1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/opensips/scripts/mysql/lcr-create.sql Wed Feb 10 21:14:04 2010 +0100 1.3 @@ -0,0 +1,30 @@ 1.4 +INSERT INTO version (table_name, table_version) values ('gw','8'); 1.5 +CREATE TABLE gw ( 1.6 + id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, 1.7 + gw_name CHAR(128) NOT NULL, 1.8 + grp_id INT UNSIGNED NOT NULL, 1.9 + ip_addr CHAR(15) NOT NULL, 1.10 + port SMALLINT UNSIGNED, 1.11 + uri_scheme TINYINT UNSIGNED, 1.12 + transport TINYINT UNSIGNED, 1.13 + strip TINYINT UNSIGNED, 1.14 + tag CHAR(16) DEFAULT NULL, 1.15 + flags INT UNSIGNED DEFAULT 0 NOT NULL, 1.16 + CONSTRAINT gw_name_idx UNIQUE (gw_name) 1.17 +) ENGINE=MyISAM; 1.18 + 1.19 +CREATE INDEX grp_id_idx ON gw (grp_id); 1.20 + 1.21 +INSERT INTO version (table_name, table_version) values ('lcr','3'); 1.22 +CREATE TABLE lcr ( 1.23 + id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, 1.24 + prefix CHAR(16) DEFAULT NULL, 1.25 + from_uri CHAR(64) DEFAULT NULL, 1.26 + grp_id INT UNSIGNED NOT NULL, 1.27 + priority INT UNSIGNED NOT NULL 1.28 +) ENGINE=MyISAM; 1.29 + 1.30 +CREATE INDEX prefix_idx ON lcr (prefix); 1.31 +CREATE INDEX from_uri_idx ON lcr (from_uri); 1.32 +CREATE INDEX grp_id_idx ON lcr (grp_id); 1.33 +