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

     1  -- +goose Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  ALTER TABLE event_log_email MODIFY COLUMN
     4    event ENUM('click', 'delivered', 'open', 'deferred', 'dropped', 'bounce', 'block') NOT NULL;
     5  
     6  UPDATE event_log_email SET event = 'dropped' WHERE event = '';
     7  
     8  -- +goose Down
     9  -- SQL section 'Down' is executed when this migration is rolled back
    10  ALTER TABLE event_log_email MODIFY COLUMN
    11    event ENUM('click', 'delivered', 'open', 'deferred', 'drop', 'bounce', 'block') NOT NULL;