-- Table structure for table `products_images`
--

CREATE TABLE `products_images` (
  `image_id` int(11) NOT NULL AUTO_INCREMENT,
  `products_id` int(11) NOT NULL DEFAULT '0',
  `image_nr` smallint(6) NOT NULL DEFAULT '0',
  `image_name` varchar(254) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `noshop` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`image_id`),
  KEY `products_id` (`products_id`)
) ENGINE=MyISAM AUTO_INCREMENT=299 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_images`
--

INSERT INTO `products_images` (`image_id`, `products_id`, `image_nr`, `image_name`, `noshop`) VALUES (183,392,1,'392_1.jpg',0),(182,393,1,'393_1.jpg',0),(181,394,1,'394_1.jpg',0),(180,395,1,'395_1.jpg',0),(179,396,1,'396_1.jpg',0),(178,397,1,'397_1.jpg',0),(177,398,1,'398_1.jpg',0),(176,410,1,'410_1.jpg',0),(184,391,1,'391_1.jpg',0),(185,390,1,'390_1.jpg',0),(186,384,1,'384_1.jpg',0),(187,383,1,'383_1.jpg',0),(115,145,1,'145_1.jpg',0),(116,145,2,'145_2.jpg',0),(117,168,1,'168_1.jpg',0),(118,168,2,'168_2.jpg',0),(119,168,3,'168_3.jpg',0),(120,169,1,'169_1.jpg',0),(121,169,2,'169_2.jpg',0),(122,169,3,'169_3.jpg',0),(123,170,1,'170_1.jpg',0),(124,170,2,'170_2.jpg',0),(125,170,3,'170_3.jpg',0),(126,171,1,'171_1.jpg',0),(127,171,2,'171_2.jpg',0),(128,171,3,'171_3.jpg',0),(129,172,1,'172_1.jpg',0),(130,172,2,'172_2.jpg',0),(131,172,3,'172_3.jpg',0),(132,173,1,'173_1.jpg',0),(133,173,2,'173_2.jpg',0),(134,173,3,'173_3.jpg',0),(135,174,1,'174_1.jpg',0),(136,174,2,'174_2.jpg',0),(137,174,3,'174_3.jpg',0),(138,175,1,'175_1.jpg',0),(139,175,2,'175_2.jpg',0),(140,175,3,'175_3.jpg',0),(141,176,1,'176_1.jpg',0),(142,176,2,'176_2.jpg',0),(143,176,3,'176_3.jpg',0),(144,177,1,'177_1.jpg',0),(145,177,2,'177_2.jpg',0),(146,177,3,'177_3.jpg',0),(147,178,1,'178_1.jpg',0),(148,178,2,'178_2.jpg',0),(149,178,3,'178_3.jpg',0),(150,179,1,'179_1.jpg',0),(151,179,2,'179_2.jpg',0),(152,179,3,'179_3.jpg',0),(153,180,1,'180_1.jpg',0),(154,180,2,'180_2.jpg',0),(155,180,3,'180_3.jpg',0),(159,167,2,'167_2.jpg',0),(158,167,1,'167_1.jpg',0),(160,159,1,'159_1.jpg',0),(161,159,2,'159_2.jpg',0),(163,165,1,'165_1.jpg',0),(164,165,2,'165_2.jpg',0),(165,164,1,'164_1.jpg',0),(166,164,2,'164_2.jpg',0),(167,163,1,'163_1.jpg',0),(168,163,2,'163_2.jpg',0),(169,162,1,'162_1.jpg',0),(171,162,2,'162_2.jpg',0),(172,227,1,'227_1.jpg',0),(173,227,2,'227_2.jpg',0),(174,156,1,'156_1.jpg',0),(175,146,1,'146_1.jpg',0),(188,237,1,'237_1.jpg',0),(189,382,1,'382_1.jpg',0),(190,381,1,'381_1.jpg',0),(191,380,1,'380_1.jpg',0),(192,379,1,'379_1.jpg',0),(193,378,1,'378_1.jpg',0),(194,377,1,'377_1.jpg',0),(195,373,1,'373_1.jpg',0),(196,371,1,'371_1.jpg',0),(198,346,1,'346_1.jpg',0),(199,345,1,'345_1.jpg',0),(200,344,1,'344_1.jpg',0),(201,343,1,'343_1.jpg',0),(202,342,1,'342_1.jpg',0),(203,341,1,'341_1.jpg',0),(204,340,1,'340_1.jpg',0),(205,339,1,'339_1.jpg',0),(206,338,1,'338_1.jpg',0),(207,337,1,'337_1.jpg',0),(208,336,1,'336_1.jpg',0),(209,335,1,'335_1.jpg',0),(210,334,1,'334_1.jpg',0),(211,333,1,'333_1.jpg',0),(212,332,1,'332_1.jpg',0),(213,332,2,'332_2.jpg',0),(214,331,1,'331_1.jpg',0),(215,330,1,'330_1.jpg',0),(216,329,1,'329_1.jpg',0),(217,329,2,'329_2.jpg',0),(218,328,1,'328_1.jpg',0),(219,328,2,'328_2.jpg',0),(220,327,1,'327_1.jpg',0),(221,325,1,'325_1.jpg',0),(222,324,1,'324_1.jpg',0),(223,323,1,'323_1.jpg',0),(224,322,1,'322_1.jpg',0),(225,321,1,'321_1.jpg',0),(226,320,1,'320_1.jpg',0),(227,319,1,'319_1.jpg',0),(228,318,1,'318_1.jpg',0),(229,316,1,'316_1.jpg',0),(230,315,1,'315_1.jpg',0),(231,314,1,'314_1.jpg',0),(232,313,1,'313_1.jpg',0),(233,312,1,'312_1.jpg',0),(234,311,1,'311_1.jpg',0),(235,310,1,'310_1.jpg',0),(236,309,1,'309_1.jpg',0),(237,308,1,'308_1.jpg',0),(238,307,1,'307_1.jpg',0),(239,306,1,'306_1.jpg',0),(240,304,1,'304_1.jpg',0),(241,303,1,'303_1.jpg',0),(242,302,1,'302_1.jpg',0),(243,301,1,'301_1.jpg',0),(244,300,1,'300_1.jpg',0),(245,299,1,'299_1.jpg',0),(246,298,1,'298_1.jpg',0),(247,297,1,'297_1.jpg',0),(248,317,1,'317_1.jpg',0),(249,296,1,'296_1.jpg',0),(250,295,1,'295_1.jpg',0),(251,294,1,'294_1.jpg',0),(252,289,1,'289_1.jpg',0),(253,288,1,'288_1.jpg',0),(254,287,1,'287_1.jpg',0),(255,287,2,'287_2.jpg',0),(256,286,1,'286_1.jpg',0),(257,285,1,'285_1.jpg',0),(258,282,1,'282_1.jpg',0),(259,281,1,'281_1.jpg',0),(260,280,1,'280_1.jpg',0),(261,280,2,'280_2.jpg',0),(262,280,3,'280_3.jpg',0),(263,279,1,'279_1.jpg',0),(264,279,2,'279_2.jpg',0),(265,279,3,'279_3.jpg',0),(266,278,1,'278_1.jpg',0),(267,278,2,'278_2.jpg',0),(268,277,1,'277_1.jpg',0),(269,277,2,'277_2.jpg',0),(270,277,3,'277_3.jpg',0),(271,277,4,'277_4.jpg',0),(272,276,1,'276_1.jpg',0),(273,276,2,'276_2.jpg',0),(274,274,1,'274_1.jpg',0),(275,268,1,'268_1.jpg',0),(276,263,1,'263_1.jpg',0),(277,262,1,'262_1.jpg',0),(278,261,1,'261_1.jpg',0),(279,260,1,'260_1.jpg',0),(280,259,1,'259_1.jpg',0),(281,258,1,'258_1.jpg',0),(282,257,1,'257_1.jpg',0),(283,256,1,'256_1.jpg',0),(284,255,1,'255_1.jpg',0),(285,254,1,'254_1.jpg',0),(286,253,1,'253_1.jpg',0),(287,252,1,'252_1.jpg',0),(288,251,1,'251_1.jpg',0),(289,250,1,'250_1.jpg',0),(290,249,1,'249_1.jpg',0),(291,248,1,'248_1.jpg',0),(292,246,1,'246_1.jpg',0),(293,245,1,'245_1.jpg',0),(294,244,1,'244_1.jpg',0),(295,243,1,'243_1.jpg',0),(296,239,1,'239_1.jpg',0),(297,1598,1,'1598_1.jpg',0),(298,1598,2,'1598_2.jpg',0);

--
-- Table structure for table `products_master_keys`
--

CREATE TABLE `products_master_keys` (
  `products_master_keys_id` int(11) NOT NULL AUTO_INCREMENT,
  `products_id` int(11) NOT NULL,
  `sort_order` int(11) NOT NULL,
  PRIMARY KEY (`products_master_keys_id`),
  KEY `products_id` (`products_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_master_keys`
--


--
-- Table structure for table `products_master_keys_description`
--

CREATE TABLE `products_master_keys_description` (
  `products_master_keys_description_id` int(11) NOT NULL AUTO_INCREMENT,
  `products_master_keys_id` int(11) NOT NULL,
  `title` varchar(128) NOT NULL,
  `language_id` int(11) NOT NULL,
  PRIMARY KEY (`products_master_keys_description_id`),
  KEY `products_master_keys_id` (`products_master_keys_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_master_keys_description`
--


--
-- Table structure for table `products_master_slave_values`
--

CREATE TABLE `products_master_slave_values` (
  `products_master_slave_values_id` int(11) NOT NULL AUTO_INCREMENT,
  `products_master_key_id` int(11) NOT NULL,
  `products_id` int(11) NOT NULL,
  `title` varchar(128) NOT NULL,
  `language_id` int(11) NOT NULL,
  PRIMARY KEY (`products_master_slave_values_id`),
  KEY `products_master_key_id` (`products_master_key_id`),
  KEY `products_id` (`products_id`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_master_slave_values`
--


--
-- Table structure for table `products_meldebestand_customers`
--

