salix/db/routines/pbx/views/followmeConf.sql

13 lines
319 B
MySQL
Raw Permalink Normal View History

CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `pbx`.`followmeConf`
AS SELECT `f`.`extension` AS `name`,
`c`.`music` AS `music`,
`c`.`context` AS `context`,
`c`.`takeCall` AS `takecall`,
`c`.`declineCall` AS `declinecall`
FROM (
`pbx`.`followme` `f`
JOIN `pbx`.`followmeConfig` `c`
)