rendered paste bodyCREATE TABLE gw (
id int(10) NOT NULL auto_increment,
gw_name VARCHAR(128) NOT NULL,
grp_id INT UNSIGNED NOT NULL,
ip_addr varchar(15) NOT NULL,
port SMALLINT UNSIGNED,
uri_scheme TINYINT UNSIGNED,
transport TINYINT UNSIGNED,
strip TINYINT UNSIGNED,
prefix varchar(16) default NULL,
UNIQUE KEY name_gw (gw_name),
INDEX gid_gw (grp_id),
PRIMARY KEY (id)
)
CREATE TABLE lcr (
id int(10) NOT NULL auto_increment,
prefix varchar(16) NOT NULL,
from_uri varchar(128) DEFAULT NULL,
grp_id INT UNSIGNED NOT NULL,
priority TINYINT UNSIGNED NOT NULL,
INDEX prefix (prefix),
INDEX fromuri (from_uri),
INDEX grpid (grp_id),
PRIMARY KEY (id)
)
INSERT INTO `lcr` (`prefix`, `from_uri`, `grp_id`, `priority`) VALUES ('', '', 1, 1);
INSERT INTO `gw` (`gw_name`, `grp_id`, `ip_addr`, `port`, `uri_scheme`, `transport`, `strip`, `prefix`) VALUES
('sd1', 1, 3707052608, 5060, 1, 1, 0, '');