1-- +migrate Up
2-- SQL in section 'Up' is executed when this migration is applied
3
4CREATE 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 PARTITION BY RANGE(id)
16(PARTITION p_start VALUES LESS THAN (MAXVALUE));
17
18-- +migrate Down
19-- SQL section 'Down' is executed when this migration is rolled back
20
21DROP TABLE `revokedCertificates`;
View as plain text