Need ability to assign indexes and manually assign primary key column

[sequelize]

Need ability to assign indexes and manually assign primary key column

[sdepold]

hey there,

@indexes: right... nice one :)
@primary key "id": there is already an issue. that's pretty difficulty. will take some time to prepare the code for that i guess.
@adding a s: the app isn't adding a s but transforming the word into plural :) I used that behavoir due to my background as rails developer. they are doing it as well and i never had problems with that. but i will think about that :)

[Trakkasure]

I've started working on potential solutions on this.
I have a field that defines the key column. I was thinking that it is possible to have multiple primary keys in the case of a complex table definition. An example of I am working on right now a radius SQL backend where there is no ID field, but a userID and an attribute field, combined they make a primary key. I didn't write it, I'm just working with it. I've added an ID field to make it work. But to ensure unique user/attribute I wanted to be able to define it in the object as it is in the DB.

[Trakkasure]

I have completed this... however.. I'm having some difficulty with the association code.. (You got some complex stuff in there)
I am chugging through it. So everything works.. until you want to work with associations.

Added Index specification.
Added Primary key option
Added ability to specify multiple primary key columns.
Added the ability to specify the size of a string in column definition (letting the DB truncate data for you)

[Trakkasure]

Check pull request for completed code.