migrations/versions/5551af72812f_.py
"""empty message
Revision ID: 5551af72812f
Revises: 7bb5891a9f2e
Create Date: 2019-04-04 23:16:27.618573
"""
from alembic import op
import sqlalchemy as sa
import sqlalchemy_utils
# revision identifiers, used by Alembic.
revision = '5551af72812f'
down_revision = '7bb5891a9f2e'
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('access_codes', sa.Column('ticket_id', sa.Integer(), nullable=True))
op.create_foreign_key(None, 'access_codes', 'tickets', ['ticket_id'], ['id'], ondelete='CASCADE')
# ### end Alembic commands ###
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_constraint(None, 'access_codes', type_='foreignkey')
op.drop_column('access_codes', 'ticket_id')
# ### end Alembic commands ###