TYPE=VIEW
query=select `wmsdb`.`t_r_modulefunction`.`mfId` AS `mfId`,`wmsdb`.`t_r_modulefunction`.`moduleId` AS `moduleId`,`wmsdb`.`t_module`.`moduleName` AS `moduleName`,`wmsdb`.`t_module`.`mOrder` AS `mOrder`,`wmsdb`.`t_module`.`moduleCode` AS `moduleCode`,`wmsdb`.`t_module`.`extCtlName` AS `extCtlName`,`wmsdb`.`t_module`.`extViewAlias` AS `extViewAlias`,`wmsdb`.`t_module`.`extViewType` AS `extViewType`,`wmsdb`.`t_module`.`extViewParams` AS `extViewParams`,`wmsdb`.`t_module`.`parentId` AS `parentId`,`wmsdb`.`t_module`.`remark` AS `remark`,`wmsdb`.`t_r_modulefunction`.`functionId` AS `functionId`,`wmsdb`.`t_function`.`functionCode` AS `functionCode`,`wmsdb`.`t_function`.`functionName` AS `functionName`,`wmsdb`.`t_function`.`fOrder` AS `fOrder` from ((`wmsdb`.`t_module` join `wmsdb`.`t_r_modulefunction` on((`wmsdb`.`t_module`.`moduleId` = `wmsdb`.`t_r_modulefunction`.`moduleId`))) join `wmsdb`.`t_function` on((`wmsdb`.`t_function`.`functionId` = `wmsdb`.`t_r_modulefunction`.`functionId`))) order by `wmsdb`.`t_module`.`moduleId`,`wmsdb`.`t_module`.`mOrder`,`wmsdb`.`t_function`.`functionId`,`wmsdb`.`t_function`.`fOrder`
md5=e98018265496f662a8b6bc768859b470
updatable=1
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2016-01-12 06:01:00
create-version=1
source=select `t_r_modulefunction`.`mfId` AS `mfId`,`t_r_modulefunction`.`moduleId` AS `moduleId`,`t_module`.`moduleName` AS `moduleName`,`t_module`.`mOrder` AS `mOrder`,`t_module`.`moduleCode` AS `moduleCode`,`t_module`.`extCtlName` AS `extCtlName`,`t_module`.`extViewAlias` AS `extViewAlias`,`t_module`.`extViewType` AS `extViewType`,`t_module`.`extViewParams` AS `extViewParams`,`t_module`.`parentId` AS `parentId`,`t_module`.`remark` AS `remark`,`t_r_modulefunction`.`functionId` AS `functionId`,`t_function`.`functionCode` AS `functionCode`,`t_function`.`functionName` AS `functionName`,`t_function`.`fOrder` AS `fOrder` from ((`t_module` join `t_r_modulefunction` on((`t_module`.`moduleId` = `t_r_modulefunction`.`moduleId`))) join `t_function` on((`t_function`.`functionId` = `t_r_modulefunction`.`functionId`))) order by `t_module`.`moduleId`,`t_module`.`mOrder`,`t_function`.`functionId`,`t_function`.`fOrder`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_r_modulefunction`.`mfId` AS `mfId`,`wmsdb`.`t_r_modulefunction`.`moduleId` AS `moduleId`,`wmsdb`.`t_module`.`moduleName` AS `moduleName`,`wmsdb`.`t_module`.`mOrder` AS `mOrder`,`wmsdb`.`t_module`.`moduleCode` AS `moduleCode`,`wmsdb`.`t_module`.`extCtlName` AS `extCtlName`,`wmsdb`.`t_module`.`extViewAlias` AS `extViewAlias`,`wmsdb`.`t_module`.`extViewType` AS `extViewType`,`wmsdb`.`t_module`.`extViewParams` AS `extViewParams`,`wmsdb`.`t_module`.`parentId` AS `parentId`,`wmsdb`.`t_module`.`remark` AS `remark`,`wmsdb`.`t_r_modulefunction`.`functionId` AS `functionId`,`wmsdb`.`t_function`.`functionCode` AS `functionCode`,`wmsdb`.`t_function`.`functionName` AS `functionName`,`wmsdb`.`t_function`.`fOrder` AS `fOrder` from ((`wmsdb`.`t_module` join `wmsdb`.`t_r_modulefunction` on((`wmsdb`.`t_module`.`moduleId` = `wmsdb`.`t_r_modulefunction`.`moduleId`))) join `wmsdb`.`t_function` on((`wmsdb`.`t_function`.`functionId` = `wmsdb`.`t_r_modulefunction`.`functionId`))) order by `wmsdb`.`t_module`.`moduleId`,`wmsdb`.`t_module`.`mOrder`,`wmsdb`.`t_function`.`functionId`,`wmsdb`.`t_function`.`fOrder`
