CREATE TABLE `articles` (
`id` int(11) NOT NULL auto_increment,
`category` varchar(100) collate latin1_general_ci NOT NULL default '',
`url` varchar(255) collate latin1_general_ci NOT NULL default '',
`title` varchar(255) collate latin1_general_ci NOT NULL default '',
`author` varchar(200) collate latin1_general_ci NOT NULL default '',
`description` text collate latin1_general_ci NOT NULL,
`articletext` longtext collate latin1_general_ci NOT NULL,
`source` varchar(100) collate latin1_general_ci NOT NULL default '',
`approved` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `url` (`url`),
KEY `category` (`category`),
KEY `ndx_approved` (`approved`),
FULLTEXT KEY `title` (`title`),
FULLTEXT KEY `articletext` (`articletext`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=176432 ;(