[Devel] trusted table
Norman Brandinger
norm at goes.com
Mon Oct 31 17:36:10 CET 2005
I would like to suggest that a "description" column be added to the
"trusted" table.
As the rows in the trusted table grows, determining the reason for a
particular entry will become more difficult. Without a "description"
column, users will have to create their own separate mechanism to
determine why a particular row in the table exists.
For example, a row might look at follows:
INSERT INTO `trusted` (`src_ip`, `proto`, `from_pattern`, `description`)
VALUES ('192.168.1.1', 'any', '^sip:.*$', 'OpenSER (ser1.example.com)')
If the decision is make not to add a "description" column to the
"trusted" table, users can add the column on their own by issuing the
following MySQL command:
alter table trusted add description varchar(32) null;
Note that in the above command, the maximum length of the column is 32
characters. I believe that a varchar field has a maximum of 255.
Regards,
Norm
More information about the Devel
mailing list