This looks very promising

, I get an error when I run this query:
[sql]
DROP TABLE IF EXISTS `wt2_queries`;
CREATE TABLE `wt2_queries` (
`qid` int(10) unsigned NOT NULL auto_increment,
`qname` varchar(200) NOT NULL default '',
`qdescription` varchar(250) NOT NULL default '',
`query` mediumtext NOT NULL,
`affixcode` mediumtext NOT NULL,
`prefixcode` mediumtext NOT NULL,
`resultrow` mediumtext NOT NULL,
`noresultrow` mediumtext NOT NULL,
`qbbcodeparse` varchar(250) NOT NULL default '',
`qdateparse` varchar(250) NOT NULL default '',
`qtype` tinyint(2) unsigned NOT NULL default '1',
`qnumberparse` varchar(250) NOT NULL default '',
`qphpinclude` mediumtext NOT NULL,
PRIMARY KEY (`qid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
[/sql]
i get this error :
Code:
#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=10' at line 16