OpenStack Study: 008_remove_bm_pxe_ips_table.py

**** CubicPower OpenStack Study ****

def upgrade(migrate_engine):

    meta = MetaData()

    meta.bind = migrate_engine

    table = Table(table_name, meta, autoload=True)

    table.drop()

**** CubicPower OpenStack Study ****

def downgrade(migrate_engine):

    meta = MetaData()

    meta.bind = migrate_engine

    bm_pxe_ips = Table(table_name, meta,

                       Column('created_at', DateTime),

                       Column('updated_at', DateTime),

                       Column('deleted_at', DateTime),

                       Column('deleted', Boolean),

                       Column('id', Integer, primary_key=True, nullable=False),

                       Column('address', String(length=255), unique=True),

                       Column('bm_node_id', Integer),

                       Column('server_address',

                              String(length=255), unique=True),

                       mysql_engine='InnoDB',

                       )

    bm_pxe_ips.create()

    Index(

        'idx_bm_pxe_ips_bm_node_id_deleted',

        bm_pxe_ips.c.bm_node_id,

        bm_pxe_ips.c.deleted

    ).create(migrate_engine)