Commits

Zhang Huangbin  committed b9ae7ee

New columns for MySQL/PostgreSQL backends:
- admin.settings: used to store per-user settings, used in iRedAdmin.
- alias.islit: used to mark a sql record is a mail list account.

  • Participants
  • Parent commits 0547745

Comments (0)

Files changed (3)

File iRedMail/ChangeLog

 iRedMail-0.9.0:
-    * New column for SQL backends: mailbox.settings. Used to store per-user
-      settings, used in iRedAdmin-Pro.
+    * New columns for MySQL and PostgreSQL backends:
+        + mailbox.settings: used to store per-user settings, used in
+          iRedAdmin-Pro.
+        + admin.settings: used to store per-user settings, used in
+          iRedAdmin-Pro.
+        + alias.islist: used to mark a sql record is a mail list account.
     * Disable 'smtp_tls_security_level=may', doesn't work very well with
       self-signed SSL certificate, especially sending email from Gmail.
     * New column for SQL backends (mailbox.enablelmtp) and new attribute/value

File iRedMail/samples/iredmail.mysql

     name VARCHAR(255) NOT NULL DEFAULT '',
     language VARCHAR(5) NOT NULL DEFAULT 'en_US',
     passwordlastchange DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+    -- Store per-admin settings. Used in iRedAdmin-Pro.
+    settings TEXT,
     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',
     moderators TEXT,
     accesspolicy VARCHAR(30) NOT NULL DEFAULT '',
     domain VARCHAR(255) NOT NULL DEFAULT '',
+    -- Mark this record is a mail list account
+    islist TINYINT(1) 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',
     active TINYINT(1) NOT NULL DEFAULT 1,
     PRIMARY KEY (address),
     INDEX (domain),
+    INDEX (islist),
     INDEX (expired),
     INDEX (active)
 ) ENGINE=MyISAM;

File iRedMail/samples/iredmail.pgsql

     name VARCHAR(255) NOT NULL DEFAULT '',
     language VARCHAR(5) NOT NULL DEFAULT 'en_US',
     passwordlastchange TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT '1970-01-01 00:00:00',
+    -- Store per-admin settings. Used in iRedAdmin-Pro.
+    settings TEXT NOT NULL DEFAULT '',
     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',
     moderators TEXT NOT NULL DEFAULT '',
     accesspolicy VARCHAR(30) NOT NULL DEFAULT '',
     domain VARCHAR(255) NOT NULL DEFAULT '',
+    -- Mark this record is a mail list account
+    islist 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',
     PRIMARY KEY (address)
 );
 CREATE INDEX idx_alias_domain ON alias (domain);
+CREATE INDEX idx_alias_islist ON alias (islist);
 CREATE INDEX idx_alias_expired ON alias (expired);
 CREATE INDEX idx_alias_active ON alias (active);