Table structure for table `matchtypes`
--
CREATE TABLE `matchtypes` (
`matchtype_id` int(10) NOT NULL auto_increment,
`matchtype` varchar(40) NOT NULL default '',
`match_cat` varchar(40) NOT NULL default '',
`division` varchar(40) NOT NULL default '',
PRIMARY KEY (`matchtype_id`),
UNIQUE KEY `matchtype` (`matchtype`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;
--
-- Dumping data for table `matchtypes`
--
INSERT INTO `matchtypes` VALUES (1, 'Enter league name here', 'league', '');
-- --------------------------------------------------------
--
-- Table structure for table `news`
--
CREATE TABLE `news` (
`news_id` int(10) NOT NULL auto_increment,
`news_username` varchar(40) default NULL,
`news` text,
`news_title` varchar(50) NOT NULL default '',
`news_date` date NOT NULL default '0000-00-00',
`topic_image` varchar(20) NOT NULL default 'topic_news.gif',
`hyperlink_text1` varchar(255) default NULL,
`hyperlink_url1` varchar(255) default NULL,
`hyperlink_text2` varchar(255) default NULL,
`hyperlink_url2` varchar(255) default NULL,
`news_image` varchar(20) NOT NULL default 'none',
PRIMARY KEY (`news_id`)
) TYPE=MyISAM AUTO_INCREMENT=160 ;
--
-- Dumping data for table `news`
--
INSERT INTO `news` VALUES (158, 'admin', 'This is an example news post, please delete this post using the ''Delete'' option in the top right corner.\r\n\r\nAdd your own news posts via the administration screen.', 'Example News', '2005-05-12', 'club news2.gif', '', '', '', '', 'none');
-- --------------------------------------------------------
--
-- Table structure for table `player_of_match`
--
CREATE TABLE `player_of_match` (
`pom_id` int(10) NOT NULL auto_increment,
`username` varchar(50) NOT NULL default '',
`playername` varchar(50) NOT NULL default '',
`match_id` int(11) NOT NULL default '0',
PRIMARY KEY (`pom_id`)
) TYPE=MyISAM AUTO_INCREMENT=18 ;
--
-- Dumping data for table `player_of_match`
--
-- --------------------------------------------------------
--
-- Table structure for table `results`
--
CREATE TABLE `results` (
`results_id` int(10) NOT NULL auto_increment,
`match_id` int(10) NOT NULL default '0',
`playername` varchar(40) NOT NULL default '',
`goals` tinyint(4) NOT NULL default '0',
`position` varchar(20) NOT NULL default '',
`pom` int(11) NOT NULL default '0',
PRIMARY KEY (`results_id`)
) TYPE=MyISAM AUTO_INCREMENT=97 ;
--
-- Dumping data for table `results`
--
-- --------------------------------------------------------
--
-- Table structure for table `roles`
--
CREATE TABLE `roles` (
`role_id` tinyint(10) NOT NULL auto_increment,
`role_title` varchar(20) NOT NULL default '',
`role_order` int(10) NOT NULL default '0',
PRIMARY KEY (`role_id`)
) TYPE=MyISAM AUTO_INCREMENT=19 ;
--
-- Dumping data for table `roles`
--
INSERT INTO `roles` VALUES (1, 'Manager', 2);
INSERT INTO `roles` VALUES (3, 'Player', 6);
-- --------------------------------------------------------
--
-- Table structure for table `seasons`
--
CREATE TABLE `seasons` (
`season_id` int(10) NOT NULL auto_increment,
`season_name` varchar(20) NOT NULL default '',
`season_start` date NOT NULL default '0000-00-00',
`season_end` date NOT NULL default '0000-00-00',
PRIMARY KEY (`season_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;
--
-- Dumping data for table `seasons`
--
INSERT INTO `seasons` VALUES (2, '2004-2005', '2004-08-01', '2005-05-29');
-- --------------------------------------------------------
--
-- Table structure for table `teams`
--
CREATE TABLE `teams` (
`team_id` int(10) NOT NULL auto_increment,
`team_name` varchar(80) NOT NULL default '',
`division` varchar(80) NOT NULL default '',
`own_team` varchar(5) NOT NULL default 'no',
`league_name` varchar(80) NOT NULL default '',
`contact_name` varchar(40) NOT NULL default '',
`contact_role` varchar(30) NOT NULL default '',
`contact_name_2` varchar(30) NOT NULL default '',
`contact_role_2` varchar(30) NOT NULL default '',
`contact_name_3` varchar(30) NOT NULL default '',
`contact_role_3` varchar(30) NOT NULL default '',
`contact_email` varchar(50) NOT NULL default '',
`contact_email_2` varchar(50) NOT NULL default '',
`contact_email_3` varchar(50) NOT NULL default '',
`contact_tel` varchar(20) NOT NULL default '',
`contact_tel_2` varchar(20) NOT NULL default '',
`contact_tel_3` varchar(20) NOT NULL default '',
`contact_address` varchar(255) NOT NULL default '',
`ground_name` varchar(50) NOT NULL default '',
`home_strip` varchar(50) NOT NULL default '',
`away_strip` varchar(50) NOT NULL default '',
`points_total` int(11) NOT NULL default '0',
`goaldiff` int(11) NOT NULL default '0',
PRIMARY KEY (`team_id`)
) TYPE=MyISAM AUTO_INCREMENT=18 ;
--
-- Dumping data for table `teams`
--
INSERT INTO `teams` VALUES (1, 'Your Team Name', '', 'yes', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `topic`
--
CREATE TABLE `topic` (
`topic_id` int(10) NOT NULL auto_increment,
`topic_image` varchar(20) NOT NULL default '',
`topic_image_name` varchar(20) NOT NULL default '',
PRIMARY KEY (`topic_id`)
) TYPE=MyISAM AUTO_INCREMENT=28 ;
--
-- Dumping data for table `topic`
--
INSERT INTO `topic` VALUES (27, 'cup news.gif', 'Cup News');
INSERT INTO `topic` VALUES (26, 'player match 2.gif', 'Player Of The Match');
INSERT INTO `topic` VALUES (21, 'match_news.gif', 'Match News');
INSERT INTO `topic` VALUES (24, 'club news2.gif', 'Club News');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(10) NOT NULL auto_increment,
`username` varchar(40) default NULL,
`displayname` varchar(40) NOT NULL default '',
`nickname` varchar(20) NOT NULL default '',
`interests` text NOT NULL,
`yim` varchar(50) NOT NULL default '',
`joindate` varchar(20) NOT NULL default 'n/a',
`clubs` text NOT NULL,
`profile` text NOT NULL,
`password` varchar(50) default NULL,
`rights` int(10) NOT NULL default '0',
`regdate` varchar(20) default NULL,
`email` varchar(100) default NULL,
`msn` varchar(40) NOT NULL default '',
`icq` varchar(10) NOT NULL default '',
`aim` varchar(40) NOT NULL default '',
`tel` varchar(20) NOT NULL default '',
`position` varchar(20) NOT NULL default '',
`role` varchar(20) NOT NULL default '',
`age` int(3) default NULL,
`website` varchar(150) default NULL,
`location` varchar(150) default NULL,
`show_email` int(2) default '0',
`last_login` varchar(20) default NULL,
`avatar` varchar(30) NOT NULL default 'no_pic.gif',
`player` char(3) NOT NULL default '',
`selected` char(3) NOT NULL default 'no',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `displayname` (`displayname`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=124 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` VALUES (121, 'admin', 'admin', '', '', '', 'n/a', '', '', '21232f297a57a5a743894a0e4a801fc3', 5, '2005-05-12', '', '', '', '', '', '', 'Player', NULL, NULL, NULL, 0, 'Never', 'no_pic.gif', 'yes', 'no');