[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