diff options
| author | David Lawrence <dkl@redhat.com> | 2014-05-29 16:20:08 +0200 |
|---|---|---|
| committer | David Lawrence <dkl@redhat.com> | 2014-05-29 16:20:08 +0200 |
| commit | 775b7cc8b474b31f4315d4f714acddac96e73b7a (patch) | |
| tree | 92bf4c4b34bb573b531bc7a95c1ff412a44ea24f /Bugzilla/DB | |
| parent | 1af952ceaa1c06a10e0eeb6f139e5a5652002e98 (diff) | |
| parent | 24a16ae497460834719d6214a7e73ecc7982f9fa (diff) | |
| download | bugzilla-775b7cc8b474b31f4315d4f714acddac96e73b7a.tar.gz bugzilla-775b7cc8b474b31f4315d4f714acddac96e73b7a.tar.xz | |
Merge remote branch 'origin/master'
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 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 |