"""empty message

Revision ID: 01b6969ef4e5
Revises: ffbb4d4dad39
Create Date: 2016-06-29 15:43:56.161000

"""

# revision identifiers, used by Alembic.
revision = '01b6969ef4e5'
down_revision = 'ffbb4d4dad39'

from alembic import op
import sqlalchemy as sa
import sqlalchemy_utils


def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint(u'speakers_sessions_session_id_fkey', 'speakers_sessions', type_='foreignkey')
    op.drop_constraint(u'speakers_sessions_speaker_id_fkey', 'speakers_sessions', type_='foreignkey')
    op.create_foreign_key(None, 'speakers_sessions', 'session', ['session_id'], ['id'], ondelete='CASCADE')
    op.create_foreign_key(None, 'speakers_sessions', 'speaker', ['speaker_id'], ['id'], ondelete='CASCADE')
    ### end Alembic commands ###


def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint(None, 'speakers_sessions', type_='foreignkey')
    op.drop_constraint(None, 'speakers_sessions', type_='foreignkey')
    op.create_foreign_key(u'speakers_sessions_speaker_id_fkey', 'speakers_sessions', 'speaker', ['speaker_id'], ['id'])
    op.create_foreign_key(u'speakers_sessions_session_id_fkey', 'speakers_sessions', 'session', ['session_id'], ['id'])
    ### end Alembic commands ###
