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

     1  -- +migrate Up
     2  
     3  DROP TABLE certificatesPerName;
     4  DROP TABLE newOrdersRL;
     5  
     6  -- +migrate Down
     7  
     8  DROP TABLE certificatesPerName;
     9  DROP TABLE newOrdersRL;
    10  
    11  CREATE TABLE `certificatesPerName` (
    12    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    13    `eTLDPlusOne` varchar(255) NOT NULL,
    14    `time` datetime NOT NULL,
    15    `count` int(11) NOT NULL,
    16    PRIMARY KEY (`id`),
    17    UNIQUE KEY `eTLDPlusOne_time_idx` (`eTLDPlusOne`,`time`)
    18  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    19  
    20  CREATE TABLE `newOrdersRL` (
    21    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    22    `regID` bigint(20) NOT NULL,
    23    `time` datetime NOT NULL,
    24    `count` int(11) NOT NULL,
    25    PRIMARY KEY (`id`),
    26    UNIQUE KEY `regID_time_idx` (`regID`,`time`)
    27  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;