-- Table structure for table `ps_sekeyword`
--

CREATE TABLE `ps_sekeyword` (
  `id_sekeyword` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_shop` int(10) unsigned NOT NULL DEFAULT '1',
  `id_shop_group` int(10) unsigned NOT NULL DEFAULT '1',
  `keyword` varchar(256) NOT NULL,
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_sekeyword`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_sekeyword`
--


--
-- Table structure for table `ps_shippinginfo`
--

CREATE TABLE `ps_shippinginfo` (
  `id_shippinginfo` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_shop` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id_shippinginfo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_shippinginfo`
--


--
-- Table structure for table `ps_shippinginfo_lang`
--

CREATE TABLE `ps_shippinginfo_lang` (
  `id_shippinginfo` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY (`id_shippinginfo`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_shippinginfo_lang`
--


--
-- Table structure for table `ps_shop`
--

CREATE TABLE `ps_shop` (
  `id_shop` int(11) NOT NULL AUTO_INCREMENT,
  `id_shop_group` int(11) NOT NULL,
  `name` varchar(64) CHARACTER SET utf8 NOT NULL,
  `id_category` int(11) NOT NULL,
  `theme_name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `active` tinyint(1) NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_shop`),
  KEY `IDX_CBDFBB9EF5C9E40` (`id_shop_group`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_shop`
--

INSERT INTO `ps_shop` VALUES (1,3,'Toys And Games',2,'PRS033',1,0),(3,3,'Geomag',2,'PRS033',1,0),(4,3,'Quercetti',2,'PRS033',1,0),(5,3,'Carioca',2,'PRS033',1,0),(6,3,'NanoBlock',2,'PRS033',1,0),(7,3,'T-Shirts',2,'PRS033',1,0),(8,4,'Carioca',2,'PRS033',1,0),(9,4,'Toys And Games',2,'PRS033',1,0),(10,4,'Geomag',2,'PRS033',1,0),(11,4,'NanoBlock',2,'PRS033',1,0),(12,4,'Quercetti',2,'PRS033',1,0),(13,4,'T-Shirts',2,'PRS033',1,0);

--
-- Table structure for table `ps_shop_group`
--

CREATE TABLE `ps_shop_group` (
  `id_shop_group` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) CHARACTER SET utf8 NOT NULL,
  `share_customer` tinyint(1) NOT NULL,
  `share_order` tinyint(1) NOT NULL,
  `share_stock` tinyint(1) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_shop_group`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_shop_group`
--

INSERT INTO `ps_shop_group` VALUES (3,'Toys And Games CH',1,1,1,1,0),(4,'Toys And Games EU',1,1,1,1,0);

--
-- Table structure for table `ps_shop_url`
--

CREATE TABLE `ps_shop_url` (
  `id_shop_url` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_shop` int(11) unsigned NOT NULL,
  `domain` varchar(150) NOT NULL,
  `domain_ssl` varchar(150) NOT NULL,
  `physical_uri` varchar(64) NOT NULL,
  `virtual_uri` varchar(64) NOT NULL,
  `main` tinyint(1) NOT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_shop_url`),
  UNIQUE KEY `full_shop_url` (`domain`,`physical_uri`,`virtual_uri`),
  UNIQUE KEY `full_shop_url_ssl` (`domain_ssl`,`physical_uri`,`virtual_uri`),
  KEY `id_shop` (`id_shop`,`main`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_shop_url`
--

INSERT INTO `ps_shop_url` VALUES (1,1,'ch.toys-and-games.com','ch.toys-and-games.com','/','',1,1),(2,3,'ch.toys-and-games.com','ch.toys-and-games.com','/','geomag/',1,1),(3,4,'ch.toys-and-games.com','ch.toys-and-games.com','/','quercetti/',1,1),(4,5,'ch.toys-and-games.com','ch.toys-and-games.com','/','carioca/',1,1),(5,6,'ch.toys-and-games.com','ch.toys-and-games.com','/','nanoblock/',1,1),(6,7,'ch.toys-and-games.com','ch.toys-and-games.com','/','tshirts/',1,1),(7,8,'eu.toys-and-games.com','eu.toys-and-games.com','/','carioca/',1,1),(8,9,'eu.toys-and-games.com','eu.toys-and-games.com','/','',1,1),(9,10,'eu.toys-and-games.com','eu.toys-and-games.com','/','geomag/',1,1),(10,11,'eu.toys-and-games.com','eu.toys-and-games.com','/','nanoblock/',1,1),(11,12,'eu.toys-and-games.com','eu.toys-and-games.com','/','quercetti/',1,1),(12,13,'eu.toys-and-games.com','eu.toys-and-games.com','/','t-shirts/',1,1);

--
-- Table structure for table `ps_smarty_cache`
--

CREATE TABLE `ps_smarty_cache` (
  `id_smarty_cache` char(40) NOT NULL,
  `name` char(40) NOT NULL,
  `cache_id` varchar(254) DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `content` longtext NOT NULL,
  PRIMARY KEY (`id_smarty_cache`),
  KEY `name` (`name`),
  KEY `cache_id` (`cache_id`),
  KEY `modified` (`modified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_smarty_cache`
--


--
-- Table structure for table `ps_smarty_last_flush`
--

CREATE TABLE `ps_smarty_last_flush` (
  `type` enum('compile','template') NOT NULL,
  `last_flush` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_smarty_last_flush`
--


--
-- Table structure for table `ps_smarty_lazy_cache`
--

CREATE TABLE `ps_smarty_lazy_cache` (
  `template_hash` varchar(32) NOT NULL DEFAULT '',
  `cache_id` varchar(255) NOT NULL DEFAULT '',
  `compile_id` varchar(32) NOT NULL DEFAULT '',
  `filepath` varchar(255) NOT NULL DEFAULT '',
  `last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`template_hash`,`cache_id`,`compile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_smarty_lazy_cache`
--


--
-- Table structure for table `ps_specific_price`
--

CREATE TABLE `ps_specific_price` (
  `id_specific_price` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_specific_price_rule` int(11) unsigned NOT NULL,
  `id_cart` int(11) unsigned NOT NULL,
  `id_product` int(10) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL DEFAULT '1',
  `id_shop_group` int(11) unsigned NOT NULL,
  `id_currency` int(10) unsigned NOT NULL,
  `id_country` int(10) unsigned NOT NULL,
  `id_group` int(10) unsigned NOT NULL,
  `id_customer` int(10) unsigned NOT NULL,
  `id_product_attribute` int(10) unsigned NOT NULL,
  `price` decimal(20,6) NOT NULL,
  `from_quantity` mediumint(8) unsigned NOT NULL,
  `reduction` decimal(20,6) NOT NULL,
  `reduction_tax` tinyint(1) NOT NULL DEFAULT '1',
  `reduction_type` enum('amount','percentage') NOT NULL,
  `from` datetime NOT NULL,
  `to` datetime NOT NULL,
  PRIMARY KEY (`id_specific_price`),
  UNIQUE KEY `id_product_2` (`id_product`,`id_product_attribute`,`id_customer`,`id_cart`,`from`,`to`,`id_shop`,`id_shop_group`,`id_currency`,`id_country`,`id_group`,`from_quantity`,`id_specific_price_rule`),
  KEY `id_product` (`id_product`,`id_shop`,`id_currency`,`id_country`,`id_group`,`id_customer`,`from_quantity`,`from`,`to`),
  KEY `from_quantity` (`from_quantity`),
  KEY `id_specific_price_rule` (`id_specific_price_rule`),
  KEY `id_cart` (`id_cart`),
  KEY `id_product_attribute` (`id_product_attribute`),
  KEY `id_shop` (`id_shop`),
  KEY `id_customer` (`id_customer`),
  KEY `from` (`from`),
  KEY `to` (`to`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_specific_price`
--


--
-- Table structure for table `ps_specific_price_priority`
--

CREATE TABLE `ps_specific_price_priority` (
  `id_specific_price_priority` int(11) NOT NULL AUTO_INCREMENT,
  `id_product` int(11) NOT NULL,
  `priority` varchar(80) NOT NULL,
  PRIMARY KEY (`id_specific_price_priority`,`id_product`),
  UNIQUE KEY `id_product` (`id_product`)
) ENGINE=InnoDB AUTO_INCREMENT=191 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_specific_price_priority`
--

INSERT INTO `ps_specific_price_priority` VALUES (1,25,'id_shop;id_currency;id_country;id_group'),(7,26,'id_shop;id_currency;id_country;id_group'),(8,48,'id_shop;id_currency;id_country;id_group'),(9,49,'id_shop;id_currency;id_country;id_group'),(10,50,'id_shop;id_currency;id_country;id_group'),(11,129,'id_shop;id_currency;id_country;id_group'),(12,128,'id_shop;id_currency;id_country;id_group'),(13,127,'id_shop;id_currency;id_country;id_group'),(14,126,'id_shop;id_currency;id_country;id_group'),(16,125,'id_shop;id_currency;id_country;id_group'),(17,124,'id_shop;id_currency;id_country;id_group'),(18,114,'id_shop;id_currency;id_country;id_group'),(19,113,'id_shop;id_currency;id_country;id_group'),(20,112,'id_shop;id_currency;id_country;id_group'),(21,123,'id_shop;id_currency;id_country;id_group'),(22,122,'id_shop;id_currency;id_country;id_group'),(23,121,'id_shop;id_currency;id_country;id_group'),(24,120,'id_shop;id_currency;id_country;id_group'),(25,118,'id_shop;id_currency;id_country;id_group'),(26,117,'id_shop;id_currency;id_country;id_group'),(27,116,'id_shop;id_currency;id_country;id_group'),(29,115,'id_shop;id_currency;id_country;id_group'),(30,111,'id_shop;id_currency;id_country;id_group'),(31,110,'id_shop;id_currency;id_country;id_group'),(32,109,'id_shop;id_currency;id_country;id_group'),(33,108,'id_shop;id_currency;id_country;id_group'),(34,107,'id_shop;id_currency;id_country;id_group'),(35,106,'id_shop;id_currency;id_country;id_group'),(36,105,'id_shop;id_currency;id_country;id_group'),(38,104,'id_shop;id_currency;id_country;id_group'),(39,103,'id_shop;id_currency;id_country;id_group'),(40,102,'id_shop;id_currency;id_country;id_group'),(41,101,'id_shop;id_currency;id_country;id_group'),(42,99,'id_shop;id_currency;id_country;id_group'),(43,98,'id_shop;id_currency;id_country;id_group'),(44,97,'id_shop;id_currency;id_country;id_group'),(47,93,'id_shop;id_currency;id_country;id_group'),(48,92,'id_shop;id_currency;id_country;id_group'),(49,91,'id_shop;id_currency;id_country;id_group'),(50,90,'id_shop;id_currency;id_country;id_group'),(51,89,'id_shop;id_currency;id_country;id_group'),(52,88,'id_shop;id_currency;id_country;id_group'),(53,87,'id_shop;id_currency;id_country;id_group'),(54,86,'id_shop;id_currency;id_country;id_group'),(55,85,'id_shop;id_currency;id_country;id_group'),(56,84,'id_shop;id_currency;id_country;id_group'),(57,83,'id_shop;id_currency;id_country;id_group'),(58,82,'id_shop;id_currency;id_country;id_group'),(60,119,'id_shop;id_currency;id_country;id_group'),(61,100,'id_shop;id_currency;id_country;id_group'),(62,96,'id_shop;id_currency;id_country;id_group'),(63,95,'id_shop;id_currency;id_country;id_group'),(64,94,'id_shop;id_currency;id_country;id_group'),(65,81,'id_shop;id_currency;id_country;id_group'),(66,80,'id_shop;id_currency;id_country;id_group'),(67,79,'id_shop;id_currency;id_country;id_group'),(68,78,'id_shop;id_currency;id_country;id_group'),(69,77,'id_shop;id_currency;id_country;id_group'),(115,69,'id_shop;id_currency;id_country;id_group'),(116,76,'id_shop;id_currency;id_country;id_group'),(117,28,'id_shop;id_currency;id_country;id_group'),(120,27,'id_shop;id_currency;id_country;id_group'),(122,29,'id_shop;id_currency;id_country;id_group'),(123,30,'id_shop;id_currency;id_country;id_group'),(124,31,'id_shop;id_currency;id_country;id_group'),(127,51,'id_shop;id_currency;id_country;id_group'),(128,52,'id_shop;id_currency;id_country;id_group'),(130,53,'id_shop;id_currency;id_country;id_group'),(131,54,'id_shop;id_currency;id_country;id_group'),(132,55,'id_shop;id_currency;id_country;id_group'),(133,56,'id_shop;id_currency;id_country;id_group'),(134,57,'id_shop;id_currency;id_country;id_group'),(135,58,'id_shop;id_currency;id_country;id_group'),(136,59,'id_shop;id_currency;id_country;id_group'),(137,60,'id_shop;id_currency;id_country;id_group'),(138,61,'id_shop;id_currency;id_country;id_group'),(139,62,'id_shop;id_currency;id_country;id_group'),(140,63,'id_shop;id_currency;id_country;id_group'),(141,64,'id_shop;id_currency;id_country;id_group'),(142,65,'id_shop;id_currency;id_country;id_group'),(143,66,'id_shop;id_currency;id_country;id_group'),(144,67,'id_shop;id_currency;id_country;id_group'),(145,68,'id_shop;id_currency;id_country;id_group'),(147,70,'id_shop;id_currency;id_country;id_group'),(148,71,'id_shop;id_currency;id_country;id_group'),(149,72,'id_shop;id_currency;id_country;id_group'),(150,73,'id_shop;id_currency;id_country;id_group'),(151,74,'id_shop;id_currency;id_country;id_group'),(152,75,'id_shop;id_currency;id_country;id_group'),(155,39,'id_shop;id_currency;id_country;id_group'),(156,40,'id_shop;id_currency;id_country;id_group'),(157,41,'id_shop;id_currency;id_country;id_group'),(158,42,'id_shop;id_currency;id_country;id_group'),(159,43,'id_shop;id_currency;id_country;id_group'),(160,44,'id_shop;id_currency;id_country;id_group'),(161,45,'id_shop;id_currency;id_country;id_group'),(162,46,'id_shop;id_currency;id_country;id_group'),(163,47,'id_shop;id_currency;id_country;id_group'),(167,130,'id_shop;id_currency;id_country;id_group'),(190,131,'id_shop;id_currency;id_country;id_group');

--
-- Table structure for table `ps_specific_price_rule`
--

CREATE TABLE `ps_specific_price_rule` (
  `id_specific_price_rule` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `id_shop` int(11) unsigned NOT NULL DEFAULT '1',
  `id_currency` int(10) unsigned NOT NULL,
  `id_country` int(10) unsigned NOT NULL,
  `id_group` int(10) unsigned NOT NULL,
  `from_quantity` mediumint(8) unsigned NOT NULL,
  `price` decimal(20,6) DEFAULT NULL,
  `reduction` decimal(20,6) NOT NULL,
  `reduction_tax` tinyint(1) NOT NULL DEFAULT '1',
  `reduction_type` enum('amount','percentage') NOT NULL,
  `from` datetime NOT NULL,
  `to` datetime NOT NULL,
  PRIMARY KEY (`id_specific_price_rule`),
  KEY `id_product` (`id_shop`,`id_currency`,`id_country`,`id_group`,`from_quantity`,`from`,`to`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_specific_price_rule`
--


--
-- Table structure for table `ps_specific_price_rule_condition`
--

CREATE TABLE `ps_specific_price_rule_condition` (
  `id_specific_price_rule_condition` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_specific_price_rule_condition_group` int(11) unsigned NOT NULL,
  `type` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`id_specific_price_rule_condition`),
  KEY `id_specific_price_rule_condition_group` (`id_specific_price_rule_condition_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_specific_price_rule_condition`
--


--
-- Table structure for table `ps_specific_price_rule_condition_group`
--

CREATE TABLE `ps_specific_price_rule_condition_group` (
  `id_specific_price_rule_condition_group` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_specific_price_rule` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_specific_price_rule_condition_group`,`id_specific_price_rule`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_specific_price_rule_condition_group`
--


--
-- Table structure for table `ps_state`
--

CREATE TABLE `ps_state` (
  `id_state` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_country` int(11) unsigned NOT NULL,
  `id_zone` int(11) unsigned NOT NULL,
  `name` varchar(64) NOT NULL,
  `iso_code` varchar(7) NOT NULL,
  `tax_behavior` smallint(1) NOT NULL DEFAULT '0',
  `active` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_state`),
  KEY `id_country` (`id_country`),
  KEY `name` (`name`),
  KEY `id_zone` (`id_zone`)
) ENGINE=InnoDB AUTO_INCREMENT=325 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_state`
--

INSERT INTO `ps_state` VALUES (1,21,2,'AA','AA',0,1),(2,21,2,'AE','AE',0,1),(3,21,2,'AP','AP',0,1),(4,21,2,'Alabama','AL',0,1),(5,21,2,'Alaska','AK',0,1),(6,21,2,'Arizona','AZ',0,1),(7,21,2,'Arkansas','AR',0,1),(8,21,2,'California','CA',0,1),(9,21,2,'Colorado','CO',0,1),(10,21,2,'Connecticut','CT',0,1),(11,21,2,'Delaware','DE',0,1),(12,21,2,'Florida','FL',0,1),(13,21,2,'Georgia','GA',0,1),(14,21,2,'Hawaii','HI',0,1),(15,21,2,'Idaho','ID',0,1),(16,21,2,'Illinois','IL',0,1),(17,21,2,'Indiana','IN',0,1),(18,21,2,'Iowa','IA',0,1),(19,21,2,'Kansas','KS',0,1),(20,21,2,'Kentucky','KY',0,1),(21,21,2,'Louisiana','LA',0,1),(22,21,2,'Maine','ME',0,1),(23,21,2,'Maryland','MD',0,1),(24,21,2,'Massachusetts','MA',0,1),(25,21,2,'Michigan','MI',0,1),(26,21,2,'Minnesota','MN',0,1),(27,21,2,'Mississippi','MS',0,1),(28,21,2,'Missouri','MO',0,1),(29,21,2,'Montana','MT',0,1),(30,21,2,'Nebraska','NE',0,1),(31,21,2,'Nevada','NV',0,1),(32,21,2,'New Hampshire','NH',0,1),(33,21,2,'New Jersey','NJ',0,1),(34,21,2,'New Mexico','NM',0,1),(35,21,2,'New York','NY',0,1),(36,21,2,'North Carolina','NC',0,1),(37,21,2,'North Dakota','ND',0,1),(38,21,2,'Ohio','OH',0,1),(39,21,2,'Oklahoma','OK',0,1),(40,21,2,'Oregon','OR',0,1),(41,21,2,'Pennsylvania','PA',0,1),(42,21,2,'Rhode Island','RI',0,1),(43,21,2,'South Carolina','SC',0,1),(44,21,2,'South Dakota','SD',0,1),(45,21,2,'Tennessee','TN',0,1),(46,21,2,'Texas','TX',0,1),(47,21,2,'Utah','UT',0,1),(48,21,2,'Vermont','VT',0,1),(49,21,2,'Virginia','VA',0,1),(50,21,2,'Washington','WA',0,1),(51,21,2,'West Virginia','WV',0,1),(52,21,2,'Wisconsin','WI',0,1),(53,21,2,'Wyoming','WY',0,1),(54,21,2,'Puerto Rico','PR',0,1),(55,21,2,'US Virgin Islands','VI',0,1),(56,21,2,'District of Columbia','DC',0,1),(57,145,2,'Aguascalientes','AGS',0,1),(58,145,2,'Baja California','BCN',0,1),(59,145,2,'Baja California Sur','BCS',0,1),(60,145,2,'Campeche','CAM',0,1),(61,145,2,'Chiapas','CHP',0,1),(62,145,2,'Chihuahua','CHH',0,1),(63,145,2,'Coahuila','COA',0,1),(64,145,2,'Colima','COL',0,1),(65,145,2,'Distrito Federal','DIF',0,1),(66,145,2,'Durango','DUR',0,1),(67,145,2,'Guanajuato','GUA',0,1),(68,145,2,'Guerrero','GRO',0,1),(69,145,2,'Hidalgo','HID',0,1),(70,145,2,'Jalisco','JAL',0,1),(71,145,2,'Estado de México','MEX',0,1),(72,145,2,'Michoacán','MIC',0,1),(73,145,2,'Morelos','MOR',0,1),(74,145,2,'Nayarit','NAY',0,1),(75,145,2,'Nuevo León','NLE',0,1),(76,145,2,'Oaxaca','OAX',0,1),(77,145,2,'Puebla','PUE',0,1),(78,145,2,'Querétaro','QUE',0,1),(79,145,2,'Quintana Roo','ROO',0,1),(80,145,2,'San Luis Potosí','SLP',0,1),(81,145,2,'Sinaloa','SIN',0,1),(82,145,2,'Sonora','SON',0,1),(83,145,2,'Tabasco','TAB',0,1),(84,145,2,'Tamaulipas','TAM',0,1),(85,145,2,'Tlaxcala','TLA',0,1),(86,145,2,'Veracruz','VER',0,1),(87,145,2,'Yucatán','YUC',0,1),(88,145,2,'Zacatecas','ZAC',0,1),(89,4,2,'Ontario','ON',0,1),(90,4,2,'Quebec','QC',0,1),(91,4,2,'British Columbia','BC',0,1),(92,4,2,'Alberta','AB',0,1),(93,4,2,'Manitoba','MB',0,1),(94,4,2,'Saskatchewan','SK',0,1),(95,4,2,'Nova Scotia','NS',0,1),(96,4,2,'New Brunswick','NB',0,1),(97,4,2,'Newfoundland and Labrador','NL',0,1),(98,4,2,'Prince Edward Island','PE',0,1),(99,4,2,'Northwest Territories','NT',0,1),(100,4,2,'Yukon','YT',0,1),(101,4,2,'Nunavut','NU',0,1),(102,44,6,'Buenos Aires','B',0,1),(103,44,6,'Catamarca','K',0,1),(104,44,6,'Chaco','H',0,1),(105,44,6,'Chubut','U',0,1),(106,44,6,'Ciudad de Buenos Aires','C',0,1),(107,44,6,'Córdoba','X',0,1),(108,44,6,'Corrientes','W',0,1),(109,44,6,'Entre Ríos','E',0,1),(110,44,6,'Formosa','P',0,1),(111,44,6,'Jujuy','Y',0,1),(112,44,6,'La Pampa','L',0,1),(113,44,6,'La Rioja','F',0,1),(114,44,6,'Mendoza','M',0,1),(115,44,6,'Misiones','N',0,1),(116,44,6,'Neuquén','Q',0,1),(117,44,6,'Río Negro','R',0,1),(118,44,6,'Salta','A',0,1),(119,44,6,'San Juan','J',0,1),(120,44,6,'San Luis','D',0,1),(121,44,6,'Santa Cruz','Z',0,1),(122,44,6,'Santa Fe','S',0,1),(123,44,6,'Santiago del Estero','G',0,1),(124,44,6,'Tierra del Fuego','V',0,1),(125,44,6,'Tucumán','T',0,1),(126,10,1,'Agrigento','AG',0,1),(127,10,1,'Alessandria','AL',0,1),(128,10,1,'Ancona','AN',0,1),(129,10,1,'Aosta','AO',0,1),(130,10,1,'Arezzo','AR',0,1),(131,10,1,'Ascoli Piceno','AP',0,1),(132,10,1,'Asti','AT',0,1),(133,10,1,'Avellino','AV',0,1),(134,10,1,'Bari','BA',0,1),(135,10,1,'Barletta-Andria-Trani','BT',0,1),(136,10,1,'Belluno','BL',0,1),(137,10,1,'Benevento','BN',0,1),(138,10,1,'Bergamo','BG',0,1),(139,10,1,'Biella','BI',0,1),(140,10,1,'Bologna','BO',0,1),(141,10,1,'Bolzano','BZ',0,1),(142,10,1,'Brescia','BS',0,1),(143,10,1,'Brindisi','BR',0,1),(144,10,1,'Cagliari','CA',0,1),(145,10,1,'Caltanissetta','CL',0,1),(146,10,1,'Campobasso','CB',0,1),(147,10,1,'Carbonia-Iglesias','CI',0,1),(148,10,1,'Caserta','CE',0,1),(149,10,1,'Catania','CT',0,1),(150,10,1,'Catanzaro','CZ',0,1),(151,10,1,'Chieti','CH',0,1),(152,10,1,'Como','CO',0,1),(153,10,1,'Cosenza','CS',0,1),(154,10,1,'Cremona','CR',0,1),(155,10,1,'Crotone','KR',0,1),(156,10,1,'Cuneo','CN',0,1),(157,10,1,'Enna','EN',0,1),(158,10,1,'Fermo','FM',0,1),(159,10,1,'Ferrara','FE',0,1),(160,10,1,'Firenze','FI',0,1),(161,10,1,'Foggia','FG',0,1),(162,10,1,'Forlì-Cesena','FC',0,1),(163,10,1,'Frosinone','FR',0,1),(164,10,1,'Genova','GE',0,1),(165,10,1,'Gorizia','GO',0,1),(166,10,1,'Grosseto','GR',0,1),(167,10,1,'Imperia','IM',0,1),(168,10,1,'Isernia','IS',0,1),(169,10,1,'L\'Aquila','AQ',0,1),(170,10,1,'La Spezia','SP',0,1),(171,10,1,'Latina','LT',0,1),(172,10,1,'Lecce','LE',0,1),(173,10,1,'Lecco','LC',0,1),(174,10,1,'Livorno','LI',0,1),(175,10,1,'Lodi','LO',0,1),(176,10,1,'Lucca','LU',0,1),(177,10,1,'Macerata','MC',0,1),(178,10,1,'Mantova','MN',0,1),(179,10,1,'Massa','MS',0,1),(180,10,1,'Matera','MT',0,1),(181,10,1,'Medio Campidano','VS',0,1),(182,10,1,'Messina','ME',0,1),(183,10,1,'Milano','MI',0,1),(184,10,1,'Modena','MO',0,1),(185,10,1,'Monza e della Brianza','MB',0,1),(186,10,1,'Napoli','NA',0,1),(187,10,1,'Novara','NO',0,1),(188,10,1,'Nuoro','NU',0,1),(189,10,1,'Ogliastra','OG',0,1),(190,10,1,'Olbia-Tempio','OT',0,1),(191,10,1,'Oristano','OR',0,1),(192,10,1,'Padova','PD',0,1),(193,10,1,'Palermo','PA',0,1),(194,10,1,'Parma','PR',0,1),(195,10,1,'Pavia','PV',0,1),(196,10,1,'Perugia','PG',0,1),(197,10,1,'Pesaro-Urbino','PU',0,1),(198,10,1,'Pescara','PE',0,1),(199,10,1,'Piacenza','PC',0,1),(200,10,1,'Pisa','PI',0,1),(201,10,1,'Pistoia','PT',0,1),(202,10,1,'Pordenone','PN',0,1),(203,10,1,'Potenza','PZ',0,1),(204,10,1,'Prato','PO',0,1),(205,10,1,'Ragusa','RG',0,1),(206,10,1,'Ravenna','RA',0,1),(207,10,1,'Reggio Calabria','RC',0,1),(208,10,1,'Reggio Emilia','RE',0,1),(209,10,1,'Rieti','RI',0,1),(210,10,1,'Rimini','RN',0,1),(211,10,1,'Roma','RM',0,1),(212,10,1,'Rovigo','RO',0,1),(213,10,1,'Salerno','SA',0,1),(214,10,1,'Sassari','SS',0,1),(215,10,1,'Savona','SV',0,1),(216,10,1,'Siena','SI',0,1),(217,10,1,'Siracusa','SR',0,1),(218,10,1,'Sondrio','SO',0,1),(219,10,1,'Taranto','TA',0,1),(220,10,1,'Teramo','TE',0,1),(221,10,1,'Terni','TR',0,1),(222,10,1,'Torino','TO',0,1),(223,10,1,'Trapani','TP',0,1),(224,10,1,'Trento','TN',0,1),(225,10,1,'Treviso','TV',0,1),(226,10,1,'Trieste','TS',0,1),(227,10,1,'Udine','UD',0,1),(228,10,1,'Varese','VA',0,1),(229,10,1,'Venezia','VE',0,1),(230,10,1,'Verbano-Cusio-Ossola','VB',0,1),(231,10,1,'Vercelli','VC',0,1),(232,10,1,'Verona','VR',0,1),(233,10,1,'Vibo Valentia','VV',0,1),(234,10,1,'Vicenza','VI',0,1),(235,10,1,'Viterbo','VT',0,1),(236,111,3,'Aceh','ID-AC',0,1),(237,111,3,'Bali','ID-BA',0,1),(238,111,3,'Banten','ID-BT',0,1),(239,111,3,'Bengkulu','ID-BE',0,1),(240,111,3,'Gorontalo','ID-GO',0,1),(241,111,3,'Jakarta','ID-JK',0,1),(242,111,3,'Jambi','ID-JA',0,1),(243,111,3,'Jawa Barat','ID-JB',0,1),(244,111,3,'Jawa Tengah','ID-JT',0,1),(245,111,3,'Jawa Timur','ID-JI',0,1),(246,111,3,'Kalimantan Barat','ID-KB',0,1),(247,111,3,'Kalimantan Selatan','ID-KS',0,1),(248,111,3,'Kalimantan Tengah','ID-KT',0,1),(249,111,3,'Kalimantan Timur','ID-KI',0,1),(250,111,3,'Kalimantan Utara','ID-KU',0,1),(251,111,3,'Kepulauan Bangka Belitug','ID-BB',0,1),(252,111,3,'Kepulauan Riau','ID-KR',0,1),(253,111,3,'Lampung','ID-LA',0,1),(254,111,3,'Maluku','ID-MA',0,1),(255,111,3,'Maluku Utara','ID-MU',0,1),(256,111,3,'Nusa Tengara Barat','ID-NB',0,1),(257,111,3,'Nusa Tenggara Timur','ID-NT',0,1),(258,111,3,'Papua','ID-PA',0,1),(259,111,3,'Papua Barat','ID-PB',0,1),(260,111,3,'Riau','ID-RI',0,1),(261,111,3,'Sulawesi Barat','ID-SR',0,1),(262,111,3,'Sulawesi Selatan','ID-SN',0,1),(263,111,3,'Sulawesi Tengah','ID-ST',0,1),(264,111,3,'Sulawesi Tenggara','ID-SG',0,1),(265,111,3,'Sulawesi Utara','ID-SA',0,1),(266,111,3,'Sumatera Barat','ID-SB',0,1),(267,111,3,'Sumatera Selatan','ID-SS',0,1),(268,111,3,'Sumatera Utara','ID-SU',0,1),(269,111,3,'Yogyakarta','ID-YO',0,1),(270,11,3,'Aichi','23',0,1),(271,11,3,'Akita','05',0,1),(272,11,3,'Aomori','02',0,1),(273,11,3,'Chiba','12',0,1),(274,11,3,'Ehime','38',0,1),(275,11,3,'Fukui','18',0,1),(276,11,3,'Fukuoka','40',0,1),(277,11,3,'Fukushima','07',0,1),(278,11,3,'Gifu','21',0,1),(279,11,3,'Gunma','10',0,1),(280,11,3,'Hiroshima','34',0,1),(281,11,3,'Hokkaido','01',0,1),(282,11,3,'Hyogo','28',0,1),(283,11,3,'Ibaraki','08',0,1),(284,11,3,'Ishikawa','17',0,1),(285,11,3,'Iwate','03',0,1),(286,11,3,'Kagawa','37',0,1),(287,11,3,'Kagoshima','46',0,1),(288,11,3,'Kanagawa','14',0,1),(289,11,3,'Kochi','39',0,1),(290,11,3,'Kumamoto','43',0,1),(291,11,3,'Kyoto','26',0,1),(292,11,3,'Mie','24',0,1),(293,11,3,'Miyagi','04',0,1),(294,11,3,'Miyazaki','45',0,1),(295,11,3,'Nagano','20',0,1),(296,11,3,'Nagasaki','42',0,1),(297,11,3,'Nara','29',0,1),(298,11,3,'Niigata','15',0,1),(299,11,3,'Oita','44',0,1),(300,11,3,'Okayama','33',0,1),(301,11,3,'Okinawa','47',0,1),(302,11,3,'Osaka','27',0,1),(303,11,3,'Saga','41',0,1),(304,11,3,'Saitama','11',0,1),(305,11,3,'Shiga','25',0,1),(306,11,3,'Shimane','32',0,1),(307,11,3,'Shizuoka','22',0,1),(308,11,3,'Tochigi','09',0,1),(309,11,3,'Tokushima','36',0,1),(310,11,3,'Tokyo','13',0,1),(311,11,3,'Tottori','31',0,1),(312,11,3,'Toyama','16',0,1),(313,11,3,'Wakayama','30',0,1),(314,11,3,'Yamagata','06',0,1),(315,11,3,'Yamaguchi','35',0,1),(316,11,3,'Yamanashi','19',0,1),(317,24,5,'Australian Capital Territory','ACT',0,1),(318,24,5,'New South Wales','NSW',0,1),(319,24,5,'Northern Territory','NT',0,1),(320,24,5,'Queensland','QLD',0,1),(321,24,5,'South Australia','SA',0,1),(322,24,5,'Tasmania','TAS',0,1),(323,24,5,'Victoria','VIC',0,1),(324,24,5,'Western Australia','WA',0,1);

--
-- Table structure for table `ps_statssearch`
--

CREATE TABLE `ps_statssearch` (
  `id_statssearch` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_shop` int(10) unsigned NOT NULL DEFAULT '1',
  `id_shop_group` int(10) unsigned NOT NULL DEFAULT '1',
  `keywords` varchar(255) NOT NULL,
  `results` int(6) NOT NULL DEFAULT '0',
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_statssearch`)
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_statssearch`
--

INSERT INTO `ps_statssearch` VALUES (1,5,3,'K',0,'2018-07-05 08:59:17'),(2,5,3,'Ki',0,'2018-07-05 08:59:18'),(3,5,3,'Kit',0,'2018-07-05 08:59:18'),(4,5,3,'Kit',0,'2018-07-05 08:59:22'),(5,1,3,'nano¨',0,'2018-07-06 14:13:15'),(6,1,3,'nano',0,'2018-07-06 14:13:19'),(7,1,3,'wa',0,'2018-07-06 14:13:24'),(8,1,3,'war',0,'2018-07-06 14:13:25'),(9,1,3,'war',0,'2018-07-06 14:13:25'),(10,4,3,'wars',0,'2018-07-06 14:13:32'),(11,4,3,'wars',0,'2018-07-06 14:13:32'),(12,4,3,'wars',0,'2018-07-06 14:13:37'),(13,1,3,'pi',0,'2018-07-06 14:13:50'),(14,1,3,'pixe',0,'2018-07-06 14:13:50'),(15,1,3,'pixel',0,'2018-07-06 14:13:51'),(16,1,3,'pixel',0,'2018-07-06 14:13:51'),(17,1,3,'geomag',0,'2018-07-12 12:23:51'),(18,1,3,'geomag',0,'2018-07-12 12:23:51'),(19,1,3,'m',0,'2018-07-13 09:35:39'),(20,1,3,'man',0,'2018-07-13 09:35:39'),(21,1,3,'manga',0,'2018-07-13 09:35:40'),(22,1,3,'ma',0,'2018-07-13 09:35:40'),(23,1,3,'m',0,'2018-07-13 09:35:41'),(24,1,3,'ma',0,'2018-07-13 09:35:41'),(25,1,3,'man',0,'2018-07-13 09:35:43'),(26,1,3,'manga ',0,'2018-07-13 09:35:44'),(27,1,3,'manga an',0,'2018-07-13 09:35:44'),(28,1,3,'manga ani',0,'2018-07-13 09:35:45'),(29,1,3,'manga ',0,'2018-07-13 09:35:47'),(30,1,3,'manga an',0,'2018-07-13 09:35:49'),(31,1,3,'manga anim',0,'2018-07-13 09:35:50'),(32,1,3,'manga anime',0,'2018-07-13 09:35:50'),(33,1,3,'manga ani',0,'2018-07-13 09:35:50'),(34,1,3,'manga anime',0,'2018-07-13 09:35:51'),(35,1,3,'Mon',0,'2018-07-13 09:36:03'),(36,1,3,'Mons',0,'2018-07-13 09:36:04'),(37,1,3,'Monster',0,'2018-07-13 09:36:05'),(38,1,3,'Monster ',0,'2018-07-13 09:36:06'),(39,1,3,'Monster h',0,'2018-07-13 09:36:07'),(40,1,3,'Monster High',0,'2018-07-13 09:36:09'),(41,1,3,'Monster High',0,'2018-07-13 09:36:10'),(42,3,3,'kor',0,'2018-07-16 16:01:18'),(43,3,3,'kor',0,'2018-07-16 16:01:19'),(44,3,3,'kor',0,'2018-07-16 16:01:21'),(45,3,3,'kor',0,'2018-07-16 16:01:24'),(46,3,3,'Col',0,'2018-07-16 16:01:30'),(47,3,3,'Colo',0,'2018-07-16 16:01:31'),(48,3,3,'Color',0,'2018-07-16 16:01:31'),(49,3,3,'Color',18,'2018-07-16 16:03:27'),(50,3,3,'ColorKor',0,'2018-07-16 16:03:34'),(51,3,3,'Kor',18,'2018-07-16 16:03:36'),(52,1,3,'Kor',0,'2018-07-16 16:03:41'),(53,1,3,'Kor',0,'2018-07-16 16:03:42'),(54,1,3,'Kor',0,'2018-07-16 16:07:43'),(55,1,3,'Kor',0,'2018-07-16 16:08:10'),(56,4,3,'Ko',0,'2018-07-16 16:08:14'),(57,4,3,'Kor',0,'2018-07-16 16:08:15'),(58,4,3,'C',0,'2018-07-16 16:08:17'),(59,4,3,'Co',0,'2018-07-16 16:08:18'),(60,4,3,'Col',10,'2018-07-16 16:08:19'),(61,4,3,'Yod',1,'2018-07-16 16:08:22'),(62,1,3,'P',0,'2018-07-19 17:38:36'),(63,1,3,'Pa',0,'2018-07-19 17:38:37'),(64,1,3,'Pal',0,'2018-07-19 17:38:37'),(65,1,3,'Palestra',0,'2018-07-19 17:38:39'),(66,1,3,'Palestra',0,'2018-07-19 17:38:40'),(67,1,3,'Le',0,'2018-07-20 08:21:15'),(68,1,3,'Lego',0,'2018-07-20 08:21:16'),(69,1,3,'Lego',0,'2018-07-20 08:21:16'),(70,1,3,'Lego',0,'2018-07-20 08:21:24'),(71,1,3,'Lego',0,'2018-07-20 08:21:48'),(72,1,3,'Lego',0,'2018-07-20 08:21:59'),(73,1,3,'Titanic',0,'2018-07-27 16:55:41'),(74,1,3,'Nano Block Titanic ',0,'2018-07-27 16:56:05'),(75,1,3,'Nano Block',0,'2018-07-27 16:56:13'),(76,1,3,'Nano Block',0,'2018-07-27 16:56:21'),(77,1,3,'Nano nlovk',0,'2018-07-27 16:56:41'),(78,1,3,'Nano block',0,'2018-07-27 16:56:50'),(79,1,3,'Nano nlovk',0,'2018-07-27 16:56:52'),(80,5,3,'ba',0,'2018-07-31 05:00:36'),(81,5,3,'bab',0,'2018-07-31 05:00:37'),(82,5,3,'baby',0,'2018-07-31 05:00:38'),(83,5,3,'b',0,'2018-07-31 05:00:39'),(84,5,3,'baby',0,'2018-07-31 05:00:44'),(85,5,3,'bab',0,'2018-07-31 05:01:07'),(86,5,3,'b',0,'2018-07-31 05:01:07'),(87,5,3,'to',0,'2018-07-31 05:01:22'),(88,5,3,'toy ',0,'2018-07-31 05:01:23'),(89,5,3,'toy fo',0,'2018-07-31 05:01:23'),(90,5,3,'toy f',0,'2018-07-31 05:01:24'),(91,5,3,'toy for',0,'2018-07-31 05:01:24'),(92,5,3,'toy for ',0,'2018-07-31 05:01:25'),(93,5,3,'toy for b',0,'2018-07-31 05:01:25'),(94,5,3,'toy',0,'2018-07-31 05:01:25'),(95,5,3,'toy for ba',0,'2018-07-31 05:01:25'),(96,5,3,'toy for bab',0,'2018-07-31 05:01:26'),(97,5,3,'toy for baby',0,'2018-07-31 05:01:26'),(98,5,3,'toy for baby',0,'2018-07-31 05:01:27'),(99,5,3,'fisher price',0,'2018-07-31 05:04:21'),(100,5,3,'lego',0,'2018-07-31 09:43:48'),(101,5,3,'lego',0,'2018-07-31 09:43:48'),(102,1,3,'Lol',0,'2018-08-08 16:02:20'),(103,4,3,'q',0,'2018-08-10 13:43:58'),(104,4,3,'qrc ',10,'2018-08-10 13:43:59'),(105,4,3,'qrc 0',10,'2018-08-10 13:44:00'),(106,4,3,'qrc 000',10,'2018-08-10 13:44:01'),(107,4,3,'qrc 0008',10,'2018-08-10 13:44:02'),(108,4,3,'qrc 00084',10,'2018-08-10 13:44:03'),(109,4,3,'qrc 000849',10,'2018-08-10 13:44:04'),(110,1,3,'Rubik',0,'2018-08-13 11:41:50'),(111,1,3,'Rubik',0,'2018-08-13 11:41:59'),(112,1,3,'Rubik',0,'2018-08-13 11:42:31'),(113,1,3,'Dji',0,'2018-08-25 21:09:09'),(114,5,3,'D',0,'2018-08-25 21:09:41'),(115,5,3,'Dji',0,'2018-08-25 21:09:42'),(116,5,3,'Dji',0,'2018-08-25 21:09:42'),(117,5,3,'Dji',0,'2018-08-25 21:09:44'),(118,5,3,'Dji',0,'2018-08-25 21:09:46'),(119,1,3,'Dji',0,'2018-08-25 21:09:58'),(120,5,3,'Plush',0,'2018-08-27 18:35:19'),(121,5,3,'Plush ',0,'2018-08-27 18:35:19'),(122,5,3,'Plush to',0,'2018-08-27 18:35:20'),(123,5,3,'Plush toy ',0,'2018-08-27 18:35:20'),(124,5,3,'Plush toy teddy',0,'2018-08-27 18:35:22'),(125,5,3,'Plush toy teddy',0,'2018-08-27 18:35:23'),(126,5,3,'Plush toy teddy',0,'2018-08-27 18:35:26'),(127,5,3,'Soft',0,'2018-08-27 18:35:32'),(128,5,3,'Soft ',0,'2018-08-27 18:35:32'),(129,5,3,'Soft toy',0,'2018-08-27 18:35:33'),(130,5,3,'Soft toy',0,'2018-08-27 18:35:34'),(131,1,3,'Teddy',0,'2018-08-27 18:36:46'),(132,3,3,'C',0,'2018-08-29 11:36:49'),(133,3,3,'X',0,'2018-08-29 11:36:50'),(134,3,3,'Xb',0,'2018-08-29 11:36:51'),(135,3,3,'Xbo',0,'2018-08-29 11:36:51'),(136,3,3,'Xbox ',0,'2018-08-29 11:36:52'),(137,3,3,'Xbox ',0,'2018-08-29 11:36:52'),(138,1,3,'thrustmaster',0,'2018-08-31 16:19:38'),(139,1,3,'xbox',0,'2018-08-31 16:19:44'),(140,1,3,'thrustmaster',0,'2018-08-31 16:19:48'),(141,5,3,'lego',0,'2018-09-08 05:57:25'),(142,3,3,'ge',0,'2018-09-08 06:00:41'),(143,3,3,'geom',53,'2018-09-08 06:00:42'),(144,3,3,'geoma',53,'2018-09-08 06:00:42'),(145,3,3,'geomag',53,'2018-09-08 06:00:43'),(146,3,3,'geomag',53,'2018-09-08 06:00:43'),(147,3,3,'geomag',53,'2018-09-08 06:00:59'),(148,3,3,'geoma',53,'2018-09-08 06:01:04'),(149,1,3,'Lego',0,'2018-09-12 10:32:43'),(150,1,3,'tea set',0,'2018-09-12 15:45:50'),(151,6,3,'sam',0,'2018-09-16 10:32:52'),(152,6,3,'samsun',0,'2018-09-16 10:32:53'),(153,6,3,'samsung',0,'2018-09-16 10:32:53'),(154,6,3,'sma',28,'2018-09-16 10:33:03'),(155,6,3,'smarhom',0,'2018-09-16 10:33:06'),(156,6,3,'smarho',0,'2018-09-16 10:33:06'),(157,6,3,'smarhone',0,'2018-09-16 10:33:07'),(158,6,3,'smarhone',0,'2018-09-16 10:33:07'),(159,6,3,'smarhone',0,'2018-09-16 10:39:23'),(160,6,3,'samsung',0,'2018-09-16 10:39:25'),(161,1,3,'Batman',0,'2018-09-24 15:28:45');

--
-- Table structure for table `ps_stock`
--

CREATE TABLE `ps_stock` (
  `id_stock` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_warehouse` int(11) unsigned NOT NULL,
  `id_product` int(11) unsigned NOT NULL,
  `id_product_attribute` int(11) unsigned NOT NULL,
  `reference` varchar(32) NOT NULL,
  `ean13` varchar(13) DEFAULT NULL,
  `isbn` varchar(32) DEFAULT NULL,
  `upc` varchar(12) DEFAULT NULL,
  `physical_quantity` int(11) unsigned NOT NULL,
  `usable_quantity` int(11) unsigned NOT NULL,
  `price_te` decimal(20,6) DEFAULT '0.000000',
  PRIMARY KEY (`id_stock`),
  KEY `id_warehouse` (`id_warehouse`),
  KEY `id_product` (`id_product`),
  KEY `id_product_attribute` (`id_product_attribute`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_stock`
--


--
-- Table structure for table `ps_stock_available`
--

CREATE TABLE `ps_stock_available` (
  `id_stock_available` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_product` int(11) unsigned NOT NULL,
  `id_product_attribute` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  `id_shop_group` int(11) unsigned NOT NULL,
  `quantity` int(10) NOT NULL DEFAULT '0',
  `physical_quantity` int(11) NOT NULL DEFAULT '0',
  `reserved_quantity` int(11) NOT NULL DEFAULT '0',
  `depends_on_stock` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `out_of_stock` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_stock_available`),
  UNIQUE KEY `product_sqlstock` (`id_product`,`id_product_attribute`,`id_shop`,`id_shop_group`),
  KEY `id_shop` (`id_shop`),
  KEY `id_shop_group` (`id_shop_group`),
  KEY `id_product` (`id_product`),
  KEY `id_product_attribute` (`id_product_attribute`)
) ENGINE=InnoDB AUTO_INCREMENT=189 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_stock_available`
--

INSERT INTO `ps_stock_available` VALUES (59,18,0,1,0,0,0,0,0,0),(60,17,0,1,0,0,0,0,0,0),(61,16,0,1,0,0,0,0,0,0),(62,11,0,1,0,0,0,0,0,0),(63,10,0,1,0,0,0,0,0,0),(64,9,0,1,0,0,0,0,0,0),(65,5,0,1,0,0,0,0,0,0),(66,4,0,1,0,0,0,0,0,0),(67,3,0,1,0,0,0,0,0,0),(68,2,0,1,0,0,0,0,0,0),(69,1,0,1,0,0,0,0,0,0),(72,21,0,0,3,0,0,0,0,2),(74,23,0,0,3,0,0,0,0,2),(76,25,0,0,3,10,0,0,0,2),(77,26,0,0,3,10,0,0,0,0),(78,27,0,0,3,10,0,0,0,0),(79,28,0,0,3,10,0,0,0,0),(80,29,0,0,3,10,0,0,0,0),(81,30,0,0,3,10,0,0,0,0),(82,31,0,0,3,10,0,0,0,0),(90,39,0,0,3,10,0,0,0,0),(91,40,0,0,3,10,0,0,0,0),(92,41,0,0,3,10,0,0,0,0),(93,42,0,0,3,10,0,0,0,0),(94,43,0,0,3,10,0,0,0,0),(95,44,0,0,3,10,0,0,0,0),(96,45,0,0,3,10,0,0,0,0),(97,46,0,0,3,10,0,0,0,0),(98,47,0,0,3,10,0,0,0,0),(99,48,0,0,3,10,0,0,0,0),(100,49,0,0,3,10,0,0,0,0),(101,50,0,0,3,10,0,0,0,0),(102,51,0,0,3,10,0,0,0,0),(103,52,0,0,3,10,0,0,0,0),(104,53,0,0,3,10,0,0,0,0),(105,54,0,0,3,10,0,0,0,0),(106,55,0,0,3,10,0,0,0,0),(107,56,0,0,3,10,0,0,0,0),(108,57,0,0,3,10,0,0,0,0),(109,58,0,0,3,10,0,0,0,0),(110,59,0,0,3,10,0,0,0,0),(111,60,0,0,3,10,0,0,0,0),(112,61,0,0,3,10,0,0,0,0),(113,62,0,0,3,10,0,0,0,0),(114,63,0,0,3,10,0,0,0,0),(115,64,0,0,3,10,0,0,0,0),(116,65,0,0,3,10,0,0,0,0),(117,66,0,0,3,10,0,0,0,0),(118,67,0,0,3,10,0,0,0,0),(119,68,0,0,3,10,0,0,0,0),(120,69,0,0,3,10,0,0,0,0),(121,70,0,0,3,10,0,0,0,0),(122,71,0,0,3,10,0,0,0,0),(123,72,0,0,3,10,0,0,0,0),(124,73,0,0,3,10,0,0,0,0),(125,74,0,0,3,10,0,0,0,0),(126,75,0,0,3,10,0,0,0,0),(127,76,0,0,3,10,0,0,0,0),(128,77,0,0,3,0,0,0,0,0),(129,78,0,0,3,0,0,0,0,0),(130,79,0,0,3,0,0,0,0,0),(131,80,0,0,3,0,0,0,0,0),(132,81,0,0,3,0,0,0,0,0),(133,82,0,0,3,0,0,0,0,0),(134,83,0,0,3,0,0,0,0,0),(135,84,0,0,3,0,0,0,0,0),(136,85,0,0,3,0,0,0,0,0),(137,86,0,0,3,0,0,0,0,0),(138,87,0,0,3,0,0,0,0,0),(139,88,0,0,3,0,0,0,0,0),(140,89,0,0,3,0,0,0,0,0),(141,90,0,0,3,0,0,0,0,0),(142,91,0,0,3,0,0,0,0,0),(143,92,0,0,3,0,0,0,0,0),(144,93,0,0,3,0,0,0,0,0),(145,94,0,0,3,0,0,0,0,0),(146,95,0,0,3,0,0,0,0,0),(147,96,0,0,3,0,0,0,0,0),(148,97,0,0,3,0,0,0,0,0),(149,98,0,0,3,0,0,0,0,0),(150,99,0,0,3,0,0,0,0,0),(151,100,0,0,3,10,0,0,0,0),(152,101,0,0,3,10,0,0,0,0),(153,102,0,0,3,10,0,0,0,0),(154,103,0,0,3,10,0,0,0,0),(155,104,0,0,3,10,0,0,0,0),(156,105,0,0,3,10,0,0,0,0),(157,106,0,0,3,10,0,0,0,0),(158,107,0,0,3,10,0,0,0,0),(159,108,0,0,3,10,0,0,0,0),(160,109,0,0,3,10,0,0,0,0),(161,110,0,0,3,10,0,0,0,0),(162,111,0,0,3,10,0,0,0,0),(163,112,0,0,3,10,0,0,0,0),(164,113,0,0,3,10,0,0,0,0),(165,114,0,0,3,10,0,0,0,0),(166,115,0,0,3,10,0,0,0,0),(167,116,0,0,3,10,0,0,0,0),(168,117,0,0,3,10,0,0,0,0),(169,118,0,0,3,10,0,0,0,0),(170,119,0,0,3,10,0,0,0,0),(171,120,0,0,3,10,0,0,0,0),(172,121,0,0,3,10,0,0,0,0),(173,122,0,0,3,10,0,0,0,0),(174,123,0,0,3,10,0,0,0,0),(175,124,0,0,3,10,0,0,0,0),(176,125,0,0,3,10,0,0,0,0),(177,126,0,0,3,10,0,0,0,0),(178,127,0,0,3,10,0,0,0,0),(179,128,0,0,3,10,0,0,0,0),(180,129,0,0,3,10,0,0,0,0),(181,130,0,0,3,30,0,0,0,2),(182,130,1,0,3,10,0,0,0,2),(183,130,2,0,3,10,0,0,0,2),(184,130,3,0,3,10,0,0,0,2),(185,131,0,0,3,30,0,0,0,2),(186,131,4,0,3,10,0,0,0,2),(187,131,5,0,3,10,0,0,0,2),(188,131,6,0,3,10,0,0,0,2);

--
-- Table structure for table `ps_stock_mvt`
--

CREATE TABLE `ps_stock_mvt` (
  `id_stock_mvt` bigint(20) NOT NULL AUTO_INCREMENT,
  `id_stock` int(11) NOT NULL,
  `id_order` int(11) DEFAULT NULL,
  `id_supply_order` int(11) DEFAULT NULL,
  `id_stock_mvt_reason` int(11) NOT NULL,
  `id_employee` int(11) NOT NULL,
  `employee_lastname` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `employee_firstname` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `physical_quantity` int(11) NOT NULL,
  `date_add` datetime NOT NULL,
  `sign` smallint(6) NOT NULL DEFAULT '1',
  `price_te` decimal(20,6) DEFAULT '0.000000',
  `last_wa` decimal(20,6) DEFAULT '0.000000',
  `current_wa` decimal(20,6) DEFAULT '0.000000',
  `referer` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id_stock_mvt`),
  KEY `id_stock` (`id_stock`),
  KEY `id_stock_mvt_reason` (`id_stock_mvt_reason`)
) ENGINE=InnoDB AUTO_INCREMENT=239 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_stock_mvt`
--

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

--
-- Table structure for table `ps_stock_mvt_reason`
--

CREATE TABLE `ps_stock_mvt_reason` (
  `id_stock_mvt_reason` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sign` tinyint(1) NOT NULL DEFAULT '1',
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_stock_mvt_reason`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_stock_mvt_reason`
--

INSERT INTO `ps_stock_mvt_reason` VALUES (1,1,'2018-05-11 14:38:06','2018-05-11 14:38:06',0),(2,-1,'2018-05-11 14:38:06','2018-05-11 14:38:06',0),(3,-1,'2018-05-11 14:38:06','2018-05-11 14:38:06',0),(4,-1,'2018-05-11 14:38:06','2018-05-11 14:38:06',0),(5,1,'2018-05-11 14:38:06','2018-05-11 14:38:06',0),(6,-1,'2018-05-11 14:38:06','2018-05-11 14:38:06',0),(7,1,'2018-05-11 14:38:06','2018-05-11 14:38:06',0),(8,1,'2018-05-11 14:38:06','2018-05-11 14:38:06',0),(9,1,'2018-05-11 14:38:06','2018-05-11 14:38:06',0),(10,1,'2018-05-11 14:38:06','2018-05-11 14:38:06',0),(11,1,'2018-05-11 14:38:06','2018-05-11 14:38:06',0),(12,-1,'2018-05-11 14:38:06','2018-05-11 14:38:06',0);

--
-- Table structure for table `ps_stock_mvt_reason_lang`
--

CREATE TABLE `ps_stock_mvt_reason_lang` (
  `id_stock_mvt_reason` int(11) unsigned NOT NULL,
  `id_lang` int(11) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id_stock_mvt_reason`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_stock_mvt_reason_lang`
--

INSERT INTO `ps_stock_mvt_reason_lang` VALUES (1,1,'Increase'),(1,2,'Erhöhung'),(1,3,'Augmentation'),(1,4,'Aumento'),(2,1,'Decrease'),(2,2,'Reduzierung'),(2,3,'Diminution'),(2,4,'Diminuisci'),(3,1,'Customer Order'),(3,2,'Bestellung'),(3,3,'Commande client'),(3,4,'Ordine Cliente'),(4,1,'Regulation following an inventory of stock'),(4,2,'Regulation following an inventory of stock'),(4,3,'Regulation following an inventory of stock'),(4,4,'Regulation following an inventory of stock'),(5,1,'Regulation following an inventory of stock'),(5,2,'Regulation following an inventory of stock'),(5,3,'Regulation following an inventory of stock'),(5,4,'Regulation following an inventory of stock'),(6,1,'Transfer to another warehouse'),(6,2,'Übertragung in anderes Lager'),(6,3,'Transfert vers un autre entrepôt'),(6,4,'Trasferimento a un altro magazzino'),(7,1,'Transfer from another warehouse'),(7,2,'Übertragung von anderem Lager'),(7,3,'Transfert depuis un autre entrepôt'),(7,4,'Trasferimento da un altro magazzino'),(8,1,'Supply Order'),(8,2,'Lieferbestellung'),(8,3,'Commande fournisseur'),(8,4,'Ordine di Fornitura'),(9,1,'Customer Order'),(9,2,'Bestellung'),(9,3,'Commande client'),(9,4,'Ordine Cliente'),(10,1,'Product return'),(10,2,'Warenrücksendung'),(10,3,'Retour produit'),(10,4,'Reso di un Prodotto'),(11,1,'Employee Edition'),(11,2,'Employee Edition'),(11,3,'Employee Edition'),(11,4,'Employee Edition'),(12,1,'Employee Edition'),(12,2,'Employee Edition'),(12,3,'Employee Edition'),(12,4,'Employee Edition');

--
-- Table structure for table `ps_store`
--

CREATE TABLE `ps_store` (
  `id_store` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_country` int(10) unsigned NOT NULL,
  `id_state` int(10) unsigned DEFAULT NULL,
  `city` varchar(64) NOT NULL,
  `postcode` varchar(12) NOT NULL,
  `latitude` decimal(13,8) DEFAULT NULL,
  `longitude` decimal(13,8) DEFAULT NULL,
  `phone` varchar(16) DEFAULT NULL,
  `fax` varchar(16) DEFAULT NULL,
  `email` varchar(128) DEFAULT NULL,
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_store`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_store`
--

INSERT INTO `ps_store` VALUES (1,19,12,'Mendrisio','6850',45.87440900,8.97921200,'0041916961700','','info@tandg.quicklysa.ch',1,'2018-05-11 14:38:17','2018-06-26 18:15:59');

--
-- Table structure for table `ps_store_lang`
--

CREATE TABLE `ps_store_lang` (
  `id_store` int(11) unsigned NOT NULL,
  `id_lang` int(11) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `address1` varchar(255) NOT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `hours` text,
  `note` text,
  PRIMARY KEY (`id_store`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_store_lang`
--

INSERT INTO `ps_store_lang` VALUES (1,1,'Toys And Games','Fox Town','Via Angelo Maspoli 18','[[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"]]',''),(1,2,'Toys And Games','Fox Town','Via Angelo Maspoli 18','[[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"]]',''),(1,3,'Toys And Games','Fox Town','Via Angelo Maspoli 18','[[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"]]',''),(1,4,'Toys And Games','Fox Town','Via Angelo Maspoli 18','[[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"],[\"11:00AM - 07:00PM\"]]','');

--
-- Table structure for table `ps_store_shop`
--

CREATE TABLE `ps_store_shop` (
  `id_store` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_store`,`id_shop`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_store_shop`
--

INSERT INTO `ps_store_shop` VALUES (1,1),(1,3),(1,4),(1,5),(1,6),(1,7),(1,8),(1,9),(1,10),(1,11),(1,12),(1,13);

--
-- Table structure for table `ps_supplier`
--

CREATE TABLE `ps_supplier` (
  `id_supplier` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_supplier`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supplier`
--

INSERT INTO `ps_supplier` VALUES (1,'Carioca','2018-05-15 11:13:58','2018-05-15 11:13:58',1),(2,'Quercetti','2018-05-16 09:57:02','2018-05-16 09:57:02',1),(3,'NanoBlock','2018-05-16 17:49:00','2018-05-16 17:49:00',1),(4,'Geomag','2018-05-16 17:59:50','2018-05-16 17:59:50',1);

--
-- Table structure for table `ps_supplier_lang`
--

CREATE TABLE `ps_supplier_lang` (
  `id_supplier` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `description` text,
  `meta_title` varchar(128) DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_supplier`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supplier_lang`
--

INSERT INTO `ps_supplier_lang` VALUES (1,1,'','','',''),(1,2,'','','',''),(1,3,'','','',''),(1,4,'','','',''),(2,1,'','','',''),(2,2,'','','',''),(2,3,'','','',''),(2,4,'','','',''),(3,1,'','','',''),(3,2,'','','',''),(3,3,'','','',''),(3,4,'','','',''),(4,1,'','','',''),(4,2,'','','',''),(4,3,'','','',''),(4,4,'','','','');

--
-- Table structure for table `ps_supplier_shop`
--

CREATE TABLE `ps_supplier_shop` (
  `id_supplier` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_supplier`,`id_shop`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supplier_shop`
--

INSERT INTO `ps_supplier_shop` VALUES (1,1),(1,3),(4,3),(1,4),(2,4),(1,5),(1,6),(3,6),(1,7),(1,8),(1,9),(1,10),(4,10),(1,11),(3,11),(1,12),(2,12),(1,13);

--
-- Table structure for table `ps_supply_order`
--

CREATE TABLE `ps_supply_order` (
  `id_supply_order` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_supplier` int(11) unsigned NOT NULL,
  `supplier_name` varchar(64) NOT NULL,
  `id_lang` int(11) unsigned NOT NULL,
  `id_warehouse` int(11) unsigned NOT NULL,
  `id_supply_order_state` int(11) unsigned NOT NULL,
  `id_currency` int(11) unsigned NOT NULL,
  `id_ref_currency` int(11) unsigned NOT NULL,
  `reference` varchar(64) NOT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `date_delivery_expected` datetime DEFAULT NULL,
  `total_te` decimal(20,6) DEFAULT '0.000000',
  `total_with_discount_te` decimal(20,6) DEFAULT '0.000000',
  `total_tax` decimal(20,6) DEFAULT '0.000000',
  `total_ti` decimal(20,6) DEFAULT '0.000000',
  `discount_rate` decimal(20,6) DEFAULT '0.000000',
  `discount_value_te` decimal(20,6) DEFAULT '0.000000',
  `is_template` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id_supply_order`),
  KEY `id_supplier` (`id_supplier`),
  KEY `id_warehouse` (`id_warehouse`),
  KEY `reference` (`reference`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supply_order`
--


--
-- Table structure for table `ps_supply_order_detail`
--

CREATE TABLE `ps_supply_order_detail` (
  `id_supply_order_detail` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_supply_order` int(11) unsigned NOT NULL,
  `id_currency` int(11) unsigned NOT NULL,
  `id_product` int(11) unsigned NOT NULL,
  `id_product_attribute` int(11) unsigned NOT NULL,
  `reference` varchar(32) NOT NULL,
  `supplier_reference` varchar(32) NOT NULL,
  `name` varchar(128) NOT NULL,
  `ean13` varchar(13) DEFAULT NULL,
  `isbn` varchar(32) DEFAULT NULL,
  `upc` varchar(12) DEFAULT NULL,
  `exchange_rate` decimal(20,6) DEFAULT '0.000000',
  `unit_price_te` decimal(20,6) DEFAULT '0.000000',
  `quantity_expected` int(11) unsigned NOT NULL,
  `quantity_received` int(11) unsigned NOT NULL,
  `price_te` decimal(20,6) DEFAULT '0.000000',
  `discount_rate` decimal(20,6) DEFAULT '0.000000',
  `discount_value_te` decimal(20,6) DEFAULT '0.000000',
  `price_with_discount_te` decimal(20,6) DEFAULT '0.000000',
  `tax_rate` decimal(20,6) DEFAULT '0.000000',
  `tax_value` decimal(20,6) DEFAULT '0.000000',
  `price_ti` decimal(20,6) DEFAULT '0.000000',
  `tax_value_with_order_discount` decimal(20,6) DEFAULT '0.000000',
  `price_with_order_discount_te` decimal(20,6) DEFAULT '0.000000',
  PRIMARY KEY (`id_supply_order_detail`),
  KEY `id_supply_order` (`id_supply_order`,`id_product`),
  KEY `id_product_attribute` (`id_product_attribute`),
  KEY `id_product_product_attribute` (`id_product`,`id_product_attribute`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supply_order_detail`
--


--
-- Table structure for table `ps_supply_order_history`
--

CREATE TABLE `ps_supply_order_history` (
  `id_supply_order_history` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_supply_order` int(11) unsigned NOT NULL,
  `id_employee` int(11) unsigned NOT NULL,
  `employee_lastname` varchar(32) DEFAULT '',
  `employee_firstname` varchar(32) DEFAULT '',
  `id_state` int(11) unsigned NOT NULL,
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_supply_order_history`),
  KEY `id_supply_order` (`id_supply_order`),
  KEY `id_employee` (`id_employee`),
  KEY `id_state` (`id_state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supply_order_history`
--


--
-- Table structure for table `ps_supply_order_receipt_history`
--

CREATE TABLE `ps_supply_order_receipt_history` (
  `id_supply_order_receipt_history` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_supply_order_detail` int(11) unsigned NOT NULL,
  `id_employee` int(11) unsigned NOT NULL,
  `employee_lastname` varchar(32) DEFAULT '',
  `employee_firstname` varchar(32) DEFAULT '',
  `id_supply_order_state` int(11) unsigned NOT NULL,
  `quantity` int(11) unsigned NOT NULL,
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_supply_order_receipt_history`),
  KEY `id_supply_order_detail` (`id_supply_order_detail`),
  KEY `id_supply_order_state` (`id_supply_order_state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supply_order_receipt_history`
--


--
-- Table structure for table `ps_supply_order_state`
--

CREATE TABLE `ps_supply_order_state` (
  `id_supply_order_state` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `delivery_note` tinyint(1) NOT NULL DEFAULT '0',
  `editable` tinyint(1) NOT NULL DEFAULT '0',
  `receipt_state` tinyint(1) NOT NULL DEFAULT '0',
  `pending_receipt` tinyint(1) NOT NULL DEFAULT '0',
  `enclosed` tinyint(1) NOT NULL DEFAULT '0',
  `color` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id_supply_order_state`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supply_order_state`
--

INSERT INTO `ps_supply_order_state` VALUES (1,0,1,0,0,0,'#faab00'),(2,1,0,0,0,0,'#273cff'),(3,0,0,0,1,0,'#ff37f5'),(4,0,0,1,1,0,'#ff3e33'),(5,0,0,1,0,1,'#00d60c'),(6,0,0,0,0,1,'#666666');

--
-- Table structure for table `ps_supply_order_state_lang`
--

CREATE TABLE `ps_supply_order_state_lang` (
  `id_supply_order_state` int(11) unsigned NOT NULL,
  `id_lang` int(11) unsigned NOT NULL,
  `name` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id_supply_order_state`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supply_order_state_lang`
--

INSERT INTO `ps_supply_order_state_lang` VALUES (1,1,'1 - Creation in progress'),(1,2,'1 - In Bearbeitung'),(1,3,'1 - En cours de création'),(1,4,'1 - Creazione in corso'),(2,1,'2 - Order validated'),(2,2,'2 - Bestellung geprüft'),(2,3,'2 - Commande validée'),(2,4,'2 - Ordine convalidato'),(3,1,'3 - Pending receipt'),(3,2,'3 - Warten auf Rechnung'),(3,3,'3 - En attente de réception'),(3,4,'3 - In attesa di ricevimento'),(4,1,'4 - Order received in part'),(4,2,'4 - Teillieferung erhalten'),(4,3,'4 - Commande reçue partiellement'),(4,4,'4 - Ordine ricevuto in parte'),(5,1,'5 - Order received completely'),(5,2,'5 - Lieferung erhalten'),(5,3,'5 - Commande reçue intégralement'),(5,4,'5 - Ordine ricevuto completamente'),(6,1,'6 - Order canceled'),(6,2,'6 - Bestellung storniert'),(6,3,'6 - Commande annulée'),(6,4,'6 - Ordine annullato');

--
-- Table structure for table `ps_tab`
--

CREATE TABLE `ps_tab` (
  `id_tab` int(11) NOT NULL AUTO_INCREMENT,
  `id_parent` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `module` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
  `class_name` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
  `active` tinyint(1) NOT NULL,
  `hide_host_mode` tinyint(1) NOT NULL,
  `icon` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id_tab`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_tab`
--

INSERT INTO `ps_tab` VALUES (1,0,0,NULL,'AdminDashboard',1,0,'trending_up'),(2,0,1,NULL,'SELL',1,0,''),(3,2,0,NULL,'AdminParentOrders',1,0,'shopping_basket'),(4,3,0,NULL,'AdminOrders',1,0,''),(5,3,1,NULL,'AdminInvoices',1,0,''),(6,3,2,NULL,'AdminSlip',1,0,''),(7,3,3,NULL,'AdminDeliverySlip',1,0,''),(8,3,4,NULL,'AdminCarts',1,0,''),(9,2,1,NULL,'AdminCatalog',1,0,'store'),(10,9,0,NULL,'AdminProducts',1,0,''),(11,9,1,NULL,'AdminCategories',1,0,''),(12,9,2,NULL,'AdminTracking',1,0,''),(13,9,3,NULL,'AdminParentAttributesGroups',1,0,''),(14,13,0,NULL,'AdminAttributesGroups',1,0,''),(15,13,1,NULL,'AdminFeatures',1,0,''),(16,9,4,NULL,'AdminParentManufacturers',1,0,''),(17,16,0,NULL,'AdminManufacturers',1,0,''),(18,16,1,NULL,'AdminSuppliers',1,0,''),(19,9,5,NULL,'AdminAttachments',1,0,''),(20,9,6,NULL,'AdminParentCartRules',1,0,''),(21,20,0,NULL,'AdminCartRules',1,0,''),(22,20,1,NULL,'AdminSpecificPriceRule',1,0,''),(23,9,7,NULL,'AdminStockManagement',1,0,''),(24,2,2,NULL,'AdminParentCustomer',1,0,'account_circle'),(25,24,0,NULL,'AdminCustomers',1,0,''),(26,24,1,NULL,'AdminAddresses',1,0,''),(27,24,2,'','AdminOutstanding',0,0,''),(28,2,3,NULL,'AdminParentCustomerThreads',1,0,'chat'),(29,28,0,NULL,'AdminCustomerThreads',1,0,''),(30,28,1,NULL,'AdminOrderMessage',1,0,''),(31,28,2,NULL,'AdminReturn',1,0,''),(32,2,4,NULL,'AdminStats',1,0,'assessment'),(33,2,5,NULL,'AdminStock',1,0,'store'),(34,33,0,NULL,'AdminWarehouses',1,0,''),(35,33,1,NULL,'AdminParentStockManagement',1,0,''),(36,35,0,NULL,'AdminStockManagement',1,0,''),(37,36,0,NULL,'AdminStockMvt',1,0,''),(38,36,1,NULL,'AdminStockInstantState',1,0,''),(39,36,2,NULL,'AdminStockCover',1,0,''),(40,33,2,NULL,'AdminSupplyOrders',1,0,''),(41,33,3,NULL,'AdminStockConfiguration',1,0,''),(42,0,2,NULL,'IMPROVE',1,0,''),(43,42,0,NULL,'AdminParentModulesSf',1,0,'extension'),(44,43,0,NULL,'AdminModulesSf',1,0,''),(45,43,1,NULL,'AdminModules',0,0,''),(46,43,2,NULL,'AdminAddonsCatalog',1,0,''),(47,42,1,NULL,'AdminParentThemes',1,0,'desktop_mac'),(48,47,0,NULL,'AdminThemes',1,0,''),(49,47,1,NULL,'AdminThemesCatalog',1,0,''),(50,47,2,NULL,'AdminCmsContent',1,0,''),(51,47,3,NULL,'AdminModulesPositions',1,0,''),(52,47,4,NULL,'AdminImages',1,0,''),(53,42,2,NULL,'AdminParentShipping',1,0,'local_shipping'),(54,53,0,NULL,'AdminCarriers',1,0,''),(55,53,1,NULL,'AdminShipping',1,0,''),(56,42,3,NULL,'AdminParentPayment',1,0,'payment'),(57,56,0,NULL,'AdminPayment',1,0,''),(58,56,1,NULL,'AdminPaymentPreferences',1,0,''),(59,42,4,NULL,'AdminInternational',1,0,'language'),(60,59,0,NULL,'AdminParentLocalization',1,0,''),(61,60,0,NULL,'AdminLocalization',1,0,''),(62,60,1,NULL,'AdminLanguages',1,0,''),(63,60,2,NULL,'AdminCurrencies',1,0,''),(64,60,3,NULL,'AdminGeolocation',1,0,''),(65,59,1,NULL,'AdminParentCountries',1,0,''),(66,65,0,NULL,'AdminZones',1,0,''),(67,65,1,NULL,'AdminCountries',1,0,''),(68,65,2,NULL,'AdminStates',1,0,''),(69,59,2,NULL,'AdminParentTaxes',1,0,''),(70,69,0,NULL,'AdminTaxes',1,0,''),(71,69,1,NULL,'AdminTaxRulesGroup',1,0,''),(72,59,3,NULL,'AdminTranslations',1,0,''),(73,0,3,NULL,'CONFIGURE',1,0,''),(74,73,0,NULL,'ShopParameters',1,0,'settings'),(75,74,0,NULL,'AdminParentPreferences',1,0,''),(76,75,0,NULL,'AdminPreferences',1,0,''),(77,75,1,NULL,'AdminMaintenance',1,0,''),(78,74,1,NULL,'AdminParentOrderPreferences',1,0,''),(79,78,0,NULL,'AdminOrderPreferences',1,0,''),(80,78,1,NULL,'AdminStatuses',1,0,''),(81,74,2,NULL,'AdminPPreferences',1,0,''),(82,74,3,NULL,'AdminParentCustomerPreferences',1,0,''),(83,82,0,NULL,'AdminCustomerPreferences',1,0,''),(84,82,1,NULL,'AdminGroups',1,0,''),(85,82,2,NULL,'AdminGenders',1,0,''),(86,74,4,NULL,'AdminParentStores',1,0,''),(87,86,0,NULL,'AdminContacts',1,0,''),(88,86,1,NULL,'AdminStores',1,0,''),(89,74,5,NULL,'AdminParentMeta',1,0,''),(90,89,1,NULL,'AdminMeta',1,0,''),(91,89,2,NULL,'AdminSearchEngines',1,0,''),(92,89,3,NULL,'AdminReferrers',1,0,''),(93,74,6,NULL,'AdminParentSearchConf',1,0,''),(94,93,0,NULL,'AdminSearchConf',1,0,''),(95,93,1,NULL,'AdminTags',1,0,''),(96,73,1,NULL,'AdminAdvancedParameters',1,0,'settings_applications'),(97,96,0,NULL,'AdminInformation',1,0,''),(98,96,1,NULL,'AdminPerformance',1,0,''),(99,96,2,NULL,'AdminAdminPreferences',1,0,''),(100,96,3,NULL,'AdminEmails',1,0,''),(101,96,4,NULL,'AdminImport',1,0,''),(102,96,5,NULL,'AdminParentEmployees',1,0,''),(103,102,0,NULL,'AdminEmployees',1,0,''),(104,102,1,NULL,'AdminProfiles',1,0,''),(105,102,2,NULL,'AdminAccess',1,0,''),(106,96,6,NULL,'AdminParentRequestSql',1,0,''),(107,106,0,NULL,'AdminRequestSql',1,0,''),(108,106,1,NULL,'AdminBackup',1,0,''),(109,96,7,NULL,'AdminLogs',1,0,''),(110,96,8,NULL,'AdminWebservice',1,0,''),(111,96,9,'','AdminShopGroup',1,0,''),(112,96,10,NULL,'AdminShopUrl',0,0,''),(113,-1,0,NULL,'AdminQuickAccesses',1,0,''),(114,0,4,NULL,'DEFAULT',1,0,''),(115,-1,1,NULL,'AdminPatterns',1,0,''),(116,-1,2,'dashgoals','AdminDashgoals',1,0,''),(117,47,5,'ps_linklist','AdminLinkWidget',1,0,''),(118,0,5,'welcome','AdminWelcome',1,0,''),(119,74,7,'gamification','AdminGamification',1,0,''),(120,-1,3,'cronjobs','AdminCronJobs',1,0,''),(121,-1,4,'customtextdesign','AdminPdfOutput',1,0,''),(122,-1,5,'customtextdesign','AdminSvgOutput',1,0,''),(123,-1,6,'customtextdesign','AdminAjaxModule',1,0,''),(124,-1,7,'customtextdesign','AdminUploadModule',1,0,''),(125,-1,8,'psgdpr','AdminAjaxPsgdpr',1,0,''),(126,-1,9,'psgdpr','AdminDownloadInvoicesPsgdpr',1,0,'');

--
-- Table structure for table `ps_tab_advice`
--

CREATE TABLE `ps_tab_advice` (
  `id_tab` int(11) NOT NULL,
  `id_advice` int(11) NOT NULL,
  PRIMARY KEY (`id_tab`,`id_advice`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tab_advice`
--

INSERT INTO `ps_tab_advice` VALUES (0,3),(0,29),(0,55),(0,81),(0,107),(0,133),(0,160),(0,187),(0,215),(0,243),(0,271),(0,299),(0,326),(0,353),(0,380),(0,407),(0,434),(0,461),(0,488),(0,515),(0,542),(0,569),(0,596),(0,623),(0,650),(0,680),(1,2),(1,5),(1,6),(1,7),(1,8),(1,9),(1,10),(1,11),(1,12),(1,13),(1,14),(1,15),(1,16),(1,17),(1,18),(1,19),(1,20),(1,21),(1,22),(1,23),(1,24),(1,25),(1,26),(1,28),(1,31),(1,32),(1,33),(1,34),(1,35),(1,36),(1,37),(1,38),(1,39),(1,40),(1,41),(1,42),(1,43),(1,44),(1,45),(1,46),(1,47),(1,48),(1,49),(1,50),(1,51),(1,52),(1,54),(1,57),(1,58),(1,59),(1,60),(1,61),(1,62),(1,63),(1,64),(1,65),(1,66),(1,67),(1,68),(1,69),(1,70),(1,71),(1,72),(1,73),(1,74),(1,75),(1,76),(1,77),(1,78),(1,80),(1,83),(1,84),(1,85),(1,86),(1,87),(1,88),(1,89),(1,90),(1,91),(1,92),(1,93),(1,94),(1,95),(1,96),(1,97),(1,98),(1,99),(1,100),(1,101),(1,102),(1,103),(1,104),(1,106),(1,109),(1,110),(1,111),(1,112),(1,113),(1,114),(1,115),(1,116),(1,117),(1,118),(1,119),(1,120),(1,121),(1,122),(1,123),(1,124),(1,125),(1,126),(1,127),(1,128),(1,129),(1,130),(1,132),(1,135),(1,136),(1,137),(1,138),(1,139),(1,140),(1,141),(1,142),(1,143),(1,144),(1,145),(1,146),(1,147),(1,148),(1,149),(1,150),(1,151),(1,152),(1,153),(1,154),(1,155),(1,156),(1,157),(1,159),(1,162),(1,163),(1,164),(1,165),(1,166),(1,167),(1,168),(1,169),(1,170),(1,171),(1,172),(1,173),(1,174),(1,175),(1,176),(1,177),(1,178),(1,179),(1,180),(1,181),(1,182),(1,183),(1,184),(1,186),(1,189),(1,190),(1,191),(1,192),(1,193),(1,194),(1,195),(1,196),(1,197),(1,198),(1,199),(1,200),(1,201),(1,202),(1,203),(1,204),(1,205),(1,206),(1,207),(1,208),(1,209),(1,210),(1,211),(1,212),(1,214),(1,217),(1,218),(1,219),(1,220),(1,221),(1,222),(1,223),(1,224),(1,225),(1,226),(1,227),(1,228),(1,229),(1,230),(1,231),(1,232),(1,233),(1,234),(1,235),(1,236),(1,237),(1,238),(1,239),(1,240),(1,242),(1,245),(1,246),(1,247),(1,248),(1,249),(1,250),(1,251),(1,252),(1,253),(1,254),(1,255),(1,256),(1,257),(1,258),(1,259),(1,260),(1,261),(1,262),(1,263),(1,264),(1,265),(1,266),(1,267),(1,268),(1,270),(1,273),(1,274),(1,275),(1,276),(1,277),(1,278),(1,279),(1,280),(1,281),(1,282),(1,283),(1,284),(1,285),(1,286),(1,287),(1,288),(1,289),(1,290),(1,291),(1,292),(1,293),(1,294),(1,295),(1,296),(1,298),(1,301),(1,302),(1,303),(1,304),(1,305),(1,306),(1,307),(1,308),(1,309),(1,310),(1,311),(1,312),(1,313),(1,314),(1,315),(1,316),(1,317),(1,318),(1,319),(1,320),(1,321),(1,322),(1,323),(1,325),(1,328),(1,329),(1,330),(1,331),(1,332),(1,333),(1,334),(1,335),(1,336),(1,337),(1,338),(1,339),(1,340),(1,341),(1,342),(1,343),(1,344),(1,345),(1,346),(1,347),(1,348),(1,349),(1,350),(1,352),(1,355),(1,356),(1,357),(1,358),(1,359),(1,360),(1,361),(1,362),(1,363),(1,364),(1,365),(1,366),(1,367),(1,368),(1,369),(1,370),(1,371),(1,372),(1,373),(1,374),(1,375),(1,376),(1,377),(1,379),(1,382),(1,383),(1,384),(1,385),(1,386),(1,387),(1,388),(1,389),(1,390),(1,391),(1,392),(1,393),(1,394),(1,395),(1,396),(1,397),(1,398),(1,399),(1,400),(1,401),(1,402),(1,403),(1,404),(1,406),(1,409),(1,410),(1,411),(1,412),(1,413),(1,414),(1,415),(1,416),(1,417),(1,418),(1,419),(1,420),(1,421),(1,422),(1,423),(1,424),(1,425),(1,426),(1,427),(1,428),(1,429),(1,430),(1,431),(1,433),(1,436),(1,437),(1,438),(1,439),(1,440),(1,441),(1,442),(1,443),(1,444),(1,445),(1,446),(1,447),(1,448),(1,449),(1,450),(1,451),(1,452),(1,453),(1,454),(1,455),(1,456),(1,457),(1,458),(1,460),(1,463),(1,464),(1,465),(1,466),(1,467),(1,468),(1,469),(1,470),(1,471),(1,472),(1,473),(1,474),(1,475),(1,476),(1,477),(1,478),(1,479),(1,480),(1,481),(1,482),(1,483),(1,484),(1,485),(1,487),(1,490),(1,491),(1,492),(1,493),(1,494),(1,495),(1,496),(1,497),(1,498),(1,499),(1,500),(1,501),(1,502),(1,503),(1,504),(1,505),(1,506),(1,507),(1,508),(1,509),(1,510),(1,511),(1,512),(1,514),(1,517),(1,518),(1,519),(1,520),(1,521),(1,522),(1,523),(1,524),(1,525),(1,526),(1,527),(1,528),(1,529),(1,530),(1,531),(1,532),(1,533),(1,534),(1,535),(1,536),(1,537),(1,538),(1,539),(1,541),(1,544),(1,545),(1,546),(1,547),(1,548),(1,549),(1,550),(1,551),(1,552),(1,553),(1,554),(1,555),(1,556),(1,557),(1,558),(1,559),(1,560),(1,561),(1,562),(1,563),(1,564),(1,565),(1,566),(1,568),(1,571),(1,572),(1,573),(1,574),(1,575),(1,576),(1,577),(1,578),(1,579),(1,580),(1,581),(1,582),(1,583),(1,584),(1,585),(1,586),(1,587),(1,588),(1,589),(1,590),(1,591),(1,592),(1,593),(1,595),(1,598),(1,599),(1,600),(1,601),(1,602),(1,603),(1,604),(1,605),(1,606),(1,607),(1,608),(1,609),(1,610),(1,611),(1,612),(1,613),(1,614),(1,615),(1,616),(1,617),(1,618),(1,619),(1,620),(1,622),(1,625),(1,626),(1,627),(1,628),(1,629),(1,630),(1,631),(1,632),(1,633),(1,634),(1,635),(1,636),(1,637),(1,638),(1,639),(1,640),(1,641),(1,642),(1,643),(1,644),(1,645),(1,646),(1,647),(1,649),(1,652),(1,653),(1,654),(1,655),(1,656),(1,657),(1,658),(1,659),(1,660),(1,661),(1,662),(1,663),(1,664),(1,665),(1,666),(1,667),(1,668),(1,669),(1,670),(1,671),(1,672),(1,673),(1,674),(1,676),(1,683),(1,684),(1,685),(1,686),(1,687),(1,688),(1,689),(1,690),(1,691),(1,692),(1,693),(1,694),(1,695),(1,696),(1,697),(1,698),(1,699),(1,700),(1,701),(1,702),(1,703),(1,704),(1,705),(1,706),(1,707),(1,708),(1,709),(1,710),(1,711),(1,712),(1,713),(1,714),(1,715),(10,682),(25,4),(25,30),(25,56),(25,82),(25,108),(25,134),(25,161),(25,188),(25,216),(25,244),(25,272),(25,300),(25,327),(25,354),(25,381),(25,408),(25,435),(25,462),(25,489),(25,516),(25,543),(25,570),(25,597),(25,624),(25,651),(25,681),(29,4),(29,30),(29,56),(29,82),(29,108),(29,134),(29,161),(29,188),(29,216),(29,244),(29,272),(29,300),(29,327),(29,354),(29,381),(29,408),(29,435),(29,462),(29,489),(29,516),(29,543),(29,570),(29,597),(29,624),(29,651),(29,681),(57,678),(66,677),(72,1),(72,27),(72,53),(72,79),(72,105),(72,131),(72,158),(72,185),(72,213),(72,241),(72,269),(72,297),(72,324),(72,351),(72,378),(72,405),(72,432),(72,459),(72,486),(72,513),(72,540),(72,567),(72,594),(72,621),(72,648),(72,675),(79,679);

--
-- Table structure for table `ps_tab_lang`
--

CREATE TABLE `ps_tab_lang` (
  `id_tab` int(11) NOT NULL,
  `id_lang` int(11) NOT NULL,
  `name` varchar(128) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id_tab`,`id_lang`),
  KEY `IDX_CFD9262DED47AB56` (`id_tab`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_tab_lang`
--

INSERT INTO `ps_tab_lang` VALUES (1,1,'Dashboard'),(1,2,'Übersicht'),(1,3,'Tableau de bord'),(1,4,'Pannello di controllo'),(2,1,'Sell'),(2,2,'Verkauf'),(2,3,'Vendre'),(2,4,'Vendi'),(3,1,'Orders'),(3,2,'Bestellungen'),(3,3,'Commandes'),(3,4,'Ordini'),(4,1,'Orders'),(4,2,'Bestellungen'),(4,3,'Commandes'),(4,4,'Ordini'),(5,1,'Invoices'),(5,2,'Rechnungen'),(5,3,'Factures'),(5,4,'Fatture'),(6,1,'Credit Slips'),(6,2,'Rückvergütungen'),(6,3,'Avoirs'),(6,4,'Buoni sconto'),(7,1,'Delivery Slips'),(7,2,'Lieferscheine'),(7,3,'Bons de livraison'),(7,4,'Bolle di consegna'),(8,1,'Shopping Carts'),(8,2,'Warenkörbe'),(8,3,'Paniers'),(8,4,'Carrello della spesa'),(9,1,'Catalog'),(9,2,'Katalog'),(9,3,'Catalogue'),(9,4,'Catalogo'),(10,1,'Products'),(10,2,'Artikel'),(10,3,'Produits'),(10,4,'Prodotti'),(11,1,'Categories'),(11,2,'Kategorien'),(11,3,'Catégories'),(11,4,'Categorie'),(12,1,'Monitoring'),(12,2,'Kontrollübersicht'),(12,3,'Suivi'),(12,4,'Monitoraggio'),(13,1,'Attributes & Features'),(13,2,'Varianten & Eigenschaften'),(13,3,'Attributs & caractéristiques'),(13,4,'Attributi e Funzionalità'),(14,1,'Attributes'),(14,2,'Varianten'),(14,3,'Attributs'),(14,4,'Attributi'),(15,1,'Features'),(15,2,'Maßnahmen'),(15,3,'Caractéristiques'),(15,4,'Funzioni'),(16,1,'Brands & Suppliers'),(16,2,'Marken & Lieferanten'),(16,3,'Marques et fournisseurs'),(16,4,'Marche & Fornitori'),(17,1,'Brands'),(17,2,'Marken'),(17,3,'Marques'),(17,4,'Marchi'),(18,1,'Suppliers'),(18,2,'Lieferanten'),(18,3,'Fournisseurs'),(18,4,'Fornitori'),(19,1,'Files'),(19,2,'Dateien'),(19,3,'Fichiers'),(19,4,'File'),(20,1,'Discounts'),(20,2,'Rabatt'),(20,3,'Réductions'),(20,4,'Buoni sconto'),(21,1,'Cart Rules'),(21,2,'Warenkorb Preisregeln'),(21,3,'Règles panier'),(21,4,'Regole Carrello'),(22,1,'Catalog Price Rules'),(22,2,'Katalog Preisregeln'),(22,3,'Règles de prix catalogue'),(22,4,'Regole Catalogo Prezzi'),(23,1,'Stocks'),(23,2,'Stocks'),(23,3,'Stocks'),(23,4,'Stocks'),(24,1,'Customers'),(24,2,'Kunden'),(24,3,'Clients'),(24,4,'Clienti'),(25,1,'Customers'),(25,2,'Kunden'),(25,3,'Clients'),(25,4,'Clienti'),(26,1,'Addresses'),(26,2,'Adressen'),(26,3,'Adresses'),(26,4,'Indirizzi'),(27,1,'Outstanding'),(27,2,'Offene Posten'),(27,3,'Encours autorisés'),(27,4,'In sospeso'),(28,1,'Customer Service'),(28,2,'Kundenservice'),(28,3,'SAV'),(28,4,'Servizio clienti'),(29,1,'Customer Service'),(29,2,'Kundenservice'),(29,3,'SAV'),(29,4,'Servizio clienti'),(30,1,'Order Messages'),(30,2,'Bestellnachrichten'),(30,3,'Messages prédéfinis'),(30,4,'Messaggi d\'ordine'),(31,1,'Merchandise Returns'),(31,2,'Warenrücksendungen'),(31,3,'Retours produits'),(31,4,'Restituzione Prodotto'),(32,1,'Stats'),(32,2,'Statistiken'),(32,3,'Statistiques'),(32,4,'Statistiche'),(34,1,'Warehouses'),(34,2,'Lager'),(34,3,'Entrepôts'),(34,4,'Magazzini'),(35,1,'Stock Management'),(35,2,'Lagerverwaltung'),(35,3,'Gestion du stock'),(35,4,'Gestione del Magazzino'),(36,1,'Stock Management'),(36,2,'Lagerverwaltung'),(36,3,'Gestion du stock'),(36,4,'Gestione del Magazzino'),(37,1,'Stock Movement'),(37,2,'Lagerbewegung'),(37,3,'Mouvements de stock'),(37,4,'Movimenti di magazzino'),(38,1,'Instant Stock Status'),(38,2,'Aktueller Lagerbestand'),(38,3,'État instantané du stock'),(38,4,'Stato dello Stock Istantaneo'),(39,1,'Stock Coverage'),(39,2,'Lagerbestand'),(39,3,'Couverture du stock'),(39,4,'Disponibilità di magazzino'),(40,1,'Supply orders'),(40,2,'Bestellaufträge'),(40,3,'Commandes fournisseurs'),(40,4,'Ordini fornitura'),(41,1,'Configuration'),(41,2,'Einstellungen'),(41,3,'Paramètres'),(41,4,'Configurazione'),(42,1,'Improve'),(42,2,'Optimierung'),(42,3,'Personnaliser'),(42,4,'Migliora'),(43,1,'Modules'),(43,2,'Module'),(43,3,'Modules'),(43,4,'Moduli'),(44,1,'Modules & Services'),(44,2,'Module und Dienste'),(44,3,'Modules et services'),(44,4,'Moduli & Servizi'),(46,1,'Modules Catalog'),(46,2,'Versanddienst'),(46,3,'Catalogue de modules'),(46,4,'Strumenti di Compra-Vendita'),(47,1,'Design'),(47,2,'Design'),(47,3,'Apparence'),(47,4,'Design'),(48,1,'Theme & Logo'),(48,2,'Template und Logo'),(48,3,'Thème et logo'),(48,4,'Tema & Logo'),(49,1,'Theme Catalog'),(49,2,'Templates'),(49,3,'Catalogue de thèmes'),(49,4,'Catalogo dei Temi'),(50,1,'Pages'),(50,2,'Seiten'),(50,3,'Pages CMS'),(50,4,'Pagine'),(51,1,'Positions'),(51,2,'Positionen'),(51,3,'Positions'),(51,4,'Posizioni'),(52,1,'Image Settings'),(52,2,'Bilder'),(52,3,'Images'),(52,4,'Impostazioni immagine'),(53,1,'Shipping'),(53,2,'Versand'),(53,3,'Livraison'),(53,4,'Spedizione'),(54,1,'Carriers'),(54,2,'Versanddienste'),(54,3,'Transporteurs'),(54,4,'Mezzi di spedizione'),(55,1,'Preferences'),(55,2,'Voreinstellungen'),(55,3,'Préférences'),(55,4,'Impostazioni'),(56,1,'Payment'),(56,2,'Zahlungsart'),(56,3,'Paiement'),(56,4,'Pagamento'),(57,1,'Payment Methods'),(57,2,'Zahlungsarten'),(57,3,'Modes de paiement'),(57,4,'Metodi di Pagamento'),(58,1,'Preferences'),(58,2,'Voreinstellungen'),(58,3,'Préférences'),(58,4,'Impostazioni'),(59,1,'International'),(59,2,'international'),(59,3,'International'),(59,4,'Internazionale'),(60,1,'Localization'),(60,2,'Lokalisierung'),(60,3,'Localisation'),(60,4,'Localizzazione'),(61,1,'Localization'),(61,2,'Lokalisierung'),(61,3,'Localisation'),(61,4,'Localizzazione'),(62,1,'Languages'),(62,2,'Sprachen'),(62,3,'Langues'),(62,4,'Lingue'),(63,1,'Currencies'),(63,2,'Währungen'),(63,3,'Devises'),(63,4,'Valute'),(64,1,'Geolocation'),(64,2,'Geotargeting'),(64,3,'Géolocalisation'),(64,4,'Geolocalizzazione'),(65,1,'Locations'),(65,2,'Länder & Gebiete'),(65,3,'Zones géographiques'),(65,4,'Località'),(66,1,'Zones'),(66,2,'Gebiete'),(66,3,'Zones'),(66,4,'Zone'),(67,1,'Countries'),(67,2,'Länder'),(67,3,'Pays'),(67,4,'Nazione'),(68,1,'States'),(68,2,'Bundesländer'),(68,3,'États'),(68,4,'Province'),(69,1,'Taxes'),(69,2,'Steuersätze'),(69,3,'Taxes'),(69,4,'Tasse'),(70,1,'Taxes'),(70,2,'Steuersätze'),(70,3,'Taxes'),(70,4,'Tasse'),(71,1,'Tax Rules'),(71,2,'Steuerregeln'),(71,3,'Règles de taxes'),(71,4,'Aliquote Iva'),(72,1,'Translations'),(72,2,'Übersetzungen'),(72,3,'Traductions'),(72,4,'Traduzioni'),(73,1,'Configure'),(73,2,'Einstellungen'),(73,3,'Configurer'),(73,4,'Configura'),(74,1,'Shop Parameters'),(74,2,'Shop-Einstellungen'),(74,3,'Paramètres de la boutique'),(74,4,'Parametri Negozio'),(75,1,'General'),(75,2,'Allgemein'),(75,3,'Paramètres généraux'),(75,4,'Generale'),(76,1,'General'),(76,2,'Allgemein'),(76,3,'Paramètres généraux'),(76,4,'Generale'),(77,1,'Maintenance'),(77,2,'Wartung'),(77,3,'Maintenance'),(77,4,'Manutenzione'),(78,1,'Order Settings'),(78,2,'Bestellungen'),(78,3,'Commandes'),(78,4,'Impostazioni Ordine'),(79,1,'Order Settings'),(79,2,'Bestellungen'),(79,3,'Commandes'),(79,4,'Impostazioni Ordine'),(80,1,'Statuses'),(80,2,'Status'),(80,3,'États de commandes'),(80,4,'Stati'),(81,1,'Product Settings'),(81,2,'Artikel'),(81,3,'Produits'),(81,4,'Prodotti'),(82,1,'Customer Settings'),(82,2,'Benutzerdefinierte Einstellungen'),(82,3,'Clients'),(82,4,'Impostazioni clienti'),(83,1,'Customers'),(83,2,'Kunden'),(83,3,'Clients'),(83,4,'Clienti'),(84,1,'Groups'),(84,2,'Gruppen'),(84,3,'Groupes'),(84,4,'Gruppi'),(85,1,'Titles'),(85,2,'Anreden'),(85,3,'Titres de civilité'),(85,4,'Titoli'),(86,1,'Contact'),(86,2,'Kontakt'),(86,3,'Contact'),(86,4,'Contatto'),(87,1,'Contacts'),(87,2,'Kontakte'),(87,3,'Contacts'),(87,4,'Contatti'),(88,1,'Stores'),(88,2,'Shops'),(88,3,'Magasins'),(88,4,'Negozi'),(89,1,'Traffic & SEO'),(89,2,'Traffic & SEO'),(89,3,'Trafic et SEO'),(89,4,'Traffico & SEO'),(90,1,'SEO & URLs'),(90,2,'SEO & URLs'),(90,3,'SEO & URL'),(90,4,'SEO & URLs'),(91,1,'Search Engines'),(91,2,'Suchmaschinen'),(91,3,'Moteurs de recherche'),(91,4,'Motori di ricerca'),(92,1,'Referrers'),(92,2,'Referrer'),(92,3,'Affiliés'),(92,4,'Affiliati'),(93,1,'Search'),(93,2,'Suche'),(93,3,'Rechercher'),(93,4,'Cerca'),(94,1,'Search'),(94,2,'Suche'),(94,3,'Rechercher'),(94,4,'Cerca'),(95,1,'Tags'),(95,2,'Stichwörter'),(95,3,'Mots-clés'),(95,4,'Tags'),(96,1,'Advanced Parameters'),(96,2,'Erweiterte Einstellungen'),(96,3,'Paramètres avancés'),(96,4,'Parametri Avanzati'),(97,1,'Information'),(97,2,'Informationen'),(97,3,'Informations'),(97,4,'Informazioni'),(98,1,'Performance'),(98,2,'Leistung'),(98,3,'Performances'),(98,4,'Prestazioni'),(99,1,'Administration'),(99,2,'Verwaltung'),(99,3,'Administration'),(99,4,'Amministrazione'),(100,1,'E-mail'),(100,2,'E-Mail'),(100,3,'Email'),(100,4,'Email'),(101,1,'Import'),(101,2,'Importieren'),(101,3,'Importer'),(101,4,'Importa'),(102,1,'Team'),(102,2,'Benutzerrechte'),(102,3,'Équipe'),(102,4,'Dipendenti'),(103,1,'Employees'),(103,2,'Mitarbeiter'),(103,3,'Employés'),(103,4,'Dipendenti'),(104,1,'Profiles'),(104,2,'Profile'),(104,3,'Profils'),(104,4,'Profili'),(105,1,'Permissions'),(105,2,'Berechtigungen'),(105,3,'Permissions'),(105,4,'Permessi'),(106,1,'Database'),(106,2,'Datenbank'),(106,3,'Base de données'),(106,4,'Database'),(107,1,'SQL Manager'),(107,2,'SQL-Abfragen'),(107,3,'Gestionnaire SQL'),(107,4,'Manager SQL'),(108,1,'DB Backup'),(108,2,'Datenbank-Backup'),(108,3,'Sauvegarde BDD'),(108,4,'Backup DB'),(109,1,'Logs'),(109,2,'Log-Dateien'),(109,3,'Logs'),(109,4,'Logs'),(110,1,'Webservice'),(110,2,'Webservice'),(110,3,'Webservice'),(110,4,'Webservice'),(111,1,'Multistore'),(111,2,'Multishop'),(111,3,'Multiboutique'),(111,4,'Multinegozio'),(112,1,'Multistore'),(112,2,'Multishop'),(112,3,'Multiboutique'),(112,4,'Multinegozio'),(113,1,'Quick Access'),(113,2,'Schnellzugriff'),(113,3,'Accès rapide'),(113,4,'Accesso Veloce'),(114,1,'More'),(114,2,'Mehr'),(114,3,'Détails'),(114,4,'Più'),(116,1,'Dashgoals'),(116,2,'Dashgoals'),(116,3,'Dashgoals'),(116,4,'Dashgoals'),(117,1,'Link Widget'),(117,2,'Link Widget'),(117,3,'Link Widget'),(117,4,'Link Widget'),(118,1,'Welcome'),(118,2,'Welcome'),(118,3,'Welcome'),(118,4,'Welcome'),(119,1,'Merchant Expertise'),(119,2,'Merchant Expertise'),(119,3,'Merchant Expertise'),(119,4,'Merchant Expertise'),(120,1,'Cron Jobs'),(120,2,'Cron Jobs'),(120,3,'Cron Jobs'),(120,4,'Cron Jobs'),(121,1,'Admin Pdf Output'),(121,2,'Admin Pdf Output'),(121,3,'Admin Pdf Output'),(121,4,'Admin Pdf Output'),(122,1,'Admin Svg Output'),(122,2,'Admin Svg Output'),(122,3,'Admin Svg Output'),(122,4,'Admin Svg Output'),(123,1,'Admin Ajax Module'),(123,2,'Admin Ajax Module'),(123,3,'Admin Ajax Module'),(123,4,'Admin Ajax Module'),(124,1,'Admin Upload Module'),(124,2,'Admin Upload Module'),(124,3,'Admin Upload Module'),(124,4,'Admin Upload Module'),(125,1,'psgdpr'),(125,2,'psgdpr'),(125,3,'psgdpr'),(125,4,'psgdpr'),(126,1,'psgdpr'),(126,2,'psgdpr'),(126,3,'psgdpr'),(126,4,'psgdpr');

--
-- Table structure for table `ps_tab_module_preference`
--

CREATE TABLE `ps_tab_module_preference` (
  `id_tab_module_preference` int(11) NOT NULL AUTO_INCREMENT,
  `id_employee` int(11) NOT NULL,
  `id_tab` int(11) NOT NULL,
  `module` varchar(255) NOT NULL,
  PRIMARY KEY (`id_tab_module_preference`),
  UNIQUE KEY `employee_module` (`id_employee`,`id_tab`,`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tab_module_preference`
--


--
-- Table structure for table `ps_tag`
--

CREATE TABLE `ps_tag` (
  `id_tag` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_lang` int(10) unsigned NOT NULL,
  `name` varchar(32) NOT NULL,
  PRIMARY KEY (`id_tag`),
  KEY `tag_name` (`name`),
  KEY `id_lang` (`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tag`
--


--
-- Table structure for table `ps_tag_count`
--

CREATE TABLE `ps_tag_count` (
  `id_group` int(10) unsigned NOT NULL DEFAULT '0',
  `id_tag` int(10) unsigned NOT NULL DEFAULT '0',
  `id_lang` int(10) unsigned NOT NULL DEFAULT '0',
  `id_shop` int(11) unsigned NOT NULL DEFAULT '0',
  `counter` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_group`,`id_tag`),
  KEY `id_group` (`id_group`,`id_lang`,`id_shop`,`counter`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tag_count`
--


--
-- Table structure for table `ps_tax`
--

CREATE TABLE `ps_tax` (
  `id_tax` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rate` decimal(10,3) NOT NULL,
  `active` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_tax`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tax`
--

INSERT INTO `ps_tax` VALUES (1,7.700,1,0),(2,3.800,1,0),(3,2.500,1,0);

--
-- Table structure for table `ps_tax_lang`
--

CREATE TABLE `ps_tax_lang` (
  `id_tax` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `name` varchar(32) NOT NULL,
  PRIMARY KEY (`id_tax`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tax_lang`
--

INSERT INTO `ps_tax_lang` VALUES (1,1,'TVA CH 7.7%'),(1,2,'TVA CH 7.7%'),(1,3,'TVA CH 7.7%'),(1,4,'IVA CH 7.7%'),(2,1,'TVA CH 3.8%'),(2,2,'TVA CH 3.8%'),(2,3,'TVA CH 3.8%'),(2,4,'TVA CH 3.8%'),(3,1,'TVA CH 2.5%'),(3,2,'TVA CH 2.5%'),(3,3,'TVA CH 2.5%'),(3,4,'TVA CH 2.5%');

--
-- Table structure for table `ps_tax_rule`
--

CREATE TABLE `ps_tax_rule` (
  `id_tax_rule` int(11) NOT NULL AUTO_INCREMENT,
  `id_tax_rules_group` int(11) NOT NULL,
  `id_country` int(11) NOT NULL,
  `id_state` int(11) NOT NULL,
  `zipcode_from` varchar(12) NOT NULL,
  `zipcode_to` varchar(12) NOT NULL,
  `id_tax` int(11) NOT NULL,
  `behavior` int(11) NOT NULL,
  `description` varchar(100) NOT NULL,
  PRIMARY KEY (`id_tax_rule`),
  KEY `id_tax_rules_group` (`id_tax_rules_group`),
  KEY `id_tax` (`id_tax`),
  KEY `category_getproducts` (`id_tax_rules_group`,`id_country`,`id_state`,`zipcode_from`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tax_rule`
--

INSERT INTO `ps_tax_rule` VALUES (1,1,19,0,'0','0',1,0,''),(2,2,19,0,'0','0',2,0,''),(3,3,19,0,'0','0',3,0,'');

--
-- Table structure for table `ps_tax_rules_group`
--

CREATE TABLE `ps_tax_rules_group` (
  `id_tax_rules_group` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `active` int(11) NOT NULL,
  `deleted` tinyint(1) unsigned NOT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_tax_rules_group`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tax_rules_group`
--

INSERT INTO `ps_tax_rules_group` VALUES (1,'CH Standard Rate (7.7%)',1,0,'2018-05-11 14:38:10','2018-05-15 10:36:13'),(2,'CH Reduced Rate (3.8%)',1,0,'2018-05-11 14:38:10','2018-05-11 14:38:10'),(3,'CH Super Reduced Rate (2.5%)',1,0,'2018-05-11 14:38:10','2018-05-11 14:38:10');

--
-- Table structure for table `ps_tax_rules_group_shop`
--

CREATE TABLE `ps_tax_rules_group_shop` (
  `id_tax_rules_group` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_tax_rules_group`,`id_shop`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tax_rules_group_shop`
--

INSERT INTO `ps_tax_rules_group_shop` VALUES (1,1),(2,1),(3,1),(1,3),(2,3),(3,3),(1,4),(2,4),(3,4),(1,5),(2,5),(3,5),(1,6),(2,6),(3,6),(1,7),(2,7),(3,7),(1,8),(2,8),(3,8),(1,9),(2,9),(3,9),(1,10),(2,10),(3,10),(1,11),(2,11),(3,11),(1,12),(2,12),(3,12),(1,13),(2,13),(3,13);

--
-- Table structure for table `ps_testimonialinfo`
--

CREATE TABLE `ps_testimonialinfo` (
  `id_testimonialinfo` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_shop` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id_testimonialinfo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_testimonialinfo`
--


--
-- Table structure for table `ps_testimonialinfo_lang`
--

CREATE TABLE `ps_testimonialinfo_lang` (
  `id_testimonialinfo` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY (`id_testimonialinfo`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_testimonialinfo_lang`
--


--
-- Table structure for table `ps_timezone`
--

CREATE TABLE `ps_timezone` (
  `id_timezone` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  PRIMARY KEY (`id_timezone`)
) ENGINE=InnoDB AUTO_INCREMENT=561 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_timezone`
--

INSERT INTO `ps_timezone` VALUES (1,'Africa/Abidjan'),(2,'Africa/Accra'),(3,'Africa/Addis_Ababa'),(4,'Africa/Algiers'),(5,'Africa/Asmara'),(6,'Africa/Asmera'),(7,'Africa/Bamako'),(8,'Africa/Bangui'),(9,'Africa/Banjul'),(10,'Africa/Bissau'),(11,'Africa/Blantyre'),(12,'Africa/Brazzaville'),(13,'Africa/Bujumbura'),(14,'Africa/Cairo'),(15,'Africa/Casablanca'),(16,'Africa/Ceuta'),(17,'Africa/Conakry'),(18,'Africa/Dakar'),(19,'Africa/Dar_es_Salaam'),(20,'Africa/Djibouti'),(21,'Africa/Douala'),(22,'Africa/El_Aaiun'),(23,'Africa/Freetown'),(24,'Africa/Gaborone'),(25,'Africa/Harare'),(26,'Africa/Johannesburg'),(27,'Africa/Kampala'),(28,'Africa/Khartoum'),(29,'Africa/Kigali'),(30,'Africa/Kinshasa'),(31,'Africa/Lagos'),(32,'Africa/Libreville'),(33,'Africa/Lome'),(34,'Africa/Luanda'),(35,'Africa/Lubumbashi'),(36,'Africa/Lusaka'),(37,'Africa/Malabo'),(38,'Africa/Maputo'),(39,'Africa/Maseru'),(40,'Africa/Mbabane'),(41,'Africa/Mogadishu'),(42,'Africa/Monrovia'),(43,'Africa/Nairobi'),(44,'Africa/Ndjamena'),(45,'Africa/Niamey'),(46,'Africa/Nouakchott'),(47,'Africa/Ouagadougou'),(48,'Africa/Porto-Novo'),(49,'Africa/Sao_Tome'),(50,'Africa/Timbuktu'),(51,'Africa/Tripoli'),(52,'Africa/Tunis'),(53,'Africa/Windhoek'),(54,'America/Adak'),(55,'America/Anchorage '),(56,'America/Anguilla'),(57,'America/Antigua'),(58,'America/Araguaina'),(59,'America/Argentina/Buenos_Aires'),(60,'America/Argentina/Catamarca'),(61,'America/Argentina/ComodRivadavia'),(62,'America/Argentina/Cordoba'),(63,'America/Argentina/Jujuy'),(64,'America/Argentina/La_Rioja'),(65,'America/Argentina/Mendoza'),(66,'America/Argentina/Rio_Gallegos'),(67,'America/Argentina/Salta'),(68,'America/Argentina/San_Juan'),(69,'America/Argentina/San_Luis'),(70,'America/Argentina/Tucuman'),(71,'America/Argentina/Ushuaia'),(72,'America/Aruba'),(73,'America/Asuncion'),(74,'America/Atikokan'),(75,'America/Atka'),(76,'America/Bahia'),(77,'America/Barbados'),(78,'America/Belem'),(79,'America/Belize'),(80,'America/Blanc-Sablon'),(81,'America/Boa_Vista'),(82,'America/Bogota'),(83,'America/Boise'),(84,'America/Buenos_Aires'),(85,'America/Cambridge_Bay'),(86,'America/Campo_Grande'),(87,'America/Cancun'),(88,'America/Caracas'),(89,'America/Catamarca'),(90,'America/Cayenne'),(91,'America/Cayman'),(92,'America/Chicago'),(93,'America/Chihuahua'),(94,'America/Coral_Harbour'),(95,'America/Cordoba'),(96,'America/Costa_Rica'),(97,'America/Cuiaba'),(98,'America/Curacao'),(99,'America/Danmarkshavn'),(100,'America/Dawson'),(101,'America/Dawson_Creek'),(102,'America/Denver'),(103,'America/Detroit'),(104,'America/Dominica'),(105,'America/Edmonton'),(106,'America/Eirunepe'),(107,'America/El_Salvador'),(108,'America/Ensenada'),(109,'America/Fort_Wayne'),(110,'America/Fortaleza'),(111,'America/Glace_Bay'),(112,'America/Godthab'),(113,'America/Goose_Bay'),(114,'America/Grand_Turk'),(115,'America/Grenada'),(116,'America/Guadeloupe'),(117,'America/Guatemala'),(118,'America/Guayaquil'),(119,'America/Guyana'),(120,'America/Halifax'),(121,'America/Havana'),(122,'America/Hermosillo'),(123,'America/Indiana/Indianapolis'),(124,'America/Indiana/Knox'),(125,'America/Indiana/Marengo'),(126,'America/Indiana/Petersburg'),(127,'America/Indiana/Tell_City'),(128,'America/Indiana/Vevay'),(129,'America/Indiana/Vincennes'),(130,'America/Indiana/Winamac'),(131,'America/Indianapolis'),(132,'America/Inuvik'),(133,'America/Iqaluit'),(134,'America/Jamaica'),(135,'America/Jujuy'),(136,'America/Juneau'),(137,'America/Kentucky/Louisville'),(138,'America/Kentucky/Monticello'),(139,'America/Knox_IN'),(140,'America/La_Paz'),(141,'America/Lima'),(142,'America/Los_Angeles'),(143,'America/Louisville'),(144,'America/Maceio'),(145,'America/Managua'),(146,'America/Manaus'),(147,'America/Marigot'),(148,'America/Martinique'),(149,'America/Mazatlan'),(150,'America/Mendoza'),(151,'America/Menominee'),(152,'America/Merida'),(153,'America/Mexico_City'),(154,'America/Miquelon'),(155,'America/Moncton'),(156,'America/Monterrey'),(157,'America/Montevideo'),(158,'America/Montreal'),(159,'America/Montserrat'),(160,'America/Nassau'),(161,'America/New_York'),(162,'America/Nipigon'),(163,'America/Nome'),(164,'America/Noronha'),(165,'America/North_Dakota/Center'),(166,'America/North_Dakota/New_Salem'),(167,'America/Panama'),(168,'America/Pangnirtung'),(169,'America/Paramaribo'),(170,'America/Phoenix'),(171,'America/Port-au-Prince'),(172,'America/Port_of_Spain'),(173,'America/Porto_Acre'),(174,'America/Porto_Velho'),(175,'America/Puerto_Rico'),(176,'America/Rainy_River'),(177,'America/Rankin_Inlet'),(178,'America/Recife'),(179,'America/Regina'),(180,'America/Resolute'),(181,'America/Rio_Branco'),(182,'America/Rosario'),(183,'America/Santarem'),(184,'America/Santiago'),(185,'America/Santo_Domingo'),(186,'America/Sao_Paulo'),(187,'America/Scoresbysund'),(188,'America/Shiprock'),(189,'America/St_Barthelemy'),(190,'America/St_Johns'),(191,'America/St_Kitts'),(192,'America/St_Lucia'),(193,'America/St_Thomas'),(194,'America/St_Vincent'),(195,'America/Swift_Current'),(196,'America/Tegucigalpa'),(197,'America/Thule'),(198,'America/Thunder_Bay'),(199,'America/Tijuana'),(200,'America/Toronto'),(201,'America/Tortola'),(202,'America/Vancouver'),(203,'America/Virgin'),(204,'America/Whitehorse'),(205,'America/Winnipeg'),(206,'America/Yakutat'),(207,'America/Yellowknife'),(208,'Antarctica/Casey'),(209,'Antarctica/Davis'),(210,'Antarctica/DumontDUrville'),(211,'Antarctica/Mawson'),(212,'Antarctica/McMurdo'),(213,'Antarctica/Palmer'),(214,'Antarctica/Rothera'),(215,'Antarctica/South_Pole'),(216,'Antarctica/Syowa'),(217,'Antarctica/Vostok'),(218,'Arctic/Longyearbyen'),(219,'Asia/Aden'),(220,'Asia/Almaty'),(221,'Asia/Amman'),(222,'Asia/Anadyr'),(223,'Asia/Aqtau'),(224,'Asia/Aqtobe'),(225,'Asia/Ashgabat'),(226,'Asia/Ashkhabad'),(227,'Asia/Baghdad'),(228,'Asia/Bahrain'),(229,'Asia/Baku'),(230,'Asia/Bangkok'),(231,'Asia/Beirut'),(232,'Asia/Bishkek'),(233,'Asia/Brunei'),(234,'Asia/Calcutta'),(235,'Asia/Choibalsan'),(236,'Asia/Chongqing'),(237,'Asia/Chungking'),(238,'Asia/Colombo'),(239,'Asia/Dacca'),(240,'Asia/Damascus'),(241,'Asia/Dhaka'),(242,'Asia/Dili'),(243,'Asia/Dubai'),(244,'Asia/Dushanbe'),(245,'Asia/Gaza'),(246,'Asia/Harbin'),(247,'Asia/Ho_Chi_Minh'),(248,'Asia/Hong_Kong'),(249,'Asia/Hovd'),(250,'Asia/Irkutsk'),(251,'Asia/Istanbul'),(252,'Asia/Jakarta'),(253,'Asia/Jayapura'),(254,'Asia/Jerusalem'),(255,'Asia/Kabul'),(256,'Asia/Kamchatka'),(257,'Asia/Karachi'),(258,'Asia/Kashgar'),(259,'Asia/Kathmandu'),(260,'Asia/Katmandu'),(261,'Asia/Kolkata'),(262,'Asia/Krasnoyarsk'),(263,'Asia/Kuala_Lumpur'),(264,'Asia/Kuching'),(265,'Asia/Kuwait'),(266,'Asia/Macao'),(267,'Asia/Macau'),(268,'Asia/Magadan'),(269,'Asia/Makassar'),(270,'Asia/Manila'),(271,'Asia/Muscat'),(272,'Asia/Nicosia'),(273,'Asia/Novosibirsk'),(274,'Asia/Omsk'),(275,'Asia/Oral'),(276,'Asia/Phnom_Penh'),(277,'Asia/Pontianak'),(278,'Asia/Pyongyang'),(279,'Asia/Qatar'),(280,'Asia/Qyzylorda'),(281,'Asia/Rangoon'),(282,'Asia/Riyadh'),(283,'Asia/Saigon'),(284,'Asia/Sakhalin'),(285,'Asia/Samarkand'),(286,'Asia/Seoul'),(287,'Asia/Shanghai'),(288,'Asia/Singapore'),(289,'Asia/Taipei'),(290,'Asia/Tashkent'),(291,'Asia/Tbilisi'),(292,'Asia/Tehran'),(293,'Asia/Tel_Aviv'),(294,'Asia/Thimbu'),(295,'Asia/Thimphu'),(296,'Asia/Tokyo'),(297,'Asia/Ujung_Pandang'),(298,'Asia/Ulaanbaatar'),(299,'Asia/Ulan_Bator'),(300,'Asia/Urumqi'),(301,'Asia/Vientiane'),(302,'Asia/Vladivostok'),(303,'Asia/Yakutsk'),(304,'Asia/Yekaterinburg'),(305,'Asia/Yerevan'),(306,'Atlantic/Azores'),(307,'Atlantic/Bermuda'),(308,'Atlantic/Canary'),(309,'Atlantic/Cape_Verde'),(310,'Atlantic/Faeroe'),(311,'Atlantic/Faroe'),(312,'Atlantic/Jan_Mayen'),(313,'Atlantic/Madeira'),(314,'Atlantic/Reykjavik'),(315,'Atlantic/South_Georgia'),(316,'Atlantic/St_Helena'),(317,'Atlantic/Stanley'),(318,'Australia/ACT'),(319,'Australia/Adelaide'),(320,'Australia/Brisbane'),(321,'Australia/Broken_Hill'),(322,'Australia/Canberra'),(323,'Australia/Currie'),(324,'Australia/Darwin'),(325,'Australia/Eucla'),(326,'Australia/Hobart'),(327,'Australia/LHI'),(328,'Australia/Lindeman'),(329,'Australia/Lord_Howe'),(330,'Australia/Melbourne'),(331,'Australia/North'),(332,'Australia/NSW'),(333,'Australia/Perth'),(334,'Australia/Queensland'),(335,'Australia/South'),(336,'Australia/Sydney'),(337,'Australia/Tasmania'),(338,'Australia/Victoria'),(339,'Australia/West'),(340,'Australia/Yancowinna'),(341,'Europe/Amsterdam'),(342,'Europe/Andorra'),(343,'Europe/Athens'),(344,'Europe/Belfast'),(345,'Europe/Belgrade'),(346,'Europe/Berlin'),(347,'Europe/Bratislava'),(348,'Europe/Brussels'),(349,'Europe/Bucharest'),(350,'Europe/Budapest'),(351,'Europe/Chisinau'),(352,'Europe/Copenhagen'),(353,'Europe/Dublin'),(354,'Europe/Gibraltar'),(355,'Europe/Guernsey'),(356,'Europe/Helsinki'),(357,'Europe/Isle_of_Man'),(358,'Europe/Istanbul'),(359,'Europe/Jersey'),(360,'Europe/Kaliningrad'),(361,'Europe/Kiev'),(362,'Europe/Lisbon'),(363,'Europe/Ljubljana'),(364,'Europe/London'),(365,'Europe/Luxembourg'),(366,'Europe/Madrid'),(367,'Europe/Malta'),(368,'Europe/Mariehamn'),(369,'Europe/Minsk'),(370,'Europe/Monaco'),(371,'Europe/Moscow'),(372,'Europe/Nicosia'),(373,'Europe/Oslo'),(374,'Europe/Paris'),(375,'Europe/Podgorica'),(376,'Europe/Prague'),(377,'Europe/Riga'),(378,'Europe/Rome'),(379,'Europe/Samara'),(380,'Europe/San_Marino'),(381,'Europe/Sarajevo'),(382,'Europe/Simferopol'),(383,'Europe/Skopje'),(384,'Europe/Sofia'),(385,'Europe/Stockholm'),(386,'Europe/Tallinn'),(387,'Europe/Tirane'),(388,'Europe/Tiraspol'),(389,'Europe/Uzhgorod'),(390,'Europe/Vaduz'),(391,'Europe/Vatican'),(392,'Europe/Vienna'),(393,'Europe/Vilnius'),(394,'Europe/Volgograd'),(395,'Europe/Warsaw'),(396,'Europe/Zagreb'),(397,'Europe/Zaporozhye'),(398,'Europe/Zurich'),(399,'Indian/Antananarivo'),(400,'Indian/Chagos'),(401,'Indian/Christmas'),(402,'Indian/Cocos'),(403,'Indian/Comoro'),(404,'Indian/Kerguelen'),(405,'Indian/Mahe'),(406,'Indian/Maldives'),(407,'Indian/Mauritius'),(408,'Indian/Mayotte'),(409,'Indian/Reunion'),(410,'Pacific/Apia'),(411,'Pacific/Auckland'),(412,'Pacific/Chatham'),(413,'Pacific/Easter'),(414,'Pacific/Efate'),(415,'Pacific/Enderbury'),(416,'Pacific/Fakaofo'),(417,'Pacific/Fiji'),(418,'Pacific/Funafuti'),(419,'Pacific/Galapagos'),(420,'Pacific/Gambier'),(421,'Pacific/Guadalcanal'),(422,'Pacific/Guam'),(423,'Pacific/Honolulu'),(424,'Pacific/Johnston'),(425,'Pacific/Kiritimati'),(426,'Pacific/Kosrae'),(427,'Pacific/Kwajalein'),(428,'Pacific/Majuro'),(429,'Pacific/Marquesas'),(430,'Pacific/Midway'),(431,'Pacific/Nauru'),(432,'Pacific/Niue'),(433,'Pacific/Norfolk'),(434,'Pacific/Noumea'),(435,'Pacific/Pago_Pago'),(436,'Pacific/Palau'),(437,'Pacific/Pitcairn'),(438,'Pacific/Ponape'),(439,'Pacific/Port_Moresby'),(440,'Pacific/Rarotonga'),(441,'Pacific/Saipan'),(442,'Pacific/Samoa'),(443,'Pacific/Tahiti'),(444,'Pacific/Tarawa'),(445,'Pacific/Tongatapu'),(446,'Pacific/Truk'),(447,'Pacific/Wake'),(448,'Pacific/Wallis'),(449,'Pacific/Yap'),(450,'Brazil/Acre'),(451,'Brazil/DeNoronha'),(452,'Brazil/East'),(453,'Brazil/West'),(454,'Canada/Atlantic'),(455,'Canada/Central'),(456,'Canada/East-Saskatchewan'),(457,'Canada/Eastern'),(458,'Canada/Mountain'),(459,'Canada/Newfoundland'),(460,'Canada/Pacific'),(461,'Canada/Saskatchewan'),(462,'Canada/Yukon'),(463,'CET'),(464,'Chile/Continental'),(465,'Chile/EasterIsland'),(466,'CST6CDT'),(467,'Cuba'),(468,'EET'),(469,'Egypt'),(470,'Eire'),(471,'EST'),(472,'EST5EDT'),(473,'Etc/GMT'),(474,'Etc/GMT+0'),(475,'Etc/GMT+1'),(476,'Etc/GMT+10'),(477,'Etc/GMT+11'),(478,'Etc/GMT+12'),(479,'Etc/GMT+2'),(480,'Etc/GMT+3'),(481,'Etc/GMT+4'),(482,'Etc/GMT+5'),(483,'Etc/GMT+6'),(484,'Etc/GMT+7'),(485,'Etc/GMT+8'),(486,'Etc/GMT+9'),(487,'Etc/GMT-0'),(488,'Etc/GMT-1'),(489,'Etc/GMT-10'),(490,'Etc/GMT-11'),(491,'Etc/GMT-12'),(492,'Etc/GMT-13'),(493,'Etc/GMT-14'),(494,'Etc/GMT-2'),(495,'Etc/GMT-3'),(496,'Etc/GMT-4'),(497,'Etc/GMT-5'),(498,'Etc/GMT-6'),(499,'Etc/GMT-7'),(500,'Etc/GMT-8'),(501,'Etc/GMT-9'),(502,'Etc/GMT0'),(503,'Etc/Greenwich'),(504,'Etc/UCT'),(505,'Etc/Universal'),(506,'Etc/UTC'),(507,'Etc/Zulu'),(508,'Factory'),(509,'GB'),(510,'GB-Eire'),(511,'GMT'),(512,'GMT+0'),(513,'GMT-0'),(514,'GMT0'),(515,'Greenwich'),(516,'Hongkong'),(517,'HST'),(518,'Iceland'),(519,'Iran'),(520,'Israel'),(521,'Jamaica'),(522,'Japan'),(523,'Kwajalein'),(524,'Libya'),(525,'MET'),(526,'Mexico/BajaNorte'),(527,'Mexico/BajaSur'),(528,'Mexico/General'),(529,'MST'),(530,'MST7MDT'),(531,'Navajo'),(532,'NZ'),(533,'NZ-CHAT'),(534,'Poland'),(535,'Portugal'),(536,'PRC'),(537,'PST8PDT'),(538,'ROC'),(539,'ROK'),(540,'Singapore'),(541,'Turkey'),(542,'UCT'),(543,'Universal'),(544,'US/Alaska'),(545,'US/Aleutian'),(546,'US/Arizona'),(547,'US/Central'),(548,'US/East-Indiana'),(549,'US/Eastern'),(550,'US/Hawaii'),(551,'US/Indiana-Starke'),(552,'US/Michigan'),(553,'US/Mountain'),(554,'US/Pacific'),(555,'US/Pacific-New'),(556,'US/Samoa'),(557,'UTC'),(558,'W-SU'),(559,'WET'),(560,'Zulu');

--
-- Table structure for table `ps_translation`
--

CREATE TABLE `ps_translation` (
  `id_translation` int(11) NOT NULL AUTO_INCREMENT,
  `id_lang` int(11) NOT NULL,
  `key` text CHARACTER SET utf8 NOT NULL,
  `translation` text CHARACTER SET utf8 NOT NULL,
  `domain` varchar(80) CHARACTER SET utf8 NOT NULL,
  `theme` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id_translation`),
  KEY `IDX_ADEBEB36BA299860` (`id_lang`),
  KEY `key` (`domain`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ps_translation`
--

INSERT INTO `ps_translation` VALUES (1,4,'%copyright% %year% - Ecommerce software by %prestashop%','%copyright% %year% - Toys and Games SA','ShopThemeGlobal','PRS033'),(2,2,'%copyright% %year% - Ecommerce software by %prestashop%','%copyright% %year% - Toys and Games SA','ShopThemeGlobal','PRS033'),(3,3,'%copyright% %year% - Ecommerce software by %prestashop%','%copyright% %year% - Toys and Games SA','ShopThemeGlobal','PRS033'),(4,4,'Sign up to receive','Iscriviti e ricevi uno sconto del','ShopTemplatetrend','PRS033'),(5,4,'your first order','sul tuo primo ordine','ShopTemplatetrend','PRS033'),(6,4,'10& off*','10%','ShopTemplatetrend','PRS033');

--
-- Table structure for table `ps_warehouse`
--

CREATE TABLE `ps_warehouse` (
  `id_warehouse` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_currency` int(11) unsigned NOT NULL,
  `id_address` int(11) unsigned NOT NULL,
  `id_employee` int(11) unsigned NOT NULL,
  `reference` varchar(32) DEFAULT NULL,
  `name` varchar(45) NOT NULL,
  `management_type` enum('WA','FIFO','LIFO') NOT NULL DEFAULT 'WA',
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_warehouse`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_warehouse`
--


--
-- Table structure for table `ps_warehouse_carrier`
--

CREATE TABLE `ps_warehouse_carrier` (
  `id_carrier` int(11) unsigned NOT NULL,
  `id_warehouse` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_warehouse`,`id_carrier`),
  KEY `id_warehouse` (`id_warehouse`),
  KEY `id_carrier` (`id_carrier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_warehouse_carrier`
--


--
-- Table structure for table `ps_warehouse_product_location`
--

CREATE TABLE `ps_warehouse_product_location` (
  `id_warehouse_product_location` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_product` int(11) unsigned NOT NULL,
  `id_product_attribute` int(11) unsigned NOT NULL,
  `id_warehouse` int(11) unsigned NOT NULL,
  `location` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id_warehouse_product_location`),
  UNIQUE KEY `id_product` (`id_product`,`id_product_attribute`,`id_warehouse`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_warehouse_product_location`
--


--
-- Table structure for table `ps_warehouse_shop`
--

CREATE TABLE `ps_warehouse_shop` (
  `id_shop` int(11) unsigned NOT NULL,
  `id_warehouse` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_warehouse`,`id_shop`),
  KEY `id_warehouse` (`id_warehouse`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_warehouse_shop`
--


--
-- Table structure for table `ps_web_browser`
--

CREATE TABLE `ps_web_browser` (
  `id_web_browser` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id_web_browser`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_web_browser`
--

INSERT INTO `ps_web_browser` VALUES (1,'Safari'),(2,'Safari iPad'),(3,'Firefox'),(4,'Opera'),(5,'IE 6'),(6,'IE 7'),(7,'IE 8'),(8,'IE 9'),(9,'IE 10'),(10,'IE 11'),(11,'Chrome');

--
-- Table structure for table `ps_webservice_account`
--

CREATE TABLE `ps_webservice_account` (
  `id_webservice_account` int(11) NOT NULL AUTO_INCREMENT,
  `key` varchar(32) NOT NULL,
  `description` text,
  `class_name` varchar(50) NOT NULL DEFAULT 'WebserviceRequest',
  `is_module` tinyint(2) NOT NULL DEFAULT '0',
  `module_name` varchar(50) DEFAULT NULL,
  `active` tinyint(2) NOT NULL,
  PRIMARY KEY (`id_webservice_account`),
  KEY `key` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_webservice_account`
--


--
-- Table structure for table `ps_webservice_account_shop`
--

CREATE TABLE `ps_webservice_account_shop` (
  `id_webservice_account` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_webservice_account`,`id_shop`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_webservice_account_shop`
--


--
-- Table structure for table `ps_webservice_permission`
--

CREATE TABLE `ps_webservice_permission` (
  `id_webservice_permission` int(11) NOT NULL AUTO_INCREMENT,
  `resource` varchar(50) NOT NULL,
  `method` enum('GET','POST','PUT','DELETE','HEAD') NOT NULL,
  `id_webservice_account` int(11) NOT NULL,
  PRIMARY KEY (`id_webservice_permission`),
  UNIQUE KEY `resource_2` (`resource`,`method`,`id_webservice_account`),
  KEY `resource` (`resource`),
  KEY `method` (`method`),
  KEY `id_webservice_account` (`id_webservice_account`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_webservice_permission`
--


--
-- Table structure for table `ps_ws_wishlist`
--

CREATE TABLE `ps_ws_wishlist` (
  `id_wishlist` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_customer` int(10) unsigned NOT NULL,
  `token` varchar(64) NOT NULL,
  `name` varchar(64) NOT NULL,
  `counter` int(10) unsigned DEFAULT NULL,
  `id_shop` int(10) unsigned DEFAULT '1',
  `id_shop_group` int(10) unsigned DEFAULT '1',
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `default` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id_wishlist`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_ws_wishlist`
--

INSERT INTO `ps_ws_wishlist` VALUES (1,3,'CD82DECA11A70B31','My wishlist',NULL,3,3,'2018-06-05 17:03:07','2018-06-05 17:03:07',1);

--
-- Table structure for table `ps_ws_wishlist_email`
--

CREATE TABLE `ps_ws_wishlist_email` (
  `id_wishlist` int(10) unsigned NOT NULL,
  `email` varchar(128) NOT NULL,
  `date_add` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_ws_wishlist_email`
--


--
-- Table structure for table `ps_ws_wishlist_product`
--

CREATE TABLE `ps_ws_wishlist_product` (
  `id_wishlist_product` int(10) NOT NULL AUTO_INCREMENT,
  `id_wishlist` int(10) unsigned NOT NULL,
  `id_product` int(10) unsigned NOT NULL,
  `id_product_attribute` int(10) unsigned NOT NULL,
  `quantity` int(10) unsigned NOT NULL,
  `priority` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_wishlist_product`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_ws_wishlist_product`
--

INSERT INTO `ps_ws_wishlist_product` VALUES (1,1,77,0,1,1);

--
-- Table structure for table `ps_ws_wishlist_product_cart`
--

CREATE TABLE `ps_ws_wishlist_product_cart` (
  `id_wishlist_product` int(10) unsigned NOT NULL,
  `id_cart` int(10) unsigned NOT NULL,
  `quantity` int(10) unsigned NOT NULL,
  `date_add` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_ws_wishlist_product_cart`
--


--
-- Table structure for table `ps_zone`
--

CREATE TABLE `ps_zone` (
  `id_zone` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_zone`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_zone`
--

INSERT INTO `ps_zone` VALUES (1,'Europe',1),(2,'North America',1),(3,'Asia',1),(4,'Africa',1),(5,'Oceania',1),(6,'South America',1),(7,'Europe (non-EU)',1),(8,'Central America/Antilla',1);

--
-- Table structure for table `ps_zone_shop`
--

CREATE TABLE `ps_zone_shop` (
  `id_zone` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_zone`,`id_shop`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_zone_shop`
--

INSERT INTO `ps_zone_shop` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(1,3),(2,3),(3,3),(4,3),(5,3),(6,3),(7,3),(8,3),(1,4),(2,4),(3,4),(4,4),(5,4),(6,4),(7,4),(8,4),(1,5),(2,5),(3,5),(4,5),(5,5),(6,5),(7,5),(8,5),(1,6),(2,6),(3,6),(4,6),(5,6),(6,6),(7,6),(8,6),(1,7),(2,7),(3,7),(4,7),(5,7),(6,7),(7,7),(8,7),(1,8),(2,8),(3,8),(4,8),(5,8),(6,8),(7,8),(8,8),(1,9),(2,9),(3,9),(4,9),(5,9),(6,9),(7,9),(8,9),(1,10),(2,10),(3,10),(4,10),(5,10),(6,10),(7,10),(8,10),(1,11),(2,11),(3,11),(4,11),(5,11),(6,11),(7,11),(8,11),(1,12),(2,12),(3,12),(4,12),(5,12),(6,12),(7,12),(8,12),(1,13),(2,13),(3,13),(4,13),(5,13),(6,13),(7,13),(8,13);


