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

Bobby Smith bobby.smith at gmail.com
Fri Oct 25 18:52:32 CEST 2013


I should also mention, I'm using this with a postgres db, so the schema
install would be from the postgres definition/scripts.


On Fri, Oct 25, 2013 at 12:50 PM, Bobby Smith <bobby.smith at gmail.com> 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,
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20131025/839bb321/attachment.htm>


More information about the Users mailing list