From 3aff80fff85d8976c968df0178850b4d24f3eaec Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Tue, 17 Apr 2018 00:17:09 +0000 Subject: [PATCH] Bug 19794: (follow-up) Add atomic update The update will - change the RLIST notice code to SERIAL_ALERT - adapt the description if it has remained unchanged from 'Routing List' to 'New serial issue' - update subscriptions to use the new notice code --- installer/data/mysql/atomicupdate/bug_19794_update_rlist.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_19794_update_rlist.sql diff --git a/installer/data/mysql/atomicupdate/bug_19794_update_rlist.sql b/installer/data/mysql/atomicupdate/bug_19794_update_rlist.sql new file mode 100644 index 0000000..29fc14d --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_19794_update_rlist.sql @@ -0,0 +1,4 @@ +UPDATE letter SET code = "SERIAL_ALERT" WHERE code = "RLIST"; +UPDATE letter SET name = "New serial issue" WHERE name = "Routing List"; +UPDATE letter SET name = "New serial issue" WHERE name = "Routing List"; +-- print Bug 19794: Rename RLIST notice to SERIAL_ALERT -- 2.1.4