-- phpMyAdmin SQL Dump
-- version 3.3.7deb7
-- http://www.phpmyadmin.net

-- Date: 30 April 2017 2:05 PM

/*!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 utf8 */;

-- ---
-- Table 'account'
--
-- ---

DROP TABLE IF EXISTS `account`;

CREATE TABLE `account` (
  `id` INTEGER(10) NULL AUTO_INCREMENT DEFAULT NULL,
  `guid` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is the players unique id!',
  `head` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is where head armor goes!',
  `body` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is where body armor goes!',
  `hand` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is where hand armor goes!',
  `foot` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is where foot armor goes!',
  `horse` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is where equiped horse goes!',
  `horse_health` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is where equiped horse health goes!',
  `slot1` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is item slot 1!',
  `slot2` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is item slot 2!',
  `slot3` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is item slot 3!',
  `slot4` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is item slot 4!',
  `health` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is player health!',
  `hunger` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is player hunger!',
  `faction` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is player faction!',
  `player_gold` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is player gold!',
  `bank_gold` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is player bank gold!',
  `status` VARCHAR NULL DEFAULT NULL COMMENT 'This is player status (online, offline, etc)',
  `posx` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is the player x position!',
  `posy` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is the player y position!',
  `posz` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is the player z position!',
  `banned_yes` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is if the player is banned or not!',
  `admin_level` VARCHAR(30) NULL DEFAULT NULL COMMENT '0 = none, 1 = teleport, 2 = kick, 3 = ban',
  PRIMARY KEY (`id`),
  UNIQUE KEY (`guid`)
);

-- ---
-- Table 'names'
--
-- ---

DROP TABLE IF EXISTS `names`;

CREATE TABLE `names` (
  `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
  `guid` VARCHAR(30) NULL DEFAULT NULL COMMENT 'This is the players unique id!',
  `name` VARCHAR(30) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY (`name`)
);

-- ---
-- Foreign Keys
-- ---

ALTER TABLE `names` ADD FOREIGN KEY (guid) REFERENCES `account` (`guid`);