patch-page_len.sql

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

-- Page length field (in bytes) for current revision of page.
-- Since page text is now stored separately, it may be compressed
-- or otherwise difficult to calculate. Additionally, the field
-- can be indexed for handy 'long' and 'short' page lists.
--
-- Added 2005-03-12

ALTER TABLE /*$wgDBprefix*/page
  ADD page_len int(8) unsigned NOT NULL,
  ADD INDEX (page_len);

-- Not accurate if upgrading from intermediate
-- 1.5 alpha and have revision compression on.
UPDATE /*$wgDBprefix*/page, /*$wgDBprefix*/text
  SET page_len=LENGTH(old_text)
  WHERE page_latest=old_id;