[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