USE `asterisk`;
alter database character set utf8;
alter database collate utf8_general_ci;
-- ----------------------------
-- Table structure for extensions
-- ----------------------------
DROP TABLE IF EXISTS `extensions`;
CREATE TABLE `extensions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`context` varchar(20) NOT NULL DEFAULT '',
`exten` varchar(20) NOT NULL DEFAULT '',
`priority` tinyint(4) NOT NULL DEFAULT '0',
`app` varchar(20) NOT NULL DEFAULT '',
`appdata` varchar(128) NOT NULL DEFAULT '',
KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2;
-- ----------------------------
-- Table structure for sipusers
-- ----------------------------
DROP TABLE IF EXISTS `sipusers`;
CREATE TABLE `sipusers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`accountcode` varchar(20) DEFAULT NULL,
`disallow` varchar(100) DEFAULT 'all',
`allow` varchar(100) DEFAULT 'g729;ilbc;gsm;ulaw;alaw',
`allowoverlap` enum('yes','no') DEFAULT 'yes',
`allowsubscribe` enum('yes','no') DEFAULT 'yes',
`allowtransfer` varchar(3) DEFAULT NULL,
`amaflags` varchar(13) DEFAULT NULL,
`autoframing` varchar(3) DEFAULT NULL,
`auth` varchar(40) DEFAULT NULL,
`buggymwi` enum('yes','no') DEFAULT 'no',
`callgroup` varchar(10) DEFAULT NULL,
`callerid` varchar(80) DEFAULT NULL,
`cid_number` varchar(40) DEFAULT NULL,
`fullname` varchar(40) DEFAULT NULL,
`call-limit` int(
DEFAULT '0',
`callingpres` varchar(80) DEFAULT NULL,
`canreinvite` char(6) DEFAULT 'yes',
`context` varchar(80) DEFAULT NULL,
`defaultip` varchar(15) DEFAULT NULL,
`dtmfmode` varchar(7) DEFAULT NULL,
`fromuser` varchar(80) DEFAULT NULL,
`fromdomain` varchar(80) DEFAULT NULL,
`fullcontact` varchar(80) DEFAULT NULL,
`g726nonstandard` enum('yes','no') DEFAULT 'no',
`host` varchar(31) NOT NULL DEFAULT 'dynamic',
`insecure` varchar(20) DEFAULT NULL,
`ipaddr` varchar(15) NOT NULL DEFAULT '',
`language` char(2) DEFAULT NULL,
`lastms` varchar(20) DEFAULT NULL,
`mailbox` varchar(50) DEFAULT NULL,
`maxcallbitrate` int(
DEFAULT '384',
`mohsuggest` varchar(80) DEFAULT NULL,
`md5secret` varchar(80) DEFAULT NULL,
`musiconhold` varchar(100) DEFAULT NULL,
`name` varchar(80) NOT NULL DEFAULT '',
`nat` varchar(5) NOT NULL DEFAULT 'no',
`outboundproxy` varchar(80) DEFAULT NULL,
`deny` varchar(95) DEFAULT NULL,
`permit` varchar(95) DEFAULT NULL,
`pickupgroup` varchar(10) DEFAULT NULL,
`port` varchar(5) NOT NULL DEFAULT '',
`progressinband` enum('yes','no','never') DEFAULT 'no',
`promiscredir` enum('yes','no') DEFAULT 'no',
`qualify` char(3) DEFAULT NULL,
`regexten` varchar(80) NOT NULL DEFAULT '',
`regseconds` int(11) NOT NULL DEFAULT '0',
`rfc2833compensate` enum('yes','no') DEFAULT 'no',
`rtptimeout` char(3) DEFAULT NULL,
`rtpholdtimeout` char(3) DEFAULT NULL,
`secret` varchar(80) DEFAULT NULL,
`sendrpid` enum('yes','no') DEFAULT 'yes',
`setvar` varchar(100) NOT NULL DEFAULT '',
`subscribecontext` varchar(80) DEFAULT NULL,
`subscribemwi` varchar(3) DEFAULT NULL,
`t38pt_udptl` enum('yes','no') DEFAULT 'no',
`trustrpid` enum('yes','no') DEFAULT 'no',
`type` varchar(6) NOT NULL DEFAULT 'friend',
`useclientcode` enum('yes','no') DEFAULT 'no',
`username` varchar(80) NOT NULL DEFAULT '',
`usereqphone` varchar(3) NOT NULL DEFAULT 'no',
`videosupport` enum('yes','no') DEFAULT 'yes',
`vmexten` varchar(80) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `name_2` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for voicemail
-- ----------------------------
DROP TABLE IF EXISTS `voicemail`;
CREATE TABLE `voicemail` (
`uniqueid` int(11) NOT NULL AUTO_INCREMENT,
`customer_id` int(11) NOT NULL DEFAULT '0',
`context` varchar(50) NOT NULL DEFAULT '',
`mailbox` int(5) NOT NULL DEFAULT '0',
`password` varchar(4) NOT NULL DEFAULT '0',
`fullname` varchar(50) NOT NULL DEFAULT '',
`email` varchar(50) NOT NULL DEFAULT '',
`pager` varchar(50) NOT NULL DEFAULT '',
`stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`attach` varchar(3) NOT NULL DEFAULT 'no',
`saycid` varchar(3) NOT NULL DEFAULT 'yes',
`hidefromdir` varchar(3) NOT NULL DEFAULT 'no',
PRIMARY KEY (`uniqueid`),
KEY `mailbox_context` (`mailbox`,`context`)
) ENGINE=MyISAM;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `extensions` VALUES ('1', 'factory', '_XXXXXXX', '1', 'NoOp', '');
INSERT INTO `sipusers` VALUES ('1', null, 'all', 'g729;ilbc;gsm;ulaw;alaw', 'yes', 'yes', null, null, null, null, 'no', null, null, null, null, '0', null, 'yes', null, null, null, null, null, null, 'no', 'dynamic', null, '', 'en', '0', null, '384', null, null, null, 'neo', 'no', null, null, null, null, '', 'no', 'no', null, '1000001', '0', 'no', null, null, 'password', 'yes', '', null, null, 'no', 'no', 'friend', 'no', '', 'no', 'yes', null);
CREATE TABLE `cdr` (
`calldate` datetime NOT NULL default '0000-00-00 00:00:00',
`clid` varchar(80) NOT NULL default '',
`src` varchar(80) NOT NULL default '',
`dst` varchar(80) NOT NULL default '',
`dcontext` varchar(80) NOT NULL default '',
`channel` varchar(80) NOT NULL default '',
`dstchannel` varchar(80) NOT NULL default '',
`lastapp` varchar(80) NOT NULL default '',
`lastdata` varchar(80) NOT NULL default '',
`duration` int(11) NOT NULL default '0',
`billsec` int(11) NOT NULL default '0',
`disposition` varchar(45) NOT NULL default '',
`amaflags` int(11) NOT NULL default '0',
`accountcode` varchar(20) NOT NULL default '',
`userfield` varchar(255) NOT NULL default ''
);
Тема: Asterisk настройка на MySQL (Прочитано 4648 раз)
