=========================测试环境恢复后执行语句====================================
UPDATE auth_user SET user_id=0 WHERE user_uid='system';


/* 密码123456           025068ABE842F5EA         */
缺省用户统一密码：123456Xl

UPDATE auth_user SET user_password='{SSHA}KvZLZ5NQcXQf8IG5V0Qv2xjXf4e6duIgPtlbQg==' WHERE user_id=1;
UPDATE auth_user SET user_id=0 WHERE user_uid='system';

/* 密码123456Xl */
UPDATE extend_data SET extend_data_value='0582A55A04A2FE730B9C0881C7570FD4' WHERE extend_data_type_id='1';

/* 密码123456Dcp */
UPDATE `extend_data` SET extend_data_value='9310908E6EE04CB6E3D24E8ED78E7249' WHERE extend_data_type_id=1 AND extend_data_sourceid<>0;

/* 设置用户最后密码修改时间 */
UPDATE auth_user SET USER_PWD_MODIFIED_DATE=NOW();

/* 设置system用户密码为123 */
UPDATE extend_data SET extend_data_value='9F8FD38DB76F9977' WHERE extend_data_type_id='1' AND extend_data_sourceid='0';
=====================================================================================

/* system用户 */
INSERT INTO `auth_user` (`USER_ID`, `USER_NAME`, `USER_UID`, `USER_PASSWORD`, `USER_NICK_NAME`, `USER_ID_CARD_NUMBER`, `USER_GENDER`, `USER_GENDER_DICT`, `USER_BIRTHDAY`, `USER_NATION`, `USER_NATION_DICT`, `USER_NATIONALITY`, `USER_NATIONALITY_DICT`, `USER_WEDLOCK`, `USER_WEDLOCK_DICT`, `USER_RELIGION`, `USER_RELIGION_DICT`, `USER_EDUCATION`, `USER_EDUCATION_DICT`, `USER_EMAIL`, `USER_TELEPHONE_NUMBER`, `USER_PREFERRED_MOBILE`, `USER_POSTAL_ADDRESS`, `USER_POSTAL_CODE`, `USER_FAX_NUMBER`, `USER_QQ`, `USER_LOCATION_PROVINCE`, `USER_LOCATION_CITY`, `USER_LOCATION_AREA`, `USER_LOCATION_STREET`, `USER_COMPANY`, `USER_DEPART`, `USER_REMARK`, `USER_TAG`, `USER_USERTYPE`, `USER_USERTYPE_DICT`, `USER_PIC`, `USER_SIGNATURE`, `USER_DESCRIPTION`, `USER_ACCOUNT_REGISTERTIME`, `USER_ACCOUNT_ENDTIME`, `USER_STATUS`, `USER_STATUS_DICT`, `USER_PWD_MODIFIED_DATE`, `LAST_LOGIN_TIME`, `CREATE_USER_ID`, `CREATE_TIME`, `UPDATE_USER_ID`, `UPDATE_TIME`, `PASSWORD_MODIFY_FLAG`, `OPERATE_STATE`, `USER_EXTENSIONS`, `boss_customer_number`, `MEDICARE_CARD_TYPE`, `MEDICARE_CARD_TYPE_DICT`, `MEDICARE_CARD_NUMBER`, `INVITATION_CODE`, `REGISTER_INVITER`, `USER_EMAIL_STATUS`, `USER_EMAIL_VALIDATED_TIME`, `USER_ENGLISH_NAME`, `USER_TITLE`, `USER_ID_CARD_TYPE`, `USER_ID_CARD_TYPE_DICT`, `USER_BIRTH_PLACE`, `USER_EDUCATION_DEGREE`, `USER_PERSONAL_EMAIL`, `USER_START_TIME`, `USER_END_TIME`, `USER_EMPLOYEENUMBER`, `USER_SUPERVISE_DEPT`, `USER_ACCESS_CARD_NUMBER`, `USER_SEAT`, `USER_NATIVE_PLACE`, `USER_OPERLINE`, `USER_DUTY`, `USER_REPORT_TO`, `USER_OPERLINE_NAME`, `USER_LABLE_URL`, `USER_DUTY_DICT`)
VALUES('0','系统','system','{SSHA}GQkDqufG8B8vWh7YU5G3LXnWvfNqfm+DxtvFng==','system','','0','0',NULL,'汉族','01','中国','E0500001',NULL,'1',NULL,'05',NULL,'','itpom2@hxb.com','','0000000','1233','',NULL,NULL,NULL,NULL,NULL,NULL,'CITICS','ee47838c23090d990123090e0f8a0002','','','0','0','icon_head/default_man.png','','fsdfsdafsdf',NULL,NULL,'0','0','2019-07-13 14:58:27',NULL,'1','2014-09-16 00:00:00','1','2019-03-03 01:14:06','1','0',NULL,NULL,NULL,NULL,NULL,NULL,'','1',NULL,'','','0',NULL,'','','system000000@hxb.com',NULL,NULL,'system','','','','','',NULL,'',NULL,'',NULL);