diff options
Diffstat (limited to 'deploy/diaries.sql')
| -rw-r--r-- | deploy/diaries.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/deploy/diaries.sql b/deploy/diaries.sql index 3188490..f156ff1 100644 --- a/deploy/diaries.sql +++ b/deploy/diaries.sql @@ -9,6 +9,7 @@ SET search_path to photos; CREATE TABLE diaries ( id UUID PRIMARY KEY, photo_id UUID NOT NULL REFERENCES photos(id) ON DELETE RESTRICT ON UPDATE RESTRICT, + date DATE NOT NULL UNIQUE, title TEXT NOT NULL, entry TEXT NOT NULL, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), |