5:39 a.m.
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(a)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(a)redhat.com>
Gerrit-Reviewer: Allon Mureinik <amureini(a)redhat.com>
Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com>
Gerrit-Reviewer: Liran Zelkha <lzelkha(a)redhat.com>
Gerrit-Reviewer: Martin Peřina <mperina(a)redhat.com>
Gerrit-Reviewer: Oved Ourfali <oourfali(a)redhat.com>
Gerrit-Reviewer: Ravi Nori <rnori(a)redhat.com>
Gerrit-Reviewer: Yair Zaslavsky <yzaslavs(a)redhat.com>
Gerrit-Reviewer: automation(a)ovirt.org
Gerrit-Reviewer: oVirt Jenkins CI Server