CREATE TABLE IF NOT EXISTS `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_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 ;

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