LP1849212: (follow-up) Don't use group ids in upgrade scripts
authorJason Boyer <JBoyer@equinoxinitiative.org>
Tue, 29 Sep 2020 14:32:48 +0000 (10:32 -0400)
committerKyle Huckins <khuckins@catalyte.io>
Thu, 21 Jan 2021 20:38:35 +0000 (20:38 +0000)
commit0aef2fa8281a7ca1437cb3e577f7cf0334b34896
tree415932329910069effb32353714a6a56825ab91c
parent7a86ae17e433b80f63e9ad23f12a193e88e8fc19
LP1849212: (follow-up) Don't use group ids in upgrade scripts

Previously if there was not a permission group with an id of 9
this upgrade script would fail. Changing the consatruction to
match the seed data allows the insert to benignly do nothing if
the group is missing. Also, the permission is made grantable.

Signed-off-by: Jason Boyer <JBoyer@equinoxinitiative.org>
Open-ILS/src/sql/Pg/upgrade/1232.schema.course-materials-module.sql
Open-ILS/src/sql/Pg/version-upgrade/3.5.1-3.6-beta1-upgrade-db.sql