· 9 years ago · Sep 29, 2016, 09:14 PM
1-- phpMyAdmin SQL Dump
2-- version 4.4.15.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Sep 15, 2016 at 04:00 PM
7-- Server version: 5.6.28
8-- PHP Version: 5.4.16
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Database: `db10302`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `account`
27--
28-- Creation: Jul 16, 2016 at 08:48 PM
29--
30
31CREATE TABLE IF NOT EXISTS `account` (
32 `uid` varchar(32) NOT NULL,
33 `clan_id` int(11) unsigned DEFAULT NULL,
34 `name` varchar(64) NOT NULL,
35 `score` int(11) NOT NULL DEFAULT '0',
36 `kills` int(11) unsigned NOT NULL DEFAULT '0',
37 `deaths` int(11) unsigned NOT NULL DEFAULT '0',
38 `locker` int(11) NOT NULL DEFAULT '0',
39 `first_connect_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
40 `last_connect_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
41 `last_disconnect_at` datetime DEFAULT NULL,
42 `total_connections` int(11) unsigned NOT NULL DEFAULT '1'
43) ENGINE=InnoDB DEFAULT CHARSET=utf8;
44
45--
46-- Dumping data for table `account`
47--
48
49INSERT INTO `account` (`uid`, `clan_id`, `name`, `score`, `kills`, `deaths`, `locker`, `first_connect_at`, `last_connect_at`, `last_disconnect_at`, `total_connections`) VALUES
50('76561197965179026', NULL, 'Kris', 54780, 215, 50, 50344, '2016-07-27 15:36:57', '2016-08-07 19:27:40', '2016-08-07 19:26:10', 35),
51('76561197965620708', 2, 'Ray', 269523, 1314, 73, 766302, '2016-07-26 19:39:40', '2016-09-14 20:33:18', '2016-09-13 22:35:12', 84),
52('76561197966389434', NULL, 'radicalSchmalle', 0, 0, 1, 0, '2016-07-30 12:29:48', '2016-07-30 12:29:48', '2016-07-31 02:55:51', 1),
53('76561197966515186', 7, 'biwix', 68872, 200, 62, 62889, '2016-08-01 15:41:29', '2016-09-04 09:21:13', '2016-09-04 09:22:13', 63),
54('76561197966815563', NULL, 'Limitless', 8113, 24, 15, 45738, '2016-07-29 20:37:23', '2016-08-02 20:30:34', '2016-08-02 21:30:00', 6),
55('76561197967872698', NULL, 'The Good Man John Farson', 0, 0, 0, 0, '2016-09-03 07:53:54', '2016-09-04 01:33:21', '2016-09-04 01:34:56', 3),
56('76561197967971215', NULL, 'Logan', 748, 3, 1, 0, '2016-09-11 08:21:02', '2016-09-11 09:30:30', '2016-09-11 10:27:55', 3),
57('76561197969049427', NULL, 'DerKB', 89, 0, 0, 125, '2016-08-01 11:55:22', '2016-08-01 11:55:22', '2016-08-01 12:52:05', 1),
58('76561197970645537', NULL, 'boelimaa', 170, 1, 3, 0, '2016-07-30 15:14:17', '2016-08-01 18:11:40', '2016-08-01 18:49:35', 6),
59('76561197970955433', 2, 'The Unknown', 556459, 2358, 119, 369671, '2016-07-25 19:49:28', '2016-09-14 20:21:30', '2016-09-14 17:01:44', 212),
60
61('76561198209258001', 6, 'Abynormal', 88232, 90, 23, 200000, '2016-07-28 15:00:08', '2016-09-03 16:58:47', '2016-09-03 19:03:53', 25),
62('76561198235342276', NULL, 'Thomas R.', 0, 0, 0, 0, '2016-07-28 02:52:44', '2016-07-28 02:52:44', '2016-07-28 02:52:55', 1),
63('76561198241395172', NULL, 'Bush', 62, 0, 2, 625, '2016-08-03 11:16:00', '2016-08-03 11:16:00', NULL, 1),
64('76561198252722784', NULL, 'Nickel77', 887, 0, 1, 8305, '2016-07-28 09:12:08', '2016-07-28 09:12:08', '2016-07-28 09:49:25', 1),
65('76561198260138634', NULL, 'Just Mike', 258, 0, 0, 0, '2016-07-30 18:02:18', '2016-07-30 18:02:18', '2016-07-30 18:40:08', 1),
66('DMS_PersistentVehicle', NULL, 'DMS_PersistentVehicle', 0, 0, 0, 0, '2016-07-25 19:28:32', '2016-07-25 19:28:32', NULL, 1);
67
68-- --------------------------------------------------------
69
70--
71-- Table structure for table `clan`
72--
73-- Creation: Jul 16, 2016 at 08:48 PM
74--
75
76CREATE TABLE IF NOT EXISTS `clan` (
77 `id` int(11) unsigned NOT NULL,
78 `name` varchar(64) NOT NULL,
79 `leader_uid` varchar(32) NOT NULL,
80 `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
81) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
82
83--
84-- Dumping data for table `clan`
85--
86
87INSERT INTO `clan` (`id`, `name`, `leader_uid`, `created_at`) VALUES
88(2, 'The WolfPack', '76561197970955433', '2016-07-27 17:24:41'),
89(3, 'CLK', '76561198011379806', '2016-07-27 20:01:27'),
90(4, 'RRTS', '76561198130739840', '2016-07-30 17:04:44'),
91(5, 'BLACKWATER', '76561198111733278', '2016-07-31 04:32:02'),
92(6, 'Battle Eye', '76561198209258001', '2016-08-03 07:53:05'),
93(7, 'justetamour', '76561197966515186', '2016-08-28 17:14:29');
94
95-- --------------------------------------------------------
96
97--
98-- Table structure for table `clan_map_marker`
99--
100-- Creation: Jul 16, 2016 at 08:48 PM
101--
102
103CREATE TABLE IF NOT EXISTS `clan_map_marker` (
104 `id` int(11) unsigned NOT NULL,
105 `clan_id` int(11) unsigned NOT NULL,
106 `markerType` tinyint(4) NOT NULL DEFAULT '-1',
107 `positionArr` text NOT NULL,
108 `color` varchar(255) NOT NULL,
109 `icon` varchar(255) NOT NULL,
110 `iconSize` float unsigned NOT NULL,
111 `label` varchar(255) NOT NULL,
112 `labelSize` float unsigned NOT NULL
113) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
114
115--
116-- Dumping data for table `clan_map_marker`
117--
118
119INSERT INTO `clan_map_marker` (`id`, `clan_id`, `markerType`, `positionArr`, `color`, `icon`, `iconSize`, `label`, `labelSize`) VALUES
120(15, 4, 0, '[9587.11,9107.07]', '[0.866667,0.14902,0.14902,1]', 'a3\\ui_f\\data\\map\\markers\\military\\flag_ca.paa', 30, 'RRTS Base', 0.139643),
121(25, 2, 0, '[11446,6258.93]', '[0.435294,0.443137,0.478431,1]', 'a3\\ui_f\\data\\map\\markers\\military\\marker_ca.paa', 21.6809, 'Stonehenge', 0.0805905),
122(26, 2, 0, '[11447.3,6255.51]', '[1,0.705882,0.0941177,1]', 'a3\\ui_f\\data\\map\\markers\\military\\arrow2_ca.paa', 21.6809, 'Stonehenge', 0.0805905),
123(28, 2, 0, '[9628.06,9173.76]', '[1,1,1,1]', 'a3\\ui_f\\data\\map\\markers\\flags\\usa_ca.paa', 20, 'The Rock', 0.123326),
124(33, 2, 0, '[6428.97,7738.44]', '[0.866667,0.14902,0.14902,1]', 'a3\\ui_f\\data\\igui\\cfg\\islandmap\\iconplayer_ca.paa', 26.0839, 'Wolves Den', 0.152852),
125(34, 2, 0, '[10845.6,14566.7]', '[0.435294,0.443137,0.478431,1]', 'a3\\ui_f\\data\\map\\markers\\military\\unknown_ca.paa', 50, 'Unknown Cave', 0.14042);
126
127-- --------------------------------------------------------
128
129--
130-- Table structure for table `construction`
131--
132-- Creation: Jul 16, 2016 at 08:48 PM
133--
134
135CREATE TABLE IF NOT EXISTS `construction` (
136 `id` int(11) unsigned NOT NULL,
137 `class` varchar(64) NOT NULL,
138 `account_uid` varchar(32) NOT NULL,
139 `spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
140 `position_x` double NOT NULL DEFAULT '0',
141 `position_y` double NOT NULL DEFAULT '0',
142 `position_z` double NOT NULL DEFAULT '0',
143 `direction_x` double NOT NULL DEFAULT '0',
144 `direction_y` double NOT NULL DEFAULT '0',
145 `direction_z` double NOT NULL DEFAULT '0',
146 `up_x` double NOT NULL DEFAULT '0',
147 `up_y` double NOT NULL DEFAULT '0',
148 `up_z` double NOT NULL DEFAULT '0',
149 `is_locked` tinyint(1) NOT NULL DEFAULT '0',
150 `pin_code` varchar(6) NOT NULL DEFAULT '000000',
151 `damage` tinyint(1) unsigned DEFAULT '0',
152 `territory_id` int(11) unsigned DEFAULT NULL,
153 `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
154 `deleted_at` datetime DEFAULT NULL
155) ENGINE=InnoDB AUTO_INCREMENT=8448 DEFAULT CHARSET=utf8;
156
157--
158-- Dumping data for table `construction`
159--
160
161INSERT INTO `construction` (`id`, `class`, `account_uid`, `spawned_at`, `position_x`, `position_y`, `position_z`, `direction_x`, `direction_y`, `direction_z`, `up_x`, `up_y`, `up_z`, `is_locked`, `pin_code`, `damage`, `territory_id`, `last_updated_at`, `deleted_at`) VALUES
162(70, 'Exile_Construction_CampFire_Static', '76561198033728628', '2016-07-26 17:53:11', 7631.168945, 12790.305664, 0.249237, 0.578585, 0.815622, 0, 0, 0, 1, 0, '000000', 0, NULL, '2016-09-11 15:03:52', NULL),
163(77, 'Land_CampingTable_F', '76561198061132496', '2016-07-26 20:46:19', 9565.242188, 9113.84082, -0.197235, -0.187723, 0.982222, 0, 0, 0, 1, 0, '000000', 0, 6, '2016-07-26 20:46:19', NULL),
164(79, 'Exile_Construction_CampFire_Static', '76561198079735673', '2016-07-26 21:01:15', 9426.722656, 7575.568359, 0.273273, 0.588482, -0.80851, 0, 0, 0, 1, 0, '000000', 0, NULL, '2016-09-11 15:03:52', NULL),
165(80, 'Exile_Construction_WorkBench_Static', '76561198079735673', '2016-07-26 21:03:28', 9430.417969, 7575.360352, 0.24749, 0.0696808, -0.997569, 0, 0, 0, 1, 0, '000000', 0, NULL, '2016-09-11 15:03:52', NULL),
166(87, 'Exile_Construction_WorkBench_Static', '76561197970955433', '2016-07-27 13:36:55', 11607.927734, 14375.814453, -0.400744, -0.480229, -0.877143, 0, 0, 0, 1, 0, '000000', 0, NULL, '2016-09-12 09:04:03', NULL),
167
168(8446, 'Exile_Construction_WoodFloor_Static', '76561197978284888', '2016-09-14 10:54:05', 6272.720703, 12942.563477, 9.342651, -0.850525, -0.525935, 0, 0, 0, 1, 0, '000000', 0, 45, '2016-09-14 10:54:05', NULL),
169(8447, 'Exile_Construction_WoodFloor_Static', '76561197978284888', '2016-09-14 10:54:16', 6267.617676, 12939.408203, 9.517041, -0.850525, -0.525935, 0, 0, 0, 1, 0, '000000', 0, 45, '2016-09-14 10:54:16', NULL);
170
171-- --------------------------------------------------------
172
173--
174-- Table structure for table `container`
175--
176-- Creation: Jul 16, 2016 at 08:48 PM
177--
178
179CREATE TABLE IF NOT EXISTS `container` (
180 `id` int(11) unsigned NOT NULL,
181 `class` varchar(64) NOT NULL,
182 `spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
183 `account_uid` varchar(32) DEFAULT NULL,
184 `is_locked` tinyint(1) NOT NULL DEFAULT '0',
185 `position_x` double NOT NULL DEFAULT '0',
186 `position_y` double NOT NULL DEFAULT '0',
187 `position_z` double NOT NULL DEFAULT '0',
188 `direction_x` double NOT NULL DEFAULT '0',
189 `direction_y` double NOT NULL DEFAULT '0',
190 `direction_z` double NOT NULL DEFAULT '0',
191 `up_x` double NOT NULL DEFAULT '0',
192 `up_y` double NOT NULL DEFAULT '0',
193 `up_z` double NOT NULL DEFAULT '1',
194 `cargo_items` text NOT NULL,
195 `cargo_magazines` text NOT NULL,
196 `cargo_weapons` text NOT NULL,
197 `cargo_container` text NOT NULL,
198 `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
199 `pin_code` varchar(6) NOT NULL DEFAULT '000000',
200 `territory_id` int(11) unsigned DEFAULT NULL,
201 `deleted_at` datetime DEFAULT NULL,
202 `money` int(11) unsigned NOT NULL DEFAULT '0',
203 `abandoned` datetime DEFAULT NULL
204) ENGINE=InnoDB AUTO_INCREMENT=325 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
205
206--
207-- Dumping data for table `container`
208--
209
210INSERT INTO `container` (`id`, `class`, `spawned_at`, `account_uid`, `is_locked`, `position_x`, `position_y`, `position_z`, `direction_x`, `direction_y`, `direction_z`, `up_x`, `up_y`, `up_z`, `cargo_items`, `cargo_magazines`, `cargo_weapons`, `cargo_container`, `last_updated_at`, `pin_code`, `territory_id`, `deleted_at`, `money`, `abandoned`) VALUES
211(13, 'Exile_Container_Storagecrate', '2016-07-26 20:41:22', '76561198061132496', -1, 9588.624023, 9097.787109, 0.918976, -0.138318, -0.990388, 0, 0, 0, 1, '[[],[]]', '[["30Rnd_762x39_Mag_F",30],["30Rnd_762x39_Mag_F",30],["Land_TableDesk_F_Kit",1]]', '[["arifle_AK12_F","","","",["30Rnd_762x39_Mag_F",30],""],["Exile_Melee_Axe","","","",[],""],["SMG_05_F","","","",[],""],["arifle_AKM_F","","","",[],""]]', '[]', '2016-08-04 19:25:34', '0000', 6, NULL, 0, NULL),
212(44, 'Exile_Container_CamoTent', '2016-07-29 06:05:37', '76561198033728628', -1, 7634.921875, 12797.697266, 0.128571, 0.984809, 0.173644, 0, 0, 0, 1, '[["optic_Holosight_blk_F","optic_Holosight_smg_blk_F","optic_ACO_grn_smg"],[1,1,1]]', ["Exile_Item_SausageGravy_Cooked",1],["Exile_Item_CampFireKit",1],["rhs_30Rnd_545x39_7N22_AK",30],["rhs_30Rnd_545x39_AK_no_tracers",30]]', '[["launch_NLAW_F","","","",["NLAW_F",1],""],["hlc_rifle_samr2","","","",[],""]]', '[["U_B_T_Sniper_F",[],[],[[],[]]],["B_Bergen_tna_F",[],[],[[],[]]]]', '2016-09-13 17:10:56', '6447', 52, NULL, 0, NULL);
213
214-- --------------------------------------------------------
215
216--
217-- Table structure for table `marxet`
218--
219-- Creation: Jul 17, 2016 at 11:14 PM
220--
221
222CREATE TABLE IF NOT EXISTS `marxet` (
223 `listingID` varchar(8) NOT NULL,
224 `itemAvailable` tinyint(1) NOT NULL DEFAULT '1',
225 `itemArray` text NOT NULL,
226 `price` double NOT NULL,
227 `sellerUID` varchar(64) NOT NULL
228) ENGINE=InnoDB DEFAULT CHARSET=utf8;
229
230-- --------------------------------------------------------
231
232--
233-- Table structure for table `player`
234--
235-- Creation: Jul 16, 2016 at 08:48 PM
236--
237
238CREATE TABLE IF NOT EXISTS `player` (
239 `id` int(11) unsigned NOT NULL,
240 `name` varchar(64) NOT NULL,
241 `account_uid` varchar(32) NOT NULL,
242 `money` int(11) unsigned NOT NULL DEFAULT '0',
243 `damage` double unsigned NOT NULL DEFAULT '0',
244 `hunger` double unsigned NOT NULL DEFAULT '100',
245 `thirst` double unsigned NOT NULL DEFAULT '100',
246 `alcohol` double unsigned NOT NULL DEFAULT '0',
247 `temperature` double NOT NULL DEFAULT '37',
248 `wetness` double unsigned NOT NULL DEFAULT '0',
249 `oxygen_remaining` double unsigned NOT NULL DEFAULT '1',
250 `bleeding_remaining` double unsigned NOT NULL DEFAULT '0',
251 `hitpoints` varchar(255) NOT NULL DEFAULT '[]',
252 `direction` double NOT NULL DEFAULT '0',
253 `position_x` double NOT NULL DEFAULT '0',
254 `position_y` double NOT NULL DEFAULT '0',
255 `position_z` double NOT NULL DEFAULT '0',
256 `spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
257 `assigned_items` text NOT NULL,
258 `backpack` varchar(64) NOT NULL,
259 `backpack_items` text NOT NULL,
260 `backpack_magazines` text NOT NULL,
261 `backpack_weapons` text NOT NULL,
262 `current_weapon` varchar(64) NOT NULL,
263 `goggles` varchar(64) NOT NULL,
264 `handgun_items` text NOT NULL,
265 `handgun_weapon` varchar(64) NOT NULL,
266 `headgear` varchar(64) NOT NULL,
267 `binocular` varchar(64) NOT NULL,
268 `loaded_magazines` text NOT NULL,
269 `primary_weapon` varchar(64) NOT NULL,
270 `primary_weapon_items` text NOT NULL,
271 `secondary_weapon` varchar(64) NOT NULL,
272 `secondary_weapon_items` text NOT NULL,
273 `uniform` varchar(64) NOT NULL,
274 `uniform_items` text NOT NULL,
275 `uniform_magazines` text NOT NULL,
276 `uniform_weapons` text NOT NULL,
277 `vest` varchar(64) NOT NULL,
278 `vest_items` text NOT NULL,
279 `vest_magazines` text NOT NULL,
280 `vest_weapons` text NOT NULL,
281 `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
282) ENGINE=InnoDB AUTO_INCREMENT=2502 DEFAULT CHARSET=utf8;
283
284--
285-- Dumping data for table `player`
286--
287
288INSERT INTO `player` (`id`, `name`, `account_uid`, `money`, `damage`, `hunger`, `thirst`, `alcohol`, `temperature`, `wetness`, `oxygen_remaining`, `bleeding_remaining`, `hitpoints`, `direction`, `position_x`, `position_y`, `position_z`, `spawned_at`, `assigned_items`, `backpack`, `backpack_items`, `backpack_magazines`, `backpack_weapons`, `current_weapon`, `goggles`, `handgun_items`, `handgun_weapon`, `headgear`, `binocular`, `loaded_magazines`, `primary_weapon`, `primary_weapon_items`, `secondary_weapon`, `secondary_weapon_items`, `uniform`, `uniform_items`, `uniform_magazines`, `uniform_weapons`, `vest`, `vest_items`, `vest_magazines`, `vest_weapons`, `last_updated_at`) VALUES
289(287, 'GodCarl', '76561198021434032', 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]]', 117.373405, 12539.163086, 12618.578125, 1000, '2016-07-26 18:33:37', '["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]', 'B_Parachute', '[]', '[]', '[]', '', '', '["","","",""]', '', '', '', '[]', '', '["","","",""]', '', '["","","",""]', 'Exile_Uniform_BambiOverall', '[]', '[["Exile_Item_PlasticBottleFreshWater",1]]', '[]', '', '[]', '[]', '[]', '2016-07-26 18:33:37'),
290'["","","",""]', 'hgun_P07_khk_F', '', '', '[["hgun_P07_khk_F","30Rnd_9x21_Mag",30,"hgun_P07_khk_F"]]', '', '["","","",""]', '', '["","","",""]', 'rhs_uniform_df15', '[]', '[["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_BeefParts",1],["Exile_Item_Bandage",1]]', '[]', 'rhs_vest_commander', '[]', '[["30Rnd_9x21_Mag",30],["30Rnd_9x21_Mag",30]]', '[]', '2016-09-14 21:01:53');
291
292-- --------------------------------------------------------
293
294--
295-- Table structure for table `player_history`
296--
297-- Creation: Jul 16, 2016 at 08:48 PM
298--
299
300CREATE TABLE IF NOT EXISTS `player_history` (
301 `id` int(11) unsigned NOT NULL,
302 `account_uid` varchar(32) NOT NULL,
303 `name` varchar(64) NOT NULL,
304 `died_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
305 `position_x` double NOT NULL,
306 `position_y` double NOT NULL,
307 `position_z` double NOT NULL
308) ENGINE=InnoDB AUTO_INCREMENT=2381 DEFAULT CHARSET=utf8;
309
310--
311-- Dumping data for table `player_history`
312--
313
314INSERT INTO `player_history` (`id`, `account_uid`, `name`, `died_at`, `position_x`, `position_y`, `position_z`) VALUES
315(184, '76561198061132496', '[RRTS] Balter', '2016-07-25 19:36:53', 9018.98, 10028.6, 0.773834),
316(185, '76561198061132496', '[RRTS] Balter', '2016-07-25 19:37:36', 8636.52, 10768.8, 0.773258),
317(186, '76561198061132496', '[RRTS] Balter', '2016-07-25 19:48:16', 8797.87, 10180.1, 0.00143814),
318(188, '76561198061132496', '[RRTS] Balter', '2016-07-25 19:55:50', 8890.97, 10139.3, 0.00144005),
319(192, '76561198061132496', '[RRTS] Balter', '2016-07-25 20:10:18', 9154.12, 10171.5, 0.0013504),
320
321(2378, '76561197970955433', 'The Unknown', '2016-09-14 20:22:22', 5765.92, 10420.8, 50.2717),
322(2379, '76561197970955433', 'The Unknown', '2016-09-14 20:49:37', 5716.78, 11278.8, 0.00168443),
323(2380, '76561197970955433', 'The Unknown', '2016-09-14 21:01:27', 5769.22, 11185.8, 0.00273108);
324
325-- --------------------------------------------------------
326
327--
328-- Table structure for table `ptws`
329--
330-- Creation: Sep 14, 2016 at 02:41 PM
331--
332
333CREATE TABLE IF NOT EXISTS `ptws` (
334 `dateID` varchar(8) NOT NULL,
335 `date` text NOT NULL,
336 `weather` text NOT NULL,
337 `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
338 `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
339) ENGINE=InnoDB DEFAULT CHARSET=utf8;
340
341--
342-- Dumping data for table `ptws`
343--
344
345INSERT INTO `ptws` (`dateID`, `date`, `weather`, `created_at`, `last_updated_at`) VALUES
346('PTWS', '[2016,8,26,16,54]', '[0.544443,0.154859,[0.0096975,0,0],[-4.79559,-0.395263,false],0.38111,0.1,0]', '2016-09-14 13:27:58', '2016-09-15 11:51:49');
347
348-- --------------------------------------------------------
349
350--
351-- Table structure for table `sneak_customs`
352--
353-- Creation: Jul 20, 2016 at 09:13 PM
354--
355
356CREATE TABLE IF NOT EXISTS `sneak_customs` (
357 `id` int(11) unsigned NOT NULL,
358 `skin_name` varchar(64) NOT NULL
359) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8;
360
361--
362-- Dumping data for table `sneak_customs`
363--
364
365INSERT INTO `sneak_customs` (`id`, `skin_name`) VALUES
366(82, 'any'),
367(85, 'any');
368
369-- --------------------------------------------------------
370
371--
372-- Table structure for table `territory`
373--
374-- Creation: Jul 16, 2016 at 08:48 PM
375--
376
377CREATE TABLE IF NOT EXISTS `territory` (
378 `id` int(11) unsigned NOT NULL,
379 `owner_uid` varchar(32) NOT NULL,
380 `name` varchar(64) NOT NULL,
381 `position_x` double NOT NULL,
382 `position_y` double NOT NULL,
383 `position_z` double NOT NULL,
384 `radius` double NOT NULL,
385 `level` int(11) NOT NULL,
386 `flag_texture` varchar(255) NOT NULL,
387 `flag_stolen` tinyint(1) NOT NULL DEFAULT '0',
388 `flag_stolen_by_uid` varchar(32) DEFAULT NULL,
389 `flag_stolen_at` datetime DEFAULT NULL,
390 `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
391 `last_paid_at` datetime DEFAULT CURRENT_TIMESTAMP,
392 `xm8_protectionmoney_notified` tinyint(1) NOT NULL DEFAULT '0',
393 `build_rights` varchar(640) NOT NULL DEFAULT '0',
394 `moderators` varchar(320) NOT NULL DEFAULT '0',
395 `deleted_at` datetime DEFAULT NULL
396) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8;
397
398--
399-- Dumping data for table `territory`
400--
401
402INSERT INTO `territory` (`id`, `owner_uid`, `name`, `position_x`, `position_y`, `position_z`, `radius`, `level`, `flag_texture`, `flag_stolen`, `flag_stolen_by_uid`, `flag_stolen_at`, `created_at`, `last_paid_at`, `xm8_protectionmoney_notified`, `build_rights`, `moderators`, `deleted_at`) VALUES
403(6, '76561198061132496', 'The Rock', 9555.203125, 9119.618164, 11.836914, 135, 9, '\\A3\\Data_F\\Flags\\flag_us_co.paa', 0, NULL, NULL, '2016-07-25 22:25:03', '2016-08-29 17:19:08', 0, '["76561198061132496","76561198130739840","76561197973365736","76561198041311769","76561197965620708"]', '["76561198061132496","76561198130739840","76561197973365736","76561198041311769"]', NULL),
404(9, '76561197970955433', 'Unknown Cave', 10864.15332, 14566.904297, 0.796474, 150, 10, 'Flags\\UnknownFlag.paa', 0, NULL, NULL, '2016-07-27 11:12:18', '2016-08-30 22:18:31', 0, '["76561197970955433"]', '["76561197970955433"]', NULL),
405(22, '76561198063061663', 'Stonehenge', 11446.224609, 6258.547852, 0.000394821, 150, 10, 'Flags\\logo.paa', 0, NULL, NULL, '2016-07-31 07:25:59', '2016-08-26 10:27:25', 0, '["76561198063061663","76561197965620708"]', '["76561198063061663"]', NULL),
406(27, '76561198080562321', 'John', 6878.489746, 12132.448242, 0.00614929, 15, 1, '\\A3\\Data_F\\Flags\\flag_green_co.paa', 0, NULL, NULL, '2016-08-02 16:18:55', '2016-08-27 11:47:53', 0, '["76561198080562321"]', '["76561198080562321"]', NULL),
407(34, '76561198185854228', 'one flew over the cuckoos nest', 12096.939453, 8641.939453, 0.231857, 90, 6, 'exile_assets\\texture\\flag\\flag_misc_dream_cat_co.paa', 0, NULL, NULL, '2016-08-04 22:02:18', '2016-09-06 00:00:00', 0, '["76561198185854228"]', '["76561198185854228"]', NULL),
408(37, '76561198156659915', 'lord Tarzan', 11595.708984, 8907.125977, 5.969269, 60, 4, 'exile_assets\\texture\\flag\\flag_misc_pirate_co.paa', 0, NULL, NULL, '2016-08-06 12:13:20', '2016-08-27 17:14:18', 0, '["76561198156659915","76561197966515186","76561197995500334"]', '["76561198156659915","76561197966515186","76561197995500334"]', NULL),
409(41, '76561197970955433', 'The Quad Track', 13420.249023, 5130.606934, 0.0331612, 250, 10, 'Flags\\logo.paa', 0, NULL, NULL, '2016-08-11 16:54:30', '2016-08-30 22:18:38', 0, '["76561197970955433"]', '["76561197970955433"]', NULL),
410(42, '76561197970955433', 'Mystery', 1106.118408, 562.394348, 0.0222902, 250, 10, 'Flags\\logo.paa', 0, NULL, NULL, '2016-08-14 09:53:34', '2016-08-30 22:18:46', 0, '["76561197970955433"]', '["76561197970955433"]', NULL),
411(43, '76561198009232012', 'FOB Murica', 5592.381348, 12629.521484, 6.0708394, 90, 6, '\\A3\\Data_F\\Flags\\flag_us_co.paa', 0, NULL, NULL, '2016-08-14 12:52:45', '2016-08-27 08:35:16', 0, '["76561198009232012"]', '["76561198009232012"]', NULL),
412(45, '76561197978284888', 'guyland', 6276.973633, 12916.257813, 7.474325, 45, 3, '\\A3\\Data_F\\Flags\\flag_us_co.paa', 0, NULL, NULL, '2016-08-17 00:02:28', '2016-09-09 11:26:44', 0, '["76561197978284888"]', '["76561197978284888"]', NULL),
413(47, '76561197965620708', 'Nimda slp', 5414.437988, 14588.5625, 1.97493, 250, 10, 'exile_assets\\texture\\flag\\flag_country_de_co.paa', 0, NULL, NULL, '2016-08-29 16:56:04', '2016-08-29 16:56:04', 0, '["76561197965620708"]', '["76561197965620708"]', NULL),
414(48, '76561198135031428', 'Fort Falcon', 6640.820313, 12616.291016, -0.139161, 60, 4, 'exile_assets\\texture\\flag\\flag_misc_kiwifern_co.paa', 0, NULL, NULL, '2016-08-30 22:06:44', '2016-08-30 22:06:44', 0, '["76561198135031428"]', '["76561198135031428"]', NULL),
415(52, '76561197965620708', 'The Wolves Den', 6445.775391, 7733.803223, -0.753399, 60, 4, 'Flags\\FlagBLWP.paa', 0, NULL, NULL, '2016-09-13 16:11:43', '2016-09-13 16:11:43', 0, '["76561197965620708"]', '["76561197965620708"]', NULL);
416
417-- --------------------------------------------------------
418
419--
420-- Table structure for table `vehicle`
421--
422-- Creation: Jul 16, 2016 at 08:48 PM
423--
424
425CREATE TABLE IF NOT EXISTS `vehicle` (
426 `id` int(11) unsigned NOT NULL,
427 `class` varchar(64) NOT NULL,
428 `spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
429 `account_uid` varchar(32) DEFAULT NULL,
430 `is_locked` tinyint(1) NOT NULL DEFAULT '0',
431 `fuel` double unsigned NOT NULL DEFAULT '0',
432 `damage` double unsigned NOT NULL DEFAULT '0',
433 `hitpoints` text NOT NULL,
434 `position_x` double NOT NULL DEFAULT '0',
435 `position_y` double NOT NULL DEFAULT '0',
436 `position_z` double NOT NULL DEFAULT '0',
437 `direction_x` double NOT NULL DEFAULT '0',
438 `direction_y` double NOT NULL DEFAULT '0',
439 `direction_z` double NOT NULL DEFAULT '0',
440 `up_x` double NOT NULL DEFAULT '0',
441 `up_y` double NOT NULL DEFAULT '0',
442 `up_z` double NOT NULL DEFAULT '1',
443 `cargo_items` text NOT NULL,
444 `cargo_magazines` text NOT NULL,
445 `cargo_weapons` text NOT NULL,
446 `cargo_container` text NOT NULL,
447 `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
448 `pin_code` varchar(6) NOT NULL DEFAULT '000000',
449 `deleted_at` datetime DEFAULT NULL,
450 `money` int(11) unsigned NOT NULL DEFAULT '0',
451 `vehicle_texture` text NOT NULL,
452 `territory_id` int(11) unsigned DEFAULT NULL
453) ENGINE=InnoDB AUTO_INCREMENT=464 DEFAULT CHARSET=utf8;
454
455--
456-- Dumping data for table `vehicle`
457--
458
459INSERT INTO `vehicle` (`id`, `class`, `spawned_at`, `account_uid`, `is_locked`, `fuel`, `damage`, `hitpoints`, `position_x`, `position_y`, `position_z`, `direction_x`, `direction_y`, `direction_z`, `up_x`, `up_y`, `up_z`, `cargo_items`, `cargo_magazines`, `cargo_weapons`, `cargo_container`, `last_updated_at`, `pin_code`, `deleted_at`, `money`, `vehicle_texture`, `territory_id`) VALUES
460(267, 'Exile_Car_Strider', '2016-08-03 21:44:30', 'DMS_PersistentVehicle', -1, 0.782553, 0, '[["HitLFWheel",0],["HitLF2Wheel",0],["HitRFWheel",0],["HitRF2Wheel",0],["HitFuel",0],["HitEngine",0],["HitBody",0],["HitGlass1",0],["HitGlass2",0],["HitGlass3",0],["HitGlass4",0],["HitGlass5",0],["HitRGlass",0],["HitLGlass",0],["HitGlass6",0],["HitLBWheel",0],["HitLMWheel",0],["HitRBWheel",0],["HitRMWheel",0],["HitGlass7",0],["HitGlass8",0],["",0],["",0],["",0],["",0],["HitTurret",0],["HitGun",0]]', 12087.550781, 8672.160156, 0.021637, 0.267151, -0.895187, 0.35675, 0.0181165, 0.374806, 0.926926, '[["rhs_acc_dtk","FirstAidKit"],[1,1]]', '[["Exile_Item_Rope",1],["Exile_Item_WoodLog",1],["Exile_Item_Rope",1],["16Rnd_9x21_Mag",16],["5Rnd_127x108_APDS_Mag",5],["5Rnd_127x108_APDS_Mag",5],["Exile_Item_PlasticBottleEmpty",1]]', '[["rhsusf_weap_glock17g4","","","",["rhsusf_mag_17Rnd_9x19_JHP",17],""],["Exile_Melee_Axe","","","",["Exile_Magazine_Swing",835],""]]', '[]', '2016-08-30 23:42:10', '1973', NULL, 0, '', 34),
461["HitLGlass",0],["HitEngine3",0],["HitWinch",0],["HitGlass1",0],["HitGlass2",0],["HitGlass3",0],["HitGlass4",0],["HitGlass5",0],["HitGlass6",0],["HitLight",0],["HitHydraulics",0],["HitGear",0],["HitHStabilizerL1",0],["HitHStabilizerR1",0],["HitVStabilizer1",0],["HitTail",0],["HitPitotTube",0],["HitStaticPort",0],["HitStarter1",0],["HitStarter2",0],["HitStarter3",0],["",0],["HitTurret",0],["HitGun",0],["HitTurret",0],["HitGun",0]]', 6258.253906, 12898.544922, 7.356738, 0.469666, -0.882838, -0.0032959, 0.00164312, -0.00285915, 0.999995, '[[],[]]', '[]', '[]', '[]', '2016-09-14 10:53:17', '1217', NULL, 0, '["A3\\Air_F_Heli\\Heli_Transport_04\\Data\\Heli_Transport_04_base_01_black_CO.paa","A3\\Air_F_Heli\\Heli_Transport_04\\Data\\Heli_Transport_04_base_02_black_CO.paa"]', 45);
462
463--
464-- Indexes for dumped tables
465--
466
467--
468-- Indexes for table `account`
469--
470ALTER TABLE `account`
471 ADD PRIMARY KEY (`uid`),
472 ADD KEY `clan_id` (`clan_id`);
473
474--
475-- Indexes for table `clan`
476--
477ALTER TABLE `clan`
478 ADD PRIMARY KEY (`id`),
479 ADD KEY `leader_uid` (`leader_uid`);
480
481--
482-- Indexes for table `clan_map_marker`
483--
484ALTER TABLE `clan_map_marker`
485 ADD PRIMARY KEY (`id`),
486 ADD KEY `clan_id` (`clan_id`);
487
488--
489-- Indexes for table `construction`
490--
491ALTER TABLE `construction`
492 ADD PRIMARY KEY (`id`),
493 ADD KEY `account_uid` (`account_uid`),
494 ADD KEY `territory_id` (`territory_id`);
495
496--
497-- Indexes for table `container`
498--
499ALTER TABLE `container`
500 ADD PRIMARY KEY (`id`),
501 ADD KEY `account_uid` (`account_uid`),
502 ADD KEY `territory_id` (`territory_id`);
503
504--
505-- Indexes for table `marxet`
506--
507ALTER TABLE `marxet`
508 ADD PRIMARY KEY (`listingID`),
509 ADD KEY `listingID` (`listingID`);
510
511--
512-- Indexes for table `player`
513--
514ALTER TABLE `player`
515 ADD PRIMARY KEY (`id`),
516 ADD KEY `player_uid` (`account_uid`);
517
518--
519-- Indexes for table `player_history`
520--
521ALTER TABLE `player_history`
522 ADD PRIMARY KEY (`id`);
523
524--
525-- Indexes for table `ptws`
526--
527ALTER TABLE `ptws`
528 ADD PRIMARY KEY (`dateID`),
529 ADD KEY `dateID` (`dateID`);
530
531--
532-- Indexes for table `sneak_customs`
533--
534ALTER TABLE `sneak_customs`
535 ADD PRIMARY KEY (`id`);
536
537--
538-- Indexes for table `territory`
539--
540ALTER TABLE `territory`
541 ADD PRIMARY KEY (`id`),
542 ADD KEY `owner_uid` (`owner_uid`),
543 ADD KEY `flag_stolen_by_uid` (`flag_stolen_by_uid`);
544
545--
546-- Indexes for table `vehicle`
547--
548ALTER TABLE `vehicle`
549 ADD PRIMARY KEY (`id`),
550 ADD KEY `account_uid` (`account_uid`),
551 ADD KEY `vehicle_ibfk_2` (`territory_id`);
552
553--
554-- AUTO_INCREMENT for dumped tables
555--
556
557--
558-- AUTO_INCREMENT for table `clan`
559--
560ALTER TABLE `clan`
561 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
562--
563-- AUTO_INCREMENT for table `clan_map_marker`
564--
565ALTER TABLE `clan_map_marker`
566 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=35;
567--
568-- AUTO_INCREMENT for table `construction`
569--
570ALTER TABLE `construction`
571 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8448;
572--
573-- AUTO_INCREMENT for table `container`
574--
575ALTER TABLE `container`
576 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=325;
577--
578-- AUTO_INCREMENT for table `player`
579--
580ALTER TABLE `player`
581 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2502;
582--
583-- AUTO_INCREMENT for table `player_history`
584--
585ALTER TABLE `player_history`
586 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2381;
587--
588-- AUTO_INCREMENT for table `sneak_customs`
589--
590ALTER TABLE `sneak_customs`
591 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=86;
592--
593-- AUTO_INCREMENT for table `territory`
594--
595ALTER TABLE `territory`
596 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=53;
597--
598-- AUTO_INCREMENT for table `vehicle`
599--
600ALTER TABLE `vehicle`
601 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=464;
602--
603-- Constraints for dumped tables
604--
605
606--
607-- Constraints for table `account`
608--
609ALTER TABLE `account`
610 ADD CONSTRAINT `account_ibfk_1` FOREIGN KEY (`clan_id`) REFERENCES `clan` (`id`) ON DELETE SET NULL;
611
612--
613-- Constraints for table `clan`
614--
615ALTER TABLE `clan`
616 ADD CONSTRAINT `clan_ibfk_1` FOREIGN KEY (`leader_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE;
617
618--
619-- Constraints for table `clan_map_marker`
620--
621ALTER TABLE `clan_map_marker`
622 ADD CONSTRAINT `clan_map_marker_ibfk_1` FOREIGN KEY (`clan_id`) REFERENCES `clan` (`id`) ON DELETE CASCADE;
623
624--
625-- Constraints for table `construction`
626--
627ALTER TABLE `construction`
628 ADD CONSTRAINT `construction_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
629 ADD CONSTRAINT `construction_ibfk_2` FOREIGN KEY (`territory_id`) REFERENCES `territory` (`id`) ON DELETE CASCADE;
630
631--
632-- Constraints for table `container`
633--
634ALTER TABLE `container`
635 ADD CONSTRAINT `container_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
636 ADD CONSTRAINT `container_ibfk_2` FOREIGN KEY (`territory_id`) REFERENCES `territory` (`id`) ON DELETE CASCADE;
637
638--
639-- Constraints for table `player`
640--
641ALTER TABLE `player`
642 ADD CONSTRAINT `player_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE;
643
644--
645-- Constraints for table `territory`
646--
647ALTER TABLE `territory`
648 ADD CONSTRAINT `territory_ibfk_1` FOREIGN KEY (`owner_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
649 ADD CONSTRAINT `territory_ibfk_2` FOREIGN KEY (`flag_stolen_by_uid`) REFERENCES `account` (`uid`) ON DELETE SET NULL;
650
651--
652-- Constraints for table `vehicle`
653--
654ALTER TABLE `vehicle`
655 ADD CONSTRAINT `vehicle_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
656 ADD CONSTRAINT `vehicle_ibfk_2` FOREIGN KEY (`territory_id`) REFERENCES `territory` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
657
658/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
659/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
660/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;