diff options
| author | Masaya Tojo <masaya@tojo.tokyo> | 2024-03-28 01:43:35 +0900 |
|---|---|---|
| committer | Masaya Tojo <masaya@tojo.tokyo> | 2024-03-28 01:51:38 +0900 |
| commit | 326678bdd0199fb55543b4d4b6a3da0e5a7b9852 (patch) | |
| tree | efb4277f16dca2b50fb7dffb6a9911b60dd0ead4 | |
| parent | 11889639d74136dd9e2a5f819da75ae781ef0efc (diff) | |
| -rw-r--r-- | deploy/articles.sql | 1 | ||||
| -rw-r--r-- | verify/articles.sql | 2 |
2 files changed, 2 insertions, 1 deletions
diff --git a/deploy/articles.sql b/deploy/articles.sql index 72f4a74..8b74140 100644 --- a/deploy/articles.sql +++ b/deploy/articles.sql @@ -9,6 +9,7 @@ CREATE TABLE articles( article_id UUID PRIMARY KEY, timestamp TIMESTAMPTZ NOT NULL, hash VARCHAR(64) NOT NULL, + source TEXT NOT NULL, title VARCHAR NOT NULL, body TEXT NOT NULL ); diff --git a/verify/articles.sql b/verify/articles.sql index 4b98547..710b462 100644 --- a/verify/articles.sql +++ b/verify/articles.sql @@ -4,7 +4,7 @@ BEGIN; SET search_path to diary; -SELECT article_id, timestamp, hash, title, body +SELECT article_id, timestamp, hash, source, title, body FROM articles WHERE FALSE; |