TYPE=VIEW
query=select `v_stock`.`goodsCode` AS `goodsCode`,`v_stock`.`goodsName` AS `goodsName`,`v_stock`.`supplierName` AS `supplierName`,`v_stock`.`areaName` AS `areaName`,`v_stock`.`locationNo` AS `locationNo`,`v_stock`.`quantity` AS `quantity`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_goods`.`outerPackingQuantity` AS `outerPackingQuantity`,`wmsdb`.`t_goods`.`innerPackingQuantity` AS `innerPackingQuantity`,`wmsdb`.`t_goods`.`outerPackingVolume` AS `outerPackingVolume`,`wmsdb`.`t_goods`.`outerPackingWeight` AS `outerPackingWeight`,`wmsdb`.`t_goods`.`innerPackingVolume` AS `innerPackingVolume`,`wmsdb`.`t_goods`.`innerPackingWeight` AS `innerPackingWeight`,`v_warehouselocationinfo`.`natureName` AS `natureName`,`v_stock`.`instockTime` AS `instockTime`,`v_stock`.`goodsId` AS `goodsId`,`v_stock`.`supplierId` AS `supplierId`,`v_stock`.`areaId` AS `areaId`,`v_stock`.`locationId` AS `locationId`,`v_warehouselocationinfo`.`natureId` AS `natureId`,`v_stock`.`stockId` AS `stockId` from ((`wmsdb`.`v_stock` join `wmsdb`.`t_goods` on((`wmsdb`.`t_goods`.`goodsId` = `v_stock`.`goodsId`))) join `wmsdb`.`v_warehouselocationinfo` on((`v_warehouselocationinfo`.`locationId` = `v_stock`.`locationId`)))
md5=df36fc6a90de95f5e333fce76a3863e8
updatable=1
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2016-01-12 06:01:59
create-version=1
source=select `v_stock`.`goodsCode` AS `goodsCode`,`v_stock`.`goodsName` AS `goodsName`,`v_stock`.`supplierName` AS `supplierName`,`v_stock`.`areaName` AS `areaName`,`v_stock`.`locationNo` AS `locationNo`,`v_stock`.`quantity` AS `quantity`,`t_goods`.`price` AS `price`,`t_goods`.`outerPackingQuantity` AS `outerPackingQuantity`,`t_goods`.`innerPackingQuantity` AS `innerPackingQuantity`,`t_goods`.`outerPackingVolume` AS `outerPackingVolume`,`t_goods`.`outerPackingWeight` AS `outerPackingWeight`,`t_goods`.`innerPackingVolume` AS `innerPackingVolume`,`t_goods`.`innerPackingWeight` AS `innerPackingWeight`,`v_warehouselocationinfo`.`natureName` AS `natureName`,`v_stock`.`instockTime` AS `instockTime`,`v_stock`.`goodsId` AS `goodsId`,`v_stock`.`supplierId` AS `supplierId`,`v_stock`.`areaId` AS `areaId`,`v_stock`.`locationId` AS `locationId`,`v_warehouselocationinfo`.`natureId` AS `natureId`,`v_stock`.`stockId` AS `stockId` from ((`v_stock` join `t_goods` on((`t_goods`.`goodsId` = `v_stock`.`goodsId`))) join `v_warehouselocationinfo` on((`v_warehouselocationinfo`.`locationId` = `v_stock`.`locationId`)))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v_stock`.`goodsCode` AS `goodsCode`,`v_stock`.`goodsName` AS `goodsName`,`v_stock`.`supplierName` AS `supplierName`,`v_stock`.`areaName` AS `areaName`,`v_stock`.`locationNo` AS `locationNo`,`v_stock`.`quantity` AS `quantity`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_goods`.`outerPackingQuantity` AS `outerPackingQuantity`,`wmsdb`.`t_goods`.`innerPackingQuantity` AS `innerPackingQuantity`,`wmsdb`.`t_goods`.`outerPackingVolume` AS `outerPackingVolume`,`wmsdb`.`t_goods`.`outerPackingWeight` AS `outerPackingWeight`,`wmsdb`.`t_goods`.`innerPackingVolume` AS `innerPackingVolume`,`wmsdb`.`t_goods`.`innerPackingWeight` AS `innerPackingWeight`,`v_warehouselocationinfo`.`natureName` AS `natureName`,`v_stock`.`instockTime` AS `instockTime`,`v_stock`.`goodsId` AS `goodsId`,`v_stock`.`supplierId` AS `supplierId`,`v_stock`.`areaId` AS `areaId`,`v_stock`.`locationId` AS `locationId`,`v_warehouselocationinfo`.`natureId` AS `natureId`,`v_stock`.`stockId` AS `stockId` from ((`wmsdb`.`v_stock` join `wmsdb`.`t_goods` on((`wmsdb`.`t_goods`.`goodsId` = `v_stock`.`goodsId`))) join `wmsdb`.`v_warehouselocationinfo` on((`v_warehouselocationinfo`.`locationId` = `v_stock`.`locationId`)))
