· 7 years ago · Sep 07, 2018, 04:20 PM
1-- MySQL dump 10.13 Distrib 5.7.18, for Win64 (x86_64)
2--
3-- Host: localhost Database: exile
4-- ------------------------------------------------------
5-- Server version 5.7.18-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Current Database: `exile`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `exile` /*!40100 DEFAULT CHARACTER SET utf8 */;
23
24USE `exile`;
25
26--
27-- Table structure for table `account`
28--
29
30DROP TABLE IF EXISTS `account`;
31/*!40101 SET @saved_cs_client = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `account` (
34 `uid` varchar(32) NOT NULL,
35 `clan_id` int(11) unsigned DEFAULT NULL,
36 `name` varchar(64) NOT NULL,
37 `score` int(11) NOT NULL DEFAULT '0',
38 `kills` int(11) unsigned NOT NULL DEFAULT '0',
39 `deaths` int(11) unsigned NOT NULL DEFAULT '0',
40 `locker` int(11) NOT NULL DEFAULT '1000000',
41 `first_connect_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
42 `last_connect_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
43 `last_disconnect_at` datetime DEFAULT NULL,
44 `total_connections` int(11) unsigned NOT NULL DEFAULT '1',
45 PRIMARY KEY (`uid`),
46 KEY `clan_id` (`clan_id`),
47 CONSTRAINT `account_ibfk_1` FOREIGN KEY (`clan_id`) REFERENCES `clan` (`id`) ON DELETE SET NULL
48) ENGINE=InnoDB DEFAULT CHARSET=utf8;
49/*!40101 SET character_set_client = @saved_cs_client */;
50
51--
52-- Dumping data for table `account`
53--
54
55LOCK TABLES `account` WRITE;
56/*!40000 ALTER TABLE `account` DISABLE KEYS */;
57INSERT INTO `account` VALUES ('76561198054241421',1,'Cj Andersin',4920,22,11,207817,'2018-08-27 12:43:39','2018-08-28 14:34:36','2018-08-28 15:50:15',7),('76561198068674681',NULL,'Austin',-102,0,9,500000,'2018-08-29 22:25:52','2018-08-29 23:21:37','2018-08-29 23:19:55',2),('76561198093676226',NULL,'KyleGD',5055,86,35,800000,'2018-08-22 18:54:41','2018-08-30 23:35:53','2018-08-30 23:30:55',75),('76561198105238009',NULL,'Scott Manly',396,2,3,1000000,'2018-08-23 00:13:17','2018-08-28 16:56:04','2018-08-28 17:08:44',6),('76561198194280417',NULL,'Given Help',313,2,0,377000,'2018-08-27 12:42:02','2018-08-27 12:42:02','2018-08-27 13:24:09',1),('76561198221222644',NULL,'DDay',0,0,0,1000000,'2018-08-23 00:41:29','2018-08-23 00:41:29','2018-08-23 00:46:23',1),('76561198350862554',NULL,'Dreyfus',6063,5,3,539546,'2018-08-28 14:09:33','2018-08-29 01:22:41','2018-08-29 01:27:15',5),('76561198833733672',NULL,'Sawyer',0,0,0,1000000,'2018-08-23 00:51:30','2018-08-23 00:51:30','2018-08-23 00:53:51',1),('DMS_PersistentVehicle',NULL,'DMS_PersistentVehicle',0,0,0,1000000,'2018-08-22 18:50:53','2018-08-22 18:50:53',NULL,1);
58/*!40000 ALTER TABLE `account` ENABLE KEYS */;
59UNLOCK TABLES;
60
61--
62-- Table structure for table `clan`
63--
64
65DROP TABLE IF EXISTS `clan`;
66/*!40101 SET @saved_cs_client = @@character_set_client */;
67/*!40101 SET character_set_client = utf8 */;
68CREATE TABLE `clan` (
69 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
70 `name` varchar(64) NOT NULL,
71 `leader_uid` varchar(32) NOT NULL,
72 `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
73 PRIMARY KEY (`id`),
74 KEY `leader_uid` (`leader_uid`),
75 CONSTRAINT `clan_ibfk_1` FOREIGN KEY (`leader_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE
76) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
77/*!40101 SET character_set_client = @saved_cs_client */;
78
79--
80-- Dumping data for table `clan`
81--
82
83LOCK TABLES `clan` WRITE;
84/*!40000 ALTER TABLE `clan` DISABLE KEYS */;
85INSERT INTO `clan` VALUES (1,'11th Recon Divison','76561198054241421','2018-08-28 14:07:18');
86/*!40000 ALTER TABLE `clan` ENABLE KEYS */;
87UNLOCK TABLES;
88
89--
90-- Table structure for table `clan_map_marker`
91--
92
93DROP TABLE IF EXISTS `clan_map_marker`;
94/*!40101 SET @saved_cs_client = @@character_set_client */;
95/*!40101 SET character_set_client = utf8 */;
96CREATE TABLE `clan_map_marker` (
97 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
98 `clan_id` int(11) unsigned NOT NULL,
99 `markerType` tinyint(4) NOT NULL DEFAULT '-1',
100 `positionArr` text NOT NULL,
101 `color` varchar(255) NOT NULL,
102 `icon` varchar(255) NOT NULL,
103 `iconSize` float unsigned NOT NULL,
104 `label` varchar(255) NOT NULL,
105 `labelSize` float unsigned NOT NULL,
106 PRIMARY KEY (`id`),
107 KEY `clan_id` (`clan_id`),
108 CONSTRAINT `clan_map_marker_ibfk_1` FOREIGN KEY (`clan_id`) REFERENCES `clan` (`id`) ON DELETE CASCADE
109) ENGINE=InnoDB DEFAULT CHARSET=utf8;
110/*!40101 SET character_set_client = @saved_cs_client */;
111
112--
113-- Dumping data for table `clan_map_marker`
114--
115
116LOCK TABLES `clan_map_marker` WRITE;
117/*!40000 ALTER TABLE `clan_map_marker` DISABLE KEYS */;
118/*!40000 ALTER TABLE `clan_map_marker` ENABLE KEYS */;
119UNLOCK TABLES;
120
121--
122-- Table structure for table `construction`
123--
124
125DROP TABLE IF EXISTS `construction`;
126/*!40101 SET @saved_cs_client = @@character_set_client */;
127/*!40101 SET character_set_client = utf8 */;
128CREATE TABLE `construction` (
129 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
130 `class` varchar(64) NOT NULL,
131 `account_uid` varchar(32) NOT NULL,
132 `spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
133 `position_x` double NOT NULL DEFAULT '0',
134 `position_y` double NOT NULL DEFAULT '0',
135 `position_z` double NOT NULL DEFAULT '0',
136 `direction_x` double NOT NULL DEFAULT '0',
137 `direction_y` double NOT NULL DEFAULT '0',
138 `direction_z` double NOT NULL DEFAULT '0',
139 `up_x` double NOT NULL DEFAULT '0',
140 `up_y` double NOT NULL DEFAULT '0',
141 `up_z` double NOT NULL DEFAULT '0',
142 `is_locked` tinyint(1) NOT NULL DEFAULT '0',
143 `pin_code` varchar(6) NOT NULL DEFAULT '000000',
144 `damage` tinyint(1) unsigned DEFAULT '0',
145 `territory_id` int(11) unsigned DEFAULT NULL,
146 `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
147 `deleted_at` datetime DEFAULT NULL,
148 PRIMARY KEY (`id`),
149 KEY `account_uid` (`account_uid`),
150 KEY `territory_id` (`territory_id`),
151 CONSTRAINT `construction_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
152 CONSTRAINT `construction_ibfk_2` FOREIGN KEY (`territory_id`) REFERENCES `territory` (`id`) ON DELETE CASCADE
153) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
154/*!40101 SET character_set_client = @saved_cs_client */;
155
156--
157-- Dumping data for table `construction`
158--
159
160LOCK TABLES `construction` WRITE;
161/*!40000 ALTER TABLE `construction` DISABLE KEYS */;
162INSERT INTO `construction` VALUES (1,'Land_BarGate_F','76561198054241421','2018-08-28 15:31:30',1051.747437,177.299637,-0.0381241,-0.11213,0.993694,0,0,0,1,0,'000000',0,2,'2018-08-28 15:31:30',NULL),(5,'Land_HBarrierWall6_F','76561198054241421','2018-08-28 15:33:01',1045.0992432,173.182663,-0.0249786,-0.669337,0.742959,0,0,0,1,0,'000000',0,2,'2018-08-28 15:33:01',NULL),(7,'Land_HBarrierWall6_F','76561198054241421','2018-08-28 15:33:30',1059.16394,176.251587,-0.0414429,0.333931,0.942597,0,0,0,1,0,'000000',0,2,'2018-08-28 15:33:30',NULL),(8,'Land_HBarrierWall_corner_F','76561198054241421','2018-08-28 15:34:09',1064.821167,173.174438,-0.0320053,0.599721,0.800209,0,0,0,1,0,'000000',0,NULL,'2018-08-30 17:51:59','2018-08-30 17:51:59'),(9,'Land_HBarrierWall_corner_F','76561198054241421','2018-08-28 15:34:27',1041.281128,168.441772,0.0126877,-0.775828,-0.630944,0,0,0,1,0,'000000',0,2,'2018-08-28 15:34:27',NULL),(10,'Land_Wall_IndCnc_4_F','76561198054241421','2018-08-28 15:34:54',1043.853394,163.150772,0.0362549,-0.698424,-0.715685,0,0,0,1,0,'000000',0,2,'2018-08-28 15:34:54',NULL),(11,'Land_Wall_IndCnc_4_F','76561198054241421','2018-08-28 15:35:09',1048.82666,160.274506,0.0421906,-0.277679,-0.960674,0,0,0,1,0,'000000',0,2,'2018-08-28 15:35:09',NULL),(12,'Land_Wall_IndCnc_4_F','76561198054241421','2018-08-28 15:35:33',1054.444702,160.458252,0.0363693,0.310859,-0.950456,0,0,0,1,0,'000000',0,2,'2018-08-28 15:35:33',NULL),(13,'Land_Wall_IndCnc_4_F','76561198054241421','2018-08-28 15:35:53',1059.518921,163.266724,0.025795,0.626659,-0.779293,0,0,0,1,0,'000000',0,2,'2018-08-28 15:35:53',NULL),(15,'Land_Sign_WarningMilitaryArea_F','76561198054241421','2018-08-28 15:36:28',1046.543701,177.875244,-0.00307465,0.621422,-0.783476,0,0,0,1,0,'000000',0,2,'2018-08-28 15:36:28',NULL),(16,'Land_Wall_IndCnc_4_F','76561198054241421','2018-08-28 15:37:17',1063.529175,167.490356,0.0207443,0.795538,-0.605904,0,0,0,1,0,'000000',0,2,'2018-08-28 15:37:17',NULL),(17,'Land_Wall_IndCnc_4_F','76561198054241421','2018-08-28 15:37:29',1065.380737,170.0731659,0.0174179,0.809586,-0.587002,0,0,0,1,0,'000000',0,2,'2018-08-28 15:37:29',NULL),(20,'Land_PortableLight_double_F','76561198054241421','2018-08-28 15:42:38',1046.712524,176.623398,0.996399,-0.715513,-0.698599,0,0,0,1,0,'000000',0,2,'2018-08-28 15:42:38',NULL),(21,'Land_PortableLight_double_F','76561198054241421','2018-08-28 15:42:58',1056.208862,178.57518,0.965485,0.91039,-0.413751,0,0,0,1,0,'000000',0,2,'2018-08-28 15:42:58',NULL),(22,'Land_BagBunker_Small_F','76561198054241421','2018-08-28 15:43:15',1051.618652,168.0914154,0.0387268,-0.038189,-0.999271,0,0,0,1,0,'000000',0,2,'2018-08-28 15:43:15',NULL),(24,'Land_SatelliteAntenna_01_F','76561198054241421','2018-08-28 15:44:09',1052.180908,167.960724,1.967491,-0.351903,0.936037,0,0,0,1,0,'000000',0,2,'2018-08-28 15:44:09',NULL),(25,'Land_Wall_IndCnc_4_F','76561198054241421','2018-08-28 15:44:59',1055.140747,176.868927,-0.00504303,-0.967396,0.253269,0,0,0,1,0,'000000',0,2,'2018-08-28 15:44:59',NULL),(26,'Land_Wall_IndCnc_4_F','76561198054241421','2018-08-28 15:45:35',1048.751953,175.354935,-0.0345078,0.72265,0.691214,0,0,0,1,0,'000000',0,2,'2018-08-28 15:45:35',NULL),(27,'Land_Wall_IndCnc_4_F','76561198054241421','2018-08-28 15:46:47',1057.0281982,172.793091,-0.0364761,0.458228,0.888835,0,0,0,1,0,'000000',0,2,'2018-08-28 15:46:47',NULL),(28,'Land_Wall_IndCnc_4_F','76561198054241421','2018-08-28 15:48:10',1048.85083,171.0353699,0.0089798,-0.750299,0.661099,0,0,0,1,0,'000000',0,2,'2018-08-28 15:48:10',NULL),(31,'Land_Sleeping_bag_F','76561198054241421','2018-08-28 15:49:15',1050.909302,168.536133,-0.00914001,0.0644985,0.997918,0,0,0,1,0,'000000',0,2,'2018-08-28 15:49:15',NULL);
163/*!40000 ALTER TABLE `construction` ENABLE KEYS */;
164UNLOCK TABLES;
165
166--
167-- Table structure for table `container`
168--
169
170DROP TABLE IF EXISTS `container`;
171/*!40101 SET @saved_cs_client = @@character_set_client */;
172/*!40101 SET character_set_client = utf8 */;
173CREATE TABLE `container` (
174 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
175 `class` varchar(64) NOT NULL,
176 `spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
177 `account_uid` varchar(32) DEFAULT NULL,
178 `is_locked` tinyint(1) NOT NULL DEFAULT '0',
179 `position_x` double NOT NULL DEFAULT '0',
180 `position_y` double NOT NULL DEFAULT '0',
181 `position_z` double NOT NULL DEFAULT '0',
182 `direction_x` double NOT NULL DEFAULT '0',
183 `direction_y` double NOT NULL DEFAULT '0',
184 `direction_z` double NOT NULL DEFAULT '0',
185 `up_x` double NOT NULL DEFAULT '0',
186 `up_y` double NOT NULL DEFAULT '0',
187 `up_z` double NOT NULL DEFAULT '1',
188 `cargo_items` text NOT NULL,
189 `cargo_magazines` text NOT NULL,
190 `cargo_weapons` text NOT NULL,
191 `cargo_container` text NOT NULL,
192 `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
193 `pin_code` varchar(6) NOT NULL DEFAULT '000000',
194 `territory_id` int(11) unsigned DEFAULT NULL,
195 `deleted_at` datetime DEFAULT NULL,
196 `money` int(11) unsigned NOT NULL DEFAULT '0',
197 `abandoned` datetime DEFAULT NULL,
198 PRIMARY KEY (`id`),
199 KEY `account_uid` (`account_uid`),
200 KEY `territory_id` (`territory_id`),
201 CONSTRAINT `container_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
202 CONSTRAINT `container_ibfk_2` FOREIGN KEY (`territory_id`) REFERENCES `territory` (`id`) ON DELETE CASCADE
203) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
204/*!40101 SET character_set_client = @saved_cs_client */;
205
206--
207-- Dumping data for table `container`
208--
209
210LOCK TABLES `container` WRITE;
211/*!40000 ALTER TABLE `container` DISABLE KEYS */;
212/*!40000 ALTER TABLE `container` ENABLE KEYS */;
213UNLOCK TABLES;
214
215--
216-- Table structure for table `player`
217--
218
219DROP TABLE IF EXISTS `player`;
220/*!40101 SET @saved_cs_client = @@character_set_client */;
221/*!40101 SET character_set_client = utf8 */;
222CREATE TABLE `player` (
223 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
224 `name` varchar(64) NOT NULL,
225 `account_uid` varchar(32) NOT NULL,
226 `money` int(11) unsigned NOT NULL DEFAULT '0',
227 `damage` double unsigned NOT NULL DEFAULT '0',
228 `hunger` double unsigned NOT NULL DEFAULT '100',
229 `thirst` double unsigned NOT NULL DEFAULT '100',
230 `alcohol` double unsigned NOT NULL DEFAULT '0',
231 `temperature` double NOT NULL DEFAULT '37',
232 `wetness` double unsigned NOT NULL DEFAULT '0',
233 `oxygen_remaining` double unsigned NOT NULL DEFAULT '1',
234 `bleeding_remaining` double unsigned NOT NULL DEFAULT '0',
235 `hitpoints` varchar(1024) NOT NULL DEFAULT '[]',
236 `direction` double NOT NULL DEFAULT '0',
237 `position_x` double NOT NULL DEFAULT '0',
238 `position_y` double NOT NULL DEFAULT '0',
239 `position_z` double NOT NULL DEFAULT '0',
240 `spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
241 `assigned_items` text NOT NULL,
242 `backpack` varchar(64) NOT NULL,
243 `backpack_items` text NOT NULL,
244 `backpack_magazines` text NOT NULL,
245 `backpack_weapons` text NOT NULL,
246 `current_weapon` varchar(64) NOT NULL,
247 `goggles` varchar(64) NOT NULL,
248 `handgun_items` text NOT NULL,
249 `handgun_weapon` varchar(64) NOT NULL,
250 `headgear` varchar(64) NOT NULL,
251 `binocular` varchar(64) NOT NULL,
252 `loaded_magazines` text NOT NULL,
253 `primary_weapon` varchar(64) NOT NULL,
254 `primary_weapon_items` text NOT NULL,
255 `secondary_weapon` varchar(64) NOT NULL,
256 `secondary_weapon_items` text NOT NULL,
257 `uniform` varchar(64) NOT NULL,
258 `uniform_items` text NOT NULL,
259 `uniform_magazines` text NOT NULL,
260 `uniform_weapons` text NOT NULL,
261 `vest` varchar(64) NOT NULL,
262 `vest_items` text NOT NULL,
263 `vest_magazines` text NOT NULL,
264 `vest_weapons` text NOT NULL,
265 `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
266 PRIMARY KEY (`id`),
267 KEY `player_uid` (`account_uid`),
268 CONSTRAINT `player_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE
269) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8;
270/*!40101 SET character_set_client = @saved_cs_client */;
271
272--
273-- Dumping data for table `player`
274--
275
276LOCK TABLES `player` WRITE;
277/*!40000 ALTER TABLE `player` DISABLE KEYS */;
278INSERT INTO `player` VALUES (3,'DDay','76561198221222644',0,0,100,100,0,37,0,1,0,'[[\"face_hub\",0],[\"neck\",0],[\"head\",0],[\"pelvis\",0],[\"spine1\",0],[\"spine2\",0],[\"spine3\",0],[\"body\",0],[\"arms\",0],[\"hands\",0],[\"legs\",0],[\"body\",0]]',259.000366211,10691.776367,3330.169678,0.00144005,'2018-08-23 00:43:24','[]','','[]','[]','[]','','','[\"\",\"\",\"\",\"\"]','','','','[]','','[\"\",\"\",\"\",\"\"]','','[\"\",\"\",\"\",\"\"]','Exile_Uniform_BambiOverall','[]','[]','[]','','[]','[]','[]','2018-08-23 00:46:23'),(4,'Sawyer','76561198833733672',0,0,100,100,0,36.931614,0,1,0,'[[\"face_hub\",0],[\"neck\",0],[\"head\",0],[\"pelvis\",0],[\"spine1\",0],[\"spine2\",0],[\"spine3\",0],[\"body\",0],[\"arms\",0],[\"hands\",0],[\"legs\",0],[\"body\",0]]',259.0371094,10663.0205078,3324.959229,1.13637,'2018-08-23 00:51:57','[\"ItemMap\",\"ItemCompass\",\"Exile_Item_XM8\",\"ItemRadio\"]','','[]','[]','[]','','G_Aviator','[\"\",\"\",\"\",\"\"]','hgun_Rook40_F','H_Cap_blk','','[[\"hgun_Rook40_F\",\"16Rnd_9x21_red_Mag\",16,\"hgun_Rook40_F\"]]','','[\"\",\"\",\"\",\"\"]','','[\"\",\"\",\"\",\"\"]','U_BG_Guerilla3_1','[]','[[\"16Rnd_9x21_red_Mag\",16],[\"16Rnd_9x21_red_Mag\",16],[\"16Rnd_9x21_red_Mag\",16],[\"Exile_Item_EMRE\",1],[\"Exile_Item_PlasticBottleFreshWater\",1],[\"Exile_Item_LightBulb\",1],[\"Chemlight_yellow\",1]]','[]','','[]','[]','[]','2018-08-23 00:53:51'),(17,'Given Help','76561198194280417',0,0.287402,70.702843,69.339783,0,37,0,1,0,'[[\"face_hub\",0.287402],[\"neck\",0.287402],[\"head\",0.287402],[\"pelvis\",0.287402],[\"spine1\",0.287402],[\"spine2\",0.287402],[\"spine3\",0.287402],[\"body\",0.287402],[\"arms\",0.287402],[\"hands\",0.287402],[\"legs\",0.287402],[\"body\",0.287402]]',29.633211,10722.480469,3316.539795,0.00144005,'2018-08-27 12:42:35','[\"ItemMap\",\"ItemCompass\",\"Exile_Item_XM8\",\"ItemRadio\"]','','[]','[]','[]','','G_Squares_Tinted','[\"\",\"\",\"\",\"\"]','hgun_Rook40_F','H_Cap_blk','','[[\"hgun_Rook40_F\",\"16Rnd_9x21_red_Mag\",16,\"hgun_Rook40_F\"]]','','[\"\",\"\",\"\",\"\"]','','[\"\",\"\",\"\",\"\"]','U_BG_Guerilla3_1','[]','[[\"Exile_Item_EMRE\",1],[\"Exile_Item_PlasticBottleFreshWater\",1],[\"Exile_Item_LightBulb\",1]]','[]','','[]','[]','[]','2018-08-27 13:24:09'),(21,'Cj Andersin','76561198054241421',0,0.00787402,38.753258,36.243568,0,36.993259,0,1,0,'[[\"face_hub\",0.00787402],[\"neck\",0.00787402],[\"head\",0.00787402],[\"pelvis\",0.00787402],[\"spine1\",0.00787402],[\"spine2\",0.00787402],[\"spine3\",0.00787402],[\"body\",0.00787402],[\"arms\",0.00787402],[\"hands\",0.00787402],[\"legs\",0.00787402],[\"body\",0.00787402]]',157.120514,1053.484253,171.955002,0.00146484,'2018-08-28 13:24:06','[\"ItemMap\",\"Exile_Item_XM8\",\"ItemGPS\",\"Rangefinder\"]','TRYK_B_Kitbag_Base','[]','[]','[]','','','[\"\",\"\",\"\",\"\"]','','rhsusf_opscore_fg_pelt_nsw','Rangefinder','[[\"SMA_M4afg_SM\",\"SMA_30Rnd_556x45_Mk262_IR\",30,\"SMA_M4afg_SM\"],[\"rhs_weap_xm2010_secondary\",\"rhsusf_5rnd_300winmag_xm2010_secondary\",3,\"rhs_weap_xm2010_secondary\"]]','SMA_M4afg_SM','[\"SMA_supp2b_556\",\"SMA_SFPEQ_M4TOP_BLK\",\"SMA_ELCAN_SPECTER_ARDRDS_4z\",\"\"]','rhs_weap_xm2010_secondary','[\"\",\"\",\"optic_lrps_tna_f_secondary\",\"bipod_01_f_blk_secondary\"]','U_BG_Guerrilla_6_1','[]','[[\"rhsusf_5Rnd_300winmag_xm2010\",5],[\"SMA_30Rnd_556x45_Mk262_IR\",30]]','[]','V_PlateCarrierIAGL_oli','[]','[[\"SMA_30Rnd_556x45_Mk262_IR\",30],[\"SMA_30Rnd_556x45_Mk262_IR\",30],[\"SMA_30Rnd_556x45_Mk262_IR\",30],[\"SMA_30Rnd_556x45_Mk262_IR\",30],[\"SMA_30Rnd_556x45_Mk262_IR\",30],[\"rhsusf_5Rnd_300winmag_xm2010\",5],[\"Land_Sign_WarningMilitaryArea_F_Kit\",1]]','[]','2018-08-28 15:50:15'),(66,'KyleGD','76561198093676226',1000450,0,99.996223,99.996086,0,37,0,1,0,'[[\"face_hub\",0],[\"neck\",0],[\"head\",0],[\"pelvis\",0],[\"spine1\",0],[\"spine2\",0],[\"spine3\",0],[\"body\",0],[\"arms\",0],[\"hands\",0],[\"legs\",0],[\"body\",0]]',5.245917,11012.0966797,14616.229492,0.000518799,'2018-08-30 23:46:30','[\"ItemMap\",\"ItemCompass\",\"Exile_Item_XM8\",\"ItemRadio\",\"ItemGPS\",\"Binocular\"]','','[]','[]','[]','hgun_PDW2000_F','','[\"\",\"\",\"\",\"\"]','hgun_Rook40_F','H_Cap_blk','Binocular','[[\"hgun_PDW2000_F\",\"30Rnd_9x21_Red_Mag\",30,\"hgun_PDW2000_F\"],[\"hgun_Rook40_F\",\"30Rnd_9x21_Red_Mag\",30,\"hgun_Rook40_F\"]]','hgun_PDW2000_F','[\"\",\"\",\"optic_Aco\",\"\"]','','[\"\",\"\",\"\",\"\"]','U_BG_Guerilla3_1','[]','[[\"16Rnd_9x21_red_Mag\",16],[\"16Rnd_9x21_red_Mag\",16],[\"16Rnd_9x21_red_Mag\",16],[\"Exile_Item_EMRE\",1],[\"Exile_Item_PlasticBottleFreshWater\",1],[\"Exile_Item_LightBulb\",1],[\"Chemlight_yellow\",1]]','[]','V_BandollierB_rgr','[]','[[\"30Rnd_9x21_Red_Mag\",30],[\"Exile_Item_CanOpener\",1],[\"Exile_Item_DogFood\",1],[\"Exile_Item_PlasticBottleFreshWater\",1],[\"Exile_Item_LightBulb\",1],[\"Exile_Item_Vishpirin\",1]]','[]','2018-08-30 23:52:24');
279/*!40000 ALTER TABLE `player` ENABLE KEYS */;
280UNLOCK TABLES;
281
282--
283-- Table structure for table `player_history`
284--
285
286DROP TABLE IF EXISTS `player_history`;
287/*!40101 SET @saved_cs_client = @@character_set_client */;
288/*!40101 SET character_set_client = utf8 */;
289CREATE TABLE `player_history` (
290 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
291 `account_uid` varchar(32) NOT NULL,
292 `name` varchar(64) NOT NULL,
293 `died_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
294 `position_x` double NOT NULL,
295 `position_y` double NOT NULL,
296 `position_z` double NOT NULL,
297 PRIMARY KEY (`id`)
298) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8;
299/*!40101 SET character_set_client = @saved_cs_client */;
300
301--
302-- Dumping data for table `player_history`
303--
304
305LOCK TABLES `player_history` WRITE;
306/*!40000 ALTER TABLE `player_history` DISABLE KEYS */;
307INSERT INTO `player_history` VALUES (1,'76561198105238009','Scott Manly','2018-08-23 00:51:26',10070,7209.12,17.2565),(2,'76561198093676226','KyleGD','2018-08-23 13:29:06',9636.33,1845.55,2.28041),(3,'76561198093676226','KyleGD','2018-08-24 17:59:48',16287.8,3617.07,0.210587),(4,'76561198093676226','KyleGD','2018-08-24 18:42:34',8945.99,11397.3,0.00144958),(5,'76561198093676226','KyleGD','2018-08-24 19:17:16',5202.44,10290.9,0.00143433),(6,'76561198093676226','KyleGD','2018-08-24 20:29:58',2148.54,1953.29,0.00198364),(7,'76561198093676226','KyleGD','2018-08-25 01:47:00',2774.13,16153.4,0.00128174),(8,'76561198093676226','KyleGD','2018-08-25 15:32:22',14519.6,7718.54,0.778206),(9,'76561198093676226','KyleGD','2018-08-25 20:19:53',13486.3,7374.88,29.1215),(10,'76561198093676226','KyleGD','2018-08-26 15:27:04',3979.04,5732.59,0.00146484),(11,'76561198093676226','KyleGD','2018-08-26 16:04:53',10943.3,6645.6,93.5329),(12,'76561198093676226','KyleGD','2018-08-26 16:05:04',10920.2,6509.81,0.756454),(13,'76561198054241421','Cj Andersin','2018-08-27 13:09:49',10018.2,3742.56,1.49816),(14,'76561198054241421','Cj Andersin','2018-08-27 13:48:55',7049.86,2199.85,1.92194),(15,'76561198054241421','Cj Andersin','2018-08-28 13:23:57',6540.97,16373.2,0.00274658),(16,'76561198093676226','KyleGD','2018-08-28 13:25:51',8055.91,16135.1,123.589),(17,'76561198093676226','KyleGD','2018-08-28 13:28:48',13297.8,13907.8,0.00152588),(18,'76561198054241421','Cj Andersin','2018-08-28 13:33:36',13308.4,13868.8,0.000579834),(19,'76561198054241421','Cj Andersin','2018-08-28 13:34:22',13300.5,13868.2,0.00115967),(20,'76561198054241421','Cj Andersin','2018-08-28 13:34:54',13299.4,13872,0.00088501),(21,'76561198054241421','Cj Andersin','2018-08-28 13:35:12',13299.2,13871.1,0.000640869),(22,'76561198054241421','Cj Andersin','2018-08-28 13:35:41',13306.6,13873,-0.00100708),(23,'76561198054241421','Cj Andersin','2018-08-28 13:38:40',13307.4,13873,0.00143433),(24,'76561198054241421','Cj Andersin','2018-08-28 13:42:06',13299.7,13866.7,0.00143433),(25,'76561198093676226','KyleGD','2018-08-28 13:44:02',13505.7,12883.2,0.000610352),(26,'76561198054241421','Cj Andersin','2018-08-28 13:51:00',13305.8,13867.7,0.0192871),(27,'76561198350862554','Dreyfus','2018-08-28 14:37:18',14007.6,3308.82,0.00181961),(28,'76561198350862554','Dreyfus','2018-08-28 15:03:25',13615.7,17538.8,0.00143433),(29,'76561198350862554','Dreyfus','2018-08-28 16:22:15',7631.5,2417.24,0.00140381),(30,'76561198105238009','Scott Manly','2018-08-28 17:00:22',10994.8,4395.74,131.721),(31,'76561198105238009','Scott Manly','2018-08-28 17:08:39',15622.3,14695,1.44879),(32,'76561198093676226','KyleGD','2018-08-28 17:48:26',11124.6,14824.8,3.35651),(33,'76561198093676226','KyleGD','2018-08-28 20:41:19',5641.52,13870.8,-0.000305176),(34,'76561198093676226','KyleGD','2018-08-28 20:45:02',6127.89,13462.9,7.83835),(35,'76561198093676226','KyleGD','2018-08-29 13:02:09',8906.55,10974.9,0.00144958),(36,'76561198093676226','KyleGD','2018-08-29 14:42:54',11390.9,6949.21,2.57194),(37,'76561198093676226','KyleGD','2018-08-29 15:06:02',11405.8,6623.05,0.00143623),(38,'76561198093676226','KyleGD','2018-08-29 16:27:19',16850.4,13100.4,0.933746),(39,'76561198093676226','KyleGD','2018-08-29 22:12:44',14254.8,18600,5.35284),(40,'76561198068674681','Austin','2018-08-29 22:27:27',16456,3692.73,0.00136948),(41,'76561198068674681','Austin','2018-08-29 22:46:29',956.402,8131.75,274.19),(42,'76561198068674681','Austin','2018-08-29 22:46:41',1006.01,8475.14,0.00256348),(43,'76561198068674681','Austin','2018-08-29 22:50:49',16922.5,-318.336,15.1548),(44,'76561198068674681','Austin','2018-08-29 22:55:35',10650.9,3428.09,3.73069),(45,'76561198068674681','Austin','2018-08-29 22:58:23',10632.1,3274.35,0.00143433),(46,'76561198093676226','KyleGD','2018-08-29 23:00:50',10483.5,3185.64,1.71208),(47,'76561198093676226','KyleGD','2018-08-29 23:04:53',10699.9,3286.41,1.84249),(48,'76561198093676226','KyleGD','2018-08-29 23:14:36',10394.1,3417.35,0.720652),(49,'76561198093676226','KyleGD','2018-08-29 23:30:44',10388.3,3024.65,-0.775328),(50,'76561198068674681','Austin','2018-08-29 23:35:05',10815.1,3104.98,0.00144386),(51,'76561198068674681','Austin','2018-08-29 23:36:32',10794.9,3107.73,0.00141525),(52,'76561198093676226','KyleGD','2018-08-29 23:37:08',10801.4,3097.86,0.650026),(53,'76561198068674681','Austin','2018-08-29 23:37:40',10792.9,3112.32,0.00143433),(54,'76561198093676226','KyleGD','2018-08-29 23:38:33',10767.1,3121.24,1.43247),(55,'76561198093676226','KyleGD','2018-08-30 18:41:10',13824.6,5665.09,0.00245667),(56,'76561198093676226','KyleGD','2018-08-30 20:10:38',16372.2,3565.57,0.00196838),(57,'76561198093676226','KyleGD','2018-08-30 23:40:37',3995.47,5731.95,0.00146484),(58,'76561198093676226','KyleGD','2018-08-30 23:41:13',5350.25,18453.6,0.00268555),(59,'76561198093676226','KyleGD','2018-08-30 23:44:26',17902.5,7879.11,0.000198364),(60,'76561198093676226','KyleGD','2018-08-30 23:45:37',18086.5,7749.34,0.00148392),(61,'76561198093676226','KyleGD','2018-08-30 23:46:21',17906.8,7923.93,0.00197983);
308/*!40000 ALTER TABLE `player_history` ENABLE KEYS */;
309UNLOCK TABLES;
310
311--
312-- Table structure for table `territory`
313--
314
315DROP TABLE IF EXISTS `territory`;
316/*!40101 SET @saved_cs_client = @@character_set_client */;
317/*!40101 SET character_set_client = utf8 */;
318CREATE TABLE `territory` (
319 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
320 `owner_uid` varchar(32) NOT NULL,
321 `name` varchar(64) NOT NULL,
322 `position_x` double NOT NULL,
323 `position_y` double NOT NULL,
324 `position_z` double NOT NULL,
325 `radius` double NOT NULL,
326 `level` int(11) NOT NULL,
327 `flag_texture` varchar(255) NOT NULL,
328 `flag_stolen` tinyint(1) NOT NULL DEFAULT '0',
329 `flag_stolen_by_uid` varchar(32) DEFAULT NULL,
330 `flag_stolen_at` datetime DEFAULT NULL,
331 `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
332 `last_paid_at` datetime DEFAULT CURRENT_TIMESTAMP,
333 `xm8_protectionmoney_notified` tinyint(1) NOT NULL DEFAULT '0',
334 `build_rights` varchar(640) NOT NULL DEFAULT '0',
335 `moderators` varchar(320) NOT NULL DEFAULT '0',
336 `deleted_at` datetime DEFAULT NULL,
337 PRIMARY KEY (`id`),
338 KEY `owner_uid` (`owner_uid`),
339 KEY `flag_stolen_by_uid` (`flag_stolen_by_uid`),
340 CONSTRAINT `territory_ibfk_1` FOREIGN KEY (`owner_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
341 CONSTRAINT `territory_ibfk_2` FOREIGN KEY (`flag_stolen_by_uid`) REFERENCES `account` (`uid`) ON DELETE SET NULL
342) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
343/*!40101 SET character_set_client = @saved_cs_client */;
344
345--
346-- Dumping data for table `territory`
347--
348
349LOCK TABLES `territory` WRITE;
350/*!40000 ALTER TABLE `territory` DISABLE KEYS */;
351INSERT INTO `territory` VALUES (1,'76561198093676226','test',3994.324707,5735.78125,-0.317505,15,1,'\\A3\\Data_F\\Flags\\flag_us_co.paa',0,NULL,NULL,'2018-08-26 14:49:07','2018-08-26 14:49:07',0,'[\"76561198093676226\"]','[\"76561198093676226\"]',NULL),(2,'76561198054241421','Outpost Zulu',1051.424805,166.928253,0.0360641,15,1,'\\A3\\Data_F\\Flags\\flag_us_co.paa',0,NULL,NULL,'2018-08-28 15:30:33','2018-08-28 15:30:33',0,'[\"76561198054241421\"]','[\"76561198054241421\"]',NULL),(3,'76561198350862554','U.N. Post Echo',7639.0727539,2416.286621,-0.375885,15,1,'\\A3\\Data_F\\Flags\\flag_us_co.paa',0,NULL,NULL,'2018-08-28 16:21:50','2018-08-28 16:21:50',0,'[\"76561198350862554\"]','[\"76561198350862554\"]',NULL);
352/*!40000 ALTER TABLE `territory` ENABLE KEYS */;
353UNLOCK TABLES;
354
355--
356-- Table structure for table `vehicle`
357--
358
359DROP TABLE IF EXISTS `vehicle`;
360/*!40101 SET @saved_cs_client = @@character_set_client */;
361/*!40101 SET character_set_client = utf8 */;
362CREATE TABLE `vehicle` (
363 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
364 `class` varchar(64) NOT NULL,
365 `spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
366 `account_uid` varchar(32) DEFAULT NULL,
367 `is_locked` tinyint(1) NOT NULL DEFAULT '0',
368 `fuel` double unsigned NOT NULL DEFAULT '0',
369 `damage` double unsigned NOT NULL DEFAULT '0',
370 `hitpoints` text NOT NULL,
371 `position_x` double NOT NULL DEFAULT '0',
372 `position_y` double NOT NULL DEFAULT '0',
373 `position_z` double NOT NULL DEFAULT '0',
374 `direction_x` double NOT NULL DEFAULT '0',
375 `direction_y` double NOT NULL DEFAULT '0',
376 `direction_z` double NOT NULL DEFAULT '0',
377 `up_x` double NOT NULL DEFAULT '0',
378 `up_y` double NOT NULL DEFAULT '0',
379 `up_z` double NOT NULL DEFAULT '1',
380 `cargo_items` text NOT NULL,
381 `cargo_magazines` text NOT NULL,
382 `cargo_weapons` text NOT NULL,
383 `cargo_container` text NOT NULL,
384 `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
385 `pin_code` varchar(6) NOT NULL DEFAULT '000000',
386 `deleted_at` datetime DEFAULT NULL,
387 `money` int(11) unsigned NOT NULL DEFAULT '0',
388 `vehicle_texture` text NOT NULL,
389 `territory_id` int(11) unsigned DEFAULT NULL,
390 `nickname` varchar(64) NOT NULL DEFAULT '',
391 PRIMARY KEY (`id`),
392 KEY `account_uid` (`account_uid`),
393 KEY `vehicle_ibfk_2_idx` (`territory_id`),
394 CONSTRAINT `vehicle_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
395 CONSTRAINT `vehicle_ibfk_2` FOREIGN KEY (`territory_id`) REFERENCES `territory` (`id`) ON DELETE CASCADE
396) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
397/*!40101 SET character_set_client = @saved_cs_client */;
398
399--
400-- Dumping data for table `vehicle`
401--
402
403LOCK TABLES `vehicle` WRITE;
404/*!40000 ALTER TABLE `vehicle` DISABLE KEYS */;
405INSERT INTO `vehicle` VALUES (4,'Exile_Car_BRDM2_HQ','2018-08-26 15:27:23','76561198093676226',0,0.999929,0,'[[\"hitlfwheel\",0],[\"hitlf2wheel\",0],[\"hitrfwheel\",0],[\"hitrf2wheel\",0],[\"hitfuel\",0],[\"hitengine\",0],[\"hitbody\",0],[\"hitrglass\",0],[\"hitlglass\",0],[\"hitglass1\",0],[\"hitglass2\",0],[\"hitglass3\",0],[\"hitglass4\",0],[\"hitglass5\",0],[\"hitlbwheel\",0],[\"hitlmwheel\",0],[\"hitrbwheel\",0],[\"hitrmwheel\",0],[\"hitglass6\",0],[\"hithull\",0],[\"hitglass7\",0],[\"hitglass8\",0],[\"hitturret\",0],[\"hitgun\",0],[\"#light_l\",0],[\"#light_r\",0]]',3990.764893,5733.143066,-0.000610352,0.379761,-0.921446,0.0819702,-0.039044,0.0725643,0.996599,'[[],[]]','[]','[]','[]','2018-08-30 23:36:57','2462',NULL,0,'',1,'BRDM-2 (HQ) 520'),(8,'rhsusf_M1220_M153_M2_usarmy_d','2018-08-27 13:32:18','76561198054241421',0,0.901256,0,'[[\"hithull\",0],[\"hitfuel\",0],[\"hitengine\",0.153543],[\"hitduke1\",0],[\"hitduke2\",0],[\"hitbody\",0.295276],[\"hitlfwheel\",0],[\"hitlbwheel\",0],[\"hitlmwheel\",0],[\"hitlf2wheel\",0],[\"hitrfwheel\",0],[\"hitrbwheel\",0],[\"hitrmwheel\",0],[\"hitrf2wheel\",0],[\"hitglass1\",0.0984252],[\"hitglass2\",0],[\"hitglass3\",0],[\"hitglass4\",0],[\"hitrglass\",0],[\"hitlglass\",0],[\"hitglass5\",0],[\"hitglass6\",0],[\"hitglass7\",0],[\"hitglass8\",0],[\"hitturret\",0],[\"hitgun\",0],[\"#light_l\",0.901575],[\"#light_l\",0.901575],[\"#light_r\",0.0472441],[\"#light_r\",0.0472441],[\"#light_l\",0.901575],[\"#light_r\",0.0472441],[\"#light_r\",0.0472441],[\"#light_l\",0.901575],[\"#cabin_light1\",0],[\"#cabin_light2\",0],[\"#cabin_light3\",0]]',7047.807129,2200.220215,0.282257,-0.864014,-0.490936,0.111633,-0.0730183,0.341574,0.937014,'[[],[]]','[]','[]','[]','2018-08-30 14:51:10','4142','2018-08-30 14:51:10',0,'',NULL,''),(12,'RHS_UH60M_MEV','2018-08-28 15:09:56','76561198054241421',-1,0.932913,0,'[[\"hithull\",0],[\"hitengine1\",0],[\"hitengine2\",0],[\"hitengine\",0],[\"hitvrotor\",0],[\"hithrotor\",0],[\"hitwinch\",0],[\"hitglass7\",0],[\"hithydraulics\",0],[\"hittransmission\",0],[\"hittail\",0],[\"hithstabilizerl1\",0],[\"hithstabilizerr1\",0],[\"hitpylon1\",0],[\"hitpylon2\",0],[\"hitpylon3\",0],[\"hitpylon4\",0],[\"hitfuel\",0],[\"hitavionics\",0],[\"hitmissiles\",0],[\"hitglass1\",0],[\"hitglass2\",0],[\"hitglass3\",0],[\"hitglass4\",0],[\"hitglass5\",0],[\"hitglass6\",0],[\"hitglass8\",0],[\"hitglass9\",0],[\"hitglass10\",0],[\"hitglass11\",0],[\"hitglass12\",0],[\"hitglass13\",0],[\"hitglass14\",0],[\"hitrglass\",0],[\"hitlglass\",0],[\"hitengine3\",0],[\"hitlight\",0],[\"hitgear\",0],[\"hitvstabilizer1\",0],[\"hitpitottube\",0],[\"hitstaticport\",0],[\"hitstarter1\",0],[\"hitstarter2\",0],[\"hitstarter3\",0],[\"#p svetlo\",0],[\"#l svetlo\",0],[\"#cabin_light\",0],[\"#cargo_light_1\",0],[\"#cargo_light_2\",0]]',1034.288086,159.0563354,-0.0822754,0.683105,-0.730307,-0.00439453,-0.00394648,-0.00970847,0.999945,'[[],[]]','[]','[]','[[\"B_Bergen_hex_F\",[],[],[[],[]]]]','2018-08-28 15:49:40','4142',NULL,0,'',NULL,''),(15,'CUP_B_M1126_ICV_M2_Desert','2018-08-28 16:00:43','76561198350862554',-1,0.990856,0,'[[\"hitlfwheel\",1],[\"hitlbwheel\",0.0551181],[\"hitlmwheel\",0.177165],[\"hitlf2wheel\",0.700787],[\"hitrfwheel\",1],[\"hitrbwheel\",0.0748032],[\"hitrmwheel\",0.291339],[\"hitrf2wheel\",0.992126],[\"hitfuel\",0],[\"hitengine\",0],[\"hithull\",0],[\"hitrglass\",0],[\"hitlglass\",0],[\"hitglass1\",0],[\"hitglass2\",0],[\"hitglass3\",0],[\"hitglass4\",0],[\"hitglass5\",0],[\"hitbody\",0],[\"hitglass6\",0],[\"hitglass7\",0],[\"hitglass8\",0],[\"hitturret\",0],[\"hitgun\",0],[\"hitturret\",0],[\"hitgun\",0],[\"#l svetlo\",0.188976],[\"#p svetlo\",0.188976]]',7628.38623,2422.529541,-0.0825653,0.792175,-0.599572,-0.113892,0.0768761,-0.0870972,0.993229,'[[],[]]','[[\"Land_Sign_WarningMilitaryArea_F_Kit\",1],[\"Land_Mil_WallBig_4m_F_Kit\",1],[\"Land_Bunker_F_Kit\",1],[\"Land_Mil_WallBig_4m_F_Kit\",1],[\"Land_HBarrierTower_F_Kit\",1],[\"Exile_Item_Codelock\",1],[\"Exile_Item_ConcreteDrawBridgeKit\",1]]','[]','[]','2018-08-28 16:22:23','3332',NULL,0,'',NULL,''),(26,'Exile_Car_Ural_Covered_Yellow','2018-08-30 18:16:12','DMS_PersistentVehicle',0,0.860829,0,'[[\"hitlfwheel\",0],[\"hitlf2wheel\",0],[\"hitrfwheel\",0],[\"hitrf2wheel\",0],[\"hitfuel\",0],[\"hitengine\",0],[\"hitbody\",0],[\"hitglass1\",0],[\"hitglass2\",0],[\"hitglass3\",0],[\"hitglass4\",0],[\"hitrglass\",0],[\"hitlglass\",0],[\"hitglass5\",0],[\"hitlbwheel\",0],[\"hitlmwheel\",0],[\"hitrbwheel\",0],[\"hitrmwheel\",0],[\"hitglass6\",0],[\"hithull\",0],[\"hitglass7\",0],[\"hitglass8\",0],[\"#l svetlo\",0],[\"#p svetlo\",0]]',6268.67334,6924.654297,0.435333,0.131403,-0.897867,-0.420201,0,-0.423876,0.90572,'[[],[]]','[]','[]','[]','2018-08-30 18:16:12','7886',NULL,0,'',NULL,'');
406/*!40000 ALTER TABLE `vehicle` ENABLE KEYS */;
407UNLOCK TABLES;
408
409--
410-- Dumping routines for database 'exile'
411--
412/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
413
414/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
415/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
416/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
417/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
418/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
419/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
420/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
421
422-- Dump completed on 2018-08-31 0:00:00