MariaDB > describe queue_members; +-----------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+------------------+------+-----+---------+----------------+ | uniqueid | int(11) unsigned | NO | UNI | NULL | auto_increment | | 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 | | | extension | int(11) | YES | | NULL | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +-----------------+------------------+------+-----+---------+----------------+ 10 rows in set (0.00 sec) MariaDB > describe queues; +-----------------------------+------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | 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 | | | client_id | int(11) | NO | | NULL | | | extension | int(11) | NO | | NULL | | | fullname | varchar(40) | NO | | NULL | | | allow_fwd | tinyint(1) | NO | | 0 | | | created_at | timestamp | YES | | NULL | | | updated_at | timestamp | YES | | NULL | | +-----------------------------+------------------------------------------------------------------------------------------------+------+-----+---------+-------+ 59 rows in set (0.00 sec) MariaDB [sipmanager]> describe queue_rules; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | rule_name | varchar(80) | NO | | NULL | | | time | varchar(32) | NO | | NULL | | | min_penalty | varchar(32) | NO | | NULL | | | max_penalty | varchar(32) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 4 rows in set (0.00 sec) MariaDB [sipmanager]> describe queue_log; +-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | time | char(26) | YES | | NULL | | | callid | varchar(32) | NO | MUL | | | | queuename | varchar(32) | NO | MUL | | | | agent | varchar(32) | NO | | | | | event | varchar(32) | NO | | | | | data1 | varchar(100) | NO | | | | | data2 | varchar(100) | NO | | | | | data3 | varchar(100) | NO | | | | | data4 | varchar(100) | NO | | | | | data5 | varchar(100) | NO | | | | +-----------+------------------+------+-----+---------+----------------+ 11 rows in set (0.00 sec)