[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