[NFR] \Phaclon\Db\Index: TYPE

[lantian]

[NOW]:
Currently we can create index via db adapter:

$db->addIndex(new Index('name', $columns));

But we can't set index type. Index has only two properties (name and columns) - http://docs.phalconphp.com/en/latest/api/Phalcon_Db_Index.html

[NFR]:
Adding new fields 'type' to improve index:

class Index {

public function __constructor($name, $columns, $type = null){...}
public function getType(){...}

}

This will allow to generate sql:

ALTER TABLE `$table` ADD $type INDEX `$name` (...$columns...);

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[ghost]

Actually I was working on a similar feature but had no time to finish it :-(

[nexik]

support for example: unique indexes would be awesome

[pgasiorowski]

+1

[TheSerapher]

👍

[sergeyklay]

@andresgutierrez Issue is solved

[Green-Cat]

@sergeyklay Implemented in #2449