-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.51b-community-nt


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

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema tcp
--

CREATE DATABASE IF NOT EXISTS tcp;
USE tcp;

--
-- Definition of table `accesskeys`
--

DROP TABLE IF EXISTS `accesskeys`;
CREATE TABLE `accesskeys` (
  `key_id` int(10) unsigned NOT NULL auto_increment,
  `account_key` varchar(45) NOT NULL,
  `account_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`key_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accesskeys`
--

/*!40000 ALTER TABLE `accesskeys` DISABLE KEYS */;
/*!40000 ALTER TABLE `accesskeys` ENABLE KEYS */;


--
-- Definition of table `accounts`
--

DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
  `account_id` int(10) unsigned NOT NULL auto_increment,
  `account_name` varchar(45) NOT NULL,
  `account_password` varchar(45) NOT NULL,
  `account_status` int(10) unsigned NOT NULL default '0',
  `account_betaflag` tinyint(1) NOT NULL default '0',
  `account_logincount` int(10) unsigned NOT NULL default '0',
  `account_sessionid` varchar(45) NOT NULL default '0',
  `account_lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `account_creationdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `account_emailaddress` varchar(45) NOT NULL,
  `account_firstname` varchar(45) NOT NULL,
  `account_lastname` varchar(45) NOT NULL,
  PRIMARY KEY  (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COMMENT='Accounts Table';

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

/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
INSERT INTO `accounts` (`account_id`,`account_name`,`account_password`,`account_status`,`account_betaflag`,`account_logincount`,`account_sessionid`,`account_lastlogin`,`account_creationdate`,`account_emailaddress`,`account_firstname`,`account_lastname`) VALUES 
 (5,'testname','testpassword',0,1,25,'Q13PgOIKWQ5M','2008-07-22 21:59:46','2008-07-08 14:52:53','Default@Default.com','Test','User'),
 (6,'Taneas','password',0,1,2,'R537pkrW5O3b','2008-07-10 15:17:49','2008-07-09 11:19:02','Taneas@ftw-studios.com','Jayson','Marion'),
 (7,'aaa','aaa',0,1,1275,'38CYihsDp43P','2008-11-11 10:27:54','2008-07-09 12:35:16','aaa@aaa.com','aaa','aaa'),
 (8,'bbb','bbb',0,1,31,'bY7d87BGw8q3','2008-08-01 14:16:01','2008-07-10 15:19:01','bbb@bbb.com','bbb','bbb'),
 (9,'banana','banana',6,0,0,'0','2008-07-29 09:39:13','2008-07-29 09:39:13','test@banana.com','testbanana','seriously');
/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;


--
-- Definition of table `characters`
--

DROP TABLE IF EXISTS `characters`;
CREATE TABLE `characters` (
  `object_id` mediumint(8) unsigned zerofill NOT NULL auto_increment,
  `account_id` int(10) unsigned NOT NULL default '0',
  `server_id` int(10) unsigned NOT NULL default '0',
  `firstname` varchar(45) NOT NULL default 'test',
  `surname` varchar(45) NOT NULL default 'test',
  `model` varchar(45) default 'human_male',
  `x` float(10,6) default '0.000000',
  `y` float(10,6) default '0.000000',
  `z` float(10,6) default '0.000000',
  PRIMARY KEY  USING BTREE (`object_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `characters`
--

/*!40000 ALTER TABLE `characters` DISABLE KEYS */;
INSERT INTO `characters` (`object_id`,`account_id`,`server_id`,`firstname`,`surname`,`model`,`x`,`y`,`z`) VALUES 
 (00000001,7,1,'TestFirst','TestLast','human_male',574.639709,138.788498,7462.021973),
 (00000002,7,1,'ggg','hhh','human_male',518.209778,116.100304,7898.317871),
 (00000003,8,1,'hhhy','yergr','human_male',20.000000,5.000000,20.000000);
/*!40000 ALTER TABLE `characters` ENABLE KEYS */;


--
-- Definition of table `servers`
--

DROP TABLE IF EXISTS `servers`;
CREATE TABLE `servers` (
  `server_id` int(10) unsigned NOT NULL auto_increment,
  `server_name` varchar(45) NOT NULL,
  `server_location` varchar(45) NOT NULL,
  `server_address` varchar(45) default NULL,
  `server_port` int(8) unsigned NOT NULL,
  `server_population` int(8) unsigned NOT NULL,
  `server_status` int(8) unsigned NOT NULL,
  PRIMARY KEY  (`server_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `servers`
--

/*!40000 ALTER TABLE `servers` DISABLE KEYS */;
INSERT INTO `servers` (`server_id`,`server_name`,`server_location`,`server_address`,`server_port`,`server_population`,`server_status`) VALUES 
 (1,'Test Server 1','Ontario','192.168.0.100',4278,10000,1),
 (2,'Test Server 2','Michigan','192.168.1.102',4278,5000,0),
 (3,'Test Server 3','Somewhere 3','192.168.1.103',4278,2500,2),
 (4,'Test Server 4','Somewhere 4','192.168.1.104',4278,1225,3);
/*!40000 ALTER TABLE `servers` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;