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

     1  -- +goose Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  CREATE TABLE IF NOT EXISTS stat_new_lesson_notifier (
     4      `date` date NOT NULL,
     5      `event` enum('click','delivered','open','deferred','dropped','bounce','block') NOT NULL,
     6      `count` int unsigned NOT NULL,
     7      `uu_count` int unsigned NOT NULL,
     8      PRIMARY KEY (`date`, `event`)
     9  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
    10  
    11  
    12  -- +goose Down
    13  -- SQL section 'Down' is executed when this migration is rolled back
    14  DROP TABLE stat_new_lesson_notifier;