-- 定时器停掉后，更新前 执行。
DROP TABLE IF EXISTS `person_base_info_bk`;
CREATE TABLE person_base_info_bk SELECT * FROM person_base_info;
DROP TABLE IF EXISTS `person_base_info_temp`;
CREATE TABLE person_base_info_temp SELECT * FROM person_base_info WHERE state=1;
TRUNCATE person_base_info;
insert into person_base_info(active,create_time,update_time,idnum,address,name,imgPath,state,updateflag)
SELECT active,create_time,update_time,idnum,address,name,imgPath,state,updateflag FROM person_base_info_temp;
DROP TABLE IF EXISTS `person_base_info_temp`;