TYPE=VIEW
query=select `wmsdb`.`t_log`.`logId` AS `logId`,`wmsdb`.`t_log`.`IP` AS `IP`,`wmsdb`.`t_log`.`logContent` AS `logContent`,`wmsdb`.`t_log`.`logTime` AS `logTime`,`wmsdb`.`t_log`.`moduleCode` AS `moduleCode`,`wmsdb`.`t_log`.`userId` AS `userId`,`wmsdb`.`t_user`.`userName` AS `userName`,`wmsdb`.`t_module`.`moduleName` AS `moduleName`,`wmsdb`.`t_module`.`moduleId` AS `moduleId` from ((`wmsdb`.`t_log` left join `wmsdb`.`t_user` on((`wmsdb`.`t_log`.`userId` = `wmsdb`.`t_user`.`userId`))) left join `wmsdb`.`t_module` on((`wmsdb`.`t_module`.`moduleCode` = `wmsdb`.`t_log`.`moduleCode`)))
md5=1ed4a797443cacd5ff24cc32b6272719
updatable=0
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_log`.`logId` AS `logId`,`t_log`.`IP` AS `IP`,`t_log`.`logContent` AS `logContent`,`t_log`.`logTime` AS `logTime`,`t_log`.`moduleCode` AS `moduleCode`,`t_log`.`userId` AS `userId`,`t_user`.`userName` AS `userName`,`t_module`.`moduleName` AS `moduleName`,`t_module`.`moduleId` AS `moduleId` from ((`t_log` left join `t_user` on((`t_log`.`userId` = `t_user`.`userId`))) left join `t_module` on((`t_module`.`moduleCode` = `t_log`.`moduleCode`)))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_log`.`logId` AS `logId`,`wmsdb`.`t_log`.`IP` AS `IP`,`wmsdb`.`t_log`.`logContent` AS `logContent`,`wmsdb`.`t_log`.`logTime` AS `logTime`,`wmsdb`.`t_log`.`moduleCode` AS `moduleCode`,`wmsdb`.`t_log`.`userId` AS `userId`,`wmsdb`.`t_user`.`userName` AS `userName`,`wmsdb`.`t_module`.`moduleName` AS `moduleName`,`wmsdb`.`t_module`.`moduleId` AS `moduleId` from ((`wmsdb`.`t_log` left join `wmsdb`.`t_user` on((`wmsdb`.`t_log`.`userId` = `wmsdb`.`t_user`.`userId`))) left join `wmsdb`.`t_module` on((`wmsdb`.`t_module`.`moduleCode` = `wmsdb`.`t_log`.`moduleCode`)))
