-- MySQL dump 9.11
--
-- Host: localhost    Database: pb
-- ------------------------------------------------------
-- Server version	4.0.22

--
-- Table structure for table `access`
--

CREATE TABLE access (
  I_UserID mediumint(8) unsigned NOT NULL default '0',
  D_Create datetime NOT NULL default '0000-00-00 00:00:00',
  I_AddedBy mediumint(8) unsigned NOT NULL default '0',
  I_AddPost tinyint(1) default '0',
  I_DeletePost tinyint(1) default '0',
  I_EditPost tinyint(1) default '0',
  I_AddAccess tinyint(1) default '0',
  I_AddLeague tinyint(1) default '0',
  I_DeleteLeague tinyint(1) default '0',
  I_EditLeague tinyint(1) default '0',
  I_LeagueID tinyint(3) unsigned NOT NULL default '0',
  I_Rater tinyint(3) unsigned default NULL,
  I_AddSchedule tinyint(1) default NULL,
  I_ModifySchedule tinyint(1) default NULL,
  I_DeleteSchedule tinyint(1) default NULL,
  I_ViewRating tinyint(3) unsigned default '0',
  I_EditTeam tinyint(3) unsigned default '0',
  KEY I_UserID (I_UserID),
  KEY I_AddedBy (I_AddedBy)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `alias`
--

CREATE TABLE alias (
  I_AliasID mediumint(8) unsigned NOT NULL auto_increment,
  I_UserID mediumint(8) unsigned NOT NULL default '0',
  D_Create datetime NOT NULL default '0000-00-00 00:00:00',
  C_Alias varchar(30) NOT NULL default '',
  C_Password varchar(20) default NULL,
  D_Modify timestamp(14) NOT NULL,
  PRIMARY KEY  (I_AliasID),
  KEY I_UserID (I_UserID),
  KEY C_Alias (C_Alias(10))
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `bb`
--

CREATE TABLE bb (
  I_AliasID mediumint(8) unsigned NOT NULL default '0',
  I_IP int(10) unsigned NOT NULL default '0',
  I_MID int(11) NOT NULL default '0',
  D_Last timestamp(14) NOT NULL,
  I_Logins mediumint(8) unsigned NOT NULL default '1',
  PRIMARY KEY  (I_AliasID,I_IP,I_MID),
  KEY I_AliasID (I_AliasID),
  KEY I_IP (I_IP),
  KEY I_MID (I_MID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `diepoled_data`
--

CREATE TABLE diepoled_data (
  I_UserID mediumint(8) unsigned NOT NULL default '0',
  vote mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (I_UserID)
) TYPE=MyISAM;

--
-- Table structure for table `diepoled_sort`
--

CREATE TABLE diepoled_sort (
  vote_option char(255) default NULL,
  votes mediumint(8) unsigned NOT NULL default '0'
) TYPE=MyISAM;

--
-- Table structure for table `division`
--

CREATE TABLE division (
  I_DivisionID smallint(5) unsigned NOT NULL auto_increment,
  I_SeasonID smallint(5) unsigned NOT NULL default '0',
  I_LeagueID tinyint(3) unsigned NOT NULL default '0',
  C_Division varchar(30) default NULL,
  PRIMARY KEY  (I_DivisionID),
  KEY I_SeasonID (I_SeasonID),
  KEY I_LeagueID (I_LeagueID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `game`
--

CREATE TABLE game (
  I_GameID mediumint(8) unsigned NOT NULL auto_increment,
  I_SegmentID smallint(5) unsigned NOT NULL default '0',
  D_Schedule datetime default NULL,
  I_HomeTeamID smallint(5) unsigned NOT NULL default '0',
  I_VisitorTeamID smallint(5) unsigned NOT NULL default '0',
  I_Overtime tinyint(1) default NULL,
  D_Duration time default '00:00:00',
  C_Location varchar(50) default NULL,
  I_RefID mediumint(8) unsigned default NULL,
  E_Result enum('Forfeit','Reschedule','Error','Complete','Draw') default NULL,
  C_Log text,
  C_Comment varchar(255) default NULL,
  I_Round tinyint(3) unsigned NOT NULL default '0',
  I_WinnerID smallint(5) unsigned default NULL,
  I_SeriesOrder tinyint(3) unsigned default '1',
  D_Start datetime default NULL,
  C_Logfile varchar(100) default NULL,
  I_MinPlayers tinyint(3) unsigned NOT NULL default '0',
  I_MaxPlayers tinyint(3) unsigned NOT NULL default '0',
  I_AvgPlayers tinyint(3) unsigned NOT NULL default '0',
  C_SSVCR varchar(255) default NULL,
  PRIMARY KEY  (I_GameID),
  KEY I_HomeTeamID (I_HomeTeamID),
  KEY I_VisitorTeamID (I_VisitorTeamID),
  KEY I_WinnerID (I_WinnerID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `game_stats`
--

CREATE TABLE game_stats (
  I_StatsID int(10) unsigned NOT NULL auto_increment,
  I_GameID mediumint(8) unsigned NOT NULL default '0',
  I_AliasID mediumint(8) unsigned NOT NULL default '0',
  I_TeamID smallint(5) unsigned NOT NULL default '0',
  I_Rating smallint(6) unsigned NOT NULL default '0',
  I_Goals tinyint(3) unsigned NOT NULL default '0',
  I_Assists tinyint(3) unsigned NOT NULL default '0',
  I_Kills tinyint(3) unsigned NOT NULL default '0',
  I_TeamKills tinyint(3) unsigned NOT NULL default '0',
  I_BallKills tinyint(3) unsigned NOT NULL default '0',
  I_FarKills tinyint(3) unsigned NOT NULL default '0',
  I_Deaths tinyint(3) unsigned NOT NULL default '0',
  I_BallDeaths tinyint(3) unsigned NOT NULL default '0',
  I_Saves tinyint(3) unsigned NOT NULL default '0',
  I_SaveAssists tinyint(3) unsigned default '0',
  I_Chokes tinyint(3) unsigned NOT NULL default '0',
  I_Steals tinyint(3) unsigned NOT NULL default '0',
  I_Pickups tinyint(3) unsigned NOT NULL default '0',
  I_Turnovers tinyint(3) unsigned NOT NULL default '0',
  I_Punts tinyint(3) unsigned NOT NULL default '0',
  I_Spawns tinyint(3) unsigned NOT NULL default '0',
  I_Carries tinyint(3) unsigned NOT NULL default '0',
  I_BallTime smallint(5) unsigned default '0',
  I_NearTime smallint(5) unsigned default '0',
  I_PlayingTime smallint(5) unsigned NOT NULL default '0',
  I_Drops smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (I_StatsID),
  KEY I_AliasID (I_AliasID),
  KEY I_TeamID (I_TeamID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `game_status`
--

CREATE TABLE game_status (
  C_Map varchar(25) NOT NULL default '',
  I_BirdScore tinyint(3) unsigned NOT NULL default '0',
  I_JavScore tinyint(3) unsigned NOT NULL default '0',
  D_Duration time NOT NULL default '00:00:00',
  C_Specs text,
  C_Birds text,
  C_Javs text
) TYPE=MyISAM;

--
-- Table structure for table `league`
--

CREATE TABLE league (
  I_LeagueID tinyint(3) unsigned NOT NULL auto_increment,
  C_League varchar(30) NOT NULL default '',
  I_Season tinyint(3) unsigned NOT NULL default '0',
  I_Loss_Pts tinyint(3) unsigned NOT NULL default '0',
  I_Win_Pts tinyint(3) unsigned NOT NULL default '0',
  I_Draw_Pts tinyint(3) unsigned NOT NULL default '0',
  I_OT_Win_Pts tinyint(3) unsigned NOT NULL default '0',
  I_OT_Loss_Pts tinyint(3) unsigned NOT NULL default '0',
  I_Forfeit_Win_Pts tinyint(3) unsigned NOT NULL default '0',
  I_Forfeit_Loss_Pts tinyint(3) unsigned NOT NULL default '0',
  I_Active tinyint(1) NOT NULL default '0',
  C_Web_Link varchar(100) default NULL,
  C_BBS_Link varchar(100) default NULL,
  D_RosterLock datetime NOT NULL default '0000-00-00 00:00:00',
  I_Salaries tinyint(1) NOT NULL default '0',
  I_SalaryCap int(10) unsigned default '0',
  I_SalaryNumPilots tinyint(3) unsigned default '0',
  D_LockSignup datetime default NULL,
  I_MaxRoster tinyint(3) unsigned default '0',
  PRIMARY KEY  (I_LeagueID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `message`
--

CREATE TABLE message (
  I_MessageID smallint(5) unsigned NOT NULL auto_increment,
  I_UserID mediumint(8) unsigned NOT NULL default '0',
  D_Create datetime default NULL,
  C_Title varchar(50) default NULL,
  C_Message text,
  I_MessageTypeID tinyint(3) unsigned NOT NULL default '0',
  D_Expire datetime default NULL,
  I_Priority tinyint(3) unsigned default '1',
  PRIMARY KEY  (I_MessageID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `message_type`
--

CREATE TABLE message_type (
  I_MessageTypeID tinyint(3) unsigned NOT NULL auto_increment,
  C_MessageType varchar(50) default NULL,
  PRIMARY KEY  (I_MessageTypeID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `mod_league_link`
--

CREATE TABLE mod_league_link (
  I_UserID mediumint(8) unsigned NOT NULL default '0',
  I_SeasonID smallint(5) unsigned NOT NULL default '0',
  I_TypeID tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (I_UserID,I_SeasonID,I_TypeID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `mod_type`
--

CREATE TABLE mod_type (
  I_TypeID tinyint(3) unsigned NOT NULL auto_increment,
  C_Type varchar(20) default NULL,
  KEY I_TypeID (I_TypeID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `mvp`
--

CREATE TABLE mvp (
  I_GameID mediumint(8) unsigned NOT NULL default '0',
  I_UserID mediumint(8) unsigned NOT NULL default '0'
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `offer`
--

CREATE TABLE offer (
  I_OfferID mediumint(8) unsigned NOT NULL auto_increment,
  I_UserID mediumint(8) unsigned NOT NULL default '0',
  I_TeamID smallint(5) unsigned NOT NULL default '0',
  D_Request datetime NOT NULL default '0000-00-00 00:00:00',
  D_Response datetime default NULL,
  C_Request varchar(255) default NULL,
  C_Response varchar(255) default NULL,
  E_Response enum('Accepted','Cancelled','Declined') default NULL,
  PRIMARY KEY  (I_OfferID),
  KEY I_UserID (I_UserID),
  KEY I_TeamID (I_TeamID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `poll`
--

CREATE TABLE poll (
  I_PollID smallint(5) unsigned NOT NULL auto_increment,
  I_AdminID mediumint(8) unsigned NOT NULL default '0',
  C_Topic varchar(255) default NULL,
  D_Create timestamp(14) NOT NULL,
  D_Close timestamp(14) NOT NULL default '00000000000000',
  I_PrivateResults tinyint(1) default '0',
  PRIMARY KEY  (I_PollID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `poll_option`
--

CREATE TABLE poll_option (
  I_OptionID mediumint(8) unsigned NOT NULL auto_increment,
  I_QuestionID mediumint(8) unsigned NOT NULL default '0',
  C_Option varchar(255) default NULL,
  PRIMARY KEY  (I_OptionID),
  KEY I_QuestionID (I_QuestionID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `poll_question`
--

CREATE TABLE poll_question (
  I_QuestionID mediumint(8) unsigned NOT NULL auto_increment,
  I_PollID smallint(5) unsigned NOT NULL default '0',
  C_Question varchar(255) default NULL,
  C_Notes text,
  PRIMARY KEY  (I_QuestionID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `poll_vote`
--

CREATE TABLE poll_vote (
  I_UserID mediumint(8) unsigned NOT NULL default '0',
  I_OptionID mediumint(8) unsigned NOT NULL default '0',
  D_Create timestamp(14) NOT NULL,
  I_QuestionID mediumint(8) unsigned NOT NULL default '0',
  KEY I_UserID (I_UserID),
  KEY I_OptionID (I_OptionID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `post`
--

CREATE TABLE post (
  I_PostID int(10) unsigned NOT NULL auto_increment,
  I_UserID mediumint(8) unsigned NOT NULL default '0',
  D_Create datetime NOT NULL default '0000-00-00 00:00:00',
  I_ParentID int(10) unsigned NOT NULL default '0',
  C_Title varchar(100) default NULL,
  C_Post text,
  I_Views smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (I_PostID),
  KEY I_UserID (I_UserID),
  KEY I_ParentID (I_ParentID),
  FULLTEXT KEY C_Title (C_Title,C_Post)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `rating`
--

CREATE TABLE rating (
  I_RaterID mediumint(8) unsigned NOT NULL default '0',
  I_UserID mediumint(8) unsigned NOT NULL default '0',
  old_raterID mediumint(8) unsigned NOT NULL default '0',
  old_userID mediumint(8) unsigned NOT NULL default '0',
  D_Create timestamp(14) NOT NULL,
  I_SeasonID smallint(5) unsigned NOT NULL default '0',
  I_LeagueID tinyint(3) unsigned NOT NULL default '0',
  I_Rating float unsigned default '0',
  C_Comment varchar(255) default NULL,
  KEY I_RaterID (I_RaterID),
  KEY I_SeasonID (I_SeasonID),
  KEY I_LeagueID (I_LeagueID),
  KEY I_UserID (I_UserID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `season`
--

CREATE TABLE season (
  I_SeasonID smallint(5) unsigned NOT NULL auto_increment,
  I_LeagueID tinyint(3) unsigned NOT NULL default '0',
  I_Season tinyint(3) unsigned NOT NULL default '0',
  I_Loss_Pts tinyint(3) unsigned NOT NULL default '0',
  I_Win_Pts tinyint(3) unsigned NOT NULL default '0',
  I_Draw_Pts tinyint(3) unsigned NOT NULL default '0',
  I_OT_Win_Pts tinyint(3) unsigned NOT NULL default '0',
  I_OT_Loss_Pts tinyint(3) unsigned NOT NULL default '0',
  I_Forfeit_Win_Pts tinyint(3) unsigned NOT NULL default '0',
  I_Forfeit_Loss_Pts tinyint(3) unsigned NOT NULL default '0',
  I_Active tinyint(1) NOT NULL default '0',
  C_Web_Link varchar(100) default NULL,
  C_BBS_Link varchar(100) default NULL,
  PRIMARY KEY  (I_SeasonID,I_LeagueID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `segment`
--

CREATE TABLE segment (
  I_SegmentID smallint(5) unsigned NOT NULL auto_increment,
  I_SeasonID smallint(5) unsigned NOT NULL default '0',
  I_LeagueID tinyint(3) unsigned NOT NULL default '0',
  I_Rounds tinyint(3) unsigned NOT NULL default '0',
  D_Start datetime NOT NULL default '0000-00-00 00:00:00',
  C_Segment varchar(30) default NULL,
  I_SeriesGames tinyint(3) unsigned NOT NULL default '1',
  PRIMARY KEY  (I_SegmentID),
  KEY I_SeasonID (I_SeasonID),
  KEY I_LeagueID (I_LeagueID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `stat_info`
--

CREATE TABLE stat_info (
  I_StatInfoID tinyint(3) unsigned NOT NULL auto_increment,
  C_Column varchar(100) default NULL,
  C_Label varchar(30) default NULL,
  C_Description varchar(255) default NULL,
  E_Grouping enum('Scoring','Ball Handling','Combat') default NULL,
  I_GroupOrder tinyint(3) unsigned NOT NULL default '0',
  C_Abbrev varchar(5) default NULL,
  PRIMARY KEY  (I_StatInfoID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `tblPballMatch`
--

CREATE TABLE tblPballMatch (
  fnRound int(11) NOT NULL default '0',
  fcUserName varchar(40) NOT NULL default '',
  fnUserId int(11) NOT NULL default '0',
  fnRating int(11) NOT NULL default '0',
  fnGoals int(11) NOT NULL default '0',
  fnAssists int(11) NOT NULL default '0',
  fnKills int(11) NOT NULL default '0',
  fnDeaths int(11) NOT NULL default '0',
  fnSteals int(11) NOT NULL default '0',
  fnTOs int(11) NOT NULL default '0',
  fnBC int(11) NOT NULL default '0',
  fnNB int(11) NOT NULL default '0',
  fnRPM float(10,0) NOT NULL default '0',
  fnMinutes int(11) NOT NULL default '0',
  fnGameLength int(11) NOT NULL default '0',
  fnLeague int(11) NOT NULL default '0',
  ftGameDate timestamp(14) NOT NULL
) TYPE=MyISAM;

--
-- Table structure for table `team`
--

CREATE TABLE team (
  I_TeamID smallint(5) unsigned NOT NULL auto_increment,
  I_CaptainID mediumint(8) unsigned NOT NULL default '0',
  D_Create datetime NOT NULL default '0000-00-00 00:00:00',
  C_Team varchar(50) default NULL,
  C_Description text,
  C_Image varchar(100) default NULL,
  C_Link varchar(100) default NULL,
  C_Banner varchar(100) default NULL,
  PRIMARY KEY  (I_TeamID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `team_division_link`
--

CREATE TABLE team_division_link (
  I_TeamID smallint(5) unsigned NOT NULL default '0',
  I_DivisionID smallint(5) unsigned NOT NULL default '0',
  KEY I_TeamID (I_TeamID),
  KEY I_DivisionID (I_DivisionID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `team_game_link`
--

CREATE TABLE team_game_link (
  I_GameID mediumint(8) unsigned NOT NULL default '0',
  I_TeamID smallint(5) unsigned NOT NULL default '0',
  I_Home tinyint(1) default '0',
  E_Ship enum('Warbird','Javelin') default NULL,
  I_Score smallint(5) unsigned default '0',
  I_Forfeit tinyint(1) default '0',
  KEY I_GameID (I_GameID),
  KEY I_TeamID (I_TeamID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `team_league_link`
--

CREATE TABLE team_league_link (
  I_TeamID smallint(5) unsigned NOT NULL default '0',
  I_LeagueID smallint(5) unsigned NOT NULL default '0',
  C_Division varchar(100) default NULL,
  KEY I_TeamID (I_TeamID),
  KEY I_LeagueID (I_LeagueID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `team_user_link`
--

CREATE TABLE team_user_link (
  I_TeamID smallint(5) unsigned NOT NULL default '0',
  I_UserID mediumint(8) unsigned NOT NULL default '0',
  I_OfferID mediumint(8) unsigned NOT NULL default '0',
  D_Signed datetime NOT NULL default '0000-00-00 00:00:00',
  D_Released datetime default NULL,
  E_Status enum('Active','Released','Resigned') default NULL,
  I_LeagueID tinyint(3) unsigned NOT NULL default '0',
  I_AliasID mediumint(8) unsigned NOT NULL default '0',
  I_Seniority tinyint(3) unsigned NOT NULL default '1',
  KEY I_TeamID (I_TeamID),
  KEY I_UserID (I_UserID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `user`
--

CREATE TABLE user (
  I_UserID mediumint(8) unsigned NOT NULL auto_increment,
  D_Create datetime NOT NULL default '0000-00-00 00:00:00',
  D_Last timestamp(14) NOT NULL,
  C_Email varchar(50) NOT NULL default '',
  C_Password varchar(20) NOT NULL default '',
  C_IP varchar(15) NOT NULL default '',
  C_Image varchar(100) default 'http://league.powerballzone.com/images/user_default.jpg',
  C_Link varchar(100) default NULL,
  C_Hometown varchar(20) default NULL,
  I_Age tinyint(3) unsigned default NULL,
  C_Occupation varchar(20) default NULL,
  C_Name varchar(20) default NULL,
  C_Notes text,
  C_PrimaryAlias varchar(30) NOT NULL default '',
  C_Avatar varchar(100) default NULL,
  C_Signature varchar(255) default NULL,
  I_ForumAliasID mediumint(8) unsigned default NULL,
  I_SendEmail tinyint(3) unsigned NOT NULL default '1',
  I_ValidEmail tinyint(3) unsigned NOT NULL default '1',
  I_ImageHeight smallint(5) unsigned default NULL,
  I_ImageWidth smallint(5) unsigned default NULL,
  PRIMARY KEY  (I_UserID),
  KEY C_Email (C_Email(10)),
  KEY C_PrimaryAlias (C_PrimaryAlias(10))
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `user_league_link`
--

CREATE TABLE user_league_link (
  I_UserID mediumint(8) unsigned NOT NULL default '0',
  I_LeagueID tinyint(3) unsigned NOT NULL default '0',
  D_Create datetime NOT NULL default '0000-00-00 00:00:00',
  I_Rating float unsigned default NULL,
  I_Ref tinyint(1) default '0',
  I_Captain tinyint(1) default '0',
  I_Rater tinyint(1) NOT NULL default '0',
  I_Salary int(10) unsigned default '0',
  C_Comment varchar(255) default NULL,
  I_Attendance tinyint(3) unsigned NOT NULL default '0',
  I_DraftPosition smallint(5) unsigned default '0',
  I_StageTaken tinyint(3) unsigned default '0',
  KEY I_UserID (I_UserID),
  KEY I_LeagueID (I_LeagueID)
) TYPE=MyISAM PACK_KEYS=1;

--
-- Table structure for table `user_prefs`
--

CREATE TABLE user_prefs (
  I_UserID mediumint(8) unsigned NOT NULL default '0',
  I_StatDisplayPrefID smallint(5) unsigned NOT NULL default '0'
) TYPE=MyISAM PACK_KEYS=1;