From dd078ce1301271954f4a289401e9177de51c3d84 Mon Sep 17 00:00:00 2001 From: River Tarnell Date: Thu, 8 Mar 2007 03:20:31 +0000 Subject: [PATCH] tables.sql needs rev_len --- maintenance/postgres/tables.sql | 3 ++- maintenance/tables.sql | 3 +++ 2 files changed, 5 insertions(+), 1 deletion(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 2ed27ef430..bdbf2e180a 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -92,7 +92,8 @@ CREATE TABLE revision ( rev_user_text TEXT NOT NULL, rev_timestamp TIMESTAMPTZ NOT NULL, rev_minor_edit CHAR NOT NULL DEFAULT '0', - rev_deleted CHAR NOT NULL DEFAULT '0' + rev_deleted CHAR NOT NULL DEFAULT '0', + rev_len INTEGER NULL ); CREATE UNIQUE INDEX revision_unique ON revision (rev_page, rev_id); CREATE INDEX rev_text_id_idx ON revision (rev_text_id); diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 8dc09d267a..ba1a885a4b 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -270,6 +270,9 @@ CREATE TABLE /*$wgDBprefix*/revision ( -- Not yet used; reserved for future changes to the deletion system. rev_deleted tinyint(1) unsigned NOT NULL default '0', + -- Length of this revision in bytes + rev_len int(8) unsigned, + PRIMARY KEY rev_page_id (rev_page, rev_id), UNIQUE INDEX rev_id (rev_id), INDEX rev_timestamp (rev_timestamp), -- 2.20.1