diff options
author | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-12 15:46:32 +0900 |
---|---|---|
committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-12 23:38:12 +0900 |
commit | cd23d52c0c5c3d3264c5a8706c2c6fe2b1649640 (patch) | |
tree | ec38121810fb9edd839dd25812a1f46c213213fd /verify | |
parent | 55618dcd6a40c0b85612a20994114a18987ff43d (diff) |
Add table for tracking items.
Diffstat (limited to 'verify')
-rw-r--r-- | verify/items.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/verify/items.sql b/verify/items.sql new file mode 100644 index 0000000..9a561cf --- /dev/null +++ b/verify/items.sql @@ -0,0 +1,16 @@ +-- Verify kakeibo:items on pg + +BEGIN; + +SELECT id, + transaction_id, + category, + subcategory, + amount, + note, + created_at, + updated_at + FROM kakeibo.items + WHERE FALSE; + +ROLLBACK; |