From 09da289c2fb18475f372bee24e885617da484e0b Mon Sep 17 00:00:00 2001
From: Frederic Guillot <fred@kanboard.net>
Date: Sat, 17 Oct 2015 22:19:49 -0400
Subject: Move slack, hipchat and jabber integrations to plugins

---
 app/Schema/Mysql.php    | 17 +++++++++++++++++
 app/Schema/Postgres.php | 17 +++++++++++++++++
 app/Schema/Sqlite.php   | 17 +++++++++++++++++
 3 files changed, 51 insertions(+)

(limited to 'app/Schema')

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)
-- 
cgit v1.2.3