NaviCat Error - [Err] 1064

Clit

Posting Freak
Feb 25, 2012
1,065
103
[Err] 1064 - You have an error in your SQL syntax near 'ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8'

Code:
DROP TABLE IF EXISTS `achievements`;
CREATE TABLE `achievements` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(100) NOT NULL DEFAULT '',
  `levels` int(11) NOT NULL DEFAULT '1',
  `dynamic_badgelevel` enum('0','1') NOT NULL DEFAULT '1',
  `badge` varchar(100) NOT NULL,
  `pixels_base` int(5) NOT NULL DEFAULT '50',
  `score_base` int(5) NOT NULL DEFAULT '10',
  `pixels_multiplier` double NOT NULL DEFAULT '1.25',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=cp1251;


This happens when I go to query build 13800 phoenix sql
 

Users who are viewing this thread

Top