-- SQL statements which are executed at application startup if hibernate.hbm2ddl.auto is 'create' or 'create-drop'

INSERT INTO "app_configuration" (id, variable, value) VALUES ('20', 'application_admin_email', 'eric.poiseau@inria.fr');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('21', 'application_issue_tracker_url', 'http://gazelle.ihe.net/jira');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('22', 'application_name', 'Simulator Template');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('23', 'application_release_notes_url', 'http://gazelle.ihe.net');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('24', 'application_time_zone', 'UTC+01');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('25', 'application_admin_name', 'Eric Poiseau');

INSERT INTO "app_configuration" (id, variable, value) VALUES ('30', 'application_configuration_name', 'LBL LB Simulator Responder');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('31', 'application_configuration_ip_address', '127.0.0.1');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('32', 'application_configuration_port', '1124');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('33', 'application_configuration_receivingApplication', 'LBL LB Simulator');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('34', 'application_configuration_receivingFacility', 'IHE');
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 tf_transaction(id, description, keyword, name) VALUES (1, 'Laboratory Specimen Barcode Labeling Label Broker', 'LAB-62', 'LBL LB');

INSERT INTO sys_config(id, name, application, facility, ip_address, port) VALUES (1, 'LBL LB Simulator Responder', 'LBL LB Simulator', 'IHE', '127.0.0.1', 1124);

INSERT INTO sys_config(id, name, application, facility, ip_address, port) VALUES (2, 'INRIA', 'LIP', 'LIP INRIA', '127.0.0.1', 5555);

