Index: lams_common/db/model/lams_11.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/model/lams_11.clay,v
diff -u -r1.25 -r1.26
--- lams_common/db/model/lams_11.clay 25 Feb 2005 00:16:33 -0000 1.25
+++ lams_common/db/model/lams_11.clay 27 Feb 2005 23:47:37 -0000 1.26
@@ -464,6 +464,19 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -644,6 +657,13 @@
+
+
+
+
+
+
+
@@ -2367,8 +2387,8 @@
-
+
@@ -3305,6 +3325,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.30 -r1.31
--- lams_common/db/sql/create_lams_11_tables.sql 25 Feb 2005 00:16:33 -0000 1.30
+++ lams_common/db/sql/create_lams_11_tables.sql 27 Feb 2005 23:47:37 -0000 1.31
@@ -96,6 +96,12 @@
, PRIMARY KEY (copy_type_id)
)TYPE=InnoDB;
+CREATE TABLE lams_activity_category (
+ activity_category_id INT(3) NOT NULL
+ , description VARCHAR(255) NOT NULL
+ , PRIMARY KEY (activity_category_id)
+)TYPE=InnoDB;
+
CREATE TABLE lams_authentication_method_type (
authentication_method_type_id INT(3) NOT NULL
, description VARCHAR(64) NOT NULL
@@ -299,6 +305,7 @@
CREATE TABLE lams_learning_activity (
activity_id BIGINT(20) NOT NULL AUTO_INCREMENT
, activity_ui_id INT(11)
+ , activity_category_id INT(3) NOT NULL
, description TEXT
, title VARCHAR(255)
, help_text TEXT
@@ -359,6 +366,9 @@
, INDEX (library_activity_id)
, CONSTRAINT FK_lams_learning_activity_11 FOREIGN KEY (library_activity_id)
REFERENCES lams_learning_activity (activity_id)
+ , INDEX (activity_category_id)
+ , CONSTRAINT FK_lams_learning_activity_12 FOREIGN KEY (activity_category_id)
+ REFERENCES lams_activity_category (activity_category_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.15 -r1.16
--- lams_common/db/sql/drop_lams_11_tables.sql 16 Feb 2005 22:17:08 -0000 1.15
+++ lams_common/db/sql/drop_lams_11_tables.sql 27 Feb 2005 23:47:37 -0000 1.16
@@ -38,5 +38,6 @@
DROP TABLE IF EXISTS lams_gate_activity_level;
DROP TABLE IF EXISTS lams_license;
DROP TABLE IF EXISTS lams_copy_type;
+DROP TABLE IF EXISTS lams_activity_category;
SET FOREIGN_KEY_CHECKS=1;
Index: lams_common/db/sql/insert_test_data.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/insert_test_data.sql,v
diff -u -r1.25 -r1.26
--- lams_common/db/sql/insert_test_data.sql 24 Feb 2005 06:42:49 -0000 1.25
+++ lams_common/db/sql/insert_test_data.sql 27 Feb 2005 23:52:19 -0000 1.26
@@ -36,8 +36,15 @@
INSERT INTO lams_authentication_method VALUES (2, 2, 'Oxford-WebAuth');
INSERT INTO lams_authentication_method VALUES (3, 3, 'MQ-LDAP');
+INSERT INTO lams_activity_category VALUES (1 ,'SYSTEM');
+INSERT INTO lams_activity_category VALUES (1 ,'COLLABORATION');
+INSERT INTO lams_activity_category VALUES (1 ,'ASSESSMENT');
+INSERT INTO lams_activity_category VALUES (1 ,'CONTENT');
+INSERT INTO lams_activity_category VALUES (1 ,'SPLIT');
+
insert into lams_workspace_folder (parent_folder_id,name,workspace_id) values(null,'Trial',1);
+
-- Populates the lams_learning_library table with default libraries
insert into lams_learning_library (learning_library_id,description,title,create_date_time) values (1,'Notebook','Notebook','20050207');