DROP TABLE IF EXISTS `jos_jcomments`;
CREATE TABLE IF NOT EXISTS `jos_jcomments` (
`id` int(11) unsigned NOT NULL auto_increment,
`parent` int(11) unsigned NOT NULL default '0',
`object_id` int(11) unsigned NOT NULL default '0',
`object_group` varchar(255) NOT NULL default '',
`object_params` text NOT NULL,
`lang` varchar(255) NOT NULL default '',
`userid` int(11) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`username` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`homepage` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`comment` text NOT NULL,
`ip` varchar(15) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`isgood` smallint(5) unsigned NOT NULL default '0',
`ispoor` smallint(5) unsigned NOT NULL default '0',
`published` tinyint(1) unsigned NOT NULL default '0',
`subscribe` tinyint(1) unsigned NOT NULL default '0',
`source` varchar(255) NOT NULL default '',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `idx_userid` (`userid`),
KEY `idx_source` (`source`),
KEY `idx_email` (`email`),
KEY `idx_lang` (`lang`),
KEY `idx_subscribe` (`subscribe`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_object` (`object_id`,`object_group`,`published`,`date`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=15 ;