-- phpMyAdmin SQL Dump -- version 4.5.4.1deb2ubuntu2.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Oct 08, 2021 at 07:37 AM -- Server version: 10.0.38-MariaDB-0ubuntu0.16.04.1 -- PHP Version: 7.0.33-50+ubuntu16.04.1+deb.sury.org+1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `newbot` -- -- -------------------------------------------------------- -- -- Table structure for table `alerts` -- DROP TABLE IF EXISTS `alerts`; CREATE TABLE `alerts` ( `alertID` bigint(20) NOT NULL, `steam` bigint(17) DEFAULT '0', `x` int(11) DEFAULT '0', `y` int(11) DEFAULT '0', `z` int(11) DEFAULT '0', `message` varchar(255) DEFAULT '', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `sent` tinyint(1) NOT NULL DEFAULT '0', `status` varchar(30) NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `altertables` -- DROP TABLE IF EXISTS `altertables`; CREATE TABLE `altertables` ( `id` int(11) NOT NULL, `statement` varchar(1000) DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `altertables` -- INSERT INTO `altertables` (`id`, `statement`) VALUES (1, 'CREATE TABLE `badWords` (`badWord` varchar(15) NOT NULL,`cost` int(11) NOT NULL DEFAULT \'10\',`counter` int(11) NOT NULL DEFAULT \'0\') ENGINE=InnoDB DEFAULT CHARSET=latin1'), (2, 'CREATE TABLE `list` (`thing` varchar(255) NOT NULL) ENGINE=MEMORY DEFAULT CHARSET=latin1 COMMENT=\'For sorting a list\''), (3, 'CREATE TABLE `prefabCopies` (`owner` bigint(17) NOT NULL DEFAULT \'0\',`name` varchar(50) NOT NULL DEFAULT \'\',`x1` int(11) NOT NULL DEFAULT \'0\',`x2` int(11) NOT NULL DEFAULT \'0\',`y1` int(11) NOT NULL DEFAULT \'0\',`y2` int(11) NOT NULL DEFAULT \'0\',`z1` int(11) NOT NULL DEFAULT \'0\',`z2` int(11) NOT NULL DEFAULT \'0\',`blockName` VARCHAR(50) NOT NULL DEFAULT \'\',`rotation` INT NOT NULL DEFAULT \'0\', PRIMARY KEY (`owner`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (4, 'CREATE TABLE `memEntities` (`entityID` bigint(20) NOT NULL,`type` varchar(20) NOT NULL DEFAULT \'\',`name` varchar(30) NOT NULL DEFAULT \'\',`x` int(11) NOT NULL DEFAULT \'0\',`y` int(11) NOT NULL DEFAULT \'0\',`z` int(11) DEFAULT \'0\',`dead` tinyint(1) NOT NULL DEFAULT \'0\',`health` int(11) NOT NULL DEFAULT \'0\', PRIMARY KEY (`entityID`)) ENGINE=MEMORY DEFAULT CHARSET=latin1'), (5, 'CREATE TABLE `waypoints` (`steam` varchar(17) NOT NULL,`name` varchar(20) NOT NULL,`x` int(11) NOT NULL DEFAULT \'0\',`y` int(11) NOT NULL DEFAULT \'0\',`z` int(11) NOT NULL DEFAULT \'0\',`shared` int(11) NOT NULL DEFAULT \'0\', PRIMARY KEY (`steam`,`name`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (6, 'CREATE TABLE `gimmeZombies` (`zombie` varchar(50) NOT NULL,`minPlayerLevel` int(11) NOT NULL DEFAULT \'1\',`minArenaLevel` int(11) NOT NULL DEFAULT \'1\', PRIMARY KEY (`zombie`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (7, 'CREATE TABLE `miscQueue` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`steam` bigint(17) NOT NULL,`command` varchar(100) NOT NULL,`action` varchar(15) NOT NULL,`value` int(11) NOT NULL DEFAULT \'0\', PRIMARY KEY (`id`)) ENGINE=MEMORY DEFAULT CHARSET=utf8'), (8, 'CREATE TABLE `customCommands` (`commandID` int(11) NOT NULL AUTO_INCREMENT, `command` varchar(50) NOT NULL, `accessLevel` int(11) NOT NULL DEFAULT \'2\', `help` varchar(255) NOT NULL, PRIMARY KEY (`commandID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (9, 'CREATE TABLE `whitelist` (`steam` varchar(17) NOT NULL, PRIMARY KEY (`steam`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (10, 'CREATE TABLE `otherEntities` (`entity` varchar(50) NOT NULL,`entityID` int(11) NOT NULL DEFAULT \'0\',`doNotSpawn` tinyint(1) NOT NULL DEFAULT \'0\', PRIMARY KEY (`entity`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (11, 'CREATE TABLE `helpCommands` (`commandID` int(11) NOT NULL AUTO_INCREMENT,`command` varchar(255) NOT NULL,`description` varchar(255) NOT NULL,`notes` text NOT NULL,`keywords` varchar(150) NOT NULL,`lastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,`accessLevel` int(11) NOT NULL DEFAULT \'99\',`ingameOnly` tinyint(1) NOT NULL DEFAULT \'0\', PRIMARY KEY (`commandID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (12, 'CREATE TABLE `helpTopicCommands` (`topicID` int(11) NOT NULL,`commandID` int(11) NOT NULL, PRIMARY KEY (`topicID`, `commandID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (13, 'CREATE TABLE `helpTopics` (`topicID` int(11) NOT NULL AUTO_INCREMENT,`topic` varchar(20) NOT NULL,`description` varchar(200) NOT NULL, PRIMARY KEY (`topicID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (14, 'CREATE TABLE `staff` (`steam` bigint(17) NOT NULL DEFAULT \'0\',`adminLevel` int(11) NOT NULL DEFAULT \'2\',`blockDelete` tinyint(1) NOT NULL DEFAULT \'0\', PRIMARY KEY (`steam`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (15, 'CREATE TABLE `spawnableItems` (`itemName` varchar(100) NOT NULL, `deleteItem` tinyint(1) NOT NULL DEFAULT \'0\', `accessLevelRestriction` int(11) NOT NULL DEFAULT \'99\', `category` varchar(20) NOT NULL DEFAULT \'None\', `price` int(11) NOT NULL DEFAULT \'10000\', `stock` int(11) NOT NULL DEFAULT \'5000\', `idx` int(11) NOT NULL DEFAULT \'0\', `maxStock` int(11) NOT NULL DEFAULT \'5000\', `inventoryResponse` varchar(10) NOT NULL DEFAULT \'none\', `StackLimit` int(11) NOT NULL DEFAULT \'1000\', `newPlayerMaxInventory` int(11) NOT NULL DEFAULT \'-1\', `units` int(11) NOT NULL DEFAULT \'1\', PRIMARY KEY (`itemName`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (16, 'CREATE TABLE `reservedSlots` (`steam` varchar(17) NOT NULL,`timeAdded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,`reserved` tinyint(1) NOT NULL DEFAULT \'0\',`staff` tinyint(1) NOT NULL DEFAULT \'0\',`totalPlayTime` int(11) NOT NULL DEFAULT \'0\',`deleteRow` TINYINT(1) NOT NULL DEFAULT \'0\',PRIMARY KEY (`steam`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (17, 'CREATE TABLE `botCommands` (`cmdCode` varchar(5) NOT NULL,`cmdIndex` int(11) NOT NULL,`accessLevel` int(11) NOT NULL DEFAULT \'0\',`enabled` tinyint(1) NOT NULL DEFAULT \'1\',`keywords` varchar(150) NOT NULL DEFAULT \'\',`shortDescription` varchar(255) NOT NULL DEFAULT \'\',`longDescription` varchar(1000) NOT NULL DEFAULT \'\',`sortOrder` int(11) NOT NULL DEFAULT \'0\',PRIMARY KEY (`cmdCode`,`cmdIndex`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (18, 'CREATE TABLE `timedEvents` (`timer` varchar(20) NOT NULL DEFAULT \'\',`delayMinutes` int(11) NOT NULL DEFAULT \'10\',`nextTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,`disabled` tinyint(1) NOT NULL DEFAULT \'0\',PRIMARY KEY (`timer`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (19, 'CREATE TABLE `botChat` (`botChatID` int(11) NOT NULL AUTO_INCREMENT,`triggerWords` varchar(255) NOT NULL DEFAULT \'\',`triggerPhrase` varchar(255) NOT NULL DEFAULT \'\',`accessLevelRestriction` int(11) NOT NULL DEFAULT \'99\',`mustAddressBot` tinyint(1) NOT NULL DEFAULT \'0\',PRIMARY KEY (`botChatID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (20, 'CREATE TABLE `botChatResponses` (`botChatResponseID` int(11) NOT NULL AUTO_INCREMENT,`botChatID` int(11) NOT NULL DEFAULT \'0\',`response` varchar(300) NOT NULL DEFAULT \'\',PRIMARY KEY (`botChatResponseID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (21, 'CREATE TABLE `webInterfaceQueue` (`id` int(11) NOT NULL AUTO_INCREMENT,`action` varchar(10) NOT NULL DEFAULT \'\',`actionTable` varchar(50) NOT NULL DEFAULT \'\',`actionQuery` text NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (22, 'CREATE TABLE `locationCategories` (`categoryName` varchar(20) NOT NULL,`minAccessLevel` int(11) NOT NULL DEFAULT \'99\',`maxAccessLevel` int(11) NOT NULL DEFAULT \'0\',PRIMARY KEY (`categoryName`)) ENGINE=InnoDB DEFAULT CHARSET=latin1'), (23, 'CREATE TABLE `gimmeGroup` (`groupName` varchar(30) NOT NULL DEFAULT \'\',PRIMARY KEY (`groupName`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4'), (24, 'CREATE TABLE `connectQueue` (`id` bigint(20) NOT NULL AUTO_INCREMENT, `steam` bigint(17) NOT NULL, `command` varchar(255) NOT NULL, `processed` TINYINT(1) NOT NULL DEFAULT \'0\', PRIMARY KEY (`id`)) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4'), (25, 'CREATE TABLE `commandAccessRestrictions` (`id` int(11) NOT NULL, `functionName` varchar(100) NOT NULL DEFAULT \'\', `accessLevel` int(11) NOT NULL DEFAULT \'3\', PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4'), (26, 'CREATE TABLE `customCommands_Detail` (`detailID` int(11) NOT NULL, `commandID` int(11) NOT NULL, `action` varchar(5) NOT NULL DEFAULT \'\' COMMENT \'say,give,tele,spawn,buff,cmd\', `thing` varchar(255) NOT NULL DEFAULT \'\', PRIMARY KEY (`detailID`,`commandID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4'), (27, 'CREATE TABLE playersArchived LIKE players'), (28, 'CREATE TABLE `APIQueue` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`URL` varchar(500) NOT NULL,`OutputFile` varchar(500) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4'), (29, 'CREATE TABLE `LKPQueue` (`id` int(11) NOT NULL AUTO_INCREMENT, `line` varchar(255) NOT NULL DEFAULT \'\', PRIMARY KEY (`id`)) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4'), (30, 'CREATE TABLE `persistentQueue` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`steam` bigint(17) NOT NULL,`command` varchar(255) NOT NULL,`action` varchar(15) NOT NULL, `value` int(11) NOT NULL DEFAULT \'0\',`timerDelay` timestamp NOT NULL DEFAULT \'0000-00-00 00:00:00\', PRIMARY KEY (`id`)) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4'), (31, 'CREATE TABLE `slots` (`slot` int(11) NOT NULL,`steam` bigint(17) NOT NULL DEFAULT \'0\',`online` tinyint(1) NOT NULL DEFAULT \'0\',`joinedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,`joinedSession` int(11) NOT NULL DEFAULT \'0\',`expires` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,`reserved` tinyint(1) NOT NULL DEFAULT \'0\',`staff` tinyint(1) NOT NULL DEFAULT \'0\',`free` TINYINT(1) NOT NULL DEFAULT \'1\',`canBeKicked` TINYINT(1) NOT NULL DEFAULT \'1\',`disconnectedTimestamp` TIMESTAMP NOT NULL DEFAULT \'0000-00-00 00:00:00\', PRIMARY KEY (`slot`)) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4'), (32, 'CREATE TABLE `bases` (`steam` bigint(17) NOT NULL,`baseNumber` int(11) NOT NULL DEFAULT \'1\',`title` varchar(100) NOT NULL DEFAULT \'\',`x` int(11) NOT NULL DEFAULT \'0\',`y` int(11) NOT NULL DEFAULT \'0\',`z` int(11) NOT NULL DEFAULT \'0\',`exitX` int(11) NOT NULL DEFAULT \'0\',`exitY` int(11) NOT NULL DEFAULT \'0\',`exitZ` int(11) NOT NULL DEFAULT \'0\',`size` int(11) NOT NULL DEFAULT \'0\',`protect` tinyint(1) NOT NULL DEFAULT \'0\',`keepOut` tinyint(1) NOT NULL DEFAULT \'0\',`creationTimestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,`creationGameDay` INT NOT NULL DEFAULT \'0\',PRIMARY KEY (`steam`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4'), (33, 'CREATE TABLE `webInterfaceJSON` (`ident` varchar(50) NOT NULL,`json` text NOT NULL, `sessionID` VARCHAR(32) NOT NULL DEFAULT \'\', PRIMARY KEY (`ident`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4'), (34, 'CREATE TABLE `donors` (`steam` int(11) NOT NULL, `level` int(11) NOT NULL DEFAULT \'0\', `expiry` int(11) DEFAULT NULL, PRIMARY KEY (`steam`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4'), (35, 'CREATE TABLE `modBotman` (`clanEnabled` tinyint(1) NOT NULL DEFAULT \'0\',`clanMaxClans` int(11) NOT NULL DEFAULT \'0\',`clanMaxPlayers` int(11) NOT NULL DEFAULT \'0\',`clanMinLevel` int(11) NOT NULL DEFAULT \'0\') ENGINE=InnoDB DEFAULT CHARSET=utf8mb4'), (36, 'CREATE TABLE list2 LIKE list'), (37, 'ALTER TABLE `players` ADD COLUMN `waypoint2X` INT NULL DEFAULT \'0\' , ADD COLUMN `waypoint2Y` INT NULL DEFAULT \'0\' , ADD COLUMN `waypoint2Z` INT NULL DEFAULT \'0\', ADD COLUMN `waypointsLinked` TINYINT(1) NULL DEFAULT \'0\''), (38, 'ALTER TABLE `players` ADD `ircMute` TINYINT(1) NULL DEFAULT \'0\''), (39, 'ALTER TABLE `players` ADD `chatColour` VARCHAR(6) NULL DEFAULT \'\''), (40, 'ALTER TABLE `players` ADD `teleCooldown` INT NULL DEFAULT \'0\''), (41, 'ALTER TABLE `players` ADD `reserveSlot` TINYINT(1) NULL DEFAULT \'0\''), (42, 'ALTER TABLE `players` ADD `prisonReleaseTime` INT NULL DEFAULT \'0\''), (43, 'ALTER TABLE `players` ADD `maxWaypoints` INT NULL DEFAULT \'2\''), (44, 'ALTER TABLE `players` ADD ircLogin varchar(20) NULL DEFAULT \'\''), (45, 'ALTER TABLE `players` ADD `waypointCooldown` INT NULL DEFAULT \'0\''), (46, 'ALTER TABLE `players` ADD `bail` INT NULL DEFAULT \'0\''), (47, 'ALTER TABLE `players` ADD `watchPlayerTimer` INT(11) NULL DEFAULT \'0\''), (48, 'ALTER TABLE `players` ADD `hackerScore` INT NULL DEFAULT \'0\''), (49, 'ALTER TABLE `players` ADD `pvpTeleportCooldown` INT NULL DEFAULT \'0\''), (50, 'ALTER TABLE `players` ADD `block` TINYINT(1) NULL DEFAULT \'0\''), (51, 'ALTER TABLE `players` ADD `removedClaims` INT NULL DEFAULT \'0\''), (52, 'ALTER TABLE `players` ADD `returnCooldown` INT NULL DEFAULT \'0\''), (53, 'ALTER TABLE `players` ADD `commandCooldown` INT NULL DEFAULT \'0\''), (54, 'ALTER TABLE `players` ADD `gimmeCooldown` INT NULL DEFAULT \'0\''), (55, 'ALTER TABLE `players` ADD `VACBanned` TINYINT(1) NULL DEFAULT \'0\''), (56, 'ALTER TABLE `players` ADD `bountyReason` VARCHAR(100) NULL DEFAULT \'\''), (57, 'ALTER TABLE `players` ADD `claimsExpired` TINYINT(1) NULL DEFAULT \'0\''), (58, 'ALTER TABLE `players` ADD `showLocationMessages` TINYINT(1) NULL DEFAULT \'1\''), (59, 'ALTER TABLE `players` ADD `DNSLookupCount` INT NULL DEFAULT \'0\', ADD `lastDNSLookup` DATE NULL DEFAULT \'1000-01-01\''), (60, 'ALTER TABLE `players` ADD `ircAuthenticated` TINYINT(1) NULL DEFAULT \'0\''), (61, 'ALTER TABLE `players` ADD `p2pCooldown` INT NULL DEFAULT \'0\''), (62, 'ALTER TABLE `players` CHANGE `name` `name` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT \'\', CHANGE `id` `id` INT(11) NULL DEFAULT \'0\', CHANGE `xPos` `xPos` INT(11) NULL DEFAULT \'0\', CHANGE `yPos` `yPos` INT(11) NULL DEFAULT \'0\', CHANGE `zPos` `zPos` INT(11) NULL DEFAULT \'0\', CHANGE `xPosOld` `xPosOld` INT(11) NULL DEFAULT \'0\', CHANGE `yPosOld` `yPosOld` INT(11) NULL DEFAULT \'0\', CHANGE `zPosOld` `zPosOld` INT(11) NULL DEFAULT \'0\', CHANGE `homeX` `homeX` INT(11) NULL DEFAULT \'0\', CHANGE `homeY` `homeY` INT(11) NULL DEFAULT \'0\', CHANGE `homeZ` `homeZ` INT(11) NULL DEFAULT \'0\', CHANGE `home2X` `home2X` INT(11) NULL DEFAULT \'0\', CHANGE `home2Y` `home2Y` INT(11) NULL DEFAULT \'0\', CHANGE `home2Z` `home2Z` INT(11) NULL DEFAULT \'0\', CHANGE `exitX` `exitX` INT(11) NULL DEFAULT \'0\', CHANGE `exitY` `exitY` INT(11) NULL DEFAULT \'0\', CHANGE `exitZ` `exitZ` INT(11) NULL DEFAULT \'0\', CHANGE `exit2X` `exit2X` INT(11) NULL DEFAULT \'0\', CHANGE `exit2Y` `exit2Y` INT(11) NULL'), (63, 'ALTER TABLE `players` CHANGE `sessionCount` `sessionCount` INT(11) NULL DEFAULT \'1\', CHANGE `timeOnServer` `timeOnServer` INT(11) NULL DEFAULT \'0\', CHANGE `firstSeen` `firstSeen` INT(11) NULL DEFAULT \'0\', CHANGE `keystones` `keystones` INT(11) NULL DEFAULT \'0\', CHANGE `overStackTimeout` `overStackTimeout` TINYINT(1) NULL DEFAULT \'0\', CHANGE `overstack` `overstack` TINYINT(1) NULL DEFAULT \'0\', CHANGE `shareWaypoint` `shareWaypoint` TINYINT(1) NULL DEFAULT \'0\', CHANGE `watchCash` `watchCash` TINYINT(1) NULL DEFAULT \'0\', CHANGE `watchPlayer` `watchPlayer` TINYINT(1) NULL DEFAULT \'1\', CHANGE `timeout` `timeout` TINYINT(1) NULL DEFAULT \'0\', CHANGE `denyRights` `denyRights` TINYINT(1) NULL DEFAULT \'0\', CHANGE `botTimeout` `botTimeout` TINYINT(1) NULL DEFAULT \'0\', CHANGE `newPlayer` `newPlayer` TINYINT(1) NULL DEFAULT \'1\', CHANGE `baseCooldown` `baseCooldown` INT(11) NULL DEFAULT \'0\', CHANGE `donor` `donor` TINYINT(1) NULL DEFAULT \'0\', CHANGE `playtime` `playtime` INT(11) NULL DEFAULT \'0\', CH'), (64, 'ALTER TABLE `players` CHANGE `walkies` `walkies` TINYINT(1) NULL DEFAULT \'0\', CHANGE `prisonxPosOld` `prisonxPosOld` INT(11) NULL DEFAULT \'0\', CHANGE `prisonyPosOld` `prisonyPosOld` INT(11) NULL DEFAULT \'0\', CHANGE `prisonzPosOld` `prisonzPosOld` INT(11) NULL DEFAULT \'0\', CHANGE `pvpVictim` `pvpVictim` BIGINT(17) NULL DEFAULT \'0\', CHANGE `canTeleport` `canTeleport` TINYINT(1) NULL DEFAULT \'1\', CHANGE `allowBadInventory` `allowBadInventory` TINYINT(1) NULL DEFAULT \'0\', CHANGE `ircTranslate` `ircTranslate` TINYINT(1) NULL DEFAULT \'0\', CHANGE `ircPass` `ircPass` VARCHAR(15) NULL DEFAULT \'\', CHANGE `noSpam` `noSpam` TINYINT(1) NULL DEFAULT \'0\', CHANGE `waypointX` `waypointX` INT(11) NULL DEFAULT \'0\', CHANGE `waypointY` `waypointY` INT(11) NULL DEFAULT \'0\', CHANGE `waypointZ` `waypointZ` INT(11) NULL DEFAULT \'0\', CHANGE `xPosTimeout` `xPosTimeout` INT(11) NULL DEFAULT \'0\', CHANGE `yPosTimeout` `yPosTimeout` INT(11) NULL DEFAULT \'0\', CHANGE `zPosTimeout` `zPosTimeout` INT(11) NULL DEFAULT \'0'), (65, 'ALTER TABLE `players` CHANGE `xPosOld2` `xPosOld2` INT(11) NULL DEFAULT \'0\', CHANGE `yPosOld2` `yPosOld2` INT(11) NULL DEFAULT \'0\', CHANGE `zPosOld2` `zPosOld2` INT(11) NULL DEFAULT \'0\', CHANGE `ignorePlayer` `ignorePlayer` TINYINT(1) NULL DEFAULT \'0\', CHANGE `ircMute` `ircMute` TINYINT(1) NULL DEFAULT \'0\', CHANGE `waypoint2X` `waypoint2X` INT(11) NULL DEFAULT \'0\', CHANGE `waypoint2Y` `waypoint2Y` INT(11) NULL DEFAULT \'0\', CHANGE `waypoint2Z` `waypoint2Z` INT(11) NULL DEFAULT \'0\', CHANGE `waypointsLinked` `waypointsLinked` TINYINT(1) NULL DEFAULT \'0\', CHANGE `chatColour` `chatColour` VARCHAR(6) NULL DEFAULT \'FFFFFF\', CHANGE `teleCooldown` `teleCooldown` INT(11) NULL DEFAULT \'0\', CHANGE `reserveSlot` `reserveSlot` TINYINT(4) NULL DEFAULT \'0\', CHANGE `prisonReleaseTime` `prisonReleaseTime` INT(11) NULL DEFAULT \'0\', CHANGE `maxWaypoints` `maxWaypoints` INT(11) NULL DEFAULT \'2\', CHANGE `ircLogin` `ircLogin` VARCHAR(20) NULL DEFAULT \'\', CHANGE `waypointCooldown` `waypointCooldown` INT(11) N'), (66, 'ALTER TABLE `players` CHANGE `gimmeCooldown` `gimmeCooldown` INT(11) NULL DEFAULT \'0\', CHANGE `VACBanned` `VACBanned` TINYINT(1) NULL DEFAULT \'0\', CHANGE `bountyReason` `bountyReason` VARCHAR(100) NULL DEFAULT \'\', CHANGE `claimsExpired` `claimsExpired` TINYINT(1) NULL DEFAULT \'0\', CHANGE `showLocationMessages` `showLocationMessages` TINYINT(1) NULL DEFAULT \'1\', CHANGE `DNSLookupCount` `DNSLookupCount` INT(11) NULL DEFAULT \'0\', CHANGE `lastDNSLookup` `lastDNSLookup` DATE NULL DEFAULT \'1000-01-01\', CHANGE `ircAuthenticated` `ircAuthenticated` TINYINT(1) NULL DEFAULT \'0\', CHANGE `p2pCooldown` `p2pCooldown` INT(11) NULL DEFAULT \'0\''), (67, 'ALTER TABLE `players` CHANGE `location` `location` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT \'\', DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, CHANGE `aliases` `aliases` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL'), (68, 'ALTER TABLE `playersArchived` CHANGE `name` `name` VARCHAR(100) NOT NULL DEFAULT \'\''), (69, 'ALTER TABLE `server` ADD `teleportCost` INT NULL DEFAULT \'200\''), (70, 'ALTER TABLE `server` ADD `ircPrivate` TINYINT(1) NULL DEFAULT \'0\''), (71, 'ALTER TABLE `server` ADD `waypointsPublic` TINYINT(1) NULL DEFAULT \'0\''), (72, 'ALTER TABLE `server` ADD `waypointCost` INT NULL DEFAULT \'0\''), (73, 'ALTER TABLE `server` ADD `waypointCooldown` INT NULL DEFAULT \'0\''), (74, 'ALTER TABLE `server` ADD `waypointCreateCost` INT NULL DEFAULT \'0\''), (75, 'ALTER TABLE `server` ADD `alertColour` VARCHAR(6) NULL DEFAULT \'DC143C\''), (76, 'ALTER TABLE `server` ADD `warnColour` VARCHAR(6) NULL DEFAULT \'FFA500\''), (77, 'ALTER TABLE `server` ADD `swearFine` INT NULL DEFAULT \'5\''), (78, 'ALTER TABLE `server` ADD `commandPrefix` VARCHAR(1) NULL DEFAULT \'/\''), (79, 'ALTER TABLE `server` ADD `chatlogPath` VARCHAR(200) NULL DEFAULT \'\''), (80, 'ALTER TABLE `server` ADD `botVersion` VARCHAR(11) NULL DEFAULT \'\''), (81, 'ALTER TABLE `server` ADD `packCost` INT NULL DEFAULT \'0\''), (82, 'ALTER TABLE `server` ADD `baseCost` INT NULL DEFAULT \'0\''), (83, 'ALTER TABLE `server` ADD `rebootHour` INT NULL DEFAULT \'-1\''), (84, 'ALTER TABLE `server` ADD `rebootMinute` INT NULL DEFAULT \'0\''), (85, 'ALTER TABLE `server` ADD `maxPrisonTime` INT NULL DEFAULT \'-1\''), (86, 'ALTER TABLE `server` ADD `bailCost` INT NULL DEFAULT \'0\''), (87, 'ALTER TABLE `server` ADD `maxWaypoints` INT NULL DEFAULT \'2\''), (88, 'ALTER TABLE `server` ADD `teleportPublicCost` INT NULL DEFAULT \'0\''), (89, 'ALTER TABLE `server` ADD `teleportPublicCooldown` INT NULL DEFAULT \'0\''), (90, 'ALTER TABLE `server` ADD `reservedSlots` INT NULL DEFAULT \'0\''), (91, 'ALTER TABLE `server` ADD `allowReturns` TINYINT(1) NULL DEFAULT \'1\''), (92, 'ALTER TABLE `server` ADD `scanNoclip` TINYINT(1) NULL DEFAULT \'1\''), (93, 'ALTER TABLE `server` ADD `scanEntities` TINYINT(1) NULL DEFAULT \'0\''), (94, 'ALTER TABLE `server` ADD `CBSMFriendly` TINYINT(1) NULL DEFAULT \'1\''), (95, 'ALTER TABLE `server` ADD `scanErrors` TINYINT(1) NULL DEFAULT \'0\''), (96, 'ALTER TABLE `server` ADD disableTPinPVP TINYINT(1) NULL DEFAULT \'0\''), (97, 'ALTER TABLE `server` ADD `ServerToolsDetected` TINYINT(1) NULL DEFAULT \'0\''), (98, 'ALTER TABLE `server` ADD `updateBot` INT(1) NULL DEFAULT \'0\' COMMENT \'0 do not update, 1 stable branch, 2 testing branch\''), (99, 'ALTER TABLE `server` ADD `alertSpending` TINYINT(1) NULL DEFAULT \'0\''), (100, 'ALTER TABLE `server` ADD `GBLBanThreshold` INT NULL DEFAULT \'0\''), (101, 'ALTER TABLE `server` ADD `lastBotsMessageID` INT NULL DEFAULT \'0\' , ADD `lastBotsMessageTimestamp` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP'), (102, 'ALTER TABLE `server` ADD `gimmeZombies` TINYINT(1) NULL DEFAULT \'1\''), (103, 'ALTER TABLE `server` ADD `allowProxies` TINYINT(1) NULL DEFAULT \'0\''), (104, 'ALTER TABLE `server` ADD `SDXDetected` TINYINT(1) NULL DEFAULT \'0\''), (105, 'ALTER TABLE `server` ADD `enableWindowMessages` TINYINT(1) NULL DEFAULT \'0\''), (106, 'ALTER TABLE `server` ADD `updateBranch` VARCHAR(7) NULL DEFAULT \'stable\''), (107, 'ALTER TABLE `server` ADD `chatColourNewPlayer` VARCHAR(6) NULL DEFAULT \'FFFFFF\' , ADD `chatColourPlayer` VARCHAR(6) NULL DEFAULT \'FFFFFF\' , ADD `chatColourDonor` VARCHAR(6) NULL DEFAULT \'FFFFFF\' , ADD `chatColourPrisoner` VARCHAR(6) NULL DEFAULT \'FFFFFF\' , ADD `chatColourMod` VARCHAR(6) NULL DEFAULT \'FFFFFF\' , ADD `chatColourAdmin` VARCHAR(6) NULL DEFAULT \'FFFFFF\' , ADD `chatColourOwner` VARCHAR(6) NULL DEFAULT \'FFFFFF\''), (108, 'ALTER TABLE `server` ADD `commandCooldown` INT NULL DEFAULT \'0\''), (109, 'ALTER TABLE `server` ADD `telnetPass` VARCHAR(50) NULL'), (110, 'ALTER TABLE `server` ADD `telnetPort` INT NULL DEFAULT \'0\''), (111, 'ALTER TABLE `server` ADD `feralRebootDelay` INT NULL DEFAULT \'68\''), (112, 'ALTER TABLE `server` ADD `pvpTeleportCooldown` INT NULL DEFAULT \'0\''), (113, 'ALTER TABLE `server` ADD `allowPlayerToPlayerTeleporting` TINYINT(1) NULL DEFAULT \'1\''), (114, 'ALTER TABLE `server` ADD `ircPort` INT NULL DEFAULT \'6667\''), (115, 'ALTER TABLE `server` ADD `botRestartHour` INT NULL DEFAULT \'25\''), (116, 'ALTER TABLE `server` ADD `trackingKeepDays` INT NULL DEFAULT \'28\' , ADD `databaseMaintenanceFinished` TINYINT(1) NULL DEFAULT \'1\''), (117, 'ALTER TABLE `server` ADD `allowHomeTeleport` TINYINT(1) NULL DEFAULT \'1\' , ADD `playerTeleportDelay` INT NULL DEFAULT \'0\''), (118, 'ALTER TABLE `server` ADD `allowPackTeleport` TINYINT(1) NULL DEFAULT \'1\''), (119, 'ALTER TABLE `server` ADD `gameVersion` VARCHAR(30) NULL DEFAULT \'\''), (120, 'ALTER TABLE `server` ADD `pvpIgnoreFriendlyKills` TINYINT(1) NULL DEFAULT \'0\', ADD `allowStuckTeleport` TINYINT(1) NULL DEFAULT \'1\''), (121, 'ALTER TABLE `server` ADD `restrictIRC` TINYINT(1) NULL DEFAULT \'0\''), (122, 'ALTER TABLE `server` ADD `nextAnnouncement` INT NULL DEFAULT \'1\''), (123, 'ALTER TABLE `server` ADD `pvpAllowProtect` INT NULL DEFAULT \'0\''), (124, 'ALTER TABLE `server` ADD `hackerTPDetection` TINYINT(1) NULL DEFAULT \'1\''), (125, 'ALTER TABLE `server` ADD `whitelistCountries` VARCHAR(50) NULL DEFAULT \'\' , ADD `perMinutePayRate` INT NULL DEFAULT \'0\' , ADD `disableWatchAlerts` TINYINT(1) NULL DEFAULT \'0\' , ADD `masterPassword` VARCHAR(50) NULL DEFAULT \'\', ADD `allowBotRestarts` TINYINT(1) NULL DEFAULT \'0\', ADD `botOwner` VARCHAR(17) NULL DEFAULT \'0\''), (126, 'ALTER TABLE `server` ADD `returnCooldown` INT NULL DEFAULT \'0\''), (127, 'ALTER TABLE `server` ADD `botRestartDay` INT NULL DEFAULT \'7\''), (128, 'ALTER TABLE `server` ADD `enableTimedClaimScan` TINYINT(1) NULL DEFAULT \'1\', ADD `enableScreamerAlert` TINYINT(1) NULL DEFAULT \'1\' , ADD `enableAirdropAlert` TINYINT(1) NULL DEFAULT \'1\''), (129, 'ALTER TABLE `server` ADD `spleefGameCoords` VARCHAR(20) NULL DEFAULT \'4000 225 4000\''), (130, 'ALTER TABLE `server` ADD `gimmeResetTime` INT NULL DEFAULT \'120\', ADD `gimmeRaincheck` INT NULL DEFAULT \'0\''), (131, 'ALTER TABLE `server` ADD `pingKickTarget` VARCHAR(3) NULL DEFAULT \'new\' , ADD `enableBounty` TINYINT(1) NULL DEFAULT \'1\', ADD `mapSizeNewPlayers` INT NULL DEFAULT \'10000\' , ADD `mapSizePlayers` INT NULL DEFAULT \'10000\', ADD `shopResetDays` INT NULL DEFAULT \'3\''), (132, 'ALTER TABLE `server` ADD `telnetLogKeepDays` INT NULL DEFAULT \'14\''), (133, 'ALTER TABLE `server` ADD `dailyRebootHour` int(11) NULL DEFAULT \'0\''), (134, 'ALTER TABLE `server` ADD `maxWaypointsDonors` INT NULL DEFAULT \'2\''), (135, 'ALTER TABLE `server` ADD `baseProtectionExpiryDays` INT NULL DEFAULT \'40\''), (136, 'ALTER TABLE `server` ADD `banVACBannedPlayers` TINYINT(1) NULL DEFAULT \'0\''), (137, 'ALTER TABLE `server` ADD `deathCost` INT NULL DEFAULT \'0\''), (138, 'ALTER TABLE `server` ADD `showLocationMessages` TINYINT(1) NULL DEFAULT \'1\''), (139, 'ALTER TABLE `server` ADD `bountyRewardItem` VARCHAR(25) NULL DEFAULT \'cash\''), (140, 'ALTER TABLE `server` ADD `enableLagCheck` TINYINT(1) NULL DEFAULT \'1\''), (141, 'ALTER TABLE `server` ADD `allowSecondBaseWithoutDonor` TINYINT(1) NULL DEFAULT \'0\''), (142, 'ALTER TABLE `server` ADD `nonAlphabeticChatReaction` VARCHAR(10) NULL DEFAULT \'nothing\''), (143, 'ALTER TABLE `server` ADD `lotteryTicketPrice` INT NULL DEFAULT \'25\''), (144, 'ALTER TABLE `server` ADD `newPlayerMaxLevel` INT NULL DEFAULT \'9\''), (145, 'ALTER TABLE `server` ADD `hordeNight` INT NULL DEFAULT \'7\''), (146, 'ALTER TABLE `server` ADD `hideUnknownCommand` TINYINT(1) NULL DEFAULT \'0\', ADD `beQuietBot` TINYINT(1) NULL DEFAULT \'0\''), (147, 'ALTER TABLE `server` ADD `gimmeResetTimer` INT NULL DEFAULT \'120\', ADD `shopResetGameOrRealDays` TINYINT(1) NULL DEFAULT \'0\', ADD `zombieKillRewardDonors` FLOAT NULL DEFAULT \'3\''), (148, 'ALTER TABLE `server` ADD `allowFamilySteamKeys` TINYINT(1) NULL DEFAULT \'1\''), (149, 'ALTER TABLE `server` ADD `checkLevelHack` TINYINT(1) NULL DEFAULT \'0\''), (150, 'ALTER TABLE `server` ADD `despawnZombiesBeforeBloodMoon` TINYINT(1) NULL DEFAULT \'0\''), (151, 'ALTER TABLE `server` ADD `optOutGlobalBots` TINYINT(1) NULL DEFAULT \'0\''), (152, 'ALTER TABLE `server` ADD `dropMiningWarningThreshold` INT NULL DEFAULT \'99\''), (153, 'ALTER TABLE `server` ADD `webPanelPort` INT NULL DEFAULT \'8080\''), (154, 'ALTER TABLE `server` ADD `allocsWebAPIUser` VARCHAR(100) NULL DEFAULT \'\', ADD `allocsWebAPIPassword` VARCHAR(100) NULL DEFAULT \'\', ADD `useAllocsWebAPI` TINYINT(1) NULL DEFAULT \'0\''), (155, 'ALTER TABLE `server` ADD `defaultWatchTimer` INT NULL DEFAULT \'259200\''), (156, 'ALTER TABLE `server` ADD `archivePlayersLastSeenDays` INT NULL DEFAULT \'60\''), (157, 'ALTER TABLE `server` ADD `playersLastArchived` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP'), (158, 'ALTER TABLE `server` ADD `alertLevelHack` TINYINT(1) NULL DEFAULT \'1\''), (159, 'ALTER TABLE `server` ADD `logBotCommands` TINYINT(1) NULL DEFAULT \'0\''), (160, 'ALTER TABLE `server` ADD `logInventory` TINYINT(1) NULL DEFAULT \'0\''), (161, 'ALTER TABLE `server` ADD `removeExpiredClaims` TINYINT(1) NULL DEFAULT \'0\''), (162, 'ALTER TABLE `server` ADD `baseDeadzone` INT NULL DEFAULT \'0\''), (163, 'ALTER TABLE `server` ADD `reservedSlotTimelimit` INT NULL DEFAULT \'0\''), (164, 'ALTER TABLE `server` ADD `logPollingInterval` INT NULL DEFAULT \'3\''), (165, 'ALTER TABLE `server` ADD `commandLagThreshold` INT NULL DEFAULT \'15\''), (166, 'ALTER TABLE `server` ADD `telnetDisabled` TINYINT(1) NULL DEFAULT \'0\''), (167, 'ALTER TABLE `server` ADD `sayUsesIRCNick` TINYINT(1) NULL DEFAULT \'0\''), (168, 'ALTER TABLE `server` ADD `readLogUsingTelnet` TINYINT(1) NULL DEFAULT \'0\''), (169, 'ALTER TABLE `server` ADD `ircMainPassword` VARCHAR(30) NULL DEFAULT \'\', ADD `ircAlertsPassword` VARCHAR(30) NULL DEFAULT \'\', ADD `ircWatchPassword` VARCHAR(30) NULL DEFAULT \'\''), (170, 'ALTER TABLE `server` ADD `chatColourPrivate` VARCHAR(6) NULL DEFAULT \'FFFFFF\', ADD `botNameColour` VARCHAR(6) NULL DEFAULT \'FFFFFF\''), (171, 'ALTER TABLE `server` ADD `disableFetch` TINYINT(1) NULL DEFAULT \'0\''), (172, 'ALTER TABLE `server` ADD `p2pCooldown` INT NULL DEFAULT \'0\''), (173, 'ALTER TABLE `server` ADD `telnetFallback` TINYINT(1) NULL DEFAULT \'0\' COMMENT \'Use telnet when API not working\''), (174, 'ALTER TABLE `server` ADD `botsIP` VARCHAR(100) NULL DEFAULT \'0.0.0.0\''), (175, 'ALTER TABLE `server` CHANGE `shopCountdown` `shopCountdown` INT(11) NULL DEFAULT \'0\', CHANGE `gimmePeace` `gimmePeace` TINYINT(1) NULL DEFAULT \'0\', CHANGE `windowDebug` `windowDebug` VARCHAR(15) NULL DEFAULT \'Debug\', CHANGE `ServerPort` `ServerPort` INT(11) NULL DEFAULT \'0\', CHANGE `windowAlerts` `windowAlerts` VARCHAR(15) NULL DEFAULT \'Alerts\', CHANGE `allowGimme` `allowGimme` TINYINT(1) NULL DEFAULT \'0\', CHANGE `mapSize` `mapSize` INT(11) NULL DEFAULT \'10000\', CHANGE `ircAlerts` `ircAlerts` VARCHAR(50) NULL DEFAULT \'#new_alerts\', CHANGE `ircWatch` `ircWatch` VARCHAR(50) NULL DEFAULT \'#new_watch\', CHANGE `prisonSize` `prisonSize` INT(11) NULL DEFAULT \'30\', CHANGE `lottery` `lottery` FLOAT NULL DEFAULT \'0\', CHANGE `allowShop` `allowShop` TINYINT(1) NULL DEFAULT \'0\', CHANGE `windowGMSG` `windowGMSG` VARCHAR(15) NULL DEFAULT \'GMSG\', CHANGE `botName` `botName` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT \'Bot\', CHANGE `allowWaypoints` `allowWaypoints` TINYINT('), (176, 'ALTER TABLE `server` CHANGE `protectionMaxDays` `protectionMaxDays` INT(11) NULL DEFAULT \'40\', CHANGE `ircBotName` `ircBotName` VARCHAR(30) NULL DEFAULT \'Bot\', CHANGE `serverName` `serverName` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT \'New Server\', CHANGE `lastDailyReboot` `lastDailyReboot` INT(11) NULL DEFAULT \'0\', CHANGE `allowNumericNames` `allowNumericNames` TINYINT(1) NULL DEFAULT \'1\', CHANGE `allowGarbageNames` `allowGarbageNames` TINYINT(1) NULL DEFAULT \'1\', CHANGE `allowReboot` `allowReboot` TINYINT(1) NULL DEFAULT \'1\', CHANGE `newPlayerTimer` `newPlayerTimer` INT(11) NULL DEFAULT \'120\', CHANGE `blacklistResponse` `blacklistResponse` VARCHAR(20) NULL DEFAULT \'ban\', CHANGE `gameDay` `gameDay` INT(11) NULL DEFAULT \'0\', CHANGE `allowVoting` `allowVoting` TINYINT(1) NULL DEFAULT \'0\', CHANGE `allowPlayerVoteTopics` `allowPlayerVoteTopics` TINYINT(1) NULL DEFAULT \'0\', CHANGE `shopOpenHour` `shopOpenHour` INT(11) NULL DEFAULT \'0\', CHANGE `shopCloseHour'), (177, 'ALTER TABLE `server` CHANGE `allowOverstacking` `allowOverstacking` TINYINT(1) NULL DEFAULT \'0\', CHANGE `announceTeleports` `announceTeleports` TINYINT(1) NULL DEFAULT \'0\', CHANGE `blacklistCountries` `blacklistCountries` VARCHAR(100) NULL DEFAULT \'CN\', CHANGE `accessLevelOverride` `accessLevelOverride` INT(11) NULL DEFAULT \'99\', CHANGE `disableBaseProtection` `disableBaseProtection` TINYINT(1) NULL DEFAULT \'0\', CHANGE `packCooldown` `packCooldown` INT(11) NULL DEFAULT \'0\', CHANGE `moneyName` `moneyName` VARCHAR(60) NULL DEFAULT \'Zenny|Zennies\', CHANGE `allowBank` `allowBank` TINYINT(1) NULL DEFAULT \'1\', CHANGE `overstackThreshold` `overstackThreshold` INT(11) NULL DEFAULT \'1000\', CHANGE `enableRegionPM` `enableRegionPM` TINYINT(1) NULL DEFAULT \'1\', CHANGE `allowRapidRelogging` `allowRapidRelogging` TINYINT(1) NULL DEFAULT \'1\', CHANGE `allowLottery` `allowLottery` TINYINT(1) NULL DEFAULT \'1\', CHANGE `lotteryMultiplier` `lotteryMultiplier` FLOAT NULL DEFAULT \'2\', CHANGE `zombieKillRewar'), (178, 'ALTER TABLE `server` CHANGE `waypointsPublic` `waypointsPublic` TINYINT(1) NULL DEFAULT \'0\', CHANGE `waypointCost` `waypointCost` INT(11) NULL DEFAULT \'0\', CHANGE `waypointCooldown` `waypointCooldown` INT(11) NULL DEFAULT \'0\', CHANGE `alertColour` `alertColour` VARCHAR(6) NULL DEFAULT \'DC143C\', CHANGE `warnColour` `warnColour` VARCHAR(6) NULL DEFAULT \'FFA500\', CHANGE `teleportCost` `teleportCost` INT(11) NULL DEFAULT \'200\', CHANGE `commandPrefix` `commandPrefix` VARCHAR(1) NULL DEFAULT \'/\', CHANGE `chatlogPath` `chatlogPath` VARCHAR(200) NULL DEFAULT \'\', CHANGE `botVersion` `botVersion` VARCHAR(20) NULL DEFAULT \'\', CHANGE `packCost` `packCost` INT(11) NULL DEFAULT \'0\', CHANGE `baseCost` `baseCost` INT(11) NULL DEFAULT \'0\', CHANGE `rebootHour` `rebootHour` INT(11) NULL DEFAULT \'-1\', CHANGE `rebootMinute` `rebootMinute` INT(11) NULL DEFAULT \'0\', CHANGE `maxPrisonTime` `maxPrisonTime` INT(11) NULL DEFAULT \'-1\', CHANGE `bailCost` `bailCost` INT(11) NULL DEFAULT \'0\', CHANGE `maxWaypoints` `'), (179, 'ALTER TABLE `server` CHANGE `ServerToolsDetected` `ServerToolsDetected` TINYINT(1) NULL DEFAULT \'0\', CHANGE `disableTPinPVP` `disableTPinPVP` TINYINT(1) NULL DEFAULT \'0\', CHANGE `updateBot` `updateBot` TINYINT(1) NULL DEFAULT \'1\', CHANGE `waypointCreateCost` `waypointCreateCost` INT(11) NULL DEFAULT \'0\', CHANGE `scanErrors` `scanErrors` TINYINT(1) NULL DEFAULT \'0\', CHANGE `alertSpending` `alertSpending` TINYINT(1) NULL DEFAULT \'0\', CHANGE `GBLBanThreshold` `GBLBanThreshold` INT(11) NULL DEFAULT \'0\', CHANGE `lastBotsMessageID` `lastBotsMessageID` INT(11) NULL DEFAULT \'0\', CHANGE `lastBotsMessageTimestamp` `lastBotsMessageTimestamp` INT(11) NULL DEFAULT \'0\', CHANGE `gimmeZombies` `gimmeZombies` TINYINT(1) NULL DEFAULT \'1\', CHANGE `allowProxies` `allowProxies` TINYINT(1) NULL DEFAULT \'0\', CHANGE `SDXDetected` `SDXDetected` TINYINT(1) NULL DEFAULT \'0\', CHANGE `enableWindowMessages` `enableWindowMessages` TINYINT(1) NULL DEFAULT \'0\', CHANGE `updateBranch` `updateBranch` VARCHAR(30) NULL DEF'), (180, 'ALTER TABLE `server` CHANGE `commandCooldown` `commandCooldown` INT(11) NULL DEFAULT \'0\', CHANGE `telnetPass` `telnetPass` VARCHAR(50) NULL DEFAULT \'\', CHANGE `telnetPort` `telnetPort` INT(11) NULL DEFAULT \'0\', CHANGE `feralRebootDelay` `feralRebootDelay` INT(11) NULL DEFAULT \'68\', CHANGE `pvpTeleportCooldown` `pvpTeleportCooldown` INT(11) NULL DEFAULT \'0\', CHANGE `allowPlayerToPlayerTeleporting` `allowPlayerToPlayerTeleporting` TINYINT(1) NULL DEFAULT \'1\', CHANGE `ircPort` `ircPort` INT(11) NULL DEFAULT \'6667\', CHANGE `botRestartHour` `botRestartHour` INT(11) NULL DEFAULT \'25\', CHANGE `trackingKeepDays` `trackingKeepDays` INT(11) NULL DEFAULT \'28\', CHANGE `databaseMaintenanceFinished` `databaseMaintenanceFinished` TINYINT(1) NULL DEFAULT \'1\', CHANGE `allowHomeTeleport` `allowHomeTeleport` TINYINT(1) NULL DEFAULT \'1\', CHANGE `playerTeleportDelay` `playerTeleportDelay` INT(11) NULL DEFAULT \'0\', CHANGE `allowPackTeleport` `allowPackTeleport` TINYINT(1) NULL DEFAULT \'1\', CHANGE `gameVersi'), (181, 'ALTER TABLE `server` CHANGE `perMinutePayRate` `perMinutePayRate` FLOAT NULL DEFAULT \'0\', CHANGE `disableWatchAlerts` `disableWatchAlerts` TINYINT(1) NULL DEFAULT \'0\', CHANGE `masterPassword` `masterPassword` VARCHAR(50) NULL DEFAULT \'\', CHANGE `allowBotRestarts` `allowBotRestarts` TINYINT(1) NULL DEFAULT \'0\', CHANGE `botOwner` `botOwner` VARCHAR(17) NULL DEFAULT \'0\', CHANGE `returnCooldown` `returnCooldown` INT(11) NULL DEFAULT \'0\', CHANGE `botRestartDay` `botRestartDay` INT(11) NULL DEFAULT \'7\', CHANGE `enableTimedClaimScan` `enableTimedClaimScan` TINYINT(1) NULL DEFAULT \'1\', CHANGE `enableScreamerAlert` `enableScreamerAlert` TINYINT(1) NULL DEFAULT \'1\', CHANGE `enableAirdropAlert` `enableAirdropAlert` TINYINT(1) NULL DEFAULT \'1\', CHANGE `spleefGameCoords` `spleefGameCoords` VARCHAR(20) NULL DEFAULT \'4000 225 4000\', CHANGE `gimmeResetTime` `gimmeResetTime` INT(11) NULL DEFAULT \'120\', CHANGE `gimmeRaincheck` `gimmeRaincheck` INT(11) NULL DEFAULT \'0\', CHANGE `pingKickTarget` `pingKickT'), (182, 'ALTER TABLE `server` CHANGE `banVACBannedPlayers` `banVACBannedPlayers` TINYINT(1) NULL DEFAULT \'0\', CHANGE `deathCost` `deathCost` INT(11) NULL DEFAULT \'0\', CHANGE `showLocationMessages` `showLocationMessages` TINYINT(1) NULL DEFAULT \'1\', CHANGE `bountyRewardItem` `bountyRewardItem` VARCHAR(25) NULL DEFAULT \'cash\', CHANGE `enableLagCheck` `enableLagCheck` TINYINT(1) NULL DEFAULT \'1\', CHANGE `allowSecondBaseWithoutDonor` `allowSecondBaseWithoutDonor` TINYINT(1) NULL DEFAULT \'0\', CHANGE `nonAlphabeticChatReaction` `nonAlphabeticChatReaction` VARCHAR(10) NULL DEFAULT \'nothing\', CHANGE `lotteryTicketPrice` `lotteryTicketPrice` INT(11) NULL DEFAULT \'25\', CHANGE `newPlayerMaxLevel` `newPlayerMaxLevel` INT(11) NULL DEFAULT \'9\', CHANGE `hordeNight` `hordeNight` INT(11) NULL DEFAULT \'7\', CHANGE `hideUnknownCommand` `hideUnknownCommand` TINYINT(1) NULL DEFAULT \'0\', CHANGE `beQuietBot` `beQuietBot` TINYINT(1) NULL DEFAULT \'0\', CHANGE `gimmeResetTimer` `gimmeResetTimer` INT(11) NULL DEFAULT \'120\''), (183, 'ALTER TABLE `server` CHANGE `webPanelPort` `webPanelPort` INT(11) NULL DEFAULT \'0\', CHANGE `allocsWebAPIUser` `allocsWebAPIUser` VARCHAR(100) NULL DEFAULT \'\', CHANGE `allocsWebAPIPassword` `allocsWebAPIPassword` VARCHAR(100) NULL DEFAULT \'\', CHANGE `useAllocsWebAPI` `useAllocsWebAPI` TINYINT(1) NULL DEFAULT \'0\', CHANGE `defaultWatchTimer` `defaultWatchTimer` INT(11) NULL DEFAULT \'259200\', CHANGE `archivePlayersLastSeenDays` `archivePlayersLastSeenDays` INT(11) NULL DEFAULT \'60\', CHANGE `playersLastArchived` `playersLastArchived` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, CHANGE `alertLevelHack` `alertLevelHack` TINYINT(1) NULL DEFAULT \'1\', CHANGE `logBotCommands` `logBotCommands` TINYINT(1) NULL DEFAULT \'0\', CHANGE `logInventory` `logInventory` TINYINT(1) NULL DEFAULT \'1\', CHANGE `removeExpiredClaims` `removeExpiredClaims` TINYINT(1) NULL DEFAULT \'0\', CHANGE `baseDeadzone` `baseDeadzone` INT(11) NULL DEFAULT \'0\', CHANGE `reservedSlotTimelimit` `reservedSlotTimelimit` INT(11) NULL DEFAUL'), (184, 'ALTER TABLE `server` CHANGE `ircWatchPassword` `ircWatchPassword` VARCHAR(30) NULL DEFAULT \'\', CHANGE `chatColourPrivate` `chatColourPrivate` VARCHAR(6) NULL DEFAULT \'FFFFFF\', CHANGE `botNameColour` `botNameColour` VARCHAR(6) NULL DEFAULT \'FFFFFF\', CHANGE `disableFetch` `disableFetch` TINYINT(1) NULL DEFAULT \'0\', CHANGE `p2pCooldown` `p2pCooldown` INT(11) NULL DEFAULT \'0\', CHANGE `telnetFallback` `telnetFallback` TINYINT(1) NULL DEFAULT \'0\' COMMENT \'Use telnet when API not working\', CHANGE `botsIP` `botsIP` VARCHAR(100) NULL DEFAULT \'0.0.0.0\''), (185, 'ALTER TABLE `server` CHANGE `rules` `rules` VARCHAR(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT \'A zombie ate the server rules! Tell an admin.\', CHANGE `shopLocation` `shopLocation` VARCHAR(30) NULL DEFAULT \'\', CHANGE `blockCountries` `blacklistCountries` VARCHAR(100) NULL DEFAULT \'CN,HK\', CHANGE `IP` `IP` VARCHAR(100) NULL DEFAULT \'0.0.0.0\', CHANGE `date` `date` VARCHAR(10) NULL DEFAULT \'\', CHANGE `welcome` `welcome` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT \'\', CHANGE `MOTD` `MOTD` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT \'\', CHANGE `website` `website` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT \'\', CHANGE `ircServer` `ircServer` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT \'127.0.0.1\', CHANGE `serverGroup` `serverGroup` VARCHAR(20) NULL DEFAULT \'\''), (186, 'ALTER TABLE `server` ADD `idleKickTimer` INT NULL DEFAULT \'900\', ADD `idleKickAnytime` TINYINT(1) NOT NULL DEFAULT \'0\''), (187, 'ALTER TABLE `server` ADD `newPlayerTimer` INT(11) NULL DEFAULT 120'), (188, 'ALTER TABLE `server` ADD `newPlayerMaxLevel` INT(11) NULL DEFAULT 9'), (189, 'ALTER TABLE `server` ADD `disableLinkedWaypoints` TINYINT(1) NULL DEFAULT \'0\''), (190, 'ALTER TABLE `server` ADD `p2pMinimumAccess` INT NULL DEFAULT \'99\''), (191, 'ALTER TABLE `server` ADD `pvpTempBanCooldown` INT NULL DEFAULT \'60\''), (192, 'ALTER TABLE `alerts` ADD `status` VARCHAR(30) NULL DEFAULT \'\''), (193, 'ALTER TABLE `badItems` ADD `validated` TINYINT(1) NULL DEFAULT \'1\''), (194, 'ALTER TABLE `bases` DROP PRIMARY KEY, ADD PRIMARY KEY(`steam`,`baseNumber`)'), (195, 'ALTER TABLE `customCommands_Detail` DROP PRIMARY KEY , ADD PRIMARY KEY (`detailID`,`commandID`)'), (196, 'ALTER TABLE `donors` ADD `name` VARCHAR(100) NULL DEFAULT \'\''), (197, 'ALTER TABLE `friends` ADD `autoAdded` TINYINT(1) NULL DEFAULT \'0\''), (198, 'ALTER TABLE `gimmePrizes` ADD `quality` INT NULL DEFAULT \'0\''), (199, 'ALTER TABLE `gimmePrizes` ADD `validated` TINYINT(1) NULL DEFAULT \'1\''), (200, 'ALTER TABLE `gimmeZombies` ADD `entityID` INT NULL DEFAULT \'0\''), (201, 'ALTER TABLE `gimmeZombies` ADD `bossZombie` TINYINT(1) NULL DEFAULT \'0\''), (202, 'ALTER TABLE `gimmeZombies` ADD `doNotSpawn` TINYINT(1) NULL DEFAULT \'0\''), (203, 'ALTER TABLE `gimmeZombies` ADD `maxHealth` INT NULL DEFAULT \'0\''), (204, 'ALTER TABLE `hotspots` ADD `action` VARCHAR(10) NULL DEFAULT \'\''), (205, 'ALTER TABLE `hotspots` ADD `destination` VARCHAR(20) NULL DEFAULT \'\''), (206, 'ALTER TABLE `inventoryChanges` ADD `flag` VARCHAR(3) DEFAULT \'\''), (207, 'ALTER TABLE `IPBlacklist` ADD `DateAdded` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP , ADD `botID` INT NULL DEFAULT \'0\' , ADD `steam` BIGINT(17) NULL DEFAULT \'0\' , ADD `playerName` VARCHAR(25) NULL DEFAULT \'\''), (208, 'ALTER TABLE `IPBlacklist` ADD `Country` VARCHAR(2) DEFAULT \'\''), (209, 'ALTER TABLE `keystones` ADD `expired` TINYINT(1) NULL DEFAULT \'0\''), (210, 'ALTER TABLE `list` ADD `steam` BIGINT(17) NULL DEFAULT \'0\''), (211, 'ALTER TABLE `list` ADD `id` INT NULL DEFAULT \'0\' , ADD `class` VARCHAR(20) NULL DEFAULT \'\''), (212, 'ALTER TABLE `locations` ADD `timeOpen` INT NULL DEFAULT \'0\' , ADD `timeClosed` INT NULL DEFAULT \'0\''), (213, 'ALTER TABLE `locations` ADD `allowWaypoints` TINYINT(1) NULL DEFAULT \'1\' , ADD `allowReturns` TINYINT(1) NULL DEFAULT \'1\', ADD `allowLeave` TINYINT(1) NULL DEFAULT \'1\''), (214, 'ALTER TABLE `locations` ADD `newPlayersOnly` TINYINT(1) NULL DEFAULT \'0\''), (215, 'ALTER TABLE `locations` ADD `minimumLevel` INT NULL DEFAULT \'0\', ADD `maximumLevel` INT NULL DEFAULT \'0\', ADD `dayClosed` INT NULL DEFAULT \'0\''), (216, 'ALTER TABLE `locations` ADD `dailyTaxRate` INT NULL DEFAULT \'0\', ADD `bank` INT NULL DEFAULT \'0\', ADD `prisonX` INT NULL DEFAULT \'0\' , ADD `prisonY` INT NULL DEFAULT \'0\' , ADD `prisonZ` INT NULL DEFAULT \'0\''), (217, 'ALTER TABLE `locations` ADD `hidden` TINYINT(1) NULL DEFAULT \'0\''), (218, 'ALTER TABLE `locations` ADD `locationCategory` VARCHAR(20) NULL DEFAULT \'\''), (219, 'ALTER TABLE `locations` ADD `coolDownTimer` INT NULL DEFAULT \'0\''), (220, 'ALTER TABLE `locations` ADD `plot` TINYINT(1) NULL DEFAULT \'0\', ADD `plotWallBock` VARCHAR(20) NULL DEFAULT \'bedrock\', ADD `plotFillBlock` VARCHAR(20) NULL DEFAULT \'dirt\', ADD `plotGridSize` INT NULL DEFAULT \'0\', ADD `plotDepth` INT NULL DEFAULT \'5\', ADD `hordeNightClosedHours` VARCHAR(5) NULL DEFAULT \'00-00\''), (221, 'ALTER TABLE `locations` ADD `watchPlayers` TINYINT(1) NULL DEFAULT \'0\''), (222, 'ALTER TABLE `locations` ADD `isRound` TINYINT(1) NULL DEFAULT \'1\''), (223, 'ALTER TABLE `locations` ADD `lobby` TINYINT(1) NULL DEFAULT \'0\''), (224, 'ALTER TABLE `locations` ADD `height` INT NULL DEFAULT \'-1\''), (225, 'ALTER TABLE `locations` ADD `allowPack` TINYINT(1) NULL DEFAULT \'1\''), (226, 'ALTER TABLE `locations` ADD `allowP2P` TINYINT(1) NULL DEFAULT \'1\''), (227, 'ALTER TABLE `memShop` ADD `units` INT NULL DEFAULT \'1\''), (228, 'ALTER TABLE `memShop` ADD `quality` INT NULL DEFAULT \'0\''), (229, 'ALTER TABLE `miscQueue` ADD `timerDelay` TIMESTAMP NULL DEFAULT \'0000-00-00 00:00:00\''), (230, 'ALTER TABLE `otherEntities` ADD `doNotDespawn` TINYINT(1) NULL DEFAULT \'0\''), (231, 'ALTER TABLE `otherEntities` ADD `remove` TINYINT(1) NULL DEFAULT \'0\''), (232, 'ALTER TABLE `playerQueue` ADD `delayTimer` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP'), (233, 'ALTER TABLE `restrictedItems` ADD `validated` TINYINT(1) NULL DEFAULT \'1\''), (234, 'ALTER TABLE `shop` ADD `validated` TINYINT(1) NULL DEFAULT \'1\''), (235, 'ALTER TABLE `shop` ADD `units` INT(1) NULL, ADD `quality` INT(0) NULL'), (236, 'ALTER TABLE `spawnableItems` ADD `craftable` TINYINT(1) NULL DEFAULT \'1\' , ADD `devBlock` TINYINT(1) NULL DEFAULT \'0\''), (237, 'ALTER TABLE `teleports` ADD `size` FLOAT(11) NULL DEFAULT \'1.5\' COMMENT \'size of start tp\' , ADD `dsize` FLOAT(11) NULL DEFAULT \'1.5\' COMMENT \'size of dest tp\''), (238, 'ALTER TABLE `teleports` ADD `minimumAccess` INT NULL DEFAULT \'0\', ADD `maximumAccess` INT NULL DEFAULT \'0\''), (239, 'ALTER TABLE `waypoints` ADD `public` TINYINT(1) NULL DEFAULT \'0\''), (240, 'ALTER TABLE `webInterfaceQueue` ADD `steam` BIGINT(17) NULL DEFAULT \'0\', ADD `actionArgs` VARCHAR(1000) NULL DEFAULT \'\', CHANGE `action` `action` VARCHAR(50), ADD `recipient` VARCHAR(5) NULL DEFAULT \'\', ADD `expire` TIMESTAMP NULL DEFAULT \'0000-00-00 00:00:00\', ADD `sessionID` VARCHAR(32) NULL DEFAULT \'\''), (241, 'ALTER TABLE `webInterfaceJSON` ADD `recipient` varchar(5) NULL DEFAULT \'\', ADD `expire` timestamp NULL DEFAULT \'0000-00-00 00:00:00\''), (242, 'ALTER TABLE `modBotman` ADD `resetsEnabled` TINYINT(1) NULL DEFAULT \'0\', ADD `resetsDelay` INT NULL DEFAULT \'999\', ADD `resetsPrefabsOnly` TINYINT(1) NULL DEFAULT \'1\', ADD `resetsRemoveLCB` TINYINT NULL DEFAULT \'1\''), (243, 'ALTER TABLE `resetZones` ADD `x` INT NULL DEFAULT \'0\', ADD `z` INT NULL DEFAULT \'0\''), (244, 'UPDATE `teleports` SET size = 1.5 WHERE size = 0'), (245, 'UPDATE `teleports` SET dsize = 1.5 WHERE dsize = 0'), (246, 'ALTER TABLE `badItems` CHANGE `action` `action` VARCHAR(10) NULL DEFAULT \'timeout\', CHANGE `validated` `validated` TINYINT(1) NULL DEFAULT \'1\''), (247, 'ALTER TABLE `badItems` CHANGE `item` `item` VARCHAR(100) NOT NULL DEFAULT \'\''), (248, 'ALTER TABLE `badWords` CHANGE `badWord` `badWord` VARCHAR(100) NULL DEFAULT \'\', CHANGE `cost` `cost` INT(11) NULL DEFAULT \'10\', CHANGE `counter` `counter` INT(11) NULL DEFAULT \'0\''), (249, 'ALTER TABLE `bans` CHANGE `BannedTo` `BannedTo` VARCHAR(22) NULL DEFAULT \'\', CHANGE `Reason` `Reason` VARCHAR(255) NULL DEFAULT \'\', CHANGE `expiryDate` `expiryDate` DATETIME NULL, CHANGE `Steam` `Steam` BIGINT(17) NOT NULL DEFAULT \'0\''), (250, 'ALTER TABLE `bases` CHANGE `title` `title` VARCHAR(100) NULL DEFAULT \'\', CHANGE `x` `x` INT(11) NULL DEFAULT \'0\', CHANGE `y` `y` INT(11) NULL DEFAULT \'0\', CHANGE `z` `z` INT(11) NULL DEFAULT \'0\', CHANGE `exitX` `exitX` INT(11) NULL DEFAULT \'0\', CHANGE `exitY` `exitY` INT(11) NULL DEFAULT \'0\', CHANGE `exitZ` `exitZ` INT(11) NULL DEFAULT \'0\', CHANGE `size` `size` INT(11) NULL DEFAULT \'0\', CHANGE `protect` `protect` TINYINT(1) NULL DEFAULT \'0\', CHANGE `keepOut` `keepOut` TINYINT(1) NULL DEFAULT \'0\', CHANGE `creationTimestamp` `creationTimestamp` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, CHANGE `creationGameDay` `creationGameDay` INT(11) NULL DEFAULT \'0\', CHANGE `steam` `steam` BIGINT(17) NOT NULL DEFAULT \'0\''), (251, 'ALTER TABLE `commandAccessRestrictions` CHANGE `functionName` `functionName` VARCHAR(100) NULL DEFAULT \'\', CHANGE `accessLevel` `accessLevel` INT(11) NULL DEFAULT \'3\''), (252, 'ALTER TABLE `customCommands` CHANGE `command` `command` VARCHAR(50) NULL DEFAULT \'\', CHANGE `accessLevel` `accessLevel` INT(11) NULL DEFAULT \'2\', CHANGE `help` `help` VARCHAR(255) NULL DEFAULT \'\''), (253, 'ALTER TABLE `customCommands_Detail` CHANGE `action` `action` VARCHAR(5) NULL DEFAULT \'\' COMMENT \'say,give,tele,spawn,buff,cmd\', CHANGE `thing` `thing` VARCHAR(255) NULL DEFAULT \'\', CHANGE `commandID` `commandID` INT(11) NOT NULL DEFAULT \'0\''), (254, 'ALTER TABLE `customMessages` CHANGE `message` `message` VARCHAR(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT \'\', CHANGE `accessLevel` `accessLevel` INT(11) NULL DEFAULT \'99\', CHANGE `command` `command` VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT \'\''), (255, 'ALTER TABLE `donors` CHANGE `level` `level` INT(11) NULL DEFAULT \'0\', CHANGE `name` `name` VARCHAR(100) NULL DEFAULT \'\', CHANGE `expiry` `expiry` INT(11) NULL DEFAULT NULL, CHANGE `steam` `steam` BIGINT(17) NOT NULL'), (256, 'ALTER TABLE `friends` CHANGE `autoAdded` `autoAdded` TINYINT(1) NULL DEFAULT \'0\''), (257, 'ALTER TABLE `gimmePrizes` CHANGE `category` `category` VARCHAR(15) NULL DEFAULT \'\', CHANGE `prizeLimit` `prizeLimit` INT(11) NULL DEFAULT \'1\', CHANGE `quality` `quality` INT(11) NULL DEFAULT \'0\', CHANGE `validated` `validated` TINYINT(1) NULL DEFAULT \'1\', CHANGE `name` `name` VARCHAR(100) NOT NULL DEFAULT \'\''), (258, 'ALTER TABLE `gimmeZombies` CHANGE `zombie` `zombie` VARCHAR(50) NULL DEFAULT \'\', CHANGE `minPlayerLevel` `minPlayerLevel` INT(11) NULL DEFAULT \'1\', CHANGE `minArenaLevel` `minArenaLevel` INT(11) NULL DEFAULT \'1\', CHANGE `bossZombie` `bossZombie` TINYINT(1) NULL DEFAULT \'0\', CHANGE `doNotSpawn` `doNotSpawn` TINYINT(1) NULL DEFAULT \'0\', CHANGE `maxHealth` `maxHealth` INT(11) NULL DEFAULT \'0\', CHANGE `remove` `remove` TINYINT(1) NULL DEFAULT \'0\''), (259, 'ALTER TABLE `hotspots` CHANGE `hotspot` `hotspot` VARCHAR(500) NULL DEFAULT \'\', CHANGE `x` `x` INT(11) NULL DEFAULT \'0\', CHANGE `y` `y` INT(11) NULL DEFAULT \'0\', CHANGE `z` `z` INT(11) NULL DEFAULT \'0\', CHANGE `size` `size` INT(11) NULL DEFAULT \'2\', CHANGE `owner` `owner` BIGINT(17) NULL DEFAULT \'0\', CHANGE `idx` `idx` INT(11) NULL DEFAULT \'0\', CHANGE `action` `action` VARCHAR(10) NULL DEFAULT \'\', CHANGE `destination` `destination` VARCHAR(20) NULL DEFAULT \'\''), (260, 'ALTER TABLE `locationCategories` CHANGE `minAccessLevel` `minAccessLevel` INT(11) NULL DEFAULT \'99\', CHANGE `maxAccessLevel` `maxAccessLevel` INT(11) NULL DEFAULT \'0\''), (261, 'ALTER TABLE `locations` CHANGE `x` `x` INT(11) NULL DEFAULT \'0\', CHANGE `y` `y` INT(11) NULL DEFAULT \'0\', CHANGE `z` `z` INT(11) NULL DEFAULT \'0\', CHANGE `public` `public` TINYINT(1) NULL DEFAULT \'0\', CHANGE `active` `active` TINYINT(1) NULL DEFAULT \'1\', CHANGE `owner` `owner` BIGINT(17) NULL DEFAULT \'0\', CHANGE `village` `village` TINYINT(1) NULL DEFAULT \'0\', CHANGE `pvp` `pvp` TINYINT(1) NULL DEFAULT \'0\', CHANGE `protectSize` `protectSize` INT(11) NULL DEFAULT \'50\', CHANGE `exitX` `exitX` INT(11) NULL DEFAULT \'0\', CHANGE `exitY` `exitY` INT(11) NULL DEFAULT \'0\', CHANGE `exitZ` `exitZ` INT(11) NULL DEFAULT \'0\', CHANGE `cost` `cost` INT(11) NULL DEFAULT \'0\', CHANGE `allowBase` `allowBase` TINYINT(1) NULL DEFAULT \'0\', CHANGE `protected` `protected` TINYINT(1) NULL DEFAULT \'0\', CHANGE `accessLevel` `accessLevel` INT(11) NULL DEFAULT \'99\', CHANGE `size` `size` INT(11) NULL DEFAULT \'20\', CHANGE `mayor` `mayor` BIGINT(17) NULL DEFAULT \'0\', CHANGE `resetZone` `resetZone` TINYINT(1) NULL DEFA'); INSERT INTO `altertables` (`id`, `statement`) VALUES (262, 'ALTER TABLE `locations` CHANGE `newPlayersOnly` `newPlayersOnly` TINYINT(1) NULL DEFAULT \'0\', CHANGE `minimumLevel` `minimumLevel` INT(11) NULL DEFAULT \'0\', CHANGE `maximumLevel` `maximumLevel` INT(11) NULL DEFAULT \'0\', CHANGE `dayClosed` `dayClosed` INT(11) NULL DEFAULT \'0\', CHANGE `dailyTaxRate` `dailyTaxRate` INT(11) NULL DEFAULT \'0\', CHANGE `bank` `bank` INT(11) NULL DEFAULT \'0\', CHANGE `prisonX` `prisonX` INT(11) NULL DEFAULT \'0\', CHANGE `prisonY` `prisonY` INT(11) NULL DEFAULT \'0\', CHANGE `prisonZ` `prisonZ` INT(11) NULL DEFAULT \'0\', CHANGE `hidden` `hidden` TINYINT(1) NULL DEFAULT \'0\', CHANGE `locationCategory` `locationCategory` VARCHAR(20) NULL DEFAULT \'\', CHANGE `coolDownTimer` `coolDownTimer` INT(11) NULL DEFAULT \'0\', CHANGE `plot` `plot` TINYINT(1) NULL DEFAULT \'0\', CHANGE `plotWallBock` `plotWallBock` VARCHAR(20) NULL DEFAULT \'terrBedrock\', CHANGE `plotFillBlock` `plotFillBlock` VARCHAR(20) NULL DEFAULT \'terrDirt\', CHANGE `plotGridSize` `plotGridSize` INT(11) NULL DEFAULT '), (263, 'ALTER TABLE `modBotman` CHANGE `clanEnabled` `clanEnabled` TINYINT(1) NULL DEFAULT \'0\', CHANGE `clanMaxClans` `clanMaxClans` INT(11) NULL DEFAULT \'0\', CHANGE `clanMaxPlayers` `clanMaxPlayers` INT(11) NULL DEFAULT \'0\', CHANGE `clanMinLevel` `clanMinLevel` INT(11) NULL DEFAULT \'0\''), (264, 'ALTER TABLE `otherEntities` CHANGE `entityID` `entityID` INT(11) NULL DEFAULT \'0\', CHANGE `doNotSpawn` `doNotSpawn` TINYINT(1) NULL DEFAULT \'0\', CHANGE `doNotDespawn` `doNotDespawn` TINYINT(1) NULL DEFAULT \'0\', CHANGE `remove` `remove` TINYINT(1) NULL DEFAULT \'0\', CHANGE `entity` `entity` VARCHAR(50) NOT NULL DEFAULT \'\''), (265, 'ALTER TABLE `reservedSlots` CHANGE `steam` `steam` BIGINT(17) NOT NULL DEFAULT \'0\', CHANGE `timeAdded` `timeAdded` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, CHANGE `reserved` `reserved` TINYINT(1) NULL DEFAULT \'0\', CHANGE `staff` `staff` TINYINT(1) NULL DEFAULT \'0\', CHANGE `totalPlayTime` `totalPlayTime` INT(11) NULL DEFAULT \'0\', CHANGE `deleteRow` `deleteRow` TINYINT(1) NULL DEFAULT \'0\', ENGINE = MEMORY'), (266, 'ALTER TABLE `restrictedItems` CHANGE `qty` `qty` INT(11) NULL DEFAULT \'65\', CHANGE `accessLevel` `accessLevel` INT(11) NULL DEFAULT \'90\', CHANGE `action` `action` VARCHAR(30) NULL DEFAULT \'\', CHANGE `validated` `validated` TINYINT(1) NULL DEFAULT \'1\''), (267, 'ALTER TABLE `shop` CHANGE `item` `item` VARCHAR(100) NOT NULL DEFAULT \'\', CHANGE `category` `category` VARCHAR(20) NULL DEFAULT \'misc\', CHANGE `price` `price` INT(11) NULL DEFAULT \'50\', CHANGE `stock` `stock` INT(11) NULL DEFAULT \'50\', CHANGE `idx` `idx` INT(11) NULL DEFAULT \'0\', CHANGE `maxStock` `maxStock` INT(11) NULL DEFAULT \'50\', CHANGE `variation` `variation` INT(11) NULL DEFAULT \'0\', CHANGE `special` `special` INT(11) NULL DEFAULT \'0\', CHANGE `validated` `validated` TINYINT(1) NULL DEFAULT \'1\', CHANGE `units` `units` INT(11) NULL DEFAULT \'1\', CHANGE `quality` `quality` INT(11) NULL DEFAULT \'3\''), (268, 'ALTER TABLE `shopCategories` CHANGE `category` `category` VARCHAR(20) NOT NULL DEFAULT \'\', CHANGE `idx` `idx` INT(11) NULL DEFAULT \'0\', CHANGE `code` `code` VARCHAR(3) NULL DEFAULT \'\''), (269, 'ALTER TABLE `slots` CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\', CHANGE `online` `online` TINYINT(1) NULL DEFAULT \'0\', CHANGE `joinedTime` `joinedTime` TIMESTAMP NULL DEFAULT \'0000-00-00 00:00:00\', CHANGE `joinedSession` `joinedSession` INT(11) NULL DEFAULT \'0\', CHANGE `expires` `expires` TIMESTAMP NULL DEFAULT \'0000-00-00 00:00:00\', CHANGE `reserved` `reserved` TINYINT(1) NULL DEFAULT \'0\', CHANGE `staff` `staff` TINYINT(1) NULL DEFAULT \'0\', CHANGE `free` `free` TINYINT(1) NULL DEFAULT \'1\', CHANGE `canBeKicked` `canBeKicked` TINYINT(1) NULL DEFAULT \'1\', CHANGE `disconnectedTimestamp` `disconnectedTimestamp` TIMESTAMP NULL DEFAULT \'0000-00-00 00:00:00\''), (270, 'ALTER TABLE `spawnableItems` CHANGE `itemName` `itemName` VARCHAR(100) NOT NULL DEFAULT \'\', CHANGE `deleteItem` `deleteItem` TINYINT(1) NULL DEFAULT \'0\', CHANGE `accessLevelRestriction` `accessLevelRestriction` INT(11) NULL DEFAULT \'99\', CHANGE `category` `category` VARCHAR(20) NULL DEFAULT \'None\', CHANGE `price` `price` INT(11) NULL DEFAULT \'10000\', CHANGE `stock` `stock` INT(11) NULL DEFAULT \'5000\', CHANGE `idx` `idx` INT(11) NULL DEFAULT \'0\', CHANGE `maxStock` `maxStock` INT(11) NULL DEFAULT \'5000\', CHANGE `inventoryResponse` `inventoryResponse` VARCHAR(10) NULL DEFAULT \'none\', CHANGE `StackLimit` `StackLimit` INT(11) NULL DEFAULT \'1000\', CHANGE `newPlayerMaxInventory` `newPlayerMaxInventory` INT(11) NULL DEFAULT \'-1\', CHANGE `units` `units` INT(11) NULL DEFAULT \'1\', CHANGE `craftable` `craftable` TINYINT(1) NULL DEFAULT \'1\', CHANGE `devBlock` `devBlock` TINYINT(1) NULL DEFAULT \'0\''), (271, 'ALTER TABLE `staff` CHANGE `adminLevel` `adminLevel` INT(11) NULL DEFAULT \'2\', CHANGE `blockDelete` `blockDelete` TINYINT(1) NULL DEFAULT \'0\''), (272, 'ALTER TABLE `teleports` CHANGE `name` `name` VARCHAR(100), CHANGE `active` `active` TINYINT(1) NULL DEFAULT \'1\', CHANGE `owner` `owner` BIGINT(17) NULL DEFAULT \'0\', CHANGE `oneway` `oneway` TINYINT(1) NULL DEFAULT \'0\', CHANGE `x` `x` INT(11) NULL DEFAULT \'0\', CHANGE `y` `y` INT(11) NULL DEFAULT \'0\', CHANGE `z` `z` INT(11) NULL DEFAULT \'0\', CHANGE `dx` `dx` INT(11) NULL DEFAULT \'0\', CHANGE `dy` `dy` INT(11) NULL DEFAULT \'0\', CHANGE `dz` `dz` INT(11) NULL DEFAULT \'0\', CHANGE `friends` `friends` TINYINT(1) NULL DEFAULT \'0\', CHANGE `public` `public` TINYINT(1) NULL DEFAULT \'0\', CHANGE `size` `size` FLOAT NULL DEFAULT \'1.5\' COMMENT \'size of start tp\', CHANGE `dsize` `dsize` FLOAT NULL DEFAULT \'1.5\' COMMENT \'size of dest tp\', CHANGE `minimumAccess` `minimumAccess` INT(11) NULL DEFAULT \'0\', CHANGE `maximumAccess` `maximumAccess` INT(11) NULL DEFAULT \'0\''), (273, 'ALTER TABLE `waypoints` CHANGE `name` `name` VARCHAR(50), CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\', CHANGE `x` `x` INT(11) NULL DEFAULT \'0\', CHANGE `y` `y` INT(11) NULL DEFAULT \'0\', CHANGE `z` `z` INT(11) NULL DEFAULT \'0\', CHANGE `linked` `linked` INT(11) NULL DEFAULT \'0\', CHANGE `shared` `shared` TINYINT(1) NULL DEFAULT \'0\', CHANGE `public` `public` TINYINT(1) NULL DEFAULT \'0\''), (274, 'ALTER TABLE `webInterfaceJSON` CHANGE `ident` `ident` VARCHAR(50) NOT NULL DEFAULT \'\', CHANGE `json` `json` TEXT NULL, CHANGE `sessionID` `sessionID` VARCHAR(32) NULL DEFAULT \'\', CHANGE `recipient` `recipient` VARCHAR(5) NULL DEFAULT \'\', CHANGE `expire` `expire` TIMESTAMP NULL DEFAULT \'0000-00-00 00:00:00\''), (275, 'ALTER TABLE `webInterfaceQueue` CHANGE `actionTable` `actionTable` VARCHAR(50) NULL DEFAULT \'\', CHANGE `action` `action` VARCHAR(50) NULL DEFAULT \'\', CHANGE `actionQuery` `actionQuery` TEXT NULL DEFAULT \'\', CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\', CHANGE `actionArgs` `actionArgs` VARCHAR(1000) NULL DEFAULT \'\', CHANGE `recipient` `recipient` VARCHAR(5) NULL DEFAULT \'\', CHANGE `expire` `expire` TIMESTAMP NULL DEFAULT \'0000-00-00 00:00:00\', CHANGE `sessionID` `sessionID` VARCHAR(32) NULL DEFAULT \'\''), (276, 'ALTER TABLE `miscQueue` CHANGE `command` `command` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT \'\', CHANGE `id` `id` BIGINT(20) NOT NULL AUTO_INCREMENT, CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\', CHANGE `action` `action` VARCHAR(15) NULL DEFAULT \'\', CHANGE `value` `value` INT(11) NULL DEFAULT \'0\', CHANGE `timerDelay` `timerDelay` TIMESTAMP NULL DEFAULT \'0000-00-00 00:00:00\''), (277, 'ALTER TABLE `botChat` MODIFY `botChatID` int(11) NOT NULL AUTO_INCREMENT'), (278, 'ALTER TABLE `botChatResponses` MODIFY `botChatResponseID` int(11) NOT NULL AUTO_INCREMENT'), (279, 'ALTER TABLE `memShop` CHANGE `item` `item` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `code` `code` VARCHAR(10) NULL DEFAULT \'\', CHANGE `category` `category` VARCHAR(20) NULL DEFAULT \'\', CHANGE `price` `price` INT(11) NULL DEFAULT \'50\', CHANGE `stock` `stock` INT(11) NULL DEFAULT \'50\', CHANGE `idx` `idx` INT(11) NULL DEFAULT \'0\', CHANGE `units` `units` INT(11) NULL DEFAULT \'1\', CHANGE `quality` `quality` INT(11) NULL DEFAULT \'0\''), (280, 'ALTER TABLE `events` CHANGE `event` `event` VARCHAR(255) NULL DEFAULT \'\', CHANGE `type` `type` VARCHAR(15) NULL DEFAULT \'\', CHANGE `serverTime` `serverTime` VARCHAR(19) NULL DEFAULT \'\', CHANGE `z` `z` INT(11) NULL DEFAULT \'0\', CHANGE `y` `y` INT(11) NULL DEFAULT \'0\', CHANGE `x` `x` INT(11) NULL DEFAULT \'0\', CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\', CHANGE `timestamp` `timestamp` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP'), (281, 'ALTER TABLE `lottery` CHANGE `steam` `steam` BIGINT(17) NOT NULL DEFAULT \'0\''), (282, 'ALTER TABLE `memLottery` CHANGE `steam` `steam` BIGINT(17) NOT NULL DEFAULT \'0\''), (283, 'ALTER TABLE `playerNotes` CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\', CHANGE `createdBy` `createdBy` BIGINT(17) NULL DEFAULT \'0\', CHANGE `note` `note` VARCHAR(400) NULL DEFAULT \'\''), (284, 'ALTER TABLE `whitelist` CHANGE `steam` `steam` BIGINT(17) NOT NULL DEFAULT \'0\''), (285, 'ALTER TABLE `memEntities` ENGINE = MEMORY'), (286, 'ALTER TABLE `helpTopics` CHANGE `description` `description` TEXT NULL DEFAULT \'\', CHANGE `topic` `topic` VARCHAR(50) NULL DEFAULT \'\''), (287, 'ALTER TABLE `helpCommands` CHANGE `command` `command` TEXT NULL DEFAULT \'\', CHANGE `description` `description` TEXT NULL DEFAULT \'\', CHANGE `keywords` `keywords` VARCHAR(150) NULL DEFAULT \'\', CHANGE `notes` `notes` TEXT NULL DEFAULT \'\', CHANGE `lastUpdate` `lastUpdate` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, CHANGE `accessLevel` `accessLevel` INT(11) NULL DEFAULT \'99\', CHANGE `ingameOnly` `ingameOnly` TINYINT(1) NULL DEFAULT \'0\''), (288, 'ALTER TABLE `keystones` CHANGE `removed` `removed` INT(11) NULL DEFAULT \'0\''), (289, 'UPDATE `keystones` SET removed = 0'), (290, 'ALTER TABLE `LKPQueue` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT'), (291, 'ALTER TABLE `polls` CHANGE `topic` `topic` VARCHAR(255) NULL DEFAULT \'\', CHANGE `option1` `option1` VARCHAR(255) NULL DEFAULT \'\', CHANGE `option2` `option2` VARCHAR(255) NULL DEFAULT \'\', CHANGE `option3` `option3` VARCHAR(255) NULL DEFAULT \'\', CHANGE `option4` `option4` VARCHAR(255) NULL DEFAULT \'\', CHANGE `option5` `option5` VARCHAR(255) NULL DEFAULT \'\', CHANGE `option6` `option6` VARCHAR(255) NULL DEFAULT \'\', CHANGE `author` `author` BIGINT(17) NULL DEFAULT \'0\', CHANGE `created` `created` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, CHANGE `expires` `expires` TIMESTAMP NULL DEFAULT \'0000-00-00 00:00:00\', CHANGE `responseYN` `responseYN` TINYINT(1) NULL DEFAULT \'1\', CHANGE `accessLevel` `accessLevel` INT(11) NULL DEFAULT \'90\''), (292, 'ALTER TABLE `pollVotes` CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\', CHANGE `vote` `vote` INT(11) NULL DEFAULT \'0\', CHANGE `weight` `weight` FLOAT NULL DEFAULT \'1\''), (293, 'UPDATE server SET logInventory = 1'), (294, 'ALTER TABLE `inventoryTracker` CHANGE `pack` `pack` VARCHAR(1100) NULL DEFAULT \'\', CHANGE `belt` `belt` VARCHAR(500) NULL DEFAULT \'\', CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\', CHANGE `x` `x` INT(11) NULL DEFAULT \'0\', CHANGE `y` `y` INT(11) NULL DEFAULT \'0\', CHANGE `z` `z` INT(11) NULL DEFAULT \'0\', CHANGE `session` `session` INT(11) NULL DEFAULT \'0\', CHANGE `timestamp` `timestamp` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP'), (295, 'ALTER TABLE `performance` CHANGE `serverDate` `serverDate` VARCHAR(19) NOT NULL DEFAULT \'\', CHANGE `gameTime` `gameTime` FLOAT NULL DEFAULT \'0\', CHANGE `fps` `fps` FLOAT NULL DEFAULT \'0\', CHANGE `heap` `heap` FLOAT NULL DEFAULT \'0\', CHANGE `heapMax` `heapMax` FLOAT NULL DEFAULT \'0\', CHANGE `chunks` `chunks` INT(11) NULL DEFAULT \'0\', CHANGE `cgo` `cgo` INT(11) NULL DEFAULT \'0\', CHANGE `players` `players` INT(11) NULL DEFAULT \'0\', CHANGE `zombies` `zombies` INT(11) NULL DEFAULT \'0\', CHANGE `entities` `entities` VARCHAR(12) NULL DEFAULT \'\', CHANGE `items` `items` INT(11) NULL DEFAULT \'0\', CHANGE `timestamp` `timestamp` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP'), (296, 'ALTER TABLE `alerts` CHANGE `message` `message` VARCHAR(255) NULL DEFAULT \'\', CHANGE `z` `z` INT(11) NULL DEFAULT \'0\', CHANGE `y` `y` INT(11) NULL DEFAULT \'0\', CHANGE `x` `x` INT(11) NULL DEFAULT \'0\', CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\''), (297, 'ALTER TABLE `connectQueue` CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\', CHANGE `command` `command` VARCHAR(255) NULL DEFAULT \'\', CHANGE `processed` `processed` TINYINT(1) NULL DEFAULT \'0\''), (298, 'ALTER TABLE `persistentQueue` CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\', CHANGE `action` `action` VARCHAR(15) NULL DEFAULT \'\', CHANGE `command` `command` VARCHAR(255) NULL DEFAULT \'\', CHANGE `value` `value` INT(11) NULL DEFAULT \'0\', CHANGE `timerDelay` `timerDelay` TIMESTAMP NULL DEFAULT \'0000-00-00 00:00:00\''), (299, 'ALTER TABLE `commandQueue` CHANGE `command` `command` VARCHAR(100) NULL DEFAULT \'\', CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\''), (300, 'ALTER TABLE `ircQueue` CHANGE `command` `command` VARCHAR(255) NULL DEFAULT \'\', CHANGE `name` `name` VARCHAR(20) NULL DEFAULT \'\''), (301, 'ALTER TABLE `APIQueue` CHANGE `URL` `URL` VARCHAR(500) NULL DEFAULT \'\', CHANGE `OutputFile` `OutputFile` VARCHAR(500) NULL DEFAULT \'\''), (302, 'ALTER TABLE `searchResults` CHANGE `owner` `owner` BIGINT(17) NULL DEFAULT \'0\', CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\', CHANGE `counter` `counter` INT(11) NULL DEFAULT \'0\', CHANGE `x` `x` INT(11) NULL DEFAULT \'0\', CHANGE `y` `y` INT(11) NULL DEFAULT \'0\', CHANGE `z` `z` INT(11) NULL DEFAULT \'0\', CHANGE `session` `session` INT(11) NULL DEFAULT \'0\', CHANGE `date` `date` VARCHAR(20) NULL DEFAULT \'\''), (303, 'ALTER TABLE `announcements` CHANGE `endDate` `endDate` DATE NULL, CHANGE `message` `message` VARCHAR(400) NULL DEFAULT \'\''), (304, 'ALTER TABLE `botCommands` CHANGE `cmdIndex` `cmdIndex` INT(11) NULL DEFAULT \'0\', CHANGE `accessLevel` `accessLevel` INT(11) NULL DEFAULT \'0\', CHANGE `enabled` `enabled` TINYINT(1) NULL DEFAULT \'1\', CHANGE `keywords` `keywords` VARCHAR(150) NULL DEFAULT \'\', CHANGE `shortDescription` `shortDescription` VARCHAR(255) NULL DEFAULT \'\', CHANGE `longDescription` `longDescription` VARCHAR(1000) NULL DEFAULT \'\', CHANGE `sortOrder` `sortOrder` INT(11) NULL DEFAULT \'0\''), (305, 'ALTER TABLE `gimmeQueue` CHANGE `command` `command` VARCHAR(255) NULL DEFAULT \'\', CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\''), (306, 'ALTER TABLE `IPBlacklist` CHANGE `EndIP` `EndIP` BIGINT(15) NULL DEFAULT \'0\''), (307, 'ALTER TABLE `memRestrictedItems` CHANGE `item` `item` VARCHAR(50) NULL DEFAULT \'\', CHANGE `action` `action` VARCHAR(30) NULL DEFAULT \'\', CHANGE `qty` `qty` INT(11) NULL DEFAULT \'65\', CHANGE `accessLevel` `accessLevel` INT(11) NULL DEFAULT \'90\''), (308, 'ALTER TABLE `messageQueue` CHANGE `message` `message` VARCHAR(1000) NULL DEFAULT \'\', CHANGE `sender` `sender` BIGINT(17) NULL DEFAULT \'0\', CHANGE `recipient` `recipient` BIGINT(17) NULL DEFAULT \'0\''), (309, 'ALTER TABLE `playerQueue` CHANGE `command` `command` VARCHAR(255) NULL DEFAULT \'\', CHANGE `arena` `arena` TINYINT(1) NULL DEFAULT \'0\', CHANGE `boss` `boss` TINYINT(1) NULL DEFAULT \'0\', CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\', CHANGE `delayTimer` `delayTimer` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP'), (310, 'ALTER TABLE `villagers` CHANGE `steam` `steam` BIGINT(17) NOT NULL DEFAULT \'0\', CHANGE `village` `village` VARCHAR(20) NOT NULL DEFAULT \'\''), (311, 'ALTER TABLE `tracker` CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\', CHANGE `x` `x` INT(11) NULL DEFAULT \'0\', CHANGE `y` `y` INT(11) NULL DEFAULT \'0\', CHANGE `z` `z` INT(11) NULL DEFAULT \'0\', CHANGE `timestamp` `timestamp` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP'), (312, 'ALTER TABLE `memTracker` CHANGE `admin` `admin` BIGINT(17) NULL DEFAULT \'0\', CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\', CHANGE `x` `x` INT(11) NULL DEFAULT \'0\', CHANGE `y` `y` INT(11) NULL DEFAULT \'0\', CHANGE `z` `z` INT(11) NULL DEFAULT \'0\', CHANGE `timestamp` `timestamp` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP'), (313, 'ALTER TABLE `list` CHANGE `thing` `thing` VARCHAR(255) NULL DEFAULT \'\', CHANGE `id` `id` INT(11) NULL DEFAULT \'0\', CHANGE `class` `class` VARCHAR(20) NULL DEFAULT \'\', CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\''), (314, 'ALTER TABLE `bookmarks` CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\', CHANGE `x` `x` INT(11) NULL DEFAULT \'0\', CHANGE `y` `y` INT(11) NULL DEFAULT \'0\', CHANGE `z` `z` INT(11) NULL DEFAULT \'0\', CHANGE `note` `note` VARCHAR(50) NULL DEFAULT \'\''), (315, 'ALTER TABLE `inventoryChanges` CHANGE `steam` `steam` BIGINT(17) NULL DEFAULT \'0\', CHANGE `item` `item` VARCHAR(30) NULL DEFAULT \'\', CHANGE `delta` `delta` INT(11) NULL DEFAULT \'0\', CHANGE `x` `x` INT(11) NULL DEFAULT \'0\', CHANGE `y` `y` INT(11) NULL DEFAULT \'0\', CHANGE `z` `z` INT(11) NULL DEFAULT \'0\', CHANGE `session` `session` INT(11) NULL DEFAULT \'0\', CHANGE `timestamp` `timestamp` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP'), (316, 'ALTER TABLE `proxies` CHANGE `scanString` `scanString` VARCHAR(100) NOT NULL DEFAULT \'\', CHANGE `action` `action` VARCHAR(20) NULL DEFAULT \'nothing\', CHANGE `hits` `hits` INT(11) NULL DEFAULT \'0\''), (317, 'ALTER TABLE `memIgnoredItems` CHANGE `item` `item` VARCHAR(100) NOT NULL DEFAULT \'\', CHANGE `qty` `qty` INT(11) NULL DEFAULT \'65\''), (318, 'ALTER TABLE `mail` CHANGE `sender` `sender` BIGINT(17) NULL DEFAULT \'0\', CHANGE `message` `message` VARCHAR(500) NULL DEFAULT \'\', CHANGE `status` `status` INT(11) NULL DEFAULT \'0\''), (319, 'ALTER TABLE `locationSpawns` CHANGE `location` `location` VARCHAR(20) NULL DEFAULT \'\', CHANGE `x` `x` INT(11) NULL DEFAULT \'0\', CHANGE `y` `y` INT(11) NULL DEFAULT \'0\', CHANGE `z` `z` INT(11) NULL DEFAULT \'0\''), (320, 'ALTER TABLE `locationSpawns` ADD `id` INT NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (`id`)'), (321, 'ALTER TABLE `donors` ADD `expired` TINYINT(1) NULL DEFAULT \'0\''), (322, 'ALTER TABLE `modBotman` ADD `webmapEnabled` TINYINT(1) NULL DEFAULT \'0\', ADD `webmapColour` VARCHAR(6) NULL DEFAULT \'FF0000\', ADD `webmapPath` VARCHAR(255) NULL DEFAULT \'\''), (323, 'ALTER TABLE `modBotman` ADD `anticheat` TINYINT(1) NULL DEFAULT \'0\', ADD `disableChatColours` TINYINT(1) NULL DEFAULT \'0\''), (324, 'ALTER TABLE `slots` CHANGE `joinedTime` `joinedTime` INT(11) NULL DEFAULT \'0\', CHANGE `expires` `expires` INT(11) NULL DEFAULT \'0\', CHANGE `disconnectedTimestamp` `disconnectedTimestamp` INT(11) NULL DEFAULT \'0\''), (325, 'ALTER TABLE `modBotman` ADD `botName` VARCHAR(30) NULL DEFAULT \'Bot\', ADD `botNameColourPublic` VARCHAR(6) NULL DEFAULT \'FFFFFF\', ADD `botNameColourPrivate` VARCHAR(6) NULL DEFAULT \'FFFFFF\', ADD `chatCommandPrefix` VARCHAR(1) NULL DEFAULT \'/\', ADD `chatCommandsHidden` TINYINT(1) NULL DEFAULT \'0\', ADD `customMessagesEnabled` TINYINT(1) NULL DEFAULT \'0\''), (326, 'ALTER TABLE `modBotman` ADD `dropminerEnabled` TINYINT(1) NULL DEFAULT \'0\', ADD `dropminerTriggerEntityCount` INT NULL DEFAULT \'0\', ADD `dropminerTriggerFallingCount` INT NULL DEFAULT \'0\', ADD `blockTreeRemoval` TINYINT(1) NULL DEFAULT \'0\', ADD `zombieAnnouncerEnabled` TINYINT(1) NULL DEFAULT \'0\''), (327, 'ALTER TABLE `modBotman` ADD `zombieFreeTimeEnabled` TINYINT(1) NULL DEFAULT \'0\', ADD `zombieFreeTimeStart` INT NULL DEFAULT \'0\', ADD `zombieFreeTimeEnd` INT NULL DEFAULT \'0\', ADD `killZonesEnabled` TINYINT(1) NULL DEFAULT \'0\', ADD `version` VARCHAR(20) NULL DEFAULT \'\''), (328, 'ALTER TABLE `slots` ADD `name` VARCHAR(100) NULL DEFAULT \'\', ADD `gameID` INT(11) NULL DEFAULT \'0\', ADD `IP` VARCHAR(15) NULL DEFAULT \'0.0.0.0\', ADD `country` VARCHAR(2) NULL DEFAULT \'\', ADD `ping` INT(11) NULL DEFAULT \'0\', ADD `level` INT(11) NULL DEFAULT \'0\', ADD `score` INT(11) NULL DEFAULT \'0\', ADD `zombieKills` INT(11) NULL DEFAULT \'0\', ADD `playerKills` INT(11) NULL DEFAULT \'0\', ADD `deaths` INT(11) NULL DEFAULT \'0\''), (329, 'ALTER TABLE `modBotman` ADD `id` INT NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (`id`)'), (330, 'ALTER TABLE `badWords` ADD PRIMARY KEY(`badWord`)'), (331, 'ALTER TABLE `modBotman` CHANGE `chatCommandsHidden` `chatCommandsHidden` TINYINT(1) NULL DEFAULT \'1\''), (332, 'UPDATE `badItems` SET action = \'ban\' WHERE item = \'*Admin\''), (333, 'DELETE FROM `badItems` WHERE item = \'*errain\''), (334, 'INSERT INTO `badItems` (`item`, `action`, `validated`) VALUES (\'terrainFiller\', \'ban\', \'1\')'), (335, 'INSERT INTO `badItems` (`item`, `action`, `validated`) VALUES (\'terrainRemove\', \'ban\', \'1\')'), (336, 'INSERT INTO `timedEvents` (`timer`, `delayMinutes`, `nextTime`, `disabled`) VALUES (\'gimmeReset\', \'120\', CURRENT_TIMESTAMP, \'0\')'), (337, 'INSERT INTO `timedEvents` (`timer`, `delayMinutes`, `nextTime`, `disabled`) VALUES (\'announcements\', \'60\', CURRENT_TIMESTAMP, \'0\')'), (338, 'DELETE FROM badItems WHERE item = \'snow\''), (339, 'ALTER TABLE `list` DROP INDEX `thing`'), (340, 'ALTER TABLE `list` DROP PRIMARY KEY'), (341, 'ALTER TABLE `resetZones` DROP COLUMN x1, DROP COLUMN x2, DROP COLUMN z1, DROP COLUMN z2'), (342, 'ALTER TABLE `bans` ADD `GBLBan` TINYINT(1) NULL DEFAULT \'0\''), (343, 'ALTER TABLE `messageQueue` ADD `messageTimestamp` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP'), (344, 'ALTER TABLE `players` ADD `ircAlias` VARCHAR(15) NULL DEFAULT \'\', ADD `ircAuthenticated` TINYINT(1) NULL DEFAULT \'0\''), (345, 'ALTER TABLE `IPBlacklist` ADD `DateAdded` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP , ADD `botID` INT NULL DEFAULT \'0\' , ADD `steam` BIGINT(17) NULL DEFAULT \'0\' , ADD `playerName` VARCHAR(25) NULL DEFAULT \'\', ADD `IP` VARCHAR(15) NULL DEFAULT \'\''), (346, 'ALTER TABLE `bans` ADD `GBLBanExpiry` DATE NOT NULL'), (347, 'ALTER TABLE `bans` ADD `GBLBanReason` VARCHAR(255) NULL DEFAULT \'\''), (348, 'ALTER TABLE `bans` ADD `GBLBanVetted` TINYINT(1) NULL DEFAULT \'0\', ADD `GBLBanActive` TINYINT(1) NULL DEFAULT \'0\''), (349, 'ALTER TABLE `bans` ADD `level` INT NULL DEFAULT \'0\''), (350, 'ALTER TABLE `IPBlacklist` ADD `OrgName` VARCHAR(100) NULL DEFAULT \'\''), (351, 'CREATE TABLE IF NOT EXISTS `IPTable` (`StartIP` bigint(15) NOT NULL,`EndIP` bigint(15) NOT NULL,`Country` varchar(2) NOT NULL DEFAULT \'\',`OrgName` varchar(100) NOT NULL DEFAULT \'\',`IP` varchar(20) NOT NULL DEFAULT \'\', PRIMARY KEY (`StartIP`)) ENGINE=InnoDB DEFAULT CHARSET=utf8'), (352, 'CREATE TABLE IF NOT EXISTS `settings` (`DNSLookupCounter` int(11) NOT NULL DEFAULT \'0\',`DNSResetCounterDate` int(11) NOT NULL DEFAULT \'10000101\') ENGINE=InnoDB DEFAULT CHARSET=utf8mb4'), (353, 'ALTER TABLE `IPTable` ADD `steam` BIGINT(17) NOT NULL DEFAULT \'0\', ADD `botID` INT NULL DEFAULT \'0\''), (354, 'ALTER TABLE servers DROP COLUMN dbName, DROP COLUMN dbUser, DROP COLUMN dbPass'); -- -------------------------------------------------------- -- -- Table structure for table `announcements` -- DROP TABLE IF EXISTS `announcements`; CREATE TABLE `announcements` ( `id` int(11) NOT NULL, `message` varchar(400) DEFAULT '', `startDate` date DEFAULT NULL, `endDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `APIQueue` -- DROP TABLE IF EXISTS `APIQueue`; CREATE TABLE `APIQueue` ( `id` bigint(20) NOT NULL, `URL` varchar(500) DEFAULT '', `OutputFile` varchar(500) DEFAULT '' ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `badItems` -- DROP TABLE IF EXISTS `badItems`; CREATE TABLE `badItems` ( `item` varchar(100) NOT NULL DEFAULT '', `action` varchar(10) DEFAULT 'timeout', `validated` tinyint(1) DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `badItems` -- INSERT INTO `badItems` (`item`, `action`, `validated`) VALUES ('artcube', 'timeout', 0), ('bedrock', 'timeout', 0), ('secureReinforcedDoorWooden', 'timeout', 0), ('terrainFiller', 'ban', 0), ('terrainRemove', 'ban', 0), ('vaultDoor03', 'timeout', 0); -- -------------------------------------------------------- -- -- Table structure for table `badWords` -- DROP TABLE IF EXISTS `badWords`; CREATE TABLE `badWords` ( `badWord` varchar(100) NOT NULL DEFAULT '', `cost` int(11) DEFAULT '10', `counter` int(11) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `bans` -- DROP TABLE IF EXISTS `bans`; CREATE TABLE `bans` ( `BannedTo` varchar(22) DEFAULT '', `Steam` bigint(17) NOT NULL DEFAULT '0', `Reason` varchar(255) DEFAULT '', `expiryDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `bases` -- DROP TABLE IF EXISTS `bases`; CREATE TABLE `bases` ( `steam` bigint(17) NOT NULL DEFAULT '0', `baseNumber` int(11) NOT NULL DEFAULT '1', `title` varchar(100) DEFAULT '', `x` int(11) DEFAULT '0', `y` int(11) DEFAULT '0', `z` int(11) DEFAULT '0', `exitX` int(11) DEFAULT '0', `exitY` int(11) DEFAULT '0', `exitZ` int(11) DEFAULT '0', `size` int(11) DEFAULT '0', `protect` tinyint(1) DEFAULT '0', `keepOut` tinyint(1) DEFAULT '0', `creationTimestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `creationGameDay` int(11) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `bookmarks` -- DROP TABLE IF EXISTS `bookmarks`; CREATE TABLE `bookmarks` ( `id` int(11) NOT NULL, `steam` bigint(17) DEFAULT '0', `x` int(11) DEFAULT '0', `y` int(11) DEFAULT '0', `z` int(11) DEFAULT '0', `note` varchar(50) DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `botChat` -- DROP TABLE IF EXISTS `botChat`; CREATE TABLE `botChat` ( `botChatID` int(11) NOT NULL, `triggerWords` varchar(255) NOT NULL DEFAULT '', `triggerPhrase` varchar(255) NOT NULL DEFAULT '', `accessLevelRestriction` int(11) NOT NULL DEFAULT '99', `mustAddressBot` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `botChatResponses` -- DROP TABLE IF EXISTS `botChatResponses`; CREATE TABLE `botChatResponses` ( `botChatResponseID` int(11) NOT NULL, `botChatID` int(11) NOT NULL DEFAULT '0', `response` varchar(300) NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `botCommands` -- DROP TABLE IF EXISTS `botCommands`; CREATE TABLE `botCommands` ( `cmdCode` varchar(5) NOT NULL, `cmdIndex` int(11) NOT NULL DEFAULT '0', `accessLevel` int(11) DEFAULT '0', `enabled` tinyint(1) DEFAULT '1', `keywords` varchar(150) DEFAULT '', `shortDescription` varchar(255) DEFAULT '', `longDescription` varchar(1000) DEFAULT '', `sortOrder` int(11) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `commandAccessRestrictions` -- DROP TABLE IF EXISTS `commandAccessRestrictions`; CREATE TABLE `commandAccessRestrictions` ( `id` int(11) NOT NULL, `functionName` varchar(100) DEFAULT '', `accessLevel` int(11) DEFAULT '3' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `commandQueue` -- DROP TABLE IF EXISTS `commandQueue`; CREATE TABLE `commandQueue` ( `id` bigint(20) NOT NULL, `steam` bigint(17) DEFAULT '0', `command` varchar(100) DEFAULT '' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `connectQueue` -- DROP TABLE IF EXISTS `connectQueue`; CREATE TABLE `connectQueue` ( `id` bigint(20) NOT NULL, `steam` bigint(17) DEFAULT '0', `command` varchar(255) DEFAULT '', `processed` tinyint(1) DEFAULT '0' ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `customCommands` -- DROP TABLE IF EXISTS `customCommands`; CREATE TABLE `customCommands` ( `commandID` int(11) NOT NULL, `command` varchar(50) DEFAULT '', `accessLevel` int(11) DEFAULT '2', `help` varchar(255) DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `customCommands_Detail` -- DROP TABLE IF EXISTS `customCommands_Detail`; CREATE TABLE `customCommands_Detail` ( `detailID` int(11) NOT NULL, `commandID` int(11) NOT NULL DEFAULT '0', `action` varchar(5) DEFAULT '' COMMENT 'say,give,tele,spawn,buff,cmd', `thing` varchar(255) DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `customMessages` -- DROP TABLE IF EXISTS `customMessages`; CREATE TABLE `customMessages` ( `command` varchar(30) CHARACTER SET utf8mb4 NOT NULL DEFAULT '', `message` varchar(500) CHARACTER SET utf8mb4 DEFAULT '', `accessLevel` int(11) DEFAULT '99' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `donors` -- DROP TABLE IF EXISTS `donors`; CREATE TABLE `donors` ( `steam` bigint(17) NOT NULL, `level` int(11) DEFAULT '0', `expiry` int(11) DEFAULT NULL, `name` varchar(100) DEFAULT '', `expired` tinyint(1) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `events` -- DROP TABLE IF EXISTS `events`; CREATE TABLE `events` ( `id` bigint(20) NOT NULL, `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `x` int(11) DEFAULT '0', `y` int(11) DEFAULT '0', `z` int(11) DEFAULT '0', `serverTime` varchar(19) DEFAULT '', `type` varchar(15) DEFAULT '', `event` varchar(255) DEFAULT '', `steam` bigint(17) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `friends` -- DROP TABLE IF EXISTS `friends`; CREATE TABLE `friends` ( `steam` bigint(17) NOT NULL, `friend` bigint(17) NOT NULL DEFAULT '0', `autoAdded` tinyint(1) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `gimmeGroup` -- DROP TABLE IF EXISTS `gimmeGroup`; CREATE TABLE `gimmeGroup` ( `groupName` varchar(30) NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `gimmePrizes` -- DROP TABLE IF EXISTS `gimmePrizes`; CREATE TABLE `gimmePrizes` ( `name` varchar(100) NOT NULL DEFAULT '', `category` varchar(15) DEFAULT '', `prizeLimit` int(11) DEFAULT '1', `quality` int(11) DEFAULT '0', `validated` tinyint(1) DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `gimmePrizes` -- INSERT INTO `gimmePrizes` (`name`, `category`, `prizeLimit`, `quality`, `validated`) VALUES ('apparelDenimPants', 'clothes', 1, 600, 1), ('apparelShades', 'clothes', 1, 0, 1), ('armorClothGloves', 'clothes', 1, 600, 1), ('armorClothHat', 'clothes', 1, 600, 1), ('armorClothJacket', 'clothes', 1, 600, 1), ('armorClothPants', 'clothes', 1, 600, 1), ('armorFootballHelmet', 'clothes', 1, 0, 1), ('armorIronGloves', 'clothes', 1, 600, 1), ('armorIronHelmet', 'clothes', 1, 600, 1), ('armorLeatherGloves', 'clothes', 1, 600, 1), ('armorLeatherPants', 'clothes', 1, 600, 1), ('armorMiningHelmet', 'clothes', 1, 600, 1), ('armorScrapGloves', 'clothes', 1, 600, 1), ('armorScrapHelmet', 'clothes', 1, 600, 1), ('carBattery', 'misc', 1, 0, 1), ('drinkJarBeer', 'food', 24, 0, 1), ('drinkJarCoffee', 'food', 15, 0, 1), ('drinkJarGoldenRodTea', 'food', 15, 0, 1), ('drinkJarGrainAlcohol', 'food', 1, 0, 1), ('drugPainkillers', 'food', 5, 0, 1), ('drugVitamins', 'food', 5, 0, 1), ('foodBaconAndEggs', 'food', 10, 0, 1), ('foodBakedPotato', 'food', 10, 0, 1), ('foodBlueberryPie', 'food', 3, 0, 1), ('foodCornBread', 'food', 20, 0, 1), ('foodCornMeal', 'food', 20, 0, 1), ('foodCornOnTheCob', 'food', 20, 0, 1), ('foodEgg', 'food', 5, 0, 1), ('foodEggBoiled', 'food', 5, 0, 1), ('foodHoney', 'food', 4, 0, 1), ('foodMeatStew', 'food', 3, 0, 1), ('foodMoldyBread', 'food', 3, 0, 1), ('foodRottingFlesh', 'food', 10, 0, 1), ('foodShamSandwich', 'food', 20, 0, 1), ('foodVegetableStew', 'food', 4, 0, 1), ('medicalAloeCream', 'health', 10, 0, 1), ('medicalBloodBag', 'health', 4, 0, 1), ('medicalFirstAidKit', 'health', 3, 0, 1), ('resourceDoorKnob', 'misc', 5, 0, 1), ('resourceRadiator', 'misc', 1, 0, 1), ('resourceScrapBrass', 'misc', 5, 0, 1), ('resourceTrophy2', 'misc', 3, 0, 1), ('resourceTrophy3', 'misc', 3, 0, 1), ('toolCookingGrill', 'misc', 1, 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `gimmeQueue` -- DROP TABLE IF EXISTS `gimmeQueue`; CREATE TABLE `gimmeQueue` ( `id` int(11) NOT NULL, `command` varchar(255) DEFAULT '', `steam` bigint(17) DEFAULT '0' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `gimmeZombies` -- DROP TABLE IF EXISTS `gimmeZombies`; CREATE TABLE `gimmeZombies` ( `zombie` varchar(50) DEFAULT '', `minPlayerLevel` int(11) DEFAULT '1', `minArenaLevel` int(11) DEFAULT '1', `entityID` int(11) NOT NULL DEFAULT '0', `bossZombie` tinyint(1) DEFAULT '0', `doNotSpawn` tinyint(1) DEFAULT '0', `maxHealth` int(11) DEFAULT '0', `remove` tinyint(1) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `gimmeZombies` -- INSERT INTO `gimmeZombies` (`zombie`, `minPlayerLevel`, `minArenaLevel`, `entityID`, `bossZombie`, `doNotSpawn`, `maxHealth`, `remove`) VALUES ('zombieTemplateMale', 1, 1, 1, 0, 1, 0, 0), ('zombieWightFeral', 1, 1, 2, 0, 1, 0, 0), ('zombieWightFeralRadiated', 1, 1, 3, 0, 1, 0, 0), ('zombieBoe', 1, 1, 4, 0, 0, 0, 0), ('zombieBoeFeral', 1, 1, 5, 0, 1, 0, 0), ('zombieFootballPlayer', 1, 1, 6, 0, 0, 0, 0), ('zombieFemaleFat', 1, 1, 7, 0, 0, 0, 0), ('zombieFemaleFatFeral', 1, 1, 8, 0, 1, 0, 0), ('zombieJoe', 1, 1, 9, 0, 0, 0, 0), ('zombieJoeFeral', 1, 1, 10, 0, 1, 0, 0), ('zombieMoe', 1, 1, 11, 0, 0, 0, 0), ('zombieMoeFeral', 1, 1, 12, 0, 1, 0, 0), ('zombieArlene', 1, 1, 13, 0, 0, 0, 0), ('zombieArleneFeral', 1, 1, 14, 0, 1, 0, 0), ('zombieScreamer', 1, 1, 15, 0, 0, 0, 0), ('zombieScreamerFeral', 1, 1, 16, 0, 1, 0, 0), ('zombieDarlene', 1, 1, 17, 0, 0, 0, 0), ('zombieDarleneFeral', 1, 1, 18, 0, 1, 0, 0), ('zombieMarlene', 1, 1, 19, 0, 0, 0, 0), ('zombieMarleneFeral', 1, 1, 20, 0, 1, 0, 0), ('zombieYo', 1, 1, 21, 0, 0, 0, 0), ('zombieYoFeral', 1, 1, 22, 0, 1, 0, 0), ('zombieSteve', 1, 1, 23, 0, 0, 0, 0), ('zombieSteveFeral', 1, 1, 24, 0, 1, 0, 0), ('zombieSteveCrawler', 1, 1, 25, 0, 0, 0, 0), ('zombieSteveCrawlerFeral', 1, 1, 26, 0, 1, 0, 0), ('zombieBusinessMan', 1, 1, 27, 0, 0, 0, 0), ('zombieBusinessManFeral', 1, 1, 28, 0, 1, 0, 0), ('zombieSnow', 1, 1, 29, 0, 0, 0, 0), ('zombieSnowFeral', 1, 1, 30, 0, 1, 0, 0), ('zombieSpider', 1, 1, 31, 0, 0, 0, 0), ('zombieSpiderFeral', 1, 1, 32, 0, 1, 0, 0), ('zombieSpiderFeralRadiated', 1, 1, 33, 0, 1, 0, 0), ('zombieBurnt', 1, 1, 34, 0, 0, 0, 0), ('zombieNurse', 1, 1, 35, 0, 0, 0, 0), ('zombieNurseFeral', 1, 1, 36, 0, 1, 0, 0), ('zombieFatHawaiian', 1, 1, 37, 0, 0, 0, 0), ('zombieFatHawaiianFeral', 1, 1, 38, 0, 1, 0, 0), ('zombieFatCop', 1, 1, 39, 0, 1, 0, 0), ('zombieFatCopFeral', 1, 1, 40, 0, 1, 0, 0), ('zombieFatCopFeralRadiated', 1, 1, 41, 0, 1, 0, 0), ('zombieMaleHazmat', 1, 1, 42, 0, 0, 0, 0), ('zombieUtilityWorker', 1, 1, 43, 0, 0, 0, 0), ('zombieUtilityWorkerFeral', 1, 1, 44, 0, 1, 0, 0), ('zombieSoldier', 1, 1, 45, 0, 0, 0, 0), ('zombieSoldierFeral', 1, 1, 46, 0, 1, 0, 0), ('zombieSkateboarder', 1, 1, 47, 0, 0, 0, 0), ('zombieSkateboarderFeral', 1, 1, 48, 0, 1, 0, 0), ('zombieCheerleader', 1, 1, 49, 0, 0, 0, 0), ('zombieCheerleaderFeral', 1, 1, 50, 0, 1, 0, 0), ('zombieOldTimer', 1, 1, 51, 0, 0, 0, 0), ('zombieOldTimerFeral', 1, 1, 52, 0, 1, 0, 0), ('zombieBiker', 1, 1, 53, 0, 0, 0, 0), ('zombieFarmer', 1, 1, 54, 0, 0, 0, 0), ('zombieFarmerFeral', 1, 1, 55, 0, 1, 0, 0), ('zombieStripper', 1, 1, 56, 0, 0, 0, 0), ('zombieStripperFeral', 1, 1, 57, 0, 1, 0, 0), ('animalZombieDog', 1, 1, 63, 0, 1, 0, 0), ('animalZombieBear', 1, 1, 65, 0, 1, 0, 0), ('animalZombieVulture', 1, 1, 68, 0, 0, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `helpCommands` -- DROP TABLE IF EXISTS `helpCommands`; CREATE TABLE `helpCommands` ( `commandID` int(11) NOT NULL, `command` text, `description` text, `notes` text, `keywords` varchar(150) DEFAULT '', `lastUpdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `accessLevel` int(11) DEFAULT '99', `ingameOnly` tinyint(1) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `helpTopicCommands` -- DROP TABLE IF EXISTS `helpTopicCommands`; CREATE TABLE `helpTopicCommands` ( `topicID` int(11) NOT NULL, `commandID` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `helpTopics` -- DROP TABLE IF EXISTS `helpTopics`; CREATE TABLE `helpTopics` ( `topicID` int(11) NOT NULL, `topic` varchar(50) DEFAULT '', `description` text ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `hotspots` -- DROP TABLE IF EXISTS `hotspots`; CREATE TABLE `hotspots` ( `id` int(11) NOT NULL, `hotspot` varchar(500) DEFAULT '', `x` int(11) DEFAULT '0', `y` int(11) DEFAULT '0', `z` int(11) DEFAULT '0', `size` int(11) DEFAULT '2', `owner` bigint(17) DEFAULT '0', `idx` int(11) DEFAULT '0', `action` varchar(10) DEFAULT '', `destination` varchar(20) DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `inventoryChanges` -- DROP TABLE IF EXISTS `inventoryChanges`; CREATE TABLE `inventoryChanges` ( `id` bigint(20) NOT NULL, `steam` bigint(17) DEFAULT '0', `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `item` varchar(30) DEFAULT '', `delta` int(11) DEFAULT '0', `x` int(11) DEFAULT '0', `y` int(11) DEFAULT '0', `z` int(11) DEFAULT '0', `session` int(11) DEFAULT '0', `flag` varchar(3) DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `inventoryTracker` -- DROP TABLE IF EXISTS `inventoryTracker`; CREATE TABLE `inventoryTracker` ( `inventoryTrackerID` bigint(20) NOT NULL, `belt` varchar(500) DEFAULT '', `pack` varchar(1100) DEFAULT '', `steam` bigint(17) DEFAULT '0', `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `x` int(11) DEFAULT '0', `y` int(11) DEFAULT '0', `z` int(11) DEFAULT '0', `session` int(11) DEFAULT '0', `equipment` varchar(500) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `IPBlacklist` -- DROP TABLE IF EXISTS `IPBlacklist`; CREATE TABLE `IPBlacklist` ( `StartIP` bigint(15) NOT NULL, `EndIP` bigint(15) DEFAULT '0', `Country` varchar(2) DEFAULT NULL, `DateAdded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `botID` int(11) NOT NULL DEFAULT '0', `steam` bigint(17) NOT NULL DEFAULT '0', `playerName` varchar(25) NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ircQueue` -- DROP TABLE IF EXISTS `ircQueue`; CREATE TABLE `ircQueue` ( `id` int(11) NOT NULL, `name` varchar(20) DEFAULT '', `command` varchar(255) DEFAULT '' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `keystones` -- DROP TABLE IF EXISTS `keystones`; CREATE TABLE `keystones` ( `steam` bigint(20) NOT NULL, `x` int(11) NOT NULL, `y` int(11) NOT NULL, `z` int(11) NOT NULL, `remove` tinyint(1) NOT NULL DEFAULT '0', `removed` int(11) DEFAULT '0', `expired` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `list` -- DROP TABLE IF EXISTS `list`; CREATE TABLE `list` ( `thing` varchar(255) DEFAULT '', `id` int(11) DEFAULT '0', `class` varchar(20) DEFAULT '', `steam` bigint(17) DEFAULT '0' ) ENGINE=MEMORY DEFAULT CHARSET=latin1 COMMENT='For sorting a list'; -- -------------------------------------------------------- -- -- Table structure for table `list2` -- DROP TABLE IF EXISTS `list2`; CREATE TABLE `list2` ( `thing` varchar(255) NOT NULL, `id` int(11) NOT NULL DEFAULT '0', `class` varchar(20) NOT NULL DEFAULT '', `steam` bigint(17) NOT NULL DEFAULT '0' ) ENGINE=MEMORY DEFAULT CHARSET=latin1 COMMENT='For sorting a list'; -- -------------------------------------------------------- -- -- Table structure for table `LKPQueue` -- DROP TABLE IF EXISTS `LKPQueue`; CREATE TABLE `LKPQueue` ( `id` int(11) NOT NULL, `line` varchar(255) NOT NULL DEFAULT '' ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `locationCategories` -- DROP TABLE IF EXISTS `locationCategories`; CREATE TABLE `locationCategories` ( `categoryName` varchar(20) NOT NULL, `minAccessLevel` int(11) DEFAULT '99', `maxAccessLevel` int(11) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `locations` -- DROP TABLE IF EXISTS `locations`; CREATE TABLE `locations` ( `name` varchar(50) NOT NULL, `x` int(11) DEFAULT '0', `y` int(11) DEFAULT '0', `z` int(11) DEFAULT '0', `public` tinyint(1) DEFAULT '0', `active` tinyint(1) DEFAULT '1', `owner` bigint(17) DEFAULT '0', `village` tinyint(1) DEFAULT '0', `pvp` tinyint(1) DEFAULT '0', `protectSize` int(11) DEFAULT '50', `exitX` int(11) DEFAULT '0', `exitY` int(11) DEFAULT '0', `exitZ` int(11) DEFAULT '0', `cost` int(11) DEFAULT '0', `currency` varchar(20) DEFAULT NULL, `allowBase` tinyint(1) DEFAULT '0', `protected` tinyint(1) DEFAULT '0', `accessLevel` int(11) DEFAULT '99', `size` int(11) DEFAULT '20', `mayor` bigint(17) DEFAULT '0', `miniGame` varchar(10) DEFAULT NULL, `resetZone` tinyint(1) DEFAULT '0', `other` varchar(10) DEFAULT NULL, `killZombies` tinyint(1) DEFAULT '0', `timeOpen` int(11) DEFAULT '0', `timeClosed` int(11) DEFAULT '0', `allowWaypoints` tinyint(1) DEFAULT '1', `allowReturns` tinyint(1) DEFAULT '1', `allowLeave` tinyint(1) DEFAULT '1', `newPlayersOnly` tinyint(1) DEFAULT '0', `minimumLevel` int(11) DEFAULT '0', `maximumLevel` int(11) DEFAULT '0', `dayClosed` int(11) DEFAULT '0', `dailyTaxRate` int(11) DEFAULT '0', `bank` int(11) DEFAULT '0', `prisonX` int(11) DEFAULT '0', `prisonY` int(11) DEFAULT '0', `prisonZ` int(11) DEFAULT '0', `hidden` tinyint(1) DEFAULT '0', `locationCategory` varchar(20) DEFAULT '', `coolDownTimer` int(11) DEFAULT '0', `plot` tinyint(1) DEFAULT '0', `plotWallBock` varchar(20) DEFAULT 'terrBedrock', `plotFillBlock` varchar(20) DEFAULT 'terrDirt', `plotGridSize` int(11) DEFAULT '0', `plotDepth` int(11) DEFAULT '5', `hordeNightClosedHours` varchar(5) DEFAULT '00-00', `watchPlayers` tinyint(1) DEFAULT '0', `isRound` tinyint(1) DEFAULT '1', `lobby` tinyint(1) DEFAULT '0', `height` int(11) DEFAULT '-1', `allowPack` tinyint(1) DEFAULT '1', `allowP2P` tinyint(1) DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `locationSpawns` -- DROP TABLE IF EXISTS `locationSpawns`; CREATE TABLE `locationSpawns` ( `location` varchar(20) DEFAULT '', `x` int(11) DEFAULT '0', `y` int(11) DEFAULT '0', `z` int(11) DEFAULT '0', `id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `lottery` -- DROP TABLE IF EXISTS `lottery`; CREATE TABLE `lottery` ( `steam` bigint(17) NOT NULL DEFAULT '0', `ticket` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `mail` -- DROP TABLE IF EXISTS `mail`; CREATE TABLE `mail` ( `id` bigint(20) NOT NULL, `sender` bigint(17) DEFAULT '0', `recipient` bigint(17) DEFAULT '0', `message` varchar(500) DEFAULT '', `status` int(11) DEFAULT '0', `flag` varchar(5) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `memEntities` -- DROP TABLE IF EXISTS `memEntities`; CREATE TABLE `memEntities` ( `entityID` bigint(20) NOT NULL, `type` varchar(20) NOT NULL DEFAULT '', `name` varchar(30) NOT NULL DEFAULT '', `x` int(11) NOT NULL DEFAULT '0', `y` int(11) NOT NULL DEFAULT '0', `z` int(11) DEFAULT '0', `dead` tinyint(1) NOT NULL DEFAULT '0', `health` int(11) NOT NULL DEFAULT '0' ) ENGINE=MEMORY DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `memIgnoredItems` -- DROP TABLE IF EXISTS `memIgnoredItems`; CREATE TABLE `memIgnoredItems` ( `item` varchar(100) NOT NULL DEFAULT '', `qty` int(11) DEFAULT '65' ) ENGINE=MEMORY DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `memLottery` -- DROP TABLE IF EXISTS `memLottery`; CREATE TABLE `memLottery` ( `steam` bigint(17) NOT NULL DEFAULT '0', `ticket` int(11) NOT NULL DEFAULT '0' ) ENGINE=MEMORY DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `memRestrictedItems` -- DROP TABLE IF EXISTS `memRestrictedItems`; CREATE TABLE `memRestrictedItems` ( `item` varchar(50) NOT NULL DEFAULT '', `qty` int(11) DEFAULT '65', `accessLevel` int(11) DEFAULT '90', `action` varchar(30) DEFAULT '' ) ENGINE=MEMORY DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `memShop` -- DROP TABLE IF EXISTS `memShop`; CREATE TABLE `memShop` ( `item` varchar(50) NOT NULL, `category` varchar(20) DEFAULT '', `price` int(11) DEFAULT '50', `stock` int(11) DEFAULT '50', `idx` int(11) DEFAULT '0', `code` varchar(10) DEFAULT '', `units` int(11) DEFAULT '1', `quality` int(11) DEFAULT '0' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `memTracker` -- DROP TABLE IF EXISTS `memTracker`; CREATE TABLE `memTracker` ( `trackerID` bigint(20) NOT NULL, `admin` bigint(17) DEFAULT '0', `steam` bigint(17) DEFAULT '0', `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `x` int(11) DEFAULT '0', `y` int(11) DEFAULT '0', `z` int(11) DEFAULT '0', `session` int(11) DEFAULT '0', `flag` varchar(10) DEFAULT NULL ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `messageQueue` -- DROP TABLE IF EXISTS `messageQueue`; CREATE TABLE `messageQueue` ( `id` bigint(20) NOT NULL, `sender` bigint(17) DEFAULT '0', `recipient` bigint(17) DEFAULT '0', `message` varchar(1000) DEFAULT '' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `miscQueue` -- DROP TABLE IF EXISTS `miscQueue`; CREATE TABLE `miscQueue` ( `id` bigint(20) NOT NULL, `steam` bigint(17) DEFAULT '0', `command` varchar(255) DEFAULT '', `action` varchar(15) DEFAULT '', `value` int(11) DEFAULT '0', `timerDelay` timestamp NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `modBotman` -- DROP TABLE IF EXISTS `modBotman`; CREATE TABLE `modBotman` ( `clanEnabled` tinyint(1) DEFAULT '0', `clanMaxClans` int(11) DEFAULT '0', `clanMaxPlayers` int(11) DEFAULT '0', `clanMinLevel` int(11) DEFAULT '0', `resetsEnabled` tinyint(1) DEFAULT '0', `resetsDelay` int(11) DEFAULT '999', `resetsPrefabsOnly` tinyint(1) DEFAULT '1', `resetsRemoveLCB` tinyint(4) DEFAULT '1', `webmapEnabled` tinyint(1) DEFAULT '0', `webmapColour` varchar(6) DEFAULT 'FF0000', `webmapPath` varchar(255) DEFAULT '', `anticheat` tinyint(1) DEFAULT '0', `disableChatColours` tinyint(1) DEFAULT '0', `botName` varchar(30) DEFAULT 'Bot', `botNameColourPublic` varchar(6) DEFAULT 'FFFFFF', `botNameColourPrivate` varchar(6) DEFAULT 'FFFFFF', `chatCommandPrefix` varchar(1) DEFAULT '/', `chatCommandsHidden` tinyint(1) DEFAULT '1', `customMessagesEnabled` tinyint(1) DEFAULT '0', `dropminerEnabled` tinyint(1) DEFAULT '0', `dropminerTriggerEntityCount` int(11) DEFAULT '0', `dropminerTriggerFallingCount` int(11) DEFAULT '0', `blockTreeRemoval` tinyint(1) DEFAULT '0', `zombieAnnouncerEnabled` tinyint(1) DEFAULT '0', `zombieFreeTimeEnabled` tinyint(1) DEFAULT '0', `zombieFreeTimeStart` int(11) DEFAULT '0', `zombieFreeTimeEnd` int(11) DEFAULT '0', `killZonesEnabled` tinyint(1) DEFAULT '0', `version` varchar(20) DEFAULT '', `id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `otherEntities` -- DROP TABLE IF EXISTS `otherEntities`; CREATE TABLE `otherEntities` ( `entity` varchar(50) NOT NULL DEFAULT '', `entityID` int(11) DEFAULT '0', `doNotSpawn` tinyint(1) DEFAULT '0', `doNotDespawn` tinyint(1) DEFAULT '0', `remove` tinyint(1) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `otherEntities` -- INSERT INTO `otherEntities` (`entity`, `entityID`, `doNotSpawn`, `doNotDespawn`, `remove`) VALUES ('animalBear', 64, 0, 0, 0), ('animalBoar', 70, 0, 0, 0), ('animalChicken', 61, 0, 0, 0), ('animalDireWolf', 67, 0, 0, 0), ('animalRabbit', 60, 0, 0, 0), ('animalSnake', 69, 0, 0, 0), ('animalStag', 59, 0, 0, 0), ('animalTemplateHostile', 62, 0, 0, 0), ('animalTemplateTimid', 58, 0, 0, 0), ('animalWolf', 66, 0, 0, 0), ('Backpack', 74, 0, 0, 0), ('DroppedLootContainer', 75, 0, 0, 0), ('EvisceratedRemains', 76, 0, 0, 0), ('invisibleAnimal', 77, 0, 0, 0), ('invisibleAnimalEnemy', 78, 0, 0, 0), ('minibike', 72, 0, 0, 0), ('npcBanditLeader', 83, 0, 0, 0), ('npcBanditMelee', 81, 0, 0, 0), ('npcBanditRanged', 82, 0, 0, 0), ('npcSurvivorRanged', 80, 0, 0, 0), ('npcSurvivorTemplate', 79, 0, 0, 0), ('npcTraderBob', 87, 0, 0, 0), ('npcTraderHugh', 89, 0, 0, 0), ('npcTraderJimmy', 88, 0, 0, 0), ('npcTraderJoel', 85, 0, 0, 0), ('npcTraderRekt', 86, 0, 0, 0), ('npcTraderTemplate', 84, 0, 0, 0), ('sc_General', 73, 0, 0, 0), ('supplyPlane', 71, 0, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `performance` -- DROP TABLE IF EXISTS `performance`; CREATE TABLE `performance` ( `serverDate` varchar(19) NOT NULL DEFAULT '', `gameTime` float DEFAULT '0', `fps` float DEFAULT '0', `heap` float DEFAULT '0', `heapMax` float DEFAULT '0', `chunks` int(11) DEFAULT '0', `cgo` int(11) DEFAULT '0', `players` int(11) DEFAULT '0', `zombies` int(11) DEFAULT '0', `entities` varchar(12) DEFAULT '', `items` int(11) DEFAULT '0', `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `persistentQueue` -- DROP TABLE IF EXISTS `persistentQueue`; CREATE TABLE `persistentQueue` ( `id` bigint(20) NOT NULL, `steam` bigint(17) DEFAULT '0', `command` varchar(255) DEFAULT '', `action` varchar(15) DEFAULT '', `value` int(11) DEFAULT '0', `timerDelay` timestamp NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `playerNotes` -- DROP TABLE IF EXISTS `playerNotes`; CREATE TABLE `playerNotes` ( `id` int(11) NOT NULL, `steam` bigint(17) DEFAULT '0', `createdBy` bigint(17) DEFAULT '0', `note` varchar(400) DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `playerQueue` -- DROP TABLE IF EXISTS `playerQueue`; CREATE TABLE `playerQueue` ( `id` int(11) NOT NULL, `command` varchar(255) DEFAULT '', `arena` tinyint(1) DEFAULT '0', `boss` tinyint(1) DEFAULT '0', `steam` bigint(17) DEFAULT '0', `delayTimer` timestamp NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `players` -- DROP TABLE IF EXISTS `players`; CREATE TABLE `players` ( `steam` bigint(17) NOT NULL DEFAULT '0', `name` varchar(100) DEFAULT '', `id` int(11) DEFAULT '0', `xPos` int(11) DEFAULT '0', `yPos` int(11) DEFAULT '0', `zPos` int(11) DEFAULT '0', `xPosOld` int(11) DEFAULT '0', `yPosOld` int(11) DEFAULT '0', `zPosOld` int(11) DEFAULT '0', `homeX` int(11) DEFAULT '0', `homeY` int(11) DEFAULT '0', `homeZ` int(11) DEFAULT '0', `home2X` int(11) DEFAULT '0', `home2Y` int(11) DEFAULT '0', `home2Z` int(11) DEFAULT '0', `exitX` int(11) DEFAULT '0', `exitY` int(11) DEFAULT '0', `exitZ` int(11) DEFAULT '0', `exit2X` int(11) DEFAULT '0', `exit2Y` int(11) DEFAULT '0', `exit2Z` int(11) DEFAULT '0', `level` int(11) DEFAULT '1', `cash` float DEFAULT '0', `pvpBounty` int(11) DEFAULT '0', `zombies` int(11) DEFAULT '0', `score` int(11) DEFAULT '0', `playerKills` int(11) DEFAULT '0', `deaths` int(11) DEFAULT '0', `protectSize` int(11) DEFAULT '32', `protect2Size` int(11) DEFAULT '32', `sessionCount` int(11) DEFAULT '1', `timeOnServer` int(11) DEFAULT '0', `firstSeen` int(11) DEFAULT '0', `keystones` int(11) DEFAULT '0', `overStackTimeout` tinyint(1) DEFAULT '0', `overstack` tinyint(1) DEFAULT '0', `shareWaypoint` tinyint(1) DEFAULT '0', `watchCash` tinyint(1) DEFAULT '0', `watchPlayer` tinyint(1) DEFAULT '1', `timeout` tinyint(1) DEFAULT '0', `denyRights` tinyint(1) DEFAULT '0', `botTimeout` tinyint(1) DEFAULT '0', `newPlayer` tinyint(1) DEFAULT '1', `ip` varchar(15) CHARACTER SET utf8 DEFAULT NULL, `seen` varchar(19) CHARACTER SET utf8 DEFAULT NULL, `baseCooldown` int(11) DEFAULT '0', `ircAlias` varchar(15) CHARACTER SET utf8 DEFAULT NULL, `bed` varchar(5) CHARACTER SET utf8 DEFAULT NULL, `donor` tinyint(1) DEFAULT '0', `playtime` int(11) DEFAULT '0', `protect` tinyint(1) DEFAULT '0', `protect2` tinyint(1) DEFAULT '0', `tokens` int(11) DEFAULT '0', `exiled` tinyint(1) DEFAULT '0', `pvpCount` int(11) DEFAULT '0', `translate` tinyint(1) DEFAULT '0', `prisoner` tinyint(1) DEFAULT '0', `permanentBan` tinyint(1) DEFAULT '0', `whitelisted` tinyint(1) DEFAULT '0', `silentBob` tinyint(1) DEFAULT '0', `walkies` tinyint(1) DEFAULT '0', `prisonReason` varchar(150) CHARACTER SET utf8 DEFAULT NULL, `prisonxPosOld` int(11) DEFAULT '0', `prisonyPosOld` int(11) DEFAULT '0', `prisonzPosOld` int(11) DEFAULT '0', `pvpVictim` bigint(17) DEFAULT '0', `aliases` varchar(255) DEFAULT NULL, `location` varchar(50) CHARACTER SET utf8 DEFAULT '', `canTeleport` tinyint(1) DEFAULT '1', `allowBadInventory` tinyint(1) DEFAULT '0', `ircTranslate` tinyint(1) DEFAULT '0', `ircPass` varchar(15) DEFAULT '', `noSpam` tinyint(1) DEFAULT '0', `waypointX` int(11) DEFAULT '0', `waypointY` int(11) DEFAULT '0', `waypointZ` int(11) DEFAULT '0', `xPosTimeout` int(11) DEFAULT '0', `yPosTimeout` int(11) DEFAULT '0', `zPosTimeout` int(11) DEFAULT '0', `accessLevel` int(11) DEFAULT '99', `country` varchar(2) CHARACTER SET utf8 DEFAULT NULL, `ping` int(11) DEFAULT '0', `donorLevel` int(11) DEFAULT '1', `donorExpiry` int(11) DEFAULT '0', `autoFriend` varchar(2) DEFAULT 'AF' COMMENT 'NA/AF/AD', `ircOtherNames` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `steamOwner` bigint(17) DEFAULT '0', `bedX` int(11) DEFAULT '0', `bedY` int(11) DEFAULT '0', `bedZ` int(11) DEFAULT '0', `mute` tinyint(4) DEFAULT '0', `xPosOld2` int(11) DEFAULT '0', `yPosOld2` int(11) DEFAULT '0', `zPosOld2` int(11) DEFAULT '0', `ISP` varchar(25) CHARACTER SET utf8 DEFAULT NULL, `ignorePlayer` tinyint(1) DEFAULT '0', `ircMute` tinyint(1) DEFAULT '0', `waypoint2X` int(11) DEFAULT '0', `waypoint2Y` int(11) DEFAULT '0', `waypoint2Z` int(11) DEFAULT '0', `waypointsLinked` tinyint(1) DEFAULT '0', `chatColour` varchar(6) DEFAULT 'FFFFFF', `teleCooldown` int(11) DEFAULT '0', `reserveSlot` tinyint(4) DEFAULT '0', `prisonReleaseTime` int(11) DEFAULT '0', `maxWaypoints` int(11) DEFAULT '2', `ircLogin` varchar(20) DEFAULT '', `waypointCooldown` int(11) DEFAULT '0', `bail` int(11) DEFAULT '0', `watchPlayerTimer` int(11) DEFAULT '0', `hackerScore` int(11) DEFAULT '0', `pvpTeleportCooldown` int(11) DEFAULT '0', `block` tinyint(1) DEFAULT '0', `removedClaims` int(11) DEFAULT '0', `returnCooldown` int(11) DEFAULT '0', `commandCooldown` int(11) DEFAULT '0', `gimmeCooldown` int(11) DEFAULT '0', `VACBanned` tinyint(1) DEFAULT '0', `bountyReason` varchar(100) DEFAULT '', `claimsExpired` tinyint(1) DEFAULT '0', `showLocationMessages` tinyint(1) DEFAULT '1', `DNSLookupCount` int(11) DEFAULT '0', `lastDNSLookup` date DEFAULT '1000-01-01', `ircAuthenticated` tinyint(1) DEFAULT '0', `p2pCooldown` int(11) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `playersArchived` -- DROP TABLE IF EXISTS `playersArchived`; CREATE TABLE `playersArchived` ( `steam` bigint(17) NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL DEFAULT '', `id` int(11) DEFAULT '0', `xPos` int(11) DEFAULT '0', `yPos` int(11) DEFAULT '0', `zPos` int(11) DEFAULT '0', `xPosOld` int(11) DEFAULT '0', `yPosOld` int(11) DEFAULT '0', `zPosOld` int(11) DEFAULT '0', `homeX` int(11) DEFAULT '0', `homeY` int(11) DEFAULT '0', `homeZ` int(11) DEFAULT '0', `home2X` int(11) DEFAULT '0', `home2Y` int(11) DEFAULT '0', `home2Z` int(11) DEFAULT '0', `exitX` int(11) DEFAULT '0', `exitY` int(11) DEFAULT '0', `exitZ` int(11) DEFAULT '0', `exit2X` int(11) DEFAULT '0', `exit2Y` int(11) DEFAULT '0', `exit2Z` int(11) DEFAULT '0', `level` int(11) DEFAULT '1', `cash` float DEFAULT '0', `pvpBounty` int(11) DEFAULT '0', `zombies` int(11) DEFAULT '0', `score` int(11) DEFAULT '0', `playerKills` int(11) DEFAULT '0', `deaths` int(11) DEFAULT '0', `protectSize` int(11) DEFAULT '32', `protect2Size` int(11) DEFAULT '32', `sessionCount` int(11) DEFAULT '1', `timeOnServer` int(11) DEFAULT '0', `firstSeen` int(11) DEFAULT '0', `keystones` int(11) DEFAULT '0', `overStackTimeout` tinyint(1) DEFAULT '0', `overstack` tinyint(1) DEFAULT '0', `shareWaypoint` tinyint(1) DEFAULT '0', `watchCash` tinyint(1) DEFAULT '0', `watchPlayer` tinyint(1) DEFAULT '1', `timeout` tinyint(1) DEFAULT '0', `denyRights` tinyint(1) DEFAULT '0', `botTimeout` tinyint(1) DEFAULT '0', `newPlayer` tinyint(1) DEFAULT '1', `ip` varchar(15) CHARACTER SET utf8 DEFAULT NULL, `seen` varchar(19) CHARACTER SET utf8 DEFAULT NULL, `baseCooldown` int(11) DEFAULT '0', `ircAlias` varchar(15) CHARACTER SET utf8 DEFAULT NULL, `bed` varchar(5) CHARACTER SET utf8 DEFAULT NULL, `donor` tinyint(1) DEFAULT '0', `playtime` int(11) DEFAULT '0', `protect` tinyint(1) DEFAULT '0', `protect2` tinyint(1) DEFAULT '0', `tokens` int(11) DEFAULT '0', `exiled` tinyint(1) DEFAULT '0', `pvpCount` int(11) DEFAULT '0', `translate` tinyint(1) DEFAULT '0', `prisoner` tinyint(1) DEFAULT '0', `permanentBan` tinyint(1) DEFAULT '0', `whitelisted` tinyint(1) DEFAULT '0', `silentBob` tinyint(1) DEFAULT '0', `walkies` tinyint(1) DEFAULT '0', `prisonReason` varchar(150) CHARACTER SET utf8 DEFAULT NULL, `prisonxPosOld` int(11) DEFAULT '0', `prisonyPosOld` int(11) DEFAULT '0', `prisonzPosOld` int(11) DEFAULT '0', `pvpVictim` bigint(17) DEFAULT '0', `aliases` varchar(255) DEFAULT NULL, `location` varchar(50) CHARACTER SET utf8 DEFAULT '', `canTeleport` tinyint(1) DEFAULT '1', `allowBadInventory` tinyint(1) DEFAULT '0', `ircTranslate` tinyint(1) DEFAULT '0', `ircPass` varchar(15) DEFAULT '', `noSpam` tinyint(1) DEFAULT '0', `waypointX` int(11) DEFAULT '0', `waypointY` int(11) DEFAULT '0', `waypointZ` int(11) DEFAULT '0', `xPosTimeout` int(11) DEFAULT '0', `yPosTimeout` int(11) DEFAULT '0', `zPosTimeout` int(11) DEFAULT '0', `accessLevel` int(11) DEFAULT '99', `country` varchar(2) CHARACTER SET utf8 DEFAULT NULL, `ping` int(11) DEFAULT '0', `donorLevel` int(11) DEFAULT '1', `donorExpiry` int(11) DEFAULT '0', `autoFriend` varchar(2) DEFAULT 'AF' COMMENT 'NA/AF/AD', `ircOtherNames` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `steamOwner` bigint(17) DEFAULT '0', `bedX` int(11) DEFAULT '0', `bedY` int(11) DEFAULT '0', `bedZ` int(11) DEFAULT '0', `mute` tinyint(4) DEFAULT '0', `xPosOld2` int(11) DEFAULT '0', `yPosOld2` int(11) DEFAULT '0', `zPosOld2` int(11) DEFAULT '0', `ISP` varchar(25) CHARACTER SET utf8 DEFAULT NULL, `ignorePlayer` tinyint(1) DEFAULT '0', `ircMute` tinyint(1) DEFAULT '0', `waypoint2X` int(11) DEFAULT '0', `waypoint2Y` int(11) DEFAULT '0', `waypoint2Z` int(11) DEFAULT '0', `waypointsLinked` tinyint(1) DEFAULT '0', `chatColour` varchar(6) DEFAULT 'FFFFFF', `teleCooldown` int(11) DEFAULT '0', `reserveSlot` tinyint(4) DEFAULT '0', `prisonReleaseTime` int(11) DEFAULT '0', `maxWaypoints` int(11) DEFAULT '2', `ircLogin` varchar(20) DEFAULT '', `waypointCooldown` int(11) DEFAULT '0', `bail` int(11) DEFAULT '0', `watchPlayerTimer` int(11) DEFAULT '0', `hackerScore` int(11) DEFAULT '0', `pvpTeleportCooldown` int(11) DEFAULT '0', `block` tinyint(1) DEFAULT '0', `removedClaims` int(11) DEFAULT '0', `returnCooldown` int(11) DEFAULT '0', `commandCooldown` int(11) DEFAULT '0', `gimmeCooldown` int(11) DEFAULT '0', `VACBanned` tinyint(1) DEFAULT '0', `bountyReason` varchar(100) DEFAULT '', `claimsExpired` tinyint(1) DEFAULT '0', `showLocationMessages` tinyint(1) DEFAULT '1', `DNSLookupCount` int(11) DEFAULT '0', `lastDNSLookup` date DEFAULT '1000-01-01', `ircAuthenticated` tinyint(1) DEFAULT '0', `p2pCooldown` int(11) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `polls` -- DROP TABLE IF EXISTS `polls`; CREATE TABLE `polls` ( `id` int(11) NOT NULL, `author` bigint(17) DEFAULT '0', `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `expires` timestamp NULL DEFAULT '0000-00-00 00:00:00', `topic` varchar(255) DEFAULT '', `responseYN` tinyint(1) DEFAULT '1', `option1` varchar(255) DEFAULT '', `option2` varchar(255) DEFAULT '', `option3` varchar(255) DEFAULT '', `option4` varchar(255) DEFAULT '', `option5` varchar(255) DEFAULT '', `option6` varchar(255) DEFAULT '', `accessLevel` int(11) DEFAULT '90' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `pollVotes` -- DROP TABLE IF EXISTS `pollVotes`; CREATE TABLE `pollVotes` ( `pollID` int(11) NOT NULL, `steam` bigint(17) NOT NULL DEFAULT '0', `vote` int(11) DEFAULT '0', `weight` float DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `prefabCopies` -- DROP TABLE IF EXISTS `prefabCopies`; CREATE TABLE `prefabCopies` ( `owner` bigint(17) NOT NULL DEFAULT '0', `name` varchar(50) NOT NULL DEFAULT '', `x1` int(11) NOT NULL DEFAULT '0', `x2` int(11) NOT NULL DEFAULT '0', `y1` int(11) NOT NULL DEFAULT '0', `y2` int(11) NOT NULL DEFAULT '0', `z1` int(11) NOT NULL DEFAULT '0', `z2` int(11) NOT NULL DEFAULT '0', `blockName` varchar(50) NOT NULL DEFAULT '', `rotation` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `proxies` -- DROP TABLE IF EXISTS `proxies`; CREATE TABLE `proxies` ( `scanString` varchar(100) NOT NULL DEFAULT '', `action` varchar(20) DEFAULT 'nothing', `hits` int(11) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `proxies` -- INSERT INTO `proxies` (`scanString`, `action`, `hits`) VALUES ('ALIBABA.COM', 'ban', 0), ('AMAZON TECHNOLOGIES', 'ban', 0), ('AOYOUHOST', 'ban', 0), ('AZURE TECHNOLOGY', 'ban', 0), ('BANK OF AMERICA', 'ban', 0), ('CHOOPA', 'ban', 0), ('DCSMANAGE.COM', 'ban', 0), ('EDIS.AT', 'ban', 0), ('EGIHOSTING', 'ban', 0), ('ETHR-NET', 'ban', 0), ('FEDERAL ONLINE GROUP', 'ban', 0), ('GAMESERVER', 'ban', 0), ('GLOBAL-FRAG-SERVERS', 'ban', 0), ('GORILLASERVERS', 'ban', 0), ('HUGESERVER', 'ban', 0), ('KRYPT TECHNOLOGIES', 'ban', 0), ('LONGLING', 'ban', 0), ('LONLIFE.CN', 'ban', 0), ('MULTACOM', 'ban', 0), ('PCCWGLOBAL.COM', 'ban', 0), ('PSYCHZ-NETWORKS', 'ban', 0), ('QUADRANET', 'ban', 0), ('SAKURA', 'ban', 0), ('TATA COMMUNICATIONS', 'ban', 0), ('TOTAL-SERVER-SOLUTIONS', 'ban', 0), ('VELIA.NET', 'ban', 0), ('WEB2OBJECTS', 'ban', 0), ('WEBNX.COM', 'ban', 0), ('WIRELESS-ALARM.COM', 'ban', 0), ('YPSOLUTIONS', 'ban', 0), ('ZENLAYER', 'ban', 0); -- -------------------------------------------------------- -- -- Table structure for table `reservedSlots` -- DROP TABLE IF EXISTS `reservedSlots`; CREATE TABLE `reservedSlots` ( `steam` bigint(17) NOT NULL DEFAULT '0', `timeAdded` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `reserved` tinyint(1) DEFAULT '0', `staff` tinyint(1) DEFAULT '0', `totalPlayTime` int(11) DEFAULT '0', `deleteRow` tinyint(1) DEFAULT '0' ) ENGINE=MEMORY DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `resetZones` -- DROP TABLE IF EXISTS `resetZones`; CREATE TABLE `resetZones` ( `region` varchar(20) NOT NULL DEFAULT '', `x` int(11) DEFAULT '0', `z` int(11) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `restrictedItems` -- DROP TABLE IF EXISTS `restrictedItems`; CREATE TABLE `restrictedItems` ( `item` varchar(50) NOT NULL, `qty` int(11) DEFAULT '65', `accessLevel` int(11) DEFAULT '90', `action` varchar(30) DEFAULT '', `validated` tinyint(1) DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `restrictedItems` -- INSERT INTO `restrictedItems` (`item`, `qty`, `accessLevel`, `action`, `validated`) VALUES ('44MagBullet', 480, 90, 'timeout', 0), ('762mmBullet', 480, 90, 'timeout', 0), ('9mmBullet', 480, 90, 'timeout', 0), ('dynamite', 5, 90, 'exile', 0), ('rocket', 99, 90, 'exile', 0); -- -------------------------------------------------------- -- -- Table structure for table `searchResults` -- DROP TABLE IF EXISTS `searchResults`; CREATE TABLE `searchResults` ( `id` bigint(20) NOT NULL, `owner` bigint(17) DEFAULT '0', `steam` bigint(17) DEFAULT '0', `x` int(11) DEFAULT '0', `y` int(11) DEFAULT '0', `z` int(11) DEFAULT '0', `session` int(11) DEFAULT '0', `date` varchar(20) DEFAULT '', `counter` int(11) DEFAULT '0' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `server` -- DROP TABLE IF EXISTS `server`; CREATE TABLE `server` ( `rules` varchar(1000) CHARACTER SET utf8mb4 DEFAULT 'A zombie ate the server rules! Tell an admin.', `shopCountdown` int(11) DEFAULT '0', `gimmePeace` tinyint(1) DEFAULT '0', `date` varchar(10) CHARACTER SET utf8mb4 DEFAULT '', `windowDebug` varchar(15) DEFAULT 'Debug', `ServerPort` int(11) DEFAULT '0', `windowAlerts` varchar(15) DEFAULT 'Alerts', `allowGimme` tinyint(1) DEFAULT '0', `mapSize` int(11) DEFAULT '10000', `ircAlerts` varchar(50) DEFAULT '#new_alerts', `ircWatch` varchar(50) DEFAULT '#new_watch', `prisonSize` int(11) DEFAULT '30', `MOTD` varchar(255) CHARACTER SET utf8mb4 DEFAULT '', `IP` varchar(100) DEFAULT '0.0.0.0', `lottery` float DEFAULT '0', `allowShop` tinyint(1) DEFAULT '0', `windowGMSG` varchar(15) DEFAULT 'GMSG', `botName` varchar(30) CHARACTER SET utf8mb4 DEFAULT 'Bot', `allowWaypoints` tinyint(1) DEFAULT '0', `windowLists` varchar(15) DEFAULT 'Lists', `ircMain` varchar(50) DEFAULT '#new', `chatColour` varchar(6) DEFAULT 'D4FFD4', `maxPlayers` int(11) DEFAULT '24', `dailyRebootHour` int(11) DEFAULT '0', `maxServerUptime` int(11) DEFAULT '12', `windowPlayers` varchar(15) DEFAULT 'Players', `baseSize` int(11) DEFAULT '32', `baseCooldown` int(11) DEFAULT '2400', `protectionMaxDays` int(11) DEFAULT '40', `ircBotName` varchar(30) DEFAULT 'Bot', `serverName` varchar(100) CHARACTER SET utf8mb4 DEFAULT 'New Server', `lastDailyReboot` int(11) DEFAULT '0', `allowNumericNames` tinyint(1) DEFAULT '1', `allowGarbageNames` tinyint(1) DEFAULT '1', `id` int(11) NOT NULL, `allowReboot` tinyint(1) DEFAULT '1', `newPlayerTimer` int(11) DEFAULT '120', `blacklistResponse` varchar(20) DEFAULT 'ban', `gameDay` int(11) DEFAULT '0', `welcome` varchar(255) CHARACTER SET utf8mb4 DEFAULT '', `allowVoting` tinyint(1) DEFAULT '0', `allowPlayerVoteTopics` tinyint(1) DEFAULT '0', `shopOpenHour` int(11) DEFAULT '0', `shopCloseHour` int(11) DEFAULT '0', `shopLocation` varchar(30) CHARACTER SET utf8mb4 DEFAULT '', `website` varchar(100) CHARACTER SET utf8mb4 DEFAULT '', `ircServer` varchar(100) CHARACTER SET utf8mb4 DEFAULT '127.0.0.1', `pingKick` int(11) DEFAULT '-1', `longPlayUpgradeTime` int(11) DEFAULT '0', `gameType` varchar(3) DEFAULT 'pve', `hideCommands` tinyint(1) DEFAULT '1', `botTick` int(11) DEFAULT '0', `serverGroup` varchar(20) CHARACTER SET utf8mb4 DEFAULT '', `botID` int(11) DEFAULT '0', `allowOverstacking` tinyint(1) DEFAULT '0', `announceTeleports` tinyint(1) DEFAULT '0', `blacklistCountries` varchar(100) DEFAULT 'CN', `northeastZone` varchar(5) DEFAULT NULL, `northwestZone` varchar(5) DEFAULT NULL, `southeastZone` varchar(5) DEFAULT NULL, `southwestZone` varchar(5) DEFAULT NULL, `allowPhysics` tinyint(1) DEFAULT '1', `playersCanFly` tinyint(1) DEFAULT '1', `accessLevelOverride` int(11) DEFAULT '99', `disableBaseProtection` tinyint(1) DEFAULT '0', `packCooldown` int(11) DEFAULT '0', `moneyName` varchar(60) DEFAULT 'Zenny|Zennies', `allowBank` tinyint(1) DEFAULT '1', `overstackThreshold` int(11) DEFAULT '1000', `enableRegionPM` tinyint(1) DEFAULT '1', `allowRapidRelogging` tinyint(1) DEFAULT '1', `allowLottery` tinyint(1) DEFAULT '1', `lotteryMultiplier` float DEFAULT '2', `zombieKillReward` float DEFAULT '3', `ircTracker` varchar(50) DEFAULT '#new_tracker', `allowTeleporting` tinyint(1) DEFAULT '1', `hardcore` tinyint(1) DEFAULT '0', `swearJar` tinyint(1) DEFAULT '0', `swearCash` int(11) DEFAULT '0', `idleKick` tinyint(1) DEFAULT '0', `swearFine` int(11) DEFAULT '5', `ircPrivate` tinyint(1) DEFAULT '0', `waypointsPublic` tinyint(1) DEFAULT '0', `waypointCost` int(11) DEFAULT '0', `waypointCooldown` int(11) DEFAULT '0', `alertColour` varchar(6) DEFAULT 'DC143C', `warnColour` varchar(6) DEFAULT 'FFA500', `teleportCost` int(11) DEFAULT '200', `commandPrefix` varchar(1) DEFAULT '/', `chatlogPath` varchar(200) DEFAULT '', `botVersion` varchar(20) DEFAULT '', `packCost` int(11) DEFAULT '0', `baseCost` int(11) DEFAULT '0', `rebootHour` int(11) DEFAULT '-1', `rebootMinute` int(11) DEFAULT '0', `maxPrisonTime` int(11) DEFAULT '-1', `bailCost` int(11) DEFAULT '0', `maxWaypoints` int(11) DEFAULT '2', `teleportPublicCost` int(11) DEFAULT '0', `teleportPublicCooldown` int(11) DEFAULT '0', `reservedSlots` int(11) DEFAULT '0', `allowReturns` tinyint(1) DEFAULT '1', `scanNoclip` tinyint(1) DEFAULT '1', `scanEntities` tinyint(1) DEFAULT '0', `CBSMFriendly` tinyint(1) DEFAULT '1', `ServerToolsDetected` tinyint(1) DEFAULT '0', `disableTPinPVP` tinyint(1) DEFAULT '0', `updateBot` tinyint(1) DEFAULT '1', `waypointCreateCost` int(11) DEFAULT '0', `scanErrors` tinyint(1) DEFAULT '0', `alertSpending` tinyint(1) DEFAULT '0', `GBLBanThreshold` int(11) DEFAULT '0', `lastBotsMessageID` int(11) DEFAULT '0', `lastBotsMessageTimestamp` int(11) DEFAULT '0', `gimmeZombies` tinyint(1) DEFAULT '1', `allowProxies` tinyint(1) DEFAULT '0', `SDXDetected` tinyint(1) DEFAULT '0', `enableWindowMessages` tinyint(1) DEFAULT '0', `updateBranch` varchar(30) DEFAULT 'a18', `chatColourNewPlayer` varchar(6) DEFAULT 'FFFFFF', `chatColourPlayer` varchar(6) DEFAULT 'FFFFFF', `chatColourDonor` varchar(6) DEFAULT 'FFFFFF', `chatColourPrisoner` varchar(6) DEFAULT 'FFFFFF', `chatColourMod` varchar(6) DEFAULT 'FFFFFF', `chatColourAdmin` varchar(6) DEFAULT 'FFFFFF', `chatColourOwner` varchar(6) DEFAULT 'FFFFFF', `commandCooldown` int(11) DEFAULT '0', `telnetPass` varchar(50) DEFAULT '', `telnetPort` int(11) DEFAULT '0', `feralRebootDelay` int(11) DEFAULT '68', `pvpTeleportCooldown` int(11) DEFAULT '0', `allowPlayerToPlayerTeleporting` tinyint(1) DEFAULT '1', `ircPort` int(11) DEFAULT '6667', `botRestartHour` int(11) DEFAULT '25', `trackingKeepDays` int(11) DEFAULT '28', `databaseMaintenanceFinished` tinyint(1) DEFAULT '1', `allowHomeTeleport` tinyint(1) DEFAULT '1', `playerTeleportDelay` int(11) DEFAULT '0', `allowPackTeleport` tinyint(1) DEFAULT '1', `gameVersion` varchar(30) DEFAULT '', `pvpIgnoreFriendlyKills` tinyint(1) DEFAULT '0', `allowStuckTeleport` tinyint(1) DEFAULT '1', `restrictIRC` tinyint(1) DEFAULT '0', `nextAnnouncement` int(11) DEFAULT '1', `pvpAllowProtect` tinyint(1) DEFAULT '0', `hackerTPDetection` tinyint(1) DEFAULT '1', `whitelistCountries` varchar(50) DEFAULT '', `perMinutePayRate` float DEFAULT '0', `disableWatchAlerts` tinyint(1) DEFAULT '0', `masterPassword` varchar(50) DEFAULT '', `allowBotRestarts` tinyint(1) DEFAULT '0', `botOwner` varchar(17) DEFAULT '0', `returnCooldown` int(11) DEFAULT '0', `botRestartDay` int(11) DEFAULT '7', `enableTimedClaimScan` tinyint(1) DEFAULT '1', `enableScreamerAlert` tinyint(1) DEFAULT '1', `enableAirdropAlert` tinyint(1) DEFAULT '1', `spleefGameCoords` varchar(20) DEFAULT '4000 225 4000', `gimmeResetTime` int(11) DEFAULT '120', `gimmeRaincheck` int(11) DEFAULT '0', `pingKickTarget` varchar(3) DEFAULT 'new', `enableBounty` tinyint(1) DEFAULT '1', `mapSizeNewPlayers` int(11) DEFAULT '10000', `mapSizePlayers` int(11) DEFAULT '10000', `shopResetDays` int(11) DEFAULT '3', `telnetLogKeepDays` int(11) DEFAULT '14', `maxWaypointsDonors` int(11) DEFAULT '2', `baseProtectionExpiryDays` int(11) DEFAULT '40', `banVACBannedPlayers` tinyint(1) DEFAULT '0', `deathCost` int(11) DEFAULT '0', `showLocationMessages` tinyint(1) DEFAULT '1', `bountyRewardItem` varchar(25) DEFAULT 'cash', `enableLagCheck` tinyint(1) DEFAULT '1', `allowSecondBaseWithoutDonor` tinyint(1) DEFAULT '0', `nonAlphabeticChatReaction` varchar(10) DEFAULT 'nothing', `lotteryTicketPrice` int(11) DEFAULT '25', `newPlayerMaxLevel` int(11) DEFAULT '9', `hordeNight` int(11) DEFAULT '7', `hideUnknownCommand` tinyint(1) DEFAULT '0', `beQuietBot` tinyint(1) DEFAULT '0', `gimmeResetTimer` int(11) DEFAULT '120', `shopResetGameOrRealDays` tinyint(1) DEFAULT '0', `zombieKillRewardDonors` float DEFAULT '3', `allowFamilySteamKeys` tinyint(1) DEFAULT '1', `checkLevelHack` tinyint(1) DEFAULT '0', `despawnZombiesBeforeBloodMoon` tinyint(1) DEFAULT '0', `optOutGlobalBots` tinyint(1) DEFAULT '0', `dropMiningWarningThreshold` int(11) DEFAULT '99', `webPanelPort` int(11) DEFAULT '0', `allocsWebAPIUser` varchar(100) DEFAULT '', `allocsWebAPIPassword` varchar(100) DEFAULT '', `useAllocsWebAPI` tinyint(1) DEFAULT '0', `defaultWatchTimer` int(11) DEFAULT '259200', `archivePlayersLastSeenDays` int(11) DEFAULT '60', `playersLastArchived` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `alertLevelHack` tinyint(1) DEFAULT '1', `logBotCommands` tinyint(1) DEFAULT '0', `logInventory` tinyint(1) DEFAULT '1', `removeExpiredClaims` tinyint(1) DEFAULT '0', `baseDeadzone` int(11) DEFAULT '0', `reservedSlotTimelimit` int(11) DEFAULT '0', `logPollingInterval` int(11) DEFAULT '3', `commandLagThreshold` int(11) DEFAULT '15', `telnetDisabled` tinyint(1) DEFAULT '0', `sayUsesIRCNick` tinyint(1) DEFAULT '0', `readLogUsingTelnet` tinyint(1) DEFAULT '0', `ircMainPassword` varchar(30) DEFAULT '', `ircAlertsPassword` varchar(30) DEFAULT '', `ircWatchPassword` varchar(30) DEFAULT '', `chatColourPrivate` varchar(6) DEFAULT 'FFFFFF', `botNameColour` varchar(6) DEFAULT 'FFFFFF', `disableFetch` tinyint(1) DEFAULT '0', `p2pCooldown` int(11) DEFAULT '0', `telnetFallback` tinyint(1) DEFAULT '0' COMMENT 'Use telnet when API not working', `botsIP` varchar(100) DEFAULT '0.0.0.0', `idleKickTimer` int(11) DEFAULT '900', `idleKickAnytime` tinyint(1) NOT NULL DEFAULT '0', `disableLinkedWaypoints` tinyint(1) DEFAULT '0', `p2pMinimumAccess` int(11) DEFAULT '99', `pvpTempBanCooldown` int(11) DEFAULT '60' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `shop` -- DROP TABLE IF EXISTS `shop`; CREATE TABLE `shop` ( `item` varchar(100) NOT NULL DEFAULT '', `category` varchar(20) DEFAULT 'misc', `price` int(11) DEFAULT '50', `stock` int(11) DEFAULT '50', `idx` int(11) DEFAULT '0', `maxStock` int(11) DEFAULT '50', `variation` int(11) DEFAULT '0', `special` int(11) DEFAULT '0', `validated` tinyint(1) DEFAULT '1', `units` int(11) DEFAULT '1', `quality` int(11) DEFAULT '3' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `shop` -- INSERT INTO `shop` (`item`, `category`, `price`, `stock`, `idx`, `maxStock`, `variation`, `special`, `validated`, `units`, `quality`) VALUES ('ammo44MagnumBulletAP', 'ammo', 3, 60, 1, 60, 0, 0, 1, 0, 0), ('ammo762mmBulletAP', 'ammo', 3, 500, 2, 500, 0, 0, 1, 0, 0), ('ammo9mmBulletAP', 'ammo', 3, 500, 3, 500, 0, 0, 1, 0, 0), ('apparelCoatLeatherDuster', 'clothing', 50, 50, 1, 50, 0, 0, 1, 0, 0), ('armorMiningHelmet', 'clothing', 125, 15, 2, 15, 0, 0, 1, 0, 0), ('carBattery', 'machines', 120, 100, 1, 100, 0, 0, 1, 0, 0), ('drinkJarBeer', 'food', 10, 20, 1, 20, 0, 0, 1, 0, 0), ('drinkJarCoffee', 'food', 30, 10, 2, 10, 0, 0, 1, 0, 0), ('drinkJarGoldenRodTea', 'food', 35, 10, 3, 10, 0, 0, 1, 0, 0), ('drugAntibiotics', 'medic', 100, 10, 1, 10, 0, 0, 1, 0, 0), ('drugPainkillers', 'medic', 25, 13, 2, 13, 0, 0, 1, 0, 0), ('drugVitamins', 'medic', 40, 10, 3, 10, 0, 0, 1, 0, 0), ('emberPileDeco1', 'housing', 5, 2000, 1, 2000, 0, 0, 1, 0, 0), ('emberPileDeco2', 'housing', 5, 2000, 2, 2000, 0, 0, 1, 0, 0), ('foodBaconAndEggs', 'food', 30, 10, 4, 10, 0, 0, 1, 0, 0), ('foodCornBread', 'food', 1, 100, 5, 100, 0, 0, 1, 0, 0), ('foodHoney', 'food', 25, 100, 6, 100, 0, 0, 1, 0, 0), ('foodMeatStew', 'food', 50, 18, 7, 18, 0, 0, 1, 0, 0), ('gunRifleT3SniperRifleSchematic', 'books', 100, 50, 1, 50, 0, 0, 1, 0, 0), ('medicalFirstAidBandage', 'medic', 50, 10, 4, 10, 0, 0, 1, 0, 0), ('medicalFirstAidKit', 'medic', 100, 50, 5, 50, 0, 0, 1, 0, 0), ('medicalFirstAidKitSchematic', 'books', 125, 5, 2, 5, 0, 0, 1, 0, 0), ('medicalSplint', 'medic', 18, 500, 6, 500, 0, 0, 1, 0, 0), ('resourceBone', 'stuff', 2, 500, 1, 500, 0, 0, 1, 0, 0), ('resourceConcreteMix', 'housing', 8, 2000, 3, 2000, 0, 0, 1, 0, 0), ('resourceCropCoffeeBeans', 'garden', 50, 10, 1, 10, 0, 0, 1, 0, 0), ('resourceFeather', 'stuff', 2, 5000, 2, 5000, 0, 0, 1, 0, 0), ('resourceGlue', 'stuff', 5, 500, 3, 500, 0, 0, 1, 0, 0), ('resourceHeadlight', 'stuff', 60, 50, 4, 50, 0, 0, 1, 0, 0), ('resourceOil', 'stuff', 15, 5000, 5, 5000, 0, 0, 1, 0, 0), ('resourceRepairKit', 'ammo', 25, 10, 4, 10, 0, 0, 1, 0, 0), ('smallEngine', 'machines', 180, 100, 2, 100, 0, 0, 1, 0, 0), ('storeShelving01', 'housing', 8, 500, 4, 500, 0, 0, 1, 0, 0), ('storeShelving01Double', 'housing', 8, 500, 5, 500, 0, 0, 1, 0, 0), ('storeShelving01Top', 'housing', 8, 500, 6, 500, 0, 0, 1, 0, 0), ('storeShelving01TopDouble', 'housing', 8, 500, 7, 500, 0, 0, 1, 0, 0), ('toolAndDieSet', 'stuff', 120, 35, 6, 35, 0, 0, 1, 0, 0), ('toolBeaker', 'medic', 300, 5, 7, 5, 0, 0, 1, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `shopCategories` -- DROP TABLE IF EXISTS `shopCategories`; CREATE TABLE `shopCategories` ( `category` varchar(20) NOT NULL DEFAULT '', `idx` int(11) DEFAULT '0', `code` varchar(3) DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `shopCategories` -- INSERT INTO `shopCategories` (`category`, `idx`, `code`) VALUES ('ammo', 6, 'a'), ('books', 10, 'b'), ('clothing', 1, 'cl'), ('food', 10, 'f'), ('garden', 5, 'g'), ('housing', 1, 'h'), ('machines', 1, 'ma'), ('medic', 8, 'm'), ('misc', 1, 'mis'), ('stuff', 1, 's'); -- -------------------------------------------------------- -- -- Table structure for table `slots` -- DROP TABLE IF EXISTS `slots`; CREATE TABLE `slots` ( `slot` int(11) NOT NULL, `steam` bigint(17) DEFAULT '0', `online` tinyint(1) DEFAULT '0', `joinedTime` int(11) DEFAULT '0', `joinedSession` int(11) DEFAULT '0', `expires` int(11) DEFAULT '0', `reserved` tinyint(1) DEFAULT '0', `staff` tinyint(1) DEFAULT '0', `free` tinyint(1) DEFAULT '1', `canBeKicked` tinyint(1) DEFAULT '1', `disconnectedTimestamp` int(11) DEFAULT '0', `name` varchar(100) DEFAULT '', `gameID` int(11) DEFAULT '0', `IP` varchar(15) DEFAULT '0.0.0.0', `country` varchar(2) DEFAULT '', `ping` int(11) DEFAULT '0', `level` int(11) DEFAULT '0', `score` int(11) DEFAULT '0', `zombieKills` int(11) DEFAULT '0', `playerKills` int(11) DEFAULT '0', `deaths` int(11) DEFAULT '0' ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `spawnableItems` -- DROP TABLE IF EXISTS `spawnableItems`; CREATE TABLE `spawnableItems` ( `itemName` varchar(100) NOT NULL DEFAULT '', `deleteItem` tinyint(1) DEFAULT '0', `accessLevelRestriction` int(11) DEFAULT '99', `category` varchar(20) DEFAULT 'None', `price` int(11) DEFAULT '10000', `stock` int(11) DEFAULT '5000', `idx` int(11) DEFAULT '0', `maxStock` int(11) DEFAULT '5000', `inventoryResponse` varchar(10) DEFAULT 'none', `StackLimit` int(11) DEFAULT '1000', `newPlayerMaxInventory` int(11) DEFAULT '-1', `units` int(11) DEFAULT '1', `craftable` tinyint(1) DEFAULT '1', `devBlock` tinyint(1) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `staff` -- DROP TABLE IF EXISTS `staff`; CREATE TABLE `staff` ( `steam` bigint(17) NOT NULL DEFAULT '0', `adminLevel` int(11) DEFAULT '2', `blockDelete` tinyint(1) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `teleports` -- DROP TABLE IF EXISTS `teleports`; CREATE TABLE `teleports` ( `active` tinyint(1) DEFAULT '1', `owner` bigint(17) DEFAULT '0', `oneway` tinyint(1) DEFAULT '0', `x` int(11) DEFAULT '0', `y` int(11) DEFAULT '0', `z` int(11) DEFAULT '0', `dx` int(11) DEFAULT '0', `dy` int(11) DEFAULT '0', `dz` int(11) DEFAULT '0', `name` varchar(100) NOT NULL, `friends` tinyint(1) DEFAULT '0', `public` tinyint(1) DEFAULT '0', `size` float DEFAULT '1.5' COMMENT 'size of start tp', `dsize` float DEFAULT '1.5' COMMENT 'size of dest tp', `minimumAccess` int(11) DEFAULT '0', `maximumAccess` int(11) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `timedEvents` -- DROP TABLE IF EXISTS `timedEvents`; CREATE TABLE `timedEvents` ( `timer` varchar(20) NOT NULL DEFAULT '', `delayMinutes` int(11) NOT NULL DEFAULT '10', `nextTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `disabled` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tracker` -- DROP TABLE IF EXISTS `tracker`; CREATE TABLE `tracker` ( `trackerID` bigint(20) NOT NULL, `steam` bigint(17) DEFAULT '0', `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `x` int(11) DEFAULT '0', `y` int(11) DEFAULT '0', `z` int(11) DEFAULT '0', `session` int(11) DEFAULT '0', `flag` varchar(10) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `villagers` -- DROP TABLE IF EXISTS `villagers`; CREATE TABLE `villagers` ( `steam` bigint(17) NOT NULL DEFAULT '0', `village` varchar(20) NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `visits` -- DROP TABLE IF EXISTS `visits`; CREATE TABLE `visits` ( `id` bigint(20) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `steam` bigint(17) NOT NULL, `visited` bigint(17) NOT NULL, `x` int(11) NOT NULL, `y` int(11) NOT NULL, `z` int(11) NOT NULL, `base` int(11) NOT NULL, `session` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `waypoints` -- DROP TABLE IF EXISTS `waypoints`; CREATE TABLE `waypoints` ( `id` int(11) NOT NULL, `steam` bigint(17) DEFAULT '0', `name` varchar(50) DEFAULT NULL, `x` int(11) DEFAULT '0', `y` int(11) DEFAULT '0', `z` int(11) DEFAULT '0', `linked` int(11) DEFAULT '0', `shared` tinyint(1) DEFAULT '0', `public` tinyint(1) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `webInterfaceJSON` -- DROP TABLE IF EXISTS `webInterfaceJSON`; CREATE TABLE `webInterfaceJSON` ( `ident` varchar(50) NOT NULL DEFAULT '', `json` text, `sessionID` varchar(32) DEFAULT '', `recipient` varchar(5) DEFAULT '', `expire` timestamp NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `webInterfaceQueue` -- DROP TABLE IF EXISTS `webInterfaceQueue`; CREATE TABLE `webInterfaceQueue` ( `id` int(11) NOT NULL, `action` varchar(50) DEFAULT '', `actionTable` varchar(50) DEFAULT '', `actionQuery` text, `steam` bigint(17) DEFAULT '0', `actionArgs` varchar(1000) DEFAULT '', `recipient` varchar(5) DEFAULT '', `expire` timestamp NULL DEFAULT '0000-00-00 00:00:00', `sessionID` varchar(32) DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `whitelist` -- DROP TABLE IF EXISTS `whitelist`; CREATE TABLE `whitelist` ( `steam` bigint(17) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `alerts` -- ALTER TABLE `alerts` ADD PRIMARY KEY (`alertID`); -- -- Indexes for table `altertables` -- ALTER TABLE `altertables` ADD PRIMARY KEY (`id`); -- -- Indexes for table `announcements` -- ALTER TABLE `announcements` ADD PRIMARY KEY (`id`); -- -- Indexes for table `APIQueue` -- ALTER TABLE `APIQueue` ADD PRIMARY KEY (`id`); -- -- Indexes for table `badItems` -- ALTER TABLE `badItems` ADD PRIMARY KEY (`item`); -- -- Indexes for table `badWords` -- ALTER TABLE `badWords` ADD PRIMARY KEY (`badWord`); -- -- Indexes for table `bans` -- ALTER TABLE `bans` ADD PRIMARY KEY (`Steam`); -- -- Indexes for table `bases` -- ALTER TABLE `bases` ADD PRIMARY KEY (`steam`,`baseNumber`); -- -- Indexes for table `bookmarks` -- ALTER TABLE `bookmarks` ADD PRIMARY KEY (`id`); -- -- Indexes for table `botChat` -- ALTER TABLE `botChat` ADD PRIMARY KEY (`botChatID`); -- -- Indexes for table `botChatResponses` -- ALTER TABLE `botChatResponses` ADD PRIMARY KEY (`botChatResponseID`); -- -- Indexes for table `botCommands` -- ALTER TABLE `botCommands` ADD PRIMARY KEY (`cmdCode`,`cmdIndex`); -- -- Indexes for table `commandAccessRestrictions` -- ALTER TABLE `commandAccessRestrictions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `commandQueue` -- ALTER TABLE `commandQueue` ADD PRIMARY KEY (`id`); -- -- Indexes for table `connectQueue` -- ALTER TABLE `connectQueue` ADD PRIMARY KEY (`id`); -- -- Indexes for table `customCommands` -- ALTER TABLE `customCommands` ADD PRIMARY KEY (`commandID`); -- -- Indexes for table `customCommands_Detail` -- ALTER TABLE `customCommands_Detail` ADD PRIMARY KEY (`detailID`,`commandID`); -- -- Indexes for table `customMessages` -- ALTER TABLE `customMessages` ADD PRIMARY KEY (`command`); -- -- Indexes for table `donors` -- ALTER TABLE `donors` ADD PRIMARY KEY (`steam`); -- -- Indexes for table `events` -- ALTER TABLE `events` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`), ADD KEY `id_2` (`id`); -- -- Indexes for table `friends` -- ALTER TABLE `friends` ADD PRIMARY KEY (`steam`,`friend`); -- -- Indexes for table `gimmeGroup` -- ALTER TABLE `gimmeGroup` ADD PRIMARY KEY (`groupName`); -- -- Indexes for table `gimmePrizes` -- ALTER TABLE `gimmePrizes` ADD PRIMARY KEY (`name`); -- -- Indexes for table `gimmeQueue` -- ALTER TABLE `gimmeQueue` ADD PRIMARY KEY (`id`); -- -- Indexes for table `gimmeZombies` -- ALTER TABLE `gimmeZombies` ADD PRIMARY KEY (`entityID`); -- -- Indexes for table `helpCommands` -- ALTER TABLE `helpCommands` ADD PRIMARY KEY (`commandID`); -- -- Indexes for table `helpTopicCommands` -- ALTER TABLE `helpTopicCommands` ADD PRIMARY KEY (`topicID`,`commandID`); -- -- Indexes for table `helpTopics` -- ALTER TABLE `helpTopics` ADD PRIMARY KEY (`topicID`); -- -- Indexes for table `hotspots` -- ALTER TABLE `hotspots` ADD PRIMARY KEY (`id`); -- -- Indexes for table `inventoryChanges` -- ALTER TABLE `inventoryChanges` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`), ADD UNIQUE KEY `id_2` (`id`), ADD UNIQUE KEY `id_5` (`id`), ADD KEY `steam` (`steam`), ADD KEY `id_3` (`id`), ADD KEY `id_4` (`id`); -- -- Indexes for table `inventoryTracker` -- ALTER TABLE `inventoryTracker` ADD PRIMARY KEY (`inventoryTrackerID`); -- -- Indexes for table `IPBlacklist` -- ALTER TABLE `IPBlacklist` ADD PRIMARY KEY (`StartIP`); -- -- Indexes for table `ircQueue` -- ALTER TABLE `ircQueue` ADD PRIMARY KEY (`id`); -- -- Indexes for table `keystones` -- ALTER TABLE `keystones` ADD PRIMARY KEY (`steam`,`x`,`y`,`z`), ADD KEY `steam` (`steam`), ADD KEY `steam_2` (`steam`); -- -- Indexes for table `LKPQueue` -- ALTER TABLE `LKPQueue` ADD PRIMARY KEY (`id`); -- -- Indexes for table `locationCategories` -- ALTER TABLE `locationCategories` ADD PRIMARY KEY (`categoryName`); -- -- Indexes for table `locations` -- ALTER TABLE `locations` ADD PRIMARY KEY (`name`), ADD UNIQUE KEY `name` (`name`); -- -- Indexes for table `locationSpawns` -- ALTER TABLE `locationSpawns` ADD PRIMARY KEY (`id`); -- -- Indexes for table `lottery` -- ALTER TABLE `lottery` ADD PRIMARY KEY (`steam`,`ticket`); -- -- Indexes for table `mail` -- ALTER TABLE `mail` ADD PRIMARY KEY (`id`); -- -- Indexes for table `memEntities` -- ALTER TABLE `memEntities` ADD UNIQUE KEY `entityID` (`entityID`); -- -- Indexes for table `memIgnoredItems` -- ALTER TABLE `memIgnoredItems` ADD PRIMARY KEY (`item`); -- -- Indexes for table `memLottery` -- ALTER TABLE `memLottery` ADD PRIMARY KEY (`steam`,`ticket`); -- -- Indexes for table `memRestrictedItems` -- ALTER TABLE `memRestrictedItems` ADD PRIMARY KEY (`item`); -- -- Indexes for table `memShop` -- ALTER TABLE `memShop` ADD PRIMARY KEY (`item`); -- -- Indexes for table `memTracker` -- ALTER TABLE `memTracker` ADD PRIMARY KEY (`trackerID`); -- -- Indexes for table `messageQueue` -- ALTER TABLE `messageQueue` ADD PRIMARY KEY (`id`); -- -- Indexes for table `miscQueue` -- ALTER TABLE `miscQueue` ADD PRIMARY KEY (`id`); -- -- Indexes for table `modBotman` -- ALTER TABLE `modBotman` ADD PRIMARY KEY (`id`); -- -- Indexes for table `otherEntities` -- ALTER TABLE `otherEntities` ADD PRIMARY KEY (`entity`); -- -- Indexes for table `performance` -- ALTER TABLE `performance` ADD PRIMARY KEY (`serverDate`), ADD KEY `serverDate` (`serverDate`); -- -- Indexes for table `persistentQueue` -- ALTER TABLE `persistentQueue` ADD PRIMARY KEY (`id`); -- -- Indexes for table `playerNotes` -- ALTER TABLE `playerNotes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `playerQueue` -- ALTER TABLE `playerQueue` ADD PRIMARY KEY (`id`); -- -- Indexes for table `players` -- ALTER TABLE `players` ADD PRIMARY KEY (`steam`), ADD UNIQUE KEY `steam` (`steam`); -- -- Indexes for table `playersArchived` -- ALTER TABLE `playersArchived` ADD PRIMARY KEY (`steam`), ADD UNIQUE KEY `steam` (`steam`); -- -- Indexes for table `polls` -- ALTER TABLE `polls` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pollVotes` -- ALTER TABLE `pollVotes` ADD PRIMARY KEY (`pollID`,`steam`); -- -- Indexes for table `prefabCopies` -- ALTER TABLE `prefabCopies` ADD PRIMARY KEY (`owner`,`name`); -- -- Indexes for table `proxies` -- ALTER TABLE `proxies` ADD PRIMARY KEY (`scanString`); -- -- Indexes for table `reservedSlots` -- ALTER TABLE `reservedSlots` ADD PRIMARY KEY (`steam`); -- -- Indexes for table `resetZones` -- ALTER TABLE `resetZones` ADD PRIMARY KEY (`region`), ADD UNIQUE KEY `region` (`region`); -- -- Indexes for table `restrictedItems` -- ALTER TABLE `restrictedItems` ADD PRIMARY KEY (`item`); -- -- Indexes for table `searchResults` -- ALTER TABLE `searchResults` ADD PRIMARY KEY (`id`); -- -- Indexes for table `server` -- ALTER TABLE `server` ADD PRIMARY KEY (`id`); -- -- Indexes for table `shop` -- ALTER TABLE `shop` ADD PRIMARY KEY (`item`); -- -- Indexes for table `shopCategories` -- ALTER TABLE `shopCategories` ADD PRIMARY KEY (`category`); -- -- Indexes for table `slots` -- ALTER TABLE `slots` ADD PRIMARY KEY (`slot`); -- -- Indexes for table `spawnableItems` -- ALTER TABLE `spawnableItems` ADD PRIMARY KEY (`itemName`); -- -- Indexes for table `staff` -- ALTER TABLE `staff` ADD PRIMARY KEY (`steam`); -- -- Indexes for table `teleports` -- ALTER TABLE `teleports` ADD PRIMARY KEY (`name`); -- -- Indexes for table `timedEvents` -- ALTER TABLE `timedEvents` ADD PRIMARY KEY (`timer`); -- -- Indexes for table `tracker` -- ALTER TABLE `tracker` ADD PRIMARY KEY (`trackerID`); -- -- Indexes for table `villagers` -- ALTER TABLE `villagers` ADD PRIMARY KEY (`steam`,`village`); -- -- Indexes for table `visits` -- ALTER TABLE `visits` ADD PRIMARY KEY (`id`); -- -- Indexes for table `waypoints` -- ALTER TABLE `waypoints` ADD PRIMARY KEY (`id`); -- -- Indexes for table `webInterfaceJSON` -- ALTER TABLE `webInterfaceJSON` ADD PRIMARY KEY (`ident`); -- -- Indexes for table `webInterfaceQueue` -- ALTER TABLE `webInterfaceQueue` ADD PRIMARY KEY (`id`); -- -- Indexes for table `whitelist` -- ALTER TABLE `whitelist` ADD PRIMARY KEY (`steam`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `alerts` -- ALTER TABLE `alerts` MODIFY `alertID` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `altertables` -- ALTER TABLE `altertables` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=355; -- -- AUTO_INCREMENT for table `announcements` -- ALTER TABLE `announcements` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `APIQueue` -- ALTER TABLE `APIQueue` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bookmarks` -- ALTER TABLE `bookmarks` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `botChat` -- ALTER TABLE `botChat` MODIFY `botChatID` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `botChatResponses` -- ALTER TABLE `botChatResponses` MODIFY `botChatResponseID` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `commandAccessRestrictions` -- ALTER TABLE `commandAccessRestrictions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `commandQueue` -- ALTER TABLE `commandQueue` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `connectQueue` -- ALTER TABLE `connectQueue` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `events` -- ALTER TABLE `events` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `gimmeQueue` -- ALTER TABLE `gimmeQueue` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `helpCommands` -- ALTER TABLE `helpCommands` MODIFY `commandID` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `helpTopics` -- ALTER TABLE `helpTopics` MODIFY `topicID` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `hotspots` -- ALTER TABLE `hotspots` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `inventoryChanges` -- ALTER TABLE `inventoryChanges` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `inventoryTracker` -- ALTER TABLE `inventoryTracker` MODIFY `inventoryTrackerID` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ircQueue` -- ALTER TABLE `ircQueue` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `LKPQueue` -- ALTER TABLE `LKPQueue` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `locationSpawns` -- ALTER TABLE `locationSpawns` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `mail` -- ALTER TABLE `mail` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `memTracker` -- ALTER TABLE `memTracker` MODIFY `trackerID` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `messageQueue` -- ALTER TABLE `messageQueue` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `miscQueue` -- ALTER TABLE `miscQueue` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `modBotman` -- ALTER TABLE `modBotman` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `persistentQueue` -- ALTER TABLE `persistentQueue` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `playerNotes` -- ALTER TABLE `playerNotes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `playerQueue` -- ALTER TABLE `playerQueue` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `polls` -- ALTER TABLE `polls` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `searchResults` -- ALTER TABLE `searchResults` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `server` -- ALTER TABLE `server` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tracker` -- ALTER TABLE `tracker` MODIFY `trackerID` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `visits` -- ALTER TABLE `visits` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `waypoints` -- ALTER TABLE `waypoints` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `webInterfaceQueue` -- ALTER TABLE `webInterfaceQueue` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;