diff options
| -rw-r--r-- | deploy/articles.sql | 4 | ||||
| -rw-r--r-- | deploy/tags.sql | 4 | ||||
| -rw-r--r-- | verify/articles.sql | 2 | ||||
| -rw-r--r-- | verify/tags.sql | 2 |
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; |