diff --git a/alembic/versions/496f7a700f2e_add_priorities.py b/alembic/versions/496f7a700f2e_add_priorities.py new file mode 100644 index 0000000..21c7ca7 --- /dev/null +++ b/alembic/versions/496f7a700f2e_add_priorities.py @@ -0,0 +1,37 @@ +"""Add priorities + +Revision ID: 496f7a700f2e +Revises: 4cae55a80a42 +Create Date: 2016-03-24 12:19:34.298752 + +""" + +# revision identifiers, used by Alembic. +revision = '496f7a700f2e' +down_revision = '4cae55a80a42' + +from alembic import op +import sqlalchemy as sa + + +def upgrade(): + ''' Add the column _priorities to the table projects + and the column priority to the table issues. + ''' + op.add_column( + 'projects', + sa.Column('_priorities', sa.Text, nullable=True) + ) + + op.add_column( + 'issues', + sa.Column('priority', sa.Integer, nullable=True, default=None) + ) + + +def downgrade(): + ''' Drop the column _priorities from the table projects + and the column priority from the table issues. + ''' + op.drop_column('projects', '_priorities') + op.drop_column('issues', 'priority')