maintenance/archives/patch-categorylinks.sql

   1 --
   2 -- Track category inclusions *used inline*
   3 -- This tracks a single level of category membership
   4 -- (folksonomic tagging, really).
   5 --
   6 CREATE TABLE /*$wgDBprefix*/categorylinks (
   7   -- Key to page_id of the page defined as a category member.
   8   cl_from int unsigned NOT NULL default '0',
   9
  10   -- Name of the category.
  11   -- This is also the page_title of the category's description page;
  12   -- all such pages are in namespace 14 (NS_CATEGORY).
  13   cl_to varchar(255) binary NOT NULL default '',
  14
  15   -- The title of the linking page, or an optional override
  16   -- to determine sort order. Sorting is by binary order, which
  17   -- isn't always ideal, but collations seem to be an exciting
  18   -- and dangerous new world in MySQL...
  19   --
  20   -- Truncate so that the cl_sortkey key fits in 1000 bytes
  21   -- (MyISAM 5 with server_character_set=utf8)
  22   cl_sortkey varchar(70) binary NOT NULL default '',
  23
  24   -- This isn't really used at present. Provided for an optional
  25   -- sorting method by approximate addition time.
  26   cl_timestamp timestamp NOT NULL,
  27
  28   UNIQUE KEY cl_from(cl_from,cl_to),
  29
  30   -- This key is trouble. It's incomplete, AND it's too big
  31   -- when collation is set to UTF-8. Bleeeacch!
  32   KEY cl_sortkey(cl_to,cl_sortkey),
  33
  34   -- Not really used?
  35   KEY cl_timestamp(cl_to,cl_timestamp)
  36
  37 ) /*$wgDBTableOptions*/;