diff options
author | Masaya Tojo <masaya@tojo.tokyo> | 2023-08-30 00:32:58 +0900 |
---|---|---|
committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-10-13 02:12:56 +0900 |
commit | 04611bd0660c1dfd290c19409cfc253d81fb0544 (patch) | |
tree | 354355422ba1526c2ebb762f1bd378b2166cac0d /verify | |
parent | ccc4cc4bab2377fc92fa6959d761885bebaaa0e0 (diff) |
Add date column to photos table
Diffstat (limited to 'verify')
-rw-r--r-- | verify/photos.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/verify/photos.sql b/verify/photos.sql index 220dc72..d37db50 100644 --- a/verify/photos.sql +++ b/verify/photos.sql @@ -4,7 +4,7 @@ BEGIN; SET search_path to photos; -SELECT id, path, is_receipt, note, taken_at, camera_name, created_at, updated_at +SELECT id, path, is_receipt, note, date, taken_at, camera_name, created_at, updated_at FROM photos WHERE FALSE; |