2 -- Track category inclusions *used inline*
3 -- cl_from keys to cur_id, cl_to keys to cur_title of the category page.
4 -- cl_sortkey is the title of the linking page or an optional override
5 -- cl_timestamp marks when the link was last added
7 CREATE TABLE categorylinks (
8 cl_from
int(8) unsigned
NOT NULL default '0',
9 cl_to
varchar(255) binary NOT NULL default '',
10 cl_sortkey
varchar(255) binary NOT NULL default '',
11 cl_timestamp
timestamp NOT NULL,
12 UNIQUE KEY cl_from(cl_from
,cl_to
),
13 KEY cl_sortkey(cl_to
,cl_sortkey(128)),
14 KEY cl_timestamp(cl_to
,cl_timestamp
)