Skip to content

Instantly share code, notes, and snippets.

@AgentRev

AgentRev/a3wasteland_db_v2.05.sql

Created June 26, 2016 23:12
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save AgentRev/50dee5734fde6444b6d28f4d97426ea9 to your computer and use it in GitHub Desktop.
Save AgentRev/50dee5734fde6444b6d28f4d97426ea9 to your computer and use it in GitHub Desktop.
Download ZIP
A3W MySQL DB v2.05
Raw
a3wasteland_db_v2.05.sql
-- MySQL Script generated by MySQL Workbench
-- 06/26/16 19:07:56
-- Model: A3Wasteland DB Version: 2.05
-- MySQL Workbench Forward Engineering
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
-- -----------------------------------------------------
-- Schema a3wasteland
-- -----------------------------------------------------
-- -----------------------------------------------------
-- Schema a3wasteland
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `a3wasteland` DEFAULT CHARACTER SET latin1 ;
USE `a3wasteland` ;
ALTER SCHEMA DEFAULT CHARACTER SET latin1 ;
-- -----------------------------------------------------
-- Table `ServerInstance`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ServerInstance` (
`ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`WarchestMoneyBLUFOR` FLOAT NOT NULL DEFAULT 0,
`WarchestMoneyOPFOR` FLOAT NOT NULL DEFAULT 0,
PRIMARY KEY (`ID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `AdminLog`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `AdminLog` (
`ServerID` INT UNSIGNED NOT NULL,
`Time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`PlayerName` VARCHAR(256) CHARACTER SET 'utf8' NOT NULL,
`PlayerUID` VARCHAR(32) NOT NULL,
`BattlEyeGUID` VARCHAR(32) NULL,
`ActionType` VARCHAR(128) NOT NULL,
`ActionValue` VARCHAR(1024) NOT NULL,
INDEX `fk_AdminLog_ServerInstance_idx` (`ServerID` ASC),
CONSTRAINT `fk_AdminLog_ServerInstance`
FOREIGN KEY (`ServerID`)
REFERENCES `ServerInstance` (`ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `AntihackLog`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `AntihackLog` (
`ServerID` INT UNSIGNED NOT NULL,
`Time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`PlayerName` VARCHAR(256) CHARACTER SET 'utf8' NOT NULL,
`PlayerUID` VARCHAR(32) NOT NULL,
`BattlEyeGUID` VARCHAR(32) NULL,
`HackType` VARCHAR(128) NOT NULL,
`HackValue` VARCHAR(1024) CHARACTER SET 'utf8' NOT NULL,
`KickOnJoin` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
`AdminNote` VARCHAR(4096) CHARACTER SET 'utf8' NULL,
INDEX `fk_AntihackLog_ServerInstance_idx` (`ServerID` ASC),
INDEX `idx_AntihackLog_kickOnJoin` (`PlayerUID` ASC, `KickOnJoin` DESC),
CONSTRAINT `fk_AntihackLog_ServerInstance`
FOREIGN KEY (`ServerID`)
REFERENCES `ServerInstance` (`ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `DBInfo`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `DBInfo` (
`Name` VARCHAR(128) NOT NULL,
`Value` VARCHAR(1024) NOT NULL,
PRIMARY KEY (`Name`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `PlayerInfo`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `PlayerInfo` (
`UID` VARCHAR(32) NOT NULL,
`BattlEyeGUID` VARCHAR(32) NULL,
`CreationDate` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
`Name` VARCHAR(256) CHARACTER SET 'utf8' NULL,
`LastSide` VARCHAR(32) NULL,
`BankMoney` FLOAT NOT NULL DEFAULT 0,
`Bounty` INT UNSIGNED NOT NULL DEFAULT 0,
`BountyKills` VARCHAR(8192) NOT NULL DEFAULT '[]',
PRIMARY KEY (`UID`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `ServerMap`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ServerMap` (
`ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`WorldName` VARCHAR(128) NOT NULL,
`Environment` VARCHAR(128) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE INDEX `idx_ServerMap_uniqueWorldEnv` (`WorldName` ASC, `Environment` ASC))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `PlayerSave`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `PlayerSave` (
`PlayerUID` VARCHAR(32) NOT NULL,
`MapID` INT UNSIGNED NOT NULL,
`CreationDate` TIMESTAMP NULL,
`LastModified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`LastServerID` INT UNSIGNED NULL,
`Position` VARCHAR(256) NOT NULL DEFAULT '[]',
`Direction` FLOAT NOT NULL DEFAULT 0,
`Damage` FLOAT NOT NULL DEFAULT 0,
`HitPoints` VARCHAR(1024) NOT NULL DEFAULT '[]',
`Hunger` FLOAT NOT NULL DEFAULT 100,
`Thirst` FLOAT NOT NULL DEFAULT 100,
`Money` FLOAT NOT NULL DEFAULT 0,
`CurrentWeapon` VARCHAR(128) NOT NULL DEFAULT '\"\"',
`Stance` VARCHAR(128) NOT NULL DEFAULT '\"\"',
`Headgear` VARCHAR(128) NOT NULL DEFAULT '\"\"',
`Goggles` VARCHAR(128) NOT NULL DEFAULT '\"\"',
`Uniform` VARCHAR(128) NOT NULL DEFAULT '\"\"',
`Vest` VARCHAR(128) NOT NULL DEFAULT '\"\"',
`Backpack` VARCHAR(128) NOT NULL DEFAULT '\"\"',
`UniformWeapons` VARCHAR(1024) NOT NULL DEFAULT '[]',
`UniformItems` VARCHAR(4096) NOT NULL DEFAULT '[]',
`UniformMagazines` VARCHAR(4096) NOT NULL DEFAULT '[]',
`VestWeapons` VARCHAR(1024) NOT NULL DEFAULT '[]',
`VestItems` VARCHAR(4096) NOT NULL DEFAULT '[]',
`VestMagazines` VARCHAR(4096) NOT NULL DEFAULT '[]',
`BackpackWeapons` VARCHAR(2048) NOT NULL DEFAULT '[]',
`BackpackItems` VARCHAR(4096) NOT NULL DEFAULT '[]',
`BackpackMagazines` VARCHAR(4096) NOT NULL DEFAULT '[]',
`PrimaryWeapon` VARCHAR(128) NOT NULL DEFAULT '\"\"',
`SecondaryWeapon` VARCHAR(128) NOT NULL DEFAULT '\"\"',
`HandgunWeapon` VARCHAR(128) NOT NULL DEFAULT '\"\"',
`PrimaryWeaponItems` VARCHAR(512) NOT NULL DEFAULT '[]',
`SecondaryWeaponItems` VARCHAR(512) NOT NULL DEFAULT '[]',
`HandgunItems` VARCHAR(512) NOT NULL DEFAULT '[]',
`AssignedItems` VARCHAR(512) NOT NULL DEFAULT '[]',
`LoadedMagazines` VARCHAR(1024) NOT NULL DEFAULT '[]',
`WastelandItems` VARCHAR(1024) NOT NULL DEFAULT '[]',
INDEX `fk_PlayerSave_ServerMap_idx` (`MapID` ASC),
INDEX `fk_PlayerSave_ServerInstance_idx` (`LastServerID` ASC),
UNIQUE INDEX `idx_PlayerSave_uniquePlayerMap` (`PlayerUID` ASC, `MapID` ASC),
INDEX `idx_PlayerSave_crossMap` (`PlayerUID` ASC, `LastModified` DESC),
CONSTRAINT `fk_PlayerSave_PlayerInfo`
FOREIGN KEY (`PlayerUID`)
REFERENCES `PlayerInfo` (`UID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_PlayerSave_ServerMap`
FOREIGN KEY (`MapID`)
REFERENCES `ServerMap` (`ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_PlayerSave_ServerInstance`
FOREIGN KEY (`LastServerID`)
REFERENCES `ServerInstance` (`ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `ServerObjects`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ServerObjects` (
`ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`ServerID` INT UNSIGNED NOT NULL,
`MapID` INT UNSIGNED NOT NULL,
`CreationDate` TIMESTAMP NULL,
`LastInteraction` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`OwnerUID` VARCHAR(32) NOT NULL DEFAULT '\"\"',
`Class` VARCHAR(128) NOT NULL DEFAULT 'nil',
`Position` VARCHAR(256) NOT NULL DEFAULT 'nil',
`Direction` VARCHAR(256) NOT NULL DEFAULT '[]',
`Locked` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
`Deployable` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
`Damage` FLOAT NOT NULL DEFAULT 0,
`AllowDamage` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
`Variables` VARCHAR(4096) NOT NULL DEFAULT '[]',
`Weapons` VARCHAR(4096) NOT NULL DEFAULT '[]',
`Magazines` VARCHAR(4096) NOT NULL DEFAULT '[]',
`Items` VARCHAR(4096) NOT NULL DEFAULT '[]',
`Backpacks` VARCHAR(4096) NOT NULL DEFAULT '[]',
`TurretMagazines` VARCHAR(4096) NOT NULL DEFAULT '[]',
`AmmoCargo` FLOAT NOT NULL DEFAULT 0,
`FuelCargo` FLOAT NOT NULL DEFAULT 0,
`RepairCargo` FLOAT NOT NULL DEFAULT 0,
PRIMARY KEY (`ID`),
INDEX `fk_ServerObjects_ServerInstance_idx` (`ServerID` ASC),
INDEX `fk_ServerObjects_ServerMap_idx` (`MapID` ASC),
CONSTRAINT `fk_ServerObjects_ServerInstance`
FOREIGN KEY (`ServerID`)
REFERENCES `ServerInstance` (`ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_ServerObjects_ServerMap`
FOREIGN KEY (`MapID`)
REFERENCES `ServerMap` (`ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `ServerVehicles`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ServerVehicles` (
`ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`ServerID` INT UNSIGNED NOT NULL,
`MapID` INT UNSIGNED NOT NULL,
`CreationDate` TIMESTAMP NULL,
`LastUsed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`OwnerUID` VARCHAR(32) NOT NULL DEFAULT '\"\"',
`Parked` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
`LockState` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
`Class` VARCHAR(128) NOT NULL DEFAULT 'nil',
`Position` VARCHAR(256) NOT NULL DEFAULT 'nil',
`Direction` VARCHAR(256) NOT NULL DEFAULT '[]',
`Velocity` VARCHAR(256) NOT NULL DEFAULT '[]',
`Flying` TINYINT(1) NOT NULL DEFAULT 0,
`Damage` FLOAT NOT NULL DEFAULT 0,
`Fuel` FLOAT NOT NULL DEFAULT 0,
`HitPoints` VARCHAR(4096) NOT NULL DEFAULT '[]',
`Variables` VARCHAR(4096) NOT NULL DEFAULT '[]',
`Textures` VARCHAR(4096) NOT NULL DEFAULT '[]',
`Weapons` VARCHAR(4096) NOT NULL DEFAULT '[]',
`Magazines` VARCHAR(4096) NOT NULL DEFAULT '[]',
`Items` VARCHAR(4096) NOT NULL DEFAULT '[]',
`Backpacks` VARCHAR(4096) NOT NULL DEFAULT '[]',
`TurretMagazines` VARCHAR(4096) NOT NULL DEFAULT '[]',
`TurretMagazines2` VARCHAR(4096) NOT NULL DEFAULT '[]',
`TurretMagazines3` VARCHAR(4096) NOT NULL DEFAULT '[]',
`AmmoCargo` FLOAT NOT NULL DEFAULT 0,
`FuelCargo` FLOAT NOT NULL DEFAULT 0,
`RepairCargo` FLOAT NOT NULL DEFAULT 0,
PRIMARY KEY (`ID`),
INDEX `fk_ServerVehicles_ServerInstance_idx` (`ServerID` ASC),
INDEX `fk_ServerVehicles_ServerMap_idx` (`MapID` ASC),
INDEX `idx_ServerVehicles_parkedOwners` (`OwnerUID` ASC, `Parked` DESC),
CONSTRAINT `fk_ServerVehicles_ServerInstance`
FOREIGN KEY (`ServerID`)
REFERENCES `ServerInstance` (`ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_ServerVehicles_ServerMap`
FOREIGN KEY (`MapID`)
REFERENCES `ServerMap` (`ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `PlayerStats`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `PlayerStats` (
`PlayerUID` VARCHAR(32) NOT NULL,
`LastModified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`PlayerKills` INT UNSIGNED NOT NULL DEFAULT 0,
`AIKills` INT UNSIGNED NOT NULL DEFAULT 0,
`TeamKills` INT UNSIGNED NOT NULL DEFAULT 0,
`DeathCount` INT UNSIGNED NOT NULL DEFAULT 0,
`ReviveCount` INT UNSIGNED NOT NULL DEFAULT 0,
`CaptureCount` INT UNSIGNED NOT NULL DEFAULT 0,
UNIQUE INDEX `idx_PlayerStats_uniquePlayer` (`PlayerUID` ASC),
CONSTRAINT `fk_PlayerStats_PlayerInfo`
FOREIGN KEY (`PlayerUID`)
REFERENCES `PlayerInfo` (`UID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `PlayerStatsMap`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `PlayerStatsMap` (
`PlayerUID` VARCHAR(32) NOT NULL,
`ServerID` INT UNSIGNED NOT NULL,
`MapID` INT UNSIGNED NOT NULL,
`LastModified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`PlayerKills` INT UNSIGNED NOT NULL DEFAULT 0,
`AIKills` INT UNSIGNED NOT NULL DEFAULT 0,
`TeamKills` INT UNSIGNED NOT NULL DEFAULT 0,
`DeathCount` INT UNSIGNED NOT NULL DEFAULT 0,
`ReviveCount` INT UNSIGNED NOT NULL DEFAULT 0,
`CaptureCount` INT UNSIGNED NOT NULL DEFAULT 0,
INDEX `fk_PlayerStatsMap_ServerMap_idx` (`MapID` ASC),
INDEX `fk_PlayerStatsMap_ServerInstance_idx` (`ServerID` ASC),
UNIQUE INDEX `idx_PlayerStatsMap_uniquePlayer` (`PlayerUID` ASC, `ServerID` ASC, `MapID` ASC),
CONSTRAINT `fk_PlayerStatsMap_PlayerStats`
FOREIGN KEY (`PlayerUID`)
REFERENCES `PlayerStats` (`PlayerUID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_PlayerStatsMap_ServerMap`
FOREIGN KEY (`MapID`)
REFERENCES `ServerMap` (`ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_PlayerStatsMap_ServerInstance`
FOREIGN KEY (`ServerID`)
REFERENCES `ServerInstance` (`ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `BankTransferLog`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BankTransferLog` (
`ServerID` INT UNSIGNED NOT NULL,
`Time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`SenderName` VARCHAR(256) CHARACTER SET 'utf8' NOT NULL,
`SenderUID` VARCHAR(32) NOT NULL,
`SenderSide` VARCHAR(32) NULL,
`RecipientName` VARCHAR(256) CHARACTER SET 'utf8' NOT NULL,
`RecipientUID` VARCHAR(32) NOT NULL,
`RecipientSide` VARCHAR(32) NULL,
`Amount` FLOAT NOT NULL,
`Fee` FLOAT NOT NULL,
INDEX `fk_BankTransfers_ServerInstance_idx` (`ServerID` ASC),
CONSTRAINT `fk_BankTransfers_ServerInstance`
FOREIGN KEY (`ServerID`)
REFERENCES `ServerInstance` (`ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `ServerTime`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ServerTime` (
`ServerID` INT UNSIGNED NOT NULL,
`MapID` INT UNSIGNED NOT NULL,
`DayTime` FLOAT NULL,
`Fog` FLOAT NULL,
`Overcast` FLOAT NULL,
`Rain` FLOAT NULL,
`Wind` VARCHAR(128) NULL,
INDEX `fk_ServerTime_ServerInstance_idx` (`ServerID` ASC),
INDEX `fk_ServerTime_ServerMap_idx` (`MapID` ASC),
UNIQUE INDEX `idx_ServerTime_uniqueServerMap` (`ServerID` ASC, `MapID` ASC),
CONSTRAINT `fk_ServerTime_ServerInstance`
FOREIGN KEY (`ServerID`)
REFERENCES `ServerInstance` (`ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_ServerTime_ServerMap`
FOREIGN KEY (`MapID`)
REFERENCES `ServerMap` (`ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `ServerMines`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ServerMines` (
`ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`ServerID` INT UNSIGNED NOT NULL,
`MapID` INT UNSIGNED NOT NULL,
`CreationDate` TIMESTAMP NULL,
`LastInteraction` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`OwnerUID` VARCHAR(32) NOT NULL DEFAULT '\"\"',
`Class` VARCHAR(128) NOT NULL DEFAULT 'nil',
`Position` VARCHAR(256) NOT NULL DEFAULT 'nil',
`Direction` VARCHAR(256) NOT NULL DEFAULT '[]',
`Damage` FLOAT NOT NULL DEFAULT 0,
`Variables` VARCHAR(4096) NOT NULL DEFAULT '[]',
PRIMARY KEY (`ID`),
INDEX `fk_ServerMines_ServerInstance_idx` (`ServerID` ASC),
INDEX `fk_ServerMines_ServerMap_idx` (`MapID` ASC),
CONSTRAINT `fk_ServerMines_ServerInstance`
FOREIGN KEY (`ServerID`)
REFERENCES `ServerInstance` (`ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_ServerMines_ServerMap`
FOREIGN KEY (`MapID`)
REFERENCES `ServerMap` (`ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `PlayerStorage`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `PlayerStorage` (
`PlayerUID` VARCHAR(32) NOT NULL,
`MapID` INT UNSIGNED NOT NULL,
`CreationDate` TIMESTAMP NULL,
`LastModified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`Weapons` VARCHAR(4096) NOT NULL DEFAULT '[]',
`Magazines` VARCHAR(4096) NOT NULL DEFAULT '[]',
`Items` VARCHAR(4096) NOT NULL DEFAULT '[]',
`Backpacks` VARCHAR(4096) NOT NULL DEFAULT '[]',
INDEX `fk_PlayerStorage_ServerMap_idx` (`MapID` ASC),
UNIQUE INDEX `idx_PlayerStorage_uniquePlayerMap` (`PlayerUID` ASC, `MapID` ASC),
CONSTRAINT `fk_PlayerStorage_PlayerInfo`
FOREIGN KEY (`PlayerUID`)
REFERENCES `PlayerInfo` (`UID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_PlayerStorage_ServerMap1`
FOREIGN KEY (`MapID`)
REFERENCES `ServerMap` (`ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
-- -----------------------------------------------------
-- Data for table `DBInfo`
-- -----------------------------------------------------
START TRANSACTION;
USE `a3wasteland`;
INSERT INTO `DBInfo` (`Name`, `Value`) VALUES ('Version', '2.05');
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment