CREATE TABLE `houses_owned` (
  `house_id` INTEGER UNSIGNED NOT NULL,
  `userid` INTEGER UNSIGNED NOT NULL,
  `occupant` INTEGER UNSIGNED NOT NULL,
  `rent` INTEGER UNSIGNED NOT NULL,
  `rent_buffer` INTEGER UNSIGNED NOT NULL,
  PRIMARY KEY (`house_id`, `userid`),
  UNIQUE INDEX `occupant`(`occupant`)
)
ENGINE = MyISAM;