summaryrefslogtreecommitdiffstats
path: root/doc/example-config/dovecot-dict-sql.conf.ext
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--doc/example-config/dovecot-dict-sql.conf.ext23
1 files changed, 23 insertions, 0 deletions
diff --git a/doc/example-config/dovecot-dict-sql.conf.ext b/doc/example-config/dovecot-dict-sql.conf.ext
new file mode 100644
index 0000000..35aa107
--- /dev/null
+++ b/doc/example-config/dovecot-dict-sql.conf.ext
@@ -0,0 +1,23 @@
+# This file is commonly accessed via dict {} section in dovecot.conf
+
+#connect = host=localhost dbname=mails user=testuser password=pass
+
+# CREATE TABLE quota (
+# username varchar(100) not null,
+# bytes bigint not null default 0,
+# messages integer not null default 0,
+# primary key (username)
+# );
+
+map {
+ pattern = priv/quota/storage
+ table = quota
+ username_field = username
+ value_field = bytes
+}
+map {
+ pattern = priv/quota/messages
+ table = quota
+ username_field = username
+ value_field = messages
+}