projects / koha.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: ec3c7a8) | patch
Bug 30060: (follow-up) Remove duplicate prior to adding key
authorMartin Renvoize <martin.renvoize@ptfs-europe.com>
Tue, 15 Feb 2022 12:17:44 +0000 (12:17 +0000)
committerFridolin Somers <fridolin.somers@biblibre.com>
Fri, 25 Feb 2022 00:35:36 +0000 (14:35 -1000)
commit64e679b012bfdd86a3ea879737209a0a581593ec
treee0e3db6869b48a8ef429a295bf759775cb93443etree | snapshot
parentec3c7a85c978a31a4404dfd9fad487bc74a4434ccommit | diff
Bug 30060: (follow-up) Remove duplicate prior to adding key

I had issues with this update as somehow my user_permissions table
contained duplicate rows which throws an error when adding the new
primary key.

This follow-up patch adds SQL to remove any duplicate rows prior to
adding the new primary key.

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
installer/data/mysql/atomicupdate/update_user_permissions_table.pl diff | blob | history
Main Koha release repository