Startsida Utforska Hjälp
Registrera dig Logga in
lizhenghang
/
dev
1
0
Fork 0
Filer Ärenden 0 Pull-förfrågningar 0 Wiki
Träd: 4f971b3fae
Grenar Taggar
dev
/
常用SQL语句
/
权限相关
/
重置所有用户密码.sql

重置所有用户密码.sql 3.1 KB
Historik Rå

1234567891011121314151617181920212223242526 
  1. =========================测试环境恢复后执行语句====================================
    2. 

  2. UPDATE auth_user SET user_id=0 WHERE user_uid='system';
    3. 

  3. 

  4. 

  5. /* 密码123456           025068ABE842F5EA         */
    6. 

  6. 缺省用户统一密码：123456Xl
    7. 

  7. 

  8. UPDATE auth_user SET user_password='{SSHA}KvZLZ5NQcXQf8IG5V0Qv2xjXf4e6duIgPtlbQg==' WHERE user_id=1;
    9. 

  9. UPDATE auth_user SET user_id=0 WHERE user_uid='system';
    10. 

  10. 

  11. /* 密码123456Xl */
    12. 

  12. UPDATE extend_data SET extend_data_value='0582A55A04A2FE730B9C0881C7570FD4' WHERE extend_data_type_id='1';
    13. 

  13. 

  14. /* 密码123456Dcp */
    15. 

  15. UPDATE `extend_data` SET extend_data_value='9310908E6EE04CB6E3D24E8ED78E7249' WHERE extend_data_type_id=1 AND extend_data_sourceid<>0;
    16. 

  16. 

  17. /* 设置用户最后密码修改时间 */
    18. 

  18. UPDATE auth_user SET USER_PWD_MODIFIED_DATE=NOW();
    19. 

  19. 

  20. /* 设置system用户密码为123 */
    21. 

  21. UPDATE extend_data SET extend_data_value='9F8FD38DB76F9977' WHERE extend_data_type_id='1' AND extend_data_sourceid='0';
    22. 

  22. =====================================================================================
    23. 

  23. 

  24. /* system用户 */
    25. 

  25. 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`)
    26. 

  26. 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);
    27.