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)
committerKyle Hall <kyle@bywatersolutions.com>
Fri, 15 Apr 2022 12:07:06 +0000 (08:07 -0400)
commit88977b09573aed44d896cab2178266b98120cc55
treeea196df5e0e0f73c79132217fa6d6973bc74b738
parent0dbb236d891b69f09ab06a62e2679755ea36621c
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>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
installer/data/mysql/atomicupdate/bug_30481.pl [new file with mode: 0755]