|
When I try and add
CREATE TABLE `rp_usergroups` (
`groupid` int(5) NOT NULL auto_increment,
`groupname` varchar(50) NOT NULL default '',
`cpaccess` smallint(3) NOT NULL default '0',
`uploads` smallint(3) NOT NULL default '1',
`reviews` smallint(3) NOT NULL default '1',
`uploadsize` int(10) default NULL,
`editpho` int(3) NOT NULL default '1',
`editposts` int(3) NOT NULL default '1',
`modaccess` smallint(3) NOT NULL default '0',
`reqmod` int(3) NOT NULL default '0',
`uplimit` int(3) NOT NULL default '0',
PRIMARY KEY (`groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=55 ;
I get this error:
SQL query:
CREATE TABLE `rp_usergroups` (
`groupid` int( 5 ) NOT NULL AUTO_INCREMENT ,
`groupname` varchar( 50 ) NOT NULL default '',
`cpaccess` smallint( 3 ) NOT NULL default '0',
`uploads` smallint( 3 ) NOT NULL default '1',
`reviews` smallint( 3 ) NOT NULL default '1',
`uploadsize` int( 10 ) default NULL ,
`editpho` int( 3 ) NOT NULL default '1',
`editposts` int( 3 ) NOT NULL default '1',
`modaccess` smallint( 3 ) NOT NULL default '0',
`reqmod` int( 3 ) NOT NULL default '0',
`uplimit` int( 3 ) NOT NULL default '0',
PRIMARY KEY ( `groupid` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =55
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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=55' at line 14
Any ideas?
|