-- Deploy kakeibo:items to pg
-- requires: schema
-- requires: transactions
-- requires: articles

BEGIN;

ALTER TABLE kakeibo.items
  ADD COLUMN article_id INTEGER,
  ADD CONSTRAINT transactions_article_id_fkey
  FOREIGN KEY (article_id) REFERENCES kakeibo.articles (id);

COMMIT;