Added virtual corpus edit service.
Change-Id: I9e030930c3fb0118086ae6359cf192157ea73098
diff --git a/full/src/main/resources/db/insert/V3.1__insert_virtual_corpus.sql b/full/src/main/resources/db/insert/V3.1__insert_virtual_corpus.sql
index 70becc8..d613460 100644
--- a/full/src/main/resources/db/insert/V3.1__insert_virtual_corpus.sql
+++ b/full/src/main/resources/db/insert/V3.1__insert_virtual_corpus.sql
@@ -7,8 +7,8 @@
INSERT INTO user_group(name,status,created_by)
VALUES ("auto group","HIDDEN","system");
-INSERT INTO user_group(name,status,created_by)
- VALUES ("all users","HIDDEN","system");
+--INSERT INTO user_group(name,status,created_by)
+-- VALUES ("all users","HIDDEN","system");
INSERT INTO user_group(name,status,created_by)
VALUES ("deleted group","DELETED","dory");
@@ -77,7 +77,7 @@
SELECT
(SELECT id from virtual_corpus where name = "published VC"),
(SELECT id from user_group where name = "all users"),
- "HIDDEN", "marlin";
+ "HIDDEN", "system";
INSERT INTO virtual_corpus_access(virtual_corpus_id, user_group_id, status, created_by)
SELECT
diff --git a/full/src/main/resources/db/insert/V3.3__insert_member_roles.sql b/full/src/main/resources/db/insert/V3.3__insert_member_roles.sql
index 459b5e2..202ff50 100644
--- a/full/src/main/resources/db/insert/V3.3__insert_member_roles.sql
+++ b/full/src/main/resources/db/insert/V3.3__insert_member_roles.sql
@@ -2,27 +2,27 @@
-- dory group
INSERT INTO group_member_role(group_member_id,role_id)
SELECT
- (SELECT id FROM user_group_member WHERE user_id="dory" AND group_id=1),
+ (SELECT id FROM user_group_member WHERE user_id="dory" AND group_id=2),
(SELECT id FROM role WHERE name = "group admin");
INSERT INTO group_member_role(group_member_id,role_id)
SELECT
- (SELECT id FROM user_group_member WHERE user_id="dory" AND group_id=1),
+ (SELECT id FROM user_group_member WHERE user_id="dory" AND group_id=2),
(SELECT id FROM role WHERE name = "vc admin");
INSERT INTO group_member_role(group_member_id,role_id)
SELECT
- (SELECT id FROM user_group_member WHERE user_id="nemo" AND group_id=1),
+ (SELECT id FROM user_group_member WHERE user_id="nemo" AND group_id=2),
(SELECT id FROM role WHERE name = "group member");
INSERT INTO group_member_role(group_member_id,role_id)
SELECT
- (SELECT id FROM user_group_member WHERE user_id="nemo" AND group_id=1),
+ (SELECT id FROM user_group_member WHERE user_id="nemo" AND group_id=2),
(SELECT id FROM role WHERE name = "vc member");
-- auto group
INSERT INTO group_member_role(group_member_id,role_id)
SELECT
- (SELECT id FROM user_group_member WHERE user_id="pearl" AND group_id=2),
+ (SELECT id FROM user_group_member WHERE user_id="pearl" AND group_id=3),
(SELECT id FROM role WHERE name = "vc member");
diff --git a/full/src/main/resources/db/predefined/V3.0__insert_predefined_user_groups.sql b/full/src/main/resources/db/predefined/V3.0__insert_predefined_user_groups.sql
new file mode 100644
index 0000000..ba34c4e
--- /dev/null
+++ b/full/src/main/resources/db/predefined/V3.0__insert_predefined_user_groups.sql
@@ -0,0 +1,3 @@
+
+INSERT INTO user_group(name,status,created_by)
+ VALUES ("all users","HIDDEN","system");
\ No newline at end of file
diff --git a/full/src/main/resources/jdbc.properties b/full/src/main/resources/jdbc.properties
index 9b888f0..fb06a12 100644
--- a/full/src/main/resources/jdbc.properties
+++ b/full/src/main/resources/jdbc.properties
@@ -22,4 +22,4 @@
jdbc.username=pc
jdbc.password=pc
# db.insert contains test data, omit it in production setting
-jdbc.schemaPath=db.new-sqlite, db.insert, db.predefined
+jdbc.schemaPath=db.new-sqlite, db.predefined, db.insert