Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: mysql kode yra isivelus klaida paziurekit

Parašė weberiz· 2008 Rugp. 14 11:08:28
#1

va man tik pirma lenta susikure o kitos nesusikure nezinau delto jei galit padekit

$inf_newtable_[1] = "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;";

$inf_newtable_[2] = "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;";

$inf_newtable_[3] = "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;";

$inf_newtable_[4] = "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;";

$inf_newtable_[5] = "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;";