DROP TABLE `budget`;
CREATE TABLE `budget` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `date` date NOT NULL default '0000-00-00',
  `in` float(10,2) NOT NULL default '0.00',
  `out` float(10,2) NOT NULL default '0.00',
  `category` smallint(5) unsigned NOT NULL default '0',
  `transaction_id` varchar(255) NOT NULL default '',
  `payment_type` smallint(5) NOT NULL default '0',
  `details` text NOT NULL,
  `note` text NOT NULL,
  `deleted` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1