-- phpMyAdmin SQL Dump
-- version 2.11.8.1deb5+lenny3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 11, 2010 at 09:03 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6-1+lenny6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `calgon_testhun`
--

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

--
-- Table structure for table `Accounts`
--

CREATE TABLE IF NOT EXISTS `Accounts` (
  `UserID` int(3) NOT NULL auto_increment,
  `Username` text NOT NULL,
  `Password` text NOT NULL,
  `AdminLevel` int(2) NOT NULL,
  `Group` int(2) NOT NULL default '0',
  `LastPosX` float NOT NULL default '0',
  `LastPosY` float NOT NULL default '0',
  `LastPosZ` float NOT NULL default '0',
  `LastSkin` int(3) NOT NULL default '299',
  `LastInterior` int(3) NOT NULL default '0',
  `LastWorld` varchar(10) NOT NULL default '0',
  `Gender` varchar(1) NOT NULL default '0',
  `Tutorial` varchar(1) NOT NULL default '1',
  `BankMoney` int(12) NOT NULL default '15000',
  PRIMARY KEY  (`UserID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `Accounts`
--

INSERT INTO `Accounts` (`UserID`, `Username`, `Password`, `AdminLevel`, `Group`, `LastPosX`, `LastPosY`, `LastPosZ`, `LastSkin`, `LastInterior`, `LastWorld`, `Gender`, `Tutorial`, `BankMoney`) VALUES
(1, 'Phillip_Morris', 'shopping', 1, 0, 287.005, -90.8297, 1.42187, 299, 0, '0', '0', '0', 15000),
(2, 'Rex_Tucker', 'the0ne', 0, 0, 0, 0, 0, 299, 0, '0', '0', '1', 15000),
(3, 'Calvin_Harris', 'Lol1234', 0, 0, 0, 0, 0, 299, 0, '0', '0', '1', 15000);

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

--
-- Table structure for table `Bans`
--

CREATE TABLE IF NOT EXISTS `Bans` (
  `BanID` int(3) NOT NULL auto_increment,
  `BannedIP` text NOT NULL,
  `BannedName` text NOT NULL,
  `BanReason` text NOT NULL,
  `BanAddedOn` datetime NOT NULL,
  PRIMARY KEY  (`BanID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `Bans`
--

INSERT INTO `Bans` (`BanID`, `BannedIP`, `BannedName`, `BanReason`, `BanAddedOn`) VALUES
(1, '121.2.44.467', 'Sid_Jenkins', 'Excessive Weapon Hacking', '0000-00-00 00:00:00');

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

--
-- Table structure for table `LoginAttempts`
--

CREATE TABLE IF NOT EXISTS `LoginAttempts` (
  `AttemptID` int(2) NOT NULL auto_increment,
  `AttemptedUsername` varchar(24) NOT NULL,
  `AttemptedPassword` text NOT NULL,
  `AttemptStatus` int(1) NOT NULL default '0',
  PRIMARY KEY  (`AttemptID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `LoginAttempts`
--


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

--
-- Table structure for table `Positions`
--

CREATE TABLE IF NOT EXISTS `Positions` (
  `PositionID` int(3) NOT NULL auto_increment,
  `PositionName` text NOT NULL,
  `PositionX` float NOT NULL,
  `PositionY` float NOT NULL,
  `PositionZ` float NOT NULL,
  `PositionInterior` int(4) NOT NULL default '0',
  `PositionWorld` int(4) NOT NULL default '0',
  PRIMARY KEY  (`PositionID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `Positions`
--

INSERT INTO `Positions` (`PositionID`, `PositionName`, `PositionX`, `PositionY`, `PositionZ`, `PositionInterior`, `PositionWorld`) VALUES
(1, 'NoobSpawn', 738.84, -1417.67, 13.5234, 0, 0);

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

--
-- Table structure for table `Settings`
--

CREATE TABLE IF NOT EXISTS `Settings` (
  `DefaultSkin` int(3) NOT NULL default '299',
  `DefaultAdminLevel` int(2) NOT NULL default '0',
  `DefaultNewbieMoney` int(12) NOT NULL default '15000',
  `ClarificationRow` int(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Settings`
--

INSERT INTO `Settings` (`DefaultSkin`, `DefaultAdminLevel`, `DefaultNewbieMoney`, `ClarificationRow`) VALUES
(299, 0, 15000, 0);