2010/5/31 Juha Heinanen jh@tutpro.com:
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.