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>
Tue, 6 Jun 2023 18:40:10 +0000 (15:40 -0300)
commit19143be87338ed6a8a3436065b2245102ecf5b6c
treeda402f4d109914c5112a0027217ef42361cb2d0a
parent73384f636d0985110081b879da5dfe14365ca83e
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