opensips/scripts/oracle/lcr-create.sql

changeset 17
733187d496d0
parent 16
c5c55937e44c
equal deleted inserted replaced
0:98ffe2422d1b 1:fd7f49e35246
8 uri_scheme NUMBER(5), 8 uri_scheme NUMBER(5),
9 transport NUMBER(5), 9 transport NUMBER(5),
10 strip NUMBER(5), 10 strip NUMBER(5),
11 tag VARCHAR2(16) DEFAULT NULL, 11 tag VARCHAR2(16) DEFAULT NULL,
12 flags NUMBER(10) DEFAULT 0 NOT 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,
13 CONSTRAINT gw_gw_name_idx UNIQUE (gw_name) 16 CONSTRAINT gw_gw_name_idx UNIQUE (gw_name)
14 ); 17 );
15 18
16 CREATE OR REPLACE TRIGGER gw_tr 19 CREATE OR REPLACE TRIGGER gw_tr
17 before insert on gw FOR EACH ROW 20 before insert on gw FOR EACH ROW

mercurial