RE: [Fwd: Re: related tables design]

>You misunderstand.  The indexes for the IP Range Table must match those
> of the DHCP Settings table, like so:
>
> [DHCP settings table]
> index       poolName          serverIp      rowStatus
>   1           testPool          a.a.a.a       1
>   2           testPool1         b.b.b.b       1
>   4           testPool2         c.c.c.c       1
>
> [IP Range Table] as augment of entries in DHCP settings table
> index    startIp            endIp
>   1        1.1.1.100          1.1.1.199
>   4        2.2.2.200          2.2.2.249   <- newly added row
>
> 	This tells us that 1.1.1.1xx addresses are assigned to testPool requests,
> 2.2.2.2xx addresses are assigned to testPool2 requests, and there will be
> no DHCP addresses in testPool1.

Thanks for pointing it out. Since the second IP Range Table is related to
the first DHCP settings table, I think I have to use multiple indexes for
the IP Range table, one for indexing itself, another one for referencing
the row number in the DHCP settings table.

/Pan



-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Net-snmp-users mailing list
[email protected]
Please see the following page to unsubscribe or change other options:
https://lists.sourceforge.net/lists/listinfo/net-snmp-users