Fix line endings; add line-ending marker property; add final newline.

[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..79bb53b 100644 (file)
--- a/maintenance/archives/patch-logging.sql
+++ b/maintenance/archives/patch-logging.sql
@@ -16,16 +16,21 @@ CREATE TABLE /*$wgDBprefix*/logging (
   
   -- 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 default '',
+
   KEY type_time (log_type, log_timestamp),
   KEY user_time (log_user, log_timestamp),
   KEY page_time (log_namespace, log_title, log_timestamp)
-);
+
+) TYPE=InnoDB;
+
 
 -- Change from unsigned to signed so we can store special pages
 ALTER TABLE recentchanges