37 lines
832 B
Python
37 lines
832 B
Python
"""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')
|