Index: lams_common/db/model/lams_11.clay
===================================================================
diff -u -r5dc4fdc2fbf4145803eb2564ed49fad5be08f58a -rca1c5a5eac11257557c3109cf5cdb20e9226b1c4
--- lams_common/db/model/lams_11.clay (.../lams_11.clay) (revision 5dc4fdc2fbf4145803eb2564ed49fad5be08f58a)
+++ lams_common/db/model/lams_11.clay (.../lams_11.clay) (revision ca1c5a5eac11257557c3109cf5cdb20e9226b1c4)
@@ -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
===================================================================
diff -u -r5dc4fdc2fbf4145803eb2564ed49fad5be08f58a -rca1c5a5eac11257557c3109cf5cdb20e9226b1c4
--- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 5dc4fdc2fbf4145803eb2564ed49fad5be08f58a)
+++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision ca1c5a5eac11257557c3109cf5cdb20e9226b1c4)
@@ -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
===================================================================
diff -u -r96689f3e959264cd1d9be578f82b3557a36d39b2 -rca1c5a5eac11257557c3109cf5cdb20e9226b1c4
--- lams_common/db/sql/drop_lams_11_tables.sql (.../drop_lams_11_tables.sql) (revision 96689f3e959264cd1d9be578f82b3557a36d39b2)
+++ lams_common/db/sql/drop_lams_11_tables.sql (.../drop_lams_11_tables.sql) (revision ca1c5a5eac11257557c3109cf5cdb20e9226b1c4)
@@ -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;