Remove EDIT_USER_GROUP_MEMBER_ROLE and disable role_index_null_query
(unsupported in Sqlite)
Change-Id: I5dbe5452a1c8c0ed9d96c33e59be6407d8b1e74a
diff --git a/src/main/resources/db/sqlite/V1.13__role_alteration.sql b/src/main/resources/db/sqlite/V1.13__role_alteration.sql
index 6deca6b..8def1df 100644
--- a/src/main/resources/db/sqlite/V1.13__role_alteration.sql
+++ b/src/main/resources/db/sqlite/V1.13__role_alteration.sql
@@ -34,10 +34,12 @@
DROP TABLE privilege;
DROP TABLE query_access;
-CREATE UNIQUE INDEX IF NOT EXISTS role_index_null_query
-ON role (name, privilege, group_id)
-WHERE query_id IS 0;
+--CREATE UNIQUE INDEX IF NOT EXISTS role_index_null_query
+--ON role (name, privilege, group_id)
+--WHERE query_id IS 0;
CREATE UNIQUE INDEX IF NOT EXISTS role_index on role(name,
privilege, group_id, query_id);
+
+DELETE FROM oauth2_access_scope where id="EDIT_USER_GROUP_MEMBER_ROLE";
\ No newline at end of file