Contributed Logic / file comparison
comparison: opensips/scripts/postgres/lcr-create.sql
opensips/scripts/postgres/lcr-create.sql
- changeset 16
- c5c55937e44c
- child 17
- 733187d496d0
equal
deleted
inserted
replaced
| -1:000000000000 | 0:61e9de5a8895 |
|---|---|
| 1 INSERT INTO version (table_name, table_version) values ('gw','8'); | |
| 2 CREATE TABLE gw ( | |
| 3 id SERIAL PRIMARY KEY NOT NULL, | |
| 4 gw_name VARCHAR(128) NOT NULL, | |
| 5 grp_id INTEGER NOT NULL, | |
| 6 ip_addr VARCHAR(15) NOT NULL, | |
| 7 port SMALLINT, | |
| 8 uri_scheme SMALLINT, | |
| 9 transport SMALLINT, | |
| 10 strip SMALLINT, | |
| 11 tag VARCHAR(16) DEFAULT NULL, | |
| 12 flags INTEGER DEFAULT 0 NOT NULL, | |
| 13 CONSTRAINT gw_gw_name_idx UNIQUE (gw_name) | |
| 14 ); | |
| 15 | |
| 16 CREATE INDEX gw_grp_id_idx ON gw (grp_id); | |
| 17 | |
| 18 INSERT INTO version (table_name, table_version) values ('lcr','3'); | |
| 19 CREATE TABLE lcr ( | |
| 20 id SERIAL PRIMARY KEY NOT NULL, | |
| 21 prefix VARCHAR(16) DEFAULT NULL, | |
| 22 from_uri VARCHAR(64) DEFAULT NULL, | |
| 23 grp_id INTEGER NOT NULL, | |
| 24 priority INTEGER NOT NULL | |
| 25 ); | |
| 26 | |
| 27 CREATE INDEX lcr_prefix_idx ON lcr (prefix); | |
| 28 CREATE INDEX lcr_from_uri_idx ON lcr (from_uri); | |
| 29 CREATE INDEX lcr_grp_id_idx ON lcr (grp_id); | |
| 30 |
