diff options
author | Dylan William Hardison <dylan@hardison.net> | 2014-04-07 08:41:11 +0200 |
---|---|---|
committer | Dylan William Hardison <dylan@hardison.net> | 2014-04-22 22:37:52 +0200 |
commit | eab44b1aad3f243dd69b1d30519b73a1e537fda2 (patch) | |
tree | 45e67469b8c6905a545dc5f2bd8bbe03bd41ea7c /Bugzilla/DB | |
parent | 36f56bd9112c2e930fb5bdbee3b5c89334de5247 (diff) | |
download | bugzilla-eab44b1aad3f243dd69b1d30519b73a1e537fda2.tar.gz bugzilla-eab44b1aad3f243dd69b1d30519b73a1e537fda2.tar.xz |
Bug 489028 - Record last-visited time of bugs when logged in
r=glob a=justdave
Diffstat (limited to 'Bugzilla/DB')
-rw-r--r-- | Bugzilla/DB/Schema.pm | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 30ed55b9a..cf404f4ca 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -1713,6 +1713,25 @@ use constant ABSTRACT_SCHEMA => { ], }, + bug_user_last_visit => { + FIELDS => [ + id => {TYPE => 'INTSERIAL', NOTNULL => 1, + PRIMARYKEY => 1}, + user_id => {TYPE => 'INT3', NOTNULL => 1, + REFERENCES => {TABLE => 'profiles', + COLUMN => 'userid', + DELETE => 'CASCADE'}}, + bug_id => {TYPE => 'INT3', NOTNULL => 1, + REFERENCES => {TABLE => 'bugs', + COLUMN => 'bug_id', + DELETE => 'CASCADE'}}, + last_visit_ts => {TYPE => 'DATETIME', NOTNULL => 1}, + ], + INDEXES => [ + bug_user_last_visit_idx => {FIELDS => ['user_id', 'bug_id'], + TYPE => 'UNIQUE'} + ], + }, }; # Foreign Keys are added in Bugzilla::DB::bz_add_field_tables |