@

Home 

OpenStack Study: 216_havana.py

OpenStack Index

**** CubicPower OpenStack Study ****

def MediumText():

    return Text().with_variant(dialects.mysql.MEDIUMTEXT(), 'mysql')

**** CubicPower OpenStack Study ****

def Inet():

    return String(length=43).with_variant(dialects.postgresql.INET(),

                  'postgresql')

**** CubicPower OpenStack Study ****

def InetSmall():

    return String(length=39).with_variant(dialects.postgresql.INET(),

                  'postgresql')

**** CubicPower OpenStack Study ****

def _create_shadow_tables(migrate_engine):

    meta = MetaData(migrate_engine)

    meta.reflect(migrate_engine)

    table_names = meta.tables.keys()

    meta.bind = migrate_engine

    for table_name in table_names:

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

        columns = []

        for column in table.columns:

            column_copy = None

            # NOTE(boris-42): BigInteger is not supported by sqlite, so

            #                 after copy it will have NullType, other

            #                 types that are used in Nova are supported by

            #                 sqlite.

            if isinstance(column.type, NullType):

                column_copy = Column(column.name, BigInteger(), default=0)

            if table_name == 'instances' and column.name == 'locked_by':

                enum = Enum('owner', 'admin',

                            name='shadow_instances0locked_by')

                column_copy = Column(column.name, enum)

            else:

                column_copy = column.copy()

            columns.append(column_copy)

        shadow_table_name = 'shadow_' + table_name

        shadow_table = Table(shadow_table_name, meta, *columns,

                             mysql_engine='InnoDB')

        try:

            shadow_table.create()

        except Exception:

            LOG.info(repr(shadow_table))

            LOG.exception(_('Exception while creating table.'))

            raise

**** CubicPower OpenStack Study ****

def _populate_instance_types(instance_types_table):

    default_inst_types = {

        'm1.tiny': dict(mem=512, vcpus=1, root_gb=1, eph_gb=0, flavid=1),

        'm1.small': dict(mem=2048, vcpus=1, root_gb=20, eph_gb=0, flavid=2),

        'm1.medium': dict(mem=4096, vcpus=2, root_gb=40, eph_gb=0, flavid=3),

        'm1.large': dict(mem=8192, vcpus=4, root_gb=80, eph_gb=0, flavid=4),

        'm1.xlarge': dict(mem=16384, vcpus=8, root_gb=160, eph_gb=0, flavid=5)

        }

    try:

        i = instance_types_table.insert()

        for name, values in default_inst_types.iteritems():

            i.execute({'name': name, 'memory_mb': values["mem"],

                        'vcpus': values["vcpus"], 'deleted': 0,

                        'root_gb': values["root_gb"],

                        'ephemeral_gb': values["eph_gb"],

                        'rxtx_factor': 1,

                        'swap': 0,

                        'flavorid': values["flavid"],

                        'disabled': False,

                        'is_public': True})

    except Exception:

        LOG.info(repr(instance_types_table))

        LOG.exception(_('Exception while seeding instance_types table'))

        raise

# NOTE(dprince): we add these here so our schema contains dump tables

# which were added in migration 209 (in Havana). We can drop these in

# Icehouse: https://bugs.launchpad.net/nova/+bug/1266538

**** CubicPower OpenStack Study ****

def _create_dump_tables(migrate_engine):

    meta = MetaData(migrate_engine)

    meta.reflect(migrate_engine)

    table_names = ['compute_node_stats', 'compute_nodes', 'instance_actions',

                   'instance_actions_events', 'instance_faults', 'migrations']

    for table_name in table_names:

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

        dump_table_name = 'dump_' + table.name

        columns = []

        for column in table.columns:

            # NOTE(dprince): The dump_ tables were originally created from an

            # earlier schema version so we don't want to add the pci_stats

            # column so that schema diffs are exactly the same.

            if column.name == 'pci_stats':

                continue

            else:

                columns.append(column.copy())

        table_dump = Table(dump_table_name, meta, *columns,

                           mysql_engine='InnoDB')

        table_dump.create()

**** CubicPower OpenStack Study ****

