deploy/transactions_article_id.sql


1
2
3
4
5
6
7
8
9
10
11

-- Deploy kakeibo:transactions_article_id to pg
-- requires: transactions
-- requires: articles

BEGIN;

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

COMMIT;