Source

iredmail / iRedMail / samples / iredmail.sql

Diff from to

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;