update   sys_dict set label  ='区域秩序维护',isActive =true where codeType ='securityScopeType' and codeValue ='6';


INSERT INTO`permission` (`role_id`, `module_id`, `operation_id`, `roletype`)
select pr.id,o.module_id,o.id,'2'
from police_role pr,police p,operation o,module m
where pr.active=true
and p.active=TRUE
and o.active=TRUE
and pr.orgid=p.id
and o.module_id=m.id
and m.id in(314,315,316,400);