Commits

Zhang Huangbin committed e3e641e

Removed columns for MySQL and PostgreSQL backends:
- domain.defaultlanguage
- domain.defaultuserquota
- domain.defaultuseraliases
- domain.disableddomainprofiles
- domain.disableduserprofiles
- domain.defaultpasswordscheme
- domain.minpasswordlength
- domain.maxpasswordlength
They all are merged into column 'domain.settings'. For example:
domain.settings='default_language:en_US;default_user_quota:1024;'

  • Participants
  • Parent commits 6a5bc68

Comments (0)

Files changed (3)

iRedMail/ChangeLog

         - LMTP socket: lmtp:unix:private/dovecot-lmtp
         - LMTP inet listener: lmtp:inet:127.0.0.1:24
 
+    * Removed columns for MySQL and PostgreSQL backends:
+        - domain.defaultlanguage
+        - domain.defaultuserquota
+        - domain.defaultuseraliases
+        - domain.disableddomainprofiles
+        - domain.disableduserprofiles
+        - domain.defaultpasswordscheme
+        - domain.minpasswordlength
+        - domain.maxpasswordlength
+      They all are merged into column 'domain.settings'. For example:
+      domain.settings='default_language:en_US;default_user_quota:1024;'
+
     * New columns for MySQL and PostgreSQL backends:
         + mailbox.enablelmtp: used by Dovecot LMTP server.
         + domain.settings: used to store per-domain settings, userd in

iRedMail/samples/iredmail.mysql

     -- Per-domain transport. e.g. dovecot, smtp:[192.168.1.1]:25
     transport VARCHAR(255) NOT NULL DEFAULT 'dovecot',
     backupmx TINYINT(1) NOT NULL DEFAULT 0,
-    -- Default preferred language for newly created mail user.
-    defaultlanguage VARCHAR(5) NOT NULL DEFAULT 'en_US',
-    -- Default quota size for newly created mail account.
-    defaultuserquota BIGINT(20) NOT NULL DEFAULT '1024',
     -- Store per-domain settings. Used in iRedAdmin-Pro.
     settings TEXT,
-    -- List of mail alias addresses assigned to newly created user.
-    defaultuseraliases TEXT,
-    -- Disabled domain profiles which can not be viewed and updated by normal
-    -- domain admin. Multiple values must be separated by comma.
-    disableddomainprofiles VARCHAR(255) NOT NULL DEFAULT '',
-    -- Disabled user profiles which can not be viewed and updated by normal
-    -- domain admin. Multiple values must be separated by comma.
-    disableduserprofiles VARCHAR(255) NOT NULL DEFAULT '',
-    -- Default password scheme. e.g. md5, plain.
-    defaultpasswordscheme VARCHAR(10) NOT NULL DEFAULT '',
-    -- Minimal password length, per-domain setting.
-    minpasswordlength INT(10) NOT NULL DEFAULT 0,
-    -- Max password length, per-domain setting.
-    maxpasswordlength INT(10) NOT NULL DEFAULT 0,
     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',

iRedMail/samples/iredmail.pgsql

     quota INT8 NOT NULL DEFAULT 0,
     -- Per-domain transport. e.g. dovecot, smtp:[192.168.1.1]:25
     transport VARCHAR(255) NOT NULL DEFAULT 'dovecot',
-    backupmx INT2 NOT NULL DEFAULT 0,
-    -- Default preferred language for newly created mail user.
-    defaultlanguage VARCHAR(5) NOT NULL DEFAULT 'en_US',
-    -- Default quota size for newly created mail account.
-    defaultuserquota INT8 NOT NULL DEFAULT '1024',
     -- Store per-domain settings. Used in iRedAdmin-Pro.
     settings TEXT NOT NULL DEFAULT '',
-    -- List of mail alias addresses assigned to newly created user.
-    defaultuseraliases TEXT NOT NULL DEFAULT '',
-    -- Disabled domain profiles which can not be viewed and updated by normal
-    -- domain admin. Multiple values must be separated by comma.
-    disableddomainprofiles VARCHAR(255) NOT NULL DEFAULT '',
-    -- Disabled user profiles which can not be viewed and updated by normal
-    -- domain admin. Multiple values must be separated by comma.
-    disableduserprofiles VARCHAR(255) NOT NULL DEFAULT '',
-    -- Default password scheme. e.g. md5, plain.
-    defaultpasswordscheme VARCHAR(10) NOT NULL DEFAULT '',
-    -- Password length
-    minpasswordlength INT8 NOT NULL DEFAULT 0,
-    maxpasswordlength INT8 NOT NULL DEFAULT 0,
+    backupmx INT2 NOT NULL DEFAULT 0,
     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',
     expired TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT '9999-12-31 00:00:00',