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

     1  -- +goose Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  CREATE TABLE IF NOT EXISTS flash_message (
     4      `id` varchar(255) NOT NULL,
     5      `value` JSON NOT NULL,
     6      `expired_at` DATETIME NOT NULL,
     7      PRIMARY KEY (`id`)
     8  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
     9  
    10  -- +goose Down
    11  -- SQL section 'Down' is executed when this migration is rolled back
    12  DROP TABLE flash_message;