From b520868941daf69b8a1d76df809c85243dcfb64a Mon Sep 17 00:00:00 2001 From: Frederic Guillot Date: Sun, 11 Sep 2016 19:22:41 -0400 Subject: Add missing primary key in Mysql schema --- app/Schema/Mysql.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'app/Schema') 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 "); } -- cgit v1.2.3