diff options
| -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; |