# phpMyAdmin SQL Dump
# version 2.5.4
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Aug 14, 2009 at 10:13 AM
# Server version: 5.1.31
# PHP Version: 5.2.8
# 
# Database : `michael_shipe`
# 

# --------------------------------------------------------

#
# Table structure for table `admin_login`
#

CREATE TABLE `admin_login` (
  `login_id` int(10) NOT NULL AUTO_INCREMENT,
  `ms_username` varchar(200) NOT NULL,
  `ms_password` varchar(200) NOT NULL,
  PRIMARY KEY (`login_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `admin_login`
#

INSERT INTO `admin_login` VALUES (1, 'admin', 'wftrade');

# --------------------------------------------------------

#
# Table structure for table `amazon_affiliate`
#

CREATE TABLE `amazon_affiliate` (
  `amazon_id` int(10) NOT NULL AUTO_INCREMENT,
  `product_id` int(10) NOT NULL,
  `url` varchar(200) NOT NULL,
  PRIMARY KEY (`amazon_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `amazon_affiliate`
#

INSERT INTO `amazon_affiliate` VALUES (1, 1, 'test url');

# --------------------------------------------------------

#
# Table structure for table `award_product`
#

CREATE TABLE `award_product` (
  `award_id` int(10) NOT NULL AUTO_INCREMENT,
  `product_id` int(10) NOT NULL,
  `award` varchar(200) NOT NULL,
  PRIMARY KEY (`award_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `award_product`
#

INSERT INTO `award_product` VALUES (1, 1, 'Best Product 2009');

# --------------------------------------------------------

#
# Table structure for table `category`
#

CREATE TABLE `category` (
  `category_id` int(10) NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) NOT NULL,
  `name` varchar(200) NOT NULL,
  PRIMARY KEY (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

#
# Dumping data for table `category`
#

INSERT INTO `category` VALUES (1, 1, 'Category1');
INSERT INTO `category` VALUES (2, 2, 'Category2');
INSERT INTO `category` VALUES (5, 1, 'Test Category');

# --------------------------------------------------------

#
# Table structure for table `company_awards`
#

CREATE TABLE `company_awards` (
  `company_award_id` int(10) NOT NULL AUTO_INCREMENT,
  `award` longtext NOT NULL,
  `company` varchar(200) NOT NULL,
  `sponsor` varchar(200) NOT NULL,
  PRIMARY KEY (`company_award_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `company_awards`
#

INSERT INTO `company_awards` VALUES (1, 'test', 'test', 'test');

# --------------------------------------------------------

#
# Table structure for table `company_category`
#

CREATE TABLE `company_category` (
  `company_category_id` int(10) NOT NULL AUTO_INCREMENT,
  `category_id` int(10) NOT NULL,
  `company_category_name` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`company_category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

#
# Dumping data for table `company_category`
#

INSERT INTO `company_category` VALUES (1, 1, 'Company Category1');
INSERT INTO `company_category` VALUES (2, 1, 'Company Category2');

# --------------------------------------------------------

#
# Table structure for table `company_comments`
#

CREATE TABLE `company_comments` (
  `company_comment_id` int(10) NOT NULL AUTO_INCREMENT,
  `company_id` int(10) NOT NULL,
  `user_id` int(10) NOT NULL,
  `rating` int(10) NOT NULL,
  `message` longtext NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`company_comment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `company_comments`
#

INSERT INTO `company_comments` VALUES (1, 1, 2, 3, 'company comment', '2009-08-10 08:29:44', '2009-08-10 08:29:44');

# --------------------------------------------------------

#
# Table structure for table `company_conferences`
#

CREATE TABLE `company_conferences` (
  `conference_id` int(10) NOT NULL AUTO_INCREMENT,
  `indicator_value` int(10) NOT NULL,
  `company_id` int(10) NOT NULL,
  `information` longtext NOT NULL,
  `citation_link` varchar(200) NOT NULL,
  `weight` float NOT NULL,
  `social_indicator` char(1) NOT NULL,
  `environmental_indicator` char(1) NOT NULL,
  `presenter` char(1) NOT NULL,
  `sponsor` char(1) NOT NULL,
  `exhibitor` char(1) NOT NULL,
  PRIMARY KEY (`conference_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

#
# Dumping data for table `company_conferences`
#


# --------------------------------------------------------

#
# Table structure for table `company_details`
#

CREATE TABLE `company_details` (
  `company_id` int(10) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(200) NOT NULL,
  `founded_date` datetime NOT NULL,
  `HQ_address` longtext NOT NULL,
  `city` varchar(200) NOT NULL,
  `state` varchar(200) NOT NULL,
  `zip` varchar(200) NOT NULL,
  `country` varchar(200) NOT NULL,
  `about` longtext NOT NULL,
  `website` varchar(200) NOT NULL,
  `logo` varchar(200) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

#
# Dumping data for table `company_details`
#

INSERT INTO `company_details` VALUES (1, 'Nextshore', '2009-06-07 00:00:00', 'nextshore add11', 'newyok', 'newyok', '2335', 'united states', '  nextshore1', 'www.nextshore.us', 'nextshore.jpg', '2009-06-07 00:00:00', '2009-06-07 00:00:00');
INSERT INTO `company_details` VALUES (2, 'Testing Company1', '2008-09-09 00:00:00', 'CA1', 'Alabama1', 'North America1', '111111111111111112', 'USA', '   New Company1', 'www.testing1.net', 'images1.jpeg', '2008-07-07 00:00:00', '2008-08-08 00:00:00');

# --------------------------------------------------------

#
# Table structure for table `company_memberships`
#

CREATE TABLE `company_memberships` (
  `membership_id` int(10) NOT NULL AUTO_INCREMENT,
  `indicator_value` int(10) NOT NULL,
  `company_id` int(10) NOT NULL,
  `information` longtext NOT NULL,
  `citation_link` varchar(200) NOT NULL,
  `weight` float NOT NULL,
  `social_indicator` char(1) NOT NULL,
  `environmental_indicator` char(1) NOT NULL,
  `membership_status` char(1) NOT NULL,
  `cop1` char(1) NOT NULL,
  `cop2` char(1) NOT NULL,
  `cop3` char(1) NOT NULL,
  `notable_cop` char(1) NOT NULL,
  `case_study` char(1) NOT NULL,
  PRIMARY KEY (`membership_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

#
# Dumping data for table `company_memberships`
#


# --------------------------------------------------------

#
# Table structure for table `company_performances`
#

CREATE TABLE `company_performances` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `indicator_value` int(10) NOT NULL,
  `company_id` int(10) NOT NULL,
  `information` longtext NOT NULL,
  `citation_link` varchar(200) NOT NULL,
  `weight` float NOT NULL,
  `social_indicator` char(1) NOT NULL,
  `environmental_indicator` char(1) NOT NULL,
  `direct_GHG_emissions` varchar(200) NOT NULL,
  `indirect_GHG_emissions` varchar(200) NOT NULL,
  `MWh_purchased` varchar(200) NOT NULL,
  `renewable_MWh_purchased` varchar(200) NOT NULL,
  `third_party_verified` char(1) NOT NULL,
  `reduction_plans` char(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

#
# Dumping data for table `company_performances`
#


# --------------------------------------------------------

#
# Table structure for table `company_recoginitions_rankings`
#

CREATE TABLE `company_recoginitions_rankings` (
  `rid` int(10) NOT NULL AUTO_INCREMENT,
  `indicator_value` int(10) NOT NULL,
  `company_id` int(10) NOT NULL,
  `information` longtext NOT NULL,
  `citation_link` varchar(200) NOT NULL,
  `weight` float NOT NULL,
  `social_indicator` char(1) NOT NULL,
  `environmental_indicator` char(1) NOT NULL,
  `rating` int(10) NOT NULL,
  `overall_score` int(10) NOT NULL,
  `social_responsibility_rank` int(10) NOT NULL,
  PRIMARY KEY (`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

#
# Dumping data for table `company_recoginitions_rankings`
#


# --------------------------------------------------------

#
# Table structure for table `company_social_indexes`
#

CREATE TABLE `company_social_indexes` (
  `index_id` int(10) NOT NULL AUTO_INCREMENT,
  `indicator_value` int(10) NOT NULL,
  `company_id` int(10) NOT NULL,
  `information` longtext NOT NULL,
  `citation_link` varchar(200) NOT NULL,
  `weight` float NOT NULL,
  `social_indicator` char(1) NOT NULL,
  `environmental_indicator` char(1) NOT NULL,
  PRIMARY KEY (`index_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

#
# Dumping data for table `company_social_indexes`
#


# --------------------------------------------------------

#
# Table structure for table `feedback_category_suggest`
#

CREATE TABLE `feedback_category_suggest` (
  `feedback_category_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `type` varchar(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `comments` longtext,
  PRIMARY KEY (`feedback_category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `feedback_category_suggest`
#

INSERT INTO `feedback_category_suggest` VALUES (1, 2, '1', 'Test', 'TEst Comments for this Category');

# --------------------------------------------------------

#
# Table structure for table `feedback_connection`
#

CREATE TABLE `feedback_connection` (
  `feedback_connection_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `product_company_type` varchar(200) NOT NULL,
  `multiple_id_connect` int(10) NOT NULL,
  PRIMARY KEY (`feedback_connection_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

#
# Dumping data for table `feedback_connection`
#


# --------------------------------------------------------

#
# Table structure for table `feedback_general`
#

CREATE TABLE `feedback_general` (
  `feedback_general_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `comments` longtext NOT NULL,
  PRIMARY KEY (`feedback_general_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `feedback_general`
#

INSERT INTO `feedback_general` VALUES (1, 2, 'test general');

# --------------------------------------------------------

#
# Table structure for table `feedback_general_company`
#

CREATE TABLE `feedback_general_company` (
  `feed_com_id` int(10) NOT NULL AUTO_INCREMENT,
  `company_id` int(10) NOT NULL,
  `user_id` int(10) NOT NULL,
  `comments` longtext NOT NULL,
  PRIMARY KEY (`feed_com_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

#
# Dumping data for table `feedback_general_company`
#

INSERT INTO `feedback_general_company` VALUES (11, 11, 2, 'test company');

# --------------------------------------------------------

#
# Table structure for table `feedback_general_product`
#

CREATE TABLE `feedback_general_product` (
  `feedback_product_id` int(10) NOT NULL AUTO_INCREMENT,
  `product_id` int(10) NOT NULL,
  `user_id` int(10) NOT NULL,
  `comments` longtext NOT NULL,
  PRIMARY KEY (`feedback_product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

#
# Dumping data for table `feedback_general_product`
#

INSERT INTO `feedback_general_product` VALUES (21, 21, 2, 'test product');

# --------------------------------------------------------

#
# Table structure for table `feedback_general_website`
#

CREATE TABLE `feedback_general_website` (
  `feedback_website_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `comments` longtext NOT NULL,
  PRIMARY KEY (`feedback_website_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;

#
# Dumping data for table `feedback_general_website`
#

INSERT INTO `feedback_general_website` VALUES (31, 2, 'test website');

# --------------------------------------------------------

#
# Table structure for table `order_details`
#

CREATE TABLE `order_details` (
  `order_id` int(10) NOT NULL AUTO_INCREMENT,
  `order_time` datetime NOT NULL,
  `cust_firstname` varchar(30) NOT NULL,
  `cust_lastname` varchar(10) NOT NULL,
  `cust_email` varchar(30) NOT NULL,
  `cust_country` varchar(30) NOT NULL,
  `cust_zip` varchar(30) NOT NULL,
  `cust_state` varchar(30) NOT NULL,
  `cust_city` varchar(30) NOT NULL,
  `cust_address` varchar(30) NOT NULL,
  `cust_phone` varchar(30) NOT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `order_details`
#

INSERT INTO `order_details` VALUES (1, '2009-08-10 10:55:08', 'ram', 'r', 'ram@yahoo.com', 'india', '123', 'test', 'test', 'test', '123');

# --------------------------------------------------------

#
# Table structure for table `ordered_shopping_cart`
#

CREATE TABLE `ordered_shopping_cart` (
  `product_id` int(10) NOT NULL,
  `order_id` int(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `price` float NOT NULL,
  `quantity` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Dumping data for table `ordered_shopping_cart`
#


# --------------------------------------------------------

#
# Table structure for table `product_category`
#

CREATE TABLE `product_category` (
  `product_category_id` int(10) NOT NULL AUTO_INCREMENT,
  `category_id` int(10) NOT NULL,
  `product_category_name` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`product_category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

#
# Dumping data for table `product_category`
#

INSERT INTO `product_category` VALUES (1, 1, 'Product Category1');
INSERT INTO `product_category` VALUES (2, 2, 'Product Category2');
INSERT INTO `product_category` VALUES (6, 1, 'Test Product Category');

# --------------------------------------------------------

#
# Table structure for table `product_comments`
#

CREATE TABLE `product_comments` (
  `product_comment_id` int(10) NOT NULL AUTO_INCREMENT,
  `product_id` int(10) NOT NULL,
  `user_id` int(10) NOT NULL,
  `rating` int(10) NOT NULL,
  `message` longtext NOT NULL,
  `created` date NOT NULL,
  `modified` date NOT NULL,
  PRIMARY KEY (`product_comment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `product_comments`
#

INSERT INTO `product_comments` VALUES (1, 1, 2, 5, 'Testing Comment', '2009-06-06', '2009-06-06');

# --------------------------------------------------------

#
# Table structure for table `product_details`
#

CREATE TABLE `product_details` (
  `product_id` int(10) NOT NULL AUTO_INCREMENT,
  `category_id` int(10) DEFAULT NULL,
  `product_name` varchar(18) DEFAULT NULL,
  `description` longtext NOT NULL,
  `customers_rating` float NOT NULL,
  `price` float NOT NULL,
  `picture` varchar(30) NOT NULL,
  `in_stock` int(10) NOT NULL,
  `thumbnail` varchar(30) NOT NULL,
  `customer_votes` int(10) NOT NULL,
  `items_sold` int(10) NOT NULL,
  `big_picture` varchar(30) NOT NULL,
  `enabled` int(10) NOT NULL,
  `brief_description` longtext NOT NULL,
  `list_price` float NOT NULL,
  `product_code` varchar(25) NOT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

#
# Dumping data for table `product_details`
#

INSERT INTO `product_details` VALUES (1, 1, 'rtr', 'dfgd', '44', '55', 'p1.jpg', 7, 'TGC 1412.jpg', 5, 8, 'tick2.jpg', 6, 'tu fhf fg fghf hfgh fg', '56', 'ac334');
INSERT INTO `product_details` VALUES (5, 1, 'Test Product2', 'Test Product2', '41', '72', 'nextshore.jpg', 72, 'p1.jpg', 42, 22, 'TGC 1416.jpg', 32, 'Test Product2 Brief Description', '41', '42');
INSERT INTO `product_details` VALUES (6, 2, 'wewew12', 'wewew12', '1212', '5512', 'bamba-velvet.png', 5512, 'bella-shimmer.png', 2312, 312, 'fawn.png', 112, 'erere12', '34312', 'aass3312');

# --------------------------------------------------------

#
# Table structure for table `product_related`
#

CREATE TABLE `product_related` (
  `product_related_id` int(10) NOT NULL AUTO_INCREMENT,
  `product1` varchar(200) NOT NULL,
  `product2` varchar(200) NOT NULL,
  `related` varchar(200) NOT NULL,
  PRIMARY KEY (`product_related_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

#
# Dumping data for table `product_related`
#


# --------------------------------------------------------

#
# Table structure for table `rating_attribute`
#

CREATE TABLE `rating_attribute` (
  `rating_attribute_id` int(10) NOT NULL AUTO_INCREMENT,
  `attribute_name` varchar(200) NOT NULL,
  `detail` longtext NOT NULL,
  `value_points` int(10) NOT NULL,
  `rank` int(10) NOT NULL,
  `extra1` varchar(200) NOT NULL,
  PRIMARY KEY (`rating_attribute_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `rating_attribute`
#

INSERT INTO `rating_attribute` VALUES (1, 'Test Attribute', 'Attribute Details', 15, 5, '1');

# --------------------------------------------------------

#
# Table structure for table `rating_attribute_link`
#

CREATE TABLE `rating_attribute_link` (
  `rating_attribute_id` int(10) NOT NULL AUTO_INCREMENT,
  `attribute` varchar(200) NOT NULL,
  `company` varchar(200) NOT NULL,
  `website` varchar(200) NOT NULL,
  PRIMARY KEY (`rating_attribute_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `rating_attribute_link`
#

INSERT INTO `rating_attribute_link` VALUES (1, 'test', 'test', 'test');

# --------------------------------------------------------

#
# Table structure for table `rating_award`
#

CREATE TABLE `rating_award` (
  `rating_award_id` int(10) NOT NULL AUTO_INCREMENT,
  `award_name` varchar(200) DEFAULT NULL,
  `website` varchar(200) NOT NULL,
  `image_url` varchar(200) NOT NULL,
  `value_points` int(10) NOT NULL,
  `about_award` longtext,
  PRIMARY KEY (`rating_award_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `rating_award`
#

INSERT INTO `rating_award` VALUES (1, 'Award 2009', 'www.test.com', 'test.jpg', 15, 'Award Details');

# --------------------------------------------------------

#
# Table structure for table `rating_award_sponsor`
#

CREATE TABLE `rating_award_sponsor` (
  `rating_award_sponsor_id` int(10) NOT NULL AUTO_INCREMENT,
  `sponsor_name` varchar(200) NOT NULL,
  `about_sponsor` longtext NOT NULL,
  `image_url` varchar(200) NOT NULL,
  `website` varchar(200) NOT NULL,
  PRIMARY KEY (`rating_award_sponsor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `rating_award_sponsor`
#

INSERT INTO `rating_award_sponsor` VALUES (1, 'New TTC', 'Details about the sponsor.', 'ttc.jpg', 'www.ttc.in');

# --------------------------------------------------------

#
# Table structure for table `relationship`
#

CREATE TABLE `relationship` (
  `relationship_id` int(10) NOT NULL AUTO_INCREMENT,
  `quality` varchar(200) NOT NULL,
  PRIMARY KEY (`relationship_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

#
# Dumping data for table `relationship`
#


# --------------------------------------------------------

#
# Table structure for table `search_details`
#

CREATE TABLE `search_details` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `term` varchar(200) NOT NULL,
  `ip` varchar(200) NOT NULL,
  `account_id` int(10) NOT NULL,
  `sdate` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `search_details`
#

INSERT INTO `search_details` VALUES (1, 'US Products', '1234577', 2, '2009-08-12 08:55:55');

# --------------------------------------------------------

#
# Table structure for table `special_offer`
#

CREATE TABLE `special_offer` (
  `offer_id` int(10) NOT NULL AUTO_INCREMENT,
  `product_id` int(10) NOT NULL,
  `sort_order` int(10) NOT NULL,
  PRIMARY KEY (`offer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `special_offer`
#

INSERT INTO `special_offer` VALUES (1, 1, 1);

# --------------------------------------------------------

#
# Table structure for table `user_details`
#

CREATE TABLE `user_details` (
  `user_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(200) NOT NULL,
  `password` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `role` varchar(200) NOT NULL,
  `banned` varchar(200) NOT NULL,
  `forgotten_password_code` varchar(200) NOT NULL,
  `last_visit` datetime NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

#
# Dumping data for table `user_details`
#

INSERT INTO `user_details` VALUES (2, 'ram', 'ram', 'rameshs@yahoo.com', 'test', 'test', 'test', '2009-06-06 00:00:00', '2009-06-06 00:00:00', '2009-06-06 00:00:00');
INSERT INTO `user_details` VALUES (3, 'Sharly Usha', 'sharlyusha', 'sharlyusha@nextshore.net', 'Test Role1', 'Test  Banned1', '123451', '2008-09-09 00:00:00', '2008-09-09 00:00:00', '2008-10-10 00:00:00');

# --------------------------------------------------------

#
# Table structure for table `user_favorite_company_rank`
#

CREATE TABLE `user_favorite_company_rank` (
  `user_favorite_company_rank_id` int(10) NOT NULL AUTO_INCREMENT,
  `rank` int(10) NOT NULL,
  PRIMARY KEY (`user_favorite_company_rank_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `user_favorite_company_rank`
#

INSERT INTO `user_favorite_company_rank` VALUES (1, 2);

# --------------------------------------------------------

#
# Table structure for table `user_favorite_product_rank`
#

CREATE TABLE `user_favorite_product_rank` (
  `user_favorite_product_rank_id` int(10) NOT NULL AUTO_INCREMENT,
  `rank` int(10) NOT NULL,
  PRIMARY KEY (`user_favorite_product_rank_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `user_favorite_product_rank`
#

INSERT INTO `user_favorite_product_rank` VALUES (1, 2);

# --------------------------------------------------------

#
# Table structure for table `user_favorite_wish_list`
#

CREATE TABLE `user_favorite_wish_list` (
  `user_favorite_wish_list_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `product_id` int(10) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `active` char(1) NOT NULL,
  PRIMARY KEY (`user_favorite_wish_list_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `user_favorite_wish_list`
#

INSERT INTO `user_favorite_wish_list` VALUES (1, 2, 1, '2009-08-12 09:23:16', '2009-08-12 09:23:16', 'Y');

# --------------------------------------------------------

#
# Table structure for table `user_favorites_company`
#

CREATE TABLE `user_favorites_company` (
  `user_favorites_company_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `company_id` int(10) NOT NULL,
  PRIMARY KEY (`user_favorites_company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `user_favorites_company`
#

INSERT INTO `user_favorites_company` VALUES (1, 2, 1);

# --------------------------------------------------------

#
# Table structure for table `user_favorites_product`
#

CREATE TABLE `user_favorites_product` (
  `user_favorites_product_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `product_id` int(10) NOT NULL,
  PRIMARY KEY (`user_favorites_product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `user_favorites_product`
#

INSERT INTO `user_favorites_product` VALUES (1, 2, 1);

# --------------------------------------------------------

#
# Table structure for table `user_profile`
#

CREATE TABLE `user_profile` (
  `user_profile_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `first_name` varchar(200) NOT NULL,
  `last_name` varchar(200) NOT NULL,
  `cellphone` varchar(200) NOT NULL,
  `verified` char(1) NOT NULL,
  PRIMARY KEY (`user_profile_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

#
# Dumping data for table `user_profile`
#

INSERT INTO `user_profile` VALUES (2, 2, 'ram', 's', '9940433283', 'Y');
INSERT INTO `user_profile` VALUES (3, 3, 'Sharly', 'Usha', '9993144331', 'Y');

# --------------------------------------------------------

#
# Table structure for table `user_social_network_account`
#

CREATE TABLE `user_social_network_account` (
  `user_social_network_account_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `network` varchar(200) NOT NULL,
  `user_name` varchar(200) NOT NULL,
  `password` varchar(200) NOT NULL,
  `default_notification` varchar(200) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`user_social_network_account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `user_social_network_account`
#

INSERT INTO `user_social_network_account` VALUES (1, 2, 'test', 'ram', 'ram', 'test', '2009-08-10 12:01:22', '2009-08-10 12:01:22');