-- 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 (1,'application_url','http://localhost:8180/PIXPDQV3Simulator/');
INSERT INTO app_configuration(id, variable, value) VALUES (2,'pds_server_port','3603');
INSERT INTO app_configuration(id, variable, value) VALUES (3,'dds_web_service','http://131.254.209.12:8080/DDS-prod-DemographicDataServer-ejb/DemographicDataServerBean?wsdl');
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/');
INSERT INTO app_configuration(id, variable, value) VALUES (6, 'application_name', 'PDQ PDS 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 app_configuration(id, variable, value) VALUES (10,'pds_server_name','jumbo-4.irisa.fr');
INSERT INTO app_configuration(id, variable, value) VALUES (11,'pds_server_port','3603');
INSERT INTO app_configuration(id, variable, value) VALUES (12,'process','Complete');

INSERT INTO app_configuration(id, variable, value) VALUES (13, 'system_id_root', '1.3.6.1.4.1.12559.11.1.2.2.3.1');

SELECT pg_catalog.setval('app_configuration_id_seq', 12, true);

INSERT INTO tf_transaction(id, description, keyword, name) VALUES (1, 'ITI-21', 'ITI-21', 'ITI-21');
SELECT pg_catalog.setval('tf_transaction_id_seq', 1, true);
