From c456c230388e449c92c008e6897580e4bb2c6a5c Mon Sep 17 00:00:00 2001 From: daniel Date: Wed, 10 Oct 2012 11:40:22 +0200 Subject: [PATCH] Fix declaration of content_model and content_format fields. The data type of content model and content format was varbinary originally, then it got changed to int, then back again to varbinary. The latter change was done in the updater, but was missing in tables.sql. Change-Id: I44a92d18ca22126d9678073b272eb6345627a951 --- maintenance/tables.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 0da3c7592a..a06c21ceb9 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -263,7 +263,7 @@ CREATE TABLE /*_*/page ( page_len int unsigned NOT NULL, -- content model, see CONTENT_MODEL_XXX constants - page_content_model int unsigned default NULL + page_content_model varbinary(32) DEFAULT NULL ) /*$wgDBTableOptions*/; CREATE UNIQUE INDEX /*i*/name_title ON /*_*/page (page_namespace,page_title); @@ -322,10 +322,10 @@ CREATE TABLE /*_*/revision ( rev_sha1 varbinary(32) NOT NULL default '', -- content model, see CONTENT_MODEL_XXX constants - rev_content_model int unsigned default NULL, + rev_content_model varbinary(32) DEFAULT NULL, -- content format, see CONTENT_FORMAT_XXX constants - rev_content_format int unsigned default NULL + rev_content_format varbinary(64) DEFAULT NULL ) /*$wgDBTableOptions*/ MAX_ROWS=10000000 AVG_ROW_LENGTH=1024; -- In case tables are created as MyISAM, use row hints for MySQL <5.0 to avoid 4GB limit @@ -439,10 +439,10 @@ CREATE TABLE /*_*/archive ( ar_sha1 varbinary(32) NOT NULL default '', -- content model, see CONTENT_MODEL_XXX constants - ar_content_model int unsigned default NULL, + ar_content_model varbinary(32) DEFAULT NULL, -- content format, see CONTENT_FORMAT_XXX constants - ar_content_format int unsigned default NULL + ar_content_format varbinary(64) DEFAULT NULL ) /*$wgDBTableOptions*/; -- 2.20.1