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

     1  -- +goose Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  CREATE TABLE IF NOT EXISTS notification_time_span (
     4      `user_id` int unsigned NOT NULL,
     5      `number` tinyint unsigned NOT NULL,
     6      `from_time` time NOT NULL,
     7      `to_time` time NOT NULL,
     8      `created_at` DATETIME NOT NULL,
     9      PRIMARY KEY (`user_id`, `number`)
    10  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
    11  
    12  
    13  -- +goose Down
    14  -- SQL section 'Down' is executed when this migration is rolled back
    15  DROP TABLE notification_time_span;