Index: lams_common/db/model/lams_11.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/model/lams_11.clay,v
diff -u -r1.19 -r1.20
--- lams_common/db/model/lams_11.clay 15 Feb 2005 00:12:20 -0000 1.19
+++ lams_common/db/model/lams_11.clay 15 Feb 2005 00:51:22 -0000 1.20
@@ -3132,42 +3132,29 @@
-
+
-
-
-
-
-
-
-
+
-
+
-
+
-
-
-
-
-
-
-
@@ -3179,6 +3166,13 @@
+
+
+
+
+
+
+
Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/create_lams_11_tables.sql,v
diff -u -r1.24 -r1.25
--- lams_common/db/sql/create_lams_11_tables.sql 15 Feb 2005 00:12:20 -0000 1.24
+++ lams_common/db/sql/create_lams_11_tables.sql 15 Feb 2005 00:51:22 -0000 1.25
@@ -80,12 +80,11 @@
CREATE TABLE lams_license (
license_id BIGINT(20) NOT NULL
- , license_text TEXT NOT NULL
- , license_url VARCHAR(256)
- , pciture_url VARCHAR(256)
, name VARCHAR(200) NOT NULL
, code VARCHAR(20) NOT NULL
- , defualt_license TINYINT(1) NOT NULL DEFAULT 0
+ , url VARCHAR(256)
+ , default_flag TINYINT(1) NOT NULL DEFAULT 0
+ , picture_url VARCHAR(256)
, PRIMARY KEY (license_id)
)TYPE=InnoDB;
Index: lams_common/db/sql/insert_types_data.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/insert_types_data.sql,v
diff -u -r1.8 -r1.9
--- lams_common/db/sql/insert_types_data.sql 7 Feb 2005 00:33:56 -0000 1.8
+++ lams_common/db/sql/insert_types_data.sql 15 Feb 2005 00:51:22 -0000 1.9
@@ -1,3 +1,7 @@
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2005-02-15 11:44:49
+#
INSERT INTO lams_role VALUES (1, 'SYSADMIN', 'LAMS System Adminstrator', NOW());
INSERT INTO lams_role VALUES (2, 'ADMIN', 'Organization Adminstrator', NOW());
INSERT INTO lams_role VALUES (3, 'AUTHOR', 'Authors Learning Designs', NOW());
@@ -47,6 +51,12 @@
INSERT INTO lams_lesson_state VALUES (5, 'FINISHED');
INSERT INTO lams_lesson_state VALUES (6, 'ARCHIVED');
+INSERT into lams_license VALUES ('1', 'Attribution-Noncommercial-ShareAlike', 'by-nc-sa', 'http://creativecommons.org/licenses/by-nc-sa/2.0/', 'true', '');
+INSERT into lams_license VALUES ('2', 'Other Licensing Agreement', 'other', '', '');
+INSERT into lams_license VALUES ('3', 'Attribution-No Derivatives', 'by-nd', 'http://creativecommons.org/licenses/by-nd/2.0/', '');
+INSERT into lams_license VALUES ('4', 'Attribution-Noncommercial-No Derivatives', 'by-nc-nd', 'http://creativecommons.org/licenses/by-nc-nd/2.0/', '');
+INSERT into lams_license VALUES ('5', 'Attribution-Noncommercial', 'by-nc', 'http://creativecommons.org/licenses/by-nc/2.0/', '');
+INSERT into lams_license VALUES ('6', 'Attribution-ShareAlike', 'by-sa', 'http://creativecommons.org/licenses/by-sa/2.0/', '');