blob: 7d01d90a53455012b105228d1826a8f47dfd208b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
-- 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 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;
|
