1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/opensips/scripts/postgres/lcr-create.sql Wed Feb 10 21:14:04 2010 +0100
1.3 @@ -0,0 +1,30 @@
1.4 +INSERT INTO version (table_name, table_version) values ('gw','8');
1.5 +CREATE TABLE gw (
1.6 + id SERIAL PRIMARY KEY NOT NULL,
1.7 + gw_name VARCHAR(128) NOT NULL,
1.8 + grp_id INTEGER NOT NULL,
1.9 + ip_addr VARCHAR(15) NOT NULL,
1.10 + port SMALLINT,
1.11 + uri_scheme SMALLINT,
1.12 + transport SMALLINT,
1.13 + strip SMALLINT,
1.14 + tag VARCHAR(16) DEFAULT NULL,
1.15 + flags INTEGER DEFAULT 0 NOT NULL,
1.16 + CONSTRAINT gw_gw_name_idx UNIQUE (gw_name)
1.17 +);
1.18 +
1.19 +CREATE INDEX gw_grp_id_idx ON gw (grp_id);
1.20 +
1.21 +INSERT INTO version (table_name, table_version) values ('lcr','3');
1.22 +CREATE TABLE lcr (
1.23 + id SERIAL PRIMARY KEY NOT NULL,
1.24 + prefix VARCHAR(16) DEFAULT NULL,
1.25 + from_uri VARCHAR(64) DEFAULT NULL,
1.26 + grp_id INTEGER NOT NULL,
1.27 + priority INTEGER NOT NULL
1.28 +);
1.29 +
1.30 +CREATE INDEX lcr_prefix_idx ON lcr (prefix);
1.31 +CREATE INDEX lcr_from_uri_idx ON lcr (from_uri);
1.32 +CREATE INDEX lcr_grp_id_idx ON lcr (grp_id);
1.33 +
