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; |
+""" |