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";
}

]]