Self-revert r80547 per CR, breaks stuff and is undesirable

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

diff --git a/maintenance/archives/patch-categorylinks.sql b/maintenance/archives/patch-categorylinks.sql
index 723c65e..02168d7 100644 (file)
--- a/maintenance/archives/patch-categorylinks.sql
+++ b/maintenance/archives/patch-categorylinks.sql
@@ -10,7 +10,7 @@ CREATE TABLE /*$wgDBprefix*/categorylinks (
   -- Name of the category.
   -- This is also the page_title of the category's description page;
   -- all such pages are in namespace 14 (NS_CATEGORY).
-  cl_to varbinary(255) NOT NULL default '',
+  cl_to varchar(255) binary NOT NULL default '',
 
   -- The title of the linking page, or an optional override
   -- to determine sort order. Sorting is by binary order, which
@@ -19,7 +19,7 @@ CREATE TABLE /*$wgDBprefix*/categorylinks (
   --
   -- Truncate so that the cl_sortkey key fits in 1000 bytes 
   -- (MyISAM 5 with server_character_set=utf8)
-  cl_sortkey varbinary(70) NOT NULL default '',
+  cl_sortkey varchar(70) binary NOT NULL default '',
   
   -- This isn't really used at present. Provided for an optional
   -- sorting method by approximate addition time.