Code: Select all
$sql = "CREATE TABLE jos_".$this->league."_standings".$this->season." (
Team tinyint(3) NOT NULL,
TeamFull varchar(20) NOT NULL,
GP tinyint(4) NOT NULL,
WIN tinyint(4) NOT NULL,
LOSS tinyint(4) NOT NULL,
TIE tinyint(4) NOT NULL,
RF smallint(6) NOT NULL,
RA smallint(6) NOT NULL,
WP decimal(3,3) NOT NULL,
FORF tinyint(4) NOT NULL,
RAIN tinyint(4) NOT NULL,
DARK tinyint(4) NOT NULL,
CANC tinyint(4) NOT NULL,
STREAK varchar(3) NOT NULL,
PRIMARY KEY (Team)
) ENGINE=InnoDB DEFAULT CHARSET=utf8";