#NEWLINE# def upgrade( migrate_engine ) : #NEWLINE# #INDENT# meta = MetaData ( ) #NEWLINE# meta . bind = migrate_engine #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# consoles_instance_uuid_column_args = [ 'instance_uuid' , String ( length = 36 ) ] #NEWLINE# if ( migrate_engine . name != 'ibm_db_sa' ) : #NEWLINE# #INDENT# consoles_instance_uuid_column_args . append ( ForeignKey ( 'instances.uuid' , name = 'consoles_instance_uuid_fkey' ) ) #NEWLINE# #UNINDENT# 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 ( * consoles_instance_uuid_column_args ) , Column ( 'deleted' , Integer ) , mysql_engine = 'InnoDB' , mysql_charset = 'utf8' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# inst_lock_enum = Enum ( 'owner' , 'admin' , name = 'instances0locked_by' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# pci_devices_uc_name = 'uniq_pci_devices0compute_node_id0address0deleted' #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# uniq_name = 'uniq_project_user_quotas0user_id0project_id0resource0deleted' #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# 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' ) #NEWLINE# instances . create ( ) #NEWLINE# Index ( 'project_id' , instances . c . project_id ) . create ( ) #NEWLINE# Index ( 'uuid' , instances . c . uuid , unique = True ) . create ( ) #NEWLINE# tables = [ aggregates , console_pools , instance_types , security_groups , snapshots , volumes , 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 ] #NEWLINE# for table in tables : #NEWLINE# #INDENT# try : #NEWLINE# #INDENT# table . create ( ) #NEWLINE# #UNINDENT# except Exception : #NEWLINE# #INDENT# LOG . info ( repr ( table ) ) #NEWLINE# LOG . exception ( _LE ( 'Exception while creating table.' ) ) #NEWLINE# raise #NEWLINE# #UNINDENT# #UNINDENT# task_log_uc = 'uniq_task_log0task_name0host0period_beginning0period_ending' #NEWLINE# task_log_cols = ( 'task_name' , 'host' , 'period_beginning' , 'period_ending' ) #NEWLINE# uc = UniqueConstraint ( * task_log_cols , table = task_log , name = task_log_uc ) #NEWLINE# uc . create ( ) #NEWLINE# UniqueConstraint ( 'vlan' , 'deleted' , table = networks , name = 'uniq_networks0vlan0deleted' ) . create ( ) #NEWLINE# UniqueConstraint ( 'name' , 'deleted' , table = instance_types , name = 'uniq_instance_types0name0deleted' ) . create ( ) #NEWLINE# UniqueConstraint ( 'flavorid' , 'deleted' , table = instance_types , name = 'uniq_instance_types0flavorid0deleted' ) . create ( ) #NEWLINE# UniqueConstraint ( 'user_id' , 'name' , 'deleted' , table = key_pairs , name = 'uniq_key_pairs0user_id0name0deleted' ) . create ( ) #NEWLINE# inst_type_uc_name = ( 'uniq_instance_type_projects0instance_type_id0' + 'project_id0deleted' ) #NEWLINE# UniqueConstraint ( 'instance_type_id' , 'project_id' , 'deleted' , table = instance_type_projects , name = inst_type_uc_name ) . create ( ) #NEWLINE# UniqueConstraint ( 'address' , 'deleted' , table = floating_ips , name = 'uniq_floating_ips0address0deleted' ) . create ( ) #NEWLINE# UniqueConstraint ( 'instance_uuid' , table = instance_info_caches , name = 'uniq_instance_info_caches0instance_uuid' ) . create ( ) #NEWLINE# UniqueConstraint ( 'address' , 'deleted' , table = virtual_interfaces , name = 'uniq_virtual_interfaces0address0deleted' ) . create ( ) #NEWLINE# UniqueConstraint ( 'name' , 'deleted' , table = cells , name = 'uniq_cells0name0deleted' ) . create ( ) #NEWLINE# uc = UniqueConstraint ( 'project_id' , 'name' , 'deleted' , table = security_groups , name = 'uniq_security_groups0project_id0name0deleted' ) #NEWLINE# uc . create ( ) #NEWLINE# UniqueConstraint ( 'project_id' , 'resource' , 'deleted' , table = quotas , name = 'uniq_quotas0project_id0resource0deleted' ) . create ( ) #NEWLINE# UniqueConstraint ( 'address' , 'deleted' , table = fixed_ips , name = 'uniq_fixed_ips0address0deleted' ) . create ( ) #NEWLINE# UniqueConstraint ( 'host' , 'topic' , 'deleted' , table = services , name = 'uniq_services0host0topic0deleted' ) . create ( ) #NEWLINE# UniqueConstraint ( 'host' , 'binary' , 'deleted' , table = services , name = 'uniq_services0host0binary0deleted' ) . create ( ) #NEWLINE# uc_name = 'uniq_agent_builds0hypervisor0os0architecture0deleted' #NEWLINE# UniqueConstraint ( 'hypervisor' , 'os' , 'architecture' , 'deleted' , table = agent_builds , name = uc_name ) . create ( ) #NEWLINE# uc_name = 'uniq_console_pools0host0console_type0compute_host0deleted' #NEWLINE# UniqueConstraint ( 'host' , 'console_type' , 'compute_host' , 'deleted' , table = console_pools , name = uc_name ) . create ( ) #NEWLINE# uc_name = 'uniq_aggregate_hosts0host0aggregate_id0deleted' #NEWLINE# UniqueConstraint ( 'host' , 'aggregate_id' , 'deleted' , table = aggregate_hosts , name = uc_name ) . create ( ) #NEWLINE# uc_name = 'uniq_aggregate_metadata0aggregate_id0key0deleted' #NEWLINE# UniqueConstraint ( 'aggregate_id' , 'key' , 'deleted' , table = aggregate_metadata , name = uc_name ) . create ( ) #NEWLINE# uc_name = 'uniq_instance_type_extra_specs0instance_type_id0key0deleted' #NEWLINE# UniqueConstraint ( 'instance_type_id' , 'key' , 'deleted' , table = instance_type_extra_specs , name = uc_name ) . create ( ) #NEWLINE# 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 ) ] #NEWLINE# common_indexes = [ Index ( 'aggregate_metadata_key_idx' , aggregate_metadata . c . key ) , Index ( 'agent_builds_hypervisor_os_arch_idx' , agent_builds . c . hypervisor , agent_builds . c . os , agent_builds . c . architecture ) , 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 ) , 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 ) , 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 ) , 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 ) , Index ( 'consoles_instance_uuid_idx' , consoles . c . instance_uuid ) , Index ( 'dns_domains_domain_deleted_idx' , dns_domains . c . domain , dns_domains . c . deleted ) , 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 ) , 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 ) , Index ( 'instance_group_member_instance_idx' , group_member . c . instance_id ) , Index ( 'instance_group_metadata_key_idx' , group_metadata . c . key ) , Index ( 'instance_group_policy_policy_idx' , group_policy . c . policy ) , 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 ) , Index ( 'instance_uuid_idx' , instance_actions . c . instance_uuid ) , Index ( 'request_id_idx' , instance_actions . c . request_id ) , 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 ) , Index ( 'ix_instance_id_mappings_uuid' , instance_id_mappings . c . uuid ) , Index ( 'instance_metadata_instance_uuid_idx' , instance_metadata . c . instance_uuid ) , Index ( 'instance_type_extra_specs_instance_type_id_key_idx' , instance_type_extra_specs . c . instance_type_id , instance_type_extra_specs . c . key ) , 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 ) , 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 ) , 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 ) , 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 ) , 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 ) , Index ( 'security_group_instance_association_instance_uuid_idx' , security_group_instance_association . c . instance_uuid ) , 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 ) , Index ( 'ix_quota_classes_class_name' , quota_classes . c . class_name ) , 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 ) , Index ( 'volumes_instance_uuid_idx' , volumes . c . instance_uuid ) ] #NEWLINE# if ( migrate_engine . name == 'mysql' ) : #NEWLINE# #INDENT# for index in mysql_pre_indexes : #NEWLINE# #INDENT# index . create ( migrate_engine ) #NEWLINE# #UNINDENT# 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)' #NEWLINE# migrate_engine . execute ( sql ) #NEWLINE# #UNINDENT# if ( migrate_engine . name == 'postgresql' ) : #NEWLINE# #INDENT# Index ( 'address' , fixed_ips . c . address ) . create ( ) #NEWLINE# #UNINDENT# POSTGRES_INDEX_SKIPS = [ 'block_device_mapping_instance_uuid_virtual_name_device_name_idx' ] #NEWLINE# DB2_INDEX_SKIPS = POSTGRES_INDEX_SKIPS #NEWLINE# MYSQL_INDEX_SKIPS = [ 'migrations_by_host_nodes_and_status_idx' ] #NEWLINE# for index in common_indexes : #NEWLINE# #INDENT# if ( ( ( migrate_engine . name == 'postgresql' ) and ( index . name in POSTGRES_INDEX_SKIPS ) ) or ( ( migrate_engine . name == 'mysql' ) and ( index . name in MYSQL_INDEX_SKIPS ) ) or ( ( migrate_engine . name == 'ibm_db_sa' ) and ( index . name in DB2_INDEX_SKIPS ) ) ) : #NEWLINE# #INDENT# continue #NEWLINE# #UNINDENT# else : #NEWLINE# #INDENT# index . create ( migrate_engine ) #NEWLINE# #UNINDENT# #UNINDENT# Index ( 'project_id' , dns_domains . c . project_id ) . drop #NEWLINE# fkeys = [ [ [ 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 . security_group_id ] , [ security_groups . c . id ] , 'security_group_instance_association_ibfk_1' ] , [ [ 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' ] ] #NEWLINE# if ( migrate_engine . name != 'ibm_db_sa' ) : #NEWLINE# #INDENT# secgroup_instance_association_instance_uuid_fkey = 'security_group_instance_association_instance_uuid_fkey' #NEWLINE# fkeys . extend ( [ [ [ 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' ] , [ [ security_group_instance_association . c . instance_uuid ] , [ instances . c . uuid ] , secgroup_instance_association_instance_uuid_fkey ] , [ [ virtual_interfaces . c . instance_uuid ] , [ instances . c . uuid ] , 'virtual_interfaces_instance_uuid_fkey' ] , [ [ 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' ] ] ) #NEWLINE# #UNINDENT# for fkey_pair in fkeys : #NEWLINE# #INDENT# if ( migrate_engine . name in ( 'mysql' , 'ibm_db_sa' ) ) : #NEWLINE# #INDENT# fkey = ForeignKeyConstraint ( columns = fkey_pair [ 0 ] , refcolumns = fkey_pair [ 1 ] , name = fkey_pair [ 2 ] ) #NEWLINE# fkey . create ( ) #NEWLINE# #UNINDENT# else : #NEWLINE# #INDENT# if ( migrate_engine . name == 'postgresql' ) : #NEWLINE# #INDENT# fkey = ForeignKeyConstraint ( columns = fkey_pair [ 0 ] , refcolumns = fkey_pair [ 1 ] ) #NEWLINE# fkey . create ( ) #NEWLINE# #UNINDENT# #UNINDENT# #UNINDENT# if ( migrate_engine . name == 'mysql' ) : #NEWLINE# #INDENT# migrate_engine . execute ( 'ALTER TABLE migrate_version CONVERT TO CHARACTER SET utf8' ) #NEWLINE# migrate_engine . execute ( ( 'ALTER DATABASE %s DEFAULT CHARACTER SET utf8' % migrate_engine . url . database ) ) #NEWLINE# #UNINDENT# _create_shadow_tables ( migrate_engine ) #NEWLINE# _create_dump_tables ( migrate_engine )