[Summary view] [Print] [Text view]

   1  --
   2  -- Adds rev_text_id field to revision table.
   3  -- This is a key to text.old_id, so that revisions can be stored
   4  -- for non-save operations without duplicating text, and so that
   5  -- a back-end storage system can provide its own numbering system
   6  -- if necessary.
   7  --
   8  -- rev.rev_id and text.old_id are no longer assumed to be the same.
   9  --
  10  -- 2005-03-28
  11  --
  12  
  13  ALTER TABLE /*$wgDBprefix*/revision
  14    ADD rev_text_id int unsigned NOT NULL;
  15  
  16  UPDATE /*$wgDBprefix*/revision
  17    SET rev_text_id=rev_id;