Eli Mesika has submitted this change and it was merged. Change subject: core: Squash 03_05 upgrade scripts into base db ...................................................................... core: Squash 03_05 upgrade scripts into base db This patch introduces all changes made in dbscripts/upgrade/03_05* scripts into the base database. The process of squashing is : 1) creating a git branch with only the squashed version upgrade scripts 2) generating schema and insert files (automatically by pg_dump) 3) restoring all deleted upgrade files with version > squashed version that were deleted in 1) 4) creating a database based on 1) to 3) 5) creating a database on master 6) using the database comparison tool to verify both databases are identical (except some generated UUIDs Change-Id: I0ccd91460ae86af8201302a9abc41149714ef0fd Signed-off-by: emesika <emesika@redhat.com> --- M packaging/dbscripts/create_tables.sql M packaging/dbscripts/data/00000_insert_schema_version.sql M packaging/dbscripts/data/00200_insert_ad_groups.sql M packaging/dbscripts/data/00300_insert_storage_pool.sql M packaging/dbscripts/data/00340_insert_policy_units.sql M packaging/dbscripts/data/00350_insert_cluster_policies.sql M packaging/dbscripts/data/00360_insert_cluster_policy_units.sql M packaging/dbscripts/data/00400_insert_vds_groups.sql M packaging/dbscripts/data/00500_insert_roles.sql M packaging/dbscripts/data/00600_insert_permissions.sql M packaging/dbscripts/data/00700_insert_roles_groups.sql M packaging/dbscripts/data/00900_insert_network.sql M packaging/dbscripts/data/01000_insert_network_cluster.sql M packaging/dbscripts/data/01100_insert_vm_static.sql M packaging/dbscripts/data/01200_insert_vm_device.sql M packaging/dbscripts/data/01300_insert_vm_ovf_generations.sql M packaging/dbscripts/data/01400_insert_action_version_map.sql M packaging/dbscripts/data/01500_insert_event_map.sql M packaging/dbscripts/data/01600_insert_dwh_history_timekeeping.sql M packaging/dbscripts/data/02000_insert_vm_init.sql M packaging/dbscripts/dbfunc-common.sh D packaging/dbscripts/upgrade/03_05_0010_add_tables_for_gluster_volume_and_brick_details.sql D packaging/dbscripts/upgrade/03_05_0020_gluster_refresh_gluster_volume_details-event_map.sql D packaging/dbscripts/upgrade/03_05_0030_add_ha_columns_to_vds_statistics.sql D packaging/dbscripts/upgrade/03_05_0040_add_ha_maintenance_events.sql D packaging/dbscripts/upgrade/03_05_0050_event_notification_methods.sql D packaging/dbscripts/upgrade/03_05_0060_event_map_vds_failure.sql D packaging/dbscripts/upgrade/03_05_0070_fix_event_notfication_method.sql D packaging/dbscripts/upgrade/03_05_0080_add_missing_manipulate_users_permissions.sql D packaging/dbscripts/upgrade/03_05_0090_delete_network_labels_action_groups.sql D packaging/dbscripts/upgrade/03_05_0100_allow_values_higher_9_for_cpuovercommit.sql D packaging/dbscripts/upgrade/03_05_0110_add_vm_serial_number_policy.sql D packaging/dbscripts/upgrade/03_05_0120_add_storage_domain_ovf.sql D packaging/dbscripts/upgrade/03_05_0130_add_ovf_data_column.sql D packaging/dbscripts/upgrade/03_05_0140_add_install_vds_upgrade_ovirt_node_action_group.sql D packaging/dbscripts/upgrade/03_05_0150_remove_import_export_permission_from_user_instance_manager_role.sql D packaging/dbscripts/upgrade/03_05_0160_add_host_interface_high_network_use_event.sql D packaging/dbscripts/upgrade/03_05_0170_add_boot_time_to_vds_statistics.sql D packaging/dbscripts/upgrade/03_05_0180_vm_init_add_sysprep_locale.sql D packaging/dbscripts/upgrade/03_05_0190_vm_init_add_user_name.sql D packaging/dbscripts/upgrade/03_05_0200_vm_init_add_active_directory_ou.sql D packaging/dbscripts/upgrade/03_05_0210_change_group_ids.sql D packaging/dbscripts/upgrade/03_05_0220_update_user_ids.sql D packaging/dbscripts/upgrade/03_05_0230_add_host_interface_status_change_events.sql D packaging/dbscripts/upgrade/03_05_0240_change_external_id_to_string.sql D packaging/dbscripts/upgrade/03_05_0250_add_reason_columns.sql D packaging/dbscripts/upgrade/03_05_0260_add_exit_reason_to_vm_dynamic.sql D packaging/dbscripts/upgrade/03_05_0270_update_template_version_naming.sql D packaging/dbscripts/upgrade/03_05_0280_add_vm_boot_menu.sql D packaging/dbscripts/upgrade/03_05_0290_drop_vds_group_id_constraint_from_vm_static.sql D packaging/dbscripts/upgrade/03_05_0300_add_host_kdump_detection.sql D packaging/dbscripts/upgrade/03_05_0310_add_host_kdump_status.sql D packaging/dbscripts/upgrade/03_05_0320_add_vds_interface_custom_properties.sql D packaging/dbscripts/upgrade/03_05_0330_nullify_external_network_labels.sql D packaging/dbscripts/upgrade/03_05_0340_add_migration_progress_percent_to_vm_dynamic.sql D packaging/dbscripts/upgrade/03_05_0350_add_display_network_change_events.sql D packaging/dbscripts/upgrade/03_05_0360_add_audit_log_operation_action_group_and_roles.sql D packaging/dbscripts/upgrade/03_05_0370_add_base_interface_column_to_vds_interfaces.sql D packaging/dbscripts/upgrade/03_05_0380_reintroduce_powersaving_variables.sql D packaging/dbscripts/upgrade/03_05_0390_add_guest_cpu_count_to_vm_dynamic.sql D packaging/dbscripts/upgrade/03_05_0400_index_for_snapshot_type.sql D packaging/dbscripts/upgrade/03_05_0410_add_selinux_to_vds_dynamic.sql D packaging/dbscripts/upgrade/03_05_0420_generalize_messaging_broker_type.sql D packaging/dbscripts/upgrade/03_05_0430_add_numa_tables_and_columns.sql D packaging/dbscripts/upgrade/03_05_0440_add_create_and_update_dates_to_users_table.sql D packaging/dbscripts/upgrade/03_05_0450_set_default_value_for_numa_tune_mode.sql D packaging/dbscripts/upgrade/03_05_0460_set_display_migration_cluster_network.sql D packaging/dbscripts/upgrade/03_05_0470_update_vm_static_child_count.sql D packaging/dbscripts/upgrade/03_05_0480_add_org_name_for_sysprep.sql D packaging/dbscripts/upgrade/03_05_0490_remove_duplicate_smartcards.sql D packaging/dbscripts/upgrade/03_05_0500_add_rng_device_columns.sql D packaging/dbscripts/upgrade/03_05_0510_unregistered_ovf_of_entities.sql D packaging/dbscripts/upgrade/03_05_0520_fix_description_of_balancing_policy_units.sql D packaging/dbscripts/upgrade/03_05_0530_remove_unused_event.sql D packaging/dbscripts/upgrade/03_05_0540_add_spice_transfer_toggle.sql D packaging/dbscripts/upgrade/03_05_0550_add_live_snapshot_support.sql D packaging/dbscripts/upgrade/03_05_0560_aaa_add_namespace.sql D packaging/dbscripts/upgrade/03_05_0570_deprecate_broken_snapshots.sql D packaging/dbscripts/upgrade/03_05_0580_add_default_instance_types.sql D packaging/dbscripts/upgrade/03_05_0590_set_default_time_zone.sql D packaging/dbscripts/upgrade/03_05_0600_drop_images_fk.sql D packaging/dbscripts/upgrade/03_05_0610_add_command_entity_table.sql D packaging/dbscripts/upgrade/03_05_0620_lowercase_default_cluster_policies_names.sql D packaging/dbscripts/upgrade/03_05_0630_add_host_protocol.sql D packaging/dbscripts/upgrade/03_05_0640_add_external_variable.sql D packaging/dbscripts/upgrade/03_05_0650_add_vds_kdump_status.sql D packaging/dbscripts/upgrade/03_05_0660_remove_command_from_async_tasks.sql D packaging/dbscripts/upgrade/03_05_0670_add_cmd_entity_callback_enabled.sql D packaging/dbscripts/upgrade/03_05_0680_add_cmd_entity_callback_notified.sql D packaging/dbscripts/upgrade/03_05_0690_add_cmd_entity_return_value.sql D packaging/dbscripts/upgrade/03_05_0700_create_vm_jobs_table.sql D packaging/dbscripts/upgrade/03_05_0710_add_manipulate_permissions_for_template_admin.sql D packaging/dbscripts/upgrade/03_05_0720_index_for_stoarge_domain_id_in_unregistered_ovf_of_entities.sql D packaging/dbscripts/upgrade/03_05_0730_drop_disk_image_dynamic_fk.sql D packaging/dbscripts/upgrade/03_05_0740_min_allocated_memory_on_instance_type.sql D packaging/dbscripts/upgrade/03_05_0750_delete_orphand_disk_image_dynamic_records.sql R packaging/dbscripts/upgrade/03_06_0000_set_version.sql 97 files changed, 614 insertions(+), 1,078 deletions(-) Approvals: Martin Peřina: Looks good to me, but someone else must approve Eli Mesika: Verified Jenkins CI: Passed CI tests Allon Mureinik: Looks good to me, approved Moti Asayag: Looks good to me, but someone else must approve Arik Hadas: Looks good to me, but someone else must approve -- To view, visit https://gerrit.ovirt.org/60328 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: I0ccd91460ae86af8201302a9abc41149714ef0fd Gerrit-PatchSet: 6 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Eli Mesika <emesika@redhat.com> Gerrit-Reviewer: Allon Mureinik <amureini@redhat.com> Gerrit-Reviewer: Alona Kaplan <alkaplan@redhat.com> Gerrit-Reviewer: Arik Hadas <ahadas@redhat.com> Gerrit-Reviewer: Eli Mesika <emesika@redhat.com> Gerrit-Reviewer: Jenkins CI Gerrit-Reviewer: Martin Peřina <mperina@redhat.com> Gerrit-Reviewer: Moti Asayag <masayag@redhat.com> Gerrit-Reviewer: Oved Ourfali <oourfali@redhat.com> Gerrit-Reviewer: Shirly Radco <sradco@redhat.com> Gerrit-Reviewer: gerrit-hooks <automation@ovirt.org>