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

-- +goose Up
-- +goose StatementBegin
CREATE TABLE log_item (
log_id CHAR(24) NOT NULL,
issue_id CHAR(32) NOT NULL,
issue_item_id CHAR(48) NOT NULL,
amount INTEGER NOT NULL,
PRIMARY KEY(log_id, issue_item_id),
INDEX (issue_item_id),
INDEX (issue_id)
);
-- +goose StatementEnd
-- +goose Down
-- +goose StatementBegin
DROP TABLE log_item;
-- +goose StatementEnd