Fix issues in Mysql schema

2 files changed, 3 insertions, 3 deletions

diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php
index 458fa81a..7051bfb4 100644
--- a/app/Schema/Mysql.php
+++ b/app/Schema/Mysql.php
@@ -66,7 +66,7 @@ function version_92($pdo)
             project_id INT NOT NULL,
             notification_type VARCHAR(50) NOT NULL,
             PRIMARY KEY(id),
-            FOREIGN KEY(project_id) REFERENCES projects(id) ON DELETE CASCADE
+            FOREIGN KEY(project_id) REFERENCES projects(id) ON DELETE CASCADE,
             UNIQUE(project_id, notification_type)
         ) ENGINE=InnoDB CHARSET=utf8
     ");
@@ -74,7 +74,7 @@ function version_92($pdo)
 
 function version_91($pdo)
 {
-    $pdo->exec("ALTER TABLE custom_filters ADD COLUMN append TINYINT(1) DEFAULT 0");
+    $pdo->exec("ALTER TABLE custom_filters ADD COLUMN `append` TINYINT(1) DEFAULT 0");
 }
 
 function version_90($pdo)
diff --git a/app/Schema/Postgres.php b/app/Schema/Postgres.php
index 165b11d2..9e12a5e8 100644
--- a/app/Schema/Postgres.php
+++ b/app/Schema/Postgres.php
@@ -73,7 +73,7 @@ function version_72($pdo)
 
 function version_71($pdo)
 {
-    $pdo->exec("ALTER TABLE custom_filters ADD COLUMN append BOOLEAN DEFAULT '0'");
+    $pdo->exec("ALTER TABLE custom_filters ADD COLUMN \"append\" BOOLEAN DEFAULT '0'");
 }
 
 function version_70($pdo)