github.com/letsencrypt/boulder@v0.20251208.0/sa/db-next/boulder_sa/20240503000000_RemoveRequestedNames.sql (about)

     1  -- +migrate Up
     2  
     3  DROP TABLE requestedNames;
     4  
     5  -- +migrate Down
     6  
     7  DROP TABLE requestedNames;
     8  
     9  CREATE TABLE `requestedNames` (
    10    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    11    `orderID` bigint(20) NOT NULL,
    12    `reversedName` varchar(253) CHARACTER SET ascii NOT NULL,
    13    PRIMARY KEY (`id`),
    14    KEY `orderID_idx` (`orderID`),
    15    KEY `reversedName_idx` (`reversedName`)
    16  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;