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;