diff options
Diffstat (limited to 'core/Updates/0.4.php')
| -rw-r--r-- | core/Updates/0.4.php | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/core/Updates/0.4.php b/core/Updates/0.4.php new file mode 100644 index 0000000000..5ea7259eae --- /dev/null +++ b/core/Updates/0.4.php @@ -0,0 +1,9 @@ +<?php + +Piwik_Query('UPDATE '. Piwik::prefixTable('log_visit') .' SET location_ip=location_ip+CAST(POW(2,32) AS UNSIGNED) WHERE location_ip < 0;'); +Piwik_Query('ALTER TABLE '. Piwik::prefixTable('log_visit') .' CHANGE location_ip location_ip BIGINT UNSIGNED;'); + +Piwik_Query('UPDATE '. Piwik::prefixTable('logger_api_call') .' SET caller_ip=caller_ip+CAST(POW(2,32) AS UNSIGNED) WHERE caller_ip < 0;'); +Piwik_Query('ALTER TABLE '. Piwik::prefixTable('logger_api_call') .' CHANGE caller_ip caller_ip BIGINT UNSIGNED;'); + +Piwik_Query( "ALTER TABLE ". Piwik::prefixTable('log_visit') . " DROP config_java" ); |