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