I have downloaded version 3 and when i run the sql statement in phpmyadmin, i get this error:
Error
SQL-query :
CREATE TABLE `manufacturers2` (
`manufacturers2_id` int( 11 ) NOT NULL auto_increment,
`manufacturers2_name` varchar( 32 ) NOT NULL default '',
`manufacturers2_image` varchar( 64 ) default NULL ,
`date_added` datetime default NULL ,
`last_modified` datetime default NULL ,
PRIMARY KEY ( `manufacturers2_id` ) ,
KEY `IDX_MANUFACTURERS2_NAME` ( `manufacturers2_name` )
)ENGINE = MyISAM DEFAULTCHARSET = latin1AUTO_INCREMENT = 21
MySQL said:
You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ' at line 9
What is wrong? the code i used was:
CREATE TABLE `manufacturers2` (
`manufacturers2_id` int(11) NOT NULL auto_increment,
`manufacturers2_name` varchar(32) NOT NULL default '',
`manufacturers2_image` varchar(64) default NULL,
`date_added` datetime default NULL,
`last_modified` datetime default NULL,
PRIMARY KEY (`manufacturers2_id`),
KEY `IDX_MANUFACTURERS2_NAME` (`manufacturers2_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
CREATE TABLE `manufacturers2_info` (
`manufacturers2_id` int(11) NOT NULL default '0',
`languages_id` int(11) NOT NULL default '0',
`manufacturers2_url` varchar(255) NOT NULL default '',
`url_clicked` int(5) NOT NULL default '0',
`date_last_click` datetime default NULL,
PRIMARY KEY (`manufacturers2_id`,`languages_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
ALTER TABLE `products` ADD `manufacturers2_id` int(11) default NULL