aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorNyeriah <sarah.trysan@live.com>2014-12-10 22:50:28 -0200
committerNyeriah <sarah.trysan@live.com>2014-12-10 22:50:28 -0200
commit99c4c4cee5c2455d881cb8f3459ddf82bbd7e96d (patch)
treea29efc79e0f0291eb1fd4fa7a39dd26840f12436 /sql/updates/auth
parent88ca8b95e0e1a31bd561e741da96b582d16c984a (diff)
Core/RBAC: Allow setting different default security level roles to different realms
(cherry picked from commit c79af3f16f84d0d26bd69b5d06dd8754643ddc7f)
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`);