diff options
author | Matthieu Aubry <mattab@users.noreply.github.com> | 2016-09-26 03:03:59 +0300 |
---|---|---|
committer | GitHub <noreply@github.com> | 2016-09-26 03:03:59 +0300 |
commit | cdc50dc38924f396dff8d50ef019c24f2a7b7bfd (patch) | |
tree | bf81c250be06b2c390029f668509f30cf622d89d /plugins/Events | |
parent | 04d0c74e08bb4d9575f50f79dbb38c403b327570 (diff) |
On very high traffic Piwik servers, prevent integer overflow by making auto_increment fields BIGINT UNSIGNED (#10548)
* Change Latitude and Longitude data types to DECIMAL instead of FLOAT
* Add system test that forces an integer overflow, currently failing as expected
* Make all overflow-able fields BIGINT UNSIGNED
* Make overflow-able fields BIGINT UNSIGNED
* These fields were not covered by the new SimulateAutoIncrementIntegerOverflow test
* fix comment
* Make it clear that id* fields are UNSIGNED when installing Piwik
* BIGINT(10) for consistency
* Update core fields to BIGINT
* UI tests: New fields to be updated to bigint
Diffstat (limited to 'plugins/Events')
-rw-r--r-- | plugins/Events/Columns/EventAction.php | 2 | ||||
-rw-r--r-- | plugins/Events/Columns/EventCategory.php | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/plugins/Events/Columns/EventAction.php b/plugins/Events/Columns/EventAction.php index 79b3b5867b..9db6d1de0b 100644 --- a/plugins/Events/Columns/EventAction.php +++ b/plugins/Events/Columns/EventAction.php @@ -18,7 +18,7 @@ use Piwik\Tracker\Request; class EventAction extends ActionDimension { protected $columnName = 'idaction_event_action'; - protected $columnType = 'INTEGER(10) UNSIGNED DEFAULT NULL'; + protected $columnType = 'BIGINT(10) UNSIGNED DEFAULT NULL'; protected function configureSegments() { diff --git a/plugins/Events/Columns/EventCategory.php b/plugins/Events/Columns/EventCategory.php index 7c6b5fd02a..2a0477d221 100644 --- a/plugins/Events/Columns/EventCategory.php +++ b/plugins/Events/Columns/EventCategory.php @@ -18,7 +18,7 @@ use Piwik\Tracker\Request; class EventCategory extends ActionDimension { protected $columnName = 'idaction_event_category'; - protected $columnType = 'INTEGER(10) UNSIGNED DEFAULT NULL'; + protected $columnType = 'BIGINT(10) UNSIGNED DEFAULT NULL'; protected function configureSegments() { |