If we are showing a RAW image, show an extra download link.

[pr0n] / sql / upgrade-v2.40.sql

diff --git a/sql/upgrade-v2.40.sql b/sql/upgrade-v2.40.sql
index 9c4fd2737b47456b9db6f08742bb107b8a4465ef..0c5614e8e0f4ecfbc342650a2b8555fd64f3d485 100644 (file)
--- 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);