Add database column for task assigned by admin

This allows us to later manually assign tasks to users,
which didn't work anymore after the task assignment
rewrite.

1 files changed, 28 insertions, 0 deletions

diff --git a/migrations/versions/ab06eac38963_mark_task_assigned_by_admin.py b/migrations/versions/ab06eac38963_mark_task_assigned_by_admin.py
new file mode 100644
index 0000000..a68d5da
--- /dev/null
+++ b/migrations/versions/ab06eac38963_mark_task_assigned_by_admin.py
@@ -0,0 +1,28 @@
+"""mark task assigned by admin
+
+Revision ID: ab06eac38963
+Revises: 70fb9f3860b1
+Create Date: 2019-09-16 12:23:43.694821
+
+"""
+from alembic import op
+import sqlalchemy as sa
+
+
+# revision identifiers, used by Alembic.
+revision = 'ab06eac38963'
+down_revision = '70fb9f3860b1'
+branch_labels = None
+depends_on = None
+
+
+def upgrade():
+    # ### commands auto generated by Alembic - please adjust! ###
+    op.add_column('task', sa.Column('admin_assigned', sa.Boolean(), nullable=False))
+    # ### end Alembic commands ###
+
+
+def downgrade():
+    # ### commands auto generated by Alembic - please adjust! ###
+    op.drop_column('task', 'admin_assigned')
+    # ### end Alembic commands ###