diff options
| author | Frédéric Buclin <LpSolit@gmail.com> | 2015-08-14 00:09:28 +0200 |
|---|---|---|
| committer | Frédéric Buclin <LpSolit@gmail.com> | 2015-08-14 00:09:28 +0200 |
| commit | ac956759a67e7bff80b8a987cf7f6b646d1ee37f (patch) | |
| tree | 136b585d1be1cdcd4aeea4fe84cd25611779f772 /Bugzilla | |
| parent | 8ebf35e43c3be63a6ad91239d4dee19ab50e769f (diff) | |
| download | bugzilla-ac956759a67e7bff80b8a987cf7f6b646d1ee37f.tar.gz bugzilla-ac956759a67e7bff80b8a987cf7f6b646d1ee37f.tar.xz | |
Bug 946780: The 'version' column of the 'bz_schema' DB table should be UNIQUE
r=dkl a=sgreen
Diffstat (limited to 'Bugzilla')
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 3 | ||||
| -rw-r--r-- | Bugzilla/Install/DB.pm | 4 |
2 files changed, 7 insertions, 0 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 5d5d52508..d770f2358 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -1748,6 +1748,9 @@ use constant ABSTRACT_SCHEMA => { schema_data => {TYPE => 'LONGBLOB', NOTNULL => 1}, version => {TYPE => 'decimal(3,2)', NOTNULL => 1}, ], + INDEXES => [ + bz_schema_version_idx => {FIELDS => ['version'], TYPE => 'UNIQUE'}, + ], }, bug_user_last_visit => { diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index d317ee594..bb82f5e2d 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -741,6 +741,10 @@ sub update_table_definitions { $dbh->bz_alter_column('logincookies', 'cookie', {TYPE => 'varchar(22)', NOTNULL => 1, PRIMARYKEY => 1}); + # 2015-07-16 LpSolit@gmail.com - Bug 946780 + $dbh->bz_add_index('bz_schema', 'bz_schema_version_idx', + {FIELDS => ['version'], TYPE => 'UNIQUE'}); + ################################################################ # New --TABLE-- changes should go *** A B O V E *** this point # ################################################################ |