blob: d95fbf5632e761008ef66b0f35ebb96c93d86017 (
about) (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
-- 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;
|