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 STAT Saving Table
Submitted by Logan on February 18, 2017

Download - Report

New Paste 1 (SQL)

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253 
CREATE TABLE IF NOT EXISTS `server2146_character_stats` (
  `id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `oldid` int(11) NOT NULL DEFAULT '0',
  `attack_level` int(11) NOT NULL DEFAULT '1',
  `attack_xp` double NOT NULL DEFAULT '0',
  `defence_level` int(11) NOT NULL DEFAULT '1',
  `defence_xp` double NOT NULL DEFAULT '0',
  `strength_level` int(11) NOT NULL DEFAULT '1',
  `strength_xp` double NOT NULL DEFAULT '0',
  `hitpoints_level` int(11) NOT NULL DEFAULT '10',
  `hitpoints_xp` double NOT NULL DEFAULT '1300',
  `ranged_level` int(11) NOT NULL DEFAULT '1',
  `ranged_xp` double NOT NULL DEFAULT '0',
  `prayer_level` int(11) NOT NULL DEFAULT '1',
  `prayer_xp` double NOT NULL DEFAULT '0',
  `magic_level` int(11) NOT NULL DEFAULT '1',
  `magic_xp` double NOT NULL DEFAULT '0',
  `cooking_level` int(11) NOT NULL DEFAULT '1',
  `cooking_xp` double NOT NULL DEFAULT '0',
  `woodcutting_level` int(11) NOT NULL DEFAULT '1',
  `woodcutting_xp` double NOT NULL DEFAULT '0',
  `fletching_level` int(11) NOT NULL DEFAULT '1',
  `fletching_xp` double NOT NULL DEFAULT '0',
  `fishing_level` int(11) NOT NULL DEFAULT '1',
  `fishing_xp` double NOT NULL DEFAULT '0',
  `firemaking_level` int(11) NOT NULL DEFAULT '1',
  `firemaking_xp` double NOT NULL DEFAULT '0',
  `crafting_level` int(11) NOT NULL DEFAULT '1',
  `crafting_xp` double NOT NULL DEFAULT '0',
  `smithing_level` int(11) NOT NULL DEFAULT '1',
  `smithing_xp` double NOT NULL DEFAULT '0',
  `mining_level` int(11) NOT NULL DEFAULT '1',
  `mining_xp` double NOT NULL DEFAULT '0',
  `herblore_level` int(11) NOT NULL DEFAULT '1',
  `herblore_xp` double NOT NULL DEFAULT '0',
  `agility_level` int(11) NOT NULL DEFAULT '1',
  `agility_xp` double NOT NULL DEFAULT '0',
  `thieving_level` int(11) NOT NULL DEFAULT '1',
  `thieving_xp` double NOT NULL DEFAULT '0',
  `slayer_level` int(11) NOT NULL DEFAULT '1',
  `slayer_xp` double NOT NULL DEFAULT '0',
  `farming_level` int(11) NOT NULL DEFAULT '1',
  `farming_xp` double NOT NULL DEFAULT '0',
  `runecrafting_level` int(11) NOT NULL DEFAULT '1',
  `runecrafting_xp` double NOT NULL DEFAULT '0',
  `total_level` int(11) DEFAULT '30',
  `total_xp` double DEFAULT '1300',
  `combat` int(11) DEFAULT '3',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  KEY `uid` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;