github.com/letsencrypt/boulder@v0.20251208.0/sa/db/boulder_sa/20230919000000_RevokedCertificates.sql (about)

     1  -- +migrate Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  
     4  CREATE TABLE `revokedCertificates` (
     5    `id` bigint(20) NOT NULL AUTO_INCREMENT,
     6    `issuerID` bigint(20) NOT NULL,
     7    `serial` varchar(255) NOT NULL,
     8    `notAfterHour` datetime NOT NULL,
     9    `shardIdx` bigint(20) NOT NULL,
    10    `revokedDate` datetime NOT NULL,
    11    `revokedReason` int(11) NOT NULL,
    12    PRIMARY KEY (`id`),
    13    KEY `issuerID_shardIdx_notAfterHour_idx` (`issuerID`, `shardIdx`, `notAfterHour`)
    14  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    15  
    16  -- +migrate Down
    17  -- SQL section 'Down' is executed when this migration is rolled back
    18  
    19  DROP TABLE `revokedCertificates`;