You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
361 lines
15 KiB
361 lines
15 KiB
-- MariaDB dump 10.19 Distrib 10.11.3-MariaDB, for debian-linux-gnu (x86_64) |
|
-- |
|
-- Host: 127.0.0.1 Database: amid |
|
-- ------------------------------------------------------ |
|
-- Server version 10.11.3-MariaDB-1 |
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
|
/*!40101 SET NAMES utf8mb4 */; |
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; |
|
/*!40103 SET TIME_ZONE='+00:00' */; |
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; |
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; |
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; |
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; |
|
|
|
-- |
|
-- Table structure for table `agent` |
|
-- |
|
|
|
DROP TABLE IF EXISTS `agent`; |
|
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
/*!40101 SET character_set_client = utf8 */; |
|
CREATE TABLE `agent` ( |
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
`name` varchar(64) NOT NULL COMMENT 'apelido do agent postgresql', |
|
`matricula` varchar(16) NOT NULL, |
|
`peer_number` varchar(16) DEFAULT NULL, |
|
`login_auto` tinyint(3) unsigned NOT NULL, |
|
`login_manual` tinyint(3) unsigned DEFAULT NULL, |
|
PRIMARY KEY (`id`) |
|
) ENGINE=MEMORY AUTO_INCREMENT=0 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; |
|
/*!40101 SET character_set_client = @saved_cs_client */; |
|
|
|
-- |
|
-- Table structure for table `bridge` |
|
-- |
|
|
|
DROP TABLE IF EXISTS `bridge`; |
|
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
/*!40101 SET character_set_client = utf8 */; |
|
CREATE TABLE `bridge` ( |
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
`uniqueid` varchar(100) NOT NULL, |
|
`type` varchar(256) DEFAULT NULL, |
|
`technology` varchar(100) DEFAULT NULL, |
|
`creator` varchar(100) DEFAULT NULL, |
|
`name` varchar(100) DEFAULT NULL, |
|
`num_channels` int(10) unsigned DEFAULT NULL, |
|
`video_source_mode` varchar(100) DEFAULT NULL, |
|
`local` tinyint(1) DEFAULT NULL, |
|
PRIMARY KEY (`id`) |
|
) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; |
|
/*!40101 SET character_set_client = @saved_cs_client */; |
|
|
|
-- |
|
-- Table structure for table `bridge_member` |
|
-- |
|
|
|
DROP TABLE IF EXISTS `bridge_member`; |
|
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
/*!40101 SET character_set_client = utf8 */; |
|
CREATE TABLE `bridge_member` ( |
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
`bridge_id` bigint(20) unsigned NOT NULL, |
|
`channel_id` bigint(20) unsigned DEFAULT NULL, |
|
PRIMARY KEY (`id`) |
|
) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; |
|
/*!40101 SET character_set_client = @saved_cs_client */; |
|
|
|
-- |
|
-- Table structure for table `call` |
|
-- |
|
|
|
DROP TABLE IF EXISTS `call`; |
|
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
/*!40101 SET character_set_client = utf8 */; |
|
CREATE TABLE `call` ( |
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
`call_uniqueid` varchar(100) DEFAULT NULL, |
|
`caller_channel_id` bigint(20) DEFAULT NULL, |
|
`callee_channel_id` bigint(20) DEFAULT NULL, |
|
`transfer_id` varchar(100) DEFAULT NULL, |
|
`call_type` varchar(100) DEFAULT NULL, |
|
`init_date` datetime(6) DEFAULT current_timestamp(6), |
|
PRIMARY KEY (`id`) |
|
) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; |
|
/*!40101 SET character_set_client = @saved_cs_client */; |
|
|
|
-- |
|
-- Table structure for table `call_member` |
|
-- |
|
|
|
DROP TABLE IF EXISTS `call_member`; |
|
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
/*!40101 SET character_set_client = utf8 */; |
|
CREATE TABLE `call_member` ( |
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
`call_id` varchar(100) DEFAULT NULL, |
|
`channel_id` varchar(100) DEFAULT NULL, |
|
`peer_id` varchar(100) DEFAULT NULL, |
|
`number` varchar(100) DEFAULT NULL, |
|
`calling_queue` varchar(100) DEFAULT NULL, |
|
PRIMARY KEY (`id`) |
|
) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; |
|
/*!40101 SET character_set_client = @saved_cs_client */; |
|
|
|
-- |
|
-- Table structure for table `call_transfer` |
|
-- |
|
|
|
DROP TABLE IF EXISTS `call_transfer`; |
|
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
/*!40101 SET character_set_client = utf8 */; |
|
CREATE TABLE `call_transfer` ( |
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
`call_id` bigint(20) unsigned DEFAULT NULL, |
|
`transferer_number` varchar(100) DEFAULT NULL, |
|
`transferee_number` varchar(100) DEFAULT NULL, |
|
`destination_number` varchar(100) DEFAULT NULL, |
|
`transfer_type` varchar(100) DEFAULT NULL, |
|
`previous_transfer_id` bigint(20) unsigned DEFAULT NULL, |
|
`previous_call_uniqueid` varchar(100) DEFAULT NULL, |
|
`transfer_call_uniqueid` varchar(100) DEFAULT NULL, |
|
`init_date` datetime(6) DEFAULT current_timestamp(6), |
|
PRIMARY KEY (`id`) |
|
) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; |
|
/*!40101 SET character_set_client = @saved_cs_client */; |
|
|
|
-- |
|
-- Table structure for table `channel` |
|
-- |
|
|
|
DROP TABLE IF EXISTS `channel`; |
|
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
/*!40101 SET character_set_client = utf8 */; |
|
CREATE TABLE `channel` ( |
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
`peer_id` bigint(20) DEFAULT NULL, |
|
`queue_id` bigint(20) DEFAULT NULL, |
|
`name` varchar(128) NOT NULL, |
|
`uniqueid` varchar(160) NOT NULL, |
|
`linkedid` varchar(160) NOT NULL, |
|
`channel_state` int(11) NOT NULL DEFAULT 0, |
|
`channel_state_desc` varchar(16) DEFAULT NULL, |
|
`caller_id_num` varchar(64) DEFAULT NULL, |
|
`caller_id_name` varchar(64) DEFAULT NULL, |
|
`connected_line_num` varchar(64) DEFAULT NULL, |
|
`connected_line_name` varchar(64) DEFAULT NULL, |
|
`account_code` varchar(32) DEFAULT NULL, |
|
`context` varchar(100) DEFAULT NULL, |
|
`priority` int(10) unsigned DEFAULT NULL, |
|
`chn_id_ref` bigint(20) DEFAULT NULL, |
|
`follow_ch_id` bigint(20) unsigned DEFAULT NULL, |
|
`transfer_from_chn_id` bigint(20) unsigned DEFAULT NULL, |
|
`transfer_to_chn_id` bigint(20) unsigned DEFAULT NULL, |
|
`pre_hangup` tinyint(1) DEFAULT NULL, |
|
`time_new_channel` datetime(6) DEFAULT current_timestamp(6), |
|
PRIMARY KEY (`id`), |
|
UNIQUE KEY `channel_UN` (`uniqueid`) |
|
) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; |
|
/*!40101 SET character_set_client = @saved_cs_client */; |
|
|
|
-- |
|
-- Table structure for table `channel_route` |
|
-- |
|
|
|
DROP TABLE IF EXISTS `channel_route`; |
|
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
/*!40101 SET character_set_client = utf8 */; |
|
CREATE TABLE `channel_route` ( |
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
`chn_id` bigint(20) unsigned NOT NULL, |
|
`event` varchar(100) DEFAULT NULL, |
|
`context` varchar(100) DEFAULT NULL, |
|
`key` varchar(256) DEFAULT NULL, |
|
`value` varchar(2048) DEFAULT NULL, |
|
PRIMARY KEY (`id`) |
|
) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; |
|
/*!40101 SET character_set_client = @saved_cs_client */; |
|
|
|
-- |
|
-- Table structure for table `exten` |
|
-- |
|
|
|
DROP TABLE IF EXISTS `exten`; |
|
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
/*!40101 SET character_set_client = utf8 */; |
|
CREATE TABLE `exten` ( |
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
`exten` varchar(30) NOT NULL COMMENT 'number of extension', |
|
`type` varchar(50) DEFAULT NULL, |
|
`context` varchar(80) DEFAULT NULL, |
|
`peer_id` bigint(20) unsigned DEFAULT 0 COMMENT 'peer', |
|
`status` int(4) NOT NULL, |
|
`status_text` varchar(32) NOT NULL, |
|
PRIMARY KEY (`id`) |
|
) ENGINE=MEMORY AUTO_INCREMENT=3480 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; |
|
/*!40101 SET character_set_client = @saved_cs_client */; |
|
|
|
-- |
|
-- Table structure for table `parking` |
|
-- |
|
|
|
DROP TABLE IF EXISTS `parking`; |
|
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
/*!40101 SET character_set_client = utf8 */; |
|
CREATE TABLE `parking` ( |
|
`prk_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
`cnl_id` bigint(20) unsigned DEFAULT NULL, |
|
`prk_channel_state` int(11) DEFAULT NULL, |
|
`prk_channel_state_desc` varchar(16) DEFAULT NULL, |
|
`prk_caller_id_num` varchar(32) DEFAULT NULL, |
|
`prk_caller_id_name` varchar(64) DEFAULT NULL, |
|
`prk_connected_line_num` varchar(32) DEFAULT NULL, |
|
`prk_connected_line_name` varchar(64) DEFAULT NULL, |
|
`prk_account_code` varchar(80) DEFAULT NULL, |
|
`prk_uniqueid` varchar(152) DEFAULT NULL, |
|
`prk_linkedid` varchar(152) DEFAULT NULL, |
|
`prk_duration` int(11) DEFAULT NULL, |
|
PRIMARY KEY (`prk_id`) |
|
) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; |
|
/*!40101 SET character_set_client = @saved_cs_client */; |
|
|
|
-- |
|
-- Table structure for table `peer` |
|
-- |
|
|
|
DROP TABLE IF EXISTS `peer`; |
|
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
/*!40101 SET character_set_client = utf8 */; |
|
CREATE TABLE `peer` ( |
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
`callerid_number` varchar(32) DEFAULT NULL, |
|
`callerid_name` varchar(64) DEFAULT NULL, |
|
`protocol` varchar(32) DEFAULT NULL, |
|
`status` varchar(32) DEFAULT NULL COMMENT 'Unknown Registered Unregistered Rejected Lagged', |
|
`exten_status` int(11) DEFAULT 0 COMMENT '-2 - A extensão foi removido do dialplan. -1 - A hint da extensão foi removida do dialplan. 0 - Idle - O dispositivo está desocupado. 1 - InUse - Os dispositivos relacionados estão em chamadas ativas, mas podem receber mais chamadas. 2 - Busy - Os dispositivos relacionados estão em chamadas ativas e não podem atender mais chamadas. 4 - Unavailable - Os dispositivos relacionados não estão acessíveis. 8 - Ringing - Dispositivos relacionados estão tocando no momento. 9 - InUse&Ringing - Os dispositivos relacionados estão tocando e em chamadas ativas. 16 - Hold - Os dispositivos relacionados estão atualmente em espera. 17 - InUse&Hold - Os dispositivos relacionados estão atualmente em espera e em chamadas ativas.', |
|
`exten_statustext` varchar(100) DEFAULT NULL COMMENT 'Idle - InUse - Busy - Unavailable - Ringing - InUse&Ringing - Hold - InUse&Hold - Unknown', |
|
`address` varchar(50) DEFAULT NULL, |
|
`trunk` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 é um tronco. 0 não tronco', |
|
`time` datetime(6) DEFAULT current_timestamp(6), |
|
PRIMARY KEY (`id`), |
|
UNIQUE KEY `idxpeercalleridnumber` (`callerid_number`) |
|
) ENGINE=MEMORY AUTO_INCREMENT=0 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; |
|
/*!40101 SET character_set_client = @saved_cs_client */; |
|
|
|
-- |
|
-- Table structure for table `queue` |
|
-- |
|
|
|
DROP TABLE IF EXISTS `queue`; |
|
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
/*!40101 SET character_set_client = utf8 */; |
|
CREATE TABLE `queue` ( |
|
`queue_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
`queue_name` varchar(64) NOT NULL, |
|
`queue_number` varchar(64) DEFAULT NULL, |
|
`strategy` varchar(100) DEFAULT NULL COMMENT 'ringall - leastrecent - fewestcalls - random - rrmemory - rrordered - linear - wrandom', |
|
`hold_time` bigint(20) unsigned DEFAULT NULL COMMENT 'uma média de tempo de espera para chamadas que foram atendidas. Em segundos', |
|
`talk_time` bigint(20) unsigned DEFAULT NULL COMMENT 'tempo que estão conectado (falando)', |
|
`calls_completed` bigint(20) unsigned DEFAULT NULL COMMENT 'chamadas completadas na fila', |
|
`calls_abandoned` bigint(20) unsigned DEFAULT NULL COMMENT 'chamadas abandonadas na fila', |
|
`calls_limit` int(10) unsigned DEFAULT NULL, |
|
`calls_waiting` int(10) unsigned DEFAULT NULL COMMENT 'Número de chamadas atualmente esperando em fila', |
|
PRIMARY KEY (`queue_id`), |
|
UNIQUE KEY `idxqueuename` (`queue_name`) |
|
) ENGINE=MEMORY AUTO_INCREMENT=0 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; |
|
/*!40101 SET character_set_client = @saved_cs_client */; |
|
|
|
-- |
|
-- Table structure for table `queue_member` |
|
-- |
|
|
|
DROP TABLE IF EXISTS `queue_member`; |
|
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
/*!40101 SET character_set_client = utf8 */; |
|
CREATE TABLE `queue_member` ( |
|
`queue_member_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
`queue_id` bigint(20) unsigned NOT NULL, |
|
`peer_id` bigint(20) unsigned NOT NULL DEFAULT 0, |
|
`agt_id` bigint(20) unsigned DEFAULT 0, |
|
`static` tinyint(4) DEFAULT NULL, |
|
`penalty` int(10) unsigned DEFAULT NULL, |
|
`calls_taken` int(10) unsigned DEFAULT NULL, |
|
`last_call` int(10) unsigned DEFAULT NULL, |
|
`in_call` tinyint(3) unsigned DEFAULT NULL, |
|
`status` int(10) unsigned DEFAULT NULL COMMENT '0 = AST_DEVICE_UNKNOWN - 1 = AST_DEVICE_NOT_INUSE - 2 = AST_DEVICE_INUSE - 3 = AST_DEVICE_BUSY - 4 = AST_DEVICE_INVALID - 5 = AST_DEVICE_UNAVAILABLE - 6 = AST_DEVICE_RINGING - 7 = AST_DEVICE_RINGINUSE - 8 = AST_DEVICE_ONHOLD', |
|
`paused` tinyint(3) unsigned DEFAULT NULL, |
|
PRIMARY KEY (`queue_member_id`) |
|
) ENGINE=MEMORY AUTO_INCREMENT=0 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; |
|
/*!40101 SET character_set_client = @saved_cs_client */; |
|
|
|
-- |
|
-- Table structure for table `settings` |
|
-- |
|
|
|
DROP TABLE IF EXISTS `settings`; |
|
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
/*!40101 SET character_set_client = utf8 */; |
|
CREATE TABLE `settings` ( |
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
`key` varchar(100) NOT NULL, |
|
`value` varchar(256) DEFAULT NULL, |
|
PRIMARY KEY (`id`) |
|
) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; |
|
/*!40101 SET character_set_client = @saved_cs_client */; |
|
|
|
-- |
|
-- Table structure for table `supervisor_agents` |
|
-- |
|
|
|
DROP TABLE IF EXISTS `supervisor_agents`; |
|
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
/*!40101 SET character_set_client = utf8 */; |
|
CREATE TABLE `supervisor_agents` ( |
|
`spa_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
`peer_id` bigint(20) unsigned NOT NULL, |
|
`agt_id` bigint(20) unsigned NOT NULL, |
|
`que_id` bigint(20) unsigned NOT NULL, |
|
`spa_callerid` varchar(32) DEFAULT NULL, |
|
`spa_status` varchar(16) DEFAULT NULL, |
|
`spa_uniqueid` varchar(160) DEFAULT NULL, |
|
`spa_status_desc` varchar(64) DEFAULT NULL, |
|
`spa_classification` smallint(6) DEFAULT 0, |
|
`sp_available_queue` smallint(6) DEFAULT 1, |
|
PRIMARY KEY (`spa_id`), |
|
UNIQUE KEY `idxpkspa` (`agt_id`,`que_id`) |
|
) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; |
|
/*!40101 SET character_set_client = @saved_cs_client */; |
|
|
|
-- |
|
-- Table structure for table `supervisor_queues` |
|
-- |
|
|
|
DROP TABLE IF EXISTS `supervisor_queues`; |
|
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
/*!40101 SET character_set_client = utf8 */; |
|
CREATE TABLE `supervisor_queues` ( |
|
`spq_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
|
`que_id` bigint(20) unsigned NOT NULL, |
|
`spq_calls` int(11) DEFAULT 0, |
|
`spq_wait` int(11) DEFAULT NULL, |
|
`spq_wait_time` int(11) DEFAULT NULL, |
|
`spq_abandon` int(11) DEFAULT NULL, |
|
`spq_abandon_time` int(11) DEFAULT NULL, |
|
PRIMARY KEY (`spq_id`) |
|
) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; |
|
/*!40101 SET character_set_client = @saved_cs_client */; |
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
|
|
|
-- Dump completed on 2023-09-20 11:26:49
|
|
|