aboutsummaryrefslogtreecommitdiff
path: root/verify
diff options
context:
space:
mode:
authorMasaya Tojo <masaya@tojo.tokyo>2024-03-11 00:24:56 +0900
committerMasaya Tojo <masaya@tojo.tokyo>2024-03-11 00:24:56 +0900
commit5039f9a506222b3f74312a4586166f5130e53817 (patch)
tree1746dbb0dfe6def169ad2b0504eba3da47d572d4 /verify
parent516117207bbb3cca9723651b73941a2d1a5dca53 (diff)
Add table manage diary articles.
Diffstat (limited to 'verify')
-rw-r--r--verify/articles.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/verify/articles.sql b/verify/articles.sql
new file mode 100644
index 0000000..9192a11
--- /dev/null
+++ b/verify/articles.sql
@@ -0,0 +1,11 @@
+-- Verify diary:articles on pg
+
+BEGIN;
+
+SET search_path to diary;
+
+SELECT id, timestamp, hash, title, body, created_at, updated_at
+ FROM articles
+ WHERE FALSE;
+
+ROLLBACK;