TYPE=VIEW
query=select `a`.`DIR` AS `DIR`,concat(_gbk\'/\',`a`.`NAME`) AS `Path` from `mydata`.`customerdir` `a` where (`a`.`DIR` = 1) union select `a`.`DIR` AS `DIR`,concat(concat(_gbk\'/\',`b`.`NAME`),_gbk\'/\',`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(_gbk\'/\',`c`.`NAME`),_gbk\'/\',`b`.`NAME`),_gbk\'/\',`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(_gbk\'/\',`d`.`NAME`),_gbk\'/\',`c`.`NAME`),_gbk\'/\',`b`.`NAME`),_gbk\'/\',`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(_gbk\'/\',`e`.`NAME`),_gbk\'/\',`d`.`NAME`),_gbk\'/\',`c`.`NAME`),_gbk\'/\',`b`.`NAME`),_gbk\'/\',`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=4b47d4a8de43d3948380e5fd9897a31a
updatable=0
algorithm=0
definer_user=root
definer_host=
suid=1
with_check_option=0
revision=1
timestamp=2009-10-29 16:24:53
create-version=1
source=select `a`.`DIR` AS `DIR`,concat(\'/\',`a`.`NAME`) AS `Path` from `customerdir` `a` where (`a`.`DIR` = 1) union select `a`.`DIR` AS `DIR`,concat(concat(\'/\',`b`.`NAME`),\'/\',`a`.`NAME`) AS `Path` from (`customerdir` `a` left join `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 ((`customerdir` `a` left join `customerdir` `b` on((`a`.`PARENT` = `b`.`DIR`))) left join `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 (((`customerdir` `a` left join `customerdir` `b` on((`a`.`PARENT` = `b`.`DIR`))) left join `customerdir` `c` on((`b`.`PARENT` = `c`.`DIR`))) left join `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 ((((`customerdir` `a` left join `customerdir` `b` on((`a`.`PARENT` = `b`.`DIR`))) left join `customerdir` `c` on((`b`.`PARENT` = `c`.`DIR`))) left join `customerdir` `d` on((`c`.`PARENT` = `d`.`DIR`))) left join `customerdir` `e` on((`d`.`PARENT` = `e`.`DIR`))) where (`e`.`DIR` = 1)
