Move slack, hipchat and jabber integrations to plugins

3 files changed, 51 insertions, 0 deletions

diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php
index b85c185e..d3c0d3b6 100644
--- a/app/Schema/Mysql.php
+++ b/app/Schema/Mysql.php
@@ -39,6 +39,23 @@ function version_93($pdo)
             UNIQUE(task_id, name)
         ) ENGINE=InnoDB CHARSET=utf8
     ");
+
+    $pdo->exec("DROP TABLE project_integrations");
+
+    $pdo->exec("DELETE FROM settings WHERE `option`='integration_jabber'");
+    $pdo->exec("DELETE FROM settings WHERE `option`='integration_jabber_server'");
+    $pdo->exec("DELETE FROM settings WHERE `option`='integration_jabber_domain'");
+    $pdo->exec("DELETE FROM settings WHERE `option`='integration_jabber_username'");
+    $pdo->exec("DELETE FROM settings WHERE `option`='integration_jabber_password'");
+    $pdo->exec("DELETE FROM settings WHERE `option`='integration_jabber_nickname'");
+    $pdo->exec("DELETE FROM settings WHERE `option`='integration_jabber_room'");
+    $pdo->exec("DELETE FROM settings WHERE `option`='integration_hipchat'");
+    $pdo->exec("DELETE FROM settings WHERE `option`='integration_hipchat_api_url'");
+    $pdo->exec("DELETE FROM settings WHERE `option`='integration_hipchat_room_id'");
+    $pdo->exec("DELETE FROM settings WHERE `option`='integration_hipchat_room_token'");
+    $pdo->exec("DELETE FROM settings WHERE `option`='integration_slack_webhook'");
+    $pdo->exec("DELETE FROM settings WHERE `option`='integration_slack_webhook_url'");
+    $pdo->exec("DELETE FROM settings WHERE `option`='integration_slack_webhook_channel'");
 }
 
 function version_92($pdo)
diff --git a/app/Schema/Postgres.php b/app/Schema/Postgres.php
index 1a399cfc..165b11d2 100644
--- a/app/Schema/Postgres.php
+++ b/app/Schema/Postgres.php
@@ -39,6 +39,23 @@ function version_73($pdo)
             UNIQUE(task_id, name)
         )
     ");
+
+    $pdo->exec("DROP TABLE project_integrations");
+
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_jabber'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_jabber_server'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_jabber_domain'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_jabber_username'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_jabber_password'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_jabber_nickname'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_jabber_room'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_hipchat'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_hipchat_api_url'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_hipchat_room_id'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_hipchat_room_token'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_slack_webhook'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_slack_webhook_url'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_slack_webhook_channel'");
 }
 
 function version_72($pdo)
diff --git a/app/Schema/Sqlite.php b/app/Schema/Sqlite.php
index 1a60443f..e8dcf50e 100644
--- a/app/Schema/Sqlite.php
+++ b/app/Schema/Sqlite.php
@@ -39,6 +39,23 @@ function version_88($pdo)
             UNIQUE(task_id, name)
         )
     ");
+
+    $pdo->exec("DROP TABLE project_integrations");
+
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_jabber'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_jabber_server'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_jabber_domain'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_jabber_username'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_jabber_password'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_jabber_nickname'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_jabber_room'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_hipchat'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_hipchat_api_url'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_hipchat_room_id'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_hipchat_room_token'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_slack_webhook'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_slack_webhook_url'");
+    $pdo->exec("DELETE FROM settings WHERE \"option\"='integration_slack_webhook_channel'");
 }
 
 function version_87($pdo)