Contributed Logic / file revision
opensips/scripts/oracle/lcr-create.sql@c5c55937e44c
opensips/scripts/oracle/lcr-create.sql
Wed, 10 Feb 2010 21:14:04 +0100
- author
- Michael Schloh von Bennewitz <michael@schloh.com>
- date
- Wed, 10 Feb 2010 21:14:04 +0100
- changeset 16
- c5c55937e44c
- child 17
- 733187d496d0
- permissions
- -rw-r--r--
Import unmodified vendor sources for correction and improvement.
1 INSERT INTO version (table_name, table_version) values ('gw','8');
2 CREATE TABLE gw (
3 id NUMBER(10) PRIMARY KEY,
4 gw_name VARCHAR2(128),
5 grp_id NUMBER(10),
6 ip_addr VARCHAR2(15),
7 port NUMBER(5),
8 uri_scheme NUMBER(5),
9 transport NUMBER(5),
10 strip NUMBER(5),
11 tag VARCHAR2(16) DEFAULT NULL,
12 flags NUMBER(10) DEFAULT 0 NOT NULL,
13 CONSTRAINT gw_gw_name_idx UNIQUE (gw_name)
14 );
16 CREATE OR REPLACE TRIGGER gw_tr
17 before insert on gw FOR EACH ROW
18 BEGIN
19 auto_id(:NEW.id);
20 END gw_tr;
21 /
22 BEGIN map2users('gw'); END;
23 /
24 CREATE INDEX gw_grp_id_idx ON gw (grp_id);
26 INSERT INTO version (table_name, table_version) values ('lcr','3');
27 CREATE TABLE lcr (
28 id NUMBER(10) PRIMARY KEY,
29 prefix VARCHAR2(16) DEFAULT NULL,
30 from_uri VARCHAR2(64) DEFAULT NULL,
31 grp_id NUMBER(10),
32 priority NUMBER(10)
33 );
35 CREATE OR REPLACE TRIGGER lcr_tr
36 before insert on lcr FOR EACH ROW
37 BEGIN
38 auto_id(:NEW.id);
39 END lcr_tr;
40 /
41 BEGIN map2users('lcr'); END;
42 /
43 CREATE INDEX lcr_prefix_idx ON lcr (prefix);
44 CREATE INDEX lcr_from_uri_idx ON lcr (from_uri);
45 CREATE INDEX lcr_grp_id_idx ON lcr (grp_id);
