new-server/scripts/20210522140146_device.sql

-- +goose Up
-- +goose StatementBegin
CREATE TABLE device
(
    id           INT          NOT NULL AUTO_INCREMENT,
    bridge_id    INT          NOT NULL,
    internal_id  VARCHAR(255) NOT NULL,
    icon         VARCHAR(255) NOT NULL,
    name         VARCHAR(255) NOT NULL,
    capabilities VARCHAR(255) NOT NULL,
    button_names VARCHAR(255) NOT NULL,

    PRIMARY KEY (id),
    UNIQUE (bridge_id, internal_id)
);
-- +goose StatementEnd

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