From 85af2317c56ed498e37426bcab8fa729f28f3afa Mon Sep 17 00:00:00 2001 From: Frederic Guillot Date: Sat, 17 Oct 2015 22:41:27 -0400 Subject: Fix issues in Mysql schema --- app/Schema/Mysql.php | 4 ++-- 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) -- cgit v1.2.3