github.com/ztalab/ZACA@v0.0.1/database/mysql/migrations/001_certs.up.sql (about)

     1  CREATE TABLE IF NOT EXISTS `certificates` (
     2    `serial_number` varchar(128) NOT NULL,
     3    `authority_key_identifier` varchar(128) NOT NULL,
     4    `ca_label` varchar(128) DEFAULT NULL,
     5    `status` varchar(128) NOT NULL,
     6    `reason` int(11) DEFAULT NULL,
     7    `expiry` timestamp NULL DEFAULT NULL,
     8    `revoked_at` timestamp NULL DEFAULT NULL,
     9    `pem` text NOT NULL,
    10    `issued_at` timestamp NULL DEFAULT NULL,
    11    `not_before` timestamp NULL DEFAULT NULL,
    12    `metadata` json DEFAULT NULL,
    13    `sans` json DEFAULT NULL,
    14    `common_name` text,
    15    PRIMARY KEY (`serial_number`,`authority_key_identifier`)
    16  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;