12 lines
280 B
MySQL
12 lines
280 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `pbx`.`followmeNumberConf`
|
||
|
|
AS SELECT `f`.`extension` AS `name`,
|
||
|
|
1 AS `ordinal`,
|
||
|
|
`f`.`phone` AS `phonenumber`,
|
||
|
|
`c`.`timeout` AS `timeout`
|
||
|
|
FROM (
|
||
|
|
`pbx`.`followme` `f`
|
||
|
|
JOIN `pbx`.`followmeConfig` `c`
|
||
|
|
)
|