Re: How to store a directory info into a database?

Thanks for your kind suggestions. But my immediate thought was that it would be very difficult the program interfacing to the database as the schema is not fixed, it changs dynamically.

Louis

Eric Dickner wrote:
> How about this.
>
> table level_0 {
> dir_id int, KEY
> dir_name varchar,
> parent_id int = null,
> child_id enumeration of int,
> }
>
> table level_1 {
> dir_id int, KEY
> dir_name varchar,
> parent_id int = null,
> child_id enumeration of int,
> }
> .
> .
> .
> table level_N {
> dir_id int, KEY
> dir_name varchar,
> parent_id int = null,
> child_id enumeration ot int,
> }
>
> I have to think this is the best you can do both search wise and sroarage
> wise.
>
> ejd
Received on Mon May 27 2002 - 08:39:20 CDT