opensips/scripts/postgres/lcr-create.sql

changeset 17
733187d496d0
parent 16
c5c55937e44c
equal deleted inserted replaced
0:61e9de5a8895 1:f282dc3432d8
8 uri_scheme SMALLINT, 8 uri_scheme SMALLINT,
9 transport SMALLINT, 9 transport SMALLINT,
10 strip SMALLINT, 10 strip SMALLINT,
11 tag VARCHAR(16) DEFAULT NULL, 11 tag VARCHAR(16) DEFAULT NULL,
12 flags INTEGER DEFAULT 0 NOT NULL, 12 flags INTEGER DEFAULT 0 NOT NULL,
13 user VARCHAR(16) DEFAULT NULL,
14 realm VARCHAR(16) DEFAULT NULL,
15 passwd VARCHAR(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 INDEX gw_grp_id_idx ON gw (grp_id); 19 CREATE INDEX gw_grp_id_idx ON gw (grp_id);
17 20

mercurial