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

[Bobby Smith]

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/6a503e80/attachment-0001.htm>