Esempi in PHP per dropAllIndicesFromTable

Esempio n. 1

File: RecreateIndexes.php Progetto: realsoc/mediawiki-extensions

function recreateIndexesForTable( Table $table, $purpose ) {
	echo "Dropping indices from table " . $table->getIdentifier() . ".\n";
	dropAllIndicesFromTable( $table->getIdentifier() );

	echo "Creating new indices for table " . $table->getIdentifier() . ".\n";
	addIndexesForTable( $table, $purpose );
}

Esempio n. 2

File: Drop indices from tables.php Progetto: realsoc/mediawiki-extensions

<?php

define( 'MEDIAWIKI', true );

require_once( "../../../../LocalSettings.php" );
require_once( "../../php-tools/ProgressBar.php" );
require_once( "DatabaseUtilities.php" );
require_once( "Setup.php" );

ob_end_flush();

global
	$beginTime, $wgCommandLineMode;

$beginTime = time();
$wgCommandLineMode = true;

for ( $i = 1; $i < $argc; $i++ ) {
	$tableName = $argv[$i];
	echo "\nDropping indices from table: " . $tableName . "\n";
	dropAllIndicesFromTable( $tableName );
}

$endTime = time();
echo( "\n\nTime elapsed: " . durationToString( $endTime - $beginTime ) );