Contributed Logic: opensips/scripts/postgres/lcr-create.sql@733187d496d0

Introduce authentication credential logic into the LCR module.
This logic is meant to complement that of changeset 18, adding
additional authentication flexibility to the UAC 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@733187d496d0

opensips/scripts/postgres/lcr-create.sql