Home Explore Help
Register Sign In
zhuhongbin
/
TMRWatchNew
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 6b9a3e5c7b
Branches Tags
TMRWatchNew
/
linux安装方法
/
TMRWatch
/
data
/
mysql
/
tmrwatch
/
currentprojinfo.frm

currentprojinfo.frm 4.2 KB
History Raw

12345678910111213141516 
  1. TYPE=VIEW
    2. 

  2. query=select `currentprojid`.`MobileMacNo` AS `inputMobileMacNo`,`tmrwatch`.`newesttmrweighttime`.`TNAME` AS `TNAME`,`tmrwatch`.`newesttmrweighttime`.`tmrID` AS `tmrID`,`tmrwatch`.`newesttmrweighttime`.`DataCaptureNo` AS `DataCaptureNo`,`tmrwatch`.`newesttmrweighttime`.`fname` AS `FNAME`,`tmrwatch`.`newesttmrweighttime`.`BNAME` AS `BNAME`,`tmrwatch`.`newesttmrweighttime`.`recbuttonID` AS `recbuttonID`,`tmrwatch`.`newesttmrweighttime`.`ObjAddr` AS `ObjAddr`,`tmrwatch`.`newesttmrweighttime`.`SrcAddr` AS `SrcAddr`,`tmrwatch`.`newesttmrweighttime`.`InTime` AS `InTime`,`tmrwatch`.`newesttmrweighttime`.`ButtonType` AS `ButtonType`,`tmrwatch`.`newesttmrweighttime`.`ProjTodayID` AS `ProjTodayID`,`tmrwatch`.`newesttmrweighttime`.`Pid` AS `Pid`,`tmrwatch`.`newesttmrweighttime`.`downloadedplanid` AS `downloadedplanid`,`tmrwatch`.`newesttmrweighttime`.`Mydate` AS `Mydate`,`tmrwatch`.`newesttmrweighttime`.`TodayID` AS `TodayID`,`tmrwatch`.`newesttmrweighttime`.`ProjName` AS `ProjName`,`tmrwatch`.`newesttmrweighttime`.`Minutes` AS `Minutes`,`tmrwatch`.`newesttmrweighttime`.`ItemNum` AS `ItemNum`,`tmrwatch`.`newesttmrweighttime`.`MobileMacNo` AS `MobileMacNo`,`tmrwatch`.`newesttmrweighttime`.`FeedItemID` AS `FeedItemID`,`tmrwatch`.`newesttmrweighttime`.`OperateName` AS `OperateName` from (`tmrwatch`.`currentprojid` join `tmrwatch`.`newesttmrweighttime` on(`currentprojid`.`recbuttonID` = `tmrwatch`.`newesttmrweighttime`.`recbuttonID`))
    3. 

  3. md5=e7a8a330fe2aaec948630055919b3a55
    4. 

  4. updatable=0
    5. 

  5. algorithm=0
    6. 

  6. definer_user=root
    7. 

  7. definer_host=localhost
    8. 

  8. suid=1
    9. 

  9. with_check_option=0
    10. 

  10. timestamp=2021-12-05 04:06:49
    11. 

  11. create-version=2
    12. 

  12. source=select `currentprojid`.`MobileMacNo` AS `inputMobileMacNo`,`newesttmrweighttime`.`TNAME` AS `TNAME`,`newesttmrweighttime`.`tmrID` AS `tmrID`,`newesttmrweighttime`.`DataCaptureNo` AS `DataCaptureNo`,`newesttmrweighttime`.`fname` AS `FNAME`,`newesttmrweighttime`.`BNAME` AS `BNAME`,`newesttmrweighttime`.`recbuttonID` AS `recbuttonID`,`newesttmrweighttime`.`ObjAddr` AS `ObjAddr`,`newesttmrweighttime`.`SrcAddr` AS `SrcAddr`,`newesttmrweighttime`.`InTime` AS `InTime`,`newesttmrweighttime`.`ButtonType` AS `ButtonType`,`newesttmrweighttime`.`ProjTodayID` AS `ProjTodayID`,`newesttmrweighttime`.`Pid` AS `Pid`,`newesttmrweighttime`.`downloadedplanid` AS `downloadedplanid`,`newesttmrweighttime`.`Mydate` AS `Mydate`,`newesttmrweighttime`.`TodayID` AS `TodayID`,`newesttmrweighttime`.`ProjName` AS `ProjName`,`newesttmrweighttime`.`Minutes` AS `Minutes`,`newesttmrweighttime`.`ItemNum` AS `ItemNum`,`newesttmrweighttime`.`MobileMacNo` AS `MobileMacNo`,`newesttmrweighttime`.`FeedItemID` AS `FeedItemID`,`newesttmrweighttime`.`OperateName` AS `OperateName` from (`currentprojid` join `newesttmrweighttime` on((`currentprojid`.`recbuttonID` = `newesttmrweighttime`.`recbuttonID`)))
    13. 

  13. client_cs_name=utf8
    14. 

  14. connection_cl_name=utf8_general_ci
    15. 

  15. view_body_utf8=select `currentprojid`.`MobileMacNo` AS `inputMobileMacNo`,`tmrwatch`.`newesttmrweighttime`.`TNAME` AS `TNAME`,`tmrwatch`.`newesttmrweighttime`.`tmrID` AS `tmrID`,`tmrwatch`.`newesttmrweighttime`.`DataCaptureNo` AS `DataCaptureNo`,`tmrwatch`.`newesttmrweighttime`.`fname` AS `FNAME`,`tmrwatch`.`newesttmrweighttime`.`BNAME` AS `BNAME`,`tmrwatch`.`newesttmrweighttime`.`recbuttonID` AS `recbuttonID`,`tmrwatch`.`newesttmrweighttime`.`ObjAddr` AS `ObjAddr`,`tmrwatch`.`newesttmrweighttime`.`SrcAddr` AS `SrcAddr`,`tmrwatch`.`newesttmrweighttime`.`InTime` AS `InTime`,`tmrwatch`.`newesttmrweighttime`.`ButtonType` AS `ButtonType`,`tmrwatch`.`newesttmrweighttime`.`ProjTodayID` AS `ProjTodayID`,`tmrwatch`.`newesttmrweighttime`.`Pid` AS `Pid`,`tmrwatch`.`newesttmrweighttime`.`downloadedplanid` AS `downloadedplanid`,`tmrwatch`.`newesttmrweighttime`.`Mydate` AS `Mydate`,`tmrwatch`.`newesttmrweighttime`.`TodayID` AS `TodayID`,`tmrwatch`.`newesttmrweighttime`.`ProjName` AS `ProjName`,`tmrwatch`.`newesttmrweighttime`.`Minutes` AS `Minutes`,`tmrwatch`.`newesttmrweighttime`.`ItemNum` AS `ItemNum`,`tmrwatch`.`newesttmrweighttime`.`MobileMacNo` AS `MobileMacNo`,`tmrwatch`.`newesttmrweighttime`.`FeedItemID` AS `FeedItemID`,`tmrwatch`.`newesttmrweighttime`.`OperateName` AS `OperateName` from (`tmrwatch`.`currentprojid` join `tmrwatch`.`newesttmrweighttime` on(`currentprojid`.`recbuttonID` = `tmrwatch`.`newesttmrweighttime`.`recbuttonID`))
    16. 

  16. mariadb-version=100511
    17.