1 CREATE OR REPLACE VIEW `alias_view`
AS
5 concat(`address`.`address`,
'@',`domaines`.`domaine`)
AS `mail`,
6 concat(
if(isnull(`mailbox`.`id`),
8 concat(concat(`address`.`address`,
'@',`domaines`.`domaine`),
'\n')),
9 `recipient`.`recipients`)
AS `alias`
12 ((`recipient`
join `address`
on((`address`.`id` = `recipient`.`address_id`)))
13 left join `mailbox`
on((`mailbox`.`address_id` = `address`.`id`))
15 join `domaines`
on((`domaines`.`id` = `address`.`domain_id`))
18 `address`.`enabled` =
1
27 distinct concat(`m`.`login`,
'@',`v`.`
value`)
AS `mail`,
33 `v`.`name` =
'mailname_bounce'
39 distinct concat(
'alterncpanel',
'@',`v`.`
value`)
AS `mail`,
45 (`v`.`name` =
'mailname_bounce' AND `m`.`uid`=
2000)
51 UPDATE address
SET TYPE=
"catchall" WHERE address=
"";
53 UPDATE domaines_type
SET only_dns=
1 WHERE name=
'ip';
54 UPDATE domaines_type
SET only_dns=
0 WHERE name=
'url';
55 UPDATE domaines_type
SET only_dns=
0 WHERE name=
'panel';