Host: localhost
Database: boatsite
Generation Time: Oct 23, 2008 at 02:42 PM
Generated by: phpMyAdmin 2.11.6 / MySQL 5.0.21
SQL query: show create table `site_products`;
Rows: 1
| Table | Create Table |
|---|---|
| site_products | CREATE TABLE `site_products` (\n `id` bigint(20) NOT NULL auto_increment,\n `user_id` bigint(20) NOT NULL default '0' COMMENT 'Reference key from boat_users table',\n `trading_name` varchar(150) NOT NULL default '' COMMENT 'Will come in dropdown',\n `product_status` enum('new','used') NOT NULL default 'new' COMMENT 'default value would be new',\n `distributor_flag` enum('0','1') NOT NULL default '0' COMMENT '0->no distributor,1->distributor',\n `retailer_flag` enum('0','1') NOT NULL default '0' COMMENT '0->no retailer,1->retailer',\n `product_type` enum('boat','motor','accessory','service','marina','charter','transport','finance','insurance') NOT NULL default 'boat',\n `catalog` enum('0','1') NOT NULL default '0' COMMENT '0->catalog not uploaded,catalog uploaded',\n `product_added_date` datetime NOT NULL default '0000-00-00 00:00:00',\n `publish_date` datetime NOT NULL default '0000-00-00 00:00:00' COMMENT 'boat publish date',\n `product_expiry_date` datetime NOT NULL default '0000-00-00 00:00:00',\n `motor` enum('0','1') NOT NULL default '0' COMMENT '1->motor detail existed,0->not existed',\n `trailer` enum('0','1') NOT NULL default '0' COMMENT '1->trailer detail existed,0->not existed',\n `product_specification_template` enum('0','1') NOT NULL default '0' COMMENT '0->Save as template,1->not saved',\n `motor_detail_template` enum('0','1') NOT NULL default '0' COMMENT '0->Save as template,1->not saved',\n `features_template` enum('0','1') NOT NULL default '0' COMMENT '0->Save as template,1->not saved',\n `optional_template` enum('0','1') NOT NULL default '0' COMMENT '0->Save as template,1->not saved',\n `tab_template` enum('0','1') NOT NULL default '0' COMMENT '0->Save as template,1->not saved',\n `city` varchar(255) NOT NULL default '',\n `state` mediumint(2) NOT NULL default '0' COMMENT 'Reference from state table',\n `other_state` varchar(50) NOT NULL default '' COMMENT 'if country is other than Australia',\n `country` mediumint(2) NOT NULL default '0' COMMENT 'Reference from country table',\n `postcode` varchar(6) NOT NULL default '',\n `short_description` text NOT NULL,\n `price` double NOT NULL default '0',\n `terms_conditions` varchar(255) NOT NULL default '',\n `status` mediumint(2) NOT NULL default '1' COMMENT '0->deactivate, 1->activate',\n `save_flag` enum('0','1') NOT NULL default '0' COMMENT '0->Unpublish,1->Published',\n `current_session_id` varchar(255) NOT NULL default '' COMMENT 'display matched boats only in cart page if retailer redirected from add boat page ',\n PRIMARY KEY (`id`),\n KEY `user_id` (`user_id`),\n KEY `trading_name` (`trading_name`),\n KEY `city` (`city`),\n KEY `state` (`state`),\n KEY `country` (`country`),\n KEY `postcode` (`postcode`),\n CONSTRAINT `site_products_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `site_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=latin1 |