    EMAIL varchar(100)
 )
 ;
-ALTER TABLE USERINFOTABLE
-ADD CONSTRAINT USERINFO_FK
-FOREIGN KEY (USERID)
-REFERENCES USERTABLE(USERID) ON DELETE CASCADE
-
-;
-CREATE INDEX SQL090616190958780 ON USERINFOTABLE(USERID)
-;
-
-INSERT INTO "APP"."USERINFOTABLE" (USERID,FIRSTNAME,LASTNAME,EMAIL) VALUES ('admin','delete or edit me','password is admin','');
-
-
 
 CREATE TABLE "APP"."GROUPTABLE"
 (

   CONSTRAINT GROUP_FK PRIMARY KEY (USERID,GROUPID)
)
;
ALTER TABLE GROUPTABLE
ADD CONSTRAINT USER_FK
FOREIGN KEY (USERID)

INSERT INTO "APP"."GROUPTABLE" (USERID,GROUPID) VALUES ('alex','ADMINISTRATORS');
INSERT INTO "APP"."GROUPTABLE" (USERID,GROUPID) VALUES ('alex','USERS');

INSERT INTO "APP"."USERINFOTABLE" (USERID,FIRSTNAME,LASTNAME,EMAIL) VALUES ('admin','delete or edit me','password is admin','');


