| Summary: | Drop unique constraint deleteditemsstocknumberidx for deleteditems | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Marcel de Rooy <m.de.rooy> |
| Component: | Database | Assignee: | Marcel de Rooy <m.de.rooy> |
| Status: | CLOSED FIXED | QA Contact: | Testopia <testopia> |
| Severity: | minor | ||
| Priority: | P5 - low | CC: | kyle, victor |
| Version: | Main | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23330 | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Crowdfunding goal: | 0 |
| Patch complexity: | Trivial patch | Documentation contact: | |
| Documentation submission: | Text to go in the release notes: | ||
| Version(s) released in: |
22.05.00,21.11.05
|
Circulation function: | |
| Bug Depends on: | |||
| Bug Blocks: | 30486 | ||
| Attachments: |
Bug 30481: Drop unique constraint deleteditemsstocknumberidx
Bug 30481: Drop unique constraint deleteditemsstocknumberidx Bug 30481: Drop unique constraint deleteditemsstocknumberidx |
||
|
Description
Marcel de Rooy
2022-04-07 09:23:45 UTC
Not sure if deleteditems.enumchron is correct too for older production dbs. It's a rather old issue, actually this is a duplicate to bug 23330 that has some of the history. Closed not too long ago (by me), but I'd actually be quite happy to have this fixed. Created attachment 133075 [details] [review] 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> Trivial: Self SO Created attachment 133135 [details] [review] 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> Created attachment 133136 [details] [review] 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> Looks good :) Pushed to master for 22.05, thanks to everybody involved [U+1F984] Pushed to 21.11.x for 21.11.05 |