+CREATE TABLE interwiki (
+ iw_prefix char(32) NOT NULL,
+ iw_url char(127) NOT NULL,
+ iw_local BOOL NOT NULL,
+ UNIQUE KEY iw_prefix (iw_prefix)
+);
+
+-- Used for caching expensive grouped queries
+CREATE TABLE querycache (
+ qc_type char(32) NOT NULL,
+ qc_value int(5) unsigned NOT NULL default '0',
+ qc_namespace tinyint(2) unsigned NOT NULL default '0',
+ qc_title char(255) binary NOT NULL default '',
+ KEY (qc_type,qc_value)
+);
+
+-- For a few generic cache operations if not using Memcached
+CREATE TABLE objectcache (
+ keyname char(255) binary not null default '',
+ value mediumblob,
+ exptime datetime,
+ unique key (keyname),
+ key (exptime)
+);
+
+-- For storing revision text
+CREATE TABLE blobs (
+ blob_index char(255) binary NOT NULL default '',
+ blob_data longblob NOT NULL default '',
+ UNIQUE key blob_index (blob_index)
+);
+
+-- For article validation
+
+CREATE TABLE `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_value` int(11) default '0',
+ `val_comment` varchar(255) NOT NULL default '',
+ KEY `val_user` (`val_user`,`val_title`,`val_timestamp`)
+) TYPE=MyISAM;