|
2323
|
1 This module logs messages to a SQL database.
|
|
|
2
|
|
|
3 SQL connection options are configured in a `message_log_sql` option,
|
|
|
4 which has the same syntax as the `sql` option for
|
|
|
5 [mod_storage_sql][doc:modules:mod_storage_sql].
|
|
|
6
|
|
|
7 You will need to create the following table in the configured database:
|
|
|
8
|
|
|
9 ``` sql
|
|
|
10 CREATE TABLE `prosodyarchive` (
|
|
|
11 `host` TEXT,
|
|
|
12 `user` TEXT,
|
|
|
13 `store` TEXT,
|
|
|
14 `id` INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
|
15 `when` INTEGER,
|
|
|
16 `with` TEXT,
|
|
|
17 `resource` TEXT,
|
|
|
18 `stanza` TEXT);
|
|
|
19 ```
|
