TYPE=VIEW
query=select `wmsdb`.`t_goods`.`goodsId` AS `goodsId`,`wmsdb`.`t_goods`.`gcId` AS `gcId`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_goods`.`innerPackingQuantity` AS `innerPackingQuantity`,`wmsdb`.`t_goods`.`innerPackingVolume` AS `innerPackingVolume`,`wmsdb`.`t_goods`.`innerPackingWeight` AS `innerPackingWeight`,`wmsdb`.`t_goods`.`material` AS `material`,`wmsdb`.`t_goods`.`maxStock` AS `maxStock`,`wmsdb`.`t_goods`.`minStock` AS `minStock`,`wmsdb`.`t_goods`.`outerPackingQuantity` AS `outerPackingQuantity`,`wmsdb`.`t_goods`.`outerPackingVolume` AS `outerPackingVolume`,`wmsdb`.`t_goods`.`outerPackingWeight` AS `outerPackingWeight`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_goods`.`shelfLife` AS `shelfLife`,`wmsdb`.`t_goods`.`specs` AS `specs`,`wmsdb`.`t_goods`.`status` AS `status`,`wmsdb`.`t_goods`.`supplierId` AS `supplierId`,`wmsdb`.`t_goods`.`weight` AS `weight`,`wmsdb`.`t_goodscategory`.`name` AS `goodsCategoryName`,`wmsdb`.`t_goodscategory`.`parentId` AS `parentId`,`t_parentgoodscategory`.`name` AS `parentGoodsCategoryName`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_supplier`.`supplierCode` AS `supplierCode`,`wmsdb`.`t_supplier`.`status` AS `supplierStatus`,`t_parentgoodscategory`.`status` AS `goodsCategoryStatus` from (((`wmsdb`.`t_goods` join `wmsdb`.`t_goodscategory` on((`wmsdb`.`t_goodscategory`.`gcId` = `wmsdb`.`t_goods`.`gcId`))) join `wmsdb`.`t_supplier` on((`wmsdb`.`t_supplier`.`supplierId` = `wmsdb`.`t_goods`.`supplierId`))) left join `wmsdb`.`t_goodscategory` `t_parentgoodscategory` on((`wmsdb`.`t_goodscategory`.`parentId` = `t_parentgoodscategory`.`gcId`)))
md5=f21eb1b280328b1d94664a9ca7307f40
updatable=0
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2016-01-12 06:00:59
create-version=1
source=select `t_goods`.`goodsId` AS `goodsId`,`t_goods`.`gcId` AS `gcId`,`t_goods`.`goodsCode` AS `goodsCode`,`t_goods`.`goodsName` AS `goodsName`,`t_goods`.`innerPackingQuantity` AS `innerPackingQuantity`,`t_goods`.`innerPackingVolume` AS `innerPackingVolume`,`t_goods`.`innerPackingWeight` AS `innerPackingWeight`,`t_goods`.`material` AS `material`,`t_goods`.`maxStock` AS `maxStock`,`t_goods`.`minStock` AS `minStock`,`t_goods`.`outerPackingQuantity` AS `outerPackingQuantity`,`t_goods`.`outerPackingVolume` AS `outerPackingVolume`,`t_goods`.`outerPackingWeight` AS `outerPackingWeight`,`t_goods`.`price` AS `price`,`t_goods`.`shelfLife` AS `shelfLife`,`t_goods`.`specs` AS `specs`,`t_goods`.`status` AS `status`,`t_goods`.`supplierId` AS `supplierId`,`t_goods`.`weight` AS `weight`,`t_goodscategory`.`name` AS `goodsCategoryName`,`t_goodscategory`.`parentId` AS `parentId`,`t_parentgoodscategory`.`name` AS `parentGoodsCategoryName`,`t_supplier`.`supplierName` AS `supplierName`,`t_supplier`.`supplierCode` AS `supplierCode`,`t_supplier`.`status` AS `supplierStatus`,`t_parentgoodscategory`.`status` AS `goodsCategoryStatus` from (((`t_goods` join `t_goodscategory` on((`t_goodscategory`.`gcId` = `t_goods`.`gcId`))) join `t_supplier` on((`t_supplier`.`supplierId` = `t_goods`.`supplierId`))) left join `t_goodscategory` `t_parentgoodscategory` on((`t_goodscategory`.`parentId` = `t_parentgoodscategory`.`gcId`)))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_goods`.`goodsId` AS `goodsId`,`wmsdb`.`t_goods`.`gcId` AS `gcId`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_goods`.`innerPackingQuantity` AS `innerPackingQuantity`,`wmsdb`.`t_goods`.`innerPackingVolume` AS `innerPackingVolume`,`wmsdb`.`t_goods`.`innerPackingWeight` AS `innerPackingWeight`,`wmsdb`.`t_goods`.`material` AS `material`,`wmsdb`.`t_goods`.`maxStock` AS `maxStock`,`wmsdb`.`t_goods`.`minStock` AS `minStock`,`wmsdb`.`t_goods`.`outerPackingQuantity` AS `outerPackingQuantity`,`wmsdb`.`t_goods`.`outerPackingVolume` AS `outerPackingVolume`,`wmsdb`.`t_goods`.`outerPackingWeight` AS `outerPackingWeight`,`wmsdb`.`t_goods`.`price` AS `price`,`wmsdb`.`t_goods`.`shelfLife` AS `shelfLife`,`wmsdb`.`t_goods`.`specs` AS `specs`,`wmsdb`.`t_goods`.`status` AS `status`,`wmsdb`.`t_goods`.`supplierId` AS `supplierId`,`wmsdb`.`t_goods`.`weight` AS `weight`,`wmsdb`.`t_goodscategory`.`name` AS `goodsCategoryName`,`wmsdb`.`t_goodscategory`.`parentId` AS `parentId`,`t_parentgoodscategory`.`name` AS `parentGoodsCategoryName`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_supplier`.`supplierCode` AS `supplierCode`,`wmsdb`.`t_supplier`.`status` AS `supplierStatus`,`t_parentgoodscategory`.`status` AS `goodsCategoryStatus` from (((`wmsdb`.`t_goods` join `wmsdb`.`t_goodscategory` on((`wmsdb`.`t_goodscategory`.`gcId` = `wmsdb`.`t_goods`.`gcId`))) join `wmsdb`.`t_supplier` on((`wmsdb`.`t_supplier`.`supplierId` = `wmsdb`.`t_goods`.`supplierId`))) left join `wmsdb`.`t_goodscategory` `t_parentgoodscategory` on((`wmsdb`.`t_goodscategory`.`parentId` = `t_parentgoodscategory`.`gcId`)))
