· 7 years ago · Jan 18, 2019, 09:38 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
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 `money` double NOT NULL DEFAULT '0',
20 `score` int(11) NOT NULL DEFAULT '0',
21 `kills` int(11) unsigned NOT NULL DEFAULT '0',
22 `deaths` int(11) unsigned NOT NULL DEFAULT '0',
23 `first_connect_at` datetime DEFAULT NULL,
24 `last_connect_at` datetime DEFAULT NULL,
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,
41 `insignia_texture` varchar(255) DEFAULT NULL,
42 PRIMARY KEY (`id`),
43 KEY `leader_uid` (`leader_uid`),
44 CONSTRAINT `clan_ibfk_1` FOREIGN KEY (`leader_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE
45) ENGINE=InnoDB DEFAULT CHARSET=utf8;
46
47-- Data exporting was unselected.
48
49
50-- Dumping structure for table exile.construction
51CREATE TABLE IF NOT EXISTS `construction` (
52 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
53 `class` varchar(64) NOT NULL,
54 `account_uid` varchar(32) NOT NULL,
55 `spawned_at` datetime NOT NULL,
56 `maintained_at` datetime DEFAULT NULL,
57 `position_x` double NOT NULL,
58 `position_y` double NOT NULL,
59 `position_z` double NOT NULL,
60 `direction_x` double NOT NULL,
61 `direction_y` double NOT NULL,
62 `direction_z` double NOT NULL,
63 `up_x` double NOT NULL,
64 `up_y` double NOT NULL,
65 `up_z` double NOT NULL,
66 `is_locked` tinyint(1) NOT NULL,
67 `pin_code` varchar(6) NOT NULL DEFAULT '000000',
68 PRIMARY KEY (`id`)
69) ENGINE=InnoDB DEFAULT CHARSET=utf8;
70
71-- Data exporting was unselected.
72
73
74-- Dumping structure for table exile.container
75CREATE TABLE IF NOT EXISTS `container` (
76 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
77 `class` varchar(64) NOT NULL,
78 `spawned_at` datetime NOT NULL,
79 `account_uid` varchar(32) DEFAULT NULL,
80 `last_accessed` datetime NOT NULL,
81 `is_locked` tinyint(1) NOT NULL DEFAULT '0',
82 `position_x` double NOT NULL DEFAULT '0',
83 `position_y` double NOT NULL DEFAULT '0',
84 `position_z` double NOT NULL DEFAULT '0',
85 `direction_x` double NOT NULL DEFAULT '0',
86 `direction_y` double NOT NULL DEFAULT '0',
87 `direction_z` double NOT NULL DEFAULT '0',
88 `up_x` double NOT NULL DEFAULT '0',
89 `up_y` double NOT NULL DEFAULT '0',
90 `up_z` double NOT NULL DEFAULT '1',
91 `cargo_items` text NOT NULL,
92 `cargo_magazines` text NOT NULL,
93 `cargo_weapons` text NOT NULL,
94 `cargo_container` text NOT NULL,
95 `pin_code` varchar(6) NOT NULL DEFAULT '000000',
96 PRIMARY KEY (`id`)
97) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
98
99-- Data exporting was unselected.
100
101
102-- Dumping structure for table exile.player
103CREATE TABLE IF NOT EXISTS `player` (
104 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
105 `name` varchar(64) NOT NULL,
106 `account_uid` varchar(32) NOT NULL,
107 `is_alive` tinyint(1) NOT NULL DEFAULT '1',
108 `damage` double unsigned NOT NULL DEFAULT '0',
109 `fatigue` double unsigned NOT NULL DEFAULT '0',
110 `hunger` double unsigned NOT NULL DEFAULT '100',
111 `thirst` double unsigned NOT NULL DEFAULT '100',
112 `alcohol` double unsigned NOT NULL DEFAULT '0',
113 `oxygen_remaining` double unsigned NOT NULL DEFAULT '1',
114 `bleeding_remaining` double unsigned NOT NULL DEFAULT '0',
115 `hitpoint_head` double unsigned NOT NULL,
116 `hitpoint_body` double unsigned NOT NULL DEFAULT '0',
117 `hitpoint_hands` double unsigned NOT NULL DEFAULT '0',
118 `hitpoint_legs` double unsigned NOT NULL DEFAULT '0',
119 `direction` double NOT NULL DEFAULT '0',
120 `position_x` double NOT NULL DEFAULT '0',
121 `position_y` double NOT NULL DEFAULT '0',
122 `position_z` double NOT NULL DEFAULT '0',
123 `spawned_at` datetime NOT NULL,
124 `died_at` datetime DEFAULT NULL,
125 `assigned_items` text NOT NULL,
126 `backpack` varchar(64) NOT NULL,
127 `backpack_items` text NOT NULL,
128 `backpack_magazines` text NOT NULL,
129 `backpack_weapons` text NOT NULL,
130 `current_weapon` varchar(64) NOT NULL,
131 `goggles` varchar(64) NOT NULL,
132 `handgun_items` varchar(255) NOT NULL,
133 `handgun_weapon` varchar(64) NOT NULL,
134 `headgear` varchar(64) NOT NULL,
135 `binocular` varchar(64) NOT NULL,
136 `loaded_magazines` varchar(255) NOT NULL,
137 `primary_weapon` varchar(64) NOT NULL,
138 `primary_weapon_items` varchar(255) NOT NULL,
139 `secondary_weapon` varchar(64) NOT NULL,
140 `secondary_weapon_items` varchar(255) NOT NULL,
141 `uniform` varchar(64) NOT NULL,
142 `uniform_items` text NOT NULL,
143 `uniform_magazines` text NOT NULL,
144 `uniform_weapons` text NOT NULL,
145 `vest` varchar(64) NOT NULL,
146 `vest_items` text NOT NULL,
147 `vest_magazines` text NOT NULL,
148 `vest_weapons` text NOT NULL,
149 PRIMARY KEY (`id`),
150 KEY `player_uid` (`account_uid`)
151) ENGINE=InnoDB DEFAULT CHARSET=utf8;
152
153-- Data exporting was unselected.
154
155
156-- Dumping structure for table exile.territory
157CREATE TABLE IF NOT EXISTS `territory` (
158 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
159 `owner_uid` varchar(32) NOT NULL,
160 `name` varchar(64) NOT NULL,
161 `position_x` double NOT NULL,
162 `position_y` double NOT NULL,
163 `position_z` double NOT NULL,
164 `radius` double NOT NULL,
165 `level` int(11) NOT NULL,
166 `flag_texture` varchar(255) NOT NULL,
167 `flag_stolen` tinyint(1) NOT NULL DEFAULT '0',
168 `flag_stolen_by_uid` varchar(32) DEFAULT NULL,
169 `flag_stolen_at` datetime DEFAULT NULL,
170 `flag_steal_message` varchar(255) DEFAULT NULL,
171 `created_at` datetime NOT NULL,
172 `last_payed_at` datetime DEFAULT NULL,
173 `build_rights` varchar(640) NOT NULL DEFAULT '0',
174 `moderators` varchar(320) NOT NULL DEFAULT '0',
175 PRIMARY KEY (`id`)
176) ENGINE=InnoDB DEFAULT CHARSET=utf8;
177
178-- Data exporting was unselected.
179
180
181-- Dumping structure for table exile.vehicle
182CREATE TABLE IF NOT EXISTS `vehicle` (
183 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
184 `class` varchar(64) NOT NULL,
185 `spawned_at` datetime NOT NULL,
186 `account_uid` varchar(32) DEFAULT NULL,
187 `is_locked` tinyint(1) NOT NULL DEFAULT '0',
188 `fuel` double unsigned NOT NULL DEFAULT '0',
189 `damage` double unsigned NOT NULL DEFAULT '0',
190 `hitpoints` text NOT NULL,
191 `position_x` double NOT NULL DEFAULT '0',
192 `position_y` double NOT NULL DEFAULT '0',
193 `position_z` double NOT NULL DEFAULT '0',
194 `direction_x` double NOT NULL DEFAULT '0',
195 `direction_y` double NOT NULL DEFAULT '0',
196 `direction_z` double NOT NULL DEFAULT '0',
197 `up_x` double NOT NULL DEFAULT '0',
198 `up_y` double NOT NULL DEFAULT '0',
199 `up_z` double NOT NULL DEFAULT '1',
200 `cargo_items` text NOT NULL,
201 `cargo_magazines` text NOT NULL,
202 `cargo_weapons` text NOT NULL,
203 `cargo_container` text NOT NULL,
204 `pin_code` varchar(6) NOT NULL DEFAULT '000000',
205 PRIMARY KEY (`id`)
206) ENGINE=InnoDB DEFAULT CHARSET=utf8;
207
208-- Data exporting was unselected.
209/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
210/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
211/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;