CREATE TABLE IF NOT EXISTS xiaoyoulu (
id int(11) not null AUTO_INCREMENT,
xingming varchar(50) not null,
jibie varchar(50) not null,
banji varchar(50) not null,
xingbie varchar(50) not null,
shouji varchar(255) not null,
dianhua varchar(255) not null,
jiguan varchar(255) not null,
qq varchar(50) not null,
gongsimingcheng varchar(255) not null,
gongsidizhi varchar(255) not null,
youxiang varchar(255) not null,
hangye varchar(50) not null,
zhiwu varchar(50) not null,
aihao varchar(255) not null,
huodongfanwei varchar(50) not null,
biaoji varchar(50) not null,
beizhu varchar(255) not null,
gengxinriqi datetime not null,
youzhaopian ENUM("Y", "N") not null DEFAULT 'N',
key id (`id`),
key xingming (`xingming`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8