1CREATE TABLE lcr_gw (
2    id INTEGER PRIMARY KEY NOT NULL,
3    lcr_id SMALLINT NOT NULL,
4    gw_name VARCHAR(128),
5    ip_addr VARCHAR(50),
6    hostname VARCHAR(64),
7    port SMALLINT,
8    params VARCHAR(64),
9    uri_scheme SMALLINT,
10    transport SMALLINT,
11    strip SMALLINT,
12    prefix VARCHAR(16) DEFAULT NULL,
13    tag VARCHAR(64) DEFAULT NULL,
14    flags INTEGER DEFAULT 0 NOT NULL,
15    defunct INTEGER DEFAULT NULL
16);
17
18CREATE INDEX lcr_gw_lcr_id_idx ON lcr_gw (lcr_id);
19
20INSERT INTO version (table_name, table_version) values ('lcr_gw','3');
21
22CREATE TABLE lcr_rule_target (
23    id INTEGER PRIMARY KEY NOT NULL,
24    lcr_id SMALLINT NOT NULL,
25    rule_id INTEGER NOT NULL,
26    gw_id INTEGER NOT NULL,
27    priority SMALLINT NOT NULL,
28    weight INTEGER DEFAULT 1 NOT NULL,
29    CONSTRAINT lcr_rule_target_rule_id_gw_id_idx UNIQUE (rule_id, gw_id)
30);
31
32CREATE INDEX lcr_rule_target_lcr_id_idx ON lcr_rule_target (lcr_id);
33
34INSERT INTO version (table_name, table_version) values ('lcr_rule_target','1');
35
36CREATE TABLE lcr_rule (
37    id INTEGER PRIMARY KEY NOT NULL,
38    lcr_id SMALLINT NOT NULL,
39    prefix VARCHAR(16) DEFAULT NULL,
40    from_uri VARCHAR(64) DEFAULT NULL,
41    request_uri VARCHAR(64) DEFAULT NULL,
42    mt_tvalue VARCHAR(128) DEFAULT NULL,
43    stopper INTEGER DEFAULT 0 NOT NULL,
44    enabled INTEGER DEFAULT 1 NOT NULL,
45    CONSTRAINT lcr_rule_lcr_id_prefix_from_uri_idx UNIQUE (lcr_id, prefix, from_uri)
46);
47
48INSERT INTO version (table_name, table_version) values ('lcr_rule','3');
49
50