Home | History | Annotate | Download | only in migrations
      1 UP_SQL = """
      2 ALTER TABLE `planner_test_runs` ADD CONSTRAINT `test_runs_unique` UNIQUE KEY (`plan_id`, `test_job_id`, `tko_test_id`, `host_id`);
      3 
      4 ALTER TABLE `planner_tests` ADD COLUMN `is_server` tinyint(1) DEFAULT 1;
      5 
      6 ALTER TABLE `planner_hosts` ADD COLUMN `added_by_label` tinyint(1) DEFAULT 0;
      7 """
      8 
      9 DOWN_SQL = """
     10 ALTER TABLE `planner_hosts` DROP COLUMN `added_by_label`;
     11 ALTER TABLE `planner_tests` DROP COLUMN `is_server`;
     12 ALTER TABLE `planner_test_runs` DROP KEY `test_runs_unique`;
     13 """
     14