Contributed Logic / file revision
opensips/scripts/oracle/lcr-create.sql@d783b433388d
opensips/scripts/oracle/lcr-create.sql
Mon, 16 Jan 2012 23:08:14 +0100
- author
- Michael Schloh von Bennewitz <michael@schloh.com>
- date
- Mon, 16 Jan 2012 23:08:14 +0100
- changeset 23
- d783b433388d
- parent 16
- c5c55937e44c
- permissions
- -rw-r--r--
Inconclusively complete possibly missing fields. This change introduces
inconsistencies difficult to correct given incomplete documentation of
IPKG and OPKG packaging standards.
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 user VARCHAR2(16) DEFAULT NULL,
14 realm VARCHAR2(16) DEFAULT NULL,
15 passwd VARCHAR2(16) DEFAULT NULL,
16 CONSTRAINT gw_gw_name_idx UNIQUE (gw_name)
17 );
19 CREATE OR REPLACE TRIGGER gw_tr
20 before insert on gw FOR EACH ROW
21 BEGIN
22 auto_id(:NEW.id);
23 END gw_tr;
24 /
25 BEGIN map2users('gw'); END;
26 /
27 CREATE INDEX gw_grp_id_idx ON gw (grp_id);
29 INSERT INTO version (table_name, table_version) values ('lcr','3');
30 CREATE TABLE lcr (
31 id NUMBER(10) PRIMARY KEY,
32 prefix VARCHAR2(16) DEFAULT NULL,
33 from_uri VARCHAR2(64) DEFAULT NULL,
34 grp_id NUMBER(10),
35 priority NUMBER(10)
36 );
38 CREATE OR REPLACE TRIGGER lcr_tr
39 before insert on lcr FOR EACH ROW
40 BEGIN
41 auto_id(:NEW.id);
42 END lcr_tr;
43 /
44 BEGIN map2users('lcr'); END;
45 /
46 CREATE INDEX lcr_prefix_idx ON lcr (prefix);
47 CREATE INDEX lcr_from_uri_idx ON lcr (from_uri);
48 CREATE INDEX lcr_grp_id_idx ON lcr (grp_id);
