1 files changed, 27 insertions, 0 deletions
diff --git a/doc/wiki/PasswordDatabase.ExtraFields.User.txt b/doc/wiki/PasswordDatabase.ExtraFields.User.txt
new file mode 100644
index 0000000..5c191e6
--- /dev/null
+++ b/doc/wiki/PasswordDatabase.ExtraFields.User.txt
@@ -0,0 +1,27 @@
+User extra field
+================
+
+This is mostly useful in case-insensitive username lookups to get the username
+returned back using the same casing always. Otherwise depending on your
+configuration it may cause problems, such as '/var/mail/user' and
+'/var/mail/User' mailboxes created for the same user.
+
+An example 'password_query' in 'dovecot-sql.conf.ext' would be:
+
+---%<-------------------------------------------------------------------------
+password_query = \
+  SELECT concat(user, '@', domain) AS user, password \
+  FROM users \
+  WHERE user = '%n' and domain = '%d'
+---%<-------------------------------------------------------------------------
+
+You can also update "username" and "domain" fields separately:
+
+---%<-------------------------------------------------------------------------
+password_query = \
+  SELECT user AS username, domain, password \
+  FROM users \
+  WHERE user = '%n' and domain = '%d'
+---%<-------------------------------------------------------------------------
+
+(This file was created from the wiki on 2019-06-19 12:42)