Links to 'num' mySQL type in drop down
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.