Index: lams_common/db/model/lams_11.clay
===================================================================
diff -u -r8b0ad8352ac106ea6aa92b1571487a1dc50674c4 -r97a20e3454d113286b226f7a3f4a1371377df1d1
--- lams_common/db/model/lams_11.clay (.../lams_11.clay) (revision 8b0ad8352ac106ea6aa92b1571487a1dc50674c4)
+++ lams_common/db/model/lams_11.clay (.../lams_11.clay) (revision 97a20e3454d113286b226f7a3f4a1371377df1d1)
@@ -186,7 +186,7 @@
-
+
@@ -440,6 +440,19 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -496,6 +509,13 @@
+
+
+
+
+
+
+
@@ -759,6 +779,19 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -780,6 +813,13 @@
+
+
+
+
+
+
+
@@ -802,7 +842,7 @@
-
+
@@ -941,8 +981,8 @@
-
+
@@ -1651,7 +1691,7 @@
-
+
@@ -1811,7 +1851,7 @@
-
+
@@ -1867,7 +1907,7 @@
-
+
@@ -2628,7 +2668,7 @@
-
+
@@ -2754,8 +2794,8 @@
-
+
@@ -2794,6 +2834,59 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
diff -u -r82e1c646c21417c7d329bc953489458a141168b3 -r97a20e3454d113286b226f7a3f4a1371377df1d1
--- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 82e1c646c21417c7d329bc953489458a141168b3)
+++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 97a20e3454d113286b226f7a3f4a1371377df1d1)
@@ -87,13 +87,12 @@
CREATE TABLE lams_authentication_method (
authentication_method_id BIGINT(20) NOT NULL DEFAULT 0
, authentication_method_type_id INT(3) NOT NULL DEFAULT 0
- , authentication_method_name VARCHAR(255) NOT NULL
+ , parameters_file_name VARCHAR(255) NOT NULL
, 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 UNIQUE INDEX UQ_lams_authentication_method_name ON lams_authentication_method (authentication_method_name ASC);
CREATE TABLE lams_workspace_folder (
workspace_folder_id BIGINT(20) NOT NULL DEFAULT 0 AUTO_INCREMENT
@@ -115,36 +114,6 @@
REFERENCES lams_workspace_folder (workspace_folder_id) ON DELETE NO ACTION ON UPDATE NO ACTION
)TYPE=InnoDB;
-CREATE TABLE lams_learning_design (
- learning_design_id BIGINT(20) NOT NULL DEFAULT 0 AUTO_INCREMENT
- , id INT(11)
- , description TEXT
- , title VARCHAR(255)
- , first_activity_id BIGINT(20)
- , max_id INT(11)
- , valid_design_flag TINYINT(4) NOT NULL
- , read_only_flag TINYINT(4) NOT NULL
- , 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_grouping (
grouping_id BIGINT(20) NOT NULL DEFAULT 0 AUTO_INCREMENT
, grouping_type_id INT(11) NOT NULL DEFAULT 0
@@ -158,16 +127,6 @@
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 DEFAULT 0 AUTO_INCREMENT
- , grouping_id BIGINT(20) NOT NULL DEFAULT 0
- , order_id INT(6) NOT NULL DEFAULT 1
- , PRIMARY KEY (group_id)
- , INDEX (grouping_id)
- , CONSTRAINT FK_lams_learning_group_1 FOREIGN KEY (grouping_id)
- REFERENCES lams_grouping (grouping_id) ON DELETE NO ACTION ON UPDATE NO ACTION
-)TYPE=InnoDB;
-
CREATE TABLE lams_organisation (
organisation_id BIGINT(20) NOT NULL DEFAULT 0 AUTO_INCREMENT
, name VARCHAR(250)
@@ -210,7 +169,8 @@
, 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)
- , base_organisation_id BIGINT(20)
+ , user_organisation_id BIGINT(20) NOT NULL DEFAULT 0
+ , base_organisation_id BIGINT(20) NOT NULL DEFAULT 0
, PRIMARY KEY (user_id)
, INDEX (authentication_method_id)
, CONSTRAINT FK_lams_user_1 FOREIGN KEY (authentication_method_id)
@@ -225,52 +185,48 @@
CREATE UNIQUE INDEX UQ_lams_user_login ON lams_user (login ASC);
CREATE INDEX login ON lams_user (login ASC);
-CREATE TABLE lams_learning_activity (
- activity_id BIGINT(20) NOT NULL DEFAULT 0 AUTO_INCREMENT
+CREATE TABLE lams_learning_design (
+ learning_design_id BIGINT(20) NOT NULL DEFAULT 0 AUTO_INCREMENT
, 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
- , 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
+ , first_activity_id BIGINT(20)
+ , max_id INT(11)
+ , valid_design_flag TINYINT(4) NOT NULL
+ , read_only_flag TINYINT(4) NOT NULL
+ , 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'
- , offline_instructions TEXT
- , max_number_of_options INT(5)
- , min_number_of_options INT(5)
- , tool_id BIGINT(20)
- , tool_content_id BIGINT(20)
- , gate_activity_level_id INT(11) DEFAULT 0
- , gate_start_date_time DATETIME
- , gate_end_date_time DATETIME
- , library_activity_ui_image VARCHAR(255)
- , 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)
+ , version VARCHAR(56) NOT NULL
+ , parent_learning_design_id BIGINT(20)
+ , open_date_time DATETIME
+ , close_date_time DATETIME
+ , workspace_folder_id BIGINT(20) NOT NULL DEFAULT 0
+ , 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 (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 (user_id)
+ , CONSTRAINT FK_lams_learning_design_3 FOREIGN KEY (user_id)
+ REFERENCES lams_user (user_id)
+ , INDEX (workspace_folder_id)
+ , CONSTRAINT FK_lams_learning_design_4 FOREIGN KEY (workspace_folder_id)
+ REFERENCES lams_workspace_folder (workspace_folder_id)
+)TYPE=InnoDB;
+CREATE INDEX idx_design_first_act ON lams_learning_design (first_activity_id ASC);
+
+CREATE TABLE lams_group (
+ group_id BIGINT(20) NOT NULL DEFAULT 0 AUTO_INCREMENT
+ , grouping_id BIGINT(20) NOT NULL DEFAULT 0
+ , order_id INT(6) NOT NULL DEFAULT 1
+ , PRIMARY KEY (group_id)
, INDEX (grouping_id)
- , CONSTRAINT FK_learning_activity_6 FOREIGN KEY (grouping_id)
+ , CONSTRAINT FK_lams_learning_group_1 FOREIGN KEY (grouping_id)
REFERENCES lams_grouping (grouping_id) ON DELETE NO ACTION ON UPDATE NO ACTION
- , INDEX (tool_id)
- , CONSTRAINT FK_lams_learning_activity_8 FOREIGN KEY (tool_id)
- REFERENCES lams_tool (tool_id)
- , INDEX (gate_activity_level_id)
- , CONSTRAINT FK_lams_learning_activity_10 FOREIGN KEY (gate_activity_level_id)
- REFERENCES lams_gate_activity_level (gate_activity_level_id)
)TYPE=InnoDB;
CREATE TABLE lams_user_organisation (
@@ -314,6 +270,58 @@
REFERENCES lams_grouping (grouping_id)
)TYPE=InnoDB;
+CREATE TABLE lams_learning_activity (
+ activity_id BIGINT(20) NOT NULL DEFAULT 0 AUTO_INCREMENT
+ , 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
+ , 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
+ , max_number_of_options INT(5)
+ , min_number_of_options INT(5)
+ , tool_id BIGINT(20)
+ , tool_content_id BIGINT(20)
+ , gate_activity_level_id INT(11) DEFAULT 0
+ , gate_start_date_time DATETIME
+ , gate_end_date_time DATETIME
+ , library_activity_ui_image VARCHAR(255)
+ , create_grouping_id BIGINT(20)
+ , 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 (grouping_id)
+ , CONSTRAINT FK_learning_activity_6 FOREIGN KEY (grouping_id)
+ REFERENCES lams_grouping (grouping_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (tool_id)
+ , CONSTRAINT FK_lams_learning_activity_8 FOREIGN KEY (tool_id)
+ REFERENCES lams_tool (tool_id)
+ , INDEX (gate_activity_level_id)
+ , CONSTRAINT FK_lams_learning_activity_10 FOREIGN KEY (gate_activity_level_id)
+ REFERENCES lams_gate_activity_level (gate_activity_level_id)
+ , INDEX (create_grouping_id)
+ , CONSTRAINT FK_lams_learning_activity_9 FOREIGN KEY (create_grouping_id)
+ REFERENCES lams_grouping (grouping_id)
+)TYPE=InnoDB;
+
CREATE TABLE lams_learner_progress (
learner_progress_id BIGINT(20) NOT NULL AUTO_INCREMENT
, user_id BIGINT(20) NOT NULL DEFAULT 0
@@ -420,6 +428,17 @@
REFERENCES lams_tool (tool_id)
)TYPE=InnoDB;
+CREATE TABLE lams_activity_learners (
+ user_id BIGINT(20) NOT NULL DEFAULT 0
+ , activity_id BIGINT(20) NOT NULL DEFAULT 0
+ , INDEX (user_id)
+ , CONSTRAINT FK_TABLE_32_1 FOREIGN KEY (user_id)
+ REFERENCES lams_user (user_id)
+ , INDEX (activity_id)
+ , CONSTRAINT FK_TABLE_32_2 FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id)
+)TYPE=InnoDB;
+
CREATE TABLE lams_learning_transition (
transition_id BIGINT(20) NOT NULL DEFAULT 0 AUTO_INCREMENT
, id INT(11)
Index: lams_common/db/sql/drop_lams_11_tables.sql
===================================================================
diff -u -rc3112099a76f62b7b6a7d757450a626e90af73f2 -r97a20e3454d113286b226f7a3f4a1371377df1d1
--- lams_common/db/sql/drop_lams_11_tables.sql (.../drop_lams_11_tables.sql) (revision c3112099a76f62b7b6a7d757450a626e90af73f2)
+++ lams_common/db/sql/drop_lams_11_tables.sql (.../drop_lams_11_tables.sql) (revision 97a20e3454d113286b226f7a3f4a1371377df1d1)
@@ -13,14 +13,8 @@
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_grouping;
DROP INDEX idx_grouping_grouping_type ON lams_grouping;
-DROP INDEX PRIMARY ON lams_group;
-DROP INDEX idx_group_grouping ON lams_group;
DROP INDEX PRIMARY ON lams_organisation;
DROP INDEX organisation_type_id ON lams_organisation;
DROP INDEX workspace_id ON lams_organisation;
@@ -30,15 +24,21 @@
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_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_group;
+DROP INDEX idx_group_grouping ON lams_group;
+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_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_user_organisation_role;
DROP INDEX role_id ON lams_user_organisation_role;
DROP INDEX user_organisation_id ON lams_user_organisation_role;
@@ -48,6 +48,7 @@
DROP INDEX idx_transition_from_activity ON lams_learning_transition;
DROP TABLE lams_learning_transition;
+DROP TABLE lams_activity_learners;
DROP TABLE lams_tool_content;
DROP TABLE lams_user_group;
DROP TABLE lams_user_tool_session;
@@ -56,14 +57,14 @@
DROP TABLE lams_user_organisation_role;
DROP TABLE lams_tool_session;
DROP TABLE lams_learner_progress;
+DROP TABLE lams_learning_activity;
DROP TABLE lams_lesson;
DROP TABLE lams_user_organisation;
-DROP TABLE lams_learning_activity;
+DROP TABLE lams_group;
+DROP TABLE lams_learning_design;
DROP TABLE lams_user;
DROP TABLE lams_organisation;
-DROP TABLE lams_group;
DROP TABLE lams_grouping;
-DROP TABLE lams_learning_design;
DROP TABLE lams_workspace;
DROP TABLE lams_workspace_folder;
DROP TABLE lams_authentication_method;
@@ -110,279 +111,4 @@
-ALTER TABLE lams_authentication_method
- ADD 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;
-ALTER TABLE lams_workspace_folder
- ADD 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;
-
-ALTER TABLE lams_workspace
- ADD 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;
-
-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)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION;
-
-ALTER TABLE lams_learning_design
- ADD CONSTRAINT FK_lams_learning_design_3
- FOREIGN KEY (user_id)
- REFERENCES lams_user (user_id);
-
-ALTER TABLE lams_grouping
- ADD 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;
-
-ALTER TABLE lams_group
- ADD CONSTRAINT FK_lams_learning_group_1
- FOREIGN KEY (grouping_id)
- REFERENCES lams_grouping (grouping_id)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION;
-
-ALTER TABLE lams_organisation
- ADD 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;
-
-ALTER TABLE lams_organisation
- ADD CONSTRAINT FK_lams_organisation_2
- FOREIGN KEY (workspace_id)
- REFERENCES lams_workspace (workspace_id)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION;
-
-ALTER TABLE lams_organisation
- ADD CONSTRAINT FK_lams_organisation_3
- FOREIGN KEY (parent_organisation_id)
- REFERENCES lams_organisation (organisation_id)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION;
-
-ALTER TABLE lams_user
- ADD 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;
-
-ALTER TABLE lams_user
- ADD CONSTRAINT FK_lams_user_2
- FOREIGN KEY (workspace_id)
- REFERENCES lams_workspace (workspace_id)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION;
-
-ALTER TABLE lams_user
- ADD CONSTRAINT FK_lams_user_3
- FOREIGN KEY (base_organisation_id)
- REFERENCES lams_organisation (organisation_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)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION;
-
-ALTER TABLE lams_learning_activity
- ADD 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;
-
-ALTER TABLE lams_learning_activity
- ADD CONSTRAINT FK_learning_activity_2
- FOREIGN KEY (parent_activity_id)
- REFERENCES lams_learning_activity (activity_id)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION;
-
-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)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION;
-
-ALTER TABLE lams_learning_activity
- ADD CONSTRAINT FK_learning_activity_6
- FOREIGN KEY (grouping_id)
- REFERENCES lams_grouping (grouping_id)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION;
-
-ALTER TABLE lams_learning_activity
- ADD CONSTRAINT FK_lams_learning_activity_8
- FOREIGN KEY (tool_id)
- REFERENCES lams_tool (tool_id);
-
-ALTER TABLE lams_learning_activity
- ADD CONSTRAINT FK_lams_learning_activity_10
- FOREIGN KEY (gate_activity_level_id)
- REFERENCES lams_gate_activity_level (gate_activity_level_id);
-
-ALTER TABLE lams_user_organisation
- ADD CONSTRAINT u_user_organisation_ibfk_1
- FOREIGN KEY (user_id)
- REFERENCES lams_user (user_id)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION;
-
-ALTER TABLE lams_user_organisation
- ADD CONSTRAINT u_user_organisation_ibfk_2
- FOREIGN KEY (organisation_id)
- REFERENCES lams_organisation (organisation_id)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION;
-
-ALTER TABLE lams_lesson
- ADD CONSTRAINT FK_lams_lesson_1_1
- FOREIGN KEY (learning_design_id)
- REFERENCES lams_learning_design (learning_design_id);
-
-ALTER TABLE lams_lesson
- ADD CONSTRAINT FK_lams_lesson_2
- FOREIGN KEY (user_id)
- REFERENCES lams_user (user_id);
-
-ALTER TABLE lams_lesson
- ADD CONSTRAINT FK_lams_lesson_3
- FOREIGN KEY (organisation_id)
- REFERENCES lams_organisation (organisation_id);
-
-ALTER TABLE lams_lesson
- ADD CONSTRAINT FK_lams_lesson_4
- FOREIGN KEY (lams_lesson_state_id)
- REFERENCES lams_lesson_state (lams_lesson_state_id);
-
-ALTER TABLE lams_lesson
- ADD CONSTRAINT FK_lams_lesson_5
- FOREIGN KEY (class_grouping_id)
- REFERENCES lams_grouping (grouping_id);
-
-ALTER TABLE lams_learner_progress
- ADD CONSTRAINT FK_lams_learner_progress_1
- FOREIGN KEY (user_id)
- REFERENCES lams_user (user_id);
-
-ALTER TABLE lams_learner_progress
- ADD CONSTRAINT FK_lams_learner_progress_2
- FOREIGN KEY (lesson_id)
- REFERENCES lams_lesson (lesson_id);
-
-ALTER TABLE lams_tool_session
- ADD CONSTRAINT FK_lams_tool_session_1
- FOREIGN KEY (group_id)
- REFERENCES lams_group (group_id);
-
-ALTER TABLE lams_tool_session
- ADD CONSTRAINT FK_lams_tool_session_4
- FOREIGN KEY (tool_session_state_id)
- REFERENCES lams_tool_session_state (tool_session_state_id);
-
-ALTER TABLE lams_user_organisation_role
- ADD CONSTRAINT FK_lams_user_organisation_role_2
- FOREIGN KEY (role_id)
- REFERENCES lams_role (role_id)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION;
-
-ALTER TABLE lams_user_organisation_role
- ADD 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;
-
-ALTER TABLE lams_progress_completed
- ADD CONSTRAINT FK_lams_progress_completed_1
- FOREIGN KEY (learner_progress_id)
- REFERENCES lams_learner_progress (learner_progress_id);
-
-ALTER TABLE lams_progress_completed
- ADD CONSTRAINT FK_lams_progress_completed_2
- FOREIGN KEY (activity_id)
- REFERENCES lams_learning_activity (activity_id);
-
-ALTER TABLE lams_progress_current
- ADD CONSTRAINT FK_lams_progress_current_1
- FOREIGN KEY (learner_progress_id)
- REFERENCES lams_learner_progress (learner_progress_id);
-
-ALTER TABLE lams_progress_current
- ADD CONSTRAINT FK_lams_progress_current_2
- FOREIGN KEY (activity_id)
- REFERENCES lams_learning_activity (activity_id);
-
-ALTER TABLE lams_user_tool_session
- ADD CONSTRAINT FK_lams_user_tool_session_1
- FOREIGN KEY (tool_session_id)
- REFERENCES lams_tool_session (tool_session_id);
-
-ALTER TABLE lams_user_tool_session
- ADD CONSTRAINT FK_lams_user_tool_session_2
- FOREIGN KEY (user_id)
- REFERENCES lams_user (user_id);
-
-ALTER TABLE lams_user_tool_session
- ADD CONSTRAINT FK_lams_user_tool_session_3
- FOREIGN KEY (user_tool_session_state_id)
- REFERENCES lams_user_tool_session_state (user_tool_session_state_id);
-
-ALTER TABLE lams_user_group
- ADD CONSTRAINT FK_lams_user_group_1
- FOREIGN KEY (user_id)
- REFERENCES lams_user (user_id);
-
-ALTER TABLE lams_user_group
- ADD CONSTRAINT FK_lams_user_group_2
- FOREIGN KEY (group_id)
- REFERENCES lams_group (group_id);
-
-ALTER TABLE lams_tool_content
- ADD CONSTRAINT FK_lams_tool_content_1
- FOREIGN KEY (tool_id)
- REFERENCES lams_tool (tool_id);
-
-ALTER TABLE lams_learning_transition
- ADD CONSTRAINT FK_learning_transition_3
- FOREIGN KEY (from_activity_id)
- REFERENCES lams_learning_activity (activity_id)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION;
-
-ALTER TABLE lams_learning_transition
- ADD CONSTRAINT FK_learning_transition_2
- FOREIGN KEY (to_activity_id)
- REFERENCES lams_learning_activity (activity_id)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION;
-
-ALTER TABLE lams_learning_transition
- ADD 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;
-