2010/5/31 Juha Heinanen <[email protected]>:
> Iñaki Baz Castillo writes:
>
>> It would be ok. However from a design point of view IMHO it's simpler
>> to have a column "stop" rather than requiring special syntax in
>> 'prefix' column. Content of lcr table is loaded into memory so I don't
>> see the benefict of using 001$ rather than "stop=1". In order to
>> design an admin interface is easier to handle a single column rather
>> than inspecting the syntax of the 'prefix' column.
>
> what bothers me is that stopping business has nothing to do with a
> particular row in rules table, but with a particular prefix.  may be a
> clean solution requires one more table.

And this would be better from a design point of view :)

So let's imagine a new table 'lcr_stopper_rules' with the following columns:

- id: Primary key as usual.
- rule_id:  Integer pointing to an entry under 'lcr_rules' ('lcr') table.

-- 
Iñaki Baz Castillo
<[email protected]>

_______________________________________________
sr-dev mailing list
[email protected]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev

Reply via email to