Contributed Logic: opensips/scripts/postgres/lcr-create.sql@8ec65b8f6e2c

Extend uac_auth() of the UAC module to workaround CSEQ problems.
This logic is meant to complement that of changeset 17, which
added rich authentication credentials to the gw table and its
associated logic in the LCR module.

     1 INSERT INTO version (table_name, table_version) values ('gw','8');

     2 CREATE TABLE gw (

     3     id SERIAL PRIMARY KEY NOT NULL,

     4     gw_name VARCHAR(128) NOT NULL,

     5     grp_id INTEGER NOT NULL,

     6     ip_addr VARCHAR(15) NOT NULL,

     7     port SMALLINT,

     8     uri_scheme SMALLINT,

     9     transport SMALLINT,

    10     strip SMALLINT,

    11     tag VARCHAR(16) DEFAULT NULL,

    12     flags INTEGER DEFAULT 0 NOT NULL,

    13     user VARCHAR(16) DEFAULT NULL,

    14     realm VARCHAR(16) DEFAULT NULL,

    15     passwd VARCHAR(16) DEFAULT NULL,

    16     CONSTRAINT gw_gw_name_idx UNIQUE (gw_name)

    17 );

    19 CREATE INDEX gw_grp_id_idx ON gw (grp_id);

    21 INSERT INTO version (table_name, table_version) values ('lcr','3');

    22 CREATE TABLE lcr (

    23     id SERIAL PRIMARY KEY NOT NULL,

    24     prefix VARCHAR(16) DEFAULT NULL,

    25     from_uri VARCHAR(64) DEFAULT NULL,

    26     grp_id INTEGER NOT NULL,

    27     priority INTEGER NOT NULL

    28 );

    30 CREATE INDEX lcr_prefix_idx ON lcr (prefix);

    31 CREATE INDEX lcr_from_uri_idx ON lcr (from_uri);

    32 CREATE INDEX lcr_grp_id_idx ON lcr (grp_id);

Contributed Logic / file revision

opensips/scripts/postgres/lcr-create.sql@8ec65b8f6e2c

opensips/scripts/postgres/lcr-create.sql