Remove updated_at and created_at columns

4 files changed, 4 insertions, 8 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;
diff --git a/verify/articles.sql b/verify/articles.sql
index 9192a11..56526d7 100644
--- a/verify/articles.sql
+++ b/verify/articles.sql
@@ -4,7 +4,7 @@ BEGIN;
 
 SET search_path to diary;
 
-SELECT id, timestamp, hash, title, body, created_at, updated_at
+SELECT id, timestamp, hash, title, body
   FROM articles
  WHERE FALSE;
 
diff --git a/verify/tags.sql b/verify/tags.sql
index 5d6b174..faaec73 100644
--- a/verify/tags.sql
+++ b/verify/tags.sql
@@ -4,7 +4,7 @@ BEGIN;
 
 SET search_path to diary;
 
-SELECT id, name, created_at, updated_at
+SELECT id, name
   FROM tags
  WHERE FALSE;