CREATE TABLE IF NOT EXISTS `accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(24) NOT NULL,
  `passwort` varchar(129) NOT NULL,
  `adminlevel` int(2) NOT NULL,
  `geld` int(11) NOT NULL,
  `level` int(2) NOT NULL,
  `alt` int(2) NOT NULL,
  `job` int(2) NOT NULL,
  `tutorial` int(2) NOT NULL,
  `skin` int(11) NOT NULL,
  `geschlecht` int(2) NOT NULL,
  `gameintro` int(2) NOT NULL,
  `krankheit` int(2) NOT NULL,
  `lust` int(2) NOT NULL,
  `handy` int(2) NOT NULL,
  `handynummer` int(20) NOT NULL,
  `handystatus` int(2) NOT NULL,
  `guthaben` int(11) NOT NULL,
  `vertrag` int(2) NOT NULL,
  `akku` int(2) NOT NULL,
  `wa` int(2) NOT NULL,
  `personalausweis` int(2) NOT NULL,
  `quest` int(2) NOT NULL,
  `klingelton` int(2) NOT NULL,
  `jailed` int(3) NOT NULL DEFAULT '-1',
  `telefonbuch` int(2) NOT NULL,
  `autoschein` int(2) NOT NULL,
  `algeld` int(2) NOT NULL,
  `fraktion` int(2) NOT NULL,
  `kondom` int(2) NOT NULL,
  `einweiser` int(2) NOT NULL,
  `ban` int(11) NOT NULL,
  `maske` int(2) NOT NULL,
  `karte` int(2) NOT NULL,
  `pin` int(4) NOT NULL,
  `konto` int(11) NOT NULL,
  `mob` int(2) NOT NULL,
  `c4` int(2) NOT NULL,
  `btuch` int(2) NOT NULL,
  `wanteds` int(2) NOT NULL,
  `praemie` int(11) NOT NULL,
  `premium` int(2) NOT NULL,
  `premiumzeit` int(11) NOT NULL,
  `hotel` int(2) NOT NULL DEFAULT '255',
  `spawnchange` int(2) NOT NULL,
  `frakskin` int(11) NOT NULL,
  `tod` int(2) NOT NULL,
  `krankenver` int(2) NOT NULL,
  `rank` int(2) NOT NULL,
  `leiter` int(2) NOT NULL,
  `mitglied` int(2) NOT NULL,
  `aschein` int(2) NOT NULL,
  `angel` int(2) NOT NULL,
  `koeder` int(3) NOT NULL,
  `fisch` int(3) NOT NULL,
  `ahut` int(2) NOT NULL DEFAULT '-1',
  `askill` int(3) NOT NULL,
  `pfand` int(3) NOT NULL,
  `bootsschein` int(2) NOT NULL,
  `ghettob` int(2) NOT NULL,
  `mp3` int(2) NOT NULL,
  `schaufel` int(2) NOT NULL,
  `ziga` int(2) NOT NULL,
  `bier` int(2) NOT NULL,
  `feuerz` int(11) NOT NULL,
  `rauchsucht` int(11) NOT NULL,
  `alkoholsucht` int(2) NOT NULL,
  `jobskin` int(11) NOT NULL,
  `waffenschein` int(3) NOT NULL,
  `laservisier` int(2) NOT NULL,
  `tsident` int(11) NOT NULL,
  `helm` int(2) NOT NULL DEFAULT '-1',
  `helmstatus` int(2) NOT NULL,
  `sonnenbrille` int(11) NOT NULL,
  `hut` int(2) NOT NULL DEFAULT '-1',
  `atmrob` int(2) NOT NULL,
  `hackwerkzeug` int(2) NOT NULL,
  `haus` int(11) NOT NULL DEFAULT '-1',
  `wohnwagen` int(2) NOT NULL,
  `punkte` int(11) NOT NULL,
  `arch` int(2) NOT NULL,
  `archz` int(11) NOT NULL,
  `ticket` int(2) NOT NULL,
  `warns` int(2) NOT NULL,
  `damage` double NOT NULL,
  `flugschein` int(2) NOT NULL,
  `pilotenskill` int(2) NOT NULL,
  `gebanntvon` varchar(26) NOT NULL,
  `gebanntgrund` varchar(75) NOT NULL,
  `pbkill` int(3) NOT NULL,
  `pbtode` int(3) NOT NULL,
  `ksscore` int(3) NOT NULL,
  `driftzeit` int(11) NOT NULL,
  `mgk` int(3) NOT NULL,
  `miniguntode` int(3) NOT NULL,
  `hausboot` int(2) NOT NULL,
  `faq` int(2) NOT NULL,
  `spunkte` int(11) NOT NULL,
  `roleplayname` varchar(26) NOT NULL DEFAULT 'Vorname_Nachname',
  `mschein` int(2) NOT NULL,
  `tschein` int(2) NOT NULL,
  `prison` int(2) NOT NULL DEFAULT '-1',
  `prisoncp` int(3) NOT NULL,
  `supsperre` int(2) NOT NULL,
  `jobtime` int(11) NOT NULL,
  `bizz` int(2) NOT NULL DEFAULT '-1',
  `kabelbinder` int(2) NOT NULL,
  `augenbinde` int(2) NOT NULL,
  `diet` int(2) NOT NULL,
  `drogen` int(11) NOT NULL,
  `drogensamen` int(3) NOT NULL,
  `duenger` int(2) NOT NULL,
  `mats` int(11) NOT NULL,
  `lohn` int(11) NOT NULL DEFAULT '850',
  `eisen` int(3) NOT NULL,
  `lastonline` int(11) NOT NULL,
  `lastip` varchar(20) NOT NULL,
  `erf` int(3) NOT NULL,
  `paypoints` int(2) NOT NULL,
  `payday` int(2) NOT NULL,
  `mieter` int(3) NOT NULL,
  `reisepass` int(2) NOT NULL,
  `visum` int(2) NOT NULL,
  `lastcrime` varchar(128) NOT NULL DEFAULT 'N/A',
  `enforcer` int(2) NOT NULL,
  `bombe` int(2) NOT NULL,
  `jailed2` int(3) NOT NULL DEFAULT '-1',
  `tickets` int(3) NOT NULL,
  `jailc` int(3) NOT NULL,
  `wantedc` int(3) NOT NULL,
  `akte` int(3) NOT NULL,
  `note` int(2) NOT NULL,
  `geworbenvon` varchar(26) NOT NULL DEFAULT 'Keinem',
  `fightstyle` int(2) NOT NULL,
  `ts3id` varchar(50) NOT NULL DEFAULT 'N/A',
  `freig` int(2) NOT NULL,
  `ofrak` int(2) NOT NULL,
  `bandana` int(2) NOT NULL DEFAULT '-1',
  `funmodus` int(2) NOT NULL,
  `login` int(2) NOT NULL,
  `premiumpd` int(3) NOT NULL,
  `bombenmats` int(2) NOT NULL,
  `namechanges` int(3) NOT NULL,
  `verheiratet` int(2) NOT NULL,
  `verheiratetmit` varchar(26) NOT NULL DEFAULT 'Keinem',
  `audiostream` int(2) NOT NULL,
  `questa` int(2) NOT NULL,
  `network` int(2) NOT NULL DEFAULT '1',
  `rd` int(11) NOT NULL,
  `tode` int(3) NOT NULL,
  `kills` int(3) NOT NULL,
  `spielstunden` int(3) NOT NULL,
  `event` int(2) NOT NULL,
  `praemie2` int(11) NOT NULL,
  `countdown` int(2) NOT NULL,
  `tazer` int(2) NOT NULL,
  `al` int(2) NOT NULL,
  `eventm` int(2) NOT NULL,
  `lotto1` int(2) NOT NULL DEFAULT '-1',
  `lotto2` int(2) NOT NULL DEFAULT '-1',
  `lotto3` int(2) NOT NULL DEFAULT '-1',
  `lotto4` int(2) NOT NULL DEFAULT '-1',
  `lotto5` int(2) NOT NULL DEFAULT '-1',
  `lotto6` int(2) NOT NULL DEFAULT '-1',
  `pilot` int(2) NOT NULL DEFAULT '0',
  `neuling` int(2) NOT NULL,
  `hits` int(2) NOT NULL,
  `lnach` int(2) NOT NULL,
  `ageber` varchar(24) NOT NULL DEFAULT 'N/A',
  `apreis` int(4) NOT NULL DEFAULT '-1',
  `aziel` int(3) NOT NULL DEFAULT '-1',
  `fsperre` int(11) NOT NULL DEFAULT '-1',
  `email` varchar(129) NOT NULL DEFAULT 'N/A',
  `emaile` int(2) NOT NULL,
  `warning1` varchar(50) NOT NULL,
  `warning2` varchar(50) NOT NULL,
  `warning3` varchar(50) NOT NULL,
  `raketen` int(20) NOT NULL,
  `Terrordrogen` int(20) NOT NULL,
  `blitzer` int(20) NOT NULL,
  `kanister` int(20) NOT NULL,
  `gasmaske` int(20) NOT NULL,
  `ladenrob` int(20) NOT NULL,
  `radio` int(20) NOT NULL,
  `cool` int(20) NOT NULL,
  `mute` int(20) NOT NULL,
  `rusi` int(20) NOT NULL,
  `leben` int(20) NOT NULL,
  `punkte0` int(20) NOT NULL,
  `punkte1` int(20) NOT NULL,
  `punkte2` int(20) NOT NULL,
  `punkte3` int(20) NOT NULL,
  `punkte4` int(20) NOT NULL,
  `punkte5` int(20) NOT NULL,
  `hbank` int(20) NOT NULL,
  `sniper` int(20) NOT NULL,
  `nagel` int(20) NOT NULL,
  `auftrage` int(20) NOT NULL,
  `coins` int(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=50774 ;


CREATE TABLE IF NOT EXISTS `achievements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(24) NOT NULL,
  `firstspawn` int(2) NOT NULL,
  `firstpayday` int(2) NOT NULL,
  `krankenhaus` int(2) NOT NULL,
  `helm` int(2) NOT NULL,
  `konto` int(2) NOT NULL,
  `ww` int(2) NOT NULL,
  `bus` int(2) NOT NULL,
  `laden` int(2) NOT NULL,
  `foto` int(2) NOT NULL,
  `damage1` int(2) NOT NULL,
  `damage2` int(2) NOT NULL,
  `damage3` int(2) NOT NULL,
  `damage4` int(2) NOT NULL,
  `damage5` int(2) NOT NULL,
  `ehausboot` int(2) NOT NULL,
  `edance` int(2) NOT NULL,
  `ejob` int(2) NOT NULL,
  `ebizz` int(2) NOT NULL,
  `emord` int(2) NOT NULL,
  `epaintball` int(2) NOT NULL,
  `eminigun` int(2) NOT NULL,
  `ederby` int(2) NOT NULL,
  `ekart` int(2) NOT NULL,
  `eauftrag` int(2) NOT NULL,
  `eliebe` int(2) NOT NULL,
  `echicken` int(2) NOT NULL,
  `eessen` int(2) NOT NULL,
  `ehaus` int(2) NOT NULL,
  `etuning` int(2) NOT NULL,
  `ebandana` int(2) NOT NULL,
  `efahrzeug` int(2) NOT NULL,
  `ekirche` int(2) NOT NULL,
  `edrogen` int(2) NOT NULL,
  `elegende` int(2) NOT NULL,
  `esupport` int(2) NOT NULL,
  `ebrand` int(2) NOT NULL,
  `emp` int(2) NOT NULL,
  `ehai` int(2) NOT NULL,
  `eal` int(2) NOT NULL,
  `ejoke` int(2) NOT NULL,
  `eangeln` int(2) NOT NULL,
  `erett` int(2) NOT NULL,
  `equest2` int(2) NOT NULL,
  `equest3` int(2) NOT NULL,
  `equest4` int(2) NOT NULL,
  `equest5` int(2) NOT NULL,
  `equest6` int(2) NOT NULL,
  `epenner` int(2) NOT NULL,
  `ejail` int(2) NOT NULL,
  `eblitz` int(2) NOT NULL,
  `esteck` int(2) NOT NULL,
  `equest7` int(2) NOT NULL,
  `equest8` int(2) NOT NULL,
  `equest9` int(2) NOT NULL,
  `equest10` int(2) NOT NULL,
  `enescar` int(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=50772 ;


CREATE TABLE IF NOT EXISTS `adventskalender` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(26) NOT NULL,
  `a1` int(2) NOT NULL,
  `a2` int(2) NOT NULL,
  `a3` int(2) NOT NULL,
  `a4` int(2) NOT NULL,
  `a5` int(2) NOT NULL,
  `a6` int(2) NOT NULL,
  `a7` int(2) NOT NULL,
  `a8` int(2) NOT NULL,
  `a9` int(2) NOT NULL,
  `a10` int(2) NOT NULL,
  `a11` int(2) NOT NULL,
  `a12` int(2) NOT NULL,
  `a13` int(2) NOT NULL,
  `a14` int(2) NOT NULL,
  `a15` int(2) NOT NULL,
  `a16` int(2) NOT NULL,
  `a17` int(2) NOT NULL,
  `a18` int(2) NOT NULL,
  `a19` int(2) NOT NULL,
  `a20` int(2) NOT NULL,
  `a21` int(2) NOT NULL,
  `a22` int(2) NOT NULL,
  `a23` int(2) NOT NULL,
  `a24` int(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6741 ;


CREATE TABLE IF NOT EXISTS `bans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `IP` varchar(20) NOT NULL,
  `name` varchar(24) NOT NULL,
  `grund` varchar(128) NOT NULL,
  `von` varchar(26) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=775 ;


CREATE TABLE IF NOT EXISTS `blitzer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sperreX` double NOT NULL,
  `sperreY` double NOT NULL,
  `sperreZ` double NOT NULL,
  `sperreA` double NOT NULL,
  `BlitzerGeschwindigkeit` int(11) NOT NULL,
  `BlitzerOrt` varchar(128) NOT NULL,
  UNIQUE KEY `id_2` (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;


CREATE TABLE IF NOT EXISTS `businesse` (
  `bid` int(11) NOT NULL AUTO_INCREMENT,
  `bowned` int(2) NOT NULL,
  `bname` varchar(36) NOT NULL,
  `bowner` varchar(36) NOT NULL,
  `bowner2` varchar(36) NOT NULL,
  `bbx` double NOT NULL,
  `bby` double NOT NULL,
  `bbz` double NOT NULL,
  `blevel` int(2) NOT NULL,
  `bpreis` int(11) NOT NULL,
  `btill` int(11) NOT NULL,
  `bproducts` int(11) NOT NULL,
  `bmaxproducts` int(11) NOT NULL,
  `bpriceprod` int(11) NOT NULL,
  `bkasse` int(11) NOT NULL,
  `bprods` int(2) NOT NULL,
  PRIMARY KEY (`bid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ;


INSERT INTO `businesse` (`bid`, `bowned`, `bname`, `bowner`,`bowner2`, `bbx`, `bby`, `bbz`, `blevel`, `bpreis`, `btill`, `bproducts`, `bmaxproducts`, `bpriceprod`, `bkasse`, `bprods`) VALUES
(0, 0, 'Ammunation-Commerce', 'Frei', 'Keiner', 1380.156, -1790.244, 13.545, 6, 550000, 1, 784, 2000, 41, 0, 1),
(1, 0, 'Waffenladen-Downtown', 'Frei','Keiner', 1785.973, -1164.404, 23.826, 10, 1200000, 0, 2000, 2000, 42, 59322, 0),
(2, 0, 'Ammunation - Oliveira [GMBH]', 'Frei','Keiner', 2397.071, -1980.18, 13.545, 6, 400000, 0, 1299, 2000, 41, 0, 0),
(3, 0, 'Ammunation-Downtown', 'Frei','Keiner', 1365.285, -1275.927, 13.545, 10, 1350000, 0, 4975, 5000, 42, 131916, 0),
(4, 0, 'Minigames', 'Frei','Keiner', 1313.8, -1369.661, 13.571, 7, 750000, 250, 141, 2000, 41, 715, 0),
(5, 0, 'Sprunk Systems GmbH', 'Frei','Keiner', 891.687, -1800.947, 13.791, 7, 750000, 0, 909, 2000, 41, 16335, 0),
(6, 0, 'PigPen', 'Frei','Keiner', 2424.714, -1220.822, 25.447, 8, 800000, 0, 1700, 2000, 42, 12408, 0),
(7, 0, 'Terroristen GmbH', 'Frei','Keiner', 1322.088, -896.726, 39.588, 5, 850000, 0, 843, 2000, 41, 95822, 1),
(8, 0, 'Tankstelle-1', 'Frei','Keiner', 1930.098, -1770.473, 13.545, 10, 1000000, 11, 1980, 2000, 4, 740, 0),
(9, 0, 'Tankstelle-2', 'Frei','Keiner', 998.754, -915.945, 42.179, 10, 1300000, 0, 889, 2000, 41, 14726, 0),
(10, 0, 'Department Tankstelle', 'Frei','Keiner', -81.763, -1175.291, 2.075, 6, 750000, 11, 1296, 2000, 41, 74989, 1),
(11, 0, 'Tankstelle - 4', 'Frei','Keiner', 1341.489, -1557.831, 13.545, 7, 1200000, 11, 687, 5000, 4, 3499, 0),
(12, 0, 'Daniel & Jerome [Hawkins GmBh]', 'Frei','Keiner', 1107.088, -1413.307, 13.59, 9, 1200000, 0, 1159, 2000, 41, 31433, 0),
(13, 0, 'Donutladen', 'Frei','Keiner', 1027.218, -1350.687, 13.3, 5, 450000, 0, 1348, 2000, 42, 348, 0),
(14, 0, 'Kaffeeladen', 'Frei','Keiner', 390.265, -1515.468, 32.34, 6, 550000, 0, 1955, 2000, 42, 10031, 0),
(15, 0, 'Victim', 'Frei','Keiner', 456.717, -1495.395, 31.083, 7, 600000, 0, 934, 2000, 42, 3302, 0),
(16, 0, 'Prolaps', 'Frei','Keiner', 505.48, -1373.774, 16.125, 6, 600000, 0, 1254, 2000, 42, 156, 0),
(17, 0, 'Casino-Hochhaus', 'Frei','Keiner', 1805.848, -1291.109, 13.619, 10, 1000000, 0, 1986, 2000, 42, 140440, 0),
(18, 0, 'Alhambra', 'Frei','Keiner', 1835.088, -1673.702, 13.406, 7, 700000, 0, 1929, 2000, 42, 17, 0),
(19, 0, 'Binco', 'Frei','Keiner', 2233.757, -1667.838, 15.22, 6, 500000, 0, 0, 2000, 42, 1238, 0),
(20, 0, 'Jizzys-Club', 'Frei','Keiner', 2121.385, -1744.375, 13.553, 6, 650000, 0, 2000, 2000, 42, 5082, 0),
(21, 0, 'Johny_JohnseN GmBH', 'Frei','Keiner', -2521.131, -624.952, 132.783, 9, 3000000, 0, 1000, 2000, 41, 15000, 0),
(22, 0, 'Pferderenn-Bahn', 'Frei','Keiner', 1628.255, -1169.097, 24.076, 8, 1500000, 0, 1935, 2000, 42, 353780, 0),
(23, 0, 'Lotto-Totto', 'Frei','Keiner', 861.418, -1577.904, 13.543, 8, 950000, 0, 1881, 2000, 42, 27840, 0),
(24, 0, 'Daniel & Jerome [Hawkins GmBh]', 'Frei','Keiner', -1996.17, 274.54, 32.922, 10, 1400000, 0, 1300, 2000, 45, 1063175, 0),
(25, 0, 'Pay & Spray GmbH', 'Frei','Keiner', 1643.196, -1520.739, 13.559, 9, 950000, 1000, 2853, 5000, 41, 0, 0),
(26, 0, '24/7-1', 'Frei','Keiner', 1971.838, -2036.529, 13.545, 8, 800000, 0, 2001, 2000, 42, 5237, 0),
(27, 0, '[Department Gmbh] 24/7 Laden', 'Frei','Keiner', 1342.379, -1759.723, 13.578, 6, 650000, 0, 907, 5000, 42, 8297, 0),
(28, 0, '24/7-3', 'Frei','Keiner', 1831.717, -1847.337, 13.578, 7, 650000, 0, 2015, 2000, 42, 321, 0),
(29, 0, 'Escobar GmbH', 'Frei','Keiner', 2350.197, -1405.041, 23.989, 5, 550000, 200, 1715, 2000, 50, 0, 1),
(30, 0, '24/7-5', 'Frei','Keiner', 1295.425, -892.702, 42.881, 9, 750000, 0, 1849, 2000, 42, 44612, 0),
(31, 0, 'Telefon Gmbh', 'Frei','Keiner', -2234.833, -180.651, 35.319, 6, 500000, 15, 2000, 2000, 42, 15350, 0),
(32, 0, 'Burger-Shot', 'Frei','Keiner', 1510.447, -1604.394, 13.3, 7, 700000, 0, 2000, 2000, 42, 7210, 0),
(33, 0, 'Burger-Shot', 'Frei','Keiner', 811.572, -1623.078, 13.553, 5, 400000, 0, 1995, 2000, 42, 13950, 0),
(34, 0, 'Burger Shot Nord', 'Frei','Keiner', 1209.635, -927.103, 42.922, 8, 1000000, 0, 1408, 2000, 42, 265, 0),
(35, 0, '[Department GmbH] Fast Food', 'Frei','Keiner', 926.08, -1350.119, 13.373, 7, 750000, 0, 2000, 2000, 42, 11640, 0),
(36, 0, '[Department GmbH] Fast Food', 'Frei','Keiner', 2420.312, -1501.541, 24, 5, 400000, 0, 1305, 2000, 41, 155, 0),
(37, 0, '[Department GmbH] Fast Food', 'Frei','Keiner', 2391.652, -1898.612, 13.545, 5, 400000, 0, 1965, 2000, 42, 13870, 0),
(38, 0, 'Pizzaladen', 'Frei','Keiner', 2104.531, -1803.697, 13.55, 7, 750000, 0, 2000, 2000, 42, 15000, 0),
(39, 0, 'Montailo-Hotel', 'Frei','Keiner', 1477.281, -1714.374, 14.656, 10, 1200000, 0, 1909, 2000, 42, 522, 0),
(40, 0, '[Department GmbH] Fast Food', 'Frei','Keiner', 1243.931, -1176.255, 24.231, 5, 550000, 0, 1995, 2000, 42, 10680, 0),
(41, 0, 'Saad GmbH', 'Frei','Keiner', 2115.756, -1884.77, 13.545, 8, 850000, 1000, 1694, 2000, 41, 5446, 1),
(42, 0, 'Bandana-Shop', 'Frei','Keiner', 1454.776, -1142.8, 24.065, 7, 650000, 0, 23, 2000, 42, 14, 0),
(43, 0, 'Johnys Autohäuser', 'Frei','Keiner', 1702.661, -1469.342, 13.545, 8, 1500000, 0, 3410, 5000, 41, 789218, 1),
(44, 0, 'Tankstelle-5', 'Frei','Keiner', 661.033, -569.783, 16.333, 7, 750000, 11, 1010, 2000, 4, 15000, 0);


CREATE TABLE IF NOT EXISTS `drogenpflanzen` (
  `pflanze` int(12) NOT NULL,
  `drgfraktid` int(3) NOT NULL,
  `drgArt` int(3) NOT NULL,
  `drgXpos` float(10,4) NOT NULL,
  `drgYpos` float(10,4) NOT NULL,
  `drgZpos` float(10,4) NOT NULL,
  `drginterior` int(5) NOT NULL,
  `drgvirtualworld` int(5) NOT NULL,
  `drgProduceDrugs` int(10) NOT NULL,
  `drgNextDrugsIn` int(128) NOT NULL,
  `drgWasserzustand` int(6) NOT NULL,
  `drgOwner` varchar(24) NOT NULL,
  PRIMARY KEY (`pflanze`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `einstellungen` (
  `id` int(2) NOT NULL,
  `bombenkasse` int(2) NOT NULL,
  `staatskasse` int(11) NOT NULL,
  `cnnkasse` int(11) NOT NULL,
  `zeitung` int(2) NOT NULL,
  `eisenlager` int(11) NOT NULL,
  `drogenlager` int(11) NOT NULL,
  `banfall` int(11) NOT NULL,
  `adminpw` varchar(35) NOT NULL,
  `codupgrade` int(2) NOT NULL,
  `codwaffen` int(11) NOT NULL,
  `codkasse` int(11) NOT NULL,
  `coddrogenkasse` int(11) NOT NULL,
  `codmatkasse` int(11) NOT NULL,
  `esbupgrade` int(2) NOT NULL,
  `esbwaffen` int(11) NOT NULL,
  `esbkasse` int(11) NOT NULL,
  `esbdrogenkasse` int(11) NOT NULL,
  `esbmatkasse` int(11) NOT NULL,
  `hmkasse` int(11) NOT NULL,
  `hmeisenkasse` int(11) NOT NULL,
  `msupgrade` int(2) NOT NULL,
  `mswaffen` int(11) NOT NULL,
  `mskasse` int(11) NOT NULL,
  `msdrogenkasse` int(11) NOT NULL,
  `msmatkasse` int(11) NOT NULL,
  `terrorkasse` int(11) NOT NULL,
  `eventhut` int(5) NOT NULL,
  `terrorwaffen` text NOT NULL,
  `terrorupgrade` int(2) NOT NULL,
  `Terrordrogen` int(20) NOT NULL,
  `Terrormats` int(20) NOT NULL,
  `Terrorrpg` int(20) NOT NULL,
  `wstatus0` int(20) NOT NULL,
  `wstatus1` int(20) NOT NULL,
  `wstatus2` int(20) NOT NULL,
  `wstatus3` int(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `einstellungen` (`id`, `bombenkasse`, `staatskasse`, `cnnkasse`, `zeitung`, `eisenlager`, `drogenlager`, `banfall`, `adminpw`, `codupgrade`, `codwaffen`, `codkasse`, `coddrogenkasse`, `codmatkasse`, `esbupgrade`, `esbwaffen`, `esbkasse`, `esbdrogenkasse`, `esbmatkasse`, `hmkasse`, `hmeisenkasse`, `msupgrade`, `mswaffen`, `mskasse`, `msdrogenkasse`, `msmatkasse`, `terrorkasse`, `eventhut`, `terrorwaffen`, `terrorupgrade`, `Terrordrogen`, `Terrormats`, `Terrorrpg`, `wstatus0`, `wstatus1`, `wstatus2`, `wstatus3`) VALUES
(0, 78, 1328887397, 15833, 1, 1185758, 594087, 3384, 'justin1998', 5, 10355, 4831, 4096, 2555, 5, 4490, 223060, 5733, 18714, 76400, 4635, 5, 1485, 456, 2734, 3945, 108589, 19065, '5830', 5,5,5,5,5,5,5,5);


CREATE TABLE IF NOT EXISTS `fahrzeuge` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(26) NOT NULL,
  `slot` int(3) NOT NULL,
  `modelid` int(4) NOT NULL,
  `x` float(10,4) NOT NULL,
  `y` float(10,4) NOT NULL,
  `z` float(10,4) NOT NULL,
  `a` float(10,4) NOT NULL,
  `cc1` int(4) NOT NULL,
  `cc2` int(4) NOT NULL,
  `paintjob` int(6) NOT NULL,
  `vehhp` float(10,4) NOT NULL,
  `abgeschlossen` int(2) NOT NULL,
  `t1` int(6) NOT NULL,
  `t2` int(6) NOT NULL,
  `t3` int(6) NOT NULL,
  `t4` int(6) NOT NULL,
  `t5` int(6) NOT NULL,
  `t6` int(6) NOT NULL,
  `t7` int(6) NOT NULL,
  `t8` int(6) NOT NULL,
  `t9` int(6) NOT NULL,
  `t10` int(6) NOT NULL,
  `t11` int(6) NOT NULL,
  `t12` int(6) NOT NULL,
  `t13` int(6) NOT NULL,
  `t14` int(6) NOT NULL,
  `preis` int(11) NOT NULL,
  `tuev` int(2) NOT NULL,
  `tank` int(3) NOT NULL,
  `towed` int(2) NOT NULL,
  `towedfreeprice` int(10) NOT NULL,
  `towedreason` varchar(64) NOT NULL DEFAULT 'N/A',
  `neon` int(6) NOT NULL,
  `mats` int(4) NOT NULL,
  `drogen` int(4) NOT NULL,
  `eisen` int(4) NOT NULL,
  `waffe` int(2) NOT NULL,
  `ammo` int(3) NOT NULL,
  `waffe2` int(2) NOT NULL,
  `ammo2` int(3) NOT NULL,
  `waffe3` int(2) NOT NULL,
  `ammo3` int(3) NOT NULL,
  `batt` int(3) NOT NULL,
  `reifenk` int(2) NOT NULL,
  `reifene` int(2) NOT NULL,
  `motork` int(2) NOT NULL,
  `drossel` int(2) NOT NULL,
  `auspuff` int(2) NOT NULL,
  `besitzer2` varchar(24) NOT NULL DEFAULT 'N/A',
  `kralle` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=664 ;



CREATE TABLE IF NOT EXISTS `gutscheine` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `gutschein` int(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=80 ;



CREATE TABLE IF NOT EXISTS `hausboot` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `inhaber` varchar(24) NOT NULL,
  `posx` double NOT NULL,
  `posy` double NOT NULL,
  `posz` double NOT NULL,
  `posa` double NOT NULL,
  `tank` int(3) NOT NULL,
  `leben` int(5) NOT NULL,
  `status` int(2) NOT NULL,
  `farbe1` int(3) NOT NULL,
  `farbe2` int(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;



CREATE TABLE IF NOT EXISTS `hddbans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `IP` varchar(20) NOT NULL,
  `GPCI` varchar(45) NOT NULL,
  `name` varchar(24) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=292 ;



CREATE TABLE IF NOT EXISTS `houses` (
  `hID` int(11) NOT NULL AUTO_INCREMENT,
  `hPreis` int(11) NOT NULL,
  `hLevel` int(2) NOT NULL,
  `hBesitzer` varchar(26) NOT NULL,
  `hInterior` int(2) NOT NULL,
  `hMieter` int(2) NOT NULL,
  `hMaxMieter` int(2) NOT NULL,
  `hLock` int(2) NOT NULL,
  `hRent` int(11) NOT NULL,
  `hDrogen` int(11) NOT NULL,
  `hMats` int(11) NOT NULL,
  `hWaffenschrank` int(2) NOT NULL,
  `hGun0` int(11) NOT NULL,
  `hGun1` int(11) NOT NULL,
  `hGun2` int(2) NOT NULL,
  `hGun3` int(2) NOT NULL,
  `hGun4` int(2) NOT NULL,
  `hAmmo0` int(11) NOT NULL,
  `hAmmo1` int(11) NOT NULL,
  `hAmmo2` int(3) NOT NULL,
  `hAmmo3` int(3) NOT NULL,
  `hAmmo4` int(3) NOT NULL,
  `hKasse` int(11) NOT NULL,
  `hHeal` int(2) NOT NULL,
  `hOwned` int(2) NOT NULL,
  `hVersteck` int(2) NOT NULL,
  `hX` float NOT NULL,
  `hY` float NOT NULL,
  `hZ` float NOT NULL,
  PRIMARY KEY (`hID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=178 ;



INSERT INTO `houses` (`hID`, `hPreis`, `hLevel`, `hBesitzer`, `hInterior`, `hMieter`, `hMaxMieter`, `hLock`, `hRent`, `hDrogen`, `hMats`, `hWaffenschrank`, `hGun0`, `hGun1`, `hGun2`, `hGun3`, `hGun4`, `hAmmo0`, `hAmmo1`, `hAmmo2`, `hAmmo3`, `hAmmo4`, `hKasse`, `hHeal`, `hOwned`, `hVersteck`, `hX`, `hY`, `hZ`) VALUES
(0, 60000, 5, 'Frei', 13, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1141.8, -1069.99, 31.763),
(1, 60000, 5, 'Frei', 11, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1183.47, -1076.11, 31.677),
(2, 60000, 5, 'Frei', 4, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1142.12, -1092.82, 28.187),
(3, 60000, 5, 'Frei', 9, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1183.47, -1099, 28.256),
(4, 60000, 5, 'Frei', 7, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1103.4, -1069.53, 31.888),
(5, 60000, 5, 'Frei', 9, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1103.41, -1092.51, 28.468),
(6, 75000, 5, 'Frei', 11, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1068.42, -1081.34, 27.544),
(7, 75000, 5, 'Frei', 11, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1285.26, -1067.39, 31.677),
(8, 60000, 5, 'Frei', 9, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1285.27, -1090.2, 28.256),
(9, 60000, 5, 'Frei', 4, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1241.94, -1076.54, 31.554),
(10, 62000, 5, 'Frei', 13, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1242.26, -1099.4, 27.975),
(11, 60000, 5, 'Frei', 9, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1325.94, -1067.77, 31.554),
(12, 60000, 5, 'Frei', 4, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1326.26, -1090.61, 27.975),
(13, 25000, 3, 'Frei', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1179.89, -1260.97, 18.898),
(14, 25000, 3, 'Frei', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1187.36, -1227.1, 22.131),
(15, 61000, 5, 'Frei', 8, 0, 3, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 693.755, -1645.88, 4.092),
(16, 55000, 5, 'Frei', 4, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 694.877, -1690.73, 4.346),
(17, 61000, 5, 'Frei', 14, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 693.544, -1705.81, 3.819),
(18, 27000, 3, 'Frei', 16, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 910.192, -1802.68, 13.798),
(19, 27000, 3, 'Frei', 10, 1, 1, 1, 125, 0, 0, 1, 31, 0, 0, 0, 0, 1, 0, 0, 0, 0, 125, 0, 1, 1, 933.619, -1805.2, 13.843),
(20, 28000, 3, 'Frei', 10, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 969.557, -1812.01, 13.883),
(21, 28000, 3, 'Frei', 3, 1, 1, 0, 200, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 200, 0, 1, 0, 992.611, -1817.63, 13.894),
(22, 58000, 5, 'Frei', 11, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2015.35, -1732.69, 14.234),
(23, 62000, 5, 'Frei', 10, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2018.24, -1703.32, 14.234),
(24, 65000, 5, 'Frei', 7, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2016.2, -1717, 14.125),
(25, 60000, 5, 'Frei', 3, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1973.28, -1705.15, 15.968),
(26, 58000, 5, 'Frei', 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1980.99, -1682.79, 17.052),
(27, 58000, 5, 'Frei', 13, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1974.82, -1671.19, 15.968),
(28, 61000, 5, 'Frei', 8, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2013.58, -1656.48, 14.135),
(29, 62000, 5, 'Frei', 6, 0, 4, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 700, 0, 1, 0, 2065.1, -1703.53, 14.147),
(30, 57000, 5, 'Frei', 12, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2066.24, -1717.04, 14.135),
(31, 25000, 3, 'Frei', 10, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1187.44, -1260.97, 15.178),
(32, 27000, 3, 'Frei', 16, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1179.89, -1261.01, 15.178),
(33, 25000, 3, 'Frei', 10, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1187.36, -1254.69, 15.178),
(34, 27000, 3, 'Frei', 16, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1179.81, -1254.78, 15.178),
(35, 27000, 3, 'Frei', 16, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1187.36, -1254.73, 18.888),
(36, 28000, 3, 'Frei', 17, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1179.81, -1254.75, 18.888),
(37, 28000, 3, 'Frei', 17, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1187.44, -1260.94, 18.898),
(38, 27000, 3, 'Frei', 16, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1179.89, -1233.36, 22.138),
(39, 28000, 3, 'Frei', 17, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1187.44, -1233.32, 22.138),
(40, 25000, 3, 'Frei', 10, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1179.81, -1227.17, 22.131),
(41, 26000, 3, 'Frei', 12, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1179.81, -1227.08, 18.554),
(42, 25000, 3, 'Frei', 10, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1187.36, -1227.07, 18.554),
(43, 26000, 3, 'Frei', 12, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1187.44, -1233.32, 18.554),
(44, 27000, 3, 'Frei', 16, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1179.89, -1233.29, 18.554),
(45, 60000, 5, 'Frei', 3, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1411.08, -920.856, 38.421),
(46, 62000, 5, 'Frei', 10, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1440.6, -926.125, 39.645),
(47, 61000, 5, 'Frei', 14, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1421.73, -886.231, 50.686),
(48, 61000, 5, 'Frei', 14, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1468.55, -906.184, 54.833),
(49, 61000, 5, 'Frei', 8, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1535.73, -885.265, 57.657),
(50, 57000, 5, 'Frei', 12, 3, 4, 0, 150, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1456, 0, 1, 0, 1540.47, -851.372, 64.333),
(51, 58000, 5, 'Frei', 13, 0, 3, 1, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1535.04, -800.213, 72.847),
(52, 55000, 5, 'Frei', 4, 0, 3, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1527.84, -772.604, 80.578),
(53, 1000000, 9, 'Frei', 2, 1, 10, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1002, 1, 1, 1, 1496.99, -687.892, 95.563),
(54, 75000, 7, 'Frei', 11, 0, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1332.11, -633.505, 109.134),
(55, 1000000, 9, 'Frei', 2, 1, 10, 0, 150, 900, 0, 1, 35, 33, 30, 34, 0, 3, 147, 492, 15, 0, 5152186, 1, 1, 1, 1259.64, -785.401, 92.027),
(56, 61000, 5, 'Frei', 2, 0, 3, 0, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1034.79, -813.192, 101.847),
(57, 61000, 5, 'Frei', 8, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1016.98, -763.361, 112.563),
(58, 65000, 5, 'Frei', 7, 0, 3, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 937.814, -848.739, 93.577),
(59, 58000, 5, 'Frei', 13, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 827.786, -857.992, 70.33),
(60, 58000, 5, 'Frei', 13, 0, 3, 0, 100, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 260, 0, 1, 1, 835.991, -894.882, 68.763),
(61, 125000, 8, 'Frei', 2, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 897.893, -677.155, 116.888),
(62, 58000, 5, 'Frei', 13, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 946.276, -710.716, 122.619),
(63, 1000000, 9, 'Frei', 1, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 980.491, -677.26, 121.972),
(64, 125000, 5, 'Frei', 3, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1045.15, -642.942, 120.111),
(65, 55000, 5, 'Frei', 4, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 824.565, -1424.2, 14.498),
(66, 61000, 5, 'Frei', 14, 2, 4, 0, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 350, 0, 1, 0, 852.276, -1423.27, 14.135),
(67, 58000, 5, 'Frei', 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 880.085, -1424.82, 14.484),
(68, 61000, 5, 'Frei', 8, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 813.69, -1456.69, 14.227),
(69, 60000, 5, 'Frei', 3, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 766.921, -1605.84, 13.803),
(70, 61000, 5, 'Frei', 8, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 768.078, -1655.79, 5.609),
(71, 55000, 5, 'Frei', 4, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 769.228, -1696.57, 5.155),
(72, 60000, 5, 'Frei', 3, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 769.228, -1745.9, 13.076),
(73, 57000, 5, 'Frei', 12, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 653.593, -1714.11, 14.762),
(74, 65000, 5, 'Frei', 7, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 652.666, -1693.98, 14.548),
(75, 61000, 5, 'Frei', 14, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 657.228, -1652.7, 15.406),
(76, 61000, 5, 'Frei', 14, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 656.03, -1635.87, 15.861),
(77, 58000, 5, 'Frei', 13, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 653.244, -1619.84, 15),
(78, 65000, 5, 'Frei', 7, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 692.898, -1602.78, 15.045),
(79, 58000, 5, 'Frei', 13, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2067.06, -1731.56, 14.206),
(80, 58000, 5, 'Frei', 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2149.86, -1433.74, 26.069),
(81, 58000, 5, 'Frei', 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2152.22, -1446.4, 26.104),
(82, 61000, 5, 'Frei', 14, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2150.92, -1419.09, 25.92),
(83, 60000, 5, 'Frei', 3, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3576.21, -2031.11, 12.461),
(84, 60000, 5, 'Frei', 3, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3594.1, -2038.89, 12.446),
(85, 61000, 5, 'Frei', 8, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3626.16, -2031.01, 12.461),
(86, 125000, 8, 'Frei', 2, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3646.17, -1992.19, 12.984),
(87, 125000, 8, 'Frei', 2, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3621.11, -1992.24, 12.984),
(88, 1000000, 9, 'Frei', 1, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3562.18, -2192.84, 11.269),
(89, 57000, 5, 'Frei', 12, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3498.54, -1921.3, 12.984),
(90, 60000, 5, 'Frei', 3, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3473.43, -1921.32, 12.984),
(91, 28000, 3, 'Frei', 17, 0, 1, 1, 0, 0, 0, 1, 24, 25, 31, 34, 29, 2820, 625, 2640, 500, 5640, 0, 0, 0, 0, 2282.39, -1641.21, 15.887),
(92, 26000, 3, 'Frei', 12, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2306.97, -1679.2, 14.331),
(93, 28000, 3, 'Frei', 5, 0, 1, 1, 200, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 2326.88, -1681.98, 14.928),
(94, 26000, 3, 'Frei', 12, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2362.84, -1643.14, 14.35),
(95, 25000, 3, 'Frei', 11, 0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 2368.25, -1675.34, 14.168),
(96, 26000, 3, 'Frei', 12, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2384.66, -1675.83, 15.244),
(97, 28000, 3, 'Frei', 17, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2393.24, -1646.03, 13.904),
(98, 25000, 3, 'Frei', 10, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2409.11, -1674.93, 14.375),
(99, 25000, 3, 'Frei', 10, 0, 1, 1, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 2413.94, -1646.79, 14.01),
(100, 27000, 3, 'Frei', 16, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2451.83, -1641.41, 14.064),
(101, 28000, 3, 'Frei', 17, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2469.54, -1646.35, 13.779),
(102, 62000, 5, 'Frei', 10, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2486.4, -1644.53, 14.076),
(103, 26000, 3, 'Frei', 12, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2498.5, -1642.26, 14.112),
(104, 27000, 3, 'Frei', 16, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2513.68, -1650.21, 14.354),
(105, 27000, 3, 'Frei', 4, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2524.71, -1658.54, 15.824),
(106, 26000, 3, 'Frei', 3, 0, 1, 1, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 2523.27, -1679.4, 15.496),
(107, 26000, 3, 'Frei', 15, 3, 3, 0, 100, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500, 1, 1, 1, 2514.3, -1691.64, 14.045),
(108, 60000, 3, 'Frei', 14, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 2495.32, -1691.06, 14.765),
(109, 25000, 3, 'Frei', 10, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2459.54, -1691.66, 13.543),
(110, 26000, 3, 'Frei', 12, 1, 1, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 80, 0, 1, 0, 2385.43, -1711.66, 14.241),
(111, 25000, 3, 'Frei', 10, 1, 1, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 200, 0, 1, 0, 2326.78, -1716.7, 14.237),
(112, 28000, 3, 'Frei', 17, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2308.92, -1714.33, 14.979),
(113, 28000, 3, 'Frei', 17, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2308.92, -1714.33, 14.979),
(114, 200000, 5, 'Frei', 2, 0, 5, 1, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1095.01, -647.914, 113.648),
(115, 57000, 5, 'Frei', 12, 0, 4, 0, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 989.817, -828.645, 95.468),
(116, 58000, 5, 'Frei', 13, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3594.97, -1873.88, 12.984),
(117, 62000, 5, 'Frei', 10, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3619.97, -1873.89, 12.984),
(118, 61000, 5, 'Frei', 14, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3644.89, -1873.9, 12.984),
(119, 58000, 5, 'Frei', 13, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3681.71, -1912.8, 12.461),
(120, 55000, 5, 'Frei', 4, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3689.49, -1944.92, 12.446),
(121, 61000, 5, 'Frei', 8, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3681.61, -1962.81, 12.461),
(122, 57000, 5, 'Frei', 12, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3689.49, -1994.9, 12.446),
(123, 57000, 5, 'Frei', 12, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3643.59, -1955.33, 12.984),
(124, 60000, 5, 'Frei', 3, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3643.71, -1930.35, 12.984),
(125, 58000, 5, 'Frei', 6, 1, 4, 1, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2500, 0, 1, 0, 724.835, -999.455, 52.734),
(126, 58000, 5, 'Frei', 6, 0, 4, 1, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 700.273, -1060.3, 49.421),
(127, 62000, 5, 'Frei', 10, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 612.218, -1085.89, 58.826),
(128, 55000, 5, 'Frei', 4, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 552.947, -1200.28, 44.831),
(129, 57000, 5, 'Frei', 2, 0, 4, 0, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 432.13, -1253.93, 51.58),
(130, 1000000, 9, 'Frei', 3, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 298.859, -1338.49, 53.441),
(131, 1000000, 9, 'Frei', 1, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 254.41, -1367.17, 53.109),
(132, 55000, 5, 'Frei', 4, 0, 3, 1, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 227.998, -1405.46, 51.609),
(133, 57000, 5, 'Frei', 12, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 142.621, -1470.36, 25.208),
(134, 1000000, 9, 'Frei', 1, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 189.636, -1308.18, 70.249),
(135, 1000000, 9, 'Frei', 1, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 219.218, -1249.81, 78.333),
(136, 61000, 5, 'Frei', 11, 0, 3, 0, 200, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 253.231, -1269.98, 74.43),
(137, 1000000, 9, 'Frei', 1, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 251.475, -1220.18, 76.097),
(138, 1000000, 9, 'Frei', 2, 2, 10, 0, 150, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 550, 0, 1, 0, 300.26, -1154.47, 81.388),
(139, 65000, 5, 'Frei', 7, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 352.388, -1197.95, 76.513),
(140, 57000, 5, 'Frei', 12, 1, 4, 0, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 1, 0, 416.716, -1154.09, 76.68),
(141, 57000, 5, 'Frei', 12, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 470.717, -1163.57, 67.217),
(142, 58000, 5, 'Frei', 6, 1, 4, 0, 200, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 850, 0, 1, 0, 559.161, -1076.38, 72.916),
(143, 1000000, 9, 'Frei', 1, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 497.359, -1095.07, 82.359),
(144, 25000, 3, 'Frei', 10, 1, 1, 0, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 179, 0, 1, 0, 168.348, -1768.4, 4.486),
(145, 25000, 3, 'Frei', 10, 1, 1, 0, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 192.783, -1769.4, 4.328),
(146, 27000, 3, 'Frei', 16, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 206.876, -1768.88, 4.368),
(147, 58000, 5, 'Frei', 6, 0, 4, 0, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 280.859, -1767.9, 4.532),
(148, 55000, 5, 'Frei', 4, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 893.606, -1635.7, 14.935),
(149, 60000, 5, 'Frei', 3, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 865.27, -1633.85, 14.928),
(150, 61000, 5, 'Frei', 8, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 878.023, -1514.64, 14.347),
(151, 58000, 5, 'Frei', 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 849.59, -1519.95, 14.347),
(152, 58000, 5, 'Frei', 11, 3, 4, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1311, 0, 1, 0, 822.439, -1505.52, 14.397),
(153, 61000, 5, 'Frei', 3, 1, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 841.338, -1471.36, 14.314),
(154, 125000, 8, 'Frei', 2, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1442.6, -628.83, 95.718),
(155, 125000, 8, 'Frei', 2, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1093.96, -807.127, 107.416),
(156, 125000, 8, 'Frei', 2, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 977.401, -771.713, 112.202),
(157, 125000, 8, 'Frei', 2, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 910.382, -817.552, 103.125),
(158, 25000, 3, 'Frei', 10, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2551.01, -1233.79, 49.331),
(159, 61000, 5, 'Frei', 2, 0, 3, 0, 1, 1000, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 31562713, 1, 1, 1, 900.544, -1470.95, 14.347),
(160, 55000, 5, 'Frei', 4, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 903.627, -1512.96, 14.366),
(161, 61000, 5, 'Frei', 14, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1863.78, -1597.28, 14.305),
(162, 61000, 5, 'Frei', 14, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1909.91, -1597.41, 14.305),
(163, 31000, 3, 'Frei', 5, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 2165.92, -1671.2, 15.071),
(164, 28000, 3, 'Frei', 17, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2165.52, -1590.48, 14.345),
(165, 28000, 3, 'Frei', 17, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2165.52, -1590.48, 14.345),
(166, 27000, 3, 'Frei', 16, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2150.41, -1583.96, 14.336),
(167, 27000, 3, 'Frei', 16, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2141.49, -1652.86, 15.085),
(168, 25000, 3, 'Frei', 10, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2129.21, -1663.85, 15.085),
(169, 26000, 3, 'Frei', 12, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2163.83, -1661.12, 15.085),
(170, 27000, 3, 'Frei', 16, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2151.44, -1672.23, 15.085),
(171, 25000, 3, 'Frei', 10, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2157.28, -1709.22, 15.085),
(172, 25000, 3, 'Frei', 10, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2140.49, -1708.31, 15.085),
(173, 26000, 3, 'Frei', 12, 0, 1, 0, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 2244.51, -1637.63, 16.236),
(174, 26000, 3, 'Frei', 12, 1, 1, 0, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 2257.11, -1643.94, 15.807),
(175, 28000, 3, 'Frei', 17, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2282.39, -1641.21, 15.887),
(176, 29000, 1, 'Frei', 2, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2066.74, -1656.47, 14.13),
(177, 29000, 3, 'Frei', 2, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2402.53, -1714.91, 14.13);



CREATE TABLE IF NOT EXISTS `iptables` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `IP` varchar(25) NOT NULL,
  `timest` bigint(20) NOT NULL,
  `Name` varchar(35) NOT NULL,
  `Reson` varchar(60) NOT NULL,
  `aName` varchar(35) NOT NULL DEFAULT 'Server',
  `Server` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;



CREATE TABLE IF NOT EXISTS `kontoauszug` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sender` varchar(26) NOT NULL,
  `empfaenger` varchar(26) NOT NULL,
  `grund` varchar(25) NOT NULL,
  `summe` int(5) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `int` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ;



CREATE TABLE IF NOT EXISTS `marktschreier` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `werbung1` varchar(90) NOT NULL,
  `werbung2` varchar(90) NOT NULL,
  `werbung3` varchar(90) NOT NULL,
  `werbung4` varchar(90) NOT NULL,
  `werbung5` varchar(90) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;



INSERT INTO `marktschreier` (`id`, `werbung1`, `werbung2`, `werbung3`, `werbung4`, `werbung5`) VALUES
(0, 'Freie Werbefläche!', '%e', '%e', '%e', '%e'),
(1, 'Freie Werbefläche!', 'Freie Werbefläche!', 'Freie Werbefläche!', 'Freie Werbefläche!', 'Freie Werbefläche!'),
(2, 'Freie Werbefläche!', 'Freie Werbefläche!', 'Freie Werbefläche!', 'Freie Werbefläche!', 'Freie Werbefläche!');



CREATE TABLE IF NOT EXISTS `multiaccounts` (
  `Name` varchar(24) NOT NULL,
  `Datum` date NOT NULL,
  `Uhrzeit` time NOT NULL,
  `Admin` varchar(24) NOT NULL,
  PRIMARY KEY (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



CREATE TABLE IF NOT EXISTS `namechanges` (
  `int` int(11) NOT NULL AUTO_INCREMENT,
  `oldName` varchar(26) NOT NULL,
  `newName` varchar(26) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`int`),
  UNIQUE KEY `int` (`int`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=136 ;



CREATE TABLE IF NOT EXISTS `polizeiakte` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(26) NOT NULL,
  `wantedanzahl` int(2) NOT NULL,
  `grund` varchar(26) NOT NULL,
  `von` varchar(26) NOT NULL,
  `zeit` varchar(10) NOT NULL,
  `datum` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;



CREATE TABLE IF NOT EXISTS `raenge` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rank1` varchar(64) NOT NULL,
  `rank2` varchar(64) NOT NULL,
  `rank3` varchar(64) NOT NULL,
  `rank4` varchar(64) NOT NULL,
  `rank5` varchar(64) NOT NULL,
  `rank6` varchar(64) NOT NULL,
  `rank7` varchar(64) NOT NULL,
  `rank8` varchar(64) NOT NULL,
  `rank9` varchar(64) NOT NULL,
  `rank10` varchar(64) NOT NULL,
  `rank11` varchar(64) NOT NULL,
  `rank12` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;



INSERT INTO `raenge` (`id`, `rank1`, `rank2`, `rank3`, `rank4`, `rank5`, `rank6`, `rank7`, `rank8`, `rank9`, `rank10`, `rank11`, `rank12`) VALUES
(0, '%e', '%e', '%e', '%e', '%e', '%e', '%e', '%e', '%e', '%e', '%e', '%e'),
(1, 'Trainee', 'Officer I', 'Officer II', 'Officer III', 'Detective I', 'Sergeant I', 'Detective II', 'Sergeant II', 'Lieutenant', 'Captain', 'Commander', 'Chief of Police'),
(2, 'Corporal', 'Sergeant', 'Staff Sergeant', 'Gunnery Sergeant', 'Master Sergeant', 'First Sergeant', 'Lieutnant', 'Commander', 'Captain', 'Major', 'Vice Admiral', 'Admiral'),
(3, 'Rettungsdiensthelfer', 'Rettungssanitäter', 'Lehrrettungsassistent', 'Rettungsassitent', 'Organisatorischer Leiter', 'Assistenzarzt', 'Notarzt', 'Betriebsarzt', 'Facharzt', 'Personalleiter', 'Oberarzt', 'Chefarzt'),
(4, 'Probefeuerwehrmann', 'Feuerwehrmann', 'Oberfeuerwehrmann', 'Hauptfeuerwehrmann', 'Löschmeister', 'Oberlöschmeister', 'Hauptlöschmeister', 'Brandmeister', 'Oberbrandmeister', 'Hauptbrandmeister', 'Hauptbrandleiter', 'Oberhauptbrandleiter'),
(5, 'Praktikant/in', 'Auszubildende/r', 'Geselle', 'Mitarbeiter/in', 'KFZ-Mechatroniker/in', 'KFZ-Meister/in', 'Abschlepp-Meister/in', 'Bestriebsrat/rätin', 'Oberbetriebsrat/rätin', 'Ausbilder', 'Vize-Firmenchef', 'Firmenchef'),
(6, 'Blutputzer', 'Beweisevernichter', 'Problemlöser', 'Wannabe-Killer', 'Blutsauger', 'Valküre', 'Attentäter', 'Meisterschütze', 'Massenmörder', 'Profikiller', 'Co-Leader', 'Leader'),
(7, 'Praktikant', 'Auszubildender Reporter', 'Lokaler Reporter', 'Lokaler Bearbeiter', 'Interner Parkwart', 'Kein Rang', 'Kein Rang', 'Praktikantenbetreuer', 'Ausbilder | Zeitungsersteller', 'Ausbilder | Eventleiter', 'Stellvertretender Geschäftsführer', 'Geschäftsführer'),
(8, 'Knecht', 'Homie', 'Brother', 'Assasine', 'Hustler', 'Smoker', 'Crack Nigga', 'Homeboy', 'Big Nigga', 'Legende', 'Co O.G', 'O.G.'),
(9, 'Laufbursche', 'Autopolierer', 'Fahrer', 'Dealer', 'Schläger', 'Vollstrecker', 'Soldat', 'Gangster', 'Homie', 'Ausbilder', 'Brother', 'Boss'),
(10, 'El nuevo', 'trepador', 'Marero', 'El Bate', 'Chófer', 'Recolector', 'traficante de drogas', 'Armero', 'Chulo', 'Izquierda', 'Derecho', 'El Diablo'),
(11, 'Anhänger | 1', 'Weakling | 2', 'Terrorist | 3', 'Specialist | 4', 'Third Terrorist | 5', 'Second Terrorist | 6', 'First Terrorist | 7', 'Terrorist Master | 8', 'Co-Ausbilder | 9', 'Ausbilder | 10', 'Co Leader | 11', 'Leader');



CREATE TABLE IF NOT EXISTS `userakte` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `adminid` int(11) NOT NULL,
  `action` varchar(60) NOT NULL,
  `reason` varchar(120) NOT NULL,
  `fromtype` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `weapons` (
  `Name` varchar(24) NOT NULL,
  `Waffen0` int(3) NOT NULL,
  `Waffen1` int(3) NOT NULL,
  `Waffen2` int(3) NOT NULL,
  `Waffen3` int(3) NOT NULL,
  `Waffen4` int(3) NOT NULL,
  `Waffen5` int(3) NOT NULL,
  `Waffen6` int(3) NOT NULL,
  `Waffen7` int(3) NOT NULL,
  `Waffen8` int(3) NOT NULL,
  `Waffen9` int(3) NOT NULL,
  `Waffen10` int(3) NOT NULL,
  `Waffen11` int(3) NOT NULL,
  `Waffen12` int(3) NOT NULL,
  `Ammo0` int(10) NOT NULL,
  `Ammo1` int(10) NOT NULL,
  `Ammo2` int(10) NOT NULL,
  `Ammo3` int(10) NOT NULL,
  `Ammo4` int(10) NOT NULL,
  `Ammo5` int(10) NOT NULL,
  `Ammo6` int(10) NOT NULL,
  `Ammo7` int(10) NOT NULL,
  `Ammo8` int(10) NOT NULL,
  `Ammo9` int(10) NOT NULL,
  `Ammo10` int(10) NOT NULL,
  `Ammo11` int(10) NOT NULL,
  `Ammo12` int(10) NOT NULL,
  PRIMARY KEY (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



CREATE TABLE IF NOT EXISTS `werbetafeln` (
  `id` int(3) NOT NULL,
  `text` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



INSERT INTO `werbetafeln` (`id`, `text`) VALUES
(0, 'Diese Werbetafel steht zur Vermietung frei!'),
(1, 'Diese Werbetafel steht zur Vermietung frei!'),
(2, 'Diese Werbetafel steht zur Vermietung frei!'),
(3, 'Diese Werbetafel steht zur Vermietung frei!'),
(4, 'Diese Werbetafel steht zur Vermietung frei!'),
(5, 'Diese Werbetafel steht zur Vermietung frei!'),
(6, 'Diese Werbetafel steht zur Vermietung frei!'),
(7, 'Diese Werbetafel steht zur Vermietung frei!'),
(8, 'Diese Werbetafel steht zur Vermietung frei!'),
(9, 'Diese Werbetafel steht zur Vermietung frei!'),
(10, 'Diese Werbetafel steht zur Vermietung frei!'),
(11, 'Diese Werbetafel steht zur Vermietung frei!'),
(12, 'Diese Werbetafel steht zur Vermietung frei!'),
(13, 'Diese Werbetafel steht zur Vermietung frei!'),
(14, 'Diese Werbetafel steht zur Vermietung frei!'),
(15, 'Diese Werbetafel steht zur Vermietung frei!'),
(16, 'Diese Werbetafel steht zur Vermietung frei!'),
(17, 'Diese Werbetafel steht zur Vermietung frei!'),
(18, 'Diese Werbetafel steht zur Vermietung frei!'),
(19, 'Diese Werbetafel steht zur Vermietung frei!'),
(20, 'Diese Werbetafel steht zur Vermietung frei!'),
(21, 'Diese Werbetafel steht zur Vermietung frei!'),
(22, 'Diese Werbetafel steht zur Vermietung frei!');



CREATE TABLE IF NOT EXISTS `wohnwagen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `inhaber` varchar(26) NOT NULL,
  `posx` double NOT NULL,
  `posy` double NOT NULL,
  `posz` double NOT NULL,
  `posa` double NOT NULL,
  `tuev` int(11) NOT NULL,
  `tank` int(3) NOT NULL,
  `leben` double(11,0) NOT NULL,
  `nitro` int(2) NOT NULL,
  `status` int(2) NOT NULL,
  `farbe1` int(2) NOT NULL,
  `farbe2` int(2) NOT NULL,
  `reifenk` int(2) NOT NULL,
  `reifene` int(2) NOT NULL,
  `motork` int(2) NOT NULL,
  `bremse` int(2) NOT NULL,
  `mats` int(4) NOT NULL,
  `drogen` int(4) NOT NULL,
  `eisen` int(11) NOT NULL,
  `waffe` int(2) NOT NULL,
  `ammo` int(2) NOT NULL,
  `waffe2` int(2) NOT NULL,
  `ammo2` int(2) NOT NULL,
  `waffe3` int(2) NOT NULL,
  `ammo3` int(2) NOT NULL,
  `batt` int(3) NOT NULL,
  `abgeschleppt` int(2) NOT NULL,
  `preis` int(3) NOT NULL,
  `grund` varchar(128) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;



CREATE TABLE IF NOT EXISTS `zeitung` (
  `zid` int(2) NOT NULL,
  `id` int(2) NOT NULL,
  `satz1` varchar(40) NOT NULL,
  `satz2` varchar(40) NOT NULL,
  `satz3` varchar(40) NOT NULL,
  `satz4` varchar(40) NOT NULL,
  `satz5` varchar(40) NOT NULL,
  `satz6` varchar(40) NOT NULL,
  `satz7` varchar(40) NOT NULL,
  `uschrift` varchar(40) NOT NULL,
  `datum` varchar(11) NOT NULL,
  `ersteller` varchar(26) NOT NULL,
  PRIMARY KEY (`zid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



INSERT INTO `zeitung` (`zid`, `id`, `satz1`, `satz2`, `satz3`, `satz4`, `satz5`, `satz6`, `satz7`, `uschrift`, `datum`, `ersteller`) VALUES
(0, 0, 'leer', 'leer', 'leer', 'leer', 'leer', 'leer', 'leer', 'leer', 'leer', 'leer');

CREATE TABLE IF NOT EXISTS `lohn` (
  `id` int(11) NOT NULL,
  `rank1` varchar(64) NOT NULL,
  `rank2` varchar(64) NOT NULL,
  `rank3` varchar(64) NOT NULL,
  `rank4` varchar(64) NOT NULL,
  `rank5` varchar(64) NOT NULL,
  `rank6` varchar(64) NOT NULL,
  `rank7` varchar(64) NOT NULL,
  `rank8` varchar(64) NOT NULL,
  `rank9` varchar(64) NOT NULL,
  `rank10` varchar(64) NOT NULL,
  `rank11` varchar(64) NOT NULL,
  `rank12` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;