# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Jan 12, 2006 at 03:00 PM
# Server version: 4.1.7
# PHP Version: 4.3.10
# 
# Database : `marshas_oscommerce`
# 
CREATE DATABASE `marshas_oscommerce`;
USE marshas_oscommerce;

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

#
# Table structure for table `address_book`
#

CREATE TABLE `address_book` (
  `address_book_id` int(11) NOT NULL auto_increment,
  `customers_id` int(11) NOT NULL default '0',
  `entry_gender` char(1) NOT NULL default '',
  `entry_company` varchar(32) default NULL,
  `entry_firstname` varchar(32) NOT NULL default '',
  `entry_lastname` varchar(32) NOT NULL default '',
  `entry_street_address` varchar(64) NOT NULL default '',
  `entry_suburb` varchar(32) default NULL,
  `entry_postcode` varchar(10) NOT NULL default '',
  `entry_city` varchar(32) NOT NULL default '',
  `entry_state` varchar(32) default NULL,
  `entry_country_id` int(11) NOT NULL default '0',
  `entry_zone_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`address_book_id`),
  KEY `idx_address_book_customers_id` (`customers_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=67 ;

#
# Dumping data for table `address_book`
#

INSERT INTO `address_book` VALUES (14, 12, 'm', '', 'simon', 'rainsford', '162 rue d\'Antrain', '', '35000', 'Rennes', 'Brittany', 73, 0);
INSERT INTO `address_book` VALUES (15, 13, 'f', '', 'test1', 'test1', '1234 Pavillion Drive', '', 'nn4 7sg', 'northampton', 'Northamptonshire', 222, 0);
INSERT INTO `address_book` VALUES (4, 4, 'm', '', 'Martin', 'Servante', 'Flat 2, 7 Selden Road', 'Worthing', 'BN11 2LL', 'Worthing', 'Sussex', 222, 0);
INSERT INTO `address_book` VALUES (17, 15, 'm', '', 'Steve', 'Allen', '1 Rowan Close', '', 'RH20 3PX', 'Storrington', 'West Sussex', 222, 0);
INSERT INTO `address_book` VALUES (9, 8, 'm', 'Lansdowne', 'Gavin', 'Fry', '96 Newlands Road', '', 'BN11 1LB', 'Worthing', 'West Sussex', 222, 0);
INSERT INTO `address_book` VALUES (10, 8, 'm', 'Lansdowne', 'Gavin', 'Fry', '1 Kings Road', '', 'BN15 8EB', 'Lancing', 'West Sussex', 222, 0);
INSERT INTO `address_book` VALUES (12, 10, 'm', '', 'Damian', 'Thorpe', '85b Ashford rd', '', 'BN21 3TE', 'Eastbourne', 'East Sussex', 222, 0);
INSERT INTO `address_book` VALUES (16, 14, 'f', '', 'Tracey', 'Parish', '1 Church Farm Rise', 'Broad Town', 'SN4 7RE', 'Swindon', 'Wiltshire', 222, 0);
INSERT INTO `address_book` VALUES (18, 16, 'f', '', 'Sue', 'Wade', '22 Newall Close', 'Tattenhall', 'ch3 9pp', 'Chester', 'UK', 222, 0);
INSERT INTO `address_book` VALUES (19, 17, 'm', '', 'Matt', 'Stacey', 'Farthings, Osmington Lodge', 'Osmington', 'DT3 6EX', 'Weymouth', 'Dorset', 222, 0);
INSERT INTO `address_book` VALUES (20, 18, 'f', '', 'Bec', 'Smith', '8 Abbas Walk', 'Great Cornard', 'CO10 0YN', 'Sudbury', 'Suffolk', 222, 0);
INSERT INTO `address_book` VALUES (21, 19, 'f', 'Premier Consulting', 'Seema', 'Sobte', '36 Hillary Drive', '', 'tw7 7eg', 'London', 'UK', 222, 0);
INSERT INTO `address_book` VALUES (22, 20, 'f', '', 'Jo', 'Lovell', '22, Cornflower Terrace', 'East Dulwich', 'SE22 0HH', 'London', 'uk', 222, 0);
INSERT INTO `address_book` VALUES (23, 21, 'f', 'charleston design', 'katherine', 'charleston', '31 rutland street', '', 'LE1 1RE', 'leicester', 'leics', 222, 0);
INSERT INTO `address_book` VALUES (24, 22, 'f', '', 'Jo', 'Pool', 'Flat 8 Escote Court, 16 Park Hill Road', 'Shortlands', 'BR2 0LE', 'Bromley', 'Ketn', 222, 0);
INSERT INTO `address_book` VALUES (25, 23, 'f', '', 'victoria', 'gordon', '53 Kingslea', '', 'RH13 5PS', 'Horsham', 'West Sussex', 222, 0);
INSERT INTO `address_book` VALUES (26, 24, 'f', '', 'Philippa', 'Jacques', 'Phoenix Cottage', '', 'SG8 8QN', 'Chrishall', 'Herts', 222, 0);
INSERT INTO `address_book` VALUES (27, 25, 'f', '', 'Louise', 'Phillips', '9 Longhill Road', 'Ovingdean', 'BN2 7BF', 'Brighton', 'East Sussex', 222, 0);
INSERT INTO `address_book` VALUES (28, 26, 'f', '', 'Carissa', 'Rattansingh', '91 Somerton road', '', 'nw2 1ru', 'cricklewood', 'london', 222, 0);
INSERT INTO `address_book` VALUES (29, 27, 'f', '', 'Rebecca', 'Holmes', '15 Earlsfield House', '', 'SW18 3AH', 'London', 'Earlsfield', 222, 0);
INSERT INTO `address_book` VALUES (30, 28, 'f', '', 'Ann', 'Wilbourn', '9 Winchester Park', 'Bromley', 'BR2 OPY', 'Kent', '--', 222, 0);
INSERT INTO `address_book` VALUES (31, 29, 'm', 'Keylight Media Ltd.', 'Andy', 'Reik', '13 Kimberley Court, Kimberley Road', '', 'NW6 7 SL', 'London', 'uk', 222, 0);
INSERT INTO `address_book` VALUES (32, 30, 'f', '', 'Claire', 'Butterfill', '6 Ashdene Gardens', 'Ashington', 'RH20 3JA', 'West Sussex', 'UK', 222, 0);
INSERT INTO `address_book` VALUES (33, 31, 'f', '', 'kelly', 'winchester', '27a high street', 'Chipping sodbury', 'bs376ba', 'bristol', 'uk', 222, 0);
INSERT INTO `address_book` VALUES (34, 32, 'm', '', 'ramshyam', 'shyam', 'india', '', '302015', 'india', 'india', 99, 0);
INSERT INTO `address_book` VALUES (35, 33, 'f', 'GO Designs', 'Karen', 'Green', 'Caldwell House, Barkham Road', '', 'RG41 4TH', 'Wokingham', 'Berkshire', 222, 0);
INSERT INTO `address_book` VALUES (36, 34, 'f', 'Focus Interiors', 'Patricia', 'Maggs', '11 Manor Close', '', 'Bn42 4nw', 'Brighton', 'East Sussex', 222, 0);
INSERT INTO `address_book` VALUES (37, 35, 'm', '', 'simon', 'wiggins', '20 madehurst close', '', 'bn20yr', 'brighton', 'east sussex', 222, 0);
INSERT INTO `address_book` VALUES (38, 36, 'f', '', 'Rebecca', 'Wells', '145 Edgewood Dr Apt #3', '', '35630', 'Florence', '', 223, 1);
INSERT INTO `address_book` VALUES (39, 37, 'f', '', 'Tes', 'Mcsharpe', 'The Shed', '17 Hill Road', 'BA16 8DD', 'Street', 'Somerset', 222, 0);
INSERT INTO `address_book` VALUES (40, 38, 'm', '', 'Neil', 'Tate', '111 Wainbody Avenue South', '', 'CV3 6DA', 'Coventry', 'West Midlands', 222, 0);
INSERT INTO `address_book` VALUES (41, 39, 'm', 'Plah', 'Tom', 'Griffiths', 'nothing', '', 'nothing', 'nowhere', 'nothing', 222, 0);
INSERT INTO `address_book` VALUES (42, 40, 'f', '', 'Jennifer', 'Gill', '5 Wychelm Road', 'Shinfield', 'RG2 9DJ', 'Reading', 'Berkshire', 222, 0);
INSERT INTO `address_book` VALUES (43, 41, 'f', '', 'Brenda', 'Celestine', '37 West Side', '', 'NW4 4XD', 'London', 'Lonodon', 222, 0);
INSERT INTO `address_book` VALUES (44, 42, 'm', '', 'andrew', 'slade', 'LINNET CLOSE', '', 'BN177GW', 'LITTLEHAMPTON', 'WEST SUSSEX', 222, 0);
INSERT INTO `address_book` VALUES (45, 43, 'f', '', 'SUE', 'PALMER', '8 Bairdsley Close', '', 'CT10 1BE', 'Broadstairs', 'Kent', 222, 0);
INSERT INTO `address_book` VALUES (46, 44, 'f', '', 'Nikki', 'Smith', '57 The Estuary', '', 'BN17 6NE', 'Littlehampton', 'West Sussex', 222, 0);
INSERT INTO `address_book` VALUES (47, 45, 'f', '', 'Beverley', 'Center', '61 Abingdon Road', 'Drayton', 'OX14 4HW', 'Abingdon', 'Oxfordshire', 222, 0);
INSERT INTO `address_book` VALUES (48, 46, 'f', '', 'debbie', 'forrest', 'P O Box 3246', '', 'BN16 1XQ', 'Littlehampton', 'West Sussex', 222, 0);
INSERT INTO `address_book` VALUES (49, 47, 'f', 'skincandy', 'hollie', 'shannon', '3 albion street', 'southwick', 'bn42 4dn', 'brighton', 'east sussex', 224, 0);
INSERT INTO `address_book` VALUES (50, 48, 'f', 'arora training & consultancy', 'sunita', 'arora-shah', '29 grasmere avenue', '', 'ha9 8tb', 'london', 'middlesex', 222, 0);
INSERT INTO `address_book` VALUES (51, 49, 'm', '', 'Steve', 'Cross', 'Vine Cot. Ludshott Gr.', 'Headley Down', 'GU35 8BQ', 'Bordon', 'Hants', 222, 0);
INSERT INTO `address_book` VALUES (52, 50, 'm', '', 'Clifford', 'Collier', '3 Roundwood', '', 'BN13 3GZ', 'Worthing', 'West Sussex', 222, 0);
INSERT INTO `address_book` VALUES (53, 51, 'f', '', 'Trish', 'Portas', '20 Douglas Gardens', '', 'PO9 5TG', 'Havant', 'Hampshire', 222, 0);
INSERT INTO `address_book` VALUES (54, 52, 'f', '', 'Victoria', 'Richardson', '1 Beckworth Close', '', 'BN13 3QB', 'Worthing', 'WSx', 222, 0);
INSERT INTO `address_book` VALUES (55, 53, 'f', '', 'sharon', 'reilly', '62 whippingham road', '', 'bn23pg', 'brighton', 'sussex', 222, 0);
INSERT INTO `address_book` VALUES (56, 54, 'f', '', 'Louise', 'Hill', 'flt 2 18 Hartfield Rd', '', 'BN21 2AR', 'Eastbourne', 'East Sussex', 222, 0);
INSERT INTO `address_book` VALUES (57, 55, 'f', '', 'justine', 'matthews', '25 rectory close', '', 'rh203lp', 'ashington', 'west sussex', 222, 0);
INSERT INTO `address_book` VALUES (58, 56, 'm', '', 'ADRIAN', 'DAVEY', 'the old bakery', 'newbridge road east', 'rh149lp', 'billingshurst', 'west sussex', 222, 0);
INSERT INTO `address_book` VALUES (59, 57, 'm', 'Oakhurst Property Developments', 'Paul', 'Heitman', '22/23 Old Burlington Street', '', 'W1S 2JJ', 'London', 'London', 222, 0);
INSERT INTO `address_book` VALUES (60, 58, 'f', 'E Nuff 2 Do', 'Samantha', 'Bertie', '11 Whytings', 'Mannings Heath', 'RH13 6JZ', 'Horsham', 'West Sussex', 222, 0);
INSERT INTO `address_book` VALUES (61, 59, 'f', 'FreedomFlights', 'Bianca', 'Boccia', '8 Groombridge Way', '', 'RH12 1XD', 'Horsham', 'West Sussex', 222, 0);
INSERT INTO `address_book` VALUES (62, 60, 'f', '', 'Beverley', 'Connor', '42 Telfords Yard', '', 'E1W 2BQ', 'London', 'London', 222, 0);
INSERT INTO `address_book` VALUES (63, 61, 'f', '', 'liz', 'williams', 'flat 10, st michaels lodge, 1 st michaels road', '', 'bn11 4sd', 'worthing', 'west sussex', 222, 0);
INSERT INTO `address_book` VALUES (64, 62, 'f', '', 'jodi', 'riches', '83 vincent square', '', 'SW1P 2PF', 'london', 'London', 222, 0);
INSERT INTO `address_book` VALUES (65, 63, 'f', '', 'Barbara', 'Lake', '3 Blackthorn Close', '', 'RH13 6BL', 'Horsham', 'Sussex', 222, 0);
INSERT INTO `address_book` VALUES (66, 64, 'f', '', 'Tracy', 'Jones', '206 Bannings Vale', 'Saltdean', 'BN2 8DJ', 'Brighton', 'East Sussex', 222, 0);

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

#
# Table structure for table `address_format`
#

CREATE TABLE `address_format` (
  `address_format_id` int(11) NOT NULL auto_increment,
  `address_format` varchar(128) NOT NULL default '',
  `address_summary` varchar(48) NOT NULL default '',
  PRIMARY KEY  (`address_format_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

#
# Dumping data for table `address_format`
#

INSERT INTO `address_format` VALUES (1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country', '$city / $country');
INSERT INTO `address_format` VALUES (2, '$firstname $lastname$cr$streets$cr$city, $state    $postcode$cr$country', '$city, $state / $country');
INSERT INTO `address_format` VALUES (3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country', '$state / $country');
INSERT INTO `address_format` VALUES (4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country');
INSERT INTO `address_format` VALUES (5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country', '$city / $country');

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

#
# Table structure for table `banners`
#

CREATE TABLE `banners` (
  `banners_id` int(11) NOT NULL auto_increment,
  `banners_title` varchar(64) NOT NULL default '',
  `banners_url` varchar(255) NOT NULL default '',
  `banners_image` varchar(64) NOT NULL default '',
  `banners_group` varchar(10) NOT NULL default '',
  `banners_html_text` text,
  `expires_impressions` int(7) default '0',
  `expires_date` datetime default NULL,
  `date_scheduled` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_status_change` datetime default NULL,
  `status` int(1) NOT NULL default '1',
  PRIMARY KEY  (`banners_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `banners`
#

INSERT INTO `banners` VALUES (1, 'osCommerce', 'http://www.oscommerce.com', 'banners/oscommerce.gif', '468x50', '', 0, NULL, NULL, '2005-01-20 09:26:36', NULL, 1);

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

#
# Table structure for table `banners_history`
#

CREATE TABLE `banners_history` (
  `banners_history_id` int(11) NOT NULL auto_increment,
  `banners_id` int(11) NOT NULL default '0',
  `banners_shown` int(5) NOT NULL default '0',
  `banners_clicked` int(5) NOT NULL default '0',
  `banners_history_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`banners_history_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

#
# Dumping data for table `banners_history`
#

INSERT INTO `banners_history` VALUES (1, 1, 15, 0, '2005-01-20 09:27:36');
INSERT INTO `banners_history` VALUES (2, 1, 13, 0, '2005-01-26 12:28:00');
INSERT INTO `banners_history` VALUES (3, 1, 30, 0, '2005-02-01 10:48:45');
INSERT INTO `banners_history` VALUES (4, 1, 9, 0, '2005-02-02 09:19:12');
INSERT INTO `banners_history` VALUES (5, 1, 32, 0, '2005-02-03 11:55:08');
INSERT INTO `banners_history` VALUES (6, 1, 16, 0, '2005-02-04 14:54:51');
INSERT INTO `banners_history` VALUES (7, 1, 11, 0, '2005-02-08 10:14:53');
INSERT INTO `banners_history` VALUES (8, 1, 111, 0, '2005-02-09 10:13:34');
INSERT INTO `banners_history` VALUES (9, 1, 192, 0, '2005-02-10 09:57:28');
INSERT INTO `banners_history` VALUES (10, 1, 2, 0, '2005-02-14 14:51:45');
INSERT INTO `banners_history` VALUES (11, 1, 140, 0, '2005-02-15 09:25:16');
INSERT INTO `banners_history` VALUES (12, 1, 409, 0, '2005-02-16 09:37:48');
INSERT INTO `banners_history` VALUES (13, 1, 262, 0, '2005-02-17 08:40:25');
INSERT INTO `banners_history` VALUES (14, 1, 56, 0, '2005-02-18 09:32:19');
INSERT INTO `banners_history` VALUES (15, 1, 1, 0, '2005-02-19 12:50:13');
INSERT INTO `banners_history` VALUES (16, 1, 220, 0, '2005-02-21 10:03:43');
INSERT INTO `banners_history` VALUES (17, 1, 351, 0, '2005-02-22 09:06:01');
INSERT INTO `banners_history` VALUES (18, 1, 16, 0, '2005-02-23 09:02:17');
INSERT INTO `banners_history` VALUES (19, 1, 51, 0, '2005-02-24 11:06:02');
INSERT INTO `banners_history` VALUES (20, 1, 1, 0, '2005-02-27 22:44:09');
INSERT INTO `banners_history` VALUES (21, 1, 478, 2, '2005-02-28 08:51:37');
INSERT INTO `banners_history` VALUES (22, 1, 737, 3, '2005-03-01 08:39:50');
INSERT INTO `banners_history` VALUES (23, 1, 250, 2, '2005-03-02 09:17:40');

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

#
# Table structure for table `categories`
#

CREATE TABLE `categories` (
  `categories_id` int(11) NOT NULL auto_increment,
  `categories_image` varchar(64) default NULL,
  `parent_id` int(11) NOT NULL default '0',
  `sort_order` int(3) default NULL,
  `date_added` datetime default NULL,
  `last_modified` datetime default NULL,
  PRIMARY KEY  (`categories_id`),
  KEY `idx_categories_parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;

#
# Dumping data for table `categories`
#

INSERT INTO `categories` VALUES (32, 'Sho1LrgLshade100x57.jpg', 25, 0, '2005-04-01 16:40:32', '2005-04-05 17:37:36');
INSERT INTO `categories` VALUES (34, 'DinRoomOffersCat100x57v2.jpg', 22, 5, '2005-05-12 13:53:45', '2005-05-12 14:45:43');
INSERT INTO `categories` VALUES (35, 'DinRoomOffersCat100x57v2.jpg', 0, 4, '2005-05-12 16:46:42', '2005-05-12 16:47:20');
INSERT INTO `categories` VALUES (36, 'cushions_subcat.gif', 25, 0, '2005-05-24 16:28:40', NULL);
INSERT INTO `categories` VALUES (37, 'throws_subcat.gif', 25, 0, '2005-05-25 13:00:37', NULL);
INSERT INTO `categories` VALUES (38, 'clocks_subcat.gif', 25, 0, '2005-05-25 13:34:38', '2005-05-25 13:43:42');
INSERT INTO `categories` VALUES (39, 'ornamants_subcat.gif', 25, 0, '2005-05-26 10:17:19', NULL);
INSERT INTO `categories` VALUES (40, 'stools_subcat.gif', 25, 0, '2005-05-26 12:03:59', NULL);
INSERT INTO `categories` VALUES (41, 'beanbag_subcat.gif', 25, 0, '2005-05-26 12:14:50', NULL);
INSERT INTO `categories` VALUES (42, 'bins_subcat.gif', 25, 0, '2005-05-26 13:24:08', '2005-05-26 13:24:40');
INSERT INTO `categories` VALUES (24, 'living_room.gif', 0, 2, '2005-02-01 15:41:57', '2005-02-16 16:26:09');
INSERT INTO `categories` VALUES (22, 'dining_room.gif', 0, 1, '2005-02-01 12:06:00', '2005-05-12 13:56:01');
INSERT INTO `categories` VALUES (23, 'sideboards.gif', 22, 4, '2005-02-01 12:07:34', '2005-02-16 16:23:59');
INSERT INTO `categories` VALUES (25, 'accessories.gif', 0, 3, '2005-02-01 15:43:55', '2005-02-16 16:26:20');
INSERT INTO `categories` VALUES (26, 'tables.gif', 22, 1, '2005-02-01 15:52:20', '2005-02-16 16:22:34');
INSERT INTO `categories` VALUES (27, 'chairs.gif', 22, 2, '2005-02-01 15:52:45', '2005-02-16 16:23:34');
INSERT INTO `categories` VALUES (28, 'cabinets.gif', 22, 3, '2005-02-01 15:53:16', '2005-02-16 16:23:46');
INSERT INTO `categories` VALUES (29, 'occasional_tables.gif', 24, 2, '2005-02-01 15:54:00', '2005-02-16 16:24:31');
INSERT INTO `categories` VALUES (30, 'cabinets.gif', 24, 0, '2005-02-01 15:54:52', '2005-02-16 16:24:21');
INSERT INTO `categories` VALUES (31, 'mirrors.gif', 25, 0, '2005-02-01 15:55:24', '2005-02-16 16:24:48');

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

#
# Table structure for table `categories_description`
#

CREATE TABLE `categories_description` (
  `categories_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `categories_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`categories_id`,`language_id`),
  KEY `idx_categories_name` (`categories_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table `categories_description`
#

INSERT INTO `categories_description` VALUES (24, 1, 'Living Room');
INSERT INTO `categories_description` VALUES (22, 1, 'Dining Room');
INSERT INTO `categories_description` VALUES (23, 1, 'Sideboards');
INSERT INTO `categories_description` VALUES (41, 1, 'Bean Bags / Pods');
INSERT INTO `categories_description` VALUES (40, 1, 'Stools');
INSERT INTO `categories_description` VALUES (25, 1, 'Accessories');
INSERT INTO `categories_description` VALUES (39, 1, 'Ornaments');
INSERT INTO `categories_description` VALUES (26, 1, 'Tables');
INSERT INTO `categories_description` VALUES (38, 1, 'Clocks');
INSERT INTO `categories_description` VALUES (27, 1, 'Chairs');
INSERT INTO `categories_description` VALUES (37, 1, 'Throws');
INSERT INTO `categories_description` VALUES (28, 1, 'Cabinets');
INSERT INTO `categories_description` VALUES (36, 1, 'Cushions');
INSERT INTO `categories_description` VALUES (29, 1, 'Occasional Tables');
INSERT INTO `categories_description` VALUES (35, 1, 'Offers');
INSERT INTO `categories_description` VALUES (30, 1, 'Cabinets');
INSERT INTO `categories_description` VALUES (34, 1, 'Offers');
INSERT INTO `categories_description` VALUES (31, 1, 'Mirrors');
INSERT INTO `categories_description` VALUES (42, 1, 'Bins');
INSERT INTO `categories_description` VALUES (32, 1, 'Lights');

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

#
# Table structure for table `configuration`
#

CREATE TABLE `configuration` (
  `configuration_id` int(11) NOT NULL auto_increment,
  `configuration_title` varchar(64) NOT NULL default '',
  `configuration_key` varchar(64) NOT NULL default '',
  `configuration_value` varchar(255) NOT NULL default '',
  `configuration_description` varchar(255) NOT NULL default '',
  `configuration_group_id` int(11) NOT NULL default '0',
  `sort_order` int(5) default NULL,
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `use_function` varchar(255) default NULL,
  `set_function` varchar(255) default NULL,
  PRIMARY KEY  (`configuration_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=194 ;

#
# Dumping data for table `configuration`
#

INSERT INTO `configuration` VALUES (1, 'Store Name', 'STORE_NAME', 'Marsha\'s', 'The name of my store', 1, 1, '2005-01-20 10:46:18', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (2, 'Store Owner', 'STORE_OWNER', 'Marsha\'s', 'The name of my store owner', 1, 2, '2005-03-02 17:25:58', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (3, 'E-Mail Address', 'STORE_OWNER_EMAIL_ADDRESS', 'info@marshas.co.uk', 'The e-mail address of my store owner', 1, 3, '2005-03-02 17:26:22', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (4, 'E-Mail From', 'EMAIL_FROM', 'Marsha\'s<info@marshas.co.uk>', 'The e-mail address used in (sent) e-mails', 1, 4, '2005-03-02 17:27:24', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (5, 'Country', 'STORE_COUNTRY', '222', 'The country my store is located in <br><br><b>Note: Please remember to update the store zone.</b>', 1, 6, '2005-01-20 10:48:59', '2005-01-20 09:26:36', 'tep_get_country_name', 'tep_cfg_pull_down_country_list(');
INSERT INTO `configuration` VALUES (6, 'Zone', 'STORE_ZONE', '', 'The zone my store is located in', 1, 7, '2005-01-20 10:49:10', '2005-01-20 09:26:36', 'tep_cfg_get_zone_name', 'tep_cfg_pull_down_zone_list(');
INSERT INTO `configuration` VALUES (7, 'Expected Sort Order', 'EXPECTED_PRODUCTS_SORT', 'desc', 'This is the sort order used in the expected products box.', 1, 8, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'asc\', \'desc\'),');
INSERT INTO `configuration` VALUES (8, 'Expected Sort Field', 'EXPECTED_PRODUCTS_FIELD', 'date_expected', 'The column to sort by in the expected products box.', 1, 9, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'products_name\', \'date_expected\'),');
INSERT INTO `configuration` VALUES (9, 'Switch To Default Language Currency', 'USE_DEFAULT_LANGUAGE_CURRENCY', 'false', 'Automatically switch to the language\'s currency when it is changed', 1, 10, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (10, 'Send Extra Order Emails To', 'SEND_EXTRA_ORDER_EMAILS_TO', 'esales@marshas.co.uk', 'Send extra order emails to the following email addresses, in this format: Name 1 &lt;email@address1&gt;, Name 2 &lt;email@address2&gt;', 1, 11, '2005-03-02 17:27:46', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (11, 'Use Search-Engine Safe URLs (still in development)', 'SEARCH_ENGINE_FRIENDLY_URLS', 'false', 'Use search-engine safe urls for all site links', 1, 12, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (12, 'Display Cart After Adding Product', 'DISPLAY_CART', 'true', 'Display the shopping cart after adding a product (or return back to their origin)', 1, 14, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (13, 'Allow Guest To Tell A Friend', 'ALLOW_GUEST_TO_TELL_A_FRIEND', 'true', 'Allow guests to tell a friend about a product', 1, 15, '2005-03-10 11:23:03', '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (14, 'Default Search Operator', 'ADVANCED_SEARCH_DEFAULT_OPERATOR', 'and', 'Default search operators', 1, 17, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'and\', \'or\'),');
INSERT INTO `configuration` VALUES (15, 'Store Address and Phone', 'STORE_NAME_ADDRESS', 'Marsha\'s\r\n14 Avis Way\r\nNewhaven\r\nBrighton\r\nEast Sussex\r\nBN9 0DP\r\n\r\nTel:  01273 612800\r\nFax: 01273 612500\r\nEmail: info@marshas.co.uk', 'This is the Store Name, Address and Phone used on printable documents and displayed online', 1, 18, '2005-06-06 14:11:35', '2005-01-20 09:26:36', NULL, 'tep_cfg_textarea(');
INSERT INTO `configuration` VALUES (16, 'Show Category Counts', 'SHOW_COUNTS', 'false', 'Count recursively how many products are in each category', 1, 19, '2005-03-02 17:28:18', '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (17, 'Tax Decimal Places', 'TAX_DECIMAL_PLACES', '0', 'Pad the tax value this amount of decimal places', 1, 20, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (18, 'Display Prices with Tax', 'DISPLAY_PRICE_WITH_TAX', 'true', 'Display prices with tax included (true) or add the tax at the end (false)', 1, 21, '2005-03-03 13:19:42', '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (19, 'First Name', 'ENTRY_FIRST_NAME_MIN_LENGTH', '2', 'Minimum length of first name', 2, 1, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (20, 'Last Name', 'ENTRY_LAST_NAME_MIN_LENGTH', '2', 'Minimum length of last name', 2, 2, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (21, 'Date of Birth', 'ENTRY_DOB_MIN_LENGTH', '10', 'Minimum length of date of birth', 2, 3, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (22, 'E-Mail Address', 'ENTRY_EMAIL_ADDRESS_MIN_LENGTH', '6', 'Minimum length of e-mail address', 2, 4, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (23, 'Street Address', 'ENTRY_STREET_ADDRESS_MIN_LENGTH', '5', 'Minimum length of street address', 2, 5, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (24, 'Company', 'ENTRY_COMPANY_MIN_LENGTH', '2', 'Minimum length of company name', 2, 6, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (25, 'Post Code', 'ENTRY_POSTCODE_MIN_LENGTH', '4', 'Minimum length of post code', 2, 7, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (26, 'City', 'ENTRY_CITY_MIN_LENGTH', '3', 'Minimum length of city', 2, 8, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (27, 'State', 'ENTRY_STATE_MIN_LENGTH', '2', 'Minimum length of state', 2, 9, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (28, 'Telephone Number', 'ENTRY_TELEPHONE_MIN_LENGTH', '3', 'Minimum length of telephone number', 2, 10, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (29, 'Password', 'ENTRY_PASSWORD_MIN_LENGTH', '5', 'Minimum length of password', 2, 11, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (30, 'Credit Card Owner Name', 'CC_OWNER_MIN_LENGTH', '3', 'Minimum length of credit card owner name', 2, 12, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (31, 'Credit Card Number', 'CC_NUMBER_MIN_LENGTH', '10', 'Minimum length of credit card number', 2, 13, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (32, 'Review Text', 'REVIEW_TEXT_MIN_LENGTH', '15', 'Minimum length of review text', 2, 14, '2005-03-01 15:14:52', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (33, 'Best Sellers', 'MIN_DISPLAY_BESTSELLERS', '1', 'Minimum number of best sellers to display', 2, 15, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (34, 'Also Purchased', 'MIN_DISPLAY_ALSO_PURCHASED', '1', 'Minimum number of products to display in the \'This Customer Also Purchased\' box', 2, 16, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (35, 'Address Book Entries', 'MAX_ADDRESS_BOOK_ENTRIES', '5', 'Maximum address book entries a customer is allowed to have', 3, 1, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (36, 'Search Results', 'MAX_DISPLAY_SEARCH_RESULTS', '4', 'Amount of products to list', 3, 2, '2005-02-28 17:00:52', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (37, 'Page Links', 'MAX_DISPLAY_PAGE_LINKS', '5', 'Number of \'number\' links use for page-sets', 3, 3, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (38, 'Special Products', 'MAX_DISPLAY_SPECIAL_PRODUCTS', '9', 'Maximum number of products on special to display', 3, 4, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (39, 'New Products Module', 'MAX_DISPLAY_NEW_PRODUCTS', '0', 'Maximum number of new products to display in a category', 3, 5, '2005-02-16 18:51:48', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (40, 'Products Expected', 'MAX_DISPLAY_UPCOMING_PRODUCTS', '0', 'Maximum number of products expected to display', 3, 6, '2005-02-22 20:13:21', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (41, 'Manufacturers List', 'MAX_DISPLAY_MANUFACTURERS_IN_A_LIST', '0', 'Used in manufacturers box; when the number of manufacturers exceeds this number, a drop-down list will be displayed instead of the default list', 3, 7, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (42, 'Manufacturers Select Size', 'MAX_MANUFACTURERS_LIST', '1', 'Used in manufacturers box; when this value is \'1\' the classic drop-down list will be used for the manufacturers box. Otherwise, a list-box with the specified number of rows will be displayed.', 3, 7, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (43, 'Length of Manufacturers Name', 'MAX_DISPLAY_MANUFACTURER_NAME_LEN', '15', 'Used in manufacturers box; maximum length of manufacturers name to display', 3, 8, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (44, 'New Reviews', 'MAX_DISPLAY_NEW_REVIEWS', '1', 'Maximum number of new reviews to display', 3, 9, '2005-03-01 14:57:59', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (45, 'Selection of Random Reviews', 'MAX_RANDOM_SELECT_REVIEWS', '1', 'How many records to select from to choose one random product review', 3, 10, '2005-03-01 14:57:26', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (46, 'Selection of Random New Products', 'MAX_RANDOM_SELECT_NEW', '0', 'How many records to select from to choose one random new product to display', 3, 11, '2005-02-22 11:42:11', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (47, 'Selection of Products on Special', 'MAX_RANDOM_SELECT_SPECIALS', '0', 'How many records to select from to choose one random product special to display', 3, 12, '2005-02-22 11:42:19', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (48, 'Categories To List Per Row', 'MAX_DISPLAY_CATEGORIES_PER_ROW', '4', 'How many categories to list per row', 3, 13, '2005-02-16 18:50:04', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (49, 'New Products Listing', 'MAX_DISPLAY_PRODUCTS_NEW', '1', 'Maximum number of new products to display in new products page', 3, 14, '2005-03-01 16:54:45', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (50, 'Best Sellers', 'MAX_DISPLAY_BESTSELLERS', '0', 'Maximum number of best sellers to display', 3, 15, '2005-02-22 11:42:27', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (51, 'Also Purchased', 'MAX_DISPLAY_ALSO_PURCHASED', '0', 'Maximum number of products to display in the \'This Customer Also Purchased\' box', 3, 16, '2005-02-22 11:42:39', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (52, 'Customer Order History Box', 'MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX', '0', 'Maximum number of products to display in the customer order history box', 3, 17, '2005-02-22 11:42:58', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (53, 'Order History', 'MAX_DISPLAY_ORDER_HISTORY', '10', 'Maximum number of orders to display in the order history page', 3, 18, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (54, 'Small Image Width', 'SMALL_IMAGE_WIDTH', '140', 'The pixel width of small images', 4, 1, '2005-02-16 18:00:16', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (55, 'Small Image Height', 'SMALL_IMAGE_HEIGHT', '120', 'The pixel height of small images', 4, 2, '2005-02-16 18:00:24', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (56, 'Heading Image Width', 'HEADING_IMAGE_WIDTH', '57', 'The pixel width of heading images', 4, 3, '2005-05-25 13:53:52', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (57, 'Heading Image Height', 'HEADING_IMAGE_HEIGHT', '40', 'The pixel height of heading images', 4, 4, '2005-05-25 13:54:04', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (58, 'Subcategory Image Width', 'SUBCATEGORY_IMAGE_WIDTH', '100', 'The pixel width of subcategory images', 4, 5, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (59, 'Subcategory Image Height', 'SUBCATEGORY_IMAGE_HEIGHT', '57', 'The pixel height of subcategory images', 4, 6, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (60, 'Calculate Image Size', 'CONFIG_CALCULATE_IMAGE_SIZE', 'false', 'Calculate the size of images?', 4, 7, '2005-05-25 13:44:44', '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (61, 'Image Required', 'IMAGE_REQUIRED', 'true', 'Enable to display broken images. Good for development.', 4, 8, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (62, 'Gender', 'ACCOUNT_GENDER', 'true', 'Display gender in the customers account', 5, 1, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (63, 'Date of Birth', 'ACCOUNT_DOB', 'true', 'Display date of birth in the customers account', 5, 2, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (64, 'Company', 'ACCOUNT_COMPANY', 'true', 'Display company in the customers account', 5, 3, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (65, 'Suburb', 'ACCOUNT_SUBURB', 'true', 'Display suburb in the customers account', 5, 4, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (66, 'State', 'ACCOUNT_STATE', 'true', 'Display state in the customers account', 5, 5, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (67, 'Installed Modules', 'MODULE_PAYMENT_INSTALLED', 'ePDQ.php', 'List of payment module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: cc.php;cod.php;paypal.php)', 6, 0, '2005-05-13 09:48:32', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (68, 'Installed Modules', 'MODULE_ORDER_TOTAL_INSTALLED', 'ot_subtotal.php;ot_shipping.php;ot_tax.php;ot_total.php', 'List of order_total module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php)', 6, 0, '2005-02-16 17:32:39', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (69, 'Installed Modules', 'MODULE_SHIPPING_INSTALLED', 'flat.php;item.php;table.php;zones.php', 'List of shipping module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ups.php;flat.php;item.php)', 6, 0, '2005-06-16 09:35:39', '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (171, 'Shipping Zone', 'MODULE_SHIPPING_TABLE_ZONE', '0', 'If a zone is selected, only enable this shipping method for that zone.', 6, 0, NULL, '2005-04-03 12:37:02', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(');
INSERT INTO `configuration` VALUES (170, 'Tax Class', 'MODULE_SHIPPING_TABLE_TAX_CLASS', '1', 'Use the following tax class on the shipping fee.', 6, 0, NULL, '2005-04-03 12:37:02', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(');
INSERT INTO `configuration` VALUES (168, 'Table Method', 'MODULE_SHIPPING_TABLE_MODE', 'price', 'The shipping cost is based on the order total or the total weight of the items ordered.', 6, 0, NULL, '2005-04-03 12:37:02', NULL, 'tep_cfg_select_option(array(\'weight\', \'price\'),');
INSERT INTO `configuration` VALUES (169, 'Handling Fee', 'MODULE_SHIPPING_TABLE_HANDLING', '0', 'Handling fee for this shipping method.', 6, 0, NULL, '2005-04-03 12:37:02', NULL, NULL);
INSERT INTO `configuration` VALUES (79, 'Enable Flat Shipping', 'MODULE_SHIPPING_FLAT_STATUS', 'False', 'Do you want to offer flat rate shipping?', 6, 0, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` VALUES (80, 'Shipping Cost', 'MODULE_SHIPPING_FLAT_COST', '59.58', 'The shipping cost for all orders using this shipping method.', 6, 0, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (81, 'Tax Class', 'MODULE_SHIPPING_FLAT_TAX_CLASS', '1', 'Use the following tax class on the shipping fee.', 6, 0, NULL, '2005-01-20 09:26:36', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(');
INSERT INTO `configuration` VALUES (82, 'Shipping Zone', 'MODULE_SHIPPING_FLAT_ZONE', '1', 'If a zone is selected, only enable this shipping method for that zone.', 6, 0, NULL, '2005-01-20 09:26:36', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(');
INSERT INTO `configuration` VALUES (83, 'Sort Order', 'MODULE_SHIPPING_FLAT_SORT_ORDER', '0', 'Sort order of display.', 6, 0, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (84, 'Default Currency', 'DEFAULT_CURRENCY', 'GBP', 'Default Currency', 6, 0, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (85, 'Default Language', 'DEFAULT_LANGUAGE', 'en', 'Default Language', 6, 0, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (86, 'Default Order Status For New Orders', 'DEFAULT_ORDERS_STATUS_ID', '1', 'When a new order is created, this order status will be assigned to it.', 6, 0, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (87, 'Display Shipping', 'MODULE_ORDER_TOTAL_SHIPPING_STATUS', 'true', 'Do you want to display the order shipping cost?', 6, 1, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (88, 'Sort Order', 'MODULE_ORDER_TOTAL_SHIPPING_SORT_ORDER', '2', 'Sort order of display.', 6, 2, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (89, 'Allow Free Shipping', 'MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING', 'false', 'Do you want to allow free shipping?', 6, 3, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (90, 'Free Shipping For Orders Over', 'MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER', '50', 'Provide free shipping for orders over the set amount.', 6, 4, NULL, '2005-01-20 09:26:36', 'currencies->format', NULL);
INSERT INTO `configuration` VALUES (91, 'Provide Free Shipping For Orders Made', 'MODULE_ORDER_TOTAL_SHIPPING_DESTINATION', 'national', 'Provide free shipping for orders sent to the set destination.', 6, 5, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'national\', \'international\', \'both\'),');
INSERT INTO `configuration` VALUES (92, 'Display Sub-Total', 'MODULE_ORDER_TOTAL_SUBTOTAL_STATUS', 'true', 'Do you want to display the order sub-total cost?', 6, 1, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (93, 'Sort Order', 'MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER', '1', 'Sort order of display.', 6, 2, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (94, 'Display Tax', 'MODULE_ORDER_TOTAL_TAX_STATUS', 'true', 'Do you want to display the order tax value?', 6, 1, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (95, 'Sort Order', 'MODULE_ORDER_TOTAL_TAX_SORT_ORDER', '3', 'Sort order of display.', 6, 2, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (96, 'Display Total', 'MODULE_ORDER_TOTAL_TOTAL_STATUS', 'true', 'Do you want to display the total order value?', 6, 1, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (97, 'Sort Order', 'MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER', '4', 'Sort order of display.', 6, 2, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (98, 'Country of Origin', 'SHIPPING_ORIGIN_COUNTRY', '222', 'Select the country of origin to be used in shipping quotes.', 7, 1, '2005-01-20 10:54:18', '2005-01-20 09:26:36', 'tep_get_country_name', 'tep_cfg_pull_down_country_list(');
INSERT INTO `configuration` VALUES (99, 'Postal Code', 'SHIPPING_ORIGIN_ZIP', 'NONE', 'Enter the Postal Code (ZIP) of the Store to be used in shipping quotes.', 7, 2, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (100, 'Enter the Maximum Package Weight you will ship', 'SHIPPING_MAX_WEIGHT', '50', 'Carriers have a max weight limit for a single package. This is a common one for all.', 7, 3, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (101, 'Package Tare weight.', 'SHIPPING_BOX_WEIGHT', '3', 'What is the weight of typical packaging of small to medium packages?', 7, 4, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (102, 'Larger packages - percentage increase.', 'SHIPPING_BOX_PADDING', '10', 'For 10% enter 10', 7, 5, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (103, 'Display Product Image', 'PRODUCT_LIST_IMAGE', '1', 'Do you want to display the Product Image?', 8, 1, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (104, 'Display Product Manufaturer Name', 'PRODUCT_LIST_MANUFACTURER', '0', 'Do you want to display the Product Manufacturer Name?', 8, 2, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (105, 'Display Product Model', 'PRODUCT_LIST_MODEL', '0', 'Do you want to display the Product Model?', 8, 3, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (106, 'Display Product Name', 'PRODUCT_LIST_NAME', '2', 'Do you want to display the Product Name?', 8, 4, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (107, 'Display Product Price', 'PRODUCT_LIST_PRICE', '3', 'Do you want to display the Product Price', 8, 5, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (108, 'Display Product Quantity', 'PRODUCT_LIST_QUANTITY', '0', 'Do you want to display the Product Quantity?', 8, 6, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (109, 'Display Product Weight', 'PRODUCT_LIST_WEIGHT', '0', 'Do you want to display the Product Weight?', 8, 7, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (110, 'Display Buy Now column', 'PRODUCT_LIST_BUY_NOW', '4', 'Do you want to display the Buy Now column?', 8, 8, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (111, 'Display Category/Manufacturer Filter (0=disable; 1=enable)', 'PRODUCT_LIST_FILTER', '1', 'Do you want to display the Category/Manufacturer Filter?', 8, 9, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (112, 'Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 'PREV_NEXT_BAR_LOCATION', '2', 'Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 8, 10, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (113, 'Check stock level', 'STOCK_CHECK', 'true', 'Check to see if sufficent stock is available', 9, 1, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (114, 'Subtract stock', 'STOCK_LIMITED', 'true', 'Subtract product in stock by product orders', 9, 2, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (115, 'Allow Checkout', 'STOCK_ALLOW_CHECKOUT', 'true', 'Allow customer to checkout even if there is insufficient stock', 9, 3, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (116, 'Mark product out of stock', 'STOCK_MARK_PRODUCT_OUT_OF_STOCK', '***', 'Display something on screen so customer can see which product has insufficient stock', 9, 4, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (117, 'Stock Re-order level', 'STOCK_REORDER_LEVEL', '5', 'Define when stock needs to be re-ordered', 9, 5, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (118, 'Store Page Parse Time', 'STORE_PAGE_PARSE_TIME', 'false', 'Store the time it takes to parse a page', 10, 1, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (119, 'Log Destination', 'STORE_PAGE_PARSE_TIME_LOG', '/var/log/www/tep/page_parse_time.log', 'Directory and filename of the page parse time log', 10, 2, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (120, 'Log Date Format', 'STORE_PARSE_DATE_TIME_FORMAT', '%d/%m/%Y %H:%M:%S', 'The date format', 10, 3, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (121, 'Display The Page Parse Time', 'DISPLAY_PAGE_PARSE_TIME', 'true', 'Display the page parse time (store page parse time must be enabled)', 10, 4, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (122, 'Store Database Queries', 'STORE_DB_TRANSACTIONS', 'false', 'Store the database queries in the page parse time log (PHP4 only)', 10, 5, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (123, 'Use Cache', 'USE_CACHE', 'false', 'Use caching features', 11, 1, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (124, 'Cache Directory', 'DIR_FS_CACHE', '/tmp/', 'The directory where the cached files are saved', 11, 2, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (125, 'E-Mail Transport Method', 'EMAIL_TRANSPORT', 'sendmail', 'Defines if this server uses a local connection to sendmail or uses an SMTP connection via TCP/IP. Servers running on Windows and MacOS should change this setting to SMTP.', 12, 1, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'sendmail\', \'smtp\'),');
INSERT INTO `configuration` VALUES (126, 'E-Mail Linefeeds', 'EMAIL_LINEFEED', 'LF', 'Defines the character sequence used to separate mail headers.', 12, 2, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'LF\', \'CRLF\'),');
INSERT INTO `configuration` VALUES (127, 'Use MIME HTML When Sending Emails', 'EMAIL_USE_HTML', 'false', 'Send e-mails in HTML format', 12, 3, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (128, 'Verify E-Mail Addresses Through DNS', 'ENTRY_EMAIL_ADDRESS_CHECK', 'false', 'Verify e-mail address through a DNS server', 12, 4, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (129, 'Send E-Mails', 'SEND_EMAILS', 'true', 'Send out e-mails', 12, 5, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (130, 'Enable download', 'DOWNLOAD_ENABLED', 'false', 'Enable the products download functions.', 13, 1, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (131, 'Download by redirect', 'DOWNLOAD_BY_REDIRECT', 'false', 'Use browser redirection for download. Disable on non-Unix systems.', 13, 2, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (132, 'Expiry delay (days)', 'DOWNLOAD_MAX_DAYS', '7', 'Set number of days before the download link expires. 0 means no limit.', 13, 3, NULL, '2005-01-20 09:26:36', NULL, '');
INSERT INTO `configuration` VALUES (133, 'Maximum number of downloads', 'DOWNLOAD_MAX_COUNT', '5', 'Set the maximum number of downloads. 0 means no download authorized.', 13, 4, NULL, '2005-01-20 09:26:36', NULL, '');
INSERT INTO `configuration` VALUES (134, 'Enable GZip Compression', 'GZIP_COMPRESSION', 'false', 'Enable HTTP GZip compression.', 14, 1, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` VALUES (135, 'Compression Level', 'GZIP_LEVEL', '5', 'Use this compression level 0-9 (0 = minimum, 9 = maximum).', 14, 2, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (136, 'Session Directory', 'SESSION_WRITE_DIRECTORY', '/tmp', 'If sessions are file based, store them in this directory.', 15, 1, NULL, '2005-01-20 09:26:36', NULL, NULL);
INSERT INTO `configuration` VALUES (137, 'Force Cookie Use', 'SESSION_FORCE_COOKIE_USE', 'False', 'Force the use of sessions when cookies are only enabled.', 15, 2, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` VALUES (138, 'Check SSL Session ID', 'SESSION_CHECK_SSL_SESSION_ID', 'False', 'Validate the SSL_SESSION_ID on every secure HTTPS page request.', 15, 3, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` VALUES (139, 'Check User Agent', 'SESSION_CHECK_USER_AGENT', 'False', 'Validate the clients browser user agent on every page request.', 15, 4, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` VALUES (140, 'Check IP Address', 'SESSION_CHECK_IP_ADDRESS', 'False', 'Validate the clients IP address on every page request.', 15, 5, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` VALUES (141, 'Prevent Spider Sessions', 'SESSION_BLOCK_SPIDERS', 'False', 'Prevent known spiders from starting a session.', 15, 6, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` VALUES (142, 'Recreate Session', 'SESSION_RECREATE', 'False', 'Recreate the session to generate a new session ID when the customer logs on or creates an account (PHP >=4.1 needed).', 15, 7, NULL, '2005-01-20 09:26:36', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` VALUES (143, 'Allow EPDQ', 'MODULE_PAYMENT_EPDQ_STATUS', '1', 'Do you want to accept EPDQ payments?', 6, 1, NULL, '2005-01-20 09:58:45', NULL, NULL);
INSERT INTO `configuration` VALUES (144, 'Merchant ID', 'MODULE_PAYMENT_EPDQ_MERCHANT_ID', '14170', 'Your EPDQ ID. Get one from www.EPDQ.com', 6, 2, NULL, '2005-01-20 09:58:45', NULL, NULL);
INSERT INTO `configuration` VALUES (145, 'Merchant Pass Phrase', 'MODULE_PAYMENT_EPDQ_PWD', 'mar5ha5', 'Your EPDQ pwd. Get one from www.EPDQ.com', 6, 3, NULL, '2005-01-20 09:58:45', NULL, NULL);
INSERT INTO `configuration` VALUES (146, 'EPDQ Currency', 'MODULE_PAYMENT_EPDQ_CURRENCY', '826', 'The currency EPDQ should charge in. Only supports GBP (826) at the moment.', 6, 4, NULL, '2005-01-20 09:58:45', NULL, NULL);
INSERT INTO `configuration` VALUES (147, 'EPDQ Charge Type', 'MODULE_PAYMENT_EPDQ_CHARGE_TYPE', 'Auth', 'The charge type.', 6, 5, NULL, '2005-01-20 09:58:45', NULL, NULL);
INSERT INTO `configuration` VALUES (148, 'EPDQ OID', 'MODULE_PAYMENT_EPDQ_OID', '1234567', 'Helps create a unique OID.', 6, 6, NULL, '2005-01-20 09:58:45', NULL, NULL);
INSERT INTO `configuration` VALUES (149, 'EPDQ ReturnURL', 'MODULE_PAYMENT_EPDQ_RETURNURL', 'epdq_success.php', 'Return URL page', 6, 7, NULL, '2005-01-20 09:58:45', NULL, NULL);
INSERT INTO `configuration` VALUES (150, 'EPDQ return URL limit', 'MODULE_PAYMENT_EPDQ_LIMIT', '100', 'The wait before EPDQ re-directs back to ReturnURL (1000 == 1 second)', 6, 8, NULL, '2005-01-20 09:58:45', NULL, NULL);
INSERT INTO `configuration` VALUES (151, 'EPDQ Display Name', 'MODULE_PAYMENT_EPDQ_DISPLAY_NAME', 'Marshas', 'This is the company name displayed on the ePDQ payment collection page', 6, 9, NULL, '2005-01-20 09:58:45', NULL, NULL);
INSERT INTO `configuration` VALUES (152, 'Sort Order of display', 'MODULE_PAYMENT_EPDQ_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', 6, 10, NULL, '2005-01-20 09:58:45', NULL, NULL);
INSERT INTO `configuration` VALUES (166, 'Enable Table Method', 'MODULE_SHIPPING_TABLE_STATUS', 'True', 'Do you want to offer table rate shipping?', 6, 0, NULL, '2005-04-03 12:37:02', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` VALUES (167, 'Shipping Table', 'MODULE_SHIPPING_TABLE_COST', '50:12.77,95:21.28,195:25.53,395:38.30,495:46.81,595:55.32,695:63.83,10000:85.11', 'The shipping cost is based on the total cost or weight of items. Example: 25:8.50,50:5.50,etc.. Up to 25 charge 8.50, from there to 50 charge 5.50, etc', 6, 0, NULL, '2005-04-03 12:37:02', NULL, NULL);
INSERT INTO `configuration` VALUES (172, 'Sort Order', 'MODULE_SHIPPING_TABLE_SORT_ORDER', '0', 'Sort order of display.', 6, 0, NULL, '2005-04-03 12:37:02', NULL, NULL);
INSERT INTO `configuration` VALUES (184, 'Handling Fee', 'MODULE_SHIPPING_ITEM_HANDLING', '0', 'Handling fee for this shipping method.', 6, 0, NULL, '2005-06-16 09:35:05', NULL, NULL);
INSERT INTO `configuration` VALUES (185, 'Tax Class', 'MODULE_SHIPPING_ITEM_TAX_CLASS', '0', 'Use the following tax class on the shipping fee.', 6, 0, NULL, '2005-06-16 09:35:05', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(');
INSERT INTO `configuration` VALUES (186, 'Shipping Zone', 'MODULE_SHIPPING_ITEM_ZONE', '0', 'If a zone is selected, only enable this shipping method for that zone.', 6, 0, NULL, '2005-06-16 09:35:05', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(');
INSERT INTO `configuration` VALUES (183, 'Shipping Cost', 'MODULE_SHIPPING_ITEM_COST', '2.50', 'The shipping cost will be multiplied by the number of items in an order that uses this shipping method.', 6, 0, NULL, '2005-06-16 09:35:05', NULL, NULL);
INSERT INTO `configuration` VALUES (182, 'Enable Item Shipping', 'MODULE_SHIPPING_ITEM_STATUS', 'False', 'Do you want to offer per item rate shipping?', 6, 0, NULL, '2005-06-16 09:35:05', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` VALUES (187, 'Sort Order', 'MODULE_SHIPPING_ITEM_SORT_ORDER', '0', 'Sort order of display.', 6, 0, NULL, '2005-06-16 09:35:05', NULL, NULL);
INSERT INTO `configuration` VALUES (188, 'Enable Zones Method', 'MODULE_SHIPPING_ZONES_STATUS', 'False', 'Do you want to offer zone rate shipping?', 6, 0, NULL, '2005-06-16 09:35:39', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` VALUES (189, 'Tax Class', 'MODULE_SHIPPING_ZONES_TAX_CLASS', '0', 'Use the following tax class on the shipping fee.', 6, 0, NULL, '2005-06-16 09:35:39', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(');
INSERT INTO `configuration` VALUES (190, 'Sort Order', 'MODULE_SHIPPING_ZONES_SORT_ORDER', '0', 'Sort order of display.', 6, 0, NULL, '2005-06-16 09:35:39', NULL, NULL);
INSERT INTO `configuration` VALUES (191, 'Zone 1 Countries', 'MODULE_SHIPPING_ZONES_COUNTRIES_1', 'US,CA', 'Comma separated list of two character ISO country codes that are part of Zone 1.', 6, 0, NULL, '2005-06-16 09:35:39', NULL, NULL);
INSERT INTO `configuration` VALUES (192, 'Zone 1 Shipping Table', 'MODULE_SHIPPING_ZONES_COST_1', '3:8.50,7:10.50,99:20.00', 'Shipping rates to Zone 1 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 1 destinations.', 6, 0, NULL, '2005-06-16 09:35:39', NULL, NULL);
INSERT INTO `configuration` VALUES (193, 'Zone 1 Handling Fee', 'MODULE_SHIPPING_ZONES_HANDLING_1', '0', 'Handling Fee for this shipping zone', 6, 0, NULL, '2005-06-16 09:35:39', NULL, NULL);

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

#
# Table structure for table `configuration_group`
#

CREATE TABLE `configuration_group` (
  `configuration_group_id` int(11) NOT NULL auto_increment,
  `configuration_group_title` varchar(64) NOT NULL default '',
  `configuration_group_description` varchar(255) NOT NULL default '',
  `sort_order` int(5) default NULL,
  `visible` int(1) default '1',
  PRIMARY KEY  (`configuration_group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

#
# Dumping data for table `configuration_group`
#

INSERT INTO `configuration_group` VALUES (1, 'My Store', 'General information about my store', 1, 1);
INSERT INTO `configuration_group` VALUES (2, 'Minimum Values', 'The minimum values for functions / data', 2, 1);
INSERT INTO `configuration_group` VALUES (3, 'Maximum Values', 'The maximum values for functions / data', 3, 1);
INSERT INTO `configuration_group` VALUES (4, 'Images', 'Image parameters', 4, 1);
INSERT INTO `configuration_group` VALUES (5, 'Customer Details', 'Customer account configuration', 5, 1);
INSERT INTO `configuration_group` VALUES (6, 'Module Options', 'Hidden from configuration', 6, 0);
INSERT INTO `configuration_group` VALUES (7, 'Shipping/Packaging', 'Shipping options available at my store', 7, 1);
INSERT INTO `configuration_group` VALUES (8, 'Product Listing', 'Product Listing    configuration options', 8, 1);
INSERT INTO `configuration_group` VALUES (9, 'Stock', 'Stock configuration options', 9, 1);
INSERT INTO `configuration_group` VALUES (10, 'Logging', 'Logging configuration options', 10, 1);
INSERT INTO `configuration_group` VALUES (11, 'Cache', 'Caching configuration options', 11, 1);
INSERT INTO `configuration_group` VALUES (12, 'E-Mail Options', 'General setting for E-Mail transport and HTML E-Mails', 12, 1);
INSERT INTO `configuration_group` VALUES (13, 'Download', 'Downloadable products options', 13, 1);
INSERT INTO `configuration_group` VALUES (14, 'GZip Compression', 'GZip compression options', 14, 1);
INSERT INTO `configuration_group` VALUES (15, 'Sessions', 'Session options', 15, 1);

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

#
# Table structure for table `counter`
#

CREATE TABLE `counter` (
  `startdate` char(8) default NULL,
  `counter` int(12) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table `counter`
#

INSERT INTO `counter` VALUES ('20050120', 51184);

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

#
# Table structure for table `counter_history`
#

CREATE TABLE `counter_history` (
  `month` char(8) default NULL,
  `counter` int(12) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table `counter_history`
#


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

#
# Table structure for table `countries`
#

CREATE TABLE `countries` (
  `countries_id` int(11) NOT NULL auto_increment,
  `countries_name` varchar(64) NOT NULL default '',
  `countries_iso_code_2` char(2) NOT NULL default '',
  `countries_iso_code_3` char(3) NOT NULL default '',
  `address_format_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`countries_id`),
  KEY `IDX_COUNTRIES_NAME` (`countries_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=240 ;

#
# Dumping data for table `countries`
#

INSERT INTO `countries` VALUES (10, 'Argentina', 'AR', 'ARG', 1);
INSERT INTO `countries` VALUES (11, 'Armenia', 'AM', 'ARM', 1);
INSERT INTO `countries` VALUES (12, 'Aruba', 'AW', 'ABW', 1);
INSERT INTO `countries` VALUES (13, 'Australia', 'AU', 'AUS', 1);
INSERT INTO `countries` VALUES (14, 'Austria', 'AT', 'AUT', 5);
INSERT INTO `countries` VALUES (15, 'Azerbaijan', 'AZ', 'AZE', 1);
INSERT INTO `countries` VALUES (16, 'Bahamas', 'BS', 'BHS', 1);
INSERT INTO `countries` VALUES (17, 'Bahrain', 'BH', 'BHR', 1);
INSERT INTO `countries` VALUES (18, 'Bangladesh', 'BD', 'BGD', 1);
INSERT INTO `countries` VALUES (19, 'Barbados', 'BB', 'BRB', 1);
INSERT INTO `countries` VALUES (20, 'Belarus', 'BY', 'BLR', 1);
INSERT INTO `countries` VALUES (21, 'Belgium', 'BE', 'BEL', 1);
INSERT INTO `countries` VALUES (22, 'Belize', 'BZ', 'BLZ', 1);
INSERT INTO `countries` VALUES (23, 'Benin', 'BJ', 'BEN', 1);
INSERT INTO `countries` VALUES (24, 'Bermuda', 'BM', 'BMU', 1);
INSERT INTO `countries` VALUES (25, 'Bhutan', 'BT', 'BTN', 1);
INSERT INTO `countries` VALUES (26, 'Bolivia', 'BO', 'BOL', 1);
INSERT INTO `countries` VALUES (27, 'Bosnia and Herzegowina', 'BA', 'BIH', 1);
INSERT INTO `countries` VALUES (28, 'Botswana', 'BW', 'BWA', 1);
INSERT INTO `countries` VALUES (29, 'Bouvet Island', 'BV', 'BVT', 1);
INSERT INTO `countries` VALUES (30, 'Brazil', 'BR', 'BRA', 1);
INSERT INTO `countries` VALUES (31, 'British Indian Ocean Territory', 'IO', 'IOT', 1);
INSERT INTO `countries` VALUES (32, 'Brunei Darussalam', 'BN', 'BRN', 1);
INSERT INTO `countries` VALUES (33, 'Bulgaria', 'BG', 'BGR', 1);
INSERT INTO `countries` VALUES (34, 'Burkina Faso', 'BF', 'BFA', 1);
INSERT INTO `countries` VALUES (35, 'Burundi', 'BI', 'BDI', 1);
INSERT INTO `countries` VALUES (36, 'Cambodia', 'KH', 'KHM', 1);
INSERT INTO `countries` VALUES (37, 'Cameroon', 'CM', 'CMR', 1);
INSERT INTO `countries` VALUES (38, 'Canada', 'CA', 'CAN', 1);
INSERT INTO `countries` VALUES (39, 'Cape Verde', 'CV', 'CPV', 1);
INSERT INTO `countries` VALUES (40, 'Cayman Islands', 'KY', 'CYM', 1);
INSERT INTO `countries` VALUES (41, 'Central African Republic', 'CF', 'CAF', 1);
INSERT INTO `countries` VALUES (42, 'Chad', 'TD', 'TCD', 1);
INSERT INTO `countries` VALUES (43, 'Chile', 'CL', 'CHL', 1);
INSERT INTO `countries` VALUES (44, 'China', 'CN', 'CHN', 1);
INSERT INTO `countries` VALUES (45, 'Christmas Island', 'CX', 'CXR', 1);
INSERT INTO `countries` VALUES (46, 'Cocos (Keeling) Islands', 'CC', 'CCK', 1);
INSERT INTO `countries` VALUES (47, 'Colombia', 'CO', 'COL', 1);
INSERT INTO `countries` VALUES (48, 'Comoros', 'KM', 'COM', 1);
INSERT INTO `countries` VALUES (49, 'Congo', 'CG', 'COG', 1);
INSERT INTO `countries` VALUES (50, 'Cook Islands', 'CK', 'COK', 1);
INSERT INTO `countries` VALUES (51, 'Costa Rica', 'CR', 'CRI', 1);
INSERT INTO `countries` VALUES (52, 'Cote D\'Ivoire', 'CI', 'CIV', 1);
INSERT INTO `countries` VALUES (53, 'Croatia', 'HR', 'HRV', 1);
INSERT INTO `countries` VALUES (54, 'Cuba', 'CU', 'CUB', 1);
INSERT INTO `countries` VALUES (55, 'Cyprus', 'CY', 'CYP', 1);
INSERT INTO `countries` VALUES (56, 'Czech Republic', 'CZ', 'CZE', 1);
INSERT INTO `countries` VALUES (57, 'Denmark', 'DK', 'DNK', 1);
INSERT INTO `countries` VALUES (58, 'Djibouti', 'DJ', 'DJI', 1);
INSERT INTO `countries` VALUES (59, 'Dominica', 'DM', 'DMA', 1);
INSERT INTO `countries` VALUES (60, 'Dominican Republic', 'DO', 'DOM', 1);
INSERT INTO `countries` VALUES (61, 'East Timor', 'TP', 'TMP', 1);
INSERT INTO `countries` VALUES (62, 'Ecuador', 'EC', 'ECU', 1);
INSERT INTO `countries` VALUES (63, 'Egypt', 'EG', 'EGY', 1);
INSERT INTO `countries` VALUES (64, 'El Salvador', 'SV', 'SLV', 1);
INSERT INTO `countries` VALUES (65, 'Equatorial Guinea', 'GQ', 'GNQ', 1);
INSERT INTO `countries` VALUES (66, 'Eritrea', 'ER', 'ERI', 1);
INSERT INTO `countries` VALUES (67, 'Estonia', 'EE', 'EST', 1);
INSERT INTO `countries` VALUES (68, 'Ethiopia', 'ET', 'ETH', 1);
INSERT INTO `countries` VALUES (69, 'Falkland Islands (Malvinas)', 'FK', 'FLK', 1);
INSERT INTO `countries` VALUES (70, 'Faroe Islands', 'FO', 'FRO', 1);
INSERT INTO `countries` VALUES (71, 'Fiji', 'FJ', 'FJI', 1);
INSERT INTO `countries` VALUES (72, 'Finland', 'FI', 'FIN', 1);
INSERT INTO `countries` VALUES (73, 'France', 'FR', 'FRA', 1);
INSERT INTO `countries` VALUES (74, 'France, Metropolitan', 'FX', 'FXX', 1);
INSERT INTO `countries` VALUES (75, 'French Guiana', 'GF', 'GUF', 1);
INSERT INTO `countries` VALUES (76, 'French Polynesia', 'PF', 'PYF', 1);
INSERT INTO `countries` VALUES (77, 'French Southern Territories', 'TF', 'ATF', 1);
INSERT INTO `countries` VALUES (78, 'Gabon', 'GA', 'GAB', 1);
INSERT INTO `countries` VALUES (79, 'Gambia', 'GM', 'GMB', 1);
INSERT INTO `countries` VALUES (80, 'Georgia', 'GE', 'GEO', 1);
INSERT INTO `countries` VALUES (81, 'Germany', 'DE', 'DEU', 5);
INSERT INTO `countries` VALUES (82, 'Ghana', 'GH', 'GHA', 1);
INSERT INTO `countries` VALUES (83, 'Gibraltar', 'GI', 'GIB', 1);
INSERT INTO `countries` VALUES (84, 'Greece', 'GR', 'GRC', 1);
INSERT INTO `countries` VALUES (85, 'Greenland', 'GL', 'GRL', 1);
INSERT INTO `countries` VALUES (86, 'Grenada', 'GD', 'GRD', 1);
INSERT INTO `countries` VALUES (87, 'Guadeloupe', 'GP', 'GLP', 1);
INSERT INTO `countries` VALUES (88, 'Guam', 'GU', 'GUM', 1);
INSERT INTO `countries` VALUES (89, 'Guatemala', 'GT', 'GTM', 1);
INSERT INTO `countries` VALUES (90, 'Guinea', 'GN', 'GIN', 1);
INSERT INTO `countries` VALUES (91, 'Guinea-bissau', 'GW', 'GNB', 1);
INSERT INTO `countries` VALUES (92, 'Guyana', 'GY', 'GUY', 1);
INSERT INTO `countries` VALUES (93, 'Haiti', 'HT', 'HTI', 1);
INSERT INTO `countries` VALUES (94, 'Heard and Mc Donald Islands', 'HM', 'HMD', 1);
INSERT INTO `countries` VALUES (95, 'Honduras', 'HN', 'HND', 1);
INSERT INTO `countries` VALUES (96, 'Hong Kong', 'HK', 'HKG', 1);
INSERT INTO `countries` VALUES (97, 'Hungary', 'HU', 'HUN', 1);
INSERT INTO `countries` VALUES (98, 'Iceland', 'IS', 'ISL', 1);
INSERT INTO `countries` VALUES (99, 'India', 'IN', 'IND', 1);
INSERT INTO `countries` VALUES (100, 'Indonesia', 'ID', 'IDN', 1);
INSERT INTO `countries` VALUES (101, 'Iran (Islamic Republic of)', 'IR', 'IRN', 1);
INSERT INTO `countries` VALUES (102, 'Iraq', 'IQ', 'IRQ', 1);
INSERT INTO `countries` VALUES (103, 'Ireland', 'IE', 'IRL', 1);
INSERT INTO `countries` VALUES (104, 'Israel', 'IL', 'ISR', 1);
INSERT INTO `countries` VALUES (105, 'Italy', 'IT', 'ITA', 1);
INSERT INTO `countries` VALUES (106, 'Jamaica', 'JM', 'JAM', 1);
INSERT INTO `countries` VALUES (107, 'Japan', 'JP', 'JPN', 1);
INSERT INTO `countries` VALUES (108, 'Jordan', 'JO', 'JOR', 1);
INSERT INTO `countries` VALUES (109, 'Kazakhstan', 'KZ', 'KAZ', 1);
INSERT INTO `countries` VALUES (110, 'Kenya', 'KE', 'KEN', 1);
INSERT INTO `countries` VALUES (111, 'Kiribati', 'KI', 'KIR', 1);
INSERT INTO `countries` VALUES (112, 'Korea, Democratic People\'s Republic of', 'KP', 'PRK', 1);
INSERT INTO `countries` VALUES (113, 'Korea, Republic of', 'KR', 'KOR', 1);
INSERT INTO `countries` VALUES (114, 'Kuwait', 'KW', 'KWT', 1);
INSERT INTO `countries` VALUES (115, 'Kyrgyzstan', 'KG', 'KGZ', 1);
INSERT INTO `countries` VALUES (116, 'Lao People\'s Democratic Republic', 'LA', 'LAO', 1);
INSERT INTO `countries` VALUES (117, 'Latvia', 'LV', 'LVA', 1);
INSERT INTO `countries` VALUES (118, 'Lebanon', 'LB', 'LBN', 1);
INSERT INTO `countries` VALUES (119, 'Lesotho', 'LS', 'LSO', 1);
INSERT INTO `countries` VALUES (120, 'Liberia', 'LR', 'LBR', 1);
INSERT INTO `countries` VALUES (121, 'Libyan Arab Jamahiriya', 'LY', 'LBY', 1);
INSERT INTO `countries` VALUES (122, 'Liechtenstein', 'LI', 'LIE', 1);
INSERT INTO `countries` VALUES (123, 'Lithuania', 'LT', 'LTU', 1);
INSERT INTO `countries` VALUES (124, 'Luxembourg', 'LU', 'LUX', 1);
INSERT INTO `countries` VALUES (125, 'Macau', 'MO', 'MAC', 1);
INSERT INTO `countries` VALUES (126, 'Macedonia, The Former Yugoslav Republic of', 'MK', 'MKD', 1);
INSERT INTO `countries` VALUES (127, 'Madagascar', 'MG', 'MDG', 1);
INSERT INTO `countries` VALUES (128, 'Malawi', 'MW', 'MWI', 1);
INSERT INTO `countries` VALUES (129, 'Malaysia', 'MY', 'MYS', 1);
INSERT INTO `countries` VALUES (130, 'Maldives', 'MV', 'MDV', 1);
INSERT INTO `countries` VALUES (131, 'Mali', 'ML', 'MLI', 1);
INSERT INTO `countries` VALUES (132, 'Malta', 'MT', 'MLT', 1);
INSERT INTO `countries` VALUES (133, 'Marshall Islands', 'MH', 'MHL', 1);
INSERT INTO `countries` VALUES (134, 'Martinique', 'MQ', 'MTQ', 1);
INSERT INTO `countries` VALUES (135, 'Mauritania', 'MR', 'MRT', 1);
INSERT INTO `countries` VALUES (136, 'Mauritius', 'MU', 'MUS', 1);
INSERT INTO `countries` VALUES (137, 'Mayotte', 'YT', 'MYT', 1);
INSERT INTO `countries` VALUES (138, 'Mexico', 'MX', 'MEX', 1);
INSERT INTO `countries` VALUES (139, 'Micronesia, Federated States of', 'FM', 'FSM', 1);
INSERT INTO `countries` VALUES (140, 'Moldova, Republic of', 'MD', 'MDA', 1);
INSERT INTO `countries` VALUES (141, 'Monaco', 'MC', 'MCO', 1);
INSERT INTO `countries` VALUES (142, 'Mongolia', 'MN', 'MNG', 1);
INSERT INTO `countries` VALUES (143, 'Montserrat', 'MS', 'MSR', 1);
INSERT INTO `countries` VALUES (144, 'Morocco', 'MA', 'MAR', 1);
INSERT INTO `countries` VALUES (145, 'Mozambique', 'MZ', 'MOZ', 1);
INSERT INTO `countries` VALUES (146, 'Myanmar', 'MM', 'MMR', 1);
INSERT INTO `countries` VALUES (147, 'Namibia', 'NA', 'NAM', 1);
INSERT INTO `countries` VALUES (148, 'Nauru', 'NR', 'NRU', 1);
INSERT INTO `countries` VALUES (149, 'Nepal', 'NP', 'NPL', 1);
INSERT INTO `countries` VALUES (150, 'Netherlands', 'NL', 'NLD', 1);
INSERT INTO `countries` VALUES (151, 'Netherlands Antilles', 'AN', 'ANT', 1);
INSERT INTO `countries` VALUES (152, 'New Caledonia', 'NC', 'NCL', 1);
INSERT INTO `countries` VALUES (153, 'New Zealand', 'NZ', 'NZL', 1);
INSERT INTO `countries` VALUES (154, 'Nicaragua', 'NI', 'NIC', 1);
INSERT INTO `countries` VALUES (155, 'Niger', 'NE', 'NER', 1);
INSERT INTO `countries` VALUES (156, 'Nigeria', 'NG', 'NGA', 1);
INSERT INTO `countries` VALUES (157, 'Niue', 'NU', 'NIU', 1);
INSERT INTO `countries` VALUES (158, 'Norfolk Island', 'NF', 'NFK', 1);
INSERT INTO `countries` VALUES (159, 'Northern Mariana Islands', 'MP', 'MNP', 1);
INSERT INTO `countries` VALUES (160, 'Norway', 'NO', 'NOR', 1);
INSERT INTO `countries` VALUES (161, 'Oman', 'OM', 'OMN', 1);
INSERT INTO `countries` VALUES (162, 'Pakistan', 'PK', 'PAK', 1);
INSERT INTO `countries` VALUES (163, 'Palau', 'PW', 'PLW', 1);
INSERT INTO `countries` VALUES (164, 'Panama', 'PA', 'PAN', 1);
INSERT INTO `countries` VALUES (165, 'Papua New Guinea', 'PG', 'PNG', 1);
INSERT INTO `countries` VALUES (166, 'Paraguay', 'PY', 'PRY', 1);
INSERT INTO `countries` VALUES (167, 'Peru', 'PE', 'PER', 1);
INSERT INTO `countries` VALUES (168, 'Philippines', 'PH', 'PHL', 1);
INSERT INTO `countries` VALUES (169, 'Pitcairn', 'PN', 'PCN', 1);
INSERT INTO `countries` VALUES (170, 'Poland', 'PL', 'POL', 1);
INSERT INTO `countries` VALUES (171, 'Portugal', 'PT', 'PRT', 1);
INSERT INTO `countries` VALUES (172, 'Puerto Rico', 'PR', 'PRI', 1);
INSERT INTO `countries` VALUES (173, 'Qatar', 'QA', 'QAT', 1);
INSERT INTO `countries` VALUES (174, 'Reunion', 'RE', 'REU', 1);
INSERT INTO `countries` VALUES (175, 'Romania', 'RO', 'ROM', 1);
INSERT INTO `countries` VALUES (176, 'Russian Federation', 'RU', 'RUS', 1);
INSERT INTO `countries` VALUES (177, 'Rwanda', 'RW', 'RWA', 1);
INSERT INTO `countries` VALUES (178, 'Saint Kitts and Nevis', 'KN', 'KNA', 1);
INSERT INTO `countries` VALUES (179, 'Saint Lucia', 'LC', 'LCA', 1);
INSERT INTO `countries` VALUES (180, 'Saint Vincent and the Grenadines', 'VC', 'VCT', 1);
INSERT INTO `countries` VALUES (181, 'Samoa', 'WS', 'WSM', 1);
INSERT INTO `countries` VALUES (182, 'San Marino', 'SM', 'SMR', 1);
INSERT INTO `countries` VALUES (183, 'Sao Tome and Principe', 'ST', 'STP', 1);
INSERT INTO `countries` VALUES (184, 'Saudi Arabia', 'SA', 'SAU', 1);
INSERT INTO `countries` VALUES (185, 'Senegal', 'SN', 'SEN', 1);
INSERT INTO `countries` VALUES (186, 'Seychelles', 'SC', 'SYC', 1);
INSERT INTO `countries` VALUES (187, 'Sierra Leone', 'SL', 'SLE', 1);
INSERT INTO `countries` VALUES (188, 'Singapore', 'SG', 'SGP', 4);
INSERT INTO `countries` VALUES (189, 'Slovakia (Slovak Republic)', 'SK', 'SVK', 1);
INSERT INTO `countries` VALUES (190, 'Slovenia', 'SI', 'SVN', 1);
INSERT INTO `countries` VALUES (191, 'Solomon Islands', 'SB', 'SLB', 1);
INSERT INTO `countries` VALUES (192, 'Somalia', 'SO', 'SOM', 1);
INSERT INTO `countries` VALUES (193, 'South Africa', 'ZA', 'ZAF', 1);
INSERT INTO `countries` VALUES (194, 'South Georgia and the South Sandwich Islands', 'GS', 'SGS', 1);
INSERT INTO `countries` VALUES (195, 'Spain', 'ES', 'ESP', 3);
INSERT INTO `countries` VALUES (196, 'Sri Lanka', 'LK', 'LKA', 1);
INSERT INTO `countries` VALUES (197, 'St. Helena', 'SH', 'SHN', 1);
INSERT INTO `countries` VALUES (198, 'St. Pierre and Miquelon', 'PM', 'SPM', 1);
INSERT INTO `countries` VALUES (199, 'Sudan', 'SD', 'SDN', 1);
INSERT INTO `countries` VALUES (200, 'Suriname', 'SR', 'SUR', 1);
INSERT INTO `countries` VALUES (201, 'Svalbard and Jan Mayen Islands', 'SJ', 'SJM', 1);
INSERT INTO `countries` VALUES (202, 'Swaziland', 'SZ', 'SWZ', 1);
INSERT INTO `countries` VALUES (203, 'Sweden', 'SE', 'SWE', 1);
INSERT INTO `countries` VALUES (204, 'Switzerland', 'CH', 'CHE', 1);
INSERT INTO `countries` VALUES (205, 'Syrian Arab Republic', 'SY', 'SYR', 1);
INSERT INTO `countries` VALUES (206, 'Taiwan', 'TW', 'TWN', 1);
INSERT INTO `countries` VALUES (207, 'Tajikistan', 'TJ', 'TJK', 1);
INSERT INTO `countries` VALUES (208, 'Tanzania, United Republic of', 'TZ', 'TZA', 1);
INSERT INTO `countries` VALUES (209, 'Thailand', 'TH', 'THA', 1);
INSERT INTO `countries` VALUES (210, 'Togo', 'TG', 'TGO', 1);
INSERT INTO `countries` VALUES (211, 'Tokelau', 'TK', 'TKL', 1);
INSERT INTO `countries` VALUES (212, 'Tonga', 'TO', 'TON', 1);
INSERT INTO `countries` VALUES (213, 'Trinidad and Tobago', 'TT', 'TTO', 1);
INSERT INTO `countries` VALUES (214, 'Tunisia', 'TN', 'TUN', 1);
INSERT INTO `countries` VALUES (215, 'Turkey', 'TR', 'TUR', 1);
INSERT INTO `countries` VALUES (216, 'Turkmenistan', 'TM', 'TKM', 1);
INSERT INTO `countries` VALUES (217, 'Turks and Caicos Islands', 'TC', 'TCA', 1);
INSERT INTO `countries` VALUES (218, 'Tuvalu', 'TV', 'TUV', 1);
INSERT INTO `countries` VALUES (219, 'Uganda', 'UG', 'UGA', 1);
INSERT INTO `countries` VALUES (220, 'Ukraine', 'UA', 'UKR', 1);
INSERT INTO `countries` VALUES (221, 'United Arab Emirates', 'AE', 'ARE', 1);
INSERT INTO `countries` VALUES (222, 'United Kingdom', 'GB', 'GBR', 1);
INSERT INTO `countries` VALUES (223, 'United States', 'US', 'USA', 2);
INSERT INTO `countries` VALUES (224, 'United States Minor Outlying Islands', 'UM', 'UMI', 1);
INSERT INTO `countries` VALUES (225, 'Uruguay', 'UY', 'URY', 1);
INSERT INTO `countries` VALUES (226, 'Uzbekistan', 'UZ', 'UZB', 1);
INSERT INTO `countries` VALUES (227, 'Vanuatu', 'VU', 'VUT', 1);
INSERT INTO `countries` VALUES (228, 'Vatican City State (Holy See)', 'VA', 'VAT', 1);
INSERT INTO `countries` VALUES (229, 'Venezuela', 'VE', 'VEN', 1);
INSERT INTO `countries` VALUES (230, 'Viet Nam', 'VN', 'VNM', 1);
INSERT INTO `countries` VALUES (231, 'Virgin Islands (British)', 'VG', 'VGB', 1);
INSERT INTO `countries` VALUES (232, 'Virgin Islands (U.S.)', 'VI', 'VIR', 1);
INSERT INTO `countries` VALUES (233, 'Wallis and Futuna Islands', 'WF', 'WLF', 1);
INSERT INTO `countries` VALUES (234, 'Western Sahara', 'EH', 'ESH', 1);
INSERT INTO `countries` VALUES (235, 'Yemen', 'YE', 'YEM', 1);
INSERT INTO `countries` VALUES (236, 'Yugoslavia', 'YU', 'YUG', 1);
INSERT INTO `countries` VALUES (237, 'Zaire', 'ZR', 'ZAR', 1);
INSERT INTO `countries` VALUES (238, 'Zambia', 'ZM', 'ZMB', 1);
INSERT INTO `countries` VALUES (239, 'Zimbabwe', 'ZW', 'ZWE', 1);

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

#
# Table structure for table `currencies`
#

CREATE TABLE `currencies` (
  `currencies_id` int(11) NOT NULL auto_increment,
  `title` varchar(32) NOT NULL default '',
  `code` char(3) NOT NULL default '',
  `symbol_left` varchar(12) default NULL,
  `symbol_right` varchar(12) default NULL,
  `decimal_point` char(1) default NULL,
  `thousands_point` char(1) default NULL,
  `decimal_places` char(1) default NULL,
  `value` float(13,8) default NULL,
  `last_updated` datetime default NULL,
  PRIMARY KEY  (`currencies_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

#
# Dumping data for table `currencies`
#

INSERT INTO `currencies` VALUES (1, 'British Sterling', 'GBP', '£', '', '.', ',', '2', '1.00000000', '2005-02-01 12:17:08');

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

#
# Table structure for table `customers`
#

CREATE TABLE `customers` (
  `customers_id` int(11) NOT NULL auto_increment,
  `customers_gender` char(1) NOT NULL default '',
  `customers_firstname` varchar(32) NOT NULL default '',
  `customers_lastname` varchar(32) NOT NULL default '',
  `customers_dob` datetime NOT NULL default '0000-00-00 00:00:00',
  `customers_email_address` varchar(96) NOT NULL default '',
  `customers_default_address_id` int(11) NOT NULL default '0',
  `customers_telephone` varchar(32) NOT NULL default '',
  `customers_fax` varchar(32) default NULL,
  `customers_password` varchar(40) NOT NULL default '',
  `customers_newsletter` char(1) default NULL,
  PRIMARY KEY  (`customers_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=65 ;

#
# Dumping data for table `customers`
#

INSERT INTO `customers` VALUES (12, 'm', 'simon', 'rainsford', '1966-10-24 00:00:00', 'simonrainsford@hotmail.com', 14, '0033 2 99 27 28 56', '', '87c77f9808bd7e00c2d1d6ea4a1e6fe7:62', '');
INSERT INTO `customers` VALUES (4, 'm', 'Martin', 'Servante', '1980-02-04 00:00:00', 'martin.servante@marshas.co.uk', 4, '07963803623', '', '8276691fd288d27fb99c1fd48a6c2441:e9', '1');
INSERT INTO `customers` VALUES (15, 'm', 'Steve', 'Allen', '1969-10-08 00:00:00', 'steve.allen@dsl.pipex.com', 17, '08701401010', '', 'cad4d8b38e0c1f1319a29f4409234754:28', '1');
INSERT INTO `customers` VALUES (14, 'f', 'Tracey', 'Parish', '1965-11-19 00:00:00', 'parisht@rpsgroup.com', 16, '01793 816936', '', 'a7f98fa0969b04d2cb17c1ea257e2a5e:d9', '');
INSERT INTO `customers` VALUES (13, 'f', 'test1', 'test1', '1982-08-09 00:00:00', 'test@test2.com', 15, '01604 123456', '', 'e8d9af17543ba70da0435fe833076260:9a', '');
INSERT INTO `customers` VALUES (8, 'm', 'Gavin', 'Fry', '1979-04-17 00:00:00', 'gavin.fry@marshas.co.uk', 9, '01903823575', '', 'e00ba4c4343d823d1dd14e6ea81c5c3c:4b', '1');
INSERT INTO `customers` VALUES (10, 'm', 'Damian', 'Thorpe', '1981-01-01 00:00:00', 'steve@smesolutions.co.uk', 12, '0870 765 9880', '', '743d97e48caf62ff347ef4450fdffb02:a6', '');
INSERT INTO `customers` VALUES (16, 'f', 'Sue', 'Wade', '1966-03-29 00:00:00', 'sue.wade@mdsuk.com', 18, '019255545690', '', '9d205fa53de0cab945d05c7045b5250f:e0', '');
INSERT INTO `customers` VALUES (17, 'm', 'Matt', 'Stacey', '1965-09-21 00:00:00', 'matthew.stacey@ukonline.co.uk', 19, '07976 702827', '07971 434467', '7668c8b6f45b0f5ffbb0afc53e528bd5:c1', '');
INSERT INTO `customers` VALUES (18, 'f', 'Bec', 'Smith', '1979-01-06 00:00:00', 'phender@aol.com', 20, '01787 466789', '', 'df88853d291c2e6d2348db9683b6be8e:80', '');
INSERT INTO `customers` VALUES (19, 'f', 'Seema', 'Sobte', '1970-02-18 00:00:00', 'seema@premierconsulting.co.uk', 21, '07958 775288', '', '2b1746d63e1057c5f3989ff939544989:95', '');
INSERT INTO `customers` VALUES (20, 'f', 'Jo', 'Lovell', '1970-06-24 00:00:00', 'jollyjamesandjo@aol.com', 22, '0208 299 1114', '', '43b782ae2536e5012c4d5a88fddf7f70:ff', '');
INSERT INTO `customers` VALUES (21, 'f', 'katherine', 'charleston', '1979-12-02 00:00:00', 'katherine@charlestondesign.co.uk', 23, '07881951206', '', '2577c38609bbfe8173f9702eeaf91b7c:3a', '1');
INSERT INTO `customers` VALUES (22, 'f', 'Jo', 'Pool', '1977-11-10 00:00:00', 'jo.pool@virgin.net', 24, '07932 949033', '', 'cdc131b871a4f46483c9546be8856602:8a', '1');
INSERT INTO `customers` VALUES (23, 'f', 'victoria', 'gordon', '1980-02-15 00:00:00', 'vickygordon1@tiscali.co.uk', 25, '01403248329', '', 'ea163da0f5f58ad7b9891c55a33c23b9:92', '1');
INSERT INTO `customers` VALUES (24, 'f', 'Philippa', 'Jacques', '1978-12-28 00:00:00', 'pip.jacques@ntlworld.com', 26, '07796 591493', '', '5996312ac28b13ee7380be01ef5774da:6c', '1');
INSERT INTO `customers` VALUES (25, 'f', 'Louise', 'Phillips', '1975-12-06 00:00:00', 'louise_e_phillips@hotmail.co.uk', 27, '01273 235515', '', '31e3a32fba14152186168fc743e29c42:88', '');
INSERT INTO `customers` VALUES (26, 'f', 'Carissa', 'Rattansingh', '1980-12-19 00:00:00', 'carissa313@hotmail.com', 28, '07817136187', '', 'd9c13c03710e6c205692e9999db7e95a:78', '');
INSERT INTO `customers` VALUES (27, 'f', 'Rebecca', 'Holmes', '1974-03-21 00:00:00', 'rebecca_holmes@hotmail.com', 29, '07971 061005', '', '1853fc4466a1471aa4925181796a7218:a6', '');
INSERT INTO `customers` VALUES (28, 'f', 'Ann', 'Wilbourn', '1957-12-07 00:00:00', 'annwilbourn@hotmail.com', 30, '07931 751817', '', 'dacdb4b71f2438b6150d90618ab8455e:6c', '');
INSERT INTO `customers` VALUES (29, 'm', 'Andy', 'Reik', '1975-04-11 00:00:00', 'andyreik@mac.com', 31, '02076244545', '', '8f85d9b1d253c7855707574a7a538cd6:d2', '');
INSERT INTO `customers` VALUES (30, 'f', 'Claire', 'Butterfill', '1981-02-24 00:00:00', 'phil.davison@btinternet.com', 32, '01903 893922', '01903 893922', 'd7ec1459c227cc847d233168a56acfc5:95', '1');
INSERT INTO `customers` VALUES (31, 'f', 'kelly', 'winchester', '1975-07-11 00:00:00', 'kellyw9@aol.com', 33, '01454318989', '', '11d2f9bb71c94cf417164cdc592fe8a6:09', '');
INSERT INTO `customers` VALUES (32, 'm', 'ramshyam', 'shyam', '1984-04-20 00:00:00', 'ramshyam@yahoo.com', 34, '123456', '132456', '19d5df65aec7faab44b39153101d31ee:f8', '');
INSERT INTO `customers` VALUES (33, 'f', 'Karen', 'Green', '1959-04-04 00:00:00', 'caldwell0@tinyworld.co.uk', 35, '01189 760217', '', '270cefc9d93ff1ae2b618121af6512c0:bc', '1');
INSERT INTO `customers` VALUES (34, 'f', 'Patricia', 'Maggs', '1962-05-12 00:00:00', 'focus_interiors@fsmail.net', 36, '01273413829', '', '10598f2e2a8c3df987ec02f57fee488c:95', '1');
INSERT INTO `customers` VALUES (35, 'm', 'simon', 'wiggins', '1975-05-21 00:00:00', 'simon.wiggins2@ntlworld.com', 37, '077 667 111 59', '', '213b8a04c811d35fd5cb215555b3d4a4:bf', '');
INSERT INTO `customers` VALUES (36, 'f', 'Rebecca', 'Wells', '1978-01-05 00:00:00', 'Rebca24@aol.com', 38, '256-767-7281', '', 'e579fb0aa754885da541933fed6f919f:b5', '1');
INSERT INTO `customers` VALUES (37, 'f', 'Tes', 'Mcsharpe', '1976-09-14 00:00:00', 'revert2out@yahoo.co.uk', 39, '01458441942', '', 'c1fc1f2588884540d1549e4fe36248ce:52', '');
INSERT INTO `customers` VALUES (38, 'm', 'Neil', 'Tate', '1981-08-07 00:00:00', 'neiltate@gmail.com', 40, '-----------', '', '548bfcbd5eea525662e34b713171b312:a0', '');
INSERT INTO `customers` VALUES (39, 'm', 'Tom', 'Griffiths', '1922-01-01 00:00:00', 'nothing@nothing.com', 41, '0123982342', '', '91e5ca94b9e19eae6de5f25f8694bf6a:2c', '');
INSERT INTO `customers` VALUES (40, 'f', 'Jennifer', 'Gill', '1974-07-08 00:00:00', 'jen@shills.co.uk', 42, '01189884332', '', '85bce253236bc740c6becd243d7c14ab:61', '1');
INSERT INTO `customers` VALUES (41, 'f', 'Brenda', 'Celestine', '1950-02-08 00:00:00', 'brendacelestine@yahoo.co.uk', 43, '07767375306', '', '3299b59a39fa2d1a56aec1d19a8b7ff7:2b', '');
INSERT INTO `customers` VALUES (42, 'm', 'andrew', 'slade', '1975-09-11 00:00:00', 'andrew@atchoo.co.uk', 44, '01903 733425', '', '3ef46d28e6086329cf75ae5fe6e58850:28', '');
INSERT INTO `customers` VALUES (43, 'f', 'SUE', 'PALMER', '1966-05-07 00:00:00', 'spalmer58@btinternet.com', 45, '01843 861551', '', 'b523baf9591842c15d23ec8d09d44bba:03', '1');
INSERT INTO `customers` VALUES (44, 'f', 'Nikki', 'Smith', '1968-01-08 00:00:00', 'nikki_smith32@hotmail.com', 46, '01903 756371', '', '9d4000a70948f318e3ef892e51c9a955:12', '');
INSERT INTO `customers` VALUES (45, 'f', 'Beverley', 'Center', '1958-09-29 00:00:00', 'beverley_center@hotmail.com', 47, '01235 202393', '01235 201004', '9e7e73fae0351561c1f5b77fe90322fc:c2', '1');
INSERT INTO `customers` VALUES (46, 'f', 'debbie', 'forrest', '1956-02-09 00:00:00', 'minglesuk@aol.com', 48, '07860578708', '', '90d8ef4bd2fe49dfa76d5267d2b2de09:c5', '');
INSERT INTO `customers` VALUES (47, 'f', 'hollie', 'shannon', '1985-03-12 00:00:00', 'skincandy_tattoos@msn.com', 49, '01273 597315', '', 'daa20cf89ecd7ac151fa7f61317039bf:ac', '');
INSERT INTO `customers` VALUES (48, 'f', 'sunita', 'arora-shah', '1963-07-10 00:00:00', 'arorano1@aol.com', 50, '07949 069237', '', '538fd41fa3772be9973fc3ef0ec909c1:e7', '1');
INSERT INTO `customers` VALUES (49, 'm', 'Steve', 'Cross', '1957-07-05 00:00:00', 'steve.cross@which.net', 51, '01428 717459', '', 'a5deaac038847cd76fb2a7ab008eb15b:fb', '1');
INSERT INTO `customers` VALUES (50, 'm', 'Clifford', 'Collier', '1966-07-09 00:00:00', 'cliff@colliers-at-home.freeserve.co.uk', 52, '01903 260461', '', '3623c9f3d55c728d038b9e2f42a23cf6:98', '');
INSERT INTO `customers` VALUES (51, 'f', 'Trish', 'Portas', '1955-09-02 00:00:00', 'p.portas@ntlworld.com', 53, '02392422429', '', '7e4ac20c7db590139e9d53839e16ec26:98', '1');
INSERT INTO `customers` VALUES (52, 'f', 'Victoria', 'Richardson', '1979-06-04 00:00:00', 'vikkirichardson@hotmail.co.uk', 54, '07760 127035', '', '9cb5570f5ea2b5dff91e6a56b3483942:f5', '');
INSERT INTO `customers` VALUES (53, 'f', 'sharon', 'reilly', '1970-11-11 00:00:00', 'sreilly@wsgfl.org.uk', 55, '01273819827', '', '9d6843d5ce3e7686afb0cdac6ced3d7d:7b', '');
INSERT INTO `customers` VALUES (54, 'f', 'Louise', 'Hill', '1979-03-03 00:00:00', 'lh@objectiveresearch.com', 56, '07729589423', '', 'e1b6b84482e13a92b23c5188ce66adc4:4f', '');
INSERT INTO `customers` VALUES (55, 'f', 'justine', 'matthews', '1970-07-16 00:00:00', 'justinematthews@hotmail.com', 57, '07771534273', '', '1ef94fc058574034dee13934104f697a:3c', '1');
INSERT INTO `customers` VALUES (56, 'm', 'ADRIAN', 'DAVEY', '1959-08-19 00:00:00', 'ada@aabs-technology.co.uk', 58, '01403784501', '', 'a88ea4ba35c643a15a94716834484b67:bf', '');
INSERT INTO `customers` VALUES (57, 'm', 'Paul', 'Heitman', '1955-10-19 00:00:00', 'paul@oakhurstproperty.co.uk', 59, '02074940144', '', '795410d9ad2d37be59a1b4cddad2b113:cc', '');
INSERT INTO `customers` VALUES (58, 'f', 'Samantha', 'Bertie', '1965-09-14 00:00:00', 'sambertie@hotmail.com', 60, '07958 691193', '', '302797b208aa8cacbac01af548856099:09', '');
INSERT INTO `customers` VALUES (59, 'f', 'Bianca', 'Boccia', '1982-05-12 00:00:00', 'bianca.boccia@freedomflights.co.uk', 61, '01293 439163', '', 'b1d31a85880b8d452e45068bea617d34:15', '');
INSERT INTO `customers` VALUES (60, 'f', 'Beverley', 'Connor', '1972-09-09 00:00:00', 'beverley.connor@ticketmaster.co.uk', 62, '07968855446', '', '179d9e74720c4cb6e14cb22311029f9f:47', '');
INSERT INTO `customers` VALUES (61, 'f', 'liz', 'williams', '1981-02-12 00:00:00', 'lillybet1@msn.com', 63, '01903 602030', '', 'e768a47d7ddd01b4f4cb65896daa0229:3f', '1');
INSERT INTO `customers` VALUES (62, 'f', 'jodi', 'riches', '1978-09-02 00:00:00', 'jodiriches@hotmail.com', 64, '07711655283', '', '55d3161113fbfc5328c347bd3bca365a:49', '');
INSERT INTO `customers` VALUES (63, 'f', 'Barbara', 'Lake', '1948-01-25 00:00:00', 'barbaralake@btinternat.com', 65, '01403269219', '', '555b3f6bd86527ee27cb55af1550468a:e5', '');
INSERT INTO `customers` VALUES (64, 'f', 'Tracy', 'Jones', '1119-06-02 00:00:00', 'jonesmail@ntlworld.com', 66, '01273305463', '', 'e5e68b47271957df3fce14673d633267:41', '');

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

#
# Table structure for table `customers_basket`
#

CREATE TABLE `customers_basket` (
  `customers_basket_id` int(11) NOT NULL auto_increment,
  `customers_id` int(11) NOT NULL default '0',
  `products_id` tinytext NOT NULL,
  `customers_basket_quantity` int(2) NOT NULL default '0',
  `final_price` decimal(15,4) NOT NULL default '0.0000',
  `customers_basket_date_added` varchar(8) default NULL,
  PRIMARY KEY  (`customers_basket_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;

#
# Dumping data for table `customers_basket`
#

INSERT INTO `customers_basket` VALUES (30, 13, '55', 1, '0.0000', '20050314');
INSERT INTO `customers_basket` VALUES (46, 39, '90', 1, '0.0000', '20050619');
INSERT INTO `customers_basket` VALUES (15, 8, '55', 1, '0.0000', '20050301');
INSERT INTO `customers_basket` VALUES (14, 8, '47', 1, '0.0000', '20050301');
INSERT INTO `customers_basket` VALUES (42, 33, '65', 1, '0.0000', '20050513');
INSERT INTO `customers_basket` VALUES (38, 26, '64{2}39', 1, '0.0000', '20050502');
INSERT INTO `customers_basket` VALUES (44, 37, '47', 1, '0.0000', '20050617');
INSERT INTO `customers_basket` VALUES (43, 4, '128', 1, '0.0000', '20050616');
INSERT INTO `customers_basket` VALUES (37, 26, '64{2}38', 1, '0.0000', '20050502');
INSERT INTO `customers_basket` VALUES (45, 38, '65', 1, '0.0000', '20050618');
INSERT INTO `customers_basket` VALUES (48, 50, '65', 1, '0.0000', '20050911');
INSERT INTO `customers_basket` VALUES (50, 60, '96', 1, '0.0000', '20051119');

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

#
# Table structure for table `customers_basket_attributes`
#

CREATE TABLE `customers_basket_attributes` (
  `customers_basket_attributes_id` int(11) NOT NULL auto_increment,
  `customers_id` int(11) NOT NULL default '0',
  `products_id` tinytext NOT NULL,
  `products_options_id` int(11) NOT NULL default '0',
  `products_options_value_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`customers_basket_attributes_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;

#
# Dumping data for table `customers_basket_attributes`
#

INSERT INTO `customers_basket_attributes` VALUES (27, 26, '64{2}39', 2, 39);
INSERT INTO `customers_basket_attributes` VALUES (26, 26, '64{2}38', 2, 38);

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

#
# Table structure for table `customers_info`
#

CREATE TABLE `customers_info` (
  `customers_info_id` int(11) NOT NULL default '0',
  `customers_info_date_of_last_logon` datetime default NULL,
  `customers_info_number_of_logons` int(5) default NULL,
  `customers_info_date_account_created` datetime default NULL,
  `customers_info_date_account_last_modified` datetime default NULL,
  `global_product_notifications` int(1) default '0',
  PRIMARY KEY  (`customers_info_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table `customers_info`
#

INSERT INTO `customers_info` VALUES (12, NULL, 0, '2005-03-10 08:43:23', NULL, 0);
INSERT INTO `customers_info` VALUES (14, NULL, 0, '2005-03-16 14:05:28', NULL, 0);
INSERT INTO `customers_info` VALUES (4, '2005-09-22 17:33:21', 14, '2005-02-21 13:54:14', NULL, 0);
INSERT INTO `customers_info` VALUES (15, NULL, 0, '2005-03-18 14:42:00', NULL, 0);
INSERT INTO `customers_info` VALUES (13, NULL, 0, '2005-03-14 11:31:37', NULL, 0);
INSERT INTO `customers_info` VALUES (8, '2005-04-06 17:36:33', 17, '2005-03-01 13:42:02', '2005-03-01 13:45:10', 0);
INSERT INTO `customers_info` VALUES (10, '2005-08-07 22:07:27', 10, '2005-03-01 16:28:00', NULL, 0);
INSERT INTO `customers_info` VALUES (16, NULL, 0, '2005-03-24 09:47:02', NULL, 0);
INSERT INTO `customers_info` VALUES (17, NULL, 0, '2005-03-24 11:22:57', NULL, 0);
INSERT INTO `customers_info` VALUES (18, NULL, 0, '2005-03-24 22:39:54', NULL, 0);
INSERT INTO `customers_info` VALUES (19, NULL, 0, '2005-03-28 10:12:07', NULL, 0);
INSERT INTO `customers_info` VALUES (20, NULL, 0, '2005-03-29 16:40:29', NULL, 0);
INSERT INTO `customers_info` VALUES (21, NULL, 0, '2005-04-03 20:14:23', NULL, 0);
INSERT INTO `customers_info` VALUES (22, NULL, 0, '2005-04-04 20:34:06', NULL, 0);
INSERT INTO `customers_info` VALUES (23, NULL, 0, '2005-04-05 18:33:50', NULL, 0);
INSERT INTO `customers_info` VALUES (24, NULL, 0, '2005-04-09 18:18:37', NULL, 0);
INSERT INTO `customers_info` VALUES (25, NULL, 0, '2005-04-18 20:28:58', NULL, 0);
INSERT INTO `customers_info` VALUES (26, '2005-05-02 22:21:32', 1, '2005-04-19 11:22:05', NULL, 0);
INSERT INTO `customers_info` VALUES (27, NULL, 0, '2005-04-21 09:04:46', NULL, 0);
INSERT INTO `customers_info` VALUES (28, NULL, 0, '2005-04-25 15:36:47', NULL, 0);
INSERT INTO `customers_info` VALUES (29, NULL, 0, '2005-05-01 00:25:18', NULL, 0);
INSERT INTO `customers_info` VALUES (30, NULL, 0, '2005-05-03 21:14:18', NULL, 0);
INSERT INTO `customers_info` VALUES (31, NULL, 0, '2005-05-08 18:34:05', NULL, 0);
INSERT INTO `customers_info` VALUES (32, NULL, 0, '2005-05-09 10:27:01', NULL, 0);
INSERT INTO `customers_info` VALUES (33, NULL, 0, '2005-05-13 20:07:44', NULL, 0);
INSERT INTO `customers_info` VALUES (34, NULL, 0, '2005-05-17 13:48:48', NULL, 0);
INSERT INTO `customers_info` VALUES (35, NULL, 0, '2005-06-03 14:26:23', NULL, 0);
INSERT INTO `customers_info` VALUES (36, NULL, 0, '2005-06-17 15:38:52', NULL, 0);
INSERT INTO `customers_info` VALUES (37, NULL, 0, '2005-06-17 15:53:05', NULL, 0);
INSERT INTO `customers_info` VALUES (38, NULL, 0, '2005-06-18 18:56:14', NULL, 0);
INSERT INTO `customers_info` VALUES (39, NULL, 0, '2005-06-19 13:46:44', NULL, 0);
INSERT INTO `customers_info` VALUES (40, NULL, 0, '2005-07-23 11:11:42', NULL, 0);
INSERT INTO `customers_info` VALUES (41, '2005-10-07 17:52:19', 1, '2005-07-23 16:12:26', NULL, 0);
INSERT INTO `customers_info` VALUES (42, NULL, 0, '2005-07-23 17:04:21', NULL, 0);
INSERT INTO `customers_info` VALUES (43, NULL, 0, '2005-07-27 18:42:47', NULL, 0);
INSERT INTO `customers_info` VALUES (44, NULL, 0, '2005-07-28 14:41:56', NULL, 0);
INSERT INTO `customers_info` VALUES (45, '2005-10-05 11:13:56', 13, '2005-08-06 09:44:54', NULL, 0);
INSERT INTO `customers_info` VALUES (46, NULL, 0, '2005-08-17 16:51:57', NULL, 0);
INSERT INTO `customers_info` VALUES (47, NULL, 0, '2005-09-02 12:45:13', NULL, 0);
INSERT INTO `customers_info` VALUES (48, NULL, 0, '2005-09-05 13:03:40', NULL, 0);
INSERT INTO `customers_info` VALUES (49, NULL, 0, '2005-09-06 22:03:05', NULL, 0);
INSERT INTO `customers_info` VALUES (50, NULL, 0, '2005-09-11 18:23:46', NULL, 0);
INSERT INTO `customers_info` VALUES (51, NULL, 0, '2005-09-11 20:41:08', NULL, 0);
INSERT INTO `customers_info` VALUES (52, NULL, 0, '2005-09-22 13:31:33', NULL, 0);
INSERT INTO `customers_info` VALUES (53, NULL, 0, '2005-09-22 13:43:21', NULL, 0);
INSERT INTO `customers_info` VALUES (54, NULL, 0, '2005-10-07 13:42:23', NULL, 0);
INSERT INTO `customers_info` VALUES (55, NULL, 0, '2005-10-08 15:02:46', NULL, 0);
INSERT INTO `customers_info` VALUES (56, NULL, 0, '2005-10-11 15:18:36', NULL, 0);
INSERT INTO `customers_info` VALUES (57, '2005-11-13 15:44:15', 1, '2005-11-07 08:18:35', NULL, 0);
INSERT INTO `customers_info` VALUES (58, NULL, 0, '2005-11-09 13:51:10', NULL, 0);
INSERT INTO `customers_info` VALUES (59, NULL, 0, '2005-11-10 10:16:47', NULL, 0);
INSERT INTO `customers_info` VALUES (60, NULL, 0, '2005-11-19 22:07:06', NULL, 0);
INSERT INTO `customers_info` VALUES (61, '2005-11-26 18:20:04', 1, '2005-11-20 11:14:06', '2005-11-20 11:17:53', 1);
INSERT INTO `customers_info` VALUES (62, NULL, 0, '2005-11-21 12:38:10', NULL, 0);
INSERT INTO `customers_info` VALUES (63, NULL, 0, '2005-12-05 16:33:20', NULL, 0);
INSERT INTO `customers_info` VALUES (64, NULL, 0, '2005-12-29 20:13:58', NULL, 0);

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

#
# Table structure for table `epdq_transactions`
#

CREATE TABLE `epdq_transactions` (
  `oid` varchar(30) NOT NULL default '',
  `transaction_status` varchar(60) default NULL,
  `order_total` decimal(14,3) NOT NULL default '0.000',
  `notes` text,
  `transaction_time` datetime default NULL,
  PRIMARY KEY  (`oid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table `epdq_transactions`
#

INSERT INTO `epdq_transactions` VALUES ('', 'manual call', '0.000', NULL, '2005-03-02 12:42:15');
INSERT INTO `epdq_transactions` VALUES ('10-20050302130906', 'DECLINED', '0.000', NULL, '2005-03-02 13:11:02');
INSERT INTO `epdq_transactions` VALUES ('11-20050302151812', 'DECLINED', '0.000', NULL, '2005-03-02 15:18:51');
INSERT INTO `epdq_transactions` VALUES ('11-20050302152022', 'DECLINED', '0.000', NULL, '2005-03-02 15:20:54');
INSERT INTO `epdq_transactions` VALUES ('13-20050314113154', 'DECLINED', '0.000', NULL, '2005-03-14 11:33:15');

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

#
# Table structure for table `geo_zones`
#

CREATE TABLE `geo_zones` (
  `geo_zone_id` int(11) NOT NULL auto_increment,
  `geo_zone_name` varchar(32) NOT NULL default '',
  `geo_zone_description` varchar(255) NOT NULL default '',
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`geo_zone_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `geo_zones`
#

INSERT INTO `geo_zones` VALUES (1, 'United Kingdom', 'Great Britain tax', '2005-01-20 11:04:19', '2005-01-20 09:26:37');

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

#
# Table structure for table `languages`
#

CREATE TABLE `languages` (
  `languages_id` int(11) NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `code` char(2) NOT NULL default '',
  `image` varchar(64) default NULL,
  `directory` varchar(32) default NULL,
  `sort_order` int(3) default NULL,
  PRIMARY KEY  (`languages_id`),
  KEY `IDX_LANGUAGES_NAME` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

#
# Dumping data for table `languages`
#

INSERT INTO `languages` VALUES (1, 'English', 'en', 'icon.gif', 'english', 1);

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

#
# Table structure for table `manufacturers`
#

CREATE TABLE `manufacturers` (
  `manufacturers_id` int(11) NOT NULL auto_increment,
  `manufacturers_name` varchar(32) NOT NULL default '',
  `manufacturers_image` varchar(64) default NULL,
  `date_added` datetime default NULL,
  `last_modified` datetime default NULL,
  PRIMARY KEY  (`manufacturers_id`),
  KEY `IDX_MANUFACTURERS_NAME` (`manufacturers_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

#
# Dumping data for table `manufacturers`
#


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

#
# Table structure for table `manufacturers_info`
#

CREATE TABLE `manufacturers_info` (
  `manufacturers_id` int(11) NOT NULL default '0',
  `languages_id` int(11) NOT NULL default '0',
  `manufacturers_url` varchar(255) NOT NULL default '',
  `url_clicked` int(5) NOT NULL default '0',
  `date_last_click` datetime default NULL,
  PRIMARY KEY  (`manufacturers_id`,`languages_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table `manufacturers_info`
#


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

#
# Table structure for table `newsletters`
#

CREATE TABLE `newsletters` (
  `newsletters_id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `content` text NOT NULL,
  `module` varchar(255) NOT NULL default '',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_sent` datetime default NULL,
  `status` int(1) default NULL,
  `locked` int(1) default '0',
  PRIMARY KEY  (`newsletters_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

#
# Dumping data for table `newsletters`
#

INSERT INTO `newsletters` VALUES (1, 'Coming soon!', 'Marsha\'s Online will soon reflect the broad range of products sold in its Sussex stores, come back soon to take advantage of the special savings available online.\r\n\r\nMarsha\'s\r\ninfo@marshas.co.uk\r\nwww.marshas.co.uk\r\n+44(0)1273 612800', 'product_notification', '2005-03-29 23:15:42', NULL, 0, 1);
INSERT INTO `newsletters` VALUES (2, 'Test HTML', '<b>Description</b>\r\n<br><br>\r\nAn extremely popular light sold in our stores, this novel light will add style to any room.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n1.6 Metres in height, comprized of 15 lights <br>\r\n<br>\r\n.....................................................................', 'product_notification', '2005-04-04 12:58:51', NULL, 0, 1);

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

#
# Table structure for table `orders`
#

CREATE TABLE `orders` (
  `orders_id` int(11) NOT NULL auto_increment,
  `customers_id` int(11) NOT NULL default '0',
  `customers_name` varchar(64) NOT NULL default '',
  `customers_company` varchar(32) default NULL,
  `customers_street_address` varchar(64) NOT NULL default '',
  `customers_suburb` varchar(32) default NULL,
  `customers_city` varchar(32) NOT NULL default '',
  `customers_postcode` varchar(10) NOT NULL default '',
  `customers_state` varchar(32) default NULL,
  `customers_country` varchar(32) NOT NULL default '',
  `customers_telephone` varchar(32) NOT NULL default '',
  `customers_email_address` varchar(96) NOT NULL default '',
  `customers_address_format_id` int(5) NOT NULL default '0',
  `delivery_name` varchar(64) NOT NULL default '',
  `delivery_company` varchar(32) default NULL,
  `delivery_street_address` varchar(64) NOT NULL default '',
  `delivery_suburb` varchar(32) default NULL,
  `delivery_city` varchar(32) NOT NULL default '',
  `delivery_postcode` varchar(10) NOT NULL default '',
  `delivery_state` varchar(32) default NULL,
  `delivery_country` varchar(32) NOT NULL default '',
  `delivery_address_format_id` int(5) NOT NULL default '0',
  `billing_name` varchar(64) NOT NULL default '',
  `billing_company` varchar(32) default NULL,
  `billing_street_address` varchar(64) NOT NULL default '',
  `billing_suburb` varchar(32) default NULL,
  `billing_city` varchar(32) NOT NULL default '',
  `billing_postcode` varchar(10) NOT NULL default '',
  `billing_state` varchar(32) default NULL,
  `billing_country` varchar(32) NOT NULL default '',
  `billing_address_format_id` int(5) NOT NULL default '0',
  `payment_method` varchar(32) NOT NULL default '',
  `cc_type` varchar(20) default NULL,
  `cc_owner` varchar(64) default NULL,
  `cc_number` varchar(32) default NULL,
  `cc_expires` varchar(4) default NULL,
  `last_modified` datetime default NULL,
  `date_purchased` datetime default NULL,
  `orders_status` int(5) NOT NULL default '0',
  `orders_date_finished` datetime default NULL,
  `currency` char(3) default NULL,
  `currency_value` decimal(14,6) default NULL,
  PRIMARY KEY  (`orders_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

#
# Dumping data for table `orders`
#

INSERT INTO `orders` VALUES (7, 17, 'Matt Stacey', '', 'Farthings, Osmington Lodge', 'Osmington', 'Weymouth', 'DT3 6EX', 'Dorset', 'United Kingdom', '07976 702827', 'matthew.stacey@ukonline.co.uk', 1, 'Matt Stacey', '', 'Farthings, Osmington Lodge', 'Osmington', 'Weymouth', 'DT3 6EX', 'Dorset', 'United Kingdom', 1, 'Matt Stacey', '', 'Farthings, Osmington Lodge', 'Osmington', 'Weymouth', 'DT3 6EX', 'Dorset', 'United Kingdom', 1, 'ePDQ', '', '', '', '', '2005-04-07 11:06:51', '2005-03-24 11:34:10', 3, NULL, 'GBP', '1.000000');
INSERT INTO `orders` VALUES (9, 45, 'Beverley Center', '', '61 Abingdon Road', 'Drayton', 'Abingdon', 'OX14 4HW', 'Oxfordshire', 'United Kingdom', '01235 202393', 'beverley_center@hotmail.com', 1, 'Beverley Center', '', '61 Abingdon Road', 'Drayton', 'Abingdon', 'OX14 4HW', 'Oxfordshire', 'United Kingdom', 1, 'Beverley Center', '', '61 Abingdon Road', 'Drayton', 'Abingdon', 'OX14 4HW', 'Oxfordshire', 'United Kingdom', 1, 'ePDQ', '', '', '', '', '2005-11-18 10:58:51', '2005-08-06 09:47:37', 3, NULL, 'GBP', '1.000000');

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

#
# Table structure for table `orders_products`
#

CREATE TABLE `orders_products` (
  `orders_products_id` int(11) NOT NULL auto_increment,
  `orders_id` int(11) NOT NULL default '0',
  `products_id` int(11) NOT NULL default '0',
  `products_model` varchar(12) default NULL,
  `products_name` varchar(64) NOT NULL default '',
  `products_price` decimal(15,4) NOT NULL default '0.0000',
  `final_price` decimal(15,4) NOT NULL default '0.0000',
  `products_tax` decimal(7,4) NOT NULL default '0.0000',
  `products_quantity` int(2) NOT NULL default '0',
  PRIMARY KEY  (`orders_products_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

#
# Dumping data for table `orders_products`
#

INSERT INTO `orders_products` VALUES (9, 9, 58, '', 'Aubusson Wall Mirror', '336.1700', '336.1700', '17.5000', 1);
INSERT INTO `orders_products` VALUES (7, 7, 60, '', 'Antibes Mirror', '212.7700', '212.7700', '17.5000', 1);

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

#
# Table structure for table `orders_products_attributes`
#

CREATE TABLE `orders_products_attributes` (
  `orders_products_attributes_id` int(11) NOT NULL auto_increment,
  `orders_id` int(11) NOT NULL default '0',
  `orders_products_id` int(11) NOT NULL default '0',
  `products_options` varchar(32) NOT NULL default '',
  `products_options_values` varchar(32) NOT NULL default '',
  `options_values_price` decimal(15,4) NOT NULL default '0.0000',
  `price_prefix` char(1) NOT NULL default '',
  PRIMARY KEY  (`orders_products_attributes_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

#
# Dumping data for table `orders_products_attributes`
#

INSERT INTO `orders_products_attributes` VALUES (2, 7, 7, 'Color', 'Clear Laquered', '0.0000', '+');
INSERT INTO `orders_products_attributes` VALUES (4, 9, 9, 'Size', '132.8 cm (L)', '0.0000', '+');

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

#
# Table structure for table `orders_products_download`
#

CREATE TABLE `orders_products_download` (
  `orders_products_download_id` int(11) NOT NULL auto_increment,
  `orders_id` int(11) NOT NULL default '0',
  `orders_products_id` int(11) NOT NULL default '0',
  `orders_products_filename` varchar(255) NOT NULL default '',
  `download_maxdays` int(2) NOT NULL default '0',
  `download_count` int(2) NOT NULL default '0',
  PRIMARY KEY  (`orders_products_download_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

#
# Dumping data for table `orders_products_download`
#


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

#
# Table structure for table `orders_status`
#

CREATE TABLE `orders_status` (
  `orders_status_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `orders_status_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`orders_status_id`,`language_id`),
  KEY `idx_orders_status_name` (`orders_status_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table `orders_status`
#

INSERT INTO `orders_status` VALUES (1, 1, 'Pending');
INSERT INTO `orders_status` VALUES (2, 1, 'Processing');
INSERT INTO `orders_status` VALUES (3, 1, 'Delivered');

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

#
# Table structure for table `orders_status_history`
#

CREATE TABLE `orders_status_history` (
  `orders_status_history_id` int(11) NOT NULL auto_increment,
  `orders_id` int(11) NOT NULL default '0',
  `orders_status_id` int(5) NOT NULL default '0',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `customer_notified` int(1) default '0',
  `comments` text,
  PRIMARY KEY  (`orders_status_history_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

#
# Dumping data for table `orders_status_history`
#

INSERT INTO `orders_status_history` VALUES (12, 7, 3, '2005-04-07 11:06:51', 1, '');
INSERT INTO `orders_status_history` VALUES (11, 7, 2, '2005-03-24 12:55:51', 1, '');
INSERT INTO `orders_status_history` VALUES (4, 3, 4, '2005-02-21 14:40:09', 0, '');
INSERT INTO `orders_status_history` VALUES (5, 4, 4, '2005-02-21 14:41:22', 0, '');
INSERT INTO `orders_status_history` VALUES (10, 7, 1, '2005-03-24 11:34:10', 1, '');
INSERT INTO `orders_status_history` VALUES (14, 9, 1, '2005-08-06 09:47:37', 1, '');
INSERT INTO `orders_status_history` VALUES (15, 9, 2, '2005-08-08 15:13:03', 1, 'Invoice printed & ent on F2000 23757');
INSERT INTO `orders_status_history` VALUES (16, 9, 3, '2005-11-18 10:58:51', 1, '');

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

#
# Table structure for table `orders_total`
#

CREATE TABLE `orders_total` (
  `orders_total_id` int(10) unsigned NOT NULL auto_increment,
  `orders_id` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `text` varchar(255) NOT NULL default '',
  `value` decimal(15,4) NOT NULL default '0.0000',
  `class` varchar(32) NOT NULL default '',
  `sort_order` int(11) NOT NULL default '0',
  PRIMARY KEY  (`orders_total_id`),
  KEY `idx_orders_total_orders_id` (`orders_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;

#
# Dumping data for table `orders_total`
#

INSERT INTO `orders_total` VALUES (35, 9, 'Total:', '<b>£440.00</b>', '440.0000', 'ot_total', 4);
INSERT INTO `orders_total` VALUES (27, 7, 'Total:', '<b>£320.01</b>', '320.0100', 'ot_total', 4);
INSERT INTO `orders_total` VALUES (26, 7, 'VAT 17.5%:', '£47.66', '47.6640', 'ot_tax', 3);
INSERT INTO `orders_total` VALUES (24, 7, 'Sub-Total:', '£250.00', '250.0000', 'ot_subtotal', 1);
INSERT INTO `orders_total` VALUES (25, 7, 'Flat Rate (Best Way):', '£70.01', '70.0100', 'ot_shipping', 2);
INSERT INTO `orders_total` VALUES (9, 3, 'Sub-Total:', '£931.92', '931.9200', 'ot_subtotal', 1);
INSERT INTO `orders_total` VALUES (10, 3, 'Flat Rate (Best Way):', '£50.00', '50.0000', 'ot_shipping', 2);
INSERT INTO `orders_total` VALUES (11, 3, 'VAT 17.5%:', '£163.09', '163.0860', 'ot_tax', 3);
INSERT INTO `orders_total` VALUES (12, 3, 'Total:', '<b>£1,145.01</b>', '1145.0060', 'ot_total', 4);
INSERT INTO `orders_total` VALUES (13, 4, 'Sub-Total:', '£931.92', '931.9200', 'ot_subtotal', 1);
INSERT INTO `orders_total` VALUES (14, 4, 'Flat Rate (Best Way):', '£50.00', '50.0000', 'ot_shipping', 2);
INSERT INTO `orders_total` VALUES (15, 4, 'VAT 17.5%:', '£163.09', '163.0860', 'ot_tax', 3);
INSERT INTO `orders_total` VALUES (16, 4, 'Total:', '<b>£1,145.01</b>', '1145.0060', 'ot_total', 4);
INSERT INTO `orders_total` VALUES (33, 9, 'Table Rate (Best Way):', '£45.00', '45.0000', 'ot_shipping', 2);
INSERT INTO `orders_total` VALUES (34, 9, 'VAT 17.5%:', '£65.53', '65.5297', 'ot_tax', 3);
INSERT INTO `orders_total` VALUES (32, 9, 'Sub-Total:', '£395.00', '395.0000', 'ot_subtotal', 1);

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

#
# Table structure for table `products`
#

CREATE TABLE `products` (
  `products_id` int(11) NOT NULL auto_increment,
  `products_quantity` int(4) NOT NULL default '0',
  `products_model` varchar(12) default NULL,
  `products_image` varchar(64) default NULL,
  `products_price` decimal(15,4) NOT NULL default '0.0000',
  `products_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `products_last_modified` datetime default NULL,
  `products_date_available` datetime default NULL,
  `products_weight` decimal(5,2) NOT NULL default '0.00',
  `products_status` tinyint(1) NOT NULL default '0',
  `products_tax_class_id` int(11) NOT NULL default '0',
  `manufacturers_id` int(11) default NULL,
  `products_ordered` int(11) NOT NULL default '0',
  PRIMARY KEY  (`products_id`),
  KEY `idx_products_date_added` (`products_date_added`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=129 ;

#
# Dumping data for table `products`
#

INSERT INTO `products` VALUES (63, 9999, '', 'MAR-D2-04 v2.JPG', '33.1915', '2005-04-01 17:36:06', '2005-04-25 16:49:15', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (55, 10000, '', 'Aubusson Carver - Rush Seat.jpg', '169.3600', '2005-02-28 12:10:48', '2005-03-02 16:59:27', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (37, 10000, '', 'Aubusson 4door cab-bottom.jpg', '1187.2300', '2005-02-22 17:47:28', '2005-03-02 17:01:44', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (38, 10000, '', 'Aubusson 4door cab-top.jpg', '1102.1300', '2005-02-22 17:50:32', '2005-03-02 17:01:55', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (39, 10000, '', 'Aubusson 3door cab-bottom.jpg', '1102.1300', '2005-02-22 19:24:29', '2005-03-02 17:01:24', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (40, 10000, '', 'Aubusson 3door cab-top.jpg', '1017.0200', '2005-02-22 19:27:07', '2005-03-02 17:01:34', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (41, 10000, '', 'Aubusson 2door cab-bottom.jpg', '761.7000', '2005-02-22 19:36:28', '2005-03-02 17:01:04', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (42, 10000, '', 'Aubusson 2door cab-top.jpg', '676.6000', '2005-02-22 19:42:48', '2005-03-02 17:01:14', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (43, 10000, '', 'Aubusson Hi-Fi Unit1Door.jpg', '574.4700', '2005-02-22 19:54:13', '2005-03-02 17:05:22', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (44, 10000, '', 'Aubusson Coffee Table.jpg', '506.3800', '2005-02-22 19:59:38', '2005-03-02 17:06:03', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (45, 10000, '', 'Aubusson Bookcase 1100.jpg', '761.7000', '2005-02-22 20:06:43', '2005-03-02 17:04:18', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (46, 10000, '', 'Aubusson Chair Leather Seat.jpg', '169.3600', '2005-02-22 20:26:13', '2005-03-02 16:59:42', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (47, 10000, '', 'Aubusson Carver Leather Seat.jpg', '211.9200', '2005-02-22 20:30:56', '2005-03-02 16:55:19', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (48, 10000, '', 'Aubusson Corner TV.jpg', '591.4900', '2005-02-22 20:41:00', '2005-03-02 17:04:59', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (49, 10000, '', 'Aubusson Table Rectangular 1.5m.jpg', '829.7900', '2005-02-22 20:49:06', '2005-03-02 16:54:43', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (50, 10000, '', 'Aubusson Entertainment Unit.jpg', '676.6000', '2005-02-28 11:29:10', '2005-03-02 17:05:10', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (51, 10000, '', 'Aubusson Coffee Table Drink Unit.jpg', '591.4900', '2005-02-28 11:35:15', '2005-03-02 17:06:16', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (52, 10000, '', 'Aubusson Hi-Fi Unit 1 Door 1 Drawer.jpg', '591.4900', '2005-02-28 11:42:40', '2005-03-02 17:05:34', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (53, 10000, '', 'Aubusson Lamp Table.jpg', '319.1500', '2005-02-28 11:54:15', '2005-03-02 17:06:28', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (54, 10000, '', 'Aubusson Chair - Rush Seat.jpg', '148.9400', '2005-02-28 12:05:22', '2005-03-02 16:59:52', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (34, 10000, '', 'Soho Dining Chair.jpg', '212.7700', '2005-02-22 15:33:12', '2005-03-02 17:00:44', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (33, 10000, '', 'Rollback Dining Chair.jpg', '212.7700', '2005-02-22 12:55:32', '2005-03-02 17:00:33', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (29, 10000, '', '5_plum_oak_sideboard.jpg', '931.9200', '2005-02-16 18:31:22', '2005-03-02 17:02:29', NULL, '0.00', 1, 1, 0, 2);
INSERT INTO `products` VALUES (32, 10000, '', 'Plum oak Dining Chair.jpg', '165.9600', '2005-02-22 12:38:06', '2005-03-02 17:00:04', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (31, 10000, '', '5_Plum_Oak_Dining_Table.jpg', '846.8100', '2005-02-22 11:13:11', '2005-05-12 15:20:13', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (56, 10000, '', 'Aubusson Bookcase 780.jpg', '659.5700', '2005-02-28 12:20:06', '2005-03-02 17:04:28', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (57, 10000, '', 'Aubusson Dresser Open Top.jpg', '591.4900', '2005-02-28 12:33:20', '2005-03-02 17:02:05', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (58, 9999, '', 'Aubusson Wall Mirror.jpg', '336.1700', '2005-02-28 12:48:56', '2005-03-02 16:54:26', NULL, '0.00', 1, 1, 0, 1);
INSERT INTO `products` VALUES (59, 10000, '', 'Country Collection Oval Table.jpg', '1442.5500', '2005-02-28 13:02:34', '2005-03-02 16:54:55', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (60, 9999, '', 'Antibes Mirror.jpg', '212.7700', '2005-02-28 13:12:37', '2005-03-02 16:54:15', NULL, '0.00', 1, 1, 0, 1);
INSERT INTO `products` VALUES (64, 99999, '', 'AccLtsShoJoLrgLshdeOrigWe.jpg', '336.1702', '2005-04-05 10:43:39', '2005-05-17 12:35:59', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (65, 10000, 'Special Offe', 'Copy-of-best-plum-shot.gif', '1442.5532', '2005-05-12 14:02:31', '2005-07-07 14:40:28', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (128, 99999, '002486', 'AcMirWhCoffDressMir980x840.jpg', '212.7660', '2005-06-15 16:36:11', '2005-06-15 17:43:24', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (66, 10000, '', 'alps.jpg', '33.1915', '2005-05-24 16:39:09', '2005-05-25 12:22:01', '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (67, 10000, '', 'grizzly.jpg', '33.1915', '2005-05-24 16:45:18', '2005-05-25 12:22:15', '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (68, 10000, '', 'newpolar.jpg', '33.1915', '2005-05-25 11:51:30', '2005-05-25 12:22:38', '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (69, 10000, '', 'lamb-ecru-60X30.jpg', '24.6809', '2005-05-25 11:55:05', '2005-05-25 12:38:23', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (70, 10000, '', 'lamb-ecru-cushion-60X60.jpg', '33.1915', '2005-05-25 12:00:01', '2005-05-25 12:14:32', '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (71, 10000, '', 'Lamb Graphite Cushion 60X30.jpg', '24.6809', '2005-05-25 12:21:41', '2005-05-25 12:38:40', '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (72, 10000, '', 'Lamb Graphite Cushion 60X60.jpg', '33.1915', '2005-05-25 12:24:42', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (73, 10000, '', 'Macro Suede Pannel Biscuit and Oatmeal 45x45.jpg', '21.2766', '2005-05-25 12:33:07', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (74, 10000, '', 'Swirl Fur Cushion 60X30.jpg', '24.6809', '2005-05-25 12:35:24', '2005-05-25 12:36:47', '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (75, 10000, '', 'Swirl Fur Cushion 60X60.jpg', '33.1915', '2005-05-25 12:42:22', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (76, 10000, '', 'Short Feather Caramel Cushion 50x50.jpg', '72.3404', '2005-05-25 12:49:59', NULL, NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (77, 10000, '', 'Alps Throw 220x240.jpg', '135.3191', '2005-05-25 13:03:13', NULL, NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (78, 10000, '', 'Arctic Wolf Throw 220x240.jpg', '135.3191', '2005-05-25 13:10:10', '2005-05-25 13:11:50', '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (79, 10000, '', 'Grizzly Throw 240x200.jpg', '135.3191', '2005-05-25 13:15:30', '2005-05-25 13:30:03', '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (80, 10000, '', 'New Pola Throw 240x200.jpg', '135.3191', '2005-05-25 13:17:04', '2005-05-25 13:30:32', '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (81, 10000, '', 'Lamb Ecru Throw 240x200.jpg', '135.3191', '2005-05-25 13:20:58', '2005-05-25 13:30:12', '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (82, 10000, '', 'Lamb Graphite Throw 240x200.jpg', '135.3191', '2005-05-25 13:24:21', '2005-05-25 13:30:21', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (83, 10000, '', 'Swirl Fur Throw 240x200.jpg', '135.3191', '2005-05-25 13:26:46', '2005-05-25 13:30:44', '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (84, 10000, '', 'White Feather Throw 240x200.jpg', '135.3191', '2005-05-25 13:29:07', NULL, NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (85, 10000, '', 'Little Ben Clock.gif', '75.7447', '2005-05-25 13:36:16', '2005-05-25 13:48:35', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (86, 10000, '', 'Large Hanging Clock.jpg', '288.5106', '2005-05-25 14:10:17', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (87, 10000, '', 'Large Hanging Scounce.jpg', '75.7447', '2005-05-25 14:12:40', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (88, 10000, '', 'Andorra Mirror.jpg', '152.3404', '2005-05-25 14:25:15', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (89, 10000, '', 'Black Steel Canted Mirror.jpg', '297.0213', '2005-05-25 14:27:57', '2005-05-25 14:28:17', '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (90, 10000, '', 'Clock Mirror.jpg', '288.5106', '2005-05-25 15:57:39', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (91, 10000, '', 'Cognac Dress Leather Mirror.jpg', '382.1277', '2005-05-25 16:00:03', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (92, 0, '', 'Cottage Pine Mirror.jpg', '194.8936', '2005-05-25 16:01:32', NULL, NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (93, 10000, '', 'Crocco Large Leather Mirror.jpg', '297.0213', '2005-05-25 16:03:29', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (94, 10000, '', 'Mocca Mirror Large.jpg', '228.9362', '2005-05-25 16:06:06', '2005-05-25 16:14:41', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (95, 10000, '', 'Mocca Mirror Large.jpg', '191.4894', '2005-05-25 16:15:52', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (96, 10000, '', 'Numeral Round Mirror.jpg', '109.7872', '2005-05-25 16:38:33', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (97, 10000, '', 'Numeral Round Mirror.jpg', '169.3617', '2005-05-25 16:39:42', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (98, 10000, '', 'Saddler Mirror.jpg', '194.8936', '2005-05-25 17:09:12', NULL, NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (99, 10000, '', 'Stockholm light Mirror.jpg', '123.4043', '2005-05-25 17:12:41', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (100, 10000, '', 'Stockholm Nuit Mirror.jpg', '152.3404', '2005-05-25 17:14:21', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (101, 10000, '', 'Sultan Mirror.jpg', '319.1489', '2005-05-25 17:17:01', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (102, 10000, '', 'Verona Large Mirror .jpg', '186.3830', '2005-05-25 17:19:49', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (103, 10000, '', 'Opio Mirror.jpg', '140.4255', '2005-05-25 17:22:47', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (104, 10000, '', 'Paris Mirror.jpg', '297.0213', '2005-05-25 17:25:07', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (105, 10000, '', 'Reisund Chrome Leather Mirror.jpg', '228.9362', '2005-05-26 09:43:50', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (106, 10000, '', 'Reisund Leather Mirror.jpg', '228.9362', '2005-05-26 10:04:13', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (107, 10000, '', 'Reisund Leather Mirror.jpg', '297.0213', '2005-05-26 10:05:43', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (108, 10000, '', 'Reisund Steel Leather Mirror.jpg', '297.0213', '2005-05-26 10:08:32', NULL, NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (109, 10000, '', 'Reisund Steel Leather Mirror.jpg', '450.2128', '2005-05-26 10:11:07', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (110, 10000, '', 'Candlesticks.jpg', '242.5532', '2005-05-26 10:30:45', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (111, 10000, '', 'Masal Iron.jpg', '107.2340', '2005-05-26 10:36:53', '2005-05-26 10:38:21', '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (112, 10000, '', 'Masal Iron.jpg', '135.3191', '2005-05-26 10:38:04', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (113, 10000, '', 'Double Wall Sconce.jpg', '75.7447', '2005-05-26 10:40:33', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (114, 10000, '', 'Large Egg Timer.jpg', '75.7447', '2005-05-26 10:43:30', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (115, 10000, '', 'Large Yacht.jpg', '63.8298', '2005-05-26 11:22:27', NULL, NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (116, 10000, '', 'Yacht.jpg', '63.8298', '2005-05-26 11:53:08', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (117, 10000, '', 'funky stool.jpg', '84.2553', '2005-05-26 12:05:49', '2005-05-26 12:06:47', '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (118, 10000, '', 'Saddler Stool.jpg', '109.7872', '2005-05-26 12:08:41', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (119, 10000, '', 'Long Stitch Cube.jpg', '356.5957', '2005-05-26 12:16:55', '2005-05-26 12:36:31', '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (120, 10000, '', 'Mocca Cube.jpg', '160.8511', '2005-05-26 12:40:27', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (121, 10000, '', 'Lizard Swivel cube.jpg', '109.7872', '2005-05-26 12:42:39', '2005-06-27 16:20:15', NULL, '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (122, 10000, '', 'Lush Leather Cube.jpg', '254.4681', '2005-05-26 12:49:05', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (123, 10000, '', 'Lush Swivel Round Cube.jpg', '254.4681', '2005-05-26 12:51:21', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (124, 10000, '', 'Mocca Swivel Cube.jpg', '254.4681', '2005-05-26 12:53:00', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (125, 10000, '', 'Reisund Round Swivel Cube.jpg', '254.4681', '2005-05-26 12:58:42', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (126, 10000, '', 'Stitch Cube.jpg', '152.3404', '2005-05-26 13:03:49', '2005-05-26 13:06:33', '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);
INSERT INTO `products` VALUES (127, 10000, '', 'Roma Leather Bin.jpg', '92.7660', '2005-05-26 13:43:17', NULL, '2005-05-27 00:00:00', '0.00', 1, 1, 0, 0);

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

#
# Table structure for table `products_attributes`
#

CREATE TABLE `products_attributes` (
  `products_attributes_id` int(11) NOT NULL auto_increment,
  `products_id` int(11) NOT NULL default '0',
  `options_id` int(11) NOT NULL default '0',
  `options_values_id` int(11) NOT NULL default '0',
  `options_values_price` decimal(15,4) NOT NULL default '0.0000',
  `price_prefix` char(1) NOT NULL default '',
  PRIMARY KEY  (`products_attributes_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=97 ;

#
# Dumping data for table `products_attributes`
#

INSERT INTO `products_attributes` VALUES (44, 33, 1, 19, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (42, 33, 1, 20, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (41, 33, 1, 18, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (40, 32, 1, 15, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (39, 32, 1, 14, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (38, 31, 2, 17, '255.3200', '+');
INSERT INTO `products_attributes` VALUES (37, 31, 2, 16, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (36, 31, 1, 15, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (35, 31, 1, 14, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (34, 29, 2, 17, '340.4200', '+');
INSERT INTO `products_attributes` VALUES (33, 29, 2, 16, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (30, 29, 1, 15, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (29, 29, 1, 14, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (45, 33, 1, 21, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (46, 33, 1, 22, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (47, 33, 1, 23, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (48, 33, 1, 24, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (49, 33, 1, 25, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (50, 33, 1, 26, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (51, 33, 1, 27, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (53, 33, 1, 28, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (54, 33, 1, 29, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (55, 34, 1, 18, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (56, 34, 1, 19, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (57, 34, 1, 20, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (58, 34, 1, 21, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (59, 34, 1, 22, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (60, 34, 1, 23, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (61, 34, 1, 24, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (62, 34, 1, 25, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (63, 34, 1, 26, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (64, 34, 1, 27, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (65, 34, 1, 28, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (66, 34, 1, 29, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (67, 49, 2, 30, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (71, 49, 2, 31, '170.2100', '+');
INSERT INTO `products_attributes` VALUES (69, 49, 2, 33, '85.1000', '+');
INSERT INTO `products_attributes` VALUES (72, 49, 2, 32, '255.3200', '+');
INSERT INTO `products_attributes` VALUES (73, 58, 2, 35, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (74, 58, 2, 34, '46.8100', '+');
INSERT INTO `products_attributes` VALUES (75, 60, 1, 15, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (88, 115, 2, 41, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (77, 63, 1, 36, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (78, 63, 1, 37, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (79, 64, 2, 38, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (80, 64, 2, 39, '209.3617', '-');
INSERT INTO `products_attributes` VALUES (87, 115, 2, 40, '127.6596', '+');
INSERT INTO `products_attributes` VALUES (89, 116, 2, 41, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (90, 116, 2, 42, '25.5319', '+');
INSERT INTO `products_attributes` VALUES (91, 119, 1, 43, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (92, 119, 1, 44, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (93, 119, 1, 45, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (94, 126, 1, 43, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (95, 126, 1, 44, '0.0000', '+');
INSERT INTO `products_attributes` VALUES (96, 126, 1, 45, '0.0000', '+');

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

#
# Table structure for table `products_attributes_download`
#

CREATE TABLE `products_attributes_download` (
  `products_attributes_id` int(11) NOT NULL default '0',
  `products_attributes_filename` varchar(255) NOT NULL default '',
  `products_attributes_maxdays` int(2) default '0',
  `products_attributes_maxcount` int(2) default '0',
  PRIMARY KEY  (`products_attributes_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table `products_attributes_download`
#

INSERT INTO `products_attributes_download` VALUES (26, 'unreal.zip', 7, 3);

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

#
# Table structure for table `products_description`
#

CREATE TABLE `products_description` (
  `products_id` int(11) NOT NULL auto_increment,
  `language_id` int(11) NOT NULL default '1',
  `products_name` varchar(64) NOT NULL default '',
  `products_description` text,
  `products_url` varchar(255) default NULL,
  `products_viewed` int(5) default '0',
  PRIMARY KEY  (`products_id`,`language_id`),
  KEY `products_name` (`products_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=129 ;

#
# Dumping data for table `products_description`
#

INSERT INTO `products_description` VALUES (45, 1, 'Aubusson Bookcase 1100', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n110 cm L x 194.8 cm H x 32 cm D<br>\r\n<br>\r\n.....................................................................', '', 55);
INSERT INTO `products_description` VALUES (124, 1, 'Mocca Swivel Cube', '<b>Description</b>\r\n<br><br>\r\nA padded footstool finished in shiny leather with a cross stitch on top. \r\n<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n47 x 47 x 49<br>\r\n\r\n<br>\r\n.....................................................................', '', 6);
INSERT INTO `products_description` VALUES (46, 1, 'Aubusson Chair - Leather Seat', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n46 cm L x 45.5/107.5 cm H x 43 cm D<br>\r\n<br>\r\n.....................................................................', '', 63);
INSERT INTO `products_description` VALUES (123, 1, 'Lush Swivel Round Cube', '<b>Description</b>\r\n<br><br>\r\nA padded footstool finished in shiny leather with a cross stitch on top. \r\n<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n47 x 47 x 49<br>\r\n\r\n<br>\r\n.....................................................................', '', 24);
INSERT INTO `products_description` VALUES (47, 1, 'Aubusson Carver - Leather Seat', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n60 cm L x 45.5/67.5/107.5 cm H x 55.5 cm D<br>\r\n<br>\r\n.....................................................................', '', 61);
INSERT INTO `products_description` VALUES (121, 1, 'Lizard Swivel cube', '<b>Description</b>\r\n<br><br>\r\nA padded footstool finished in shiny leather with a cross stitch on top. \r\n<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n47 x 47 x 49<br>\r\n\r\n<br>\r\n.....................................................................', '', 30);
INSERT INTO `products_description` VALUES (122, 1, 'Lush Leather Cube', '<b>Description</b>\r\n<br><br>\r\nA padded footstool finished in shiny leather with a cross stitch on top. Available in Cream, red or brown. <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n45 x 45 x 45<br>\r\n\r\n<br>\r\n.....................................................................', '', 34);
INSERT INTO `products_description` VALUES (48, 1, 'Aubusson Corner TV', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n106.7 cm L x 61 cm H x 56.6 cm D<br>\r\n<br>\r\n.....................................................................', '', 45);
INSERT INTO `products_description` VALUES (120, 1, 'Mocca Cube', '<b>Description</b>\r\n<br><br>\r\nA padded footstool finished in Brown mocca leather<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n45 x 45 x 45<br>\r\n\r\n<br>\r\n.....................................................................', '', 7);
INSERT INTO `products_description` VALUES (49, 1, 'Aubusson Table Rectangular', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n150/226 cm L x 77 cm H x 90 cm D<br>\r\n180/256 cm L x 77 cm H x 90 cm D<br>\r\n200/280 cm L x 77 cm H x 90 cm D<br>\r\n220/300 cm L x 77 cm H x 90 cm D<br>\r\n<br>\r\n.....................................................................', '', 416);
INSERT INTO `products_description` VALUES (75, 1, 'Swirl Fur Cushion 60X60', '<b>Description</b>\r\n<br><br>\r\nWell, it\'s swirly and it\'s furry! Available in 60x60 or 60x30 cushions, and 200x240 or 180x145 throws <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n60 x 60<br>\r\n<br>\r\n.....................................................................', '', 11);
INSERT INTO `products_description` VALUES (76, 1, 'Short Feather Caramel Cushion 50x50', '<b>Description</b>\r\n<br><br>\r\nBest quality cotton velvet trimmed with contrasting short feathers.An elegant 50x50 cushion.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n60 x 60<br>\r\n<br>\r\n.....................................................................', '', 12);
INSERT INTO `products_description` VALUES (50, 1, 'Aubusson Entertainment Unit', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n132.8 cm L x 91.2 cm H x 49 cm D<br>\r\n<br>\r\n.....................................................................', '', 61);
INSERT INTO `products_description` VALUES (119, 1, 'Long Stitch Cube', '<b>Description</b>\r\n<br><br>\r\nA padded footstool finished in shiny leather with a cross stitch on top. Available in <a href="images/Long Stitch Cube-cream.jpg" target="_blank">Cream</a>, red or <a href="images/Long Stitch Cube-brown.jpg" target="_blank">brown</a><br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n120 x 45 x 45<br>\r\n\r\n<br>\r\n.....................................................................', '', 55);
INSERT INTO `products_description` VALUES (51, 1, 'Aubusson Coffee Table Drink Unit', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n130 cm L x 48.5 cm H x 75 cm D<br>\r\n<br>\r\n.....................................................................', '', 62);
INSERT INTO `products_description` VALUES (117, 1, 'Funky Stool', '<b>Description</b>\r\n<br><br>\r\nA brown mahogany stool with a black leather weaved seating.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n39 x 39 x 46 <br>\r\n\r\n<br>\r\n.....................................................................', '', 24);
INSERT INTO `products_description` VALUES (118, 1, 'Saddler Stool', '<b>Description</b>\r\n<br><br>\r\nOur Saddler stool is practical and appealing, using leather and wood.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n70 x 35 x 50<br>\r\n\r\n<br>\r\n.....................................................................', '', 30);
INSERT INTO `products_description` VALUES (52, 1, 'Aubusson Hi-Fi Unit 1 Door 1 Drawer', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n66.4 cm L x 91.2 cm H x 49 cm D<br>\r\n<br>\r\n.....................................................................', '', 14);
INSERT INTO `products_description` VALUES (116, 1, 'Yacht', '<b>Description</b>\r\n<br><br>\r\nfulfill your dreams and sail away in our amazing yacht.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\nSmall: 76cm x 92.5cm x 12cm <br>\r\nLarge: 100cm x 124cm x 17cm <br>\r\n<br>\r\n.....................................................................', '', 23);
INSERT INTO `products_description` VALUES (53, 1, 'Aubusson Lamp Table', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n57 cm L x 57 cm H x 57 cm D<br>\r\n<br>\r\n.....................................................................', '', 45);
INSERT INTO `products_description` VALUES (115, 1, 'Large Yacht', '<b>Description</b>\r\n<br><br>\r\nfulfill your dreams and sail away in our amazing yacht.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\nSmall: 76cm x 92.5cm x 12cm <br>\r\nLarge: 199cm x 27cm x 229cm <br>\r\n<br>\r\n.....................................................................', '', 40);
INSERT INTO `products_description` VALUES (74, 1, 'Swirl Fur Cushion 60X30', '<b>Description</b>\r\n<br><br>\r\nWell, it\'s swirly and it\'s furry! Available in 60x60 or 60x30 cushions, and 200x240 or 180x145 throws<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n45 x 45<br>\r\n<br>\r\n.....................................................................', '', 6);
INSERT INTO `products_description` VALUES (54, 1, 'Aubusson Chair – Rush Seat', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n46 cm L x 45.5/107.5 cm H x 43 cm D<br>\r\n<br>\r\n.....................................................................', '', 39);
INSERT INTO `products_description` VALUES (113, 1, 'Double Wall Sconce', '<b>Description</b>\r\n<br><br>\r\nA mixture of traditional and contemporary, which a touch of rustic.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n13 x 27 x 39<br>\r\n\r\n<br>\r\n.....................................................................', '', 30);
INSERT INTO `products_description` VALUES (114, 1, 'Large Egg Timer', '<b>Description</b>\r\n<br><br>\r\nNo more problems with your boiled eggs now. <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n24 x 24 28<br>\r\n\r\n<br>\r\n.....................................................................', '', 31);
INSERT INTO `products_description` VALUES (55, 1, 'Aubusson Carver – Rush Seat', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n60 cm L x 45.5/67.5/107.5 cm H x 55.5 cm D<br>\r\n<br>\r\n.....................................................................', '', 31);
INSERT INTO `products_description` VALUES (112, 1, 'Masal Iron Large', '<b>Description</b>\r\n<br><br>\r\nMasal Iron Large - Impressive wall torch traditionally fabricated in steel and sheesem wood.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\nLarge: 31cm x 22cm x 133cm<br>\r\n\r\n<br>\r\n.....................................................................', '', 15);
INSERT INTO `products_description` VALUES (56, 1, 'Aubusson Bookcase 780', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n78 cm L x 194.8 cm H x 32 cm D<br>\r\n<br>\r\n.....................................................................', '', 37);
INSERT INTO `products_description` VALUES (111, 1, 'Masal Iron', '<b>Description</b>\r\n<br><br>\r\nMasal Iron - Impressive wall torch traditionally fabricated in steel and sheesem wood.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\nSmall: 28cm x 17cm x 100cm<br>\r\n\r\n<br>\r\n.....................................................................', '', 9);
INSERT INTO `products_description` VALUES (57, 1, 'Aubusson Dresser Open Top', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n132.8 cm L x 103.6 cm H x 32 cm D<br>\r\n<br>\r\n.....................................................................', '', 24);
INSERT INTO `products_description` VALUES (110, 1, 'Candlesticks', '<b>Description</b>\r\n<br><br>\r\nSmall 5 Branch: Small 5 Candlestick: Finished at EPNS this traditional style c/stick would grace any table.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\nLarge 5 Branch: 150 cm<br>\r\nSmall 3 Branch: 85 cm<br>\r\n<br>\r\n.....................................................................', '', 44);
INSERT INTO `products_description` VALUES (58, 1, 'Aubusson Wall Mirror', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n132.8 cm L x 103.6 cm H x 43 cm D<br>\r\n188.4 cm L x 103.6 cm H x 43 cm D<br>\r\n<br>\r\n.....................................................................', '', 114);
INSERT INTO `products_description` VALUES (108, 1, 'Reisund Steel Leather Mirror', '<b>Description</b>\r\n<br><br>\r\nSmall rectangular mirror in a dark brown reisund leather frame with a steel edging.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n96 x 70<br>\r\n\r\n<br>\r\n.....................................................................', '', 7);
INSERT INTO `products_description` VALUES (109, 1, 'Reisund Steel Leather Mirror', '<b>Description</b>\r\n<br><br>\r\nLarge rectangular mirror in a dark brown reisund leather frame with a steel edging.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n121 x 90<br>\r\n\r\n<br>\r\n.....................................................................', '', 8);
INSERT INTO `products_description` VALUES (59, 1, 'Country Collection Oval Table', '<b>Description</b>\r\n<br><br>\r\nA traditional design with a modern twist. Made from solid oak that has been waxed and hand polished giving a fresh look, coupled with the rustic charm of aged.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n190/270 cm L x 77 cm H x 110 cm W<br>\r\n<br>\r\n.....................................................................', '', 184);
INSERT INTO `products_description` VALUES (107, 1, 'Reisund Leather Mirror - Large', '<b>Description</b>\r\n<br><br>\r\nLarge rectangular mirror in a stitched dark brown reisund leather frame. \r\n<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n120 x 90<br>\r\n\r\n<br>\r\n.....................................................................', '', 13);
INSERT INTO `products_description` VALUES (60, 1, 'Antibes Mirror', '<b>Description</b>\r\n<br><br>\r\nA combination of both lacquer and wax on the finish gives this range timeless elegance, which will suit a variety of environments.<br><br>\r\nAvailable colours : Clear Laquered or Nuit<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n120 cm L x 90 cm W<br>\r\n<br>\r\n.....................................................................', '', 155);
INSERT INTO `products_description` VALUES (91, 1, 'Cognac Dress Leather Mirror', '<b>Description</b>\r\n<br><br>\r\nTall rectangular dress mirror finished in light brown padded and stitched leather.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n64 x 150<br>\r\n<br>\r\n.....................................................................', '', 11);
INSERT INTO `products_description` VALUES (92, 1, 'Cottage Pine Mirror', '<b>Description</b>\r\n<br><br>\r\nThe Cottage Pine collection has a rustic feel but maintains a versatility which enables it to sit comfortably in both the town and country. Available as both dining and bedroom collections.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n64 x 150<br>\r\n<br>\r\n.....................................................................', '', 5);
INSERT INTO `products_description` VALUES (93, 1, 'Crocco Large Leather Mirror', '<b>Description</b>\r\n<br><br>\r\nLarge rectangular mirror finished in a light brown leather giving a unique crocodile skin finish. <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n120 x 90<br>\r\n<br>\r\n.....................................................................', '', 9);
INSERT INTO `products_description` VALUES (94, 1, 'Mocca Mirror Large', '<b>Description</b>\r\n<br><br>\r\nLarge rectangular mirror finished in a brown padded stitched leather.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n121 x 90<br>\r\n<br>\r\n.....................................................................', '', 10);
INSERT INTO `products_description` VALUES (95, 1, 'Mocca Mirror Small', '<b>Description</b>\r\n<br><br>\r\nLarge rectangular mirror finished in a brown padded stitched leather.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n69 x 79<br>\r\n<br>\r\n.....................................................................', '', 8);
INSERT INTO `products_description` VALUES (96, 1, 'Numeral Round Mirror Small', '<b>Description</b>\r\n<br><br>\r\nA mixture of ancient and modern.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\nSmall 50.5cm x 3cm x 50.5cm<br>\r\n\r\n<br>\r\n.....................................................................', '', 11);
INSERT INTO `products_description` VALUES (97, 1, 'Numeral Round Mirror Medium', '<b>Description</b>\r\n<br><br>\r\nA mixture of ancient and modern.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\nMedium 92cm x 3cm x 92cm<br>\r\n\r\n<br>\r\n.....................................................................', '', 14);
INSERT INTO `products_description` VALUES (98, 1, 'Saddler Mirror', '<b>Description</b>\r\n<br><br>\r\nSaddler is our new range of stained Acacia wood furniture from the same stable as the Sheppee@Halo ranges. It features inlayed leather ‘tiles’ creating a stunningly unique look. <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n121 x 90 x 5.5<br>\r\n\r\n<br>\r\n.....................................................................', '', 15);
INSERT INTO `products_description` VALUES (99, 1, 'Stockholm light Mirror', '<b>Description</b>\r\n<br><br>\r\nSolid, clean lines in Oak with 3 finishes, great hardware and finger jointed detail producing a very commercial range. Available also in both bedroom and dining.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n138 x 91 x 3<br>\r\n\r\n<br>\r\n.....................................................................', '', 10);
INSERT INTO `products_description` VALUES (100, 1, 'Stockholm Nuit Mirror', '<b>Description</b>\r\n<br><br>\r\nSolid, clean lines in Oak with 3 finishes, great hardware and finger jointed detail producing a very commercial range. Available also in both bedroom and dining. \r\n<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n138 x 91 x 3<br>\r\n\r\n<br>\r\n.....................................................................', '', 10);
INSERT INTO `products_description` VALUES (101, 1, 'Sultan Mirror', '<b>Description</b>\r\n<br><br>\r\nA wide range bedroom furniture, hand stitched and finished in a vegetable tan leather.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n69 x 5 x 79<br>\r\n\r\n<br>\r\n.....................................................................', '', 10);
INSERT INTO `products_description` VALUES (102, 1, 'Verona Large Mirror', '<b>Description</b>\r\n<br><br>\r\nTimeless lines and a quality finish on charming acacia wood produces an enduring collection of practical furniture. <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n69 x 5 x 79<br>\r\n\r\n<br>\r\n.....................................................................', '', 9);
INSERT INTO `products_description` VALUES (103, 1, 'Opio Mirror', '<b>Description</b>\r\n<br><br>\r\nA contemporary range of dining and bedroom furniture in a light coloured, oiled oak. With its clean lines and simplicity the Opio Oak collection is a contemporary classic.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n122 x 5 x 76<br>\r\n\r\n<br>\r\n.....................................................................', '', 15);
INSERT INTO `products_description` VALUES (104, 1, 'Paris Mirror', '<b>Description</b>\r\n<br><br>\r\nCircular mirror based in a square brown leather stitched frame.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n90 x 90<br>\r\n\r\n<br>\r\n.....................................................................', '', 15);
INSERT INTO `products_description` VALUES (105, 1, 'Reisund Chrome Leather Mirror', '<b>Description</b>\r\n<br><br>\r\nLarge rectangular mirror finished in dark brown leather with square steel corners.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n69 x 79<br>\r\n\r\n<br>\r\n.....................................................................', '', 11);
INSERT INTO `products_description` VALUES (106, 1, 'Reisund Leather Mirror - Small', '<b>Description</b>\r\n<br><br>\r\nSmall rectangular mirror in a stitched dark brown reisund leather frame. \r\n<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n69 x 79<br>\r\n<br>\r\n.....................................................................', '', 6);
INSERT INTO `products_description` VALUES (66, 1, 'Alps Cushion 60x60', '<b>Description</b>\r\n<br><br>\r\nA great alternative to our Genuine Mongolian range this long haired white 60x60 cushion.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n60 x 60<br>\r\n<br>\r\n.....................................................................', '', 35);
INSERT INTO `products_description` VALUES (67, 1, 'Grizzly Cushion 60x60', '<b>Description</b>\r\n<br><br>\r\nGrizzly Cushion Black luxury, with hints of silver and greys available in 60x60 and 60x30<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n60 x 60<br>\r\n<br>\r\n.....................................................................', '', 35);
INSERT INTO `products_description` VALUES (68, 1, 'New Polar Cushion 60x60', '<b>Description</b>\r\n<br><br>\r\nToo soft to describe, available in 60x60 and 30x60 also to match large a throw 200x240 and small in 145x180 <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n60 x 60<br>\r\n<br>\r\n.....................................................................', '', 13);
INSERT INTO `products_description` VALUES (69, 1, 'Lamb Ecru Cushion 60x30', '<b>Description</b>\r\n<br><br>\r\nFull luxury Faux Fur outer and full feather inner. Colour: Ecru, available in 60x60 and 60x30 <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n60 x 30<br>\r\n<br>\r\n.....................................................................', '', 22);
INSERT INTO `products_description` VALUES (37, 1, 'Aubusson 4 Door Cabinet - Base Unit', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n243.6 cm L x 91.2 cm H x 49 cm D<br>\r\n<br>\r\n.....................................................................', '', 19);
INSERT INTO `products_description` VALUES (89, 1, 'Black Steel Canted Mirror', '<b>Description</b>\r\n<br><br>\r\nBlack leather canted mirror with unique steel inlay. . <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n96 x 70<br>\r\n<br>\r\n.....................................................................', '', 25);
INSERT INTO `products_description` VALUES (90, 1, 'Clock Mirror', '<b>Description</b>\r\n<br><br>\r\nCircular mirror based on a large square steel clock face with steel roman numerals. <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n120cm x 120cm<br>\r\n<br>\r\n.....................................................................', '', 19);
INSERT INTO `products_description` VALUES (38, 1, 'Aubusson 4 Door Cabinet – Dresser Top', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n243.6 cm L x 103.6 cm H x 41.5 cm D<br>\r\n<br>\r\n.....................................................................', '', 13);
INSERT INTO `products_description` VALUES (88, 1, 'Andorra Mirror', '<b>Description</b>\r\n<br><br>\r\nA Rectangular inlayed mirror in Light Oak. <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n120cm x 5cm x 90cm<br>\r\n<br>\r\n.....................................................................', '', 30);
INSERT INTO `products_description` VALUES (39, 1, 'Aubusson 3 Door Cabinet - Base Unit', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n188.4 cm L x 91.2 cm H x 49 cm D<br>\r\n<br>\r\n.....................................................................', '', 57);
INSERT INTO `products_description` VALUES (86, 1, 'Large Hanging Clock', '<b>Description</b>\r\n<br><br>\r\nShort of space for a large clock? Hang it from the ceiling! .<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n48 x 35 x 46<br>\r\n<br>\r\n.....................................................................', '', 35);
INSERT INTO `products_description` VALUES (87, 1, 'Large Hanging Scounce', '<b>Description</b>\r\n<br><br>\r\nThat can’t be the light from just one candle <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n25 x 25 x 43<br>\r\n<br>\r\n.....................................................................', '', 41);
INSERT INTO `products_description` VALUES (40, 1, 'Aubusson 3 Door Cabinet – Dresser Top', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n188.4 cm L x 103.6 cm H x 41.5 cm D<br>\r\n<br>\r\n.....................................................................', '', 30);
INSERT INTO `products_description` VALUES (85, 1, 'Little Ben Clock', '<b>Description</b>\r\n<br><br>\r\nA traditional nickel mantel clock.<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\nAwaiting Specifications<br>\r\n<br>\r\n.....................................................................', '', 44);
INSERT INTO `products_description` VALUES (41, 1, 'Aubusson 2 Door Cabinet - Base Unit', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n132.8 cm L x 91.2 cm H x 49 cm D<br>\r\n<br>\r\n.....................................................................', '', 70);
INSERT INTO `products_description` VALUES (84, 1, 'White Feather Throw 240x200', '<b>Description</b>\r\n<br><br>\r\nWell, it\'s swirly and it\'s furry! Available in 60x60 or 60x30 cushions, and 200x240 or 180x145 throws <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n200 x 240<br>\r\n<br>\r\n.....................................................................', '', 11);
INSERT INTO `products_description` VALUES (42, 1, 'Aubusson 2 Door Cabinet – Dresser Top', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n132.8 cm L x 103.6 cm H x 41.5 cm D<br>\r\n<br>\r\n.....................................................................', '', 41);
INSERT INTO `products_description` VALUES (82, 1, 'Lamb Graphite Throw 240x200', '<b>Description</b>\r\n<br><br>\r\nLong hair Luxury with full feather filling, cushions in 60x60 or 30x60 and throws 140x180 or 200x240 <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n200 x 240<br>\r\n<br>\r\n.....................................................................', '', 5);
INSERT INTO `products_description` VALUES (83, 1, 'Swirl Fur Throw 240x200', '<b>Description</b>\r\n<br><br>\r\nWell, it\'s swirly and it\'s furry! Available in 60x60 or 60x30 cushions, and 200x240 or 180x145 throws <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n200 x 240<br>\r\n<br>\r\n.....................................................................', '', 9);
INSERT INTO `products_description` VALUES (43, 1, 'Aubusson Hi-Fi Unit 1 Door', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n66.4 cm L x 91.2 cm H x 49 cm D<br>\r\n<br>\r\n.....................................................................', '', 13);
INSERT INTO `products_description` VALUES (127, 1, 'Roma Leather Bin', '<b>Description</b>\r\n<br><br>\r\nDurable luxurious leather bin to throw your waste away<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n32cm x 32cm x 41cm<br>\r\n\r\n<br>\r\n.....................................................................', '', 28);
INSERT INTO `products_description` VALUES (128, 1, 'White Coffee Wood Mirror', '<b>Description</b>\r\n<br><br>\r\nWhite coffee wood dressing frame mirror. <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n80cm Length x 72cm Width x 23cm Depth<br>\r\n<br>\r\n.....................................................................', '', 35);
INSERT INTO `products_description` VALUES (81, 1, 'Lamb Ecru Throw 240x200', '<b>Description</b>\r\n<br><br>\r\nFull luxury Faux Fur outer and full feather inner. Colour: Ecru, available in 200x240 and 145x180<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n200 x 240<br>\r\n<br>\r\n.....................................................................', '', 32);
INSERT INTO `products_description` VALUES (44, 1, 'Aubusson Coffee Table', '<b>Description</b>\r\n<br><br>\r\nA reinvented traditional oak look, which was inspired by the Arts and Crafts of the 21st Century. With there clean lines and a light matt finish. The Aubusson range is ideal for any home.<br><br>\r\n\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n130 cm L x 48.5 cm H x 75 cm W<br>\r\n<br>\r\n.....................................................................', '', 46);
INSERT INTO `products_description` VALUES (126, 1, 'Stitch Cube', '<b>Description</b>\r\n<br><br>\r\nA padded footstool finished in shiny leather with a cross stitch on top. Available in <a href="images/Stitch Cube-cream.jpg" target="_blank">Cream</a>, red or <a href="images/Stitch Cube-brown.jpg" target="_blank">brown</a><br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n45 x 45 x 45<br>\r\n\r\n<br>\r\n.....................................................................', '', 25);
INSERT INTO `products_description` VALUES (80, 1, 'New Pola Throw 240x200', '<b>Description</b>\r\n<br><br>\r\nCuddle up in this super soft opulence, available in 60x60 and 30x60 also to match large a throw 200x240 and small in 145x180 \r\n<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n200 x 240<br>\r\n<br>\r\n.....................................................................', '', 7);
INSERT INTO `products_description` VALUES (71, 1, 'Lamb Graphite Cushion 60X30', '<b>Description</b>\r\n<br><br>\r\nLong hair Luxury with full feather filling, cushions in 60x60 or 30x60 and throws 140x180 or 200x240 \r\n <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n60 x 30<br>\r\n<br>\r\n.....................................................................', '', 6);
INSERT INTO `products_description` VALUES (72, 1, 'Lamb Graphite Cushion 60X60', '<b>Description</b>\r\n<br><br>\r\nLong hair Luxury with full feather filling, cushions in 60x60 or 30x60 and throws 140x180 or 200x240 <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n60 x 60<br>\r\n<br>\r\n.....................................................................', '', 9);
INSERT INTO `products_description` VALUES (32, 1, 'Plum Oak Dining Chair', '<b>Description</b>\r\n<br><br>\r\nA solid oak chair in a modern ladder back style, comes with leather seating pad. Will compliment any similar styled table.<br><br>\r\nAvailable colours: Nuit or Clear Laqured<br>\r\nImage shown in \'Clear Laquered Brown Seat<br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n47 cm L x 106 cm H x 48 cm D<br>\r\n<br>\r\n.....................................................................', '', 139);
INSERT INTO `products_description` VALUES (77, 1, 'Alps Throw 220x240', '<b>Description</b>\r\n<br><br>\r\nA great alternative to our Genuine Mongolian range this long haired white 220x240 throw and 60x60 cushion offer remarkable value<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n220 x 240<br>\r\n<br>\r\n.....................................................................', '', 27);
INSERT INTO `products_description` VALUES (78, 1, 'Arctic Wolf Throw 240x200', '<b>Description</b>\r\n<br><br>\r\nSuper soft best seller to suit any home, available in 60x60 or 60x30 cushions, and 145x180 or 200x240 throws<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n200 x 240<br>\r\n<br>\r\n.....................................................................', '', 32);
INSERT INTO `products_description` VALUES (79, 1, 'Grizzly Throw 240x200', '<b>Description</b>\r\n<br><br>\r\nCuddle up in this soft luxury, available in 200x240 and 145x180<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n200 x 240<br>\r\n<br>\r\n.....................................................................', '', 35);
INSERT INTO `products_description` VALUES (33, 1, 'Rollback Dining Chair', '<b>Description</b>\r\n<br><br>\r\nThe stylish Rollback Dining Chair is upholstered in a Reisund leather, with a rolled over top.<br><br>\r\nAvailable in 12 different styles<br>\r\nImage shown in \'Dark Leg Brown\'<br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n46 cm L x 107 cm H  x 46 cm D<br>\r\n<br>\r\n.....................................................................', '', 183);
INSERT INTO `products_description` VALUES (125, 1, 'Reisund Round Swivel Cube', '<b>Description</b>\r\n<br><br>\r\nA padded footstool finished in shiny leather with a cross stitch on top. \r\n<br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n47 x 47 x 49<br>\r\n\r\n<br>\r\n.....................................................................', '', 7);
INSERT INTO `products_description` VALUES (29, 1, 'Plum Oak Sideboard', '<b>Description</b>\r\n<br><br>\r\nThis sideboard is a prime example of excellent contemporary design.<br><br>\r\nAvailable colours: Nuit or ClearLaqured<br>\r\nImage shown in Clear Laqured<br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n5\': 152 cm L x 77cm H x 57cm D<br>\r\n6\': 183 cm L x 77cm H x 57cm D<br>\r\n<br>\r\n.....................................................................', '', 467);
INSERT INTO `products_description` VALUES (70, 1, 'Lamb Ecru Cushion 60X60', '<b>Description</b>\r\n<br><br>\r\nFull luxury Faux Fur outer and full feather inner. Colour: Ecru, available in 60x60 and 60x30 <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n60 x 60<br>\r\n<br>\r\n.....................................................................', '', 31);
INSERT INTO `products_description` VALUES (73, 1, 'Macro Suede Pannel Biscuit and Oatmeal 45x45', '<b>Description</b>\r\n<br><br>\r\nMade with the revolutionary \'Wipe-clean\' MACROSUEDE and feather filled <br><br>\r\n\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n45 x 45<br>\r\n<br>\r\n.....................................................................', '', 9);
INSERT INTO `products_description` VALUES (34, 1, 'Soho Dining Chair', '<b>Description</b>\r\n<br><br>\r\nThe stylish Soho Dining Chair is upholstered in Reisund leather.<br><br>\r\nAvailable in 12 various colours<br>\r\nImage shown in \'Dark Leg Brown\'<br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n46 cm L x 107 cm H  x 46 cm D<br>\r\n\r\n<br>\r\n.....................................................................', '', 97);
INSERT INTO `products_description` VALUES (31, 1, 'Plum Oak Dining Table', '<b>Description</b>\r\n<br><br>\r\nThis Dining Table is made using solid oak . It can also be extended to 8ft and 9ft respectively if required.<br><br>\r\nColours: Nuit or Clear Laquered<br>\r\nImage shown in Nuit<br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n5\': 152/244 cm L x 76cm H x 91.5cm W<br>\r\n6\': 183/274 cm L x 76cm H x 91.5cm W<br>\r\n<br>\r\n.....................................................................', '', 548);
INSERT INTO `products_description` VALUES (63, 1, 'Twig Lights', '<b>Description</b>\r\n<br><br>\r\nAn extremely popular light sold in our stores, this novel light will add style to any room.<br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n1.6 Metres in height, comprized of 15 lights <br>\r\n<br>\r\n.....................................................................', '', 176);
INSERT INTO `products_description` VALUES (64, 1, 'Giant and Small Lampshade', '<b>Description</b>\r\n<br><br>\r\nThis stunning and original light come chandelier will fill your room with a rich light which cannot fail to impress. Giant shown. <br><br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Dimensions</b>\r\n<br><br>\r\n90cm Lampshade (Giant) <br>\r\n53cm Lampshade (Small) <br>\r\n<br>\r\n.....................................................................', '', 198);
INSERT INTO `products_description` VALUES (65, 1, 'Large Plumbridge Table & 8 Chairs', '<b>Description</b>\r\n<br><br>\r\nThis Dining Table is made using solid oak. It can also be extended to 9ft if required. The chairs which come with this table are solid and finished in high quality leather. This is an exceptional table with equally exceptional chairs.<br>\r\nLarge Plumbridge Table, 2 Rollback dining chairs, 6 Plum chairs<br><br>\r\n.....................................................................\r\n<br><br>\r\n<b>Special Offer - Limited availability</b><br><br>\r\nIndividual sale price £2965<br>\r\nSpecial offer            £1695<br><br>\r\n<b>Saving                    £1270</b><br><br>\r\n<b>ONLY 6 SETS OF TABLE & CHAIRS LEFT</b><br><br>\r\n.....................................................................\r\n<br><br>\r\nAll individual items can be seen seperately here (copy the links and paste into your broswer bar):<br><br>\r\nTable: http://www.marshas.co.uk/catalog/product_info.php?cPath=22_26&products_id=31<br><br>\r\nChairs: http://www.marshas.co.uk/catalog/product_info.php?cPath=22_27&products_id=33<br><br>\r\nChairs: http://www.marshas.co.uk/catalog/product_info.php?cPath=22_27&products_id=32<br><br>\r\nTable Colour: Clear Laquered<br><br>\r\nChairs: Brown Leather Light Leg<br><br>\r\nImage shown in Clear with Brown Rollback Chairs<br>\r\n<br>\r\n.....................................................................\r\n<br><br>\r\n<b>Table Dimensions</b>\r\n<br><br>\r\n6ftTable ext to 9ft: 183/274 cm L x 76cm H x 91.5cm W<br><br>\r\nChairs: 46 cm L x 107 cm H x 46 cm D<br>\r\nChairs: 47 cm L x 106 cm H x 48 cm D<br>\r\n.....................................................................', '', 706);

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

#
# Table structure for table `products_notifications`
#

CREATE TABLE `products_notifications` (
  `products_id` int(11) NOT NULL default '0',
  `customers_id` int(11) NOT NULL default '0',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`products_id`,`customers_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table `products_notifications`
#

INSERT INTO `products_notifications` VALUES (0, 3, '2005-02-21 11:25:04');
INSERT INTO `products_notifications` VALUES (29, 3, '2005-02-21 13:31:44');
INSERT INTO `products_notifications` VALUES (58, 4, '2005-02-28 17:24:52');
INSERT INTO `products_notifications` VALUES (0, 10, '2005-03-02 13:14:42');
INSERT INTO `products_notifications` VALUES (0, 17, '2005-03-24 11:34:24');
INSERT INTO `products_notifications` VALUES (64, 26, '2005-04-19 11:24:51');
INSERT INTO `products_notifications` VALUES (0, 45, '2005-08-06 09:47:51');
INSERT INTO `products_notifications` VALUES (59, 48, '2005-09-05 13:03:49');
INSERT INTO `products_notifications` VALUES (65, 49, '2005-09-06 22:03:20');
INSERT INTO `products_notifications` VALUES (65, 58, '2005-11-09 13:51:21');

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

#
# Table structure for table `products_options`
#

CREATE TABLE `products_options` (
  `products_options_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `products_options_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`products_options_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table `products_options`
#

INSERT INTO `products_options` VALUES (1, 1, 'Color');
INSERT INTO `products_options` VALUES (2, 1, 'Size');

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

#
# Table structure for table `products_options_values`
#

CREATE TABLE `products_options_values` (
  `products_options_values_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `products_options_values_name` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`products_options_values_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table `products_options_values`
#

INSERT INTO `products_options_values` VALUES (20, 1, 'Clear Laquered Leg - Lush');
INSERT INTO `products_options_values` VALUES (19, 1, 'Clear Laquered Leg - Mocca');
INSERT INTO `products_options_values` VALUES (18, 1, 'Clear Laquered Leg - Brown');
INSERT INTO `products_options_values` VALUES (17, 1, '6\' (183 cm)');
INSERT INTO `products_options_values` VALUES (16, 1, '5\' (152 cm)');
INSERT INTO `products_options_values` VALUES (14, 1, 'Nuit');
INSERT INTO `products_options_values` VALUES (15, 1, 'Clear Laquered');
INSERT INTO `products_options_values` VALUES (21, 1, 'Clear Laquered Leg - Black');
INSERT INTO `products_options_values` VALUES (45, 1, 'Brown');
INSERT INTO `products_options_values` VALUES (22, 1, 'Clear Laquered Leg - Ivory');
INSERT INTO `products_options_values` VALUES (44, 1, 'Red');
INSERT INTO `products_options_values` VALUES (23, 1, 'Clear Laquered Leg - Red');
INSERT INTO `products_options_values` VALUES (43, 1, 'Cream');
INSERT INTO `products_options_values` VALUES (24, 1, 'Dark Leg - Brown');
INSERT INTO `products_options_values` VALUES (25, 1, 'Dark Leg - Mocca');
INSERT INTO `products_options_values` VALUES (42, 1, '100cm x 124cm x 17cm');
INSERT INTO `products_options_values` VALUES (26, 1, 'Dark Leg - Lush');
INSERT INTO `products_options_values` VALUES (27, 1, 'Dark Leg - Black');
INSERT INTO `products_options_values` VALUES (41, 1, '76cm x 92.5cm x 12cm');
INSERT INTO `products_options_values` VALUES (28, 1, 'Dark Leg - Ivory');
INSERT INTO `products_options_values` VALUES (29, 1, 'Dark Leg - Red');
INSERT INTO `products_options_values` VALUES (40, 1, '199cm x 27cm x 229cm');
INSERT INTO `products_options_values` VALUES (30, 1, '1.5 m (150 cm)');
INSERT INTO `products_options_values` VALUES (31, 1, '2.0 m (200 cm)');
INSERT INTO `products_options_values` VALUES (39, 1, 'Small 53cm');
INSERT INTO `products_options_values` VALUES (32, 1, '2.2 m (220 cm)');
INSERT INTO `products_options_values` VALUES (33, 1, '1.8 m (180 cm)');
INSERT INTO `products_options_values` VALUES (38, 1, 'Giant 90cm');
INSERT INTO `products_options_values` VALUES (34, 1, '188.4 cm (L)');
INSERT INTO `products_options_values` VALUES (37, 1, 'White');
INSERT INTO `products_options_values` VALUES (35, 1, '132.8 cm (L)');
INSERT INTO `products_options_values` VALUES (36, 1, 'Natural (Brown)');

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

#
# Table structure for table `products_options_values_to_products_options`
#

CREATE TABLE `products_options_values_to_products_options` (
  `products_options_values_to_products_options_id` int(11) NOT NULL auto_increment,
  `products_options_id` int(11) NOT NULL default '0',
  `products_options_values_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`products_options_values_to_products_options_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=50 ;

#
# Dumping data for table `products_options_values_to_products_options`
#

INSERT INTO `products_options_values_to_products_options` VALUES (26, 1, 26);
INSERT INTO `products_options_values_to_products_options` VALUES (25, 1, 25);
INSERT INTO `products_options_values_to_products_options` VALUES (24, 1, 24);
INSERT INTO `products_options_values_to_products_options` VALUES (23, 1, 23);
INSERT INTO `products_options_values_to_products_options` VALUES (22, 1, 22);
INSERT INTO `products_options_values_to_products_options` VALUES (21, 1, 21);
INSERT INTO `products_options_values_to_products_options` VALUES (20, 1, 20);
INSERT INTO `products_options_values_to_products_options` VALUES (19, 1, 19);
INSERT INTO `products_options_values_to_products_options` VALUES (18, 1, 18);
INSERT INTO `products_options_values_to_products_options` VALUES (17, 2, 17);
INSERT INTO `products_options_values_to_products_options` VALUES (16, 2, 16);
INSERT INTO `products_options_values_to_products_options` VALUES (14, 1, 14);
INSERT INTO `products_options_values_to_products_options` VALUES (15, 1, 15);
INSERT INTO `products_options_values_to_products_options` VALUES (27, 1, 27);
INSERT INTO `products_options_values_to_products_options` VALUES (28, 1, 28);
INSERT INTO `products_options_values_to_products_options` VALUES (29, 1, 29);
INSERT INTO `products_options_values_to_products_options` VALUES (30, 2, 30);
INSERT INTO `products_options_values_to_products_options` VALUES (31, 2, 31);
INSERT INTO `products_options_values_to_products_options` VALUES (32, 2, 32);
INSERT INTO `products_options_values_to_products_options` VALUES (33, 2, 33);
INSERT INTO `products_options_values_to_products_options` VALUES (34, 2, 34);
INSERT INTO `products_options_values_to_products_options` VALUES (35, 2, 35);
INSERT INTO `products_options_values_to_products_options` VALUES (36, 1, 36);
INSERT INTO `products_options_values_to_products_options` VALUES (37, 1, 37);
INSERT INTO `products_options_values_to_products_options` VALUES (38, 2, 38);
INSERT INTO `products_options_values_to_products_options` VALUES (39, 2, 39);
INSERT INTO `products_options_values_to_products_options` VALUES (44, 2, 40);
INSERT INTO `products_options_values_to_products_options` VALUES (45, 2, 41);
INSERT INTO `products_options_values_to_products_options` VALUES (46, 2, 42);
INSERT INTO `products_options_values_to_products_options` VALUES (47, 1, 43);
INSERT INTO `products_options_values_to_products_options` VALUES (48, 1, 44);
INSERT INTO `products_options_values_to_products_options` VALUES (49, 1, 45);

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

#
# Table structure for table `products_to_categories`
#

CREATE TABLE `products_to_categories` (
  `products_id` int(11) NOT NULL default '0',
  `categories_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`products_id`,`categories_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table `products_to_categories`
#

INSERT INTO `products_to_categories` VALUES (29, 23);
INSERT INTO `products_to_categories` VALUES (31, 26);
INSERT INTO `products_to_categories` VALUES (32, 27);
INSERT INTO `products_to_categories` VALUES (33, 27);
INSERT INTO `products_to_categories` VALUES (34, 27);
INSERT INTO `products_to_categories` VALUES (37, 28);
INSERT INTO `products_to_categories` VALUES (38, 28);
INSERT INTO `products_to_categories` VALUES (39, 28);
INSERT INTO `products_to_categories` VALUES (40, 28);
INSERT INTO `products_to_categories` VALUES (41, 28);
INSERT INTO `products_to_categories` VALUES (42, 28);
INSERT INTO `products_to_categories` VALUES (43, 30);
INSERT INTO `products_to_categories` VALUES (44, 29);
INSERT INTO `products_to_categories` VALUES (45, 30);
INSERT INTO `products_to_categories` VALUES (46, 27);
INSERT INTO `products_to_categories` VALUES (47, 27);
INSERT INTO `products_to_categories` VALUES (48, 30);
INSERT INTO `products_to_categories` VALUES (49, 26);
INSERT INTO `products_to_categories` VALUES (50, 30);
INSERT INTO `products_to_categories` VALUES (51, 29);
INSERT INTO `products_to_categories` VALUES (52, 30);
INSERT INTO `products_to_categories` VALUES (53, 29);
INSERT INTO `products_to_categories` VALUES (54, 27);
INSERT INTO `products_to_categories` VALUES (55, 27);
INSERT INTO `products_to_categories` VALUES (56, 30);
INSERT INTO `products_to_categories` VALUES (57, 28);
INSERT INTO `products_to_categories` VALUES (58, 31);
INSERT INTO `products_to_categories` VALUES (59, 26);
INSERT INTO `products_to_categories` VALUES (60, 31);
INSERT INTO `products_to_categories` VALUES (63, 32);
INSERT INTO `products_to_categories` VALUES (64, 32);
INSERT INTO `products_to_categories` VALUES (65, 34);
INSERT INTO `products_to_categories` VALUES (65, 35);
INSERT INTO `products_to_categories` VALUES (66, 36);
INSERT INTO `products_to_categories` VALUES (67, 36);
INSERT INTO `products_to_categories` VALUES (68, 36);
INSERT INTO `products_to_categories` VALUES (69, 36);
INSERT INTO `products_to_categories` VALUES (70, 36);
INSERT INTO `products_to_categories` VALUES (71, 36);
INSERT INTO `products_to_categories` VALUES (72, 36);
INSERT INTO `products_to_categories` VALUES (73, 36);
INSERT INTO `products_to_categories` VALUES (74, 36);
INSERT INTO `products_to_categories` VALUES (75, 36);
INSERT INTO `products_to_categories` VALUES (76, 36);
INSERT INTO `products_to_categories` VALUES (77, 37);
INSERT INTO `products_to_categories` VALUES (78, 37);
INSERT INTO `products_to_categories` VALUES (79, 37);
INSERT INTO `products_to_categories` VALUES (80, 37);
INSERT INTO `products_to_categories` VALUES (81, 37);
INSERT INTO `products_to_categories` VALUES (82, 37);
INSERT INTO `products_to_categories` VALUES (83, 37);
INSERT INTO `products_to_categories` VALUES (84, 37);
INSERT INTO `products_to_categories` VALUES (85, 38);
INSERT INTO `products_to_categories` VALUES (86, 38);
INSERT INTO `products_to_categories` VALUES (87, 38);
INSERT INTO `products_to_categories` VALUES (88, 31);
INSERT INTO `products_to_categories` VALUES (89, 31);
INSERT INTO `products_to_categories` VALUES (90, 31);
INSERT INTO `products_to_categories` VALUES (91, 31);
INSERT INTO `products_to_categories` VALUES (92, 31);
INSERT INTO `products_to_categories` VALUES (93, 31);
INSERT INTO `products_to_categories` VALUES (94, 31);
INSERT INTO `products_to_categories` VALUES (95, 31);
INSERT INTO `products_to_categories` VALUES (96, 31);
INSERT INTO `products_to_categories` VALUES (97, 31);
INSERT INTO `products_to_categories` VALUES (98, 31);
INSERT INTO `products_to_categories` VALUES (99, 31);
INSERT INTO `products_to_categories` VALUES (100, 31);
INSERT INTO `products_to_categories` VALUES (101, 31);
INSERT INTO `products_to_categories` VALUES (102, 31);
INSERT INTO `products_to_categories` VALUES (103, 31);
INSERT INTO `products_to_categories` VALUES (104, 31);
INSERT INTO `products_to_categories` VALUES (105, 31);
INSERT INTO `products_to_categories` VALUES (106, 31);
INSERT INTO `products_to_categories` VALUES (107, 31);
INSERT INTO `products_to_categories` VALUES (108, 31);
INSERT INTO `products_to_categories` VALUES (109, 31);
INSERT INTO `products_to_categories` VALUES (110, 39);
INSERT INTO `products_to_categories` VALUES (111, 39);
INSERT INTO `products_to_categories` VALUES (112, 39);
INSERT INTO `products_to_categories` VALUES (113, 39);
INSERT INTO `products_to_categories` VALUES (114, 39);
INSERT INTO `products_to_categories` VALUES (115, 39);
INSERT INTO `products_to_categories` VALUES (116, 39);
INSERT INTO `products_to_categories` VALUES (117, 40);
INSERT INTO `products_to_categories` VALUES (118, 40);
INSERT INTO `products_to_categories` VALUES (119, 41);
INSERT INTO `products_to_categories` VALUES (120, 41);
INSERT INTO `products_to_categories` VALUES (121, 41);
INSERT INTO `products_to_categories` VALUES (122, 41);
INSERT INTO `products_to_categories` VALUES (123, 41);
INSERT INTO `products_to_categories` VALUES (124, 41);
INSERT INTO `products_to_categories` VALUES (125, 41);
INSERT INTO `products_to_categories` VALUES (126, 41);
INSERT INTO `products_to_categories` VALUES (127, 42);
INSERT INTO `products_to_categories` VALUES (128, 31);

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

#
# Table structure for table `reviews`
#

CREATE TABLE `reviews` (
  `reviews_id` int(11) NOT NULL auto_increment,
  `products_id` int(11) NOT NULL default '0',
  `customers_id` int(11) default NULL,
  `customers_name` varchar(64) NOT NULL default '',
  `reviews_rating` int(1) default NULL,
  `date_added` datetime default NULL,
  `last_modified` datetime default NULL,
  `reviews_read` int(5) NOT NULL default '0',
  PRIMARY KEY  (`reviews_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

#
# Dumping data for table `reviews`
#

INSERT INTO `reviews` VALUES (12, 64, 25, 'Louise Phillips', 5, '2005-04-18 20:41:13', NULL, 8);

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

#
# Table structure for table `reviews_description`
#

CREATE TABLE `reviews_description` (
  `reviews_id` int(11) NOT NULL default '0',
  `languages_id` int(11) NOT NULL default '0',
  `reviews_text` text NOT NULL,
  PRIMARY KEY  (`reviews_id`,`languages_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table `reviews_description`
#

INSERT INTO `reviews_description` VALUES (12, 1, 'Rating: When I say good I mean Fabulous!\r\n\r\nAnother brilliant product from Marsha\'s!!\r\n\r\nBought one last year along with a whole load of french country bedroom furniture - in fact we just popped into Marsha\'s Home and said we would have the whole room just as it was on display:-)\r\n\r\nSince then, friends and family have all commented on how gorgeous the newly decorated bedroom actually looks, although the star attraction is most definitely the unusual Giant Shell Lampshade, which has been hung really close to the ceiling for maximum effect (as advised by Marsha\'s).\r\n\r\nI\'ve decided to order another 2 for our other bedrooms, after they have been decorated and no doubt Ill be also looking for more furniture - Marsha you had better watch out!!!');

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

#
# Table structure for table `sessions`
#

CREATE TABLE `sessions` (
  `sesskey` varchar(32) NOT NULL default '',
  `expiry` int(11) unsigned NOT NULL default '0',
  `value` text NOT NULL,
  PRIMARY KEY  (`sesskey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table `sessions`
#

INSERT INTO `sessions` VALUES ('afcf66f71fcfe1607fef83c57f10c8a3', 1136988649, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:2:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"22_27";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('4611f027403033cece6cd20a7b215976', 1137011476, 'language|s:7:"english";languages_id|s:1:"1";selected_box|s:5:"tools";');
INSERT INTO `sessions` VALUES ('9de0a19b0db9d521cd4e0ca6906b0a64', 1136978281, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('277ce1e517b7984a79495715dacfea35', 1136979767, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:2:{s:5:"cPath";s:2:"22";s:6:"osCsid";s:32:"277ce1e517b7984a79495715dacfea35";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"22_34";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('42d4b8f2b3d714afb519f77ff1516f98', 1136977308, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:2:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"35";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('6485f1dea93606d9b4a67af38a01c752', 1136983800, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:11:"privacy.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:6:"osCsid";s:32:"6485f1dea93606d9b4a67af38a01c752";}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:26:"advanced_search_result.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:4:{s:6:"osCsid";s:32:"6485f1dea93606d9b4a67af38a01c752";s:8:"keywords";s:8:"wardrobe";s:1:"x";s:1:"4";s:1:"y";s:1:"4";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:19:"advanced_search.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:2:{s:8:"keywords";s:8:"wardrobe";s:6:"osCsid";s:32:"6485f1dea93606d9b4a67af38a01c752";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('960e644e9bcbec53e1d9353e835662db', 1136946967, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('6c0d12b95357847496449a3138956cdd', 1136953075, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('fce1bca17e9396f94f32097a7f37214d', 1136928877, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('320503747092f58e474f2a24aab7d2af', 1136923808, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('72545b165d9cb00f7e64697eb233dab5', 1136923928, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:4:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:2:{s:5:"cPath";s:2:"24";s:6:"osCsid";s:32:"72545b165d9cb00f7e64697eb233dab5";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"24_30";}s:4:"post";a:0:{}}i:3;a:4:{s:4:"page";s:26:"advanced_search_result.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:3:{s:8:"keywords";s:5:"plank";s:1:"x";s:1:"0";s:1:"y";s:1:"0";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('8d2a9a25f6d823e3f61d32805aef611d', 1136923761, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:2:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"35";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('1f6d521f07abaa93e09e4704803e717f', 1136914625, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"24";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"24_30";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('455571e666914d8abdcce2a2e08edd22', 1136915864, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('a8a7a7045bc46cb34723f30b4f494140', 1136913113, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('8c15f17441ba84a9339702ed41e58902', 1136909822, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:2:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"35";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('4a22633ceb5ce7818a4ecf8d62b0dec6', 1136912213, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('7d8491c0c7b049d409622126204427ee', 1136906806, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"25";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"25_36";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('7290a15a90f041e6f9026317af9acaba', 1136906822, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:6:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"25";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"25_32";}s:4:"post";a:0:{}}i:3;a:4:{s:4:"page";s:16:"product_info.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:2:{s:5:"cPath";s:5:"25_32";s:11:"products_id";s:2:"64";}s:4:"post";a:0:{}}i:4;a:4:{s:4:"page";s:26:"advanced_search_result.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:3:{s:8:"keywords";s:7:"bedding";s:1:"x";s:2:"10";s:1:"y";s:1:"2";}s:4:"post";a:0:{}}i:5;a:4:{s:4:"page";s:19:"advanced_search.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:8:"keywords";s:7:"bedding";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('2dc19e2f4e54df236f995c6fec59dae1', 1136904291, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('c540f9839df083e63578b05042c257b5', 1136903146, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"25";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"25_41";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('e954f5f9715617232ce61f7acc02c8b8', 1136901467, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('6b4bb05d5dbbf154009f2a79fad58b4c', 1136906513, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"25_31";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:16:"product_info.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:2:{s:5:"cPath";s:5:"25_32";s:11:"products_id";s:2:"63";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('90b8ef50d0eef5cee760d4296b7c6ea6', 1136900258, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:16:"product_info.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:3:{s:5:"cPath";s:2:"35";s:11:"products_id";s:2:"65";s:6:"osCsid";s:32:"90b8ef50d0eef5cee760d4296b7c6ea6";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('259fc2f9e445579b71e6c72ec69e6b3d', 1136899505, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"25";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"25_41";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('c8ba61c74d62d6db71af47103bbb0614', 1136897866, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:4:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"25";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"25_41";}s:4:"post";a:0:{}}i:3;a:4:{s:4:"page";s:16:"product_info.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:2:{s:5:"cPath";s:5:"25_41";s:11:"products_id";s:3:"121";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('f08b84085dbe0864287dac4ee2f41c93', 1136889004, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:2:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"35";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('2cf25faeabd769049f3085eba7618afa', 1136892599, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"25";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"25_36";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('3e040c54c2945a4facb7a9de38de2338', 1136848309, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('2bd4e572ac6b6450f49887af85ecfc5a', 1136843671, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:5:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:26:"advanced_search_result.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:4:{s:6:"osCsid";s:32:"2bd4e572ac6b6450f49887af85ecfc5a";s:8:"keywords";s:7:"mirrors";s:1:"x";s:2:"11";s:1:"y";s:2:"12";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"25";}s:4:"post";a:0:{}}i:3;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"25_31";}s:4:"post";a:0:{}}i:4;a:4:{s:4:"page";s:16:"product_info.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:2:{s:5:"cPath";s:5:"25_31";s:11:"products_id";s:3:"107";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('87401a494d6cbe093c2800c4c112b2db', 1136842891, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"25";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"25_31";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('8bfeb10dd2e89eb334b2e0076530cb07', 1136839241, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"25";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"25_39";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('ca729f63b1ab83fd16530daa6b022aa7', 1136840289, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:2:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"25";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('3b931f627cce87e5d0e95ef4dce6ab80', 1136838826, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:2:{s:5:"cPath";s:2:"22";s:6:"osCsid";s:32:"3b931f627cce87e5d0e95ef4dce6ab80";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"22_26";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('092811ee3ea6f397609d9760b8ce5d15', 1136836599, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('54ef51a53a187c1acc35d096d4accd9b', 1136768314, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"25";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"25_36";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('3eacab2d3d49f5ef458bf5dee2b17da8', 1136757055, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:0:{}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('e179ba6ac7c74eae99e98297fb930e58', 1136754796, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"25";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"25_42";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('1323bb66927eefa2dd6640d9890b590d', 1136757095, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:2:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"25";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('bd1ebe5f55cf8ae6d3d4b1e44f836cea', 1136753736, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:2:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"35";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('a8b5ea5d0f87d9424eaa68c1f2148d47', 1136834323, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"25";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"25_32";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('9a954768d24bd1fabcffbeb2987b0170', 1136832658, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('a95ace65ef9725f06ac57c66a1ec6d89', 1136900138, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:25:"account_notifications.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:6:"osCsid";s:32:"a95ace65ef9725f06ac57c66a1ec6d89";}s:4:"post";a:0:{}}}s:8:"snapshot";a:4:{s:4:"page";s:25:"account_notifications.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:6:"osCsid";s:32:"a95ace65ef9725f06ac57c66a1ec6d89";}s:4:"post";a:0:{}}}');
INSERT INTO `sessions` VALUES ('78f2a81b2b97bebfdf29a43243846633', 1136753464, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:2:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:26:"advanced_search_result.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:8:"keywords";s:6:"soffas";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('17b4ddf1eb3c82c7f7e7f0e730521d5e', 1136946086, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:17:"shopping_cart.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:6:"osCsid";s:32:"17b4ddf1eb3c82c7f7e7f0e730521d5e";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('dbff639cf1f0000b92c3f6f13af5a449', 1136827928, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:2:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"24";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('d8c34fcfa3647114e72d05e1f0da21ac', 1136831222, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('1dacc06bb3d724c6fd097cca43506a70', 1136807003, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"24";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"24_30";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('2b086ab5196467b579c5cf9659f08ee9', 1136810703, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"24";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"24_30";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('fe3dddad180214f0af26717425e223e5', 1136806924, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:5:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:11:"account.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:17:"shopping_cart.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:3;a:4:{s:4:"page";s:21:"checkout_shipping.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:4;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"24";}s:4:"post";a:0:{}}}s:8:"snapshot";a:4:{s:4:"page";s:21:"checkout_shipping.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}');
INSERT INTO `sessions` VALUES ('6acfdcca88b4e865e946bed9c6c6f34d', 1136810854, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:2:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:19:"advanced_search.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:6:"osCsid";s:32:"6acfdcca88b4e865e946bed9c6c6f34d";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('daba9d0b0bfba2401e467255da55cb2c', 1136811114, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('59d18b2c119180c2a036a51ffddf15b0', 1136811959, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('e74eb16be1ce8fe6df26db208e6c1c98', 1136814274, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('6491062274311963873eb331c2545533', 1136816583, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:4:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:2:{s:5:"cPath";s:2:"22";s:6:"osCsid";s:32:"6491062274311963873eb331c2545533";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"22_34";}s:4:"post";a:0:{}}i:3;a:4:{s:4:"page";s:16:"product_info.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:2:{s:5:"cPath";s:5:"22_34";s:11:"products_id";s:2:"65";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('5c681e3d8d5cb569512ff7f97449b0c3', 1136820327, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:2:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"25";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('a6c18182436ae68cafd6af09a674af6d', 1136824155, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('598543dd38236345972d067bc2212843', 1136826527, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:4:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:2:{s:5:"cPath";s:2:"22";s:6:"osCsid";s:32:"598543dd38236345972d067bc2212843";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:5:"22_27";}s:4:"post";a:0:{}}i:3;a:4:{s:4:"page";s:26:"advanced_search_result.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:8:"keywords";s:14:"krystal chairs";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('b7ce5a4e97d497a2f6b69b8036d3d270', 1136827480, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:26:"advanced_search_result.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:8:"keywords";s:8:"barstool";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"22";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('2e84a63c5d9e22ab4ea39beba8a95c5d', 1136795206, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:5:"cPath";s:2:"35";}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:16:"product_info.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:2:{s:5:"cPath";s:2:"35";s:11:"products_id";s:2:"65";}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');
INSERT INTO `sessions` VALUES ('39972db6e4674fcc4b5f573f9ff79d7d', 1136790831, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"GBP";navigation|O:17:"navigationhistory":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}s:8:"snapshot";a:0:{}}');

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

#
# Table structure for table `specials`
#

CREATE TABLE `specials` (
  `specials_id` int(11) NOT NULL auto_increment,
  `products_id` int(11) NOT NULL default '0',
  `specials_new_products_price` decimal(15,4) NOT NULL default '0.0000',
  `specials_date_added` datetime default NULL,
  `specials_last_modified` datetime default NULL,
  `expires_date` datetime default NULL,
  `date_status_change` datetime default NULL,
  `status` int(1) NOT NULL default '1',
  PRIMARY KEY  (`specials_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

#
# Dumping data for table `specials`
#


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

#
# Table structure for table `tax_class`
#

CREATE TABLE `tax_class` (
  `tax_class_id` int(11) NOT NULL auto_increment,
  `tax_class_title` varchar(32) NOT NULL default '',
  `tax_class_description` varchar(255) NOT NULL default '',
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`tax_class_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `tax_class`
#

INSERT INTO `tax_class` VALUES (1, 'Taxable Goods', 'The following types of products are included non-food, services, etc', '2005-01-20 09:26:37', '2005-01-20 09:26:37');

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

#
# Table structure for table `tax_rates`
#

CREATE TABLE `tax_rates` (
  `tax_rates_id` int(11) NOT NULL auto_increment,
  `tax_zone_id` int(11) NOT NULL default '0',
  `tax_class_id` int(11) NOT NULL default '0',
  `tax_priority` int(5) default '1',
  `tax_rate` decimal(7,4) NOT NULL default '0.0000',
  `tax_description` varchar(255) NOT NULL default '',
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`tax_rates_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `tax_rates`
#

INSERT INTO `tax_rates` VALUES (1, 1, 1, 1, '17.5000', 'VAT 17.5%', '2005-02-16 17:33:36', '2005-01-20 09:26:37');

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

#
# Table structure for table `whos_online`
#

CREATE TABLE `whos_online` (
  `customer_id` int(11) default NULL,
  `full_name` varchar(64) NOT NULL default '',
  `session_id` varchar(128) NOT NULL default '',
  `ip_address` varchar(15) NOT NULL default '',
  `time_entry` varchar(14) NOT NULL default '',
  `time_last_click` varchar(14) NOT NULL default '',
  `last_page_url` varchar(64) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table `whos_online`
#


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

#
# Table structure for table `zones`
#

CREATE TABLE `zones` (
  `zone_id` int(11) NOT NULL auto_increment,
  `zone_country_id` int(11) NOT NULL default '0',
  `zone_code` varchar(32) NOT NULL default '',
  `zone_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`zone_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=182 ;

#
# Dumping data for table `zones`
#

INSERT INTO `zones` VALUES (1, 223, 'AL', 'Alabama');
INSERT INTO `zones` VALUES (2, 223, 'AK', 'Alaska');
INSERT INTO `zones` VALUES (3, 223, 'AS', 'American Samoa');
INSERT INTO `zones` VALUES (4, 223, 'AZ', 'Arizona');
INSERT INTO `zones` VALUES (5, 223, 'AR', 'Arkansas');
INSERT INTO `zones` VALUES (6, 223, 'AF', 'Armed Forces Africa');
INSERT INTO `zones` VALUES (7, 223, 'AA', 'Armed Forces Americas');
INSERT INTO `zones` VALUES (8, 223, 'AC', 'Armed Forces Canada');
INSERT INTO `zones` VALUES (9, 223, 'AE', 'Armed Forces Europe');
INSERT INTO `zones` VALUES (10, 223, 'AM', 'Armed Forces Middle East');
INSERT INTO `zones` VALUES (11, 223, 'AP', 'Armed Forces Pacific');
INSERT INTO `zones` VALUES (12, 223, 'CA', 'California');
INSERT INTO `zones` VALUES (13, 223, 'CO', 'Colorado');
INSERT INTO `zones` VALUES (14, 223, 'CT', 'Connecticut');
INSERT INTO `zones` VALUES (15, 223, 'DE', 'Delaware');
INSERT INTO `zones` VALUES (16, 223, 'DC', 'District of Columbia');
INSERT INTO `zones` VALUES (17, 223, 'FM', 'Federated States Of Micronesia');
INSERT INTO `zones` VALUES (18, 223, 'FL', 'Florida');
INSERT INTO `zones` VALUES (19, 223, 'GA', 'Georgia');
INSERT INTO `zones` VALUES (20, 223, 'GU', 'Guam');
INSERT INTO `zones` VALUES (21, 223, 'HI', 'Hawaii');
INSERT INTO `zones` VALUES (22, 223, 'ID', 'Idaho');
INSERT INTO `zones` VALUES (23, 223, 'IL', 'Illinois');
INSERT INTO `zones` VALUES (24, 223, 'IN', 'Indiana');
INSERT INTO `zones` VALUES (25, 223, 'IA', 'Iowa');
INSERT INTO `zones` VALUES (26, 223, 'KS', 'Kansas');
INSERT INTO `zones` VALUES (27, 223, 'KY', 'Kentucky');
INSERT INTO `zones` VALUES (28, 223, 'LA', 'Louisiana');
INSERT INTO `zones` VALUES (29, 223, 'ME', 'Maine');
INSERT INTO `zones` VALUES (30, 223, 'MH', 'Marshall Islands');
INSERT INTO `zones` VALUES (31, 223, 'MD', 'Maryland');
INSERT INTO `zones` VALUES (32, 223, 'MA', 'Massachusetts');
INSERT INTO `zones` VALUES (33, 223, 'MI', 'Michigan');
INSERT INTO `zones` VALUES (34, 223, 'MN', 'Minnesota');
INSERT INTO `zones` VALUES (35, 223, 'MS', 'Mississippi');
INSERT INTO `zones` VALUES (36, 223, 'MO', 'Missouri');
INSERT INTO `zones` VALUES (37, 223, 'MT', 'Montana');
INSERT INTO `zones` VALUES (38, 223, 'NE', 'Nebraska');
INSERT INTO `zones` VALUES (39, 223, 'NV', 'Nevada');
INSERT INTO `zones` VALUES (40, 223, 'NH', 'New Hampshire');
INSERT INTO `zones` VALUES (41, 223, 'NJ', 'New Jersey');
INSERT INTO `zones` VALUES (42, 223, 'NM', 'New Mexico');
INSERT INTO `zones` VALUES (43, 223, 'NY', 'New York');
INSERT INTO `zones` VALUES (44, 223, 'NC', 'North Carolina');
INSERT INTO `zones` VALUES (45, 223, 'ND', 'North Dakota');
INSERT INTO `zones` VALUES (46, 223, 'MP', 'Northern Mariana Islands');
INSERT INTO `zones` VALUES (47, 223, 'OH', 'Ohio');
INSERT INTO `zones` VALUES (48, 223, 'OK', 'Oklahoma');
INSERT INTO `zones` VALUES (49, 223, 'OR', 'Oregon');
INSERT INTO `zones` VALUES (50, 223, 'PW', 'Palau');
INSERT INTO `zones` VALUES (51, 223, 'PA', 'Pennsylvania');
INSERT INTO `zones` VALUES (52, 223, 'PR', 'Puerto Rico');
INSERT INTO `zones` VALUES (53, 223, 'RI', 'Rhode Island');
INSERT INTO `zones` VALUES (54, 223, 'SC', 'South Carolina');
INSERT INTO `zones` VALUES (55, 223, 'SD', 'South Dakota');
INSERT INTO `zones` VALUES (56, 223, 'TN', 'Tennessee');
INSERT INTO `zones` VALUES (57, 223, 'TX', 'Texas');
INSERT INTO `zones` VALUES (58, 223, 'UT', 'Utah');
INSERT INTO `zones` VALUES (59, 223, 'VT', 'Vermont');
INSERT INTO `zones` VALUES (60, 223, 'VI', 'Virgin Islands');
INSERT INTO `zones` VALUES (61, 223, 'VA', 'Virginia');
INSERT INTO `zones` VALUES (62, 223, 'WA', 'Washington');
INSERT INTO `zones` VALUES (63, 223, 'WV', 'West Virginia');
INSERT INTO `zones` VALUES (64, 223, 'WI', 'Wisconsin');
INSERT INTO `zones` VALUES (65, 223, 'WY', 'Wyoming');
INSERT INTO `zones` VALUES (66, 38, 'AB', 'Alberta');
INSERT INTO `zones` VALUES (67, 38, 'BC', 'British Columbia');
INSERT INTO `zones` VALUES (68, 38, 'MB', 'Manitoba');
INSERT INTO `zones` VALUES (69, 38, 'NF', 'Newfoundland');
INSERT INTO `zones` VALUES (70, 38, 'NB', 'New Brunswick');
INSERT INTO `zones` VALUES (71, 38, 'NS', 'Nova Scotia');
INSERT INTO `zones` VALUES (72, 38, 'NT', 'Northwest Territories');
INSERT INTO `zones` VALUES (73, 38, 'NU', 'Nunavut');
INSERT INTO `zones` VALUES (74, 38, 'ON', 'Ontario');
INSERT INTO `zones` VALUES (75, 38, 'PE', 'Prince Edward Island');
INSERT INTO `zones` VALUES (76, 38, 'QC', 'Quebec');
INSERT INTO `zones` VALUES (77, 38, 'SK', 'Saskatchewan');
INSERT INTO `zones` VALUES (78, 38, 'YT', 'Yukon Territory');
INSERT INTO `zones` VALUES (79, 81, 'NDS', 'Niedersachsen');
INSERT INTO `zones` VALUES (80, 81, 'BAW', 'Baden-Württemberg');
INSERT INTO `zones` VALUES (81, 81, 'BAY', 'Bayern');
INSERT INTO `zones` VALUES (82, 81, 'BER', 'Berlin');
INSERT INTO `zones` VALUES (83, 81, 'BRG', 'Brandenburg');
INSERT INTO `zones` VALUES (84, 81, 'BRE', 'Bremen');
INSERT INTO `zones` VALUES (85, 81, 'HAM', 'Hamburg');
INSERT INTO `zones` VALUES (86, 81, 'HES', 'Hessen');
INSERT INTO `zones` VALUES (87, 81, 'MEC', 'Mecklenburg-Vorpommern');
INSERT INTO `zones` VALUES (88, 81, 'NRW', 'Nordrhein-Westfalen');
INSERT INTO `zones` VALUES (89, 81, 'RHE', 'Rheinland-Pfalz');
INSERT INTO `zones` VALUES (90, 81, 'SAR', 'Saarland');
INSERT INTO `zones` VALUES (91, 81, 'SAS', 'Sachsen');
INSERT INTO `zones` VALUES (92, 81, 'SAC', 'Sachsen-Anhalt');
INSERT INTO `zones` VALUES (93, 81, 'SCN', 'Schleswig-Holstein');
INSERT INTO `zones` VALUES (94, 81, 'THE', 'Thüringen');
INSERT INTO `zones` VALUES (95, 14, 'WI', 'Wien');
INSERT INTO `zones` VALUES (96, 14, 'NO', 'Niederösterreich');
INSERT INTO `zones` VALUES (97, 14, 'OO', 'Oberösterreich');
INSERT INTO `zones` VALUES (98, 14, 'SB', 'Salzburg');
INSERT INTO `zones` VALUES (99, 14, 'KN', 'Kärnten');
INSERT INTO `zones` VALUES (100, 14, 'ST', 'Steiermark');
INSERT INTO `zones` VALUES (101, 14, 'TI', 'Tirol');
INSERT INTO `zones` VALUES (102, 14, 'BL', 'Burgenland');
INSERT INTO `zones` VALUES (103, 14, 'VB', 'Voralberg');
INSERT INTO `zones` VALUES (104, 204, 'AG', 'Aargau');
INSERT INTO `zones` VALUES (105, 204, 'AI', 'Appenzell Innerrhoden');
INSERT INTO `zones` VALUES (106, 204, 'AR', 'Appenzell Ausserrhoden');
INSERT INTO `zones` VALUES (107, 204, 'BE', 'Bern');
INSERT INTO `zones` VALUES (108, 204, 'BL', 'Basel-Landschaft');
INSERT INTO `zones` VALUES (109, 204, 'BS', 'Basel-Stadt');
INSERT INTO `zones` VALUES (110, 204, 'FR', 'Freiburg');
INSERT INTO `zones` VALUES (111, 204, 'GE', 'Genf');
INSERT INTO `zones` VALUES (112, 204, 'GL', 'Glarus');
INSERT INTO `zones` VALUES (113, 204, 'JU', 'Graubünden');
INSERT INTO `zones` VALUES (114, 204, 'JU', 'Jura');
INSERT INTO `zones` VALUES (115, 204, 'LU', 'Luzern');
INSERT INTO `zones` VALUES (116, 204, 'NE', 'Neuenburg');
INSERT INTO `zones` VALUES (117, 204, 'NW', 'Nidwalden');
INSERT INTO `zones` VALUES (118, 204, 'OW', 'Obwalden');
INSERT INTO `zones` VALUES (119, 204, 'SG', 'St. Gallen');
INSERT INTO `zones` VALUES (120, 204, 'SH', 'Schaffhausen');
INSERT INTO `zones` VALUES (121, 204, 'SO', 'Solothurn');
INSERT INTO `zones` VALUES (122, 204, 'SZ', 'Schwyz');
INSERT INTO `zones` VALUES (123, 204, 'TG', 'Thurgau');
INSERT INTO `zones` VALUES (124, 204, 'TI', 'Tessin');
INSERT INTO `zones` VALUES (125, 204, 'UR', 'Uri');
INSERT INTO `zones` VALUES (126, 204, 'VD', 'Waadt');
INSERT INTO `zones` VALUES (127, 204, 'VS', 'Wallis');
INSERT INTO `zones` VALUES (128, 204, 'ZG', 'Zug');
INSERT INTO `zones` VALUES (129, 204, 'ZH', 'Zürich');
INSERT INTO `zones` VALUES (130, 195, 'A Coruña', 'A Coruña');
INSERT INTO `zones` VALUES (131, 195, 'Alava', 'Alava');
INSERT INTO `zones` VALUES (132, 195, 'Albacete', 'Albacete');
INSERT INTO `zones` VALUES (133, 195, 'Alicante', 'Alicante');
INSERT INTO `zones` VALUES (134, 195, 'Almeria', 'Almeria');
INSERT INTO `zones` VALUES (135, 195, 'Asturias', 'Asturias');
INSERT INTO `zones` VALUES (136, 195, 'Avila', 'Avila');
INSERT INTO `zones` VALUES (137, 195, 'Badajoz', 'Badajoz');
INSERT INTO `zones` VALUES (138, 195, 'Baleares', 'Baleares');
INSERT INTO `zones` VALUES (139, 195, 'Barcelona', 'Barcelona');
INSERT INTO `zones` VALUES (140, 195, 'Burgos', 'Burgos');
INSERT INTO `zones` VALUES (141, 195, 'Caceres', 'Caceres');
INSERT INTO `zones` VALUES (142, 195, 'Cadiz', 'Cadiz');
INSERT INTO `zones` VALUES (143, 195, 'Cantabria', 'Cantabria');
INSERT INTO `zones` VALUES (144, 195, 'Castellon', 'Castellon');
INSERT INTO `zones` VALUES (145, 195, 'Ceuta', 'Ceuta');
INSERT INTO `zones` VALUES (146, 195, 'Ciudad Real', 'Ciudad Real');
INSERT INTO `zones` VALUES (147, 195, 'Cordoba', 'Cordoba');
INSERT INTO `zones` VALUES (148, 195, 'Cuenca', 'Cuenca');
INSERT INTO `zones` VALUES (149, 195, 'Girona', 'Girona');
INSERT INTO `zones` VALUES (150, 195, 'Granada', 'Granada');
INSERT INTO `zones` VALUES (151, 195, 'Guadalajara', 'Guadalajara');
INSERT INTO `zones` VALUES (152, 195, 'Guipuzcoa', 'Guipuzcoa');
INSERT INTO `zones` VALUES (153, 195, 'Huelva', 'Huelva');
INSERT INTO `zones` VALUES (154, 195, 'Huesca', 'Huesca');
INSERT INTO `zones` VALUES (155, 195, 'Jaen', 'Jaen');
INSERT INTO `zones` VALUES (156, 195, 'La Rioja', 'La Rioja');
INSERT INTO `zones` VALUES (157, 195, 'Las Palmas', 'Las Palmas');
INSERT INTO `zones` VALUES (158, 195, 'Leon', 'Leon');
INSERT INTO `zones` VALUES (159, 195, 'Lleida', 'Lleida');
INSERT INTO `zones` VALUES (160, 195, 'Lugo', 'Lugo');
INSERT INTO `zones` VALUES (161, 195, 'Madrid', 'Madrid');
INSERT INTO `zones` VALUES (162, 195, 'Malaga', 'Malaga');
INSERT INTO `zones` VALUES (163, 195, 'Melilla', 'Melilla');
INSERT INTO `zones` VALUES (164, 195, 'Murcia', 'Murcia');
INSERT INTO `zones` VALUES (165, 195, 'Navarra', 'Navarra');
INSERT INTO `zones` VALUES (166, 195, 'Ourense', 'Ourense');
INSERT INTO `zones` VALUES (167, 195, 'Palencia', 'Palencia');
INSERT INTO `zones` VALUES (168, 195, 'Pontevedra', 'Pontevedra');
INSERT INTO `zones` VALUES (169, 195, 'Salamanca', 'Salamanca');
INSERT INTO `zones` VALUES (170, 195, 'Santa Cruz de Tenerife', 'Santa Cruz de Tenerife');
INSERT INTO `zones` VALUES (171, 195, 'Segovia', 'Segovia');
INSERT INTO `zones` VALUES (172, 195, 'Sevilla', 'Sevilla');
INSERT INTO `zones` VALUES (173, 195, 'Soria', 'Soria');
INSERT INTO `zones` VALUES (174, 195, 'Tarragona', 'Tarragona');
INSERT INTO `zones` VALUES (175, 195, 'Teruel', 'Teruel');
INSERT INTO `zones` VALUES (176, 195, 'Toledo', 'Toledo');
INSERT INTO `zones` VALUES (177, 195, 'Valencia', 'Valencia');
INSERT INTO `zones` VALUES (178, 195, 'Valladolid', 'Valladolid');
INSERT INTO `zones` VALUES (179, 195, 'Vizcaya', 'Vizcaya');
INSERT INTO `zones` VALUES (180, 195, 'Zamora', 'Zamora');
INSERT INTO `zones` VALUES (181, 195, 'Zaragoza', 'Zaragoza');

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

#
# Table structure for table `zones_to_geo_zones`
#

CREATE TABLE `zones_to_geo_zones` (
  `association_id` int(11) NOT NULL auto_increment,
  `zone_country_id` int(11) NOT NULL default '0',
  `zone_id` int(11) default NULL,
  `geo_zone_id` int(11) default NULL,
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`association_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

#
# Dumping data for table `zones_to_geo_zones`
#

INSERT INTO `zones_to_geo_zones` VALUES (1, 222, NULL, 1, '2005-01-20 11:04:36', '2005-01-20 09:26:37');
