DROP TABLE IF EXISTS `account_access`;
CREATE TABLE IF NOT EXISTS `account_access` (
  `id` int(11) unsigned NOT NULL,
  `gmlevel` tinyint(3) unsigned NOT NULL,
  `RealmID` int(11) NOT NULL DEFAULT '-1',
  `command` tinytext,
  `gmrang` tinytext,
  `server` tinytext,
  PRIMARY KEY (`id`,`RealmID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

INSERT INTO `account_access` (`id`, `gmlevel`, `RealmID`, `command`, `gmrang`, `server`) VALUES
(5, 8, -1, 'Kevin', 'Projekt-Leitung', 'Alle'),
(285, 8, -1, 'Gismu', 'Projekt-Leitung', 'Alle'),
(681, 2, 2, 'Biene', 'VIP', 'Genesis'),
(681, 8, 3, 'Biene', 'VIP', 'Test-Server'),
(769, 8, 1, 'Dimplex', 'Dev-Fightbase', 'Fightbase'),
(769, 5, 2, 'Dimplex', 'Transfer-Event-GM', 'Genesis'),
(769, 8, 3, 'Dimplex', 'Transfer-Event-GM', 'Test-Server'),
(1380, 6, 2, 'Hasilein', 'Transfer-Leitung', 'Genesis'),
(1380, 8, 3, 'Hasilein', 'Transfer-Leitung', 'Test-Server'),
(1382, 8, -1, 'Wasitank', 'Team-Leitung', 'Alle'),
(2531, 6, 2, 'Suse', 'Mod-Leitung', 'Genesis'),
(2531, 8, 3, 'Suse', 'Mod-Leitung', 'Test-Server'),
(2690, 8, -1, 'Dekora', 'Dev-Leitung', 'Alle'),
(5483, 8, -1, 'Skyangle', 'Team-Leitung', 'Alle'),
(7499, 5, 2, 'Lyrox', 'Event-GM', 'Genesis'),
(7499, 8, 3, 'Lyrox', 'Event-GM', 'Test-Server'),
(7676, 6, 2, 'Indrik', 'Event-Leitung', 'Genesis'),
(7676, 8, 3, 'Indrik', 'Event-Leitung', 'Test-Server'),
(7936, 4, 2, 'Keksii', 'Transfer-GM', 'Genesis'),
(7936, 8, 3, 'Keksii', 'Transfer-GM', 'Test-Server'),
(7987, 6, 2, 'Nighty', 'GM-Leitung', 'Genesis'),
(7987, 8, 3, 'Nighty', 'GM-Leitung', 'Test-Server'),
(8173, 3, 2, 'Ariano', 'GM', 'Genesis'),
(8173, 8, 3, 'Ariano', 'Dev', 'Test-Server'),
(10156, 2, 2, 'Ckey', 'Test-GM', 'Genesis'),
(10156, 8, 3, 'Ckey', 'Test-GM', 'Test-Server'),
(10255, 2, 2, 'Totti', 'Test-Dev', 'Genesis'),
(10255, 8, 3, 'Totti', 'Test-Dev', 'Test-Server'),
(10345, 3, 2, 'Skydragon', 'GM', 'Genesis'),
(10345, 8, 3, 'Skydragon', 'GM', 'Test-Server'),
(10347, 2, 2, 'Sorijana', 'Test-GM', 'Genesis'),
(10347, 8, 3, 'Sorijana', 'Test-GM', 'Test-Server'),
(10381, 3, 2, 'Elwirá', 'Dev', 'Genesis'),
(10381, 8, 3, 'Elwirá', 'Dev', 'Test-Server'),
(10383, 3, 2, 'Etomidate', 'GM', 'Genesis'),
(10383, 8, 3, 'Etomidate', 'GM', 'Test-Server'),
(10401, 3, 2, 'Twisted', 'GM', 'Genesis'),
(10401, 8, 3, 'Twisted', 'GM', 'Test-Server'),
(10411, 3, 2, 'Xslayer', 'GM', 'Genesis'),
(10411, 8, 3, 'Xslayer', 'GM', 'Test-Server'),
(10546, 3, 2, 'Skorpi', 'GM', 'Genesis'),
(10546, 8, 3, 'Skorpi', 'GM', 'Test-Server'),
(10655, 2, 2, 'Migi', 'Test-GM', 'Genesis'),
(10655, 8, 3, 'Migi', 'Test-GM', 'Test-Server'),
(10656, 2, 2, 'Channa', 'Test-GM', 'Genesis'),
(10656, 8, 3, 'Channa', 'Test-GM', 'Test-Server'),
(10670, 2, 2, 'Nokoribi', 'Test-Dev', 'Genesis'),
(10670, 8, 3, 'Nokoribi', 'Test-Dev', 'Test-Server'),
(10737, 2, 2, 'Shoana', 'Test-GM', 'Genesis'),
(10737, 8, 3, 'Shoana', 'Test-GM', 'Test-Server');