(1756,4,4,18,'Added a link to blacklist a callerid in Call History</dd><dd>Some fixes to use PJSIP outbound providers</dd><dd>Added a redial even internal numbers special destination</dd><dd>Fixed marking voicemail messages as read</dd><dd>Better handling of defaults in ps_endpoints and ps_aors tables</dd><dd>Added year field to cronjobs</dd><dd>Added proxyapi managedb option for destinations','2021-09-19 16:46:05',''),(1757,4,4,19,'Fixed batch uploading of recordings missing the year field','2021-09-27 21:55:55',''),(1758,4,4,20,'Definitive solution to cronjob year problem','2021-09-28 21:14:15',''),(1759,4,4,21,'Improved queue abandoned calls table to include clients calling multiple times and answered once</dd><dd>Added a wallboard element to show connected line and call time running</dd><dd>Added queue filter to queue stats','2021-10-03 22:55:52',''),(1760,4,4,22,'Allowed to define more types of destination for the DISA IVR','2021-10-04 22:04:30',''),(1761,4,4,23,'Fixed newly introduced wallboard item for virtual extensions</dd><dd>Added user profile menu entry for Response Path Logs</dd><dd>Fixed Post URL for voicemail event</dd><dd>Fixed setting SIP headers for SMS over SIP MESSAGE</dd><dd>Added custom parking lots to Configuration/Settings page','2021-10-11 00:02:51',''),(1762,4,4,24,'Added a parameter, nodename to CHANNELS proxyapi request to limit the request to just one node of the cluster','2021-10-12 18:44:15',''),(1763,4,4,25,'Fixed duplicating a tenant with regards to PJSIP extensions and custom parking lots</dd><dd>Fixed Admin Lists/Extensions additional fields</dd><dd>Added field dtls_auto_generate_cert</dd><dd>Added whisper and barge mode to spygroup</dd><dd>Added a callers waiting wallboard elements, showing callerids and wait time</dd><dd>Fixed spying on virtual extensions when there is only one PJSIP extension associated','2021-10-17 23:05:09',''),(1764,4,5,0,'<b>This version introduces a better prevention of HTML injection and XSS protection, so it is possible something will be broken by this</b></dd><dd>In the Send Fax page, added a check to allow adding only numbers from the phone book</dd><dd>Fixed external only recording, avoiding recording internal calls when \"record the other leg\" was active</dd><dd>Fixed login to a wrong queue number from feature code</dd><dd>Adjusted the queue callers with callerid and time to work also with queue using member names</dd><dd>Fixed a problem with the call costs alerts when a call failed the first provider and attempt with another provider</dd><dd>Completed and fixed the proxyapi managedb for DIDs</dd><dd>Added VM_TENANTID variable to voicemail processing','2021-10-25 16:55:07',''),(1765,4,5,1,'Lots of fixes due to the XSS and HTML injection protection','2021-10-26 08:51:46',''),(1766,4,5,2,'More fixes due to the change in the code for XSS and HTML injection protection','2021-10-26 19:19:44',''),(1767,4,5,3,'Almost all bugs introduced by the XSS and HTML injection fix has been fixed</dd><dd>Changed the queue abandoned calls page to Datatable to allow searches</dd><dd>Added a destination for when the fax is received successfull','2021-10-28 00:11:33',''),(1768,4,5,4,'Error 500 solved for many pages involving a different way to manage NULL values after the infamous security fix of XSS and HTML injection','2021-10-30 17:47:42',''),(1769,4,5,5,'Fixed script problem with croncheck</dd><dd>Fixed MMS sending with Bandwidth</dd><dd>Fixed Vm_TENANTID variable</dd><dd>Added a retry timeout to campaigns</dd><dd>Some other fixes due to the XSS fix','2021-10-31 19:35:32',''),(1770,4,5,6,'Fixed downloading and sending of faxes</dd><dd>Added more variables to set in the custom destination','2022-01-12 17:36:55',''),(1771,4,5,7,'Fixed creating PJSIP extensions with zero minimum expiration</dd><dd>Added a button for resetting the state of the extension in Status/Queue, useful to reset custom destination extensions','2021-11-02 09:09:30',''),(1772,4,5,8,'Added a setting to limit the [NUM] parameter number of digits. If less than the value set, it will be sent outside</dd><dd>Fixed generating conference usage report</dd><dd>Added activity logging for voicemail page','2021-11-04 21:43:01',''),(1773,4,5,9,'Added ability to add/edit queue callbacks from the web interface. The callerid can\'t be added due to avoid adding a queue log entry</dd><dd>Added option to switch position in voicemail escalation</dd><dd>Fixed extension trunk mode hidden mode</dd><dd>Fixed template encoding of HTML entities</dd><dd>Fixed provisioning empty values in radio buttons and others</dd><dd>Fixed condition recurring checkbox</dd><dd>Added ability to send more faxes at once, selecting more than one file. For each file, a distinct fax will be sent</dd><dd>Added a check to not send more than one fax at once at the same number.','2021-11-09 14:59:03',''),(1774,4,5,10,'Fixed state duration in wallboard \"extension general activity\" for virtual extensions, but you need to kill the devstate receiver</dd><dd>Fixed a problem with fax scheduling','2021-11-09 15:10:30',''),(1775,4,5,11,'Improved the auto selection of the language</dd><dd>Added the option to the language to auto select RTL and moved the theme RTL selection to a \"force RTL\"</dd><dd>Better handling or Wasabi additional regions</dd><dd>Fixed deleting custom files from admin provisioning page</dd><dd>Fixed display for Phone provisioning template</dd><dd>Fixed min num param length for feature code</dd><dd>Fixed user activity stats from showing call costs when that is not allowed for the user</dd><dd>Small adjustment to IBM watson endpoint for dynamic created media files</dd><dd>Fixed msg_id variable for voicemail templates</dd><dd>Extended the mail to fax to accept more than one pdf at time</dd><dd>Added three new custom destinations to add, remove and clean extensions to/from virtual extensions','2021-11-15 12:32:12',''),(1776,4,5,12,'Fixed changing tenant with \"admin can see all tenants\" activated','2021-11-15 12:39:48',''),(1777,4,5,13,'Added custom destination to set option to play a message at certain intervals</dd><dd>Fixed using a user level profile','2021-11-17 15:48:59',''),(1778,4,5,14,'Fixed transport and rtp encryption default values fro PJSIP extensions</dd><dd>Added URI logging in User Activity</dd><dd>Fixed adding an agent to a queue number using a special destination and the wrong queue number</dd><dd>Fixed a problem with pdftk version 2 and mail to fax</dd><dd>Fixed DIDs statistics links when using a translation','2021-11-22 22:38:50',''),(1779,4,5,15,'Added huntlist as possible destination for IVR</dd><dd>Keeping the DB connection open during housekeeping</dd><dd>Fixing template for extension offline</dd><dd>Fixed PJSIP cleaning during housekeeping</dd><dd>Fixed editing CNAM with less privileged user</dd><dd>Fixed sending test email','2021-11-28 21:57:11',''),(1780,4,5,16,'Added a Tenant Group feature to assign tenants more easily to a group of users, accessible from Admin/Users','2021-12-08 08:55:49',''),(1781,4,5,17,'Fixed an incompatible database upgrade for older MySQL','2021-12-08 09:09:18',''),(1782,4,5,18,'<b>Warning, this version includes a change in the fax table, so it will take a long time to apply if you use fax extensively</b></dd><dd>Added saving the name of the original fax file</dd><dd>Added the variable for the fax name in temaplates</dd><dd>Fixed disposition in Simple Call History for calls dialed by queue callback</dd><dd>Added a condition to check if a channel is running</dd><dd>Added a custom destination to hangup a channel','2021-12-15 11:00:42',''),(1783,4,5,19,'Improved the \"route the call to the extension who has called the number\" by checking the real number dialed</dd><dd>Fixed saving hours and minutes on reports</dd><dd>Reverted fix breaking devstate updates','2021-12-15 11:07:26',''),(1784,4,5,20,'Fixed a tenant selection problem in tenant  user groups</dd><dd>Added proxyapi calls for manipulating user groups</dd><dd>Added an option to route the call back to the extension who called a number to filter by source callerid</dd><dd>Added a provider outbound channels limit, so you can limit the number of outbound channels used with a provider</dd><dd>Added an option to delay the attempts for queue callback</dd><dd>Added callerid name to queue abandoned report</dd><dd>Definitively fixing reports showing empty hours/minutes','2021-12-22 09:10:54',''),(1785,4,5,21,'Added option to use Outbound DIDs as SMS callerid</dd><dd>Fixed saving a provider without setting the amount of outbound channels</dd><dd>Fixed a problem with upload of recording that can lead to the loss of some of them','2021-12-23 19:18:11',''),(1786,4,5,22,'Added a smart title in Admin/Theme and activated for few configuration pages</dd><dd>Fixed wrong display of hours/minute in report scheduling</dd><dd>You can now use the emergencynote in the dialplan, like in a header to be sent to the provider</dd><dd>Fixed not-latin character in fax file name sent by mail to fax','2021-12-27 00:10:22',''),(1787,4,6,0,'Added a order field for the agents login custom destination, so you can place the agent in the correct position for linear queues</dd><dd>Showing callerid info when playing the message in voicemail browse custom destination, plus added a callback option</dd><dd>Fixed queue callbacks when the callerid is the INCOMINGDID</dd><dd>Fixed a problem with the queuemetrics sync, when recovering the latest ID transmitted</dd><dd>Added an incoming DID modification rule, so you can tweak the incoming DID</dd><dd>Extension web user password are now encrypted with SHA256 and hidden in the web interface</dd><dd>Improved abandoned calls queue page to allow from/to date</dd><dd>Added user password expiration','2022-01-03 08:43:01',''),(1788,4,6,1,'Fixed virtual and custom extension web password edit/display','2022-01-05 14:11:58',''),(1789,4,6,2,'Fixed display of user password</dd><dd>Added an icon in Call History for fax sent and received','2022-01-08 12:38:28',''),(1790,4,6,3,'Inbound DID mods are now applied also to custom extensions','2022-01-09 23:25:29',''),(1791,4,6,4,'Fixed reporting call campaign calls twice in simple call history</dd><dd>Fixed automatic filters on cdrs and other pages</dd><dd>Added option to change the format of the fax name being sent by email','2022-01-10 23:34:01',''),(1792,4,6,5,'Added the visualization of all pickup and call groups for extensions in the grid view for extensions</dd><dd>Fixed a bug preventing custom extension to use correctly the callerid','2022-01-12 23:40:26',''),(1793,4,6,6,'Fixed translation page</dd><dd>Fixed the extension level password encryption update</dd><dd>Fixed agent format for custom and special destination login action','2022-01-13 17:17:49',''),(1794,4,7,0,'Added queue penalty variables to pbx intercommuncation, all nodes must be on the same version</dd><dd>Fixed password authentication in Switchboard','2022-01-18 16:22:10',''),(1795,4,7,1,'Fixed qualify frequency conversion from chan_sip to pjsip</dd><dd>Fixed jqgrid display of extensions</dd><dd>Added an option in Admin/Tenant to force the usage of pin codes on on-net calls</dd><dd>Fixed realsrc reporting on some blind transfered calls involving RDNIS</dd><dd>Added SIP headers to PJSIP provider','2022-01-22 18:48:16',''),(1796,4,7,2,'Fixed network filter in User Stats</dd><dd>Added a tenant channels usage stats</dd><dd>Added monthly limit for extensions</dd><dd>Fixed realtime Text to Speech with Google TTS</dd><dd>Fixed setting voicemail values overwriting the new item defaults settings</dd><dd>Added a direct link for detected loop call messages','2022-01-31 17:01:10',''),(1797,4,7,3,'Fixed converting encryption parameter between chan_sip and PJSIP</dd><dd>Fixed provisioning regex for Panasonic phones</dd><dd>Logging user activity for media files</dd><dd>Added more columns to general display of Tenants</dd><dd>Fixed usage of html entities in provision mac template</dd><dd>Added a Following to FMFM only for agents','2022-02-13 23:09:48',''),(1798,4,7,4,'Fixed allowed user profiles for users</dd><dd>Fixed a case when a fax abandoned was not notified</dd><dd>Improving showing of phone lines on autoprovision editing</dd><dd>Fixed faxname in email templates</dd><dd>Added few AWS endpoint for voice services','2022-02-21 00:25:07',''),(1799,4,7,5,'Fixed misalignment in phones page</dd><dd>Fixed searching agent in queue page for MariaDB 5.5 and older db','2022-02-21 21:30:02',''),(1800,4,7,6,'Fixed downloading of recording using SSL-FTP with proxyapi</dd><dd>Disabled channel tracking for device state update for chan_sip, leaving active only for PJSIP','2022-02-23 19:28:42',''),(1801,4,7,7,'Improved queueabandoned call page to show if an inbound call has been answered</dd><dd>Prelimitary support to virtual extension provisioning, but not yet working</dd><dd>Added extension names to phone provisioning page, peer status, queue status</dd><dd>Fixed media file creationg by dialing a number javascript problem</dd><dd>Fixed queue callback allowing to call the first and only call requesting to be called back</dd><dd>Fixed recording setting for queue callback calls</dd><dd>Fixed a bug when using split call cost limit, always checking both limits, preventing local calls when international call limit is over</dd><dd>More work on the provisioning template for virtual extensions','2022-03-07 07:41:17',''),(1802,4,7,8,'Fixed a problem on some system with empty timezone for system cronjobs</dd><dd>Fixed double call when using FMFM simultaneous with confirm','2022-03-14 08:39:43',''),(1803,4,7,9,'Multiple deleting AWS S3 recordings instead of one by one</dd><dd>Fixed complete call history from showing only 1 week of data even if the easy filters are not selected</dd><dd>Fixed wrongly displaying of admin menu when the user can just change SIP tech</dd><dd>Fixed custom configuration for provisioned phones</dd><dd>Fixed multiple state condition check</dd><dd>Now you can receive SMS messages from Whatsapp</dd><dd>Fixed choosing virtual extension agents with FMFM in queue</dd><dd>Fixed duplicating tenant, AORs were not copied correctly</dd><dd>Changed the way the deny/permit networks are saved for SIP filters</dd><dd>Added variable expansion to setvar','2022-03-22 21:38:01',''),(1804,4,7,10,'Finally found, thanks to a very talented and dedicated client, and fixed a very elusive bug involving PJSIP and multiple channels hold by a phone, during an attended transfer. Once upgraded, you need to kill the devstatereceiver.php to make it restart on the new version','2022-03-25 00:05:40',''),(1805,4,7,11,'Added the number of agents in a queue in main queues page</dd><dd>Allow to resend multiple faxes at once</dd><dd>Added support for remove_existing in ps_aors</dd><dd>Added housekeeping for system messages</dd><dd>Fixed duplicating a phone, now the button layout and phone books are copied too</dd><dd>Fixed bug in reporting a queue call being end instead of answered when the queue was on the other server</dd><dd>Using DISA, it will accept # as number termination</dd><dd>The wallboard configuration has got a little pimp up, for now only the Extension: General Activity can be further customized, but now I am open to more customization of components','2022-04-03 22:20:39',''),(1806,4,7,12,'Added a notification for abandoned queue calls using SMS</dd><dd>Fixed display of notification for abandoned calls','2022-04-04 23:29:49',''),(1807,4,7,13,'Fixed a bug preventing a not privileges user to edit recording minimum size</dd><dd>Added a tenant option in Configuration/Settings to always delete faxes once sent</dd><dd>Fixed the privilege \"canEditCostLimits\"</dd><dd>Fixed sending emails while adding/updating an extension','2022-04-06 23:47:25',''),(1808,4,7,14,'Fixed a bug not showing the additional button when configuring the wallboard items supporting it</dd><dd>Fixed a problem when deleting the last extension allowed for the tenant</dd><dd>Fixed importing CSV for extensions</dd><dd>Added a max of 5 attempts to enter a correct pin for a conference</dd><dd>Added a custom timeout for custom parking lots</dd><dd>Fixed a bug preventing usage of custom parking lots</dd><dd>Fixed showing/hiding the http user/password block in provisioning when hidden from New Item Defaults</dd><dd>Added password policy for extension passwords</dd><dd>Fixed empty queues from displaying in queues page','2022-04-15 09:30:35',''),(1809,4,7,15,'Small javascript fix to wallboard, restoring secondary color selection','2022-04-18 23:18:16',''),(1810,4,7,16,'Fixed a problem with the extension password regex','2022-04-18 23:38:12',''),(1811,4,7,17,'Fixed node affinity enforce thanks to hard work from Phil</dd><dd>Fixed phone display of secret, user and password based on new item defaults','2022-04-22 16:49:11',''),(1812,4,7,18,'Fixed notifying abandoned calls using SMS when no notify email is set</dd><dd>Fixed newly created PJSIP extension using WebRTC to correctly work</dd><dd>Fixed using FMFM for Custom extension agents</dd><dd>Restored the bottom message in the template</dd><dd>Fixed dialing the parking lot number using the special destination \"park the call in the num\" when using a custom parking lot','2022-05-09 17:44:56',''),(1813,4,7,19,'Automatically generating an API KEY when the tenant is created</dd><dd>Added a new Agent Stat report</dd><dd>Fixed the rest of dtls auto generate certificate on extension save</dd><dd>Fixed button layout templates HTML entities</dd><dd>Added timeout option to authenticate condition</dd><dd>Added an option to skip requesting PIN when using a short code','2022-05-20 23:59:39',''),(1814,4,8,0,'Very big cahnge to the condition system to allow multiple destinations for the same condition type. We have now a \"multiple weektime\" condition. ','2022-05-23 01:04:11',''),(1815,4,8,1,'Fixed duplicate phone from not admin users</dd><dd>Improved query for selecting voicemail messages, reducing the memory footprint</dd><dd>Improved query for selecting media files, reducing the memory footprint</dd><dd>Fixed the custom parking lot monitoring and pickup</dd><dd>Added two new fields to the general activity object for wallboard, showing the time elapsed from the last call and showing the state in different colors based on the time elapsed','2022-05-29 15:19:47',''),(1816,4,8,2,'More fixes to reduce the memory footprint when loading from the me_mediafiles table','2022-05-31 16:18:27',''),(1817,4,8,3,'<b>Slow upgrade - this upgrade will take a lots of time to apply due to database changes</b></dd><dd>Fixed email template profiles for missed calls</dd><dd>More adjustment to colors for wallboard agents</dd><dd>Preliminary support to geoip IPv6','2022-06-02 17:58:03',''),(1818,4,8,4,'<b>I will be travelling until the 18th of June, upgrade only if you need</b></dd><dd>Fixed enforcing music on hold for extensions</dd><dd>Parking lot for virtual extensions</dd><dd>New destination to park a call in a certain parking lot</dd><dd>Added a new variable for \"wherelanded\" in recording template</dd><dd>Fixed adding a destination with a feature code','2022-06-08 21:26:35',''),(1819,4,8,5,'Fixing the extension dial timeout when using the huntlist</dd><dd>Fixed extension edit link in Status/Peers</dd><dd>Added extension edit link in Configuration/Phones</dd><dd>Improved usability of new multicolor condition</dd><dd>Fixed a security problem allowing to evade restriction in the extension, like after an abuse detected</dd><dd>Fixed showing call rates allowed for the user while editing rates cost','2022-06-20 07:49:58',''),(1820,4,8,6,'Fixed locate ip</dd><dd>Fixed deleting DID using Proxyapi</dd><dd>Added ability to set in the virtual extension to use real extension callerid</dd><dd>Notification by email now more tolerant to bad email addresses','2022-06-26 23:45:52',''),(1821,4,8,7,'Extended the agent report to include more fields, like the stats</dd><dd>Added a menu for list the remote numbers for digital faxes, so more than one fax at time can be sent to these numbers, you can find in Admin/Settings and Configuration/Settings</dd><dd>Added a listnumbers and cleannumbers action for proxyapi campaign</dd><dd>Added disposition filter to OUTCDR report</dd><dd>Fixed a bug sending multiple alerts for call cost limits</dd><dd>Allowed extension user to use the simple call history','2022-07-04 13:15:55',''),(1822,4,8,8,'Added a condition to check for callerid name','2022-07-04 16:05:45',''),(1823,4,8,9,'Added option for using extension outbound callerid in virtual extension also to extensions</dd><dd>Added an option to use only the privacy id for callerid blocked calls. Works for now only on SIP providers</dd><dd>Disabled php logging by default</dd><dd>Added a cute condition to ask to enter a random number. It can be used to stop robocallers</dd><dd>Fixed a HTML injection problem</dd><dd>Added working hours restrictions to single extensions</dd><dd>Fixed a logging problem with \"login to all queues but only if allowed\"','2022-07-18 00:44:01',''),(1824,4,8,10,'Fixed new escaping code for jqgrid','2022-07-19 09:53:17',''),(1825,4,8,11,'Other jqgrid fixes','2022-07-20 09:39:53',''),(1826,4,8,12,'Added record and rerecord message without prompt (silent)</dd><dd>If the local mailer is not available, will retry in 5 seconds to send the voicemail</dd><dd>Fixed campaign \"Allowed channels for each of the free agents\" for campaign','2022-07-25 09:08:11',''),(1827,4,8,13,'Fixed the multiweek destination when chosen for the first time</dd><dd>Added export/import of routing profiles rules','2022-08-02 12:11:27',''),(1828,4,8,14,'Added a show all abandoned calls for queue status page</dd><dd>You can add multiple records to the phone book at once</dd><dd>You ca specify a custom message for callerid name when performing the internal call on campaign','2022-08-11 13:23:00',''),(1829,4,8,15,'Added auto refresh to campaign numbers and queue logs page</dd><dd>Fixed default values for remove_existing</dd><dd>Fixed auto rotation for sending faxes</dd><dd>A not existing provider cost will block the call if you set to not use routes at loss</dd><dd>Added encoding conversion to most CSV load pages','2022-08-22 08:00:32',''),(1830,4,8,16,'Added notification for csv load for extensions</dd><dd>Added -dir and -pb for directory provisioning','2022-08-22 19:33:40',''),(1831,4,8,17,'Added a new item defaults for \"Alert on offline\"</dd><dd>Improved callerid usage when forwarding anonymous calls</dd><dd>Added callerid name to campaigns</dd><dd>Added an option to play MoH when blind transfering a call</dd><dd>Added proxyapi to manage tenant settings','2022-08-28 20:12:40',''),(1832,4,8,18,'Fixed saving extensions in virtual phone provisioning</dd><dd>Extended the wallboard to include also the custom extensions</dd><dd>Fixed monthly limit for extensions','2022-09-05 10:06:55',''),(1833,4,8,19,'Fixed receiving SMS messages and not storing the content</dd><dd>Preliminary thread support for SMS','2022-09-12 00:23:54',''),(1834,4,8,20,'Added special destination to add the latest incoming and outgoing number to a campaign</dd><dd>Added an option to check only a certain number of digits when doing autoclip</dd><dd>Fixed saving a PJSIP extension with a less privileged user','2022-09-19 07:36:36','');

