[odrs-web/oscp] Use a 40-char string for the user_hash

[Richard Hughes <rhughes src gnome org>]

commit 2f547f7365f253efc260ac9efbf422705c9aa2b3
Author: Richard Hughes <richard hughsie com>
Date:   Tue Jul 2 10:26:02 2019 +0100

    Use a 40-char string for the user_hash
    
    This is easier to index, and should be smaller to store.

 app_data/migrations/versions/84deb10331db_.py | 28 +++++++++++++++++++++++++++
 app_data/odrs/models.py                       |  2 +-
 2 files changed, 29 insertions(+), 1 deletion(-)
---
diff --git a/app_data/migrations/versions/84deb10331db_.py b/app_data/migrations/versions/84deb10331db_.py
new file mode 100644
index 0000000..3d90ebe
--- /dev/null
+++ b/app_data/migrations/versions/84deb10331db_.py
@@ -0,0 +1,28 @@
+"""
+
+Revision ID: 84deb10331db
+Revises: bbbcd54c69ac
+Create Date: 2019-07-02 10:26:30.036790
+
+"""
+
+# revision identifiers, used by Alembic.
+revision = '84deb10331db'
+down_revision = 'bbbcd54c69ac'
+
+from alembic import op
+import sqlalchemy as sa
+from sqlalchemy.dialects import mysql
+
+def upgrade():
+    op.alter_column('users', 'user_hash',
+               existing_type=mysql.TEXT(),
+               type_=sa.String(length=40),
+               existing_nullable=True)
+
+
+def downgrade():
+    op.alter_column('users', 'user_hash',
+               existing_type=sa.String(length=40),
+               type_=mysql.TEXT(),
+               existing_nullable=True)
diff --git a/app_data/odrs/models.py b/app_data/odrs/models.py
index 7350a49..134c0e3 100644
--- a/app_data/odrs/models.py
+++ b/app_data/odrs/models.py
@@ -73,7 +73,7 @@ class User(db.Model):
 
     user_id = Column(Integer, primary_key=True, nullable=False, unique=True)
     date_created = Column(DateTime, nullable=False, default=datetime.datetime.utcnow)
-    user_hash = Column(Text)
+    user_hash = Column(String(40))
     karma = Column(Integer, default=0)
     is_banned = Column(Boolean, default=False)