From b7b17d87df7e70d6774e40b864227fc3ddce4686 Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Tue, 28 Feb 2023 00:52:10 +0900 Subject: Add transaction type. --- deploy/transaction_type.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 deploy/transaction_type.sql (limited to 'deploy') 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; -- cgit v1.2.3