Index: lams_common/db/model/lams_11.clay
===================================================================
diff -u -r214a1e8fd168d4797f028fdad3807256a6d92c5e -r73cf786468f4ffa28dda74a671297b7950e0d1f2
--- lams_common/db/model/lams_11.clay (.../lams_11.clay) (revision 214a1e8fd168d4797f028fdad3807256a6d92c5e)
+++ lams_common/db/model/lams_11.clay (.../lams_11.clay) (revision 73cf786468f4ffa28dda74a671297b7950e0d1f2)
@@ -232,6 +232,12 @@
+
+
+
+
+
+
@@ -458,6 +464,19 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -484,6 +503,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
@@ -683,11 +714,11 @@
-
+
-
+
@@ -786,11 +817,11 @@
-
+
-
+
@@ -905,6 +936,13 @@
+
+
+
+
+
+
+
@@ -1089,19 +1127,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -2505,6 +2530,19 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -2535,6 +2573,12 @@
+
+
+
+
+
+
@@ -3104,7 +3148,7 @@
-
+
@@ -3202,6 +3246,39 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
diff -u -r214a1e8fd168d4797f028fdad3807256a6d92c5e -r73cf786468f4ffa28dda74a671297b7950e0d1f2
--- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 214a1e8fd168d4797f028fdad3807256a6d92c5e)
+++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 73cf786468f4ffa28dda74a671297b7950e0d1f2)
@@ -50,11 +50,13 @@
, default_tool_content_id BIGINT(20) NOT NULL
, supports_grouping_flag TINYINT(1) NOT NULL DEFAULT 0
, supports_define_later_flag TINYINT(1) NOT NULL DEFAULT 0
+ , supports_moderation_flag TINYINT(1) NOT NULL
, learner_url TEXT NOT NULL
, author_url TEXT NOT NULL
, define_later_url TEXT
, export_portfolio_url TEXT NOT NULL
, monitor_url TEXT NOT NULL
+ , contribute_url TEXT
, UNIQUE UQ_lams_tool_sig (tool_signature)
, UNIQUE UQ_lams_tool_class_name (service_name)
, PRIMARY KEY (tool_id)
@@ -88,6 +90,12 @@
, PRIMARY KEY (license_id)
)TYPE=InnoDB;
+CREATE TABLE lams_copy_type (
+ copy_type_id TINYINT(4) NOT NULL
+ , description VARCHAR(255) NOT NULL
+ , PRIMARY KEY (copy_type_id)
+)TYPE=InnoDB;
+
CREATE TABLE lams_authentication_method_type (
authentication_method_type_id INT(3) NOT NULL
, description VARCHAR(64) NOT NULL
@@ -134,7 +142,6 @@
, learners_per_group INT(11)
, staff_group_id BIGINT(20) DEFAULT 0
, max_number_of_groups INT(3)
- , id INT(11)
, PRIMARY KEY (grouping_id)
, INDEX (grouping_type_id)
, CONSTRAINT FK_lams_learning_grouping_1 FOREIGN KEY (grouping_type_id)
@@ -201,7 +208,7 @@
CREATE TABLE lams_learning_design (
learning_design_id BIGINT(20) NOT NULL AUTO_INCREMENT
- , id INT(11)
+ , learning_design_ui_id INT(11)
, description TEXT
, title VARCHAR(255)
, first_activity_id BIGINT(20)
@@ -211,7 +218,7 @@
, date_read_only DATETIME
, user_id BIGINT(20) NOT NULL
, help_text TEXT
- , lesson_copy_flag TINYINT(4) NOT NULL DEFAULT 0
+ , copy_type_id TINYINT(4) NOT NULL
, create_date_time DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
, version VARCHAR(56)
, parent_learning_design_id BIGINT(20)
@@ -232,6 +239,9 @@
, INDEX (license_id)
, CONSTRAINT FK_lams_learning_design_5 FOREIGN KEY (license_id)
REFERENCES lams_license (license_id)
+ , INDEX (copy_type_id)
+ , CONSTRAINT FK_lams_learning_design_6 FOREIGN KEY (copy_type_id)
+ REFERENCES lams_copy_type (copy_type_id)
)TYPE=InnoDB;
CREATE INDEX idx_design_first_act ON lams_learning_design (first_activity_id ASC);
@@ -291,6 +301,7 @@
, activity_ui_id INT(11)
, description TEXT
, title VARCHAR(255)
+ , help_text TEXT
, xcoord INT(11)
, ycoord INT(11)
, parent_activity_id BIGINT(20)
@@ -310,8 +321,11 @@
, tool_id BIGINT(20)
, tool_content_id BIGINT(20)
, gate_activity_level_id INT(11)
+ , gate_open_flag TINYINT(1)
, gate_start_time_offset BIGINT(38)
, gate_end_time_offset BIGINT(38)
+ , gate_start_date_time DATETIME
+ , gate_end_date_time DATETIME
, library_activity_ui_image VARCHAR(255)
, create_grouping_id BIGINT(20)
, create_grouping_ui_id INT(11)
Index: lams_common/db/sql/drop_lams_11_tables.sql
===================================================================
diff -u -ra9fe4d83bdf4fb9bfc4924b0469c8836de992576 -r73cf786468f4ffa28dda74a671297b7950e0d1f2
--- lams_common/db/sql/drop_lams_11_tables.sql (.../drop_lams_11_tables.sql) (revision a9fe4d83bdf4fb9bfc4924b0469c8836de992576)
+++ lams_common/db/sql/drop_lams_11_tables.sql (.../drop_lams_11_tables.sql) (revision 73cf786468f4ffa28dda74a671297b7950e0d1f2)
@@ -1,3 +1,7 @@
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2005-02-16 16:04:11
+#
SET FOREIGN_KEY_CHECKS=0;
# Connection: ROOT LOCAL
@@ -37,5 +41,6 @@
DROP TABLE IF EXISTS lams_grouping_type;
DROP TABLE IF EXISTS lams_gate_activity_level;
DROP TABLE IF EXISTS lams_license;
+DROP TABLE IF EXISTS lams_copy_type;
SET FOREIGN_KEY_CHECKS=1;
Index: lams_common/db/sql/insert_types_data.sql
===================================================================
diff -u -r7d81fd4d9c51f9747fb92cb2d75e18fe1a81e9d5 -r73cf786468f4ffa28dda74a671297b7950e0d1f2
--- lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision 7d81fd4d9c51f9747fb92cb2d75e18fe1a81e9d5)
+++ lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision 73cf786468f4ffa28dda74a671297b7950e0d1f2)
@@ -1,5 +1,9 @@
# Connection: ROOT LOCAL
# Host: localhost
+# Saved: 2005-02-16 16:03:41
+#
+# Connection: ROOT LOCAL
+# Host: localhost
# Saved: 2005-02-15 11:44:49
#
INSERT INTO lams_role VALUES (1, 'SYSADMIN', 'LAMS System Adminstrator', NOW());
@@ -58,7 +62,12 @@
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/', '');
+INSERT into lams_copy_type VALUES ('1', 'NONE');
+INSERT into lams_copy_type VALUES ('2', 'LESSON COPY');
+INSERT into lams_copy_type VALUES ('3', 'PREVIEW COPY');
+
+