github.com/letsencrypt/boulder@v0.20251208.0/sa/db/incidents_sa/20220328100000_Incidents.sql (about)

     1  -- +migrate Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  
     4  CREATE 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  
    14  CREATE 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  
    27  DROP TABLE `incident_foo`;
    28  DROP TABLE `incident_bar`;