summaryrefslogtreecommitdiff
path: root/modules/extra/stats/m_chanstats.cpp
diff options
context:
space:
mode:
authorDukePyrolator <DukePyrolator@anope.org>2014-09-14 11:36:05 +0200
committerDukePyrolator <DukePyrolator@anope.org>2014-09-14 11:36:05 +0200
commit6a3f7c01b1232830f92c8ad6510071852d2abb30 (patch)
tree5a7be440814bb5a0a8e8736ed8955d9c226b2e23 /modules/extra/stats/m_chanstats.cpp
parent4c2bf72cb642fc03de3eaf2591d84cb622609cb2 (diff)
changed the engine of the chanstats table from InnoDB back to MyISAM to avoid increasing the auto_increment counter on each INSERT IGNORE. For existing tables please manually run 'ALTER TABLE anope_chanstats ENGINE=MyISAM'.
Diffstat (limited to 'modules/extra/stats/m_chanstats.cpp')
-rw-r--r--modules/extra/stats/m_chanstats.cpp2
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/extra/stats/m_chanstats.cpp b/modules/extra/stats/m_chanstats.cpp
index 4557b816f..7a2fe0486 100644
--- a/modules/extra/stats/m_chanstats.cpp
+++ b/modules/extra/stats/m_chanstats.cpp
@@ -309,7 +309,7 @@ class MChanstats : public Module
"KEY `nick` (`nick`),"
"KEY `chan_` (`chan`),"
"KEY `type` (`type`)"
- ") ENGINE=InnoDB DEFAULT CHARSET=utf8;";
+ ") ENGINE=MyISAM DEFAULT CHARSET=utf8;";
this->RunQuery(query);
}
/* There is no CREATE OR REPLACE PROCEDURE in MySQL */