v_v_milkdate.frm 1.0 KB

123456789101112131415
  1. TYPE=VIEW
  2. query=select `heatwatch`.`milk`.`intPastureId` AS `intPastureId`,`heatwatch`.`milk`.`milkDate` AS `milk_Date` from `heatwatch`.`milk` union select `heatwatch`.`milksale`.`intPastureId` AS `intPastureId`,`heatwatch`.`milksale`.`dateOddDate` AS `dateOddDate` from `heatwatch`.`milksale`
  3. md5=bc1debd09f1bc2a6b359364b07afed19
  4. updatable=0
  5. algorithm=0
  6. definer_user=roo
  7. definer_host=%
  8. suid=1
  9. with_check_option=0
  10. timestamp=2022-12-14 10:07:39
  11. create-version=1
  12. source=select `milk`.`intPastureId` AS `intPastureId`,`milk`.`milkDate` AS `milk_Date` from `milk` union select `milksale`.`intPastureId` AS `intPastureId`,`milksale`.`dateOddDate` AS `dateOddDate` from `milksale`
  13. client_cs_name=utf8
  14. connection_cl_name=utf8_general_ci
  15. view_body_utf8=select `heatwatch`.`milk`.`intPastureId` AS `intPastureId`,`heatwatch`.`milk`.`milkDate` AS `milk_Date` from `heatwatch`.`milk` union select `heatwatch`.`milksale`.`intPastureId` AS `intPastureId`,`heatwatch`.`milksale`.`dateOddDate` AS `dateOddDate` from `heatwatch`.`milksale`