# HG changeset patch
# User Kim Alvefur <zash@zash.se>
# Date 1744810507 -7200
# Node ID ce4b4c2863f3e460ddd965359326b83115176760
# Parent  ecafafec7806f428df61cc02805a69776b741e92
mod_storage_sql: Also retrieve all SQLite3 indices

Missed this in 2558be2daaca

diff -r ecafafec7806 -r ce4b4c2863f3 plugins/mod_storage_sql.lua
--- a/plugins/mod_storage_sql.lua	Tue Apr 15 21:47:13 2025 +0200
+++ b/plugins/mod_storage_sql.lua	Wed Apr 16 15:35:07 2025 +0200
@@ -879,7 +879,7 @@
 		local indices = {};
 		engine:transaction(function ()
 			if params.driver == "SQLite3" then
-				for row in engine:select [[SELECT "name" FROM "sqlite_schema" WHERE "type"='index' AND "tbl_name"='prosody' AND "name"='prosody_index';]] do
+				for row in engine:select [[SELECT "name" FROM "sqlite_schema" WHERE "type"='index' AND "tbl_name"='prosody';]] do
 					indices[row[1]] = true;
 				end
 			elseif params.driver == "PostgreSQL" then