github.com/icyphox/x@v0.0.355-0.20220311094250-029bd783e8b8/popx/stub/migrations/legacy/20200831110752_identity_verifiable_address_remove_code.mysql.down.sql (about)

     1  ALTER TABLE `identity_verifiable_addresses` ADD COLUMN `code` VARCHAR (32);
     2  ALTER TABLE `identity_verifiable_addresses` ADD COLUMN `expires_at` DATETIME;
     3  UPDATE identity_verifiable_addresses SET code = LEFT(MD5(RAND()), 32) WHERE code IS NULL;
     4  UPDATE identity_verifiable_addresses SET expires_at = CURRENT_TIMESTAMP WHERE expires_at IS NULL;
     5  ALTER TABLE `identity_verifiable_addresses` MODIFY `code` VARCHAR (32) NOT NULL;
     6  ALTER TABLE `identity_verifiable_addresses` MODIFY `expires_at` DATETIME;
     7  CREATE UNIQUE INDEX `identity_verifiable_addresses_code_uq_idx` ON `identity_verifiable_addresses` (`code`);
     8  CREATE INDEX `identity_verifiable_addresses_code_idx` ON `identity_verifiable_addresses` (`code`);