CREATE TABLE `products_meldebestand_customers` (
  `products_meldebestand_customers_id` int(11) NOT NULL AUTO_INCREMENT,
  `products_id` int(11) NOT NULL,
  `customers_id` int(11) NOT NULL,
  PRIMARY KEY (`products_meldebestand_customers_id`),
  KEY `products_id` (`products_id`,`customers_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_meldebestand_customers`
--


--
-- Table structure for table `products_notifications`
--

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

--
-- Dumping data for table `products_notifications`
--

INSERT INTO `products_notifications` (`products_id`, `customers_id`, `date_added`) VALUES (0,4994,'2009-08-04 11:43:47'),(0,4987,'2009-11-22 17:13:48'),(0,4995,'2010-03-22 15:58:07'),(0,4996,'2010-03-25 19:49:32'),(0,4997,'2010-03-25 19:57:38'),(0,1,'2011-01-20 15:20:08');

--
-- Table structure for table `products_options`
--

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

--
-- Dumping data for table `products_options`
--


--
-- Table structure for table `products_options_values`
--

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

--
-- Dumping data for table `products_options_values`
--


--
-- Table structure for table `products_options_values_to_products_options`
--

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

--
-- Dumping data for table `products_options_values_to_products_options`
--


--
-- Table structure for table `products_properties`
--

CREATE TABLE `products_properties` (
  `products_properties_id` int(11) NOT NULL AUTO_INCREMENT,
  `products_id` int(11) NOT NULL,
  `date_added` datetime NOT NULL,
  `sort_order` int(1) NOT NULL,
  `image` varchar(16) NOT NULL,
  PRIMARY KEY (`products_properties_id`),
  KEY `products_id` (`products_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_properties`
--


--
-- Table structure for table `products_properties_description`
--

CREATE TABLE `products_properties_description` (
  `products_properties_description_id` int(11) NOT NULL AUTO_INCREMENT,
  `products_properties_id` int(11) NOT NULL,
  `language_id` int(1) NOT NULL,
  `title` varchar(64) NOT NULL,
  PRIMARY KEY (`products_properties_description_id`),
  KEY `products_properties_id` (`products_properties_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_properties_description`
--


--
-- Table structure for table `products_properties_values`
--

CREATE TABLE `products_properties_values` (
  `products_properties_values_id` int(11) NOT NULL AUTO_INCREMENT,
  `products_properties_id` int(11) NOT NULL,
  `price` decimal(15,4) NOT NULL,
  `sort_order` int(1) NOT NULL,
  `image` varchar(16) NOT NULL,
  `files_image` varchar(255) NOT NULL,
  PRIMARY KEY (`products_properties_values_id`),
  KEY `products_properties_description_id` (`products_properties_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_properties_values`
--


--
-- Table structure for table `products_properties_values_description`
--

CREATE TABLE `products_properties_values_description` (
  `products_properties_values_description_id` int(11) NOT NULL AUTO_INCREMENT,
  `products_properties_values_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `title` varchar(64) NOT NULL,
  PRIMARY KEY (`products_properties_values_description_id`),
  KEY `products_properties_description_id` (`products_properties_values_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_properties_values_description`
--


--
-- Table structure for table `products_questions`
--

CREATE TABLE `products_questions` (
  `products_questions_id` int(11) NOT NULL AUTO_INCREMENT,
  `products_id` int(11) NOT NULL,
  `customers_id` int(11) NOT NULL,
  `comments` text NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`products_questions_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_questions`
--


--
-- Table structure for table `products_serials`
--

CREATE TABLE `products_serials` (
  `products_serials_id` int(11) NOT NULL AUTO_INCREMENT,
  `products_id` int(11) NOT NULL DEFAULT '0',
  `serial_number` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `serial_status` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`products_serials_id`),
  KEY `products_id` (`products_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_serials`
--


--
-- Table structure for table `products_shipping_extra_charge`
--

CREATE TABLE `products_shipping_extra_charge` (
  `products_shipping_extra_charge_id` int(11) NOT NULL AUTO_INCREMENT,
  `products_id` int(11) NOT NULL,
  `shipping_graduation_groups_id` int(11) NOT NULL,
  `shipping_extra_charge` decimal(15,4) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`products_shipping_extra_charge_id`),
  KEY `products_id` (`products_id`),
  KEY `shipping_graduation_groups_id` (`shipping_graduation_groups_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `products_shipping_extra_charge`
--


--
-- Table structure for table `products_storages`
--

CREATE TABLE `products_storages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `products_id` int(11) NOT NULL DEFAULT '0',
  `storage_id` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `products_id` (`products_id`),
  KEY `storage_id` (`storage_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_storages`
--


--
-- Table structure for table `products_storages_history`
--

CREATE TABLE `products_storages_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `products_id` int(11) NOT NULL DEFAULT '0',
  `storage_id` int(11) NOT NULL DEFAULT '0',
  `date_saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `customers_id` int(11) NOT NULL DEFAULT '0',
  `orders_id` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `products_id` (`products_id`),
  KEY `storage_id` (`storage_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_storages_history`
--


--
-- Table structure for table `products_to_categories`
--

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

--
-- Dumping data for table `products_to_categories`
--

INSERT INTO `products_to_categories` (`products_id`, `categories_id`) VALUES (1,2),(2,2),(3,2),(4,2),(5,2),(6,2),(7,2),(8,2),(9,2),(10,2),(11,2),(12,2),(13,2),(14,2),(15,2),(111,2),(112,2),(143,31),(144,31),(145,36),(146,31),(147,31),(148,31),(149,31),(150,31),(151,31),(152,31),(153,31),(154,31),(155,31),(156,31),(157,31),(158,31),(159,31),(160,31),(161,31),(162,31),(163,31),(164,31),(165,31),(166,31),(167,31),(168,37),(169,37),(170,37),(171,37),(172,37),(173,37),(174,36),(175,36),(176,36),(177,36),(178,36),(179,36),(180,36),(181,33),(182,33),(183,33),(184,33),(185,33),(186,33),(187,33),(188,33),(189,33),(190,33),(191,33),(192,33),(193,33),(194,33),(195,33),(196,33),(197,33),(198,33),(199,33),(200,33),(201,33),(202,33),(203,33),(204,33),(205,33),(206,33),(207,33),(208,33),(209,33),(210,33),(211,33),(212,33),(213,33),(214,33),(215,33),(216,33),(217,33),(218,33),(219,33),(220,33),(221,33),(222,33),(223,33),(224,33),(225,33),(226,33),(227,33),(228,33),(229,33),(230,33),(231,33),(232,33),(233,33),(234,33),(235,33),(236,33),(237,33),(238,33),(239,38),(240,40),(241,40),(242,48),(243,38),(244,38),(245,38),(246,38),(247,38),(248,38),(249,38),(250,38),(251,38),(252,38),(253,38),(254,38),(255,38),(256,38),(257,38),(258,38),(259,38),(260,38),(261,38),(262,38),(263,38),(264,47),(265,47),(266,48),(267,48),(268,43),(269,42),(270,42),(271,42),(272,42),(273,48),(274,38),(275,38),(276,44),(277,44),(278,44),(279,44),(280,44),(281,42),(282,42),(283,42),(284,42),(285,42),(286,42),(287,47),(288,43),(289,43),(290,44),(291,44),(292,42),(293,42),(294,51),(295,51),(296,51),(297,51),(298,51),(299,51),(300,51),(301,51),(302,51),(303,51),(304,51),(305,51),(306,51),(307,38),(308,38),(309,38),(310,38),(311,38),(312,38),(313,38),(314,38),(315,38),(316,38),(317,38),(318,38),(319,38),(320,38),(321,38),(322,38),(323,38),(324,38),(325,38),(326,38),(327,38),(328,38),(329,44),(330,38),(331,44),(332,43),(333,43),(334,38),(335,43),(336,38),(337,38),(338,38),(339,38),(340,38),(341,38),(342,38),(343,38),(344,38),(345,38),(346,38),(347,40),(348,40),(349,40),(350,40),(351,48),(352,48),(353,47),(354,47),(355,47),(356,47),(357,47),(358,47),(359,47),(360,47),(361,47),(362,47),(363,47),(364,47),(365,48),(366,48),(367,48),(368,48),(369,48),(370,48),(371,48),(372,48),(373,48),(374,48),(375,48),(376,48),(377,38),(378,38),(379,38),(380,38),(381,38),(382,43),(383,38),(384,38),(385,44),(386,40),(387,40),(388,40),(389,40),(390,40),(391,40),(392,40),(393,40),(394,40),(395,40),(396,40),(397,40),(398,40),(399,40),(400,40),(401,40),(402,40),(403,40),(404,40),(405,42),(406,42),(407,42),(408,47),(409,47),(410,38),(411,42),(412,42),(413,42),(414,42),(415,42),(416,42),(417,42),(418,42),(620,45),(621,45),(622,45),(623,45),(624,45),(625,45),(626,45),(627,45),(628,45),(629,45),(630,45),(631,45),(632,45),(633,45),(634,45),(635,45),(636,45),(637,45),(638,45),(639,45),(640,45),(641,45),(642,45),(643,45),(644,45),(645,45),(646,45),(647,45),(648,45),(649,45),(650,45),(651,45),(652,45),(653,45),(654,45),(655,45),(656,45),(657,45),(658,45),(659,45),(660,45),(661,45),(662,45),(663,45),(664,45),(665,45),(666,45),(667,45),(668,45),(669,45),(670,45),(671,45),(672,45),(673,45),(674,45),(675,45),(676,45),(677,45),(678,45),(679,45),(680,45),(681,45),(682,45),(683,45),(684,45),(685,45),(686,45),(687,45),(688,45),(689,45),(690,45),(691,45),(692,45),(693,45),(694,45),(695,45),(696,45),(697,45),(698,45),(699,45),(700,45),(701,45),(702,45),(703,45),(704,45),(705,45),(706,45),(707,45),(708,45),(709,45),(710,45),(711,45),(712,45),(713,45),(714,45),(715,45),(716,45),(717,45),(718,45),(719,45),(720,45),(721,45),(722,45),(723,45),(724,45),(725,45),(726,45),(727,45),(728,45),(729,45),(730,45),(731,45),(732,45),(733,45),(734,45),(735,45),(736,45),(737,45),(738,45),(739,45),(740,45),(741,45),(742,45),(743,45),(744,45),(745,45),(746,45),(747,45),(748,45),(749,45),(750,45),(751,45),(752,45),(753,45),(754,45),(755,45),(756,45),(757,45),(758,45),(759,45),(760,45),(761,45),(762,45),(763,45),(764,45),(765,45),(766,45),(767,45),(768,45),(769,45),(770,45),(771,45),(772,45),(773,45),(774,45),(775,45),(776,45),(777,45),(778,45),(779,45),(780,45),(781,45),(782,45),(783,45),(784,45),(785,45),(786,45),(787,45),(788,45),(789,45),(790,45),(791,45),(792,45),(793,45),(794,45),(795,45),(796,45),(797,45),(798,45),(799,45),(800,45),(801,45),(802,45),(803,45),(804,45),(805,45),(806,45),(807,45),(808,45),(809,45),(810,45),(811,45),(812,45),(813,45),(814,45),(815,45),(816,45),(817,45),(818,45),(819,45),(820,45),(821,45),(822,45),(823,45),(824,45),(825,45),(826,45),(827,45),(828,45),(829,45),(830,45),(831,45),(832,45),(833,45),(834,45),(835,45),(836,45),(837,45),(838,45),(839,45),(840,45),(841,45),(842,45),(843,45),(844,45),(845,45),(846,45),(847,45),(848,45),(849,45),(850,45),(851,45),(852,45),(853,45),(854,45),(855,45),(856,45),(857,45),(858,45),(859,45),(860,45),(861,45),(862,45),(863,45),(864,45),(865,45),(866,45),(867,45),(868,45),(869,45),(870,45),(871,45),(872,45),(873,45),(874,45),(875,45),(876,45),(877,45),(878,45),(879,45),(880,45),(881,45),(882,45),(883,45),(884,45),(885,45),(886,45),(887,45),(888,45),(889,45),(890,45),(891,45),(892,45),(893,45),(894,45),(895,45),(896,45),(897,45),(898,45),(899,45),(900,45),(901,45),(902,45),(903,45),(904,45),(905,45),(906,45),(907,45),(908,45),(909,45),(910,45),(911,45),(912,45),(913,45),(914,45),(915,45),(916,45),(917,45),(918,45),(919,45),(920,45),(921,45),(922,45),(923,45),(924,45),(925,45),(926,45),(927,45),(928,45),(929,45),(930,45),(931,45),(932,45),(933,45),(934,45),(935,45),(936,45),(937,45),(938,45),(939,45),(940,45),(941,45),(942,45),(943,45),(944,45),(945,45),(946,45),(947,45),(948,45),(949,45),(950,45),(951,45),(952,45),(953,45),(954,45),(955,45),(956,45),(957,45),(958,45),(959,45),(960,45),(961,45),(962,45),(963,45),(964,45),(965,45),(966,45),(967,45),(968,45),(969,45),(970,45),(971,45),(972,45),(973,45),(974,45),(975,45),(976,45),(977,45),(978,45),(979,45),(980,45),(981,45),(982,45),(983,45),(984,45),(985,45),(986,45),(987,45),(988,45),(989,45),(990,45),(991,45),(992,45),(993,45),(994,45),(995,45),(996,45),(997,45),(998,45),(999,45),(1000,45),(1001,45),(1002,45),(1003,45),(1004,45),(1005,45),(1006,45),(1007,45),(1008,45),(1009,45),(1010,45),(1011,45),(1012,45),(1013,45),(1014,45),(1015,45),(1016,45),(1017,45),(1018,45),(1019,45),(1020,45),(1021,45),(1022,45),(1023,45),(1024,45),(1025,45),(1026,45),(1027,45),(1028,45),(1029,45),(1030,45),(1031,45),(1032,45),(1033,45),(1034,45),(1035,45),(1036,45),(1037,45),(1038,45),(1039,45),(1040,45),(1041,45),(1042,45),(1043,45),(1044,45),(1045,45),(1046,45),(1047,45),(1048,45),(1049,45),(1050,45),(1051,45),(1052,45),(1053,45),(1054,45),(1055,45),(1056,45),(1057,45),(1058,45),(1059,45),(1060,45),(1061,45),(1062,45),(1063,45),(1064,45),(1065,45),(1066,45),(1067,45),(1068,45),(1069,45),(1070,45),(1071,45),(1072,45),(1073,45),(1074,45),(1075,45),(1076,45),(1077,45),(1078,45),(1079,45),(1080,45),(1081,45),(1082,45),(1083,45),(1084,45),(1085,45),(1086,45),(1087,45),(1088,45),(1089,45),(1090,45),(1091,45),(1092,45),(1093,45),(1094,45),(1095,45),(1096,45),(1097,45),(1098,45),(1099,45),(1100,45),(1101,45),(1102,45),(1103,45),(1104,45),(1105,45),(1106,45),(1107,45),(1108,45),(1109,45),(1110,45),(1111,45),(1112,45),(1113,45),(1114,45),(1115,45),(1116,45),(1117,45),(1118,45),(1119,45),(1120,45),(1121,45),(1122,45),(1123,45),(1124,45),(1125,45),(1126,45),(1127,45),(1128,45),(1129,45),(1130,45),(1131,45),(1132,45),(1133,45),(1134,45),(1135,45),(1136,45),(1137,45),(1138,45),(1139,45),(1140,45),(1141,45),(1142,45),(1143,45),(1144,45),(1145,45),(1146,45),(1147,45),(1148,45),(1149,45),(1150,45),(1151,45),(1152,45),(1153,45),(1154,45),(1155,45),(1156,45),(1157,45),(1158,45),(1159,45),(1160,45),(1161,45),(1162,45),(1163,45),(1164,45),(1165,45),(1166,45),(1167,45),(1168,45),(1169,45),(1170,45),(1171,45),(1172,45),(1173,45),(1174,45),(1175,45),(1176,45),(1177,45),(1178,45),(1179,45),(1180,45),(1181,45),(1182,45),(1183,45),(1184,45),(1185,45),(1186,45),(1187,45),(1188,45),(1189,45),(1190,45),(1191,45),(1192,45),(1193,45),(1194,45),(1195,45),(1196,45),(1197,45),(1198,45),(1199,45),(1200,45),(1201,45),(1202,45),(1203,45),(1204,45),(1205,45),(1206,45),(1207,45),(1208,45),(1209,45),(1210,45),(1211,45),(1212,45),(1213,45),(1214,45),(1215,45),(1216,45),(1217,45),(1218,45),(1219,45),(1220,45),(1221,45),(1222,45),(1223,45),(1224,45),(1225,45),(1226,45),(1227,45),(1228,45),(1229,45),(1230,45),(1231,45),(1232,45),(1233,45),(1234,45),(1235,45),(1236,45),(1237,45),(1238,45),(1239,45),(1240,45),(1241,45),(1242,45),(1243,45),(1244,45),(1245,45),(1246,45),(1247,45),(1248,45),(1249,45),(1250,45),(1251,45),(1252,45),(1253,45),(1254,45),(1255,45),(1256,45),(1257,45),(1258,45),(1259,45),(1260,45),(1261,45),(1262,45),(1263,45),(1264,45),(1265,45),(1266,45),(1267,45),(1268,45),(1269,45),(1270,45),(1271,45),(1272,45),(1273,45),(1274,45),(1275,45),(1276,45),(1277,45),(1278,45),(1279,45),(1280,45),(1281,45),(1282,45),(1283,45),(1284,45),(1285,45),(1286,45),(1287,45),(1288,45),(1289,45),(1290,45),(1291,45),(1292,45),(1293,45),(1294,45),(1295,45),(1296,45),(1297,45),(1298,45),(1299,45),(1300,45),(1301,45),(1302,45),(1303,45),(1304,45),(1305,45),(1306,45),(1307,45),(1308,45),(1309,45),(1310,45),(1311,45),(1312,45),(1313,45),(1314,45),(1315,45),(1316,45),(1317,45),(1318,45),(1319,45),(1320,45),(1321,45),(1322,45),(1323,45),(1324,45),(1325,45),(1326,45),(1327,45),(1328,45),(1329,45),(1330,45),(1331,45),(1332,45),(1333,45),(1334,45),(1335,45),(1336,45),(1337,45),(1338,45),(1339,45),(1340,45),(1341,45),(1342,45),(1343,45),(1344,45),(1345,45),(1346,45),(1347,45),(1348,45),(1349,45),(1350,45),(1351,45),(1352,45),(1353,45),(1354,45),(1355,45),(1356,45),(1357,45),(1358,45),(1359,45),(1360,45),(1361,45),(1362,45),(1363,45),(1364,45),(1365,45),(1366,45),(1367,45),(1368,45),(1369,45),(1370,45),(1371,45),(1372,45),(1373,45),(1374,45),(1375,45),(1376,45),(1377,45),(1378,45),(1379,45),(1380,45),(1381,45),(1382,45),(1383,45),(1384,45),(1385,45),(1386,45),(1387,45),(1388,45),(1389,45),(1390,45),(1391,45),(1392,45),(1393,45),(1394,45),(1395,45),(1396,45),(1397,45),(1398,45),(1399,45),(1400,45),(1401,45),(1402,45),(1403,45),(1404,45),(1405,45),(1406,45),(1407,45),(1408,45),(1409,45),(1410,45),(1411,45),(1412,45),(1413,45),(1414,45),(1415,45),(1416,45),(1417,45),(1418,45),(1419,45),(1420,45),(1421,45),(1422,45),(1423,45),(1424,45),(1425,45),(1426,45),(1427,45),(1428,45),(1429,45),(1430,45),(1431,45),(1432,45),(1433,45),(1434,45),(1435,45),(1436,45),(1437,45),(1438,45),(1439,45),(1440,45),(1441,45),(1442,45),(1443,45),(1444,45),(1445,45),(1446,45),(1447,45),(1448,45),(1449,45),(1450,45),(1451,45),(1452,45),(1453,45),(1454,45),(1455,45),(1456,45),(1457,45),(1458,45),(1459,45),(1460,45),(1461,45),(1462,45),(1463,45),(1464,45),(1465,45),(1466,45),(1467,45),(1468,45),(1469,45),(1470,45),(1471,45),(1472,45),(1473,45),(1474,45),(1475,45),(1476,45),(1477,45),(1478,45),(1479,45),(1480,45),(1481,45),(1482,45),(1483,45),(1484,45),(1485,45),(1486,45),(1487,45),(1488,45),(1489,45),(1490,45),(1491,45),(1492,45),(1493,45),(1494,45),(1495,45),(1496,45),(1497,45),(1498,45),(1499,45),(1500,45),(1501,45),(1502,45),(1503,45),(1504,45),(1505,45),(1506,45),(1507,45),(1508,45),(1509,45),(1510,45),(1511,45),(1512,45),(1513,45),(1514,45),(1515,45),(1516,45),(1517,45),(1518,45),(1519,45),(1520,45),(1521,45),(1522,45),(1523,45),(1524,45),(1525,45),(1526,45),(1527,45),(1528,45),(1529,45),(1530,45),(1531,45),(1532,45),(1533,45),(1534,45),(1535,45),(1536,45),(1537,45),(1538,45),(1539,45),(1540,45),(1541,45),(1542,45),(1543,45),(1544,45),(1545,45),(1546,45),(1547,45),(1548,45),(1549,45),(1550,45),(1551,45),(1552,45),(1553,45),(1554,45),(1555,45),(1556,45),(1557,45),(1558,45),(1559,45),(1560,45),(1561,45),(1562,45),(1563,45),(1564,45),(1565,45),(1566,45),(1567,45),(1568,45),(1569,45),(1570,45),(1571,45),(1572,45),(1573,45),(1574,45),(1575,45),(1576,45),(1577,45),(1578,45),(1579,45),(1580,49),(1581,49),(1582,52),(1583,52),(1584,52),(1585,52),(1586,52),(1587,52),(1588,52),(1589,52),(1590,52),(1591,52),(1592,52),(1593,52),(1594,52),(1595,52),(1596,0),(1597,53),(1598,53),(1599,0);

--
-- Table structure for table `products_to_characteristics`
--

CREATE TABLE `products_to_characteristics` (
  `products_to_characteristics_id` int(11) NOT NULL AUTO_INCREMENT,
  `products_id` int(11) NOT NULL DEFAULT '0',
  `products_characteristic_set_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`products_to_characteristics_id`),
  KEY `products_id` (`products_id`),
  KEY `products_characteristic_set_id` (`products_characteristic_set_id`)
) ENGINE=MyISAM AUTO_INCREMENT=920 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_to_characteristics`
--

INSERT INTO `products_to_characteristics` (`products_to_characteristics_id`, `products_id`, `products_characteristic_set_id`) VALUES (346,143,111),(347,143,105),(348,143,109),(349,143,106),(350,143,110),(351,143,107),(335,144,112),(336,144,113),(337,144,105),(338,144,109),(339,144,110),(365,146,114),(366,146,115),(367,146,109),(368,146,106),(369,146,110),(370,146,107),(364,146,138),(371,147,111),(372,147,105),(373,147,109),(374,147,106),(375,147,110),(376,147,107),(377,148,111),(378,148,105),(379,148,109),(380,148,106),(381,148,110),(382,148,107),(383,149,111),(384,149,105),(385,149,109),(386,149,106),(387,149,110),(388,149,107),(431,150,111),(432,150,148),(433,150,106),(434,150,110),(435,150,107),(440,151,141),(441,151,148),(442,151,106),(443,151,110),(444,152,146),(445,152,148),(446,152,110),(447,152,107),(454,153,143),(455,153,149),(456,153,109),(457,153,106),(458,153,110),(459,153,107),(460,154,141),(461,154,149),(462,154,109),(463,154,106),(464,154,110),(471,156,138),(465,155,144),(466,155,150),(467,155,109),(468,155,106),(469,155,110),(470,155,107),(472,156,145),(473,156,150),(474,156,109),(475,156,106),(476,156,110),(482,157,149),(483,157,109),(484,157,110),(485,157,107),(481,157,143),(486,160,152),(487,160,115),(488,160,109),(489,160,106),(490,160,110),(491,160,107),(498,161,115),(499,161,109),(500,161,106),(501,161,110),(502,161,107),(497,161,153),(508,164,156),(509,164,106),(510,164,110),(506,164,154),(507,164,155),(511,165,157),(512,165,155),(513,165,156),(514,165,106),(515,165,110),(516,165,107),(517,166,157),(518,166,155),(519,166,156),(520,166,106),(521,166,110),(522,166,107),(523,167,112),(524,167,158),(525,167,155),(526,167,156),(527,167,110),(528,168,172),(529,168,161),(530,168,162),(531,168,165),(532,168,170),(533,168,159),(534,168,160),(535,168,168),(536,168,164),(537,168,171),(545,169,159),(546,169,160),(547,169,162),(548,169,161),(549,169,164),(553,169,171),(554,169,172),(550,169,173),(551,169,174),(552,169,175),(563,170,159),(564,170,160),(566,170,161),(567,170,164),(568,170,165),(569,170,168),(570,170,170),(571,170,171),(565,170,176),(572,170,177),(573,171,159),(574,171,160),(575,171,176),(576,171,161),(577,171,164),(578,171,173),(579,171,174),(580,171,175),(581,171,171),(582,171,177),(583,172,178),(584,172,160),(585,172,162),(586,172,179),(587,172,163),(588,172,166),(589,172,180),(590,172,169),(591,172,171),(592,172,172),(593,173,178),(594,173,160),(595,173,176),(596,173,179),(597,173,163),(598,173,166),(599,173,180),(600,173,169),(601,173,171),(602,173,177),(609,174,181),(610,174,182),(612,174,174),(613,174,175),(614,174,183),(615,174,177),(611,174,184),(616,177,187),(617,177,182),(618,177,166),(619,177,186),(620,177,169),(621,177,183),(622,175,185),(623,175,182),(624,175,166),(625,175,186),(626,175,169),(627,175,183),(628,178,188),(629,178,182),(630,178,166),(631,178,180),(632,178,169),(633,178,183),(634,178,177),(635,179,189),(636,179,182),(637,179,166),(638,179,180),(639,179,169),(640,179,183),(641,180,190),(642,180,182),(643,180,166),(644,180,169),(645,180,183),(653,382,194),(654,289,194),(655,288,194),(656,268,194),(696,375,194),(695,376,194),(692,242,194),(697,374,194),(698,373,194),(699,372,194),(700,371,194),(701,370,194),(702,369,194),(703,368,194),(704,367,194),(705,366,194),(706,365,194),(709,352,194),(710,351,194),(711,273,194),(712,267,194),(713,266,194),(726,385,194),(748,283,194),(747,284,194),(727,291,194),(728,290,194),(746,285,194),(745,286,194),(749,282,194),(750,281,194),(751,272,194),(752,271,194),(780,404,194),(781,403,194),(782,402,194),(783,401,194),(784,400,194),(785,399,194),(786,398,194),(787,397,194),(788,396,194),(789,395,194),(790,394,194),(791,393,194),(792,392,194),(793,391,194),(794,390,194),(795,389,194),(796,388,194),(797,387,194),(798,386,194),(799,350,194),(800,349,194),(801,348,194),(802,347,194),(803,241,194),(804,240,194),(815,418,194),(816,417,194),(817,416,194),(818,415,194),(819,414,194),(820,413,194),(821,412,194),(822,411,194),(823,293,194),(824,292,194),(830,410,194),(831,384,194),(832,383,194),(833,381,194),(834,380,194),(835,379,194),(897,378,194),(898,377,194),(899,274,194),(900,263,194),(901,262,194),(902,261,194),(903,260,194),(904,259,194),(905,258,194),(906,257,194),(907,256,194),(908,255,194),(909,254,194),(910,253,194),(911,252,194),(912,251,194),(913,250,194),(914,249,194),(915,248,194),(916,247,194),(917,246,194),(918,245,194),(919,244,194),(895,243,194),(896,239,194);

--
-- Table structure for table `products_to_groups`
--

CREATE TABLE `products_to_groups` (
  `products_id` int(11) NOT NULL DEFAULT '0',
  `groups_id` int(11) NOT NULL DEFAULT '0',
  KEY `products_id` (`products_id`),
  KEY `groups_id` (`groups_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_to_groups`
--


--
-- Table structure for table `products_vpe`
--

CREATE TABLE `products_vpe` (
  `products_vpe_id` int(11) NOT NULL DEFAULT '0',
  `language_id` int(11) NOT NULL DEFAULT '0',
  `products_vpe_name` varchar(32) NOT NULL,
  KEY `language_id` (`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_vpe`
--


--
-- Table structure for table `products_xsell`
--

CREATE TABLE `products_xsell` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `products_id` int(10) unsigned NOT NULL DEFAULT '1',
  `xsell_id` int(10) unsigned NOT NULL DEFAULT '1',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '1',
  `reverse_cross_selling` int(1) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `products_id` (`products_id`),
  KEY `xsell_id` (`xsell_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products_xsell`
--


--
-- Table structure for table `push_customer_allocations`
--

CREATE TABLE `push_customer_allocations` (
  `push_customer_allocations_id` int(11) NOT NULL AUTO_INCREMENT,
  `customers_id` int(11) NOT NULL,
  `allocation` varchar(16) NOT NULL,
  PRIMARY KEY (`push_customer_allocations_id`),
  KEY `customers_id` (`customers_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `push_customer_allocations`
--


--
-- Table structure for table `push_subscriber`
--

CREATE TABLE `push_subscriber` (
  `push_subscriber_id` int(11) NOT NULL AUTO_INCREMENT,
  `customers_id` int(11) NOT NULL,
  `endpoint` varchar(255) NOT NULL,
  `publicKey` varchar(255) NOT NULL,
  `token` varchar(128) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`push_subscriber_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `push_subscriber`
--


--
-- Table structure for table `quick_login`
--

CREATE TABLE `quick_login` (
  `quick_login_id` int(11) NOT NULL AUTO_INCREMENT,
  `customers_id` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `quick_login_sessionid` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `number_of_logins` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`quick_login_id`),
  KEY `customers_id` (`customers_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `quick_login`
--


--
-- Table structure for table `reclamations`
--

CREATE TABLE `reclamations` (
  `reclamations_id` int(11) NOT NULL AUTO_INCREMENT,
  `orders_id` int(11) NOT NULL DEFAULT '0',
  `customers_id` int(11) NOT NULL DEFAULT '0',
  `ebay_id` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `customers_cid` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `customers_vat_id` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `customers_status` int(11) DEFAULT NULL,
  `customers_status_name` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `customers_status_image` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `customers_status_discount` decimal(4,2) DEFAULT NULL,
  `customers_name` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `customers_company` varchar(128) DEFAULT NULL,
  `customers_street_address` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `customers_suburb` varchar(64) DEFAULT NULL,
  `customers_city` varchar(64) NOT NULL,
  `customers_postcode` varchar(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `customers_state` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `customers_country` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `customers_telephone` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `customers_email_address` varchar(96) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `customers_address_format_id` int(5) NOT NULL DEFAULT '0',
  `delivery_name` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `delivery_company` varchar(128) DEFAULT NULL,
  `delivery_street_address` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `delivery_suburb` varchar(64) DEFAULT NULL,
  `delivery_city` varchar(64) NOT NULL,
  `delivery_postcode` varchar(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `delivery_state` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `delivery_country` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `delivery_address_format_id` int(5) NOT NULL DEFAULT '0',
  `billing_name` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `billing_company` varchar(128) DEFAULT NULL,
  `billing_street_address` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `billing_suburb` varchar(64) DEFAULT NULL,
  `billing_city` varchar(64) NOT NULL,
  `billing_postcode` varchar(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `billing_state` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `billing_country` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `billing_address_format_id` int(5) NOT NULL DEFAULT '0',
  `payment_method` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `comments` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL,
  `date_created` datetime DEFAULT NULL,
  `date_payment` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `reclamations_status` int(5) NOT NULL DEFAULT '0',
  `reclamations_type` int(11) NOT NULL DEFAULT '0',
  `reclamations_date_finished` datetime DEFAULT NULL,
  `currency` char(3) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `currency_value` decimal(14,6) DEFAULT NULL,
  `account_type` int(1) NOT NULL DEFAULT '0',
  `language` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `versender` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `rueckerstattung` int(11) NOT NULL DEFAULT '0',
  `send` int(1) NOT NULL DEFAULT '0',
  `send_status` int(1) NOT NULL DEFAULT '0',
  `repair` int(1) NOT NULL DEFAULT '0',
  `kto_nummer` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `kto_inhaber` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `kto_blz` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `kto_bank` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `rueckerstattungsbetrag` float NOT NULL DEFAULT '0',
  `rueckerstattungsgrund` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `block_shipping` int(1) NOT NULL DEFAULT '0',
  `versender_proposal` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `shipping_comments` text NOT NULL,
  PRIMARY KEY (`reclamations_id`),
  KEY `orders_id` (`orders_id`),
  KEY `customers_id` (`customers_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reclamations`
--

INSERT INTO `reclamations` (`reclamations_id`, `orders_id`, `customers_id`, `ebay_id`, `customers_cid`, `customers_vat_id`, `customers_status`, `customers_status_name`, `customers_status_image`, `customers_status_discount`, `customers_name`, `customers_company`, `customers_street_address`, `customers_suburb`, `customers_city`, `customers_postcode`, `customers_state`, `customers_country`, `customers_telephone`, `customers_email_address`, `customers_address_format_id`, `delivery_name`, `delivery_company`, `delivery_street_address`, `delivery_suburb`, `delivery_city`, `delivery_postcode`, `delivery_state`, `delivery_country`, `delivery_address_format_id`, `billing_name`, `billing_company`, `billing_street_address`, `billing_suburb`, `billing_city`, `billing_postcode`, `billing_state`, `billing_country`, `billing_address_format_id`, `payment_method`, `comments`, `last_modified`, `date_created`, `date_payment`, `reclamations_status`, `reclamations_type`, `reclamations_date_finished`, `currency`, `currency_value`, `account_type`, `language`, `versender`, `rueckerstattung`, `send`, `send_status`, `repair`, `kto_nummer`, `kto_inhaber`, `kto_blz`, `kto_bank`, `rueckerstattungsbetrag`, `rueckerstattungsgrund`, `block_shipping`, `versender_proposal`, `shipping_comments`) VALUES (1,13,4997,'','','',2,'PRIVATER KUNDE','customer_status.gif',0.00,'Testkunde2 Testkunde2nachname','','teststr. 4','','Hamburg','12345',NULL,'Germany','','Testkunde2@yes4trade.de',5,'Testkunde2 Testkunde2nachname','','teststr. 4','','Hamburg','12345',NULL,'Germany',5,'Testkunde2 Testkunde2nachname','','teststr. 4','','Hamburg','12345',NULL,'Germany',5,'moneyorder',NULL,'2010-03-25 22:21:47','2010-03-25 22:13:04','0000-00-00 00:00:00',3,4,NULL,'EUR',0.000000,0,'german','DPD',0,1,2,0,'','','','',0,'',0,'',''),(2,19,1,'','','',0,'Admin','admin_status.gif',0.00,'YES System','','Gasstrasse 18','','Hamburg','22761',NULL,'Germany','','system@yes-websolutions.de',5,'YES System','','Gasstrasse 18','','Hamburg','22761',NULL,'Germany',5,'YES System','','Gasstrasse 18','','Hamburg','22761',NULL,'Germany',5,'bar_kasse',NULL,'2013-11-06 17:27:01','2013-11-06 17:27:01','0000-00-00 00:00:00',3,2,NULL,'EUR',0.000000,0,'german','Post',0,0,0,0,'','','','',0,'',0,'','');

--
-- Table structure for table `reclamations_bestandssperre`
--

CREATE TABLE `reclamations_bestandssperre` (
  `reclamations_bestandssperre_id` int(11) NOT NULL AUTO_INCREMENT,
  `reclamations_id` int(11) NOT NULL DEFAULT '0',
  `products_id` int(11) NOT NULL DEFAULT '0',
  `storage_id` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`reclamations_bestandssperre_id`),
  KEY `reclamations_id` (`reclamations_id`),
  KEY `products_id` (`products_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reclamations_bestandssperre`
--


--
-- Table structure for table `reclamations_products`
--

CREATE TABLE `reclamations_products` (
  `reclamations_products_id` int(11) NOT NULL AUTO_INCREMENT,
  `reclamations_id` int(11) NOT NULL DEFAULT '0',
  `products_id` int(11) NOT NULL DEFAULT '0',
  `products_model` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `products_name` varchar(128) NOT NULL DEFAULT '',
  `products_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `products_discount_made` decimal(4,2) DEFAULT NULL,
  `final_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `products_tax` decimal(7,4) NOT NULL DEFAULT '0.0000',
  `products_quantity` int(2) NOT NULL DEFAULT '0',
  `allow_tax` int(1) NOT NULL DEFAULT '0',
  `false_products_id` int(11) NOT NULL,
  PRIMARY KEY (`reclamations_products_id`),
  KEY `reclamations_id` (`reclamations_id`),
  KEY `products_id` (`products_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reclamations_products`
--

INSERT INTO `reclamations_products` (`reclamations_products_id`, `reclamations_id`, `products_id`, `products_model`, `products_name`, `products_price`, `products_discount_made`, `final_price`, `products_tax`, `products_quantity`, `allow_tax`, `false_products_id`) VALUES (1,1,93,'1111','Testhandy 1',0.0000,0.00,0.0000,0.0000,1,1,0),(2,2,113,'','Teststuhl mit Artikeleigenschaftenn',0.0000,0.00,0.0000,0.0000,1,1,0);

--
-- Table structure for table `reclamations_products_properties`
--

CREATE TABLE `reclamations_products_properties` (
  `reclamations_products_properties_id` int(11) NOT NULL AUTO_INCREMENT,
  `reclamations_products_id` int(11) NOT NULL,
  `property_title` varchar(64) NOT NULL,
  `property_value` varchar(64) NOT NULL,
  PRIMARY KEY (`reclamations_products_properties_id`),
  KEY `reclamations_products_id` (`reclamations_products_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reclamations_products_properties`
--

INSERT INTO `reclamations_products_properties` (`reclamations_products_properties_id`, `reclamations_products_id`, `property_title`, `property_value`) VALUES (1,2,'Farbe','Gold'),(2,2,'Material','Edelstahl');

--
-- Table structure for table `reclamations_products_serials`
--

CREATE TABLE `reclamations_products_serials` (
  `reclamations_products_serials_id` int(11) NOT NULL AUTO_INCREMENT,
  `reclamations_products_id` int(11) NOT NULL DEFAULT '0',
  `products_id` int(11) NOT NULL DEFAULT '0',
  `serial_number` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`reclamations_products_serials_id`),
  KEY `reclamations_products_id` (`reclamations_products_id`),
  KEY `products_id` (`products_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reclamations_products_serials`
--


--
-- Table structure for table `reclamations_reasons`
--

CREATE TABLE `reclamations_reasons` (
  `reclamations_reasons_id` int(11) NOT NULL AUTO_INCREMENT,
  `reason` varchar(64) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`reclamations_reasons_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reclamations_reasons`
--

INSERT INTO `reclamations_reasons` (`reclamations_reasons_id`, `reason`, `date_added`) VALUES (1,'Transportschaden','2010-11-24 22:45:15'),(2,'Ware hat nicht gefallen','2010-11-24 22:45:24'),(3,'Qualitätsproblem','2010-11-24 22:45:46'),(4,'Durch Kunden beim aufbau beschädigt','2010-11-24 22:46:01');

--
-- Table structure for table `reclamations_recalculate`
--

CREATE TABLE `reclamations_recalculate` (
  `reclamations_recalculate_id` int(11) NOT NULL AUTO_INCREMENT,
  `reclamations_id` int(11) NOT NULL DEFAULT '0',
  `n_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `b_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `tax` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `tax_rate` decimal(7,4) NOT NULL DEFAULT '0.0000',
  `class` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`reclamations_recalculate_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reclamations_recalculate`
--


--
-- Table structure for table `reclamations_status`
--

CREATE TABLE `reclamations_status` (
  `reclamations_status_id` int(11) NOT NULL DEFAULT '0',
  `language_id` int(11) NOT NULL DEFAULT '1',
  `reclamations_status_name` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`reclamations_status_id`,`language_id`),
  KEY `reclamations_status_name` (`reclamations_status_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reclamations_status`
--

INSERT INTO `reclamations_status` (`reclamations_status_id`, `language_id`, `reclamations_status_name`) VALUES (3,2,'Abgeschlossen'),(1,2,'Eingeleitet'),(2,2,'In Bearbeitung');

--
-- Table structure for table `reclamations_status_history`
--

CREATE TABLE `reclamations_status_history` (
  `reclamations_status_history_id` int(11) NOT NULL AUTO_INCREMENT,
  `reclamations_id` int(11) NOT NULL DEFAULT '0',
  `reclamations_status_id` int(5) NOT NULL DEFAULT '0',
  `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `customer_notified` int(1) DEFAULT '0',
  `comments` text CHARACTER SET latin1 COLLATE latin1_general_ci,
  `editor_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`reclamations_status_history_id`),
  KEY `reclamations_id` (`reclamations_id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reclamations_status_history`
--

INSERT INTO `reclamations_status_history` (`reclamations_status_history_id`, `reclamations_id`, `reclamations_status_id`, `date_added`, `customer_notified`, `comments`, `editor_id`) VALUES (1,1,1,'2006-03-03 12:31:30',0,'Colli 8 aus Produkt 14 mit 1 gespeichert; --',4457),(2,1,1,'2006-03-03 12:32:07',0,'Vom Versand ausgeschlossen: Muss nochmal versand zahlen',4457),(3,1,1,'2010-03-25 22:13:04',0,'Die Retoure 1 wurde angelegt.',1),(4,1,1,'2010-03-25 22:13:04',0,'Angelegt: ',1),(5,1,1,'2010-03-25 22:13:28',0,'Im Versandmodul verfuegbar gemacht.',1),(6,1,1,'2010-03-25 22:15:30',0,'Ware ging über Post in den Versand.',1),(7,1,2,'2010-03-25 22:21:32',0,'Statusaenderung zu In Bearbeitung: Prüfung',1),(8,1,3,'2010-03-25 22:21:47',0,'Statusaenderung zu Abgeschlossen: In Ordnung',1),(9,1,3,'2010-03-25 22:25:27',0,'Die Retoure 1 hat neuen Status Abholung angewiesen',1),(10,1,3,'2010-03-25 22:25:41',0,'Der Wareneingang der Retoure 1 wurde gebucht.',1),(11,1,3,'2010-03-25 22:25:41',0,'Die Retoure 1 hat neuen Status Beendet',1),(12,2,3,'2013-11-06 17:27:01',0,'Die Retoure 2 wurde angelegt.',1),(13,2,3,'2013-11-06 17:27:01',0,'Die Rueckerstattung (Bar) 2 wurde angelegt.',1),(14,2,3,'2013-11-06 17:27:01',0,'Angelegt: ',1),(15,2,3,'2013-11-06 17:27:49',0,'Die Retoure 2 hat neuen Status Abholung angewiesen',1);

--
-- Table structure for table `reclamations_to_reclamations_reasons`
--

CREATE TABLE `reclamations_to_reclamations_reasons` (
  `reclamations_id` int(11) NOT NULL,
  `reclamations_reasons_id` int(11) NOT NULL,
  KEY `reclamations_id` (`reclamations_id`),
  KEY `reclamations_reasons_id` (`reclamations_reasons_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reclamations_to_reclamations_reasons`
--

INSERT INTO `reclamations_to_reclamations_reasons` (`reclamations_id`, `reclamations_reasons_id`) VALUES (2,2);

--
-- Table structure for table `reclamations_total`
--

CREATE TABLE `reclamations_total` (
  `reclamations_total_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reclamations_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `text` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `value` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `class` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `sort_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`reclamations_total_id`),
  KEY `reclamations_id` (`reclamations_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reclamations_total`
--

INSERT INTO `reclamations_total` (`reclamations_total_id`, `reclamations_id`, `title`, `text`, `value`, `class`, `sort_order`) VALUES (1,1,'Zwischensumme','0,00 EUR',0.0000,'ot_subtotal',0),(2,1,'Enth. MwSt. 19,00%','1.76 EUR',1.7563,'ot_tax',10),(3,1,'Versandkosten','1.00 EUR',1.0000,'ot_shippings',20),(4,1,'Transportkosten','10.00 EUR',10.0000,'ot_transport',23),(5,1,'<b>Gesamtbetrag</b>','11.00 EUR',1.0000,'ot_total',50),(6,2,'Zwischensumme','0,00 EUR',0.0000,'ot_subtotal',0),(7,2,'<b>Gesamtbetrag</b>','0.00 EUR',0.0000,'ot_total',50);

--
-- Table structure for table `reclamations_types`
--

CREATE TABLE `reclamations_types` (
  `reclamations_types_id` int(11) NOT NULL AUTO_INCREMENT,
  `reclamations_types_title` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`reclamations_types_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reclamations_types`
--

INSERT INTO `reclamations_types` (`reclamations_types_id`, `reclamations_types_title`) VALUES (2,'Widerruf | Ruecktritt'),(3,'Defekt | Ersatzversand'),(4,'Falschlieferung | Neuversand'),(5,'Falsche Adresse | Neuversand'),(6,'Vereinfachte Warenrücknahme');

--
-- Table structure for table `retoure_products`
--

CREATE TABLE `retoure_products` (
  `retoure_products_id` int(11) NOT NULL AUTO_INCREMENT,
  `retoure_id` int(11) NOT NULL DEFAULT '0',
  `products_id` int(11) NOT NULL DEFAULT '0',
  `products_model` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `products_name` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `products_quantity` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`retoure_products_id`),
  KEY `retoure_id` (`retoure_id`),
  KEY `products_id` (`products_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `retoure_products`
--

INSERT INTO `retoure_products` (`retoure_products_id`, `retoure_id`, `products_id`, `products_model`, `products_name`, `products_quantity`) VALUES (1,1,93,'1111','Testhandy 1',1),(2,2,113,'','Teststuhl mit Artikeleigenschaftenn',1);

--
-- Table structure for table `retoure_products_properties`
--

CREATE TABLE `retoure_products_properties` (
  `retoure_products_properties_id` int(11) NOT NULL AUTO_INCREMENT,
  `retoure_products_id` int(11) NOT NULL,
  `property_title` varchar(64) NOT NULL,
  `property_value` varchar(64) NOT NULL,
  PRIMARY KEY (`retoure_products_properties_id`),
  KEY `retoure_products_id` (`retoure_products_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `retoure_products_properties`
--

INSERT INTO `retoure_products_properties` (`retoure_products_properties_id`, `retoure_products_id`, `property_title`, `property_value`) VALUES (1,2,'Farbe','Gold'),(2,2,'Material','Edelstahl');

--
-- Table structure for table `retoure_products_serials`
--

CREATE TABLE `retoure_products_serials` (
  `retoure_products_serials_id` int(11) NOT NULL AUTO_INCREMENT,
  `retoure_products_id` int(11) NOT NULL DEFAULT '0',
  `products_id` int(11) NOT NULL DEFAULT '0',
  `serial_number` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`retoure_products_serials_id`),
  KEY `retoure_products_id` (`retoure_products_id`),
  KEY `products_id` (`products_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `retoure_products_serials`
--


--
-- Table structure for table `retoure_status`
--

CREATE TABLE `retoure_status` (
  `retoure_status_id` int(11) NOT NULL AUTO_INCREMENT,
  `retoure_status_name` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`retoure_status_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `retoure_status`
--

INSERT INTO `retoure_status` (`retoure_status_id`, `retoure_status_name`) VALUES (1,'Angelegt'),(2,'Abholung angewiesen'),(3,'Beendet'),(4,'Fehlgeschlagen');

--
-- Table structure for table `retoure_status_history`
--

CREATE TABLE `retoure_status_history` (
  `retoure_status_history_id` int(11) NOT NULL AUTO_INCREMENT,
  `retoure_id` int(11) NOT NULL DEFAULT '0',
  `retoure_status_id` int(5) NOT NULL DEFAULT '0',
  `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `customer_notified` int(1) DEFAULT '0',
  `comments` text CHARACTER SET latin1 COLLATE latin1_general_ci,
  `editor_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`retoure_status_history_id`),
  KEY `retoure_id` (`retoure_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `retoure_status_history`
--

INSERT INTO `retoure_status_history` (`retoure_status_history_id`, `retoure_id`, `retoure_status_id`, `date_added`, `customer_notified`, `comments`, `editor_id`) VALUES (1,1,1,'2010-03-25 22:13:04',0,'Aus der Reklamation 1 heraus angelegt.',1),(2,1,2,'2010-03-25 22:25:27',0,'Neuer Status. Keine Retoureinfo per Email versendet',1),(3,1,2,'2010-03-25 22:25:41',0,'Wareneingang wurde gebucht.',1),(4,1,3,'2010-03-25 22:25:41',0,'Auf neuen Status gesetzt.',1),(5,2,1,'2013-11-06 17:27:01',0,'Aus der Reklamation 2 heraus angelegt.',1),(6,2,2,'2013-11-06 17:27:49',1,'Retoureinfo per Email an system@yes-websolutions.de versendet',1);

--
-- Table structure for table `retouren`
--

CREATE TABLE `retouren` (
  `retoure_id` int(11) NOT NULL AUTO_INCREMENT,
  `orders_id` int(11) NOT NULL DEFAULT '0',
  `reclamations_id` int(11) NOT NULL DEFAULT '0',
  `customers_id` int(11) NOT NULL DEFAULT '0',
  `shipping_company` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `shipping_name` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `shipping_name2` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `shipping_street` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `shipping_street2` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `shipping_postcode` varchar(6) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `shipping_city` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `shipping_country` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_initiated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_finished` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `retoure_status` int(11) NOT NULL DEFAULT '0',
  `versender` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `costs` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`retoure_id`),
  KEY `orders_id` (`orders_id`),
  KEY `reclamations_id` (`reclamations_id`),
  KEY `customers_id` (`customers_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `retouren`
--

INSERT INTO `retouren` (`retoure_id`, `orders_id`, `reclamations_id`, `customers_id`, `shipping_company`, `shipping_name`, `shipping_name2`, `shipping_street`, `shipping_street2`, `shipping_postcode`, `shipping_city`, `shipping_country`, `date_created`, `date_initiated`, `date_finished`, `retoure_status`, `versender`, `costs`) VALUES (1,13,1,4997,'','Testkunde2 Testkunde2nachname','','teststr. 4','','12345','Hamburg','Germany','2010-03-25 22:13:04','2010-03-25 22:25:27','2010-03-25 22:25:41',3,'DPD',10),(2,19,2,1,'','YES System','','Gasstrasse 18','','22761','Hamburg','Germany','2013-11-06 17:27:01','2013-11-06 17:27:48','0000-00-00 00:00:00',2,'Post',0);

--
-- Table structure for table `reviews`
--

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

--
-- Dumping data for table `reviews`
--


--
-- Table structure for table `reviews_description`
--

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

--
-- Dumping data for table `reviews_description`
--


--
-- Table structure for table `rueckerstattungen`
--

CREATE TABLE `rueckerstattungen` (
  `rueckerstattungs_id` int(11) NOT NULL AUTO_INCREMENT,
  `orders_id` int(11) NOT NULL DEFAULT '0',
  `customers_id` int(11) NOT NULL DEFAULT '0',
  `reclamations_id` int(11) NOT NULL DEFAULT '0',
  `betrag` float NOT NULL DEFAULT '0',
  `paymode` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_payment` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `kto_nummer` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `kto_blz` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `kto_inhaber` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `comments` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `editor_id` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT '0',
  `kto_grund` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `kto_bank` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `kto_iban` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `kto_swift` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `billsafe_tax_rate` float NOT NULL,
  PRIMARY KEY (`rueckerstattungs_id`),
  KEY `orders_id` (`orders_id`),
  KEY `customers_id` (`customers_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rueckerstattungen`
--

INSERT INTO `rueckerstattungen` (`rueckerstattungs_id`, `orders_id`, `customers_id`, `reclamations_id`, `betrag`, `paymode`, `date_created`, `date_payment`, `kto_nummer`, `kto_blz`, `kto_inhaber`, `comments`, `editor_id`, `status`, `type`, `kto_grund`, `kto_bank`, `kto_iban`, `kto_swift`, `billsafe_tax_rate`) VALUES (1,7,4987,0,5,'Bank','2010-03-25 19:36:29','0000-00-00 00:00:00','','','','Rueckerstattung nach Storno',1,1,2,'','','','',0),(2,19,1,2,31,'Bar','2013-11-06 17:27:01','2013-11-06 17:27:01','','','','Rueckerstattung bei Reklamation Bar',1,2,3,'','','','',0);

--
-- Table structure for table `rueckerstattungen_status`
--

CREATE TABLE `rueckerstattungen_status` (
  `rueckerstattungen_status_id` int(11) NOT NULL AUTO_INCREMENT,
  `rueckerstattungen_status_title` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`rueckerstattungen_status_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rueckerstattungen_status`
--

INSERT INTO `rueckerstattungen_status` (`rueckerstattungen_status_id`, `rueckerstattungen_status_title`) VALUES (1,'Offen'),(2,'Ueberwiesen'),(3,'Keine Rueckerstattung'),(4,'In Bearbeitung');

--
-- Table structure for table `rueckerstattungen_status_history`
--

CREATE TABLE `rueckerstattungen_status_history` (
  `rueckerstattungen_status_history_id` int(11) NOT NULL AUTO_INCREMENT,
  `rueckerstattungen_id` int(11) NOT NULL DEFAULT '0',
  `rueckerstattungen_status_id` int(5) NOT NULL DEFAULT '0',
  `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `customer_notified` int(1) DEFAULT '0',
  `comments` text CHARACTER SET latin1 COLLATE latin1_general_ci,
  `editor_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rueckerstattungen_status_history_id`),
  KEY `rueckerstattungen_id` (`rueckerstattungen_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rueckerstattungen_status_history`
--

INSERT INTO `rueckerstattungen_status_history` (`rueckerstattungen_status_history_id`, `rueckerstattungen_id`, `rueckerstattungen_status_id`, `date_added`, `customer_notified`, `comments`, `editor_id`) VALUES (1,1,1,'2010-03-25 19:36:29',0,'Aus Stornierung der Rechnung 7 heraus angelegt.',1),(2,2,2,'2013-11-06 17:27:01',0,'Aus Reklamation 2 heraus angelegt (Bar).',1);

--
-- Table structure for table `rueckerstattungen_types`
--

CREATE TABLE `rueckerstattungen_types` (
  `rueckerstattungen_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `rueckerstattungen_type_title` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`rueckerstattungen_type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rueckerstattungen_types`
--

INSERT INTO `rueckerstattungen_types` (`rueckerstattungen_type_id`, `rueckerstattungen_type_title`) VALUES (1,'Keine Rückerstattung'),(2,'Bank/Überweisung'),(3,'Bar'),(4,'Paypal'),(5,'Kreditkarte'),(6,'Amazon'),(7,'Secupay');

--
-- Table structure for table `search_allocations`
--

CREATE TABLE `search_allocations` (
  `word` varchar(32) NOT NULL,
  `pid` text NOT NULL,
  `language_id` int(1) NOT NULL,
  KEY `word` (`word`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `search_allocations`
--


--
-- Table structure for table `secupay_history_inv`
--

CREATE TABLE `secupay_history_inv` (
  `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `req_data` text,
  `ret_data` text,
  `payment_method` varchar(255) DEFAULT NULL,
  `hash` char(40) DEFAULT NULL,
  `transaction_id` int(10) unsigned DEFAULT NULL,
  `ordernr` int(11) DEFAULT NULL,
  `msg` varchar(255) DEFAULT NULL,
  `rank` int(10) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `action` text,
  `created` datetime NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`log_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `secupay_history_inv`
--

INSERT INTO `secupay_history_inv` (`log_id`, `req_data`, `ret_data`, `payment_method`, `hash`, `transaction_id`, `ordernr`, `msg`, `rank`, `status`, `amount`, `action`, `created`, `timestamp`) VALUES (1,'','{\"status\":\"ok\",\"data\":{\"hash\":\"mqumlcxblzog2634813\",\"iframe_url\":\"https:\\/\\/api.secupay.ag\\/payment\\/mqumlcxblzog2634813\"},\"errors\":null}','secupay_inv_xtc','mqumlcxblzog2634813',0,NULL,'',NULL,'ok','34855','','2018-01-31 07:48:42','2018-01-31 06:48:42'),(2,'','{\"status\":\"ok\",\"data\":{\"hash\":\"mmhtmycxvgsp2791620\",\"iframe_url\":\"https:\\/\\/api.secupay.ag\\/payment\\/mmhtmycxvgsp2791620\"},\"errors\":null}','secupay_inv_xtc','mmhtmycxvgsp2791620',0,5009,'',NULL,'ok','8187','','2018-04-13 17:43:14','2018-04-13 15:43:56'),(3,'','{\"status\":\"ok\",\"data\":{\"hash\":\"gvwzztgjnsya2892940\",\"iframe_url\":\"https:\\/\\/api.secupay.ag\\/payment\\/gvwzztgjnsya2892940\"},\"errors\":null}','secupay_inv_xtc','gvwzztgjnsya2892940',0,5010,'',NULL,'ok','7449','','2018-05-26 17:26:51','2018-05-26 15:27:38'),(4,'','{\"status\":\"ok\",\"data\":{\"hash\":\"tpsflvgfixxs3015964\",\"iframe_url\":\"https:\\/\\/api.secupay.ag\\/payment\\/tpsflvgfixxs3015964\"},\"errors\":null}','secupay_inv_xtc','tpsflvgfixxs3015964',0,NULL,'',NULL,'ok','87602','','2018-07-23 13:01:28','2018-07-23 11:01:28'),(5,'','{\"status\":\"ok\",\"data\":{\"hash\":\"gszhqvhtggbw3015972\",\"iframe_url\":\"https:\\/\\/api.secupay.ag\\/payment\\/gszhqvhtggbw3015972\"},\"errors\":null}','secupay_inv_xtc','gszhqvhtggbw3015972',0,NULL,'',NULL,'ok','87602','','2018-07-23 13:03:31','2018-07-23 11:03:31'),(6,'','{\"status\":\"ok\",\"data\":{\"hash\":\"tgdixaukzemf3018640\",\"iframe_url\":\"https:\\/\\/api.secupay.ag\\/payment\\/tgdixaukzemf3018640\"},\"errors\":null}','secupay_inv_xtc','tgdixaukzemf3018640',0,NULL,'',NULL,'ok','11460','','2018-07-24 11:39:00','2018-07-24 09:39:00');

--
-- Table structure for table `secupay_history_kk`
--

CREATE TABLE `secupay_history_kk` (
  `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `req_data` text,
  `ret_data` text,
  `payment_method` varchar(255) DEFAULT NULL,
  `hash` char(40) DEFAULT NULL,
  `transaction_id` int(10) unsigned DEFAULT NULL,
  `ordernr` int(11) DEFAULT NULL,
  `msg` varchar(255) DEFAULT NULL,
  `rank` int(10) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `action` text,
  `created` datetime NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`log_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `secupay_history_kk`
--

INSERT INTO `secupay_history_kk` (`log_id`, `req_data`, `ret_data`, `payment_method`, `hash`, `transaction_id`, `ordernr`, `msg`, `rank`, `status`, `amount`, `action`, `created`, `timestamp`) VALUES (1,'','{\"status\":\"ok\",\"data\":{\"hash\":\"jmccyhxzbrtt3015976\",\"iframe_url\":\"https:\\/\\/api.secupay.ag\\/payment\\/jmccyhxzbrtt3015976\"},\"errors\":null}','secupay_kk_xtc','jmccyhxzbrtt3015976',0,5018,'',NULL,'ok','87602','','2018-07-23 13:03:58','2018-07-23 11:05:44');

--
-- Table structure for table `secupay_history_ls`
--

CREATE TABLE `secupay_history_ls` (
  `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `req_data` text,
  `ret_data` text,
  `payment_method` varchar(255) DEFAULT NULL,
  `hash` char(40) DEFAULT NULL,
  `transaction_id` int(10) unsigned DEFAULT NULL,
  `ordernr` int(11) DEFAULT NULL,
  `msg` varchar(255) DEFAULT NULL,
  `rank` int(10) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `action` text,
  `created` datetime NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`log_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `secupay_history_ls`
--


--
-- Table structure for table `secupay_iframe_url`
--

CREATE TABLE `secupay_iframe_url` (
  `iframe_url_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `iframe_url` text,
  PRIMARY KEY (`iframe_url_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `secupay_iframe_url`
--

INSERT INTO `secupay_iframe_url` (`iframe_url_id`, `iframe_url`) VALUES (1,'https://api.secupay.ag/payment/');

--
-- Table structure for table `secupay_transaction_order`
--

CREATE TABLE `secupay_transaction_order` (
  `hash` char(40) NOT NULL,
  `ordernr` int(11) DEFAULT NULL,
  `transaction_id` int(10) unsigned DEFAULT NULL,
  `created` datetime NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `iframe_url_id` int(10) unsigned DEFAULT NULL,
  `capture_status` int(1) NOT NULL,
  PRIMARY KEY (`hash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `secupay_transaction_order`
--

INSERT INTO `secupay_transaction_order` (`hash`, `ordernr`, `transaction_id`, `created`, `timestamp`, `iframe_url_id`, `capture_status`) VALUES ('mqumlcxblzog2634813',NULL,NULL,'2018-01-31 07:48:42','2018-01-31 06:48:42',1,0),('mmhtmycxvgsp2791620',5009,11961992,'2018-04-13 17:43:14','2018-06-07 10:09:23',1,1),('gvwzztgjnsya2892940',5010,12227576,'2018-05-26 17:26:51','2018-06-07 10:09:23',1,1),('tpsflvgfixxs3015964',NULL,NULL,'2018-07-23 13:01:28','2018-07-23 11:01:28',1,0),('gszhqvhtggbw3015972',NULL,NULL,'2018-07-23 13:03:31','2018-07-23 11:03:31',1,0),('jmccyhxzbrtt3015976',5018,12582429,'2018-07-23 13:03:58','2018-08-01 05:52:03',NULL,2),('tgdixaukzemf3018640',NULL,NULL,'2018-07-24 11:39:00','2018-07-24 09:39:00',1,0);

--
-- Table structure for table `sessions`
--

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

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`sesskey`, `expiry`, `value`) VALUES ('c0a28d79e2b6bb825050f193cc445b0f',1276272732,'language|s:6:\"german\";languages_id|s:1:\"2\";customers_status|a:16:{s:19:\"customers_status_id\";s:1:\"0\";s:21:\"customers_status_name\";s:5:\"Admin\";s:22:\"customers_status_image\";s:16:\"admin_status.gif\";s:23:\"customers_status_public\";s:1:\"0\";s:25:\"customers_status_discount\";s:4:\"0.00\";s:33:\"customers_status_ot_discount_flag\";s:1:\"1\";s:28:\"customers_status_ot_discount\";s:4:\"0.00\";s:33:\"customers_status_graduated_prices\";s:1:\"1\";s:27:\"customers_status_show_price\";s:1:\"1\";s:31:\"customers_status_show_price_tax\";s:1:\"1\";s:27:\"customers_status_add_tax_ot\";s:1:\"0\";s:34:\"customers_status_payment_unallowed\";s:7:\"invoice\";s:35:\"customers_status_shipping_unallowed\";s:0:\"\";s:36:\"customers_status_discount_attributes\";s:1:\"0\";s:15:\"customers_fsk18\";s:1:\"1\";s:23:\"customers_fsk18_display\";s:1:\"1\";}user_info|a:4:{s:7:\"user_ip\";s:14:\"87.142.143.133\";s:9:\"user_host\";s:26:\"p578E8F85.dip.t-dialin.net\";s:10:\"advertiser\";N;s:11:\"referer_url\";s:52:\"http://clean.agronalin.abcde.biz/yes/admin/notiz.php\";}selected_box|s:13:\"configuration\";tracking|a:5:{s:12:\"http_referer\";a:3:{s:6:\"scheme\";s:4:\"http\";s:4:\"host\";s:25:\"clean.agronalin.abcde.biz\";s:4:\"path\";s:14:\"/yes/index.php\";}s:4:\"date\";s:19:\"2010-06-11 14:04:59\";s:7:\"browser\";s:85:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; de; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3\";s:2:\"ip\";s:14:\"87.142.143.133\";s:16:\"pageview_history\";a:2:{i:0;a:3:{s:6:\"scheme\";s:4:\"http\";s:4:\"host\";s:25:\"clean.agronalin.abcde.biz\";s:4:\"path\";s:14:\"/yes/login.php\";}i:1;a:3:{s:6:\"scheme\";s:4:\"http\";s:4:\"host\";s:25:\"clean.agronalin.abcde.biz\";s:4:\"path\";s:14:\"/yes/login.php\";}}}currency|s:3:\"EUR\";cart|O:12:\"shoppingCart\":6:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"customers_id\";N;s:6:\"cartID\";N;s:12:\"content_type\";b:0;}account_type|s:1:\"0\";customer_gender|s:1:\"m\";customer_first_name|s:3:\"YES\";customer_last_name|s:6:\"System\";customer_id|s:1:\"1\";customer_vat_id|s:0:\"\";customer_default_address_id|s:1:\"1\";customer_country_id|s:2:\"81\";customer_zone_id|s:2:\"85\";actual_content|a:0:{}language_id|i:2;curl_alerts_last_action|i:1276260219;hidenote|i:0;menugroup|s:10:\"interfaces\";ebay_sammler|s:1:\"0\";quantity_inputmode|s:8:\"inventur\";messageToStack|a:1:{i:0;a:2:{s:4:\"text\";s:204:\"Der Token (verschlüsselte Zugangsdaten zu Ebay) ist abgelaufen oder noch nicht aktiv, klicken Sie <a href=\'http://clean.agronalin.abcde.biz/yes/admin/token.php\'><u>hier um den Token zu generieren</u></a>.\";s:4:\"type\";s:5:\"error\";}}');

--
-- Table structure for table `shipping_graduation`
--

CREATE TABLE `shipping_graduation` (
  `shipping_graduation_id` int(11) NOT NULL AUTO_INCREMENT,
  `value` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`shipping_graduation_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shipping_graduation`
--

INSERT INTO `shipping_graduation` (`shipping_graduation_id`, `value`) VALUES (1,1);

--
-- Table structure for table `shipping_graduation_countries`
--

CREATE TABLE `shipping_graduation_countries` (
  `shipping_graduation_countries_id` int(11) NOT NULL AUTO_INCREMENT,
  `country_id` int(11) NOT NULL DEFAULT '0',
  `shipping_graduation_groups_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`shipping_graduation_countries_id`),
  KEY `country_id` (`country_id`),
  KEY `shipping_graduation_groups_id` (`shipping_graduation_groups_id`)
) ENGINE=MyISAM AUTO_INCREMENT=208 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shipping_graduation_countries`
--

INSERT INTO `shipping_graduation_countries` (`shipping_graduation_countries_id`, `country_id`, `shipping_graduation_groups_id`) VALUES (197,73,3),(201,222,3),(200,204,3),(199,203,3),(198,105,3),(196,150,2),(195,124,2),(194,57,2),(193,21,2),(192,14,2),(207,81,1),(204,195,4),(203,171,4),(202,72,4),(205,-1,999999);

--
-- Table structure for table `shipping_graduation_groups`
--

CREATE TABLE `shipping_graduation_groups` (
  `shipping_graduation_groups_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `shippingcosts_multiplikator` int(1) NOT NULL DEFAULT '0',
  `shippingcosts_products_multiplikator` int(1) NOT NULL DEFAULT '0',
  `shippingcosts_only_max` int(11) NOT NULL DEFAULT '0',
  `show_weight` int(1) NOT NULL DEFAULT '0',
  `not_ship` int(1) NOT NULL DEFAULT '0',
  `weight_calc` int(1) NOT NULL DEFAULT '0',
  `allow_cod` int(1) NOT NULL DEFAULT '0',
  `cod_fee` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`shipping_graduation_groups_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1000000 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shipping_graduation_groups`
--

INSERT INTO `shipping_graduation_groups` (`shipping_graduation_groups_id`, `title`, `shippingcosts_multiplikator`, `shippingcosts_products_multiplikator`, `shippingcosts_only_max`, `show_weight`, `not_ship`, `weight_calc`, `allow_cod`, `cod_fee`) VALUES (1,'Gruppe 1',0,0,1,0,0,0,0,0),(2,'Gruppe 2',0,0,0,0,0,0,0,0),(3,'Gruppe 3',0,0,0,0,0,0,0,0),(4,'Gruppe 4',0,0,0,0,0,0,0,0),(5,'Gruppe 5',0,0,0,0,0,0,0,0),(999999,'Alle anderen Länder',0,0,0,0,0,0,0,0);

--
-- Table structure for table `shipping_graduation_products`
--

CREATE TABLE `shipping_graduation_products` (
  `shipping_graduation_products_id` int(11) NOT NULL AUTO_INCREMENT,
  `shipping_graduation_groups_id` int(11) NOT NULL DEFAULT '0',
  `graduation_id` int(11) NOT NULL DEFAULT '0',
  `products_id` int(11) NOT NULL DEFAULT '0',
  `value` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`shipping_graduation_products_id`),
  KEY `shipping_graduation_groups_id` (`shipping_graduation_groups_id`),
  KEY `products_id` (`products_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shipping_graduation_products`
--


--
-- Table structure for table `shipping_graduation_values`
--

CREATE TABLE `shipping_graduation_values` (
  `shipping_graduation_id` int(11) NOT NULL DEFAULT '0',
  `shipping_graduation_weights_id` int(11) NOT NULL DEFAULT '0',
  `shipping_graduation_groups_id` int(11) NOT NULL DEFAULT '0',
  `grad_value` float NOT NULL DEFAULT '0',
  `grad_value_cost` float NOT NULL,
  KEY `shipping_graduation_id` (`shipping_graduation_id`),
  KEY `shipping_graduation_weights_id` (`shipping_graduation_weights_id`),
  KEY `shipping_graduation_groups_id` (`shipping_graduation_groups_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shipping_graduation_values`
--

INSERT INTO `shipping_graduation_values` (`shipping_graduation_id`, `shipping_graduation_weights_id`, `shipping_graduation_groups_id`, `grad_value`, `grad_value_cost`) VALUES (2,1,1,10,0),(2,1,2,11,0),(2,1,3,12,0),(2,1,4,13,0),(2,2,1,20,0),(2,2,2,21,0),(2,2,3,22,0),(2,2,4,23,0),(2,3,1,34,0),(2,3,2,35,0),(2,3,3,36,0),(2,3,4,37,0),(1,6,999999,180,0),(1,6,5,124.95,0),(1,6,4,78.95,0),(1,6,3,67.95,0),(1,6,2,56.95,0),(1,6,1,24.95,0),(1,2,999999,140,0),(1,2,5,94.95,0),(1,2,4,53.95,0),(1,2,3,39.95,0),(1,2,2,34.95,0),(1,2,1,14.95,0),(1,5,999999,110,0),(1,5,5,79.9,0),(1,5,4,38.9,0),(1,5,3,13.5,0),(1,5,2,13.5,0),(1,5,1,6.5,0),(1,8,999999,0,0),(1,8,5,0,0),(1,8,4,0,0),(1,8,3,0,0),(1,8,2,6.5,0),(1,8,1,4.96,0),(1,9,1,29,0),(1,9,2,65,0),(1,9,3,80,0),(1,9,4,90,0),(1,9,5,140,0),(1,9,999999,200,0),(1,10,1,35,0),(1,10,2,75,0),(1,10,3,90,0),(1,10,4,100,0),(1,10,5,150,0),(1,10,999999,220,0),(1,11,1,45,0),(1,11,2,90,0),(1,11,3,100,0),(1,11,4,120,0),(1,11,5,180,0),(1,11,999999,240,0);

--
-- Table structure for table `shipping_graduation_weights`
--

CREATE TABLE `shipping_graduation_weights` (
  `shipping_graduation_weights_id` int(11) NOT NULL AUTO_INCREMENT,
  `weight` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`shipping_graduation_weights_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shipping_graduation_weights`
--

INSERT INTO `shipping_graduation_weights` (`shipping_graduation_weights_id`, `weight`) VALUES (2,20),(5,10),(6,40),(8,3),(9,60),(10,80),(11,100);

--
-- Table structure for table `shipping_status`
--

CREATE TABLE `shipping_status` (
  `shipping_status_id` int(11) NOT NULL DEFAULT '0',
  `language_id` int(11) NOT NULL DEFAULT '1',
  `shipping_status_name` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `shipping_status_image` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`shipping_status_id`,`language_id`),
  KEY `shipping_status_name` (`shipping_status_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shipping_status`
--

INSERT INTO `shipping_status` (`shipping_status_id`, `language_id`, `shipping_status_name`, `shipping_status_image`) VALUES (1,1,'3-4 Days',''),(1,2,'1 - 2 Tage',''),(2,1,'1 Week',''),(2,2,'1 Woche',''),(3,1,'2 Weeks',''),(3,2,'2 Wochen',''),(4,2,'Auf Anfrage',''),(5,2,'4-6 Wochen','');

--
-- Table structure for table `shippings`
--

CREATE TABLE `shippings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orders_id` int(11) NOT NULL DEFAULT '0',
  `reclamations_id` int(11) NOT NULL DEFAULT '0',
  `customers_id` int(11) NOT NULL DEFAULT '0',
  `weight` float DEFAULT NULL,
  `packages` int(11) NOT NULL DEFAULT '0',
  `versender` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_finished` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `name1` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `name2` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `company` varchar(128) DEFAULT NULL,
  `street1` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `street2` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `postcode` varchar(10) NOT NULL,
  `city` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `country_id` int(11) NOT NULL DEFAULT '0',
  `country_name` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `country_special` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `ebay_id` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `email` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `status` int(1) NOT NULL DEFAULT '0',
  `csv_status` int(1) NOT NULL DEFAULT '0',
  `comments` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `feedback_mail_sent` int(1) NOT NULL,
  `pdf_status` int(1) NOT NULL,
  `tracking_id` varchar(64) NOT NULL,
  `shipper_export_status` int(1) NOT NULL,
  `email_send_status` int(1) NOT NULL,
  `additional_params` varchar(255) NOT NULL,
  `secupay_send_status` int(1) DEFAULT '0' COMMENT 'Wurde die Versandmeldung an secupay uebergeben?',
  `stop_recreate` int(1) NOT NULL COMMENT 'verhindern das geloeschte DHL Label im versandmodul gemeldet werden bzw neu erzeugt werden',
  PRIMARY KEY (`id`),
  KEY `orders_id` (`orders_id`),
  KEY `reclamations_id` (`reclamations_id`),
  KEY `customers_id` (`customers_id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shippings`
--

INSERT INTO `shippings` (`id`, `orders_id`, `reclamations_id`, `customers_id`, `weight`, `packages`, `versender`, `date_added`, `date_finished`, `name1`, `name2`, `company`, `street1`, `street2`, `postcode`, `city`, `country_id`, `country_name`, `country_special`, `ebay_id`, `email`, `status`, `csv_status`, `comments`, `feedback_mail_sent`, `pdf_status`, `tracking_id`, `shipper_export_status`, `email_send_status`, `additional_params`, `secupay_send_status`, `stop_recreate`) VALUES (1,6,0,4987,80,1,'Gls','2009-12-14 12:11:29','2010-03-25 22:14:33','-------- --------','','--------','--------','','----','--------',0,'Germany','','','frank@naydowski.de',1,1,'',1,1,'',0,0,'',0,0),(2,0,1,4997,80,1,'Post','2010-03-25 22:15:12','2010-03-25 22:15:30','Testkunde2 Testkunde2nachname','','','teststr. 4','','12345','Hamburg',0,'Germany','','','Testkunde2@yes4trade.de',1,1,'',0,1,'',0,0,'',0,0),(3,10,0,4995,80,1,'Post','2010-03-25 22:16:25','2010-03-25 22:16:33','HTestvorname HTestnachname','','','teststr. 5','','20097','Hamburg',0,'Germany','','','Htest@yes4trade.de',1,1,'',1,1,'',0,0,'',0,0),(5,5000,0,5003,20,1,'GLS','2017-12-08 11:45:32','2017-12-08 11:46:55','Uhlmann Marco','','','Friedhofstraße 2','','86420','Diedorf',0,'Germany','','172970434696','volleyballulli@hotmail.de',1,1,'',0,1,'',0,0,'',0,0),(6,5001,0,5004,20,1,'GLS','2017-12-08 11:45:32','2017-12-08 11:46:55','Carolin Schulz','','','Wiesenweg 4','','96479','Weitramsdorf',0,'Germany','','172970371576','carolinschulzneundorf@gmail.com',1,1,'',0,1,'',0,0,'',0,0),(7,5002,0,5005,20,1,'GLS','2017-12-22 19:09:47','2017-12-22 19:09:48','Uwe Neddermann','','','Friederich-Ludwig-Jahn-Str. 4','','27211','BASSUM',0,'Germany','','173027816653','u.neddermann@yahoo.de',1,1,'',0,1,'',0,2,'',0,0),(8,5003,0,5006,20,1,'GLS','2018-01-10 18:39:26','2018-01-10 18:39:29','Ralf Poelmann','','','Johann-Strauß-Ring 31','','26842','Ostrhauderfehn',81,'Germany','','173027817897','mail@ralf-poelmann.de',1,1,'',0,1,'',0,2,'',0,0),(9,5006,0,5011,20,1,'GLS','2018-02-14 17:43:05','2018-06-07 12:05:53','Hans Jürgen Weber','','','Auf der Oes 4','','35510','Butzbach',81,'Germany','','173027780835','weber@kfz-oes.de',1,1,'',0,1,'',0,2,'',0,0),(10,5005,0,5010,20,1,'GLS','2018-06-07 12:04:30','2018-06-07 12:05:53','Guido Brabender','','','Gräfenhohner Str. 23','','53639','Königswinter',0,'Germany','','173027661398','guido.brabender@web.de',1,1,'',0,1,'',0,2,'',0,0),(11,5007,0,5012,20,1,'GLS','2018-06-07 12:04:30','2018-06-07 12:05:53','Rolf Neumann','','','Freiheit 17','Klärwerl Ruhleben / Betriebsleitung','13597','Berlin',0,'Germany','','173027816750','rolf.neu2@freenet.de',1,1,'',0,1,'',0,2,'',0,0),(12,5008,0,5013,20,1,'GLS','2018-06-07 12:04:30','2018-06-07 12:05:53','Johannes Metzger','','','Alte Poststraße 28a','','53721','Siegburg',0,'Germany','','173027780577','hannesmetzger@gmx.de',1,1,'',0,1,'',0,2,'',0,0),(13,5009,0,5014,20,1,'GLS','2018-06-07 12:04:30','2018-06-07 12:05:53','Christoph Stroppel','','Hotel Restaurant & Steakhaus Ochsen ','Paradiesstr. 6','','88348 ','Bad Saulgau',0,'Germany','','','hotel@ochsen-bad-saulgau.de',1,1,'',0,1,'',0,2,'',1,0),(14,5010,0,5015,80,1,'GLS','2018-06-07 12:04:30','2018-06-07 12:05:53','Theo Giesen','','','Bürgermeister-Singer-Str. 10','','86825','Bad Wörishofen',0,'Germany','','','giesen-bw@t-online.de',1,1,'',0,1,'',0,2,'',1,0),(15,5004,0,5009,20,1,'Spedition','2018-06-07 12:04:30','2018-06-07 12:05:53','Sven Giertz','','','Zillebogen, 10','','15806','Zossen',0,'Germany','','','svengiertz@hotmail.com',1,1,'',0,1,'',0,2,'',0,0),(16,5011,0,5016,20,1,'GLS','2018-06-11 10:07:59','2018-06-11 10:08:25','Tim Körner','','','Paula-Fürst-Str. 11','','10317','Berlin',0,'Germany','','173027816275','tkx2@pfs11.de',1,1,'',0,1,'',0,2,'',0,0),(17,5012,0,5016,20,1,'GLS','2018-06-11 10:07:59','2018-06-11 10:08:25','Tim Körner','','','Paula-Fürst-Str. 11','','10317','Berlin',0,'Germany','','173027817681','tkx2@pfs11.de',1,1,'',0,1,'',0,2,'',0,0),(18,5013,0,5017,20,1,'GLS','2018-06-26 11:27:37','2018-06-26 11:29:23','Ilka Rosenthal','','','Oderstraße 16','','10247','Berlin',81,'Germany','','173027778710','rilki@gmx.de',1,1,'',0,1,'',0,2,'',0,0),(19,5018,0,5021,20,1,'GLS','2018-08-01 07:49:36','2018-08-01 07:49:47','Hermann Probst','','','Ibach 1','','88263','Horgenzell',81,'Germany','','','probst.hermann@web.de',1,1,'',0,1,'',0,2,'',1,0),(20,5014,0,5019,20,1,'Spedition','2018-08-01 07:52:55','2018-08-01 07:53:22','Paul Böhme','','','Dahlberg 3','','23970','Wismar',0,'Germany','','173027664608','ch.boehme@gmx.net',1,1,'',0,1,'',0,2,'',0,0),(21,5019,0,5023,20,1,'GLS','2018-08-09 07:57:34','2018-08-09 07:57:52','Beatrice Blumenroth','','','Peter-Klein-Str.27','','53117','Bonn',81,'Germany','','173027803669','b-hanne@t-online.de',1,1,'',0,1,'',0,2,'',0,0),(22,5024,0,5027,250,1,'GLS','2018-12-03 12:00:02','2018-12-03 12:00:09','Natalie Wettinger','','','Schulgasse 10','','92637','Weiden',81,'Germany','','','edgarw1860@gmail.com',1,1,'',0,1,'',0,2,'',0,0),(23,5025,0,5028,20,1,'GLS','2018-12-13 15:17:12','2018-12-14 16:29:25','Jens Rommelfanger','','','Trierer Str. 10a','ITA Rommelfanger GmbH','54314','Zerf',0,'Germany','','173027778800','thandor358@web.de',1,1,'',0,1,'',0,2,'',0,0),(24,5026,0,5029,20,1,'GLS','2018-12-13 15:17:44','2018-12-14 16:29:25','Ilka Rosenthal','','Herbert und Kohlmeyer Immobilien GmbH','Lychener Straße','2','10437','Berlin',0,'Germany','','','rilki@gmx.de',1,1,'',0,1,'',0,2,'',0,0);

--
-- Table structure for table `shippings_products`
--

CREATE TABLE `shippings_products` (
  `shippings_products_id` int(11) NOT NULL AUTO_INCREMENT,
  `shippings_id` int(11) NOT NULL,
  `products_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `source_products_id` int(11) NOT NULL,
  PRIMARY KEY (`shippings_products_id`),
  KEY `shippings_id` (`shippings_id`,`products_id`,`source_products_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shippings_products`
--

INSERT INTO `shippings_products` (`shippings_products_id`, `shippings_id`, `products_id`, `quantity`, `source_products_id`) VALUES (1,6,352,1,35),(2,5,412,1,34),(3,7,195,1,36),(4,8,226,1,37),(5,13,351,1,43),(6,10,413,1,39),(7,9,265,1,40),(8,12,354,1,42),(9,11,198,1,41),(10,14,418,1,44),(11,15,403,1,38),(12,16,182,1,45),(13,17,221,1,46),(14,18,267,1,47),(15,19,180,1,63),(16,20,270,1,48),(17,21,387,1,64),(18,22,405,1,69),(19,24,267,1,71),(20,23,242,1,70);

--
-- Table structure for table `shippings_tracking_numbers`
--

CREATE TABLE `shippings_tracking_numbers` (
  `shippings_tracking_numbers_id` int(11) NOT NULL AUTO_INCREMENT,
  `shippings_id` int(11) NOT NULL,
  `tracking_number` varchar(64) NOT NULL,
  `date_added` datetime NOT NULL,
  `manifest` int(1) NOT NULL,
  PRIMARY KEY (`shippings_tracking_numbers_id`),
  KEY `shippings_id` (`shippings_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `shippings_tracking_numbers`
--

INSERT INTO `shippings_tracking_numbers` (`shippings_tracking_numbers_id`, `shippings_id`, `tracking_number`, `date_added`, `manifest`) VALUES (1,5,'56221823421','2017-12-08 11:51:57',0),(2,6,'56221823442','2017-12-08 11:51:57',0),(3,7,'56221833753','2017-12-22 19:11:38',0),(4,16,'56222430935','2018-06-11 10:11:05',0),(5,17,'56222430935','2018-06-11 10:11:06',0),(6,21,'56222490579','2018-08-09 08:02:25',0),(7,22,'56229254541','2018-12-03 14:37:45',0),(8,23,'56229288493','2018-12-14 16:33:09',0),(9,24,'56229283688','2018-12-14 16:33:09',0);

--
-- Table structure for table `specials`
--

CREATE TABLE `specials` (
  `specials_id` int(11) NOT NULL AUTO_INCREMENT,
  `products_id` int(11) NOT NULL DEFAULT '0',
  `specials_quantity` int(4) NOT NULL DEFAULT '0',
  `specials_new_products_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `specials_date_added` datetime DEFAULT NULL,
  `specials_last_modified` datetime DEFAULT NULL,
  `expires_date` datetime DEFAULT NULL,
  `date_status_change` datetime DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  `start_date` datetime NOT NULL,
  `sell_to_v1null` int(1) NOT NULL,
  `ebay_price_revise` int(1) NOT NULL,
  PRIMARY KEY (`specials_id`),
  KEY `products_id` (`products_id`),
  KEY `specials_date_added` (`specials_date_added`),
  KEY `products_id_2` (`products_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `specials`
--


--
-- Table structure for table `specials_ebay_revise`
--

CREATE TABLE `specials_ebay_revise` (
  `specials_ebay_revise_id` int(11) NOT NULL AUTO_INCREMENT,
  `specials_id` int(11) NOT NULL,
  `ebay_auctions_id` int(11) NOT NULL,
  `sku` varchar(64) NOT NULL,
  `orig_price` decimal(15,4) NOT NULL,
  `status` int(1) NOT NULL COMMENT 'wenn der np wieder gesetzt werden soll, auf 1',
  `original_price` decimal(13,4) NOT NULL,
  `special_price` decimal(13,4) NOT NULL,
  `is_revised` int(1) NOT NULL,
  PRIMARY KEY (`specials_ebay_revise_id`),
  KEY `specials_id` (`specials_id`),
  KEY `ebay_auctions_id` (`ebay_auctions_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `specials_ebay_revise`
--


--
-- Table structure for table `storage_numbers`
--

CREATE TABLE `storage_numbers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `products_id` int(11) NOT NULL DEFAULT '0',
  `storage_id` int(11) NOT NULL DEFAULT '0',
  `nummer` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `products_id` (`products_id`),
  KEY `storage_id` (`storage_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `storage_numbers`
--

INSERT INTO `storage_numbers` (`id`, `products_id`, `storage_id`, `nummer`) VALUES (5,143,1,'15');

--
-- Table structure for table `storage_places`
--

CREATE TABLE `storage_places` (
  `storage_places_id` int(11) NOT NULL AUTO_INCREMENT,
  `storage_id` int(11) NOT NULL,
  `title` varchar(64) NOT NULL,
  `storage_type` int(1) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`storage_places_id`),
  KEY `storage_id` (`storage_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='lagerplaetze';

--
-- Dumping data for table `storage_places`
--

INSERT INTO `storage_places` (`storage_places_id`, `storage_id`, `title`, `storage_type`, `description`) VALUES (1,1,'Platz A',0,'Autoimport YES 20.06.2016 10:51:34'),(2,1,'Platz B',0,'Autoimport YES 20.06.2016 10:51:36'),(3,1,'C',0,'Autoimport YES 20.06.2016 10:51:36'),(4,1,'1a_oben',0,'Autoimport YES 20.06.2016 10:51:36'),(5,1,'1a_unten',0,'Autoimport YES 20.06.2016 10:51:36'),(6,1,'2a_hinten',0,'Autoimport YES 20.06.2016 10:51:36'),(7,1,'2b_vorn',0,'Autoimport YES 20.06.2016 10:51:36'),(8,1,'A0001',0,'');

--
-- Table structure for table `storage_products`
--

CREATE TABLE `storage_products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `storage_id` int(11) NOT NULL DEFAULT '0',
  `products_id` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `storage_place` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `priority` int(11) NOT NULL,
  `storage_places_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `storage_id` (`storage_id`),
  KEY `products_id` (`products_id`),
  KEY `storage_place` (`storage_place`),
  KEY `storage_places_id` (`storage_places_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `storage_products`
--

INSERT INTO `storage_products` (`id`, `storage_id`, `products_id`, `quantity`, `created`, `changed`, `storage_place`, `priority`, `storage_places_id`) VALUES (8,1,143,0,'2017-07-10 05:28:57','0000-00-00 00:00:00','',0,8);

--
-- Table structure for table `storage_products_transfer`
--

CREATE TABLE `storage_products_transfer` (
  `storage_products_transfer_id` int(11) NOT NULL AUTO_INCREMENT,
  `source_storage_products_id` int(11) NOT NULL,
  `target_storage_products_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `editor` int(11) NOT NULL,
  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `reason_class` varchar(16) NOT NULL,
  `reason_id` int(11) NOT NULL,
  `reason_subclass` varchar(16) NOT NULL,
  `shipping_products_id` int(11) NOT NULL COMMENT 'wird bei versandabschluss gesetzt',
  PRIMARY KEY (`storage_products_transfer_id`),
  KEY `source_storage_products_id` (`source_storage_products_id`,`target_storage_products_id`,`quantity`),
  KEY `shipping_products_id` (`shipping_products_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `storage_products_transfer`
--

INSERT INTO `storage_products_transfer` (`storage_products_transfer_id`, `source_storage_products_id`, `target_storage_products_id`, `quantity`, `editor`, `date_added`, `reason_class`, `reason_id`, `reason_subclass`, `shipping_products_id`) VALUES (1,0,4,20,1,'2013-11-16 10:31:38','',0,'',0),(2,0,5,10,1,'2013-11-16 10:31:58','',0,'',0),(3,0,6,40,1,'2013-11-16 10:32:13','',0,'',0),(4,0,7,30,1,'2013-11-16 10:32:25','',0,'',0);

--
-- Table structure for table `storages`
--

CREATE TABLE `storages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `beschreibung` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `schema_key` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `schema_start` int(11) NOT NULL DEFAULT '0',
  `default_storage` enum('n','y') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'n',
  `storage_company` varchar(64) NOT NULL,
  `storage_suburb` varchar(64) NOT NULL,
  `storage_name` varchar(64) NOT NULL,
  `storage_street_address` varchar(64) NOT NULL,
  `storage_city` varchar(32) NOT NULL,
  `storage_postcode` varchar(10) NOT NULL,
  `storage_country` tinyint(4) NOT NULL,
  `storage_telephone` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `storages`
--

INSERT INTO `storages` (`id`, `name`, `beschreibung`, `schema_key`, `schema_start`, `default_storage`, `storage_company`, `storage_suburb`, `storage_name`, `storage_street_address`, `storage_city`, `storage_postcode`, `storage_country`, `storage_telephone`) VALUES (1,'Stammlager','Stammlager HH-Hafen','1',1,'y','','','','','','',0,''),(2,'Testfiliale1','Filiale','2',1,'n','','','','','','',0,'');

--
-- Table structure for table `system_alerts_status`
--

CREATE TABLE `system_alerts_status` (
  `system_alerts_status_id` int(11) NOT NULL AUTO_INCREMENT,
  `customers_id` int(11) NOT NULL,
  `guid` int(11) NOT NULL,
  `status_read` tinyint(1) NOT NULL,
  `status_read_date` datetime NOT NULL,
  PRIMARY KEY (`system_alerts_status_id`),
  KEY `customers_id` (`customers_id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `system_alerts_status`
--

INSERT INTO `system_alerts_status` (`system_alerts_status_id`, `customers_id`, `guid`, `status_read`, `status_read_date`) VALUES (1,1,3,1,'2008-11-26 08:31:35'),(2,1,2,1,'2008-11-26 08:31:37'),(3,1,1,1,'2008-11-26 08:31:38'),(4,1,4,1,'2009-01-24 10:34:12'),(5,4987,4,1,'2009-02-19 19:07:38'),(6,4987,3,1,'2009-02-19 19:07:42'),(7,4987,2,1,'2009-02-19 19:07:44'),(8,4987,1,1,'2009-02-19 19:07:35'),(9,4987,5,1,'2009-06-27 19:44:11'),(10,1,6,1,'2009-07-14 18:13:48'),(11,1,5,1,'2009-07-14 18:13:51'),(12,4987,6,1,'2009-07-15 12:59:55'),(13,4987,7,1,'2009-10-20 15:04:24'),(14,1,7,1,'2009-11-13 11:15:21'),(15,4988,7,1,'2010-03-18 18:43:05'),(16,4988,6,1,'2010-03-18 18:43:07'),(17,4988,5,1,'2010-03-18 18:43:08'),(18,4988,4,1,'2010-03-18 18:43:10'),(19,4988,3,1,'2010-03-18 18:43:11'),(20,4988,2,1,'2010-03-18 18:43:13'),(21,4988,1,1,'2010-03-18 18:43:04'),(22,1,9,1,'2011-09-28 17:18:02'),(23,1,8,1,'2011-09-28 17:18:05');

--
-- Table structure for table `table_lock`
--

CREATE TABLE `table_lock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_key` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `status` enum('locked','open') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'locked',
  `last_lock` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `table_lock`
--

INSERT INTO `table_lock` (`id`, `action_key`, `status`, `last_lock`) VALUES (1,'addtimer','locked','2018-12-19 20:57:31');

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `tags_id` int(11) NOT NULL AUTO_INCREMENT,
  `tag` varchar(64) NOT NULL,
  `date_added` datetime NOT NULL,
  `editor_id` int(11) NOT NULL,
  `type` varchar(8) NOT NULL,
  PRIMARY KEY (`tags_id`),
  KEY `type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` (`tags_id`, `tag`, `date_added`, `editor_id`, `type`) VALUES (1,'','2017-07-17 03:46:32',1,'product');

--
-- Table structure for table `tags_products`
--

CREATE TABLE `tags_products` (
  `tags_products_id` int(11) NOT NULL AUTO_INCREMENT,
  `tags_id` int(11) NOT NULL,
  `products_id` int(11) NOT NULL,
  PRIMARY KEY (`tags_products_id`),
  KEY `tags_id` (`tags_id`,`products_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2570 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tags_products`
--

INSERT INTO `tags_products` (`tags_products_id`, `tags_id`, `products_id`) VALUES (1,1,148),(2,1,149),(3,1,150),(4,1,151),(5,1,152),(6,1,153),(7,1,154),(8,1,155),(9,1,156),(10,1,157),(11,1,181),(12,1,182),(13,1,183),(14,1,184),(15,1,185),(16,1,186),(17,1,187),(18,1,188),(19,1,189),(20,1,190),(21,1,191),(22,1,192),(23,1,193),(24,1,194),(25,1,195),(26,1,196),(27,1,197),(28,1,198),(29,1,199),(30,1,200),(31,1,201),(32,1,202),(33,1,203),(34,1,204),(35,1,205),(36,1,206),(37,1,207),(38,1,208),(39,1,209),(40,1,210),(41,1,211),(42,1,212),(43,1,213),(44,1,214),(45,1,215),(46,1,216),(47,1,217),(48,1,218),(49,1,219),(50,1,220),(51,1,221),(52,1,222),(53,1,223),(54,1,224),(55,1,225),(56,1,226),(57,1,227),(58,1,228),(59,1,229),(60,1,230),(61,1,231),(62,1,232),(63,1,233),(64,1,234),(65,1,235),(66,1,236),(67,1,237),(68,1,351),(69,1,352),(70,1,353),(71,1,354),(72,1,355),(73,1,356),(74,1,357),(75,1,358),(76,1,359),(77,1,360),(78,1,361),(79,1,362),(80,1,363),(81,1,364),(82,1,365),(83,1,366),(84,1,367),(85,1,368),(86,1,369),(87,1,370),(88,1,371),(89,1,372),(90,1,373),(91,1,374),(92,1,375),(93,1,376),(94,1,377),(95,1,378),(96,1,379),(97,1,380),(98,1,381),(99,1,382),(100,1,383),(101,1,384),(102,1,385),(103,1,386),(104,1,387),(105,1,388),(106,1,389),(107,1,390),(108,1,391),(109,1,392),(110,1,393),(111,1,394),(112,1,395),(113,1,396),(114,1,397),(115,1,398),(116,1,399),(117,1,400),(118,1,401),(119,1,402),(120,1,403),(121,1,404),(122,1,405),(123,1,406),(124,1,407),(125,1,408),(126,1,409),(127,1,410),(128,1,411),(129,1,412),(130,1,413),(131,1,414),(132,1,415),(133,1,416),(134,1,417),(135,1,418),(136,1,350),(137,1,348),(138,1,349),(139,1,347),(140,1,240),(141,1,241),(142,1,242),(143,1,243),(144,1,244),(145,1,245),(146,1,246),(147,1,247),(148,1,248),(149,1,249),(150,1,250),(151,1,251),(152,1,252),(153,1,253),(154,1,254),(155,1,255),(156,1,256),(157,1,257),(158,1,258),(159,1,259),(160,1,260),(161,1,261),(162,1,262),(163,1,263),(164,1,264),(165,1,265),(166,1,266),(167,1,267),(168,1,268),(169,1,269),(170,1,270),(171,1,271),(172,1,272),(173,1,273),(174,1,274),(175,1,275),(176,1,276),(177,1,277),(178,1,278),(179,1,279),(180,1,280),(181,1,281),(182,1,282),(183,1,283),(184,1,284),(185,1,285),(186,1,286),(187,1,287),(188,1,288),(189,1,289),(190,1,290),(191,1,291),(192,1,292),(193,1,293),(194,1,294),(195,1,295),(196,1,296),(197,1,297),(198,1,298),(199,1,299),(200,1,300),(201,1,301),(202,1,302),(203,1,303),(204,1,304),(205,1,305),(206,1,306),(207,1,307),(208,1,308),(209,1,309),(210,1,310),(211,1,311),(212,1,312),(213,1,313),(214,1,314),(215,1,315),(216,1,316),(217,1,317),(218,1,318),(219,1,319),(220,1,320),(221,1,321),(222,1,322),(223,1,323),(224,1,324),(225,1,325),(226,1,326),(227,1,327),(228,1,328),(229,1,329),(230,1,330),(231,1,331),(232,1,332),(233,1,333),(234,1,334),(235,1,335),(236,1,336),(237,1,337),(238,1,338),(239,1,339),(240,1,340),(241,1,341),(242,1,342),(243,1,343),(244,1,344),(245,1,345),(246,1,346),(247,1,239),(1409,1,1458),(1410,1,1459),(1411,1,1460),(1412,1,1461),(1413,1,1462),(1414,1,1463),(1415,1,1464),(1416,1,1465),(1417,1,1466),(1418,1,1467),(1419,1,1468),(1420,1,1469),(1421,1,1470),(1422,1,1471),(1423,1,1472),(1424,1,1473),(1425,1,1474),(1426,1,1475),(1427,1,1476),(1428,1,1477),(1429,1,1478),(1430,1,1479),(1431,1,1480),(1432,1,1481),(1433,1,1482),(1434,1,1483),(1435,1,1484),(1436,1,1485),(1437,1,1486),(1438,1,1487),(1439,1,1488),(1440,1,1489),(1441,1,1490),(1442,1,1491),(1443,1,1492),(1444,1,1493),(1445,1,1494),(1446,1,1495),(1447,1,1496),(1448,1,1497),(1449,1,1498),(1450,1,1499),(1451,1,1500),(1452,1,1501),(1453,1,1502),(1454,1,1503),(1455,1,1504),(1456,1,1505),(1457,1,1506),(1458,1,1507),(1459,1,1508),(1460,1,1509),(1461,1,1510),(1462,1,1511),(1463,1,1512),(1464,1,1513),(1465,1,1514),(1466,1,1515),(1467,1,1516),(1468,1,1517),(1469,1,1518),(1470,1,1519),(1471,1,1520),(1472,1,1521),(1473,1,1522),(1474,1,1523),(1475,1,1524),(1476,1,1525),(1477,1,1526),(1478,1,1527),(1479,1,1528),(1480,1,1529),(1481,1,1530),(1482,1,1531),(1483,1,1532),(1484,1,1533),(1485,1,1534),(1486,1,1535),(1487,1,1536),(1488,1,1537),(1489,1,1538),(1490,1,1539),(1491,1,1540),(1492,1,1541),(1493,1,1542),(1494,1,1543),(1495,1,1544),(1496,1,1545),(1497,1,1546),(1498,1,1547),(1499,1,1548),(1500,1,1549),(1501,1,1550),(1502,1,1551),(1503,1,1552),(1504,1,1553),(1505,1,1554),(1506,1,1555),(1507,1,1556),(1508,1,1557),(1509,1,1558),(1510,1,1559),(1511,1,1560),(1512,1,1561),(1513,1,1562),(1514,1,1563),(1515,1,1564),(1516,1,1565),(1517,1,1566),(1518,1,1567),(1519,1,1568),(1520,1,1569),(1521,1,1570),(1522,1,1571),(1523,1,1572),(1524,1,1573),(1525,1,1574),(1526,1,1575),(1527,1,1576),(1528,1,1577),(1529,1,1578),(1530,1,1579),(1531,1,1420),(1532,1,1421),(1533,1,1422),(1534,1,1423),(1535,1,1424),(1536,1,1425),(1537,1,1426),(1538,1,1427),(1539,1,1428),(1540,1,1429),(1541,1,1430),(1542,1,1431),(1543,1,1432),(1544,1,1433),(1545,1,1434),(1546,1,1435),(1547,1,1436),(1548,1,1437),(1549,1,1438),(1550,1,1439),(1551,1,1440),(1552,1,1441),(1553,1,1442),(1554,1,1443),(1555,1,1444),(1556,1,1445),(1557,1,1446),(1558,1,1447),(1559,1,1448),(1560,1,1449),(1561,1,1450),(1562,1,1451),(1563,1,1452),(1564,1,1453),(1565,1,1454),(1566,1,1455),(1567,1,1456),(1568,1,1457),(1569,1,1294),(1570,1,1295),(1571,1,1296),(1572,1,1297),(1573,1,1298),(1574,1,1299),(1575,1,1300),(1576,1,1301),(1577,1,1302),(1578,1,1303),(1579,1,1304),(1580,1,1305),(1581,1,1306),(1582,1,1307),(1583,1,1308),(1584,1,1309),(1585,1,1310),(1586,1,1311),(1587,1,1312),(1588,1,1313),(1589,1,1314),(1590,1,1315),(1591,1,1316),(1592,1,1317),(1593,1,1318),(1594,1,1319),(1595,1,1320),(1596,1,1321),(1597,1,1322),(1598,1,1323),(1599,1,1324),(1600,1,1325),(1601,1,1326),(1602,1,1327),(1603,1,1328),(1604,1,1329),(1605,1,1330),(1606,1,1331),(1607,1,1332),(1608,1,1333),(1609,1,1334),(1610,1,1335),(1611,1,1336),(1612,1,1337),(1613,1,1338),(1614,1,1339),(1615,1,1340),(1616,1,1341),(1617,1,1342),(1618,1,1343),(1619,1,1344),(1620,1,1345),(1621,1,1346),(1622,1,1347),(1623,1,1348),(1624,1,1349),(1625,1,1350),(1626,1,1351),(1627,1,1352),(1628,1,1353),(1629,1,1354),(1630,1,1355),(1631,1,1356),(1632,1,1357),(1633,1,1358),(1634,1,1359),(1635,1,1360),(1636,1,1361),(1637,1,1362),(1638,1,1363),(1639,1,1364),(1640,1,1365),(1641,1,1366),(1642,1,1367),(1643,1,1368),(1644,1,1369),(1645,1,1370),(1646,1,1371),(1647,1,1372),(1648,1,1373),(1649,1,1374),(1650,1,1375),(1651,1,1376),(1652,1,1377),(1653,1,1378),(1654,1,1379),(1655,1,1380),(1656,1,1381),(1657,1,1382),(1658,1,1383),(1659,1,1384),(1660,1,1385),(1661,1,1386),(1662,1,1387),(1663,1,1388),(1664,1,1389),(1665,1,1390),(1666,1,1391),(1667,1,1392),(1668,1,1393),(1669,1,1394),(1670,1,1395),(1671,1,1396),(1672,1,1397),(1673,1,1398),(1674,1,1399),(1675,1,1400),(1676,1,1401),(1677,1,1402),(1678,1,1403),(1679,1,1404),(1680,1,1405),(1681,1,1406),(1682,1,1407),(1683,1,1408),(1684,1,1409),(1685,1,1410),(1686,1,1411),(1687,1,1412),(1688,1,1413),(1689,1,1414),(1690,1,1415),(1691,1,1416),(1692,1,1417),(1693,1,1418),(1694,1,1419),(1695,1,1043),(1696,1,1044),(1697,1,1045),(1698,1,1046),(1699,1,1047),(1700,1,1048),(1701,1,1049),(1702,1,1050),(1703,1,1051),(1704,1,1052),(1705,1,1053),(1706,1,1054),(1707,1,1055),(1708,1,1056),(1709,1,1057),(1710,1,1058),(1711,1,1059),(1712,1,1060),(1713,1,1061),(1714,1,1062),(1715,1,1063),(1716,1,1064),(1717,1,1065),(1718,1,1066),(1719,1,1067),(1720,1,1068),(1721,1,1069),(1722,1,1070),(1723,1,1071),(1724,1,1072),(1725,1,1073),(1726,1,1074),(1727,1,1075),(1728,1,1076),(1729,1,1077),(1730,1,1078),(1731,1,1079),(1732,1,1080),(1733,1,1081),(1734,1,1082),(1735,1,1083),(1736,1,1084),(1737,1,1085),(1738,1,1086),(1739,1,1087),(1740,1,1088),(1741,1,1089),(1742,1,1090),(1743,1,1091),(1744,1,1092),(1745,1,1093),(1746,1,1094),(1747,1,1095),(1748,1,1096),(1749,1,1097),(1750,1,1098),(1751,1,1099),(1752,1,1100),(1753,1,1101),(1754,1,1102),(1755,1,1103),(1756,1,1104),(1757,1,1105),(1758,1,1106),(1759,1,1107),(1760,1,1108),(1761,1,1109),(1762,1,1110),(1763,1,1111),(1764,1,1112),(1765,1,1113),(1766,1,1114),(1767,1,1115),(1768,1,1116),(1769,1,1117),(1770,1,1118),(1771,1,1119),(1772,1,1120),(1773,1,1121),(1774,1,1122),(1775,1,1123),(1776,1,1124),(1777,1,1125),(1778,1,1126),(1779,1,1127),(1780,1,1128),(1781,1,1129),(1782,1,1130),(1783,1,1131),(1784,1,1132),(1785,1,1133),(1786,1,1134),(1787,1,1135),(1788,1,1136),(1789,1,1137),(1790,1,1138),(1791,1,1139),(1792,1,1140),(1793,1,1141),(1794,1,1142),(1795,1,1143),(1796,1,1144),(1797,1,1145),(1798,1,1146),(1799,1,1147),(1800,1,1148),(1801,1,1149),(1802,1,1150),(1803,1,1151),(1804,1,1152),(1805,1,1153),(1806,1,1154),(1807,1,1155),(1808,1,1156),(1809,1,1157),(1810,1,1158),(1811,1,1159),(1812,1,1160),(1813,1,1161),(1814,1,1162),(1815,1,1163),(1816,1,1164),(1817,1,1165),(1818,1,1166),(1819,1,1167),(1820,1,1168),(1821,1,1169),(1822,1,1170),(1823,1,1171),(1824,1,1172),(1825,1,1173),(1826,1,1174),(1827,1,1175),(1828,1,1176),(1829,1,1177),(1830,1,1178),(1831,1,1179),(1832,1,1180),(1833,1,1181),(1834,1,1182),(1835,1,1183),(1836,1,1184),(1837,1,1185),(1838,1,1186),(1839,1,1187),(1840,1,1188),(1841,1,1189),(1842,1,1190),(1843,1,1191),(1844,1,1192),(1845,1,1193),(1846,1,1194),(1847,1,1195),(1848,1,1196),(1849,1,1197),(1850,1,1198),(1851,1,1199),(1852,1,1200),(1853,1,1201),(1854,1,1202),(1855,1,1203),(1856,1,1204),(1857,1,1205),(1858,1,1206),(1859,1,1207),(1860,1,1208),(1861,1,1209),(1862,1,1210),(1863,1,1211),(1864,1,1212),(1865,1,1213),(1866,1,1214),(1867,1,1215),(1868,1,1216),(1869,1,1217),(1870,1,1218),(1871,1,1219),(1872,1,1220),(1873,1,1221),(1874,1,1222),(1875,1,1223),(1876,1,1224),(1877,1,1225),(1878,1,1226),(1879,1,1227),(1880,1,1228),(1881,1,1229),(1882,1,1230),(1883,1,1231),(1884,1,1232),(1885,1,1233),(1886,1,1234),(1887,1,1235),(1888,1,1236),(1889,1,1237),(1890,1,1238),(1891,1,1239),(1892,1,1240),(1893,1,1241),(1894,1,1242),(1895,1,1243),(1896,1,1244),(1897,1,1245),(1898,1,1246),(1899,1,1247),(1900,1,1248),(1901,1,1249),(1902,1,1250),(1903,1,1251),(1904,1,1252),(1905,1,1253),(1906,1,1254),(1907,1,1255),(1908,1,1256),(1909,1,1257),(1910,1,1258),(1911,1,1259),(1912,1,1260),(1913,1,1261),(1914,1,1262),(1915,1,1263),(1916,1,1264),(1917,1,1265),(1918,1,1266),(1919,1,1267),(1920,1,1268),(1921,1,1269),(1922,1,1270),(1923,1,1271),(1924,1,1272),(1925,1,1273),(1926,1,1274),(1927,1,1275),(1928,1,1276),(1929,1,1277),(1930,1,1278),(1931,1,1279),(1932,1,1280),(1933,1,1281),(1934,1,1282),(1935,1,1283),(1936,1,1284),(1937,1,1285),(1938,1,1286),(1939,1,1287),(1940,1,1288),(1941,1,1289),(1942,1,1290),(1943,1,1291),(1944,1,1292),(1945,1,1293),(1946,1,920),(1947,1,921),(1948,1,922),(1949,1,923),(1950,1,924),(1951,1,925),(1952,1,926),(1953,1,927),(1954,1,928),(1955,1,929),(1956,1,930),(1957,1,931),(1958,1,932),(1959,1,933),(1960,1,934),(1961,1,935),(1962,1,936),(1963,1,937),(1964,1,938),(1965,1,939),(1966,1,940),(1967,1,941),(1968,1,942),(1969,1,943),(1970,1,944),(1971,1,945),(1972,1,946),(1973,1,947),(1974,1,948),(1975,1,949),(1976,1,950),(1977,1,951),(1978,1,952),(1979,1,953),(1980,1,954),(1981,1,955),(1982,1,956),(1983,1,957),(1984,1,958),(1985,1,959),(1986,1,960),(1987,1,961),(1988,1,962),(1989,1,963),(1990,1,964),(1991,1,965),(1992,1,966),(1993,1,967),(1994,1,968),(1995,1,969),(1996,1,970),(1997,1,971),(1998,1,972),(1999,1,973),(2000,1,974),(2001,1,975),(2002,1,976),(2003,1,977),(2004,1,978),(2005,1,979),(2006,1,980),(2007,1,981),(2008,1,982),(2009,1,983),(2010,1,984),(2011,1,985),(2012,1,986),(2013,1,987),(2014,1,988),(2015,1,989),(2016,1,990),(2017,1,991),(2018,1,992),(2019,1,993),(2020,1,994),(2021,1,995),(2022,1,996),(2023,1,997),(2024,1,998),(2025,1,999),(2026,1,1000),(2027,1,1001),(2028,1,1002),(2029,1,1003),(2030,1,1004),(2031,1,1005),(2032,1,1006),(2033,1,1007),(2034,1,1008),(2035,1,1009),(2036,1,1010),(2037,1,1011),(2038,1,1012),(2039,1,1013),(2040,1,1014),(2041,1,1015),(2042,1,1016),(2043,1,1017),(2044,1,1018),(2045,1,1019),(2046,1,1020),(2047,1,1021),(2048,1,1022),(2049,1,1023),(2050,1,1024),(2051,1,1025),(2052,1,1026),(2053,1,1027),(2054,1,1028),(2055,1,1029),(2056,1,1030),(2057,1,1031),(2058,1,1032),(2059,1,1033),(2060,1,1034),(2061,1,1035),(2062,1,1036),(2063,1,1037),(2064,1,1038),(2065,1,1039),(2066,1,1040),(2067,1,1041),(2068,1,1042),(2069,1,870),(2070,1,871),(2071,1,872),(2072,1,873),(2073,1,874),(2074,1,875),(2075,1,876),(2076,1,877),(2077,1,878),(2078,1,879),(2079,1,880),(2080,1,881),(2081,1,882),(2082,1,883),(2083,1,884),(2084,1,885),(2085,1,886),(2086,1,887),(2087,1,888),(2088,1,889),(2089,1,890),(2090,1,891),(2091,1,892),(2092,1,893),(2093,1,894),(2094,1,895),(2095,1,896),(2096,1,897),(2097,1,898),(2098,1,899),(2099,1,900),(2100,1,901),(2101,1,902),(2102,1,903),(2103,1,904),(2104,1,905),(2105,1,906),(2106,1,907),(2107,1,908),(2108,1,909),(2109,1,910),(2110,1,911),(2111,1,912),(2112,1,913),(2113,1,914),(2114,1,915),(2115,1,916),(2116,1,917),(2117,1,918),(2118,1,919),(2119,1,620),(2120,1,621),(2121,1,622),(2122,1,623),(2123,1,624),(2124,1,625),(2125,1,626),(2126,1,627),(2127,1,628),(2128,1,629),(2129,1,630),(2130,1,631),(2131,1,632),(2132,1,633),(2133,1,634),(2134,1,635),(2135,1,636),(2136,1,637),(2137,1,638),(2138,1,639),(2139,1,640),(2140,1,641),(2141,1,642),(2142,1,643),(2143,1,644),(2144,1,645),(2145,1,646),(2146,1,647),(2147,1,648),(2148,1,649),(2149,1,650),(2150,1,651),(2151,1,652),(2152,1,653),(2153,1,654),(2154,1,655),(2155,1,656),(2156,1,657),(2157,1,658),(2158,1,659),(2159,1,660),(2160,1,661),(2161,1,662),(2162,1,663),(2163,1,664),(2164,1,665),(2165,1,666),(2166,1,667),(2167,1,668),(2168,1,669),(2169,1,670),(2170,1,671),(2171,1,672),(2172,1,673),(2173,1,674),(2174,1,675),(2175,1,676),(2176,1,677),(2177,1,678),(2178,1,679),(2179,1,680),(2180,1,681),(2181,1,682),(2182,1,683),(2183,1,684),(2184,1,685),(2185,1,686),(2186,1,687),(2187,1,688),(2188,1,689),(2189,1,690),(2190,1,691),(2191,1,692),(2192,1,693),(2193,1,694),(2194,1,695),(2195,1,696),(2196,1,697),(2197,1,698),(2198,1,699),(2199,1,700),(2200,1,701),(2201,1,702),(2202,1,703),(2203,1,704),(2204,1,705),(2205,1,706),(2206,1,707),(2207,1,708),(2208,1,709),(2209,1,710),(2210,1,711),(2211,1,712),(2212,1,713),(2213,1,714),(2214,1,715),(2215,1,716),(2216,1,717),(2217,1,718),(2218,1,719),(2219,1,720),(2220,1,721),(2221,1,722),(2222,1,723),(2223,1,724),(2224,1,725),(2225,1,726),(2226,1,727),(2227,1,728),(2228,1,729),(2229,1,730),(2230,1,731),(2231,1,732),(2232,1,733),(2233,1,734),(2234,1,735),(2235,1,736),(2236,1,737),(2237,1,738),(2238,1,739),(2239,1,740),(2240,1,741),(2241,1,742),(2242,1,743),(2243,1,744),(2244,1,745),(2245,1,746),(2246,1,747),(2247,1,748),(2248,1,749),(2249,1,750),(2250,1,751),(2251,1,752),(2252,1,753),(2253,1,754),(2254,1,755),(2255,1,756),(2256,1,757),(2257,1,758),(2258,1,759),(2259,1,760),(2260,1,761),(2261,1,762),(2262,1,763),(2263,1,764),(2264,1,765),(2265,1,766),(2266,1,767),(2267,1,768),(2268,1,769),(2269,1,770),(2270,1,771),(2271,1,772),(2272,1,773),(2273,1,774),(2274,1,775),(2275,1,776),(2276,1,777),(2277,1,778),(2278,1,779),(2279,1,780),(2280,1,781),(2281,1,782),(2282,1,783),(2283,1,784),(2284,1,785),(2285,1,786),(2286,1,787),(2287,1,788),(2288,1,789),(2289,1,790),(2290,1,791),(2291,1,792),(2292,1,793),(2293,1,794),(2294,1,795),(2295,1,796),(2296,1,797),(2297,1,798),(2298,1,799),(2299,1,800),(2300,1,801),(2301,1,802),(2302,1,803),(2303,1,804),(2304,1,805),(2305,1,806),(2306,1,807),(2307,1,808),(2308,1,809),(2309,1,810),(2310,1,811),(2311,1,812),(2312,1,813),(2313,1,814),(2314,1,815),(2315,1,816),(2316,1,817),(2317,1,818),(2318,1,819),(2319,1,820),(2320,1,821),(2321,1,822),(2322,1,823),(2323,1,824),(2324,1,825),(2325,1,826),(2326,1,827),(2327,1,828),(2328,1,829),(2329,1,830),(2330,1,831),(2331,1,832),(2332,1,833),(2333,1,834),(2334,1,835),(2335,1,836),(2336,1,837),(2337,1,838),(2338,1,839),(2339,1,840),(2340,1,841),(2341,1,842),(2342,1,843),(2343,1,844),(2344,1,845),(2345,1,846),(2346,1,847),(2347,1,848),(2348,1,849),(2349,1,850),(2350,1,851),(2351,1,852),(2352,1,853),(2353,1,854),(2354,1,855),(2355,1,856),(2356,1,857),(2357,1,858),(2358,1,859),(2359,1,860),(2360,1,861),(2361,1,862),(2362,1,863),(2363,1,864),(2364,1,865),(2365,1,866),(2366,1,867),(2367,1,868),(2368,1,869),(2369,1,420),(2370,1,421),(2371,1,422),(2372,1,423),(2373,1,424),(2374,1,425),(2375,1,426),(2376,1,427),(2377,1,428),(2378,1,429),(2379,1,430),(2380,1,431),(2381,1,432),(2382,1,433),(2383,1,434),(2384,1,435),(2385,1,436),(2386,1,437),(2387,1,438),(2388,1,439),(2389,1,440),(2390,1,441),(2391,1,442),(2392,1,443),(2393,1,444),(2394,1,445),(2395,1,446),(2396,1,447),(2397,1,448),(2398,1,449),(2399,1,450),(2400,1,451),(2401,1,452),(2402,1,453),(2403,1,454),(2404,1,455),(2405,1,456),(2406,1,457),(2407,1,458),(2408,1,459),(2409,1,460),(2410,1,461),(2411,1,462),(2412,1,463),(2413,1,464),(2414,1,465),(2415,1,466),(2416,1,467),(2417,1,468),(2418,1,469),(2419,1,470),(2420,1,471),(2421,1,472),(2422,1,473),(2423,1,474),(2424,1,475),(2425,1,476),(2426,1,477),(2427,1,478),(2428,1,479),(2429,1,480),(2430,1,481),(2431,1,482),(2432,1,483),(2433,1,484),(2434,1,485),(2435,1,486),(2436,1,487),(2437,1,488),(2438,1,489),(2439,1,490),(2440,1,491),(2441,1,492),(2442,1,493),(2443,1,494),(2444,1,495),(2445,1,496),(2446,1,497),(2447,1,498),(2448,1,499),(2449,1,500),(2450,1,501),(2451,1,502),(2452,1,503),(2453,1,504),(2454,1,505),(2455,1,506),(2456,1,507),(2457,1,508),(2458,1,509),(2459,1,510),(2460,1,511),(2461,1,512),(2462,1,513),(2463,1,514),(2464,1,515),(2465,1,516),(2466,1,517),(2467,1,518),(2468,1,519),(2469,1,520),(2470,1,521),(2471,1,522),(2472,1,523),(2473,1,524),(2474,1,525),(2475,1,526),(2476,1,527),(2477,1,528),(2478,1,529),(2479,1,530),(2480,1,531),(2481,1,532),(2482,1,533),(2483,1,534),(2484,1,535),(2485,1,536),(2486,1,537),(2487,1,538),(2488,1,539),(2489,1,540),(2490,1,541),(2491,1,542),(2492,1,543),(2493,1,544),(2494,1,545),(2495,1,546),(2496,1,547),(2497,1,548),(2498,1,549),(2499,1,550),(2500,1,551),(2501,1,552),(2502,1,553),(2503,1,554),(2504,1,555),(2505,1,556),(2506,1,557),(2507,1,558),(2508,1,559),(2509,1,560),(2510,1,561),(2511,1,562),(2512,1,563),(2513,1,564),(2514,1,565),(2515,1,566),(2516,1,567),(2517,1,568),(2518,1,569),(2519,1,570),(2520,1,571),(2521,1,572),(2522,1,573),(2523,1,574),(2524,1,575),(2525,1,576),(2526,1,577),(2527,1,578),(2528,1,579),(2529,1,580),(2530,1,581),(2531,1,582),(2532,1,583),(2533,1,584),(2534,1,585),(2535,1,586),(2536,1,587),(2537,1,588),(2538,1,589),(2539,1,590),(2540,1,591),(2541,1,592),(2542,1,593),(2543,1,594),(2544,1,595),(2545,1,596),(2546,1,597),(2547,1,598),(2548,1,599),(2549,1,600),(2550,1,601),(2551,1,602),(2552,1,603),(2553,1,604),(2554,1,605),(2555,1,606),(2556,1,607),(2557,1,608),(2558,1,609),(2559,1,610),(2560,1,611),(2561,1,612),(2562,1,613),(2563,1,614),(2564,1,615),(2565,1,616),(2566,1,617),(2567,1,618),(2568,1,619),(2569,1,419);

--
-- Table structure for table `tax_class`
--

CREATE TABLE `tax_class` (
  `tax_class_id` int(11) NOT NULL AUTO_INCREMENT,
  `tax_class_title` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `tax_class_description` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `last_modified` datetime DEFAULT NULL,
  `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`tax_class_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tax_class`
--

INSERT INTO `tax_class` (`tax_class_id`, `tax_class_title`, `tax_class_description`, `last_modified`, `date_added`) VALUES (1,'Standardsatz','','0000-00-00 00:00:00','2004-09-15 10:00:46'),(2,'ermaeßigter Steuersatz','','2013-04-30 17:49:09','2004-09-15 10:00:46');

--
-- Table structure for table `tax_rates`
--

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

--
-- Dumping data for table `tax_rates`
--

INSERT INTO `tax_rates` (`tax_rates_id`, `tax_zone_id`, `tax_class_id`, `tax_priority`, `tax_rate`, `tax_description`, `last_modified`, `date_added`) VALUES (1,5,1,1,19.0000,'UST 19%','2006-12-27 10:39:14','0000-00-00 00:00:00'),(2,5,2,1,7.0000,'UST 7%','0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,6,1,1,19.0000,'EU-AUS-UST 19%','2006-12-27 10:39:49','0000-00-00 00:00:00'),(4,6,2,1,7.0000,'EU-AUS-UST 7%','2006-12-27 10:40:04','0000-00-00 00:00:00');

--
-- Table structure for table `testeo`
--

CREATE TABLE `testeo` (
  `yourID` int(11) NOT NULL DEFAULT '0',
  `testeoGrade` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `sourceCode` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`yourID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `testeo`
--


--
-- Table structure for table `ts_rating`
--

CREATE TABLE `ts_rating` (
  `id` varchar(16) NOT NULL DEFAULT 'default',
  `tsid_de` varchar(33) NOT NULL,
  `tsid_de_enabled` tinyint(1) NOT NULL,
  `tsid_en` varchar(33) NOT NULL,
  `tsid_en_enabled` tinyint(1) NOT NULL,
  `tsid_fr` varchar(33) NOT NULL,
  `tsid_fr_enabled` tinyint(1) NOT NULL,
  `tsid_es` varchar(33) NOT NULL,
  `tsid_es_enabled` tinyint(1) NOT NULL,
  `tsid_pl` varchar(33) NOT NULL,
  `tsid_pl_enabled` tinyint(1) NOT NULL,
  `ts_widget` tinyint(1) NOT NULL,
  `ts_button` tinyint(1) NOT NULL,
  `ts_button_checkout` tinyint(1) NOT NULL,
  `ts_mail` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ts_rating`
--

INSERT INTO `ts_rating` (`id`, `tsid_de`, `tsid_de_enabled`, `tsid_en`, `tsid_en_enabled`, `tsid_fr`, `tsid_fr_enabled`, `tsid_es`, `tsid_es_enabled`, `tsid_pl`, `tsid_pl_enabled`, `ts_widget`, `ts_button`, `ts_button_checkout`, `ts_mail`) VALUES ('default','',0,'',0,'',0,'',0,'',0,0,0,0,0);

--
-- Table structure for table `units`
--

CREATE TABLE `units` (
  `units_id` int(11) NOT NULL AUTO_INCREMENT,
  `units_title` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`units_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `units`
--

INSERT INTO `units` (`units_id`, `units_title`) VALUES (1,'2er'),(2,'4er'),(3,'6er');

--
-- Table structure for table `units_description`
--

CREATE TABLE `units_description` (
  `units_description_id` int(11) NOT NULL AUTO_INCREMENT,
  `units_id` int(11) NOT NULL DEFAULT '0',
  `language_id` int(11) NOT NULL DEFAULT '0',
  `units_value` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`units_description_id`),
  KEY `units_id` (`units_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `units_description`
--

INSERT INTO `units_description` (`units_description_id`, `units_id`, `language_id`, `units_value`) VALUES (1,1,2,'2'),(2,2,2,'4'),(3,3,2,'6');

--
-- Table structure for table `whos_online`
--

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

--
-- Dumping data for table `whos_online`
--

INSERT INTO `whos_online` (`customer_id`, `full_name`, `session_id`, `ip_address`, `time_entry`, `time_last_click`, `last_page_url`) VALUES (0,'Guest','','','1544092670','1545252190','');

--
-- Table structure for table `wishlist_attributes`
--

CREATE TABLE `wishlist_attributes` (
  `attributes_id` int(11) NOT NULL AUTO_INCREMENT,
  `customers_id` int(11) NOT NULL DEFAULT '0',
  `wishlist_products_id` int(11) NOT NULL DEFAULT '0',
  `products_options_id` int(11) NOT NULL DEFAULT '0',
  `products_options_value_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`attributes_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wishlist_attributes`
--


--
-- Table structure for table `wishlist_customers`
--

CREATE TABLE `wishlist_customers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customers_id` int(11) NOT NULL DEFAULT '0',
  `create_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `memo` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `customers_id` (`customers_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wishlist_customers`
--

INSERT INTO `wishlist_customers` (`id`, `customers_id`, `create_date`, `memo`) VALUES (1,1,'2017-06-27 23:15:57',''),(2,5008,'2018-01-30 12:29:35','');

--
-- Table structure for table `wishlist_products`
--

CREATE TABLE `wishlist_products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `wishlist_customers_id` int(11) NOT NULL DEFAULT '0',
  `products_id` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `memo` text NOT NULL,
  `wishstatus` int(1) NOT NULL DEFAULT '0',
  `ordered` int(3) NOT NULL DEFAULT '0',
  `create_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `wishlist_customers_id` (`wishlist_customers_id`),
  KEY `products_id` (`products_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wishlist_products`
--

INSERT INTO `wishlist_products` (`id`, `wishlist_customers_id`, `products_id`, `quantity`, `memo`, `wishstatus`, `ordered`, `create_date`) VALUES (1,1,101,1,'',0,0,'2017-06-27 23:15:57'),(2,2,396,1,'',0,0,'2018-01-30 12:29:35');

--
-- Table structure for table `wrapping_counter`
--

CREATE TABLE `wrapping_counter` (
  `wrapping_counter_id` int(11) NOT NULL AUTO_INCREMENT,
  `orders_id` int(11) NOT NULL DEFAULT '0',
  `branches_id` int(11) NOT NULL DEFAULT '0',
  `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_fetched` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`wrapping_counter_id`),
  KEY `orders_id` (`orders_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wrapping_counter`
--

INSERT INTO `wrapping_counter` (`wrapping_counter_id`, `orders_id`, `branches_id`, `date_added`, `date_fetched`) VALUES (1,8,0,'2010-01-02 18:44:12','0000-00-00 00:00:00'),(2,12,0,'2010-03-25 19:52:43','0000-00-00 00:00:00'),(3,19,0,'2013-11-06 17:25:57','0000-00-00 00:00:00');

--
-- Table structure for table `yes_amazon_pay_authorization`
--

CREATE TABLE `yes_amazon_pay_authorization` (
  `yes_amazon_pay_authorization_id` int(11) NOT NULL AUTO_INCREMENT,
  `AuthorizationAmount_CurrencyCode` varchar(3) NOT NULL,
  `AuthorizationAmount_Amount` decimal(15,4) NOT NULL,
  `CapturedAmount_CurrencyCode` varchar(3) NOT NULL,
  `CapturedAmount_Amount` decimal(15,4) NOT NULL,
  `SoftDescriptor` varchar(32) NOT NULL,
  `IdList_member` varchar(64) NOT NULL,
  `SoftDecline` int(1) NOT NULL,
  `LastUpdateTimestamp` datetime NOT NULL,
  `State` varchar(16) NOT NULL,
  `AuthorizationFee_CurrencyCode` varchar(3) NOT NULL,
  `AuthorizationFee_Amount` decimal(15,4) NOT NULL,
  `AmazonAuthorizationId` varchar(64) NOT NULL,
  `AuthorizationReferenceId` varchar(64) NOT NULL,
  `OrderReferenceID` varchar(32) NOT NULL,
  `yes_amazon_pay_reference` varchar(32) NOT NULL,
  PRIMARY KEY (`yes_amazon_pay_authorization_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `yes_amazon_pay_authorization`
--


--
-- Table structure for table `yes_amazon_pay_refunds`
--

CREATE TABLE `yes_amazon_pay_refunds` (
  `yes_amazon_pay_refunds_id` int(11) NOT NULL AUTO_INCREMENT,
  `AmazonRefundId` varchar(32) NOT NULL,
  `RefundReferenceId` varchar(32) NOT NULL,
  `SellerRefundNote` text NOT NULL,
  `RefundType` varchar(32) NOT NULL,
  `Currency` varchar(3) NOT NULL,
  `RefundedAmount` decimal(15,4) NOT NULL,
  `FeeRefunded` decimal(15,4) NOT NULL,
  `RefundStatus` varchar(16) NOT NULL,
  `date_created` datetime NOT NULL,
  `yes_amazon_pay_reference_id` varchar(32) NOT NULL,
  PRIMARY KEY (`yes_amazon_pay_refunds_id`),
  KEY `yes_amazon_pay_reference_id` (`yes_amazon_pay_reference_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `yes_amazon_pay_refunds`
--


--
-- Table structure for table `yes_cron_export_heading_rows`
--

CREATE TABLE `yes_cron_export_heading_rows` (
  `yes_cron_export_heading_rows_id` int(11) NOT NULL AUTO_INCREMENT,
  `yes_cron_exports_id` int(11) NOT NULL,
  `sort_order` int(11) NOT NULL,
  `name` varchar(128) NOT NULL,
  PRIMARY KEY (`yes_cron_export_heading_rows_id`),
  KEY `yes_cron_exports_id` (`yes_cron_exports_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `yes_cron_export_heading_rows`
--


--
-- Table structure for table `yes_cron_exports`
--

CREATE TABLE `yes_cron_exports` (
  `yes_cron_exports_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `date_added` datetime NOT NULL,
  `last_export` datetime NOT NULL,
  `use_heading_row` int(1) NOT NULL,
  `ini_file` varchar(64) NOT NULL,
  `current_export` int(1) NOT NULL,
  `current_export_page` int(2) NOT NULL,
  `export_filename` varchar(64) NOT NULL,
  `export_linked_products` int(1) NOT NULL,
  `cat` varchar(255) NOT NULL,
  `allCat` int(1) NOT NULL,
  `distributors_id` int(11) NOT NULL,
  PRIMARY KEY (`yes_cron_exports_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `yes_cron_exports`
--


--
-- Table structure for table `yes_help`
--

CREATE TABLE `yes_help` (
  `help_id` int(11) NOT NULL AUTO_INCREMENT,
  `help_title` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `help_text` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `last_change` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`help_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `yes_help`
--


--
-- Table structure for table `yes_xmlrpc_import_config`
--

CREATE TABLE `yes_xmlrpc_import_config` (
  `yes_xmlrpc_import_config_id` int(11) NOT NULL AUTO_INCREMENT,
  `yes_xmlrpc_remote_token_id` int(11) NOT NULL,
  `languages` text NOT NULL,
  `manufacturers` text NOT NULL,
  `import_categories_id` int(11) NOT NULL,
  `shipping_statuses` text NOT NULL,
  `units` text NOT NULL,
  `products_vpe` text NOT NULL,
  PRIMARY KEY (`yes_xmlrpc_import_config_id`),
  KEY `yes_xmlrpc_token_id` (`yes_xmlrpc_remote_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `yes_xmlrpc_import_config`
--


--
-- Table structure for table `yes_xmlrpc_products`
--

CREATE TABLE `yes_xmlrpc_products` (
  `yes_xmlrpc_products_id` int(11) NOT NULL AUTO_INCREMENT,
  `yes_xmlrpc_remote_token_id` int(11) NOT NULL,
  `products_id` int(11) NOT NULL,
  `remote_products_id` int(11) NOT NULL,
  `date_added` datetime NOT NULL,
  `imported` int(1) NOT NULL,
  `remote_set_id` varchar(32) NOT NULL,
  PRIMARY KEY (`yes_xmlrpc_products_id`),
  KEY `yes_xmlrpc_remote_token_id` (`yes_xmlrpc_remote_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `yes_xmlrpc_products`
--


--
-- Table structure for table `yes_xmlrpc_remote_token`
--

CREATE TABLE `yes_xmlrpc_remote_token` (
  `yes_xmlrpc_remote_token_id` int(11) NOT NULL AUTO_INCREMENT,
  `token` varchar(32) NOT NULL,
  `token_alias` varchar(32) NOT NULL,
  `server` varchar(255) NOT NULL,
  `server_path` varchar(255) NOT NULL,
  `server_image_path` varchar(255) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`yes_xmlrpc_remote_token_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `yes_xmlrpc_remote_token`
--


--
-- Table structure for table `yes_xmlrpc_token`
--

CREATE TABLE `yes_xmlrpc_token` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `token` varchar(32) NOT NULL,
  `token_alias` varchar(32) NOT NULL,
  `date_added` datetime NOT NULL,
  `allowed_functions` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `yes_xmlrpc_token`
--


--
-- Table structure for table `zones`
--

CREATE TABLE `zones` (
  `zone_id` int(11) NOT NULL AUTO_INCREMENT,
  `zone_country_id` int(11) NOT NULL DEFAULT '0',
  `zone_code` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `zone_name` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`zone_id`)
) ENGINE=MyISAM AUTO_INCREMENT=848 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zones`
--

INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (1,223,'AL','Alabama'),(2,223,'AK','Alaska'),(3,223,'AS','American Samoa'),(4,223,'AZ','Arizona'),(5,223,'AR','Arkansas'),(6,223,'AF','Armed Forces Africa'),(7,223,'AA','Armed Forces Americas'),(8,223,'AC','Armed Forces Canada'),(9,223,'AE','Armed Forces Europe'),(10,223,'AM','Armed Forces Middle East'),(11,223,'AP','Armed Forces Pacific'),(12,223,'CA','California'),(13,223,'CO','Colorado'),(14,223,'CT','Connecticut'),(15,223,'DE','Delaware'),(16,223,'DC','District of Columbia'),(17,223,'FM','Federated States Of Micronesia'),(18,223,'FL','Florida'),(19,223,'GA','Georgia'),(20,223,'GU','Guam'),(21,223,'HI','Hawaii'),(22,223,'ID','Idaho'),(23,223,'IL','Illinois'),(24,223,'IN','Indiana'),(25,223,'IA','Iowa'),(26,223,'KS','Kansas'),(27,223,'KY','Kentucky'),(28,223,'LA','Louisiana'),(29,223,'ME','Maine'),(30,223,'MH','Marshall Islands'),(31,223,'MD','Maryland'),(32,223,'MA','Massachusetts'),(33,223,'MI','Michigan'),(34,223,'MN','Minnesota'),(35,223,'MS','Mississippi'),(36,223,'MO','Missouri'),(37,223,'MT','Montana'),(38,223,'NE','Nebraska'),(39,223,'NV','Nevada'),(40,223,'NH','New Hampshire'),(41,223,'NJ','New Jersey'),(42,223,'NM','New Mexico'),(43,223,'NY','New York'),(44,223,'NC','North Carolina'),(45,223,'ND','North Dakota'),(46,223,'MP','Northern Mariana Islands'),(47,223,'OH','Ohio'),(48,223,'OK','Oklahoma'),(49,223,'OR','Oregon'),(50,223,'PW','Palau'),(51,223,'PA','Pennsylvania'),(52,223,'PR','Puerto Rico'),(53,223,'RI','Rhode Island'),(54,223,'SC','South Carolina'),(55,223,'SD','South Dakota'),(56,223,'TN','Tennessee'),(57,223,'TX','Texas'),(58,223,'UT','Utah'),(59,223,'VT','Vermont'),(60,223,'VI','Virgin Islands'),(61,223,'VA','Virginia'),(62,223,'WA','Washington'),(63,223,'WV','West Virginia'),(64,223,'WI','Wisconsin'),(65,223,'WY','Wyoming'),(66,38,'AB','Alberta'),(67,38,'BC','British Columbia'),(68,38,'MB','Manitoba'),(69,38,'NF','Newfoundland'),(70,38,'NB','New Brunswick'),(71,38,'NS','Nova Scotia'),(72,38,'NT','Northwest Territories'),(73,38,'NU','Nunavut'),(74,38,'ON','Ontario'),(75,38,'PE','Prince Edward Island'),(76,38,'QC','Quebec'),(77,38,'SK','Saskatchewan'),(78,38,'YT','Yukon Territory'),(79,81,'NDS','Niedersachsen'),(80,81,'BAW','Baden-Württemberg'),(81,81,'BAY','Bayern'),(82,81,'BER','Berlin'),(83,81,'BRG','Brandenburg'),(84,81,'BRE','Bremen'),(85,81,'HAM','Hamburg'),(86,81,'HES','Hessen'),(87,81,'MEC','Mecklenburg-Vorpommern'),(88,81,'NRW','Nordrhein-Westfalen'),(89,81,'RHE','Rheinland-Pfalz'),(90,81,'SAR','Saarland'),(91,81,'SAS','Sachsen'),(92,81,'SAC','Sachsen-Anhalt'),(93,81,'SCN','Schleswig-Holstein'),(94,81,'THE','Thüringen'),(95,14,'WI','Wien'),(96,14,'NO','NiederÃƒÂƒÃââ'),(97,14,'OO','OberÃƒÂƒÃâ€'),(98,14,'SB','Salzburg'),(99,14,'KN','KÃƒÂƒÃ‚Ã'),(100,14,'ST','Steiermark'),(101,14,'TI','Tirol'),(102,14,'BL','Burgenland'),(103,14,'VB','Voralberg'),(104,204,'AG','Aargau'),(105,204,'AI','Appenzell Innerrhoden'),(106,204,'AR','Appenzell Ausserrhoden'),(107,204,'BE','Bern'),(108,204,'BL','Basel-Landschaft'),(109,204,'BS','Basel-Stadt'),(110,204,'FR','Freiburg'),(111,204,'GE','Genf'),(112,204,'GL','Glarus'),(113,204,'JU','GraubÃƒÂƒÃââ‚'),(114,204,'JU','Jura'),(115,204,'LU','Luzern'),(116,204,'NE','Neuenburg'),(117,204,'NW','Nidwalden'),(118,204,'OW','Obwalden'),(119,204,'SG','St. Gallen'),(120,204,'SH','Schaffhausen'),(121,204,'SO','Solothurn'),(122,204,'SZ','Schwyz'),(123,204,'TG','Thurgau'),(124,204,'TI','Tessin'),(125,204,'UR','Uri'),(126,204,'VD','Waadt'),(127,204,'VS','Wallis'),(128,204,'ZG','Zug'),(129,204,'ZH','ZÃƒÂƒÃ‚Ã'),(130,195,'A CoruÃƒÂƒÃââ','A CoruÃƒÂƒÃââ'),(131,195,'Alava','Alava'),(132,195,'Albacete','Albacete'),(133,195,'Alicante','Alicante'),(134,195,'Almeria','Almeria'),(135,195,'Asturias','Asturias'),(136,195,'Avila','Avila'),(137,195,'Badajoz','Badajoz'),(138,195,'Baleares','Baleares'),(139,195,'Barcelona','Barcelona'),(140,195,'Burgos','Burgos'),(141,195,'Caceres','Caceres'),(142,195,'Cadiz','Cadiz'),(143,195,'Cantabria','Cantabria'),(144,195,'Castellon','Castellon'),(145,195,'Ceuta','Ceuta'),(146,195,'Ciudad Real','Ciudad Real'),(147,195,'Cordoba','Cordoba'),(148,195,'Cuenca','Cuenca'),(149,195,'Girona','Girona'),(150,195,'Granada','Granada'),(151,195,'Guadalajara','Guadalajara'),(152,195,'Guipuzcoa','Guipuzcoa'),(153,195,'Huelva','Huelva'),(154,195,'Huesca','Huesca'),(155,195,'Jaen','Jaen'),(156,195,'La Rioja','La Rioja'),(157,195,'Las Palmas','Las Palmas'),(158,195,'Leon','Leon'),(159,195,'Lleida','Lleida'),(160,195,'Lugo','Lugo'),(161,195,'Madrid','Madrid'),(162,195,'Malaga','Malaga'),(163,195,'Melilla','Melilla'),(164,195,'Murcia','Murcia'),(165,195,'Navarra','Navarra'),(166,195,'Ourense','Ourense'),(167,195,'Palencia','Palencia'),(168,195,'Pontevedra','Pontevedra'),(169,195,'Salamanca','Salamanca'),(170,195,'Santa Cruz de Tenerife','Santa Cruz de Tenerife'),(171,195,'Segovia','Segovia'),(172,195,'Sevilla','Sevilla'),(173,195,'Soria','Soria'),(174,195,'Tarragona','Tarragona'),(175,195,'Teruel','Teruel'),(176,195,'Toledo','Toledo'),(177,195,'Valencia','Valencia'),(178,195,'Valladolid','Valladolid'),(179,195,'Vizcaya','Vizcaya'),(180,195,'Zamora','Zamora'),(181,195,'Zaragoza','Zaragoza'),(182,13,'NSW','New South Wales'),(183,13,'VIC','Victoria'),(184,13,'QLD','Queensland'),(185,13,'NT','Northern Territory'),(186,13,'WA','Western Australia'),(187,13,'SA','South Australia'),(188,13,'TAS','Tasmania'),(189,13,'ACT','Australian Capital Territory'),(190,153,'Northland','Northland'),(191,153,'Auckland','Auckland'),(192,153,'Waikato','Waikato'),(193,153,'Bay of Plenty','Bay of Plenty'),(194,153,'Gisborne','Gisborne'),(195,153,'Hawkes Bay','Hawkes Bay'),(196,153,'Taranaki','Taranaki'),(197,153,'Manawatu-Wanganui','Manawatu-Wanganui'),(198,153,'Wellington','Wellington'),(199,153,'West Coast','West Coast'),(200,153,'Canterbury','Canterbury'),(201,153,'Otago','Otago'),(202,153,'Southland','Southland'),(203,153,'Tasman','Tasman'),(204,153,'Nelson','Nelson'),(205,153,'Marlborough','Marlborough'),(206,30,'SP','SÃƒÂƒÃ‚Ã'),(207,30,'RJ','Rio de Janeiro'),(208,30,'PE','Pernanbuco'),(209,30,'BA','Bahia'),(210,30,'AM','Amazonas'),(211,30,'MG','Minas Gerais'),(212,30,'ES','Espirito Santo'),(213,30,'RS','Rio Grande do Sul'),(214,30,'PR','ParanÃƒÂƒÃââ‚'),(215,30,'SC','Santa Catarina'),(216,30,'RG','Rio Grande do Norte'),(217,30,'MS','Mato Grosso do Sul'),(218,30,'MT','Mato Grosso'),(219,30,'GO','Goias'),(220,30,'TO','Tocantins'),(221,30,'DF','Distrito Federal'),(222,30,'RO','Rondonia'),(223,30,'AC','Acre'),(224,30,'AP','Amapa'),(225,30,'RO','Roraima'),(226,30,'AL','Alagoas'),(227,30,'CE','CearÃƒÂƒÃâ€'),(228,30,'MA','MaranhÃƒÂƒÃââ'),(229,30,'PA','ParÃƒÂƒÃâ€Å'),(230,30,'PB','ParaÃƒÂƒÃâ€'),(231,30,'PI','PiauÃƒÂƒÃâ€'),(232,30,'SE','Sergipe'),(233,43,'I','I RegiÃƒÂƒÃââ'),(234,43,'II','II RegiÃƒÂƒÃâ'),(235,43,'III','III RegiÃƒÂƒÃÃ'),(236,43,'IV','IV RegiÃƒÂƒÃâ'),(237,43,'V','V RegiÃƒÂƒÃââ'),(238,43,'RM','RegiÃƒÂƒÃâ€'),(239,43,'VI','VI RegiÃƒÂƒÃâ'),(240,43,'VII','VII RegiÃƒÂƒÃÃ'),(241,43,'VIII','VIII RegiÃƒÂƒÃ'),(242,43,'IX','IX RegiÃƒÂƒÃâ'),(243,43,'X','X RegiÃƒÂƒÃââ'),(244,43,'XI','XI RegiÃƒÂƒÃâ'),(245,43,'XII','XII RegiÃƒÂƒÃÃ'),(246,47,'AMA','Amazonas'),(247,47,'ANT','Antioquia'),(248,47,'ARA','Arauca'),(249,47,'ATL','Atlantico'),(250,47,'BOL','Bolivar'),(251,47,'BOY','Boyaca'),(252,47,'CAL','Caldas'),(253,47,'CAQ','Caqueta'),(254,47,'CAS','Casanare'),(255,47,'CAU','Cauca'),(256,47,'CES','Cesar'),(257,47,'CHO','Choco'),(258,47,'COR','Cordoba'),(259,47,'CUN','Cundinamarca'),(260,47,'HUI','Huila'),(261,47,'GUA','Guainia'),(262,47,'GUA','Guajira'),(263,47,'GUV','Guaviare'),(264,47,'MAG','Magdalena'),(265,47,'MET','Meta'),(266,47,'NAR','Narino'),(267,47,'NDS','Norte de Santander'),(268,47,'PUT','Putumayo'),(269,47,'QUI','Quindio'),(270,47,'RIS','Risaralda'),(271,47,'SAI','San Andres Islas'),(272,47,'SAN','Santander'),(273,47,'SUC','Sucre'),(274,47,'TOL','Tolima'),(275,47,'VAL','Valle'),(276,47,'VAU','Vaupes'),(277,47,'VIC','Vichada'),(278,73,'Et','Etranger'),(279,73,'01','Ain'),(280,73,'02','Aisne'),(281,73,'03','Allier'),(282,73,'04','Alpes de Haute Provence'),(283,73,'05','Hautes-Alpes'),(284,73,'06','Alpes Maritimes'),(285,73,'07','Ard?che'),(286,73,'08','Ardennes'),(287,73,'09','Ari?ge'),(288,73,'10','Aube'),(289,73,'11','Aude'),(290,73,'12','Aveyron'),(291,73,'13','Bouches du Rh?ne'),(292,73,'14','Calvados'),(293,73,'15','Cantal'),(294,73,'16','Charente'),(295,73,'17','Charente Maritime'),(296,73,'18','Cher'),(297,73,'19','Corr?ze'),(298,73,'2A','Corse du Sud'),(299,73,'2B','Haute Corse'),(300,73,'21','C?te d\'or'),(301,73,'22','C?tes d\'Armor'),(302,73,'23','Creuse'),(303,73,'24','Dordogne'),(304,73,'25','Doubs'),(305,73,'26','Dr?me'),(306,73,'27','Eure'),(307,73,'28','Eure et Loir'),(308,73,'29','Finist?re'),(309,73,'30','Gard'),(310,73,'31','Haute Garonne'),(311,73,'32','Gers'),(312,73,'33','Gironde'),(313,73,'34','H?rault'),(314,73,'35','Ille et Vilaine'),(315,73,'36','Indre'),(316,73,'37','Indre et Loire'),(317,73,'38','Is?re'),(318,73,'39','Jura'),(319,73,'40','Landes'),(320,73,'41','Loir et Cher'),(321,73,'42','Loire'),(322,73,'43','Haute Loire'),(323,73,'44','Loire Atlantique'),(324,73,'45','Loiret'),(325,73,'46','Lot'),(326,73,'47','Lot et Garonne'),(327,73,'48','Loz?re'),(328,73,'49','Maine et Loire'),(329,73,'50','Manche'),(330,73,'51','Marne'),(331,73,'52','Haute Marne'),(332,73,'53','Mayenne'),(333,73,'54','Meurthe et Moselle'),(334,73,'55','Meuse'),(335,73,'56','Morbihan'),(336,73,'57','Moselle'),(337,73,'58','Ni?vre'),(338,73,'59','Nord'),(339,73,'60','Oise'),(340,73,'61','Orne'),(341,73,'62','Pas de Calais'),(342,73,'63','Puy de D?me'),(343,73,'64','Pyr?n?es Atlantiques'),(344,73,'65','Hautes Pyr?n?es'),(345,73,'66','Pyr?n?es Orientales'),(346,73,'67','Bas Rhin'),(347,73,'68','Haut Rhin'),(348,73,'69','Rh?ne'),(349,73,'70','Haute Sa?ne'),(350,73,'71','Sa?ne et Loire'),(351,73,'72','Sarthe'),(352,73,'73','Savoie'),(353,73,'74','Haute Savoie'),(354,73,'75','Paris'),(355,73,'76','Seine Maritime'),(356,73,'77','Seine et Marne'),(357,73,'78','Yvelines'),(358,73,'79','Deux S?vres'),(359,73,'80','Somme'),(360,73,'81','Tarn'),(361,73,'82','Tarn et Garonne'),(362,73,'83','Var'),(363,73,'84','Vaucluse'),(364,73,'85','Vend?e'),(365,73,'86','Vienne'),(366,73,'87','Haute Vienne'),(367,73,'88','Vosges'),(368,73,'89','Yonne'),(369,73,'90','Territoire de Belfort'),(370,73,'91','Essonne'),(371,73,'92','Hauts de Seine'),(372,73,'93','Seine St-Denis'),(373,73,'94','Val de Marne'),(374,73,'95','Val d\'Oise'),(375,73,'971 (DOM)','Guadeloupe'),(376,73,'972 (DOM)','Martinique'),(377,73,'973 (DOM)','Guyane'),(378,73,'974 (DOM)','Saint Denis'),(379,73,'975 (DOM)','St-Pierre de Miquelon'),(380,73,'976 (TOM)','Mayotte'),(381,73,'984 (TOM)','Terres australes et Antartiques'),(382,73,'985 (TOM)','Nouvelle Cal?donie'),(383,73,'986 (TOM)','Wallis et Futuna'),(384,73,'987 (TOM)','Polyn?sie fran?aise'),(385,99,'DL','Delhi'),(386,99,'MH','Maharashtra'),(387,99,'TN','Tamil Nadu'),(388,99,'KL','Kerala'),(389,99,'AP','Andhra Pradesh'),(390,99,'KA','Karnataka'),(391,99,'GA','Goa'),(392,99,'MP','Madhya Pradesh'),(393,99,'PY','Pondicherry'),(394,99,'GJ','Gujarat'),(395,99,'OR','Orrisa'),(396,99,'CA','Chhatisgarh'),(397,99,'JH','Jharkhand'),(398,99,'BR','Bihar'),(399,99,'WB','West Bengal'),(400,99,'UP','Uttar Pradesh'),(401,99,'RJ','Rajasthan'),(402,99,'PB','Punjab'),(403,99,'HR','Haryana'),(404,99,'CH','Chandigarh'),(405,99,'JK','Jammu & Kashmir'),(406,99,'HP','Himachal Pradesh'),(407,99,'UA','Uttaranchal'),(408,99,'LK','Lakshadweep'),(409,99,'AN','Andaman & Nicobar'),(410,99,'MG','Meghalaya'),(411,99,'AS','Assam'),(412,99,'DR','Dadra & Nagar Haveli'),(413,99,'DN','Daman & Diu'),(414,99,'SK','Sikkim'),(415,99,'TR','Tripura'),(416,99,'MZ','Mizoram'),(417,99,'MN','Manipur'),(418,99,'NL','Nagaland'),(419,99,'AR','Arunachal Pradesh'),(420,105,'AG','Agrigento'),(421,105,'AL','Alessandria'),(422,105,'AN','Ancona'),(423,105,'AO','Aosta'),(424,105,'AR','Arezzo'),(425,105,'AP','Ascoli Piceno'),(426,105,'AT','Asti'),(427,105,'AV','Avellino'),(428,105,'BA','Bari'),(429,105,'BL','Belluno'),(430,105,'BN','Benevento'),(431,105,'BG','Bergamo'),(432,105,'BI','Biella'),(433,105,'BO','Bologna'),(434,105,'BZ','Bolzano'),(435,105,'BS','Brescia'),(436,105,'BR','Brindisi'),(437,105,'CA','Cagliari'),(438,105,'CL','Caltanissetta'),(439,105,'CB','Campobasso'),(440,105,'CE','Caserta'),(441,105,'CT','Catania'),(442,105,'CZ','Catanzaro'),(443,105,'CH','Chieti'),(444,105,'CO','Como'),(445,105,'CS','Cosenza'),(446,105,'CR','Cremona'),(447,105,'KR','Crotone'),(448,105,'CN','Cuneo'),(449,105,'EN','Enna'),(450,105,'FE','Ferrara'),(451,105,'FI','Firenze'),(452,105,'FG','Foggia'),(453,105,'FO','ForlÃƒÂƒÃâ€'),(454,105,'FR','Frosinone'),(455,105,'GE','Genova'),(456,105,'GO','Gorizia'),(457,105,'GR','Grosseto'),(458,105,'IM','Imperia'),(459,105,'IS','Isernia'),(460,105,'AQ','Aquila'),(461,105,'SP','La Spezia'),(462,105,'LT','Latina'),(463,105,'LE','Lecce'),(464,105,'LC','Lecco'),(465,105,'LI','Livorno'),(466,105,'LO','Lodi'),(467,105,'LU','Lucca'),(468,105,'MC','Macerata'),(469,105,'MN','Mantova'),(470,105,'MS','Massa-Carrara'),(471,105,'MT','Matera'),(472,105,'ME','Messina'),(473,105,'MI','Milano'),(474,105,'MO','Modena'),(475,105,'NA','Napoli'),(476,105,'NO','Novara'),(477,105,'NU','Nuoro'),(478,105,'OR','Oristano'),(479,105,'PD','Padova'),(480,105,'PA','Palermo'),(481,105,'PR','Parma'),(482,105,'PG','Perugia'),(483,105,'PV','Pavia'),(484,105,'PS','Pesaro e Urbino'),(485,105,'PE','Pescara'),(486,105,'PC','Piacenza'),(487,105,'PI','Pisa'),(488,105,'PT','Pistoia'),(489,105,'PN','Pordenone'),(490,105,'PZ','Potenza'),(491,105,'PO','Prato'),(492,105,'RG','Ragusa'),(493,105,'RA','Ravenna'),(494,105,'RC','Reggio di Calabria'),(495,105,'RE','Reggio Emilia'),(496,105,'RI','Rieti'),(497,105,'RN','Rimini'),(498,105,'RM','Roma'),(499,105,'RO','Rovigo'),(500,105,'SA','Salerno'),(501,105,'SS','Sassari'),(502,105,'SV','Savona'),(503,105,'SI','Siena'),(504,105,'SR','Siracusa'),(505,105,'SO','Sondrio'),(506,105,'TA','Taranto'),(507,105,'TE','Teramo'),(508,105,'TR','Terni'),(509,105,'TO','Torino'),(510,105,'TP','Trapani'),(511,105,'TN','Trento'),(512,105,'TV','Treviso'),(513,105,'TS','Trieste'),(514,105,'UD','Udine'),(515,105,'VA','Varese'),(516,105,'VE','Venezia'),(517,105,'VB','Verbania'),(518,105,'VC','Vercelli'),(519,105,'VR','Verona'),(520,105,'VV','Vibo Valentia'),(521,105,'VI','Vicenza'),(522,105,'VT','Viterbo'),(523,107,'Niigata','Niigata'),(524,107,'Toyama','Toyama'),(525,107,'Ishikawa','Ishikawa'),(526,107,'Fukui','Fukui'),(527,107,'Yamanashi','Yamanashi'),(528,107,'Nagano','Nagano'),(529,107,'Gifu','Gifu'),(530,107,'Shizuoka','Shizuoka'),(531,107,'Aichi','Aichi'),(532,107,'Mie','Mie'),(533,107,'Shiga','Shiga'),(534,107,'Kyoto','Kyoto'),(535,107,'Osaka','Osaka'),(536,107,'Hyogo','Hyogo'),(537,107,'Nara','Nara'),(538,107,'Wakayama','Wakayama'),(539,107,'Tottori','Tottori'),(540,107,'Shimane','Shimane'),(541,107,'Okayama','Okayama'),(542,107,'Hiroshima','Hiroshima'),(543,107,'Yamaguchi','Yamaguchi'),(544,107,'Tokushima','Tokushima'),(545,107,'Kagawa','Kagawa'),(546,107,'Ehime','Ehime'),(547,107,'Kochi','Kochi'),(548,107,'Fukuoka','Fukuoka'),(549,107,'Saga','Saga'),(550,107,'Nagasaki','Nagasaki'),(551,107,'Kumamoto','Kumamoto'),(552,107,'Oita','Oita'),(553,107,'Miyazaki','Miyazaki'),(554,107,'Kagoshima','Kagoshima'),(555,129,'JOH','Johor'),(556,129,'KDH','Kedah'),(557,129,'KEL','Kelantan'),(558,129,'KL','Kuala Lumpur'),(559,129,'MEL','Melaka'),(560,129,'NS','Negeri Sembilan'),(561,129,'PAH','Pahang'),(562,129,'PRK','Perak'),(563,129,'PER','Perlis'),(564,129,'PP','Pulau Pinang'),(565,129,'SAB','Sabah'),(566,129,'SWK','Sarawak'),(567,129,'SEL','Selangor'),(568,129,'TER','Terengganu'),(569,129,'LAB','W.P.Labuan'),(570,138,'AGS','Aguascalientes'),(571,138,'BC','Baja California'),(572,138,'BCS','Baja California Sur'),(573,138,'CAM','Campeche'),(574,138,'COA','Coahuila'),(575,138,'COL','Colima'),(576,138,'CHI','Chiapas'),(577,138,'CHIH','Chihuahua'),(578,138,'DF','Distrito Federal'),(579,138,'DGO','Durango'),(580,138,'MEX','Estado de Mexico'),(581,138,'GTO','Guanajuato'),(582,138,'GRO','Guerrero'),(583,138,'HGO','Hidalgo'),(584,138,'JAL','Jalisco'),(585,138,'MCH','Michoacan'),(586,138,'MOR','Morelos'),(587,138,'NAY','Nayarit'),(588,138,'NL','Nuevo Leon'),(589,138,'OAX','Oaxaca'),(590,138,'PUE','Puebla'),(591,138,'QRO','Queretaro'),(592,138,'QR','Quintana Roo'),(593,138,'SLP','San Luis Potosi'),(594,138,'SIN','Sinaloa'),(595,138,'SON','Sonora'),(596,138,'TAB','Tabasco'),(597,138,'TMPS','Tamaulipas'),(598,138,'TLAX','Tlaxcala'),(599,138,'VER','Veracruz'),(600,138,'YUC','Yucatan'),(601,138,'ZAC','Zacatecas'),(602,160,'OSL','Oslo'),(603,160,'AKE','Akershus'),(604,160,'AUA','Aust-Agder'),(605,160,'BUS','Buskerud'),(606,160,'FIN','Finnmark'),(607,160,'HED','Hedmark'),(608,160,'HOR','Hordaland'),(609,160,'MOR','MÃƒÂƒÃ‚Ã'),(610,160,'NOR','Nordland'),(611,160,'NTR','Nord-TrÃƒÂƒÃâ'),(612,160,'OPP','Oppland'),(613,160,'ROG','Rogaland'),(614,160,'SOF','Sogn og Fjordane'),(615,160,'STR','SÃƒÂƒÃ‚Ã'),(616,160,'TEL','Telemark'),(617,160,'TRO','Troms'),(618,160,'VEA','Vest-Agder'),(619,160,'OST','ÃƒÂƒÃ‚Ã'),(620,160,'SVA','Svalbard'),(621,99,'KHI','Karachi'),(622,99,'LH','Lahore'),(623,99,'ISB','Islamabad'),(624,99,'QUE','Quetta'),(625,99,'PSH','Peshawar'),(626,99,'GUJ','Gujrat'),(627,99,'SAH','Sahiwal'),(628,99,'FSB','Faisalabad'),(629,99,'RIP','Rawal Pindi'),(630,175,'AB','Alba'),(631,175,'AR','Arad'),(632,175,'AG','Arges'),(633,175,'BC','Bacau'),(634,175,'BH','Bihor'),(635,175,'BN','Bistrita-Nasaud'),(636,175,'BT','Botosani'),(637,175,'BV','Brasov'),(638,175,'BR','Braila'),(639,175,'B','Bucuresti'),(640,175,'BZ','Buzau'),(641,175,'CS','Caras-Severin'),(642,175,'CL','Calarasi'),(643,175,'CJ','Cluj'),(644,175,'CT','Constanta'),(645,175,'CV','Covasna'),(646,175,'DB','Dimbovita'),(647,175,'DJ','Dolj'),(648,175,'GL','Galati'),(649,175,'GR','Giurgiu'),(650,175,'GJ','Gorj'),(651,175,'HR','Harghita'),(652,175,'HD','Hunedoara'),(653,175,'IL','Ialomita'),(654,175,'IS','Iasi'),(655,175,'IF','Ilfov'),(656,175,'MM','Maramures'),(657,175,'MH','Mehedint'),(658,175,'MS','Mures'),(659,175,'NT','Neamt'),(660,175,'OT','Olt'),(661,175,'PH','Prahova'),(662,175,'SM','Satu-Mare'),(663,175,'SJ','Salaj'),(664,175,'SB','Sibiu'),(665,175,'SV','Suceava'),(666,175,'TR','Teleorman'),(667,175,'TM','Timis'),(668,175,'TL','Tulcea'),(669,175,'VS','Vaslui'),(670,175,'VL','Valcea'),(671,175,'VN','Vrancea'),(672,193,'WP','Western Cape'),(673,193,'GP','Gauteng'),(674,193,'KZN','Kwazulu-Natal'),(675,193,'NC','Northern-Cape'),(676,193,'EC','Eastern-Cape'),(677,193,'MP','Mpumalanga'),(678,193,'NW','North-West'),(679,193,'FS','Free State'),(680,193,'NP','Northern Province'),(681,215,'ADANA','ADANA'),(682,215,'ADIYAMAN','ADIYAMAN'),(683,215,'AFYON','AFYON'),(684,215,'AGRI','AGRI'),(685,215,'AMASYA','AMASYA'),(686,215,'ANKARA','ANKARA'),(687,215,'ANTALYA','ANTALYA'),(688,215,'ARTVIN','ARTVIN'),(689,215,'AYDIN','AYDIN'),(690,215,'BALIKESIR','BALIKESIR'),(691,215,'BILECIK','BILECIK'),(692,215,'BINGÃƒÂƒÃâ€','BINGÃƒÂƒÃâ€'),(693,215,'BITLIS','BITLIS'),(694,215,'BOLU','BOLU'),(695,215,'BURDUR','BURDUR'),(696,215,'BURSA','BURSA'),(697,215,'ÃƒÂƒÃ‚Ã','ÃƒÂƒÃ‚Ã'),(698,215,'ÃƒÂƒÃ‚Ã','ÃƒÂƒÃ‚Ã'),(699,215,'ÃƒÂƒÃ‚Ã','ÃƒÂƒÃ‚Ã'),(700,215,'DENIZLI','DENIZLI'),(701,215,'DIYARBAKIR','DIYARBAKIR'),(702,215,'EDIRNE','EDIRNE'),(703,215,'ELAZIG','ELAZIG'),(704,215,'ERZINCAN','ERZINCAN'),(705,215,'ERZURUM','ERZURUM'),(706,215,'ESKISEHIR','ESKISEHIR'),(707,215,'GAZIANTEP','GAZIANTEP'),(708,215,'GIRESUN','GIRESUN'),(709,215,'GÃƒÂƒÃ‚Ã','GÃƒÂƒÃ‚Ã'),(710,215,'HAKKARI','HAKKARI'),(711,215,'HATAY','HATAY'),(712,215,'ISPARTA','ISPARTA'),(713,215,'IÃƒÂƒÃ‚Ã','IÃƒÂƒÃ‚Ã'),(714,215,'ISTANBUL','ISTANBUL'),(715,215,'IZMIR','IZMIR'),(716,215,'KARS','KARS'),(717,215,'KASTAMONU','KASTAMONU'),(718,215,'KAYSERI','KAYSERI'),(719,215,'KIRKLARELI','KIRKLARELI'),(720,215,'KIRSEHIR','KIRSEHIR'),(721,215,'KOCAELI','KOCAELI'),(722,215,'KONYA','KONYA'),(723,215,'KÃƒÂƒÃ‚Ã','KÃƒÂƒÃ‚Ã'),(724,215,'MALATYA','MALATYA'),(725,215,'MANISA','MANISA'),(726,215,'KAHRAMANMARAS','KAHRAMANMARAS'),(727,215,'MARDIN','MARDIN'),(728,215,'MUGLA','MUGLA'),(729,215,'MUS','MUS'),(730,215,'NEVSEHIR','NEVSEHIR'),(731,215,'NIGDE','NIGDE'),(732,215,'ORDU','ORDU'),(733,215,'RIZE','RIZE'),(734,215,'SAKARYA','SAKARYA'),(735,215,'SAMSUN','SAMSUN'),(736,215,'SIIRT','SIIRT'),(737,215,'SINOP','SINOP'),(738,215,'SIVAS','SIVAS'),(739,215,'TEKIRDAG','TEKIRDAG'),(740,215,'TOKAT','TOKAT'),(741,215,'TRABZON','TRABZON'),(742,215,'TUNCELI','TUNCELI'),(743,215,'SANLIURFA','SANLIURFA'),(744,215,'USAK','USAK'),(745,215,'VAN','VAN'),(746,215,'YOZGAT','YOZGAT'),(747,215,'ZONGULDAK','ZONGULDAK'),(748,215,'AKSARAY','AKSARAY'),(749,215,'BAYBURT','BAYBURT'),(750,215,'KARAMAN','KARAMAN'),(751,215,'KIRIKKALE','KIRIKKALE'),(752,215,'BATMAN','BATMAN'),(753,215,'SIRNAK','SIRNAK'),(754,215,'BARTIN','BARTIN'),(755,215,'ARDAHAN','ARDAHAN'),(756,215,'IGDIR','IGDIR'),(757,215,'YALOVA','YALOVA'),(758,215,'KARABÃƒÂƒÃââ‚','KARABÃƒÂƒÃââ‚'),(759,215,'KILIS','KILIS'),(760,215,'OSMANIYE','OSMANIYE'),(761,215,'DÃƒÂƒÃ‚Ã','DÃƒÂƒÃ‚Ã'),(762,229,'AM','Amazonas'),(763,229,'AN','AnzoÃƒÂƒÃâ€'),(764,229,'AR','Aragua'),(765,229,'AP','Apure'),(766,229,'BA','Barinas'),(767,229,'BO','BolÃƒÂƒÃâ€Å'),(768,229,'CA','Carabobo'),(769,229,'CO','Cojedes'),(770,229,'DA','Delta Amacuro'),(771,229,'DC','Distrito Capital'),(772,229,'FA','FalcÃƒÂƒÃâ€'),(773,229,'GA','GuÃƒÂƒÃ‚'),(774,229,'GU','Guayana'),(775,229,'LA','Lara'),(776,229,'ME','MÃƒÂƒÃ‚Ã'),(777,229,'MI','Miranda'),(778,229,'MO','Monagas'),(779,229,'NE','Nueva Esparta'),(780,229,'PO','Portuguesa'),(781,229,'SU','Sucre'),(782,229,'TA','TÃƒÂƒÃ‚Ã'),(783,229,'TU','Trujillo'),(784,229,'VA','Vargas'),(785,229,'YA','Yaracuy'),(786,229,'ZU','Zulia'),(787,222,'AVON','Avon'),(788,222,'BEDS','Bedfordshire'),(789,222,'BERK','Berkshire'),(790,222,'BIRM','Birmingham'),(791,222,'BORD','Borders'),(792,222,'BUCK','Buckinghamshire'),(793,222,'CAMB','Cambridgeshire'),(794,222,'CENT','Central'),(795,222,'CHES','Cheshire'),(796,222,'CLEV','Cleveland'),(797,222,'CLWY','Clwyd'),(798,222,'CORN','Cornwall'),(799,222,'CUMB','Cumbria'),(800,222,'DERB','Derbyshire'),(801,222,'DEVO','Devon'),(802,222,'DORS','Dorset'),(803,222,'DUMF','Dumfries & Galloway'),(804,222,'DURH','Durham'),(805,222,'DYFE','Dyfed'),(806,222,'ESUS','East Sussex'),(807,222,'ESSE','Essex'),(808,222,'FIFE','Fife'),(809,222,'GLAM','Glamorgan'),(810,222,'GLOU','Gloucestershire'),(811,222,'GRAM','Grampian'),(812,222,'GWEN','Gwent'),(813,222,'GWYN','Gwynedd'),(814,222,'HAMP','Hampshire'),(815,222,'HERE','Hereford & Worcester'),(816,222,'HERT','Hertfordshire'),(817,222,'HUMB','Humberside'),(818,222,'KENT','Kent'),(819,222,'LANC','Lancashire'),(820,222,'LEIC','Leicestershire'),(821,222,'LINC','Lincolnshire'),(822,222,'LOND','London'),(823,222,'LOTH','Lothian'),(824,222,'MANC','Manchester'),(825,222,'MERS','Merseyside'),(826,222,'NORF','Norfolk'),(827,222,'NYOR','North Yorkshire'),(828,222,'NWHI','North west Highlands'),(829,222,'NHAM','Northamptonshire'),(830,222,'NUMB','Northumberland'),(831,222,'NOTT','Nottinghamshire'),(832,222,'OXFO','Oxfordshire'),(833,222,'POWY','Powys'),(834,222,'SHRO','Shropshire'),(835,222,'SOME','Somerset'),(836,222,'SYOR','South Yorkshire'),(837,222,'STAF','Staffordshire'),(838,222,'STRA','Strathclyde'),(839,222,'SUFF','Suffolk'),(840,222,'SURR','Surrey'),(841,222,'WSUS','West Sussex'),(842,222,'TAYS','Tayside'),(843,222,'TYWE','Tyne & Wear'),(844,222,'WARW','Warwickshire'),(845,222,'WISL','West Isles'),(846,222,'WYOR','West Yorkshire'),(847,222,'WILT','Wiltshire');

--
-- Table structure for table `zones_to_geo_zones`
--

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

--
-- Dumping data for table `zones_to_geo_zones`
--

INSERT INTO `zones_to_geo_zones` (`association_id`, `zone_country_id`, `zone_id`, `geo_zone_id`, `last_modified`, `date_added`) VALUES (5,57,0,5,NULL,'2004-09-15 10:00:46'),(4,21,0,5,NULL,'2004-09-15 10:00:46'),(6,72,0,5,NULL,'2004-09-15 10:00:46'),(7,73,0,5,NULL,'2004-09-15 10:00:46'),(8,84,0,5,NULL,'2004-09-15 10:00:46'),(9,103,0,5,NULL,'2004-09-15 10:00:46'),(10,105,0,5,NULL,'2004-09-15 10:00:46'),(11,124,0,5,NULL,'2004-09-15 10:00:46'),(12,150,0,5,NULL,'2004-09-15 10:00:46'),(13,14,0,5,NULL,'2004-09-15 10:00:46'),(14,171,0,5,NULL,'2004-09-15 10:00:46'),(15,195,0,5,NULL,'2004-09-15 10:00:46'),(16,222,0,5,NULL,'2004-09-15 10:00:46'),(17,203,0,5,NULL,'2004-09-15 10:00:46'),(18,81,0,5,NULL,'2004-09-15 10:00:46'),(19,1,0,6,NULL,'2004-09-15 10:00:46'),(20,2,0,6,NULL,'2004-09-15 10:00:46'),(21,3,0,6,NULL,'2004-09-15 10:00:46'),(22,4,0,6,NULL,'2004-09-15 10:00:46'),(23,5,0,6,NULL,'2004-09-15 10:00:46'),(24,6,NULL,6,NULL,'2004-09-15 10:00:46'),(25,7,0,6,NULL,'2004-09-15 10:00:46'),(26,8,0,6,NULL,'2004-09-15 10:00:46'),(27,9,0,6,NULL,'2004-09-15 10:00:46'),(28,10,0,6,NULL,'2004-09-15 10:00:46'),(29,11,0,6,NULL,'2004-09-15 10:00:46'),(30,13,0,6,NULL,'2004-09-15 10:00:46'),(31,15,0,6,NULL,'2004-09-15 10:00:46'),(32,16,0,6,NULL,'2004-09-15 10:00:46'),(33,17,0,6,NULL,'2004-09-15 10:00:46'),(34,19,0,6,NULL,'2004-09-15 10:00:46'),(35,20,0,6,NULL,'2004-09-15 10:00:46'),(36,22,0,6,NULL,'2004-09-15 10:00:46'),(37,23,0,6,NULL,'2004-09-15 10:00:46'),(38,24,0,6,NULL,'2004-09-15 10:00:46'),(39,25,0,6,NULL,'2004-09-15 10:00:46'),(40,27,0,6,NULL,'2004-09-15 10:00:46'),(41,26,0,6,NULL,'2004-09-15 10:00:46'),(42,28,0,6,NULL,'2004-09-15 10:00:46'),(43,29,0,6,NULL,'2004-09-15 10:00:46'),(44,30,0,6,NULL,'2004-09-15 10:00:46'),(45,31,0,6,NULL,'2004-09-15 10:00:46'),(46,32,0,6,NULL,'2004-09-15 10:00:46'),(47,33,0,6,NULL,'2004-09-15 10:00:46'),(48,34,0,6,NULL,'2004-09-15 10:00:46'),(49,35,0,6,NULL,'2004-09-15 10:00:46'),(50,36,0,6,NULL,'2004-09-15 10:00:46'),(51,37,0,6,NULL,'2004-09-15 10:00:46'),(52,39,NULL,6,NULL,'2004-09-15 10:00:46'),(53,38,0,6,NULL,'2004-09-15 10:00:46'),(54,40,0,6,NULL,'2004-09-15 10:00:46'),(55,41,0,6,NULL,'2004-09-15 10:00:46'),(56,42,0,6,NULL,'2004-09-15 10:00:46'),(57,43,0,6,NULL,'2004-09-15 10:00:46'),(58,44,0,6,NULL,'2004-09-15 10:00:46'),(59,45,0,6,NULL,'2004-09-15 10:00:46'),(60,47,0,6,NULL,'2004-09-15 10:00:46'),(61,48,0,6,NULL,'2004-09-15 10:00:46'),(62,49,0,6,NULL,'2004-09-15 10:00:46'),(63,50,0,6,NULL,'2004-09-15 10:00:46'),(64,51,0,6,NULL,'2004-09-15 10:00:46'),(65,52,0,6,NULL,'2004-09-15 10:00:46'),(66,53,0,6,NULL,'2004-09-15 10:00:46'),(67,54,0,6,NULL,'2004-09-15 10:00:46'),(68,55,0,6,NULL,'2004-09-15 10:00:46'),(69,56,0,6,NULL,'2004-09-15 10:00:46'),(70,58,0,6,NULL,'2004-09-15 10:00:46'),(71,59,0,6,NULL,'2004-09-15 10:00:46'),(72,60,0,6,NULL,'2004-09-15 10:00:46'),(73,61,0,6,NULL,'2004-09-15 10:00:46'),(74,62,0,6,NULL,'2004-09-15 10:00:46'),(75,63,0,6,NULL,'2004-09-15 10:00:46'),(76,64,0,6,NULL,'2004-09-15 10:00:46'),(77,65,0,6,NULL,'2004-09-15 10:00:46'),(78,66,0,6,NULL,'2004-09-15 10:00:46'),(79,67,0,6,NULL,'2004-09-15 10:00:46'),(80,68,0,6,NULL,'2004-09-15 10:00:46'),(81,69,0,6,NULL,'2004-09-15 10:00:46'),(82,70,0,6,NULL,'2004-09-15 10:00:46'),(83,71,0,6,NULL,'2004-09-15 10:00:46'),(84,74,0,6,NULL,'2004-09-15 10:00:46'),(85,75,0,6,NULL,'2004-09-15 10:00:46'),(86,76,0,6,NULL,'2004-09-15 10:00:46'),(87,77,0,6,NULL,'2004-09-15 10:00:46'),(88,78,0,6,NULL,'2004-09-15 10:00:46'),(89,79,0,6,NULL,'2004-09-15 10:00:46'),(90,82,0,6,NULL,'2004-09-15 10:00:46'),(91,83,0,6,NULL,'2004-09-15 10:00:46'),(92,86,0,6,NULL,'2004-09-15 10:00:46'),(93,87,0,6,NULL,'2004-09-15 10:00:46'),(94,88,0,6,NULL,'2004-09-15 10:00:46'),(95,89,0,6,NULL,'2004-09-15 10:00:46'),(96,90,0,6,NULL,'2004-09-15 10:00:46'),(97,91,0,6,NULL,'2004-09-15 10:00:46'),(98,92,0,6,NULL,'2004-09-15 10:00:46'),(99,93,0,6,NULL,'2004-09-15 10:00:46'),(100,94,0,6,NULL,'2004-09-15 10:00:46'),(101,95,0,6,NULL,'2004-09-15 10:00:46'),(102,96,0,6,NULL,'2004-09-15 10:00:46'),(103,97,0,6,NULL,'2004-09-15 10:00:46'),(104,99,0,6,NULL,'2004-09-15 10:00:46'),(105,100,0,6,NULL,'2004-09-15 10:00:46'),(106,101,0,6,NULL,'2004-09-15 10:00:46'),(107,102,0,6,NULL,'2004-09-15 10:00:46'),(108,104,0,6,NULL,'2004-09-15 10:00:46'),(109,106,0,6,NULL,'2004-09-15 10:00:46'),(110,107,0,6,NULL,'2004-09-15 10:00:46'),(111,109,0,6,NULL,'2004-09-15 10:00:46'),(112,110,0,6,NULL,'2004-09-15 10:00:46'),(113,111,0,6,NULL,'2004-09-15 10:00:46'),(114,112,0,6,NULL,'2004-09-15 10:00:46'),(115,113,0,6,NULL,'2004-09-15 10:00:46'),(116,114,0,6,NULL,'2004-09-15 10:00:46'),(117,115,0,6,NULL,'2004-09-15 10:00:46'),(118,116,0,6,NULL,'2004-09-15 10:00:46'),(119,117,0,6,NULL,'2004-09-15 10:00:46'),(120,118,0,6,NULL,'2004-09-15 10:00:46'),(121,119,0,6,NULL,'2004-09-15 10:00:46'),(122,120,0,6,NULL,'2004-09-15 10:00:46'),(123,121,0,6,NULL,'2004-09-15 10:00:46'),(124,122,0,6,NULL,'2004-09-15 10:00:46'),(125,125,0,6,NULL,'2004-09-15 10:00:46'),(126,126,0,6,NULL,'2004-09-15 10:00:46'),(127,127,0,6,NULL,'2004-09-15 10:00:46'),(128,128,0,6,NULL,'2004-09-15 10:00:46'),(129,129,0,6,NULL,'2004-09-15 10:00:46'),(130,130,0,6,NULL,'2004-09-15 10:00:46'),(131,131,0,6,NULL,'2004-09-15 10:00:46'),(132,132,0,6,NULL,'2004-09-15 10:00:46'),(133,133,0,6,NULL,'2004-09-15 10:00:46'),(134,134,0,6,NULL,'2004-09-15 10:00:46'),(135,135,0,6,NULL,'2004-09-15 10:00:46'),(136,136,0,6,NULL,'2004-09-15 10:00:46'),(137,137,0,6,NULL,'2004-09-15 10:00:46'),(138,138,0,6,NULL,'2004-09-15 10:00:46'),(139,139,0,6,NULL,'2004-09-15 10:00:46'),(140,140,0,6,NULL,'2004-09-15 10:00:46'),(141,141,0,6,NULL,'2004-09-15 10:00:46'),(142,142,0,6,NULL,'2004-09-15 10:00:46'),(143,143,0,6,NULL,'2004-09-15 10:00:46'),(144,144,0,6,NULL,'2004-09-15 10:00:46'),(145,145,0,6,NULL,'2004-09-15 10:00:46'),(146,146,0,6,NULL,'2004-09-15 10:00:46'),(147,147,0,6,NULL,'2004-09-15 10:00:46'),(148,148,0,6,NULL,'2004-09-15 10:00:46'),(149,149,0,6,NULL,'2004-09-15 10:00:46'),(150,151,0,6,NULL,'2004-09-15 10:00:46'),(151,152,0,6,NULL,'2004-09-15 10:00:46'),(152,153,0,6,NULL,'2004-09-15 10:00:46'),(153,154,0,6,NULL,'2004-09-15 10:00:46'),(154,155,0,6,NULL,'2004-09-15 10:00:46'),(155,156,0,6,NULL,'2004-09-15 10:00:46'),(156,157,0,6,NULL,'2004-09-15 10:00:46'),(157,158,0,6,NULL,'2004-09-15 10:00:46'),(158,159,0,6,NULL,'2004-09-15 10:00:46'),(159,160,0,6,NULL,'2004-09-15 10:00:46'),(160,161,0,6,NULL,'2004-09-15 10:00:46'),(161,162,0,6,NULL,'2004-09-15 10:00:46'),(162,164,0,6,NULL,'2004-09-15 10:00:46'),(163,165,0,6,NULL,'2004-09-15 10:00:46'),(164,166,0,6,NULL,'2004-09-15 10:00:46'),(165,167,0,6,NULL,'2004-09-15 10:00:46'),(166,168,0,6,NULL,'2004-09-15 10:00:46'),(167,169,0,6,NULL,'2004-09-15 10:00:46'),(168,170,0,6,NULL,'2004-09-15 10:00:46'),(169,172,0,6,NULL,'2004-09-15 10:00:46'),(170,173,0,6,NULL,'2004-09-15 10:00:46'),(171,174,0,6,NULL,'2004-09-15 10:00:46'),(172,176,0,6,NULL,'2004-09-15 10:00:46'),(173,177,0,6,NULL,'2004-09-15 10:00:46'),(174,178,0,6,NULL,'2004-09-15 10:00:46'),(175,179,0,6,NULL,'2004-09-15 10:00:46'),(176,180,0,6,NULL,'2004-09-15 10:00:46'),(177,181,0,6,NULL,'2004-09-15 10:00:46'),(178,182,0,6,NULL,'2004-09-15 10:00:46'),(179,183,0,6,NULL,'2004-09-15 10:00:46'),(180,184,0,6,NULL,'2004-09-15 10:00:46'),(181,185,0,6,NULL,'2004-09-15 10:00:46'),(182,186,0,6,NULL,'2004-09-15 10:00:46'),(183,187,0,6,NULL,'2004-09-15 10:00:46'),(184,188,0,6,NULL,'2004-09-15 10:00:46'),(185,189,0,6,NULL,'2004-09-15 10:00:46'),(186,190,0,6,NULL,'2004-09-15 10:00:46'),(187,191,0,6,NULL,'2004-09-15 10:00:46'),(188,193,0,6,NULL,'2004-09-15 10:00:46'),(189,194,0,6,NULL,'2004-09-15 10:00:46'),(190,192,0,6,NULL,'2004-09-15 10:00:46'),(191,196,0,6,NULL,'2004-09-15 10:00:46'),(192,197,0,6,NULL,'2004-09-15 10:00:46'),(193,198,0,6,NULL,'2004-09-15 10:00:46'),(194,199,0,6,NULL,'2004-09-15 10:00:46'),(195,200,0,6,NULL,'2004-09-15 10:00:46'),(196,201,0,6,NULL,'2004-09-15 10:00:46'),(197,202,0,6,NULL,'2004-09-15 10:00:46'),(198,204,0,6,NULL,'2004-09-15 10:00:46'),(199,205,0,6,NULL,'2004-09-15 10:00:46'),(200,206,0,6,NULL,'2004-09-15 10:00:46'),(201,207,0,6,NULL,'2004-09-15 10:00:46'),(202,208,0,6,NULL,'2004-09-15 10:00:46'),(203,209,0,6,NULL,'2004-09-15 10:00:46'),(204,210,0,6,NULL,'2004-09-15 10:00:46'),(205,211,0,6,NULL,'2004-09-15 10:00:46'),(206,212,0,6,NULL,'2004-09-15 10:00:46'),(207,213,0,6,NULL,'2004-09-15 10:00:46'),(208,214,0,6,NULL,'2004-09-15 10:00:46'),(209,215,0,6,NULL,'2004-09-15 10:00:46'),(210,216,0,6,NULL,'2004-09-15 10:00:46'),(211,217,0,6,NULL,'2004-09-15 10:00:46'),(212,218,0,6,NULL,'2004-09-15 10:00:46'),(213,219,0,6,NULL,'2004-09-15 10:00:46'),(214,221,0,6,NULL,'2004-09-15 10:00:46'),(215,223,0,6,NULL,'2004-09-15 10:00:46'),(216,224,0,6,NULL,'2004-09-15 10:00:46'),(217,225,0,6,NULL,'2004-09-15 10:00:46'),(218,226,0,6,NULL,'2004-09-15 10:00:46'),(219,227,0,6,NULL,'2004-09-15 10:00:46'),(220,228,0,6,NULL,'2004-09-15 10:00:46'),(221,229,0,6,NULL,'2004-09-15 10:00:46'),(222,230,0,6,NULL,'2004-09-15 10:00:46'),(223,231,0,6,NULL,'2004-09-15 10:00:46'),(224,232,0,6,NULL,'2004-09-15 10:00:46'),(225,233,0,6,NULL,'2004-09-15 10:00:46'),(226,234,0,6,NULL,'2004-09-15 10:00:46'),(227,235,0,6,NULL,'2004-09-15 10:00:46'),(228,236,0,6,NULL,'2004-09-15 10:00:46'),(229,237,0,6,NULL,'2004-09-15 10:00:46'),(230,238,0,6,NULL,'2004-09-15 10:00:46'),(231,239,0,6,NULL,'2004-09-15 10:00:46'),(232,175,0,5,NULL,'2012-07-16 18:07:55');


