# HG changeset patch
# User Christian Weiske <cweiske@cweiske.de>
# Date 1769544741 -3600
# Node ID caaa9ea58bec495baba24984a1bca2d38d15f401
# Parent  f1743e2c23baec7069c1330769c4eb4bddc3a7ed
mod_auth_sql: Document database table in README

diff -r f1743e2c23ba -r caaa9ea58bec mod_auth_sql/README.md
--- a/mod_auth_sql/README.md	Tue Jan 27 21:12:03 2026 +0100
+++ b/mod_auth_sql/README.md	Tue Jan 27 21:12:21 2026 +0100
@@ -32,6 +32,17 @@
 the module to change it. The default query is compatible with jabberd2
 DB schema.
 
+
+Database schema
+===============
+
+`mod_auth_sql` requires a database table `authreg` with the following columns:
+
+- `username` - First part of the JID, before the `@`
+- `realm` - Part of the JID after the `@`
+- `password` - Plain text password (insecure!)
+
+
 Compatibility
 =============