v_test_rpt.frm 1.3 KB

123456789101112131415
  1. TYPE=VIEW
  2. query=(select `a`.`intEvtId` AS `intEvtId`,`a`.`dateEvtDate` AS `dateEvtDate`,`a`.`intClass` AS `intClass`,`a`.`NewClass` AS `NewClass`,`a`.`NewState` AS `NewState`,`a`.`intCowId` AS `intCowId`,`c`.`sireClass` AS `sireClass`,`c`.`belongState` AS `belongState` from (`heatwatch`.`events` `a` join `heatwatch`.`cow` `c`) where (`a`.`intCowId` = `c`.`intCowId`))
  3. md5=d2e7aae5539af8880d6bd738de16fde8
  4. updatable=1
  5. algorithm=0
  6. definer_user=root
  7. definer_host=localhost
  8. suid=1
  9. with_check_option=0
  10. timestamp=2022-12-14 10:07:39
  11. create-version=1
  12. source=(select `a`.`intEvtId` AS `intEvtId`,`a`.`dateEvtDate` AS `dateEvtDate`,`a`.`intClass` AS `intClass`,`a`.`NewClass` AS `NewClass`,`a`.`NewState` AS `NewState`,`a`.`intCowId` AS `intCowId`,`c`.`sireClass` AS `sireClass`,`c`.`belongState` AS `belongState` from (`events` `a` join `cow` `c`) where `a`.`intCowId` = `c`.`intCowId`)
  13. client_cs_name=utf8
  14. connection_cl_name=utf8_general_ci
  15. view_body_utf8=(select `a`.`intEvtId` AS `intEvtId`,`a`.`dateEvtDate` AS `dateEvtDate`,`a`.`intClass` AS `intClass`,`a`.`NewClass` AS `NewClass`,`a`.`NewState` AS `NewState`,`a`.`intCowId` AS `intCowId`,`c`.`sireClass` AS `sireClass`,`c`.`belongState` AS `belongState` from (`heatwatch`.`events` `a` join `heatwatch`.`cow` `c`) where (`a`.`intCowId` = `c`.`intCowId`))