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