整理的删除SQL，有些数据在界面无法删除

liangzy

整理的删除SQL，有些数据在界面无法删除：

1.          删除一个人：

                delete from t_s_role_user
                where userid = '4028ef81563ae5be01563ae92d7f0002';

                delete from t_s_user
                where id = '4028ef81563ae5be01563ae92d7f0002';

                delete from t_s_base_user
                where id = '4028ef81563ae5be01563ae92d7f0002';
               
2.    删除一个组织机构
      delete  from  t_s_user_org  where org_id='8a8ab0b246dc81120146dc8180a20016'
      delete from t_s_role_org where org_id='8a8ab0b246dc81120146dc8180a20016'               
          
          
3.   删除角色

     delete  from t_s_role_user where roleid = '402880e74d75c4dd014d75d3c5f40001';

         delete from t_s_role_org where role_id = '402880e74d75c4dd014d75d3c5f40001';

         delete from t_s_role where id = '402880e74d75c4dd014d75d3c5f40001';            

sunonly

总结得很好