aboutsummaryrefslogtreecommitdiff
path: root/deploy/kakeibo.transactions.sql
diff options
context:
space:
mode:
Diffstat (limited to 'deploy/kakeibo.transactions.sql')
-rw-r--r--deploy/kakeibo.transactions.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/deploy/kakeibo.transactions.sql b/deploy/kakeibo.transactions.sql
new file mode 100644
index 0000000..3a4585a
--- /dev/null
+++ b/deploy/kakeibo.transactions.sql
@@ -0,0 +1,12 @@
+-- Deploy kakeibo:transactions to pg
+-- requires: schema
+-- requires: articles
+
+BEGIN;
+
+ALTER TABLE kakeibo.transactions
+ ADD CONSTRAINT transactions_type_code_fkey
+ FOREIGN KEY (type_code)
+ REFERENCES kakeibo.transaction_types (code);
+
+COMMIT;