rendered paste body `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,
`Price` int(11) default NULL,
`OwnerIDs` text,
`LastPaid` datetime default NULL,
`KeptMoney` bigint(20) default NULL,
PRIMARY KEY (`HouseNumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;