Таблица реалтайм очереди Asterisk

queues;

CREATE TABLE `queues` (
  `name` varchar(128) NOT NULL,
  `musiconhold` varchar(128) DEFAULT 'default',
  `announce` varchar(128) DEFAULT NULL,
  `context` varchar(128) DEFAULT NULL,
  `timeout` int(11) DEFAULT 15,
  `ringinuse` enum('yes','no') DEFAULT 'no',
  `setinterfacevar` enum('yes','no') DEFAULT 'no',
  `setqueuevar` enum('yes','no') DEFAULT 'no',
  `setqueueentryvar` enum('yes','no') DEFAULT 'no',
  `monitor_format` varchar(8) DEFAULT NULL,
  `membermacro` varchar(512) DEFAULT NULL,
  `membergosub` varchar(512) DEFAULT NULL,
  `queue_youarenext` varchar(128) DEFAULT 'queue-youarenext',
  `queue_thereare` varchar(128) DEFAULT 'queue-thereare',
  `queue_callswaiting` varchar(128) DEFAULT 'queue-callswaiting',
  `queue_quantity1` varchar(128) DEFAULT 'queue-quantity1',
  `queue_quantity2` varchar(128) DEFAULT 'queue-quantity2',
  `queue_holdtime` varchar(128) DEFAULT 'queue-holdtime',
  `queue_minutes` varchar(128) DEFAULT 'queue-minutes',
  `queue_minute` varchar(128) DEFAULT 'queue-minute',
  `queue_seconds` varchar(128) DEFAULT 'queue-seconds',
  `queue_thankyou` varchar(128) DEFAULT 'queue-thankyou',
  `queue_callerannounce` varchar(128) DEFAULT 'queue-callerannounce',
  `queue_reporthold` varchar(128) DEFAULT 'queue-reporthold',
  `announce_frequency` int(11) DEFAULT 45,
  `announce_to_first_user` enum('yes','no') DEFAULT 'no',
  `min_announce_frequency` int(11) DEFAULT 15,
  `announce_round_seconds` int(11) DEFAULT 10,
  `announce_holdtime` varchar(128) DEFAULT 'no',
  `announce_position` varchar(128) DEFAULT 'no',
  `announce_position_limit` int(11) DEFAULT 5,
  `periodic_announce` varchar(50) DEFAULT 'queue-periodic-announce',
  `periodic_announce_frequency` int(11) DEFAULT 0,
  `relative_periodic_announce` enum('yes','no') DEFAULT 'no',
  `random_periodic_announce` enum('yes','no') DEFAULT 'no',
  `retry` int(11) DEFAULT 5,
  `wrapuptime` int(11) DEFAULT 0,
  `penaltymemberslimit` int(11) DEFAULT 5,
  `autofill` enum('yes','no') DEFAULT 'no',
  `monitor_type` varchar(128) DEFAULT 'mixmonitor',
  `autopause` enum('yes','no','all') DEFAULT 'no',
  `autopausedelay` int(11) DEFAULT 0,
  `autopausebusy` enum('yes','no') DEFAULT 'no',
  `autopauseunavail` enum('yes','no') DEFAULT 'no',
  `maxlen` int(11) DEFAULT 0,
  `servicelevel` int(11) DEFAULT 3,
  `strategy` enum('ringall','leastrecent','fewestcalls','random','rrmemory','linear','wrandom','rrordered') DEFAULT 'ringall',
  `joinempty` varchar(128) DEFAULT NULL,
  `leavewhenempty` varchar(128) DEFAULT NULL,
  `reportholdtime` enum('yes','no') DEFAULT 'no',
  `memberdelay` int(11) DEFAULT 0,
  `weight` int(11) DEFAULT 0,
  `timeoutrestart` enum('yes','no') DEFAULT 'no',
  `defaultrule` varchar(128) DEFAULT NULL,
  `timeoutpriority` varchar(128) DEFAULT 'app',
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Field Type Null Key Default Extra
name varchar(128) NO PRI NULL
musiconhold varchar(128) YES NULL
announce varchar(128) YES NULL
context varchar(128) YES NULL
timeout int(11) YES NULL
ringinuse enum('yes','no') YES NULL
setinterfacevar enum('yes','no') YES NULL
setqueuevar enum('yes','no') YES NULL
setqueueentryvar enum('yes','no') YES NULL
monitor_format varchar(8) YES NULL
membermacro varchar(512) YES NULL
membergosub varchar(512) YES NULL
queue_youarenext varchar(128) YES NULL
queue_thereare varchar(128) YES NULL
queue_callswaiting varchar(128) YES NULL
queue_quantity1 varchar(128) YES NULL
queue_quantity2 varchar(128) YES NULL
queue_holdtime varchar(128) YES NULL
queue_minutes varchar(128) YES NULL
queue_minute varchar(128) YES NULL
queue_seconds varchar(128) YES NULL
queue_thankyou varchar(128) YES NULL
queue_callerannounce varchar(128) YES NULL
queue_reporthold varchar(128) YES NULL
announce_frequency int(11) YES NULL
announce_to_first_user enum('yes','no') YES NULL
min_announce_frequency int(11) YES NULL
announce_round_seconds int(11) YES NULL
announce_holdtime varchar(128) YES NULL
announce_position varchar(128) YES NULL
announce_position_limit int(11) YES NULL
periodic_announce varchar(50) YES NULL
periodic_announce_frequency int(11) YES NULL
relative_periodic_announce enum('yes','no') YES NULL
random_periodic_announce enum('yes','no') YES NULL
retry int(11) YES NULL
wrapuptime int(11) YES NULL
penaltymemberslimit int(11) YES NULL
autofill enum('yes','no') YES NULL
monitor_type varchar(128) YES NULL
autopause enum('yes','no','all') YES NULL
autopausedelay int(11) YES NULL
autopausebusy enum('yes','no') YES NULL
autopauseunavail enum('yes','no') YES NULL
maxlen int(11) YES NULL
servicelevel int(11) YES NULL
strategy enum('ringall','leastrecent','fewestcalls','random','rrmemory','linear','wrandom','rrordered') YES NULL
joinempty varchar(128) YES NULL
leavewhenempty varchar(128) YES NULL
reportholdtime enum('yes','no') YES NULL
memberdelay int(11) YES NULL
weight int(11) YES NULL
timeoutrestart enum('yes','no') YES NULL
defaultrule varchar(128) YES NULL
timeoutpriority varchar(128) YES NULL
Таблица операторов очереди Asterisk

queue_members;

Field Type Null Key Default Extra
queue_name varchar(80) NO PRI NULL
interface varchar(80) NO PRI NULL
membername varchar(80) YES NULL
state_interface varchar(80) YES NULL
penalty int(11) YES NULL
paused int(11) YES NULL
uniqueid int(11) NO UNI NULL auto_increment
  • asterisk/cf/extconfig.conf/realtime-queues.txt
  • Последние изменения: 2020/02/18