[Devel] trusted table

Bogdan-Andrei Iancu bogdan at voice-system.ro
Mon Oct 31 21:45:09 CET 2005


Hi Norm,

I uploaded your request on the tracker. See
    http://sourceforge.net/tracker/?group_id=139143
Feature Request Tracking System

Let's start using this tracker to store all open issues - is more 
convenient to use.

regards,
bogdan

Norman Brandinger wrote:

> 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
>
>
>
> _______________________________________________
> Devel mailing list
> Devel at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/devel
>




More information about the Devel mailing list