diff options
author | Masaya Tojo <masaya@tojo.tokyo> | 2023-08-30 00:33:59 +0900 |
---|---|---|
committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-10-13 02:13:00 +0900 |
commit | c9d52a5091b7313315506d5b647c6f5c6a5113f7 (patch) | |
tree | afcd9a318bed73a6733e184b5a225c4850af319c /deploy | |
parent | 04611bd0660c1dfd290c19409cfc253d81fb0544 (diff) |
Add unique constraint to path column of photos table
Diffstat (limited to 'deploy')
-rw-r--r-- | deploy/photos.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/deploy/photos.sql b/deploy/photos.sql index c451146..6c796ff 100644 --- a/deploy/photos.sql +++ b/deploy/photos.sql @@ -8,7 +8,7 @@ SET search_path to photos; CREATE TABLE photos( id UUID PRIMARY KEY, - path TEXT NOT NULL, + path TEXT NOT NULL UNIQUE, date DATE NOT NULL, is_receipt BOOLEAN NOT NULL DEFAULT FALSE, note TEXT CHECK (note <> ''), |