--
-- Table structure for table `admin`
--
CREATE TABLE `admin` (
`user` VARCHAR(255) NOT NULL,
`password_sha1` VARCHAR(64) NOT NULL,
PRIMARY KEY (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `confbridge_ast_config`
--
CREATE TABLE `confbridge_ast_config` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`cat_metric` INT(11) NOT NULL DEFAULT '0',
`var_metric` INT(11) NOT NULL DEFAULT '0',
`commented` INT(11) NOT NULL DEFAULT '0',
`filename` VARCHAR(128) NOT NULL DEFAULT '',
`category` VARCHAR(128) NOT NULL DEFAULT 'default',
`var_name` VARCHAR(128) NOT NULL DEFAULT '',
`var_val` VARCHAR(128) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `filename_comment` (`filename`,`commented`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `dp_agents`
--
CREATE TABLE `dp_agents` (
`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
`context` VARCHAR(40) NOT NULL,
`exten` VARCHAR(40) NOT NULL,
`priority` INT(11) NOT NULL,
`app` VARCHAR(40) NOT NULL,
`appdata` VARCHAR(256) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `context` (`context`,`exten`,`priority`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `dp_external`
--
CREATE TABLE `dp_external` (
`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
`context` VARCHAR(40) NOT NULL,
`exten` VARCHAR(40) NOT NULL,
`priority` INT(11) NOT NULL,
`app` VARCHAR(40) NOT NULL,
`appdata` VARCHAR(256) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `context` (`context`,`exten`,`priority`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `dp_internal`
--
CREATE TABLE `dp_internal` (
`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
`context` VARCHAR(40) NOT NULL,
`exten` VARCHAR(40) NOT NULL,
`priority` INT(11) NOT NULL,
`app` VARCHAR(40) NOT NULL,
`appdata` VARCHAR(256) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `context` (`context`,`exten`,`priority`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `dp_living`
--
CREATE TABLE `ext_ast_config` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`cat_metric` INT(11) NOT NULL DEFAULT '0',
`var_metric` INT(11) NOT NULL DEFAULT '0',
`commented` INT(11) NOT NULL DEFAULT '0',
`filename` VARCHAR(128) NOT NULL DEFAULT '',
`category` VARCHAR(128) NOT NULL DEFAULT 'default',
`var_name` VARCHAR(128) NOT NULL DEFAULT '',
`var_val` VARCHAR(128) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `filename_comment` (`filename`,`commented`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `feat_ast_config`
--
CREATE TABLE `feat_ast_config` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`cat_metric` INT(11) NOT NULL DEFAULT '0',
`var_metric` INT(11) NOT NULL DEFAULT '0',
`commented` INT(11) NOT NULL DEFAULT '0',
`filename` VARCHAR(128) NOT NULL DEFAULT '',
`category` VARCHAR(128) NOT NULL DEFAULT 'default',
`var_name` VARCHAR(128) NOT NULL DEFAULT '',
`var_val` VARCHAR(128) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `filename_comment` (`filename`,`commented`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `follow_ast_config`
--
CREATE TABLE `follow_ast_config` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`cat_metric` INT(11) NOT NULL DEFAULT '0',
`var_metric` INT(11) NOT NULL DEFAULT '0',
`commented` INT(11) NOT NULL DEFAULT '0',
`filename` VARCHAR(128) NOT NULL DEFAULT '',
`category` VARCHAR(128) NOT NULL DEFAULT 'default',
`var_name` VARCHAR(128) NOT NULL DEFAULT '',
`var_val` VARCHAR(128) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `filename_comment` (`filename`,`commented`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `iaxfriends`
--
CREATE TABLE `iaxfriends` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(40) NOT NULL,
`type` enum('friend','user','peer') DEFAULT NULL,
`username` VARCHAR(40) DEFAULT NULL,
`mailbox` VARCHAR(40) DEFAULT NULL,
`secret` VARCHAR(40) DEFAULT NULL,
`dbsecret` VARCHAR(40) DEFAULT NULL,
`context` VARCHAR(40) DEFAULT NULL,
`regcontext` VARCHAR(40) DEFAULT NULL,
`host` VARCHAR(40) DEFAULT NULL,
`ipaddr` VARCHAR(40) DEFAULT NULL,
`port` INT(11) DEFAULT NULL,
`defaultip` VARCHAR(20) DEFAULT NULL,
`sourceaddress` VARCHAR(20) DEFAULT NULL,
`mask` VARCHAR(20) DEFAULT NULL,
`regexten` VARCHAR(40) DEFAULT NULL,
`regseconds` INT(11) DEFAULT NULL,
`accountcode` VARCHAR(80) DEFAULT NULL,
`mohinterpret` VARCHAR(20) DEFAULT NULL,
`mohsuggest` VARCHAR(20) DEFAULT NULL,
`inkeys` VARCHAR(40) DEFAULT NULL,
`outkeys` VARCHAR(40) DEFAULT NULL,
`language` VARCHAR(10) DEFAULT NULL,
`callerid` VARCHAR(100) DEFAULT NULL,
`cid_number` VARCHAR(40) DEFAULT NULL,
`sendani` enum('yes','no') DEFAULT NULL,
`fullname` VARCHAR(40) DEFAULT NULL,
`trunk` enum('yes','no') DEFAULT NULL,
`auth` VARCHAR(20) DEFAULT NULL,
`maxauthreq` INT(11) DEFAULT NULL,
`requirecalltoken` enum('yes','no','auto') DEFAULT NULL,
`encryption` enum('yes','no','aes128') DEFAULT NULL,
`transfer` enum('yes','no','mediaonly') DEFAULT NULL,
`jitterbuffer` enum('yes','no') DEFAULT NULL,
`forcejitterbuffer` enum('yes','no') DEFAULT NULL,
`disallow` VARCHAR(200) DEFAULT NULL,
`allow` VARCHAR(200) DEFAULT NULL,
`codecpriority` VARCHAR(40) DEFAULT NULL,
`qualify` VARCHAR(10) DEFAULT NULL,
`qualifysmoothing` enum('yes','no') DEFAULT NULL,
`qualifyfreqok` VARCHAR(10) DEFAULT NULL,
`qualifyfreqnotok` VARCHAR(10) DEFAULT NULL,
`timezone` VARCHAR(20) DEFAULT NULL,
`adsi` enum('yes','no') DEFAULT NULL,
`amaflags` VARCHAR(20) DEFAULT NULL,
`setvar` VARCHAR(200) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `iaxfriends_name` (`name`),
KEY `iaxfriends_name_host` (`name`,`host`),
KEY `iaxfriends_name_ipaddr_port` (`name`,`ipaddr`,`port`),
KEY `iaxfriends_ipaddr_port` (`ipaddr`,`port`),
KEY `iaxfriends_host_port` (`host`,`port`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `meetme`
--
CREATE TABLE `meetme` (
`bookid` INT(11) NOT NULL AUTO_INCREMENT,
`confno` VARCHAR(80) NOT NULL,
`starttime` datetime DEFAULT NULL,
`endtime` datetime DEFAULT NULL,
`pin` VARCHAR(20) DEFAULT NULL,
`adminpin` VARCHAR(20) DEFAULT NULL,
`opts` VARCHAR(20) DEFAULT NULL,
`adminopts` VARCHAR(20) DEFAULT NULL,
`recordingfilename` VARCHAR(80) DEFAULT NULL,
`recordingformat` VARCHAR(10) DEFAULT NULL,
`maxusers` INT(11) DEFAULT NULL,
`members` INT(11) NOT NULL,
PRIMARY KEY (`bookid`),
KEY `meetme_confno_start_end` (`confno`,`starttime`,`endtime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `musiconhold`
--
CREATE TABLE `musiconhold` (
`name` VARCHAR(80) NOT NULL,
`mode` enum('custom','files','mp3nb','quietmp3nb','quietmp3') DEFAULT NULL,
`directory` VARCHAR(255) DEFAULT NULL,
`application` VARCHAR(255) DEFAULT NULL,
`digit` VARCHAR(1) DEFAULT NULL,
`sort` VARCHAR(10) DEFAULT NULL,
`format` VARCHAR(10) DEFAULT NULL,
`stamp` datetime DEFAULT NULL,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `ps_aors`
--
CREATE TABLE `ps_aors` (
`id` VARCHAR(40) NOT NULL,
`contact` VARCHAR(255) DEFAULT NULL,
`default_expiration` INT(11) DEFAULT NULL,
`mailboxes` VARCHAR(80) DEFAULT NULL,
`max_contacts` INT(11) DEFAULT NULL,
`minimum_expiration` INT(11) DEFAULT NULL,
`remove_existing` enum('yes','no') DEFAULT NULL,
`qualify_frequency` INT(11) DEFAULT NULL,
`authenticate_qualify` enum('yes','no') DEFAULT NULL,
`maximum_expiration` INT(11) DEFAULT NULL,
`outbound_proxy` VARCHAR(40) DEFAULT NULL,
`support_path` enum('yes','no') DEFAULT NULL,
`qualify_timeout` FLOAT DEFAULT NULL,
`voicemail_extension` VARCHAR(40) DEFAULT NULL,
UNIQUE KEY `id` (`id`),
KEY `ps_aors_id` (`id`),
KEY `ps_aors_qualifyfreq_contact` (`qualify_frequency`,`contact`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `ps_auths`
--
CREATE TABLE `ps_auths` (
`id` VARCHAR(40) NOT NULL,
`auth_type` enum('md5','userpass') DEFAULT NULL,
`nonce_lifetime` INT(11) DEFAULT NULL,
`md5_cred` VARCHAR(40) DEFAULT NULL,
`password` VARCHAR(80) DEFAULT NULL,
`realm` VARCHAR(40) DEFAULT NULL,
`username` VARCHAR(40) DEFAULT NULL,
UNIQUE KEY `id` (`id`),
KEY `ps_auths_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `ps_contacts`
--
CREATE TABLE `ps_contacts` (
`id` VARCHAR(255) DEFAULT NULL,
`uri` VARCHAR(255) DEFAULT NULL,
`expiration_time` BIGINT(20) DEFAULT NULL,
`qualify_frequency` INT(11) DEFAULT NULL,
`outbound_proxy` VARCHAR(40) DEFAULT NULL,
`path` text,
`user_agent` VARCHAR(255) DEFAULT NULL,
`qualify_timeout` FLOAT DEFAULT NULL,
`reg_server` VARCHAR(20) DEFAULT NULL,
`authenticate_qualify` enum('yes','no') DEFAULT NULL,
`via_addr` VARCHAR(40) DEFAULT NULL,
`via_port` INT(11) DEFAULT NULL,
`call_id` VARCHAR(255) DEFAULT NULL,
`endpoint` VARCHAR(40) DEFAULT NULL,
`prune_on_boot` enum('yes','no') DEFAULT NULL,
UNIQUE KEY `id` (`id`),
UNIQUE KEY `ps_contacts_uq` (`id`,`reg_server`),
KEY `ps_contacts_id` (`id`),
KEY `ps_contacts_qualifyfreq_exp` (`qualify_frequency`,`expiration_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `ps_domain_aliases`
--
CREATE TABLE `ps_domain_aliases` (
`id` VARCHAR(40) NOT NULL,
`domain` VARCHAR(80) DEFAULT NULL,
UNIQUE KEY `id` (`id`),
KEY `ps_domain_aliases_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `ps_endpoint_id_ips`
--
CREATE TABLE `ps_endpoint_id_ips` (
`id` VARCHAR(40) NOT NULL,
`endpoint` VARCHAR(40) DEFAULT NULL,
`match` VARCHAR(80) DEFAULT NULL,
UNIQUE KEY `id` (`id`),
KEY `ps_endpoint_id_ips_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `ps_endpoints`
--
CREATE TABLE `ps_endpoints` (
`id` VARCHAR(40) NOT NULL,
`transport` VARCHAR(40) DEFAULT NULL,
`aors` VARCHAR(200) DEFAULT NULL,
`auth` VARCHAR(40) DEFAULT NULL,
`context` VARCHAR(40) DEFAULT NULL,
`disallow` VARCHAR(200) DEFAULT NULL,
`allow` VARCHAR(200) DEFAULT NULL,
`direct_media` enum('yes','no') DEFAULT NULL,
`connected_line_method` enum('invite','reinvite','update') DEFAULT NULL,
`direct_media_method` enum('invite','reinvite','update') DEFAULT NULL,
`direct_media_glare_mitigation` enum('none','outgoing','incoming') DEFAULT NULL,
`disable_direct_media_on_nat` enum('yes','no') DEFAULT NULL,
`dtmf_mode` enum('rfc4733','inband','info','auto') DEFAULT NULL,
`external_media_address` VARCHAR(40) DEFAULT NULL,
`force_rport` enum('yes','no') DEFAULT NULL,
`ice_support` enum('yes','no') DEFAULT NULL,
`identify_by` enum('username','auth_username') DEFAULT NULL,
`mailboxes` VARCHAR(40) DEFAULT NULL,
`moh_suggest` VARCHAR(40) DEFAULT NULL,
`outbound_auth` VARCHAR(40) DEFAULT NULL,
`outbound_proxy` VARCHAR(40) DEFAULT NULL,
`rewrite_contact` enum('yes','no') DEFAULT NULL,
`rtp_ipv6` enum('yes','no') DEFAULT NULL,
`rtp_symmetric` enum('yes','no') DEFAULT NULL,
`send_diversion` enum('yes','no') DEFAULT NULL,
`send_pai` enum('yes','no') DEFAULT NULL,
`send_rpid` enum('yes','no') DEFAULT NULL,
`timers_min_se` INT(11) DEFAULT NULL,
`timers` enum('forced','no','required','yes') DEFAULT NULL,
`timers_sess_expires` INT(11) DEFAULT NULL,
`callerid` VARCHAR(40) DEFAULT NULL,
`callerid_privacy` enum('allowed_not_screened','allowed_passed_screened','allowed_failed_screened','allowed','prohib_not_screened','prohib_passed_screened','prohib_failed_screened','prohib','unavailable') DEFAULT NULL,
`callerid_tag` VARCHAR(40) DEFAULT NULL,
`100rel` enum('no','required','yes') DEFAULT NULL,
`aggregate_mwi` enum('yes','no') DEFAULT NULL,
`trust_id_inbound` enum('yes','no') DEFAULT NULL,
`trust_id_outbound` enum('yes','no') DEFAULT NULL,
`use_ptime` enum('yes','no') DEFAULT NULL,
`use_avpf` enum('yes','no') DEFAULT NULL,
`media_encryption` enum('no','sdes','dtls') DEFAULT NULL,
`inband_progress` enum('yes','no') DEFAULT NULL,
`call_group` VARCHAR(40) DEFAULT NULL,
`pickup_group` VARCHAR(40) DEFAULT NULL,
`named_call_group` VARCHAR(40) DEFAULT NULL,
`named_pickup_group` VARCHAR(40) DEFAULT NULL,
`device_state_busy_at` INT(11) DEFAULT NULL,
`fax_detect` enum('yes','no') DEFAULT NULL,
`t38_udptl` enum('yes','no') DEFAULT NULL,
`t38_udptl_ec` enum('none','fec','redundancy') DEFAULT NULL,
`t38_udptl_maxdatagram` INT(11) DEFAULT NULL,
`t38_udptl_nat` enum('yes','no') DEFAULT NULL,
`t38_udptl_ipv6` enum('yes','no') DEFAULT NULL,
`tone_zone` VARCHAR(40) DEFAULT NULL,
`language` VARCHAR(40) DEFAULT NULL,
`one_touch_recording` enum('yes','no') DEFAULT NULL,
`record_on_feature` VARCHAR(40) DEFAULT NULL,
`record_off_feature` VARCHAR(40) DEFAULT NULL,
`rtp_engine` VARCHAR(40) DEFAULT NULL,
`allow_transfer` enum('yes','no') DEFAULT NULL,
`allow_subscribe` enum('yes','no') DEFAULT NULL,
`sdp_owner` VARCHAR(40) DEFAULT NULL,
`sdp_session` VARCHAR(40) DEFAULT NULL,
`tos_audio` VARCHAR(10) DEFAULT NULL,
`tos_video` VARCHAR(10) DEFAULT NULL,
`sub_min_expiry` INT(11) DEFAULT NULL,
`from_domain` VARCHAR(40) DEFAULT NULL,
`from_user` VARCHAR(40) DEFAULT NULL,
`mwi_from_user` VARCHAR(40) DEFAULT NULL,
`dtls_verify` VARCHAR(40) DEFAULT NULL,
`dtls_rekey` VARCHAR(40) DEFAULT NULL,
`dtls_cert_file` VARCHAR(200) DEFAULT NULL,
`dtls_private_key` VARCHAR(200) DEFAULT NULL,
`dtls_cipher` VARCHAR(200) DEFAULT NULL,
`dtls_ca_file` VARCHAR(200) DEFAULT NULL,
`dtls_ca_path` VARCHAR(200) DEFAULT NULL,
`dtls_setup` enum('active','passive','actpass') DEFAULT NULL,
`srtp_tag_32` enum('yes','no') DEFAULT NULL,
`media_address` VARCHAR(40) DEFAULT NULL,
`redirect_method` enum('user','uri_core','uri_pjsip') DEFAULT NULL,
`set_var` text,
`cos_audio` INT(11) DEFAULT NULL,
`cos_video` INT(11) DEFAULT NULL,
`message_context` VARCHAR(40) DEFAULT NULL,
`force_avp` enum('yes','no') DEFAULT NULL,
`media_use_received_transport` enum('yes','no') DEFAULT NULL,
`accountcode` VARCHAR(80) DEFAULT NULL,
`user_eq_phone` enum('yes','no') DEFAULT NULL,
`moh_passthrough` enum('yes','no') DEFAULT NULL,
`media_encryption_optimistic` enum('yes','no') DEFAULT NULL,
`rpid_immediate` enum('yes','no') DEFAULT NULL,
`g726_non_standard` enum('yes','no') DEFAULT NULL,
`rtp_keepalive` INT(11) DEFAULT NULL,
`rtp_timeout` INT(11) DEFAULT NULL,
`rtp_timeout_hold` INT(11) DEFAULT NULL,
`bind_rtp_to_media_address` enum('yes','no') DEFAULT NULL,
`voicemail_extension` VARCHAR(40) DEFAULT NULL,
`mwi_subscribe_replaces_unsolicited` INT(11) DEFAULT NULL,
`deny` VARCHAR(95) DEFAULT NULL,
`permit` VARCHAR(95) DEFAULT NULL,
`acl` VARCHAR(40) DEFAULT NULL,
`contact_deny` VARCHAR(95) DEFAULT NULL,
`contact_permit` VARCHAR(95) DEFAULT NULL,
`contact_acl` VARCHAR(40) DEFAULT NULL,
`subscribe_context` VARCHAR(40) DEFAULT NULL,
`fax_detect_timeout` INT(11) DEFAULT NULL,
`contact_user` VARCHAR(80) DEFAULT NULL,
`asymmetric_rtp_codec` enum('yes','no') DEFAULT NULL,
UNIQUE KEY `id` (`id`),
KEY `ps_endpoints_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `ps_globals`
--
CREATE TABLE `ps_globals` (
`id` VARCHAR(40) NOT NULL,
`max_forwards` INT(11) DEFAULT NULL,
`user_agent` VARCHAR(255) DEFAULT NULL,
`default_outbound_endpoint` VARCHAR(40) DEFAULT NULL,
`debug` VARCHAR(40) DEFAULT NULL,
`endpoint_identifier_order` VARCHAR(40) DEFAULT NULL,
`max_initial_qualify_time` INT(11) DEFAULT NULL,
`default_from_user` VARCHAR(80) DEFAULT NULL,
`keep_alive_interval` INT(11) DEFAULT NULL,
`regcontext` VARCHAR(80) DEFAULT NULL,
`contact_expiration_check_interval` INT(11) DEFAULT NULL,
`default_voicemail_extension` VARCHAR(40) DEFAULT NULL,
`disable_multi_domain` enum('yes','no') DEFAULT NULL,
`unidentified_request_count` INT(11) DEFAULT NULL,
`unidentified_request_period` INT(11) DEFAULT NULL,
`unidentified_request_prune_interval` INT(11) DEFAULT NULL,
`default_realm` VARCHAR(40) DEFAULT NULL,
`mwi_tps_queue_high` INT(11) DEFAULT NULL,
`mwi_tps_queue_low` INT(11) DEFAULT NULL,
`mwi_disable_initial_unsolicited` enum('yes','no') DEFAULT NULL,
`ignore_uri_user_options` enum('yes','no') DEFAULT NULL,
UNIQUE KEY `id` (`id`),
KEY `ps_globals_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `ps_registrations`
--
CREATE TABLE `ps_registrations` (
`id` VARCHAR(40) NOT NULL,
`auth_rejection_permanent` enum('yes','no') DEFAULT NULL,
`client_uri` VARCHAR(255) DEFAULT NULL,
`contact_user` VARCHAR(40) DEFAULT NULL,
`expiration` INT(11) DEFAULT NULL,
`max_retries` INT(11) DEFAULT NULL,
`outbound_auth` VARCHAR(40) DEFAULT NULL,
`outbound_proxy` VARCHAR(40) DEFAULT NULL,
`retry_interval` INT(11) DEFAULT NULL,
`forbidden_retry_interval` INT(11) DEFAULT NULL,
`server_uri` VARCHAR(255) DEFAULT NULL,
`transport` VARCHAR(40) DEFAULT NULL,
`support_path` enum('yes','no') DEFAULT NULL,
`fatal_retry_interval` INT(11) DEFAULT NULL,
`line` enum('yes','no') DEFAULT NULL,
`endpoint` VARCHAR(40) DEFAULT NULL,
UNIQUE KEY `id` (`id`),
KEY `ps_registrations_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `ps_subscription_persistence`
--
CREATE TABLE `ps_subscription_persistence` (
`id` VARCHAR(40) NOT NULL,
`packet` VARCHAR(2048) DEFAULT NULL,
`src_name` VARCHAR(128) DEFAULT NULL,
`src_port` INT(11) DEFAULT NULL,
`transport_key` VARCHAR(64) DEFAULT NULL,
`local_name` VARCHAR(128) DEFAULT NULL,
`local_port` INT(11) DEFAULT NULL,
`cseq` INT(11) DEFAULT NULL,
`tag` VARCHAR(128) DEFAULT NULL,
`endpoint` VARCHAR(40) DEFAULT NULL,
`expires` INT(11) DEFAULT NULL,
UNIQUE KEY `id` (`id`),
KEY `ps_subscription_persistence_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `ps_systems`
--
CREATE TABLE `ps_systems` (
`id` VARCHAR(40) NOT NULL,
`timer_t1` INT(11) DEFAULT NULL,
`timer_b` INT(11) DEFAULT NULL,
`compact_headers` enum('yes','no') DEFAULT NULL,
`threadpool_initial_size` INT(11) DEFAULT NULL,
`threadpool_auto_increment` INT(11) DEFAULT NULL,
`threadpool_idle_timeout` INT(11) DEFAULT NULL,
`threadpool_max_size` INT(11) DEFAULT NULL,
`disable_tcp_switch` enum('yes','no') DEFAULT NULL,
UNIQUE KEY `id` (`id`),
KEY `ps_systems_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `ps_transports`
--
CREATE TABLE `ps_transports` (
`id` VARCHAR(40) NOT NULL,
`async_operations` INT(11) DEFAULT NULL,
`bind` VARCHAR(40) DEFAULT NULL,
`ca_list_file` VARCHAR(200) DEFAULT NULL,
`cert_file` VARCHAR(200) DEFAULT NULL,
`cipher` VARCHAR(200) DEFAULT NULL,
`domain` VARCHAR(40) DEFAULT NULL,
`external_media_address` VARCHAR(40) DEFAULT NULL,
`external_signaling_address` VARCHAR(40) DEFAULT NULL,
`external_signaling_port` INT(11) DEFAULT NULL,
`method` enum('default','unspecified','tlsv1','sslv2','sslv3','sslv23') DEFAULT NULL,
`local_net` VARCHAR(40) DEFAULT NULL,
`password` VARCHAR(40) DEFAULT NULL,
`priv_key_file` VARCHAR(200) DEFAULT NULL,
`protocol` enum('udp','tcp','tls','ws','wss') DEFAULT NULL,
`require_client_cert` enum('yes','no') DEFAULT NULL,
`verify_client` enum('yes','no') DEFAULT NULL,
`verify_server` enum('yes','no') DEFAULT NULL,
`tos` VARCHAR(10) DEFAULT NULL,
`cos` INT(11) DEFAULT NULL,
`allow_reload` enum('yes','no') DEFAULT NULL,
UNIQUE KEY `id` (`id`),
KEY `ps_transports_id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `queue_members`
--
CREATE TABLE `queue_members` (
`queue_name` VARCHAR(80) NOT NULL,
`interface` VARCHAR(80) NOT NULL,
`membername` VARCHAR(80) DEFAULT NULL,
`state_interface` VARCHAR(80) DEFAULT NULL,
`penalty` INT(11) DEFAULT NULL,
`paused` INT(11) DEFAULT NULL,
`uniqueid` INT(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`queue_name`,`interface`),
UNIQUE KEY `uniqueid` (`uniqueid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `queue_rules`
--
CREATE TABLE `queue_rules` (
`rule_name` VARCHAR(80) NOT NULL,
`time` VARCHAR(32) NOT NULL,
`min_penalty` VARCHAR(32) NOT NULL,
`max_penalty` VARCHAR(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `queues`
--
CREATE TABLE `queues` (
`name` VARCHAR(128) NOT NULL,
`musiconhold` VARCHAR(128) DEFAULT NULL,
`announce` VARCHAR(128) DEFAULT NULL,
`context` VARCHAR(128) DEFAULT NULL,
`timeout` INT(11) DEFAULT NULL,
`ringinuse` enum('yes','no') DEFAULT NULL,
`setinterfacevar` enum('yes','no') DEFAULT NULL,
`setqueuevar` enum('yes','no') DEFAULT NULL,
`setqueueentryvar` enum('yes','no') DEFAULT NULL,
`monitor_format` VARCHAR(8) DEFAULT NULL,
`membermacro` VARCHAR(512) DEFAULT NULL,
`membergosub` VARCHAR(512) DEFAULT NULL,
`queue_youarenext` VARCHAR(128) DEFAULT NULL,
`queue_thereare` VARCHAR(128) DEFAULT NULL,
`queue_callswaiting` VARCHAR(128) DEFAULT NULL,
`queue_quantity1` VARCHAR(128) DEFAULT NULL,
`queue_quantity2` VARCHAR(128) DEFAULT NULL,
`queue_holdtime` VARCHAR(128) DEFAULT NULL,
`queue_minutes` VARCHAR(128) DEFAULT NULL,
`queue_minute` VARCHAR(128) DEFAULT NULL,
`queue_seconds` VARCHAR(128) DEFAULT NULL,
`queue_thankyou` VARCHAR(128) DEFAULT NULL,
`queue_callerannounce` VARCHAR(128) DEFAULT NULL,
`queue_reporthold` VARCHAR(128) DEFAULT NULL,
`announce_frequency` INT(11) DEFAULT NULL,
`announce_to_first_user` enum('yes','no') DEFAULT NULL,
`min_announce_frequency` INT(11) DEFAULT NULL,
`announce_round_seconds` INT(11) DEFAULT NULL,
`announce_holdtime` VARCHAR(128) DEFAULT NULL,
`announce_position` VARCHAR(128) DEFAULT NULL,
`announce_position_limit` INT(11) DEFAULT NULL,
`periodic_announce` VARCHAR(50) DEFAULT NULL,
`periodic_announce_frequency` INT(11) DEFAULT NULL,
`relative_periodic_announce` enum('yes','no') DEFAULT NULL,
`random_periodic_announce` enum('yes','no') DEFAULT NULL,
`retry` INT(11) DEFAULT NULL,
`wrapuptime` INT(11) DEFAULT NULL,
`penaltymemberslimit` INT(11) DEFAULT NULL,
`autofill` enum('yes','no') DEFAULT NULL,
`monitor_type` VARCHAR(128) DEFAULT NULL,
`autopause` enum('yes','no','all') DEFAULT NULL,
`autopausedelay` INT(11) DEFAULT NULL,
`autopausebusy` enum('yes','no') DEFAULT NULL,
`autopauseunavail` enum('yes','no') DEFAULT NULL,
`maxlen` INT(11) DEFAULT NULL,
`servicelevel` INT(11) DEFAULT NULL,
`strategy` enum('ringall','leastrecent','fewestcalls','random','rrmemory','linear','wrandom','rrordered') DEFAULT NULL,
`joinempty` VARCHAR(128) DEFAULT NULL,
`leavewhenempty` VARCHAR(128) DEFAULT NULL,
`reportholdtime` enum('yes','no') DEFAULT NULL,
`memberdelay` INT(11) DEFAULT NULL,
`weight` INT(11) DEFAULT NULL,
`timeoutrestart` enum('yes','no') DEFAULT NULL,
`defaultrule` VARCHAR(128) DEFAULT NULL,
`timeoutpriority` VARCHAR(128) DEFAULT NULL,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `sip_ast_config`
--
CREATE TABLE `sip_ast_config` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`cat_metric` INT(11) NOT NULL DEFAULT '0',
`var_metric` INT(11) NOT NULL DEFAULT '0',
`commented` INT(11) NOT NULL DEFAULT '0',
`filename` VARCHAR(128) NOT NULL DEFAULT '',
`category` VARCHAR(128) NOT NULL DEFAULT 'default',
`var_name` VARCHAR(128) NOT NULL DEFAULT '',
`var_val` VARCHAR(128) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `filename_comment` (`filename`,`commented`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `sippeers`
--
CREATE TABLE `sippeers` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(40) NOT NULL,
`ipaddr` VARCHAR(45) DEFAULT NULL,
`port` INT(11) DEFAULT NULL,
`regseconds` INT(11) DEFAULT NULL,
`defaultuser` VARCHAR(40) DEFAULT NULL,
`fullcontact` VARCHAR(80) DEFAULT NULL,
`regserver` VARCHAR(20) DEFAULT NULL,
`useragent` VARCHAR(255) DEFAULT NULL,
`lastms` INT(11) DEFAULT NULL,
`host` VARCHAR(40) DEFAULT NULL,
`type` enum('friend','user','peer') DEFAULT NULL,
`context` VARCHAR(40) DEFAULT NULL,
`permit` VARCHAR(95) DEFAULT NULL,
`deny` VARCHAR(95) DEFAULT NULL,
`secret` VARCHAR(40) DEFAULT NULL,
`md5secret` VARCHAR(40) DEFAULT NULL,
`remotesecret` VARCHAR(40) DEFAULT NULL,
`transport` enum('udp','tcp','tls','ws','wss','udp,tcp','tcp,udp') DEFAULT NULL,
`encryption` VARCHAR(128) DEFAULT NULL,
`dtmfmode` enum('rfc2833','info','shortinfo','inband','auto') DEFAULT NULL,
`directmedia` enum('yes','no','nonat','update','outgoing') DEFAULT NULL,
`nat` VARCHAR(29) DEFAULT NULL,
`callgroup` VARCHAR(40) DEFAULT NULL,
`pickupgroup` VARCHAR(40) DEFAULT NULL,
`language` VARCHAR(40) DEFAULT NULL,
`disallow` VARCHAR(200) DEFAULT NULL,
`allow` VARCHAR(200) DEFAULT NULL,
`insecure` VARCHAR(40) DEFAULT NULL,
`trustrpid` enum('yes','no') DEFAULT NULL,
`progressinband` enum('yes','no','never') DEFAULT NULL,
`promiscredir` enum('yes','no') DEFAULT NULL,
`useclientcode` enum('yes','no') DEFAULT NULL,
`accountcode` VARCHAR(80) DEFAULT NULL,
`setvar` VARCHAR(200) DEFAULT NULL,
`callerid` VARCHAR(40) DEFAULT NULL,
`amaflags` VARCHAR(40) DEFAULT NULL,
`callcounter` enum('yes','no') DEFAULT NULL,
`busylevel` INT(11) DEFAULT NULL,
`allowoverlap` enum('yes','no') DEFAULT NULL,
`allowsubscribe` enum('yes','no') DEFAULT NULL,
`videosupport` enum('yes','no') DEFAULT NULL,
`maxcallbitrate` INT(11) DEFAULT NULL,
`rfc2833compensate` enum('yes','no') DEFAULT NULL,
`mailbox` VARCHAR(40) DEFAULT NULL,
`session-timers` enum('accept','refuse','originate') DEFAULT NULL,
`session-expires` INT(11) DEFAULT NULL,
`session-minse` INT(11) DEFAULT NULL,
`session-refresher` enum('uac','uas') DEFAULT NULL,
`t38pt_usertpsource` VARCHAR(40) DEFAULT NULL,
`regexten` VARCHAR(40) DEFAULT NULL,
`fromdomain` VARCHAR(40) DEFAULT NULL,
`fromuser` VARCHAR(40) DEFAULT NULL,
`qualify` VARCHAR(40) DEFAULT NULL,
`defaultip` VARCHAR(45) DEFAULT NULL,
`rtptimeout` INT(11) DEFAULT NULL,
`rtpholdtimeout` INT(11) DEFAULT NULL,
`sendrpid` enum('yes','no') DEFAULT NULL,
`outboundproxy` VARCHAR(40) DEFAULT NULL,
`callbackextension` VARCHAR(40) DEFAULT NULL,
`timert1` INT(11) DEFAULT NULL,
`timerb` INT(11) DEFAULT NULL,
`qualifyfreq` INT(11) DEFAULT NULL,
`constantssrc` enum('yes','no') DEFAULT NULL,
`contactpermit` VARCHAR(95) DEFAULT NULL,
`contactdeny` VARCHAR(95) DEFAULT NULL,
`usereqphone` enum('yes','no') DEFAULT NULL,
`textsupport` enum('yes','no') DEFAULT NULL,
`faxdetect` enum('yes','no') DEFAULT NULL,
`buggymwi` enum('yes','no') DEFAULT NULL,
`auth` VARCHAR(40) DEFAULT NULL,
`fullname` VARCHAR(40) DEFAULT NULL,
`trunkname` VARCHAR(40) DEFAULT NULL,
`cid_number` VARCHAR(40) DEFAULT NULL,
`callingpres` enum('allowed_not_screened','allowed_passed_screen','allowed_failed_screen','allowed','prohib_not_screened','prohib_passed_screen','prohib_failed_screen','prohib') DEFAULT NULL,
`canreinvite` VARCHAR(15) DEFAULT NULL,
`mohinterpret` VARCHAR(40) DEFAULT NULL,
`mohsuggest` VARCHAR(40) DEFAULT NULL,
`parkinglot` VARCHAR(40) DEFAULT NULL,
`hasvoicemail` enum('yes','no') DEFAULT NULL,
`subscribemwi` enum('yes','no') DEFAULT NULL,
`vmexten` VARCHAR(40) DEFAULT NULL,
`autoframing` enum('yes','no') DEFAULT NULL,
`rtpkeepalive` INT(11) DEFAULT NULL,
`call-limit` INT(11) DEFAULT NULL,
`g726nonstandard` enum('yes','no') DEFAULT NULL,
`ignoresdpversion` enum('yes','no') DEFAULT NULL,
`allowtransfer` enum('yes','no') DEFAULT NULL,
`dynamic` enum('yes','no') DEFAULT NULL,
`path` VARCHAR(256) DEFAULT NULL,
`supportpath` enum('yes','no') DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `sippeers_name` (`name`),
KEY `sippeers_name_host` (`name`,`host`),
KEY `sippeers_ipaddr_port` (`ipaddr`,`port`),
KEY `sippeers_host_port` (`host`,`port`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `vm_ast_config`
--
CREATE TABLE `vm_ast_config` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`cat_metric` INT(11) NOT NULL DEFAULT '0',
`var_metric` INT(11) NOT NULL DEFAULT '0',
`commented` INT(11) NOT NULL DEFAULT '0',
`filename` VARCHAR(128) NOT NULL DEFAULT '',
`category` VARCHAR(128) NOT NULL DEFAULT 'default',
`var_name` VARCHAR(128) NOT NULL DEFAULT '',
`var_val` VARCHAR(128) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `filename_comment` (`filename`,`commented`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Table structure for table `voicemail`
--
CREATE TABLE `voicemail` (
`uniqueid` INT(11) NOT NULL AUTO_INCREMENT,
`context` VARCHAR(80) NOT NULL,
`mailbox` VARCHAR(80) NOT NULL,
`password` VARCHAR(80) NOT NULL,
`fullname` VARCHAR(80) DEFAULT NULL,
`alias` VARCHAR(80) DEFAULT NULL,
`email` VARCHAR(80) DEFAULT NULL,
`pager` VARCHAR(80) DEFAULT NULL,
`attach` enum('yes','no') DEFAULT NULL,
`attachfmt` VARCHAR(10) DEFAULT NULL,
`serveremail` VARCHAR(80) DEFAULT NULL,
`language` VARCHAR(20) DEFAULT NULL,
`tz` VARCHAR(30) DEFAULT NULL,
`deletevoicemail` enum('yes','no') DEFAULT NULL,
`saycid` enum('yes','no') DEFAULT NULL,
`sendvoicemail` enum('yes','no') DEFAULT NULL,
`review` enum('yes','no') DEFAULT NULL,
`tempgreetwarn` enum('yes','no') DEFAULT NULL,
`operator` enum('yes','no') DEFAULT NULL,
`envelope` enum('yes','no') DEFAULT NULL,
`sayduration` INT(11) DEFAULT NULL,
`forcename` enum('yes','no') DEFAULT NULL,
`forcegreetings` enum('yes','no') DEFAULT NULL,
`callback` VARCHAR(80) DEFAULT NULL,
`dialout` VARCHAR(80) DEFAULT NULL,
`exitcontext` VARCHAR(80) DEFAULT NULL,
`maxmsg` INT(11) DEFAULT NULL,
`volgain` DECIMAL(5,2) DEFAULT NULL,
`imapuser` VARCHAR(80) DEFAULT NULL,
`imappassword` VARCHAR(80) DEFAULT NULL,
`imapserver` VARCHAR(80) DEFAULT NULL,
`imapport` VARCHAR(8) DEFAULT NULL,
`imapflags` VARCHAR(80) DEFAULT NULL,
`stamp` datetime DEFAULT NULL,
PRIMARY KEY (`uniqueid`),
KEY `voicemail_mailbox` (`mailbox`),
KEY `voicemail_context` (`context`),
KEY `voicemail_mailbox_context` (`mailbox`,`context`),
KEY `voicemail_imapuser` (`imapuser`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;