summaryrefslogtreecommitdiff
path: root/app
diff options
context:
space:
mode:
Diffstat (limited to 'app')
-rw-r--r--app/Schema/Mysql.php3
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
");
}