TYPE=VIEW
query=select `a`.`DIR` AS `DIR`,concat(\'/\',`a`.`NAME`) AS `Path` from `mydata`.`customerdir` `a` where (`a`.`DIR` = 1) union select `a`.`DIR` AS `DIR`,concat(concat(\'/\',`b`.`NAME`),\'/\',`a`.`NAME`) AS `Path` from (`mydata`.`customerdir` `a` left join `mydata`.`customerdir` `b` on((`a`.`PARENT` = `b`.`DIR`))) where (`b`.`DIR` = 1) union select `a`.`DIR` AS `DIR`,concat(concat(concat(\'/\',`c`.`NAME`),\'/\',`b`.`NAME`),\'/\',`a`.`NAME`) AS `Path` from ((`mydata`.`customerdir` `a` left join `mydata`.`customerdir` `b` on((`a`.`PARENT` = `b`.`DIR`))) left join `mydata`.`customerdir` `c` on((`b`.`PARENT` = `c`.`DIR`))) where (`c`.`DIR` = 1) union select `a`.`DIR` AS `DIR`,concat(concat(concat(concat(\'/\',`d`.`NAME`),\'/\',`c`.`NAME`),\'/\',`b`.`NAME`),\'/\',`a`.`NAME`) AS `Path` from (((`mydata`.`customerdir` `a` left join `mydata`.`customerdir` `b` on((`a`.`PARENT` = `b`.`DIR`))) left join `mydata`.`customerdir` `c` on((`b`.`PARENT` = `c`.`DIR`))) left join `mydata`.`customerdir` `d` on((`c`.`PARENT` = `d`.`DIR`))) where (`d`.`DIR` = 1) union select `a`.`DIR` AS `DIR`,concat(concat(concat(concat(concat(\'/\',`e`.`NAME`),\'/\',`d`.`NAME`),\'/\',`c`.`NAME`),\'/\',`b`.`NAME`),\'/\',`a`.`NAME`) AS `Path` from ((((`mydata`.`customerdir` `a` left join `mydata`.`customerdir` `b` on((`a`.`PARENT` = `b`.`DIR`))) left join `mydata`.`customerdir` `c` on((`b`.`PARENT` = `c`.`DIR`))) left join `mydata`.`customerdir` `d` on((`c`.`PARENT` = `d`.`DIR`))) left join `mydata`.`customerdir` `e` on((`d`.`PARENT` = `e`.`DIR`))) where (`e`.`DIR` = 1)
md5=038b73c24ef4cc084c19243b76aab1a4
updatable=0
algorithm=0
definer_user=root
definer_host=127.0.0.1
suid=2
with_check_option=0
revision=1
timestamp=2009-09-21 16:11:51
create-version=1
source=select a.DIR, CONCAT(\'/\',a.name) as Path   from  Customerdir AS a  WHERE  a.dir = 1
\n union 
\n select a.DIR, CONCAT( CONCAT(\'/\',b.name) , \'/\',a.name) as Path  from  Customerdir AS a   
\n left join   Customerdir AS b on a.parent = b.dir where b.dir =1
\n union
\n select a.DIR, CONCAT( CONCAT(CONCAT(\'/\',c.name),\'/\',b.name) , \'/\',a.name) as Path  from  Customerdir AS a   
\n left join   Customerdir AS b on a.parent = b.dir 
\n left join   Customerdir AS c on b.parent = c.dir where c.dir =1
\n union
\n select a.DIR, CONCAT( CONCAT(CONCAT(CONCAT(\'/\',d.name),\'/\',c.name),\'/\',b.name) , \'/\',a.name) as Path  from  Customerdir AS a   
\n left join   Customerdir AS b on a.parent = b.dir 
\n left join   Customerdir AS c on b.parent = c.dir 
\n left join   Customerdir AS d on c.parent = d.dir where d.dir =1
\n union
\n select a.DIR, CONCAT( CONCAT(CONCAT(CONCAT(CONCAT(\'/\',e.name),\'/\',d.name),\'/\',c.name),\'/\',b.name) , \'/\',a.name) as Path  from  Customerdir AS a   
\n left join   Customerdir AS b on a.parent = b.dir 
\n left join   Customerdir AS c on b.parent = c.dir 
\n left join   Customerdir AS d on c.parent = d.dir 
\n left join   Customerdir AS e on d.parent = e.dir where e.dir =1
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `a`.`DIR` AS `DIR`,concat(\'/\',`a`.`NAME`) AS `Path` from `mydata`.`customerdir` `a` where (`a`.`DIR` = 1) union select `a`.`DIR` AS `DIR`,concat(concat(\'/\',`b`.`NAME`),\'/\',`a`.`NAME`) AS `Path` from (`mydata`.`customerdir` `a` left join `mydata`.`customerdir` `b` on((`a`.`PARENT` = `b`.`DIR`))) where (`b`.`DIR` = 1) union select `a`.`DIR` AS `DIR`,concat(concat(concat(\'/\',`c`.`NAME`),\'/\',`b`.`NAME`),\'/\',`a`.`NAME`) AS `Path` from ((`mydata`.`customerdir` `a` left join `mydata`.`customerdir` `b` on((`a`.`PARENT` = `b`.`DIR`))) left join `mydata`.`customerdir` `c` on((`b`.`PARENT` = `c`.`DIR`))) where (`c`.`DIR` = 1) union select `a`.`DIR` AS `DIR`,concat(concat(concat(concat(\'/\',`d`.`NAME`),\'/\',`c`.`NAME`),\'/\',`b`.`NAME`),\'/\',`a`.`NAME`) AS `Path` from (((`mydata`.`customerdir` `a` left join `mydata`.`customerdir` `b` on((`a`.`PARENT` = `b`.`DIR`))) left join `mydata`.`customerdir` `c` on((`b`.`PARENT` = `c`.`DIR`))) left join `mydata`.`customerdir` `d` on((`c`.`PARENT` = `d`.`DIR`))) where (`d`.`DIR` = 1) union select `a`.`DIR` AS `DIR`,concat(concat(concat(concat(concat(\'/\',`e`.`NAME`),\'/\',`d`.`NAME`),\'/\',`c`.`NAME`),\'/\',`b`.`NAME`),\'/\',`a`.`NAME`) AS `Path` from ((((`mydata`.`customerdir` `a` left join `mydata`.`customerdir` `b` on((`a`.`PARENT` = `b`.`DIR`))) left join `mydata`.`customerdir` `c` on((`b`.`PARENT` = `c`.`DIR`))) left join `mydata`.`customerdir` `d` on((`c`.`PARENT` = `d`.`DIR`))) left join `mydata`.`customerdir` `e` on((`d`.`PARENT` = `e`.`DIR`))) where (`e`.`DIR` = 1)
