aboutsummaryrefslogtreecommitdiff
path: root/deploy/transaction_type@v1.0.0-dev1.sql
diff options
context:
space:
mode:
authorMasaya Tojo <masaya@tojo.tokyo>2023-03-04 20:21:24 +0900
committerMasaya Tojo <masaya@tojo.tokyo>2023-03-04 20:21:24 +0900
commit69ac90518f003895b8ffb6618b84b91ff4256308 (patch)
treea81c9562b8390afe2f0e5cebf06d019ab44e86ec /deploy/transaction_type@v1.0.0-dev1.sql
parent85aa0f7fa89cad0cd81af87336d7f9d31bb19422 (diff)
Drop transaction_type.
Diffstat (limited to 'deploy/transaction_type@v1.0.0-dev1.sql')
-rw-r--r--deploy/transaction_type@v1.0.0-dev1.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/deploy/transaction_type@v1.0.0-dev1.sql b/deploy/transaction_type@v1.0.0-dev1.sql
new file mode 100644
index 0000000..b29421f
--- /dev/null
+++ b/deploy/transaction_type@v1.0.0-dev1.sql
@@ -0,0 +1,11 @@
+-- Deploy kakeibo:transaction_type to pg
+-- requires: appschema
+
+BEGIN;
+
+CREATE TYPE kakeibo.transaction_type AS ENUM(
+ 'income',
+ 'outgo'
+);
+
+COMMIT;