database.SQL

-- phpMyAdmin SQL Dump
-- version 4.1.12
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Oct 01, 2014 at 12:07 PM
-- Server version: 5.5.36
-- PHP Version: 5.4.27

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

--
-- Database: `admin-system`
--

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

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

CREATE TABLE IF NOT EXISTS `accounts` (
  `ID` INT(11) NOT NULL,
  `Password` VARCHAR(129) NOT NULL,
  `Username` VARCHAR(32) NOT NULL,
  `AdminLevel` INT(11) NOT NULL,
  `Warn` INT(11) NOT NULL,
  `KickCount` INT(11) NOT NULL,
  `Banned` INT(11) NOT NULL,
  `Level` INT(11) NOT NULL,
  `Premium` INT(11) NOT NULL,
  `Kills` INT(11) NOT NULL,
  `Deaths` INT(11) NOT NULL,
  `Registred` INT(11) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bans`
--

CREATE TABLE IF NOT EXISTS `bans` (
  `ID` INT(11) NOT NULL,
  `Player` VARCHAR(32) NOT NULL,
  `Admin` VARCHAR(32) NOT NULL,
  `Reason` VARCHAR(128) NOT NULL,
  `Time` datetime NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `logs`
--

CREATE TABLE IF NOT EXISTS `logs` (
  `Type` VARCHAR(24) NOT NULL,
  `Content` VARCHAR(256) NOT NULL,
  `Date` VARCHAR(24) NOT NULL,
  PRIMARY KEY (`Type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `warn`
--

CREATE TABLE IF NOT EXISTS `warn` (
  `ID` INT(11) NOT NULL,
  `Player` VARCHAR(32) NOT NULL,
  `Admin` VARCHAR(32) NOT NULL,
  `Content` VARCHAR(256) NOT NULL,
  PRIMARY KEY (`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 */;