| public createIndex ( string $name, string $table, string | array $columns, boolean $unique = false ) | ||
| $name | string | the name of the index. The name will be properly quoted by the method. |
| $table | string | the table that the new index will be created for. The table name will be properly quoted by the method. |
| $columns | string | array | the column(s) that should be included in the index. If there are multiple columns, please separate them by commas or use an array. Each column name will be properly quoted by the method. Quoting will be skipped for column names that include a left parenthesis "(". |
| $unique | boolean | whether to add UNIQUE constraint on the created index. |
public function createIndex($name, $table, $columns, $unique = false)
{
echo ' > create' . ($unique ? ' unique' : '') . " index {$name} on {$table} (" . implode(',', (array) $columns) . ') ...';
$time = microtime(true);
$this->db->createCommand()->createIndex($name, $table, $columns, $unique)->execute();
echo ' done (time: ' . sprintf('%.3f', microtime(true) - $time) . "s)\n";
} public function createIndex($name, $table, $columns, $unique = false)
{
if (is_null($name)) {
$name = self::formIndexName($table, $columns, $unique ? "unq" : "idx");
}
return parent::createIndex($name, $table, $columns, $unique);
}
