1 UP_SQL = """ 2 CREATE TABLE planner_test_configs_skipped_hosts ( 3 testconfig_id INT NOT NULL, 4 host_id INT NOT NULL, 5 PRIMARY KEY (testconfig_id, host_id) 6 ) ENGINE = InnoDB; 7 8 ALTER TABLE planner_test_configs_skipped_hosts 9 ADD CONSTRAINT planner_test_configs_skipped_hosts_testconfig_ibfk 10 FOREIGN KEY (testconfig_id) REFERENCES planner_test_configs (id); 11 12 ALTER TABLE planner_test_configs_skipped_hosts 13 ADD CONSTRAINT planner_test_configs_skipped_hosts_host_ibfk 14 FOREIGN KEY (host_id) REFERENCES afe_hosts (id); 15 """ 16 17 DOWN_SQL = """ 18 DROP TABLE IF EXISTS planner_test_configs_skipped_hosts; 19 """ 20
