-- phpMyAdmin SQL Dump
-- version 2.11.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 06, 2011 at 02:20 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `wineshop`
--

-- --------------------------------------------------------

--
-- Table structure for table `basket`
--

CREATE TABLE `basket` (
  `shopper_id` int(11) NOT NULL default '0',
  `product_id` int(11) NOT NULL default '0',
  `datestamp` int(11) NOT NULL default '0',
  `itemcount` int(11) NOT NULL default '0',
  PRIMARY KEY  (`shopper_id`,`product_id`),
  UNIQUE KEY `datestamp` (`datestamp`),
  UNIQUE KEY `shopper_id` (`shopper_id`),
  UNIQUE KEY `datestamp_2` (`datestamp`),
  UNIQUE KEY `shopper_id_2` (`shopper_id`),
  UNIQUE KEY `product_id_2` (`product_id`),
  UNIQUE KEY `itemcount_3` (`itemcount`),
  UNIQUE KEY `shopper_id_4` (`shopper_id`),
  UNIQUE KEY `product_id_4` (`product_id`),
  UNIQUE KEY `datestamp_5` (`datestamp`),
  UNIQUE KEY `shopper_id_6` (`shopper_id`),
  UNIQUE KEY `itemcount_6` (`itemcount`),
  UNIQUE KEY `product_id_5` (`product_id`),
  UNIQUE KEY `datestamp_7` (`datestamp`),
  UNIQUE KEY `shopper_id_7` (`shopper_id`),
  UNIQUE KEY `itemcount_7` (`itemcount`),
  UNIQUE KEY `datestamp_8` (`datestamp`),
  UNIQUE KEY `product_id_7` (`product_id`),
  KEY `itemcount` (`itemcount`),
  KEY `product_id` (`product_id`),
  KEY `itemcount_2` (`itemcount`),
  KEY `datestamp_3` (`datestamp`),
  KEY `product_id_3` (`product_id`),
  KEY `shopper_id_3` (`shopper_id`),
  KEY `datestamp_4` (`datestamp`),
  KEY `itemcount_4` (`itemcount`),
  KEY `shopper_id_5` (`shopper_id`),
  KEY `datestamp_6` (`datestamp`),
  KEY `itemcount_5` (`itemcount`),
  KEY `product_id_6` (`product_id`),
  KEY `shopper_id_8` (`shopper_id`),
  KEY `itemcount_8` (`itemcount`),
  KEY `datestamp_9` (`datestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `cart_id` int(11) NOT NULL auto_increment,
  `relink_id` int(11) NOT NULL default '0',
  `date_created` int(11) NOT NULL default '0',
  `date_modified` int(11) NOT NULL default '0',
  `basket_data` text,
  PRIMARY KEY  (`cart_id`),
  UNIQUE KEY `cart_id` (`cart_id`),
  UNIQUE KEY `relink_id_2` (`relink_id`),
  UNIQUE KEY `cart_id_3` (`cart_id`),
  UNIQUE KEY `cart_id_5` (`cart_id`),
  UNIQUE KEY `relink_id_4` (`relink_id`),
  UNIQUE KEY `cart_id_7` (`cart_id`),
  UNIQUE KEY `relink_id_6` (`relink_id`),
  KEY `relink_id` (`relink_id`),
  KEY `cart_id_2` (`cart_id`),
  KEY `date_created` (`date_created`),
  KEY `date_modified` (`date_modified`),
  KEY `relink_id_3` (`relink_id`),
  KEY `date_created_2` (`date_created`),
  KEY `date_modified_2` (`date_modified`),
  KEY `cart_id_4` (`cart_id`),
  KEY `cart_id_6` (`cart_id`),
  KEY `relink_id_5` (`relink_id`),
  KEY `date_modified_3` (`date_modified`),
  KEY `date_created_3` (`date_created`),
  FULLTEXT KEY `basket_data` (`basket_data`),
  FULLTEXT KEY `basket_data_2` (`basket_data`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=748 ;

-- --------------------------------------------------------

--
-- Table structure for table `cat`
--

CREATE TABLE `cat` (
  `cat_id` int(11) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL default '',
  `description` varchar(255) default NULL,
  `parent_id` int(11) NOT NULL default '0',
  `cat_order` int(11) default '100',
  `cat_param` tinyint(4) default '0',
  `status` char(1) NOT NULL default '',
  `name2` varchar(64) default NULL,
  `description2` varchar(255) default NULL,
  PRIMARY KEY  (`cat_id`),
  UNIQUE KEY `cat_id_2` (`cat_id`),
  UNIQUE KEY `cat_id_3` (`cat_id`),
  UNIQUE KEY `cat_id_5` (`cat_id`),
  KEY `cat_order` (`cat_order`),
  KEY `status` (`status`),
  KEY `name_2` (`name`),
  KEY `parent_id` (`parent_id`),
  KEY `cat_param` (`cat_param`),
  KEY `cat_id` (`cat_id`),
  KEY `description` (`description`),
  KEY `description2_2` (`description2`),
  KEY `name2_3` (`name2`),
  KEY `description2_3` (`description2`),
  KEY `cat_id_4` (`cat_id`),
  KEY `cat_param_2` (`cat_param`),
  KEY `cat_order_2` (`cat_order`),
  KEY `parent_id_2` (`parent_id`),
  KEY `description_3` (`description`),
  KEY `name_4` (`name`),
  KEY `description_5` (`description`),
  KEY `description2_4` (`description2`),
  KEY `parent_id_3` (`parent_id`),
  KEY `cat_order_3` (`cat_order`),
  KEY `status_2` (`status`),
  KEY `name2_5` (`name2`),
  KEY `status_3` (`status`),
  KEY `name_6` (`name`),
  KEY `cat_param_3` (`cat_param`),
  KEY `cat_id_6` (`cat_id`),
  KEY `description2_6` (`description2`),
  FULLTEXT KEY `name2` (`name2`),
  FULLTEXT KEY `name2_2` (`name2`),
  FULLTEXT KEY `name` (`name`),
  FULLTEXT KEY `description2` (`description2`),
  FULLTEXT KEY `description_2` (`description`),
  FULLTEXT KEY `name_3` (`name`),
  FULLTEXT KEY `description_4` (`description`),
  FULLTEXT KEY `description2_5` (`description2`),
  FULLTEXT KEY `name_5` (`name`),
  FULLTEXT KEY `name2_4` (`name2`),
  FULLTEXT KEY `name2_6` (`name2`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=171 ;

-- --------------------------------------------------------

--
-- Table structure for table `cat_product`
--

CREATE TABLE `cat_product` (
  `product_id` int(11) NOT NULL default '0',
  `cat_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`product_id`,`cat_id`),
  KEY `product_id` (`product_id`),
  KEY `cat_id` (`cat_id`),
  KEY `cat_id_2` (`cat_id`),
  KEY `product_id_2` (`product_id`),
  KEY `product_id_3` (`product_id`),
  KEY `cat_id_3` (`cat_id`),
  KEY `cat_id_4` (`cat_id`),
  KEY `product_id_4` (`product_id`),
  KEY `cat_id_5` (`cat_id`),
  KEY `product_id_5` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `cat_prod_roundtrip`
--

CREATE TABLE `cat_prod_roundtrip` (
  `product_id` int(11) NOT NULL default '0',
  `co_code` char(8) NOT NULL default '',
  PRIMARY KEY  (`product_id`,`co_code`),
  UNIQUE KEY `product_id_2` (`product_id`),
  UNIQUE KEY `product_id_3` (`product_id`),
  UNIQUE KEY `product_id_4` (`product_id`),
  UNIQUE KEY `product_id_6` (`product_id`),
  UNIQUE KEY `product_id_8` (`product_id`),
  KEY `product_id` (`product_id`),
  KEY `co_code` (`co_code`),
  KEY `co_code_2` (`co_code`),
  KEY `product_id_5` (`product_id`),
  KEY `co_code_3` (`co_code`),
  KEY `co_code_4` (`co_code`),
  KEY `product_id_7` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `order_id` int(11) NOT NULL auto_increment,
  `order_strid` varchar(30) default NULL,
  `shopper_id` int(11) NOT NULL default '0',
  `datestamp` int(11) NOT NULL default '0',
  `total_amount` float NOT NULL default '0',
  `ship_details` text,
  `bill_details` text,
  `product_details` text,
  `bank_details` text,
  `status` char(1) NOT NULL default '',
  PRIMARY KEY  (`order_id`),
  UNIQUE KEY `order_id_2` (`order_id`),
  UNIQUE KEY `order_id_4` (`order_id`),
  UNIQUE KEY `order_id_5` (`order_id`),
  UNIQUE KEY `ostr` (`order_strid`),
  UNIQUE KEY `order_strid_2` (`order_strid`),
  UNIQUE KEY `order_strid_5` (`order_strid`),
  UNIQUE KEY `order_strid_8` (`order_strid`),
  KEY `shopid` (`shopper_id`),
  KEY `status` (`status`),
  KEY `datestamp` (`datestamp`),
  KEY `order_id` (`order_id`),
  KEY `total_amount` (`total_amount`),
  KEY `status_2` (`status`),
  KEY `shopper_id` (`shopper_id`),
  KEY `datestamp_2` (`datestamp`),
  KEY `order_strid_3` (`order_strid`),
  KEY `order_strid_4` (`order_strid`),
  KEY `order_id_3` (`order_id`),
  KEY `total_amount_2` (`total_amount`),
  KEY `shopper_id_2` (`shopper_id`),
  KEY `datestamp_3` (`datestamp`),
  KEY `status_3` (`status`),
  KEY `status_4` (`status`),
  KEY `order_id_6` (`order_id`),
  KEY `datestamp_4` (`datestamp`),
  KEY `shopper_id_3` (`shopper_id`),
  KEY `order_strid_9` (`order_strid`),
  KEY `total_amount_3` (`total_amount`),
  FULLTEXT KEY `product_details` (`product_details`),
  FULLTEXT KEY `product_details_2` (`product_details`),
  FULLTEXT KEY `order_strid` (`order_strid`),
  FULLTEXT KEY `bill_details` (`bill_details`),
  FULLTEXT KEY `ship_details` (`ship_details`),
  FULLTEXT KEY `bank_details` (`bank_details`),
  FULLTEXT KEY `product_details_3` (`product_details`),
  FULLTEXT KEY `order_strid_6` (`order_strid`),
  FULLTEXT KEY `bill_details_2` (`bill_details`),
  FULLTEXT KEY `order_strid_7` (`order_strid`),
  FULLTEXT KEY `bank_details_2` (`bank_details`),
  FULLTEXT KEY `product_details_4` (`product_details`),
  FULLTEXT KEY `ship_details_2` (`ship_details`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5388 ;

-- --------------------------------------------------------

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `product_id` int(11) NOT NULL auto_increment,
  `sku` varchar(30) default NULL,
  `title` varchar(128) NOT NULL default '',
  `title2` varchar(128) NOT NULL default '',
  `shortdesc` varchar(255) default NULL,
  `shortdesc2` varchar(255) default NULL,
  `longdesc` text,
  `longdesc2` text,
  `manufacturer` varchar(50) default NULL,
  `manufacturer2` varchar(50) default NULL,
  `bigpic` varchar(128) default NULL,
  `bigpicwidth` int(11) default NULL,
  `bigpicheight` int(11) default NULL,
  `smallpic` varchar(128) default NULL,
  `smallpicwidth` int(11) default NULL,
  `smallpicheight` int(11) default NULL,
  `porder` int(11) NOT NULL default '100',
  `status` char(1) NOT NULL default '',
  PRIMARY KEY  (`product_id`),
  UNIQUE KEY `product_id` (`product_id`),
  UNIQUE KEY `product_id_3` (`product_id`),
  KEY `bigpicwidth` (`bigpicwidth`),
  KEY `porder` (`porder`),
  KEY `title` (`title`),
  KEY `shortdesc` (`shortdesc`),
  KEY `status` (`status`),
  KEY `bigpic` (`bigpic`),
  KEY `bigpicheight` (`bigpicheight`),
  KEY `title2` (`title2`),
  KEY `porder_2` (`porder`),
  KEY `bigpicwidth_2` (`bigpicwidth`),
  KEY `smallpic_2` (`smallpic`),
  KEY `smallpicheight` (`smallpicheight`),
  KEY `manufacturer_3` (`manufacturer`),
  KEY `title_3` (`title`),
  KEY `product_id_2` (`product_id`),
  KEY `shortdesc2_3` (`shortdesc2`),
  KEY `manufacturer2_3` (`manufacturer2`),
  KEY `shortdesc_3` (`shortdesc`),
  KEY `bigpic_3` (`bigpic`),
  KEY `smallpicwidth` (`smallpicwidth`),
  KEY `sku_3` (`sku`),
  KEY `status_2` (`status`),
  KEY `porder_3` (`porder`),
  KEY `bigpicwidth_3` (`bigpicwidth`),
  KEY `product_id_4` (`product_id`),
  KEY `smallpicwidth_2` (`smallpicwidth`),
  KEY `shortdesc2_5` (`shortdesc2`),
  KEY `sku_4` (`sku`),
  KEY `smallpicheight_2` (`smallpicheight`),
  KEY `manufacturer_4` (`manufacturer`),
  KEY `shortdesc_4` (`shortdesc`),
  KEY `status_3` (`status`),
  KEY `manufacturer2_5` (`manufacturer2`),
  KEY `porder_4` (`porder`),
  KEY `manufacturer2_6` (`manufacturer2`),
  KEY `manufacturer_5` (`manufacturer`),
  KEY `title2_4` (`title2`),
  KEY `bigpicheight_2` (`bigpicheight`),
  FULLTEXT KEY `manufacturer2` (`manufacturer2`),
  FULLTEXT KEY `sku` (`sku`),
  FULLTEXT KEY `shortdesc2` (`shortdesc2`),
  FULLTEXT KEY `manufacturer` (`manufacturer`),
  FULLTEXT KEY `title_2` (`title`),
  FULLTEXT KEY `manufacturer_2` (`manufacturer`),
  FULLTEXT KEY `shortdesc_2` (`shortdesc`),
  FULLTEXT KEY `sku_2` (`sku`),
  FULLTEXT KEY `smallpic` (`smallpic`),
  FULLTEXT KEY `shortdesc2_2` (`shortdesc2`),
  FULLTEXT KEY `bigpic_2` (`bigpic`),
  FULLTEXT KEY `manufacturer2_2` (`manufacturer2`),
  FULLTEXT KEY `longdesc` (`longdesc`),
  FULLTEXT KEY `title2_2` (`title2`),
  FULLTEXT KEY `longdesc2` (`longdesc2`),
  FULLTEXT KEY `smallpic_3` (`smallpic`),
  FULLTEXT KEY `shortdesc2_4` (`shortdesc2`),
  FULLTEXT KEY `title2_3` (`title2`),
  FULLTEXT KEY `manufacturer2_4` (`manufacturer2`),
  FULLTEXT KEY `sku_5` (`sku`),
  FULLTEXT KEY `longdesc2_2` (`longdesc2`),
  FULLTEXT KEY `longdesc_2` (`longdesc`),
  FULLTEXT KEY `longdesc_3` (`longdesc`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3053 ;

-- --------------------------------------------------------

--
-- Table structure for table `product_cross`
--

CREATE TABLE `product_cross` (
  `product_id` int(11) NOT NULL default '0',
  `related_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`product_id`,`related_id`),
  KEY `product_id` (`product_id`),
  KEY `related_id` (`related_id`),
  KEY `product_id_2` (`product_id`),
  KEY `related_id_2` (`related_id`),
  KEY `product_id_3` (`product_id`),
  KEY `related_id_3` (`related_id`),
  KEY `product_id_4` (`product_id`),
  KEY `product_id_5` (`product_id`),
  KEY `related_id_4` (`related_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `quantity`
--

CREATE TABLE `quantity` (
  `quantity_id` smallint(6) NOT NULL auto_increment,
  `description` varchar(50) NOT NULL default '',
  `description2` varchar(50) default NULL,
  PRIMARY KEY  (`quantity_id`),
  UNIQUE KEY `description` (`description`),
  UNIQUE KEY `description_4` (`description`),
  UNIQUE KEY `quantity_id_3` (`quantity_id`),
  UNIQUE KEY `description_6` (`description`),
  UNIQUE KEY `quantity_id_5` (`quantity_id`),
  UNIQUE KEY `description_8` (`description`),
  UNIQUE KEY `description_11` (`description`),
  UNIQUE KEY `quantity_id_6` (`quantity_id`),
  UNIQUE KEY `description2` (`description2`),
  UNIQUE KEY `description2_4` (`description2`),
  UNIQUE KEY `description2_8` (`description2`),
  UNIQUE KEY `description2_12` (`description2`),
  UNIQUE KEY `description2_13` (`description2`),
  KEY `quantity_id` (`quantity_id`),
  KEY `description2_2` (`description2`),
  KEY `description_3` (`description`),
  KEY `quantity_id_2` (`quantity_id`),
  KEY `description2_5` (`description2`),
  KEY `description2_7` (`description2`),
  KEY `quantity_id_4` (`quantity_id`),
  KEY `description_10` (`description`),
  KEY `description2_11` (`description2`),
  KEY `quantity_id_7` (`quantity_id`),
  FULLTEXT KEY `description2_3` (`description2`),
  FULLTEXT KEY `description_2` (`description`),
  FULLTEXT KEY `description_5` (`description`),
  FULLTEXT KEY `description2_6` (`description2`),
  FULLTEXT KEY `description_7` (`description`),
  FULLTEXT KEY `description2_9` (`description2`),
  FULLTEXT KEY `description_9` (`description`),
  FULLTEXT KEY `description_12` (`description`),
  FULLTEXT KEY `description2_10` (`description2`),
  FULLTEXT KEY `description2_14` (`description2`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- --------------------------------------------------------

--
-- Table structure for table `rate`
--

CREATE TABLE `rate` (
  `product_id` int(11) NOT NULL default '0',
  `A` int(11) default '0',
  `B` int(11) default '0',
  `C` int(11) default '0',
  PRIMARY KEY  (`product_id`),
  UNIQUE KEY `product_id` (`product_id`),
  UNIQUE KEY `product_id_3` (`product_id`),
  UNIQUE KEY `product_id_4` (`product_id`),
  UNIQUE KEY `product_id_6` (`product_id`),
  UNIQUE KEY `product_id_8` (`product_id`),
  KEY `product_id_2` (`product_id`),
  KEY `product_id_5` (`product_id`),
  KEY `C` (`C`),
  KEY `B` (`B`),
  KEY `A` (`A`),
  KEY `product_id_7` (`product_id`),
  KEY `B_2` (`B`),
  KEY `C_2` (`C`),
  KEY `A_2` (`A`),
  KEY `product_id_9` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `related`
--

CREATE TABLE `related` (
  `pri_id` int(11) NOT NULL default '0',
  `rel_id` int(11) NOT NULL default '0',
  `rel_type` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`pri_id`,`rel_id`,`rel_type`),
  KEY `rel_type` (`rel_type`),
  KEY `pri_id` (`pri_id`),
  KEY `rel_id` (`rel_id`),
  KEY `rel_id_2` (`rel_id`),
  KEY `pri_id_2` (`pri_id`),
  KEY `rel_type_2` (`rel_type`),
  KEY `rel_type_3` (`rel_type`),
  KEY `rel_id_3` (`rel_id`),
  KEY `rel_id_4` (`rel_id`),
  KEY `rel_type_4` (`rel_type`),
  KEY `rel_type_5` (`rel_type`),
  KEY `pri_id_3` (`pri_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `sg`
--

CREATE TABLE `sg` (
  `sg_id` int(11) NOT NULL auto_increment,
  `sg_name` varchar(50) NOT NULL default '',
  `isb2b` char(1) NOT NULL default '',
  `status` char(1) NOT NULL default '',
  PRIMARY KEY  (`sg_id`),
  UNIQUE KEY `sg_id_4` (`sg_id`),
  UNIQUE KEY `sg_id_5` (`sg_id`),
  UNIQUE KEY `sg_id_7` (`sg_id`),
  KEY `isb2b` (`isb2b`),
  KEY `sg_id` (`sg_id`),
  KEY `sg_name_3` (`sg_name`),
  KEY `isb2b_2` (`isb2b`),
  KEY `sg_id_2` (`sg_id`),
  KEY `isb2b_3` (`isb2b`),
  KEY `sg_name_4` (`sg_name`),
  KEY `sg_id_3` (`sg_id`),
  KEY `status` (`status`),
  KEY `sg_id_6` (`sg_id`),
  KEY `sg_name_5` (`sg_name`),
  KEY `status_2` (`status`),
  KEY `sg_name_6` (`sg_name`),
  KEY `isb2b_4` (`isb2b`),
  KEY `sg_id_8` (`sg_id`),
  FULLTEXT KEY `sg_name` (`sg_name`),
  FULLTEXT KEY `sg_name_2` (`sg_name`),
  FULLTEXT KEY `sg_name_7` (`sg_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

-- --------------------------------------------------------

--
-- Table structure for table `sg_product`
--

CREATE TABLE `sg_product` (
  `product_id` int(11) NOT NULL default '0',
  `sg_id` int(11) NOT NULL default '0',
  `price` float NOT NULL default '0',
  `saleprice` float default NULL,
  `salestart` int(11) default NULL,
  `saleend` int(11) default NULL,
  `weight` float default NULL,
  `quantity_id` smallint(6) NOT NULL default '0',
  `hot` tinyint(4) NOT NULL default '0',
  `vat_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`product_id`,`sg_id`),
  KEY `quantity_id` (`quantity_id`),
  KEY `hot` (`hot`),
  KEY `sg_id` (`sg_id`),
  KEY `price` (`price`),
  KEY `saleprice` (`saleprice`),
  KEY `product_id` (`product_id`),
  KEY `salestart` (`salestart`),
  KEY `saleend` (`saleend`),
  KEY `vat_id` (`vat_id`),
  KEY `weight` (`weight`),
  KEY `weight_2` (`weight`),
  KEY `product_id_2` (`product_id`),
  KEY `quantity_id_2` (`quantity_id`),
  KEY `saleend_2` (`saleend`),
  KEY `sg_id_2` (`sg_id`),
  KEY `price_2` (`price`),
  KEY `saleprice_2` (`saleprice`),
  KEY `vat_id_2` (`vat_id`),
  KEY `saleend_3` (`saleend`),
  KEY `sg_id_3` (`sg_id`),
  KEY `quantity_id_3` (`quantity_id`),
  KEY `saleprice_3` (`saleprice`),
  KEY `quantity_id_4` (`quantity_id`),
  KEY `saleend_4` (`saleend`),
  KEY `price_3` (`price`),
  KEY `salestart_2` (`salestart`),
  KEY `sg_id_4` (`sg_id`),
  KEY `hot_2` (`hot`),
  KEY `product_id_3` (`product_id`),
  KEY `weight_3` (`weight`),
  KEY `vat_id_3` (`vat_id`),
  KEY `product_id_4` (`product_id`),
  KEY `saleprice_4` (`saleprice`),
  KEY `vat_id_4` (`vat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `shopper`
--

CREATE TABLE `shopper` (
  `shopper_id` int(11) NOT NULL auto_increment,
  `sg_id` int(11) NOT NULL default '0',
  `date_created` int(11) NOT NULL default '0',
  `date_updated` int(11) NOT NULL default '0',
  `name` varchar(80) default NULL,
  `password` varchar(16) default NULL,
  `address` varchar(255) default NULL,
  `zip` varchar(10) default NULL,
  `city` varchar(50) default NULL,
  `country` varchar(50) default NULL,
  `phone` varchar(50) default NULL,
  `fax` varchar(50) default NULL,
  `email` varchar(128) NOT NULL default '',
  `company` varchar(50) default '',
  `afm` varchar(10) default '',
  `doy` varchar(30) default '',
  `mailinglist` char(1) default NULL,
  `status` char(1) NOT NULL default '',
  `lastname` varchar(80) NOT NULL default '',
  `job` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`shopper_id`),
  UNIQUE KEY `shopper_id` (`shopper_id`),
  KEY `sg` (`sg_id`),
  KEY `email` (`email`),
  KEY `name` (`name`),
  KEY `name_2` (`name`),
  KEY `sg_id` (`sg_id`),
  KEY `date_updated` (`date_updated`),
  KEY `email_3` (`email`),
  KEY `country` (`country`),
  KEY `city_4` (`city`),
  KEY `company` (`company`),
  KEY `lastname_3` (`lastname`),
  KEY `status` (`status`),
  KEY `doy` (`doy`),
  KEY `mailinglist` (`mailinglist`),
  KEY `job_2` (`job`),
  KEY `phone_2` (`phone`),
  KEY `password_4` (`password`),
  KEY `date_created` (`date_created`),
  KEY `afm_2` (`afm`),
  KEY `shopper_id_2` (`shopper_id`),
  KEY `address_3` (`address`),
  KEY `fax_2` (`fax`),
  KEY `zip_3` (`zip`),
  KEY `fax_3` (`fax`),
  KEY `name_5` (`name`),
  KEY `email_4` (`email`),
  KEY `email_5` (`email`),
  KEY `lastname_4` (`lastname`),
  KEY `status_2` (`status`),
  KEY `name_6` (`name`),
  KEY `date_updated_2` (`date_updated`),
  FULLTEXT KEY `zip` (`zip`),
  FULLTEXT KEY `address` (`address`),
  FULLTEXT KEY `password` (`password`),
  FULLTEXT KEY `city` (`city`),
  FULLTEXT KEY `lastname` (`lastname`),
  FULLTEXT KEY `password_2` (`password`),
  FULLTEXT KEY `city_2` (`city`),
  FULLTEXT KEY `city_3` (`city`),
  FULLTEXT KEY `job` (`job`),
  FULLTEXT KEY `email_2` (`email`),
  FULLTEXT KEY `lastname_2` (`lastname`),
  FULLTEXT KEY `phone` (`phone`),
  FULLTEXT KEY `fax` (`fax`),
  FULLTEXT KEY `address_2` (`address`),
  FULLTEXT KEY `company_2` (`company`),
  FULLTEXT KEY `zip_2` (`zip`),
  FULLTEXT KEY `password_3` (`password`),
  FULLTEXT KEY `doy_2` (`doy`),
  FULLTEXT KEY `afm` (`afm`),
  FULLTEXT KEY `country_2` (`country`),
  FULLTEXT KEY `name_3` (`name`),
  FULLTEXT KEY `name_4` (`name`),
  FULLTEXT KEY `country_3` (`country`),
  FULLTEXT KEY `company_3` (`company`),
  FULLTEXT KEY `country_4` (`country`),
  FULLTEXT KEY `address_4` (`address`),
  FULLTEXT KEY `country_5` (`country`),
  FULLTEXT KEY `address_5` (`address`),
  FULLTEXT KEY `zip_4` (`zip`),
  FULLTEXT KEY `fax_4` (`fax`),
  FULLTEXT KEY `job_3` (`job`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1829 ;

-- --------------------------------------------------------

--
-- Table structure for table `vat`
--

CREATE TABLE `vat` (
  `vat_id` smallint(6) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `name2` varchar(50) NOT NULL default '',
  `tax` float NOT NULL default '0',
  PRIMARY KEY  (`vat_id`),
  UNIQUE KEY `vat_id` (`vat_id`),
  UNIQUE KEY `name_2` (`name`),
  UNIQUE KEY `name2_3` (`name2`),
  UNIQUE KEY `name2_4` (`name2`),
  UNIQUE KEY `name_4` (`name`),
  UNIQUE KEY `vat_id_4` (`vat_id`),
  UNIQUE KEY `name2_7` (`name2`),
  UNIQUE KEY `vat_id_5` (`vat_id`),
  UNIQUE KEY `name_7` (`name`),
  KEY `name2` (`name2`),
  KEY `vat_id_2` (`vat_id`),
  KEY `tax` (`tax`),
  KEY `name_3` (`name`),
  KEY `vat_id_3` (`vat_id`),
  KEY `tax_2` (`tax`),
  KEY `name2_6` (`name2`),
  KEY `name_5` (`name`),
  KEY `name2_9` (`name2`),
  KEY `tax_3` (`tax`),
  KEY `vat_id_6` (`vat_id`),
  KEY `tax_4` (`tax`),
  FULLTEXT KEY `name` (`name`),
  FULLTEXT KEY `name2_2` (`name2`),
  FULLTEXT KEY `name2_5` (`name2`),
  FULLTEXT KEY `name2_8` (`name2`),
  FULLTEXT KEY `name_6` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;