]> git.koha-community.org Git - koha.git/commit
Bug 21983: DB update
authorTomas Cohen Arazi <tomascohen@theke.io>
Mon, 5 Jun 2023 16:50:00 +0000 (13:50 -0300)
committerMatt Blenkinsop <matt.blenkinsop@ptfs-europe.com>
Mon, 12 Jun 2023 11:03:49 +0000 (12:03 +0100)
commitb60671cff3664d59fabdf0799f1c4a19077bab83
treecbc19701b3c20d7750e4ad2ca02bac927e374307
parentaf1c78ab51986f8604c2efce5a82dbc2577b0010
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>
(cherry picked from commit f1346c20257038e523be0405e9d84fe762d502db)
installer/data/mysql/atomicupdate/bug_21983_ill_fk.pl [new file with mode: 0755]
installer/data/mysql/db_revs/221105004.pl
installer/data/mysql/kohastructure.sql