· 8 years ago · Apr 06, 2018, 07:58 PM
1-- MySQL Script generated by MySQL Workbench
2-- 07/02/17 20:36:17
3-- Model: A3Wasteland DB Version: 2.06
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema a3wasteland
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema a3wasteland
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `a3wasteland` DEFAULT CHARACTER SET latin1 ;
18USE `a3wasteland` ;
19
20ALTER SCHEMA DEFAULT CHARACTER SET latin1 ;
21
22-- -----------------------------------------------------
23-- Table `ServerInstance`
24-- -----------------------------------------------------
25CREATE TABLE IF NOT EXISTS `ServerInstance` (
26 `ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
27 `WarchestMoneyBLUFOR` FLOAT NOT NULL DEFAULT 0,
28 `WarchestMoneyOPFOR` FLOAT NOT NULL DEFAULT 0,
29 PRIMARY KEY (`ID`))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `AdminLog`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `AdminLog` (
37 `ServerID` INT UNSIGNED NOT NULL,
38 `Time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
39 `PlayerName` VARCHAR(256) CHARACTER SET 'utf8' NOT NULL,
40 `PlayerUID` VARCHAR(32) NOT NULL,
41 `BattlEyeGUID` VARCHAR(32) NULL,
42 `ActionType` VARCHAR(128) NOT NULL,
43 `ActionValue` VARCHAR(1024) NOT NULL,
44 INDEX `fk_AdminLog_ServerInstance_idx` (`ServerID` ASC),
45 CONSTRAINT `fk_AdminLog_ServerInstance`
46 FOREIGN KEY (`ServerID`)
47 REFERENCES `ServerInstance` (`ID`)
48 ON DELETE NO ACTION
49 ON UPDATE NO ACTION)
50ENGINE = InnoDB;
51
52
53-- -----------------------------------------------------
54-- Table `AntihackLog`
55-- -----------------------------------------------------
56CREATE TABLE IF NOT EXISTS `AntihackLog` (
57 `EntryID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
58 `ServerID` INT UNSIGNED NOT NULL,
59 `Time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
60 `PlayerName` VARCHAR(256) CHARACTER SET 'utf8' NOT NULL,
61 `PlayerUID` VARCHAR(32) NOT NULL,
62 `BattlEyeGUID` VARCHAR(32) NULL,
63 `HackType` VARCHAR(128) NOT NULL,
64 `HackValue` VARCHAR(1024) CHARACTER SET 'utf8' NOT NULL,
65 `KickOnJoin` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
66 `AdminNote` VARCHAR(4096) CHARACTER SET 'utf8' NULL,
67 INDEX `fk_AntihackLog_ServerInstance_idx` (`ServerID` ASC),
68 INDEX `idx_AntihackLog_kickOnJoin` (`PlayerUID` ASC, `KickOnJoin` DESC),
69 PRIMARY KEY (`EntryID`),
70 CONSTRAINT `fk_AntihackLog_ServerInstance`
71 FOREIGN KEY (`ServerID`)
72 REFERENCES `ServerInstance` (`ID`)
73 ON DELETE NO ACTION
74 ON UPDATE NO ACTION)
75ENGINE = InnoDB;
76
77
78-- -----------------------------------------------------
79-- Table `DBInfo`
80-- -----------------------------------------------------
81CREATE TABLE IF NOT EXISTS `DBInfo` (
82 `Name` VARCHAR(128) NOT NULL,
83 `Value` VARCHAR(1024) NOT NULL,
84 PRIMARY KEY (`Name`))
85ENGINE = InnoDB;
86
87
88-- -----------------------------------------------------
89-- Table `PlayerInfo`
90-- -----------------------------------------------------
91CREATE TABLE IF NOT EXISTS `PlayerInfo` (
92 `UID` VARCHAR(32) NOT NULL,
93 `BattlEyeGUID` VARCHAR(32) NULL,
94 `CreationDate` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
95 `Name` VARCHAR(256) CHARACTER SET 'utf8' NULL,
96 `LastSide` VARCHAR(32) NULL,
97 PRIMARY KEY (`UID`))
98ENGINE = InnoDB;
99
100
101-- -----------------------------------------------------
102-- Table `ServerMap`
103-- -----------------------------------------------------
104CREATE TABLE IF NOT EXISTS `ServerMap` (
105 `ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
106 `WorldName` VARCHAR(128) NOT NULL,
107 `Environment` VARCHAR(128) NOT NULL,
108 PRIMARY KEY (`ID`),
109 UNIQUE INDEX `idx_ServerMap_uniqueWorldEnv` (`WorldName` ASC, `Environment` ASC))
110ENGINE = InnoDB;
111
112
113-- -----------------------------------------------------
114-- Table `PlayerSave`
115-- -----------------------------------------------------
116CREATE TABLE IF NOT EXISTS `PlayerSave` (
117 `PlayerUID` VARCHAR(32) NOT NULL,
118 `MapID` INT UNSIGNED NOT NULL,
119 `CreationDate` TIMESTAMP NULL,
120 `LastModified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
121 `LastServerID` INT UNSIGNED NULL,
122 `Position` VARCHAR(256) NOT NULL DEFAULT '[]',
123 `Direction` FLOAT NOT NULL DEFAULT 0,
124 `Damage` FLOAT NOT NULL DEFAULT 0,
125 `HitPoints` VARCHAR(1024) NOT NULL DEFAULT '[]',
126 `Hunger` FLOAT NOT NULL DEFAULT 100,
127 `Thirst` FLOAT NOT NULL DEFAULT 100,
128 `Money` INT UNSIGNED NOT NULL DEFAULT 0,
129 `CurrentWeapon` VARCHAR(128) NOT NULL DEFAULT '\"\"',
130 `Stance` VARCHAR(128) NOT NULL DEFAULT '\"\"',
131 `Headgear` VARCHAR(128) NOT NULL DEFAULT '\"\"',
132 `Goggles` VARCHAR(128) NOT NULL DEFAULT '\"\"',
133 `Uniform` VARCHAR(128) NOT NULL DEFAULT '\"\"',
134 `Vest` VARCHAR(128) NOT NULL DEFAULT '\"\"',
135 `Backpack` VARCHAR(128) NOT NULL DEFAULT '\"\"',
136 `UniformWeapons` VARCHAR(1024) NOT NULL DEFAULT '[]',
137 `UniformItems` VARCHAR(4096) NOT NULL DEFAULT '[]',
138 `UniformMagazines` VARCHAR(4096) NOT NULL DEFAULT '[]',
139 `VestWeapons` VARCHAR(1024) NOT NULL DEFAULT '[]',
140 `VestItems` VARCHAR(4096) NOT NULL DEFAULT '[]',
141 `VestMagazines` VARCHAR(4096) NOT NULL DEFAULT '[]',
142 `BackpackWeapons` VARCHAR(2048) NOT NULL DEFAULT '[]',
143 `BackpackItems` VARCHAR(4096) NOT NULL DEFAULT '[]',
144 `BackpackMagazines` VARCHAR(4096) NOT NULL DEFAULT '[]',
145 `PrimaryWeapon` VARCHAR(128) NOT NULL DEFAULT '\"\"',
146 `SecondaryWeapon` VARCHAR(128) NOT NULL DEFAULT '\"\"',
147 `HandgunWeapon` VARCHAR(128) NOT NULL DEFAULT '\"\"',
148 `PrimaryWeaponItems` VARCHAR(512) NOT NULL DEFAULT '[]',
149 `SecondaryWeaponItems` VARCHAR(512) NOT NULL DEFAULT '[]',
150 `HandgunItems` VARCHAR(512) NOT NULL DEFAULT '[]',
151 `AssignedItems` VARCHAR(512) NOT NULL DEFAULT '[]',
152 `LoadedMagazines` VARCHAR(1024) NOT NULL DEFAULT '[]',
153 `WastelandItems` VARCHAR(1024) NOT NULL DEFAULT '[]',
154 INDEX `fk_PlayerSave_ServerMap_idx` (`MapID` ASC),
155 INDEX `fk_PlayerSave_ServerInstance_idx` (`LastServerID` ASC),
156 UNIQUE INDEX `idx_PlayerSave_uniquePlayerMap` (`PlayerUID` ASC, `MapID` ASC),
157 INDEX `idx_PlayerSave_crossMap` (`PlayerUID` ASC, `LastModified` DESC),
158 CONSTRAINT `fk_PlayerSave_PlayerInfo`
159 FOREIGN KEY (`PlayerUID`)
160 REFERENCES `PlayerInfo` (`UID`)
161 ON DELETE NO ACTION
162 ON UPDATE NO ACTION,
163 CONSTRAINT `fk_PlayerSave_ServerMap`
164 FOREIGN KEY (`MapID`)
165 REFERENCES `ServerMap` (`ID`)
166 ON DELETE NO ACTION
167 ON UPDATE NO ACTION,
168 CONSTRAINT `fk_PlayerSave_ServerInstance`
169 FOREIGN KEY (`LastServerID`)
170 REFERENCES `ServerInstance` (`ID`)
171 ON DELETE NO ACTION
172 ON UPDATE NO ACTION)
173ENGINE = InnoDB;
174
175
176-- -----------------------------------------------------
177-- Table `ServerObjects`
178-- -----------------------------------------------------
179CREATE TABLE IF NOT EXISTS `ServerObjects` (
180 `ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
181 `ServerID` INT UNSIGNED NOT NULL,
182 `MapID` INT UNSIGNED NOT NULL,
183 `CreationDate` TIMESTAMP NULL,
184 `LastInteraction` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
185 `OwnerUID` VARCHAR(32) NOT NULL DEFAULT '\"\"',
186 `Class` VARCHAR(128) NOT NULL DEFAULT 'nil',
187 `Position` VARCHAR(256) NOT NULL DEFAULT 'nil',
188 `Direction` VARCHAR(256) NOT NULL DEFAULT '[]',
189 `Locked` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
190 `Deployable` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
191 `Damage` FLOAT NOT NULL DEFAULT 0,
192 `AllowDamage` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
193 `Variables` VARCHAR(4096) NOT NULL DEFAULT '[]',
194 `Weapons` VARCHAR(4096) NOT NULL DEFAULT '[]',
195 `Magazines` VARCHAR(4096) NOT NULL DEFAULT '[]',
196 `Items` VARCHAR(4096) NOT NULL DEFAULT '[]',
197 `Backpacks` VARCHAR(4096) NOT NULL DEFAULT '[]',
198 `TurretMagazines` VARCHAR(4096) NOT NULL DEFAULT '[]',
199 `AmmoCargo` FLOAT NOT NULL DEFAULT 0,
200 `FuelCargo` FLOAT NOT NULL DEFAULT 0,
201 `RepairCargo` FLOAT NOT NULL DEFAULT 0,
202 PRIMARY KEY (`ID`),
203 INDEX `fk_ServerObjects_ServerInstance_idx` (`ServerID` ASC),
204 INDEX `fk_ServerObjects_ServerMap_idx` (`MapID` ASC),
205 CONSTRAINT `fk_ServerObjects_ServerInstance`
206 FOREIGN KEY (`ServerID`)
207 REFERENCES `ServerInstance` (`ID`)
208 ON DELETE NO ACTION
209 ON UPDATE NO ACTION,
210 CONSTRAINT `fk_ServerObjects_ServerMap`
211 FOREIGN KEY (`MapID`)
212 REFERENCES `ServerMap` (`ID`)
213 ON DELETE NO ACTION
214 ON UPDATE NO ACTION)
215ENGINE = InnoDB;
216
217
218-- -----------------------------------------------------
219-- Table `ServerVehicles`
220-- -----------------------------------------------------
221CREATE TABLE IF NOT EXISTS `ServerVehicles` (
222 `ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
223 `ServerID` INT UNSIGNED NOT NULL,
224 `MapID` INT UNSIGNED NOT NULL,
225 `CreationDate` TIMESTAMP NULL,
226 `LastUsed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
227 `OwnerUID` VARCHAR(32) NOT NULL DEFAULT '\"\"',
228 `Parked` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
229 `LockState` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
230 `Class` VARCHAR(128) NOT NULL DEFAULT 'nil',
231 `Position` VARCHAR(256) NOT NULL DEFAULT 'nil',
232 `Direction` VARCHAR(256) NOT NULL DEFAULT '[]',
233 `Velocity` VARCHAR(256) NOT NULL DEFAULT '[]',
234 `Flying` TINYINT(1) NOT NULL DEFAULT 0,
235 `Damage` FLOAT NOT NULL DEFAULT 0,
236 `Fuel` FLOAT NOT NULL DEFAULT 0,
237 `HitPoints` VARCHAR(4096) NOT NULL DEFAULT '[]',
238 `Variables` VARCHAR(4096) NOT NULL DEFAULT '[]',
239 `Textures` VARCHAR(4096) NOT NULL DEFAULT '[]',
240 `Weapons` VARCHAR(4096) NOT NULL DEFAULT '[]',
241 `Magazines` VARCHAR(4096) NOT NULL DEFAULT '[]',
242 `Items` VARCHAR(4096) NOT NULL DEFAULT '[]',
243 `Backpacks` VARCHAR(4096) NOT NULL DEFAULT '[]',
244 `TurretMagazines` VARCHAR(4096) NOT NULL DEFAULT '[]',
245 `TurretMagazines2` VARCHAR(4096) NOT NULL DEFAULT '[]',
246 `TurretMagazines3` VARCHAR(4096) NOT NULL DEFAULT '[]',
247 `AmmoCargo` FLOAT NOT NULL DEFAULT 0,
248 `FuelCargo` FLOAT NOT NULL DEFAULT 0,
249 `RepairCargo` FLOAT NOT NULL DEFAULT 0,
250 PRIMARY KEY (`ID`),
251 INDEX `fk_ServerVehicles_ServerInstance_idx` (`ServerID` ASC),
252 INDEX `fk_ServerVehicles_ServerMap_idx` (`MapID` ASC),
253 INDEX `idx_ServerVehicles_parkedOwners` (`OwnerUID` ASC, `Parked` DESC),
254 CONSTRAINT `fk_ServerVehicles_ServerInstance`
255 FOREIGN KEY (`ServerID`)
256 REFERENCES `ServerInstance` (`ID`)
257 ON DELETE NO ACTION
258 ON UPDATE NO ACTION,
259 CONSTRAINT `fk_ServerVehicles_ServerMap`
260 FOREIGN KEY (`MapID`)
261 REFERENCES `ServerMap` (`ID`)
262 ON DELETE NO ACTION
263 ON UPDATE NO ACTION)
264ENGINE = InnoDB;
265
266
267-- -----------------------------------------------------
268-- Table `PlayerStats`
269-- -----------------------------------------------------
270CREATE TABLE IF NOT EXISTS `PlayerStats` (
271 `PlayerUID` VARCHAR(32) NOT NULL,
272 `LastModified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
273 `PlayerKills` INT UNSIGNED NOT NULL DEFAULT 0,
274 `AIKills` INT UNSIGNED NOT NULL DEFAULT 0,
275 `TeamKills` INT UNSIGNED NOT NULL DEFAULT 0,
276 `DeathCount` INT UNSIGNED NOT NULL DEFAULT 0,
277 `ReviveCount` INT UNSIGNED NOT NULL DEFAULT 0,
278 `CaptureCount` INT UNSIGNED NOT NULL DEFAULT 0,
279 UNIQUE INDEX `idx_PlayerStats_uniquePlayer` (`PlayerUID` ASC),
280 CONSTRAINT `fk_PlayerStats_PlayerInfo`
281 FOREIGN KEY (`PlayerUID`)
282 REFERENCES `PlayerInfo` (`UID`)
283 ON DELETE NO ACTION
284 ON UPDATE NO ACTION)
285ENGINE = InnoDB;
286
287
288-- -----------------------------------------------------
289-- Table `PlayerStatsMap`
290-- -----------------------------------------------------
291CREATE TABLE IF NOT EXISTS `PlayerStatsMap` (
292 `PlayerUID` VARCHAR(32) NOT NULL,
293 `ServerID` INT UNSIGNED NOT NULL,
294 `MapID` INT UNSIGNED NOT NULL,
295 `LastModified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
296 `PlayerKills` INT UNSIGNED NOT NULL DEFAULT 0,
297 `AIKills` INT UNSIGNED NOT NULL DEFAULT 0,
298 `TeamKills` INT UNSIGNED NOT NULL DEFAULT 0,
299 `DeathCount` INT UNSIGNED NOT NULL DEFAULT 0,
300 `ReviveCount` INT UNSIGNED NOT NULL DEFAULT 0,
301 `CaptureCount` INT UNSIGNED NOT NULL DEFAULT 0,
302 INDEX `fk_PlayerStatsMap_ServerMap_idx` (`MapID` ASC),
303 INDEX `fk_PlayerStatsMap_ServerInstance_idx` (`ServerID` ASC),
304 UNIQUE INDEX `idx_PlayerStatsMap_uniquePlayer` (`PlayerUID` ASC, `ServerID` ASC, `MapID` ASC),
305 CONSTRAINT `fk_PlayerStatsMap_PlayerStats`
306 FOREIGN KEY (`PlayerUID`)
307 REFERENCES `PlayerStats` (`PlayerUID`)
308 ON DELETE NO ACTION
309 ON UPDATE NO ACTION,
310 CONSTRAINT `fk_PlayerStatsMap_ServerMap`
311 FOREIGN KEY (`MapID`)
312 REFERENCES `ServerMap` (`ID`)
313 ON DELETE NO ACTION
314 ON UPDATE NO ACTION,
315 CONSTRAINT `fk_PlayerStatsMap_ServerInstance`
316 FOREIGN KEY (`ServerID`)
317 REFERENCES `ServerInstance` (`ID`)
318 ON DELETE NO ACTION
319 ON UPDATE NO ACTION)
320ENGINE = InnoDB;
321
322
323-- -----------------------------------------------------
324-- Table `BankTransferLog`
325-- -----------------------------------------------------
326CREATE TABLE IF NOT EXISTS `BankTransferLog` (
327 `ServerID` INT UNSIGNED NOT NULL,
328 `Time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
329 `SenderName` VARCHAR(256) CHARACTER SET 'utf8' NOT NULL,
330 `SenderUID` VARCHAR(32) NOT NULL,
331 `SenderSide` VARCHAR(32) NULL,
332 `RecipientName` VARCHAR(256) CHARACTER SET 'utf8' NOT NULL,
333 `RecipientUID` VARCHAR(32) NOT NULL,
334 `RecipientSide` VARCHAR(32) NULL,
335 `Amount` FLOAT NOT NULL,
336 `Fee` FLOAT NOT NULL,
337 INDEX `fk_BankTransfers_ServerInstance_idx` (`ServerID` ASC),
338 CONSTRAINT `fk_BankTransfers_ServerInstance`
339 FOREIGN KEY (`ServerID`)
340 REFERENCES `ServerInstance` (`ID`)
341 ON DELETE NO ACTION
342 ON UPDATE NO ACTION)
343ENGINE = InnoDB;
344
345
346-- -----------------------------------------------------
347-- Table `ServerTime`
348-- -----------------------------------------------------
349CREATE TABLE IF NOT EXISTS `ServerTime` (
350 `ServerID` INT UNSIGNED NOT NULL,
351 `MapID` INT UNSIGNED NOT NULL,
352 `DayTime` FLOAT NULL,
353 `Fog` FLOAT NULL,
354 `Overcast` FLOAT NULL,
355 `Rain` FLOAT NULL,
356 `Wind` VARCHAR(128) NULL,
357 INDEX `fk_ServerTime_ServerInstance_idx` (`ServerID` ASC),
358 INDEX `fk_ServerTime_ServerMap_idx` (`MapID` ASC),
359 UNIQUE INDEX `idx_ServerTime_uniqueServerMap` (`ServerID` ASC, `MapID` ASC),
360 CONSTRAINT `fk_ServerTime_ServerInstance`
361 FOREIGN KEY (`ServerID`)
362 REFERENCES `ServerInstance` (`ID`)
363 ON DELETE NO ACTION
364 ON UPDATE NO ACTION,
365 CONSTRAINT `fk_ServerTime_ServerMap`
366 FOREIGN KEY (`MapID`)
367 REFERENCES `ServerMap` (`ID`)
368 ON DELETE NO ACTION
369 ON UPDATE NO ACTION)
370ENGINE = InnoDB;
371
372
373-- -----------------------------------------------------
374-- Table `ServerMines`
375-- -----------------------------------------------------
376CREATE TABLE IF NOT EXISTS `ServerMines` (
377 `ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
378 `ServerID` INT UNSIGNED NOT NULL,
379 `MapID` INT UNSIGNED NOT NULL,
380 `CreationDate` TIMESTAMP NULL,
381 `LastInteraction` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
382 `OwnerUID` VARCHAR(32) NOT NULL DEFAULT '\"\"',
383 `Class` VARCHAR(128) NOT NULL DEFAULT 'nil',
384 `Position` VARCHAR(256) NOT NULL DEFAULT 'nil',
385 `Direction` VARCHAR(256) NOT NULL DEFAULT '[]',
386 `Damage` FLOAT NOT NULL DEFAULT 0,
387 `Variables` VARCHAR(4096) NOT NULL DEFAULT '[]',
388 PRIMARY KEY (`ID`),
389 INDEX `fk_ServerMines_ServerInstance_idx` (`ServerID` ASC),
390 INDEX `fk_ServerMines_ServerMap_idx` (`MapID` ASC),
391 CONSTRAINT `fk_ServerMines_ServerInstance`
392 FOREIGN KEY (`ServerID`)
393 REFERENCES `ServerInstance` (`ID`)
394 ON DELETE NO ACTION
395 ON UPDATE NO ACTION,
396 CONSTRAINT `fk_ServerMines_ServerMap`
397 FOREIGN KEY (`MapID`)
398 REFERENCES `ServerMap` (`ID`)
399 ON DELETE NO ACTION
400 ON UPDATE NO ACTION)
401ENGINE = InnoDB;
402
403
404-- -----------------------------------------------------
405-- Table `PlayerStorage`
406-- -----------------------------------------------------
407CREATE TABLE IF NOT EXISTS `PlayerStorage` (
408 `PlayerUID` VARCHAR(32) NOT NULL,
409 `MapID` INT UNSIGNED NOT NULL,
410 `CreationDate` TIMESTAMP NULL,
411 `LastModified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
412 `Weapons` VARCHAR(4096) NOT NULL DEFAULT '[]',
413 `Magazines` VARCHAR(4096) NOT NULL DEFAULT '[]',
414 `Items` VARCHAR(4096) NOT NULL DEFAULT '[]',
415 `Backpacks` VARCHAR(4096) NOT NULL DEFAULT '[]',
416 INDEX `fk_PlayerStorage_ServerMap_idx` (`MapID` ASC),
417 UNIQUE INDEX `idx_PlayerStorage_uniquePlayerMap` (`PlayerUID` ASC, `MapID` ASC),
418 CONSTRAINT `fk_PlayerStorage_PlayerInfo`
419 FOREIGN KEY (`PlayerUID`)
420 REFERENCES `PlayerInfo` (`UID`)
421 ON DELETE NO ACTION
422 ON UPDATE NO ACTION,
423 CONSTRAINT `fk_PlayerStorage_ServerMap`
424 FOREIGN KEY (`MapID`)
425 REFERENCES `ServerMap` (`ID`)
426 ON DELETE NO ACTION
427 ON UPDATE NO ACTION)
428ENGINE = InnoDB;
429
430
431-- -----------------------------------------------------
432-- Table `PlayerStatus`
433-- -----------------------------------------------------
434CREATE TABLE IF NOT EXISTS `PlayerStatus` (
435 `PlayerUID` VARCHAR(32) NOT NULL,
436 `MapID` INT UNSIGNED NOT NULL,
437 `CreationDate` TIMESTAMP NULL,
438 `LastModified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
439 `BankMoney` INT UNSIGNED NOT NULL DEFAULT 0,
440 `Bounty` INT UNSIGNED NOT NULL DEFAULT 0,
441 `BountyKills` VARCHAR(8192) NOT NULL DEFAULT '[]',
442 INDEX `fk_PlayerStatus_PlayerInfo_idx` (`PlayerUID` ASC),
443 INDEX `fk_PlayerStatus_ServerMap_idx` (`MapID` ASC),
444 UNIQUE INDEX `idx_PlayerStatus_uniquePlayerMap` (`PlayerUID` ASC, `MapID` ASC),
445 INDEX `idx_PlayerStatus_crossMap` (`PlayerUID` ASC, `LastModified` ASC),
446 CONSTRAINT `fk_PlayerStatus_PlayerInfo`
447 FOREIGN KEY (`PlayerUID`)
448 REFERENCES `PlayerInfo` (`UID`)
449 ON DELETE NO ACTION
450 ON UPDATE NO ACTION,
451 CONSTRAINT `fk_PlayerStatus_ServerMap`
452 FOREIGN KEY (`MapID`)
453 REFERENCES `ServerMap` (`ID`)
454 ON DELETE NO ACTION
455 ON UPDATE NO ACTION)
456ENGINE = InnoDB;
457
458
459SET SQL_MODE=@OLD_SQL_MODE;
460SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
461SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
462
463-- -----------------------------------------------------
464-- Data for table `DBInfo`
465-- -----------------------------------------------------
466START TRANSACTION;
467USE `a3wasteland`;
468INSERT INTO `DBInfo` (`Name`, `Value`) VALUES ('Version', '2.06');
469
470COMMIT;