Index: lams_common/db/model/lams_11.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/model/lams_11.clay,v
diff -u -r1.27 -r1.28
--- lams_common/db/model/lams_11.clay 28 Feb 2005 07:35:30 -0000 1.27
+++ lams_common/db/model/lams_11.clay 3 Mar 2005 23:53:56 -0000 1.28
@@ -934,6 +934,45 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -1601,17 +1640,10 @@
-
+
-
-
-
-
-
-
-
-
-
+
+
@@ -2226,17 +2258,43 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -2264,23 +2322,22 @@
+
+
+
+
+
+
-
+
-
-
-
-
-
-
-
-
-
+
+
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.34 -r1.35
--- lams_common/db/sql/create_lams_11_tables.sql 28 Feb 2005 22:10:50 -0000 1.34
+++ lams_common/db/sql/create_lams_11_tables.sql 3 Mar 2005 23:53:57 -0000 1.35
@@ -36,7 +36,7 @@
role_id INT(6) NOT NULL DEFAULT 0
, name VARCHAR(64) NOT NULL
, description TEXT
- , create_date DATETIME
+ , create_date DATETIME NOT NULL
, PRIMARY KEY (role_id)
)TYPE=InnoDB;
CREATE INDEX gname ON lams_role (name ASC);
@@ -107,7 +107,6 @@
, name VARCHAR(255) NOT NULL
, PRIMARY KEY (workspace_id)
)TYPE=InnoDB;
-ALTER TABLE lams_cr_workspace COMMENT='Content repository workspace';
CREATE TABLE lams_cr_credential (
credential_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT
@@ -116,7 +115,6 @@
, wc_id BIGINT(20) UNSIGNED NOT NULL
, PRIMARY KEY (credential_id)
)TYPE=InnoDB;
-ALTER TABLE lams_cr_credential COMMENT='Records the identification properties for a tool.';
CREATE TABLE lams_authentication_method_type (
authentication_method_type_id INT(3) NOT NULL
@@ -234,6 +232,10 @@
, duration BIGINT(38)
, license_id BIGINT(20)
, license_text TEXT
+ , lesson_org_id BIGINT(20)
+ , lesson_org_name VARCHAR(255)
+ , lesson_id BIGINT(20)
+ , lesson_start_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)
@@ -294,12 +296,16 @@
lesson_id BIGINT(20) NOT NULL AUTO_INCREMENT
, learning_design_id BIGINT(20) NOT NULL
, user_id BIGINT(20) NOT NULL
+ , name VARCHAR(255)
+ , description TEXT
, create_date_time DATETIME NOT NULL
- , organisation_id BIGINT(20) NOT NULL
+ , organisation_id BIGINT(20)
+ , class_grouping_id BIGINT(20)
, lesson_state_id INT(3) NOT NULL
, start_date_time DATETIME
+ , schedule_start_date_time DATETIME
, end_date_time DATETIME
- , class_grouping_id BIGINT(20) NOT NULL
+ , schedule_end_date_time DATETIME
, PRIMARY KEY (lesson_id)
, INDEX (learning_design_id)
, CONSTRAINT FK_lams_lesson_1_1 FOREIGN KEY (learning_design_id)
@@ -430,7 +436,6 @@
, CONSTRAINT FK_lams_cr_node_1 FOREIGN KEY (workspace_id)
REFERENCES lams_cr_workspace (workspace_id)
)TYPE=InnoDB;
-ALTER TABLE lams_cr_node COMMENT='The main table containing the node definition';
CREATE TABLE lams_cr_node_version (
nv_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT
@@ -443,7 +448,6 @@
, CONSTRAINT FK_lams_cr_node_version_2 FOREIGN KEY (node_id)
REFERENCES lams_cr_node (node_id)
)TYPE=InnoDB;
-ALTER TABLE lams_cr_node_version COMMENT='Represents a version of a node';
CREATE TABLE lams_user_organisation_role (
user_organisation_role_id BIGINT(20) NOT NULL AUTO_INCREMENT
@@ -569,7 +573,6 @@
, CONSTRAINT FK_lams_cr_workspace_credential_2 FOREIGN KEY (credential_id)
REFERENCES lams_cr_credential (credential_id) ON DELETE NO ACTION ON UPDATE NO ACTION
)TYPE=InnoDB;
-ALTER TABLE lams_cr_workspace_credential COMMENT='Maps tools access to workspaces';
CREATE TABLE lams_cr_node_version_property (
id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT