1CREATE TABLE lcr_gw ( 2 id NUMBER(10) PRIMARY KEY, 3 lcr_id NUMBER(5), 4 gw_name VARCHAR2(128), 5 ip_addr VARCHAR2(50), 6 hostname VARCHAR2(64), 7 port NUMBER(5), 8 params VARCHAR2(64), 9 uri_scheme NUMBER(5), 10 transport NUMBER(5), 11 strip NUMBER(5), 12 prefix VARCHAR2(16) DEFAULT NULL, 13 tag VARCHAR2(64) DEFAULT NULL, 14 flags NUMBER(10) DEFAULT 0 NOT NULL, 15 defunct NUMBER(10) DEFAULT NULL 16); 17 18CREATE OR REPLACE TRIGGER lcr_gw_tr 19before insert on lcr_gw FOR EACH ROW 20BEGIN 21 auto_id(:NEW.id); 22END lcr_gw_tr; 23/ 24BEGIN map2users('lcr_gw'); END; 25/ 26CREATE INDEX lcr_gw_lcr_id_idx ON lcr_gw (lcr_id); 27 28INSERT INTO version (table_name, table_version) values ('lcr_gw','3'); 29 30CREATE TABLE lcr_rule_target ( 31 id NUMBER(10) PRIMARY KEY, 32 lcr_id NUMBER(5), 33 rule_id NUMBER(10), 34 gw_id NUMBER(10), 35 priority NUMBER(5), 36 weight NUMBER(10) DEFAULT 1 NOT NULL, 37 CONSTRAINT ORA_rule_id_gw_id_idx UNIQUE (rule_id, gw_id) 38); 39 40CREATE OR REPLACE TRIGGER lcr_rule_target_tr 41before insert on lcr_rule_target FOR EACH ROW 42BEGIN 43 auto_id(:NEW.id); 44END lcr_rule_target_tr; 45/ 46BEGIN map2users('lcr_rule_target'); END; 47/ 48CREATE INDEX lcr_rule_target_lcr_id_idx ON lcr_rule_target (lcr_id); 49 50INSERT INTO version (table_name, table_version) values ('lcr_rule_target','1'); 51 52CREATE TABLE lcr_rule ( 53 id NUMBER(10) PRIMARY KEY, 54 lcr_id NUMBER(5), 55 prefix VARCHAR2(16) DEFAULT NULL, 56 from_uri VARCHAR2(64) DEFAULT NULL, 57 request_uri VARCHAR2(64) DEFAULT NULL, 58 mt_tvalue VARCHAR2(128) DEFAULT NULL, 59 stopper NUMBER(10) DEFAULT 0 NOT NULL, 60 enabled NUMBER(10) DEFAULT 1 NOT NULL, 61 CONSTRAINT ORA_lcr_id_prefix_from_uri_idx UNIQUE (lcr_id, prefix, from_uri) 62); 63 64CREATE OR REPLACE TRIGGER lcr_rule_tr 65before insert on lcr_rule FOR EACH ROW 66BEGIN 67 auto_id(:NEW.id); 68END lcr_rule_tr; 69/ 70BEGIN map2users('lcr_rule'); END; 71/ 72INSERT INTO version (table_name, table_version) values ('lcr_rule','3'); 73 74