Text file src/github.com/letsencrypt/boulder/sa/db/boulder_sa/20230519000000_CrlShards.sql

Documentation: github.com/letsencrypt/boulder/sa/db/boulder_sa

     1-- +migrate Up
     2-- SQL in section 'Up' is executed when this migration is applied
     3
     4CREATE 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,
     9  `nextUpdate` datetime,
    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
    18DROP TABLE `crlShards`;

View as plain text