commit 594761f549499b4271311d79684691d7ca6441d2
author Allen Li <ayatane@chromium.org> Fri Oct 20 21:45:06 2017 +0000
committer android-build-merger <android-build-merger@google.com> Fri Oct 20 21:45:06 2017 +0000
tree ebf30f3051cc0417cffe8ac8f7ed4fffb6445d1f
parent a1c97c54e9d3e72b0df4708f0558cb59574b6d9b
parent 12291941077c62e997512e0daea3d9aed6fd337d

[autotest] Add migration for table to track job handoff
am: 1229194107

Change-Id: I181c18a7555b127f7f9ac4fb74605c292e15e211

frontend/migrations/120_add_job_handoff_table.py

diff --git a/frontend/migrations/120_add_job_handoff_table.py b/frontend/migrations/120_add_job_handoff_table.py
new file mode 100644
index 0000000..67e0eda
--- /dev/null
+++ b/frontend/migrations/120_add_job_handoff_table.py
@@ -0,0 +1,13 @@
+UP_SQL = """
+CREATE TABLE afe_job_handoffs (
+  job_id int(11) NOT NULL,
+  PRIMARY KEY (job_id),
+  CONSTRAINT job_fk FOREIGN KEY (job_id)
+    REFERENCES afe_jobs(id)
+    ON DELETE CASCADE
+) ENGINE=INNODB;
+"""
+
+DOWN_SQL = """
+DROP TABLE afe_job_handoffs;
+"""