#/bin/bash
sync
mysql -uroot -pxxxooo tablename -e 'create table `xxx` select min(id) as id,username,password,mail from `tmp_xxx` group by mail,password order by id;'
sync
mysql -uroot -pxxxooo tablename -e 'alter table `xxx` add index `inx_mail` using BTREE (`mail`), add index `inx_username` (`username`), add primary key (`id`);'
sync
date > done.txt
init 0