Hi
i use asterisk realtime with postgresql via ODBC
in asterisk source\contrib in postgresql folder & mysql folder seems table name & number of fields for same work (sip) is totaly diffrent and seems mysql tabel field is more complete
for example i need “subscribecontext” av. in mysql but not avalibale in postgresql !
why ?
mysql table name is sipfreind :
CREATE TABLE `sipfriends` (
`name` varchar(40) NOT NULL default '',
`type` varchar(10) NOT NULL default '',
`username` varchar(40),
`fromuser` varchar(40),
`fromdomain` varchar(40),
`secret` varchar(40),
`md5secret` varchar(40),
`auth` varchar(10),
`mailbox` varchar(20),
`subscribemwi` varchar(10), -- yes/no
`vmexten` varchar(20),
`callerid` varchar(40),
`cid_number` varchar(40),
`callingpres` varchar(20),
`usereqphone` varchar(10),
`language` varchar(10),
`incominglimit` varchar(10),
`context` varchar(40) NOT NULL default '',
`subscribecontext` varchar(40),
`amaflags` varchar(20),
`accountcode` varchar(20),
`musicclass` varchar(20),
`mohsuggest` varchar(20),
`allowtransfer` varchar(20),
`callgroup` varchar(20),
`pickupgroup` varchar(20),
`autoframing` varchar(10), -- yes/no
`disallow` varchar(20) default 'all',
`allow` varchar(20),
`maxcallbitrate` varchar(15),
`host` varchar(40) default 'dynamic',
`outboundproxy` varchar(40),
`ipaddr` varchar(40) NOT NULL default '',
`defaultip` varchar(20),
`port` int(6) NOT NULL default '0',
`fullcontact` varchar(40),
`insecure` varchar(20),
`qualify` varchar(15),
`regseconds` int(11) NOT NULL default '0',
`regexten` varchar(20),
`regserver` varchar(20),
`rtptimeout` varchar(15),
`rtpholdtimeout` varchar(15),
`rtpkeepalive` varchar(15),
`lastms` int(11) NOT NULL default '-1',
`setvar` varchar(200),
PRIMARY KEY (`name`),
INDEX host (host, port),
INDEX ipaddr (ipaddr, port),
) TYPE=MyISAM;
postgresql table
CREATE TABLE sip_conf (
id serial NOT NULL,
name character varying(80) DEFAULT '' NOT NULL,
accountcode character varying(20),
amaflags character varying(7),
callgroup character varying(10),
callerid character varying(80),
canreinvite character varying(3) DEFAULT 'yes',
context character varying(80),
defaultip character varying(15),
dtmfmode character varying(7),
fromuser character varying(80),
fromdomain character varying(80),
host character varying(31) DEFAULT '' NOT NULL,
insecure character varying(4),
"language" character varying(2),
mailbox character varying(50),
md5secret character varying(80),
nat character varying(5) DEFAULT 'no' NOT NULL,
permit character varying(95),
deny character varying(95),
mask character varying(95),
pickupgroup character varying(10),
port character varying(5) DEFAULT '' NOT NULL,
qualify character varying(3),
restrictcid character varying(1),
rtptimeout character varying(3),
rtpholdtimeout character varying(3),
secret character varying(80),
"type" character varying DEFAULT 'friend' NOT NULL,
username character varying(80) DEFAULT '' NOT NULL,
disallow character varying(100) DEFAULT 'all',
allow character varying(100) DEFAULT 'g729;ilbc;gsm;ulaw;alaw',
musiconhold character varying(100),
regseconds bigint DEFAULT 0::bigint NOT NULL,
ipaddr character varying(40) DEFAULT '' NOT NULL,
regexten character varying(80) DEFAULT '' NOT NULL,
cancallforward character varying(3) DEFAULT 'yes',
lastms integer DEFAULT -1 NOT NULL
);