-- SQL statements which are executed at application startup if hibernate.hbm2ddl.auto is 'create' or 'create-drop'
INSERT INTO xcpd_configuration(id, variable, value) VALUES (1,'gazelle_bin','/opt/gazelle/bin');
INSERT INTO xcpd_configuration(id, variable, value) VALUES (2,'xcpd_request_schema','/opt/gazelle/bin/schematron/xcpd/xcpd-identification/schemas/HL7V3/NE2008/multicacheschemas/PRPA_IN201305UV02PLA.xsd');
INSERT INTO xcpd_configuration(id, variable, value) VALUES (3,'xcpd_response_schema','/opt/gazelle/bin/schematron/xcpd/xcpd-identification/schemas/HL7V3/NE2008/multicacheschemas/PRPA_IN201306UV02PLA.xsd');
INSERT INTO xcpd_configuration(id, variable, value) VALUES (4,'pds_server_name','jumbo-4.irisa.fr');
INSERT INTO xcpd_configuration(id, variable, value) VALUES (5,'pds_server_port','3603');
INSERT INTO xcpd_configuration(id, variable, value) VALUES (6,'process','Complete');
INSERT INTO xcpd_configuration(id, variable, value) VALUES (7,'sts_url','http://localhost:8080/picketlink-sts-1.0.3.SP1/PicketLinkSTS');
INSERT INTO xcpd_configuration(id, variable, value) VALUES (8,'sts_service_name','PicketLinkSTS');
INSERT INTO xcpd_configuration(id, variable, value) VALUES (9,'sts_port','PicketLinkSTSPort');
INSERT INTO xcpd_configuration(id, variable, value) VALUES (10,'is_xua','True');
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, 'Cross Gateway Patient Discovery', 'ITI-55', 'Cross Gateway Patient Discovery');
