Mercurial > prosody-modules

comparison mod_log_messages_sql/README.markdown @ 2406:a216be9b1d6e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
mod_log_messages_sql/README: Point out incompatibility with 0.10
author Kim Alvefur <zash@zash.se>
date Fri, 02 Dec 2016 20:02:04 +0100
parents 35ae59a8196d
children b74c86d137c9
comparison
equal deleted inserted replaced
2405:7bce126bf60c 2406:a216be9b1d6e
1 # Introduction
2
1 This module logs messages to a SQL database. 3 This module logs messages to a SQL database.
2 4
3 SQL connection options are configured in a `message_log_sql` option, 5 SQL connection options are configured in a `message_log_sql` option,
4 which has the same syntax as the `sql` option for 6 which has the same syntax as the `sql` option for
5 [mod_storage_sql][doc:modules:mod_storage_sql]. 7 [mod_storage_sql][doc:modules:mod_storage_sql].
8
9 # Usage
6 10
7 You will need to create the following table in the configured database: 11 You will need to create the following table in the configured database:
8 12
9 ``` sql 13 ``` sql
10 CREATE TABLE `prosodyarchive` ( 14 CREATE TABLE `prosodyarchive` (
15 `when` INTEGER, 19 `when` INTEGER,
16 `with` TEXT, 20 `with` TEXT,
17 `resource` TEXT, 21 `resource` TEXT,
18 `stanza` TEXT); 22 `stanza` TEXT);
19 ``` 23 ```
24
25 # Compatibility
26
27 Does *NOT* work with 0.10 due to a conflict with the new archiving
28 support in `mod_storage_sql`ยท