-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Sep 07, 2008 at 05:51 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6-3
-- 
-- Database: `teewars`
-- 

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

-- 
-- Table structure for table `teewars_party`
-- 

CREATE TABLE `teewars_party` (
  `id` int(8) NOT NULL auto_increment,
  `start` int(10) default NULL,
  `end` int(10) NOT NULL,
  `type` enum(' Capture The Flag',' Death Match',' Team Death Match') default NULL,
  `map` varchar(16) NOT NULL,
  `maxtime` int(8) NOT NULL,
  `winner` int(8) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=543 DEFAULT CHARSET=latin1 AUTO_INCREMENT=543 ;

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

-- 
-- Table structure for table `teewars_player`
-- 

CREATE TABLE `teewars_player` (
  `id` int(8) NOT NULL auto_increment,
  `name` varchar(32) NOT NULL,
  `points` int(8) default NULL,
  `deaths` int(4) NOT NULL,
  `ptime` double default NULL,
  `captures` int(8) NOT NULL,
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=1404 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1404 ;

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

-- 
-- Table structure for table `teewars_stats`
-- 

CREATE TABLE `teewars_stats` (
  `id` int(16) NOT NULL auto_increment,
  `party` int(8) NOT NULL,
  `user` int(8) NOT NULL,
  `team` int(1) NOT NULL,
  `points` int(8) default NULL,
  `deaths` int(8) default NULL,
  `ptime` int(4) NOT NULL,
  `captures` int(4) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3186 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3186 ;