-- +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