Таблица реалтайм очереди 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 |