[OpenSIPS-Users] question about drouting schema >= 1.8 (coming from a 1.7 install)

Bobby Smith bobby.smith at gmail.com
Mon Oct 28 17:18:51 CET 2013


I got it, it's actually the string you can use to identify just a single
carrier from script functions.

The name was just a bit confusing, because in the 1.7 schema it was the pk
id on the table, which has now been aptly renamed to just 'id'.

Thanks for the help,


On Fri, Oct 25, 2013 at 7:40 PM, Aaron Seelye <aseelye-lists at eltopia.com>wrote:

> My answer is mysql-influenced, but it's the id to which you're either
> defining the carrier gwlist, or the gwlist target in the rules.
>
> -Aaron
>
>
> On 10/25/2013 9:50 AM, Bobby Smith wrote:
>
>> Greetings,
>>
>> I'm trying to migrate an opensips 1.7 install to 1.9.  In the process, I
>> noticed the drouting tables have changed a good bit.
>>
>> After the schema was changed in 1.8 for the drouting module, this is a
>> description of the new dr_gateways table (at the bottom).
>>
>> My question is:  there is now a "id" column, which is what i'd expect,
>> and a gwid column, which is a varchar type that's not a sequence, not
>> unique, but cannot be null.  What is this column used for?
>>
>> I noticed opensips 1.7, there is just a gwid column, which is an int
>> with a sequence, which is what I expected.  Is this just a way to carry
>> that over with a db migration to 1.8 without having collisions on the
>> sequence?  So that new id's are generated, leaving this column
>> essentially deprecated?
>>
>> If so, why make it not null?
>>
>> opensips=# \d dr_gateways;
>>                                     Table "public.dr_gateways"
>>     Column    |          Type          |                        Modifiers
>> -------------+----------------**--------+---------------------**
>> ------------------------------**-------
>>   id          | integer                | not null default
>> nextval('dr_gateways_id_seq'::**regclass)
>>   gwid        | character varying(64)  | not null
>>   type        | integer                | not null default 0
>>   address     | character varying(128) | not null
>>   strip       | integer                | not null default 0
>>   pri_prefix  | character varying(16)  | default NULL::character varying
>>   attrs       | character varying(255) | default NULL::character varying
>>   probe_mode  | integer                | not null default 0
>>   description | character varying(128) | not null default ''::character
>> varying
>> Indexes:
>>      "dr_gateways_pkey" PRIMARY KEY, btree (id)
>>      "dr_gateways_dr_gw_idx" UNIQUE, btree (gwid)
>>
>> Thanks,
>>
>>
>>
>> ______________________________**_________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-**bin/mailman/listinfo/users<http://lists.opensips.org/cgi-bin/mailman/listinfo/users>
>>
>>
> ______________________________**_________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-**bin/mailman/listinfo/users<http://lists.opensips.org/cgi-bin/mailman/listinfo/users>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20131028/9d750b1d/attachment.htm>


More information about the Users mailing list