Bug 30481: Drop unique constraint deleteditemsstocknumberidx
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Thu, 7 Apr 2022 11:59:53 +0000 (11:59 +0000)
committerFridolin Somers <fridolin.somers@biblibre.com>
Wed, 13 Apr 2022 13:55:39 +0000 (15:55 +0200)
commit0b647518de03239c6cbe65c42133be467e1efda8
tree3296aa9ba44270f57e6b2175441d2ef41b00dd83
parent35595922dd5280d4860a3cb3ee08a9f37d1df703
Bug 30481: Drop unique constraint deleteditemsstocknumberidx

Resolves a sync issue between database and schema caused by
differences between structure and upgrades. Note: newer
databases do not contain this index any longer.

Test plan:
Run dbrev.
Check SHOW CREATE TABLE deleteditems.
Verify that unique index has been dropped, regular index added.

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Victor Grousset/tuxayo <victor@tuxayo.net>
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
installer/data/mysql/atomicupdate/bug_30481.pl [new file with mode: 0755]