summaryrefslogtreecommitdiffstats
path: root/Bugzilla/DB
diff options
context:
space:
mode:
authorDylan William Hardison <dylan@hardison.net>2014-05-28 17:30:47 +0200
committerDylan William Hardison <dylan@hardison.net>2014-05-28 17:32:06 +0200
commit24a16ae497460834719d6214a7e73ecc7982f9fa (patch)
tree9f3b21e15348a7f2793949fe91ad5cc2d0ed4cc0 /Bugzilla/DB
parent7ea36c899372e8e113935ff036e992a819d786b6 (diff)
downloadbugzilla-24a16ae497460834719d6214a7e73ecc7982f9fa.tar.gz
bugzilla-24a16ae497460834719d6214a7e73ecc7982f9fa.tar.xz
Bug 1000917 - allow user last visit searching (schema only)
Diffstat (limited to 'Bugzilla/DB')
-rw-r--r--Bugzilla/DB/Schema.pm19
1 files changed, 19 insertions, 0 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index d8f3e175a..cbcb5b26c 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -1714,6 +1714,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