diff options
author | Matthieu Aubry <mattab@users.noreply.github.com> | 2016-09-27 04:35:02 +0300 |
---|---|---|
committer | GitHub <noreply@github.com> | 2016-09-27 04:35:02 +0300 |
commit | b073766826fac25c8f3558c3d66a5741bdceb91a (patch) | |
tree | 7fbe369d840b4d1d6ee7c6941ce82bfdd2aea650 /plugins/Actions/Columns | |
parent | 60ab0f1cc3ecbc1f78bd90c2551cb9adba5d73bb (diff) |
do not make log_action.idaction (and foreign keys) BIGINT to prevent large overhead (#10569)
Partial revert https://github.com/piwik/piwik/pull/10548/files
Diffstat (limited to 'plugins/Actions/Columns')
-rw-r--r-- | plugins/Actions/Columns/EntryPageTitle.php | 2 | ||||
-rw-r--r-- | plugins/Actions/Columns/EntryPageUrl.php | 2 | ||||
-rw-r--r-- | plugins/Actions/Columns/ExitPageTitle.php | 2 | ||||
-rw-r--r-- | plugins/Actions/Columns/ExitPageUrl.php | 2 | ||||
-rw-r--r-- | plugins/Actions/Columns/PageTitle.php | 2 | ||||
-rw-r--r-- | plugins/Actions/Columns/PageUrl.php | 2 |
6 files changed, 6 insertions, 6 deletions
diff --git a/plugins/Actions/Columns/EntryPageTitle.php b/plugins/Actions/Columns/EntryPageTitle.php index c23568cc0a..30445f9549 100644 --- a/plugins/Actions/Columns/EntryPageTitle.php +++ b/plugins/Actions/Columns/EntryPageTitle.php @@ -18,7 +18,7 @@ use Piwik\Tracker\Visitor; class EntryPageTitle extends VisitDimension { protected $columnName = 'visit_entry_idaction_name'; - protected $columnType = 'BIGINT(10) UNSIGNED NULL'; + protected $columnType = 'INTEGER(10) UNSIGNED NULL'; protected function configureSegments() { diff --git a/plugins/Actions/Columns/EntryPageUrl.php b/plugins/Actions/Columns/EntryPageUrl.php index 5ff80f43f5..7f3ef19ad1 100644 --- a/plugins/Actions/Columns/EntryPageUrl.php +++ b/plugins/Actions/Columns/EntryPageUrl.php @@ -18,7 +18,7 @@ use Piwik\Tracker\Visitor; class EntryPageUrl extends VisitDimension { protected $columnName = 'visit_entry_idaction_url'; - protected $columnType = 'BIGINT(10) UNSIGNED NULL'; + protected $columnType = 'INTEGER(10) UNSIGNED NULL'; protected function configureSegments() { diff --git a/plugins/Actions/Columns/ExitPageTitle.php b/plugins/Actions/Columns/ExitPageTitle.php index 4d238b51bb..97428d9ad9 100644 --- a/plugins/Actions/Columns/ExitPageTitle.php +++ b/plugins/Actions/Columns/ExitPageTitle.php @@ -18,7 +18,7 @@ use Piwik\Tracker\Visitor; class ExitPageTitle extends VisitDimension { protected $columnName = 'visit_exit_idaction_name'; - protected $columnType = 'BIGINT(10) UNSIGNED NULL'; + protected $columnType = 'INTEGER(10) UNSIGNED NULL'; protected function configureSegments() { diff --git a/plugins/Actions/Columns/ExitPageUrl.php b/plugins/Actions/Columns/ExitPageUrl.php index 36c8a31458..094719bb75 100644 --- a/plugins/Actions/Columns/ExitPageUrl.php +++ b/plugins/Actions/Columns/ExitPageUrl.php @@ -18,7 +18,7 @@ use Piwik\Tracker\Visitor; class ExitPageUrl extends VisitDimension { protected $columnName = 'visit_exit_idaction_url'; - protected $columnType = 'BIGINT(10) UNSIGNED NULL DEFAULT 0'; + protected $columnType = 'INTEGER(10) UNSIGNED NULL DEFAULT 0'; protected function configureSegments() { diff --git a/plugins/Actions/Columns/PageTitle.php b/plugins/Actions/Columns/PageTitle.php index 7590a456c9..6517bede92 100644 --- a/plugins/Actions/Columns/PageTitle.php +++ b/plugins/Actions/Columns/PageTitle.php @@ -15,7 +15,7 @@ use Piwik\Plugins\Actions\Segment; class PageTitle extends ActionDimension { protected $columnName = 'idaction_name'; - protected $columnType = 'BIGINT(10) UNSIGNED'; + protected $columnType = 'INTEGER(10) UNSIGNED'; protected function configureSegments() { diff --git a/plugins/Actions/Columns/PageUrl.php b/plugins/Actions/Columns/PageUrl.php index b33d0cfae8..1f9a7035e5 100644 --- a/plugins/Actions/Columns/PageUrl.php +++ b/plugins/Actions/Columns/PageUrl.php @@ -15,7 +15,7 @@ use Piwik\Plugins\Actions\Segment; class PageUrl extends ActionDimension { protected $columnName = 'idaction_url'; - protected $columnType = 'BIGINT(10) UNSIGNED DEFAULT NULL'; + protected $columnType = 'INTEGER(10) UNSIGNED DEFAULT NULL'; protected function configureSegments() { |