summaryrefslogtreecommitdiff
path: root/verify
diff options
context:
space:
mode:
authorMasaya Tojo <masaya@tojo.tokyo>2023-08-30 00:49:46 +0900
committerMasaya Tojo <masaya@tojo.tokyo>2023-10-13 02:13:08 +0900
commit47a910d64e1ed8339b9efc3bd929f55c85172cba (patch)
tree4554168b226e0a843a5c5494c5ea1e51fe97113d /verify
parent36fe291d3732003d0392d796f6dbdd027d11e367 (diff)
Add table to manage diaries
Diffstat (limited to 'verify')
-rw-r--r--verify/diaries.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/verify/diaries.sql b/verify/diaries.sql
new file mode 100644
index 0000000..654c2ff
--- /dev/null
+++ b/verify/diaries.sql
@@ -0,0 +1,11 @@
+-- Verify photos:diaries on pg
+
+BEGIN;
+
+SET search_path to photos;
+
+SELECT id, photo_id, title, entry, created_at, updated_at
+ FROM diaries
+ WHERE FALSE;
+
+ROLLBACK;