Add email confirmation field

2 files changed, 29 insertions, 0 deletions

diff --git a/app/models.py b/app/models.py
index 03ba884..86e15f0 100644
--- a/app/models.py
+++ b/app/models.py
@@ -22,6 +22,7 @@ class User(UserMixin, db.Model):
         db.DateTime(), nullable=False, default=datetime.datetime.utcnow
     )
     is_admin = db.Column(db.Boolean(), default=False)
+    is_confirmed = db.Column(db.Boolean(), default=False)
 
     def __repr__(self):
         return "<User %r>" % self.username
diff --git a/migrations/versions/e58a3596b899_add_email_confirmation_field.py b/migrations/versions/e58a3596b899_add_email_confirmation_field.py
new file mode 100644
index 0000000..215a1f4
--- /dev/null
+++ b/migrations/versions/e58a3596b899_add_email_confirmation_field.py
@@ -0,0 +1,28 @@
+"""add email confirmation field
+
+Revision ID: e58a3596b899
+Revises: 878e8193ae4d
+Create Date: 2019-03-26 15:05:01.522435
+
+"""
+from alembic import op
+import sqlalchemy as sa
+
+
+# revision identifiers, used by Alembic.
+revision = 'e58a3596b899'
+down_revision = '878e8193ae4d'
+branch_labels = None
+depends_on = None
+
+
+def upgrade():
+    # ### commands auto generated by Alembic - please adjust! ###
+    op.add_column('user', sa.Column('is_confirmed', sa.Boolean(), nullable=True))
+    # ### end Alembic commands ###
+
+
+def downgrade():
+    # ### commands auto generated by Alembic - please adjust! ###
+    op.drop_column('user', 'is_confirmed')
+    # ### end Alembic commands ###