· 7 years ago · Nov 27, 2018, 12:14 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 5.6.26-log - MySQL Community Server (GPL)
4-- Server OS: Win64
5-- HeidiSQL Version: 9.2.0.4970
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8mb4 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13
14-- Dumping structure for table exile.account
15CREATE TABLE IF NOT EXISTS `account` (
16 `uid` varchar(32) NOT NULL,
17 `clan_id` int(11) unsigned DEFAULT NULL,
18 `name` varchar(64) NOT NULL,
19 `score` int(11) NOT NULL DEFAULT '0',
20 `kills` int(11) unsigned NOT NULL DEFAULT '0',
21 `deaths` int(11) unsigned NOT NULL DEFAULT '0',
22 `locker` int(11) NOT NULL DEFAULT '0',
23 `first_connect_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
24 `last_connect_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
25 `last_disconnect_at` datetime DEFAULT NULL,
26 `total_connections` int(11) unsigned NOT NULL DEFAULT '1',
27 PRIMARY KEY (`uid`),
28 KEY `clan_id` (`clan_id`),
29 CONSTRAINT `account_ibfk_1` FOREIGN KEY (`clan_id`) REFERENCES `clan` (`id`) ON DELETE SET NULL
30) ENGINE=InnoDB DEFAULT CHARSET=utf8;
31
32-- Data exporting was unselected.
33
34
35-- Dumping structure for table exile.clan
36CREATE TABLE IF NOT EXISTS `clan` (
37 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
38 `name` varchar(64) NOT NULL,
39 `leader_uid` varchar(32) NOT NULL,
40 `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
41 PRIMARY KEY (`id`),
42 KEY `leader_uid` (`leader_uid`),
43 CONSTRAINT `clan_ibfk_1` FOREIGN KEY (`leader_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE
44) ENGINE=InnoDB DEFAULT CHARSET=utf8;
45
46-- Data exporting was unselected.
47
48
49-- Dumping structure for table exile.clan_map_marker
50CREATE TABLE IF NOT EXISTS `clan_map_marker` (
51 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
52 `clan_id` int(11) unsigned NOT NULL,
53 `markerType` tinyint(4) NOT NULL DEFAULT '-1',
54 `positionArr` text NOT NULL,
55 `color` varchar(255) NOT NULL,
56 `icon` varchar(255) NOT NULL,
57 `iconSize` float unsigned NOT NULL,
58 `label` varchar(255) NOT NULL,
59 `labelSize` float unsigned NOT NULL,
60 PRIMARY KEY (`id`),
61 KEY `clan_id` (`clan_id`),
62 CONSTRAINT `clan_map_marker_ibfk_1` FOREIGN KEY (`clan_id`) REFERENCES `clan` (`id`) ON DELETE CASCADE
63) ENGINE=InnoDB DEFAULT CHARSET=utf8;
64
65-- Data exporting was unselected.
66
67
68-- Dumping structure for table exile.construction
69CREATE TABLE IF NOT EXISTS `construction` (
70 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
71 `class` varchar(64) NOT NULL,
72 `account_uid` varchar(32) NOT NULL,
73 `spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
74 `position_x` double NOT NULL DEFAULT '0',
75 `position_y` double NOT NULL DEFAULT '0',
76 `position_z` double NOT NULL DEFAULT '0',
77 `direction_x` double NOT NULL DEFAULT '0',
78 `direction_y` double NOT NULL DEFAULT '0',
79 `direction_z` double NOT NULL DEFAULT '0',
80 `up_x` double NOT NULL DEFAULT '0',
81 `up_y` double NOT NULL DEFAULT '0',
82 `up_z` double NOT NULL DEFAULT '0',
83 `is_locked` tinyint(1) NOT NULL DEFAULT '0',
84 `pin_code` varchar(6) NOT NULL DEFAULT '000000',
85 `damage` tinyint(1) unsigned NULL DEFAULT '0',
86 `territory_id` int(11) unsigned DEFAULT NULL,
87 `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
88 `deleted_at` datetime DEFAULT NULL,
89 PRIMARY KEY (`id`),
90 KEY `account_uid` (`account_uid`),
91 KEY `territory_id` (`territory_id`),
92 CONSTRAINT `construction_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
93 CONSTRAINT `construction_ibfk_2` FOREIGN KEY (`territory_id`) REFERENCES `territory` (`id`) ON DELETE CASCADE
94) ENGINE=InnoDB DEFAULT CHARSET=utf8;
95
96-- Data exporting was unselected.
97
98
99-- Dumping structure for table exile.container
100CREATE TABLE IF NOT EXISTS `container` (
101 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
102 `class` varchar(64) NOT NULL,
103 `spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
104 `account_uid` varchar(32) DEFAULT NULL,
105 `is_locked` tinyint(1) NOT NULL DEFAULT '0',
106 `position_x` double NOT NULL DEFAULT '0',
107 `position_y` double NOT NULL DEFAULT '0',
108 `position_z` double NOT NULL DEFAULT '0',
109 `direction_x` double NOT NULL DEFAULT '0',
110 `direction_y` double NOT NULL DEFAULT '0',
111 `direction_z` double NOT NULL DEFAULT '0',
112 `up_x` double NOT NULL DEFAULT '0',
113 `up_y` double NOT NULL DEFAULT '0',
114 `up_z` double NOT NULL DEFAULT '1',
115 `cargo_items` text NOT NULL,
116 `cargo_magazines` text NOT NULL,
117 `cargo_weapons` text NOT NULL,
118 `cargo_container` text NOT NULL,
119 `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
120 `pin_code` varchar(6) NOT NULL DEFAULT '000000',
121 `territory_id` int(11) unsigned DEFAULT NULL,
122 `deleted_at` datetime DEFAULT NULL,
123 `money` int(11) unsigned NOT NULL DEFAULT '0',
124 `abandoned` datetime DEFAULT NULL,
125 PRIMARY KEY (`id`),
126 KEY `account_uid` (`account_uid`),
127 KEY `territory_id` (`territory_id`),
128 CONSTRAINT `container_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
129 CONSTRAINT `container_ibfk_2` FOREIGN KEY (`territory_id`) REFERENCES `territory` (`id`) ON DELETE CASCADE
130) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
131
132-- Data exporting was unselected.
133
134
135-- Dumping structure for table exile.player
136CREATE TABLE IF NOT EXISTS `player` (
137 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
138 `name` varchar(64) NOT NULL,
139 `account_uid` varchar(32) NOT NULL,
140 `money` int(11) unsigned NOT NULL DEFAULT '0',
141 `damage` double unsigned NOT NULL DEFAULT '0',
142 `hunger` double unsigned NOT NULL DEFAULT '100',
143 `thirst` double unsigned NOT NULL DEFAULT '100',
144 `alcohol` double unsigned NOT NULL DEFAULT '0',
145 `temperature` double NOT NULL DEFAULT '37',
146 `wetness` double unsigned NOT NULL DEFAULT '0',
147 `oxygen_remaining` double unsigned NOT NULL DEFAULT '1',
148 `bleeding_remaining` double unsigned NOT NULL DEFAULT '0',
149 `hitpoints` varchar(1024) NOT NULL DEFAULT '[]',
150 `direction` double NOT NULL DEFAULT '0',
151 `position_x` double NOT NULL DEFAULT '0',
152 `position_y` double NOT NULL DEFAULT '0',
153 `position_z` double NOT NULL DEFAULT '0',
154 `spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
155 `assigned_items` text NOT NULL,
156 `backpack` varchar(64) NOT NULL,
157 `backpack_items` text NOT NULL,
158 `backpack_magazines` text NOT NULL,
159 `backpack_weapons` text NOT NULL,
160 `current_weapon` varchar(64) NOT NULL,
161 `goggles` varchar(64) NOT NULL,
162 `handgun_items` text NOT NULL,
163 `handgun_weapon` varchar(64) NOT NULL,
164 `headgear` varchar(64) NOT NULL,
165 `binocular` varchar(64) NOT NULL,
166 `loaded_magazines` text NOT NULL,
167 `primary_weapon` varchar(64) NOT NULL,
168 `primary_weapon_items` text NOT NULL,
169 `secondary_weapon` varchar(64) NOT NULL,
170 `secondary_weapon_items` text NOT NULL,
171 `uniform` varchar(64) NOT NULL,
172 `uniform_items` text NOT NULL,
173 `uniform_magazines` text NOT NULL,
174 `uniform_weapons` text NOT NULL,
175 `vest` varchar(64) NOT NULL,
176 `vest_items` text NOT NULL,
177 `vest_magazines` text NOT NULL,
178 `vest_weapons` text NOT NULL,
179 `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
180 PRIMARY KEY (`id`),
181 KEY `player_uid` (`account_uid`),
182 CONSTRAINT `player_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE
183) ENGINE=InnoDB DEFAULT CHARSET=utf8;
184
185-- Data exporting was unselected.
186
187
188-- Dumping structure for table exile.player_history
189CREATE TABLE IF NOT EXISTS `player_history` (
190 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
191 `account_uid` varchar(32) NOT NULL,
192 `name` varchar(64) NOT NULL,
193 `died_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
194 `position_x` double NOT NULL,
195 `position_y` double NOT NULL,
196 `position_z` double NOT NULL,
197 PRIMARY KEY (`id`)
198) ENGINE=InnoDB DEFAULT CHARSET=utf8;
199
200-- Data exporting was unselected.
201
202
203-- Dumping structure for table exile.territory
204CREATE TABLE IF NOT EXISTS `territory` (
205 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
206 `owner_uid` varchar(32) NOT NULL,
207 `name` varchar(64) NOT NULL,
208 `position_x` double NOT NULL,
209 `position_y` double NOT NULL,
210 `position_z` double NOT NULL,
211 `radius` double NOT NULL,
212 `level` int(11) NOT NULL,
213 `flag_texture` varchar(255) NOT NULL,
214 `flag_stolen` tinyint(1) NOT NULL DEFAULT '0',
215 `flag_stolen_by_uid` varchar(32) DEFAULT NULL,
216 `flag_stolen_at` datetime DEFAULT NULL,
217 `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
218 `last_paid_at` datetime DEFAULT CURRENT_TIMESTAMP,
219 `xm8_protectionmoney_notified` tinyint(1) NOT NULL DEFAULT '0',
220 `build_rights` varchar(640) NOT NULL DEFAULT '0',
221 `moderators` varchar(320) NOT NULL DEFAULT '0',
222 `deleted_at` datetime DEFAULT NULL,
223 PRIMARY KEY (`id`),
224 KEY `owner_uid` (`owner_uid`),
225 KEY `flag_stolen_by_uid` (`flag_stolen_by_uid`),
226 CONSTRAINT `territory_ibfk_1` FOREIGN KEY (`owner_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
227 CONSTRAINT `territory_ibfk_2` FOREIGN KEY (`flag_stolen_by_uid`) REFERENCES `account` (`uid`) ON DELETE SET NULL
228) ENGINE=InnoDB DEFAULT CHARSET=utf8;
229
230-- Data exporting was unselected.
231
232
233-- Dumping structure for table exile.vehicle
234CREATE TABLE IF NOT EXISTS `vehicle` (
235 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
236 `class` varchar(64) NOT NULL,
237 `spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
238 `account_uid` varchar(32) DEFAULT NULL,
239 `is_locked` tinyint(1) NOT NULL DEFAULT '0',
240 `fuel` double unsigned NOT NULL DEFAULT '0',
241 `damage` double unsigned NOT NULL DEFAULT '0',
242 `hitpoints` text NOT NULL,
243 `position_x` double NOT NULL DEFAULT '0',
244 `position_y` double NOT NULL DEFAULT '0',
245 `position_z` double NOT NULL DEFAULT '0',
246 `direction_x` double NOT NULL DEFAULT '0',
247 `direction_y` double NOT NULL DEFAULT '0',
248 `direction_z` double NOT NULL DEFAULT '0',
249 `up_x` double NOT NULL DEFAULT '0',
250 `up_y` double NOT NULL DEFAULT '0',
251 `up_z` double NOT NULL DEFAULT '1',
252 `cargo_items` text NOT NULL,
253 `cargo_magazines` text NOT NULL,
254 `cargo_weapons` text NOT NULL,
255 `cargo_container` text NOT NULL,
256 `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
257 `pin_code` varchar(6) NOT NULL DEFAULT '000000',
258 `deleted_at` datetime DEFAULT NULL,
259 `money` int(11) unsigned NOT NULL DEFAULT '0',
260 `vehicle_texture` text NOT NULL,
261 `territory_id` int(11) unsigned DEFAULT NULL,
262 `nickname` varchar(64) NOT NULL DEFAULT '',
263 PRIMARY KEY (`id`),
264 KEY `account_uid` (`account_uid`),
265 KEY `vehicle_ibfk_2_idx` (`territory_id`),
266 CONSTRAINT `vehicle_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
267 CONSTRAINT `vehicle_ibfk_2` FOREIGN KEY (`territory_id`) REFERENCES `territory` (`id`) ON DELETE CASCADE
268) ENGINE=InnoDB DEFAULT CHARSET=utf8;
269
270-- Data exporting was unselected.
271/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
272/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
273/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;