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

     1  -- +goose Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  CREATE TABLE stat_notifier (
     4    `datetime` datetime NOT NULL,
     5    `interval` tinyint(3) unsigned NOT NULL,
     6    `elapsed` int(10) unsigned NOT NULL,
     7    `user_count` int(10) unsigned NOT NULL,
     8    `followed_teacher_count` int(10) unsigned NOT NULL,
     9    PRIMARY KEY (`datetime`, `interval`)
    10  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
    11  
    12  -- +goose Down
    13  -- SQL section 'Down' is executed when this migration is rolled back
    14  DROP TABLE stat_notifier;