Index: lams_common/db/model/lams_11.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/model/lams_11.clay,v
diff -u -r1.29 -r1.30
--- lams_common/db/model/lams_11.clay 10 Mar 2005 03:26:11 -0000 1.29
+++ lams_common/db/model/lams_11.clay 15 Mar 2005 02:54:39 -0000 1.30
@@ -303,6 +303,19 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -406,6 +419,12 @@
+
+
+
+
+
+
@@ -664,6 +683,13 @@
+
+
+
+
+
+
+
@@ -2243,8 +2269,8 @@
-
+
@@ -2458,7 +2484,7 @@
-
+
@@ -2717,8 +2743,21 @@
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -2730,11 +2769,11 @@
-
+
-
+
@@ -2756,6 +2795,19 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -2821,6 +2873,13 @@
+
+
+
+
+
+
+
@@ -3966,8 +4025,8 @@
-
+
@@ -3992,6 +4051,39 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
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.39 -r1.40
--- lams_common/db/sql/create_lams_11_tables.sql 14 Mar 2005 22:50:26 -0000 1.39
+++ lams_common/db/sql/create_lams_11_tables.sql 15 Mar 2005 02:54:38 -0000 1.40
@@ -102,6 +102,12 @@
, PRIMARY KEY (lams_workspace_folder_type_id)
)TYPE=InnoDB;
+CREATE TABLE lams_grouping_support_type (
+ grouping_support_type_id INT(3) NOT NULL
+ , description VARCHAR(64) NOT NULL
+ , PRIMARY KEY (grouping_support_type_id)
+)TYPE=InnoDB;
+
CREATE TABLE lams_authentication_method_type (
authentication_method_type_id INT(3) NOT NULL
, description VARCHAR(64) NOT NULL
@@ -228,9 +234,11 @@
, learning_library_id BIGINT(20) NOT NULL
, default_tool_content_id BIGINT(20) NOT NULL
, valid_flag TINYINT(1) NOT NULL DEFAULT 1
- , supports_grouping_flag TINYINT(1) NOT NULL DEFAULT 0
+ , grouping_support_type_id INT(3) NOT NULL
, supports_define_later_flag TINYINT(1) NOT NULL DEFAULT 0
+ , supports_run_offline_flag TINYINT(1) NOT NULL
, supports_moderation_flag TINYINT(1) NOT NULL
+ , supports_contribute_flag TINYINT(1) NOT NULL
, learner_url TEXT NOT NULL
, author_url TEXT NOT NULL
, define_later_url TEXT
@@ -244,6 +252,9 @@
, INDEX (learning_library_id)
, CONSTRAINT FK_lams_tool_1 FOREIGN KEY (learning_library_id)
REFERENCES lams_learning_library (learning_library_id)
+ , INDEX (grouping_support_type_id)
+ , CONSTRAINT FK_lams_tool_2 FOREIGN KEY (grouping_support_type_id)
+ REFERENCES lams_grouping_support_type (grouping_support_type_id)
)TYPE=InnoDB;
CREATE TABLE lams_learning_design (
@@ -268,7 +279,6 @@
, license_text TEXT
, lesson_org_id BIGINT(20)
, lesson_org_name VARCHAR(255)
- , lesson_name VARCHAR(255)
, lesson_id BIGINT(20)
, lesson_start_date_time DATETIME
, last_modified_date_time DATETIME NOT NULL
@@ -357,6 +367,7 @@
, parent_activity_id BIGINT(20)
, parent_ui_id INT(11)
, learning_activity_type_id INT(11) NOT NULL DEFAULT 0
+ , grouping_support_type_id INT(3) NOT NULL
, grouping_id BIGINT(20)
, grouping_ui_id INT(11)
, order_id INT(11)
@@ -366,6 +377,7 @@
, create_date_time DATETIME NOT NULL
, run_offline_flag TINYINT(1) NOT NULL
, offline_instructions TEXT
+ , online_instructions TEXT
, max_number_of_options INT(5)
, min_number_of_options INT(5)
, options_instructions TEXT
@@ -413,6 +425,9 @@
, INDEX (activity_category_id)
, CONSTRAINT FK_lams_learning_activity_12 FOREIGN KEY (activity_category_id)
REFERENCES lams_activity_category (activity_category_id)
+ , INDEX (grouping_support_type_id)
+ , CONSTRAINT FK_lams_learning_activity_13 FOREIGN KEY (grouping_support_type_id)
+ REFERENCES lams_grouping_support_type (grouping_support_type_id)
)TYPE=InnoDB;
CREATE TABLE lams_learner_progress (
Index: lams_common/db/sql/drop_lams_11_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/drop_lams_11_tables.sql,v
diff -u -r1.18 -r1.19
--- lams_common/db/sql/drop_lams_11_tables.sql 10 Mar 2005 03:26:11 -0000 1.18
+++ lams_common/db/sql/drop_lams_11_tables.sql 15 Mar 2005 02:54:38 -0000 1.19
@@ -1,5 +1,9 @@
# Connection: ROOT LOCAL
# Host: localhost
+# Saved: 2005-03-15 13:43:35
+#
+# Connection: ROOT LOCAL
+# Host: localhost
# Saved: 2005-03-10 14:16:48
#
# Connection: ROOT LOCAL
@@ -50,5 +54,6 @@
DROP TABLE IF EXISTS lams_cr_workspace;
DROP TABLE IF EXISTS lams_cr_credential;
DROP TABLE IF EXISTS lams_workspace_folder_type;
+DROP TABLE IF EXISTS lams_grouping_support_type;
SET FOREIGN_KEY_CHECKS=1;
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.16 -r1.17
--- lams_common/db/sql/insert_types_data.sql 13 Mar 2005 22:39:01 -0000 1.16
+++ lams_common/db/sql/insert_types_data.sql 15 Mar 2005 02:54:38 -0000 1.17
@@ -1,3 +1,7 @@
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2005-03-15 13:54:28
+#
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());
@@ -70,7 +74,11 @@
INSERT INTO lams_activity_category VALUES (4 ,'CONTENT');
INSERT INTO lams_activity_category VALUES (5 ,'SPLIT');
+INSERT INTO lams_grouping_support_type VALUES (1 ,'NONE');
+INSERT INTO lams_grouping_support_type VALUES (2 ,'OPTIONAL');
+INSERT INTO lams_grouping_support_type VALUES (3 ,'REQUIRED');
+