TYPE=VIEW
query=select `t_parentgoodscategory`.`name` AS `parentname`,`wmsdb`.`t_goodscategory`.`gcId` AS `gcId`,`wmsdb`.`t_goodscategory`.`name` AS `name`,`wmsdb`.`t_goodscategory`.`parentId` AS `parentId`,`wmsdb`.`t_goodscategory`.`status` AS `status`,`t_parentgoodscategory`.`gcId` AS `goodsParentId` from (`wmsdb`.`t_goodscategory` left join `wmsdb`.`t_goodscategory` `t_parentgoodscategory` on((`t_parentgoodscategory`.`gcId` = `wmsdb`.`t_goodscategory`.`parentId`)))
md5=f061f791c70e5331b2aebb2b0daca5ee
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_parentgoodscategory`.`name` AS `parentname`,`t_goodscategory`.`gcId` AS `gcId`,`t_goodscategory`.`name` AS `name`,`t_goodscategory`.`parentId` AS `parentId`,`t_goodscategory`.`status` AS `status`,`t_parentgoodscategory`.`gcId` AS `goodsParentId` from (`t_goodscategory` left join `t_goodscategory` `t_parentgoodscategory` on((`t_parentgoodscategory`.`gcId` = `t_goodscategory`.`parentId`)))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `t_parentgoodscategory`.`name` AS `parentname`,`wmsdb`.`t_goodscategory`.`gcId` AS `gcId`,`wmsdb`.`t_goodscategory`.`name` AS `name`,`wmsdb`.`t_goodscategory`.`parentId` AS `parentId`,`wmsdb`.`t_goodscategory`.`status` AS `status`,`t_parentgoodscategory`.`gcId` AS `goodsParentId` from (`wmsdb`.`t_goodscategory` left join `wmsdb`.`t_goodscategory` `t_parentgoodscategory` on((`t_parentgoodscategory`.`gcId` = `wmsdb`.`t_goodscategory`.`parentId`)))
