diff options
Diffstat (limited to 'deploy')
| -rw-r--r-- | deploy/articles.sql | 4 | ||||
| -rw-r--r-- | deploy/tags.sql | 4 |
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; |