

INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED) VALUES(1,'1','lingo','临远','active','unlocked','2015-02-27 00:00:00','临远','required');
INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED) VALUES(2,'2','vivian','薇薇安','active','unlocked','2015-02-27 00:00:00','薇薇安','required');
INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED) VALUES(3,'3','steven','史蒂文','active','unlocked','2015-02-27 00:00:00','史蒂文','required');
INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED) VALUES(4,'4','king','金','active','unlocked','2015-02-27 00:00:00','金','required');
INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED) VALUES(5,'5','john','约翰','active','unlocked','2015-02-27 00:00:00','约翰','required');
INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED) VALUES(6,'6','william','威廉','active','unlocked','2015-02-27 00:00:00','威廉','required');
INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED) VALUES(7,'7','adam','亚当','active','unlocked','2015-02-27 00:00:00','亚当','required');
INSERT INTO ACCOUNT_INFO(ID,CODE,USERNAME,DISPLAY_NAME,STATUS,LOCKED,CREATE_TIME,NICK_NAME,PASSWORD_REQUIRED) VALUES(8,'8','robot','罗伯特','active','unlocked','2015-02-27 00:00:00','罗伯特','required');


INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID) VALUES(1,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2020-04-30 00:00:00','normal','yes','normal','default','active',1);
INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID) VALUES(2,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2020-04-30 00:00:00','normal','yes','normal','default','active',2);
INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID) VALUES(3,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2020-04-30 00:00:00','normal','yes','normal','default','active',3);
INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID) VALUES(4,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2020-04-30 00:00:00','normal','yes','normal','default','active',4);
INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID) VALUES(5,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2020-04-30 00:00:00','normal','yes','normal','default','active',5);
INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID) VALUES(6,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2020-04-30 00:00:00','normal','yes','normal','default','active',6);
INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID) VALUES(7,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2020-04-30 00:00:00','normal','yes','normal','default','active',7);
INSERT INTO ACCOUNT_CREDENTIAL(ID,PASSWORD,MODIFY_TIME,EXPIRE_TIME,EXPIRE_STATUS,COULD_MODIFY,TYPE,CATALOG,STATUS,ACCOUNT_ID) VALUES(8,'a1ccdbc7f295e0aeda5dc4e0f2677ea3','2015-02-27 00:00:00','2020-04-30 00:00:00','normal','yes','normal','default','active',8);


INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL) VALUES(1,'1','lingo','Lingo','Mossle','Lingo Mossle','18012345678','lingo.mossle@gmail.com');
INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL) VALUES(2,'2','vivian','Vivian','Mossle','Vivian Mossle','18012345678','vivian.mossle@gmail.com');
INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL) VALUES(3,'3','steven','Steven','Demo','Steven','18012345678','vivian.mossle@gmail.com');
INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL) VALUES(4,'4','king','King','Demo','King','18012345678','vivian.mossle@gmail.com');
INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL) VALUES(5,'5','john','John','Demo','John','18012345678','vivian.mossle@gmail.com');
INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL) VALUES(6,'6','william','William','','William','18012345678','vivian.mossle@gmail.com');
INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL) VALUES(7,'7','adam','Adam','Demo','Adam','18012345678','vivian.mossle@gmail.com');
INSERT INTO PERSON_INFO(ID,CODE,USERNAME,GIVEN_NAME,FAMILY_NAME,FULL_NAME,CELLPHONE,EMAIL) VALUES(8,'8','robot','Robot','Demo','Robot','18012345678','vivian.mossle@gmail.com');

