Links to 'num' mySQL type in drop down
2 posts by 2 authors in: Forums > CMS Builder
Last Post: September 16, 2016 (RSS)
I am working on a new project, I have related tables which means that I have list fields that are then related to the parent table record. For each one I have to manually set the mySQL type to "int(10) unsigned" to match the 'num' value of the parent. Do you think that you could add that to the drop down list to make it a single step operation rather than having to say custom and typing it in ... yes I know I am lazy, but it is something simple that should be easy.
Thanks
Larry
<?= "Jenolan(Larry) :: Coding Since 1973" ?>
Peace and Long Life
By Dave - September 16, 2016
Hi Larry,
Which CMSB version are you using? The latest release has a pulldown for "MySQL Column Type" with INT as an option. It's still in the field editor, so you need to click edit on the fieldname, but it's quicker than typing it. You can also set up basic indexes through the CMS now by clicking "Column Indexing".
Also, I often don't even bother setting column types unless I know there's going to be a lot of records or there is a performance/overhead issue.
interactivetools.com