EVOLUTION-NINJA
Edit File: qpcache.install
<?php /** * The installer file for qpcache. * @file */ function qpcache_update_6100() { $spec = array( 'type' => 'int', 'not null' => TRUE, 'unsigned' => FALSE, 'default' => 0, ); $indexes = array( 'unique keys' => array('hash' => array('crckey', 'hashkey')), ); db_change_field('qpcache_xmlcache', 'crckey', 'crckey', $spec, $indexes); return; } function qpcache_update_6101() { $spec = array( 'type' => 'int', 'size' => 'big', 'not null' => TRUE, 'unsigned' => FALSE, 'default' => 0, ); db_change_field('qpcache_xmlcache', 'crckey', 'crckey', $spec); return; } /** * Implementation of hook_schema(). */ function qpcache_schema() { $schema['qpcache_xmlcache'] = array( 'fields' => array( // Cache ID 'cid' => array( 'type' => 'serial', 'not null' => TRUE, 'unsigned' => TRUE, ), // CRC32 checksum 'crckey' => array( 'type' => 'int', 'size' => 'big', 'not null' => TRUE, 'unsigned' => FALSE, 'default' => 0, ), // Expiration timestamp 'expire' => array( 'type' => 'int', 'not null' => TRUE, 'unsigned' => TRUE, 'default' => 0, ), // Hash key 'hashkey' => array( 'type' => 'varchar', 'length' => 32, ), // Cleartext key (for DBAs) 'clearkey' => array( 'type' => 'text', ), // XML content 'body' => array( 'type' => 'text', 'size' => 'big', ), ), 'primary key' => array('cid'), // Collision space for the combination of these two should be miniscule. 'unique keys' => array('hash' => array('crckey', 'hashkey')), 'indexes' => array( // Used for fast seeking 'by_key' => array('crckey', 'hashkey', 'expire'), // Used by cache maintanance 'cacheexpire' => array('expire'), ), ); return $schema; }