summaryrefslogtreecommitdiff
path: root/verify
diff options
context:
space:
mode:
authorMasaya Tojo <masaya@tojo.tokyo>2023-08-30 00:30:15 +0900
committerMasaya Tojo <masaya@tojo.tokyo>2023-10-13 02:12:52 +0900
commitccc4cc4bab2377fc92fa6959d761885bebaaa0e0 (patch)
tree0cb24a6a1d56e699dc10bdfdbc202ec75bae2115 /verify
parentb6d633011163002c2923f3809cd5ead2c53e2aa3 (diff)
Add note column to photos table
Diffstat (limited to 'verify')
-rw-r--r--verify/photos.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/verify/photos.sql b/verify/photos.sql
index b082730..220dc72 100644
--- a/verify/photos.sql
+++ b/verify/photos.sql
@@ -4,7 +4,7 @@ BEGIN;
SET search_path to photos;
-SELECT id, path, is_receipt, taken_at, camera_name, created_at, updated_at
+SELECT id, path, is_receipt, note, taken_at, camera_name, created_at, updated_at
FROM photos
WHERE FALSE;