From 8bb83f6b1a667121ba68f5c191b9f953af6f22bd Mon Sep 17 00:00:00 2001
From: Sadie Powell <sadie@witchery.services>
Date: Thu, 16 May 2024 17:13:47 +0100
Subject: Explicitly specify ROW_FORMAT=DYNAMIC when creating tables.

Resolves the issues some people were having with extremely wide rows.
---
 modules/extra/m_mysql.cpp | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'modules/extra/m_mysql.cpp')

diff --git a/modules/extra/m_mysql.cpp b/modules/extra/m_mysql.cpp
index 82e2873b8..bb9ee8444 100644
--- a/modules/extra/m_mysql.cpp
+++ b/modules/extra/m_mysql.cpp
@@ -404,7 +404,7 @@ std::vector<Query> MySQLService::CreateTable(const Anope::string &table, const D
 			else
 				query_text += "text";
 		}
-		query_text += ", PRIMARY KEY (`id`), KEY `timestamp_idx` (`timestamp`))";
+		query_text += ", PRIMARY KEY (`id`), KEY `timestamp_idx` (`timestamp`)) ROW_FORMAT=DYNAMIC";
 		queries.push_back(query_text);
 	}
 	else
-- 
cgit