create table tab(id int(10) unsigned primary key auto_increment,account char(20) not null default '',password not null char(32) default,INDEX index1(id,account))ENGINE=InnoDB DEFAULT CHARSET=utf-8;
create table tab(id int(10) unsigned primary key auto_increment,account char(20) not null default '',password not null char(32) default,INDEX index1(id,account))ENGINE=InnoDB DEFAULT CHARSET=utf-8;