opensips/scripts/oracle/lcr-create.sql@8ec65b8f6e2c (annotated)
opensips/scripts/oracle/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 NUMBER(10) PRIMARY KEY, |
| michael@16 | 4 | gw_name VARCHAR2(128), |
| michael@16 | 5 | grp_id NUMBER(10), |
| michael@16 | 6 | ip_addr VARCHAR2(15), |
| michael@16 | 7 | port NUMBER(5), |
| michael@16 | 8 | uri_scheme NUMBER(5), |
| michael@16 | 9 | transport NUMBER(5), |
| michael@16 | 10 | strip NUMBER(5), |
| michael@16 | 11 | tag VARCHAR2(16) DEFAULT NULL, |
| michael@16 | 12 | flags NUMBER(10) DEFAULT 0 NOT NULL, |
| michael@17 | 13 | user VARCHAR2(16) DEFAULT NULL, |
| michael@17 | 14 | realm VARCHAR2(16) DEFAULT NULL, |
| michael@17 | 15 | passwd VARCHAR2(16) DEFAULT NULL, |
| michael@16 | 16 | CONSTRAINT gw_gw_name_idx UNIQUE (gw_name) |
| michael@16 | 17 | ); |
| michael@16 | 18 | |
| michael@16 | 19 | CREATE OR REPLACE TRIGGER gw_tr |
| michael@16 | 20 | before insert on gw FOR EACH ROW |
| michael@16 | 21 | BEGIN |
| michael@16 | 22 | auto_id(:NEW.id); |
| michael@16 | 23 | END gw_tr; |
| michael@16 | 24 | / |
| michael@16 | 25 | BEGIN map2users('gw'); END; |
| michael@16 | 26 | / |
| michael@16 | 27 | CREATE INDEX gw_grp_id_idx ON gw (grp_id); |
| michael@16 | 28 | |
| michael@16 | 29 | INSERT INTO version (table_name, table_version) values ('lcr','3'); |
| michael@16 | 30 | CREATE TABLE lcr ( |
| michael@16 | 31 | id NUMBER(10) PRIMARY KEY, |
| michael@16 | 32 | prefix VARCHAR2(16) DEFAULT NULL, |
| michael@16 | 33 | from_uri VARCHAR2(64) DEFAULT NULL, |
| michael@16 | 34 | grp_id NUMBER(10), |
| michael@16 | 35 | priority NUMBER(10) |
| michael@16 | 36 | ); |
| michael@16 | 37 | |
| michael@16 | 38 | CREATE OR REPLACE TRIGGER lcr_tr |
| michael@16 | 39 | before insert on lcr FOR EACH ROW |
| michael@16 | 40 | BEGIN |
| michael@16 | 41 | auto_id(:NEW.id); |
| michael@16 | 42 | END lcr_tr; |
| michael@16 | 43 | / |
| michael@16 | 44 | BEGIN map2users('lcr'); END; |
| michael@16 | 45 | / |
| michael@16 | 46 | CREATE INDEX lcr_prefix_idx ON lcr (prefix); |
| michael@16 | 47 | CREATE INDEX lcr_from_uri_idx ON lcr (from_uri); |
| michael@16 | 48 | CREATE INDEX lcr_grp_id_idx ON lcr (grp_id); |
| michael@16 | 49 |
