aboutsummaryrefslogtreecommitdiff
path: root/server/store/migrations/mysql/20180807224200_new_primary_key.sql
blob: ed6a3c261b34f9d7e40f770de682cdc62c089f3b (plain)
1
2
3
4
5
6
7
8
9
10
11
-- +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`);