| 123456789101112131415161718192021222324252627282930 |
- """state_to_region
- Revision ID: 661865b159c9
- Revises: 376b13137050
- Create Date: 2019-10-17 23:11:16.074823
- """
- from alembic import op
- import sqlalchemy as sa
- # revision identifiers, used by Alembic.
- revision = '661865b159c9'
- down_revision = '376b13137050'
- branch_labels = None
- depends_on = None
- def upgrade():
- op.add_column('state_market_stat', sa.Column('region_id', sa.Integer(), nullable=True))
- op.drop_constraint('fk_state_market_stat_state_id_state', 'state_market_stat', type_='foreignkey')
- op.create_foreign_key(op.f('fk_state_market_stat_region_id_region'), 'state_market_stat', 'region', ['region_id'], ['id'])
- op.drop_column('state_market_stat', 'state_id')
- def downgrade():
- op.add_column('state_market_stat', sa.Column('state_id', sa.INTEGER(), autoincrement=False, nullable=True))
- op.drop_constraint(op.f('fk_state_market_stat_region_id_region'), 'state_market_stat', type_='foreignkey')
- op.create_foreign_key('fk_state_market_stat_state_id_state', 'state_market_stat', 'state', ['state_id'], ['id'])
- op.drop_column('state_market_stat', 'region_id')
|
