Remove updated_at and created_at columns

2 files changed, 2 insertions, 6 deletions

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';
diff --git a/deploy/tags.sql b/deploy/tags.sql
index 8186248..d66bca5 100644
--- a/deploy/tags.sql
+++ b/deploy/tags.sql
@@ -7,9 +7,7 @@ SET search_path to diary;
 
 CREATE TABLE tags(
   id UUID PRIMARY KEY,
-  name TEXT UNIQUE NOT NULL,
-  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
-  updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
+  name TEXT UNIQUE NOT NULL
 );
 
 COMMIT;