TYPE=VIEW
query=select `tmrwatch`.`downloadplandtl2`.`ID` AS `ID`,`tmrwatch`.`downloadplandtl2`.`FBarID` AS `FBarID`,`tmrwatch`.`downloadedplan`.`Mydate` AS `Mydate`,`tmrwatch`.`downloadedplan`.`TodayID` AS `TodayID`,`tmrwatch`.`downloadedplan`.`MobileMacNo` AS `MobileMacNo`,`tmrwatch`.`downloadedplan`.`DataCaptureNo` AS `DataCaptureNo`,`tmrwatch`.`downloadplandtl2`.`LastOpID` AS `LastOpId` from (`tmrwatch`.`downloadplandtl2` join `tmrwatch`.`downloadedplan` on(`tmrwatch`.`downloadplandtl2`.`PID` = `tmrwatch`.`downloadedplan`.`id`))
md5=366ed1893adc9c732747ee6daf1aeee0
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 `downloadplandtl2`.`ID` AS `ID`,`downloadplandtl2`.`FBarID` AS `FBarID`,`downloadedplan`.`Mydate` AS `Mydate`,`downloadedplan`.`TodayID` AS `TodayID`,`downloadedplan`.`MobileMacNo` AS `MobileMacNo`,`downloadedplan`.`DataCaptureNo` AS `DataCaptureNo`,`downloadplandtl2`.`LastOpID` AS `LastOpId` from (`downloadplandtl2` join `downloadedplan` on((`downloadplandtl2`.`PID` = `downloadedplan`.`id`)))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `tmrwatch`.`downloadplandtl2`.`ID` AS `ID`,`tmrwatch`.`downloadplandtl2`.`FBarID` AS `FBarID`,`tmrwatch`.`downloadedplan`.`Mydate` AS `Mydate`,`tmrwatch`.`downloadedplan`.`TodayID` AS `TodayID`,`tmrwatch`.`downloadedplan`.`MobileMacNo` AS `MobileMacNo`,`tmrwatch`.`downloadedplan`.`DataCaptureNo` AS `DataCaptureNo`,`tmrwatch`.`downloadplandtl2`.`LastOpID` AS `LastOpId` from (`tmrwatch`.`downloadplandtl2` join `tmrwatch`.`downloadedplan` on(`tmrwatch`.`downloadplandtl2`.`PID` = `tmrwatch`.`downloadedplan`.`id`))
mariadb-version=100511