HbaGLH7L

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : MAIN
5Source Server Version : 50525
6Source Host           : localhost:3316
7Source Database       : dayz
8
9Target Server Type    : MYSQL
10Target Server Version : 50525
11File Encoding         : 65001
12
13Date: 2012-11-01 13:31:09
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `building`
20-- ----------------------------
21DROP TABLE IF EXISTS `building`;
22CREATE TABLE `building` (
23  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
24  `class_name` varchar(100) DEFAULT NULL,
25  PRIMARY KEY (`id`),
26  UNIQUE KEY `uq1_building` (`class_name`)
27) ENGINE=InnoDB AUTO_INCREMENT=719 DEFAULT CHARSET=utf8;
28
29-- ----------------------------
30-- Records of building
31-- ----------------------------
32INSERT INTO `building` VALUES ('510', 'ACamp');
33INSERT INTO `building` VALUES ('322', 'Barrels');
34INSERT INTO `building` VALUES ('641', 'Base_WarfareBBarrier10x');
35INSERT INTO `building` VALUES ('521', 'BMP2Wreck');
36INSERT INTO `building` VALUES ('650', 'Body');
37INSERT INTO `building` VALUES ('506', 'BRDMWreck');
38INSERT INTO `building` VALUES ('603', 'Camp');
39INSERT INTO `building` VALUES ('643', 'CampEast');
40INSERT INTO `building` VALUES ('648', 'CDF_WarfareBContructionSite1');
41INSERT INTO `building` VALUES ('343', 'datsun02Wreck');
42INSERT INTO `building` VALUES ('333', 'Fence_corrugated_plate');
43INSERT INTO `building` VALUES ('387', 'Fishing_Boat');
44INSERT INTO `building` VALUES ('513', 'FoldChair');
45INSERT INTO `building` VALUES ('483', 'Fort_Barricade');
46INSERT INTO `building` VALUES ('318', 'Fort_Crate_wood');
47INSERT INTO `building` VALUES ('392', 'Fort_StoneWall_EP1');
48INSERT INTO `building` VALUES ('672', 'Garbage_can');
49INSERT INTO `building` VALUES ('339', 'Garbage_container');
50INSERT INTO `building` VALUES ('398', 'GraveCross1');
51INSERT INTO `building` VALUES ('399', 'GraveCross2');
52INSERT INTO `building` VALUES ('320', 'GuerillaCacheBox');
53INSERT INTO `building` VALUES ('397', 'Hanged');
54INSERT INTO `building` VALUES ('396', 'Hanged_MD');
55INSERT INTO `building` VALUES ('345', 'Haystack');
56INSERT INTO `building` VALUES ('570', 'Haystack_small');
57INSERT INTO `building` VALUES ('701', 'HeliHRescue');
58INSERT INTO `building` VALUES ('354', 'Hhedgehog_concrete');
59INSERT INTO `building` VALUES ('347', 'hiluxWreck');
60INSERT INTO `building` VALUES ('640', 'HMMWVWreck');
61INSERT INTO `building` VALUES ('465', 'Land_A_Castle_Bergfrit');
62INSERT INTO `building` VALUES ('466', 'Land_A_Castle_Donjon');
63INSERT INTO `building` VALUES ('464', 'Land_A_Castle_Wall1_20');
64INSERT INTO `building` VALUES ('453', 'Land_A_Castle_Wall1_End');
65INSERT INTO `building` VALUES ('457', 'Land_A_Castle_Wall1_End_2');
66INSERT INTO `building` VALUES ('463', 'Land_A_Castle_Wall2_30');
67INSERT INTO `building` VALUES ('627', 'Land_A_CraneCon');
68INSERT INTO `building` VALUES ('709', 'Land_A_FuelStation_Shed');
69INSERT INTO `building` VALUES ('704', 'Land_A_GeneralStore_01');
70INSERT INTO `building` VALUES ('468', 'Land_A_Hospital');
71INSERT INTO `building` VALUES ('300', 'Land_a_stationhouse');
72INSERT INTO `building` VALUES ('511', 'Land_A_tent');
73INSERT INTO `building` VALUES ('524', 'Land_Barn_Metal');
74INSERT INTO `building` VALUES ('702', 'Land_Barrack2');
75INSERT INTO `building` VALUES ('700', 'Land_Barrel_empty');
76INSERT INTO `building` VALUES ('452', 'Land_brana02nodoor');
77INSERT INTO `building` VALUES ('644', 'Land_Campfire_burning');
78INSERT INTO `building` VALUES ('391', 'Land_Church_05R');
79INSERT INTO `building` VALUES ('459', 'Land_CncBlock');
80INSERT INTO `building` VALUES ('718', 'Land_ConcreteRamp');
81INSERT INTO `building` VALUES ('705', 'Land_Dirthump01');
82INSERT INTO `building` VALUES ('380', 'Land_Dirthump03');
83INSERT INTO `building` VALUES ('530', 'Land_Farm_Cowshed_b');
84INSERT INTO `building` VALUES ('649', 'Land_Fire');
85INSERT INTO `building` VALUES ('661', 'Land_Fire_barrel_burning');
86INSERT INTO `building` VALUES ('518', 'Land_fortified_nest_big');
87INSERT INTO `building` VALUES ('330', 'Land_fortified_nest_small');
88INSERT INTO `building` VALUES ('713', 'Land_fort_artillery_nest');
89INSERT INTO `building` VALUES ('304', 'Land_fort_bagfence_corner');
90INSERT INTO `building` VALUES ('361', 'Land_fort_bagfence_round');
91INSERT INTO `building` VALUES ('662', 'Land_fort_rampart');
92INSERT INTO `building` VALUES ('473', 'Land_Fort_Watchtower');
93INSERT INTO `building` VALUES ('331', 'Land_HBarrier1');
94INSERT INTO `building` VALUES ('314', 'Land_HBarrier_large');
95INSERT INTO `building` VALUES ('710', 'Land_Hlidac_budka');
96INSERT INTO `building` VALUES ('602', 'Land_Ind_BoardsPack1');
97INSERT INTO `building` VALUES ('628', 'Land_Ind_BoardsPack2');
98INSERT INTO `building` VALUES ('303', 'Land_Ind_Garage01');
99INSERT INTO `building` VALUES ('356', 'Land_Ind_IlluminantTower');
100INSERT INTO `building` VALUES ('474', 'Land_Ind_Pec_01');
101INSERT INTO `building` VALUES ('517', 'Land_Ind_TankSmall');
102INSERT INTO `building` VALUES ('708', 'Land_Ind_TankSmall2');
103INSERT INTO `building` VALUES ('715', 'Land_Ind_Timbers');
104INSERT INTO `building` VALUES ('706', 'Land_Ind_Workshop01_01');
105INSERT INTO `building` VALUES ('313', 'Land_Ind_Workshop01_02');
106INSERT INTO `building` VALUES ('479', 'Land_Ind_Workshop01_04');
107INSERT INTO `building` VALUES ('707', 'Land_KBud');
108INSERT INTO `building` VALUES ('717', 'Land_ladder_half');
109INSERT INTO `building` VALUES ('302', 'Land_Mil_Barracks');
110INSERT INTO `building` VALUES ('301', 'Land_Mil_Barracks_i');
111INSERT INTO `building` VALUES ('312', 'Land_Mil_House');
112INSERT INTO `building` VALUES ('656', 'Land_Misc_Cargo1Ao');
113INSERT INTO `building` VALUES ('311', 'Land_Misc_Cargo1Bo');
114INSERT INTO `building` VALUES ('480', 'Land_Misc_Cargo2E');
115INSERT INTO `building` VALUES ('631', 'Land_Misc_ConcPipeline_EP1');
116INSERT INTO `building` VALUES ('346', 'Land_Misc_deerstand');
117INSERT INTO `building` VALUES ('350', 'Land_Misc_GContainer_Big');
118INSERT INTO `building` VALUES ('630', 'Land_Misc_IronPipes_EP1');
119INSERT INTO `building` VALUES ('657', 'Land_Misc_Rubble_EP1');
120INSERT INTO `building` VALUES ('716', 'Land_Misc_Scaffolding');
121INSERT INTO `building` VALUES ('633', 'Land_Panelak');
122INSERT INTO `building` VALUES ('632', 'Land_Panelak2');
123INSERT INTO `building` VALUES ('451', 'Land_radar');
124INSERT INTO `building` VALUES ('357', 'Land_ruin_01');
125INSERT INTO `building` VALUES ('359', 'Land_ruin_corner_2');
126INSERT INTO `building` VALUES ('360', 'Land_ruin_wall');
127INSERT INTO `building` VALUES ('358', 'Land_ruin_walldoor');
128INSERT INTO `building` VALUES ('307', 'Land_seno_balik');
129INSERT INTO `building` VALUES ('712', 'Land_Shed_W01');
130INSERT INTO `building` VALUES ('450', 'Land_vez');
131INSERT INTO `building` VALUES ('626', 'Land_Vysilac_FM');
132INSERT INTO `building` VALUES ('523', 'Land_wagon_tanker');
133INSERT INTO `building` VALUES ('484', 'Mass_grave');
134INSERT INTO `building` VALUES ('659', 'Mi8Wreck');
135INSERT INTO `building` VALUES ('666', 'Misc_cargo_cont_net2');
136INSERT INTO `building` VALUES ('668', 'Misc_cargo_cont_net3');
137INSERT INTO `building` VALUES ('326', 'Misc_cargo_cont_small');
138INSERT INTO `building` VALUES ('669', 'Misc_cargo_cont_small2');
139INSERT INTO `building` VALUES ('670', 'Misc_cargo_cont_tiny');
140INSERT INTO `building` VALUES ('324', 'Misc_concrete_High');
141INSERT INTO `building` VALUES ('714', 'Misc_palletsfoiled_heap');
142INSERT INTO `building` VALUES ('355', 'Notice_board');
143INSERT INTO `building` VALUES ('344', 'Paleta2');
144INSERT INTO `building` VALUES ('605', 'Park_bench2');
145INSERT INTO `building` VALUES ('340', 'PowGen_Big');
146INSERT INTO `building` VALUES ('381', 'RampConcrete');
147INSERT INTO `building` VALUES ('711', 'RoadBarrier_light');
148INSERT INTO `building` VALUES ('329', 'T72Wreck');
149INSERT INTO `building` VALUES ('476', 'T72WreckTurret');
150INSERT INTO `building` VALUES ('482', 'UAZWreck');
151INSERT INTO `building` VALUES ('522', 'UralWreck');
152INSERT INTO `building` VALUES ('703', 'USMC_WarfareBFieldhHospital');
153INSERT INTO `building` VALUES ('486', 'WarfareBCamp');
154INSERT INTO `building` VALUES ('454', 'ZavoraAnim');
155
156-- ----------------------------
157-- Table structure for `deployable`
158-- ----------------------------
159DROP TABLE IF EXISTS `deployable`;
160CREATE TABLE `deployable` (
161  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
162  `class_name` varchar(100) DEFAULT NULL,
163  PRIMARY KEY (`id`),
164  UNIQUE KEY `uq1_deployable` (`class_name`)
165) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
166
167-- ----------------------------
168-- Records of deployable
169-- ----------------------------
170INSERT INTO `deployable` VALUES ('4', 'Hedgehog_DZ');
171INSERT INTO `deployable` VALUES ('5', 'Sandbag1_DZ');
172INSERT INTO `deployable` VALUES ('1', 'TentStorage');
173INSERT INTO `deployable` VALUES ('2', 'TrapBear');
174INSERT INTO `deployable` VALUES ('3', 'Wire_cat1');
175
176-- ----------------------------
177-- Table structure for `instance`
178-- ----------------------------
179DROP TABLE IF EXISTS `instance`;
180CREATE TABLE `instance` (
181  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
182  `world_id` smallint(5) unsigned NOT NULL DEFAULT '1',
183  `inventory` varchar(2048) NOT NULL DEFAULT '[]',
184  `backpack` varchar(2048) NOT NULL DEFAULT '["DZ_Patrol_Pack_EP1",[[],[]],[[],[]]]',
185  PRIMARY KEY (`id`),
186  KEY `fk1_instance` (`world_id`),
187  CONSTRAINT `instance_ibfk_1` FOREIGN KEY (`world_id`) REFERENCES `world` (`id`)
188) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
189
190-- ----------------------------
191-- Records of instance
192-- ----------------------------
193INSERT INTO `instance` VALUES ('1', '1', '[]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]');
194
195-- ----------------------------
196-- Table structure for `instance_building`
197-- ----------------------------
198DROP TABLE IF EXISTS `instance_building`;
199CREATE TABLE `instance_building` (
200  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
201  `building_id` smallint(5) unsigned NOT NULL,
202  `instance_id` bigint(20) unsigned NOT NULL DEFAULT '1',
203  `worldspace` varchar(60) NOT NULL DEFAULT '[0,[0,0,0]]',
204  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
205  PRIMARY KEY (`id`),
206  KEY `idx1_instance_building` (`building_id`),
207  KEY `idx3_instance_building` (`instance_id`),
208  CONSTRAINT `instance_building_ibfk_1` FOREIGN KEY (`instance_id`) REFERENCES `instance` (`id`),
209  CONSTRAINT `instance_building_ibfk_2` FOREIGN KEY (`building_id`) REFERENCES `building` (`id`)
210) ENGINE=InnoDB AUTO_INCREMENT=248 DEFAULT CHARSET=utf8;
211
212-- ----------------------------
213-- Records of instance_building
214-- ----------------------------
215INSERT INTO `instance_building` VALUES ('1', '300', '1', '[20,[12121.5,12741.2,0.19783433]]', '0000-00-00 00:00:00');
216INSERT INTO `instance_building` VALUES ('2', '301', '1', '[15,[12103.1,12626.4,0.121408]]', '0000-00-00 00:00:00');
217INSERT INTO `instance_building` VALUES ('3', '302', '1', '[113,[12072.5,12757.8,0.00143433]]', '0000-00-00 00:00:00');
218INSERT INTO `instance_building` VALUES ('4', '303', '1', '[22,[12092,12760.6,0.00143433]]', '0000-00-00 00:00:00');
219INSERT INTO `instance_building` VALUES ('5', '304', '1', '[293,[12078.5,12749,0.10143433]]', '0000-00-00 00:00:00');
220INSERT INTO `instance_building` VALUES ('6', '331', '1', '[202,[12076.,12748.9,0.00143433]]', '0000-00-00 00:00:00');
221INSERT INTO `instance_building` VALUES ('7', '307', '1', '[269,[12181.4,12704.9,0.00143433]]', '0000-00-00 00:00:00');
222INSERT INTO `instance_building` VALUES ('8', '307', '1', '[255,[12197.4,12718.3,0.00144958]]', '0000-00-00 00:00:00');
223INSERT INTO `instance_building` VALUES ('9', '307', '1', '[258,[12213.6,12692.5,0.00146484]]', '0000-00-00 00:00:00');
224INSERT INTO `instance_building` VALUES ('10', '307', '1', '[257,[12227.8,12708,0.00143433]]', '0000-00-00 00:00:00');
225INSERT INTO `instance_building` VALUES ('11', '311', '1', '[199,[12140.1,12732,0.00143433]]', '0000-00-00 00:00:00');
226INSERT INTO `instance_building` VALUES ('12', '312', '1', '[199,[12163.6,12723.37,0.00141907]]', '0000-00-00 00:00:00');
227INSERT INTO `instance_building` VALUES ('13', '313', '1', '[280,[12122.8,12613.6,0.0161896]]', '0000-00-00 00:00:00');
228INSERT INTO `instance_building` VALUES ('14', '314', '1', '[20,[12115.4,12589.3,-0.1723]]', '0000-00-00 00:00:00');
229INSERT INTO `instance_building` VALUES ('15', '314', '1', '[16,[12106.1,12592.5,-0.3350]]', '0000-00-00 00:00:00');
230INSERT INTO `instance_building` VALUES ('16', '662', '1', '[18,[12085.9,12598.1,0.00119019]]', '0000-00-00 00:00:00');
231INSERT INTO `instance_building` VALUES ('17', '484', '1', '[74,[12081.6,12618.4,0.00143433]]', '0000-00-00 00:00:00');
232INSERT INTO `instance_building` VALUES ('18', '318', '1', '[101,[12092.9,12626.1,0.00140381]]', '0000-00-00 00:00:00');
233INSERT INTO `instance_building` VALUES ('19', '318', '1', '[62,[12093.4,12624.9,0.00132751]]', '0000-00-00 00:00:00');
234INSERT INTO `instance_building` VALUES ('20', '320', '1', '[175,[12094.5,12625.1,0.0014801]]', '0000-00-00 00:00:00');
235INSERT INTO `instance_building` VALUES ('21', '320', '1', '[144,[12110.9,12620.8,0.00134277]]', '0000-00-00 00:00:00');
236INSERT INTO `instance_building` VALUES ('22', '322', '1', '[30,[12102.4,12608.3,0.00138855]]', '0000-00-00 00:00:00');
237INSERT INTO `instance_building` VALUES ('23', '322', '1', '[76,[12100.7,12609.2,0.00131226]]', '0000-00-00 00:00:00');
238INSERT INTO `instance_building` VALUES ('24', '324', '1', '[321,[12115,12601.4,0.00186157]]', '0000-00-00 00:00:00');
239INSERT INTO `instance_building` VALUES ('25', '669', '1', '[72,[12100.5,12607.,0.00134277]]', '0000-00-00 00:00:00');
240INSERT INTO `instance_building` VALUES ('26', '326', '1', '[56,[12126.9,12608.9,0.00140381]]', '0000-00-00 00:00:00');
241INSERT INTO `instance_building` VALUES ('27', '666', '1', '[24,[12079.5,12636.7,0.00143433]]', '0000-00-00 00:00:00');
242INSERT INTO `instance_building` VALUES ('28', '506', '1', '[244,[12147.5,12657.6,0.00143433]]', '0000-00-00 00:00:00');
243INSERT INTO `instance_building` VALUES ('29', '329', '1', '[56,[12130.9,12709.3,0.00144958]]', '0000-00-00 00:00:00');
244INSERT INTO `instance_building` VALUES ('30', '330', '1', '[71,[12320.4,12679.6,0.00143433]]', '0000-00-00 00:00:00');
245INSERT INTO `instance_building` VALUES ('31', '331', '1', '[30,[12322.8,12678.1,0.00143433]]', '0000-00-00 00:00:00');
246INSERT INTO `instance_building` VALUES ('32', '522', '1', '[332,[12185.3,12723.5,0.0014801]]', '0000-00-00 00:00:00');
247INSERT INTO `instance_building` VALUES ('33', '333', '1', '[204,[12147,12752.5,0.00143433]]', '0000-00-00 00:00:00');
248INSERT INTO `instance_building` VALUES ('34', '333', '1', '[205,[12150.5,12750.8,0.00143433]]', '0000-00-00 00:00:00');
249INSERT INTO `instance_building` VALUES ('35', '333', '1', '[207,[12153.6,12749.2,0.00144958]]', '0000-00-00 00:00:00');
250INSERT INTO `instance_building` VALUES ('36', '333', '1', '[212,[12156.9,12747.2,0.00143433]]', '0000-00-00 00:00:00');
251INSERT INTO `instance_building` VALUES ('37', '333', '1', '[215,[12143.6,12754.4,0.00143433]]', '0000-00-00 00:00:00');
252INSERT INTO `instance_building` VALUES ('38', '333', '1', '[202,[12139.9,12756.4,0.00143433]]', '0000-00-00 00:00:00');
253INSERT INTO `instance_building` VALUES ('39', '339', '1', '[102,[12141.2,12754.5,0.00143433]]', '0000-00-00 00:00:00');
254INSERT INTO `instance_building` VALUES ('40', '340', '1', '[300,[12161.2,12743.7,0.00140381]]', '0000-00-00 00:00:00');
255INSERT INTO `instance_building` VALUES ('41', '659', '1', '[340,[12065.6,12772.7,0.00143433]]', '0000-00-00 00:00:00');
256INSERT INTO `instance_building` VALUES ('42', '482', '1', '[129,[12044,12709.6,0.00143433]]', '0000-00-00 00:00:00');
257INSERT INTO `instance_building` VALUES ('43', '343', '1', '[166,[12085.5,12706.8,0.00143433]]', '0000-00-00 00:00:00');
258INSERT INTO `instance_building` VALUES ('44', '344', '1', '[136,[12095.4,12633.9,0.0014801]]', '0000-00-00 00:00:00');
259INSERT INTO `instance_building` VALUES ('45', '345', '1', '[319,[12020,12793.2,0.00143433]]', '0000-00-00 00:00:00');
260INSERT INTO `instance_building` VALUES ('46', '346', '1', '[340,[12483.2,12822.3,0.00151062]]', '0000-00-00 00:00:00');
261INSERT INTO `instance_building` VALUES ('47', '347', '1', '[318,[12255.8,12738.3,0.00154114]]', '0000-00-00 00:00:00');
262INSERT INTO `instance_building` VALUES ('48', '350', '1', '[65,[12132.9,12755.9,0.00144958]]', '0000-00-00 00:00:00');
263INSERT INTO `instance_building` VALUES ('49', '451', '1', '[220,[6598.76,8063.7,0.00125122]]', '0000-00-00 00:00:00');
264INSERT INTO `instance_building` VALUES ('50', '626', '1', '[236,[7420.75,8119.6,0.0017395]]', '0000-00-00 00:00:00');
265INSERT INTO `instance_building` VALUES ('51', '518', '1', '[21,[6495.25,8345.39,0.178162]]', '0000-00-00 00:00:00');
266INSERT INTO `instance_building` VALUES ('52', '354', '1', '[25,[6493.16,8342.61,0.00119019]]', '0000-00-00 00:00:00');
267INSERT INTO `instance_building` VALUES ('53', '355', '1', '[337,[6496.69,8349.06,-0.102423]]', '0000-00-00 00:00:00');
268INSERT INTO `instance_building` VALUES ('54', '356', '1', '[186,[6124.9,8090.46,0.00195313]]', '0000-00-00 00:00:00');
269INSERT INTO `instance_building` VALUES ('55', '357', '1', '[248,[6119.19,8127.43,0.00167847]]', '0000-00-00 00:00:00');
270INSERT INTO `instance_building` VALUES ('56', '358', '1', '[84,[6106.73,8106.56,0.00112915]]', '0000-00-00 00:00:00');
271INSERT INTO `instance_building` VALUES ('57', '359', '1', '[284,[6140.53,8121.7,0.00164795]]', '0000-00-00 00:00:00');
272INSERT INTO `instance_building` VALUES ('58', '360', '1', '[190,[6136.17,8143.85,0.00109863]]', '0000-00-00 00:00:00');
273INSERT INTO `instance_building` VALUES ('59', '361', '1', '[162,[6196.54,7894.74,0.00195313]]', '0000-00-00 00:00:00');
274INSERT INTO `instance_building` VALUES ('60', '451', '1', '[67,[5905.86,7742.99,0.00186157]]', '0000-00-00 00:00:00');
275INSERT INTO `instance_building` VALUES ('61', '381', '1', '[69,[3591.73,8514.17,0.00146484]]', '0000-00-00 00:00:00');
276INSERT INTO `instance_building` VALUES ('62', '381', '1', '[246,[3554.21,8500.02,-0.2022583]]', '0000-00-00 00:00:00');
277INSERT INTO `instance_building` VALUES ('63', '380', '1', '[194,[3558.37,8505.83,-0.800823975]]', '0000-00-00 00:00:00');
278INSERT INTO `instance_building` VALUES ('64', '381', '1', '[236,[3577.32,8479.16,-0.10149536]]', '0000-00-00 00:00:00');
279INSERT INTO `instance_building` VALUES ('65', '381', '1', '[58,[3604.98,8498.89,-0.30170898]]', '0000-00-00 00:00:00');
280INSERT INTO `instance_building` VALUES ('66', '391', '1', '[74,[3961.95,11636.3,0.00134277]]', '0000-00-00 00:00:00');
281INSERT INTO `instance_building` VALUES ('67', '392', '1', '[244,[3937.59,11600.7,0.00149536]]', '0000-00-00 00:00:00');
282INSERT INTO `instance_building` VALUES ('68', '392', '1', '[291,[3924.65,11661.3,0.00146484]]', '0000-00-00 00:00:00');
283INSERT INTO `instance_building` VALUES ('69', '392', '1', '[274,[3920.07,11628.8,0.00149536]]', '0000-00-00 00:00:00');
284INSERT INTO `instance_building` VALUES ('70', '484', '1', '[193,[3945.06,11719.5,0.00164795]]', '0000-00-00 00:00:00');
285INSERT INTO `instance_building` VALUES ('71', '396', '1', '[88,[3946.62,11708.9,3.20128174]]', '0000-00-00 00:00:00');
286INSERT INTO `instance_building` VALUES ('72', '397', '1', '[348,[3943.33,11732.6,2.5012207]]', '0000-00-00 00:00:00');
287INSERT INTO `instance_building` VALUES ('73', '398', '1', '[115,[3932.82,11675,0.00149536]]', '0000-00-00 00:00:00');
288INSERT INTO `instance_building` VALUES ('74', '399', '1', '[115,[3930.04,11673,0.00146484]]', '0000-00-00 00:00:00');
289INSERT INTO `instance_building` VALUES ('75', '450', '1', '[22,[11909.4,12833.3,0.00141907]]', '0000-00-00 00:00:00');
290INSERT INTO `instance_building` VALUES ('76', '451', '1', '[132,[11765.7,12899,0.00152588]]', '0000-00-00 00:00:00');
291INSERT INTO `instance_building` VALUES ('77', '452', '1', '[110,[4108.64,11647.3,0.00137329]]', '0000-00-00 00:00:00');
292INSERT INTO `instance_building` VALUES ('78', '453', '1', '[330,[4116.64,11655.3,0.00143433]]', '0000-00-00 00:00:00');
293INSERT INTO `instance_building` VALUES ('79', '454', '1', '[287,[4117.33,11645.5,0.00152588]]', '0000-00-00 00:00:00');
294INSERT INTO `instance_building` VALUES ('80', '459', '1', '[105,[4115.57,11649,0.00137329]]', '0000-00-00 00:00:00');
295INSERT INTO `instance_building` VALUES ('81', '459', '1', '[105,[4116.05,11650.8,0.00134277]]', '0000-00-00 00:00:00');
296INSERT INTO `instance_building` VALUES ('82', '457', '1', '[264,[4112.32,11637.1,0.0015564]]', '0000-00-00 00:00:00');
297INSERT INTO `instance_building` VALUES ('83', '459', '1', '[106,[4113.85,11640.5,0.00134277]]', '0000-00-00 00:00:00');
298INSERT INTO `instance_building` VALUES ('84', '459', '1', '[105,[4113.01,11637.8,0.00137329]]', '0000-00-00 00:00:00');
299INSERT INTO `instance_building` VALUES ('85', '331', '1', '[168,[4107.25,11644.6,0.00134277]]', '0000-00-00 00:00:00');
300INSERT INTO `instance_building` VALUES ('86', '331', '1', '[86,[4109.35,11650.6,0.00128174]]', '0000-00-00 00:00:00');
301INSERT INTO `instance_building` VALUES ('87', '463', '1', '[89,[4111.51,11616.4,0.00149536]]', '0000-00-00 00:00:00');
302INSERT INTO `instance_building` VALUES ('88', '464', '1', '[331,[4101.51,11596.2,0.0012207]]', '0000-00-00 00:00:00');
303INSERT INTO `instance_building` VALUES ('89', '465', '1', '[127,[4109.14,11602.6,0.0015564]]', '0000-00-00 00:00:00');
304INSERT INTO `instance_building` VALUES ('90', '466', '1', '[154,[3992.83,11582.2,0.00161743]]', '0000-00-00 00:00:00');
305INSERT INTO `instance_building` VALUES ('91', '468', '1', '[218,[2804.9,9825.02,0.19149536]]', '0000-00-00 00:00:00');
306INSERT INTO `instance_building` VALUES ('92', '521', '1', '[301,[2827.31,9827.04,0.00143433]]', '0000-00-00 00:00:00');
307INSERT INTO `instance_building` VALUES ('93', '522', '1', '[232,[2789.44,9852.91,0.00143433]]', '0000-00-00 00:00:00');
308INSERT INTO `instance_building` VALUES ('96', '473', '1', '[53,[2820.61,9838.01,0.00140381]]', '0000-00-00 00:00:00');
309INSERT INTO `instance_building` VALUES ('97', '474', '1', '[328,[2867.94,9873.62,-0.527863]]', '0000-00-00 00:00:00');
310INSERT INTO `instance_building` VALUES ('98', '330', '1', '[45,[2973.33,9858.91,0.003131226]]', '0000-00-00 00:00:00');
311INSERT INTO `instance_building` VALUES ('99', '476', '1', '[160,[2984.26,9850.58,0.00186157]]', '0000-00-00 00:00:00');
312INSERT INTO `instance_building` VALUES ('100', '329', '1', '[67,[2965.26,9832.46,0.0012207]]', '0000-00-00 00:00:00');
313INSERT INTO `instance_building` VALUES ('101', '343', '1', '[6,[2921.16,9854.86,0.00109863]]', '0000-00-00 00:00:00');
314INSERT INTO `instance_building` VALUES ('102', '479', '1', '[328,[2878.14,9828.97,0.00146484]]', '0000-00-00 00:00:00');
315INSERT INTO `instance_building` VALUES ('103', '480', '1', '[134,[2891.02,9845.71,0.00146484]]', '0000-00-00 00:00:00');
316INSERT INTO `instance_building` VALUES ('104', '311', '1', '[179,[2886.77,9849.82,0.00140381]]', '0000-00-00 00:00:00');
317INSERT INTO `instance_building` VALUES ('105', '482', '1', '[17,[2867.99,9858.63,0.00143433]]', '0000-00-00 00:00:00');
318INSERT INTO `instance_building` VALUES ('106', '483', '1', '[138,[2853.72,9891.61,0.00143433]]', '0000-00-00 00:00:00');
319INSERT INTO `instance_building` VALUES ('107', '484', '1', '[169,[2836.36,9847.13,-0.14946484]]', '0000-00-00 00:00:00');
320INSERT INTO `instance_building` VALUES ('109', '486', '1', '[223,[2899.94,9939.66,-0.23167847]]', '0000-00-00 00:00:00');
321INSERT INTO `instance_building` VALUES ('114', '506', '1', '[164,[6902.74,2582.08,0.00143862]]', '0000-00-00 00:00:00');
322INSERT INTO `instance_building` VALUES ('115', '522', '1', '[313,[7842.48,3177.08,0.00147247]]', '0000-00-00 00:00:00');
323INSERT INTO `instance_building` VALUES ('116', '510', '1', '[174,[7842.28,3168.68,0.00140333]]', '0000-00-00 00:00:00');
324INSERT INTO `instance_building` VALUES ('117', '511', '1', '[156,[7848.24,3165.46,0.00140476]]', '0000-00-00 00:00:00');
325INSERT INTO `instance_building` VALUES ('118', '644', '1', '[330,[7847.24,3170.79,0.00143814]]', '0000-00-00 00:00:00');
326INSERT INTO `instance_building` VALUES ('119', '513', '1', '[122,[7851.13,3168.08,0.00145721]]', '0000-00-00 00:00:00');
327INSERT INTO `instance_building` VALUES ('120', '517', '1', '[248,[1902.64,7487.58,-0.30026967]]', '0000-00-00 00:00:00');
328INSERT INTO `instance_building` VALUES ('121', '518', '1', '[97,[12841.6,9033.16,0.00142193]]', '0000-00-00 00:00:00');
329INSERT INTO `instance_building` VALUES ('122', '640', '1', '[68,[12827.3,9057.37,0.001441]]', '0000-00-00 00:00:00');
330INSERT INTO `instance_building` VALUES ('123', '521', '1', '[102,[12808.9,9020.73,0.00143147]]', '0000-00-00 00:00:00');
331INSERT INTO `instance_building` VALUES ('124', '522', '1', '[344,[12803.1,9079.62,0.00146294]]', '0000-00-00 00:00:00');
332INSERT INTO `instance_building` VALUES ('125', '523', '1', '[179,[12771.5,9005.56,0.573406]]', '0000-00-00 00:00:00');
333INSERT INTO `instance_building` VALUES ('126', '524', '1', '[180,[12726.3,9026.86,0.00143862]]', '0000-00-00 00:00:00');
334INSERT INTO `instance_building` VALUES ('129', '570', '1', '[90,[12711,9003.35,0.00144148]]', '0000-00-00 00:00:00');
335INSERT INTO `instance_building` VALUES ('130', '570', '1', '[84,[12707.7,9006.21,0.001441]]', '0000-00-00 00:00:00');
336INSERT INTO `instance_building` VALUES ('131', '570', '1', '[91,[12708,9003.28,0.001441]]', '0000-00-00 00:00:00');
337INSERT INTO `instance_building` VALUES ('132', '530', '1', '[96,[12685.7,8995.55,0.00144243]]', '0000-00-00 00:00:00');
338INSERT INTO `instance_building` VALUES ('133', '570', '1', '[85,[12710.8,9006.22,0.001441]]', '0000-00-00 00:00:00');
339INSERT INTO `instance_building` VALUES ('135', '628', '1', '[276,[2899.84,9878.54,0.00100381]]', '0000-00-00 00:00:00');
340INSERT INTO `instance_building` VALUES ('136', '602', '1', '[223,[2901.61,9886.56,-0.10017395]]', '0000-00-00 00:00:00');
341INSERT INTO `instance_building` VALUES ('137', '603', '1', '[142,[2825,9882.69,0.00146484]]', '0000-00-00 00:00:00');
342INSERT INTO `instance_building` VALUES ('138', '603', '1', '[142,[2832.92,9888.82,0.00143433]]', '0000-00-00 00:00:00');
343INSERT INTO `instance_building` VALUES ('139', '605', '1', '[272,[3012.41,9759.15,0.00143433]]', '0000-00-00 00:00:00');
344INSERT INTO `instance_building` VALUES ('140', '605', '1', '[272,[3012.57,9762.38,0.00137329]]', '0000-00-00 00:00:00');
345INSERT INTO `instance_building` VALUES ('141', '626', '1', '[254,[3086.91,9892.64,0.00137329]]', '0000-00-00 00:00:00');
346INSERT INTO `instance_building` VALUES ('142', '627', '1', '[153,[2898.17,9897.54,-0.30186157]]', '0000-00-00 00:00:00');
347INSERT INTO `instance_building` VALUES ('143', '628', '1', '[176,[2897.96,9892.3,20.20164795]]', '0000-00-00 00:00:00');
348INSERT INTO `instance_building` VALUES ('144', '630', '1', '[188,[2883.18,9901.56,0.00170898]]', '0000-00-00 00:00:00');
349INSERT INTO `instance_building` VALUES ('145', '630', '1', '[109,[2896.17,9896.39,0.00161743]]', '0000-00-00 00:00:00');
350INSERT INTO `instance_building` VALUES ('146', '631', '1', '[201,[2890.93,9894.34,0.00177002]]', '0000-00-00 00:00:00');
351INSERT INTO `instance_building` VALUES ('147', '632', '1', '[307,[2969.07,9759.77,0.00134277]]', '0000-00-00 00:00:00');
352INSERT INTO `instance_building` VALUES ('148', '633', '1', '[35,[2946.45,9786.25,0.00143433]]', '0000-00-00 00:00:00');
353INSERT INTO `instance_building` VALUES ('149', '339', '1', '[154,[2955.28,9783.46,0.00128174]]', '0000-00-00 00:00:00');
354INSERT INTO `instance_building` VALUES ('150', '339', '1', '[339,[2950.9,9776.22,0.0012207]]', '0000-00-00 00:00:00');
355INSERT INTO `instance_building` VALUES ('151', '339', '1', '[251,[2977.12,9768.1,0.00143433]]', '0000-00-00 00:00:00');
356INSERT INTO `instance_building` VALUES ('152', '339', '1', '[92,[2968.6,9749.71,0.00143433]]', '0000-00-00 00:00:00');
357INSERT INTO `instance_building` VALUES ('153', '350', '1', '[262,[2908.36,9819.89,0.00143433]]', '0000-00-00 00:00:00');
358INSERT INTO `instance_building` VALUES ('154', '396', '1', '[176,[2898.96,9892.3,13.20164795]]', '0000-00-00 00:00:00');
359INSERT INTO `instance_building` VALUES ('155', '640', '1', '[94,[2822.63,9812.52,0.00149536]]', '0000-00-00 00:00:00');
360INSERT INTO `instance_building` VALUES ('156', '641', '1', '[319,[2820.52,9889,0.00143433]]', '0000-00-00 00:00:00');
361INSERT INTO `instance_building` VALUES ('157', '641', '1', '[320,[2830.64,9897.59,0.00143433]]', '0000-00-00 00:00:00');
362INSERT INTO `instance_building` VALUES ('158', '643', '1', '[145,[2844.78,9864.76,0.00143433]]', '0000-00-00 00:00:00');
363INSERT INTO `instance_building` VALUES ('159', '644', '1', '[144,[2835.75,9877.07,0.00140381]]', '0000-00-00 00:00:00');
364INSERT INTO `instance_building` VALUES ('160', '483', '1', '[44,[2972.0,9857.39,0.0012207]]', '0000-00-00 00:00:00');
365INSERT INTO `instance_building` VALUES ('161', '396', '1', '[317,[2832.15,9804.86,0.2949536]]', '0000-00-00 00:00:00');
366INSERT INTO `instance_building` VALUES ('162', '648', '1', '[267,[2807.86,9846.85,0.00143433]]', '0000-00-00 00:00:00');
367INSERT INTO `instance_building` VALUES ('163', '649', '1', '[311,[2809.6,9838.06,0.00143433]]', '0000-00-00 00:00:00');
368INSERT INTO `instance_building` VALUES ('164', '650', '1', '[267,[2799.67,9844,0.00143433]]', '0000-00-00 00:00:00');
369INSERT INTO `instance_building` VALUES ('165', '650', '1', '[211,[2798.36,9846.1,0.00143433]]', '0000-00-00 00:00:00');
370INSERT INTO `instance_building` VALUES ('166', '650', '1', '[203,[2798.28,9849.61,0.00143433]]', '0000-00-00 00:00:00');
371INSERT INTO `instance_building` VALUES ('167', '650', '1', '[189,[2796.96,9852.32,0.00143433]]', '0000-00-00 00:00:00');
372INSERT INTO `instance_building` VALUES ('168', '331', '1', '[318,[2814.28,9830.35,0.00143433]]', '0000-00-00 00:00:00');
373INSERT INTO `instance_building` VALUES ('169', '331', '1', '[241,[2814.42,9834.12,0.00143433]]', '0000-00-00 00:00:00');
374INSERT INTO `instance_building` VALUES ('170', '656', '1', '[180,[2820.46,9846.32,0.00143433]]', '0000-00-00 00:00:00');
375INSERT INTO `instance_building` VALUES ('171', '657', '1', '[22,[2812.66,9806.2,0.00128174]]', '0000-00-00 00:00:00');
376INSERT INTO `instance_building` VALUES ('172', '657', '1', '[137,[2814.71,9806.41,0.00066]]', '0000-00-00 00:00:00');
377INSERT INTO `instance_building` VALUES ('173', '659', '1', '[115,[2792.59,9824.87,0.00161743]]', '0000-00-00 00:00:00');
378INSERT INTO `instance_building` VALUES ('174', '483', '1', '[37,[2792.72,9830.13,0.00146484]]', '0000-00-00 00:00:00');
379INSERT INTO `instance_building` VALUES ('175', '661', '1', '[15,[2794.28,9824.25,0.00131226]]', '0000-00-00 00:00:00');
380INSERT INTO `instance_building` VALUES ('176', '662', '1', '[35,[2809.76,9841.34,0.115485]]', '0000-00-00 00:00:00');
381INSERT INTO `instance_building` VALUES ('177', '643', '1', '[208,[2800.96,9859.32,0.125763]]', '0000-00-00 00:00:00');
382INSERT INTO `instance_building` VALUES ('178', '643', '1', '[207,[2810.04,9854.95,0.00143433]]', '0000-00-00 00:00:00');
383INSERT INTO `instance_building` VALUES ('179', '650', '1', '[252,[2808.14,9861.54,0.00143433]]', '0000-00-00 00:00:00');
384INSERT INTO `instance_building` VALUES ('180', '666', '1', '[10,[2843.26,9858.76,0.00143433]]', '0000-00-00 00:00:00');
385INSERT INTO `instance_building` VALUES ('182', '668', '1', '[97,[2851.38,9882.83,0.00143433]]', '0000-00-00 00:00:00');
386INSERT INTO `instance_building` VALUES ('183', '669', '1', '[228,[2854.3,9881.26,0.00140381]]', '0000-00-00 00:00:00');
387INSERT INTO `instance_building` VALUES ('184', '670', '1', '[81,[2852.01,9879.63,0.00143433]]', '0000-00-00 00:00:00');
388INSERT INTO `instance_building` VALUES ('185', '661', '1', '[33,[2898.31,9891.68,0.00109863]]', '0000-00-00 00:00:00');
389INSERT INTO `instance_building` VALUES ('186', '672', '1', '[270,[3013.97,9761.09,0.00137329]]', '0000-00-00 00:00:00');
390INSERT INTO `instance_building` VALUES ('187', '701', '1', '[152,[4125.65,10847.7,0.00143433]]', '0000-00-00 00:00:00');
391INSERT INTO `instance_building` VALUES ('188', '346', '1', '[99,[2608.78,5357.92,0.00164795]]', '0000-00-00 00:00:00');
392INSERT INTO `instance_building` VALUES ('189', '346', '1', '[160,[2347.39,5485.03,0.00205994]]', '0000-00-00 00:00:00');
393INSERT INTO `instance_building` VALUES ('190', '346', '1', '[268,[2861.09,5040.43,0.00158691]]', '0000-00-00 00:00:00');
394INSERT INTO `instance_building` VALUES ('191', '633', '1', '[146,[2485.12,5087.96,0.00143433]]', '0000-00-00 00:00:00');
395INSERT INTO `instance_building` VALUES ('192', '343', '1', '[112,[1125.95,2144.5,0.00158262]]', '0000-00-00 00:00:00');
396INSERT INTO `instance_building` VALUES ('193', '661', '1', '[60,[2900.87,9893.1,0.00125122]]', '0000-00-00 00:00:00');
397INSERT INTO `instance_building` VALUES ('194', '633', '1', '[143,[2500.13,5098.66,0.00143433]]', '0000-00-00 00:00:00');
398INSERT INTO `instance_building` VALUES ('195', '313', '1', '[56,[2497.21,5049.75,0.00135803]]', '0000-00-00 00:00:00');
399INSERT INTO `instance_building` VALUES ('196', '702', '1', '[202,[4720.65,2432.1,0.00149155]]', '0000-00-00 00:00:00');
400INSERT INTO `instance_building` VALUES ('197', '702', '1', '[202,[4753,2419.1,0.00143909]]', '0000-00-00 00:00:00');
401INSERT INTO `instance_building` VALUES ('198', '703', '1', '[109,[4741.31,2427.94,-0.00143909]]', '0000-00-00 00:00:00');
402INSERT INTO `instance_building` VALUES ('199', '704', '1', '[176,[1991.22,2270.95,-.47303]]', '0000-00-00 00:00:00');
403INSERT INTO `instance_building` VALUES ('200', '705', '1', '[314,[1995.29,2269.68,-1.00123405]]', '0000-00-00 00:00:00');
404INSERT INTO `instance_building` VALUES ('201', '346', '1', '[164,[1959.26,2319.47,0.0019207]]', '0000-00-00 00:00:00');
405INSERT INTO `instance_building` VALUES ('202', '300', '1', '[164,[1868.28,2174.06,0.00147867]]', '0000-00-00 00:00:00');
406INSERT INTO `instance_building` VALUES ('203', '522', '1', '[118,[1836.93,2162.89,0.00143719]]', '0000-00-00 00:00:00');
407INSERT INTO `instance_building` VALUES ('204', '482', '1', '[208,[1838.77,2181.1,0.00144911]]', '0000-00-00 00:00:00');
408INSERT INTO `instance_building` VALUES ('205', '640', '1', '[213,[1897.77,2194.47,0.00143862]]', '0000-00-00 00:00:00');
409INSERT INTO `instance_building` VALUES ('206', '330', '1', '[31,[1872.85,2206.48,0.00942479]]', '0000-00-00 00:00:00');
410INSERT INTO `instance_building` VALUES ('207', '347', '1', '[134,[1880.03,2191.53,0.0014205]]', '0000-00-00 00:00:00');
411INSERT INTO `instance_building` VALUES ('208', '484', '1', '[77,[1846.99,2205.92,0.00143576]]', '0000-00-00 00:00:00');
412INSERT INTO `instance_building` VALUES ('209', '479', '1', '[253,[1908.34,2166.82,0.00143862]]', '0000-00-00 00:00:00');
413INSERT INTO `instance_building` VALUES ('210', '706', '1', '[164,[8852.34,2893.55,0.150039]]', '0000-00-00 00:00:00');
414INSERT INTO `instance_building` VALUES ('211', '705', '1', '[138,[8851.92,2896.45,-1.656112]]', '0000-00-00 00:00:00');
415INSERT INTO `instance_building` VALUES ('212', '672', '1', '[210,[8855.67,2891.85,-0.07175476]]', '0000-00-00 00:00:00');
416INSERT INTO `instance_building` VALUES ('213', '707', '1', '[234,[8851.24,2884.89,-0.300717163]]', '0000-00-00 00:00:00');
417INSERT INTO `instance_building` VALUES ('214', '605', '1', '[87,[8850.37,2887.71,-0.10138855]]', '0000-00-00 00:00:00');
418INSERT INTO `instance_building` VALUES ('215', '709', '1', '[57,[13116.3,3885.02,0.326489]]', '0000-00-00 00:00:00');
419INSERT INTO `instance_building` VALUES ('216', '710', '1', '[327,[13113.9,3873.99,0.00146389]]', '0000-00-00 00:00:00');
420INSERT INTO `instance_building` VALUES ('217', '710', '1', '[147,[13119,3898.73,0.00143862]]', '0000-00-00 00:00:00');
421INSERT INTO `instance_building` VALUES ('218', '708', '1', '[147,[13121.6,3877.26,0.00142717]]', '0000-00-00 00:00:00');
422INSERT INTO `instance_building` VALUES ('219', '711', '1', '[268,[13098.8,3867.41,0.00142241]]', '0000-00-00 00:00:00');
423INSERT INTO `instance_building` VALUES ('220', '711', '1', '[225,[13101.8,3874.74,0.00141716]]', '0000-00-00 00:00:00');
424INSERT INTO `instance_building` VALUES ('221', '706', '1', '[239,[13102.7,3907.35,0.17441]]', '0000-00-00 00:00:00');
425INSERT INTO `instance_building` VALUES ('222', '712', '1', '[28,[13350.1,12118.6,0.00191498]]', '0000-00-00 00:00:00');
426INSERT INTO `instance_building` VALUES ('223', '706', '1', '[141,[12747.7,12290,0.002876]]', '0000-00-00 00:00:00');
427INSERT INTO `instance_building` VALUES ('224', '657', '1', '[316,[12106.6,12734.6,0.00143433]]', '0000-00-00 00:00:00');
428INSERT INTO `instance_building` VALUES ('225', '657', '1', '[158,[12096.9,12676.6,0.00149536]]', '0000-00-00 00:00:00');
429INSERT INTO `instance_building` VALUES ('226', '713', '1', '[343,[12191.9,12632.8,0.00143433]]', '0000-00-00 00:00:00');
430INSERT INTO `instance_building` VALUES ('227', '318', '1', '[293,[12187.8,12623.1,0.00140381]]', '0000-00-00 00:00:00');
431INSERT INTO `instance_building` VALUES ('228', '318', '1', '[268,[12187.5,12621,0.007658]]', '0000-00-00 00:00:00');
432INSERT INTO `instance_building` VALUES ('229', '318', '1', '[11,[12198.7,12626.4,0.00143433]]', '0000-00-00 00:00:00');
433INSERT INTO `instance_building` VALUES ('230', '318', '1', '[312,[12204.6,12621.8,0.00143433]]', '0000-00-00 00:00:00');
434INSERT INTO `instance_building` VALUES ('231', '666', '1', '[253,[12204.8,12623.9,0.00143433]]', '0000-00-00 00:00:00');
435INSERT INTO `instance_building` VALUES ('232', '307', '1', '[262,[12228,12658.9,0.00143433]]', '0000-00-00 00:00:00');
436INSERT INTO `instance_building` VALUES ('233', '307', '1', '[262,[12255.8,12639,0.00143433]]', '0000-00-00 00:00:00');
437INSERT INTO `instance_building` VALUES ('234', '307', '1', '[265,[12274.9,12685.8,0.00141907]]', '0000-00-00 00:00:00');
438INSERT INTO `instance_building` VALUES ('235', '307', '1', '[259,[12269.6,12652.7,0.00143433]]', '0000-00-00 00:00:00');
439INSERT INTO `instance_building` VALUES ('236', '307', '1', '[253,[12246.3,12684.1,0.00140381]]', '0000-00-00 00:00:00');
440INSERT INTO `instance_building` VALUES ('237', '307', '1', '[252,[12262.8,12708.6,0.00143433]]', '0000-00-00 00:00:00');
441INSERT INTO `instance_building` VALUES ('238', '307', '1', '[266,[12189.9,12655.6,0.00143433]]', '0000-00-00 00:00:00');
442INSERT INTO `instance_building` VALUES ('239', '307', '1', '[268,[12165.5,12671,0.00143433]]', '0000-00-00 00:00:00');
443INSERT INTO `instance_building` VALUES ('240', '324', '1', '[46,[12150.3,12695.5,0.00143433]]', '0000-00-00 00:00:00');
444INSERT INTO `instance_building` VALUES ('241', '714', '1', '[166,[12149.6,12701.7,0.00146484]]', '0000-00-00 00:00:00');
445INSERT INTO `instance_building` VALUES ('242', '628', '1', '[169,[12146.6,12698.2,0.00144958]]', '0000-00-00 00:00:00');
446INSERT INTO `instance_building` VALUES ('243', '715', '1', '[136,[12148.4,12748.6,0.0014801]]', '0000-00-00 00:00:00');
447INSERT INTO `instance_building` VALUES ('244', '716', '1', '[24,[12178.2,12719.9,0.00143433]]', '0000-00-00 00:00:00');
448INSERT INTO `instance_building` VALUES ('245', '717', '1', '[288,[12179.8,12723.5,5.40146484]]', '0000-00-00 00:00:00');
449INSERT INTO `instance_building` VALUES ('246', '718', '1', '[238,[3582.14,8482.19,.00151]]', '0000-00-00 00:00:00');
450INSERT INTO `instance_building` VALUES ('247', '381', '1', '[245,[3581.34,8486.16,0.0024194]]', '0000-00-00 00:00:00');
451
452-- ----------------------------
453-- Table structure for `instance_deployable`
454-- ----------------------------
455DROP TABLE IF EXISTS `instance_deployable`;
456CREATE TABLE `instance_deployable` (
457  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
458  `unique_id` varchar(60) NOT NULL,
459  `deployable_id` smallint(5) unsigned NOT NULL,
460  `owner_id` int(10) unsigned NOT NULL,
461  `instance_id` bigint(20) unsigned NOT NULL DEFAULT '1',
462  `worldspace` varchar(60) NOT NULL DEFAULT '[0,[0,0,0]]',
463  `inventory` varchar(2048) NOT NULL DEFAULT '[]',
464  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
465  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
466  PRIMARY KEY (`id`),
467  KEY `idx1_instance_deployable` (`deployable_id`),
468  KEY `idx2_instance_deployable` (`owner_id`),
469  KEY `idx3_instance_deployable` (`instance_id`),
470  CONSTRAINT `instance_deployable_ibfk_1` FOREIGN KEY (`instance_id`) REFERENCES `instance` (`id`),
471  CONSTRAINT `instance_deployable_ibfk_2` FOREIGN KEY (`owner_id`) REFERENCES `survivor` (`id`),
472  CONSTRAINT `instance_deployable_ibfk_3` FOREIGN KEY (`deployable_id`) REFERENCES `deployable` (`id`)
473) ENGINE=InnoDB DEFAULT CHARSET=utf8;
474
475-- ----------------------------
476-- Records of instance_deployable
477-- ----------------------------
478
479-- ----------------------------
480-- Table structure for `instance_vehicle`
481-- ----------------------------
482DROP TABLE IF EXISTS `instance_vehicle`;
483CREATE TABLE `instance_vehicle` (
484  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
485  `world_vehicle_id` bigint(20) unsigned NOT NULL,
486  `instance_id` bigint(20) unsigned NOT NULL DEFAULT '1',
487  `worldspace` varchar(60) NOT NULL DEFAULT '[0,[0,0,0]]',
488  `inventory` varchar(2048) NOT NULL DEFAULT '[]',
489  `parts` varchar(1024) NOT NULL DEFAULT '[]',
490  `fuel` double NOT NULL DEFAULT '0',
491  `damage` double NOT NULL DEFAULT '0',
492  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
493  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
494  PRIMARY KEY (`id`),
495  KEY `idx3_instance_vehicle` (`instance_id`),
496  KEY `fk3_instance_vehicle` (`world_vehicle_id`),
497  CONSTRAINT `fk3_instance_vehicle` FOREIGN KEY (`world_vehicle_id`) REFERENCES `world_vehicle` (`id`),
498  CONSTRAINT `instance_vehicle_ibfk_1` FOREIGN KEY (`instance_id`) REFERENCES `instance` (`id`)
499) ENGINE=InnoDB AUTO_INCREMENT=1417 DEFAULT CHARSET=utf8;
500
501-- ----------------------------
502-- Records of instance_vehicle
503-- ----------------------------
504INSERT INTO `instance_vehicle` VALUES ('1183', '17', '1', '[112,[4751.68,2526.37,0.00146675]]', '[]', '[]', '0.47', '0.689', '2012-11-01 13:29:45', '2012-11-01 13:29:45');
505INSERT INTO `instance_vehicle` VALUES ('1184', '155', '1', '[27.56838,[9374.1426,8817.5078,-6.1035156e-005]]', '[]', '[[\"wheel_2_1_steering\",1]]', '0.55', '0.3', '2012-11-01 13:29:45', '2012-11-01 13:29:45');
506INSERT INTO `instance_vehicle` VALUES ('1185', '158', '1', '[150,[4493.17,10807.2,0.00143433]]', '[]', '[[\"karoserie\",1]]', '0.404', '0.7', '2012-11-01 13:29:45', '2012-11-01 13:29:45');
507INSERT INTO `instance_vehicle` VALUES ('1186', '217', '1', '[261,[12174.6,9751.76,0.00143909]]', '[]', '[[\"palivo\",1],[\"wheel_2_1_steering\",1]]', '0.2', '0.465', '2012-11-01 13:29:45', '2012-11-01 13:29:45');
508INSERT INTO `instance_vehicle` VALUES ('1187', '126', '1', '[1943.09,7358.95,0.00158691]]', '[]', '[[\"karoserie\",1]]', '0.2', '0.3', '2012-11-01 13:29:45', '2012-11-01 13:29:45');
509INSERT INTO `instance_vehicle` VALUES ('1188', '4', '1', '[42,[1850.3,2178.1,0.2152]]', '[]', '[]', '0.55', '0.464', '2012-11-01 13:29:45', '2012-11-01 13:29:45');
510INSERT INTO `instance_vehicle` VALUES ('1189', '16', '1', '[261,[4608.12,2744.73,0.00145626]]', '[]', '[[\"motor\",1]]', '0.372', '0.7', '2012-11-01 13:29:45', '2012-11-01 13:29:45');
511INSERT INTO `instance_vehicle` VALUES ('1190', '19', '1', '[308,[5147.27,2327.17,0.00143909]]', '[]', '[[\"wheel_2_1_steering\",1]]', '0.55', '0.7', '2012-11-01 13:29:45', '2012-11-01 13:29:45');
512INSERT INTO `instance_vehicle` VALUES ('1191', '48', '1', '[196,[11468.4,11386.9,0.00158691]]', '[]', '[[\"wheel_2_1_steering\",1]]', '0.55', '0.689', '2012-11-01 13:29:45', '2012-11-01 13:29:45');
513INSERT INTO `instance_vehicle` VALUES ('1192', '49', '1', '[120,[11461.7,11386.1,0.0015564]]', '[]', '[[\"motor\",1],[\"wheel_2_1_steering\",1]]', '0.2', '0.526', '2012-11-01 13:29:45', '2012-11-01 13:29:45');
514INSERT INTO `instance_vehicle` VALUES ('1193', '50', '1', '[173,[11456.9,11397.8,0.0015564]]', '[]', '[[\"motor\",1]]', '0.462', '0.693', '2012-11-01 13:29:45', '2012-11-01 13:29:45');
515INSERT INTO `instance_vehicle` VALUES ('1194', '82', '1', '[349,[3487.4,8379.37,0.00137329]]', '[]', '[]', '0.367', '0.3', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
516INSERT INTO `instance_vehicle` VALUES ('1195', '98', '1', '[30,[3018.82,11807.1,0.0015564]]', '[]', '[[\"wheel_2_1_steering\",1]]', '0.363', '0.3', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
517INSERT INTO `instance_vehicle` VALUES ('1196', '101', '1', '[155,[4071.52,11677.1,0.00167847]]', '[]', '[]', '0.55', '0.3', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
518INSERT INTO `instance_vehicle` VALUES ('1197', '102', '1', '[78,[4038.13,11670.9,0.00140381]]', '[]', '[]', '0.2', '0.372', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
519INSERT INTO `instance_vehicle` VALUES ('1198', '111', '1', '[261,[2953.76,9903.49,0.00146484]]', '[]', '[[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]', '0.288', '0.7', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
520INSERT INTO `instance_vehicle` VALUES ('1199', '138', '1', '[173,[12170,3519.73,0.00140619]]', '[]', '[]', '0.55', '0.7', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
521INSERT INTO `instance_vehicle` VALUES ('1200', '146', '1', '[225.06236,[10415.568,9855.6143,-9.9182129]]', '[]', '[]', '0.55', '0.3', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
522INSERT INTO `instance_vehicle` VALUES ('1201', '147', '1', '[-113.11581,[8557.8154,11957.857,7.6293945]]', '[]', '[]', '0.217', '0.394', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
523INSERT INTO `instance_vehicle` VALUES ('1202', '149', '1', '[-44.028866,[8524.8652,6625.3853,-0.056130722]]', '[]', '[[\"wheel_2_1_steering\",1],[\"wheel_2_2_steering\",1]]', '0.293', '0.571', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
524INSERT INTO `instance_vehicle` VALUES ('1203', '152', '1', '[536.30884,[5921.0962,4696.5688,-6.1035156e-005]', '[]', '[[\"wheel_2_2_steering\",1]]', '0.55', '0.3', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
525INSERT INTO `instance_vehicle` VALUES ('1204', '170', '1', '[98,[3683.76,6000.34,0.00143433]]', '[]', '[]', '0.2', '0.3', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
526INSERT INTO `instance_vehicle` VALUES ('1205', '193', '1', '[110,[8849.62,2859.79,0.00115967]]', '[]', '[[\"karoserie\",1]]', '0.361', '0.3', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
527INSERT INTO `instance_vehicle` VALUES ('1206', '194', '1', '[227,[8857.99,2865.04,0.00102234]]', '[]', '[[\"wheel_1_1_steering\",1]]', '0.399', '0.637', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
528INSERT INTO `instance_vehicle` VALUES ('1207', '195', '1', '[45,[8856.46,2889.11,0.00117493]]', '[]', '[[\"karoserie\",1]]', '0.425', '0.7', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
529INSERT INTO `instance_vehicle` VALUES ('1208', '196', '1', '[111,[8879.75,2854.01,0.00172424]]', '[]', '[]', '0.55', '0.7', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
530INSERT INTO `instance_vehicle` VALUES ('1209', '222', '1', '[223,[13353,12090,0.00131226]]', '[]', '[[\"palivo\",1]]', '0.427', '0.7', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
531INSERT INTO `instance_vehicle` VALUES ('1210', '223', '1', '[154,[13344.3,12089.5,0.00163269]]', '[]', '[[\"wheel_1_2_steering\",1]]', '0.364', '0.3', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
532INSERT INTO `instance_vehicle` VALUES ('1211', '240', '1', '[210,[6557.32,4449.87,0.00177002]]', '[]', '[[\"wheel_1_2_steering\",1]]', '0.286', '0.486', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
533INSERT INTO `instance_vehicle` VALUES ('1212', '66', '1', '[141,[6037.38,7792.28,0.00143433]]', '[]', '[[\"palivo\",1]]', '0.55', '0.3', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
534INSERT INTO `instance_vehicle` VALUES ('1213', '145', '1', '[181.03763,[10202.597,9850.127,0.00068664551]]', '[]', '[[\"palivo\",1],[\"wheel_2_2_steering\",1]]', '0.55', '0.3', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
535INSERT INTO `instance_vehicle` VALUES ('1214', '153', '1', '[176.27989,[5926.9404, 4696.8701]', '[]', '[]', '0.55', '0.7', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
536INSERT INTO `instance_vehicle` VALUES ('1215', '5', '1', '[159,[1865.14,2147.92,0.00143862]]', '[]', '[[\"wheel_1_1_steering\",1]]', '0.322', '0.346', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
537INSERT INTO `instance_vehicle` VALUES ('1216', '177', '1', '[333,[7428.6,5152.33,0.00137329]]', '[]', '[[\"karoserie\",1],[\"wheel_1_2_steering\",1]]', '0.204', '0.7', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
538INSERT INTO `instance_vehicle` VALUES ('1217', '212', '1', '[264,[11961.7,9139.93,0.00143814]]', '[]', '[[\"wheel_1_1_steering\",1]]', '0.55', '0.7', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
539INSERT INTO `instance_vehicle` VALUES ('1218', '61', '1', '[218,[6259.18,7809.74,0.00164795]]', '[]', '[[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]', '0.522', '0.3', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
540INSERT INTO `instance_vehicle` VALUES ('1219', '219', '1', '[223,[12361.1,10818.5,0.00114441]]', '[]', '[]', '0.55', '0.3', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
541INSERT INTO `instance_vehicle` VALUES ('1220', '58', '1', '[39,[6343.84,7770.92,0.00140381]]', '[]', '[]', '0.2', '0.7', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
542INSERT INTO `instance_vehicle` VALUES ('1221', '83', '1', '[245,[3753.24,8689.69,0.00143433]]', '[]', '[[\"motor\",1],[\"wheel_1_2_steering\",1]]', '0.2', '0.7', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
543INSERT INTO `instance_vehicle` VALUES ('1222', '120', '1', '[43,[6860.78,2597.28,0.00146008]]', '[]', '[]', '0.297', '0.3', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
544INSERT INTO `instance_vehicle` VALUES ('1223', '207', '1', '[26,[13109.1,7128.65,1.21738]]', '[]', '[]', '0.2', '0.7', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
545INSERT INTO `instance_vehicle` VALUES ('1224', '234', '1', '[293,[10654.5,8101.59,0.00144958]]', '[]', '[]', '0.245', '0.436', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
546INSERT INTO `instance_vehicle` VALUES ('1225', '33', '1', '[43,[6529.32,2289.04,0.00143862]]', '[]', '[]', '0.55', '0.442', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
547INSERT INTO `instance_vehicle` VALUES ('1226', '44', '1', '[345,[6597.54,2921.26,0.00143957]]', '[]', '[[\"motor\",1]]', '0.55', '0.3', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
548INSERT INTO `instance_vehicle` VALUES ('1227', '209', '1', '[236,[12026.6,9169.05,0.00144196]]', '[]', '[]', '0.55', '0.3', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
549INSERT INTO `instance_vehicle` VALUES ('1228', '53', '1', '[105,[12139.6,12607.6,0.00138855]]', '[]', '[[\"wheel_1_2_steering\",1]]', '0.55', '0.3', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
550INSERT INTO `instance_vehicle` VALUES ('1229', '76', '1', '[293,[3789.45,8961.33,0.00146484]]', '[]', '[]', '0.43', '0.648', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
551INSERT INTO `instance_vehicle` VALUES ('1230', '148', '1', '[3.4719064,[8418.3477,12021.596]]', '[]', '[[\"wheel_1_2_steering\",1]]', '0.2', '0.3', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
552INSERT INTO `instance_vehicle` VALUES ('1231', '159', '1', '[177,[4647.4,10464,0.00143433]]', '[]', '[]', '0.55', '0.532', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
553INSERT INTO `instance_vehicle` VALUES ('1232', '169', '1', '[53,[2490.3,4689.95,0.00134277]]', '[]', '[[\"wheel_1_1_steering\",1]]', '0.392', '0.593', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
554INSERT INTO `instance_vehicle` VALUES ('1233', '1', '1', '[355,[1946.19,2274.64,0.0013032]]', '[]', '[]', '0', '0', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
555INSERT INTO `instance_vehicle` VALUES ('1234', '2', '1', '[267,[2004.74,2275.64,0.00120068]]', '[]', '[]', '0', '0', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
556INSERT INTO `instance_vehicle` VALUES ('1235', '3', '1', '[8,[1836.04,2239.08,0.00142956]]', '[]', '[]', '0', '0', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
557INSERT INTO `instance_vehicle` VALUES ('1236', '6', '1', '[195,[1703.05,2231.89,0.00145721]]', '[]', '[]', '0', '0', '2012-11-01 13:29:46', '2012-11-01 13:29:46');
558INSERT INTO `instance_vehicle` VALUES ('1237', '7', '1', '[61,[1747.81,2321.22,0.00161171]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
559INSERT INTO `instance_vehicle` VALUES ('1238', '12', '1', '[245,[3508.55,2405.78,0.00146294]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
560INSERT INTO `instance_vehicle` VALUES ('1239', '14', '1', '[249,[3678.38,2494.59,0.0013299]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
561INSERT INTO `instance_vehicle` VALUES ('1240', '15', '1', '[41,[4564.03,2552.84,0.00144386]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
562INSERT INTO `instance_vehicle` VALUES ('1241', '23', '1', '[285,[5187.15,2082.67,0.00143862]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
563INSERT INTO `instance_vehicle` VALUES ('1242', '25', '1', '[74,[5831.51,2192.55,0.00145149]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
564INSERT INTO `instance_vehicle` VALUES ('1243', '26', '1', '[314,[6123.23,1987.68,0.00152779]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
565INSERT INTO `instance_vehicle` VALUES ('1244', '29', '1', '[216,[6261.02,2133.71,0.00140667]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
566INSERT INTO `instance_vehicle` VALUES ('1245', '31', '1', '[245,[6397.18,2221.84,0.00138283]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
567INSERT INTO `instance_vehicle` VALUES ('1246', '32', '1', '[43,[6527.46,2290,0.00143862]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
568INSERT INTO `instance_vehicle` VALUES ('1247', '34', '1', '[43,[6531.46,2290,0.00143862]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
569INSERT INTO `instance_vehicle` VALUES ('1248', '39', '1', '[132,[6389.15,2568.72,0.00143862]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
570INSERT INTO `instance_vehicle` VALUES ('1249', '40', '1', '[102,[6273,2571.66,0.00144243]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
571INSERT INTO `instance_vehicle` VALUES ('1250', '42', '1', '[322,[6334.38,3286.25,0.00106812]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
572INSERT INTO `instance_vehicle` VALUES ('1251', '43', '1', '[234,[6383.24,3214.7,0.0013485]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
573INSERT INTO `instance_vehicle` VALUES ('1252', '45', '1', '[145,[6764.63,2978.71,0.00143862]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
574INSERT INTO `instance_vehicle` VALUES ('1253', '63', '1', '[126,[5987.26,7807.34,0.00134277]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
575INSERT INTO `instance_vehicle` VALUES ('1254', '65', '1', '[126,[5988.26,7808.34,0.00134277]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
576INSERT INTO `instance_vehicle` VALUES ('1255', '70', '1', '[298,[5337.78,8558.67,0.00158691]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
577INSERT INTO `instance_vehicle` VALUES ('1256', '72', '1', '[102,[3978.76,8823.34,0.00170898]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
578INSERT INTO `instance_vehicle` VALUES ('1257', '73', '1', '[246,[3787.24,8952.46,0.00143433]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
579INSERT INTO `instance_vehicle` VALUES ('1258', '74', '1', '[88,[3813.74,8960.23,0.00143433]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
580INSERT INTO `instance_vehicle` VALUES ('1259', '75', '1', '[85,[3820.73,8955.62,0.00143433]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
581INSERT INTO `instance_vehicle` VALUES ('1260', '81', '1', '[29,[3802.41,8927,10.9342]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
582INSERT INTO `instance_vehicle` VALUES ('1261', '87', '1', '[236,[2230.91,11266.2,0.00170898]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
583INSERT INTO `instance_vehicle` VALUES ('1262', '90', '1', '[153,[1839.23,12036.5,0.00106812]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
584INSERT INTO `instance_vehicle` VALUES ('1263', '93', '1', '[224,[1686.06,13059.1,0.00149536]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
585INSERT INTO `instance_vehicle` VALUES ('1264', '97', '1', '[73,[3022.44,11829.5,0.000930786]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
586INSERT INTO `instance_vehicle` VALUES ('1265', '104', '1', '[310,[5010.86,12482.3,0.00143433]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
587INSERT INTO `instance_vehicle` VALUES ('1266', '107', '1', '[107,[5067.23,12483.4,0.00138855]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
588INSERT INTO `instance_vehicle` VALUES ('1267', '108', '1', '[174,[2906.14,9821.96,0.00143433]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
589INSERT INTO `instance_vehicle` VALUES ('1268', '112', '1', '[283,[2873.57,9884.28,37.7611]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
590INSERT INTO `instance_vehicle` VALUES ('1269', '117', '1', '[231,[6647.15,2849.44,0.00143862]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
591INSERT INTO `instance_vehicle` VALUES ('1270', '118', '1', '[230,[6648.87,2848.1,0.00143862]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
592INSERT INTO `instance_vehicle` VALUES ('1271', '123', '1', '[110,[3068.44,7986.02,0.103424]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
593INSERT INTO `instance_vehicle` VALUES ('1272', '163', '1', '[300,[2230.5,5167.99,0.00137329]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
594INSERT INTO `instance_vehicle` VALUES ('1273', '165', '1', '[289,[2590.99,5086.57,0.00143433]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
595INSERT INTO `instance_vehicle` VALUES ('1274', '167', '1', '[332,[2591.52,5075.1,0.00144958]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
596INSERT INTO `instance_vehicle` VALUES ('1275', '168', '1', '[239,[2579.47,5082.93,0.00143433]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
597INSERT INTO `instance_vehicle` VALUES ('1276', '173', '1', '[177,[1975.01,2275.82,0.0015502]]', '[]', '[]', '0', '0', '2012-11-01 13:29:47', '2012-11-01 13:29:47');
598INSERT INTO `instance_vehicle` VALUES ('1277', '181', '1', '[144,[10399.3,2366.69,0.00142097]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
599INSERT INTO `instance_vehicle` VALUES ('1278', '182', '1', '[155,[10407.1,2357.78,0.00144434]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
600INSERT INTO `instance_vehicle` VALUES ('1279', '183', '1', '[59,[10471.7,2343.65,0.103437]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
601INSERT INTO `instance_vehicle` VALUES ('1280', '184', '1', '[136,[10492,2330.82,0.00143862]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
602INSERT INTO `instance_vehicle` VALUES ('1281', '185', '1', '[334,[9936.79,1977.63,0.00143862]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
603INSERT INTO `instance_vehicle` VALUES ('1282', '186', '1', '[344,[9957.74,1985.24,0.00143862]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
604INSERT INTO `instance_vehicle` VALUES ('1283', '187', '1', '[75,[9978.57,1979.43,0.00143862]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
605INSERT INTO `instance_vehicle` VALUES ('1284', '189', '1', '[93,[9320.2,2037.65,0.0014677]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
606INSERT INTO `instance_vehicle` VALUES ('1285', '190', '1', '[166,[9279.42,2035.65,0.00137472]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
607INSERT INTO `instance_vehicle` VALUES ('1286', '191', '1', '[106,[8679.5,2444.05,0.00143766]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
608INSERT INTO `instance_vehicle` VALUES ('1287', '192', '1', '[92,[8680.61,2441.15,0.00144529]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
609INSERT INTO `instance_vehicle` VALUES ('1288', '197', '1', '[182,[8835.9,2840.78,0.00180054]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
610INSERT INTO `instance_vehicle` VALUES ('1289', '198', '1', '[182,[8836.9,2842.78,0.00180054]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
611INSERT INTO `instance_vehicle` VALUES ('1290', '205', '1', '[341,[13204,7002.29,0.00142717]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
612INSERT INTO `instance_vehicle` VALUES ('1291', '208', '1', '[242,[12023.2,9147.75,0.00144577]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
613INSERT INTO `instance_vehicle` VALUES ('1292', '210', '1', '[250,[12043,9149.25,0.00143814]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
614INSERT INTO `instance_vehicle` VALUES ('1293', '213', '1', '[221,[12280.3,9461.43,0.0013485]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
615INSERT INTO `instance_vehicle` VALUES ('1294', '214', '1', '[242,[12283.2,9455.86,0.00136566]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
616INSERT INTO `instance_vehicle` VALUES ('1295', '215', '1', '[324,[12270.4,9462.47,0.00165176]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
617INSERT INTO `instance_vehicle` VALUES ('1296', '225', '1', '[112,[11274.7,12222.9,0.0014801]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
618INSERT INTO `instance_vehicle` VALUES ('1297', '226', '1', '[203,[11259.6,12208.2,0.00143433]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
619INSERT INTO `instance_vehicle` VALUES ('1298', '227', '1', '[26,[11240.8,12208.1,0.00143433]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
620INSERT INTO `instance_vehicle` VALUES ('1299', '230', '1', '[124,[10636.9,8029.1,0.103439]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
621INSERT INTO `instance_vehicle` VALUES ('1300', '231', '1', '[142,[10633.3,8010.86,0.00143433]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
622INSERT INTO `instance_vehicle` VALUES ('1301', '232', '1', '[37,[10649.7,8005.16,0.103439]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
623INSERT INTO `instance_vehicle` VALUES ('1302', '238', '1', '[79,[6506.46,4586.54,0.00175476]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
624INSERT INTO `instance_vehicle` VALUES ('1303', '239', '1', '[182,[6509.5,4590.82,0.000671387]]', '[]', '[]', '0', '0', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
625INSERT INTO `instance_vehicle` VALUES ('1304', '21', '1', '[234,[4940.5,2198.67,0.00143862]]', '[]', '[]', '0.55', '0.602', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
626INSERT INTO `instance_vehicle` VALUES ('1305', '62', '1', '[188,[6260.87,7844.97,0.00152588]]', '[]', '[]', '0.55', '0.674', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
627INSERT INTO `instance_vehicle` VALUES ('1306', '95', '1', '[225,[2148.87,12853.1,0.00161743]]', '[]', '[]', '0.55', '0.429', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
628INSERT INTO `instance_vehicle` VALUES ('1307', '114', '1', '[17,[12013,12639.5,0.0584564]]', '[]', '[[\"velka vrtule\",1]]', '0.55', '0.655', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
629INSERT INTO `instance_vehicle` VALUES ('1308', '115', '1', '[174,[11477.3,11310.7,0.00149536]]', '[]', '[[\"mala vrtule\",1]]', '0.346', '0.7', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
630INSERT INTO `instance_vehicle` VALUES ('1309', '156', '1', '[57,[2862.88,9887.7,23.2235]]', '[]', '[]', '0.55', '0.55', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
631INSERT INTO `instance_vehicle` VALUES ('1310', '157', '1', '[152,[4125.65,10847.7,0.00143433]]', '[]', '[[\"motor\",1],[\"mala vrtule\",1]]', '0.55', '0.7', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
632INSERT INTO `instance_vehicle` VALUES ('1311', '175', '1', '[1,[6554.17,5598.13,19.8338]]', '[]', '[[\"motor\",1],[\"elektronika\",1]]', '0.55', '0.7', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
633INSERT INTO `instance_vehicle` VALUES ('1312', '176', '1', '[1,[11229,4247.62,7.49878]]', '[]', '[]', '0.2', '0.322', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
634INSERT INTO `instance_vehicle` VALUES ('1313', '9', '1', '[294,[3573.4,2203.29,0.00143814]]', '[]', '[[\"wheel_1_2_steering\",1]]', '0.55', '0.3', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
635INSERT INTO `instance_vehicle` VALUES ('1314', '116', '1', '[6605.08,2918.34,0.00143766]]', '[]', '[]', '0.55', '0.365', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
636INSERT INTO `instance_vehicle` VALUES ('1315', '151', '1', '[252.9185,[5852.5439,4727.2544,1.5258789]]', '[]', '[]', '0.366', '0.7', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
637INSERT INTO `instance_vehicle` VALUES ('1316', '220', '1', '[153,[13226.7,11772.4,0.00165176]]', '[]', '[[\"motor\",1]]', '0.272', '0.3', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
638INSERT INTO `instance_vehicle` VALUES ('1317', '35', '1', '[117,[6658.5,2291.37,0.00143862]]', '[]', '[[\"wheel_2_2_steering\",1]]', '0.55', '0.443', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
639INSERT INTO `instance_vehicle` VALUES ('1318', '59', '1', '[222,[6316.23,7713.15,0.00143433]]', '[]', '[]', '0.55', '0.7', '2012-11-01 13:29:48', '2012-11-01 13:29:48');
640INSERT INTO `instance_vehicle` VALUES ('1319', '160', '1', '[100,[4743.14,10188.3,0.00143433]]', '[]', '[[\"motor\",1]]', '0.208', '0.668', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
641INSERT INTO `instance_vehicle` VALUES ('1320', '224', '1', '[136,[12741.8,12282.4,0.00144196]]', '[]', '[[\"wheel_2_1_steering\",1]]', '0.55', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
642INSERT INTO `instance_vehicle` VALUES ('1321', '236', '1', '[236,[11334.8,6627.8,0.00144196]]', '[]', '[[\"palivo\",1],[\"karoserie\",1]]', '0.458', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
643INSERT INTO `instance_vehicle` VALUES ('1322', '80', '1', '[299,[3734.79,8677.57,0.00137329]]', '[]', '[[\"wheel_1_1_steering\",1]]', '0.2', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
644INSERT INTO `instance_vehicle` VALUES ('1323', '136', '1', '[285,[10426.5,2349.39,0.0014348]]', '[]', '[[\"palivo\",1],[\"wheel_2_1_steering\",1]]', '0.55', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
645INSERT INTO `instance_vehicle` VALUES ('1324', '143', '1', '[198.49109,[13103.873,10360.645,4.0054321]]', '[]', '[[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]', '0.48', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
646INSERT INTO `instance_vehicle` VALUES ('1325', '71', '1', '[294,[4108.38,8727.14,0.00125122]]', '[]', '[]', '0.55', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
647INSERT INTO `instance_vehicle` VALUES ('1326', '122', '1', '[233,[7076.7,3268.1,0.00143766]]', '[]', '[]', '0.2', '0.575', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
648INSERT INTO `instance_vehicle` VALUES ('1327', '129', '1', '[102,[2670.43,5266.14,0.00125122]]', '[]', '[[\"motor\",1],[\"wheel_2_1_steering\",1]]', '0.219', '0.698', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
649INSERT INTO `instance_vehicle` VALUES ('1328', '142', '1', '[181,[12720.1,9042.32,0.00287724]]', '[]', '[[\"palivo\",1],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1]]', '0.55', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
650INSERT INTO `instance_vehicle` VALUES ('1329', '174', '1', '[252,[1862.45,2169.65,0.00141668]]', '[]', '[[\"wheel_2_2_steering\",1]]', '0.455', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
651INSERT INTO `instance_vehicle` VALUES ('1330', '180', '1', '[186,[10563.4,2875.76,0.00234222]]', '[]', '[[\"palivo\",1]]', '0.395', '0.336', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
652INSERT INTO `instance_vehicle` VALUES ('1331', '41', '1', '[254,[6451.36,2861.8,0.00143862]]', '[]', '[[\"wheel_1_1_steering\",1],[\"wheel_2_2_steering\",1]]', '0.521', '0.3', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
653INSERT INTO `instance_vehicle` VALUES ('1332', '203', '1', '[360,[13387.8,6604.42,0.00126123]]', '[]', '[[\"palivo\",1],[\"wheel_1_1_steering\",1]]', '0.55', '0.665', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
654INSERT INTO `instance_vehicle` VALUES ('1333', '233', '1', '[162,[10671.8,8009.39,0.00143433]]', '[]', '[[\"wheel_2_2_steering\",1]]', '0.55', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
655INSERT INTO `instance_vehicle` VALUES ('1334', '140', '1', '[360,[13294.4,6102.1,0.00105572]]', '[]', '[[\"palivo\",1]]', '0.267', '0.381', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
656INSERT INTO `instance_vehicle` VALUES ('1335', '235', '1', '[360,[9447.2,8778.69,0.14917]]', '[]', '[]', '0.402', '0.3', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
657INSERT INTO `instance_vehicle` VALUES ('1336', '237', '1', '[230,[13268.8,6094.22,0.00143862]]', '[]', '[[\"karoserie\",1],[\"wheel_2_2_steering\",1]]', '0.2', '0.3', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
658INSERT INTO `instance_vehicle` VALUES ('1337', '113', '1', '[193,[2882.04,9871.03,37.6934]]', '[]', '[]', '0.55', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
659INSERT INTO `instance_vehicle` VALUES ('1338', '38', '1', '[37,[6534.57,2477.35,0.00137854]]', '[]', '[]', '0.2', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
660INSERT INTO `instance_vehicle` VALUES ('1339', '94', '1', '[252,[1666.84,13094.6,0.00146484]]', '[]', '[[\"wheel_1_1_steering\",1]]', '0.349', '0.3', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
661INSERT INTO `instance_vehicle` VALUES ('1340', '89', '1', '[132,[2204.39,11795.4,1.45158]]', '[]', '[[\"motor\",1]]', '0.52', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
662INSERT INTO `instance_vehicle` VALUES ('1341', '200', '1', '[341,[10316.8,3681.93,1.93906]]', '[]', '[]', '0.55', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
663INSERT INTO `instance_vehicle` VALUES ('1342', '88', '1', '[296,[2159.14,11850.7,0.000854492]]', '[]', '[]', '0.208', '0.36', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
664INSERT INTO `instance_vehicle` VALUES ('1343', '199', '1', '[128,[10208.9,3174.42,0.00110435]]', '[]', '[[\"motor\",1]]', '0.297', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
665INSERT INTO `instance_vehicle` VALUES ('1344', '201', '1', '[350,[12376.9,3475.17,0.00124048]]', '[]', '[]', '0.2', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
666INSERT INTO `instance_vehicle` VALUES ('1345', '10', '1', '[183,[3603.71,2079.54,2.94831]]', '[]', '[]', '0.55', '0.3', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
667INSERT INTO `instance_vehicle` VALUES ('1346', '30', '1', '[323,[6222.32,2183.22,0.00143862]]', '[]', '[[\"motor\",1],[\"karoserie\",1],[\"wheel_1_2_steering\",1]]', '0.2', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
668INSERT INTO `instance_vehicle` VALUES ('1347', '69', '1', '[120,[5378.99,8580.88,0.00146484]]', '[]', '[[\"palivo\",1]]', '0.55', '0.3', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
669INSERT INTO `instance_vehicle` VALUES ('1348', '161', '1', '[7,[2688.36,5604.03,0.00143433]]', '[]', '[[\"karoserie\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]', '0.46', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
670INSERT INTO `instance_vehicle` VALUES ('1349', '202', '1', '[91,[13115.3,3881.15,0.00144243]]', '[]', '[]', '0.55', '0.3', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
671INSERT INTO `instance_vehicle` VALUES ('1350', '105', '1', '[24,[5015.65,12458.9,0.00158691]]', '[]', '[]', '0.2', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
672INSERT INTO `instance_vehicle` VALUES ('1351', '144', '1', '[133.48735,[11992.119, 9075.0225, -3.0517578]]', '[]', '[]', '0.2', '0.3', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
673INSERT INTO `instance_vehicle` VALUES ('1352', '172', '1', '[225,[3698.46,6013.93,0.00143433]]', '[]', '[[\"palivo\",1]]', '0.435', '0.476', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
674INSERT INTO `instance_vehicle` VALUES ('1353', '131', '1', '[65,[10486.8,2006.53,0.00134802]]', '[]', '[[\"motor\",1]]', '0.442', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
675INSERT INTO `instance_vehicle` VALUES ('1354', '179', '1', '[204,[10803.6,2660.42,0.00143862]]', '[]', '[[\"wheel_1_2_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_2_2_steering\",1]]', '0.437', '0.3', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
676INSERT INTO `instance_vehicle` VALUES ('1355', '8', '1', '[165,[2028.49,2215.47,0.00144529]]', '[]', '[]', '0.2', '0.426', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
677INSERT INTO `instance_vehicle` VALUES ('1356', '77', '1', '[287,[3787.94,8955.26,0.00143433]]', '[]', '[]', '0.55', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
678INSERT INTO `instance_vehicle` VALUES ('1357', '106', '1', '[111,[5058.31,12462.3,0.00143433]]', '[]', '[[\"wheel_1_2_steering\",1]]', '0.2', '0.3', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
679INSERT INTO `instance_vehicle` VALUES ('1358', '125', '1', '[160,[1916.37,7516.88,0.0015564]]', '[]', '[]', '0.2', '0.358', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
680INSERT INTO `instance_vehicle` VALUES ('1359', '130', '1', '[20,[3351.35,3922.75,0.00144958]]', '[]', '[]', '0.55', '0.3', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
681INSERT INTO `instance_vehicle` VALUES ('1360', '134', '1', '[237,[10460.8,2322.76,0.215481]]', '[]', '[]', '0.55', '0.7', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
682INSERT INTO `instance_vehicle` VALUES ('1361', '218', '1', '[223,[12344.8,10633.2,0.000907898]]', '[]', '[]', '0.55', '0.316', '2012-11-01 13:29:49', '2012-11-01 13:29:49');
683INSERT INTO `instance_vehicle` VALUES ('1362', '11', '1', '[133,[3618.83,2065.77,3.31019]]', '[]', '[]', '0.475', '0.7', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
684INSERT INTO `instance_vehicle` VALUES ('1363', '13', '1', '[218,[3643.8,2546.55,0.00134754]]', '[]', '[]', '0.55', '0.3', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
685INSERT INTO `instance_vehicle` VALUES ('1364', '36', '1', '[227,[6564.57,2418.37,0.00143862]]', '[]', '[]', '0.55', '0.426', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
686INSERT INTO `instance_vehicle` VALUES ('1365', '85', '1', '[52,[2892.25,9749.2,0.00143433]]', '[]', '[[\"wheel_1_2_steering\",1]]', '0.549', '0.356', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
687INSERT INTO `instance_vehicle` VALUES ('1366', '99', '1', '[297,[3439.88,12319.7,0.00160217]]', '[]', '[]', '0.2', '0.641', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
688INSERT INTO `instance_vehicle` VALUES ('1367', '133', '1', '[234,[10505.9,2298.52,0.107767]]', '[]', '[[\"motor\",1]]', '0.55', '0.3', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
689INSERT INTO `instance_vehicle` VALUES ('1368', '139', '1', '[353,[12118.6,3485.21,0.00139046]]', '[]', '[]', '0.2', '0.3', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
690INSERT INTO `instance_vehicle` VALUES ('1369', '141', '1', '[94,[13373.1,6212.78,0.00152445]]', '[]', '[]', '0.372', '0.671', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
691INSERT INTO `instance_vehicle` VALUES ('1370', '150', '1', '[54.694489,[8400.2324,6694.3633,3.0517578]]', '[]', '[]', '0.2', '0.3', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
692INSERT INTO `instance_vehicle` VALUES ('1371', '27', '1', '[59,[6061.75,1934.57,0.00128269]]', '[]', '[]', '0.266', '0.361', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
693INSERT INTO `instance_vehicle` VALUES ('1372', '47', '1', '[240,[6706.47,2991.1,0.00143576]]', '[]', '[]', '0.55', '0.439', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
694INSERT INTO `instance_vehicle` VALUES ('1373', '68', '1', '[209,[5360.68,8581.01,0.00134277]]', '[]', '[[\"wheel_1_2_steering\",1]]', '0.411', '0.3', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
695INSERT INTO `instance_vehicle` VALUES ('1374', '178', '1', '[108,[7498.06,5107.75,0.00144958]]', '[]', '[]', '0.343', '0.7', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
696INSERT INTO `instance_vehicle` VALUES ('1375', '20', '1', '[152,[5145.47,2381.52,0.139968]]', '[]', '[]', '0.48', '0.672', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
697INSERT INTO `instance_vehicle` VALUES ('1376', '28', '1', '[228,[6194.77,2087.69,0.00162268]]', '[]', '[[\"wheel_1_2_steering\",1]]', '0.55', '0.3', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
698INSERT INTO `instance_vehicle` VALUES ('1377', '51', '1', '[123,[11467.3,11398.7,0.00164795]]', '[]', '[[\"wheel_1_1_steering\",1],[\"wheel_1_2_steering\",1]]', '0.2', '0.627', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
699INSERT INTO `instance_vehicle` VALUES ('1378', '67', '1', '[328,[5453.49,8486.9,0.00158691]]', '[]', '[]', '0.519', '0.7', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
700INSERT INTO `instance_vehicle` VALUES ('1379', '100', '1', '[303,[3438.91,12317.1,0.00164795]]', '[]', '[]', '0.55', '0.7', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
701INSERT INTO `instance_vehicle` VALUES ('1380', '109', '1', '[34,[2949.26,9777.23,0.00140381]]', '[]', '[]', '0.2', '0.7', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
702INSERT INTO `instance_vehicle` VALUES ('1381', '229', '1', '[136,[11257,12262.4,0.00146484]]', '[]', '[[\"motor\",1]]', '0.32', '0.652', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
703INSERT INTO `instance_vehicle` VALUES ('1382', '241', '1', '[292,[6560.65,4443.13,0.00170898]]', '[]', '[]', '0.2', '0.354', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
704INSERT INTO `instance_vehicle` VALUES ('1383', '24', '1', '[348,[5847.39,2203.91,0.00151539]]', '[]', '[[\"wheel_2_2_steering\",1]]', '0.2', '0.654', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
705INSERT INTO `instance_vehicle` VALUES ('1384', '121', '1', '[54,[6967.17,2480.14,0.212507]]', '[]', '[[\"karoserie\",1],[\"wheel_2_1_steering\",1]]', '0.55', '0.51', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
706INSERT INTO `instance_vehicle` VALUES ('1385', '124', '1', '[56,[3028.41,7874.2,0.00161743]]', '[]', '[[\"karoserie\",1],[\"wheel_2_2_steering\",1]]', '0.536', '0.7', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
707INSERT INTO `instance_vehicle` VALUES ('1386', '22', '1', '[156,[4915.46,2229.15,0.00143862]]', '[]', '[[\"palivo\",1]]', '0.55', '0.476', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
708INSERT INTO `instance_vehicle` VALUES ('1387', '78', '1', '[206,[3808.39,8886.88,0.00143433]]', '[]', '[[\"wheel_1_1_steering\",1]]', '0.55', '0.3', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
709INSERT INTO `instance_vehicle` VALUES ('1388', '110', '1', '[168,[2880.7,9884.34,0.00149536]]', '[]', '[[\"motor\",1]]', '0.454', '0.611', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
710INSERT INTO `instance_vehicle` VALUES ('1389', '137', '1', '[78,[11974.6,3567.13,0.00143862]]', '[]', '[[\"palivo\",1]]', '0.55', '0.7', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
711INSERT INTO `instance_vehicle` VALUES ('1390', '18', '1', '[206,[4754.22,2608.02,0.0584259]]', '[]', '[]', '0.311', '0.7', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
712INSERT INTO `instance_vehicle` VALUES ('1391', '228', '1', '[60,[11186.5,12288,0.00157166]]', '[]', '[[\"palivo\",1],[\"wheel_1_1_steering\",1]]', '0.55', '0.353', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
713INSERT INTO `instance_vehicle` VALUES ('1392', '55', '1', '[281,[6298.51,7832.84,0.00146484]]', '[]', '[]', '0.49', '0.7', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
714INSERT INTO `instance_vehicle` VALUES ('1393', '154', '1', '[40.095413,[9415.3467,8950.1064,-0.00012207031]]', '[]', '[[\"karoserie\",1]]', '0.55', '0.7', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
715INSERT INTO `instance_vehicle` VALUES ('1394', '211', '1', '[94,[12036.3,9142.56,0.00144196]]', '[]', '[]', '0.55', '0.7', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
716INSERT INTO `instance_vehicle` VALUES ('1395', '56', '1', '[43,[6292.22,7826,0.00149536]]', '[]', '[[\"palivo\",1],[\"motor\",1]]', '0.55', '0.633', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
717INSERT INTO `instance_vehicle` VALUES ('1396', '57', '1', '[30,[6286.14,7805.29,0.00131226]]', '[]', '[[\"motor\",1]]', '0.263', '0.7', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
718INSERT INTO `instance_vehicle` VALUES ('1397', '128', '1', '[105,[2764.59,5253.12,0.00137329]]', '[]', '[[\"wheel_1_1_steering\",1]]', '0.2', '0.61', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
719INSERT INTO `instance_vehicle` VALUES ('1398', '79', '1', '[244,[3815.12,8811.92,0.00140381]]', '[]', '[[\"wheel_2_2_steering\",1]]', '0.326', '0.3', '2012-11-01 13:29:50', '2012-11-01 13:29:50');
720INSERT INTO `instance_vehicle` VALUES ('1399', '132', '1', '[243,[10537.8,2199.67,0.00143862]]', '[]', '[]', '0.42', '0.7', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
721INSERT INTO `instance_vehicle` VALUES ('1400', '86', '1', '[237,[2228.57,11271,0.00170898]]', '[]', '[[\"wheel_2_1_steering\",1],[\"wheel_2_2_steering\",1]]', '0.55', '0.7', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
722INSERT INTO `instance_vehicle` VALUES ('1401', '127', '1', '[342,[2508.94,6330.11,0.00128174]]', '[]', '[[\"motor\",1]]', '0.2', '0.526', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
723INSERT INTO `instance_vehicle` VALUES ('1402', '92', '1', '[259,[1918.46,12440.1,0.00134277]]', '[]', '[[\"wheel_2_1_steering\",1]]', '0.55', '0.448', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
724INSERT INTO `instance_vehicle` VALUES ('1403', '103', '1', '[222,[4993.81,12530.6,0.00144958]]', '[]', '[[\"karoserie\",1]]', '0.55', '0.3', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
725INSERT INTO `instance_vehicle` VALUES ('1404', '206', '1', '[97,[13070.2,7162.65,0.00143862]]', '[]', '[]', '0.2', '0.627', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
726INSERT INTO `instance_vehicle` VALUES ('1405', '91', '1', '[66,[1845.13,12035,0.00144958]]', '[]', '[[\"wheel_2_2_steering\",1]]', '0.436', '0.546', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
727INSERT INTO `instance_vehicle` VALUES ('1406', '119', '1', '[130,[6748.51,2732.75,0.00143862]]', '[]', '[[\"palivo\",1]]', '0.55', '0.405', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
728INSERT INTO `instance_vehicle` VALUES ('1407', '221', '1', '[278,[13262.9,12058.7,0.00156403]]', '[]', '[[\"palivo\",1]]', '0.55', '0.7', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
729INSERT INTO `instance_vehicle` VALUES ('1408', '135', '1', '[234,[10500.4,2392.12,0.00145817]]', '[]', '[[\"wheel_1_2_steering\",1]]', '0.229', '0.7', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
730INSERT INTO `instance_vehicle` VALUES ('1409', '164', '1', '[246,[2612.85,5078.83,0.00143433]]', '[]', '[]', '0.55', '0.418', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
731INSERT INTO `instance_vehicle` VALUES ('1410', '84', '1', '[349,[2880.94,9693.5,0.0012207]]', '[]', '[[\"wheel_2_1_steering\",1]]', '0.55', '0.7', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
732INSERT INTO `instance_vehicle` VALUES ('1411', '188', '1', '[94,[9498.45,2008.85,0.00138903]]', '[]', '[[\"palivo\",1],[\"wheel_1_2_steering\",1]]', '0.55', '0.3', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
733INSERT INTO `instance_vehicle` VALUES ('1412', '52', '1', '[289,[12149.7,12726.3,0.00143433]]', '[]', '[[\"wheel_1_1_steering\",1]]', '0.55', '0.7', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
734INSERT INTO `instance_vehicle` VALUES ('1413', '54', '1', '[48,[6293.1,7850.45,0.00146484]]', '[]', '[]', '0.2', '0.368', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
735INSERT INTO `instance_vehicle` VALUES ('1414', '60', '1', '[35,[6333.04,7671.52,0.0524597]]', '[]', '[[\"wheel_1_1_steering\",1]]', '0.78', '0.7', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
736INSERT INTO `instance_vehicle` VALUES ('1415', '216', '1', '[67,[12232.3,9506.75,0.00156784]]', '[]', '[[\"wheel_2_2_steering\",1]]', '0.8', '0.7', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
737INSERT INTO `instance_vehicle` VALUES ('1416', '162', '1', '[46,[2254.15,5133.65,0.240982]]', '[]', '[]', '0.702', '0.563', '2012-11-01 13:29:51', '2012-11-01 13:29:51');
738
739-- ----------------------------
740-- Table structure for `log_code`
741-- ----------------------------
742DROP TABLE IF EXISTS `log_code`;
743CREATE TABLE `log_code` (
744  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
745  `name` varchar(50) NOT NULL,
746  `description` varchar(255) DEFAULT '',
747  PRIMARY KEY (`id`),
748  UNIQUE KEY `uq_log_code` (`name`)
749) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
750
751-- ----------------------------
752-- Records of log_code
753-- ----------------------------
754INSERT INTO `log_code` VALUES ('1', 'Login', 'Player has logged in');
755INSERT INTO `log_code` VALUES ('2', 'Logout', 'Player has logged out');
756INSERT INTO `log_code` VALUES ('3', 'Ban', 'Player was banned');
757INSERT INTO `log_code` VALUES ('4', 'Connect', 'Player has connected');
758INSERT INTO `log_code` VALUES ('5', 'Disconnect', 'Player has disconnected');
759
760-- ----------------------------
761-- Table structure for `log_entry`
762-- ----------------------------
763DROP TABLE IF EXISTS `log_entry`;
764CREATE TABLE `log_entry` (
765  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
766  `unique_id` varchar(128) NOT NULL DEFAULT '',
767  `log_code_id` int(11) unsigned NOT NULL,
768  `text` varchar(1024) DEFAULT '',
769  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
770  `instance_id` int(11) unsigned NOT NULL DEFAULT '0',
771  PRIMARY KEY (`id`),
772  KEY `fk1_log_entry` (`log_code_id`),
773  CONSTRAINT `fk1_log_entry` FOREIGN KEY (`log_code_id`) REFERENCES `log_code` (`id`)
774) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
775
776-- ----------------------------
777-- Records of log_entry
778-- ----------------------------
779INSERT INTO `log_entry` VALUES ('1', '10424262', '1', '', '2012-11-01 10:59:45', '1');
780INSERT INTO `log_entry` VALUES ('2', '10923334', '1', '', '2012-11-01 11:00:57', '1');
781INSERT INTO `log_entry` VALUES ('3', '10923334', '5', '', '2012-11-01 11:05:38', '1');
782INSERT INTO `log_entry` VALUES ('4', '10923334', '1', '', '2012-11-01 11:05:47', '1');
783INSERT INTO `log_entry` VALUES ('5', '4278982', '5', '', '2012-11-01 11:08:34', '1');
784INSERT INTO `log_entry` VALUES ('6', '', '1', '', '2012-11-01 11:10:47', '1');
785INSERT INTO `log_entry` VALUES ('7', '4278982', '1', '', '2012-11-01 11:10:47', '1');
786INSERT INTO `log_entry` VALUES ('8', '10923334', '1', '', '2012-11-01 11:10:49', '1');
787INSERT INTO `log_entry` VALUES ('9', '10923334', '5', '', '2012-11-01 11:14:35', '1');
788INSERT INTO `log_entry` VALUES ('10', '10923334', '1', '', '2012-11-01 11:14:45', '1');
789INSERT INTO `log_entry` VALUES ('11', '10923334', '5', '', '2012-11-01 11:15:23', '1');
790INSERT INTO `log_entry` VALUES ('12', '10923334', '1', '', '2012-11-01 11:15:31', '1');
791
792-- ----------------------------
793-- Table structure for `migration_schema_log`
794-- ----------------------------
795DROP TABLE IF EXISTS `migration_schema_log`;
796CREATE TABLE `migration_schema_log` (
797  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
798  `schema_name` varchar(255) NOT NULL,
799  `event_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
800  `old_version` varchar(255) NOT NULL,
801  `new_version` varchar(255) NOT NULL,
802  PRIMARY KEY (`id`)
803) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
804
805-- ----------------------------
806-- Records of migration_schema_log
807-- ----------------------------
808INSERT INTO `migration_schema_log` VALUES ('1', 'Bliss', '2012-11-01 10:50:23', '0.000000', '0.010000');
809INSERT INTO `migration_schema_log` VALUES ('2', 'Bliss', '2012-11-01 10:50:24', '0.010000', '0.020000');
810INSERT INTO `migration_schema_log` VALUES ('3', 'Bliss', '2012-11-01 10:50:24', '0.020000', '0.030000');
811INSERT INTO `migration_schema_log` VALUES ('4', 'Bliss', '2012-11-01 10:50:24', '0.030000', '0.040000');
812INSERT INTO `migration_schema_log` VALUES ('5', 'Bliss', '2012-11-01 10:50:25', '0.040000', '0.050000');
813INSERT INTO `migration_schema_log` VALUES ('6', 'Bliss', '2012-11-01 10:50:26', '0.050000', '0.060000');
814INSERT INTO `migration_schema_log` VALUES ('7', 'Bliss', '2012-11-01 10:50:26', '0.060000', '0.070000');
815INSERT INTO `migration_schema_log` VALUES ('8', 'Bliss', '2012-11-01 10:50:27', '0.070000', '0.080000');
816INSERT INTO `migration_schema_log` VALUES ('9', 'Bliss', '2012-11-01 10:50:27', '0.080000', '0.090000');
817INSERT INTO `migration_schema_log` VALUES ('10', 'Bliss', '2012-11-01 10:50:27', '0.090000', '0.100000');
818INSERT INTO `migration_schema_log` VALUES ('11', 'Bliss', '2012-11-01 10:50:27', '0.100000', '0.110000');
819INSERT INTO `migration_schema_log` VALUES ('12', 'Bliss', '2012-11-01 10:50:27', '0.110000', '0.120000');
820INSERT INTO `migration_schema_log` VALUES ('13', 'Bliss', '2012-11-01 10:50:27', '0.120000', '0.130000');
821INSERT INTO `migration_schema_log` VALUES ('14', 'Bliss', '2012-11-01 10:50:27', '0.130000', '0.140000');
822INSERT INTO `migration_schema_log` VALUES ('15', 'Bliss', '2012-11-01 10:50:27', '0.140000', '0.150000');
823INSERT INTO `migration_schema_log` VALUES ('16', 'Bliss', '2012-11-01 10:50:27', '0.150000', '0.160000');
824INSERT INTO `migration_schema_log` VALUES ('17', 'Bliss', '2012-11-01 10:50:27', '0.160000', '0.170000');
825INSERT INTO `migration_schema_log` VALUES ('18', 'Bliss', '2012-11-01 10:50:27', '0.170000', '0.180000');
826INSERT INTO `migration_schema_log` VALUES ('19', 'Bliss', '2012-11-01 10:50:28', '0.180000', '0.190000');
827INSERT INTO `migration_schema_log` VALUES ('20', 'Bliss', '2012-11-01 10:50:28', '0.190000', '0.200000');
828INSERT INTO `migration_schema_log` VALUES ('21', 'Bliss', '2012-11-01 10:50:29', '0.200000', '0.210000');
829INSERT INTO `migration_schema_log` VALUES ('22', 'Bliss', '2012-11-01 10:50:29', '0.210000', '0.220000');
830INSERT INTO `migration_schema_log` VALUES ('23', 'Bliss', '2012-11-01 10:50:29', '0.220000', '0.230000');
831INSERT INTO `migration_schema_log` VALUES ('24', 'Bliss', '2012-11-01 10:50:29', '0.230000', '0.240000');
832INSERT INTO `migration_schema_log` VALUES ('25', 'Bliss', '2012-11-01 10:50:29', '0.240000', '0.250000');
833INSERT INTO `migration_schema_log` VALUES ('26', 'Bliss', '2012-11-01 10:50:29', '0.250000', '0.260000');
834INSERT INTO `migration_schema_log` VALUES ('27', 'Bliss', '2012-11-01 10:50:30', '0.260000', '0.270000');
835INSERT INTO `migration_schema_log` VALUES ('28', 'blissbuildings', '2012-11-01 10:50:33', '0.000000', '0.010000');
836
837-- ----------------------------
838-- Table structure for `migration_schema_version`
839-- ----------------------------
840DROP TABLE IF EXISTS `migration_schema_version`;
841CREATE TABLE `migration_schema_version` (
842  `name` varchar(255) NOT NULL,
843  `version` varchar(255) NOT NULL,
844  PRIMARY KEY (`name`)
845) ENGINE=InnoDB DEFAULT CHARSET=utf8;
846
847-- ----------------------------
848-- Records of migration_schema_version
849-- ----------------------------
850INSERT INTO `migration_schema_version` VALUES ('Bliss', '0.270000');
851INSERT INTO `migration_schema_version` VALUES ('blissbuildings', '0.010000');
852
853-- ----------------------------
854-- Table structure for `profile`
855-- ----------------------------
856DROP TABLE IF EXISTS `profile`;
857CREATE TABLE `profile` (
858  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
859  `unique_id` varchar(128) NOT NULL,
860  `name` varchar(64) NOT NULL DEFAULT '',
861  `humanity` int(6) NOT NULL DEFAULT '2500',
862  `survival_attempts` int(3) unsigned NOT NULL DEFAULT '1',
863  `total_survival_time` int(5) unsigned NOT NULL DEFAULT '0',
864  `total_survivor_kills` int(4) unsigned NOT NULL DEFAULT '0',
865  `total_bandit_kills` int(4) unsigned NOT NULL DEFAULT '0',
866  `total_zombie_kills` int(5) unsigned NOT NULL DEFAULT '0',
867  `total_headshots` int(5) unsigned NOT NULL DEFAULT '0',
868  PRIMARY KEY (`id`),
869  UNIQUE KEY `uq_profile` (`unique_id`)
870) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
871
872-- ----------------------------
873-- Records of profile
874-- ----------------------------
875INSERT INTO `profile` VALUES ('1', '10923334', 'Rinaun', '2500', '1', '0', '0', '0', '0', '0');
876INSERT INTO `profile` VALUES ('2', '9835590', 'CornBread', '2500', '2', '0', '0', '0', '0', '0');
877INSERT INTO `profile` VALUES ('3', '86420102', 'RANDOMhero', '2500', '1', '0', '0', '0', '0', '0');
878INSERT INTO `profile` VALUES ('4', '5023558', 'Biddo', '2500', '1', '0', '0', '0', '0', '0');
879INSERT INTO `profile` VALUES ('5', '26888646', 'Andrew Harris', '2500', '1', '0', '0', '0', '0', '0');
880INSERT INTO `profile` VALUES ('6', '74899206', 'vincenzo', '2500', '2', '0', '0', '0', '0', '0');
881INSERT INTO `profile` VALUES ('7', '82302342', 'winterwill', '2500', '1', '0', '0', '0', '0', '0');
882INSERT INTO `profile` VALUES ('8', '72487174', 'Aaron', '2500', '1', '0', '0', '0', '0', '0');
883INSERT INTO `profile` VALUES ('9', '40161670', 'stardude5', '2500', '1', '0', '0', '0', '0', '0');
884INSERT INTO `profile` VALUES ('10', '16575174', 'brad', '2500', '1', '0', '0', '0', '0', '0');
885INSERT INTO `profile` VALUES ('11', '29601286', 'AlZymers the Mechanic', '2500', '1', '0', '0', '0', '0', '0');
886INSERT INTO `profile` VALUES ('12', '81706438', 'Tmoney', '2500', '1', '0', '0', '0', '0', '0');
887INSERT INTO `profile` VALUES ('13', '75452870', 'Clayton', '2500', '1', '0', '0', '0', '0', '0');
888INSERT INTO `profile` VALUES ('14', '10746886', '=OSF=NecessaryEvil', '2500', '1', '0', '0', '0', '0', '0');
889INSERT INTO `profile` VALUES ('15', '26734278', 'xlExample', '2500', '1', '0', '0', '0', '0', '0');
890INSERT INTO `profile` VALUES ('16', '66803782', 'GhoZt', '2500', '1', '0', '0', '0', '0', '0');
891INSERT INTO `profile` VALUES ('17', '55431046', 'AngryBirds', '2500', '1', '0', '0', '0', '0', '0');
892INSERT INTO `profile` VALUES ('18', '50901382', 'Obama Nhiayi', '2500', '2', '0', '0', '0', '0', '0');
893INSERT INTO `profile` VALUES ('19', '4278982', 'pappy dag', '2500', '1', '0', '0', '0', '0', '0');
894INSERT INTO `profile` VALUES ('20', '52189318', 'Bane', '2500', '1', '0', '0', '0', '0', '0');
895INSERT INTO `profile` VALUES ('21', '40109062', 'Weeda', '2500', '1', '0', '0', '0', '0', '0');
896INSERT INTO `profile` VALUES ('22', '1869760', 'TAW_Valko', '2500', '1', '0', '0', '0', '0', '0');
897INSERT INTO `profile` VALUES ('23', '80088966', 'John', '2500', '1', '0', '0', '0', '0', '0');
898INSERT INTO `profile` VALUES ('24', '3649986', 'Someone', '2500', '1', '0', '0', '0', '0', '0');
899
900-- ----------------------------
901-- Table structure for `survivor`
902-- ----------------------------
903DROP TABLE IF EXISTS `survivor`;
904CREATE TABLE `survivor` (
905  `id` int(8) unsigned NOT NULL AUTO_INCREMENT,
906  `unique_id` varchar(128) NOT NULL,
907  `world_id` smallint(5) unsigned NOT NULL DEFAULT '1',
908  `worldspace` varchar(60) NOT NULL DEFAULT '[]',
909  `inventory` varchar(2048) NOT NULL DEFAULT '[]',
910  `backpack` varchar(2048) NOT NULL DEFAULT '[]',
911  `medical` varchar(255) NOT NULL DEFAULT '[false,false,false,false,false,false,false,12000,[],[0,0],0]',
912  `is_dead` tinyint(3) unsigned NOT NULL DEFAULT '0',
913  `model` varchar(128) NOT NULL DEFAULT 'Survivor2_DZ',
914  `state` varchar(128) NOT NULL DEFAULT '["","aidlpercmstpsnonwnondnon_player_idlesteady04",36]',
915  `survivor_kills` int(3) unsigned NOT NULL DEFAULT '0',
916  `bandit_kills` int(3) unsigned NOT NULL DEFAULT '0',
917  `zombie_kills` int(4) unsigned NOT NULL DEFAULT '0',
918  `headshots` int(4) unsigned NOT NULL DEFAULT '0',
919  `last_ate` int(3) unsigned NOT NULL DEFAULT '0',
920  `last_drank` int(3) unsigned NOT NULL DEFAULT '0',
921  `survival_time` int(3) unsigned NOT NULL DEFAULT '0',
922  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
923  `start_time` datetime NOT NULL,
924  PRIMARY KEY (`id`),
925  KEY `idx1_main` (`unique_id`)
926) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
927
928-- ----------------------------
929-- Records of survivor
930-- ----------------------------
931INSERT INTO `survivor` VALUES ('1', '10923334', '1', '[249,[4608.71,2746.75,0.001]]', '[[\"ItemFlashlight\"],[\"ItemPainkiller\",\"ItemBandage\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[0,0]]', '0', 'Survivor2_DZ', '[\"\",\"aidlpercmstpsnonwnondnon_player_idlesteady03\",36]', '0', '0', '0', '0', '0', '0', '0', '2012-11-01 11:15:27', '2012-10-31 17:58:44');
932INSERT INTO `survivor` VALUES ('2', '9835590', '1', '[179,[13427.8,6360.83,0.15]]', '[[\"ItemFlashlight\",\"ItemWatch\",\"ItemKnife\"],[\"ItemPainkiller\",\"ItemPainkiller\",\"ItemBandage\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,true,true,false,true,5.067,[\"aimpoint\",\"pilot\"],[1.456,0],0,[260.508,303.961]]', '1', 'Survivor2_DZ', '[\"\",\"adthppnemstpsnonwnondnon\",41]', '0', '0', '0', '0', '0', '0', '0', '2012-10-31 18:12:13', '2012-10-31 18:02:20');
933INSERT INTO `survivor` VALUES ('3', '86420102', '1', '[90,[9759.23,1695.56,0.002]]', '[[\"ItemFlashlight\"],[\"ItemBandage\",\"ItemPainkiller\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[0,0]]', '0', 'Survivor2_DZ', '[\"\",\"amovpercmstpsnonwnondnon_zevl\",100]', '0', '0', '0', '0', '0', '0', '0', '2012-10-31 18:13:58', '2012-10-31 18:11:57');
934INSERT INTO `survivor` VALUES ('4', '9835590', '1', '[208,[12289,13008.2,0.002]]', '[[\"ItemWatch\",\"ItemKnife\",\"ItemHatchet\",\"ItemMap\",\"ItemMatchbox\",\"ItemFlashlight\",\"Binocular\",\"M16A2GL\"],[\"ItemAntibiotic\",\"ItemBandage\",\"FoodSteakCooked\",\"ItemSodaPepsi\",\"ItemMorphine\",\"30Rnd_556x45_Stanag\",\"30Rnd_556x45_Stanag\",\"30Rnd_556x45_Stanag\",\"ItemPainkiller\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[\"ItemBandage\",\"ItemPainkiller\",\"ItemMorphine\"],[3,1,1]]]', '[false,false,false,false,false,false,true,12000,[],[0.796,0],0,[405.03,630.694]]', '0', 'Survivor2_DZ', '[\"M16A2GL\",\"amovppnemstpsraswrfldnon\",42]', '0', '0', '12', '11', '0', '0', '0', '2012-11-01 09:27:35', '2012-10-31 18:12:24');
935INSERT INTO `survivor` VALUES ('5', '5023558', '1', '[180,[6121.92,8087.99,20.816]]', '[[\"ItemFlashlight\",\"ItemWatch\",\"Binocular\",\"ItemCompass\",\"ItemMap\",\"ItemKnife\",\"ItemHatchet\",\"ItemEtool\",\"UZI_EP1\",\"AKS_74_kobra\"],[\"ItemBandage\",\"ItemBandage\",\"SmokeShell\",\"ItemBandage\",\"ItemPainkiller\",\"30Rnd_545x39_AK\",\"30Rnd_545x39_AK\",\"30Rnd_545x39_AK\",\"30Rnd_545x39_AK\",\"30Rnd_9x19_UZI\",\"30Rnd_9x19_UZI\",\"15Rnd_9x19_M9\",\"15Rnd_9x19_M9\",\"17Rnd_9x19_glock17\",\"ItemSodaCoke\",\"ItemSodaCoke\",\"ItemSodaCoke\"]]', '[\"DZ_ALICE_Pack_EP1\",[[],[]],[[\"ItemPainkiller\",\"ItemMorphine\",\"ItemBloodbag\",\"20Rnd_762x51_DMR\",\"FoodCanSardines\",\"ItemSodaPepsi\",\"FoodCanFrankBeans\"],[1,3,2,4,2,4,2]]]', '[false,false,false,false,false,false,true,11487,[],[0,0],0,[57.914,53.0]]', '0', 'Survivor2_DZ', '[\"AKS_74_kobra\",\"amovppnemstpsraswrfldnon\",42]', '0', '0', '46', '40', '0', '0', '0', '2012-11-01 05:20:51', '2012-10-31 18:21:31');
936INSERT INTO `survivor` VALUES ('6', '26888646', '1', '[92,[9680.16,1691.84,0.002]]', '[[\"ItemFlashlight\"],[\"ItemBandage\",\"ItemPainkiller\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[4.4,6.409]]', '0', 'Survivor2_DZ', '[\"\",\"aidlpercmstpsnonwnondnon_player_idlesteady03\",36]', '0', '0', '0', '0', '0', '0', '0', '2012-11-01 09:17:10', '2012-10-31 18:29:41');
937INSERT INTO `survivor` VALUES ('7', '74899206', '1', '[343,[-18682.6,25925.5,0.002]]', '[[],[]]', '[\"\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[0,0]]', '1', 'Survivor1_DZ', '[\"\",\"amovpercmstpsnonwnondnon_zevl\",100]', '0', '0', '0', '0', '0', '0', '0', '2012-10-31 18:34:59', '2012-10-31 18:30:14');
938INSERT INTO `survivor` VALUES ('8', '74899206', '1', '[33,[10460.1,2600.38,11.116]]', '[[\"ItemFlashlight\",\"M16A2\",\"ItemToolbox\",\"ItemKnife\",\"ItemHatchet\",\"Makarov\",\"ItemWatch\",\"ItemMatchbox\",\"ItemMap\"],[\"ItemPainkiller\",\"30Rnd_556x45_Stanag\",\"30Rnd_556x45_Stanag\",\"ItemSodaCoke\",\"FoodCanFrankBeans\",\"SmokeShell\",\"ItemSodaCoke\",\"8Rnd_9x18_Makarov\",\"ItemBandage\",\"30Rnd_556x45_Stanag\",\"15Rnd_9x19_M9\",\"ItemBandage\",\"ItemSodaPepsi\",\"8Rnd_9x18_Makarov\",\"ItemWaterbottle\",\"8Rnd_9x18_Makarov\",\"FoodCanFrankBeans\",\"FoodCanSardines\",\"8Rnd_9x18_Makarov\",\"17Rnd_9x19_glock17\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[\"30Rnd_762x39_AK47\",\"ItemHeatPack\",\"FoodCanFrankBeans\",\"FoodCanSardines\",\"ItemSodaCoke\",\"ItemSodaPepsi\"],[2,1,1,1,1,1]]]', '[false,false,false,false,false,false,true,9885.96,[],[0.047,0],0,[89.857,124.191]]', '0', 'Survivor2_DZ', '[\"M16A2\",\"amovppnemstpsraswrfldnon\",41]', '0', '0', '26', '24', '0', '0', '0', '2012-10-31 19:06:27', '2012-10-31 18:35:11');
939INSERT INTO `survivor` VALUES ('9', '82302342', '1', '[6,[1153.56,2159.72,0.002]]', '[[\"ItemFlashlight\"],[\"ItemBandage\",\"ItemPainkiller\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[1.92,3.214]]', '0', 'Survivor2_DZ', '[\"\",\"aidlpknlmstpsnonwnondnon_player_idlesteady02\",36]', '0', '0', '0', '0', '0', '0', '0', '2012-10-31 18:38:17', '2012-10-31 18:37:39');
940INSERT INTO `survivor` VALUES ('10', '72487174', '1', '[315,[2575.96,1915.14,0.001]]', '[[\"ItemFlashlight\"],[\"ItemBandage\",\"ItemPainkiller\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[0,0]]', '0', 'Survivor2_DZ', '[\"\",\"aidlpercmstpsnonwnondnon_player_idlesteady03\",36]', '0', '0', '0', '0', '0', '0', '0', '2012-10-31 20:14:31', '2012-10-31 20:13:41');
941INSERT INTO `survivor` VALUES ('11', '40161670', '1', '[119,[4869.95,2228.64,0.001]]', '[[\"ItemFlashlight\",\"Remington870_lamp\"],[\"ItemBandage\",\"ItemPainkiller\",\"ItemBandage\",\"FoodCanBakedBeans\",\"8Rnd_B_Beneli_74Slug\",\"8Rnd_B_Beneli_74Slug\",\"ItemBandage\",\"ItemBandage\",\"ItemMorphine\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[248.89,272.133]]', '0', 'Survivor2_DZ', '[\"Remington870_lamp\",\"amovpknlmevasraswrfldf\",36]', '0', '0', '0', '0', '0', '0', '0', '2012-10-31 20:29:55', '2012-10-31 20:19:24');
942INSERT INTO `survivor` VALUES ('12', '16575174', '1', '[95,[10473.2,2166.04,0.001]]', '[[\"ItemFlashlight\",\"ItemWatch\"],[\"ItemBandage\",\"ItemPainkiller\",\"5x_22_LR_17_HMR\",\"FoodCanBakedBeans\",\"8Rnd_9x18_Makarov\",\"HandRoadFlare\",\"ItemWaterbottleUnfilled\",\"10x_303\",\"ItemSodaCoke\",\"HandRoadFlare\",\"ItemBandage\",\"ItemBandage\",\"HandChemRed\",\"ItemHeatPack\",\"ItemSodaCoke\",\"2Rnd_shotgun_74Slug\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[243.09,271.001]]', '0', 'Survivor2_DZ', '[\"RoadFlareMuzzle\",\"aidlpercmstpsnonwnondnon_player_idlesteady02\",41]', '0', '0', '0', '0', '0', '0', '0', '2012-10-31 21:43:46', '2012-10-31 20:20:37');
943INSERT INTO `survivor` VALUES ('13', '29601286', '1', '[292,[6377.05,7916.1,9.155e-04]]', '[[\"ItemFlashlight\",\"Binocular\",\"ItemKnife\",\"ItemMap\",\"ItemWatch\",\"Makarov\",\"bizon_silenced\"],[\"HandChemBlue\",\"ItemBandage\",\"ItemBandage\",\"HandRoadFlare\",\"HandRoadFlare\",\"FoodCanFrankBeans\",\"FoodCanBakedBeans\",\"8Rnd_9x18_Makarov\",\"8Rnd_9x18_Makarov\",\"8Rnd_9x18_Makarov\",\"FoodCanPasta\",\"8Rnd_9x18_Makarov\",\"ItemSodaPepsi\",\"8Rnd_9x18_Makarov\",\"ItemSodaCoke\",\"ItemSodaPepsi\",\"SmokeShell\",\"64Rnd_9x19_SD_Bizon\",\"ItemBandage\",\"ItemSodaCoke\"]]', '[\"DZ_ALICE_Pack_EP1\",[[],[]],[[\"ItemSodaCoke\",\"ItemWaterbottle\",\"ItemTent\",\"FoodCanPasta\",\"ItemPainkiller\",\"30Rnd_545x39_AK\",\"ItemJerrycan\",\"FoodCanBakedBeans\",\"ItemSodaPepsi\",\"ItemMorphine\"],[1,1,2,2,1,1,1,2,2,1]]]', '[false,false,false,true,false,false,true,11490.2,[\"aimpoint\"],[0.411,0],0,[972.415,242.577]]', '0', 'Survivor2_DZ', '[\"bizon_silenced\",\"aidlpercmstpsraswrfldnon_idlesteady04\",41]', '0', '0', '12', '8', '0', '0', '0', '2012-11-01 10:23:25', '2012-10-31 22:49:01');
944INSERT INTO `survivor` VALUES ('14', '81706438', '1', '[306,[11865.7,3160.52,9.403]]', '[[\"ItemFlashlight\"],[\"ItemBandage\",\"ItemPainkiller\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[18.88,23.312]]', '0', 'Survivor2_DZ', '[\"\",\"aswmpercmstpsnonwnondnon\",33]', '0', '0', '0', '0', '0', '0', '0', '2012-10-31 23:06:52', '2012-10-31 23:04:05');
945INSERT INTO `survivor` VALUES ('15', '75452870', '1', '[149,[2124.89,2137.13,0.001]]', '[[\"ItemFlashlight\"],[\"ItemBandage\",\"ItemPainkiller\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[0,0]]', '0', 'Survivor2_DZ', '[\"\",\"aidlpercmstpsnonwnondnon_player_idlesteady02\",36]', '0', '0', '0', '0', '0', '0', '0', '2012-11-01 03:31:17', '2012-10-31 23:10:22');
946INSERT INTO `survivor` VALUES ('16', '10746886', '1', '[113,[11436.1,3326.67,0.002]]', '[[\"ItemFlashlight\"],[\"ItemBandage\",\"ItemPainkiller\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[0,0]]', '0', 'Survivor2_DZ', '[\"\",\"aidlpercmstpsnonwnondnon_player_idlesteady04\",36]', '0', '0', '0', '0', '0', '0', '0', '2012-11-01 01:11:26', '2012-11-01 01:11:01');
947INSERT INTO `survivor` VALUES ('17', '26734278', '1', '[165,[1915.13,2254.79,0.001]]', '[[\"ItemFlashlight\",\"ItemMap\"],[\"ItemBandage\",\"ItemPainkiller\",\"HandChemBlue\",\"ItemPainkiller\",\"ItemSandbag\",\"ItemSodaPepsi\",\"FoodCanBakedBeans\",\"ItemSodaCoke\",\"ItemPainkiller\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,true,12000,[],[0.096,0],0,[70.357,80.389]]', '0', 'Survivor2_DZ', '[\"ChemLightMuzzle\",\"aidlpercmstpsnonwnondnon_player_idlesteady03\",38]', '0', '0', '0', '0', '0', '0', '0', '2012-11-01 05:48:18', '2012-11-01 05:43:55');
948INSERT INTO `survivor` VALUES ('18', '66803782', '1', '[247,[10032.1,2294.23,0.001]]', '[[\"ItemFlashlight\",\"AKS_74_kobra\",\"ItemKnife\",\"ItemWatch\",\"ItemCompass\",\"ItemMatchbox\",\"Binocular\",\"M9\"],[\"ItemPainkiller\",\"30Rnd_545x39_AK\",\"30Rnd_545x39_AK\",\"30Rnd_545x39_AK\",\"ItemBandage\",\"ItemBandage\",\"17Rnd_9x19_glock17\",\"15Rnd_9x19_M9\",\"ItemBandage\",\"15Rnd_9x19_M9\",\"15Rnd_9x19_M9\",\"15Rnd_9x19_M9\"]]', '[\"DZ_CivilBackpack_EP1\",[[],[]],[[\"ItemWaterbottle\",\"ItemWaterbottleUnfilled\",\"FoodCanFrankBeans\",\"FoodCanPasta\",\"FoodCanBakedBeans\",\"ItemSodaPepsi\"],[4,2,1,2,1,1]]]', '[false,false,false,false,false,false,true,11312.6,[],[0.352,0],0,[567.243,378.773]]', '0', 'Sniper1_DZ', '[\"M9\",\"aidlpercmstpsraswpstdnon_player_idlesteady02\",41]', '0', '0', '14', '14', '0', '0', '0', '2012-11-01 06:38:24', '2012-11-01 05:58:51');
949INSERT INTO `survivor` VALUES ('19', '55431046', '1', '[22,[3765.16,2236.49,0.002]]', '[[\"ItemFlashlight\"],[\"ItemBandage\",\"ItemPainkiller\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[3.84,6.376]]', '0', 'Survivor2_DZ', '[\"\",\"aidlpercmstpsnonwnondnon_player_idlesteady01\",36]', '0', '0', '0', '0', '0', '0', '0', '2012-11-01 06:01:59', '2012-11-01 06:00:27');
950INSERT INTO `survivor` VALUES ('20', '50901382', '1', '[172,[-18697.6,25815.301,0.001]]', '[[],[]]', '[\"\",[[],[]],[[],[]]]', '[false,false,false,true,true,false,true,2550.35,[\"aimpoint\",\"neck\",\"pilot\"],[0.868,0],0,[339.171,239.438]]', '1', 'Survivor2_DZ', '[\"\",\"aidlpercmstpsnonwnondnon_player_idlesteady03\",33]', '0', '0', '0', '0', '0', '0', '0', '2012-11-01 06:57:59', '2012-11-01 06:41:19');
951INSERT INTO `survivor` VALUES ('21', '4278982', '1', '[322,[2964.2,9758.67,12.978]]', '[[\"ItemToolbox\",\"ItemKnife\",\"Binocular\",\"ItemWatch\",\"Colt1911\",\"ItemMatchbox\",\"ItemMap\",\"ItemFlashlight\",\"ItemCompass\",\"ItemHatchet\",\"DMR\"],[\"HandChemBlue\",\"ItemBandage\",\"ItemBandage\",\"7Rnd_45ACP_1911\",\"7Rnd_45ACP_1911\",\"7Rnd_45ACP_1911\",\"7Rnd_45ACP_1911\",\"FoodCanBakedBeans\",\"7Rnd_45ACP_1911\",\"PartWheel\",\"ItemSodaCoke\",\"ItemSodaPepsi\",\"HandRoadFlare\",\"20Rnd_762x51_DMR\"]]', '[\"DZ_ALICE_Pack_EP1\",[[\"FN_FAL_ANPVS4\"],[1]],[[\"ItemPainkiller\",\"FoodCanPasta\",\"ItemSodaCoke\",\"FoodCanSardines\",\"20Rnd_762x51_FNFAL\"],[1,1,1,1,6]]]', '[false,false,false,false,false,false,true,10508.3,[],[0.525,0],0,[664.299,824.135]]', '0', 'Survivor2_DZ', '[\"\",\"amovpknlmstpsraswrfldnon\",42]', '0', '0', '10', '2', '0', '0', '0', '2012-11-01 11:10:47', '2012-11-01 06:55:19');
952INSERT INTO `survivor` VALUES ('22', '50901382', '1', '[344,[4946.94,2118.14,0.589]]', '[[\"ItemKnife\",\"AK_74\",\"ItemFlashlight\"],[\"HandChemBlue\",\"ItemBandage\",\"ItemEpinephrine\",\"ItemBandage\",\"ItemMorphine\",\"15Rnd_9x19_M9\",\"17Rnd_9x19_glock17\",\"30Rnd_545x39_AK\",\"HandRoadFlare\",\"8Rnd_9x18_Makarov\",\"30Rnd_545x39_AK\",\"30Rnd_545x39_AK\",\"30Rnd_545x39_AK\",\"HandChemRed\",\"ItemWaterbottle\"]]', '[\"DZ_Assault_Pack_EP1\",[[],[]],[[\"ItemPainkiller\",\"ItemSodaCoke\",\"ItemSodaPepsi\",\"ItemMorphine\",\"ItemBloodbag\",\"30Rnd_762x39_AK47\",\"ItemBandage\",\"6Rnd_45ACP\",\"17Rnd_9x19_glock17\"],[2,1,1,1,1,1,2,1,2]]]', '[false,false,false,false,true,false,true,10229.8,[],[0,0],0,[575.12,224.623]]', '0', 'Survivor2_DZ', '[\"AK_74\",\"amovppnemstpsraswrfldnon\",41]', '0', '0', '4', '0', '0', '0', '0', '2012-11-01 07:45:02', '2012-11-01 06:58:11');
953INSERT INTO `survivor` VALUES ('23', '52189318', '1', '[8,[10294.7,1890.96,0.14]]', '[[\"MeleeFlashlight\"],[\"ItemBandage\",\"ItemPainkiller\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[86.91,97.49]]', '0', 'Survivor2_DZ', '[\"MeleeFlashlight\",\"aidlpercmstpsraswpstdnon_player_idlesteady01\",37]', '0', '0', '0', '0', '0', '0', '0', '2012-11-01 08:38:10', '2012-11-01 08:33:06');
954INSERT INTO `survivor` VALUES ('24', '40109062', '1', '[330,[7316.63,2680.81,0.001]]', '[[\"ItemFlashlight\"],[\"ItemBandage\",\"ItemPainkiller\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[3.84,6.378]]', '0', 'Survivor2_DZ', '[\"\",\"aidlpercmstpsnonwnondnon_player_idlesteady03\",36]', '0', '0', '0', '0', '0', '0', '0', '2012-11-01 09:12:22', '2012-11-01 09:10:52');
955INSERT INTO `survivor` VALUES ('25', '1869760', '1', '[0,[3341.82,1966.43,0.001]]', '[[\"ItemFlashlight\"],[\"ItemBandage\",\"ItemPainkiller\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[0,0]]', '0', 'Survivor2_DZ', '[\"\",\"aidlpercmstpsnonwnondnon_player_idlesteady04\",36]', '0', '0', '0', '0', '0', '0', '0', '2012-11-01 09:50:26', '2012-11-01 09:49:57');
956INSERT INTO `survivor` VALUES ('26', '80088966', '1', '[213,[1864.33,2184.4,14.017]]', '[[\"MeleeFlashlight\"],[\"ItemBandage\",\"ItemPainkiller\",\"30Rnd_556x45_Stanag\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[146.64,160.981]]', '0', 'Survivor2_DZ', '[\"MeleeFlashlight\",\"amovpknlmstpsraswpstdnon_gear\",36]', '0', '0', '0', '0', '0', '0', '0', '2012-11-01 10:08:06', '2012-11-01 10:01:10');
957INSERT INTO `survivor` VALUES ('27', '3649986', '1', '[0,[10212.8,1572.63,8.178e-05]]', '[[\"ItemFlashlight\"],[\"ItemBandage\",\"ItemPainkiller\"]]', '[\"DZ_Patrol_Pack_EP1\",[[],[]],[[],[]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[0,0]]', '0', 'Survivor2_DZ', '[\"\",\"aidlpercmstpsnonwnondnon_player_idlesteady02\",36]', '0', '0', '0', '0', '0', '0', '0', '2012-11-01 10:20:01', '2012-11-01 10:18:33');
958
959-- ----------------------------
960-- Table structure for `vehicle`
961-- ----------------------------
962DROP TABLE IF EXISTS `vehicle`;
963CREATE TABLE `vehicle` (
964  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
965  `class_name` varchar(100) DEFAULT NULL,
966  `damage_min` decimal(4,3) NOT NULL DEFAULT '0.100',
967  `damage_max` decimal(4,3) NOT NULL DEFAULT '0.700',
968  `fuel_min` decimal(4,3) NOT NULL DEFAULT '0.200',
969  `fuel_max` decimal(4,3) NOT NULL DEFAULT '0.800',
970  `limit_min` tinyint(3) unsigned NOT NULL DEFAULT '0',
971  `limit_max` tinyint(3) unsigned NOT NULL DEFAULT '0',
972  `parts` varchar(1024) DEFAULT NULL,
973  `inventory` varchar(2048) NOT NULL DEFAULT '[]',
974  PRIMARY KEY (`id`),
975  UNIQUE KEY `uq1_vehicle` (`class_name`),
976  KEY `idx1_vehicle` (`class_name`)
977) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
978
979-- ----------------------------
980-- Records of vehicle
981-- ----------------------------
982INSERT INTO `vehicle` VALUES ('1', 'UAZ_Unarmed_TK_EP1', '0.300', '0.700', '0.200', '0.550', '1', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
983INSERT INTO `vehicle` VALUES ('2', 'UAZ_Unarmed_TK_CIV_EP1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
984INSERT INTO `vehicle` VALUES ('3', 'UAZ_Unarmed_UN_EP1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
985INSERT INTO `vehicle` VALUES ('4', 'UAZ_RU', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
986INSERT INTO `vehicle` VALUES ('5', 'ATV_US_EP1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
987INSERT INTO `vehicle` VALUES ('6', 'ATV_CZ_EP1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
988INSERT INTO `vehicle` VALUES ('7', 'SkodaBlue', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
989INSERT INTO `vehicle` VALUES ('8', 'Skoda', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
990INSERT INTO `vehicle` VALUES ('9', 'SkodaGreen', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
991INSERT INTO `vehicle` VALUES ('10', 'TT650_Ins', '0.300', '0.700', '0.200', '0.550', '0', '255', 'motor,wheel_1_1_steering,wheel_1_2_steering', '[]');
992INSERT INTO `vehicle` VALUES ('11', 'TT650_TK_EP1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'motor,wheel_1_1_steering,wheel_1_2_steering', '[]');
993INSERT INTO `vehicle` VALUES ('12', 'TT650_TK_CIV_EP1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'motor,wheel_1_1_steering,wheel_1_2_steering', '[]');
994INSERT INTO `vehicle` VALUES ('13', 'Old_bike_TK_CIV_EP1', '0.000', '0.000', '0.000', '0.000', '0', '255', null, '[]');
995INSERT INTO `vehicle` VALUES ('15', 'UH1H_DZ', '0.300', '0.700', '0.200', '0.550', '0', '255', 'motor,elektronika,mala vrtule,velka vrtule', '[]');
996INSERT INTO `vehicle` VALUES ('16', 'hilux1_civil_3_open', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
997INSERT INTO `vehicle` VALUES ('17', 'Ikarus_TK_CIV_EP1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
998INSERT INTO `vehicle` VALUES ('18', 'Ikarus', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
999INSERT INTO `vehicle` VALUES ('19', 'Tractor', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1000INSERT INTO `vehicle` VALUES ('20', 'S1203_TK_CIV_EP1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1001INSERT INTO `vehicle` VALUES ('21', 'V3S_Civ', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1002INSERT INTO `vehicle` VALUES ('22', 'UralCivil', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1003INSERT INTO `vehicle` VALUES ('23', 'car_hatchback', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1004INSERT INTO `vehicle` VALUES ('24', 'Fishing_Boat', '0.300', '0.700', '0.200', '0.550', '0', '255', 'motor', '[]');
1005INSERT INTO `vehicle` VALUES ('25', 'PBX', '0.300', '0.700', '0.200', '0.550', '0', '255', 'motor', '[]');
1006INSERT INTO `vehicle` VALUES ('26', 'Smallboat_1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'motor', '[]');
1007INSERT INTO `vehicle` VALUES ('27', 'Volha_2_TK_CIV_EP1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1008INSERT INTO `vehicle` VALUES ('28', 'Volha_1_TK_CIV_EP1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1009INSERT INTO `vehicle` VALUES ('29', 'SUV_TK_CIV_EP1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1010INSERT INTO `vehicle` VALUES ('30', 'car_sedan', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1011INSERT INTO `vehicle` VALUES ('32', 'TT650_Civ', '0.300', '0.700', '0.200', '0.550', '0', '255', 'motor,wheel_1_1_steering,wheel_1_2_steering', '[]');
1012INSERT INTO `vehicle` VALUES ('33', 'Smallboat_2', '0.300', '0.700', '0.200', '0.550', '0', '255', 'motor', '[]');
1013INSERT INTO `vehicle` VALUES ('34', 'M1030', '0.300', '0.700', '0.200', '0.550', '0', '255', 'motor,wheel_1_1_steering,wheel_1_2_steering', '[]');
1014INSERT INTO `vehicle` VALUES ('35', 'M1030_US_DES_EP1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'motor,wheel_1_1_steering,wheel_1_2_steering', '[]');
1015INSERT INTO `vehicle` VALUES ('36', 'Old_moto_TK_Civ_EP1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'motor,wheel_1_1_steering,wheel_1_2_steering', '[]');
1016INSERT INTO `vehicle` VALUES ('37', 'datsun1_civil_2_covered', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1017INSERT INTO `vehicle` VALUES ('38', 'LadaLM', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1018INSERT INTO `vehicle` VALUES ('39', 'Ural_TK_CIV_EP1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1019INSERT INTO `vehicle` VALUES ('40', 'VWGolf', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1020INSERT INTO `vehicle` VALUES ('41', 'datsun1_civil_1_open', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1021INSERT INTO `vehicle` VALUES ('42', 'Lada1_TK_CIV_EP1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1022INSERT INTO `vehicle` VALUES ('43', 'TT650_Gue', '0.300', '0.700', '0.200', '0.550', '0', '255', 'motor,wheel_1_1_steering,wheel_1_2_steering', '[]');
1023INSERT INTO `vehicle` VALUES ('44', 'datsun1_civil_3_open', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1024INSERT INTO `vehicle` VALUES ('45', 'hilux1_civil_1_open', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1025INSERT INTO `vehicle` VALUES ('46', 'UralOpen_INS', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1026INSERT INTO `vehicle` VALUES ('47', 'VolhaLimo_TK_CIV_EP1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1027INSERT INTO `vehicle` VALUES ('48', 'UAZ_CDF', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1028INSERT INTO `vehicle` VALUES ('49', 'SkodaRed', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1029INSERT INTO `vehicle` VALUES ('50', 'Ural_CDF', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1030INSERT INTO `vehicle` VALUES ('51', 'LandRover_CZ_EP1', '0.300', '0.700', '0.200', '0.550', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1031INSERT INTO `vehicle` VALUES ('52', 'UralCivil2', '0.100', '0.700', '0.200', '0.800', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1032INSERT INTO `vehicle` VALUES ('53', 'hilux1_civil_2_covered', '0.100', '0.700', '0.200', '0.800', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1033INSERT INTO `vehicle` VALUES ('54', 'Lada2_TK_CIV_EP1', '0.100', '0.700', '0.200', '0.800', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1034INSERT INTO `vehicle` VALUES ('55', 'LandRover_TK_CIV_EP1', '0.100', '0.700', '0.200', '0.800', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1035INSERT INTO `vehicle` VALUES ('100', 'LADAWreck', '0.000', '0.000', '0.000', '0.000', '0', '255', 'palivo,motor,karoserie,wheel_1_1_steering,wheel_1_2_steering,wheel_2_1_steering,wheel_2_2_steering', '[]');
1036
1037-- ----------------------------
1038-- Table structure for `world`
1039-- ----------------------------
1040DROP TABLE IF EXISTS `world`;
1041CREATE TABLE `world` (
1042  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
1043  `name` varchar(32) NOT NULL DEFAULT '0',
1044  `max_x` mediumint(9) DEFAULT '0',
1045  `max_y` mediumint(9) DEFAULT '0',
1046  PRIMARY KEY (`id`),
1047  UNIQUE KEY `uq_world` (`name`),
1048  KEY `idx1_world` (`name`)
1049) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
1050
1051-- ----------------------------
1052-- Records of world
1053-- ----------------------------
1054INSERT INTO `world` VALUES ('1', 'chernarus', '14700', '15360');
1055INSERT INTO `world` VALUES ('2', 'lingor', '10000', '10000');
1056INSERT INTO `world` VALUES ('3', 'utes', '5100', '5100');
1057INSERT INTO `world` VALUES ('4', 'takistan', '14000', '14000');
1058INSERT INTO `world` VALUES ('5', 'panthera2', '10200', '10200');
1059INSERT INTO `world` VALUES ('6', 'fallujah', '10200', '10200');
1060INSERT INTO `world` VALUES ('7', 'zargabad', '8000', '8000');
1061INSERT INTO `world` VALUES ('8', 'namalsk', '12000', '12000');
1062INSERT INTO `world` VALUES ('9', 'mbg_celle2', '13000', '13000');
1063
1064-- ----------------------------
1065-- Table structure for `world_vehicle`
1066-- ----------------------------
1067DROP TABLE IF EXISTS `world_vehicle`;
1068CREATE TABLE `world_vehicle` (
1069  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1070  `vehicle_id` smallint(5) unsigned NOT NULL DEFAULT '1',
1071  `world_id` smallint(5) unsigned NOT NULL DEFAULT '1',
1072  `worldspace` varchar(60) NOT NULL DEFAULT '[]',
1073  `description` varchar(1024) DEFAULT NULL,
1074  `chance` decimal(4,3) unsigned NOT NULL DEFAULT '0.000',
1075  `last_modified` varchar(10) DEFAULT NULL,
1076  PRIMARY KEY (`id`),
1077  KEY `idx1_world_vehicle` (`vehicle_id`) USING BTREE,
1078  KEY `idx2_world_vehicle` (`world_id`) USING BTREE,
1079  CONSTRAINT `world_vehicle_ibfk_1` FOREIGN KEY (`vehicle_id`) REFERENCES `vehicle` (`id`),
1080  CONSTRAINT `world_vehicle_ibfk_2` FOREIGN KEY (`world_id`) REFERENCES `world` (`id`)
1081) ENGINE=InnoDB AUTO_INCREMENT=242 DEFAULT CHARSET=utf8;
1082
1083-- ----------------------------
1084-- Records of world_vehicle
1085-- ----------------------------
1086INSERT INTO `world_vehicle` VALUES ('1', '13', '1', '[355,[1946.19,2274.64,0.0013032]]', 'House Kamenka', '0.990', null);
1087INSERT INTO `world_vehicle` VALUES ('2', '13', '1', '[267,[2004.74,2275.64,0.00120068]]', 'Store Kamenka', '0.990', null);
1088INSERT INTO `world_vehicle` VALUES ('3', '13', '1', '[8,[1836.04,2239.08,0.00142956]]', 'House Kamenka', '0.990', null);
1089INSERT INTO `world_vehicle` VALUES ('4', '5', '1', '[42,[1850.3,2178.1,0.2152]]', 'Firehouse Kamenka', '0.990', null);
1090INSERT INTO `world_vehicle` VALUES ('5', '7', '1', '[159,[1865.14,2147.92,0.00143862]]', 'Behind Firehouse Kamenka', '0.990', null);
1091INSERT INTO `world_vehicle` VALUES ('6', '13', '1', '[195,[1703.05,2231.89,0.00145721]]', 'ChicknHouse Kamenka', '0.990', null);
1092INSERT INTO `world_vehicle` VALUES ('7', '13', '1', '[61,[1747.81,2321.22,0.00161171]]', 'House Hill Kamenka', '0.990', null);
1093INSERT INTO `world_vehicle` VALUES ('8', '32', '1', '[165,[2028.49,2215.47,0.00144529]]', 'House by Store Kamenka', '0.990', null);
1094INSERT INTO `world_vehicle` VALUES ('9', '16', '1', '[294,[3573.4,2203.29,0.00143814]]', 'WareHouse Dock Komarovo', '0.990', null);
1095INSERT INTO `world_vehicle` VALUES ('10', '26', '1', '[183,[3603.71,2079.54,2.94831]]', 'Dock Komarovo', '0.990', null);
1096INSERT INTO `world_vehicle` VALUES ('11', '33', '1', '[133,[3618.83,2065.77,3.31019]]', 'Dock Komarovo', '0.990', null);
1097INSERT INTO `world_vehicle` VALUES ('12', '13', '1', '[245,[3508.55,2405.78,0.00146294]]', 'House Komarovo', '0.990', null);
1098INSERT INTO `world_vehicle` VALUES ('13', '34', '1', '[218,[3643.8,2546.55,0.00134754]]', 'Shed Komarovo', '0.990', null);
1099INSERT INTO `world_vehicle` VALUES ('14', '13', '1', '[249,[3678.38,2494.59,0.0013299]]', 'House Komarovo', '0.990', null);
1100INSERT INTO `world_vehicle` VALUES ('15', '13', '1', '[41,[4564.03,2552.84,0.00144386]]', 'House Balota', '0.990', null);
1101INSERT INTO `world_vehicle` VALUES ('16', '5', '1', '[261,[4608.12,2744.73,0.00145626]]', 'House Outside Balota', '0.990', null);
1102INSERT INTO `world_vehicle` VALUES ('17', '1', '1', '[112,[4751.68,2526.37,0.00146675]]', 'Balota Airstrip', '0.990', null);
1103INSERT INTO `world_vehicle` VALUES ('18', '39', '1', '[206,[4754.22,2608.02,0.0584259]]', 'Balota Airstrip', '0.990', null);
1104INSERT INTO `world_vehicle` VALUES ('19', '5', '1', '[308,[5147.27,2327.17,0.00143909]]', 'Balota Airstrip', '0.990', null);
1105INSERT INTO `world_vehicle` VALUES ('20', '36', '1', '[152,[5145.47,2381.52,0.139968]]', 'Balota Airstrip', '0.990', null);
1106INSERT INTO `world_vehicle` VALUES ('21', '15', '1', '[234,[4940.5,2198.67,0.00143862]]', 'Helicopter Spawnpad Balota', '0.990', null);
1107INSERT INTO `world_vehicle` VALUES ('22', '38', '1', '[156,[4915.46,2229.15,0.00143862]]', 'Camp Balota', '0.990', null);
1108INSERT INTO `world_vehicle` VALUES ('23', '13', '1', '[285,[5187.15,2082.67,0.00143862]]', 'House Outside Balota', '0.990', null);
1109INSERT INTO `world_vehicle` VALUES ('24', '37', '1', '[348,[5847.39,2203.91,0.00151539]]', 'Gas Station Outside Cherno', '0.990', null);
1110INSERT INTO `world_vehicle` VALUES ('25', '13', '1', '[74,[5831.51,2192.55,0.00145149]]', 'Gas Station Outside Cherno', '0.990', null);
1111INSERT INTO `world_vehicle` VALUES ('26', '13', '1', '[314,[6123.23,1987.68,0.00152779]]', 'Outside Cherno', '0.990', null);
1112INSERT INTO `world_vehicle` VALUES ('27', '35', '1', '[59,[6061.75,1934.57,0.00128269]]', 'Outside Cherno', '0.990', null);
1113INSERT INTO `world_vehicle` VALUES ('28', '36', '1', '[228,[6194.77,2087.69,0.00162268]]', 'Cherno 2story House', '0.990', null);
1114INSERT INTO `world_vehicle` VALUES ('29', '13', '1', '[216,[6261.02,2133.71,0.00140667]]', 'Cherno House', '0.990', null);
1115INSERT INTO `world_vehicle` VALUES ('30', '27', '1', '[323,[6222.32,2183.22,0.00143862]]', 'Outside Cherno', '0.990', null);
1116INSERT INTO `world_vehicle` VALUES ('31', '13', '1', '[245,[6397.18,2221.84,0.00138283]]', 'Cherno', '0.990', null);
1117INSERT INTO `world_vehicle` VALUES ('32', '13', '1', '[43,[6527.46,2290,0.00143862]]', 'Store Cherno', '0.990', null);
1118INSERT INTO `world_vehicle` VALUES ('33', '11', '1', '[43,[6529.32,2289.04,0.00143862]]', 'Store Cherno', '0.990', null);
1119INSERT INTO `world_vehicle` VALUES ('34', '13', '1', '[43,[6531.46,2290,0.00143862]]', 'Store Cherno', '0.990', null);
1120INSERT INTO `world_vehicle` VALUES ('35', '17', '1', '[117,[6658.5,2291.37,0.00143862]]', 'Church Cherno', '0.990', null);
1121INSERT INTO `world_vehicle` VALUES ('36', '34', '1', '[227,[6564.57,2418.37,0.00143862]]', 'Firehouse Cherno', '0.990', null);
1122INSERT INTO `world_vehicle` VALUES ('38', '23', '1', '[37,[6534.57,2477.35,0.00137854]]', 'Cherno Industrial', '0.990', null);
1123INSERT INTO `world_vehicle` VALUES ('39', '13', '1', '[132,[6389.15,2568.72,0.00143862]]', 'Cherno Industrial', '0.990', null);
1124INSERT INTO `world_vehicle` VALUES ('40', '13', '1', '[102,[6273,2571.66,0.00144243]]', 'Cherno', '0.990', null);
1125INSERT INTO `world_vehicle` VALUES ('41', '20', '1', '[254,[6451.36,2861.8,0.00143862]]', 'Cherno', '0.990', null);
1126INSERT INTO `world_vehicle` VALUES ('42', '13', '1', '[322,[6334.38,3286.25,0.00106812]]', 'Outside Cherno', '0.990', null);
1127INSERT INTO `world_vehicle` VALUES ('43', '13', '1', '[234,[6383.24,3214.7,0.0013485]]', 'Outside Cherno', '0.990', null);
1128INSERT INTO `world_vehicle` VALUES ('44', '11', '1', '[345,[6597.54,2921.26,0.00143957]]', 'Cherno', '0.990', null);
1129INSERT INTO `world_vehicle` VALUES ('45', '13', '1', '[145,[6764.63,2978.71,0.00143862]]', 'Cherno', '0.990', null);
1130INSERT INTO `world_vehicle` VALUES ('46', '40', '1', '[235,[6702.18,3000.09,0.00143719]]', 'Gas Station Cherno', '0.990', null);
1131INSERT INTO `world_vehicle` VALUES ('47', '35', '1', '[240,[6706.47,2991.1,0.00143576]]', 'Cherno', '0.990', null);
1132INSERT INTO `world_vehicle` VALUES ('48', '5', '1', '[196,[11468.4,11386.9,0.00158691]]', 'Klen Mountains', '0.990', null);
1133INSERT INTO `world_vehicle` VALUES ('49', '5', '1', '[120,[11461.7,11386.1,0.0015564]]', 'Klen Mountains', '0.990', null);
1134INSERT INTO `world_vehicle` VALUES ('50', '5', '1', '[173,[11456.9,11397.8,0.0015564]]', 'Klen Mountains', '0.990', null);
1135INSERT INTO `world_vehicle` VALUES ('51', '36', '1', '[123,[11467.3,11398.7,0.00164795]]', 'Klen Mountains', '0.990', null);
1136INSERT INTO `world_vehicle` VALUES ('52', '51', '1', '[289,[12149.7,12726.3,0.00143433]]', 'Northeast Airfield Camo', '0.990', null);
1137INSERT INTO `world_vehicle` VALUES ('53', '12', '1', '[105,[12139.6,12607.6,0.00138855]]', 'Northeast Airfield Industrial', '0.990', null);
1138INSERT INTO `world_vehicle` VALUES ('54', '52', '1', '[48,[6293.1,7850.45,0.00146484]]', 'Stary Sobor Car Lot', '0.990', null);
1139INSERT INTO `world_vehicle` VALUES ('55', '41', '1', '[281,[6298.51,7832.84,0.00146484]]', 'Stary Sobor Car Lot', '0.990', null);
1140INSERT INTO `world_vehicle` VALUES ('56', '42', '1', '[43,[6292.22,7826,0.00149536]]', 'Stary Sobor Car Lot', '0.990', null);
1141INSERT INTO `world_vehicle` VALUES ('57', '43', '1', '[30,[6286.14,7805.29,0.00131226]]', 'Stary Sobor Military Tents', '0.990', null);
1142INSERT INTO `world_vehicle` VALUES ('58', '10', '1', '[39,[6343.84,7770.92,0.00140381]]', 'Stary Sobor Military Tents', '0.990', null);
1143INSERT INTO `world_vehicle` VALUES ('59', '17', '1', '[222,[6316.23,7713.15,0.00143433]]', 'Stary Sobor Warehouse', '0.990', null);
1144INSERT INTO `world_vehicle` VALUES ('60', '53', '1', '[35,[6333.04,7671.52,0.0524597]]', 'Stary Sobor Warehouse', '0.990', null);
1145INSERT INTO `world_vehicle` VALUES ('61', '9', '1', '[218,[6259.18,7809.74,0.00164795]]', 'Stary Sobor Inner City', '0.990', null);
1146INSERT INTO `world_vehicle` VALUES ('62', '15', '1', '[188,[6260.87,7844.97,0.00152588]]', 'Stary Sobor Car Lot', '0.990', null);
1147INSERT INTO `world_vehicle` VALUES ('63', '13', '1', '[126,[5987.26,7807.34,0.00134277]]', 'Stary Sobor Grocery', '0.990', null);
1148INSERT INTO `world_vehicle` VALUES ('64', '13', '1', '[126,[5986.26,7806.34,0.00134277]]', 'Stary Sobor Grocery', '0.990', null);
1149INSERT INTO `world_vehicle` VALUES ('65', '13', '1', '[126,[5988.26,7808.34,0.00134277]]', 'Stary Sobor Grocery', '0.990', null);
1150INSERT INTO `world_vehicle` VALUES ('66', '6', '1', '[141,[6037.38,7792.28,0.00143433]]', 'Stary Sobor Inner City', '0.990', null);
1151INSERT INTO `world_vehicle` VALUES ('67', '36', '1', '[328,[5453.49,8486.9,0.00158691]]', 'Kabanino Streets', '0.990', null);
1152INSERT INTO `world_vehicle` VALUES ('68', '35', '1', '[209,[5360.68,8581.01,0.00134277]]', 'Kabanino House', '0.990', null);
1153INSERT INTO `world_vehicle` VALUES ('69', '27', '1', '[120,[5378.99,8580.88,0.00146484]]', 'Kabanino House', '0.990', null);
1154INSERT INTO `world_vehicle` VALUES ('70', '13', '1', '[298,[5337.78,8558.67,0.00158691]]', 'Kabanino House', '0.990', null);
1155INSERT INTO `world_vehicle` VALUES ('71', '19', '1', '[294,[4108.38,8727.14,0.00125122]]', 'Vybor Fields', '0.990', null);
1156INSERT INTO `world_vehicle` VALUES ('72', '13', '1', '[102,[3978.76,8823.34,0.00170898]]', 'Vybor Grocery', '0.990', null);
1157INSERT INTO `world_vehicle` VALUES ('73', '13', '1', '[246,[3787.24,8952.46,0.00143433]]', 'Vybor Grocery', '0.990', null);
1158INSERT INTO `world_vehicle` VALUES ('74', '13', '1', '[88,[3813.74,8960.23,0.00143433]]', 'Vybor Grocery', '0.990', null);
1159INSERT INTO `world_vehicle` VALUES ('75', '13', '1', '[85,[3820.73,8955.62,0.00143433]]', 'Vybor Schoolhouse', '0.990', null);
1160INSERT INTO `world_vehicle` VALUES ('76', '12', '1', '[293,[3789.45,8961.33,0.00146484]]', 'Vybor Grocery', '0.990', null);
1161INSERT INTO `world_vehicle` VALUES ('77', '32', '1', '[287,[3787.94,8955.26,0.00143433]]', 'Vybor Grocery', '0.990', null);
1162INSERT INTO `world_vehicle` VALUES ('78', '38', '1', '[206,[3808.39,8886.88,0.00143433]]', 'Vybor Inner City', '0.990', null);
1163INSERT INTO `world_vehicle` VALUES ('79', '44', '1', '[244,[3815.12,8811.92,0.00140381]]', 'Vybor Outskirts', '0.990', null);
1164INSERT INTO `world_vehicle` VALUES ('80', '18', '1', '[299,[3734.79,8677.57,0.00137329]]', 'Vybor Outskirts', '0.990', null);
1165INSERT INTO `world_vehicle` VALUES ('81', '13', '1', '[29,[3802.41,8927,10.9342]]', 'Vybor House', '0.990', null);
1166INSERT INTO `world_vehicle` VALUES ('82', '5', '1', '[349,[3487.4,8379.37,0.00137329]]', 'Pustoshka Streets', '0.990', null);
1167INSERT INTO `world_vehicle` VALUES ('83', '10', '1', '[245,[3753.24,8689.69,0.00143433]]', 'Pustoshka House', '0.990', null);
1168INSERT INTO `world_vehicle` VALUES ('84', '50', '1', '[349,[2880.94,9693.5,0.0012207]]', 'Lopatina Warehouse', '0.990', null);
1169INSERT INTO `world_vehicle` VALUES ('85', '34', '1', '[52,[2892.25,9749.2,0.00143433]]', 'Lopatina Warehouse', '0.990', null);
1170INSERT INTO `world_vehicle` VALUES ('86', '45', '1', '[237,[2228.57,11271,0.00170898]]', 'Road to Skalka', '0.990', null);
1171INSERT INTO `world_vehicle` VALUES ('87', '13', '1', '[236,[2230.91,11266.2,0.00170898]]', 'Road to Skalka', '0.990', null);
1172INSERT INTO `world_vehicle` VALUES ('88', '25', '1', '[296,[2159.14,11850.7,0.000854492]]', 'Skalka Pond', '0.990', null);
1173INSERT INTO `world_vehicle` VALUES ('89', '24', '1', '[132,[2204.39,11795.4,1.45158]]', 'Skalka Pond', '0.990', null);
1174INSERT INTO `world_vehicle` VALUES ('90', '13', '1', '[153,[1839.23,12036.5,0.00106812]]', 'Skalka Road', '0.990', null);
1175INSERT INTO `world_vehicle` VALUES ('91', '48', '1', '[66,[1845.13,12035,0.00144958]]', 'Skalka Road', '0.990', null);
1176INSERT INTO `world_vehicle` VALUES ('92', '46', '1', '[259,[1918.46,12440.1,0.00134277]]', 'Skalka Industrial', '0.990', null);
1177INSERT INTO `world_vehicle` VALUES ('93', '13', '1', '[224,[1686.06,13059.1,0.00149536]]', 'Skalka House', '0.990', null);
1178INSERT INTO `world_vehicle` VALUES ('94', '23', '1', '[252,[1666.84,13094.6,0.00146484]]', 'Skalka House', '0.990', null);
1179INSERT INTO `world_vehicle` VALUES ('95', '15', '1', '[225,[2148.87,12853.1,0.00161743]]', 'Skalka Mountains', '0.990', null);
1180INSERT INTO `world_vehicle` VALUES ('97', '13', '1', '[73,[3022.44,11829.5,0.000930786]]', 'Skalka Cottage', '0.990', null);
1181INSERT INTO `world_vehicle` VALUES ('98', '5', '1', '[30,[3018.82,11807.1,0.0015564]]', 'Skalka Cottage', '0.990', null);
1182INSERT INTO `world_vehicle` VALUES ('99', '34', '1', '[297,[3439.88,12319.7,0.00160217]]', 'Northwest Trails', '0.990', null);
1183INSERT INTO `world_vehicle` VALUES ('100', '36', '1', '[303,[3438.91,12317.1,0.00164795]]', 'Northwest Trails', '0.990', null);
1184INSERT INTO `world_vehicle` VALUES ('101', '5', '1', '[155,[4071.52,11677.1,0.00167847]]', 'Northwest Trails', '0.990', null);
1185INSERT INTO `world_vehicle` VALUES ('102', '5', '1', '[78,[4038.13,11670.9,0.00140381]]', 'Northwest Trails', '0.990', null);
1186INSERT INTO `world_vehicle` VALUES ('103', '47', '1', '[222,[4993.81,12530.6,0.00144958]]', 'Petrovka', '0.990', null);
1187INSERT INTO `world_vehicle` VALUES ('104', '13', '1', '[310,[5010.86,12482.3,0.00143433]]', 'Petrovka', '0.990', null);
1188INSERT INTO `world_vehicle` VALUES ('105', '29', '1', '[24,[5015.65,12458.9,0.00158691]]', 'Petrovka', '0.990', null);
1189INSERT INTO `world_vehicle` VALUES ('106', '32', '1', '[111,[5058.31,12462.3,0.00143433]]', 'Petrovka', '0.990', null);
1190INSERT INTO `world_vehicle` VALUES ('107', '13', '1', '[107,[5067.23,12483.4,0.00138855]]', 'Petrovka', '0.990', null);
1191INSERT INTO `world_vehicle` VALUES ('108', '13', '1', '[174,[2906.14,9821.96,0.00143433]]', 'Lopatina', '0.990', null);
1192INSERT INTO `world_vehicle` VALUES ('109', '36', '1', '[34,[2949.26,9777.23,0.00140381]]', 'Lopatina', '0.990', null);
1193INSERT INTO `world_vehicle` VALUES ('110', '38', '1', '[168,[2880.7,9884.34,0.00149536]]', 'Lopatina', '0.990', null);
1194INSERT INTO `world_vehicle` VALUES ('111', '5', '1', '[261,[2953.76,9903.49,0.00146484]]', 'Lopatina', '0.990', null);
1195INSERT INTO `world_vehicle` VALUES ('112', '13', '1', '[283,[2873.57,9884.28,37.7611]]', 'LOLpatino', '0.990', null);
1196INSERT INTO `world_vehicle` VALUES ('113', '22', '1', '[193,[2882.04,9871.03,37.6934]]', 'LOLpatino', '0.990', null);
1197INSERT INTO `world_vehicle` VALUES ('114', '15', '1', '[17,[12013,12639.5,0.0584564]]', 'Northeast Airfield', '0.990', null);
1198INSERT INTO `world_vehicle` VALUES ('115', '15', '1', '[174,[11477.3,11310.7,0.00149536]]', 'Klen Mountain', '0.990', null);
1199INSERT INTO `world_vehicle` VALUES ('116', '16', '1', '[6605.08,2918.34,0.00143766]]', 'Cherno', '0.990', null);
1200INSERT INTO `world_vehicle` VALUES ('117', '13', '1', '[231,[6647.15,2849.44,0.00143862]]', 'Prigorodky', '0.990', null);
1201INSERT INTO `world_vehicle` VALUES ('118', '13', '1', '[230,[6648.87,2848.1,0.00143862]]', 'Prigorodky', '0.990', null);
1202INSERT INTO `world_vehicle` VALUES ('119', '48', '1', '[130,[6748.51,2732.75,0.00143862]]', 'Prigorodky', '0.990', null);
1203INSERT INTO `world_vehicle` VALUES ('120', '10', '1', '[43,[6860.78,2597.28,0.00146008]]', 'Prigorodky', '0.990', null);
1204INSERT INTO `world_vehicle` VALUES ('121', '37', '1', '[54,[6967.17,2480.14,0.212507]]', 'Prigorodky', '0.990', null);
1205INSERT INTO `world_vehicle` VALUES ('122', '19', '1', '[233,[7076.7,3268.1,0.00143766]]', 'Prigorodky', '0.990', null);
1206INSERT INTO `world_vehicle` VALUES ('123', '13', '1', '[110,[3068.44,7986.02,0.103424]]', 'Pustoshka', '0.990', null);
1207INSERT INTO `world_vehicle` VALUES ('124', '37', '1', '[56,[3028.41,7874.2,0.00161743]]', 'Pustoshka', '0.990', null);
1208INSERT INTO `world_vehicle` VALUES ('125', '32', '1', '[160,[1916.37,7516.88,0.0015564]]', 'Pustoshka', '0.990', null);
1209INSERT INTO `world_vehicle` VALUES ('126', '4', '1', '[1943.09,7358.95,0.00158691]]', 'Myshtkna', '0.990', null);
1210INSERT INTO `world_vehicle` VALUES ('127', '45', '1', '[342,[2508.94,6330.11,0.00128174]]', 'Myshikna', '0.990', null);
1211INSERT INTO `world_vehicle` VALUES ('128', '43', '1', '[105,[2764.59,5253.12,0.00137329]]', 'Myshikna', '0.990', null);
1212INSERT INTO `world_vehicle` VALUES ('129', '19', '1', '[102,[2670.43,5266.14,0.00125122]]', 'Pavlovo', '0.990', null);
1213INSERT INTO `world_vehicle` VALUES ('130', '32', '1', '[20,[3351.35,3922.75,0.00144958]]', 'Pavlovo', '0.990', null);
1214INSERT INTO `world_vehicle` VALUES ('131', '30', '1', '[65,[10486.8,2006.53,0.00134802]]', 'Electro', '0.990', null);
1215INSERT INTO `world_vehicle` VALUES ('132', '44', '1', '[243,[10537.8,2199.67,0.00143862]]', 'Electro', '0.990', null);
1216INSERT INTO `world_vehicle` VALUES ('133', '34', '1', '[234,[10505.9,2298.52,0.107767]]', 'Electro', '0.990', null);
1217INSERT INTO `world_vehicle` VALUES ('134', '32', '1', '[237,[10460.8,2322.76,0.215481]]', 'Electro', '0.990', null);
1218INSERT INTO `world_vehicle` VALUES ('135', '49', '1', '[234,[10500.4,2392.12,0.00145817]]', 'Electro', '0.990', null);
1219INSERT INTO `world_vehicle` VALUES ('136', '18', '1', '[285,[10426.5,2349.39,0.0014348]]', 'Electro', '0.990', null);
1220INSERT INTO `world_vehicle` VALUES ('137', '38', '1', '[78,[11974.6,3567.13,0.00143862]]', 'Kamyshovo', '0.990', null);
1221INSERT INTO `world_vehicle` VALUES ('138', '5', '1', '[173,[12170,3519.73,0.00140619]]', 'Kamyshovo', '0.990', null);
1222INSERT INTO `world_vehicle` VALUES ('139', '34', '1', '[353,[12118.6,3485.21,0.00139046]]', 'Kamyshovo', '0.990', null);
1223INSERT INTO `world_vehicle` VALUES ('140', '21', '1', '[360,[13294.4,6102.1,0.00105572]]', 'Solnichiniy', '0.990', null);
1224INSERT INTO `world_vehicle` VALUES ('141', '34', '1', '[94,[13373.1,6212.78,0.00152445]]', 'Solnichiniy', '0.990', null);
1225INSERT INTO `world_vehicle` VALUES ('142', '19', '1', '[181,[12720.1,9042.32,0.00287724]]', 'Niz/Berezno mid farm', '0.990', null);
1226INSERT INTO `world_vehicle` VALUES ('143', '18', '1', '[198.49109,[13103.873,10360.645,4.0054321]]', 'Berezino', '0.990', null);
1227INSERT INTO `world_vehicle` VALUES ('144', '29', '1', '[133.48735,[11992.119, 9075.0225, -3.0517578]]', 'Berezino', '0.990', null);
1228INSERT INTO `world_vehicle` VALUES ('145', '6', '1', '[181.03763,[10202.597,9850.127,0.00068664551]]', 'Dubrovka', '0.990', null);
1229INSERT INTO `world_vehicle` VALUES ('146', '5', '1', '[225.06236,[10415.568,9855.6143,-9.9182129]]', 'Dubrovka', '0.990', null);
1230INSERT INTO `world_vehicle` VALUES ('147', '5', '1', '[-113.11581,[8557.8154,11957.857,7.6293945]]', 'Gvozdao', '0.990', null);
1231INSERT INTO `world_vehicle` VALUES ('148', '12', '1', '[3.4719064,[8418.3477,12021.596]]', 'Gvozdao', '0.990', null);
1232INSERT INTO `world_vehicle` VALUES ('149', '5', '1', '[-44.028866,[8524.8652,6625.3853,-0.056130722]]', 'Guglovo', '0.990', null);
1233INSERT INTO `world_vehicle` VALUES ('150', '34', '1', '[54.694489,[8400.2324,6694.3633,3.0517578]]', 'Guglovo', '0.990', null);
1234INSERT INTO `world_vehicle` VALUES ('151', '16', '1', '[252.9185,[5852.5439,4727.2544,1.5258789]]', 'Nadezhdino', '0.990', null);
1235INSERT INTO `world_vehicle` VALUES ('152', '5', '1', '[536.30884,[5921.0962,4696.5688,-6.1035156e-005]', 'Nadezhdino', '0.990', null);
1236INSERT INTO `world_vehicle` VALUES ('153', '6', '1', '[176.27989,[5926.9404, 4696.8701]', 'Nadezhdino', '0.990', null);
1237INSERT INTO `world_vehicle` VALUES ('154', '41', '1', '[40.095413,[9415.3467,8950.1064,-0.00012207031]]', 'Gorka', '0.990', null);
1238INSERT INTO `world_vehicle` VALUES ('155', '2', '1', '[27.56838,[9374.1426,8817.5078,-6.1035156e-005]]', 'Gorka', '0.990', null);
1239INSERT INTO `world_vehicle` VALUES ('156', '15', '1', '[57,[2862.88,9887.7,23.2235]]', 'Lopatina', '0.990', null);
1240INSERT INTO `world_vehicle` VALUES ('157', '15', '1', '[152,[4125.65,10847.7,0.00143433]]', 'NWAF', '0.990', null);
1241INSERT INTO `world_vehicle` VALUES ('158', '2', '1', '[150,[4493.17,10807.2,0.00143433]]', 'NWAF', '0.990', null);
1242INSERT INTO `world_vehicle` VALUES ('159', '12', '1', '[177,[4647.4,10464,0.00143433]]', 'NWAF', '0.990', null);
1243INSERT INTO `world_vehicle` VALUES ('160', '17', '1', '[100,[4743.14,10188.3,0.00143433]]', 'NWAF', '0.990', null);
1244INSERT INTO `world_vehicle` VALUES ('161', '28', '1', '[7,[2688.36,5604.03,0.00143433]]', 'Zelenagorsk Gas Station', '0.990', null);
1245INSERT INTO `world_vehicle` VALUES ('162', '55', '1', '[46,[2254.15,5133.65,0.240982]]', 'Zelenagorks Industrial', '0.990', null);
1246INSERT INTO `world_vehicle` VALUES ('163', '13', '1', '[300,[2230.5,5167.99,0.00137329]]', 'Zelenagorsk Industrial', '0.990', null);
1247INSERT INTO `world_vehicle` VALUES ('164', '49', '1', '[246,[2612.85,5078.83,0.00143433]]', 'Zelena Grocery', '0.990', null);
1248INSERT INTO `world_vehicle` VALUES ('165', '13', '1', '[289,[2590.99,5086.57,0.00143433]]', 'Zelena Grocery', '0.990', null);
1249INSERT INTO `world_vehicle` VALUES ('167', '13', '1', '[332,[2591.52,5075.1,0.00144958]]', 'Zelena Grocery', '0.990', null);
1250INSERT INTO `world_vehicle` VALUES ('168', '13', '1', '[239,[2579.47,5082.93,0.00143433]]', 'Zelena Grocery', '0.990', null);
1251INSERT INTO `world_vehicle` VALUES ('169', '12', '1', '[53,[2490.3,4689.95,0.00134277]]', 'Zelena/Bor Barn', '0.990', null);
1252INSERT INTO `world_vehicle` VALUES ('170', '5', '1', '[98,[3683.76,6000.34,0.00143433]]', 'Green Mountain', '0.990', null);
1253INSERT INTO `world_vehicle` VALUES ('171', '4', '1', '[161,[3692.99,5969.62,0.00143433]]', 'Green Mountain', '0.990', null);
1254INSERT INTO `world_vehicle` VALUES ('172', '29', '1', '[225,[3698.46,6013.93,0.00143433]]', 'Green Mountain', '0.990', null);
1255INSERT INTO `world_vehicle` VALUES ('173', '13', '1', '[177,[1975.01,2275.82,0.0015502]]', 'Kamenka Grocery', '0.990', null);
1256INSERT INTO `world_vehicle` VALUES ('174', '19', '1', '[252,[1862.45,2169.65,0.00141668]]', 'Kamenka Firehouse', '0.990', null);
1257INSERT INTO `world_vehicle` VALUES ('175', '15', '1', '[1,[6554.17,5598.13,19.8338]]', 'Zub Castle', '0.990', null);
1258INSERT INTO `world_vehicle` VALUES ('176', '15', '1', '[1,[11229,4247.62,7.49878]]', 'Rog Castle', '0.990', null);
1259INSERT INTO `world_vehicle` VALUES ('177', '7', '1', '[333,[7428.6,5152.33,0.00137329]]', 'Mogilevka', '0.990', null);
1260INSERT INTO `world_vehicle` VALUES ('178', '35', '1', '[108,[7498.06,5107.75,0.00144958]]', 'Mogilevka', '0.990', null);
1261INSERT INTO `world_vehicle` VALUES ('179', '30', '1', '[204,[10803.6,2660.42,0.00143862]]', 'Electro Outskirts', '0.990', null);
1262INSERT INTO `world_vehicle` VALUES ('180', '19', '1', '[186,[10563.4,2875.76,0.00234222]]', 'Dubry', '0.990', null);
1263INSERT INTO `world_vehicle` VALUES ('181', '13', '1', '[144,[10399.3,2366.69,0.00142097]]', 'Electro Grocery', '0.990', null);
1264INSERT INTO `world_vehicle` VALUES ('182', '13', '1', '[155,[10407.1,2357.78,0.00144434]]', 'Electro Grocery', '0.990', null);
1265INSERT INTO `world_vehicle` VALUES ('183', '13', '1', '[59,[10471.7,2343.65,0.103437]]', 'Electro School', '0.990', null);
1266INSERT INTO `world_vehicle` VALUES ('184', '13', '1', '[136,[10492,2330.82,0.00143862]]', 'Electro School', '0.990', null);
1267INSERT INTO `world_vehicle` VALUES ('185', '13', '1', '[334,[9936.79,1977.63,0.00143862]]', 'Electro Outskirts', '0.990', null);
1268INSERT INTO `world_vehicle` VALUES ('186', '13', '1', '[344,[9957.74,1985.24,0.00143862]]', 'Electro Outskirts', '0.990', null);
1269INSERT INTO `world_vehicle` VALUES ('187', '13', '1', '[75,[9978.57,1979.43,0.00143862]]', 'Electro Outskirts', '0.990', null);
1270INSERT INTO `world_vehicle` VALUES ('188', '50', '1', '[94,[9498.45,2008.85,0.00138903]]', 'Cap Galova', '0.990', null);
1271INSERT INTO `world_vehicle` VALUES ('189', '13', '1', '[93,[9320.2,2037.65,0.0014677]]', 'Cap Galova', '0.990', null);
1272INSERT INTO `world_vehicle` VALUES ('190', '13', '1', '[166,[9279.42,2035.65,0.00137472]]', 'Cap Galova', '0.990', null);
1273INSERT INTO `world_vehicle` VALUES ('191', '13', '1', '[106,[8679.5,2444.05,0.00143766]]', 'Cap Galova', '0.990', null);
1274INSERT INTO `world_vehicle` VALUES ('192', '13', '1', '[92,[8680.61,2441.15,0.00144529]]', 'Cap Galova', '0.990', null);
1275INSERT INTO `world_vehicle` VALUES ('193', '5', '1', '[110,[8849.62,2859.79,0.00115967]]', 'Pik Kozlova', '0.990', null);
1276INSERT INTO `world_vehicle` VALUES ('194', '5', '1', '[227,[8857.99,2865.04,0.00102234]]', 'Pik Kozlova', '0.990', null);
1277INSERT INTO `world_vehicle` VALUES ('195', '5', '1', '[45,[8856.46,2889.11,0.00117493]]', 'Pik Kozlova', '0.990', null);
1278INSERT INTO `world_vehicle` VALUES ('196', '5', '1', '[111,[8879.75,2854.01,0.00172424]]', 'Pik Kozlova', '0.990', null);
1279INSERT INTO `world_vehicle` VALUES ('197', '13', '1', '[182,[8835.9,2840.78,0.00180054]]', 'Pik Kozlova', '0.990', null);
1280INSERT INTO `world_vehicle` VALUES ('198', '13', '1', '[182,[8836.9,2842.78,0.00180054]]', 'Pik Kozlova', '0.990', null);
1281INSERT INTO `world_vehicle` VALUES ('199', '25', '1', '[128,[10208.9,3174.42,0.00110435]]', 'Topeka Dam', '0.990', null);
1282INSERT INTO `world_vehicle` VALUES ('200', '24', '1', '[341,[10316.8,3681.93,1.93906]]', 'Topeka Dam', '0.990', null);
1283INSERT INTO `world_vehicle` VALUES ('201', '25', '1', '[350,[12376.9,3475.17,0.00124048]]', 'Eastern Coast', '0.990', null);
1284INSERT INTO `world_vehicle` VALUES ('202', '28', '1', '[91,[13115.3,3881.15,0.00144243]]', 'Eastern Coast', '0.990', null);
1285INSERT INTO `world_vehicle` VALUES ('203', '20', '1', '[360,[13387.8,6604.42,0.00126123]]', 'Eastern Coast Gas Station', '0.990', null);
1286INSERT INTO `world_vehicle` VALUES ('204', '13', '1', '[339,[13373.5,6611.93,0.00145936]]', 'Eastern Coast Gas Station', '0.990', null);
1287INSERT INTO `world_vehicle` VALUES ('205', '13', '1', '[341,[13204,7002.29,0.00142717]]', 'Eastern Factory', '0.990', null);
1288INSERT INTO `world_vehicle` VALUES ('206', '47', '1', '[97,[13070.2,7162.65,0.00143862]]', 'Eastern Factory', '0.990', null);
1289INSERT INTO `world_vehicle` VALUES ('207', '10', '1', '[26,[13109.1,7128.65,1.21738]]', 'Eastern Factory', '0.990', null);
1290INSERT INTO `world_vehicle` VALUES ('208', '13', '1', '[242,[12023.2,9147.75,0.00144577]]', 'Berezino North Grocery', '0.990', null);
1291INSERT INTO `world_vehicle` VALUES ('209', '11', '1', '[236,[12026.6,9169.05,0.00144196]]', 'Berezino North Grocery', '0.990', null);
1292INSERT INTO `world_vehicle` VALUES ('210', '13', '1', '[250,[12043,9149.25,0.00143814]]', 'Berezino North Grocery', '0.990', null);
1293INSERT INTO `world_vehicle` VALUES ('211', '41', '1', '[94,[12036.3,9142.56,0.00144196]]', 'Berezino North Grocery', '0.990', null);
1294INSERT INTO `world_vehicle` VALUES ('212', '8', '1', '[264,[11961.7,9139.93,0.00143814]]', 'Berezino Hospital', '0.990', null);
1295INSERT INTO `world_vehicle` VALUES ('213', '13', '1', '[221,[12280.3,9461.43,0.0013485]]', 'Berezino South Grocery', '0.990', null);
1296INSERT INTO `world_vehicle` VALUES ('214', '13', '1', '[242,[12283.2,9455.86,0.00136566]]', 'Berezino South Grocery', '0.990', null);
1297INSERT INTO `world_vehicle` VALUES ('215', '13', '1', '[324,[12270.4,9462.47,0.00165176]]', 'Berezino South Grocery', '0.990', null);
1298INSERT INTO `world_vehicle` VALUES ('216', '53', '1', '[67,[12232.3,9506.75,0.00156784]]', 'Berezino Apartments', '0.990', null);
1299INSERT INTO `world_vehicle` VALUES ('217', '3', '1', '[261,[12174.6,9751.76,0.00143909]]', 'Berezino Military Tents', '0.990', null);
1300INSERT INTO `world_vehicle` VALUES ('218', '32', '1', '[223,[12344.8,10633.2,0.000907898]]', 'Khelm', '0.990', null);
1301INSERT INTO `world_vehicle` VALUES ('219', '9', '1', '[223,[12361.1,10818.5,0.00114441]]', 'Khelm', '0.990', null);
1302INSERT INTO `world_vehicle` VALUES ('220', '16', '1', '[153,[13226.7,11772.4,0.00165176]]', 'Blunt Rocks', '0.990', null);
1303INSERT INTO `world_vehicle` VALUES ('221', '48', '1', '[278,[13262.9,12058.7,0.00156403]]', 'Black Lake', '0.990', null);
1304INSERT INTO `world_vehicle` VALUES ('222', '5', '1', '[223,[13353,12090,0.00131226]]', 'Black Lake', '0.990', null);
1305INSERT INTO `world_vehicle` VALUES ('223', '5', '1', '[154,[13344.3,12089.5,0.00163269]]', 'Black Lake', '0.990', null);
1306INSERT INTO `world_vehicle` VALUES ('224', '17', '1', '[136,[12741.8,12282.4,0.00144196]]', 'Northeast Farmland', '0.990', null);
1307INSERT INTO `world_vehicle` VALUES ('225', '13', '1', '[112,[11274.7,12222.9,0.0014801]]', 'Krastonav Grocery', '0.990', null);
1308INSERT INTO `world_vehicle` VALUES ('226', '13', '1', '[203,[11259.6,12208.2,0.00143433]]', 'Krastonav Grocery', '0.990', null);
1309INSERT INTO `world_vehicle` VALUES ('227', '13', '1', '[26,[11240.8,12208.1,0.00143433]]', 'Krastonav Grocery', '0.990', null);
1310INSERT INTO `world_vehicle` VALUES ('228', '40', '1', '[60,[11186.5,12288,0.00157166]]', 'Krastonav Church', '0.990', null);
1311INSERT INTO `world_vehicle` VALUES ('229', '36', '1', '[136,[11257,12262.4,0.00146484]]', 'Krastonav Residential', '0.990', null);
1312INSERT INTO `world_vehicle` VALUES ('230', '13', '1', '[124,[10636.9,8029.1,0.103439]]', 'Polana Grocery', '0.990', null);
1313INSERT INTO `world_vehicle` VALUES ('231', '13', '1', '[142,[10633.3,8010.86,0.00143433]]', 'Polana Grocery', '0.990', null);
1314INSERT INTO `world_vehicle` VALUES ('232', '13', '1', '[37,[10649.7,8005.16,0.103439]]', 'Polana Grocery', '0.990', null);
1315INSERT INTO `world_vehicle` VALUES ('233', '20', '1', '[162,[10671.8,8009.39,0.00143433]]', 'Polana Residential', '0.990', null);
1316INSERT INTO `world_vehicle` VALUES ('234', '10', '1', '[293,[10654.5,8101.59,0.00144958]]', 'Polana Residential', '0.990', null);
1317INSERT INTO `world_vehicle` VALUES ('235', '21', '1', '[360,[9447.2,8778.69,0.14917]]', 'Gorka Shelter', '0.990', null);
1318INSERT INTO `world_vehicle` VALUES ('236', '17', '1', '[236,[11334.8,6627.8,0.00144196]]', 'Dolina', '0.990', null);
1319INSERT INTO `world_vehicle` VALUES ('237', '21', '1', '[230,[13268.8,6094.22,0.00143862]]', 'Quarry', '0.990', null);
1320INSERT INTO `world_vehicle` VALUES ('238', '13', '1', '[79,[6506.46,4586.54,0.00175476]]', 'Zub Backroads', '0.990', null);
1321INSERT INTO `world_vehicle` VALUES ('239', '13', '1', '[182,[6509.5,4590.82,0.000671387]]', 'Zub Backroads', '0.990', null);
1322INSERT INTO `world_vehicle` VALUES ('240', '5', '1', '[210,[6557.32,4449.87,0.00177002]]', 'Zub Backroads', '0.990', null);
1323INSERT INTO `world_vehicle` VALUES ('241', '36', '1', '[292,[6560.65,4443.13,0.00170898]]', 'Zub Backroads', '0.990', null);
1324
1325-- ----------------------------
1326-- Procedure structure for `proc_getBuildingPageCount`
1327-- ----------------------------
1328DROP PROCEDURE IF EXISTS `proc_getBuildingPageCount`;
1329DELIMITER ;;
1330CREATE DEFINER=`dayz`@`localhost` PROCEDURE `proc_getBuildingPageCount`(in `p_instanceId` int)
1331begin
1332  declare itemsPerPage int default 5; -- must match proc_getobjects
1333  select
1334    floor(count(*) / itemsPerPage) + if((count(*) mod itemsPerPage) > 0, 1, 0)
1335  from instance_building
1336  where instance_id = p_instanceId; --
1337end
1338;;
1339DELIMITER ;
1340
1341-- ----------------------------
1342-- Procedure structure for `proc_getBuildings`
1343-- ----------------------------
1344DROP PROCEDURE IF EXISTS `proc_getBuildings`;
1345DELIMITER ;;
1346CREATE DEFINER=`dayz`@`localhost` PROCEDURE `proc_getBuildings`(in `p_instanceId` int, in `p_currentPage` int)
1347begin
1348  set @instance = p_instanceId; --
1349  set @page = greatest(((p_currentPage - 1) * 5), 0); --
1350  prepare stmt from '
1351  select
1352    b.class_name, ib.worldspace
1353  from
1354    instance_building ib
1355    inner join building b on ib.building_id = b.id
1356  where
1357    ib.instance_id = ?
1358  limit ?, 5'; --
1359  execute stmt using @instance, @page; --
1360  deallocate prepare stmt; --
1361end
1362;;
1363DELIMITER ;
1364
1365-- ----------------------------
1366-- Procedure structure for `proc_loglogin`
1367-- ----------------------------
1368DROP PROCEDURE IF EXISTS `proc_loglogin`;
1369DELIMITER ;;
1370CREATE DEFINER=`dayz`@`localhost` PROCEDURE `proc_loglogin`(in `p_uniqueId` varchar(128), in `p_instanceId` int)
1371begin
1372  insert into log_entry (unique_id, instance_id, log_code_id) values (p_uniqueId, p_instanceId, 1); --
1373end
1374;;
1375DELIMITER ;
1376
1377-- ----------------------------
1378-- Procedure structure for `proc_loglogout`
1379-- ----------------------------
1380DROP PROCEDURE IF EXISTS `proc_loglogout`;
1381DELIMITER ;;
1382CREATE DEFINER=`dayz`@`localhost` PROCEDURE `proc_loglogout`(in `p_uniqueId` varchar(128), in `p_instanceId` int)
1383begin
1384  insert into log_entry (unique_id, instance_id, log_code_id) values (p_uniqueId, p_instanceId, 5); --
1385end
1386;;
1387DELIMITER ;