diff options
| author | Ben Burwell <ben@benburwell.com> | 2020-04-13 23:57:13 -0400 |
|---|---|---|
| committer | Ben Burwell <ben@benburwell.com> | 2020-04-13 23:57:13 -0400 |
| commit | 2ce3b86e0ff69538935db3149d1ed2f24aea09a3 (patch) | |
| tree | 1c0329a5c1191690e57e7160bd3150c9a2851866 /server/store/migrations/sqlite3/20180626224600_create_issued_certs.sql | |
| parent | 8b1ee3e95010681d98d1b31af98f0ce0832cedd2 (diff) | |
Simplify
Diffstat (limited to 'server/store/migrations/sqlite3/20180626224600_create_issued_certs.sql')
| -rw-r--r-- | server/store/migrations/sqlite3/20180626224600_create_issued_certs.sql | 15 |
1 files changed, 0 insertions, 15 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`; |