mysql> explain cnotes; +-----------+-----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-----------------+------+-----+---------+-------+ | caseid | int(7) unsigned | YES | MUL | NULL | | | catchnote | text | YES | MUL | NULL | | | headnote | text | YES | MUL | NULL | | | seqno | int(7) unsigned | YES | | 1 | | | ab | varchar(50) | YES | | NULL | | +-----------+-----------------+------+-----+---------+-------+ 5 rows in set (0.01 sec) mysql> explain glrcase; +-------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------------+------+-----+---------+----------------+ | caseid | int(7) unsigned | NO | PRI | NULL | auto_increment | | publication | varchar(9) | YES | MUL | NULL | | | pubyear | int(4) unsigned | YES | MUL | NULL | | | yearvol | char(2) | YES | | NULL | | | glrno | int(7) unsigned | YES | | NULL | | | result | varchar(50) | YES | | NULL | | | jfulltext | longtext | YES | | NULL | | | dedate | date | YES | | NULL | | | title | varchar(150) | YES | | NULL | | | appealno | varchar(500) | YES | | NULL | | | appealyear | varchar(50) | YES | | NULL | | | title2 | varchar(200) | YES | | NULL | | | bench | varchar(50) | YES | | NULL | | | pnames | varchar(1000) | YES | MUL | NULL | | | authorid | varchar(200) | YES | | NULL | | | userid | int(7) unsigned | YES | | NULL | | | usdate | date | YES | | NULL | | | glrtype | char(1) | YES | | G | | | note | text | YES | | NULL | | | gname | varchar(50) | YES | MUL | NULL | | | cjudge | tinyint(1) unsigned | YES | | 0 | | | cadvocate | tinyint(1) unsigned | YES | | 0 | | | ccitation | tinyint(1) unsigned | YES | | 0 | | | cnotes | tinyint(1) unsigned | YES | | 0 | | | cparty | tinyint(1) unsigned | YES | | 0 | | | coparty | tinyint(1) unsigned | YES | | 0 | | | cspobs | tinyint(1) unsigned | YES | | 0 | | | cstatute | tinyint(1) unsigned | YES | | 0 | | | ccase | tinyint(1) unsigned | YES | | 0 | | | cfulltext | tinyint(1) unsigned | YES | | 0 | | | completed | tinyint(1) unsigned | YES | | 0 | | +-------------+---------------------+------+-----+---------+----------------+ 31 rows in set (0.02 sec) mysql> explain glrtext; ERROR 1146 (42S02): Table 'glrout.glrtext' doesn't exist mysql> explain glrtxt; +-----------+-----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-----------------+------+-----+---------+-------+ | caseid | int(7) unsigned | NO | PRI | 0 | | | jfulltext | longtext | YES | MUL | NULL | | | gujtext | longtext | YES | | NULL | | +-----------+-----------------+------+-----+---------+-------+ 3 rows in set (0.00 sec) mysql> show create table cnotes; +--------+-------------------------------------- | Table | Create Table | +--------+-------------------------------------- | cnotes | CREATE TABLE `cnotes` ( `caseid` int(7) unsigned default NULL, `catchnote` text, `headnote` text, `seqno` int(7) unsigned default '1', `ab` varchar(50) default NULL, KEY `caseid` (`caseid`), FULLTEXT KEY `cnote` (`catchnote`), FULLTEXT KEY `hnote` (`headnote`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +--------+---------------------------------------------------- 1 row in set (0.01 sec) mysql> show create table glrtxt; +--------+-------------------------------------------------- | Table | Create Table | +--------+-------------------------------------------------- | glrtxt | CREATE TABLE `glrtxt` ( `caseid` int(7) unsigned NOT NULL default '0', `jfulltext` longtext, `gujtext` longtext, PRIMARY KEY (`caseid`), FULLTEXT KEY `jfull` (`jfulltext`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +--------+--------------------------------------------------- 1 row in set (0.00 sec) mysql> show create table glrcase; +---------+-------------------------------------------------- | Table | Create Table | +---------+------------------------------------------------- | glrcase | CREATE TABLE `glrcase` ( `caseid` int(7) unsigned NOT NULL auto_increment, `publication` varchar(9) default NULL, `pubyear` int(4) unsigned default NULL, `yearvol` char(2) default NULL, `glrno` int(7) unsigned default NULL, `result` varchar(50) default NULL, `jfulltext` longtext, `dedate` date default NULL, `title` varchar(150) default NULL, `appealno` varchar(500) default NULL, `appealyear` varchar(50) default NULL, `title2` varchar(200) default NULL, `bench` varchar(50) default NULL, `pnames` varchar(1000) default NULL, `authorid` varchar(200) default NULL, `userid` int(7) unsigned default NULL, `usdate` date default NULL, `glrtype` char(1) default 'G', `note` text, `gname` varchar(50) default NULL, `cjudge` tinyint(1) unsigned default '0', `cadvocate` tinyint(1) unsigned default '0', `ccitation` tinyint(1) unsigned default '0', `cnotes` tinyint(1) unsigned default '0', `cparty` tinyint(1) unsigned default '0', `coparty` tinyint(1) unsigned default '0', `cspobs` tinyint(1) unsigned default '0', `cstatute` tinyint(1) unsigned default '0', `ccase` tinyint(1) unsigned default '0', `cfulltext` tinyint(1) unsigned default '0', `completed` tinyint(1) unsigned default '0', PRIMARY KEY (`caseid`), KEY `gname` (`gname`), KEY `pnames` (`pnames`(767)), KEY `year` (`pubyear`), KEY `pub` (`publication`) ) ENGINE=InnoDB AUTO_INCREMENT=800101 DEFAULT CHARSET=latin1 | +---------+----------------------------------------------------------- 1 row in set (0.00 sec) mysql> exit