Bug 21983: DB update
authorTomas Cohen Arazi <tomascohen@theke.io>
Mon, 5 Jun 2023 16:50:00 +0000 (13:50 -0300)
committerTomas Cohen Arazi <tomascohen@theke.io>
Fri, 9 Jun 2023 15:04:48 +0000 (12:04 -0300)
commitf1346c20257038e523be0405e9d84fe762d502db
treeaf7b887b55d1faa899ed41f6c195dcb162b31cff
parenta7b7f316ba285d92f1d3218655e892e2fb634469
Bug 21983: DB update

This patch:
- Adds a illrequests.deleted_biblio_id column
- Adjusts existing db_rev so people upgrading have the biblio_id value
  moved to the also created column, before attempting to add the FK
  constraint on the biblios table.
- Adds a new db_rev for those who unfortunately already updated, it
  should be idempotent.

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
installer/data/mysql/atomicupdate/bug_21983_ill_fk.pl [new file with mode: 0755]
installer/data/mysql/db_revs/221200026.pl
installer/data/mysql/kohastructure.sql