For Tran - Blow away Ct and Pubs

gistfile1.sql

begin transaction tx
delete from provider_media_item 
where author_set_id in (134, 136, 137, 226, 227, 290)

delete from clinical_trial_link
where clinical_trial_id in (select clinical_trial_id from clinical_trial
                            where clinical_trial_set_id in (143, 145, 236, 237, 238, 290))

delete from clinical_trial_sponsor
where clinical_trial_id in (select clinical_trial_id from clinical_trial
                            where clinical_trial_set_id in (143, 145, 236, 237, 238, 290))
                            
delete from clinical_trial_media_item
where clinical_trial_id in (select clinical_trial_id from clinical_trial
                            where clinical_trial_set_id in (143, 145, 236, 237, 238, 290))                            

delete from provider_clinical_trial
where clinical_trial_id in (select clinical_trial_id from clinical_trial
                            where clinical_trial_set_id in (143, 145, 236, 237, 238, 290))
                            
delete from clinical_trial
where clinical_trial_set_id in (143, 145, 236, 237, 238, 290)
rollback transaction tx