migrations/versions/3ca4aedaa7df_.py
"""empty message
Revision ID: 3ca4aedaa7df
Revises: 10841bb4b0ea
Create Date: 2018-07-26 15:45:09.833748
"""
from alembic import op
import sqlalchemy as sa
import sqlalchemy_utils
# revision identifiers, used by Alembic.
revision = '3ca4aedaa7df'
down_revision = '10841bb4b0ea'
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('feedback', sa.Column('session_id', sa.Integer(), nullable=True))
op.create_foreign_key(None, 'feedback', 'sessions', ['session_id'], ['id'], ondelete='CASCADE')
# ### end Alembic commands ###
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_constraint(None, 'feedback', type_='foreignkey')
op.drop_column('feedback', 'session_id')
# ### end Alembic commands ###