--
-- Table structure for table `ve_virtualextensions`
--

CREATE TABLE `ve_virtualextensions` (
  `ve_id` int(11) NOT NULL AUTO_INCREMENT,
  `ve_te_id` int(11) NOT NULL,
  `ve_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ve_callerid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ve_securitypin` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ve_mailbox` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ve_useextcallerid` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ve_id`),
  KEY `ve_te_id` (`ve_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ve_virtualextensions`
--


--
-- Table structure for table `ve_voiceengines`
--

CREATE TABLE `ve_voiceengines` (
  `ve_id` int(11) NOT NULL AUTO_INCREMENT,
  `ve_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ve_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ve_voiceengines`
--

INSERT INTO `ve_voiceengines` VALUES (1,'IBM Watson TTS'),(3,'Amazon AWS Polly'),(4,'Microsoft Azure Cognitive Services'),(5,'Google Cloud Text to Speech');

--
-- Table structure for table `vi_virtualextensionitems`
--

CREATE TABLE `vi_virtualextensionitems` (
  `vi_id` int(11) NOT NULL AUTO_INCREMENT,
  `vi_te_id` int(11) NOT NULL,
  `vi_ve_id` int(11) NOT NULL,
  `vi_ex_id` int(11) NOT NULL,
  `vi_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`vi_id`),
  KEY `name` (`vi_name`),
  KEY `vi_ex_id` (`vi_ex_id`),
  KEY `virtual_te_ve_id` (`vi_te_id`,`vi_ve_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `vi_virtualextensionitems`
--


--
-- Table structure for table `vl_voicemaillog`
--

CREATE TABLE `vl_voicemaillog` (
  `vl_id` int(11) NOT NULL AUTO_INCREMENT,
  `vl_message_id` int(11) NOT NULL,
  `vl_te_id` int(11) NOT NULL,
  `vl_datetime` datetime NOT NULL,
  `vl_action` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `vl_response` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `vl_action_parameter` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `vl_response_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`vl_id`),
  KEY `vl_te_id` (`vl_te_id`),
  KEY `vl_message_id` (`vl_message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `vl_voicemaillog`
--


--
-- Table structure for table `vo_voices`
--

CREATE TABLE `vo_voices` (
  `vo_id` int(11) NOT NULL AUTO_INCREMENT,
  `vo_ve_id` int(11) NOT NULL DEFAULT '0',
  `vo_language` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `vo_sublanguage` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `vo_dialect` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `vo_sex` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `vo_index` int(11) NOT NULL,
  `vo_voice` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `vo_voicedescription` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `vo_tts` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`vo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `vo_voices`
--

INSERT INTO `vo_voices` VALUES (1,1,'Italian','','','female',1,'it-IT_FrancescaVoice','Francesca',''),(2,1,'German','','','male',1,'de-DE_DieterVoice','Dieter',''),(3,1,'German','','','female',1,'de-DE_BirgitVoice','Birgit',''),(4,1,'English','British','','female',1,'en-GB_KateVoice','Kate',''),(5,1,'English','US','','female',1,'en-US_AllisonVoice','Allison',''),(6,1,'English','US','','male',1,'en-US_MichaelVoice','Michael',''),(7,1,'English','US','','female',1,'en-US_LisaVoice','Lisa',''),(8,1,'Spanish','Castilian','','male',1,'es-ES_EnriqueVoice','Enrique',''),(9,1,'Spanish','Castilian','','female',1,'es-ES_LauraVoice','Laura',''),(10,1,'Spanish','North America','','female',1,'es-US_SofiaVoice','Sofia',''),(11,1,'French','','','female',1,'fr-FR_ReneeVoice','Renee',''),(16,1,'Japanese','','','female',1,'ja-JP_EmiVoice','Emi',''),(17,1,'Portuguese','Brazilian','','female',1,'pt-BR_IsabelaVoice','Isabela','');

--
-- Table structure for table `voicemail`
--

CREATE TABLE `voicemail` (
  `uniqueid` int(11) NOT NULL AUTO_INCREMENT,
  `te_id` int(11) NOT NULL,
  `context` char(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',
  `mailbox` char(80) COLLATE utf8_unicode_ci NOT NULL,
  `password` char(80) COLLATE utf8_unicode_ci NOT NULL,
  `fullname` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pager` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `attach` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `attachfmt` char(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `serveremail` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tz` char(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tzbytenant` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `deletevoicemail` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `saycid` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sendvoicemail` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `review` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tempgreetwarn` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `operator` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `envelope` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sayduration` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `saydurationm` int(3) DEFAULT NULL,
  `forcename` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `forcegreetings` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `callback` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dialout` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `exitcontext` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `maxmsg` int(5) DEFAULT NULL,
  `volgain` decimal(5,2) DEFAULT NULL,
  `imapuser` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `imappassword` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `welcomeoption` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fromstring` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `minsecs` int(11) NOT NULL,
  `maxsecs` int(11) NOT NULL DEFAULT '3600',
  `transcript_store` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `onnewmessage` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `onnewmessageparam2` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ivr_id` int(11) NOT NULL,
  `nextaftercmd` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `onnewmessageparam4` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam5` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam6` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam7` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam8` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam9` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam10` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam11` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam12` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam13` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam14` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam15` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `includeindbn` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `onnewmessageparam16` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam17` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam18` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam19` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam20` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam21` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam22` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam23` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam24` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam25` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam26` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam27` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam28` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam29` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `onnewmessageparam30` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `transcript_generate` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `autodeleteolder` varchar(4) COLLATE utf8_unicode_ci DEFAULT '',
  PRIMARY KEY (`uniqueid`),
  KEY `te_id` (`te_id`),
  KEY `contextmailbox` (`context`,`mailbox`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `voicemail`
--


--
-- Table structure for table `voicemail_data`
--

CREATE TABLE `voicemail_data` (
  `filename` char(255) COLLATE utf8_unicode_ci NOT NULL,
  `origmailbox` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `context` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `macrocontext` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `exten` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `priority` int(5) DEFAULT NULL,
  `callerchan` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `callerid` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `origdate` char(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `origtime` int(11) DEFAULT NULL,
  `category` char(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  PRIMARY KEY (`filename`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `voicemail_data`
--


--
-- Table structure for table `voicemail_messages`
--

CREATE TABLE `voicemail_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dir` char(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `msgnum` int(11) NOT NULL DEFAULT '0',
  `context` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `macrocontext` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `callerid` char(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `origtime` int(11) DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `recording` longblob,
  `flag` char(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category` char(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mailboxuser` char(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mailboxcontext` char(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `msg_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `transcript` longblob,
  PRIMARY KEY (`id`),
  UNIQUE KEY `dirmsgnum` (`dir`,`msgnum`),
  KEY `voicemail_messages_dir` (`dir`),
  KEY `mailboxcontext` (`mailboxcontext`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `voicemail_messages`
--


--
-- Table structure for table `wb_wallboards`
--

CREATE TABLE `wb_wallboards` (
  `wb_id` int(11) NOT NULL AUTO_INCREMENT,
  `wb_te_id` int(11) NOT NULL,
  `wb_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `wb_description` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `wb_timeout` int(11) NOT NULL,
  `wb_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'queues',
  `wb_up_id` int(11) NOT NULL DEFAULT '0',
  `wb_extshow` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NUMBERS',
  PRIMARY KEY (`wb_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `wb_wallboards`
--


--
-- Table structure for table `wc_ip`
--

CREATE TABLE `wc_ip` (
  `wc_id` int(11) NOT NULL AUTO_INCREMENT,
  `wc_te_id` int(11) NOT NULL,
  `wc_ip` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `wc_note` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`wc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `wc_ip`
--


--
-- Table structure for table `we_wallboardelements`
--

CREATE TABLE `we_wallboardelements` (
  `we_id` int(11) NOT NULL AUTO_INCREMENT,
  `we_te_id` int(11) DEFAULT NULL,
  `we_wb_id` int(11) DEFAULT NULL,
  `we_xx_id` int(11) DEFAULT NULL,
  `we_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'queues',
  PRIMARY KEY (`we_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `we_wallboardelements`
--


--
-- Table structure for table `wh_webhooks`
--

CREATE TABLE `wh_webhooks` (
  `wh_id` int(11) NOT NULL AUTO_INCREMENT,
  `wh_te_id` int(11) NOT NULL,
  `wh_page` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `wh_type` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `wh_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `wh_postdata` text COLLATE utf8_unicode_ci NOT NULL,
  `wh_username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `wh_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`wh_id`),
  KEY `wh_te_id` (`wh_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `wh_webhooks`
--


--
-- Table structure for table `wi_wallboarditems`
--

CREATE TABLE `wi_wallboarditems` (
  `wi_id` int(11) NOT NULL AUTO_INCREMENT,
  `wi_code` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `wi_description` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `wi_default_title` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `wi_default_color` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `wi_default_bgcolor` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `wi_default_position` int(11) NOT NULL,
  `wi_default_size` int(11) NOT NULL,
  `wi_default_text_size` int(11) NOT NULL,
  `wi_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `wi_default_title_text_size` int(11) NOT NULL DEFAULT '24',
  `wi_default_color2` varchar(50) COLLATE utf8_unicode_ci DEFAULT '',
  `wi_default_color3` varchar(50) COLLATE utf8_unicode_ci DEFAULT '',
  `wi_default_bgcolor2` varchar(50) COLLATE utf8_unicode_ci DEFAULT '',
  `wi_default_bgcolor3` varchar(50) COLLATE utf8_unicode_ci DEFAULT '',
  `wi_help` text COLLATE utf8_unicode_ci NOT NULL,
  `wi_more` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`wi_id`),
  UNIQUE KEY `wi_code` (`wi_code`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `wi_wallboarditems`
--

INSERT INTO `wi_wallboarditems` VALUES (1,'CALLSINQUEUE','Number of callers waiting in the queue','Waiting now','#ffffff','#404040',10,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#404040','#404040','This item uses the reqtype=INFO&info=queue proxyapi request and queries the AGI manager interface using the \"queue show\" command, capturing the number of callers waiting to be connected to an agent in the selected queue',''),(2,'CALLSRECEIVED','Number of calls received by the queue','Inbound calls','#ffffff','#57889c',30,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#57889c','#57889c','',''),(3,'CALLSONLINE','Number of calls answered now in the queue','Answered now','#ffffff','#356e35',20,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#356e35','#356e35','',''),(4,'TALKTIME','Time spent talking with callers in the queue','Talk time','#ffffff','#a8829f',50,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#a8829f','#a8829f','',''),(5,'FIRSTWAITING','Time the first caller in line is waiting','1st waiting','#ffffff','#82a896',60,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#82a896','#82a896','',''),(6,'SECONDWAITING','Time the second caller in line is waiting','2nd waiting','#ffffff','#92a896',70,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#92a896','#92a896','',''),(7,'THIRDWAITING','Time the third caller in line is waiting','3rd waiting','#ffffff','#a2a896',80,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#a2a896','#a2a896','',''),(8,'ANSWEREDCALLS','Number of calls answered by agents','Answered calls','#ffffff','#3768ac',40,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#3768ac','#3768ac','',''),(10,'AGENTANSWERED','Agents: Answered Calls from Queues','Answered Calls from Queues','#305d8c','#d6dde7',1000,1,13,'AGENT',13,'#305d8c','#305d8c','#d6dde7','#d6dde7','You can set the background and text color when unavailable or when busy in the secondary color fields',''),(11,'EXTDIALEDANSWERED','Extensions: Dialed out calls and then answered','Dialed out calls and then answered','#305d8c','#d6dde7',9999,1,13,'EXTENSION',13,'#305d8c','#305d8c','#d6dde7','#d6dde7','You can set the background and text color when unavailable or when busy in the secondary color fields',''),(12,'EXTDIALEDTOTAL','Extensions: Dialed out calls','Dialed out calls','#305d8c','#d6dde7',9999,1,13,'EXTENSION',13,'#305d8c','#305d8c','#d6dde7','#d6dde7','You can set the background and text color when unavailable or when busy in the secondary color fields',''),(13,'EXTDIALEDANSWEREDTOTAL','Extensions: Dialed out and then answered/total','Dialed out calls and then answered/total','#305d8c','#d6dde7',9999,1,13,'EXTENSION',13,'#305d8c','#305d8c','#d6dde7','#d6dde7','You can set the background and text color when unavailable or when busy in the secondary color fields',''),(14,'TALKTIMETOTAL','Time spent talking with callers, all queues','Total Talk Time','#305d8c','#ffffff',9999,2,50,'BOXAGENT',24,'#305d8c','#305d8c','#ffffff','#ffffff','',''),(15,'CALLSINQUEUETOTAL','Number of callers waiting, all queues','Total callers waiting now','#305d8c','#ffffff',9999,2,50,'BOXAGENT',24,'#305d8c','#305d8c','#ffffff','#ffffff','',''),(16,'CALLSONLINETOTAL','Number of calls answered now, all queues','Total answered now','#305d8c','#ffffff',9999,2,50,'BOXAGENT',24,'#305d8c','#305d8c','#ffffff','#ffffff','',''),(17,'CALLSRECEIVEDTOTAL','Number of calls received, all queues','Total inbound calls','#305d8c','#ffffff',9999,2,50,'BOXAGENT',24,'#305d8c','#305d8c','#ffffff','#ffffff','',''),(18,'ANSWEREDCALLSTOTAL','Number of calls answered by agents, all queues','Total answered calls','#305d8c','#ffffff',9999,2,50,'BOXAGENT',24,'#305d8c','#305d8c','#ffffff','#ffffff','',''),(19,'TOTALOUTCALLTIME','Time spent dialing out, selected extensions','Total outbound talk time','#305d8c','#ffffff',9999,2,50,'BOXEXTENSION',24,'#305d8c','#305d8c','#ffffff','#ffffff','',''),(20,'AVERAGEOUTCALLTIME','Averate time spent dialing out, selected extensions','Average outbound talk time','#305d8c','#ffffff',9999,2,50,'BOXEXTENSION',24,'#305d8c','#305d8c','#ffffff','#ffffff','',''),(21,'TOTALOUTDIALS','Number of calls dialed, selected extensions','Calls dialed','#305d8c','#ffffff',9999,2,50,'BOXEXTENSION',24,'#305d8c','#305d8c','#ffffff','#ffffff','',''),(22,'TOTALOUTCALLS','Number of calls dialed and answered, selected extensions','Calls dialed and answered','#305d8c','#ffffff',9999,2,50,'BOXEXTENSION',24,'#305d8c','#305d8c','#ffffff','#ffffff','',''),(23,'EXTDETAILS','Extensions: Details','','#305d8c','#ffffff',9999,2,50,'LONGEXTENSION',24,'#305d8c','#305d8c','#ffffff','#ffffff','',''),(24,'EXTDETAILSWITHCDR','Extensions: Details with CDR link','','#305d8c','#ffffff',9999,2,50,'LONGEXTENSION',24,'#305d8c','#305d8c','#ffffff','#ffffff','',''),(25,'ABANDONEDCALLS','Number of callers abandoning the queue','Abandoned','#ffffff','#404040',30,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#404040','#404040','',''),(26,'ABANDONEDCALLSTOTAL','Number of callers abandoning all queues','Total abandoned','#ffffff','#57889c',30,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#57889c','#57889c','',''),(27,'TOTALOUTCALLS30SEC','Number of calls dialed and answered for more than 30 sec., selected extensions','Calls dialed and answered > 30 sec.','#ffffff','#404040',9999,2,50,'BOXEXTENSION',24,'#ffffff','#ffffff','#404040','#404040','',''),(28,'EXTDIALEDANSWERED30SEC','Extensions: Dialed out calls and then answered for more than 30 sec.','Dialed out calls and then answered > 30 sec.','#ffffff','#404040',9999,1,13,'EXTENSION',13,'#ffffff','#ffffff','#404040','#404040','You can set the background and text color when unavailable or when busy in the secondary color fields',''),(29,'EMPTY','Empty box','','#ffffff','#ffffff',9999,2,50,'',24,'#ffffff','#ffffff','#ffffff','#ffffff','',''),(30,'TOTALOUTCALLS180SEC','Number of calls dialed and answered for more than 180 sec., selected extensions','Calls dialed and answered > 180 sec.','#ffffff','#404040',9999,2,50,'BOXEXTENSION',24,'#ffffff','#ffffff','#404040','#404040','',''),(31,'EXTDIALEDANSWERED180SEC','Extensions: Dialed out calls and then answered for more than 180 sec.','Dialed out calls and then answered > 180 sec.','#ffffff','#404040',9999,1,13,'EXTENSION',13,'#ffffff','#ffffff','#404040','#404040','You can set the background and text color when unavailable or when busy in the secondary color fields',''),(32,'AVERAGETALKTIME','Average time spent talking with callers in the queue','Average Talk Time','#ffffff','#caa3bf',9999,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#caa3bf','#caa3bf','',''),(33,'AGENTSAVAILABLE','Number of available agents in the queue','Available Agents','#ffffff','#66ccff',9999,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#66ccff','#66ccff','',''),(34,'AGENTSPAUSED','Number of paused agents in the queue','Paused Agents','#ffffff','#336699',9999,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#336699','#336699','',''),(35,'AGENTQUEUEANSWERED','Agents: Answered Calls from shown Queue','Answered Calls from Queue','#305d8c','#d6dde7',9999,1,13,'AGENT',13,'#305d8c','#305d8c','#d6dde7','#d6dde7','You can set the background and text color when unavailable or when busy in the secondary color fields',''),(36,'AGENTQUEUEDELAY','Agents: Delay in answering calls from shown Queue','Delay in answering calls','#305d8c','#d6dde7',9999,1,13,'AGENT',13,'#305d8c','#305d8c','#d6dde7','#d6dde7','You can set the background and text color when unavailable or when busy in the secondary color fields',''),(37,'AGENTDELAY','Agents: Delay in answering calls from Queues','Delay in answering calls for all queues','#305d8c','#d6dde7',9999,1,13,'AGENT',13,'#305d8c','#305d8c','#d6dde7','#d6dde7','You can set the background and text color when unavailable or when busy in the secondary color fields',''),(38,'TIMEDOUTCALLS','Number of calls timed out in the queue','Timed out','#ffffff','#d6d6e7',9999,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#d6d6e7','#d6d6e7','',''),(39,'TIMEDOUTCALLSTOTAL','Number of calls timed out, all queues','Total Timed out','#ffffff','#d6d6d6',9999,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#d6d6d6','#d6d6d6','',''),(40,'TOTALOUTCALLS300SEC','Number of calls dialed and answered for more than 300 sec., selected extensions','Calls dialed and answered > 300 sec.','#ffffff','#404040',9999,2,50,'BOXEXTENSION',24,'#ffffff','#ffffff','#404040','#404040','',''),(41,'EXTDIALEDANSWERED300SEC','Extensions: Dialed out calls and then answered for more than 300 sec.','Dialed out calls and then answered > 300 sec.','#ffffff','#404040',9999,1,13,'EXTENSION',13,'#ffffff','#ffffff','#404040','#404040','You can set the background and text color when unavailable or when busy in the secondary color fields',''),(42,'AVERAGEHOLDTIME','Average hold time in the queue','Average hold time','#ffffff','#404040',9999,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#404040','#404040','',''),(43,'AVERAGEHOLDTIMETOTAL','Average hold time all the queues','Total average hold time','#ffffff','#404040',9999,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#404040','#404040','',''),(44,'SERVICELEVEL','Queue Service Level','Service Level','#ffffff','#66ccff',9999,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#66ccff','#66ccff','',''),(45,'THEMELOGO','Theme Logo','Replace with your company name','#ffffff','#000000',9999,1,50,'BOX',24,'#ffffff','#ffffff','#000000','#000000','',''),(46,'MAXHOLDTIME','Max Hold time in the queue','Max hold time','#ffffff','#000000',9999,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#000000','#000000','',''),(47,'TOTALMAXHOLDTIME','Max Hold time all the queues','Total max hold time','#ffffff','#000000',9999,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#000000','#000000','',''),(48,'AGENTSFREE','Number of free agents in the queue','Free Agents','#ffffff','#66ccff',9999,2,50,'BOXAGENT',24,'','','','','',''),(49,'AGENTSONLINE','Number of online agents in the queue','Online Agents','#ffffff','#336699',9999,2,50,'BOXAGENT',24,'','','','','',''),(50,'AGENTTIMEANSWERED','Agents: Answered minute:seconds from Queues','Answered minute:seconds from Queues','#305d8c','#d6dde7',9999,1,13,'AGENT',24,'','','','','',''),(51,'AGENTTIMEANDOUTANSWERED','Agents: Answered minute:seconds from Queues and outbound calls','Answered minute:seconds from Queues and outbound c','#305d8c','#d6dde7',9999,1,13,'AGENT',24,'','','','','',''),(52,'AGENTCONNECTEDQUEUEANSWERED','Agents connected: Answered Calls from Queue','Answered Calls from Queue','#305d8c','#d6dde7',9999,1,13,'AGENT',13,'#305d8c','#305d8c','#d6dde7','#d6dde7','You can set the background and text color when unavailable or when busy in the secondary color fields',''),(53,'EXTENSIONGENERALACTIVITY','Extensions: General Activity','Extensions activity','#305d8c','#d6dde7',9999,12,10,'LONGEXTENSION',10,'#305d8c','#305d8c','#d6dde7','#d6dde7','','yes'),(54,'SERVICELEVEL2','Queue Service Level 2','Service Level 2','#ffffff','#66ccff',9999,2,50,'BOXAGENT',24,'','','','','',''),(55,'QUEUECAR','Call answer rate','Call Answer Rate','#ffffff','#404040',15,2,50,'BOXAGENT',24,'#ffffff','#ffffff','#404040','#404040','',''),(56,'AGENTANSWEREDWITHCLIDANDCALLRUNTIME','Agents: Answered Calls from Queues with CallerID and call time','Answered Calls from Queues','#305d8c','#d6dde7',9999,2,13,'AGENT',24,'#305d8c','#305d8c','#d6dde7','#d6dde7','',''),(57,'QUEUECALLERSWAITING','Callers waiting in the queue','Callers Waiting','#305d8c','#d6dde7',9999,2,13,'BOXAGENT',24,'','','','','',''),(58,'AGENTQUEUEANSWEREDWITHCLIDANDCALLRUNTIME','Agents: Answered Calls from shown Queue with CallerID and call time','Answered Calls from Queue','#305d8c','#d6dde7',9999,2,13,'AGENT',24,'#305d8c','#305d8c','#d6dde7','#d6dde7','','');

--
-- Table structure for table `wp_wallboardparameters`
--

CREATE TABLE `wp_wallboardparameters` (
  `wp_id` int(11) NOT NULL AUTO_INCREMENT,
  `wp_te_id` int(11) NOT NULL,
  `wp_wb_id` int(11) NOT NULL,
  `wp_ws_id` int(11) NOT NULL,
  `wp_parameter` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `wp_value1` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `wp_value2` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `wp_value3` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `wp_value4` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `wp_value5` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`wp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `wp_wallboardparameters`
--


--
-- Table structure for table `ws_wallboardstructures`
--

CREATE TABLE `ws_wallboardstructures` (
  `ws_id` int(11) NOT NULL AUTO_INCREMENT,
  `ws_te_id` int(11) NOT NULL,
  `ws_wb_id` int(11) NOT NULL,
  `ws_wi_id` int(11) NOT NULL,
  `ws_title` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ws_color` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ws_bgcolor` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ws_position` int(11) NOT NULL,
  `ws_size` int(11) NOT NULL,
  `ws_text_size` int(11) NOT NULL,
  `ws_title_text_size` int(11) NOT NULL DEFAULT '24',
  `ws_color2` varchar(50) COLLATE utf8_unicode_ci DEFAULT '',
  `ws_color3` varchar(50) COLLATE utf8_unicode_ci DEFAULT '',
  `ws_bgcolor2` varchar(50) COLLATE utf8_unicode_ci DEFAULT '',
  `ws_bgcolor3` varchar(50) COLLATE utf8_unicode_ci DEFAULT '',
  `ws_parameters` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ws_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ws_wallboardstructures`
--


--
-- Table structure for table `xt_xmltemplates`
--

CREATE TABLE `xt_xmltemplates` (
  `xt_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `xt_te_id` int(10) unsigned NOT NULL,
  `xt_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `xt_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `xt_xmltemplate` longblob NOT NULL,
  PRIMARY KEY (`xt_id`),
  KEY `xt_te_id` (`xt_te_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `xt_xmltemplates`
--



