Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql (.../patch0013_updateFrom21.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql (.../patch0013_updateFrom21.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- LDEV1893 - Create notifications/events service ------------------------------ CREATE TABLE lams_events ( @@ -117,7 +117,7 @@ insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) values ('LDAPBindUserPassword','', 'config.ldap.bind.user.password', 'config.header.ldap', 'STRING', 0); -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0015_updateFrom22.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0015_updateFrom22.sql (.../patch0015_updateFrom22.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0015_updateFrom22.sql (.../patch0015_updateFrom22.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- LI-192 This script needs to be in updaters - before new tools are deployed --ALTER TABLE lams_tool ADD COLUMN pedagogical_planner_url TEXT; @@ -150,7 +150,7 @@ -- disable videorecorder update lams_learning_library set valid_flag=0 where title="VideoRecorder"; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0017_updateFrom23-231.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0017_updateFrom23-231.sql (.../patch0017_updateFrom23-231.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0017_updateFrom23-231.sql (.../patch0017_updateFrom23-231.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- Adding new column to external organisation table for tool adapters ALTER TABLE lams_ext_server_org_map ADD COLUMN server_url varchar(255) default null; @@ -33,7 +33,7 @@ PRIMARY KEY (user_id,page_str) )ENGINE=InnoDB; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190119.sql =================================================================== diff -u -raec96466d0f510ff3a0acfc5651f485bb1b477d9 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190119.sql (.../patch20190119.sql) (revision aec96466d0f510ff3a0acfc5651f485bb1b477d9) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190119.sql (.../patch20190119.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,15 +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------------------------- +-- Put all sql statements below here -- LDEV-4755 Add configuratio settings for ClamAV antivirus INSERT INTO lams_configuration VALUES ('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); -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190126.sql =================================================================== diff -u -rbd4fa408454e7389b4e60bc68f2488de88eff663 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190126.sql (.../patch20190126.sql) (revision bd4fa408454e7389b4e60bc68f2488de88eff663) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190126.sql (.../patch20190126.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,13 +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------------------------- +-- Put all sql statements below here -- LDEV-4587 Direction (asc/desc) of ordered branching. NULL means it is non-ordered tool-based branching ALTER TABLE lams_learning_activity ADD COLUMN branching_ordered_asc TINYINT(1); -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190201.sql =================================================================== diff -u -r7f420dcfde4984d32bb8acedde964ca613c1cb6c -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190201.sql (.../patch20190201.sql) (revision 7f420dcfde4984d32bb8acedde964ca613c1cb6c) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190201.sql (.../patch20190201.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,15 +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------------------------- +-- Put all sql statements below here -- LDEV-4767 Add new event types for log in and log out INSERT INTO lams_log_event_type VALUES (24, 'TYPE_LOGIN', 'SECURITY'), (25, 'TYPE_LOGOUT', 'SECURITY'); -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190226.sql =================================================================== diff -u -r78b847b4a5962e1c3d0167cfdc0f95137be57e6a -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190226.sql (.../patch20190226.sql) (revision 78b847b4a5962e1c3d0167cfdc0f95137be57e6a) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190226.sql (.../patch20190226.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,14 +1,14 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-4778 Add new event type for sysadmin configuration change INSERT INTO lams_log_event_type VALUES (26, 'TYPE_CONFIG_CHANGE', 'SECURITY'); -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190313.sql =================================================================== diff -u -r7ba17e82a4cd08db748536b39aef80a4f1c03027 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190313.sql (.../patch20190313.sql) (revision 7ba17e82a4cd08db748536b39aef80a4f1c03027) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190313.sql (.../patch20190313.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-4788 Remove reference to organisation in learning outcomes. They are all global now. @@ -15,7 +15,7 @@ DROP COLUMN organisation_id, DROP COLUMN content_folder_id; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190415.sql =================================================================== diff -u -r0c436f5f696e462cb9882e9e0fb1e1e76224044e -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190415.sql (.../patch20190415.sql) (revision 0c436f5f696e462cb9882e9e0fb1e1e76224044e) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190415.sql (.../patch20190415.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,14 +1,14 @@ -- 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------------------------- +-- Put all sql statements below here -- SP-2 Add logout URL to integrated servers ALTER TABLE lams_ext_server_org_map ADD COLUMN logout_url TEXT AFTER lesson_finish_url; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190429.sql =================================================================== diff -u -r3443abdf0cbd3a7e1b5caed8f1eacd987d89b5ac -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190429.sql (.../patch20190429.sql) (revision 3443abdf0cbd3a7e1b5caed8f1eacd987d89b5ac) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190429.sql (.../patch20190429.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,13 +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------------------------- +-- Put all sql statements below here -- LDEV-4813 Add an index to process event log faster ALTER TABLE lams_log_event ADD KEY event_log_date_and_type (occurred_date_time, log_event_type_id); -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190520.sql =================================================================== diff -u -rba2b4e0d8f708d647ab75bf4db71559dfb249e07 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190520.sql (.../patch20190520.sql) (revision ba2b4e0d8f708d647ab75bf4db71559dfb249e07) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190520.sql (.../patch20190520.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,13 +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------------------------- +-- Put all sql statements below here -- LDEV-4819 Add configuration setting for disabling Learning Outcome quick add by authors INSERT INTO lams_configuration VALUES ('LearningOutcomeQuickAddEnable', 'true', 'config.learning.outcome.add.enable', 'config.header.features', 'BOOLEAN', 1); -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190723.sql =================================================================== diff -u -rfadc30445af67b39ce07890493c9cea08c3ea5db -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190723.sql (.../patch20190723.sql) (revision fadc30445af67b39ce07890493c9cea08c3ea5db) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190723.sql (.../patch20190723.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-4827 Add configuration settings for Question Bank INSERT INTO lams_configuration VALUES @@ -12,7 +12,7 @@ ('QbStatsMinParticipants', '2', 'config.qb.stats.min.participants', 'config.header.qb', 'LONG', 1), ('QbStatsGroupSize', '27', 'config.qb.stats.group.size', 'config.header.qb', 'LONG', 1); -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190724.sql =================================================================== diff -u -rfadc30445af67b39ce07890493c9cea08c3ea5db -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190724.sql (.../patch20190724.sql) (revision fadc30445af67b39ce07890493c9cea08c3ea5db) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190724.sql (.../patch20190724.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-4828 Add tables for QB collections CREATE TABLE lams_qb_collection (`uid` BIGINT AUTO_INCREMENT, @@ -38,7 +38,7 @@ INSERT INTO lams_configuration VALUES ('QbCollectionsTransferEnable', 'true', 'config.qb.collections.transfer.enable', 'config.header.qb', 'BOOLEAN', 1); -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190725.sql =================================================================== diff -u -rfadc30445af67b39ce07890493c9cea08c3ea5db -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190725.sql (.../patch20190725.sql) (revision fadc30445af67b39ce07890493c9cea08c3ea5db) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190725.sql (.../patch20190725.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,12 +1,12 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-4834 Add Learning Outcomes to QB questions ALTER TABLE lams_outcome_mapping ADD COLUMN qb_question_id INT; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190806.sql =================================================================== diff -u -r6b58638c62c43fc5b43bc67402d77b347311bc16 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190806.sql (.../patch20190806.sql) (revision 6b58638c62c43fc5b43bc67402d77b347311bc16) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190806.sql (.../patch20190806.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,12 +1,12 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-4589 Add column for LTI Membership service ALTER TABLE lams_ext_server_org_map ADD COLUMN `membership_url` text COLLATE utf8mb4_unicode_ci; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190808.sql =================================================================== diff -u -r0483acb3c9e3b07f42d9511bbfea3708029438e8 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190808.sql (.../patch20190808.sql) (revision 0483acb3c9e3b07f42d9511bbfea3708029438e8) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190808.sql (.../patch20190808.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,12 +1,12 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-4844 Add a Question Bank event for merging questions INSERT INTO lams_log_event_type VALUES (27, 'TYPE_QUESTIONS_MERGED', 'QUESTION_BANK'); -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190816.sql =================================================================== diff -u -re51bab38bdf978a85dccdcd423dccd9001d7b2f0 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190816.sql (.../patch20190816.sql) (revision e51bab38bdf978a85dccdcd423dccd9001d7b2f0) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190816.sql (.../patch20190816.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,13 +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------------------------- +-- Put all sql statements below here -- LDEV-4827 Add configuration settings for Question Bank INSERT INTO lams_configuration VALUES ('QbMergeEnable', 'true', 'config.qb.merge.enable', 'config.header.qb', 'BOOLEAN', 1); -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190913.sql =================================================================== diff -u -re8a7110708b15579af2c6b31ac52a6da427fef6d -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190913.sql (.../patch20190913.sql) (revision e8a7110708b15579af2c6b31ac52a6da427fef6d) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190913.sql (.../patch20190913.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,12 +1,12 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-4875 Add VSA question type to Assessment and Scratchie ALTER TABLE lams_qb_question ADD COLUMN autocomplete_enabled TINYINT(1) DEFAULT 0; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20191009.sql =================================================================== diff -u -r63bee30ea13fab1267c0744f26929af1736a1cf9 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20191009.sql (.../patch20191009.sql) (revision 63bee30ea13fab1267c0744f26929af1736a1cf9) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20191009.sql (.../patch20191009.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,12 +1,12 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-4876 Ability for LTI servers to get userId from another request parameter name ALTER TABLE lams_ext_server_org_map ADD COLUMN `use_alternative_user_id_parameter_name` tinyint(1) DEFAULT '0'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20191023.sql =================================================================== diff -u -r17f106d9b03871e7278c6eb87f793193d8ff0908 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20191023.sql (.../patch20191023.sql) (revision 17f106d9b03871e7278c6eb87f793193d8ff0908) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20191023.sql (.../patch20191023.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-4884 Allow pre-filling QB question UUID, for example when it gets imported DROP TRIGGER IF EXISTS before_insert_qb_question; @@ -11,7 +11,7 @@ FOR EACH ROW SET new.uuid = IF(new.uuid IS NULL, UUID_TO_BIN(UUID()), new.uuid); -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20110413_updateTo236.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20110413_updateTo236.sql (.../patch20110413_updateTo236.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20110413_updateTo236.sql (.../patch20110413_updateTo236.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- LDEV-2657 Date and time restriction ALTER TABLE tl_laasse10_assessment ADD COLUMN submission_deadline DATETIME DEFAULT null; @@ -31,7 +31,7 @@ -- LDEV-2717 Add passing mark feature to assessment tool ALTER TABLE tl_laasse10_assessment ADD COLUMN passing_mark integer DEFAULT 0; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r4ba184e420dd753ae8e2dcc9434581a794fa244d -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 4ba184e420dd753ae8e2dcc9434581a794fa244d) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- patch20130216.sql -- LDEV-2953 Add notebook option after learners finish Assessment @@ -200,7 +200,7 @@ UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='laasse10'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190423.sql =================================================================== diff -u -r2e0feff80999b1c81deb3d2bc462619b1bc64fdc -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190423.sql (.../patch20190423.sql) (revision 2e0feff80999b1c81deb3d2bc462619b1bc64fdc) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190423.sql (.../patch20190423.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-4813 Add a missing foreign key and index to speed up queries -- We need to check if patch20190722.sql from lams_common has not run already @@ -14,7 +14,7 @@ PREPARE stmt FROM @sqlstmt; EXECUTE stmt; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190517.sql =================================================================== diff -u -r887cde82a7847b6294b50d242c448f2a575f9c9e -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190517.sql (.../patch20190517.sql) (revision 887cde82a7847b6294b50d242c448f2a575f9c9e) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190517.sql (.../patch20190517.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,14 +1,14 @@ -- 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------------------------- +-- Put all sql statements below here --LDEV-4821 remove obsolete hash field ALTER TABLE tl_laasse10_assessment_question DROP COLUMN question_hash; UPDATE lams_tool SET tool_version='20190517' WHERE tool_signature='laasse10'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190704.sql =================================================================== diff -u -r8eefd9a2f57ce5b05eb75908e36bb042c5fe7fce -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190704.sql (.../patch20190704.sql) (revision 8eefd9a2f57ce5b05eb75908e36bb042c5fe7fce) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190704.sql (.../patch20190704.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- 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------------------------- +-- Put all sql statements below here --LDEV-4836 remove obsolete columns ALTER TABLE tl_laasse10_question_reference DROP COLUMN title; @@ -16,7 +16,7 @@ UPDATE lams_tool SET tool_version='20190704' WHERE tool_signature='laasse10'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190809.sql =================================================================== diff -u -r846fd5c0307ebedc923d937f6dbe9a614b746e2e -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190809.sql (.../patch20190809.sql) (revision 846fd5c0307ebedc923d937f6dbe9a614b746e2e) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190809.sql (.../patch20190809.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,13 +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------------------------- +-- Put all sql statements below here --LDEV-4845 Bump version so content version filter kicks in UPDATE lams_tool SET tool_version='20190809' WHERE tool_signature='laasse10'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190913.sql =================================================================== diff -u -re8a7110708b15579af2c6b31ac52a6da427fef6d -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190913.sql (.../patch20190913.sql) (revision e8a7110708b15579af2c6b31ac52a6da427fef6d) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190913.sql (.../patch20190913.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,12 +1,12 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-4875 Add VSA question type to Assessment and Scratchie ALTER TABLE tl_lascrt11_scratchie ADD COLUMN activity_uuid_providing_vsa_answers INT(11); -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20191016.sql =================================================================== diff -u -r1577a6a33d31161c0eddd4afe2c37e70ce79d88a -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20191016.sql (.../patch20191016.sql) (revision 1577a6a33d31161c0eddd4afe2c37e70ce79d88a) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20191016.sql (.../patch20191016.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,14 +1,14 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-4813 Add missing indexes to speed up queries ALTER TABLE tl_laasse10_assessment_result ADD INDEX (latest); ALTER TABLE tl_laasse10_option_answer ADD INDEX (answer_boolean); -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20191120.sql =================================================================== diff -u -r6b89d0c84a5695fb1ad02d5525eb240a9f4d3134 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20191120.sql (.../patch20191120.sql) (revision 6b89d0c84a5695fb1ad02d5525eb240a9f4d3134) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20191120.sql (.../patch20191120.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,13 +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------------------------- +-- Put all sql statements below here -- LDEV-4880 Confidence level variations ALTER TABLE tl_laasse10_assessment ADD COLUMN confidence_levels_type TINYINT DEFAULT 1; UPDATE lams_tool SET tool_version='20191120' WHERE tool_signature='laasse10'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20191205.sql =================================================================== diff -u -r670dd8e248dc4705c92031c79d05a99559e35024 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20191205.sql (.../patch20191205.sql) (revision 670dd8e248dc4705c92031c79d05a99559e35024) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20191205.sql (.../patch20191205.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- 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------------------------- +-- Put all sql statements below here --LDEV-4921 Allow question title hiding in learner @@ -15,7 +15,7 @@ UPDATE lams_tool SET admin_url = 'tool/laasse10/admin/start.do' WHERE tool_signature = 'laasse10'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20081027_updateFrom21.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20081027_updateFrom21.sql (.../patch20081027_updateFrom21.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20081027_updateFrom21.sql (.../patch20081027_updateFrom21.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -2,7 +2,7 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- SQL statements to update from LAMS 2.1/2.1.1 CREATE TABLE tl_lachat11_conditions ( @@ -17,7 +17,7 @@ UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='lachat11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20081125_updateFrom22.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20081125_updateFrom22.sql (.../patch20081125_updateFrom22.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20081125_updateFrom22.sql (.../patch20081125_updateFrom22.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,11 +3,11 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here UPDATE lams_tool SET pedagogical_planner_url='tool/lachat11/pedagogicalPlanner.do' WHERE tool_signature='lachat11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20110416_updateFrom235.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20110416_updateFrom235.sql (.../patch20110416_updateFrom235.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20110416_updateFrom235.sql (.../patch20110416_updateFrom235.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,13 +3,13 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here alter table tl_lachat11_chat add column submission_deadline datetime default null; UPDATE lams_tool SET tool_version = "20110416" WHERE tool_signature = "lachat11"; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r4ba184e420dd753ae8e2dcc9434581a794fa244d -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 4ba184e420dd753ae8e2dcc9434581a794fa244d) +++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- 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------------------------- +-- Put all sql statements below here -- patch20121024.sql ALTER TABLE tl_lachat11_user DROP COLUMN jabber_id, @@ -52,7 +52,7 @@ -- LDEV-4180 UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='lachat11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20081114_updateFrom21.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20081114_updateFrom21.sql (.../patch20081114_updateFrom21.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20081114_updateFrom21.sql (.../patch20081114_updateFrom21.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,14 +3,14 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- SQL statements to update from LAMS 2.1/2.1.1 UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='ladaco10'; ----Put all sql statements above here------------------------- +-- Put all sql statements above here------------------------- -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20090326_updateFrom22.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20090326_updateFrom22.sql (.../patch20090326_updateFrom22.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20090326_updateFrom22.sql (.../patch20090326_updateFrom22.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,11 +3,11 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here ALTER TABLE tl_ladaco10_answers ADD COLUMN create_date datetime; ----Put all sql statements above here------------------------- +-- Put all sql statements above here------------------------- -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r4ba184e420dd753ae8e2dcc9434581a794fa244d -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 4ba184e420dd753ae8e2dcc9434581a794fa244d) +++ lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- 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------------------------- +-- Put all sql statements below here -- patch20140102.sql -- LDEV-3147 Simplify tools: get rid of instructions tab, define in monitor and offline activity options @@ -80,7 +80,7 @@ UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='ladaco10'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081022_updateFrom21.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081022_updateFrom21.sql (.../patch20081022_updateFrom21.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081022_updateFrom21.sql (.../patch20081022_updateFrom21.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here CREATE TABLE tl_lafrum11_conditions ( condition_id BIGINT(20) NOT NULL @@ -26,7 +26,7 @@ )ENGINE=InnoDB; ALTER TABLE tl_lafrum11_forum ADD COLUMN mark_release_notify tinyint DEFAULT 0; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081118_updateFrom22.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081118_updateFrom22.sql (.../patch20081118_updateFrom22.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081118_updateFrom22.sql (.../patch20081118_updateFrom22.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here UPDATE lams_tool SET pedagogical_planner_url='tool/lafrum11/authoring/initPedagogicalPlannerForm.do' WHERE tool_signature='lafrum11'; @@ -22,7 +22,7 @@ alter table tl_lafrum11_timestamp add index ForumUserFK (forum_user_uid), add constraint ForumUserFK foreign key (forum_user_uid) references tl_lafrum11_forum_user (uid); alter table tl_lafrum11_timestamp add index MessageFK (message_uid), add constraint MessageFK foreign key (message_uid) references tl_lafrum11_message (uid); -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20101025_updateTo24.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20101025_updateTo24.sql (.../patch20101025_updateTo24.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20101025_updateTo24.sql (.../patch20101025_updateTo24.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,13 +1,13 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- LDEV-2545 Deliver email messages to students/teachers on forum postings alter table tl_lafrum11_forum add column notify_learners_on_forum_posting tinyint DEFAULT 0; alter table tl_lafrum11_forum add column notify_teachers_on_forum_posting tinyint DEFAULT 0; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql (.../patch20110228_updateTo236.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql (.../patch20110228_updateTo236.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- 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------------------------- +-- Put all sql statements below here ALTER TABLE tl_lafrum11_forum ADD COLUMN allow_rate_messages smallint not null default 0; @@ -25,7 +25,7 @@ UPDATE lams_tool SET tool_version = "20110228" WHERE tool_signature = "lafrum11"; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110408_updateTo236.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110408_updateTo236.sql (.../patch20110408_updateTo236.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110408_updateTo236.sql (.../patch20110408_updateTo236.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -4,14 +4,14 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-2657 alter table tl_lafrum11_forum add column submission_deadline datetime default null; UPDATE lams_tool SET tool_version = "20110408" WHERE tool_signature = "lafrum11"; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20121109_updateTo241.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20121109_updateTo241.sql (.../patch20121109_updateTo241.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20121109_updateTo241.sql (.../patch20121109_updateTo241.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -4,15 +4,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------------------------- +-- Put all sql statements below here -- LDEV-2921 Set max and min rate per thread ALTER TABLE tl_lafrum11_forum ADD COLUMN minimum_rate integer DEFAULT 0; ALTER TABLE tl_lafrum11_forum ADD COLUMN maximum_rate integer DEFAULT 0; UPDATE lams_tool SET tool_version = "20121109" WHERE tool_signature = "lafrum11"; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; SET AUTOCOMMIT = 1; Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r4ba184e420dd753ae8e2dcc9434581a794fa244d -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 4ba184e420dd753ae8e2dcc9434581a794fa244d) +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -18,7 +18,7 @@ -- 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------------------------- +-- Put all sql statements below here -- patch20140102.sql -- LDEV-3147 Simplify tools: get rid of instructions tab, define in monitor and offline activity options @@ -39,7 +39,7 @@ -- LDEV-3432 Do not limit reflect instructions length ALTER TABLE tl_lafrum11_forum MODIFY COLUMN reflect_instructions text; --- --------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; SET AUTOCOMMIT = 1; @@ -56,7 +56,7 @@ SET AUTOCOMMIT = 0; SET FOREIGN_KEY_CHECKS = 0; --- --------------------Put all sql statements below here------------------------- +-- Put all sql statements below here ALTER TABLE `tl_lafrum11_message_seq` ADD COLUMN `thread_message_uid` BIGINT(20) DEFAULT NULL, @@ -68,7 +68,7 @@ ON DELETE RESTRICT ON UPDATE RESTRICT; --- --------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; SET AUTOCOMMIT = 1; @@ -257,7 +257,7 @@ SET AUTOCOMMIT = 0; SET FOREIGN_KEY_CHECKS = 0; --- --------------------Put all sql statements below here------------------------- +-- Put all sql statements below here call tl_lafrum11_get_all_thread_message_uids_tmp(); call tl_lafrum11_set_all_thread_message_uids_tmp(); @@ -270,7 +270,7 @@ drop temporary table if exists tl_lafrum11_recursive_tmp; --- --------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; SET AUTOCOMMIT = 1; @@ -284,7 +284,7 @@ -- 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------------------------- +-- Put all sql statements below here -- patch20150930.sql -- LDEV-3564 tool session id must be unique in tool's session table @@ -401,7 +401,7 @@ UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='lafrum11'; --- --------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20190121.sql =================================================================== diff -u -r756341d57daae979f43d1203609ab5d1bacd27ea -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20190121.sql (.../patch20190121.sql) (revision 756341d57daae979f43d1203609ab5d1bacd27ea) +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20190121.sql (.../patch20190121.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,12 +1,12 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-4756 Unable to add attachments in Forum UPDATE lams_cr_credential set name = "forum" where name = "forumw"; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20090819_updateFrom23.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20090819_updateFrom23.sql (.../patch20090819_updateFrom23.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20090819_updateFrom23.sql (.../patch20090819_updateFrom23.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,12 +3,12 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here ALTER TABLE tl_laimag10_imagegallery_item DROP FOREIGN KEY FK_NEW_1821149711_F52D1F93EC0D3147, DROP COLUMN session_uid; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r4ba184e420dd753ae8e2dcc9434581a794fa244d -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 4ba184e420dd753ae8e2dcc9434581a794fa244d) +++ lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- 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------------------------- +-- Put all sql statements below here -- patch20140102.sql -- LDEV-3123 Make all DB tables names to be lowercase @@ -158,7 +158,7 @@ UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='laimag10'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r4ba184e420dd753ae8e2dcc9434581a794fa244d -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 4ba184e420dd753ae8e2dcc9434581a794fa244d) +++ lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- 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------------------------- +-- Put all sql statements below here -- patch20140102.sql -- LDEV-3123 Make all DB tables names to be lowercase @@ -126,7 +126,7 @@ UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='laimsc11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20081127_updateFrom22.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20081127_updateFrom22.sql (.../patch20081127_updateFrom22.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20081127_updateFrom22.sql (.../patch20081127_updateFrom22.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,11 +3,11 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here UPDATE lams_tool SET pedagogical_planner_url='tool/lamc11/pedagogicalPlanner.do' WHERE tool_signature='lamc11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20110416_updateFrom235.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20110416_updateFrom235.sql (.../patch20110416_updateFrom235.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20110416_updateFrom235.sql (.../patch20110416_updateFrom235.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,12 +3,12 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here alter table tl_lamc11_content add column submission_deadline datetime default null; UPDATE lams_tool SET tool_version = "20110416" WHERE tool_signature = "lamc11"; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r4ba184e420dd753ae8e2dcc9434581a794fa244d -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 4ba184e420dd753ae8e2dcc9434581a794fa244d) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- patch20130325.sql ALTER TABLE tl_lamc11_que_usr DROP COLUMN viewSummaryRequested ; @@ -123,7 +123,7 @@ -- LDEV-4180 UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='lamc11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20190517.sql =================================================================== diff -u -r887cde82a7847b6294b50d242c448f2a575f9c9e -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20190517.sql (.../patch20190517.sql) (revision 887cde82a7847b6294b50d242c448f2a575f9c9e) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20190517.sql (.../patch20190517.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,14 +1,14 @@ -- 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------------------------- +-- Put all sql statements below here --LDEV-4821 remove obsolete hash field ALTER TABLE tl_lamc11_que_content DROP COLUMN question_hash; UPDATE lams_tool SET tool_version='20190517' WHERE tool_signature='lamc11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20190809.sql =================================================================== diff -u -r45f55e8dd35ae8841dbc8db3f38a41d9d52fd2ca -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20190809.sql (.../patch20190809.sql) (revision 45f55e8dd35ae8841dbc8db3f38a41d9d52fd2ca) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20190809.sql (.../patch20190809.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,13 +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------------------------- +-- Put all sql statements below here --LDEV-4845 Bump version so content version filter kicks in UPDATE lams_tool SET tool_version='20190809' WHERE tool_signature='lamc11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20191205.sql =================================================================== diff -u -r5ebec80ccc488d5c09da8e9f648b718b02d0dee2 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20191205.sql (.../patch20191205.sql) (revision 5ebec80ccc488d5c09da8e9f648b718b02d0dee2) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20191205.sql (.../patch20191205.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- 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------------------------- +-- Put all sql statements below here --LDEV-4921 Allow question title hiding in learner @@ -15,7 +15,7 @@ UPDATE lams_tool SET admin_url = 'tool/lamc11/admin/start.do' WHERE tool_signature = 'lamc11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20080926_updateFrom21.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20080926_updateFrom21.sql (.../patch20080926_updateFrom21.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20080926_updateFrom21.sql (.../patch20080926_updateFrom21.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- SQL statements to update from LAMS 2.1/2.1.1 @@ -68,7 +68,7 @@ -- Wizard questions INSERT INTO tl_laqa11_wizard_question VALUES (1,1,'Please%20identify%u2026'),(2,2,'What%20do%20you%20observe%20...'),(3,2,'What%20do%20you%20see%u2026%3F'),(4,3,'Give%20the%20definition%20of%u2026'),(5,3,'What%20is%20the%20meaning%20of%u2026%3F'),(6,3,'What%20has%20been%20said%20by%u2026%20about%u2026%3F'),(7,4,'Find%20a%20criterion%20to%20order%20these%u2026'),(8,4,'Order%20these%u2026'),(9,4,'Find%20the%205%20biggest/smallest%20%u2026'),(10,5,'Compare%20these%u2026%20using%20the%20following%20criteria%u2026'),(11,5,'Find%20the%20pros%20and%20cons%20of%u2026'),(12,5,'Find%20both%20the%20similarities%20and%20the%20differences%20between..%20and%u2026'),(13,6,'Arrange%20these%u2026by%20the%20following%20criterion%u2026'),(14,6,'Sort%20these%u2026%20by%20the%20following%20criterion%u2026'),(15,6,'Put%20these%u2026in%20an%20ascending/descending%20sequence%u2026'),(16,7,'Group%20these%20elements%20using%20the%20following%20criteria%u2026'),(17,7,'Find%20the%20pros%20and%20cons%20of%20these%u2026solutions'),(18,7,'Find%205%20%20advantages%20and%203%20disadvantages%20%20of%20%u2026'),(19,8,'Clarify%20whether%20this%20%u2026describes%20a%20fact%20or%20if%20it%20is%20a%20personal%20opinion'),(20,8,'Provide%20more%20than%20one%20view%20about%20the%20following%u2026'),(21,8,'Provide%20logical%20arguments%20to%20support%20the%20following%20statement'),(22,9,'Identify%20the%20parts/units/characteristics%20of%u2026'),(23,9,'Define%20the%20data%20given%20and%20the%20objectives%20of%u2026.'),(24,9,'Refer%20to%20the%20appropriate%20phases%20of%20the%20solution%20plan%20for%u2026'),(25,10,'What%20do%20we%20mean%20by%u2026%3F'),(26,10,'Provide%20an%20example%20to%20clarify%u2026'),(27,10,'When%20does%20this%u2026have%20a%20meaning%u2026%3F'),(28,11,'Distinguish%20possible%20relationships%20among%20the%20data%u2026'),(29,11,'Is%20there%20any%20reason%20that%20affects%20this%20phenomenon%u2026%3F'),(30,11,'Is%20there%20any%20structure%20within%u2026%3F'),(31,12,'Is%20there%20any%20pattern%20that%20is%20repeated%20in%u2026%3F'),(32,12,'Find%20out%20what%20is%20common%20in%u2026'),(33,12,'Find%20out%20what%20is%20similar%20in%u2026'),(34,13,'Point%20out%20the%20mistakes%20of/in%u2026'),(35,13,'Are%20there%20any%20contradictions%20in%u2026%3F'),(36,13,'What%20is%20missing%20in%u2026%3F'),(37,14,'Form%20an%20abstract%20of%20%u2026%28number%29%20words%20to%20describe%u2026'),(38,14,'Which%20are%20the%20main%20points%20of%20%u2026'),(39,14,'Which%20are%20the%20top%205%20essential%20points%20of%20%u2026'),(40,15,'What%20have%20you%20learnt%20about%u2026%3F'),(41,15,'Are%20there%20any%20points%20that%20you%u2026%3F'),(42,16,'If%20%u2026%20then%u2026'),(43,17,'Could%20you%20make%20any%20predictions%20about%u2026%3F'),(44,17,'If%20we%20do%u2026then%20what%20will%20happen%3F'),(45,17,'In%20the%20case%20of%u2026find%20out%u2026'),(46,18,'Please%20explain%20how%20the%20meaning%20of%u2026'),(47,18,'Please%20explain%20why%20the%20meaning%20of/%u2026'),(48,18,'Please%20explain%20what%20the%20meaning%20of%20%u2026'),(49,18,'Please%20explain%20in%20your%20own%20words%u2026'),(50,18,'Please%20explain%20in%20your%20own%20words%u2026'),(51,19,'Could%20you%20accept%20the%20role%20of%u2026%3F'),(52,19,'What%20are%20the%20possible%20arguments%20of%20others%20for%u2026%3F'),(53,19,'What%20would%20be%20your%20answer%20if%20you%20were%20in%20the%20position%20of%u2026%3F'),(54,20,'Make%20a%20hierarchical%20tree%20to%20describe%u2026'),(55,20,'Can%20you%20form%20a%20sequential%20structure%20of%u2026%3F'),(56,20,'Characterize%20it%20according%20to%20the%20following%20criteria%u2026'),(57,21,'How%20can%20you%20improve%20this%u2026in%20order%20to%u2026%3F'),(58,21,'How%20can%20you%20apply%20this%u2026in%20order%20to%u2026%3F'),(59,22,'Assess%20this%u2026'),(60,22,'Evaluate%20the%u2026'),(61,22,'What%20kind%20of%20criteria%20can%20you%20use%20to%20evaluate%20the%u2026%3F'),(62,23,'Please%20verify%20that%u2026'),(63,23,'Please%20confirm%20that%u2026'),(64,24,'Based%20on%20this%u2026what%20do%20you%20conclude%3F'),(65,24,'Based%20on%20these%u2026what%20do%20you%20conclude%3F'),(66,24,'Are%20there%20any%20exceptions%20to%u2026%3F'),(67,24,'Are%20there%20any%20weak%20points%20in%u2026%3F'); -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20081126_updateFrom22.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20081126_updateFrom22.sql (.../patch20081126_updateFrom22.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20081126_updateFrom22.sql (.../patch20081126_updateFrom22.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,13 +3,13 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here UPDATE lams_tool SET pedagogical_planner_url='tool/laqa11/pedagogicalPlanner.do' WHERE tool_signature='laqa11'; alter table tl_laqa11_content add column allow_rich_editor TINYINT(1) NOT NULL DEFAULT 0; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20101022_updateTo235.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20101022_updateTo235.sql (.../patch20101022_updateTo235.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20101022_updateTo235.sql (.../patch20101022_updateTo235.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,13 +3,13 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here ALTER TABLE tl_laqa11_que_content ADD COLUMN answer_required TINYINT(1) NOT NULL DEFAULT 0; UPDATE lams_tool SET tool_version = "20101022" WHERE tool_signature = "laqa11"; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20110217_updateTo236.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20110217_updateTo236.sql (.../patch20110217_updateTo236.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20110217_updateTo236.sql (.../patch20110217_updateTo236.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- 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------------------------- +-- Put all sql statements below here ALTER TABLE tl_laqa11_content ADD COLUMN allow_rate_answers TINYINT(1) NOT NULL DEFAULT 0; @@ -30,7 +30,7 @@ UPDATE lams_tool SET tool_version = "20110217" WHERE tool_signature = "laqa11"; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r8cb3b47e0bc1e7d89582929aa33ee29f0ef37189 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 8cb3b47e0bc1e7d89582929aa33ee29f0ef37189) +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-3155 adding all the leader aware tools (lamc,assessment,qa) to regular LAMS ALTER TABLE tl_laqa11_content ADD COLUMN use_select_leader_tool_ouput TINYINT(1) NOT NULL DEFAULT 0; @@ -104,7 +104,7 @@ -- LDEV-4180 UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='laqa11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20190809.sql =================================================================== diff -u -re784910cb85086f0951f780d5dd64ed7a039ba5a -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20190809.sql (.../patch20190809.sql) (revision e784910cb85086f0951f780d5dd64ed7a039ba5a) +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20190809.sql (.../patch20190809.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,13 +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------------------------- +-- Put all sql statements below here --LDEV-4845 Bump version so content version filter kicks in UPDATE lams_tool SET tool_version='20190809' WHERE tool_signature='laqa11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20081107_updateFrom21.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20081107_updateFrom21.sql (.../patch20081107_updateFrom21.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20081107_updateFrom21.sql (.../patch20081107_updateFrom21.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,11 +3,11 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here ALTER TABLE tl_larsrc11_resource ADD COLUMN assigment_submit_notify tinyint DEFAULT 0; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20090115_updateFrom22.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20090115_updateFrom22.sql (.../patch20090115_updateFrom22.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20090115_updateFrom22.sql (.../patch20090115_updateFrom22.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,11 +3,11 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here UPDATE lams_tool SET pedagogical_planner_url='tool/larsrc11/authoring/initPedagogicalPlannerForm.do' WHERE tool_signature='larsrc11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20090818_updateFrom231.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20090818_updateFrom231.sql (.../patch20090818_updateFrom231.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20090818_updateFrom231.sql (.../patch20090818_updateFrom231.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,12 +3,12 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- LDEV-2421 Adding sorting for resource items ALTER TABLE tl_larsrc11_resource_item ADD COLUMN order_id integer DEFAULT NULL; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20110810_updateFrom235.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20110810_updateFrom235.sql (.../patch20110810_updateFrom235.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20110810_updateFrom235.sql (.../patch20110810_updateFrom235.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,12 +3,12 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- LDEV-2705 Improve reporting for Share Resources ALTER TABLE tl_larsrc11_item_log ADD COLUMN complete_date datetime DEFAULT NULL; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r8cb3b47e0bc1e7d89582929aa33ee29f0ef37189 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 8cb3b47e0bc1e7d89582929aa33ee29f0ef37189) +++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-2941 Enable the option "Open URL in pop-up" for the example URL by default UPDATE tl_larsrc11_resource_item SET open_url_new_window=1 WHERE uid='1'; @@ -90,7 +90,7 @@ UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='larsrc11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r4ba184e420dd753ae8e2dcc9434581a794fa244d -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 4ba184e420dd753ae8e2dcc9434581a794fa244d) +++ lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- 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------------------------- +-- Put all sql statements below here -- patch20140102.sql -- LDEV-3147 Simplify tools: get rid of instructions tab, define in monitor and offline activity options @@ -33,7 +33,7 @@ -- LDEV-4180 UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='lalead11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20110414_updateTo236.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20110414_updateTo236.sql (.../patch20110414_updateTo236.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20110414_updateTo236.sql (.../patch20110414_updateTo236.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,12 +3,12 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- LDEV-2657 Date and time restriction alter table tl_lamind10_mindmap add column submission_deadline datetime default null; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r4ba184e420dd753ae8e2dcc9434581a794fa244d -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 4ba184e420dd753ae8e2dcc9434581a794fa244d) +++ lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- 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------------------------- +-- Put all sql statements below here -- patch20140102.sql @@ -55,7 +55,7 @@ -- LDEV-4180 UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='lamind10'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20081209_updateFrom22.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20081209_updateFrom22.sql (.../patch20081209_updateFrom22.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20081209_updateFrom22.sql (.../patch20081209_updateFrom22.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,11 +3,11 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here UPDATE lams_tool SET pedagogical_planner_url='tool/lanb11/pedagogicalPlanner.do' WHERE tool_signature='lanb11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r4ba184e420dd753ae8e2dcc9434581a794fa244d -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 4ba184e420dd753ae8e2dcc9434581a794fa244d) +++ lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,7 +1,7 @@ -- 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------------------------- +-- Put all sql statements below here -- patch20140102.sql -- LDEV-3147 Simplify tools: get rid of instructions tab, define in monitor and offline activity options @@ -39,7 +39,7 @@ -- LDEV-4180 UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='lanb11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20080929_updateFrom21.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20080929_updateFrom21.sql (.../patch20080929_updateFrom21.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20080929_updateFrom21.sql (.../patch20080929_updateFrom21.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here CREATE TABLE tl_lantbk11_conditions ( condition_id BIGINT(20) NOT NULL @@ -17,7 +17,7 @@ UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='lantbk11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20081118_updateFrom22.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20081118_updateFrom22.sql (.../patch20081118_updateFrom22.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20081118_updateFrom22.sql (.../patch20081118_updateFrom22.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,11 +3,11 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here UPDATE lams_tool SET pedagogical_planner_url='tool/lantbk11/pedagogicalPlanner.do' WHERE tool_signature='lantbk11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20110510_updateTo236.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20110510_updateTo236.sql (.../patch20110510_updateTo236.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20110510_updateTo236.sql (.../patch20110510_updateTo236.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,13 +3,13 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- LDEV-2657 alter table tl_lantbk11_notebook add column submission_deadline datetime default null; UPDATE lams_tool SET tool_version = "20110510" WHERE tool_signature = "lantbk11"; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r4ba184e420dd753ae8e2dcc9434581a794fa244d -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 4ba184e420dd753ae8e2dcc9434581a794fa244d) +++ lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -2,7 +2,7 @@ -- 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------------------------- +-- Put all sql statements below here -- patch20140102.sql -- LDEV-3147 Simplify tools: get rid of instructions tab, define in monitor and offline activity options @@ -41,7 +41,7 @@ -- LDEV-4180 UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='lantbk11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r8cb3b47e0bc1e7d89582929aa33ee29f0ef37189 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 8cb3b47e0bc1e7d89582929aa33ee29f0ef37189) +++ lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-3147 Simplify tools: get rid of instructions tab, define in monitor and offline activity options ALTER TABLE tl_lapixl10_pixlr DROP COLUMN online_instructions; @@ -26,7 +26,7 @@ -- LDEV-4180 UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='lapixl10'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r8cb3b47e0bc1e7d89582929aa33ee29f0ef37189 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 8cb3b47e0bc1e7d89582929aa33ee29f0ef37189) +++ lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- 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------------------------- +-- Put all sql statements below here ALTER TABLE `tl_laprev11_user` ADD UNIQUE INDEX `prev11uniqusersession` (`user_id` ASC, `session_uid` ASC); @@ -51,7 +51,7 @@ UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='laprev11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20081107_updateFrom21.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20081107_updateFrom21.sql (.../patch20081107_updateFrom21.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20081107_updateFrom21.sql (.../patch20081107_updateFrom21.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,12 +3,12 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here ALTER TABLE tl_lasbmt11_content ADD COLUMN mark_release_notify tinyint DEFAULT 0; ALTER TABLE tl_lasbmt11_content ADD COLUMN file_submit_notify tinyint DEFAULT 0; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20090113_updateFrom22.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20090113_updateFrom22.sql (.../patch20090113_updateFrom22.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20090113_updateFrom22.sql (.../patch20090113_updateFrom22.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,11 +3,11 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here UPDATE lams_tool SET pedagogical_planner_url='tool/lasbmt11/pedagogicalPlanner.do' WHERE tool_signature='lasbmt11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20090723_updateFrom231.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20090723_updateFrom231.sql (.../patch20090723_updateFrom231.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20090723_updateFrom231.sql (.../patch20090723_updateFrom231.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,14 +3,14 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- LDEV-2385 alter table tl_lasbmt11_report add column mark_file_uuid bigint default null; alter table tl_lasbmt11_report add column mark_file_version_id bigint default null; alter table tl_lasbmt11_report add column mark_file_name varchar(255) default null; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20091028_updatefrom232.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20091028_updatefrom232.sql (.../patch20091028_updatefrom232.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20091028_updatefrom232.sql (.../patch20091028_updatefrom232.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,11 +3,11 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here alter table tl_lasbmt11_report modify column comments text; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20110325_updateTo236.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20110325_updateTo236.sql (.../patch20110325_updateTo236.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20110325_updateTo236.sql (.../patch20110325_updateTo236.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,12 +3,12 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- LDEV-2657 alter table tl_lasbmt11_content add column submission_deadline datetime default null; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r8cb3b47e0bc1e7d89582929aa33ee29f0ef37189 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 8cb3b47e0bc1e7d89582929aa33ee29f0ef37189) +++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-3147 Simplify tools: get rid of instructions tab, define in monitor and offline activity options ALTER TABLE tl_lasbmt11_content DROP COLUMN online_instruction; @@ -65,7 +65,7 @@ UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='lasbmt11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20191128.sql =================================================================== diff -u -re34c7b767eb34caebbfa0c9bdfb50d771d3b9d95 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20191128.sql (.../patch20191128.sql) (revision e34c7b767eb34caebbfa0c9bdfb50d771d3b9d95) +++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20191128.sql (.../patch20191128.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,12 +1,12 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-4913 Include a minimum number of files to submit ALTER TABLE tl_lasbmt11_content ADD COLUMN min_limit_upload_number bigint; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20121004_wviCustomUpdate.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20121004_wviCustomUpdate.sql (.../patch20121004_wviCustomUpdate.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20121004_wviCustomUpdate.sql (.../patch20121004_wviCustomUpdate.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,12 +1,12 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- LDEV-2657 Date and time restriction ALTER TABLE tl_lascrt11_user ADD COLUMN leader smallint DEFAULT 0; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20130502_wviCustomUpdate.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20130502_wviCustomUpdate.sql (.../patch20130502_wviCustomUpdate.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20130502_wviCustomUpdate.sql (.../patch20130502_wviCustomUpdate.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,14 +1,14 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- LKC-4 Modify Scratchie Tool to use Select Leader Tool Outputs ALTER TABLE tl_lascrt11_session ADD COLUMN group_leader_uid BIGINT; ALTER TABLE tl_lascrt11_session ADD INDEX FK_lalead11_session1 (group_leader_uid), ADD CONSTRAINT FK_lalead11_session1 FOREIGN KEY (group_leader_uid) REFERENCES tl_lascrt11_user (uid); ALTER TABLE tl_lascrt11_user DROP COLUMN leader; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r8cb3b47e0bc1e7d89582929aa33ee29f0ef37189 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 8cb3b47e0bc1e7d89582929aa33ee29f0ef37189) +++ lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- 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------------------------- +-- Put all sql statements below here -- LKC-15 adding a constraint to the scratchie user table so no same user_id and session_id can be repetead ALTER TABLE tl_lascrt11_user ADD UNIQUE INDEX(user_id, session_uid); @@ -181,7 +181,7 @@ UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='lascrt11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20190510.sql =================================================================== diff -u -rc05bc28426be01ab26818fef24699cea98d568c8 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20190510.sql (.../patch20190510.sql) (revision c05bc28426be01ab26818fef24699cea98d568c8) +++ lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20190510.sql (.../patch20190510.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,12 +1,12 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-4817 Delete existing blank burning questions DELETE FROM tl_lascrt11_burning_question WHERE question IS NULL OR TRIM(question) = ''; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20190809.sql =================================================================== diff -u -rb765f567ba3ca9ca048b434d243d94d865ef363c -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20190809.sql (.../patch20190809.sql) (revision b765f567ba3ca9ca048b434d243d94d865ef363c) +++ lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20190809.sql (.../patch20190809.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,13 +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------------------------- +-- Put all sql statements below here --LDEV-4845 Bump version so content version filter kicks in UPDATE lams_tool SET tool_version='20190809' WHERE tool_signature='lascrt11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20191205.sql =================================================================== diff -u -r87ea6a14122fad745d95e49494d801d317fd6d61 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20191205.sql (.../patch20191205.sql) (revision 87ea6a14122fad745d95e49494d801d317fd6d61) +++ lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20191205.sql (.../patch20191205.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -1,13 +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------------------------- +-- Put all sql statements below here --LDEV-4921 Allow question title hiding in learner INSERT INTO `tl_lascrt11_configuration` (`config_key`, `config_value`) VALUES ('hideTitles', 'false'); -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20090226_updateFrom22.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20090226_updateFrom22.sql (.../patch20090226_updateFrom22.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20090226_updateFrom22.sql (.../patch20090226_updateFrom22.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,11 +3,11 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here UPDATE lams_tool SET pedagogical_planner_url='tool/lascrb11/pedagogicalPlanner.do' WHERE tool_signature='lascrb11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r8cb3b47e0bc1e7d89582929aa33ee29f0ef37189 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 8cb3b47e0bc1e7d89582929aa33ee29f0ef37189) +++ lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-3147 Simplify tools: get rid of instructions tab, define in monitor and offline activity options ALTER TABLE tl_lascrb11_scribe DROP COLUMN online_instructions; @@ -42,7 +42,7 @@ -- LDEV-4180 UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='lascrb11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r8cb3b47e0bc1e7d89582929aa33ee29f0ef37189 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 8cb3b47e0bc1e7d89582929aa33ee29f0ef37189) +++ lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-3147 Simplify tools: get rid of instructions tab, define in monitor and offline activity options ALTER TABLE tl_lasprd10_spreadsheet DROP COLUMN online_instructions; @@ -69,7 +69,7 @@ UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='lasprd10'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql (.../patch20081021_updateFrom21.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql (.../patch20081021_updateFrom21.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here CREATE TABLE tl_lasurv11_conditions ( condition_id BIGINT(20) NOT NULL @@ -28,7 +28,7 @@ UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='lasurv11'; ALTER TABLE tl_lasurv11_survey ADD COLUMN answer_submit_notify tinyint DEFAULT 0; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20110406_updateFrom235.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20110406_updateFrom235.sql (.../patch20110406_updateFrom235.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20110406_updateFrom235.sql (.../patch20110406_updateFrom235.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,14 +3,14 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- LDEV-2657 alter table tl_lasurv11_survey add column submission_deadline datetime default null; UPDATE lams_tool SET tool_version = "20110406" WHERE tool_signature = "lasurv11"; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r8cb3b47e0bc1e7d89582929aa33ee29f0ef37189 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 8cb3b47e0bc1e7d89582929aa33ee29f0ef37189) +++ lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-3147 Simplify tools: get rid of instructions tab, define in monitor and offline activity options ALTER TABLE tl_lasurv11_survey DROP COLUMN online_instructions; @@ -74,7 +74,7 @@ UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='lasurv11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20090113_updateFrom22.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20090113_updateFrom22.sql (.../patch20090113_updateFrom22.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20090113_updateFrom22.sql (.../patch20090113_updateFrom22.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,11 +3,11 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here UPDATE lams_tool SET pedagogical_planner_url='tool/latask10/authoring/initPedagogicalPlannerForm.do' WHERE tool_signature='latask10'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20110510_updateTo236.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20110510_updateTo236.sql (.../patch20110510_updateTo236.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20110510_updateTo236.sql (.../patch20110510_updateTo236.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,13 +3,13 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here -- LDEV-2657 alter table tl_latask10_tasklist add column submission_deadline datetime default null; UPDATE lams_tool SET tool_version = "20110510" WHERE tool_signature = "latask10"; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r47b4ad60d91b997793d306845a62f0502acf33d3 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 47b4ad60d91b997793d306845a62f0502acf33d3) +++ lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV-3123 Make all DB tables names to be lowercase SELECT DATABASE() INTO @db_name FROM DUAL; @@ -155,7 +155,7 @@ UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='latask10'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20081203_updateFrom22.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20081203_updateFrom22.sql (.../patch20081203_updateFrom22.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20081203_updateFrom22.sql (.../patch20081203_updateFrom22.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,11 +3,11 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here UPDATE lams_tool SET pedagogical_planner_url='tool/lavote11/pedagogicalPlanner.do' WHERE tool_signature='lavote11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r8cb3b47e0bc1e7d89582929aa33ee29f0ef37189 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 8cb3b47e0bc1e7d89582929aa33ee29f0ef37189) +++ lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV ALTER TABLE tl_lavote11_content ADD COLUMN use_select_leader_tool_ouput TINYINT(1) NOT NULL DEFAULT 0; @@ -70,7 +70,7 @@ UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='lavote11'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20090121_updateFrom22.sql =================================================================== diff -u -r7475d08afc280b5e2e5ddf04e8bf35e3166aaf80 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20090121_updateFrom22.sql (.../patch20090121_updateFrom22.sql) (revision 7475d08afc280b5e2e5ddf04e8bf35e3166aaf80) +++ lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20090121_updateFrom22.sql (.../patch20090121_updateFrom22.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; -----------------------Put all sql statements below here------------------------- +-- Put all sql statements below here UPDATE lams_tool SET pedagogical_planner_url='tool/lawiki10/pedagogicalPlanner.do' WHERE tool_signature='lawiki10'; @@ -32,7 +32,7 @@ SET FOREIGN_KEY_CHECKS=1; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT; Index: lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20170101_updateTo30.sql =================================================================== diff -u -r8cb3b47e0bc1e7d89582929aa33ee29f0ef37189 -r7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91 --- lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 8cb3b47e0bc1e7d89582929aa33ee29f0ef37189) +++ lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20170101_updateTo30.sql (.../patch20170101_updateTo30.sql) (revision 7d3a4b0828b2f3d5ad768e0053cb4014ac9b8a91) @@ -3,7 +3,7 @@ -- 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------------------------- +-- Put all sql statements below here -- LDEV- ALTER TABLE tl_lawiki10_wiki_page ADD COLUMN deleted bit DEFAULT 0 AFTER editable; @@ -67,7 +67,7 @@ -- LDEV-4180 UPDATE lams_tool SET tool_version='20170101' WHERE tool_signature='lawiki10'; -----------------------Put all sql statements above here------------------------- +-- Put all sql statements above here -- If there were no errors, commit and restore autocommit to on COMMIT;