aboutsummaryrefslogtreecommitdiff
path: root/verify
diff options
context:
space:
mode:
authorMasaya Tojo <masaya@tojo.tokyo>2024-03-17 17:33:46 +0900
committerMasaya Tojo <masaya@tojo.tokyo>2024-03-17 17:34:25 +0900
commit63eaf4837fef5ea76a9249a752041d58e51eba0f (patch)
treeb75369c8c4fe5251ae665ad21924888e90347cbc /verify
parent1cbd623da4d1eb4f6b44f9b1d72978dd7cdbd412 (diff)
Rename column name from `id` to `<name>_id`.
Diffstat (limited to 'verify')
-rw-r--r--verify/articles.sql2
-rw-r--r--verify/tags.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/verify/articles.sql b/verify/articles.sql
index 56526d7..4b98547 100644
--- a/verify/articles.sql
+++ b/verify/articles.sql
@@ -4,7 +4,7 @@ BEGIN;
SET search_path to diary;
-SELECT id, timestamp, hash, title, body
+SELECT article_id, timestamp, hash, title, body
FROM articles
WHERE FALSE;
diff --git a/verify/tags.sql b/verify/tags.sql
index faaec73..86321d3 100644
--- a/verify/tags.sql
+++ b/verify/tags.sql
@@ -4,7 +4,7 @@ BEGIN;
SET search_path to diary;
-SELECT id, name
+SELECT tag_id, name
FROM tags
WHERE FALSE;