Text file src/github.com/letsencrypt/boulder/sa/db/incidents_sa/20220328100000_Incidents.sql

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

     1-- +migrate Up
     2-- SQL in section 'Up' is executed when this migration is applied
     3
     4CREATE TABLE `incident_foo` (
     5    `serial` varchar(255) NOT NULL,
     6    `registrationID` bigint(20) unsigned NULL,
     7    `orderID` bigint(20) unsigned NULL,
     8    `lastNoticeSent` datetime NULL,
     9    PRIMARY KEY (`serial`),
    10    KEY `registrationID_idx` (`registrationID`),
    11    KEY `orderID_idx` (`orderID`)
    12) CHARSET=utf8mb4;
    13
    14CREATE TABLE `incident_bar` (
    15    `serial` varchar(255) NOT NULL,
    16    `registrationID` bigint(20) unsigned NULL,
    17    `orderID` bigint(20) unsigned NULL,
    18    `lastNoticeSent` datetime NULL,
    19    PRIMARY KEY (`serial`),
    20    KEY `registrationID_idx` (`registrationID`),
    21    KEY `orderID_idx` (`orderID`)
    22) CHARSET=utf8mb4;
    23
    24-- +migrate Down
    25-- SQL section 'Down' is executed when this migration is rolled back
    26
    27DROP TABLE `incident_foo`;
    28DROP TABLE `incident_bar`;

View as plain text