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

     1  -- +goose Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  CREATE TABLE IF NOT EXISTS event_log_email (
     4    datetime DATETIME NOT NULL,
     5    event ENUM('click', 'delivered', 'open', 'deferred', 'drop', 'bounce', 'block') NOT NULL,
     6    email_type ENUM('new_lesson_notifier', 'follow_reminder') NOT NULL,
     7    user_id int(10) unsigned NOT NULL,
     8    user_agent VARCHAR(255) NOT NULL DEFAULT '',
     9    teacher_ids TEXT NOT NULL,
    10    url VARCHAR(255) NOT NULL DEFAULT '',
    11    KEY (`datetime`, `event`),
    12    KEY (`user_id`)
    13  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;
    14  
    15  -- +goose Down
    16  -- SQL section 'Down' is executed when this migration is rolled back
    17  DROP TABLE IF EXISTS event_log_email;