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

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);