Source

iredmail / iRedMail / samples / used_quota.sql

Full commit
#
# Table `used_quota`. Used for Dovecot to store realtime quota.
#
# WARNING:
#   - Works only with Dovecot 1.2+.
#   - This table is not required in MySQL backend.
#
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;