# Sample configuration file for mailbox-count.
#
-# The name of the database to which we should connect.
+# The name of the database (or file, if SQLite) to which we should connect.
#
# Default: The name of the current user (Postgres only)
#
# detail = true
-# Hostname where the database is located.
+# SQL query used to produce the detail report. This should return the
+# set of all (domain, username) pairs. See the default value for an
+# example.
+#
+# Default: "SELECT domain,username FROM mailbox ORDER BY domain;"
+#
+# detail_query = "SELECT domain,username FROM mailbox LIMIT 1000;"
+
+
+# Hostname where the database is located (Postgres-only).
#
# Default: None, a UNIX domain socket connection is attempted (Postgres only)
#
# host = "localhost"
-# Password used to connect to the database.
+# Password used to connect to the database (Postgres-only).
#
# Default: None (assumes passwordless authentication)
#
# password = "hunter2"
-# Port number used to connect to the database.
+# Port number used to connect to the database (Postgres-only).
#
# Default: None, a UNIX domain socket connection is attempted (Postgres only)
#
# port = 5432
-# Username used to connect to the database.
+# SQL query used to produce the summary report. This should return
+# (domain, user count) pairs. See the default value for an
+# example.
+#
+# Default: "SELECT domain,COUNT(username) FROM mailbox GROUP BY domain ORDER BY domain;"
+#
+# summary_query = "SELECT domain,COUNT(username) as cnt GROUP BY domain ORDER by cnt;"
+
+
+# Username used to connect to the database (Postgres-only).
#
# Default: The current user
#