• file
• revisions
• annotate
• diff
• comparison
• raw

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

opensips/scripts/mysql/lcr-create.sql

Wed, 10 Feb 2010 21:25:01 +0100

author

Michael Schloh von Bennewitz <michael@schloh.com>

date

Wed, 10 Feb 2010 21:25:01 +0100

changeset 18

8ec65b8f6e2c

parent 16

c5c55937e44c

permissions

-rw-r--r--

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.

michael@16	1	INSERT INTO version (table_name, table_version) values ('gw','8');
michael@16	2	CREATE TABLE gw (
michael@16	3	id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
michael@16	4	gw_name CHAR(128) NOT NULL,
michael@16	5	grp_id INT UNSIGNED NOT NULL,
michael@16	6	ip_addr CHAR(15) NOT NULL,
michael@16	7	port SMALLINT UNSIGNED,
michael@16	8	uri_scheme TINYINT UNSIGNED,
michael@16	9	transport TINYINT UNSIGNED,
michael@16	10	strip TINYINT UNSIGNED,
michael@16	11	tag CHAR(16) DEFAULT NULL,
michael@16	12	flags INT UNSIGNED DEFAULT 0 NOT NULL,
michael@17	13	user CHAR(16) DEFAULT NULL,
michael@17	14	realm CHAR(16) DEFAULT NULL,
michael@17	15	passwd CHAR(16) DEFAULT NULL,
michael@16	16	CONSTRAINT gw_name_idx UNIQUE (gw_name)
michael@16	17	) ENGINE=MyISAM;
michael@16	18
michael@16	19	CREATE INDEX grp_id_idx ON gw (grp_id);
michael@16	20
michael@16	21	INSERT INTO version (table_name, table_version) values ('lcr','3');
michael@16	22	CREATE TABLE lcr (
michael@16	23	id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
michael@16	24	prefix CHAR(16) DEFAULT NULL,
michael@16	25	from_uri CHAR(64) DEFAULT NULL,
michael@16	26	grp_id INT UNSIGNED NOT NULL,
michael@16	27	priority INT UNSIGNED NOT NULL
michael@16	28	) ENGINE=MyISAM;
michael@16	29
michael@16	30	CREATE INDEX prefix_idx ON lcr (prefix);
michael@16	31	CREATE INDEX from_uri_idx ON lcr (from_uri);
michael@16	32	CREATE INDEX grp_id_idx ON lcr (grp_id);
michael@16	33