You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
16 lines
972 B
16 lines
972 B
USE system_manager_ssh_rs_xj_v3_cp;
|
|
DELETE FROM T_BASE_USER WHERE DEPT_ID IS NOT NULL AND DEPT_ID <> '' OR LOGIN_NAME LIKE '%bzr%' OR DELETE_FLAG = 1;
|
|
DELETE FROM T_BASE_USER_IDENTITY WHERE USER_ID NOT IN (SELECT ID FROM T_BASE_USER);
|
|
DELETE FROM T_BASE_USER_DETAIL WHERE USER_ID NOT IN (SELECT ID FROM T_BASE_USER);
|
|
DELETE FROM T_BASE_USER_ORG WHERE USER_ID NOT IN (SELECT ID FROM T_BASE_USER);
|
|
DELETE FROM T_BASE_USER_PARENT;
|
|
DELETE FROM T_BASE_USER_STAGE WHERE USER_ID NOT IN (SELECT ID FROM T_BASE_USER);
|
|
DELETE FROM T_BASE_USER_SUBJECT WHERE USER_ID NOT IN (SELECT ID FROM T_BASE_USER);
|
|
DELETE FROM T_SYS_USER_ROLE WHERE USER_ID NOT IN (SELECT ID FROM T_BASE_USER);
|
|
DELETE FROM T_SYS_USER_MANAGE WHERE USER_ID NOT IN (SELECT ID FROM T_BASE_USER);
|
|
|
|
DELETE FROM T_BASE_ORGTREE WHERE DELETE_FLAG = 1;
|
|
DELETE FROM T_BASE_ORG WHERE DELETE_FLAG = 1;
|
|
DELETE FROM T_BASE_ORGTREE WHERE ORG_ID IN (SELECT ID FROM T_BASE_DEPT);
|
|
DELETE FROM T_BASE_DEPT;
|
|
DELETE FROM T_BASE_CLASS; |