Contributed Logic: opensips/scripts/mysql/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 INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,

     4     gw_name CHAR(128) NOT NULL,

     5     grp_id INT UNSIGNED NOT NULL,

     6     ip_addr CHAR(15) NOT NULL,

     7     port SMALLINT UNSIGNED,

     8     uri_scheme TINYINT UNSIGNED,

     9     transport TINYINT UNSIGNED,

    10     strip TINYINT UNSIGNED,

    11     tag CHAR(16) DEFAULT NULL,

    12     flags INT UNSIGNED DEFAULT 0 NOT NULL,

    13     user CHAR(16) DEFAULT NULL,

    14     realm CHAR(16) DEFAULT NULL,

    15     passwd CHAR(16) DEFAULT NULL,

    16     CONSTRAINT gw_name_idx UNIQUE (gw_name)

    17 ) ENGINE=MyISAM;

    19 CREATE INDEX grp_id_idx ON gw (grp_id);

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

    22 CREATE TABLE lcr (

    23     id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,

    24     prefix CHAR(16) DEFAULT NULL,

    25     from_uri CHAR(64) DEFAULT NULL,

    26     grp_id INT UNSIGNED NOT NULL,

    27     priority INT UNSIGNED NOT NULL

    28 ) ENGINE=MyISAM;

    30 CREATE INDEX prefix_idx ON lcr (prefix);

    31 CREATE INDEX from_uri_idx ON lcr (from_uri);

    32 CREATE INDEX grp_id_idx ON lcr (grp_id);

Contributed Logic / file revision

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

opensips/scripts/mysql/lcr-create.sql