INSERT INTO "app_configuration" (id, variable, value) VALUES ('1', 'ltwort_application_configuration_ip_address', '131.254.209.12');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('2', 'ltwort_application_configuration_port', '10013');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('3', 'ltwort_application_configuration_receivingApplication', 'LTW ORT Simulator');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('4', 'ltwort_application_configuration_receivingFacility', 'IHE');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('5', 'xsl_location', 'http://sumo.irisa.fr/xsl/hl7Validation/resultStylesheet.xsl');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('6', 'url_EVCS_ws', 'http://kujira.irisa.fr:8080/Hl7V2Evs-prod-InriaHL7Validator-ejb/InriaHL7CupWS?wsdl');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('7', 'documentation_link', 'http://gazelle.ihe.net/content/ltw-ort-simulator');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('8', 'hl7_version', '2.5');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('9', 'ltwort_application_configuration_name', 'LTW ORT Simulator');
INSERT INTO "app_configuration" (id, variable, value) VALUES ('10', 'timeout_for_receiving_messages', '500');

INSERT INTO "tf_actor" (id, name, keyword) VALUES ('1', 'Order Filler', 'OF');
INSERT INTO "tf_actor" (id, name, keyword) VALUES ('2', 'Order Result Tracker', 'ORT');

INSERT INTO "tf_transaction" (id, name, keyword) VALUES ('1', 'Order Results Management', 'LAB-3');

INSERT INTO "validation_parameters" (id, message_type,profile_oid,actor_id,transaction_id) VALUES ('1', 'ORU^R01^ORU_R01','1.3.6.1.4.12559.11.1.1.20',1,1);
INSERT INTO "validation_parameters" (id, message_type,profile_oid,actor_id,transaction_id) VALUES ('2', 'OUL^R22^OUL_R22','1.3.6.1.4.12559.11.1.1.18',1,1);
INSERT INTO "validation_parameters" (id, message_type,profile_oid,actor_id,transaction_id) VALUES ('3', 'ACK','1.3.6.1.4.12559.11.1.1.22',2,1);



INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (1,  'ASCII','ASCII', 'US-ASCII' );                                
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (2,  'Latin alphabet No.1',	'8859/1'	,'ISO-8859-1');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (3,  'Latin alphabet No.2', 	'8859/2'	, 'ISO8859_2');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (4,  'Latin alphabet No.3', 	'8859/3'	, 'ISO8859_3');    
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (5,  'Latin alphabet No.4', 	'8859/4'	, 'ISO8859_4');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (6,  'Latin/Cyrillic alphabet', 	'8859/5'	, 'ISO8859_5');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (7,  'Latin/Arabic alphabet', 	'8859/6'	, 'ISO8859_6');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (8,  'Latin/Greek alphabet', 	'8859/7'	, 'ISO8859_7');   
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (9,  'Latin/Hebrew alphabet', 	'8859/8'	, 'ISO8859_8');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (10, 'Latin alphabet No.5', 	'8859/9'	, 'ISO8859_9');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (11, 'Japanese (JIS X 0201)', 	'ISO IR14', 'JIS0201' );
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (12, 'Japanese (JIS X 0208)', 	'ISO IR87', 'JIS0208' );            
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (13, 'Japanese (JIS X 0212)', 	'ISO IR159',  'JIS0212');       
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (14, 'Chinese', 	'GB 18030-2000'	, 'EUC_CN');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (15, 'Korean', 	'KS X 1001'	, 'EUC_KR');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (16, 'Taiwanese', 	'CNS 11643-1992', 'EUC_TW');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (17, 'Taiwanese (BIG 5)', 'BIG-5', 'Big5');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (18, 'UTF-8', 		'UNICODE UTF-8' , 'UTF8'    ); 
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (19, 'UTF-16', 		'UNICODE UTF-16', 'UTF-16');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (20, 'UTF-32', 		'UNICODE UTF-32', 'UTF-32');                                                                                                                                               

SELECT pg_catalog.setval('hl7_charset_id_seq', 20, true);

INSERT INTO app_configuration(id, variable, value) VALUES (26, 'application_url', 'http://localhost:8080/LTWORT');


INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (1, 'ORT in ASCII', 10080, 2, 1, null, 1, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (2, 'ORT in Latin alphabet ISO-8859-1', 10081, 2, 1, null, 2, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (3, 'ORT in Latin alphabet ISO8859_2', 10082, 2, 1, null, 3, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (4, 'ORT in Latin alphabet ISO8859_3', 10083, 2, 1, null, 4, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (5, 'ORT in Latin alphabet ISO8859_4', 10084, 2, 1, null, 5, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (6, 'ORT in Latin/Cyrillic alphabet ISO8859_5', 10085, 2, 1, null, 6, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (7, 'ORT in Latin/Arabic alphabet ISO8859_6', 10086, 2, 1, null, 7, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (8, 'ORT in Latin/Greek alphabet ISO8859_7', 10087, 2, 1, null, 8, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (9, 'ORT in Latin/Hebrew alphabet ISO8859_8', 10088, 2, 1, null, 9, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (10, 'ORT in Latin alphabet No.5 ISO8859_9', 10089, 2, 1, null, 10, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (11, 'ORT in Japanese (JIS X 0201)', 10090, 2, 1, null, 11, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (12, 'ORT in Japanese (JIS X 0208)', 10091, 2, 1, null, 12, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (13, 'ORT in Japanese (JIS X 0212)', 10092, 2, 1, null, 13, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (14, 'ORT in Chinese', 10093, 2, 1, null, 14, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (15, 'ORT in Korean', 10094, 2, 1, null, 15, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (16, 'ORT in Taiwanese', 10095, 2, 1, null, 16, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (17, 'ORT in Taiwanese (BIG 5)', 10096, 2, 1, null, 17, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (18, 'ORT in UTF-8', 10097, 2, 1, null, 18, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (19, 'ORT in UTF-16', 10098, 2, 1, null, 19, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, ip_address, receiving_application, receiving_facility) VALUES (20, 'ORT in UTF-32', 10099, 2, 1, null, 20, '*', '*', '127.0.0.1', 'LTW ORT Simulator', 'IHE');

