summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorDave Lawrence <dlawrence@mozilla.com>2013-04-09 17:21:46 +0200
committerDave Lawrence <dlawrence@mozilla.com>2013-04-09 17:21:46 +0200
commit0ceb712501dc3146a4c8d06b7177e1e091362f00 (patch)
tree0991268eedf0c97059e8feade1236f9ca4725b6b
parent2cc30c4cf799041a110f4023e4a3bbc80c384f75 (diff)
downloadbugzilla-0ceb712501dc3146a4c8d06b7177e1e091362f00.tar.gz
bugzilla-0ceb712501dc3146a4c8d06b7177e1e091362f00.tar.xz
Bug 859480 - Backport upstream bug 148564 to current BMO code base
- DB Schema change only
-rw-r--r--Bugzilla/DB/Schema.pm17
1 files changed, 17 insertions, 0 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index f45f82852..89f0e1ecb 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -958,6 +958,23 @@ use constant ABSTRACT_SCHEMA => {
],
},
+ email_bug_ignore => {
+ FIELDS => [
+ 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'}},
+ ],
+ INDEXES => [
+ email_bug_ignore_user_id_idx => {FIELDS => [qw(user_id bug_id)],
+ TYPE => 'UNIQUE'},
+ ],
+ },
+
watch => {
FIELDS => [
watcher => {TYPE => 'INT3', NOTNULL => 1,