[Summary view] [Print] [Text view]

   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*/;