mysql> show create table tasklist;
+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table    | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tasklist | CREATE TABLE `tasklist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `no` int(11) NOT NULL,
  `claim_id` decimal(20,2) DEFAULT NULL,
  `crt_date` datetime NOT NULL,
  `crt_ou` int(1) NOT NULL,
  `deadline` datetime NOT NULL,
  `complete_time` datetime DEFAULT NULL,
  `task` text NOT NULL,
  `creator` int(3) NOT NULL,
  `task_for` int(3) NOT NULL DEFAULT '1',
  `performer` int(3) DEFAULT '1',
  `complited` int(1) NOT NULL DEFAULT '2',
  `view_count` int(3) NOT NULL DEFAULT '0',
  `root` int(1) NOT NULL DEFAULT '1',
  `parent_id` int(11) DEFAULT NULL,
  `active_task` int(1) NOT NULL DEFAULT '0',
  `auto_task_id` int(2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `no` (`no`),
  KEY `complited` (`complited`),
  KEY `crt_date` (`crt_date`),
  KEY `creator` (`creator`),
  KEY `performer` (`performer`),
  KEY `parent_id` (`parent_id`),
  KEY `deadline` (`deadline`),
  KEY `combine` (`creator`,`performer`,`no`),
  KEY `crt_ou` (`crt_ou`)
) ENGINE=MyISAM AUTO_INCREMENT=171332 DEFAULT CHARSET=utf8 |
+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)