aboutsummaryrefslogtreecommitdiff
path: root/db/seed.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/seed.sql')
-rw-r--r--db/seed.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/db/seed.sql b/db/seed.sql
index cf5e62a..7c438fd 100644
--- a/db/seed.sql
+++ b/db/seed.sql
@@ -4,10 +4,10 @@ USE `certs`;
CREATE TABLE `issued_certs` (
`key_id` varchar(255) NOT NULL,
- `principals` varchar(255) DEFAULT NULL,
- `created_at` datetime DEFAULT NULL,
- `expires_at` datetime DEFAULT NULL,
- `revoked` tinyint(1) DEFAULT 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`)
);