]> review.fuel-infra Code Review - openstack-build/cinder-build.git/commit
Create single initial Cinder DB migration file
authorJohn Griffith <john.griffith@solidfire.com>
Tue, 3 Jul 2012 22:40:15 +0000 (16:40 -0600)
committerJohn Griffith <john.griffith@solidfire.com>
Fri, 6 Jul 2012 01:10:50 +0000 (19:10 -0600)
commit263d7b905446e8eaadbcc0501846da7d771e57ad
tree2ccbd4e7d95a9ba9455e86c4bb679912bc93c1fd
parenta55f0732211f0a1a8f6db40e6d1f464050234844
Create single initial Cinder DB migration file

 * Implements blueprint initial-db-cleanup
 * Sets initial migration
 * Removes unused tables that were brought in from nova
 * Condenses db migrations into the single initial migration/creation
 * Add explicit mysql set InnoDB in UTF8 loop
 * Folow up patches include:
 *    Remove unused db API calls
 *    Fix/Remove affected tests

Change-Id: If24b00747dbbff7037b7aca39602d5f0b1c6aa50
135 files changed:
cinder/db/migration.py
cinder/db/sqlalchemy/migrate_repo/versions/001_austin.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/001_cinder_init.py [new file with mode: 0644]
cinder/db/sqlalchemy/migrate_repo/versions/002_bexar.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/002_postgresql_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/002_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/003_add_label_to_networks.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/003_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/004_add_zone_tables.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/005_add_instance_metadata.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/006_add_provider_data_to_volumes.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/006_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/007_add_ipv6_to_fixed_ips.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/007_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/008_add_instance_types.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/009_add_instance_migrations.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/010_add_os_type_to_instances.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/011_live_migration.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/012_add_ipv6_flatmanager.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/012_sqlite_upgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/013_add_flavors_to_migrations.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/013_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/014_add_instance_type_id_to_instances.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/015_add_auto_assign_to_floating_ips.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/015_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/016_make_quotas_key_and_value.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/017_make_instance_type_id_an_integer.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/018_rename_server_management_url.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/019_add_volume_snapshot_support.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/020_add_snapshot_id_to_volumes.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/020_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/021_rename_image_ids.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/022_set_engine_mysql_innodb.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/023_add_vm_mode_to_instances.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/024_add_block_device_mapping.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/025_add_uuid_to_instances.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/026_add_agent_table.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/027_add_provider_firewall_rules.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/028_add_instance_type_extra_specs.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/029_add_zone_weight_offsets.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/030_multi_nic.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/030_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/031_fk_fixed_ips_virtual_interface_id.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/031_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/031_sqlite_upgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/032_add_root_device_name.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/033_ha_network.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/033_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/034_change_instance_id_in_migrations.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/035_secondary_dns.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/036_change_flavor_id_in_migrations.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/037_instances_drop_admin_pass.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/038_add_uuid_to_virtual_interfaces.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/038_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/039_add_instances_accessip.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/040_add_uuid_to_networks.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/041_add_config_drive_to_instances.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/042_add_volume_types_and_extradata.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/042_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/043_add_vsa_data.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/044_update_instance_states.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/045_add_network_priority.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/046_add_instance_swap.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/047_remove_instances_fk_from_vif.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/047_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/047_sqlite_upgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/048_add_zone_name.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/049_add_instances_progress.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/050_add_disk_config_to_instances.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/050_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/051_add_vcpu_weight_to_instance_types.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/052_kill_export_devices.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/053_add_connection_info_to_block_device_mapping.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/053_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/054_add_bw_usage_data_cache.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/055_convert_flavor_id_to_str.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/056_add_s3_images.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/057_add_sm_driver_tables.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/058_rename_managed_disk.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/059_split_rxtx_quota_into_network.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/059_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/059_sqlite_upgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/060_remove_network_fk_from_vif.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/060_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/060_sqlite_upgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/061_add_index_to_instance_uuid.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/062_add_instance_info_cache_table.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/063_add_instance_faults_table.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/064_change_instance_id_to_uuid_in_instance_actions.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/065_add_index_to_instance_project_id.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/066_preload_instance_info_cache_table.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/067_add_pool_and_interface_to_floating_ip.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/067_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/068_add_instance_attribute.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/068_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/069_block_migration.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/070_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/070_sqlite_upgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/070_untie_nova_network_models.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/071_add_host_aggregate_tables.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/072_add_dns_table.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/072_mysql_upgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/073_add_capacity.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/074_change_flavor_local_gb.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/074_sqlite_upgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/075_convert_bw_usage_to_store_network_id.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/076_remove_unique_constraints.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/076_sqlite_upgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/077_convert_to_utf8.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/078_add_rpc_info_to_zones.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/078_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/079_add_zone_name_to_instances.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/080_add_hypervisor_hostname_to_compute_nodes.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/081_drop_instance_id_bw_cache.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/082_zone_to_cell.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/083_quota_class.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/084_quotas_unlimited.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/085_add_index_to_fixed_ips_by_address.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/086_set_engine_mysql_innodb.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/087_add_uuid_to_bw_usage_cache.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/088_change_instance_id_to_uuid_in_block_device_mapping.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/088_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/088_sqlite_upgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/089_add_volume_id_mappings.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/090_modify_volume_id_datatype.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/090_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/090_sqlite_upgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/091_convert_volume_ids_to_uuid.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/092_change_fk_instance_id_to_uuid.py [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/092_sqlite_downgrade.sql [deleted file]
cinder/db/sqlalchemy/migrate_repo/versions/092_sqlite_upgrade.sql [deleted file]
cinder/db/sqlalchemy/migration.py
cinder/db/sqlalchemy/models.py
cinder/tests/test_db_api.py [deleted file]
cinder/tests/test_migrations.py