migrations/versions/e95a9cd83678_.py
"""empty message
Revision ID: e95a9cd83678
Revises: 3f145ecaf358
Create Date: 2016-12-21 13:17:24.682386
"""
# revision identifiers, used by Alembic.
revision = 'e95a9cd83678'
down_revision = '3f145ecaf358'
from alembic import op
import sqlalchemy as sa
import sqlalchemy_utils
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_constraint(u'association_ticket_tag_id_fkey', 'association', type_='foreignkey')
op.drop_constraint(u'association_ticket_id_fkey', 'association', type_='foreignkey')
op.create_foreign_key(None, 'association', 'ticket_tag', ['ticket_tag_id'], ['id'], ondelete='CASCADE')
op.create_foreign_key(None, 'association', 'ticket', ['ticket_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'booked_ticket_ticket_id_fkey', 'booked_ticket', type_='foreignkey')
op.drop_constraint(u'booked_ticket_user_id_fkey', 'booked_ticket', type_='foreignkey')
op.create_foreign_key(None, 'booked_ticket', 'user', ['user_id'], ['id'], ondelete='CASCADE')
op.create_foreign_key(None, 'booked_ticket', 'ticket', ['ticket_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'email_notification_user_id_fkey', 'email_notification', type_='foreignkey')
op.drop_constraint(u'email_notification_event_id_fkey', 'email_notification', type_='foreignkey')
op.create_foreign_key(None, 'email_notification', 'events', ['event_id'], ['id'], ondelete='CASCADE')
op.create_foreign_key(None, 'email_notification', 'user', ['user_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'events_creator_id_fkey', 'events', type_='foreignkey')
op.create_foreign_key(None, 'events', 'user', ['creator_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'orders_user_id_fkey', 'orders', type_='foreignkey')
op.drop_constraint(u'orders_event_id_fkey', 'orders', type_='foreignkey')
op.drop_constraint(u'orders_marketer_id_fkey', 'orders', type_='foreignkey')
op.create_foreign_key(None, 'orders', 'user', ['marketer_id'], ['id'], ondelete='SET NULL')
op.create_foreign_key(None, 'orders', 'user', ['user_id'], ['id'], ondelete='SET NULL')
op.create_foreign_key(None, 'orders', 'events', ['event_id'], ['id'], ondelete='SET NULL')
op.drop_constraint(u'orders_tickets_ticket_id_fkey', 'orders_tickets', type_='foreignkey')
op.drop_constraint(u'orders_tickets_order_id_fkey', 'orders_tickets', type_='foreignkey')
op.create_foreign_key(None, 'orders_tickets', 'ticket', ['ticket_id'], ['id'], ondelete='CASCADE')
op.create_foreign_key(None, 'orders_tickets', 'orders', ['order_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'ticket_holders_ticket_id_fkey', 'ticket_holders', type_='foreignkey')
op.create_foreign_key(None, 'ticket_holders', 'ticket', ['ticket_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'ticket_tag_event_id_fkey', 'ticket_tag', type_='foreignkey')
op.create_foreign_key(None, 'ticket_tag', 'events', ['event_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'user_system_role_user_id_fkey', 'user_system_role', type_='foreignkey')
op.drop_constraint(u'user_system_role_role_id_fkey', 'user_system_role', type_='foreignkey')
op.create_foreign_key(None, 'user_system_role', 'custom_sys_role', ['role_id'], ['id'], ondelete='CASCADE')
op.create_foreign_key(None, 'user_system_role', 'user', ['user_id'], ['id'], ondelete='CASCADE')
op.drop_constraint(u'users_events_roles_role_id_fkey', 'users_events_roles', type_='foreignkey')
op.drop_constraint(u'users_events_roles_user_id_fkey', 'users_events_roles', type_='foreignkey')
op.create_foreign_key(None, 'users_events_roles', 'role', ['role_id'], ['id'], ondelete='CASCADE')
op.create_foreign_key(None, 'users_events_roles', 'user', ['user_id'], ['id'], ondelete='CASCADE')
### end Alembic commands ###
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_constraint(None, 'users_events_roles', type_='foreignkey')
op.drop_constraint(None, 'users_events_roles', type_='foreignkey')
op.create_foreign_key(u'users_events_roles_user_id_fkey', 'users_events_roles', 'user', ['user_id'], ['id'])
op.create_foreign_key(u'users_events_roles_role_id_fkey', 'users_events_roles', 'role', ['role_id'], ['id'])
op.drop_constraint(None, 'user_system_role', type_='foreignkey')
op.drop_constraint(None, 'user_system_role', type_='foreignkey')
op.create_foreign_key(u'user_system_role_role_id_fkey', 'user_system_role', 'custom_sys_role', ['role_id'], ['id'])
op.create_foreign_key(u'user_system_role_user_id_fkey', 'user_system_role', 'user', ['user_id'], ['id'])
op.drop_constraint(None, 'ticket_tag', type_='foreignkey')
op.create_foreign_key(u'ticket_tag_event_id_fkey', 'ticket_tag', 'events', ['event_id'], ['id'])
op.drop_constraint(None, 'ticket_holders', type_='foreignkey')
op.create_foreign_key(u'ticket_holders_ticket_id_fkey', 'ticket_holders', 'ticket', ['ticket_id'], ['id'])
op.drop_constraint(None, 'orders_tickets', type_='foreignkey')
op.drop_constraint(None, 'orders_tickets', type_='foreignkey')
op.create_foreign_key(u'orders_tickets_order_id_fkey', 'orders_tickets', 'orders', ['order_id'], ['id'])
op.create_foreign_key(u'orders_tickets_ticket_id_fkey', 'orders_tickets', 'ticket', ['ticket_id'], ['id'])
op.drop_constraint(None, 'orders', type_='foreignkey')
op.drop_constraint(None, 'orders', type_='foreignkey')
op.drop_constraint(None, 'orders', type_='foreignkey')
op.create_foreign_key(u'orders_marketer_id_fkey', 'orders', 'user', ['marketer_id'], ['id'])
op.create_foreign_key(u'orders_event_id_fkey', 'orders', 'events', ['event_id'], ['id'])
op.create_foreign_key(u'orders_user_id_fkey', 'orders', 'user', ['user_id'], ['id'])
op.drop_constraint(None, 'events', type_='foreignkey')
op.create_foreign_key(u'events_creator_id_fkey', 'events', 'user', ['creator_id'], ['id'])
op.drop_constraint(None, 'email_notification', type_='foreignkey')
op.drop_constraint(None, 'email_notification', type_='foreignkey')
op.create_foreign_key(u'email_notification_event_id_fkey', 'email_notification', 'events', ['event_id'], ['id'])
op.create_foreign_key(u'email_notification_user_id_fkey', 'email_notification', 'user', ['user_id'], ['id'])
op.drop_constraint(None, 'booked_ticket', type_='foreignkey')
op.drop_constraint(None, 'booked_ticket', type_='foreignkey')
op.create_foreign_key(u'booked_ticket_user_id_fkey', 'booked_ticket', 'user', ['user_id'], ['id'])
op.create_foreign_key(u'booked_ticket_ticket_id_fkey', 'booked_ticket', 'ticket', ['ticket_id'], ['id'])
op.drop_constraint(None, 'association', type_='foreignkey')
op.drop_constraint(None, 'association', type_='foreignkey')
op.create_foreign_key(u'association_ticket_id_fkey', 'association', 'ticket', ['ticket_id'], ['id'])
op.create_foreign_key(u'association_ticket_tag_id_fkey', 'association', 'ticket_tag', ['ticket_tag_id'], ['id'])
### end Alembic commands ###