insert into usr_institution (id,keyword,name,url,institution_type_id) values (nextval('usr_institution_id_seq'),'IHE','IHE','http://gazelle.ihe.net',1);

--
-- Data for Name: tm_testing_session; Type: TABLE DATA; Schema: public; Owner: gazelle
--

INSERT INTO tm_testing_session (id, last_changed, last_modifier_id, active, beginning_date, description, ending_date, invoice_payment_deadline_date, registration_deadline_date, type, year, zone, address_id, currency_id, networkconfiguration_id, mailing_list_url, hidden, order_in_gui, is_critical_status_enabled, configuration_overview, is_proxy_use_enabled, contact_email, contact_firstname, contact_lastname, domain_fee, fee_additional_system, fee_first_system, vat_percent, wiki_url, required_contract, contract_template_path, logo_link_url, logo_url, next_invoice_number, invoice_template_path, ti_accessed_by_qr, ti_claimed_by_qr, ti_verified_on_smartphone, fee_participant, iso3_vat_countries, session_closed, results_compute, internettesting, disable_auto_results, enable_precat_tests, target_color, allowparticipantregistration, certificates_rul, display_certificates_menu, default_testing_session, disable_patient_generation_and_sharing) VALUES (nextval('tm_testing_session_id_seq'), 'now', '', true, '2015-02-13 12:00:00+01', 'default testing session ', '2016-02-12 12:00:00+01', NULL, '2016-02-04 12:00:00+01', 'Connectathon', 2015, 'Demo', NULL, NULL, NULL, '', false, 1, false, NULL, false, 'admin@gazelle.com', 'Admin', 'Admin', NULL, 0.00, 0.00, NULL, '', false, NULL, '', '', 1, NULL, NULL, NULL, NULL, 0.00, NULL, false, '2015-04-09 15:13:13.98751+02', false, false, true, '#4a75b5', false, null, true, true, NULL);


--
-- Data for Name: tm_institution_system; Type: TABLE DATA; Schema: public; Owner: gazelle
--

INSERT INTO tm_institution_system (id, last_changed, last_modifier_id, comment, institution_id, system_id) VALUES (nextval('tm_institution_system_id_seq'), 'now', 'admin', NULL, (select id from usr_institution where keyword = 'IHE'), (select id from tm_system where keyword = 'TOOL_IHE_XDSTOOLS2'));
INSERT INTO tm_institution_system (id, last_changed, last_modifier_id, comment, institution_id, system_id) VALUES (nextval('tm_institution_system_id_seq'), 'now', 'admin', NULL, (select id from usr_institution where keyword = 'IHE'), (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'));


--
-- Data for Name: tm_system_actor_profiles; Type: TABLE DATA; Schema: public; Owner: gazelle
--

INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 260, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 738, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 261, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 739, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 266, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 859, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 265, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 858, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 13,  (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 857, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 247, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 856, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 262, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 855, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 860, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 861, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);      
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 862, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 863, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);
INSERT INTO tm_system_actor_profiles (id, last_changed, last_modifier_id, actor_integration_profile_option_id, system_id, testing_type_id, wanted_testing_type_id, testing_type_reviewed) VALUES (nextval('tm_system_actor_profiles_id_seq'), 'now', 'admin', 341, (select id from tm_system where keyword = 'TOOL_IHE_PATIENT_MANAGER'), 1, NULL, NULL);


