-- 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,'jumbo-4.irisa.fr','SWFID-HOST');
INSERT INTO app_configuration (id,value,variable) VALUES(2,'10012','SWFID-PORT');
INSERT INTO app_configuration (id,value,variable) VALUES(3,'DCM4CHEE','SWFID-AET');
INSERT INTO app_configuration (id, variable, value) VALUES (4, 'application_admin_email', 'eric.poiseau@inria.fr');
INSERT INTO app_configuration (id, variable, value) VALUES (5, 'application_issue_tracker_url', 'http://gazelle.ihe.net/jira/browse/SWFID');
INSERT INTO app_configuration (id, variable, value) VALUES (6, 'application_name', 'SWFID Simulator');
INSERT INTO app_configuration (id, variable, value) VALUES (7, 'application_release_notes_url', 'http://gazelle.ihe.net');
INSERT INTO app_configuration (id, variable, value) VALUES (8, 'application_time_zone', 'UTC+01');
INSERT INTO app_configuration (id, variable, value) VALUES (9, 'application_admin_name', 'Eric Poiseau');
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);