v018_to_v019.sql

CRM源码This file describes some issues that should be implemented in future and how it should be imple

create view dbo.qx_user_permissions as
    select u.pkey as user_id, p.*
    from qx_permission p
		inner join qx_role_to_users r2u on p.role_id = r2u.role_id
		inner join qx_users u on u.pkey = r2u.user_id
    union
    select u.pkey as user_id, p.*
    from qx_permission p
		inner join qx_workgroup_to_role w2r on p.role_id = w2r.role_id
		inner join qx_workgroup w on w.pkey = w2r.workgroup_id
		inner join qx_groupmember gm on gm.workgroupgroup = w.pkey
		inner join qx_users u on u.pkey = gm.employeegroup
go

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