$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;";

Error

SQL query:

CREATE TABLE IF NOT EXISTS `fs_teams` (
`team_id` smallint( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
`team_sport` tinyint( 5 ) COLLATE utf8_lithuanian_ci NOT NULL default '',
`team_name` varchar( 200 ) COLLATE utf8_lithuanian_ci NOT NULL default '',
PRIMARY KEY ( `team_id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_lithuanian_ci AUTO_INCREMENT =2

MySQL said: Documentation
#1067 - Invalid default value for 'team_sport'

gintaras4321 parašė:
padekit zmones ka cia nera specu kurie zino?