This is the py file:
"""
Revision ID: 356ffba72559
Revises: 813ea74ce8dc
Create Date: 2019-01-29 13:33:49.853953
"""
import sqlalchemy as sa
from alembic import op
# revision identifiers, used by Alembic.
revision = '356ffba72559'
down_revision = '813ea74ce8dc'
branch_labels = None
depends_on = None
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_constraint(u'fk_designer_image_files_template_id_designer_templates', 'designer_image_files', type_='foreignkey')
op.create_foreign_key(op.f('fk_designer_image_files_template_id_designer_templates'), 'designer_image_files', 'designer_templates', ['template_id'], ['id'], source_schema='indico', referent_schema='indico')
op.drop_constraint(u'fk_designer_templates_background_image_id_designer_image_files', 'designer_templates', type_='foreignkey')
op.drop_constraint(u'fk_designer_templates_backside_template_id_designer_templates', 'designer_templates', type_='foreignkey')
op.drop_constraint(u'fk_designer_templates_category_id_categories', 'designer_templates', type_='foreignkey')
op.drop_constraint(u'fk_designer_templates_event_id_events', 'designer_templates', type_='foreignkey')
op.create_foreign_key(op.f('fk_designer_templates_event_id_events'), 'designer_templates', 'events', ['event_id'], ['id'], source_schema='indico', referent_schema='events')
op.create_foreign_key(op.f('fk_designer_templates_category_id_categories'), 'designer_templates', 'categories', ['category_id'], ['id'], source_schema='indico', referent_schema='categories')
op.create_foreign_key(op.f('fk_designer_templates_background_image_id_designer_image_files'), 'designer_templates', 'designer_image_files', ['background_image_id'], ['id'], source_schema='indico', referent_schema='indico')
op.create_foreign_key(op.f('fk_designer_templates_backside_template_id_designer_templates'), 'designer_templates', 'designer_templates', ['backside_template_id'], ['id'], source_schema='indico', referent_schema='indico')
op.drop_constraint(u'fk_ip_networks_group_id_ip_network_groups', 'ip_networks', type_='foreignkey')
op.create_foreign_key(op.f('fk_ip_networks_group_id_ip_network_groups'), 'ip_networks', 'ip_network_groups', ['group_id'], ['id'], source_schema='indico', referent_schema='indico')
op.drop_constraint(u'fk_settings_principals_user_id_users', 'settings_principals', type_='foreignkey')
op.drop_constraint(u'fk_settings_principals_local_group_id_groups', 'settings_principals', type_='foreignkey')
op.create_foreign_key(op.f('fk_settings_principals_user_id_users'), 'settings_principals', 'users', ['user_id'], ['id'], source_schema='indico', referent_schema='users')
op.create_foreign_key(op.f('fk_settings_principals_local_group_id_groups'), 'settings_principals', 'groups', ['local_group_id'], ['id'], source_schema='indico', referent_schema='users')
op.drop_constraint(u'fk_categories_default_ticket_template_id_designer_templates', 'categories', schema='categories', type_='foreignkey')
op.create_foreign_key(op.f('fk_categories_default_ticket_template_id_designer_templates'), 'categories', 'designer_templates', ['default_ticket_template_id'], ['id'], source_schema='categories', referent_schema='indico')
op.drop_constraint(u'fk_principals_ip_network_group_id_ip_network_groups', 'principals', schema='categories', type_='foreignkey')
op.create_foreign_key(op.f('fk_principals_ip_network_group_id_ip_network_groups'), 'principals', 'ip_network_groups', ['ip_network_group_id'], ['id'], source_schema='categories', referent_schema='indico')
op.drop_constraint(u'fk_forms_ticket_template_id_designer_templates', 'forms', schema='event_registration', type_='foreignkey')
op.create_foreign_key(op.f('fk_forms_ticket_template_id_designer_templates'), 'forms', 'designer_templates', ['ticket_template_id'], ['id'], source_schema='event_registration', referent_schema='indico')
op.drop_constraint(u'fk_contribution_references_reference_type_id_reference_types', 'contribution_references', schema='events', type_='foreignkey')
op.create_foreign_key(op.f('fk_contribution_references_reference_type_id_reference_types'), 'contribution_references', 'reference_types', ['reference_type_id'], ['id'], source_schema='events', referent_schema='indico')
op.drop_constraint(u'fk_event_references_reference_type_id_reference_types', 'event_references', schema='events', type_='foreignkey')
op.create_foreign_key(op.f('fk_event_references_reference_type_id_reference_types'), 'event_references', 'reference_types', ['reference_type_id'], ['id'], source_schema='events', referent_schema='indico')
op.drop_constraint(u'fk_principals_ip_network_group_id_ip_network_groups', 'principals', schema='events', type_='foreignkey')
op.create_foreign_key(op.f('fk_principals_ip_network_group_id_ip_network_groups'), 'principals', 'ip_network_groups', ['ip_network_group_id'], ['id'], source_schema='events', referent_schema='indico')
op.drop_constraint(u'fk_subcontribution_references_reference_type_id_reference_types', 'subcontribution_references', schema='events', type_='foreignkey')
op.create_foreign_key(op.f('fk_subcontribution_references_reference_type_id_reference_types'), 'subcontribution_references', 'reference_types', ['reference_type_id'], ['id'], source_schema='events', referent_schema='indico')
# ### end Alembic commands ###
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_constraint(op.f('fk_subcontribution_references_reference_type_id_reference_types'), 'subcontribution_references', schema='events', type_='foreignkey')
op.create_foreign_key(u'fk_subcontribution_references_reference_type_id_reference_types', 'subcontribution_references', 'reference_types', ['reference_type_id'], ['id'], source_schema='events')
op.drop_constraint(op.f('fk_principals_ip_network_group_id_ip_network_groups'), 'principals', schema='events', type_='foreignkey')
op.create_foreign_key(u'fk_principals_ip_network_group_id_ip_network_groups', 'principals', 'ip_network_groups', ['ip_network_group_id'], ['id'], source_schema='events')
op.drop_constraint(op.f('fk_event_references_reference_type_id_reference_types'), 'event_references', schema='events', type_='foreignkey')
op.create_foreign_key(u'fk_event_references_reference_type_id_reference_types', 'event_references', 'reference_types', ['reference_type_id'], ['id'], source_schema='events')
op.drop_constraint(op.f('fk_contribution_references_reference_type_id_reference_types'), 'contribution_references', schema='events', type_='foreignkey')
op.create_foreign_key(u'fk_contribution_references_reference_type_id_reference_types', 'contribution_references', 'reference_types', ['reference_type_id'], ['id'], source_schema='events')
op.drop_constraint(op.f('fk_forms_ticket_template_id_designer_templates'), 'forms', schema='event_registration', type_='foreignkey')
op.create_foreign_key(u'fk_forms_ticket_template_id_designer_templates', 'forms', 'designer_templates', ['ticket_template_id'], ['id'], source_schema='event_registration')
op.drop_constraint(op.f('fk_principals_ip_network_group_id_ip_network_groups'), 'principals', schema='categories', type_='foreignkey')
op.create_foreign_key(u'fk_principals_ip_network_group_id_ip_network_groups', 'principals', 'ip_network_groups', ['ip_network_group_id'], ['id'], source_schema='categories')
op.drop_constraint(op.f('fk_categories_default_ticket_template_id_designer_templates'), 'categories', schema='categories', type_='foreignkey')
op.create_foreign_key(u'fk_categories_default_ticket_template_id_designer_templates', 'categories', 'designer_templates', ['default_ticket_template_id'], ['id'], source_schema='categories')
op.drop_constraint(op.f('fk_settings_principals_local_group_id_groups'), 'settings_principals', schema='indico', type_='foreignkey')
op.drop_constraint(op.f('fk_settings_principals_user_id_users'), 'settings_principals', schema='indico', type_='foreignkey')
op.create_foreign_key(u'fk_settings_principals_local_group_id_groups', 'settings_principals', 'groups', ['local_group_id'], ['id'], referent_schema='users')
op.create_foreign_key(u'fk_settings_principals_user_id_users', 'settings_principals', 'users', ['user_id'], ['id'], referent_schema='users')
op.drop_constraint(op.f('fk_ip_networks_group_id_ip_network_groups'), 'ip_networks', schema='indico', type_='foreignkey')
op.create_foreign_key(u'fk_ip_networks_group_id_ip_network_groups', 'ip_networks', 'ip_network_groups', ['group_id'], ['id'])
op.drop_constraint(op.f('fk_designer_templates_backside_template_id_designer_templates'), 'designer_templates', schema='indico', type_='foreignkey')
op.drop_constraint(op.f('fk_designer_templates_background_image_id_designer_image_files'), 'designer_templates', schema='indico', type_='foreignkey')
op.drop_constraint(op.f('fk_designer_templates_category_id_categories'), 'designer_templates', schema='indico', type_='foreignkey')
op.drop_constraint(op.f('fk_designer_templates_event_id_events'), 'designer_templates', schema='indico', type_='foreignkey')
op.create_foreign_key(u'fk_designer_templates_event_id_events', 'designer_templates', 'events', ['event_id'], ['id'], referent_schema='events')
op.create_foreign_key(u'fk_designer_templates_category_id_categories', 'designer_templates', 'categories', ['category_id'], ['id'], referent_schema='categories')
op.create_foreign_key(u'fk_designer_templates_backside_template_id_designer_templates', 'designer_templates', 'designer_templates', ['backside_template_id'], ['id'])
op.create_foreign_key(u'fk_designer_templates_background_image_id_designer_image_files', 'designer_templates', 'designer_image_files', ['background_image_id'], ['id'])
op.drop_constraint(op.f('fk_designer_image_files_template_id_designer_templates'), 'designer_image_files', schema='indico', type_='foreignkey')
op.create_foreign_key(u'fk_designer_image_files_template_id_designer_templates', 'designer_image_files', 'designer_templates', ['template_id'], ['id'])