[odrs-web/production] Use an index for the user_hash

[Richard Hughes <rhughes src gnome org>]

commit ec651e95934c8dd18da7b9378529a04437ff2c61
Author: Richard Hughes <richard hughsie com>
Date:   Fri Jan 12 12:26:03 2018 +0000

    Use an index for the user_hash
    
    This reduces load on the odrs.gnome.org server considerably.

 schema.sql |    1 +
 1 files changed, 1 insertions(+), 0 deletions(-)
---
diff --git a/schema.sql b/schema.sql
index 80191bc..8c1f189 100644
--- a/schema.sql
+++ b/schema.sql
@@ -39,6 +39,7 @@ CREATE TABLE users (
   is_banned INT DEFAULT 0,
   UNIQUE KEY id (user_id)
 ) CHARSET=utf8;
+CREATE INDEX users_hash_idx ON users (user_hash(40));
 DROP TABLE IF EXISTS eventlog;
 CREATE TABLE eventlog (
   eventlog_id INT NOT NULL AUTO_INCREMENT,