Contributed Logic / file comparison
comparison: opensips/scripts/mysql/lcr-create.sql
opensips/scripts/mysql/lcr-create.sql
- changeset 16
- c5c55937e44c
- child 17
- 733187d496d0
equal
deleted
inserted
replaced
| -1:000000000000 | 0:fedc5d2da14f |
|---|---|
| 1 INSERT INTO version (table_name, table_version) values ('gw','8'); | |
| 2 CREATE TABLE gw ( | |
| 3 id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, | |
| 4 gw_name CHAR(128) NOT NULL, | |
| 5 grp_id INT UNSIGNED NOT NULL, | |
| 6 ip_addr CHAR(15) NOT NULL, | |
| 7 port SMALLINT UNSIGNED, | |
| 8 uri_scheme TINYINT UNSIGNED, | |
| 9 transport TINYINT UNSIGNED, | |
| 10 strip TINYINT UNSIGNED, | |
| 11 tag CHAR(16) DEFAULT NULL, | |
| 12 flags INT UNSIGNED DEFAULT 0 NOT NULL, | |
| 13 CONSTRAINT gw_name_idx UNIQUE (gw_name) | |
| 14 ) ENGINE=MyISAM; | |
| 15 | |
| 16 CREATE INDEX 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 INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, | |
| 21 prefix CHAR(16) DEFAULT NULL, | |
| 22 from_uri CHAR(64) DEFAULT NULL, | |
| 23 grp_id INT UNSIGNED NOT NULL, | |
| 24 priority INT UNSIGNED NOT NULL | |
| 25 ) ENGINE=MyISAM; | |
| 26 | |
| 27 CREATE INDEX prefix_idx ON lcr (prefix); | |
| 28 CREATE INDEX from_uri_idx ON lcr (from_uri); | |
| 29 CREATE INDEX grp_id_idx ON lcr (grp_id); | |
| 30 |
