Update LanguageTrTest::testDottedAndDotlessI for PHP 7.3

[lhc/web/wiklou.git] / maintenance / archives / patch-logging.sql

diff --git a/maintenance/archives/patch-logging.sql b/maintenance/archives/patch-logging.sql
index 44d6d9e..79df0dd 100644 (file)
--- a/maintenance/archives/patch-logging.sql
+++ b/maintenance/archives/patch-logging.sql
@@ -5,27 +5,32 @@ CREATE TABLE /*$wgDBprefix*/logging (
   -- Symbolic keys for the general log type and the action type
   -- within the log. The output format will be controlled by the
   -- action field, but only the type controls categorization.
-  log_type char(10) NOT NULL default '',
-  log_action char(10) NOT NULL default '',
-  
+  log_type varbinary(10) NOT NULL default '',
+  log_action varbinary(10) NOT NULL default '',
+
   -- Timestamp. Duh.
-  log_timestamp char(14) NOT NULL default '19700101000000',
-  
+  log_timestamp binary(14) NOT NULL default '19700101000000',
+
   -- The user who performed this action; key to user_id
   log_user int unsigned NOT NULL default 0,
-  
+
   -- Key to the page affected. Where a user is the target,
   -- this will point to the user page.
-  log_namespace tinyint unsigned NOT NULL default 0,
-  log_title varchar(255) NOT NULL default '',
-  
+  log_namespace int NOT NULL default 0,
+  log_title varchar(255) binary NOT NULL default '',
+
   -- Freeform text. Interpreted as edit history comments.
   log_comment varchar(255) NOT NULL default '',
-  
+
+  -- LF separated list of miscellaneous parameters
+  log_params blob NOT NULL,
+
   KEY type_time (log_type, log_timestamp),
   KEY user_time (log_user, log_timestamp),
   KEY page_time (log_namespace, log_title, log_timestamp)
-);
+
+) /*$wgDBTableOptions*/;
+
 
 -- Change from unsigned to signed so we can store special pages
 ALTER TABLE recentchanges