text: 
  
  UPDATE ACCOUNT_INFO SET TYPE='employee';
  
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(9,'9','bob','鲍勃','active','employee','unlocked','2015-02-27 00:00:00','鲍勃','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(9,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',9,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(9,'9','bob','Bob','***','Bob ***','18012345678','bob@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(10,'10','alice','爱丽丝','active','employee','unlocked','2015-02-27 00:00:00','爱丽丝','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(10,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',10,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(10,'10','alice','Alice','***','Alice ***','18012345678','alice@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(11,'11','mike','麦克','active','employee','unlocked','2015-02-27 00:00:00','麦克','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(11,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',11,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(11,'11','mike','Mike','***','Mike ***','18012345678','mike@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(12,'12','justin','贾斯汀','active','employee','unlocked','2015-02-27 00:00:00','贾斯汀','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(12,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',12,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(12,'12','justin','Justin','***','Justin ***','18012345678','justin@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(13,'13','tom','汤姆','active','employee','unlocked','2015-02-27 00:00:00','汤姆','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(13,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',13,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(13,'13','tom','Tom','***','Tom ***','18012345678','tom@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(14,'14','james','詹姆斯','active','employee','unlocked','2015-02-27 00:00:00','詹姆斯','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(14,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',14,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(14,'14','james','James','***','James ***','18012345678','james@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(15,'15','joe','乔伊','active','employee','unlocked','2015-02-27 00:00:00','乔伊','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(15,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',15,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(15,'15','joe','Joe','***','Joe ***','18012345678','joe@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(16,'16','paul','保罗','active','employee','unlocked','2015-02-27 00:00:00','保罗','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(16,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',16,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(16,'16','paul','Paul','***','Paul ***','18012345678','paul@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(17,'17','jane','简','active','employee','unlocked','2015-02-27 00:00:00','简','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(17,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',17,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(17,'17','jane','Jane','***','Jane ***','18012345678','jane@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(18,'18','marry','玛丽','active','employee','unlocked','2015-02-27 00:00:00','玛丽','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(18,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',18,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(18,'18','marry','Marry','***','Marry ***','18012345678','marry@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(19,'19','ben','本','active','employee','unlocked','2015-02-27 00:00:00','本','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(19,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',19,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(19,'19','ben','Ben','***','Ben ***','18012345678','ben@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(20,'20','bot','系统机器人','active','bot','unlocked','2015-02-27 00:00:00','系统机器人','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(20,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',20,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(20,'20','bot','Bot','***','Bot ***','18012345678','bot@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(21,'21','jack','杰克','active','employee','unlocked','2015-02-27 00:00:00','杰克','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(21,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',21,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(21,'21','jack','Jack','***','Jack ***','18012345678','jack@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(22,'22','martin','马丁','active','employee','unlocked','2015-02-27 00:00:00','马丁','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(22,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',22,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(22,'22','martin','Martin','***','Martin ***','18012345678','marin@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(23,'23','alex','阿莱克斯','active','employee','unlocked','2015-02-27 00:00:00','阿莱克斯','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(23,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',23,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(23,'23','alex','Alex','***','Alex ***','18012345678','alex@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(24,'24','daniel','丹尼尔','active','employee','unlocked','2015-02-27 00:00:00','丹尼尔','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(24,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',24,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(24,'24','daniel','Daniel','***','Daniel ***','18012345678','daniel@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(25,'25','eric','艾瑞克','active','employee','unlocked','2015-02-27 00:00:00','艾瑞克','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(25,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',25,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(25,'25','eric','Eric','***','Eric ***','18012345678','eric@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(26,'26','leon','里昂','active','employee','unlocked','2015-02-27 00:00:00','里昂','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(26,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',26,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(26,'26','leon','Leon','***','Leon ***','18012345678','leon@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(27,'27','clark','克拉克','active','employee','unlocked','2015-02-27 00:00:00','克拉克','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(27,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',27,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(27,'27','clark','Clark','***','Clark ***','18012345678','clark@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(28,'28','david','大卫','active','employee','unlocked','2015-02-27 00:00:00','大卫','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(28,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',28,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(28,'28','david','David','***','David ***','18012345678','david@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(29,'29','henry','亨利','active','employee','unlocked','2015-02-27 00:00:00','亨利','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(29,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',29,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(29,'29','henry','Henry','***','Henry ***','18012345678','henry@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(30,'30','helen','海伦','active','employee','unlocked','2015-02-27 00:00:00','海伦','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(30,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',30,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(30,'30','helen','Helen','***','Helen ***','18012345678','helen@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(31,'31','sarah','莎拉','active','employee','unlocked','2015-02-27 00:00:00','莎拉','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(31,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',31,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(31,'31','sarah','Sarah','***','Sarah ***','18012345678','sarah@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(32,'32','sam','萨姆','active','employee','unlocked','2015-02-27 00:00:00','萨姆','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(32,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',32,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(32,'32','sam','Sam','***','Sam ***','18012345678','sam@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(33,'33','claire','克莱尔','active','employee','unlocked','2015-02-27 00:00:00','克莱尔','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(33,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',33,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(33,'33','claire','Claire','***','Claire ***','18012345678','claire@mossle.com','1');
  
  INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,TYPE,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED,TENANT_ID) VALUES(34,'34','thomas','托马斯','active','employee','unlocked','2015-02-27 00:00:00','托马斯','required','1');
  INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID,TENANT_ID) VALUES(34,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2017-04-28 00:00:00','normal','yes','normal','default','active',34,'1');
  INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL,TENANT_ID) VALUES(34,'34','thomas','Thomas','***','Thomas ***','18012345678','thomas@mossle.com','1');
  
  UPDATE PERSON_INFO SET EMAIL='lingo@mossle.com' WHERE ID=1;
  UPDATE PERSON_INFO SET EMAIL='vivian@mossle.com' WHERE ID=2;
  UPDATE PERSON_INFO SET EMAIL='steven@mossle.com' WHERE ID=3;
  UPDATE PERSON_INFO SET EMAIL='king@mossle.com' WHERE ID=4;
  UPDATE PERSON_INFO SET EMAIL='john@mossle.com' WHERE ID=5;
  UPDATE PERSON_INFO SET EMAIL='william@mossle.com' WHERE ID=6;
  UPDATE PERSON_INFO SET EMAIL='adam@mossle.com' WHERE ID=7;
  UPDATE PERSON_INFO SET EMAIL='robot@mossle.com' WHERE ID=8;
  