Host: localhost
Database: boatsite
Generation Time: Oct 23, 2008 at 02:48 PM
Generated by: phpMyAdmin 2.11.6 / MySQL 5.0.21
SQL query: show create table `site_product_invoice`;
Rows: 1
| Table | Create Table |
|---|---|
| site_product_invoice | CREATE TABLE `site_product_invoice` (\n `id` bigint(20) NOT NULL auto_increment,\n `order_id` bigint(20) NOT NULL default '0' COMMENT 'Reference key from site order table',\n `product_id` bigint(20) NOT NULL default '0' COMMENT 'id of boat product table (reference key)',\n `amount_pay` decimal(10,3) NOT NULL default '0.000' COMMENT 'will be returned by the payment gateway and will tell us the transaction current state.',\n PRIMARY KEY (`id`),\n KEY `order_id` (`order_id`),\n KEY `product_id` (`product_id`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1 |