Discuz! info: MySQL Query Error
User: 毛毛
Time: 2007-1-10 7:57pm
Script: /pet_install.php
SQL: CREATE TABLE IF NOT EXISTS `pet_item` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`itemname` varchar(15) NOT NULL default '',
`cname` varchar(30) NOT NULL default '',
`moretxt` mediumtext NOT NULL,
`selltag` tinyint(1) unsigned NOT NULL default '0',
`money` int(10) unsigned NOT NULL default '0',
`pic` varchar(100) NOT NULL,
`itemtype` tinyint(1) unsigned NOT NULL default '0',
`requirejob` smallint(4) unsigned NOT NULL default '0',
`requirelevel` mediumint(6) unsigned NOT NULL default '0',
`addnum` mediumint(6) unsigned NOT NULL default '0',
`droptag` tinyint(1) unsigned NOT NULL default '0',
`droplevel` smallint(6) unsigned NOT NULL default '0',
`droprange` tinyint(3) unsigned NOT NULL default '100',
`storagetag` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `itemname` (`itemname`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
Error: 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=gbk' at line 19
Errno.: 1064
Similar error report has beed dispatched to administrator before.
这个是怎么回事~~! |