· 7 years ago · Feb 19, 2019, 03:20 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', 'Genesis'),
16(681, 8, 3, 'Biene', 'VIP', 'Test-Server'),
17(769, 8, 1, 'Dimplex', 'Dev-Fightbase', 'Fightbase'),
18(769, 5, 2, 'Dimplex', 'Event-GM', 'Genesis'),
19(769, 8, 3, 'Dimplex', 'Event-GM', 'Test-Server'),
20(1380, 6, 2, 'Hasilein', 'Transfer-Leitung', 'Genesis'),
21(1380, 8, 3, 'Hasilein', 'Transfer-Leitung', 'Test-Server'),
22(1382, 8, -1, 'Wasitank', 'Team-Leitung', 'Alle'),
23(2531, 6, 2, 'Suse', 'Mod-Leitung', 'Genesis'),
24(2531, 8, 3, 'Suse', 'Mod-Leitung', 'Test-Server'),
25(2690, 8, -1, 'Dekora', 'Dev-Leitung', 'Alle'),
26(5483, 8, -1, 'Skyangle', 'Team-Leitung', 'Alle'),
27(7499, 3, 2, 'Lyrox', 'GM', 'Genesis'),
28(7499, 8, 3, 'Lyrox', 'GM', 'Test-Server'),
29(7676, 6, 2, 'Indrik', 'Event-Leitung', 'Genesis'),
30(7676, 8, 3, 'Indrik', 'Event-Leitung', 'Test-Server'),
31(7936, 4, 2, 'Kiikii', 'Transfer-GM', 'Genesis'),
32(7936, 8, 3, 'Kiikii', 'Transfer-GM', 'Test-Server'),
33(7970, 5, 2, 'Zeed', 'Event-GM', 'Genesis'),
34(7970, 8, 3, 'Zeed', 'Event-GM', 'Test-Server'),
35(7987, 6, 2, 'Nighty', 'GM-Leitung', 'Genesis'),
36(7987, 8, 3, 'Nighty', 'GM-Leitung', 'Test-Server'),
37(8173, 3, 2, 'Ariano', 'GM', 'Genesis'),
38(8173, 8, 3, 'Ariano', 'Dev', 'Test-Server'),
39(9590, 3, 2, 'Relict', 'GM', 'Genesis'),
40(9590, 8, 3, 'Relict', 'GM', 'Test-Server'),
41(10156, 2, 2, 'Ckey', 'Test-GM', 'Genesis'),
42(10156, 3, 8, 'Ckey', 'Test-GM', 'Test-Server'),
43(10255, 2, 2, 'Totti', 'Test-Dev', 'Genesis'),
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, 2, 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'),
51(10383, 3, 2, 'Etomidate', 'GM', 'Genesis'),
52(10383, 8, 3, 'Etomidate', 'GM', 'Test-Server'),
53(10401, 3, 2, 'Twisted', 'GM', 'Genesis'),
54(10401, 8, 3, 'Twisted', 'GM', 'Test-Server'),
55(10411, 3, 2, 'Xslayer', 'GM', 'Genesis'),
56(10411, 8, 3, 'Xslayer', 'GM', 'Test-Server'),
57(10546, 3, 2, 'Skorpi', 'GM', 'Genesis'),
58(10546, 8, 3, 'Skorpi', 'GM', 'Test-Server'),
59(10655, 2, 2, 'Migi', 'Test-GM', 'Genesis'),
60(10655, 8, 3, 'Migi', 'Test-GM', 'Test-Server'),
61(10656, 2, 2, 'Channa', 'Test-GM', 'Genesis'),
62(10656, 8, 3, 'Channa', 'Test-GM', 'Test-Server'),
63(10670, 2, 2, 'Nokoribi', 'Test-Dev', 'Genesis'),
64(10670, 8, 3, 'Nokoribi', 'Test-Dev', 'Test-Server');