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

     1  -- +goose Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  ALTER TABLE lesson
     4    ADD COLUMN `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT FIRST
     5    , DROP PRIMARY KEY
     6    , ADD PRIMARY KEY (id)
     7    , ADD UNIQUE KEY `teacher_id-datetime` (`teacher_id`, `datetime`)
     8  ;
     9  
    10  CREATE TABLE lesson_status_log (
    11      `lesson_id` BIGINT UNSIGNED NOT NULL,
    12      `status` enum('finished','reserved','available','cancelled') COLLATE utf8mb4_bin NOT NULL,
    13      `created_at` DATETIME NOT NULL
    14  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
    15  
    16  -- +goose Down
    17  -- SQL section 'Down' is executed when this migration is rolled back
    18  DROP TABLE lesson_status_log;
    19  ALTER TABLE `lesson`
    20    DROP PRIMARY KEY
    21    , ADD PRIMARY KEY `teacher_id-datetime` (`teacher_id`, `datetime`)
    22    , DROP COLUMN `id`
    23    , DROP KEY `teacher_id-datetime`
    24  ;