CREATE TABLE `accounting` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(200) default NULL,
  `Description` text,
  `Amount` decimal(8,2) default NULL,
  `MemberID` int(11) default NULL,
  `FName` varchar(50) default NULL,
  `LName` varchar(50) default NULL,
  `PostDate` datetime default NULL,
  `CategoryID` int(11) default NULL,
  `CategoryDescription` varchar(225) default NULL,
  `Used` varchar(5) default NULL,
  `TransactionID` varchar(55) default NULL,
  `Days` int(11) default NULL,
  `Photos` int(11) default NULL,
  `ListingID` int(11) NOT NULL default '0',
  `TypeID` int(11) default NULL,
  PRIMARY KEY  (`ID`)
)