Surprise! We've been running on hardware provided by BuyVM for a few months and wanted to show them a little appreciation.
Running a paste site comes with unique challenges, ones that aren't always obvious and hard to control. As such, BuyVM offered us a home where we could worry less about the hosting side of things and focus on maintaining a clean and useful service! Go check them out and show them some love!
Description: MySQL Char Saving Table
Submitted by Logan on February 18, 2017

New Paste 1 (SQL)

CREATE TABLE IF NOT EXISTS `server2146_characters` (
  `id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(25) NOT NULL DEFAULT '',
  `height` tinyint(4) NOT NULL DEFAULT '0',
  `x` smallint(6) NOT NULL DEFAULT '2606',
  `y` smallint(6) NOT NULL DEFAULT '3102',
  `fightStyle` tinyint(4) NOT NULL DEFAULT '1',
  `energy` int(11) DEFAULT '100',
  `questPoints` int(11) DEFAULT NULL,
  `skullTimer` int(11) DEFAULT NULL,
  `specAmount` int(11) DEFAULT '100',
  `teleBlockLength` int(11) DEFAULT NULL,
  `autoRetaliate` tinyint(4) DEFAULT NULL,
  `accountFlagged` tinyint(4) DEFAULT NULL,
  `mageArenaPoints` int(11) DEFAULT NULL,
  `taskId` int(11) DEFAULT NULL,
  `taskAmount` int(11) DEFAULT NULL,
  `slayerPoints` int(11) DEFAULT NULL,
  `bank` longtext,
  `equipment` longtext,
  `inventory` longtext,
  `look` longtext,
  `friends` longtext,
  `addStarter` tinyint(1) DEFAULT '1',
  `splitChat` tinyint(1) DEFAULT '1',
  `uuid` varchar(255) DEFAULT NULL,
  `playerVotePoints` int(11) DEFAULT '0',
  `playerLevelPoints` int(11) DEFAULT '0',
  `playerAssaultPoints` int(11) DEFAULT '0',
  `playerCWGames` int(11) DEFAULT '0',
  `playerLockedXP` int(1) DEFAULT '0',
  `playerMembership` int(1) DEFAULT '0',
  `playerXPModifier` decimal(10,0) DEFAULT '0',
  `playerLastLogin` datetime DEFAULT '0000-00-00 00:00:00',
  `playerDesertTreasure` int(11) DEFAULT '0',
  `playerDTKill` int(11) DEFAULT '0',
  `playerHFD` int(11) DEFAULT '0',
  `playerRFDRound` int(11) DEFAULT '0',
  `playerCookAss` int(11) DEFAULT '0',
  `playerRuneMysteries` int(1) DEFAULT '0',
  `playerDoricsQuest` int(1) DEFAULT '0',
  `playerDemonSlayer` int(1) DEFAULT '0',
  `playerIncantation` int(1) DEFAULT '0',
  `playerBoneSearch` int(1) DEFAULT '0',
  `playerCaptainbRov` int(1) DEFAULT '0',
  `playerTrailBorn` int(1) DEFAULT '0',
  `playerCrystalbowShots` int(11) DEFAULT '0',
  `playerJail` int(11) DEFAULT '0',
  `playerPlaytime` int(11) DEFAULT '0',
  `playerMagicBook` int(3) DEFAULT '1',
  `playerBrotherInfo` varchar(45) DEFAULT '0 0,1 0,2 0,3 0,4 0,5 0',
  `playerSelectedCoffin` int(3) DEFAULT '0',
  `playerBarrowsKills` int(11) DEFAULT '0',
  `playerPouch` varchar(45) DEFAULT '0 0 0 0',
  `playerPCPoints` int(11) DEFAULT '0',
  `playerRemovedTask1` int(1) DEFAULT '0',
  `playerRemovedTask2` int(1) DEFAULT '0',
  `playerRemovedTask3` int(1) DEFAULT '0',
  `playerRemovedTask4` int(1) DEFAULT '0',
  `playerPKPoints` int(11) DEFAULT '0',
  `playerFMPoints` int(11) DEFAULT '0',
  `playerRogueKills` int(11) DEFAULT '0',
  `playerBountyKills` int(11) DEFAULT '0',
  `playerSafeTimer` int(11) DEFAULT '0',
  `playerPenaltyTimer` int(1) DEFAULT '0',
  `playerKillsMultiplier` int(3) DEFAULT '1',
  `playerWave` int(11) DEFAULT '0',
  `playerGWKC` int(11) DEFAULT '0',
  `playerVoid` varchar(45) DEFAULT '0 0 0 0',
  `playerCompletedTutorial` int(1) DEFAULT '0',
  `playerTutorial` varchar(45) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  KEY `id` (`id`),
  FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;