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

     1  -- +migrate Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  
     4  CREATE TABLE overrides (
     5     `limitEnum` tinyint(4) UNSIGNED NOT NULL,
     6     `bucketKey` varchar(255) NOT NULL,
     7     `comment`   varchar(255) NOT NULL,
     8     `periodNS`  bigint(20) UNSIGNED NOT NULL,
     9     `count`     int UNSIGNED NOT NULL,
    10     `burst`     int UNSIGNED NOT NULL,
    11     `updatedAt` datetime NOT NULL,
    12     `enabled`   boolean NOT NULL DEFAULT false,
    13    UNIQUE KEY `limitEnum_bucketKey` (`limitEnum`, `bucketKey`),
    14    INDEX idx_enabled (enabled)
    15  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    16  
    17  -- +migrate Down
    18  -- SQL section 'Down' is executed when this migration is rolled back
    19  
    20  DROP TABLE IF EXISTS overrides;