summaryrefslogtreecommitdiffstats
path: root/Bugzilla
diff options
context:
space:
mode:
authormkanat%bugzilla.org <>2009-03-31 01:16:05 +0200
committermkanat%bugzilla.org <>2009-03-31 01:16:05 +0200
commit046d3a48fdf83496fd352ee51b7c836d7e69a313 (patch)
treecc0a07830cfbe9f6680cae2938151d7185781e67 /Bugzilla
parentd9041c3f97422fb377c3e8d20129f4ef8517f833 (diff)
downloadbugzilla-046d3a48fdf83496fd352ee51b7c836d7e69a313.tar.gz
bugzilla-046d3a48fdf83496fd352ee51b7c836d7e69a313.tar.xz
Bug 423613: Make profiles.extern_id actually UNIQUE in the DB schema.
Patch by arbingersys@gmail.com r=mkanat, a=mkanat
Diffstat (limited to 'Bugzilla')
-rw-r--r--Bugzilla/DB/Schema.pm2
-rw-r--r--Bugzilla/Install/DB.pm4
2 files changed, 6 insertions, 0 deletions
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 #
################################################################