File: finance.sql

CREATE TABLE `finance` (
  `id` int(6) unsigned NOT NULL auto_increment,
  `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `type` char(1) NOT NULL default 'w',
  `entity` text NOT NULL,
  `amount` decimal(10,2) NOT NULL default '0.00',
  `fkCategoryID` int(11) NOT NULL default '0',
  `fkSubCategoryID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `datetime` (`datetime`)
) TYPE=MyISAM AUTO_INCREMENT=152 ;

INSERT INTO `finance` VALUES (128, '2005-05-06 00:00:00', 'b', 'Chevron: 4.459 @ 2.15', 9.63, 5, 3);
INSERT INTO `finance` VALUES (129, '2005-05-06 00:00:00', 'w', 'Cracker Barell', 1.53, 4, 2);
INSERT INTO `finance` VALUES (130, '2005-05-05 00:00:00', 'b', 'BP: 5.052 @ 2.129', 10.76, 5, 3);
INSERT INTO `finance` VALUES (131, '2005-05-06 00:00:00', 'd', 'Rockery Amoco, NO', 4.75, 4, 2);