X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Farchives%2Fpatch-categorylinks.sql;h=0af0cf915c1ccfffe0537d1ed76380ebd38fbe73;hb=c00c34f288c13b5360e30c694d929e4c65e3a3a1;hp=02168d7f254ceb65b0193a8e6b89c796b7405dab;hpb=051e1e76249de4b51cebdc795fe37976141279dd;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/archives/patch-categorylinks.sql b/maintenance/archives/patch-categorylinks.sql index 02168d7f25..0af0cf915c 100644 --- a/maintenance/archives/patch-categorylinks.sql +++ b/maintenance/archives/patch-categorylinks.sql @@ -6,7 +6,7 @@ CREATE TABLE /*$wgDBprefix*/categorylinks ( -- Key to page_id of the page defined as a category member. cl_from int unsigned NOT NULL default '0', - + -- 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). @@ -17,20 +17,20 @@ CREATE TABLE /*$wgDBprefix*/categorylinks ( -- isn't always ideal, but collations seem to be an exciting -- and dangerous new world in MySQL... -- - -- Truncate so that the cl_sortkey key fits in 1000 bytes + -- Truncate so that the cl_sortkey key fits in 1000 bytes -- (MyISAM 5 with server_character_set=utf8) 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. cl_timestamp timestamp NOT NULL, - + UNIQUE KEY cl_from(cl_from,cl_to), - + -- This key is trouble. It's incomplete, AND it's too big -- when collation is set to UTF-8. Bleeeacch! KEY cl_sortkey(cl_to,cl_sortkey), - + -- Not really used? KEY cl_timestamp(cl_to,cl_timestamp)