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;