Shireesh Anjal has uploaded a new change for review. Change subject: gluster: Unique constraint for gluster volume name ......................................................................
gluster: Unique constraint for gluster volume name Removed the old index which was not unique, and created a new unique constraint Change-Id: Ib4d37d656e793d351b1744abdf35cb3b28019632 Signed-off-by: Shireesh Anjal <san...@redhat.com> --- A backend/manager/dbscripts/upgrade/03_02_0190_gluster_volume_name_unique_constraint.sql 1 file changed, 5 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/28/10428/1 diff --git a/backend/manager/dbscripts/upgrade/03_02_0190_gluster_volume_name_unique_constraint.sql b/backend/manager/dbscripts/upgrade/03_02_0190_gluster_volume_name_unique_constraint.sql new file mode 100644 index 0000000..309f54f --- /dev/null +++ b/backend/manager/dbscripts/upgrade/03_02_0190_gluster_volume_name_unique_constraint.sql @@ -0,0 +1,5 @@ +-- Remove the existing index which is not unique +DROP INDEX IDX_gluster_volumes_name_unique; + +-- Create a unique constraint +ALTER TABLE gluster_volume_options ADD CONSTRAINT gluster_volumes_name_unique UNIQUE(cluster_id, vol_name); -- To view, visit http://gerrit.ovirt.org/10428 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ib4d37d656e793d351b1744abdf35cb3b28019632 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Shireesh Anjal <san...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
