Host: localhost
Database: boatsite
Generation Time: Oct 23, 2008 at 02:44 PM
Generated by: phpMyAdmin 2.11.6 / MySQL 5.0.21
SQL query: show create table `site_distributor_retailer` ;
Rows: 1
| Table | Create Table |
|---|---|
| site_distributor_retailer | CREATE TABLE `site_distributor_retailer` (\n `id` bigint(20) NOT NULL auto_increment,\n `dist_id` bigint(20) NOT NULL default '0' COMMENT 'referance key of users',\n `brand_id` int(11) NOT NULL default '0' COMMENT 'referance key of brand',\n `retail_id` bigint(20) NOT NULL default '0' COMMENT 'referance key of users',\n `date_added` datetime NOT NULL default '0000-00-00 00:00:00',\n `status` enum('0','1') NOT NULL default '1',\n PRIMARY KEY (`id`),\n KEY `dist_id` (`dist_id`),\n KEY `brand_id` (`brand_id`),\n KEY `retail_id` (`retail_id`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1 |