Bug 30060: Add primary key to user_permissions table
authorNick Clemens <nick@bywatersolutions.com>
Mon, 27 Sep 2021 18:34:17 +0000 (18:34 +0000)
committerFridolin Somers <fridolin.somers@biblibre.com>
Fri, 25 Feb 2022 00:35:36 +0000 (14:35 -1000)
commitec3c7a85c978a31a4404dfd9fad487bc74a4434c
tree70d981aed620329a00f9b9f930da39410e1473cb
parentc023f63abcce53d71c9492aea4bc7aa30fdc5d73
Bug 30060: Add primary key to user_permissions table

Without primary key DBIC is failing with something like:

GET /api/v1/suggestions/managers: unhandled exception (DBIx::Class::Exception)<<DBIx::Class::ResultSource::RowParser::_resolve_collapse(): Unable to calculate a definitive collapse co
lumn set for UserPermission (last member of the Borrower -> user_permissions chain): fetch more unique non-nullable columns at /kohadevbox/koha/Koha/Objects.pm line 394>> Koha::REST::Plugin::Exceptions::__ANON__ /
kohadevbox/koha/Koha/REST/Plugin/Exceptions.pm (73)

Test plan:
Execute the atomic update and confirm that the new PK has been added to the user_permissions table.

Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
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 [new file with mode: 0755]
installer/data/mysql/kohastructure.sql