TMRWatchNew/linux安装方法/TMRWatch/data/mysql/tmrwatch/dtl2_bar.frm

TYPE=VIEW
query=select `tmrwatch`.`lpplandtl2`.`ID` AS `ID`,`tmrwatch`.`lpplandtl2`.`PID` AS `PID`,`tmrwatch`.`lpplandtl2`.`FBarID` AS `FBarID`,`tmrwatch`.`lpplandtl2`.`LWEIGHT` AS `LWEIGHT`,`tmrwatch`.`lpplandtl2`.`SORT` AS `SORT`,concat(\'已投料在"\',`tmrwatch`.`feedp`.`BNAME`,\'"棚\') AS `BarName2`,`tmrwatch`.`feedp`.`BNAME` AS `BNAME` from (`tmrwatch`.`lpplandtl2` join `tmrwatch`.`feedp` on(`tmrwatch`.`lpplandtl2`.`FBarID` = `tmrwatch`.`feedp`.`ID`))
md5=c048c9a3a60262ce922fbf9e5aec5a20
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2021-12-05 04:06:49
create-version=2
source=select `lpplandtl2`.`ID` AS `ID`,`lpplandtl2`.`PID` AS `PID`,`lpplandtl2`.`FBarID` AS `FBarID`,`lpplandtl2`.`LWEIGHT` AS `LWEIGHT`,`lpplandtl2`.`SORT` AS `SORT`,concat(\'已投料在"\',`feedp`.`BNAME`,\'"棚\') AS `BarName2`,`feedp`.`BNAME` AS `BNAME` from (`lpplandtl2` join `feedp` on((`lpplandtl2`.`FBarID` = `feedp`.`ID`)))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `tmrwatch`.`lpplandtl2`.`ID` AS `ID`,`tmrwatch`.`lpplandtl2`.`PID` AS `PID`,`tmrwatch`.`lpplandtl2`.`FBarID` AS `FBarID`,`tmrwatch`.`lpplandtl2`.`LWEIGHT` AS `LWEIGHT`,`tmrwatch`.`lpplandtl2`.`SORT` AS `SORT`,concat(\'已投料在"\',`tmrwatch`.`feedp`.`BNAME`,\'"棚\') AS `BarName2`,`tmrwatch`.`feedp`.`BNAME` AS `BNAME` from (`tmrwatch`.`lpplandtl2` join `tmrwatch`.`feedp` on(`tmrwatch`.`lpplandtl2`.`FBarID` = `tmrwatch`.`feedp`.`ID`))
mariadb-version=100511