1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
--
-- Track category inclusions *used inline*
-- This tracks a single level of category membership
-- (folksonomic tagging, really).
--
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',
-- 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 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
-- 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 '',
-- 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)
) /*$wgDBTableOptions*/;
|
