Commits

Zhang Huangbin  committed 3fd1d3e

New SQL columns in table 'vmail.mailbox' for per-user restriction, used by iRedAPD: allowedsenders, rejectedsenders, allowedrecipients, rejectedrecipients.

  • Participants
  • Parent commits 554f533

Comments (0)

Files changed (3)

File iRedMail/ChangeLog

 iRedMail-0.8.4:
+    * New SQL columns in `vmail.mailbox` for per-user restriction, used by
+      iRedAPD:
+      allowedsenders, rejectedsenders, allowedrecipients, rejectedrecipients
     * Now supports OpenBSD built-in LDAP daemon: ldapd(8).
     * Fixed:
         - Cannot handle alias domain in Postfix per-user bcc.

File iRedMail/samples/iredmail.mysql

     lastloginprotocol CHAR(255) NOT NULL DEFAULT '',
     disclaimer TEXT NOT NULL DEFAULT '',
     passwordlastchange DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+    allowedsenders TEXT NOT NULL DEFAULT '',
+    rejectedsenders TEXT NOT NULL DEFAULT '',
+    allowedrecipients TEXT NOT NULL DEFAULT '',
+    rejectedrecipients TEXT NOT NULL DEFAULT '',
     created DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
     modified DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
     expired DATETIME NOT NULL DEFAULT '9999-12-31 00:00:00',

File iRedMail/samples/iredmail.pgsql

     lastloginipv4 INET NOT NULL DEFAULT '0.0.0.0',
     lastloginprotocol CHAR(255) NOT NULL DEFAULT '',
     disclaimer TEXT NOT NULL DEFAULT '',
+    allowedsenders TEXT NOT NULL DEFAULT '',
+    rejectedsenders TEXT NOT NULL DEFAULT '',
+    allowedrecipients TEXT NOT NULL DEFAULT '',
+    rejectedrecipients TEXT NOT NULL DEFAULT '',
     passwordlastchange TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT '1970-01-01 00:00:00',
     created TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT '1970-01-01 00:00:00',
     modified TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT '1970-01-01 00:00:00',