- added admin user in the database

[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 72a1a3cecd23f7f3b15e49265ec9faa2c22ba979..ed647251dbc7d3ca94851d8670206a309e208c15 100644 (file)
--- a/projects/GDE_App/src/GDE_DB_Init.sql
+++ b/projects/GDE_App/src/GDE_DB_Init.sql
@@ -110,3 +110,8 @@ CREATE TABLE profile_attribute (
     profile_id bigint REFERENCES profile (id)
 );
 
+-- The 50 first id are reserved for initial data
+INSERT INTO users (id,username,userpassword) VALUES (0,'admin','edf123');
+INSERT INTO group_ (id,groupname) VALUES (1,'admins');
+INSERT into usergroup(id,groupid,userid) VALUES (2,1,0);
+