Commits

Zhang Huangbin committed bac5d9b

Store realtime mailbox quota in separate SQL table in MySQL backend.

  • Participants
  • Parent commits 1b99953

Comments (0)

Files changed (3)

File iRedMail/ChangeLog

 iRedMail-0.7.4:
+    * Store realtime mailbox quota in separate SQL table in MySQL backend.
     * It now works on Ubuntu 11.10, openSUSE 12.1.
     * SPF verification is now enabled by default.
     * Add Policyd-2.0.x (code name "cluebringer") support on Ubuntu 11.10.

File iRedMail/functions/cleanup.sh

 cleanup()
 {
     cat > /etc/${PROG_NAME_LOWERCASE}-release <<EOF
-${PROG_NAME}-${PROG_VERSION}
+${PROG_VERSION}
 EOF
 
     cat <<EOF

File iRedMail/samples/iredmail.sql

     INDEX (from_user),
     INDEX (to_user)
 );
+
+#
+# Table `used_quota`. Used to store realtime mailbox quota in Dovecot.
+#
+# WARNING:
+#   - Works only with Dovecot 1.2+.
+#
+CREATE TABLE IF NOT EXISTS `used_quota` (
+    `username` VARCHAR(255) NOT NULL,
+    `bytes` BIGINT NOT NULL DEFAULT 0,
+    `messages` BIGINT NOT NULL DEFAULT 0,
+    PRIMARY KEY (`username`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;