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);

UPDATE sys_config SET active = TRUE, shared = TRUE;

UPDATE "sys_config" SET charset_id = 18;

INSERT INTO app_configuration(id, variable, value) VALUES (26, 'application_url', 'http://gazelle.ihe.net/LBLSimulator');

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, 'LB in ASCII', 10040, 1, 1, null, 1, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in Latin alphabet ISO-8859-1', 10041, 1, 1, null, 2, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in Latin alphabet ISO8859_2', 10042, 1, 1, null, 3, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in Latin alphabet ISO8859_3', 10043, 1, 1, null, 4, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in Latin alphabet ISO8859_4', 10044, 1, 1, null, 5, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in Latin/Cyrillic alphabet ISO8859_5', 10045, 1, 1, null, 6, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in Latin/Arabic alphabet ISO8859_6', 10046, 1, 1, null, 7, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in Latin/Greek alphabet ISO8859_7', 10047, 1, 1, null, 8, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in Latin/Hebrew alphabet ISO8859_8', 10048, 1, 1, null, 9, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in Latin alphabet No.5 ISO8859_9', 10049, 1, 1, null, 10, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in Japanese (JIS X 0201)', 10050, 1, 1, null, 11, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in Japanese (JIS X 0208)', 10051, 1, 1, null, 12, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in Japanese (JIS X 0212)', 10052, 1, 1, null, 13, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in Chinese', 10053, 1, 1, null, 14, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in Korean', 10054, 1, 1, null, 15, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in Taiwanese', 10055, 1, 1, null, 16, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in Taiwanese (BIG 5)', 10056, 1, 1, null, 17, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in UTF-8', 10057, 1, 1, null, 18, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in UTF-16', 10058, 1, 1, null, 19, '*', '*', '131.254.209.12', 'LBL LB 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, 'LB in UTF-32', 10059, 1, 1, null, 20, '*', '*', '131.254.209.12', 'LBL LB 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 (21, 'LIP in ASCII', 10060, 2, 2, null, 1, '*', '*', '131.254.209.12', 'LBL LIP 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 (22, 'LIP in Latin alphabet ISO-8859-1', 10061, 2, 2, null, 2, '*', '*', '131.254.209.12', 'LBL LIP 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 (23, 'LIP in Latin alphabet ISO8859_2', 10062, 2, 2, null, 3, '*', '*', '131.254.209.12', 'LBL LIP 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 (24, 'LIP in Latin alphabet ISO8859_3', 10063, 2, 2, null, 4, '*', '*', '131.254.209.12', 'LBL LIP 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 (25, 'LIP in Latin alphabet ISO8859_4', 10064, 2, 2, null, 5, '*', '*', '131.254.209.12', 'LBL LIP 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 (26, 'LIP in Latin/Cyrillic alphabet ISO8859_5', 10065, 2, 2, null, 6, '*', '*', '131.254.209.12', 'LBL LIP 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 (27, 'LIP in Latin/Arabic alphabet ISO8859_6', 10066, 2, 2, null, 7, '*', '*', '131.254.209.12', 'LBL LIP 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 (28, 'LIP in Latin/Greek alphabet ISO8859_7', 10067, 2, 2, null, 8, '*', '*', '131.254.209.12', 'LBL LIP 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 (29, 'LIP in Latin/Hebrew alphabet ISO8859_8', 10068, 2, 2, null, 9, '*', '*', '131.254.209.12', 'LBL LIP 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 (30, 'LIP in Latin alphabet No.5 ISO8859_9', 10069, 2, 2, null, 10, '*', '*', '131.254.209.12', 'LBL LIP 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 (31, 'LIP in Japanese (JIS X 0201)', 10070, 2, 2, null, 11, '*', '*', '131.254.209.12', 'LBL LIP 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 (32, 'LIP in Japanese (JIS X 0208)', 10071, 2, 2, null, 12, '*', '*', '131.254.209.12', 'LBL LIP 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 (33, 'LIP in Japanese (JIS X 0212)', 10072, 2, 2, null, 13, '*', '*', '131.254.209.12', 'LBL LIP 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 (34, 'LIP in Chinese', 10073, 2, 2, null, 14, '*', '*', '131.254.209.12', 'LBL LIP 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 (35, 'LIP in Korean', 10074, 2, 2, null, 15, '*', '*', '131.254.209.12', 'LBL LIP 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 (36, 'LIP in Taiwanese', 10075, 2, 2, null, 16, '*', '*', '131.254.209.12', 'LBL LIP 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 (37, 'LIP in Taiwanese (BIG 5)', 10076, 2, 2, null, 17, '*', '*', '131.254.209.12', 'LBL LIP 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 (38, 'LIP in UTF-8', 10077, 2, 2, null, 18, '*', '*', '131.254.209.12', 'LBL LIP 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 (39, 'LIP in UTF-16', 10078, 2, 2, null, 19, '*', '*', '131.254.209.12', 'LBL LIP 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 (40, 'LIP in UTF-32', 10079, 2, 2, null, 20, '*', '*', '131.254.209.12', 'LBL LIP Simulator', 'IHE');





