X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=sql%2Fupgrade-v2.40.sql;h=0c5614e8e0f4ecfbc342650a2b8555fd64f3d485;hb=9b45ad1ecd9f1eace384f825a7dc6b2b7920af65;hp=9c4fd2737b47456b9db6f08742bb107b8a4465ef;hpb=6be9a26e71fc85e69cbbdbc95fc50d3569050921;p=pr0n

diff --git a/sql/upgrade-v2.40.sql b/sql/upgrade-v2.40.sql
index 9c4fd27..0c5614e 100644
--- a/sql/upgrade-v2.40.sql
+++ b/sql/upgrade-v2.40.sql
@@ -44,7 +44,7 @@ ALTER TABLE events DROP CONSTRAINT events_pkey CASCADE;
 
 -- Finally, fix up some unique constraints
 DROP INDEX unique_filenames;
-CREATE INDEX unique_filenames ON images (vhost,event,filename);
+CREATE UNIQUE INDEX unique_filenames ON images (vhost,event,filename);
 
 ALTER TABLE fake_files DROP CONSTRAINT fake_files_pkey;
 ALTER TABLE fake_files ADD PRIMARY KEY (vhost,event,filename);