From 77746d08c5d6e469632221a74da4530beb20d678 Mon Sep 17 00:00:00 2001 From: Thomas Steur Date: Tue, 20 Sep 2016 16:14:22 +1200 Subject: refs #9231 Make all log_* tables fields NULLable (#10492) --- plugins/Actions/Columns/EntryPageTitle.php | 2 +- plugins/Actions/Columns/EntryPageUrl.php | 2 +- plugins/Actions/Columns/ExitPageTitle.php | 2 +- plugins/Actions/Columns/TimeSpentRefAction.php | 2 +- plugins/Actions/Columns/VisitTotalActions.php | 2 +- plugins/Actions/Columns/VisitTotalSearches.php | 2 +- plugins/CoreHome/Columns/VisitGoalBuyer.php | 2 +- plugins/CoreHome/Columns/VisitGoalConverted.php | 2 +- plugins/CoreHome/Columns/VisitorDaysSinceFirst.php | 2 +- plugins/CoreHome/Columns/VisitorDaysSinceOrder.php | 2 +- plugins/CoreHome/Columns/VisitorReturning.php | 2 +- plugins/DevicePlugins/Columns/PluginCookie.php | 2 +- plugins/DevicePlugins/Columns/PluginDirector.php | 2 +- plugins/DevicePlugins/Columns/PluginFlash.php | 2 +- plugins/DevicePlugins/Columns/PluginGears.php | 2 +- plugins/DevicePlugins/Columns/PluginJava.php | 2 +- plugins/DevicePlugins/Columns/PluginPdf.php | 2 +- plugins/DevicePlugins/Columns/PluginQuickTime.php | 2 +- plugins/DevicePlugins/Columns/PluginRealPlayer.php | 2 +- plugins/DevicePlugins/Columns/PluginSilverlight.php | 2 +- plugins/DevicePlugins/Columns/PluginWindowsMedia.php | 2 +- plugins/DevicesDetection/Columns/BrowserEngine.php | 2 +- plugins/DevicesDetection/Columns/BrowserName.php | 2 +- plugins/DevicesDetection/Columns/BrowserVersion.php | 2 +- plugins/DevicesDetection/Columns/Os.php | 2 +- plugins/Events/Columns/TotalEvents.php | 2 +- plugins/ExampleTracker/Columns/ExampleConversionDimension.php | 2 +- plugins/ExampleTracker/Columns/ExampleVisitDimension.php | 2 +- plugins/Referrers/Columns/ReferrerUrl.php | 2 +- plugins/Resolution/Columns/Resolution.php | 2 +- plugins/UserCountry/Columns/Country.php | 2 +- plugins/UserLanguage/Columns/Language.php | 2 +- plugins/VisitTime/Columns/LocalTime.php | 2 +- plugins/VisitorInterest/Columns/VisitsByDaysSinceLastVisit.php | 2 +- 34 files changed, 34 insertions(+), 34 deletions(-) (limited to 'plugins') diff --git a/plugins/Actions/Columns/EntryPageTitle.php b/plugins/Actions/Columns/EntryPageTitle.php index 0da5b2b4ce..72e80f8783 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 = 'INTEGER(11) UNSIGNED NOT NULL'; + protected $columnType = 'INTEGER(11) UNSIGNED NULL'; protected function configureSegments() { diff --git a/plugins/Actions/Columns/EntryPageUrl.php b/plugins/Actions/Columns/EntryPageUrl.php index 7256105b57..8adf0ab2f6 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 = 'INTEGER(11) UNSIGNED NOT NULL'; + protected $columnType = 'INTEGER(11) UNSIGNED NULL'; protected function configureSegments() { diff --git a/plugins/Actions/Columns/ExitPageTitle.php b/plugins/Actions/Columns/ExitPageTitle.php index 8078461da2..766897bd32 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 = 'INTEGER(11) UNSIGNED NOT NULL'; + protected $columnType = 'INTEGER(11) UNSIGNED NULL'; protected function configureSegments() { diff --git a/plugins/Actions/Columns/TimeSpentRefAction.php b/plugins/Actions/Columns/TimeSpentRefAction.php index 1154fd3989..a51cac9d59 100644 --- a/plugins/Actions/Columns/TimeSpentRefAction.php +++ b/plugins/Actions/Columns/TimeSpentRefAction.php @@ -16,7 +16,7 @@ use Piwik\Tracker\Visitor; class TimeSpentRefAction extends ActionDimension { protected $columnName = 'time_spent_ref_action'; - protected $columnType = 'INTEGER(10) UNSIGNED NOT NULL'; + protected $columnType = 'INTEGER(10) UNSIGNED NULL'; public function onNewAction(Request $request, Visitor $visitor, Action $action) { diff --git a/plugins/Actions/Columns/VisitTotalActions.php b/plugins/Actions/Columns/VisitTotalActions.php index 58ac9fdf9c..914f18ba8e 100644 --- a/plugins/Actions/Columns/VisitTotalActions.php +++ b/plugins/Actions/Columns/VisitTotalActions.php @@ -18,7 +18,7 @@ use Piwik\Tracker\Visitor; class VisitTotalActions extends VisitDimension { protected $columnName = 'visit_total_actions'; - protected $columnType = 'INT(11) UNSIGNED NOT NULL'; + protected $columnType = 'INT(11) UNSIGNED NULL'; protected function configureSegments() { diff --git a/plugins/Actions/Columns/VisitTotalSearches.php b/plugins/Actions/Columns/VisitTotalSearches.php index 1b8fba9ffd..e3ebb83247 100644 --- a/plugins/Actions/Columns/VisitTotalSearches.php +++ b/plugins/Actions/Columns/VisitTotalSearches.php @@ -18,7 +18,7 @@ use Piwik\Tracker\Visitor; class VisitTotalSearches extends VisitDimension { protected $columnName = 'visit_total_searches'; - protected $columnType = 'SMALLINT(5) UNSIGNED NOT NULL'; + protected $columnType = 'SMALLINT(5) UNSIGNED NULL'; protected function configureSegments() { diff --git a/plugins/CoreHome/Columns/VisitGoalBuyer.php b/plugins/CoreHome/Columns/VisitGoalBuyer.php index 21c8b06963..779d5fd5be 100644 --- a/plugins/CoreHome/Columns/VisitGoalBuyer.php +++ b/plugins/CoreHome/Columns/VisitGoalBuyer.php @@ -32,7 +32,7 @@ class VisitGoalBuyer extends VisitDimension ); protected $columnName = 'visit_goal_buyer'; - protected $columnType = 'TINYINT(1) NOT NULL'; + protected $columnType = 'TINYINT(1) NULL'; protected function configureSegments() { diff --git a/plugins/CoreHome/Columns/VisitGoalConverted.php b/plugins/CoreHome/Columns/VisitGoalConverted.php index a0d735dd96..1c0cc40e65 100644 --- a/plugins/CoreHome/Columns/VisitGoalConverted.php +++ b/plugins/CoreHome/Columns/VisitGoalConverted.php @@ -17,7 +17,7 @@ use Piwik\Tracker\Visitor; class VisitGoalConverted extends VisitDimension { protected $columnName = 'visit_goal_converted'; - protected $columnType = 'TINYINT(1) NOT NULL'; + protected $columnType = 'TINYINT(1) NULL'; protected function configureSegments() { diff --git a/plugins/CoreHome/Columns/VisitorDaysSinceFirst.php b/plugins/CoreHome/Columns/VisitorDaysSinceFirst.php index 683e5d5b3c..3445f21f59 100644 --- a/plugins/CoreHome/Columns/VisitorDaysSinceFirst.php +++ b/plugins/CoreHome/Columns/VisitorDaysSinceFirst.php @@ -17,7 +17,7 @@ use Piwik\Tracker\Visitor; class VisitorDaysSinceFirst extends VisitDimension { protected $columnName = 'visitor_days_since_first'; - protected $columnType = 'SMALLINT(5) UNSIGNED NOT NULL'; + protected $columnType = 'SMALLINT(5) UNSIGNED NULL'; protected function configureSegments() { diff --git a/plugins/CoreHome/Columns/VisitorDaysSinceOrder.php b/plugins/CoreHome/Columns/VisitorDaysSinceOrder.php index f0345069f0..c126b5957c 100644 --- a/plugins/CoreHome/Columns/VisitorDaysSinceOrder.php +++ b/plugins/CoreHome/Columns/VisitorDaysSinceOrder.php @@ -17,7 +17,7 @@ use Piwik\Tracker\Visitor; class VisitorDaysSinceOrder extends VisitDimension { protected $columnName = 'visitor_days_since_order'; - protected $columnType = 'SMALLINT(5) UNSIGNED NOT NULL'; + protected $columnType = 'SMALLINT(5) UNSIGNED NULL'; protected function configureSegments() { diff --git a/plugins/CoreHome/Columns/VisitorReturning.php b/plugins/CoreHome/Columns/VisitorReturning.php index 3a7268052e..ca1ef11652 100644 --- a/plugins/CoreHome/Columns/VisitorReturning.php +++ b/plugins/CoreHome/Columns/VisitorReturning.php @@ -22,7 +22,7 @@ class VisitorReturning extends VisitDimension const IS_NEW = 0; protected $columnName = 'visitor_returning'; - protected $columnType = 'TINYINT(1) NOT NULL'; + protected $columnType = 'TINYINT(1) NULL'; protected $conversionField = true; protected function configureSegments() diff --git a/plugins/DevicePlugins/Columns/PluginCookie.php b/plugins/DevicePlugins/Columns/PluginCookie.php index 935bd24333..f5c88a1dc2 100644 --- a/plugins/DevicePlugins/Columns/PluginCookie.php +++ b/plugins/DevicePlugins/Columns/PluginCookie.php @@ -17,7 +17,7 @@ use Piwik\Tracker\Action; class PluginCookie extends VisitDimension { protected $columnName = 'config_cookie'; - protected $columnType = 'TINYINT(1) NOT NULL'; + protected $columnType = 'TINYINT(1) NULL'; /** * @param Request $request diff --git a/plugins/DevicePlugins/Columns/PluginDirector.php b/plugins/DevicePlugins/Columns/PluginDirector.php index 4e5b82d2fd..e1a60bb92a 100644 --- a/plugins/DevicePlugins/Columns/PluginDirector.php +++ b/plugins/DevicePlugins/Columns/PluginDirector.php @@ -17,7 +17,7 @@ use Piwik\Tracker\Action; class PluginDirector extends VisitDimension { protected $columnName = 'config_director'; - protected $columnType = 'TINYINT(1) NOT NULL'; + protected $columnType = 'TINYINT(1) NULL'; /** * @param Request $request diff --git a/plugins/DevicePlugins/Columns/PluginFlash.php b/plugins/DevicePlugins/Columns/PluginFlash.php index 70d9bbfe83..448a02a9b1 100644 --- a/plugins/DevicePlugins/Columns/PluginFlash.php +++ b/plugins/DevicePlugins/Columns/PluginFlash.php @@ -17,7 +17,7 @@ use Piwik\Tracker\Action; class PluginFlash extends VisitDimension { protected $columnName = 'config_flash'; - protected $columnType = 'TINYINT(1) NOT NULL'; + protected $columnType = 'TINYINT(1) NULL'; /** * @param Request $request diff --git a/plugins/DevicePlugins/Columns/PluginGears.php b/plugins/DevicePlugins/Columns/PluginGears.php index 8d0584a937..f6e2e0aa61 100644 --- a/plugins/DevicePlugins/Columns/PluginGears.php +++ b/plugins/DevicePlugins/Columns/PluginGears.php @@ -17,7 +17,7 @@ use Piwik\Tracker\Action; class PluginGears extends VisitDimension { protected $columnName = 'config_gears'; - protected $columnType = 'TINYINT(1) NOT NULL'; + protected $columnType = 'TINYINT(1) NULL'; /** * @param Request $request diff --git a/plugins/DevicePlugins/Columns/PluginJava.php b/plugins/DevicePlugins/Columns/PluginJava.php index 9b316fda83..351328ce17 100644 --- a/plugins/DevicePlugins/Columns/PluginJava.php +++ b/plugins/DevicePlugins/Columns/PluginJava.php @@ -17,7 +17,7 @@ use Piwik\Tracker\Action; class PluginJava extends VisitDimension { protected $columnName = 'config_java'; - protected $columnType = 'TINYINT(1) NOT NULL'; + protected $columnType = 'TINYINT(1) NULL'; /** * @param Request $request diff --git a/plugins/DevicePlugins/Columns/PluginPdf.php b/plugins/DevicePlugins/Columns/PluginPdf.php index 4f637e6d79..1a9a22dc21 100644 --- a/plugins/DevicePlugins/Columns/PluginPdf.php +++ b/plugins/DevicePlugins/Columns/PluginPdf.php @@ -17,7 +17,7 @@ use Piwik\Tracker\Action; class PluginPdf extends VisitDimension { protected $columnName = 'config_pdf'; - protected $columnType = 'TINYINT(1) NOT NULL'; + protected $columnType = 'TINYINT(1) NULL'; /** * @param Request $request diff --git a/plugins/DevicePlugins/Columns/PluginQuickTime.php b/plugins/DevicePlugins/Columns/PluginQuickTime.php index 9f74f0191d..8626adbfb2 100644 --- a/plugins/DevicePlugins/Columns/PluginQuickTime.php +++ b/plugins/DevicePlugins/Columns/PluginQuickTime.php @@ -17,7 +17,7 @@ use Piwik\Tracker\Action; class PluginQuickTime extends VisitDimension { protected $columnName = 'config_quicktime'; - protected $columnType = 'TINYINT(1) NOT NULL'; + protected $columnType = 'TINYINT(1) NULL'; /** * @param Request $request diff --git a/plugins/DevicePlugins/Columns/PluginRealPlayer.php b/plugins/DevicePlugins/Columns/PluginRealPlayer.php index 902bac086b..baeadb4b4c 100644 --- a/plugins/DevicePlugins/Columns/PluginRealPlayer.php +++ b/plugins/DevicePlugins/Columns/PluginRealPlayer.php @@ -17,7 +17,7 @@ use Piwik\Tracker\Action; class PluginRealPlayer extends VisitDimension { protected $columnName = 'config_realplayer'; - protected $columnType = 'TINYINT(1) NOT NULL'; + protected $columnType = 'TINYINT(1) NULL'; /** * @param Request $request diff --git a/plugins/DevicePlugins/Columns/PluginSilverlight.php b/plugins/DevicePlugins/Columns/PluginSilverlight.php index a9381a35ee..e3b62cd409 100644 --- a/plugins/DevicePlugins/Columns/PluginSilverlight.php +++ b/plugins/DevicePlugins/Columns/PluginSilverlight.php @@ -17,7 +17,7 @@ use Piwik\Tracker\Action; class PluginSilverlight extends VisitDimension { protected $columnName = 'config_silverlight'; - protected $columnType = 'TINYINT(1) NOT NULL'; + protected $columnType = 'TINYINT(1) NULL'; /** * @param Request $request diff --git a/plugins/DevicePlugins/Columns/PluginWindowsMedia.php b/plugins/DevicePlugins/Columns/PluginWindowsMedia.php index 3ae32f8ab3..569133ba04 100644 --- a/plugins/DevicePlugins/Columns/PluginWindowsMedia.php +++ b/plugins/DevicePlugins/Columns/PluginWindowsMedia.php @@ -17,7 +17,7 @@ use Piwik\Tracker\Action; class PluginWindowsMedia extends VisitDimension { protected $columnName = 'config_windowsmedia'; - protected $columnType = 'TINYINT(1) NOT NULL'; + protected $columnType = 'TINYINT(1) NULL'; /** * @param Request $request diff --git a/plugins/DevicesDetection/Columns/BrowserEngine.php b/plugins/DevicesDetection/Columns/BrowserEngine.php index 4348a1a117..1639ec59fe 100644 --- a/plugins/DevicesDetection/Columns/BrowserEngine.php +++ b/plugins/DevicesDetection/Columns/BrowserEngine.php @@ -17,7 +17,7 @@ use Piwik\Tracker\Action; class BrowserEngine extends Base { protected $columnName = 'config_browser_engine'; - protected $columnType = 'VARCHAR(10) NOT NULL'; + protected $columnType = 'VARCHAR(10) NULL'; protected function configureSegments() { diff --git a/plugins/DevicesDetection/Columns/BrowserName.php b/plugins/DevicesDetection/Columns/BrowserName.php index f29ee7da61..b60b87f5af 100644 --- a/plugins/DevicesDetection/Columns/BrowserName.php +++ b/plugins/DevicesDetection/Columns/BrowserName.php @@ -17,7 +17,7 @@ use Piwik\Tracker\Action; class BrowserName extends Base { protected $columnName = 'config_browser_name'; - protected $columnType = 'VARCHAR(10) NOT NULL'; + protected $columnType = 'VARCHAR(10) NULL'; protected function configureSegments() { diff --git a/plugins/DevicesDetection/Columns/BrowserVersion.php b/plugins/DevicesDetection/Columns/BrowserVersion.php index 14e3221a0f..aabca4e9fb 100644 --- a/plugins/DevicesDetection/Columns/BrowserVersion.php +++ b/plugins/DevicesDetection/Columns/BrowserVersion.php @@ -17,7 +17,7 @@ use Piwik\Tracker\Action; class BrowserVersion extends Base { protected $columnName = 'config_browser_version'; - protected $columnType = 'VARCHAR(20) NOT NULL'; + protected $columnType = 'VARCHAR(20) NULL'; protected function configureSegments() { diff --git a/plugins/DevicesDetection/Columns/Os.php b/plugins/DevicesDetection/Columns/Os.php index f8c66bee3f..a787340dc2 100644 --- a/plugins/DevicesDetection/Columns/Os.php +++ b/plugins/DevicesDetection/Columns/Os.php @@ -18,7 +18,7 @@ use Piwik\Tracker\Action; class Os extends Base { protected $columnName = 'config_os'; - protected $columnType = 'CHAR(3) NOT NULL'; + protected $columnType = 'CHAR(3) NULL'; protected function configureSegments() { diff --git a/plugins/Events/Columns/TotalEvents.php b/plugins/Events/Columns/TotalEvents.php index e3a81f4f3e..410144e3a9 100644 --- a/plugins/Events/Columns/TotalEvents.php +++ b/plugins/Events/Columns/TotalEvents.php @@ -18,7 +18,7 @@ use Piwik\Tracker\Visitor; class TotalEvents extends VisitDimension { protected $columnName = 'visit_total_events'; - protected $columnType = 'INT(11) UNSIGNED NOT NULL'; + protected $columnType = 'INT(11) UNSIGNED NULL'; protected function configureSegments() { diff --git a/plugins/ExampleTracker/Columns/ExampleConversionDimension.php b/plugins/ExampleTracker/Columns/ExampleConversionDimension.php index ea780abbd3..6b6bf3d51f 100644 --- a/plugins/ExampleTracker/Columns/ExampleConversionDimension.php +++ b/plugins/ExampleTracker/Columns/ExampleConversionDimension.php @@ -40,7 +40,7 @@ class ExampleConversionDimension extends ConversionDimension * perform an update which can sometimes take a long time so be careful when choosing the correct column type. * @var string */ - protected $columnType = 'INTEGER(11) DEFAULT 0 NOT NULL'; + protected $columnType = 'INTEGER(11) DEFAULT 0 NULL'; /** * The name of the dimension which will be visible for instance in the UI of a related report and in the mobile app. diff --git a/plugins/ExampleTracker/Columns/ExampleVisitDimension.php b/plugins/ExampleTracker/Columns/ExampleVisitDimension.php index f0d28b66da..15d32592a6 100644 --- a/plugins/ExampleTracker/Columns/ExampleVisitDimension.php +++ b/plugins/ExampleTracker/Columns/ExampleVisitDimension.php @@ -38,7 +38,7 @@ class ExampleVisitDimension extends VisitDimension * perform an update which can sometimes take a long time so be careful when choosing the correct column type. * @var string */ - protected $columnType = 'INTEGER(11) DEFAULT 0 NOT NULL'; + protected $columnType = 'INTEGER(11) DEFAULT 0 NULL'; /** * The name of the dimension which will be visible for instance in the UI of a related report and in the mobile app. diff --git a/plugins/Referrers/Columns/ReferrerUrl.php b/plugins/Referrers/Columns/ReferrerUrl.php index ab523740a7..e70f75c9ef 100644 --- a/plugins/Referrers/Columns/ReferrerUrl.php +++ b/plugins/Referrers/Columns/ReferrerUrl.php @@ -16,7 +16,7 @@ use Piwik\Tracker\Action; class ReferrerUrl extends Base { protected $columnName = 'referer_url'; - protected $columnType = 'TEXT NOT NULL'; + protected $columnType = 'TEXT NULL'; protected function configureSegments() { diff --git a/plugins/Resolution/Columns/Resolution.php b/plugins/Resolution/Columns/Resolution.php index e0f2611e07..53a5f8cc4d 100644 --- a/plugins/Resolution/Columns/Resolution.php +++ b/plugins/Resolution/Columns/Resolution.php @@ -18,7 +18,7 @@ use Piwik\Tracker\Visitor; class Resolution extends VisitDimension { protected $columnName = 'config_resolution'; - protected $columnType = 'VARCHAR(18) NOT NULL'; + protected $columnType = 'VARCHAR(18) NULL'; protected function configureSegments() { diff --git a/plugins/UserCountry/Columns/Country.php b/plugins/UserCountry/Columns/Country.php index 841c88f16b..9ce817ae9d 100644 --- a/plugins/UserCountry/Columns/Country.php +++ b/plugins/UserCountry/Columns/Country.php @@ -26,7 +26,7 @@ use Piwik\Tracker\Request; class Country extends Base { protected $columnName = 'location_country'; - protected $columnType = 'CHAR(3) NOT NULL'; + protected $columnType = 'CHAR(3) NULL'; protected function configureSegments() { diff --git a/plugins/UserLanguage/Columns/Language.php b/plugins/UserLanguage/Columns/Language.php index c51a3372ab..fa665ed998 100644 --- a/plugins/UserLanguage/Columns/Language.php +++ b/plugins/UserLanguage/Columns/Language.php @@ -18,7 +18,7 @@ use Piwik\Tracker\Visitor; class Language extends VisitDimension { protected $columnName = 'location_browser_lang'; - protected $columnType = 'VARCHAR(20) NOT NULL'; + protected $columnType = 'VARCHAR(20) NULL'; public function getName() { diff --git a/plugins/VisitTime/Columns/LocalTime.php b/plugins/VisitTime/Columns/LocalTime.php index abe27d777b..a37367cd6e 100644 --- a/plugins/VisitTime/Columns/LocalTime.php +++ b/plugins/VisitTime/Columns/LocalTime.php @@ -18,7 +18,7 @@ use Piwik\Tracker\Visitor; class LocalTime extends VisitDimension { protected $columnName = 'visitor_localtime'; - protected $columnType = 'TIME NOT NULL'; + protected $columnType = 'TIME NULL'; protected function configureSegments() { diff --git a/plugins/VisitorInterest/Columns/VisitsByDaysSinceLastVisit.php b/plugins/VisitorInterest/Columns/VisitsByDaysSinceLastVisit.php index dfebfee708..b83cc9d72a 100644 --- a/plugins/VisitorInterest/Columns/VisitsByDaysSinceLastVisit.php +++ b/plugins/VisitorInterest/Columns/VisitsByDaysSinceLastVisit.php @@ -18,7 +18,7 @@ use Piwik\Tracker\Visitor; class VisitsByDaysSinceLastVisit extends VisitDimension { protected $columnName = 'visitor_days_since_last'; - protected $columnType = 'SMALLINT(5) UNSIGNED NOT NULL'; + protected $columnType = 'SMALLINT(5) UNSIGNED NULL'; protected function configureSegments() { -- cgit v1.2.3