· 7 years ago · Jan 07, 2019, 09:38 PM
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, 2, 'Biene', 'VIP', 'Alle'),
16(769, 8, 1, 'Dimplex', 'Dev-Fightbase', 'Fightbase'),
17(769, 5, 2, 'Dimplex', 'Event-GM', 'Genesis'),
18(769, 8, 3, 'Dimplex', 'Event-GM', 'Test-Server'),
19(1380, 6, 2, 'Hasilein', 'Transfer-Leitung', 'Genesis'),
20(1380, 8, 3, 'Hasilein', 'Transfer-Leitung', 'Test-Server'),
21(1382, 8, -1, 'Wasitank', 'Team-Leitung', 'Alle'),
22(2531, 6, 2, 'Suse', 'Mod-Leitung', 'Genesis'),
23(2531, 8, 3, 'Suse', 'Mod-Leitung', 'Test-Server'),
24(2690, 8, -1, 'Dekora', 'Dev-Leitung', 'Alle'),
25(5483, 8, -1, 'Skyangle', 'Team-Leitung', 'Alle'),
26(7499, 3, 2, 'Lyrox', 'GM', 'Genesis'),
27(7499, 8, 3, 'Lyrox', 'GM', 'Test-Server'),
28(7676, 6, 2, 'Indrik', 'Event-Leitung', 'Genesis'),
29(7676, 8, 3, 'Indrik', 'Event-Leitung', 'Test-Server'),
30(7936, 4, 2, 'Kiikii', 'Transfer-GM', 'Genesis'),
31(7936, 8, 3, 'Kiikii', 'Transfer-GM', 'Test-Server'),
32(7970, 5, 2, 'Zeed', 'Event-GM', 'Genesis'),
33(7970, 8, 3, 'Zeed', 'Event-GM', 'Test-Server'),
34(7975, 5, 2, 'Opti', 'Event-GM', 'Genesis'),
35(7975, 8, 3, 'Opti', 'Event-GM', 'Test-Server'),
36(7987, 6, 2, 'Nighty', 'GM-Leitung', 'Genesis'),
37(7987, 8, 3, 'Nighty', 'GM-Leitung', 'Test-Server'),
38(8173, 3, 2, 'Ariano', 'GM', 'Genesis'),
39(8173, 8, 3, 'Ariano', 'Dev', 'Test-Server'),
40(9590, 3, 2, 'Relict', 'GM', 'Genesis'),
41(9590, 8, 3, 'Relict', 'GM', 'Test-Server'),
42(10156, 2, 2, 'Ckey', 'Test-GM', 'Genesis'),
43(10156, 3, 8, 'Ckey', 'Test-GM', 'Test-Server'),
44(10255, 8, 3, 'Totti', 'Test-Dev', 'Test-Server'),
45(10345, 3, 2, 'Skydragon', 'GM', 'Genesis'),
46(10345, 8, 3, 'Skydragon', 'GM', 'Test-Server'),
47(10347, 3, 2, 'Sorijana', 'Test-GM', 'Genesis'),
48(10347, 8, 3, 'Sorijana', 'Test-GM', 'Test-Server'),
49(10381, 3, 2, 'Elvira', 'Dev', 'Genesis'),
50(10381, 8, 3, 'Elvira', 'Dev', 'Test-Server');