Wed, 10 Feb 2010 21:14:04 +0100
Import unmodified vendor sources for correction and improvement.
michael@16 | 1 | INSERT INTO version (table_name, table_version) values ('gw','8'); |
michael@16 | 2 | CREATE TABLE gw ( |
michael@16 | 3 | id SERIAL PRIMARY KEY NOT NULL, |
michael@16 | 4 | gw_name VARCHAR(128) NOT NULL, |
michael@16 | 5 | grp_id INTEGER NOT NULL, |
michael@16 | 6 | ip_addr VARCHAR(15) NOT NULL, |
michael@16 | 7 | port SMALLINT, |
michael@16 | 8 | uri_scheme SMALLINT, |
michael@16 | 9 | transport SMALLINT, |
michael@16 | 10 | strip SMALLINT, |
michael@16 | 11 | tag VARCHAR(16) DEFAULT NULL, |
michael@16 | 12 | flags INTEGER DEFAULT 0 NOT NULL, |
michael@16 | 13 | CONSTRAINT gw_gw_name_idx UNIQUE (gw_name) |
michael@16 | 14 | ); |
michael@16 | 15 | |
michael@16 | 16 | CREATE INDEX gw_grp_id_idx ON gw (grp_id); |
michael@16 | 17 | |
michael@16 | 18 | INSERT INTO version (table_name, table_version) values ('lcr','3'); |
michael@16 | 19 | CREATE TABLE lcr ( |
michael@16 | 20 | id SERIAL PRIMARY KEY NOT NULL, |
michael@16 | 21 | prefix VARCHAR(16) DEFAULT NULL, |
michael@16 | 22 | from_uri VARCHAR(64) DEFAULT NULL, |
michael@16 | 23 | grp_id INTEGER NOT NULL, |
michael@16 | 24 | priority INTEGER NOT NULL |
michael@16 | 25 | ); |
michael@16 | 26 | |
michael@16 | 27 | CREATE INDEX lcr_prefix_idx ON lcr (prefix); |
michael@16 | 28 | CREATE INDEX lcr_from_uri_idx ON lcr (from_uri); |
michael@16 | 29 | CREATE INDEX lcr_grp_id_idx ON lcr (grp_id); |
michael@16 | 30 |