opensips/scripts/mysql/lcr-create.sql@3374f578f080 (annotated)
opensips/scripts/mysql/lcr-create.sql
Wed, 10 Feb 2010 21:40:10 +0100
- author
- Michael Schloh von Bennewitz <michael@schloh.com>
- date
- Wed, 10 Feb 2010 21:40:10 +0100
- changeset 19
- 3374f578f080
- parent 16
- c5c55937e44c
- permissions
- -rw-r--r--
Changes accepted by upstream vendor and merged into trunk revision 6590.
http://opensips.svn.sourceforge.net/viewvc/opensips?view=rev&revision=6590
svn co -r 6590 https://opensips.svn.sourceforge.net/svnroot/opensips/trunk
| michael@16 | 1 | INSERT INTO version (table_name, table_version) values ('gw','8'); |
| michael@16 | 2 | CREATE TABLE gw ( |
| michael@16 | 3 | id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, |
| michael@16 | 4 | gw_name CHAR(128) NOT NULL, |
| michael@16 | 5 | grp_id INT UNSIGNED NOT NULL, |
| michael@16 | 6 | ip_addr CHAR(15) NOT NULL, |
| michael@16 | 7 | port SMALLINT UNSIGNED, |
| michael@16 | 8 | uri_scheme TINYINT UNSIGNED, |
| michael@16 | 9 | transport TINYINT UNSIGNED, |
| michael@16 | 10 | strip TINYINT UNSIGNED, |
| michael@16 | 11 | tag CHAR(16) DEFAULT NULL, |
| michael@16 | 12 | flags INT UNSIGNED DEFAULT 0 NOT NULL, |
| michael@17 | 13 | user CHAR(16) DEFAULT NULL, |
| michael@17 | 14 | realm CHAR(16) DEFAULT NULL, |
| michael@17 | 15 | passwd CHAR(16) DEFAULT NULL, |
| michael@16 | 16 | CONSTRAINT gw_name_idx UNIQUE (gw_name) |
| michael@16 | 17 | ) ENGINE=MyISAM; |
| michael@16 | 18 | |
| michael@16 | 19 | CREATE INDEX 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 INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, |
| michael@16 | 24 | prefix CHAR(16) DEFAULT NULL, |
| michael@16 | 25 | from_uri CHAR(64) DEFAULT NULL, |
| michael@16 | 26 | grp_id INT UNSIGNED NOT NULL, |
| michael@16 | 27 | priority INT UNSIGNED NOT NULL |
| michael@16 | 28 | ) ENGINE=MyISAM; |
| michael@16 | 29 | |
| michael@16 | 30 | CREATE INDEX prefix_idx ON lcr (prefix); |
| michael@16 | 31 | CREATE INDEX from_uri_idx ON lcr (from_uri); |
| michael@16 | 32 | CREATE INDEX grp_id_idx ON lcr (grp_id); |
| michael@16 | 33 |
