text: drop view if exists run_id_with_results;
  
  drop table if exists run;
  drop type if exists run_status_enum;
  
  drop table if exists result;
  drop type if exists result_type_enum;
  drop table if exists run_result;
  drop table if exists template_result;
  