~blueyed/b2evolution/dev

Add index 'check_for_reload' to speedup Hit logging.

added added

removed removed

144

global $DB;

145

if( db_index_exists($table, $name) )

146

{

147

$DB->query( 'ALTER TABLE '.$table.' DROP INDEX '.$name );

147

$DB->query( "ALTER TABLE `$table` DROP INDEX `$name`" );

148

}

149

$DB->query( 'ALTER TABLE '.$table.' ADD '.$type.' '.$name.' ('.$def.')' );

149

$DB->query( "ALTER TABLE `$table` ADD $type `$name` ($def)" );

150

}

151

152

2827

* NOTE: every change that gets done here, should bump {@link $new_db_version} (by 100).

2828

2829

2830

db_add_index( 'T_hitlog', 'check_for_reload', 'hit_datetime, hit_remote_addr, hit_uri, hit_agent_type' );

2830

2831

2832

2833

/* Wait until we're sure and no longer experimental for that one...