/*   Delete Sample test data
*/
delete from samples where code = 'CTLP_CODE' and saty_id = (select id from sample_types where code = 'CONTROL LAYOUT');

delete from samples where code = 'CP_CODE' and saty_id = (select id from sample_types where code = 'CELL PLATE');

delete from samples where code = 'DP_CODE' and saty_id = (select id from sample_types where code = 'DILUTION PLATE');

delete from samples where code = 'MP_CODE' and saty_id = (select id from sample_types where code = 'MASTER PLATE');
