diff options
| author | mkanat%bugzilla.org <> | 2009-03-31 01:16:05 +0200 |
|---|---|---|
| committer | mkanat%bugzilla.org <> | 2009-03-31 01:16:05 +0200 |
| commit | 046d3a48fdf83496fd352ee51b7c836d7e69a313 (patch) | |
| tree | cc0a07830cfbe9f6680cae2938151d7185781e67 | |
| parent | d9041c3f97422fb377c3e8d20129f4ef8517f833 (diff) | |
| download | bugzilla-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
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 2 | ||||
| -rw-r--r-- | Bugzilla/Install/DB.pm | 4 |
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 # ################################################################ |