Index: lams_common/db/model/lams_11.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/model/lams_11.clay,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ lams_common/db/model/lams_11.clay 23 Nov 2004 05:32:21 -0000 1.1
@@ -0,0 +1,2140 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: lams_common/db/model/learning_design.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/model/Attic/learning_design.clay,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ lams_common/db/model/learning_design.clay 23 Nov 2004 05:32:21 -0000 1.1
@@ -0,0 +1,788 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: lams_common/db/model/user_management.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/model/Attic/user_management.clay,v
diff -u -r1.2 -r1.3
--- lams_common/db/model/user_management.clay 17 Nov 2004 00:43:01 -0000 1.2
+++ lams_common/db/model/user_management.clay 23 Nov 2004 05:32:21 -0000 1.3
@@ -240,7 +240,12 @@
-
+
+
+
+
+
+
@@ -477,19 +482,31 @@
-
+
+
+
+
+
+
+
+
-
+
+
+
+
+
+
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
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ lams_common/db/sql/create_lams_11_tables.sql 23 Nov 2004 05:32:21 -0000 1.1
@@ -0,0 +1,328 @@
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2004-11-23 15:13:48
+#
+CREATE TABLE lams_gate_activity_level (
+ gate_activity_level_id INT(11) NOT NULL DEFAULT 0
+ , description VARCHAR(128) NOT NULL
+ , PRIMARY KEY (gate_activity_level_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_grouping_type (
+ grouping_type_id INT(11) NOT NULL DEFAULT 0
+ , description VARCHAR(128) NOT NULL
+ , PRIMARY KEY (grouping_type_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_learning_activity_type (
+ learning_activity_type_id INT(11) NOT NULL DEFAULT 0
+ , description VARCHAR(255) NOT NULL
+ , PRIMARY KEY (learning_activity_type_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_learning_library (
+ learning_library_id BIGINT(20) NOT NULL DEFAULT 0
+ , description TEXT
+ , title VARCHAR(255)
+ , create_date_time DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
+ , PRIMARY KEY (learning_library_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_organisation_type (
+ organisation_type_id INT(3) NOT NULL DEFAULT 0
+ , name VARCHAR(64) NOT NULL
+ , description VARCHAR(255) NOT NULL
+ , PRIMARY KEY (organisation_type_id)
+)TYPE=InnoDB;
+CREATE UNIQUE INDEX UQ_lams_organisation_type_name ON lams_organisation_type (name ASC);
+
+CREATE TABLE lams_role (
+ role_id INT(6) NOT NULL DEFAULT 0
+ , name VARCHAR(64) NOT NULL
+ , description TEXT
+ , create_date BIGINT(20)
+ , PRIMARY KEY (role_id)
+)TYPE=InnoDB;
+CREATE INDEX gname ON lams_role (name ASC);
+
+CREATE TABLE lams_authentication_method_type (
+ authentication_method_type_id INT(3) NOT NULL DEFAULT 0
+ , description VARCHAR(64) NOT NULL
+ , PRIMARY KEY (authentication_method_type_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_authentication_method (
+ authentication_method_id BIGINT(20) NOT NULL DEFAULT 0
+ , authentication_method_type_id INT(3) NOT NULL DEFAULT 0
+ , PRIMARY KEY (authentication_method_id)
+ , INDEX (authentication_method_type_id)
+ , CONSTRAINT FK_lams_authorization_method_1 FOREIGN KEY (authentication_method_type_id)
+ REFERENCES lams_authentication_method_type (authentication_method_type_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
+CREATE TABLE lams_workspace_folder (
+ workspace_folder_id BIGINT(20) NOT NULL DEFAULT 0
+ , parent_folder_id BIGINT(20)
+ , name VARCHAR(64) NOT NULL
+ , workspace_id BIGINT(20) NOT NULL DEFAULT 0
+ , PRIMARY KEY (workspace_folder_id)
+ , INDEX (parent_folder_id)
+ , CONSTRAINT FK_lams_workspace_folder_2 FOREIGN KEY (parent_folder_id)
+ REFERENCES lams_workspace_folder (workspace_folder_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
+CREATE TABLE lams_workspace (
+ workspace_id BIGINT(20) NOT NULL DEFAULT 0
+ , root_folder_id BIGINT(20) NOT NULL DEFAULT 0
+ , PRIMARY KEY (workspace_id)
+ , INDEX (root_folder_id)
+ , CONSTRAINT FK_lams_workspace_1 FOREIGN KEY (root_folder_id)
+ REFERENCES lams_workspace_folder (workspace_folder_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
+CREATE TABLE lams_user (
+ user_id BIGINT(20) NOT NULL DEFAULT 0
+ , login VARCHAR(20) NOT NULL
+ , password VARCHAR(50) NOT NULL
+ , title VARCHAR(32)
+ , first_name VARCHAR(64)
+ , last_name VARCHAR(128)
+ , address_line_1 VARCHAR(64)
+ , address_line_2 VARCHAR(64)
+ , address_line_3 VARCHAR(64)
+ , city VARCHAR(64)
+ , state VARCHAR(64)
+ , country VARCHAR(64)
+ , day_phone VARCHAR(64)
+ , evening_phone VARCHAR(64)
+ , mobile_phone VARCHAR(64)
+ , fax VARCHAR(64)
+ , email VARCHAR(128)
+ , disabled_flag TINYINT(1) NOT NULL DEFAULT 0
+ , create_date DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
+ , authentication_method_id BIGINT(20) NOT NULL DEFAULT 0
+ , workspace_id BIGINT(20)
+ , PRIMARY KEY (user_id)
+ , INDEX (authentication_method_id)
+ , CONSTRAINT FK_lams_user_1 FOREIGN KEY (authentication_method_id)
+ REFERENCES lams_authentication_method (authentication_method_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (workspace_id)
+ , CONSTRAINT FK_lams_user_2 FOREIGN KEY (workspace_id)
+ REFERENCES lams_workspace (workspace_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+CREATE UNIQUE INDEX UQ_lams_user_login ON lams_user (login ASC);
+CREATE INDEX login ON lams_user (login ASC);
+
+CREATE TABLE lams_learning_design (
+ learning_design_id BIGINT(20) NOT NULL DEFAULT 0
+ , id INT(11)
+ , description TEXT
+ , title VARCHAR(255)
+ , first_activity_id BIGINT(20)
+ , max_id INT(11)
+ , object_type VARCHAR(255)
+ , valid_design_flag TINYINT(4)
+ , read_only_flag TINYINT(4)
+ , date_read_only DATETIME
+ , read_access BIGINT(20)
+ , write_access BIGINT(20)
+ , user_id BIGINT(20) NOT NULL
+ , help_text TEXT
+ , lesson_copy_flag TINYINT(4) NOT NULL DEFAULT 0
+ , create_date_time DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
+ , version VARCHAR(56) NOT NULL
+ , parent_learning_design_id BIGINT(20)
+ , open_date_time DATETIME
+ , close_date_time DATETIME
+ , PRIMARY KEY (learning_design_id)
+ , INDEX (parent_learning_design_id)
+ , CONSTRAINT FK_lams_learning_design_2 FOREIGN KEY (parent_learning_design_id)
+ REFERENCES lams_learning_design (learning_design_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (user_id)
+ , CONSTRAINT FK_lams_learning_design_3 FOREIGN KEY (user_id)
+ REFERENCES lams_user (user_id)
+)TYPE=InnoDB;
+CREATE INDEX idx_design_first_act ON lams_learning_design (first_activity_id ASC);
+
+CREATE TABLE lams_learning_grouping (
+ learning_grouping_id BIGINT(20) NOT NULL DEFAULT 0
+ , grouping_type_id INT(11) NOT NULL DEFAULT 0
+ , number_of_groups INT(11)
+ , learners_per_group INT(11)
+ , PRIMARY KEY (learning_grouping_id)
+ , INDEX (grouping_type_id)
+ , CONSTRAINT FK_lams_learning_grouping_1 FOREIGN KEY (grouping_type_id)
+ REFERENCES lams_grouping_type (grouping_type_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
+CREATE TABLE lams_organisation (
+ organisation_id BIGINT(20) NOT NULL DEFAULT 0
+ , name VARCHAR(250)
+ , description VARCHAR(250)
+ , parent_organisation_id BIGINT(20)
+ , organisation_type_id INT(3) NOT NULL DEFAULT 0
+ , create_date DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
+ , workspace_id BIGINT(20)
+ , PRIMARY KEY (organisation_id)
+ , INDEX (organisation_type_id)
+ , CONSTRAINT FK_lams_organisation_1 FOREIGN KEY (organisation_type_id)
+ REFERENCES lams_organisation_type (organisation_type_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (workspace_id)
+ , CONSTRAINT FK_lams_organisation_2 FOREIGN KEY (workspace_id)
+ REFERENCES lams_workspace (workspace_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (parent_organisation_id)
+ , CONSTRAINT FK_lams_organisation_3 FOREIGN KEY (parent_organisation_id)
+ REFERENCES lams_organisation (organisation_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
+
+
+CREATE TABLE lams_learning_activity (
+ activity_id BIGINT(20) NOT NULL DEFAULT 0
+ , id INT(11)
+ , description TEXT
+ , title VARCHAR(255)
+ , xcoord INT(11)
+ , ycoord INT(11)
+ , parent_activity_id BIGINT(20)
+ , learning_activity_type_id INT(11) NOT NULL DEFAULT 0
+ , learning_grouping_id BIGINT(20)
+ , order_id INT(11)
+ , define_later_flag TINYINT(4) NOT NULL DEFAULT 0
+ , learning_design_id BIGINT(20) DEFAULT 0
+ , learning_library_id BIGINT(20) DEFAULT 0
+ , create_date_time DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
+ , offline_instructions TEXT
+ , PRIMARY KEY (activity_id)
+ , INDEX (learning_library_id)
+ , CONSTRAINT FK_lams_learning_activity_7 FOREIGN KEY (learning_library_id)
+ REFERENCES lams_learning_library (learning_library_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (learning_design_id)
+ , CONSTRAINT FK_lams_learning_activity_6 FOREIGN KEY (learning_design_id)
+ REFERENCES lams_learning_design (learning_design_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (parent_activity_id)
+ , CONSTRAINT FK_learning_activity_2 FOREIGN KEY (parent_activity_id)
+ REFERENCES lams_learning_activity (activity_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (learning_activity_type_id)
+ , CONSTRAINT FK_learning_activity_3 FOREIGN KEY (learning_activity_type_id)
+ REFERENCES lams_learning_activity_type (learning_activity_type_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (learning_grouping_id)
+ , CONSTRAINT FK_learning_activity_6 FOREIGN KEY (learning_grouping_id)
+ REFERENCES lams_learning_grouping (learning_grouping_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
+CREATE TABLE lams_user_organisation (
+ user_organisation_id BIGINT(20) NOT NULL DEFAULT 0
+ , organisation_id BIGINT(20) NOT NULL DEFAULT 0
+ , user_id BIGINT(20) NOT NULL DEFAULT 0
+ , PRIMARY KEY (user_organisation_id)
+ , INDEX (user_id)
+ , CONSTRAINT u_user_organisation_ibfk_1 FOREIGN KEY (user_id)
+ REFERENCES lams_user (user_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (organisation_id)
+ , CONSTRAINT u_user_organisation_ibfk_2 FOREIGN KEY (organisation_id)
+ REFERENCES lams_organisation (organisation_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
+CREATE TABLE lams_learning_gate_activity (
+ activity_id BIGINT(20) NOT NULL DEFAULT 0
+ , start_date_time DATETIME
+ , end_date_time DATETIME
+ , gate_activity_level_id INT(11) NOT NULL DEFAULT 0
+ , PRIMARY KEY (activity_id)
+ , INDEX (gate_activity_level_id)
+ , CONSTRAINT FK_lams_learning_gate_activity_2 FOREIGN KEY (gate_activity_level_id)
+ REFERENCES lams_gate_activity_level (gate_activity_level_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (activity_id)
+ , CONSTRAINT FK_lams_learning_gate_activity_1 FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
+CREATE TABLE lams_learning_group (
+ learning_group_id BIGINT(20) NOT NULL DEFAULT 0
+ , learning_grouping_id BIGINT(20) NOT NULL DEFAULT 0
+ , PRIMARY KEY (learning_group_id)
+ , INDEX (learning_grouping_id)
+ , CONSTRAINT FK_lams_learning_group_1 FOREIGN KEY (learning_grouping_id)
+ REFERENCES lams_learning_grouping (learning_grouping_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
+CREATE TABLE lams_learning_grouping_activity (
+ activity_id BIGINT(20) NOT NULL DEFAULT 0
+ , learning_grouping_id BIGINT(20) NOT NULL DEFAULT 0
+ , PRIMARY KEY (activity_id)
+ , INDEX (learning_grouping_id)
+ , CONSTRAINT FK_lams_learning_grouping_activity_2 FOREIGN KEY (learning_grouping_id)
+ REFERENCES lams_learning_grouping (learning_grouping_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (activity_id)
+ , CONSTRAINT FK_lams_learning_grouping_activity_1 FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
+CREATE TABLE lams_learning_options_activity (
+ activity_id BIGINT(20) NOT NULL DEFAULT 0
+ , min_number_of_options INT(11)
+ , max_number_of_options INT(11)
+ , PRIMARY KEY (activity_id)
+ , INDEX (activity_id)
+ , CONSTRAINT FK_lams_learning_options_activity_1 FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
+CREATE TABLE lams_learning_tool_activity (
+ activity_id BIGINT(20) NOT NULL DEFAULT 0
+ , tool_id BIGINT(20) NOT NULL DEFAULT 0
+ , tool_content_id BIGINT(20)
+ , PRIMARY KEY (activity_id)
+ , INDEX (activity_id)
+ , CONSTRAINT FK_lams_learning_tool_activity_1 FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+CREATE INDEX idx_toole_act_tool ON lams_learning_tool_activity (tool_id ASC);
+CREATE INDEX idx_toole_act_tool_content ON lams_learning_tool_activity (tool_content_id ASC);
+
+CREATE TABLE lams_learning_transition (
+ transition_id BIGINT(20) NOT NULL DEFAULT 0
+ , id INT(11)
+ , description TEXT
+ , title VARCHAR(255)
+ , to_activity_id BIGINT(20) NOT NULL DEFAULT 0
+ , from_activity_id BIGINT(20) NOT NULL DEFAULT 0
+ , learning_design_id BIGINT(20) NOT NULL DEFAULT 0
+ , create_date_time DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
+ , PRIMARY KEY (transition_id)
+ , INDEX (from_activity_id)
+ , CONSTRAINT FK_learning_transition_3 FOREIGN KEY (from_activity_id)
+ REFERENCES lams_learning_activity (activity_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (to_activity_id)
+ , CONSTRAINT FK_learning_transition_2 FOREIGN KEY (to_activity_id)
+ REFERENCES lams_learning_activity (activity_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (learning_design_id)
+ , CONSTRAINT lddefn_transition_ibfk_1 FOREIGN KEY (learning_design_id)
+ REFERENCES lams_learning_design (learning_design_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
+CREATE TABLE lams_user_organisation_role (
+ user_organisation_role_id BIGINT(20) NOT NULL DEFAULT 0
+ , user_organisation_id BIGINT(20) NOT NULL DEFAULT 0
+ , role_id INT(6) NOT NULL DEFAULT 0
+ , PRIMARY KEY (user_organisation_role_id)
+ , INDEX (role_id)
+ , CONSTRAINT FK_lams_user_organisation_role_2 FOREIGN KEY (role_id)
+ REFERENCES lams_role (role_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (user_organisation_id)
+ , CONSTRAINT FK_lams_user_organisation_role_3 FOREIGN KEY (user_organisation_id)
+ REFERENCES lams_user_organisation (user_organisation_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
+CREATE TABLE lams_authentication_method_parameter (
+ authentication_parameter_id BIGINT(20) NOT NULL DEFAULT 0
+ , authentication_method_id BIGINT(20) NOT NULL DEFAULT 0
+ , name VARCHAR(128) NOT NULL
+ , value VARCHAR(255)
+ , PRIMARY KEY (authentication_parameter_id)
+ , INDEX (authentication_method_id)
+ , CONSTRAINT FK_lams_authorization_method_parameter_1 FOREIGN KEY (authentication_method_id)
+ REFERENCES lams_authentication_method (authentication_method_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
Index: lams_common/db/sql/create_learning_design_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/create_learning_design_tables.sql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ lams_common/db/sql/create_learning_design_tables.sql 23 Nov 2004 05:32:21 -0000 1.1
@@ -0,0 +1,270 @@
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2004-11-22 15:34:31
+#
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2004-11-22 15:21:41
+#
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2004-11-22 14:57:54
+#
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2004-11-22 13:18:58
+#
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2004-11-22 11:59:03
+#
+-- Tables are not sorted because:
+-- Circular dependency between table DEFAULT_SCHEMA.lams_learning_activity and table DEFAULT_SCHEMA.lams_learning_design: both have foreign keys that reference the other table.
+-- Try generating Foreign Keys with ALTER TABLE statements.
+CREATE TABLE lams_learning_activity (
+ activity_id BIGINT DEFAULT '0' NOT NULL
+ , id INT
+ , description TEXT
+ , title VARCHAR(255)
+ , xcoord INT
+ , ycoord INT
+ , parent_activity_id BIGINT
+ , learning_activity_type_id INT NOT NULL
+ , learning_grouping_id BIGINT
+ , order_id INT
+ , define_later_flag TINYINT DEFAULT '0' NOT NULL
+ , learning_design_id BIGINT DEFAULT '0'
+ , learning_library_id BIGINT DEFAULT '0'
+ , create_date_time DATETIME NOT NULL
+ , PRIMARY KEY (activity_id)
+)TYPE=InnoDB;
+CREATE INDEX idx_activity_library_id ON lams_learning_activity (learning_library_id);
+CREATE INDEX idx_activity_design_id ON lams_learning_activity (learning_design_id);
+CREATE INDEX idx_activity_grouping_id ON lams_learning_activity (learning_grouping_id);
+CREATE INDEX idx_activity_activity_type_id ON lams_learning_activity (learning_activity_type_id);
+CREATE INDEX idx_activity_parent_id ON lams_learning_activity (parent_activity_id);
+
+
+CREATE TABLE lams_learning_design (
+ learning_design_id BIGINT DEFAULT '0' NOT NULL
+ , id INT
+ , description TEXT
+ , title VARCHAR(255)
+ , first_activity_id BIGINT
+ , max_id INT
+ , object_type VARCHAR(255)
+ , valid_design_flag TINYINT
+ , read_only_flag TINYINT
+ , date_read_only DATETIME
+ , read_access BIGINT
+ , write_access BIGINT
+ , owning_user_id BIGINT
+ , help_text TEXT
+ , lesson_copy_flag TINYINT DEFAULT '0' NOT NULL
+ , create_date_time DATETIME NOT NULL
+ , version VARCHAR(56) NOT NULL
+ , parent_learning_design_id BIGINT
+ , open_date_time DATETIME
+ , close_date_time DATETIME
+ , PRIMARY KEY (learning_design_id)
+)TYPE=InnoDB;
+CREATE INDEX idx_design_parent_id ON lams_learning_design (parent_learning_design_id);
+CREATE INDEX idx_design_user_id ON lams_learning_design (owning_user_id);
+CREATE INDEX idx_design_first_act ON lams_learning_design (first_activity_id);
+
+CREATE TABLE lams_learning_library (
+ learning_library_id BIGINT DEFAULT '0' NOT NULL
+ , description TEXT
+ , title VARCHAR(255)
+ , create_date_time DATETIME NOT NULL
+ , PRIMARY KEY (learning_library_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_learning_transition (
+ transition_id BIGINT DEFAULT '0' NOT NULL
+ , id INT
+ , description TEXT
+ , title VARCHAR(255)
+ , to_activity_id BIGINT NOT NULL
+ , from_activity_id BIGINT NOT NULL
+ , learning_design_id BIGINT NOT NULL
+ , create_date_time DATETIME NOT NULL
+ , PRIMARY KEY (transition_id)
+)TYPE=InnoDB;
+CREATE INDEX ldId ON lams_learning_transition (learning_design_id);
+CREATE INDEX idx_transition_to_activity ON lams_learning_transition (to_activity_id);
+CREATE INDEX idx_transition_from_activity ON lams_learning_transition (from_activity_id);
+
+
+CREATE TABLE lams_learning_grouping (
+ learning_grouping_id BIGINT NOT NULL
+ , grouping_type_id INT NOT NULL
+ , number_of_groups INT
+ , learners_per_group INT
+ , PRIMARY KEY (learning_grouping_id)
+)TYPE=InnoDB;
+CREATE INDEX idx_grouping_grouping_type ON lams_learning_grouping (grouping_type_id);
+
+CREATE TABLE lams_learning_group (
+ learning_group_id BIGINT NOT NULL
+ , learning_grouping_id BIGINT NOT NULL
+ , PRIMARY KEY (learning_group_id)
+)TYPE=InnoDB;
+CREATE INDEX idx_group_grouping ON lams_learning_group (learning_grouping_id);
+
+CREATE TABLE lams_learning_activity_type (
+ learning_activity_type_id INT NOT NULL
+ , description VARCHAR(255) NOT NULL
+ , PRIMARY KEY (learning_activity_type_id)
+)TYPE=InnoDB;
+
+
+
+CREATE TABLE lams_learning_tool_activity (
+ activity_id BIGINT DEFAULT '0' NOT NULL
+ , tool_id BIGINT NOT NULL
+ , tool_content_id BIGINT
+ , PRIMARY KEY (activity_id)
+)TYPE=InnoDB;
+CREATE INDEX idx_toole_act_activity ON lams_learning_tool_activity (activity_id);
+CREATE INDEX idx_toole_act_tool ON lams_learning_tool_activity (tool_id);
+CREATE INDEX idx_toole_act_tool_content ON lams_learning_tool_activity (tool_content_id);
+
+CREATE TABLE lams_learning_gate_activity (
+ activity_id BIGINT DEFAULT '0' NOT NULL
+ , start_date_time DATETIME
+ , end_date_time DATETIME
+ , gate_activity_level_id INT NOT NULL
+ , PRIMARY KEY (activity_id)
+)TYPE=InnoDB;
+CREATE INDEX idx_gate_act_activity ON lams_learning_gate_activity (activity_id);
+CREATE INDEX idx_gate_act_level ON lams_learning_gate_activity (gate_activity_level_id);
+
+CREATE TABLE lams_grouping_type (
+ grouping_type_id INT NOT NULL
+ , description VARCHAR(128) NOT NULL
+ , PRIMARY KEY (grouping_type_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_gate_activity_level (
+ gate_activity_level_id INT NOT NULL
+ , description VARCHAR(128) NOT NULL
+ , PRIMARY KEY (gate_activity_level_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_learning_options_activity (
+ activity_id BIGINT DEFAULT '0' NOT NULL
+ , min_number_of_options INT
+ , max_number_of_options INT
+ , PRIMARY KEY (activity_id)
+)TYPE=InnoDB;
+CREATE INDEX idx_options_act_activity ON lams_learning_options_activity (activity_id);
+
+CREATE TABLE lams_learning_grouping_activity (
+ activity_id BIGINT DEFAULT '0' NOT NULL
+ , learning_grouping_id BIGINT NOT NULL
+ , PRIMARY KEY (activity_id)
+)TYPE=InnoDB;
+CREATE INDEX idx_grouping_act_activity ON lams_learning_grouping_activity (activity_id);
+CREATE INDEX idx_grouping_act_grouping ON lams_learning_grouping_activity (learning_grouping_id);
+
+ALTER TABLE lams_learning_activity
+ ADD CONSTRAINT FK_learning_activity_2
+ FOREIGN KEY (parent_activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_activity
+ ADD CONSTRAINT FK_learning_activity_3
+ FOREIGN KEY (learning_activity_type_id)
+ REFERENCES lams_learning_activity_type (learning_activity_type_id);
+
+ALTER TABLE lams_learning_activity
+ ADD CONSTRAINT FK_learning_activity_4
+ FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_activity
+ ADD CONSTRAINT FK_learning_activity_5
+ FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_activity
+ ADD CONSTRAINT FK_learning_activity_6
+ FOREIGN KEY (learning_grouping_id)
+ REFERENCES lams_learning_grouping (learning_grouping_id);
+
+ALTER TABLE lams_learning_activity
+ ADD CONSTRAINT FK_lams_learning_activity_6
+ FOREIGN KEY (learning_design_id)
+ REFERENCES lams_learning_design (learning_design_id);
+
+ALTER TABLE lams_learning_activity
+ ADD CONSTRAINT FK_lams_learning_activity_7
+ FOREIGN KEY (learning_library_id)
+ REFERENCES lams_learning_library (learning_library_id);
+
+ALTER TABLE lams_learning_design
+ ADD CONSTRAINT FK_lams_learning_design_1
+ FOREIGN KEY (first_activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_design
+ ADD CONSTRAINT FK_lams_learning_design_2
+ FOREIGN KEY (parent_learning_design_id)
+ REFERENCES lams_learning_design (learning_design_id);
+
+ALTER TABLE lams_learning_transition
+ ADD CONSTRAINT lddefn_transition_ibfk_1
+ FOREIGN KEY (learning_design_id)
+ REFERENCES lams_learning_design (learning_design_id);
+
+ALTER TABLE lams_learning_transition
+ ADD CONSTRAINT FK_learning_transition_2
+ FOREIGN KEY (to_activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_transition
+ ADD CONSTRAINT FK_learning_transition_3
+ FOREIGN KEY (from_activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_grouping
+ ADD CONSTRAINT FK_lams_learning_grouping_1
+ FOREIGN KEY (grouping_type_id)
+ REFERENCES lams_grouping_type (grouping_type_id);
+
+ALTER TABLE lams_learning_group
+ ADD CONSTRAINT FK_lams_learning_group_1
+ FOREIGN KEY (learning_grouping_id)
+ REFERENCES lams_learning_grouping (learning_grouping_id);
+
+ALTER TABLE lams_learning_tool_activity
+ ADD CONSTRAINT FK_lams_learning_tool_activity_1
+ FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_gate_activity
+ ADD CONSTRAINT FK_lams_learning_gate_activity_1
+ FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_gate_activity
+ ADD CONSTRAINT FK_lams_learning_gate_activity_2
+ FOREIGN KEY (gate_activity_level_id)
+ REFERENCES lams_gate_activity_level (gate_activity_level_id);
+
+ALTER TABLE lams_learning_options_activity
+ ADD CONSTRAINT FK_lams_learning_options_activity_1
+ FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_grouping_activity
+ ADD CONSTRAINT FK_lams_learning_grouping_activity_1
+ FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_grouping_activity
+ ADD CONSTRAINT FK_lams_learning_grouping_activity_2
+ FOREIGN KEY (learning_grouping_id)
+ REFERENCES lams_learning_grouping (learning_grouping_id);
+
Index: lams_common/db/sql/create_user_management_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/create_user_management_tables.sql,v
diff -u -r1.2 -r1.3
--- lams_common/db/sql/create_user_management_tables.sql 17 Nov 2004 00:43:01 -0000 1.2
+++ lams_common/db/sql/create_user_management_tables.sql 23 Nov 2004 05:32:21 -0000 1.3
@@ -1,6 +1,8 @@
CREATE TABLE lams_organisation_type (
organisation_type_id INT(3) NOT NULL
- , description VARCHAR(64) NOT NULL
+ , name VARCHAR(64) NOT NULL
+ , description VARCHAR(255) NOT NULL
+ , UNIQUE UQ_lams_organisation_type_name (name)
, PRIMARY KEY (organisation_type_id)
)TYPE=InnoDB;
@@ -70,6 +72,7 @@
, create_date DATETIME NOT NULL
, authentication_method_id INT(11) NOT NULL
, workspace_id INT(11)
+ , UNIQUE UQ_lams_user_login (login)
, PRIMARY KEY (user_id)
, INDEX (authentication_method_id)
, CONSTRAINT FK_lams_user_1 FOREIGN KEY (authentication_method_id)
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
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ lams_common/db/sql/drop_lams_11_tables.sql 23 Nov 2004 05:32:21 -0000 1.1
@@ -0,0 +1,112 @@
+DROP INDEX PRIMARY ON lams_gate_activity_level;
+DROP INDEX PRIMARY ON lams_grouping_type;
+DROP INDEX PRIMARY ON lams_learning_activity_type;
+DROP INDEX PRIMARY ON lams_learning_library;
+DROP INDEX PRIMARY ON lams_organisation_type;
+DROP INDEX UQ_lams_organisation_type_name ON lams_organisation_type;
+DROP INDEX PRIMARY ON lams_role;
+DROP INDEX gname ON lams_role;
+DROP INDEX PRIMARY ON lams_authentication_method_type;
+DROP INDEX PRIMARY ON lams_authentication_method;
+DROP INDEX authentication_method_type_id ON lams_authentication_method;
+DROP INDEX PRIMARY ON lams_workspace_folder;
+DROP INDEX parent_folder_id ON lams_workspace_folder;
+DROP INDEX PRIMARY ON lams_workspace;
+DROP INDEX root_folder_id ON lams_workspace;
+DROP INDEX PRIMARY ON lams_learning_design;
+DROP INDEX idx_design_parent_id ON lams_learning_design;
+DROP INDEX idx_design_user_id ON lams_learning_design;
+DROP INDEX idx_design_first_act ON lams_learning_design;
+DROP INDEX PRIMARY ON lams_learning_grouping;
+DROP INDEX idx_grouping_grouping_type ON lams_learning_grouping;
+DROP INDEX PRIMARY ON lams_organisation;
+DROP INDEX organisation_type_id ON lams_organisation;
+DROP INDEX workspace_id ON lams_organisation;
+DROP INDEX parent_organisation_id ON lams_organisation;
+DROP INDEX PRIMARY ON lams_user;
+DROP INDEX UQ_lams_user_login ON lams_user;
+DROP INDEX authentication_method_id ON lams_user;
+DROP INDEX workspace_id ON lams_user;
+DROP INDEX login ON lams_user;
+DROP INDEX PRIMARY ON lams_learning_activity;
+DROP INDEX idx_activity_library_id ON lams_learning_activity;
+DROP INDEX idx_activity_design_id ON lams_learning_activity;
+DROP INDEX idx_activity_grouping_id ON lams_learning_activity;
+DROP INDEX idx_activity_activity_type_id ON lams_learning_activity;
+DROP INDEX idx_activity_parent_id ON lams_learning_activity;
+DROP INDEX PRIMARY ON lams_user_organisation;
+DROP INDEX user_id ON lams_user_organisation;
+DROP INDEX organisation_id ON lams_user_organisation;
+DROP INDEX PRIMARY ON lams_learning_gate_activity;
+DROP INDEX idx_gate_act_activity ON lams_learning_gate_activity;
+DROP INDEX idx_gate_act_level ON lams_learning_gate_activity;
+DROP INDEX PRIMARY ON lams_learning_group;
+DROP INDEX idx_group_grouping ON lams_learning_group;
+DROP INDEX PRIMARY ON lams_learning_grouping_activity;
+DROP INDEX idx_grouping_act_activity ON lams_learning_grouping_activity;
+DROP INDEX idx_grouping_act_grouping ON lams_learning_grouping_activity;
+DROP INDEX PRIMARY ON lams_learning_options_activity;
+DROP INDEX idx_options_act_activity ON lams_learning_options_activity;
+DROP INDEX PRIMARY ON lams_learning_tool_activity;
+DROP INDEX idx_toole_act_activity ON lams_learning_tool_activity;
+DROP INDEX idx_toole_act_tool ON lams_learning_tool_activity;
+DROP INDEX idx_toole_act_tool_content ON lams_learning_tool_activity;
+DROP INDEX PRIMARY ON lams_learning_transition;
+DROP INDEX ldId ON lams_learning_transition;
+DROP INDEX idx_transition_to_activity ON lams_learning_transition;
+DROP INDEX idx_transition_from_activity ON lams_learning_transition;
+DROP INDEX PRIMARY ON lams_user_organisation_role;
+DROP INDEX role_id ON lams_user_organisation_role;
+DROP INDEX user_organisation_id ON lams_user_organisation_role;
+DROP INDEX PRIMARY ON lams_authentication_method_parameter;
+DROP INDEX authentication_method_id ON lams_authentication_method_parameter;
+
+DROP TABLE lams_authentication_method_parameter;
+DROP TABLE lams_user_organisation_role;
+DROP TABLE lams_learning_transition;
+DROP TABLE lams_learning_tool_activity;
+DROP TABLE lams_learning_options_activity;
+DROP TABLE lams_learning_grouping_activity;
+DROP TABLE lams_learning_group;
+DROP TABLE lams_learning_gate_activity;
+DROP TABLE lams_user_organisation;
+DROP TABLE lams_learning_activity;
+DROP TABLE lams_user;
+DROP TABLE lams_organisation;
+DROP TABLE lams_learning_grouping;
+DROP TABLE lams_learning_design;
+DROP TABLE lams_workspace;
+DROP TABLE lams_workspace_folder;
+DROP TABLE lams_authentication_method;
+DROP TABLE lams_authentication_method_type;
+DROP TABLE lams_role;
+DROP TABLE lams_organisation_type;
+DROP TABLE lams_learning_library;
+DROP TABLE lams_learning_activity_type;
+DROP TABLE lams_grouping_type;
+DROP TABLE lams_gate_activity_level;
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: lams_common/db/sql/drop_learning_design_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/drop_learning_design_tables.sql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ lams_common/db/sql/drop_learning_design_tables.sql 23 Nov 2004 05:32:21 -0000 1.1
@@ -0,0 +1,140 @@
+-- Tables are not sorted because:
+-- Circular dependency between table DEFAULT_SCHEMA.lams_learning_activity and table DEFAULT_SCHEMA.lams_learning_design: both have foreign keys that reference the other table.
+-- Try generating Foreign Keys with ALTER TABLE statements.
+DROP INDEX PRIMARY;
+DROP INDEX ldId;
+DROP INDEX optional_activity_id;
+DROP INDEX PRIMARY;
+DROP INDEX idx_learning_design_libary_id;
+DROP INDEX PRIMARY;
+DROP INDEX PRIMARY;
+DROP INDEX ldId;
+DROP INDEX activity_id;
+
+DROP TABLE lams_learning_grouping_activity;
+DROP TABLE lams_learning_options_activity;
+DROP TABLE lams_gate_activity_level;
+DROP TABLE lams_grouping_type;
+DROP TABLE lams_learning_gate_activity;
+DROP TABLE lams_learning_tool_activity;
+DROP TABLE lams_learning_activity_type;
+DROP TABLE lams_learning_group;
+DROP TABLE lams_learning_grouping;
+DROP TABLE lams_learning_transition;
+DROP TABLE lams_learning_library;
+DROP TABLE lams_learning_design;
+DROP TABLE lams_learning_activity;
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ALTER TABLE lams_learning_activity
+ ADD CONSTRAINT FK_learning_activity_2
+ FOREIGN KEY (parent_activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_activity
+ ADD CONSTRAINT FK_learning_activity_3
+ FOREIGN KEY (learning_activity_type_id)
+ REFERENCES lams_learning_activity_type (learning_activity_type_id);
+
+ALTER TABLE lams_learning_activity
+ ADD CONSTRAINT FK_learning_activity_4
+ FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_activity
+ ADD CONSTRAINT FK_learning_activity_5
+ FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_activity
+ ADD CONSTRAINT FK_learning_activity_6
+ FOREIGN KEY (learning_grouping_id)
+ REFERENCES lams_learning_grouping (learning_grouping_id);
+
+ALTER TABLE lams_learning_activity
+ ADD CONSTRAINT FK_lams_learning_activity_6
+ FOREIGN KEY (learning_design_id)
+ REFERENCES lams_learning_design (learning_design_id);
+
+ALTER TABLE lams_learning_activity
+ ADD CONSTRAINT FK_lams_learning_activity_7
+ FOREIGN KEY (learning_library_id)
+ REFERENCES lams_learning_library (learning_library_id);
+
+ALTER TABLE lams_learning_design
+ ADD CONSTRAINT FK_lams_learning_design_1
+ FOREIGN KEY (first_activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_design
+ ADD CONSTRAINT FK_lams_learning_design_2
+ FOREIGN KEY (parent_learning_design_id)
+ REFERENCES lams_learning_design (learning_design_id);
+
+ALTER TABLE lams_learning_transition
+ ADD CONSTRAINT lddefn_transition_ibfk_1
+ FOREIGN KEY (learning_design_id)
+ REFERENCES lams_learning_design (learning_design_id);
+
+ALTER TABLE lams_learning_transition
+ ADD CONSTRAINT FK_learning_transition_2
+ FOREIGN KEY (to_activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_transition
+ ADD CONSTRAINT FK_learning_transition_3
+ FOREIGN KEY (from_activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_grouping
+ ADD CONSTRAINT FK_lams_learning_grouping_1
+ FOREIGN KEY (grouping_type_id)
+ REFERENCES lams_grouping_type (grouping_type_id);
+
+ALTER TABLE lams_learning_group
+ ADD CONSTRAINT FK_lams_learning_group_1
+ FOREIGN KEY (learning_grouping_id)
+ REFERENCES lams_learning_grouping (learning_grouping_id);
+
+ALTER TABLE lams_learning_tool_activity
+ ADD CONSTRAINT FK_lams_learning_tool_activity_1
+ FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_gate_activity
+ ADD CONSTRAINT FK_lams_learning_gate_activity_1
+ FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_gate_activity
+ ADD CONSTRAINT FK_lams_learning_gate_activity_2
+ FOREIGN KEY (gate_activity_level_id)
+ REFERENCES lams_gate_activity_level (gate_activity_level_id);
+
+ALTER TABLE lams_learning_options_activity
+ ADD CONSTRAINT FK_lams_learning_options_activity_1
+ FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_grouping_activity
+ ADD CONSTRAINT FK_lams_learning_grouping_activity_1
+ FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id);
+
+ALTER TABLE lams_learning_grouping_activity
+ ADD CONSTRAINT FK_lams_learning_grouping_activity_2
+ FOREIGN KEY (learning_grouping_id)
+ REFERENCES lams_learning_grouping (learning_grouping_id);
+
Index: lams_common/db/sql/insert_user_management_data.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/insert_user_management_data.sql,v
diff -u -r1.1 -r1.2
--- lams_common/db/sql/insert_user_management_data.sql 11 Nov 2004 03:01:56 -0000 1.1
+++ lams_common/db/sql/insert_user_management_data.sql 23 Nov 2004 05:32:21 -0000 1.2
@@ -1,5 +1,9 @@
# Connection: ROOT LOCAL
# Host: localhost
+# Saved: 2004-11-22 11:44:40
+#
+# Connection: ROOT LOCAL
+# Host: localhost
# Saved: 2004-11-09 15:04:37
#
# Connection: ROOT LOCAL
@@ -16,7 +20,7 @@
INSERT INTO lams_authentication_method_type VALUES(2, 'WEB_AUTH');
INSERT INTO lams_authentication_method_type VALUES(3, 'LDAP');
-INSERT INTO lams_organisation_type VALUES(1, 'ROOT ORGANISATION');
-INSERT INTO lams_organisation_type VALUES(2, 'BASE ORGANISATION');
-INSERT INTO lams_organisation_type VALUES(3, 'SUB-ORGANIZATION');
+INSERT INTO lams_organisation_type VALUES(1, 'ROOT ORGANISATION', 'root all other organisations: controlled by Sysadmin');
+INSERT INTO lams_organisation_type VALUES(2, 'BASE ORGANISATION', 'base organization: represents a real seperate organization sucha s a university ');
+INSERT INTO lams_organisation_type VALUES(3, 'SUB-ORGANIZATION', 'sub organization of a base organization');
Index: lams_common/design/lams11.xml.zip
===================================================================
RCS file: /usr/local/cvsroot/lams_common/design/lams11.xml.zip,v
diff -u -r1.2 -r1.3
Binary files differ