Próbowałem importować baze. To jest kawałek kodu który skopiowałem z pliku baza.sql. Kiedy inportuje cały plik tez jest problem.
Kod PHP:
CREATE TABLE `jos_banner` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) collate utf8_polish_ci NOT NULL,
`name` varchar(50) collate utf8_polish_ci NOT NULL,
`imptotal` int(11) NOT NULL default '0',
`impmade` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(100) collate utf8_polish_ci NOT NULL,
`clickurl` varchar(200) collate utf8_polish_ci NOT NULL,
`date` datetime default NULL,
`showBanner` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) collate utf8_polish_ci default NULL,
`custombannercode` text collate utf8_polish_ci,
PRIMARY KEY (`bid`),
KEY `viewbanner` (`showBanner`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=7;
i dostaje komunikat
MySQL zwrócił komunikat:
#1064 - Something is wrong in your syntax obok 'collate utf8_polish_ci NOT NULL,
`name` varchar(50) collate u' w linii 4