diff options
author | Masaya Tojo <masaya@tojo.tokyo> | 2023-08-31 00:35:36 +0900 |
---|---|---|
committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-10-13 02:13:22 +0900 |
commit | e3131b37eb7d9b6284a68077a9f0d5ad9dc99f98 (patch) | |
tree | 16bb962bbbe566b24e985c4886570d498a62c009 /verify | |
parent | 67cabf314b2b60c81454682f9259c3c207f71a73 (diff) |
Add table to manage transactions
Diffstat (limited to 'verify')
-rw-r--r-- | verify/transactions.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/verify/transactions.sql b/verify/transactions.sql new file mode 100644 index 0000000..1a01f6f --- /dev/null +++ b/verify/transactions.sql @@ -0,0 +1,11 @@ +-- Verify photos:transactions on pg + +BEGIN; + +SET search_path to photos; + +SELECT id, photo_id, is_income, category, amount, note, created_at, updated_at + FROM transactions + WHERE FALSE; + +ROLLBACK; |