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);
|