Host: localhost
Database: boatsite
Generation Time: Oct 23, 2008 at 02:43 PM
Generated by: phpMyAdmin 2.11.6 / MySQL 5.0.21
SQL query: show create table `site_boat_details`;
Rows: 1
| Table | Create Table |
|---|---|
| site_boat_details | CREATE TABLE `site_boat_details` (\n `id` bigint(20) NOT NULL auto_increment,\n `product_id` bigint(20) NOT NULL default '0' COMMENT 'id of boat product table (reference key)',\n `brand_id` int(11) unsigned NOT NULL default '0' COMMENT 'id of brand table (reference key)',\n `model_id` int(11) NOT NULL default '0' COMMENT 'id of model table (reference key)',\n `propulsion` varchar(30) NOT NULL default '' COMMENT 'Power,Sail,Other',\n `boat_type` varchar(30) NOT NULL default '' COMMENT 'Trailerable,Non-Traile',\n `material` varchar(30) NOT NULL default '' COMMENT 'Aluminium,Fiberglass,Other',\n `hull_type` varchar(30) NOT NULL default '' COMMENT 'Single Hull,Multi Hull',\n `boat_style` varchar(50) NOT NULL default '' COMMENT 'Bowrider – Catamaran - Centre-Console - Cuddy/Half Cabin - Flybridge – Inflatable - Motor Yacht – Open – Pontoon – Runabout – Sailboat - Ski Boat - Sport Cruiser - Trailer Sailor',\n `usage` varchar(255) NOT NULL default '',\n `manufacture_year` mediumint(4) NOT NULL default '0',\n `registration_number` varchar(50) NOT NULL default '',\n `registration_expiry_date` datetime NOT NULL default '0000-00-00 00:00:00',\n `hin_number` varchar(50) NOT NULL default '',\n `condition` varchar(15) NOT NULL default '' COMMENT 'New, As New,Excellent,Good,Fair,Poor',\n PRIMARY KEY (`id`),\n KEY `product_id` (`product_id`),\n KEY `brand_id` (`brand_id`),\n KEY `model_id` (`model_id`),\n KEY `propulsion` (`propulsion`),\n KEY `boat_type` (`boat_type`),\n KEY `material` (`material`),\n KEY `hull_type` (`hull_type`),\n KEY `boat_style` (`boat_style`)\n) ENGINE=InnoDB DEFAULT CHARSET=latin1 |