TYPE=VIEW
query=select `wmsdb`.`t_demander`.`demanderId` AS `demanderId`,`wmsdb`.`t_demander`.`account` AS `account`,`wmsdb`.`t_demander`.`address` AS `address`,`wmsdb`.`t_demander`.`bank` AS `bank`,`wmsdb`.`t_demander`.`contacts1` AS `contacts1`,`wmsdb`.`t_demander`.`contacts2` AS `contacts2`,`wmsdb`.`t_demander`.`corporation` AS `corporation`,`wmsdb`.`t_demander`.`demanderBeginDate` AS `demanderBeginDate`,`wmsdb`.`t_demander`.`demanderCode` AS `demanderCode`,`wmsdb`.`t_demander`.`demanderEndDate` AS `demanderEndDate`,`wmsdb`.`t_demander`.`demanderName` AS `demanderName`,`wmsdb`.`t_demander`.`demanderNature` AS `demanderNature`,`wmsdb`.`t_demander`.`status` AS `status`,`wmsdb`.`t_demander`.`tariff` AS `tariff`,`wmsdb`.`t_demander`.`tel1` AS `tel1`,`wmsdb`.`t_demander`.`tel2` AS `tel2`,`wmsdb`.`t_dict`.`dictName` AS `natureName`,`wmsdb`.`t_dict`.`dictType` AS `dictType`,`wmsdb`.`t_dict`.`status` AS `demanderStatus`,`wmsdb`.`t_dict`.`dictId` AS `dictId` from (`wmsdb`.`t_demander` left join `wmsdb`.`t_dict` on((`wmsdb`.`t_demander`.`demanderNature` = `wmsdb`.`t_dict`.`dictId`))) where (`wmsdb`.`t_dict`.`dictType` = 2)
md5=9689f7f4490a6ed41638a9b69041c570
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_demander`.`demanderId` AS `demanderId`,`t_demander`.`account` AS `account`,`t_demander`.`address` AS `address`,`t_demander`.`bank` AS `bank`,`t_demander`.`contacts1` AS `contacts1`,`t_demander`.`contacts2` AS `contacts2`,`t_demander`.`corporation` AS `corporation`,`t_demander`.`demanderBeginDate` AS `demanderBeginDate`,`t_demander`.`demanderCode` AS `demanderCode`,`t_demander`.`demanderEndDate` AS `demanderEndDate`,`t_demander`.`demanderName` AS `demanderName`,`t_demander`.`demanderNature` AS `demanderNature`,`t_demander`.`status` AS `status`,`t_demander`.`tariff` AS `tariff`,`t_demander`.`tel1` AS `tel1`,`t_demander`.`tel2` AS `tel2`,`t_dict`.`dictName` AS `natureName`,`t_dict`.`dictType` AS `dictType`,`t_dict`.`status` AS `demanderStatus`,`t_dict`.`dictId` AS `dictId` from (`t_demander` left join `t_dict` on((`t_demander`.`demanderNature` = `t_dict`.`dictId`))) where (`t_dict`.`dictType` = 2)
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_demander`.`demanderId` AS `demanderId`,`wmsdb`.`t_demander`.`account` AS `account`,`wmsdb`.`t_demander`.`address` AS `address`,`wmsdb`.`t_demander`.`bank` AS `bank`,`wmsdb`.`t_demander`.`contacts1` AS `contacts1`,`wmsdb`.`t_demander`.`contacts2` AS `contacts2`,`wmsdb`.`t_demander`.`corporation` AS `corporation`,`wmsdb`.`t_demander`.`demanderBeginDate` AS `demanderBeginDate`,`wmsdb`.`t_demander`.`demanderCode` AS `demanderCode`,`wmsdb`.`t_demander`.`demanderEndDate` AS `demanderEndDate`,`wmsdb`.`t_demander`.`demanderName` AS `demanderName`,`wmsdb`.`t_demander`.`demanderNature` AS `demanderNature`,`wmsdb`.`t_demander`.`status` AS `status`,`wmsdb`.`t_demander`.`tariff` AS `tariff`,`wmsdb`.`t_demander`.`tel1` AS `tel1`,`wmsdb`.`t_demander`.`tel2` AS `tel2`,`wmsdb`.`t_dict`.`dictName` AS `natureName`,`wmsdb`.`t_dict`.`dictType` AS `dictType`,`wmsdb`.`t_dict`.`status` AS `demanderStatus`,`wmsdb`.`t_dict`.`dictId` AS `dictId` from (`wmsdb`.`t_demander` left join `wmsdb`.`t_dict` on((`wmsdb`.`t_demander`.`demanderNature` = `wmsdb`.`t_dict`.`dictId`))) where (`wmsdb`.`t_dict`.`dictType` = 2)
