Code: Select all
CREATE TABLE `InvoiceItems` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`invNo` smallint(5) unsigned NOT NULL default '0',
`details` text NOT NULL,
`net` decimal(9,2) NOT NULL default '0.00',
PRIMARY KEY (`id`),
KEY `invNo` (`invNo`)
) TYPE=MyISAM ;
INSERT INTO `InvoiceItems` VALUES (1, 1, 'Test Item', 15.00);
INSERT INTO `InvoiceItems` VALUES (2, 1, 'Another Item', 48.00);
INSERT INTO `InvoiceItems` VALUES (3, 2, 'Item 1', 49.99);
INSERT INTO `InvoiceItems` VALUES (4, 2, 'Item 2', 78.50);
INSERT INTO `InvoiceItems` VALUES (5, 3, 'Just one item', 50.00);
CREATE TABLE `Invoices` (
`invNo` smallint(5) unsigned NOT NULL default '0',
`issued` date NOT NULL default '0000-00-00',
`company` varchar(50) NOT NULL default '',
PRIMARY KEY (`invNo`)
) TYPE=MyISAM;
INSERT INTO `Invoices` VALUES (1, '2006-01-01', 'Test Co');
INSERT INTO `Invoices` VALUES (2, '2006-01-02', 'Another Test');
INSERT INTO `Invoices` VALUES (3, '2006-01-03', 'And Another');
CREATE TABLE `Transactions` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`date` date NOT NULL default '0000-00-00',
`net` decimal(9,2) NOT NULL default '0.00',
`invNo` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `invNo` (`invNo`)
) TYPE=MyISAM ;
INSERT INTO `Transactions` VALUES (1, '2006-01-02', 63.00, 1);
INSERT INTO `Transactions` VALUES (2, '2006-01-05', 10.00, 2);
INSERT INTO `Transactions` VALUES (3, '2006-01-10', 1.99, 2);
INSERT INTO `Transactions` VALUES (4, '2006-01-11', 1.50, 2);
INSERT INTO `Transactions` VALUES (5, '2006-01-12', 115.00, 2);
Here's some simplified example tables.