diff options
| author | Masaya Tojo <masaya@tojo.tokyo> | 2023-08-31 00:31:37 +0900 |
|---|---|---|
| committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-10-13 02:13:19 +0900 |
| commit | 67cabf314b2b60c81454682f9259c3c207f71a73 (patch) | |
| tree | d7a32d4addea4913d55607863d0ea56fea8e573c /deploy | |
| parent | 9fb64fe1519512308764bce7056250751ae4f32f (diff) | |
Add date column to date table
Diffstat (limited to 'deploy')
| -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(), |