Error
SQL query:
--
-- Add a new field to existing table 'customers'
--
ALTER TABLE `customers` ADD `mmstatus` VARCHAR( 2 ) NOT NULL DEFAULT '0' AFTER `customers_newsletter` -- --------------------------------------------------------
--
-- Table structure for table `mm_bulkmail`
--
CREATE TABLE IF NOT EXISTS `mm_bulkmail` (
`bulkmail_id` int( 11 ) NOT NULL AUTO_INCREMENT ,`title` varchar( 255 ) NOT NULL ,
`htmlcontent` text NOT NULL ,
`txtcontent` text NOT NULL ,
`date_added` datetime NOT NULL ,
`date_sent` datetime DEFAULT NULL ,
PRIMARY KEY ( `bulkmail_id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `mm_bulkmail` (
`bulkmail_id` int(11) NOT NULL AUTO' at line 12
something needs fixing cant execute sql