-- Table "dbhouse" DDL

CREATE TABLE `dbhouse` (
  `DBHouse_ID` text,
  `HouseNumber` int(11) NOT NULL default '0',
  `X` int(11) NOT NULL default '0',
  `Y` int(11) NOT NULL default '0',
  `Z` int(11) NOT NULL default '0',
  `RegionID` smallint(5) unsigned NOT NULL default '0',
  `Heading` int(11) NOT NULL default '0',
  `CreationTime` datetime default NULL,
  `Name` text,
  `Model` int(11) default NULL,
  `Emblem` int(11) default NULL,
  `PorchRoofColor` int(11) default NULL,
  `PorchMaterial` int(11) default NULL,
  `RoofMaterial` int(11) default NULL,
  `DoorMaterial` int(11) default NULL,
  `WallMaterial` int(11) default NULL,
  `TrussMaterial` int(11) default NULL,
  `WindowMaterial` int(11) default NULL,
  `Rug1Color` int(11) default NULL,
  `Rug2Color` int(11) default NULL,
  `Rug3Color` int(11) default NULL,
  `Rug4Color` int(11) default NULL,
  `IndoorGuildBanner` tinyint(1) default NULL,
  `IndoorGuildShield` tinyint(1) default NULL,
  `OutdoorGuildBanner` tinyint(1) default NULL,
  `OutdoorGuildShield` tinyint(1) default NULL,
  `Porch` tinyint(1) default NULL,
  `OwnerIDs` text,
  `LastPaid` datetime default NULL,
  `KeptMoney` bigint(20) default NULL,
  PRIMARY KEY  (`HouseNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;