aboutsummaryrefslogtreecommitdiff
path: root/server/store/migrations/mysql/20180807224200_new_primary_key.sql
diff options
context:
space:
mode:
Diffstat (limited to 'server/store/migrations/mysql/20180807224200_new_primary_key.sql')
-rw-r--r--server/store/migrations/mysql/20180807224200_new_primary_key.sql11
1 files changed, 0 insertions, 11 deletions
diff --git a/server/store/migrations/mysql/20180807224200_new_primary_key.sql b/server/store/migrations/mysql/20180807224200_new_primary_key.sql
deleted file mode 100644
index ed6a3c2..0000000
--- a/server/store/migrations/mysql/20180807224200_new_primary_key.sql
+++ /dev/null
@@ -1,11 +0,0 @@
--- +migrate Up
-ALTER TABLE `issued_certs`
- DROP PRIMARY KEY,
- ADD COLUMN `id` INT PRIMARY KEY AUTO_INCREMENT FIRST,
- ADD UNIQUE INDEX `idx_key_id` (`key_id`);
-
--- +migrate Down
-ALTER TABLE `issued_certs`
- DROP PRIMARY KEY,
- DROP COLUMN `id`,
- ADD PRIMARY KEY (`key_id`);