Change Primary Key?
3 posts by 3 authors in: Forums > CMS Builder
Last Post: March 26, 2018 (RSS)
By (Deleted User) - March 25, 2018
Hello,
I need to run a more complex custom query, and what I need is the ability to have a composite primary key. The primary key needs to be a combination of 3 different columns. Is this possible? If so, how can I achieve this.
Thanks
By kitsguru - March 26, 2018
You can use the mysql console to create a unique key with any columns you require. Technically it is a unique key not a primary key, however it will function essentially the same.
By Dave - March 26, 2018
Hi testplan,
Yea, there's no support for composite primary keys. So options would be to try some things and see if CMSB still works with it (it's always going to expect a num column), or perhaps have an additional table that isn't managed by CMSB.
Hope that helps!
interactivetools.com