mysql> SHOW CREATE TABLE boc.doc\G
*************************** 1. row ***************************
       Table: doc
Create Table: CREATE TABLE `doc` (
  `docno` varchar(12) NOT NULL DEFAULT '',
  `doctype` char(1) DEFAULT NULL,                                                                                                                                                                                                            
  `rdate` date NOT NULL DEFAULT '0000-00-00',                                                                                                                                                                                                
  `grantor` varchar(40) NOT NULL DEFAULT '',                                                                                                                                                                                                 
  `grantee` varchar(40) NOT NULL DEFAULT '',                                                                                                                                                                                                 
  `class` varchar(12) DEFAULT NULL,                                                                                                                                                                                                          
  `class_desc` varchar(12) DEFAULT NULL,                                                                                                                                                                                                     
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,                                                                                                                                                                               
  PRIMARY KEY (`docno`),                                                                                                                                                                                                                     
  KEY `names` (`grantor`,`grantee`),                                                                                                                                                                                                         
  KEY `grantee` (`grantee`),                                                                                                                                                                                                                 
  KEY `idx_doc_rdate` (`rdate`),                                                                                                                                                                                                             
  KEY `idx_doc_class` (`class`)                                                                                                                                                                                                              
) ENGINE=MyISAM DEFAULT CHARSET=latin1