
SELECT setval('cmn_transaction_instance_id_seq', 1);
SELECT setval('cmn_message_instance_id_seq', 1);
SELECT setval('cmn_message_instance_metadata_id_seq', 1);

truncate om_patient_identifier, om_patient;
SELECT setval('om_patient_identifier_id_seq', 1);
SELECT setval('om_patient_id_seq', 1);

truncate pat_patient, pat_patient_address;
SELECT setval('pat_patient_id_seq', 1);
SELECT setval('pat_patient_address_id_seq', 1);

truncate om_encounter, om_lab_order, om_order, om_tele_radiology_order, om_lab_order_specimen, om_specimen, om_order_parent_id, om_wos_query_orders, om_observation, om_appointment, om_requested_procedure, teleradiologyorder_relatedstudies, om_tele_radiology_procedure, om_container, om_observation_flag, om_note_and_comment, om_appointment_resource, om_scheduled_procedure_step, om_protocol_item, om_worklist_entry;
