Asterisk 1.8.x and MySQL tables

Hi,

I’m looking information about the structure of the MySQL database tables for Asterisk 1.8.x.
Is there somewhere published the final structure of these tables with the description fields ?

Best regards,

Daniel

Howdy,

wiki.asterisk.org/wiki/display/ … DR+Backend

[quote=“malcolmd”]Howdy,

wiki.asterisk.org/wiki/display/ … DR+Backend[/quote]

OK But this is only CDR table.
I was looking on this WIKI description of the other tables but have not found.

Daniel

Hi,

I’m looking for the official version of the tables for :

  • sippeers
  • sipusers
  • queues
  • meetme
  • voicemail
  • extensions

Best regards,

Daniel

Hi,

Did you check the contrib/realtime/mysql directory?

Hi,

You’re right, in this directory are sql files :smile:
These are the final versions with all fields ?

Best regards,

Daniel

Hi,

In folder /asterisk-1.8.3.2/contrib/realtime/mysql is sipfriends.sql file.

#
# Table structure for table `sipfriends`
#

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;

In my opinion in this files is many errors.

In this sql I do not see filds:

  • defaultuser
  • useragent
    which are probably required.

And a lot of files in my opinion is from old version of Asterisk.

What is your opinion on this topic ?

Best regards,

Daniel