Copy querycache: encoding and a table definition change

[lhc/web/wiklou.git] / maintenance / upgrade1_5.php

diff --git a/maintenance/upgrade1_5.php b/maintenance/upgrade1_5.php
index fdfc8b3..d86d0e9 100644 (file)
--- a/maintenance/upgrade1_5.php
+++ b/maintenance/upgrade1_5.php
@@ -55,7 +55,8 @@ class FiveUpgrade {
                        'imagelinks',
                        'categorylinks',
                        'ipblocks',
-                       'recentchanges' );
+                       'recentchanges',
+                       'querycache' );
                foreach( $tables as $table ) {
                        if( $this->doing( $table ) ) {
                                $method = 'upgrade' . ucfirst( $table );
@@ -1131,6 +1132,32 @@ END;
                $this->copyTable( 'recentchanges', $tabledef, $fields );
        }
        
+       function upgradeQuerycache() {
+               // There's a format change in the namespace field
+               $tabledef = <<<END
+CREATE TABLE $1 (
+  -- A key name, generally the base name of of the special page.
+  qc_type char(32) NOT NULL,
+  
+  -- Some sort of stored value. Sizes, counts...
+  qc_value int(5) unsigned NOT NULL default '0',
+  
+  -- Target namespace+title
+  qc_namespace int NOT NULL default '0',
+  qc_title char(255) binary NOT NULL default '',
+  
+  KEY (qc_type,qc_value)
+
+) TYPE=InnoDB
+END;
+               $fields = array(
+                       'qc_type'      => MW_UPGRADE_COPY,
+                       'qc_value'     => MW_UPGRADE_COPY,
+                       'qc_namespace' => MW_UPGRADE_COPY,
+                       'qc_title'     => MW_UPGRADE_ENCODE );
+               $this->copyTable( 'querycache', $tabledef, $fields );
+       }
+       
        /**
         * Rename all our temporary tables into final place.
         * We've left things in place so a read-only wiki can continue running