From 390526dbb8847ebddbc83b5151c5486cb1fa01e7 Mon Sep 17 00:00:00 2001 From: Kavoos Bojnourdi Date: Sun, 9 Aug 2015 16:13:01 +0200 Subject: [PATCH] - added admin user in the database --- projects/GDE_App/src/GDE_DB_Init.sql | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/projects/GDE_App/src/GDE_DB_Init.sql b/projects/GDE_App/src/GDE_DB_Init.sql index 72a1a3c..ed64725 100644 --- 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); + -- 2.30.2