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)