new-server/scripts/20210522140147_device_property.sql

-- +goose Up
-- +goose StatementBegin
CREATE TABLE device_property
(
    device_id  INT          NOT NULL,
    prop_key   VARCHAR(255) NOT NULL,
    prop_value VARCHAR(255) NOT NULL,
    is_user    TINYINT      NOT NULL DEFAULT 0,

    PRIMARY KEY (device_id, prop_key)
);
-- +goose StatementEnd

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