From 7b055b9f5a7f4250e6effb230bbfb1f7996b1904 Mon Sep 17 00:00:00 2001
From: Byron Jones <glob@mozilla.com>
Date: Thu, 18 Sep 2014 13:20:05 +0800
Subject: Bug 1054141: add the ability to filter on the user that made the
 change (schema only)

---
 extensions/BugmailFilter/Extension.pm | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)

(limited to 'extensions/BugmailFilter')

diff --git a/extensions/BugmailFilter/Extension.pm b/extensions/BugmailFilter/Extension.pm
index 035de241c..f645d03ac 100644
--- a/extensions/BugmailFilter/Extension.pm
+++ b/extensions/BugmailFilter/Extension.pm
@@ -416,6 +416,15 @@ sub db_schema_abstract_schema {
                     DELETE => 'CASCADE'
                 },
             },
+            changer_id => {
+                TYPE       => 'INT3',
+                NOTNULL    => 0,
+                REFERENCES => {
+                    TABLE  => 'profiles',
+                    COLUMN => 'userid',
+                    DELETE => 'CASCADE'
+                },
+            },
             relationship => {
                 TYPE       => 'INT2',
                 NOTNULL    => 0,
@@ -438,6 +447,17 @@ sub db_schema_abstract_schema {
     };
 }
 
+sub install_update_db {
+    Bugzilla->dbh->bz_add_column(
+        'bugmail_filters',
+        'changer_id',
+        {
+            TYPE    => 'INT3',
+            NOTNULL => 0,
+        }
+    );
+}
+
 sub db_sanitize {
     my $dbh = Bugzilla->dbh;
     print "Deleting bugmail filters...\n";
-- 
cgit v1.2.3-24-g4f1b