ALTER TABLE mail_users ADD quota_mb integer DEFAULT 100;
DROP VIEW user_view;
CREATE VIEW user_view AS SELECT *,
name||'@'||domain AS mail,
'/var/mail/vhosts/'||domain||'/'||name AS dovecot_home,
domain||'/'||name||'/Maildir/' AS maildir,
'*:storage='||quota_mb||'M' AS quota_rule
FROM mail_users;
This entry was posted on 金曜日, 1月 6th, 2023 at 16:50 and is filed under 未分類. You can follow any responses to this entry through the RSS 2.0 feed.
You can skip to the end and leave a response. Pinging is currently not allowed.