Database error

steno

Member
Feb 18, 2011
56
0
I keep getting database errors whenever i execute a sql query in navicat.

error code:
[SQL]
--
-- Table structure for table `achievements`
--

CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=40 ;
[Err] 1064 - You have an error in your SQL syntax near 'ENGINE=InnoDB DEFAULT CHARSET=cp1251 AUTO_INCREMENT=40 ' at line 15

If anyone could help via join.me or teamviewer that will be great
 

Users who are viewing this thread

Top