From f3022db88d32e70320b58ad8cf99898c46b41103 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Sat, 21 Jul 2007 01:53:01 +0200 Subject: [PATCH 1/1] Oops, the unique_filenames index should really be unique. --- sql/upgrade-v2.40.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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); -- 2.39.2