-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: 21-Fev-2016 às 01:40
-- Versão do servidor: 10.1.9-MariaDB
-- PHP Version: 5.5.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: `lnd`
--

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

--
-- Estrutura da tabela `achievements`
--

CREATE TABLE `achievements` (
  `Ach_ID` int(11) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `100Kills` int(11) NOT NULL,
  `500Kills` int(11) NOT NULL,
  `1000Kills` int(11) NOT NULL,
  `DoubleKill` int(11) NOT NULL,
  `TripleKill` int(11) NOT NULL,
  `3KS` int(11) NOT NULL,
  `24KS` int(11) NOT NULL,
  `EndKS` int(11) NOT NULL,
  `Piss` int(11) NOT NULL,
  `PissV` int(11) NOT NULL,
  `Shit` int(11) NOT NULL,
  `ShitV` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estrutura da tabela `aka`
--

CREATE TABLE `aka` (
  `Aka_ID` int(10) NOT NULL,
  `Ip` varchar(255) NOT NULL,
  `Names` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estrutura da tabela `bans`
--

CREATE TABLE `bans` (
  `Ban_ID` int(10) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Admin` varchar(255) NOT NULL,
  `IP` varchar(255) NOT NULL,
  `Reason` varchar(255) NOT NULL,
  `Day` int(10) NOT NULL,
  `Month` int(10) NOT NULL,
  `Year` int(10) NOT NULL,
  `Hour` int(10) NOT NULL,
  `Minute` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estrutura da tabela `inventory`
--

CREATE TABLE `inventory` (
  `Iventory_ID` int(11) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Slot1` int(11) NOT NULL,
  `Slot2` int(11) NOT NULL,
  `Slot3` int(11) NOT NULL,
  `HaveSlot` int(11) NOT NULL,
  `HaveExplosion` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estrutura da tabela `players`
--

CREATE TABLE `players` (
  `ID` int(10) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Password` varchar(255) NOT NULL,
  `PIP` varchar(255) NOT NULL,
  `AL` int(11) NOT NULL,
  `Admin` int(1) NOT NULL,
  `Level` int(3) NOT NULL,
  `Kills` int(10) NOT NULL,
  `Deaths` int(10) NOT NULL,
  `Ratio` float NOT NULL,
  `Weed` int(11) NOT NULL,
  `Exp` int(10) NOT NULL,
  `MExp` int(10) NOT NULL,
  `Banned` int(2) NOT NULL,
  `Skin` int(3) NOT NULL,
  `Color` varchar(255) NOT NULL,
  `Weather` int(10) NOT NULL,
  `Time` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estrutura da tabela `unbans`
--

CREATE TABLE `unbans` (
  `Unban_ID` int(11) NOT NULL,
  `Admin` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Day` int(2) NOT NULL,
  `Month` int(2) NOT NULL,
  `Year` int(4) NOT NULL,
  `Hour` int(2) NOT NULL,
  `Minute` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `achievements`
--
ALTER TABLE `achievements`
  ADD PRIMARY KEY (`Ach_ID`);

--
-- Indexes for table `aka`
--
ALTER TABLE `aka`
  ADD PRIMARY KEY (`Aka_ID`);

--
-- Indexes for table `bans`
--
ALTER TABLE `bans`
  ADD PRIMARY KEY (`Ban_ID`);

--
-- Indexes for table `inventory`
--
ALTER TABLE `inventory`
  ADD PRIMARY KEY (`Iventory_ID`);

--
-- Indexes for table `players`
--
ALTER TABLE `players`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `unbans`
--
ALTER TABLE `unbans`
  ADD PRIMARY KEY (`Unban_ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `achievements`
--
ALTER TABLE `achievements`
  MODIFY `Ach_ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `aka`
--
ALTER TABLE `aka`
  MODIFY `Aka_ID` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `bans`
--
ALTER TABLE `bans`
  MODIFY `Ban_ID` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `inventory`
--
ALTER TABLE `inventory`
  MODIFY `Iventory_ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `players`
--
ALTER TABLE `players`
  MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `unbans`
--
ALTER TABLE `unbans`
  MODIFY `Unban_ID` int(11) NOT NULL AUTO_INCREMENT;
/*!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 */;