diff options
author | Masaya Tojo <masaya@tojo.tokyo> | 2024-03-17 17:33:46 +0900 |
---|---|---|
committer | Masaya Tojo <masaya@tojo.tokyo> | 2024-03-17 17:34:25 +0900 |
commit | 63eaf4837fef5ea76a9249a752041d58e51eba0f (patch) | |
tree | b75369c8c4fe5251ae665ad21924888e90347cbc /verify | |
parent | 1cbd623da4d1eb4f6b44f9b1d72978dd7cdbd412 (diff) |
Rename column name from `id` to `<name>_id`.
Diffstat (limited to 'verify')
-rw-r--r-- | verify/articles.sql | 2 | ||||
-rw-r--r-- | verify/tags.sql | 2 |
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; |