aboutsummaryrefslogtreecommitdiff
path: root/verify
diff options
context:
space:
mode:
authorMasaya Tojo <masaya@tojo.tokyo>2023-03-28 01:10:08 +0900
committerMasaya Tojo <masaya@tojo.tokyo>2023-03-28 01:10:08 +0900
commit37db03353a121d039a98af49aa034fb2d8f6e6ea (patch)
tree2b92da1e57dec3297473e7bf1b2288fc53da71ec /verify
parenta32412ed8826a036be7ebf76ecba8c9134301ecb (diff)
Add table for tracking photos.
Diffstat (limited to 'verify')
-rw-r--r--verify/photo.photos.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/verify/photo.photos.sql b/verify/photo.photos.sql
new file mode 100644
index 0000000..c3e2c42
--- /dev/null
+++ b/verify/photo.photos.sql
@@ -0,0 +1,15 @@
+-- Verify life-archive:photo.photos on pg
+
+BEGIN;
+
+SELECT id,
+ url,
+ taken_at,
+ place,
+ note,
+ created_at,
+ updated_at
+ FROM photo.photos
+ WHERE FALSE;
+
+ROLLBACK;