CREATE TABLE `houses` (
`house_id` SMALLINT( 4 ) NOT NULL ,
`house_name` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL 
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;