{"action":"created","issue":{"url":"https://api.github.com/repos/ManageIQ/manageiq/issues/3454","labels_url":"https://api.github.com/repos/ManageIQ/manageiq/issues/3454/labels{/name}","comments_url":"https://api.github.com/repos/ManageIQ/manageiq/issues/3454/comments","events_url":"https://api.github.com/repos/ManageIQ/manageiq/issues/3454/events","html_url":"https://github.com/ManageIQ/manageiq/pull/3454","id":95108625,"number":3454,"title":"[WIP] Collapse old migrations","user":{"login":"Fryguy","id":52120,"avatar_url":"https://avatars.githubusercontent.com/u/52120?v=3","gravatar_id":"","url":"https://api.github.com/users/Fryguy","html_url":"https://github.com/Fryguy","followers_url":"https://api.github.com/users/Fryguy/followers","following_url":"https://api.github.com/users/Fryguy/following{/other_user}","gists_url":"https://api.github.com/users/Fryguy/gists{/gist_id}","starred_url":"https://api.github.com/users/Fryguy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Fryguy/subscriptions","organizations_url":"https://api.github.com/users/Fryguy/orgs","repos_url":"https://api.github.com/users/Fryguy/repos","events_url":"https://api.github.com/users/Fryguy/events{/privacy}","received_events_url":"https://api.github.com/users/Fryguy/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ManageIQ/manageiq/labels/technical%20debt","name":"technical debt","color":"eb6420"},{"url":"https://api.github.com/repos/ManageIQ/manageiq/labels/wip","name":"wip","color":"eeeeee"}],"state":"open","locked":false,"assignee":{"login":"Fryguy","id":52120,"avatar_url":"https://avatars.githubusercontent.com/u/52120?v=3","gravatar_id":"","url":"https://api.github.com/users/Fryguy","html_url":"https://github.com/Fryguy","followers_url":"https://api.github.com/users/Fryguy/followers","following_url":"https://api.github.com/users/Fryguy/following{/other_user}","gists_url":"https://api.github.com/users/Fryguy/gists{/gist_id}","starred_url":"https://api.github.com/users/Fryguy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Fryguy/subscriptions","organizations_url":"https://api.github.com/users/Fryguy/orgs","repos_url":"https://api.github.com/users/Fryguy/repos","events_url":"https://api.github.com/users/Fryguy/events{/privacy}","received_events_url":"https://api.github.com/users/Fryguy/received_events","type":"User","site_admin":false},"milestone":null,"comments":9,"created_at":"2015-07-15T05:17:20Z","updated_at":"2015-07-16T14:56:46Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/ManageIQ/manageiq/pulls/3454","html_url":"https://github.com/ManageIQ/manageiq/pull/3454","diff_url":"https://github.com/ManageIQ/manageiq/pull/3454.diff","patch_url":"https://github.com/ManageIQ/manageiq/pull/3454.patch"},"body":"Marked as WIP until I can do further testing including upgrading old databases.\r\n\r\nCollapse initial migrations up to CloudForms 3.0 (CFME 5.2.0.37)\r\n\r\nAny old customer upgrading to a version of CloudForms greater than 3.0\r\nwill have to go through the upgrade to 3.0 first.  Once on 3.0, they can\r\njump straight to the latest version on the 3.x series, so we can\r\ncollapse anything from the 3.0 release and earlier.\r\n\r\nAll of these migrations are from before the open-sourcing of ManageIQ,\r\nand thus do not affect current upstream releases (anand and botvinnik).\r\n\r\n@chessbyte @jrafanie Please review\r\ncc @jonnyfiveiq\r\ncc @kbrock from our discussion in #3355 \r\n\r\n---\r\n\r\nSince github can't handle this PR, here are the stats:\r\n\r\n```\r\n db/migrate/20100302205959_collapsed_initial_migration.rb                         |  1934 ----\r\n db/migrate/20100308005125_create_miq_cim_instances.rb                            |    34 -\r\n db/migrate/20100308005859_create_miq_cim_associations.rb                         |    23 -\r\n db/migrate/20100310182434_add_priority_to_assigned_server_roles.rb               |    34 -\r\n db/migrate/20100311205819_create_storages_vms.rb                                 |    15 -\r\n db/migrate/20100312211113_create_miq_cim_stats.rb                                |    12 -\r\n db/migrate/20100312211226_create_miq_cim_derived_stats.rb                        |    36 -\r\n db/migrate/20100313004414_create_miq_smis_agents.rb                              |    16 -\r\n db/migrate/20100323125129_add_storage_id_to_disks.rb                             |     9 -\r\n db/migrate/20100326173712_add_ems_ref_to_tables.rb                               |    19 -\r\n db/migrate/20100407192439_add_responds_to_events_to_miq_alerts.rb                |    18 -\r\n db/migrate/20100408131912_update_system_schedules.rb                             |    12 -\r\n db/migrate/20100408163035_create_chargeback_rates.rb                             |    31 -\r\n db/migrate/20100409221634_change_index_on_miq_queue.rb                           |    30 -\r\n db/migrate/20100413003434_remove_miq_alert_contents.rb                           |    53 -\r\n .../20100423210619_move_vim_performance_counters_to_vim_performance_metrics.rb   |    57 -\r\n db/migrate/20100427170608_add_default_to_chargeback_rate.rb                      |    11 -\r\n db/migrate/20100428172512_create_miq_alert_statuses.rb                           |    14 -\r\n db/migrate/20100515003009_remove_vim_performance_metrics.rb                      |   113 -\r\n db/migrate/20100602222107_create_miq_report_result_details.rb                    |    16 -\r\n db/migrate/20100610234327_add_drb_uri_to_miq_server.rb                           |     9 -\r\n db/migrate/20100611011454_rename_drb_uri_column_in_miq_workers.rb                |     9 -\r\n db/migrate/20100617174900_add_zone_id_to_miq_smis_agent.rb                       |     9 -\r\n db/migrate/20100621174417_convert_ids_to64bit.rb                                 |   299 -\r\n db/migrate/20100621180850_add_state_to_miq_provision.rb                          |    11 -\r\n db/migrate/20100622195644_add_start_address_to_partitions.rb                     |    30 -\r\n db/migrate/20100624180332_add_zone_and_vmdb_and_source_to_miq_cim_instance.rb    |    15 -\r\n db/migrate/20100629191445_create_miq_regions.rb                                  |    13 -\r\n db/migrate/20100702152803_add_derived_vm_numvcpus_to_vim_performances.rb         |    20 -\r\n db/migrate/20100707191417_add_display_name_to_automate_namespace_and_value.rb    |    11 -\r\n db/migrate/20100707192347_add_condition_to_automate_field_and_value.rb           |    11 -\r\n db/migrate/20100707192517_add_collect_to_automate_value.rb                       |     9 -\r\n .../20100707212512_add_report_rows_per_detail_rows_to_miq_report_results.rb      |     9 -\r\n db/migrate/20100709185222_add_on_xxx_columns_to_miq_ae_fields.rb                 |    13 -\r\n db/migrate/20100709185817_add_reserved_to_miq_ae_methods.rb                      |     9 -\r\n db/migrate/20100709191713_expand_columns_in_miq_ae_fields_and_values.rb          |    13 -\r\n db/migrate/20100709194556_add_region_id_to_users.rb                              |    20 -\r\n db/migrate/20100709210006_remove_username_password_from_miq_smis_agent.rb        |    11 -\r\n db/migrate/20100716215211_make_smis_agents_like_ems.rb                           |    15 -\r\n db/migrate/20100716235722_add_on_xxx_columns_to_miq_ae_values.rb                 |    13 -\r\n db/migrate/20100730193012_add_miq_group_to_vms_and_users.rb                      |    61 -\r\n db/migrate/20100806185448_create_customization_specs.rb                          |    18 -\r\n db/migrate/20100818152022_add_indexes_to_ems_events.rb                           |    15 -\r\n db/migrate/20100818223202_update_indexes_on_ems_events.rb                        |    21 -\r\n db/migrate/20100830200755_remove_reserved.rb                                     |   140 -\r\n db/migrate/20100901210737_add_index_to_miq_report_result_details.rb              |     9 -\r\n db/migrate/20100902190255_convert_smis_class_hier_to_string.rb                   |    28 -\r\n db/migrate/20100902210402_add_type_to_miq_cim_instances.rb                       |    50 -\r\n db/migrate/20100903152050_smis_convert_ids_to64bit.rb                            |    13 -\r\n db/migrate/20100903201734_add_operating_ranges_to_vms.rb                         |     9 -\r\n db/migrate/20100908214807_recreate_relationships.rb                              |   142 -\r\n db/migrate/20100914190518_add_supported_capabilities_to_storage.rb               |    13 -\r\n db/migrate/20100914223945_remove_reserved_from_automation.rb                     |    48 -\r\n db/migrate/20100921183530_create_database_backups.rb                             |    12 -\r\n db/migrate/20100922214757_create_file_depots.rb                                  |    15 -\r\n db/migrate/20100923195540_remove_owner_from_vms.rb                               |     9 -\r\n db/migrate/20100924173953_add_description_to_miq_regions.rb                      |    15 -\r\n .../20100927191952_add_region_id_to_database_backup_and_missing_indexes.rb       |    17 -\r\n db/migrate/20100928194331_add_ipv6_to_networks.rb                                |     9 -\r\n db/migrate/20101015163550_add_first_and_last_names_to_users.rb                   |    11 -\r\n db/migrate/20101021182637_add_adhoc_to_miq_schedules.rb                          |     9 -\r\n db/migrate/20101027203743_add_reporting_cols_to_authentications.rb               |    17 -\r\n db/migrate/20101028195038_remove_custom_fields_from_vms_hosts.rb                 |    54 -\r\n db/migrate/20101028212240_create_miq_databases.rb                                |    13 -\r\n db/migrate/20101102205337_add_guid_to_miq_regions.rb                             |     9 -\r\n db/migrate/20101110193452_create_miq_widgets.rb                                  |    24 -\r\n db/migrate/20101110214129_create_miq_widget_contents.rb                          |    16 -\r\n db/migrate/20101118165232_remove_miq_region_from_miq_databases.rb                |     9 -\r\n db/migrate/20101201225812_add_remote_ui_url_to_miq_regions.rb                    |    20 -\r\n db/migrate/20101216164622_fix_index_on_relationships.rb                          |    20 -\r\n db/migrate/20101216235159_fix_boolean_columns_in_classifications.rb              |    15 -\r\n db/migrate/20110103165119_add_name_and_visibility_to_automation_uris.rb          |    11 -\r\n db/migrate/20110103222425_add_macaddress_and_vm_id_to_miq_server.rb              |    11 -\r\n db/migrate/20110106084530_create_vdi_classes.rb                                  |    86 -\r\n db/migrate/20110106220403_add_time_profile_daily_rollup_columns.rb               |    22 -\r\n db/migrate/20110107192542_create_vdi_desktop_pool_vdi_user.rb                    |    36 -\r\n db/migrate/20110113172631_add_vdi_to_vms.rb                                      |     9 -\r\n db/migrate/20110125223619_recreate_performance_views.rb                          |    13 -\r\n db/migrate/20110203035917_make_polymorphic_handler_in_miq_queue.rb               |    27 -\r\n db/migrate/20110209044337_add_maxima_for_automate_state_machines.rb              |    21 -\r\n db/migrate/20110210224809_create_vim_performance_operating_ranges.rb             |    20 -\r\n db/migrate/20110215195730_create_miq_user_roles_and_features.rb                  |    36 -\r\n db/migrate/20110216165949_add_vdi_cis_to_ems_events.rb                           |    27 -\r\n db/migrate/20110216210923_add_last_updated_by_to_automate_tables.rb              |    15 -\r\n db/migrate/20110217143738_rename_last_updated_by_fields_in_automate.rb           |    15 -\r\n db/migrate/20110217192941_add_active_role_flags_to_miq_servers.rb                |    11 -\r\n db/migrate/20110217193830_remove_remote_ui_url_from_miq_regions.rb               |     9 -\r\n db/migrate/20110223170600_convert_miq_smis_agents_to_storage_managers.rb         |    45 -\r\n db/migrate/20110225193433_add_for_user_to_miq_queue.rb                           |    11 -\r\n db/migrate/20110225201158_add_settings_to_miq_user_roles.rb                      |     9 -\r\n db/migrate/20110321230023_convert_custom_spec_description_to_text.rb             |     9 -\r\n db/migrate/20110322143007_fix_indices_on_vim_performance.rb                      |    15 -\r\n db/migrate/20110325161234_remove_vim_performance_views.rb                        |    13 -\r\n db/migrate/20110328153536_add_perf_by_tag_to_classifications.rb                  |    40 -\r\n db/migrate/20110406160642_add_admin_disabled_to_host.rb                          |     9 -\r\n db/migrate/20110408161800_add_service_tag_and_asset_tag_to_host.rb               |    22 -\r\n db/migrate/20110411122118_add_ipmi_address_to_host.rb                            |     9 -\r\n db/migrate/20110411145828_add_role_scope_column_to_server_roles.rb               |     9 -\r\n db/migrate/20110413190627_create_tftp_servers.rb                                 |    15 -\r\n db/migrate/20110415132554_create_os_images.rb                                    |    17 -\r\n db/migrate/20110419163004_rename_tftp_servers_to_pxe_servers.rb                  |     9 -\r\n db/migrate/20110419185327_rename_os_images_to_pxe_images.rb                      |    25 -\r\n db/migrate/20110422214842_add_cols_to_pxe_servers.rb                             |    11 -\r\n db/migrate/20110505210204_add_mac_address_to_hosts.rb                            |     9 -\r\n db/migrate/20110506203134_create_miq_host_provision_requests.rb                  |    32 -\r\n db/migrate/20110602123937_change_alert_processor_to_notifier.rb                  |    28 -\r\n db/migrate/20110609170223_create_customization_templates.rb                      |    17 -\r\n .../20110613185503_add_image_type_to_pxe_images_and_customization_templates.rb   |    11 -\r\n db/migrate/20110615151326_create_miq_dialogs.rb                                  |    18 -\r\n db/migrate/20110629192208_extend_vim_performance_operating_ranges.rb             |    25 -\r\n db/migrate/20110701100258_create_miq_request_tasks.rb                            |    94 -\r\n db/migrate/20110701142013_add_miq_provisions_to_miq_requests.rb                  |    87 -\r\n db/migrate/20110713190127_add_identifier_to_miq_tasks.rb                         |     9 -\r\n db/migrate/20110713192713_add_result_to_miq_alert_statuses.rb                    |     9 -\r\n db/migrate/20110805164836_add_type_to_hosts.rb                                   |    32 -\r\n db/migrate/20110822140627_add_settings_to_miq_group.rb                           |    59 -\r\n db/migrate/20110830191326_add_miq_report_results_to_miq_group.rb                 |    26 -\r\n db/migrate/20110901140214_add_type_to_ext_management_systems.rb                  |    29 -\r\n db/migrate/20110907213116_add_vapp_to_resource_pool.rb                           |    20 -\r\n db/migrate/20110920173457_add_owner_to_miq_set.rb                                |    11 -\r\n db/migrate/20111014182710_add_type_spec_obj_to_miq_cim_instances.rb              |     9 -\r\n db/migrate/20111018160128_add_type_to_miq_cim_stat.rb                            |    16 -\r\n db/migrate/20111019212046_create_ontap_volume_derived_stats.rb                   |    58 -\r\n db/migrate/20111020162549_rename_miq_cim_stats_to_miq_storage_stats.rb           |     9 -\r\n db/migrate/20111020181617_rename_miq_cim_stat_id_cols.rb                         |    23 -\r\n ...0111020183837_add_miq_task_id_and_last_generated_content_on_to_miq_widgets.rb |    23 -\r\n db/migrate/20111025152608_convert_hardware_vmotion_enabled_to_boolean.rb         |     9 -\r\n db/migrate/20111025155528_create_ontap_aggregate_derived_stats.rb                |    26 -\r\n db/migrate/20111025175841_create_ontap_disk_derived_stats.rb                     |    46 -\r\n db/migrate/20111025204747_create_ontap_lun_derived_stats.rb                      |    27 -\r\n db/migrate/20111025235521_create_ontap_system_derived_stats.rb                   |    43 -\r\n db/migrate/20111123162600_add_linked_clone_and_fault_tolerance_to_vms.rb         |    22 -\r\n db/migrate/20111128175655_fix_order_of_multi_column_indices.rb                   |    63 -\r\n db/migrate/20111128180748_create_resource_index_on_compliances.rb                |     9 -\r\n db/migrate/20111128201805_create_indices_for_implicit_foreign_keys.rb            |   134 -\r\n db/migrate/20111129025024_fix_order_of_multi_column_index_on_vim_performances.rb |    17 -\r\n db/migrate/20111213223620_add_master_to_storages.rb                              |     5 -\r\n db/migrate/20111227190450_create_metrics_subtables_on_postgres.rb                |   222 -\r\n ...20111227190500_copy_vim_performances_data_to_metrics_subtables_on_postgres.rb |    74 -\r\n ...convert_rubyrep_data_for_vim_performances_to_metrics_subtables_on_postgres.rb |   155 -\r\n ...90510_recreate_vim_performances_as_parent_of_metrics_subtables_on_postgres.rb |   134 -\r\n .../20111227190521_split_and_rename_vim_performances_to_metrics_on_sqlserver.rb  |   337 -\r\n db/migrate/20111228214919_rename_vim_performance_id_to_metric.rb                 |    39 -\r\n .../20111228233256_rename_rollup_daily_performances_to_rollup_daily_metrics.rb   |     5 -\r\n db/migrate/20111229201847_create_automation_requests_and_tasks.rb                |    31 -\r\n db/migrate/20111230141215_remove_automation_requests_and_tasks.rb                |    90 -\r\n db/migrate/20120105202052_expand_lockout_duration_on_operating_systems.rb        |     9 -\r\n ...120224250_remove_message_and_monitor_status_columns_from_miq_workers_table.rb |    11 -\r\n db/migrate/20120123170106_ontap_rename_stats_to_metrics.rb                       |   108 -\r\n ...20120125211033_ontap_add_base_counters_and_counter_info_to_derived_metrics.rb |    35 -\r\n db/migrate/20120126190558_remove_message_column_from_miq_servers_table.rb        |     9 -\r\n db/migrate/20120126211839_add_type_to_vms.rb                                     |    45 -\r\n db/migrate/20120126225337_ontap_create_metrics_rollup_tables.rb                  |   393 -\r\n db/migrate/20120201202300_change_cpu_time_from_string_to_float.rb                |    11 -\r\n db/migrate/20120207184241_rename_vm_id_columns_to_vm_or_template_id.rb           |     7 -\r\n db/migrate/20120207204723_fix_storages_vms_join_table.rb                         |    20 -\r\n db/migrate/20120207224937_change_polymorphic_types_from_vm_to_vm_or_template.rb  |    31 -\r\n .../20120209042609_change_all_polymorphic_types_from_vm_to_vm_or_template.rb     |    66 -\r\n ...0210185620_migrate_data_for_association_type_in_vim_performance_tag_values.rb |    15 -\r\n .../20120216210738_add_api_version_and_uid_ems_to_ext_management_systems.rb      |    22 -\r\n .../20120217224756_rename_dest_vm_id_to_dest_vm_or_template_id_for_ems_events.rb |     5 -\r\n db/migrate/20120221192819_create_services_and_templates.rb                       |    45 -\r\n db/migrate/20120301190348_ontap_add_cim_instance_id_to_metrics_tables.rb         |   100 -\r\n db/migrate/20120305222718_ontap_remove_position_from_metrics_tables.rb           |    39 -\r\n db/migrate/20120319220134_add_failover_to_hosts.rb                               |    20 -\r\n db/migrate/20120320194601_add_effective_cpu_and_memory_to_cluster.rb             |    22 -\r\n db/migrate/20120328200439_ontap_refactor_metrics_metadata.rb                     |   173 -\r\n db/migrate/20120328210051_add_expires_on_to_miq_queue.rb                         |    27 -\r\n db/migrate/20120329205436_create_services.rb                                     |    59 -\r\n db/migrate/20120402095720_add_owner_to_services.rb                               |    11 -\r\n db/migrate/20120410153053_create_tables_for_vmdb_database.rb                     |    76 -\r\n db/migrate/20120413002558_add_last_replication_id_and_count_to_miq_database.rb   |    22 -\r\n db/migrate/20120508014559_add_status_to_miq_cim_associations.rb                  |    11 -\r\n db/migrate/20120510021231_rename_process_type_column_in_jobs_table.rb            |     9 -\r\n db/migrate/20120510032049_add_options_and_context_columns_to_jobs.rb             |     6 -\r\n db/migrate/20120511235145_add_sql_spid_column_to_miq_worker_and_miq_server.rb    |     8 -\r\n db/migrate/20120511235150_remove_reserves_values_for_miq_worker_sql_spid.rb      |    22 -\r\n db/migrate/20120514132616_create_dialogs.rb                                      |    51 -\r\n db/migrate/20120515174136_rename_processes_running_on_vmdb_database_metrics.rb   |     5 -\r\n db/migrate/20120524142236_add_miq_request_task_id_to_miq_request_task.rb         |     5 -\r\n db/migrate/20120605013547_add_indexes_to_miq_cim_associations.rb                 |     8 -\r\n db/migrate/20120605020842_remove_timestamps_from_miq_cim_associations.rb         |     9 -\r\n db/migrate/20120605084820_add_label_to_dialogs.rb                                |     8 -\r\n db/migrate/20120605132213_create_resource_actions.rb                             |    10 -\r\n db/migrate/20120606185521_add_indexes_to_miq_cim_instances.rb                    |     6 -\r\n db/migrate/20120607192330_add_ems_ref_to_snapshots.rb                            |     5 -\r\n db/migrate/20120607195908_rename_table_type_column_to_type_in_vmdb_table.rb      |    21 -\r\n db/migrate/20120608194236_add_capture_interval_name_to_vmdb_metric_tables.rb     |    22 -\r\n db/migrate/20120611175932_add_ems_ref_obj_column_to_tables.rb                    |    76 -\r\n db/migrate/20120612122655_rename_path_column_in_vmdb_databases.rb                |     5 -\r\n db/migrate/20120614040940_correct_columns_in_vmdb_database_metrics.rb            |    31 -\r\n db/migrate/20120614161725_add_data_disk_column_to_vmdb_databases.rb              |     5 -\r\n db/migrate/20120618121720_add_automation_columns_to_resource_actions.rb          |     9 -\r\n db/migrate/20120620002806_pluralize_columns_on_vmdb_metrics.rb                   |     6 -\r\n .../20120620003239_change_size_column_from_float_to_bigint_on_vmdb_metrics.rb    |     9 -\r\n db/migrate/20120620215900_add_data_to_states.rb                                  |     9 -\r\n db/migrate/20120620215904_convert_old_states_to_new_format.rb                    |   206 -\r\n db/migrate/20120620215910_remove_columns_from_states.rb                          |    31 -\r\n db/migrate/20120622192537_add_zone_id_to_vdi_farm.rb                             |     5 -\r\n db/migrate/20120625173520_migrate_automate_uri_data_to_resource_actions.rb       |    94 -\r\n db/migrate/20120706153004_agnostic_server_roles.rb                               |   193 -\r\n db/migrate/20120713183245_set_type_for_vmdb_storage_manager.rb                   |    11 -\r\n db/migrate/20120716182000_rename_states_to_drift_states.rb                       |    37 -\r\n db/migrate/20120716184941_add_applies_to_id_to_automation_uri.rb                 |     5 -\r\n db/migrate/20120716191644_add_timestamp_index_on_drift_states.rb                 |     5 -\r\n db/migrate/20120716194013_set_type_for_ontap_flex_vol_and_disk_extent.rb         |    15 -\r\n db/migrate/20120719214738_rename_automation_uri_to_custom_button.rb              |    64 -\r\n db/migrate/20120724195950_add_phase_to_miq_request_task.rb                       |     5 -\r\n db/migrate/20120726213928_add_phase_context_to_miq_request_tasks.rb              |     5 -\r\n db/migrate/20120802025926_add_kickstart_and_pxe_directories_to_pxe_servers.rb    |     6 -\r\n db/migrate/20120802030449_create_pxe_menus_table.rb                              |    14 -\r\n db/migrate/20120802154022_add_pxe_menu_id_to_pxe_images.rb                       |    13 -\r\n db/migrate/20120802154316_add_sti_to_pxe_menus_and_pxe_images.rb                 |     6 -\r\n db/migrate/20120803170449_create_pxe_image_types.rb                              |    33 -\r\n db/migrate/20120803181442_split_out_options_in_pxe_images.rb                     |    19 -\r\n db/migrate/20120815051205_add_chap_auth_enabled_to_guest_devices.rb              |    20 -\r\n db/migrate/20120815055747_add_hyperthreading_to_hosts.rb                         |    20 -\r\n db/migrate/20120820180244_create_pictures.rb                                     |    11 -\r\n db/migrate/20120821101620_rename_dialog_options_fields.rb                        |    13 -\r\n db/migrate/20120822180220_add_prov_type_to_service_templates.rb                  |    15 -\r\n db/migrate/20120824092620_add_service_id_to_services.rb                          |     5 -\r\n .../20120824181318_add_prior_raw_metrics_to_vmdb_tables_and_vmdb_indexes.rb      |    13 -\r\n db/migrate/20120827162810_add_ems_cluster_id_to_hosts_and_vms.rb                 |    38 -\r\n .../20120827215812_rename_kickstart_directory_to_customization_directory.rb      |     9 -\r\n db/migrate/20120828220222_add_type_to_customization_template.rb                  |    17 -\r\n db/migrate/20120904183349_create_windows_images.rb                               |    13 -\r\n db/migrate/20120906193426_add_pxe_image_type_reference_to_windows_image.rb       |    13 -\r\n db/migrate/20120906194907_add_default_for_windows_to_pxe_images.rb               |     5 -\r\n db/migrate/20120912200413_remove_operating_ranges_from_vms_table.rb              |     9 -\r\n db/migrate/20120919210858_deserialize_retirement_from_vms.rb                     |    41 -\r\n db/migrate/20120921170929_add_retirement_to_services.rb                          |     8 -\r\n db/migrate/20120921203124_add_provision_cost_to_service_templates.rb             |     5 -\r\n db/migrate/20120925162220_create_service_template_catalog.rb                     |    25 -\r\n db/migrate/20121002183249_create_miq_shortcuts.rb                                |    17 -\r\n db/migrate/20121002202734_add_long_description_to_service_templates.rb           |     5 -\r\n db/migrate/20121003160154_add_sequence_to_shortcuts.rb                           |     6 -\r\n db/migrate/20121003201227_add_path_to_pxe_images.rb                              |     5 -\r\n db/migrate/20121005192809_add_system_to_customization_templates.rb               |     5 -\r\n db/migrate/20121017121520_add_type_to_vdi_farms.rb                               |    19 -\r\n db/migrate/20121022150323_rename_miq_schedule_last_update_on_to_updated_at.rb    |     9 -\r\n db/migrate/20121022155944_add_next_available_vnc_port_to_hosts.rb                |    20 -\r\n db/migrate/20121022181037_add_vnc_port_to_vms.rb                                 |    20 -\r\n db/migrate/20121022185550_add_resource_to_miq_widget_contents.rb                 |    99 -\r\n ...031211450_add_host_default_vnc_port_start_and_end_to_ext_management_system.rb |    22 -\r\n ...ry_blob_and_binary_blob_part_size_values_from_character_length_to_bytesize.rb |    41 -\r\n db/migrate/20121116135220_convert_vdi_desktop_vdi_user_relationship_to_habtm.rb  |    34 -\r\n .../20121119152820_convert_vdi_desktop_pool_to_ems_relationship_to_habtm.rb      |    34 -\r\n db/migrate/20121121173839_change_port_in_rhevm30_instances.rb                    |    23 -\r\n db/migrate/20121205035058_create_iso_datastores_and_iso_images.rb                |    19 -\r\n db/migrate/20121205171738_add_type_to_authentications.rb                         |    23 -\r\n db/migrate/20121207100520_create_ldap_servers.rb                                 |    26 -\r\n db/migrate/20121208094220_create_ldap_users_and_ldap_groups.rb                   |    52 -\r\n db/migrate/20121211175420_add_auth_key_to_authentications.rb                     |     9 -\r\n db/migrate/20121219170219_change_ts_index_on_metrics_to_add_resource.rb          |    53 -\r\n db/migrate/20121220065120_add_last_sync_time_to_ldap_servers.rb                  |    17 -\r\n db/migrate/20121221061920_add_get_groups_from_ldap_ldap_servers.rb               |     8 -\r\n db/migrate/20130115114420_add_vdi_user_reltionship_to_ldap_users.rb              |    17 -\r\n ...20130115171747_create_ldap_region_and_ldap_domain_and_refactor_ldap_server.rb |    60 -\r\n db/migrate/20130214181620_add_index_on_vdi_desktop_pools_vdi_users.rb            |    13 -\r\n db/migrate/20130221210837_remove_defaults_from_miq_widgets.rb                    |    11 -\r\n db/migrate/20130312212335_remove_defaults_from_service_resource.rb               |    13 -\r\n db/migrate/20130326173718_remove_defaults_from_dialog_fields.rb                  |     9 -\r\n db/migrate/20130509182443_add_registration_information_to_miq_databases.rb       |    12 -\r\n db/migrate/20130509191546_add_update_and_registration_status_to_miq_servers.rb   |     8 -\r\n db/migrate/20130521133700_fix_vm_or_template_alerts.rb                           |    46 -\r\n db/migrate/20130528153700_migrate_to_bcrypt_password.rb                          |    25 -\r\n db/migrate/20130530201901_add_session_secret_token_to_miq_database.rb            |     5 -\r\n db/migrate/20130606205500_add_csrf_secret_token_to_miq_database.rb               |     5 -\r\n db/migrate/20130608025610_create_availability_zones.rb                           |    16 -\r\n db/migrate/20130608030909_create_flavors.rb                                      |    18 -\r\n db/migrate/20130608040734_add_flavor_and_availability_zone_to_vms.rb             |     9 -\r\n db/migrate/20130610122520_add_service_id_to_ems_events.rb                        |     8 -\r\n db/migrate/20130620185912_add_ems_ref_to_flavors_and_availability_zones.rb       |     6 -\r\n db/migrate/20130701174443_remove_emstype_from_ems.rb                             |    26 -\r\n db/migrate/20130708204413_migrate_management_systems_reports_to_providers.rb     |    23 -\r\n db/migrate/20130715204720_remove_name_from_dialog_dialog_tab_and_dialog_group.rb |    13 -\r\n db/migrate/20130715221820_add_order_to_dialog_resources.rb                       |    78 -\r\n db/migrate/20130719204831_add_cloud_to_vms.rb                                    |    21 -\r\n db/migrate/20130725223459_create_security_groups.rb                              |    11 -\r\n db/migrate/20130725224004_change_firewall_rules_to_polymorphic.rb                |    39 -\r\n db/migrate/20130726202453_add_fingerprint_to_authentications.rb                  |     5 -\r\n .../20130727001152_add_source_security_group_id_and_range_to_firewall_rules.rb   |     6 -\r\n db/migrate/20130730214020_rename_dialog_order_to_position.rb                     |     8 -\r\n ...0130801152053_remove_double_serialization_in_configuration_settings_column.rb |    20 -\r\n db/migrate/20130806180520_add_provision_idx_to_service_resources.rb              |     5 -\r\n .../20130809172032_change_miq_event_description_from_mgmt_sys_to_provider.rb     |    23 -\r\n db/migrate/20130809202309_add_type_to_availability_zones_and_flavors.rb          |    40 -\r\n db/migrate/20130822002643_add_availability_zone_to_ems_events.rb                 |     5 -\r\n db/migrate/20130826174120_change_nil_provision_index_to_zero.rb                  |    10 -\r\n db/migrate/20130826194420_add_storage_domain_type_to_storages.rb                 |     5 -\r\n db/migrate/20130829193552_add_supports32_bit_and64_bit_to_flavors.rb             |     6 -\r\n db/migrate/20130829204023_add_bitness_to_hardwares.rb                            |     5 -\r\n db/migrate/20130903210812_add_vm_habtm_security_groups.rb                        |     8 -\r\n db/migrate/20130904193717_add_vm_habtm_key_pairs.rb                              |     8 -\r\n db/migrate/20130909231726_add_enabled_to_flavors.rb                              |     5 -\r\n db/migrate/20130910193641_create_floating_ips.rb                                 |    11 -\r\n db/migrate/20130910204759_add_rhn_mirror.rb                                      |     5 -\r\n db/migrate/20130912141816_create_cloud_volume_and_cloud_volume_snapshot.rb       |    21 -\r\n ...2201251_add_name_and_description_to_cloud_volume_and_cloud_volume_snapshot.rb |     8 -\r\n db/migrate/20130919000000_remove_cloud_modeling_via_hosts_and_clusters.rb        |   107 -\r\n db/migrate/20130919172020_add_retirement_state_to_vms_and_services.rb            |     7 -\r\n db/migrate/20130923182042_collapsed_initial_migration.rb                         |  3717 +++++++\r\n db/migrate/20130923182042_create_cloud_networks_and_subnets.rb                   |    25 -\r\n lib/migration_helper.rb                                                          |   209 +-\r\n lib/migration_helper/performances_views.rb                                       |    38 -\r\n spec/migrations/20100310182434_add_priority_to_assigned_server_roles_spec.rb     |    82 -\r\n spec/migrations/20100407192439_add_responds_to_events_to_miq_alerts_spec.rb      |    20 -\r\n spec/migrations/20100408131912_update_system_schedules_spec.rb                   |    28 -\r\n spec/migrations/20100413003434_remove_miq_alert_contents_spec.rb                 |    74 -\r\n spec/migrations/20100515003009_remove_vim_performance_metrics_spec.rb            |    98 -\r\n spec/migrations/20100622195644_add_start_address_to_partitions_spec.rb           |    46 -\r\n spec/migrations/20100730193012_add_miq_group_to_vms_and_users_spec.rb            |    59 -\r\n spec/migrations/20100830200755_remove_reserved_spec.rb                           |    26 -\r\n spec/migrations/20100902190255_convert_smis_class_hier_to_string_spec.rb         |    28 -\r\n spec/migrations/20100902210402_add_type_to_miq_cim_instances_spec.rb             |    16 -\r\n spec/migrations/20100914223945_remove_reserved_from_automation_spec.rb           |    26 -\r\n spec/migrations/20100924173953_add_description_to_miq_regions_spec.rb            |    16 -\r\n spec/migrations/20110203035917_make_polymorphic_handler_in_miq_queue_spec.rb     |    34 -\r\n .../20110223170600_convert_miq_smis_agents_to_storage_managers_spec.rb           |    58 -\r\n spec/migrations/20110602123937_change_alert_processor_to_notifier_spec.rb        |    50 -\r\n spec/migrations/20110805164836_add_type_to_hosts_spec.rb                         |    28 -\r\n spec/migrations/20110822140627_add_settings_to_miq_group_spec.rb                 |    25 -\r\n spec/migrations/20110901140214_add_type_to_ext_management_systems_spec.rb        |    26 -\r\n ...227190500_copy_vim_performances_data_to_metrics_subtables_on_postgres_spec.rb |    23 -\r\n ...rt_rubyrep_data_for_vim_performances_to_metrics_subtables_on_postgres_spec.rb |    30 -\r\n spec/migrations/20111230141215_remove_automation_requests_and_tasks_spec.rb      |    67 -\r\n spec/migrations/20120123170106_ontap_rename_stats_to_metrics_spec.rb             |    34 -\r\n spec/migrations/20120126211839_add_type_to_vms_spec.rb                           |    54 -\r\n spec/migrations/20120328210051_add_expires_on_to_miq_queue_spec.rb               |    26 -\r\n .../20120511235150_remove_reserves_values_for_miq_worker_sql_spid_spec.rb        |    21 -\r\n .../20120607195908_rename_table_type_column_to_type_in_vmdb_table_spec.rb        |    36 -\r\n .../20120608194236_add_capture_interval_name_to_vmdb_metric_tables_spec.rb       |    25 -\r\n spec/migrations/20120620215904_convert_old_states_to_new_format_spec.rb          |    63 -\r\n .../20120625173520_migrate_automate_uri_data_to_resource_actions_spec.rb         |    90 -\r\n spec/migrations/20120706153004_agnostic_server_roles_spec.rb                     |   285 -\r\n spec/migrations/20120716182000_rename_states_to_drift_states_spec.rb             |    68 -\r\n .../20120716194013_set_type_for_ontap_flex_vol_and_disk_extent_spec.rb           |    46 -\r\n spec/migrations/20120719214738_rename_automation_uri_to_custom_button_spec.rb    |   132 -\r\n spec/migrations/20120822180220_add_prov_type_to_service_templates_spec.rb        |    21 -\r\n spec/migrations/20120827162810_add_ems_cluster_id_to_hosts_and_vms_spec.rb       |    28 -\r\n spec/migrations/20120828220222_add_type_to_customization_template_spec.rb        |    16 -\r\n spec/migrations/20121022185550_add_resource_to_miq_widget_contents_spec.rb       |    82 -\r\n ...ob_and_binary_blob_part_size_values_from_character_length_to_bytesize_spec.rb |    27 -\r\n spec/migrations/20121121173839_change_port_in_rhevm30_instances_spec.rb          |    40 -\r\n spec/migrations/20130521133700_fix_vm_or_template_alerts_spec.rb                 |    36 -\r\n spec/migrations/20130701174443_remove_emstype_from_ems_spec.rb                   |    26 -\r\n spec/migrations/20130715221820_add_order_to_dialog_resources_spec.rb             |   105 -\r\n spec/migrations/20130719204831_add_cloud_to_vms_spec.rb                          |    60 -\r\n spec/migrations/20130725224004_change_firewall_rules_to_polymorphic_spec.rb      |    33 -\r\n ...01152053_remove_double_serialization_in_configuration_settings_column_spec.rb |    32 -\r\n ...20130809172032_change_miq_event_description_from_mgmt_sys_to_provider_spec.rb |    18 -\r\n .../migrations/20130809202309_add_type_to_availability_zones_and_flavors_spec.rb |    35 -\r\n spec/migrations/20130826174120_change_nil_provision_index_to_zero_spec.rb        |    27 -\r\n .../20130919000000_remove_cloud_modeling_via_hosts_and_clusters_spec.rb          |   162 -\r\n .../data/20120620215904_convert_old_states_to_new_format_spec/host.yaml          |  1144 ---\r\n .../data/20120620215904_convert_old_states_to_new_format_spec/host_expected.yaml |  9321 ------------------\r\n .../data/20120620215904_convert_old_states_to_new_format_spec/vm_linux.yaml      |  1674 ----\r\n .../20120620215904_convert_old_states_to_new_format_spec/vm_linux_expected.yaml  | 19729 -------------------------------------\r\n .../data/20120620215904_convert_old_states_to_new_format_spec/vm_windows.yaml    |   879 --\r\n .../vm_windows_expected.yaml                                                     |  6397 ------------\r\n 360 files changed, 3722 insertions(+), 52735 deletions(-)\r\n```"},"comment":{"url":"https://api.github.com/repos/ManageIQ/manageiq/issues/comments/121980821","html_url":"https://github.com/ManageIQ/manageiq/pull/3454#issuecomment-121980821","issue_url":"https://api.github.com/repos/ManageIQ/manageiq/issues/3454","id":121980821,"user":{"login":"Fryguy","id":52120,"avatar_url":"https://avatars.githubusercontent.com/u/52120?v=3","gravatar_id":"","url":"https://api.github.com/users/Fryguy","html_url":"https://github.com/Fryguy","followers_url":"https://api.github.com/users/Fryguy/followers","following_url":"https://api.github.com/users/Fryguy/following{/other_user}","gists_url":"https://api.github.com/users/Fryguy/gists{/gist_id}","starred_url":"https://api.github.com/users/Fryguy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Fryguy/subscriptions","organizations_url":"https://api.github.com/users/Fryguy/orgs","repos_url":"https://api.github.com/users/Fryguy/repos","events_url":"https://api.github.com/users/Fryguy/events{/privacy}","received_events_url":"https://api.github.com/users/Fryguy/received_events","type":"User","site_admin":false},"created_at":"2015-07-16T14:56:46Z","updated_at":"2015-07-16T14:56:46Z","body":"I figured out the id issue and opened #3479 "}}