def do_upgrade(): """ Implement your upgrades here """ op.rename_table('pid', 'pidSTORE') op.drop_index('idx_object_type_id', 'pidSTORE') op.alter_column( 'pidSTORE', 'type', new_column_name='pid_type', existing_type=mysql.VARCHAR(length=6), nullable=False, existing_server_default='') op.alter_column( 'pidSTORE', 'pid', new_column_name='pid_value', existing_type=mysql.VARCHAR(length=255), nullable=False, existing_server_default='') op.alter_column( 'pidSTORE', 'object_id', new_column_name='object_value', existing_type=mysql.VARCHAR(length=255), nullable=True, existing_server_default='') op.add_column( 'pidSTORE', db.Column('pid_provider', db.String(length=255), nullable=False) )
def do_upgrade(): """ Implement your upgrades here """ op.rename_table('pid', 'pidSTORE') op.drop_index('idx_object_type_id', 'pidSTORE') op.alter_column('pidSTORE', 'type', new_column_name='pid_type', existing_type=mysql.VARCHAR(length=6), nullable=False, existing_server_default='') op.alter_column('pidSTORE', 'pid', new_column_name='pid_value', existing_type=mysql.VARCHAR(length=255), nullable=False, existing_server_default='') op.alter_column('pidSTORE', 'object_id', new_column_name='object_value', existing_type=mysql.VARCHAR(length=255), nullable=True, existing_server_default='') op.add_column( 'pidSTORE', db.Column('pid_provider', db.String(length=255), nullable=False))
def do_upgrade(): """Implement your upgrades here.""" try: op.drop_index('ix_usergroup_name', table_name='usergroup') except OperationalError: pass try: op.drop_index('name', table_name='usergroup') except OperationalError: pass op.create_index(op.f('ix_usergroup_name'), 'usergroup', ['name'], unique=True)