# This file is part of The Droid's NCAA Tournament Pool.
# 
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
# 
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
# 
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
	
# phpMyAdmin SQL Dump
# version 2.5.4
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Apr 17, 2005 at 11:15 PM
# Server version: 4.1.7
# PHP Version: 5.0.2
# 
# Database : `ncaa05`
# 

# --------------------------------------------------------

#
# Table structure for table `Entries`
#

CREATE TABLE `Entries` (
  `EntryID` int(10) unsigned NOT NULL auto_increment,
  `UserID` int(10) unsigned NOT NULL default '0',
  `EntryName` varchar(200) NOT NULL default '',
  `Active` tinyint(3) unsigned NOT NULL default '1',
  `Score1` tinyint(3) unsigned default NULL,
  `Score2` tinyint(3) unsigned default NULL,
  `CurrentScore` mediumint(9) NOT NULL default '0',
  `CurrentRank` mediumint(8) unsigned default '0',
  `F4Picks` tinyint(3) unsigned NOT NULL default '0',
  `TotalPicks` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`EntryID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=232 ;

# --------------------------------------------------------

#
# Table structure for table `Games`
#

CREATE TABLE `Games` (
  `Round` tinyint(3) unsigned NOT NULL default '0',
  `Game` tinyint(3) unsigned NOT NULL default '0',
  `GameTime` datetime default NULL,
  `TeamID1` int(10) unsigned default NULL,
  `TeamID2` int(10) unsigned default NULL,
  `WinnerID` int(10) unsigned default NULL,
  `PointValue` smallint(5) unsigned default NULL,
  `Team1Score` tinyint(3) unsigned default NULL,
  `Team2Score` tinyint(3) unsigned default NULL,
  `TimeLeft` varchar(255) default NULL,
  PRIMARY KEY  (`Round`,`Game`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `History`
#

CREATE TABLE `History` (
  `EntryID` int(10) unsigned NOT NULL default '0',
  `ScoreDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `Score` mediumint(9) NOT NULL default '0',
  `Rank` mediumint(8) unsigned default '0',
  `DailyFinal` tinyint(3) unsigned NOT NULL default '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `Messages`
#

CREATE TABLE `Messages` (
  `MessageID` int(10) unsigned NOT NULL auto_increment,
  `ParentID` int(10) unsigned default NULL,
  `UserID` int(10) unsigned NOT NULL default '0',
  `PostDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `EditDate` datetime default NULL,
  `Subject` varchar(255) NOT NULL default '',
  `Body` mediumtext NOT NULL,
  `Deleted` tinyint(3) unsigned NOT NULL default '0',
  `Replies` int(10) unsigned NOT NULL default '0',
  `LastReply` datetime default NULL,
  `LastReplyBy` int(10) unsigned default NULL,
  PRIMARY KEY  (`MessageID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;

# --------------------------------------------------------

#
# Table structure for table `News`
#

CREATE TABLE `News` (
  `NewsID` int(10) unsigned NOT NULL auto_increment,
  `UserID` int(10) unsigned NOT NULL default '0',
  `PostDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `Subject` varchar(255) NOT NULL default '',
  `Body` mediumtext NOT NULL,
  `Deleted` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`NewsID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

# --------------------------------------------------------

#
# Table structure for table `Picks`
#

CREATE TABLE `Picks` (
  `EntryID` int(10) unsigned NOT NULL default '0',
  `Round` tinyint(3) unsigned NOT NULL default '0',
  `Game` tinyint(3) unsigned NOT NULL default '0',
  `WinningTeamID` int(10) unsigned default NULL,
  PRIMARY KEY  (`EntryID`,`Round`,`Game`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `Picks_flat`
#

CREATE TABLE `Picks_flat` (
  `EntryID` int(10) unsigned NOT NULL default '0',
  `1_0` int(10) unsigned default NULL,
  `1_1` int(10) unsigned default NULL,
  `1_2` int(10) unsigned default NULL,
  `1_3` int(10) unsigned default NULL,
  `1_4` int(10) unsigned default NULL,
  `1_5` int(10) unsigned default NULL,
  `1_6` int(10) unsigned default NULL,
  `1_7` int(10) unsigned default NULL,
  `1_8` int(10) unsigned default NULL,
  `1_9` int(10) unsigned default NULL,
  `1_10` int(10) unsigned default NULL,
  `1_11` int(10) unsigned default NULL,
  `1_12` int(10) unsigned default NULL,
  `1_13` int(10) unsigned default NULL,
  `1_14` int(10) unsigned default NULL,
  `1_15` int(10) unsigned default NULL,
  `1_16` int(10) unsigned default NULL,
  `1_17` int(10) unsigned default NULL,
  `1_18` int(10) unsigned default NULL,
  `1_19` int(10) unsigned default NULL,
  `1_20` int(10) unsigned default NULL,
  `1_21` int(10) unsigned default NULL,
  `1_22` int(10) unsigned default NULL,
  `1_23` int(10) unsigned default NULL,
  `1_24` int(10) unsigned default NULL,
  `1_25` int(10) unsigned default NULL,
  `1_26` int(10) unsigned default NULL,
  `1_27` int(10) unsigned default NULL,
  `1_28` int(10) unsigned default NULL,
  `1_29` int(10) unsigned default NULL,
  `1_30` int(10) unsigned default NULL,
  `1_31` int(10) unsigned default NULL,
  `2_0` int(10) unsigned default NULL,
  `2_1` int(10) unsigned default NULL,
  `2_2` int(10) unsigned default NULL,
  `2_3` int(10) unsigned default NULL,
  `2_4` int(10) unsigned default NULL,
  `2_5` int(10) unsigned default NULL,
  `2_6` int(10) unsigned default NULL,
  `2_7` int(10) unsigned default NULL,
  `2_8` int(10) unsigned default NULL,
  `2_9` int(10) unsigned default NULL,
  `2_10` int(10) unsigned default NULL,
  `2_11` int(10) unsigned default NULL,
  `2_12` int(10) unsigned default NULL,
  `2_13` int(10) unsigned default NULL,
  `2_14` int(10) unsigned default NULL,
  `2_15` int(10) unsigned default NULL,
  `3_0` int(10) unsigned default NULL,
  `3_1` int(10) unsigned default NULL,
  `3_2` int(10) unsigned default NULL,
  `3_3` int(10) unsigned default NULL,
  `3_4` int(10) unsigned default NULL,
  `3_5` int(10) unsigned default NULL,
  `3_6` int(10) unsigned default NULL,
  `3_7` int(10) unsigned default NULL,
  `4_0` int(10) unsigned default NULL,
  `4_1` int(10) unsigned default NULL,
  `4_2` int(10) unsigned default NULL,
  `4_3` int(10) unsigned default NULL,
  `5_0` int(10) unsigned default NULL,
  `5_1` int(10) unsigned default NULL,
  `6_0` int(10) unsigned default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `Regions`
#

CREATE TABLE `Regions` (
  `RegionID` int(10) unsigned NOT NULL auto_increment,
  `RegionName` varchar(100) NOT NULL default '',
  `Abbreviation` varchar(10) NOT NULL default '',
  `BracketLocation` enum('1','2','3','4') NOT NULL default '1',
  PRIMARY KEY  (`RegionID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

# --------------------------------------------------------

#
# Table structure for table `ReturningEmails`
#

CREATE TABLE `ReturningEmails` (
  `Email` varchar(255) NOT NULL default '',
  `Name` varchar(255) NOT NULL default '',
  `Sent` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# --------------------------------------------------------

#
# Table structure for table `Teams`
#

CREATE TABLE `Teams` (
  `TeamID` int(10) unsigned NOT NULL auto_increment,
  `RegionID` int(10) unsigned NOT NULL default '0',
  `Seed` tinyint(3) unsigned NOT NULL default '0',
  `Name` varchar(100) NOT NULL default '',
  `ShortName` varchar(100) default NULL,
  `TeamImage` varchar(200) default NULL,
  `Eliminated` date default NULL,
  `ValidNames` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`TeamID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=65 ;

# --------------------------------------------------------

#
# Table structure for table `Users`
#

CREATE TABLE `Users` (
  `UserID` int(10) unsigned NOT NULL auto_increment,
  `Email` varchar(200) NOT NULL default '',
  `Password` varchar(50) NOT NULL default '',
  `Referer` varchar(200) NOT NULL default '',
  `Admin` enum('Y','N') NOT NULL default 'N',
  `Name` varchar(200) NOT NULL default '',
  `Address` varchar(200) NOT NULL default '',
  `City` varchar(100) NOT NULL default '',
  `State` char(2) NOT NULL default '',
  `Zip` varchar(5) NOT NULL default '',
  `Phone` varchar(20) NOT NULL default '',
  `MoneyPaid` float unsigned NOT NULL default '0',
  `ActualMoneyPaid` float unsigned NOT NULL default '0',
  `Comments` varchar(255) default NULL,
  PRIMARY KEY  (`UserID`),
  UNIQUE KEY `Email` (`Email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=215 ;