· 6 years ago · Oct 25, 2019, 05:38 PM
1/*
2 Navicat Premium Data Transfer
3
4 Source Server : PlayV
5 Source Server Type : MySQL
6 Source Server Version : 50726
7 Source Host : 94.23.160.54:3306
8 Source Schema : playvrp
9
10 Target Server Type : MySQL
11 Target Server Version : 50726
12 File Encoding : 65001
13
14 Date: 25/10/2019 19:34:07
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for accounts
22-- ----------------------------
23DROP TABLE IF EXISTS `accounts`;
24CREATE TABLE `accounts` (
25 `id` int(11) NOT NULL AUTO_INCREMENT,
26 `username` varchar(35) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
27 `password` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
28 `salt` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
29 `health` int(3) NOT NULL DEFAULT 100,
30 `armor` int(3) NOT NULL DEFAULT 0,
31 `hunger` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '100',
32 `thirst` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '100',
33 `alcoholBloodLevel` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
34 `thcBloodLevel` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
35 `cocainBloodLevel` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
36 `money` int(11) NOT NULL DEFAULT 1000,
37 `hasBankAcc` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'False',
38 `bank` int(1) NOT NULL DEFAULT 0,
39 `bankMoney` int(11) NOT NULL DEFAULT 0,
40 `telNumber` int(9) NOT NULL,
41 `level` int(4) NOT NULL DEFAULT 1,
42 `xp` int(11) NOT NULL DEFAULT 0,
43 `adminLevel` int(2) NOT NULL DEFAULT 0,
44 `adminDept` int(1) NOT NULL DEFAULT 0,
45 `job` int(2) NOT NULL DEFAULT 0,
46 `jobXP` int(11) NOT NULL DEFAULT 0,
47 `jobPoints` int(11) NOT NULL DEFAULT 0,
48 `fraction` int(2) NOT NULL DEFAULT 0,
49 `rank` int(2) NOT NULL DEFAULT 0,
50 `injury` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'none',
51 `deathTime` int(11) NOT NULL DEFAULT -1,
52 `stable` int(1) NOT NULL DEFAULT 0,
53 `isInJail` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'False',
54 `jailtime` int(11) NOT NULL DEFAULT 0,
55 `minutesToPayday` int(2) NOT NULL DEFAULT 60,
56 `minutesOnDuty` int(2) NOT NULL DEFAULT 0,
57 `onDuty` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'False',
58 `hasSocialBonus` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'False',
59 `hasBan` int(1) NOT NULL DEFAULT 0,
60 `banDuration` int(11) NOT NULL,
61 `bdate` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '01.01.1980',
62 `bplace` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'Los Santos',
63 `amLicense` int(1) NOT NULL DEFAULT 0,
64 `aLicense` int(1) NOT NULL DEFAULT 0,
65 `bLicense` int(1) NOT NULL DEFAULT 0,
66 `cLicense` int(1) NOT NULL DEFAULT 0,
67 `dLicense` int(1) NOT NULL DEFAULT 0,
68 `eLicense` int(1) NOT NULL DEFAULT 0,
69 `f1License` int(1) NOT NULL DEFAULT 0,
70 `f2License` int(1) NOT NULL DEFAULT 0,
71 `gLicense` int(1) NOT NULL DEFAULT 0,
72 `posX` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '5.5',
73 `posY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '5.5',
74 `posZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '71.5',
75 `inventory` json NOT NULL,
76 `outfit` json NOT NULL,
77 `outfit2` json NOT NULL,
78 `clothes` json NOT NULL,
79 `contacts` json NOT NULL,
80 `weaponData` json NOT NULL,
81 PRIMARY KEY (`id`) USING BTREE
82) ENGINE = MyISAM AUTO_INCREMENT = 100014 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
83
84-- ----------------------------
85-- Records of accounts
86-- ----------------------------
87INSERT INTO `accounts` VALUES (10001, 'Stanley_Johnson', 'EB58772AE0902DD71B9CA8C3BC9F1A85A2686207B1D1FDBCDCF68EBF64CA0981', 'K0I17v08LBGVcj7F', 95, 0, '0', '0', '0', '0', '0', 4231, 'True', 1, 402476, 761555420, 1, 19100, 7, 4, 2, 1150, 0, 4, 12, 'none', -1, -1, 'False', 0, 59, 1, 'True', 'True', 0, 0, '12.06.1997', 'Davis', 1, 1, 1, 1, 1, 1, 1, 1, 1, '1784,06', '3319,31', '41,45', '[{\"Key\": \"item_firstaid\", \"Name\": \"Verbandskasten\", \"Price\": 50, \"Weight\": 0.3, \"Quantity\": 11, \"Description\": \"Verbinde deine Wunden mit dem Verbandskasten.\"}, {\"Key\": \"item_radio\", \"Name\": \"Funkgerät\", \"Price\": 150, \"Weight\": 0.3, \"Quantity\": 10, \"Description\": \"Damit kannst du dich über weite Entfernungen unterhalten.\"}, {\"Key\": \"item_cannabush\", \"Name\": \"Cannabisstrauch\", \"Price\": 0, \"Weight\": 0.75, \"Quantity\": 1, \"Description\": \"Ein frischer Busch mit Cannabisblüten.\"}, {\"Key\": \"item_water\", \"Name\": \"Mineralwasser\", \"Price\": 1, \"Weight\": 0.5, \"Quantity\": 5, \"Description\": \"Ein stilles Mineralwasser für den Kreislauf.\"}, {\"Key\": \"item_repkit\", \"Name\": \"Reperatur Kit\", \"Price\": 75, \"Weight\": 0.5, \"Quantity\": 9, \"Description\": \"Repariert die Schäden an deinem Fahrzeug.\"}]', '[[4, 17, 9], [8, 15, 0], [10, 0, 0], [6, 16, 5], [7, 127, 0], [3, 11, 0], [5, 13, 0], [11, 3, 0]]', '[[11, 10, 0], [7, 6, 0], [6, 17, 0], [8, 17, 0], [4, 27, 9], [10, 0, 0]]', '[[4, 55, 0], [11, 17, 4], [11, 38, 4], [3, 11, 0], [11, 80, 0], [11, 80, 1], [11, 80, 2], [11, 253, 25]]', '[[\"Test Kontakt\", \"0123456789\"], [\"Test Kontakt\", \"0123456789\"], [\"Test Kontakt\", \"0123456789\"], [\"Test Kontakt\", \"0123456789\"], [\"xxx\", \"228555265\"]]', '[]');
88INSERT INTO `accounts` VALUES (10010, 'Toku_Koru', 'EE1B61CDB4961A3E7D9B56A2A3BFA6CFD15452A1D08939DAFCA240C40987290F', 'R3IfbvoXtE0ql3QK', 90, 0, '23', '23', '0', '0', '0', 1000, 'True', 2, 20000, 158555289, 1, 100, 6, 0, 1, 150, 0, 0, 0, 'none', -1, -1, 'False', 0, 43, 0, 'False', 'False', 0, 0, '13.07.1998', 'Los Santos', 1, 1, 0, 0, 0, 0, 0, 0, 0, '28,02', '-1348,17', '29,5', '[{\"Key\": \"item_water\", \"Name\": \"Mineralwasser\", \"Price\": 1, \"Weight\": 0.5, \"Quantity\": 10, \"Description\": \"Ein stilles Mineralwasser für den Kreislauf.\"}, {\"Key\": \"item_donut\", \"Name\": \"Donut\", \"Price\": 2, \"Weight\": 0.15, \"Quantity\": 10, \"Description\": \"Ein Leckerbissen für zwischendurch.\"}]', '[[4, 3, 0], [6, 1, 1]]', '[]', '[[4, 3, 0], [6, 1, 1]]', '[]', '[]');
89INSERT INTO `accounts` VALUES (10002, 'Luca_Bernegger', '435DD43F04A35DF68EB165FCE2A80789FA2F851E65F8052E21405D1730E3AB53', 'XqxHcfFfR7JDdymB', 97, 0, '62', '63', '0', '0', '0', 13571, 'False', 0, 123, 158555281, 1, 900, 5, 0, 0, 0, 0, 0, 0, 'none', -1, -1, 'False', 0, 14, 0, 'False', 'False', 0, 0, '15.03.1997', 'Georgetown', 0, 0, 0, 0, 0, 0, 0, 0, 0, '-449,8', '-335,1', '34,5', '[{\"Key\": \"item_repkit\", \"Name\": \"Reperatur Kit\", \"Price\": 0, \"Weight\": 0.5, \"Quantity\": 1, \"Description\": \"Repariert die Schäden an deinem Fahrzeug.\"}, {\"Key\": \"item_water\", \"Name\": \"Mineralwasser\", \"Price\": 1, \"Weight\": 0.5, \"Quantity\": 4, \"Description\": \"Ein stilles Mineralwasser für den Kreislauf.\"}, {\"Key\": \"item_donut\", \"Name\": \"Donut\", \"Price\": 2, \"Weight\": 0.15, \"Quantity\": 1, \"Description\": \"Ein Leckerbissen für zwischendurch.\"}]', '[[8, 15, 0], [4, 0, 11], [3, 64, 0], [11, 253, 26]]', '[]', '[[3, 1, 0], [3, 119, 0], [4, 0, 10], [4, 0, 15], [4, 0, 11], [3, 64, 0], [11, 17, 0], [11, 34, 1]]', '[]', '[]');
90INSERT INTO `accounts` VALUES (10003, 'Michael_Kleinig', '9987B0A911E553B38179570A6DB6D9FEE6812E2A07E62879C2236F5917BF3874', 'PYL7yf3QKXtEitym', 100, 0, '0', '0', '0', '0', '0', 10000, 'True', 1, 998000, 228555265, 1, 3400, 7, 4, 1, 150, 0, 1, 0, 'Starvation', 14, 0, 'False', 0, 33, 0, 'False', 'False', 0, 0, '01.01.1980', 'Los Santos', 0, 0, 0, 0, 0, 0, 0, 0, 0, '2293,99', '-690,34', '65,37', '[{\"Key\": \"item_radio\", \"Name\": \"Funkgerät\", \"Price\": 150, \"Weight\": 0.3, \"Quantity\": 1, \"Description\": \"Damit kannst du dich über weite Entfernungen unterhalten.\"}]', '[[11, 31, 0], [3, 31, 0], [8, 33, 0], [6, 10, 0], [4, 24, 0], [1, 28, 0], [7, 38, 16]]', '[]', '[[4, 3, 0], [6, 1, 1]]', '[[\"Test Kontakt\", \"0123456789\"], [\"Test Kontakt\", \"0123456789\"], [\"Stanley\", \"761555420\"], [\"STANLEY\", \"761555420\"]]', '[]');
91INSERT INTO `accounts` VALUES (10013, 'Markus_Becker', '9987B0A911E553B38179570A6DB6D9FEE6812E2A07E62879C2236F5917BF3874', 'PYL7yf3QKXtEitym', 95, 0, '71,5', '0', '0', '0', '0', 745985, 'True', 1, 9000000, 178379091, 1, 600, 2, 0, 0, 0, 0, 1, 0, 'Starvation', 12, 0, 'False', 0, 42, 0, 'False', 'False', 0, 0, '01.01.1980', 'Los Santos', 0, 0, 0, 0, 0, 0, 0, 0, 0, '-676,65', '884,08', '225,24', '[{\"Key\": \"item_bag\", \"Name\": \"Sack\", \"Price\": 0, \"Weight\": 0.3, \"Quantity\": 3, \"Description\": \"Hat die Perfekte größe für einen Kopf.\"}, {\"Key\": \"item_radio\", \"Name\": \"Funkgerät\", \"Price\": 150, \"Weight\": 0.3, \"Quantity\": 2, \"Description\": \"Damit kannst du dich über weite Entfernungen unterhalten.\"}, {\"Key\": \"item_cola\", \"Name\": \"Cola\", \"Price\": 2, \"Weight\": 0.35, \"Quantity\": 2, \"Description\": \"Ein koffeninhaltiges Getränk zum Genuss.\"}, {\"Key\": \"item_cannabush\", \"Name\": \"Cannabisstrauch\", \"Price\": 0, \"Weight\": 0.75, \"Quantity\": 34, \"Description\": \"Ein frischer Busch mit Cannabisblüten.\"}]', '[[7, 3, 4], [1, 46, 1], [3, 0, 0], [10, 8, 1], [6, 24, 0], [11, 55, 0], [2, 0, 0], [0, 1, 0], [4, 35, 0], [8, 122, 0]]', '[]', '[[4, 3, 0], [6, 1, 1]]', '[]', '[]');
92INSERT INTO `accounts` VALUES (10004, 'Titus_Max', 'C0221D0E0E5DD5CF7AEC76EBA0F41E62756D35B7D8EA16AF5EAA20D1E3AD9B3D', 't0agcYaDwp9zGXuP', 98, 0, '6', '64', '0', '0', '0', 99, 'True', 2, 264119, 176555113, 1, 2100, 7, 3, 0, 0, 0, 1, 12, 'none', -1, -1, 'False', 0, 16, 0, 'False', 'True', 0, 0, '13.10.1977', 'North Yankton', 1, 1, 1, 0, 1, 1, 1, 0, 1, '402,13', '-983,08', '29,41', '[{\"Key\": \"item_handcuffs\", \"Name\": \"Handfesseln\", \"Price\": 0, \"Weight\": 0.3, \"Quantity\": 22, \"Description\": \"Damit lassen sich Personen fesseln.\"}, {\"Key\": \"item_cola\", \"Name\": \"Cola\", \"Price\": 2, \"Weight\": 0.35, \"Quantity\": 10, \"Description\": \"Ein koffeninhaltiges Getränk zum Genuss.\"}, {\"Key\": \"item_water\", \"Name\": \"Mineralwasser\", \"Price\": 1, \"Weight\": 0.5, \"Quantity\": 2, \"Description\": \"Ein stilles Mineralwasser für den Kreislauf.\"}]', '[[3, 11, 0], [7, 125, 0], [10, 8, 1], [8, 122, 0], [11, 13, 0], [6, 27, 0], [4, 4, 0]]', '[]', '[[4, 3, 0], [6, 1, 1]]', '[]', '[]');
93INSERT INTO `accounts` VALUES (10005, 'Justin_Schweitzer', '', '', 100, 0, '100', '100', '0', '0', '0', 30001, 'False', 0, 0, 158555284, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'none', -1, -1, 'False', 0, 16, 0, 'False', 'False', 0, 0, '01.01.1980', 'Los Santos', 0, 0, 0, 0, 0, 0, 0, 0, 0, '-429,67', '1125,78', '325,91', '[]', '[[4, 3, 0], [6, 1, 1]]', '[]', '[[4, 3, 0], [6, 1, 1]]', '[]', '[]');
94INSERT INTO `accounts` VALUES (10007, 'WeirdNewbie', '', '', 75, 0, '100', '100', '0', '0', '0', 1000, 'False', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'none', -1, -1, 'False', 0, 1, 0, 'False', 'False', 0, 0, '01.01.1980', 'Los Santos', 0, 0, 0, 0, 0, 0, 0, 0, 0, '409,77', '-994,57', '29,27', '[]', '[]', '[]', '[]', '[]', '[]');
95INSERT INTO `accounts` VALUES (10006, 'Emily_Santoro', '21C2029C98B8C5C1B4FCD0C015ECABD05A63A360966DABA9E5F81BEBA99044E6', 'd2te8cB6qggVxklE', 48, 0, '100', '100', '0', '0', '0', 7001, 'True', 1, 51000, 555555555, 1, 200, 4, 0, 0, 0, 0, 8, 12, 'none', -1, -1, 'False', 0, 33, 0, 'False', 'True', 0, 0, '27.07.2000', 'Agira', 1, 0, 1, 0, 0, 0, 0, 0, 0, '-629,32', '840,55', '242,18', '[{\"Key\": \"item_firstaid\", \"Name\": \"Verbandskasten\", \"Weight\": 0, \"Quantity\": 2, \"Description\": \"Verbinde deine Wunden mit dem Verbandskasten.\"}, {\"Key\": \"item_bodyarmor\", \"Name\": \"Beschusshemmende Weste\", \"Weight\": 0, \"Quantity\": 7, \"Description\": \"Die beschusshemmende Weste kann dir in einem Feuergefecht den entscheidenden Vorteil bringen.\"}]', '[[4, 3, 0], [6, 1, 1]]', '[]', '[[4, 3, 0], [6, 1, 1]]', '[]', '[]');
96INSERT INTO `accounts` VALUES (10008, 'Patrick_DeRain', 'ED8425077920EE02FDF10724CD1A5D02497371BB38E5FAD6765001C4D20F8116', 'ufpwiKroYgSA6mXX', 95, 0, '0', '34,5', '0', '0', '0', 250, 'True', 1, 137674, 815555273, 1, 1900, 0, 0, 3, 0, 0, 2, 12, 'BrokenBones', 19, 0, 'False', 0, 25, 35, 'True', 'False', 0, 0, '01.01.1980', 'Los Santos', 0, 0, 0, 0, 0, 0, 0, 0, 0, '58,1', '-790,51', '31,58', '[{\"Key\": \"item_water\", \"Name\": \"Mineralwasser\", \"Price\": 1, \"Weight\": 0.5, \"Quantity\": 7, \"Description\": \"Ein stilles Mineralwasser für den Kreislauf.\"}, {\"Key\": \"item_radio\", \"Name\": \"Funkgerät\", \"Price\": 150, \"Weight\": 0.3, \"Quantity\": 1, \"Description\": \"Damit kannst du dich über weite Entfernungen unterhalten.\"}, {\"Key\": \"item_fuelcane\", \"Name\": \"Leerer Benzinkanister\", \"Price\": 20, \"Weight\": 0.35, \"Quantity\": 2, \"Description\": \"Dieser Kanister kann mit Benzin gefüllt werden.\"}]', '[[11, 31, 0], [3, 31, 0], [8, 33, 0], [4, 24, 0], [1, 0, 0], [7, 125, 0], [6, 10, 0]]', '[]', '[[3, 0, 0], [4, 3, 0], [6, 1, 1]]', '[[\"Test Kontakt\", \"0123456789\"], [\"Michael Kleinig (DOJ)\", \"228555284\"], [\"Stanley Johnson (LSMC)\", \"761555420\"], [\"Test Kontakt\", \"0123456789\"], [\"Test Kontakt\", \"0123456789\"]]', '[]');
97INSERT INTO `accounts` VALUES (10009, 'Mason_Brown', '0A81ABAC908B7122AE4A0A40452A3380DC9378665B35B6B74187EF7DCE51684A', 'bvmdg40qRl3oIT7I', 63, 0, '33', '63,5', '0', '0', '0', 5740, 'True', 1, 83328, 158555288, 1, 1100, 2, 0, 0, 0, 0, 3, 12, 'none', -1, -1, 'False', 0, 37, 23, 'True', 'False', 0, 0, '24.07.1978', 'Lakeside', 0, 0, 0, 0, 0, 0, 0, 0, 0, '2884,69', '3604,56', '52,8', '[{\"Key\": \"item_radio\", \"Name\": \"Funkgerät\", \"Price\": 150, \"Weight\": 0.3, \"Quantity\": 1, \"Description\": \"Damit kannst du dich über weite Entfernungen unterhalten.\"}, {\"Key\": \"item_firstaid\", \"Name\": \"Verbandskasten\", \"Price\": 50, \"Weight\": 0.3, \"Quantity\": 7, \"Description\": \"Verbinde deine Wunden mit dem Verbandskasten.\"}, {\"Key\": \"item_water\", \"Name\": \"Mineralwasser\", \"Price\": 1, \"Weight\": 0.5, \"Quantity\": 4, \"Description\": \"Ein stilles Mineralwasser für den Kreislauf.\"}, {\"Key\": \"item_donut\", \"Name\": \"Donut\", \"Price\": 2, \"Weight\": 0.15, \"Quantity\": 4, \"Description\": \"Ein Leckerbissen für zwischendurch.\"}]', '[[10, 0, 0], [6, 25, 0], [11, 13, 2], [3, 11, 0], [7, 125, 0], [8, 122, 0], [4, 0, 12]]', '[[4, 0, 6], [3, 0, 0], [11, 222, 3], [10, 0, 0]]', '[[4, 0, 2], [4, 0, 12], [4, 0, 12], [4, 3, 0], [6, 1, 1]]', '[]', '[]');
98INSERT INTO `accounts` VALUES (10011, 'Stuart_Russell', '115A8F872E5E6EE9B18DF6D52C519DD650BB4AF687EC0DE00F913FC480DE0852', '9P7mbe2agcfBjqhd', 100, 0, '100', '100', '0', '0', '0', 35000, 'False', 0, 0, 241555487, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'none', -1, 0, 'False', 0, 60, 0, 'False', 'False', 0, 0, '24.10.1989', 'Dallas', 1, 0, 1, 0, 0, 0, 0, 0, 0, '-1044.98', '-2750.43', '21.37', '[]', '[[4, 3, 0], [6, 1, 1]]', '[]', '[[4, 3, 0], [6, 1, 1]]', '[]', '[]');
99INSERT INTO `accounts` VALUES (10012, 'Stan_Smith', '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]]', '[]', '[]');
100INSERT INTO `accounts` VALUES (10014, 'Kevin_Summer', '9987B0A911E553B38179570A6DB6D9FEE6812E2A07E62879C2236F5917BF3874', 'PYL7yf3QKXtEitym', 100, 0, '100', '100', '0', '0', '0', 10000000, 'False', 0, 0, 87585574, 1, 0, 2, 0, 0, 0, 0, 0, 0, 'none', -1, 0, 'False', 0, 60, 0, 'False', 'False', 0, 0, '01.01.1980', 'Los Santos', 0, 0, 0, 0, 0, 0, 0, 0, 0, '-135,13', '-900,89', '29,15', '[{\"Key\": \"item_repkit\", \"Name\": \"Reperatur Kit\", \"Price\": 0, \"Weight\": 0.5, \"Quantity\": 1, \"Description\": \"Repariert die Schäden an deinem Fahrzeug.\"}, {\"Key\": \"item_bag\", \"Name\": \"Sack\", \"Price\": 0, \"Weight\": 0.3, \"Quantity\": 5, \"Description\": \"Hat die Perfekte größe für einen Kopf.\"}, {\"Key\": \"item_radio\", \"Name\": \"Funkgerät\", \"Price\": 150, \"Weight\": 0.3, \"Quantity\": 1, \"Description\": \"Damit kannst du dich über weite Entfernungen unterhalten.\"}]', '[[11, 31, 0], [3, 31, 0], [8, 33, 0], [6, 10, 0], [4, 24, 0], [1, 28, 0]]', '[]', '[[4, 3, 0], [6, 1, 1]]', '[]', '[]');
101INSERT INTO `accounts` VALUES (10015, 'Alessio_Corleone', '9987B0A911E553B38179570A6DB6D9FEE6812E2A07E62879C2236F5917BF3874', 'PYL7yf3QKXtEitym', 100, 0, '11,5', '56,5', '0', '0', '0', 9659155, 'False', 0, 0, 1526124, 1, 200, 2, 0, 0, 0, 0, 0, 0, 'none', -1, -1, 'False', 0, 3, 0, 'False', 'False', 0, 0, '01.01.1980', 'Los Santos', 0, 0, 0, 0, 0, 0, 0, 0, 0, '447,75', '-978,6', '30,69', '[{\"Key\": \"item_bag\", \"Name\": \"Sack\", \"Price\": 0, \"Weight\": 0.3, \"Quantity\": 4, \"Description\": \"Hat die Perfekte größe für einen Kopf.\"}, {\"Key\": \"item_radio\", \"Name\": \"Funkgerät\", \"Price\": 150, \"Weight\": 0.3, \"Quantity\": 1, \"Description\": \"Damit kannst du dich über weite Entfernungen unterhalten.\"}, {\"Key\": \"item_water\", \"Name\": \"Mineralwasser\", \"Price\": 1, \"Weight\": 0.5, \"Quantity\": 13, \"Description\": \"Ein stilles Mineralwasser für den Kreislauf.\"}, {\"Key\": \"item_beer\", \"Name\": \"Bier\", \"Price\": 5, \"Weight\": 0.6, \"Quantity\": 2, \"Description\": \"Ein kühles Bier zum genießen und erfrischen.\"}]', '[[11, 31, 0], [3, 31, 0], [8, 33, 0], [6, 10, 0], [4, 24, 0], [1, 28, 0]]', '[]', '[[4, 3, 0], [6, 1, 1]]', '[]', '[]');
102
103-- ----------------------------
104-- Table structure for atms
105-- ----------------------------
106DROP TABLE IF EXISTS `atms`;
107CREATE TABLE `atms` (
108 `id` int(11) NOT NULL AUTO_INCREMENT,
109 `bank` int(1) NOT NULL,
110 `posX` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
111 `posY` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
112 `posZ` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
113 PRIMARY KEY (`id`) USING BTREE
114) ENGINE = MyISAM AUTO_INCREMENT = 35 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
115
116-- ----------------------------
117-- Records of atms
118-- ----------------------------
119INSERT INTO `atms` VALUES (1, 2, '238,2985', '215,8825', '106,2868');
120INSERT INTO `atms` VALUES (2, 2, '285,6497', '143,754', '104,1714');
121INSERT INTO `atms` VALUES (3, 2, '237,458', '217,8258', '106,2868');
122INSERT INTO `atms` VALUES (4, 2, '236,4734', '219,7039', '106,2868');
123INSERT INTO `atms` VALUES (5, 1, '145,9562', '-1035,07', '29,34493');
124INSERT INTO `atms` VALUES (6, 1, '147,5776', '-1035,684', '29,34313');
125INSERT INTO `atms` VALUES (7, 2, '24,4623', '-945,9905', '29,35756');
126INSERT INTO `atms` VALUES (8, 2, '5,242511', '-919,8077', '29,55954');
127INSERT INTO `atms` VALUES (9, 3, '-203,7859', '-861,3891', '30,26763');
128INSERT INTO `atms` VALUES (10, 3, '-254,3345', '-692,4426', '33,6103');
129INSERT INTO `atms` VALUES (11, 3, '-256,2151', '-716,2308', '33,51609');
130INSERT INTO `atms` VALUES (12, 3, '-258,7664', '-723,3732', '33,46457');
131INSERT INTO `atms` VALUES (13, 3, '119,1495', '-883,6396', '31,12308');
132INSERT INTO `atms` VALUES (14, 3, '112,6922', '-819,3987', '31,33744');
133INSERT INTO `atms` VALUES (15, 3, '111,1151', '-775,5048', '31,43859');
134INSERT INTO `atms` VALUES (16, 3, '114,5756', '-776,4779', '31,41672');
135INSERT INTO `atms` VALUES (17, 2, '-2072,803', '-317,2693', '13,31597');
136INSERT INTO `atms` VALUES (18, 3, '-2975,04', '380,0625', '14,99889');
137INSERT INTO `atms` VALUES (19, 3, '-2959,016', '487,8256', '15,46392');
138INSERT INTO `atms` VALUES (20, 3, '-2956,845', '487,7185', '15,46392');
139INSERT INTO `atms` VALUES (21, 3, '-3241,13', '997,502', '12,5504');
140INSERT INTO `atms` VALUES (22, 2, '295,7563', '-896,1332', '29,21983');
141INSERT INTO `atms` VALUES (23, 2, '296,4652', '-894,1866', '29,23101');
142INSERT INTO `atms` VALUES (24, 3, '-303,3651', '-829,8547', '32,41724');
143INSERT INTO `atms` VALUES (25, 3, '-301,6258', '-830,0173', '32,41726');
144INSERT INTO `atms` VALUES (26, 2, '527,225', '-160,7883', '57,08646');
145INSERT INTO `atms` VALUES (27, 1, '-56,93454', '-1752,058', '29,42101');
146INSERT INTO `atms` VALUES (28, 2, '418,8717', '-970,9462', '29,42178');
147INSERT INTO `atms` VALUES (29, 3, '380,9012', '323,4257', '103,5664');
148INSERT INTO `atms` VALUES (30, 3, '33,34349', '-1348,159', '29,49702');
149INSERT INTO `atms` VALUES (31, 2, '264,7929', '210,9631', '106,2832');
150INSERT INTO `atms` VALUES (32, 2, '265,4444', '213,0442', '106,2832');
151INSERT INTO `atms` VALUES (33, 2, '-821,6531', '-1082,013', '11,13243');
152INSERT INTO `atms` VALUES (34, 2, '2558,844', '351,0537', '108,6214');
153
154-- ----------------------------
155-- Table structure for banks
156-- ----------------------------
157DROP TABLE IF EXISTS `banks`;
158CREATE TABLE `banks` (
159 `id` int(11) NOT NULL AUTO_INCREMENT,
160 `bank` int(1) NOT NULL DEFAULT 1,
161 `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
162 `posX` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
163 `posY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
164 `posZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
165 PRIMARY KEY (`id`) USING BTREE
166) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
167
168-- ----------------------------
169-- Records of banks
170-- ----------------------------
171INSERT INTO `banks` VALUES (1, 1, 'Fleeca Bank Pillbox Hill', '149,82', '-1040,65', '29,37');
172INSERT INTO `banks` VALUES (2, 1, 'Pacific Standard Public Deposit', '242,29', '225,07', '106,28');
173INSERT INTO `banks` VALUES (3, 2, 'Pacific Standard Public Deposit', '247,56', '223,17', '106,28');
174INSERT INTO `banks` VALUES (4, 3, 'Pacific Standard Public Deposit', '252,64', '221,41', '106,28');
175
176-- ----------------------------
177-- Table structure for blips
178-- ----------------------------
179DROP TABLE IF EXISTS `blips`;
180CREATE TABLE `blips` (
181 `id` int(11) NOT NULL AUTO_INCREMENT,
182 `alpha` int(11) NULL DEFAULT 255,
183 `color` int(11) NULL DEFAULT NULL,
184 `dimension` int(11) NULL DEFAULT 0,
185 `drawDistance` int(11) NULL DEFAULT 0,
186 `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
187 `rotation` int(11) NULL DEFAULT 0,
188 `scale` float NULL DEFAULT 1,
189 `posX` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
190 `posY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
191 `posZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
192 `sprite` int(11) NULL DEFAULT NULL,
193 PRIMARY KEY (`id`) USING BTREE
194) ENGINE = MyISAM AUTO_INCREMENT = 112 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
195
196-- ----------------------------
197-- Records of blips
198-- ----------------------------
199INSERT INTO `blips` VALUES (1, 255, 1, 0, 0, 'St. Fiacre Hospital', 0, 1, '1122,58', '-1523,36', '34,8377', 61);
200INSERT INTO `blips` VALUES (2, 255, 3, 0, 0, 'La Mesa Police Department', 0, 1, '827,295', '-1290,03', '28,2407', 60);
201INSERT INTO `blips` VALUES (3, 255, 3, 0, 0, 'Davis Sheriff\'s Station', 0, 1, '361,003', '-1584,7', '29,2919', 60);
202INSERT INTO `blips` VALUES (4, 255, 3, 0, 0, 'Mission Row Police Department', 0, 1, '434,101', '-981,898', '30,7093', 60);
203INSERT INTO `blips` VALUES (5, 255, 1, 0, 0, 'Central Los Santos Medical Center', 0, 1, '343,097', '-1398,25', '32,5093', 61);
204INSERT INTO `blips` VALUES (6, 255, 10, 0, 0, 'Gericht', 0, 1, '337,41', '-1562,38', '30,298', 541);
205INSERT INTO `blips` VALUES (7, 255, 1, 0, 0, 'Davis Fire Station', 0, 1, '199,427', '-1634,58', '29,8032', 436);
206INSERT INTO `blips` VALUES (8, 255, 3, 0, 0, 'Vespucci Police Department', 0, 1, '-1093,04', '-809,747', '19,2779', 60);
207INSERT INTO `blips` VALUES (9, 255, 1, 0, 0, 'Sandy Shores Medical Center', 0, 1, '1838,87', '3673,69', '34,2767', 61);
208INSERT INTO `blips` VALUES (10, 255, 3, 0, 0, 'Sandy Shores Sheriff\'s Station', 0, 1, '1853,46', '3687,92', '34,2671', 60);
209INSERT INTO `blips` VALUES (11, 255, 1, 0, 0, 'Rockford Hills Fire Station', 0, 1, '-634,689', '-124,112', '39,0138', 436);
210INSERT INTO `blips` VALUES (12, 255, 1, 0, 0, 'Sandy Shores Fire Station', 0, 1, '1696,55', '3586,15', '35,6209', 436);
211INSERT INTO `blips` VALUES (13, 255, 1, 0, 0, 'Mount Zonah Medical Center', 0, 1, '-447,965', '-340,971', '34,5018', 61);
212INSERT INTO `blips` VALUES (14, 255, 4, 0, 0, 'Sandy Shores Flugzeughangar', 0, 1, '1732,05', '3310,09', '40,7205', 557);
213INSERT INTO `blips` VALUES (15, 255, 4, 0, 0, 'Grapeseed Flugzeughangar', 0, 1, '2134,76', '4780,97', '40,4672', 557);
214INSERT INTO `blips` VALUES (16, 255, 1, 0, 0, 'The Bay Care Center', 0, 1, '-246,027', '6329,15', '32,4262', 61);
215INSERT INTO `blips` VALUES (17, 255, 1, 0, 0, 'Los Santos International Airport Fire Station', 0, 1, '-1095,63', '-2363,26', '14,0237', 436);
216INSERT INTO `blips` VALUES (18, 255, 3, 0, 0, 'Los Santos County Sheriff', 0, 1, '-441,258', '6018,42', '31,5588', 60);
217INSERT INTO `blips` VALUES (19, 255, 4, 0, 0, 'Los Santos International Airport Flugzeughangar', 0, 1, '-990,39', '-3000,74', '13,9474', 557);
218INSERT INTO `blips` VALUES (20, 255, 4, 0, 0, 'Vanilla Unicorn', 0, 1, '128,447', '-1298,57', '29,2327', 121);
219INSERT INTO `blips` VALUES (21, 255, 4, 0, 0, 'Binco', 0, 1, '-822,323', '-1073,66', '11,3281', 73);
220INSERT INTO `blips` VALUES (23, 255, 25, 0, 0, 'Fleeca Bank', 0, 1, '149,472', '-1040,57', '29,3741', 207);
221INSERT INTO `blips` VALUES (25, 255, 25, 0, 0, 'Fleeca Bank', 0, 1, '314,124', '-278,739', '54,1708', 207);
222INSERT INTO `blips` VALUES (26, 255, 25, 0, 0, 'Fleeca Bank', 0, 1, '-2962,59', '482,452', '15,7031', 207);
223INSERT INTO `blips` VALUES (28, 255, 4, 0, 0, 'Pacific Standard Public Deposit Bank', 0, 1, '237,43', '217,68', '106,287', 605);
224INSERT INTO `blips` VALUES (30, 255, 4, 0, 0, 'Car Wash', 0, 1, '-699,716', '-933,469', '19,0139', 100);
225INSERT INTO `blips` VALUES (32, 255, 6, 0, 0, 'LTD', 0, 1, '-723,286', '-935,327', '19,2139', 361);
226INSERT INTO `blips` VALUES (34, 255, 4, 0, 0, 'Bahama Mamas', 0, 1, '-1388,27', '-586,88', '30,2177', 93);
227INSERT INTO `blips` VALUES (37, 255, 6, 0, 0, 'Xero Gas', 0, 1, '-525,818', '-1211,01', '18,1849', 361);
228INSERT INTO `blips` VALUES (38, 255, 6, 0, 0, 'Xero Gas', 0, 1, '-2096,23', '-320,169', '13,1686', 361);
229INSERT INTO `blips` VALUES (39, 255, 6, 0, 0, 'RON', 0, 1, '-1437,21', '-277,118', '46,2077', 361);
230INSERT INTO `blips` VALUES (41, 255, 4, 0, 0, 'Vespucci Movie Masks', 0, 1, '-1336,29', '-1277,71', '4,87249', 102);
231INSERT INTO `blips` VALUES (44, 255, 4, 0, 0, 'Herr Kutz Barber', 0, 1, '133,798', '-1709,09', '29,2916', 71);
232INSERT INTO `blips` VALUES (45, 255, 4, 0, 0, 'Herr Kutz Barber', 0, 1, '1210,12', '-470,322', '66,208', 71);
233INSERT INTO `blips` VALUES (46, 255, 4, 0, 0, 'Hair on Hawick Barbers', 0, 1, '-30,0712', '-150,476', '57,0765', 71);
234INSERT INTO `blips` VALUES (47, 255, 4, 0, 0, 'Bob Mulet', 0, 1, '-821,885', '-184,791', '37,5689', 71);
235INSERT INTO `blips` VALUES (48, 255, 4, 0, 0, 'Beachcombover Barbers', 0, 1, '-1285,61', '-1115,12', '6,99011', 71);
236INSERT INTO `blips` VALUES (53, 255, 6, 0, 0, 'RON', 0, 1, '819,624', '-1028,53', '26,4043', 361);
237INSERT INTO `blips` VALUES (54, 255, 4, 0, 0, 'Tuning Werkstatt', 0, 1, '732,841', '-1087,5', '22,169', 446);
238INSERT INTO `blips` VALUES (55, 255, 4, 0, 0, 'Tuning Werkstatt', 0, 1, '-337,628', '-137,039', '39,0096', 446);
239INSERT INTO `blips` VALUES (56, 255, 4, 0, 0, 'Tuning Werkstatt', 0, 1, '-1155,12', '-2006,06', '13,1803', 446);
240INSERT INTO `blips` VALUES (57, 255, 6, 0, 0, 'LTD', 0, 1, '-71,2302', '-1761,58', '29,534', 361);
241INSERT INTO `blips` VALUES (59, 255, 6, 0, 0, 'Globe Oil', 0, 1, '-319,471', '-1471,59', '30,5486', 361);
242INSERT INTO `blips` VALUES (60, 255, 6, 0, 0, 'LTD', 0, 1, '1180,85', '-329,906', '69,3167', 361);
243INSERT INTO `blips` VALUES (66, 255, 4, 0, 0, 'Car Wash', 0, 1, '22,734', '-1391,73', '29,3302', 100);
244INSERT INTO `blips` VALUES (70, 255, 1, 0, 0, 'Paleto Bay Fire Station', 0, 1, '-379,525', '6118,29', '31,8487', 436);
245INSERT INTO `blips` VALUES (72, 255, 4, 0, 0, 'Herr Kutz Barber', 0, 1, '-278,959', '6231,45', '31,6955', 71);
246INSERT INTO `blips` VALUES (74, 255, 4, 0, 0, 'Tuning Werkstatt', 0, 1, '107,149', '6624,86', '31,7872', 446);
247INSERT INTO `blips` VALUES (75, 255, 6, 0, 0, 'RON', 0, 1, '179,974', '6602,79', '31,8682', 361);
248INSERT INTO `blips` VALUES (76, 255, 6, 0, 0, 'Globe Oil', 0, 1, '1702,11', '6416,94', '32,764', 361);
249INSERT INTO `blips` VALUES (78, 255, 6, 0, 0, 'Xero Gas', 0, 1, '2679,02', '3264,52', '55,2406', 361);
250INSERT INTO `blips` VALUES (79, 255, 6, 0, 0, 'RON', 0, 1, '2580,92', '361,803', '108,469', 361);
251INSERT INTO `blips` VALUES (84, 255, 4, 0, 0, 'Tattoo Studio', 0, 1, '1862,01', '3749,66', '33,0319', 75);
252INSERT INTO `blips` VALUES (85, 255, 4, 0, 0, 'O\'Sheas Barbers', 0, 1, '1931,58', '3726,95', '32,8444', 71);
253INSERT INTO `blips` VALUES (87, 255, 6, 0, 0, 'Xero Gas', 0, 1, '2005,23', '3774,28', '32,4039', 361);
254INSERT INTO `blips` VALUES (89, 255, 25, 0, 0, 'Fleeca Bank', 0, 1, '1175,58', '2706,8', '38,0941', 207);
255INSERT INTO `blips` VALUES (91, 255, 4, 0, 0, 'Tuning Werkstatt', 0, 1, '1178,65', '2638,92', '37,7538', 446);
256INSERT INTO `blips` VALUES (92, 255, 6, 0, 0, 'Globe Oil', 0, 1, '1207,6', '2660,64', '37,8998', 361);
257INSERT INTO `blips` VALUES (97, 255, 6, 0, 0, 'RON', 0, 1, '-2555,33', '2334,36', '33,078', 361);
258INSERT INTO `blips` VALUES (100, 255, 4, 0, 0, 'Hochschule', 0, 1, '-1636,95', '180,522', '61,7573', 80);
259INSERT INTO `blips` VALUES (101, 255, 4, 0, 0, 'FIB Tower', 0, 1, '115,593', '-748,21', '45,7516', 88);
260INSERT INTO `blips` VALUES (102, 255, 4, 0, 0, 'Stadthalle', 0, 1, '-544,73', '-204,504', '38,2155', 120);
261INSERT INTO `blips` VALUES (103, 255, 6, 0, 0, 'Globe Oil', 0, 1, '620,701', '268,953', '103,089', 361);
262INSERT INTO `blips` VALUES (104, 255, 4, 0, 0, 'The Richman Hotel', 0, 1, '-1273,73', '315,76', '65,5118', 475);
263INSERT INTO `blips` VALUES (105, 255, 4, 0, 0, 'Templar Hotel', 0, 1, '288,209', '-1094,94', '29,4197', 475);
264INSERT INTO `blips` VALUES (106, 255, 4, 0, 0, 'The Vault', 0, 1, '232,281', '-1094,99', '29,2942', 93);
265INSERT INTO `blips` VALUES (107, 255, 4, 0, 0, 'The Gentry Manor Hotel', 0, 1, '-60,8282', '360,512', '113,056', 475);
266INSERT INTO `blips` VALUES (108, 255, 4, 0, 0, 'Los Santos International Airport', 0, 1, '-1044,11', '-2748,79', '21,3634', 251);
267INSERT INTO `blips` VALUES (109, 255, 4, 0, 0, 'Opium Nights Hotel', 0, 1, '-737,011', '-2276,13', '13,4375', 475);
268INSERT INTO `blips` VALUES (110, 255, 1, 0, 0, 'El Burro Heights Fire Station', 0, 1, '1185,62', '-1463,94', '34,9011', 436);
269INSERT INTO `blips` VALUES (111, 255, 4, 0, 0, 'Kirche', 0, 1, '-1684,74', '-291,5704', '51,89004', 305);
270
271-- ----------------------------
272-- Table structure for buildingdoors
273-- ----------------------------
274DROP TABLE IF EXISTS `buildingdoors`;
275CREATE TABLE `buildingdoors` (
276 `id` int(11) NOT NULL AUTO_INCREMENT,
277 `doorId` int(11) NOT NULL,
278 `ownerId` int(11) NOT NULL,
279 `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
280 `locked` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'True',
281 `posX` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
282 `posY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
283 `posZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
284 `rotZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
285 PRIMARY KEY (`id`) USING BTREE
286) ENGINE = MyISAM AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
287
288-- ----------------------------
289-- Records of buildingdoors
290-- ----------------------------
291INSERT INTO `buildingdoors` VALUES (1, 1, 10001, 'Theater Ausgang', 'False', '-565,98', '-597,64', '7,12', '180,85');
292INSERT INTO `buildingdoors` VALUES (2, 1, 10001, 'Theater Eingang', 'False', '-555,53', '-619,33', '34,67', '352,47');
293INSERT INTO `buildingdoors` VALUES (3, 2, 4, 'Mt. Zonah Medical Center Eingang', 'False', '-447,90', '-340,98', '34,50', '86,246');
294INSERT INTO `buildingdoors` VALUES (4, 2, 4, 'Mt. Zonah Medical Center Ausgang', 'False', '-450,00', '-316,00', '55,00', '00,00');
295INSERT INTO `buildingdoors` VALUES (5, 3, 10001, 'Stadthalle Eingang', 'True', '237,86', '-412,92', '48,11', '337,308');
296INSERT INTO `buildingdoors` VALUES (6, 3, 10001, 'Stadthalle Ausgang', 'True', '277,97', '-267,72', '53,93', '164,405');
297INSERT INTO `buildingdoors` VALUES (7, 4, 10001, 'Kirche Ausgang', 'False', '-1946,74', '-12,24', '91,67', '90');
298INSERT INTO `buildingdoors` VALUES (8, 4, 10001, 'Kirche Eingang', 'False', '-1684,74', '-291,57', '51,89', '145,98');
299INSERT INTO `buildingdoors` VALUES (9, 5, 9898, 'N.O.O.S.E. Eingang', 'False', '2475,724', '-384,053', '94,399', '275,149');
300INSERT INTO `buildingdoors` VALUES (10, 5, 9898, 'N.O.O.S.E. Ausgang', 'False', '2154,540', '2921,017', '-81,075', '267.905');
301
302-- ----------------------------
303-- Table structure for cardealers
304-- ----------------------------
305DROP TABLE IF EXISTS `cardealers`;
306CREATE TABLE `cardealers` (
307 `id` int(11) NOT NULL AUTO_INCREMENT,
308 `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
309 `posX` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
310 `posY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
311 `posZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
312 PRIMARY KEY (`id`) USING BTREE
313) ENGINE = MyISAM AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
314
315-- ----------------------------
316-- Records of cardealers
317-- ----------------------------
318INSERT INTO `cardealers` VALUES (1, 'Vinewood Compact Cars', '-340,57', '266,12', '85,67');
319INSERT INTO `cardealers` VALUES (2, 'Premium Deluxe Motorsport', '-29,99', '-1104,88', '26,42');
320INSERT INTO `cardealers` VALUES (3, 'Benefactor Automotives', '-1160,86', '-1701,24', '4,56');
321
322-- ----------------------------
323-- Table structure for clothingcatalogue
324-- ----------------------------
325DROP TABLE IF EXISTS `clothingcatalogue`;
326CREATE TABLE `clothingcatalogue` (
327 `id` int(11) NOT NULL AUTO_INCREMENT,
328 `shopType` int(11) NOT NULL,
329 `slot` int(11) NOT NULL,
330 `drawable` int(11) NOT NULL,
331 `maxTexture` int(11) NOT NULL,
332 `price` int(11) NOT NULL,
333 `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
334 `gender` int(1) NOT NULL,
335 PRIMARY KEY (`id`) USING BTREE
336) ENGINE = MyISAM AUTO_INCREMENT = 178 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
337
338-- ----------------------------
339-- Records of clothingcatalogue
340-- ----------------------------
341INSERT INTO `clothingcatalogue` VALUES (100, 1, 11, 63, 0, 35, 'Hemd hochgekrempelt', 1);
342INSERT INTO `clothingcatalogue` VALUES (3, 1, 3, 0, 0, 0, 'Koerper 1', 1);
343INSERT INTO `clothingcatalogue` VALUES (4, 1, 3, 1, 0, 0, 'Koerper 2', 1);
344INSERT INTO `clothingcatalogue` VALUES (5, 1, 3, 2, 0, 0, 'Koerper 3', 1);
345INSERT INTO `clothingcatalogue` VALUES (6, 1, 3, 4, 0, 0, 'Koerper 4', 1);
346INSERT INTO `clothingcatalogue` VALUES (7, 1, 3, 5, 0, 0, 'Koerper 5', 1);
347INSERT INTO `clothingcatalogue` VALUES (8, 1, 3, 6, 0, 0, 'Koerper 6', 1);
348INSERT INTO `clothingcatalogue` VALUES (9, 1, 3, 8, 0, 0, 'Koerper 7', 1);
349INSERT INTO `clothingcatalogue` VALUES (10, 1, 3, 11, 0, 0, 'Koerper 8', 1);
350INSERT INTO `clothingcatalogue` VALUES (11, 1, 3, 12, 0, 0, 'Koerper 9', 1);
351INSERT INTO `clothingcatalogue` VALUES (12, 1, 3, 14, 0, 0, 'Koerper 10', 1);
352INSERT INTO `clothingcatalogue` VALUES (13, 1, 3, 15, 0, 0, 'Koerper 11', 1);
353INSERT INTO `clothingcatalogue` VALUES (14, 1, 3, 119, 0, 20, 'Arbeitshandschuhe gelb 1', 1);
354INSERT INTO `clothingcatalogue` VALUES (15, 1, 3, 126, 0, 20, 'Arbeitshandschuhe gelb 2', 1);
355INSERT INTO `clothingcatalogue` VALUES (16, 1, 3, 63, 0, 20, 'Arbeitshandschuhe gelb 2', 1);
356INSERT INTO `clothingcatalogue` VALUES (17, 1, 3, 64, 0, 20, 'Arbeitshandschuhe gelb 4', 1);
357INSERT INTO `clothingcatalogue` VALUES (18, 1, 3, 0, 0, 0, 'Koerper 1', 2);
358INSERT INTO `clothingcatalogue` VALUES (19, 1, 3, 1, 0, 0, 'Koerper 2', 2);
359INSERT INTO `clothingcatalogue` VALUES (20, 1, 3, 2, 0, 0, 'Koerper 3', 2);
360INSERT INTO `clothingcatalogue` VALUES (21, 1, 3, 3, 0, 0, 'Koerper 4', 2);
361INSERT INTO `clothingcatalogue` VALUES (22, 1, 3, 4, 0, 0, 'Koerper 5', 2);
362INSERT INTO `clothingcatalogue` VALUES (23, 1, 3, 5, 0, 0, 'Koerper 6', 2);
363INSERT INTO `clothingcatalogue` VALUES (24, 1, 3, 6, 0, 0, 'Koerper 7', 2);
364INSERT INTO `clothingcatalogue` VALUES (25, 1, 3, 7, 0, 0, 'Koerper 8', 2);
365INSERT INTO `clothingcatalogue` VALUES (26, 1, 3, 9, 0, 0, 'Koerper 9', 2);
366INSERT INTO `clothingcatalogue` VALUES (27, 1, 3, 11, 0, 0, 'Koerper 10', 2);
367INSERT INTO `clothingcatalogue` VALUES (28, 1, 3, 12, 0, 0, 'Koerper 11', 2);
368INSERT INTO `clothingcatalogue` VALUES (29, 1, 3, 14, 0, 0, 'Koerper 12', 2);
369INSERT INTO `clothingcatalogue` VALUES (30, 1, 3, 15, 0, 0, 'Koerper 13', 2);
370INSERT INTO `clothingcatalogue` VALUES (31, 1, 3, 72, 0, 20, 'Arbeitshandschuhe gelb 1', 2);
371INSERT INTO `clothingcatalogue` VALUES (32, 1, 3, 75, 0, 20, 'Arbeitshandschuhe gelb 2', 2);
372INSERT INTO `clothingcatalogue` VALUES (33, 1, 3, 77, 0, 20, 'Arbeitshandschuhe gelb 3', 2);
373INSERT INTO `clothingcatalogue` VALUES (34, 1, 3, 80, 0, 20, 'Arbeitshandschuhe gelb 4', 2);
374INSERT INTO `clothingcatalogue` VALUES (35, 1, 6, 1, 15, 50, 'Sneaker', 1);
375INSERT INTO `clothingcatalogue` VALUES (136, 1, 11, 169, 3, 40, 'Jeansjacke offen', 1);
376INSERT INTO `clothingcatalogue` VALUES (135, 1, 11, 168, 2, 35, 'Hoodie 2', 1);
377INSERT INTO `clothingcatalogue` VALUES (134, 1, 11, 164, 2, 25, 'Hemd oversized 2', 1);
378INSERT INTO `clothingcatalogue` VALUES (133, 1, 11, 163, 0, 65, 'Lederjacke offen 2', 1);
379INSERT INTO `clothingcatalogue` VALUES (132, 1, 11, 162, 3, 55, 'Lederweste 3', 1);
380INSERT INTO `clothingcatalogue` VALUES (131, 1, 11, 161, 3, 65, 'Lederjacke 2', 1);
381INSERT INTO `clothingcatalogue` VALUES (130, 1, 11, 160, 1, 50, 'Lederweste 2', 1);
382INSERT INTO `clothingcatalogue` VALUES (129, 1, 11, 159, 1, 50, 'Sakko', 1);
383INSERT INTO `clothingcatalogue` VALUES (128, 1, 11, 158, 2, 45, 'Weste', 1);
384INSERT INTO `clothingcatalogue` VALUES (127, 1, 11, 157, 3, 55, 'Lederweste', 1);
385INSERT INTO `clothingcatalogue` VALUES (126, 1, 11, 152, 15, 60, 'Motocross Longsleeve', 1);
386INSERT INTO `clothingcatalogue` VALUES (125, 1, 11, 151, 5, 55, 'Bikerjacke', 1);
387INSERT INTO `clothingcatalogue` VALUES (49, 1, 6, 4, 4, 50, 'Chucks', 1);
388INSERT INTO `clothingcatalogue` VALUES (124, 1, 11, 150, 11, 40, 'Baseballjacke Muster', 1);
389INSERT INTO `clothingcatalogue` VALUES (123, 1, 11, 148, 11, 50, 'Sportjacke 2', 1);
390INSERT INTO `clothingcatalogue` VALUES (122, 1, 11, 146, 8, 25, 'T-Shirt 2', 1);
391INSERT INTO `clothingcatalogue` VALUES (121, 1, 11, 143, 9, 55, 'Baseballjacke 3', 1);
392INSERT INTO `clothingcatalogue` VALUES (120, 1, 11, 141, 10, 30, 'Sportjacke', 1);
393INSERT INTO `clothingcatalogue` VALUES (119, 1, 11, 127, 14, 35, 'Hemd kariert offen', 1);
394INSERT INTO `clothingcatalogue` VALUES (56, 1, 6, 5, 3, 20, 'Flip Flops', 1);
395INSERT INTO `clothingcatalogue` VALUES (118, 1, 11, 126, 14, 35, 'Hemd kariert 2', 1);
396INSERT INTO `clothingcatalogue` VALUES (117, 1, 11, 122, 13, 45, 'Jacke offen', 1);
397INSERT INTO `clothingcatalogue` VALUES (116, 1, 11, 118, 9, 60, 'Lederjacke offen', 1);
398INSERT INTO `clothingcatalogue` VALUES (115, 1, 11, 117, 15, 40, 'Hemd 2', 1);
399INSERT INTO `clothingcatalogue` VALUES (114, 1, 11, 114, 3, 50, 'Bademantel', 1);
400INSERT INTO `clothingcatalogue` VALUES (113, 1, 11, 111, 5, 60, 'Rollkragenpullover', 1);
401INSERT INTO `clothingcatalogue` VALUES (112, 1, 11, 105, 0, 35, 'Hemd Blumenmuster', 1);
402INSERT INTO `clothingcatalogue` VALUES (111, 1, 11, 88, 11, 55, 'Baseballjacke offen', 1);
403INSERT INTO `clothingcatalogue` VALUES (110, 1, 11, 87, 11, 55, 'Baseballjacke 2', 1);
404INSERT INTO `clothingcatalogue` VALUES (109, 1, 11, 84, 5, 35, 'Baseball Pullover', 1);
405INSERT INTO `clothingcatalogue` VALUES (108, 1, 11, 82, 4, 25, 'Hemd oversized', 1);
406INSERT INTO `clothingcatalogue` VALUES (69, 1, 6, 7, 15, 45, 'Turnschuhe', 1);
407INSERT INTO `clothingcatalogue` VALUES (70, 1, 6, 27, 0, 65, 'Lederstiefel', 1);
408INSERT INTO `clothingcatalogue` VALUES (99, 1, 11, 57, 0, 35, 'Hoodie', 1);
409INSERT INTO `clothingcatalogue` VALUES (98, 1, 11, 39, 1, 40, 'Polo', 1);
410INSERT INTO `clothingcatalogue` VALUES (97, 1, 11, 38, 4, 35, 'Baseball Shirt', 1);
411INSERT INTO `clothingcatalogue` VALUES (96, 1, 11, 34, 1, 35, 'T-Shirt V-Neck 2', 1);
412INSERT INTO `clothingcatalogue` VALUES (95, 1, 11, 33, 0, 30, 'T-Shirt gestreift', 1);
413INSERT INTO `clothingcatalogue` VALUES (94, 1, 11, 22, 2, 25, 'T-Shirt', 1);
414INSERT INTO `clothingcatalogue` VALUES (93, 1, 11, 17, 5, 20, 'Tank Top', 1);
415INSERT INTO `clothingcatalogue` VALUES (83, 1, 4, 0, 15, 70, 'Jeans', 1);
416INSERT INTO `clothingcatalogue` VALUES (102, 1, 11, 65, 3, 45, 'Arbeitsjacke', 1);
417INSERT INTO `clothingcatalogue` VALUES (101, 1, 11, 64, 0, 60, 'Lederjacke', 1);
418INSERT INTO `clothingcatalogue` VALUES (86, 1, 11, 16, 2, 30, 'T-Shirt V-Neck', 1);
419INSERT INTO `clothingcatalogue` VALUES (107, 1, 11, 81, 2, 30, 'T-Shirt oversized V-Neck', 1);
420INSERT INTO `clothingcatalogue` VALUES (106, 1, 11, 80, 2, 25, 'T-Shirt oversized', 1);
421INSERT INTO `clothingcatalogue` VALUES (105, 1, 11, 79, 0, 50, 'Baseballjacke', 1);
422INSERT INTO `clothingcatalogue` VALUES (104, 1, 11, 69, 5, 35, 'Kaputzenjacke 2', 1);
423INSERT INTO `clothingcatalogue` VALUES (103, 1, 11, 68, 5, 35, 'Kaputzenjacke', 1);
424INSERT INTO `clothingcatalogue` VALUES (92, 1, 11, 14, 5, 35, 'Hemd kariert', 1);
425INSERT INTO `clothingcatalogue` VALUES (137, 1, 11, 170, 3, 35, 'Jeansweste offen', 1);
426INSERT INTO `clothingcatalogue` VALUES (138, 1, 11, 171, 1, 35, 'Kaputzenpulli', 1);
427INSERT INTO `clothingcatalogue` VALUES (139, 1, 11, 172, 3, 45, 'Jeansjacke offen 2', 1);
428INSERT INTO `clothingcatalogue` VALUES (140, 1, 11, 173, 3, 40, 'Jeansweste offen 2', 1);
429INSERT INTO `clothingcatalogue` VALUES (141, 1, 11, 174, 3, 50, 'Bikerjacke 2', 1);
430INSERT INTO `clothingcatalogue` VALUES (142, 1, 11, 175, 3, 45, 'Bikerweste', 1);
431INSERT INTO `clothingcatalogue` VALUES (143, 1, 11, 176, 0, 45, 'Lederweste 3', 1);
432INSERT INTO `clothingcatalogue` VALUES (144, 1, 11, 191, 25, 50, 'Winterjacke offen', 1);
433INSERT INTO `clothingcatalogue` VALUES (145, 1, 11, 193, 25, 35, 'T-Shirt oversized 2', 1);
434INSERT INTO `clothingcatalogue` VALUES (146, 1, 11, 196, 15, 40, 'Weihnachtspullover', 1);
435INSERT INTO `clothingcatalogue` VALUES (147, 1, 11, 198, 7, 45, 'Weihnachtscardigan', 1);
436INSERT INTO `clothingcatalogue` VALUES (148, 1, 11, 200, 25, 40, 'Kaputzenpulli 2', 1);
437INSERT INTO `clothingcatalogue` VALUES (149, 1, 11, 203, 25, 40, 'Kaputzenpulli 3', 1);
438INSERT INTO `clothingcatalogue` VALUES (150, 1, 11, 225, 1, 35, 'Baseball Shirt 2', 1);
439INSERT INTO `clothingcatalogue` VALUES (151, 1, 11, 229, 11, 50, 'Jacke', 1);
440INSERT INTO `clothingcatalogue` VALUES (152, 1, 11, 230, 11, 50, 'Jacke offen', 1);
441INSERT INTO `clothingcatalogue` VALUES (153, 1, 11, 251, 25, 60, 'Regenjacke', 1);
442INSERT INTO `clothingcatalogue` VALUES (154, 1, 11, 253, 25, 60, 'Regenjacke 2', 1);
443INSERT INTO `clothingcatalogue` VALUES (155, 4, 7, 18, 0, 50, 'Rote Krawatte Breit', 1);
444INSERT INTO `clothingcatalogue` VALUES (156, 4, 7, 19, 0, 50, 'Rote Krawatte Schmal', 1);
445INSERT INTO `clothingcatalogue` VALUES (157, 4, 7, 10, 3, 50, 'Krawatte Breit', 1);
446INSERT INTO `clothingcatalogue` VALUES (158, 4, 7, 12, 3, 50, 'Krawatte Schmal', 1);
447INSERT INTO `clothingcatalogue` VALUES (159, 4, 7, 25, 10, 50, 'Kurze Krawatte Schmal', 1);
448INSERT INTO `clothingcatalogue` VALUES (160, 4, 7, 26, 10, 50, 'Kurze Krawatte Breit', 1);
449INSERT INTO `clothingcatalogue` VALUES (161, 4, 7, 118, 0, 50, 'Schwarze Fliege', 1);
450INSERT INTO `clothingcatalogue` VALUES (162, 4, 7, 132, 15, 40, 'Offene Krawatte', 1);
451INSERT INTO `clothingcatalogue` VALUES (163, 4, 7, 20, 4, 50, 'Kurze Krawatte Breit', 1);
452INSERT INTO `clothingcatalogue` VALUES (164, 4, 7, 27, 15, 50, 'Kurze Krawatte Schmal', 1);
453INSERT INTO `clothingcatalogue` VALUES (165, 4, 7, 28, 15, 50, 'Lange Krawatte Breit', 1);
454INSERT INTO `clothingcatalogue` VALUES (166, 4, 7, 29, 15, 50, 'Lange Krawatte Schmal', 1);
455INSERT INTO `clothingcatalogue` VALUES (167, 4, 7, 36, 0, 50, 'Smoking Fliege', 1);
456INSERT INTO `clothingcatalogue` VALUES (168, 4, 7, 37, 15, 50, 'Lockere Krawatte Breit', 1);
457INSERT INTO `clothingcatalogue` VALUES (169, 4, 7, 115, 1, 50, 'Enge Krawatte Breit', 1);
458INSERT INTO `clothingcatalogue` VALUES (170, 4, 7, 24, 15, 50, 'Kurez Krawatte Breit', 1);
459INSERT INTO `clothingcatalogue` VALUES (171, 4, 7, 23, 12, 50, 'Lange Krawatte Schmal', 1);
460INSERT INTO `clothingcatalogue` VALUES (172, 4, 7, 21, 12, 50, 'Lange Krawatte Breit', 1);
461INSERT INTO `clothingcatalogue` VALUES (173, 4, 7, 39, 15, 50, 'Weite Krawatte Breit', 1);
462INSERT INTO `clothingcatalogue` VALUES (174, 4, 7, 116, 9, 50, 'Kurze Krawatte Schmal', 1);
463INSERT INTO `clothingcatalogue` VALUES (175, 4, 7, 117, 9, 50, 'Enge Krawatte Schmal', 1);
464INSERT INTO `clothingcatalogue` VALUES (176, 4, 7, 20, 4, 50, 'Kurze Krawatte Breit', 1);
465INSERT INTO `clothingcatalogue` VALUES (177, 4, 7, 38, 15, 50, 'Enge Krawatte Breit', 1);
466
467-- ----------------------------
468-- Table structure for clothingstores
469-- ----------------------------
470DROP TABLE IF EXISTS `clothingstores`;
471CREATE TABLE `clothingstores` (
472 `id` int(11) NOT NULL AUTO_INCREMENT,
473 `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
474 `type` int(11) NOT NULL,
475 `posX` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
476 `posY` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
477 `posZ` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
478 `rotZ` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
479 PRIMARY KEY (`id`) USING BTREE
480) ENGINE = MyISAM AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
481
482-- ----------------------------
483-- Records of clothingstores
484-- ----------------------------
485INSERT INTO `clothingstores` VALUES (1, 'Binco', 1, '426,9737', '-807,0072', '29,49113', '91,86121');
486INSERT INTO `clothingstores` VALUES (2, 'Discount Store', 2, '-1102,15', '2711,98', '19,10787', '216,337');
487INSERT INTO `clothingstores` VALUES (3, 'Ponsonbys', 4, '-708,257', '-152,911', '37,41515', '106,8056');
488INSERT INTO `clothingstores` VALUES (4, 'Sub Urban', 3, '-1193,892', '-767,0292', '17,31635', '216,9148');
489INSERT INTO `clothingstores` VALUES (5, 'Ponsonbys', 4, '-1449,033', '-238,1345', '49,81334', '44,76788');
490INSERT INTO `clothingstores` VALUES (6, 'Sub Urban', 3, '126,9899', '-224,2319', '54,55782', '71,12019');
491INSERT INTO `clothingstores` VALUES (7, 'Ponsonbys', 4, '-164,9591', '-302,816', '39,73328', '248,7796');
492INSERT INTO `clothingstores` VALUES (8, 'Binco', 1, '-817,0952', '-1072,208', '11,32811', '117,6323');
493INSERT INTO `clothingstores` VALUES (9, 'Discount Store', 2, '73,9707', '-1392,298', '29,37614', '271,0424');
494INSERT INTO `clothingstores` VALUES (10, 'Discount Store', 2, '-0,4904017', '6510,492', '31,87783', '308,5635');
495INSERT INTO `clothingstores` VALUES (11, 'Sub Urban', 3, '-3169,343', '1043,34', '20,86321', '62,22139');
496INSERT INTO `clothingstores` VALUES (12, 'Discount Store', 2, '1201,973', '2710,321', '38,22259', '89,88564');
497INSERT INTO `clothingstores` VALUES (13, 'Discount Store', 2, '-1097,202', '2713,816', '19,10787', '122,1445');
498
499-- ----------------------------
500-- Table structure for dealercars
501-- ----------------------------
502DROP TABLE IF EXISTS `dealercars`;
503CREATE TABLE `dealercars` (
504 `id` int(11) NOT NULL AUTO_INCREMENT,
505 `dealerId` int(11) NOT NULL,
506 `model` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
507 `price` int(11) NOT NULL,
508 `posX` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
509 `posY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
510 `posZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
511 `rotZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
512 PRIMARY KEY (`id`) USING BTREE
513) ENGINE = MyISAM AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
514
515-- ----------------------------
516-- Records of dealercars
517-- ----------------------------
518INSERT INTO `dealercars` VALUES (1, 1, 'brioso', 54999, '-349,77', '272,46', '84,27', '271,076');
519INSERT INTO `dealercars` VALUES (2, 1, 'blista', 46999, '-349,72', '275,93', '84,82', '271,365');
520INSERT INTO `dealercars` VALUES (3, 1, 'blista2', 39999, '-349,97', '279,25', '84,41', '271,257');
521INSERT INTO `dealercars` VALUES (4, 1, 'bilettante', 45999, '-349,92', '282,60', '84,39', '271,249');
522INSERT INTO `dealercars` VALUES (5, 1, 'issi2', 48999, '-349,96', '286,22', '84,58', '271,965');
523INSERT INTO `dealercars` VALUES (6, 1, 'panto', 39999, '-349,84', '289,88', '84,24', '271,527');
524INSERT INTO `dealercars` VALUES (7, 1, 'prairie', 52999, '-350,21', '293,26', '84,47', '272,969');
525INSERT INTO `dealercars` VALUES (8, 1, 'rhapsody', 44999, '-350,28', '296,79', '84,59', '270,832');
526INSERT INTO `dealercars` VALUES (9, 2, 'f620', 129999, '-56,89', '-1097,65', '25,98', '297,397');
527INSERT INTO `dealercars` VALUES (10, 2, 'cogcabrio', 109999, '-49,31', '-1101,26', '25,87', '318,590');
528INSERT INTO `dealercars` VALUES (11, 2, 'felon', 104999, '-46,43', '-1102,43', '26,11', '318,590');
529INSERT INTO `dealercars` VALUES (12, 2, 'sentinel2', 99999, '-47,69', '-1092,55', '25,80', '190,250');
530INSERT INTO `dealercars` VALUES (13, 2, 'jackal', 109999, '-41,84', '-1094,77', '26,14', '190,250');
531INSERT INTO `dealercars` VALUES (14, 2, 'zion', 94999, '-35,11', '-1099,01', '25,81', '138,793');
532INSERT INTO `dealercars` VALUES (15, 3, 'schlagen', 214999, '-1156,86', '-1707,69', '3,85', '0,028');
533INSERT INTO `dealercars` VALUES (16, 3, 'schafter3', 159999, '-1163,27', '-1712,40', '3,83', '-0,014');
534INSERT INTO `dealercars` VALUES (17, 3, 'schwarzer', 114999, '-1169,66', '-1716,87', '4,12', '0,245');
535INSERT INTO `dealercars` VALUES (18, 3, 'surano', 134999, '-1175,49', '-1720,74', '4,18', '-0,042');
536INSERT INTO `dealercars` VALUES (19, 3, 'xls', 109999, '-1181,22', '-1724,71', '4,47', '-0,022');
537INSERT INTO `dealercars` VALUES (20, 3, 'dubsta', 109999, '-1128,37', '-1729,07', '4,44', '18,233');
538INSERT INTO `dealercars` VALUES (21, 3, 'feltzer2', 184999, '-1124,25', '-1727,66', '4,70', '19,248');
539INSERT INTO `dealercars` VALUES (22, 3, 'schafter2', 134999, '-1118,11', '-1722,97', '4,54', '4,804');
540INSERT INTO `dealercars` VALUES (23, 3, 'serrano', 89999, '-1114,36', '-1719,91', '4,56', '3,244');
541
542-- ----------------------------
543-- Table structure for fractionbanks
544-- ----------------------------
545DROP TABLE IF EXISTS `fractionbanks`;
546CREATE TABLE `fractionbanks` (
547 `id` int(11) NOT NULL AUTO_INCREMENT,
548 `amount` int(11) NOT NULL DEFAULT 0,
549 PRIMARY KEY (`id`) USING BTREE
550) ENGINE = MyISAM AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;
551
552-- ----------------------------
553-- Records of fractionbanks
554-- ----------------------------
555INSERT INTO `fractionbanks` VALUES (0, 1850);
556INSERT INTO `fractionbanks` VALUES (1, 0);
557INSERT INTO `fractionbanks` VALUES (2, 0);
558INSERT INTO `fractionbanks` VALUES (3, 0);
559INSERT INTO `fractionbanks` VALUES (4, 0);
560INSERT INTO `fractionbanks` VALUES (5, 0);
561INSERT INTO `fractionbanks` VALUES (6, 0);
562INSERT INTO `fractionbanks` VALUES (7, 0);
563
564-- ----------------------------
565-- Table structure for fractions
566-- ----------------------------
567DROP TABLE IF EXISTS `fractions`;
568CREATE TABLE `fractions` (
569 `id` int(11) NOT NULL AUTO_INCREMENT,
570 `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
571 `money` int(11) NOT NULL DEFAULT 0,
572 `dutyPoints` json NOT NULL,
573 `outfitsM` json NOT NULL,
574 `outfitsW` json NOT NULL,
575 PRIMARY KEY (`id`) USING BTREE
576) ENGINE = MyISAM AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
577
578-- ----------------------------
579-- Records of fractions
580-- ----------------------------
581INSERT INTO `fractions` VALUES (0, '', 107500, '[]', '[]', '[]');
582INSERT INTO `fractions` VALUES (1, 'Los Santos Police Ddepartment', 0, '[{\"x\": 455.568848, \"y\": -988.6502, \"z\": 30.6895828}]', '[]', '[]');
583INSERT INTO `fractions` VALUES (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]]]', '[]');
584INSERT INTO `fractions` VALUES (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]]]', '[]');
585INSERT INTO `fractions` VALUES (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]]]', '[]');
586INSERT INTO `fractions` VALUES (5, 'Department of Justice', 0, '[]', '[]', '[]');
587INSERT INTO `fractions` VALUES (6, 'Department of Public Order and Safety', 0, '[]', '[]', '[]');
588INSERT INTO `fractions` VALUES (7, 'Department of Motor Vehicles', 0, '[]', '[]', '[]');
589INSERT INTO `fractions` VALUES (8, 'La Cosa Nostra', 0, '[]', '[]', '[]');
590
591-- ----------------------------
592-- Table structure for garages
593-- ----------------------------
594DROP TABLE IF EXISTS `garages`;
595CREATE TABLE `garages` (
596 `id` int(11) NOT NULL AUTO_INCREMENT,
597 `propertyId` int(11) NOT NULL DEFAULT 0,
598 `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
599 `fraction` int(2) NOT NULL,
600 `type` int(2) NOT NULL DEFAULT 1,
601 `isPrivate` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'False',
602 `marker` int(3) NOT NULL DEFAULT 23,
603 `scale` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1,0',
604 `red` int(3) NOT NULL,
605 `green` int(3) NOT NULL,
606 `blue` int(3) NOT NULL,
607 `alpha` int(3) NOT NULL DEFAULT 150,
608 `posX` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
609 `posY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
610 `posZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
611 PRIMARY KEY (`id`) USING BTREE
612) ENGINE = MyISAM AUTO_INCREMENT = 1039 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
613
614-- ----------------------------
615-- Records of garages
616-- ----------------------------
617INSERT INTO `garages` VALUES (1001, 0, 'La Mesa Police Department', 1, 1, 'False', 23, '1,0', 50, 50, 255, 155, '850,10', '-1285,66', '28,00');
618INSERT INTO `garages` VALUES (1002, 0, 'St. Fiacre Hospital', 4, 1, 'False', 23, '1,0', 255, 50, 50, 155, '1207,31', '-1487,24', '34,84');
619INSERT INTO `garages` VALUES (1003, 0, 'Autogarage Burton', 0, 1, 'False', 23, '1,0', 255, 255, 255, 150, '-365,52', '-72,13', '45,65');
620INSERT INTO `garages` VALUES (1004, 0, 'Autogarage Pillbox Hill', 0, 1, 'False', 23, '1,0', 255, 255, 255, 150, '146,71', '-1086,18', '29,19');
621INSERT INTO `garages` VALUES (1005, 0, 'Autogarage Rancho', 0, 1, 'False', 23, '1,0', 255, 255, 255, 150, '361,22', '-1647,69', '27,25');
622INSERT INTO `garages` VALUES (1006, 0, 'Autogarage LS Intl. Airport', 0, 1, 'False', 23, '1,0', 255, 255, 255, 150, '-668,32', '-2385,89', '13,92');
623INSERT INTO `garages` VALUES (1007, 0, 'Autogarage Vespucci', 0, 1, 'False', 23, '1,0', 255, 255, 255, 150, '-1125,34', '-833,06', '13,36');
624INSERT INTO `garages` VALUES (1008, 0, 'Autogarage Pacific Bluffs', 0, 1, 'False', 23, '1,0', 255, 255, 255, 150, '-2952,86', '49,49', '11,60');
625INSERT INTO `garages` VALUES (1009, 0, 'Autogarage Rockford', 0, 1, 'False', 23, '1,0', 255, 255, 255, 150, '-794,32', '353,06', '87,87');
626INSERT INTO `garages` VALUES (1010, 0, 'Autogarage Vinewood', 0, 1, 'False', 23, '1,0', 255, 255, 255, 150, '303,83', '361,70', '105,38');
627INSERT INTO `garages` VALUES (1011, 0, 'Vespucci Police Department', 1, 1, 'False', 23, '1,0', 50, 50, 255, 150, '-1078,787', '-856,5075', '5,042521');
628INSERT INTO `garages` VALUES (1012, 0, 'LSMCCW', 4, 1, 'False', 23, '1,0', 255, 50, 50, 150, '-510,6587', '-295,8061', '35,36591');
629INSERT INTO `garages` VALUES (1013, 0, 'LSMCDP', 4, 1, 'False', 23, '1,0', 255, 50, 50, 150, '334,3082', '-561,1508', '28,74379');
630INSERT INTO `garages` VALUES (1014, 0, 'LSPD Mission Row', 1, 1, 'False', 23, '1,0', 50, 50, 255, 150, '441,8878', '-1013,545', '28,62858');
631INSERT INTO `garages` VALUES (1015, 0, 'Vinewood Police Department', 1, 1, 'False', 23, '1,0', 50, 50, 255, 150, '535,5668', '-21,83558', '70,62952');
632INSERT INTO `garages` VALUES (1016, 0, 'Weazle News HQ', 7, 1, 'False', 23, '1,0', 255, 255, 255, 150, '-537,099', '-886,8401', '25,19219');
633INSERT INTO `garages` VALUES (1017, 0, 'Davis Sheriff\'s Station', 1, 1, 'False', 23, '1,0', 50, 50, 255, 150, '377,9274', '-1622,088', '29,29195');
634INSERT INTO `garages` VALUES (1018, 0, 'Rockford Hills Fire Station', 4, 1, 'False', 23, '1,0', 255, 50, 50, 150, '-634,7909', '-109,3366', '38,03267');
635INSERT INTO `garages` VALUES (1019, 0, 'Davis Fire Station', 4, 1, 'False', 23, '1,0', 255, 50, 50, 150, '202,3365', '-1665,711', '29,80322');
636INSERT INTO `garages` VALUES (1020, 0, 'LSIA Fire Station', 4, 1, 'False', 23, '1,0', 255, 50, 50, 150, '-1095,604', '-2363,309', '14,02258');
637INSERT INTO `garages` VALUES (1021, 0, 'Sandy Shores Fire Station', 4, 1, 'False', 23, '1,0', 255, 50, 50, 150, '1697,681', '3613,929', '35,3105');
638INSERT INTO `garages` VALUES (1022, 0, 'Paleto Fire Station', 4, 1, 'False', 23, '1,0', 255, 50, 50, 150, '-372,1975', '6119,379', '31,44028');
639INSERT INTO `garages` VALUES (1023, 0, 'Fort Zancudo', 3, 1, 'False', 23, '1,0', 110, 80, 0, 150, '-2414,956', '3339,346', '32,97707');
640INSERT INTO `garages` VALUES (1024, 0, 'FIB HQ', 2, 1, 'False', 23, '1,0', 0, 0, 0, 150, '165,9536', '-688,8113', '33,12795');
641INSERT INTO `garages` VALUES (1025, 0, 'La Cosa Nostra', 8, 1, 'False', 23, '1,0', 0, 0, 0, 150, '-1531,876', '78,98055', '56,75471');
642INSERT INTO `garages` VALUES (1026, 0, 'La Cosa Nostra Helikopter', 8, 3, 'False', 23, '1,0', 0, 0, 0, 150, '-1547,362', '89,28055', '61,31318');
643INSERT INTO `garages` VALUES (1027, 1001, '6085 Milton Road', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '-681,22', '901,9814', '230,5754');
644INSERT INTO `garages` VALUES (1028, 1002, '4589 Milton Road', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '-614,7619', '864,7507', '213,3161');
645INSERT INTO `garages` VALUES (1029, 1003, '4588 Milton Road', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '-556,6844', '828,7972', '197,5883');
646INSERT INTO `garages` VALUES (1030, 1004, '4587 Milton Road', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '-490,1459', '796,0521', '180,5625');
647INSERT INTO `garages` VALUES (1031, 1005, '1337 Buen Vino Road', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '-2593,011', '1927,749', '167,3065');
648INSERT INTO `garages` VALUES (1032, 1006, '2001 Senora Road', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '1398,437', '1114,372', '114,8377');
649INSERT INTO `garages` VALUES (1033, 1007, '2707 Americano Way', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '-1493,189', '17,15579', '54,71732');
650INSERT INTO `garages` VALUES (1034, 1009, '2802 Portola Drive', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '-837,4678', '119,0358', '55,45132');
651INSERT INTO `garages` VALUES (1035, 1012, '6729BridgeStreet', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '1102,434', '-432,6344', '67,39205');
652INSERT INTO `garages` VALUES (1036, 1014, '6731BridgeStreet', 0, 1, 'True', 23, '1,0', 0, 0, 0, 150, '1089,885', '-492,8275', '65,07653');
653INSERT INTO `garages` VALUES (1037, 0, 'Schiffsgarage-DOD', 3, 5, 'False', 23, '1,0', 110, 80, 0, 150, '508,51', '-3287,536', '6,069262');
654INSERT INTO `garages` VALUES (1038, 0, 'LSMCVespucciBeach', 4, 1, 'False', 23, '1,0', 255, 50, 50, 150, '-1202,734', '-1802,889', '3,908577');
655
656-- ----------------------------
657-- Table structure for gaspumps
658-- ----------------------------
659DROP TABLE IF EXISTS `gaspumps`;
660CREATE TABLE `gaspumps` (
661 `id` int(11) NOT NULL AUTO_INCREMENT,
662 `gasStation` int(11) NOT NULL,
663 `posX` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
664 `posY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
665 `posZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
666 PRIMARY KEY (`id`) USING BTREE
667) ENGINE = MyISAM AUTO_INCREMENT = 97 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
668
669-- ----------------------------
670-- Records of gaspumps
671-- ----------------------------
672INSERT INTO `gaspumps` VALUES (1, 1, '818,4428', '-1029,053', '26,4043');
673INSERT INTO `gaspumps` VALUES (2, 1, '811,3011', '-1028,706', '26,41885');
674INSERT INTO `gaspumps` VALUES (3, 1, '826,6649', '-1028,632', '26,60824');
675INSERT INTO `gaspumps` VALUES (4, 2, '1210,905', '-1405,092', '35,38521');
676INSERT INTO `gaspumps` VALUES (5, 2, '1206,226', '-1399,964', '35,38554');
677INSERT INTO `gaspumps` VALUES (6, 3, '621,0241', '264,7424', '103,2771');
678INSERT INTO `gaspumps` VALUES (7, 3, '612,6577', '264,8711', '103,2771');
679INSERT INTO `gaspumps` VALUES (8, 3, '612,2741', '272,7649', '103,2771');
680INSERT INTO `gaspumps` VALUES (9, 3, '620,9195', '273,0555', '103,2771');
681INSERT INTO `gaspumps` VALUES (10, 3, '629,6777', '272,8902', '103,2771');
682INSERT INTO `gaspumps` VALUES (11, 3, '629,7007', '264,9323', '103,2771');
683INSERT INTO `gaspumps` VALUES (12, 4, '1178,402', '-330,8781', '69,3166');
684INSERT INTO `gaspumps` VALUES (13, 4, '1176,654', '-322,2249', '69,35079');
685INSERT INTO `gaspumps` VALUES (14, 4, '1182,182', '-321,1485', '69,3503');
686INSERT INTO `gaspumps` VALUES (15, 4, '1183,966', '-330,0107', '69,32634');
687INSERT INTO `gaspumps` VALUES (16, 4, '1185,538', '-338,3997', '69,36536');
688INSERT INTO `gaspumps` VALUES (17, 4, '1179,794', '-339,2729', '69,35648');
689INSERT INTO `gaspumps` VALUES (18, 5, '-71,77341', '-1764,18', '29,53297');
690INSERT INTO `gaspumps` VALUES (19, 5, '-69,7798', '-1758,866', '29,53405');
691INSERT INTO `gaspumps` VALUES (20, 5, '-77,94009', '-1755,864', '29,80033');
692INSERT INTO `gaspumps` VALUES (21, 5, '-79,82786', '-1761,25', '29,80007');
693INSERT INTO `gaspumps` VALUES (22, 5, '-63,37265', '-1767,086', '29,26173');
694INSERT INTO `gaspumps` VALUES (23, 5, '-61,51406', '-1761,69', '29,26173');
695INSERT INTO `gaspumps` VALUES (24, 6, '-329,2758', '-1472,314', '30,72421');
696INSERT INTO `gaspumps` VALUES (25, 6, '-325,2377', '-1479,583', '30,72421');
697INSERT INTO `gaspumps` VALUES (26, 6, '-317,7741', '-1475,276', '30,72421');
698INSERT INTO `gaspumps` VALUES (27, 6, '-310,2865', '-1470,813', '30,72421');
699INSERT INTO `gaspumps` VALUES (28, 6, '-321,906', '-1468,168', '30,72421');
700INSERT INTO `gaspumps` VALUES (29, 6, '-314,286', '-1463,887', '30,72421');
701INSERT INTO `gaspumps` VALUES (30, 7, '-530,4554', '-1212,781', '18,32954');
702INSERT INTO `gaspumps` VALUES (31, 7, '-523,3819', '-1216,044', '18,32881');
703INSERT INTO `gaspumps` VALUES (32, 7, '-520,3547', '-1209,587', '18,32497');
704INSERT INTO `gaspumps` VALUES (33, 7, '-527,7216', '-1206,159', '18,32878');
705INSERT INTO `gaspumps` VALUES (34, 8, '-732,5057', '-933,4132', '19,21393');
706INSERT INTO `gaspumps` VALUES (35, 8, '-732,7756', '-938,3526', '19,20996');
707INSERT INTO `gaspumps` VALUES (36, 8, '-724,0641', '-938,3694', '19,20962');
708INSERT INTO `gaspumps` VALUES (37, 8, '-724,2483', '-933,4478', '19,21393');
709INSERT INTO `gaspumps` VALUES (38, 8, '-715,5161', '-933,4754', '19,21374');
710INSERT INTO `gaspumps` VALUES (39, 8, '-715,051', '-938,4157', '19,20944');
711INSERT INTO `gaspumps` VALUES (40, 9, '-1436,138', '-284,058', '46,38717');
712INSERT INTO `gaspumps` VALUES (41, 9, '-1443,868', '-274,9907', '46,39413');
713INSERT INTO `gaspumps` VALUES (42, 9, '-1429,667', '-278,4758', '46,38716');
714INSERT INTO `gaspumps` VALUES (43, 9, '-1437,497', '-269,4554', '46,39414');
715INSERT INTO `gaspumps` VALUES (44, 10, '-2097,287', '-319,7908', '13,16863');
716INSERT INTO `gaspumps` VALUES (45, 10, '-2097,353', '-325,5308', '13,16859');
717INSERT INTO `gaspumps` VALUES (46, 10, '-2096,176', '-312,8006', '13,16863');
718INSERT INTO `gaspumps` VALUES (47, 10, '-2087,287', '-313,6806', '13,16863');
719INSERT INTO `gaspumps` VALUES (48, 10, '-2087,941', '-320,1857', '13,16862');
720INSERT INTO `gaspumps` VALUES (49, 10, '-2088,712', '-326,439', '13,16702');
721INSERT INTO `gaspumps` VALUES (50, 10, '-2105,997', '-324,671', '13,16863');
722INSERT INTO `gaspumps` VALUES (51, 10, '-2105,26', '-318,3625', '13,16862');
723INSERT INTO `gaspumps` VALUES (52, 10, '-2104,295', '-311,9776', '13,16862');
724INSERT INTO `gaspumps` VALUES (53, 11, '-2559,379', '2334,525', '33,25668');
725INSERT INTO `gaspumps` VALUES (54, 11, '-2551,406', '2334,52', '33,25701');
726INSERT INTO `gaspumps` VALUES (55, 11, '-2550,562', '2327,612', '33,25701');
727INSERT INTO `gaspumps` VALUES (56, 11, '-2558,911', '2327,101', '33,25668');
728INSERT INTO `gaspumps` VALUES (57, 11, '-2559,741', '2341,049', '33,25668');
729INSERT INTO `gaspumps` VALUES (58, 11, '-2551,476', '2341,551', '33,25698');
730INSERT INTO `gaspumps` VALUES (59, 12, '176,5727', '-1556,694', '29,23015');
731INSERT INTO `gaspumps` VALUES (60, 12, '170,3675', '-1562,729', '29,26891');
732INSERT INTO `gaspumps` VALUES (61, 12, '181,118', '-1561,053', '29,25958');
733INSERT INTO `gaspumps` VALUES (62, 13, '257,0258', '-1268,773', '29,29295');
734INSERT INTO `gaspumps` VALUES (63, 13, '257,0195', '-1261,3', '29,29295');
735INSERT INTO `gaspumps` VALUES (64, 13, '257,0193', '-1253,462', '29,29295');
736INSERT INTO `gaspumps` VALUES (65, 13, '264,4765', '-1253,414', '29,28998');
737INSERT INTO `gaspumps` VALUES (66, 13, '264,4769', '-1261,224', '29,29282');
738INSERT INTO `gaspumps` VALUES (67, 13, '264,4769', '-1268,637', '29,28942');
739INSERT INTO `gaspumps` VALUES (68, 13, '273,2508', '-1268,593', '29,29293');
740INSERT INTO `gaspumps` VALUES (69, 13, '273,2509', '-1261,235', '29,29296');
741INSERT INTO `gaspumps` VALUES (70, 13, '273,2626', '-1253,434', '29,29277');
742INSERT INTO `gaspumps` VALUES (71, 14, '2579,867', '364,3596', '108,4688');
743INSERT INTO `gaspumps` VALUES (72, 14, '2579,974', '358,6909', '108,6454');
744INSERT INTO `gaspumps` VALUES (73, 14, '2574,882', '359,2014', '108,4687');
745INSERT INTO `gaspumps` VALUES (74, 14, '2575,344', '364,6651', '108,4671');
746INSERT INTO `gaspumps` VALUES (75, 14, '2587,192', '363,9868', '108,4686');
747INSERT INTO `gaspumps` VALUES (76, 14, '2587,167', '358,4953', '108,4692');
748INSERT INTO `gaspumps` VALUES (77, 16, '185,5136', '6606,016', '31,86814');
749INSERT INTO `gaspumps` VALUES (78, 16, '180,2211', '6605,012', '32,04737');
750INSERT INTO `gaspumps` VALUES (79, 16, '172,9092', '6603,74', '32,04679');
751INSERT INTO `gaspumps` VALUES (80, 15, '1705,158', '6414,262', '32,76402');
752INSERT INTO `gaspumps` VALUES (81, 15, '1701,532', '6415,778', '32,76397');
753INSERT INTO `gaspumps` VALUES (82, 15, '1697,374', '6417,904', '32,76403');
754INSERT INTO `gaspumps` VALUES (83, 17, '-2558,612', '2340,88', '33,25547');
755INSERT INTO `gaspumps` VALUES (84, 17, '-2552,354', '2341,307', '33,25701');
756INSERT INTO `gaspumps` VALUES (85, 17, '-2552,618', '2335,059', '33,25699');
757INSERT INTO `gaspumps` VALUES (86, 17, '-2558,515', '2334,719', '33,25666');
758INSERT INTO `gaspumps` VALUES (87, 17, '-2558,05', '2327,288', '33,25664');
759INSERT INTO `gaspumps` VALUES (88, 17, '-2551,168', '2327,716', '33,257');
760INSERT INTO `gaspumps` VALUES (89, 18, '2008,504', '3776,124', '32,40394');
761INSERT INTO `gaspumps` VALUES (90, 18, '2006,746', '3775,671', '32,40394');
762INSERT INTO `gaspumps` VALUES (91, 18, '2003,411', '3772,765', '32,40395');
763INSERT INTO `gaspumps` VALUES (92, 18, '2002,087', '3772,836', '32,40395');
764INSERT INTO `gaspumps` VALUES (93, 19, '1209,429', '2659,279', '37,89977');
765INSERT INTO `gaspumps` VALUES (94, 19, '1206,286', '2662,438', '37,89977');
766INSERT INTO `gaspumps` VALUES (95, 20, '2681,388', '3267,204', '55,40941');
767INSERT INTO `gaspumps` VALUES (96, 18, '2678,013', '3261,53', '55,4094');
768
769-- ----------------------------
770-- Table structure for gasstations
771-- ----------------------------
772DROP TABLE IF EXISTS `gasstations`;
773CREATE TABLE `gasstations` (
774 `id` int(11) NOT NULL AUTO_INCREMENT,
775 `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
776 `type` int(11) NOT NULL,
777 `pplDiesel` int(11) NOT NULL,
778 `pplSuper` int(11) NOT NULL,
779 PRIMARY KEY (`id`) USING BTREE
780) ENGINE = MyISAM AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
781
782-- ----------------------------
783-- Records of gasstations
784-- ----------------------------
785INSERT INTO `gasstations` VALUES (1, 'RON', 3, 5, 7);
786INSERT INTO `gasstations` VALUES (2, 'RON', 3, 13, 15);
787INSERT INTO `gasstations` VALUES (3, 'Globe-Oil', 2, 10, 13);
788INSERT INTO `gasstations` VALUES (4, 'LTD', 1, 11, 13);
789INSERT INTO `gasstations` VALUES (5, 'LTD', 1, 12, 14);
790INSERT INTO `gasstations` VALUES (6, 'LTD', 1, 10, 13);
791INSERT INTO `gasstations` VALUES (7, 'Xero-Gas', 4, 12, 14);
792INSERT INTO `gasstations` VALUES (8, 'LTD', 1, 12, 14);
793INSERT INTO `gasstations` VALUES (9, 'RON', 3, 9, 13);
794INSERT INTO `gasstations` VALUES (10, 'Xero-Gas', 4, 11, 14);
795INSERT INTO `gasstations` VALUES (11, 'RON', 3, 9, 11);
796INSERT INTO `gasstations` VALUES (12, 'RON', 3, 8, 12);
797INSERT INTO `gasstations` VALUES (13, 'Xero-Gas', 4, 9, 11);
798INSERT INTO `gasstations` VALUES (14, 'RON', 3, 6, 11);
799INSERT INTO `gasstations` VALUES (15, 'GlobeOil', 2, 7, 11);
800INSERT INTO `gasstations` VALUES (16, 'RON', 3, 8, 12);
801INSERT INTO `gasstations` VALUES (17, 'RON', 3, 8, 12);
802INSERT INTO `gasstations` VALUES (18, 'Xero-Gas', 4, 8, 11);
803INSERT INTO `gasstations` VALUES (19, 'GlobeOil', 2, 6, 11);
804INSERT INTO `gasstations` VALUES (20, 'Xero-Gas', 4, 8, 11);
805
806-- ----------------------------
807-- Table structure for hinterzimmerjhonny
808-- ----------------------------
809DROP TABLE IF EXISTS `hinterzimmerjhonny`;
810CREATE TABLE `hinterzimmerjhonny` (
811 `id` int(11) NOT NULL AUTO_INCREMENT,
812 `posX` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
813 `posY` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
814 `posZ` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
815 `rotZ` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
816 PRIMARY KEY (`id`) USING BTREE
817) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
818
819-- ----------------------------
820-- Records of hinterzimmerjhonny
821-- ----------------------------
822INSERT INTO `hinterzimmerjhonny` VALUES (1, '31,28936', '-1340,27', '29,49702', '81,17692');
823
824-- ----------------------------
825-- Table structure for jobs
826-- ----------------------------
827DROP TABLE IF EXISTS `jobs`;
828CREATE TABLE `jobs` (
829 `id` int(11) NOT NULL AUTO_INCREMENT,
830 `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
831 `posX` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
832 `posY` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
833 `posZ` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
834 `routes` json NOT NULL,
835 PRIMARY KEY (`id`) USING BTREE
836) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
837
838-- ----------------------------
839-- Records of jobs
840-- ----------------------------
841INSERT INTO `jobs` VALUES (0, '-', '0', '0', '0', '[]');
842INSERT INTO `jobs` VALUES (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}]]');
843INSERT INTO `jobs` VALUES (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}]]');
844INSERT INTO `jobs` VALUES (3, 'Taxifahrer/-in', '895,1838', '-179,2972', '74,70027', '[]');
845INSERT INTO `jobs` VALUES (4, 'KFZ-Mechaniker/-in', '-206,8346', '-1341,642', '34,89437', '[]');
846
847-- ----------------------------
848-- Table structure for meddropoff
849-- ----------------------------
850DROP TABLE IF EXISTS `meddropoff`;
851CREATE TABLE `meddropoff` (
852 `id` int(11) NOT NULL AUTO_INCREMENT,
853 `name` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
854 `posX` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
855 `posY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
856 `posZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
857 `posXA` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
858 `posYA` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
859 `posZA` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
860 PRIMARY KEY (`id`) USING BTREE
861) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
862
863-- ----------------------------
864-- Records of meddropoff
865-- ----------------------------
866INSERT INTO `meddropoff` VALUES (1, 'st.fiacre', '1164,48', '-1569,15', '39,40', '1122,56', '-1522,41', '34,83');
867INSERT INTO `meddropoff` VALUES (2, 'mt.zonah', '-454,35', '-339,77', '34,36', '-447,83', '-340,99', '34,50');
868
869-- ----------------------------
870-- Table structure for parkingpoints
871-- ----------------------------
872DROP TABLE IF EXISTS `parkingpoints`;
873CREATE TABLE `parkingpoints` (
874 `id` int(11) NOT NULL AUTO_INCREMENT,
875 `garageId` int(11) NOT NULL,
876 `posX` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
877 `posY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
878 `posZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
879 `rotZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
880 PRIMARY KEY (`id`) USING BTREE
881) ENGINE = MyISAM AUTO_INCREMENT = 61 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
882
883-- ----------------------------
884-- Records of parkingpoints
885-- ----------------------------
886INSERT INTO `parkingpoints` VALUES (1, 1, '-339,85', '300,26', '84,99', '94,769');
887INSERT INTO `parkingpoints` VALUES (2, 1003, '-361,04', '-79,05', '45,66', '165,799');
888INSERT INTO `parkingpoints` VALUES (3, 1004, '132,26', '-1081,41', '28,69', '358,622');
889INSERT INTO `parkingpoints` VALUES (4, 1005, '361,77', '-1653,16', '26,75', '233,036');
890INSERT INTO `parkingpoints` VALUES (5, 1006, '-674,35', '-2391,07', '13,88', '58,134');
891INSERT INTO `parkingpoints` VALUES (6, 1007, '-1124,47', '-839,44', '12,90', '0,278');
892INSERT INTO `parkingpoints` VALUES (7, 1008, '-2953,12', '55,75', '11,10', '65,462');
893INSERT INTO `parkingpoints` VALUES (8, 1009, '-805,42', '357,62', '87,37', '1,329');
894INSERT INTO `parkingpoints` VALUES (9, 1010, '301,32', '367,62', '104,82', '347,028');
895INSERT INTO `parkingpoints` VALUES (10, 2, '-44,99', '-1116,21', '26,43', '357,860');
896INSERT INTO `parkingpoints` VALUES (11, 1001, '855,34', '-1279,49', '26,07', '1,194');
897INSERT INTO `parkingpoints` VALUES (12, 1002, '1196,69', '-1495,81', '34,69', '181,730');
898INSERT INTO `parkingpoints` VALUES (13, 1011, '-1071,741', '-856,8323', '4,867273', '214,3');
899INSERT INTO `parkingpoints` VALUES (14, 1011, '-1067,829', '-853,8982', '4,867257', '212,0308');
900INSERT INTO `parkingpoints` VALUES (15, 1012, '-515,7177', '-295,1559', '35,22958', '18,60837');
901INSERT INTO `parkingpoints` VALUES (16, 1013, '328,7159', '-557,0048', '28,74378', '341,49');
902INSERT INTO `parkingpoints` VALUES (17, 1014, '436,3889', '-997,4418', '25,75775', '175,9671');
903INSERT INTO `parkingpoints` VALUES (18, 1014, '431,1583', '-997,6219', '25,7567', '183,4842');
904INSERT INTO `parkingpoints` VALUES (19, 1015, '534,4287', '-26,67013', '70,62952', '211,3751');
905INSERT INTO `parkingpoints` VALUES (20, 1015, '529,9918', '-29,41676', '70,62952', '212,5214');
906INSERT INTO `parkingpoints` VALUES (21, 1017, '377,3943', '-1627,918', '28,55701', '318,3333');
907INSERT INTO `parkingpoints` VALUES (22, 1017, '380,3398', '-1630,432', '28,55686', '319,4666');
908INSERT INTO `parkingpoints` VALUES (23, 1018, '-638,3484', '-104,7636', '38,03584', '94,78943');
909INSERT INTO `parkingpoints` VALUES (24, 1018, '-635,4251', '-96,76399', '38,04562', '82,86921');
910INSERT INTO `parkingpoints` VALUES (25, 1018, '-638,6085', '-112,8882', '37,9902', '81,23292');
911INSERT INTO `parkingpoints` VALUES (26, 1019, '197,8346', '-1667,372', '29,80322', '139,0015');
912INSERT INTO `parkingpoints` VALUES (27, 1019, '194,5943', '-1664,659', '29,80322', '134,6946');
913INSERT INTO `parkingpoints` VALUES (28, 1019, '191,5628', '-1661,758', '29,80322', '139,5075');
914INSERT INTO `parkingpoints` VALUES (29, 1020, '-1094,107', '-2369,805', '13,94515', '147,8232');
915INSERT INTO `parkingpoints` VALUES (30, 1020, '-1088,82', '-2372,313', '13,94515', '151,0368');
916INSERT INTO `parkingpoints` VALUES (31, 1020, '-1084,073', '-2374,888', '13,94515', '149,2802');
917INSERT INTO `parkingpoints` VALUES (32, 1020, '-1079,116', '-2377,851', '13,94515', '148,6439');
918INSERT INTO `parkingpoints` VALUES (33, 1024, '167,0051', '-693,1143', '33,128', '162,068');
919INSERT INTO `parkingpoints` VALUES (42, 1025, '-1524,774', '82,46057', '56,55148', '7,031225');
920INSERT INTO `parkingpoints` VALUES (41, 1025, '-1529,002', '82,22009', '56,65501', '6,184558');
921INSERT INTO `parkingpoints` VALUES (40, 1025, '-1532,302', '82,89035', '56,74903', '315,2464');
922INSERT INTO `parkingpoints` VALUES (43, 1027, '-676,1087', '904,0263', '230,5777', '325,2675');
923INSERT INTO `parkingpoints` VALUES (38, 1026, '-1541,237', '78,63522', '62,31318', '47,87769');
924INSERT INTO `parkingpoints` VALUES (44, 1028, '-608,7338', '867,8205', '213,6238', '335,4611');
925INSERT INTO `parkingpoints` VALUES (45, 1029, '-551,5853', '831,7141', '197,9177', '339,3808');
926INSERT INTO `parkingpoints` VALUES (46, 1030, '-484,7044', '798,5886', '180,8445', '332,9511');
927INSERT INTO `parkingpoints` VALUES (47, 1032, '1401,752', '1117,634', '114,8377', '91,06383');
928INSERT INTO `parkingpoints` VALUES (48, 1032, '1407,497', '1117,277', '114,8377', '94,40981');
929INSERT INTO `parkingpoints` VALUES (49, 1032, '1414,032', '1117,41', '114,8379', '89,53864');
930INSERT INTO `parkingpoints` VALUES (50, 1033, '-1490,695', '22,9341', '54,72226', '349,5105');
931INSERT INTO `parkingpoints` VALUES (51, 1034, '-834,817', '116,192', '55,37723', '187,4521');
932INSERT INTO `parkingpoints` VALUES (52, 1034, '-839,3872', '115,304', '55,39243', '183,5414');
933INSERT INTO `parkingpoints` VALUES (53, 1036, '1086,353', '-494,8581', '64,64405', '79,22189');
934INSERT INTO `parkingpoints` VALUES (54, 1031, '-2595,885', '1930,126', '167,3073', '273,8013');
935INSERT INTO `parkingpoints` VALUES (55, 1035, '1098,729', '-429,1322', '67,3924', '87,46418');
936INSERT INTO `parkingpoints` VALUES (57, 1023, '-2409,667', '3332,095', '32,82911', '237,1624');
937INSERT INTO `parkingpoints` VALUES (58, 1037, '524,7269', '-3315,428', '-0,8356363', '182,7323');
938INSERT INTO `parkingpoints` VALUES (59, 3, '-1136,555', '-1717,769', '4,355034', '138,8057');
939INSERT INTO `parkingpoints` VALUES (60, 1038, '-1205,431', '-1798,995', '3,940186', '68,61');
940
941-- ----------------------------
942-- Table structure for plants
943-- ----------------------------
944DROP TABLE IF EXISTS `plants`;
945CREATE TABLE `plants` (
946 `id` int(11) NOT NULL AUTO_INCREMENT,
947 `type` int(1) NOT NULL,
948 `time` int(5) NOT NULL DEFAULT 3,
949 `totalTime` int(5) NOT NULL,
950 `posX` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
951 `posY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
952 `posZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
953 PRIMARY KEY (`id`) USING BTREE
954) ENGINE = MyISAM AUTO_INCREMENT = 66 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
955
956-- ----------------------------
957-- Records of plants
958-- ----------------------------
959INSERT INTO `plants` VALUES (19, 1, 0, 180, '-246,83', '-984,27', '30,95');
960INSERT INTO `plants` VALUES (49, 1, 0, 180, '-245,28', '-929,77', '31,45');
961INSERT INTO `plants` VALUES (50, 1, 0, 180, '-225,94', '-910,34', '31,48');
962INSERT INTO `plants` VALUES (51, 1, 0, 180, '-231,23', '-925,32', '31,29');
963INSERT INTO `plants` VALUES (52, 1, 0, 180, '-256,27', '-899,13', '31,45');
964INSERT INTO `plants` VALUES (53, 1, 0, 180, '-264,85', '-896,18', '31,48');
965INSERT INTO `plants` VALUES (54, 1, 0, 180, '-246,4', '-894,73', '31,3');
966
967-- ----------------------------
968-- Table structure for properties
969-- ----------------------------
970DROP TABLE IF EXISTS `properties`;
971CREATE TABLE `properties` (
972 `id` int(11) NOT NULL AUTO_INCREMENT,
973 `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
974 `ownerId` int(11) NOT NULL DEFAULT 0,
975 `price` int(11) NOT NULL,
976 `rent` int(4) NOT NULL DEFAULT 0,
977 `playerSlots` int(11) NOT NULL DEFAULT 1,
978 `vehicleSlots` int(11) NOT NULL DEFAULT 1,
979 `storage` int(11) NOT NULL DEFAULT 1000,
980 `garageId` int(11) NOT NULL DEFAULT 0,
981 `locked` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'True',
982 `posX` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
983 `posY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
984 `posZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
985 `rotZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
986 `posXi` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '347,26',
987 `posYi` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-999,29',
988 `posZi` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-99,19',
989 `rotZi` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
990 `IPLi` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
991 `posXb` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1087,8624',
992 `posYb` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-3099,3125',
993 `posZb` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-39,00363',
994 `rotZb` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '274,4692',
995 `IPLb` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'ex_exec_warehouse_placement_interior_1_int_warehouse_s_dlc_milo',
996 `storageX` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1104,822',
997 `storageY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-3099,403',
998 `storageZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-38,999',
999 `inventory` json NOT NULL,
1000 `occupants` json NOT NULL,
1001 PRIMARY KEY (`id`) USING BTREE
1002) ENGINE = MyISAM AUTO_INCREMENT = 1015 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1003
1004-- ----------------------------
1005-- Records of properties
1006-- ----------------------------
1007INSERT INTO `properties` VALUES (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]');
1008INSERT INTO `properties` VALUES (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', '[]', '[]');
1009INSERT INTO `properties` VALUES (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', '[]', '[]');
1010INSERT INTO `properties` VALUES (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', '[]', '[]');
1011INSERT INTO `properties` VALUES (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]');
1012INSERT INTO `properties` VALUES (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]');
1013INSERT INTO `properties` VALUES (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]');
1014INSERT INTO `properties` VALUES (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', '[]', '[]');
1015INSERT INTO `properties` VALUES (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]');
1016INSERT INTO `properties` VALUES (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', '[]', '[]');
1017INSERT INTO `properties` VALUES (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', '[]', '[]');
1018INSERT INTO `properties` VALUES (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', '[]', '[]');
1019INSERT INTO `properties` VALUES (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', '[]', '[]');
1020INSERT INTO `properties` VALUES (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', '[]', '[]');
1021
1022-- ----------------------------
1023-- Table structure for shops
1024-- ----------------------------
1025DROP TABLE IF EXISTS `shops`;
1026CREATE TABLE `shops` (
1027 `id` int(11) NOT NULL AUTO_INCREMENT,
1028 `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1029 `type` int(11) NOT NULL,
1030 `posX` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1031 `posY` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1032 `posZ` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1033 `rotZ` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1034 PRIMARY KEY (`id`) USING BTREE
1035) ENGINE = MyISAM AUTO_INCREMENT = 32 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1036
1037-- ----------------------------
1038-- Records of shops
1039-- ----------------------------
1040INSERT INTO `shops` VALUES (1, 'LTD Shop', 2, '-706,1013', '-914,6157', '19,21559', '88,92066');
1041INSERT INTO `shops` VALUES (2, 'Robs Liquor', 3, '-1222,07', '-908,3552', '12,32636', '34,99833');
1042INSERT INTO `shops` VALUES (3, 'Robs Liquor', 3, '-1486,214', '-378,1111', '40,16343', '129,9144');
1043INSERT INTO `shops` VALUES (4, '24/7', 1, '372,9709', '328,162', '103,5664', '251,9434');
1044INSERT INTO `shops` VALUES (5, 'LTD Shop', 2, '1164,824', '-323,6348', '69,20515', '98,30661');
1045INSERT INTO `shops` VALUES (6, 'Robs Liquor', 3, '1134,127', '-982,0408', '46,41585', '276,1852');
1046INSERT INTO `shops` VALUES (7, '24/7', 1, '24,50045', '-1345,557', '29,49702', '263,2627');
1047INSERT INTO `shops` VALUES (8, 'LTD Shop', 2, '-47,34829', '-1758,613', '29,421', '52,49707');
1048INSERT INTO `shops` VALUES (9, '24/7', 1, '2556,838', '380,8612', '108,6229', '353,6436');
1049INSERT INTO `shops` VALUES (10, 'Ammu-Nation', 9, '21,73938', '-1105,115', '29,79703', '163,5664');
1050INSERT INTO `shops` VALUES (11, 'Ammu-Nation', 9, '-662,3483', '-933,5735', '21,82924', '172,7118');
1051INSERT INTO `shops` VALUES (12, '24/7', 1, '2677,948', '3279,342', '55,24112', '321,2331');
1052INSERT INTO `shops` VALUES (13, '24/7', 1, '1727,912', '6415,285', '35,03721', '248,9729');
1053INSERT INTO `shops` VALUES (14, 'Ammu-Nation', 9, '810,8101', '-2158,992', '29,61901', '355,635');
1054INSERT INTO `shops` VALUES (15, 'Ammu-Nation', 9, '-331,1203', '6085,41', '31,45479', '218,3346');
1055INSERT INTO `shops` VALUES (16, '24/7', 1, '-3242,469', '999,8877', '12,8307', '343,3961');
1056INSERT INTO `shops` VALUES (17, 'Ammu-Nation', 9, '-3173,386', '1088,963', '20,83875', '243,0187');
1057INSERT INTO `shops` VALUES (18, '24/7', 1, '-3039,215', '584,4747', '7,908927', '11,59717');
1058INSERT INTO `shops` VALUES (19, 'Robs Liquor', 3, '-2966,428', '391,3408', '15,04332', '86,63471');
1059INSERT INTO `shops` VALUES (20, 'Ammu-Nation', 9, '1692,333', '3761,109', '34,70531', '223,7303');
1060INSERT INTO `shops` VALUES (21, '24/7', 1, '1959,116', '3741,606', '32,34375', '300,9392');
1061INSERT INTO `shops` VALUES (22, '24/7', 1, '549,0751', '2671,054', '42,15648', '92,38366');
1062INSERT INTO `shops` VALUES (23, 'Scoops Liquor Barn', 3, '1165,698', '2710,84', '38,15771', '168,4661');
1063INSERT INTO `shops` VALUES (24, 'Ammu-Nation', 9, '-1118,351', '2700,302', '18,55415', '205,9733');
1064INSERT INTO `shops` VALUES (25, 'Robs Liquor', 3, '1392,845', '3606,478', '34,98093', '194,5726');
1065INSERT INTO `shops` VALUES (26, 'Donutladen', 5, '435,1627', '-974,3655', '30,97778', '88,20151');
1066INSERT INTO `shops` VALUES (27, 'Fresh Fruits', 8, '196,806', '-993,626', '30,09191', '49,78316');
1067INSERT INTO `shops` VALUES (28, 'Chihuahua Hotdogs', 4, '153,9446', '-982,5247', '30,16298', '329,0476');
1068INSERT INTO `shops` VALUES (29, 'Cheap Shot Coffee', 7, '152,236', '-964,3322', '30,29083', '231,6664');
1069INSERT INTO `shops` VALUES (30, 'Chihuahua Hotdogs', 4, '215,0492', '-899,9711', '30,69249', '186,3291');
1070INSERT INTO `shops` VALUES (31, 'Ammu-Nation', 9, '254,2706', '-50,93164', '69,98112', '72,74512');
1071
1072-- ----------------------------
1073-- Table structure for vehdata
1074-- ----------------------------
1075DROP TABLE IF EXISTS `vehdata`;
1076CREATE TABLE `vehdata` (
1077 `id` int(11) NOT NULL AUTO_INCREMENT,
1078 `model` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1079 `fuelType` int(1) NOT NULL DEFAULT 1,
1080 `maxFuel` int(5) NOT NULL DEFAULT 100,
1081 `fuelConsumption` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0,1',
1082 `maxStorage` int(5) NOT NULL DEFAULT 40,
1083 `engineMulti` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1,0',
1084 `hasSiren` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'False',
1085 PRIMARY KEY (`id`) USING BTREE
1086) ENGINE = MyISAM AUTO_INCREMENT = 57 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1087
1088-- ----------------------------
1089-- Records of vehdata
1090-- ----------------------------
1091INSERT INTO `vehdata` VALUES (1, 'brioso', 1, 60, '0,05', 40, '1,0', 'False');
1092INSERT INTO `vehdata` VALUES (2, 'blista2', 1, 65, '0,06', 40, '1,0', 'False');
1093INSERT INTO `vehdata` VALUES (3, 'dilettante', 1, 70, '0,06', 45, '1,0', 'False');
1094INSERT INTO `vehdata` VALUES (4, 'blista', 1, 65, '0,06', 45, '1,0', 'False');
1095INSERT INTO `vehdata` VALUES (5, 'issi2', 1, 60, '0,07', 40, '1,0', 'False');
1096INSERT INTO `vehdata` VALUES (6, 'panto', 1, 45, '0,07', 20, '1,0', 'False');
1097INSERT INTO `vehdata` VALUES (7, 'prairie', 1, 70, '0,07', 35, '1,0', 'False');
1098INSERT INTO `vehdata` VALUES (8, 'rhapsody', 1, 50, '0,06', 40, '1,0', 'False');
1099INSERT INTO `vehdata` VALUES (9, 'f620', 1, 60, '0,08', 40, '1,0', 'False');
1100INSERT INTO `vehdata` VALUES (10, 'cogcabrio', 1, 65, '0,08', 45, '1,0', 'False');
1101INSERT INTO `vehdata` VALUES (11, 'felon', 1, 55, '0,09', 50, '1,0', 'False');
1102INSERT INTO `vehdata` VALUES (12, 'sentinel2', 1, 60, '0,08', 50, '1,0', 'False');
1103INSERT INTO `vehdata` VALUES (13, 'jackal', 1, 70, '0,07', 55, '1,0', 'False');
1104INSERT INTO `vehdata` VALUES (14, 'zion', 1, 65, '0,08', 55, '1,0', 'False');
1105INSERT INTO `vehdata` VALUES (15, 'ambulance', 2, 110, '0,05', 100, '1,0', 'True');
1106INSERT INTO `vehdata` VALUES (16, 'ambulance2', 2, 95, '0,05', 100, '1,0', 'True');
1107INSERT INTO `vehdata` VALUES (17, 'barracks3', 2, 150, '0,07', 130, '1,0', 'False');
1108INSERT INTO `vehdata` VALUES (18, 'blazer2', 1, 40, '0,05', 15, '1,0', 'True');
1109INSERT INTO `vehdata` VALUES (19, 'dubsta2', 2, 90, '0,09', 50, '1,0', 'False');
1110INSERT INTO `vehdata` VALUES (20, 'fibp', 1, 80, '0,08', 70, '1,0', 'True');
1111INSERT INTO `vehdata` VALUES (21, 'hotknife', 2, 60, '0,1', 40, '1,0', 'False');
1112INSERT INTO `vehdata` VALUES (22, 'lguard', 2, 80, '0,07', 55, '1,0', 'True');
1113INSERT INTO `vehdata` VALUES (23, 'lsfd', 2, 100, '0,1', 50, '1,0', 'True');
1114INSERT INTO `vehdata` VALUES (24, 'lsfd2', 2, 100, '0,1', 60, '1,0', 'True');
1115INSERT INTO `vehdata` VALUES (25, 'lsfd3', 2, 100, '0,1', 100, '1,0', 'True');
1116INSERT INTO `vehdata` VALUES (26, 'lsfd4', 2, 100, '0,1', 100, '1,0', 'True');
1117INSERT INTO `vehdata` VALUES (27, 'lsfd5', 2, 100, '0,1', 50, '1,0', 'True');
1118INSERT INTO `vehdata` VALUES (28, 'lsfdtruck', 2, 130, '0,07', 150, '1,0', 'True');
1119INSERT INTO `vehdata` VALUES (29, 'lsfdtruck2', 2, 130, '0,07', 150, '1,0', 'True');
1120INSERT INTO `vehdata` VALUES (30, 'lsfdtruck3', 2, 130, '0,07', 150, '1,0', 'True');
1121INSERT INTO `vehdata` VALUES (31, 'nef-1', 2, 100, '0,1', 50, '1,0', 'True');
1122INSERT INTO `vehdata` VALUES (32, 'neon', 1, 100, '0,1', 50, '1,0', 'False');
1123INSERT INTO `vehdata` VALUES (33, 'pbus', 2, 130, '0,09', 50, '1,0', 'True');
1124INSERT INTO `vehdata` VALUES (34, 'police', 2, 100, '0,1', 50, '1,0', 'True');
1125INSERT INTO `vehdata` VALUES (35, 'police2', 2, 100, '0,1', 50, '1,0', 'True');
1126INSERT INTO `vehdata` VALUES (36, 'police3', 2, 100, '0,1', 50, '1,0', 'True');
1127INSERT INTO `vehdata` VALUES (37, 'police4', 2, 100, '0,1', 50, '1,0', 'True');
1128INSERT INTO `vehdata` VALUES (38, 'policeb', 2, 100, '0,1', 50, '1,0', 'True');
1129INSERT INTO `vehdata` VALUES (39, 'policet', 2, 100, '0,1', 50, '1,0', 'True');
1130INSERT INTO `vehdata` VALUES (40, 'pranger', 2, 100, '0,1', 50, '1,0', 'True');
1131INSERT INTO `vehdata` VALUES (41, 'riot', 2, 100, '0,1', 50, '1,0', 'True');
1132INSERT INTO `vehdata` VALUES (42, 'riot2', 2, 100, '0,1', 50, '1,0', 'True');
1133INSERT INTO `vehdata` VALUES (43, 'sheriff', 2, 100, '0,1', 50, '1,0', 'True');
1134INSERT INTO `vehdata` VALUES (44, 'sheriff2', 2, 100, '0,1', 50, '1,0', 'True');
1135INSERT INTO `vehdata` VALUES (45, 't20', 1, 100, '0,1', 50, '1,0', 'False');
1136INSERT INTO `vehdata` VALUES (46, 'volatus', 4, 100, '0,1', 50, '1,0', 'False');
1137INSERT INTO `vehdata` VALUES (47, 'james', 2, 2000, '0,2', 8000, '1,0', 'False');
1138INSERT INTO `vehdata` VALUES (48, 'schlagen', 1, 65, '0,08', 40, '1,0', 'False');
1139INSERT INTO `vehdata` VALUES (49, 'schafter3', 1, 80, '0,07', 60, '1,0', 'False');
1140INSERT INTO `vehdata` VALUES (50, 'schwarzer', 1, 70, '0,07', 55, '1,0', 'False');
1141INSERT INTO `vehdata` VALUES (51, 'surano', 1, 65, '0,08', 50, '1,0', 'False');
1142INSERT INTO `vehdata` VALUES (52, 'xls', 2, 80, '0,07', 70, '1,0', 'False');
1143INSERT INTO `vehdata` VALUES (53, 'dubsta', 2, 90, '0,09', 80, '1,0', 'False');
1144INSERT INTO `vehdata` VALUES (54, 'feltzer2', 1, 60, '0,08', 40, '1,0', 'False');
1145INSERT INTO `vehdata` VALUES (55, 'schafter3', 1, 80, '0,09', 60, '1,0', 'False');
1146INSERT INTO `vehdata` VALUES (56, 'serrano', 2, 65, '0,08', 60, '1,0', 'False');
1147
1148-- ----------------------------
1149-- Table structure for vehicles
1150-- ----------------------------
1151DROP TABLE IF EXISTS `vehicles`;
1152CREATE TABLE `vehicles` (
1153 `id` int(11) NOT NULL AUTO_INCREMENT,
1154 `ownerId` int(11) NOT NULL,
1155 `model` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1156 `health` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1157 `fuel` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1158 `col1` int(3) NOT NULL DEFAULT 4,
1159 `col2` int(3) NOT NULL DEFAULT 4,
1160 `livery` int(2) NOT NULL DEFAULT 255,
1161 `inGarage` int(1) NOT NULL,
1162 `garageId` int(11) NOT NULL DEFAULT 0,
1163 `isRegistered` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'False',
1164 `posX` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1165 `posY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1166 `posZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1167 `rotZ` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1168 `inventory` json NOT NULL,
1169 PRIMARY KEY (`id`) USING BTREE
1170) ENGINE = MyISAM AUTO_INCREMENT = 113 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
1171
1172-- ----------------------------
1173-- Records of vehicles
1174-- ----------------------------
1175INSERT INTO `vehicles` VALUES (5, 10001, 'Brioso', '1000', '100', 4, 0, 255, 0, 1009, 'False', '-349,96', '286,22', '84,58', '271,965', '[]');
1176INSERT INTO `vehicles` VALUES (9, 10002, 'Blista2', '1000', '100', 4, 0, 255, 0, 1004, 'False', '-56,89', '-1097,65', '25,98', '297,397', '[]');
1177INSERT INTO `vehicles` VALUES (8, 10002, 'Dilettante', '1000', '100', 4, 0, 255, 1, 1003, 'False', '-350,28', '296,79', '84,59', '270,832', '[]');
1178INSERT INTO `vehicles` VALUES (10, 10001, 'f620', '1000', '100', 4, 0, 255, 0, 1005, 'False', '-49,31', '-1101,26', '25,87', '318,59', '[]');
1179INSERT INTO `vehicles` VALUES (109, 10015, 'cogcabrio', '1000', '99,90096', 4, 0, 255, 0, 0, 'True', '824,26', '-1027,55', '25,76', '183,1895', '[]');
1180INSERT INTO `vehicles` VALUES (106, 10015, 'cogcabrio', '1000', '100', 4, 0, 255, 0, 0, 'True', '1179,22', '-333,43', '68,63', '287,9306', '[]');
1181INSERT INTO `vehicles` VALUES (107, 10013, 'zion', '1000', '100', 4, 0, 255, 0, 0, 'False', '-521,74', '-1211,17', '17,57', '242,3361', '[]');
1182INSERT INTO `vehicles` VALUES (108, 10003, 'sentinel2', '907,6242', '60', 4, 0, 255, 0, 0, 'True', '424,88', '-1027,77', '28,41', '184,821', '[]');
1183INSERT INTO `vehicles` VALUES (11, 10002, 'f620', '1000', '100', 4, 0, 255, 1, 1004, 'False', '-46,43', '-1102,43', '26,11', '318,59', '[]');
1184INSERT INTO `vehicles` VALUES (13, 1, 'police', '1000', '100', 4, 0, 255, 1, 1001, 'False', '-41,84', '-1094,77', '26,14', '190,25', '[]');
1185INSERT INTO `vehicles` VALUES (12, 1, 'police', '1000', '100', 4, 0, 255, 1, 1001, 'False', '-47,69', '-1092,55', '25,8', '190,25', '[]');
1186INSERT INTO `vehicles` VALUES (14, 1, 'police2', '1000', '100', 4, 0, 255, 1, 1014, 'False', '-35,11', '-1099,01', '25,81', '138,793', '[]');
1187INSERT INTO `vehicles` VALUES (15, 1, 'police2', '1000', '100', 4, 0, 255, 1, 1001, 'False', '-1156,86', '-1707,69', '3,85', '0,028', '[]');
1188INSERT INTO `vehicles` VALUES (16, 1, 'police3', '1000', '100', 4, 0, 255, 1, 1001, 'False', '-1163,27', '-1712,4', '3,83', '-0,014', '[]');
1189INSERT INTO `vehicles` VALUES (17, 1, 'police3', '1000', '100', 4, 0, 255, 1, 1001, 'False', '-1169,66', '-1716,87', '4,12', '0,245', '[]');
1190INSERT INTO `vehicles` VALUES (18, 1, 'police4', '1000', '100', 4, 0, 255, 1, 1001, 'False', '-1175,49', '-1720,74', '4,18', '-0,042', '[]');
1191INSERT INTO `vehicles` VALUES (19, 1, 'police4', '1000', '100', 4, 0, 255, 1, 1014, 'False', '-1181,22', '-1724,71', '4,47', '-0,022', '[]');
1192INSERT INTO `vehicles` VALUES (20, 10003, 'sentinel2', '1000', '100', 4, 0, 255, 0, 1005, 'True', '-1128,37', '-1729,07', '4,44', '18,233', '[]');
1193INSERT INTO `vehicles` VALUES (21, 4, 'ambulance', '1000', '109,25', 4, 0, 255, 0, 1002, 'False', '-409,76', '-281,6', '35,01', '285,6213', '[]');
1194INSERT INTO `vehicles` VALUES (22, 4, 'ambulance', '1000', '100', 0, 0, 255, 0, 1002, 'True', '1175', '-1546,19', '39,17', '0,001342773', '[]');
1195INSERT INTO `vehicles` VALUES (23, 4, 'ambulance', '1000', '100', 4, 0, 255, 1, 1002, 'False', '-1114,36', '-1719,91', '4,56', '3,244', '[]');
1196INSERT INTO `vehicles` VALUES (24, 4, 'ambulance', '1000', '100', 0, 0, 255, 1, 1002, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null');
1197INSERT INTO `vehicles` VALUES (25, 4, 'ambulance2', '1000', '100', 0, 0, 255, 1, 1002, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null');
1198INSERT INTO `vehicles` VALUES (26, 4, 'ambulance2', '1000', '99,5', 0, 0, 255, 0, 1002, 'True', '331,98', '-541,61', '28,48', '181,0619', '[]');
1199INSERT INTO `vehicles` VALUES (27, 4, 'ambulance2', '1000', '100', 0, 0, 255, 1, 1002, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null');
1200INSERT INTO `vehicles` VALUES (28, 4, 'ambulance2', '1000', '88,50018', 0, 0, 255, 0, 1002, 'True', '1201,93', '-1535,7', '39,14', '174,0112', '[]');
1201INSERT INTO `vehicles` VALUES (29, 4, 'lsfd', '1000', '100', 0, 0, 255, 1, 1002, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null');
1202INSERT INTO `vehicles` VALUES (30, 4, 'lsfd', '1000', '89,80016', 0, 0, 255, 1, 1002, 'True', '1194,86', '-1495,67', '34,37', '359,931', '[]');
1203INSERT INTO `vehicles` VALUES (31, 4, 'lsfd2', '1000', '91,70013', 0, 0, 255, 0, 1002, 'True', '1215,61', '-1525,52', '34,41', '179,6981', '[]');
1204INSERT INTO `vehicles` VALUES (32, 4, 'lsfd3', '1000', '84,10025', 0, 0, 255, 0, 1002, 'True', '334,96', '-541,79', '28,37', '179,3879', '[]');
1205INSERT INTO `vehicles` VALUES (33, 4, 'lsfd3', '1000', '94,50008', 0, 0, 255, 1, 1002, 'True', '1203,6', '-1489,86', '34,35', '307,3761', '[]');
1206INSERT INTO `vehicles` VALUES (34, 4, 'lsfd4', '1000', '51,30074', 0, 0, 255, 0, 1002, 'True', '1192,18', '-1546,46', '39,41', '359,9901', '[]');
1207INSERT INTO `vehicles` VALUES (35, 4, 'lsfd4', '1000', '89,10017', 0, 0, 255, 1, 1002, 'True', '1196,81', '-1480,19', '34,85', '0,0402832', '[]');
1208INSERT INTO `vehicles` VALUES (36, 4, 'lsfd5', '1000', '83,80025', 0, 0, 255, 0, 1002, 'True', '1200,92', '-1466,89', '34,53', '359,8689', '[]');
1209INSERT INTO `vehicles` VALUES (37, 4, 'lsfdtruck', '1000', '100', 0, 0, 255, 1, 1002, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null');
1210INSERT INTO `vehicles` VALUES (38, 4, 'lsfdtruck', '1000', '98,30003', 0, 0, 255, 1, 1002, 'True', '1203,37', '-1490,5', '34,83', '177,6132', '[]');
1211INSERT INTO `vehicles` VALUES (39, 4, 'lsfdtruck', '1000', '100', 0, 0, 255, 1, 1002, 'True', '1204,73', '-1468,35', '34,93', '359,9793', 'null');
1212INSERT INTO `vehicles` VALUES (40, 4, 'lsfdtruck2', '1000', '100', 0, 0, 255, 1, 1002, 'True', '1195,79', '-1491,96', '35,02', '179,5983', '[]');
1213INSERT INTO `vehicles` VALUES (41, 4, 'lsfdtruck3', '1000', '71,00044', 0, 0, 255, 1, 1002, 'True', '1199,59', '-1491,84', '34,8', '179,6813', '[]');
1214INSERT INTO `vehicles` VALUES (42, 1, 'riot', '1000', '63,90055', 0, 0, 255, 0, 1017, 'False', '406,63', '-992,2', '28,93', '50,10342', '[]');
1215INSERT INTO `vehicles` VALUES (43, 1, 'riot2', '1000', '-0,09904858', 0, 0, 255, 1, 1014, 'False', '439,65', '-1016,26', '28,53', '64,57562', '[]');
1216INSERT INTO `vehicles` VALUES (44, 4, 'lsfdtruck', '1000', '100', 0, 0, 255, 1, 1018, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null');
1217INSERT INTO `vehicles` VALUES (45, 4, 'lsfdtruck', '1000', '100', 0, 0, 255, 0, 1018, 'False', '-635,09', '-113,49', '38,1', '84,91574', '[]');
1218INSERT INTO `vehicles` VALUES (46, 4, 'lsfdtruck', '1000', '100', 0, 0, 255, 1, 1018, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null');
1219INSERT INTO `vehicles` VALUES (47, 4, 'lsfdtruck', '1000', '100', 0, 0, 255, 1, 1018, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null');
1220INSERT INTO `vehicles` VALUES (48, 4, 'lsfdtruck2', '1000', '100', 0, 0, 255, 1, 1018, 'False', '-632,54', '-97,62', '38,38', '84,25839', 'null');
1221INSERT INTO `vehicles` VALUES (49, 4, 'lsfdtruck2', '1000', '100', 0, 0, 255, 1, 1018, 'True', '-638,35', '-104,76', '38,04', '94,78943', 'null');
1222INSERT INTO `vehicles` VALUES (50, 4, 'lsfdtruck3', '1000', '100', 0, 0, 255, 1, 1018, 'True', '-638,35', '-104,76', '38,04', '94,78943', '[]');
1223INSERT INTO `vehicles` VALUES (51, 4, 'lsfdtruck3', '1000', '100', 0, 0, 255, 1, 1018, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null');
1224INSERT INTO `vehicles` VALUES (52, 4, 'lsfd', '1000', '100', 0, 0, 255, 1, 1018, 'True', '1196,69', '-1495,81', '34,69', '181,73', 'null');
1225INSERT INTO `vehicles` VALUES (53, 4, 'lsfd', '1000', '100', 0, 0, 255, 1, 1019, 'True', '207,59', '-1673,36', '29,41', '139,6198', 'null');
1226INSERT INTO `vehicles` VALUES (54, 4, 'lsfd2', '1000', '100', 0, 0, 255, 1, 1019, 'True', '197,83', '-1667,37', '29,8', '139,0015', 'null');
1227INSERT INTO `vehicles` VALUES (55, 4, 'lsfd3', '1000', '99,50001', 0, 0, 255, 0, 1012, 'True', '1200,7', '-1478,85', '34,48', '0,6375122', '[]');
1228INSERT INTO `vehicles` VALUES (56, 4, 'lsfd4', '1000', '85,70022', 0, 0, 255, 0, 1012, 'True', '-43,59', '1878,57', '196,28', '167,7517', '[]');
1229INSERT INTO `vehicles` VALUES (57, 4, 'lsfd5', '748,754', '100', 0, 0, 255, 1, 1019, 'False', '197,05', '-1664,9', '29,47', '1,27475', 'null');
1230INSERT INTO `vehicles` VALUES (58, 4, 'lsfd5', '1000', '100', 0, 0, 255, 1, 1019, 'True', '194,53', '-1670,08', '29,47', '225,6304', 'null');
1231INSERT INTO `vehicles` VALUES (59, 4, 'NEF-1', '1000', '91,90013', 0, 0, 255, 0, 1002, 'True', '1185,33', '-1547,04', '39,34', '359,7902', '[]');
1232INSERT INTO `vehicles` VALUES (60, 4, 'NEF-1', '1000', '-0,09904858', 0, 0, 255, 0, 1002, 'True', '9,5', '-1356,48', '29,16', '80,7041', '[]');
1233INSERT INTO `vehicles` VALUES (79, 1, 'policet', '1000', '97,10004', 131, 0, 255, 1, 1014, 'True', '442,1', '-1017,93', '28,66', '238,0742', '[]');
1234INSERT INTO `vehicles` VALUES (61, 0, 'hotknife', '1000', '100', 4, 0, 255, 0, 0, 'False', '924,04', '-968,33', '44,47', '0', '[]');
1235INSERT INTO `vehicles` VALUES (62, 0, 'hotknife', '1000', '100', 4, 0, 255, 0, 0, 'False', '93129', '-968,33', '44,47', '0', '[]');
1236INSERT INTO `vehicles` VALUES (69, 8, 'dubsta2', '1000', '100', 0, 0, 255, 1, 1025, 'True', '-1524,77', '82,46', '56,55', '7,031225', 'null');
1237INSERT INTO `vehicles` VALUES (63, 10004, 'Blista2', '1000', '100', 4, 0, 255, 1, 1032, 'False', '621,77', '281,49', '102,59', '308,4686', 'null');
1238INSERT INTO `vehicles` VALUES (64, 10004, 'felon', '1000', '86,7002', 43, 0, 255, 0, 1032, 'False', '1368,17', '1155,23', '113,45', '55,5054', '[]');
1239INSERT INTO `vehicles` VALUES (65, 10005, 'sentinel2', '1000', '100', 140, 0, 255, 0, 1010, 'False', '223,36', '-127,83', '63,16', '244,8822', '[]');
1240INSERT INTO `vehicles` VALUES (66, 10001, 'Rhapsody', '1000', '100', 4, 0, 255, 0, 0, 'False', '-328,35', '299,3', '85,9', '94,89725', '[]');
1241INSERT INTO `vehicles` VALUES (67, 10006, 't20', '1000', '100', 0, 0, 255, 0, 1009, 'False', '-1535,68', '85,41', '56,35', '324,6274', '[]');
1242INSERT INTO `vehicles` VALUES (68, 8, 'volatus', '1000', '91,00014', 0, 0, 255, 1, 1026, 'True', '-1542,94', '80,27', '61,97', '230,7121', 'null');
1243INSERT INTO `vehicles` VALUES (70, 8, 'dubsta2', '1000', '100', 0, 0, 255, 1, 1025, 'True', '0,0', '0,0', '0,0', '0,0', 'null');
1244INSERT INTO `vehicles` VALUES (74, 8, 'neon', '1000', '100', 0, 0, 255, 1, 1025, 'True', '-1524,77', '82,46', '56,55', '7,031225', 'null');
1245INSERT INTO `vehicles` VALUES (71, 8, 'dubsta2', '1000', '100', 0, 0, 255, 1, 1025, 'True', '0,0', '0,0', '0,0', '0,0', 'null');
1246INSERT INTO `vehicles` VALUES (72, 8, 'dubsta2', '1000', '100', 0, 0, 255, 1, 1025, 'True', '0,0', '0,0', '0,0', '0,0', 'null');
1247INSERT INTO `vehicles` VALUES (75, 8, 'neon', '1000', '100', 0, 0, 255, 1, 1025, 'True', '0,0', '0,0', '0,0', '0,0', 'null');
1248INSERT INTO `vehicles` VALUES (76, 8, 'neon', '1000', '100', 0, 0, 255, 1, 1025, 'True', '0,0', '0,0', '0,0', '0,0', 'null');
1249INSERT INTO `vehicles` VALUES (77, 8, 'neon', '1000', '100', 0, 0, 255, 1, 1025, 'True', '0,0', '0,0', '0,0', '0,0', 'null');
1250INSERT INTO `vehicles` VALUES (78, 8, 'neon', '1000', '100', 0, 0, 255, 1, 1025, 'True', '-1524,77', '82,46', '56,55', '7,031225', 'null');
1251INSERT INTO `vehicles` VALUES (80, 1, 'policet', '1000', '-0,09904858', 131, 0, 255, 0, 1014, 'True', '448,81', '-1024,62', '28,54', '4,40152', '[]');
1252INSERT INTO `vehicles` VALUES (81, 1, 'pranger', '1000', '91,00014', 131, 0, 255, 0, 1014, 'True', '439,5', '-1024,59', '28,33', '0,2683716', '[]');
1253INSERT INTO `vehicles` VALUES (82, 1, 'pranger', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null');
1254INSERT INTO `vehicles` VALUES (83, 1, 'sheriff', '1000', '-0,09905621', 131, 0, 255, 0, 1014, 'True', '409,49', '-1028,41', '28,99', '172,7388', '[]');
1255INSERT INTO `vehicles` VALUES (84, 1, 'sheriff', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null');
1256INSERT INTO `vehicles` VALUES (85, 1, 'sheriff2', '1000', '97,20004', 131, 0, 255, 1, 1014, 'True', '436,39', '-997,44', '25,76', '175,9671', '[]');
1257INSERT INTO `vehicles` VALUES (86, 1, 'sheriff2', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null');
1258INSERT INTO `vehicles` VALUES (87, 1, 'policeb', '1000', '-0,09904858', 131, 0, 255, 0, 1014, 'True', '87,06', '-813,15', '30,85', '165,829', '[]');
1259INSERT INTO `vehicles` VALUES (88, 1, 'policeb', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null');
1260INSERT INTO `vehicles` VALUES (89, 1, 'policeb', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null');
1261INSERT INTO `vehicles` VALUES (90, 1, 'police', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null');
1262INSERT INTO `vehicles` VALUES (91, 1, 'police', '1000', '-0,09904858', 131, 0, 255, 0, 1014, 'True', '442,97', '-1025,96', '28,31', '188,2796', '[]');
1263INSERT INTO `vehicles` VALUES (92, 1, 'police2', '1000', '97,90003', 131, 0, 255, 1, 1014, 'True', '431,33', '-1026,36', '28,51', '359,7169', 'null');
1264INSERT INTO `vehicles` VALUES (93, 1, 'police2', '1000', '100', 131, 12, 255, 1, 1014, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null');
1265INSERT INTO `vehicles` VALUES (94, 1, 'police3', '-3082,056', '19,50099', 131, 0, 255, 1, 1014, 'True', '451,68', '-1006,29', '27,31', '272,9483', 'null');
1266INSERT INTO `vehicles` VALUES (95, 1, 'police3', '1000', '-0,09904858', 131, 0, 255, 0, 1014, 'True', '431,72', '-1025,86', '28,64', '179,3765', '[]');
1267INSERT INTO `vehicles` VALUES (96, 1, 'police4', '1000', '-0,09904858', 131, 0, 255, 0, 1014, 'True', '429,07', '-1026,32', '28,54', '179,7118', '[]');
1268INSERT INTO `vehicles` VALUES (97, 1, 'police4', '1000', '-0,09904858', 131, 0, 255, 0, 1014, 'True', '434,69', '-1025,52', '28,43', '177,5847', '[]');
1269INSERT INTO `vehicles` VALUES (98, 1, 'pbus', '1000', '100', 131, 12, 255, 1, 1015, 'True', '855,34', '-1279,49', '26,07', '1,194', 'null');
1270INSERT INTO `vehicles` VALUES (99, 4, 'blazer2', '1000', '90,19977', 111, 0, 255, 1, 1038, 'True', '-1205,43', '-1799', '3,94', '68,61', '[]');
1271INSERT INTO `vehicles` VALUES (100, 4, 'lguard', '1000', '66,35006', 111, 0, 255, 1, 1038, 'True', '-1205,43', '-1799', '3,94', '68,61', '[]');
1272INSERT INTO `vehicles` VALUES (101, 10008, 'cogcabrio', '1000', '54,3007', 4, 0, 255, 0, 1027, 'True', '-532,73', '267,42', '82,39', '320,2188', '[]');
1273INSERT INTO `vehicles` VALUES (102, 2, 'fibp', '1000', '-0,09904572', 4, 0, 255, 0, 1024, 'True', '-156,92', '-1512,4', '33,35', '227,6397', '[]');
1274INSERT INTO `vehicles` VALUES (103, 3, 'barracks3', '1000', '95,50007', 4, 0, 255, 1, 1023, 'True', '-2409,67', '3332,1', '32,83', '237,1624', '[]');
1275INSERT INTO `vehicles` VALUES (104, 3, 'james', '1000', '2000', 4, 0, 255, 0, 1037, 'True', '524,73', '-3315,43', '-0,84', '182,7323', '[]');
1276INSERT INTO `vehicles` VALUES (105, 10001, 'schlagen', '1000', '5,319267', 4, 0, 255, 0, 1009, 'True', '-1677,36', '-301,13', '51,1', '55,28082', '[]');
1277INSERT INTO `vehicles` VALUES (110, 10015, 'cogcabrio', '1000', '99,40001', 4, 0, 255, 0, 0, 'True', '408', '-984,55', '28,72', '234,9836', '[]');
1278INSERT INTO `vehicles` VALUES (111, 10013, 'cogcabrio', '1000', '57,40065', 4, 0, 255, 0, 0, 'False', '-677,73', '903,05', '230,04', '326,3979', '[]');
1279INSERT INTO `vehicles` VALUES (112, 10013, 'issi2', '1000', '92,80011', 4, 0, 255, 0, 0, 'False', '-340,82', '258,13', '85,18', '95,95416', '[]');
1280
1281SET FOREIGN_KEY_CHECKS = 1;