TYPE=VIEW
query=select distinct `wmsdb`.`t_r_userrole`.`userId` AS `userId`,`v_modulefunction`.`moduleId` AS `moduleId`,`v_modulefunction`.`moduleName` AS `moduleName`,`v_modulefunction`.`extCtlName` AS `extCtlName`,`v_modulefunction`.`extViewAlias` AS `extViewAlias`,`v_modulefunction`.`extViewType` AS `extViewType`,`v_modulefunction`.`extViewParams` AS `extViewParams`,`v_modulefunction`.`parentId` AS `parentId`,`v_modulefunction`.`functionCode` AS `functionCode`,`wmsdb`.`t_module`.`moduleName` AS `parentName`,`v_modulefunction`.`mfId` AS `mfId`,`wmsdb`.`t_module`.`parentId` AS `grandfatherId`,`v_modulefunction`.`moduleCode` AS `moduleCode`,`wmsdb`.`t_module`.`mOrder` AS `parentModuleOrder`,`v_modulefunction`.`mOrder` AS `mOrder`,`v_modulefunction`.`fOrder` AS `fOrder`,`wmsdb`.`t_module`.`moduleCode` AS `parentCode`,`v_modulefunction`.`functionName` AS `functionName` from ((((`wmsdb`.`t_r_userrole` join `wmsdb`.`t_r_rolefunction` on((`wmsdb`.`t_r_userrole`.`roleId` = `wmsdb`.`t_r_rolefunction`.`roleId`))) join `wmsdb`.`v_modulefunction` on((`wmsdb`.`t_r_rolefunction`.`mfId` = `v_modulefunction`.`mfId`))) join `wmsdb`.`t_module` on((`v_modulefunction`.`parentId` = `wmsdb`.`t_module`.`moduleId`))) join `wmsdb`.`t_role` on((`wmsdb`.`t_role`.`roleId` = `wmsdb`.`t_r_userrole`.`roleId`))) where (`wmsdb`.`t_role`.`status` = 1) order by `wmsdb`.`t_module`.`parentId`,`wmsdb`.`t_module`.`mOrder`,`v_modulefunction`.`mOrder`,`v_modulefunction`.`fOrder`
md5=ea344a19ea993074fe5c5d03218dc693
updatable=0
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2016-01-12 06:01:01
create-version=1
source=select distinct `t_r_userrole`.`userId` AS `userId`,`v_modulefunction`.`moduleId` AS `moduleId`,`v_modulefunction`.`moduleName` AS `moduleName`,`v_modulefunction`.`extCtlName` AS `extCtlName`,`v_modulefunction`.`extViewAlias` AS `extViewAlias`,`v_modulefunction`.`extViewType` AS `extViewType`,`v_modulefunction`.`extViewParams` AS `extViewParams`,`v_modulefunction`.`parentId` AS `parentId`,`v_modulefunction`.`functionCode` AS `functionCode`,`t_module`.`moduleName` AS `parentName`,`v_modulefunction`.`mfId` AS `mfId`,`t_module`.`parentId` AS `grandfatherId`,`v_modulefunction`.`moduleCode` AS `moduleCode`,`t_module`.`mOrder` AS `parentModuleOrder`,`v_modulefunction`.`mOrder` AS `mOrder`,`v_modulefunction`.`fOrder` AS `fOrder`,`t_module`.`moduleCode` AS `parentCode`,`v_modulefunction`.`functionName` AS `functionName` from ((((`t_r_userrole` join `t_r_rolefunction` on((`t_r_userrole`.`roleId` = `t_r_rolefunction`.`roleId`))) join `v_modulefunction` on((`t_r_rolefunction`.`mfId` = `v_modulefunction`.`mfId`))) join `t_module` on((`v_modulefunction`.`parentId` = `t_module`.`moduleId`))) join `t_role` on((`t_role`.`roleId` = `t_r_userrole`.`roleId`))) where (`t_role`.`status` = 1) order by `grandfatherId`,`parentModuleOrder`,`v_modulefunction`.`mOrder`,`v_modulefunction`.`fOrder`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select distinct `wmsdb`.`t_r_userrole`.`userId` AS `userId`,`v_modulefunction`.`moduleId` AS `moduleId`,`v_modulefunction`.`moduleName` AS `moduleName`,`v_modulefunction`.`extCtlName` AS `extCtlName`,`v_modulefunction`.`extViewAlias` AS `extViewAlias`,`v_modulefunction`.`extViewType` AS `extViewType`,`v_modulefunction`.`extViewParams` AS `extViewParams`,`v_modulefunction`.`parentId` AS `parentId`,`v_modulefunction`.`functionCode` AS `functionCode`,`wmsdb`.`t_module`.`moduleName` AS `parentName`,`v_modulefunction`.`mfId` AS `mfId`,`wmsdb`.`t_module`.`parentId` AS `grandfatherId`,`v_modulefunction`.`moduleCode` AS `moduleCode`,`wmsdb`.`t_module`.`mOrder` AS `parentModuleOrder`,`v_modulefunction`.`mOrder` AS `mOrder`,`v_modulefunction`.`fOrder` AS `fOrder`,`wmsdb`.`t_module`.`moduleCode` AS `parentCode`,`v_modulefunction`.`functionName` AS `functionName` from ((((`wmsdb`.`t_r_userrole` join `wmsdb`.`t_r_rolefunction` on((`wmsdb`.`t_r_userrole`.`roleId` = `wmsdb`.`t_r_rolefunction`.`roleId`))) join `wmsdb`.`v_modulefunction` on((`wmsdb`.`t_r_rolefunction`.`mfId` = `v_modulefunction`.`mfId`))) join `wmsdb`.`t_module` on((`v_modulefunction`.`parentId` = `wmsdb`.`t_module`.`moduleId`))) join `wmsdb`.`t_role` on((`wmsdb`.`t_role`.`roleId` = `wmsdb`.`t_r_userrole`.`roleId`))) where (`wmsdb`.`t_role`.`status` = 1) order by `wmsdb`.`t_module`.`parentId`,`wmsdb`.`t_module`.`mOrder`,`v_modulefunction`.`mOrder`,`v_modulefunction`.`fOrder`
