aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorNyeriah <sarah.trysan@live.com>2014-11-22 00:30:24 -0200
committerNyeriah <sarah.trysan@live.com>2014-12-10 18:43:14 -0200
commitc79af3f16f84d0d26bd69b5d06dd8754643ddc7f (patch)
treefdada41736758a2366d28d6548c4cbe667039ba3 /sql/updates/auth
parentef6772b896363da024108864786326b0197f8b8f (diff)
Core/RBAC: Allow setting different default security level roles to different realms
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/2014_12_10_00_auth.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/auth/2014_12_10_00_auth.sql b/sql/updates/auth/2014_12_10_00_auth.sql
new file mode 100644
index 00000000000..8068fd3c459
--- /dev/null
+++ b/sql/updates/auth/2014_12_10_00_auth.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `rbac_default_permissions`
+ADD COLUMN `realmId` INT(11) NOT NULL DEFAULT '-1' COMMENT 'Realm Id, -1 means all',
+DROP PRIMARY KEY, ADD PRIMARY KEY (`secId`, `permissionId`, `realmId`);