· 8 years ago · May 26, 2018, 09:34 PM
1 # Time Action Message Duration / Fetch
23 1 10:29:18 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */ 0 row(s) affected 0.000 sec
33 2 10:29:18 /*!40101 SET NAMES utf8mb4 */ 0 row(s) affected 0.000 sec
43 3 10:29:18 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */ 0 row(s) affected 0.000 sec
53 4 10:29:18 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */ 0 row(s) affected 0.000 sec
61 5 10:29:18 CREATE DATABASE IF NOT EXISTS `exile` /*!40100 DEFAULT CHARACTER SET utf8 */ 1 row(s) affected, 2 warning(s):
7 3719 'utf8' is currently an alias for the character set UTF8MB3, which will be replaced by UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
8 1007 Can't create database 'exile'; database exists 0.000 sec
93 6 10:29:18 USE `exile` 0 row(s) affected 0.000 sec
101 7 10:29:18 CREATE TABLE IF NOT EXISTS `account` (
11 `uid` varchar(32) NOT NULL,
12 `clan_id` int(11) unsigned DEFAULT NULL,
13 `name` varchar(64) NOT NULL,
14 `score` int(11) NOT NULL DEFAULT '0',
15 `kills` int(11) unsigned NOT NULL DEFAULT '0',
16 `deaths` int(11) unsigned NOT NULL DEFAULT '0',
17 `locker` int(11) NOT NULL DEFAULT '0',
18 `first_connect_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
19 `last_connect_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
20 `last_disconnect_at` datetime DEFAULT NULL,
21 `total_connections` int(11) unsigned NOT NULL DEFAULT '1',
22 PRIMARY KEY (`uid`),
23 KEY `clan_id` (`clan_id`),
24 CONSTRAINT `account_ibfk_1` FOREIGN KEY (`clan_id`) REFERENCES `clan` (`id`) ON DELETE SET NULL
25 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 0 row(s) affected, 2 warning(s):
26 3719 'utf8' is currently an alias for the character set UTF8MB3, which will be replaced by UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
27 1050 Table 'account' already exists 0.000 sec
281 8 10:29:18 CREATE TABLE IF NOT EXISTS `clan` (
29 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
30 `name` varchar(64) NOT NULL,
31 `leader_uid` varchar(32) NOT NULL,
32 `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
33 PRIMARY KEY (`id`),
34 KEY `leader_uid` (`leader_uid`),
35 CONSTRAINT `clan_ibfk_1` FOREIGN KEY (`leader_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE
36 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 0 row(s) affected, 2 warning(s):
37 3719 'utf8' is currently an alias for the character set UTF8MB3, which will be replaced by UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
38 1050 Table 'clan' already exists 0.000 sec
391 9 10:29:18 CREATE TABLE IF NOT EXISTS `clan_map_marker` (
40 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
41 `clan_id` int(11) unsigned NOT NULL,
42 `markerType` tinyint(4) NOT NULL DEFAULT '-1',
43 `positionArr` text NOT NULL,
44 `color` varchar(255) NOT NULL,
45 `icon` varchar(255) NOT NULL,
46 `iconSize` float unsigned NOT NULL,
47 `label` varchar(255) NOT NULL,
48 `labelSize` float unsigned NOT NULL,
49 PRIMARY KEY (`id`),
50 KEY `clan_id` (`clan_id`),
51 CONSTRAINT `clan_map_marker_ibfk_1` FOREIGN KEY (`clan_id`) REFERENCES `clan` (`id`) ON DELETE CASCADE
52 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 0 row(s) affected, 2 warning(s):
53 3719 'utf8' is currently an alias for the character set UTF8MB3, which will be replaced by UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
54 1050 Table 'clan_map_marker' already exists 0.016 sec
551 10 10:29:18 CREATE TABLE IF NOT EXISTS `construction` (
56 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
57 `class` varchar(64) NOT NULL,
58 `account_uid` varchar(32) NOT NULL,
59 `spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
60 `position_x` double NOT NULL DEFAULT '0',
61 `position_y` double NOT NULL DEFAULT '0',
62 `position_z` double NOT NULL DEFAULT '0',
63 `direction_x` double NOT NULL DEFAULT '0',
64 `direction_y` double NOT NULL DEFAULT '0',
65 `direction_z` double NOT NULL DEFAULT '0',
66 `up_x` double NOT NULL DEFAULT '0',
67 `up_y` double NOT NULL DEFAULT '0',
68 `up_z` double NOT NULL DEFAULT '0',
69 `is_locked` tinyint(1) NOT NULL DEFAULT '0',
70 `pin_code` varchar(6) NOT NULL DEFAULT '000000',
71 `damage` tinyint(1) unsigned NULL DEFAULT '0',
72 `territory_id` int(11) unsigned DEFAULT NULL,
73 `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
74 `deleted_at` datetime DEFAULT NULL,
75 PRIMARY KEY (`id`),
76 KEY `account_uid` (`account_uid`),
77 KEY `territory_id` (`territory_id`),
78 CONSTRAINT `construction_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
79 CONSTRAINT `construction_ibfk_2` FOREIGN KEY (`territory_id`) REFERENCES `territory` (`id`) ON DELETE CASCADE
80 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 0 row(s) affected, 2 warning(s):
81 3719 'utf8' is currently an alias for the character set UTF8MB3, which will be replaced by UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
82 1050 Table 'construction' already exists 0.000 sec
831 11 10:29:18 CREATE TABLE IF NOT EXISTS `container` (
84 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
85 `class` varchar(64) NOT NULL,
86 `spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
87 `account_uid` varchar(32) DEFAULT NULL,
88 `is_locked` tinyint(1) NOT NULL DEFAULT '0',
89 `position_x` double NOT NULL DEFAULT '0',
90 `position_y` double NOT NULL DEFAULT '0',
91 `position_z` double NOT NULL DEFAULT '0',
92 `direction_x` double NOT NULL DEFAULT '0',
93 `direction_y` double NOT NULL DEFAULT '0',
94 `direction_z` double NOT NULL DEFAULT '0',
95 `up_x` double NOT NULL DEFAULT '0',
96 `up_y` double NOT NULL DEFAULT '0',
97 `up_z` double NOT NULL DEFAULT '1',
98 `cargo_items` text NOT NULL,
99 `cargo_magazines` text NOT NULL,
100 `cargo_weapons` text NOT NULL,
101 `cargo_container` text NOT NULL,
102 `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
103 `pin_code` varchar(6) NOT NULL DEFAULT '000000',
104 `territory_id` int(11) unsigned DEFAULT NULL,
105 `deleted_at` datetime DEFAULT NULL,
106 `money` int(11) unsigned NOT NULL DEFAULT '0',
107 `abandoned` datetime DEFAULT NULL,
108 PRIMARY KEY (`id`),
109 KEY `account_uid` (`account_uid`),
110 KEY `territory_id` (`territory_id`),
111 CONSTRAINT `container_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
112 CONSTRAINT `container_ibfk_2` FOREIGN KEY (`territory_id`) REFERENCES `territory` (`id`) ON DELETE CASCADE
113 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT 0 row(s) affected, 2 warning(s):
114 3719 'utf8' is currently an alias for the character set UTF8MB3, which will be replaced by UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
115 1050 Table 'container' already exists 0.000 sec
1161 12 10:29:18 CREATE TABLE IF NOT EXISTS `player` (
117 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
118 `name` varchar(64) NOT NULL,
119 `account_uid` varchar(32) NOT NULL,
120 `money` int(11) unsigned NOT NULL DEFAULT '0',
121 `damage` double unsigned NOT NULL DEFAULT '0',
122 `hunger` double unsigned NOT NULL DEFAULT '100',
123 `thirst` double unsigned NOT NULL DEFAULT '100',
124 `alcohol` double unsigned NOT NULL DEFAULT '0',
125 `temperature` double NOT NULL DEFAULT '37',
126 `wetness` double unsigned NOT NULL DEFAULT '0',
127 `oxygen_remaining` double unsigned NOT NULL DEFAULT '1',
128 `bleeding_remaining` double unsigned NOT NULL DEFAULT '0',
129 `hitpoints` varchar(1024) NOT NULL DEFAULT '[]',
130 `direction` double NOT NULL DEFAULT '0',
131 `position_x` double NOT NULL DEFAULT '0',
132 `position_y` double NOT NULL DEFAULT '0',
133 `position_z` double NOT NULL DEFAULT '0',
134 `spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
135 `assigned_items` text NOT NULL,
136 `backpack` varchar(64) NOT NULL,
137 `backpack_items` text NOT NULL,
138 `backpack_magazines` text NOT NULL,
139 `backpack_weapons` text NOT NULL,
140 `current_weapon` varchar(64) NOT NULL,
141 `goggles` varchar(64) NOT NULL,
142 `handgun_items` text NOT NULL,
143 `handgun_weapon` varchar(64) NOT NULL,
144 `headgear` varchar(64) NOT NULL,
145 `binocular` varchar(64) NOT NULL,
146 `loaded_magazines` text NOT NULL,
147 `primary_weapon` varchar(64) NOT NULL,
148 `primary_weapon_items` text NOT NULL,
149 `secondary_weapon` varchar(64) NOT NULL,
150 `secondary_weapon_items` text NOT NULL,
151 `uniform` varchar(64) NOT NULL,
152 `uniform_items` text NOT NULL,
153 `uniform_magazines` text NOT NULL,
154 `uniform_weapons` text NOT NULL,
155 `vest` varchar(64) NOT NULL,
156 `vest_items` text NOT NULL,
157 `vest_magazines` text NOT NULL,
158 `vest_weapons` text NOT NULL,
159 `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
160 PRIMARY KEY (`id`),
161 KEY `player_uid` (`account_uid`),
162 CONSTRAINT `player_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE
163 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 0 row(s) affected, 2 warning(s):
164 3719 'utf8' is currently an alias for the character set UTF8MB3, which will be replaced by UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
165 1050 Table 'player' already exists 0.000 sec
1661 13 10:29:18 CREATE TABLE IF NOT EXISTS `player_history` (
167 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
168 `account_uid` varchar(32) NOT NULL,
169 `name` varchar(64) NOT NULL,
170 `died_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
171 `position_x` double NOT NULL,
172 `position_y` double NOT NULL,
173 `position_z` double NOT NULL,
174 PRIMARY KEY (`id`)
175 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 0 row(s) affected, 2 warning(s):
176 3719 'utf8' is currently an alias for the character set UTF8MB3, which will be replaced by UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
177 1050 Table 'player_history' already exists 0.000 sec
1781 14 10:29:18 CREATE TABLE IF NOT EXISTS `territory` (
179 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
180 `owner_uid` varchar(32) NOT NULL,
181 `name` varchar(64) NOT NULL,
182 `position_x` double NOT NULL,
183 `position_y` double NOT NULL,
184 `position_z` double NOT NULL,
185 `radius` double NOT NULL,
186 `level` int(11) NOT NULL,
187 `flag_texture` varchar(255) NOT NULL,
188 `flag_stolen` tinyint(1) NOT NULL DEFAULT '0',
189 `flag_stolen_by_uid` varchar(32) DEFAULT NULL,
190 `flag_stolen_at` datetime DEFAULT NULL,
191 `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
192 `last_paid_at` datetime DEFAULT CURRENT_TIMESTAMP,
193 `xm8_protectionmoney_notified` tinyint(1) NOT NULL DEFAULT '0',
194 `build_rights` varchar(640) NOT NULL DEFAULT '0',
195 `moderators` varchar(320) NOT NULL DEFAULT '0',
196 `deleted_at` datetime DEFAULT NULL,
197 PRIMARY KEY (`id`),
198 KEY `owner_uid` (`owner_uid`),
199 KEY `flag_stolen_by_uid` (`flag_stolen_by_uid`),
200 CONSTRAINT `territory_ibfk_1` FOREIGN KEY (`owner_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
201 CONSTRAINT `territory_ibfk_2` FOREIGN KEY (`flag_stolen_by_uid`) REFERENCES `account` (`uid`) ON DELETE SET NULL
202 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 0 row(s) affected, 2 warning(s):
203 3719 'utf8' is currently an alias for the character set UTF8MB3, which will be replaced by UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
204 1050 Table 'territory' already exists 0.000 sec
2051 15 10:29:18 CREATE TABLE IF NOT EXISTS `vehicle` (
206 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
207 `class` varchar(64) NOT NULL,
208 `spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
209 `account_uid` varchar(32) DEFAULT NULL,
210 `is_locked` tinyint(1) NOT NULL DEFAULT '0',
211 `fuel` double unsigned NOT NULL DEFAULT '0',
212 `damage` double unsigned NOT NULL DEFAULT '0',
213 `hitpoints` text NOT NULL,
214 `position_x` double NOT NULL DEFAULT '0',
215 `position_y` double NOT NULL DEFAULT '0',
216 `position_z` double NOT NULL DEFAULT '0',
217 `direction_x` double NOT NULL DEFAULT '0',
218 `direction_y` double NOT NULL DEFAULT '0',
219 `direction_z` double NOT NULL DEFAULT '0',
220 `up_x` double NOT NULL DEFAULT '0',
221 `up_y` double NOT NULL DEFAULT '0',
222 `up_z` double NOT NULL DEFAULT '1',
223 `cargo_items` text NOT NULL,
224 `cargo_magazines` text NOT NULL,
225 `cargo_weapons` text NOT NULL,
226 `cargo_container` text NOT NULL,
227 `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
228 `pin_code` varchar(6) NOT NULL DEFAULT '000000',
229 `deleted_at` datetime DEFAULT NULL,
230 `money` int(11) unsigned NOT NULL DEFAULT '0',
231 `vehicle_texture` text NOT NULL,
232 `territory_id` int(11) unsigned DEFAULT NULL,
233 `nickname` varchar(64) NOT NULL DEFAULT '',
234 PRIMARY KEY (`id`),
235 KEY `account_uid` (`account_uid`),
236 KEY `vehicle_ibfk_2_idx` (`territory_id`),
237 CONSTRAINT `vehicle_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE,
238 CONSTRAINT `vehicle_ibfk_2` FOREIGN KEY (`territory_id`) REFERENCES `territory` (`id`) ON DELETE CASCADE
239 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 0 row(s) affected, 2 warning(s):
240 3719 'utf8' is currently an alias for the character set UTF8MB3, which will be replaced by UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
241 1050 Table 'vehicle' already exists 0.000 sec
2423 16 10:29:18 /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */ 0 row(s) affected 0.000 sec
2433 17 10:29:19 /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */ 0 row(s) affected 0.000 sec
2443 18 10:29:19 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */ 0 row(s) affected 0.000 sec