diff options
author | Pierre Schmitz <pierre@archlinux.de> | 2007-07-18 09:49:48 +0200 |
---|---|---|
committer | Pierre Schmitz <pierre@archlinux.de> | 2007-07-18 09:49:48 +0200 |
commit | fd12989ef8eab0fc9816decb8bcabccd1d213ee8 (patch) | |
tree | 68b12cc05704f2181a90d69b898f999309a8c036 /maintenance/archives/patch-categorylinks.sql | |
parent | 1a1c15f5da352895fb32daab8550cb3dca8198ac (diff) |
auf 1.10.1 aktualisiert
Diffstat (limited to 'maintenance/archives/patch-categorylinks.sql')
-rw-r--r-- | maintenance/archives/patch-categorylinks.sql | 10 |
1 files changed, 4 insertions, 6 deletions
diff --git a/maintenance/archives/patch-categorylinks.sql b/maintenance/archives/patch-categorylinks.sql index c5eb396e..02168d7f 100644 --- a/maintenance/archives/patch-categorylinks.sql +++ b/maintenance/archives/patch-categorylinks.sql @@ -5,7 +5,7 @@ -- CREATE TABLE /*$wgDBprefix*/categorylinks ( -- Key to page_id of the page defined as a category member. - cl_from int(8) unsigned NOT NULL default '0', + cl_from int unsigned NOT NULL default '0', -- Name of the category. -- This is also the page_title of the category's description page; @@ -17,11 +17,9 @@ CREATE TABLE /*$wgDBprefix*/categorylinks ( -- isn't always ideal, but collations seem to be an exciting -- and dangerous new world in MySQL... -- - -- For MySQL 4.1+ with charset set to utf8, the sort key *index* - -- needs cut to be smaller than 1024 bytes (at 3 bytes per char). - -- To sort properly on the shorter key, this field needs to be - -- the same shortness. - cl_sortkey varchar(86) binary NOT NULL default '', + -- 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. |