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

     1  -- +migrate Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  
     4  CREATE TABLE `replacementOrders` (
     5    `id` bigint(20) NOT NULL AUTO_INCREMENT,
     6    `serial` varchar(255) NOT NULL,
     7    `orderID` bigint(20) NOT NULL,
     8    `orderExpires` datetime NOT NULL,
     9    `replaced` boolean DEFAULT false,
    10    PRIMARY KEY (`id`),
    11    KEY `serial_idx` (`serial`),
    12    KEY `orderID_idx` (`orderID`)
    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 `replacementOrders`;