Miscellany

CREATE TABLE `jos_sb_messages` (  `id` int(11) NOT NULL auto_increment,  `parent` int(11) default '0',  `thread` int(11) default '0',  `catid` int(11) NOT NULL default '0',  `name` tinytext,  `userid` int(11) NOT NULL default '0',  `email` tinytext,  `subject` tinytext,  `time` int(11) NOT NULL default '0',  `ip` varchar(15) default NULL,  `topic_emoticon` int(11) NOT NULL default '0',  `locked` tinyint(4) NOT NULL default '0',  `hold` tinyint(4) NOT NULL default '0',  `ordering` int(11) default '0',  `hits` int(11) default '0',  `moved` tinyint(4) default '0',  `message_type` tinyint(4) NOT NULL default '1',  `last_updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  PRIMARY KEY  (`id`),  KEY `thread` (`thread`),  KEY `ip` (`ip`),  KEY `time` (`time`,`hold`),  KEY `idx_subject` (`subject`(128)),  KEY `catid` (`catid`,`message_type`),  KEY `userid` (`userid`,`catid`,`parent`),  KEY `cat_par_msg_hld` (`catid`,`parent`,`message_type`,`hold`),  KEY `time_hold` (`time`,`hold`),  KEY `time_catid` (`time`,`catid`),  KEY `catid_messagetype` (`catid`,`message_type`),  KEY `userid_catid_parent` (`userid`,`catid`,`parent`),  KEY `parent` (`parent`,`catid`),  KEY `cat_parent_messagetype_hold` (`catid`,`parent`,`message_type`,`hold`),  KEY `time_2` (`catid`,`time`),  KEY `last_updated` (`last_updated`))