Host: localhost
Database: boatsite
Generation Time: Oct 23, 2008 at 02:50 PM
Generated by: phpMyAdmin 2.11.6 / MySQL 5.0.21
SQL query: Show Create Table `site_product_order` ;
Rows: 1
| Table | Create Table |
|---|---|
| site_product_order | CREATE TABLE `site_product_order` (\n `id` bigint(20) NOT NULL auto_increment,\n `user_id` bigint(20) NOT NULL default '0' COMMENT 'Reference key from boat_users table (if user is a retailer)',\n `payment_method` enum('Paymate','PayPal','Visa/Bankcard','Direct Deposit','Cheque','Free') NOT NULL default 'Paymate',\n `order_number` varchar(20) NOT NULL default '' COMMENT 'will use as reference number and will send to the payment gateway.',\n `order_date` datetime NOT NULL default '0000-00-00 00:00:00',\n `transaction_id` varchar(50) NOT NULL default '' COMMENT 'will be the payment date',\n `response_code` varchar(10) NOT NULL default '' COMMENT 'will be returned by the payment gateway',\n `total_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 `payment_currency` varchar(10) NOT NULL default '',\n `payment_date` datetime NOT NULL default '0000-00-00 00:00:00' COMMENT '//day of payment',\n `buyer_email` varchar(150) NOT NULL default '',\n `billing_address1` varchar(255) NOT NULL default '',\n `billing_address2` varchar(255) NOT NULL default '',\n `billing_city` varchar(80) NOT NULL default '',\n `billing_state` varchar(80) NOT NULL default '',\n `billing_country` varchar(80) NOT NULL default '',\n `billing_postcode` varchar(10) NOT NULL default '',\n `billing_firstname` varchar(50) NOT NULL default '',\n `billing_lastname` varchar(50) NOT NULL default '',\n `payment_status` enum('0','1') NOT NULL default '0' COMMENT '0-Pending,1->Paid',\n PRIMARY KEY (`id`),\n KEY `user_id` (`user_id`),\n KEY `payment_status` (`payment_status`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1 |