opensips/scripts/postgres/lcr-create.sql@d783b433388d (annotated)
opensips/scripts/postgres/lcr-create.sql
Mon, 16 Jan 2012 23:08:14 +0100
- author
- Michael Schloh von Bennewitz <michael@schloh.com>
- date
- Mon, 16 Jan 2012 23:08:14 +0100
- changeset 23
- d783b433388d
- parent 16
- c5c55937e44c
- permissions
- -rw-r--r--
Inconclusively complete possibly missing fields. This change introduces
inconsistencies difficult to correct given incomplete documentation of
IPKG and OPKG packaging standards.
| 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@17 | 13 | user VARCHAR(16) DEFAULT NULL, |
| michael@17 | 14 | realm VARCHAR(16) DEFAULT NULL, |
| michael@17 | 15 | passwd VARCHAR(16) DEFAULT NULL, |
| michael@16 | 16 | CONSTRAINT gw_gw_name_idx UNIQUE (gw_name) |
| michael@16 | 17 | ); |
| michael@16 | 18 | |
| michael@16 | 19 | CREATE INDEX gw_grp_id_idx ON gw (grp_id); |
| michael@16 | 20 | |
| michael@16 | 21 | INSERT INTO version (table_name, table_version) values ('lcr','3'); |
| michael@16 | 22 | CREATE TABLE lcr ( |
| michael@16 | 23 | id SERIAL PRIMARY KEY NOT NULL, |
| michael@16 | 24 | prefix VARCHAR(16) DEFAULT NULL, |
| michael@16 | 25 | from_uri VARCHAR(64) DEFAULT NULL, |
| michael@16 | 26 | grp_id INTEGER NOT NULL, |
| michael@16 | 27 | priority INTEGER NOT NULL |
| michael@16 | 28 | ); |
| michael@16 | 29 | |
| michael@16 | 30 | CREATE INDEX lcr_prefix_idx ON lcr (prefix); |
| michael@16 | 31 | CREATE INDEX lcr_from_uri_idx ON lcr (from_uri); |
| michael@16 | 32 | CREATE INDEX lcr_grp_id_idx ON lcr (grp_id); |
| michael@16 | 33 |
