diff options
| author | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2021-06-28 20:56:50 +0200 |
|---|---|---|
| committer | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2021-07-04 18:38:53 +0200 |
| commit | 2f931dece84c0f3f974cbf0d8863046b9268277d (patch) | |
| tree | 3a03d9259a701992c2def8a4dc466de08aa33e5c /src/main/resources/db | |
| parent | a50ac8daab5f90dbf329446cc20c9e9458f24402 (diff) | |
KB66 Add editor role.
Change-Id: Ibcf94b6532ccb1602bf169ffb434b75557767598
Diffstat (limited to 'src/main/resources/db')
| -rw-r--r-- | src/main/resources/db/changeLog-1.8.xml | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/src/main/resources/db/changeLog-1.8.xml b/src/main/resources/db/changeLog-1.8.xml index 2359001..05948b0 100644 --- a/src/main/resources/db/changeLog-1.8.xml +++ b/src/main/resources/db/changeLog-1.8.xml @@ -55,4 +55,11 @@ </createIndex> </changeSet> + <changeSet id="1.8-4" author="mulk"> + <sql> + ALTER TABLE benki.role_tags DROP CONSTRAINT role_tags_tag_check; + ALTER TABLE benki.role_tags ADD CONSTRAINT role_tags_tag_check CHECK (tag = ANY(ARRAY['admin', 'everyone', 'world', 'editor'])); + </sql> + </changeSet> + </databaseChangeLog> |