kzzTPDAz

1DROP TABLE IF EXISTS `account_access`;
2CREATE TABLE IF NOT EXISTS `account_access` (
3  `id` int(11) unsigned NOT NULL,
4  `gmlevel` tinyint(3) unsigned NOT NULL,
5  `RealmID` int(11) NOT NULL DEFAULT '-1',
6  `command` tinytext,
7  `gmrang` tinytext,
8  `server` tinytext,
9  PRIMARY KEY (`id`,`RealmID`)
10) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
11
12INSERT INTO `account_access` (`id`, `gmlevel`, `RealmID`, `command`, `gmrang`, `server`) VALUES
13(5, 8, -1, 'Kevin', 'Projekt-Leitung', 'Alle'),
14(285, 8, -1, 'Gismu', 'Projekt-Leitung', 'Alle'),
15(681, 2, -1, 'Biene', 'VIP', 'Alle'),
16(769, 7, 1, 'Dimplex', 'Dev', 'Fightbase'),
17(769, 3, 2, 'Dimplex', 'GM', 'Genesis'),
18(769, 7, 3, 'Dimplex', 'Dev', 'Test 1'),
19(769, 7, 4, 'Dimplex', 'Dev', 'Test 2'),
20(1380, 6, -1, 'Hasilein', 'Transfer-Leitung', 'Alle'),
21(1382, 8, -1, 'Wasitank', 'Team-Leitung', 'Alle'),
22(2531, 6, -1, 'Suse', 'Mod-Leitung', 'Alle'),
23(2690, 8, -1, 'Dekora', 'Dev-Leitung', 'Alle'),
24(5483, 8, -1, 'Skyangle', 'Team-Leitung', 'Alle'),
25(7499, 3, -1, 'Lyrox', 'GM', 'Alle'),
26(7676, 6, -1, 'Indrik', 'Event-Leitung', 'Alle'),
27(7936, 4, -1, 'Kiikii', 'Transfer-GM', 'Alle'),
28(7970, 5, 1, 'Hankey', 'Event-GM', 'Fightbase'),
29(7970, 3, 2, 'Hankey', 'GM', 'Genesis'),
30(7970, 5, 3, 'Hankey', 'Event-GM', 'Test 1'),
31(7970, 5, 4, 'Hankey', 'Event-GM', 'Test 2'),
32(7975, 5, 1, 'Opti', 'Event-GM', 'Fightbase'),
33(7975, 3, 2, 'Opti', 'GM', 'Genesis'),
34(7975, 5, 3, 'Opti', 'Event-GM', 'Test 1'),
35(7975, 5, 4, 'Opti', 'Event-GM', 'Test 2'),
36(7987, 6, -1, 'Nighty', 'GM-Leitung', 'Alle'),
37(8173, 7, 1, 'Ariano', 'Dev', 'Fightbase'),
38(8173, 3, 2, 'Ariano', 'GM', 'Genesis'),
39(8173, 7, 3, 'Ariano', 'Dev', 'Test 1'),
40(8173, 7, 4, 'Ariano', 'Dev', 'Test 2'),
41(8960, 3, -1, 'DKay', 'GM', 'Alle'),
42(8967, 0, 1, 'Winters', 'Dev', 'Fightbase'),
43(8967, 0, 2, 'Winters', 'GM', 'Genesis'),
44(8967, 0, 3, 'Winters', 'Dev', 'Test 1'),
45(8967, 0, 4, 'Winters', 'Dev', 'Test 2'),
46(8972, 3, -1, 'Sandrilas', 'GM', 'Alle'),
47(9590, 3, -1, 'Relict', 'GM', 'Alle'),
48(9982, 2, -1, 'Mythos', 'Test-GM', 'Alle');