|
|
~\Desktop\prem2005\base schema.sql.html
SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
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 DATABASE /*!32312 IF NOT EXISTS*/ `premiership`;
USE `premiership`;
CREATE TABLE `dual` (
`dummy` char(1) NOT NULL default '',
PRIMARY KEY (`dummy`)
) TYPE=MyISAM;
INSERT INTO `dual` (`dummy`) VALUES ('x');
CREATE TABLE `fixtures` (
`id` int(10) unsigned NOT NULL auto_increment,
`home` int(10) unsigned NOT NULL default '0',
`visitor` int(10) unsigned NOT NULL default '0',
`date` date NOT NULL default '0000-00-00',
`competition` int(10) unsigned NOT NULL default '0',
`h_odds` float NOT NULL default '0',
`v_odss` float NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM ROW_FORMAT=DYNAMIC;
CREATE TABLE `results` (
`id` int(10) unsigned NOT NULL auto_increment,
`home` int(10) unsigned NOT NULL default '0',
`visitor` int(10) unsigned NOT NULL default '0',
`hscore` int(10) unsigned NOT NULL default '0',
`vscore` int(10) unsigned NOT NULL default '0',
`date` date NOT NULL default '0000-00-00',
`competition` int(10) unsigned NOT NULL default '0',
`hrank_new` int(11) default '0',
`vrank_new` int(11) default '0',
`wh_home` float default '2.209',
`wh_away` float default '3.563',
`hrank_old` int(10) unsigned default '0',
`vrank_old` int(10) unsigned default '0',
`game_rec` blob,
`game_meta` blob,
PRIMARY KEY (`id`)
) TYPE=MyISAM ROW_FORMAT=DYNAMIC;
CREATE TABLE `seasonrank` (
`team` int(10) unsigned NOT NULL auto_increment,
`season` int(10) unsigned NOT NULL default '0',
`rank` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`team`,`season`)
) TYPE=MyISAM;
CREATE TABLE `seasons` (
`id` int(10) unsigned NOT NULL auto_increment,
`start` date NOT NULL default '0000-00-00',
`end` date NOT NULL default '0000-00-00',
`text` varchar(11) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
INSERT INTO `seasons` (`id`,`start`,`end`,`text`) VALUES (1,'2005-08-01','2006-05-01','2005-2006'),(2,'2004-08-01','2005-05-30','2004-2005'),(3,'2002-08-01','2003-05-30','2002-2003'),(4,'2001-08-01','2002-05-30','2001-2002'),(5,'2000-08-01','2001-05-30','2000-2001'),(6,'1999-08-30','2000-05-30','1999-2000'),(7,'1998-08-01','1999-05-30','1998-1999'),(8,'1997-08-01','1998-05-30','1997-1998'),(9,'1996-08-01','1997-05-30','1996-1997'),(10,'1995-08-01','1996-05-30','1995-1996'),(11,'1994-08-01','1995-05-30','1994-1995'),(12,'1993-08-01','1994-05-30','1993-1995'),(13,'2003-08-01','2004-05-30','2003-2004');
CREATE TABLE `teams` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(45) NOT NULL default '',
`title` varchar(45) default NULL,
`rate` double NOT NULL default '1500',
`start_rate` int(10) unsigned NOT NULL default '1500',
`competition` int(10) unsigned NOT NULL default '0',
`alt_name` varchar(45) default NULL,
`first_match` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
CREATE TABLE `competitions` (
`id` int(10) unsigned NOT NULL auto_increment,
`tag` varchar(6) NOT NULL default '',
`title` varchar(45) NOT NULL default '',
`start_rank` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
INSERT INTO `competitions` (`id`,`tag`,`title`,`start_rank`) VALUES (1,'E0','Barclaycard Premiership',2100),(2,'FACUP','F.A. Cup',0),(3,'LC','League Cup',0),(4,'UEFA','UEFA Cup',0),(5,'CHAMPS','Champtions League',0),(6,'E1','Coca-Cola Championship',1700),(7,'E2','Coca-Cola League 1',1300),(8,'E3','Coca-Cola League 2',900);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT;
SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS;
SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|