diff options
| author | Thomas <38024168+cavallit@users.noreply.github.com> | 2018-10-05 19:44:02 -0400 |
|---|---|---|
| committer | fguillot <fred@kanboard.net> | 2018-10-06 13:06:13 -0700 |
| commit | e650ed58148094627438fc74ef2c765ee5fbd41b (patch) | |
| tree | 9f0024a99bf2396d12c28e6db6ee1b00b6447d24 /app/Schema/Mysql.php | |
| parent | c06a1108304eb31d15523fcd3caf78509eefd841 (diff) | |
Escape table name 'groups' because groups is a reserved word as of MySql 8.0.2
Diffstat (limited to 'app/Schema/Mysql.php')
| -rw-r--r-- | app/Schema/Mysql.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php index 5b70f2a3..3ae37eab 100644 --- a/app/Schema/Mysql.php +++ b/app/Schema/Mysql.php @@ -507,7 +507,7 @@ function version_96(PDO $pdo) `group_id` INT NOT NULL, `project_id` INT NOT NULL, `role` VARCHAR(25) NOT NULL, - FOREIGN KEY(group_id) REFERENCES groups(id) ON DELETE CASCADE, + FOREIGN KEY(group_id) REFERENCES `groups`(id) ON DELETE CASCADE, FOREIGN KEY(project_id) REFERENCES projects(id) ON DELETE CASCADE, UNIQUE(group_id, project_id) ) ENGINE=InnoDB CHARSET=utf8 @@ -535,7 +535,7 @@ function version_96(PDO $pdo) function version_95(PDO $pdo) { $pdo->exec(" - CREATE TABLE groups ( + CREATE TABLE `groups` ( id INT NOT NULL AUTO_INCREMENT, external_id VARCHAR(255) DEFAULT '', name VARCHAR(100) NOT NULL UNIQUE, @@ -547,7 +547,7 @@ function version_95(PDO $pdo) CREATE TABLE group_has_users ( group_id INT NOT NULL, user_id INT NOT NULL, - FOREIGN KEY(group_id) REFERENCES groups(id) ON DELETE CASCADE, + FOREIGN KEY(group_id) REFERENCES `groups`(id) ON DELETE CASCADE, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE, UNIQUE(group_id, user_id) ) ENGINE=InnoDB CHARSET=utf8 |