[Devel] trusted table

[Daryl Sanders]

I think this is a good idea, I like knowing a glance the reason fo each entry.

- Daryl

On 10/31/05, Norman Brandinger <norm at goes.com> 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
>