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

     1  -- +migrate Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  
     4  ALTER TABLE `registrations`
     5  DROP COLUMN `initialIP`,
     6  DROP KEY `initialIP_createdAt`;
     7  
     8  -- +migrate Down
     9  -- SQL section 'Down' is executed when this migration is rolled back
    10  
    11  ALTER TABLE `registrations`
    12  ADD COLUMN `initialIP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
    13  ADD KEY `initialIP_createdAt` (`initialIP`, `createdAt`);