[odrs-web/oscp] Add a foreign key for the votes table back to the review itself

[Richard Hughes <rhughes src gnome org>]

commit c54308b636c0e1712aa3f2c15cc48f8edda17f3b
Author: Richard Hughes <richard hughsie com>
Date:   Wed Jul 3 11:40:40 2019 +0100

    Add a foreign key for the votes table back to the review itself

 app_data/migrations/versions/036f0cd034e5_.py | 21 +++++++++++++++++++++
 app_data/odrs/models.py                       |  3 ++-
 2 files changed, 23 insertions(+), 1 deletion(-)
---
diff --git a/app_data/migrations/versions/036f0cd034e5_.py b/app_data/migrations/versions/036f0cd034e5_.py
new file mode 100644
index 0000000..020e9f3
--- /dev/null
+++ b/app_data/migrations/versions/036f0cd034e5_.py
@@ -0,0 +1,21 @@
+"""
+
+Revision ID: 036f0cd034e5
+Revises: b63a028c3346
+Create Date: 2019-07-03 11:39:22.323579
+
+"""
+
+# revision identifiers, used by Alembic.
+revision = '036f0cd034e5'
+down_revision = 'b63a028c3346'
+
+from alembic import op
+import sqlalchemy as sa
+from sqlalchemy.dialects import mysql
+
+def upgrade():
+    op.create_foreign_key(None, 'votes', 'reviews', ['review_id'], ['review_id'])
+
+def downgrade():
+    op.drop_constraint(None, 'votes', type_='foreignkey')
diff --git a/app_data/odrs/models.py b/app_data/odrs/models.py
index 9df1c7b..040b6c6 100644
--- a/app_data/odrs/models.py
+++ b/app_data/odrs/models.py
@@ -51,11 +51,12 @@ class Vote(db.Model):
 
     vote_id = Column(Integer, primary_key=True, nullable=False, unique=True)
     date_created = Column(DateTime, nullable=False, default=datetime.datetime.utcnow)
+    review_id = Column(Integer, ForeignKey('reviews.review_id'), nullable=True)
     user_id = Column(Integer, ForeignKey('users.user_id'), nullable=True)
     val = Column(Integer, default=0)
-    review_id = Column(Integer, default=0)
 
     user = relationship('User')
+    review = relationship('Review')
 
     def __init__(self, user_id, val, review_id=0):
         self.review_id = review_id