Fixed multiple column non-primary keys in DB_forge.

[harryxu]

According to the User guide below code will generate a compound index.

$this->dbforge->add_key(array('blog_name', 'blog_label')); 

But it generate two individual indexes.

This issue was also found in 2010.

http://codeigniter.com/forums/viewthread/175805/

[spajz]

Hi!
I noticed the same thing.

[petsagouris]

We also need to be able to specify a key name with that.

[MitchellMcKenna]

I can confirm this issue, it's a simple fix and I have tested that @harryxu's fix works.

@harryxu You may need to make this pull request against the develop branch for it to be accepted, currently it is against stable.

@petsagouris You do not need a way to specify a key name, it is noted in the documentation that it will combine the column names and put underscores between them.

[michaelbrooks]

Are we still waiting on this fix? It looks like @harryxu's fix won't work though, since it just removes the array handling code altogether.

[wyred]

I just tested it and it doesn't work if I were to create a primary key that consists of more than 1 columns.
I ended up with "PRIMARY KEY Array (Array)" in the SQL

[narfbg]

#1939