-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- Client: localhost
-- Généré le: Dim 06 Avril 2014 à 13:19
-- Version du serveur: 5.6.12-log
-- Version de PHP: 5.4.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


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

--
-- Base de données: `elkyosserver`
--
CREATE DATABASE IF NOT EXISTS `elkyosserver` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `elkyosserver`;

-- --------------------------------------------------------

--
-- Structure de la table `accounts`
--

CREATE TABLE IF NOT EXISTS `accounts` (
  `auto_increment` int(11) NOT NULL AUTO_INCREMENT,
  `accountName` varchar(64) NOT NULL,
  `characterName` varchar(16) NOT NULL,
  `uniqueId` varchar(36) NOT NULL,
  `breed` tinyint(4) NOT NULL,
  `gender` tinyint(4) NOT NULL,
  `customization` varchar(256) NOT NULL,
  PRIMARY KEY (`auto_increment`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

--
-- Contenu de la table `accounts`
--

INSERT INTO `accounts` (`auto_increment`, `accountName`, `characterName`, `uniqueId`, `breed`, `gender`, `customization`) VALUES
(16, 'Player2', 'Character263', '~~NULL~~', 1, 0, 'primaryColor(255,255,255):-1:secondaryColor(255,255,255):0:0:0:-1:-1:-1:-1'),
(17, 'Player1', 'Character198', '~~NULL~~', 1, 0, 'primaryColor(255,255,255):-1:secondaryColor(255,255,255):0:0:0:-1:-1:-1:-1'),
(18, 'Player5', 'Character53', '~~NULL~~', 1, 0, 'primaryColor(255,255,255):-1:secondaryColor(255,255,255):0:0:0:-1:-1:-1:-1'),
(19, 'Player3', 'Character290', '~~NULL~~', 1, 0, 'primaryColor(255,255,255):-1:secondaryColor(255,255,255):0:0:0:-1:-1:-1:-1'),
(20, 'Player0', 'Character295', '~~NULL~~', 1, 0, 'primaryColor(255,255,255):-1:secondaryColor(255,255,255):0:0:0:-1:-1:-1:-1'),
(21, 'Player8', 'Character131', '~~NULL~~', 1, 0, 'primaryColor(255,255,255):-1:secondaryColor(255,255,255):0:0:0:-1:-1:-1:-1'),
(22, 'Player9', 'Character272', '~~NULL~~', 1, 0, 'primaryColor(255,255,255):-1:secondaryColor(255,255,255):0:0:0:-1:-1:-1:-1'),
(23, 'Player6', 'Character315', '~~NULL~~', 1, 0, 'primaryColor(255,255,255):-1:secondaryColor(255,255,255):0:0:0:-1:-1:-1:-1'),
(24, 'Player4', 'Character251', '~~NULL~~', 1, 0, 'primaryColor(255,255,255):-1:secondaryColor(255,255,255):0:0:0:-1:-1:-1:-1');

-- --------------------------------------------------------

--
-- Structure de la table `items`
--

CREATE TABLE IF NOT EXISTS `items` (
  `key` int(11) NOT NULL,
  `type` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `quests(test)`
--

CREATE TABLE IF NOT EXISTS `quests(test)` (
  `auto_increment` int(11) NOT NULL AUTO_INCREMENT,
  `qID` int(11) NOT NULL,
  `parentID` int(11) NOT NULL DEFAULT '-1',
  `type` tinyint(64) NOT NULL,
  `goal` varchar(255) NOT NULL,
  `reward` varchar(255) NOT NULL,
  `difficultyLevel` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`auto_increment`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Structure de la table `zones`
--

CREATE TABLE IF NOT EXISTS `zones` (
  `zone_id` int(11) NOT NULL,
  `point_1` char(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `point_2` char(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `zone_name` char(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `parent_id` int(11) NOT NULL,
  `priority` int(11) NOT NULL,
  `place_permission` tinyint(1) NOT NULL,
  `pvp_flag` tinyint(1) NOT NULL,
  `keywords` char(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `tick1` int(11) NOT NULL,
  `tick2` int(11) NOT NULL,
  `mob_spawn_restrictions` char(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `mob_move_restrictions` char(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  UNIQUE KEY `zone_id` (`zone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;