Parašė Dandžu· 2008 Geg. 11 22:05:47
#6
Še.
CREATE TABLE fusion_fs_sports (
sport_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
sport_name VARCHAR(200) DEFAULT '' NOT NULL,
sport_icon VARCHAR(200) DEFAULT '' NOT NULL,
PRIMARY KEY (sport_id)
) TYPE=MyISAM;
CREATE TABLE fusion_fs_teams (
team_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
team_sport TINYINT(5) DEFAULT '' NOT NULL,
team_name VARCHAR(200) DEFAULT '' NOT NULL,
PRIMARY KEY (team_id)
) TYPE=MyISAM;
CREATE TABLE fusion_fs_games (
game_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
game_sport TINYINT(5) DEFAULT '' NOT NULL,
game_home TINYINT(5) DEFAULT '' NOT NULL,
game_guest TINYINT(5) DEFAULT '' NOT NULL,
game_winner TINYINT(5) DEFAULT '' NOT NULL,
game_time VARCHAR(200) DEFAULT '' NOT NULL,
PRIMARY KEY (game_id)
) TYPE=MyISAM;
CREATE TABLE fusion_fs_bets (
bet_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
bet_sport TINYINT(5) DEFAULT '' NOT NULL,
bet_game TINYINT(5) DEFAULT '' NOT NULL,
bet_user TINYINT(5) DEFAULT '' NOT NULL,
bet_bet TINYINT(5) DEFAULT '' NOT NULL,
PRIMARY KEY (bet_id)
) TYPE=MyISAM;
CREATE TABLE fusion_fs_jackpot (
jackpot_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
jackpot_game TINYINT(5) DEFAULT '' NOT NULL,
jackpot_jackpot TINYINT(5) DEFAULT '' NOT NULL,
PRIMARY KEY (jackpot_id)
) TYPE=MyISAM;