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