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

     1  -- +migrate Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  
     4  DROP TABLE orderToAuthz2;
     5  CREATE TABLE `orderToAuthz2` (
     6    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
     7    `orderID` bigint(20) UNSIGNED NOT NULL,
     8    `authzID` bigint(20) UNSIGNED NOT NULL,
     9    PRIMARY KEY (`id`),
    10    KEY `orderID_idx` (`orderID`),
    11    KEY `authzID_idx` (`authzID`)
    12  ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;
    13  
    14  -- +migrate Down
    15  -- SQL section 'Down' is executed when this migration is rolled back
    16  
    17  DROP TABLE orderToAuthz2;
    18  CREATE TABLE `orderToAuthz2` (
    19    `orderID` bigint(20) NOT NULL,
    20    `authzID` bigint(20) NOT NULL,
    21    PRIMARY KEY (`orderID`,`authzID`),
    22    KEY `authzID` (`authzID`)
    23  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;