• Home
  • Line#
  • Scopes#
  • Navigate#
  • Raw
  • Download
1UP_SQL = """
2CREATE 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
8ALTER TABLE planner_test_configs_skipped_hosts
9ADD CONSTRAINT planner_test_configs_skipped_hosts_testconfig_ibfk
10FOREIGN KEY (testconfig_id) REFERENCES planner_test_configs (id);
11
12ALTER TABLE planner_test_configs_skipped_hosts
13ADD CONSTRAINT planner_test_configs_skipped_hosts_host_ibfk
14FOREIGN KEY (host_id) REFERENCES afe_hosts (id);
15"""
16
17DOWN_SQL = """
18DROP TABLE IF EXISTS planner_test_configs_skipped_hosts;
19"""
20