projects / evergreen / pines.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 3724a2c) | patch
LP#1676608: provide DB update script to convert legacy copy alert messages
authorGalen Charlton <gmc@equinoxinitiative.org>
Thu, 22 Feb 2018 22:02:11 +0000 (17:02 -0500)
committerMike Rylander <mrylander@gmail.com>
Wed, 28 Feb 2018 15:26:44 +0000 (10:26 -0500)
commit290a336fde9810cfd1be0df364634d629c77dc67
tree8e53b3cb8c2bfbac20551f9c6976077a866911a3tree
parent3724a2cf6b8ba4e6191ed19b48102b22d2766c2acommit | diff
LP#1676608: provide DB update script to convert legacy copy alert messages

Legacy copy alert messages are moved to new normal checkout and
normal checkin copy alerts. This patch also converts the foreign
key relationship from asset.copy_alert to asset.copy to a "fake"
one using a constraint trigger.

Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/040.schema.asset.sql diff | blob | history
Open-ILS/src/sql/Pg/800.fkeys.sql diff | blob | history
Open-ILS/src/sql/Pg/950.data.seed-values.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.copy_alerts.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/YYYY.data.stock_copy_alert_types.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/ZZZA.data.move_legacy_copy_alerts.sql [new file with mode: 0644] blob
Evergreen working repo (PINES)