Shirly Radco has uploaded a new change for review. Change subject: history:Removes ad_domain column from vm_configuration table ......................................................................
history:Removes ad_domain column from vm_configuration table This patch removes ad_domain column from vm_configuration table. Change-Id: I4047a8eedae7160fa634125f7c5864703c3cdaab Related-To: https://bugzilla.redhat.com/1051041 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 A packaging/dbscripts/upgrade/03_04_0040_drop_ad_domain_from_vm_configuration.sql 6 files changed, 11 insertions(+), 10 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/84/23884/1 diff --git a/packaging/dbscripts/create_views_3_0.sql b/packaging/dbscripts/create_views_3_0.sql index a0b66df..d742431 100644 --- a/packaging/dbscripts/create_views_3_0.sql +++ b/packaging/dbscripts/create_views_3_0.sql @@ -440,7 +440,7 @@ number_of_sockets as number_of_sockets, memory_size_mb as memory_size_mb, operating_system as operating_system, - ad_domain as ad_domain, + NULL as ad_domain, default_host as default_host, high_availability as high_availability, initialized as initialized, @@ -471,7 +471,7 @@ number_of_sockets as number_of_sockets, memory_size_mb as memory_size_mb, operating_system as operating_system, - ad_domain as ad_domain, + NULL as ad_domain, default_host as default_host, high_availability as high_availability, initialized as initialized, diff --git a/packaging/dbscripts/create_views_3_1.sql b/packaging/dbscripts/create_views_3_1.sql index 5913b37..b5387ea 100644 --- a/packaging/dbscripts/create_views_3_1.sql +++ b/packaging/dbscripts/create_views_3_1.sql @@ -444,7 +444,7 @@ number_of_sockets as number_of_sockets, memory_size_mb as memory_size_mb, operating_system as operating_system, - ad_domain as ad_domain, + NULL as ad_domain, default_host as default_host, high_availability as high_availability, initialized as initialized, @@ -475,7 +475,7 @@ number_of_sockets as number_of_sockets, memory_size_mb as memory_size_mb, operating_system as operating_system, - ad_domain as ad_domain, + NULL as ad_domain, default_host as default_host, high_availability as high_availability, initialized as initialized, diff --git a/packaging/dbscripts/create_views_3_2.sql b/packaging/dbscripts/create_views_3_2.sql index a2349a3..e5ed31a 100644 --- a/packaging/dbscripts/create_views_3_2.sql +++ b/packaging/dbscripts/create_views_3_2.sql @@ -447,7 +447,7 @@ number_of_sockets as number_of_sockets, memory_size_mb as memory_size_mb, operating_system as operating_system, - ad_domain as ad_domain, + NULL as ad_domain, default_host as default_host, high_availability as high_availability, initialized as initialized, @@ -477,7 +477,7 @@ number_of_sockets as number_of_sockets, memory_size_mb as memory_size_mb, operating_system as operating_system, - ad_domain as ad_domain, + NULL as ad_domain, default_host as default_host, high_availability as high_availability, initialized as initialized, diff --git a/packaging/dbscripts/create_views_3_3.sql b/packaging/dbscripts/create_views_3_3.sql index 8d635ea..c9c8add 100644 --- a/packaging/dbscripts/create_views_3_3.sql +++ b/packaging/dbscripts/create_views_3_3.sql @@ -447,7 +447,7 @@ number_of_sockets as number_of_sockets, memory_size_mb as memory_size_mb, operating_system as operating_system, - ad_domain as ad_domain, + NULL as ad_domain, default_host as default_host, high_availability as high_availability, initialized as initialized, @@ -479,7 +479,7 @@ number_of_sockets as number_of_sockets, memory_size_mb as memory_size_mb, operating_system as operating_system, - ad_domain as ad_domain, + NULL as ad_domain, default_host as default_host, high_availability as high_availability, initialized as initialized, diff --git a/packaging/dbscripts/create_views_3_4.sql b/packaging/dbscripts/create_views_3_4.sql index 95398d3..d94563f 100644 --- a/packaging/dbscripts/create_views_3_4.sql +++ b/packaging/dbscripts/create_views_3_4.sql @@ -446,7 +446,6 @@ number_of_sockets as number_of_sockets, memory_size_mb as memory_size_mb, operating_system as operating_system, - ad_domain as ad_domain, default_host as default_host, high_availability as high_availability, initialized as initialized, @@ -480,7 +479,6 @@ number_of_sockets as number_of_sockets, memory_size_mb as memory_size_mb, operating_system as operating_system, - ad_domain as ad_domain, default_host as default_host, high_availability as high_availability, initialized as initialized, diff --git a/packaging/dbscripts/upgrade/03_04_0040_drop_ad_domain_from_vm_configuration.sql b/packaging/dbscripts/upgrade/03_04_0040_drop_ad_domain_from_vm_configuration.sql new file mode 100644 index 0000000..fc595dc --- /dev/null +++ b/packaging/dbscripts/upgrade/03_04_0040_drop_ad_domain_from_vm_configuration.sql @@ -0,0 +1,3 @@ +--delete ad_domain column from vm_configuration table +SELECT fn_db_drop_column('vm_configuration', 'ad_domain'); + -- To view, visit http://gerrit.ovirt.org/23884 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I4047a8eedae7160fa634125f7c5864703c3cdaab 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
