deletePatientDataForOpenMRS.sql

set foreign_key_checks=0;

truncate table test_order;
truncate table drug_order;
truncate table note;   
truncate table obs_relationship;  
truncate table concept_proposal;  	
truncate table concept_proposal_tag_map;
truncate table obs;
truncate table orders;
truncate table drug_order; 
truncate table test_order; 
truncate table relationship;
truncate table visit_attribute;
truncate table bed_patient_assignment_map;
truncate table encounter_provider;
truncate table episode_encounter;
truncate table order_group;
truncate table encounter;  
truncate table appointmentscheduling_appointment;
truncate table appointmentscheduling_appointment_status_history;
truncate table visit_attribute;
truncate table visit; 
truncate table patient_identifier;
truncate table appointmentscheduling_appointment_request;
truncate table conditions;
truncate table cohort_member;
truncate table patient_program;
truncate table episode_patient_program;
truncate table patient_program_attribute;
truncate table patient_state;
truncate table patient; 
truncate table episode;
truncate table audit_log;
delete from person_address where person_id <> 1;
delete from person_attribute where person_id <> 1;
delete from person_name where not exists
	(select u.person_id from users u where person_name.person_id = u.person_id or person_name.person_id = 1)
	and not exists (select p.person_id from provider p where person_name.person_id = p.person_id or person_name.person_id = 1);
delete from person where not exists
	(select u.person_id from users u where person.person_id = u.person_id or person.person_id = 1)
	and not exists (select p.person_id from provider p where person.person_id = p.person_id or person.person_id = 1);

delete from event_records where category = 'patient' OR category = 'Encounter';
delete from markers where feed_uri like '%feed/patient/recent%' ;	

truncate table event_records_offset_marker;

update bed set status="AVAILABLE";

set foreign_key_checks=1;