Index: lams_common/db/model/lams_11.clay
===================================================================
diff -u -r93da2b2771430e63ed55f97c51a1e777ab74a288 -rab84b2bbb1debe040baba7093cbb26a168b14f42
--- lams_common/db/model/lams_11.clay (.../lams_11.clay) (revision 93da2b2771430e63ed55f97c51a1e777ab74a288)
+++ lams_common/db/model/lams_11.clay (.../lams_11.clay) (revision ab84b2bbb1debe040baba7093cbb26a168b14f42)
@@ -407,7 +407,7 @@
-
+
@@ -496,11 +496,11 @@
-
+
-
+
@@ -902,7 +902,7 @@
-
+
@@ -1320,7 +1320,7 @@
-
+
@@ -1422,7 +1422,7 @@
-
+
@@ -1559,7 +1559,7 @@
-
+
@@ -1871,7 +1871,7 @@
-
+
@@ -2863,6 +2863,12 @@
+
+
+
+
+
+
@@ -3173,7 +3179,7 @@
-
+
@@ -4097,6 +4103,125 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
diff -u -r93da2b2771430e63ed55f97c51a1e777ab74a288 -rab84b2bbb1debe040baba7093cbb26a168b14f42
--- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 93da2b2771430e63ed55f97c51a1e777ab74a288)
+++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision ab84b2bbb1debe040baba7093cbb26a168b14f42)
@@ -21,7 +21,7 @@
, description TEXT
, title VARCHAR(255)
, valid_flag TINYINT(1) NOT NULL DEFAULT 1
- , create_date_time DATETIME NOT NULL
+ , create_date_time DATETIME NOT NULL
, PRIMARY KEY (learning_library_id)
)TYPE=InnoDB;
@@ -108,6 +108,12 @@
, PRIMARY KEY (grouping_support_type_id)
)TYPE=InnoDB;
+CREATE TABLE lams_log_event_type (
+ log_event_type_id INT(5) NOT NULL
+ , description VARCHAR(255) NOT NULL
+ , PRIMARY KEY (log_event_type_id)
+)TYPE=InnoDB;
+
CREATE TABLE lams_authentication_method_type (
authentication_method_type_id INT(3) NOT NULL
, description VARCHAR(64) NOT NULL
@@ -159,7 +165,7 @@
, description VARCHAR(250)
, parent_organisation_id BIGINT(20)
, organisation_type_id INT(3) NOT NULL DEFAULT 0
- , create_date DATETIME NOT NULL
+ , create_date DATETIME NOT NULL
, workspace_id BIGINT(20)
, PRIMARY KEY (organisation_id)
, INDEX (organisation_type_id)
@@ -192,7 +198,7 @@
, fax VARCHAR(64)
, email VARCHAR(128)
, disabled_flag TINYINT(1) NOT NULL DEFAULT 0
- , create_date DATETIME NOT NULL
+ , create_date DATETIME NOT NULL
, authentication_method_id BIGINT(20) NOT NULL DEFAULT 0
, workspace_id BIGINT(20)
, user_organisation_id BIGINT(20) NOT NULL DEFAULT 0
@@ -211,52 +217,6 @@
CREATE UNIQUE INDEX UQ_lams_user_login ON lams_user (login ASC);
CREATE INDEX login ON lams_user (login ASC);
-CREATE TABLE lams_grouping (
- grouping_id BIGINT(20) NOT NULL AUTO_INCREMENT
- , grouping_ui_id INT(11)
- , grouping_type_id INT(11) NOT NULL
- , number_of_groups INT(11)
- , learners_per_group INT(11)
- , staff_group_id BIGINT(20) DEFAULT 0
- , max_number_of_groups INT(3)
- , PRIMARY KEY (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_tool (
- tool_id BIGINT(20) NOT NULL AUTO_INCREMENT
- , tool_signature VARCHAR(64) NOT NULL
- , service_name VARCHAR(255) NOT NULL
- , tool_display_name VARCHAR(255) NOT NULL
- , description TEXT
- , learning_library_id BIGINT(20) NOT NULL
- , default_tool_content_id BIGINT(20) NOT NULL
- , valid_flag TINYINT(1) NOT NULL DEFAULT 1
- , grouping_support_type_id INT(3) NOT NULL
- , supports_define_later_flag TINYINT(1) NOT NULL DEFAULT 0
- , supports_run_offline_flag TINYINT(1) NOT NULL
- , supports_moderation_flag TINYINT(1) NOT NULL
- , supports_contribute_flag TINYINT(1) NOT NULL
- , learner_url TEXT NOT NULL
- , author_url TEXT NOT NULL
- , define_later_url TEXT
- , export_portfolio_url TEXT NOT NULL
- , monitor_url TEXT NOT NULL
- , contribute_url TEXT
- , moderation_url TEXT
- , UNIQUE UQ_lams_tool_sig (tool_signature)
- , UNIQUE UQ_lams_tool_class_name (service_name)
- , PRIMARY KEY (tool_id)
- , INDEX (learning_library_id)
- , CONSTRAINT FK_lams_tool_1 FOREIGN KEY (learning_library_id)
- REFERENCES lams_learning_library (learning_library_id)
- , INDEX (grouping_support_type_id)
- , CONSTRAINT FK_lams_tool_2 FOREIGN KEY (grouping_support_type_id)
- REFERENCES lams_grouping_support_type (grouping_support_type_id)
-)TYPE=InnoDB;
-
CREATE TABLE lams_learning_design (
learning_design_id BIGINT(20) NOT NULL AUTO_INCREMENT
, learning_design_ui_id INT(11)
@@ -270,7 +230,7 @@
, user_id BIGINT(20) NOT NULL
, help_text TEXT
, copy_type_id TINYINT(4) NOT NULL
- , create_date_time DATETIME NOT NULL
+ , create_date_time DATETIME NOT NULL
, version VARCHAR(56)
, parent_learning_design_id BIGINT(20)
, workspace_folder_id BIGINT(20)
@@ -302,6 +262,20 @@
)TYPE=InnoDB;
CREATE INDEX idx_design_first_act ON lams_learning_design (first_activity_id ASC);
+CREATE TABLE lams_grouping (
+ grouping_id BIGINT(20) NOT NULL AUTO_INCREMENT
+ , grouping_ui_id INT(11)
+ , grouping_type_id INT(11) NOT NULL
+ , number_of_groups INT(11)
+ , learners_per_group INT(11)
+ , staff_group_id BIGINT(20) DEFAULT 0
+ , max_number_of_groups INT(3)
+ , PRIMARY KEY (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_group (
group_id BIGINT(20) NOT NULL AUTO_INCREMENT
, grouping_id BIGINT(20) NOT NULL
@@ -357,6 +331,39 @@
REFERENCES lams_grouping (grouping_id)
)TYPE=InnoDB;
+CREATE TABLE lams_tool (
+ tool_id BIGINT(20) NOT NULL AUTO_INCREMENT
+ , tool_signature VARCHAR(64) NOT NULL
+ , service_name VARCHAR(255) NOT NULL
+ , tool_display_name VARCHAR(255) NOT NULL
+ , description TEXT
+ , learning_library_id BIGINT(20) NOT NULL
+ , default_tool_content_id BIGINT(20) NOT NULL
+ , valid_flag TINYINT(1) NOT NULL DEFAULT 1
+ , grouping_support_type_id INT(3) NOT NULL
+ , supports_define_later_flag TINYINT(1) NOT NULL DEFAULT 0
+ , supports_run_offline_flag TINYINT(1) NOT NULL
+ , supports_moderation_flag TINYINT(1) NOT NULL
+ , supports_contribute_flag TINYINT(1) NOT NULL
+ , learner_url TEXT NOT NULL
+ , author_url TEXT NOT NULL
+ , define_later_url TEXT
+ , export_portfolio_url TEXT NOT NULL
+ , monitor_url TEXT NOT NULL
+ , contribute_url TEXT
+ , moderation_url TEXT
+ , create_date_time DATETIME NOT NULL
+ , UNIQUE UQ_lams_tool_sig (tool_signature)
+ , UNIQUE UQ_lams_tool_class_name (service_name)
+ , PRIMARY KEY (tool_id)
+ , INDEX (learning_library_id)
+ , CONSTRAINT FK_lams_tool_1 FOREIGN KEY (learning_library_id)
+ REFERENCES lams_learning_library (learning_library_id)
+ , INDEX (grouping_support_type_id)
+ , CONSTRAINT FK_lams_tool_2 FOREIGN KEY (grouping_support_type_id)
+ REFERENCES lams_grouping_support_type (grouping_support_type_id)
+)TYPE=InnoDB;
+
CREATE TABLE lams_learning_activity (
activity_id BIGINT(20) NOT NULL AUTO_INCREMENT
, activity_ui_id INT(11)
@@ -376,7 +383,7 @@
, define_later_flag TINYINT(4) NOT NULL DEFAULT 0
, learning_design_id BIGINT(20)
, learning_library_id BIGINT(20)
- , create_date_time DATETIME NOT NULL
+ , create_date_time DATETIME NOT NULL
, run_offline_flag TINYINT(1) NOT NULL
, offline_instructions TEXT
, online_instructions TEXT
@@ -385,7 +392,7 @@
, options_instructions TEXT
, tool_id BIGINT(20)
, tool_content_id BIGINT(20)
- , activity_category_id INT(3)
+ , activity_category_id INT(3) NOT NULL
, gate_activity_level_id INT(11)
, gate_open_flag TINYINT(1)
, gate_start_time_offset BIGINT(38)
@@ -626,6 +633,19 @@
REFERENCES lams_cr_node_version (nv_id)
)TYPE=InnoDB;
+CREATE TABLE lams_log_event (
+ log_event_id BIGINT(20) NOT NULL AUTO_INCREMENT
+ , log_event_type_id INT(5) NOT NULL
+ , user_id BIGINT(20)
+ , timestamp DATETIME NOT NULL
+ , ref_id BIGINT(20)
+ , message VARCHAR(255)
+ , PRIMARY KEY (log_event_id)
+ , INDEX (log_event_type_id)
+ , CONSTRAINT FK_lams_event_log_1 FOREIGN KEY (log_event_type_id)
+ REFERENCES lams_log_event_type (log_event_type_id)
+)TYPE=InnoDB;
+
CREATE TABLE lams_learning_transition (
transition_id BIGINT(20) NOT NULL AUTO_INCREMENT
, transition_ui_id INT(11)
@@ -634,7 +654,7 @@
, to_activity_id BIGINT(20) NOT NULL
, from_activity_id BIGINT(20) NOT NULL
, learning_design_id BIGINT(20) NOT NULL DEFAULT 0
- , create_date_time DATETIME NOT NULL
+ , create_date_time DATETIME NOT NULL
, to_ui_id INT(11)
, from_ui_id INT(11)
, PRIMARY KEY (transition_id)
Index: lams_common/db/sql/drop_lams_11_tables.sql
===================================================================
diff -u -re5d2e738b82a794a28bb96ee7198f26c9be4aedf -rab84b2bbb1debe040baba7093cbb26a168b14f42
--- lams_common/db/sql/drop_lams_11_tables.sql (.../drop_lams_11_tables.sql) (revision e5d2e738b82a794a28bb96ee7198f26c9be4aedf)
+++ lams_common/db/sql/drop_lams_11_tables.sql (.../drop_lams_11_tables.sql) (revision ab84b2bbb1debe040baba7093cbb26a168b14f42)
@@ -1,5 +1,13 @@
# Connection: ROOT LOCAL
# Host: localhost
+# Saved: 2005-03-18 15:25:57
+#
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2005-03-18 15:04:50
+#
+# Connection: ROOT LOCAL
+# Host: localhost
# Saved: 2005-03-15 13:43:35
#
# Connection: ROOT LOCAL
@@ -55,5 +63,7 @@
DROP TABLE IF EXISTS lams_cr_credential;
DROP TABLE IF EXISTS lams_workspace_folder_type;
DROP TABLE IF EXISTS lams_grouping_support_type;
+DROP TABLE IF EXISTS lams_log_event;
+DROP TABLE IF EXISTS lams_log_event_type;
SET FOREIGN_KEY_CHECKS=1;
Index: lams_common/db/sql/insert_types_data.sql
===================================================================
diff -u -re5d2e738b82a794a28bb96ee7198f26c9be4aedf -rab84b2bbb1debe040baba7093cbb26a168b14f42
--- lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision e5d2e738b82a794a28bb96ee7198f26c9be4aedf)
+++ lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision ab84b2bbb1debe040baba7093cbb26a168b14f42)
@@ -1,7 +1,11 @@
# Connection: ROOT LOCAL
# Host: localhost
-# Saved: 2005-03-15 13:54:28
+# Saved: 2005-03-18 15:28:01
#
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2005-03-18 14:55:46
+#
INSERT INTO lams_role VALUES (1, 'SYSADMIN', 'LAMS System Adminstrator', NOW());
INSERT INTO lams_role VALUES (2, 'ADMIN', 'Organization Adminstrator', NOW());
INSERT INTO lams_role VALUES (3, 'AUTHOR', 'Authors Learning Designs', NOW());
@@ -78,7 +82,14 @@
INSERT INTO lams_grouping_support_type VALUES (2 ,'OPTIONAL');
INSERT INTO lams_grouping_support_type VALUES (3 ,'REQUIRED');
+INSERT INTO lams_log_event_type VALUES (1, 'LEARNER_LESSON_START');
+INSERT INTO lams_log_event_type VALUES (2, 'LEARNER_LESSON_FINISH');
+INSERT INTO lams_log_event_type VALUES (3, 'LEARNER_LESSON_EXIT');
+INSERT INTO lams_log_event_type VALUES (4, 'LEARNER_LESSON_RESUME');
+INSERT INTO lams_log_event_type VALUES (5, 'LEARNER_ACTIVITY_START');
+INSERT INTO lams_log_event_type VALUES (6, 'LEARNER_ACTIVITY_FINISH');
+