31 May
2010
31 May
'10
12:11 p.m.
2010/5/31 Juha Heinanen <jh(a)tutpro.com>om>:
Iñaki Baz Castillo writes:
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
<ibc(a)aliax.net>
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.