Index: lams_common/db/model/lams_11.clay
===================================================================
diff -u -rca1c5a5eac11257557c3109cf5cdb20e9226b1c4 -r7d81fd4d9c51f9747fb92cb2d75e18fe1a81e9d5
--- lams_common/db/model/lams_11.clay (.../lams_11.clay) (revision ca1c5a5eac11257557c3109cf5cdb20e9226b1c4)
+++ lams_common/db/model/lams_11.clay (.../lams_11.clay) (revision 7d81fd4d9c51f9747fb92cb2d75e18fe1a81e9d5)
@@ -3132,42 +3132,29 @@
-
+
-
-
-
-
-
-
-
+
-
+
-
+
-
-
-
-
-
-
-
@@ -3179,6 +3166,13 @@
+
+
+
+
+
+
+
Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
diff -u -rca1c5a5eac11257557c3109cf5cdb20e9226b1c4 -r7d81fd4d9c51f9747fb92cb2d75e18fe1a81e9d5
--- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision ca1c5a5eac11257557c3109cf5cdb20e9226b1c4)
+++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 7d81fd4d9c51f9747fb92cb2d75e18fe1a81e9d5)
@@ -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
===================================================================
diff -u -r3ed1429e34ca4653f94fe6ba93811d9e310c4cb2 -r7d81fd4d9c51f9747fb92cb2d75e18fe1a81e9d5
--- lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision 3ed1429e34ca4653f94fe6ba93811d9e310c4cb2)
+++ lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision 7d81fd4d9c51f9747fb92cb2d75e18fe1a81e9d5)
@@ -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/', '');