1. SET FOREIGN_KEY_CHECKS=0;
  3. -- ----------------------------
  4. -- Table structure for `rbac_account_groups`
  5. -- ----------------------------
  6. DROP TABLE IF EXISTS `rbac_account_groups`;
  7. CREATE TABLE `rbac_account_groups` (
  8. `accountId` int(10) unsigned NOT NULL COMMENT 'Account id',
  9. `groupId` int(10) unsigned NOT NULL COMMENT 'Group id',
  10. `realmId` int(11) NOT NULL DEFAULT '-1' COMMENT 'Realm Id, -1 means all',
  11. PRIMARY KEY (`accountId`,`groupId`,`realmId`),
  12. KEY `fk__rbac_account_groups__rbac_groups` (`groupId`),
  13. CONSTRAINT `fk__rbac_account_groups__account` FOREIGN KEY (`accountId`) REFERENCES `account` (`id`) ON DELETE CASCADE,
  14. CONSTRAINT `fk__rbac_account_groups__rbac_groups` FOREIGN KEY (`groupId`) REFERENCES `rbac_groups` (`id`) ON DELETE CASCADE
  15. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Account-Group relation';
  18. -- ----------------------------
  19. -- Table structure for `rbac_account_permissions`
  20. -- ----------------------------
  21. DROP TABLE IF EXISTS `rbac_account_permissions`;
  22. CREATE TABLE `rbac_account_permissions` (
  23. `accountId` int(10) unsigned NOT NULL COMMENT 'Account id',
  24. `permissionId` int(10) unsigned NOT NULL COMMENT 'Permission id',
  25. `granted` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Granted = 1, Denied = 0',
  26. `realmId` int(11) NOT NULL DEFAULT '-1' COMMENT 'Realm Id, -1 means all',
  27. PRIMARY KEY (`accountId`,`permissionId`,`realmId`),
  28. KEY `fk__rbac_account_roles__rbac_permissions` (`permissionId`),
  29. CONSTRAINT `fk__rbac_account_permissions__account` FOREIGN KEY (`accountId`) REFERENCES `account` (`id`) ON DELETE CASCADE,
  30. CONSTRAINT `fk__rbac_account_roles__rbac_permissions` FOREIGN KEY (`permissionId`) REFERENCES `rbac_permissions` (`id`) ON DELETE CASCADE
  31. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Account-Permission relation';
  34. -- ----------------------------
  35. -- Table structure for `rbac_account_roles`
  36. -- ----------------------------
  37. DROP TABLE IF EXISTS `rbac_account_roles`;
  38. CREATE TABLE `rbac_account_roles` (
  39. `accountId` int(10) unsigned NOT NULL COMMENT 'Account id',
  40. `roleId` int(10) unsigned NOT NULL COMMENT 'Role id',
  41. `granted` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Granted = 1, Denied = 0',
  42. `realmId` int(11) NOT NULL DEFAULT '-1' COMMENT 'Realm Id, -1 means all',
  43. PRIMARY KEY (`accountId`,`roleId`,`realmId`),
  44. KEY `fk__rbac_account_roles__rbac_roles` (`roleId`),
  45. CONSTRAINT `fk__rbac_account_roles__account` FOREIGN KEY (`accountId`) REFERENCES `account` (`id`) ON DELETE CASCADE,
  46. CONSTRAINT `fk__rbac_account_roles__rbac_roles` FOREIGN KEY (`roleId`) REFERENCES `rbac_roles` (`id`) ON DELETE CASCADE
  47. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Account-Role relation';
  49. -- ----------------------------
  50. -- Table structure for `rbac_group_roles`
  51. -- ----------------------------
  52. DROP TABLE IF EXISTS `rbac_group_roles`;
  53. CREATE TABLE `rbac_group_roles` (
  54. `groupId` int(10) unsigned NOT NULL COMMENT 'group id',
  55. `roleId` int(10) unsigned NOT NULL COMMENT 'Role id',
  56. PRIMARY KEY (`groupId`,`roleId`),
  57. KEY `fk__rbac_group_roles__rbac_roles` (`roleId`),
  58. CONSTRAINT `fk__rbac_group_roles__rbac_groups` FOREIGN KEY (`groupId`) REFERENCES `rbac_groups` (`id`) ON DELETE CASCADE,
  59. CONSTRAINT `fk__rbac_group_roles__rbac_roles` FOREIGN KEY (`roleId`) REFERENCES `rbac_roles` (`id`) ON DELETE CASCADE
  60. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Group Role relation';
  62. -- ----------------------------
  63. -- Records of rbac_group_roles
  64. -- ----------------------------
  65. INSERT INTO `rbac_group_roles` VALUES ('1', '1');
  66. INSERT INTO `rbac_group_roles` VALUES ('2', '2');
  67. INSERT INTO `rbac_group_roles` VALUES ('3', '3');
  68. INSERT INTO `rbac_group_roles` VALUES ('4', '4');
  69. INSERT INTO `rbac_group_roles` VALUES ('2', '5');
  70. INSERT INTO `rbac_group_roles` VALUES ('1', '6');
  71. INSERT INTO `rbac_group_roles` VALUES ('1', '7');
  72. INSERT INTO `rbac_group_roles` VALUES ('2', '8');
  73. INSERT INTO `rbac_group_roles` VALUES ('3', '8');
  74. INSERT INTO `rbac_group_roles` VALUES ('4', '8');
  75. INSERT INTO `rbac_group_roles` VALUES ('2', '9');
  76. INSERT INTO `rbac_group_roles` VALUES ('3', '9');
  77. INSERT INTO `rbac_group_roles` VALUES ('4', '9');
  78. INSERT INTO `rbac_group_roles` VALUES ('2', '10');
  79. INSERT INTO `rbac_group_roles` VALUES ('3', '10');
  80. INSERT INTO `rbac_group_roles` VALUES ('4', '10');
  81. INSERT INTO `rbac_group_roles` VALUES ('2', '11');
  82. INSERT INTO `rbac_group_roles` VALUES ('3', '11');
  83. INSERT INTO `rbac_group_roles` VALUES ('4', '11');
  84. INSERT INTO `rbac_group_roles` VALUES ('2', '12');
  85. INSERT INTO `rbac_group_roles` VALUES ('3', '12');
  86. INSERT INTO `rbac_group_roles` VALUES ('4', '12');
  87. INSERT INTO `rbac_group_roles` VALUES ('2', '13');
  88. INSERT INTO `rbac_group_roles` VALUES ('3', '13');
  89. INSERT INTO `rbac_group_roles` VALUES ('4', '13');
  90. INSERT INTO `rbac_group_roles` VALUES ('2', '14');
  91. INSERT INTO `rbac_group_roles` VALUES ('3', '14');
  92. INSERT INTO `rbac_group_roles` VALUES ('4', '14');
  93. INSERT INTO `rbac_group_roles` VALUES ('2', '15');
  94. INSERT INTO `rbac_group_roles` VALUES ('3', '15');
  95. INSERT INTO `rbac_group_roles` VALUES ('4', '15');
  96. INSERT INTO `rbac_group_roles` VALUES ('2', '16');
  97. INSERT INTO `rbac_group_roles` VALUES ('3', '16');
  98. INSERT INTO `rbac_group_roles` VALUES ('4', '16');
  99. INSERT INTO `rbac_group_roles` VALUES ('2', '17');
  100. INSERT INTO `rbac_group_roles` VALUES ('3', '17');
  101. INSERT INTO `rbac_group_roles` VALUES ('4', '17');
  102. INSERT INTO `rbac_group_roles` VALUES ('4', '18');
  103. INSERT INTO `rbac_group_roles` VALUES ('1', '19');
  104. INSERT INTO `rbac_group_roles` VALUES ('2', '19');
  105. INSERT INTO `rbac_group_roles` VALUES ('3', '19');
  106. INSERT INTO `rbac_group_roles` VALUES ('4', '19');
  107. INSERT INTO `rbac_group_roles` VALUES ('2', '20');
  108. INSERT INTO `rbac_group_roles` VALUES ('3', '20');
  109. INSERT INTO `rbac_group_roles` VALUES ('4', '20');
  110. INSERT INTO `rbac_group_roles` VALUES ('2', '21');
  111. INSERT INTO `rbac_group_roles` VALUES ('3', '21');
  112. INSERT INTO `rbac_group_roles` VALUES ('4', '21');
  113. INSERT INTO `rbac_group_roles` VALUES ('2', '22');
  114. INSERT INTO `rbac_group_roles` VALUES ('3', '22');
  115. INSERT INTO `rbac_group_roles` VALUES ('4', '22');
  116. INSERT INTO `rbac_group_roles` VALUES ('4', '23');
  117. INSERT INTO `rbac_group_roles` VALUES ('2', '24');
  118. INSERT INTO `rbac_group_roles` VALUES ('3', '24');
  119. INSERT INTO `rbac_group_roles` VALUES ('4', '24');
  120. INSERT INTO `rbac_group_roles` VALUES ('2', '25');
  121. INSERT INTO `rbac_group_roles` VALUES ('3', '25');
  122. INSERT INTO `rbac_group_roles` VALUES ('4', '25');
  123. INSERT INTO `rbac_group_roles` VALUES ('2', '26');
  124. INSERT INTO `rbac_group_roles` VALUES ('3', '26');
  125. INSERT INTO `rbac_group_roles` VALUES ('4', '26');
  126. INSERT INTO `rbac_group_roles` VALUES ('2', '27');
  127. INSERT INTO `rbac_group_roles` VALUES ('3', '27');
  128. INSERT INTO `rbac_group_roles` VALUES ('4', '27');
  129. INSERT INTO `rbac_group_roles` VALUES ('1', '28');
  130. INSERT INTO `rbac_group_roles` VALUES ('2', '28');
  131. INSERT INTO `rbac_group_roles` VALUES ('3', '28');
  132. INSERT INTO `rbac_group_roles` VALUES ('4', '28');
  133. INSERT INTO `rbac_group_roles` VALUES ('2', '29');
  134. INSERT INTO `rbac_group_roles` VALUES ('3', '29');
  135. INSERT INTO `rbac_group_roles` VALUES ('4', '29');
  136. INSERT INTO `rbac_group_roles` VALUES ('1', '30');
  137. INSERT INTO `rbac_group_roles` VALUES ('2', '30');
  138. INSERT INTO `rbac_group_roles` VALUES ('3', '30');
  139. INSERT INTO `rbac_group_roles` VALUES ('4', '30');
  140. INSERT INTO `rbac_group_roles` VALUES ('2', '31');
  141. INSERT INTO `rbac_group_roles` VALUES ('3', '31');
  142. INSERT INTO `rbac_group_roles` VALUES ('4', '31');
  143. INSERT INTO `rbac_group_roles` VALUES ('2', '32');
  144. INSERT INTO `rbac_group_roles` VALUES ('3', '32');
  145. INSERT INTO `rbac_group_roles` VALUES ('4', '32');
  146. INSERT INTO `rbac_group_roles` VALUES ('2', '33');
  147. INSERT INTO `rbac_group_roles` VALUES ('3', '33');
  148. INSERT INTO `rbac_group_roles` VALUES ('4', '33');
  149. INSERT INTO `rbac_group_roles` VALUES ('2', '34');
  150. INSERT INTO `rbac_group_roles` VALUES ('3', '34');
  151. INSERT INTO `rbac_group_roles` VALUES ('4', '34');
  152. INSERT INTO `rbac_group_roles` VALUES ('2', '35');
  153. INSERT INTO `rbac_group_roles` VALUES ('3', '35');
  154. INSERT INTO `rbac_group_roles` VALUES ('4', '35');
  155. INSERT INTO `rbac_group_roles` VALUES ('2', '36');
  156. INSERT INTO `rbac_group_roles` VALUES ('3', '36');
  157. INSERT INTO `rbac_group_roles` VALUES ('4', '36');
  158. INSERT INTO `rbac_group_roles` VALUES ('2', '37');
  159. INSERT INTO `rbac_group_roles` VALUES ('3', '37');
  160. INSERT INTO `rbac_group_roles` VALUES ('4', '37');
  161. INSERT INTO `rbac_group_roles` VALUES ('2', '38');
  162. INSERT INTO `rbac_group_roles` VALUES ('3', '38');
  163. INSERT INTO `rbac_group_roles` VALUES ('4', '38');
  165. -- ----------------------------
  166. -- Table structure for `rbac_groups`
  167. -- ----------------------------
  168. DROP TABLE IF EXISTS `rbac_groups`;
  169. CREATE TABLE `rbac_groups` (
  170. `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Group id',
  171. `name` varchar(100) NOT NULL COMMENT 'Group name',
  172. PRIMARY KEY (`id`)
  173. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Group List';
  175. -- ----------------------------
  176. -- Records of rbac_groups
  177. -- ----------------------------
  178. INSERT INTO `rbac_groups` VALUES ('1', 'Player');
  179. INSERT INTO `rbac_groups` VALUES ('2', 'Moderator');
  180. INSERT INTO `rbac_groups` VALUES ('3', 'GameMaster');
  181. INSERT INTO `rbac_groups` VALUES ('4', 'Administrator');
  183. -- ----------------------------
  184. -- Table structure for `rbac_permissions`
  185. -- ----------------------------
  186. DROP TABLE IF EXISTS `rbac_permissions`;
  187. CREATE TABLE `rbac_permissions` (
  188. `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Permission id',
  189. `name` varchar(100) NOT NULL COMMENT 'Permission name',
  190. PRIMARY KEY (`id`)
  191. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Permission List';
  193. -- ----------------------------
  194. -- Records of rbac_permissions
  195. -- ----------------------------
  196. INSERT INTO `rbac_permissions` VALUES ('1', 'Instant logout');
  197. INSERT INTO `rbac_permissions` VALUES ('2', 'Skip Queue');
  198. INSERT INTO `rbac_permissions` VALUES ('3', 'Join Normal Battleground');
  199. INSERT INTO `rbac_permissions` VALUES ('4', 'Join Random Battleground');
  200. INSERT INTO `rbac_permissions` VALUES ('5', 'Join Arenas');
  201. INSERT INTO `rbac_permissions` VALUES ('6', 'Join Dungeon Finder');
  202. INSERT INTO `rbac_permissions` VALUES ('7', 'Player Commands (Temporal till commands moved to rbac)');
  203. INSERT INTO `rbac_permissions` VALUES ('8', 'Moderator Commands (Temporal till commands moved to rbac)');
  204. INSERT INTO `rbac_permissions` VALUES ('9', 'GameMaster Commands (Temporal till commands moved to rbac)');
  205. INSERT INTO `rbac_permissions` VALUES ('10', 'Administrator Commands (Temporal till commands moved to rbac)');
  206. INSERT INTO `rbac_permissions` VALUES ('11', 'Log GM trades');
  207. INSERT INTO `rbac_permissions` VALUES ('13', 'Skip Instance required bosses check');
  208. INSERT INTO `rbac_permissions` VALUES ('14', 'Skip character creation team mask check');
  209. INSERT INTO `rbac_permissions` VALUES ('15', 'Skip character creation class mask check');
  210. INSERT INTO `rbac_permissions` VALUES ('16', 'Skip character creation race mask check');
  211. INSERT INTO `rbac_permissions` VALUES ('17', 'Skip character creation reserved name check');
  212. INSERT INTO `rbac_permissions` VALUES ('18', 'Skip character creation heroic min level check');
  213. INSERT INTO `rbac_permissions` VALUES ('19', 'Skip needed requirements to use channel check');
  214. INSERT INTO `rbac_permissions` VALUES ('20', 'Skip disable map check');
  215. INSERT INTO `rbac_permissions` VALUES ('21', 'Skip reset talents when used more than allowed check');
  216. INSERT INTO `rbac_permissions` VALUES ('22', 'Skip spam chat check');
  217. INSERT INTO `rbac_permissions` VALUES ('23', 'Skip over-speed ping check');
  218. INSERT INTO `rbac_permissions` VALUES ('24', 'Two side faction characters on the same account');
  219. INSERT INTO `rbac_permissions` VALUES ('25', 'Allow say chat between factions');
  220. INSERT INTO `rbac_permissions` VALUES ('26', 'Allow channel chat between factions');
  221. INSERT INTO `rbac_permissions` VALUES ('27', 'Two side mail interaction');
  222. INSERT INTO `rbac_permissions` VALUES ('28', 'See two side who list');
  223. INSERT INTO `rbac_permissions` VALUES ('29', 'Add friends of other faction');
  224. INSERT INTO `rbac_permissions` VALUES ('30', 'Save character without delay with .save command');
  225. INSERT INTO `rbac_permissions` VALUES ('31', 'Use params with .unstuck command');
  226. INSERT INTO `rbac_permissions` VALUES ('32', 'Can be assigned tickets with .assign ticket command');
  227. INSERT INTO `rbac_permissions` VALUES ('33', 'Notify if a command was not found');
  228. INSERT INTO `rbac_permissions` VALUES ('34', 'Check if should appear in list using .gm ingame command');
  229. INSERT INTO `rbac_permissions` VALUES ('35', 'See all security levels with who command');
  230. INSERT INTO `rbac_permissions` VALUES ('36', 'Filter whispers');
  231. INSERT INTO `rbac_permissions` VALUES ('37', 'Use staff badge in chat');
  232. INSERT INTO `rbac_permissions` VALUES ('38', 'Resurrect with full Health Points');
  233. INSERT INTO `rbac_permissions` VALUES ('39', 'Restore saved gm setting states');
  234. INSERT INTO `rbac_permissions` VALUES ('40', 'Allows to add a gm to friend list');
  235. INSERT INTO `rbac_permissions` VALUES ('41', 'Use Config option START_GM_LEVEL to assign new character level');
  236. INSERT INTO `rbac_permissions` VALUES ('42', 'Allows to use CMSG_WORLD_TELEPORT opcode');
  237. INSERT INTO `rbac_permissions` VALUES ('43', 'Allows to use CMSG_WHOIS opcode');
  238. INSERT INTO `rbac_permissions` VALUES ('44', 'Receive global GM messages/texts');
  239. INSERT INTO `rbac_permissions` VALUES ('45', 'Join channels without announce');
  240. INSERT INTO `rbac_permissions` VALUES ('46', 'Change channel settings without being channel moderator');
  241. INSERT INTO `rbac_permissions` VALUES ('47', 'Enables lower security than target check');
  243. -- ----------------------------
  244. -- Table structure for `rbac_role_permissions`
  245. -- ----------------------------
  246. DROP TABLE IF EXISTS `rbac_role_permissions`;
  247. CREATE TABLE `rbac_role_permissions` (
  248. `roleId` int(10) unsigned NOT NULL COMMENT 'Role id',
  249. `permissionId` int(10) unsigned NOT NULL COMMENT 'Permission id',
  250. PRIMARY KEY (`roleId`,`permissionId`),
  251. KEY `fk__role_permissions__rbac_permissions` (`permissionId`),
  252. CONSTRAINT `fk__role_permissions__rbac_permissions` FOREIGN KEY (`permissionId`) REFERENCES `rbac_permissions` (`id`) ON DELETE CASCADE,
  253. CONSTRAINT `fk__role_permissions__rbac_roles` FOREIGN KEY (`roleId`) REFERENCES `rbac_roles` (`id`) ON DELETE CASCADE
  254. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Role Permission relation';
  256. -- ----------------------------
  257. -- Records of rbac_role_permissions
  258. -- ----------------------------
  259. INSERT INTO `rbac_role_permissions` VALUES ('5', '1');
  260. INSERT INTO `rbac_role_permissions` VALUES ('5', '2');
  261. INSERT INTO `rbac_role_permissions` VALUES ('6', '3');
  262. INSERT INTO `rbac_role_permissions` VALUES ('6', '4');
  263. INSERT INTO `rbac_role_permissions` VALUES ('6', '5');
  264. INSERT INTO `rbac_role_permissions` VALUES ('7', '6');
  265. INSERT INTO `rbac_role_permissions` VALUES ('1', '7');
  266. INSERT INTO `rbac_role_permissions` VALUES ('2', '8');
  267. INSERT INTO `rbac_role_permissions` VALUES ('3', '9');
  268. INSERT INTO `rbac_role_permissions` VALUES ('4', '10');
  269. INSERT INTO `rbac_role_permissions` VALUES ('8', '11');
  270. INSERT INTO `rbac_role_permissions` VALUES ('9', '13');
  271. INSERT INTO `rbac_role_permissions` VALUES ('33', '14');
  272. INSERT INTO `rbac_role_permissions` VALUES ('33', '15');
  273. INSERT INTO `rbac_role_permissions` VALUES ('33', '16');
  274. INSERT INTO `rbac_role_permissions` VALUES ('33', '17');
  275. INSERT INTO `rbac_role_permissions` VALUES ('33', '18');
  276. INSERT INTO `rbac_role_permissions` VALUES ('27', '19');
  277. INSERT INTO `rbac_role_permissions` VALUES ('22', '20');
  278. INSERT INTO `rbac_role_permissions` VALUES ('23', '21');
  279. INSERT INTO `rbac_role_permissions` VALUES ('24', '22');
  280. INSERT INTO `rbac_role_permissions` VALUES ('17', '23');
  281. INSERT INTO `rbac_role_permissions` VALUES ('34', '24');
  282. INSERT INTO `rbac_role_permissions` VALUES ('28', '25');
  283. INSERT INTO `rbac_role_permissions` VALUES ('30', '26');
  284. INSERT INTO `rbac_role_permissions` VALUES ('19', '27');
  285. INSERT INTO `rbac_role_permissions` VALUES ('35', '28');
  286. INSERT INTO `rbac_role_permissions` VALUES ('36', '29');
  287. INSERT INTO `rbac_role_permissions` VALUES ('11', '30');
  288. INSERT INTO `rbac_role_permissions` VALUES ('12', '31');
  289. INSERT INTO `rbac_role_permissions` VALUES ('10', '32');
  290. INSERT INTO `rbac_role_permissions` VALUES ('20', '33');
  291. INSERT INTO `rbac_role_permissions` VALUES ('14', '34');
  292. INSERT INTO `rbac_role_permissions` VALUES ('37', '35');
  293. INSERT INTO `rbac_role_permissions` VALUES ('29', '36');
  294. INSERT INTO `rbac_role_permissions` VALUES ('15', '37');
  295. INSERT INTO `rbac_role_permissions` VALUES ('13', '38');
  296. INSERT INTO `rbac_role_permissions` VALUES ('25', '39');
  297. INSERT INTO `rbac_role_permissions` VALUES ('38', '40');
  298. INSERT INTO `rbac_role_permissions` VALUES ('26', '41');
  299. INSERT INTO `rbac_role_permissions` VALUES ('18', '42');
  300. INSERT INTO `rbac_role_permissions` VALUES ('18', '43');
  301. INSERT INTO `rbac_role_permissions` VALUES ('16', '44');
  302. INSERT INTO `rbac_role_permissions` VALUES ('31', '45');
  303. INSERT INTO `rbac_role_permissions` VALUES ('32', '46');
  304. INSERT INTO `rbac_role_permissions` VALUES ('21', '47');
  306. -- ----------------------------
  307. -- Table structure for `rbac_roles`
  308. -- ----------------------------
  309. DROP TABLE IF EXISTS `rbac_roles`;
  310. CREATE TABLE `rbac_roles` (
  311. `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Role id',
  312. `name` varchar(100) NOT NULL COMMENT 'Role name',
  313. PRIMARY KEY (`id`)
  314. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Roles List';
  316. -- ----------------------------
  317. -- Records of rbac_roles
  318. -- ----------------------------
  319. INSERT INTO `rbac_roles` VALUES ('1', 'Player Commands');
  320. INSERT INTO `rbac_roles` VALUES ('2', 'Moderator Commands');
  321. INSERT INTO `rbac_roles` VALUES ('3', 'GameMaster Commands');
  322. INSERT INTO `rbac_roles` VALUES ('4', 'Administrator Commands');
  323. INSERT INTO `rbac_roles` VALUES ('5', 'Quick Login/Logout');
  324. INSERT INTO `rbac_roles` VALUES ('6', 'Use Battleground/Arenas');
  325. INSERT INTO `rbac_roles` VALUES ('7', 'Use Dungeon Finder');
  326. INSERT INTO `rbac_roles` VALUES ('8', 'Log GM trades');
  327. INSERT INTO `rbac_roles` VALUES ('9', 'Skip Instance required bosses check');
  328. INSERT INTO `rbac_roles` VALUES ('10', 'Ticket management');
  329. INSERT INTO `rbac_roles` VALUES ('11', 'Instant .save');
  330. INSERT INTO `rbac_roles` VALUES ('12', 'Allow params with .unstuck');
  331. INSERT INTO `rbac_roles` VALUES ('13', 'Full HP after resurrect');
  332. INSERT INTO `rbac_roles` VALUES ('14', 'Appear in GM ingame list');
  333. INSERT INTO `rbac_roles` VALUES ('15', 'Use staff badge in chat');
  334. INSERT INTO `rbac_roles` VALUES ('16', 'Receive global GM messages/texts');
  335. INSERT INTO `rbac_roles` VALUES ('17', 'Skip over-speed ping check');
  336. INSERT INTO `rbac_roles` VALUES ('18', 'Allows Admin Opcodes');
  337. INSERT INTO `rbac_roles` VALUES ('19', 'Two side mail interaction');
  338. INSERT INTO `rbac_roles` VALUES ('20', 'Notify if a command was not found');
  339. INSERT INTO `rbac_roles` VALUES ('21', 'Enables lower security than target check');
  340. INSERT INTO `rbac_roles` VALUES ('22', 'Skip disable map check');
  341. INSERT INTO `rbac_roles` VALUES ('23', 'Skip reset talents when used more than allowed check');
  342. INSERT INTO `rbac_roles` VALUES ('24', 'Skip spam chat check');
  343. INSERT INTO `rbac_roles` VALUES ('25', 'Restore saved gm setting states');
  344. INSERT INTO `rbac_roles` VALUES ('26', 'Use Config option START_GM_LEVEL to assign new character level');
  345. INSERT INTO `rbac_roles` VALUES ('27', 'Skip needed requirements to use channel check');
  346. INSERT INTO `rbac_roles` VALUES ('28', 'Allow say chat between factions');
  347. INSERT INTO `rbac_roles` VALUES ('29', 'Filter whispers');
  348. INSERT INTO `rbac_roles` VALUES ('30', 'Allow channel chat between factions');
  349. INSERT INTO `rbac_roles` VALUES ('31', 'Join channels without announce');
  350. INSERT INTO `rbac_roles` VALUES ('32', 'Change channel settings without being channel moderator');
  351. INSERT INTO `rbac_roles` VALUES ('33', 'Skip character creation checks');
  352. INSERT INTO `rbac_roles` VALUES ('34', 'Two side faction characters on the same account');
  353. INSERT INTO `rbac_roles` VALUES ('35', 'See two side who list');
  354. INSERT INTO `rbac_roles` VALUES ('36', 'Add friends of other faction');
  355. INSERT INTO `rbac_roles` VALUES ('37', 'See all security levels with who command');
  356. INSERT INTO `rbac_roles` VALUES ('38', 'Allows to add a gm to friend list');
  358. -- ----------------------------
  359. -- Table structure for `rbac_security_level_groups`
  360. -- ----------------------------
  361. DROP TABLE IF EXISTS `rbac_security_level_groups`;
  362. CREATE TABLE `rbac_security_level_groups` (
  363. `secId` int(10) unsigned NOT NULL COMMENT 'Security Level id',
  364. `groupId` int(10) unsigned NOT NULL COMMENT 'group id',
  365. PRIMARY KEY (`secId`,`groupId`),
  366. KEY `fk__rbac_security_level_groups__rbac_groups` (`groupId`),
  367. CONSTRAINT `fk__rbac_security_level_groups__rbac_groups` FOREIGN KEY (`groupId`) REFERENCES `rbac_groups` (`id`)
  368. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Default groups to assign when an account is set gm level';
  370. -- ----------------------------
  371. -- Records of rbac_security_level_groups
  372. -- ----------------------------
  373. INSERT INTO `rbac_security_level_groups` VALUES ('0', '1');
  374. INSERT INTO `rbac_security_level_groups` VALUES ('1', '1');
  375. INSERT INTO `rbac_security_level_groups` VALUES ('2', '1');
  376. INSERT INTO `rbac_security_level_groups` VALUES ('3', '1');
  377. INSERT INTO `rbac_security_level_groups` VALUES ('1', '2');
  378. INSERT INTO `rbac_security_level_groups` VALUES ('2', '2');
  379. INSERT INTO `rbac_security_level_groups` VALUES ('3', '2');
  380. INSERT INTO `rbac_security_level_groups` VALUES ('2', '3');
  381. INSERT INTO `rbac_security_level_groups` VALUES ('3', '3');
  382. INSERT INTO `rbac_security_level_groups` VALUES ('3', '4');