Acasă Explorează Ajutor
Înregistrare Autentificare
xuyiping
/
docker-compose
1
0
Bifurcare 0
Fisiere Probleme 0 Trageți solicitările 0 Wiki
Ramură: master
Ramuri Etichete
docker-compose
/
mysql5.7
/
mysql
/
data
/
heatwatch
/
xtview.frm

xtview.frm 2.5 KB
Permalink Istoric Crud

123456789101112131415 
  1. TYPE=VIEW
    2. 

  2. query=select `evtfoot`.`intPastureId` AS `intPastureId`,`evtfoot`.`intEvtId` AS `intEvtId`,`evtfoot`.`intCowId` AS `evtCowId`,`evtfoot`.`dateEvtDate` AS `evtfootDate`,`heatwatch`.`employee`.`varEmployeeName` AS `footPersoner`,`evtfoot`.`varNotes` AS `varfootNotes`,(case when (`heatwatch`.`foot`.`IsRepaired` = 0) then \'否\' else \'是\' end) AS `footIsRepaired`,`heatwatch`.`foot`.`footCount` AS `footCount`,`heatwatch`.`foot`.`IntervalDays` AS `footIntervalDays` from ((`heatwatch`.`events` `evtfoot` join `heatwatch`.`foot` on(((`heatwatch`.`foot`.`intEvtId` = `evtfoot`.`intEvtId`) and (`heatwatch`.`foot`.`intPastureId` = `evtfoot`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtfoot`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtfoot`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`))))
    3. 

  3. md5=620e7d4f037e4b90198757287a23e9ef
    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:39
    11. 

  11. create-version=1
    12. 

  12. source=select `evtfoot`.`intPastureId` AS `intPastureId`,`evtfoot`.`intEvtId` AS `intEvtId`,`evtfoot`.`intCowId` AS `evtCowId`,`evtfoot`.`dateEvtDate` AS `evtfootDate`,`employee`.`varEmployeeName` AS `footPersoner`,`evtfoot`.`varNotes` AS `varfootNotes`,case when `foot`.`IsRepaired` = 0 then \'否\' else \'是\' end AS `footIsRepaired`,`foot`.`footCount` AS `footCount`,`foot`.`IntervalDays` AS `footIntervalDays` from ((`events` `evtfoot` join `foot` on(`foot`.`intEvtId` = `evtfoot`.`intEvtId` and `foot`.`intPastureId` = `evtfoot`.`intPastureId`)) left join `employee` on(`evtfoot`.`intPersoner` = `employee`.`intEmployeeId` and `evtfoot`.`intPastureId` = `employee`.`intPastureId`))
    13. 

  13. client_cs_name=utf8
    14. 

  14. connection_cl_name=utf8_general_ci
    15. 

  15. view_body_utf8=select `evtfoot`.`intPastureId` AS `intPastureId`,`evtfoot`.`intEvtId` AS `intEvtId`,`evtfoot`.`intCowId` AS `evtCowId`,`evtfoot`.`dateEvtDate` AS `evtfootDate`,`heatwatch`.`employee`.`varEmployeeName` AS `footPersoner`,`evtfoot`.`varNotes` AS `varfootNotes`,(case when (`heatwatch`.`foot`.`IsRepaired` = 0) then \'否\' else \'是\' end) AS `footIsRepaired`,`heatwatch`.`foot`.`footCount` AS `footCount`,`heatwatch`.`foot`.`IntervalDays` AS `footIntervalDays` from ((`heatwatch`.`events` `evtfoot` join `heatwatch`.`foot` on(((`heatwatch`.`foot`.`intEvtId` = `evtfoot`.`intEvtId`) and (`heatwatch`.`foot`.`intPastureId` = `evtfoot`.`intPastureId`)))) left join `heatwatch`.`employee` on(((`evtfoot`.`intPersoner` = `heatwatch`.`employee`.`intEmployeeId`) and (`evtfoot`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`))))
    16.