From 4414f92a106eed45901b949b99ffa67a88a89895 Mon Sep 17 00:00:00 2001
From: Masaya Tojo <masaya@tojo.tokyo>
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

