Index: unix_installer/installer-package/sql-scripts/removeConfigs.sql =================================================================== diff -u -rcedf53563cb1cbae9d8c7ca8ed58a77a37d66bb0 -r5758bb0413c6074c8630e31e7555b1417c0914b6 --- unix_installer/installer-package/sql-scripts/removeConfigs.sql (.../removeConfigs.sql) (revision cedf53563cb1cbae9d8c7ca8ed58a77a37d66bb0) +++ unix_installer/installer-package/sql-scripts/removeConfigs.sql (.../removeConfigs.sql) (revision 5758bb0413c6074c8630e31e7555b1417c0914b6) @@ -16,6 +16,3 @@ delete from lams_qtz_SIMPLE_TRIGGERS; delete from lams_qtz_TRIGGERS; delete from lams_qtz_JOB_DETAILS; - - - Index: win_installer/build.xml =================================================================== diff -u -r319146ead6b24a283bbbc6ebcd34e48c6ee47df8 -r5758bb0413c6074c8630e31e7555b1417c0914b6 --- win_installer/build.xml (.../build.xml) (revision 319146ead6b24a283bbbc6ebcd34e48c6ee47df8) +++ win_installer/build.xml (.../build.xml) (revision 5758bb0413c6074c8630e31e7555b1417c0914b6) @@ -16,6 +16,7 @@ output="${database}/dump.sql"> + Index: win_installer/updater/src/sql/removeConfigs.sql =================================================================== diff -u -r4da5c6b27490d8e693ef427a93e15a61998f1dd4 -r5758bb0413c6074c8630e31e7555b1417c0914b6 --- win_installer/updater/src/sql/removeConfigs.sql (.../removeConfigs.sql) (revision 4da5c6b27490d8e693ef427a93e15a61998f1dd4) +++ win_installer/updater/src/sql/removeConfigs.sql (.../removeConfigs.sql) (revision 5758bb0413c6074c8630e31e7555b1417c0914b6) @@ -12,3 +12,7 @@ -- From 2.2 onwards. Ensure spreadsheet is set to disabled update lams_learning_library set valid_flag=0 where title="SpreadSheet"; +-- From 2.2 onwards. Remove lams_qtz event entires +delete from lams_qtz_SIMPLE_TRIGGERS; +delete from lams_qtz_TRIGGERS; +delete from lams_qtz_JOB_DETAILS;