[Summary view] [Print] [Text view]

   1  -- Rollup table to pull a LIST of tags simply without ugly GROUP_CONCAT that only works on MySQL 4.1+
   2  -- Andrew Garrett, 2009-01
   3  CREATE TABLE /*_*/tag_summary (
   4      ts_rc_id int NULL,
   5      ts_log_id int NULL,
   6      ts_rev_id int NULL,
   7      ts_tags BLOB NOT NULL
   8  ) /*$wgDBTableOptions*/;
   9  
  10  CREATE UNIQUE INDEX /*i*/tag_summary_rc_id ON /*_*/tag_summary (ts_rc_id);
  11  CREATE UNIQUE INDEX /*i*/tag_summary_log_id ON /*_*/tag_summary (ts_log_id);
  12  CREATE UNIQUE INDEX /*i*/tag_summary_rev_id ON /*_*/tag_summary (ts_rev_id);