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/DB | |
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/DB')
-rw-r--r-- | Bugzilla/DB/Schema.pm | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 975fa7067..dbcffac7c 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -1138,17 +1138,18 @@ use constant ABSTRACT_SCHEMA => { logincookies => { FIELDS => [ - cookie => {TYPE => 'varchar(22)', NOTNULL => 1, - PRIMARYKEY => 1}, + cookie => {TYPE => 'varchar(22)', NOTNULL => 1}, userid => {TYPE => 'INT3', NOTNULL => 1, REFERENCES => {TABLE => 'profiles', COLUMN => 'userid', DELETE => 'CASCADE'}}, ipaddr => {TYPE => 'varchar(40)'}, lastused => {TYPE => 'DATETIME', NOTNULL => 1}, + id => {TYPE => 'INTSERIAL', NOTNULL => 1, PRIMARYKEY => 1}, ], INDEXES => [ logincookies_lastused_idx => ['lastused'], + logincookies_cookie_idx => {FIELDS => ['cookie'], TYPE => 'UNIQUE'}, ], }, |