TYPE=VIEW
query=select `wmsdb`.`t_dict`.`dictType` AS `dictType`,`wmsdb`.`t_supplier`.`supplierId` AS `supplierId`,`wmsdb`.`t_supplier`.`account` AS `account`,`wmsdb`.`t_supplier`.`address` AS `address`,`wmsdb`.`t_supplier`.`bank` AS `bank`,`wmsdb`.`t_supplier`.`contacts1` AS `contacts1`,`wmsdb`.`t_supplier`.`contacts2` AS `contacts2`,`wmsdb`.`t_supplier`.`corporation` AS `corporation`,`wmsdb`.`t_supplier`.`status` AS `status`,`wmsdb`.`t_supplier`.`supplierCode` AS `supplierCode`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_supplier`.`supplierNature` AS `supplierNature`,`wmsdb`.`t_supplier`.`supplyBeginDate` AS `supplyBeginDate`,`wmsdb`.`t_supplier`.`supplyEndDate` AS `supplyEndDate`,`wmsdb`.`t_supplier`.`tariff` AS `tariff`,`wmsdb`.`t_supplier`.`tel1` AS `tel1`,`wmsdb`.`t_supplier`.`tel2` AS `tel2`,`wmsdb`.`t_dict`.`dictName` AS `natureName`,`wmsdb`.`t_dict`.`dictId` AS `dictId`,`wmsdb`.`t_dict`.`status` AS `supplierStatus` from (`wmsdb`.`t_dict` join `wmsdb`.`t_supplier` on((`wmsdb`.`t_dict`.`dictId` = `wmsdb`.`t_supplier`.`supplierNature`))) where (`wmsdb`.`t_dict`.`dictType` = 1)
md5=8a39c3fc11ca44b4c2938937a0526016
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_dict`.`dictType` AS `dictType`,`t_supplier`.`supplierId` AS `supplierId`,`t_supplier`.`account` AS `account`,`t_supplier`.`address` AS `address`,`t_supplier`.`bank` AS `bank`,`t_supplier`.`contacts1` AS `contacts1`,`t_supplier`.`contacts2` AS `contacts2`,`t_supplier`.`corporation` AS `corporation`,`t_supplier`.`status` AS `status`,`t_supplier`.`supplierCode` AS `supplierCode`,`t_supplier`.`supplierName` AS `supplierName`,`t_supplier`.`supplierNature` AS `supplierNature`,`t_supplier`.`supplyBeginDate` AS `supplyBeginDate`,`t_supplier`.`supplyEndDate` AS `supplyEndDate`,`t_supplier`.`tariff` AS `tariff`,`t_supplier`.`tel1` AS `tel1`,`t_supplier`.`tel2` AS `tel2`,`t_dict`.`dictName` AS `natureName`,`t_dict`.`dictId` AS `dictId`,`t_dict`.`status` AS `supplierStatus` from (`t_dict` join `t_supplier` on((`t_dict`.`dictId` = `t_supplier`.`supplierNature`))) where (`t_dict`.`dictType` = 1)
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_dict`.`dictType` AS `dictType`,`wmsdb`.`t_supplier`.`supplierId` AS `supplierId`,`wmsdb`.`t_supplier`.`account` AS `account`,`wmsdb`.`t_supplier`.`address` AS `address`,`wmsdb`.`t_supplier`.`bank` AS `bank`,`wmsdb`.`t_supplier`.`contacts1` AS `contacts1`,`wmsdb`.`t_supplier`.`contacts2` AS `contacts2`,`wmsdb`.`t_supplier`.`corporation` AS `corporation`,`wmsdb`.`t_supplier`.`status` AS `status`,`wmsdb`.`t_supplier`.`supplierCode` AS `supplierCode`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_supplier`.`supplierNature` AS `supplierNature`,`wmsdb`.`t_supplier`.`supplyBeginDate` AS `supplyBeginDate`,`wmsdb`.`t_supplier`.`supplyEndDate` AS `supplyEndDate`,`wmsdb`.`t_supplier`.`tariff` AS `tariff`,`wmsdb`.`t_supplier`.`tel1` AS `tel1`,`wmsdb`.`t_supplier`.`tel2` AS `tel2`,`wmsdb`.`t_dict`.`dictName` AS `natureName`,`wmsdb`.`t_dict`.`dictId` AS `dictId`,`wmsdb`.`t_dict`.`status` AS `supplierStatus` from (`wmsdb`.`t_dict` join `wmsdb`.`t_supplier` on((`wmsdb`.`t_dict`.`dictId` = `wmsdb`.`t_supplier`.`supplierNature`))) where (`wmsdb`.`t_dict`.`dictType` = 1)
