summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--frontend/migrations/065_add_id_afe_hosts_labels.py7
1 files changed, 7 insertions, 0 deletions
diff --git a/frontend/migrations/065_add_id_afe_hosts_labels.py b/frontend/migrations/065_add_id_afe_hosts_labels.py
new file mode 100644
index 00000000..995feef1
--- /dev/null
+++ b/frontend/migrations/065_add_id_afe_hosts_labels.py
@@ -0,0 +1,7 @@
+UP_SQL = """
+ALTER TABLE afe_hosts_labels ADD COLUMN id integer AUTO_INCREMENT NOT NULL PRIMARY KEY FIRST;
+"""
+
+DOWN_SQL = """
+ALTER TABLE afe_hosts_labels DROP COLUMN id;
+"""