Removed created_by, status and status_date from user_group_member table.
Removed GroupMemberStatus (#764)
Change-Id: Ic5ec60cc05d95e6d805aa2abc2ffec1114d702f8
diff --git a/src/main/resources/db/sqlite/V1.13__user_group_alteration.sql b/src/main/resources/db/sqlite/V1.13__role_alteration.sql
similarity index 63%
rename from src/main/resources/db/sqlite/V1.13__user_group_alteration.sql
rename to src/main/resources/db/sqlite/V1.13__role_alteration.sql
index 84daff6..6deca6b 100644
--- a/src/main/resources/db/sqlite/V1.13__user_group_alteration.sql
+++ b/src/main/resources/db/sqlite/V1.13__role_alteration.sql
@@ -1,32 +1,5 @@
---DROP INDEX IF EXISTS group_member_role_index;
---DROP INDEX IF EXISTS user_group_member_index;
---DROP INDEX IF EXISTS user_group_member_status_index;
DROP INDEX IF EXISTS role_index;
--- please commented out the triggers in V1.2__triggers.sql later
---DROP TRIGGER IF EXISTS insert_member_status;
---DROP TRIGGER IF EXISTS update_member_status;
-DROP TRIGGER IF EXISTS delete_member;
-
-ALTER TABLE user_group
-DROP COLUMN deleted_by;
-
-ALTER TABLE user_group
-ADD COLUMN created_date TIMESTAMP;
---
---ALTER TABLE user_group_member
---DROP COLUMN created_by;
---
-ALTER TABLE user_group_member
-DROP COLUMN deleted_by;
---
---ALTER TABLE user_group_member
---DROP COLUMN status;
---
---ALTER TABLE user_group_member
---DROP COLUMN status_date;
-
-
CREATE TABLE IF NOT EXISTS role_new (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name VARCHAR(100) NOT NULL,
@@ -66,4 +39,5 @@
WHERE query_id IS 0;
CREATE UNIQUE INDEX IF NOT EXISTS role_index on role(name,
- privilege, group_id, query_id);
\ No newline at end of file
+ privilege, group_id, query_id);
+
\ No newline at end of file
diff --git a/src/main/resources/db/sqlite/V1.14__user_group_alteration.sql b/src/main/resources/db/sqlite/V1.14__user_group_alteration.sql
new file mode 100644
index 0000000..1be030e
--- /dev/null
+++ b/src/main/resources/db/sqlite/V1.14__user_group_alteration.sql
@@ -0,0 +1,27 @@
+-- please commented out the indexes in V1.1 later
+DROP INDEX IF EXISTS group_member_role_index;
+DROP INDEX IF EXISTS user_group_member_status_index;
+
+-- please commented out the triggers in V1.2__triggers.sql later
+DROP TRIGGER IF EXISTS insert_member_status;
+DROP TRIGGER IF EXISTS update_member_status;
+DROP TRIGGER IF EXISTS delete_member;
+
+ALTER TABLE user_group
+ADD COLUMN created_date TIMESTAMP;
+
+ALTER TABLE user_group
+DROP COLUMN deleted_by;
+
+ALTER TABLE user_group_member
+DROP COLUMN created_by;
+
+ALTER TABLE user_group_member
+DROP COLUMN deleted_by;
+
+ALTER TABLE user_group_member
+DROP COLUMN status;
+
+ALTER TABLE user_group_member
+DROP COLUMN status_date;
+
\ No newline at end of file