stufflog graphql server
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.

18 lines
390 B

4 years ago
  1. -- +goose Up
  2. -- +goose StatementBegin
  3. CREATE TABLE log_item (
  4. log_id CHAR(24) NOT NULL,
  5. issue_id CHAR(32) NOT NULL,
  6. issue_item_id CHAR(48) NOT NULL,
  7. amount INTEGER NOT NULL,
  8. PRIMARY KEY(log_id, issue_item_id),
  9. INDEX (issue_item_id),
  10. INDEX (issue_id)
  11. );
  12. -- +goose StatementEnd
  13. -- +goose Down
  14. -- +goose StatementBegin
  15. DROP TABLE log_item;
  16. -- +goose StatementEnd