[sr-dev] 'address' table and composite UNIQUE key for 'ip_addr' and 'mask' columns

[Alex Balashov]

On 04/15/2010 05:57 AM, Iñaki Baz Castillo wrote:

> Hi, 'ip_addr' and 'mask' columns (in 'address' table) should be a
> composite UNIQUE key as it doesn't make sense to have two entries
> sharing both values (the module would always take the first one).
> This would requiere a change in the DB schema. Opinions?

What if you want to have the same CIDR block be a member of different 
groups (grp) or allow two distinct source ports only (port) from a given 
block?

-- 
Alex Balashov - Principal
Evariste Systems LLC
1170 Peachtree Street
12th Floor, Suite 1200
Atlanta, GA 30309
Tel: +1-678-954-0670
Fax: +1-404-961-1892
Web: http://www.evaristesys.com/