diff options
Diffstat (limited to 'maintenance/archives/patch-page_len.sql')
-rw-r--r-- | maintenance/archives/patch-page_len.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/maintenance/archives/patch-page_len.sql b/maintenance/archives/patch-page_len.sql new file mode 100644 index 00000000..c32dc8d4 --- /dev/null +++ b/maintenance/archives/patch-page_len.sql @@ -0,0 +1,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(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; |