[Piwik-svn] r470 - trunk/modules

[svnmaster at piwik.org]

Author: matt
Date: 2008-05-09 01:21:56 +0200 (Fri, 09 May 2008)
New Revision: 470

Modified:
   trunk/modules/Piwik.php
Log:
- refs #203, fixing tables field types, limit is now MEDIUMBLOB to allow up to 16M values. Previous BLOB limit of 64K was not enough.

Modified: trunk/modules/Piwik.php
===================================================================
--- trunk/modules/Piwik.php	2008-05-08 22:50:56 UTC (rev 469)
+++ trunk/modules/Piwik.php	2008-05-08 23:21:56 UTC (rev 470)
@@ -440,7 +440,7 @@
 			'logger_message' => "CREATE TABLE {$prefixTables}logger_message (
 									  idlogger_message INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
 									  timestamp TIMESTAMP NULL,
-									  message TINYTEXT NULL,
+									  message TEXT NULL,
 									  PRIMARY KEY(idlogger_message)
 									)
 			",
@@ -449,12 +449,12 @@
 									  idlogger_api_call INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
 									  class_name VARCHAR(255) NULL,
 									  method_name VARCHAR(255) NULL,
-									  parameter_names_default_values TINYTEXT NULL,
-									  parameter_values TINYTEXT NULL,
+									  parameter_names_default_values TEXT NULL,
+									  parameter_values TEXT NULL,
 									  execution_time FLOAT NULL,
 									  caller_ip BIGINT NULL,
 									  timestamp TIMESTAMP NULL,
-									  returned_value TINYTEXT NULL,
+									  returned_value TEXT NULL,
 									  PRIMARY KEY(idlogger_api_call)
 									) 
 			",
@@ -462,7 +462,7 @@
 			'logger_error' => "CREATE TABLE {$prefixTables}logger_error (
 									  idlogger_error INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
 									  timestamp TIMESTAMP NULL,
-									  message TINYTEXT NULL,
+									  message TEXT NULL,
 									  errno INTEGER UNSIGNED NULL,
 									  errline INTEGER UNSIGNED NULL,
 									  errfile VARCHAR(255) NULL,
@@ -474,7 +474,7 @@
 			'logger_exception' => "CREATE TABLE {$prefixTables}logger_exception (
 									  idlogger_exception INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
 									  timestamp TIMESTAMP NULL,
-									  message TINYTEXT NULL,
+									  message TEXT NULL,
 									  errno INTEGER UNSIGNED NULL,
 									  errline INTEGER UNSIGNED NULL,
 									  errfile VARCHAR(255) NULL,
@@ -569,7 +569,7 @@
 									  date2 DATE NULL,
 									  period TINYINT UNSIGNED NULL,
 									  ts_archived DATETIME NULL,
-									  value BLOB NULL,
+									  value MEDIUMBLOB NULL,
 									  PRIMARY KEY(idarchive, name)
 									)
 			",