aboutsummaryrefslogtreecommitdiff
path: root/db/seed.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/seed.sql')
-rw-r--r--db/seed.sql15
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`);