github.com/oinume/lekcije@v0.0.0-20231017100347-5b4c5eb6ab24/backend/db/migrations/20160909225400_add_email_verified.sql (about)

     1  -- +goose Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  ALTER TABLE user ADD COLUMN `email_verified` tinyint(1) unsigned NOT NULL DEFAULT 0 AFTER `email`;
     4  
     5  -- +goose Down
     6  -- SQL section 'Down' is executed when this migration is rolled back
     7  ALTER TABLE user DROP COLUMN `email_verified`;