diff options
author | Masaya Tojo <masaya@tojo.tokyo> | 2024-03-11 00:24:56 +0900 |
---|---|---|
committer | Masaya Tojo <masaya@tojo.tokyo> | 2024-03-11 00:24:56 +0900 |
commit | 5039f9a506222b3f74312a4586166f5130e53817 (patch) | |
tree | 1746dbb0dfe6def169ad2b0504eba3da47d572d4 /verify | |
parent | 516117207bbb3cca9723651b73941a2d1a5dca53 (diff) |
Add table manage diary articles.
Diffstat (limited to 'verify')
-rw-r--r-- | verify/articles.sql | 11 |
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; |