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