Yedidyah Bar David has uploaded a new change for review. Change subject: packaging: dbscripts: drop index if exists ......................................................................
packaging: dbscripts: drop index if exists drop index if exists using IDX_images_images_group_id. Change-Id: Ibacd60bb90ba6e1213b4f0fcb4844aa36ff60fc7 Bug-Url: https://bugzilla.redhat.com/1155153 Signed-off-by: Yedidyah Bar David <[email protected]> (cherry picked from commit be6f4a3e70660e5499b673e32bf689f8a2399fb5) --- M packaging/dbscripts/upgrade/03_05_0720_index_for_stoarge_domain_id_in_unregistered_ovf_of_entities.sql M packaging/dbscripts/upgrade/03_05_1090_create_index_on_images.sql M packaging/dbscripts/upgrade/03_05_1100_create_index_on_vm_device.sql 3 files changed, 3 insertions(+), 5 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/00/35200/1 diff --git a/packaging/dbscripts/upgrade/03_05_0720_index_for_stoarge_domain_id_in_unregistered_ovf_of_entities.sql b/packaging/dbscripts/upgrade/03_05_0720_index_for_stoarge_domain_id_in_unregistered_ovf_of_entities.sql index 4013d28..ac91ed7 100644 --- a/packaging/dbscripts/upgrade/03_05_0720_index_for_stoarge_domain_id_in_unregistered_ovf_of_entities.sql +++ b/packaging/dbscripts/upgrade/03_05_0720_index_for_stoarge_domain_id_in_unregistered_ovf_of_entities.sql @@ -1 +1 @@ -CREATE INDEX IDX_unregistered_ovf_of_entities_storage_domain_id ON unregistered_ovf_of_entities(storage_domain_id); +fn_db_create_index('IDX_unregistered_ovf_of_entities_storage_domain_id', 'unregistered_ovf_of_entities', 'storage_domain_id', ''); diff --git a/packaging/dbscripts/upgrade/03_05_1090_create_index_on_images.sql b/packaging/dbscripts/upgrade/03_05_1090_create_index_on_images.sql index 30007af..a30462a 100644 --- a/packaging/dbscripts/upgrade/03_05_1090_create_index_on_images.sql +++ b/packaging/dbscripts/upgrade/03_05_1090_create_index_on_images.sql @@ -1,4 +1,2 @@ -- Create index -CREATE INDEX IDX_images_images_group_id on images(image_group_id); - - +fn_db_create_index('IDX_images_images_group_id', 'images', 'image_group_id', ''); diff --git a/packaging/dbscripts/upgrade/03_05_1100_create_index_on_vm_device.sql b/packaging/dbscripts/upgrade/03_05_1100_create_index_on_vm_device.sql index e3e399e..aee1424 100644 --- a/packaging/dbscripts/upgrade/03_05_1100_create_index_on_vm_device.sql +++ b/packaging/dbscripts/upgrade/03_05_1100_create_index_on_vm_device.sql @@ -1,3 +1,3 @@ -- Create index -CREATE INDEX IDX_vm_device_vm_id on vm_device(vm_id); +fn_db_create_index('IDX_vm_device_vm_id', 'vm_device', 'vm_id', ''); -- To view, visit http://gerrit.ovirt.org/35200 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ibacd60bb90ba6e1213b4f0fcb4844aa36ff60fc7 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: ovirt-engine-3.5 Gerrit-Owner: Yedidyah Bar David <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
