Mercurial > prosody-modules

comparison mod_log_messages_sql/README.markdown @ 2323:35ae59a8196d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add some documentation stubs
author Kim Alvefur <zash@zash.se>
date Sat, 01 Oct 2016 20:34:43 +0200
parents
children a216be9b1d6e
comparison
equal deleted inserted replaced
2322:73fbfd1e820b 2323:35ae59a8196d
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 ```