projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: a43bbb7) | 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)
committerGalen Charlton <gmc@equinoxinitiative.org>
Thu, 22 Feb 2018 22:02:11 +0000 (17:02 -0500)
commit4217ee5b4502b68c238124779213f97bcafa6df6
treec6f0d10bf18a0923924ed727fd9b68499d278d44tree
parenta43bbb7c7e30a42b43347cb14a8aceba69e3eff9commit | 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>
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 ILS