refs #9231 Make all log_* tables fields NULLable (#10492)

34 files changed, 34 insertions, 34 deletions

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()
     {