diff options
Diffstat (limited to 'verify/transactions.sql')
-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; |