diff options
author | Niall Sheridan <nsheridan@gmail.com> | 2018-08-05 23:40:27 +0100 |
---|---|---|
committer | Niall Sheridan <nsheridan@gmail.com> | 2018-08-07 15:43:39 +0100 |
commit | 162efe8828ce1c2828206e5050a2c0c175265d70 (patch) | |
tree | 837b08d75b45a9d9e613182f76b2b71b27cf3ac6 /db | |
parent | d836a4496de7b24a9d3317e274800d35053a04f6 (diff) |
Remove obsolete db seed script
Diffstat (limited to 'db')
-rw-r--r-- | db/seed.sql | 15 |
1 files changed, 0 insertions, 15 deletions
diff --git a/db/seed.sql b/db/seed.sql deleted file mode 100644 index 03f7b1e..0000000 --- a/db/seed.sql +++ /dev/null @@ -1,15 +0,0 @@ -CREATE DATABASE IF NOT EXISTS `certs`; - -USE `certs`; - -CREATE TABLE `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`); |