summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-rev_text_id.sql
blob: 3dd9127d6c478d777f4fa88d10c115a82041db50 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
--
-- Adds rev_text_id field to revision table.
-- This is a key to text.old_id, so that revisions can be stored
-- for non-save operations without duplicating text, and so that
-- a back-end storage system can provide its own numbering system
-- if necessary.
--
-- rev.rev_id and text.old_id are no longer assumed to be the same.
--
-- 2005-03-28
--

ALTER TABLE /*$wgDBprefix*/revision
  ADD rev_text_id int unsigned NOT NULL;

UPDATE /*$wgDBprefix*/revision
  SET rev_text_id=rev_id;