MySQL cleaner ways to do things

Create table ..

CREATE TABLE `mycash`.`unit` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Sequence number',
`name` VARCHAR(45) NOT NULL COMMENT 'organization or home name',
`type` ENUM('Home','Organization','Community') NOT NULL DEFAULT 'Home',
`country_code` TINYINT UNSIGNED NOT NULL,
`area_code` SMALLINT UNSIGNED NOT NULL,
`pincode` INTEGER UNSIGNED NOT NULL,
`street_address` TEXT,
`creation_date` DATE NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE = InnoDB
COMMENT = 'Top level entity, could be a house, organization or community';