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

     1  -- +migrate Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  
     4  CREATE TABLE `crlShards` (
     5    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
     6    `issuerID` bigint(20) NOT NULL,
     7    `idx` int UNSIGNED NOT NULL,
     8    `thisUpdate` datetime DEFAULT NULL,
     9    `nextUpdate` datetime DEFAULT NULL,
    10    `leasedUntil` datetime NOT NULL,
    11    PRIMARY KEY (`id`),
    12    UNIQUE KEY `shardID` (`issuerID`, `idx`)
    13  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    14  
    15  -- +migrate Down
    16  -- SQL section 'Down' is executed when this migration is rolled back
    17  
    18  DROP TABLE `crlShards`;