gelöschte Views

mail_discard

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `mail_discard` AS select case `mail_virtual`.`destination` when _latin1'd-e-v-n-u-l-l@shsh.de' then _latin1'DISCARD' when _latin1'r-e-j-e-c-t@shsh.de' then _latin1'REJECT' end AS `ACTION`,`mail_virtual`.`email` AS `email` from `mail_virtual` where `mail_virtual`.`destination` = _latin1'r-e-j-e-c-t@shsh.de' or `mail_virtual`.`destination` = _latin1'd-e-v-n-u-l-l@shsh.de' 

view_emaildomains

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_emaildomains` AS select `panel_domains`.`domain` AS `domain` from `panel_domains` where `panel_domains`.`isemaildomain` = 1