MySQL - Use proper column length

Don't use BIGINT if MEDIUMINT will do, or CHAR(255) if strings are never more than 100 characters long. Shorter columns requires less storage space and can be compared faster. If a column is indexed, making the column smaller allows more key values to fit in the index cache.