Adding relation changes column type

[Kaylakaze]

I'm accessing data from a CRM system that uses CHAR(36) for the id column. Mostly, this isn't a problem, but when I relate data, Fabrik changes the id field of my primary table to INT, which, needless to say, completely destroys the existing ids. Any ideas how to fix?

 

[troester]

If you are creating a new fabrik list pointing to an existing DB table set "alter field types"=no in list's Details/Advanced.
But I'm not sure if an non-int primary key in a fabrik list will do in any case.

 

[Kaylakaze]

Yeah, the non-int ID works fine. I didn't know about that option. Thanks.

Edit: Unfortunately, Fabrik updates the key BEFORE saving the "don't alter" information, so it ends up altering the table anyway when you save the list with that option. At least it doesn't do it any more after that.