new-server/scripts/20210926135923_scene.sql

-- +goose Up
-- +goose StatementBegin
CREATE TABLE scene
(
    id          INT          NOT NULL AUTO_INCREMENT,
    name        VARCHAR(255) NOT NULL,
    interval_ms INT          NOT NULL,
    roles       JSON         NOT NULL,

    PRIMARY KEY (id)
);
-- +goose StatementEnd

-- +goose Down
-- +goose StatementBegin
DROP TABLE scene;
-- +goose StatementEnd