From 94617ddcba0228307f49093eb58f5907f370d118 Mon Sep 17 00:00:00 2001 From: River Tarnell Date: Thu, 8 Mar 2007 02:55:14 +0000 Subject: [PATCH] add rev_len to revision; store length of revision when saving. HEADS UP: schema change to revision table --- includes/Revision.php | 1 + maintenance/archives/patch-rev_len.sql | 3 +++ maintenance/updaters.inc | 4 +++- 3 files changed, 7 insertions(+), 1 deletion(-) create mode 100644 maintenance/archives/patch-rev_len.sql diff --git a/includes/Revision.php b/includes/Revision.php index f5a84ca26b..7526a54f07 100644 --- a/includes/Revision.php +++ b/includes/Revision.php @@ -677,6 +677,7 @@ class Revision { 'rev_user_text' => $this->mUserText, 'rev_timestamp' => $dbw->timestamp( $this->mTimestamp ), 'rev_deleted' => $this->mDeleted, + 'rev_len' => strlen($this->mText), ), $fname ); diff --git a/maintenance/archives/patch-rev_len.sql b/maintenance/archives/patch-rev_len.sql new file mode 100644 index 0000000000..b861a2bc29 --- /dev/null +++ b/maintenance/archives/patch-rev_len.sql @@ -0,0 +1,3 @@ +ALTER TABLE /*$wgDBprefix*/revision + ADD rev_len INT(8) UNSIGNED; + diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 321acfab13..5c860d35a6 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -68,6 +68,7 @@ $wgNewFields = array( array( 'user', 'user_editcount', 'patch-user_editcount.sql' ), array( 'logging', 'log_id', 'patch-log_id.sql' ), array( 'page_restrictions', 'pr_id', 'patch-page_restrictions_sortkey.sql' ), + array( 'revision', 'rev_len', 'patch-rev_len.sql' ), ); function rename_table( $from, $to, $patch ) { @@ -1174,7 +1175,8 @@ function do_postgres_updates() { array("ipblocks", "ipb_create_account", "CHAR NOT NULL DEFAULT '1'"), array("ipblocks", "ipb_enable_autoblock", "CHAR NOT NULL DEFAULT '1'"), array("recentchanges", "rc_old_len", "INT"), - array("recentchanges", "rc_new_len", "INT") + array("recentchanges", "rc_new_len", "INT"), + array("revision", "rev_len", "INT") ); $newtables = array( -- 2.20.1