| public createIndex ( string $name, string $table, string | array $columns, boolean $unique = false ) : string | ||
| $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, separate them with commas or use an array to represent them. Each column name will be properly quoted by the method, unless a parenthesis is found in the name. |
| $unique | boolean | whether to add UNIQUE constraint on the created index. |
| return | string | the SQL statement for creating a new index. |
public function createIndex($name, $table, $columns, $unique = false)
{
return ($unique ? 'CREATE UNIQUE INDEX ' : 'CREATE INDEX ') . $this->db->quoteTableName($name) . ' ON ' . $this->db->quoteTableName($table) . ' (' . $this->buildColumns($columns) . ')';
}