v064_to_v065.sql

来自「CRM源码This file describes some issues tha」· SQL 代码 · 共 17 行

drop view qx_user_roles
go

create view qx_user_roles as
    select distinct r.role_id, u.user_id, r.default_focus_id
        from qx_role r, qx_role_to_users u
        where r.role_id = u.role_id
union all
    select r.role_id, g.employeegroup, r.default_focus_id
        from qx_role r, qx_workgroup_to_role wr, qx_groupmember g
        where r.role_id = wr.role_id
        and wr.workgroup_id = g.workgroupgroup
go

UPDATE QX_SYS_PROP SET PROP_VAL = '065' WHERE (PROP_ID = 'DB_CORE_VERSION');
go