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/DB/Schema.pm  | 2 ++
 Bugzilla/Install/DB.pm | 4 ++++
 2 files changed, 6 insertions(+)

(limited to 'Bugzilla')

diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index a3fefd8d8..680f754ca 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -825,6 +825,8 @@ use constant ABSTRACT_SCHEMA => {
         INDEXES => [
             profiles_login_name_idx => {FIELDS => ['login_name'],
                                         TYPE => 'UNIQUE'},
+            profiles_extern_id_idx => {FIELDS => ['extern_id'],
+                                       TYPE   => 'UNIQUE'}
         ],
     },
 
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