From 08607314e3995003703bb1f4499dd90df9fbd617 Mon Sep 17 00:00:00 2001 From: Magnus Manske Date: Sat, 19 Mar 2005 13:42:36 +0000 Subject: [PATCH] correct validate-table code --- maintenance/tables.sql | 11 +++++------ 1 file changed, 5 insertions(+), 6 deletions(-) diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 802069f62a..4e0651f9d8 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -312,14 +312,13 @@ CREATE TABLE /*$wgDBprefix*/blobs ( CREATE TABLE /*$wgDBprefix*/validate ( `val_user` int(11) NOT NULL default '0', - `val_title` varchar(255) binary NOT NULL default '', - `val_timestamp` varchar(14) binary NOT NULL default '', - `val_type` int(10) unsigned NOT NULL default '0', + `val_page` int(11) unsigned NOT NULL default '0', + `val_revision` int(11) unsigned NOT NULL default '0', + `val_type` int(11) unsigned NOT NULL default '0', `val_value` int(11) default '0', `val_comment` varchar(255) NOT NULL default '', - KEY `val_user` (`val_user`,`val_title`,`val_timestamp`) -); - + KEY `val_user` (`val_user`,`val_revision`) +) TYPE=MyISAM; CREATE TABLE /*$wgDBprefix*/logging ( -- Symbolic keys for the general log type and the action type -- 2.20.1