diff options
author | Masaya Tojo <masaya@tojo.tokyo> | 2023-02-28 00:52:10 +0900 |
---|---|---|
committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-01 02:28:55 +0900 |
commit | b7b17d87df7e70d6774e40b864227fc3ddce4686 (patch) | |
tree | 43edf499efaf772727987d209302b9120c7a994d /deploy | |
parent | acf7f9ecff4ddad620b85b07b4b4e6952946b385 (diff) |
Add transaction type.
Diffstat (limited to 'deploy')
-rw-r--r-- | deploy/transaction_type.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/deploy/transaction_type.sql b/deploy/transaction_type.sql new file mode 100644 index 0000000..b29421f --- /dev/null +++ b/deploy/transaction_type.sql @@ -0,0 +1,11 @@ +-- Deploy kakeibo:transaction_type to pg +-- requires: appschema + +BEGIN; + +CREATE TYPE kakeibo.transaction_type AS ENUM( + 'income', + 'outgo' +); + +COMMIT; |