Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: klausimas su mysql kviečiu nusimanančius apie mysql

Parašė weberiz· 2008 Rugp. 15 11:08:05
#1

va man problema man kaško nesukuria lenteles
va kodas:
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 ;


va koki meta error
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'


galetumete padieti i man baisiai pradejo nervoti :(:(