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