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

Parašė weberiz· 2008 Rugp. 14 13:08:03
#8

ka reik pakeist jei gali pasakyt

as biski kitaip pabadziau sukurt ir mete si error

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'