CREATE TABLE `LoginLogs` (
  `dbid` int(11) DEFAULT NULL,
  `connectedFrom` varchar(100) DEFAULT NULL,
  `hostAddress` varchar(100) DEFAULT NULL,
  `macAddress` varchar(100) DEFAULT NULL,
  `regSerial` varchar(100) DEFAULT NULL,
  `systemName` varchar(100) DEFAULT NULL,
  `playerName` varchar(50) DEFAULT NULL,
  `playerRights` int(11) DEFAULT NULL,
  `macAdress` varchar(100) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

CREATE TABLE `account_registration` (
  `playerID` int(11) DEFAULT NULL,
  `playerName` varchar(50) DEFAULT NULL,
  `registerDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `hostAddress` varchar(100) DEFAULT NULL,
  `macAddress` varchar(100) DEFAULT NULL,
  `regSerial` varchar(100) DEFAULT NULL,
  `systemName` varchar(100) DEFAULT NULL
);

CREATE TABLE `clients` (
  `playerID` int(11) DEFAULT NULL,
  `voteStreaks` int(11) DEFAULT NULL,
  `playerName` varchar(50) DEFAULT NULL,
  `playerMacAddress` varchar(50) DEFAULT NULL,
  `connectedFrom` varchar(50) DEFAULT NULL,
  `regSerial` varchar(50) DEFAULT NULL,
  `dbid` int(11) DEFAULT NULL,
  `lockedExperienceGain` tinyint(1) DEFAULT NULL,
  `weaponGameMeleeLevel` int(11) DEFAULT NULL,
  `encryptedPass` varchar(100) DEFAULT NULL,
  `gameMode` varchar(50) DEFAULT NULL,
  `newPlayer` tinyint(1) DEFAULT NULL,
  `heightLevel` int(11) DEFAULT NULL,
  `absX` int(11) DEFAULT NULL,
  `absY` int(11) DEFAULT NULL,
  `playerRights` int(11) DEFAULT NULL,
  `systemName` varchar(50) DEFAULT NULL,
  `playerMacAdress` varchar(50) DEFAULT NULL,
  `titleColor` varchar(50) DEFAULT NULL,
  `runEnergy` int(11) DEFAULT NULL,
  `titleShadow` varchar(50) DEFAULT NULL,
  `textShadow` varchar(50) DEFAULT NULL,
  `yellTitle` varchar(50) DEFAULT NULL,
  `textYellColor` varchar(50) DEFAULT NULL,
  `crystalBowShots` int(11) DEFAULT NULL,
  `lostCatId` int(11) DEFAULT NULL,
  `dungTokens` int(11) DEFAULT NULL,
  `duelsWon` int(11) DEFAULT NULL,
  `duelsLost` int(11) DEFAULT NULL,
  `premiumPoints` int(11) DEFAULT NULL,
  `voterPoints` int(11) DEFAULT NULL,
  `totalVotes` int(11) DEFAULT NULL,
  `amountDonated` int(11) DEFAULT NULL,
  `title` varchar(50) DEFAULT NULL,
  `donorPoints` int(11) DEFAULT NULL,
  `tempAmountDonated` int(11) DEFAULT NULL,
  `YellsRemaining` float DEFAULT NULL,
  `playTime` mediumtext,
  `weaponGameRangeLevel` int(11) DEFAULT NULL,
  `weaponGameMageLevel` int(11) DEFAULT NULL,
  `weaponGameMeleeKills` int(11) DEFAULT NULL,
  `weaponGameRangeKills` int(11) DEFAULT NULL,
  `weaponGameMeleeDeaths` int(11) DEFAULT NULL,
  `weaponGameRangeDeaths` int(11) DEFAULT NULL,
  `weaponGameMageDeaths` int(11) DEFAULT NULL,
  `weaponGameMeleeLP` int(11) DEFAULT NULL,
  `weaponGameRangeLP` int(11) DEFAULT NULL,
  `weaponGameMageLP` int(11) DEFAULT NULL,
  `lastWeapon` int(11) DEFAULT NULL,
  `homeArea` int(11) DEFAULT NULL,
  `Tasksdone` int(11) DEFAULT NULL,
  `bankPin` int(11) DEFAULT NULL,
  `recievedWg` tinyint(1) DEFAULT NULL,
  `usingCurses` int(11) DEFAULT NULL,
  `useCustomYell` tinyint(1) DEFAULT NULL,
  `attemptsRemaining` int(11) DEFAULT NULL,
  `WGPoints` int(11) DEFAULT NULL,
  `poisonDamage` int(11) DEFAULT NULL,
  `action` int(11) DEFAULT NULL,
  `totalBossesKilled` int(11) DEFAULT NULL,
  `PkKillCount` int(11) DEFAULT NULL,
  `boostedHits` int(11) DEFAULT NULL,
  `pure` int(11) DEFAULT NULL,
  `isSpawned` tinyint(1) DEFAULT NULL,
  `FamiliarID` int(11) DEFAULT NULL,
  `pkingPoints` int(11) DEFAULT NULL,
  `skullTimer` int(11) DEFAULT NULL,
  `weaponGameMageKills` int(11) DEFAULT NULL,
  `recoveryId` int(11) DEFAULT NULL,
  `playerDeathCount` int(11) DEFAULT NULL,
  `Blackmarks` int(11) DEFAULT NULL,
  `xpLock` int(11) DEFAULT NULL,
  `membership` tinyint(1) DEFAULT NULL,
  `startDay` int(11) DEFAULT NULL,
  `startMonth` int(11) DEFAULT NULL,
  `recoilCount` int(11) DEFAULT NULL,
  `doubleExpRingCount` int(11) DEFAULT NULL,
  `playerMagicBook` int(11) DEFAULT NULL,
  `barrowsNpcs` varchar(1000) DEFAULT NULL,
  `specialAttackCharge` double DEFAULT NULL,
  `randomCoffin` int(11) DEFAULT NULL,
  `barrowsKillCount` int(11) DEFAULT NULL,
  `pcPoints` int(11) DEFAULT NULL,
  `donatedtimes` int(11) DEFAULT NULL,
  `donatorType` int(11) DEFAULT NULL,
  `isStarter` int(11) DEFAULT NULL,
  `magePoints` int(11) DEFAULT NULL,
  `pkPoints` int(11) DEFAULT NULL,
  `waveId` int(11) DEFAULT NULL,
  `killCount` int(11) DEFAULT NULL,
  `fightStyle` int(11) DEFAULT NULL,
  `fightMode` int(11) DEFAULT NULL,
  `epAmount` int(11) DEFAULT NULL,
  `splitChat` int(11) DEFAULT NULL,
  `brightness` int(11) DEFAULT NULL,
  `totalEXP` mediumtext,
  `enterBHTimer` int(11) DEFAULT NULL,
  `lastClan` varchar(50) DEFAULT NULL,
  `lastWithdrawAmount` int(11) DEFAULT NULL,
  `playerEquipment` varchar(1000) DEFAULT NULL,
  `playerAppearance` varchar(1000) DEFAULT NULL,
  `playerLevel` varchar(1000) DEFAULT NULL,
  `playerItems` varchar(5000) DEFAULT NULL,
  `playerBank` varchar(25000) DEFAULT NULL,
  `clanKey` int(11) DEFAULT NULL,
  `friends` varchar(1000) DEFAULT NULL,
  `ignores` varchar(1000) DEFAULT NULL,
  `publicChatMode` int(11) DEFAULT NULL,
  `privateChatMode` int(11) DEFAULT NULL,
  `clanChatMode` int(11) DEFAULT NULL,
  `tradeMode` int(11) DEFAULT NULL,
  `shoutMode` int(11) DEFAULT NULL,
  `globalMode` int(11) DEFAULT NULL,
  `gameChatMode` int(11) DEFAULT NULL,
  `bossesKilled` int(11) DEFAULT NULL,
  `wonBets` int(11) DEFAULT NULL,
  `lostBets` int(11) DEFAULT NULL,
  `resetRequestDate` mediumtext,
  `tasks` varchar(2000) DEFAULT NULL,
  `taskProgress` varchar(5000) DEFAULT NULL,
  `familiaritems` varchar(1000) DEFAULT NULL,
  `settingValues` varchar(500) DEFAULT NULL,
  `playerData` varchar(5000) DEFAULT NULL,
  `playerPresets` varchar(2000) DEFAULT NULL,
  `playerTimers` varchar(2000) DEFAULT NULL,
  `itemDegrading` varchar(2000) DEFAULT NULL,
  `playerSettings` varchar(2000) DEFAULT NULL,
  `quickPrayers` int(11) DEFAULT NULL,
  `quickCurses` int(11) DEFAULT NULL,
  `overloadTick` int(11) DEFAULT NULL,
  `lastDailyReward` int(11) DEFAULT NULL,
  `wgClassID` int(11) DEFAULT NULL,
  `playerEmail` varchar(30) DEFAULT NULL,
  `castleWarsScore` int(11) DEFAULT NULL,
  `castleWarsCaptures` int(11) DEFAULT NULL,
  `castleWarsCatapultDamage` int(11) DEFAULT NULL,
  `changePassword` int(11) DEFAULT NULL,
  `slayerMaster` int(11) DEFAULT NULL,
  `castleWarsGamesPlayed` int(11) DEFAULT NULL,
  `castleWarsKills` int(11) DEFAULT NULL,
  `slayerMonsterType` int(11) DEFAULT NULL,
  `slayerPendingKills` int(11) DEFAULT NULL,
  `slayerPoints` int(11) DEFAULT NULL,
  `slayerTaskStreak` int(11) DEFAULT NULL,
  `slayerDisabledTasks` varchar(300) DEFAULT NULL,
  `recolors` varchar(500) DEFAULT NULL,
  `settingsFlags` mediumtext,
  `killStreak` int(11) DEFAULT NULL,
  `knowledgePool` mediumtext,
  `luckPool` mediumtext,
  `precisionPool` mediumtext,
  `reinvigorationPool` mediumtext,
  `securityPool` mediumtext,
  `dfsCharges` int(11) DEFAULT NULL,
  `acceptRules` int(11) DEFAULT NULL,
  `lastVoteStreak` mediumtext,
  `lastStreakPenalty` mediumtext,
  `streakPenalty` mediumtext,
  `donatorExpireTime` mediumtext,
  `participationPoints` int(11) DEFAULT NULL,
  `contributionPoints` int(11) DEFAULT NULL,
  `dicingHosts` int(11) DEFAULT NULL,
  `trollPetNameID` int(11) DEFAULT NULL,
  `charmCollectSettings` int(11) DEFAULT NULL,
  `skillingPoints` int(11) DEFAULT NULL,
  `skillingExperience` int(11) DEFAULT NULL,
  `experienceBonus` mediumtext,
  `collectBoneID` int(11) DEFAULT NULL,
  `collectedBones` int(11) DEFAULT NULL,
  `playerTitle` varchar(100) DEFAULT NULL,
  `titleTasks` varchar(300) DEFAULT NULL,
  `progressVariables` varchar(300) DEFAULT NULL,
  `fightPitsWins` int(11) DEFAULT NULL,
  `middleman` tinyint(1) DEFAULT NULL,
  `rareDropCount` int(11) DEFAULT NULL,
  `duelPresets` varchar(300) DEFAULT NULL,
  `minedDusts` int(11) DEFAULT NULL,
  `spottedStars` int(11) DEFAULT NULL,
  `soulPoints` int(11) DEFAULT NULL,
  `lastRecoverCountReset` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `collectionRecoveries` varchar(500) DEFAULT NULL,
  `easyScroll` varchar(100) DEFAULT NULL,
  `mediumScroll` varchar(100) DEFAULT NULL,
  `hardScroll` varchar(100) DEFAULT NULL,
  `eliteScroll` varchar(100) DEFAULT NULL,
  `recoveryPoints` int(11) DEFAULT NULL,
  `dicingDuration` mediumtext,
  `bankItems` varchar(3000) DEFAULT NULL,
  `isTrusted` tinyint(1) DEFAULT NULL
);

CREATE TABLE `clients_old` (
  `playerID` int(11) DEFAULT NULL,
  `voteStreaks` int(11) DEFAULT NULL,
  `playerName` varchar(50) DEFAULT NULL,
  `playerMacAddress` varchar(50) DEFAULT NULL,
  `connectedFrom` varchar(50) DEFAULT NULL,
  `regSerial` varchar(50) DEFAULT NULL
);

CREATE TABLE `collect` (
  `player` int(11) DEFAULT NULL,
  `items` varchar(1000) DEFAULT NULL
);

CREATE TABLE `npcKills` (
  `playerID` int(11) DEFAULT NULL,
  `npcID` int(11) DEFAULT NULL,
  `killCount` int(11) DEFAULT NULL,
  `bestKillTime` mediumtext
);

CREATE TABLE `player_inventory` (
  `playerID` int(11) DEFAULT NULL,
  `looting_bag` varchar(5000) DEFAULT NULL
);

CREATE TABLE `player_killing_score` (
  `player_id` int(11) DEFAULT NULL,
  `pk_score` int(11) DEFAULT NULL
);

CREATE TABLE `player_killing_tournament` (
  `playerID` int(11) DEFAULT NULL,
  `score` int(11) DEFAULT NULL
);

CREATE TABLE `player_pending_action` (
  `action_id` int(11) DEFAULT NULL,
  `player_id` int(11) DEFAULT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type` varchar(100) DEFAULT NULL
);

CREATE TABLE `playercount` (
  `playerCount` int(11) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `count` int(11) DEFAULT NULL
);

CREATE TABLE `punishment` (
  `index` int(11) DEFAULT NULL,
  `playerName` varchar(50) DEFAULT NULL,
  `agent` varchar(50) DEFAULT NULL,
  `expireDate` mediumtext,
  `duration` varchar(50) DEFAULT NULL,
  `type` varchar(300) DEFAULT NULL,
  `reason` varchar(50) DEFAULT NULL,
  `punishment` varchar(50) DEFAULT NULL,
  `hostAddress` varchar(100) DEFAULT NULL,
  `serial` varchar(100) DEFAULT NULL
);

CREATE TABLE `time_online_log` (
  `playerID` int(11) DEFAULT NULL,
  `loginHash` int(11) DEFAULT NULL,
  `onlineTime` mediumtext
);

CREATE TABLE `votes_lottery_winners` (
  `playerID` int(11) DEFAULT NULL,
  `playerName` varchar(50) DEFAULT NULL,
  `itemID` int(11) DEFAULT NULL,
  `dateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

CREATE TABLE `votes_record` (
  `playerID` int(11) DEFAULT NULL,
  `playerName` varchar(50) DEFAULT NULL,
  `points` int(11) DEFAULT NULL,
  `totalPoints` int(11) DEFAULT NULL,
  `voteStreaks` float DEFAULT NULL
);

CREATE TABLE `votes_winners` (
  `playerID` int(11) DEFAULT NULL,
  `playerName` varchar(50) DEFAULT NULL,
  `position` int(11) DEFAULT NULL,
  `points` int(11) DEFAULT NULL,
  `voteStreaks` float DEFAULT NULL,
  `dateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

CREATE TABLE `voting_lottery` (
  `playerID` int(11) DEFAULT NULL,
  `playerName` varchar(50) DEFAULT NULL
);

CREATE TABLE `website_message` (
  `message_type` varchar(100) DEFAULT NULL,
  `data` varchar(100) DEFAULT NULL
);