diff options
| -rw-r--r-- | app/Schema/Mysql.php | 4 | ||||
| -rw-r--r-- | app/Schema/Postgres.php | 2 |
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) |