DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(11) NOT NULL auto_increment,
`admin` varchar(40) NOT NULL default '',
`motdepasse` varchar(40) NOT NULL default '',
`banqueNom` varchar(200) NOT NULL default '',
`banqueAdresse` varchar(200) NOT NULL default '',
`banqueNumeroCompte` varchar(200) NOT NULL default '',
`banqueTitulaireCompte` varchar(200) NOT NULL default '',
`banqueCodeSwift` varchar(200) NOT NULL default '',
`text_home_1` longtext NOT NULL,
`text_home_2` longtext NOT NULL,
`text_home_3` longtext NOT NULL,
`text_categories_1` longtext NOT NULL,
`text_categories_2` longtext NOT NULL,
`text_categories_3` longtext NOT NULL,
`text_list_1` longtext NOT NULL,
`text_list_2` longtext NOT NULL,
`text_list_3` longtext NOT NULL,
`interface` varchar(40) NOT NULL default '',
`my_css` longtext NOT NULL,
`search_engine` longtext NOT NULL,
`free_shipping_zone` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
INSERT INTO `admin` values ('1',
'admin',
'192c191a',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'perso',
'',
'',
'||||||');
DROP TABLE IF EXISTS `banner`;
CREATE TABLE `banner` (
`banner_id` int(11) NOT NULL auto_increment,
`banner_desc` text NOT NULL,
`banner_image` text NOT NULL,
`banner_url` text NOT NULL,
`banner_date_added` datetime default NULL,
`banner_date_end` datetime NOT NULL default '0000-00-00 00:00:00',
`banner_vue` int(11) NOT NULL default '0',
`banner_hit` int(11) NOT NULL default '0',
`banner_visible` enum('yes','no') NOT NULL default 'yes',
PRIMARY KEY (`banner_id`)
) TYPE=MyISAM;
INSERT INTO `banner` values ('5',
'Boutique ecom',
'im/banner/banner1.gif',
'http://www.agua-amarga.com/ecom/fr',
'2003-11-21 19:16:17',
'2004-11-30 00:00:00',
'7274',
'15',
'yes');
INSERT INTO `banner` values ('6',
'Agua Amarga location',
'im/banner/banner2.gif',
'http://www.agua-amarga.com',
'2003-11-21 19:17:11',
'2004-10-02 00:00:00',
'4884',
'6',
'yes');
INSERT INTO `banner` values ('7',
'pub',
'im/banner/banner3.gif',
'http://www4.click-fr.com/clickj.cgi?a=10411-4756504&b',
'2003-11-21 19:17:59',
'2006-10-30 00:00:00',
'7003',
'1',
'yes');
INSERT INTO `banner` values ('18',
'essai',
'im/banner/bandeau_logo.gif',
'',
'2004-12-21 16:34:03',
'2003-01-01 00:00:00',
'240',
'0',
'yes');
INSERT INTO `banner` values ('19',
'tanga.fr',
'im/banner/banner3.gif',
'http://www.tanga.fr/affiliation/liens/6.php?aff=33',
'2004-12-24 17:50:31',
'2010-01-01 00:00:00',
'109',
'0',
'yes');
DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories` (
`tree` varchar(50) NOT NULL default 'tree',
`parent_id` varchar(30) default NULL,
`categories_id` varchar(30) NOT NULL default '0',
`categories_noeud` char(1) NOT NULL default '',
`categories_name_1` varchar(255) NOT NULL default '',
`categories_name_2` varchar(255) NOT NULL default '',
`categories_name_3` varchar(255) NOT NULL default '',
`categories_comment_1` varchar(255) NOT NULL default '',
`categories_comment_2` varchar(255) NOT NULL default '',
`categories_comment_3` varchar(255) NOT NULL default '',
`categories_image` varchar(100) NOT NULL default '',
`categories_visible` enum('yes','no') NOT NULL default 'yes',
PRIMARY KEY (`categories_id`),
UNIQUE KEY `categories_id` (`categories_id`)
) TYPE=MyISAM;
INSERT INTO `categories` values ('tree',
'24',
'30',
'L',
'déco-enfants',
'',
'',
'',
'',
'',
'im/zzz.gif',
'yes');
INSERT INTO `categories` values ('tree',
'24',
'31',
'L',
'bougeoirs',
'',
'',
'',
'',
'',
'im/zzz.gif',
'yes');
INSERT INTO `categories` values ('tree',
'0',
'32',
'B',
'Tradition',
'',
'',
'',
'',
'',
'im/zzz.gif',
'yes');
INSERT INTO `categories` values ('tree',
'24',
'26',
'L',
'boites',
'',
'',
'',
'',
'',
'im/zzz.gif',
'yes');
INSERT INTO `categories` values ('tree',
'24',
'27',
'L',
'coffrets',
'',
'',
'',
'',
'',
'im/zzz.gif',
'yes');
INSERT INTO `categories` values ('tree',
'24',
'28',
'L',
'Accessoires',
'',
'',
'',
'',
'',
'im/zzz.gif',
'yes');
INSERT INTO `categories` values ('tree',
'0',
'24',
'B',
'Artisanat',
'',
'',
'',
'',
'',
'im/zzz.gif',
'yes');
INSERT INTO `categories` values ('tree',
'24',
'25',
'L',
'Jeux en bois massif',
'',
'',
'',
'',
'',
'im/zzz.gif',
'yes');
INSERT INTO `categories` values ('tree',
'',
'0',
'R',
'Menu',
'Menu',
'Menu',
'Commentaires',
'Comments',
'Comentarios',
'im/f90.gif',
'yes');
INSERT INTO `categories` values ('tree',
'24',
'29',
'L',
'Figurines',
'',
'',
'',
'',
'',
'im/zzz.gif',
'yes');
INSERT INTO `categories` values ('tree',
'32',
'33',
'L',
'Argenterie des bauges',
'',
'',
'',
'',
'',
'im/zzz.gif',
'yes');
DROP TABLE IF EXISTS `code_promo`;
CREATE TABLE `code_promo` (
`code_promo_id` int(11) NOT NULL auto_increment,
`code_promo` varchar(11) NOT NULL default '',
`code_promo_start` date NOT NULL default '0000-00-00',
`code_promo_end` date NOT NULL default '0000-00-00',
`code_promo_reduction` int(11) NOT NULL default '0',
`code_promo_type` char(1) NOT NULL default '',
`code_promo_seuil` decimal(7,2) NOT NULL default '0.00',
`code_promo_stat` enum('public','prive') NOT NULL default 'public',
`code_promo_enter` int(11) NOT NULL default '0',
PRIMARY KEY (`code_promo_id`)
) TYPE=MyISAM;
INSERT INTO `code_promo` values ('1',
'titi',
'2003-11-12',
'2005-01-01',
'6',
'€',
'110.00',
'public',
'1');
DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries` (
`countries_id` int(5) NOT NULL auto_increment,
`countries_name` varchar(100) NOT NULL default '',
`countries_shipping` enum('zone1','zone2','zone3','zone4','zone5','zone6','zone7','zone8','exclude') NOT NULL default 'zone1',
`countries_shipping_tax` decimal(7,2) NOT NULL default '0.00',
`countries_shipping_tax_active` enum('yes','no') NOT NULL default 'no',
`countries_product_tax` decimal(7,2) NOT NULL default '0.00',
`countries_product_tax_active` enum('yes','no') NOT NULL default 'no',
`country_state` enum('country','state') NOT NULL default 'country',
`state_of_country` varchar(100) NOT NULL default '',
`apply_tax` int(1) NOT NULL default '0',
PRIMARY KEY (`countries_id`),
KEY `IDX_COUNTRIES_NAME` (`countries_name`)
) TYPE=MyISAM;
INSERT INTO `countries` values ('1',
'Afghanistan',
'zone3',
'10.00',
'yes',
'12.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('2',
'Albania',
'zone2',
'0.00',
'no',
'10.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('3',
'Algeria',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('4',
'American Samoa',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('5',
'Andorra',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('6',
'Angola',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('7',
'Anguilla',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('8',
'Antarctica',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('9',
'Antigua and Barbuda',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('10',
'Argentina',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('11',
'Armenia',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('12',
'Aruba',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('13',
'Australia',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('14',
'Austria',
'zone1',
'19.60',
'yes',
'19.60',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('15',
'Azerbaijan',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('16',
'Bahamas',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('17',
'Bahrain',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('18',
'Bangladesh',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('19',
'Barbados',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('20',
'Belarus',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('21',
'Belgium',
'zone1',
'21.00',
'yes',
'21.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('22',
'Belize',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('23',
'Benin',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('24',
'Bermuda',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('25',
'Bhutan',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('26',
'Bolivia',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('27',
'Bosnia and Herzegowina',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('28',
'Botswana',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('29',
'Bouvet Island',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('30',
'Brazil',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('31',
'British Indian Ocean Territory',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('32',
'Brunei Darussalam',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('33',
'Bulgaria',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('34',
'Burkina Faso',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('35',
'Burundi',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('36',
'Cambodia',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('37',
'Cameroon',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('38',
'Canada',
'zone3',
'7.00',
'yes',
'7.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('39',
'Cape Verde',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('40',
'Cayman Islands',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('41',
'Central African Republic',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('42',
'Chad',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('43',
'Chile',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('44',
'China',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('45',
'Christmas Island',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('46',
'Cocos (Keeling) Islands',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('47',
'Colombia',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('48',
'Comoros',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('49',
'Congo',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('50',
'Cook Islands',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('51',
'Costa Rica',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('52',
'Cote D\'Ivoire',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('53',
'Croatia',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('54',
'Cuba',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('55',
'Cyprus',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('56',
'Czech Republic',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('57',
'Denmark',
'zone1',
'10.00',
'yes',
'10.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('58',
'Djibouti',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('59',
'Dominica',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('60',
'Dominican Republic',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('61',
'East Timor',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('62',
'Ecuador',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('63',
'Egypt',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('64',
'El Salvador',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('65',
'Equatorial Guinea',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('66',
'Eritrea',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('67',
'Estonia',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('68',
'Ethiopia',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('69',
'Falkland Islands (Malvinas)',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('70',
'Faroe Islands',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('71',
'Fiji',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('72',
'Finland',
'zone1',
'19.60',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('73',
'France',
'zone1',
'19.60',
'no',
'19.60',
'no',
'state',
'',
'0');
INSERT INTO `countries` values ('75',
'French Guiana',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('76',
'French Polynesia',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('77',
'French Southern Territories',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('78',
'Gabon',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('79',
'Gambia',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('80',
'Georgia',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('81',
'Germany',
'zone1',
'19.60',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('82',
'Ghana',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('83',
'Gibraltar',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('84',
'Greece',
'zone1',
'19.60',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('85',
'Greenland',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('86',
'Grenada',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('87',
'Guadeloupe',
'zone1',
'8.50',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('88',
'Guam',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('89',
'Guatemala',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('90',
'Guinea',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('91',
'Guinea-bissau',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('92',
'Guyana',
'zone1',
'8.50',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('93',
'Haiti',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('94',
'Heard and Mc Donald Islands',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('95',
'Honduras',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('96',
'Hong Kong',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('97',
'Hungary',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('98',
'Iceland',
'zone1',
'19.60',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('99',
'India',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('100',
'Indonesia',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('101',
'Iran (Islamic Republic of)',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('102',
'Iraq',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('103',
'Ireland',
'zone1',
'19.60',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('104',
'Israel',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('105',
'Italy',
'zone1',
'19.60',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('106',
'Jamaica',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('107',
'Japan',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('108',
'Jordan',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('109',
'Kazakhstan',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('110',
'Kenya',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('111',
'Kiribati',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('112',
'Korea, Democratic Republic of',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('113',
'Korea, Republic of',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('114',
'Kuwait',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('115',
'Kyrgyzstan',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('116',
'Lao People\'s Democratic Republic',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('117',
'Latvia',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('118',
'Lebanon',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('119',
'Lesotho',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('120',
'Liberia',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('121',
'Libyan Arab Jamahiriya',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('122',
'Liechtenstein',
'zone1',
'19.60',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('123',
'Lithuania',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('124',
'Luxembourg',
'zone1',
'19.60',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('125',
'Macau',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('126',
'Macedonia',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('127',
'Madagascar',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('128',
'Malawi',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('129',
'Malaysia',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('130',
'Maldives',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('131',
'Mali',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('132',
'Malta',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('133',
'Marshall Islands',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('134',
'Martinique',
'zone1',
'8.50',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('135',
'Mauritania',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('136',
'Mauritius',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('137',
'Mayotte',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('138',
'Mexico',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('139',
'Micronesia, Federated States of',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('140',
'Moldova, Republic of',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('141',
'Monaco',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('142',
'Mongolia',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('143',
'Montserrat',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('144',
'Morocco',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('145',
'Mozambique',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('146',
'Myanmar',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('147',
'Namibia',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('148',
'Nauru',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('149',
'Nepal',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('150',
'Netherlands',
'zone1',
'19.60',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('151',
'Netherlands Antilles',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('152',
'New Caledonia',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('153',
'New Zealand',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('154',
'Nicaragua',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('155',
'Niger',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('156',
'Nigeria',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('157',
'Niue',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('158',
'Norfolk Island',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('159',
'Northern Mariana Islands',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('160',
'Norway',
'zone1',
'19.60',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('161',
'Oman',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('162',
'Pakistan',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('163',
'Palau',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('164',
'Panama',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('165',
'Papua New Guinea',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('166',
'Paraguay',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('167',
'Peru',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('168',
'Philippines',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('169',
'Pitcairn',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('170',
'Poland',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('171',
'Portugal',
'zone1',
'19.60',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('172',
'Puerto Rico',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('173',
'Qatar',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('174',
'Reunion',
'zone1',
'8.50',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('175',
'Romania',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('176',
'Russian Federation',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('177',
'Rwanda',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('178',
'Saint Kitts and Nevis',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('179',
'Saint Lucia',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('180',
'Saint Vincent and the Grenadines',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('181',
'Samoa',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('182',
'San Marino',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('183',
'Sao Tome and Principe',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('184',
'Saudi Arabia',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('185',
'Senegal',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('186',
'Seychelles',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('187',
'Sierra Leone',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('188',
'Singapore',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('189',
'Slovakia (Slovak Republic)',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('190',
'Slovenia',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('191',
'Solomon Islands',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('192',
'Somalia',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('193',
'south Africa',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('194',
'South Georgia',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('195',
'Spain',
'zone1',
'19.60',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('196',
'Sri Lanka',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('197',
'St. Helena',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('198',
'St. Pierre and Miquelon',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('199',
'Sudan',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('200',
'Suriname',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('201',
'Svalbard and Jan Mayen Islands',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('202',
'Swaziland',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('203',
'Sweden',
'zone1',
'19.60',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('204',
'Switzerland',
'zone1',
'19.60',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('205',
'Syrian Arab Republic',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('206',
'Taiwan, Province of China',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('207',
'Tajikistan',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('208',
'Tanzania, United Republic of',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('209',
'Thailand',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('210',
'Togo',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('211',
'Tokelau',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('212',
'Tonga',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('213',
'Trinidad and Tobago',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('214',
'Tunisia',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('215',
'Turkey',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('216',
'Turkmenistan',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('217',
'Turks and Caicos Islands',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('218',
'Tuvalu',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('219',
'Uganda',
'zone2',
'5.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('220',
'Ukraine',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('221',
'United Arab Emirates',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('222',
'United Kingdom',
'zone1',
'19.60',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('223',
'United States',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('225',
'Uruguay',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('226',
'Uzbekistan',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('227',
'Vanuatu',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('228',
'Vatican City State (Holy See)',
'zone1',
'19.60',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('229',
'Venezuela',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('230',
'Viet Nam',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('231',
'Virgin Islands (British)',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('232',
'Virgin Islands (U.S.)',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('233',
'Wallis and Futuna Islands',
'exclude',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('234',
'Western Sahara',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('235',
'Yemen',
'zone3',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('236',
'Yugoslavia',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('237',
'Zaire',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('238',
'Zambia',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('239',
'Zimbabwe',
'zone2',
'0.00',
'no',
'0.00',
'no',
'country',
'',
'0');
INSERT INTO `countries` values ('240',
'Corsica',
'zone1',
'19.60',
'yes',
'0.00',
'yes',
'country',
'',
'0');
INSERT INTO `countries` values ('241',
'Alaska',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('242',
'Alabama',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('243',
'American Samoa',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('244',
'Arizona',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('245',
'Arkansas',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('246',
'California',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('247',
'Colorado',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('248',
'Connecticut',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('249',
'Delaware',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('250',
'District of Columbia',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('251',
'Florida',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('252',
'Georgia',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('253',
'Guam',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('254',
'Hawaii',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('255',
'Idaho',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('256',
'Illinois',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('257',
'Indiana',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('258',
'Iowa',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('259',
'Kansas',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('260',
'Kentucky',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('261',
'Louisiana',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('262',
'Maine',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('263',
'Marshall Islands',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('264',
'Maryland',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('265',
'Massachusetts',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('266',
'Michigan',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('267',
'Minnesota',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('268',
'Mississippi',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('269',
'Missouri',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('270',
'Montana',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('271',
'Nebraska',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('272',
'Nevada',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('273',
'New Hampshire',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('274',
'New Jersey',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('275',
'New Mexico',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('276',
'New York',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('277',
'North Carolina',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('278',
'North Dakota',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('279',
'Northern Mariana Islands',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('280',
'Ohio',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('281',
'Oklahoma',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('282',
'Oregon',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('283',
'Palau',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('284',
'Pennsylvania',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('285',
'Puerto Rico',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('286',
'Rhode Island',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('287',
'South Carolina',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('288',
'South Dakota',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('289',
'Tennessee',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('290',
'Texas',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('291',
'Utah',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('292',
'Vermont',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('293',
'Virgin Islands',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('294',
'Virginia',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('295',
'Washington',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('296',
'West Virginia',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('297',
'Wisconsin',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('298',
'Wyoming',
'zone7',
'0.00',
'no',
'0.00',
'no',
'state',
'United States',
'0');
INSERT INTO `countries` values ('299',
'Alberta',
'zone8',
'7.00',
'yes',
'0.00',
'yes',
'state',
'Canada',
'0');
INSERT INTO `countries` values ('300',
'British Columbia',
'zone8',
'7.00',
'yes',
'0.00',
'yes',
'state',
'Canada',
'0');
INSERT INTO `countries` values ('301',
'Manitoba',
'zone8',
'7.00',
'yes',
'0.00',
'yes',
'state',
'Canada',
'0');
INSERT INTO `countries` values ('302',
'New Brunswick',
'zone8',
'7.00',
'yes',
'0.00',
'yes',
'state',
'Canada',
'0');
INSERT INTO `countries` values ('303',
'Newfoundland and Labrador',
'zone8',
'7.00',
'yes',
'0.00',
'yes',
'state',
'Canada',
'0');
INSERT INTO `countries` values ('304',
'Northwest Territories',
'zone8',
'7.00',
'yes',
'0.00',
'yes',
'state',
'Canada',
'0');
INSERT INTO `countries` values ('305',
'Nova Scotia',
'zone8',
'7.00',
'yes',
'0.00',
'yes',
'state',
'Canada',
'0');
INSERT INTO `countries` values ('306',
'Nunavut',
'zone8',
'7.00',
'yes',
'0.00',
'yes',
'state',
'Canada',
'0');
INSERT INTO `countries` values ('307',
'Ontario',
'zone8',
'7.00',
'yes',
'0.00',
'yes',
'state',
'Canada',
'0');
INSERT INTO `countries` values ('308',
'Prince Edward Island',
'zone8',
'7.00',
'yes',
'0.00',
'yes',
'state',
'Canada',
'0');
INSERT INTO `countries` values ('309',
'Quebec',
'zone3',
'7.50',
'yes',
'7.50',
'yes',
'state',
'Canada',
'0');
INSERT INTO `countries` values ('310',
'Saskatchewan',
'zone8',
'7.00',
'yes',
'0.00',
'yes',
'state',
'Canada',
'0');
INSERT INTO `countries` values ('311',
'Yukon',
'zone8',
'7.00',
'yes',
'0.00',
'yes',
'state',
'Canada',
'0');
DROP TABLE IF EXISTS `fournisseurs`;
CREATE TABLE `fournisseurs` (
`fournisseurs_id` int(5) NOT NULL auto_increment,
`fournisseurs_ref` varchar(5) NOT NULL default '',
`fournisseurs_company` varchar(30) NOT NULL default '',
`fournisseurs_firstname` varchar(255) NOT NULL default '',
`fournisseurs_name` varchar(255) NOT NULL default '',
`fournisseurs_address` varchar(255) NOT NULL default '',
`fournisseurs_zip` varchar(15) NOT NULL default '',
`fournisseurs_city` varchar(255) NOT NULL default '',
`fournisseurs_pays` varchar(255) NOT NULL default '',
`fournisseurs_tel1` varchar(30) NOT NULL default '',
`fournisseurs_tel2` varchar(30) NOT NULL default '',
`fournisseurs_cel1` varchar(30) NOT NULL default '',
`fournisseurs_cel2` varchar(30) NOT NULL default '',
`fournisseurs_fax` varchar(30) NOT NULL default '',
`fournisseurs_email` varchar(255) NOT NULL default '',
`fournisseurs_link` varchar(255) NOT NULL default '',
`fournisseurs_divers` text NOT NULL,
PRIMARY KEY (`fournisseurs_id`)
) TYPE=MyISAM;
INSERT INTO `fournisseurs` values ('1',
'usrob',
'US Robotic Inc.',
'',
'',
'',
'',
'Atlanta',
'',
'123-234-234',
'123-234-235',
'',
'',
'',
'',
'',
'Modem');
INSERT INTO `fournisseurs` values ('2',
'rockw',
'Rockwell Int.',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'');
INSERT INTO `fournisseurs` values ('3',
'dell',
'DELL',
'moi',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'788-776-44',
'',
'',
'');
INSERT INTO `fournisseurs` values ('4',
'adob',
'Adobe.inc',
'Antonio',
'Manolo',
'Ferrocaril Minero s/n',
'04149',
'Agua Amarga',
'Espagne',
'123 123 123',
'123 1234441',
'3456 223 44',
'223 566 433',
'000-000-000',
'toto@adobe.net',
'',
's/o');
INSERT INTO `fournisseurs` values ('5',
'macro',
'Macromedia inc.',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'');
INSERT INTO `fournisseurs` values ('6',
'aegam',
'AE Games',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'');
INSERT INTO `fournisseurs` values ('7',
'ubi',
'Ubi Soft',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'');
INSERT INTO `fournisseurs` values ('8',
'micro',
'Microsoft',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'');
INSERT INTO `fournisseurs` values ('9',
'eidos',
'Eidos Interactive',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'');
INSERT INTO `fournisseurs` values ('10',
'sony',
'Sony',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'');
INSERT INTO `fournisseurs` values ('11',
'apple',
'Apple',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'');
INSERT INTO `fournisseurs` values ('12',
'tosh',
'Toshiba',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'');
INSERT INTO `fournisseurs` values ('13',
'sam',
'Samsung',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'');
INSERT INTO `fournisseurs` values ('14',
'luca',
'LucasArts',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'');
INSERT INTO `fournisseurs` values ('15',
'epson',
'Epson',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'');
INSERT INTO `fournisseurs` values ('16',
'hp',
'Hewlett Packard',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'http://www.hp.com',
'');
INSERT INTO `fournisseurs` values ('17',
'can',
'Canon',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'');
INSERT INTO `fournisseurs` values ('31',
'666',
'moa',
'cosette',
'',
'ccccc',
'66666',
'gdkedkyew',
'france',
'02345678',
'',
'',
'',
'',
'',
'',
'');
INSERT INTO `fournisseurs` values ('33',
'activ',
'ACTIVE WEAR',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'000-000-000',
'',
'',
'');
INSERT INTO `fournisseurs` values ('35',
'fubu',
'FUBU',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'000-000-000',
'',
'',
'Pantalons baggy');
INSERT INTO `fournisseurs` values ('37',
'chev',
'Chevignon',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'000-000-000',
'',
'',
'');
INSERT INTO `fournisseurs` values ('38',
'TIPST',
'TIPSTER',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'000-000-000',
'',
'',
'');
INSERT INTO `fournisseurs` values ('39',
'dick',
'DICKIES',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'000-000-000',
'',
'',
'');
INSERT INTO `fournisseurs` values ('40',
'lev',
'LEV\'IS®',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'000-000-000',
'',
'',
'');
INSERT INTO `fournisseurs` values ('41',
'nike',
'Nike',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'000-000-000',
'',
'',
'');
INSERT INTO `fournisseurs` values ('42',
'adida',
'Adidas',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'000-000-000',
'',
'',
'');
INSERT INTO `fournisseurs` values ('43',
'reeb',
'REEBOK',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'000-000-000',
'',
'',
'');
INSERT INTO `fournisseurs` values ('44',
'puma',
'Puma',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'000-000-000',
'',
'',
'');
INSERT INTO `fournisseurs` values ('45',
'man',
'ALAIN MANOUKIAN',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'000-000-000',
'',
'',
'');
INSERT INTO `fournisseurs` values ('46',
'soft',
'Soft Grey',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'000-000-000',
'',
'',
'');
INSERT INTO `fournisseurs` values ('47',
'bout',
'La boutique',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'000-000-000',
'',
'',
'');
INSERT INTO `fournisseurs` values ('48',
'cote',
'CÔTÉ FEMME',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'000-000-000',
'',
'',
'');
INSERT INTO `fournisseurs` values ('53',
'J0001',
'coquelicot bleu',
'juge',
'estelle',
'Marcellaz Albanais',
'',
'Marcellaz Albanais',
'',
'',
'',
'',
'',
'',
'',
'',
'');
INSERT INTO `fournisseurs` values ('54',
'ros',
'Jean-Paul ROSSI',
'',
'',
'',
'73',
'Thoiry',
'',
'',
'',
'',
'',
'',
'',
'',
'');
DROP TABLE IF EXISTS `languages`;
CREATE TABLE `languages` (
`languages_id` int(5) NOT NULL auto_increment,
`name` varchar(32) NOT NULL default '',
`code` char(2) NOT NULL default '',
`defaut` enum('yes','no') NOT NULL default 'no',
`visible` enum('yes','no') NOT NULL default 'yes',
PRIMARY KEY (`languages_id`),
KEY `IDX_LANGUAGES_NAME` (`name`)
) TYPE=MyISAM;
INSERT INTO `languages` values ('1',
'Français',
'1',
'yes',
'yes');
INSERT INTO `languages` values ('2',
'English',
'2',
'no',
'no');
INSERT INTO `languages` values ('3',
'Español',
'3',
'no',
'no');
DROP TABLE IF EXISTS `newsletter`;
CREATE TABLE `newsletter` (
`newsletter_id` int(11) NOT NULL auto_increment,
`newsletter_email` varchar(255) NOT NULL default '',
`newsletter_password` varchar(11) NOT NULL default '',
`newsletter_langue` char(2) NOT NULL default '',
`newsletter_active` enum('yes','no') NOT NULL default 'no',
`newsletter_statut` enum('never','active','out') NOT NULL default 'never',
`newsletter_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`newsletter_id`)
) TYPE=MyISAM;
INSERT INTO `newsletter` values ('34',
'toto@toto.com',
'5FLV4PG',
'fr',
'no',
'never',
'2003-11-26 18:26:36');
INSERT INTO `newsletter` values ('31',
'4@4.com',
'ICBAQKR',
'fr',
'no',
'never',
'2003-11-26 17:26:59');
INSERT INTO `newsletter` values ('30',
'3@3.com',
'ZDZT4GN',
'fr',
'yes',
'active',
'2003-11-26 17:26:50');
INSERT INTO `newsletter` values ('28',
'1@1.com',
'CNE9FVZ',
'fr',
'no',
'never',
'2003-11-26 17:00:57');
INSERT INTO `newsletter` values ('29',
'2@2.com',
'FYSNSF3',
'fr',
'yes',
'active',
'2003-11-26 17:26:35');
DROP TABLE IF EXISTS `newsletter_sent`;
CREATE TABLE `newsletter_sent` (
`newsletter_sent_id` int(11) NOT NULL auto_increment,
`newsletter_sent_date` date NOT NULL default '0000-00-00',
`newsletter_sent_message` longtext NOT NULL,
PRIMARY KEY (`newsletter_sent_id`)
) TYPE=MyISAM;
INSERT INTO `newsletter_sent` values ('32',
'2004-05-14',
'bold');
INSERT INTO `newsletter_sent` values ('4',
'2003-11-26',
'MESSAGE4');
INSERT INTO `newsletter_sent` values ('28',
'2004-02-12',
'test2');
INSERT INTO `newsletter_sent` values ('31',
'2004-05-14',
'test newsletter');
INSERT INTO `newsletter_sent` values ('7',
'2003-11-26',
'ded');
INSERT INTO `newsletter_sent` values ('27',
'2004-02-12',
'test');
INSERT INTO `newsletter_sent` values ('30',
'2004-02-12',
'test1000');
INSERT INTO `newsletter_sent` values ('33',
'2004-05-14',
'test');
INSERT INTO `newsletter_sent` values ('34',
'2004-05-14',
'test');
INSERT INTO `newsletter_sent` values ('35',
'2004-05-14',
'test');
INSERT INTO `newsletter_sent` values ('36',
'2004-05-14',
'test');
DROP TABLE IF EXISTS `ordered`;
CREATE TABLE `ordered` (
`order_id` int(11) NOT NULL auto_increment,
`order_1` varchar(25) NOT NULL default '',
`order_2` varchar(25) NOT NULL default '',
`order_3` varchar(25) NOT NULL default '',
`order_view` enum('yes','no') NOT NULL default 'yes',
PRIMARY KEY (`order_id`)
) TYPE=MyISAM;
INSERT INTO `ordered` values ('1',
'Ref',
'Ref',
'Ref',
'yes');
INSERT INTO `ordered` values ('20',
'Article',
'Item',
'Artículo',
'yes');
INSERT INTO `ordered` values ('3',
'Prix',
'Price',
'Precio',
'yes');
INSERT INTO `ordered` values ('4',
'Compagnie',
'Company',
'Empresa',
'yes');
INSERT INTO `ordered` values ('5',
'Les plus visites',
'The most viewed',
'Los mas vistos',
'yes');
DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
`products_id` int(5) NOT NULL auto_increment,
`categories_id` int(5) NOT NULL default '0',
`fournisseurs_id` int(5) NOT NULL default '0',
`afficher_fournisseur` enum('yes','no') NOT NULL default 'yes',
`products_name_1` varchar(255) NOT NULL default '',
`products_name_2` varchar(255) NOT NULL default '',
`products_name_3` varchar(255) NOT NULL default '',
`products_desc_1` longtext NOT NULL,
`products_desc_2` longtext NOT NULL,
`products_desc_3` longtext NOT NULL,
`products_garantie_1` varchar(255) NOT NULL default '',
`products_garantie_2` varchar(255) NOT NULL default '',
`products_garantie_3` varchar(255) NOT NULL default '',
`products_price` decimal(6,2) NOT NULL default '0.00',
`products_weight` int(11) NOT NULL default '0',
`products_options` enum('yes','no') NOT NULL default 'no',
`products_option_note_1` longtext NOT NULL,
`products_option_note_2` longtext NOT NULL,
`products_option_note_3` longtext NOT NULL,
`products_ref` varchar(255) NOT NULL default '',
`products_im` enum('yes','no') NOT NULL default 'yes',
`products_image` varchar(255) NOT NULL default '',
`products_image2` varchar(255) NOT NULL default '',
`products_image3` varchar(255) NOT NULL default '',
`products_image4` varchar(255) NOT NULL default '',
`products_image5` varchar(255) NOT NULL default '',
`products_note_1` longtext NOT NULL,
`products_note_2` longtext NOT NULL,
`products_note_3` longtext NOT NULL,
`products_visible` enum('yes','no') NOT NULL default 'yes',
`products_taxable` enum('yes','no') NOT NULL default 'yes',
`products_tax` decimal(4,2) NOT NULL default '0.00',
`products_date_added` datetime default NULL,
`products_viewed` int(11) NOT NULL default '0',
`products_added` int(11) NOT NULL default '0',
`products_qt` int(11) NOT NULL default '0',
`products_download` enum('yes','no') NOT NULL default 'no',
`products_download_name` varchar(255) NOT NULL default '',
`products_related` varchar(255) NOT NULL default '',
PRIMARY KEY (`products_id`)
) TYPE=MyISAM;
INSERT INTO `products` values ('176',
'27',
'53',
'yes',
'Boite à sucre ou à thé',
'',
'',
'Boite à sucre ou à thé,avec compartiments amovibles.
dimensions L:24 l:17 H:11 cm .',
'',
'',
'',
'',
'',
'43.00',
'700',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'btethé',
'yes',
'im/boite_à théW.jpg',
'im/boite_à thé1.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 17:54:15',
'2',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('177',
'27',
'53',
'yes',
'petit coffret',
'',
'',
'Petit coffret en sapin,trés solide avec compartiments amovibles',
'',
'',
'',
'',
'',
'52.00',
'600',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'pticof',
'yes',
'im/petit_coffret.jpg',
'im/petit_coffret_inter.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 17:58:54',
'14',
'3',
'2',
'no',
'',
'');
INSERT INTO `products` values ('178',
'27',
'53',
'yes',
'coffret luge',
'',
'',
'A remplir de papillotes.',
'',
'',
'',
'',
'',
'0.00',
'0',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'cofluge',
'yes',
'im/luge_à_papillottes_W.jpg',
'im/luge_à_papillottes.jpg',
'',
'',
'',
'Fabriqué en bois massif avec séparations amovibles . Longueur:environ 20 cm',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 18:02:36',
'0',
'0',
'0',
'no',
'',
'');
INSERT INTO `products` values ('179',
'28',
'53',
'yes',
'Support papier toilettes',
'',
'',
'Accessoire pour les petits et les grands',
'',
'',
'',
'',
'',
'28.00',
'300',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'lapintoil',
'yes',
'im/lapin_papier_toiletteW.jpg',
'im/lapin_papier_toilette.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 18:07:01',
'2',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('180',
'28',
'53',
'yes',
'Cache photo simple',
'',
'',
'cadre en bois décoré à la main.',
'',
'',
'',
'',
'',
'19.00',
'150',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'photsimpl',
'yes',
'im/cache_phot_seul_W.jpg',
'im/cache_phot_seul.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 18:11:35',
'1',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('181',
'28',
'53',
'yes',
'accroche torchons',
'',
'',
'Pratique dans la maison,en bois peint à la main.',
'',
'',
'',
'',
'',
'10.00',
'120',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'actorchon',
'yes',
'im/accroche_torchon_W.jpg',
'im/accroche_torchon.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 18:26:51',
'0',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('182',
'28',
'53',
'yes',
'cadre photo avec figurine',
'',
'',
'Cadre photo avec figurine en bois peint à la main.
pour photo 13 * 18 cm',
'',
'',
'',
'',
'',
'29.00',
'350',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'photfigur',
'yes',
'im/cache_phot_figurine_W.jpg',
'im/cache_phot_figurine.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 18:30:29',
'3',
'1',
'2',
'no',
'',
'');
INSERT INTO `products` values ('183',
'28',
'53',
'yes',
'plateau luge',
'',
'',
'Plateau livré prêt à décorer.
dimension Longueur environ 40 cm',
'',
'',
'',
'',
'',
'43.00',
'700',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'platluge',
'yes',
'im/plateau_luge_W.jpg',
'im/plateau_luge.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 22:43:26',
'5',
'1',
'2',
'no',
'',
'');
INSERT INTO `products` values ('184',
'28',
'53',
'yes',
'marque de porte',
'',
'',
'Plaques de porte peintes à la main .',
'',
'',
'',
'',
'',
'11.00',
'100',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'marqporte',
'yes',
'im/marques de portesW.jpg',
'im/marques de portes.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 22:46:57',
'0',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('185',
'29',
'53',
'yes',
'Père noël',
'',
'',
'Père noël sur socle peint à la main.
Hauteur environ 37 cm.',
'',
'',
'',
'',
'',
'35.00',
'500',
'no',
'',
'',
'',
'pernoël',
'yes',
'im/Gd_père_noël_W.jpg',
'im/Gd_père_noël.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 22:51:45',
'3',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('186',
'29',
'53',
'yes',
'bonhomme de neige sur socle',
'',
'',
'Figurine en bois peinte à la main.',
'',
'',
'',
'',
'',
'20.50',
'300',
'no',
'',
'',
'',
'bonhneige',
'yes',
'im/bonh_de neige_sur_socleW.jpg',
'im/bonh_de neige_sur_socle.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 22:56:24',
'3',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('187',
'29',
'53',
'yes',
'Grand ours de noël',
'',
'',
'Grand ours de noël aux dimensions respectables. H:60 l:40 cm.',
'',
'',
'',
'',
'',
'51.00',
'600',
'no',
'',
'',
'',
'gdoursnoël',
'yes',
'im/ours_de_noêl_W.jpg',
'im/ours_de_noêl.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 22:59:52',
'2',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('188',
'29',
'53',
'yes',
'Sapin sur socle',
'',
'',
'Sapin sur socle peint sur les deux faces comportant chacune un motif différent.
Hauteur environ 35 cm.',
'',
'',
'',
'',
'',
'29.50',
'400',
'no',
'',
'',
'',
'sapsoc',
'yes',
'im/sapin_sur_socle_W.jpg',
'im/sapi_sur_socle.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 23:03:42',
'3',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('189',
'30',
'53',
'yes',
'applique champignon',
'',
'',
'Amettre sur le mur des enfants.
Hauteur environ 20 cm .',
'',
'',
'',
'',
'',
'17.00',
'150',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'apchamp',
'yes',
'im/applique_deco_champignonW.jpg',
'im/applique_deco_champignon.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 23:08:57',
'0',
'0',
'0',
'no',
'',
'');
INSERT INTO `products` values ('190',
'30',
'53',
'yes',
'applique mouton',
'',
'',
'A mettre sur les murs de la chambre des enfants.',
'',
'',
'',
'',
'',
'17.00',
'150',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'apmouton',
'yes',
'im/applique_deco_mouton_W.jpg',
'im/applique_deco_mouton.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 23:23:41',
'0',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('191',
'30',
'53',
'yes',
'applique poisson',
'',
'',
'A accrocher au mur de la chambre des enfants.',
'',
'',
'',
'',
'',
'17.00',
'150',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'appoisson',
'yes',
'im/applique_deco_poissonW.jpg',
'im/applique_deco_poisson.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 23:29:45',
'2',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('192',
'30',
'53',
'yes',
'applique vache',
'',
'',
'A mettre sur le mur de la chambre des enfants.',
'',
'',
'',
'',
'',
'17.00',
'150',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'apvache',
'yes',
'im/applique_deco_vacheW.jpg',
'im/applique_deco_vache.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 23:32:42',
'1',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('193',
'30',
'53',
'yes',
'applique bonhomme de neige',
'',
'',
'A mettre sur le mur de la chambre des enfants.',
'',
'',
'',
'',
'',
'17.00',
'150',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'apbonneige',
'yes',
'im/applique_decobon_d_neige.jpg',
'im/applique_decobon_d_neige_gd.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 23:35:23',
'2',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('194',
'31',
'53',
'yes',
'bougeoirs animal',
'',
'',
'Chats,cerf bougeoirs décorés à la main.
Hauteur 18 cm.
Le prix indiqué correspond à une pièce !',
'',
'',
'',
'',
'',
'17.80',
'300',
'no',
'',
'',
'',
'bouganim',
'yes',
'im/bougeoirs_animaux_W.jpg',
'im/bougeoirs_animaux.jpg',
'im/bougeoirs_animaux_cerf_w.jpg',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 23:51:10',
'0',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('195',
'31',
'53',
'yes',
'bougeoir bonhomme de neige',
'',
'',
'Ce bougeoir décoré plaira aux enfants lors des fêtes (anniversaire et à noël).',
'',
'',
'',
'',
'',
'20.50',
'300',
'no',
'',
'',
'',
'bougboneige',
'yes',
'im/bougeoirs_bonh_de_neige_femme_W.jpg',
'im/bougeoirs_bonh_de_neige_femme.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 23:56:38',
'2',
'1',
'2',
'no',
'',
'');
INSERT INTO `products` values ('173',
'25',
'53',
'yes',
'Pendule',
'',
'',
'Pour apprendre à lire l’heure.
Hauter environ 40 cm',
'',
'',
'',
'',
'',
'39.00',
'800',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'pendule',
'yes',
'im/pendule_lapinW.jpg',
'im/pendule_lapin.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 16:01:40',
'4',
'1',
'2',
'no',
'',
'');
INSERT INTO `products` values ('174',
'26',
'53',
'yes',
'Boite à jeu de cartes',
'',
'',
'En bois massifavec cloisons amovibles.
Dimensions L:24 l:20 H:6 cm',
'',
'',
'',
'',
'',
'49.00',
'600',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'btejdecart',
'yes',
'im/boite_à_jeux_de_carteW.jpg',
'',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 17:03:36',
'1',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('175',
'26',
'53',
'yes',
'Grande boite',
'',
'',
'Grande boite de rangements avec cloisons amovibles.
Dimensions L:45 l:33 H:8 cm.
Existe aussi avec une hauteur de 8 cm',
'',
'',
'',
'',
'',
'85.00',
'1500',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'gdebterang',
'yes',
'im/boite_à_rangements_W.jpg',
'im/boite_à_rangements.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 17:06:36',
'2',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('166',
'25',
'53',
'yes',
'Jeu de l’écureuil',
'',
'',
'Petit écureuil fait ses réserves',
'',
'',
'',
'',
'',
'54.00',
'1000',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'Jécureuil',
'yes',
'im/jeux_ecureuilW.jpg',
'im/jeux_ecureuil.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 15:13:00',
'5',
'1',
'2',
'no',
'',
'');
INSERT INTO `products` values ('167',
'25',
'53',
'yes',
'A vos rames',
'',
'',
'A vos rames prêt partez !',
'',
'',
'',
'',
'',
'54.00',
'1000',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'àvosram',
'yes',
'im/jeux_àvosramesW.jpg',
'im/jeux_àvosrames.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 15:16:14',
'3',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('168',
'25',
'53',
'yes',
'La course du poulailler',
'',
'',
'\"La course du poulailler\",présenté sur le dessus d’une trés jolie boite de jeu.
dimensions:L:45 l:33 H:8 cm',
'',
'',
'',
'',
'',
'95.00',
'1000',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'courspoul',
'yes',
'im/jeux_boitecoursepoulaillerW.jpg',
'',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 15:20:27',
'2',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('169',
'25',
'53',
'yes',
'Boite à puzzle',
'',
'',
'Boite à puzzlz.Dimensions L:24 l:16 H:9 cm',
'',
'',
'',
'',
'',
'73.00',
'600',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'btepuzz',
'yes',
'im/boite_puzzlereduit1W.jpg',
'im/boite_puzzle.jpg',
'im/boite_puzzle1.jpg',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 15:32:12',
'0',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('170',
'25',
'53',
'yes',
'Boite à chiffres',
'',
'',
'Joli coffret décoré contenant des cubes en bois sur lesquels sont peints des chiffres.',
'',
'',
'',
'',
'',
'40.00',
'700',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'btchiff',
'yes',
'im/bteàcchiffres1W.jpg',
'im/bteàcchiffres1.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 15:38:20',
'2',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('171',
'26',
'53',
'yes',
'Boite à dent de lait',
'',
'',
'La souris saura où mettre sa petite pièce.Diamètre environ 9 cm.',
'',
'',
'',
'',
'',
'16.00',
'150',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'btedetlait',
'yes',
'im/boite_dent_laitW.jpg',
'im/boite_dent_lait.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 15:45:23',
'3',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('172',
'25',
'53',
'yes',
'J’apprends à compter',
'',
'',
'J’apprends à compter avec les herissons,présenté dans un sac en toile de jute avec un dé en pin massif de 40*40 mm et une règle du jeu.
Dimension L:20 H:10 cm',
'',
'',
'',
'',
'',
'13.00',
'300',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'japcompther',
'yes',
'im/jeux_duherisson_rouge.jpg',
'im/jeux_duherissonW.jpg',
'im/jeux_duherisson_jaune.jpg',
'im/jeux_duherisson_citron.jpg',
'im/jeux_duherisson_champignon_vert.jpg',
'A la commande , précisez le modèle et la couleur ex:herisson rouge .Merci',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 15:50:03',
'0',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('165',
'25',
'53',
'yes',
'Jeu des champignons',
'',
'',
'Style jeu de l’oie \"La cueillette des champignons\".Livré avec un sac de toile conttenant les pions.',
'',
'',
'',
'',
'',
'54.00',
'1000',
'yes',
'A la demande il est possible d’inscrire une dédicace ou un prénom .
Indiquez vos préférences lors de la commande.
',
'',
'',
'Jchamp',
'yes',
'im/jeux_cueilchampignons1W.jpg',
'im/jeux_cueilchampignons.jpg',
'im/jeux_cueilchampignons1.jpg',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-21 14:53:27',
'2',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('201',
'33',
'54',
'yes',
'Ecuelle médiévale',
'',
'',
'Décoration \"dent de scie\" tournée au tour à perche en bois vert. ',
'',
'',
'',
'',
'',
'69.00',
'600',
'no',
'',
'',
'',
'ecuelmed',
'yes',
'im/écuelle médiévale_red.jpg',
'im/écuelle médiévale_grd.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-27 17:30:36',
'0',
'0',
'1',
'no',
'',
'');
INSERT INTO `products` values ('202',
'33',
'54',
'yes',
'Gourde monoxyle',
'',
'',
'Gourde traditionnelle des bauges appelée \"Boteillon\" fabriquée à l’ancienne.
contenance :2 litres environ.',
'',
'',
'',
'',
'',
'195.00',
'0',
'no',
'',
'',
'',
'gourde',
'yes',
'im/gourde monoxyle_red.jpg',
'im/gourde monoxyle_grd.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-27 17:33:56',
'2',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('203',
'33',
'54',
'yes',
'Mortier et Pilon',
'',
'',
'Fabriqué en pommier huilé et en sycomore pour le pilon.',
'',
'',
'',
'',
'',
'61.00',
'0',
'no',
'',
'',
'',
'mopil',
'yes',
'im/mortier et pilon_red.jpg',
'im/mortier et pilon_grd.jpg',
'im/mortier et pilon1_grd.jpg',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-27 17:37:37',
'0',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('204',
'33',
'54',
'yes',
'Cuillère 2 axes',
'',
'',
'En bois tounée,Longueur 39 cm',
'',
'',
'',
'',
'',
'20.00',
'0',
'no',
'',
'',
'',
'cuil2ax',
'yes',
'im/cuiller 2 axes_red.jpg',
'im/cuiller tournée 2 axes_grd.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-27 17:40:47',
'2',
'0',
'2',
'no',
'',
'');
INSERT INTO `products` values ('205',
'33',
'54',
'yes',
'Gralet',
'',
'',
'Fait selon les modeles anciens en érable sycomore.Diamétre 17 cm.',
'',
'',
'',
'',
'',
'29.00',
'250',
'yes',
'',
'',
'',
'gralet',
'yes',
'im/gralet_red.jpg',
'im/gralet_grd.jpg',
'',
'',
'',
'Existe également en diamètre 20 cm',
'',
'',
'yes',
'no',
'0.00',
'2004-12-29 16:14:32',
'0',
'0',
'1',
'no',
'',
'');
INSERT INTO `products` values ('206',
'33',
'54',
'yes',
'cuillère tournée 2 axes',
'',
'',
'Tournées 2 axes en érable duret ou alisier blanc .Prix pour une pièce.Le petit modèle:',
'',
'',
'',
'',
'',
'17.00',
'120',
'yes',
'',
'',
'',
'cuitour2ax',
'yes',
'im/cuiller tournée 2 axes_red.jpg',
'im/cuiller tournée 2 axes_grd.jpg',
'',
'',
'',
'le grand modèle:',
'',
'',
'yes',
'no',
'0.00',
'2004-12-29 16:33:34',
'0',
'0',
'1',
'no',
'',
'');
INSERT INTO `products` values ('207',
'33',
'54',
'yes',
'Grale',
'',
'',
'Magnifique Grale réalisé au tour à bois selon une méthode ancestrale,cette pièce est unique.Réalisée en érable,son diamètre est de 57 cm avec une profondeur de 15 cm.
',
'',
'',
'',
'',
'',
'575.00',
'6000',
'no',
'',
'',
'',
'grale',
'yes',
'im/grale en bois_red.jpg',
'im/grale en bois_grd.jpg',
'im/grale en bois_int_grd.jpg',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-29 16:42:13',
'1',
'0',
'1',
'no',
'',
'');
INSERT INTO `products` values ('196',
'33',
'54',
'yes',
'Colu',
'',
'',
'Entonnoir et Filtre à lait .
Longueur environ 35 cm.',
'',
'',
'',
'',
'',
'80.00',
'300',
'no',
'',
'',
'',
'colu',
'yes',
'im/colu_red.jpg',
'im/colu_red _grd.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-27 17:13:07',
'0',
'0',
'0',
'no',
'',
'');
INSERT INTO `products` values ('197',
'33',
'54',
'yes',
'Bol',
'',
'',
'Bol en Robiner',
'',
'',
'',
'',
'',
'17.00',
'150',
'no',
'',
'',
'',
'bol',
'yes',
'im/bol en robinier_red.jpg',
'im/bol en robinier_grd.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-27 17:16:55',
'0',
'0',
'0',
'no',
'',
'');
INSERT INTO `products` values ('198',
'33',
'54',
'yes',
'Bol à Vis',
'',
'',
'Bols à vis tourné à la perche selon les methodes anciennes en vis à vis dans l’arbre (Pièces jumelles).
vendus par paires.Fabriqués en érable sycomore.',
'',
'',
'',
'',
'',
'76.00',
'0',
'no',
'',
'',
'',
'bolvis',
'yes',
'im/bol à vis_red.jpg',
'im/bol à vis_grd.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-27 17:19:20',
'1',
'0',
'400',
'no',
'',
'');
INSERT INTO `products` values ('199',
'33',
'54',
'yes',
'Ecuelle',
'',
'',
'Trés jolie écuelle en prunier , Diamètre 24 cm.',
'',
'',
'',
'',
'',
'60.00',
'400',
'no',
'',
'',
'',
'ecuel',
'yes',
'im/écuelle en prunier_red.jpg',
'im/écuelle en prunier_grd.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-27 17:24:02',
'0',
'0',
'1',
'no',
'',
'');
INSERT INTO `products` values ('200',
'33',
'54',
'yes',
'Grande Jatte',
'',
'',
'Grande Jatte en bois de noyer d’un diamètre de 44 cm et d’une profondeur intérieure de 8 cm',
'',
'',
'',
'',
'',
'390.00',
'0',
'no',
'',
'',
'',
'jat',
'yes',
'im/grande jatte en noyer_red.jpg',
'im/grande jatte en noyer_grd.jpg',
'',
'',
'',
'',
'',
'',
'yes',
'no',
'0.00',
'2004-12-27 17:27:08',
'1',
'0',
'1',
'no',
'',
'');
DROP TABLE IF EXISTS `products_id_to_products_options_id`;
CREATE TABLE `products_id_to_products_options_id` (
`products_id` int(11) NOT NULL default '0',
`products_options_id` int(11) NOT NULL default '0',
`products_option` text NOT NULL
) TYPE=MyISAM;
INSERT INTO `products_id_to_products_options_id` values ('169',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('96',
'1',
'Blanc::+0.00,Bleu::+0.00,Jaune::+0.00,Rose::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('174',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('167',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('168',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('165',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('166',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('96',
'2',
'32-36::+0.00,40-42::+0.00,42-45::+10.00,');
INSERT INTO `products_id_to_products_options_id` values ('176',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('170',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('171',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('172',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('173',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('175',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('205',
'2',
'diamétre 20 cm::+5.00,');
INSERT INTO `products_id_to_products_options_id` values ('206',
'57',
'la pièce::+3.00,');
INSERT INTO `products_id_to_products_options_id` values ('181',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('182',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('183',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('184',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('189',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('190',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('191',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('192',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('193',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('177',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('178',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('179',
'55',
'6 euros::+0.00,');
INSERT INTO `products_id_to_products_options_id` values ('180',
'55',
'6 euros::+0.00,');
DROP TABLE IF EXISTS `products_options`;
CREATE TABLE `products_options` (
`products_options_id` int(11) NOT NULL auto_increment,
`products_options_name` varchar(255) NOT NULL default '',
PRIMARY KEY (`products_options_id`)
) TYPE=MyISAM;
INSERT INTO `products_options` values ('1',
'Couleur');
INSERT INTO `products_options` values ('2',
'Taille');
INSERT INTO `products_options` values ('3',
'Matiére');
INSERT INTO `products_options` values ('36',
'4 - Disque dur');
INSERT INTO `products_options` values ('35',
'8 - Clavier');
INSERT INTO `products_options` values ('34',
'1 - Processeur');
INSERT INTO `products_options` values ('32',
'Livraison');
INSERT INTO `products_options` values ('33',
'Écran');
INSERT INTO `products_options` values ('37',
'2 - Système d\'exploitation');
INSERT INTO `products_options` values ('38',
'3 - Mémoire');
INSERT INTO `products_options` values ('39',
'6 - Moniteur');
INSERT INTO `products_options` values ('40',
'5 - Vidéo');
INSERT INTO `products_options` values ('41',
'CDRom');
INSERT INTO `products_options` values ('50',
'test');
INSERT INTO `products_options` values ('51',
'Systéme');
INSERT INTO `products_options` values ('45',
'7 - Souris');
INSERT INTO `products_options` values ('47',
'test1');
INSERT INTO `products_options` values ('52',
'test adobe');
INSERT INTO `products_options` values ('53',
'test12');
INSERT INTO `products_options` values ('54',
'test111');
INSERT INTO `products_options` values ('55',
'Personnalisation');
INSERT INTO `products_options` values ('56',
'diamétre 20 cm');
INSERT INTO `products_options` values ('57',
'grand modèle');
DROP TABLE IF EXISTS `products_options_values`;
CREATE TABLE `products_options_values` (
`products_options_values_id` int(11) NOT NULL auto_increment,
`products_options_id` int(11) NOT NULL default '0',
`products_options_values_name` varchar(255) NOT NULL default '',
PRIMARY KEY (`products_options_values_id`)
) TYPE=MyISAM;
INSERT INTO `products_options_values` values ('16',
'1',
'Bleu');
INSERT INTO `products_options_values` values ('2',
'1',
'Blanc');
INSERT INTO `products_options_values` values ('3',
'1',
'Rouge');
INSERT INTO `products_options_values` values ('4',
'2',
'X');
INSERT INTO `products_options_values` values ('5',
'2',
'XL');
INSERT INTO `products_options_values` values ('6',
'2',
'XXL');
INSERT INTO `products_options_values` values ('7',
'3',
'Bois');
INSERT INTO `products_options_values` values ('8',
'3',
'plastique');
INSERT INTO `products_options_values` values ('9',
'3',
'Cuir');
INSERT INTO `products_options_values` values ('10',
'1',
'Vert');
INSERT INTO `products_options_values` values ('24',
'32',
'Boite');
INSERT INTO `products_options_values` values ('23',
'1',
'Jaune');
INSERT INTO `products_options_values` values ('21',
'1',
'Rose');
INSERT INTO `products_options_values` values ('22',
'1',
'Marron');
INSERT INTO `products_options_values` values ('25',
'32',
'Télécharger');
INSERT INTO `products_options_values` values ('26',
'2',
'36-40');
INSERT INTO `products_options_values` values ('27',
'2',
'40-42');
INSERT INTO `products_options_values` values ('28',
'2',
'42-45');
INSERT INTO `products_options_values` values ('29',
'2',
'32-36');
INSERT INTO `products_options_values` values ('30',
'1',
'Noir');
INSERT INTO `products_options_values` values ('31',
'33',
'14.1 pouces');
INSERT INTO `products_options_values` values ('32',
'33',
'15 pouces');
INSERT INTO `products_options_values` values ('40',
'33',
'16.1 pouces');
INSERT INTO `products_options_values` values ('37',
'34',
'1.8 GHz');
INSERT INTO `products_options_values` values ('35',
'34',
'2 GHz');
INSERT INTO `products_options_values` values ('36',
'34',
'2.5 GHz');
INSERT INTO `products_options_values` values ('38',
'35',
'QWERTY');
INSERT INTO `products_options_values` values ('41',
'36',
'30 Go');
INSERT INTO `products_options_values` values ('42',
'36',
'60 Go');
INSERT INTO `products_options_values` values ('43',
'36',
'80 Go');
INSERT INTO `products_options_values` values ('45',
'1',
'Beige');
INSERT INTO `products_options_values` values ('46',
'1',
'Gris');
INSERT INTO `products_options_values` values ('47',
'1',
'Kaki');
INSERT INTO `products_options_values` values ('48',
'2',
'38');
INSERT INTO `products_options_values` values ('49',
'2',
'40');
INSERT INTO `products_options_values` values ('50',
'2',
'42');
INSERT INTO `products_options_values` values ('51',
'2',
'44');
INSERT INTO `products_options_values` values ('52',
'2',
'46');
INSERT INTO `products_options_values` values ('53',
'2',
'48');
INSERT INTO `products_options_values` values ('54',
'2',
'50');
INSERT INTO `products_options_values` values ('55',
'2',
'36');
INSERT INTO `products_options_values` values ('56',
'1',
'Bleu foncé brillant');
INSERT INTO `products_options_values` values ('57',
'2',
'34');
INSERT INTO `products_options_values` values ('58',
'1',
'Lavé');
INSERT INTO `products_options_values` values ('59',
'1',
'Stone');
INSERT INTO `products_options_values` values ('60',
'2',
'26');
INSERT INTO `products_options_values` values ('61',
'2',
'28');
INSERT INTO `products_options_values` values ('62',
'2',
'30');
INSERT INTO `products_options_values` values ('63',
'2',
'32');
INSERT INTO `products_options_values` values ('64',
'1',
'Bleu lavé');
INSERT INTO `products_options_values` values ('65',
'2',
'31');
INSERT INTO `products_options_values` values ('66',
'1',
'Black optic');
INSERT INTO `products_options_values` values ('67',
'1',
'bleu stone');
INSERT INTO `products_options_values` values ('71',
'1',
'Blanc-Marine');
INSERT INTO `products_options_values` values ('86',
'1',
'Rose irisé');
INSERT INTO `products_options_values` values ('74',
'2',
'39');
INSERT INTO `products_options_values` values ('75',
'2',
'41');
INSERT INTO `products_options_values` values ('76',
'2',
'43');
INSERT INTO `products_options_values` values ('77',
'2',
'45');
INSERT INTO `products_options_values` values ('78',
'1',
'Bleu-Gris');
INSERT INTO `products_options_values` values ('79',
'1',
'Rouge-Noir');
INSERT INTO `products_options_values` values ('80',
'1',
'Argent-Bleu');
INSERT INTO `products_options_values` values ('81',
'2',
'35');
INSERT INTO `products_options_values` values ('82',
'2',
'37');
INSERT INTO `products_options_values` values ('83',
'1',
'Blanc-Argent');
INSERT INTO `products_options_values` values ('84',
'1',
'Rouge-écru');
INSERT INTO `products_options_values` values ('85',
'1',
'Noir-Vanille');
INSERT INTO `products_options_values` values ('99',
'35',
'AZERTY');
INSERT INTO `products_options_values` values ('100',
'37',
'Microsoft Windows XP édition familiale (SP1)');
INSERT INTO `products_options_values` values ('101',
'37',
'Microsoft Windows XP Professionnel.');
INSERT INTO `products_options_values` values ('103',
'34',
'Intel P4 à 3 GHz. bus systéme à 800 MHz');
INSERT INTO `products_options_values` values ('104',
'34',
'Intel Pentium 4 à 3.2 GHz. bus systéme à 800 MHz');
INSERT INTO `products_options_values` values ('108',
'38',
'512 Mo DDR SDRAM (2x256)');
INSERT INTO `products_options_values` values ('107',
'38',
'256 Mo DDR SDRAM (2x128)');
INSERT INTO `products_options_values` values ('109',
'38',
'1024 Mo DDR SDRAM (2x512)');
INSERT INTO `products_options_values` values ('110',
'38',
'2048 Mo DDR SDRAM (4x512)');
INSERT INTO `products_options_values` values ('111',
'36',
'80 Go Ultra DMA (7200 tpm)');
INSERT INTO `products_options_values` values ('112',
'36',
'120 Go Serial ATA (7200rpm)');
INSERT INTO `products_options_values` values ('113',
'36',
'200 Go Ultra DMA (7200 tpm)');
INSERT INTO `products_options_values` values ('123',
'39',
'Moniteur standard 19 M992 noir');
INSERT INTO `products_options_values` values ('135',
'39',
'Ecran Plat 19 1901FP ultrasharp (DVI) noir');
INSERT INTO `products_options_values` values ('134',
'39',
'Ecran Plat 17 E172FP analogique noir');
INSERT INTO `products_options_values` values ('124',
'39',
'Moniteur 21 P1130 Ultrascan noir');
INSERT INTO `products_options_values` values ('125',
'39',
'Ecran Plat 15 E151FPB analogique noir');
INSERT INTO `products_options_values` values ('136',
'39',
'Ecran Plat 20 2000FP ultrasharp (DVI) noir');
INSERT INTO `products_options_values` values ('137',
'40',
'Carte Video ATI Radeon 9800 Pro 128 Mo DDR');
INSERT INTO `products_options_values` values ('138',
'40',
'Carte Video ATI Radeon 9800XT 256 Mo DDR');
INSERT INTO `products_options_values` values ('154',
'47',
'titi');
INSERT INTO `products_options_values` values ('140',
'41',
'Graveur DVD+RW 4x-CDRW (12x-10x-32x)');
INSERT INTO `products_options_values` values ('148',
'45',
'Souris PS-2 2 boutons - molette');
INSERT INTO `products_options_values` values ('149',
'45',
'Souris Logitech Optique USB 2 boutons - molette (avec fil)...');
INSERT INTO `products_options_values` values ('150',
'34',
'Intel P4 à 2.5 GHz. bus systéme à 800 MHz');
INSERT INTO `products_options_values` values ('151',
'47',
'toto');
INSERT INTO `products_options_values` values ('163',
'50',
'ff');
INSERT INTO `products_options_values` values ('164',
'51',
'PC');
INSERT INTO `products_options_values` values ('165',
'51',
'MAC');
INSERT INTO `products_options_values` values ('166',
'52',
'grand');
INSERT INTO `products_options_values` values ('167',
'52',
'petit');
INSERT INTO `products_options_values` values ('169',
'53',
'petit');
INSERT INTO `products_options_values` values ('172',
'55',
'6 euros');
INSERT INTO `products_options_values` values ('173',
'2',
'diametre');
INSERT INTO `products_options_values` values ('174',
'2',
'diamétre 20 cm');
INSERT INTO `products_options_values` values ('175',
'2',
'- 5');
INSERT INTO `products_options_values` values ('176',
'2',
'-5');
INSERT INTO `products_options_values` values ('177',
'2',
'5');
INSERT INTO `products_options_values` values ('178',
'2',
'5');
INSERT INTO `products_options_values` values ('179',
'2',
'-5');
INSERT INTO `products_options_values` values ('180',
'2',
'- 5');
INSERT INTO `products_options_values` values ('181',
'2',
'diamétre 20 cm');
INSERT INTO `products_options_values` values ('182',
'2',
'diametre');
INSERT INTO `products_options_values` values ('183',
'56',
'5');
INSERT INTO `products_options_values` values ('184',
'56',
'5');
INSERT INTO `products_options_values` values ('185',
'57',
'3');
INSERT INTO `products_options_values` values ('186',
'57',
'la pièce');
DROP TABLE IF EXISTS `ship_price`;
CREATE TABLE `ship_price` (
`id` int(11) NOT NULL auto_increment,
`weight` int(11) NOT NULL default '0',
`zone1` decimal(7,2) NOT NULL default '0.00',
`zone2` decimal(7,2) NOT NULL default '0.00',
`zone3` decimal(7,2) NOT NULL default '0.00',
`zone4` decimal(7,2) NOT NULL default '0.00',
`zone5` decimal(7,2) NOT NULL default '0.00',
`zone6` decimal(7,2) NOT NULL default '0.00',
`zone7` decimal(7,2) NOT NULL default '0.00',
`zone8` decimal(7,2) NOT NULL default '0.00',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
INSERT INTO `ship_price` values ('24',
'20',
'0.51',
'0.71',
'0.90',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('2',
'40',
'1.00',
'1.60',
'1.80',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('3',
'60',
'1.20',
'1.95',
'2.40',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('4',
'80',
'1.45',
'2.15',
'2.80',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('5',
'100',
'1.75',
'2.40',
'3.20',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('6',
'200',
'3.50',
'4.10',
'5.20',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('7',
'300',
'5.40',
'5.80',
'7.20',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('8',
'400',
'6.00',
'6.40',
'8.20',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('9',
'500',
'6.30',
'6.80',
'8.50',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('10',
'750',
'8.00',
'8.50',
'10.50',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('11',
'1000',
'9.00',
'10.00',
'12.80',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('12',
'1200',
'10.00',
'11.00',
'15.80',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('13',
'1500',
'11.00',
'12.00',
'18.10',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('14',
'1750',
'12.00',
'13.00',
'19.50',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('15',
'2000',
'12.50',
'14.00',
'20.50',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('34',
'100000',
'50.00',
'60.00',
'70.00',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('31',
'4500',
'25.00',
'26.00',
'28.00',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('30',
'4000',
'25.00',
'26.00',
'28.00',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('29',
'3500',
'21.00',
'23.00',
'24.00',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
INSERT INTO `ship_price` values ('27',
'3000',
'13.00',
'15.00',
'22.00',
'0.00',
'0.00',
'0.00',
'0.00',
'0.00');
DROP TABLE IF EXISTS `specials`;
CREATE TABLE `specials` (
`specials_id` int(5) NOT NULL auto_increment,
`products_id` int(5) NOT NULL default '0',
`specials_new_price` decimal(6,2) NOT NULL default '0.00',
`specials_first_day` date NOT NULL default '0000-00-00',
`specials_last_day` date NOT NULL default '0000-00-00',
`specials_visible` enum('yes','no') default 'yes',
PRIMARY KEY (`specials_id`)
) TYPE=MyISAM;
INSERT INTO `specials` values ('86',
'103',
'8.00',
'2003-11-24',
'2010-01-01',
'yes');
INSERT INTO `specials` values ('84',
'8',
'799.20',
'2003-11-11',
'2010-01-01',
'yes');
INSERT INTO `specials` values ('85',
'98',
'20.00',
'2003-11-15',
'2010-01-01',
'yes');
INSERT INTO `specials` values ('182',
'10',
'879.12',
'2004-02-15',
'2010-01-01',
'yes');
INSERT INTO `specials` values ('72',
'57',
'19.50',
'2003-11-10',
'2010-01-01',
'yes');
INSERT INTO `specials` values ('156',
'134',
'103.50',
'2004-02-13',
'2010-01-01',
'yes');
INSERT INTO `specials` values ('157',
'126',
'90.00',
'2004-02-13',
'2010-01-01',
'yes');
DROP TABLE IF EXISTS `users_caddie`;
CREATE TABLE `users_caddie` (
`users_caddie_id` int(5) NOT NULL auto_increment,
`users_caddie_session` longtext NOT NULL,
`users_caddie_password` varchar(10) NOT NULL default '',
`users_caddie_number` varchar(10) NOT NULL default '',
`users_caddie_date` date default '0000-00-00',
PRIMARY KEY (`users_caddie_id`)
) TYPE=MyISAM;
INSERT INTO `users_caddie` values ('8',
'10+1+799.20+aeff+Adobe After Effect 5.5+5.00+',
'titi',
'ML6121',
'2003-12-26');
INSERT INTO `users_caddie` values ('9',
'28+1+30.00+star+1+19.60+,27+1+55.00+hit2+1+19.60+,137+1+90.00+adi12+1+19.60+Rouge-écru|44',
'123',
'YYPHMP',
'2004-09-30');
INSERT INTO `users_caddie` values ('10',
'28+1+25.50+star+1+19.60+',
'111',
'FVAVBE',
'2004-02-09');
INSERT INTO `users_caddie` values ('11',
'150+2+1440.00+com83+1+19.60+Intel Pentium 4 à 3.2 GHz. bus systéme à 800 MHz|Microsoft Windows XP édition familiale (SP1)|256 Mo DDR SDRAM (2x128)|80 Go Ultra DMA (7200 tpm)|Carte Video ATI Radeon 9800 Pro 128 Mo DDR|Moniteur standard 19 M992 noir|Souris PS-2 2 boutons - molette|QWERTY++,30+1+299.00+bjc+1+19.60+++,26+1+2849.05+crus+1+19.60+',
'1234',
'LCVW4Y',
'2004-03-27');
INSERT INTO `users_caddie` values ('7',
'29+0+99.00+desk++++HP DeskJet 3420+19.60,12+0+479.00+drea++++Macromedia Dreamweaver MX+19.60,10+0+799.20+aeff++++Adobe After Effect 5.5+5.00,57+0+0.00+NULL+36+Bleu+Or+Jean Lewis+19.60,57+0+0.00+NULL+41-45+Bleu+Or+Jean Lewis+19.60,18+1+45.00+lock++++Lock on+19.60,93+1+15.00+lew1+36+Bleu++Jean Lewis+19.60',
'toto',
'eee',
'2003-12-21');
INSERT INTO `users_caddie` values ('12',
'16+2+48.40+spin+1+19.60+,19+1+75.00+hit+1+19.60+',
'eeee',
'U8MVW2',
'2004-05-08');
INSERT INTO `users_caddie` values ('13',
'16+2+48.40+spin+1+19.60+++,19+1+75.00+hit+1+19.60+++,151+1+220.00+test+1+12.00+1.8 GHz|Microsoft Windows XP Professionnel.',
'222',
'AF59UR',
'2004-05-08');
INSERT INTO `users_caddie` values ('14',
'16+2+48.40+spin+1+19.60+,19+1+75.00+hit+1+19.60+,150+1+1440.00+com83+1+19.60+Intel P4 à 3 GHz. bus systéme à 800 MHz|Microsoft Windows XP édition familiale (SP1)|256 Mo DDR SDRAM (2x128)|80 Go Ultra DMA (7200 tpm)|Carte Video ATI Radeon 9800 Pro 128 Mo DDR|Moniteur standard 19 M992 noir|Souris PS-2 2 boutons - molette|QWERTY',
'qq',
'8BIUHY',
'2004-05-08');
INSERT INTO `users_caddie` values ('15',
'28+1+30.00+star+1+19.60+,27+2+55.00+hit2+1+19.60+,137+1+90.00+adi12+1+19.60+Rouge-écru|44',
'1111',
'2PIHH4',
'2004-09-30');
DROP TABLE IF EXISTS `users_orders`;
CREATE TABLE `users_orders` (
`users_id` int(5) NOT NULL auto_increment,
`users_gender` char(3) NOT NULL default '',
`users_firstname` varchar(32) NOT NULL default '',
`users_lastname` varchar(32) NOT NULL default '',
`users_address` varchar(100) NOT NULL default '',
`users_zip` varchar(10) NOT NULL default '',
`users_city` varchar(30) NOT NULL default '',
`users_surburb` varchar(20) NOT NULL default '',
`users_country` varchar(100) NOT NULL default '',
`users_date_added` datetime default '0000-00-00 00:00:00',
`users_email` varchar(96) NOT NULL default '',
`users_telephone` varchar(32) NOT NULL default '',
`users_fax` varchar(32) default NULL,
`users_password` varchar(40) NOT NULL default '',
`users_nic` varchar(20) NOT NULL default '',
`users_payment` char(2) NOT NULL default '',
`users_symbol_devise` varchar(25) NOT NULL default '',
`users_products` text NOT NULL,
`users_products_weight` decimal(7,2) NOT NULL default '0.00',
`users_products_weight_price` decimal(8,4) NOT NULL default '0.0000',
`users_total_to_pay` decimal(8,2) NOT NULL default '0.00',
`users_shipping_price` decimal(7,2) NOT NULL default '0.00',
`users_ship_ht` decimal(7,2) NOT NULL default '0.00',
`users_ship_tax` decimal(7,2) NOT NULL default '0.00',
`users_products_ht` decimal(7,2) NOT NULL default '0.00',
`users_products_tax` decimal(7,2) NOT NULL default '0.00',
`users_products_tax_statut` varchar(25) NOT NULL default '',
`users_payed` varchar(25) NOT NULL default '',
`users_statut` varchar(25) NOT NULL default '',
`users_comment` longtext NOT NULL,
`users_remise` decimal(7,2) NOT NULL default '0.00',
`users_remise_coupon` decimal(7,2) NOT NULL default '0.00',
`users_remise_coupon_name` varchar(255) NOT NULL default '',
`users_contre_remboursement` decimal(7,2) NOT NULL default '0.00',
`users_lang` char(2) NOT NULL default '',
`users_confirm` enum('yes','no') NOT NULL default 'no',
`users_facture` int(11) NOT NULL default '0',
`users_facture_adresse` text NOT NULL,
`pp_statut` varchar(50) NOT NULL default '',
`trans_id` varchar(50) NOT NULL default '',
`users_note` text NOT NULL,
`users_save_data_from_form` varchar(8) NOT NULL default 'no',
`users_shipping_note` varchar(255) NOT NULL default '',
`users_remise_note` varchar(255) NOT NULL default '',
`users_coupon_note` varchar(255) NOT NULL default '',
PRIMARY KEY (`users_id`)
) TYPE=MyISAM;