Index: lams_common/db/model/lams_11.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/model/lams_11.clay,v
diff -u -r1.18 -r1.19
--- lams_common/db/model/lams_11.clay 14 Feb 2005 22:59:16 -0000 1.18
+++ lams_common/db/model/lams_11.clay 15 Feb 2005 00:12:20 -0000 1.19
@@ -851,6 +851,25 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -879,6 +898,13 @@
+
+
+
+
+
+
+
@@ -2101,7 +2127,7 @@
-
+
@@ -2872,7 +2898,7 @@
-
+
@@ -3089,6 +3115,79 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
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.23 -r1.24
--- lams_common/db/sql/create_lams_11_tables.sql 14 Feb 2005 22:59:16 -0000 1.23
+++ lams_common/db/sql/create_lams_11_tables.sql 15 Feb 2005 00:12:20 -0000 1.24
@@ -78,6 +78,17 @@
, PRIMARY KEY (tool_session_type_id)
)TYPE=InnoDB;
+CREATE TABLE lams_license (
+ license_id BIGINT(20) NOT NULL
+ , license_text TEXT NOT NULL
+ , license_url VARCHAR(256)
+ , pciture_url VARCHAR(256)
+ , name VARCHAR(200) NOT NULL
+ , code VARCHAR(20) NOT NULL
+ , defualt_license TINYINT(1) NOT NULL DEFAULT 0
+ , PRIMARY KEY (license_id)
+)TYPE=InnoDB;
+
CREATE TABLE lams_authentication_method_type (
authentication_method_type_id INT(3) NOT NULL
, description VARCHAR(64) NOT NULL
@@ -207,6 +218,8 @@
, parent_learning_design_id BIGINT(20)
, workspace_folder_id BIGINT(20)
, duration BIGINT(38)
+ , license_id BIGINT(20)
+ , license_text TEXT
, PRIMARY KEY (learning_design_id)
, INDEX (parent_learning_design_id)
, CONSTRAINT FK_lams_learning_design_2 FOREIGN KEY (parent_learning_design_id)
@@ -217,6 +230,9 @@
, INDEX (workspace_folder_id)
, CONSTRAINT FK_lams_learning_design_4 FOREIGN KEY (workspace_folder_id)
REFERENCES lams_workspace_folder (workspace_folder_id)
+ , INDEX (license_id)
+ , CONSTRAINT FK_lams_learning_design_5 FOREIGN KEY (license_id)
+ REFERENCES lams_license (license_id)
)TYPE=InnoDB;
CREATE INDEX idx_design_first_act ON lams_learning_design (first_activity_id ASC);
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.11 -r1.12
--- lams_common/db/sql/drop_lams_11_tables.sql 9 Feb 2005 04:05:11 -0000 1.11
+++ lams_common/db/sql/drop_lams_11_tables.sql 15 Feb 2005 00:12:20 -0000 1.12
@@ -1,3 +1,7 @@
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2005-02-15 11:12:43
+#
DROP TABLE IF EXISTS lams_learning_transition;
DROP TABLE IF EXISTS lams_lesson_learner;
DROP TABLE IF EXISTS lams_activity_learners;
@@ -30,6 +34,7 @@
DROP TABLE IF EXISTS lams_learning_activity_type;
DROP TABLE IF EXISTS lams_grouping_type;
DROP TABLE IF EXISTS lams_gate_activity_level;
+DROP TABLE IF EXISTS lams_license;