TYPE=VIEW
query=select `wmsdb`.`t_stock`.`stockId` AS `stockId`,`wmsdb`.`t_stock`.`goodsId` AS `goodsId`,`wmsdb`.`t_stock`.`instockTime` AS `instockTime`,`wmsdb`.`t_stock`.`locationId` AS `locationId`,`wmsdb`.`t_stock`.`productBatch` AS `productBatch`,`wmsdb`.`t_stock`.`quantity` AS `quantity`,`wmsdb`.`t_stock`.`supplierId` AS `supplierId`,`wmsdb`.`t_stock`.`orderNo` AS `orderNo`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_warehouselocation`.`locationNo` AS `locationNo`,`wmsdb`.`t_warehouselocation`.`areaId` AS `areaId`,`wmsdb`.`t_warehousearea`.`areaNature` AS `areaNature`,`wmsdb`.`t_warehousearea`.`areaName` AS `areaName`,`wmsdb`.`t_warehousearea`.`status` AS `areaStatus`,`wmsdb`.`t_supplier`.`status` AS `supplierStatus`,`wmsdb`.`t_goods`.`status` AS `goodsStatus`,`wmsdb`.`t_warehouselocation`.`status` AS `locationStatus` from ((((`wmsdb`.`t_goods` join `wmsdb`.`t_stock` on((`wmsdb`.`t_stock`.`goodsId` = `wmsdb`.`t_goods`.`goodsId`))) join `wmsdb`.`t_supplier` on((`wmsdb`.`t_stock`.`supplierId` = `wmsdb`.`t_supplier`.`supplierId`))) join `wmsdb`.`t_warehouselocation` on((`wmsdb`.`t_stock`.`locationId` = `wmsdb`.`t_warehouselocation`.`locationId`))) join `wmsdb`.`t_warehousearea` on((`wmsdb`.`t_warehouselocation`.`areaId` = `wmsdb`.`t_warehousearea`.`areaId`)))
md5=ab5b16e8ba3d8332115a55122959b6d6
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_stock`.`stockId` AS `stockId`,`t_stock`.`goodsId` AS `goodsId`,`t_stock`.`instockTime` AS `instockTime`,`t_stock`.`locationId` AS `locationId`,`t_stock`.`productBatch` AS `productBatch`,`t_stock`.`quantity` AS `quantity`,`t_stock`.`supplierId` AS `supplierId`,`t_stock`.`orderNo` AS `orderNo`,`t_goods`.`goodsCode` AS `goodsCode`,`t_goods`.`goodsName` AS `goodsName`,`t_supplier`.`supplierName` AS `supplierName`,`t_warehouselocation`.`locationNo` AS `locationNo`,`t_warehouselocation`.`areaId` AS `areaId`,`t_warehousearea`.`areaNature` AS `areaNature`,`t_warehousearea`.`areaName` AS `areaName`,`t_warehousearea`.`status` AS `areaStatus`,`t_supplier`.`status` AS `supplierStatus`,`t_goods`.`status` AS `goodsStatus`,`t_warehouselocation`.`status` AS `locationStatus` from ((((`t_goods` join `t_stock` on((`t_stock`.`goodsId` = `t_goods`.`goodsId`))) join `t_supplier` on((`t_stock`.`supplierId` = `t_supplier`.`supplierId`))) join `t_warehouselocation` on((`t_stock`.`locationId` = `t_warehouselocation`.`locationId`))) join `t_warehousearea` on((`t_warehouselocation`.`areaId` = `t_warehousearea`.`areaId`)))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_stock`.`stockId` AS `stockId`,`wmsdb`.`t_stock`.`goodsId` AS `goodsId`,`wmsdb`.`t_stock`.`instockTime` AS `instockTime`,`wmsdb`.`t_stock`.`locationId` AS `locationId`,`wmsdb`.`t_stock`.`productBatch` AS `productBatch`,`wmsdb`.`t_stock`.`quantity` AS `quantity`,`wmsdb`.`t_stock`.`supplierId` AS `supplierId`,`wmsdb`.`t_stock`.`orderNo` AS `orderNo`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_warehouselocation`.`locationNo` AS `locationNo`,`wmsdb`.`t_warehouselocation`.`areaId` AS `areaId`,`wmsdb`.`t_warehousearea`.`areaNature` AS `areaNature`,`wmsdb`.`t_warehousearea`.`areaName` AS `areaName`,`wmsdb`.`t_warehousearea`.`status` AS `areaStatus`,`wmsdb`.`t_supplier`.`status` AS `supplierStatus`,`wmsdb`.`t_goods`.`status` AS `goodsStatus`,`wmsdb`.`t_warehouselocation`.`status` AS `locationStatus` from ((((`wmsdb`.`t_goods` join `wmsdb`.`t_stock` on((`wmsdb`.`t_stock`.`goodsId` = `wmsdb`.`t_goods`.`goodsId`))) join `wmsdb`.`t_supplier` on((`wmsdb`.`t_stock`.`supplierId` = `wmsdb`.`t_supplier`.`supplierId`))) join `wmsdb`.`t_warehouselocation` on((`wmsdb`.`t_stock`.`locationId` = `wmsdb`.`t_warehouselocation`.`locationId`))) join `wmsdb`.`t_warehousearea` on((`wmsdb`.`t_warehouselocation`.`areaId` = `wmsdb`.`t_warehousearea`.`areaId`)))
