-- SQL statements which are executed at application startup if hibernate.hbm2ddl.auto is 'create' or 'create-drop'
INSERT INTO app_configuration (id,value,VARIABLE)VALUES(1,'/opt/XDRSRCSimulator','epsosFolder');
INSERT INTO app_configuration (id,value,VARIABLE)VALUES(2,'/opt/XDRSRCSimulator/tmp','uploadFolder');
INSERT INTO app_configuration (id,value,VARIABLE)VALUES(3,'1.3.6.1.4.1.12559.11.1.2.2.1.1','sourceID');
INSERT INTO app_configuration (id,value,VARIABLE)VALUES(4,'gazelle','keyStorePass');
INSERT INTO app_configuration (id,value,VARIABLE)VALUES(5,'cda.xsl','cda_xsl_path');
INSERT INTO app_configuration (id,value,VARIABLE)VALUES(6,'True','xua');
INSERT INTO app_configuration (id,value,VARIABLE)VALUES(7,'http://gazelle.ihe.net/sts','sts_server');
INSERT INTO app_configuration (id,value,VARIABLE)VALUES(8,'Epsos','application_domain');
INSERT INTO app_configuration (id, value, VARIABLE) VALUES (9,'XDR Test Pratician','default_pratician_id' );
INSERT INTO app_configuration (id, variable, value) VALUES (10, 'application_admin_email', 'eric.poiseau@inria.fr');
INSERT INTO app_configuration (id, variable, value) VALUES (11, 'application_issue_tracker_url', 'http://gazelle.ihe.net/jira/browse/XDRSRC');
INSERT INTO app_configuration (id, variable, value) VALUES (12, 'application_name', 'XDR Source document');
INSERT INTO app_configuration (id, variable, value) VALUES (13, 'application_release_notes_url', 'http://gazelle.ihe.net');
INSERT INTO app_configuration (id, variable, value) VALUES (14, 'application_time_zone', 'UTC+01');
INSERT INTO app_configuration (id, variable, value) VALUES (15, 'application_admin_name', 'Eric Poiseau');

INSERT INTO xdr_system_configuration (id,ip,name,port,secure,url)VALUES(1,'131.254.209.14','Epsos Secured',9085,'True','/epsos/services/xdsrepositoryb');
INSERT INTO xdr_system_configuration (id,ip,name,port,secure,url)VALUES(2,'131.254.209.14','Epsos Unsecured',9080,'False','/epsos/services/xdsrepositoryb');
insert into user_role (id, name, conditional) values (1, 'admin', false);
insert into user_role (id, name, conditional) values (2, 'member', false);
insert into user_role (id, name, conditional) values (3, 'guest', true);
insert into user_account_role (account_id, member_of_role) values (1, 1);
insert into user_role_group (role_id, member_of_role) values (1, 2);

INSERT INTO gs_test_instance_status(id, keyword, label_to_display, description) VALUES (1, 'started', 'started', 'started');
INSERT INTO gs_test_instance_status(id, keyword, label_to_display, description) VALUES (2, 'completed', 'completed', 'completed');

