1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/opensips/scripts/oracle/lcr-create.sql Wed Feb 10 21:14:04 2010 +0100
1.3 @@ -0,0 +1,46 @@
1.4 +INSERT INTO version (table_name, table_version) values ('gw','8');
1.5 +CREATE TABLE gw (
1.6 + id NUMBER(10) PRIMARY KEY,
1.7 + gw_name VARCHAR2(128),
1.8 + grp_id NUMBER(10),
1.9 + ip_addr VARCHAR2(15),
1.10 + port NUMBER(5),
1.11 + uri_scheme NUMBER(5),
1.12 + transport NUMBER(5),
1.13 + strip NUMBER(5),
1.14 + tag VARCHAR2(16) DEFAULT NULL,
1.15 + flags NUMBER(10) DEFAULT 0 NOT NULL,
1.16 + CONSTRAINT gw_gw_name_idx UNIQUE (gw_name)
1.17 +);
1.18 +
1.19 +CREATE OR REPLACE TRIGGER gw_tr
1.20 +before insert on gw FOR EACH ROW
1.21 +BEGIN
1.22 + auto_id(:NEW.id);
1.23 +END gw_tr;
1.24 +/
1.25 +BEGIN map2users('gw'); END;
1.26 +/
1.27 +CREATE INDEX gw_grp_id_idx ON gw (grp_id);
1.28 +
1.29 +INSERT INTO version (table_name, table_version) values ('lcr','3');
1.30 +CREATE TABLE lcr (
1.31 + id NUMBER(10) PRIMARY KEY,
1.32 + prefix VARCHAR2(16) DEFAULT NULL,
1.33 + from_uri VARCHAR2(64) DEFAULT NULL,
1.34 + grp_id NUMBER(10),
1.35 + priority NUMBER(10)
1.36 +);
1.37 +
1.38 +CREATE OR REPLACE TRIGGER lcr_tr
1.39 +before insert on lcr FOR EACH ROW
1.40 +BEGIN
1.41 + auto_id(:NEW.id);
1.42 +END lcr_tr;
1.43 +/
1.44 +BEGIN map2users('lcr'); END;
1.45 +/
1.46 +CREATE INDEX lcr_prefix_idx ON lcr (prefix);
1.47 +CREATE INDEX lcr_from_uri_idx ON lcr (from_uri);
1.48 +CREATE INDEX lcr_grp_id_idx ON lcr (grp_id);
1.49 +
