Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- jos_jcomments structure:
- Table Create Table
- v9465_jcomments CREATE TABLE `v9465_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',
- `deleted` int(11) NOT NULL,
- `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=4143 DEFAULT CHARSET=utf8
- v9465_jcomments_votes
- Table Create Table
- v9465_jcomments_votes CREATE TABLE `v9465_jcomments_votes` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `commentid` int(11) unsigned NOT NULL DEFAULT '0',
- `userid` int(11) unsigned NOT NULL DEFAULT '0',
- `ip` varchar(15) NOT NULL DEFAULT '',
- `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `value` tinyint(1) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `idx_comment` (`commentid`,`userid`)
- ) ENGINE=MyISAM AUTO_INCREMENT=13237 DEFAULT CHARSET=utf8
Add Comment
Please, Sign In to add comment