diff options
| author | Frédéric Guillot <fred@kanboard.net> | 2017-01-15 15:46:50 -0500 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-01-15 15:46:50 -0500 |
| commit | 9f5bbd1cf6e5573fc1a6aee148adc35c7d2d9f86 (patch) | |
| tree | 2ff004b759e732a2e52a57b34f7deeeaf2cc9a90 | |
| parent | 513aefdb2c092b687c567c62e6e3d70b9bcea4f4 (diff) | |
| parent | 0ad1779435eaa3f35b05500947c2762e5b806d10 (diff) | |
Merge pull request #2947
Fix Kanboard installation errors on MySQL 8.0.0
| -rw-r--r-- | app/Schema/Mysql.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php index fac8688a..cc691d1f 100644 --- a/app/Schema/Mysql.php +++ b/app/Schema/Mysql.php @@ -63,9 +63,9 @@ function version_113(PDO $pdo) $pdo->exec(" CREATE TABLE project_has_roles ( role_id INT NOT NULL AUTO_INCREMENT, - role VARCHAR(255) NOT NULL, + `role` VARCHAR(255) NOT NULL, project_id INT NOT NULL, - UNIQUE(project_id, role), + UNIQUE(project_id, `role`), FOREIGN KEY(project_id) REFERENCES projects(id) ON DELETE CASCADE, PRIMARY KEY(role_id) ) ENGINE=InnoDB CHARSET=utf8 |