CREATE TABLE IF NOT EXISTS `%prefix%players` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `displayName` varchar(30) DEFAULT NULL,
  `address` varchar(15) DEFAULT NULL,
  `inventory` text,
  `armor` text,
  `heldItemSlot` int(11) DEFAULT NULL,
  `health` int(11) DEFAULT NULL,
  `remainingAir` int(11) DEFAULT NULL,
  `fireTicks` int(11) DEFAULT NULL,
  `foodLevel` int(11) DEFAULT NULL,
  `exhaustion` float DEFAULT NULL,
  `saturation` float DEFAULT NULL,
  `gameMode` varchar(15) DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `exp` float DEFAULT NULL,
  `totalExperience` int(11) DEFAULT NULL,
  `potionEffects` text,

  `server` varchar(30) DEFAULT NULL,
  `world` varchar(15) DEFAULT NULL,
  `coords` varchar(100) DEFAULT NULL,

  `groups` text,

  `bedServer` varchar(30) DEFAULT NULL,
  `bedWorld` varchar(15) DEFAULT NULL,
  `bedCoords` varchar(100) DEFAULT NULL,

  `joins` int(11) DEFAULT 0,
  `firstJoin` timestamp NOT NULL DEFAULT '00-00-0000 00:00:00',
  `lastJoin` timestamp NULL DEFAULT NULL,
  `quits` int(11) DEFAULT 0,
  `lastQuit` timestamp NULL DEFAULT NULL,
  `kicks` int(11) DEFAULT 0,
  `lastKick` timestamp NULL DEFAULT NULL,
  `lastKickMessage` varchar(255) DEFAULT NULL,
  `deaths` int(11) DEFAULT 0,
  `deathCauses` text,
  `lastDeath` timestamp NULL DEFAULT NULL,
  `lastDeathMessage` varchar(255) DEFAULT NULL,
  `playerKills` int(11) DEFAULT 0,
  `playersKilled` text,
  `playersKilledByWeapon` text,
  `lastPlayerKill` timestamp NULL DEFAULT NULL,
  `lastPlayerKilled` varchar(30) DEFAULT NULL,
  `mobKills` int(11) DEFAULT 0,
  `mobsKilled` text,
  `mobsKilledByWeapon` text,
  `lastMobKill` timestamp NULL DEFAULT NULL,
  `lastMobKilled` varchar(30) DEFAULT NULL,

  `blocksBroken` text,
  `blocksPlaced` text,
  `animalsTamed` text,
  `travelDistances` text,
  `biomeDistances` text,
  `travelTimes` text,
  `biomeTimes` text,
  `itemsDropped` text,
  `itemsPickedUp` text,
  `itemsCrafted` text,
  `eggsThrown` text,
  `foodEaten` text,

  `timesSlept` int(11) DEFAULT 0,
  `arrowsShot` int(11) DEFAULT 0,
  `firesStarted` int(11) DEFAULT 0,
  `fishCaught` int(11) DEFAULT 0,
  `sheepSheared` int(11) DEFAULT 0,
  `chatMessages` int(11) DEFAULT 0,
  `portalsCrossed` int(11) DEFAULT 0,
  `waterBucketsFilled` int(11) DEFAULT 0,
  `waterBucketsEmptied` int(11) DEFAULT 0,
  `lavaBucketsFilled` int(11) DEFAULT 0,
  `lavaBucketsEmptied` int(11) DEFAULT 0,
  `cowsMilked` int(11) DEFAULT 0,
  `mushroomCowsMilked` int(11) DEFAULT 0,
  `sheepDyed` int(11) DEFAULT 0,
  `lifetimeExperience` int(11) DEFAULT 0,
  `itemsEnchanted` int(11) DEFAULT 0,
  `itemEnchantmentLevels` int(11) DEFAULT 0,

  `sessionTime` int(11) DEFAULT 0,
  `totalTime` int(11) DEFAULT 0,

  `lastUpdate` timestamp NOT NULL DEFAULT '00-00-0000 00:00:00',

  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
);
CREATE TABLE IF NOT EXISTS `%prefix%versions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `version` varchar(10) NOT NULL,
  `updated` timestamp NOT NULL DEFAULT '00-00-0000 00:00:00',

  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
);
INSERT INTO `%prefix%versions` (name,version,updated) VALUES ("%pluginName%","1",NOW())
ON DUPLICATE KEY UPDATE version=VALUES(version), updated=VALUES(updated);
=== Version: 1
