From 326678bdd0199fb55543b4d4b6a3da0e5a7b9852 Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Thu, 28 Mar 2024 01:43:35 +0900 Subject: Add source column for saving org subtree. --- deploy/articles.sql | 1 + verify/articles.sql | 2 +- 2 files changed, 2 insertions(+), 1 deletion(-) 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; -- cgit v1.2.3