Contributed Logic: opensips/scripts/mysql/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 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@733187d496d0

opensips/scripts/mysql/lcr-create.sql