Index: lams_build/common.properties =================================================================== diff -u -r924d4186e55122ce91b5dcaba3311ab026060e94 -r10db06081c24c1566659b76698016e844de327a5 --- lams_build/common.properties (.../common.properties) (revision 924d4186e55122ce91b5dcaba3311ab026060e94) +++ lams_build/common.properties (.../common.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -18,7 +18,7 @@ # http://www.gnu.org/licenses/gpl.txt # put into EAR MANIFEST.MF file -project.version=4.6 +project.version=4.7 # is HTTPS in use? if so, set it to true, so JSESSIONID cookie is secured secure.cookie=false Index: lams_common/db/sql/create_lams_11_tables.sql =================================================================== diff -u -r812d599154aefa64ac8c3db4cdecdc1b679706af -r10db06081c24c1566659b76698016e844de327a5 --- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 812d599154aefa64ac8c3db4cdecdc1b679706af) +++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -1,2033 +1,2185 @@ -- dumped with --- mysqldump --default-character-set=utf8mb4 --single-transaction --hex-blob --routines --triggers --add-drop-table --add-drop-trigger --skip-quote-names --skip-set-charset --skip-add-locks --skip-comments +-- mysqldump --default-character-set=utf8mb4 --single-transaction --hex-blob --routines --triggers --add-drop-table --add-drop-trigger --skip-quote-names --skip-set-charset --skip-add-locks --skip-comments --no-data SET FOREIGN_KEY_CHECKS=0; DROP TABLE IF EXISTS lams_activity_evaluation; CREATE TABLE lams_activity_evaluation ( - activity_id bigint NOT NULL, - tool_output_definition varchar(255) NOT NULL, - weight tinyint DEFAULT NULL, - PRIMARY KEY (activity_id), - KEY activity_id (activity_id), - CONSTRAINT FK_lams_activity_evaluation_1 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE + activity_id bigint NOT NULL, + tool_output_definition varchar(255) NOT NULL, + weight tinyint DEFAULT NULL, + PRIMARY KEY (activity_id), + KEY activity_id (activity_id), + CONSTRAINT FK_lams_activity_evaluation_1 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_auth_method_type; + CREATE TABLE lams_auth_method_type ( - authentication_method_type_id int NOT NULL, - `description` varchar(64) NOT NULL, - PRIMARY KEY (authentication_method_type_id) + authentication_method_type_id int NOT NULL, + `description` varchar(64) NOT NULL, + PRIMARY KEY (authentication_method_type_id) ); DROP TABLE IF EXISTS lams_authentication_method; + CREATE TABLE lams_authentication_method ( - authentication_method_id bigint NOT NULL, - authentication_method_type_id int NOT NULL DEFAULT '0', - authentication_method_name varchar(191) NOT NULL, - PRIMARY KEY (authentication_method_id), - UNIQUE KEY UQ_lams_authentication_method_1 (authentication_method_name), - KEY authentication_method_type_id (authentication_method_type_id), - CONSTRAINT FK_lams_authorization_method_1 FOREIGN KEY (authentication_method_type_id) REFERENCES lams_auth_method_type (authentication_method_type_id) + authentication_method_id bigint NOT NULL, + authentication_method_type_id int NOT NULL DEFAULT '0', + authentication_method_name varchar(191) NOT NULL, + PRIMARY KEY (authentication_method_id), + UNIQUE KEY UQ_lams_authentication_method_1 (authentication_method_name), + KEY authentication_method_type_id (authentication_method_type_id), + CONSTRAINT FK_lams_authorization_method_1 FOREIGN KEY (authentication_method_type_id) REFERENCES lams_auth_method_type (authentication_method_type_id) ); DROP TABLE IF EXISTS lams_branch_activity_entry; + CREATE TABLE lams_branch_activity_entry ( - entry_id bigint NOT NULL AUTO_INCREMENT, - entry_ui_id int DEFAULT NULL, - group_id bigint DEFAULT NULL, - sequence_activity_id bigint DEFAULT NULL, - branch_activity_id bigint NOT NULL, - condition_id bigint DEFAULT NULL, - open_gate tinyint(1) DEFAULT NULL, - PRIMARY KEY (entry_id), - KEY group_id (group_id), - KEY sequence_activity_id (sequence_activity_id), - KEY branch_activity_id (branch_activity_id), - KEY condition_id (condition_id), - CONSTRAINT FK_lams_branch_activity_entry_4 FOREIGN KEY (condition_id) REFERENCES lams_branch_condition (condition_id), - CONSTRAINT FK_lams_branch_map_branch FOREIGN KEY (branch_activity_id) REFERENCES lams_learning_activity (activity_id), - CONSTRAINT FK_lams_branch_map_sequence FOREIGN KEY (sequence_activity_id) REFERENCES lams_learning_activity (activity_id), - CONSTRAINT FK_lams_group_activity_1 FOREIGN KEY (group_id) REFERENCES lams_group (group_id) + entry_id bigint NOT NULL AUTO_INCREMENT, + entry_ui_id int DEFAULT NULL, + group_id bigint DEFAULT NULL, + sequence_activity_id bigint DEFAULT NULL, + branch_activity_id bigint NOT NULL, + condition_id bigint DEFAULT NULL, + open_gate tinyint(1) DEFAULT NULL, + PRIMARY KEY (entry_id), + KEY group_id (group_id), + KEY sequence_activity_id (sequence_activity_id), + KEY branch_activity_id (branch_activity_id), + KEY condition_id (condition_id), + CONSTRAINT FK_lams_branch_activity_entry_4 FOREIGN KEY (condition_id) REFERENCES lams_branch_condition (condition_id), + CONSTRAINT FK_lams_branch_map_branch FOREIGN KEY (branch_activity_id) REFERENCES lams_learning_activity (activity_id), + CONSTRAINT FK_lams_branch_map_sequence FOREIGN KEY (sequence_activity_id) REFERENCES lams_learning_activity (activity_id), + CONSTRAINT FK_lams_group_activity_1 FOREIGN KEY (group_id) REFERENCES lams_group (group_id) ); DROP TABLE IF EXISTS lams_branch_condition; + CREATE TABLE lams_branch_condition ( - condition_id bigint NOT NULL AUTO_INCREMENT, - condition_ui_id int DEFAULT NULL, - order_id int DEFAULT NULL, - `name` varchar(255) NOT NULL, - display_name varchar(255) DEFAULT NULL, - `type` varchar(30) NOT NULL, - start_value varchar(255) DEFAULT NULL, - end_value varchar(255) DEFAULT NULL, - exact_match_value varchar(255) DEFAULT NULL, - PRIMARY KEY (condition_id) + condition_id bigint NOT NULL AUTO_INCREMENT, + condition_ui_id int DEFAULT NULL, + order_id int DEFAULT NULL, + `name` varchar(255) NOT NULL, + display_name varchar(255) DEFAULT NULL, + `type` varchar(30) NOT NULL, + start_value varchar(255) DEFAULT NULL, + end_value varchar(255) DEFAULT NULL, + exact_match_value varchar(255) DEFAULT NULL, + PRIMARY KEY (condition_id) ); DROP TABLE IF EXISTS lams_comment; + CREATE TABLE lams_comment ( - uid bigint NOT NULL AUTO_INCREMENT, - session_id bigint NOT NULL, - body mediumtext, - create_by bigint DEFAULT NULL, - create_date datetime DEFAULT NULL, - update_date datetime DEFAULT NULL, - update_by bigint DEFAULT NULL, - last_modified datetime DEFAULT NULL, - last_reply_date datetime DEFAULT NULL, - reply_number int DEFAULT NULL, - hide_flag smallint DEFAULT NULL, - parent_uid bigint DEFAULT NULL, - root_comment_uid bigint DEFAULT NULL, - comment_level smallint DEFAULT NULL, - thread_comment_uid bigint DEFAULT NULL, - sticky smallint DEFAULT '0', - monitor smallint DEFAULT '0', - anonymous smallint DEFAULT '0', - PRIMARY KEY (uid), - KEY FK_comment_session (session_id), - KEY FK_comment_create (create_by), - KEY FK_comment_modify (update_by), - KEY FK_comment_parent (parent_uid), - KEY FK_comment_root (root_comment_uid), - KEY FK_comment_thread (thread_comment_uid), - KEY IX_comment_level_sticky (comment_level,sticky), - CONSTRAINT FK_comment_create FOREIGN KEY (create_by) REFERENCES lams_user (user_id), - CONSTRAINT FK_comment_modify FOREIGN KEY (update_by) REFERENCES lams_user (user_id), - CONSTRAINT FK_comment_parent FOREIGN KEY (parent_uid) REFERENCES lams_comment (uid), - CONSTRAINT FK_comment_root FOREIGN KEY (root_comment_uid) REFERENCES lams_comment (uid), - CONSTRAINT FK_comment_session FOREIGN KEY (session_id) REFERENCES lams_comment_session (uid), - CONSTRAINT FK_comment_thread FOREIGN KEY (thread_comment_uid) REFERENCES lams_comment (uid) + uid bigint NOT NULL AUTO_INCREMENT, + session_id bigint NOT NULL, + body mediumtext, + create_by bigint DEFAULT NULL, + create_date datetime DEFAULT NULL, + update_date datetime DEFAULT NULL, + update_by bigint DEFAULT NULL, + last_modified datetime DEFAULT NULL, + last_reply_date datetime DEFAULT NULL, + reply_number int DEFAULT NULL, + hide_flag smallint DEFAULT NULL, + parent_uid bigint DEFAULT NULL, + root_comment_uid bigint DEFAULT NULL, + comment_level smallint DEFAULT NULL, + thread_comment_uid bigint DEFAULT NULL, + sticky smallint DEFAULT '0', + monitor smallint DEFAULT '0', + anonymous smallint DEFAULT '0', + PRIMARY KEY (uid), + KEY FK_comment_session (session_id), + KEY FK_comment_create (create_by), + KEY FK_comment_modify (update_by), + KEY FK_comment_parent (parent_uid), + KEY FK_comment_root (root_comment_uid), + KEY FK_comment_thread (thread_comment_uid), + KEY IX_comment_level_sticky (comment_level,sticky), + CONSTRAINT FK_comment_create FOREIGN KEY (create_by) REFERENCES lams_user (user_id), + CONSTRAINT FK_comment_modify FOREIGN KEY (update_by) REFERENCES lams_user (user_id), + CONSTRAINT FK_comment_parent FOREIGN KEY (parent_uid) REFERENCES lams_comment (uid), + CONSTRAINT FK_comment_root FOREIGN KEY (root_comment_uid) REFERENCES lams_comment (uid), + CONSTRAINT FK_comment_session FOREIGN KEY (session_id) REFERENCES lams_comment_session (uid), + CONSTRAINT FK_comment_thread FOREIGN KEY (thread_comment_uid) REFERENCES lams_comment (uid) ); DROP TABLE IF EXISTS lams_comment_likes; + CREATE TABLE lams_comment_likes ( - uid bigint NOT NULL AUTO_INCREMENT, - comment_uid bigint NOT NULL, - user_id bigint NOT NULL, - vote tinyint(1) DEFAULT NULL, - PRIMARY KEY (uid), - UNIQUE KEY comment_like_unique (comment_uid,user_id), - KEY FK_commentlike_comment (comment_uid), - KEY FK_commentlike_user (user_id), - CONSTRAINT FK_commentlike_comment FOREIGN KEY (comment_uid) REFERENCES lams_comment (uid), - CONSTRAINT FK_commentlike_user FOREIGN KEY (user_id) REFERENCES lams_user (user_id) + uid bigint NOT NULL AUTO_INCREMENT, + comment_uid bigint NOT NULL, + user_id bigint NOT NULL, + vote tinyint(1) DEFAULT NULL, + PRIMARY KEY (uid), + UNIQUE KEY comment_like_unique (comment_uid,user_id), + KEY FK_commentlike_comment (comment_uid), + KEY FK_commentlike_user (user_id), + CONSTRAINT FK_commentlike_comment FOREIGN KEY (comment_uid) REFERENCES lams_comment (uid), + CONSTRAINT FK_commentlike_user FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ); DROP TABLE IF EXISTS lams_comment_session; + CREATE TABLE lams_comment_session ( - uid bigint NOT NULL AUTO_INCREMENT, - external_id bigint DEFAULT NULL, - external_id_type int DEFAULT NULL, - external_signature varchar(40) DEFAULT NULL, - external_secondary_id bigint DEFAULT NULL, - PRIMARY KEY (uid), - KEY comment_ext_sig (external_id,external_signature) + uid bigint NOT NULL AUTO_INCREMENT, + external_id bigint DEFAULT NULL, + external_id_type int DEFAULT NULL, + external_signature varchar(40) DEFAULT NULL, + external_secondary_id bigint DEFAULT NULL, + PRIMARY KEY (uid), + KEY comment_ext_sig (external_id,external_signature) ); DROP TABLE IF EXISTS lams_competence; + CREATE TABLE lams_competence ( - competence_id bigint NOT NULL AUTO_INCREMENT, - learning_design_id bigint DEFAULT NULL, - `description` mediumtext, - title varchar(191) DEFAULT NULL, - PRIMARY KEY (competence_id), - UNIQUE KEY competence_id (competence_id), - UNIQUE KEY learning_design_id (learning_design_id,title), - CONSTRAINT LearningDesignCompetenceMap FOREIGN KEY (learning_design_id) REFERENCES lams_learning_design (learning_design_id) ON DELETE CASCADE ON UPDATE CASCADE + competence_id bigint NOT NULL AUTO_INCREMENT, + learning_design_id bigint DEFAULT NULL, + `description` mediumtext, + title varchar(191) DEFAULT NULL, + PRIMARY KEY (competence_id), + UNIQUE KEY competence_id (competence_id), + UNIQUE KEY learning_design_id (learning_design_id,title), + CONSTRAINT LearningDesignCompetenceMap FOREIGN KEY (learning_design_id) REFERENCES lams_learning_design (learning_design_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_competence_mapping; + CREATE TABLE lams_competence_mapping ( - competence_mapping_id bigint NOT NULL AUTO_INCREMENT, - competence_id bigint DEFAULT NULL, - activity_id bigint DEFAULT NULL, - PRIMARY KEY (competence_mapping_id), - UNIQUE KEY competence_mapping_id (competence_mapping_id), - UNIQUE KEY competence_id (competence_id,activity_id), - KEY activity_id (activity_id), - CONSTRAINT FK_lams_competence_mapping_1 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_competence_mapping_2 FOREIGN KEY (competence_id) REFERENCES lams_competence (competence_id) ON DELETE CASCADE ON UPDATE CASCADE + competence_mapping_id bigint NOT NULL AUTO_INCREMENT, + competence_id bigint DEFAULT NULL, + activity_id bigint DEFAULT NULL, + PRIMARY KEY (competence_mapping_id), + UNIQUE KEY competence_mapping_id (competence_mapping_id), + UNIQUE KEY competence_id (competence_id,activity_id), + KEY activity_id (activity_id), + CONSTRAINT FK_lams_competence_mapping_1 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_competence_mapping_2 FOREIGN KEY (competence_id) REFERENCES lams_competence (competence_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_configuration; + CREATE TABLE lams_configuration ( - config_key varchar(30) NOT NULL, - config_value varchar(255) DEFAULT NULL, - description_key varchar(255) DEFAULT NULL, - header_name varchar(50) DEFAULT NULL, - `format` varchar(30) DEFAULT NULL, - required tinyint(1) NOT NULL DEFAULT '0', - PRIMARY KEY (config_key) + config_key varchar(30) NOT NULL, + config_value varchar(255) DEFAULT NULL, + description_key varchar(255) DEFAULT NULL, + header_name varchar(50) DEFAULT NULL, + `format` varchar(30) DEFAULT NULL, + required tinyint(1) NOT NULL DEFAULT '0', + PRIMARY KEY (config_key) ); DROP TABLE IF EXISTS lams_copy_type; + CREATE TABLE lams_copy_type ( - copy_type_id tinyint NOT NULL, - `description` varchar(255) NOT NULL, - PRIMARY KEY (copy_type_id) + copy_type_id tinyint NOT NULL, + `description` varchar(255) NOT NULL, + PRIMARY KEY (copy_type_id) ); DROP TABLE IF EXISTS lams_cr_credential; + CREATE TABLE lams_cr_credential ( - credential_id bigint unsigned NOT NULL AUTO_INCREMENT, - `name` varchar(255) NOT NULL, - `password` varchar(255) NOT NULL, - PRIMARY KEY (credential_id) + credential_id bigint unsigned NOT NULL AUTO_INCREMENT, + `name` varchar(255) NOT NULL, + `password` varchar(255) NOT NULL, + PRIMARY KEY (credential_id) ); DROP TABLE IF EXISTS lams_cr_node; + CREATE TABLE lams_cr_node ( - node_id bigint unsigned NOT NULL AUTO_INCREMENT, - portrait_uuid binary(16) DEFAULT NULL, - workspace_id bigint unsigned NOT NULL, - `path` varchar(255) DEFAULT NULL, - `type` varchar(255) NOT NULL, - created_date_time datetime NOT NULL, - next_version_id bigint unsigned NOT NULL DEFAULT '1', - parent_nv_id bigint unsigned DEFAULT NULL, - PRIMARY KEY (node_id), - UNIQUE KEY IDX_portrait_uuid (portrait_uuid), - KEY workspace_id (workspace_id), - CONSTRAINT FK_lams_cr_node_1 FOREIGN KEY (workspace_id) REFERENCES lams_cr_workspace (workspace_id) + node_id bigint unsigned NOT NULL AUTO_INCREMENT, + uuid binary(16) DEFAULT NULL, + workspace_id bigint unsigned NOT NULL, + `path` varchar(255) DEFAULT NULL, + `type` varchar(255) NOT NULL, + created_date_time datetime NOT NULL, + next_version_id bigint unsigned NOT NULL DEFAULT '1', + parent_nv_id bigint unsigned DEFAULT NULL, + PRIMARY KEY (node_id), + UNIQUE KEY IDX_uuid (uuid), + KEY workspace_id (workspace_id), + CONSTRAINT FK_lams_cr_node_1 FOREIGN KEY (workspace_id) REFERENCES lams_cr_workspace (workspace_id) ); DROP TABLE IF EXISTS lams_cr_node_version; + CREATE TABLE lams_cr_node_version ( - nv_id bigint unsigned NOT NULL AUTO_INCREMENT, - node_id bigint unsigned NOT NULL, - version_id bigint unsigned NOT NULL, - created_date_time datetime NOT NULL, - user_id bigint NOT NULL, - PRIMARY KEY (nv_id), - KEY node_id (node_id), - CONSTRAINT FK_lams_cr_node_version_2 FOREIGN KEY (node_id) REFERENCES lams_cr_node (node_id) + nv_id bigint unsigned NOT NULL AUTO_INCREMENT, + node_id bigint unsigned NOT NULL, + version_id bigint unsigned NOT NULL, + created_date_time datetime NOT NULL, + user_id bigint NOT NULL, + PRIMARY KEY (nv_id), + KEY node_id (node_id), + CONSTRAINT FK_lams_cr_node_version_2 FOREIGN KEY (node_id) REFERENCES lams_cr_node (node_id) ); DROP TABLE IF EXISTS lams_cr_node_version_property; + CREATE TABLE lams_cr_node_version_property ( - id bigint unsigned NOT NULL AUTO_INCREMENT, - nv_id bigint unsigned NOT NULL, - `name` varchar(255) NOT NULL, - `value` varchar(255) NOT NULL, - `type` tinyint NOT NULL, - PRIMARY KEY (id), - KEY nv_id (nv_id), - CONSTRAINT FK_lams_cr_node_version_property_1 FOREIGN KEY (nv_id) REFERENCES lams_cr_node_version (nv_id) + id bigint unsigned NOT NULL AUTO_INCREMENT, + nv_id bigint unsigned NOT NULL, + `name` varchar(255) NOT NULL, + `value` varchar(255) NOT NULL, + `type` tinyint NOT NULL, + PRIMARY KEY (id), + KEY nv_id (nv_id), + CONSTRAINT FK_lams_cr_node_version_property_1 FOREIGN KEY (nv_id) REFERENCES lams_cr_node_version (nv_id) ); DROP TABLE IF EXISTS lams_cr_workspace; + CREATE TABLE lams_cr_workspace ( - workspace_id bigint unsigned NOT NULL AUTO_INCREMENT, - `name` varchar(255) NOT NULL, - PRIMARY KEY (workspace_id) + workspace_id bigint unsigned NOT NULL AUTO_INCREMENT, + `name` varchar(255) NOT NULL, + PRIMARY KEY (workspace_id) ); DROP TABLE IF EXISTS lams_cr_workspace_credential; + CREATE TABLE lams_cr_workspace_credential ( - wc_id bigint unsigned NOT NULL AUTO_INCREMENT, - workspace_id bigint unsigned NOT NULL, - credential_id bigint unsigned NOT NULL, - PRIMARY KEY (wc_id), - KEY workspace_id (workspace_id), - KEY credential_id (credential_id), - CONSTRAINT FK_lams_cr_workspace_credential_1 FOREIGN KEY (workspace_id) REFERENCES lams_cr_workspace (workspace_id), - CONSTRAINT FK_lams_cr_workspace_credential_2 FOREIGN KEY (credential_id) REFERENCES lams_cr_credential (credential_id) + wc_id bigint unsigned NOT NULL AUTO_INCREMENT, + workspace_id bigint unsigned NOT NULL, + credential_id bigint unsigned NOT NULL, + PRIMARY KEY (wc_id), + KEY workspace_id (workspace_id), + KEY credential_id (credential_id), + CONSTRAINT FK_lams_cr_workspace_credential_1 FOREIGN KEY (workspace_id) REFERENCES lams_cr_workspace (workspace_id), + CONSTRAINT FK_lams_cr_workspace_credential_2 FOREIGN KEY (credential_id) REFERENCES lams_cr_credential (credential_id) ); DROP TABLE IF EXISTS lams_data_flow; + CREATE TABLE lams_data_flow ( - data_flow_object_id bigint NOT NULL AUTO_INCREMENT, - transition_id bigint NOT NULL, - order_id int DEFAULT NULL, - `name` varchar(255) NOT NULL, - display_name varchar(255) DEFAULT NULL, - tool_assigment_id int DEFAULT NULL, - PRIMARY KEY (data_flow_object_id), - KEY FK_lams_learning_transition_1 (transition_id), - CONSTRAINT FK_lams_learning_transition_1 FOREIGN KEY (transition_id) REFERENCES lams_learning_transition (transition_id) ON DELETE CASCADE ON UPDATE CASCADE + data_flow_object_id bigint NOT NULL AUTO_INCREMENT, + transition_id bigint NOT NULL, + order_id int DEFAULT NULL, + `name` varchar(255) NOT NULL, + display_name varchar(255) DEFAULT NULL, + tool_assigment_id int DEFAULT NULL, + PRIMARY KEY (data_flow_object_id), + KEY FK_lams_learning_transition_1 (transition_id), + CONSTRAINT FK_lams_learning_transition_1 FOREIGN KEY (transition_id) REFERENCES lams_learning_transition (transition_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_discussion_sentiment; + CREATE TABLE lams_discussion_sentiment ( - uid bigint NOT NULL AUTO_INCREMENT, - lesson_id bigint NOT NULL, - tool_question_uid bigint NOT NULL, - burning_question_uid bigint DEFAULT NULL, - user_id bigint DEFAULT NULL, - selected_option tinyint unsigned DEFAULT NULL, - PRIMARY KEY (uid), - UNIQUE KEY UQ_lams_discussion_sentiment_2 (lesson_id,tool_question_uid,burning_question_uid,user_id), - KEY IDX_lams_discussion_sentiment_1 (burning_question_uid), - KEY FK_lams_discussion_sentiment_2 (tool_question_uid), - KEY FK_lams_discussion_sentiment_3 (user_id), - CONSTRAINT FK_lams_discussion_sentiment_1 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_discussion_sentiment_2 FOREIGN KEY (tool_question_uid) REFERENCES lams_qb_tool_question (tool_question_uid) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_discussion_sentiment_3 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE + uid bigint NOT NULL AUTO_INCREMENT, + lesson_id bigint NOT NULL, + tool_question_uid bigint NOT NULL, + burning_question_uid bigint DEFAULT NULL, + user_id bigint DEFAULT NULL, + selected_option tinyint unsigned DEFAULT NULL, + PRIMARY KEY (uid), + UNIQUE KEY UQ_lams_discussion_sentiment_2 (lesson_id,tool_question_uid,burning_question_uid,user_id), + KEY IDX_lams_discussion_sentiment_1 (burning_question_uid), + KEY FK_lams_discussion_sentiment_2 (tool_question_uid), + KEY FK_lams_discussion_sentiment_3 (user_id), + CONSTRAINT FK_lams_discussion_sentiment_1 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_discussion_sentiment_2 FOREIGN KEY (tool_question_uid) REFERENCES lams_qb_tool_question (tool_question_uid) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_discussion_sentiment_3 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_email_notification_archive; + CREATE TABLE lams_email_notification_archive ( - uid bigint NOT NULL AUTO_INCREMENT, - organisation_id bigint DEFAULT NULL, - lesson_id bigint DEFAULT NULL, - search_type tinyint NOT NULL, - sent_on datetime NOT NULL, - body mediumtext, - PRIMARY KEY (uid), - KEY FK_lams_email_notification_archive_1 (organisation_id), - KEY FK_lams_email_notification_archive_2 (lesson_id), - CONSTRAINT FK_lams_email_notification_archive_1 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_email_notification_archive_2 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE + uid bigint NOT NULL AUTO_INCREMENT, + organisation_id bigint DEFAULT NULL, + lesson_id bigint DEFAULT NULL, + search_type tinyint NOT NULL, + sent_on datetime NOT NULL, + body mediumtext, + PRIMARY KEY (uid), + KEY FK_lams_email_notification_archive_1 (organisation_id), + KEY FK_lams_email_notification_archive_2 (lesson_id), + CONSTRAINT FK_lams_email_notification_archive_1 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_email_notification_archive_2 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_email_notification_recipient_archive; + CREATE TABLE lams_email_notification_recipient_archive ( - email_notification_uid bigint NOT NULL, - user_id bigint NOT NULL, - KEY FK_lams_email_notification_recipient_archive_1 (email_notification_uid), - KEY FK_lams_email_notification_recipient_archive_2 (user_id), - CONSTRAINT FK_lams_email_notification_recipient_archive_1 FOREIGN KEY (email_notification_uid) REFERENCES lams_email_notification_archive (uid) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_email_notification_recipient_archive_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE + email_notification_uid bigint NOT NULL, + user_id bigint NOT NULL, + KEY FK_lams_email_notification_recipient_archive_1 (email_notification_uid), + KEY FK_lams_email_notification_recipient_archive_2 (user_id), + CONSTRAINT FK_lams_email_notification_recipient_archive_1 FOREIGN KEY (email_notification_uid) REFERENCES lams_email_notification_archive (uid) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_email_notification_recipient_archive_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_ext_course_class_map; + CREATE TABLE lams_ext_course_class_map ( - sid int NOT NULL AUTO_INCREMENT, - courseid varchar(255) NOT NULL, - classid bigint NOT NULL, - ext_server_org_map_id int NOT NULL, - PRIMARY KEY (sid), - KEY classid (classid), - KEY ext_server_org_map_id (ext_server_org_map_id), - CONSTRAINT lams_ext_course_class_map_fk FOREIGN KEY (classid) REFERENCES lams_organisation (organisation_id), - CONSTRAINT lams_ext_course_class_map_fk1 FOREIGN KEY (ext_server_org_map_id) REFERENCES lams_ext_server_org_map (sid) ON DELETE CASCADE ON UPDATE CASCADE + sid int NOT NULL AUTO_INCREMENT, + courseid varchar(255) NOT NULL, + classid bigint NOT NULL, + ext_server_org_map_id int NOT NULL, + PRIMARY KEY (sid), + KEY classid (classid), + KEY ext_server_org_map_id (ext_server_org_map_id), + CONSTRAINT lams_ext_course_class_map_fk FOREIGN KEY (classid) REFERENCES lams_organisation (organisation_id), + CONSTRAINT lams_ext_course_class_map_fk1 FOREIGN KEY (ext_server_org_map_id) REFERENCES lams_ext_server_org_map (sid) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_ext_server_lesson_map; + CREATE TABLE lams_ext_server_lesson_map ( - uid bigint NOT NULL AUTO_INCREMENT, - lesson_id bigint NOT NULL, - ext_server_org_map_id int NOT NULL, - resource_link_id varchar(255) DEFAULT NULL, - PRIMARY KEY (uid), - UNIQUE KEY lesson_id (lesson_id), - KEY lams_ext_server_lesson_map_fk1 (ext_server_org_map_id), - CONSTRAINT lams_ext_server_lesson_map_fk1 FOREIGN KEY (ext_server_org_map_id) REFERENCES lams_ext_server_org_map (sid) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT lams_ext_server_lesson_map_fk2 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE + uid bigint NOT NULL AUTO_INCREMENT, + lesson_id bigint NOT NULL, + ext_server_org_map_id int NOT NULL, + resource_link_id varchar(255) DEFAULT NULL, + lti_adv_deployment_id varchar(255) DEFAULT NULL, + lti_adv_grading_type varchar(10) DEFAULT NULL, + lti_adv_grading_url varchar(255) DEFAULT NULL, + PRIMARY KEY (uid), + UNIQUE KEY lesson_id (lesson_id), + KEY lams_ext_server_lesson_map_fk1 (ext_server_org_map_id), + CONSTRAINT lams_ext_server_lesson_map_fk1 FOREIGN KEY (ext_server_org_map_id) REFERENCES lams_ext_server_org_map (sid) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT lams_ext_server_lesson_map_fk2 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_ext_server_org_map; + CREATE TABLE lams_ext_server_org_map ( - sid int NOT NULL AUTO_INCREMENT, - serverid varchar(191) NOT NULL, - serverkey text NOT NULL, - servername varchar(255) NOT NULL, - serverdesc mediumtext, - prefix varchar(11) NOT NULL, - userinfo_url text NOT NULL, - lesson_finish_url text, - logout_url text, - disabled bit(1) NOT NULL, - time_to_live_login_request int DEFAULT '80', - time_to_live_login_request_enabled tinyint(1) NOT NULL DEFAULT '0', - ext_groups_url text, - server_type_id int NOT NULL DEFAULT '1', - lti_consumer_monitor_roles text, - learner_presence_avail tinyint(1) DEFAULT '0', - learner_im_avail tinyint(1) DEFAULT '0', - live_edit_enabled tinyint(1) DEFAULT '1', - enable_lesson_notifications tinyint(1) DEFAULT '1', - force_restart tinyint(1) DEFAULT '0', - allow_restart tinyint(1) DEFAULT '0', - gradebook_on_complete tinyint(1) DEFAULT '1', - membership_url text, - user_id_parameter_name varchar(255) DEFAULT NULL, - PRIMARY KEY (sid), - UNIQUE KEY serverid (serverid), - UNIQUE KEY prefix (prefix), - KEY FK_lams_ext_server_type (server_type_id), - CONSTRAINT FK_lams_ext_server_type FOREIGN KEY (server_type_id) REFERENCES lams_ext_server_type (server_type_id) + sid int NOT NULL AUTO_INCREMENT, + serverid varchar(191) NOT NULL, + serverkey text NOT NULL, + servername varchar(255) NOT NULL, + serverdesc mediumtext, + prefix varchar(11) NOT NULL, + userinfo_url text NOT NULL, + lesson_finish_url text, + logout_url text, + disabled bit(1) NOT NULL, + time_to_live_login_request int DEFAULT '80', + time_to_live_login_request_enabled tinyint(1) NOT NULL DEFAULT '0', + add_staff_to_all_lessons tinyint NOT NULL DEFAULT '0', + ext_groups_url text, + server_type_id int NOT NULL DEFAULT '1', + lti_consumer_monitor_roles text, + learner_presence_avail tinyint(1) DEFAULT '0', + learner_im_avail tinyint(1) DEFAULT '0', + live_edit_enabled tinyint(1) DEFAULT '1', + enable_lesson_notifications tinyint(1) DEFAULT '1', + force_restart tinyint(1) DEFAULT '0', + allow_restart tinyint(1) DEFAULT '0', + gradebook_on_complete tinyint(1) DEFAULT '1', + membership_url text, + user_id_parameter_name varchar(255) DEFAULT NULL, + default_country char(2) DEFAULT NULL, + default_locale_id tinyint unsigned DEFAULT NULL, + default_timezone varchar(255) DEFAULT NULL, + use_course_prefix tinyint NOT NULL DEFAULT '1', + user_registration_enabled tinyint NOT NULL DEFAULT '1', + user_name_lower_case tinyint NOT NULL DEFAULT '0', + lti_adv_enforce_cookie tinyint NOT NULL DEFAULT '0', + lti_adv_reregistration_enabled tinyint NOT NULL DEFAULT '1', + lti_adv_issuer varchar(64) DEFAULT NULL, + lti_adv_client_id varchar(64) DEFAULT NULL, + lti_adv_platform_key_set_url varchar(255) DEFAULT NULL, + lti_adv_oidc_auth_url varchar(255) DEFAULT NULL, + lti_adv_access_token_url varchar(255) DEFAULT NULL, + lti_adv_tool_name varchar(64) DEFAULT NULL, + lti_adv_tool_description varchar(255) DEFAULT NULL, + lti_adv_tool_key_set_url varchar(255) DEFAULT NULL, + lti_adv_tool_key_id varchar(32) DEFAULT NULL, + lti_adv_public_key text, + lti_adv_private_key text, + PRIMARY KEY (sid), + UNIQUE KEY serverid (serverid), + KEY FK_lams_ext_server_type (server_type_id), + CONSTRAINT FK_lams_ext_server_type FOREIGN KEY (server_type_id) REFERENCES lams_ext_server_type (server_type_id) ); DROP TABLE IF EXISTS lams_ext_server_tool_map; + CREATE TABLE lams_ext_server_tool_map ( - uid bigint NOT NULL AUTO_INCREMENT, - tool_id bigint NOT NULL, - ext_server_org_map_id int NOT NULL, - PRIMARY KEY (uid), - UNIQUE KEY unique_adapter_map (ext_server_org_map_id,tool_id), - KEY lams_ext_server_tool_map_fk2 (tool_id), - CONSTRAINT lams_ext_server_tool_map_fk1 FOREIGN KEY (ext_server_org_map_id) REFERENCES lams_ext_server_org_map (sid) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT lams_ext_server_tool_map_fk2 FOREIGN KEY (tool_id) REFERENCES lams_tool (tool_id) ON DELETE CASCADE ON UPDATE CASCADE + uid bigint NOT NULL AUTO_INCREMENT, + tool_id bigint NOT NULL, + ext_server_org_map_id int NOT NULL, + PRIMARY KEY (uid), + UNIQUE KEY unique_adapter_map (ext_server_org_map_id,tool_id), + KEY lams_ext_server_tool_map_fk2 (tool_id), + CONSTRAINT lams_ext_server_tool_map_fk1 FOREIGN KEY (ext_server_org_map_id) REFERENCES lams_ext_server_org_map (sid) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT lams_ext_server_tool_map_fk2 FOREIGN KEY (tool_id) REFERENCES lams_tool (tool_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_ext_server_type; + CREATE TABLE lams_ext_server_type ( - server_type_id int NOT NULL, - `description` varchar(255) NOT NULL, - PRIMARY KEY (server_type_id) + server_type_id int NOT NULL, + `description` varchar(255) NOT NULL, + PRIMARY KEY (server_type_id) ); DROP TABLE IF EXISTS lams_ext_user_userid_map; + CREATE TABLE lams_ext_user_userid_map ( - sid int NOT NULL AUTO_INCREMENT, - external_username varchar(250) NOT NULL, - user_id bigint NOT NULL, - ext_server_org_map_id int NOT NULL, - tc_gradebook_id text, - PRIMARY KEY (sid), - KEY user_id (user_id), - KEY ext_server_org_map_id (ext_server_org_map_id), - CONSTRAINT lams_ext_user_userid_map_fk FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT lams_ext_user_userid_map_fk1 FOREIGN KEY (ext_server_org_map_id) REFERENCES lams_ext_server_org_map (sid) ON DELETE CASCADE ON UPDATE CASCADE + sid int NOT NULL AUTO_INCREMENT, + external_username varchar(250) NOT NULL, + lti_adv_username varchar(250) DEFAULT NULL, + user_id bigint NOT NULL, + ext_server_org_map_id int NOT NULL, + tc_gradebook_id text, + PRIMARY KEY (sid), + UNIQUE KEY UQ_lams_ext_user_userid_map_1 (ext_server_org_map_id,external_username), + KEY user_id (user_id), + KEY ext_server_org_map_id (ext_server_org_map_id), + KEY UQ_lams_ext_user_userid_map_2 (external_username), + CONSTRAINT lams_ext_user_userid_map_fk FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT lams_ext_user_userid_map_fk1 FOREIGN KEY (ext_server_org_map_id) REFERENCES lams_ext_server_org_map (sid) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_favorite_organisation; + CREATE TABLE lams_favorite_organisation ( - favorite_organisation_id bigint NOT NULL AUTO_INCREMENT, - organisation_id bigint NOT NULL, - user_id bigint NOT NULL, - PRIMARY KEY (favorite_organisation_id), - KEY organisation_id (organisation_id), - KEY user_id (user_id), - CONSTRAINT FK_lams_favorite_organisation_1 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id), - CONSTRAINT FK_lams_favorite_organisation_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) + favorite_organisation_id bigint NOT NULL AUTO_INCREMENT, + organisation_id bigint NOT NULL, + user_id bigint NOT NULL, + PRIMARY KEY (favorite_organisation_id), + KEY organisation_id (organisation_id), + KEY user_id (user_id), + CONSTRAINT FK_lams_favorite_organisation_1 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id), + CONSTRAINT FK_lams_favorite_organisation_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ); DROP TABLE IF EXISTS lams_gate_activity_level; + CREATE TABLE lams_gate_activity_level ( - gate_activity_level_id int NOT NULL, - `description` varchar(128) NOT NULL, - PRIMARY KEY (gate_activity_level_id) + gate_activity_level_id int NOT NULL, + `description` varchar(128) NOT NULL, + PRIMARY KEY (gate_activity_level_id) ); DROP TABLE IF EXISTS lams_gate_allowed_learners; + CREATE TABLE lams_gate_allowed_learners ( - user_id bigint NOT NULL, - activity_id bigint NOT NULL, - KEY user_id (user_id), - KEY activity_id (activity_id), - CONSTRAINT FK_TABLE_32_1 FOREIGN KEY (user_id) REFERENCES lams_user (user_id), - CONSTRAINT FK_TABLE_32_2 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) + user_id bigint NOT NULL, + activity_id bigint NOT NULL, + KEY user_id (user_id), + KEY activity_id (activity_id), + CONSTRAINT FK_TABLE_32_1 FOREIGN KEY (user_id) REFERENCES lams_user (user_id), + CONSTRAINT FK_TABLE_32_2 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ); DROP TABLE IF EXISTS lams_gradebook_user_activity; + CREATE TABLE lams_gradebook_user_activity ( - uid bigint NOT NULL AUTO_INCREMENT, - activity_id bigint NOT NULL, - user_id bigint NOT NULL, - mark double DEFAULT NULL, - feedback mediumtext, - marked_in_gradebook tinyint(1) NOT NULL DEFAULT '0', - update_date datetime DEFAULT NULL, - PRIMARY KEY (uid), - UNIQUE KEY UQ_lams_gradebook_user_activity_1 (activity_id,user_id), - KEY FK_lams_gradebook_user_activity_2 (user_id), - CONSTRAINT FK_lams_gradebook_user_activity_1 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_gradebook_user_activity_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE + uid bigint NOT NULL AUTO_INCREMENT, + activity_id bigint NOT NULL, + user_id bigint NOT NULL, + mark double DEFAULT NULL, + feedback mediumtext, + marked_in_gradebook tinyint(1) NOT NULL DEFAULT '0', + update_date datetime DEFAULT NULL, + PRIMARY KEY (uid), + UNIQUE KEY UQ_lams_gradebook_user_activity_1 (activity_id,user_id), + KEY FK_lams_gradebook_user_activity_2 (user_id), + CONSTRAINT FK_lams_gradebook_user_activity_1 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_gradebook_user_activity_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_gradebook_user_activity_archive; + CREATE TABLE lams_gradebook_user_activity_archive ( - uid bigint NOT NULL, - activity_id bigint NOT NULL, - user_id bigint NOT NULL, - mark double DEFAULT NULL, - feedback mediumtext, - marked_in_gradebook tinyint(1) NOT NULL DEFAULT '0', - update_date datetime DEFAULT NULL, - archive_date datetime DEFAULT NULL, - PRIMARY KEY (uid), - KEY activity_id (activity_id,user_id), - KEY FK_lams_gradebook_user_activity_archive_2 (user_id), - CONSTRAINT FK_lams_gradebook_user_activity_archive_1 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_gradebook_user_activity_archive_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE + uid bigint NOT NULL, + activity_id bigint NOT NULL, + user_id bigint NOT NULL, + mark double DEFAULT NULL, + feedback mediumtext, + marked_in_gradebook tinyint(1) NOT NULL DEFAULT '0', + update_date datetime DEFAULT NULL, + archive_date datetime DEFAULT NULL, + PRIMARY KEY (uid), + KEY activity_id (activity_id,user_id), + KEY FK_lams_gradebook_user_activity_archive_2 (user_id), + CONSTRAINT FK_lams_gradebook_user_activity_archive_1 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_gradebook_user_activity_archive_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_gradebook_user_lesson; + CREATE TABLE lams_gradebook_user_lesson ( - uid bigint NOT NULL AUTO_INCREMENT, - lesson_id bigint NOT NULL, - user_id bigint NOT NULL, - mark double DEFAULT NULL, - feedback text, - PRIMARY KEY (uid), - UNIQUE KEY lesson_id (lesson_id,user_id), - KEY FK_lams_gradebook_user_lesson_2 (user_id), - CONSTRAINT FK_lams_gradebook_user_lesson_1 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id), - CONSTRAINT FK_lams_gradebook_user_lesson_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE + uid bigint NOT NULL AUTO_INCREMENT, + lesson_id bigint NOT NULL, + user_id bigint NOT NULL, + mark double DEFAULT NULL, + feedback text, + PRIMARY KEY (uid), + UNIQUE KEY lesson_id (lesson_id,user_id), + KEY FK_lams_gradebook_user_lesson_2 (user_id), + CONSTRAINT FK_lams_gradebook_user_lesson_1 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id), + CONSTRAINT FK_lams_gradebook_user_lesson_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_gradebook_user_lesson_archive; + CREATE TABLE lams_gradebook_user_lesson_archive ( - uid bigint NOT NULL, - lesson_id bigint NOT NULL, - user_id bigint NOT NULL, - mark double DEFAULT NULL, - feedback mediumtext, - archive_date datetime DEFAULT NULL, - PRIMARY KEY (uid), - KEY lesson_id (lesson_id,user_id), - KEY FK_lams_gradebook_user_lesson_archive_2 (user_id), - CONSTRAINT FK_lams_gradebook_user_lesson_archive_1 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_gradebook_user_lesson_archive_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE + uid bigint NOT NULL, + lesson_id bigint NOT NULL, + user_id bigint NOT NULL, + mark double DEFAULT NULL, + feedback mediumtext, + archive_date datetime DEFAULT NULL, + PRIMARY KEY (uid), + KEY lesson_id (lesson_id,user_id), + KEY FK_lams_gradebook_user_lesson_archive_2 (user_id), + CONSTRAINT FK_lams_gradebook_user_lesson_archive_1 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_gradebook_user_lesson_archive_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_group; + CREATE TABLE lams_group ( - group_id bigint NOT NULL AUTO_INCREMENT, - group_name varchar(255) NOT NULL, - grouping_id bigint NOT NULL, - order_id int NOT NULL DEFAULT '1', - group_ui_id int DEFAULT NULL, - PRIMARY KEY (group_id), - UNIQUE KEY UQ_lams_group_1 (grouping_id,order_id), - KEY grouping_id (grouping_id), - CONSTRAINT FK_lams_learning_group_1 FOREIGN KEY (grouping_id) REFERENCES lams_grouping (grouping_id) + group_id bigint NOT NULL AUTO_INCREMENT, + group_name varchar(255) NOT NULL, + grouping_id bigint NOT NULL, + order_id int NOT NULL DEFAULT '1', + group_ui_id int DEFAULT NULL, + PRIMARY KEY (group_id), + UNIQUE KEY UQ_lams_group_1 (grouping_id,order_id), + KEY grouping_id (grouping_id), + CONSTRAINT FK_lams_learning_group_1 FOREIGN KEY (grouping_id) REFERENCES lams_grouping (grouping_id) ); DROP TABLE IF EXISTS lams_grouping; + CREATE TABLE lams_grouping ( - grouping_id bigint NOT NULL AUTO_INCREMENT, - grouping_ui_id int DEFAULT NULL, - grouping_type_id int NOT NULL, - number_of_groups int DEFAULT NULL, - learners_per_group int DEFAULT NULL, - staff_group_id bigint DEFAULT '0', - max_number_of_groups int DEFAULT NULL, - equal_number_of_learners_per_group tinyint(1) DEFAULT '0', - view_students_before_selection tinyint(1) DEFAULT '0', - PRIMARY KEY (grouping_id), - KEY grouping_type_id (grouping_type_id), - CONSTRAINT FK_lams_learning_grouping_1 FOREIGN KEY (grouping_type_id) REFERENCES lams_grouping_type (grouping_type_id) + grouping_id bigint NOT NULL AUTO_INCREMENT, + grouping_ui_id int DEFAULT NULL, + grouping_type_id int NOT NULL, + number_of_groups int DEFAULT NULL, + learners_per_group int DEFAULT NULL, + staff_group_id bigint DEFAULT '0', + max_number_of_groups int DEFAULT NULL, + equal_number_of_learners_per_group tinyint(1) DEFAULT '0', + view_students_before_selection tinyint(1) DEFAULT '0', + PRIMARY KEY (grouping_id), + KEY grouping_type_id (grouping_type_id), + CONSTRAINT FK_lams_learning_grouping_1 FOREIGN KEY (grouping_type_id) REFERENCES lams_grouping_type (grouping_type_id) ); DROP TABLE IF EXISTS lams_grouping_support_type; + CREATE TABLE lams_grouping_support_type ( - grouping_support_type_id int NOT NULL, - `description` varchar(64) NOT NULL, - PRIMARY KEY (grouping_support_type_id) + grouping_support_type_id int NOT NULL, + `description` varchar(64) NOT NULL, + PRIMARY KEY (grouping_support_type_id) ); DROP TABLE IF EXISTS lams_grouping_type; + CREATE TABLE lams_grouping_type ( - grouping_type_id int NOT NULL, - `description` varchar(128) NOT NULL, - PRIMARY KEY (grouping_type_id) + grouping_type_id int NOT NULL, + `description` varchar(128) NOT NULL, + PRIMARY KEY (grouping_type_id) ); DROP TABLE IF EXISTS lams_input_activity; + CREATE TABLE lams_input_activity ( - activity_id bigint NOT NULL, - input_activity_id bigint NOT NULL, - UNIQUE KEY UQ_lams_input_activity_1 (activity_id,input_activity_id), - KEY activity_id (activity_id), - CONSTRAINT FK_lams_input_activity_1 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id), - CONSTRAINT FK_lams_input_activity_2 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) + activity_id bigint NOT NULL, + input_activity_id bigint NOT NULL, + UNIQUE KEY UQ_lams_input_activity_1 (activity_id,input_activity_id), + KEY activity_id (activity_id), + CONSTRAINT FK_lams_input_activity_1 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id), + CONSTRAINT FK_lams_input_activity_2 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ); DROP TABLE IF EXISTS lams_kumalive; + CREATE TABLE lams_kumalive ( - kumalive_id bigint NOT NULL AUTO_INCREMENT, - organisation_id bigint NOT NULL, - created_by bigint DEFAULT NULL, - finished tinyint(1) NOT NULL DEFAULT '0', - `name` varchar(250) DEFAULT NULL, - PRIMARY KEY (kumalive_id), - KEY FK_lams_kumalive_1 (organisation_id), - KEY FK_lams_kumalive_2 (created_by), - CONSTRAINT FK_lams_kumalive_1 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_kumalive_2 FOREIGN KEY (created_by) REFERENCES lams_user (user_id) ON DELETE SET NULL ON UPDATE CASCADE + kumalive_id bigint NOT NULL AUTO_INCREMENT, + organisation_id bigint NOT NULL, + created_by bigint DEFAULT NULL, + finished tinyint(1) NOT NULL DEFAULT '0', + `name` varchar(250) DEFAULT NULL, + PRIMARY KEY (kumalive_id), + KEY FK_lams_kumalive_1 (organisation_id), + KEY FK_lams_kumalive_2 (created_by), + CONSTRAINT FK_lams_kumalive_1 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_kumalive_2 FOREIGN KEY (created_by) REFERENCES lams_user (user_id) ON DELETE SET NULL ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_kumalive_log; + CREATE TABLE lams_kumalive_log ( - log_id bigint NOT NULL AUTO_INCREMENT, - kumalive_id bigint NOT NULL, - user_id bigint DEFAULT NULL, - log_date datetime NOT NULL, - log_type tinyint DEFAULT NULL, - PRIMARY KEY (log_id), - KEY FK_lams_kumalive_log_1 (kumalive_id), - KEY FK_lams_kumalive_log_2 (user_id), - CONSTRAINT FK_lams_kumalive_log_1 FOREIGN KEY (kumalive_id) REFERENCES lams_kumalive (kumalive_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_kumalive_log_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE SET NULL ON UPDATE CASCADE + log_id bigint NOT NULL AUTO_INCREMENT, + kumalive_id bigint NOT NULL, + user_id bigint DEFAULT NULL, + log_date datetime NOT NULL, + log_type tinyint DEFAULT NULL, + PRIMARY KEY (log_id), + KEY FK_lams_kumalive_log_1 (kumalive_id), + KEY FK_lams_kumalive_log_2 (user_id), + CONSTRAINT FK_lams_kumalive_log_1 FOREIGN KEY (kumalive_id) REFERENCES lams_kumalive (kumalive_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_kumalive_log_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE SET NULL ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_kumalive_poll; + CREATE TABLE lams_kumalive_poll ( - poll_id bigint NOT NULL AUTO_INCREMENT, - kumalive_id bigint NOT NULL, - `name` varchar(250) DEFAULT NULL, - votes_released tinyint(1) DEFAULT '0', - voters_released tinyint(1) DEFAULT '0', - start_date datetime NOT NULL, - finish_date datetime DEFAULT NULL, - PRIMARY KEY (poll_id), - KEY FK_lams_kumalive_poll_1 (kumalive_id), - CONSTRAINT FK_lams_kumalive_poll_1 FOREIGN KEY (kumalive_id) REFERENCES lams_kumalive (kumalive_id) ON DELETE CASCADE ON UPDATE CASCADE + poll_id bigint NOT NULL AUTO_INCREMENT, + kumalive_id bigint NOT NULL, + `name` varchar(250) DEFAULT NULL, + votes_released tinyint(1) DEFAULT '0', + voters_released tinyint(1) DEFAULT '0', + start_date datetime NOT NULL, + finish_date datetime DEFAULT NULL, + PRIMARY KEY (poll_id), + KEY FK_lams_kumalive_poll_1 (kumalive_id), + CONSTRAINT FK_lams_kumalive_poll_1 FOREIGN KEY (kumalive_id) REFERENCES lams_kumalive (kumalive_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_kumalive_poll_answer; + CREATE TABLE lams_kumalive_poll_answer ( - answer_id bigint NOT NULL AUTO_INCREMENT, - poll_id bigint NOT NULL, - order_id tinyint NOT NULL, - `name` varchar(250) DEFAULT NULL, - PRIMARY KEY (answer_id), - KEY FK_lams_kumalive_poll_answer_1 (poll_id), - CONSTRAINT FK_lams_kumalive_poll_answer_1 FOREIGN KEY (poll_id) REFERENCES lams_kumalive_poll (poll_id) ON DELETE CASCADE ON UPDATE CASCADE + answer_id bigint NOT NULL AUTO_INCREMENT, + poll_id bigint NOT NULL, + order_id tinyint NOT NULL, + `name` varchar(250) DEFAULT NULL, + PRIMARY KEY (answer_id), + KEY FK_lams_kumalive_poll_answer_1 (poll_id), + CONSTRAINT FK_lams_kumalive_poll_answer_1 FOREIGN KEY (poll_id) REFERENCES lams_kumalive_poll (poll_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_kumalive_poll_vote; + CREATE TABLE lams_kumalive_poll_vote ( - answer_id bigint NOT NULL, - user_id bigint NOT NULL, - vote_date datetime DEFAULT NULL, - PRIMARY KEY (answer_id,user_id), - KEY FK_lams_kumalive_poll_vote_2 (user_id), - CONSTRAINT FK_lams_kumalive_poll_vote_1 FOREIGN KEY (answer_id) REFERENCES lams_kumalive_poll_answer (answer_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_kumalive_poll_vote_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE + answer_id bigint NOT NULL, + user_id bigint NOT NULL, + vote_date datetime DEFAULT NULL, + PRIMARY KEY (answer_id,user_id), + KEY FK_lams_kumalive_poll_vote_2 (user_id), + CONSTRAINT FK_lams_kumalive_poll_vote_1 FOREIGN KEY (answer_id) REFERENCES lams_kumalive_poll_answer (answer_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_kumalive_poll_vote_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_kumalive_rubric; + CREATE TABLE lams_kumalive_rubric ( - rubric_id bigint NOT NULL AUTO_INCREMENT, - organisation_id bigint NOT NULL, - kumalive_id bigint DEFAULT NULL, - order_id tinyint NOT NULL, - `name` varchar(250) DEFAULT NULL, - PRIMARY KEY (rubric_id), - KEY FK_lams_kumalive_rubric_1 (organisation_id), - KEY FK_lams_kumalive_rubric_2 (kumalive_id), - CONSTRAINT FK_lams_kumalive_rubric_1 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_kumalive_rubric_2 FOREIGN KEY (kumalive_id) REFERENCES lams_kumalive (kumalive_id) ON DELETE CASCADE ON UPDATE CASCADE + rubric_id bigint NOT NULL AUTO_INCREMENT, + organisation_id bigint NOT NULL, + kumalive_id bigint DEFAULT NULL, + order_id tinyint NOT NULL, + `name` varchar(250) DEFAULT NULL, + PRIMARY KEY (rubric_id), + KEY FK_lams_kumalive_rubric_1 (organisation_id), + KEY FK_lams_kumalive_rubric_2 (kumalive_id), + CONSTRAINT FK_lams_kumalive_rubric_1 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_kumalive_rubric_2 FOREIGN KEY (kumalive_id) REFERENCES lams_kumalive (kumalive_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_kumalive_score; + CREATE TABLE lams_kumalive_score ( - score_id bigint NOT NULL AUTO_INCREMENT, - rubric_id bigint NOT NULL, - user_id bigint DEFAULT NULL, - batch bigint DEFAULT NULL, - score tinyint DEFAULT NULL, - PRIMARY KEY (score_id), - KEY FK_lams_kumalive_score_1 (rubric_id), - KEY FK_lams_kumalive_score_2 (user_id), - CONSTRAINT FK_lams_kumalive_score_1 FOREIGN KEY (rubric_id) REFERENCES lams_kumalive_rubric (rubric_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_kumalive_score_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE + score_id bigint NOT NULL AUTO_INCREMENT, + rubric_id bigint NOT NULL, + user_id bigint DEFAULT NULL, + batch bigint DEFAULT NULL, + score tinyint DEFAULT NULL, + PRIMARY KEY (score_id), + KEY FK_lams_kumalive_score_1 (rubric_id), + KEY FK_lams_kumalive_score_2 (user_id), + CONSTRAINT FK_lams_kumalive_score_1 FOREIGN KEY (rubric_id) REFERENCES lams_kumalive_rubric (rubric_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_kumalive_score_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_learner_interaction_event; + CREATE TABLE lams_learner_interaction_event ( - uid bigint unsigned NOT NULL AUTO_INCREMENT, - event_type tinyint unsigned NOT NULL, - occurred_date_time datetime NOT NULL, - user_id bigint NOT NULL, - qb_tool_question_uid bigint DEFAULT NULL, - option_uid bigint DEFAULT NULL, - PRIMARY KEY (uid), - KEY event_type (event_type), - KEY lams_learner_interaction_event_FK1 (user_id), - KEY lams_learner_interaction_event_FK2 (qb_tool_question_uid), - CONSTRAINT lams_learner_interaction_event_FK1 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT lams_learner_interaction_event_FK2 FOREIGN KEY (qb_tool_question_uid) REFERENCES lams_qb_tool_question (tool_question_uid) ON DELETE RESTRICT ON UPDATE CASCADE + uid bigint unsigned NOT NULL AUTO_INCREMENT, + event_type tinyint unsigned NOT NULL, + occurred_date_time datetime NOT NULL, + user_id bigint NOT NULL, + qb_tool_question_uid bigint DEFAULT NULL, + option_uid bigint DEFAULT NULL, + PRIMARY KEY (uid), + KEY event_type (event_type), + KEY lams_learner_interaction_event_FK1 (user_id), + KEY lams_learner_interaction_event_FK2 (qb_tool_question_uid), + CONSTRAINT lams_learner_interaction_event_FK1 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT lams_learner_interaction_event_FK2 FOREIGN KEY (qb_tool_question_uid) REFERENCES lams_qb_tool_question (tool_question_uid) ON DELETE RESTRICT ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_learner_progress; + CREATE TABLE lams_learner_progress ( - learner_progress_id bigint NOT NULL AUTO_INCREMENT, - user_id bigint NOT NULL, - lesson_id bigint NOT NULL, - lesson_completed_flag tinyint(1) NOT NULL DEFAULT '0', - waiting_flag tinyint NOT NULL, - start_date_time datetime NOT NULL, - finish_date_time datetime DEFAULT NULL, - current_activity_id bigint DEFAULT NULL, - next_activity_id bigint DEFAULT NULL, - previous_activity_id bigint DEFAULT NULL, - requires_restart_flag tinyint(1) NOT NULL, - PRIMARY KEY (learner_progress_id), - UNIQUE KEY IX_lams_learner_progress_1 (user_id,lesson_id), - KEY user_id (user_id), - KEY lesson_id (lesson_id), - KEY current_activity_id (current_activity_id), - KEY next_activity_id (next_activity_id), - KEY previous_activity_id (previous_activity_id), - CONSTRAINT FK_lams_learner_progress_1 FOREIGN KEY (user_id) REFERENCES lams_user (user_id), - CONSTRAINT FK_lams_learner_progress_2 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id), - CONSTRAINT FK_lams_learner_progress_3 FOREIGN KEY (current_activity_id) REFERENCES lams_learning_activity (activity_id), - CONSTRAINT FK_lams_learner_progress_4 FOREIGN KEY (next_activity_id) REFERENCES lams_learning_activity (activity_id), - CONSTRAINT FK_lams_learner_progress_5 FOREIGN KEY (previous_activity_id) REFERENCES lams_learning_activity (activity_id) + learner_progress_id bigint NOT NULL AUTO_INCREMENT, + user_id bigint NOT NULL, + lesson_id bigint NOT NULL, + lesson_completed_flag tinyint(1) NOT NULL DEFAULT '0', + waiting_flag tinyint NOT NULL, + start_date_time datetime NOT NULL, + finish_date_time datetime DEFAULT NULL, + current_activity_id bigint DEFAULT NULL, + next_activity_id bigint DEFAULT NULL, + previous_activity_id bigint DEFAULT NULL, + requires_restart_flag tinyint(1) NOT NULL, + PRIMARY KEY (learner_progress_id), + UNIQUE KEY IX_lams_learner_progress_1 (user_id,lesson_id), + KEY user_id (user_id), + KEY lesson_id (lesson_id), + KEY current_activity_id (current_activity_id), + KEY next_activity_id (next_activity_id), + KEY previous_activity_id (previous_activity_id), + CONSTRAINT FK_lams_learner_progress_1 FOREIGN KEY (user_id) REFERENCES lams_user (user_id), + CONSTRAINT FK_lams_learner_progress_2 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id), + CONSTRAINT FK_lams_learner_progress_3 FOREIGN KEY (current_activity_id) REFERENCES lams_learning_activity (activity_id), + CONSTRAINT FK_lams_learner_progress_4 FOREIGN KEY (next_activity_id) REFERENCES lams_learning_activity (activity_id), + CONSTRAINT FK_lams_learner_progress_5 FOREIGN KEY (previous_activity_id) REFERENCES lams_learning_activity (activity_id) ); DROP TABLE IF EXISTS lams_learner_progress_archive; + CREATE TABLE lams_learner_progress_archive ( - learner_progress_id bigint NOT NULL AUTO_INCREMENT, - user_id bigint NOT NULL, - lesson_id bigint NOT NULL, - attempt_id tinyint NOT NULL DEFAULT '1', - lesson_completed_flag tinyint(1) NOT NULL DEFAULT '0', - start_date_time datetime NOT NULL, - finish_date_time datetime DEFAULT NULL, - current_activity_id bigint DEFAULT NULL, - archive_date datetime DEFAULT NULL, - PRIMARY KEY (learner_progress_id), - UNIQUE KEY IX_lams_learner_progress_archive_1 (user_id,lesson_id,attempt_id), - KEY FK_lams_learner_progress_archive_2 (lesson_id), - KEY FK_lams_learner_progress_archive_3 (current_activity_id), - CONSTRAINT FK_lams_learner_progress_archive_1 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_learner_progress_archive_2 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_learner_progress_archive_3 FOREIGN KEY (current_activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE SET NULL ON UPDATE CASCADE + learner_progress_id bigint NOT NULL AUTO_INCREMENT, + user_id bigint NOT NULL, + lesson_id bigint NOT NULL, + attempt_id tinyint NOT NULL DEFAULT '1', + lesson_completed_flag tinyint(1) NOT NULL DEFAULT '0', + start_date_time datetime NOT NULL, + finish_date_time datetime DEFAULT NULL, + current_activity_id bigint DEFAULT NULL, + archive_date datetime DEFAULT NULL, + PRIMARY KEY (learner_progress_id), + UNIQUE KEY IX_lams_learner_progress_archive_1 (user_id,lesson_id,attempt_id), + KEY FK_lams_learner_progress_archive_2 (lesson_id), + KEY FK_lams_learner_progress_archive_3 (current_activity_id), + CONSTRAINT FK_lams_learner_progress_archive_1 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_learner_progress_archive_2 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_learner_progress_archive_3 FOREIGN KEY (current_activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE SET NULL ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_learning_activity; + CREATE TABLE lams_learning_activity ( - activity_id bigint NOT NULL AUTO_INCREMENT, - activity_ui_id int DEFAULT NULL, - `description` mediumtext, - title varchar(255) DEFAULT NULL, - xcoord int DEFAULT NULL, - ycoord int DEFAULT NULL, - parent_activity_id bigint DEFAULT NULL, - parent_ui_id int DEFAULT NULL, - learning_activity_type_id int NOT NULL DEFAULT '0', - grouping_support_type_id int NOT NULL, - apply_grouping_flag tinyint(1) NOT NULL, - grouping_id bigint DEFAULT NULL, - grouping_ui_id int DEFAULT NULL, - order_id int DEFAULT NULL, - learning_design_id bigint DEFAULT NULL, - learning_library_id bigint DEFAULT NULL, - create_date_time datetime NOT NULL, - max_number_of_options int DEFAULT NULL, - min_number_of_options int DEFAULT NULL, - options_instructions mediumtext, - tool_id bigint DEFAULT NULL, - tool_content_id bigint DEFAULT NULL, - gate_activity_level_id int DEFAULT NULL, - gate_open_flag tinyint(1) DEFAULT NULL, - gate_open_user bigint DEFAULT NULL, - gate_open_time datetime DEFAULT NULL, - gate_start_time_offset bigint DEFAULT NULL, - gate_end_time_offset bigint DEFAULT NULL, - gate_activity_completion_based tinyint(1) DEFAULT NULL, - gate_password varchar(32) DEFAULT NULL, - gate_stop_at_preceding_activity tinyint NOT NULL DEFAULT '0', - library_activity_ui_image varchar(255) DEFAULT NULL, - create_grouping_id bigint DEFAULT NULL, - create_grouping_ui_id int DEFAULT NULL, - library_activity_id bigint DEFAULT NULL, - language_file varchar(255) DEFAULT NULL, - system_tool_id bigint DEFAULT NULL, - `read_only` tinyint(1) DEFAULT '0', - initialised tinyint(1) DEFAULT '0', - default_activity_id bigint DEFAULT NULL, - start_xcoord int DEFAULT NULL, - start_ycoord int DEFAULT NULL, - end_xcoord int DEFAULT NULL, - end_ycoord int DEFAULT NULL, - stop_after_activity tinyint(1) NOT NULL DEFAULT '0', - transition_to_id bigint DEFAULT NULL, - transition_from_id bigint DEFAULT NULL, - branching_ordered_asc tinyint(1) DEFAULT NULL, - PRIMARY KEY (activity_id), - KEY lams_learning_activity_tool_content_id (tool_content_id), - KEY learning_library_id (learning_library_id), - KEY learning_design_id (learning_design_id), - KEY parent_activity_id (parent_activity_id), - KEY learning_activity_type_id (learning_activity_type_id), - KEY grouping_id (grouping_id), - KEY tool_id (tool_id), - KEY gate_activity_level_id (gate_activity_level_id), - KEY create_grouping_id (create_grouping_id), - KEY library_activity_id (library_activity_id), - KEY grouping_support_type_id (grouping_support_type_id), - KEY system_tool_id (system_tool_id), - KEY FK_lams_learning_activity_15 (transition_to_id), - KEY FK_lams_learning_activity_16 (transition_from_id), - KEY FK_lams_learning_activity_17 (gate_open_user), - CONSTRAINT FK_lams_learning_activity_10 FOREIGN KEY (gate_activity_level_id) REFERENCES lams_gate_activity_level (gate_activity_level_id), - CONSTRAINT FK_lams_learning_activity_11 FOREIGN KEY (library_activity_id) REFERENCES lams_learning_activity (activity_id), - CONSTRAINT FK_lams_learning_activity_13 FOREIGN KEY (grouping_support_type_id) REFERENCES lams_grouping_support_type (grouping_support_type_id), - CONSTRAINT FK_lams_learning_activity_14 FOREIGN KEY (system_tool_id) REFERENCES lams_system_tool (system_tool_id), - CONSTRAINT FK_lams_learning_activity_15 FOREIGN KEY (transition_to_id) REFERENCES lams_learning_transition (transition_id) ON DELETE SET NULL ON UPDATE CASCADE, - CONSTRAINT FK_lams_learning_activity_16 FOREIGN KEY (transition_from_id) REFERENCES lams_learning_transition (transition_id) ON DELETE SET NULL ON UPDATE CASCADE, - CONSTRAINT FK_lams_learning_activity_17 FOREIGN KEY (gate_open_user) REFERENCES lams_user (user_id) ON DELETE SET NULL ON UPDATE CASCADE, - CONSTRAINT FK_lams_learning_activity_6 FOREIGN KEY (learning_design_id) REFERENCES lams_learning_design (learning_design_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_learning_activity_7 FOREIGN KEY (learning_library_id) REFERENCES lams_learning_library (learning_library_id), - CONSTRAINT FK_lams_learning_activity_8 FOREIGN KEY (tool_id) REFERENCES lams_tool (tool_id), - CONSTRAINT FK_lams_learning_activity_9 FOREIGN KEY (create_grouping_id) REFERENCES lams_grouping (grouping_id), - CONSTRAINT FK_learning_activity_2 FOREIGN KEY (parent_activity_id) REFERENCES lams_learning_activity (activity_id), - CONSTRAINT FK_learning_activity_3 FOREIGN KEY (learning_activity_type_id) REFERENCES lams_learning_activity_type (learning_activity_type_id), - CONSTRAINT FK_learning_activity_6 FOREIGN KEY (grouping_id) REFERENCES lams_grouping (grouping_id) + activity_id bigint NOT NULL AUTO_INCREMENT, + activity_ui_id int DEFAULT NULL, + `description` mediumtext, + title varchar(255) DEFAULT NULL, + xcoord int DEFAULT NULL, + ycoord int DEFAULT NULL, + parent_activity_id bigint DEFAULT NULL, + parent_ui_id int DEFAULT NULL, + learning_activity_type_id int NOT NULL DEFAULT '0', + grouping_support_type_id int NOT NULL, + apply_grouping_flag tinyint(1) NOT NULL, + grouping_id bigint DEFAULT NULL, + grouping_ui_id int DEFAULT NULL, + order_id int DEFAULT NULL, + learning_design_id bigint DEFAULT NULL, + learning_library_id bigint DEFAULT NULL, + create_date_time datetime NOT NULL, + max_number_of_options int DEFAULT NULL, + min_number_of_options int DEFAULT NULL, + options_instructions mediumtext, + tool_id bigint DEFAULT NULL, + tool_content_id bigint DEFAULT NULL, + gate_activity_level_id int DEFAULT NULL, + gate_open_flag tinyint(1) DEFAULT NULL, + gate_open_user bigint DEFAULT NULL, + gate_open_time datetime DEFAULT NULL, + gate_start_time_offset bigint DEFAULT NULL, + gate_end_time_offset bigint DEFAULT NULL, + gate_activity_completion_based tinyint(1) DEFAULT NULL, + gate_password varchar(32) DEFAULT NULL, + gate_stop_at_preceding_activity tinyint NOT NULL DEFAULT '0', + library_activity_ui_image varchar(255) DEFAULT NULL, + create_grouping_id bigint DEFAULT NULL, + create_grouping_ui_id int DEFAULT NULL, + library_activity_id bigint DEFAULT NULL, + language_file varchar(255) DEFAULT NULL, + system_tool_id bigint DEFAULT NULL, + `read_only` tinyint(1) DEFAULT '0', + initialised tinyint(1) DEFAULT '0', + default_activity_id bigint DEFAULT NULL, + start_xcoord int DEFAULT NULL, + start_ycoord int DEFAULT NULL, + end_xcoord int DEFAULT NULL, + end_ycoord int DEFAULT NULL, + stop_after_activity tinyint(1) NOT NULL DEFAULT '0', + transition_to_id bigint DEFAULT NULL, + transition_from_id bigint DEFAULT NULL, + branching_ordered_asc tinyint(1) DEFAULT NULL, + PRIMARY KEY (activity_id), + KEY lams_learning_activity_tool_content_id (tool_content_id), + KEY learning_library_id (learning_library_id), + KEY learning_design_id (learning_design_id), + KEY parent_activity_id (parent_activity_id), + KEY learning_activity_type_id (learning_activity_type_id), + KEY grouping_id (grouping_id), + KEY tool_id (tool_id), + KEY gate_activity_level_id (gate_activity_level_id), + KEY create_grouping_id (create_grouping_id), + KEY library_activity_id (library_activity_id), + KEY grouping_support_type_id (grouping_support_type_id), + KEY system_tool_id (system_tool_id), + KEY FK_lams_learning_activity_15 (transition_to_id), + KEY FK_lams_learning_activity_16 (transition_from_id), + KEY FK_lams_learning_activity_17 (gate_open_user), + CONSTRAINT FK_lams_learning_activity_10 FOREIGN KEY (gate_activity_level_id) REFERENCES lams_gate_activity_level (gate_activity_level_id), + CONSTRAINT FK_lams_learning_activity_11 FOREIGN KEY (library_activity_id) REFERENCES lams_learning_activity (activity_id), + CONSTRAINT FK_lams_learning_activity_13 FOREIGN KEY (grouping_support_type_id) REFERENCES lams_grouping_support_type (grouping_support_type_id), + CONSTRAINT FK_lams_learning_activity_14 FOREIGN KEY (system_tool_id) REFERENCES lams_system_tool (system_tool_id), + CONSTRAINT FK_lams_learning_activity_15 FOREIGN KEY (transition_to_id) REFERENCES lams_learning_transition (transition_id) ON DELETE SET NULL ON UPDATE CASCADE, + CONSTRAINT FK_lams_learning_activity_16 FOREIGN KEY (transition_from_id) REFERENCES lams_learning_transition (transition_id) ON DELETE SET NULL ON UPDATE CASCADE, + CONSTRAINT FK_lams_learning_activity_17 FOREIGN KEY (gate_open_user) REFERENCES lams_user (user_id) ON DELETE SET NULL ON UPDATE CASCADE, + CONSTRAINT FK_lams_learning_activity_6 FOREIGN KEY (learning_design_id) REFERENCES lams_learning_design (learning_design_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_learning_activity_7 FOREIGN KEY (learning_library_id) REFERENCES lams_learning_library (learning_library_id), + CONSTRAINT FK_lams_learning_activity_8 FOREIGN KEY (tool_id) REFERENCES lams_tool (tool_id), + CONSTRAINT FK_lams_learning_activity_9 FOREIGN KEY (create_grouping_id) REFERENCES lams_grouping (grouping_id), + CONSTRAINT FK_learning_activity_2 FOREIGN KEY (parent_activity_id) REFERENCES lams_learning_activity (activity_id), + CONSTRAINT FK_learning_activity_3 FOREIGN KEY (learning_activity_type_id) REFERENCES lams_learning_activity_type (learning_activity_type_id), + CONSTRAINT FK_learning_activity_6 FOREIGN KEY (grouping_id) REFERENCES lams_grouping (grouping_id) ); DROP TABLE IF EXISTS lams_learning_activity_type; + CREATE TABLE lams_learning_activity_type ( - learning_activity_type_id int NOT NULL, - `description` varchar(255) NOT NULL, - PRIMARY KEY (learning_activity_type_id) + learning_activity_type_id int NOT NULL, + `description` varchar(255) NOT NULL, + PRIMARY KEY (learning_activity_type_id) ); DROP TABLE IF EXISTS lams_learning_command; + CREATE TABLE lams_learning_command ( - uid bigint NOT NULL AUTO_INCREMENT, - lesson_id bigint DEFAULT NULL, - user_name varchar(191) DEFAULT NULL, - create_date datetime NOT NULL, - command_TEXT text, - PRIMARY KEY (uid), - KEY idx_lesson_id (lesson_id), - KEY idx_user_name (user_name), - KEY idx_create_date (create_date) + uid bigint NOT NULL AUTO_INCREMENT, + lesson_id bigint DEFAULT NULL, + user_name varchar(191) DEFAULT NULL, + create_date datetime NOT NULL, + command_TEXT text, + PRIMARY KEY (uid), + KEY idx_lesson_id (lesson_id), + KEY idx_user_name (user_name), + KEY idx_create_date (create_date) ); DROP TABLE IF EXISTS lams_learning_design; + CREATE TABLE lams_learning_design ( - learning_design_id bigint NOT NULL AUTO_INCREMENT, - learning_design_ui_id int DEFAULT NULL, - `description` mediumtext, - title varchar(255) DEFAULT NULL, - first_activity_id bigint DEFAULT NULL, - floating_activity_id bigint DEFAULT NULL, - max_id int DEFAULT NULL, - valid_design_flag tinyint(1) NOT NULL, - read_only_flag tinyint(1) NOT NULL, - date_read_only datetime DEFAULT NULL, - user_id bigint NOT NULL, - original_user_id bigint NOT NULL, - help_text mediumtext, - copy_type_id tinyint NOT NULL, - create_date_time datetime NOT NULL, - version varchar(56) DEFAULT NULL, - original_learning_design_id bigint DEFAULT NULL, - workspace_folder_id bigint DEFAULT NULL, - duration bigint DEFAULT NULL, - license_id bigint DEFAULT NULL, - license_TEXT mediumtext, - last_modified_date_time datetime DEFAULT NULL, - content_folder_id char(36) DEFAULT NULL, - edit_override_lock tinyint(1) DEFAULT '0', - edit_override_user_id bigint DEFAULT NULL, - design_version int DEFAULT '1', - removed tinyint(1) NOT NULL DEFAULT '0', - design_type varchar(255) DEFAULT NULL, - PRIMARY KEY (learning_design_id), - KEY user_id (user_id), - KEY workspace_folder_id (workspace_folder_id), - KEY license_id (license_id), - KEY copy_type_id (copy_type_id), - KEY edit_override_user_id (edit_override_user_id), - KEY idx_design_parent_id (original_learning_design_id), - KEY idx_design_first_act (first_activity_id), - KEY idx_design_floating_act (floating_activity_id), - CONSTRAINT FK_lams_learning_design_3 FOREIGN KEY (user_id) REFERENCES lams_user (user_id), - CONSTRAINT FK_lams_learning_design_4 FOREIGN KEY (workspace_folder_id) REFERENCES lams_workspace_folder (workspace_folder_id), - CONSTRAINT FK_lams_learning_design_5 FOREIGN KEY (license_id) REFERENCES lams_license (license_id), - CONSTRAINT FK_lams_learning_design_6 FOREIGN KEY (copy_type_id) REFERENCES lams_copy_type (copy_type_id), - CONSTRAINT FK_lams_learning_design_7 FOREIGN KEY (edit_override_user_id) REFERENCES lams_user (user_id) + learning_design_id bigint NOT NULL AUTO_INCREMENT, + learning_design_ui_id int DEFAULT NULL, + `description` mediumtext, + title varchar(255) DEFAULT NULL, + first_activity_id bigint DEFAULT NULL, + floating_activity_id bigint DEFAULT NULL, + max_id int DEFAULT NULL, + valid_design_flag tinyint(1) NOT NULL, + read_only_flag tinyint(1) NOT NULL, + date_read_only datetime DEFAULT NULL, + user_id bigint NOT NULL, + original_user_id bigint NOT NULL, + help_text mediumtext, + copy_type_id tinyint NOT NULL, + create_date_time datetime NOT NULL, + version varchar(56) DEFAULT NULL, + original_learning_design_id bigint DEFAULT NULL, + workspace_folder_id bigint DEFAULT NULL, + duration bigint DEFAULT NULL, + license_id bigint DEFAULT NULL, + license_TEXT mediumtext, + last_modified_date_time datetime DEFAULT NULL, + content_folder_id char(36) DEFAULT NULL, + edit_override_lock tinyint(1) DEFAULT '0', + edit_override_user_id bigint DEFAULT NULL, + design_version int DEFAULT '1', + removed tinyint(1) NOT NULL DEFAULT '0', + design_type varchar(255) DEFAULT NULL, + PRIMARY KEY (learning_design_id), + KEY user_id (user_id), + KEY workspace_folder_id (workspace_folder_id), + KEY license_id (license_id), + KEY copy_type_id (copy_type_id), + KEY edit_override_user_id (edit_override_user_id), + KEY idx_design_parent_id (original_learning_design_id), + KEY idx_design_first_act (first_activity_id), + KEY idx_design_floating_act (floating_activity_id), + CONSTRAINT FK_lams_learning_design_3 FOREIGN KEY (user_id) REFERENCES lams_user (user_id), + CONSTRAINT FK_lams_learning_design_4 FOREIGN KEY (workspace_folder_id) REFERENCES lams_workspace_folder (workspace_folder_id), + CONSTRAINT FK_lams_learning_design_5 FOREIGN KEY (license_id) REFERENCES lams_license (license_id), + CONSTRAINT FK_lams_learning_design_6 FOREIGN KEY (copy_type_id) REFERENCES lams_copy_type (copy_type_id), + CONSTRAINT FK_lams_learning_design_7 FOREIGN KEY (edit_override_user_id) REFERENCES lams_user (user_id) ); DROP TABLE IF EXISTS lams_learning_design_access; + CREATE TABLE lams_learning_design_access ( - learning_design_id bigint NOT NULL, - user_id bigint NOT NULL, - access_date datetime DEFAULT NULL, - PRIMARY KEY (learning_design_id,user_id), - KEY FK_lams_learning_design_access_2 (user_id), - CONSTRAINT FK_lams_learning_design_access_1 FOREIGN KEY (learning_design_id) REFERENCES lams_learning_design (learning_design_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_learning_design_access_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE + learning_design_id bigint NOT NULL, + user_id bigint NOT NULL, + access_date datetime DEFAULT NULL, + PRIMARY KEY (learning_design_id,user_id), + KEY FK_lams_learning_design_access_2 (user_id), + CONSTRAINT FK_lams_learning_design_access_1 FOREIGN KEY (learning_design_id) REFERENCES lams_learning_design (learning_design_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_learning_design_access_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_learning_design_annotation; + CREATE TABLE lams_learning_design_annotation ( - uid bigint NOT NULL AUTO_INCREMENT, - learning_design_id bigint NOT NULL, - ui_id int DEFAULT NULL, - title varchar(1024) DEFAULT NULL, - xcoord int DEFAULT NULL, - ycoord int DEFAULT NULL, - end_xcoord int DEFAULT NULL, - end_ycoord int DEFAULT NULL, - color char(7) DEFAULT NULL, - size tinyint DEFAULT NULL, - PRIMARY KEY (uid), - KEY FK_lams_learning_design_annotation_1 (learning_design_id), - CONSTRAINT FK_lams_learning_design_annotation_1 FOREIGN KEY (learning_design_id) REFERENCES lams_learning_design (learning_design_id) ON DELETE CASCADE ON UPDATE CASCADE + uid bigint NOT NULL AUTO_INCREMENT, + learning_design_id bigint NOT NULL, + ui_id int DEFAULT NULL, + title varchar(1024) DEFAULT NULL, + xcoord int DEFAULT NULL, + ycoord int DEFAULT NULL, + end_xcoord int DEFAULT NULL, + end_ycoord int DEFAULT NULL, + color char(7) DEFAULT NULL, + size tinyint DEFAULT NULL, + PRIMARY KEY (uid), + KEY FK_lams_learning_design_annotation_1 (learning_design_id), + CONSTRAINT FK_lams_learning_design_annotation_1 FOREIGN KEY (learning_design_id) REFERENCES lams_learning_design (learning_design_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_learning_library; + CREATE TABLE lams_learning_library ( - learning_library_id bigint NOT NULL AUTO_INCREMENT, - `description` mediumtext, - title varchar(255) DEFAULT NULL, - valid_flag tinyint(1) NOT NULL DEFAULT '1', - create_date_time datetime NOT NULL, - PRIMARY KEY (learning_library_id) + learning_library_id bigint NOT NULL AUTO_INCREMENT, + `description` mediumtext, + title varchar(255) DEFAULT NULL, + valid_flag tinyint(1) NOT NULL DEFAULT '1', + create_date_time datetime NOT NULL, + PRIMARY KEY (learning_library_id) ); DROP TABLE IF EXISTS lams_learning_library_to_group; + CREATE TABLE lams_learning_library_to_group ( - group_id int NOT NULL, - learning_library_id bigint NOT NULL, - PRIMARY KEY (group_id,learning_library_id) + group_id int NOT NULL, + learning_library_id bigint NOT NULL, + PRIMARY KEY (group_id,learning_library_id) ); DROP TABLE IF EXISTS lams_learning_transition; + CREATE TABLE lams_learning_transition ( - transition_id bigint NOT NULL AUTO_INCREMENT, - transition_ui_id int DEFAULT NULL, - `description` mediumtext, - title varchar(255) DEFAULT NULL, - to_activity_id bigint NOT NULL, - from_activity_id bigint NOT NULL, - learning_design_id bigint DEFAULT NULL, - create_date_time datetime NOT NULL, - to_ui_id int DEFAULT NULL, - from_ui_id int DEFAULT NULL, - transition_type tinyint NOT NULL DEFAULT '0', - PRIMARY KEY (transition_id), - KEY from_activity_id (from_activity_id), - KEY to_activity_id (to_activity_id), - KEY learning_design_id (learning_design_id), - CONSTRAINT FK_learning_transition_2 FOREIGN KEY (to_activity_id) REFERENCES lams_learning_activity (activity_id), - CONSTRAINT FK_learning_transition_3 FOREIGN KEY (from_activity_id) REFERENCES lams_learning_activity (activity_id), - CONSTRAINT lddefn_transition_ibfk_1 FOREIGN KEY (learning_design_id) REFERENCES lams_learning_design (learning_design_id) ON DELETE CASCADE ON UPDATE CASCADE + transition_id bigint NOT NULL AUTO_INCREMENT, + transition_ui_id int DEFAULT NULL, + `description` mediumtext, + title varchar(255) DEFAULT NULL, + to_activity_id bigint NOT NULL, + from_activity_id bigint NOT NULL, + learning_design_id bigint DEFAULT NULL, + create_date_time datetime NOT NULL, + to_ui_id int DEFAULT NULL, + from_ui_id int DEFAULT NULL, + transition_type tinyint NOT NULL DEFAULT '0', + PRIMARY KEY (transition_id), + KEY from_activity_id (from_activity_id), + KEY to_activity_id (to_activity_id), + KEY learning_design_id (learning_design_id), + CONSTRAINT FK_learning_transition_2 FOREIGN KEY (to_activity_id) REFERENCES lams_learning_activity (activity_id), + CONSTRAINT FK_learning_transition_3 FOREIGN KEY (from_activity_id) REFERENCES lams_learning_activity (activity_id), + CONSTRAINT lddefn_transition_ibfk_1 FOREIGN KEY (learning_design_id) REFERENCES lams_learning_design (learning_design_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_lesson; + CREATE TABLE lams_lesson ( - lesson_id bigint NOT NULL AUTO_INCREMENT, - learning_design_id bigint NOT NULL, - user_id bigint NOT NULL, - `name` varchar(255) NOT NULL, - `description` mediumtext, - create_date_time datetime NOT NULL, - organisation_id bigint DEFAULT NULL, - class_grouping_id bigint DEFAULT NULL, - lesson_state_id int NOT NULL, - start_date_time datetime DEFAULT NULL, - scheduled_number_days_to_lesson_finish int DEFAULT NULL, - schedule_start_date_time datetime DEFAULT NULL, - end_date_time datetime DEFAULT NULL, - schedule_end_date_time datetime DEFAULT NULL, - previous_state_id int DEFAULT NULL, - learner_presence_avail tinyint(1) NOT NULL DEFAULT '0', - learner_im_avail tinyint(1) NOT NULL DEFAULT '0', - live_edit_enabled tinyint(1) NOT NULL DEFAULT '0', - enable_lesson_notifications tinyint(1) NOT NULL DEFAULT '0', - locked_for_edit tinyint(1) NOT NULL DEFAULT '0', - marks_released tinyint(1) NOT NULL DEFAULT '0', - enable_lesson_intro tinyint(1) NOT NULL DEFAULT '0', - display_design_image tinyint(1) NOT NULL DEFAULT '0', - force_restart tinyint(1) NOT NULL DEFAULT '0', - allow_restart tinyint(1) NOT NULL DEFAULT '0', - gradebook_on_complete tinyint(1) NOT NULL DEFAULT '0', - PRIMARY KEY (lesson_id), - KEY learning_design_id (learning_design_id), - KEY user_id (user_id), - KEY organisation_id (organisation_id), - KEY lesson_state_id (lesson_state_id), - KEY class_grouping_id (class_grouping_id), - CONSTRAINT FK_lams_lesson_1_1 FOREIGN KEY (learning_design_id) REFERENCES lams_learning_design (learning_design_id), - CONSTRAINT FK_lams_lesson_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id), - CONSTRAINT FK_lams_lesson_3 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id), - CONSTRAINT FK_lams_lesson_4 FOREIGN KEY (lesson_state_id) REFERENCES lams_lesson_state (lesson_state_id), - CONSTRAINT FK_lams_lesson_5 FOREIGN KEY (class_grouping_id) REFERENCES lams_grouping (grouping_id) + lesson_id bigint NOT NULL AUTO_INCREMENT, + learning_design_id bigint NOT NULL, + user_id bigint NOT NULL, + `name` varchar(255) NOT NULL, + `description` mediumtext, + create_date_time datetime NOT NULL, + organisation_id bigint DEFAULT NULL, + class_grouping_id bigint DEFAULT NULL, + lesson_state_id int NOT NULL, + start_date_time datetime DEFAULT NULL, + scheduled_number_days_to_lesson_finish int DEFAULT NULL, + schedule_start_date_time datetime DEFAULT NULL, + end_date_time datetime DEFAULT NULL, + schedule_end_date_time datetime DEFAULT NULL, + previous_state_id int DEFAULT NULL, + learner_presence_avail tinyint(1) NOT NULL DEFAULT '0', + learner_im_avail tinyint(1) NOT NULL DEFAULT '0', + live_edit_enabled tinyint(1) NOT NULL DEFAULT '0', + enable_lesson_notifications tinyint(1) NOT NULL DEFAULT '0', + locked_for_edit tinyint(1) NOT NULL DEFAULT '0', + marks_released tinyint(1) NOT NULL DEFAULT '0', + enable_lesson_intro tinyint(1) NOT NULL DEFAULT '0', + display_design_image tinyint(1) NOT NULL DEFAULT '0', + force_restart tinyint(1) NOT NULL DEFAULT '0', + allow_restart tinyint(1) NOT NULL DEFAULT '0', + gradebook_on_complete tinyint(1) NOT NULL DEFAULT '0', + PRIMARY KEY (lesson_id), + KEY learning_design_id (learning_design_id), + KEY user_id (user_id), + KEY organisation_id (organisation_id), + KEY lesson_state_id (lesson_state_id), + KEY class_grouping_id (class_grouping_id), + CONSTRAINT FK_lams_lesson_1_1 FOREIGN KEY (learning_design_id) REFERENCES lams_learning_design (learning_design_id), + CONSTRAINT FK_lams_lesson_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id), + CONSTRAINT FK_lams_lesson_3 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id), + CONSTRAINT FK_lams_lesson_4 FOREIGN KEY (lesson_state_id) REFERENCES lams_lesson_state (lesson_state_id), + CONSTRAINT FK_lams_lesson_5 FOREIGN KEY (class_grouping_id) REFERENCES lams_grouping (grouping_id) ); DROP TABLE IF EXISTS lams_lesson_dependency; + CREATE TABLE lams_lesson_dependency ( - lesson_id bigint NOT NULL, - preceding_lesson_id bigint NOT NULL, - PRIMARY KEY (lesson_id,preceding_lesson_id), - KEY FK_lams_lesson_dependency_2 (preceding_lesson_id), - CONSTRAINT FK_lams_lesson_dependency_1 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_lesson_dependency_2 FOREIGN KEY (preceding_lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE + lesson_id bigint NOT NULL, + preceding_lesson_id bigint NOT NULL, + PRIMARY KEY (lesson_id,preceding_lesson_id), + KEY FK_lams_lesson_dependency_2 (preceding_lesson_id), + CONSTRAINT FK_lams_lesson_dependency_1 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_lesson_dependency_2 FOREIGN KEY (preceding_lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_lesson_state; + CREATE TABLE lams_lesson_state ( - lesson_state_id int NOT NULL, - `description` varchar(255) NOT NULL, - PRIMARY KEY (lesson_state_id) + lesson_state_id int NOT NULL, + `description` varchar(255) NOT NULL, + PRIMARY KEY (lesson_state_id) ); DROP TABLE IF EXISTS lams_license; + CREATE TABLE lams_license ( - license_id bigint NOT NULL, - `name` varchar(200) NOT NULL, - `code` varchar(20) NOT NULL, - url varchar(256) DEFAULT NULL, - default_flag tinyint(1) NOT NULL DEFAULT '0', - picture_url varchar(256) DEFAULT NULL, - order_id tinyint DEFAULT '0', - PRIMARY KEY (license_id) + license_id bigint NOT NULL, + `name` varchar(200) NOT NULL, + `code` varchar(20) NOT NULL, + `url` varchar(256) DEFAULT NULL, + default_flag tinyint(1) NOT NULL DEFAULT '0', + picture_url varchar(256) DEFAULT NULL, + order_id tinyint DEFAULT '0', + PRIMARY KEY (license_id) ); DROP TABLE IF EXISTS lams_log_event; + CREATE TABLE lams_log_event ( - id bigint NOT NULL AUTO_INCREMENT, - log_event_type_id int NOT NULL, - user_id bigint DEFAULT NULL, - occurred_date_time datetime NOT NULL, - lesson_id bigint DEFAULT NULL, - activity_id bigint DEFAULT NULL, - target_user_id bigint DEFAULT NULL, - `description` text, - PRIMARY KEY (id), - KEY event_log_occurred_date_time (occurred_date_time), - KEY FK_event_log_event_type_idx (log_event_type_id), - KEY event_log_date_and_type (occurred_date_time,log_event_type_id), - KEY event_log_user (user_id), - KEY event_log_target_user (target_user_id), - KEY event_log_lesson (lesson_id), - KEY event_log_activity (activity_id), - CONSTRAINT FK_event_log_event_type FOREIGN KEY (log_event_type_id) REFERENCES lams_log_event_type (log_event_type_id) ON DELETE RESTRICT ON UPDATE RESTRICT + id bigint NOT NULL AUTO_INCREMENT, + log_event_type_id int NOT NULL, + user_id bigint DEFAULT NULL, + occurred_date_time datetime NOT NULL, + lesson_id bigint DEFAULT NULL, + activity_id bigint DEFAULT NULL, + target_user_id bigint DEFAULT NULL, + `description` text, + PRIMARY KEY (id), + KEY event_log_occurred_date_time (occurred_date_time), + KEY FK_event_log_event_type_idx (log_event_type_id), + KEY event_log_date_and_type (occurred_date_time,log_event_type_id), + KEY event_log_user (user_id), + KEY event_log_target_user (target_user_id), + KEY event_log_lesson (lesson_id), + KEY event_log_activity (activity_id), + CONSTRAINT FK_event_log_event_type FOREIGN KEY (log_event_type_id) REFERENCES lams_log_event_type (log_event_type_id) ON DELETE RESTRICT ON UPDATE RESTRICT ); DROP TABLE IF EXISTS lams_log_event_type; + CREATE TABLE lams_log_event_type ( - log_event_type_id int NOT NULL, - `description` varchar(255) NOT NULL, - area varchar(255) DEFAULT NULL, - PRIMARY KEY (log_event_type_id) + log_event_type_id int NOT NULL, + `description` varchar(255) NOT NULL, + area varchar(255) DEFAULT NULL, + PRIMARY KEY (log_event_type_id) ); DROP TABLE IF EXISTS lams_notebook_entry; + CREATE TABLE lams_notebook_entry ( - uid bigint NOT NULL AUTO_INCREMENT, - external_id bigint DEFAULT NULL, - external_id_type int DEFAULT NULL, - external_signature varchar(255) DEFAULT NULL, - user_id int DEFAULT NULL, - title varchar(255) DEFAULT NULL, - entry mediumtext, - create_date datetime DEFAULT NULL, - last_modified datetime DEFAULT NULL, - PRIMARY KEY (uid), - KEY ext_sig_user (external_id,external_id_type,external_signature,user_id), - KEY idx_create_date (create_date) + uid bigint NOT NULL AUTO_INCREMENT, + external_id bigint DEFAULT NULL, + external_id_type int DEFAULT NULL, + external_signature varchar(255) DEFAULT NULL, + user_id int DEFAULT NULL, + title varchar(255) DEFAULT NULL, + entry mediumtext, + create_date datetime DEFAULT NULL, + last_modified datetime DEFAULT NULL, + PRIMARY KEY (uid), + KEY ext_sig_user (external_id,external_id_type,external_signature,user_id), + KEY idx_create_date (create_date) ); DROP TABLE IF EXISTS lams_notification_event; + CREATE TABLE lams_notification_event ( - uid bigint NOT NULL AUTO_INCREMENT, - scope varchar(128) NOT NULL, - `name` varchar(128) NOT NULL, - event_session_id bigint DEFAULT NULL, - `subject` varchar(255) DEFAULT NULL, - message mediumtext, - fail_time datetime DEFAULT NULL, - html_format tinyint(1) DEFAULT '0', - PRIMARY KEY (uid), - KEY scope (scope,`name`,event_session_id) + uid bigint NOT NULL AUTO_INCREMENT, + scope varchar(128) NOT NULL, + `name` varchar(128) NOT NULL, + event_session_id bigint DEFAULT NULL, + `subject` varchar(255) DEFAULT NULL, + message mediumtext, + fail_time datetime DEFAULT NULL, + html_format tinyint(1) DEFAULT '0', + PRIMARY KEY (uid), + KEY scope (scope,`name`,event_session_id) ); DROP TABLE IF EXISTS lams_notification_subscription; + CREATE TABLE lams_notification_subscription ( - uid bigint NOT NULL AUTO_INCREMENT, - user_id bigint DEFAULT NULL, - event_uid bigint DEFAULT NULL, - delivery_method_id tinyint unsigned DEFAULT NULL, - last_operation_message mediumtext, - PRIMARY KEY (uid), - KEY EventSubscriptionsToUsers (user_id), - KEY event_uid (event_uid), - CONSTRAINT EventSubscriptionsToEvent FOREIGN KEY (event_uid) REFERENCES lams_notification_event (uid) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT EventSubscriptionsToUsers FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE + uid bigint NOT NULL AUTO_INCREMENT, + user_id bigint DEFAULT NULL, + event_uid bigint DEFAULT NULL, + delivery_method_id tinyint unsigned DEFAULT NULL, + last_operation_message mediumtext, + PRIMARY KEY (uid), + KEY EventSubscriptionsToUsers (user_id), + KEY event_uid (event_uid), + CONSTRAINT EventSubscriptionsToEvent FOREIGN KEY (event_uid) REFERENCES lams_notification_event (uid) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT EventSubscriptionsToUsers FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_organisation; + CREATE TABLE lams_organisation ( - organisation_id bigint NOT NULL AUTO_INCREMENT, - `name` varchar(250) NOT NULL, - `code` varchar(20) DEFAULT NULL, - `description` mediumtext, - parent_organisation_id bigint DEFAULT NULL, - organisation_type_id int NOT NULL DEFAULT '0', - create_date datetime NOT NULL, - created_by bigint NOT NULL, - organisation_state_id int NOT NULL, - admin_add_new_users tinyint(1) NOT NULL DEFAULT '0', - admin_browse_all_users tinyint(1) NOT NULL DEFAULT '0', - admin_change_status tinyint(1) NOT NULL DEFAULT '0', - admin_create_guest tinyint(1) NOT NULL DEFAULT '0', - enable_course_notifications tinyint(1) NOT NULL DEFAULT '0', - enable_learner_gradebook tinyint(1) NOT NULL DEFAULT '0', - enable_single_activity_lessons tinyint(1) NOT NULL DEFAULT '1', - enable_live_edit tinyint(1) NOT NULL DEFAULT '1', - enable_kumalive tinyint(1) NOT NULL DEFAULT '0', - archived_date datetime DEFAULT NULL, - ordered_lesson_ids text, - PRIMARY KEY (organisation_id), - KEY organisation_type_id (organisation_type_id), - KEY parent_organisation_id (parent_organisation_id), - KEY organisation_state_id (organisation_state_id), - CONSTRAINT FK_lams_organisation_1 FOREIGN KEY (organisation_type_id) REFERENCES lams_organisation_type (organisation_type_id), - CONSTRAINT FK_lams_organisation_3 FOREIGN KEY (parent_organisation_id) REFERENCES lams_organisation (organisation_id), - CONSTRAINT FK_lams_organisation_4 FOREIGN KEY (organisation_state_id) REFERENCES lams_organisation_state (organisation_state_id) + organisation_id bigint NOT NULL AUTO_INCREMENT, + `name` varchar(250) NOT NULL, + `code` varchar(20) DEFAULT NULL, + `description` mediumtext, + parent_organisation_id bigint DEFAULT NULL, + organisation_type_id int NOT NULL DEFAULT '0', + create_date datetime NOT NULL, + created_by bigint NOT NULL, + organisation_state_id int NOT NULL, + admin_add_new_users tinyint(1) NOT NULL DEFAULT '0', + admin_browse_all_users tinyint(1) NOT NULL DEFAULT '0', + admin_change_status tinyint(1) NOT NULL DEFAULT '0', + admin_create_guest tinyint(1) NOT NULL DEFAULT '0', + enable_course_notifications tinyint(1) NOT NULL DEFAULT '0', + enable_learner_gradebook tinyint(1) NOT NULL DEFAULT '0', + enable_single_activity_lessons tinyint(1) NOT NULL DEFAULT '1', + enable_live_edit tinyint(1) NOT NULL DEFAULT '1', + enable_kumalive tinyint(1) NOT NULL DEFAULT '0', + archived_date datetime DEFAULT NULL, + ordered_lesson_ids text, + PRIMARY KEY (organisation_id), + KEY organisation_type_id (organisation_type_id), + KEY parent_organisation_id (parent_organisation_id), + KEY organisation_state_id (organisation_state_id), + CONSTRAINT FK_lams_organisation_1 FOREIGN KEY (organisation_type_id) REFERENCES lams_organisation_type (organisation_type_id), + CONSTRAINT FK_lams_organisation_3 FOREIGN KEY (parent_organisation_id) REFERENCES lams_organisation (organisation_id), + CONSTRAINT FK_lams_organisation_4 FOREIGN KEY (organisation_state_id) REFERENCES lams_organisation_state (organisation_state_id) ); DROP TABLE IF EXISTS lams_organisation_group; + CREATE TABLE lams_organisation_group ( - group_id bigint NOT NULL AUTO_INCREMENT, - grouping_id bigint NOT NULL, - `name` varchar(255) DEFAULT NULL, - PRIMARY KEY (group_id), - KEY FK_lams_organisation_group_1 (grouping_id), - CONSTRAINT FK_lams_organisation_group_1 FOREIGN KEY (grouping_id) REFERENCES lams_organisation_grouping (grouping_id) ON DELETE CASCADE ON UPDATE CASCADE + group_id bigint NOT NULL AUTO_INCREMENT, + grouping_id bigint NOT NULL, + `name` varchar(255) DEFAULT NULL, + PRIMARY KEY (group_id), + KEY FK_lams_organisation_group_1 (grouping_id), + CONSTRAINT FK_lams_organisation_group_1 FOREIGN KEY (grouping_id) REFERENCES lams_organisation_grouping (grouping_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_organisation_grouping; + CREATE TABLE lams_organisation_grouping ( - grouping_id bigint NOT NULL AUTO_INCREMENT, - organisation_id bigint NOT NULL, - `name` varchar(255) DEFAULT NULL, - PRIMARY KEY (grouping_id), - KEY FK_lams_organisation_grouping_1 (organisation_id), - CONSTRAINT FK_lams_organisation_grouping_1 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id) ON DELETE CASCADE ON UPDATE CASCADE + grouping_id bigint NOT NULL AUTO_INCREMENT, + organisation_id bigint NOT NULL, + `name` varchar(255) DEFAULT NULL, + PRIMARY KEY (grouping_id), + KEY FK_lams_organisation_grouping_1 (organisation_id), + CONSTRAINT FK_lams_organisation_grouping_1 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_organisation_state; + CREATE TABLE lams_organisation_state ( - organisation_state_id int NOT NULL, - `description` varchar(255) DEFAULT NULL, - PRIMARY KEY (organisation_state_id) + organisation_state_id int NOT NULL, + `description` varchar(255) DEFAULT NULL, + PRIMARY KEY (organisation_state_id) ); DROP TABLE IF EXISTS lams_organisation_type; + CREATE TABLE lams_organisation_type ( - organisation_type_id int NOT NULL, - `name` varchar(64) NOT NULL, - `description` varchar(255) NOT NULL, - PRIMARY KEY (organisation_type_id), - UNIQUE KEY UQ_lams_organisation_type_name (`name`) + organisation_type_id int NOT NULL, + `name` varchar(64) NOT NULL, + `description` varchar(255) NOT NULL, + PRIMARY KEY (organisation_type_id), + UNIQUE KEY UQ_lams_organisation_type_name (`name`) ); DROP TABLE IF EXISTS lams_outcome; + CREATE TABLE lams_outcome ( - outcome_id mediumint NOT NULL AUTO_INCREMENT, - scale_id mediumint NOT NULL, - `name` varchar(255) DEFAULT NULL, - `code` varchar(50) DEFAULT NULL, - `description` text, - create_by bigint DEFAULT NULL, - create_date_time datetime NOT NULL, - PRIMARY KEY (outcome_id), - KEY `name` (`name`), - KEY `code` (`code`), - KEY FK_lams_outcome_2 (scale_id), - CONSTRAINT FK_lams_outcome_2 FOREIGN KEY (scale_id) REFERENCES lams_outcome_scale (scale_id) ON UPDATE CASCADE + outcome_id mediumint NOT NULL AUTO_INCREMENT, + scale_id mediumint NOT NULL, + `name` varchar(255) DEFAULT NULL, + `code` varchar(50) DEFAULT NULL, + `description` text, + create_by bigint DEFAULT NULL, + create_date_time datetime NOT NULL, + PRIMARY KEY (outcome_id), + KEY `name` (`name`), + KEY `code` (`code`), + KEY FK_lams_outcome_2 (scale_id), + CONSTRAINT FK_lams_outcome_2 FOREIGN KEY (scale_id) REFERENCES lams_outcome_scale (scale_id) ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_outcome_mapping; + CREATE TABLE lams_outcome_mapping ( - mapping_id bigint NOT NULL AUTO_INCREMENT, - outcome_id mediumint NOT NULL, - lesson_id bigint DEFAULT NULL, - tool_content_id bigint DEFAULT NULL, - item_id bigint DEFAULT NULL, - qb_question_id int DEFAULT NULL, - PRIMARY KEY (mapping_id), - KEY FK_lams_outcome_mapping_1 (outcome_id), - KEY FK_lams_outcome_mapping_2 (lesson_id), - KEY FK_lams_outcome_mapping_3 (tool_content_id), - CONSTRAINT FK_lams_outcome_mapping_1 FOREIGN KEY (outcome_id) REFERENCES lams_outcome (outcome_id) ON DELETE RESTRICT ON UPDATE CASCADE, - CONSTRAINT FK_lams_outcome_mapping_2 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_outcome_mapping_3 FOREIGN KEY (tool_content_id) REFERENCES lams_tool_content (tool_content_id) ON DELETE CASCADE ON UPDATE CASCADE + mapping_id bigint NOT NULL AUTO_INCREMENT, + outcome_id mediumint NOT NULL, + lesson_id bigint DEFAULT NULL, + tool_content_id bigint DEFAULT NULL, + item_id bigint DEFAULT NULL, + qb_question_id int DEFAULT NULL, + PRIMARY KEY (mapping_id), + KEY FK_lams_outcome_mapping_1 (outcome_id), + KEY FK_lams_outcome_mapping_2 (lesson_id), + KEY FK_lams_outcome_mapping_3 (tool_content_id), + CONSTRAINT FK_lams_outcome_mapping_1 FOREIGN KEY (outcome_id) REFERENCES lams_outcome (outcome_id) ON DELETE RESTRICT ON UPDATE CASCADE, + CONSTRAINT FK_lams_outcome_mapping_2 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_outcome_mapping_3 FOREIGN KEY (tool_content_id) REFERENCES lams_tool_content (tool_content_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_outcome_result; + CREATE TABLE lams_outcome_result ( - result_id bigint NOT NULL AUTO_INCREMENT, - mapping_id bigint NOT NULL, - user_id bigint DEFAULT NULL, - `value` tinyint DEFAULT NULL, - create_by bigint DEFAULT NULL, - create_date_time datetime NOT NULL, - PRIMARY KEY (result_id), - KEY FK_lams_outcome_result_1 (mapping_id), - KEY FK_lams_outcome_result_2 (user_id), - KEY FK_lams_outcome_result_3 (create_by), - CONSTRAINT FK_lams_outcome_result_1 FOREIGN KEY (mapping_id) REFERENCES lams_outcome_mapping (mapping_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_outcome_result_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_outcome_result_3 FOREIGN KEY (create_by) REFERENCES lams_user (user_id) ON DELETE SET NULL ON UPDATE CASCADE + result_id bigint NOT NULL AUTO_INCREMENT, + mapping_id bigint NOT NULL, + user_id bigint DEFAULT NULL, + `value` tinyint DEFAULT NULL, + create_by bigint DEFAULT NULL, + create_date_time datetime NOT NULL, + PRIMARY KEY (result_id), + KEY FK_lams_outcome_result_1 (mapping_id), + KEY FK_lams_outcome_result_2 (user_id), + KEY FK_lams_outcome_result_3 (create_by), + CONSTRAINT FK_lams_outcome_result_1 FOREIGN KEY (mapping_id) REFERENCES lams_outcome_mapping (mapping_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_outcome_result_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_outcome_result_3 FOREIGN KEY (create_by) REFERENCES lams_user (user_id) ON DELETE SET NULL ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_outcome_scale; + CREATE TABLE lams_outcome_scale ( - scale_id mediumint NOT NULL AUTO_INCREMENT, - `name` varchar(255) DEFAULT NULL, - `code` varchar(50) DEFAULT NULL, - `description` text, - create_by bigint DEFAULT NULL, - create_date_time datetime NOT NULL, - PRIMARY KEY (scale_id), - KEY `name` (`name`), - KEY `code` (`code`) + scale_id mediumint NOT NULL AUTO_INCREMENT, + `name` varchar(255) DEFAULT NULL, + `code` varchar(50) DEFAULT NULL, + `description` text, + create_by bigint DEFAULT NULL, + create_date_time datetime NOT NULL, + PRIMARY KEY (scale_id), + KEY `name` (`name`), + KEY `code` (`code`) ); DROP TABLE IF EXISTS lams_outcome_scale_item; + CREATE TABLE lams_outcome_scale_item ( - item_id int NOT NULL AUTO_INCREMENT, - scale_id mediumint DEFAULT NULL, - `value` tinyint DEFAULT NULL, - `name` varchar(255) DEFAULT NULL, - PRIMARY KEY (item_id), - KEY FK_lams_outcome_scale_item_1 (scale_id), - CONSTRAINT FK_lams_outcome_scale_item_1 FOREIGN KEY (scale_id) REFERENCES lams_outcome_scale (scale_id) ON DELETE CASCADE ON UPDATE CASCADE + item_id int NOT NULL AUTO_INCREMENT, + scale_id mediumint DEFAULT NULL, + `value` tinyint DEFAULT NULL, + `name` varchar(255) DEFAULT NULL, + PRIMARY KEY (item_id), + KEY FK_lams_outcome_scale_item_1 (scale_id), + CONSTRAINT FK_lams_outcome_scale_item_1 FOREIGN KEY (scale_id) REFERENCES lams_outcome_scale (scale_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_password_request; + CREATE TABLE lams_password_request ( - request_id bigint NOT NULL AUTO_INCREMENT, - user_id bigint NOT NULL, - request_key char(36) DEFAULT NULL, - request_date datetime NOT NULL, - PRIMARY KEY (request_id), - UNIQUE KEY IX_lams_psswd_rqst_key (request_key) + request_id bigint NOT NULL AUTO_INCREMENT, + user_id bigint NOT NULL, + request_key char(36) DEFAULT NULL, + request_date datetime NOT NULL, + PRIMARY KEY (request_id), + UNIQUE KEY IX_lams_psswd_rqst_key (request_key) ); DROP TABLE IF EXISTS lams_planner_node_role; + CREATE TABLE lams_planner_node_role ( - uid bigint NOT NULL AUTO_INCREMENT, - node_uid bigint NOT NULL, - user_id bigint NOT NULL, - role_id int NOT NULL, - PRIMARY KEY (uid), - KEY FK_planner_node_role_user (user_id), - KEY FK_planner_node_role_node (node_uid), - KEY FK_planner_node_role_role (role_id), - CONSTRAINT FK_planner_node_role_node FOREIGN KEY (node_uid) REFERENCES lams_planner_nodes (uid) ON DELETE CASCADE, - CONSTRAINT FK_planner_node_role_role FOREIGN KEY (role_id) REFERENCES lams_role (role_id) ON DELETE CASCADE, - CONSTRAINT FK_planner_node_role_user FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE + uid bigint NOT NULL AUTO_INCREMENT, + node_uid bigint NOT NULL, + user_id bigint NOT NULL, + role_id int NOT NULL, + PRIMARY KEY (uid), + KEY FK_planner_node_role_user (user_id), + KEY FK_planner_node_role_node (node_uid), + KEY FK_planner_node_role_role (role_id), + CONSTRAINT FK_planner_node_role_node FOREIGN KEY (node_uid) REFERENCES lams_planner_nodes (uid) ON DELETE CASCADE, + CONSTRAINT FK_planner_node_role_role FOREIGN KEY (role_id) REFERENCES lams_role (role_id) ON DELETE CASCADE, + CONSTRAINT FK_planner_node_role_user FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ); DROP TABLE IF EXISTS lams_planner_nodes; + CREATE TABLE lams_planner_nodes ( - uid bigint NOT NULL AUTO_INCREMENT, - parent_uid bigint DEFAULT NULL, - order_id tinyint unsigned NOT NULL, - `locked` tinyint(1) NOT NULL DEFAULT '0', - content_folder_id char(36) DEFAULT NULL, - title varchar(255) NOT NULL, - brief_desc mediumtext, - full_desc mediumtext, - ld_id bigint DEFAULT NULL, - user_id bigint DEFAULT NULL, - permissions int DEFAULT NULL, - PRIMARY KEY (uid), - UNIQUE KEY parent_uid (parent_uid,order_id), - KEY FK_lams_planner_node_user (user_id), - CONSTRAINT FK_lams_planner_node_parent FOREIGN KEY (parent_uid) REFERENCES lams_planner_nodes (uid) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_planner_node_user FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE SET NULL ON UPDATE SET NULL + uid bigint NOT NULL AUTO_INCREMENT, + parent_uid bigint DEFAULT NULL, + order_id tinyint unsigned NOT NULL, + `locked` tinyint(1) NOT NULL DEFAULT '0', + content_folder_id char(36) DEFAULT NULL, + title varchar(255) NOT NULL, + brief_desc mediumtext, + full_desc mediumtext, + ld_id bigint DEFAULT NULL, + user_id bigint DEFAULT NULL, + permissions int DEFAULT NULL, + PRIMARY KEY (uid), + UNIQUE KEY parent_uid (parent_uid,order_id), + KEY FK_lams_planner_node_user (user_id), + CONSTRAINT FK_lams_planner_node_parent FOREIGN KEY (parent_uid) REFERENCES lams_planner_nodes (uid) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_planner_node_user FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE SET NULL ON UPDATE SET NULL ); DROP TABLE IF EXISTS lams_policy; + CREATE TABLE lams_policy ( - uid bigint NOT NULL AUTO_INCREMENT, - policy_id bigint DEFAULT NULL, - created_by bigint NOT NULL, - policy_name varchar(255) NOT NULL, - version mediumtext, - summary text, - full_policy text, - last_modified datetime NOT NULL, - policy_state_id int NOT NULL, - policy_type_id int NOT NULL, - PRIMARY KEY (uid), - KEY created_by (created_by), - KEY policy_state_id (policy_state_id), - KEY policy_type_id (policy_type_id), - CONSTRAINT FK_lams_lesson_1 FOREIGN KEY (created_by) REFERENCES lams_user (user_id), - CONSTRAINT FK_lams_policy_2 FOREIGN KEY (policy_state_id) REFERENCES lams_policy_state (policy_state_id), - CONSTRAINT FK_lams_policy_3 FOREIGN KEY (policy_type_id) REFERENCES lams_policy_type (policy_type_id) + uid bigint NOT NULL AUTO_INCREMENT, + policy_id bigint DEFAULT NULL, + created_by bigint NOT NULL, + policy_name varchar(255) NOT NULL, + version mediumtext, + summary text, + full_policy text, + last_modified datetime NOT NULL, + policy_state_id int NOT NULL, + policy_type_id int NOT NULL, + PRIMARY KEY (uid), + KEY created_by (created_by), + KEY policy_state_id (policy_state_id), + KEY policy_type_id (policy_type_id), + CONSTRAINT FK_lams_lesson_1 FOREIGN KEY (created_by) REFERENCES lams_user (user_id), + CONSTRAINT FK_lams_policy_2 FOREIGN KEY (policy_state_id) REFERENCES lams_policy_state (policy_state_id), + CONSTRAINT FK_lams_policy_3 FOREIGN KEY (policy_type_id) REFERENCES lams_policy_type (policy_type_id) ); DROP TABLE IF EXISTS lams_policy_consent; + CREATE TABLE lams_policy_consent ( - uid bigint NOT NULL AUTO_INCREMENT, - date_agreed_on datetime NOT NULL, - policy_uid bigint NOT NULL, - user_id bigint NOT NULL, - PRIMARY KEY (uid), - KEY policy_uid (policy_uid), - KEY user_id (user_id), - CONSTRAINT FK_lams_consent_1_1 FOREIGN KEY (policy_uid) REFERENCES lams_policy (uid), - CONSTRAINT FK_lams_consent_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) + uid bigint NOT NULL AUTO_INCREMENT, + date_agreed_on datetime NOT NULL, + policy_uid bigint NOT NULL, + user_id bigint NOT NULL, + PRIMARY KEY (uid), + KEY policy_uid (policy_uid), + KEY user_id (user_id), + CONSTRAINT FK_lams_consent_1_1 FOREIGN KEY (policy_uid) REFERENCES lams_policy (uid), + CONSTRAINT FK_lams_consent_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ); DROP TABLE IF EXISTS lams_policy_state; + CREATE TABLE lams_policy_state ( - policy_state_id int NOT NULL, - `description` varchar(255) NOT NULL, - PRIMARY KEY (policy_state_id) + policy_state_id int NOT NULL, + `description` varchar(255) NOT NULL, + PRIMARY KEY (policy_state_id) ); DROP TABLE IF EXISTS lams_policy_type; + CREATE TABLE lams_policy_type ( - policy_type_id int NOT NULL, - `description` varchar(255) NOT NULL, - PRIMARY KEY (policy_type_id) + policy_type_id int NOT NULL, + `description` varchar(255) NOT NULL, + PRIMARY KEY (policy_type_id) ); DROP TABLE IF EXISTS lams_presence_chat_msgs; + CREATE TABLE lams_presence_chat_msgs ( - uid bigint NOT NULL AUTO_INCREMENT, - lesson_id bigint DEFAULT NULL, - from_user varchar(191) DEFAULT NULL, - to_user varchar(191) DEFAULT NULL, - date_sent datetime DEFAULT NULL, - message varchar(1023) DEFAULT NULL, - PRIMARY KEY (uid), - KEY FK_lams_presence_chat_msgs_lesson (lesson_id), - KEY idx_lams_presence_chat_msgs_from (from_user), - KEY idx_lams_presence_chat_msgs_to (to_user), - CONSTRAINT FK_lams_presence_chat_msgs_lesson FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE + uid bigint NOT NULL AUTO_INCREMENT, + lesson_id bigint DEFAULT NULL, + from_user varchar(191) DEFAULT NULL, + to_user varchar(191) DEFAULT NULL, + date_sent datetime DEFAULT NULL, + message varchar(1023) DEFAULT NULL, + PRIMARY KEY (uid), + KEY FK_lams_presence_chat_msgs_lesson (lesson_id), + KEY idx_lams_presence_chat_msgs_from (from_user), + KEY idx_lams_presence_chat_msgs_to (to_user), + CONSTRAINT FK_lams_presence_chat_msgs_lesson FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_presence_user; + CREATE TABLE lams_presence_user ( - nickname varchar(191) NOT NULL, - lesson_id bigint NOT NULL, - last_presence datetime DEFAULT NULL, - PRIMARY KEY (nickname,lesson_id), - KEY FK_lams_presence_user_lesson (lesson_id), - CONSTRAINT FK_lams_presence_user_lesson FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE + nickname varchar(191) NOT NULL, + lesson_id bigint NOT NULL, + last_presence datetime DEFAULT NULL, + PRIMARY KEY (nickname,lesson_id), + KEY FK_lams_presence_user_lesson (lesson_id), + CONSTRAINT FK_lams_presence_user_lesson FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_progress_attempted; + CREATE TABLE lams_progress_attempted ( - learner_progress_id bigint NOT NULL, - activity_id bigint NOT NULL, - start_date_time datetime DEFAULT NULL, - PRIMARY KEY (learner_progress_id,activity_id), - KEY learner_progress_id (learner_progress_id), - KEY activity_id (activity_id), - CONSTRAINT FK_lams_progress_current_1 FOREIGN KEY (learner_progress_id) REFERENCES lams_learner_progress (learner_progress_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_progress_current_2 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE + learner_progress_id bigint NOT NULL, + activity_id bigint NOT NULL, + start_date_time datetime DEFAULT NULL, + PRIMARY KEY (learner_progress_id,activity_id), + KEY learner_progress_id (learner_progress_id), + KEY activity_id (activity_id), + CONSTRAINT FK_lams_progress_current_1 FOREIGN KEY (learner_progress_id) REFERENCES lams_learner_progress (learner_progress_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_progress_current_2 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_progress_attempted_archive; + CREATE TABLE lams_progress_attempted_archive ( - learner_progress_id bigint NOT NULL, - activity_id bigint NOT NULL, - start_date_time datetime DEFAULT NULL, - PRIMARY KEY (learner_progress_id,activity_id), - KEY FK_lams_progress_current_archive_2 (activity_id), - CONSTRAINT FK_lams_progress_current_archive_1 FOREIGN KEY (learner_progress_id) REFERENCES lams_learner_progress_archive (learner_progress_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_progress_current_archive_2 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE + learner_progress_id bigint NOT NULL, + activity_id bigint NOT NULL, + start_date_time datetime DEFAULT NULL, + PRIMARY KEY (learner_progress_id,activity_id), + KEY FK_lams_progress_current_archive_2 (activity_id), + CONSTRAINT FK_lams_progress_current_archive_1 FOREIGN KEY (learner_progress_id) REFERENCES lams_learner_progress_archive (learner_progress_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_progress_current_archive_2 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_progress_completed; + CREATE TABLE lams_progress_completed ( - learner_progress_id bigint NOT NULL, - activity_id bigint NOT NULL, - completed_date_time datetime DEFAULT NULL, - start_date_time datetime DEFAULT NULL, - PRIMARY KEY (learner_progress_id,activity_id), - KEY learner_progress_id (learner_progress_id), - KEY activity_id (activity_id), - CONSTRAINT FK_lams_progress_completed_1 FOREIGN KEY (learner_progress_id) REFERENCES lams_learner_progress (learner_progress_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_progress_completed_2 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE + learner_progress_id bigint NOT NULL, + activity_id bigint NOT NULL, + completed_date_time datetime DEFAULT NULL, + start_date_time datetime DEFAULT NULL, + PRIMARY KEY (learner_progress_id,activity_id), + KEY learner_progress_id (learner_progress_id), + KEY activity_id (activity_id), + CONSTRAINT FK_lams_progress_completed_1 FOREIGN KEY (learner_progress_id) REFERENCES lams_learner_progress (learner_progress_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_progress_completed_2 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_progress_completed_archive; + CREATE TABLE lams_progress_completed_archive ( - learner_progress_id bigint NOT NULL, - activity_id bigint NOT NULL, - completed_date_time datetime DEFAULT NULL, - start_date_time datetime DEFAULT NULL, - PRIMARY KEY (learner_progress_id,activity_id), - KEY FK_lams_progress_completed_archive_2 (activity_id), - CONSTRAINT FK_lams_progress_completed_archive_1 FOREIGN KEY (learner_progress_id) REFERENCES lams_learner_progress_archive (learner_progress_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_progress_completed_archive_2 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE + learner_progress_id bigint NOT NULL, + activity_id bigint NOT NULL, + completed_date_time datetime DEFAULT NULL, + start_date_time datetime DEFAULT NULL, + PRIMARY KEY (learner_progress_id,activity_id), + KEY FK_lams_progress_completed_archive_2 (activity_id), + CONSTRAINT FK_lams_progress_completed_archive_1 FOREIGN KEY (learner_progress_id) REFERENCES lams_learner_progress_archive (learner_progress_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_progress_completed_archive_2 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_qb_collection; + CREATE TABLE lams_qb_collection ( - uid bigint NOT NULL AUTO_INCREMENT, - `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - user_id bigint DEFAULT NULL, - personal tinyint(1) NOT NULL DEFAULT '0', - PRIMARY KEY (uid), - KEY personal (personal), - KEY FK_lams_qb_collection_1 (user_id), - CONSTRAINT FK_lams_qb_collection_1 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE + uid bigint NOT NULL AUTO_INCREMENT, + `name` varchar(255) DEFAULT NULL, + user_id bigint DEFAULT NULL, + personal tinyint(1) NOT NULL DEFAULT '0', + PRIMARY KEY (uid), + KEY personal (personal), + KEY FK_lams_qb_collection_1 (user_id), + CONSTRAINT FK_lams_qb_collection_1 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_qb_collection_organisation; + CREATE TABLE lams_qb_collection_organisation ( - collection_uid bigint NOT NULL, - organisation_id bigint NOT NULL, - KEY FK_lams_qb_collection_share_1 (collection_uid), - KEY FK_lams_qb_collection_share_2 (organisation_id), - CONSTRAINT FK_lams_qb_collection_share_1 FOREIGN KEY (collection_uid) REFERENCES lams_qb_collection (uid) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_qb_collection_share_2 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id) ON DELETE CASCADE ON UPDATE CASCADE + collection_uid bigint NOT NULL, + organisation_id bigint NOT NULL, + KEY FK_lams_qb_collection_share_1 (collection_uid), + KEY FK_lams_qb_collection_share_2 (organisation_id), + CONSTRAINT FK_lams_qb_collection_share_1 FOREIGN KEY (collection_uid) REFERENCES lams_qb_collection (uid) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_qb_collection_share_2 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_qb_collection_question; + CREATE TABLE lams_qb_collection_question ( - collection_uid bigint NOT NULL, - qb_question_id int NOT NULL, - KEY FK_lams_qb_collection_question_1 (collection_uid), - KEY FK_lams_qb_collection_question_2 (qb_question_id), - CONSTRAINT FK_lams_qb_collection_question_1 FOREIGN KEY (collection_uid) REFERENCES lams_qb_collection (uid) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_qb_collection_question_2 FOREIGN KEY (qb_question_id) REFERENCES lams_qb_question (question_id) ON DELETE CASCADE ON UPDATE CASCADE + collection_uid bigint NOT NULL, + qb_question_id int NOT NULL, + KEY FK_lams_qb_collection_question_1 (collection_uid), + KEY FK_lams_qb_collection_question_2 (qb_question_id), + CONSTRAINT FK_lams_qb_collection_question_1 FOREIGN KEY (collection_uid) REFERENCES lams_qb_collection (uid) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_qb_collection_question_2 FOREIGN KEY (qb_question_id) REFERENCES lams_qb_question (question_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_qb_option; + CREATE TABLE lams_qb_option ( - uid bigint NOT NULL AUTO_INCREMENT, - qb_question_uid bigint NOT NULL, - display_order tinyint NOT NULL DEFAULT '1', - `name` text COLLATE utf8mb4_unicode_ci, - matching_pair text COLLATE utf8mb4_unicode_ci, - numerical_option double DEFAULT NULL, - max_mark float DEFAULT '0', - accepted_error float DEFAULT '0', - feedback text COLLATE utf8mb4_unicode_ci, - PRIMARY KEY (uid), - KEY display_order (display_order), - KEY FK_lams_qb_option_1 (qb_question_uid), - CONSTRAINT FK_lams_qb_option_1 FOREIGN KEY (qb_question_uid) REFERENCES lams_qb_question (uid) ON DELETE CASCADE ON UPDATE CASCADE + uid bigint NOT NULL AUTO_INCREMENT, + qb_question_uid bigint NOT NULL, + display_order tinyint NOT NULL DEFAULT '1', + `name` text, + matching_pair text, + numerical_option double DEFAULT NULL, + max_mark float DEFAULT '0', + accepted_error float DEFAULT '0', + feedback text, + PRIMARY KEY (uid), + KEY display_order (display_order), + KEY FK_lams_qb_option_1 (qb_question_uid), + CONSTRAINT FK_lams_qb_option_1 FOREIGN KEY (qb_question_uid) REFERENCES lams_qb_question (uid) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_qb_question; + CREATE TABLE lams_qb_question ( - uid bigint NOT NULL AUTO_INCREMENT, - uuid binary(16) NOT NULL, - `type` tinyint NOT NULL, - question_id int NOT NULL, - version smallint NOT NULL DEFAULT '1', - create_date datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, - content_folder_id char(36) COLLATE utf8mb4_unicode_ci NOT NULL, - `name` text COLLATE utf8mb4_unicode_ci, - `description` mediumtext COLLATE utf8mb4_unicode_ci, - max_mark int DEFAULT NULL, - feedback text COLLATE utf8mb4_unicode_ci, - penalty_factor float DEFAULT '0', - multiple_answers_allowed tinyint(1) DEFAULT '0', - incorrect_answer_nullifies_mark tinyint(1) DEFAULT '0', - feedback_on_correct text COLLATE utf8mb4_unicode_ci, - feedback_on_partially_correct text COLLATE utf8mb4_unicode_ci, - feedback_on_incorrect text COLLATE utf8mb4_unicode_ci, - shuffle tinyint(1) DEFAULT '0', - prefix_answers_with_letters tinyint(1) DEFAULT '0', - case_sensitive tinyint(1) DEFAULT '0', - correct_answer tinyint(1) DEFAULT '0', - allow_rich_editor tinyint(1) DEFAULT '0', - max_words_limit int DEFAULT '0', - min_words_limit int DEFAULT '0', - code_style tinyint unsigned DEFAULT NULL, - hedging_justification_enabled tinyint(1) DEFAULT '0', - autocomplete_enabled tinyint(1) DEFAULT '0', - PRIMARY KEY (uid), - UNIQUE KEY UQ_question_version (question_id,version) + uid bigint NOT NULL AUTO_INCREMENT, + uuid binary(16) NOT NULL, + `type` tinyint NOT NULL, + question_id int NOT NULL, + version smallint NOT NULL DEFAULT '1', + create_date datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + content_folder_id char(36) NOT NULL, + `name` text, + `description` mediumtext, + max_mark int DEFAULT NULL, + feedback text, + penalty_factor float DEFAULT '0', + multiple_answers_allowed tinyint(1) DEFAULT '0', + incorrect_answer_nullifies_mark tinyint(1) DEFAULT '0', + feedback_on_correct text, + feedback_on_partially_correct text, + feedback_on_incorrect text, + shuffle tinyint(1) DEFAULT '0', + prefix_answers_with_letters tinyint(1) DEFAULT '0', + case_sensitive tinyint(1) DEFAULT '0', + exact_match tinyint NOT NULL DEFAULT '0', + correct_answer tinyint(1) DEFAULT '0', + allow_rich_editor tinyint(1) DEFAULT '0', + max_words_limit int DEFAULT '0', + min_words_limit int DEFAULT '0', + code_style tinyint unsigned DEFAULT NULL, + hedging_justification_enabled tinyint(1) DEFAULT '0', + autocomplete_enabled tinyint(1) DEFAULT '0', + PRIMARY KEY (uid), + UNIQUE KEY UQ_question_version (question_id,version) ); DROP TABLE IF EXISTS lams_qb_question_unit; + CREATE TABLE lams_qb_question_unit ( - uid bigint NOT NULL AUTO_INCREMENT, - qb_question_uid bigint NOT NULL, - display_order tinyint NOT NULL DEFAULT '1', - multiplier float DEFAULT '0', - `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - PRIMARY KEY (uid), - KEY FK_lams_qb_question_unit_1 (qb_question_uid), - CONSTRAINT FK_lams_qb_question_unit_1 FOREIGN KEY (qb_question_uid) REFERENCES lams_qb_question (uid) ON DELETE CASCADE ON UPDATE CASCADE + uid bigint NOT NULL AUTO_INCREMENT, + qb_question_uid bigint NOT NULL, + display_order tinyint NOT NULL DEFAULT '1', + multiplier float DEFAULT '0', + `name` varchar(255) DEFAULT NULL, + PRIMARY KEY (uid), + KEY FK_lams_qb_question_unit_1 (qb_question_uid), + CONSTRAINT FK_lams_qb_question_unit_1 FOREIGN KEY (qb_question_uid) REFERENCES lams_qb_question (uid) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_qb_tool_answer; + CREATE TABLE lams_qb_tool_answer ( - answer_uid bigint NOT NULL AUTO_INCREMENT, - tool_question_uid bigint NOT NULL, - qb_option_uid bigint DEFAULT NULL, - answer mediumtext COLLATE utf8mb4_unicode_ci, - PRIMARY KEY (answer_uid), - KEY FK_lams_qb_tool_answer_1 (tool_question_uid), - KEY FK_lams_qb_tool_answer_2 (qb_option_uid), - CONSTRAINT FK_lams_qb_tool_answer_1 FOREIGN KEY (tool_question_uid) REFERENCES lams_qb_tool_question (tool_question_uid) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_qb_tool_answer_2 FOREIGN KEY (qb_option_uid) REFERENCES lams_qb_option (uid) ON DELETE CASCADE ON UPDATE CASCADE + answer_uid bigint NOT NULL AUTO_INCREMENT, + tool_question_uid bigint NOT NULL, + qb_option_uid bigint DEFAULT NULL, + answer mediumtext, + PRIMARY KEY (answer_uid), + KEY FK_lams_qb_tool_answer_1 (tool_question_uid), + KEY FK_lams_qb_tool_answer_2 (qb_option_uid), + CONSTRAINT FK_lams_qb_tool_answer_1 FOREIGN KEY (tool_question_uid) REFERENCES lams_qb_tool_question (tool_question_uid) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_qb_tool_answer_2 FOREIGN KEY (qb_option_uid) REFERENCES lams_qb_option (uid) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_qb_tool_question; + CREATE TABLE lams_qb_tool_question ( - tool_question_uid bigint NOT NULL AUTO_INCREMENT, - qb_question_uid bigint NOT NULL, - tool_content_id bigint NOT NULL, - answer_required tinyint NOT NULL DEFAULT '0', - display_order tinyint unsigned NOT NULL DEFAULT '1', - PRIMARY KEY (tool_question_uid), - KEY tool_content_id (tool_content_id), - KEY FK_lams_qb_tool_question_1 (qb_question_uid), - CONSTRAINT FK_lams_qb_tool_question_1 FOREIGN KEY (qb_question_uid) REFERENCES lams_qb_question (uid) ON UPDATE CASCADE + tool_question_uid bigint NOT NULL AUTO_INCREMENT, + qb_question_uid bigint NOT NULL, + tool_content_id bigint NOT NULL, + answer_required tinyint NOT NULL DEFAULT '0', + display_order tinyint unsigned NOT NULL DEFAULT '1', + PRIMARY KEY (tool_question_uid), + KEY tool_content_id (tool_content_id), + KEY FK_lams_qb_tool_question_1 (qb_question_uid), + CONSTRAINT FK_lams_qb_tool_question_1 FOREIGN KEY (qb_question_uid) REFERENCES lams_qb_question (uid) ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_rating; + CREATE TABLE lams_rating ( - uid bigint NOT NULL AUTO_INCREMENT, - rating_criteria_id bigint NOT NULL, - item_id bigint DEFAULT NULL, - user_id bigint NOT NULL, - rating float DEFAULT NULL, - tool_session_id bigint DEFAULT NULL, - PRIMARY KEY (uid), - KEY rating_criteria_id (rating_criteria_id), - KEY user_id (user_id), - KEY FK_lams_rating_3 (tool_session_id), - CONSTRAINT FK_lams_rating_1 FOREIGN KEY (rating_criteria_id) REFERENCES lams_rating_criteria (rating_criteria_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_rating_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE + uid bigint NOT NULL AUTO_INCREMENT, + rating_criteria_id bigint NOT NULL, + item_id bigint DEFAULT NULL, + user_id bigint NOT NULL, + rating float DEFAULT NULL, + tool_session_id bigint DEFAULT NULL, + PRIMARY KEY (uid), + KEY rating_criteria_id (rating_criteria_id), + KEY user_id (user_id), + KEY FK_lams_rating_3 (tool_session_id), + CONSTRAINT FK_lams_rating_1 FOREIGN KEY (rating_criteria_id) REFERENCES lams_rating_criteria (rating_criteria_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_rating_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_rating_comment; + CREATE TABLE lams_rating_comment ( - uid bigint NOT NULL AUTO_INCREMENT, - rating_criteria_id bigint NOT NULL, - item_id bigint DEFAULT NULL, - user_id bigint NOT NULL, - `comment` mediumtext, - posted_date datetime DEFAULT NULL, - tool_session_id bigint DEFAULT NULL, - PRIMARY KEY (uid), - KEY rating_criteria_id (rating_criteria_id), - KEY user_id (user_id), - KEY FK_lams_rating_comment_3 (tool_session_id), - CONSTRAINT FK_lams_rating_comment_1 FOREIGN KEY (rating_criteria_id) REFERENCES lams_rating_criteria (rating_criteria_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_rating_comment_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE + uid bigint NOT NULL AUTO_INCREMENT, + rating_criteria_id bigint NOT NULL, + item_id bigint DEFAULT NULL, + user_id bigint NOT NULL, + `comment` mediumtext, + posted_date datetime DEFAULT NULL, + tool_session_id bigint DEFAULT NULL, + PRIMARY KEY (uid), + KEY rating_criteria_id (rating_criteria_id), + KEY user_id (user_id), + KEY FK_lams_rating_comment_3 (tool_session_id), + CONSTRAINT FK_lams_rating_comment_1 FOREIGN KEY (rating_criteria_id) REFERENCES lams_rating_criteria (rating_criteria_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_rating_comment_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_rating_criteria; + CREATE TABLE lams_rating_criteria ( - rating_criteria_id bigint NOT NULL AUTO_INCREMENT, - title varchar(255) DEFAULT NULL, - rating_criteria_type_id int NOT NULL DEFAULT '0', - rating_criteria_group_id mediumint unsigned DEFAULT NULL, - comments_enabled tinyint(1) NOT NULL DEFAULT '0', - comments_min_words_limit int DEFAULT '0', - order_id int NOT NULL, - tool_content_id bigint DEFAULT NULL, - item_id bigint DEFAULT NULL, - lesson_id bigint DEFAULT NULL, - rating_style bigint NOT NULL DEFAULT '1', - max_rating bigint NOT NULL DEFAULT '5', - minimum_rates int DEFAULT '0', - maximum_rates int DEFAULT '0', - PRIMARY KEY (rating_criteria_id), - KEY rating_criteria_type_id (rating_criteria_type_id), - KEY tool_content_id (tool_content_id), - KEY lesson_id (lesson_id), - CONSTRAINT FK_lams_rating_criteria_1 FOREIGN KEY (rating_criteria_type_id) REFERENCES lams_rating_criteria_type (rating_criteria_type_id), - CONSTRAINT FK_lams_rating_criteria_2 FOREIGN KEY (tool_content_id) REFERENCES lams_tool_content (tool_content_id), - CONSTRAINT FK_lams_rating_criteria_3 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) + rating_criteria_id bigint NOT NULL AUTO_INCREMENT, + title varchar(255) DEFAULT NULL, + rating_criteria_type_id int NOT NULL DEFAULT '0', + rating_criteria_group_id mediumint unsigned DEFAULT NULL, + comments_enabled tinyint(1) NOT NULL DEFAULT '0', + comments_min_words_limit int DEFAULT '0', + order_id int NOT NULL, + tool_content_id bigint DEFAULT NULL, + item_id bigint DEFAULT NULL, + lesson_id bigint DEFAULT NULL, + rating_style bigint NOT NULL DEFAULT '1', + max_rating bigint NOT NULL DEFAULT '5', + minimum_rates int DEFAULT '0', + maximum_rates int DEFAULT '0', + PRIMARY KEY (rating_criteria_id), + KEY rating_criteria_type_id (rating_criteria_type_id), + KEY tool_content_id (tool_content_id), + KEY lesson_id (lesson_id), + CONSTRAINT FK_lams_rating_criteria_1 FOREIGN KEY (rating_criteria_type_id) REFERENCES lams_rating_criteria_type (rating_criteria_type_id), + CONSTRAINT FK_lams_rating_criteria_2 FOREIGN KEY (tool_content_id) REFERENCES lams_tool_content (tool_content_id), + CONSTRAINT FK_lams_rating_criteria_3 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ); DROP TABLE IF EXISTS lams_rating_criteria_type; + CREATE TABLE lams_rating_criteria_type ( - rating_criteria_type_id int NOT NULL, - `description` varchar(255) NOT NULL, - PRIMARY KEY (rating_criteria_type_id) + rating_criteria_type_id int NOT NULL, + `description` varchar(255) NOT NULL, + PRIMARY KEY (rating_criteria_type_id) ); DROP TABLE IF EXISTS lams_rating_rubrics_columns; + CREATE TABLE lams_rating_rubrics_columns ( - uid int unsigned NOT NULL AUTO_INCREMENT, - rating_criteria_group_id mediumint unsigned DEFAULT NULL, - rating_criteria_id bigint DEFAULT NULL, - order_id tinyint unsigned NOT NULL, - `name` varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - PRIMARY KEY (uid), - UNIQUE KEY UQ_lams_rating_rubrics_columns_1 (rating_criteria_group_id,rating_criteria_id,order_id), - KEY FK_lams_rating_rubrics_columns_1 (rating_criteria_id), - CONSTRAINT FK_lams_rating_rubrics_columns_1 FOREIGN KEY (rating_criteria_id) REFERENCES lams_rating_criteria (rating_criteria_id) ON DELETE CASCADE ON UPDATE CASCADE + uid int unsigned NOT NULL AUTO_INCREMENT, + rating_criteria_group_id mediumint unsigned DEFAULT NULL, + rating_criteria_id bigint DEFAULT NULL, + order_id tinyint unsigned NOT NULL, + `name` varchar(2000) DEFAULT NULL, + PRIMARY KEY (uid), + UNIQUE KEY UQ_lams_rating_rubrics_columns_1 (rating_criteria_group_id,rating_criteria_id,order_id), + KEY FK_lams_rating_rubrics_columns_1 (rating_criteria_id), + CONSTRAINT FK_lams_rating_rubrics_columns_1 FOREIGN KEY (rating_criteria_id) REFERENCES lams_rating_criteria (rating_criteria_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_role; + CREATE TABLE lams_role ( - role_id int NOT NULL, - `name` varchar(64) NOT NULL, - `description` text, - create_date datetime NOT NULL, - PRIMARY KEY (role_id), - KEY gname (`name`) + role_id int NOT NULL, + `name` varchar(64) NOT NULL, + `description` text, + create_date datetime NOT NULL, + PRIMARY KEY (role_id), + KEY gname (`name`) ); DROP TABLE IF EXISTS lams_sequence_generator; + CREATE TABLE lams_sequence_generator ( - lams_qb_question_question_id int DEFAULT NULL, - UNIQUE KEY IDX_lams_qb_question_question_id (lams_qb_question_question_id) + lams_qb_question_question_id int DEFAULT NULL, + UNIQUE KEY IDX_lams_qb_question_question_id (lams_qb_question_question_id) ); - DROP TABLE IF EXISTS lams_signup_organisation; + CREATE TABLE lams_signup_organisation ( - signup_organisation_id bigint NOT NULL AUTO_INCREMENT, - organisation_id bigint NOT NULL, - add_to_lessons tinyint(1) DEFAULT '1', - add_as_staff tinyint(1) DEFAULT '0', - add_with_author tinyint(1) DEFAULT '0', - add_with_monitor tinyint(1) DEFAULT '0', - email_verify tinyint(1) DEFAULT '0', - course_key varchar(255) DEFAULT NULL, - blurb text, - create_date datetime DEFAULT NULL, - disabled tinyint(1) DEFAULT '0', - `conTEXT` varchar(191) NOT NULL, - login_tab_active tinyint(1) DEFAULT '0', - PRIMARY KEY (signup_organisation_id), - UNIQUE KEY `conTEXT` (`conTEXT`), - KEY organisation_id (organisation_id) + signup_organisation_id bigint NOT NULL AUTO_INCREMENT, + organisation_id bigint NOT NULL, + add_to_lessons tinyint(1) DEFAULT '1', + add_as_staff tinyint(1) DEFAULT '0', + add_with_author tinyint(1) DEFAULT '0', + add_with_monitor tinyint(1) DEFAULT '0', + email_verify tinyint(1) DEFAULT '0', + course_key varchar(255) DEFAULT NULL, + blurb text, + create_date datetime DEFAULT NULL, + disabled tinyint(1) DEFAULT '0', + `conTEXT` varchar(191) NOT NULL, + login_tab_active tinyint(1) DEFAULT '0', + PRIMARY KEY (signup_organisation_id), + UNIQUE KEY `conTEXT` (`conTEXT`), + KEY organisation_id (organisation_id) ); DROP TABLE IF EXISTS lams_supported_locale; + CREATE TABLE lams_supported_locale ( - locale_id int NOT NULL AUTO_INCREMENT, - language_iso_code varchar(2) NOT NULL, - country_iso_code varchar(2) DEFAULT NULL, - `description` varchar(255) NOT NULL, - direction varchar(3) NOT NULL, - fckeditor_code varchar(10) DEFAULT NULL, - PRIMARY KEY (locale_id) + locale_id int NOT NULL AUTO_INCREMENT, + language_iso_code varchar(2) NOT NULL, + country_iso_code varchar(2) DEFAULT NULL, + `description` varchar(255) NOT NULL, + direction varchar(3) NOT NULL, + fckeditor_code varchar(10) DEFAULT NULL, + PRIMARY KEY (locale_id) ); DROP TABLE IF EXISTS lams_system_tool; + CREATE TABLE lams_system_tool ( - system_tool_id bigint NOT NULL AUTO_INCREMENT, - learning_activity_type_id int NOT NULL, - tool_display_name varchar(255) NOT NULL, - `description` text, - learner_url text, - learner_preview_url text, - learner_progress_url text, - monitor_url text, - contribute_url text, - help_url text, - create_date_time datetime NOT NULL, - admin_url text, - PRIMARY KEY (system_tool_id), - UNIQUE KEY UQ_systool_activity_type (learning_activity_type_id), - CONSTRAINT FK_lams_system_tool FOREIGN KEY (learning_activity_type_id) REFERENCES lams_learning_activity_type (learning_activity_type_id) + system_tool_id bigint NOT NULL AUTO_INCREMENT, + learning_activity_type_id int NOT NULL, + tool_display_name varchar(255) NOT NULL, + `description` text, + learner_url text, + learner_preview_url text, + learner_progress_url text, + monitor_url text, + contribute_url text, + help_url text, + create_date_time datetime NOT NULL, + admin_url text, + PRIMARY KEY (system_tool_id), + UNIQUE KEY UQ_systool_activity_type (learning_activity_type_id), + CONSTRAINT FK_lams_system_tool FOREIGN KEY (learning_activity_type_id) REFERENCES lams_learning_activity_type (learning_activity_type_id) ); DROP TABLE IF EXISTS lams_text_search_condition; + CREATE TABLE lams_text_search_condition ( - condition_id bigint NOT NULL, - text_search_all_words text, - text_search_phrase text, - text_search_any_words text, - text_search_excluded_words text, - PRIMARY KEY (condition_id), - CONSTRAINT TextSearchConditionInheritance FOREIGN KEY (condition_id) REFERENCES lams_branch_condition (condition_id) ON DELETE CASCADE ON UPDATE CASCADE + condition_id bigint NOT NULL, + text_search_all_words text, + text_search_phrase text, + text_search_any_words text, + text_search_excluded_words text, + PRIMARY KEY (condition_id), + CONSTRAINT TextSearchConditionInheritance FOREIGN KEY (condition_id) REFERENCES lams_branch_condition (condition_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_theme; + CREATE TABLE lams_theme ( - theme_id bigint NOT NULL AUTO_INCREMENT, - `name` varchar(100) NOT NULL, - `description` varchar(100) DEFAULT NULL, - image_directory varchar(100) DEFAULT NULL, - PRIMARY KEY (theme_id), - UNIQUE KEY UQ_name (`name`) + theme_id bigint NOT NULL AUTO_INCREMENT, + `name` varchar(100) NOT NULL, + `description` varchar(100) DEFAULT NULL, + image_directory varchar(100) DEFAULT NULL, + PRIMARY KEY (theme_id), + UNIQUE KEY UQ_name (`name`) ); DROP TABLE IF EXISTS lams_timezone; + CREATE TABLE lams_timezone ( - id bigint NOT NULL AUTO_INCREMENT, - timezone_id varchar(255) NOT NULL, - server_timezone tinyint(1) DEFAULT '0', - PRIMARY KEY (id) + id bigint NOT NULL AUTO_INCREMENT, + timezone_id varchar(255) NOT NULL, + server_timezone tinyint(1) DEFAULT '0', + PRIMARY KEY (id) ); DROP TABLE IF EXISTS lams_tool; + CREATE TABLE lams_tool ( - tool_id bigint NOT NULL AUTO_INCREMENT, - tool_signature varchar(64) NOT NULL, - service_name varchar(191) NOT NULL, - tool_display_name varchar(255) NOT NULL, - `description` text, - tool_identifier varchar(64) NOT NULL, - tool_version varchar(10) NOT NULL, - learning_library_id bigint DEFAULT NULL, - default_tool_content_id bigint DEFAULT NULL, - valid_flag tinyint(1) NOT NULL DEFAULT '1', - grouping_support_type_id int NOT NULL, - learner_url text NOT NULL, - learner_preview_url text, - learner_progress_url text, - author_url text NOT NULL, - monitor_url text, - help_url text, - create_date_time datetime NOT NULL, - language_file varchar(255) DEFAULT NULL, - modified_date_time datetime DEFAULT NULL, - admin_url text, - supports_outputs tinyint(1) DEFAULT '0', - ext_lms_id varchar(255) DEFAULT NULL, - PRIMARY KEY (tool_id), - UNIQUE KEY UQ_lams_tool_sig (tool_signature), - UNIQUE KEY UQ_lams_tool_class_name (service_name), - KEY learning_library_id (learning_library_id), - KEY grouping_support_type_id (grouping_support_type_id), - CONSTRAINT FK_lams_tool_1 FOREIGN KEY (learning_library_id) REFERENCES lams_learning_library (learning_library_id), - CONSTRAINT FK_lams_tool_2 FOREIGN KEY (grouping_support_type_id) REFERENCES lams_grouping_support_type (grouping_support_type_id) + tool_id bigint NOT NULL AUTO_INCREMENT, + tool_signature varchar(64) NOT NULL, + service_name varchar(191) NOT NULL, + tool_display_name varchar(255) NOT NULL, + `description` text, + tool_identifier varchar(64) NOT NULL, + tool_version varchar(10) NOT NULL, + learning_library_id bigint DEFAULT NULL, + default_tool_content_id bigint DEFAULT NULL, + valid_flag tinyint(1) NOT NULL DEFAULT '1', + grouping_support_type_id int NOT NULL, + learner_url text NOT NULL, + learner_preview_url text, + learner_progress_url text, + author_url text NOT NULL, + monitor_url text, + help_url text, + create_date_time datetime NOT NULL, + language_file varchar(255) DEFAULT NULL, + modified_date_time datetime DEFAULT NULL, + admin_url text, + supports_outputs tinyint(1) DEFAULT '0', + ext_lms_id varchar(255) DEFAULT NULL, + PRIMARY KEY (tool_id), + UNIQUE KEY UQ_lams_tool_sig (tool_signature), + UNIQUE KEY UQ_lams_tool_class_name (service_name), + KEY learning_library_id (learning_library_id), + KEY grouping_support_type_id (grouping_support_type_id), + CONSTRAINT FK_lams_tool_1 FOREIGN KEY (learning_library_id) REFERENCES lams_learning_library (learning_library_id), + CONSTRAINT FK_lams_tool_2 FOREIGN KEY (grouping_support_type_id) REFERENCES lams_grouping_support_type (grouping_support_type_id) ); DROP TABLE IF EXISTS lams_tool_content; + CREATE TABLE lams_tool_content ( - tool_content_id bigint NOT NULL AUTO_INCREMENT, - tool_id bigint NOT NULL, - PRIMARY KEY (tool_content_id), - KEY tool_id (tool_id), - CONSTRAINT FK_lams_tool_content_1 FOREIGN KEY (tool_id) REFERENCES lams_tool (tool_id) + tool_content_id bigint NOT NULL AUTO_INCREMENT, + tool_id bigint NOT NULL, + PRIMARY KEY (tool_content_id), + KEY tool_id (tool_id), + CONSTRAINT FK_lams_tool_content_1 FOREIGN KEY (tool_id) REFERENCES lams_tool (tool_id) ); DROP TABLE IF EXISTS lams_tool_session; + CREATE TABLE lams_tool_session ( - tool_session_id bigint NOT NULL AUTO_INCREMENT, - tool_session_name varchar(255) NOT NULL, - tool_session_type_id int NOT NULL, - lesson_id bigint NOT NULL, - activity_id bigint NOT NULL, - tool_session_state_id int NOT NULL, - create_date_time datetime NOT NULL, - group_id bigint DEFAULT NULL, - user_id bigint DEFAULT NULL, - unique_key varchar(128) NOT NULL, - PRIMARY KEY (tool_session_id), - UNIQUE KEY UQ_lams_tool_session_1 (unique_key), - KEY tool_session_state_id (tool_session_state_id), - KEY user_id (user_id), - KEY tool_session_type_id (tool_session_type_id), - KEY activity_id (activity_id), - KEY group_id (group_id), - CONSTRAINT FK_lams_tool_session_1 FOREIGN KEY (group_id) REFERENCES lams_group (group_id), - CONSTRAINT FK_lams_tool_session_4 FOREIGN KEY (tool_session_state_id) REFERENCES lams_tool_session_state (tool_session_state_id), - CONSTRAINT FK_lams_tool_session_5 FOREIGN KEY (user_id) REFERENCES lams_user (user_id), - CONSTRAINT FK_lams_tool_session_7 FOREIGN KEY (tool_session_type_id) REFERENCES lams_tool_session_type (tool_session_type_id), - CONSTRAINT FK_lams_tool_session_8 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) + tool_session_id bigint NOT NULL AUTO_INCREMENT, + tool_session_name varchar(255) NOT NULL, + tool_session_type_id int NOT NULL, + lesson_id bigint NOT NULL, + activity_id bigint NOT NULL, + tool_session_state_id int NOT NULL, + create_date_time datetime NOT NULL, + group_id bigint DEFAULT NULL, + user_id bigint DEFAULT NULL, + unique_key varchar(128) NOT NULL, + PRIMARY KEY (tool_session_id), + UNIQUE KEY UQ_lams_tool_session_1 (unique_key), + KEY tool_session_state_id (tool_session_state_id), + KEY user_id (user_id), + KEY tool_session_type_id (tool_session_type_id), + KEY activity_id (activity_id), + KEY group_id (group_id), + CONSTRAINT FK_lams_tool_session_1 FOREIGN KEY (group_id) REFERENCES lams_group (group_id), + CONSTRAINT FK_lams_tool_session_4 FOREIGN KEY (tool_session_state_id) REFERENCES lams_tool_session_state (tool_session_state_id), + CONSTRAINT FK_lams_tool_session_5 FOREIGN KEY (user_id) REFERENCES lams_user (user_id), + CONSTRAINT FK_lams_tool_session_7 FOREIGN KEY (tool_session_type_id) REFERENCES lams_tool_session_type (tool_session_type_id), + CONSTRAINT FK_lams_tool_session_8 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ); DROP TABLE IF EXISTS lams_tool_session_state; + CREATE TABLE lams_tool_session_state ( - tool_session_state_id int NOT NULL, - `description` varchar(255) NOT NULL, - PRIMARY KEY (tool_session_state_id) + tool_session_state_id int NOT NULL, + `description` varchar(255) NOT NULL, + PRIMARY KEY (tool_session_state_id) ); DROP TABLE IF EXISTS lams_tool_session_type; + CREATE TABLE lams_tool_session_type ( - tool_session_type_id int NOT NULL, - `description` varchar(255) NOT NULL, - PRIMARY KEY (tool_session_type_id) + tool_session_type_id int NOT NULL, + `description` varchar(255) NOT NULL, + PRIMARY KEY (tool_session_type_id) ); DROP TABLE IF EXISTS lams_user; + CREATE TABLE lams_user ( - user_id bigint NOT NULL AUTO_INCREMENT, - login varchar(191) NOT NULL, - `password` char(64) NOT NULL, - salt char(64) DEFAULT NULL, - two_factor_auth_enabled tinyint(1) DEFAULT '0', - two_factor_auth_secret char(64) DEFAULT NULL, - title varchar(32) DEFAULT NULL, - first_name varchar(128) DEFAULT NULL, - last_name varchar(128) DEFAULT NULL, - address_line_1 varchar(64) DEFAULT NULL, - address_line_2 varchar(64) DEFAULT NULL, - address_line_3 varchar(64) DEFAULT NULL, - city varchar(64) DEFAULT NULL, - state varchar(64) DEFAULT NULL, - postcode varchar(10) DEFAULT NULL, - country varchar(2) DEFAULT NULL, - day_phone varchar(64) DEFAULT NULL, - evening_phone varchar(64) DEFAULT NULL, - mobile_phone varchar(64) DEFAULT NULL, - fax varchar(64) DEFAULT NULL, - email varchar(128) DEFAULT NULL, - email_verified tinyint(1) DEFAULT '1', - disabled_flag tinyint(1) NOT NULL DEFAULT '0', - create_date datetime NOT NULL, - authentication_method_id bigint NOT NULL DEFAULT '0', - workspace_folder_id bigint DEFAULT NULL, - theme_id bigint DEFAULT NULL, - locale_id int DEFAULT NULL, - portrait_uuid binary(16) DEFAULT NULL, - password_change_date datetime DEFAULT NULL, - change_password tinyint(1) DEFAULT '0', - timezone varchar(255) DEFAULT NULL, - first_login tinyint(1) DEFAULT '1', - modified_date datetime DEFAULT NULL, - last_visited_organisation_id bigint DEFAULT NULL, - failed_attempts tinyint DEFAULT NULL, - lock_out_time datetime DEFAULT NULL, - PRIMARY KEY (user_id), - UNIQUE KEY UQ_lams_user_login (login), - KEY authentication_method_id (authentication_method_id), - KEY workspace_folder_id (workspace_folder_id), - KEY theme_id (theme_id), - KEY locale_id (locale_id), - KEY FK_lams_user_7 (last_visited_organisation_id), - KEY email (email), - CONSTRAINT FK_lams_user_1 FOREIGN KEY (authentication_method_id) REFERENCES lams_authentication_method (authentication_method_id), - CONSTRAINT FK_lams_user_2 FOREIGN KEY (workspace_folder_id) REFERENCES lams_workspace_folder (workspace_folder_id), - CONSTRAINT FK_lams_user_5 FOREIGN KEY (theme_id) REFERENCES lams_theme (theme_id), - CONSTRAINT FK_lams_user_6 FOREIGN KEY (locale_id) REFERENCES lams_supported_locale (locale_id), - CONSTRAINT FK_lams_user_7 FOREIGN KEY (last_visited_organisation_id) REFERENCES lams_organisation (organisation_id) + user_id bigint NOT NULL AUTO_INCREMENT, + login varchar(191) NOT NULL, + `password` char(64) NOT NULL, + salt char(64) DEFAULT NULL, + two_factor_auth_enabled tinyint(1) DEFAULT '0', + two_factor_auth_secret char(64) DEFAULT NULL, + title varchar(32) DEFAULT NULL, + first_name varchar(128) DEFAULT NULL, + last_name varchar(128) DEFAULT NULL, + address_line_1 varchar(64) DEFAULT NULL, + address_line_2 varchar(64) DEFAULT NULL, + address_line_3 varchar(64) DEFAULT NULL, + city varchar(64) DEFAULT NULL, + state varchar(64) DEFAULT NULL, + postcode varchar(10) DEFAULT NULL, + country varchar(2) DEFAULT NULL, + day_phone varchar(64) DEFAULT NULL, + evening_phone varchar(64) DEFAULT NULL, + mobile_phone varchar(64) DEFAULT NULL, + fax varchar(64) DEFAULT NULL, + email varchar(128) DEFAULT NULL, + email_verified tinyint(1) DEFAULT '1', + disabled_flag tinyint(1) NOT NULL DEFAULT '0', + create_date datetime NOT NULL, + authentication_method_id bigint NOT NULL DEFAULT '0', + workspace_folder_id bigint DEFAULT NULL, + theme_id bigint DEFAULT NULL, + locale_id int DEFAULT NULL, + portrait_uuid binary(16) DEFAULT NULL, + password_change_date datetime DEFAULT NULL, + change_password tinyint(1) DEFAULT '0', + timezone varchar(255) DEFAULT NULL, + first_login tinyint(1) DEFAULT '1', + modified_date datetime DEFAULT NULL, + last_visited_organisation_id bigint DEFAULT NULL, + failed_attempts tinyint DEFAULT NULL, + lock_out_time datetime DEFAULT NULL, + PRIMARY KEY (user_id), + UNIQUE KEY UQ_lams_user_login (login), + KEY authentication_method_id (authentication_method_id), + KEY workspace_folder_id (workspace_folder_id), + KEY theme_id (theme_id), + KEY locale_id (locale_id), + KEY FK_lams_user_7 (last_visited_organisation_id), + KEY email (email), + CONSTRAINT FK_lams_user_1 FOREIGN KEY (authentication_method_id) REFERENCES lams_authentication_method (authentication_method_id), + CONSTRAINT FK_lams_user_2 FOREIGN KEY (workspace_folder_id) REFERENCES lams_workspace_folder (workspace_folder_id), + CONSTRAINT FK_lams_user_5 FOREIGN KEY (theme_id) REFERENCES lams_theme (theme_id), + CONSTRAINT FK_lams_user_6 FOREIGN KEY (locale_id) REFERENCES lams_supported_locale (locale_id), + CONSTRAINT FK_lams_user_7 FOREIGN KEY (last_visited_organisation_id) REFERENCES lams_organisation (organisation_id) ); DROP TABLE IF EXISTS lams_user_group; + CREATE TABLE lams_user_group ( - user_id bigint NOT NULL, - group_id bigint NOT NULL, - scheduled_lesson_end_date datetime DEFAULT NULL, - PRIMARY KEY (user_id,group_id), - KEY user_id (user_id), - KEY group_id (group_id), - CONSTRAINT FK_lams_user_group_1 FOREIGN KEY (user_id) REFERENCES lams_user (user_id), - CONSTRAINT FK_lams_user_group_2 FOREIGN KEY (group_id) REFERENCES lams_group (group_id) + user_id bigint NOT NULL, + group_id bigint NOT NULL, + scheduled_lesson_end_date datetime DEFAULT NULL, + PRIMARY KEY (user_id,group_id), + KEY user_id (user_id), + KEY group_id (group_id), + CONSTRAINT FK_lams_user_group_1 FOREIGN KEY (user_id) REFERENCES lams_user (user_id), + CONSTRAINT FK_lams_user_group_2 FOREIGN KEY (group_id) REFERENCES lams_group (group_id) ); DROP TABLE IF EXISTS lams_user_organisation; + CREATE TABLE lams_user_organisation ( - user_organisation_id bigint NOT NULL AUTO_INCREMENT, - organisation_id bigint NOT NULL, - user_id bigint NOT NULL, - PRIMARY KEY (user_organisation_id), - KEY organisation_id (organisation_id), - KEY user_id (user_id), - CONSTRAINT FK_lams_user_organisation_1 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id), - CONSTRAINT FK_lams_user_organisation_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) + user_organisation_id bigint NOT NULL AUTO_INCREMENT, + organisation_id bigint NOT NULL, + user_id bigint NOT NULL, + PRIMARY KEY (user_organisation_id), + KEY organisation_id (organisation_id), + KEY user_id (user_id), + CONSTRAINT FK_lams_user_organisation_1 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id), + CONSTRAINT FK_lams_user_organisation_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ); DROP TABLE IF EXISTS lams_user_organisation_collapsed; + CREATE TABLE lams_user_organisation_collapsed ( - uid bigint NOT NULL AUTO_INCREMENT, - organisation_id bigint NOT NULL, - user_id bigint NOT NULL, - collapsed tinyint(1) NOT NULL DEFAULT '0', - PRIMARY KEY (uid), - KEY organisation_id (organisation_id), - KEY user_id (user_id), - CONSTRAINT FK_lams_user_organisation_collapsed_1 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id), - CONSTRAINT FK_lams_user_organisation_collapsed_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) + uid bigint NOT NULL AUTO_INCREMENT, + organisation_id bigint NOT NULL, + user_id bigint NOT NULL, + collapsed tinyint(1) NOT NULL DEFAULT '0', + PRIMARY KEY (uid), + KEY organisation_id (organisation_id), + KEY user_id (user_id), + CONSTRAINT FK_lams_user_organisation_collapsed_1 FOREIGN KEY (organisation_id) REFERENCES lams_organisation (organisation_id), + CONSTRAINT FK_lams_user_organisation_collapsed_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ); DROP TABLE IF EXISTS lams_user_organisation_group; + CREATE TABLE lams_user_organisation_group ( - group_id bigint NOT NULL, - user_id bigint NOT NULL, - PRIMARY KEY (group_id,user_id), - KEY FK_lams_user_organisation_group_2 (user_id), - CONSTRAINT FK_lams_user_organisation_group_1 FOREIGN KEY (group_id) REFERENCES lams_organisation_group (group_id) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_lams_user_organisation_group_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE + group_id bigint NOT NULL, + user_id bigint NOT NULL, + PRIMARY KEY (group_id,user_id), + KEY FK_lams_user_organisation_group_2 (user_id), + CONSTRAINT FK_lams_user_organisation_group_1 FOREIGN KEY (group_id) REFERENCES lams_organisation_group (group_id) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_lams_user_organisation_group_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_user_organisation_role; + CREATE TABLE lams_user_organisation_role ( - user_organisation_role_id bigint NOT NULL AUTO_INCREMENT, - user_organisation_id bigint NOT NULL, - role_id int NOT NULL, - PRIMARY KEY (user_organisation_role_id), - KEY role_id (role_id), - KEY user_organisation_id (user_organisation_id), - CONSTRAINT FK_lams_user_organisation_role_2 FOREIGN KEY (role_id) REFERENCES lams_role (role_id), - CONSTRAINT FK_lams_user_organisation_role_3 FOREIGN KEY (user_organisation_id) REFERENCES lams_user_organisation (user_organisation_id) + user_organisation_role_id bigint NOT NULL AUTO_INCREMENT, + user_organisation_id bigint NOT NULL, + role_id int NOT NULL, + PRIMARY KEY (user_organisation_role_id), + KEY role_id (role_id), + KEY user_organisation_id (user_organisation_id), + CONSTRAINT FK_lams_user_organisation_role_2 FOREIGN KEY (role_id) REFERENCES lams_role (role_id), + CONSTRAINT FK_lams_user_organisation_role_3 FOREIGN KEY (user_organisation_id) REFERENCES lams_user_organisation (user_organisation_id) ); DROP TABLE IF EXISTS lams_user_password_history; + CREATE TABLE lams_user_password_history ( - uid int unsigned NOT NULL AUTO_INCREMENT, - user_id bigint NOT NULL, - change_date datetime NOT NULL, - `password` char(129) COLLATE utf8mb4_unicode_ci NOT NULL, - PRIMARY KEY (uid), - KEY FK_lams_user_password_history_1 (user_id), - CONSTRAINT FK_lams_user_password_history_1 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE + uid int unsigned NOT NULL AUTO_INCREMENT, + user_id bigint NOT NULL, + change_date datetime NOT NULL, + `password` char(129) NOT NULL, + PRIMARY KEY (uid), + KEY FK_lams_user_password_history_1 (user_id), + CONSTRAINT FK_lams_user_password_history_1 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE ); DROP TABLE IF EXISTS lams_workspace_folder; + CREATE TABLE lams_workspace_folder ( - workspace_folder_id bigint NOT NULL AUTO_INCREMENT, - parent_folder_id bigint DEFAULT NULL, - `name` varchar(255) NOT NULL, - user_id bigint NOT NULL, - organisation_id bigint DEFAULT NULL, - create_date_time datetime NOT NULL, - last_modified_date_time datetime DEFAULT NULL, - lams_workspace_folder_type_id int NOT NULL, - PRIMARY KEY (workspace_folder_id), - KEY parent_folder_id (parent_folder_id), - KEY lams_workspace_folder_type_id (lams_workspace_folder_type_id), - CONSTRAINT FK_lams_workspace_folder_2 FOREIGN KEY (parent_folder_id) REFERENCES lams_workspace_folder (workspace_folder_id), - CONSTRAINT FK_lams_workspace_folder_4 FOREIGN KEY (lams_workspace_folder_type_id) REFERENCES lams_workspace_folder_type (lams_workspace_folder_type_id) + workspace_folder_id bigint NOT NULL AUTO_INCREMENT, + parent_folder_id bigint DEFAULT NULL, + `name` varchar(255) NOT NULL, + user_id bigint NOT NULL, + organisation_id bigint DEFAULT NULL, + create_date_time datetime NOT NULL, + last_modified_date_time datetime DEFAULT NULL, + lams_workspace_folder_type_id int NOT NULL, + PRIMARY KEY (workspace_folder_id), + KEY parent_folder_id (parent_folder_id), + KEY lams_workspace_folder_type_id (lams_workspace_folder_type_id), + CONSTRAINT FK_lams_workspace_folder_2 FOREIGN KEY (parent_folder_id) REFERENCES lams_workspace_folder (workspace_folder_id), + CONSTRAINT FK_lams_workspace_folder_4 FOREIGN KEY (lams_workspace_folder_type_id) REFERENCES lams_workspace_folder_type (lams_workspace_folder_type_id) ); DROP TABLE IF EXISTS lams_workspace_folder_content; + CREATE TABLE lams_workspace_folder_content ( - folder_content_id bigint NOT NULL AUTO_INCREMENT, - content_type_id int NOT NULL, - `name` varchar(64) NOT NULL, - `description` varchar(64) NOT NULL, - create_date_time datetime NOT NULL, - last_modified_date datetime NOT NULL, - workspace_folder_id bigint NOT NULL, - uuid bigint DEFAULT NULL, - version_id bigint DEFAULT NULL, - mime_type varchar(10) NOT NULL, - PRIMARY KEY (folder_content_id), - UNIQUE KEY unique_content_name (`name`,workspace_folder_id,mime_type), - UNIQUE KEY unique_node_version (workspace_folder_id,uuid,version_id), - KEY content_type_id (content_type_id), - KEY workspace_folder_id (workspace_folder_id), - CONSTRAINT FK_lams_workspace_folder_content_1 FOREIGN KEY (workspace_folder_id) REFERENCES lams_workspace_folder (workspace_folder_id) + folder_content_id bigint NOT NULL AUTO_INCREMENT, + content_type_id int NOT NULL, + `name` varchar(64) NOT NULL, + `description` varchar(64) NOT NULL, + create_date_time datetime NOT NULL, + last_modified_date datetime NOT NULL, + workspace_folder_id bigint NOT NULL, + uuid bigint DEFAULT NULL, + version_id bigint DEFAULT NULL, + mime_type varchar(10) NOT NULL, + PRIMARY KEY (folder_content_id), + UNIQUE KEY unique_content_name (`name`,workspace_folder_id,mime_type), + UNIQUE KEY unique_node_version (workspace_folder_id,uuid,version_id), + KEY content_type_id (content_type_id), + KEY workspace_folder_id (workspace_folder_id), + CONSTRAINT FK_lams_workspace_folder_content_1 FOREIGN KEY (workspace_folder_id) REFERENCES lams_workspace_folder (workspace_folder_id) ); DROP TABLE IF EXISTS lams_workspace_folder_type; + CREATE TABLE lams_workspace_folder_type ( - lams_workspace_folder_type_id int NOT NULL, - `description` varchar(255) NOT NULL, - PRIMARY KEY (lams_workspace_folder_type_id) + lams_workspace_folder_type_id int NOT NULL, + `description` varchar(255) NOT NULL, + PRIMARY KEY (lams_workspace_folder_type_id) ); DROP TABLE IF EXISTS patches; + CREATE TABLE patches ( - system_name varchar(30) NOT NULL, - patch_level int NOT NULL, - patch_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - patch_in_progress char(1) NOT NULL DEFAULT 'F', - PRIMARY KEY (system_name,patch_level) + system_name varchar(30) NOT NULL, + patch_level int NOT NULL, + patch_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + patch_in_progress char(1) NOT NULL DEFAULT 'F', + PRIMARY KEY (system_name,patch_level) ); DROP TRIGGER IF EXISTS before_insert_qb_question; Index: lams_common/db/sql/create_quartz_table.sql =================================================================== diff -u -r812d599154aefa64ac8c3db4cdecdc1b679706af -r10db06081c24c1566659b76698016e844de327a5 --- lams_common/db/sql/create_quartz_table.sql (.../create_quartz_table.sql) (revision 812d599154aefa64ac8c3db4cdecdc1b679706af) +++ lams_common/db/sql/create_quartz_table.sql (.../create_quartz_table.sql) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -1,175 +1,187 @@ -- Quartz 2.2.3 + SET FOREIGN_KEY_CHECKS=0; DROP TABLE IF EXISTS lams_qtz_blob_triggers; + CREATE TABLE lams_qtz_blob_triggers ( - SCHED_NAME varchar(120) NOT NULL, - TRIGGER_NAME varchar(200) NOT NULL, - TRIGGER_GROUP varchar(200) NOT NULL, - BLOB_DATA blob, - PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), - KEY SCHED_NAME (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), - CONSTRAINT lams_qtz_BLOB_TRIGGERS_ibfk_1 FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES lams_qtz_triggers (sched_name, trigger_name, trigger_group) + SCHED_NAME varchar(120) NOT NULL, + TRIGGER_NAME varchar(200) NOT NULL, + TRIGGER_GROUP varchar(200) NOT NULL, + BLOB_DATA blob, + PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), + KEY SCHED_NAME (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), + CONSTRAINT lams_qtz_BLOB_TRIGGERS_ibfk_1 FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES lams_qtz_triggers (sched_name, trigger_name, trigger_group) ); DROP TABLE IF EXISTS lams_qtz_calendars; + CREATE TABLE lams_qtz_calendars ( - SCHED_NAME varchar(120) NOT NULL, - CALENDAR_NAME varchar(200) NOT NULL, - CALENDAR blob NOT NULL, - PRIMARY KEY (SCHED_NAME,CALENDAR_NAME) + SCHED_NAME varchar(120) NOT NULL, + CALENDAR_NAME varchar(200) NOT NULL, + CALENDAR blob NOT NULL, + PRIMARY KEY (SCHED_NAME,CALENDAR_NAME) ); DROP TABLE IF EXISTS lams_qtz_cron_triggers; + CREATE TABLE lams_qtz_cron_triggers ( - SCHED_NAME varchar(120) NOT NULL, - TRIGGER_NAME varchar(200) NOT NULL, - TRIGGER_GROUP varchar(200) NOT NULL, - CRON_EXPRESSION varchar(120) NOT NULL, - TIME_ZONE_ID varchar(80) DEFAULT NULL, - PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), - CONSTRAINT lams_qtz_CRON_TRIGGERS_ibfk_1 FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES lams_qtz_triggers (sched_name, trigger_name, trigger_group) + SCHED_NAME varchar(120) NOT NULL, + TRIGGER_NAME varchar(200) NOT NULL, + TRIGGER_GROUP varchar(200) NOT NULL, + CRON_EXPRESSION varchar(120) NOT NULL, + TIME_ZONE_ID varchar(80) DEFAULT NULL, + PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), + CONSTRAINT lams_qtz_CRON_TRIGGERS_ibfk_1 FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES lams_qtz_triggers (sched_name, trigger_name, trigger_group) ); DROP TABLE IF EXISTS lams_qtz_fired_triggers; + CREATE TABLE lams_qtz_fired_triggers ( - SCHED_NAME varchar(120) NOT NULL, - ENTRY_ID varchar(95) NOT NULL, - TRIGGER_NAME varchar(200) NOT NULL, - TRIGGER_GROUP varchar(200) NOT NULL, - INSTANCE_NAME varchar(200) NOT NULL, - FIRED_TIME bigint NOT NULL, - SCHED_TIME bigint NOT NULL, - PRIORITY int NOT NULL, - STATE varchar(16) NOT NULL, - JOB_NAME varchar(200) DEFAULT NULL, - JOB_GROUP varchar(200) DEFAULT NULL, - IS_NONCONCURRENT varchar(1) DEFAULT NULL, - REQUESTS_RECOVERY varchar(1) DEFAULT NULL, - PRIMARY KEY (SCHED_NAME,ENTRY_ID), - KEY IDX_lams_qtz_FT_TRIG_INST_NAME (SCHED_NAME,INSTANCE_NAME), - KEY IDX_lams_qtz_FT_INST_JOB_REQ_RCVRY (SCHED_NAME,INSTANCE_NAME,REQUESTS_RECOVERY), - KEY IDX_lams_qtz_FT_J_G (SCHED_NAME,JOB_NAME,JOB_GROUP), - KEY IDX_lams_qtz_FT_JG (SCHED_NAME,JOB_GROUP), - KEY IDX_lams_qtz_FT_T_G (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), - KEY IDX_lams_qtz_FT_TG (SCHED_NAME,TRIGGER_GROUP) + SCHED_NAME varchar(120) NOT NULL, + ENTRY_ID varchar(95) NOT NULL, + TRIGGER_NAME varchar(200) NOT NULL, + TRIGGER_GROUP varchar(200) NOT NULL, + INSTANCE_NAME varchar(200) NOT NULL, + FIRED_TIME bigint NOT NULL, + SCHED_TIME bigint NOT NULL, + PRIORITY int NOT NULL, + STATE varchar(16) NOT NULL, + JOB_NAME varchar(200) DEFAULT NULL, + JOB_GROUP varchar(200) DEFAULT NULL, + IS_NONCONCURRENT varchar(1) DEFAULT NULL, + REQUESTS_RECOVERY varchar(1) DEFAULT NULL, + PRIMARY KEY (SCHED_NAME,ENTRY_ID), + KEY IDX_lams_qtz_FT_TRIG_INST_NAME (SCHED_NAME,INSTANCE_NAME), + KEY IDX_lams_qtz_FT_INST_JOB_REQ_RCVRY (SCHED_NAME,INSTANCE_NAME,REQUESTS_RECOVERY), + KEY IDX_lams_qtz_FT_J_G (SCHED_NAME,JOB_NAME,JOB_GROUP), + KEY IDX_lams_qtz_FT_JG (SCHED_NAME,JOB_GROUP), + KEY IDX_lams_qtz_FT_T_G (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), + KEY IDX_lams_qtz_FT_TG (SCHED_NAME,TRIGGER_GROUP) ); DROP TABLE IF EXISTS lams_qtz_job_details; + CREATE TABLE lams_qtz_job_details ( - SCHED_NAME varchar(120) NOT NULL, - JOB_NAME varchar(200) NOT NULL, - JOB_GROUP varchar(200) NOT NULL, - `DESCRIPTION` varchar(250) DEFAULT NULL, - JOB_CLASS_NAME varchar(250) NOT NULL, - IS_DURABLE varchar(1) NOT NULL, - IS_NONCONCURRENT varchar(1) NOT NULL, - IS_UPDATE_DATA varchar(1) NOT NULL, - REQUESTS_RECOVERY varchar(1) NOT NULL, - JOB_DATA blob, - PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP), - KEY IDX_lams_qtz_J_REQ_RECOVERY (SCHED_NAME,REQUESTS_RECOVERY), - KEY IDX_lams_qtz_J_GRP (SCHED_NAME,JOB_GROUP) + SCHED_NAME varchar(120) NOT NULL, + JOB_NAME varchar(200) NOT NULL, + JOB_GROUP varchar(200) NOT NULL, + `DESCRIPTION` varchar(250) DEFAULT NULL, + JOB_CLASS_NAME varchar(250) NOT NULL, + IS_DURABLE varchar(1) NOT NULL, + IS_NONCONCURRENT varchar(1) NOT NULL, + IS_UPDATE_DATA varchar(1) NOT NULL, + REQUESTS_RECOVERY varchar(1) NOT NULL, + JOB_DATA blob, + PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP), + KEY IDX_lams_qtz_J_REQ_RECOVERY (SCHED_NAME,REQUESTS_RECOVERY), + KEY IDX_lams_qtz_J_GRP (SCHED_NAME,JOB_GROUP) ); DROP TABLE IF EXISTS lams_qtz_locks; + CREATE TABLE lams_qtz_locks ( - SCHED_NAME varchar(120) NOT NULL, - LOCK_NAME varchar(40) NOT NULL, - PRIMARY KEY (SCHED_NAME,LOCK_NAME) + SCHED_NAME varchar(120) NOT NULL, + LOCK_NAME varchar(40) NOT NULL, + PRIMARY KEY (SCHED_NAME,LOCK_NAME) ); DROP TABLE IF EXISTS lams_qtz_paused_trigger_grps; + CREATE TABLE lams_qtz_paused_trigger_grps ( - SCHED_NAME varchar(120) NOT NULL, - TRIGGER_GROUP varchar(200) NOT NULL, - PRIMARY KEY (SCHED_NAME,TRIGGER_GROUP) + SCHED_NAME varchar(120) NOT NULL, + TRIGGER_GROUP varchar(200) NOT NULL, + PRIMARY KEY (SCHED_NAME,TRIGGER_GROUP) ); DROP TABLE IF EXISTS lams_qtz_scheduler_state; + CREATE TABLE lams_qtz_scheduler_state ( - SCHED_NAME varchar(120) NOT NULL, - INSTANCE_NAME varchar(200) NOT NULL, - LAST_CHECKIN_TIME bigint NOT NULL, - CHECKIN_INTERVAL bigint NOT NULL, - PRIMARY KEY (SCHED_NAME,INSTANCE_NAME) + SCHED_NAME varchar(120) NOT NULL, + INSTANCE_NAME varchar(200) NOT NULL, + LAST_CHECKIN_TIME bigint NOT NULL, + CHECKIN_INTERVAL bigint NOT NULL, + PRIMARY KEY (SCHED_NAME,INSTANCE_NAME) ); DROP TABLE IF EXISTS lams_qtz_simple_triggers; + CREATE TABLE lams_qtz_simple_triggers ( - SCHED_NAME varchar(120) NOT NULL, - TRIGGER_NAME varchar(200) NOT NULL, - TRIGGER_GROUP varchar(200) NOT NULL, - REPEAT_COUNT bigint NOT NULL, - REPEAT_INTERVAL bigint NOT NULL, - TIMES_TRIGGERED bigint NOT NULL, - PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), - CONSTRAINT lams_qtz_SIMPLE_TRIGGERS_ibfk_1 FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES lams_qtz_triggers (sched_name, trigger_name, trigger_group) + SCHED_NAME varchar(120) NOT NULL, + TRIGGER_NAME varchar(200) NOT NULL, + TRIGGER_GROUP varchar(200) NOT NULL, + REPEAT_COUNT bigint NOT NULL, + REPEAT_INTERVAL bigint NOT NULL, + TIMES_TRIGGERED bigint NOT NULL, + PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), + CONSTRAINT lams_qtz_SIMPLE_TRIGGERS_ibfk_1 FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES lams_qtz_triggers (sched_name, trigger_name, trigger_group) ); DROP TABLE IF EXISTS lams_qtz_simprop_triggers; + CREATE TABLE lams_qtz_simprop_triggers ( - SCHED_NAME varchar(120) NOT NULL, - TRIGGER_NAME varchar(200) NOT NULL, - TRIGGER_GROUP varchar(200) NOT NULL, - STR_PROP_1 varchar(512) DEFAULT NULL, - STR_PROP_2 varchar(512) DEFAULT NULL, - STR_PROP_3 varchar(512) DEFAULT NULL, - INT_PROP_1 int DEFAULT NULL, - INT_PROP_2 int DEFAULT NULL, - LONG_PROP_1 bigint DEFAULT NULL, - LONG_PROP_2 bigint DEFAULT NULL, - DEC_PROP_1 decimal(13,4) DEFAULT NULL, - DEC_PROP_2 decimal(13,4) DEFAULT NULL, - BOOL_PROP_1 varchar(1) DEFAULT NULL, - BOOL_PROP_2 varchar(1) DEFAULT NULL, - PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), - CONSTRAINT lams_qtz_SIMPROP_TRIGGERS_ibfk_1 FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES lams_qtz_triggers (sched_name, trigger_name, trigger_group) + SCHED_NAME varchar(120) NOT NULL, + TRIGGER_NAME varchar(200) NOT NULL, + TRIGGER_GROUP varchar(200) NOT NULL, + STR_PROP_1 varchar(512) DEFAULT NULL, + STR_PROP_2 varchar(512) DEFAULT NULL, + STR_PROP_3 varchar(512) DEFAULT NULL, + INT_PROP_1 int DEFAULT NULL, + INT_PROP_2 int DEFAULT NULL, + LONG_PROP_1 bigint DEFAULT NULL, + LONG_PROP_2 bigint DEFAULT NULL, + DEC_PROP_1 decimal(13,4) DEFAULT NULL, + DEC_PROP_2 decimal(13,4) DEFAULT NULL, + BOOL_PROP_1 varchar(1) DEFAULT NULL, + BOOL_PROP_2 varchar(1) DEFAULT NULL, + PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), + CONSTRAINT lams_qtz_SIMPROP_TRIGGERS_ibfk_1 FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES lams_qtz_triggers (sched_name, trigger_name, trigger_group) ); DROP TABLE IF EXISTS lams_qtz_triggers; + CREATE TABLE lams_qtz_triggers ( - SCHED_NAME varchar(120) NOT NULL, - TRIGGER_NAME varchar(200) NOT NULL, - TRIGGER_GROUP varchar(200) NOT NULL, - JOB_NAME varchar(200) NOT NULL, - JOB_GROUP varchar(200) NOT NULL, - `DESCRIPTION` varchar(250) DEFAULT NULL, - NEXT_FIRE_TIME bigint DEFAULT NULL, - PREV_FIRE_TIME bigint DEFAULT NULL, - PRIORITY int DEFAULT NULL, - TRIGGER_STATE varchar(16) NOT NULL, - TRIGGER_TYPE varchar(8) NOT NULL, - START_TIME bigint NOT NULL, - END_TIME bigint DEFAULT NULL, - CALENDAR_NAME varchar(200) DEFAULT NULL, - MISFIRE_INSTR smallint DEFAULT NULL, - JOB_DATA blob, - PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), - KEY IDX_lams_qtz_T_J (SCHED_NAME,JOB_NAME,JOB_GROUP), - KEY IDX_lams_qtz_T_JG (SCHED_NAME,JOB_GROUP), - KEY IDX_lams_qtz_T_C (SCHED_NAME,CALENDAR_NAME), - KEY IDX_lams_qtz_T_G (SCHED_NAME,TRIGGER_GROUP), - KEY IDX_lams_qtz_T_STATE (SCHED_NAME,TRIGGER_STATE), - KEY IDX_lams_qtz_T_N_STATE (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE), - KEY IDX_lams_qtz_T_N_G_STATE (SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE), - KEY IDX_lams_qtz_T_NEXT_FIRE_TIME (SCHED_NAME,NEXT_FIRE_TIME), - KEY IDX_lams_qtz_T_NFT_ST (SCHED_NAME,TRIGGER_STATE,NEXT_FIRE_TIME), - KEY IDX_lams_qtz_T_NFT_MISFIRE (SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME), - KEY IDX_lams_qtz_T_NFT_ST_MISFIRE (SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_STATE), - KEY IDX_lams_qtz_T_NFT_ST_MISFIRE_GRP (SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_GROUP,TRIGGER_STATE), - CONSTRAINT lams_qtz_TRIGGERS_ibfk_1 FOREIGN KEY (SCHED_NAME, JOB_NAME, JOB_GROUP) REFERENCES lams_qtz_job_details (SCHED_NAME, JOB_NAME, JOB_GROUP) + SCHED_NAME varchar(120) NOT NULL, + TRIGGER_NAME varchar(200) NOT NULL, + TRIGGER_GROUP varchar(200) NOT NULL, + JOB_NAME varchar(200) NOT NULL, + JOB_GROUP varchar(200) NOT NULL, + `DESCRIPTION` varchar(250) DEFAULT NULL, + NEXT_FIRE_TIME bigint DEFAULT NULL, + PREV_FIRE_TIME bigint DEFAULT NULL, + PRIORITY int DEFAULT NULL, + TRIGGER_STATE varchar(16) NOT NULL, + TRIGGER_TYPE varchar(8) NOT NULL, + START_TIME bigint NOT NULL, + END_TIME bigint DEFAULT NULL, + CALENDAR_NAME varchar(200) DEFAULT NULL, + MISFIRE_INSTR smallint DEFAULT NULL, + JOB_DATA blob, + PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP), + KEY IDX_lams_qtz_T_J (SCHED_NAME,JOB_NAME,JOB_GROUP), + KEY IDX_lams_qtz_T_JG (SCHED_NAME,JOB_GROUP), + KEY IDX_lams_qtz_T_C (SCHED_NAME,CALENDAR_NAME), + KEY IDX_lams_qtz_T_G (SCHED_NAME,TRIGGER_GROUP), + KEY IDX_lams_qtz_T_STATE (SCHED_NAME,TRIGGER_STATE), + KEY IDX_lams_qtz_T_N_STATE (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE), + KEY IDX_lams_qtz_T_N_G_STATE (SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE), + KEY IDX_lams_qtz_T_NEXT_FIRE_TIME (SCHED_NAME,NEXT_FIRE_TIME), + KEY IDX_lams_qtz_T_NFT_ST (SCHED_NAME,TRIGGER_STATE,NEXT_FIRE_TIME), + KEY IDX_lams_qtz_T_NFT_MISFIRE (SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME), + KEY IDX_lams_qtz_T_NFT_ST_MISFIRE (SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_STATE), + KEY IDX_lams_qtz_T_NFT_ST_MISFIRE_GRP (SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_GROUP,TRIGGER_STATE), + CONSTRAINT lams_qtz_TRIGGERS_ibfk_1 FOREIGN KEY (SCHED_NAME, JOB_NAME, JOB_GROUP) REFERENCES lams_qtz_job_details (SCHED_NAME, JOB_NAME, JOB_GROUP) ); INSERT INTO lams_qtz_job_details VALUES ('LAMS','Resend Messages Job','DEFAULT',NULL,'org.lamsfoundation.lams.events.ResendMessagesJob','1','0','0','0',0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787000737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F40000000000010770800000010000000007800); Index: lams_common/db/sql/insert_lams_config_data.sql =================================================================== diff -u -r812d599154aefa64ac8c3db4cdecdc1b679706af -r10db06081c24c1566659b76698016e844de327a5 --- lams_common/db/sql/insert_lams_config_data.sql (.../insert_lams_config_data.sql) (revision 812d599154aefa64ac8c3db4cdecdc1b679706af) +++ lams_common/db/sql/insert_lams_config_data.sql (.../insert_lams_config_data.sql) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -1,20 +1,18 @@ INSERT INTO lams_configuration VALUES -('AdminScreenSize','1280x720','config.admin.screen.size','config.header.look.feel','STRING',1), ('AllowDirectAccessIntgrtnLrnr','false','config.allow.direct.access.for.integration.learners','config.header.features','BOOLEAN',1), ('AllowDirectLessonLaunch','false','config.allow.direct.lesson.launch','config.header.features','BOOLEAN',1), ('AllowKumalive','true','config.allow.kumalive','config.header.features','BOOLEAN',1), ('AllowLiveEdit','true','config.allow.live.edit','config.header.features','BOOLEAN',1), ('AntivirusEnable','false','config.av.enable','config.header.antivirus','BOOLEAN',1), ('AntivirusHost','localhost','config.av.host','config.header.antivirus','STRING',0), ('AntivirusPort','3310','config.av.port','config.header.antivirus','LONG',0), -('AuthoringScreenSize','1280x720','config.authoring.screen.size','config.header.look.feel','STRING',1), ('CleanupPreviewOlderThanDays','7','config.cleanup.preview.older.than.days','config.header.system','LONG',1), ('ConfigCacheRefreshInterval','0','config.cache.refresh','config.header.system','LONG',0), ('ContentRepositoryPath','@contentrepository.directory@','config.content.repository.path','config.header.uploads','STRING',1), ('CustomTabLink','','config.custom.tab.link','config.header.look.feel','STRING',0), ('CustomTabTitle','','config.custom.tab.title','config.header.look.feel','STRING',0), ('DefaultTheme','defaultHTML','config.default.html.theme','config.header.look.feel','STRING',1), -('DictionaryDateCreated','2021-10-25','config.dictionary.date.created','config.header.versions','STRING',1), +('DictionaryDateCreated','2023-03-25','config.dictionary.date.created','config.header.versions','STRING',1), ('DisplayPortrait','true','config.display.portrait','config.header.look.feel','BOOLEAN',0), ('DisplayPrintButton','false','config.display.print.button','config.header.features','BOOLEAN',1), ('EARDir','@ear.directory@','config.ear.dir','config.header.system','STRING',1), @@ -65,11 +63,9 @@ ('LDAPSecurityProtocol','','config.ldap.security.protocol','config.header.ldap','STRING',0), ('LDAPStateAttr','st','admin.user.state','config.header.ldap.attributes','STRING',0), ('LDAPUpdateOnLogin','true','config.ldap.update.on.login','config.header.ldap','BOOLEAN',1), -('LearnerScreenSize','1280x720','config.learner.screen.size','config.header.look.feel','STRING',1), ('LearningOutcomeQuickAddEnable','true','config.learning.outcome.add.enable','config.header.features','BOOLEAN',1), ('LockOutTime','5','config.lock.out.time','config.header.password.policy','LONG',1), ('LoginAsEnable','true','config.login.as.enable','config.header.privacy.settings','BOOLEAN',1), -('MonitorScreenSize','1280x720','config.monitor.screen.size','config.header.look.feel','STRING',1), ('PasswordExpirationMonths','12','config.password.expiration','config.header.password.policy','LONG',1), ('PasswordHistoryLimit','3','config.password.history','config.header.password.policy','LONG',1), ('PasswordPolicyLowercase','true','config.password.lowercase','config.header.password.policy','BOOLEAN',0), @@ -93,7 +89,7 @@ ('ServerPageDirection','LTR','config.server.page.direction','config.header.look.feel','STRING',1), ('ServerURL','http://localhost:8080/lams/','config.server.url','config.header.system','STRING',1), ('ServerURLContextPath','lams/','config.server.url.context.path','config.header.system','STRING',1), -('ServerVersionNumber','4.6','config.server.version.number','config.header.versions','STRING',1), +('ServerVersionNumber','4.7','config.server.version.number','config.header.versions','STRING',1), ('ShowAllMyLessonLink','true','config.show.all.my.lesson.link','config.header.features','BOOLEAN',1), ('ShowTimezoneWarning','true','config.show.timezone.warning','config.header.features','BOOLEAN',1), ('SiteName','LAMS','config.site.name','config.header.system','STRING',1), @@ -111,4 +107,4 @@ ('UserValidationEmail','true','config.user.validation.emails','config.header.user.validation','BOOLEAN',0), ('UserValidationFirstLastName','true','config.user.validation.first.last.name','config.header.user.validation','BOOLEAN',0), ('UserValidationUsername','true','config.user.validation.username','config.header.user.validation','BOOLEAN',0), -('Version','4.6','config.version','config.header.system','STRING',1); \ No newline at end of file +('Version','4.7','config.version','config.header.system','STRING',1); \ No newline at end of file Index: lams_common/db/sql/insert_lams_users.sql =================================================================== diff -u -r0830e8691458c7833c2aa84cfd18806b34daeaa8 -r10db06081c24c1566659b76698016e844de327a5 --- lams_common/db/sql/insert_lams_users.sql (.../insert_lams_users.sql) (revision 0830e8691458c7833c2aa84cfd18806b34daeaa8) +++ lams_common/db/sql/insert_lams_users.sql (.../insert_lams_users.sql) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -125,4 +125,5 @@ (71,27,5), (72,28,5), (73,29,5), -(74,18,2); \ No newline at end of file +(74,18,2), +(75,1,7); \ No newline at end of file Index: lams_common/db/sql/insert_types_data.sql =================================================================== diff -u -r812d599154aefa64ac8c3db4cdecdc1b679706af -r10db06081c24c1566659b76698016e844de327a5 --- lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision 812d599154aefa64ac8c3db4cdecdc1b679706af) +++ lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -16,8 +16,8 @@ (1,'INTEGRATED SERVER'), (2,'LTI TOOL CONSUMER'); -INSERT INTO lams_ext_server_org_map VALUES -(1,'moodle','moodle','moodle','moodle','mdl','http://localhost/moodle/mod/lamstwo/userinfo.php?ts=%timestamp%&un=%username%&hs=%hash%','',NULL,0x01,80,0,NULL,1,NULL,0,0,1,1,0,0,1,NULL,NULL); +INSERT INTO lams_ext_server_org_map (sid, serverid, serverkey, servername, serverdesc, prefix, userinfo_url, disabled) VALUES +(1,'moodle','moodle','moodle','moodle','mdl','http://localhost/moodle/mod/lamstwo/userinfo.php?ts=%timestamp%&un=%username%&hs=%hash%',1); INSERT INTO lams_gate_activity_level VALUES (1,'LEARNER'), @@ -130,9 +130,9 @@ (4,'TYPE_OTHER'); INSERT INTO lams_qb_question VALUES -(1,0x71B92B1038C811ED8F4600D8618629BB,1,1,1,'2022-09-20 11:39:19','93b97f99-a9ad-471b-a71a-5cc58ab2196e','A Sample question?','A Sample question?',1,NULL,0,0,0,NULL,NULL,NULL,0,0,0,0,0,0,0,NULL,0,0), -(2,0x71EFEAD338C811ED8F4600D8618629BB,1,2,1,'2022-09-20 11:40:08','93b97f99-a9ad-471b-a71a-5cc58ab2196e','Question Title','Question Description',NULL,NULL,0,0,0,NULL,NULL,NULL,0,0,0,0,0,0,0,NULL,0,0), -(3,0x72E874A938C811ED8F4600D8618629BB,6,3,1,'2022-09-20 11:39:26','93b97f99-a9ad-471b-a71a-5cc58ab2196e','Sample Question 1?','Sample Question 1?',1,NULL,0,0,0,NULL,NULL,NULL,0,0,0,0,0,0,0,NULL,0,0); +(1,0xC3A4FAD2A0C611EE8D61B025AA5E5BB6,1,1,1,'2022-09-20 11:39:19','93b97f99-a9ad-471b-a71a-5cc58ab2196e','A Sample question?','A Sample question?',1,NULL,0,0,0,NULL,NULL,NULL,0,0,0,0,0,0,0,0,NULL,0,0), +(2,0xC3A4FE96A0C611EE8D61B025AA5E5BB6,1,2,1,'2022-09-20 11:40:08','93b97f99-a9ad-471b-a71a-5cc58ab2196e','Question Title','Question Description',NULL,NULL,0,0,0,NULL,NULL,NULL,0,0,0,0,0,0,0,0,NULL,0,0), +(3,0xC3A4FFEDA0C611EE8D61B025AA5E5BB6,6,3,1,'2022-09-20 11:39:26','93b97f99-a9ad-471b-a71a-5cc58ab2196e','Sample Question 1?','Sample Question 1?',1,NULL,0,0,0,NULL,NULL,NULL,0,0,0,0,0,0,0,0,NULL,0,0); INSERT INTO lams_qb_option VALUES (1,1,1,'Answer 1',NULL,0,0,0,NULL), @@ -157,11 +157,12 @@ (4,'LESSON'); INSERT INTO lams_role VALUES -(1,'SYSADMIN','LAMS System Adminstrator','2022-09-20 11:38:25'), -(2,'GROUP MANAGER','Group Manager','2022-09-20 11:38:25'), -(3,'AUTHOR','Authors Learning Designs','2022-09-20 11:38:25'), -(4,'MONITOR','Member of Staff','2022-09-20 11:38:25'), -(5,'LEARNER','Student','2022-09-20 11:38:25'); +(1,'APPADMIN','LAMS System Administrator', NOW()), +(2,'GROUP MANAGER','Group Manager', NOW()), +(3,'AUTHOR','Authors Learning Designs', NOW()), +(4,'MONITOR','Member of Staff', NOW()), +(5,'LEARNER','Student', NOW()), +(7,'SYSADMIN', 'LAMS System Administrator', NOW()); INSERT INTO lams_sequence_generator VALUES (3); @@ -256,4 +257,4 @@ (3,'PUBLIC SEQUENCES'); INSERT INTO patches VALUES -('lams', 20211025, NOW(), 'F'); \ No newline at end of file +('lams', 20230325, NOW(), 'F'); \ No newline at end of file Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20220126.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20220201.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20220210.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20220411.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20220503.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20220528.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20220920.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20221003.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20221118.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20230127.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20230219.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20230324.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20230324_updateTo47.sql =================================================================== diff -u --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20230324_updateTo47.sql (revision 0) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20230324_updateTo47.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,94 @@ +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS = 0; + +-- This patch contains files patch20220126.sql to patch20230324.sql +-- It should upgrade LAMS to version 4.7 + +--LDEV-5277 Add LTI Advantage model +ALTER TABLE lams_ext_server_lesson_map ADD COLUMN lti_adv_deployment_id VARCHAR(255), + ADD COLUMN lti_adv_grading_type VARCHAR(10), + ADD COLUMN lti_adv_grading_url VARCHAR(255); + +ALTER TABLE lams_ext_server_org_map ADD COLUMN use_course_prefix TINYINT NOT NULL DEFAULT 1, + ADD COLUMN user_registration_enabled TINYINT NOT NULL DEFAULT 1, + ADD COLUMN user_name_lower_case TINYINT NOT NULL DEFAULT 0, + + ADD COLUMN lti_adv_enforce_cookie TINYINT NOT NULL DEFAULT 0, + ADD COLUMN lti_adv_reregistration_enabled TINYINT NOT NULL DEFAULT 1, + ADD COLUMN lti_adv_issuer VARCHAR(64), + ADD COLUMN lti_adv_client_id VARCHAR(64), + ADD COLUMN lti_adv_platform_key_set_url VARCHAR(255), + ADD COLUMN lti_adv_oidc_auth_url VARCHAR(255), + ADD COLUMN lti_adv_access_token_url VARCHAR(255), + ADD COLUMN lti_adv_tool_name VARCHAR(64), + ADD COLUMN lti_adv_tool_description VARCHAR(255), + ADD COLUMN lti_adv_tool_key_set_url VARCHAR(255), + ADD COLUMN lti_adv_tool_key_id VARCHAR(32), + ADD COLUMN lti_adv_public_key TEXT, + ADD COLUMN lti_adv_private_key TEXT; + +--LDEV-5277 Add default country, locale and timezone to LTI consumer + +ALTER TABLE lams_ext_server_org_map ADD COLUMN default_country CHAR(2) AFTER user_id_parameter_name, + ADD COLUMN default_locale_id TINYINT UNSIGNED AFTER default_country, + ADD COLUMN default_timezone VARCHAR(255) AFTER default_locale_id; + +--LDEV-5286 + +ALTER TABLE lams_ext_server_org_map ADD COLUMN add_staff_to_all_lessons TINYINT NOT NULL DEFAULT 0 AFTER time_to_live_login_request_enabled; + +--LDEV-5307 Allow exact matching of VSAs + +ALTER TABLE lams_qb_question ADD COLUMN exact_match TINYINT NOT NULL DEFAULT 0 AFTER case_sensitive; + +--LDEV-5277 Add ID for communication with LTI Advantage platform, which is not necessarily the same as external user ID + +ALTER TABLE lams_ext_user_userid_map ADD COLUMN lti_adv_username VARCHAR(250) AFTER external_username; + +-- LDEV-5316 Change content folder ID to default one for questions which have images referring the default content folder +-- and which do not have images which refer a new content folder + +UPDATE lams_qb_question AS q LEFT JOIN lams_qb_option AS o ON q.uid = o.qb_question_uid + SET q.content_folder_id = '12345678-9012-abcd-0123-4567890abcde' +WHERE (q.description LIKE '%secure/12/34/56/78/90/12/%' OR o.name LIKE '%secure/12/34/56/78/90/12/%') + AND (q.content_folder_id IS NULL OR (q.description NOT LIKE CONCAT('%secure/', SUBSTRING(q.content_folder_id, 0, 2)) + AND (o.uid IS NULL OR o.name NOT LIKE CONCAT('%secure/', SUBSTRING(q.content_folder_id, 0, 2))))); + +-- LDEV-5328 Bump version +UPDATE lams_configuration SET config_value = '4.6' WHERE config_key = 'ServerVersionNumber'; + +-- LDEV-5329 Remove obsolete configuration items +DELETE FROM lams_configuration WHERE config_key IN ('AuthoringScreenSize', 'MonitorScreenSize', 'LearnerScreenSize', 'AdminScreenSize'); + +-- LDEV-5302 Rename SYSADMIN to APPADMIN, add new SYSADMIN role + +UPDATE lams_role SET name = 'APPADMIN', description = 'LAMS Application Administrator' WHERE name = 'SYSADMIN'; + +INSERT INTO lams_role(role_id, name, description, create_date) VALUES (7, 'SYSADMIN', 'LAMS System Administrator', NOW()); +INSERT INTO lams_user_organisation_role SELECT NULL, user_organisation_id, 7 FROM lams_user_organisation_role WHERE role_id = 1; + +-- LDEV-5357 Use complex UUIDs for all files +ALTER TABLE lams_cr_node RENAME COLUMN portrait_uuid TO uuid, + RENAME INDEX IDX_portrait_uuid TO IDX_uuid; + +UPDATE lams_cr_node SET uuid = UUID_TO_BIN(LOWER(CONCAT( + HEX(RANDOM_BYTES(4)), '-', + HEX(RANDOM_BYTES(2)), '-4', + SUBSTR(HEX(RANDOM_BYTES(2)), 2, 3), '-', + CONCAT(HEX(FLOOR(ASCII(RANDOM_BYTES(1)) / 64)+8),SUBSTR(HEX(RANDOM_BYTES(2)), 2, 3)), '-', + HEX(RANDOM_BYTES(6)) +))) WHERE uuid IS NULL; + +-- SP-4 Prevent duplicates in ext user mapping table +ALTER TABLE lams_ext_user_userid_map ADD KEY UQ_lams_ext_user_userid_map_2 (external_username); +DELETE a FROM lams_ext_user_userid_map AS a JOIN (SELECT sid, ext_server_org_map_id, external_username FROM lams_ext_user_userid_map GROUP BY ext_server_org_map_id, external_username) AS b USING (ext_server_org_map_id, external_username) WHERE a.sid <> b.sid; +ALTER TABLE lams_ext_user_userid_map ADD UNIQUE KEY UQ_lams_ext_user_userid_map_1 (ext_server_org_map_id, external_username); + +-- LDEV-5277 Remove prefix uniqueness as sometimes duplicate feature becomes an useful feature + +ALTER TABLE lams_ext_server_org_map DROP KEY prefix; + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20230325.sql (revision 0) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,15 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Bump version +UPDATE lams_configuration SET config_value = '4.7' WHERE config_key = 'ServerVersionNumber'; + + +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_assessment/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_assessment/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_assessment/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,7 +2,7 @@ min.server.version.number=4.6 signature=laasse10 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=assessment Index: lams_tool_assessment/db/sql/create_lams_tool_assessment.sql =================================================================== diff -u -r812d599154aefa64ac8c3db4cdecdc1b679706af -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_assessment/db/sql/create_lams_tool_assessment.sql (.../create_lams_tool_assessment.sql) (revision 812d599154aefa64ac8c3db4cdecdc1b679706af) +++ lams_tool_assessment/db/sql/create_lams_tool_assessment.sql (.../create_lams_tool_assessment.sql) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -26,6 +26,7 @@ allow_answer_justification tinyint DEFAULT '0', allow_discussion_sentiment tinyint DEFAULT '0', display_summary tinyint(1) DEFAULT NULL, + display_max_mark TINYINT NOT NULL DEFAULT 0, questions_per_page int DEFAULT '0', shuffled tinyint(1) DEFAULT NULL, attempt_completion_notify tinyint(1) DEFAULT '0', @@ -137,20 +138,24 @@ DROP TABLE IF EXISTS tl_laasse10_question_result; CREATE TABLE tl_laasse10_question_result ( - uid bigint NOT NULL AUTO_INCREMENT, - result_uid bigint DEFAULT NULL, - answer_float float DEFAULT NULL, - answer_boolean tinyint(1) DEFAULT NULL, - mark float DEFAULT NULL, - penalty float DEFAULT NULL, - finish_date datetime DEFAULT NULL, - max_mark float DEFAULT NULL, - confidence_level int NOT NULL DEFAULT '0', - justification varchar(10000) DEFAULT NULL, - PRIMARY KEY (uid), - KEY FK_tl_laasse10_question_result_1 (result_uid), - CONSTRAINT FK_tl_laasse10_question_result_1 FOREIGN KEY (result_uid) REFERENCES tl_laasse10_assessment_result (uid) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK_tl_laasse10_question_result_2 FOREIGN KEY (uid) REFERENCES lams_qb_tool_answer (answer_uid) ON DELETE CASCADE ON UPDATE CASCADE + uid bigint NOT NULL AUTO_INCREMENT, + result_uid bigint DEFAULT NULL, + answer_float float DEFAULT NULL, + answer_boolean tinyint(1) DEFAULT NULL, + mark float DEFAULT NULL, + penalty float DEFAULT NULL, + finish_date datetime DEFAULT NULL, + max_mark float DEFAULT NULL, + confidence_level int NOT NULL DEFAULT '0', + justification varchar(10000) DEFAULT NULL, + marked_by bigint DEFAULT NULL, + marker_comment varchar(100) DEFAULT NULL, + PRIMARY KEY (uid), + KEY FK_tl_laasse10_question_result_1 (result_uid), + KEY FK_tl_laasse10_question_result_3 (marked_by), + CONSTRAINT FK_tl_laasse10_question_result_1 FOREIGN KEY (result_uid) REFERENCES tl_laasse10_assessment_result (uid) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_tl_laasse10_question_result_2 FOREIGN KEY (uid) REFERENCES lams_qb_tool_answer (answer_uid) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK_tl_laasse10_question_result_3 FOREIGN KEY (marked_by) REFERENCES lams_user (user_id) ON DELETE SET NULL ON UPDATE CASCADE ); DROP TABLE IF EXISTS tl_laasse10_session; @@ -203,8 +208,21 @@ CONSTRAINT FK_NEW_1720029621_30113BFCEC0D3147 FOREIGN KEY (session_uid) REFERENCES tl_laasse10_session (uid) ON DELETE CASCADE ON UPDATE CASCADE ); -INSERT INTO tl_laasse10_configuration VALUES ('hideTitles','false'); +DROP TABLE IF EXISTS tl_laasse10_section; +CREATE TABLE tl_laasse10_section ( + uid mediumint unsigned NOT NULL AUTO_INCREMENT, + assessment_uid bigint DEFAULT NULL, + display_order tinyint unsigned NOT NULL DEFAULT '1', + `name` varchar(100) DEFAULT NULL, + question_count tinyint unsigned NOT NULL, + PRIMARY KEY (uid), + KEY FK_tl_laasse10_section_1 (assessment_uid), + CONSTRAINT FK_tl_laasse10_section_1 FOREIGN KEY (assessment_uid) REFERENCES tl_laasse10_assessment (uid) ON DELETE CASCADE ON UPDATE CASCADE +); + +INSERT INTO tl_laasse10_configuration VALUES ('hideTitles','false'), ('autoexpandJustification', 'false'); + INSERT INTO tl_laasse10_assessment (uid, title, instructions, define_later, content_id, allow_question_feedback, allow_overall_feedback, allow_right_answers, allow_wrong_answers, allow_grades_after_attempt, allow_history_responses, display_summary, shuffled) VALUES Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20220920.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20221220.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20230202.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20230207.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20230208.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20230217.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20230227.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20230309.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20230309_updateTo47.sql =================================================================== diff -u --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20230309_updateTo47.sql (revision 0) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20230309_updateTo47.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,45 @@ +SET FOREIGN_KEY_CHECKS = 0; + +-- This patch contains files patch20221220.sql to patch20230309.sql +-- It should upgrade this tool to version 4.7 + +-- LDEV-5351 Tell whether and which teacher marked the question manually +ALTER TABLE tl_laasse10_question_result + ADD COLUMN marked_by BIGINT, + ADD CONSTRAINT FK_tl_laasse10_question_result_3 FOREIGN KEY (marked_by) REFERENCES tl_laasse10_user(uid) + ON UPDATE CASCADE ON DELETE SET NULL; + +-- LDEV-5359 Add question sections +CREATE TABLE tl_laasse10_section( + uid MEDIUMINT UNSIGNED NOT NULL auto_increment, + assessment_uid BIGINT, + display_order TINYINT UNSIGNED NOT NULL DEFAULT '1', + name VARCHAR(100), + question_count TINYINT UNSIGNED NOT NULL, + CONSTRAINT FK_tl_laasse10_section_1 FOREIGN KEY (assessment_uid) REFERENCES tl_laasse10_assessment(uid) + ON UPDATE CASCADE ON DELETE CASCADE, + PRIMARY KEY (uid) +); + +-- LDEV-5360 Add marker's comment column to question result +ALTER TABLE tl_laasse10_question_result + ADD COLUMN marker_comment VARCHAR(100); + +-- LDEV-5360 Use core Users and not AssessmentUsers for marker column +UPDATE tl_laasse10_question_result AS r JOIN tl_laasse10_user AS u ON r.marked_by = u.uid + SET r.marked_by = u.user_id; + +-- LDEV-5366 Allow autoexpanding justification panel on question answer +INSERT INTO `tl_laasse10_configuration` (`config_key`, `config_value`) VALUES ('autoexpandJustification', 'false'); + +-- LDEV-5360 Use core Users and not AssessmentUsers for marker column +ALTER TABLE tl_laasse10_question_result +DROP FOREIGN KEY FK_tl_laasse10_question_result_3; +ALTER TABLE tl_laasse10_question_result + ADD CONSTRAINT FK_tl_laasse10_question_result_3 FOREIGN KEY (marked_by) REFERENCES lams_user(user_id) + ON UPDATE CASCADE ON DELETE SET NULL; + +-- LDEV-5374 Show max mark next to each question +ALTER TABLE tl_laasse10_assessment ADD COLUMN display_max_mark TINYINT NOT NULL DEFAULT 0 AFTER display_summary; + +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='laasse10'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_chat/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_chat/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_chat/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,7 +2,7 @@ min.server.version.number=4.6 signature=lachat11 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=chat Index: lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='lachat11'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_daco/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_daco/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_daco/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,9 +2,9 @@ min.server.version.number=4.6 signature=ladaco10 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=daco # SCSS Directories - override value in common.properties -scss.css.dir=${basedir}/web/includes/css +scss.css.dir=${basedir}/web/includes/css \ No newline at end of file Index: lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='ladaco10'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_doku/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_doku/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_doku/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,6 +2,6 @@ min.server.version.number=4.6 signature=ladoku11 -tool.version=20220101 +tool.version=20230331 tool.hide=false tool.short.name=dokumaran \ No newline at end of file Index: lams_tool_doku/db/sql/create_lams_tool_dokumaran.sql =================================================================== diff -u -r812d599154aefa64ac8c3db4cdecdc1b679706af -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_doku/db/sql/create_lams_tool_dokumaran.sql (.../create_lams_tool_dokumaran.sql) (revision 812d599154aefa64ac8c3db4cdecdc1b679706af) +++ lams_tool_doku/db/sql/create_lams_tool_dokumaran.sql (.../create_lams_tool_dokumaran.sql) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -21,6 +21,8 @@ allow_multiple_leaders tinyint DEFAULT NULL, reflect_instructions mediumtext, reflect_on_activity smallint DEFAULT NULL, + max_mark TINYINT UNSIGNED NOT NULL DEFAULT '100', + submission_deadline DATETIME, relative_time_limit smallint unsigned NOT NULL DEFAULT '0', absolute_time_limit datetime DEFAULT NULL, gallery_walk_enabled tinyint NOT NULL DEFAULT '0', Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20220920.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20221116.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20230330.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20230330_updateTo47.sql =================================================================== diff -u --- lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20230330_updateTo47.sql (revision 0) +++ lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20230330_updateTo47.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,12 @@ +SET FOREIGN_KEY_CHECKS = 0; + +-- This patch contains files patch20221116.sql to patch20230330.sql +-- It should upgrade this tool to version 4.7 + +-- LDEV-5331 Add submission deadline +ALTER TABLE tl_ladoku11_dokumaran ADD COLUMN submission_deadline DATETIME AFTER reflect_on_activity; + +-- LDEV-5378 Add max mark for whole dokumaran activity +ALTER TABLE tl_ladoku11_dokumaran ADD COLUMN max_mark TINYINT UNSIGNED NOT NULL DEFAULT '100' AFTER reflect_on_activity; + +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20230331.sql =================================================================== diff -u --- lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20230331.sql (revision 0) +++ lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20230331.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230331' WHERE tool_signature='ladoku11'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_forum/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_forum/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_forum/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,6 +2,6 @@ min.server.version.number=4.6 signature=lafrum11 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=forum \ No newline at end of file Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='lafrum11'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_images/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_images/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_images/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,9 +2,9 @@ min.server.version.number=4.6 signature=laimag10 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=imageGallery # SCSS Directories - override value in common.properties -scss.css.dir=${basedir}/web/includes/css +scss.css.dir=${basedir}/web/includes/css \ No newline at end of file Index: lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='laimag10'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_imscc/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_imscc/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_imscc/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,6 +2,6 @@ min.server.version.number=4.6 signature=laimsc11 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=commonCartridge \ No newline at end of file Index: lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='laimsc11'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_lamc/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_lamc/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_lamc/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,6 +2,6 @@ min.server.version.number=4.6 signature=lamc11 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=mc \ No newline at end of file Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='lamc11'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_laqa/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_laqa/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_laqa/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,9 +2,9 @@ min.server.version.number=4.6 signature=laqa11 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=qa # SCSS Directories - override value in common.properties -scss.css.dir=${basedir}/web/includes/css +scss.css.dir=${basedir}/web/includes/css \ No newline at end of file Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='laqa11'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_larsrc/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_larsrc/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_larsrc/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,6 +2,6 @@ min.server.version.number=4.6 signature=larsrc11 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=rsrc \ No newline at end of file Index: lams_tool_larsrc/db/sql/create_lams_tool_rsrc.sql =================================================================== diff -u -r8cb3b47e0bc1e7d89582929aa33ee29f0ef37189 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_larsrc/db/sql/create_lams_tool_rsrc.sql (.../create_lams_tool_rsrc.sql) (revision 8cb3b47e0bc1e7d89582929aa33ee29f0ef37189) +++ lams_tool_larsrc/db/sql/create_lams_tool_rsrc.sql (.../create_lams_tool_rsrc.sql) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -1,121 +1,105 @@ SET FOREIGN_KEY_CHECKS=0; -create table tl_larsrc11_resource ( - uid bigint not null auto_increment, - create_date datetime, - update_date datetime, - create_by bigint, - title varchar(255), - lock_on_finished TINYINT(1), - instructions MEDIUMTEXT, - content_in_use TINYINT(1), - define_later TINYINT(1), - content_id bigint, - allow_add_files TINYINT(1), - allow_add_urls TINYINT(1), - mini_view_resource_number integer, - allow_auto_run TINYINT(1), - reflect_instructions MEDIUMTEXT, - reflect_on_activity TINYINT(1), - assigment_submit_notify TINYINT(1) DEFAULT 0, - file_upload_notify TINYINT(1) DEFAULT 0, - PRIMARY KEY (uid), - UNIQUE KEY content_id (content_id) -); -create table tl_larsrc11_session ( - uid bigint not null auto_increment, - session_end_date datetime, - session_start_date datetime, - status integer, - resource_uid bigint, - session_id bigint, - session_name varchar(250), - primary key (uid), - UNIQUE KEY session_id (session_id), - CONSTRAINT FK24AA78C530E79035 FOREIGN KEY (resource_uid) - REFERENCES tl_larsrc11_resource (uid) ON DELETE CASCADE ON UPDATE CASCADE +CREATE TABLE tl_larsrc11_item_log ( + uid bigint NOT NULL AUTO_INCREMENT, + access_date datetime DEFAULT NULL, + complete_date datetime DEFAULT NULL, + resource_item_uid bigint DEFAULT NULL, + user_uid bigint DEFAULT NULL, + complete tinyint(1) DEFAULT NULL, + session_id bigint DEFAULT NULL, + PRIMARY KEY (uid), + KEY idx_item_log_session_id (session_id), + KEY FK693580A438BF8DFE (resource_item_uid), + KEY FK693580A441F9365D (user_uid), + CONSTRAINT FK693580A438BF8DFE FOREIGN KEY (resource_item_uid) REFERENCES tl_larsrc11_resource_item (uid) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FK693580A441F9365D FOREIGN KEY (user_uid) REFERENCES tl_larsrc11_user (uid) ON DELETE CASCADE ON UPDATE CASCADE ); -create table tl_larsrc11_user ( - uid bigint not null auto_increment, - user_id bigint, - last_name varchar(255), - first_name varchar(255), - login_name varchar(255), - session_finished TINYINT(1), - session_uid bigint, - resource_uid bigint, - primary key (uid), - KEY idx_user_user_id (user_id), - CONSTRAINT FK30113BFC309ED320 FOREIGN KEY (resource_uid) - REFERENCES tl_larsrc11_resource (uid) ON DELETE SET NULL ON UPDATE CASCADE, - CONSTRAINT FK30113BFCEC0D3147 FOREIGN KEY (session_uid) - REFERENCES tl_larsrc11_session (uid) ON DELETE CASCADE ON UPDATE CASCADE +CREATE TABLE tl_larsrc11_resource ( + uid bigint NOT NULL AUTO_INCREMENT, + create_date datetime DEFAULT NULL, + update_date datetime DEFAULT NULL, + create_by bigint DEFAULT NULL, + title varchar(255) DEFAULT NULL, + lock_on_finished tinyint(1) DEFAULT NULL, + instructions mediumtext, + content_in_use tinyint(1) DEFAULT NULL, + define_later tinyint(1) DEFAULT NULL, + content_id bigint DEFAULT NULL, + allow_add_files tinyint(1) DEFAULT NULL, + allow_add_urls tinyint(1) DEFAULT NULL, + mini_view_resource_number int DEFAULT NULL, + reflect_instructions mediumtext, + reflect_on_activity tinyint(1) DEFAULT NULL, + assigment_submit_notify tinyint(1) DEFAULT '0', + file_upload_notify tinyint(1) DEFAULT '0', + PRIMARY KEY (uid), + UNIQUE KEY content_id (content_id), + KEY FK89093BF758092FB (create_by), + CONSTRAINT FK89093BF758092FB FOREIGN KEY (create_by) REFERENCES tl_larsrc11_user (uid) ON DELETE SET NULL ON UPDATE CASCADE ); -create table tl_larsrc11_resource_item ( - uid bigint not null auto_increment, - file_uuid bigint, - file_version_id bigint, - description varchar(255), - ims_schema varchar(255), - init_item varchar(255), - organization_xml text, - title varchar(255), - url text, - create_by bigint, - create_date datetime, - create_by_author tinyint(1), - is_hide tinyint(1), - item_type smallint, - file_type varchar(255), - file_name varchar(255), - open_url_new_window tinyint(1), - resource_uid bigint, - session_uid bigint, - order_id integer, - is_allow_rating TINYINT(1) default 0, - is_allow_comments TINYINT(1) default 0, - primary key (uid), - CONSTRAINT FKF52D1F9330E79035 FOREIGN KEY (resource_uid) - REFERENCES tl_larsrc11_resource (uid) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FKF52D1F93758092FB FOREIGN KEY (create_by) - REFERENCES tl_larsrc11_user (uid) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FKF52D1F93EC0D3147 FOREIGN KEY (session_uid) - REFERENCES tl_larsrc11_session (uid) ON DELETE CASCADE ON UPDATE CASCADE +CREATE TABLE tl_larsrc11_resource_item ( + uid bigint NOT NULL AUTO_INCREMENT, + file_uuid bigint DEFAULT NULL, + file_version_id bigint DEFAULT NULL, + instructions text, + title varchar(255) DEFAULT NULL, + `url` text, + create_by bigint DEFAULT NULL, + create_date datetime DEFAULT NULL, + create_by_author tinyint(1) DEFAULT NULL, + is_hide tinyint(1) DEFAULT NULL, + item_type smallint DEFAULT NULL, + init_item varchar(255) DEFAULT NULL, + file_type varchar(255) DEFAULT NULL, + file_name varchar(255) DEFAULT NULL, + resource_uid bigint DEFAULT NULL, + session_uid bigint DEFAULT NULL, + order_id int DEFAULT NULL, + is_allow_rating tinyint(1) DEFAULT '0', + is_allow_comments tinyint(1) DEFAULT '0', + PRIMARY KEY (uid), + KEY FKF52D1F9330E79035 (resource_uid), + KEY FKF52D1F93758092FB (create_by), + KEY FKF52D1F93EC0D3147 (session_uid), + CONSTRAINT FKF52D1F9330E79035 FOREIGN KEY (resource_uid) REFERENCES tl_larsrc11_resource (uid) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FKF52D1F93758092FB FOREIGN KEY (create_by) REFERENCES tl_larsrc11_user (uid) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT FKF52D1F93EC0D3147 FOREIGN KEY (session_uid) REFERENCES tl_larsrc11_session (uid) ON DELETE CASCADE ON UPDATE CASCADE ); -create table tl_larsrc11_item_instruction ( - uid bigint not null auto_increment, - description MEDIUMTEXT, - sequence_id integer, - item_uid bigint, - primary key (uid), - CONSTRAINT FKA5665013980570ED FOREIGN KEY (item_uid) - REFERENCES tl_larsrc11_resource_item (uid) ON DELETE CASCADE ON UPDATE CASCADE +CREATE TABLE tl_larsrc11_session ( + uid bigint NOT NULL AUTO_INCREMENT, + session_end_date datetime DEFAULT NULL, + session_start_date datetime DEFAULT NULL, + `status` int DEFAULT NULL, + resource_uid bigint DEFAULT NULL, + session_id bigint DEFAULT NULL, + session_name varchar(250) DEFAULT NULL, + PRIMARY KEY (uid), + UNIQUE KEY session_id (session_id), + KEY FK24AA78C530E79035 (resource_uid), + CONSTRAINT FK24AA78C530E79035 FOREIGN KEY (resource_uid) REFERENCES tl_larsrc11_resource (uid) ON DELETE CASCADE ON UPDATE CASCADE ); -create table tl_larsrc11_item_log ( - uid bigint not null auto_increment, - access_date datetime, - complete_date datetime, - resource_item_uid bigint, - user_uid bigint, - complete tinyint(1), - session_id bigint, - primary key (uid), - KEY idx_item_log_session_id (session_id), - CONSTRAINT FK693580A438BF8DFE FOREIGN KEY (resource_item_uid) - REFERENCES tl_larsrc11_resource_item (uid) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT FK693580A441F9365D FOREIGN KEY (user_uid) - REFERENCES tl_larsrc11_user (uid) ON DELETE CASCADE ON UPDATE CASCADE +CREATE TABLE tl_larsrc11_user ( + uid bigint NOT NULL AUTO_INCREMENT, + user_id bigint DEFAULT NULL, + last_name varchar(255) DEFAULT NULL, + first_name varchar(255) DEFAULT NULL, + login_name varchar(255) DEFAULT NULL, + session_finished tinyint(1) DEFAULT NULL, + session_uid bigint DEFAULT NULL, + resource_uid bigint DEFAULT NULL, + PRIMARY KEY (uid), + KEY idx_user_user_id (user_id), + KEY FK30113BFC309ED320 (resource_uid), + KEY FK30113BFCEC0D3147 (session_uid), + CONSTRAINT FK30113BFC309ED320 FOREIGN KEY (resource_uid) REFERENCES tl_larsrc11_resource (uid) ON DELETE SET NULL ON UPDATE CASCADE, + CONSTRAINT FK30113BFCEC0D3147 FOREIGN KEY (session_uid) REFERENCES tl_larsrc11_session (uid) ON DELETE CASCADE ON UPDATE CASCADE ); - -ALTER TABLE tl_larsrc11_resource ADD CONSTRAINT FK89093BF758092FB FOREIGN KEY (create_by) - REFERENCES tl_larsrc11_user (uid) ON DELETE SET NULL ON UPDATE CASCADE; - - INSERT INTO tl_larsrc11_resource (uid, title, lock_on_finished, instructions, content_in_use, define_later, content_id, allow_add_files, allow_add_urls, mini_view_resource_number, allow_auto_run,reflect_on_activity) VALUES Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20220211.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20220217.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20220920.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20221212.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20221212_updateTo47.sql =================================================================== diff -u --- lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20221212_updateTo47.sql (revision 0) +++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20221212_updateTo47.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,35 @@ +SET FOREIGN_KEY_CHECKS = 0; + +-- This patch contains files from patch20220211.sql to patch20221212.sql +-- It should upgrade this tool to version 4.7 + +-- LDEV-5186 Merge two "notify on submit" column into one +UPDATE tl_larsrc11_resource SET assigment_submit_notify = 1 WHERE file_upload_notify = 1; + +-- LDEV-5287 Use a single instructions field instead of multiple ones +ALTER TABLE tl_larsrc11_resource_item CHANGE COLUMN description instructions TEXT; + +-- set concat max len to its max +-- https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_group_concat_max_len +SET SESSION group_concat_max_len=18446744073709551615; + +UPDATE tl_larsrc11_resource_item AS r JOIN + (SELECT item_uid, GROUP_CONCAT(description ORDER BY sequence_id SEPARATOR '

') AS merged_instructions FROM tl_larsrc11_item_instruction GROUP BY item_uid) + AS i ON r.uid = i.item_uid + SET r.instructions = CONCAT(IF(r.instructions IS NULL OR TRIM(r.instructions) = '', '', CONCAT(TRIM(r.instructions), '

')), i.merged_instructions); + +DROP TABLE tl_larsrc11_item_instruction; + +-- remove zipped website and IMS package item types + +ALTER TABLE tl_larsrc11_resource_item DROP COLUMN organization_xml, +DROP COLUMN ims_schema, + DROP COLUMN init_item; + +-- remove auto run functionality +ALTER TABLE tl_larsrc11_resource DROP COLUMN allow_auto_run; + +-- reintroduce zipped website item types +ALTER TABLE tl_larsrc11_resource_item ADD COLUMN init_item VARCHAR(255) AFTER item_type; + +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='larsrc11'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_leader/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_leader/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_leader/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,6 +2,6 @@ min.server.version.number=4.6 signature=lalead11 -tool.version=20220101 +tool.version=20230325 tool.hide=false -tool.short.name=leaderselection +tool.short.name=leaderselection \ No newline at end of file Index: lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='lalead11'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_mindmap/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_mindmap/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_mindmap/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,8 +2,8 @@ min.server.version.number=4.6 signature=lamind10 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=mindmap -scss.css.dir=${basedir}/web/includes/css +scss.css.dir=${basedir}/web/includes/css \ No newline at end of file Index: lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='lamind10'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_nb/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_nb/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_nb/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,7 +2,7 @@ min.server.version.number=4.6 signature=lanb11 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=noticeboard Index: lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='lanb11'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_notebook/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_notebook/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_notebook/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,6 +2,6 @@ min.server.version.number=4.6 signature=lantbk11 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=notebook \ No newline at end of file Index: lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='lantbk11'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='lapixl10'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_preview/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_preview/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_preview/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,7 +2,7 @@ min.server.version.number=4.6 signature=laprev11 -tool.version=20220101 +tool.version=20230508 tool.hide=false tool.short.name=peerreview Index: lams_tool_preview/db/sql/create_lams_tool_peerreview.sql =================================================================== diff -u -r812d599154aefa64ac8c3db4cdecdc1b679706af -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_preview/db/sql/create_lams_tool_peerreview.sql (.../create_lams_tool_peerreview.sql) (revision 812d599154aefa64ac8c3db4cdecdc1b679706af) +++ lams_tool_preview/db/sql/create_lams_tool_peerreview.sql (.../create_lams_tool_peerreview.sql) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -20,6 +20,9 @@ self_review tinyint(1) DEFAULT 0, show_ratings_left_by_user tinyint(1) DEFAULT 0, tolerance TINYINT UNSIGNED NOT NULL DEFAULT 0, + rubrics_view TINYINT UNSIGNED NOT NULL DEFAULT 1, + rubrics_in_between_columns TINYINT UNSIGNED NOT NULL DEFAULT 0, + rubrics_require_ratings TINYINT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (uid), UNIQUE KEY content_id (content_id) ); @@ -32,6 +35,7 @@ peerreview_uid bigint, session_id bigint, session_name varchar(250), + emails_sent TINYINT UNSIGNED NOT NULL DEFAULT 0, primary key (uid), UNIQUE KEY session_id (session_id), CONSTRAINT FK_NEW_1661738138_24AA78C530E79035 FOREIGN KEY (peerreview_uid) Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20220920.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20230303.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20230306.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20230412.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20230507.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20230507_updateTo47.sql =================================================================== diff -u --- lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20230507_updateTo47.sql (revision 0) +++ lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20230507_updateTo47.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,18 @@ +SET FOREIGN_KEY_CHECKS = 0; + +-- This patch contains files from patch20230303.sql to patch20230507.sql +-- It should upgrade this tool to version 4.7 + +-- LDEV-5369 Add alternative rubrics learner view +ALTER TABLE tl_laprev11_peerreview ADD COLUMN rubrics_view TINYINT UNSIGNED NOT NULL DEFAULT 1; + +-- LDEV-5370 Add half point rubrics columns +ALTER TABLE tl_laprev11_peerreview ADD COLUMN rubrics_in_between_columns TINYINT UNSIGNED NOT NULL DEFAULT 0; + +-- LDEV-5370 Add "students must rate all peers in rubrics" option +ALTER TABLE tl_laprev11_peerreview ADD COLUMN rubrics_require_ratings TINYINT UNSIGNED NOT NULL DEFAULT 0; + +-- LDEV-5394 Mark which group has been sent out emails to +ALTER TABLE tl_laprev11_session ADD COLUMN emails_sent TINYINT UNSIGNED NOT NULL DEFAULT 0; + +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20230508.sql =================================================================== diff -u --- lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20230508.sql (revision 0) +++ lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20230508.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230508' WHERE tool_signature='laprev11'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_sbmt/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_sbmt/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_sbmt/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,7 +2,7 @@ min.server.version.number=4.6 signature=lasbmt11 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=sbmt Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='lasbmt11'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_scratchie/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_scratchie/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_scratchie/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,9 +2,9 @@ min.server.version.number=4.6 signature=lascrt11 -tool.version=20220101 +tool.version=20230411 tool.hide=false tool.short.name=scratchie # SCSS Directories - override value in common.properties -scss.css.dir=${basedir}/web/includes/css +scss.css.dir=${basedir}/web/includes/css \ No newline at end of file Index: lams_tool_scratchie/db/sql/create_lams_tool_scratchie.sql =================================================================== diff -u -r812d599154aefa64ac8c3db4cdecdc1b679706af -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_scratchie/db/sql/create_lams_tool_scratchie.sql (.../create_lams_tool_scratchie.sql) (revision 812d599154aefa64ac8c3db4cdecdc1b679706af) +++ lams_tool_scratchie/db/sql/create_lams_tool_scratchie.sql (.../create_lams_tool_scratchie.sql) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -69,6 +69,7 @@ relative_time_limit smallint unsigned NOT NULL DEFAULT '0', absolute_time_limit datetime DEFAULT NULL, double_click tinyint DEFAULT '0', + require_all_answers TINYINT DEFAULT '1', shuffle_items tinyint(1) DEFAULT '0', confidence_levels_activity_uiid int DEFAULT NULL, confidence_levels_anonymous tinyint DEFAULT '0', @@ -101,7 +102,7 @@ session_id bigint DEFAULT NULL, session_name varchar(250) DEFAULT NULL, group_leader_uid bigint DEFAULT NULL, - mark int DEFAULT '0', + mark FLOAT DEFAULT '0', scratching_finished tinyint(1) DEFAULT '0', time_limit_launched_date datetime DEFAULT NULL, time_limit_adjustment smallint DEFAULT NULL, Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20220920.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20230220.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20230410.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20230410_updateTo47.sql =================================================================== diff -u --- lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20230410_updateTo47.sql (revision 0) +++ lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20230410_updateTo47.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,12 @@ +SET FOREIGN_KEY_CHECKS = 0; + +-- This patch contains files patch202230220.sql to patch20240410.sql +-- It should upgrade this tool to version 4.7 + +-- LDEV-5361 Add option to prevent learners from advancing if they have not found all answers +ALTER TABLE tl_lascrt11_scratchie ADD COLUMN require_all_answers TINYINT DEFAULT '1' AFTER double_click; + +-- LDEV-5385 Allow real numbers for marks +ALTER TABLE tl_lascrt11_session MODIFY COLUMN mark FLOAT DEFAULT '0'; + +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20230411.sql =================================================================== diff -u --- lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20230411.sql (revision 0) +++ lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20230411.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230411' WHERE tool_signature='lascrt11'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_scribe/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_scribe/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_scribe/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,6 +2,6 @@ min.server.version.number=4.6 signature=lascrb11 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=scribe \ No newline at end of file Index: lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='lascrb11'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_spreadsheet/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_spreadsheet/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_spreadsheet/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,6 +2,6 @@ min.server.version.number=4.6 signature=lasprd10 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=spreadsheet \ No newline at end of file Index: lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='lasprd10'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_survey/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_survey/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_survey/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,6 +2,6 @@ min.server.version.number=4.6 signature=lasurv11 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=survey \ No newline at end of file Index: lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='lasurv11'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_task/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_task/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_task/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,9 +2,9 @@ min.server.version.number=4.6 signature=latask10 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=taskList # SCSS Directories - override value in common.properties -scss.css.dir=${basedir}/web/includes/css +scss.css.dir=${basedir}/web/includes/css \ No newline at end of file Index: lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='latask10'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_vote/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_vote/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_vote/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,6 +2,6 @@ min.server.version.number=4.6 signature=lavote11 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=vote \ No newline at end of file Index: lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='lavote11'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_whiteboard/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_whiteboard/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_whiteboard/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,6 +2,6 @@ min.server.version.number=4.6 signature=lawhiteboard11 -tool.version=20220101 +tool.version=20230325 tool.hide=false -tool.short.name=whiteboard +tool.short.name=whiteboard \ No newline at end of file Index: lams_tool_whiteboard/db/sql/create_lams_tool_whiteboard.sql =================================================================== diff -u -r812d599154aefa64ac8c3db4cdecdc1b679706af -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_whiteboard/db/sql/create_lams_tool_whiteboard.sql (.../create_lams_tool_whiteboard.sql) (revision 812d599154aefa64ac8c3db4cdecdc1b679706af) +++ lams_tool_whiteboard/db/sql/create_lams_tool_whiteboard.sql (.../create_lams_tool_whiteboard.sql) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -16,6 +16,7 @@ use_select_leader_tool_ouput tinyint, reflect_instructions MEDIUMTEXT, reflect_on_activity smallint, + submission_deadline DATETIME, relative_time_limit smallint unsigned NOT NULL DEFAULT '0', absolute_time_limit datetime DEFAULT NULL, gallery_walk_enabled TINYINT NOT NULL DEFAULT 0, Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_whiteboard/src/java/org/lamsfoundation/lams/tool/whiteboard/dbupdates/patch20220920.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 10db06081c24c1566659b76698016e844de327a5 refers to a dead (removed) revision in file `lams_tool_whiteboard/src/java/org/lamsfoundation/lams/tool/whiteboard/dbupdates/patch20221116.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: lams_tool_whiteboard/src/java/org/lamsfoundation/lams/tool/whiteboard/dbupdates/patch20221116_updateTo47.sql =================================================================== diff -u --- lams_tool_whiteboard/src/java/org/lamsfoundation/lams/tool/whiteboard/dbupdates/patch20221116_updateTo47.sql (revision 0) +++ lams_tool_whiteboard/src/java/org/lamsfoundation/lams/tool/whiteboard/dbupdates/patch20221116_updateTo47.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,9 @@ +SET FOREIGN_KEY_CHECKS = 0; + +-- This patch contains file patch20221116.sql +-- It should upgrade this tool to version 4.7 + +-- LDEV-5331 Add submission deadline +ALTER TABLE tl_lawhiteboard11_whiteboard ADD COLUMN submission_deadline DATETIME AFTER reflect_on_activity; + +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_whiteboard/src/java/org/lamsfoundation/lams/tool/whiteboard/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_whiteboard/src/java/org/lamsfoundation/lams/tool/whiteboard/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_whiteboard/src/java/org/lamsfoundation/lams/tool/whiteboard/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='lawhiteboard11'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_wiki/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_wiki/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_wiki/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,6 +2,6 @@ min.server.version.number=4.6 signature=lawiki10 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=wiki \ No newline at end of file Index: lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='lawiki10'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file Index: lams_tool_zoom/build.properties =================================================================== diff -u -ra8ce480542041cbca7a1ebc53fd8448352d4b225 -r10db06081c24c1566659b76698016e844de327a5 --- lams_tool_zoom/build.properties (.../build.properties) (revision a8ce480542041cbca7a1ebc53fd8448352d4b225) +++ lams_tool_zoom/build.properties (.../build.properties) (revision 10db06081c24c1566659b76698016e844de327a5) @@ -2,6 +2,6 @@ min.server.version.number=4.6 signature=lazoom10 -tool.version=20220101 +tool.version=20230325 tool.hide=false tool.short.name=zoom \ No newline at end of file Index: lams_tool_zoom/src/java/org/lamsfoundation/lams/tool/zoom/dbupdates/patch20230325.sql =================================================================== diff -u --- lams_tool_zoom/src/java/org/lamsfoundation/lams/tool/zoom/dbupdates/patch20230325.sql (revision 0) +++ lams_tool_zoom/src/java/org/lamsfoundation/lams/tool/zoom/dbupdates/patch20230325.sql (revision 10db06081c24c1566659b76698016e844de327a5) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +-- Put all sql statements below here + +-- LDEV-5433 Update tools version for LAMS 4.7 release +UPDATE lams_tool SET tool_version='20230325' WHERE tool_signature='lazoom10'; +-- Put all sql statements above here + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file