Eli Mesika has submitted this change and it was merged. Change subject: core: db squash 3.2 upgrade scripts ...................................................................... core: db squash 3.2 upgrade scripts This patch squashes all 03_02_* upgrade scripts into the main database creation scripts. 1) Creating a git branch and removing all upgrade scripts except those with 03_02_* 2) Creating a new 3_2 database based on 1) 3) Using pg_dump to export 3_2 schema & data 4) Replacing the create_tables.sql with the schema file generated on 3) 5) Editing manually insert_data.sql and insert_predefined_roles.sql to have all changes from data exported at step 3) 6) Creating a database engine_db_squash_3_2 on this patch branch 7) Creating a database engine_master on the master branch 8) Use pg_dump to export db from step 6) schema & data 9) Use pg_dump to export db from step 7) schema & data 10) Compare schema & data from steps 8) & 9) Change-Id: I1ce390403c6133b66726089ff3b1e0c91ec4a2c8 Signed-off-by: Eli Mesika <emesika@redhat.com> --- M packaging/dbscripts/common_sp.sql M packaging/dbscripts/create_functions.sql M packaging/dbscripts/create_tables.sql M packaging/dbscripts/dbfunc-common.sh M packaging/dbscripts/insert_data.sql M packaging/dbscripts/insert_predefined_roles.sql D packaging/dbscripts/upgrade/03_02_0010_delete_action_version_map.sql D packaging/dbscripts/upgrade/03_02_0020_add_libvirt_version_col.sql D packaging/dbscripts/upgrade/03_02_0030_delete_permissions_on_vnic.sql D packaging/dbscripts/upgrade/03_02_0040_add_permissions_on_networks.sql D packaging/dbscripts/upgrade/03_02_0050_add_vm_guest_agent_interfaces_table.sql D packaging/dbscripts/upgrade/03_02_0060_change_host_to_server_event_map.sql D packaging/dbscripts/upgrade/03_02_0070_ha_vm_event_notifications.sql D packaging/dbscripts/upgrade/03_02_0080_add_user_vm_manager_to_vm_power_users.sql D packaging/dbscripts/upgrade/03_02_0090_cpuhost_support.sql D packaging/dbscripts/upgrade/03_02_0100_add_cpu_thread_columns.sql D packaging/dbscripts/upgrade/03_02_0110_add_nic_hash_column_to_vm_dynamic.sql D packaging/dbscripts/upgrade/03_02_0120_add_index_to_vm_guest_agent_interfaces.sql D packaging/dbscripts/upgrade/03_02_0130_add_linked_to_vm_interface.sql D packaging/dbscripts/upgrade/03_02_0140_allow_null_network_name_in_vm_interfaces.sql D packaging/dbscripts/upgrade/03_02_0150_add_console_cur_user_name.sql D packaging/dbscripts/upgrade/03_02_0160_drop_guest_user_id_column.sql D packaging/dbscripts/upgrade/03_02_0170_add_admin_internal_user_role_system.sql D packaging/dbscripts/upgrade/03_02_0180_add_pm_proxy_preferences.sql D packaging/dbscripts/upgrade/03_02_0190_add_vds_hardware_info.sql D packaging/dbscripts/upgrade/03_02_0200_add_vm_generation_columns.sql D packaging/dbscripts/upgrade/03_02_0210_add_external_events.sql D packaging/dbscripts/upgrade/03_02_0220_add_pm_multi_agent_support.sql D packaging/dbscripts/upgrade/03_02_0230_extend_lun_size.sql D packaging/dbscripts/upgrade/03_02_0240_add_gluster_action_version_map.sql D packaging/dbscripts/upgrade/03_02_0250_delete_actiongroups_uservmmanager.sql D packaging/dbscripts/upgrade/03_02_0260_add_delete_protection.sql D packaging/dbscripts/upgrade/03_02_0270_gluster_volume_name_unique_constraint.sql D packaging/dbscripts/upgrade/03_02_0280_drop_licenses.sql D packaging/dbscripts/upgrade/03_02_0290_change_vm_guest_agent_interface_mac_address_type.sql D packaging/dbscripts/upgrade/03_02_0300_add_quota_consume_action_group_link.sql D packaging/dbscripts/upgrade/03_02_0310_add_disabled_to_vm_static.sql D packaging/dbscripts/upgrade/03_02_0320_fix_principal_name_in_users_for_ad_users.sql D packaging/dbscripts/upgrade/03_02_0330_add_vds_event_notifications.sql D packaging/dbscripts/upgrade/03_02_0340_gluster_volume_status_events.sql D packaging/dbscripts/upgrade/03_02_0350_add_console_address.sql D packaging/dbscripts/upgrade/03_02_0360_add_secondary_index_to_network.sql D packaging/dbscripts/upgrade/03_02_0370_add_vds_performance_notifications.sql D packaging/dbscripts/upgrade/03_02_0380_gluster_option_changed_event.sql D packaging/dbscripts/upgrade/03_02_0390_align_lun_volume_group_id.sql D packaging/dbscripts/upgrade/03_02_0400_add_login_permission_to_network_user_role.sql D packaging/dbscripts/upgrade/03_02_0410_remove_user_session.sql D packaging/dbscripts/upgrade/03_02_0420_materialized_views_extensions.sql D packaging/dbscripts/upgrade/03_02_0430_dummy.sql D packaging/dbscripts/upgrade/03_02_0440_dummy.sql D packaging/dbscripts/upgrade/03_02_0450_dummy.sql D packaging/dbscripts/upgrade/03_02_0460_add_async_task_task_parameters.sql D packaging/dbscripts/upgrade/03_02_0470_lsm_version_support.sql D packaging/dbscripts/upgrade/03_02_0480_fix_stateless_snapshot.sql D packaging/dbscripts/upgrade/03_02_0490_add_update_column_to_statistics_tables.sql D packaging/dbscripts/upgrade/03_02_0500_add_gluster_hooks_table.sql R packaging/dbscripts/upgrade/03_03_0000_set_version.sql M packaging/dbscripts/upgrade/03_03_0450_add_external_tasks_support.sql 58 files changed, 532 insertions(+), 624 deletions(-) Approvals: Martin Peřina: Looks good to me, but someone else must approve Eli Mesika: Verified Ravi Nori: Looks good to me, but someone else must approve Allon Mureinik: Looks good to me, approved Liran Zelkha: Looks good to me, but someone else must approve -- To view, visit http://gerrit.ovirt.org/30899 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: I1ce390403c6133b66726089ff3b1e0c91ec4a2c8 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: Eli Mesika <emesika@redhat.com> Gerrit-Reviewer: Liran Zelkha <lzelkha@redhat.com> Gerrit-Reviewer: Martin Peřina <mperina@redhat.com> Gerrit-Reviewer: Oved Ourfali <oourfali@redhat.com> Gerrit-Reviewer: Ravi Nori <rnori@redhat.com> Gerrit-Reviewer: Yair Zaslavsky <yzaslavs@redhat.com> Gerrit-Reviewer: automation@ovirt.org Gerrit-Reviewer: oVirt Jenkins CI Server