Shirly Radco has uploaded a new change for review. Change subject: history: changed network_name column ......................................................................
history: changed network_name column changed network_name column to logical_network_name. Change-Id: Ic3d2f8815a7dbb48552c1c7b4162c570ea3f43b1 Bug-Url: https://bugzilla.redhat.com/891073 Signed-off-by: Shirly Radco <sra...@redhat.com> --- M packaging/dbscripts/create_views_3_0.sql M packaging/dbscripts/create_views_3_1.sql M packaging/dbscripts/create_views_3_2.sql M packaging/dbscripts/create_views_3_3.sql M packaging/dbscripts/create_views_3_4.sql M packaging/dbscripts/create_views_3_5.sql A packaging/dbscripts/upgrade/03_05_0040_change_network_name_column.sql 7 files changed, 26 insertions(+), 24 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/89/27789/1 diff --git a/packaging/dbscripts/create_views_3_0.sql b/packaging/dbscripts/create_views_3_0.sql index 541f46a..f435799 100644 --- a/packaging/dbscripts/create_views_3_0.sql +++ b/packaging/dbscripts/create_views_3_0.sql @@ -352,7 +352,7 @@ host_interface_type as host_interface_type, host_interface_speed_bps as host_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, ip_address as ip_address, gateway as gateway, bond as bond, @@ -374,7 +374,7 @@ host_interface_type as host_interface_type, host_interface_speed_bps as host_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, ip_address as ip_address, gateway as gateway, bond as bond, @@ -578,7 +578,7 @@ vm_interface_type as vm_interface_type, vm_interface_speed_bps as vm_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, vm_configuration_version as vm_configuration_version, create_date as create_date, update_date as update_date, @@ -595,7 +595,7 @@ vm_interface_type as vm_interface_type, vm_interface_speed_bps as vm_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, vm_configuration_version as vm_configuration_version, create_date as create_date, update_date as update_date diff --git a/packaging/dbscripts/create_views_3_1.sql b/packaging/dbscripts/create_views_3_1.sql index 1d28419..5172690 100644 --- a/packaging/dbscripts/create_views_3_1.sql +++ b/packaging/dbscripts/create_views_3_1.sql @@ -356,7 +356,7 @@ host_interface_type as host_interface_type, host_interface_speed_bps as host_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, ip_address as ip_address, gateway as gateway, bond as bond, @@ -378,7 +378,7 @@ host_interface_type as host_interface_type, host_interface_speed_bps as host_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, ip_address as ip_address, gateway as gateway, bond as bond, @@ -581,7 +581,7 @@ vm_interface_type as vm_interface_type, vm_interface_speed_bps as vm_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, vm_configuration_version as vm_configuration_version, create_date as create_date, update_date as update_date, @@ -597,7 +597,7 @@ vm_interface_type as vm_interface_type, vm_interface_speed_bps as vm_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, vm_configuration_version as vm_configuration_version, create_date as create_date, update_date as update_date diff --git a/packaging/dbscripts/create_views_3_2.sql b/packaging/dbscripts/create_views_3_2.sql index 5a94781..d5c153f 100644 --- a/packaging/dbscripts/create_views_3_2.sql +++ b/packaging/dbscripts/create_views_3_2.sql @@ -359,7 +359,7 @@ host_interface_type as host_interface_type, host_interface_speed_bps as host_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, ip_address as ip_address, gateway as gateway, bond as bond, @@ -381,7 +381,7 @@ host_interface_type as host_interface_type, host_interface_speed_bps as host_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, ip_address as ip_address, gateway as gateway, bond as bond, @@ -628,7 +628,7 @@ vm_interface_type as vm_interface_type, vm_interface_speed_bps as vm_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, vm_configuration_version as vm_configuration_version, create_date as create_date, update_date as update_date, @@ -644,7 +644,7 @@ vm_interface_type as vm_interface_type, vm_interface_speed_bps as vm_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, vm_configuration_version as vm_configuration_version, create_date as create_date, update_date as update_date diff --git a/packaging/dbscripts/create_views_3_3.sql b/packaging/dbscripts/create_views_3_3.sql index d5bb69c..80257a2 100644 --- a/packaging/dbscripts/create_views_3_3.sql +++ b/packaging/dbscripts/create_views_3_3.sql @@ -359,7 +359,7 @@ host_interface_type as host_interface_type, host_interface_speed_bps as host_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, ip_address as ip_address, gateway as gateway, bond as bond, @@ -381,7 +381,7 @@ host_interface_type as host_interface_type, host_interface_speed_bps as host_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, ip_address as ip_address, gateway as gateway, bond as bond, @@ -640,7 +640,7 @@ vm_interface_type as vm_interface_type, vm_interface_speed_bps as vm_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, vm_configuration_version as vm_configuration_version, create_date as create_date, update_date as update_date, @@ -656,7 +656,7 @@ vm_interface_type as vm_interface_type, vm_interface_speed_bps as vm_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, vm_configuration_version as vm_configuration_version, create_date as create_date, update_date as update_date diff --git a/packaging/dbscripts/create_views_3_4.sql b/packaging/dbscripts/create_views_3_4.sql index 93fa4ba..c8f7566 100644 --- a/packaging/dbscripts/create_views_3_4.sql +++ b/packaging/dbscripts/create_views_3_4.sql @@ -358,7 +358,7 @@ host_interface_type as host_interface_type, host_interface_speed_bps as host_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, ip_address as ip_address, gateway as gateway, bond as bond, @@ -380,7 +380,7 @@ host_interface_type as host_interface_type, host_interface_speed_bps as host_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, ip_address as ip_address, gateway as gateway, bond as bond, @@ -645,7 +645,7 @@ vm_interface_type as vm_interface_type, vm_interface_speed_bps as vm_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, vm_configuration_version as vm_configuration_version, create_date as create_date, update_date as update_date, @@ -661,7 +661,7 @@ vm_interface_type as vm_interface_type, vm_interface_speed_bps as vm_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as network_name, vm_configuration_version as vm_configuration_version, create_date as create_date, update_date as update_date diff --git a/packaging/dbscripts/create_views_3_5.sql b/packaging/dbscripts/create_views_3_5.sql index 39322cb..5f34253 100644 --- a/packaging/dbscripts/create_views_3_5.sql +++ b/packaging/dbscripts/create_views_3_5.sql @@ -358,7 +358,7 @@ host_interface_type as host_interface_type, host_interface_speed_bps as host_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as logical_network_name, ip_address as ip_address, gateway as gateway, bond as bond, @@ -380,7 +380,7 @@ host_interface_type as host_interface_type, host_interface_speed_bps as host_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as logical_network_name, ip_address as ip_address, gateway as gateway, bond as bond, @@ -627,7 +627,7 @@ vm_interface_type as vm_interface_type, vm_interface_speed_bps as vm_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as logical_network_name, vm_configuration_version as vm_configuration_version, create_date as create_date, update_date as update_date, @@ -643,7 +643,7 @@ vm_interface_type as vm_interface_type, vm_interface_speed_bps as vm_interface_speed_bps, mac_address as mac_address, - network_name as network_name, + logical_network_name as logical_network_name, vm_configuration_version as vm_configuration_version, create_date as create_date, update_date as update_date diff --git a/packaging/dbscripts/upgrade/03_05_0040_change_network_name_column.sql b/packaging/dbscripts/upgrade/03_05_0040_change_network_name_column.sql new file mode 100644 index 0000000..58e35df --- /dev/null +++ b/packaging/dbscripts/upgrade/03_05_0040_change_network_name_column.sql @@ -0,0 +1,2 @@ +SELECT fn_db_rename_column('host_interface_configuration','network_name','logical_network_name'); +SELECT fn_db_rename_column('vm_interface_configuration','network_name','logical_network_name'); -- To view, visit http://gerrit.ovirt.org/27789 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ic3d2f8815a7dbb48552c1c7b4162c570ea3f43b1 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-dwh Gerrit-Branch: master Gerrit-Owner: Shirly Radco <sra...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
