| Index: frontend/migrations/056_planner_global_support.py
|
| diff --git a/frontend/migrations/056_planner_global_support.py b/frontend/migrations/056_planner_global_support.py
|
| new file mode 100644
|
| index 0000000000000000000000000000000000000000..e5ce4d3ed4fe8b8849c6c7006e0185ca19a98c23
|
| --- /dev/null
|
| +++ b/frontend/migrations/056_planner_global_support.py
|
| @@ -0,0 +1,19 @@
|
| +UP_SQL = """
|
| +CREATE TABLE planner_test_configs_skipped_hosts (
|
| + testconfig_id INT NOT NULL,
|
| + host_id INT NOT NULL,
|
| + PRIMARY KEY (testconfig_id, host_id)
|
| +) ENGINE = InnoDB;
|
| +
|
| +ALTER TABLE planner_test_configs_skipped_hosts
|
| +ADD CONSTRAINT planner_test_configs_skipped_hosts_testconfig_ibfk
|
| +FOREIGN KEY (testconfig_id) REFERENCES planner_test_configs (id);
|
| +
|
| +ALTER TABLE planner_test_configs_skipped_hosts
|
| +ADD CONSTRAINT planner_test_configs_skipped_hosts_host_ibfk
|
| +FOREIGN KEY (host_id) REFERENCES afe_hosts (id);
|
| +"""
|
| +
|
| +DOWN_SQL = """
|
| +DROP TABLE IF EXISTS planner_test_configs_skipped_hosts;
|
| +"""
|
|
|