From bf718e869892bf418051d0140d7628c69d4ee3c9 Mon Sep 17 00:00:00 2001 From: Adam Date: Sun, 30 Dec 2012 10:30:29 -0500 Subject: Evidently not specifying NOT NULL is not enough to allow null timestamps --- 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 d431ba909..76a030b2c 100644 --- a/modules/extra/m_mysql.cpp +++ b/modules/extra/m_mysql.cpp @@ -372,7 +372,7 @@ std::vector MySQLService::CreateTable(const Anope::string &table, const D if (known_cols.empty()) { Anope::string query_text = "CREATE TABLE `" + table + "` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT," - " `timestamp` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP"; + " `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP"; for (Data::Map::const_iterator it = data.data.begin(), it_end = data.data.end(); it != it_end; ++it) { known_cols.insert(it->first); -- cgit