Inicio Explorar Ayuda
Registro Iniciar sesión
xuyiping
/
docker-compose
1
0
Fork 0
Archivos Incidencias 0 Pull Requests 0 Wiki
Rama: master
Ramas Etiquetas
docker-compose
/
mysql5.7
/
mysql
/
data
/
heatwatch
/
lcview.frm

lcview.frm 4.3 KB
Permalink Histórico Raw

123456789101112131415 
  1. TYPE=VIEW
    2. 

  2. query=select `evtleave`.`intPastureId` AS `intPastureId`,`evtleave`.`intEvtId` AS `intEvtId`,`evtleave`.`intCowId` AS `evtCowId`,`evtleave`.`dateEvtDate` AS `evtleaveDate`,`evtleave`.`varNotes` AS `evtleaveNotes`,`heatwatch`.`employee`.`varEmployeeName` AS `leavePersoner`,`c1`.`varName` AS `intLeaveClass`,`c2`.`varName` AS `intReason`,`heatwatch`.`custom`.`varCustomName` AS `varCustomName`,`heatwatch`.`leave`.`decWeight` AS `decWeight`,`heatwatch`.`leave`.`mPrice` AS `mPrice`,`heatwatch`.`leave`.`milkDays` AS `milkDays`,`heatwatch`.`leave`.`DaysAge` AS `DaysAge` from (((((`heatwatch`.`events` `evtleave` join `heatwatch`.`leave` on(((`evtleave`.`intEvtId` = `heatwatch`.`leave`.`intEvtId`) and (`evtleave`.`intPastureId` = `heatwatch`.`leave`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtleave`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtleave`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`)))) left join `heatwatch`.`classlist` `c1` on(((`heatwatch`.`leave`.`intLeaveClass` = `c1`.`intClassListId`) and (`heatwatch`.`leave`.`intPastureId` = `c1`.`intPastureId`)))) left join `heatwatch`.`classlist` `c2` on(((`heatwatch`.`leave`.`intReason` = `c2`.`intClassListId`) and (`heatwatch`.`leave`.`intPastureId` = `c2`.`intPastureId`)))) left join `heatwatch`.`custom` on(((`heatwatch`.`leave`.`varGoWhere` = `heatwatch`.`custom`.`intCustomId`) and (`heatwatch`.`leave`.`intPastureId` = `heatwatch`.`custom`.`intPastureId`))))
    3. 

  3. md5=e56d8a2589601c704cfe56b6b2d36c69
    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=2022-12-14 10:07:38
    11. 

  11. create-version=1
    12. 

  12. source=select `evtleave`.`intPastureId` AS `intPastureId`,`evtleave`.`intEvtId` AS `intEvtId`,`evtleave`.`intCowId` AS `evtCowId`,`evtleave`.`dateEvtDate` AS `evtleaveDate`,`evtleave`.`varNotes` AS `evtleaveNotes`,`employee`.`varEmployeeName` AS `leavePersoner`,`c1`.`varName` AS `intLeaveClass`,`c2`.`varName` AS `intReason`,`custom`.`varCustomName` AS `varCustomName`,`leave`.`decWeight` AS `decWeight`,`leave`.`mPrice` AS `mPrice`,`leave`.`milkDays` AS `milkDays`,`leave`.`DaysAge` AS `DaysAge` from (((((`events` `evtleave` join `leave` on(`evtleave`.`intEvtId` = `leave`.`intEvtId` and `evtleave`.`intPastureId` = `leave`.`intPastureId`)) left join `employee` on(`evtleave`.`intPersoner` = `employee`.`intEmployeeId` and `evtleave`.`intPastureId` = `employee`.`intPastureId`)) left join `classlist` `c1` on(`leave`.`intLeaveClass` = `c1`.`intClassListId` and `leave`.`intPastureId` = `c1`.`intPastureId`)) left join `classlist` `c2` on(`leave`.`intReason` = `c2`.`intClassListId` and `leave`.`intPastureId` = `c2`.`intPastureId`)) left join `custom` on(`leave`.`varGoWhere` = `custom`.`intCustomId` and `leave`.`intPastureId` = `custom`.`intPastureId`))
    13. 

  13. client_cs_name=utf8
    14. 

  14. connection_cl_name=utf8_general_ci
    15. 

  15. view_body_utf8=select `evtleave`.`intPastureId` AS `intPastureId`,`evtleave`.`intEvtId` AS `intEvtId`,`evtleave`.`intCowId` AS `evtCowId`,`evtleave`.`dateEvtDate` AS `evtleaveDate`,`evtleave`.`varNotes` AS `evtleaveNotes`,`heatwatch`.`employee`.`varEmployeeName` AS `leavePersoner`,`c1`.`varName` AS `intLeaveClass`,`c2`.`varName` AS `intReason`,`heatwatch`.`custom`.`varCustomName` AS `varCustomName`,`heatwatch`.`leave`.`decWeight` AS `decWeight`,`heatwatch`.`leave`.`mPrice` AS `mPrice`,`heatwatch`.`leave`.`milkDays` AS `milkDays`,`heatwatch`.`leave`.`DaysAge` AS `DaysAge` from (((((`heatwatch`.`events` `evtleave` join `heatwatch`.`leave` on(((`evtleave`.`intEvtId` = `heatwatch`.`leave`.`intEvtId`) and (`evtleave`.`intPastureId` = `heatwatch`.`leave`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtleave`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtleave`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`)))) left join `heatwatch`.`classlist` `c1` on(((`heatwatch`.`leave`.`intLeaveClass` = `c1`.`intClassListId`) and (`heatwatch`.`leave`.`intPastureId` = `c1`.`intPastureId`)))) left join `heatwatch`.`classlist` `c2` on(((`heatwatch`.`leave`.`intReason` = `c2`.`intClassListId`) and (`heatwatch`.`leave`.`intPastureId` = `c2`.`intPastureId`)))) left join `heatwatch`.`custom` on(((`heatwatch`.`leave`.`varGoWhere` = `heatwatch`.`custom`.`intCustomId`) and (`heatwatch`.`leave`.`intPastureId` = `heatwatch`.`custom`.`intPastureId`))))
    16.