SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

USE `ni77283_1_DB`;

CREATE TABLE IF NOT EXISTS `achievments` (
  `Name` varchar(50) NOT NULL,
  `SchlaflosInSA` varchar(50) NOT NULL DEFAULT '0',
  `Waffenschieber` varchar(50) NOT NULL DEFAULT '0',
  `Angler` varchar(50) NOT NULL DEFAULT '0',
  `Lizensen` varchar(50) NOT NULL DEFAULT '0',
  `Fahrzeugwahn` varchar(50) NOT NULL DEFAULT '0',
  `EigeneFueße` varchar(50) NOT NULL DEFAULT '0',
  `KingOfTheHill` varchar(50) NOT NULL DEFAULT '0',
  `ReallifeWTF` varchar(50) NOT NULL DEFAULT '0',
  `DerSammler` varchar(50) NOT NULL DEFAULT '0',
  `TheTruthIsOutThere` varchar(50) NOT NULL DEFAULT '0',
  `SilentAssasin` varchar(50) NOT NULL DEFAULT '0',
  `HighwayToHell` varchar(50) NOT NULL DEFAULT '0',
  `LookoutsA` varchar(20) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|',
  `Hufeisen` varchar(50) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|',
  `Revolverheld` int(1) NOT NULL DEFAULT '0',
  `ChickenDinner` int(1) NOT NULL DEFAULT '0',
  `NichtGehtMehr` int(1) NOT NULL DEFAULT '0',
  `highscore` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Name`),
  KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `ban` (
  `Name` varchar(50) NOT NULL,
  `Admin` varchar(50) NOT NULL,
  `Grund` varchar(50) NOT NULL,
  `Datum` varchar(50) NOT NULL,
  `IP` varchar(50) NOT NULL DEFAULT '0',
  `Serial` varchar(50) NOT NULL,
  `Eintragsdatum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `STime` int(11) NOT NULL DEFAULT '0',
  KEY `Name` (`Name`),
  KEY `IP` (`IP`),
  KEY `Serial` (`Serial`),
  KEY `STime` (`STime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `betakeys` (
  `Betakey` varchar(50) NOT NULL,
  `Name` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `biz` (
  `Biz` varchar(50) NOT NULL,
  `Inhaber` varchar(50) NOT NULL,
  `Kasse` int(11) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Preis` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `biz` (`Biz`, `Inhaber`, `Kasse`, `Name`, `Preis`) VALUES
('MistysBar', 'none', 111700, 'Mistys Bar', 350000),
('Sprunk', 'none', 246503, 'Sprunk Fabrik', 475000),
('WellStackedPizza', 'none', 43900, 'Well Stacked Pizza Co.', 500000),
('TankstellePine', 'none', 64432, 'Tankstelle Pine', 650000),
('TankstelleNord', 'none', 6601, 'Tankstelle North', 200000),
('Visage', 'none', 104547, 'Visage Hotel', 10000000),
('VankHoff', 'none', 2300, 'Vank Hoff Hotel', 3000000),
('PaynSprayJuniper', 'none', 0, 'Pay n Spray', 350000),
('TankstelleSued', 'none', 0, 'Tankstelle South', 750000),
('PaynSprayWangcars', 'none', 0, 'Pay n Spray', 250000);

CREATE TABLE IF NOT EXISTS `blacklist` (
  `Name` varchar(50) NOT NULL DEFAULT '',
  `Eintraeger` varchar(50) NOT NULL DEFAULT '',
  `Fraktion` int(2) NOT NULL,
  `Eintragungsdatum` int(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `blocks` (
  `Name` varchar(50) NOT NULL,
  `Punkte` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `bonustable` (
  `Name` varchar(50) NOT NULL,
  `Lungenvolumen` varchar(50) NOT NULL,
  `Muskeln` varchar(50) NOT NULL,
  `Kondition` varchar(50) NOT NULL,
  `Boxen` varchar(50) NOT NULL,
  `KungFu` varchar(50) NOT NULL,
  `Streetfighting` varchar(50) NOT NULL,
  `CurStyle` varchar(50) NOT NULL,
  `PistolenSkill` varchar(50) NOT NULL,
  `DeagleSkill` varchar(50) NOT NULL,
  `ShotgunSkill` varchar(50) NOT NULL,
  `AssaultSkill` varchar(50) NOT NULL,
  `Vortex` varchar(50) NOT NULL DEFAULT 'none',
  `MP5Skills` varchar(50) NOT NULL DEFAULT 'none',
  `Quad` varchar(50) NOT NULL DEFAULT 'none',
  `CarslotUpgrades` varchar(50) NOT NULL DEFAULT 'none',
  `PremiumUntilDay` int(50) NOT NULL DEFAULT '0',
  `PremiumUntilYear` varchar(50) NOT NULL DEFAULT '0',
  `BonusSkin1` varchar(50) NOT NULL DEFAULT 'none',
  `CarslotUpdate2` int(11) NOT NULL DEFAULT '0',
  `CarslotUpdate3` int(11) NOT NULL DEFAULT '0',
  `Skimmer` int(1) NOT NULL DEFAULT '0',
  `Leichenwagen` int(1) NOT NULL DEFAULT '0',
  `Schach` tinyint(1) NOT NULL DEFAULT '0',
  `Caddy` tinyint(1) NOT NULL DEFAULT '0',
  `fglass` tinyint(1) NOT NULL DEFAULT '0',
  `uzi` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Name`),
  KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `buyit` (
  `ID` int(50) NOT NULL,
  `Typ` varchar(50) NOT NULL,
  `Anbieter` varchar(50) NOT NULL,
  `Hoechstbietender` varchar(50) NOT NULL,
  `Hoechstgebot` int(50) NOT NULL,
  `LaeuftBis` int(50) NOT NULL,
  `Beschreibung` varchar(200) NOT NULL DEFAULT '',
  `OptischesDatum` varchar(50) NOT NULL,
  `Anzahl` varchar(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



CREATE TABLE IF NOT EXISTS `carhouses_icons` (
  `Name` varchar(50) NOT NULL,
  `ID` int(3) NOT NULL,
  `X` double NOT NULL,
  `Y` double NOT NULL,
  `Z` double NOT NULL,
  `SpawnX` float NOT NULL,
  `SpawnY` float NOT NULL,
  `SpawnZ` float NOT NULL,
  `SpawnRX` float NOT NULL,
  `SpawnRY` float NOT NULL,
  `SpawnRZ` float NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO `carhouses_icons` (`Name`, `ID`, `X`, `Y`, `Z`, `SpawnX`, `SpawnY`, `SpawnZ`, `SpawnRX`, `SpawnRY`, `SpawnRZ`) VALUES
('Otto''s Autos', 3, -1649.9169921875, 1209.8126220703, 7.25, -1637.07, 1208.94, 7.07969, 0, 0, 224),
('Wang Cars', 2, -1966.1179199219, 293.97113037109, 35.46875, -1932.04, 268.793, 41.1455, 0, 0, 180),
('San Fierro\nAirport', 1, -1544.4420166016, -440.82772827148, 6, -1224.29, -7.50679, 15.0342, 0, 0, 0),
('Bayside Boats', 4, -2185.0559082031, 2413.1411132813, 5.15625, -2215.62, 2438.35, 0, 0, 0, 314),
('Las Venturas\nAirport', 5, 1714.8116455078, 1616.1896972656, 10.09, 1346.85, 1341.25, 12.3362, 0, 0, 268),
('$HODY USED\nAUTOS', 6, 1689.0015869141, 1850.7039794922, 11.219537734985, 1692.42, 1865.62, 10.7203, 0, 0, 270),
('Auto Bahn', 7, 2200.86, 1394.32, 10.9, 2200.93, 1386.6, 10.55, 0, 0, 90),
('Bonusfahrzeuge\n( See )', 8, -911.11560058594, 2686.1909179688, 42.817291259766, -962.246, 2671.21, 40.3628, 0, 0, 135),
('Bonusfahrzeuge\n( Land )', 9, -902.84930419922, 2681.6420898438, 42.734336853027, -898.47, 2715.61, 45.9974, 0, 0, 97),
('Auto Bahn', 10, 1948.6752929688, 2068.84, 11.466958999634, 1940.2, 2068.54, 10.8203, 0, 0, 0),
('Kleinstadt-\\nhaendler', 11, -2088.97, -2262.41, 30.32, -2088.42, -2267.6, 30.5, 0, 0, 45);


CREATE TABLE IF NOT EXISTS `carhouses_vehicles` (
  `AutohausID` int(50) NOT NULL,
  `X` double NOT NULL,
  `Y` double NOT NULL,
  `Z` double NOT NULL,
  `RX` double NOT NULL,
  `RY` double NOT NULL,
  `RZ` double NOT NULL,
  `Preis` int(11) NOT NULL,
  `Typ` int(50) NOT NULL,
  `Info` varchar(50) NOT NULL,
  `Comment` varchar(999) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO `carhouses_vehicles` (`AutohausID`, `X`, `Y`, `Z`, `RX`, `RY`, `RZ`, `Preis`, `Typ`, `Info`, `Comment`) VALUES
(1, -1188.5283203125, 32.646484375, 15.034187316895, 0, 0, 0, 129000, 568, 'Helikoper mit\n2 Sitzplaetzen', 'Raindance'),
(1, -1187.7210693359, 15.780174255371, 14.24843788147, 0, 0, 16, 31900, 469, 'Helikoper mit\n2 Sitzplaetzen', 'Sparrow'),
(1, -1175.3992919922, 29.118057250977, 14.413437843323, 0, 0, 50, 74900, 487, 'Helikoper mit\n4 Sitzplaetzen', 'Maverick'),
(2, -1949.3812255859, 263.57504272461, 40.867080688477, 0, 0, 68, 12900, 426, 'Viertuerer', 'Premier'),
(2, -1948.7930908203, 272.47186279297, 41.003414154053, 0, 0, 106, 7500, 507, 'Viertuerer', 'Elegant'),
(2, -1956.0469970703, 291.77319335938, 40.877082824707, 0, 0, 130, 11500, 404, 'Viertuerer', 'Perennial'),
(2, -1959.2907714844, 258.83361816406, 35.168510437012, 0, 0, 18, 1800, 581, 'Motorrad', 'BF-400'),
(2, -1949.6003417969, 261.25247192383, 35.330226898193, 0, 0, 26, 1200, 549, 'Billigkarre', 'Tampa'),
(2, -1948.7517089844, 270.49761962891, 35.423927307129, 0, 0, 112, 14500, 412, 'Viertuerer', 'Vodoo'),
(2, -1956.056640625, 296.3076171875, 35.567386627197, 0, 0, 132, 17800, 579, 'SUV', 'Huntley'),
(3, -1660.5234375, 1213.8901367188, 6.9103775024414, 0, 0, 326, 32500, 522, 'Rennmotorad', 'NRG-500'),
(3, -1654.2049560547, 1213.8233642578, 13.371874809265, 0, 0, 14, 47900, 541, 'Sportwagen', 'Bullet'),
(3, -1660.8762207031, 1216.0104980469, 13.463988304138, 0, 0, 332, 42500, 506, 'Sportwagen', 'Super GT'),
(3, -1673.5727539063, 1206.7923583984, 21.005771636963, 0, 0, 248, 48900, 415, 'Sportwagen', 'Cheetah'),
(3, -1657, 1211, 7.04, 0, 0, 318, 84900, 411, 'Sportwagen', 'Infernus'),
(3, -1650.2810058594, 1208.2152099609, 20.898662567139, 0, 0, 10.25, 54900, 429, 'Sportcabrio', 'Banshee'),
(3, -1663.4768066406, 1219.8461914063, 20.966249465942, 0, 0, 250, 39500, 587, 'Sportwagen', 'Euros'),
(4, -2213.1484375, 2411.6689453125, 0, 0, 0, 42, 179900, 484, 'Segelyacht\n( Mit Koje )', 'Marquis'),
(4, -2223.1516113281, 2400.8994140625, 0, 0, 0, 46, 129900, 454, 'Motoryacht\n( Mit Koje )', 'Tropic'),
(4, -2231.357421875, 2390.7587890625, 0, 0, 0, 44, 27900, 446, 'Speedboot', 'Squalo'),
(4, -2258.015691406, 2419.2734375, 0, 0, 0, 224, 19900, 452, 'Speedboot', 'Speeder'),
(4, -2249.8605957031, 2423.9106445313, 0, 0, 0, 224, 7900, 473, 'Schlauchboot', 'Dinghy'),
(4, -2239.6242675781, 2440.6728515625, 0, 0, 0, 226, 42500, 493, 'Speedboot', 'Jetmax'),
(5, 1296.4821777344, 1324.9904785156, 11.370494842529, 0, 0, 270, 32500, 593, 'Propeller-\nmaschiene\n(2 Sitzplaetze)', 'Dodo'),
(5, 1295.6755371094, 1361.3303222656, 12.271298408508, 12, 0, 270, 54900, 553, 'Alte Propeller-\nmaschiene', 'Nevada'),
(5, 1291.8493652344, 1389.7900390625, 11.820384979248, 0, 0, 270, 149900, 519, 'Privatjet', 'Shamal'),
(5, 1296.9296875, 1340.884765625, 11.605069160461, 0, 0, 270, 34900, 513, 'Stuntflugzeug', 'Stuntplane'),
(5, 1350.5347900391, 1281.189453125, 12.336210250854, 0, 0, 0, 24900, 511, 'Propellerflug-\nzeug ( 2 Sitze )', 'Beagle'),
(6, 1728.9261474609, 2019.6724853516, 10.690312385559, 0, 0, 90, 17950, 467, 'Viertuerer', 'Oceanic'),
(6, 1728.9013671875, 2009.2183837891, 10.82, 0, 0, 90, 74950, 603, 'Muscle-Car', 'Phoenix'),
(6, 1728.9013671875, 2003, 10.72, 0, 0, 90, 21000, 475, 'Muscle-Car', 'Sabre'),
(6, 1728.2746582031, 1991.4293212891, 10.96, 0, 0, 90, 84000, 434, 'Hotrod', 'Hotknife'),
(6, 1729, 1985.2177734375, 10.75, 0, 0, 90, 49000, 419, 'Lowrider', 'Esperanto'),
(6, 1729.08, 1979.41, 10.667, 0, 0, 90, 26000, 424, 'Strandbuggy', 'BF Injection'),
(6, 1742.11, 2019.2, 10.49, 0, 0, 0, 490, 462, 'Roller', 'Faggio'),
(6, 1744.46, 2013.42, 10.77, 0, 0, 90, 15000, 412, 'Lowrider', 'Voodoo'),
(6, 1744, 2006.88, 10.57, 0, 0, 90, 35000, 559, 'Muscle-Car', 'Jester'),
(6, 1745.725, 1993.88, 10.6, 0, 0, 90, 54500, 555, 'Cabrio', 'Windsor'),
(6, 1746.39, 1985.35, 11.18, 0, 0, 90, 28750, 489, 'Jeep', 'Rancher'),
(7, 2148.72, 1397.41, 10.75, 0, 0, 0, 47800, 402, 'Sportwagen', 'Buffalo'),
(6, 1745.65, 1972.61, 10.51, 0, 0, 90, 34500, 565, 'Zweituerer', 'Flash'),
(7, 2142.47, 1395.71, 10.75, 0, 0, 0, 89500, 409, 'Limousine', 'Stretch'),
(7, 2139.501953125, 1396.9553222656, 10.76, 0, 0, 0, 19500, 545, 'Muscle-Car', 'Hustler'),
(7, 2132.72, 1396.93, 10.79, 0, 0, 0, 24500, 568, 'Buggy', 'Bandito'),
(7, 2126.37, 1397.1, 10.73, 0, 0, 0, 45000, 561, 'SUV', 'Stratum'),
(7, 2120.1, 1397.43, 10.61, 0, 0, 0, 43000, 560, 'Viertuerer', 'Sultan'),
(7, 2123.05, 1397.17, 10.65, 0, 0, 0, 24950, 535, 'Lowrider', 'Slamvan'),
(7, 2113.57, 1397.91, 10.58, 0, 0, 0, 17800, 468, 'Cross\nMotorad', 'Sanchez'),
(7, 2148.62, 1409.58, 10.74, 0, 0, 180, 27850, 550, 'Vierteurer', 'Sunrise'),
(7, 2139.1, 1410.19, 10.53, 0, 0, 180, 19500, 589, 'Zweituerer', 'Club'),
(7, 2132.6291503906, 1409.98, 10.67, 0, 0, 180, 29800, 536, 'Lowrider-\nCabrio', 'Blade'),
(7, 2129.5183105, 1411.01, 10.72, 0, 0, 180, 12500, 479, 'SUV', 'Regina'),
(8, -942.18560791016, 2648.8591308594, 42.386817932129, 0, 0, 135, 74500, 460, 'Wasserflug-\nzeug', 'Skimmer'),
(8, -912.12268066406, 2695.1982421875, 42.017189025879, 0, 0, 135, 45000, 539, 'Hovercraft', 'Vortex'),
(9, -887.50402832031, 2697.2333984375, 41.945262908936, 0, 0, 315, 24500, 471, 'Quad', 'Quadbike'),
(9, -893.67626953125, 2700.0336914063, 42.320129394531, 0, 0, 315, 39500, 442, 'Leichen-\nwagen', 'Romero'),
(9, -902.78149414063, 2699.6669921875, 42.096534729004, 0, 0, 0, 23500, 457, 'Golf-\nwagen', 'Caddy'),
(10, 1994.6566162109, 2059.0798339844, 10.62031269, 0, 0, 0, 37500, 533, 'Cabrio', 'Feltzer'),
(10, 1991.0211181641, 2058.85, 10.57, 0, 0, 0, 64780, 562, 'Sportwagen', 'Elegy'),
(10, 1987.41, 2058.85, 10.72, 0, 0, 0, 24000, 491, 'Zweituerer', 'Virgo'),
(10, 1983.7, 2058.7, 10.79, 0, 0, 0, 32700, 567, 'Lowrider', 'Savanna'),
(10, 1979.65, 2058.69, 10.52, 0, 0, 0, 80000, 541, 'Sportwagen', 'Bullet'),
(10, 1994.71, 2035.77, 10.8, 0, 0, 180, 34500, 445, 'Viertuerer', 'Admiral'),
(10, 1990.63, 2035.77, 10.94, 0, 0, 180, 47500, 400, 'Jeep', 'Landstalker'),
(10, 1986.39, 2036.29, 10.68, 0, 0, 180, 24000, 401, 'Zweituerer', 'Bravura'),
(10, 1982.29, 2035.91, 10.51, 0, 0, 180, 65000, 558, 'Sportwagen', 'Uranus'),
(11, -2089.78, -2242.6, 30.82, 359, 359, 45, 11950, 543, 'Pickup', 'Sadler'),
(11, -2098.32, -2255, 30.7, 0, 0, 0, 9500, 478, 'Pickup', 'Walton'),
(11, -2112.39, -2241.16, 30.4, 0, 0, 0, 19500, 518, 'Zweitruerer', 'Buccaneer'),
(11, -2099.4, -2225.87, 30.46, 0, 0, 45, 2900, 542, 'Zweitruerer', 'Clover');



CREATE TABLE IF NOT EXISTS `cars_ai` (
  `ID` int(11) NOT NULL,
  `Model` int(11) NOT NULL,
  `Preis` int(11) NOT NULL,
  `Name` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `cars_ai` (`ID`, `Model`, `Preis`, `Name`) VALUES
(1, 496, 28000, 'Blista Compact'),
(2, 580, 175000, 'Stafford'),
(3, 534, 54500, 'Remington'),
(4, 480, 95000, 'Comet'),
(5, 451, 249500, 'Tourismo'),
(6, 558, 124500, 'Uranus'),
(7, 477, 249500, 'ZR-350'),
(8, 521, 79500, 'FRC-900');


CREATE TABLE IF NOT EXISTS `cars_peds_ai` (
  `ID` int(11) NOT NULL,
  `VehX` float NOT NULL,
  `VehY` float NOT NULL,
  `VehZ` float NOT NULL,
  `VehRX` float NOT NULL,
  `VehRY` float NOT NULL,
  `VehRZ` float NOT NULL,
  `PedX` float NOT NULL,
  `PedY` float NOT NULL,
  `PedZ` float NOT NULL,
  `PedR` float NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



INSERT INTO `cars_peds_ai` (`ID`, `VehX`, `VehY`, `VehZ`, `VehRX`, `VehRY`, `VehRZ`, `PedX`, `PedY`, `PedZ`, `PedR`) VALUES
(1, -2099.44, -9.94, 35.32, 0, 0, 260, -2099.93, -11.63, 34.32, 190),
(2, -2693.58, 1228.74, 55.56, 0, 0, 0, -2691.69, 1227.19, 54.56, 220),
(3, -2804.4, -252.72, 7.17, 0, 0, 0, -2805.06, -249.59, 6.03, 0),
(4, -1446.24, 920.05, 7.18, 0, 0, 0, -1444.79, 919.6, 6.18, 270),
(5, -1959.31, 1227.51, 31.64, 0, 0, 18, -1958.05, 1227.93, 30.64, 285),
(6, -2706.82, 1304.78, 7.04, 0, 0, 190, -2705.09, 1304.53, 6.05, 240);



CREATE TABLE IF NOT EXISTS `email` (
  `Empfaenger` varchar(50) NOT NULL,
  `Text` varchar(500) NOT NULL,
  `Yearday` int(11) NOT NULL,
  `Year` int(11) NOT NULL,
  KEY `Empfaenger` (`Empfaenger`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



CREATE TABLE IF NOT EXISTS `fraktionen` (
  `Name` varchar(50) NOT NULL,
  `ID` int(50) NOT NULL,
  `FKasse` varchar(50) NOT NULL,
  `DepotGeld` varchar(50) NOT NULL DEFAULT '0',
  `DepotDrogen` varchar(50) NOT NULL DEFAULT '0',
  `DepotMaterials` varchar(50) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO `fraktionen` (`Name`, `ID`, `FKasse`, `DepotGeld`, `DepotDrogen`, `DepotMaterials`) VALUES
('Mafia', 2, '0', '0', '0', '0'),
('SFPD', 1, '0', '0', '0', '0'),
('Triaden', 3, '0', '0', '0', '0'),
('Terroristen', 4, '0', '0', '0', '0'),
('Reporter', 5, '0', '0', '0', '0'),
('FBI', 6, '0', '0', '0', '0'),
('Aztecas', 7, '0', '0', '0', '0'),
('Biker', 9, '0', '0', '0', '0');


CREATE TABLE IF NOT EXISTS `fraktionswaffen` (
  `Fraktion` varchar(50) NOT NULL,
  `ID` varchar(50) NOT NULL,
  `Schlagringe` int(11) NOT NULL,
  `Baseballschlaeger` int(11) NOT NULL,
  `Messer` int(11) NOT NULL,
  `Schaufeln` int(11) NOT NULL,
  `Pistolen` int(11) NOT NULL,
  `SDPistolen` int(11) NOT NULL,
  `PistolenMagazine` int(11) NOT NULL,
  `DesertEagles` int(11) NOT NULL,
  `DesertEagleMunition` int(11) NOT NULL,
  `Schrotflinten` int(11) NOT NULL,
  `SchrotflintenMunition` int(11) NOT NULL,
  `MP` int(11) NOT NULL,
  `MPMunition` int(11) NOT NULL,
  `AK` int(11) NOT NULL,
  `AKMunition` int(11) NOT NULL,
  `M` int(11) NOT NULL,
  `MMunition` int(11) NOT NULL,
  `Gewehre` int(11) NOT NULL,
  `GewehrPatronen` int(11) NOT NULL,
  `SGewehr` int(11) NOT NULL,
  `SGewehrMunition` int(11) NOT NULL,
  `Raketenwerfer` int(11) NOT NULL,
  `Raketen` int(11) NOT NULL,
  `Spezwaffen` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO `fraktionswaffen` (`Fraktion`, `ID`, `Schlagringe`, `Baseballschlaeger`, `Messer`, `Schaufeln`, `Pistolen`, `SDPistolen`, `PistolenMagazine`, `DesertEagles`, `DesertEagleMunition`, `Schrotflinten`, `SchrotflintenMunition`, `MP`, `MPMunition`, `AK`, `AKMunition`, `M`, `MMunition`, `Gewehre`, `GewehrPatronen`, `SGewehr`, `SGewehrMunition`, `Raketenwerfer`, `Raketen`, `Spezwaffen`) VALUES
('Mafia', '2', 20, 20, 15, 10, 35, 10, 125, 5, 50, 15, 1106, 18, 38, 7, 20, 5, 15, 10, 150, 1, 24, 3, 10, 7),
('SFPD', '1', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('Triaden', '3', 20, 19, 15, 9, 34, 10, 122, 1, 28, 4, 535, 15, 32, 7, 20, 5, 11, 7, 31, 2, 46, 1, 0, 7),
('Aztecas', '7', 20, 19, 14, 10, 34, 10, 125, 5, 50, 14, 1102, 18, 37, 7, 20, 5, 13, 10, 100, 3, 29, 2, 0, 0),
('Terroristen', '4', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('Reporter', '5', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);



CREATE TABLE IF NOT EXISTS `gang_basic` (
  `Name` varchar(50) NOT NULL DEFAULT 'Def. Gang',
  `LeaderMSG` varchar(50) NOT NULL DEFAULT '',
  `Waffe` int(2) NOT NULL DEFAULT '0',
  `Skin` int(3) NOT NULL DEFAULT '7',
  `HausID` int(4) NOT NULL DEFAULT '0',
  `Rang1` varchar(50) NOT NULL DEFAULT 'Anfaenger',
  `Rang2` varchar(50) NOT NULL DEFAULT 'Mitglied',
  `Rang3` varchar(50) NOT NULL DEFAULT 'Anfuehrer',
  `MaxMembers` int(4) NOT NULL DEFAULT '8',
  `Drugs` int(10) NOT NULL DEFAULT '0',
  `Mats` int(10) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



CREATE TABLE IF NOT EXISTS `gang_members` (
  `Name` varchar(50) NOT NULL,
  `Gang` int(4) NOT NULL DEFAULT '0',
  `Rang` int(2) NOT NULL DEFAULT '1',
  `Founder` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `gang_vehicles` (
  `GangID` int(4) NOT NULL,
  `Typ` int(3) NOT NULL DEFAULT '500',
  `Tuning` varchar(50) NOT NULL DEFAULT '|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|',
  `Spawnpos_X` double NOT NULL DEFAULT '0',
  `Spawnpos_Y` double NOT NULL DEFAULT '0',
  `Spawnpos_Z` double NOT NULL DEFAULT '0',
  `Spawnrot_X` double NOT NULL DEFAULT '0',
  `Spawnrot_Y` double NOT NULL DEFAULT '0',
  `Spawnrot_Z` double NOT NULL DEFAULT '0',
  `Farbe` varchar(50) NOT NULL DEFAULT '|0|0|0|0|',
  `Paintjob` int(4) NOT NULL DEFAULT '0',
  `Lights` varchar(13) NOT NULL DEFAULT '|255|255|255|'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `gangs` (
  `X1` varchar(50) NOT NULL,
  `Y1` varchar(50) NOT NULL,
  `X2` varchar(50) NOT NULL,
  `Y2` varchar(50) NOT NULL,
  `X3` varchar(50) NOT NULL,
  `Y3` varchar(50) NOT NULL,
  `Z3` varchar(50) NOT NULL,
  `BesitzerFraktion` int(2) NOT NULL,
  `Einnahmen` int(5) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Nummer` int(2) NOT NULL,
  `LastAttacked` int(20) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

ALTER TABLE `gangs` CHANGE `LastAttacked` `LastAttacked` TIMESTAMP NOT NULL DEFAULT 0;

INSERT INTO `gangs` (`X1`, `Y1`, `X2`, `Y2`, `X3`, `Y3`, `Z3`, `BesitzerFraktion`, `Einnahmen`, `Name`, `Nummer`, `LastAttacked`) VALUES
('-2758.99', '1310.52', '-2573.75', '1528.54', '-2631.68', '1357.41', '6.75', 7, 6, 'Pleasure Domes Club', 1, 58652581),
('-2361.49', '-183.31', ' -2269.87', '-80.65', '-2308.15', '-123.21', '34.96', 7, 6, 'Burgershot', 2, 58652696),
('-2201.72', '-280.57', '-2096.76', '-80.93', '-2136.24', '-181.63', '34.96', 3, 6, 'Fabrikgel�nde', 3, 58652535),
('-2215.40', '-950.06', '-2025', '-700', '-2115.4033203125', '-893.06', '31.67', 7, 6, 'Universit�t', 4, 58652362),
('-2811.12', '-413.97', '-2634.36', '-261.18', '-2719.86', '-317.43', '7.5', 3, 6, 'Golfclub', 5, 58652171),
('-2293.56', '2226.63', '-2237.42', '2473.87', '-2261.91', '2317.41', '4.46', 7, 6, 'Bayside', 6, 58651342),
('-87.404563903809', '2420.3674316406', '458.44122314453', '2575.6437988281', '414.26818847656', '2528.28906253', '16.25', 7, 6, 'Verdannt Medows', 7, 58652811),
('-1494.2794189453', '1434.4106445313', '-1336.6267089844', '1531.5936279297', '-1376.3942871094', '1491.3725585938', '10.8523', 7, 6, 'Schiff ( Flach )', 8, 58651986),
('2502.08', '2714.93', '2576.66', '2790.27', '2546.65', '2753.65', '11.20', 7, 6, 'KAK', 11, 58652757),
('1858.28', '1473.03', '2010.69', '1691.0', '1908.77', '1518.43', '13.62', 7, 6, 'Piratenschiff', 10, 58652155),
('1296.96', '2100.37', '1416.82', '2219.80', '1344.46', '2148.45', '10.66', 7, 6, 'Baseballstadion', 9, 58652720);

CREATE TABLE IF NOT EXISTS `gunlicense` (
  `Name` varchar(50) NOT NULL,
  `Time` int(20) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `houses` (
  `ID` int(11) NOT NULL,
  `SymbolX` double NOT NULL,
  `SymbolY` double NOT NULL,
  `SymbolZ` double NOT NULL,
  `Besitzer` varchar(50) NOT NULL,
  `Preis` int(11) NOT NULL,
  `Mindestzeit` int(11) NOT NULL,
  `CurrentInterior` int(11) NOT NULL,
  `Kasse` int(11) NOT NULL,
  `Miete` int(11) NOT NULL,
  KEY `Besitzer` (`Besitzer`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `houses` (`ID`, `SymbolX`, `SymbolY`, `SymbolZ`, `Besitzer`, `Preis`, `Mindestzeit`, `CurrentInterior`, `Kasse`, `Miete`) VALUES
(32, -2661.0751953125, 877.8896484375, 79.773796081543, 'none', 150000, 70, 30, 3231, 50),
(31, -2872.4599609375, 697.58203125, 23.462213516235, 'none', 100000, 35, 2, 0, 500),
(29, -2723.640625, -191.298828125, 4.3359375, 'none', 70000, 45, 13, 2799, 0),
(28, -2356.818359375, 579.708984375, 24.890625, 'none', 110000, 55, 11, 7767, 29),
(27, -2369.2265625, 763.5888671875, 35.125843048096, 'none', 100000, 50, 7, 8400, 100),
(26, -2689.591796875, -152.7783203125, 5, 'none', 150000, 50, 3, 1200, 100),
(25, -2099.66796875, 898.1171875, 76.7109375, 'none', 220000, 70, 13, 300, 50),
(24, -2552.044921875, 2266.572265625, 5.4755249023438, 'none', 195000, 60, 9, 7450, 50),
(23, -2630.919921875, 252.572265625, 7.1875, 'none', 80000, 40, 1, 4950, 50),
(22, -2895.115234375, 1016.96484375, 36.828125, 'none', 180000, 70, 8, 6275, 25),
(19, -2583.1669921875, 2307.884765625, 7.0028858184814, 'none', 170000, 90, 14, 0, 0),
(20, -2864.5869140625, 681.666015625, 23.465063095093, 'none', 180000, 60, 2, 1300, 10),
(21, -2839.8779296875, 877.3486328125, 44.0546875, 'none', 160000, 65, 4, 38, 500),
(15, -2479.6640625, 2449.3017578125, 17.323022842407, 'none', 195000, 100, 10, 275, 0),
(16, -2581.072265625, 919.787109375, 64.984375, 'none', 90000, 50, 8, 330, 30),
(17, -2421.43359375, 2406.7001953125, 13.025882720947, 'none', 300000, 100, 6, 0, 15),
(18, -2582.8408203125, 2299.9580078125, 7.0028858184814, 'none', 150000, 90, 15, 1462, 0),
(14, -2555.97265625, 896.845703125, 64.984375, 'none', 80000, 35, 7, 340, 20),
(13, -2301.814453125, 579.76171875, 34.409286499023, 'none', 120000, 50, 5, 7225, 35),
(12, -2027.6943359375, -41.05078125, 38.8046875, 'none', 100000, 40, 6, 1910, 25),
(11, -2472.2802734375, 2450.8505859375, 17.323022842407, 'none', 195000, 90, 9, 0, 0),
(10, -2665.1240234375, 916.0771484375, 79.678031921387, 'none', 250000, 100, 30, 5950, 30),
(9, -2348.458984375, 2423.23828125, 7.3348751068115, 'none', 220000, 90, 10, 40, 40),
(8, -2641.1650390625, 935.52734375, 71.953125, 'none', 250000, 80, 15, 2100, 50),
(7, -2359.0400390625, 1117.685546875, 55.7265625, 'none', 75000, 20, 2, 220, 5),
(6, -2407.0068359375, 1135.2578125, 55.7265625, 'none', 75000, 20, 2, 0, 10),
(5, -2379.4833984375, 2443.87890625, 10.169355392456, 'none', 350000, 120, 5, 2938, 100),
(4, -2451.2646484375, 1141.4755859375, 55.733276367188, 'none', 75000, 20, 2, 5190, 30),
(1, -2523.39453125, 2239.77734375, 5.3425970077515, 'none', 200000, 60, 3, 7650, 50),
(2, -2534.478515625, 1143.5869140625, 55.7265625, 'none', 75000, 20, 2, 1437, 1),
(3, -2493.4921875, 1141.7685546875, 55.7265625, 'none', 75000, 20, 2, 1000, 50),
(36, -2075.1003417969, 1377.3017578125, 7.5927696228027, 'none', 250000, 150, 28, 0, 0),
(37, -2071.7817382812, 1414.2403564453, 7.7502980232239, 'none', 250000, 125, 28, 0, 0),
(44, -805.970703125, 2426.783203125, 157.47073364258, 'none', 150000, 350, 1, 79, 1),
(50, -2793.0634765625, -152.998046875, 7.4753980636597, 'none', 70000, 35, 1, 2945, 50),
(41, -2721.2294921875, 924.150390625, 67.59375, 'none', 100000, 60, 3, 602, 0),
(43, 300.162109375, -1154.5751953125, 81.326240539551, 'none', 450000, 600, 10, 0, 0),
(45, -1060.205078125, -1205.474609375, 129.21875, 'none', 150000, 100, 30, 480, 80),
(52, -2437.4462890625, 2354.939453125, 5.4430656433105, 'none', 115000, 65, 5, 4, 75),
(42, -2657.4130859375, 849.0166015625, 64.0078125, 'none', 250000, 130, 13, 0, 100),
(56, -2792.251953125, 218.5634765625, 7.859375, 'none', 125000, 35, 1, 9125, 50),
(35, -2793.26953125, 111.0126953125, 7.1875, 'none', 75000, 30, 1, 2500, 100),
(39, -2792.83984375, 84.9541015625, 7.630811214447, 'none', 75000, 30, 1, 3350, 100),
(46, -2792.056640625, 130.751953125, 7.859375, 'none', 125000, 35, 1, 0, 100),
(54, -2075.228515625, 899.9150390625, 64.1328125, 'none', 75000, 50, 6, 6150, 15),
(40, -2710.564453125, 968.0625, 54.4609375, 'none', 350000, 120, 12, 300, 300),
(57, -2883.3447265625, 736.6318359375, 29.237142562866, 'none', 150000, 50, 3, 875, 10),
(58, -2880.099609375, 797.4208984375, 35.355754852295, 'none', 160000, 75, 3, 320, 100),
(59, -2881.8916015625, 779.8935546875, 35.142761230469, 'none', 160000, 75, 3, 2712, 80),
(60, -2655.046875, 986.509765625, 64.991287231445, 'none', 380000, 120, 13, 100, 0),
(61, -2863.220703125, 829.54296875, 39.577255249023, 'none', 175000, 75, 5, 50, 50),
(62, -2477.296875, 1338.193359375, 8.5038833618164, 'none', 125000, 50, 6, 0, 15),
(64, -2477.4697265625, 1264.3095703125, 28.25, 'none', 125000, 50, 6, 8386, 10),
(65, -2477.2197265625, 1301.072265625, 18.375, 'none', 0, 50, 6, 4370, 5),
(66, -1438.77734375, -1544.607421875, 102.1637878418, 'none', 550000, 140, 6, 0, 500),
(67, -2476.845703125, 1281.5712890625, 23.7265625, 'none', 82000, 60, 9, 60, 20),
(68, -2219.982421875, -2400.20703125, 32.58226776123, 'none', 125000, 60, 25, 820, 80),
(69, -2239.103515625, -2423.9365234375, 32.70726776123, 'none', 125000, 60, 25, 0, 80),
(70, -2687.5966796875, 115.74609375, 7.082070350647, 'none', 100000, 65, 5, 15, 15),
(71, -384.537109375, -1438.8896484375, 26.3203125, 'none', 600000, 90, 5, 0, 0),
(72, -2686.8212890625, -187.9580078125, 7.203125, 'none', 70000, 50, 11, 536, 0),
(73, -348.0361328125, -1046.10546875, 59.8125, 'none', 250000, 90, 6, 750, 195),
(74, -588.5810546875, -1048.923828125, 23.345886230469, 'none', 50000, 20, 1, 250, 10),
(75, -601.3427734375, -1065.6640625, 23.404870986938, 'none', 50000, 20, 1, 830, 10),
(76, -427.4501953125, -392.439453125, 16.580152511597, 'none', 120000, 40, 1, 11872, 15),
(77, 870.1337890625, -25.685546875, 63.927940368652, 'none', 620000, 150, 16, 0, 0),
(78, -1499.9404296875, 1960.5419921875, 49.0234375, 'none', 350000, 150, 21, 200, 50),
(30, -2169.7490234375, 1027.41796875, 80.0078125, 'none', 160000, 50, 5, 1400, 50),
(79, -1051.5478515625, 1549.9306640625, 33.437610626221, 'none', 20000, 120, 3, 500, 0),
(81, 2272.3818359375, -118.9013671875, 28.153547286987, 'none', 550000, 150, 10, 0, 0),
(51, -2424.697265625, 2448.626953125, 13.154174804688, 'none', 120000, 75, 9, 0, 0),
(55, 2245.455078125, -121.8125, 28.153547286987, 'none', 550000, 150, 30, 5000, 50),
(47, -2792.0546875, -17.755859375, 7.859375, 'none', 75000, 30, 1, 923, 20),
(48, -2786.88671875, 0.171875, 10.0625, 'none', 85000, 40, 1, 1820, 10),
(49, -2792.189453125, -107.396484375, 7.859375, 'none', 70000, 35, 1, 580, 3),
(34, 1496.8935546875, -688.1591796875, 95.544792175293, 'none', 1200000, 120, 12, 2, 0),
(80, -2597.66015625, 2357.1259765625, 9.8829956054688, 'none', 175000, 130, 14, 40, 20),
(82, -2597.40625, 2364.658203125, 9.8829956054688, 'none', 175000, 130, 14, 150, 25),
(83, -2627.6328125, 2283.2763671875, 8.3148441314697, 'none', 150000, 115, 1, 0, 0),
(84, -2627.4384765625, 2291.908203125, 8.3132781982422, 'none', 150000, 115, 1, 0, 20),
(85, -2627.064453125, 2310.013671875, 8.3102703094482, 'none', 150000, 115, 1, 0, 25),
(86, -2627.04296875, 2318.52734375, 8.3100967407227, 'none', 150000, 115, 1, 0, 0),
(87, 1606.505859375, 2679.3935546875, 10.8203125, 'none', 470000, 320, 3, 0, 0),
(88, 1315.1123046875, 2524.5244140625, 10.8203125, 'none', 320000, 210, 3, 0, 150),
(89, 1500.3486328125, 2535.33984375, 10.8203125, 'none', 320000, 210, 3, 0, 500),
(90, 342.12890625, 62.4033203125, 3.8452200889587, 'none', 82500, 55, 6, 868, 20),
(91, 309.47265625, 43.9619140625, 2.8879654407501, 'none', 82500, 55, 6, 0, 100),
(92, 286.02734375, 41.43359375, 2.5319972038269, 'none', 82500, 55, 6, 0, 25),
(93, -2064.74609375, 876.013671875, 69.46875, 'none', 75000, 40, 11, 800, 100),
(94, -2722.6123046875, -58.0322265625, 4.3359375, 'none', 75000, 100, 1, 12, 3),
(96, -2050.53125, 883.2509765625, 63.174026489258, 'none', 75000, 40, 11, 1980, 15),
(98, 265.62890625, -1287.8818359375, 74.632507324219, 'none', 750000, 400, 30, 0, 0),
(99, 251.4521484375, -1220.1982421875, 76.10237121582, 'none', 750000, 400, 30, 50, 0),
(100, 219.21484375, -1249.8232421875, 78.336547851562, 'none', 750000, 400, 12, 0, 100),
(101, 298.9755859375, -1338.408203125, 53.441558837891, 'none', 549000, 250, 12, 0, 0),
(102, 398.1201171875, -1271.38671875, 50.019790649414, 'none', 680000, 350, 30, 1040, 1),
(103, 2324.5654296875, 162.1357421875, 28.441644668579, 'none', 350000, 90, 8, 0, 0),
(104, 2204.208984375, -89.70703125, 28.153547286987, 'none', 550000, 90, 12, 0, 1),
(105, 2198.10546875, -60.7421875, 28.153549194336, 'none', 450000, 90, 15, 0, 400),
(106, 2200.7509765625, -37.697265625, 28.153547286987, 'none', 450000, 90, 22, 0, 500),
(107, 1258.01171875, -785.67578125, 92.030181884766, 'none', 2500000, 510, 31, 300, 100),
(108, 1331.6650390625, -631.6748046875, 109.1349029541, 'none', 1500000, 110, 30, 0, 100),
(109, -2134.236328125, -2504.70703125, 31.816270828247, 'none', 350000, 110, 6, 80, 80),
(110, -2174.498046875, -2482.2939453125, 31.816272735596, 'none', 230000, 110, 23, 0, 30),
(111, -2706.619140625, 865.5419921875, 70.703125, 'none', 375000, 175, 30, 4000, 0),
(112, -2738.0576171875, 866.2509765625, 64.6328125, 'none', 120000, 40, 10, 960, 10),
(113, 2293.7705078125, -124.9609375, 28.153549194336, 'none', 550000, 150, 12, 0, 1),
(114, 2322.23828125, -124.923828125, 28.153551101685, 'none', 350000, 90, 10, 4561, 20),
(115, 2313.8515625, -124.9619140625, 28.153551101685, 'none', 350000, 90, 12, 0, 1),
(116, 2415.4189453125, -52.2763671875, 28.153547286987, 'none', 550000, 115, 10, 0, 20),
(97, -2397.666015625, -28.423828125, 35.984142303467, 'none', 250000, 450, 25, 500, 0),
(95, -2212.1396484375, 1056.8466796875, 80.013061523438, 'none', 85000, 90, 4, 350, 50),
(117, 2509.361328125, 10.0634765625, 28.4453125, 'none', 300000, 250, 10, 0, 0),
(118, 2488.283203125, 11.1220703125, 28.44164276123, 'none', 300000, 350, 5, 0, 0),
(38, 1106.1025390625, -299.845703125, 74.5390625, 'none', 330000, 475, 21, 118, 1),
(53, 2097.7802734375, 2493.6826171875, 14.838953018188, 'none', 750000, 400, 1, 0, 0),
(149, -2685.044921875, 820.5185546875, 49.984375, 'none', 100000, 75, 5, 390, 10),
(119, 1563.9560546875, 2776.609375, 10.8203125, 'none', 220000, 75, 5, 0, 15),
(120, 1550.611328125, 2845.029296875, 10.8203125, 'none', 250000, 150, 10, 410, 10),
(121, 1601.876953125, 2845.1611328125, 10.8203125, 'none', 250000, 150, 10, 90, 10),
(122, 1563.8603515625, 2756.9130859375, 10.8203125, 'none', 250000, 80, 3, 0, 0),
(123, 1622.8134765625, 2844.919921875, 10.8203125, 'none', 250000, 150, 10, 4500, 0),
(124, 1575.703125, 2842.9921875, 10.8203125, 'none', 200000, 70, 10, 2500, 0),
(125, 1632.73046875, 2843.1064453125, 10.8203125, 'none', 250000, 150, 10, 226, 15),
(126, 1664.8271484375, 2844.734375, 10.8203125, 'none', 250000, 150, 10, 0, 0),
(127, 1678.29296875, 2691.603515625, 10.8203125, 'none', 275000, 150, 10, 120, 120),
(128, 1735.8017578125, 2692.1748046875, 10.8203125, 'none', 275000, 150, 10, 960, 20),
(129, 1703.6513671875, 2690.0302734375, 10.8203125, 'none', 275000, 150, 13, 18500, 0),
(130, 1570.1298828125, 2711.771484375, 10.8203125, 'none', 300000, 150, 13, 0, 100),
(131, 1599.6494140625, 2756.7783203125, 10.8203125, 'none', 300000, 150, 13, 0, 50),
(132, 1588.5458984375, 2798.072265625, 10.8203125, 'none', 300000, 75, 9, 0, 0),
(133, 1580.21875, 2709.9716796875, 10.8203125, 'none', 350000, 175, 15, 0, 0),
(134, 1618.3037109375, 2801.935546875, 10.8203125, 'none', 300000, 75, 8, 0, 0),
(135, 1601.193359375, 2709.9248046875, 10.8203125, 'none', 350000, 175, 15, 0, 10),
(136, 1652.427734375, 2709.8681640625, 10.8203125, 'none', 350000, 175, 15, 0, 500),
(137, 1627.1298828125, 2711.248046875, 10.8203125, 'none', 370000, 200, 10, 1345, 30),
(138, 1608.4677734375, 2752.7216796875, 10.8203125, 'none', 150000, 85, 3, 1300, 100),
(139, 1626.826171875, 2753.40234375, 10.8203125, 'none', 150000, 85, 3, 0, 500),
(140, 1663.12890625, 2752.6318359375, 10.8203125, 'none', 150000, 85, 3, 1000, 500),
(141, 1643.7158203125, 2752.31640625, 10.8203125, 'none', 150000, 85, 3, 300, 0),
(142, 1672.9736328125, 2801.5478515625, 10.8203125, 'none', 175000, 85, 3, 1700, 100),
(143, 1637.7138671875, 2802.41015625, 10.8203125, 'none', 175000, 85, 3, 0, 100),
(144, 1654.798828125, 2802.263671875, 10.8203125, 'none', 350000, 75, 9, 0, 0),
(145, -797.322265625, 2439.3876953125, 158.01237487793, 'none', 150000, 350, 6, 20592, 1),
(146, 189.6396484375, -1308.1845703125, 70.249412536621, 'none', 750000, 450, 10, 0, 0),
(148, -2659.6962890625, 803.083984375, 49.9765625, 'none', 100000, 75, 4, 1000, 200),
(150, -2563.1171875, 1149.1162109375, 55.7265625, 'none', 100000, 75, 4, 0, 0),
(151, -2900.7197265625, 1073.7763671875, 32.1328125, 'none', 75000, 50, 7, 320, 10),
(152, -2369.8935546875, 847.1103515625, 43.7890625, 'none', 157000, 100, 6, 355, 5),
(153, -2905.2578125, 1171.6455078125, 13.6640625, 'none', 75000, 50, 7, 0, 10),
(155, -2860.740234375, 963.609375, 44.0546875, 'none', 75000, 50, 1, 2735, 75),
(156, -2844.693359375, 921.2978515625, 44.0546875, 'none', 75000, 50, 1, 89, 25),
(157, -2843.220703125, 904.4736328125, 44.0546875, 'none', 75000, 50, 1, 140, 20),
(158, -2220.94921875, 99.875, 35.3203125, 'none', 75000, 50, 1, 800, 50),
(159, -2625.8642578125, 78.771484375, 7.203125, 'none', 250000, 150, 11, 655, 15),
(160, -2623.4296875, -99.337890625, 7.203125, 'none', 250000, 150, 11, 0, 50),
(161, -2725.7333984375, -92.4599609375, 7.203125, 'none', 275000, 150, 11, 0, 0),
(162, -2075.7568359375, -2312.7841796875, 31.13125038147, 'none', 350000, 150, 1, 450, 50),
(163, -2224.564453125, -2482.8828125, 31.816272735596, 'none', 250000, 150, 25, 3500, 0),
(164, -2181.015625, -2519.98828125, 31.816270828247, 'none', 350000, 150, 25, 750, 0),
(165, 300.2001953125, 1141.1572265625, 9.1374855041504, 'none', 250000, 150, 1, 400, 25),
(166, 2373.4873046875, 1642.58984375, 11.0234375, 'none', 30000, 30, 4, 2300, 0),
(167, 2363.40234375, 1642.595703125, 11.0234375, 'none', 30000, 30, 4, 0, 0),
(168, 2376.3408203125, 1682.8779296875, 11.0234375, 'none', 30000, 30, 4, 20, 10),
(169, 2357.7431640625, 1653.83984375, 11.0234375, 'none', 30000, 30, 4, 60, 20),
(170, 2357.75390625, 1669.3779296875, 11.0234375, 'none', 30000, 30, 4, 0, 20),
(171, 2391.3486328125, 1682.8779296875, 11.0234375, 'none', 30000, 30, 4, 0, 20),
(172, 2401.40625, 1682.875, 11.0234375, 'none', 30000, 30, 4, 11, 1),
(173, 2357.7451171875, 1653.853515625, 14.281055450439, 'none', 30000, 30, 4, 887, 10),
(174, 2366.3154296875, 1682.87890625, 14.281055450439, 'none', 30000, 30, 4, 160, 20),
(175, 2517.03515625, 1674.2451171875, 11.0234375, 'none', 30000, 30, 4, 0, 10),
(176, 2476.3134765625, 1682.869140625, 11.0234375, 'none', 30000, 30, 4, 0, 30),
(177, 2496.36328125, 1682.8681640625, 11.0234375, 'none', 30000, 30, 4, 10, 10),
(178, 2517.01953125, 1653.9091796875, 11.0234375, 'none', 30000, 30, 4, 70, 10),
(179, 2503.498046875, 1643.5791015625, 11.0234375, 'none', 30000, 30, 4, 15, 5),
(180, 2631.330078125, 1978.8408203125, 10.8203125, 'none', 30000, 30, 4, 3335, 25),
(181, 2626.98828125, 2019.2138671875, 10.8203125, 'none', 30000, 30, 4, 0, 20),
(182, 2649.8779296875, 1978.83984375, 10.8203125, 'none', 30000, 30, 4, 0, 0),
(183, 2645.6044921875, 2019.2021484375, 10.816846847534, 'none', 30000, 30, 4, 0, 10),
(184, 2649.9072265625, 1978.83984375, 14.116060256958, 'none', 30000, 30, 4, 0, 0),
(185, 2633.1572265625, 1978.8466796875, 14.116060256958, 'none', 30000, 30, 4, 80, 20),
(186, 2634.5791015625, 2019.2041015625, 14.116060256958, 'none', 30000, 30, 4, 0, 1),
(187, 1967.3349609375, 2766.5439453125, 10.826543807983, 'none', 350000, 200, 10, 0, 500),
(188, 1992.5673828125, 2764.6357421875, 10.8203125, 'none', 500000, 250, 10, 0, 100),
(189, 2018.6494140625, 2766.5419921875, 10.826543807983, 'none', 350000, 200, 10, 0, 0),
(190, 2039.55859375, 2766.541015625, 10.826543807983, 'none', 350000, 200, 10, 0, 50),
(191, 2049.6025390625, 2764.2802734375, 10.8203125, 'none', 350000, 200, 10, 0, 0),
(192, 2018.1494140625, 2721.9443359375, 10.8203125, 'none', 250000, 200, 13, 2550, 50),
(33, -2196.7177734375, 602.818359375, 35.1640625, 'none', 150000, 200, 2, 71, 10),
(193, 1095.02, -647.65, 113.6484375, 'none', 750000, 700, 5, 51503, 100),
(198, -2214.2919921875, -2451.78515625, 31.816270828247, 'none', 25000, 45, 9, 50, 50),
(63, -2172.8505859375, 644.09375, 49.4375, 'none', 150000, 200, 5, 31, 1),
(147, -758.96875, 907.416015625, 12.822039604187, 'none', 150000, 200, 5, 22000, 50),
(154, -684.47265625, 939.46875, 13.6328125, 'none', 350000, 500, 12, 12875, 5),
(194, 4.1796875, 1344.658203125, 9.171875, 'none', 100000, 500, 2, 0, 40),
(195, 4.3623046875, 1381.791015625, 9.1781387329102, 'none', 100000, 500, 2, 0, 20),
(196, -88.9453125, 1378.3330078125, 10.469839096069, 'none', 675000, 500, 3, 0, 100),
(197, 254.86328125, -1366.80078125, 53.109375, 'none', 750000, 500, 10, 0, 0),
(199, -313.947265625, 1774.595703125, 43.640625, 'none', 1, 500, 8, 6100, 50),
(201, -2620.2353515625, 883.166015625, 63.25, 'none', 75000, 50, 1, 0, 0),
(200, 1266.3876953125, 234.3330078125, 25.048685073853, 'none', 2500000, 1000, 31, 551500, 0),
(205, -2789.1708984375, -181.3623046875, 10.0625, 'none', 130000, 150, 10, 7000, 500),
(237, 2495.4111328125, -1691.1376953125, 14.765625, 'none', 750000, 500, 30, 0, 15),
(202, -2789.185546875, 183.7421875, 10.0625, 'none', 85000, 60, 3, 286, 11),
(203, -2786.75390625, 62.6728515625, 10.0625, 'none', 65000, 50, 7, 30, 10),
(242, -2961.7744140625, 476.2255859375, 4.9099960327148, 'none', 500000, 50, 5, 2000, 250),
(204, -2791.947265625, -24.3974609375, 10.0546875, 'none', 110000, 100, 14, 2700, 50),
(206, -2881.0888671875, 989.7255859375, 40.71875, 'none', 95000, 100, 15, 0, 25),
(207, -2161.4462890625, -2535.556640625, 31.816270828247, 'none', 175000, 250, 3, 0, 0),
(220, 693.5439453125, -1705.814453125, 3.8194825649261, 'none', 300000, 300, 5, 234, 200),
(208, -2069.3564453125, -2495.169921875, 31.066806793213, 'none', 40000, 35, 4, 0, 0),
(209, -2067.7783203125, -2536.7783203125, 30.841997146606, 'none', 40000, 35, 4, 70, 0),
(210, -2045.0947265625, -2522.388671875, 31.066806793213, 'none', 40000, 35, 4, 10, 10),
(211, -1054.2357177734, -1623.5227050781, 77.141128540039, 'none', 200000, 250, 28, 24000, 0),
(212, 24.505859375, -2646.6796875, 40.464488983154, 'none', 100000, 150, 8, 300, 10),
(213, -36.1513671875, -2490.734375, 36.6484375, 'none', 30000, 30, 4, 0, 0),
(214, -15.271484375, -2497.45703125, 36.6484375, 'none', 30000, 30, 4, 998, 1),
(215, -9.978515625, -2505.9306640625, 36.655464172363, 'none', 30000, 30, 4, 80, 20),
(216, -17.1650390625, -2527.421875, 36.655464172363, 'none', 30000, 30, 4, 39, 1),
(217, -2004.2414550781, -1576.0859375, 86.344055175781, 'none', 150000, 500, 1, 14987, 500),
(218, -282.73046875, -2174.4560546875, 28.658182144165, 'none', 80000, 60, 7, 0, 500),
(219, -418.9072265625, -1759.19921875, 6.21875, 'none', 20000, 30, 1, 5, 1),
(221, 315.861328125, -1769.4306640625, 4.6224284172058, 'none', 350000, 200, 13, 36100, 0),
(222, 295.3212890625, -1764.119140625, 4.870002746582, 'none', 200000, 100, 1, 0, 39),
(223, 849.5927734375, -1519.9150390625, 14.348239898682, 'none', 500000, 350, 30, 0, 100),
(224, 841.2939453125, -1471.357421875, 14.313896179199, 'none', 500000, 350, 30, 30600, 150),
(225, 822.35546875, -1505.513671875, 14.39778137207, 'none', 500000, 350, 30, 35, 5),
(226, 813.67578125, -1456.6669921875, 14.220042228699, 'none', 500000, 350, 30, 0, 100),
(227, 852.248046875, -1423.2646484375, 14.136735916138, 'none', 500000, 350, 30, 0, 0),
(228, 893.65625, -1635.6982421875, 14.9296875, 'none', 350000, 200, 10, 0, 0),
(229, 865.244140625, -1633.845703125, 14.9296875, 'none', 350000, 200, 10, 0, 100),
(230, 693.7578125, -1645.8193359375, 4.09375, 'none', 300000, 300, 5, 1, 0),
(231, 725.6064453125, -1440.4482421875, 13.531820297241, 'none', 650000, 600, 30, 1900, 100),
(232, 980.9375, -1814.8193359375, 13.888680458069, 'none', 200000, 150, 9, 0, 40),
(233, 958.130859375, -1809.1865234375, 13.881379127502, 'none', 200000, 150, 9, 1583, 50),
(234, 922.0322265625, -1803.8955078125, 13.837596893311, 'none', 200000, 150, 9, 500, 0),
(235, 280.91015625, -1767.0693359375, 4.546875, 'none', 350000, 200, 13, 80, 40),
(236, 206.89453125, -1768.8828125, 4.3690934181213, 'none', 350000, 200, 13, 0, 150),
(238, 2459.447265625, -1691.65234375, 13.54590511322, 'none', 500000, 350, 5, 0, 50),
(239, 2523.271484375, -1679.3583984375, 15.496999740601, 'none', 350000, 300, 9, 0, 0),
(240, 2486.4736328125, -1644.5341796875, 14.077178955078, 'none', 600000, 400, 13, 8, 1),
(244, 946.3212890625, -710.69140625, 122.61987304688, 'none', 150000, 200, 1, 0, 0),
(241, -311.2919921875, 1303.4619140625, 53.664344787598, 'none', 500000, 600, 12, 5900, 100),
(246, 1566.55, 18.03, 23.81, 'none', 75000, 9999999, 12, 0, 100),
(243, 697.41, -1627.02, 3.4, 'none', 300000, 300, 12, 0, 50),
(245, 559.1279296875, -1076.404296875, 72.921989440918, 'none', 150000, 130, 1, 0, 300);



CREATE TABLE IF NOT EXISTS `idcounter` (
  `id` int(50) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO `idcounter` (`id`) VALUES
(1);



CREATE TABLE IF NOT EXISTS `inventar` (
  `Name` varchar(50) NOT NULL,
  `Wuerfel` tinyint(1) NOT NULL DEFAULT '0',
  `Blumensamen` int(11) NOT NULL DEFAULT '0',
  `Lottoschein` varchar(50) NOT NULL DEFAULT '0|0|0|0|0|0',
  `Essensslot1` int(2) NOT NULL DEFAULT '0',
  `Essensslot2` int(2) NOT NULL DEFAULT '0',
  `Essensslot3` int(2) NOT NULL DEFAULT '0',
  `Waffenslot1` varchar(50) NOT NULL DEFAULT '0|0',
  `Waffenslot2` varchar(50) NOT NULL DEFAULT '0|0',
  `Waffenslot3` varchar(50) NOT NULL DEFAULT '0|0',
  `Zigaretten` int(5) NOT NULL DEFAULT '0',
  `Materials` int(10) NOT NULL DEFAULT '0',
  `Benzinkanister` int(10) NOT NULL DEFAULT '0',
  `FruitNotebook` tinyint(1) NOT NULL DEFAULT '0',
  `Gameboy` int(1) NOT NULL DEFAULT '0',
  `Objekt` int(10) NOT NULL DEFAULT '0',
  `Chips` int(50) NOT NULL DEFAULT '0',
  `Geschenke` int(50) NOT NULL DEFAULT '0',
  `fishing` varchar(39) NOT NULL DEFAULT '0|0|0|0;0|0;0|0;0',
  `fglass` tinyint(1) NOT NULL DEFAULT '0',
  `eggs` int(10) NOT NULL DEFAULT '0',
  `Spezial` text NOT NULL,
  KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `loggedin` (
  `Name` varchar(50) NOT NULL,
  `Serial` varchar(32) NOT NULL DEFAULT 'ABCD1234ABCD1234',
  `IP` varchar(50) NOT NULL DEFAULT '0.0.0.0',
  `Loggedin` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `logout` (
  `Position` varchar(50) NOT NULL,
  `Waffen` varchar(50) NOT NULL,
  `Name` varchar(50) NOT NULL,
  KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



CREATE TABLE IF NOT EXISTS `lotto` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `z1` int(2) NOT NULL DEFAULT '0',
  `z2` int(2) NOT NULL DEFAULT '0',
  `z3` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

CREATE TABLE IF NOT EXISTS `object` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `model` int(6) NOT NULL,
  `x` float NOT NULL,
  `y` float NOT NULL,
  `z` float NOT NULL,
  `rx` float NOT NULL,
  `taken` tinyint(1) NOT NULL DEFAULT '0',
  `placer` varchar(50) NOT NULL,
  `deleteTime` int(15) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `packages` (
  `Name` varchar(50) NOT NULL,
  `Paket1` int(11) NOT NULL,
  `Paket2` int(11) NOT NULL,
  `Paket3` int(11) NOT NULL,
  `Paket4` int(11) NOT NULL,
  `Paket5` int(11) NOT NULL,
  `Paket6` int(11) NOT NULL,
  `Paket7` int(11) NOT NULL,
  `Paket8` int(11) NOT NULL,
  `Paket9` int(11) NOT NULL,
  `Paket10` int(11) NOT NULL,
  `Paket11` int(11) NOT NULL,
  `Paket12` int(11) NOT NULL,
  `Paket13` int(11) NOT NULL,
  `Paket14` int(11) NOT NULL,
  `Paket15` int(11) NOT NULL,
  `Paket16` int(11) NOT NULL,
  `Paket17` int(11) NOT NULL,
  `Paket18` int(11) NOT NULL,
  `Paket19` int(11) NOT NULL,
  `Paket20` int(11) NOT NULL,
  `Paket21` int(11) NOT NULL,
  `Paket22` int(11) NOT NULL,
  `Paket23` int(11) NOT NULL,
  `Paket24` int(11) NOT NULL,
  `Paket25` int(11) NOT NULL,
  PRIMARY KEY (`Name`),
  KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `players` (
  `id` int(10) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Serial` varchar(50) NOT NULL,
  `IP` varchar(50) NOT NULL,
  `Last_login` varchar(50) NOT NULL,
  `Geburtsdatum_Tag` int(11) NOT NULL,
  `Geburtsdatum_Monat` int(11) NOT NULL,
  `Geburtsdatum_Jahr` int(4) NOT NULL,
  `Passwort` varchar(32) NOT NULL,
  `Geschlecht` int(50) NOT NULL,
  `RegisterDatum` varchar(50) NOT NULL,
  `Salt` varchar(20) NOT NULL DEFAULT '',
  `LastLogin` int(50) NOT NULL DEFAULT '1',
  PRIMARY KEY (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `playingtime` (
  `Name` varchar(50) NOT NULL,
  `Time` int(4) NOT NULL DEFAULT '0',
  KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



CREATE TABLE IF NOT EXISTS `pm` (
  `Sender` varchar(50) NOT NULL,
  `Empfaenger` varchar(50) NOT NULL,
  `Text` varchar(500) NOT NULL,
  `Datum` varchar(50) NOT NULL,
  `ids` int(50) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`ids`),
  KEY `Empfaenger` (`Empfaenger`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `prestige` (
  `ID` int(10) NOT NULL,
  `X` float NOT NULL,
  `Y` float NOT NULL,
  `Z` float NOT NULL,
  `Besitzer` varchar(50) NOT NULL,
  `Preis` int(7) NOT NULL,
  `Beschreibung` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



INSERT INTO `prestige` (`ID`, `X`, `Y`, `Z`, `Besitzer`, `Preis`, `Beschreibung`) VALUES
(1, -2154.5, 461.22, 34.82, 'none', 250000, 'Glockenturm'),
(2, -1494.54, 920.17, 6.83, 'none', 500000, 'Glockenturm-Geb�ude ( SFPD )'),
(3, -1937.04, 883.32, 38.16, 'none', 100000, 'Statue'),
(4, -1989.04, 1117.92, 54.12, 'none', 250000, 'Kirche'),
(5, -2520.94, -623.43, 132.42, 'none', 175000, 'EWerk'),
(6, -2157.94, -399.43, 34.98, 'none', 75000, 'Football'),
(7, -2594.15, -41.08, 3.97, 'none', 300000, 'Gedenkstaette'),
(8, -2818.16, 1145.8, 20.01, 'none', 250000, 'Park'),
(9, -1503.91, 1373.92, 3.43, 'none', 250000, 'Insel'),
(10, -2533.16, 1221.05, 37.07, 'none', 125000, 'Diner'),
(11, 2490.67, 918.43, 10.67, 'none', 150000, 'Kirche'),
(12, 2000.82, 1523.16, 16.71, 'none', 245000, 'Piratenschiff'),
(13, 2226.35, 1838.65, 10.46, 'none', 150000, 'Clown-Casino'),
(14, -236.84, 2656.15, 62.29, 'none', 75000, 'Riesenhuehnchen');

CREATE TABLE IF NOT EXISTS `racing` (
  `Name` varchar(50) NOT NULL,
  `MilliSekunden` int(1) NOT NULL,
  `Sekunden` int(2) NOT NULL,
  `Minuten` int(5) NOT NULL,
  `Platz` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `skills` (
  `id` int(11) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `fishing` int(5) NOT NULL DEFAULT '0',
  `repair` int(5) NOT NULL DEFAULT '0',
  `gamble` int(10) NOT NULL DEFAULT '0',
  `cook` int(5) NOT NULL DEFAULT '0',
  KEY `id` (`id`),
  KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `state_files` (
  `name` varchar(50) NOT NULL,
  `text` varchar(1000) NOT NULL,
  `editor` varchar(50) NOT NULL,
  `faction` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `ticket_answeres` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(35) NOT NULL,
  `admin` varchar(35) NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `tickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(35) NOT NULL,
  `kathegory` int(11) NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `userdata` (
  `Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Geld` double NOT NULL DEFAULT '350',
  `Spawnpos_X` varchar(50) NOT NULL DEFAULT '-2458.288085',
  `Spawnpos_Y` varchar(50) NOT NULL DEFAULT '774.354492',
  `Spawnpos_Z` varchar(50) NOT NULL DEFAULT '35.171875',
  `Spawnrot_X` varchar(50) NOT NULL DEFAULT '52.94',
  `SpawnInterior` double NOT NULL DEFAULT '0',
  `SpawnDimension` double NOT NULL DEFAULT '0',
  `Fraktion` double NOT NULL DEFAULT '0',
  `FraktionsRang` double NOT NULL DEFAULT '0',
  `Adminlevel` int(10) NOT NULL DEFAULT '0',
  `Spielzeit` double NOT NULL DEFAULT '0',
  `CurrentCars` double NOT NULL DEFAULT '0',
  `MaximumCars` double NOT NULL DEFAULT '3',
  `Tode` double NOT NULL DEFAULT '0',
  `Kills` double NOT NULL DEFAULT '0',
  `Knastzeit` double NOT NULL DEFAULT '0',
  `Himmelszeit` double NOT NULL DEFAULT '0',
  `Hausschluessel` int(50) NOT NULL DEFAULT '0',
  `Bizschluessel` int(50) NOT NULL DEFAULT '0',
  `Bankgeld` double NOT NULL DEFAULT '1500',
  `Drogen` double NOT NULL DEFAULT '0',
  `Skinid` int(3) NOT NULL DEFAULT '0',
  `Autofuehrerschein` int(1) NOT NULL DEFAULT '0',
  `Motorradtfuehrerschein` int(1) NOT NULL DEFAULT '0',
  `LKWfuehrerschein` int(1) NOT NULL DEFAULT '0',
  `Helikopterfuehrerschein` int(1) NOT NULL DEFAULT '0',
  `FlugscheinKlasseA` int(1) NOT NULL DEFAULT '0',
  `FlugscheinKlasseB` int(1) NOT NULL DEFAULT '0',
  `Motorbootschein` int(1) NOT NULL DEFAULT '0',
  `Segelschein` int(1) NOT NULL DEFAULT '0',
  `Angelschein` int(1) NOT NULL DEFAULT '0',
  `Wanteds` int(1) NOT NULL DEFAULT '0',
  `StvoPunkte` int(2) NOT NULL DEFAULT '0',
  `Waffenschein` int(1) NOT NULL DEFAULT '0',
  `Perso` int(1) NOT NULL DEFAULT '0',
  `IncomePayday` float NOT NULL DEFAULT '2500',
  `Boni` double NOT NULL DEFAULT '0',
  `PdayIncome` double NOT NULL DEFAULT '0',
  `PdayKosten` double NOT NULL DEFAULT '0',
  `Telefonnr` varchar(50) NOT NULL DEFAULT '0',
  `Warns` int(50) NOT NULL DEFAULT '0',
  `Gunbox1` varchar(50) NOT NULL DEFAULT '0|0',
  `Gunbox2` varchar(50) NOT NULL DEFAULT '0|0',
  `Gunbox3` varchar(50) NOT NULL DEFAULT '0|0',
  `Job` varchar(50) NOT NULL DEFAULT 'none',
  `Jobtime` double NOT NULL DEFAULT '0',
  `Club` varchar(50) NOT NULL DEFAULT 'none',
  `FavRadio` varchar(50) NOT NULL DEFAULT '0',
  `Bonuspunkte` int(11) NOT NULL DEFAULT '0',
  `Truckerskill` varchar(50) NOT NULL DEFAULT 'none',
  `AirportLevel` varchar(50) NOT NULL DEFAULT '1',
  `farmerLVL` int(10) NOT NULL DEFAULT '0',
  `Contract` int(7) NOT NULL DEFAULT '0',
  `ArmyPermissions` varchar(50) NOT NULL DEFAULT '|0|0|0|0|0|0|0|0|0|',
  `SocialState` varchar(50) NOT NULL DEFAULT 'Obdachloser',
  `LastFactionChange` varchar(50) NOT NULL DEFAULT '-',
  `StreetCleanPoints` int(11) NOT NULL DEFAULT '0',
  `Handy` varchar(50) NOT NULL DEFAULT '|1|0|',
  `Rausch` varchar(50) NOT NULL DEFAULT '0|0|0|',
  `Sucht` varchar(50) NOT NULL DEFAULT '0|0|0|',
  `pred` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ob das Promt-Fenster gelesen wurde',
  `Shader` varchar(35) NOT NULL,
  KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `vehicles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Kofferraum` varchar(50) NOT NULL DEFAULT '0|0|0|0|',
  `Besitzer` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Typ` int(11) NOT NULL,
  `Tuning` varchar(255) NOT NULL,
  `Spawnpos_X` varchar(50) NOT NULL,
  `Spawnpos_Y` varchar(50) NOT NULL,
  `Spawnpos_Z` varchar(50) NOT NULL,
  `Spawnrot_X` varchar(50) NOT NULL,
  `Spawnrot_Y` varchar(50) NOT NULL,
  `Spawnrot_Z` varchar(50) NOT NULL,
  `Farbe` varchar(50) NOT NULL,
  `Paintjob` varchar(50) NOT NULL,
  `Benzin` varchar(50) NOT NULL,
  `Slot` float NOT NULL,
  `Special` int(11) NOT NULL DEFAULT '0',
  `Lights` varchar(50) NOT NULL DEFAULT '|255|255|255|',
  `Distance` double NOT NULL DEFAULT '0',
  `STuning` varchar(50) NOT NULL DEFAULT '0|0|0|0|0|0|',
  `AuktionsID` int(10) NOT NULL DEFAULT '0',
  `GangVehicle` tinyint(1) NOT NULL DEFAULT '0',
  `rc` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `Besitzer` (`Besitzer`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `warns` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player` varchar(35) NOT NULL,
  `admin` varchar(35) NOT NULL,
  `reason` text NOT NULL,
  `extends` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `extends_o` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;


CREATE TABLE IF NOT EXISTS `weed` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `x` int(20) NOT NULL,
  `y` int(20) NOT NULL,
  `z` int(20) NOT NULL,
  `time` int(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;