Add schema migration for Slack channel

4 files changed, 26 insertions, 8 deletions

diff --git a/app/Integration/SlackWebhook.php b/app/Integration/SlackWebhook.php
index a584c132..4f42dca3 100644
--- a/app/Integration/SlackWebhook.php
+++ b/app/Integration/SlackWebhook.php
@@ -38,7 +38,7 @@ class SlackWebhook extends \Core\Base
         $options = $this->projectIntegration->getParameters($project_id);
         return $options['slack_webhook_url'];
     }
-    
+
     /**
      * Get optional Slack channel
      *
@@ -48,10 +48,10 @@ class SlackWebhook extends \Core\Base
      */
     public function getChannel($project_id)
     {
-    	if (!empty($this->config->get('integration_slack_webhook_channel'))) {
+    	if (! empty($this->config->get('integration_slack_webhook_channel'))) {
     		return $this->config->get('integration_slack_webhook_channel');
     	}
-    
+
     	$options = $this->projectIntegration->getParameters($project_id);
     	return $options['slack_webhook_channel'];
     }
@@ -85,9 +85,9 @@ class SlackWebhook extends \Core\Base
                 $payload['text'] .= $this->helper->url->href('task', 'show', array('task_id' => $task_id, 'project_id' => $project_id));
                 $payload['text'] .= '|'.t('view the task on Kanboard').'>';
             }
-            
+
             $channel = $this->getChannel($project_id);
-            if (!empty($channel)) {
+            if (! empty($channel)) {
             	$payload['channel'] = $channel;
             }
 
diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php
index 0c932104..37ef637b 100644
--- a/app/Schema/Mysql.php
+++ b/app/Schema/Mysql.php
@@ -6,7 +6,13 @@ use PDO;
 use Core\Security;
 use Model\Link;
 
-const VERSION = 77;
+const VERSION = 78;
+
+function version_78($pdo)
+{
+    $pdo->exec("ALTER TABLE project_integrations ADD COLUMN slack_webhook_channel VARCHAR(255) DEFAULT ''");
+    $pdo->exec("INSERT INTO settings VALUES ('integration_slack_webhook_channel', '')");
+}
 
 function version_77($pdo)
 {
diff --git a/app/Schema/Postgres.php b/app/Schema/Postgres.php
index a3309068..62f22baa 100644
--- a/app/Schema/Postgres.php
+++ b/app/Schema/Postgres.php
@@ -6,7 +6,13 @@ use PDO;
 use Core\Security;
 use Model\Link;
 
-const VERSION = 57;
+const VERSION = 58;
+
+function version_58($pdo)
+{
+    $pdo->exec("ALTER TABLE project_integrations ADD COLUMN slack_webhook_channel VARCHAR(255) DEFAULT ''");
+    $pdo->exec("INSERT INTO settings VALUES ('integration_slack_webhook_channel', '')");
+}
 
 function version_57($pdo)
 {
diff --git a/app/Schema/Sqlite.php b/app/Schema/Sqlite.php
index c3bbbac9..10899b54 100644
--- a/app/Schema/Sqlite.php
+++ b/app/Schema/Sqlite.php
@@ -6,7 +6,13 @@ use Core\Security;
 use PDO;
 use Model\Link;
 
-const VERSION = 73;
+const VERSION = 74;
+
+function version_74($pdo)
+{
+    $pdo->exec("ALTER TABLE project_integrations ADD COLUMN slack_webhook_channel TEXT DEFAULT ''");
+    $pdo->exec("INSERT INTO settings VALUES ('integration_slack_webhook_channel', '')");
+}
 
 function version_73($pdo)
 {