aboutsummaryrefslogtreecommitdiff
path: root/deploy/transactions_type_code.sql
diff options
context:
space:
mode:
Diffstat (limited to 'deploy/transactions_type_code.sql')
-rw-r--r--deploy/transactions_type_code.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/deploy/transactions_type_code.sql b/deploy/transactions_type_code.sql
new file mode 100644
index 0000000..5c29ec9
--- /dev/null
+++ b/deploy/transactions_type_code.sql
@@ -0,0 +1,8 @@
+-- Deploy kakeibo:transactions_type_code to pg
+-- requires: transactions
+
+BEGIN;
+
+ALTER TABLE kakeibo.transactions RENAME COLUMN type to type_code;
+
+COMMIT;