v_ref_dtl1_over.frm 1.2 KB

12345678910111213141516
  1. TYPE=VIEW
  2. query=select `tmrwatch`.`downloadplandtl1`.`ID` AS `ID`,`tmrwatch`.`downloadplandtl1`.`PID` AS `PID` from (`tmrwatch`.`downloadplandtl1` join `tmrwatch`.`feed` on(`tmrwatch`.`downloadplandtl1`.`FID` = `tmrwatch`.`feed`.`ID` and abs(`tmrwatch`.`downloadplandtl1`.`ErrRatio`) > `tmrwatch`.`feed`.`AllowRatio`)) where `tmrwatch`.`downloadplandtl1`.`ButtonSucc` = 1
  3. md5=cf2e53bd761f460d9f8ee79edd637c1b
  4. updatable=1
  5. algorithm=0
  6. definer_user=root
  7. definer_host=localhost
  8. suid=1
  9. with_check_option=0
  10. timestamp=2021-12-05 04:06:49
  11. create-version=2
  12. source=select `downloadplandtl1`.`ID` AS `ID`,`downloadplandtl1`.`PID` AS `PID` from (`downloadplandtl1` join `feed` on(((`downloadplandtl1`.`FID` = `feed`.`ID`) and (abs(`downloadplandtl1`.`ErrRatio`) > `feed`.`AllowRatio`)))) where (`downloadplandtl1`.`ButtonSucc` = 1)
  13. client_cs_name=utf8
  14. connection_cl_name=utf8_general_ci
  15. view_body_utf8=select `tmrwatch`.`downloadplandtl1`.`ID` AS `ID`,`tmrwatch`.`downloadplandtl1`.`PID` AS `PID` from (`tmrwatch`.`downloadplandtl1` join `tmrwatch`.`feed` on(`tmrwatch`.`downloadplandtl1`.`FID` = `tmrwatch`.`feed`.`ID` and abs(`tmrwatch`.`downloadplandtl1`.`ErrRatio`) > `tmrwatch`.`feed`.`AllowRatio`)) where `tmrwatch`.`downloadplandtl1`.`ButtonSucc` = 1
  16. mariadb-version=100511