git.evergreen-ils.org Git - Evergreen.git/commit

]> git.evergreen-ils.org Git - Evergreen.git/commit

author	Galen Charlton <gmc@equinoxinitiative.org>
	Thu, 22 Feb 2018 22:02:11 +0000 (17:02 -0500)
committer	Mike Rylander <mrylander@gmail.com>
	Wed, 28 Feb 2018 15:26:44 +0000 (10:26 -0500)
commit	290a336fde9810cfd1be0df364634d629c77dc67
tree	8e53b3cb8c2bfbac20551f9c6976077a866911a3	tree
parent	3724a2cf6b8ba4e6191ed19b48102b22d2766c2a	commit \| 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>

Evergreen ILS

RSS Atom

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