DROP TABLE IF EXISTS `tt01`;
CREATE TABLE  `tra_occ`.`tt01` (
  `id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(30) COLLATE utf8_bin DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tt01_name` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

insert into tt01 values (1,'a',1);
insert into tt01 values (2,'b',2);
insert into tt01 values (3,'c',3);
insert into tt01 values (4,'d',4);
insert into tt01 values (6,'f',6);
insert into tt01 values (7,'g',7);
insert into tt01 values (8,'h',8);