All pastes #590950 Raw Edit

Something

public text v1 · immutable
#590950 ·published 2007-06-26 21:37 UTC
rendered paste body
CREATE 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, '');