Bug 1054141: add the ability to filter on the user that made the change

(schema only)

1 files changed, 20 insertions, 0 deletions

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";