aboutsummaryrefslogtreecommitdiff
path: root/deploy/items.sql
diff options
context:
space:
mode:
authorMasaya Tojo <masaya@tojo.tokyo>2023-03-28 01:29:08 +0900
committerMasaya Tojo <masaya@tojo.tokyo>2023-03-28 01:29:08 +0900
commit70304b1903cc5b1accd9caea229e59901384203a (patch)
tree0068f30d93a328799898a6773828032fe7e1c843 /deploy/items.sql
parent37db03353a121d039a98af49aa034fb2d8f6e6ea (diff)
Add `kakeibo.` prefix.
Diffstat (limited to 'deploy/items.sql')
-rw-r--r--deploy/items.sql13
1 files changed, 0 insertions, 13 deletions
diff --git a/deploy/items.sql b/deploy/items.sql
deleted file mode 100644
index d95fbf5..0000000
--- a/deploy/items.sql
+++ /dev/null
@@ -1,13 +0,0 @@
--- 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;