aboutsummaryrefslogtreecommitdiff
path: root/db/seed.sql
blob: 7c438fd865b729a92bba971eb580c5ac8cf9f1d7 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
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`)
);