diff options
| author | Masaya Tojo <masaya@tojo.tokyo> | 2024-03-13 01:10:00 +0900 |
|---|---|---|
| committer | Masaya Tojo <masaya@tojo.tokyo> | 2024-03-13 01:10:00 +0900 |
| commit | 4414f92a106eed45901b949b99ffa67a88a89895 (patch) | |
| tree | 2f7418147c1789c1d6ff5818c239749cecc4d5da /deploy/articles.sql | |
| parent | a927b30705d1e8c6b1b046e7512cc67cbdf19a21 (diff) | |
Remove updated_at and created_at columns
Diffstat (limited to 'deploy/articles.sql')
| -rw-r--r-- | deploy/articles.sql | 4 |
1 files changed, 1 insertions, 3 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'; |