diff options
| author | Niall Sheridan <nsheridan@gmail.com> | 2017-01-20 00:52:56 +0000 |
|---|---|---|
| committer | Niall Sheridan <nsheridan@gmail.com> | 2017-01-22 22:25:35 +0000 |
| commit | 51cc4c07b2a2b6345b1496baac865f5faf955e7d (patch) | |
| tree | edd51d045954eb802c470be4481a1d130d5f988c /db | |
| parent | fb4a1232be3b2d00483a7399e7131c211d8cd551 (diff) | |
Switch from database/sql to sqlx
Diffstat (limited to 'db')
| -rw-r--r-- | db/seed.sql | 8 |
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`) ); |