You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

21 lines
544 B

4 years ago
4 years ago
4 years ago
  1. -- +goose Up
  2. -- +goose StatementBegin
  3. CREATE TABLE device
  4. (
  5. id INT NOT NULL AUTO_INCREMENT,
  6. bridge_id INT NOT NULL,
  7. internal_id VARCHAR(255) NOT NULL,
  8. icon VARCHAR(255) NOT NULL,
  9. name VARCHAR(255) NOT NULL,
  10. capabilities VARCHAR(255) NOT NULL,
  11. button_names VARCHAR(255) NOT NULL,
  12. PRIMARY KEY (id),
  13. UNIQUE (bridge_id, internal_id)
  14. );
  15. -- +goose StatementEnd
  16. -- +goose Down
  17. -- +goose StatementBegin
  18. DROP TABLE device;
  19. -- +goose StatementEnd