TYPE=VIEW
query=select `jjlourens2`.`setup_insurer`.`pk_insurer` AS `pk_insurer`,`jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`job_schedule`.`jobDone` AS `jobDone`,`jjlourens2`.`job_schedule`.`cancelled` AS `cancelled`,`jjlourens2`.`job`.`jbdate` AS `jbdate`,`jjlourens2`.`setup_plumber`.`pname` AS `pname`,`jjlourens2`.`job_type`.`tName` AS `tName`,`jjlourens2`.`setup_scheduletype`.`ActionName` AS `ActionName`,`jjlourens2`.`job_schedule`.`pk_schedule` AS `pk_schedule` from (((((`jjlourens2`.`job` join `jjlourens2`.`job_schedule` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_schedule`.`fk_job`))) join `jjlourens2`.`setup_insurer` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`))) join `jjlourens2`.`setup_plumber` on((`jjlourens2`.`setup_plumber`.`pk_plumber` = `jjlourens2`.`job_schedule`.`fk_plumber`))) join `jjlourens2`.`job_type` on((`jjlourens2`.`job_type`.`pk_jtype` = `jjlourens2`.`job_schedule`.`jobCat`))) join `jjlourens2`.`setup_scheduletype` on((`jjlourens2`.`setup_scheduletype`.`pkaction` = `jjlourens2`.`job_schedule`.`jobType`)))
md5=28980448474cf24350224e7fa5492e6f
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=1
timestamp=2013-07-24 00:12:02
create-version=1
source=select `setup_insurer`.`pk_insurer` AS `pk_insurer`,`setup_insurer`.`insName` AS `insName`,`job`.`jbClaimNo` AS `jbClaimNo`,`job_schedule`.`sheduleDate` AS `sheduleDate`,`job_schedule`.`jobDone` AS `jobDone`,`job_schedule`.`cancelled` AS `cancelled`,`job`.`jbdate` AS `jbdate`,`setup_plumber`.`pname` AS `pname`,`job_type`.`tName` AS `tName`,`setup_scheduletype`.`ActionName` AS `ActionName`,`job_schedule`.`pk_schedule` AS `pk_schedule` from (((((`job` join `job_schedule` on((`job`.`pk_job` = `job_schedule`.`fk_job`))) join `setup_insurer` on((`setup_insurer`.`pk_insurer` = `job`.`fk_insurer`))) join `setup_plumber` on((`setup_plumber`.`pk_plumber` = `job_schedule`.`fk_plumber`))) join `job_type` on((`job_type`.`pk_jtype` = `job_schedule`.`jobCat`))) join `setup_scheduletype` on((`setup_scheduletype`.`pkaction` = `job_schedule`.`jobType`)))