mysql_41.sql

来自「个人认为是最好的Java论坛源码」· SQL 代码 · 共 31 行

# ################
# PermissionControl
# ################
	
PermissionControl.deleteAllUserRoleValuesByGroup = DELETE rv \
	FROM jforum_roles r, jforum_role_values rv, jforum_users u, jforum_user_groups ug \
	WHERE r.role_id = rv.role_id \
	AND u.user_id = ug.user_id \
	AND ug.group_id = ? \
	AND r.user_id = u.user_id \
	AND r.role_name = ?

PermissionControl.deleteUserRoleByGroup = DELETE r \
	FROM jforum_roles r, jforum_user_groups ug \
	WHERE ug.user_id = r.user_id \
	AND ug.group_id = ? \
	AND r.name = ?
	
PermissionControl.deleteUserRoleValuesByRoleName = DELETE rv \
	FROM jforum_role_values rv, jforum_roles r, jforum_user_groups ug \
	WHERE r.role_id = rv.role_id \
	AND ug.user_id = r.user_id \
	AND ug.group_id = ? \
	AND r.name = ?

PermissionControl.deleteUserRoleValueByGroup =  DELETE rv \
	FROM jforum_role_values rv, jforum_roles r, jforum_user_groups ug \
	WHERE r.role_id = rv.role_id \
	AND ug.user_id = r.user_id \
	AND ug.group_id = ? \
	AND r.name = ?