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

Juha Heinanen jh at tutpro.com
Thu Apr 15 12:05:03 CEST 2010


Iñaki Baz Castillo writes:

 > 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?

i think that grp should also be included in the unique key.

-- juha



More information about the sr-dev mailing list