def upgrade(migrate_engine):

    meta = MetaData()

    meta.bind = migrate_engine

    agent_builds = Table('agent_builds', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('hypervisor', String(length=255)),

        Column('os', String(length=255)),

        Column('architecture', String(length=255)),

        Column('version', String(length=255)),

        Column('url', String(length=255)),

        Column('md5hash', String(length=255)),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    aggregate_hosts = Table('aggregate_hosts', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('host', String(length=255)),

        Column('aggregate_id', Integer, ForeignKey('aggregates.id'),

              nullable=False),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    aggregate_metadata = Table('aggregate_metadata', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('aggregate_id', Integer, ForeignKey('aggregates.id'),

              nullable=False),

        Column('key', String(length=255), nullable=False),

        Column('value', String(length=255), nullable=False),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    aggregates = Table('aggregates', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('name', String(length=255)),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    block_device_mapping = Table('block_device_mapping', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('device_name', String(length=255), nullable=True),

        Column('delete_on_termination', Boolean),

        Column('snapshot_id', String(length=36), nullable=True),

        Column('volume_id', String(length=36), nullable=True),

        Column('volume_size', Integer),

        Column('no_device', Boolean),

        Column('connection_info', MediumText()),

        Column('instance_uuid', String(length=36)),

        Column('deleted', Integer),

        Column('source_type', String(length=255), nullable=True),

        Column('destination_type', String(length=255), nullable=True),

        Column('guest_format', String(length=255), nullable=True),

        Column('device_type', String(length=255), nullable=True),

        Column('disk_bus', String(length=255), nullable=True),

        Column('boot_index', Integer),

        Column('image_id', String(length=36), nullable=True),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    bw_usage_cache = Table('bw_usage_cache', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('start_period', DateTime, nullable=False),

        Column('last_refreshed', DateTime),

        Column('bw_in', BigInteger),

        Column('bw_out', BigInteger),

        Column('mac', String(length=255)),

        Column('uuid', String(length=36)),

        Column('last_ctr_in', BigInteger()),

        Column('last_ctr_out', BigInteger()),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    cells = Table('cells', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('api_url', String(length=255)),

        Column('weight_offset', Float),

        Column('weight_scale', Float),

        Column('name', String(length=255)),

        Column('is_parent', Boolean),

        Column('deleted', Integer),

        Column('transport_url', String(length=255), nullable=False),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    certificates = Table('certificates', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('user_id', String(length=255)),

        Column('project_id', String(length=255)),

        Column('file_name', String(length=255)),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    compute_node_stats = Table('compute_node_stats', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('compute_node_id', Integer, nullable=False),

        Column('key', String(length=255), nullable=False),

        Column('value', String(length=255)),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    compute_nodes = Table('compute_nodes', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('service_id', Integer, nullable=False),

        Column('vcpus', Integer, nullable=False),

        Column('memory_mb', Integer, nullable=False),

        Column('local_gb', Integer, nullable=False),

        Column('vcpus_used', Integer, nullable=False),

        Column('memory_mb_used', Integer, nullable=False),

        Column('local_gb_used', Integer, nullable=False),

        Column('hypervisor_type', MediumText(), nullable=False),

        Column('hypervisor_version', Integer, nullable=False),

        Column('cpu_info', MediumText(), nullable=False),

        Column('disk_available_least', Integer),

        Column('free_ram_mb', Integer),

        Column('free_disk_gb', Integer),

        Column('current_workload', Integer),

        Column('running_vms', Integer),

        Column('hypervisor_hostname', String(length=255)),

        Column('deleted', Integer),

        Column('host_ip', InetSmall()),

        Column('supported_instances', Text),

        Column('pci_stats', Text, nullable=True),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    console_pools = Table('console_pools', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('address', InetSmall()),

        Column('username', String(length=255)),

        Column('password', String(length=255)),

        Column('console_type', String(length=255)),

        Column('public_hostname', String(length=255)),

        Column('host', String(length=255)),

        Column('compute_host', String(length=255)),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    consoles = Table('consoles', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('instance_name', String(length=255)),

        Column('password', String(length=255)),

        Column('port', Integer),

        Column('pool_id', Integer, ForeignKey('console_pools.id')),

        Column('instance_uuid', String(length=36),

               ForeignKey('instances.uuid',

                          name='consoles_instance_uuid_fkey')),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    dns_domains = Table('dns_domains', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

        Column('deleted', Boolean),

        Column('domain', String(length=255), primary_key=True, nullable=False),

        Column('scope', String(length=255)),

        Column('availability_zone', String(length=255)),

        Column('project_id', String(length=255)),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    fixed_ips = Table('fixed_ips', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('address', InetSmall()),

        Column('network_id', Integer),

        Column('allocated', Boolean),

        Column('leased', Boolean),

        Column('reserved', Boolean),

        Column('virtual_interface_id', Integer),

        Column('host', String(length=255)),

        Column('instance_uuid', String(length=36)),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    floating_ips = Table('floating_ips', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('address', InetSmall()),

        Column('fixed_ip_id', Integer),

        Column('project_id', String(length=255)),

        Column('host', String(length=255)),

        Column('auto_assigned', Boolean),

        Column('pool', String(length=255)),

        Column('interface', String(length=255)),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    instance_faults = Table('instance_faults', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('instance_uuid', String(length=36)),

        Column('code', Integer, nullable=False),

        Column('message', String(length=255)),

        Column('details', MediumText()),

        Column('host', String(length=255)),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    instance_id_mappings = Table('instance_id_mappings', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('uuid', String(36), nullable=False),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    instance_info_caches = Table('instance_info_caches', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('network_info', MediumText()),

        Column('instance_uuid', String(length=36), nullable=False),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    groups = Table('instance_groups', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

        Column('deleted', Integer),

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

        Column('user_id', String(length=255)),

        Column('project_id', String(length=255)),

        Column('uuid', String(length=36), nullable=False),

        Column('name', String(length=255)),

        UniqueConstraint('uuid', 'deleted',

                         name='uniq_instance_groups0uuid0deleted'),

        mysql_engine='InnoDB',

        mysql_charset='utf8',

    )

    group_metadata = Table('instance_group_metadata', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

        Column('deleted', Integer),

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

        Column('key', String(length=255)),

        Column('value', String(length=255)),

        Column('group_id', Integer, ForeignKey('instance_groups.id'),

               nullable=False),

        mysql_engine='InnoDB',

        mysql_charset='utf8',

    )

    group_policy = Table('instance_group_policy', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

        Column('deleted', Integer),

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

        Column('policy', String(length=255)),

        Column('group_id', Integer, ForeignKey('instance_groups.id'),

               nullable=False),

        mysql_engine='InnoDB',

        mysql_charset='utf8',

    )

    group_member = Table('instance_group_member', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

        Column('deleted', Integer),

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

        Column('instance_id', String(length=255)),

        Column('group_id', Integer, ForeignKey('instance_groups.id'),

               nullable=False),

        mysql_engine='InnoDB',

        mysql_charset='utf8',

    )

    instance_metadata = Table('instance_metadata', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('key', String(length=255)),

        Column('value', String(length=255)),

        Column('instance_uuid', String(length=36), nullable=True),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    instance_system_metadata = Table('instance_system_metadata', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('instance_uuid', String(length=36), nullable=False),

        Column('key', String(length=255), nullable=False),

        Column('value', String(length=255)),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    instance_type_extra_specs = Table('instance_type_extra_specs', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('instance_type_id', Integer, ForeignKey('instance_types.id'),

               nullable=False),

        Column('key', String(length=255)),

        Column('value', String(length=255)),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    instance_type_projects = Table('instance_type_projects', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('instance_type_id', Integer, nullable=False),

        Column('project_id', String(length=255)),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    instance_types = Table('instance_types', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

        Column('name', String(length=255)),

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

        Column('memory_mb', Integer, nullable=False),

        Column('vcpus', Integer, nullable=False),

        Column('swap', Integer, nullable=False),

        Column('vcpu_weight', Integer),

        Column('flavorid', String(length=255)),

        Column('rxtx_factor', Float),

        Column('root_gb', Integer),

        Column('ephemeral_gb', Integer),

        Column('disabled', Boolean),

        Column('is_public', Boolean),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    inst_lock_enum = Enum('owner', 'admin', name='instances0locked_by')

    instances = Table('instances', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('internal_id', Integer),

        Column('user_id', String(length=255)),

        Column('project_id', String(length=255)),

        Column('image_ref', String(length=255)),

        Column('kernel_id', String(length=255)),

        Column('ramdisk_id', String(length=255)),

        Column('launch_index', Integer),

        Column('key_name', String(length=255)),

        Column('key_data', MediumText()),

        Column('power_state', Integer),

        Column('vm_state', String(length=255)),

        Column('memory_mb', Integer),

        Column('vcpus', Integer),

        Column('hostname', String(length=255)),

        Column('host', String(length=255)),

        Column('user_data', MediumText()),

        Column('reservation_id', String(length=255)),

        Column('scheduled_at', DateTime),

        Column('launched_at', DateTime),

        Column('terminated_at', DateTime),

        Column('display_name', String(length=255)),

        Column('display_description', String(length=255)),

        Column('availability_zone', String(length=255)),

        Column('locked', Boolean),

        Column('os_type', String(length=255)),

        Column('launched_on', MediumText()),

        Column('instance_type_id', Integer),

        Column('vm_mode', String(length=255)),

        Column('uuid', String(length=36)),

        Column('architecture', String(length=255)),

        Column('root_device_name', String(length=255)),

        Column('access_ip_v4', InetSmall()),

        Column('access_ip_v6', InetSmall()),

        Column('config_drive', String(length=255)),

        Column('task_state', String(length=255)),

        Column('default_ephemeral_device', String(length=255)),

        Column('default_swap_device', String(length=255)),

        Column('progress', Integer),

        Column('auto_disk_config', Boolean),

        Column('shutdown_terminate', Boolean),

        Column('disable_terminate', Boolean),

        Column('root_gb', Integer),

        Column('ephemeral_gb', Integer),

        Column('cell_name', String(length=255)),

        Column('node', String(length=255)),

        Column('deleted', Integer),

        Column('locked_by', inst_lock_enum),

        Column('cleaned', Integer, default=0),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    instance_actions = Table('instance_actions', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('action', String(length=255)),

        Column('instance_uuid', String(length=36)),

        Column('request_id', String(length=255)),

        Column('user_id', String(length=255)),

        Column('project_id', String(length=255)),

        Column('start_time', DateTime),

        Column('finish_time', DateTime),

        Column('message', String(length=255)),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8',

    )

    instance_actions_events = Table('instance_actions_events', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('event', String(length=255)),

        Column('action_id', Integer, ForeignKey('instance_actions.id')),

        Column('start_time', DateTime),

        Column('finish_time', DateTime),

        Column('result', String(length=255)),

        Column('traceback', Text),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8',

    )

    iscsi_targets = Table('iscsi_targets', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('target_num', Integer),

        Column('host', String(length=255)),

        Column('volume_id', String(length=36), nullable=True),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    key_pairs = Table('key_pairs', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('name', String(length=255)),

        Column('user_id', String(length=255)),

        Column('fingerprint', String(length=255)),

        Column('public_key', MediumText()),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    migrations = Table('migrations', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('source_compute', String(length=255)),

        Column('dest_compute', String(length=255)),

        Column('dest_host', String(length=255)),

        Column('status', String(length=255)),

        Column('instance_uuid', String(length=36)),

        Column('old_instance_type_id', Integer),

        Column('new_instance_type_id', Integer),

        Column('source_node', String(length=255)),

        Column('dest_node', String(length=255)),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    networks = Table('networks', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('injected', Boolean),

        Column('cidr', Inet()),

        Column('netmask', InetSmall()),

        Column('bridge', String(length=255)),

        Column('gateway', InetSmall()),

        Column('broadcast', InetSmall()),

        Column('dns1', InetSmall()),

        Column('vlan', Integer),

        Column('vpn_public_address', InetSmall()),

        Column('vpn_public_port', Integer),

        Column('vpn_private_address', InetSmall()),

        Column('dhcp_start', InetSmall()),

        Column('project_id', String(length=255)),

        Column('host', String(length=255)),

        Column('cidr_v6', Inet()),

        Column('gateway_v6', InetSmall()),

        Column('label', String(length=255)),

        Column('netmask_v6', InetSmall()),

        Column('bridge_interface', String(length=255)),

        Column('multi_host', Boolean),

        Column('dns2', InetSmall()),

        Column('uuid', String(length=36)),

        Column('priority', Integer),

        Column('rxtx_base', Integer),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    pci_devices_uc_name = 'uniq_pci_devices0compute_node_id0address0deleted'

    pci_devices = Table('pci_devices', meta,

        Column('created_at', DateTime(timezone=False)),

        Column('updated_at', DateTime(timezone=False)),

        Column('deleted_at', DateTime(timezone=False)),

        Column('deleted', Integer, default=0, nullable=False),

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

        Column('compute_node_id', Integer, nullable=False),

        Column('address', String(12), nullable=False),

        Column('product_id', String(4)),

        Column('vendor_id', String(4)),

        Column('dev_type', String(8)),

        Column('dev_id', String(255)),

        Column('label', String(255), nullable=False),

        Column('status', String(36), nullable=False),

        Column('extra_info', Text, nullable=True),

        Column('instance_uuid', String(36), nullable=True),

        Index('ix_pci_devices_compute_node_id_deleted',

              'compute_node_id', 'deleted'),

        Index('ix_pci_devices_instance_uuid_deleted',

              'instance_uuid', 'deleted'),

        UniqueConstraint('compute_node_id',

                        'address', 'deleted',

                        name=pci_devices_uc_name),

        mysql_engine='InnoDB',

        mysql_charset='utf8')

    provider_fw_rules = Table('provider_fw_rules', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('protocol', String(length=5)),

        Column('from_port', Integer),

        Column('to_port', Integer),

        Column('cidr', Inet()),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    quota_classes = Table('quota_classes', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('class_name', String(length=255)),

        Column('resource', String(length=255)),

        Column('hard_limit', Integer),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    quota_usages = Table('quota_usages', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('project_id', String(length=255)),

        Column('resource', String(length=255)),

        Column('in_use', Integer, nullable=False),

        Column('reserved', Integer, nullable=False),

        Column('until_refresh', Integer),

        Column('deleted', Integer),

        Column('user_id', String(length=255)),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    quotas = Table('quotas', meta,

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

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

        Column('project_id', String(length=255)),

        Column('resource', String(length=255), nullable=False),

        Column('hard_limit', Integer),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    uniq_name = "uniq_project_user_quotas0user_id0project_id0resource0deleted"

    project_user_quotas = Table('project_user_quotas', meta,

                        Column('id', Integer, primary_key=True,

                               nullable=False),

                        Column('created_at', DateTime),

                        Column('updated_at', DateTime),

                        Column('deleted_at', DateTime),

                        Column('deleted', Integer),

                        Column('user_id',

                               String(length=255),

                               nullable=False),

                        Column('project_id',

                               String(length=255),

                               nullable=False),

                        Column('resource',

                               String(length=255),

                               nullable=False),

                        Column('hard_limit', Integer, nullable=True),

                        UniqueConstraint('user_id', 'project_id', 'resource',

                                         'deleted', name=uniq_name),

                        mysql_engine='InnoDB',

                        mysql_charset='utf8',

                        )

    reservations = Table('reservations', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('uuid', String(length=36), nullable=False),

        Column('usage_id', Integer, nullable=False),

        Column('project_id', String(length=255)),

        Column('resource', String(length=255)),

        Column('delta', Integer, nullable=False),

        Column('expire', DateTime),

        Column('deleted', Integer),

        Column('user_id', String(length=255)),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    s3_images = Table('s3_images', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('uuid', String(length=36), nullable=False),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    security_group_instance_association = \

        Table('security_group_instance_association', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('security_group_id', Integer),

        Column('instance_uuid', String(length=36)),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    security_group_rules = Table('security_group_rules', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('parent_group_id', Integer, ForeignKey('security_groups.id')),

        Column('protocol', String(length=255)),

        Column('from_port', Integer),

        Column('to_port', Integer),

        Column('cidr', Inet()),

        Column('group_id', Integer, ForeignKey('security_groups.id')),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    security_groups = Table('security_groups', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('name', String(length=255)),

        Column('description', String(length=255)),

        Column('user_id', String(length=255)),

        Column('project_id', String(length=255)),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    security_group_default_rules = Table('security_group_default_rules', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

        Column('deleted', Integer, default=0),

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

        Column('protocol', String(length=5)),

        Column('from_port', Integer),

        Column('to_port', Integer),

        Column('cidr', Inet()),

        mysql_engine='InnoDB',

        mysql_charset='utf8',

    )

    services = Table('services', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('host', String(length=255)),

        Column('binary', String(length=255)),

        Column('topic', String(length=255)),

        Column('report_count', Integer, nullable=False),

        Column('disabled', Boolean),

        Column('deleted', Integer),

        Column('disabled_reason', String(length=255)),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    snapshot_id_mappings = Table('snapshot_id_mappings', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('uuid', String(length=36), nullable=False),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    snapshots = Table('snapshots', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

        Column('id', String(length=36), primary_key=True, nullable=False),

        Column('volume_id', String(length=36), nullable=False),

        Column('user_id', String(length=255)),

        Column('project_id', String(length=255)),

        Column('status', String(length=255)),

        Column('progress', String(length=255)),

        Column('volume_size', Integer),

        Column('scheduled_at', DateTime),

        Column('display_name', String(length=255)),

        Column('display_description', String(length=255)),

        Column('deleted', String(length=36)),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    task_log = Table('task_log', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('task_name', String(length=255), nullable=False),

        Column('state', String(length=255), nullable=False),

        Column('host', String(length=255), nullable=False),

        Column('period_beginning', DateTime, nullable=False),

        Column('period_ending', DateTime, nullable=False),

        Column('message', String(length=255), nullable=False),

        Column('task_items', Integer),

        Column('errors', Integer),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    virtual_interfaces = Table('virtual_interfaces', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

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

        Column('network_id', Integer),

        Column('uuid', String(length=36)),

        Column('instance_uuid', String(length=36), nullable=True),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    volume_id_mappings = Table('volume_id_mappings', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

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

        Column('uuid', String(length=36), nullable=False),

        Column('deleted', Integer),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    volumes = Table('volumes', meta,

        Column('created_at', DateTime),

        Column('updated_at', DateTime),

        Column('deleted_at', DateTime),

        Column('id', String(length=36), primary_key=True, nullable=False),

        Column('ec2_id', String(length=255)),

        Column('user_id', String(length=255)),

        Column('project_id', String(length=255)),

        Column('host', String(length=255)),

        Column('size', Integer),

        Column('availability_zone', String(length=255)),

        Column('mountpoint', String(length=255)),

        Column('status', String(length=255)),

        Column('attach_status', String(length=255)),

        Column('scheduled_at', DateTime),

        Column('launched_at', DateTime),

        Column('terminated_at', DateTime),

        Column('display_name', String(length=255)),

        Column('display_description', String(length=255)),

        Column('provider_location', String(length=256)),

        Column('provider_auth', String(length=256)),

        Column('snapshot_id', String(length=36)),

        Column('volume_type_id', Integer),

        Column('instance_uuid', String(length=36)),

        Column('attach_time', DateTime),

        Column('deleted', String(length=36)),

        mysql_engine='InnoDB',

        mysql_charset='utf8'

    )

    volume_usage_cache = Table('volume_usage_cache', meta,

            Column('created_at', DateTime(timezone=False)),

            Column('updated_at', DateTime(timezone=False)),

            Column('deleted_at', DateTime(timezone=False)),

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

            Column('volume_id', String(36), nullable=False),

            Column('tot_last_refreshed', DateTime(timezone=False)),

            Column('tot_reads', BigInteger(), default=0),

            Column('tot_read_bytes', BigInteger(), default=0),

            Column('tot_writes', BigInteger(), default=0),

            Column('tot_write_bytes', BigInteger(), default=0),

            Column('curr_last_refreshed', DateTime(timezone=False)),

            Column('curr_reads', BigInteger(), default=0),

            Column('curr_read_bytes', BigInteger(), default=0),

            Column('curr_writes', BigInteger(), default=0),

            Column('curr_write_bytes', BigInteger(), default=0),

            Column('deleted', Integer),

            Column("instance_uuid", String(length=36)),

            Column("project_id", String(length=36)),

            Column("user_id", String(length=36)),

            Column("availability_zone", String(length=255)),

            mysql_engine='InnoDB',

            mysql_charset='utf8'

    )

    instances.create()

    Index('project_id', instances.c.project_id).create()

    Index('uuid', instances.c.uuid, unique=True).create()

    # create all tables

    tables = [aggregates, console_pools, instance_types,

              security_groups, snapshots, volumes,

              # those that are children and others later

              agent_builds, aggregate_hosts, aggregate_metadata,

              block_device_mapping, bw_usage_cache, cells,

              certificates, compute_node_stats, compute_nodes, consoles,

              dns_domains, fixed_ips, floating_ips,

              instance_faults, instance_id_mappings, instance_info_caches,

              instance_metadata, instance_system_metadata,

              instance_type_extra_specs, instance_type_projects,

              instance_actions, instance_actions_events,

              groups, group_metadata, group_policy, group_member,

              iscsi_targets, key_pairs, migrations, networks,

              pci_devices, provider_fw_rules, quota_classes, quota_usages,

              quotas, project_user_quotas,

              reservations, s3_images, security_group_instance_association,

              security_group_rules, security_group_default_rules,

              services, snapshot_id_mappings, task_log,

              virtual_interfaces,

              volume_id_mappings,

              volume_usage_cache]

    for table in tables:

        try:

            table.create()

        except Exception:

            LOG.info(repr(table))

            LOG.exception(_('Exception while creating table.'))

            raise

    # task log unique constraint

    task_log_uc = "uniq_task_log0task_name0host0period_beginning0period_ending"

    task_log_cols = ('task_name', 'host', 'period_beginning', 'period_ending')

    uc = UniqueConstraint(*task_log_cols, table=task_log, name=task_log_uc)

    uc.create()

    # networks unique constraint

    UniqueConstraint('vlan', 'deleted', table=networks,

                     name='uniq_networks0vlan0deleted').create()

    # instance_type_name constraint

    UniqueConstraint('name', 'deleted', table=instance_types,

                     name='uniq_instance_types0name0deleted').create()

    # flavorid unique constraint

    UniqueConstraint('flavorid', 'deleted', table=instance_types,

                     name='uniq_instance_types0flavorid0deleted').create()

    # keypair contraint

    UniqueConstraint('user_id', 'name', 'deleted', table=key_pairs,

                     name='uniq_key_pairs0user_id0name0deleted').create()

    # instance_type_projects constraint

    inst_type_uc_name = 'uniq_instance_type_projects0instance_type_id0' + \

                        'project_id0deleted'

    UniqueConstraint('instance_type_id', 'project_id', 'deleted',

                     table=instance_type_projects,

                     name=inst_type_uc_name).create()

    # floating_ips unique constraint

    UniqueConstraint('address', 'deleted',

                     table=floating_ips,

                     name='uniq_floating_ips0address0deleted').create()

    # instance_info_caches

    UniqueConstraint('instance_uuid',

                     table=instance_info_caches,

                     name='uniq_instance_info_caches0instance_uuid').create()

    UniqueConstraint('address', 'deleted',

                     table=virtual_interfaces,

                     name='uniq_virtual_interfaces0address0deleted').create()

    # cells

    UniqueConstraint('name', 'deleted',

                     table=cells,

                     name='uniq_cells0name0deleted').create()

    # security_groups

    uc = UniqueConstraint('project_id', 'name', 'deleted',

                     table=security_groups,

                     name='uniq_security_groups0project_id0name0deleted')

    uc.create()

    # quotas

    UniqueConstraint('project_id', 'resource', 'deleted',

                     table=quotas,

                     name='uniq_quotas0project_id0resource0deleted').create()

    # fixed_ips

    UniqueConstraint('address', 'deleted',

                     table=fixed_ips,

                     name='uniq_fixed_ips0address0deleted').create()

    # services

    UniqueConstraint('host', 'topic', 'deleted',

                     table=services,

                     name='uniq_services0host0topic0deleted').create()

    UniqueConstraint('host', 'binary', 'deleted',

                     table=services,

                     name='uniq_services0host0binary0deleted').create()

    # agent_builds

    uc_name = 'uniq_agent_builds0hypervisor0os0architecture0deleted'

    UniqueConstraint('hypervisor', 'os', 'architecture', 'deleted',

                     table=agent_builds,

                     name=uc_name).create()

    uc_name = 'uniq_console_pools0host0console_type0compute_host0deleted'

    UniqueConstraint('host', 'console_type', 'compute_host', 'deleted',

                     table=console_pools,

                     name=uc_name).create()

    uc_name = 'uniq_aggregate_hosts0host0aggregate_id0deleted'

    UniqueConstraint('host', 'aggregate_id', 'deleted',

                     table=aggregate_hosts,

                     name=uc_name).create()

    uc_name = 'uniq_aggregate_metadata0aggregate_id0key0deleted'

    UniqueConstraint('aggregate_id', 'key', 'deleted',

                     table=aggregate_metadata,

                     name=uc_name).create()

    uc_name = 'uniq_instance_type_extra_specs0instance_type_id0key0deleted'

    UniqueConstraint('instance_type_id', 'key', 'deleted',

                     table=instance_type_extra_specs,

                     name=uc_name).create()

    # created first (to preserve ordering for schema diffs)

    mysql_pre_indexes = [

        Index('instance_type_id', instance_type_projects.c.instance_type_id),

        Index('project_id', dns_domains.c.project_id),

        Index('fixed_ip_id', floating_ips.c.fixed_ip_id),

        Index('network_id', virtual_interfaces.c.network_id),

        Index('network_id', fixed_ips.c.network_id),

        Index('fixed_ips_virtual_interface_id_fkey',

                  fixed_ips.c.virtual_interface_id),

        Index('address', fixed_ips.c.address),

        Index('fixed_ips_instance_uuid_fkey', fixed_ips.c.instance_uuid),

        Index('instance_uuid', instance_system_metadata.c.instance_uuid),

        Index('iscsi_targets_volume_id_fkey', iscsi_targets.c.volume_id),

        Index('snapshot_id', block_device_mapping.c.snapshot_id),

        Index('usage_id', reservations.c.usage_id),

        Index('virtual_interfaces_instance_uuid_fkey',

              virtual_interfaces.c.instance_uuid),

        Index('volume_id', block_device_mapping.c.volume_id),

        Index('security_group_id',

              security_group_instance_association.c.security_group_id),

    ]

    # Common indexes (indexes we apply to all databases)

    # NOTE: order specific for MySQL diff support

    common_indexes = [

        # aggregate_metadata

        Index('aggregate_metadata_key_idx', aggregate_metadata.c.key),

        # agent_builds

        Index('agent_builds_hypervisor_os_arch_idx',

              agent_builds.c.hypervisor,

              agent_builds.c.os,

              agent_builds.c.architecture),

        # block_device_mapping

        Index('block_device_mapping_instance_uuid_idx',

              block_device_mapping.c.instance_uuid),

        Index('block_device_mapping_instance_uuid_device_name_idx',

              block_device_mapping.c.instance_uuid,

              block_device_mapping.c.device_name),

        # NOTE(dprince): This is now a duplicate index on MySQL and needs to

        # be removed there. We leave it here so the Index ordering

        # matches on schema diffs (for MySQL).

        # See Havana migration 186_new_bdm_format where we dropped the

        # virtual_name column.

        # IceHouse fix is here: https://bugs.launchpad.net/nova/+bug/1265839

        Index(

             'block_device_mapping_instance_uuid_virtual_name_device_name_idx',

             block_device_mapping.c.instance_uuid,

             block_device_mapping.c.device_name),

        Index('block_device_mapping_instance_uuid_volume_id_idx',

              block_device_mapping.c.instance_uuid,

              block_device_mapping.c.volume_id),

        # bw_usage_cache

        Index('bw_usage_cache_uuid_start_period_idx',

              bw_usage_cache.c.uuid, bw_usage_cache.c.start_period),

        Index('certificates_project_id_deleted_idx',

              certificates.c.project_id, certificates.c.deleted),

        Index('certificates_user_id_deleted_idx', certificates.c.user_id,

              certificates.c.deleted),

        # compute_node_stats

        Index('ix_compute_node_stats_compute_node_id',

              compute_node_stats.c.compute_node_id),

        Index('compute_node_stats_node_id_and_deleted_idx',

              compute_node_stats.c.compute_node_id,

              compute_node_stats.c.deleted),

        # consoles

        Index('consoles_instance_uuid_idx', consoles.c.instance_uuid),

        # dns_domains

        Index('dns_domains_domain_deleted_idx',

              dns_domains.c.domain, dns_domains.c.deleted),

        # fixed_ips

        Index('fixed_ips_host_idx', fixed_ips.c.host),

        Index('fixed_ips_network_id_host_deleted_idx', fixed_ips.c.network_id,

              fixed_ips.c.host, fixed_ips.c.deleted),

        Index('fixed_ips_address_reserved_network_id_deleted_idx',

              fixed_ips.c.address, fixed_ips.c.reserved,

              fixed_ips.c.network_id, fixed_ips.c.deleted),

        Index('fixed_ips_deleted_allocated_idx', fixed_ips.c.address,

              fixed_ips.c.deleted, fixed_ips.c.allocated),

        # floating_ips

        Index('floating_ips_host_idx', floating_ips.c.host),

        Index('floating_ips_project_id_idx', floating_ips.c.project_id),

        Index('floating_ips_pool_deleted_fixed_ip_id_project_id_idx',

              floating_ips.c.pool, floating_ips.c.deleted,

              floating_ips.c.fixed_ip_id, floating_ips.c.project_id),

        # group_member

        Index('instance_group_member_instance_idx',

              group_member.c.instance_id),

        # group_metadata

        Index('instance_group_metadata_key_idx', group_metadata.c.key),

        # group_policy

        Index('instance_group_policy_policy_idx', group_policy.c.policy),

        # instances

        Index('instances_reservation_id_idx',

              instances.c.reservation_id),

        Index('instances_terminated_at_launched_at_idx',

              instances.c.terminated_at,

              instances.c.launched_at),

        Index('instances_task_state_updated_at_idx',

              instances.c.task_state,

              instances.c.updated_at),

        Index('instances_host_deleted_idx', instances.c.host,

              instances.c.deleted),

        Index('instances_uuid_deleted_idx', instances.c.uuid,

              instances.c.deleted),

        Index('instances_host_node_deleted_idx', instances.c.host,

              instances.c.node, instances.c.deleted),

        Index('instances_host_deleted_cleaned_idx',

                          instances.c.host, instances.c.deleted,

                          instances.c.cleaned),

        # instance_actions

        Index('instance_uuid_idx', instance_actions.c.instance_uuid),

        Index('request_id_idx', instance_actions.c.request_id),

        # instance_faults

        Index('instance_faults_host_idx', instance_faults.c.host),

        Index('instance_faults_instance_uuid_deleted_created_at_idx',

              instance_faults.c.instance_uuid, instance_faults.c.deleted,

              instance_faults.c.created_at),

        # instance_id_mappings

        Index('ix_instance_id_mappings_uuid', instance_id_mappings.c.uuid),

        # instance_metadata

        Index('instance_metadata_instance_uuid_idx',

              instance_metadata.c.instance_uuid),

        # instance_type_extra_specs

        Index('instance_type_extra_specs_instance_type_id_key_idx',

              instance_type_extra_specs.c.instance_type_id,

              instance_type_extra_specs.c.key),

        # iscsi_targets

        Index('iscsi_targets_host_idx', iscsi_targets.c.host),

        Index('iscsi_targets_host_volume_id_deleted_idx',

              iscsi_targets.c.host, iscsi_targets.c.volume_id,

              iscsi_targets.c.deleted),

        # migrations

        Index('migrations_by_host_nodes_and_status_idx',

              migrations.c.deleted, migrations.c.source_compute,

              migrations.c.dest_compute, migrations.c.source_node,

              migrations.c.dest_node, migrations.c.status),

        Index('migrations_instance_uuid_and_status_idx',

              migrations.c.deleted, migrations.c.instance_uuid,

              migrations.c.status),

        # networks

        Index('networks_host_idx', networks.c.host),

        Index('networks_cidr_v6_idx', networks.c.cidr_v6),

        Index('networks_bridge_deleted_idx', networks.c.bridge,

              networks.c.deleted),

        Index('networks_project_id_deleted_idx', networks.c.project_id,

              networks.c.deleted),

        Index('networks_uuid_project_id_deleted_idx',

              networks.c.uuid, networks.c.project_id, networks.c.deleted),

        Index('networks_vlan_deleted_idx', networks.c.vlan,

              networks.c.deleted),

        # project_user_quotas

        Index('project_user_quotas_project_id_deleted_idx',

              project_user_quotas.c.project_id,

              project_user_quotas.c.deleted),

        Index('project_user_quotas_user_id_deleted_idx',

              project_user_quotas.c.user_id, project_user_quotas.c.deleted),

        # reservations

        Index('ix_reservations_project_id', reservations.c.project_id),

        Index('ix_reservations_user_id_deleted',

              reservations.c.user_id, reservations.c.deleted),

        Index('reservations_uuid_idx', reservations.c.uuid),

        # security_group_instance_association

        Index('security_group_instance_association_instance_uuid_idx',

              security_group_instance_association.c.instance_uuid),

        # task_log

        Index('ix_task_log_period_beginning', task_log.c.period_beginning),

        Index('ix_task_log_host', task_log.c.host),

        Index('ix_task_log_period_ending', task_log.c.period_ending),

        # quota_classes

        Index('ix_quota_classes_class_name', quota_classes.c.class_name),

        # quota_usages

        Index('ix_quota_usages_project_id', quota_usages.c.project_id),

        Index('ix_quota_usages_user_id_deleted',

              quota_usages.c.user_id, quota_usages.c.deleted),

        # volumes

        Index('volumes_instance_uuid_idx', volumes.c.instance_uuid),

    ]

    # MySQL specific indexes

    if migrate_engine.name == 'mysql':

        for index in mysql_pre_indexes:

            index.create(migrate_engine)

        # mysql-specific index by leftmost 100 chars.  (mysql gets angry if the

        # index key length is too long.)

        sql = ("create index migrations_by_host_nodes_and_status_idx ON "

               "migrations (deleted, source_compute(100), dest_compute(100), "

               "source_node(100), dest_node(100), status)")

        migrate_engine.execute(sql)

    # PostgreSQL specific indexes

    if migrate_engine.name == 'postgresql':

        Index('address', fixed_ips.c.address).create()

    # NOTE(dprince): PostgreSQL doesn't allow duplicate indexes

    # so we skip creation of select indexes (so schemas match exactly).

    POSTGRES_INDEX_SKIPS = [

        # See Havana migration 186_new_bdm_format where we dropped the

        # virtual_name column.

        # IceHouse fix is here: https://bugs.launchpad.net/nova/+bug/1265839

        'block_device_mapping_instance_uuid_virtual_name_device_name_idx'

    ]

    MYSQL_INDEX_SKIPS = [

        # we create this one manually for MySQL above

        'migrations_by_host_nodes_and_status_idx'

    ]

    for index in common_indexes:

        if migrate_engine.name == 'postgresql' and \

            index.name in POSTGRES_INDEX_SKIPS:

            continue

        if migrate_engine.name == 'mysql' and \

            index.name in MYSQL_INDEX_SKIPS:

            continue

        else:

            index.create(migrate_engine)

    Index('project_id', dns_domains.c.project_id).drop

    fkeys = [

              [[fixed_ips.c.instance_uuid],

                  [instances.c.uuid],

                  'fixed_ips_instance_uuid_fkey'],

              [[block_device_mapping.c.instance_uuid],

                  [instances.c.uuid],

                  'block_device_mapping_instance_uuid_fkey'],

              [[instance_info_caches.c.instance_uuid],

                  [instances.c.uuid],

                  'instance_info_caches_instance_uuid_fkey'],

              [[instance_metadata.c.instance_uuid],

                  [instances.c.uuid],

                  'instance_metadata_instance_uuid_fkey'],

              [[instance_system_metadata.c.instance_uuid],

                  [instances.c.uuid],

                  'instance_system_metadata_ibfk_1'],

              [[instance_type_projects.c.instance_type_id],

                  [instance_types.c.id],

                  'instance_type_projects_ibfk_1'],

              [[iscsi_targets.c.volume_id],

                  [volumes.c.id],

                  'iscsi_targets_volume_id_fkey'],

              [[reservations.c.usage_id],

                  [quota_usages.c.id],

                  'reservations_ibfk_1'],

              [[security_group_instance_association.c.instance_uuid],

                  [instances.c.uuid],

                  'security_group_instance_association_instance_uuid_fkey'],

              [[security_group_instance_association.c.security_group_id],

                  [security_groups.c.id],

                  'security_group_instance_association_ibfk_1'],

              [[virtual_interfaces.c.instance_uuid],

                  [instances.c.uuid],

                  'virtual_interfaces_instance_uuid_fkey'],

              [[compute_node_stats.c.compute_node_id],

                  [compute_nodes.c.id],

                  'fk_compute_node_stats_compute_node_id'],

              [[compute_nodes.c.service_id],

                  [services.c.id],

                  'fk_compute_nodes_service_id'],

              [[instance_actions.c.instance_uuid],

                  [instances.c.uuid],

                  'fk_instance_actions_instance_uuid'],

              [[instance_faults.c.instance_uuid],

                  [instances.c.uuid],

                  'fk_instance_faults_instance_uuid'],

              [[migrations.c.instance_uuid],

                  [instances.c.uuid],

                  'fk_migrations_instance_uuid'],

            ]

    for fkey_pair in fkeys:

        if migrate_engine.name == 'mysql':

            # For MySQL we name our fkeys explicitly so they match Havana

            fkey = ForeignKeyConstraint(columns=fkey_pair[0],

                                   refcolumns=fkey_pair[1],

                                   name=fkey_pair[2])

            fkey.create()

        elif migrate_engine.name == 'postgresql':

            # PostgreSQL names things like it wants (correct and compatible!)

            fkey = ForeignKeyConstraint(columns=fkey_pair[0],

                                   refcolumns=fkey_pair[1])

            fkey.create()

    if migrate_engine.name == "mysql":

        # In Folsom we explicitly converted migrate_version to UTF8.

        sql = "ALTER TABLE migrate_version CONVERT TO CHARACTER SET utf8;"

        # Set default DB charset to UTF8.

        sql += "ALTER DATABASE %s DEFAULT CHARACTER SET utf8;" % \

                migrate_engine.url.database

        migrate_engine.execute(sql)

    _create_shadow_tables(migrate_engine)

    # populate initial instance types

    _populate_instance_types(instance_types)

    _create_dump_tables(migrate_engine)

**** CubicPower OpenStack Study ****

def downgrade(migrate_engine):

    raise NotImplementedError('Downgrade from Havana is unsupported.')