From 4414f92a106eed45901b949b99ffa67a88a89895 Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Wed, 13 Mar 2024 01:10:00 +0900 Subject: Remove updated_at and created_at columns --- deploy/articles.sql | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) (limited to 'deploy/articles.sql') diff --git a/deploy/articles.sql b/deploy/articles.sql index 8c259d1..0b9b973 100644 --- a/deploy/articles.sql +++ b/deploy/articles.sql @@ -10,9 +10,7 @@ CREATE TABLE articles( timestamp TIMESTAMPTZ NOT NULL, hash VARCHAR(64) NOT NULL, title TEXT NOT NULL, - body TEXT NOT NULL, - created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), - updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW() + body TEXT NOT NULL ); COMMENT ON COLUMN articles.hash is 'SHA256 of org subtrees'; -- cgit v1.2.3