Bug 1054832: past revisions of comments are not removed by the database sanisisation script

3 files changed, 23 insertions, 0 deletions

diff --git a/extensions/BugmailFilter/Extension.pm b/extensions/BugmailFilter/Extension.pm
index 01719db1f..053b07575 100644
--- a/extensions/BugmailFilter/Extension.pm
+++ b/extensions/BugmailFilter/Extension.pm
@@ -427,4 +427,10 @@ sub db_schema_abstract_schema {
     };
 }
 
+sub db_sanitize {
+    my $dbh = Bugzilla->dbh;
+    print "Deleting bugmail filters...\n";
+    $dbh->do("DELETE FROM bugmail_filters");
+}
+
 __PACKAGE__->NAME;
diff --git a/extensions/EditComments/Extension.pm b/extensions/EditComments/Extension.pm
index a3769544f..fef1b7693 100644
--- a/extensions/EditComments/Extension.pm
+++ b/extensions/EditComments/Extension.pm
@@ -260,4 +260,11 @@ sub webservice {
     $dispatch->{EditComments} = "Bugzilla::Extension::EditComments::WebService";
 }
 
+sub db_sanitize {
+    my $dbh = Bugzilla->dbh;
+    print "Deleting edited comment histories...\n";
+    $dbh->do("DELETE FROM longdescs_activity");
+    $dbh->do("UPDATE longdescs SET edit_count=0");
+}
+
 __PACKAGE__->NAME;
diff --git a/extensions/Push/Extension.pm b/extensions/Push/Extension.pm
index 3332df8e8..1d6ec5b62 100644
--- a/extensions/Push/Extension.pm
+++ b/extensions/Push/Extension.pm
@@ -645,4 +645,14 @@ sub install_filesystem {
     };
 }
 
+sub db_sanitize {
+    my $dbh = Bugzilla->dbh;
+    print "Deleting push extension logs and messages...\n";
+    $dbh->do("DELETE FROM push");
+    $dbh->do("DELETE FROM push_backlog");
+    $dbh->do("DELETE FROM push_backoff");
+    $dbh->do("DELETE FROM push_log");
+    $dbh->do("DELETE FROM push_options");
+}
+
 __PACKAGE__->NAME;