CREATE TABLE `info` ( `id` int(11) NOT NULL auto_increment, `customerid` int(11) default NULL, `type` varchar(30) default NULL, `name` varchar(30) default NULL, `number` varchar(20) default NULL, `expire_month` char(2) default NULL, `expire_year` varchar(4) default NULL, `code` varchar(4) default NULL, PRIMARY KEY (`id`), UNIQUE KEY `id_2` (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3003 ;