Software / code / prosody
File
tools/migration/migrator.cfg.lua @ 13833:497efa2cbf2c 13.0
mod_storage_sql: Add shell command to create tables and indices (again)
This is meant as a way to diagnose e.g. issues creating indices.
It would have been nice to capture e.g. PostgreSQL notices, but LuaDBI
would need support for this first, see https://github.com/mwild1/luadbi/issues/62
| author | Kim Alvefur <zash@zash.se> |
|---|---|
| date | Wed, 09 Apr 2025 15:06:48 +0200 |
| parent | 13296:803a4ef6244d |
line wrap: on
line source
local data_path = "../../data"; local vhost = { "accounts", "account_details", "account_roles", "roster", "vcard", "private", "blocklist", "privacy", "archive-archive", "offline-archive", "pubsub_nodes-pubsub", "pep-pubsub", "cron", "smacks_h", } local muc = { "persistent", "config", "state", "muc_log-archive", "cron", }; local upload = { "uploads-archive", "upload_stats", "cron", } input { hosts = { ["example.com"] = vhost; ["conference.example.com"] = muc; ["share.example.com"] = upload; }; type = "internal"; path = data_path; } output { type = "sql"; driver = "SQLite3"; database = data_path.."/prosody.sqlite"; } --[[ input { type = "internal"; path = data_path; } output { type = "sql"; driver = "SQLite3"; database = data_path.."/prosody.sqlite"; } ]]