2024-01-15 11:31:03 +00:00
|
|
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
|
|
|
|
SQL SECURITY DEFINER
|
|
|
|
|
VIEW `pbx`.`queueConf`
|
|
|
|
|
AS SELECT `q`.`name` AS `name`,
|
|
|
|
|
`c`.`strategy` AS `strategy`,
|
|
|
|
|
`c`.`timeout` AS `timeout`,
|
|
|
|
|
`c`.`retry` AS `retry`,
|
|
|
|
|
`c`.`weight` AS `weight`,
|
|
|
|
|
`c`.`maxLen` AS `maxlen`,
|
|
|
|
|
`c`.`ringInUse` AS `ringinuse`
|
|
|
|
|
FROM (
|
|
|
|
|
`pbx`.`queue` `q`
|
2024-07-10 05:46:18 +00:00
|
|
|
JOIN `pbx`.`queueMultiConfig` `c` ON(`q`.`config` = `c`.`id`)
|
2024-01-15 11:31:03 +00:00
|
|
|
)
|
