Skip to content

Instantly share code, notes, and snippets.

@briankip
Last active August 29, 2015 14:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save briankip/939cfbee1a44a8488909 to your computer and use it in GitHub Desktop.
Save briankip/939cfbee1a44a8488909 to your computer and use it in GitHub Desktop.
Measures that are tests
delete from iblis.testtype_measures where test_type_id = 192;
delete from iblis.testtype_specimentypes where test_type_id = 192;
delete from iblis.test_types where id = 192;
delete from iblis.testtype_measures where test_type_id = 181;
delete from iblis.testtype_specimentypes where test_type_id = 181;
delete from iblis.test_types where id = 181;
delete from iblis.testtype_measures where test_type_id = 184;
delete from iblis.testtype_specimentypes where test_type_id = 184;
delete from iblis.test_types where id = 184;
delete from iblis.testtype_measures where test_type_id = 185;
delete from iblis.testtype_specimentypes where test_type_id = 185;
delete from iblis.test_types where id = 185;
delete from iblis.testtype_measures where test_type_id = 186;
delete from iblis.testtype_specimentypes where test_type_id = 186;
delete from iblis.test_types where id = 186;
delete from iblis.testtype_measures where test_type_id = 187;
delete from iblis.testtype_specimentypes where test_type_id = 187;
delete from iblis.test_types where id = 187;
delete from iblis.testtype_measures where test_type_id = 188;
delete from iblis.testtype_specimentypes where test_type_id = 188;
delete from iblis.test_types where id = 188;
delete from iblis.testtype_measures where test_type_id = 190;
delete from iblis.testtype_specimentypes where test_type_id = 190;
delete from iblis.test_types where id = 190;
delete from iblis.testtype_measures where test_type_id = 191;
delete from iblis.testtype_specimentypes where test_type_id = 191;
delete from iblis.test_types where id = 191;
delete from iblis.testtype_measures where test_type_id = 138;
delete from iblis.testtype_specimentypes where test_type_id = 138;
delete from iblis.test_types where id = 138;
delete from iblis.testtype_measures where test_type_id = 142;
delete from iblis.testtype_specimentypes where test_type_id = 142;
delete from iblis.test_types where id = 142;
delete from iblis.testtype_measures where test_type_id = 144;
delete from iblis.testtype_specimentypes where test_type_id = 144;
delete from iblis.test_types where id = 144;
delete from iblis.testtype_measures where test_type_id = 156;
delete from iblis.testtype_specimentypes where test_type_id = 156;
delete from iblis.test_types where id = 156;
delete from iblis.testtype_measures where test_type_id = 158;
delete from iblis.testtype_specimentypes where test_type_id = 158;
delete from iblis.test_types where id = 158;
delete from iblis.testtype_measures where test_type_id = 160;
delete from iblis.testtype_specimentypes where test_type_id = 160;
delete from iblis.test_types where id = 160;
delete from iblis.testtype_measures where test_type_id = 161;
delete from iblis.testtype_specimentypes where test_type_id = 161;
delete from iblis.test_types where id = 161;
delete from iblis.testtype_measures where test_type_id = 162;
delete from iblis.testtype_specimentypes where test_type_id = 162;
delete from iblis.test_types where id = 162;
delete from iblis.testtype_measures where test_type_id = 163;
delete from iblis.testtype_specimentypes where test_type_id = 163;
delete from iblis.test_types where id = 163;
delete from iblis.testtype_measures where test_type_id = 164;
delete from iblis.testtype_specimentypes where test_type_id = 164;
delete from iblis.test_types where id = 164;
delete from iblis.testtype_measures where test_type_id = 166;
delete from iblis.testtype_specimentypes where test_type_id = 166;
delete from iblis.test_types where id = 166;
delete from iblis.testtype_measures where test_type_id = 169;
delete from iblis.testtype_specimentypes where test_type_id = 169;
delete from iblis.test_types where id = 169;
delete from iblis.testtype_measures where test_type_id = 171;
delete from iblis.testtype_specimentypes where test_type_id = 171;
delete from iblis.test_types where id = 171;
delete from iblis.testtype_measures where test_type_id = 172;
delete from iblis.testtype_specimentypes where test_type_id = 172;
delete from iblis.test_types where id = 172;
delete from iblis.testtype_measures where test_type_id = 174;
delete from iblis.testtype_specimentypes where test_type_id = 174;
delete from iblis.test_types where id = 174;
delete from iblis.testtype_measures where test_type_id = 222;
delete from iblis.testtype_specimentypes where test_type_id = 222;
delete from iblis.test_types where id = 222;
delete from iblis.testtype_measures where test_type_id = 223;
delete from iblis.testtype_specimentypes where test_type_id = 223;
delete from iblis.test_types where id = 223;
delete from iblis.testtype_measures where test_type_id = 224;
delete from iblis.testtype_specimentypes where test_type_id = 224;
delete from iblis.test_types where id = 224;
delete from iblis.testtype_measures where test_type_id = 225;
delete from iblis.testtype_specimentypes where test_type_id = 225;
delete from iblis.test_types where id = 225;
delete from iblis.testtype_measures where test_type_id = 226;
delete from iblis.testtype_specimentypes where test_type_id = 226;
delete from iblis.test_types where id = 226;
delete from iblis.testtype_measures where test_type_id = 255;
delete from iblis.testtype_specimentypes where test_type_id = 255;
delete from iblis.test_types where id = 255;
delete from iblis.testtype_measures where test_type_id = 260;
delete from iblis.testtype_specimentypes where test_type_id = 260;
delete from iblis.test_types where id = 260;
delete from iblis.testtype_measures where test_type_id = 281;
delete from iblis.testtype_specimentypes where test_type_id = 281;
delete from iblis.test_types where id = 281;
delete from iblis.testtype_measures where test_type_id = 282;
delete from iblis.testtype_specimentypes where test_type_id = 282;
delete from iblis.test_types where id = 282;
delete from iblis.testtype_measures where test_type_id = 307;
delete from iblis.testtype_specimentypes where test_type_id = 307;
delete from iblis.test_types where id = 307;
delete from iblis.testtype_measures where test_type_id = 328;
delete from iblis.testtype_specimentypes where test_type_id = 328;
delete from iblis.test_types where id = 328;
delete from iblis.testtype_measures where test_type_id = 334;
delete from iblis.testtype_specimentypes where test_type_id = 334;
delete from iblis.test_types where id = 334;
delete from iblis.testtype_measures where test_type_id = 335;
delete from iblis.testtype_specimentypes where test_type_id = 335;
delete from iblis.test_types where id = 335;
delete from iblis.testtype_measures where test_type_id = 336;
delete from iblis.testtype_specimentypes where test_type_id = 336;
delete from iblis.test_types where id = 336;
delete from iblis.testtype_measures where test_type_id = 325;
delete from iblis.testtype_specimentypes where test_type_id = 325;
delete from iblis.test_types where id = 325;
delete from iblis.testtype_measures where test_type_id = 330;
delete from iblis.testtype_specimentypes where test_type_id = 330;
delete from iblis.test_types where id = 330;
delete from iblis.testtype_measures where test_type_id = 332;
delete from iblis.testtype_specimentypes where test_type_id = 332;
delete from iblis.test_types where id = 332;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment