diff options
| author | Dylan William Hardison <dylan@mozilla.com> | 2015-08-24 10:18:37 +0200 |
|---|---|---|
| committer | Byron Jones <glob@mozilla.com> | 2015-08-24 10:18:37 +0200 |
| commit | 57f911c45c2d1a434243633b4b178a8775597593 (patch) | |
| tree | a2fc537f91222a3171a9dd2f0eee5d9b8603959d /Bugzilla/Install | |
| parent | 0b05719fc8029a128c9b8e8e85109f3f8c13f47a (diff) | |
| download | bugzilla-57f911c45c2d1a434243633b4b178a8775597593.tar.gz bugzilla-57f911c45c2d1a434243633b4b178a8775597593.tar.xz | |
Bug 1196092 - Switch logincookies primary key to auto_incremented id, make cookie a secondary UNIQUE key
Diffstat (limited to 'Bugzilla/Install')
| -rw-r--r-- | Bugzilla/Install/DB.pm | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index 02777d7f1..ce148d62d 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -733,8 +733,14 @@ sub update_table_definitions { # 2015-07-25 dylan@mozilla.com - Bug 1179856 $dbh->bz_alter_column('tokens', 'token', {TYPE => 'varchar(22)', NOTNULL => 1, PRIMARYKEY => 1}); + + # 2015-08-20 dylan@mozilla.com - Bug 1196092 $dbh->bz_alter_column('logincookies', 'cookie', - {TYPE => 'varchar(22)', NOTNULL => 1, PRIMARYKEY => 1}); + {TYPE => 'varchar(22)', NOTNULL => 1}); + $dbh->bz_add_index('logincookies', 'logincookies_cookie_idx', + {TYPE => 'UNIQUE', FIELDS => ['cookie']}); + $dbh->bz_add_column('logincookies', 'id', + {TYPE => 'INTSERIAL', NOTNULL => 1, PRIMARYKEY => 1}); $dbh->bz_add_column('user_api_keys', 'last_used_ip', {TYPE => 'varchar(40)'}); |