GamerTDM SQL

-- phpMyAdmin SQL Dump
-- version 2.11.3deb1ubuntu1.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 28, 2015 at 02:46 PM
-- Server version: 5.0.96
-- PHP Version: 5.2.4-2ubuntu5.27

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `patrikocskaxd2015_server1`
--

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

--
-- Table structure for table `players`
--

CREATE TABLE IF NOT EXISTS `players` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `Username` VARCHAR(24) COLLATE latin1_general_ci NOT NULL,
  `Password` VARCHAR(129) COLLATE latin1_general_ci NOT NULL,
  `Admin` INT(11) NOT NULL DEFAULT '0',
  `VIP` INT(11) NOT NULL DEFAULT '0',
  `EXP` INT(11) NOT NULL DEFAULT '0',
  `Level` INT(11) NOT NULL DEFAULT '1',
  `Team` INT(11) NOT NULL DEFAULT '0',
  `Class` INT(11) NOT NULL DEFAULT '0',
  `Warn` INT(11) NOT NULL DEFAULT '0',
  `Mute` INT(11) NOT NULL DEFAULT '0',
  `IP` VARCHAR(23) COLLATE latin1_general_ci NOT NULL,
  `Banned` INT(11) NOT NULL DEFAULT '0',
  `FavSkin` BIGINT(20) NOT NULL DEFAULT '0',
  `Jailtime` INT(11) NOT NULL DEFAULT '0',
  `Kills` INT(11) NOT NULL DEFAULT '0',
  `Deaths` INT(11) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=128 ;