2 files changed, 8 insertions, 2 deletions
diff --git a/db/schema.sql b/db/schema.sql
index 297a13946..86a9598c4 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -358,9 +358,8 @@ create table flickr_imported (
 create unique index flickr_imported_id_idx on flickr_imported(id);
 
 create table abuse (
-    email text not null
+    email text primary key check( lower(email) = email )
 );
-create unique index abuse_email_idx on abuse(lower(email));
 
 create table textmystreet (
     name text not null,
diff --git a/db/schema_0001-add_sessions_and_users_and_dbic_fields.sql b/db/schema_0001-add_sessions_and_users_and_dbic_fields.sql
index 992f3c685..581741fe8 100644
--- a/db/schema_0001-add_sessions_and_users_and_dbic_fields.sql
+++ b/db/schema_0001-add_sessions_and_users_and_dbic_fields.sql
@@ -44,4 +44,11 @@ create or replace function contacts_updated()
     end;
 ' language 'plpgsql';
 
+
+--- add pk and lowercase check to abuse
+drop index  abuse_email_idx;
+update abuse set email = lower(email);
+alter table abuse add check( lower(email) = email );
+alter table abuse add primary key(email);
+
 commit;