Anonymous

CREATE TABLE peer (  peer_id int(11) unsigned NOT NULL auto_increment,  `status` enum('A','I') NOT NULL default 'A',  account_id int(11) unsigned NOT NULL default '0',  reference_name varchar(32) NOT NULL default '',  tech enum('S','I') NOT NULL default 'S',  name varchar(40) NOT NULL default '',  username varchar(40) default '',  secret varchar(40) NOT NULL default '',  context varchar(40) NOT NULL default '',  ipaddr varchar(20) NOT NULL default '',  port int(6) NOT NULL default '0',  regseconds int(11) NOT NULL default '0',  sip_canreinvite enum('no','yes') NOT NULL default 'no',  sip_dtmfmode enum('rfc2833','info','inband') NOT NULL default 'rfc2833',  PRIMARY KEY  (peer_id),  UNIQUE KEY tech (tech,name),  KEY account_id (account_id),  CONSTRAINT `peer_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `account` (`account_id`) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=latin1;