Merge remote branch 'origin/master' into agr/api_cpp

[modules/gde.git] / projects / GDE_App / src / GDE_DB_Init.sql

diff --git a/projects/GDE_App/src/GDE_DB_Init.sql b/projects/GDE_App/src/GDE_DB_Init.sql
index 10e4cf0789f010d0034c5923967f53e4c18c541e..de15a8334c596014b52a4a77efc7fa2b57d6fd68 100644 (file)
--- a/projects/GDE_App/src/GDE_DB_Init.sql
+++ b/projects/GDE_App/src/GDE_DB_Init.sql
@@ -3,6 +3,7 @@
 drop sequence if exists SEQ_GEN_SEQUENCE;
 create sequence SEQ_GEN_SEQUENCE START WITH 1000 INCREMENT BY 50;
 
+drop table if exists study_files cascade;
 
 DROP TABLE IF EXISTS GROUP_ CASCADE;
 CREATE TABLE GROUP_ (
@@ -26,8 +27,6 @@ CREATE TABLE USERGROUP (
 );
 create index usergroup_groupId_idx ON USERGROUP(groupId);
 
-
-
 DROP TABLE IF EXISTS GROUPPERMISSIONS CASCADE;
 CREATE TABLE GROUPPERMISSIONS (
     id bigint NOT NULL PRIMARY KEY,
@@ -71,7 +70,6 @@ CREATE TABLE profile_attribute (
 );
 
 /* DATA */
-
 DROP TABLE IF EXISTS gde_file CASCADE;
 CREATE TABLE gde_file (
     id bigint NOT NULL PRIMARY KEY,
@@ -98,7 +96,6 @@ CREATE TABLE chunk (
 );
 
 /* STUDIES */
-
 DROP TABLE IF EXISTS study CASCADE;
 CREATE TABLE study (
     id bigint NOT NULL PRIMARY KEY,
@@ -151,4 +148,11 @@ INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (26, 1,
 INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (27, 1, 'AttributesService',5); -- Delete attribute group
 INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (28, 1, 'AttributesService',6); -- Update attribute group
 INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (29, 1, 'AttributesService',7); -- Read attribute group
- 
+/* File services */ 
+INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (30, 1, 'FileService',1); -- 
+INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (31, 1, 'FileService',2); -- 
+INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (32, 1, 'FileService',3); -- 
+INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (33, 1, 'FileService',4); -- 
+INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (34, 1, 'FileService',5); -- 
+INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (35, 1, 'FileService',6); -- 
+INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (36, 1, 'FileService',7); --