aboutsummaryrefslogtreecommitdiff
path: root/verify
diff options
context:
space:
mode:
authorMasaya Tojo <masaya@tojo.tokyo>2023-03-12 23:53:45 +0900
committerMasaya Tojo <masaya@tojo.tokyo>2023-03-12 23:54:12 +0900
commitaae863e98b35152e8e7c0efe7919dd105c229361 (patch)
tree3e991ce3d407d4e734097de4c0d2b00a239adca4 /verify
parent51e01e14cad5c092a1e1d0772de9ff0f5922a76e (diff)
Add table to manage articles.
Diffstat (limited to 'verify')
-rw-r--r--verify/articles.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/verify/articles.sql b/verify/articles.sql
new file mode 100644
index 0000000..355d20f
--- /dev/null
+++ b/verify/articles.sql
@@ -0,0 +1,13 @@
+-- Verify kakeibo:articles on pg
+
+BEGIN;
+
+SELECT id,
+ location,
+ title,
+ created_at,
+ updated_at
+ FROM kakeibo.articles
+ WHERE FALSE;
+
+ROLLBACK;