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

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