diff options
author | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-13 00:23:26 +0900 |
---|---|---|
committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-14 09:09:58 +0900 |
commit | f011f99514c304521e14eb00b2c6e6d4b2c3dd11 (patch) | |
tree | c62fecf1393cd9b8525e2cbffd70e5fca0f0834d /deploy | |
parent | 16b03189283eeb212499681d9de5bc054346b184 (diff) |
Add table to manage transaction type codes.
Diffstat (limited to 'deploy')
-rw-r--r-- | deploy/transaction_types.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/deploy/transaction_types.sql b/deploy/transaction_types.sql new file mode 100644 index 0000000..cf07925 --- /dev/null +++ b/deploy/transaction_types.sql @@ -0,0 +1,12 @@ +-- Deploy kakeibo:transaction_types to pg +-- requires: schema + +BEGIN; + +CREATE TABLE kakeibo.transaction_types ( + code INTEGER PRIMARY KEY, + name TEXT NOT NULL +); +INSERT INTO kakeibo.transaction_types VALUES (0, 'outgo'), (1, 'income'); + +COMMIT; |