lucifer
/
new-server
2
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
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.
93 Commits
3 Branches
21 Tags
2.3 MiB
Branch: asmodeus
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'asmodeus'
${ noResults }
new-server/scripts/20210918105052_device_tag.sql

16 lines
330 B
Raw Permalink Normal View History

small fixed, device repo and some device api
3 years ago
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
  1. -- +goose Up
  2. -- +goose StatementBegin
  3. CREATE TABLE device_tag
  4. (
  5. device_id INT NOT NULL,
  6. tag_name VARCHAR(255) NOT NULL,
  8. PRIMARY KEY (device_id, tag_name),
  9. INDEX (tag_name)
  10. );
  11. -- +goose StatementEnd
  13. -- +goose Down
  14. -- +goose StatementBegin
  15. DROP TABLE device_tag;
  16. -- +goose StatementEnd