linccce

dumps

Jul 16th, 2014
279
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 2.04 KB | None | 0 0
  1. jos_jcomments structure:
  2. Table   Create Table
  3. v9465_jcomments CREATE TABLE `v9465_jcomments` (
  4.  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  5.  `parent` int(11) unsigned NOT NULL DEFAULT '0',
  6.  `object_id` int(11) unsigned NOT NULL DEFAULT '0',
  7.  `object_group` varchar(255) NOT NULL DEFAULT '',
  8.  `object_params` text NOT NULL,
  9.  `lang` varchar(255) NOT NULL DEFAULT '',
  10.  `userid` int(11) unsigned NOT NULL DEFAULT '0',
  11.  `name` varchar(255) NOT NULL DEFAULT '',
  12.  `username` varchar(255) NOT NULL DEFAULT '',
  13.  `email` varchar(255) NOT NULL DEFAULT '',
  14.  `homepage` varchar(255) NOT NULL DEFAULT '',
  15.  `title` varchar(255) NOT NULL DEFAULT '',
  16.  `comment` text NOT NULL,
  17.  `ip` varchar(15) NOT NULL DEFAULT '',
  18.  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  19.  `isgood` smallint(5) unsigned NOT NULL DEFAULT '0',
  20.  `ispoor` smallint(5) unsigned NOT NULL DEFAULT '0',
  21.  `published` tinyint(1) unsigned NOT NULL DEFAULT '0',
  22.  `deleted` int(11) NOT NULL,
  23.  `subscribe` tinyint(1) unsigned NOT NULL DEFAULT '0',
  24.  `source` varchar(255) NOT NULL DEFAULT '',
  25.  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  26.  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  27.  `editor` varchar(50) NOT NULL DEFAULT '',
  28.  PRIMARY KEY (`id`),
  29.  KEY `idx_userid` (`userid`),
  30.  KEY `idx_source` (`source`),
  31.  KEY `idx_email` (`email`),
  32.  KEY `idx_lang` (`lang`),
  33.  KEY `idx_subscribe` (`subscribe`),
  34.  KEY `idx_checkout` (`checked_out`),
  35.  KEY `idx_object` (`object_id`,`object_group`,`published`,`date`)
  36. ) ENGINE=MyISAM AUTO_INCREMENT=4143 DEFAULT CHARSET=utf8
  37.  
  38. v9465_jcomments_votes
  39. Table   Create Table
  40. v9465_jcomments_votes   CREATE TABLE `v9465_jcomments_votes` (
  41.  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  42.  `commentid` int(11) unsigned NOT NULL DEFAULT '0',
  43.  `userid` int(11) unsigned NOT NULL DEFAULT '0',
  44.  `ip` varchar(15) NOT NULL DEFAULT '',
  45.  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  46.  `value` tinyint(1) NOT NULL,
  47.  PRIMARY KEY (`id`),
  48.  KEY `idx_comment` (`commentid`,`userid`)
  49. ) ENGINE=MyISAM AUTO_INCREMENT=13237 DEFAULT CHARSET=utf8
Add Comment
Please, Sign In to add comment