|
7675.395.54
by Stuart Bishop
lower(EmailAddress.email) should be unique |
1 |
SET client_min_messages=ERROR; |
2 |
||
3 |
DROP INDEX emailaddress__lower_email__key; |
|
4 |
CREATE UNIQUE INDEX emailaddress__lower_email__key |
|
5 |
ON EmailAddress(lower(email)); |
|
6 |
||
7 |
INSERT INTO LaunchpadDatabaseRevision VALUES (2207, 35, 1); |