API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 18th, 2019
317
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 80.74 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.9.1
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: 127.0.0.1
  6. -- Erstellungszeit: 19. Okt 2019 um 05:26
  7. -- Server-Version: 10.4.8-MariaDB
  8. -- PHP-Version: 7.3.10
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET AUTOCOMMIT = 0;
  12. START TRANSACTION;
  13. SET time_zone = "+00:00";
  14.  
  15.  
  16. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  17. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  18. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  19. /*!40101 SET NAMES utf8mb4 */;
  20.  
  21. --
  22. -- Datenbank: `test`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Tabellenstruktur für Tabelle `accounts`
  29. --
  30.  
  31. CREATE TABLE `accounts` (
  32.   `id` int(11) NOT NULL,
  33.   `username` varchar(35) NOT NULL,
  34.   `password` varchar(256) NOT NULL,
  35.   `salt` varchar(16) NOT NULL,
  36.   `health` int(3) NOT NULL DEFAULT 100,
  37.   `armor` int(3) NOT NULL DEFAULT 0,
  38.   `hunger` varchar(12) NOT NULL DEFAULT '100',
  39.   `thirst` varchar(12) NOT NULL DEFAULT '100',
  40.   `alcoholBloodLevel` varchar(16) NOT NULL DEFAULT '0',
  41.   `thcBloodLevel` varchar(16) NOT NULL DEFAULT '0',
  42.   `cocainBloodLevel` varchar(16) NOT NULL DEFAULT '0',
  43.   `money` int(11) NOT NULL DEFAULT 1000,
  44.   `hasBankAcc` varchar(5) NOT NULL DEFAULT 'False',
  45.   `bank` int(1) NOT NULL DEFAULT 0,
  46.   `bankMoney` int(11) NOT NULL DEFAULT 0,
  47.   `telNumber` int(9) NOT NULL,
  48.   `level` int(4) NOT NULL DEFAULT 1,
  49.   `xp` int(11) NOT NULL DEFAULT 0,
  50.   `adminLevel` int(2) NOT NULL DEFAULT 0,
  51.   `adminDept` int(1) NOT NULL DEFAULT 0,
  52.   `job` int(2) NOT NULL DEFAULT 0,
  53.   `jobXP` int(11) NOT NULL DEFAULT 0,
  54.   `jobPoints` int(11) NOT NULL DEFAULT 0,
  55.   `fraction` int(2) NOT NULL DEFAULT 0,
  56.   `rank` int(2) NOT NULL DEFAULT 0,
  57.   `injury` varchar(32) NOT NULL DEFAULT 'none',
  58.   `deathTime` int(11) NOT NULL DEFAULT -1,
  59.   `stable` int(1) NOT NULL DEFAULT 0,
  60.   `isInJail` varchar(5) NOT NULL DEFAULT 'False',
  61.   `jailtime` int(11) NOT NULL DEFAULT 0,
  62.   `minutesToPayday` int(2) NOT NULL DEFAULT 60,
  63.   `minutesOnDuty` int(2) NOT NULL DEFAULT 0,
  64.   `onDuty` varchar(5) NOT NULL DEFAULT 'False',
  65.   `hasSocialBonus` varchar(5) NOT NULL DEFAULT 'False',
  66.   `hasBan` int(1) NOT NULL DEFAULT 0,
  67.   `banDuration` int(11) NOT NULL,
  68.   `bdate` varchar(32) NOT NULL DEFAULT '01.01.1980',
  69.   `bplace` varchar(32) NOT NULL DEFAULT 'Los Santos',
  70.   `amLicense` int(1) NOT NULL DEFAULT 0,
  71.   `aLicense` int(1) NOT NULL DEFAULT 0,
  72.   `bLicense` int(1) NOT NULL DEFAULT 0,
  73.   `cLicense` int(1) NOT NULL DEFAULT 0,
  74.   `dLicense` int(1) NOT NULL DEFAULT 0,
  75.   `eLicense` int(1) NOT NULL DEFAULT 0,
  76.   `f1License` int(1) NOT NULL DEFAULT 0,
  77.   `f2License` int(1) NOT NULL DEFAULT 0,
  78.   `gLicense` int(1) NOT NULL DEFAULT 0,
  79.   `posX` varchar(32) NOT NULL DEFAULT '5.5',
  80.   `posY` varchar(32) NOT NULL DEFAULT '5.5',
  81.   `posZ` varchar(32) NOT NULL DEFAULT '71.5',
  82.   `inventory` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL
  83. ) ;
  84.  
  85. --
  86. -- Daten für Tabelle `accounts`
  87. --
  88.  
  89. INSERT INTO `accounts` (`id`, `username`, `password`, `salt`, `health`, `armor`, `hunger`, `thirst`, `alcoholBloodLevel`, `thcBloodLevel`, `cocainBloodLevel`, `money`, `hasBankAcc`, `bank`, `bankMoney`, `telNumber`, `level`, `xp`, `adminLevel`, `adminDept`, `job`, `jobXP`, `jobPoints`, `fraction`, `rank`, `injury`, `deathTime`, `stable`, `isInJail`, `jailtime`, `minutesToPayday`, `minutesOnDuty`, `onDuty`, `hasSocialBonus`, `hasBan`, `banDuration`, `bdate`, `bplace`, `amLicense`, `aLicense`, `bLicense`, `cLicense`, `dLicense`, `eLicense`, `f1License`, `f2License`, `gLicense`, `posX`, `posY`, `posZ`, `inventory`, `outfit`, `outfit2`, `clothes`, `contacts`, `weaponData`) VALUES
  90. (10012, 'Demoaccount', '4C041FCADFA5C419883A188FE7E44D7312B4C0C5D57AEDECD212C1F82D683521', 'BxMs8SZ6Z0csz2n0', 100, 0, '100', '100', '0', '0', '0', 35000, 'False', 0, 0, 292555498, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'none', -1, 0, 'False', 0, 60, 0, 'False', 'False', 0, 0, '01.01.1980', 'Los Santos', 1, 0, 1, 0, 0, 0, 0, 0, 0, '5.5', '5.5', '71.5', '[]', '[[4, 3, 0], [6, 1, 1]]', '[]', '[[4, 3, 0], [6, 1, 1]]', '[]', '[]');
  91.  
  92. -- --------------------------------------------------------
  93.  
  94. --
  95. -- Tabellenstruktur für Tabelle `atms`
  96. --
  97.  
  98. CREATE TABLE `atms` (
  99.   `id` int(11) NOT NULL,
  100.   `bank` int(1) NOT NULL,
  101.   `posX` varchar(12) NOT NULL,
  102.   `posY` varchar(12) NOT NULL,
  103.   `posZ` varchar(12) NOT NULL
  104. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  105.  
  106. --
  107. -- Daten für Tabelle `atms`
  108. --
  109.  
  110. INSERT INTO `atms` (`id`, `bank`, `posX`, `posY`, `posZ`) VALUES
  111. (1, 2, '238,2985', '215,8825', '106,2868'),
  112. (2, 2, '285,6497', '143,754', '104,1714'),
  113. (3, 2, '237,458', '217,8258', '106,2868'),
  114. (4, 2, '236,4734', '219,7039', '106,2868'),
  115. (5, 1, '145,9562', '-1035,07', '29,34493'),
  116. (6, 1, '147,5776', '-1035,684', '29,34313'),
  117. (7, 2, '24,4623', '-945,9905', '29,35756'),
  118. (8, 2, '5,242511', '-919,8077', '29,55954'),
  119. (9, 3, '-203,7859', '-861,3891', '30,26763'),
  120. (10, 3, '-254,3345', '-692,4426', '33,6103'),
  121. (11, 3, '-256,2151', '-716,2308', '33,51609'),
  122. (12, 3, '-258,7664', '-723,3732', '33,46457'),
  123. (13, 3, '119,1495', '-883,6396', '31,12308'),
  124. (14, 3, '112,6922', '-819,3987', '31,33744'),
  125. (15, 3, '111,1151', '-775,5048', '31,43859'),
  126. (16, 3, '114,5756', '-776,4779', '31,41672'),
  127. (17, 2, '-2072,803', '-317,2693', '13,31597'),
  128. (18, 3, '-2975,04', '380,0625', '14,99889'),
  129. (19, 3, '-2959,016', '487,8256', '15,46392'),
  130. (20, 3, '-2956,845', '487,7185', '15,46392'),
  131. (21, 3, '-3241,13', '997,502', '12,5504'),
  132. (22, 2, '295,7563', '-896,1332', '29,21983'),
  133. (23, 2, '296,4652', '-894,1866', '29,23101'),
  134. (24, 3, '-303,3651', '-829,8547', '32,41724'),
  135. (25, 3, '-301,6258', '-830,0173', '32,41726'),
  136. (26, 2, '527,225', '-160,7883', '57,08646'),
  137. (27, 1, '-56,93454', '-1752,058', '29,42101'),
  138. (28, 2, '418,8717', '-970,9462', '29,42178'),
  139. (29, 3, '380,9012', '323,4257', '103,5664'),
  140. (30, 3, '33,34349', '-1348,159', '29,49702'),
  141. (31, 2, '264,7929', '210,9631', '106,2832'),
  142. (32, 2, '265,4444', '213,0442', '106,2832'),
  143. (33, 2, '-821,6531', '-1082,013', '11,13243'),
  144. (34, 2, '2558,844', '351,0537', '108,6214');
  145.  
  146. -- --------------------------------------------------------
  147.  
  148. --
  149. -- Tabellenstruktur für Tabelle `banks`
  150. --
  151.  
  152. CREATE TABLE `banks` (
  153.   `id` int(11) NOT NULL,
  154.   `bank` int(1) NOT NULL DEFAULT 1,
  155.   `name` varchar(32) NOT NULL,
  156.   `posX` varchar(32) NOT NULL,
  157.   `posY` varchar(32) NOT NULL,
  158.   `posZ` varchar(32) NOT NULL
  159. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  160.  
  161. --
  162. -- Daten für Tabelle `banks`
  163. --
  164.  
  165. INSERT INTO `banks` (`id`, `bank`, `name`, `posX`, `posY`, `posZ`) VALUES
  166. (1, 1, 'Fleeca Bank Pillbox Hill', '149,82', '-1040,65', '29,37'),
  167. (2, 1, 'Pacific Standard Public Deposit', '242,29', '225,07', '106,28'),
  168. (3, 2, 'Pacific Standard Public Deposit', '247,56', '223,17', '106,28'),
  169. (4, 3, 'Pacific Standard Public Deposit', '252,64', '221,41', '106,28');
  170.  
  171. -- --------------------------------------------------------
  172.  
  173. --
  174. -- Tabellenstruktur für Tabelle `blips`
  175. --
  176.  
  177. CREATE TABLE `blips` (
  178.   `id` int(11) NOT NULL,
  179.   `alpha` int(11) DEFAULT 255,
  180.   `color` int(11) DEFAULT NULL,
  181.   `dimension` int(11) DEFAULT 0,
  182.   `drawDistance` int(11) DEFAULT 0,
  183.   `name` varchar(64) DEFAULT NULL,
  184.   `rotation` int(11) DEFAULT 0,
  185.   `scale` float DEFAULT 1,
  186.   `posX` varchar(32) DEFAULT NULL,
  187.   `posY` varchar(32) DEFAULT NULL,
  188.   `posZ` varchar(32) DEFAULT NULL,
  189.   `sprite` int(11) DEFAULT NULL
  190. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  191.  
  192. --
  193. -- Daten für Tabelle `blips`
  194. --
  195.  
  196. INSERT INTO `blips` (`id`, `alpha`, `color`, `dimension`, `drawDistance`, `name`, `rotation`, `scale`, `posX`, `posY`, `posZ`, `sprite`) VALUES
  197. (1, 255, 1, 0, 0, 'St. Fiacre Hospital', 0, 1, '1122,58', '-1523,36', '34,8377', 61),
  198. (2, 255, 3, 0, 0, 'La Mesa Police Department', 0, 1, '827,295', '-1290,03', '28,2407', 60),
  199. (3, 255, 3, 0, 0, 'Davis Sheriff\'s Station', 0, 1, '361,003', '-1584,7', '29,2919', 60),
  200. (4, 255, 3, 0, 0, 'Mission Row Police Department', 0, 1, '434,101', '-981,898', '30,7093', 60),
  201. (5, 255, 1, 0, 0, 'Central Los Santos Medical Center', 0, 1, '343,097', '-1398,25', '32,5093', 61),
  202. (6, 255, 10, 0, 0, 'Gericht', 0, 1, '337,41', '-1562,38', '30,298', 541),
  203. (7, 255, 1, 0, 0, 'Davis Fire Station', 0, 1, '199,427', '-1634,58', '29,8032', 436),
  204. (8, 255, 3, 0, 0, 'Vespucci Police Department', 0, 1, '-1093,04', '-809,747', '19,2779', 60),
  205. (9, 255, 1, 0, 0, 'Sandy Shores Medical Center', 0, 1, '1838,87', '3673,69', '34,2767', 61),
  206. (10, 255, 3, 0, 0, 'Sandy Shores Sheriff\'s Station', 0, 1, '1853,46', '3687,92', '34,2671', 60),
  207. (11, 255, 1, 0, 0, 'Rockford Hills Fire Station', 0, 1, '-634,689', '-124,112', '39,0138', 436),
  208. (12, 255, 1, 0, 0, 'Sandy Shores Fire Station', 0, 1, '1696,55', '3586,15', '35,6209', 436),
  209. (13, 255, 1, 0, 0, 'Mount Zonah Medical Center', 0, 1, '-447,965', '-340,971', '34,5018', 61),
  210. (14, 255, 4, 0, 0, 'Sandy Shores Flugzeughangar', 0, 1, '1732,05', '3310,09', '40,7205', 557),
  211. (15, 255, 4, 0, 0, 'Grapeseed Flugzeughangar', 0, 1, '2134,76', '4780,97', '40,4672', 557),
  212. (16, 255, 1, 0, 0, 'The Bay Care Center', 0, 1, '-246,027', '6329,15', '32,4262', 61),
  213. (17, 255, 1, 0, 0, 'Los Santos International Airport Fire Station', 0, 1, '-1095,63', '-2363,26', '14,0237', 436),
  214. (18, 255, 3, 0, 0, 'Los Santos County Sheriff', 0, 1, '-441,258', '6018,42', '31,5588', 60),
  215. (19, 255, 4, 0, 0, 'Los Santos International Airport Flugzeughangar', 0, 1, '-990,39', '-3000,74', '13,9474', 557),
  216. (20, 255, 4, 0, 0, 'Vanilla Unicorn', 0, 1, '128,447', '-1298,57', '29,2327', 121),
  217. (21, 255, 4, 0, 0, 'Binco', 0, 1, '-822,323', '-1073,66', '11,3281', 73),
  218. (23, 255, 25, 0, 0, 'Fleeca Bank', 0, 1, '149,472', '-1040,57', '29,3741', 207),
  219. (25, 255, 25, 0, 0, 'Fleeca Bank', 0, 1, '314,124', '-278,739', '54,1708', 207),
  220. (26, 255, 25, 0, 0, 'Fleeca Bank', 0, 1, '-2962,59', '482,452', '15,7031', 207),
  221. (28, 255, 4, 0, 0, 'Pacific Standard Public Deposit Bank', 0, 1, '237,43', '217,68', '106,287', 605),
  222. (30, 255, 4, 0, 0, 'Car Wash', 0, 1, '-699,716', '-933,469', '19,0139', 100),
  223. (32, 255, 6, 0, 0, 'LTD', 0, 1, '-723,286', '-935,327', '19,2139', 361),
  224. (34, 255, 4, 0, 0, 'Bahama Mamas', 0, 1, '-1388,27', '-586,88', '30,2177', 93),
  225. (37, 255, 6, 0, 0, 'Xero Gas', 0, 1, '-525,818', '-1211,01', '18,1849', 361),
  226. (38, 255, 6, 0, 0, 'Xero Gas', 0, 1, '-2096,23', '-320,169', '13,1686', 361),
  227. (39, 255, 6, 0, 0, 'RON', 0, 1, '-1437,21', '-277,118', '46,2077', 361),
  228. (41, 255, 4, 0, 0, 'Vespucci Movie Masks', 0, 1, '-1336,29', '-1277,71', '4,87249', 102),
  229. (44, 255, 4, 0, 0, 'Herr Kutz Barber', 0, 1, '133,798', '-1709,09', '29,2916', 71),
  230. (45, 255, 4, 0, 0, 'Herr Kutz Barber', 0, 1, '1210,12', '-470,322', '66,208', 71),
  231. (46, 255, 4, 0, 0, 'Hair on Hawick Barbers', 0, 1, '-30,0712', '-150,476', '57,0765', 71),
  232. (47, 255, 4, 0, 0, 'Bob Mulet', 0, 1, '-821,885', '-184,791', '37,5689', 71),
  233. (48, 255, 4, 0, 0, 'Beachcombover Barbers', 0, 1, '-1285,61', '-1115,12', '6,99011', 71),
  234. (53, 255, 6, 0, 0, 'RON', 0, 1, '819,624', '-1028,53', '26,4043', 361),
  235. (54, 255, 4, 0, 0, 'Tuning Werkstatt', 0, 1, '732,841', '-1087,5', '22,169', 446),
  236. (55, 255, 4, 0, 0, 'Tuning Werkstatt', 0, 1, '-337,628', '-137,039', '39,0096', 446),
  237. (56, 255, 4, 0, 0, 'Tuning Werkstatt', 0, 1, '-1155,12', '-2006,06', '13,1803', 446),
  238. (57, 255, 6, 0, 0, 'LTD', 0, 1, '-71,2302', '-1761,58', '29,534', 361),
  239. (59, 255, 6, 0, 0, 'Globe Oil', 0, 1, '-319,471', '-1471,59', '30,5486', 361),
  240. (60, 255, 6, 0, 0, 'LTD', 0, 1, '1180,85', '-329,906', '69,3167', 361),
  241. (66, 255, 4, 0, 0, 'Car Wash', 0, 1, '22,734', '-1391,73', '29,3302', 100),
  242. (70, 255, 1, 0, 0, 'Paleto Bay Fire Station', 0, 1, '-379,525', '6118,29', '31,8487', 436),
  243. (72, 255, 4, 0, 0, 'Herr Kutz Barber', 0, 1, '-278,959', '6231,45', '31,6955', 71),
  244. (74, 255, 4, 0, 0, 'Tuning Werkstatt', 0, 1, '107,149', '6624,86', '31,7872', 446),
  245. (75, 255, 6, 0, 0, 'RON', 0, 1, '179,974', '6602,79', '31,8682', 361),
  246. (76, 255, 6, 0, 0, 'Globe Oil', 0, 1, '1702,11', '6416,94', '32,764', 361),
  247. (78, 255, 6, 0, 0, 'Xero Gas', 0, 1, '2679,02', '3264,52', '55,2406', 361),
  248. (79, 255, 6, 0, 0, 'RON', 0, 1, '2580,92', '361,803', '108,469', 361),
  249. (84, 255, 4, 0, 0, 'Tattoo Studio', 0, 1, '1862,01', '3749,66', '33,0319', 75),
  250. (85, 255, 4, 0, 0, 'O\'Sheas Barbers', 0, 1, '1931,58', '3726,95', '32,8444', 71),
  251. (87, 255, 6, 0, 0, 'Xero Gas', 0, 1, '2005,23', '3774,28', '32,4039', 361),
  252. (89, 255, 25, 0, 0, 'Fleeca Bank', 0, 1, '1175,58', '2706,8', '38,0941', 207),
  253. (91, 255, 4, 0, 0, 'Tuning Werkstatt', 0, 1, '1178,65', '2638,92', '37,7538', 446),
  254. (92, 255, 6, 0, 0, 'Globe Oil', 0, 1, '1207,6', '2660,64', '37,8998', 361),
  255. (97, 255, 6, 0, 0, 'RON', 0, 1, '-2555,33', '2334,36', '33,078', 361),
  256. (100, 255, 4, 0, 0, 'Hochschule', 0, 1, '-1636,95', '180,522', '61,7573', 80),
  257. (101, 255, 4, 0, 0, 'FIB Tower', 0, 1, '115,593', '-748,21', '45,7516', 88),
  258. (102, 255, 4, 0, 0, 'Stadthalle', 0, 1, '-544,73', '-204,504', '38,2155', 120),
  259. (103, 255, 6, 0, 0, 'Globe Oil', 0, 1, '620,701', '268,953', '103,089', 361),
  260. (104, 255, 4, 0, 0, 'The Richman Hotel', 0, 1, '-1273,73', '315,76', '65,5118', 475),
  261. (105, 255, 4, 0, 0, 'Templar Hotel', 0, 1, '288,209', '-1094,94', '29,4197', 475),
  262. (106, 255, 4, 0, 0, 'The Vault', 0, 1, '232,281', '-1094,99', '29,2942', 93),
  263. (107, 255, 4, 0, 0, 'The Gentry Manor Hotel', 0, 1, '-60,8282', '360,512', '113,056', 475),
  264. (108, 255, 4, 0, 0, 'Los Santos International Airport', 0, 1, '-1044,11', '-2748,79', '21,3634', 251),
  265. (109, 255, 4, 0, 0, 'Opium Nights Hotel', 0, 1, '-737,011', '-2276,13', '13,4375', 475),
  266. (110, 255, 1, 0, 0, 'El Burro Heights Fire Station', 0, 1, '1185,62', '-1463,94', '34,9011', 436),
  267. (111, 255, 4, 0, 0, 'Kirche', 0, 1, '-1684,74', '-291,5704', '51,89004', 305);
  268.  
  269. -- --------------------------------------------------------
  270.  
  271. --
  272. -- Tabellenstruktur für Tabelle `buildingdoors`
  273. --
  274.  
  275. CREATE TABLE `buildingdoors` (
  276.   `id` int(11) NOT NULL,
  277.   `doorId` int(11) NOT NULL,
  278.   `ownerId` int(11) NOT NULL,
  279.   `name` varchar(32) NOT NULL,
  280.   `locked` varchar(5) NOT NULL DEFAULT 'True',
  281.   `posX` varchar(32) NOT NULL,
  282.   `posY` varchar(32) NOT NULL,
  283.   `posZ` varchar(32) NOT NULL,
  284.   `rotZ` varchar(32) NOT NULL
  285. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  286.  
  287. --
  288. -- Daten für Tabelle `buildingdoors`
  289. --
  290.  
  291. INSERT INTO `buildingdoors` (`id`, `doorId`, `ownerId`, `name`, `locked`, `posX`, `posY`, `posZ`, `rotZ`) VALUES
  292. (1, 1, 10001, 'Theater Ausgang', 'False', '-565,98', '-597,64', '7,12', '180,85'),
  293. (2, 1, 10001, 'Theater Eingang', 'False', '-555,53', '-619,33', '34,67', '352,47'),
  294. (3, 2, 4, 'Mt. Zonah Medical Center Eingang', 'False', '-447,90', '-340,98', '34,50', '86,246'),
  295. (4, 2, 4, 'Mt. Zonah Medical Center Ausgang', 'False', '-450,00', '-316,00', '55,00', '00,00'),
  296. (5, 3, 10001, 'Stadthalle Eingang', 'True', '237,86', '-412,92', '48,11', '337,308'),
  297. (6, 3, 10001, 'Stadthalle Ausgang', 'True', '277,97', '-267,72', '53,93', '164,405'),
  298. (7, 4, 10001, 'Kirche Ausgang', 'False', '-1946,74', '-12,24', '91,67', '90'),
  299. (8, 4, 10001, 'Kirche Eingang', 'False', '-1684,74', '-291,57', '51,89', '145,98'),
  300. (9, 5, 9898, 'N.O.O.S.E. Eingang', 'False', '2475,724', '-384,053', '94,399', '275,149'),
  301. (10, 5, 9898, 'N.O.O.S.E. Ausgang', 'False', '2154,540', '2921,017', '-81,075', '267.905');
  302.  
  303. -- --------------------------------------------------------
  304.  
  305. --
  306. -- Tabellenstruktur für Tabelle `cardealers`
  307. --
  308.  
  309. CREATE TABLE `cardealers` (
  310.   `id` int(11) NOT NULL,
  311.   `name` varchar(32) NOT NULL,
  312.   `posX` varchar(32) NOT NULL,
  313.   `posY` varchar(32) NOT NULL,
  314.   `posZ` varchar(32) NOT NULL
  315. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  316.  
  317. --
  318. -- Daten für Tabelle `cardealers`
  319. --
  320.  
  321. INSERT INTO `cardealers` (`id`, `name`, `posX`, `posY`, `posZ`) VALUES
  322. (1, 'Vinewood Compact Cars', '-340,57', '266,12', '85,67'),
  323. (2, 'Premium Deluxe Motorsport', '-29,99', '-1104,88', '26,42'),
  324. (3, 'Benefactor Automotives', '-1160,86', '-1701,24', '4,56');
  325.  
  326. -- --------------------------------------------------------
  327.  
  328. --
  329. -- Tabellenstruktur für Tabelle `clothingcatalogue`
  330. --
  331.  
  332. CREATE TABLE `clothingcatalogue` (
  333.   `id` int(11) NOT NULL,
  334.   `shopType` int(11) NOT NULL,
  335.   `slot` int(11) NOT NULL,
  336.   `drawable` int(11) NOT NULL,
  337.   `maxTexture` int(11) NOT NULL,
  338.   `price` int(11) NOT NULL,
  339.   `name` varchar(32) NOT NULL,
  340.   `gender` int(1) NOT NULL
  341. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  342.  
  343. --
  344. -- Daten für Tabelle `clothingcatalogue`
  345. --
  346.  
  347. INSERT INTO `clothingcatalogue` (`id`, `shopType`, `slot`, `drawable`, `maxTexture`, `price`, `name`, `gender`) VALUES
  348. (100, 1, 11, 63, 0, 35, 'Hemd hochgekrempelt', 1),
  349. (3, 1, 3, 0, 0, 0, 'Koerper 1', 1),
  350. (4, 1, 3, 1, 0, 0, 'Koerper 2', 1),
  351. (5, 1, 3, 2, 0, 0, 'Koerper 3', 1),
  352. (6, 1, 3, 4, 0, 0, 'Koerper 4', 1),
  353. (7, 1, 3, 5, 0, 0, 'Koerper 5', 1),
  354. (8, 1, 3, 6, 0, 0, 'Koerper 6', 1),
  355. (9, 1, 3, 8, 0, 0, 'Koerper 7', 1),
  356. (10, 1, 3, 11, 0, 0, 'Koerper 8', 1),
  357. (11, 1, 3, 12, 0, 0, 'Koerper 9', 1),
  358. (12, 1, 3, 14, 0, 0, 'Koerper 10', 1),
  359. (13, 1, 3, 15, 0, 0, 'Koerper 11', 1),
  360. (14, 1, 3, 119, 0, 20, 'Arbeitshandschuhe gelb 1', 1),
  361. (15, 1, 3, 126, 0, 20, 'Arbeitshandschuhe gelb 2', 1),
  362. (16, 1, 3, 63, 0, 20, 'Arbeitshandschuhe gelb 2', 1),
  363. (17, 1, 3, 64, 0, 20, 'Arbeitshandschuhe gelb 4', 1),
  364. (18, 1, 3, 0, 0, 0, 'Koerper 1', 2),
  365. (19, 1, 3, 1, 0, 0, 'Koerper 2', 2),
  366. (20, 1, 3, 2, 0, 0, 'Koerper 3', 2),
  367. (21, 1, 3, 3, 0, 0, 'Koerper 4', 2),
  368. (22, 1, 3, 4, 0, 0, 'Koerper 5', 2),
  369. (23, 1, 3, 5, 0, 0, 'Koerper 6', 2),
  370. (24, 1, 3, 6, 0, 0, 'Koerper 7', 2),
  371. (25, 1, 3, 7, 0, 0, 'Koerper 8', 2),
  372. (26, 1, 3, 9, 0, 0, 'Koerper 9', 2),
  373. (27, 1, 3, 11, 0, 0, 'Koerper 10', 2),
  374. (28, 1, 3, 12, 0, 0, 'Koerper 11', 2),
  375. (29, 1, 3, 14, 0, 0, 'Koerper 12', 2),
  376. (30, 1, 3, 15, 0, 0, 'Koerper 13', 2),
  377. (31, 1, 3, 72, 0, 20, 'Arbeitshandschuhe gelb 1', 2),
  378. (32, 1, 3, 75, 0, 20, 'Arbeitshandschuhe gelb 2', 2),
  379. (33, 1, 3, 77, 0, 20, 'Arbeitshandschuhe gelb 3', 2),
  380. (34, 1, 3, 80, 0, 20, 'Arbeitshandschuhe gelb 4', 2),
  381. (35, 1, 6, 1, 15, 50, 'Sneaker', 1),
  382. (136, 1, 11, 169, 3, 40, 'Jeansjacke offen', 1),
  383. (135, 1, 11, 168, 2, 35, 'Hoodie 2', 1),
  384. (134, 1, 11, 164, 2, 25, 'Hemd oversized 2', 1),
  385. (133, 1, 11, 163, 0, 65, 'Lederjacke offen 2', 1),
  386. (132, 1, 11, 162, 3, 55, 'Lederweste 3', 1),
  387. (131, 1, 11, 161, 3, 65, 'Lederjacke 2', 1),
  388. (130, 1, 11, 160, 1, 50, 'Lederweste 2', 1),
  389. (129, 1, 11, 159, 1, 50, 'Sakko', 1),
  390. (128, 1, 11, 158, 2, 45, 'Weste', 1),
  391. (127, 1, 11, 157, 3, 55, 'Lederweste', 1),
  392. (126, 1, 11, 152, 15, 60, 'Motocross Longsleeve', 1),
  393. (125, 1, 11, 151, 5, 55, 'Bikerjacke', 1),
  394. (49, 1, 6, 4, 4, 50, 'Chucks', 1),
  395. (124, 1, 11, 150, 11, 40, 'Baseballjacke Muster', 1),
  396. (123, 1, 11, 148, 11, 50, 'Sportjacke 2', 1),
  397. (122, 1, 11, 146, 8, 25, 'T-Shirt 2', 1),
  398. (121, 1, 11, 143, 9, 55, 'Baseballjacke 3', 1),
  399. (120, 1, 11, 141, 10, 30, 'Sportjacke', 1),
  400. (119, 1, 11, 127, 14, 35, 'Hemd kariert offen', 1),
  401. (56, 1, 6, 5, 3, 20, 'Flip Flops', 1),
  402. (118, 1, 11, 126, 14, 35, 'Hemd kariert 2', 1),
  403. (117, 1, 11, 122, 13, 45, 'Jacke offen', 1),
  404. (116, 1, 11, 118, 9, 60, 'Lederjacke offen', 1),
  405. (115, 1, 11, 117, 15, 40, 'Hemd 2', 1),
  406. (114, 1, 11, 114, 3, 50, 'Bademantel', 1),
  407. (113, 1, 11, 111, 5, 60, 'Rollkragenpullover', 1),
  408. (112, 1, 11, 105, 0, 35, 'Hemd Blumenmuster', 1),
  409. (111, 1, 11, 88, 11, 55, 'Baseballjacke offen', 1),
  410. (110, 1, 11, 87, 11, 55, 'Baseballjacke 2', 1),
  411. (109, 1, 11, 84, 5, 35, 'Baseball Pullover', 1),
  412. (108, 1, 11, 82, 4, 25, 'Hemd oversized', 1),
  413. (69, 1, 6, 7, 15, 45, 'Turnschuhe', 1),
  414. (70, 1, 6, 27, 0, 65, 'Lederstiefel', 1),
  415. (99, 1, 11, 57, 0, 35, 'Hoodie', 1),
  416. (98, 1, 11, 39, 1, 40, 'Polo', 1),
  417. (97, 1, 11, 38, 4, 35, 'Baseball Shirt', 1),
  418. (96, 1, 11, 34, 1, 35, 'T-Shirt V-Neck 2', 1),
  419. (95, 1, 11, 33, 0, 30, 'T-Shirt gestreift', 1),
  420. (94, 1, 11, 22, 2, 25, 'T-Shirt', 1),
  421. (93, 1, 11, 17, 5, 20, 'Tank Top', 1),
  422. (83, 1, 4, 0, 15, 70, 'Jeans', 1),
  423. (102, 1, 11, 65, 3, 45, 'Arbeitsjacke', 1),
  424. (101, 1, 11, 64, 0, 60, 'Lederjacke', 1),
  425. (86, 1, 11, 16, 2, 30, 'T-Shirt V-Neck', 1),
  426. (107, 1, 11, 81, 2, 30, 'T-Shirt oversized V-Neck', 1),
  427. (106, 1, 11, 80, 2, 25, 'T-Shirt oversized', 1),
  428. (105, 1, 11, 79, 0, 50, 'Baseballjacke', 1),
  429. (104, 1, 11, 69, 5, 35, 'Kaputzenjacke 2', 1),
  430. (103, 1, 11, 68, 5, 35, 'Kaputzenjacke', 1),
  431. (92, 1, 11, 14, 5, 35, 'Hemd kariert', 1),
  432. (137, 1, 11, 170, 3, 35, 'Jeansweste offen', 1),
  433. (138, 1, 11, 171, 1, 35, 'Kaputzenpulli', 1),
  434. (139, 1, 11, 172, 3, 45, 'Jeansjacke offen 2', 1),
  435. (140, 1, 11, 173, 3, 40, 'Jeansweste offen 2', 1),
  436. (141, 1, 11, 174, 3, 50, 'Bikerjacke 2', 1),
  437. (142, 1, 11, 175, 3, 45, 'Bikerweste', 1),
  438. (143, 1, 11, 176, 0, 45, 'Lederweste 3', 1),
  439. (144, 1, 11, 191, 25, 50, 'Winterjacke offen', 1),
  440. (145, 1, 11, 193, 25, 35, 'T-Shirt oversized 2', 1),
  441. (146, 1, 11, 196, 15, 40, 'Weihnachtspullover', 1),
  442. (147, 1, 11, 198, 7, 45, 'Weihnachtscardigan', 1),
  443. (148, 1, 11, 200, 25, 40, 'Kaputzenpulli 2', 1),
  444. (149, 1, 11, 203, 25, 40, 'Kaputzenpulli 3', 1),
  445. (150, 1, 11, 225, 1, 35, 'Baseball Shirt 2', 1),
  446. (151, 1, 11, 229, 11, 50, 'Jacke', 1),
  447. (152, 1, 11, 230, 11, 50, 'Jacke offen', 1),
  448. (153, 1, 11, 251, 25, 60, 'Regenjacke', 1),
  449. (154, 1, 11, 253, 25, 60, 'Regenjacke 2', 1);
  450.  
  451. -- --------------------------------------------------------
  452.  
  453. --
  454. -- Tabellenstruktur für Tabelle `clothingstores`
  455. --
  456.  
  457. CREATE TABLE `clothingstores` (
  458.   `id` int(11) NOT NULL,
  459.   `name` varchar(32) NOT NULL,
  460.   `type` int(11) NOT NULL,
  461.   `posX` varchar(16) NOT NULL,
  462.   `posY` varchar(16) NOT NULL,
  463.   `posZ` varchar(16) NOT NULL,
  464.   `rotZ` varchar(16) NOT NULL
  465. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  466.  
  467. --
  468. -- Daten für Tabelle `clothingstores`
  469. --
  470.  
  471. INSERT INTO `clothingstores` (`id`, `name`, `type`, `posX`, `posY`, `posZ`, `rotZ`) VALUES
  472. (1, 'Binco', 1, '426,9737', '-807,0072', '29,49113', '91,86121'),
  473. (2, 'Discount Store', 2, '-1102,15', '2711,98', '19,10787', '216,337'),
  474. (3, 'Ponsonbys', 4, '-708,257', '-152,911', '37,41515', '106,8056'),
  475. (4, 'Sub Urban', 3, '-1193,892', '-767,0292', '17,31635', '216,9148'),
  476. (5, 'Ponsonbys', 4, '-1449,033', '-238,1345', '49,81334', '44,76788'),
  477. (6, 'Sub Urban', 3, '126,9899', '-224,2319', '54,55782', '71,12019'),
  478. (7, 'Ponsonbys', 4, '-164,9591', '-302,816', '39,73328', '248,7796'),
  479. (8, 'Binco', 1, '-817,0952', '-1072,208', '11,32811', '117,6323'),
  480. (9, 'Discount Store', 2, '73,9707', '-1392,298', '29,37614', '271,0424'),
  481. (10, 'Discount Store', 2, '-0,4904017', '6510,492', '31,87783', '308,5635'),
  482. (11, 'Sub Urban', 3, '-3169,343', '1043,34', '20,86321', '62,22139'),
  483. (12, 'Discount Store', 2, '1201,973', '2710,321', '38,22259', '89,88564'),
  484. (13, 'Discount Store', 2, '-1097,202', '2713,816', '19,10787', '122,1445');
  485.  
  486. -- --------------------------------------------------------
  487.  
  488. --
  489. -- Tabellenstruktur für Tabelle `dealercars`
  490. --
  491.  
  492. CREATE TABLE `dealercars` (
  493.   `id` int(11) NOT NULL,
  494.   `dealerId` int(11) NOT NULL,
  495.   `model` varchar(32) NOT NULL,
  496.   `price` int(11) NOT NULL,
  497.   `posX` varchar(32) NOT NULL,
  498.   `posY` varchar(32) NOT NULL,
  499.   `posZ` varchar(32) NOT NULL,
  500.   `rotZ` varchar(32) NOT NULL
  501. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  502.  
  503. --
  504. -- Daten für Tabelle `dealercars`
  505. --
  506.  
  507. INSERT INTO `dealercars` (`id`, `dealerId`, `model`, `price`, `posX`, `posY`, `posZ`, `rotZ`) VALUES
  508. (1, 1, 'brioso', 54999, '-349,77', '272,46', '84,27', '271,076'),
  509. (2, 1, 'blista', 46999, '-349,72', '275,93', '84,82', '271,365'),
  510. (3, 1, 'blista2', 39999, '-349,97', '279,25', '84,41', '271,257'),
  511. (4, 1, 'bilettante', 45999, '-349,92', '282,60', '84,39', '271,249'),
  512. (5, 1, 'issi2', 48999, '-349,96', '286,22', '84,58', '271,965'),
  513. (6, 1, 'panto', 39999, '-349,84', '289,88', '84,24', '271,527'),
  514. (7, 1, 'prairie', 52999, '-350,21', '293,26', '84,47', '272,969'),
  515. (8, 1, 'rhapsody', 44999, '-350,28', '296,79', '84,59', '270,832'),
  516. (9, 2, 'f620', 129999, '-56,89', '-1097,65', '25,98', '297,397'),
  517. (10, 2, 'cogcabrio', 109999, '-49,31', '-1101,26', '25,87', '318,590'),
  518. (11, 2, 'felon', 104999, '-46,43', '-1102,43', '26,11', '318,590'),
  519. (12, 2, 'sentinel2', 99999, '-47,69', '-1092,55', '25,80', '190,250'),
  520. (13, 2, 'jackal', 109999, '-41,84', '-1094,77', '26,14', '190,250'),
  521. (14, 2, 'zion', 94999, '-35,11', '-1099,01', '25,81', '138,793'),
  522. (15, 3, 'schlagen', 214999, '-1156,86', '-1707,69', '3,85', '0,028'),
  523. (16, 3, 'schafter3', 159999, '-1163,27', '-1712,40', '3,83', '-0,014'),
  524. (17, 3, 'schwarzer', 114999, '-1169,66', '-1716,87', '4,12', '0,245'),
  525. (18, 3, 'surano', 134999, '-1175,49', '-1720,74', '4,18', '-0,042'),
  526. (19, 3, 'xls', 109999, '-1181,22', '-1724,71', '4,47', '-0,022'),
  527. (20, 3, 'dubsta', 109999, '-1128,37', '-1729,07', '4,44', '18,233'),
  528. (21, 3, 'feltzer2', 184999, '-1124,25', '-1727,66', '4,70', '19,248'),
  529. (22, 3, 'schafter2', 134999, '-1118,11', '-1722,97', '4,54', '4,804'),
  530. (23, 3, 'serrano', 89999, '-1114,36', '-1719,91', '4,56', '3,244');
  531.  
  532. -- --------------------------------------------------------
  533.  
  534. --
  535. -- Tabellenstruktur für Tabelle `fractionbanks`
  536. --
  537.  
  538. CREATE TABLE `fractionbanks` (
  539.   `id` int(11) NOT NULL,
  540.   `amount` int(11) NOT NULL DEFAULT 0
  541. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
  542.  
  543. --
  544. -- Daten für Tabelle `fractionbanks`
  545. --
  546.  
  547. INSERT INTO `fractionbanks` (`id`, `amount`) VALUES
  548. (0, 1850),
  549. (1, 0),
  550. (2, 0),
  551. (3, 0),
  552. (4, 0),
  553. (5, 0),
  554. (6, 0),
  555. (7, 0);
  556.  
  557. -- --------------------------------------------------------
  558.  
  559. --
  560. -- Tabellenstruktur für Tabelle `fractions`
  561. --
  562.  
  563. CREATE TABLE `fractions` (
  564.   `id` int(11) NOT NULL,
  565.   `name` varchar(50) NOT NULL,
  566.   `money` int(11) NOT NULL DEFAULT 0,
  567.   `dutyPoints` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL
  568. ) ;
  569.  
  570. --
  571. -- Daten für Tabelle `fractions`
  572. --
  573.  
  574. INSERT INTO `fractions` (`id`, `name`, `money`, `dutyPoints`, `outfitsM`, `outfitsW`) VALUES
  575. (0, '', 101200, '[]', '[]', '[]'),
  576. (1, 'Los Santos Police Ddepartment', 0, '[{\"x\": 455.568848, \"y\": -988.6502, \"z\": 30.6895828}]', '[]', '[]'),
  577. (2, 'Federal Investigation Bureau', 0, '[]', '[[[4, 10, 0], [6, 10, 0], [11, 29, 0], [7, 125, 0], [3, 27, 0], [8, 34, 5]], [[7, 125, 0], [10, 0, 0], [3, 4, 0], [4, 34, 0], [6, 61, 0], [11, 53, 0], [8, 127, 0]]]', '[]'),
  578. (3, 'Department of Defense', 0, '[{\"x\": -2350.0957, \"y\": 3266.05078, \"z\": 32.8107567}]', '[[[10, 0, 0], [8, 15, 0], [4, 86, 3], [3, 0, 0], [7, 0, 0], [6, 25, 0], [11, 0, 1]], [[10, 0, 0], [6, 25, 0], [3, 11, 0], [7, 125, 0], [11, 186, 0], [4, 84, 0], [8, 97, 6]], [[10, 0, 0], [8, 15, 0], [4, 86, 3], [7, 0, 0], [6, 25, 0], [11, 221, 3], [3, 17, 0]], [[10, 0, 0], [8, 15, 0], [7, 0, 0], [6, 25, 0], [11, 48, 0], [4, 46, 1], [3, 96, 0]], [[10, 0, 0], [8, 15, 0], [7, 0, 0], [6, 25, 0], [11, 231, 0], [4, 93, 0], [3, 17, 2]], [[10, 0, 0], [6, 25, 0], [11, 13, 2], [3, 11, 0], [4, 86, 3], [7, 125, 0], [8, 122, 0]], [[10, 0, 0], [6, 25, 0], [3, 11, 0], [4, 86, 3], [11, 53, 1], [7, 125, 0], [8, 122, 0]]]', '[]'),
  579. (4, 'Los Santos Medical Center', 0, '[{\"x\": 1194.56934, \"y\": -1477.75623, \"z\": 34.85949}, {\"x\": -456.2336, \"y\": -305.618317, \"z\": 54.76033}]', '[[[11, 234, 4], [8, 15, 0], [3, 81, 0], [4, 25, 5], [6, 9, 0], [10, 9, 0], [7, 0, 0]], [[4, 17, 9], [8, 15, 0], [11, 5, 0], [3, 5, 0], [10, 0, 0], [6, 16, 5], [7, 127, 0]]]', '[]'),
  580. (5, 'Department of Justice', 0, '[]', '[]', '[]'),
  581. (6, 'Department of Public Order and Safety', 0, '[]', '[]', '[]'),
  582. (7, 'Department of Motor Vehicles', 0, '[]', '[]', '[]'),
  583. (8, 'La Cosa Nostra', 0, '[]', '[]', '[]');
  584.  
  585. -- --------------------------------------------------------
  586.  
  587. --
  588. -- Tabellenstruktur für Tabelle `garages`
  589. --
  590.  
  591. CREATE TABLE `garages` (
  592.   `id` int(11) NOT NULL,
  593.   `propertyId` int(11) NOT NULL DEFAULT 0,
  594.   `name` varchar(32) NOT NULL,
  595.   `fraction` int(2) NOT NULL,
  596.   `type` int(2) NOT NULL DEFAULT 1,
  597.   `isPrivate` varchar(5) NOT NULL DEFAULT 'False',
  598.   `marker` int(3) NOT NULL DEFAULT 23,
  599.   `scale` varchar(32) NOT NULL DEFAULT '1,0',
  600.   `red` int(3) NOT NULL,
  601.   `green` int(3) NOT NULL,
  602.   `blue` int(3) NOT NULL,
  603.   `alpha` int(3) NOT NULL DEFAULT 150,
  604.   `posX` varchar(32) NOT NULL,
  605.   `posY` varchar(32) NOT NULL,
  606.   `posZ` varchar(32) NOT NULL
  607. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  608.  
  609. --
  610. -- Daten für Tabelle `garages`
  611. --
  612.  
  613. INSERT INTO `garages` (`id`, `propertyId`, `name`, `fraction`, `type`, `isPrivate`, `marker`, `scale`, `red`, `green`, `blue`, `alpha`, `posX`, `posY`, `posZ`) VALUES
  614. (1001, 0, 'La Mesa Police Department', 1, 1, 'False', 23, '1,0', 50, 50, 255, 155, '850,10', '-1285,66', '28,00'),
  615. (1002, 0, 'St. Fiacre Hospital', 4, 1, 'False', 23, '1,0', 255, 50, 50, 155, '1207,31', '-1487,24', '34,84'),
  616. (1003, 0, 'Autogarage Burton', 0, 1, 'False', 23, '1,0', 255, 255, 255, 150, '-365,52', '-72,13', '45,65'),
  617. (1004, 0, 'Autogarage Pillbox Hill', 0, 1, 'False', 23, '1,0', 255, 255, 255, 150, '146,71', '-1086,18', '29,19'),
  618. (1005, 0, 'Autogarage Rancho', 0, 1, 'False', 23, '1,0', 255, 255, 255, 150, '361,22', '-1647,69', '27,25'),
  619. (1006, 0, 'Autogarage LS Intl. Airport', 0, 1, 'False', 23, '1,0', 255, 255, 255, 150, '-668,32', '-2385,89', '13,92'),
  620. (1007, 0, 'Autogarage Vespucci', 0, 1, 'False', 23, '1,0', 255, 255, 255, 150, '-1125,34', '-833,06', '13,36'),
  621. (1008, 0, 'Autogarage Pacific Bluffs', 0, 1, 'False', 23, '1,0', 255, 255, 255, 150, '-2952,86', '49,49', '11,60'),
  622. (1009, 0, 'Autogarage Rockford', 0, 1, 'False', 23, '1,0', 255, 255, 255, 150, '-794,32', '353,06', '87,87'),
  623. (1010, 0, 'Autogarage Vinewood', 0, 1, 'False', 23, '1,0', 255, 255, 255, 150, '303,83', '361,70', '105,38'),
  624. (1011, 0, 'Vespucci Police Department', 1, 1, 'False', 23, '1,0', 50, 50, 255, 150, '-1078,787', '-856,5075', '5,042521'),
  625. (1012, 0, 'LSMCCW', 4, 1, 'False', 23, '1,0', 255, 50, 50, 150, '-510,6587', '-295,8061', '35,36591'),
  626. (1013, 0, 'LSMCDP', 4, 1, 'False', 23, '1,0', 255, 50, 50, 150, '334,3082', '-561,1508', '28,74379'),
  627. (1014, 0, 'LSPD Mission Row', 1, 1, 'False', 23, '1,0', 50, 50, 255, 150, '441,8878', '-1013,545', '28,62858'),
  628. (1015, 0, 'Vinewood Police Department', 1, 1, 'False', 23, '1,0', 50, 50, 255, 150, '535,5668', '-21,83558', '70,62952'),
  629. (1016, 0, 'Weazle News HQ', 7, 1, 'False', 23, '1,0', 255, 255, 255, 150, '-537,099', '-886,8401', '25,19219'),
  630. (1017, 0, 'Davis Sheriff\'s Station', 1, 1, 'False', 23, '1,0', 50, 50, 255, 150, '377,9274', '-1622,088', '29,29195'),
  631. (1018, 0, 'Rockford Hills Fire Station', 4, 1, 'False', 23, '1,0', 255, 50, 50, 150, '-634,7909', '-109,3366', '38,03267'),
  632. (1019, 0, 'Davis Fire Station', 4, 1, 'False', 23, '1,0', 255, 50, 50, 150, '202,3365', '-1665,711', '29,80322'),
  633. (1020, 0, 'LSIA Fire Station', 4, 1, 'False', 23, '1,0', 255, 50, 50, 150, '-1095,604', '-2363,309', '14,02258'),
  634. (1021, 0, 'Sandy Shores Fire Station', 4, 1, 'False', 23, '1,0', 255, 50, 50, 150, '1697,681', '3613,929', '35,3105'),
  635. (1022, 0, 'Paleto Fire Station', 4, 1, 'False', 23, '1,0', 255, 50, 50, 150, '-372,1975', '6119,379', '31,44028'),
  636. (1023, 0, 'Fort Zancudo', 3, 1, 'False', 23, '1,0', 110, 80, 0, 150, '-2414,956', '3339,346', '32,97707'),
  637. (1024, 0, 'FIB HQ', 2, 1, 'False', 23, '1,0', 0, 0, 0, 150, '165,9536', '-688,8113', '33,12795'),
  638. (1025, 0, 'La Cosa Nostra', 8, 1, 'False', 23, '1,0', 0, 0, 0, 150, '-1531,876', '78,98055', '56,75471'),
  639. (1026, 0, 'La Cosa Nostra Helikopter', 8, 3, 'False', 23, '1,0', 0, 0, 0, 150, '-1547,362', '89,28055', '61,31318'),
  640. (1027, 1001, '6085 Milton Road', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '-681,22', '901,9814', '230,5754'),
  641. (1028, 1002, '4589 Milton Road', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '-614,7619', '864,7507', '213,3161'),
  642. (1029, 1003, '4588 Milton Road', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '-556,6844', '828,7972', '197,5883'),
  643. (1030, 1004, '4587 Milton Road', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '-490,1459', '796,0521', '180,5625'),
  644. (1031, 1005, '1337 Buen Vino Road', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '-2593,011', '1927,749', '167,3065'),
  645. (1032, 1006, '2001 Senora Road', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '1398,437', '1114,372', '114,8377'),
  646. (1033, 1007, '2707 Americano Way', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '-1493,189', '17,15579', '54,71732'),
  647. (1034, 1009, '2802 Portola Drive', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '-837,4678', '119,0358', '55,45132'),
  648. (1035, 1012, '6729BridgeStreet', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '1102,434', '-432,6344', '67,39205'),
  649. (1036, 1014, '6731BridgeStreet', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '1089,885', '-492,8275', '65,07653'),
  650. (1037, 0, 'Schiffsgarage-DOD', 3, 5, 'False', 23, '1,0', 110, 80, 0, 150, '508,51', '-3287,536', '6,069262'),
  651. (1038, 0, 'LSMCVespucciBeach', 4, 1, 'False', 23, '1,0', 255, 50, 50, 150, '-1202,734', '-1802,889', '3,908577');
  652.  
  653. -- --------------------------------------------------------
  654.  
  655. --
  656. -- Tabellenstruktur für Tabelle `gaspumps`
  657. --
  658.  
  659. CREATE TABLE `gaspumps` (
  660.   `id` int(11) NOT NULL,
  661.   `gasStation` int(11) NOT NULL,
  662.   `posX` varchar(32) NOT NULL,
  663.   `posY` varchar(32) NOT NULL,
  664.   `posZ` varchar(32) NOT NULL
  665. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  666.  
  667. --
  668. -- Daten für Tabelle `gaspumps`
  669. --
  670.  
  671. INSERT INTO `gaspumps` (`id`, `gasStation`, `posX`, `posY`, `posZ`) VALUES
  672. (1, 1, '818,4428', '-1029,053', '26,4043'),
  673. (2, 1, '811,3011', '-1028,706', '26,41885'),
  674. (3, 1, '826,6649', '-1028,632', '26,60824'),
  675. (4, 2, '1210,905', '-1405,092', '35,38521'),
  676. (5, 2, '1206,226', '-1399,964', '35,38554'),
  677. (6, 3, '621,0241', '264,7424', '103,2771'),
  678. (7, 3, '612,6577', '264,8711', '103,2771'),
  679. (8, 3, '612,2741', '272,7649', '103,2771'),
  680. (9, 3, '620,9195', '273,0555', '103,2771'),
  681. (10, 3, '629,6777', '272,8902', '103,2771'),
  682. (11, 3, '629,7007', '264,9323', '103,2771'),
  683. (12, 4, '1178,402', '-330,8781', '69,3166'),
  684. (13, 4, '1176,654', '-322,2249', '69,35079'),
  685. (14, 4, '1182,182', '-321,1485', '69,3503'),
  686. (15, 4, '1183,966', '-330,0107', '69,32634'),
  687. (16, 4, '1185,538', '-338,3997', '69,36536'),
  688. (17, 4, '1179,794', '-339,2729', '69,35648'),
  689. (18, 5, '-71,77341', '-1764,18', '29,53297'),
  690. (19, 5, '-69,7798', '-1758,866', '29,53405'),
  691. (20, 5, '-77,94009', '-1755,864', '29,80033'),
  692. (21, 5, '-79,82786', '-1761,25', '29,80007'),
  693. (22, 5, '-63,37265', '-1767,086', '29,26173'),
  694. (23, 5, '-61,51406', '-1761,69', '29,26173'),
  695. (24, 6, '-329,2758', '-1472,314', '30,72421'),
  696. (25, 6, '-325,2377', '-1479,583', '30,72421'),
  697. (26, 6, '-317,7741', '-1475,276', '30,72421'),
  698. (27, 6, '-310,2865', '-1470,813', '30,72421'),
  699. (28, 6, '-321,906', '-1468,168', '30,72421'),
  700. (29, 6, '-314,286', '-1463,887', '30,72421'),
  701. (30, 7, '-530,4554', '-1212,781', '18,32954'),
  702. (31, 7, '-523,3819', '-1216,044', '18,32881'),
  703. (32, 7, '-520,3547', '-1209,587', '18,32497'),
  704. (33, 7, '-527,7216', '-1206,159', '18,32878'),
  705. (34, 8, '-732,5057', '-933,4132', '19,21393'),
  706. (35, 8, '-732,7756', '-938,3526', '19,20996'),
  707. (36, 8, '-724,0641', '-938,3694', '19,20962'),
  708. (37, 8, '-724,2483', '-933,4478', '19,21393'),
  709. (38, 8, '-715,5161', '-933,4754', '19,21374'),
  710. (39, 8, '-715,051', '-938,4157', '19,20944'),
  711. (40, 9, '-1436,138', '-284,058', '46,38717'),
  712. (41, 9, '-1443,868', '-274,9907', '46,39413'),
  713. (42, 9, '-1429,667', '-278,4758', '46,38716'),
  714. (43, 9, '-1437,497', '-269,4554', '46,39414'),
  715. (44, 10, '-2097,287', '-319,7908', '13,16863'),
  716. (45, 10, '-2097,353', '-325,5308', '13,16859'),
  717. (46, 10, '-2096,176', '-312,8006', '13,16863'),
  718. (47, 10, '-2087,287', '-313,6806', '13,16863'),
  719. (48, 10, '-2087,941', '-320,1857', '13,16862'),
  720. (49, 10, '-2088,712', '-326,439', '13,16702'),
  721. (50, 10, '-2105,997', '-324,671', '13,16863'),
  722. (51, 10, '-2105,26', '-318,3625', '13,16862'),
  723. (52, 10, '-2104,295', '-311,9776', '13,16862'),
  724. (53, 11, '-2559,379', '2334,525', '33,25668'),
  725. (54, 11, '-2551,406', '2334,52', '33,25701'),
  726. (55, 11, '-2550,562', '2327,612', '33,25701'),
  727. (56, 11, '-2558,911', '2327,101', '33,25668'),
  728. (57, 11, '-2559,741', '2341,049', '33,25668'),
  729. (58, 11, '-2551,476', '2341,551', '33,25698'),
  730. (59, 12, '176,5727', '-1556,694', '29,23015'),
  731. (60, 12, '170,3675', '-1562,729', '29,26891'),
  732. (61, 12, '181,118', '-1561,053', '29,25958'),
  733. (62, 13, '257,0258', '-1268,773', '29,29295'),
  734. (63, 13, '257,0195', '-1261,3', '29,29295'),
  735. (64, 13, '257,0193', '-1253,462', '29,29295'),
  736. (65, 13, '264,4765', '-1253,414', '29,28998'),
  737. (66, 13, '264,4769', '-1261,224', '29,29282'),
  738. (67, 13, '264,4769', '-1268,637', '29,28942'),
  739. (68, 13, '273,2508', '-1268,593', '29,29293'),
  740. (69, 13, '273,2509', '-1261,235', '29,29296'),
  741. (70, 13, '273,2626', '-1253,434', '29,29277'),
  742. (71, 14, '2579,867', '364,3596', '108,4688'),
  743. (72, 14, '2579,974', '358,6909', '108,6454'),
  744. (73, 14, '2574,882', '359,2014', '108,4687'),
  745. (74, 14, '2575,344', '364,6651', '108,4671'),
  746. (75, 14, '2587,192', '363,9868', '108,4686'),
  747. (76, 14, '2587,167', '358,4953', '108,4692'),
  748. (77, 16, '185,5136', '6606,016', '31,86814'),
  749. (78, 16, '180,2211', '6605,012', '32,04737'),
  750. (79, 16, '172,9092', '6603,74', '32,04679'),
  751. (80, 15, '1705,158', '6414,262', '32,76402'),
  752. (81, 15, '1701,532', '6415,778', '32,76397'),
  753. (82, 15, '1697,374', '6417,904', '32,76403'),
  754. (83, 17, '-2558,612', '2340,88', '33,25547'),
  755. (84, 17, '-2552,354', '2341,307', '33,25701'),
  756. (85, 17, '-2552,618', '2335,059', '33,25699'),
  757. (86, 17, '-2558,515', '2334,719', '33,25666'),
  758. (87, 17, '-2558,05', '2327,288', '33,25664'),
  759. (88, 17, '-2551,168', '2327,716', '33,257'),
  760. (89, 18, '2008,504', '3776,124', '32,40394'),
  761. (90, 18, '2006,746', '3775,671', '32,40394'),
  762. (91, 18, '2003,411', '3772,765', '32,40395'),
  763. (92, 18, '2002,087', '3772,836', '32,40395'),
  764. (93, 19, '1209,429', '2659,279', '37,89977'),
  765. (94, 19, '1206,286', '2662,438', '37,89977'),
  766. (95, 20, '2681,388', '3267,204', '55,40941'),
  767. (96, 18, '2678,013', '3261,53', '55,4094');
  768.  
  769. -- --------------------------------------------------------
  770.  
  771. --
  772. -- Tabellenstruktur für Tabelle `gasstations`
  773. --
  774.  
  775. CREATE TABLE `gasstations` (
  776.   `id` int(11) NOT NULL,
  777.   `name` varchar(32) NOT NULL,
  778.   `type` int(11) NOT NULL,
  779.   `pplDiesel` int(11) NOT NULL,
  780.   `pplSuper` int(11) NOT NULL
  781. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  782.  
  783. --
  784. -- Daten für Tabelle `gasstations`
  785. --
  786.  
  787. INSERT INTO `gasstations` (`id`, `name`, `type`, `pplDiesel`, `pplSuper`) VALUES
  788. (1, 'RON', 3, 5, 7),
  789. (2, 'RON', 3, 13, 15),
  790. (3, 'Globe-Oil', 2, 10, 13),
  791. (4, 'LTD', 1, 11, 13),
  792. (5, 'LTD', 1, 12, 14),
  793. (6, 'LTD', 1, 10, 13),
  794. (7, 'Xero-Gas', 4, 12, 14),
  795. (8, 'LTD', 1, 12, 14),
  796. (9, 'RON', 3, 9, 13),
  797. (10, 'Xero-Gas', 4, 11, 14),
  798. (11, 'RON', 3, 9, 11),
  799. (12, 'RON', 3, 8, 12),
  800. (13, 'Xero-Gas', 4, 9, 11),
  801. (14, 'RON', 3, 6, 11),
  802. (15, 'GlobeOil', 2, 7, 11),
  803. (16, 'RON', 3, 8, 12),
  804. (17, 'RON', 3, 8, 12),
  805. (18, 'Xero-Gas', 4, 8, 11),
  806. (19, 'GlobeOil', 2, 6, 11),
  807. (20, 'Xero-Gas', 4, 8, 11);
  808.  
  809. -- --------------------------------------------------------
  810.  
  811. --
  812. -- Tabellenstruktur für Tabelle `hinterzimmerjhonny`
  813. --
  814.  
  815. CREATE TABLE `hinterzimmerjhonny` (
  816.   `id` int(11) NOT NULL,
  817.   `posX` varchar(16) NOT NULL,
  818.   `posY` varchar(16) NOT NULL,
  819.   `posZ` varchar(16) NOT NULL,
  820.   `rotZ` varchar(16) NOT NULL
  821. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  822.  
  823. --
  824. -- Daten für Tabelle `hinterzimmerjhonny`
  825. --
  826.  
  827. INSERT INTO `hinterzimmerjhonny` (`id`, `posX`, `posY`, `posZ`, `rotZ`) VALUES
  828. (1, '31,28936', '-1340,27', '29,49702', '81,17692');
  829.  
  830. -- --------------------------------------------------------
  831.  
  832. --
  833. -- Tabellenstruktur für Tabelle `jobs`
  834. --
  835.  
  836. CREATE TABLE `jobs` (
  837.   `id` int(11) NOT NULL,
  838.   `name` varchar(32) NOT NULL,
  839.   `posX` varchar(11) NOT NULL,
  840.   `posY` varchar(11) NOT NULL,
  841.   `posZ` varchar(11) NOT NULL,
  842.   `routes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL
  843. ) ;
  844.  
  845. --
  846. -- Daten für Tabelle `jobs`
  847. --
  848.  
  849. INSERT INTO `jobs` (`id`, `name`, `posX`, `posY`, `posZ`, `routes`) VALUES
  850. (0, '-', '0', '0', '0', '[]'),
  851. (1, 'Muellmann/-frau', '-322,2482', '-1545,795', '31,01991', '[[{\"x\": -626.4235, \"y\": -1604.59131, \"z\": 26.4807663}, {\"x\": -637.8767, \"y\": -1221.08142, \"z\": 11.4734058}, {\"x\": -721.5046, \"y\": -1169.47424, \"z\": 10.273056}, {\"x\": -710.119751, \"y\": -1138.4231, \"z\": 10.3294811}, {\"x\": -633.6979, \"y\": -1153.88354, \"z\": 9.280435}, {\"x\": -610.137451, \"y\": -1037.249, \"z\": 21.50178}, {\"x\": -564.2292, \"y\": -977.721558, \"z\": 21.8911762}, {\"x\": -526.1085, \"y\": -884.5221, \"z\": 24.8401833}, {\"x\": -573.841, \"y\": -895.964844, \"z\": 25.4142818}, {\"x\": -572.814453, \"y\": -858.2321, \"z\": 25.9704475}, {\"x\": -514.7756, \"y\": -873.702332, \"z\": 28.6492519}, {\"x\": -330.296173, \"y\": -1322.4342, \"z\": 31.1075134}, {\"x\": -290.479462, \"y\": -1357.437, \"z\": 30.9498272}, {\"x\": -335.317963, \"y\": -1564.36157, \"z\": 24.9444065}], [{\"x\": -364.524384, \"y\": -1863.9198, \"z\": 20.2432251}, {\"x\": -36.83889, \"y\": -1752.35754, \"z\": 29.0707626}, {\"x\": 111.263329, \"y\": -1814.54541, \"z\": 26.294775}, {\"x\": 195.4335, \"y\": -1810.51514, \"z\": 28.1858368}, {\"x\": 228.578491, \"y\": -1844.78943, \"z\": 26.5619183}, {\"x\": 378.76355, \"y\": -1975.36975, \"z\": 23.8553829}, {\"x\": 420.7524, \"y\": -2018.78833, \"z\": 22.7879963}, {\"x\": 416.995117, \"y\": -2040.57617, \"z\": 22.3262157}, {\"x\": 787.6243, \"y\": -1733.3479, \"z\": 29.2429581}, {\"x\": 433.992035, \"y\": -1459.16736, \"z\": 28.93712}, {\"x\": 492.229828, \"y\": -1507.048, \"z\": 28.96383}, {\"x\": 498.913574, \"y\": -1884.39661, \"z\": 25.5618057}, {\"x\": 451.5108, \"y\": -1883.71643, \"z\": 26.44212}, {\"x\": 194.873962, \"y\": -1776.07715, \"z\": 28.8237457}, {\"x\": 140.561981, \"y\": -1729.27185, \"z\": 28.8057632}, {\"x\": 95.09537, \"y\": -1691.5249, \"z\": 28.813015}, {\"x\": 3.64021635, \"y\": -1615.43127, \"z\": 28.96759}, {\"x\": -167.4331, \"y\": -1463.52161, \"z\": 31.5866032}, {\"x\": -335.3072, \"y\": -1564.33081, \"z\": 24.9466877}]]'),
  852. (2, 'Busfahrer/-in', '458,363', '-573,1226', '27,5498', '[[{\"x\": 457.2367, \"y\": -654.337341, \"z\": 27.8507214}, {\"x\": 307.214325, \"y\": -766.114563, \"z\": 29.23216}, {\"x\": 198.713181, \"y\": -1024.00134, \"z\": 29.3485489}, {\"x\": -270.992218, \"y\": -823.1102, \"z\": 31.7497959}, {\"x\": 54.34108, \"y\": -751.1152, \"z\": 44.127594}, {\"x\": 259.0586, \"y\": -377.4523, \"z\": 44.5904236}, {\"x\": 216.260147, \"y\": -52.94014, \"z\": 68.9695}, {\"x\": -501.281738, \"y\": 20.5429688, \"z\": 44.7558975}, {\"x\": -694.1351, \"y\": -7.54558563, \"z\": 38.11766}, {\"x\": -939.5701, \"y\": -131.2199, \"z\": 37.5764732}, {\"x\": -1525.64038, \"y\": -467.7906, \"z\": 35.35188}, {\"x\": -1600.41675, \"y\": -1040.56421, \"z\": 13.04139}, {\"x\": -1144.85583, \"y\": -826.9639, \"z\": 14.785058}, {\"x\": -691.1733, \"y\": -667.7231, \"z\": 30.8334255}, {\"x\": -504.3774, \"y\": -667.5803, \"z\": 33.0021935}, {\"x\": -244.832748, \"y\": -714.75824, \"z\": 33.4075165}, {\"x\": -248.8621, \"y\": -883.534668, \"z\": 30.5290833}, {\"x\": 129.424942, \"y\": -1021.15936, \"z\": 29.2555923}, {\"x\": 429.982, \"y\": -643.4129, \"z\": 28.4961452}], [{\"x\": 458.8063, \"y\": -648.0138, \"z\": 28.1984386}, {\"x\": 395.2793, \"y\": -992.6662, \"z\": 29.2804775}, {\"x\": 195.796722, \"y\": -1024.08167, \"z\": 29.3514938}, {\"x\": 112.119781, \"y\": -783.1077, \"z\": 31.3119755}, {\"x\": -173.712631, \"y\": -822.656555, \"z\": 30.9578762}, {\"x\": -582.513855, \"y\": -953.611633, \"z\": 22.8154545}, {\"x\": -811.0096, \"y\": -1127.78113, \"z\": 9.379256}, {\"x\": -1204.04114, \"y\": -1183.70471, \"z\": 7.61299753}, {\"x\": -1474.8562, \"y\": -629.877747, \"z\": 30.6090546}, {\"x\": -676.5198, \"y\": -377.656677, \"z\": 34.2568474}, {\"x\": 263.328, \"y\": -378.988861, \"z\": 44.6749077}, {\"x\": 771.3824, \"y\": -945.7114, \"z\": 25.7311}, {\"x\": 430.2601, \"y\": -637.798157, \"z\": 28.4964924}]]'),
  853. (3, 'Taxifahrer/-in', '895,1838', '-179,2972', '74,70027', '[]'),
  854. (4, 'KFZ-Mechaniker/-in', '-206,8346', '-1341,642', '34,89437', '[]');
  855.  
  856. -- --------------------------------------------------------
  857.  
  858. --
  859. -- Tabellenstruktur für Tabelle `meddropoff`
  860. --
  861.  
  862. CREATE TABLE `meddropoff` (
  863.   `id` int(11) NOT NULL,
  864.   `name` varchar(16) NOT NULL,
  865.   `posX` varchar(32) NOT NULL,
  866.   `posY` varchar(32) NOT NULL,
  867.   `posZ` varchar(32) NOT NULL,
  868.   `posXA` varchar(32) NOT NULL,
  869.   `posYA` varchar(32) NOT NULL,
  870.   `posZA` varchar(32) NOT NULL
  871. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  872.  
  873. --
  874. -- Daten für Tabelle `meddropoff`
  875. --
  876.  
  877. INSERT INTO `meddropoff` (`id`, `name`, `posX`, `posY`, `posZ`, `posXA`, `posYA`, `posZA`) VALUES
  878. (1, 'st.fiacre', '1164,48', '-1569,15', '39,40', '1122,56', '-1522,41', '34,83'),
  879. (2, 'mt.zonah', '-454,35', '-339,77', '34,36', '-447,83', '-340,99', '34,50');
  880.  
  881. -- --------------------------------------------------------
  882.  
  883. --
  884. -- Tabellenstruktur für Tabelle `parkingpoints`
  885. --
  886.  
  887. CREATE TABLE `parkingpoints` (
  888.   `id` int(11) NOT NULL,
  889.   `garageId` int(11) NOT NULL,
  890.   `posX` varchar(32) NOT NULL,
  891.   `posY` varchar(32) NOT NULL,
  892.   `posZ` varchar(32) NOT NULL,
  893.   `rotZ` varchar(32) NOT NULL
  894. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  895.  
  896. --
  897. -- Daten für Tabelle `parkingpoints`
  898. --
  899.  
  900. INSERT INTO `parkingpoints` (`id`, `garageId`, `posX`, `posY`, `posZ`, `rotZ`) VALUES
  901. (1, 1, '-339,85', '300,26', '84,99', '94,769'),
  902. (2, 1003, '-361,04', '-79,05', '45,66', '165,799'),
  903. (3, 1004, '132,26', '-1081,41', '28,69', '358,622'),
  904. (4, 1005, '361,77', '-1653,16', '26,75', '233,036'),
  905. (5, 1006, '-674,35', '-2391,07', '13,88', '58,134'),
  906. (6, 1007, '-1124,47', '-839,44', '12,90', '0,278'),
  907. (7, 1008, '-2953,12', '55,75', '11,10', '65,462'),
  908. (8, 1009, '-805,42', '357,62', '87,37', '1,329'),
  909. (9, 1010, '301,32', '367,62', '104,82', '347,028'),
  910. (10, 2, '-44,99', '-1116,21', '26,43', '357,860'),
  911. (11, 1001, '855,34', '-1279,49', '26,07', '1,194'),
  912. (12, 1002, '1196,69', '-1495,81', '34,69', '181,730'),
  913. (13, 1011, '-1071,741', '-856,8323', '4,867273', '214,3'),
  914. (14, 1011, '-1067,829', '-853,8982', '4,867257', '212,0308'),
  915. (15, 1012, '-515,7177', '-295,1559', '35,22958', '18,60837'),
  916. (16, 1013, '328,7159', '-557,0048', '28,74378', '341,49'),
  917. (17, 1014, '436,3889', '-997,4418', '25,75775', '175,9671'),
  918. (18, 1014, '431,1583', '-997,6219', '25,7567', '183,4842'),
  919. (19, 1015, '534,4287', '-26,67013', '70,62952', '211,3751'),
  920. (20, 1015, '529,9918', '-29,41676', '70,62952', '212,5214'),
  921. (21, 1017, '377,3943', '-1627,918', '28,55701', '318,3333'),
  922. (22, 1017, '380,3398', '-1630,432', '28,55686', '319,4666'),
  923. (23, 1018, '-638,3484', '-104,7636', '38,03584', '94,78943'),
  924. (24, 1018, '-635,4251', '-96,76399', '38,04562', '82,86921'),
  925. (25, 1018, '-638,6085', '-112,8882', '37,9902', '81,23292'),
  926. (26, 1019, '197,8346', '-1667,372', '29,80322', '139,0015'),
  927. (27, 1019, '194,5943', '-1664,659', '29,80322', '134,6946'),
  928. (28, 1019, '191,5628', '-1661,758', '29,80322', '139,5075'),
  929. (29, 1020, '-1094,107', '-2369,805', '13,94515', '147,8232'),
  930. (30, 1020, '-1088,82', '-2372,313', '13,94515', '151,0368'),
  931. (31, 1020, '-1084,073', '-2374,888', '13,94515', '149,2802'),
  932. (32, 1020, '-1079,116', '-2377,851', '13,94515', '148,6439'),
  933. (33, 1024, '167,0051', '-693,1143', '33,128', '162,068'),
  934. (42, 1025, '-1524,774', '82,46057', '56,55148', '7,031225'),
  935. (41, 1025, '-1529,002', '82,22009', '56,65501', '6,184558'),
  936. (40, 1025, '-1532,302', '82,89035', '56,74903', '315,2464'),
  937. (43, 1027, '-676,1087', '904,0263', '230,5777', '325,2675'),
  938. (38, 1026, '-1541,237', '78,63522', '62,31318', '47,87769'),
  939. (44, 1028, '-608,7338', '867,8205', '213,6238', '335,4611'),
  940. (45, 1029, '-551,5853', '831,7141', '197,9177', '339,3808'),
  941. (46, 1030, '-484,7044', '798,5886', '180,8445', '332,9511'),
  942. (47, 1032, '1401,752', '1117,634', '114,8377', '91,06383'),
  943. (48, 1032, '1407,497', '1117,277', '114,8377', '94,40981'),
  944. (49, 1032, '1414,032', '1117,41', '114,8379', '89,53864'),
  945. (50, 1033, '-1490,695', '22,9341', '54,72226', '349,5105'),
  946. (51, 1034, '-834,817', '116,192', '55,37723', '187,4521'),
  947. (52, 1034, '-839,3872', '115,304', '55,39243', '183,5414'),
  948. (53, 1036, '1086,353', '-494,8581', '64,64405', '79,22189'),
  949. (54, 1031, '-2595,885', '1930,126', '167,3073', '273,8013'),
  950. (55, 1035, '1098,729', '-429,1322', '67,3924', '87,46418'),
  951. (57, 1023, '-2409,667', '3332,095', '32,82911', '237,1624'),
  952. (58, 1037, '524,7269', '-3315,428', '-0,8356363', '182,7323'),
  953. (59, 3, '-1136,555', '-1717,769', '4,355034', '138,8057'),
  954. (60, 1038, '-1205,431', '-1798,995', '3,940186', '68,61');
  955.  
  956. -- --------------------------------------------------------
  957.  
  958. --
  959. -- Tabellenstruktur für Tabelle `plants`
  960. --
  961.  
  962. CREATE TABLE `plants` (
  963.   `id` int(11) NOT NULL,
  964.   `type` int(1) NOT NULL,
  965.   `time` int(5) NOT NULL DEFAULT 3,
  966.   `totalTime` int(5) NOT NULL,
  967.   `posX` varchar(32) NOT NULL,
  968.   `posY` varchar(32) NOT NULL,
  969.   `posZ` varchar(32) NOT NULL
  970. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  971.  
  972. --
  973. -- Daten für Tabelle `plants`
  974. --
  975.  
  976. INSERT INTO `plants` (`id`, `type`, `time`, `totalTime`, `posX`, `posY`, `posZ`) VALUES
  977. (12, 1, 0, 180, '-223,46', '-991,28', '28,94'),
  978. (13, 1, 0, 180, '-224,35', '-990,26', '28,94'),
  979. (14, 1, 0, 180, '-221,93', '-991,12', '28,94'),
  980. (15, 1, 0, 180, '-224,09', '-988,34', '28,94'),
  981. (16, 1, 0, 180, '-221,26', '-989,32', '28,94'),
  982. (17, 1, 0, 180, '-223,96', '-986,07', '28,94'),
  983. (18, 1, 0, 180, '-220,58', '-987,1', '28,94'),
  984. (19, 1, 0, 180, '-246,83', '-984,27', '30,95'),
  985. (20, 1, 0, 180, '-223,71', '-984,14', '28,94'),
  986. (21, 1, 0, 180, '-220,08', '-985,54', '28,94'),
  987. (22, 1, 0, 180, '-223,43', '-981,94', '28,94'),
  988. (23, 1, 0, 180, '-219,28', '-983,45', '28,94'),
  989. (24, 1, 0, 180, '-222,97', '-979,52', '28,94'),
  990. (25, 1, 0, 180, '-218,25', '-981,19', '28,94'),
  991. (26, 1, 0, 180, '-222,57', '-976,91', '28,94'),
  992. (27, 1, 0, 180, '-217,36', '-978,67', '28,94'),
  993. (28, 1, 0, 180, '-222,35', '-974,3', '28,94'),
  994. (29, 1, 0, 180, '-216,74', '-976,35', '28,94'),
  995. (30, 1, 0, 180, '-222,1', '-971,68', '28,94'),
  996. (31, 1, 0, 180, '-216,4', '-973,89', '28,94'),
  997. (32, 1, 0, 180, '-221,34', '-968,86', '28,94'),
  998. (33, 1, 0, 180, '-216,29', '-971,21', '28,94'),
  999. (34, 1, 0, 180, '-221,26', '-966,24', '28,94'),
  1000. (35, 1, 0, 180, '-216,35', '-968,17', '28,94'),
  1001. (36, 1, 0, 180, '-220,45', '-963,91', '28,94'),
  1002. (39, 1, 0, 180, '-216,23', '-962,85', '28,94'),
  1003. (40, 1, 0, 180, '-218,82', '-959,6', '28,94'),
  1004. (41, 1, 0, 180, '-216,2', '-960,17', '28,94'),
  1005. (42, 1, 0, 180, '-217,97', '-957,14', '28,94'),
  1006. (43, 1, 0, 180, '-216,06', '-957,84', '28,94'),
  1007. (44, 1, 0, 180, '-217,23', '-954,88', '28,94'),
  1008. (45, 1, 0, 180, '-216,03', '-955,28', '28,94'),
  1009. (46, 1, 0, 180, '-215,63', '-952,45', '28,94'),
  1010. (47, 1, 0, 180, '-216,71', '-952,21', '28,94'),
  1011. (48, 1, 0, 180, '-215,57', '-949,89', '28,94'),
  1012. (49, 1, 0, 180, '-245,28', '-929,77', '31,45'),
  1013. (50, 1, 0, 180, '-225,94', '-910,34', '31,48'),
  1014. (51, 1, 0, 180, '-231,23', '-925,32', '31,29'),
  1015. (52, 1, 0, 180, '-256,27', '-899,13', '31,45'),
  1016. (53, 1, 0, 180, '-264,85', '-896,18', '31,48'),
  1017. (54, 1, 0, 180, '-246,4', '-894,73', '31,3');
  1018.  
  1019. -- --------------------------------------------------------
  1020.  
  1021. --
  1022. -- Tabellenstruktur für Tabelle `properties`
  1023. --
  1024.  
  1025. CREATE TABLE `properties` (
  1026.   `id` int(11) NOT NULL,
  1027.   `name` varchar(32) NOT NULL,
  1028.   `ownerId` int(11) NOT NULL DEFAULT 0,
  1029.   `price` int(11) NOT NULL,
  1030.   `rent` int(4) NOT NULL DEFAULT 0,
  1031.   `playerSlots` int(11) NOT NULL DEFAULT 1,
  1032.   `vehicleSlots` int(11) NOT NULL DEFAULT 1,
  1033.   `storage` int(11) NOT NULL DEFAULT 1000,
  1034.   `garageId` int(11) NOT NULL DEFAULT 0,
  1035.   `locked` varchar(5) NOT NULL DEFAULT 'True',
  1036.   `posX` varchar(32) NOT NULL DEFAULT '0',
  1037.   `posY` varchar(32) NOT NULL DEFAULT '0',
  1038.   `posZ` varchar(32) NOT NULL DEFAULT '0',
  1039.   `rotZ` varchar(32) NOT NULL DEFAULT '0',
  1040.   `posXi` varchar(32) NOT NULL DEFAULT '347,26',
  1041.   `posYi` varchar(32) NOT NULL DEFAULT '-999,29',
  1042.   `posZi` varchar(32) NOT NULL DEFAULT '-99,19',
  1043.   `rotZi` varchar(32) NOT NULL DEFAULT '0',
  1044.   `IPLi` varchar(64) NOT NULL DEFAULT '',
  1045.   `posXb` varchar(32) NOT NULL DEFAULT '1087,8624',
  1046.   `posYb` varchar(32) NOT NULL DEFAULT '-3099,3125',
  1047.   `posZb` varchar(32) NOT NULL DEFAULT '-39,00363',
  1048.   `rotZb` varchar(32) NOT NULL DEFAULT '274,4692',
  1049.   `IPLb` varchar(64) NOT NULL DEFAULT 'ex_exec_warehouse_placement_interior_1_int_warehouse_s_dlc_milo',
  1050.   `storageX` varchar(32) NOT NULL DEFAULT '1104,822',
  1051.   `storageY` varchar(32) NOT NULL DEFAULT '-3099,403',
  1052.   `storageZ` varchar(32) NOT NULL DEFAULT '-38,999',
  1053.   `inventory` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL
  1054. ) ;
  1055.  
  1056. --
  1057. -- Daten für Tabelle `properties`
  1058. --
  1059.  
  1060. INSERT INTO `properties` (`id`, `name`, `ownerId`, `price`, `rent`, `playerSlots`, `vehicleSlots`, `storage`, `garageId`, `locked`, `posX`, `posY`, `posZ`, `rotZ`, `posXi`, `posYi`, `posZi`, `rotZi`, `IPLi`, `posXb`, `posYb`, `posZb`, `rotZb`, `IPLb`, `storageX`, `storageY`, `storageZ`, `inventory`, `occupants`) VALUES
  1061. (1001, '6085 Milton Road', 10008, 1500000, 0, 6, 30, 2000, 1027, 'True', '-658,5752', '887,0107', '229,2491', '178,2441', '117,18', '559,79', '184,30', '0', '', '1087,8624', '-3099,3125', '-39,00363', '274,4692', 'ex_exec_warehouse_placement_interior_1_int_warehouse_s_dlc_milo', '1104,822', '-3099,403', '-38,999', '[{\"Key\": \"item_bodyarmor\", \"Name\": \"Beschusshemmende Weste\", \"Price\": 0, \"Weight\": 1.5, \"Quantity\": 100, \"Description\": \"Die beschusshemmende Weste kann dir in einem Feuergefecht den entscheidenden Vorteil bringen.\"}]', '[10008]'),
  1062. (1002, '4589 Milton Road', 0, 0, 0, 4, 20, 1500, 1028, 'True', '-597,09', '851,6519', '211,4527', '44,33932', '117,18', '559,79', '184,30', '0', '', '1087,8624', '-3099,3125', '-39,00363', '274,4692', 'ex_exec_warehouse_placement_interior_1_int_warehouse_s_dlc_milo', '1104,822', '-3099,403', '-38,999', '[]', '[]'),
  1063. (1003, '4588 Milton Road', 0, 0, 0, 4, 20, 1500, 1029, 'True', '-536,4775', '818,9922', '197,5102', '338,7892', '117,18', '559,79', '184,30', '0', '', '1087,8624', '-3099,3125', '-39,00363', '274,4692', 'ex_exec_warehouse_placement_interior_1_int_warehouse_s_dlc_milo', '1104,822', '-3099,403', '-38,999', '[]', '[]'),
  1064. (1004, '4587 Milton Road', 0, 0, 0, 4, 20, 1500, 1030, 'True', '-494,2159', '796,0244', '184,3425', '78,41667', '117,18', '559,79', '184,30', '0', '', '1087,8624', '-3099,3125', '-39,00363', '274,4692', 'ex_exec_warehouse_placement_interior_1_int_warehouse_s_dlc_milo', '1104,822', '-3099,403', '-38,999', '[]', '[]'),
  1065. (1005, '1206 Buen Vino Road', 10001, 2500000, 100, 7, 35, 2500, 1031, 'True', '-2588,09', '1911,016', '167,4991', '12,84349', '-786,8195', '315,5634', '187,9137', '268,6951', 'apa_v_mp_h_02_c', '1087,8624', '-3099,3125', '-39,00363', '274,4692', 'ex_exec_warehouse_placement_interior_1_int_warehouse_s_dlc_milo', '1104,822', '-3099,403', '-38,999', '[{\"Key\": \"item_firstaid\", \"Name\": \"Verbandskasten\", \"Price\": 0, \"Weight\": 0.3, \"Quantity\": 7, \"Description\": \"Verbinde deine Wunden mit dem Verbandskasten.\"}, {\"Key\": \"item_bodyarmor\", \"Name\": \"Beschusshemmende Weste\", \"Price\": 0, \"Weight\": 1.5, \"Quantity\": 65, \"Description\": \"Die beschusshemmende Weste kann dir in einem Feuergefecht den entscheidenden Vorteil bringen.\"}]', '[10001, 10002]'),
  1066. (1006, '2001 Senora Road', 10004, 4500000, 0, 11, 60, 7500, 1032, 'True', '1394,422', '1141,848', '114,6398', '89,36447', '1397,175', '1141,752', '114,3336', '268,3558', '', '1087,8624', '-3099,3125', '-39,00363', '274,4692', 'ex_exec_warehouse_placement_interior_1_int_warehouse_s_dlc_milo', '1104,822', '-3099,403', '-38,999', '[]', '[10004]'),
  1067. (1007, '2707 Americano Way', 10006, 1500000, 100, 5, 25, 1000, 1033, 'True', '-1467,66', '34,7724', '54,54489', '152,4186', '-786,9483', '315,63', '187,9136', '268,3416', 'apa_v_mp_h_05_c', '1087,8624', '-3099,3125', '-39,00363', '274,4692', 'ex_exec_warehouse_placement_interior_1_int_warehouse_s_dlc_milo', '1104,822', '-3099,403', '-38,999', '[]', '[10006]'),
  1068. (1008, '1182 Banham Canyon Drive', 0, 0, 0, 5, 0, 1500, 0, 'True', '-2797,812', '1431,709', '100,9284', '329,8744', '0', '0', '0', '0', '', '1087,8624', '-3099,3125', '-39,00363', '274,4692', 'ex_exec_warehouse_placement_interior_1_int_warehouse_s_dlc_milo', '1104,822', '-3099,403', '-38,999', '[]', '[]'),
  1069. (1009, '2802 Portola Drive', 10003, 0, 0, 5, 25, 2000, 1034, 'True', '-830,7675', '115,0703', '55,82977', '95,15666', '-787,0902', '315,7039', '217,6384', '0', 'apa_v_mp_h_04_a', '1087,8624', '-3099,3125', '-39,00363', '274,4692', 'ex_exec_warehouse_placement_interior_1_int_warehouse_s_dlc_milo', '1104,822', '-3099,403', '-38,999', '[]', '[10003]'),
  1070. (1010, '1403 West Mirror Drive', 0, 0, 0, 2, 0, 1000, 0, 'True', '1114,22', '-391,2126', '68,94823', '68,8236', '266,0647', '-1007,441', '-101,0086', '356,4032', '', '1087,8624', '-3099,3125', '-39,00363', '274,4692', 'ex_exec_warehouse_placement_interior_1_int_warehouse_s_dlc_milo', '1104,822', '-3099,403', '-38,999', '[]', '[]'),
  1071. (1011, '6728 Bridge Street', 0, 0, 0, 3, 0, 2000, 0, 'True', '1100,774', '-411,3606', '67,55516', '84,38036', '266,0728', '-1007,398', '-101,0086', '0,5207935', '', '1087,8624', '-3099,3125', '-39,00363', '274,4692', 'ex_exec_warehouse_placement_interior_1_int_warehouse_s_dlc_milo', '1104,822', '-3099,403', '-38,999', '[]', '[]'),
  1072. (1012, '6729 Bridge Street', 0, 0, 0, 4, 20, 2000, 1035, 'True', '1099,399', '-438,6172', '67,79058', '350,9154', '346,5652', '-1012,721', '-99,19627', '358,7278', '', '1087,8624', '-3099,3125', '-39,00363', '274,4692', 'ex_exec_warehouse_placement_interior_1_int_warehouse_s_dlc_milo', '1104,822', '-3099,403', '-38,999', '[]', '[]'),
  1073. (1013, '6730 Bridge Street', 0, 0, 0, 2, 0, 1000, 0, 'True', '1098,587', '-464,6228', '67,31943', '163,9087', '346,4814', '-1012,708', '-99,19618', '359,6047', '', '1087,8624', '-3099,3125', '-39,00363', '274,4692', 'ex_exec_warehouse_placement_interior_1_int_warehouse_s_dlc_milo', '1104,822', '-3099,403', '-38,999', '[]', '[]'),
  1074. (1014, '6731BridgeStreet', 0, 0, 0, 4, 20, 2000, 1036, 'True', '1090,201', '-484,2894', '65,66044', '80,82219', '0', '0', '0', '0', '', '1087,8624', '-3099,3125', '-39,00363', '274,4692', 'ex_exec_warehouse_placement_interior_1_int_warehouse_s_dlc_milo', '1104,822', '-3099,403', '-38,999', '[]', '[]');
  1075.  
  1076. -- --------------------------------------------------------
  1077.  
  1078. --
  1079. -- Tabellenstruktur für Tabelle `shops`
  1080. --
  1081.  
  1082. CREATE TABLE `shops` (
  1083.   `id` int(11) NOT NULL,
  1084.   `name` varchar(32) NOT NULL,
  1085.   `type` int(11) NOT NULL,
  1086.   `posX` varchar(16) NOT NULL,
  1087.   `posY` varchar(16) NOT NULL,
  1088.   `posZ` varchar(16) NOT NULL,
  1089.   `rotZ` varchar(16) NOT NULL
  1090. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  1091.  
  1092. --
  1093. -- Daten für Tabelle `shops`
  1094. --
  1095.  
  1096. INSERT INTO `shops` (`id`, `name`, `type`, `posX`, `posY`, `posZ`, `rotZ`) VALUES
  1097. (1, 'LTD Shop', 2, '-706,1013', '-914,6157', '19,21559', '88,92066'),
  1098. (2, 'Robs Liquor', 3, '-1222,07', '-908,3552', '12,32636', '34,99833'),
  1099. (3, 'Robs Liquor', 3, '-1486,214', '-378,1111', '40,16343', '129,9144'),
  1100. (4, '24/7', 1, '372,9709', '328,162', '103,5664', '251,9434'),
  1101. (5, 'LTD Shop', 2, '1164,824', '-323,6348', '69,20515', '98,30661'),
  1102. (6, 'Robs Liquor', 3, '1134,127', '-982,0408', '46,41585', '276,1852'),
  1103. (7, '24/7', 1, '24,50045', '-1345,557', '29,49702', '263,2627'),
  1104. (8, 'LTD Shop', 2, '-47,34829', '-1758,613', '29,421', '52,49707'),
  1105. (9, '24/7', 1, '2556,838', '380,8612', '108,6229', '353,6436'),
  1106. (10, 'Ammu-Nation', 9, '21,73938', '-1105,115', '29,79703', '163,5664'),
  1107. (11, 'Ammu-Nation', 9, '-662,3483', '-933,5735', '21,82924', '172,7118'),
  1108. (12, '24/7', 1, '2677,948', '3279,342', '55,24112', '321,2331'),
  1109. (13, '24/7', 1, '1727,912', '6415,285', '35,03721', '248,9729'),
  1110. (14, 'Ammu-Nation', 9, '810,8101', '-2158,992', '29,61901', '355,635'),
  1111. (15, 'Ammu-Nation', 9, '-331,1203', '6085,41', '31,45479', '218,3346'),
  1112. (16, '24/7', 1, '-3242,469', '999,8877', '12,8307', '343,3961'),
  1113. (17, 'Ammu-Nation', 9, '-3173,386', '1088,963', '20,83875', '243,0187'),
  1114. (18, '24/7', 1, '-3039,215', '584,4747', '7,908927', '11,59717'),
  1115. (19, 'Robs Liquor', 3, '-2966,428', '391,3408', '15,04332', '86,63471'),
  1116. (20, 'Ammu-Nation', 9, '1692,333', '3761,109', '34,70531', '223,7303'),
  1117. (21, '24/7', 1, '1959,116', '3741,606', '32,34375', '300,9392'),
  1118. (22, '24/7', 1, '549,0751', '2671,054', '42,15648', '92,38366'),
  1119. (23, 'Scoops Liquor Barn', 3, '1165,698', '2710,84', '38,15771', '168,4661'),
  1120. (24, 'Ammu-Nation', 9, '-1118,351', '2700,302', '18,55415', '205,9733'),
  1121. (25, 'Robs Liquor', 3, '1392,845', '3606,478', '34,98093', '194,5726'),
  1122. (26, 'Donutladen', 5, '435,1627', '-974,3655', '30,97778', '88,20151'),
  1123. (27, 'Fresh Fruits', 8, '196,806', '-993,626', '30,09191', '49,78316'),
  1124. (28, 'Chihuahua Hotdogs', 4, '153,9446', '-982,5247', '30,16298', '329,0476'),
  1125. (29, 'Cheap Shot Coffee', 7, '152,236', '-964,3322', '30,29083', '231,6664'),
  1126. (30, 'Chihuahua Hotdogs', 4, '215,0492', '-899,9711', '30,69249', '186,3291'),
  1127. (31, 'Ammu-Nation', 9, '254,2706', '-50,93164', '69,98112', '72,74512');
  1128.  
  1129. -- --------------------------------------------------------
  1130.  
  1131. --
  1132. -- Tabellenstruktur für Tabelle `vehdata`
  1133. --
  1134.  
  1135. CREATE TABLE `vehdata` (
  1136.   `id` int(11) NOT NULL,
  1137.   `model` varchar(32) NOT NULL,
  1138.   `fuelType` int(1) NOT NULL DEFAULT 1,
  1139.   `maxFuel` int(5) NOT NULL DEFAULT 100,
  1140.   `fuelConsumption` varchar(4) NOT NULL DEFAULT '0,1',
  1141.   `maxStorage` int(5) NOT NULL DEFAULT 40,
  1142.   `engineMulti` varchar(4) NOT NULL DEFAULT '1,0',
  1143.   `hasSiren` varchar(5) NOT NULL DEFAULT 'False'
  1144. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  1145.  
  1146. --
  1147. -- Daten für Tabelle `vehdata`
  1148. --
  1149.  
  1150. INSERT INTO `vehdata` (`id`, `model`, `fuelType`, `maxFuel`, `fuelConsumption`, `maxStorage`, `engineMulti`, `hasSiren`) VALUES
  1151. (1, 'brioso', 1, 60, '0,05', 40, '1,0', 'False'),
  1152. (2, 'blista2', 1, 65, '0,06', 40, '1,0', 'False'),
  1153. (3, 'dilettante', 1, 70, '0,06', 45, '1,0', 'False'),
  1154. (4, 'blista', 1, 65, '0,06', 45, '1,0', 'False'),
  1155. (5, 'issi2', 1, 60, '0,07', 40, '1,0', 'False'),
  1156. (6, 'panto', 1, 45, '0,07', 20, '1,0', 'False'),
  1157. (7, 'prairie', 1, 70, '0,07', 35, '1,0', 'False'),
  1158. (8, 'rhapsody', 1, 50, '0,06', 40, '1,0', 'False'),
  1159. (9, 'f620', 1, 60, '0,08', 40, '1,0', 'False'),
  1160. (10, 'cogcabrio', 1, 65, '0,08', 45, '1,0', 'False'),
  1161. (11, 'felon', 1, 55, '0,09', 50, '1,0', 'False'),
  1162. (12, 'sentinel2', 1, 60, '0,08', 50, '1,0', 'False'),
  1163. (13, 'jackal', 1, 70, '0,07', 55, '1,0', 'False'),
  1164. (14, 'zion', 1, 65, '0,08', 55, '1,0', 'False'),
  1165. (15, 'ambulance', 2, 110, '0,05', 100, '1,0', 'True'),
  1166. (16, 'ambulance2', 2, 95, '0,05', 100, '1,0', 'True'),
  1167. (17, 'barracks3', 2, 150, '0,07', 130, '1,0', 'False'),
  1168. (18, 'blazer2', 1, 40, '0,05', 15, '1,0', 'True'),
  1169. (19, 'dubsta2', 2, 90, '0,09', 50, '1,0', 'False'),
  1170. (20, 'fibp', 1, 80, '0,08', 70, '1,0', 'True'),
  1171. (21, 'hotknife', 2, 60, '0,1', 40, '1,0', 'False'),
  1172. (22, 'lguard', 2, 80, '0,07', 55, '1,0', 'True'),
  1173. (23, 'lsfd', 2, 100, '0,1', 50, '1,0', 'True'),
  1174. (24, 'lsfd2', 2, 100, '0,1', 60, '1,0', 'True'),
  1175. (25, 'lsfd3', 2, 100, '0,1', 100, '1,0', 'True'),
  1176. (26, 'lsfd4', 2, 100, '0,1', 100, '1,0', 'True'),
  1177. (27, 'lsfd5', 2, 100, '0,1', 50, '1,0', 'True'),
  1178. (28, 'lsfdtruck', 2, 130, '0,07', 150, '1,0', 'True'),
  1179. (29, 'lsfdtruck2', 2, 130, '0,07', 150, '1,0', 'True'),
  1180. (30, 'lsfdtruck3', 2, 130, '0,07', 150, '1,0', 'True'),
  1181. (31, 'nef-1', 2, 100, '0,1', 50, '1,0', 'True'),
  1182. (32, 'neon', 1, 100, '0,1', 50, '1,0', 'False'),
  1183. (33, 'pbus', 2, 130, '0,09', 50, '1,0', 'True'),
  1184. (34, 'police', 2, 100, '0,1', 50, '1,0', 'True'),
  1185. (35, 'police2', 2, 100, '0,1', 50, '1,0', 'True'),
  1186. (36, 'police3', 2, 100, '0,1', 50, '1,0', 'True'),
  1187. (37, 'police4', 2, 100, '0,1', 50, '1,0', 'True'),
  1188. (38, 'policeb', 2, 100, '0,1', 50, '1,0', 'True'),
  1189. (39, 'policet', 2, 100, '0,1', 50, '1,0', 'True'),
  1190. (40, 'pranger', 2, 100, '0,1', 50, '1,0', 'True'),
  1191. (41, 'riot', 2, 100, '0,1', 50, '1,0', 'True'),
  1192. (42, 'riot2', 2, 100, '0,1', 50, '1,0', 'True'),
  1193. (43, 'sheriff', 2, 100, '0,1', 50, '1,0', 'True'),
  1194. (44, 'sheriff2', 2, 100, '0,1', 50, '1,0', 'True'),
  1195. (45, 't20', 1, 100, '0,1', 50, '1,0', 'False'),
  1196. (46, 'volatus', 4, 100, '0,1', 50, '1,0', 'False'),
  1197. (47, 'james', 2, 2000, '0,2', 8000, '1,0', 'False'),
  1198. (48, 'schlagen', 1, 65, '0,08', 40, '1,0', 'False'),
  1199. (49, 'schafter3', 1, 80, '0,07', 60, '1,0', 'False'),
  1200. (50, 'schwarzer', 1, 70, '0,07', 55, '1,0', 'False'),
  1201. (51, 'surano', 1, 65, '0,08', 50, '1,0', 'False'),
  1202. (52, 'xls', 2, 80, '0,07', 70, '1,0', 'False'),
  1203. (53, 'dubsta', 2, 90, '0,09', 80, '1,0', 'False'),
  1204. (54, 'feltzer2', 1, 60, '0,08', 40, '1,0', 'False'),
  1205. (55, 'schafter3', 1, 80, '0,09', 60, '1,0', 'False'),
  1206. (56, 'serrano', 2, 65, '0,08', 60, '1,0', 'False');
  1207.  
  1208. -- --------------------------------------------------------
  1209.  
  1210. --
  1211. -- Tabellenstruktur für Tabelle `vehicles`
  1212. --
  1213.  
  1214. CREATE TABLE `vehicles` (
  1215.   `id` int(11) NOT NULL,
  1216.   `ownerId` int(11) NOT NULL,
  1217.   `model` varchar(32) NOT NULL,
  1218.   `health` varchar(32) NOT NULL,
  1219.   `fuel` varchar(32) NOT NULL,
  1220.   `col1` int(3) NOT NULL DEFAULT 4,
  1221.   `col2` int(3) NOT NULL DEFAULT 4,
  1222.   `livery` int(2) NOT NULL DEFAULT 255,
  1223.   `inGarage` int(1) NOT NULL,
  1224.   `garageId` int(11) NOT NULL DEFAULT 0,
  1225.   `isRegistered` varchar(5) NOT NULL DEFAULT 'False',
  1226.   `posX` varchar(32) NOT NULL,
  1227.   `posY` varchar(32) NOT NULL,
  1228.   `posZ` varchar(32) NOT NULL,
  1229.   `rotZ` varchar(32) NOT NULL,
  1230.   `inventory` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL
  1231. ) ;
  1232.  
  1233. --
  1234. -- Daten für Tabelle `vehicles`
  1235. --
  1236.  
  1237. INSERT INTO `vehicles` (`id`, `ownerId`, `model`, `health`, `fuel`, `col1`, `col2`, `livery`, `inGarage`, `garageId`, `isRegistered`, `posX`, `posY`, `posZ`, `rotZ`, `inventory`) VALUES
  1238. (5, 10001, 'Brioso', '1000', '100', 4, 0, 255, 0, 1009, 'False', '-349,96', '286,22', '84,58', '271,965', '[]'),
  1239. (9, 10002, 'Blista2', '1000', '100', 4, 0, 255, 0, 1004, 'False', '-56,89', '-1097,65', '25,98', '297,397', '[]'),
  1240. (8, 10002, 'Dilettante', '1000', '100', 4, 0, 255, 1, 1003, 'False', '-350,28', '296,79', '84,59', '270,832', '[]'),
  1241. (10, 10001, 'f620', '1000', '100', 4, 0, 255, 0, 1005, 'False', '-49,31', '-1101,26', '25,87', '318,59', '[]'),
  1242. (11, 10002, 'f620', '1000', '100', 4, 0, 255, 1, 1004, 'False', '-46,43', '-1102,43', '26,11', '318,59', '[]'),
  1243. (13, 1, 'police', '1000', '100', 4, 0, 255, 1, 1001, 'False', '-41,84', '-1094,77', '26,14', '190,25', '[]'),
  1244. (12, 1, 'police', '1000', '100', 4, 0, 255, 1, 1001, 'False', '-47,69', '-1092,55', '25,8', '190,25', '[]'),
  1245. (14, 1, 'police2', '1000', '100', 4, 0, 255, 1, 1014, 'False', '-35,11', '-1099,01', '25,81', '138,793', '[]'),
  1246. (15, 1, 'police2', '1000', '100', 4, 0, 255, 1, 1001, 'False', '-1156,86', '-1707,69', '3,85', '0,028', '[]'),
  1247. (16, 1, 'police3', '1000', '100', 4, 0, 255, 1, 1001, 'False', '-1163,27', '-1712,4', '3,83', '-0,014', '[]'),
  1248. (17, 1, 'police3', '1000', '100', 4, 0, 255, 1, 1001, 'False', '-1169,66', '-1716,87', '4,12', '0,245', '[]'),
  1249. (18, 1, 'police4', '1000', '100', 4, 0, 255, 1, 1001, 'False', '-1175,49', '-1720,74', '4,18', '-0,042', '[]'),
  1250. (19, 1, 'police4', '1000', '100', 4, 0, 255, 1, 1014, 'False', '-1181,22', '-1724,71', '4,47', '-0,022', '[]'),
  1251. (20, 10003, 'sentinel2', '1000', '100', 4, 0, 255, 0, 1005, 'False', '-1128,37', '-1729,07', '4,44', '18,233', '[]'),
  1252. (21, 4, 'ambulance', '1000', '-0,002115227', 4, 0, 255, 0, 1002, 'False', '-453,66', '-335,81', '34,13', '3,525238', '[]'),
  1253. (22, 4, 'ambulance', '1000', '100', 0, 0, 255, 0, 1002, 'True', '1175', '-1546,19', '39,17', '0,001342773', '[]'),
  1254. (23, 4, 'ambulance', '1000', '100', 4, 0, 255, 1, 1002, 'False', '-1114,36', '-1719,91', '4,56', '3,244', '[]'),
  1255. (24, 4, 'ambulance', '1000', '100', 0, 0, 255, 1, 1002, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null'),
  1256. (25, 4, 'ambulance2', '1000', '100', 0, 0, 255, 1, 1002, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null'),
  1257. (26, 4, 'ambulance2', '1000', '99,5', 0, 0, 255, 0, 1002, 'True', '331,98', '-541,61', '28,48', '181,0619', '[]'),
  1258. (27, 4, 'ambulance2', '1000', '100', 0, 0, 255, 1, 1002, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null'),
  1259. (28, 4, 'ambulance2', '1000', '88,50018', 0, 0, 255, 0, 1002, 'True', '1201,93', '-1535,7', '39,14', '174,0112', '[]'),
  1260. (29, 4, 'lsfd', '1000', '100', 0, 0, 255, 1, 1002, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null'),
  1261. (30, 4, 'lsfd', '1000', '89,80016', 0, 0, 255, 1, 1002, 'True', '1194,86', '-1495,67', '34,37', '359,931', '[]'),
  1262. (31, 4, 'lsfd2', '1000', '91,70013', 0, 0, 255, 0, 1002, 'True', '1215,61', '-1525,52', '34,41', '179,6981', '[]'),
  1263. (32, 4, 'lsfd3', '1000', '84,10025', 0, 0, 255, 0, 1002, 'True', '334,96', '-541,79', '28,37', '179,3879', '[]'),
  1264. (33, 4, 'lsfd3', '1000', '94,50008', 0, 0, 255, 1, 1002, 'True', '1203,6', '-1489,86', '34,35', '307,3761', '[]'),
  1265. (34, 4, 'lsfd4', '1000', '51,30074', 0, 0, 255, 0, 1002, 'True', '1192,18', '-1546,46', '39,41', '359,9901', '[]'),
  1266. (35, 4, 'lsfd4', '1000', '89,10017', 0, 0, 255, 1, 1002, 'True', '1196,81', '-1480,19', '34,85', '0,0402832', '[]'),
  1267. (36, 4, 'lsfd5', '1000', '88,70017', 0, 0, 255, 0, 1002, 'True', '1219,16', '-1524,38', '34,36', '3,269958', '[]'),
  1268. (37, 4, 'lsfdtruck', '1000', '100', 0, 0, 255, 1, 1002, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null'),
  1269. (38, 4, 'lsfdtruck', '1000', '98,30003', 0, 0, 255, 1, 1002, 'True', '1203,37', '-1490,5', '34,83', '177,6132', '[]'),
  1270. (39, 4, 'lsfdtruck', '1000', '100', 0, 0, 255, 1, 1002, 'True', '1204,73', '-1468,35', '34,93', '359,9793', 'null'),
  1271. (40, 4, 'lsfdtruck2', '1000', '100', 0, 0, 255, 1, 1002, 'True', '1195,79', '-1491,96', '35,02', '179,5983', '[]'),
  1272. (41, 4, 'lsfdtruck3', '1000', '71,00044', 0, 0, 255, 1, 1002, 'True', '1199,59', '-1491,84', '34,8', '179,6813', '[]'),
  1273. (42, 1, 'riot', '1000', '85,40022', 0, 0, 255, 0, 1017, 'False', '462,43', '-1014,85', '27,74', '92,45425', '[]'),
  1274. (43, 1, 'riot2', '1000', '81,10029', 0, 0, 255, 0, 1015, 'False', '453,14', '-1025,43', '28,35', '89,1333', '[]'),
  1275. (44, 4, 'lsfdtruck', '1000', '100', 0, 0, 255, 1, 1018, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null'),
  1276. (45, 4, 'lsfdtruck', '1000', '100', 0, 0, 255, 0, 1018, 'False', '-635,09', '-113,49', '38,1', '84,91574', '[]'),
  1277. (46, 4, 'lsfdtruck', '1000', '100', 0, 0, 255, 1, 1018, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null'),
  1278. (47, 4, 'lsfdtruck', '1000', '100', 0, 0, 255, 1, 1018, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null'),
  1279. (48, 4, 'lsfdtruck2', '1000', '100', 0, 0, 255, 1, 1018, 'False', '-632,54', '-97,62', '38,38', '84,25839', 'null'),
  1280. (49, 4, 'lsfdtruck2', '1000', '100', 0, 0, 255, 1, 1018, 'True', '-638,35', '-104,76', '38,04', '94,78943', 'null'),
  1281. (50, 4, 'lsfdtruck3', '1000', '100', 0, 0, 255, 1, 1018, 'True', '-638,35', '-104,76', '38,04', '94,78943', '[]'),
  1282. (51, 4, 'lsfdtruck3', '1000', '100', 0, 0, 255, 1, 1018, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null'),
  1283. (52, 4, 'lsfd', '1000', '100', 0, 0, 255, 1, 1018, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null'),
  1284. (53, 4, 'lsfd', '1000', '100', 0, 0, 255, 1, 1019, 'True', '207,59', '-1673,36', '29,41', '139,6198', 'null'),
  1285. (54, 4, 'lsfd2', '1000', '100', 0, 0, 255, 1, 1019, 'True', '197,83', '-1667,37', '29,8', '139,0015', 'null'),
  1286. (55, 4, 'lsfd3', '1000', '99,50001', 0, 0, 255, 0, 1012, 'True', '1200,7', '-1478,85', '34,48', '0,6375122', '[]'),
  1287. (56, 4, 'lsfd4', '1000', '85,70022', 0, 0, 255, 0, 1012, 'True', '-43,59', '1878,57', '196,28', '167,7517', '[]'),
  1288. (57, 4, 'lsfd5', '748,754', '100', 0, 0, 255, 1, 1019, 'False', '197,05', '-1664,9', '29,47', '1,27475', 'null'),
  1289. (58, 4, 'lsfd5', '1000', '100', 0, 0, 255, 1, 1019, 'True', '194,53', '-1670,08', '29,47', '225,6304', 'null'),
  1290. (59, 4, 'NEF-1', '1000', '91,90013', 0, 0, 255, 0, 1002, 'True', '1185,33', '-1547,04', '39,34', '359,7902', '[]'),
  1291. (60, 4, 'NEF-1', '1000', '99,8', 0, 0, 255, 0, 1002, 'True', '1189,01', '-1547,04', '39,34', '359,4524', '[]'),
  1292. (79, 1, 'policet', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null'),
  1293. (61, 0, 'hotknife', '1000', '100', 4, 0, 255, 0, 0, 'False', '924,04', '-968,33', '44,47', '0', '[]'),
  1294. (62, 0, 'hotknife', '1000', '100', 4, 0, 255, 0, 0, 'False', '93129', '-968,33', '44,47', '0', '[]'),
  1295. (69, 8, 'dubsta2', '1000', '100', 0, 0, 255, 1, 1025, 'True', '-1524,77', '82,46', '56,55', '7,031225', 'null'),
  1296. (63, 10004, 'Blista2', '1000', '100', 4, 0, 255, 1, 1032, 'False', '621,77', '281,49', '102,59', '308,4686', 'null'),
  1297. (64, 10004, 'felon', '1000', '86,7002', 43, 0, 255, 0, 1032, 'False', '1368,17', '1155,23', '113,45', '55,5054', '[]'),
  1298. (65, 10005, 'sentinel2', '1000', '100', 140, 0, 255, 0, 1010, 'False', '223,36', '-127,83', '63,16', '244,8822', '[]'),
  1299. (66, 10001, 'Rhapsody', '1000', '100', 4, 0, 255, 0, 0, 'False', '-328,35', '299,3', '85,9', '94,89725', '[]'),
  1300. (67, 10006, 't20', '1000', '100', 0, 0, 255, 0, 1009, 'False', '-1535,68', '85,41', '56,35', '324,6274', '[]'),
  1301. (68, 8, 'volatus', '1000', '91,00014', 0, 0, 255, 1, 1026, 'True', '-1542,94', '80,27', '61,97', '230,7121', 'null'),
  1302. (70, 8, 'dubsta2', '1000', '100', 0, 0, 255, 1, 1025, 'True', '0,0', '0,0', '0,0', '0,0', 'null'),
  1303. (74, 8, 'neon', '1000', '100', 0, 0, 255, 1, 1025, 'True', '-1524,77', '82,46', '56,55', '7,031225', 'null'),
  1304. (71, 8, 'dubsta2', '1000', '100', 0, 0, 255, 1, 1025, 'True', '0,0', '0,0', '0,0', '0,0', 'null'),
  1305. (72, 8, 'dubsta2', '1000', '100', 0, 0, 255, 1, 1025, 'True', '0,0', '0,0', '0,0', '0,0', 'null'),
  1306. (75, 8, 'neon', '1000', '100', 0, 0, 255, 1, 1025, 'True', '0,0', '0,0', '0,0', '0,0', 'null'),
  1307. (76, 8, 'neon', '1000', '100', 0, 0, 255, 1, 1025, 'True', '0,0', '0,0', '0,0', '0,0', 'null'),
  1308. (77, 8, 'neon', '1000', '100', 0, 0, 255, 1, 1025, 'True', '0,0', '0,0', '0,0', '0,0', 'null'),
  1309. (78, 8, 'neon', '1000', '100', 0, 0, 255, 1, 1025, 'True', '-1524,77', '82,46', '56,55', '7,031225', 'null'),
  1310. (80, 1, 'policet', '1000', '100', 131, 12, 255, 1, 1014, 'True', '436,39', '-997,44', '25,76', '175,9671', 'null'),
  1311. (81, 1, 'pranger', '1000', '92,40012', 131, 12, 255, 1, 1014, 'True', '447,51', '-999,06', '25,36', '358,4232', 'null'),
  1312. (82, 1, 'pranger', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null'),
  1313. (83, 1, 'sheriff', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null'),
  1314. (84, 1, 'sheriff', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null'),
  1315. (85, 1, 'sheriff2', '619,2949', '97,20004', 131, 0, 255, 1, 1014, 'True', '437,12', '-1012,69', '28,29', '89,50476', 'null'),
  1316. (86, 1, 'sheriff2', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null'),
  1317. (87, 1, 'policeb', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null'),
  1318. (88, 1, 'policeb', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null'),
  1319. (89, 1, 'policeb', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null'),
  1320. (90, 1, 'police', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null'),
  1321. (91, 1, 'police', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null'),
  1322. (92, 1, 'police2', '1000', '97,90003', 131, 0, 255, 1, 1014, 'True', '431,33', '-1026,36', '28,51', '359,7169', 'null'),
  1323. (93, 1, 'police2', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null'),
  1324. (94, 1, 'police3', '-3082,056', '19,50099', 131, 0, 255, 1, 1014, 'True', '451,68', '-1006,29', '27,31', '272,9483', 'null'),
  1325. (95, 1, 'police3', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null'),
  1326. (96, 1, 'police4', '1000', '100', 131, 0, 255, 1, 1014, 'True', '436,39', '-997,44', '25,76', '175,9671', 'null'),
  1327. (97, 1, 'police4', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null'),
  1328. (98, 1, 'pbus', '1000', '100', 131, 12, 255, 1, 1015, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null'),
  1329. (99, 4, 'blazer2', '1000', '90,19977', 111, 0, 255, 1, 1038, 'True', '-1205,43', '-1799', '3,94', '68,61', '[]'),
  1330. (100, 4, 'lguard', '1000', '66,35006', 111, 0, 255, 1, 1038, 'True', '-1205,43', '-1799', '3,94', '68,61', '[]'),
  1331. (101, 10008, 'cogcabrio', '1000', '54,3007', 4, 0, 255, 0, 1027, 'True', '-532,73', '267,42', '82,39', '320,2188', '[]'),
  1332. (102, 2, 'fibp', '1000', '-0,09904572', 4, 0, 255, 0, 1024, 'True', '-156,92', '-1512,4', '33,35', '227,6397', '[]'),
  1333. (103, 3, 'barracks3', '1000', '95,50007', 4, 0, 255, 1, 1023, 'True', '-2409,67', '3332,1', '32,83', '237,1624', '[]'),
  1334. (104, 3, 'james', '1000', '2000', 4, 0, 255, 0, 1037, 'True', '524,73', '-3315,43', '-0,84', '182,7323', '[]'),
  1335. (105, 10001, 'schlagen', '1000', '5,319267', 4, 0, 255, 0, 1009, 'True', '-1677,36', '-301,13', '51,1', '55,28082', '[]');
  1336.  
  1337. --
  1338. -- Indizes der exportierten Tabellen
  1339. --
  1340.  
  1341. --
  1342. -- Indizes für die Tabelle `atms`
  1343. --
  1344. ALTER TABLE `atms`
  1345.   ADD PRIMARY KEY (`id`) USING BTREE;
  1346.  
  1347. --
  1348. -- Indizes für die Tabelle `banks`
  1349. --
  1350. ALTER TABLE `banks`
  1351.   ADD PRIMARY KEY (`id`) USING BTREE;
  1352.  
  1353. --
  1354. -- Indizes für die Tabelle `blips`
  1355. --
  1356. ALTER TABLE `blips`
  1357.   ADD PRIMARY KEY (`id`) USING BTREE;
  1358.  
  1359. --
  1360. -- Indizes für die Tabelle `buildingdoors`
  1361. --
  1362. ALTER TABLE `buildingdoors`
  1363.   ADD PRIMARY KEY (`id`) USING BTREE;
  1364.  
  1365. --
  1366. -- Indizes für die Tabelle `cardealers`
  1367. --
  1368. ALTER TABLE `cardealers`
  1369.   ADD PRIMARY KEY (`id`) USING BTREE;
  1370.  
  1371. --
  1372. -- Indizes für die Tabelle `clothingcatalogue`
  1373. --
  1374. ALTER TABLE `clothingcatalogue`
  1375.   ADD PRIMARY KEY (`id`) USING BTREE;
  1376.  
  1377. --
  1378. -- Indizes für die Tabelle `clothingstores`
  1379. --
  1380. ALTER TABLE `clothingstores`
  1381.   ADD PRIMARY KEY (`id`) USING BTREE;
  1382.  
  1383. --
  1384. -- Indizes für die Tabelle `dealercars`
  1385. --
  1386. ALTER TABLE `dealercars`
  1387.   ADD PRIMARY KEY (`id`) USING BTREE;
  1388.  
  1389. --
  1390. -- Indizes für die Tabelle `fractionbanks`
  1391. --
  1392. ALTER TABLE `fractionbanks`
  1393.   ADD PRIMARY KEY (`id`) USING BTREE;
  1394.  
  1395. --
  1396. -- Indizes für die Tabelle `garages`
  1397. --
  1398. ALTER TABLE `garages`
  1399.   ADD PRIMARY KEY (`id`) USING BTREE;
  1400.  
  1401. --
  1402. -- Indizes für die Tabelle `gaspumps`
  1403. --
  1404. ALTER TABLE `gaspumps`
  1405.   ADD PRIMARY KEY (`id`) USING BTREE;
  1406.  
  1407. --
  1408. -- Indizes für die Tabelle `gasstations`
  1409. --
  1410. ALTER TABLE `gasstations`
  1411.   ADD PRIMARY KEY (`id`) USING BTREE;
  1412.  
  1413. --
  1414. -- Indizes für die Tabelle `hinterzimmerjhonny`
  1415. --
  1416. ALTER TABLE `hinterzimmerjhonny`
  1417.   ADD PRIMARY KEY (`id`) USING BTREE;
  1418.  
  1419. --
  1420. -- Indizes für die Tabelle `meddropoff`
  1421. --
  1422. ALTER TABLE `meddropoff`
  1423.   ADD PRIMARY KEY (`id`) USING BTREE;
  1424.  
  1425. --
  1426. -- Indizes für die Tabelle `parkingpoints`
  1427. --
  1428. ALTER TABLE `parkingpoints`
  1429.   ADD PRIMARY KEY (`id`) USING BTREE;
  1430.  
  1431. --
  1432. -- Indizes für die Tabelle `plants`
  1433. --
  1434. ALTER TABLE `plants`
  1435.   ADD PRIMARY KEY (`id`) USING BTREE;
  1436.  
  1437. --
  1438. -- Indizes für die Tabelle `shops`
  1439. --
  1440. ALTER TABLE `shops`
  1441.   ADD PRIMARY KEY (`id`) USING BTREE;
  1442.  
  1443. --
  1444. -- Indizes für die Tabelle `vehdata`
  1445. --
  1446. ALTER TABLE `vehdata`
  1447.   ADD PRIMARY KEY (`id`) USING BTREE;
  1448.  
  1449. --
  1450. -- AUTO_INCREMENT für exportierte Tabellen
  1451. --
  1452.  
  1453. --
  1454. -- AUTO_INCREMENT für Tabelle `accounts`
  1455. --
  1456. ALTER TABLE `accounts`
  1457.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  1458.  
  1459. --
  1460. -- AUTO_INCREMENT für Tabelle `atms`
  1461. --
  1462. ALTER TABLE `atms`
  1463.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;
  1464.  
  1465. --
  1466. -- AUTO_INCREMENT für Tabelle `banks`
  1467. --
  1468. ALTER TABLE `banks`
  1469.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  1470.  
  1471. --
  1472. -- AUTO_INCREMENT für Tabelle `blips`
  1473. --
  1474. ALTER TABLE `blips`
  1475.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=112;
  1476.  
  1477. --
  1478. -- AUTO_INCREMENT für Tabelle `buildingdoors`
  1479. --
  1480. ALTER TABLE `buildingdoors`
  1481.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
  1482.  
  1483. --
  1484. -- AUTO_INCREMENT für Tabelle `cardealers`
  1485. --
  1486. ALTER TABLE `cardealers`
  1487.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  1488.  
  1489. --
  1490. -- AUTO_INCREMENT für Tabelle `clothingcatalogue`
  1491. --
  1492. ALTER TABLE `clothingcatalogue`
  1493.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=155;
  1494.  
  1495. --
  1496. -- AUTO_INCREMENT für Tabelle `clothingstores`
  1497. --
  1498. ALTER TABLE `clothingstores`
  1499.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
  1500.  
  1501. --
  1502. -- AUTO_INCREMENT für Tabelle `dealercars`
  1503. --
  1504. ALTER TABLE `dealercars`
  1505.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
  1506.  
  1507. --
  1508. -- AUTO_INCREMENT für Tabelle `fractionbanks`
  1509. --
  1510. ALTER TABLE `fractionbanks`
  1511.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  1512.  
  1513. --
  1514. -- AUTO_INCREMENT für Tabelle `fractions`
  1515. --
  1516. ALTER TABLE `fractions`
  1517.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  1518.  
  1519. --
  1520. -- AUTO_INCREMENT für Tabelle `garages`
  1521. --
  1522. ALTER TABLE `garages`
  1523.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1039;
  1524.  
  1525. --
  1526. -- AUTO_INCREMENT für Tabelle `gaspumps`
  1527. --
  1528. ALTER TABLE `gaspumps`
  1529.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=97;
  1530.  
  1531. --
  1532. -- AUTO_INCREMENT für Tabelle `gasstations`
  1533. --
  1534. ALTER TABLE `gasstations`
  1535.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
  1536.  
  1537. --
  1538. -- AUTO_INCREMENT für Tabelle `hinterzimmerjhonny`
  1539. --
  1540. ALTER TABLE `hinterzimmerjhonny`
  1541.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  1542.  
  1543. --
  1544. -- AUTO_INCREMENT für Tabelle `jobs`
  1545. --
  1546. ALTER TABLE `jobs`
  1547.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  1548.  
  1549. --
  1550. -- AUTO_INCREMENT für Tabelle `meddropoff`
  1551. --
  1552. ALTER TABLE `meddropoff`
  1553.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  1554.  
  1555. --
  1556. -- AUTO_INCREMENT für Tabelle `parkingpoints`
  1557. --
  1558. ALTER TABLE `parkingpoints`
  1559.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;
  1560.  
  1561. --
  1562. -- AUTO_INCREMENT für Tabelle `plants`
  1563. --
  1564. ALTER TABLE `plants`
  1565.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;
  1566.  
  1567. --
  1568. -- AUTO_INCREMENT für Tabelle `properties`
  1569. --
  1570. ALTER TABLE `properties`
  1571.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  1572.  
  1573. --
  1574. -- AUTO_INCREMENT für Tabelle `shops`
  1575. --
  1576. ALTER TABLE `shops`
  1577.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;
  1578.  
  1579. --
  1580. -- AUTO_INCREMENT für Tabelle `vehdata`
  1581. --
  1582. ALTER TABLE `vehdata`
  1583.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;
  1584.  
  1585. --
  1586. -- AUTO_INCREMENT für Tabelle `vehicles`
  1587. --
  1588. ALTER TABLE `vehicles`
  1589.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  1590. COMMIT;
  1591.  
  1592. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  1593. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  1594. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!