diff options
Diffstat (limited to 'server/store/migrations/sqlite3')
4 files changed, 0 insertions, 70 deletions
diff --git a/server/store/migrations/sqlite3/20180626224600_create_issued_certs.sql b/server/store/migrations/sqlite3/20180626224600_create_issued_certs.sql deleted file mode 100644 index c5b80e0..0000000 --- a/server/store/migrations/sqlite3/20180626224600_create_issued_certs.sql +++ /dev/null @@ -1,15 +0,0 @@ --- +migrate Up -CREATE TABLE IF NOT EXISTS `issued_certs` ( - `key_id` varchar(255) NOT NULL, - `principals` varchar(255) DEFAULT "[]", - `created_at` datetime DEFAULT '1970-01-01 00:00:01', - `expires_at` datetime DEFAULT '1970-01-01 00:00:01', - `revoked` tinyint(1) DEFAULT 0, - `raw_key` text, - PRIMARY KEY (`key_id`) -); -CREATE INDEX `idx_expires_at` ON `issued_certs` (`expires_at`); -CREATE INDEX `idx_revoked_expires_at` ON `issued_certs` (`revoked`, `expires_at`); - --- +migrate Down -DROP TABLE `issued_certs`; diff --git a/server/store/migrations/sqlite3/20180807223808_idx_revoked_expires_at.sql b/server/store/migrations/sqlite3/20180807223808_idx_revoked_expires_at.sql deleted file mode 100644 index ae9ca3d..0000000 --- a/server/store/migrations/sqlite3/20180807223808_idx_revoked_expires_at.sql +++ /dev/null @@ -1,5 +0,0 @@ --- +migrate Up -DROP INDEX `idx_revoked_expires_at`; - --- +migrate Down -CREATE INDEX `idx_revoked_expires_at` ON `issued_certs` (`revoked`, `expires_at`); diff --git a/server/store/migrations/sqlite3/20180807224200_new_primary_key.sql b/server/store/migrations/sqlite3/20180807224200_new_primary_key.sql deleted file mode 100644 index 40f333c..0000000 --- a/server/store/migrations/sqlite3/20180807224200_new_primary_key.sql +++ /dev/null @@ -1,32 +0,0 @@ --- +migrate Up -CREATE TABLE `issued_certs_new` ( - `id` INTEGER PRIMARY KEY, - `key_id` varchar(255) UNIQUE NOT NULL, - `principals` varchar(255) DEFAULT '[]', - `created_at` datetime DEFAULT '1970-01-01 00:00:01', - `expires_at` datetime DEFAULT '1970-01-01 00:00:01', - `revoked` tinyint(1) DEFAULT '0', - `raw_key` text -); -INSERT INTO `issued_certs_new` (key_id, principals, created_at, expires_at, revoked, raw_key) - SELECT key_id, principals, created_at, expires_at, revoked, raw_key FROM `issued_certs`; -DROP TABLE `issued_certs`; -ALTER TABLE `issued_certs_new` RENAME TO `issued_certs`; -CREATE INDEX `idx_expires_at` ON `issued_certs` (`expires_at`); - --- +migrate Down -CREATE TABLE IF NOT EXISTS `issued_certs_old` ( - `key_id` varchar(255) NOT NULL, - `principals` varchar(255) DEFAULT "[]", - `created_at` datetime DEFAULT '1970-01-01 00:00:01', - `expires_at` datetime DEFAULT '1970-01-01 00:00:01', - `revoked` tinyint(1) DEFAULT 0, - `raw_key` text, - PRIMARY KEY (`key_id`) -); - -INSERT INTO `issued_certs_old` (key_id, principals, created_at, expires_at, revoked, raw_key) - SELECT key_id, principals, created_at, expires_at, revoked, raw_key FROM `issued_certs`; -DROP TABLE `issued_certs`; -ALTER TABLE `issued_certs_old` RENAME TO `issued_certs`; -CREATE INDEX `idx_expires_at` ON `issued_certs` (`expires_at`);
\ No newline at end of file diff --git a/server/store/migrations/sqlite3/20180822204521_add_reason.sql b/server/store/migrations/sqlite3/20180822204521_add_reason.sql deleted file mode 100644 index 07e9d49..0000000 --- a/server/store/migrations/sqlite3/20180822204521_add_reason.sql +++ /dev/null @@ -1,18 +0,0 @@ --- +migrate Up -ALTER TABLE `issued_certs` ADD COLUMN `message` TEXT NOT NULL DEFAULT ""; - --- +migrate Down -CREATE TABLE `issued_certs_new` ( - `id` INTEGER PRIMARY KEY, - `key_id` varchar(255) UNIQUE NOT NULL, - `principals` varchar(255) DEFAULT '[]', - `created_at` datetime DEFAULT '1970-01-01 00:00:01', - `expires_at` datetime DEFAULT '1970-01-01 00:00:01', - `revoked` tinyint(1) DEFAULT '0', - `raw_key` text -); -INSERT INTO `issued_certs_new` (key_id, principals, created_at, expires_at, revoked, raw_key) - SELECT key_id, principals, created_at, expires_at, revoked, raw_key FROM `issued_certs`; -DROP TABLE `issued_certs`; -ALTER TABLE `issued_certs_new` RENAME TO `issued_certs`; -CREATE INDEX `idx_expires_at` ON `issued_certs` (`expires_at`);
\ No newline at end of file |