-- phpMyAdmin SQL Dump
-- version 4.6.5.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Dec 20, 2017 at 05:03 PM
-- Server version: 10.1.21-MariaDB
-- PHP Version: 5.6.30

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

--
-- Database: `l5rp_new`
--

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

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `id` int(11) NOT NULL,
  `username` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
  `username_canonical` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
  `email_canonical` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `salt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `last_login` datetime DEFAULT NULL,
  `confirmation_token` varchar(180) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password_requested_at` datetime DEFAULT NULL,
  `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `first_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `character_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (
	`id`,
	`username`,
	`username_canonical`,
	`email`,
	`email_canonical`,
	`enabled`,
	`salt`,
	`password`,
	`last_login`,
	`confirmation_token`,
	`password_requested_at`,
	`roles`,
	`first_name`,
	`last_name`,
	`character_id`
) VALUES
(1, 'test@gmail.com', 'test@gmail.com', 'test@gmail.com', 'test@gmail.com', 1, NULL, 'putmd5hashhere', NULL, NULL, NULL, '', 'Vardenis', 'Pavardenis', 3);

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

--
-- Table structure for table `action_history`
--

CREATE TABLE `action_history` (
  `id` int(11) NOT NULL,
  `account_id` int(11) DEFAULT NULL,
  `time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `action` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `x` double NOT NULL,
  `y` double NOT NULL,
  `z` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `characters`
--

CREATE TABLE `characters` (
  `id` int(11) NOT NULL,
  `gender` tinyint(1) NOT NULL,
  `x` double NOT NULL,
  `y` double NOT NULL,
  `z` double NOT NULL,
  `xp` int(11) NOT NULL,
  `money` int(11) NOT NULL,
  `job` int(11) NOT NULL,
  `face` tinyint(1) NOT NULL,
  `skinCol` double NOT NULL,
  `hair` tinyint(1) NOT NULL,
  `hairCol` tinyint(1) NOT NULL,
  `hairHCol` tinyint(1) NOT NULL,
  `eyeBCol` tinyint(1) NOT NULL,
  `beardCol` tinyint(1) NOT NULL,
  `chestCol` tinyint(1) NOT NULL,
  `eyeCol` tinyint(1) NOT NULL,
  `top` int(11) NOT NULL,
  `legs` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `shoes` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `character_face_features`
--

CREATE TABLE `character_face_features` (
  `character_id` int(11) NOT NULL,
  `offset` tinyint(11) UNSIGNED NOT NULL,
  `value` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `character_head_overlays`
--

CREATE TABLE `character_head_overlays` (
  `character_id` int(11) NOT NULL,
  `offset` tinyint(3) UNSIGNED NOT NULL,
  `value` tinyint(3) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `vehicles`
--

CREATE TABLE `vehicles` (
  `id` int(11) NOT NULL,
  `model` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `x` double NOT NULL,
  `y` double NOT NULL,
  `z` double NOT NULL,
  `rx` double NOT NULL,
  `ry` double NOT NULL,
  `rz` double NOT NULL,
  `job` int(11) NOT NULL,
  `color_r1` tinyint(1) NOT NULL,
  `color_g1` tinyint(1) NOT NULL,
  `color_b1` tinyint(1) NOT NULL,
  `color_r2` tinyint(1) NOT NULL,
  `color_g2` tinyint(1) NOT NULL,
  `color_b2` tinyint(1) NOT NULL,
  `neon_r` tinyint(1) NOT NULL,
  `neon_g` tinyint(1) NOT NULL,
  `neon_b` tinyint(1) NOT NULL,
  `numberPlate` varchar(8) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexes for table `accounts`
--
ALTER TABLE `accounts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_7D3656A492FC23A8` (`username_canonical`),
  ADD UNIQUE KEY `UNIQ_7D3656A4A0D96FBF` (`email_canonical`),
  ADD UNIQUE KEY `UNIQ_7D3656A4C05FB297` (`confirmation_token`),
  ADD UNIQUE KEY `UNIQ_7D3656A41136BE75` (`character_id`);

--
-- Indexes for table `action_history`
--
ALTER TABLE `action_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_FD18F8AA9B6B5FBA` (`account_id`);

--
-- Indexes for table `characters`
--
ALTER TABLE `characters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `character_face_features`
--
ALTER TABLE `character_face_features`
  ADD UNIQUE KEY `player` (`character_id`,`offset`);

--
-- Indexes for table `character_head_overlays`
--
ALTER TABLE `character_head_overlays`
  ADD UNIQUE KEY `player` (`character_id`,`offset`);

--
-- Indexes for table `vehicles`
--
ALTER TABLE `vehicles`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accounts`
--
ALTER TABLE `accounts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `action_history`
--
ALTER TABLE `action_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2236;
--
-- AUTO_INCREMENT for table `characters`
--
ALTER TABLE `characters`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `vehicles`
--
ALTER TABLE `vehicles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `accounts`
--
ALTER TABLE `accounts`
  ADD CONSTRAINT `FK_7D3656A41136BE75` FOREIGN KEY (`character_id`) REFERENCES `characters` (`id`);

--
-- Constraints for table `action_history`
--
ALTER TABLE `action_history`
  ADD CONSTRAINT `FK_FD18F8AA9B6B5FBA` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`);

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