--
-- Host: localhost    Database: asterisk
-- ------------------------------------------------------


--
-- Current Database: `asterisk`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `asterisk` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;

USE `asterisk`;

--
-- Table structure for table `aa_autoanswers`
--

CREATE TABLE `aa_autoanswers` (
  `aa_id` int(11) NOT NULL AUTO_INCREMENT,
  `aa_te_id` int(11) NOT NULL,
  `aa_field` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `aa_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `aa_comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`aa_id`),
  KEY `aa_te_id` (`aa_te_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `aa_autoanswers`
--

INSERT INTO `aa_autoanswers` VALUES (1,-1,'Call-Info','Answer-After=0',''),(2,-1,'Alert-Info','Info=Alert-Autoanswer',''),(3,-1,'Alert-Info','info=ringAutoAnswer',''),(4,-1,'Call-Info','answer-after=0',''),(5,-1,'Alert-Info','info=intercom',''),(6,-1,'Alert-Info','intercom',''),(7,-1,'Alert-Info','Ring Answer',''),(8,-1,'P-Auto-Answer','normal',''),(9,-1,'Alert-Info','<http://www.notused.com>;info=alert-autoanswer;delay=0',''),(10,-1,'Answer-Mode','Auto',''),(11,-1,'Call-Info','<sip:>;answer-after=0','');

--
-- Table structure for table `ab_alarmsbinding`
--

CREATE TABLE `ab_alarmsbinding` (
  `ab_id` int(11) NOT NULL AUTO_INCREMENT,
  `ab_te_id` int(11) NOT NULL,
  `ab_callerid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ab_emailnotification` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ab_relayserver` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ab_id`),
  UNIQUE KEY `ab_callerid` (`ab_callerid`),
  KEY `ab_te_id` (`ab_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ab_alarmsbinding`
--


--
-- Table structure for table `ac_autocharges`
--

CREATE TABLE `ac_autocharges` (
  `ac_id` int(11) NOT NULL AUTO_INCREMENT,
  `ac_te_id` int(11) NOT NULL,
  `ac_cr_id` int(11) NOT NULL,
  `ac_amount` decimal(11,5) NOT NULL,
  PRIMARY KEY (`ac_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ac_autocharges`
--


--
-- Table structure for table `ag_agiscripts`
--

CREATE TABLE `ag_agiscripts` (
  `ag_id` int(11) NOT NULL AUTO_INCREMENT,
  `ag_te_id` int(11) NOT NULL,
  `ag_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ag_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ag_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ag_numparams` int(11) NOT NULL,
  `ag_admparam1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ag_allowuser1` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `ag_admparam2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ag_allowuser2` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `ag_admparam3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ag_allowuser3` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `ag_admparam4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ag_allowuser4` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `ag_admparam5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ag_allowuser5` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ag_agiscripts`
--


--
-- Table structure for table `al_alarms`
--

CREATE TABLE `al_alarms` (
  `al_id` int(11) NOT NULL AUTO_INCREMENT,
  `al_te_id` int(11) NOT NULL,
  `al_alarm_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `al_param1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `al_param2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `al_param3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `al_param4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `al_param5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `al_param6` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`al_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `al_alarms`
--


--
-- Table structure for table `al_autoprovisionlabels`
--

CREATE TABLE `al_autoprovisionlabels` (
  `al_id` int(11) NOT NULL AUTO_INCREMENT,
  `al_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `al_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `al_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `al_order` int(11) NOT NULL,
  PRIMARY KEY (`al_id`),
  UNIQUE KEY `al_value` (`al_value`)
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `al_autoprovisionlabels`
--

INSERT INTO `al_autoprovisionlabels` VALUES (1,'Missed call log','missed_call_log','LINE',10),(2,'Auto answer','auto_answer','LINE',20),(3,'Server host','server_host','LINE',30),(4,'Server port','server_port','LINE',40),(5,'Local port','local_port','LINE',50),(6,'Server expires','server_expires','LINE',60),(7,'Use outbound proxy server','enable_outbound_proxy_server','LINE',70),(8,'Outbound proxy server','outbound_host','LINE',80),(9,'Outbound proxy server port','outbound_port','LINE',90),(10,'Backup outbound proxy server','backup_outbound_host','LINE',100),(11,'Backup outbound proxy server port','backup_outbound_port','LINE',110),(12,'Enable stun','enable_stun','LINE',120),(13,'Backup server host','backup_server_host','LINE',130),(14,'Backup server host port','backup_server_port','LINE',140),(15,'Enable voice VLAN','voice_vlan_enable','PHONE',150),(16,'Voice VLAN id','voice_vlan_id','PHONE',160),(17,'Enable data VLAN','data_vlan_enable','PHONE',170),(18,'Display name','displayname','LINE',2),(19,'Username','username','LINE',4),(20,'Authname','authname','LINE',6),(21,'Secret','secret','LINE',8),(22,'Data VLAN id','data_vlan_id','PHONE',180),(23,'Subscribe Message Waiting Indicator','subscribe_mwi','LINE',190),(25,'SIP Registration Retry Timer','sip_registration_retry_timer','LINE',210),(26,'Voicemail Number','voicemail_number','LINE',220),(27,'NAT Traversal','nat_trans','LINE',230),(28,'STUN Server','stun_server','LINE',240),(29,'STUN Server Port','stun_server_port','LINE',250),(30,'Enable UDP Update','udp_keepalive_enable','LINE',260),(31,'UDP Update Time','udp_keepalive_seconds','LINE',270),(32,'RPort Enable','rport_enable','LINE',280),(33,'Contact List Server Address','contact_list_address','PHONE',290),(34,'Ringtone Server Address','ringtone_url','PHONE',270),(35,'Logo URL','logo_url','PHONE',280),(36,'LCD Logo','lcdlogo','PHONE',300),(37,'Admin Password','admin_pass','PHONE',310),(38,'Admin Password','adminpw','PHONE',320),(39,'Type','type','BUTTON',10),(40,'Parameter','parameter','BUTTON',20),(41,'Label','label','BUTTON',30),(42,'Account','account','BUTTON',40),(43,'Extension','extension','BUTTON',50),(44,'User Password','userpw','PHONE',330),(45,'VAR Password','varpw','PHONE',340),(47,'Tenant Code','tenantcode','LINE',1),(48,'Phone MAC Address','mac','PHONE',330),(49,'Phone Provision Password','provisionpassword','PHONE',335),(50,'Virtual display name','virtualdisplayname','LINE',2),(51,'Virtual number','virtualnumber','LINE',3),(52,'Number of lines','numlines','PHONE',500),(53,'Account index','index','LINE',5),(57,'Transport (udp=0, tcp=1, tls=2)','transportY','LINE',320),(58,'Transport (UDPOnly, TCPOnly, TLS)','transportP','LINE',320),(59,'Send MWI only if subscribed','subscribemwi','LINE',300),(60,'Voicemail MWI','mailbox','LINE',310),(61,'Transport','transport','LINE',320),(62,'Codecs','codecs','LINE',330),(63,'Virtual Multi-Purpose Key 1 type','vpk1type','PHONE',900),(64,'Virtual Multi-Purpose Key 1 account','vpk1account','PHONE',901),(65,'Virtual Multi-Purpose Key 1 description','vpk1description','PHONE',902),(66,'Virtual Multi-Purpose Key 1 value','vpk1value','PHONE',903),(67,'Virtual Multi-Purpose Key 2 type','vpk2type','PHONE',904),(68,'Virtual Multi-Purpose Key 2 account','vpk2account','PHONE',905),(69,'Virtual Multi-Purpose Key 2 description','vpk2description','PHONE',906),(70,'Virtual Multi-Purpose Key 2 value','vpk2value','PHONE',907),(71,'Virtual Multi-Purpose Key 3 type','vpk3type','PHONE',908),(72,'Virtual Multi-Purpose Key 3 account','vpk3account','PHONE',909),(73,'Virtual Multi-Purpose Key 3 description','vpk3description','PHONE',910),(74,'Virtual Multi-Purpose Key 3 value','vpk3value','PHONE',911),(75,'Virtual Multi-Purpose Key 4 type','vpk4type','PHONE',912),(76,'Virtual Multi-Purpose Key 4 account','vpk4account','PHONE',913),(77,'Virtual Multi-Purpose Key 4 description','vpk4description','PHONE',914),(78,'Virtual Multi-Purpose Key 4 value','vpk4value','PHONE',915),(79,'Virtual Multi-Purpose Key 5 type','vpk5type','PHONE',916),(80,'Virtual Multi-Purpose Key 5 account','vpk5account','PHONE',917),(81,'Virtual Multi-Purpose Key 5 description','vpk5description','PHONE',918),(82,'Virtual Multi-Purpose Key 5 value','vpk5value','PHONE',919),(83,'Virtual Multi-Purpose Key 6 type','vpk6type','PHONE',920),(84,'Virtual Multi-Purpose Key 6 account','vpk6account','PHONE',921),(85,'Virtual Multi-Purpose Key 6 description','vpk6description','PHONE',922),(86,'Virtual Multi-Purpose Key 6 value','vpk6value','PHONE',923),(87,'Virtual Multi-Purpose Key 7 type','vpk7type','PHONE',924),(88,'Virtual Multi-Purpose Key 7 account','vpk7account','PHONE',925),(89,'Virtual Multi-Purpose Key 7 description','vpk7description','PHONE',926),(90,'Virtual Multi-Purpose Key 7 value','vpk7value','PHONE',927),(91,'Virtual Multi-Purpose Key 8 type','vpk8type','PHONE',928),(92,'Virtual Multi-Purpose Key 8 account','vpk8account','PHONE',929),(93,'Virtual Multi-Purpose Key 8 description','vpk8description','PHONE',930),(94,'Virtual Multi-Purpose Key 8 value','vpk8value','PHONE',931),(95,'Virtual Multi-Purpose Key 9 type','vpk9type','PHONE',932),(96,'Virtual Multi-Purpose Key 9 account','vpk9account','PHONE',933),(97,'Virtual Multi-Purpose Key 9 description','vpk9description','PHONE',934),(98,'Virtual Multi-Purpose Key 9 value','vpk9value','PHONE',935),(99,'Virtual Multi-Purpose Key 10 type','vpk10type','PHONE',936),(100,'Virtual Multi-Purpose Key 10 account','vpk10account','PHONE',937),(101,'Virtual Multi-Purpose Key 10 description','vpk10description','PHONE',938),(102,'Virtual Multi-Purpose Key 10 value','vpk10value','PHONE',939),(103,'Virtual Multi-Purpose Key 11 type','vpk11type','PHONE',940),(104,'Virtual Multi-Purpose Key 11 account','vpk11account','PHONE',941),(105,'Virtual Multi-Purpose Key 11 description','vpk11description','PHONE',942),(106,'Virtual Multi-Purpose Key 11 value','vpk11value','PHONE',943),(107,'Virtual Multi-Purpose Key 12 type','vpk12type','PHONE',944),(108,'Virtual Multi-Purpose Key 12 account','vpk12account','PHONE',945),(109,'Virtual Multi-Purpose Key 12 description','vpk12description','PHONE',946),(110,'Virtual Multi-Purpose Key 12 value','vpk12value','PHONE',947),(111,'Screensaver','screensaver','PHONE',190),(112,'Station name','stationname','PHONE',200),(113,'Internal Caller ID','internalcallerid','LINE',250),(114,'HTTP/S Username','https_username','PHONE',999),(115,'HTTP/S Password','https_password','PHONE',999),(116,'Encryption','encryption','LINE',290),(117,'Tech','tech','LINE',290),(118,'Encryption','encryptionY','LINE',290),(119,'Overwrite mode','overwrite_mode','PHONE',180);

--
-- Table structure for table `aq_allowed_queue_member`
--

CREATE TABLE `aq_allowed_queue_member` (
  `aq_uniqueid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aq_membername` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `aq_queue_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `aq_interface` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `aq_state_interface` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `aq_penalty` int(11) DEFAULT NULL,
  `aq_paused` int(11) DEFAULT NULL,
  `aq_member_device` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`aq_uniqueid`),
  UNIQUE KEY `aq_queue_interface` (`aq_queue_name`,`aq_interface`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `aq_allowed_queue_member`
--


--
-- Table structure for table `ar_alarmsreceived`
--

CREATE TABLE `ar_alarmsreceived` (
  `ar_id` int(11) NOT NULL AUTO_INCREMENT,
  `ar_te_id` int(11) NOT NULL,
  `ar_callerid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ar_callername` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ar_protocol` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ar_haschecksum` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `ar_timestamp` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ar_datetime` datetime NOT NULL,
  `ar_event` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ar_account_number` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
  `ar_message_type` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `ar_qualifier` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `ar_code` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `ar_group` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `ar_zone` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `ar_checksum` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `ar_file` longblob NOT NULL,
  `ar_server` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ar_notified` datetime DEFAULT NULL,
  PRIMARY KEY (`ar_id`),
  KEY `ar_te_id` (`ar_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ar_alarmsreceived`
--


--
-- Table structure for table `ar_autorefills`
--

CREATE TABLE `ar_autorefills` (
  `ar_id` int(11) NOT NULL AUTO_INCREMENT,
  `ar_te_id` int(11) NOT NULL,
  `ar_cr_id` int(11) NOT NULL,
  `ar_amount` decimal(11,5) NOT NULL,
  PRIMARY KEY (`ar_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ar_autorefills`
--


--
-- Table structure for table `av_autoprovisionvalues`
--

CREATE TABLE `av_autoprovisionvalues` (
  `av_id` int(11) NOT NULL AUTO_INCREMENT,
  `av_te_id` int(11) NOT NULL,
  `av_ph_id` int(11) NOT NULL,
  `av_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `av_order` int(11) NOT NULL,
  `av_al_id` int(11) NOT NULL,
  `av_value` varchar(511) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`av_id`),
  KEY `av_ph_id_av_al_id` (`av_ph_id`,`av_al_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `av_autoprovisionvalues`
--


--
-- Table structure for table `ba_backups`
--

CREATE TABLE `ba_backups` (
  `ba_id` int(11) NOT NULL AUTO_INCREMENT,
  `ba_cr_id` int(11) NOT NULL,
  `ba_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ba_host` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ba_user` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ba_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ba_directory` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ba_ftphost` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ba_ftpuser` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ba_ftppassword` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ba_ftpdirectory` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ba_ftprate` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ba_dirasteriskfiles` int(11) NOT NULL,
  `ba_ftpasteriskfiles` int(11) NOT NULL,
  `ba_dircdrdbfiles` int(11) NOT NULL,
  `ba_ftpcdrdbfiles` int(11) NOT NULL,
  `ba_dirrecfiles` int(11) NOT NULL,
  `ba_ftprecfiles` int(11) NOT NULL,
  `ba_ftppassive` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'on',
  `ba_dircustomfiles` int(11) NOT NULL DEFAULT '0',
  `ba_ftpcustomfiles` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `ba_id` (`ba_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ba_backups`
--


--
-- Table structure for table `bi_billings`
--

CREATE TABLE `bi_billings` (
  `bi_id` int(11) NOT NULL AUTO_INCREMENT,
  `bi_te_id` int(11) NOT NULL,
  `bi_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bi_date` datetime NOT NULL,
  `bi_amount` decimal(20,5) NOT NULL,
  PRIMARY KEY (`bi_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `bi_billings`
--


--
-- Table structure for table `bl_blacklists`
--

CREATE TABLE `bl_blacklists` (
  `bl_id` int(11) NOT NULL AUTO_INCREMENT,
  `bl_te_id` int(11) NOT NULL,
  `bl_callerid` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `bl_inserted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `bl_reason` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`bl_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `bl_blacklists`
--


--
-- Table structure for table `bl_buttonlayouts`
--

CREATE TABLE `bl_buttonlayouts` (
  `bl_id` int(11) NOT NULL AUTO_INCREMENT,
  `bl_te_id` int(11) NOT NULL,
  `bl_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bl_code` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `bl_start` int(11) NOT NULL,
  `bl_end` int(11) NOT NULL,
  `bl_bt_id` int(11) NOT NULL DEFAULT '0',
  `bl_pb_id` int(11) NOT NULL DEFAULT '0',
  `bl_usephonebook` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `bl_phonebookorderid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`bl_id`),
  KEY `bl_te_id` (`bl_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `bl_buttonlayouts`
--


--
-- Table structure for table `bt_buttonlayouttemplates`
--

CREATE TABLE `bt_buttonlayouttemplates` (
  `bt_id` int(11) NOT NULL AUTO_INCREMENT,
  `bt_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `bt_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `bt_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `bt_start` int(11) NOT NULL DEFAULT '0',
  `bt_end` int(11) NOT NULL DEFAULT '0',
  `bt_template` blob NOT NULL,
  `bt_lock` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `bt_lockpassword` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`bt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `bt_buttonlayouttemplates`
--


--
-- Table structure for table `ca_calleridmods`
--

CREATE TABLE `ca_calleridmods` (
  `ca_id` int(11) NOT NULL AUTO_INCREMENT,
  `ca_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ca_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ca_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ca_calleridmods`
--


--
-- Table structure for table `ca_campaigns`
--

CREATE TABLE `ca_campaigns` (
  `ca_id` int(11) NOT NULL AUTO_INCREMENT,
  `ca_te_id` int(11) NOT NULL,
  `ca_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ca_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'SCHEDULED',
  `ca_datestart` date NOT NULL,
  `ca_dateend` date NOT NULL,
  `ca_co_id` int(11) NOT NULL,
  `ca_maxchannels` int(11) NOT NULL,
  `ca_maxattempts` int(11) NOT NULL,
  `ca_callerid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ca_calldelay` int(11) NOT NULL,
  `ca_state` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ca_lastrun` datetime NOT NULL,
  `ca_dialtimeout` int(11) NOT NULL,
  `ca_hosted` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ca_tech` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'VOICE',
  `ca_message` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ca_recording` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ca_cr_id` int(11) NOT NULL DEFAULT '0',
  `ca_qu_id` int(11) NOT NULL DEFAULT '0',
  `ca_minfreeagents` int(11) NOT NULL DEFAULT '0',
  `ca_emailrecording` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ca_minemailrecording` int(11) NOT NULL DEFAULT '0',
  `ca_retrytime` int(11) NOT NULL DEFAULT '0',
  `ca_channelsforfreeagents` int(11) NOT NULL DEFAULT '2',
  `ca_onconnect_calleridname` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ca_calleridname` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ca_id`),
  KEY `ca_te_id` (`ca_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ca_campaigns`
--


--
-- Table structure for table `ca_cdranalyze`
--

CREATE TABLE `ca_cdranalyze` (
  `ca_id` int(11) NOT NULL AUTO_INCREMENT,
  `ca_session` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ca_start` datetime DEFAULT NULL,
  `ca_answer` datetime DEFAULT NULL,
  `ca_end` datetime DEFAULT NULL,
  `ca_realsrc` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ca_firstdst` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ca_lastdst` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ca_disposition` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ca_direction` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ca_callstart` datetime DEFAULT NULL,
  `ca_callend` datetime DEFAULT NULL,
  `ca_callerip` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ca_calledip` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ca_a_lost` int(11) DEFAULT NULL,
  `ca_b_lost` int(11) DEFAULT NULL,
  `ca_a_avgjitter_mult10` int(11) DEFAULT NULL,
  `ca_b_avgjitter_mult10` int(11) DEFAULT NULL,
  `ca_a_maxjitter` int(11) DEFAULT NULL,
  `ca_b_maxjitter` int(11) DEFAULT NULL,
  `ca_a_mos_f1_mult10` int(11) DEFAULT NULL,
  `ca_a_mos_f2_mult10` int(11) DEFAULT NULL,
  `ca_a_mos_adapt_mult10` int(11) DEFAULT NULL,
  `ca_b_mos_f1_mult10` int(11) DEFAULT NULL,
  `ca_b_mos_f2_mult10` int(11) DEFAULT NULL,
  `ca_b_mos_adapt_mult10` int(11) DEFAULT NULL,
  `ca_packet_loss_perc_mult1000` int(11) DEFAULT NULL,
  `ca_mos_min_mult10` int(11) DEFAULT NULL,
  `ca_a_mos_min_mult10` int(11) DEFAULT NULL,
  `ca_b_mos_min_mult10` int(11) DEFAULT NULL,
  `ca_processtime` int(11) DEFAULT NULL,
  `ca_duration` int(11) DEFAULT '0',
  `ca_payload` int(11) DEFAULT NULL,
  `ca_other_payload` int(11) DEFAULT NULL,
  PRIMARY KEY (`ca_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ca_cdranalyze`
--


--
-- Table structure for table `cc_callcosts`
--

CREATE TABLE `cc_callcosts` (
  `cc_id` int(11) NOT NULL AUTO_INCREMENT,
  `cc_te_id` int(11) NOT NULL,
  `cc_uniqueid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cc_cost` decimal(10,5) NOT NULL,
  `cc_bi_id` int(11) NOT NULL,
  `cc_cdr_sequence` int(11) NOT NULL,
  `cc_pr_id` int(11) NOT NULL,
  `cc_buy` decimal(10,5) NOT NULL,
  `cc_ex_id` int(11) DEFAULT NULL,
  `cc_peername` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cc_date` date DEFAULT NULL,
  `cc_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'OUTBOUND',
  `cc_type_id` int(11) DEFAULT NULL,
  `cc_country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cc_network` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cc_international` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`cc_id`),
  KEY `cc_te_id` (`cc_te_id`,`cc_bi_id`),
  KEY `cc_uniqueid` (`cc_uniqueid`),
  KEY `cc_date` (`cc_date`,`cc_peername`),
  KEY `cc_te_id_2` (`cc_te_id`,`cc_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cc_callcosts`
--


--
-- Table structure for table `cc_cnamecache`
--

CREATE TABLE `cc_cnamecache` (
  `cc_id` int(11) NOT NULL AUTO_INCREMENT,
  `cc_number` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `cc_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `cc_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cc_manual` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `cc_te_id` int(11) NOT NULL DEFAULT '-1',
  `cc_note` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`cc_id`),
  UNIQUE KEY `cc_number` (`cc_te_id`,`cc_number`),
  KEY `cc_datetime` (`cc_te_id`,`cc_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cc_cnamecache`
--


--
-- Table structure for table `cd_codecs`
--

CREATE TABLE `cd_codecs` (
  `cd_id` int(11) NOT NULL AUTO_INCREMENT,
  `cd_name` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `cd_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cd_ptime` int(11) NOT NULL DEFAULT '20',
  `cd_type` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`cd_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cd_codecs`
--

INSERT INTO `cd_codecs` VALUES (1,'alaw','G.711 A-law',20,'AUDIO'),(2,'ulaw','G.711 u-law',20,'AUDIO'),(3,'g722','G.722',20,'AUDIO'),(4,'g723','G.723.1',20,'AUDIO'),(5,'g726','G.726 RFC3551',20,'AUDIO'),(6,'adpcm','ADPCM',20,'AUDIO'),(7,'lpc10','LPC10',20,'AUDIO'),(8,'g729','G.729A',20,'AUDIO'),(9,'speex','SpeeX',20,'AUDIO'),(10,'speex16','SpeeX 16khz',20,'AUDIO'),(11,'ilbc','iLBC',20,'AUDIO'),(12,'g726aal2','G.726 AAL2',20,'AUDIO'),(13,'g722','G722',20,'AUDIO'),(14,'gsm','GSM',20,'AUDIO'),(15,'h261','H.261 Video',20,'VIDEO'),(16,'h263','H.263 Video',20,'VIDEO'),(17,'h263p','H.263+ Video',20,'VIDEO'),(18,'h264','H.264 Video',20,'VIDEO'),(19,'mpeg4','MPEG4 Video',20,'VIDEO'),(20,'siren7','ITU G.722.1 (Siren7, licensed from Polycom)',20,'AUDIO'),(21,'siren14','ITU G.722.1 Annex C, (Siren14, licensed from Polycom)',20,'AUDIO'),(22,'g719','ITU G.719',20,'AUDIO'),(25,'speex32','SpeeX 32khz',20,'AUDIO');

--
-- Table structure for table `ce_conditions_extended`
--

CREATE TABLE `ce_conditions_extended` (
  `ce_id` int(11) NOT NULL AUTO_INCREMENT,
  `ce_te_id` int(11) NOT NULL,
  `ce_co_id` int(11) NOT NULL,
  `ce_param1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ce_param2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ce_param3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ce_param4` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ce_id`),
  KEY `ce_co_id` (`ce_co_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ce_conditions_extended`
--


--
-- Table structure for table `ce_customextensions`
--

CREATE TABLE `ce_customextensions` (
  `ce_id` int(11) NOT NULL AUTO_INCREMENT,
  `ce_te_id` int(11) NOT NULL,
  `ce_dialoption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ce_auth_type` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ce_pr_id` int(11) NOT NULL DEFAULT '0',
  `ce_auth_parameter` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ce_peername` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ce_usecid` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'EXTERNAL',
  PRIMARY KEY (`ce_id`),
  KEY `ce_te_id` (`ce_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ce_customextensions`
--


--
-- Table structure for table `ce_customs_extended`
--

CREATE TABLE `ce_customs_extended` (
  `ce_id` int(11) NOT NULL AUTO_INCREMENT,
  `ce_te_id` int(11) NOT NULL,
  `ce_cu_id` int(11) NOT NULL,
  `ce_param1` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ce_param2` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ce_param3` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ce_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ce_customs_extended`
--


--
-- Table structure for table `cf_customfiles`
--

CREATE TABLE `cf_customfiles` (
  `cf_id` int(11) NOT NULL AUTO_INCREMENT,
  `cf_te_id` int(11) NOT NULL,
  `cf_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cf_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cf_data` longblob NOT NULL,
  `cf_size` int(11) NOT NULL,
  `cf_md5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cf_useragentregex` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`cf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cf_customfiles`
--


--
-- Table structure for table `cg_callgroups`
--

CREATE TABLE `cg_callgroups` (
  `cg_id` int(11) NOT NULL AUTO_INCREMENT,
  `cg_te_id` int(11) NOT NULL,
  `cg_ex_id` int(11) NOT NULL,
  `cg_value` int(11) NOT NULL,
  PRIMARY KEY (`cg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cg_callgroups`
--


--
-- Table structure for table `ch_channels`
--

CREATE TABLE `ch_channels` (
  `ch_id` int(11) NOT NULL AUTO_INCREMENT,
  `ch_server` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ch_extension` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ch_channel` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ch_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ch_callerid` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ch_direction` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ch_id`),
  KEY `ch_channel` (`ch_channel`),
  KEY `ch_extension` (`ch_extension`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ch_channels`
--


--
-- Table structure for table `cl_clientrates`
--

CREATE TABLE `cl_clientrates` (
  `cl_id` int(11) NOT NULL AUTO_INCREMENT,
  `cl_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `cl_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cl_customratescript` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cl_ratescripttech` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'AGI',
  PRIMARY KEY (`cl_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cl_clientrates`
--


--
-- Table structure for table `cl_conferenceroomlogs`
--

CREATE TABLE `cl_conferenceroomlogs` (
  `cl_id` int(11) NOT NULL AUTO_INCREMENT,
  `cl_te_id` int(11) NOT NULL,
  `cl_start` datetime NOT NULL,
  `cl_end` datetime DEFAULT NULL,
  `cl_cr_id` int(11) NOT NULL,
  `cl_pinused` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `cl_calleridname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cl_calleridnum` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cl_uniqueid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cl_meetmesecs` int(11) DEFAULT NULL,
  `cl_reportsent` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `cl_conferencestart` datetime NOT NULL,
  `cl_conferenceend` datetime NOT NULL,
  `cl_prevuniqueid` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`cl_id`),
  KEY `cl_te_id` (`cl_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cl_conferenceroomlogs`
--


--
-- Table structure for table `cn_campaignnumbers`
--

CREATE TABLE `cn_campaignnumbers` (
  `cn_id` int(11) NOT NULL AUTO_INCREMENT,
  `cn_te_id` int(11) NOT NULL,
  `cn_ca_id` int(11) NOT NULL,
  `cn_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cn_disposition` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cn_attempts` int(11) NOT NULL,
  `cn_lastattempt` datetime NOT NULL,
  `cn_description` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `cn_billsec` int(11) NOT NULL,
  `cn_field1` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cn_field2` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cn_field3` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cn_field4` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cn_field5` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cn_field6` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cn_field7` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cn_field8` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cn_field9` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cn_field10` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`cn_id`),
  KEY `cn_te_id` (`cn_te_id`),
  KEY `cn_ca_id` (`cn_ca_id`),
  KEY `cn_ca_te_id` (`cn_ca_id`,`cn_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cn_campaignnumbers`
--


--
-- Table structure for table `co_conditions`
--

CREATE TABLE `co_conditions` (
  `co_id` int(11) NOT NULL AUTO_INCREMENT,
  `co_te_id` int(11) NOT NULL,
  `co_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `co_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `co_timezone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `co_param1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `co_param2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `co_param3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `co_param4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `co_param5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `co_param6` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `co_param7` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `co_param8` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `co_param9` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `co_param10` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `co_param11` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `co_param12` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `co_param13` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `co_param14` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `co_param15` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`co_id`),
  KEY `co_te_id` (`co_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `co_conditions`
--


--
-- Table structure for table `co_countries`
--

CREATE TABLE `co_countries` (
  `co_code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `co_country` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`co_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `co_countries`
--


--
-- Table structure for table `cp_clustersportal`
--

CREATE TABLE `cp_clustersportal` (
  `cp_id` int(11) NOT NULL AUTO_INCREMENT,
  `cp_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cp_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cp_apikey` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cp_th_id` int(11) NOT NULL DEFAULT '0',
  `cp_includedids` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`cp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cp_clustersportal`
--


--
-- Table structure for table `cp_customextensionproviders`
--

CREATE TABLE `cp_customextensionproviders` (
  `cp_id` int(11) NOT NULL AUTO_INCREMENT,
  `cp_te_id` int(11) NOT NULL,
  `cp_ex_id` int(11) NOT NULL,
  `cp_pr_id` int(11) NOT NULL,
  PRIMARY KEY (`cp_id`),
  KEY `cp_te_id` (`cp_te_id`),
  KEY `cp_ex_id` (`cp_ex_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cp_customextensionproviders`
--


--
-- Table structure for table `cr_calleridmodrules`
--

CREATE TABLE `cr_calleridmodrules` (
  `cr_id` int(11) NOT NULL AUTO_INCREMENT,
  `cr_ca_id` int(11) NOT NULL,
  `cr_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cr_regex` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cr_adddigits` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cr_deldigits` int(11) NOT NULL,
  PRIMARY KEY (`cr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cr_calleridmodrules`
--


--
-- Table structure for table `cr_calleridregexs`
--

CREATE TABLE `cr_calleridregexs` (
  `cr_id` int(11) NOT NULL AUTO_INCREMENT,
  `cr_te_id` int(11) NOT NULL,
  `cr_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cr_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`cr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cr_calleridregexs`
--


--
-- Table structure for table `cr_callreservations`
--

CREATE TABLE `cr_callreservations` (
  `cr_id` int(11) NOT NULL AUTO_INCREMENT,
  `cr_te_id` int(11) NOT NULL,
  `cr_caller` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cr_called` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cr_datetime` datetime NOT NULL,
  PRIMARY KEY (`cr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cr_callreservations`
--


--
-- Table structure for table `cr_conferencerooms`
--

CREATE TABLE `cr_conferencerooms` (
  `cr_id` int(11) NOT NULL AUTO_INCREMENT,
  `cr_te_id` int(11) NOT NULL,
  `cr_number` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `cr_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cr_hosted` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cr_bookid` int(11) NOT NULL,
  `cr_rrid` int(11) NOT NULL DEFAULT '0',
  `cr_sendreport` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `cr_sendreportemail` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cr_sendreportemailfromdate` datetime DEFAULT NULL,
  `cr_requestpinmeid` int(11) NOT NULL DEFAULT '0',
  `cr_pinenteredmeid` int(11) NOT NULL DEFAULT '0',
  `cr_adminpinenteredmeid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cr_id`),
  KEY `cr_te_id` (`cr_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cr_conferencerooms`
--


--
-- Table structure for table `cr_cronjobs`
--

CREATE TABLE `cr_cronjobs` (
  `cr_id` int(11) NOT NULL AUTO_INCREMENT,
  `cr_te_id` int(11) NOT NULL,
  `cr_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cr_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cr_no_id` int(11) NOT NULL,
  `cr_active` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `cr_minute` varchar(11) COLLATE utf8_unicode_ci NOT NULL,
  `cr_hour` varchar(11) COLLATE utf8_unicode_ci NOT NULL,
  `cr_day` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cr_month` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cr_weekday` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cr_laststarted` datetime NOT NULL,
  `cr_lastended` datetime NOT NULL,
  `cr_run` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cr_once` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cr_lastping` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cr_pid` int(11) NOT NULL DEFAULT '0',
  `cr_timezone` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cr_year` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`cr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cr_cronjobs`
--


--
-- Table structure for table `csv_importer`
--

CREATE TABLE `csv_importer` (
  `csv_id` int(11) NOT NULL AUTO_INCREMENT,
  `csv_session` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `csv_rownum` int(11) NOT NULL,
  `csv_date` date NOT NULL,
  `csv_data` blob,
  PRIMARY KEY (`csv_id`),
  KEY `csv_session` (`csv_session`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `csv_importer`
--


--
-- Table structure for table `ct_customtypes`
--

CREATE TABLE `ct_customtypes` (
  `ct_id` int(11) NOT NULL AUTO_INCREMENT,
  `ct_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ct_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ct_id`),
  KEY `ct_name` (`ct_name`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ct_customtypes`
--

INSERT INTO `ct_customtypes` VALUES (1,'FORWARD','Forward call to'),(2,'ALTERCALLERIDNAME','Alter Caller ID Name to'),(3,'ALTERCALLERID','Alter Caller ID to'),(4,'CUSTOMDIAL','Custom dial() with param.'),(5,'FEATURECODE','Use Feature Code'),(18,'SETEXTINUSE','Set Extension to in use'),(19,'SETEXTNOTINUSE','Set Extension to not in use'),(20,'TOGGLEEXTSTATE','Toggle Extension state'),(21,'SETSIPHEADER','Set SIP Header'),(22,'AGISCRIPT','Run AGI Script'),(24,'READVAR','Read a variable'),(25,'MEETMEBYPIN','Connect to a Conference by entering the PIN'),(26,'DIALAS','Just dial'),(27,'SETLANGUAGE','Set Language'),(28,'SETVAR','Set Variable'),(29,'CALLTHROUGH','Call Through'),(30,'QUEUEATPOSITION','Connect to Queue at position'),(31,'ORIGINATE','Originate a call and connect to destination'),(32,'ONANSWER','When destination answers'),(33,'CURL','Recover an URL using Curl'),(34,'EMAILTO','Email to'),(35,'PLAYCALLED','Play to the called party when answer'),(36,'LOCALMACRO','Run local macro'),(37,'LOCALMEDIA','Play mediafiles in /var/lib/asterisk/sounds'),(38,'SETDIALOPTIONS','Set Dial options'),(39,'CHANNELGROUPCOUNT','Count this channel in custom group'),(40,'SETCALLCAMPAIGNDIALSTATUS','Set call campaign latest dialed number dial status'),(41,'CONTROLPLAYBACK','Control playback'),(42,'SAYDIGITS','Say digits'),(43,'OVERRIDEVOICEMAILTYPE','Override Voicemail type and option'),(44,'LOGINQUEUEWITHPENALTY','Login caller agent to a queue with a penalty'),(45,'QUEUECALLBACKNUMBER','Place a number in the queue callback list'),(46,'ONCALLERHANGUP','When caller hangup'),(47,'SPLITCHANNELACTION','Execute separately on channels when answer'),(48,'SETEXTFMFMNUMBER','Set extension FMFM number'),(49,'ENABLEEXTFMFM','Enable extension FMFM'),(50,'DISABLEEXTFMFM','Disable extension FMFM'),(51,'LOGINEXTERNALAGENTQUEUE','Login external agent to a queue'),(52,'LOGOUTEXTERNALAGENTQUEUE','Logout external agent from a queue'),(53,'LOGINQUEUENUMBERWITHPENALTY','Login caller agent to a queue number with a penalty'),(54,'CALLBACK','Call Back'),(55,'VISUALVOICEMAIL','Play voicemail message'),(56,'SAYNUMBER','Say number'),(57,'COUNTVOICEMAILS','Count voicemails in NUMVOICEMAILS variable'),(58,'MEETMEWITHPIN','Connect to a Conference specifying the PIN'),(59,'CALLSCREENING','Call Screening'),(60,'DELETEALLVMMESSAGES','Delete all voicemail messages'),(61,'ENABLEEXTDND','Enable extension DND'),(62,'DISABLEEXTDND','Disable extension DND'),(63,'DELETEALLREADVMMESSAGES','Delete all read voicemail messages'),(64,'WAITXSECONDS','Wait X seconds'),(65,'CUSTOMSPY','Custom Spy'),(66,'PARKCALLBACK','When call parked times out, dial'),(67,'ADDNUMBERTODNC','Add a number to Do Not Call List'),(68,'LOGINAGENTQUEUEWITHPENALTY','Login agent to a queue with a penalty'),(69,'LOGOUTAGENTQUEUE','Logout agent from a queue'),(70,'VOICEMAILBROWSE','Voicemail messages browse'),(71,'SPYGROUPS','Spy Groups'),(72,'ROUTEBYPREVCALL','Route the call to the extension who has called the number'),(73,'ROUTEBYPREVSMS','Route the SMS to the extension who has sent a SMS to the sender'),(74,'ROUTEBYPREVCONNECTED','Route the call to the extension who has answered to the number'),(75,'ROUTEBYPREVQUEUECONNECTED','Route the call to the extension who has answered to the number in the selected queue'),(76,'LENNYCHATBOX','Run a Lenny style chatbox to annoy telemarketers'),(77,'SETTIMEOUT','Set timeout for a call'),(78,'SMSTO','SMS to'),(79,'WAITFORSILENCE','Wait for silence'),(80,'WAITFORNOISE','Wait for noise'),(81,'PHONEBOOKDBLOOKUP','Route the call by looking up the value from the database'),(82,'CUSTOMQUEUELOG','Generate a custom queue log entry'),(83,'SENDDTMF','Send DTMF'),(84,'ALTERCUSTOMCALLERID','Alter CallerID custom parameter'),(85,'UPDATEPHONEBOOK','Search and update/insert in a phone book'),(86,'SETQUEUERULE','Set a Queue Rule for the next Queue'),(87,'SEARCHPHONEBOOK','Search a value in the phone book'),(88,'ADDNUMBERTOCAMPAIGN','Add a number to a campaign'),(89,'NOTIFYEXTENSION','Notify an extension'),(90,'SETVMCATEGORY','Set voicemail category'),(91,'SETEXTCALLERIDNUM','Set extension outbound callerid number'),(92,'ADDTOVIRTUALEXTENSION','Add an extension to a virtual extension'),(93,'REMOVEFROMVIRTUALEXTENSION','Remove an extension from a virtual extension'),(94,'CLEANVIRTUALEXTENSION','Remove all extensions from a virtual extension'),(95,'SETCALLLIMIT','Set call/play limit'),(96,'HANGUPCHANNEL','Hangup a channel');

--
-- Table structure for table `cu_customs`
--

CREATE TABLE `cu_customs` (
  `cu_id` int(11) NOT NULL AUTO_INCREMENT,
  `cu_te_id` int(11) NOT NULL,
  `cu_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cu_ct_id` int(11) NOT NULL,
  `cu_param1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cu_param2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cu_param3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cu_param4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cu_param5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cu_param6` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cu_param7` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cu_param8` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cu_param9` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cu_param10` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cu_param11` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cu_param12` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cu_param13` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cu_param14` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cu_param15` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cu_param16` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cu_param17` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cu_param18` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cu_param19` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cu_param20` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`cu_id`),
  KEY `cu_te_id` (`cu_te_id`),
  KEY `cu_param1` (`cu_param1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cu_customs`
--


--
-- Table structure for table `dc_donotcalls`
--

CREATE TABLE `dc_donotcalls` (
  `dc_id` int(11) NOT NULL AUTO_INCREMENT,
  `dc_te_id` int(11) NOT NULL,
  `dc_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dc_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY `dc_id` (`dc_id`),
  KEY `dc_te_id` (`dc_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dc_donotcalls`
--


--
-- Table structure for table `de_destinations`
--

CREATE TABLE `de_destinations` (
  `de_id` int(11) NOT NULL AUTO_INCREMENT,
  `de_te_id` int(11) NOT NULL,
  `de_type_src` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `de_type_id_src` int(11) NOT NULL,
  `de_type_dst` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `de_type_id_dst` int(11) NOT NULL,
  `de_ord` int(11) NOT NULL,
  PRIMARY KEY (`de_id`),
  KEY `de_type_src` (`de_type_src`,`de_type_id_src`),
  KEY `de_type_dst` (`de_type_dst`,`de_type_id_dst`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `de_destinations`
--


--
-- Table structure for table `de_devstateevents`
--

CREATE TABLE `de_devstateevents` (
  `de_id` bigint(11) NOT NULL AUTO_INCREMENT,
  `de_servername` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `de_event` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `de_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `de_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`de_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `de_devstateevents`
--


--
-- Table structure for table `df_default_fields`
--

CREATE TABLE `df_default_fields` (
  `df_id` int(11) NOT NULL AUTO_INCREMENT,
  `df_section` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `df_table` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `df_column` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `df_formfield` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `df_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`df_id`)
) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `df_default_fields`
--

INSERT INTO `df_default_fields` VALUES (1,'Extensions','sipfriends','allow','codecs','Codecs'),(3,'Extensions','sipfriends','dtmfmode','dtmfmode','DTMF Mode'),(5,'DIDs','di_dids','di_maxchannels','maxchannels','Max Channels'),(6,'Extensions','sipfriends','progressinband','progressinband','Progress inband'),(8,'Extensions','ex_extensions','ex_autocallerid','autocallerid','Auto Internal CallerID'),(9,'Extensions','ex_extensions','ex_cidnum','cidnum','External CID Number'),(10,'Extensions','ex_extensions','ex_cidname','cidname','External CID Name'),(11,'DIDs','di_dids','di_cnam','cnam','Use CNAM Service'),(12,'Extensions','sipfriends','sendrpid','sendrpid','Send RPID'),(14,'Extensions','sipfriends','subscribemwi','subscribemwi','Send MWI only if subscribed'),(15,'Extensions','sipfriends','call-limit','calllimit','Call Limit'),(16,'Extensions','sipfriends','trustrpid','trustrpid','Trust RPID'),(17,'Extensions','sipfriends','nat','nat','NAT'),(18,'Extensions','sipfriends','qualify','qualify','Qualify'),(19,'Extensions','sipfriends','qualifyfreq','qualifyfreq','Qualify Frequency'),(20,'Extensions','sipfriends','keepalive','keepalive','Keep Alive'),(21,'Extensions','sipfriends','rtpkeepalive','rtpkeepalive','RTP Keep Alive'),(22,'Extensions','ex_extensions','ex_recording','recording','Always Record'),(23,'Extensions','sipfriends','host','host','Host'),(24,'Extensions','sipfriends','insecure','insecure','Insecure'),(25,'Extensions','sipfriends','transport','transport','Transport'),(26,'Extensions','sipfriends','encryption','encryption','RTP Encryption (SRTP)'),(27,'Extensions','ex_extensions','ex_callallowed','callallowed','Outbound Destinations'),(28,'Extensions','ex_extensions','ex_userpanel','userpanel','Allow Web User Panel Access'),(29,'Settings','se_settings','se_value','DIALTIMEOUT','Dial timeout'),(30,'Settings','se_settings','se_value','EXTDIALTIMEOUT','Extension Dial timeout'),(31,'Settings','se_settings','se_value','PARKTIMEOUT','Parking lot timeout'),(32,'Settings','se_settings','se_value','MAXCALLDURATION','Max call duration'),(33,'Extensions','ex_extensions','ex_dialtimeout','dialtimeout','Inbound Dial Timeout'),(34,'Extensions','de_destinations','EXT-NOANSWER','','On No Answer'),(35,'Extensions','de_destinations','EXT-BUSY','','On Extension Busy'),(36,'Extensions','de_destinations','EXT-OFFLINE','','On Extension Offline'),(37,'Extensions','ex_extensions','ex_txvolume','txvolume','Volume TX level'),(38,'Extensions','ex_extensions','ex_rxvolume','rxvolume','Volume RX level'),(39,'Extensions','ex_extensions','EXT-MUID','','Music on hold'),(40,'Extensions','ex_extensions','ex_faxgateway','faxgateway','Fax Gateway'),(41,'DIDs','di_dids','di_country','country','Country code'),(42,'DIDs','di_dids','di_smsprotocol','smsprotocol','SMS Protocol'),(43,'DIDs','di_dids','di_smsfromfield','smsfromfield','SMS From field'),(44,'DIDs','di_dids','di_smstofield','smstofield','SMS To field'),(45,'DIDs','di_dids','di_smsbodyfield','smsbodyfield','SMS Body field'),(46,'DIDs','di_dids','di_smsemail','smsemail','Send SMS to email'),(47,'DIDs','di_dids','di_sms_store','smsstore','Store SMS received'),(48,'DIDs','de_destinations','DID-SMS','smsdestination','SMS Destination'),(49,'Extensions','ex_extensions','ex_branch','branch','Branch'),(50,'Extensions','ex_extensions','ex_department','department','Department'),(51,'Extensions','sipfriends','directmedia','directmedia','Direct Media'),(52,'Extensions','sipfriends','directrtpsetup','directrtpsetup','Direct RTP Setup'),(53,'Extensions','sipfriends','mailbox','mailbox','Voicemail MWI'),(54,'Provisioning/Phones','ph_phones','ph_acceptdata','acceptdata','Accept data from phone'),(56,'Voicemails','voicemail','maxmsg','maxmsg','Max number of messages'),(57,'Voicemails','voicemail','maxsecs','maxsecs','Max len of a voicemail message in seconds'),(58,'Voicemails','voicemail','minsecs','minsecs','Min len of a voicemail message in seconds'),(59,'Extensions','ex_extensions','ex_referenceid','referenceid','Reference ID'),(60,'Extensions','ex_extensions','ex_notes','notes','Additional Info'),(61,'Extensions','sipfriends','secret','secret','Password'),(62,'Voicemails','voicemail','saycid','saycid','Say Caller ID'),(63,'Voicemails','voicemail','attach','attach','Attach message'),(64,'Voicemails','voicemail','transcript_store','transcript_store','Store transcript'),(65,'Voicemails','voicemail','deletevoicemail','deletevoicemail','Automatic delete'),(66,'Voicemails','voicemail','review','review','Allow review'),(67,'Voicemails','voicemail','welcomeoption','welcomeoption','Greeting'),(68,'Voicemails','voicemail','exitcontext','exitcontext','Allow operator/extras during greetings'),(69,'DIDs','di_dids','di_recording','recording','Always Record'),(70,'Extensions','ex_extensions','ex_callwaiting','callwaiting','Call Waiting'),(71,'DIDs','di_dids','di_allowemergency','allowemergency','Use as Emergency CallerID'),(72,'Extensions','sipfriends','name','sipusername','Username'),(73,'Voicemails','voicemail','password','password','PIN'),(74,'Extensions','ex_extensions','ex_includeinpb','includeinpb','Include in Phone Books'),(75,'DIDs','di_dids','di_minemailrecording','minemailrecording','Email recording</t> - <t>Minimum Size (bytes)'),(76,'Settings','se_settings','se_value','VMAUTORECOVER','Recover VM messages dialing your own same number'),(77,'Settings','se_settings','se_value','VMSAMEPASSWORD','When recovering your same number VM, prompt for password'),(78,'Extensions','ex_extensions','ex_fmfmdialmethod','fmfmdialmethod','FMFM Dial Method'),(79,'Extensions','ex_extensions','ex_fmfmcallerid','fmfmcallerid','FMFM Caller ID'),(80,'Extensions','sipfriends','cisco_usecallmanager','cisco_usecallmanager','Support for Cisco SIP phone features'),(81,'Extensions','sipfriends','subscribe','subscribe','Phone subscription'),(82,'Extensions','sipfriends','register','register','Bulk-register specified peer automatically'),(83,'Settings','se_settings','se_value','CALLERIDONBLIND','CallerID on blind transfer'),(84,'Extensions','ex_extensions','ex_autocidname','cidname','Auto External CID Name'),(85,'Settings','se_settings','se_value','DIALOUTDIGIT','Dialout digit'),(86,'Extensions','sipfriends','videosupport','videosupport','Video support'),(87,'Extensions','sipfriends','maxcallbitrate','maxcallbitrate','Max video bit rate'),(88,'Settings','se_settings','se_value','INTERNALRING','Internal call distinctive ring'),(89,'Settings','se_settings','se_value','EXTERNALRING','External call distinctive ring'),(90,'Settings','se_settings','se_value','TRANSFERRING','Transfer call distinctive ring'),(91,'Settings','se_settings','se_value','QUEUERING','Queue call distinctive ring'),(92,'Settings','se_settings','se_value','PARKEDCALLTIMEOUT','Parked call timeout distinctive ring'),(93,'Settings','se_settings','se_value','BLINDTRANSFEREDCALLTIMEOUTRING','Blind transfered call timeout distinctive ring'),(95,'Admin/Tenants','te_tenants','te_payment_type','paymenttype','Payment type'),(96,'Extensions','ex_extensions','ex_fmfmconfirmmessage_id','fmfmconfirmmessage_id','FMFM Confirm Message (ID)'),(97,'Extensions','ex_extensions','ex_fmfmholdmessage_id','fmfmholdmessage_id','FMFM Hold Message (ID)'),(98,'Queues','queue','wrapuptime','wrapuptime','Wrap-up time'),(99,'Queues','queue','periodic_announce_frequency','periodic_announce_frequency','Announce Frequency'),(100,'Voicemails','voicemail','nextaftercmd','nextaftercmd','Play a message after the other'),(101,'IVRs','iv_ivrs','iv_timeout','timeout','Menu selection timeout'),(102,'Admin/Tenants','te_tenants','te_allowanycalleridusage','allowanycalleridusage','Allow any Caller ID usage when dialing out'),(103,'Admin/Tenants','te_tenants','te_allowanycalleridforemerg','allowanycalleridforemerg','Allow any Caller ID usage when dialing out an emergency number'),(104,'Admin/Tenants','te_tenants','te_maxchannels','maxchannels','Max number of Inbound/Outbound Channels'),(105,'Admin/Tenants','te_tenants','te_maxanychannels','maxanychannels','Max number of Any Channel'),(106,'Extensions','sipfriends','language','language','Language'),(107,'Extensions','ex_extensions','ex_autoanswer','autoanswer','Autoanswer'),(108,'Extensions','sipfriends','outboundproxy','outboundproxy','Outbound Proxy'),(109,'Extensions','ex_extensions','ex_fromfilterregex','fromfilterregex','Regex Filter on SIP From'),(110,'Extensions','ex_extensions','ex_costlimits','costlimits','Apply call cost limits'),(111,'Extensions','ex_extensions','ex_alertemail','alertemail','Alert email'),(112,'Extensions','ex_extensions','ex_overridesippermit','overridesippermit','Override Tenant IP Restrictions'),(113,'Extensions','ex_extensions','ex_prefix','prefix','Area Code'),(114,'Extensions','ex_extensions','ex_regexprefix','regexprefix','Area Code Regex'),(115,'Extensions','ex_extensions','ex_rp_id','rpid','Routing Profile'),(116,'Extensions','ex_extensions','ex_cl_id','clid','Call Rate'),(117,'Extensions','ex_extensions','ex_fmfmnumprefix','fmfmnumprefix','FMFM Caller ID Num Prefix'),(118,'Extensions','ex_extensions','ex_fmfmnameprefix','fmfmnameprefix','FMFM Caller ID Name Prefix'),(119,'Extensions','ex_extensions','ex_fmfmdialtimeout','fmfmdialtimeout','FMFM Dial Timeout'),(120,'Extensions','ex_extensions','ex_abusedetection','abusedetection','Abuse detection'),(121,'Queues','qu_queues','qu_allowoptimization','allowoptimization','Allow Call Optmization'),(122,'Settings','se_settings','se_value','BLINDDIALTIMEOUT','Blind transfer dial timeout'),(123,'Extensions','ex_extensions','ex_trunk','trunk','Trunk'),(124,'DIDs','di_dids','di_smsanswer','smsanswer','HTTP Answer'),(125,'Extensions','sipfriends','secret','secret','SIP Password'),(126,'Provisioning/Phones','ph_phones','ph_password','password','Secret'),(127,'Extensions','ex_extensions','ex_emergencycidnum','emergencycidnum','Emergency CID Number'),(128,'Queues','aq_allowed_queue_member','aq_uniqueid','allowedagents','Allowed Agents'),(129,'DIDs','di_dids','di_faxprotocol','faxprotocol','Fax protocol'),(130,'Extensions','ex_extensions','ex_spygroups','spygroups','Spy Groups'),(131,'Queues','qu_queues','qu_spygroups','spygroups','Spy Groups'),(132,'Settings','se_settings','se_value','SMSSENDERHOST','SMS sender host'),(133,'Queues','queue','announce_holdtime','announce_holdtime','Announce holdtime'),(134,'Queues','queue','announce_position','announce_position','Announce position'),(135,'Queues','queue','timeout','timeout','Agent timeout'),(136,'Admin/Users','us_users','us_up_id','up_id','User Profile'),(137,'Provisioning/Phones','ph_phones','ph_filename','filename','Optional file name'),(138,'Provisioning/Phones','ph_phones','ph_http_user','http_user','HTTP/S Username'),(139,'Provisioning/Phones','ph_phones','ph_http_password','http_password','HTTP/S Password'),(140,'Settings','se_settings','se_value','AGICALLEND','On call end, run AGI script'),(141,'Extensions','ex_extensions','ex_tech','tech','SIP stack'),(142,'Queues','qu_queues','qu_calltimeout','calltimeout','Max Call duration'),(143,'Extensions','ex_extensions','ex_cr_id','calleridregex','Use CallerID Regex'),(144,'DIDs','di_dids','di_emergencynotes','emergencynotes','Emergency Notes'),(145,'DIDs','di_dids','di_ibid','ibid','Inbound Call Rate'),(146,'Queues','qu_queues','qu_alwaysrecord','alwaysrecord','Always Record'),(147,'Queues','qu_queues','qu_hosted','hosted','Queue server'),(148,'Hunt Lists','hu_huntlists','hu_fastdialing','fastdialing','Use fast dialing'),(149,'Extensions','ex_extensions','ex_webrtcsupport','webrtcsupport','WebRTC Support'),(150,'Extensions','sipfriends','port','port','Port'),(151,'Admin/Tenants','te_tenants','te_alertemail','alertemail','Alert email'),(152,'Extensions/AORs','ps_aors','default_expiration','default_expiration','Default Expiration'),(153,'Extensions/AORs','ps_aors','minimum_expiration','minimum_expiration','Minimum Expiration'),(154,'Extensions/AORs','ps_aors','maximum_expiration','maximum_expiration','Maximum Expiration'),(155,'Extensions','ex_extensions','ex_smscidnum','smscidnum','External SMS CID Number:'),(156,'Extensions','ex_extensions','ex_emailrecording','emailrecording','Email recording to'),(157,'Extensions','ex_extensions','ex_useragentsecurity','useragentsecurity','Learn Regex Filter on SIP User Agent'),(158,'Extensions','ex_extensions','ex_useragentallowed','useragentallowed','Regex Filter on SIP User Agent'),(159,'Admin/Themes','th_themes','th_theme','theme','Theme'),(160,'Extensions/AORs','ps_aors','max_contacts','max_contacts','Max Contacts'),(161,'Extensions','ex_extensions','ex_trunkemergencycidoverride','trunkemergencycidoverride','Emergency CallerID Number Override'),(162,'Settings','se_settings','se_value','RECORDOTHERLEG','Record also the other leg'),(163,'Extensions','ps_endpoints','tos_audio','tos_audio','TOS audio'),(164,'Extensions','ps_endpoints','tos_video','tos_video','TOS video'),(165,'Extensions','ps_endpoints','cos_audio','cos_audio','COS audio'),(166,'Extensions','ps_endpoints','cos_video','cos_video','COS video'),(167,'Settings','se_settings','se_value','SKIPFMFMLOCALCONFIRM','Skip confirmation on local call for simultaneous FMFM'),(168,'Queues','queue','eventmemberstatus','eventmemberstatus','Generate AMI Events for member status'),(169,'Queues','queue','eventwhencalled','eventwhencalled','Generate AMI Events when agent called'),(170,'Voicemails','voicemail','autodeleteolder','autodeleteolder','Delete older messages'),(171,'Extensions','ps_endpoints','connected_line_method','connected_line_method','Connected Line Method'),(172,'Extensions','ex_extensions','ex_webphone','webphone','Allow Web Phone Usage'),(173,'Extensions','ps_endpoints','dtls_cert_file','dtls_cert_file','DTLS certificate file path'),(174,'Extensions','ps_endpoints','dtls_ca_file','dtls_ca_file','DTLS CA certificate file path'),(175,'Settings','se_settings','se_value','CALLERIDONATTENDED','CallerID on attended transfer'),(176,'Extensions','ps_endpoints','send_pai','send_pai','Send PAI'),(177,'Extensions','ex_extensions','ex_prefixdefault','prefixdefault','Area Code Use Default'),(178,'Extensions','ex_extensions','ex_regexprefixdefault','regexprefixdefault','Area Code Regex Use Default'),(179,'Extensions','ex_extensions','ex_emergencynotes','emergencynotes','Emergency Notes'),(180,'Settings','se_settings','se_value','ALWAYSRECORD','Always Record'),(181,'Admin/Tenants','te_tenants','te_rp_id','rpid','Routing profile'),(182,'Admin/Tenants','te_tenants','te_cl_id','callrate','Call rate'),(183,'Admin/Tenants','te_tenants','te_billonnet','billonnet','Bill onnet calls'),(184,'Provisioning/Phones','ph_phones','ph_pm_id','pmid','Phone Model'),(185,'Queues','queue','autofill','autofill','Auto fill'),(186,'Extensions','ps_endpoints','rpid_immediate','rpid_immediate','RPID Immediate'),(187,'Extensions','ps_endpoints','dtls_auto_generate_cert','dtls_auto_generate_cert','DTLS Auto generate certificate'),(188,'Settings','se_settings','se_value','FASTPROVQRCODE','Fast provisioning QR Code'),(189,'Settings','se_settings','se_value','ENABLEFASTPROVQRCODE','Fast provisioning QR Code - Enabled'),(191,'Extensions/AORs','ps_aors','remove_existing','remove_existing','Remove Existing'),(192,'Voicemails','voicemail','transcript_generate','transcript_generate','Generate transcript'),(193,'Settings','se_settings','se_value','READONLYAPIKEY','Read Only API Key'),(194,'Settings','se_settings','se_value','APIKEY','API Key'),(195,'Extensions','ex_extensions','ex_alertwhenoffline','alertwhenoffline','Alert when offline'),(196,'Admin/Tenants','te_tenants','te_allowincomingcalleridusage','allowincomingcalleridusage','Allow incoming Caller ID usage when dialing out');

--
-- Table structure for table `di_dids`
--

CREATE TABLE `di_dids` (
  `di_id` int(11) NOT NULL AUTO_INCREMENT,
  `di_te_id` int(11) NOT NULL,
  `di_country` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `di_area` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `di_number` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `di_comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `di_recording` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `di_didprefix` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `di_fax` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `di_faxstationid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `di_faxheaderinfo` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `di_faxprotocol` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `di_fax_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `di_fax_store` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `di_didnameprefix` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `di_unconditionalstatus` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `di_maxchannels` int(11) NOT NULL DEFAULT '-1',
  `di_cnam` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `di_allowemergency` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `di_emergencynotes` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `di_ibid` int(11) NOT NULL,
  `di_emailrecording` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `di_admincomment` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `di_notifyunassigned` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'on',
  `di_minemailrecording` int(11) NOT NULL,
  `di_dp_id` int(11) NOT NULL DEFAULT '0',
  `di_provider_info` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `di_provider_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `di_smsprotocol` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `di_smsfromfield` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `di_smstofield` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `di_smsbodyfield` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `di_sms_store` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `di_smsemail` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `di_branch` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `di_department` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `di_storeandforwardnumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `di_notifymaxchannels` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
  `di_faxprinturl` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `di_smsanswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `di_mmslinkfield` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `di_faxprinturlformat` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'PDF',
  `di_mmslinkauthprovider` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`di_id`),
  UNIQUE KEY `di_country` (`di_country`,`di_area`,`di_number`),
  KEY `di_te_id` (`di_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `di_dids`
--


--
-- Table structure for table `di_digitalfaxes`
--

CREATE TABLE `di_digitalfaxes` (
  `di_id` int(11) NOT NULL AUTO_INCREMENT,
  `di_te_id` int(11) NOT NULL,
  `di_number` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `di_comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`di_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `di_digitalfaxes`
--


--
-- Table structure for table `dl_dialingrules`
--

CREATE TABLE `dl_dialingrules` (
  `dl_id` int(11) NOT NULL AUTO_INCREMENT,
  `dl_rp_id` int(11) NOT NULL,
  `dl_no_id` int(11) NOT NULL,
  `dl_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dl_regex` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dl_masklen` int(11) NOT NULL,
  `dl_pr_id` int(11) NOT NULL,
  `dl_adddigits` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dl_deldigits` int(11) NOT NULL,
  `dl_uselcr` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `dl_priority` int(11) NOT NULL,
  `dl_order` int(11) NOT NULL,
  `dl_weight` int(11) NOT NULL,
  `dl_emergencyroute` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `dl_usepin` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `dl_paused` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  UNIQUE KEY `dl_id` (`dl_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dl_dialingrules`
--


--
-- Table structure for table `dl_dnc_numbers`
--

CREATE TABLE `dl_dnc_numbers` (
  `dl_id` int(11) NOT NULL AUTO_INCREMENT,
  `dl_te_id` int(11) NOT NULL,
  `dl_dc_id` int(11) NOT NULL,
  `dl_number` char(20) COLLATE utf8_unicode_ci NOT NULL,
  `dl_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`dl_id`),
  KEY `dl_te_id` (`dl_te_id`,`dl_dc_id`,`dl_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dl_dnc_numbers`
--


--
-- Table structure for table `dn_dialbyname`
--

CREATE TABLE `dn_dialbyname` (
  `dn_id` int(11) NOT NULL AUTO_INCREMENT,
  `dn_te_id` int(11) NOT NULL,
  `dn_type_id` int(11) NOT NULL DEFAULT '0',
  `dn_number` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `dn_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'EXT',
  PRIMARY KEY (`dn_id`),
  KEY `dn_te_id` (`dn_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dn_dialbyname`
--


--
-- Table structure for table `dp_didproviders`
--

CREATE TABLE `dp_didproviders` (
  `dp_id` int(11) NOT NULL AUTO_INCREMENT,
  `dp_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dp_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dp_host` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dp_port` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dp_username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dp_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dp_account` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`dp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dp_didproviders`
--


--
-- Table structure for table `ds_disas`
--

CREATE TABLE `ds_disas` (
  `ds_id` int(11) NOT NULL AUTO_INCREMENT,
  `ds_te_id` int(11) NOT NULL,
  `ds_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ds_me_id` int(11) NOT NULL,
  `ds_pin` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `ds_outbound` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `ds_blockcid` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `ds_calleridnum` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ds_calleridname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ds_digitstimeout` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ds_id`),
  KEY `ds_te_id` (`ds_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ds_disas`
--


--
-- Table structure for table `dt_datetimeformats`
--

CREATE TABLE `dt_datetimeformats` (
  `dt_id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dt_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`dt_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dt_datetimeformats`
--

INSERT INTO `dt_datetimeformats` VALUES (1,'%Y-%m-%d %H:%M:%S','%Y-%m-%d %H:%M:%S - 2016-07-19 14:23:12'),(2,'%d/%m/%Y %H:%M:%S','%d/%m/%Y %H:%M:%S - 19/07/2016 14:23:12'),(3,'%d %B %Y %H:%M:%S','%d %B %Y %H:%M:%S - 19 July 2016 14:23:12'),(4,'%d %b %H:%M:%S','%d %b %H:%M:%S - 19 Jul 14:23:12');

--
-- Table structure for table `dv_default_values`
--

CREATE TABLE `dv_default_values` (
  `dv_id` int(11) NOT NULL AUTO_INCREMENT,
  `dv_df_id` int(11) NOT NULL,
  `dv_te_id` int(11) NOT NULL,
  `dv_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dv_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `dv_show` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`dv_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dv_default_values`
--

INSERT INTO `dv_default_values` VALUES (1,8,0,'on','Locked','Hidden'),(2,80,0,'','Locked','Hidden'),(3,81,0,'','Locked','Hidden'),(4,82,0,'','Locked','Hidden'),(5,86,0,'yes','Locked','Hidden'),(6,87,0,'384','Locked','Hidden'),(7,102,0,'on','Free','Shown'),(8,103,0,'on','Free','Shown'),(9,121,0,'','Locked','Unavail'),(10,128,0,'','Free','Hidden'),(11,130,0,'','Free','Hidden'),(12,131,0,'','Free','Hidden'),(13,148,0,'on','Free','Show'),(14,155,0,'','Free','Hidden'),(15,160,99,'','Free','Show'),(16,168,0,'on','Free','Hidden'),(17,169,0,'on','Free','Hidden'),(18,179,0,'','Locked','Hidden'),(19,193,0,'RANDOM16','Free','Shown'),(20,194,0,'RANDOM16','Free','Shown');

--
-- Table structure for table `ea_externalagents`
--

CREATE TABLE `ea_externalagents` (
  `ea_id` int(11) NOT NULL AUTO_INCREMENT,
  `ea_te_id` int(11) NOT NULL,
  `ea_number` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ea_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ea_id`),
  KEY `ea_te_id` (`ea_te_id`),
  KEY `ea_number` (`ea_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ea_externalagents`
--


--
-- Table structure for table `ed_emailtemplateprofiledetails`
--

CREATE TABLE `ed_emailtemplateprofiledetails` (
  `ed_id` int(11) NOT NULL AUTO_INCREMENT,
  `ed_ep_id` int(11) NOT NULL,
  `ed_et_id` int(11) NOT NULL,
  PRIMARY KEY (`ed_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ed_emailtemplateprofiledetails`
--


--
-- Table structure for table `ed_extensiondialings`
--

CREATE TABLE `ed_extensiondialings` (
  `ed_id` int(11) NOT NULL AUTO_INCREMENT,
  `ed_te_id` int(11) NOT NULL,
  `ed_from` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ed_to` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ed_advanced` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ed_id`),
  KEY `ed_te_id` (`ed_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ed_extensiondialings`
--


--
-- Table structure for table `ee_extensionevents`
--

CREATE TABLE `ee_extensionevents` (
  `ee_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ee_extension` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ee_event` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ee_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ee_ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ee_parameter` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ee_id`),
  KEY `ee_extension` (`ee_extension`),
  KEY `ee_datetime` (`ee_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ee_extensionevents`
--


--
-- Table structure for table `ep_emailtemplateprofiles`
--

CREATE TABLE `ep_emailtemplateprofiles` (
  `ep_id` int(11) NOT NULL AUTO_INCREMENT,
  `ep_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ep_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ep_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ep_emailtemplateprofiles`
--


--
-- Table structure for table `es_phonebookexternalsources`
--

CREATE TABLE `es_phonebookexternalsources` (
  `es_id` int(11) NOT NULL AUTO_INCREMENT,
  `es_te_id` int(11) NOT NULL,
  `es_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `es_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `es_param1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `es_param2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `es_param3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `es_param4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `es_param5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `es_param6` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `es_param7` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `es_param8` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `es_param9` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `es_param10` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`es_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `es_phonebookexternalsources`
--


--
-- Table structure for table `et_emailtemplates`
--

CREATE TABLE `et_emailtemplates` (
  `et_id` int(11) NOT NULL AUTO_INCREMENT,
  `et_te_id` int(11) NOT NULL,
  `et_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `et_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `et_active` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `et_sendername` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `et_senderemail` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `et_subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `et_text` longblob NOT NULL,
  `et_language` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `et_allowattachment` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'on',
  `et_priority` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`et_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `et_emailtemplates`
--


--
-- Table structure for table `ex_extensions`
--

CREATE TABLE `ex_extensions` (
  `ex_id` int(11) NOT NULL AUTO_INCREMENT,
  `ex_te_id` int(11) NOT NULL,
  `ex_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ex_tech` enum('SIP','IAX2','VIRTUAL','PJSIP','CUSTOM') COLLATE utf8_unicode_ci DEFAULT NULL,
  `ex_number` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `ex_trunk` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_tech_id` int(11) NOT NULL,
  `ex_cidnum` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `ex_cidname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ex_cidusage` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `ex_blockcid` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `ex_prefix` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `ex_mindigitprefix` int(11) NOT NULL,
  `ex_maxdigitprefix` int(11) NOT NULL,
  `ex_fmfmstatus` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ex_fmfmnumber` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ex_fmfmdialtimeout` int(11) NOT NULL,
  `ex_fmfmdialmethod` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ex_fmfmcallerid` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ex_fmfmnumprefix` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ex_fmfmnameprefix` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ex_recording` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_dialtimeout` int(11) NOT NULL,
  `ex_callgroup` int(11) NOT NULL,
  `ex_pickupgroup` int(11) NOT NULL,
  `ex_unconditionalstatus` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ex_onbusystatus` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ex_onofflinestatus` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ex_onnoanswerstatus` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ex_callallowed` varchar(40) COLLATE utf8_unicode_ci DEFAULT 'all',
  `ex_destallowregex` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `ex_rp_id` int(11) NOT NULL,
  `ex_dnd` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `ex_emergencycidnum` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `ex_webpassword` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ex_up_id` int(11) NOT NULL,
  `ex_userpanel` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `ex_datecreation` datetime DEFAULT NULL,
  `ex_emailrecording` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ex_fmfmconfirm` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ex_fmfmconfirmmessage_id` int(11) NOT NULL,
  `ex_minemailrecording` int(11) NOT NULL,
  `ex_branch` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ex_department` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ex_autocallerid` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'on',
  `ex_trunkcidoverride` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ex_trunkemergencycidoverride` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ex_cr_id` int(11) NOT NULL,
  `ex_trunkcidsource` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ex_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_fmfmholdmessage_id` int(11) NOT NULL,
  `ex_notifymissingemail` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ex_webuseldap` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `ex_webuser` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_txvolume` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_rxvolume` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_mu_id` int(11) DEFAULT '0',
  `ex_faxgateway` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_faxalert` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_trunkdid` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_fmfmdelay` int(11) NOT NULL DEFAULT '0',
  `ex_includeindbn` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  `ex_abusedetection` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_referenceid` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_notes` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ex_callwaiting` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_costlimits` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_dailycostlimit` decimal(10,5) DEFAULT '0.00000',
  `ex_dailycostlimitdom` decimal(10,5) NOT NULL DEFAULT '0.00000',
  `ex_dailycostlimitint` decimal(10,5) NOT NULL DEFAULT '0.00000',
  `ex_routecostlimit` decimal(10,5) DEFAULT '0.00000',
  `ex_dailycostwarning` decimal(10,5) DEFAULT '0.00000',
  `ex_dailycostwarningdom` decimal(10,5) NOT NULL DEFAULT '0.00000',
  `ex_dailycostwarningint` decimal(10,5) NOT NULL DEFAULT '0.00000',
  `ex_lastcostalert` datetime DEFAULT NULL,
  `ex_cl_id` int(11) NOT NULL DEFAULT '0',
  `ex_alertemail` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_includeinpb` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `ex_onconditionstatus` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_oncondition_id` int(11) NOT NULL DEFAULT '0',
  `ex_autoanswer` varchar(20) COLLATE utf8_unicode_ci DEFAULT '',
  `ex_autocidname` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_regexprefix` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_fromfilterregex` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_ignoreemptyemergcallerid` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_overridesippermit` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_webrtcsupport` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `ex_blockanonymous` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_dn_me_id` int(11) NOT NULL DEFAULT '0',
  `ex_spygroups` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_email` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_inboundblockcid` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_inboundblockcidname` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_applyalwaysrpid` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_mailbox` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_outboundtimeout` int(11) NOT NULL DEFAULT '0',
  `ex_smscidnum` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_useragentsecurity` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_useragentallowed` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_sms_rp_id` int(11) NOT NULL DEFAULT '0',
  `ex_callallowedreason` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_permit` varchar(500) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_permit_fqdn` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_calleridregexsamesms` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_ignoreinternalmissed` varchar(4) COLLATE utf8_unicode_ci DEFAULT '',
  `ex_webphone` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_prefixdefault` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_regexprefixdefault` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_alertwhenoffline` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_lastofflinealert` datetime DEFAULT NULL,
  `ex_emergencynotes` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_parkinglot` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_monthlycostlimit` decimal(10,5) DEFAULT '0.00000',
  `ex_monthlycostlimitdom` decimal(10,5) DEFAULT '0.00000',
  `ex_monthlycostlimitint` decimal(10,5) DEFAULT '0.00000',
  `ex_monthlycostwarning` decimal(10,5) DEFAULT '0.00000',
  `ex_monthlycostwarningdom` decimal(10,5) DEFAULT '0.00000',
  `ex_monthlycostwarningint` decimal(10,5) DEFAULT '0.00000',
  `ex_workinghours` int(11) NOT NULL DEFAULT '0',
  `ex_enableworkinghours` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ex_useextcallerid` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  UNIQUE KEY `ex_id` (`ex_id`),
  KEY `ex_tech_id` (`ex_tech_id`),
  KEY `ex_te_id` (`ex_te_id`,`ex_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ex_extensions`
--


--
-- Table structure for table `fa_faxes`
--

CREATE TABLE `fa_faxes` (
  `fa_id` int(11) NOT NULL AUTO_INCREMENT,
  `fa_te_id` int(11) NOT NULL,
  `fa_source_num` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fa_source_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fa_dest_num` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fa_remoteid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fa_direction` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `fa_file` longblob NOT NULL,
  `fa_date` datetime NOT NULL,
  `fa_pages` int(11) NOT NULL,
  `fa_status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fa_error` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fa_attempt` int(11) NOT NULL,
  `fa_rescheduled_as` int(11) NOT NULL,
  `fa_size` int(11) NOT NULL,
  `fa_statusemail` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fa_language` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `fa_sublanguage` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `fa_schedule` datetime NOT NULL,
  `fa_delete_after_send` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `fa_faxname` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`fa_id`),
  KEY `fa_status` (`fa_status`),
  KEY `fa_te_id` (`fa_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fa_faxes`
--


--
-- Table structure for table `fe_features`
--

CREATE TABLE `fe_features` (
  `fe_id` int(11) NOT NULL AUTO_INCREMENT,
  `fe_te_id` int(11) NOT NULL,
  `fe_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fe_comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`fe_id`),
  KEY `fe_te_id` (`fe_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fe_features`
--


--
-- Table structure for table `fl_flows`
--

CREATE TABLE `fl_flows` (
  `fl_id` int(11) NOT NULL AUTO_INCREMENT,
  `fl_te_id` int(11) NOT NULL,
  `fl_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fl_comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fl_number` varchar(40) COLLATE utf8_unicode_ci DEFAULT '',
  `fl_value` varchar(2048) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `fl_value_for_unavailable` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fl_value_for_inuse` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fl_value_for_notinuse` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fl_value_for_ringing` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fl_variable_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fl_monitor_type` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `fl_monitor_type_id` int(11) NOT NULL DEFAULT '0',
  `fl_monitor_parameter` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`fl_id`),
  KEY `fl_te_id` (`fl_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fl_flows`
--


--
-- Table structure for table `followme`
--

CREATE TABLE `followme` (
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `musiconhold` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `context` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `takecall` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `declinecall` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `call_from_prompt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `norecording_prompt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `options_prompt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pls_hold_prompt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status_prompt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sorry_prompt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `followme`
--


--
-- Table structure for table `followme_numbers`
--

CREATE TABLE `followme_numbers` (
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ordinal` int(11) NOT NULL,
  `phonenumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `timeout` int(11) NOT NULL,
  UNIQUE KEY `name` (`name`,`ordinal`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `followme_numbers`
--


--
-- Table structure for table `fs_fail2banstatus`
--

CREATE TABLE `fs_fail2banstatus` (
  `fs_no_id` int(11) NOT NULL,
  `fs_jail` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `fs_status` varchar(5000) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`fs_no_id`,`fs_jail`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fs_fail2banstatus`
--


--
-- Table structure for table `ft_faxattempts`
--

CREATE TABLE `ft_faxattempts` (
  `ft_id` int(11) NOT NULL AUTO_INCREMENT,
  `ft_te_id` int(11) NOT NULL,
  `ft_fa_id` int(11) unsigned NOT NULL,
  `ft_remoteid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ft_date` datetime NOT NULL,
  `ft_status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ft_dialstatus` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `ft_error` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ft_attempt` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `ft_ecm` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ft_rate` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ft_modem` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ft_id`),
  KEY `ft_te_id` (`ft_te_id`),
  KEY `ft_fa_id` (`ft_fa_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ft_faxattempts`
--


--
-- Table structure for table `ge_geoip`
--

CREATE TABLE `ge_geoip` (
  `ge_allowed` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  KEY `ge_allowed` (`ge_allowed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ge_geoip`
--


--
-- Table structure for table `gn_groupnames`
--

CREATE TABLE `gn_groupnames` (
  `gn_id` int(11) NOT NULL AUTO_INCREMENT,
  `gn_te_id` int(11) NOT NULL,
  `gn_number` int(11) NOT NULL,
  `gn_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`gn_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `gn_groupnames`
--


--
-- Table structure for table `gr_groupcounts`
--

CREATE TABLE `gr_groupcounts` (
  `gr_id` int(11) NOT NULL AUTO_INCREMENT,
  `gr_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `gr_server` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `gr_count` int(11) NOT NULL,
  PRIMARY KEY (`gr_id`),
  UNIQUE KEY `gr_name` (`gr_name`,`gr_server`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `gr_groupcounts`
--


--
-- Table structure for table `hu_huntlists`
--

CREATE TABLE `hu_huntlists` (
  `hu_id` int(11) NOT NULL AUTO_INCREMENT,
  `hu_number` varchar(40) COLLATE utf8_unicode_ci DEFAULT '',
  `hu_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `hu_te_id` int(11) NOT NULL,
  `hu_type` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `hu_ringtime` int(11) DEFAULT NULL,
  `hu_checkinuse` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hu_checkoffline` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hu_requestconfirm` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hu_confirmmessage_id` int(11) NOT NULL,
  `hu_usemoh` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hu_allowredirect` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hu_allowadditionaldestinations` varchar(10) COLLATE utf8_unicode_ci DEFAULT '',
  `hu_allowfmfm` varchar(10) COLLATE utf8_unicode_ci DEFAULT '',
  `hu_dialtimeout` int(11) NOT NULL DEFAULT '3600',
  `hu_fastdialing` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'on',
  `hu_usecustomdetails` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`hu_id`),
  KEY `hu_te_id` (`hu_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `hu_huntlists`
--


--
-- Table structure for table `iaxfriends`
--

CREATE TABLE `iaxfriends` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `te_id` int(11) NOT NULL,
  `name` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'friend',
  `username` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mailbox` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `secret` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dbsecret` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `context` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `regcontext` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `host` varchar(40) COLLATE utf8_unicode_ci DEFAULT 'dynamic',
  `ipaddr` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `port` int(5) DEFAULT NULL,
  `defaultip` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sourceaddress` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mask` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `regexten` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `regserver` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `regseconds` int(11) DEFAULT NULL,
  `accountcode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mohinterpret` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mohsuggest` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `inkeys` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `outkey` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `callerid` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cid_number` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sendani` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fullname` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `trunk` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `auth` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `maxauthreq` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `requirecalltoken` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `encryption` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `transfer` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `jitterbuffer` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `forcejitterbuffer` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `disallow` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `allow` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `codecpriority` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `qualify` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `qualifysmoothing` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `qualifyfreqok` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `qualifyfreqnotok` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `timezone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `adsi` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `amaflags` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `setvar` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `parkinglot` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`name`),
  UNIQUE KEY `id` (`id`),
  KEY `name` (`name`,`host`),
  KEY `name2` (`name`,`ipaddr`,`port`),
  KEY `ipaddr` (`ipaddr`,`port`),
  KEY `host` (`host`,`port`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `iaxfriends`
--


--
-- Table structure for table `ib_inboundrates`
--

CREATE TABLE `ib_inboundrates` (
  `ib_id` int(11) NOT NULL AUTO_INCREMENT,
  `ib_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ib_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ib_setup` decimal(10,5) NOT NULL,
  `ib_cost` decimal(10,5) NOT NULL,
  `ib_roundingtime` int(11) NOT NULL DEFAULT '1',
  `ib_minimumcost` decimal(10,5) NOT NULL DEFAULT '0.00000',
  `ib_roundingcost` int(11) NOT NULL DEFAULT '5',
  PRIMARY KEY (`ib_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ib_inboundrates`
--


--
-- Table structure for table `id_ipdatabase`
--

CREATE TABLE `id_ipdatabase` (
  `id_id` int(11) NOT NULL AUTO_INCREMENT,
  `id_startip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `id_endip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `id_startnum` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `id_endnum` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `id_countrycode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `id_country` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `id_type` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ipv4',
  PRIMARY KEY (`id_id`),
  KEY `id_startendnum` (`id_startnum`,`id_endnum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `id_ipdatabase`
--


--
-- Table structure for table `il_ivr_logs`
--

CREATE TABLE `il_ivr_logs` (
  `il_id` int(11) NOT NULL AUTO_INCREMENT,
  `il_te_id` int(11) NOT NULL,
  `il_iv_id` int(11) NOT NULL,
  `il_cdr_start` datetime NOT NULL,
  `il_cdr_uniqueid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `il_start` datetime NOT NULL,
  `il_end` datetime NOT NULL,
  `il_action` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `il_option` char(10) COLLATE utf8_unicode_ci NOT NULL,
  `il_disa` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `il_clid` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `il_firstdst` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`il_id`),
  KEY `il_te_id_start` (`il_te_id`,`il_cdr_start`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `il_ivr_logs`
--


--
-- Table structure for table `ir_internalroutings`
--

CREATE TABLE `ir_internalroutings` (
  `ir_id` int(11) NOT NULL AUTO_INCREMENT,
  `ir_te_id` int(11) NOT NULL,
  `ir_regexp` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ir_ex_id` int(11) NOT NULL,
  `ir_adddigits` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ir_deldigits` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ir_id`),
  KEY `ir_te_id` (`ir_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ir_internalroutings`
--


--
-- Table structure for table `iv_ivrs`
--

CREATE TABLE `iv_ivrs` (
  `iv_id` int(11) NOT NULL AUTO_INCREMENT,
  `iv_te_id` int(11) NOT NULL,
  `iv_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `iv_me_id` int(11) NOT NULL,
  `iv_timeout` int(11) NOT NULL,
  `iv_loopontimeout` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `iv_looponwrongkeypress` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `iv_allowdisa` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `iv_allowfeatures` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `iv_digittimeout` int(11) NOT NULL,
  `iv_allowcustom` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `iv_maxloops` int(11) NOT NULL DEFAULT '5',
  `iv_loopplaymessageonce` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `iv_allowanyextension` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`iv_id`),
  KEY `iv_te_id` (`iv_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `iv_ivrs`
--


--
-- Table structure for table `la_languages`
--

CREATE TABLE `la_languages` (
  `la_id` int(11) NOT NULL AUTO_INCREMENT,
  `la_directory` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `la_languagecode` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `la_sublanguagecode` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `la_locale` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `la_flag` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `la_language` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `la_enabled` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `la_tonezone` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `la_rtl` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`la_id`),
  KEY `la_directory` (`la_directory`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `la_languages`
--

INSERT INTO `la_languages` VALUES (1,'en_GB','en','GB','en','gb','English (UK)','on','uk',''),(2,'pt_BR','pt','BR','pt-br','br','Brazilian Portoguese','on','br',''),(3,'ee','ee','EE','ee','ee','Estonian','on','ee',''),(4,'it','it','IT','it','it','Italian','on','it',''),(5,'fr','fr','FR','fr','fr','French','on','fr',''),(6,'mn','mn','MN','mn','mn','Mongolian','on',NULL,''),(7,'pl','pl','PL','pl','pl','Polish','on','pl',''),(8,'ru','ru','RU','ru','ru','Russian','on','ru',''),(9,'es','es','ES','es','es','Spanish','on','es',''),(10,'tr','tr','TR','tr','tr','Turkish','on',NULL,''),(11,'en','en','US','en','us','English (US)','on','us',''),(12,'de','de','DE','de','de','German','on',NULL,''),(13,'hr','hr','HR','hr','hr','Croatian','on',NULL,''),(14,'sv','sv','SE','sv','sv','Swedish','on',NULL,''),(15,'he','he','IL','he','il','Hebrew','on','il','yes'),(16,'nl_BE','nl','BE','nl','be','Belgian (Dutch)','on','be',''),(17,'nl','nl','NL','nl','nl','Dutch','on','nl',''),(18,'en_AU','en','AU','en','au','English (AU)','on','au',''),(20,'de_AT','de','AT','de','at','Austria','','at',''),(21,'de_CH','de','CH','de','ch','Swiss (German)','','ch',''),(22,'lt','lt','LT','lt','lt','Lithuania','','lt',''),(23,'ja','ja','JA','ja','jp','Japanese','','ja',''),(24,'ar_EG','ar','EG','ar','ar','Arabic (EG)','','ar','yes'),(25,'ar_SA','ar','SA','ar','ar','Arabic (SA)','','ar','yes'),(26,'bg_BG','bg','BG','bg','bg','Bulgarian','','bg',''),(27,'ca_ES','ca','ES','ca','ca','Caralan (ES)','','ca',''),(28,'cs_CZ','cs','CZ','cs','cs','Czech (CZ)','','cs',''),(29,'da_DK','da','DK','dk','dk','Danish (DK)','','dk',''),(30,'el_GR','el','GR','el','el','Greek (GR)','','el',''),(31,'en_CA','en','CA','en','en','English (CA)','','us',''),(32,'en_IE','en','IE','en','en','English (IE)','','en',''),(33,'es_MX','es','MX','es','es','Spanish (MX)','','es',''),(34,'fi_FI','fi','FI','fi','fi','Finnish','','fi',''),(35,'fr_CA','fr','CA','fr','fr','French (CA)','','us',''),(36,'fr_CH','fr','CH','fr','fr','French (CH)','','fr',''),(37,'hi_IN','hi','IN','hi','hi','Hindi (IN)','','hi',''),(38,'hu_HU','hu','HU','hu','hu','Hungarian','','hu',''),(39,'id_ID','id','ID','id','id','Indonesian','','id',''),(40,'ja_JP','ja','JP','ja','ja','Japanese (JP)','','ja',''),(41,'ko_KR','ko','KR','kr','kr','Korean (KR)','','ko',''),(42,'ms_MY','ms','MY','ms','ms','Malay (MY)','','ms',''),(43,'nb_NO','nb','NO','nb','nb','Norwegian (Bokmål)','','nb',''),(44,'pt_PT','pt','PT','pt','pt','Portuguese','','pt',''),(45,'ro_RO','ro','RO','ro','ro','Romanian','','ro',''),(46,'sk_SK','sk','SK','sk','sk','Slovak','','sk',''),(47,'sl_SI','sl','SI','sl','sl','Slovenian (SI)','','sl',''),(48,'ta_IN','ta','IN','ta','ta','Tamil (IN)','','ta',''),(49,'te_IN','te','IN','te','te','Telugu (IN)','','te',''),(50,'th_TH','th','TH','th','th','Thai','','th',''),(51,'vi_VN','vi','VN','vi','vi','Vietnamese (VN)','','vi',''),(52,'zh_CN','zh','CN','zh','zh','Chinese (CN)','','zh',''),(53,'zh_HK','zh','HK','zh','zh','Chinese (HK)','','zh',''),(54,'zh_TW','zh','TW','zh','zh','Chinese (TW)','','zh',''),(55,'en_IN','enr','IN','en','en','English (IN)','','en',''),(56,'pt','pt','PT','pt','pt','Portuguese','','pt',''),(57,'af_ZA','af','ZA','af','af','Afrikaans (South Africa)','','',''),(58,'ar_XA','ar','XA','ar','ar','Arabic','','','yes'),(59,'bn_IN','bn','IN','bn','bn','Bengali (India)','','',''),(60,'cmn_CN','cmn','CN','cmn','cmn','Mandarin Chinese','','',''),(61,'cmn_TW','cmn','TW','cmn','cmn','Mandarin Chinese','','',''),(62,'en_IN','en','IN','en','en','English (India)','','',''),(63,'es_US','es','US','es','es','Spanis (US)','','',''),(64,'fil_PH','fil','PH','fil','fil','Filipino (Philippines)','','',''),(65,'gu_IN','gu','IN','gu','gu','Gujarati (India)','','',''),(66,'is_IS','is','IS','is','is','Icelandic (Iceland)','','',''),(67,'kn_IN','kn','IN','kn','kn','Kannada (India)','','',''),(68,'lv_LV','lv','LV','lv','lv','Latvian (Latvia)','','',''),(69,'ml_IN','ml','IN','ml','ml','Malayalam (India)','','',''),(70,'sr_RS','sr','RS','sr','sr','Serbian (Cyrillic)','','',''),(71,'uk_UA','uk','UA','uk','uk','Ukrainian (Ukraine)','','',''),(72,'yue_HK','yue','HK','yue','yue','Chinese (Hong Kong)','','','');

--
-- Table structure for table `ld_lastnumbersdialed`
--

CREATE TABLE `ld_lastnumbersdialed` (
  `ld_id` int(11) NOT NULL AUTO_INCREMENT,
  `ld_peername` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ld_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ld_number` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ld_id`),
  KEY `ld_peername` (`ld_peername`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ld_lastnumbersdialed`
--


--
-- Table structure for table `me_mediafiles`
--

CREATE TABLE `me_mediafiles` (
  `me_id` int(11) NOT NULL AUTO_INCREMENT,
  `me_te_id` int(11) NOT NULL,
  `me_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `me_format` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `me_size` int(11) NOT NULL,
  `me_md5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `me_data` longblob NOT NULL,
  `me_moh` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `me_description` varchar(2999) COLLATE utf8_unicode_ci NOT NULL,
  `me_type` varchar(10) COLLATE utf8_unicode_ci DEFAULT 'STATIC',
  `me_text` varchar(5000) COLLATE utf8_unicode_ci DEFAULT '',
  `me_engine` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `me_language` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `me_voiceapiusername` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `me_voiceapipassword` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `me_volume` decimal(10,5) DEFAULT '1.00000',
  `me_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `me_voiceapihost` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`me_id`),
  KEY `me_te_id` (`me_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `me_mediafiles`
--


--
-- Table structure for table `meetme`
--

CREATE TABLE `meetme` (
  `bookid` int(11) NOT NULL AUTO_INCREMENT,
  `confno` char(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `starttime` datetime DEFAULT '1900-01-01 12:00:00',
  `endtime` datetime DEFAULT '2038-01-01 12:00:00',
  `pin` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `adminpin` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `opts` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `adminopts` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recordingfilename` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recordingformat` char(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `maxusers` int(11) DEFAULT NULL,
  `members` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`bookid`),
  KEY `confno` (`confno`,`starttime`,`endtime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `meetme`
--


--
-- Table structure for table `mf_mailtofaxes`
--

CREATE TABLE `mf_mailtofaxes` (
  `mf_id` int(11) NOT NULL AUTO_INCREMENT,
  `mf_te_id` int(11) NOT NULL,
  `mf_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mf_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mf_protocol` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mf_host` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mf_port` int(11) NOT NULL,
  `mf_transport` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mf_username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mf_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mf_folder` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mf_cidnum` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mf_faxquality` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mf_authtype` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mf_authdata` text COLLATE utf8_unicode_ci NOT NULL,
  `mf_disabled` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `mf_language` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mf_cidname` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `mf_pagesize` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'auto',
  `mf_unauthenticated` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'DELETE',
  `mf_automaticrotate` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`mf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `mf_mailtofaxes`
--


--
-- Table structure for table `mm_messages`
--

CREATE TABLE `mm_messages` (
  `mm_id` int(11) NOT NULL AUTO_INCREMENT,
  `mm_te_id` int(11) NOT NULL,
  `mm_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `mm_message` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mm_read` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `mm_hosted` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `mm_severity` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`mm_id`),
  KEY `mm_te_id` (`mm_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `mm_messages`
--


--
-- Table structure for table `mm_mmsmedias`
--

CREATE TABLE `mm_mmsmedias` (
  `mm_id` int(11) NOT NULL AUTO_INCREMENT,
  `mm_te_id` int(11) NOT NULL,
  `mm_sm_id` int(11) NOT NULL DEFAULT '0',
  `mm_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `mm_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `mm_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `mm_expire` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `mm_data` longblob NOT NULL,
  PRIMARY KEY (`mm_id`),
  KEY `mm_te_id` (`mm_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `mm_mmsmedias`
--


--
-- Table structure for table `mu_managerusers`
--

CREATE TABLE `mu_managerusers` (
  `mu_id` int(11) NOT NULL AUTO_INCREMENT,
  `mu_te_id` int(11) NOT NULL,
  `mu_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mu_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mu_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`mu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `mu_managerusers`
--


--
-- Table structure for table `mu_musiconholds`
--

CREATE TABLE `mu_musiconholds` (
  `mu_id` int(11) NOT NULL AUTO_INCREMENT,
  `mu_te_id` int(11) NOT NULL,
  `mu_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mu_custom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mu_default` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `mu_volume` int(11) NOT NULL DEFAULT '1024',
  `mu_randomizeorder` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `mu_streamengine` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`mu_id`),
  KEY `mu_te_id` (`mu_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `mu_musiconholds`
--


--
-- Table structure for table `musiconhold`
--

CREATE TABLE `musiconhold` (
  `name` char(80) COLLATE utf8_unicode_ci NOT NULL,
  `mode` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `directory` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `application` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `digit` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sort` char(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `format` char(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `musiconhold`
--

INSERT INTO `musiconhold` VALUES ('default','files','/var/lib/asterisk/moh/',NULL,NULL,NULL,NULL,'2022-09-25 10:59:20'),('silence','files','/var/lib/asterisk/silencemoh',NULL,NULL,NULL,'wav','2022-09-25 10:59:22');

--
-- Table structure for table `no_nodes`
--

CREATE TABLE `no_nodes` (
  `no_id` int(11) NOT NULL AUTO_INCREMENT,
  `no_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `no_peername` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `no_ipaddress` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `no_manageruser` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_managerpassword` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_firewallhash` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `no_croncheck` datetime DEFAULT NULL,
  `no_geoipstatus` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `no_devstatecheck` datetime DEFAULT NULL,
  `no_devstate_ping` datetime DEFAULT NULL,
  `no_devstate_pong` datetime DEFAULT NULL,
  `no_f2biphash` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `no_devstateversion` int(11) NOT NULL DEFAULT '0',
  `no_dahdistatus` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `no_geoipdata` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `no_autorestart` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `no_lastautorestartdate` datetime DEFAULT NULL,
  `no_autorestartdelay` int(11) NOT NULL DEFAULT '5',
  `no_healthcheckcount` int(11) NOT NULL DEFAULT '0',
  `no_healthcheckstatus` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `no_healthcheckport` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '5060',
  `no_voipmonitor` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `no_voipmonitorstatus` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `no_mirtapbxversion` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `no_uuid` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `no_cores` int(11) DEFAULT NULL,
  `no_load` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_mem` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_swap` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_disk` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_housekeepingrun` datetime NOT NULL,
  `no_housekeepingend` datetime NOT NULL,
  PRIMARY KEY (`no_id`),
  KEY `no_peername` (`no_peername`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `no_nodes`
--


--
-- Table structure for table `od_outbounddids`
--

CREATE TABLE `od_outbounddids` (
  `od_id` int(11) NOT NULL AUTO_INCREMENT,
  `od_te_id` int(11) NOT NULL,
  `od_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `od_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `od_status` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `od_secret` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `od_emergency` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `od_sms` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  PRIMARY KEY (`od_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `od_outbounddids`
--


--
-- Table structure for table `pa_paginggroups`
--

CREATE TABLE `pa_paginggroups` (
  `pa_id` int(11) NOT NULL AUTO_INCREMENT,
  `pa_te_id` int(11) NOT NULL,
  `pa_number` varchar(40) COLLATE utf8_unicode_ci DEFAULT '',
  `pa_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pa_pin` int(11) DEFAULT NULL,
  `pa_bidirectional` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `pa_checkinuse` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pa_me_id` int(11) NOT NULL DEFAULT '0',
  `pa_manualheader` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`pa_id`),
  KEY `pa_te_id` (`pa_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pa_paginggroups`
--


--
-- Table structure for table `pb_phonebooks`
--

CREATE TABLE `pb_phonebooks` (
  `pb_id` int(11) NOT NULL AUTO_INCREMENT,
  `pb_te_id` int(11) NOT NULL,
  `pb_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pb_includeext` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  PRIMARY KEY (`pb_id`),
  KEY `pb_te_id` (`pb_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pb_phonebooks`
--


--
-- Table structure for table `pc_pincodes`
--

CREATE TABLE `pc_pincodes` (
  `pc_id` int(11) NOT NULL AUTO_INCREMENT,
  `pc_te_id` int(11) NOT NULL,
  `pc_pin` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `pc_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pc_disabled` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`pc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pc_pincodes`
--


--
-- Table structure for table `pc_providercosts`
--

CREATE TABLE `pc_providercosts` (
  `pc_id` int(11) NOT NULL AUTO_INCREMENT,
  `pc_pr_id` int(11) NOT NULL,
  `pc_prefix` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pc_country` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pc_network` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pc_cost` decimal(10,5) NOT NULL,
  `pc_code` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `pc_parent_id` int(11) NOT NULL DEFAULT '0',
  `pc_roundingtime` int(11) NOT NULL DEFAULT '1',
  `pc_minimumcost` decimal(10,5) NOT NULL DEFAULT '0.00000',
  `pc_roundingcost` int(11) NOT NULL DEFAULT '5',
  `pc_setup` decimal(10,5) NOT NULL DEFAULT '0.00000',
  PRIMARY KEY (`pc_id`),
  KEY `pc_pr_id` (`pc_pr_id`),
  KEY `pc_code_pr_id` (`pc_code`,`pc_pr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pc_providercosts`
--


--
-- Table structure for table `pc_proxyapi_cache`
--

CREATE TABLE `pc_proxyapi_cache` (
  `pc_id` bigint(11) NOT NULL AUTO_INCREMENT,
  `pc_command` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pc_servername` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `pc_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `pc_result` longblob NOT NULL,
  PRIMARY KEY (`pc_id`),
  UNIQUE KEY `pc_command` (`pc_command`,`pc_servername`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pc_proxyapi_cache`
--


--
-- Table structure for table `pd_phonebookdetails`
--

CREATE TABLE `pd_phonebookdetails` (
  `pd_id` int(11) NOT NULL AUTO_INCREMENT,
  `pd_te_id` int(11) NOT NULL,
  `pd_pe_id` int(11) NOT NULL,
  `pd_pi_id` int(11) NOT NULL,
  `pd_pi_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`pd_id`),
  KEY `pd_te_id` (`pd_te_id`,`pd_pi_value`),
  KEY `pd_te_id_pd_pe_id` (`pd_te_id`,`pd_pe_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pd_phonebookdetails`
--


--
-- Table structure for table `pe_phonebookentries`
--

CREATE TABLE `pe_phonebookentries` (
  `pe_id` int(11) NOT NULL AUTO_INCREMENT,
  `pe_te_id` int(11) NOT NULL,
  `pe_pb_id` int(11) NOT NULL,
  PRIMARY KEY (`pe_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pe_phonebookentries`
--


--
-- Table structure for table `pf_phonefeedbacks`
--

CREATE TABLE `pf_phonefeedbacks` (
  `pf_id` int(11) NOT NULL AUTO_INCREMENT,
  `pf_te_id` int(11) NOT NULL,
  `pf_ph_id` int(11) NOT NULL,
  `pf_datetime` datetime NOT NULL,
  `pf_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pf_pfb_id` int(11) NOT NULL,
  `pf_size` int(11) NOT NULL,
  PRIMARY KEY (`pf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pf_phonefeedbacks`
--


--
-- Table structure for table `pfb_phonefeedbacks_binary`
--

CREATE TABLE `pfb_phonefeedbacks_binary` (
  `pfb_id` int(11) NOT NULL AUTO_INCREMENT,
  `pfb_binary` longblob NOT NULL,
  `pfb_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`pfb_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pfb_phonefeedbacks_binary`
--


--
-- Table structure for table `pg_pickupgroups`
--

CREATE TABLE `pg_pickupgroups` (
  `pg_id` int(11) NOT NULL AUTO_INCREMENT,
  `pg_te_id` int(11) NOT NULL,
  `pg_ex_id` int(11) NOT NULL,
  `pg_value` int(11) NOT NULL,
  PRIMARY KEY (`pg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pg_pickupgroups`
--


--
-- Table structure for table `ph_phones`
--

CREATE TABLE `ph_phones` (
  `ph_id` int(11) NOT NULL AUTO_INCREMENT,
  `ph_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `ph_te_id` int(11) NOT NULL,
  `ph_pm_id` int(11) NOT NULL,
  `ph_mac` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ph_password` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ph_line0_ex_id` int(11) DEFAULT NULL,
  `ph_line1_ex_id` int(11) DEFAULT NULL,
  `ph_line2_ex_id` int(11) DEFAULT NULL,
  `ph_line3_ex_id` int(11) DEFAULT NULL,
  `ph_line4_ex_id` int(11) DEFAULT NULL,
  `ph_line5_ex_id` int(11) DEFAULT NULL,
  `ph_line6_ex_id` int(11) DEFAULT NULL,
  `ph_line7_ex_id` int(11) DEFAULT NULL,
  `ph_line8_ex_id` int(11) DEFAULT NULL,
  `ph_line9_ex_id` int(11) DEFAULT NULL,
  `ph_line10_ex_id` int(11) DEFAULT NULL,
  `ph_line11_ex_id` int(11) DEFAULT NULL,
  `ph_line12_ex_id` int(11) DEFAULT NULL,
  `ph_line13_ex_id` int(11) DEFAULT NULL,
  `ph_line14_ex_id` int(11) DEFAULT NULL,
  `ph_line15_ex_id` int(11) DEFAULT NULL,
  `ph_line16_ex_id` int(11) DEFAULT NULL,
  `ph_line17_ex_id` int(11) DEFAULT NULL,
  `ph_line18_ex_id` int(11) DEFAULT NULL,
  `ph_line19_ex_id` int(11) DEFAULT NULL,
  `ph_line20_ex_id` int(11) DEFAULT NULL,
  `ph_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ph_acceptdata` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ph_line21_ex_id` int(11) DEFAULT NULL,
  `ph_line22_ex_id` int(11) DEFAULT NULL,
  `ph_line23_ex_id` int(11) DEFAULT NULL,
  `ph_line24_ex_id` int(11) DEFAULT NULL,
  `ph_line25_ex_id` int(11) DEFAULT NULL,
  `ph_line26_ex_id` int(11) DEFAULT NULL,
  `ph_line27_ex_id` int(11) DEFAULT NULL,
  `ph_line28_ex_id` int(11) DEFAULT NULL,
  `ph_line29_ex_id` int(11) DEFAULT NULL,
  `ph_line30_ex_id` int(11) DEFAULT NULL,
  `ph_line31_ex_id` int(11) DEFAULT NULL,
  `ph_line32_ex_id` int(11) DEFAULT NULL,
  `ph_line33_ex_id` int(11) DEFAULT NULL,
  `ph_line34_ex_id` int(11) DEFAULT NULL,
  `ph_line35_ex_id` int(11) DEFAULT NULL,
  `ph_line36_ex_id` int(11) DEFAULT NULL,
  `ph_line37_ex_id` int(11) DEFAULT NULL,
  `ph_line38_ex_id` int(11) DEFAULT NULL,
  `ph_line39_ex_id` int(11) DEFAULT NULL,
  `ph_line40_ex_id` int(11) DEFAULT NULL,
  `ph_line41_ex_id` int(11) DEFAULT NULL,
  `ph_line42_ex_id` int(11) DEFAULT NULL,
  `ph_line43_ex_id` int(11) DEFAULT NULL,
  `ph_line44_ex_id` int(11) DEFAULT NULL,
  `ph_line45_ex_id` int(11) DEFAULT NULL,
  `ph_line46_ex_id` int(11) DEFAULT NULL,
  `ph_line47_ex_id` int(11) DEFAULT NULL,
  `ph_line48_ex_id` int(11) DEFAULT NULL,
  `ph_line49_ex_id` int(11) DEFAULT NULL,
  `ph_line50_ex_id` int(11) DEFAULT NULL,
  `ph_http_user` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ph_http_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ph_default` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  `ph_active` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  `ph_virtual` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ph_id`),
  KEY `passwordmac` (`ph_password`,`ph_mac`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ph_phones`
--


--
-- Table structure for table `pi_phonebookitems`
--

CREATE TABLE `pi_phonebookitems` (
  `pi_id` int(11) NOT NULL AUTO_INCREMENT,
  `pi_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pi_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`pi_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pi_phonebookitems`
--

INSERT INTO `pi_phonebookitems` VALUES (1,'NAME','Name'),(2,'PHONE1','Phone'),(3,'PHONE2','Mobile Phone'),(4,'EMAIL','Email'),(5,'ROUTING','Route to'),(6,'PHONE3','Additional Phone 1'),(7,'PHONE4','Additional Phone 2'),(8,'PHONE5','Additional Phone 3'),(9,'PHONE6','Additional Phone 4'),(10,'PHONE7','Additional Phone 5'),(11,'FIRSTNAME','First Name'),(12,'LASTNAME','Last Name'),(13,'COMPANY','Company'),(14,'SIPADDRESS','SIP Address'),(15,'XMPPADDRESS','XMPP Address'),(16,'ACCOUNTNUMBER','Account Number'),(17,'FAX','Fax'),(18,'LOOKUPVALUE','Lookup Value');

--
-- Table structure for table `pk_parkinglots`
--

CREATE TABLE `pk_parkinglots` (
  `pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `pk_te_id` int(11) NOT NULL,
  `pk_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pk_start` int(11) NOT NULL,
  `pk_end` int(11) NOT NULL,
  `pk_hosted` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pk_timeout` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pk_id`),
  KEY `pk_te_id` (`pk_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pk_parkinglots`
--


--
-- Table structure for table `pl_phonebooklayouts`
--

CREATE TABLE `pl_phonebooklayouts` (
  `pl_id` int(11) NOT NULL AUTO_INCREMENT,
  `pl_te_id` int(11) NOT NULL,
  `pl_pb_id` int(11) NOT NULL,
  `pl_pi_id` int(11) NOT NULL,
  `pl_order` int(11) NOT NULL,
  PRIMARY KEY (`pl_id`),
  KEY `pl_te_id` (`pl_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pl_phonebooklayouts`
--


--
-- Table structure for table `pl_phonebuttonlayouts`
--

CREATE TABLE `pl_phonebuttonlayouts` (
  `pl_id` int(11) NOT NULL AUTO_INCREMENT,
  `pl_te_id` int(11) NOT NULL,
  `pl_ph_id` int(11) NOT NULL,
  `pl_bl_id` int(11) NOT NULL,
  `pl_order` int(11) NOT NULL,
  PRIMARY KEY (`pl_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pl_phonebuttonlayouts`
--


--
-- Table structure for table `pl_provisioninglogs`
--

CREATE TABLE `pl_provisioninglogs` (
  `pl_id` int(11) NOT NULL AUTO_INCREMENT,
  `pl_te_id` int(11) NOT NULL,
  `pl_key` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `pl_mac` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `pl_datetime` datetime NOT NULL,
  `pl_file` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `pl_result` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `pl_ip` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `pl_useragent` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pl_https` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`pl_id`),
  KEY `pl_te_id` (`pl_te_id`),
  KEY `teidmac` (`pl_te_id`,`pl_mac`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pl_provisioninglogs`
--


--
-- Table structure for table `pm_phonemodels`
--

CREATE TABLE `pm_phonemodels` (
  `pm_id` int(11) NOT NULL AUTO_INCREMENT,
  `pm_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pm_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pm_mac` longblob NOT NULL,
  `pm_startline` int(11) NOT NULL,
  `pm_endline` int(11) NOT NULL,
  `pm_directory` longblob NOT NULL,
  `pm_locked` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `pm_lockpassword` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pm_remotepost` longblob NOT NULL,
  `pm_remoteposturl` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pm_remotepostuser` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pm_remotepostpassword` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pm_provisioningsuffix` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pm_remotepostcontenttype` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pm_qrcode` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pm_macrequestcontenttype` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pm_dirrequestcontenttype` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pm_showqrcodelink` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`pm_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pm_phonemodels`
--

INSERT INTO `pm_phonemodels` VALUES (1,'Cisco SPA504G','','<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\r\n<flat-profile>\r\n\r\n{line_loop}\r\n\r\n<!--########################################################-->\r\n<!--###           SIP Settings for Identity {$line_m1}   ###-->\r\n<!--########################################################-->\r\n\r\n<!--# The \"Line_Enable_{$line_m1}_\" field enables or disables Identity {$line_m1} on the phone. Valid values are \"Yes\"==Enable Identity; \"No\"==Disable Identity. The provisioning template sets the value to \"Yes\"==Enable Identity.-->\r\n<Line_Enable_{$line_m1}_ group=\"Ext_{$line_m1}/General\">Yes</Line_Enable_{$line_m1}_>\r\n\r\n<!--# The \"SIP_Port_{$line_m1}_\" field specifies which port number the phone should listen on for SIP Traffic. Valid values are 1 to 65535. The provisioning template sets the value to 5060 which is the standard SIP Port.-->\r\n<SIP_Port_{$line_m1}_ group=\"Ext_{$line_m1}/SIP_Settings\">{$local_port}</SIP_Port_{$line_m1}_>\r\n\r\n<!--# The Extension Number must be specified in the \"User_ID_{$line_m1}\" field. The \"extension_number\" variable will be replaced by the Extension\'s Extension Number.-->\r\n<User_ID_{$line_m1}_ group=\"Ext_{$line_m1}/Subscriber_Information\">{$username}</User_ID_{$line_m1}_>\r\n\r\n<!--# The \"Use_Auth_ID_{$line_m1}_\" field enables or disables the phone to use the Authentication ID to register itself with MiRTA PBX. Valid values are \"Yes\"==Register Using Authentication ID; \"No\"==Do Not Register Using Authentication ID. The provisioning template sets the value to \"Yes\"==Register Using Authentication ID.-->\r\n<Use_Auth_ID_{$line_m1}_ group=\"Ext_{$line_m1}/Subscriber_Information\">Yes</Use_Auth_ID_{$line_m1}_>\r\n\r\n<!--# The Authentication ID must be specified in the \"Auth_ID_{$line_m1}_\" field. The \"extension_auth_id\" variable will be replaced by the Extension\'s Authentication ID.-->\r\n<Auth_ID_{$line_m1}_ group=\"Ext_{$line_m1}/Subscriber_Information\">{$authname}</Auth_ID_{$line_m1}_>\r\n\r\n<!--# The Authentication Password must be specified in the \"Password_{$line_m1}_\" field. The \"extension_auth_pw\" variable will be replaced by the Extension\'s Authentication Password.-->\r\n<Password_{$line_m1}_ group=\"Ext_{$line_m1}/Subscriber_Information\">{$secret}</Password_{$line_m1}_>\r\n\r\n<!--# The \"Display_Name_{$line_m1}_\" field contains the Caller Name which the phone will send to MiRTA PBX. The \"extension_first_name\" and \"extension_last_name\" variables will be replaced by the Extension\'s First Name and Last Name.-->\r\n<Display_Name_{$line_m1}_ group=\"Ext_{$line_m1}/Subscriber_Information\">{$displayname}</Display_Name_{$line_m1}_>\r\n\r\n<!--# The \"Register_{$line_m1}_\" field specifies whether the phone should register with the SIP Registrar - in this case MiRTA PBX. Valid values are \"Yes\"==Register with SIP Registrar; \"No\"==Do Not Register With SIP Registrar. The provisioning template sets this value to \"Yes\"==Register with SIP Registrar to enable interaction with MiRTA PBX.-->\r\n<Register_{$line_m1}_ group=\"Ext_1/Proxy_and_Registration\">Yes</Register_{$line_m1}_>\r\n\r\n<!--# The \"Proxy_{$line_m1}_\" field contains the ip address and SIP port of the SIP Registrar and Proxy - in this case MiRTA PBX. The \"pbx_ip\" and \"param::sipport\" variables will be replaced by the IP Address and SIP Port of MiRTA PBX.-->\r\n<Proxy_{$line_m1}_ group=\"Ext_{$line_m1}/Proxy_and_Registration\">{$server_host|jjpbx.co.uk}:{$server_port|5060}</Proxy_{$line_m1}_>\r\n\r\n<!--# The \"Use_Outbound_Proxy_{$line_m1}_\" field specifies whether the phone should use an Outbound Proxy to deliver outgoing SIP messages. Valid values are \"Yes\"==Use Outbound Proxy; \"No\"==Do Not Use Outbound Proxy. The provisioning template sets the value to \"No\"==Do Not Use Outbound Proxy.-->\r\n<Use_Outbound_Proxy_{$line_m1}_ group=\"Ext_{$line_m1}/Proxy_and_Registration\">No</Use_Outbound_Proxy_{$line_m1}_>\r\n\r\n<!--# The \"DNS_SRV_Auto_Prefix_{$line_m1}_\" field specifies whether the phone should make DNS lookups for SRV records when attempting to contact the Proxy or the Outbound Proxy. Valid values are \"Yes\"==Make DNS Lookups For SRV Records; \"No\"==Do Not Make DNS Lookups for SRV Records. The provisioning template sets the value to \"No\"==Do Not Make DNS Lookups for SRV Records.-->\r\n<DNS_SRV_Auto_Prefix_{$line_m1}_ group=\"Ext_{$line_m1}/Proxy_and_Registration\">No</DNS_SRV_Auto_Prefix_{$line_m1}_>\r\n\r\n<!--# The \"Register_Expires_{$line_m1}_\" field specifies the length of time (in seconds) the phone will be registered with MiRTA PBX. The phone will attempt to re-register with MiRTA PBX before this time expires. The provisioning template sets the value to 900 (15 minutes). Valid values are any positive integer.-->\r\n<Register_Expires_{$line_m1}_ group=\"Ext_{$line_m1}/Proxy_and_Registration\">60</Register_Expires_{$line_m1}_>\r\n\r\n<!--# The \"Dial_Plan_{$line_m1}_\" field specifies which number combinations are allowed. Since MiRTA PBX takes all necessary routing decisions directly, the dialplan is set to \"[x*].\" to allow any sequence of keys to be dialed and sent to MiRTA PBX.-->\r\n<Dial_Plan_{$line_m1}_ group=\"Ext_{$line_m1}/Dial_Plan\">[x*].</Dial_Plan_{$line_m1}_>\r\n\r\n<Extension_{$line_m1}_ group=\"Phone/Line_Key_{$line_m1}Phone/Line_Key_{$line_m1}\">1</Extension_{$line_m1}_> \r\n<Short_Name_{$line_m1}_ group=\"Phone/Line_Key_{$line_m1}\">{$displayname}</Short_Name_{$line_m1}_> \r\n<Share_Call_Appearance_{$line_m1}_ group=\"Phone/Line_Key_{$line_m1}\">private</Share_Call_Appearance_{$line_m1}_> \r\n<Extended_Function_{$line_m1}_ group=\"Phone/Line_Key_{$line_m1}\"></Extended_Function_{$line_m1}_> \r\n{/line_loop}\r\n\r\n<Admin_Passwd group=\"System/System_Configuration\">{$adminpw|123456}</Admin_Passwd>\r\n<User_Password group=\"System/System_Configuration\">{$userpw|123456}</User_Password>\r\n\r\n</flat-profile>',1,4,'','','','','','','','','','','','',''),(2,'Panasonic KX-UT133','','# Panasonic SIP Phone Standard Format File #\r\n## SIP Settings\r\n{line_loop}\r\nDISPLAY_NAME_{$line_m1}=\"{$displayname}\"\r\nSIP_URI_{$line_m1}=\"sip:{$username}@{$server_host}\"\r\nSIP_AUTHID_{$line_m1}=\"{$authname}\"\r\nSIP_PASS_{$line_m1}=\"{$secret}\"\r\nSIP_PRXY_ADDR_{$line_m1}=\"{$server_host}\"\r\nSIP_PRXY_PORT_{$line_m1}=\"{$server_port}\"\r\nSIP_RGSTR_ADDR_{$line_m1}=\"{$server_host}\"\r\nSIP_RGSTR_PORT_{$line_m1}=\"{$server_port}\"\r\nSIP_OUTPROXY_ADDR_{$line_m1}=\"{$server_host}\"\r\nSIP_OUTPROXY_PORT_{$line_m1}=\"{$server_port}\"\r\nPHONE_NUMBER_{$line_m1}=\"\"\r\n{/line_loop}\r\n\r\n## HTTP Settings\r\nHTTPD_PORTOPEN_AUTO=\"Y\"\r\nHTTP_VER=\"1\"\r\nHTTP_USER_AGENT=\"Panasonic_{MODEL}/{fwver} ({mac})\"\r\nHTTP_SSL_VERIFY=\"0\"\r\nCFG_ROOT_CERTIFICATE_PATH=\"\"',1,4,'','','','','','','','','','','','',''),(3,'Grandstream GXP 140x','','<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n<gs_provision version=\"1\">\r\n<config version=\"1\"> \r\n <P271>{$line_active#1}</P271> \r\n <P270>{$displayname#1}</P270> \r\n <P298>1</P298>\r\n <P47>{$server_host#1}</P47>\r\n <P2312>{$backup_server_host#1}</P2312>\r\n <P35>{$username#1}</P35>\r\n <P36>{$authname#1}</P36>\r\n <P34>{$secret#1}</P34>\r\n <P3>{$displayname#2}</P3>\r\n <P401>{$line_active#2}</P401>\r\n <P417>{$displayname#2}</P417>\r\n <P402>{$server_host#2}</P402>\r\n <P2412>{$backup_server_host#2}</P2412>\r\n <P404>{$username#2}</P404>\r\n <P405>{$authname#2}</P405>\r\n <P406>{$secret#2}</P406> \r\n <P407>{$displayname#2}</P407>\r\n </config> \r\n</gs_provision>',1,2,'','','','','','','','','','','','',''),(4,'Yealink SIP-T2X','','{line_loop}\r\n[ account ]\r\npath= /config/voip/sipAccount{$line_m1}.cfg\r\nEnable = {$line_active}\r\nLabel = {$displayname}\r\nDisplayName = {$displayname}\r\nUserName = {$username}\r\nAuthName = {$authname}\r\npassword = {$secret}\r\nMissedCallLog = {$missed_call_log|0}\r\nAutoAnswer = {$auto_answer|0}\r\nSIPServerHost = {$server_host}\r\nSIPServerPort = {$server_port}\r\nSIPListenRandom = 0\r\nSIPListenPort = {$local_port}\r\nExpire = {$server_expires}\r\nUseOutboundProxy = {$enable_outbound_proxy_server}\r\nOutboundHost = {$outbound_host}\r\nOutboundPort = {$outbound_port}\r\nEnableEncrypt = 0\r\nEncryptKey = 29749\r\nEncryptVersion = 1\r\nBakOutboundHost = {$backup_outbound_host}\r\nBakOutboundPort = {$backup_outbound_port}\r\nEnableSTUN = {$enable_stun}\r\nproxy-require = 0\r\nptime = 20\r\nsrtp_encryption = 0\r\nsrtp_encryption_algorithm = 0\r\nBackupSIPServerHost = {$backup_server_host}\r\nBackupSIPServerPort = {$backup_server_port}\r\nEnable 100Rel = 0\r\nprecondition = 0\r\nSubsribeRegister = 0\r\nCIDSource = 0\r\nEnableSessionTimer = 0\r\nSessionExpires =\r\nSessionRefresher = 0\r\nEnableUserEqualPhone = 0\r\nBLFList_URI =\r\nSubsribeMWI = {$subscribe_mwi|1}\r\nAnonymousCall = 0\r\nRejectAnonymousCall = 0\r\nTransport = {$transport|0}\r\nShareLine =\r\ndialoginfo_callpickup =\r\nAnonymousCall_OnCode =\r\nAnonymousCall_OffCode =\r\nAnonymousReject_OnCode =\r\nAnonymousReject_OffCode =\r\nBLANumber =\r\nSIP Registration Retry Timer = {$sip_registration_retry_timer|30}\r\n\r\n[ Message ]\r\npath=/config/Features/Message.cfg\r\n#Set voicemail number for each account\r\nVoiceNumber{$line_m1} = {$voicemail_number}\r\n\r\n[ audio0 ]\r\npath=/config/voip/sipAccount{$line_m1}.cfg\r\nenable = 1\r\nPayloadType = PCMU\r\npriority = 1\r\nrtpmap = 0\r\n\r\n[ audio1 ]\r\npath=/config/voip/sipAccount{$line_m1}.cfg\r\nenable = 1\r\nPayloadType = PCMA\r\npriority = 2\r\nrtpmap = 8\r\n\r\n[ audio2 ]\r\npath=/config/voip/sipAccount{$line_m1}.cfg\r\nenable = 0\r\nPayloadType = G723_53\r\npriority = 0\r\nrtpmap = 4\r\n\r\n[ audio3 ]\r\npath=/config/voip/sipAccount{$line_m1}.cfg\r\nenable = 0\r\nPayloadType = G723_63\r\npriority = 0\r\nrtpmap = 4\r\n\r\n[ audio4 ]\r\npath=/config/voip/sipAccount{$line_m1}.cfg\r\nenable = 1\r\nPayloadType = G729\r\npriority = 3\r\nrtpmap = 18\r\n\r\n[ audio5 ]\r\npath=/config/voip/sipAccount{$line_m1}.cfg\r\nenable = 0\r\nPayloadType = G722\r\npriority = 0\r\nrtpmap = 9\r\n\r\n[ audio6 ]\r\npath=/config/voip/sipAccount{$line_m1}.cfg\r\nenable = 0\r\nPayloadType = iLBC\r\npriority = 3\r\nrtpmap = 97\r\n\r\n[ audio7 ]\r\npath=/config/voip/sipAccount{$line_m1}.cfg\r\nenable = 0\r\nPayloadType = G726-16\r\npriority = 0\r\nrtpmap = 112\r\n\r\n[ audio8 ]\r\npath=/config/voip/sipAccount{$line_m1}.cfg\r\nenable = 0\r\nPayloadType = G726-24\r\npriority = 0\r\nrtpmap = 102\r\n\r\n[ audio9 ]\r\npath=/config/voip/sipAccount{$line_m1}.cfg\r\nenable = 0\r\nPayloadType = G726-32\r\npriority = 0\r\nrtpmap = 2\r\n\r\n[ audio10 ]\r\npath=/config/voip/sipAccount{$line_m1}.cfg\r\nenable = 0\r\nPayloadType = G726-40\r\npriority = 0\r\nrtpmap = 104\r\n\r\n[ DTMF ]\r\npath=/config/voip/sipAccount{$line_m1}.cfg\r\nDTMFInbandTransfer = 1\r\nDTMFPayload = 101\r\nDTMFToneLen = 300\r\nInbandDtmfVolume = 0\r\nRxLatency = 20\r\nCPTToneCountry = 12\r\nG726CodeWord = 1\r\nInfoType = 0\r\n\r\n[ NAT ]\r\npath=/config/voip/sipAccount{$line_m1}.cfg\r\nMaxRTPPort = 11800\r\nMinRTPPort = 11780\r\nNATTraversal = {$nat_trans}\r\nSTUNServer = {$stun_server}\r\nSTUNPort = {$stun_server_port}\r\nEnableUDPUpdate = {$udp_keepalive_enable}\r\nUDPUpdateTime = {$udp_keepalive_seconds}\r\nrport = {$rport_enable}\r\n\r\n[ ADVANCED ]\r\npath=/config/voip/sipAccount{$line_m1}.cfg\r\ndefault_t1 = 0.5\r\ndefault_t2 = 4\r\ndefault_t4 = 5\r\n\r\n[blf]\r\npath=/config/voip/sipAccount{$line_m1}.cfg\r\nSubscribePeriod = 3600\r\n{/line_loop}\r\n\r\n[ VLAN ]\r\npath = /config/Network/Network.cfg\r\n#ISVLAN,VID and USRPRIORITY are used for VLAN on LAN port\r\n#PC_PORT_VLAN_ENABLE,PC_PORT_VID and PC_PORT_PRIORITY are used for PC port\r\nISVLAN = {$voice_vlan_enable}\r\nVID = {$voice_vlan_id}\r\nUSRPRIORITY = 0\r\nPC_PORT_VLAN_ENABLE = {$data_vlan_enable}\r\nPC_PORT_VID = {$data_vlan_id}\r\nPC_PORT_PRIORITY = 0\r\n\r\n[ ContactList ]\r\npath = /tmp/download.cfg\r\n#to specify a XML phonebook for update\r\n#an example for a right server_address:http://192.168.0.132:9/file_provision/contactData1.xml\r\nserver_address = {$contact_list_address}\r\n\r\n{loop_remotephonebook}\r\n[ RemotePhoneBook{$number} ]\r\npath = /config/Setting/Setting.cfg\r\nURL = {$url}\r\nName = {$name}\r\n{/loop_remotephonebook}\r\n\r\n[ ringtone ]\r\npath = /tmp/download.cfg\r\n#to specify a ringtone for update\r\n#the format of the ringtone must be WAV\r\n#an example for a right server_address:ftp://wxf:123456@192.168.0.132:21/Ring20.wav\r\nserver_address = {$ringtone_url}\r\n\r\n[Logo]\r\npath = /tmp/download.cfg\r\nserver_address = {$logo_url}\r\n\r\n[ Features ]\r\npath = /config/Features/Phone.cfg\r\nCall_Waiting = 1\r\nHotlinenumber =\r\nBusyToneDelay =\r\nLCD_Logo = {$lcdlogo}\r\nDND_Code = 480\r\nRefuse_Code = 480\r\nDND_On_Code = *181\r\nDND_Off_Code = *182\r\nButtonSoundOn = 1\r\n\r\n[ Webserver Type ]\r\npath = /config/Advanced/Advanced.cfg\r\nWebType =\r\n\r\n{loop_memkey}\r\n[ memory{$key} ]\r\npath = /config/vpPhone/vpPhone.ini\r\nLine = {$line}\r\ntype = {$parameter}\r\nValue = {$extension}\r\nCallpickup =\r\nDKtype = {$type}\r\nPickupValue = {$pickup_value}\r\n{/loop_memkey}\r\n\r\n#START Line Key Options\r\n{loop_linekey}\r\n[ memory{$number} ]\r\npath = /config/vpPhone/vpPhone.ini\r\ntype = {$mode}\r\nDKtype = {$type}\r\nLine = {$line}\r\nValue = {$extension}\r\n{/loop_linekey}\r\n#END Line Key Options\r\n\r\n#START DialNow configuration\r\n[ DialNow ]\r\npath = /tmp/dialnow.xml\r\n{loop_dialnow}\r\n{$count} = {$rule}\r\n{/loop_dialnow}\r\n#END DialNow configuration\r\n\r\n{loop_sdext38}\r\n[ Key{$number} ]\r\nPath = /config/vpPhone/Ext38_00000000000001.cfg\r\nDKtype = {$type}\r\nLine = 0\r\nValue = {$value}\r\ntype = {$btype}\r\nPickupValue = {$pickup_value}\r\nLabel = {$label}\r\n{/loop_sdext38}\r\n\r\n#START Soft Keys\r\n{loop_softkey}\r\n[ programablekey{$number} ]\r\npath = /config/vpPhone/vpPhone.ini\r\nLabel = {$label}\r\nDKtype = {$type}\r\nLine = 0\r\nValue = {$value}\r\nXMLPhoneBook = \r\n{/loop_softkey}\r\n#END Soft Keys\r\n\r\n#Program UP Key\r\n[ programablekey5 ]\r\npath = /config/vpPhone/vpPhone.ini\r\nDKtype = {$hardkey_up_type}\r\nLine = {$hardkey_up_line}\r\nValue = {$hardkey_up_extension}\r\nXMLPhoneBook =\r\n\r\n#Program DOWN Key\r\n[ programablekey6 ]\r\npath = /config/vpPhone/vpPhone.ini\r\nDKtype = {$hardkey_down_type}\r\nLine = {$hardkey_down_line}\r\nValue = {$hardkey_down_extension}\r\nXMLPhoneBook =\r\n\r\n#Program LEFT Key\r\n[ programablekey7 ]\r\npath = /config/vpPhone/vpPhone.ini\r\nDKtype = {$hardkey_left_type}\r\nLine = {$hardkey_left_line}\r\nValue = {$hardkey_left_extension}\r\nXMLPhoneBook =\r\n\r\n#Program RIGHT Key\r\n[ programablekey8 ]\r\npath = /config/vpPhone/vpPhone.ini\r\nDKtype = {$hardkey_right_type}\r\nLine = {$hardkey_right_line}\r\nValue = {$hardkey_right_value}\r\nXMLPhoneBook =\r\n\r\n#Program OK Key\r\n[ programablekey9 ]\r\npath = /config/vpPhone/vpPhone.ini\r\nDKtype = {$hardkey_ok_type}\r\nLine = {$hardkey_ok_line}\r\nValue = {$hardkey_ok_value}\r\nXMLPhoneBook =\r\n\r\n#Program CANCEL Key\r\n[ programablekey10 ]\r\npath = /config/vpPhone/vpPhone.ini\r\nDKtype = {$hardkey_cancel_type}\r\nLine = {$hardkey_cancel_line}\r\nValue = {$hardkey_cancel_value}\r\nXMLPhoneBook =\r\n\r\n#Program FWD Key\r\n[ programablekey14 ]\r\npath = /config/vpPhone/vpPhone.ini\r\nDKtype = {$hardkey_fwd_type}\r\nLine = {$hardkey_fwd_line}\r\nValue = {$hardkey_fwd_value}\r\nXMLPhoneBook =\r\n\r\n[ AdminPassword ]\r\npath = /config/Setting/autop.cfg\r\nPassword = {$adminpw}',0,5,'','','','','','','','','','','','','');

--
-- Table structure for table `pp_panelpositions`
--

CREATE TABLE `pp_panelpositions` (
  `pp_id` int(11) NOT NULL AUTO_INCREMENT,
  `pp_us_id` int(11) NOT NULL,
  `pp_te_id` int(11) NOT NULL,
  `pp_obj_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `pp_obj_id` int(11) NOT NULL,
  `pp_pos_x` int(11) NOT NULL,
  `pp_pos_y` int(11) NOT NULL,
  PRIMARY KEY (`pp_id`),
  UNIQUE KEY `pp_us_id` (`pp_us_id`,`pp_te_id`,`pp_obj_type`,`pp_obj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pp_panelpositions`
--


--
-- Table structure for table `pp_phonephonebooks`
--

CREATE TABLE `pp_phonephonebooks` (
  `pp_id` int(11) NOT NULL AUTO_INCREMENT,
  `pp_te_id` int(11) NOT NULL,
  `pp_ph_id` int(11) NOT NULL,
  `pp_pb_id` int(11) NOT NULL,
  `pp_order` int(11) NOT NULL,
  PRIMARY KEY (`pp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pp_phonephonebooks`
--


--
-- Table structure for table `pp_profileprivileges`
--

CREATE TABLE `pp_profileprivileges` (
  `pp_id` int(11) NOT NULL AUTO_INCREMENT,
  `pp_up_id` int(11) NOT NULL,
  `pp_ug_id` int(11) NOT NULL,
  `pp_param1` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pp_param2` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pp_param3` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pp_param4` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pp_param5` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`pp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pp_profileprivileges`
--

INSERT INTO `pp_profileprivileges` VALUES (1,1,1,'','','','',''),(2,2,2,'','','','',''),(3,3,3,'','','','',''),(4,4,4,'','','','',''),(5,5,33,'','','','',''),(6,1,120,'','','','',''),(7,2,120,'','','','',''),(8,3,120,'','','','',''),(9,4,120,'','','','',''),(10,5,120,'','','','','');

--
-- Table structure for table `pr_parkinglotsreturns`
--

CREATE TABLE `pr_parkinglotsreturns` (
  `pr_id` int(11) NOT NULL AUTO_INCREMENT,
  `pr_te_id` int(11) NOT NULL,
  `pr_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pr_dialback` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pr_comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`pr_id`),
  KEY `pr_te_id` (`pr_te_id`,`pr_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pr_parkinglotsreturns`
--


--
-- Table structure for table `pr_privacy`
--

CREATE TABLE `pr_privacy` (
  `pr_id` int(11) NOT NULL AUTO_INCREMENT,
  `pr_te_id` int(11) NOT NULL,
  `pr_callerid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pr_action` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pr_media` longblob NOT NULL,
  `pr_datetime` datetime NOT NULL,
  PRIMARY KEY (`pr_id`),
  UNIQUE KEY `pr_teid_callerid` (`pr_te_id`,`pr_callerid`),
  KEY `pr_te_id` (`pr_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pr_privacy`
--


--
-- Table structure for table `pr_providers`
--

CREATE TABLE `pr_providers` (
  `pr_id` int(11) NOT NULL AUTO_INCREMENT,
  `pr_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pr_peername` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_tech` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_penalty` bigint(20) NOT NULL DEFAULT '0',
  `pr_header1` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_header2` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_header3` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_disabled` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_ca_id` int(11) NOT NULL DEFAULT '0',
  `pr_tech_id` int(11) NOT NULL DEFAULT '0',
  `pr_userealtime` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_adddigits` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pr_deldigits` int(11) NOT NULL,
  `pr_callerpres` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pr_smsurl` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_smspost` text COLLATE utf8_unicode_ci,
  `pr_smsuser` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_smspassword` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_calleridregex` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_smsprotocol` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_smsprovider` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_header4` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_header5` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_header6` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_inboundadddigits` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_inbounddeldigits` int(11) NOT NULL DEFAULT '0',
  `pr_allowcustomext` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_httpcontenttype` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_smsaction` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_getnumberfrom` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_ignoresipcause` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_host` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_ignorebusy` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pr_maxoutchannels` int(11) NOT NULL DEFAULT '-1',
  `pr_did_ca_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pr_providers`
--

INSERT INTO `pr_providers` VALUES (-1,'','','',0,'','','','',0,0,'','',0,'auto_not_screened','',NULL,'','','','','','','','','',0,'','','','','','','',-1,0);

--
-- Table structure for table `ps_aors`
--

CREATE TABLE `ps_aors` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `contact` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `default_expiration` int(11) DEFAULT NULL,
  `mailboxes` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `max_contacts` int(11) DEFAULT NULL,
  `minimum_expiration` int(11) DEFAULT NULL,
  `remove_existing` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `qualify_frequency` int(11) DEFAULT NULL,
  `authenticate_qualify` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `maximum_expiration` int(11) DEFAULT NULL,
  `outbound_proxy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `support_path` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `qualify_timeout` float DEFAULT NULL,
  `voicemail_extension` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `ps_aors_id` (`id`),
  KEY `ps_aors_qualifyfreq_contact` (`qualify_frequency`,`contact`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_aors`
--


--
-- Table structure for table `ps_asterisk_publications`
--

CREATE TABLE `ps_asterisk_publications` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `devicestate_publish` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mailboxstate_publish` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `device_state` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `device_state_filter` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mailbox_state` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `mailbox_state_filter` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `ps_asterisk_publications_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_asterisk_publications`
--


--
-- Table structure for table `ps_auths`
--

CREATE TABLE `ps_auths` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `auth_type` enum('md5','userpass') COLLATE utf8_unicode_ci DEFAULT NULL,
  `nonce_lifetime` int(11) DEFAULT NULL,
  `md5_cred` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `realm` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `ps_auths_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_auths`
--


--
-- Table structure for table `ps_contacts`
--

CREATE TABLE `ps_contacts` (
  `id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `uri` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `expiration_time` bigint(20) DEFAULT NULL,
  `qualify_frequency` int(11) DEFAULT NULL,
  `outbound_proxy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `path` text COLLATE utf8_unicode_ci,
  `user_agent` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `qualify_timeout` float DEFAULT NULL,
  `reg_server` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `authenticate_qualify` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `via_addr` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `via_port` int(11) DEFAULT NULL,
  `call_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `endpoint` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `prune_on_boot` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `RoundtripUsec` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  UNIQUE KEY `ps_contacts_uq` (`id`,`reg_server`),
  KEY `ps_contacts_id` (`id`),
  KEY `ps_contacts_qualifyfreq_exp` (`qualify_frequency`,`expiration_time`),
  KEY `endpoint` (`endpoint`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_contacts`
--


--
-- Table structure for table `ps_domain_aliases`
--

CREATE TABLE `ps_domain_aliases` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `domain` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `ps_domain_aliases_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_domain_aliases`
--


--
-- Table structure for table `ps_endpoint_id_ips`
--

CREATE TABLE `ps_endpoint_id_ips` (
  `id` int(40) NOT NULL AUTO_INCREMENT,
  `endpoint` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `match` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'identify',
  UNIQUE KEY `id` (`id`),
  KEY `ps_endpoint_id_ips_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_endpoint_id_ips`
--


--
-- Table structure for table `ps_endpoints`
--

CREATE TABLE `ps_endpoints` (
  `tech_id` int(11) NOT NULL AUTO_INCREMENT,
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `te_id` int(11) NOT NULL,
  `transport` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `aors` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `auth` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `context` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `disallow` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `allow` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `direct_media` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `connected_line_method` enum('invite','reinvite','update') COLLATE utf8_unicode_ci DEFAULT NULL,
  `direct_media_method` enum('invite','reinvite','update') COLLATE utf8_unicode_ci DEFAULT NULL,
  `direct_media_glare_mitigation` enum('none','outgoing','incoming') COLLATE utf8_unicode_ci DEFAULT NULL,
  `disable_direct_media_on_nat` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `dtmf_mode` enum('rfc4733','inband','info','auto') COLLATE utf8_unicode_ci DEFAULT NULL,
  `external_media_address` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `force_rport` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `ice_support` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `identify_by` enum('username','auth_username','ip') COLLATE utf8_unicode_ci DEFAULT NULL,
  `mailboxes` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `moh_suggest` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `outbound_auth` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `outbound_proxy` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rewrite_contact` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `rtp_ipv6` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `rtp_symmetric` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `send_diversion` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `send_pai` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `send_rpid` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `timers_min_se` int(11) DEFAULT NULL,
  `timers` enum('forced','no','required','yes') COLLATE utf8_unicode_ci DEFAULT NULL,
  `timers_sess_expires` int(11) DEFAULT NULL,
  `callerid` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `callerid_privacy` enum('allowed_not_screened','allowed_passed_screened','allowed_failed_screened','allowed','prohib_not_screened','prohib_passed_screened','prohib_failed_screened','prohib','unavailable') COLLATE utf8_unicode_ci DEFAULT NULL,
  `callerid_tag` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `100rel` enum('no','required','yes') COLLATE utf8_unicode_ci DEFAULT NULL,
  `aggregate_mwi` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `trust_id_inbound` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `trust_id_outbound` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `use_ptime` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `use_avpf` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `media_encryption` enum('no','sdes','dtls') COLLATE utf8_unicode_ci DEFAULT NULL,
  `inband_progress` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `call_group` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pickup_group` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `named_call_group` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `named_pickup_group` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `device_state_busy_at` int(11) DEFAULT NULL,
  `fax_detect` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `t38_udptl` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `t38_udptl_ec` enum('none','fec','redundancy') COLLATE utf8_unicode_ci DEFAULT NULL,
  `t38_udptl_maxdatagram` int(11) DEFAULT NULL,
  `t38_udptl_nat` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `t38_udptl_ipv6` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `tone_zone` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `one_touch_recording` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `record_on_feature` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `record_off_feature` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rtp_engine` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `allow_transfer` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `allow_subscribe` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT 'yes',
  `sdp_owner` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sdp_session` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tos_audio` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tos_video` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sub_min_expiry` int(11) DEFAULT NULL,
  `from_domain` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `from_user` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mwi_from_user` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dtls_verify` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dtls_rekey` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dtls_cert_file` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dtls_private_key` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dtls_cipher` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dtls_ca_file` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dtls_ca_path` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dtls_setup` enum('active','passive','actpass') COLLATE utf8_unicode_ci DEFAULT NULL,
  `srtp_tag_32` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `media_address` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `redirect_method` enum('user','uri_core','uri_pjsip') COLLATE utf8_unicode_ci DEFAULT NULL,
  `set_var` text COLLATE utf8_unicode_ci,
  `message_context` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `force_avp` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `media_use_received_transport` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `accountcode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `media_encryption_optimistic` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_eq_phone` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `rpid_immediate` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `g726_non_standard` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `rtp_keepalive` int(11) DEFAULT NULL,
  `rtp_timeout` int(11) DEFAULT NULL,
  `rtp_timeout_hold` int(11) DEFAULT NULL,
  `bind_rtp_to_media_address` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `cos_audio` int(11) DEFAULT NULL,
  `cos_video` int(11) DEFAULT NULL,
  `deny` varchar(95) COLLATE utf8_unicode_ci DEFAULT NULL,
  `permit` varchar(95) COLLATE utf8_unicode_ci DEFAULT NULL,
  `acl` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact_deny` varchar(95) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact_permit` varchar(95) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact_acl` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `voicemail_extension` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mwi_subscribe_replaces_unsolicited` int(11) DEFAULT NULL,
  `subscribe_context` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax_detect_timeout` int(11) DEFAULT NULL,
  `contact_user` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `asymmetric_rtp_codec` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `preferred_codec_only` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `rtcp_mux` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `dtls_auto_generate_cert` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`tech_id`),
  UNIQUE KEY `id` (`id`),
  KEY `ps_endpoints_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_endpoints`
--


--
-- Table structure for table `ps_globals`
--

CREATE TABLE `ps_globals` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `max_forwards` int(11) DEFAULT NULL,
  `user_agent` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `default_outbound_endpoint` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `debug` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `endpoint_identifier_order` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `max_initial_qualify_time` int(11) DEFAULT NULL,
  `default_from_user` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `keep_alive_interval` int(11) DEFAULT NULL,
  `regcontext` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `unidentified_request_count` int(11) DEFAULT NULL,
  `unidentified_request_period` int(11) DEFAULT NULL,
  `unidentified_request_prune_interval` int(11) DEFAULT NULL,
  `default_realm` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `disable_multi_domain` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `default_voicemail_extension` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact_expiration_check_interval` int(11) DEFAULT NULL,
  `mwi_tps_queue_high` int(11) DEFAULT NULL,
  `mwi_tps_queue_low` int(11) DEFAULT NULL,
  `mwi_disable_initial_unsolicited` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `ignore_uri_user_options` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `ps_globals_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_globals`
--


--
-- Table structure for table `ps_inbound_publications`
--

CREATE TABLE `ps_inbound_publications` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `endpoint` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_asterisk-devicestate` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_asterisk-mwi` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `ps_inbound_publications_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_inbound_publications`
--


--
-- Table structure for table `ps_outbound_publishes`
--

CREATE TABLE `ps_outbound_publishes` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `expiration` int(11) DEFAULT NULL,
  `outbound_auth` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `outbound_proxy` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  `server_uri` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  `from_uri` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  `to_uri` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `max_auth_attempts` int(11) DEFAULT NULL,
  `transport` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `multi_user` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `@body` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `@context` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  `@exten` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `ps_outbound_publishes_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_outbound_publishes`
--


--
-- Table structure for table `ps_registrations`
--

CREATE TABLE `ps_registrations` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `auth_rejection_permanent` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `client_uri` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact_user` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `expiration` int(11) DEFAULT NULL,
  `max_retries` int(11) DEFAULT NULL,
  `outbound_auth` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `outbound_proxy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `retry_interval` int(11) DEFAULT NULL,
  `forbidden_retry_interval` int(11) DEFAULT NULL,
  `server_uri` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `transport` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `support_path` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `fatal_retry_interval` int(11) DEFAULT NULL,
  `line` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `endpoint` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `ps_registrations_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_registrations`
--


--
-- Table structure for table `ps_resource_list`
--

CREATE TABLE `ps_resource_list` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `list_item` varchar(2048) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `full_state` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `notification_batch_interval` int(11) DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `ps_resource_list_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_resource_list`
--


--
-- Table structure for table `ps_subscription_persistence`
--

CREATE TABLE `ps_subscription_persistence` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `packet` varchar(2048) COLLATE utf8_unicode_ci DEFAULT NULL,
  `src_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `src_port` int(11) DEFAULT NULL,
  `transport_key` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `local_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `local_port` int(11) DEFAULT NULL,
  `cseq` int(11) DEFAULT NULL,
  `tag` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `endpoint` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `expires` int(11) DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `ps_subscription_persistence_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_subscription_persistence`
--


--
-- Table structure for table `ps_systems`
--

CREATE TABLE `ps_systems` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `timer_t1` int(11) DEFAULT NULL,
  `timer_b` int(11) DEFAULT NULL,
  `compact_headers` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `threadpool_initial_size` int(11) DEFAULT NULL,
  `threadpool_auto_increment` int(11) DEFAULT NULL,
  `threadpool_idle_timeout` int(11) DEFAULT NULL,
  `threadpool_max_size` int(11) DEFAULT NULL,
  `disable_tcp_switch` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `ps_systems_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_systems`
--


--
-- Table structure for table `ps_transports`
--

CREATE TABLE `ps_transports` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `async_operations` int(11) DEFAULT NULL,
  `bind` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ca_list_file` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cert_file` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cipher` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `domain` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `external_media_address` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `external_signaling_address` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `external_signaling_port` int(11) DEFAULT NULL,
  `method` enum('default','unspecified','tlsv1','sslv2','sslv3','sslv23') COLLATE utf8_unicode_ci DEFAULT NULL,
  `local_net` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `priv_key_file` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `protocol` enum('udp','tcp','tls','ws','wss') COLLATE utf8_unicode_ci DEFAULT NULL,
  `require_client_cert` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `verify_client` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `verify_server` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `tos` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `allow_reload` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  `cos` int(11) DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `ps_transports_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_transports`
--


--
-- Table structure for table `qa_queueabandonednotified`
--

CREATE TABLE `qa_queueabandonednotified` (
  `qa_id` int(11) NOT NULL AUTO_INCREMENT,
  `qa_te_id` int(11) NOT NULL,
  `qa_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `qa_qu_id` int(11) NOT NULL,
  `qa_uniqueid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `qa_status` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`qa_id`),
  KEY `qa_uniqueid` (`qa_uniqueid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `qa_queueabandonednotified`
--


--
-- Table structure for table `qc_queuecallbacks`
--

CREATE TABLE `qc_queuecallbacks` (
  `qc_id` int(11) NOT NULL AUTO_INCREMENT,
  `qc_te_id` int(11) NOT NULL,
  `qc_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `qc_qu_id` int(11) NOT NULL,
  `qc_uniqueid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `qc_status` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `qc_times` int(11) NOT NULL DEFAULT '0',
  `qc_callsource` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  PRIMARY KEY (`qc_id`),
  KEY `qc_uniqueid` (`qc_uniqueid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `qc_queuecallbacks`
--


--
-- Table structure for table `ql_queue_log_consolidated`
--

CREATE TABLE `ql_queue_log_consolidated` (
  `ql_id` int(11) NOT NULL AUTO_INCREMENT,
  `ql_te_id` int(11) NOT NULL,
  `ql_date` datetime NOT NULL,
  `ql_qu_id` int(11) NOT NULL,
  `ql_callerid` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ql_calleridname` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ql_disposition` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `ql_whoangup` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `ql_pausereason` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ql_agent` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `ql_agentname` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ql_transferred` int(11) NOT NULL,
  `ql_holdtime` int(11) NOT NULL,
  `ql_calltime` int(11) NOT NULL,
  `ql_position` int(11) NOT NULL,
  `ql_callid` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ql_id`),
  UNIQUE KEY `ql_id` (`ql_id`),
  KEY `ql_te_id` (`ql_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ql_queue_log_consolidated`
--


--
-- Table structure for table `qr_queuerules`
--

CREATE TABLE `qr_queuerules` (
  `qr_id` int(11) NOT NULL AUTO_INCREMENT,
  `qr_te_id` int(11) NOT NULL,
  `qr_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `qr_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`qr_id`),
  KEY `qr_te_id` (`qr_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `qr_queuerules`
--


--
-- Table structure for table `qt_queuelog_transfers`
--

CREATE TABLE `qt_queuelog_transfers` (
  `qt_id` int(11) NOT NULL AUTO_INCREMENT,
  `qt_te_id` int(11) NOT NULL,
  `qt_callid` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `qt_queuename` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `qt_extension` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `qt_transfer` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `qt_transto` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `qt_generated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`qt_id`),
  KEY `qt_te_id` (`qt_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `qt_queuelog_transfers`
--


--
-- Table structure for table `qu_queues`
--

CREATE TABLE `qu_queues` (
  `qu_id` int(11) NOT NULL AUTO_INCREMENT,
  `qu_te_id` int(11) NOT NULL,
  `qu_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `qu_hosted` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `qu_alwaysrecord` varchar(16) COLLATE utf8_unicode_ci DEFAULT 'no',
  `qu_timeout` int(11) NOT NULL,
  `qu_parameters` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `qu_youarenext_me_id` int(11) NOT NULL,
  `qu_thereare_me_id` int(11) NOT NULL,
  `qu_callswaiting_me_id` int(11) NOT NULL,
  `qu_thankyou_me_id` int(11) NOT NULL,
  `qu_periodic_announce_me_id` int(11) NOT NULL,
  `qu_nobodyhome` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `qu_ringinuse` varchar(40) COLLATE utf8_unicode_ci DEFAULT '',
  `qu_calltimeout` int(11) NOT NULL DEFAULT '7200',
  `qu_agent_announce_me_id` int(11) NOT NULL,
  `qu_id_text` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `qu_number` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `qu_callbackabandoned` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `qu_callbackwhenfree` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `qu_callbackabandonedstart` datetime DEFAULT NULL,
  `qu_callbackcalleridnum` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `qu_callbackcalleridname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `qu_callbackmaxattempts` int(11) NOT NULL DEFAULT '1',
  `qu_nofreemember` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `qu_ivr_id` int(11) NOT NULL DEFAULT '0',
  `qu_agent_ag_id` int(11) NOT NULL DEFAULT '0',
  `qu_notifyabandoned` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `qu_notifyabandonedemail` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `qu_notifyabandonedstart` datetime DEFAULT NULL,
  `qu_holdtime_me_id` int(11) NOT NULL DEFAULT '0',
  `qu_callback` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `qu_agent_confirmmessage_me_id` int(11) NOT NULL DEFAULT '0',
  `qu_agentname` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'EXTENSION',
  `qu_allowoptimization` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `qu_spygroups` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `qu_api_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `qu_api_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `qu_api_username` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `qu_api_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `qu_usequeuerules` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `qu_minpenalty` int(11) DEFAULT NULL,
  `qu_maxpenalty` int(11) DEFAULT NULL,
  `qu_raisepenalty` int(11) DEFAULT NULL,
  `qu_callbackhours` int(11) NOT NULL DEFAULT '0',
  `qu_notifyabandonedurl` varchar(500) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `qu_onautopause` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `qu_emailrecording` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `qu_minemailrecording` int(11) NOT NULL DEFAULT '0',
  `qu_callbackdelay` int(11) NOT NULL DEFAULT '1',
  `qu_notifyabandonedsmsnumbers` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `qu_notifyabandonedsmstext` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `qu_notifyabandonedsmssender` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`qu_id`),
  KEY `qu_te_id` (`qu_te_id`),
  KEY `qu_notifyabandoned` (`qu_notifyabandoned`,`qu_hosted`),
  KEY `qu_callbackabandoned` (`qu_callbackabandoned`,`qu_hosted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `qu_queues`
--


--
-- Table structure for table `queue`
--

CREATE TABLE `queue` (
  `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `musiconhold` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `announce` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `context` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `timeout` int(11) DEFAULT NULL,
  `monitor_join` tinyint(1) DEFAULT NULL,
  `monitor_format` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `queue_youarenext` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `queue_thereare` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `queue_callswaiting` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `queue_holdtime` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `queue_minutes` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `queue_seconds` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `queue_lessthan` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `queue_thankyou` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `queue_reporthold` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `announce_frequency` int(11) DEFAULT NULL,
  `announce_round_seconds` int(11) DEFAULT NULL,
  `announce_holdtime` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `retry` int(11) DEFAULT NULL,
  `wrapuptime` int(11) DEFAULT NULL,
  `maxlen` int(11) DEFAULT NULL,
  `servicelevel` int(11) DEFAULT NULL,
  `strategy` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `joinempty` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `leavewhenempty` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `eventmemberstatus` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `eventwhencalled` tinyint(1) DEFAULT NULL,
  `reportholdtime` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `memberdelay` int(11) DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  `timeoutrestart` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `periodic_announce` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `periodic_announce_frequency` int(11) DEFAULT NULL,
  `ringinuse` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `setinterfacevar` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `announce_position` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `announce_position_limit` int(11) NOT NULL,
  `setqueueentryvar` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `setqueuevar` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `autofill` varchar(10) COLLATE utf8_unicode_ci DEFAULT 'no',
  `autopause` enum('yes','no','all') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `relative_periodic_announce` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `penaltymemberslimit` int(11) NOT NULL DEFAULT '0',
  `defaultrule` int(11) DEFAULT NULL,
  `autopausedelay` int(11) NOT NULL DEFAULT '0',
  `autopausebusy` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  `autopauseunavail` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `queue`
--


--
-- Table structure for table `queue_log`
--

CREATE TABLE `queue_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` datetime DEFAULT NULL,
  `callid` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `queuename` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `agent` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `data1` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `data2` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `data3` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `data4` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `data5` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bydate` (`time`),
  KEY `qname` (`queuename`,`time`),
  KEY `callid` (`callid`),
  KEY `qnameeventagent` (`queuename`,`event`,`agent`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `queue_log`
--

INSERT INTO `queue_log` VALUES (1,'2022-09-25 10:55:14','NONE','NONE','NONE','QUEUESTART','','','','','');

--
-- Table structure for table `queue_member`
--

CREATE TABLE `queue_member` (
  `uniqueid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `membername` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `queue_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `interface` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state_interface` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `penalty` int(11) DEFAULT NULL,
  `paused` int(11) DEFAULT NULL,
  `member_device` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `wrapuptime` int(11) DEFAULT NULL,
  PRIMARY KEY (`uniqueid`),
  UNIQUE KEY `queue_interface` (`queue_name`,`interface`),
  KEY `queue_member_device` (`queue_name`,`member_device`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `queue_member`
--


--
-- Table structure for table `queue_rules`
--

CREATE TABLE `queue_rules` (
  `rule_id` int(11) NOT NULL AUTO_INCREMENT,
  `rule_name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `min_penalty` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `max_penalty` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `raise_penalty` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`rule_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `queue_rules`
--


--
-- Table structure for table `ra_rates`
--

CREATE TABLE `ra_rates` (
  `ra_id` int(11) NOT NULL AUTO_INCREMENT,
  `ra_cl_id` int(11) NOT NULL,
  `ra_prefix` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ra_country` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ra_network` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ra_setup` decimal(10,5) NOT NULL,
  `ra_cost` decimal(10,5) NOT NULL,
  `ra_roundingtime` int(11) NOT NULL DEFAULT '1',
  `ra_minimumcost` decimal(10,5) NOT NULL,
  `ra_roundingcost` int(11) NOT NULL DEFAULT '5',
  PRIMARY KEY (`ra_id`),
  KEY `ra_cl_id` (`ra_cl_id`),
  KEY `ra_cl_id_2` (`ra_cl_id`,`ra_country`),
  KEY `ra_cl_id_3` (`ra_cl_id`,`ra_network`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ra_rates`
--


--
-- Table structure for table `rd_reportsdata`
--

CREATE TABLE `rd_reportsdata` (
  `rd_id` int(11) NOT NULL AUTO_INCREMENT,
  `rd_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rd_te_id` int(11) NOT NULL,
  `rd_re_id` int(11) NOT NULL,
  `rd_size` int(11) NOT NULL,
  `rd_datestart` datetime NOT NULL,
  `rd_dateend` datetime NOT NULL,
  `rd_expires` datetime NOT NULL,
  `rd_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rd_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `rd_format` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pdf',
  PRIMARY KEY (`rd_id`),
  KEY `rd_te_id` (`rd_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rd_reportsdata`
--


--
-- Table structure for table `rd_reportsdata_bin`
--

CREATE TABLE `rd_reportsdata_bin` (
  `rd_bin_id` int(11) NOT NULL,
  `rd_bin` longblob NOT NULL,
  PRIMARY KEY (`rd_bin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rd_reportsdata_bin`
--


--
-- Table structure for table `re_recordings`
--

CREATE TABLE `re_recordings` (
  `re_id` int(11) NOT NULL AUTO_INCREMENT,
  `re_te_id` int(11) NOT NULL,
  `re_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `re_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `re_format` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `re_uniqueid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `re_size` int(11) NOT NULL,
  `re_data` longblob NOT NULL,
  PRIMARY KEY (`re_id`),
  KEY `re_te_id` (`re_te_id`,`re_uniqueid`),
  KEY `re_te_id_2` (`re_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `re_recordings`
--


--
-- Table structure for table `re_regions`
--

CREATE TABLE `re_regions` (
  `re_id` int(11) NOT NULL AUTO_INCREMENT,
  `re_protocol` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `re_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `re_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`re_id`),
  KEY `re_protocol` (`re_protocol`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `re_regions`
--

INSERT INTO `re_regions` VALUES (1,'AWS3','us-east-1','US East (N. Virginia)'),(2,'AWS3','us-east-2','US East (Ohio)'),(3,'AWS3','us-west-1','US West (N. California)'),(4,'AWS3','us-west-2','US West (Oregon)'),(5,'AWS3','eu-west-1','EU (Ireland)'),(6,'AWS3','eu-west-2','EU (London)'),(7,'AWS3','eu-central-1','EU (Frankfurt)'),(8,'AWS3','ap-southeast-1','Asia Pacific (Singapore)'),(9,'AWS3','ap-northeast-1','Asia Pacific (Tokyo)'),(10,'AWS3','ap-southeast-2','Asia Pacific (Sydney)'),(11,'AWS3','ap-northeast-2','Asia Pacific (Seoul)'),(12,'AWS3','sa-east-1','South America (Sao Paulo)'),(13,'azure','centralus','Americas - Central US'),(14,'azure','eastus','Americas - East US'),(15,'azure','eastus2','Americas - East US 2'),(16,'azure','northcentralus','Americas - North Central US'),(17,'azure','southcentralus','Americas - South Central US'),(18,'azure','westcentralus','Americas - West Central US'),(19,'azure','westus','Americas - West US'),(20,'azure','westus2','Americas - West US 2'),(21,'azure','canadacentral','Americas - Canada Central'),(22,'azure','brazilsouth','Americas - Brazil South'),(23,'azure','eastasia','Asia Pacific - East Asia'),(24,'azure','southeastasia','Asia Pacific - Southeast Asia'),(25,'azure','australiaeast','Asia Pacific - Australia East'),(26,'azure','centralindia','Asia Pacific - Central India'),(27,'azure','japaneast','Asia Pacific - Japan East'),(28,'azure','japanwest','Asia Pacific - Japan West'),(29,'azure','koreacentral','Asia Pacific - Korea Central'),(30,'azure','northeurope','Europe - North Europe'),(31,'azure','westeurope','Europe - West Europe'),(32,'azure','francecentral','Europe - France Central'),(33,'azure','uksouth','Europe - UK South'),(34,'AWS3','af-south-1','Africa (Cape Town)'),(35,'AWS3','ap-east-1','Asia Pacific (Hong Kong)'),(36,'AWS3','ap-south-1','Asia Pacific (Mumbai)'),(37,'AWS3','ap-northeast-3','Asia Pacific (Osaka-Local)'),(38,'AWS3','ca-central-1','Canada (Central)'),(39,'AWS3','cn-north-1','China (Beijing)'),(40,'AWS3','cn-northwest-1','China (Ningxia)'),(41,'AWS3','eu-west-3','Europe (Paris)'),(42,'AWS3','eu-north-1','Europe (Stockholm)'),(43,'AWS3','me-south-1','Middle East (Bahrain)'),(44,'AWS3','us-gov-east-1','AWS GovCloud (US-East)'),(45,'AWS3','us-gov-west-1','AWS GovCloud (US)');

--
-- Table structure for table `re_reports`
--

CREATE TABLE `re_reports` (
  `re_id` int(11) NOT NULL AUTO_INCREMENT,
  `re_te_id` int(11) NOT NULL,
  `re_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `re_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `re_parameters` longblob NOT NULL,
  `re_holding` int(11) NOT NULL,
  `re_cr_id` int(11) NOT NULL DEFAULT '0',
  `re_et_id` int(11) NOT NULL DEFAULT '0',
  `re_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`re_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `re_reports`
--


--
-- Table structure for table `re_rtpanelextensions`
--

CREATE TABLE `re_rtpanelextensions` (
  `re_id` int(11) NOT NULL AUTO_INCREMENT,
  `re_te_id` int(11) NOT NULL,
  `re_rp_id` int(11) NOT NULL,
  `re_ex_id` int(11) NOT NULL,
  PRIMARY KEY (`re_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `re_rtpanelextensions`
--


--
-- Table structure for table `ri_rings`
--

CREATE TABLE `ri_rings` (
  `ri_id` int(11) NOT NULL AUTO_INCREMENT,
  `ri_code` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ri_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ri_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ri_rings`
--

INSERT INTO `ri_rings` VALUES (1,'Bellcore-dr1','<t>Bellcore-dr1</t>'),(2,'Bellcore-dr2','<t>Bellcore-dr2</t>'),(3,'Bellcore-dr3','<t>Bellcore-dr3</t>'),(4,'Bellcore-dr4','<t>Bellcore-dr4</t>'),(5,'Bellcore-dr5','<t>Bellcore-dr5</t>'),(6,'info=<Bellcore-dr1>','<t>Info Bellcore-dr1</t>'),(7,'info=<Bellcore-dr2>','<t>Info Bellcore-dr2</t>'),(8,'info=<Bellcore-dr3>','<t>Info Bellcore-dr3</t>'),(9,'info=<Bellcore-dr4>','<t>Info Bellcore-dr4</t>'),(10,'info=<Bellcore-dr5>','<t>Info Bellcore-dr5</t>');

--
-- Table structure for table `rm_realtimemodules`
--

CREATE TABLE `rm_realtimemodules` (
  `rm_id` int(11) NOT NULL AUTO_INCREMENT,
  `rm_code` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `rm_name` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `rm_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rm_icon` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`rm_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rm_realtimemodules`
--

INSERT INTO `rm_realtimemodules` VALUES (1,'EXTSTATUS','Extension Status','',''),(2,'QUEUESSTATUS','Queues Status','','');

--
-- Table structure for table `rmc_realtimemodulecontents`
--

CREATE TABLE `rmc_realtimemodulecontents` (
  `rmc_id` int(11) NOT NULL AUTO_INCREMENT,
  `rmc_te_id` int(11) NOT NULL,
  `rmc_rpm_id` int(11) NOT NULL,
  `rmc_type` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `rmc_type_id` int(11) NOT NULL,
  `rmc_order` int(11) NOT NULL,
  PRIMARY KEY (`rmc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rmc_realtimemodulecontents`
--


--
-- Table structure for table `rn_reservednumbers`
--

CREATE TABLE `rn_reservednumbers` (
  `rn_id` bigint(11) NOT NULL AUTO_INCREMENT,
  `rn_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rn_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`rn_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rn_reservednumbers`
--


--
-- Table structure for table `rp_realtimepanels`
--

CREATE TABLE `rp_realtimepanels` (
  `rp_id` int(11) NOT NULL AUTO_INCREMENT,
  `rp_te_id` int(11) NOT NULL,
  `rp_ex_id` int(11) NOT NULL DEFAULT '0',
  `rp_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rp_description` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `rp_icon` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rp_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rp_realtimepanels`
--


--
-- Table structure for table `rp_responsepaths`
--

CREATE TABLE `rp_responsepaths` (
  `rp_id` int(11) NOT NULL AUTO_INCREMENT,
  `rp_te_id` int(11) NOT NULL,
  `rp_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rp_holddays` int(11) NOT NULL DEFAULT '0',
  `rp_xmldata` longblob,
  PRIMARY KEY (`rp_id`),
  KEY `rp_te_id` (`rp_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rp_responsepaths`
--


--
-- Table structure for table `rp_routingprofiles`
--

CREATE TABLE `rp_routingprofiles` (
  `rp_id` int(11) NOT NULL AUTO_INCREMENT,
  `rp_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rp_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rp_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'VOICE',
  PRIMARY KEY (`rp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rp_routingprofiles`
--


--
-- Table structure for table `rpm_realtimepanelmodules`
--

CREATE TABLE `rpm_realtimepanelmodules` (
  `rpm_id` int(11) NOT NULL AUTO_INCREMENT,
  `rpm_te_id` int(11) NOT NULL,
  `rpm_rp_id` int(11) NOT NULL,
  `rpm_rm_id` int(11) NOT NULL,
  `rpm_name` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `rpm_icon` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `rpm_parameters` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`rpm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rpm_realtimepanelmodules`
--


--
-- Table structure for table `rr_calleridregex_rules`
--

CREATE TABLE `rr_calleridregex_rules` (
  `rr_id` int(11) NOT NULL AUTO_INCREMENT,
  `rr_te_id` int(11) NOT NULL,
  `rr_cr_id` int(11) NOT NULL,
  `rr_regex` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rr_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rr_comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rr_co_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rr_calleridregex_rules`
--


--
-- Table structure for table `rr_conferenceroomsrates`
--

CREATE TABLE `rr_conferenceroomsrates` (
  `rr_id` int(11) NOT NULL AUTO_INCREMENT,
  `rr_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rr_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rr_setup` decimal(10,5) NOT NULL,
  `rr_cost` decimal(10,5) NOT NULL,
  `rr_rounding` int(11) NOT NULL,
  PRIMARY KEY (`rr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rr_conferenceroomsrates`
--


--
-- Table structure for table `rr_responsepathresponses`
--

CREATE TABLE `rr_responsepathresponses` (
  `rr_id` int(11) NOT NULL AUTO_INCREMENT,
  `rr_te_id` int(11) NOT NULL,
  `rr_rp_id` int(11) NOT NULL,
  `rr_uniqueid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rr_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rr_type_id` int(11) NOT NULL,
  `rr_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rr_type_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rr_value_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`rr_id`),
  KEY `rr_rp_id` (`rr_rp_id`),
  KEY `rr_te_id` (`rr_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rr_responsepathresponses`
--


--
-- Table structure for table `rr_runningrecordings`
--

CREATE TABLE `rr_runningrecordings` (
  `rr_id` int(11) NOT NULL AUTO_INCREMENT,
  `rr_node` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rr_channel` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rr_uniqueid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rr_mixmonitorid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rr_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`rr_id`),
  KEY `rr_uniqueid` (`rr_uniqueid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rr_runningrecordings`
--


--
-- Table structure for table `rt_rtpanelpositions`
--

CREATE TABLE `rt_rtpanelpositions` (
  `rt_id` int(11) NOT NULL AUTO_INCREMENT,
  `rt_rp_id` int(11) NOT NULL,
  `rt_te_id` int(11) NOT NULL,
  `rt_obj_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `rt_obj_id` int(11) NOT NULL,
  `rt_pos_x` decimal(20,17) NOT NULL,
  `rt_pos_y` decimal(20,17) NOT NULL,
  `rt_size` int(11) NOT NULL DEFAULT '100',
  PRIMARY KEY (`rt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rt_rtpanelpositions`
--


--
-- Table structure for table `sb_statsboards`
--

CREATE TABLE `sb_statsboards` (
  `sb_id` int(11) NOT NULL AUTO_INCREMENT,
  `sb_te_id` int(11) NOT NULL,
  `sb_name` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `sb_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`sb_id`),
  KEY `sb_te_id` (`sb_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sb_statsboards`
--


--
-- Table structure for table `sc_statsboard_cache`
--

CREATE TABLE `sc_statsboard_cache` (
  `sc_id` int(11) NOT NULL AUTO_INCREMENT,
  `sc_te_id` int(11) NOT NULL,
  `sc_type` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `sc_date` date NOT NULL,
  `sc_value1` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `sc_value2` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `sc_value3` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `sc_value4` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `sc_value5` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `sc_value6` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`sc_id`),
  UNIQUE KEY `sc_te_id_sc_type_sc_date` (`sc_te_id`,`sc_type`,`sc_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sc_statsboard_cache`
--


--
-- Table structure for table `se_settings`
--

CREATE TABLE `se_settings` (
  `se_id` int(11) NOT NULL AUTO_INCREMENT,
  `se_te_id` int(11) NOT NULL,
  `se_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `se_value` varchar(5000) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`se_id`),
  UNIQUE KEY `se_te_id` (`se_te_id`,`se_code`)
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `se_settings`
--

INSERT INTO `se_settings` VALUES (1,0,'DBVERSION','1727'),(3,0,'DATABASERUNNINGON','betatelephony-1'),(14,-2,'F2BFINDTIME','600'),(27,-1,'CURRENCY',''),(28,-1,'INTERNATIONALPREFIX','011'),(29,-1,'TRUNKPREFIX','1'),(30,-1,'LANGUAGE',''),(31,-1,'INBOUNDCALLERIDMOD',''),(32,-1,'ALLOWEDOUTBOUNDDIGITS','0123456789*+#'),(33,-1,'FORCEFEATURECODES','on'),(34,-1,'LICENSEKEY','iaEHGKO6GqieGegPpKyN6xVU+eSfepJODB+FCJ5nYZ81uwSQZgxk9COBBwpBKep89rkD//p776Hkh391NH3+Am/mTHkRclfUGqAaopqLKrIO3bCOwqvNmTb01WWppmPZn/OTj+WylKLFm+VVD/TqUGsTG4ICOuN3sN0TLaCe8lsKJ4SrGM0178n2hF1WxE6+vnVmmMraQcrI5GmCRA8BVd7DIqqn2Q2nbBBfMiEERj7bj4+XkQgeaIPF8/0YnE1MNSgfam3yGlBHXCe8gGGxpxoqITtfyX7ZOoIcB9mcZeIfvB3dtAOruojblyphKzbSc/KKQZztGgpG0qd5e96CkQ==\n'),(35,-1,'APIKEY',''),(36,-1,'CALLPCAPDAYS','3'),(37,-1,'CALLHISTORYDAYS','365'),(38,-1,'PROVISIONINGHISTORYDAYS','5'),(39,-1,'ACTIVITYLOGHISTORYDAYS','365'),(40,-1,'RECORDINGHOLDINGDAYS','3650'),(41,-1,'VOICEMAILHOLDINGDAYS','3650'),(42,-1,'FAXHOLDINGDAYS','3650'),(43,-1,'PROCESSLOGHOLDINGDAYS','5'),(44,-1,'STORAGEBACKEND','DB'),(45,-1,'RECORDINGHOST',''),(46,-1,'RECORDINGUSER',''),(47,-1,'RECORDINGPASSWORD',''),(48,-1,'RECORDINGDIR',''),(49,-1,'RECORDINGFORMAT','wav'),(50,-1,'RECORDINGFROM',''),(51,-1,'RECORDINGFROMEMAIL',''),(52,-1,'VOICEENGINE','IBM Watson TTS'),(53,-1,'VOICEENGINEAPIUSER',''),(54,-1,'VOICEENGINEAPIPASSWORD',''),(55,-1,'SPEECHTOTEXTENGINE','AT&T Speech API'),(56,-1,'SPEECHTOTEXTENGINEAPIUSER',''),(57,-1,'SPEECHTOTEXTENGINEAPIPASSWORD',''),(58,-1,'FAXMINSPEED',''),(59,-1,'FAXMAXSPEED',''),(60,-1,'FAXECM',''),(61,-1,'FAXDELAY','1'),(62,-1,'FAXMAXATTEMPTS','10'),(63,-1,'FAXCODEC',''),(64,-1,'FAXPROTOCOL','f'),(65,-1,'ONLYFAXDIDS','no'),(66,-1,'FAXFROM',''),(67,-1,'FAXFROMEMAIL',''),(68,-1,'FAXWAIT','3'),(69,-1,'LDAPBASEDN',''),(70,-1,'LDAPACCOUNTSUFFIX',''),(71,-1,'LDAPACCOUNTPREFIX',''),(72,-1,'LDAPDOMAINCONTROLLERS',''),(73,-1,'LDAPUSESSL','yes'),(74,-1,'LDAPUSETLS','yes'),(75,-1,'LDAPUSERNAMETEST',''),(76,-1,'LDAPPASSWORDTEST',''),(77,-1,'CONFERENCEFROM',''),(78,-1,'CONFERENCEFROMEMAIL',''),(79,-1,'UNKNOWNDIDEMAIL',''),(80,-1,'UNKNOWNDIDMEID',''),(81,-1,'CNAMURL','https://api.opencnam.com/v2/phone/%%NUM%%'),(82,-1,'CNAMCACHERETENTION',''),(83,-1,'TTTENANT','Service Not Enabled'),(84,-1,'TTMAXLEN',''),(85,-1,'TTRECAPTCHAPRVKEY',''),(86,-1,'WEBCALLPANELHOST',''),(87,-1,'WEBCALLPANELSSL','yes'),(88,-1,'EXTSTATUS','on'),(89,-1,'DIDFORMAT','three'),(90,-1,'NATIONALDID','on'),(91,-1,'ADMINALLTENANTS','on'),(92,-1,'ADVANCEDFILTERS','on'),(93,-1,'USETRANSLATIONS','on'),(94,-1,'DAYOFWEEKSTART','0'),(95,-1,'CDRVIEW','EXPANDED'),(96,-1,'CDRDESTVIEW','dialedexpanded'),(97,-1,'LCRPREFIX','4'),(98,-1,'TENANTSELECTORFORMAT','nameonly'),(99,0,'DATABASEUPGRADE',''),(101,-1,'DEFAULTCRONJOBSERVER','0'),(102,-1,'QUEUEHISTORYDAYS','365'),(103,-1,'SHOWNATIPPORTDUP','on'),(104,-1,'UPLOADRECORDINGATCALLEND','yes'),(105,-1,'SHOWPLUSINDID','on'),(106,-1,'LOGPROVISIONS','on'),(107,-1,'REPLACEPLUS','on'),(108,-1,'CELHISTORYDAYS','365'),(109,-1,'KILLMOH','on'),(110,-1,'LETSENCRYPT','on'),(111,-1,'VIRTUALHOSTPATH','/etc/httpd/conf.d'),(112,-1,'VIRTUALHOSTTEMPLATE','<VirtualHost *:80>\nServerName @@SERVERNAME@@\nLogLevel warn\n\n<Files ~ \"\\.(cgi|shtml|phtml|php3?)$\">\n    SSLOptions +StdEnvVars\n</Files>\n<Directory \"/var/www/cgi-bin\">\n    SSLOptions +StdEnvVars\n</Directory>\n\n</VirtualHost> '),(113,-1,'DEFAULTFAXSERVER','0'),(114,-1,'PASSWORDREQUIREMENTS','Password needs to be at least 8 chars, 2 uppercase, 2 digits and 3 lowercase'),(115,-1,'PASSWORDPATTERN','(?=.*[A-Z].*[A-Z])(?=.*[0-9].*[0-9])(?=.*[a-z].*[a-z].*[a-z]).{8}'),(116,-1,'ADVCALLDAYS','3'),(117,-2,'F2BVOIPPORTS','5060,5061,5080,5081,5082'),(118,-2,'F2BWEBPORTS','80,443'),(119,-2,'F2BSSHPORTS','22'),(120,-1,'VOICEENGINEHOST','stream.watsonplatform.net');

--
