From 046d3a48fdf83496fd352ee51b7c836d7e69a313 Mon Sep 17 00:00:00 2001
From: "mkanat%bugzilla.org" <>
Date: Mon, 30 Mar 2009 23:16:05 +0000
Subject: Bug 423613: Make profiles.extern_id actually UNIQUE in the DB schema.
 Patch by arbingersys@gmail.com r=mkanat, a=mkanat

---
 Bugzilla/Install/DB.pm | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'Bugzilla/Install')

diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm
index ff949f58e..ec6c8ce9c 100644
--- a/Bugzilla/Install/DB.pm
+++ b/Bugzilla/Install/DB.pm
@@ -554,6 +554,10 @@ sub update_table_definitions {
 
     _add_visiblity_value_to_value_tables();
 
+    # 2009-03-02 arbingersys@gmail.com - Bug 423613
+    $dbh->bz_add_index('profiles', 'profiles_extern_id_idx',
+                       {TYPE => 'UNIQUE', FIELDS => [qw(extern_id)]});
+ 
     ################################################################
     # New --TABLE-- changes should go *** A B O V E *** this point #
     ################################################################
-- 
cgit v1.2.3-24-g4f1b