Asterisk 1.8.x and MySQL tables

Asterisk Asterisk Support
#1

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

#2

Howdy,

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

#3

[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

#4

Hi,

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

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

Best regards,

Daniel

#5

Hi,

Did you check the contrib/realtime/mysql directory?

#6

Hi,

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

Best regards,

Daniel

#7

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