TYPE=VIEW
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`
md5=bc1debd09f1bc2a6b359364b07afed19
updatable=0
algorithm=0
definer_user=roo
definer_host=%
suid=1
with_check_option=0
timestamp=2022-12-14 10:07:39
create-version=1
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`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
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`