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

     1  -- +migrate Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  
     4  -- This table has no auto-incrementing primary key because we don't plan to
     5  -- partition it. This table expected to be < 800K rows initially and grow at a
     6  -- rate of ~18% per year.
     7  
     8  CREATE TABLE `paused` (
     9    `registrationID` bigint(20) UNSIGNED NOT NULL,
    10    `identifierType` tinyint(4) NOT NULL,
    11    `identifierValue` varchar(255) NOT NULL,
    12    `pausedAt` datetime NOT NULL,
    13    `unpausedAt` datetime DEFAULT NULL,
    14    PRIMARY KEY (`registrationID`, `identifierValue`, `identifierType`)
    15  );
    16  
    17  -- +migrate Down
    18  -- SQL section 'Down' is executed when this migration is rolled back
    19  
    20  DROP TABLE `paused`;