Mysql formats for some data types
Maximum length id 254 characters. May contain non-ASCII characters. So it's NVARCHAR(254) CHARACTER SET utf8.
Latitude and Longitude
About length - 3 + 6 decimal digits (in degrees) are accurate to ~10 cm. Details: 1, 2. In mysql format it will look like DECIMAL(9,6).
md5 hash
CHAR(32) CHARACTER SET latin1. I hope you don't use it for storing passwords.
CPasswordHelper hash
Documentation says you should use CHAR(64) CHARACTER SET latin1.
Apple Device Token
Device token is a 64-charred hex-string so it must match regexp like this: ~^[0-9a-f]{64}$~. Mysql type is CHAR(64) CHARACTER SET latin1.
Facebook ID
This may be used for storing user and apge ids provided by facebook api. Mysql type is bigint(20) unsigned.