1382 lines
48 KiB
SQL
1382 lines
48 KiB
SQL
/*M!999999\- enable the sandbox mode */
|
|
-- MariaDB dump 10.19 Distrib 10.11.14-MariaDB, for debian-linux-gnu (x86_64)
|
|
--
|
|
-- Host: localhost Database: asterisk
|
|
-- ------------------------------------------------------
|
|
-- Server version 10.11.14-MariaDB-0ubuntu0.24.04.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 `admin`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `admin`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `admin` (
|
|
`variable` varchar(20) NOT NULL DEFAULT '',
|
|
`value` varchar(80) NOT NULL DEFAULT '',
|
|
PRIMARY KEY (`variable`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `ampusers`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `ampusers`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `ampusers` (
|
|
`username` varchar(190) NOT NULL,
|
|
`email` varchar(40) DEFAULT '',
|
|
`extension` varchar(40) DEFAULT '',
|
|
`password_sha1` varchar(40) NOT NULL,
|
|
`extension_low` varchar(20) NOT NULL DEFAULT '',
|
|
`extension_high` varchar(20) NOT NULL DEFAULT '',
|
|
`deptname` varchar(20) NOT NULL DEFAULT '',
|
|
`sections` longblob NOT NULL,
|
|
PRIMARY KEY (`username`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `callrecording`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `callrecording`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `callrecording` (
|
|
`callrecording_id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`callrecording_mode` varchar(50) DEFAULT NULL,
|
|
`description` varchar(50) DEFAULT NULL,
|
|
`dest` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`callrecording_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `callrecording_module`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `callrecording_module`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `callrecording_module` (
|
|
`extension` varchar(50) DEFAULT NULL,
|
|
`cidnum` varchar(50) DEFAULT '',
|
|
`callrecording` varchar(10) DEFAULT NULL,
|
|
`display` varchar(20) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `certman_cas`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `certman_cas`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `certman_cas` (
|
|
`uid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`basename` varchar(190) NOT NULL,
|
|
`cn` varchar(255) NOT NULL,
|
|
`on` varchar(255) NOT NULL,
|
|
`passphrase` varchar(255) DEFAULT NULL,
|
|
`salt` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`uid`),
|
|
UNIQUE KEY `basename` (`basename`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `certman_certs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `certman_certs`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `certman_certs` (
|
|
`cid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`caid` int(11) DEFAULT NULL,
|
|
`basename` varchar(190) NOT NULL,
|
|
`description` varchar(255) DEFAULT NULL,
|
|
`type` varchar(2) NOT NULL DEFAULT 'ss',
|
|
`default` tinyint(1) NOT NULL DEFAULT 0,
|
|
`additional` longblob DEFAULT NULL,
|
|
PRIMARY KEY (`cid`),
|
|
UNIQUE KEY `basename_UNIQUE` (`basename`),
|
|
UNIQUE KEY `basename` (`basename`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `certman_csrs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `certman_csrs`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `certman_csrs` (
|
|
`cid` int(11) NOT NULL AUTO_INCREMENT,
|
|
`basename` varchar(190) NOT NULL,
|
|
PRIMARY KEY (`cid`),
|
|
UNIQUE KEY `basename` (`basename`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `certman_mapping`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `certman_mapping`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `certman_mapping` (
|
|
`id` varchar(20) NOT NULL,
|
|
`cid` int(11) DEFAULT NULL,
|
|
`verify` varchar(255) DEFAULT NULL,
|
|
`setup` varchar(45) DEFAULT NULL,
|
|
`rekey` int(11) DEFAULT NULL,
|
|
`auto_generate_cert` tinyint(1) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `cron_jobs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `cron_jobs`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `cron_jobs` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`modulename` varchar(170) NOT NULL DEFAULT '',
|
|
`jobname` varchar(170) NOT NULL DEFAULT '',
|
|
`command` longtext DEFAULT NULL,
|
|
`class` varchar(255) DEFAULT '',
|
|
`schedule` varchar(255) NOT NULL DEFAULT '',
|
|
`max_runtime` int(11) NOT NULL DEFAULT 30,
|
|
`enabled` tinyint(1) NOT NULL DEFAULT 1,
|
|
`execution_order` int(11) NOT NULL DEFAULT 100,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `modulename` (`modulename`,`jobname`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `cronmanager`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `cronmanager`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `cronmanager` (
|
|
`module` varchar(50) NOT NULL DEFAULT '',
|
|
`id` varchar(24) NOT NULL DEFAULT '',
|
|
`time` varchar(5) DEFAULT NULL,
|
|
`freq` int(11) NOT NULL DEFAULT 0,
|
|
`lasttime` int(11) NOT NULL DEFAULT 0,
|
|
`command` varchar(255) NOT NULL DEFAULT '',
|
|
PRIMARY KEY (`module`,`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `dahdi`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `dahdi`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `dahdi` (
|
|
`id` varchar(20) NOT NULL DEFAULT '-1',
|
|
`keyword` varchar(30) NOT NULL DEFAULT '',
|
|
`data` varchar(255) NOT NULL DEFAULT '',
|
|
`flags` int(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`,`keyword`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `dahdichandids`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `dahdichandids`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `dahdichandids` (
|
|
`channel` int(11) NOT NULL DEFAULT 0,
|
|
`description` varchar(80) NOT NULL DEFAULT '',
|
|
`did` varchar(60) NOT NULL DEFAULT '',
|
|
PRIMARY KEY (`channel`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `devices`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `devices`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `devices` (
|
|
`id` varchar(20) NOT NULL DEFAULT '',
|
|
`tech` varchar(10) NOT NULL DEFAULT '',
|
|
`dial` varchar(255) NOT NULL DEFAULT '',
|
|
`devicetype` varchar(5) NOT NULL DEFAULT '',
|
|
`user` varchar(50) DEFAULT NULL,
|
|
`description` varchar(80) DEFAULT NULL,
|
|
`emergency_cid` varchar(100) DEFAULT NULL,
|
|
`hint_override` varchar(100) DEFAULT NULL,
|
|
KEY `id` (`id`),
|
|
KEY `tech` (`tech`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `emergencydevices`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `emergencydevices`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `emergencydevices` (
|
|
`id` varchar(20) NOT NULL,
|
|
`tech` varchar(10) NOT NULL,
|
|
`dial` varchar(255) NOT NULL,
|
|
`devicetype` varchar(10) DEFAULT NULL,
|
|
`user` varchar(50) DEFAULT NULL,
|
|
`description` varchar(100) DEFAULT NULL,
|
|
`emergency_cid` varchar(100) DEFAULT NULL,
|
|
`hint_override` varchar(100) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `featurecodes`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `featurecodes`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `featurecodes` (
|
|
`modulename` varchar(50) NOT NULL DEFAULT '',
|
|
`featurename` varchar(50) NOT NULL DEFAULT '',
|
|
`description` varchar(200) NOT NULL DEFAULT '',
|
|
`helptext` varchar(500) NOT NULL DEFAULT '',
|
|
`defaultcode` varchar(20) DEFAULT NULL,
|
|
`customcode` varchar(20) DEFAULT NULL,
|
|
`enabled` tinyint(1) NOT NULL DEFAULT 0,
|
|
`providedest` tinyint(1) NOT NULL DEFAULT 0,
|
|
`depend` varchar(200) DEFAULT NULL,
|
|
PRIMARY KEY (`modulename`,`featurename`),
|
|
KEY `enabled` (`enabled`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `freepbx_log`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `freepbx_log`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `freepbx_log` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`time` datetime NOT NULL,
|
|
`section` varchar(50) DEFAULT NULL,
|
|
`level` varchar(150) NOT NULL DEFAULT 'error',
|
|
`status` int(11) NOT NULL DEFAULT 0,
|
|
`message` longtext NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `time` (`time`,`level`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `freepbx_settings`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `freepbx_settings`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `freepbx_settings` (
|
|
`keyword` varchar(50) NOT NULL DEFAULT '',
|
|
`value` varchar(255) DEFAULT NULL,
|
|
`name` varchar(80) DEFAULT NULL,
|
|
`level` tinyint(1) DEFAULT 0,
|
|
`description` longtext DEFAULT NULL,
|
|
`type` varchar(25) DEFAULT NULL,
|
|
`options` longtext DEFAULT NULL,
|
|
`defaultval` varchar(255) DEFAULT NULL,
|
|
`readonly` tinyint(1) DEFAULT 0,
|
|
`hidden` tinyint(1) DEFAULT 0,
|
|
`category` varchar(50) DEFAULT NULL,
|
|
`module` varchar(50) DEFAULT NULL,
|
|
`emptyok` tinyint(1) DEFAULT 1,
|
|
`sortorder` int(11) DEFAULT 0,
|
|
PRIMARY KEY (`keyword`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `globals`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `globals`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `globals` (
|
|
`variable` varchar(190) NOT NULL,
|
|
`value` varchar(255) NOT NULL,
|
|
PRIMARY KEY (`variable`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `iax`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `iax`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `iax` (
|
|
`id` varchar(20) NOT NULL DEFAULT '-1',
|
|
`keyword` varchar(30) NOT NULL DEFAULT '',
|
|
`data` varchar(255) NOT NULL,
|
|
`flags` int(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`,`keyword`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `incoming`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `incoming`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `incoming` (
|
|
`cidnum` varchar(50) DEFAULT NULL,
|
|
`extension` varchar(50) NOT NULL,
|
|
`destination` varchar(60) DEFAULT NULL,
|
|
`privacyman` tinyint(1) DEFAULT NULL,
|
|
`alertinfo` varchar(255) DEFAULT NULL,
|
|
`ringing` varchar(20) DEFAULT NULL,
|
|
`fanswer` varchar(20) DEFAULT NULL,
|
|
`mohclass` varchar(80) NOT NULL DEFAULT 'default',
|
|
`description` varchar(100) DEFAULT NULL,
|
|
`grppre` varchar(80) DEFAULT NULL,
|
|
`delay_answer` int(11) DEFAULT NULL,
|
|
`pricid` varchar(20) DEFAULT NULL,
|
|
`pmmaxretries` varchar(2) DEFAULT NULL,
|
|
`pmminlength` varchar(2) DEFAULT NULL,
|
|
`reversal` varchar(10) DEFAULT NULL,
|
|
`rvolume` varchar(2) DEFAULT '',
|
|
`indication_zone` varchar(20) DEFAULT 'default'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `indications_zonelist`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `indications_zonelist`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `indications_zonelist` (
|
|
`iso` varchar(20) NOT NULL,
|
|
`name` varchar(80) NOT NULL,
|
|
`conf` longblob DEFAULT NULL,
|
|
PRIMARY KEY (`iso`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `ivr_details`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `ivr_details`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `ivr_details` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(50) DEFAULT NULL,
|
|
`description` varchar(150) DEFAULT NULL,
|
|
`announcement` int(11) DEFAULT NULL,
|
|
`directdial` varchar(50) DEFAULT NULL,
|
|
`invalid_loops` varchar(10) DEFAULT NULL,
|
|
`invalid_retry_recording` varchar(25) DEFAULT NULL,
|
|
`invalid_destination` varchar(50) DEFAULT NULL,
|
|
`timeout_enabled` varchar(50) DEFAULT NULL,
|
|
`invalid_recording` varchar(25) DEFAULT NULL,
|
|
`retvm` varchar(8) DEFAULT NULL,
|
|
`timeout_time` int(11) DEFAULT NULL,
|
|
`timeout_recording` varchar(25) DEFAULT NULL,
|
|
`timeout_retry_recording` varchar(25) DEFAULT NULL,
|
|
`timeout_destination` varchar(50) DEFAULT NULL,
|
|
`timeout_loops` varchar(10) DEFAULT NULL,
|
|
`timeout_append_announce` tinyint(1) NOT NULL DEFAULT 1,
|
|
`invalid_append_announce` tinyint(1) NOT NULL DEFAULT 1,
|
|
`timeout_ivr_ret` tinyint(1) NOT NULL DEFAULT 0,
|
|
`invalid_ivr_ret` tinyint(1) NOT NULL DEFAULT 0,
|
|
`alertinfo` varchar(150) DEFAULT NULL,
|
|
`rvolume` varchar(2) NOT NULL DEFAULT '',
|
|
`strict_dial_timeout` tinyint(1) NOT NULL DEFAULT 2,
|
|
`accept_pound_key` tinyint(1) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `ivr_entries`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `ivr_entries`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `ivr_entries` (
|
|
`ivr_id` int(11) NOT NULL,
|
|
`selection` varchar(30) DEFAULT NULL,
|
|
`dest` varchar(200) DEFAULT NULL,
|
|
`ivr_ret` tinyint(1) NOT NULL DEFAULT 0
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `kvblobstore`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `kvblobstore`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `kvblobstore` (
|
|
`uuid` char(36) NOT NULL,
|
|
`type` char(32) DEFAULT NULL,
|
|
`content` longblob DEFAULT NULL,
|
|
PRIMARY KEY (`uuid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `kvstore_Dashboard`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `kvstore_Dashboard`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `kvstore_Dashboard` (
|
|
`key` char(255) NOT NULL,
|
|
`val` varchar(4096) DEFAULT NULL,
|
|
`type` char(16) DEFAULT NULL,
|
|
`id` char(255) DEFAULT NULL,
|
|
UNIQUE KEY `uniqueindex` (`key`(190),`id`(190)),
|
|
KEY `keyindex` (`key`(190)),
|
|
KEY `idindex` (`id`(190))
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `kvstore_FreePBX`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `kvstore_FreePBX`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `kvstore_FreePBX` (
|
|
`key` char(255) NOT NULL,
|
|
`val` varchar(4096) DEFAULT NULL,
|
|
`type` char(16) DEFAULT NULL,
|
|
`id` char(255) DEFAULT NULL,
|
|
UNIQUE KEY `uniqueindex` (`key`(190),`id`(190)),
|
|
KEY `keyindex` (`key`(190)),
|
|
KEY `idindex` (`id`(190))
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `kvstore_FreePBX_Hooks`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `kvstore_FreePBX_Hooks`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `kvstore_FreePBX_Hooks` (
|
|
`key` char(255) NOT NULL,
|
|
`val` varchar(4096) DEFAULT NULL,
|
|
`type` char(16) DEFAULT NULL,
|
|
`id` char(255) DEFAULT NULL,
|
|
UNIQUE KEY `uniqueindex` (`key`(190),`id`(190)),
|
|
KEY `keyindex` (`key`(190)),
|
|
KEY `idindex` (`id`(190))
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `kvstore_FreePBX_Media`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `kvstore_FreePBX_Media`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `kvstore_FreePBX_Media` (
|
|
`key` char(255) NOT NULL,
|
|
`val` varchar(4096) DEFAULT NULL,
|
|
`type` char(16) DEFAULT NULL,
|
|
`id` char(255) DEFAULT NULL,
|
|
UNIQUE KEY `uniqueindex` (`key`(190),`id`(190)),
|
|
KEY `keyindex` (`key`(190)),
|
|
KEY `idindex` (`id`(190))
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `kvstore_FreePBX_modules_Cdr`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `kvstore_FreePBX_modules_Cdr`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `kvstore_FreePBX_modules_Cdr` (
|
|
`key` char(255) NOT NULL,
|
|
`val` varchar(4096) DEFAULT NULL,
|
|
`type` char(16) DEFAULT NULL,
|
|
`id` char(255) DEFAULT NULL,
|
|
UNIQUE KEY `uniqueindex` (`key`(190),`id`(190)),
|
|
KEY `keyindex` (`key`(190)),
|
|
KEY `idindex` (`id`(190))
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `kvstore_FreePBX_modules_Core`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `kvstore_FreePBX_modules_Core`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `kvstore_FreePBX_modules_Core` (
|
|
`key` char(255) NOT NULL,
|
|
`val` varchar(4096) DEFAULT NULL,
|
|
`type` char(16) DEFAULT NULL,
|
|
`id` char(255) DEFAULT NULL,
|
|
UNIQUE KEY `uniqueindex` (`key`(190),`id`(190)),
|
|
KEY `keyindex` (`key`(190)),
|
|
KEY `idindex` (`id`(190))
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `kvstore_FreePBX_modules_Filestore`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `kvstore_FreePBX_modules_Filestore`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `kvstore_FreePBX_modules_Filestore` (
|
|
`key` char(255) NOT NULL,
|
|
`val` varchar(4096) DEFAULT NULL,
|
|
`type` char(16) DEFAULT NULL,
|
|
`id` char(255) DEFAULT NULL,
|
|
UNIQUE KEY `uniqueindex` (`key`(190),`id`(190)),
|
|
KEY `keyindex` (`key`(190)),
|
|
KEY `idindex` (`id`(190))
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `kvstore_FreePBX_modules_Userman`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `kvstore_FreePBX_modules_Userman`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `kvstore_FreePBX_modules_Userman` (
|
|
`key` char(255) NOT NULL,
|
|
`val` varchar(4096) DEFAULT NULL,
|
|
`type` char(16) DEFAULT NULL,
|
|
`id` char(255) DEFAULT NULL,
|
|
UNIQUE KEY `uniqueindex` (`key`(190),`id`(190)),
|
|
KEY `keyindex` (`key`(190)),
|
|
KEY `idindex` (`id`(190))
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `kvstore_FreePBX_modules_Voicemail`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `kvstore_FreePBX_modules_Voicemail`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `kvstore_FreePBX_modules_Voicemail` (
|
|
`key` char(255) NOT NULL,
|
|
`val` varchar(4096) DEFAULT NULL,
|
|
`type` char(16) DEFAULT NULL,
|
|
`id` char(255) DEFAULT NULL,
|
|
UNIQUE KEY `uniqueindex` (`key`(190),`id`(190)),
|
|
KEY `keyindex` (`key`(190)),
|
|
KEY `idindex` (`id`(190))
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `kvstore_FreePBX_modules_Webrtc`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `kvstore_FreePBX_modules_Webrtc`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `kvstore_FreePBX_modules_Webrtc` (
|
|
`key` char(255) NOT NULL,
|
|
`val` varchar(4096) DEFAULT NULL,
|
|
`type` char(16) DEFAULT NULL,
|
|
`id` char(255) DEFAULT NULL,
|
|
UNIQUE KEY `uniqueindex` (`key`(190),`id`(190)),
|
|
KEY `keyindex` (`key`(190)),
|
|
KEY `idindex` (`id`(190))
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `kvstore_OOBE`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `kvstore_OOBE`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `kvstore_OOBE` (
|
|
`key` char(255) NOT NULL,
|
|
`val` varchar(4096) DEFAULT NULL,
|
|
`type` char(16) DEFAULT NULL,
|
|
`id` char(255) DEFAULT NULL,
|
|
UNIQUE KEY `uniqueindex` (`key`(190),`id`(190)),
|
|
KEY `keyindex` (`key`(190)),
|
|
KEY `idindex` (`id`(190))
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `kvstore_Sipsettings`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `kvstore_Sipsettings`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `kvstore_Sipsettings` (
|
|
`key` char(255) NOT NULL,
|
|
`val` varchar(4096) DEFAULT NULL,
|
|
`type` char(16) DEFAULT NULL,
|
|
`id` char(255) DEFAULT NULL,
|
|
UNIQUE KEY `uniqueindex` (`key`(190),`id`(190)),
|
|
KEY `keyindex` (`key`(190)),
|
|
KEY `idindex` (`id`(190))
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `module_xml`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `module_xml`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `module_xml` (
|
|
`id` varchar(20) NOT NULL DEFAULT 'xml',
|
|
`time` int(11) NOT NULL DEFAULT 0,
|
|
`data` longblob DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `modules`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `modules`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `modules` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`modulename` varchar(50) NOT NULL DEFAULT '',
|
|
`version` varchar(20) NOT NULL DEFAULT '',
|
|
`enabled` tinyint(1) NOT NULL DEFAULT 0,
|
|
`signature` longblob DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `music`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `music`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `music` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`category` varchar(190) DEFAULT NULL,
|
|
`type` varchar(100) DEFAULT NULL,
|
|
`random` tinyint(1) DEFAULT 0,
|
|
`application` varchar(255) DEFAULT NULL,
|
|
`format` varchar(10) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `category_UNIQUE` (`category`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `notifications`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `notifications`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `notifications` (
|
|
`module` varchar(50) NOT NULL DEFAULT '',
|
|
`id` varchar(50) NOT NULL DEFAULT '',
|
|
`level` int(11) NOT NULL DEFAULT 0,
|
|
`display_text` varchar(255) NOT NULL DEFAULT '',
|
|
`extended_text` longblob NOT NULL,
|
|
`link` varchar(255) NOT NULL DEFAULT '',
|
|
`reset` tinyint(1) NOT NULL DEFAULT 0,
|
|
`candelete` tinyint(1) NOT NULL DEFAULT 0,
|
|
`timestamp` int(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`module`,`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `outbound_route_email`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `outbound_route_email`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `outbound_route_email` (
|
|
`route_id` int(11) NOT NULL,
|
|
`emailfrom` varchar(320) DEFAULT '',
|
|
`emailto` varchar(320) DEFAULT '',
|
|
`emailsubject` longtext DEFAULT '',
|
|
`emailbody` longtext DEFAULT '',
|
|
PRIMARY KEY (`route_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `outbound_route_patterns`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `outbound_route_patterns`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `outbound_route_patterns` (
|
|
`route_id` int(11) NOT NULL,
|
|
`match_pattern_prefix` varchar(60) NOT NULL DEFAULT '',
|
|
`match_pattern_pass` varchar(60) NOT NULL DEFAULT '',
|
|
`match_cid` varchar(60) NOT NULL DEFAULT '',
|
|
`prepend_digits` varchar(100) NOT NULL DEFAULT '',
|
|
PRIMARY KEY (`route_id`,`match_pattern_prefix`,`match_pattern_pass`,`match_cid`,`prepend_digits`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `outbound_route_sequence`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `outbound_route_sequence`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `outbound_route_sequence` (
|
|
`route_id` int(11) NOT NULL,
|
|
`seq` int(11) NOT NULL,
|
|
PRIMARY KEY (`route_id`,`seq`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `outbound_route_trunks`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `outbound_route_trunks`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `outbound_route_trunks` (
|
|
`route_id` int(11) NOT NULL,
|
|
`trunk_id` int(11) NOT NULL,
|
|
`seq` int(11) NOT NULL,
|
|
PRIMARY KEY (`route_id`,`trunk_id`,`seq`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `outbound_routes`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `outbound_routes`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `outbound_routes` (
|
|
`route_id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(40) DEFAULT NULL,
|
|
`outcid` varchar(255) DEFAULT NULL,
|
|
`outcid_mode` varchar(20) DEFAULT NULL,
|
|
`password` varchar(80) DEFAULT NULL,
|
|
`emergency_route` varchar(4) DEFAULT NULL,
|
|
`intracompany_route` varchar(4) DEFAULT NULL,
|
|
`mohclass` varchar(80) DEFAULT NULL,
|
|
`time_group_id` int(11) DEFAULT NULL,
|
|
`dest` varchar(255) DEFAULT NULL,
|
|
`time_mode` varchar(20) DEFAULT '',
|
|
`calendar_id` varchar(255) DEFAULT NULL,
|
|
`calendar_group_id` varchar(255) DEFAULT NULL,
|
|
`timezone` varchar(255) DEFAULT NULL,
|
|
`notification_on` varchar(255) DEFAULT 'call',
|
|
PRIMARY KEY (`route_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `pjsip`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `pjsip`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `pjsip` (
|
|
`id` varchar(20) NOT NULL DEFAULT '-1',
|
|
`keyword` varchar(30) NOT NULL DEFAULT '',
|
|
`data` varchar(8100) NOT NULL,
|
|
`flags` int(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`,`keyword`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `queues_config`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `queues_config`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `queues_config` (
|
|
`extension` varchar(20) NOT NULL DEFAULT '',
|
|
`descr` varchar(254) NOT NULL DEFAULT '',
|
|
`grppre` varchar(100) NOT NULL DEFAULT '',
|
|
`alertinfo` varchar(254) NOT NULL DEFAULT '',
|
|
`ringing` tinyint(1) NOT NULL DEFAULT 0,
|
|
`maxwait` varchar(8) NOT NULL DEFAULT '',
|
|
`password` varchar(20) NOT NULL DEFAULT '',
|
|
`ivr_id` varchar(8) NOT NULL DEFAULT '0',
|
|
`dest` varchar(50) NOT NULL DEFAULT '',
|
|
`cwignore` tinyint(1) NOT NULL DEFAULT 0,
|
|
`queuewait` tinyint(1) DEFAULT 0,
|
|
`use_queue_context` tinyint(1) DEFAULT 0,
|
|
`togglehint` tinyint(1) DEFAULT 0,
|
|
`qnoanswer` tinyint(1) DEFAULT 0,
|
|
`callconfirm` tinyint(1) DEFAULT 0,
|
|
`callconfirm_id` int(11) DEFAULT NULL,
|
|
`qregex` varchar(255) DEFAULT NULL,
|
|
`agentannounce_id` int(11) DEFAULT NULL,
|
|
`joinannounce_id` int(11) DEFAULT NULL,
|
|
`monitor_type` varchar(5) DEFAULT NULL,
|
|
`monitor_heard` int(11) DEFAULT NULL,
|
|
`monitor_spoken` int(11) DEFAULT NULL,
|
|
`callback_id` varchar(8) NOT NULL DEFAULT '',
|
|
PRIMARY KEY (`extension`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `queues_details`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `queues_details`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `queues_details` (
|
|
`id` varchar(45) NOT NULL DEFAULT '-1',
|
|
`keyword` varchar(30) NOT NULL DEFAULT '',
|
|
`data` varchar(150) NOT NULL DEFAULT '',
|
|
`flags` int(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`,`keyword`,`data`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `recordings`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `recordings`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `recordings` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`displayname` varchar(50) DEFAULT NULL,
|
|
`filename` longblob DEFAULT NULL,
|
|
`description` varchar(254) DEFAULT NULL,
|
|
`fcode` tinyint(1) DEFAULT 0,
|
|
`fcode_pass` varchar(20) DEFAULT NULL,
|
|
`fcode_lang` varchar(20) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `sip`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `sip`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `sip` (
|
|
`id` varchar(20) NOT NULL DEFAULT '-1',
|
|
`keyword` varchar(30) NOT NULL DEFAULT '',
|
|
`data` varchar(8100) NOT NULL,
|
|
`flags` int(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`,`keyword`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `sipsettings`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `sipsettings`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `sipsettings` (
|
|
`keyword` varchar(50) NOT NULL DEFAULT '',
|
|
`seq` tinyint(1) NOT NULL DEFAULT 0,
|
|
`type` tinyint(1) NOT NULL DEFAULT 0,
|
|
`data` varchar(255) NOT NULL DEFAULT '',
|
|
PRIMARY KEY (`keyword`,`seq`,`type`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `soundlang_customlangs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `soundlang_customlangs`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `soundlang_customlangs` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`language` varchar(20) NOT NULL,
|
|
`description` varchar(80) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `soundlang_packages`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `soundlang_packages`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `soundlang_packages` (
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`type` varchar(20) NOT NULL,
|
|
`module` varchar(80) NOT NULL,
|
|
`language` varchar(20) NOT NULL,
|
|
`license` longblob DEFAULT NULL,
|
|
`author` varchar(80) DEFAULT NULL,
|
|
`authorlink` varchar(256) DEFAULT NULL,
|
|
`format` varchar(20) NOT NULL,
|
|
`version` varchar(20) DEFAULT NULL,
|
|
`installed` varchar(20) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `id` (`id`),
|
|
UNIQUE KEY `unique` (`type`,`module`,`language`,`format`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=148 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `soundlang_prompts`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `soundlang_prompts`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `soundlang_prompts` (
|
|
`type` varchar(20) NOT NULL,
|
|
`module` varchar(80) NOT NULL,
|
|
`language` varchar(20) NOT NULL,
|
|
`format` varchar(20) NOT NULL,
|
|
`filename` varchar(255) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `soundlang_settings`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `soundlang_settings`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `soundlang_settings` (
|
|
`keyword` varchar(20) NOT NULL,
|
|
`value` varchar(80) NOT NULL,
|
|
PRIMARY KEY (`keyword`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `trunk_dialpatterns`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `trunk_dialpatterns`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `trunk_dialpatterns` (
|
|
`trunkid` int(11) NOT NULL DEFAULT 0,
|
|
`match_pattern_prefix` varchar(50) NOT NULL DEFAULT '',
|
|
`match_pattern_pass` varchar(50) NOT NULL DEFAULT '',
|
|
`prepend_digits` varchar(50) NOT NULL DEFAULT '',
|
|
`seq` int(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`trunkid`,`match_pattern_prefix`,`match_pattern_pass`,`prepend_digits`,`seq`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `trunks`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `trunks`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `trunks` (
|
|
`trunkid` int(11) NOT NULL DEFAULT 0,
|
|
`tech` varchar(20) NOT NULL,
|
|
`channelid` varchar(190) NOT NULL DEFAULT '',
|
|
`name` varchar(255) NOT NULL DEFAULT '',
|
|
`outcid` varchar(255) NOT NULL DEFAULT '',
|
|
`keepcid` varchar(4) DEFAULT 'off',
|
|
`maxchans` varchar(6) DEFAULT '',
|
|
`failscript` varchar(255) NOT NULL DEFAULT '',
|
|
`dialoutprefix` varchar(255) NOT NULL DEFAULT '',
|
|
`usercontext` varchar(255) DEFAULT NULL,
|
|
`provider` varchar(40) DEFAULT NULL,
|
|
`disabled` varchar(4) DEFAULT 'off',
|
|
`continue` varchar(4) DEFAULT 'off',
|
|
`routedisplay` varchar(4) DEFAULT 'on',
|
|
PRIMARY KEY (`trunkid`,`tech`,`channelid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `ucp_sessions`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `ucp_sessions`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `ucp_sessions` (
|
|
`session` varchar(190) NOT NULL,
|
|
`uid` int(11) DEFAULT NULL,
|
|
`address` varchar(255) DEFAULT NULL,
|
|
`time` int(11) DEFAULT NULL,
|
|
`socketid` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`session`),
|
|
UNIQUE KEY `session_UNIQUE` (`session`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `userman_call_activity_groups`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `userman_call_activity_groups`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `userman_call_activity_groups` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`groupname` varchar(150) DEFAULT NULL,
|
|
`description` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `userman_call_activity_users`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `userman_call_activity_users`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `userman_call_activity_users` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`uid` varchar(40) NOT NULL DEFAULT '',
|
|
`act_grp_id` varchar(40) NOT NULL DEFAULT '',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `call_act_gid_uid_unique` (`uid`,`act_grp_id`),
|
|
KEY `call_act_gid_idx` (`act_grp_id`),
|
|
KEY `call_act_uid_idx` (`uid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `userman_directories`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `userman_directories`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `userman_directories` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(250) DEFAULT NULL,
|
|
`driver` varchar(150) NOT NULL DEFAULT '',
|
|
`active` tinyint(1) NOT NULL DEFAULT 0,
|
|
`order` int(11) NOT NULL DEFAULT 5,
|
|
`default` tinyint(1) NOT NULL DEFAULT 0,
|
|
`locked` tinyint(1) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `userman_groups`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `userman_groups`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `userman_groups` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`auth` varchar(150) DEFAULT 'freepbx',
|
|
`authid` varchar(750) DEFAULT NULL,
|
|
`groupname` varchar(150) DEFAULT NULL,
|
|
`description` varchar(255) DEFAULT NULL,
|
|
`language` varchar(100) DEFAULT NULL,
|
|
`timezone` varchar(100) DEFAULT NULL,
|
|
`dateformat` varchar(100) DEFAULT NULL,
|
|
`timeformat` varchar(100) DEFAULT NULL,
|
|
`datetimeformat` varchar(100) DEFAULT NULL,
|
|
`priority` int(11) NOT NULL DEFAULT 5,
|
|
`users` longblob DEFAULT NULL,
|
|
`permissions` longblob DEFAULT NULL,
|
|
`local` int(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `groupname_UNIQUE` (`groupname`,`auth`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `userman_groups_settings`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `userman_groups_settings`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `userman_groups_settings` (
|
|
`gid` int(11) NOT NULL,
|
|
`module` varchar(65) NOT NULL,
|
|
`key` varchar(190) NOT NULL,
|
|
`val` longblob NOT NULL,
|
|
`type` varchar(16) DEFAULT NULL,
|
|
UNIQUE KEY `index4` (`gid`,`module`,`key`),
|
|
KEY `index2` (`gid`,`key`),
|
|
KEY `index6` (`module`,`gid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `userman_password_reminder`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `userman_password_reminder`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `userman_password_reminder` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`uid` varchar(40) NOT NULL DEFAULT '',
|
|
`username` varchar(40) NOT NULL DEFAULT '',
|
|
`usermail` varchar(40) NOT NULL DEFAULT '',
|
|
`usertype` varchar(20) NOT NULL DEFAULT '',
|
|
`passwordChangedAt` datetime NOT NULL,
|
|
`passwordExpiryDate` datetime NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `userman_template_settings`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `userman_template_settings`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `userman_template_settings` (
|
|
`tid` int(11) NOT NULL,
|
|
`module` varchar(65) NOT NULL,
|
|
`key` varchar(190) NOT NULL,
|
|
`val` longblob NOT NULL,
|
|
`type` varchar(16) DEFAULT NULL,
|
|
UNIQUE KEY `index4` (`tid`,`module`,`key`),
|
|
KEY `index2` (`tid`,`key`),
|
|
KEY `index6` (`module`,`tid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `userman_ucp_templates`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `userman_ucp_templates`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `userman_ucp_templates` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`templatename` varchar(150) NOT NULL,
|
|
`description` varchar(255) DEFAULT NULL,
|
|
`importedfromuname` varchar(255) DEFAULT NULL,
|
|
`importedfromuid` varchar(255) DEFAULT NULL,
|
|
`defaultexten` varchar(255) DEFAULT NULL,
|
|
`hasupdated` tinyint(1) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `userman_users`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `userman_users`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `userman_users` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`auth` varchar(150) DEFAULT 'freepbx',
|
|
`authid` varchar(750) DEFAULT NULL,
|
|
`username` varchar(150) DEFAULT NULL,
|
|
`description` varchar(255) DEFAULT NULL,
|
|
`password` varchar(255) DEFAULT NULL,
|
|
`default_extension` varchar(45) NOT NULL DEFAULT 'none',
|
|
`primary_group` int(11) DEFAULT NULL,
|
|
`permissions` longblob DEFAULT NULL,
|
|
`fname` varchar(100) DEFAULT NULL,
|
|
`lname` varchar(100) DEFAULT NULL,
|
|
`displayname` varchar(200) DEFAULT NULL,
|
|
`title` varchar(100) DEFAULT NULL,
|
|
`company` varchar(100) DEFAULT NULL,
|
|
`department` varchar(100) DEFAULT NULL,
|
|
`language` varchar(100) DEFAULT NULL,
|
|
`timezone` varchar(100) DEFAULT NULL,
|
|
`dateformat` varchar(100) DEFAULT NULL,
|
|
`timeformat` varchar(100) DEFAULT NULL,
|
|
`datetimeformat` varchar(100) DEFAULT NULL,
|
|
`email` longtext DEFAULT NULL,
|
|
`cell` varchar(100) DEFAULT NULL,
|
|
`work` varchar(100) DEFAULT NULL,
|
|
`home` varchar(100) DEFAULT NULL,
|
|
`fax` varchar(100) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `username_UNIQUE` (`username`,`auth`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `userman_users_settings`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `userman_users_settings`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `userman_users_settings` (
|
|
`uid` int(11) NOT NULL,
|
|
`module` varchar(65) NOT NULL,
|
|
`key` varchar(190) NOT NULL,
|
|
`val` longblob NOT NULL,
|
|
`type` varchar(16) DEFAULT NULL,
|
|
UNIQUE KEY `index4` (`uid`,`module`,`key`),
|
|
KEY `index2` (`uid`,`key`),
|
|
KEY `index6` (`module`,`uid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `users`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `users`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `users` (
|
|
`extension` varchar(20) NOT NULL DEFAULT '',
|
|
`password` varchar(20) DEFAULT NULL,
|
|
`name` varchar(50) DEFAULT NULL,
|
|
`voicemail` varchar(50) DEFAULT NULL,
|
|
`ringtimer` int(11) DEFAULT NULL,
|
|
`noanswer` varchar(100) DEFAULT NULL,
|
|
`recording` varchar(50) DEFAULT NULL,
|
|
`outboundcid` varchar(50) DEFAULT NULL,
|
|
`sipname` varchar(50) DEFAULT NULL,
|
|
`noanswer_cid` varchar(20) NOT NULL DEFAULT '',
|
|
`busy_cid` varchar(20) NOT NULL DEFAULT '',
|
|
`chanunavail_cid` varchar(20) NOT NULL DEFAULT '',
|
|
`noanswer_dest` varchar(255) NOT NULL DEFAULT '',
|
|
`busy_dest` varchar(255) NOT NULL DEFAULT '',
|
|
`chanunavail_dest` varchar(255) NOT NULL DEFAULT '',
|
|
`mohclass` varchar(80) DEFAULT 'default',
|
|
KEY `extension` (`extension`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `voicemail_admin`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `voicemail_admin`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `voicemail_admin` (
|
|
`variable` varchar(30) NOT NULL DEFAULT '',
|
|
`value` varchar(80) NOT NULL DEFAULT '',
|
|
PRIMARY KEY (`variable`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `webrtc_clients`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `webrtc_clients`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `webrtc_clients` (
|
|
`user` varchar(190) NOT NULL,
|
|
`device` varchar(190) NOT NULL,
|
|
`prefix` varchar(10) NOT NULL,
|
|
`module` varchar(100) NOT NULL,
|
|
`certid` int(11) DEFAULT NULL,
|
|
UNIQUE KEY `userandprefix` (`user`,`prefix`),
|
|
UNIQUE KEY `device` (`device`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_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 2026-04-29 6:27:00
|