patch-rev_text_id.sql

来自「php 开发的内容管理系统」· SQL 代码 · 共 18 行

--
-- 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(8) unsigned NOT NULL;

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