Commits

Zhang Huangbin committed db53b4d

Sync comments in samples/mysql.*sql.

  • Participants
  • Parent commits 984527a

Comments (0)

Files changed (2)

iRedMail/samples/iredmail.mysql

     mailboxes INT(10) NOT NULL DEFAULT 0,
     -- Max mailbox quota in this domain. e.g. 1073741824 (1GB).
     maxquota BIGINT(20) NOT NULL DEFAULT 0,
+    -- Not used. Historical.
     quota BIGINT(20) NOT NULL DEFAULT 0,
     -- Per-domain transport. e.g. dovecot, smtp:[192.168.1.1]:25
     transport VARCHAR(255) NOT NULL DEFAULT 'dovecot',
     PRIMARY KEY (from_user)
 );
 
-#
-# Table `used_quota`. Used to store realtime mailbox quota in Dovecot.
-# WARNING: Works only with Dovecot 1.2+.
-#
+-- used_quota
+-- Used to store realtime mailbox quota in Dovecot.
+-- WARNING: Works only with Dovecot 1.2+.
+--
+-- Note: Don't touch this table, it will be updated by Dovecot automatically.
 CREATE TABLE IF NOT EXISTS `used_quota` (
     `username` VARCHAR(255) NOT NULL,
     `bytes` BIGINT NOT NULL DEFAULT 0,

iRedMail/samples/iredmail.pgsql

     mailboxes INT8 NOT NULL DEFAULT 0,
     -- Max mailbox quota in this domain. e.g. 1073741824 (1GB).
     maxquota INT8 NOT NULL DEFAULT 0,
+    -- Not used. Historical.
     quota INT8 NOT NULL DEFAULT 0,
     -- Per-domain transport. e.g. dovecot, smtp:[192.168.1.1]:25
     transport VARCHAR(255) NOT NULL DEFAULT 'dovecot',
     PRIMARY KEY (from_user)
 );
 
---
--- Table used_quota. Used to store realtime mailbox quota in Dovecot.
+-- used_quota
+-- Used to store realtime mailbox quota in Dovecot.
 -- WARNING: Works only with Dovecot 1.2+.
 --
+-- Note: Don't touch this table, it will be updated by Dovecot automatically.
 CREATE TABLE used_quota (
     username VARCHAR(255) NOT NULL,
     bytes INT8 NOT NULL DEFAULT 0,