new_contents: """change column user.province_id to user.associate_group_id
  
  Revision ID: 91b7a3d00a9e
  Revises: 84fc7bc201e6
  Create Date: 2017-10-25 08:00:01.999168
  
  """
  
  # revision identifiers, used by Alembic.
  revision = '91b7a3d00a9e'
  down_revision = '84fc7bc201e6'
  
  from alembic import op
  import sqlalchemy as sa
  from sqlalchemy.dialects import mysql
  
  def upgrade():
      # ### commands auto generated by Alembic - please adjust! ###
      op.add_column('user', sa.Column('associate_group_id', sa.String(length=64), nullable=True))
      op.drop_constraint('user_ibfk_1', 'user', type_='foreignkey')
      op.create_foreign_key(None, 'user', 'associate_group', ['associate_group_id'], ['id'])
      op.drop_column('user', 'province_id')
      # ### end Alembic commands ###
  
  
  def downgrade():
      # ### commands auto generated by Alembic - please adjust! ###
      op.add_column('user', sa.Column('province_id', mysql.VARCHAR(length=64), nullable=True))
      op.drop_constraint(None, 'user', type_='foreignkey')
      op.create_foreign_key('user_ibfk_1', 'user', 'province', ['province_id'], ['province_id'])
      op.drop_column('user', 'associate_group_id')
      # ### end Alembic commands ###
  
subject: change column user.province_id to user.associate_gorup_id in user model