diff options
| author | Frederic Guillot <fred@kanboard.net> | 2016-09-11 19:22:41 -0400 |
|---|---|---|
| committer | Frederic Guillot <fred@kanboard.net> | 2016-09-11 19:22:41 -0400 |
| commit | b520868941daf69b8a1d76df809c85243dcfb64a (patch) | |
| tree | 5bde79038813a724eafa162b2de8eb2767e4c3eb /app/Schema | |
| parent | c84df535b6bdc7260144872fc4e0c241a5a5ad61 (diff) | |
Add missing primary key in Mysql schema
Diffstat (limited to 'app/Schema')
| -rw-r--r-- | app/Schema/Mysql.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php index 0da54597..398b963e 100644 --- a/app/Schema/Mysql.php +++ b/app/Schema/Mysql.php @@ -18,7 +18,8 @@ function version_114(PDO $pdo) rule VARCHAR(255) NOT NULL, UNIQUE(role_id, rule), FOREIGN KEY(project_id) REFERENCES projects(id) ON DELETE CASCADE, - FOREIGN KEY(role_id) REFERENCES project_has_roles(role_id) ON DELETE CASCADE + FOREIGN KEY(role_id) REFERENCES project_has_roles(role_id) ON DELETE CASCADE, + PRIMARY KEY(restriction_id) ) ENGINE=InnoDB CHARSET=utf8 "); } |