TYPE=VIEW
query=select `wmsdb`.`t_warehouselocation`.`locationId` AS `locationId`,`wmsdb`.`t_warehouselocation`.`acreage` AS `acreage`,`wmsdb`.`t_warehouselocation`.`areaId` AS `areaId`,`wmsdb`.`t_warehouselocation`.`locationNo` AS `locationNo`,`wmsdb`.`t_warehouselocation`.`manager1` AS `manager1`,`wmsdb`.`t_warehouselocation`.`manager2` AS `manager2`,`wmsdb`.`t_warehouselocation`.`maxStorageCapacity` AS `maxStorageCapacity`,`wmsdb`.`t_warehouselocation`.`natureId` AS `natureId`,`wmsdb`.`t_warehouselocation`.`status` AS `status`,`wmsdb`.`t_warehouselocation`.`tel1` AS `tel1`,`wmsdb`.`t_warehouselocation`.`tel2` AS `tel2`,`wmsdb`.`t_warehousearea`.`areaName` AS `areaName`,`wmsdb`.`t_locationnature`.`natureName` AS `natureName`,`wmsdb`.`t_locationnature`.`areaNature` AS `areaNature`,`wmsdb`.`t_warehousearea`.`areaCode` AS `areaCode`,`wmsdb`.`t_warehousearea`.`status` AS `areaStatus`,`wmsdb`.`t_locationnature`.`status` AS `locationNatureStatus` from ((`wmsdb`.`t_warehouselocation` join `wmsdb`.`t_warehousearea` on((`wmsdb`.`t_warehouselocation`.`areaId` = `wmsdb`.`t_warehousearea`.`areaId`))) join `wmsdb`.`t_locationnature` on((`wmsdb`.`t_warehouselocation`.`natureId` = `wmsdb`.`t_locationnature`.`natureId`)))
md5=79f26569c43dc6d8f046b92b7864798c
updatable=1
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 `t_warehouselocation`.`locationId` AS `locationId`,`t_warehouselocation`.`acreage` AS `acreage`,`t_warehouselocation`.`areaId` AS `areaId`,`t_warehouselocation`.`locationNo` AS `locationNo`,`t_warehouselocation`.`manager1` AS `manager1`,`t_warehouselocation`.`manager2` AS `manager2`,`t_warehouselocation`.`maxStorageCapacity` AS `maxStorageCapacity`,`t_warehouselocation`.`natureId` AS `natureId`,`t_warehouselocation`.`status` AS `status`,`t_warehouselocation`.`tel1` AS `tel1`,`t_warehouselocation`.`tel2` AS `tel2`,`t_warehousearea`.`areaName` AS `areaName`,`t_locationnature`.`natureName` AS `natureName`,`t_locationnature`.`areaNature` AS `areaNature`,`t_warehousearea`.`areaCode` AS `areaCode`,`t_warehousearea`.`status` AS `areaStatus`,`t_locationnature`.`status` AS `locationNatureStatus` from ((`t_warehouselocation` join `t_warehousearea` on((`t_warehouselocation`.`areaId` = `t_warehousearea`.`areaId`))) join `t_locationnature` on((`t_warehouselocation`.`natureId` = `t_locationnature`.`natureId`)))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_warehouselocation`.`locationId` AS `locationId`,`wmsdb`.`t_warehouselocation`.`acreage` AS `acreage`,`wmsdb`.`t_warehouselocation`.`areaId` AS `areaId`,`wmsdb`.`t_warehouselocation`.`locationNo` AS `locationNo`,`wmsdb`.`t_warehouselocation`.`manager1` AS `manager1`,`wmsdb`.`t_warehouselocation`.`manager2` AS `manager2`,`wmsdb`.`t_warehouselocation`.`maxStorageCapacity` AS `maxStorageCapacity`,`wmsdb`.`t_warehouselocation`.`natureId` AS `natureId`,`wmsdb`.`t_warehouselocation`.`status` AS `status`,`wmsdb`.`t_warehouselocation`.`tel1` AS `tel1`,`wmsdb`.`t_warehouselocation`.`tel2` AS `tel2`,`wmsdb`.`t_warehousearea`.`areaName` AS `areaName`,`wmsdb`.`t_locationnature`.`natureName` AS `natureName`,`wmsdb`.`t_locationnature`.`areaNature` AS `areaNature`,`wmsdb`.`t_warehousearea`.`areaCode` AS `areaCode`,`wmsdb`.`t_warehousearea`.`status` AS `areaStatus`,`wmsdb`.`t_locationnature`.`status` AS `locationNatureStatus` from ((`wmsdb`.`t_warehouselocation` join `wmsdb`.`t_warehousearea` on((`wmsdb`.`t_warehouselocation`.`areaId` = `wmsdb`.`t_warehousearea`.`areaId`))) join `wmsdb`.`t_locationnature` on((`wmsdb`.`t_warehouselocation`.`natureId` = `wmsdb`.`t_locationnature`.`natureId`)))
