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

CREATE TABLE `ps_stock_mvt` (
  `id_stock_mvt` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_stock` int(11) unsigned NOT NULL,
  `id_order` int(11) unsigned DEFAULT NULL,
  `id_supply_order` int(11) unsigned DEFAULT NULL,
  `id_stock_mvt_reason` int(11) unsigned NOT NULL,
  `id_employee` int(11) unsigned NOT NULL,
  `employee_lastname` varchar(32) DEFAULT '',
  `employee_firstname` varchar(32) DEFAULT '',
  `physical_quantity` int(11) unsigned NOT NULL,
  `date_add` datetime NOT NULL,
  `sign` tinyint(1) 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) unsigned DEFAULT NULL,
  PRIMARY KEY (`id_stock_mvt`),
  KEY `id_stock` (`id_stock`),
  KEY `id_stock_mvt_reason` (`id_stock_mvt_reason`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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


--
-- 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=9 DEFAULT CHARSET=utf8;

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

INSERT INTO `ps_stock_mvt_reason` VALUES (1,1,'2016-02-15 10:48:01','2016-02-15 10:48:01',0),(2,-1,'2016-02-15 10:48:01','2016-02-15 10:48:01',0),(3,-1,'2016-02-15 10:48:01','2016-02-15 10:48:01',0),(4,-1,'2016-02-15 10:48:01','2016-02-15 10:48:01',0),(5,1,'2016-02-15 10:48:01','2016-02-15 10:48:01',0),(6,-1,'2016-02-15 10:48:01','2016-02-15 10:48:01',0),(7,1,'2016-02-15 10:48:01','2016-02-15 10:48:01',0),(8,1,'2016-02-15 10:48:01','2016-02-15 10:48:01',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,'Aumento'),(2,1,'Diminuzione'),(3,1,'Ordine cliente'),(4,1,'Adeguamento in seguito a un inventario delle scorte'),(5,1,'Adeguamento in seguito a un inventario delle scorte'),(6,1,'Trasferimento a un altro magazzino'),(7,1,'Trasferimento da un altro magazzino'),(8,1,'Ordine di fornitura');

--
-- 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,
  `name` varchar(128) NOT NULL,
  `address1` varchar(128) NOT NULL,
  `address2` varchar(128) DEFAULT NULL,
  `city` varchar(64) NOT NULL,
  `postcode` varchar(12) NOT NULL,
  `latitude` decimal(13,8) DEFAULT NULL,
  `longitude` decimal(13,8) DEFAULT NULL,
  `hours` varchar(254) DEFAULT NULL,
  `phone` varchar(16) DEFAULT NULL,
  `fax` varchar(16) DEFAULT NULL,
  `email` varchar(128) DEFAULT NULL,
  `note` text,
  `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=7 DEFAULT CHARSET=utf8;

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

INSERT INTO `ps_store` VALUES (6,10,210,'NewPeople','Via Vittorio Emanuele, 24','','Pellezzano','84080',40.71880490,14.76415760,'a:7:{i:0;s:0:\"\";i:1;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:6;s:0:\"\";}','089566944','089566944','info@desktopstore.it','',1,'2016-03-05 14:29:54','2016-03-05 14:29:54');

--
-- 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 (6,1);

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

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

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

INSERT INTO `ps_supplier` VALUES (1,'XXXXX','','2016-12-27 03:41:07','2016-12-27 03:41:07',0),(2,'ARKÈ S.R.L.','','2016-12-27 03:41:08','2016-12-27 03:41:08',0),(3,'ALEXIA S.R.L.','','2016-12-27 03:41:08','2016-12-27 03:41:08',0),(4,'BALDI - INGROSSO S.R.L.','','2016-12-27 03:41:08','2016-12-27 03:41:08',0),(5,'BYZANT ITALIA','byzant@byzantitalia.191.it','2016-12-27 03:41:08','2016-12-27 03:41:08',0),(6,'BARRA ROBERTO S.R.L.','info@robertobarra.com','2016-12-27 03:41:09','2016-12-27 03:41:09',0),(7,'DIFFUSIONE SAN PAOLO S.R.L.','','2016-12-27 03:41:09','2016-12-27 03:41:09',0),(8,'C.E.D. CENTRO EDITORIALE DEHONIANO S.P.A.','','2016-12-27 03:41:09','2016-12-27 03:41:09',0),(9,'GRAFICHE CAPOZZOLI','info@grafichecapozzoli.com','2016-12-27 03:41:09','2016-12-27 03:41:09',0),(10,'CASA DEL LIBRO S.A.S. DI MICHELE MANCINI','casadellibromancini@hotmail.it','2016-12-27 03:41:09','2016-12-27 03:41:09',0),(11,'CRISTO RE ARTE SACRA SRL','vassallo.gennaro@libero.it','2016-12-27 03:41:10','2017-09-27 13:03:34',0),(12,'CALANDRINI S.R.L.','info@calandrini.it','2016-12-27 03:41:10','2018-01-09 11:33:15',0),(13,'CARTAPIETRA S.R.L.','','2016-12-27 03:41:10','2016-12-27 03:41:10',0),(14,'CRISMA S.R.L.','info@piccinini.com','2016-12-27 03:41:10','2016-12-27 03:41:10',0),(15,'CROCE DEL SUD S.R.L. - AMEN','info@crocesud.com','2016-12-27 03:41:10','2016-12-27 03:41:10',0),(16,'CIPOLLETTI CLAUDIO S.R.L.','info@claudiocipolletti.it','2016-12-27 03:41:11','2016-12-27 03:41:11',0),(17,'CENTRO CULTURALE CATTOLICO','ccc@velar.it','2016-12-27 03:41:11','2016-12-27 03:41:11',0),(18,'DEHONIANA LIBRI S.P.A.','','2016-12-27 03:41:11','2016-12-27 03:41:11',0),(19,'DUEBI DI SAVARESE MARIAROSARIA','duebireligiosi@libero.it','2016-12-27 03:41:11','2016-12-27 03:41:11',0),(20,'DESTA INDUSTRIE S.R.L.','','2016-12-27 03:41:11','2016-12-27 03:41:11',0),(21,'DORATURA MANERBIESE','','2016-12-27 03:41:11','2016-12-27 03:41:11',0),(22,'DOMUS','info@ostificiodomus.it','2016-12-27 03:41:12','2016-12-27 03:41:12',0),(23,'EGIM S.R.L.','egim@egim.it','2016-12-27 03:41:12','2016-12-27 03:41:12',0),(24,'ERREGI S.R.L.','erregisrl@alice.it','2016-12-27 03:41:12','2016-12-27 03:41:12',0),(25,'ECUMENICUS','','2016-12-27 03:41:12','2016-12-27 03:41:12',0),(26,'F.LLI BONELLA S.R.L.','info@fratellibonella.it','2016-12-27 03:41:12','2016-12-27 03:41:12',0),(27,'FIORETTI ARGENTI','fiorettiargenti@libero.it','2016-12-27 03:41:13','2016-12-27 03:41:13',0),(28,'FARS S.R.L.','fars@fars.it','2016-12-27 03:41:13','2016-12-27 03:41:13',0),(29,'FUSCO ARGENTI S.A.S.','info@armadanueva.it','2016-12-27 03:41:13','2016-12-27 03:41:13',0),(30,'FERRARI & ARRIGHETTI SNC','info@ferrari-arrighetti.com','2016-12-27 03:41:13','2016-12-27 03:41:13',0),(31,'GRAZIANI S.R.L.','info@graziani.net','2016-12-27 03:41:13','2016-12-27 03:41:13',0),(32,'GESTORE DEI SERVIZI ENERGETICI S.P.A.','','2016-12-27 03:41:13','2016-12-27 03:41:13',0),(33,'GIOVINARTE SRL','info@giovinarte.com','2016-12-27 03:41:13','2016-12-27 03:41:13',0),(34,'LABORATORIO ORAFO DI AURICCHIO VINCENZO','','2016-12-27 03:41:14','2016-12-27 03:41:14',0),(35,'CRIVARO S.R.L. - FABBRICA ART. RELIGIOSI','www.crivaro.it','2016-12-27 03:41:14','2016-12-27 03:41:14',0),(36,'LE CERE  - CERERIA FINASSI LEONE','info@cereriafinassi.com','2016-12-27 03:41:14','2016-12-27 03:41:14',0),(37,'CAMARDA NEON DI CAMARDA GIUSEPPE','','2016-12-27 03:41:16','2016-12-27 03:41:16',0),(38,'EDITRICE SHALOM SRL','','2016-12-27 03:41:17','2016-12-27 03:41:17',0),(39,'TIESSE S.R.L.','','2016-12-27 03:41:17','2016-12-27 03:41:17',0),(40,'EDIZIONI ART S.R.L.','','2016-12-27 03:41:17','2016-12-27 03:41:17',0),(41,'ITALTIME ROMA S.R.L.','italtimeroma@virgilio.it','2016-12-27 03:41:18','2016-12-27 03:41:18',0),(42,'LEGATORIA ETRUSCA S.R.L.','info@legatoriaetrusca.it','2016-12-27 03:41:18','2016-12-27 03:41:18',0),(43,'L.A.L. S.R.L.','','2016-12-27 03:41:18','2016-12-27 03:41:18',0),(44,'L\'AGORÀ ARTE SACRA S.R.L.','','2016-12-27 03:41:18','2016-12-27 03:41:18',0),(45,'LEADER S.R.L.','leader@leaderargenti.com','2016-12-27 03:41:18','2016-12-27 03:41:18',0),(46,'MESSAGGERO DISTRIBUZIONE S.R.L.','www.messaggerodistribuzione.it','2016-12-27 03:41:19','2016-12-27 03:41:19',0),(47,'MESCAT S.R.L.','','2016-12-27 03:41:19','2016-12-27 03:41:19',0),(48,'MARTINEZ S.R.L.','info@martinez.it','2016-12-27 03:41:19','2016-12-27 03:41:19',0),(49,'MONASTERO SUORE CISTERCENSI','','2016-12-27 03:41:19','2016-12-27 03:41:19',0),(50,'QUADRI E QUADRI DI A. CANDELA','info@quadriequadri.com','2016-12-27 03:41:19','2016-12-27 03:41:19',0),(51,'OSTIFICIO MORREALE','info@ostificiomorreale.com','2016-12-27 03:41:20','2017-04-28 17:00:15',0),(52,'ARTE DEL SOUVENIR DI MERENDONI ANTONIO','','2016-12-27 03:41:20','2016-12-27 03:41:20',0),(53,'ARGO STUDIO ADV S.R.L.','info@argostudioadv.it','2016-12-27 03:41:20','2017-11-24 16:16:31',0),(54,'PROART SNC DI AVERSANO & C.','ordini@proartitalia.com','2016-12-27 03:41:20','2016-12-27 03:41:20',0),(55,'EDITORIALE JACA BOOK','','2016-12-27 03:41:20','2016-12-27 03:41:20',0),(56,'AMC S.R.L. - DOLFI','info@dolfi.com','2016-12-27 03:41:21','2016-12-27 03:41:21',0),(57,'UGO MURSIA EDITORE S.R.L.','','2016-12-27 03:41:21','2016-12-27 03:41:21',0),(58,'DELL\'ARTE SRL','','2016-12-27 03:41:21','2016-12-27 03:41:21',0),(59,'ITACA SRL','itaca@itacalibri.it','2016-12-27 03:41:21','2016-12-27 03:41:21',0),(60,'CAART S.R.L.','info@caart.it','2016-12-27 03:41:21','2016-12-27 03:41:21',0),(61,'EDIZIONI CANTAGALLI S.R.L.','cantagalli@edizionicantagalli.com','2016-12-27 03:41:21','2016-12-27 03:41:21',0),(62,'OFFICE DEPOT S,R.L.','','2016-12-27 03:41:22','2016-12-27 03:41:22',0),(63,'PERIODICI SAN PAOLO S.R.L.','','2016-12-27 03:41:22','2018-06-13 18:11:12',0),(64,'PICAL ARTE','picalartecreazionisacre@gmail.com','2016-12-27 03:41:22','2016-12-27 03:41:22',0),(65,'PROLIBER S.R.L.','amministrazione@proliber.it','2016-12-27 03:41:22','2017-10-27 13:21:50',0),(66,'POMILIA CALAMIA','info@pomiliacalamiavini.it','2016-12-27 03:41:22','2016-12-27 03:41:22',0),(67,'RISI DI RISI WALTER & C S.N.C.','info@risibox.it','2016-12-27 03:41:22','2016-12-27 03:41:22',0),(68,'ROSSI & ARCANDI S.R.L.','info@rossiarcandi.it','2016-12-27 03:41:23','2016-12-27 03:41:23',0),(69,'SUORE CROCIFISSE ADORATRICI DELL\'EUCARISTIA','','2016-12-27 03:41:23','2016-12-27 03:41:23',0),(70,'SPANÒ ANTONINO','antoninospano@tiscali.it','2016-12-27 03:41:23','2016-12-27 03:41:23',0),(71,'NATALE SALVARDI SRL','info@salvardi.com','2016-12-27 03:41:23','2017-04-19 16:29:58',0),(72,'SAMBUCO MARIO & C. SNC','sambuco@sambuco.it','2016-12-27 03:41:24','2016-12-27 03:41:24',0),(73,'CERERIA TRIBOLDI SIMP','info@simp-trading.com','2016-12-27 03:41:24','2016-12-27 03:41:24',0),(74,'SHAN S.R.L.','','2016-12-27 03:41:24','2016-12-27 03:41:24',0),(75,'TIPOLITOGRAFIA SCALA S.N.C.','info@artigrafichescala.it','2016-12-27 03:41:24','2016-12-27 03:41:24',0),(76,'VINIMAR','info@vinimar.it','2016-12-27 03:41:24','2016-12-27 03:41:24',0),(77,'JUSTA','info@justa.com.pl','2016-12-27 03:41:24','2016-12-27 03:41:24',0),(78,'fornitore',NULL,'2017-01-19 17:24:46','2017-01-19 17:24:46',0),(79,'LIBRERIA EDITRICE VATICANA','','2017-01-23 12:07:51','2017-01-23 12:15:15',0),(80,'VINCI VINI srl','vincivini@libero.it','2017-01-25 10:59:44','2017-01-25 11:02:34',0),(81,'LIBRERIA EDITRICE REDENZIONE','casaeditrice@lereditrice.it','2017-02-13 08:49:25','2017-02-13 08:53:38',0),(82,'BEL SANTI di G. De Carolis','info@belsanti.it','2017-02-24 19:49:21','2017-02-24 19:51:38',0),(83,'PIENNE ARGENTI S.A.S.','pienneargenti@alice.it','2017-02-25 08:47:37','2017-02-25 09:03:50',0),(84,'PIENNE ARGENTI S.A.S.','pienneargenti@alice.it','2017-02-25 09:07:04','2017-02-25 09:11:55',0),(85,'F.lli BRANCACCIO s.p.a.','','2017-03-22 18:26:34','2017-03-22 18:33:23',0),(86,'SANDNER','info@sandner-gmbh.de','2017-04-05 14:52:50','2017-04-05 14:59:05',0),(87,'',NULL,'2017-04-10 15:42:40','2017-05-23 19:13:32',0),(88,'',NULL,'2017-04-10 15:42:51','2017-05-23 19:13:30',0),(89,'AR.PA.S. di OPERTI ROBERTO & C. S.N.C.','info@arpasparamenti.it','2017-04-12 18:51:22','2017-04-12 18:54:34',0),(90,'NUOVA CEV - IL CRISTALLO','nuovacev@nuovacev.it','2017-04-26 08:42:28','2017-04-26 08:45:27',0),(91,'A.S.A. LINEA S.R.L.','info@asalinea.com','2017-05-03 19:27:29','2017-05-03 19:29:59',0),(92,'\"WRZOS\" ZDOBIENIE SZKLA I KRYSZTALOW','','2017-05-09 18:53:07','2017-05-09 18:58:51',0),(93,'TIPOLITOGRAFIA QUATRINI ARCHIMEDE & FIGLI snc','info@quatrini.it','2017-06-01 19:19:05','2017-06-01 19:21:39',0),(94,'PIETROBON BRUNO arredi sacri','pietrobon@pietrobon.it','2017-06-07 11:42:10','2017-06-07 11:46:09',0),(95,'ALESS Snc DI PETRALI','info@aless.it','2017-06-07 11:46:34','2017-09-08 11:46:40',0),(96,'ASTEGIANO EDITORE DI ASTEGIANO ELISA','info@astegianoeditore.it','2017-10-20 19:07:41','2017-10-20 19:09:55',0),(97,'LIPA srl','','2017-10-27 11:16:45','2017-10-27 11:18:00',0),(98,'PEMA s.r.l.','info@pema.it','2017-11-10 19:48:01','2017-11-10 19:50:54',0),(99,'SANTUARIO DELLA B. M. VERGINE DI VALLE DI POMPEI','ragioneria@santuariodipompei.it','2017-11-17 14:44:58','2017-11-17 14:47:26',0),(100,'FEDE & CULTURA soc. coop.','edizioni@fedecultura.com','2017-11-17 18:17:53','2017-11-17 18:20:06',0),(101,'ECCLESIA - TANGARI S.R.L.','info@ecclesiamadeinitaly.it','2017-11-24 17:02:07','2017-11-24 17:08:49',0),(102,'LE STELLE IMPORT SRL','','2017-12-02 09:19:01','2017-12-02 09:23:10',0),(103,'CASA EDITRICE LEONARDO DA VINCI','','2017-12-12 09:11:00','2017-12-12 09:12:58',0),(104,'ARTE SPECIALE D\'AMBROSIO di D\'Aambrosio Daniele','','2017-12-22 16:18:53','2017-12-22 16:23:04',0),(105,'CRISTIANO LIBRI SRL','info@cristianolibri.it','2018-01-04 18:15:46','2018-01-04 18:18:35',0),(106,'CHIRICO di FERNANDO MARIA CHIRICO','info@chiricolibri.it','2018-01-19 15:47:16','2018-01-19 15:49:16',0),(107,'BYBLOS GROUP DISTRIBUZIONE s.r.l.','','2018-01-22 12:35:38','2018-01-22 12:38:06',0),(108,'AMATO ANTONINO','amatoantonino@tin.it','2018-02-07 09:01:05','2018-02-07 09:03:48',0),(109,'MESSAGGERIE LIBRI spa','','2018-02-07 11:37:15','2018-02-07 11:39:52',0),(110,'FERDINANDO PERATHONER di Bruno','info@ferdinando-perathoner.com','2018-02-23 17:48:06','2018-02-23 17:50:38',0),(111,'LIBRERIA COLETTI srl','info@libreriacoletti.it','2018-03-26 12:40:20','2018-03-26 12:42:03',0),(112,'LINDAU SRL','lindau@lindau.it','2018-04-06 09:32:55','2018-04-06 09:37:50',0),(113,'EFFE-ERRE di Parodi Riccardo & C. s.n.c.','filigrana@effe-erre.com','2018-05-07 16:04:04','2018-05-07 16:06:47',0),(114,'MONDADORI LIBRI spa','','2018-05-14 16:52:24','2018-05-16 12:40:23',0),(115,'VALSESE TIPOGRAFIA Srl','amministratorevalsele@netlab.it','2018-05-18 11:01:28','2018-05-18 11:04:41',0),(116,'ARTEPLEX DI PANTANO VINCENZO','arteplex@libero.it','2018-05-22 15:03:24','2018-05-22 15:06:01',0),(117,'RIGIONE STATUE SACRE srl','info@rigionestatue.it','2018-06-04 19:25:04','2018-06-04 19:26:56',0),(118,'PANAROTTO CONFEZIONI ECCLESIASTICHE','info@panarotto.net','2018-07-20 16:23:34','2018-07-20 16:25:18',0);

--
-- 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,'',NULL,NULL,NULL),(2,1,'CENTRO ORAFO \"IL TARÍ\" MOD. 55 ZONA IND.LE A.S.I.',NULL,NULL,NULL),(3,1,'',NULL,NULL,NULL),(4,1,'',NULL,NULL,NULL),(5,1,'',NULL,NULL,NULL),(6,1,'',NULL,NULL,NULL),(7,1,'',NULL,NULL,NULL),(8,1,'',NULL,NULL,NULL),(9,1,'',NULL,NULL,NULL),(10,1,'',NULL,NULL,NULL),(11,1,'','',NULL,''),(12,1,'','',NULL,''),(13,1,'',NULL,NULL,NULL),(14,1,'MATERIALE: PIETRA',NULL,NULL,NULL),(15,1,'',NULL,NULL,NULL),(16,1,'',NULL,NULL,NULL),(17,1,'',NULL,NULL,NULL),(18,1,'',NULL,NULL,NULL),(19,1,'',NULL,NULL,NULL),(20,1,'',NULL,NULL,NULL),(21,1,'',NULL,NULL,NULL),(22,1,'',NULL,NULL,NULL),(23,1,'',NULL,NULL,NULL),(24,1,'',NULL,NULL,NULL),(25,1,'',NULL,NULL,NULL),(26,1,'',NULL,NULL,NULL),(27,1,'',NULL,NULL,NULL),(28,1,'',NULL,NULL,NULL),(29,1,' DI FUSCO ANTONELLA E C.',NULL,NULL,NULL),(30,1,'',NULL,NULL,NULL),(31,1,'',NULL,NULL,NULL),(32,1,'',NULL,NULL,NULL),(33,1,'',NULL,NULL,NULL),(34,1,'',NULL,NULL,NULL),(35,1,'',NULL,NULL,NULL),(36,1,'',NULL,NULL,NULL),(37,1,'',NULL,NULL,NULL),(38,1,'',NULL,NULL,NULL),(39,1,'',NULL,NULL,NULL),(40,1,'',NULL,NULL,NULL),(41,1,'',NULL,NULL,NULL),(42,1,'',NULL,NULL,NULL),(43,1,'',NULL,NULL,NULL),(44,1,'',NULL,NULL,NULL),(45,1,'',NULL,NULL,NULL),(46,1,'MESSAGGERO DISTRIBUZIONE S.R.L.',NULL,NULL,NULL),(47,1,'',NULL,NULL,NULL),(48,1,'',NULL,NULL,NULL),(49,1,'',NULL,NULL,NULL),(50,1,'',NULL,NULL,NULL),(51,1,'','',NULL,''),(52,1,'',NULL,NULL,NULL),(53,1,'','',NULL,''),(54,1,'',NULL,NULL,NULL),(55,1,'',NULL,NULL,NULL),(56,1,'',NULL,NULL,NULL),(57,1,'',NULL,NULL,NULL),(58,1,'',NULL,NULL,NULL),(59,1,'',NULL,NULL,NULL),(60,1,'',NULL,NULL,NULL),(61,1,'',NULL,NULL,NULL),(62,1,'',NULL,NULL,NULL),(63,1,'','',NULL,''),(64,1,'',NULL,NULL,NULL),(65,1,'','',NULL,''),(66,1,'',NULL,NULL,NULL),(67,1,'',NULL,NULL,NULL),(68,1,'',NULL,NULL,NULL),(69,1,'',NULL,NULL,NULL),(70,1,'',NULL,NULL,NULL),(71,1,'','',NULL,''),(72,1,'SCONTO 3% SU BONIFICO ANTICIPATO',NULL,NULL,NULL),(73,1,'',NULL,NULL,NULL),(74,1,'',NULL,NULL,NULL),(75,1,'',NULL,NULL,NULL),(76,1,'',NULL,NULL,NULL),(77,1,'',NULL,NULL,NULL),(78,1,NULL,NULL,NULL,NULL),(79,1,'','',NULL,''),(80,1,'CASA VINICOLA','',NULL,''),(81,1,'SEDE LEGALE: P.ZZA P. ARTURO D\'ONOFRIO, 26 - 80030 VISCIANO NA','',NULL,''),(82,1,'','',NULL,''),(83,1,'','',NULL,''),(84,1,'','',NULL,''),(85,1,'','',NULL,''),(86,1,'','',NULL,''),(87,1,NULL,NULL,NULL,NULL),(88,1,NULL,NULL,NULL,NULL),(89,1,'','',NULL,''),(90,1,'','',NULL,''),(91,1,'','',NULL,''),(92,1,'DI MAREK WRZOS       NAZ. POLONIA','',NULL,''),(93,1,'','',NULL,''),(94,1,'','',NULL,''),(95,1,'MINIMO ORD. 13/14 m','',NULL,''),(96,1,'','',NULL,''),(97,1,'','',NULL,''),(98,1,'','',NULL,''),(99,1,'','',NULL,''),(100,1,'SEDE OPERATIVA: VIA MARCONI, 58 C - 60 A / 37122 VERONA','',NULL,''),(101,1,'SEDE MAGAZZINO - E AMMINISTRAZIONE : VIA SAN MAGNO KM 0,400 Z.I. - CORATO - 70033 -  BARI - 0803588043','',NULL,''),(102,1,'UFFICIO E NEGOZIO: \r\nVIA PONZA, 7\r\n80026 CASORIA NA\r\n','',NULL,''),(103,1,'','',NULL,''),(104,1,'','',NULL,''),(105,1,'','',NULL,''),(106,1,'','',NULL,''),(107,1,'SEDE OPERATIVA: VIA ERCOLE RAMARINI, 31/33 - 00015 MONTEROTONDO  RM','',NULL,''),(108,1,'DITTA VENDITA CALICI ARGENTO E SIMILI','',NULL,''),(109,1,'','',NULL,''),(110,1,'ARS SACRA SCULTORI','',NULL,''),(111,1,'','',NULL,''),(112,1,'','',NULL,''),(113,1,'','',NULL,''),(114,1,'','',NULL,''),(115,1,'','',NULL,''),(116,1,'','',NULL,''),(117,1,'','',NULL,''),(118,1,'','',NULL,'');

--
-- 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),(2,1),(3,1),(4,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),(27,1),(28,1),(29,1),(30,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),(53,1),(54,1),(55,1),(56,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),(79,1),(80,1),(81,1),(82,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),(105,1),(106,1),(107,1),(108,1),(109,1),(110,1),(111,1),(112,1),(113,1),(114,1),(115,1),(116,1),(117,1),(118,1);

--
-- 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,
  `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 - Creazione in corso'),(2,1,'2 - Ordine convalidato'),(3,1,'3 - In attesa di ricevimento'),(4,1,'4 - Ordine ricevuto in parte'),(5,1,'5 - Ordine ricevuto completamente'),(6,1,'6 - Ordine annullato');

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

CREATE TABLE `ps_tab` (
  `id_tab` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_parent` int(11) NOT NULL,
  `class_name` varchar(64) NOT NULL,
  `module` varchar(64) DEFAULT NULL,
  `position` int(10) unsigned NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `hide_host_mode` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_tab`),
  KEY `class_name` (`class_name`),
  KEY `id_parent` (`id_parent`)
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8;

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

INSERT INTO `ps_tab` VALUES (1,0,'AdminDashboard',NULL,0,1,0),(2,-1,'AdminCms',NULL,0,1,0),(3,-1,'AdminCmsCategories',NULL,1,1,0),(4,-1,'AdminAttributeGenerator',NULL,2,1,0),(5,-1,'AdminSearch',NULL,3,1,0),(6,-1,'AdminLogin',NULL,4,1,0),(7,-1,'AdminShop',NULL,5,1,0),(8,-1,'AdminShopUrl',NULL,6,1,0),(9,0,'AdminCatalog',NULL,1,1,0),(10,0,'AdminParentOrders',NULL,2,1,0),(11,0,'AdminParentCustomer',NULL,3,1,0),(12,0,'AdminPriceRule',NULL,4,1,0),(13,0,'AdminParentModules',NULL,5,1,0),(14,0,'AdminParentShipping',NULL,6,1,0),(15,0,'AdminParentLocalization',NULL,7,1,0),(16,0,'AdminParentPreferences',NULL,8,1,0),(17,0,'AdminTools',NULL,9,1,0),(18,0,'AdminAdmin',NULL,10,1,0),(19,0,'AdminParentStats',NULL,11,1,0),(20,0,'AdminStock',NULL,12,1,0),(21,9,'AdminProducts',NULL,0,1,0),(22,9,'AdminCategories',NULL,1,1,0),(23,9,'AdminTracking',NULL,2,1,0),(24,9,'AdminAttributesGroups',NULL,3,1,0),(25,9,'AdminFeatures',NULL,4,1,0),(26,9,'AdminManufacturers',NULL,5,1,0),(27,9,'AdminSuppliers',NULL,6,1,0),(28,9,'AdminTags',NULL,7,1,0),(29,9,'AdminAttachments',NULL,8,1,0),(30,10,'AdminOrders',NULL,0,1,0),(31,10,'AdminInvoices',NULL,1,1,0),(32,10,'AdminReturn',NULL,2,1,0),(33,10,'AdminDeliverySlip',NULL,3,1,0),(34,10,'AdminSlip',NULL,4,1,0),(35,10,'AdminStatuses',NULL,5,1,0),(36,10,'AdminOrderMessage',NULL,6,1,0),(37,11,'AdminCustomers',NULL,0,1,0),(38,11,'AdminAddresses',NULL,1,1,0),(39,11,'AdminGroups',NULL,2,1,0),(40,11,'AdminCarts',NULL,3,1,0),(41,11,'AdminCustomerThreads',NULL,4,1,0),(42,11,'AdminContacts',NULL,5,1,0),(43,11,'AdminGenders',NULL,6,1,0),(44,11,'AdminOutstanding',NULL,7,0,0),(45,12,'AdminCartRules',NULL,0,1,0),(46,12,'AdminSpecificPriceRule',NULL,1,1,0),(47,12,'AdminMarketing',NULL,2,1,0),(48,14,'AdminCarriers',NULL,0,1,0),(49,14,'AdminShipping',NULL,1,1,0),(50,14,'AdminCarrierWizard',NULL,2,1,0),(51,15,'AdminLocalization',NULL,0,1,0),(52,15,'AdminLanguages',NULL,1,1,0),(53,15,'AdminZones',NULL,2,1,0),(54,15,'AdminCountries',NULL,3,1,0),(55,15,'AdminStates',NULL,4,1,0),(56,15,'AdminCurrencies',NULL,5,1,0),(57,15,'AdminTaxes',NULL,6,1,0),(58,15,'AdminTaxRulesGroup',NULL,7,1,0),(59,15,'AdminTranslations',NULL,8,1,0),(60,13,'AdminModules',NULL,0,1,0),(61,13,'AdminAddonsCatalog',NULL,1,1,0),(62,13,'AdminModulesPositions',NULL,2,1,0),(63,13,'AdminPayment',NULL,3,1,0),(64,16,'AdminPreferences',NULL,0,1,0),(65,16,'AdminOrderPreferences',NULL,1,1,0),(66,16,'AdminPPreferences',NULL,2,1,0),(67,16,'AdminCustomerPreferences',NULL,3,1,0),(68,16,'AdminThemes',NULL,4,1,0),(69,16,'AdminMeta',NULL,5,1,0),(70,16,'AdminCmsContent',NULL,6,1,0),(71,16,'AdminImages',NULL,7,1,0),(72,16,'AdminStores',NULL,8,1,0),(73,16,'AdminSearchConf',NULL,9,1,0),(74,16,'AdminMaintenance',NULL,10,1,0),(75,16,'AdminGeolocation',NULL,11,1,0),(76,17,'AdminInformation',NULL,0,1,0),(77,17,'AdminPerformance',NULL,1,1,0),(78,17,'AdminEmails',NULL,2,1,0),(79,17,'AdminShopGroup',NULL,3,0,0),(80,17,'AdminImport',NULL,4,1,0),(81,17,'AdminBackup',NULL,5,1,0),(82,17,'AdminRequestSql',NULL,6,1,0),(83,17,'AdminLogs',NULL,7,1,0),(84,17,'AdminWebservice',NULL,8,1,0),(85,18,'AdminAdminPreferences',NULL,0,1,0),(86,18,'AdminQuickAccesses',NULL,1,1,0),(87,18,'AdminEmployees',NULL,2,1,0),(88,18,'AdminProfiles',NULL,3,1,0),(89,18,'AdminAccess',NULL,4,1,0),(90,18,'AdminTabs',NULL,5,1,0),(91,19,'AdminStats',NULL,0,1,0),(92,19,'AdminSearchEngines',NULL,1,1,0),(93,19,'AdminReferrers',NULL,2,1,0),(94,20,'AdminWarehouses',NULL,0,1,0),(95,20,'AdminStockManagement',NULL,1,1,0),(96,20,'AdminStockMvt',NULL,2,1,0),(97,20,'AdminStockInstantState',NULL,3,1,0),(98,20,'AdminStockCover',NULL,4,1,0),(99,20,'AdminSupplyOrders',NULL,5,1,0),(100,20,'AdminStockConfiguration',NULL,6,1,0),(101,-1,'AdminBlockCategories','blockcategories',7,1,0),(102,-1,'AdminDashgoals','dashgoals',8,1,0),(103,-1,'AdminThemeConfigurator','themeconfigurator',9,1,0),(104,18,'AdminGamification','gamification',6,1,0),(105,-1,'AdminCronJobs','cronjobs',10,1,0),(107,-1,'AdminGanalyticsAjax','ganalytics',11,0,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,9),(0,50),(0,91),(0,132),(0,173),(0,214),(0,255),(0,296),(0,337),(0,378),(0,419),(0,458),(0,495),(0,532),(0,569),(0,606),(0,643),(0,680),(0,717),(0,755),(0,793),(0,831),(0,870),(0,909),(0,948),(0,987),(0,1026),(0,1068),(0,1110),(0,1152),(0,1194),(0,1236),(0,1278),(0,1320),(0,1362),(0,1404),(0,1447),(0,1493),(0,1539),(0,1585),(0,1631),(0,1707),(0,1723),(0,1769),(0,1815),(0,1861),(0,1906),(0,1951),(0,1996),(0,2040),(0,2084),(0,2128),(0,2172),(0,2216),(0,2260),(0,2304),(0,2348),(0,2392),(0,2436),(0,2480),(0,2524),(0,2568),(0,2613),(0,2658),(0,2703),(0,2748),(0,2794),(0,2840),(0,2886),(0,2932),(0,2978),(0,3024),(0,3070),(0,3116),(0,3162),(0,3203),(0,3244),(0,3285),(0,3326),(0,3367),(0,3408),(0,3449),(0,3490),(0,3531),(0,3572),(0,3613),(0,3654),(0,3695),(0,3736),(0,3780),(0,3824),(1,1),(1,4),(1,10),(1,12),(1,13),(1,14),(1,15),(1,17),(1,20),(1,23),(1,24),(1,25),(1,26),(1,27),(1,29),(1,30),(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,45),(1,51),(1,53),(1,54),(1,55),(1,56),(1,58),(1,61),(1,64),(1,65),(1,66),(1,67),(1,68),(1,70),(1,71),(1,72),(1,73),(1,74),(1,75),(1,76),(1,77),(1,78),(1,79),(1,80),(1,81),(1,82),(1,83),(1,86),(1,92),(1,94),(1,95),(1,96),(1,97),(1,99),(1,102),(1,105),(1,106),(1,107),(1,108),(1,109),(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,127),(1,133),(1,135),(1,136),(1,137),(1,138),(1,140),(1,143),(1,146),(1,147),(1,148),(1,149),(1,150),(1,152),(1,153),(1,154),(1,155),(1,156),(1,157),(1,158),(1,159),(1,160),(1,161),(1,162),(1,163),(1,164),(1,165),(1,168),(1,174),(1,176),(1,177),(1,178),(1,179),(1,181),(1,184),(1,187),(1,188),(1,189),(1,190),(1,191),(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,209),(1,215),(1,217),(1,218),(1,219),(1,220),(1,222),(1,225),(1,228),(1,229),(1,230),(1,231),(1,232),(1,234),(1,235),(1,236),(1,237),(1,238),(1,239),(1,240),(1,241),(1,242),(1,243),(1,244),(1,245),(1,246),(1,247),(1,250),(1,256),(1,258),(1,259),(1,260),(1,261),(1,263),(1,266),(1,269),(1,270),(1,271),(1,272),(1,273),(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,291),(1,297),(1,299),(1,300),(1,301),(1,302),(1,304),(1,307),(1,310),(1,311),(1,312),(1,313),(1,314),(1,316),(1,317),(1,318),(1,319),(1,320),(1,321),(1,322),(1,323),(1,324),(1,325),(1,326),(1,327),(1,328),(1,329),(1,332),(1,338),(1,340),(1,341),(1,342),(1,343),(1,345),(1,348),(1,351),(1,352),(1,353),(1,354),(1,355),(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,373),(1,379),(1,381),(1,382),(1,383),(1,384),(1,386),(1,389),(1,392),(1,393),(1,394),(1,395),(1,396),(1,398),(1,399),(1,400),(1,401),(1,402),(1,403),(1,404),(1,405),(1,406),(1,407),(1,408),(1,409),(1,410),(1,411),(1,414),(1,420),(1,422),(1,423),(1,424),(1,425),(1,427),(1,430),(1,433),(1,434),(1,435),(1,436),(1,437),(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,454),(1,459),(1,461),(1,462),(1,463),(1,464),(1,466),(1,471),(1,472),(1,473),(1,474),(1,475),(1,477),(1,478),(1,479),(1,480),(1,481),(1,482),(1,483),(1,484),(1,485),(1,486),(1,487),(1,488),(1,489),(1,491),(1,496),(1,498),(1,499),(1,500),(1,501),(1,503),(1,508),(1,509),(1,510),(1,511),(1,512),(1,514),(1,515),(1,516),(1,517),(1,518),(1,519),(1,520),(1,521),(1,522),(1,523),(1,524),(1,525),(1,526),(1,528),(1,533),(1,535),(1,536),(1,537),(1,538),(1,540),(1,545),(1,546),(1,547),(1,548),(1,549),(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,565),(1,570),(1,572),(1,573),(1,574),(1,575),(1,577),(1,582),(1,583),(1,584),(1,585),(1,586),(1,588),(1,589),(1,590),(1,591),(1,592),(1,593),(1,594),(1,595),(1,596),(1,597),(1,598),(1,599),(1,600),(1,602),(1,607),(1,609),(1,610),(1,611),(1,612),(1,614),(1,619),(1,620),(1,621),(1,622),(1,623),(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,639),(1,644),(1,646),(1,647),(1,648),(1,649),(1,651),(1,656),(1,657),(1,658),(1,659),(1,660),(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,681),(1,683),(1,684),(1,685),(1,686),(1,688),(1,693),(1,694),(1,695),(1,696),(1,697),(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,713),(1,718),(1,720),(1,721),(1,722),(1,723),(1,725),(1,730),(1,731),(1,732),(1,733),(1,734),(1,736),(1,737),(1,738),(1,739),(1,740),(1,741),(1,742),(1,743),(1,744),(1,745),(1,746),(1,747),(1,748),(1,749),(1,751),(1,756),(1,758),(1,759),(1,760),(1,761),(1,763),(1,768),(1,769),(1,770),(1,771),(1,772),(1,774),(1,775),(1,776),(1,777),(1,778),(1,779),(1,780),(1,781),(1,782),(1,783),(1,784),(1,785),(1,786),(1,787),(1,789),(1,794),(1,796),(1,797),(1,798),(1,799),(1,801),(1,806),(1,807),(1,808),(1,809),(1,810),(1,812),(1,813),(1,814),(1,815),(1,816),(1,817),(1,818),(1,819),(1,820),(1,821),(1,822),(1,823),(1,824),(1,825),(1,827),(1,832),(1,834),(1,835),(1,836),(1,837),(1,839),(1,844),(1,845),(1,846),(1,847),(1,849),(1,850),(1,851),(1,852),(1,853),(1,854),(1,855),(1,856),(1,857),(1,858),(1,859),(1,860),(1,861),(1,862),(1,863),(1,864),(1,866),(1,871),(1,873),(1,874),(1,875),(1,876),(1,878),(1,883),(1,884),(1,885),(1,886),(1,888),(1,889),(1,890),(1,891),(1,892),(1,893),(1,894),(1,895),(1,896),(1,897),(1,898),(1,899),(1,900),(1,901),(1,902),(1,903),(1,905),(1,910),(1,912),(1,913),(1,914),(1,915),(1,917),(1,922),(1,923),(1,924),(1,925),(1,927),(1,928),(1,929),(1,930),(1,931),(1,932),(1,933),(1,934),(1,935),(1,936),(1,937),(1,938),(1,939),(1,940),(1,941),(1,942),(1,944),(1,949),(1,951),(1,952),(1,953),(1,954),(1,956),(1,961),(1,962),(1,963),(1,964),(1,966),(1,967),(1,968),(1,969),(1,970),(1,971),(1,972),(1,973),(1,974),(1,975),(1,976),(1,977),(1,978),(1,979),(1,980),(1,981),(1,983),(1,988),(1,990),(1,991),(1,992),(1,993),(1,995),(1,1000),(1,1001),(1,1002),(1,1003),(1,1005),(1,1006),(1,1007),(1,1008),(1,1009),(1,1010),(1,1011),(1,1012),(1,1013),(1,1014),(1,1015),(1,1016),(1,1017),(1,1018),(1,1019),(1,1020),(1,1022),(1,1027),(1,1029),(1,1030),(1,1031),(1,1032),(1,1034),(1,1039),(1,1040),(1,1041),(1,1042),(1,1044),(1,1045),(1,1046),(1,1047),(1,1048),(1,1049),(1,1050),(1,1051),(1,1052),(1,1053),(1,1054),(1,1055),(1,1056),(1,1057),(1,1058),(1,1059),(1,1060),(1,1061),(1,1062),(1,1064),(1,1069),(1,1071),(1,1072),(1,1073),(1,1074),(1,1076),(1,1081),(1,1082),(1,1083),(1,1084),(1,1086),(1,1087),(1,1088),(1,1089),(1,1090),(1,1091),(1,1092),(1,1093),(1,1094),(1,1095),(1,1096),(1,1097),(1,1098),(1,1099),(1,1100),(1,1101),(1,1102),(1,1103),(1,1104),(1,1106),(1,1111),(1,1113),(1,1114),(1,1115),(1,1116),(1,1118),(1,1123),(1,1124),(1,1125),(1,1126),(1,1128),(1,1129),(1,1130),(1,1131),(1,1132),(1,1133),(1,1134),(1,1135),(1,1136),(1,1137),(1,1138),(1,1139),(1,1140),(1,1141),(1,1142),(1,1143),(1,1144),(1,1145),(1,1146),(1,1148),(1,1153),(1,1155),(1,1156),(1,1157),(1,1158),(1,1160),(1,1165),(1,1166),(1,1167),(1,1168),(1,1170),(1,1171),(1,1172),(1,1173),(1,1174),(1,1175),(1,1176),(1,1177),(1,1178),(1,1179),(1,1180),(1,1181),(1,1182),(1,1183),(1,1184),(1,1185),(1,1186),(1,1187),(1,1188),(1,1190),(1,1195),(1,1197),(1,1198),(1,1199),(1,1200),(1,1202),(1,1207),(1,1208),(1,1209),(1,1210),(1,1212),(1,1213),(1,1214),(1,1215),(1,1216),(1,1217),(1,1218),(1,1219),(1,1220),(1,1221),(1,1222),(1,1223),(1,1224),(1,1225),(1,1226),(1,1227),(1,1228),(1,1229),(1,1230),(1,1232),(1,1237),(1,1239),(1,1240),(1,1241),(1,1242),(1,1244),(1,1249),(1,1250),(1,1251),(1,1252),(1,1254),(1,1255),(1,1256),(1,1257),(1,1258),(1,1259),(1,1260),(1,1261),(1,1262),(1,1263),(1,1264),(1,1265),(1,1266),(1,1267),(1,1268),(1,1269),(1,1270),(1,1271),(1,1272),(1,1274),(1,1279),(1,1281),(1,1282),(1,1283),(1,1284),(1,1286),(1,1291),(1,1292),(1,1293),(1,1294),(1,1296),(1,1297),(1,1298),(1,1299),(1,1300),(1,1301),(1,1302),(1,1303),(1,1304),(1,1305),(1,1306),(1,1307),(1,1308),(1,1309),(1,1310),(1,1311),(1,1312),(1,1313),(1,1314),(1,1316),(1,1321),(1,1323),(1,1324),(1,1325),(1,1326),(1,1328),(1,1333),(1,1334),(1,1335),(1,1336),(1,1338),(1,1339),(1,1340),(1,1341),(1,1342),(1,1343),(1,1344),(1,1345),(1,1346),(1,1347),(1,1348),(1,1349),(1,1350),(1,1351),(1,1352),(1,1353),(1,1354),(1,1355),(1,1356),(1,1358),(1,1363),(1,1365),(1,1366),(1,1367),(1,1368),(1,1370),(1,1375),(1,1376),(1,1377),(1,1378),(1,1380),(1,1381),(1,1382),(1,1383),(1,1384),(1,1385),(1,1386),(1,1387),(1,1388),(1,1389),(1,1390),(1,1391),(1,1392),(1,1393),(1,1394),(1,1395),(1,1396),(1,1397),(1,1398),(1,1400),(1,1405),(1,1407),(1,1408),(1,1409),(1,1410),(1,1412),(1,1417),(1,1418),(1,1419),(1,1420),(1,1422),(1,1423),(1,1424),(1,1425),(1,1426),(1,1427),(1,1428),(1,1429),(1,1430),(1,1431),(1,1432),(1,1433),(1,1434),(1,1435),(1,1436),(1,1437),(1,1438),(1,1439),(1,1440),(1,1441),(1,1443),(1,1448),(1,1450),(1,1451),(1,1452),(1,1453),(1,1455),(1,1460),(1,1461),(1,1462),(1,1463),(1,1465),(1,1466),(1,1467),(1,1468),(1,1469),(1,1470),(1,1471),(1,1472),(1,1473),(1,1474),(1,1475),(1,1476),(1,1477),(1,1478),(1,1479),(1,1480),(1,1481),(1,1482),(1,1483),(1,1484),(1,1485),(1,1486),(1,1487),(1,1489),(1,1494),(1,1496),(1,1497),(1,1498),(1,1499),(1,1501),(1,1506),(1,1507),(1,1508),(1,1509),(1,1511),(1,1512),(1,1513),(1,1514),(1,1515),(1,1516),(1,1517),(1,1518),(1,1519),(1,1520),(1,1521),(1,1522),(1,1523),(1,1524),(1,1525),(1,1526),(1,1527),(1,1528),(1,1529),(1,1530),(1,1531),(1,1532),(1,1533),(1,1535),(1,1540),(1,1542),(1,1543),(1,1544),(1,1545),(1,1547),(1,1552),(1,1553),(1,1554),(1,1555),(1,1557),(1,1558),(1,1559),(1,1560),(1,1561),(1,1562),(1,1563),(1,1564),(1,1565),(1,1566),(1,1567),(1,1568),(1,1569),(1,1570),(1,1571),(1,1572),(1,1573),(1,1574),(1,1575),(1,1576),(1,1577),(1,1578),(1,1579),(1,1581),(1,1586),(1,1588),(1,1589),(1,1590),(1,1591),(1,1593),(1,1598),(1,1599),(1,1600),(1,1601),(1,1603),(1,1604),(1,1605),(1,1606),(1,1607),(1,1608),(1,1609),(1,1610),(1,1611),(1,1612),(1,1613),(1,1614),(1,1615),(1,1616),(1,1617),(1,1618),(1,1619),(1,1620),(1,1621),(1,1622),(1,1623),(1,1624),(1,1625),(1,1627),(1,1632),(1,1634),(1,1635),(1,1636),(1,1637),(1,1639),(1,1644),(1,1645),(1,1646),(1,1647),(1,1649),(1,1650),(1,1651),(1,1652),(1,1653),(1,1654),(1,1655),(1,1656),(1,1657),(1,1658),(1,1659),(1,1660),(1,1661),(1,1662),(1,1664),(1,1665),(1,1667),(1,1669),(1,1670),(1,1671),(1,1672),(1,1673),(1,1674),(1,1675),(1,1676),(1,1678),(1,1679),(1,1680),(1,1681),(1,1682),(1,1683),(1,1684),(1,1685),(1,1686),(1,1687),(1,1688),(1,1689),(1,1690),(1,1691),(1,1692),(1,1693),(1,1694),(1,1695),(1,1696),(1,1697),(1,1698),(1,1699),(1,1700),(1,1701),(1,1703),(1,1708),(1,1710),(1,1711),(1,1712),(1,1713),(1,1715),(1,1717),(1,1719),(1,1724),(1,1726),(1,1727),(1,1728),(1,1729),(1,1731),(1,1736),(1,1737),(1,1738),(1,1739),(1,1741),(1,1742),(1,1743),(1,1744),(1,1745),(1,1746),(1,1747),(1,1748),(1,1749),(1,1750),(1,1751),(1,1752),(1,1753),(1,1754),(1,1755),(1,1756),(1,1757),(1,1758),(1,1759),(1,1760),(1,1761),(1,1762),(1,1763),(1,1765),(1,1770),(1,1772),(1,1773),(1,1774),(1,1775),(1,1777),(1,1782),(1,1783),(1,1784),(1,1785),(1,1787),(1,1788),(1,1789),(1,1790),(1,1791),(1,1792),(1,1793),(1,1794),(1,1795),(1,1796),(1,1797),(1,1798),(1,1799),(1,1800),(1,1801),(1,1802),(1,1803),(1,1804),(1,1805),(1,1806),(1,1807),(1,1808),(1,1809),(1,1811),(1,1816),(1,1818),(1,1819),(1,1820),(1,1821),(1,1823),(1,1828),(1,1829),(1,1830),(1,1831),(1,1833),(1,1834),(1,1835),(1,1836),(1,1837),(1,1838),(1,1839),(1,1840),(1,1841),(1,1842),(1,1843),(1,1844),(1,1845),(1,1846),(1,1847),(1,1848),(1,1849),(1,1850),(1,1851),(1,1852),(1,1853),(1,1854),(1,1855),(1,1857),(1,1863),(1,1864),(1,1865),(1,1866),(1,1868),(1,1873),(1,1874),(1,1875),(1,1876),(1,1878),(1,1879),(1,1880),(1,1881),(1,1882),(1,1883),(1,1884),(1,1885),(1,1886),(1,1887),(1,1888),(1,1889),(1,1890),(1,1891),(1,1892),(1,1893),(1,1894),(1,1895),(1,1896),(1,1897),(1,1898),(1,1899),(1,1900),(1,1902),(1,1908),(1,1909),(1,1910),(1,1911),(1,1913),(1,1918),(1,1919),(1,1920),(1,1921),(1,1923),(1,1924),(1,1925),(1,1926),(1,1927),(1,1928),(1,1929),(1,1930),(1,1931),(1,1932),(1,1933),(1,1934),(1,1935),(1,1936),(1,1937),(1,1938),(1,1939),(1,1940),(1,1941),(1,1942),(1,1943),(1,1944),(1,1945),(1,1947),(1,1953),(1,1954),(1,1955),(1,1956),(1,1958),(1,1963),(1,1964),(1,1965),(1,1966),(1,1968),(1,1969),(1,1970),(1,1971),(1,1972),(1,1973),(1,1974),(1,1975),(1,1976),(1,1977),(1,1978),(1,1979),(1,1980),(1,1981),(1,1982),(1,1983),(1,1984),(1,1985),(1,1986),(1,1987),(1,1988),(1,1989),(1,1990),(1,1992),(1,1998),(1,1999),(1,2000),(1,2001),(1,2003),(1,2007),(1,2008),(1,2009),(1,2010),(1,2012),(1,2013),(1,2014),(1,2015),(1,2016),(1,2017),(1,2018),(1,2019),(1,2020),(1,2021),(1,2022),(1,2023),(1,2024),(1,2025),(1,2026),(1,2027),(1,2028),(1,2029),(1,2030),(1,2031),(1,2032),(1,2033),(1,2034),(1,2036),(1,2042),(1,2043),(1,2044),(1,2045),(1,2047),(1,2051),(1,2052),(1,2053),(1,2054),(1,2056),(1,2057),(1,2058),(1,2059),(1,2060),(1,2061),(1,2062),(1,2063),(1,2064),(1,2065),(1,2066),(1,2067),(1,2068),(1,2069),(1,2070),(1,2071),(1,2072),(1,2073),(1,2074),(1,2075),(1,2076),(1,2077),(1,2078),(1,2080),(1,2086),(1,2087),(1,2088),(1,2089),(1,2091),(1,2095),(1,2096),(1,2097),(1,2098),(1,2100),(1,2101),(1,2102),(1,2103),(1,2104),(1,2105),(1,2106),(1,2107),(1,2108),(1,2109),(1,2110),(1,2111),(1,2112),(1,2113),(1,2114),(1,2115),(1,2116),(1,2117),(1,2118),(1,2119),(1,2120),(1,2121),(1,2122),(1,2124),(1,2130),(1,2131),(1,2132),(1,2133),(1,2135),(1,2139),(1,2140),(1,2141),(1,2142),(1,2144),(1,2145),(1,2146),(1,2147),(1,2148),(1,2149),(1,2150),(1,2151),(1,2152),(1,2153),(1,2154),(1,2155),(1,2156),(1,2157),(1,2158),(1,2159),(1,2160),(1,2161),(1,2162),(1,2163),(1,2164),(1,2165),(1,2166),(1,2168),(1,2174),(1,2175),(1,2176),(1,2177),(1,2179),(1,2183),(1,2184),(1,2185),(1,2186),(1,2188),(1,2189),(1,2190),(1,2191),(1,2192),(1,2193),(1,2194),(1,2195),(1,2196),(1,2197),(1,2198),(1,2199),(1,2200),(1,2201),(1,2202),(1,2203),(1,2204),(1,2205),(1,2206),(1,2207),(1,2208),(1,2209),(1,2210),(1,2212),(1,2218),(1,2219),(1,2220),(1,2221),(1,2223),(1,2227),(1,2228),(1,2229),(1,2230),(1,2232),(1,2233),(1,2234),(1,2235),(1,2236),(1,2237),(1,2238),(1,2239),(1,2240),(1,2241),(1,2242),(1,2243),(1,2244),(1,2245),(1,2246),(1,2247),(1,2248),(1,2249),(1,2250),(1,2251),(1,2252),(1,2253),(1,2254),(1,2256),(1,2262),(1,2263),(1,2264),(1,2265),(1,2267),(1,2271),(1,2272),(1,2273),(1,2274),(1,2276),(1,2277),(1,2278),(1,2279),(1,2280),(1,2281),(1,2282),(1,2283),(1,2284),(1,2285),(1,2286),(1,2287),(1,2288),(1,2289),(1,2290),(1,2291),(1,2292),(1,2293),(1,2294),(1,2295),(1,2296),(1,2297),(1,2298),(1,2300),(1,2306),(1,2307),(1,2308),(1,2309),(1,2311),(1,2315),(1,2316),(1,2317),(1,2318),(1,2320),(1,2321),(1,2322),(1,2323),(1,2324),(1,2325),(1,2326),(1,2327),(1,2328),(1,2329),(1,2330),(1,2331),(1,2332),(1,2333),(1,2334),(1,2335),(1,2336),(1,2337),(1,2338),(1,2339),(1,2340),(1,2341),(1,2342),(1,2344),(1,2350),(1,2351),(1,2352),(1,2353),(1,2355),(1,2359),(1,2360),(1,2361),(1,2362),(1,2364),(1,2365),(1,2366),(1,2367),(1,2368),(1,2369),(1,2370),(1,2371),(1,2372),(1,2373),(1,2374),(1,2375),(1,2376),(1,2377),(1,2378),(1,2379),(1,2380),(1,2381),(1,2382),(1,2383),(1,2384),(1,2385),(1,2386),(1,2388),(1,2394),(1,2395),(1,2396),(1,2397),(1,2399),(1,2403),(1,2404),(1,2405),(1,2406),(1,2408),(1,2409),(1,2410),(1,2411),(1,2412),(1,2413),(1,2414),(1,2415),(1,2416),(1,2417),(1,2418),(1,2419),(1,2420),(1,2421),(1,2422),(1,2423),(1,2424),(1,2425),(1,2426),(1,2427),(1,2428),(1,2429),(1,2430),(1,2432),(1,2438),(1,2439),(1,2440),(1,2441),(1,2443),(1,2447),(1,2448),(1,2449),(1,2450),(1,2452),(1,2453),(1,2454),(1,2455),(1,2456),(1,2457),(1,2458),(1,2459),(1,2460),(1,2461),(1,2462),(1,2463),(1,2464),(1,2465),(1,2466),(1,2467),(1,2468),(1,2469),(1,2470),(1,2471),(1,2472),(1,2473),(1,2474),(1,2476),(1,2482),(1,2483),(1,2484),(1,2485),(1,2487),(1,2491),(1,2492),(1,2493),(1,2494),(1,2496),(1,2497),(1,2498),(1,2499),(1,2500),(1,2501),(1,2502),(1,2503),(1,2504),(1,2505),(1,2506),(1,2507),(1,2508),(1,2509),(1,2510),(1,2511),(1,2512),(1,2513),(1,2514),(1,2515),(1,2516),(1,2517),(1,2518),(1,2520),(1,2526),(1,2527),(1,2528),(1,2529),(1,2531),(1,2535),(1,2536),(1,2537),(1,2538),(1,2540),(1,2541),(1,2542),(1,2543),(1,2544),(1,2545),(1,2546),(1,2547),(1,2548),(1,2549),(1,2550),(1,2551),(1,2552),(1,2553),(1,2554),(1,2555),(1,2556),(1,2557),(1,2558),(1,2559),(1,2560),(1,2561),(1,2562),(1,2564),(1,2570),(1,2571),(1,2572),(1,2573),(1,2575),(1,2579),(1,2580),(1,2581),(1,2582),(1,2584),(1,2585),(1,2586),(1,2587),(1,2588),(1,2589),(1,2590),(1,2591),(1,2592),(1,2593),(1,2594),(1,2595),(1,2596),(1,2597),(1,2598),(1,2599),(1,2600),(1,2601),(1,2602),(1,2603),(1,2604),(1,2605),(1,2606),(1,2607),(1,2609),(1,2615),(1,2616),(1,2617),(1,2618),(1,2620),(1,2624),(1,2625),(1,2626),(1,2627),(1,2629),(1,2630),(1,2631),(1,2632),(1,2633),(1,2634),(1,2635),(1,2636),(1,2637),(1,2638),(1,2639),(1,2640),(1,2641),(1,2642),(1,2643),(1,2644),(1,2645),(1,2646),(1,2647),(1,2648),(1,2649),(1,2650),(1,2651),(1,2652),(1,2654),(1,2660),(1,2661),(1,2662),(1,2663),(1,2665),(1,2669),(1,2670),(1,2671),(1,2672),(1,2674),(1,2675),(1,2676),(1,2677),(1,2678),(1,2679),(1,2680),(1,2681),(1,2682),(1,2683),(1,2684),(1,2685),(1,2686),(1,2687),(1,2688),(1,2689),(1,2690),(1,2691),(1,2692),(1,2693),(1,2694),(1,2695),(1,2696),(1,2697),(1,2699),(1,2705),(1,2706),(1,2707),(1,2708),(1,2710),(1,2714),(1,2715),(1,2716),(1,2717),(1,2719),(1,2720),(1,2721),(1,2722),(1,2723),(1,2724),(1,2725),(1,2726),(1,2727),(1,2728),(1,2729),(1,2730),(1,2731),(1,2732),(1,2733),(1,2734),(1,2735),(1,2736),(1,2737),(1,2738),(1,2739),(1,2740),(1,2741),(1,2742),(1,2744),(1,2750),(1,2751),(1,2752),(1,2753),(1,2755),(1,2759),(1,2760),(1,2761),(1,2762),(1,2764),(1,2765),(1,2766),(1,2767),(1,2768),(1,2769),(1,2770),(1,2771),(1,2772),(1,2773),(1,2774),(1,2775),(1,2776),(1,2777),(1,2778),(1,2779),(1,2780),(1,2781),(1,2782),(1,2783),(1,2784),(1,2785),(1,2786),(1,2787),(1,2788),(1,2790),(1,2796),(1,2797),(1,2798),(1,2799),(1,2801),(1,2805),(1,2806),(1,2807),(1,2808),(1,2810),(1,2811),(1,2812),(1,2813),(1,2814),(1,2815),(1,2816),(1,2817),(1,2818),(1,2819),(1,2820),(1,2821),(1,2822),(1,2823),(1,2824),(1,2825),(1,2826),(1,2827),(1,2828),(1,2829),(1,2830),(1,2831),(1,2832),(1,2833),(1,2834),(1,2836),(1,2842),(1,2843),(1,2844),(1,2845),(1,2847),(1,2851),(1,2852),(1,2853),(1,2854),(1,2856),(1,2857),(1,2858),(1,2859),(1,2860),(1,2861),(1,2862),(1,2863),(1,2864),(1,2865),(1,2866),(1,2867),(1,2868),(1,2869),(1,2870),(1,2871),(1,2872),(1,2873),(1,2874),(1,2875),(1,2876),(1,2877),(1,2878),(1,2879),(1,2880),(1,2882),(1,2888),(1,2889),(1,2890),(1,2891),(1,2893),(1,2897),(1,2898),(1,2899),(1,2900),(1,2902),(1,2903),(1,2904),(1,2905),(1,2906),(1,2907),(1,2908),(1,2909),(1,2910),(1,2911),(1,2912),(1,2913),(1,2914),(1,2915),(1,2916),(1,2917),(1,2918),(1,2919),(1,2920),(1,2921),(1,2922),(1,2923),(1,2924),(1,2925),(1,2926),(1,2928),(1,2934),(1,2935),(1,2936),(1,2937),(1,2939),(1,2943),(1,2944),(1,2945),(1,2946),(1,2948),(1,2949),(1,2950),(1,2951),(1,2952),(1,2953),(1,2954),(1,2955),(1,2956),(1,2957),(1,2958),(1,2959),(1,2960),(1,2961),(1,2962),(1,2963),(1,2964),(1,2965),(1,2966),(1,2967),(1,2968),(1,2969),(1,2970),(1,2971),(1,2972),(1,2974),(1,2980),(1,2981),(1,2982),(1,2983),(1,2985),(1,2989),(1,2990),(1,2991),(1,2992),(1,2994),(1,2995),(1,2996),(1,2997),(1,2998),(1,2999),(1,3000),(1,3001),(1,3002),(1,3003),(1,3004),(1,3005),(1,3006),(1,3007),(1,3008),(1,3009),(1,3010),(1,3011),(1,3012),(1,3013),(1,3014),(1,3015),(1,3016),(1,3017),(1,3018),(1,3020),(1,3026),(1,3027),(1,3028),(1,3029),(1,3031),(1,3035),(1,3036),(1,3037),(1,3038),(1,3040),(1,3041),(1,3042),(1,3043),(1,3044),(1,3045),(1,3046),(1,3047),(1,3048),(1,3049),(1,3050),(1,3051),(1,3052),(1,3053),(1,3054),(1,3055),(1,3056),(1,3057),(1,3058),(1,3059),(1,3060),(1,3061),(1,3062),(1,3063),(1,3064),(1,3066),(1,3072),(1,3073),(1,3074),(1,3075),(1,3077),(1,3081),(1,3082),(1,3083),(1,3084),(1,3086),(1,3087),(1,3088),(1,3089),(1,3090),(1,3091),(1,3092),(1,3093),(1,3094),(1,3095),(1,3096),(1,3097),(1,3098),(1,3099),(1,3100),(1,3101),(1,3102),(1,3103),(1,3104),(1,3105),(1,3106),(1,3107),(1,3108),(1,3109),(1,3110),(1,3112),(1,3118),(1,3119),(1,3120),(1,3121),(1,3123),(1,3127),(1,3128),(1,3129),(1,3130),(1,3132),(1,3133),(1,3134),(1,3135),(1,3136),(1,3137),(1,3138),(1,3139),(1,3140),(1,3141),(1,3142),(1,3143),(1,3144),(1,3145),(1,3146),(1,3147),(1,3148),(1,3149),(1,3150),(1,3151),(1,3152),(1,3153),(1,3154),(1,3155),(1,3156),(1,3158),(1,3163),(1,3164),(1,3165),(1,3167),(1,3171),(1,3172),(1,3173),(1,3175),(1,3176),(1,3177),(1,3178),(1,3179),(1,3180),(1,3181),(1,3182),(1,3183),(1,3184),(1,3185),(1,3186),(1,3187),(1,3188),(1,3189),(1,3190),(1,3191),(1,3192),(1,3193),(1,3194),(1,3195),(1,3196),(1,3197),(1,3199),(1,3204),(1,3205),(1,3206),(1,3208),(1,3212),(1,3213),(1,3214),(1,3216),(1,3217),(1,3218),(1,3219),(1,3220),(1,3221),(1,3222),(1,3223),(1,3224),(1,3225),(1,3226),(1,3227),(1,3228),(1,3229),(1,3230),(1,3231),(1,3232),(1,3233),(1,3234),(1,3235),(1,3236),(1,3237),(1,3238),(1,3240),(1,3245),(1,3246),(1,3247),(1,3249),(1,3253),(1,3254),(1,3255),(1,3257),(1,3258),(1,3259),(1,3260),(1,3261),(1,3262),(1,3263),(1,3264),(1,3265),(1,3266),(1,3267),(1,3268),(1,3269),(1,3270),(1,3271),(1,3272),(1,3273),(1,3274),(1,3275),(1,3276),(1,3277),(1,3278),(1,3279),(1,3281),(1,3286),(1,3287),(1,3288),(1,3290),(1,3294),(1,3295),(1,3296),(1,3298),(1,3299),(1,3300),(1,3301),(1,3302),(1,3303),(1,3304),(1,3305),(1,3306),(1,3307),(1,3308),(1,3309),(1,3310),(1,3311),(1,3312),(1,3313),(1,3314),(1,3315),(1,3316),(1,3317),(1,3318),(1,3319),(1,3320),(1,3322),(1,3327),(1,3328),(1,3329),(1,3331),(1,3335),(1,3336),(1,3337),(1,3339),(1,3340),(1,3341),(1,3342),(1,3343),(1,3344),(1,3345),(1,3346),(1,3347),(1,3348),(1,3349),(1,3350),(1,3351),(1,3352),(1,3353),(1,3354),(1,3355),(1,3356),(1,3357),(1,3358),(1,3359),(1,3360),(1,3361),(1,3363),(1,3368),(1,3369),(1,3370),(1,3372),(1,3376),(1,3377),(1,3378),(1,3380),(1,3381),(1,3382),(1,3383),(1,3384),(1,3385),(1,3386),(1,3387),(1,3388),(1,3389),(1,3390),(1,3391),(1,3392),(1,3393),(1,3394),(1,3395),(1,3396),(1,3397),(1,3398),(1,3399),(1,3400),(1,3401),(1,3402),(1,3404),(1,3409),(1,3410),(1,3411),(1,3413),(1,3417),(1,3418),(1,3419),(1,3421),(1,3422),(1,3423),(1,3424),(1,3425),(1,3426),(1,3427),(1,3428),(1,3429),(1,3430),(1,3431),(1,3432),(1,3433),(1,3434),(1,3435),(1,3436),(1,3437),(1,3438),(1,3439),(1,3440),(1,3441),(1,3442),(1,3443),(1,3445),(1,3450),(1,3451),(1,3452),(1,3454),(1,3458),(1,3459),(1,3460),(1,3462),(1,3463),(1,3464),(1,3465),(1,3466),(1,3467),(1,3468),(1,3469),(1,3470),(1,3471),(1,3472),(1,3473),(1,3474),(1,3475),(1,3476),(1,3477),(1,3478),(1,3479),(1,3480),(1,3481),(1,3482),(1,3483),(1,3484),(1,3486),(1,3491),(1,3492),(1,3493),(1,3495),(1,3499),(1,3500),(1,3501),(1,3503),(1,3504),(1,3505),(1,3506),(1,3507),(1,3508),(1,3509),(1,3510),(1,3511),(1,3512),(1,3513),(1,3514),(1,3515),(1,3516),(1,3517),(1,3518),(1,3519),(1,3520),(1,3521),(1,3522),(1,3523),(1,3524),(1,3525),(1,3527),(1,3532),(1,3533),(1,3534),(1,3536),(1,3540),(1,3541),(1,3542),(1,3544),(1,3545),(1,3546),(1,3547),(1,3548),(1,3549),(1,3550),(1,3551),(1,3552),(1,3553),(1,3554),(1,3555),(1,3556),(1,3557),(1,3558),(1,3559),(1,3560),(1,3561),(1,3562),(1,3563),(1,3564),(1,3565),(1,3566),(1,3568),(1,3573),(1,3574),(1,3575),(1,3577),(1,3581),(1,3582),(1,3583),(1,3585),(1,3586),(1,3587),(1,3588),(1,3589),(1,3590),(1,3591),(1,3592),(1,3593),(1,3594),(1,3595),(1,3596),(1,3597),(1,3598),(1,3599),(1,3600),(1,3601),(1,3602),(1,3603),(1,3604),(1,3605),(1,3606),(1,3607),(1,3609),(1,3614),(1,3615),(1,3616),(1,3618),(1,3622),(1,3623),(1,3624),(1,3626),(1,3627),(1,3628),(1,3629),(1,3630),(1,3631),(1,3632),(1,3633),(1,3634),(1,3635),(1,3636),(1,3637),(1,3638),(1,3639),(1,3640),(1,3641),(1,3642),(1,3643),(1,3644),(1,3645),(1,3646),(1,3647),(1,3648),(1,3650),(1,3655),(1,3656),(1,3657),(1,3659),(1,3663),(1,3664),(1,3665),(1,3667),(1,3668),(1,3669),(1,3670),(1,3671),(1,3672),(1,3673),(1,3674),(1,3675),(1,3676),(1,3677),(1,3678),(1,3679),(1,3680),(1,3681),(1,3682),(1,3683),(1,3684),(1,3685),(1,3686),(1,3687),(1,3688),(1,3689),(1,3691),(1,3696),(1,3697),(1,3698),(1,3700),(1,3704),(1,3705),(1,3706),(1,3708),(1,3709),(1,3710),(1,3711),(1,3712),(1,3713),(1,3714),(1,3715),(1,3716),(1,3717),(1,3718),(1,3719),(1,3720),(1,3721),(1,3722),(1,3723),(1,3724),(1,3725),(1,3726),(1,3727),(1,3728),(1,3729),(1,3730),(1,3732),(1,3737),(1,3738),(1,3739),(1,3741),(1,3745),(1,3746),(1,3747),(1,3749),(1,3750),(1,3751),(1,3752),(1,3753),(1,3754),(1,3755),(1,3756),(1,3757),(1,3758),(1,3759),(1,3760),(1,3761),(1,3762),(1,3763),(1,3764),(1,3765),(1,3766),(1,3767),(1,3768),(1,3769),(1,3770),(1,3771),(1,3772),(1,3773),(1,3774),(1,3776),(1,3781),(1,3782),(1,3783),(1,3785),(1,3789),(1,3790),(1,3791),(1,3793),(1,3794),(1,3795),(1,3796),(1,3797),(1,3798),(1,3799),(1,3800),(1,3801),(1,3802),(1,3803),(1,3804),(1,3805),(1,3806),(1,3807),(1,3808),(1,3809),(1,3810),(1,3811),(1,3812),(1,3813),(1,3814),(1,3815),(1,3816),(1,3817),(1,3818),(1,3820),(1,3825),(1,3826),(1,3827),(1,3829),(1,3833),(1,3834),(1,3835),(1,3837),(1,3838),(1,3839),(1,3840),(1,3841),(1,3842),(1,3843),(1,3844),(1,3845),(1,3846),(1,3847),(1,3848),(1,3849),(1,3850),(1,3851),(1,3852),(1,3853),(1,3854),(1,3855),(1,3856),(1,3857),(1,3858),(1,3859),(1,3860),(1,3861),(9,22),(9,28),(9,63),(9,69),(9,104),(9,110),(9,145),(9,151),(9,186),(9,192),(9,227),(9,233),(9,268),(9,274),(9,309),(9,315),(9,350),(9,356),(9,391),(9,397),(9,432),(9,438),(9,470),(9,476),(9,507),(9,513),(9,544),(9,550),(9,581),(9,587),(9,618),(9,624),(9,655),(9,661),(9,692),(9,698),(9,729),(9,735),(9,767),(9,773),(9,805),(9,811),(9,843),(9,848),(9,882),(9,887),(9,921),(9,926),(9,960),(9,965),(9,999),(9,1004),(9,1038),(9,1043),(9,1080),(9,1085),(9,1122),(9,1127),(9,1164),(9,1169),(9,1206),(9,1211),(9,1248),(9,1253),(9,1290),(9,1295),(9,1332),(9,1337),(9,1374),(9,1379),(9,1416),(9,1421),(9,1459),(9,1464),(9,1505),(9,1510),(9,1551),(9,1556),(9,1597),(9,1602),(9,1643),(9,1648),(9,1668),(9,1677),(9,1735),(9,1740),(9,1781),(9,1786),(9,1827),(9,1832),(9,1872),(9,1877),(9,1917),(9,1922),(9,1962),(9,1967),(9,2011),(9,2055),(9,2099),(9,2143),(9,2187),(9,2231),(9,2275),(9,2319),(9,2363),(9,2407),(9,2451),(9,2495),(9,2539),(9,2583),(9,2628),(9,2673),(9,2718),(9,2763),(9,2809),(9,2855),(9,2901),(9,2947),(9,2993),(9,3039),(9,3085),(9,3131),(9,3174),(9,3215),(9,3256),(9,3297),(9,3338),(9,3379),(9,3420),(9,3461),(9,3502),(9,3543),(9,3584),(9,3625),(9,3666),(9,3707),(9,3748),(9,3792),(9,3836),(21,18),(21,19),(21,21),(21,59),(21,60),(21,62),(21,100),(21,101),(21,103),(21,141),(21,142),(21,144),(21,182),(21,183),(21,185),(21,223),(21,224),(21,226),(21,264),(21,265),(21,267),(21,305),(21,306),(21,308),(21,346),(21,347),(21,349),(21,387),(21,388),(21,390),(21,428),(21,429),(21,431),(21,467),(21,468),(21,469),(21,504),(21,505),(21,506),(21,541),(21,542),(21,543),(21,578),(21,579),(21,580),(21,615),(21,616),(21,617),(21,652),(21,653),(21,654),(21,689),(21,690),(21,691),(21,726),(21,727),(21,728),(21,764),(21,765),(21,766),(21,802),(21,803),(21,804),(21,840),(21,841),(21,842),(21,879),(21,880),(21,881),(21,918),(21,919),(21,920),(21,957),(21,958),(21,959),(21,996),(21,997),(21,998),(21,1035),(21,1036),(21,1037),(21,1077),(21,1078),(21,1079),(21,1119),(21,1120),(21,1121),(21,1161),(21,1162),(21,1163),(21,1203),(21,1204),(21,1205),(21,1245),(21,1246),(21,1247),(21,1287),(21,1288),(21,1289),(21,1329),(21,1330),(21,1331),(21,1371),(21,1372),(21,1373),(21,1413),(21,1414),(21,1415),(21,1456),(21,1457),(21,1458),(21,1502),(21,1503),(21,1504),(21,1548),(21,1549),(21,1550),(21,1594),(21,1595),(21,1596),(21,1640),(21,1641),(21,1642),(21,1663),(21,1666),(21,1716),(21,1732),(21,1733),(21,1734),(21,1778),(21,1779),(21,1780),(21,1824),(21,1825),(21,1826),(21,1869),(21,1870),(21,1871),(21,1914),(21,1915),(21,1916),(21,1959),(21,1960),(21,1961),(21,2004),(21,2005),(21,2006),(21,2048),(21,2049),(21,2050),(21,2092),(21,2093),(21,2094),(21,2136),(21,2137),(21,2138),(21,2180),(21,2181),(21,2182),(21,2224),(21,2225),(21,2226),(21,2268),(21,2269),(21,2270),(21,2312),(21,2313),(21,2314),(21,2356),(21,2357),(21,2358),(21,2400),(21,2401),(21,2402),(21,2444),(21,2445),(21,2446),(21,2488),(21,2489),(21,2490),(21,2532),(21,2533),(21,2534),(21,2576),(21,2577),(21,2578),(21,2621),(21,2622),(21,2623),(21,2666),(21,2667),(21,2668),(21,2711),(21,2712),(21,2713),(21,2756),(21,2757),(21,2758),(21,2802),(21,2803),(21,2804),(21,2848),(21,2849),(21,2850),(21,2894),(21,2895),(21,2896),(21,2940),(21,2941),(21,2942),(21,2986),(21,2987),(21,2988),(21,3032),(21,3033),(21,3034),(21,3078),(21,3079),(21,3080),(21,3124),(21,3125),(21,3126),(21,3168),(21,3169),(21,3170),(21,3209),(21,3210),(21,3211),(21,3250),(21,3251),(21,3252),(21,3291),(21,3292),(21,3293),(21,3332),(21,3333),(21,3334),(21,3373),(21,3374),(21,3375),(21,3414),(21,3415),(21,3416),(21,3455),(21,3456),(21,3457),(21,3496),(21,3497),(21,3498),(21,3537),(21,3538),(21,3539),(21,3578),(21,3579),(21,3580),(21,3619),(21,3620),(21,3621),(21,3660),(21,3661),(21,3662),(21,3701),(21,3702),(21,3703),(21,3742),(21,3743),(21,3744),(21,3786),(21,3787),(21,3788),(21,3830),(21,3831),(21,3832),(22,2),(22,5),(22,22),(22,43),(22,46),(22,63),(22,84),(22,87),(22,104),(22,125),(22,128),(22,145),(22,166),(22,169),(22,186),(22,207),(22,210),(22,227),(22,248),(22,251),(22,268),(22,289),(22,292),(22,309),(22,330),(22,333),(22,350),(22,371),(22,374),(22,391),(22,412),(22,415),(22,432),(22,470),(22,507),(22,544),(22,581),(22,618),(22,655),(22,692),(22,729),(22,767),(22,805),(22,843),(22,882),(22,921),(22,960),(22,999),(22,1038),(22,1080),(22,1122),(22,1164),(22,1206),(22,1248),(22,1290),(22,1332),(22,1374),(22,1416),(22,1459),(22,1505),(22,1551),(22,1597),(22,1643),(22,1668),(22,1735),(22,1781),(22,1827),(22,1872),(22,1917),(22,1962),(23,2),(23,5),(23,43),(23,46),(23,84),(23,87),(23,125),(23,128),(23,166),(23,169),(23,207),(23,210),(23,248),(23,251),(23,289),(23,292),(23,330),(23,333),(23,371),(23,374),(23,412),(23,415),(30,2),(30,5),(30,11),(30,18),(30,43),(30,46),(30,52),(30,59),(30,84),(30,87),(30,93),(30,100),(30,125),(30,128),(30,134),(30,141),(30,166),(30,169),(30,175),(30,182),(30,207),(30,210),(30,216),(30,223),(30,248),(30,251),(30,257),(30,264),(30,289),(30,292),(30,298),(30,305),(30,330),(30,333),(30,339),(30,346),(30,371),(30,374),(30,380),(30,387),(30,412),(30,415),(30,421),(30,428),(30,460),(30,467),(30,497),(30,504),(30,534),(30,541),(30,571),(30,578),(30,608),(30,615),(30,645),(30,652),(30,682),(30,689),(30,719),(30,726),(30,757),(30,764),(30,795),(30,802),(30,833),(30,840),(30,872),(30,879),(30,911),(30,918),(30,950),(30,957),(30,989),(30,996),(30,1028),(30,1035),(30,1070),(30,1077),(30,1112),(30,1119),(30,1154),(30,1161),(30,1196),(30,1203),(30,1238),(30,1245),(30,1280),(30,1287),(30,1322),(30,1329),(30,1364),(30,1371),(30,1406),(30,1413),(30,1449),(30,1456),(30,1495),(30,1502),(30,1541),(30,1548),(30,1587),(30,1594),(30,1633),(30,1640),(30,1709),(30,1716),(30,1725),(30,1732),(30,1771),(30,1778),(30,1817),(30,1824),(30,1862),(30,1869),(30,1907),(30,1914),(30,1952),(30,1959),(30,1997),(30,2004),(30,2041),(30,2048),(30,2085),(30,2092),(30,2129),(30,2136),(30,2173),(30,2180),(30,2217),(30,2224),(30,2261),(30,2268),(30,2305),(30,2312),(30,2349),(30,2356),(30,2393),(30,2400),(30,2437),(30,2444),(30,2481),(30,2488),(30,2525),(30,2532),(30,2569),(30,2576),(30,2614),(30,2621),(30,2659),(30,2666),(30,2704),(30,2711),(30,2749),(30,2756),(30,2795),(30,2802),(30,2841),(30,2848),(30,2887),(30,2894),(30,2933),(30,2940),(30,2979),(30,2986),(30,3025),(30,3032),(30,3071),(30,3078),(30,3117),(30,3124),(30,3168),(30,3209),(30,3250),(30,3291),(30,3332),(30,3373),(30,3414),(30,3455),(30,3496),(30,3537),(30,3578),(30,3619),(30,3660),(30,3701),(30,3742),(30,3786),(30,3830),(37,16),(37,28),(37,57),(37,69),(37,98),(37,110),(37,139),(37,151),(37,180),(37,192),(37,221),(37,233),(37,262),(37,274),(37,303),(37,315),(37,344),(37,356),(37,385),(37,397),(37,426),(37,438),(37,465),(37,476),(37,502),(37,513),(37,539),(37,550),(37,576),(37,587),(37,613),(37,624),(37,650),(37,661),(37,687),(37,698),(37,724),(37,735),(37,762),(37,773),(37,800),(37,811),(37,838),(37,848),(37,877),(37,887),(37,916),(37,926),(37,955),(37,965),(37,994),(37,1004),(37,1033),(37,1043),(37,1075),(37,1085),(37,1117),(37,1127),(37,1159),(37,1169),(37,1201),(37,1211),(37,1243),(37,1253),(37,1285),(37,1295),(37,1327),(37,1337),(37,1369),(37,1379),(37,1411),(37,1421),(37,1454),(37,1464),(37,1500),(37,1510),(37,1546),(37,1556),(37,1592),(37,1602),(37,1638),(37,1648),(37,1677),(37,1714),(37,1730),(37,1740),(37,1776),(37,1786),(37,1822),(37,1832),(37,1867),(37,1877),(37,1912),(37,1922),(37,1957),(37,1967),(37,2002),(37,2011),(37,2046),(37,2055),(37,2090),(37,2099),(37,2134),(37,2143),(37,2178),(37,2187),(37,2222),(37,2231),(37,2266),(37,2275),(37,2310),(37,2319),(37,2354),(37,2363),(37,2398),(37,2407),(37,2442),(37,2451),(37,2486),(37,2495),(37,2530),(37,2539),(37,2574),(37,2583),(37,2619),(37,2628),(37,2664),(37,2673),(37,2709),(37,2718),(37,2754),(37,2763),(37,2800),(37,2809),(37,2846),(37,2855),(37,2892),(37,2901),(37,2938),(37,2947),(37,2984),(37,2993),(37,3030),(37,3039),(37,3076),(37,3085),(37,3122),(37,3131),(37,3166),(37,3174),(37,3207),(37,3215),(37,3248),(37,3256),(37,3289),(37,3297),(37,3330),(37,3338),(37,3371),(37,3379),(37,3412),(37,3420),(37,3453),(37,3461),(37,3494),(37,3502),(37,3535),(37,3543),(37,3576),(37,3584),(37,3617),(37,3625),(37,3658),(37,3666),(37,3699),(37,3707),(37,3740),(37,3748),(37,3784),(37,3792),(37,3828),(37,3836),(39,28),(39,69),(39,110),(39,151),(39,192),(39,233),(39,274),(39,315),(39,356),(39,397),(39,438),(39,476),(39,513),(39,550),(39,587),(39,624),(39,661),(39,698),(39,735),(39,773),(39,811),(39,848),(39,887),(39,926),(39,965),(39,1004),(39,1043),(39,1085),(39,1127),(39,1169),(39,1211),(39,1253),(39,1295),(39,1337),(39,1379),(39,1421),(39,1464),(39,1510),(39,1556),(39,1602),(39,1648),(39,1677),(39,1740),(39,1786),(39,1832),(39,1877),(39,1922),(39,1967),(39,2011),(39,2055),(39,2099),(39,2143),(39,2187),(39,2231),(39,2275),(39,2319),(39,2363),(39,2407),(39,2451),(39,2495),(39,2539),(39,2583),(39,2628),(39,2673),(39,2718),(39,2763),(39,2809),(39,2855),(39,2901),(39,2947),(39,2993),(39,3039),(39,3085),(39,3131),(39,3174),(39,3215),(39,3256),(39,3297),(39,3338),(39,3379),(39,3420),(39,3461),(39,3502),(39,3543),(39,3584),(39,3625),(39,3666),(39,3707),(39,3748),(39,3792),(39,3836),(41,16),(41,57),(41,98),(41,139),(41,180),(41,221),(41,262),(41,303),(41,344),(41,385),(41,426),(41,465),(41,502),(41,539),(41,576),(41,613),(41,650),(41,687),(41,724),(41,762),(41,800),(41,838),(41,877),(41,916),(41,955),(41,994),(41,1033),(41,1075),(41,1117),(41,1159),(41,1201),(41,1243),(41,1285),(41,1327),(41,1369),(41,1411),(41,1454),(41,1500),(41,1546),(41,1592),(41,1638),(41,1714),(41,1730),(41,1776),(41,1822),(41,1867),(41,1912),(41,1957),(41,2002),(41,2046),(41,2090),(41,2134),(41,2178),(41,2222),(41,2266),(41,2310),(41,2354),(41,2398),(41,2442),(41,2486),(41,2530),(41,2574),(41,2619),(41,2664),(41,2709),(41,2754),(41,2800),(41,2846),(41,2892),(41,2938),(41,2984),(41,3030),(41,3076),(41,3122),(41,3166),(41,3207),(41,3248),(41,3289),(41,3330),(41,3371),(41,3412),(41,3453),(41,3494),(41,3535),(41,3576),(41,3617),(41,3658),(41,3699),(41,3740),(41,3784),(41,3828),(48,11),(48,52),(48,93),(48,134),(48,175),(48,216),(48,257),(48,298),(48,339),(48,380),(48,421),(48,460),(48,497),(48,534),(48,571),(48,608),(48,645),(48,682),(48,719),(48,757),(48,795),(48,833),(48,872),(48,911),(48,950),(48,989),(48,1028),(48,1070),(48,1112),(48,1154),(48,1196),(48,1238),(48,1280),(48,1322),(48,1364),(48,1406),(48,1449),(48,1495),(48,1541),(48,1587),(48,1633),(48,1709),(48,1725),(48,1771),(48,1817),(48,1862),(48,1907),(48,1952),(48,1997),(48,2041),(48,2085),(48,2129),(48,2173),(48,2217),(48,2261),(48,2305),(48,2349),(48,2393),(48,2437),(48,2481),(48,2525),(48,2569),(48,2614),(48,2659),(48,2704),(48,2749),(48,2795),(48,2841),(48,2887),(48,2933),(48,2979),(48,3025),(48,3071),(48,3117),(53,6),(53,47),(53,88),(53,129),(53,170),(53,211),(53,252),(53,293),(53,334),(53,375),(53,416),(53,455),(53,492),(53,529),(53,566),(53,603),(53,640),(53,677),(53,714),(53,752),(53,790),(53,828),(53,867),(53,906),(53,945),(53,984),(53,1023),(53,1065),(53,1107),(53,1149),(53,1191),(53,1233),(53,1275),(53,1317),(53,1359),(53,1401),(53,1444),(53,1490),(53,1536),(53,1582),(53,1628),(53,1704),(53,1720),(53,1766),(53,1812),(53,1858),(53,1903),(53,1948),(53,1993),(53,2037),(53,2081),(53,2125),(53,2169),(53,2213),(53,2257),(53,2301),(53,2345),(53,2389),(53,2433),(53,2477),(53,2521),(53,2565),(53,2610),(53,2655),(53,2700),(53,2745),(53,2791),(53,2837),(53,2883),(53,2929),(53,2975),(53,3021),(53,3067),(53,3113),(53,3159),(53,3200),(53,3241),(53,3282),(53,3323),(53,3364),(53,3405),(53,3446),(53,3487),(53,3528),(53,3569),(53,3610),(53,3651),(53,3692),(53,3733),(53,3777),(53,3821),(59,3),(59,44),(59,85),(59,126),(59,167),(59,208),(59,249),(59,290),(59,331),(59,372),(59,413),(59,453),(59,490),(59,527),(59,564),(59,601),(59,638),(59,675),(59,712),(59,750),(59,788),(59,826),(59,865),(59,904),(59,943),(59,982),(59,1021),(59,1063),(59,1105),(59,1147),(59,1189),(59,1231),(59,1273),(59,1315),(59,1357),(59,1399),(59,1442),(59,1488),(59,1534),(59,1580),(59,1626),(59,1702),(59,1718),(59,1764),(59,1810),(59,1856),(59,1901),(59,1946),(59,1991),(59,2035),(59,2079),(59,2123),(59,2167),(59,2211),(59,2255),(59,2299),(59,2343),(59,2387),(59,2431),(59,2475),(59,2519),(59,2563),(59,2608),(59,2653),(59,2698),(59,2743),(59,2789),(59,2835),(59,2881),(59,2927),(59,2973),(59,3019),(59,3065),(59,3111),(59,3157),(59,3198),(59,3239),(59,3280),(59,3321),(59,3362),(59,3403),(59,3444),(59,3485),(59,3526),(59,3567),(59,3608),(59,3649),(59,3690),(59,3731),(59,3775),(59,3819),(63,7),(63,48),(63,89),(63,130),(63,171),(63,212),(63,253),(63,294),(63,335),(63,376),(63,417),(63,456),(63,493),(63,530),(63,567),(63,604),(63,641),(63,678),(63,715),(63,753),(63,791),(63,829),(63,868),(63,907),(63,946),(63,985),(63,1024),(63,1066),(63,1108),(63,1150),(63,1192),(63,1234),(63,1276),(63,1318),(63,1360),(63,1402),(63,1445),(63,1491),(63,1537),(63,1583),(63,1629),(63,1705),(63,1721),(63,1767),(63,1813),(63,1859),(63,1904),(63,1949),(63,1994),(63,2038),(63,2082),(63,2126),(63,2170),(63,2214),(63,2258),(63,2302),(63,2346),(63,2390),(63,2434),(63,2478),(63,2522),(63,2566),(63,2611),(63,2656),(63,2701),(63,2746),(63,2792),(63,2838),(63,2884),(63,2930),(63,2976),(63,3022),(63,3068),(63,3114),(63,3160),(63,3201),(63,3242),(63,3283),(63,3324),(63,3365),(63,3406),(63,3447),(63,3488),(63,3529),(63,3570),(63,3611),(63,3652),(63,3693),(63,3734),(63,3778),(63,3822),(65,8),(65,49),(65,90),(65,131),(65,172),(65,213),(65,254),(65,295),(65,336),(65,377),(65,418),(65,457),(65,494),(65,531),(65,568),(65,605),(65,642),(65,679),(65,716),(65,754),(65,792),(65,830),(65,869),(65,908),(65,947),(65,986),(65,1025),(65,1067),(65,1109),(65,1151),(65,1193),(65,1235),(65,1277),(65,1319),(65,1361),(65,1403),(65,1446),(65,1492),(65,1538),(65,1584),(65,1630),(65,1706),(65,1722),(65,1768),(65,1814),(65,1860),(65,1905),(65,1950),(65,1995),(65,2039),(65,2083),(65,2127),(65,2171),(65,2215),(65,2259),(65,2303),(65,2347),(65,2391),(65,2435),(65,2479),(65,2523),(65,2567),(65,2612),(65,2657),(65,2702),(65,2747),(65,2793),(65,2839),(65,2885),(65,2931),(65,2977),(65,3023),(65,3069),(65,3115),(65,3161),(65,3202),(65,3243),(65,3284),(65,3325),(65,3366),(65,3407),(65,3448),(65,3489),(65,3530),(65,3571),(65,3612),(65,3653),(65,3694),(65,3735),(65,3779),(65,3823);

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

CREATE TABLE `ps_tab_lang` (
  `id_tab` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `name` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id_tab`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `ps_tab_lang` VALUES (1,1,'Dashboard'),(2,1,'Pagine CMS'),(3,1,'Categorie CMS'),(4,1,'Generatore di combinazioni'),(5,1,'Cerca'),(6,1,'Login'),(7,1,'Negozi associati'),(8,1,'URLs negozi'),(9,1,'Catalogo'),(10,1,'Ordini'),(11,1,'Clienti'),(12,1,'Regole Prezzi'),(13,1,'Moduli'),(14,1,'Spedizione'),(15,1,'Localizzazione'),(16,1,'Preferenze'),(17,1,'Parametri Avanzati'),(18,1,'Amministrazione'),(19,1,'Statistiche'),(20,1,'Magazzino'),(21,1,'Prodotti'),(22,1,'Categorie'),(23,1,'Monitoraggio'),(24,1,'Attributi e Valori'),(25,1,'Caratt.'),(26,1,'Produttori'),(27,1,'Fornitori'),(28,1,'Tag'),(29,1,'Documenti allegati'),(30,1,'Ordini'),(31,1,'Fatture'),(32,1,'Restituzione prodotto'),(33,1,'Note di Consegna'),(34,1,'Note di credito'),(35,1,'Stati'),(36,1,'Messaggi predefiniti'),(37,1,'Clienti'),(38,1,'Indirizzi'),(39,1,'Gruppi'),(40,1,'Carrello'),(41,1,'Servizio clienti'),(42,1,'Contatti'),(43,1,'Titoli'),(44,1,'In sospeso'),(45,1,'Regole carrello'),(46,1,'Regole Catalogo Prezzi'),(47,1,'Marketing'),(48,1,'Mezzi di spedizione'),(49,1,'Preferenze'),(50,1,'Carrier'),(51,1,'Localizzazione'),(52,1,'Lingue'),(53,1,'Zone'),(54,1,'Nazione'),(55,1,'Stati'),(56,1,'Valute'),(57,1,'Tasse'),(58,1,'Regole'),(59,1,'Traduzioni'),(60,1,'Moduli e Servizi'),(61,1,'Catalogo Moduli e temi'),(62,1,'Posizioni'),(63,1,'Pagamento'),(64,1,'Generale'),(65,1,'Ordini'),(66,1,'Prodotti'),(67,1,'Clienti'),(68,1,'Temi'),(69,1,'URL e SEO'),(70,1,'CMS'),(71,1,'Immagini'),(72,1,'Contatti del negozio'),(73,1,'Cerca'),(74,1,'Manutenzione'),(75,1,'Geolocalizzazione'),(76,1,'Informazioni'),(77,1,'Prestazioni'),(78,1,'E-mail'),(79,1,'Multi-negozio'),(80,1,'Importo CVS'),(81,1,'Backup DB'),(82,1,'Manager SQL'),(83,1,'Archivi'),(84,1,'Webservice'),(85,1,'Preferenze'),(86,1,'Accesso veloce'),(87,1,'Dipendenti'),(88,1,'Profili'),(89,1,'Permessi'),(90,1,'Tabs'),(91,1,'Statistiche'),(92,1,'Motori di ricerca'),(93,1,'Affiliati'),(94,1,'Magazzino'),(95,1,'Gestione dello Stock'),(96,1,'Movimento magazzino'),(97,1,'Stato dello stock Istantaneo'),(98,1,'Copertura Stock'),(99,1,'Ordini fornitura'),(100,1,'Configurazione'),(101,1,'BlockCategories'),(102,1,'Dashgoals'),(103,1,'themeconfigurator'),(104,1,'Merchant Expertise'),(105,1,'Cron Jobs'),(107,1,'Google Analytics Ajax');

--
-- 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 AUTO_INCREMENT=73 DEFAULT CHARSET=utf8;

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

INSERT INTO `ps_tag` VALUES (1,1,'g900f'),(14,1,'Cassa note 3'),(15,1,'note 3'),(16,1,'note III'),(17,1,'samsung note 3'),(19,1,'antenna note 3'),(23,1,'s6 edge'),(24,1,'antenna s6 edge'),(25,1,'antenna g925f'),(28,1,'fotocamera s6 edge'),(29,1,'fotocamera frontale s6 edge'),(39,1,'s7'),(40,1,'samsung s7'),(41,1,'g930'),(42,1,'fotocamera s7'),(44,1,'altoparlante s7'),(46,1,'jack audio s7'),(47,1,'vibrazione note 2'),(48,1,'vibrazione note II'),(49,1,'N7100'),(50,1,'Note 2'),(51,1,'TASTO ACCENSIONE'),(52,1,'FLAT NOTE 2'),(53,1,'FLAT POWER'),(58,1,'FOTOCAMERA FRONTALE S2'),(59,1,'I9100'),(60,1,'S2'),(61,1,'SENSORE S2'),(62,1,'sensore prossimità s7'),(65,1,'biadesivo s7'),(66,1,'biadesivo g930'),(69,1,'biadesivo g935'),(70,1,'biadesivo s7 edge'),(71,1,'vibrazione s3'),(72,1,'i9300');

--
-- 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`
--

INSERT INTO `ps_tag_count` VALUES (0,1,1,1,1),(0,14,1,1,1),(0,17,1,1,1),(0,19,1,1,1),(0,24,1,1,1),(0,25,1,1,1),(0,28,1,1,1),(0,29,1,1,1),(0,42,1,1,1),(0,44,1,1,1),(0,46,1,1,1),(0,47,1,1,1),(0,48,1,1,1),(0,49,1,1,1),(0,51,1,1,1),(0,52,1,1,1),(0,53,1,1,1),(0,58,1,1,1),(0,59,1,1,1),(0,60,1,1,1),(0,61,1,1,1),(0,62,1,1,1),(0,66,1,1,1),(0,69,1,1,1),(0,70,1,1,1),(0,71,1,1,1),(0,72,1,1,1),(0,15,1,1,2),(0,16,1,1,2),(0,23,1,1,2),(0,50,1,1,2),(0,65,1,1,2),(0,40,1,1,4),(0,39,1,1,5),(0,41,1,1,5),(1,1,1,1,1),(1,14,1,1,1),(1,17,1,1,1),(1,19,1,1,1),(1,24,1,1,1),(1,25,1,1,1),(1,28,1,1,1),(1,29,1,1,1),(1,42,1,1,1),(1,44,1,1,1),(1,46,1,1,1),(1,47,1,1,1),(1,48,1,1,1),(1,49,1,1,1),(1,51,1,1,1),(1,52,1,1,1),(1,53,1,1,1),(1,58,1,1,1),(1,59,1,1,1),(1,60,1,1,1),(1,61,1,1,1),(1,62,1,1,1),(1,66,1,1,1),(1,69,1,1,1),(1,70,1,1,1),(1,71,1,1,1),(1,72,1,1,1),(1,15,1,1,2),(1,16,1,1,2),(1,23,1,1,2),(1,50,1,1,2),(1,65,1,1,2),(1,40,1,1,4),(1,39,1,1,5),(1,41,1,1,5),(2,1,1,1,1),(2,14,1,1,1),(2,17,1,1,1),(2,19,1,1,1),(2,24,1,1,1),(2,25,1,1,1),(2,28,1,1,1),(2,29,1,1,1),(2,42,1,1,1),(2,44,1,1,1),(2,46,1,1,1),(2,47,1,1,1),(2,48,1,1,1),(2,49,1,1,1),(2,51,1,1,1),(2,52,1,1,1),(2,53,1,1,1),(2,58,1,1,1),(2,59,1,1,1),(2,60,1,1,1),(2,61,1,1,1),(2,62,1,1,1),(2,66,1,1,1),(2,69,1,1,1),(2,70,1,1,1),(2,71,1,1,1),(2,72,1,1,1),(2,15,1,1,2),(2,16,1,1,2),(2,23,1,1,2),(2,50,1,1,2),(2,65,1,1,2),(2,40,1,1,4),(2,39,1,1,5),(2,41,1,1,5),(3,1,1,1,1),(3,14,1,1,1),(3,17,1,1,1),(3,19,1,1,1),(3,24,1,1,1),(3,25,1,1,1),(3,28,1,1,1),(3,29,1,1,1),(3,42,1,1,1),(3,44,1,1,1),(3,46,1,1,1),(3,47,1,1,1),(3,48,1,1,1),(3,49,1,1,1),(3,51,1,1,1),(3,52,1,1,1),(3,53,1,1,1),(3,58,1,1,1),(3,59,1,1,1),(3,60,1,1,1),(3,61,1,1,1),(3,62,1,1,1),(3,66,1,1,1),(3,69,1,1,1),(3,70,1,1,1),(3,71,1,1,1),(3,72,1,1,1),(3,15,1,1,2),(3,16,1,1,2),(3,23,1,1,2),(3,50,1,1,2),(3,65,1,1,2),(3,40,1,1,4),(3,39,1,1,5),(3,41,1,1,5);

--
-- 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=69 DEFAULT CHARSET=utf8;

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

INSERT INTO `ps_tax` VALUES (1,22.000,1,0),(2,10.000,1,0),(3,4.000,1,0),(4,0.000,1,0),(5,21.000,1,0),(6,20.000,1,0),(7,19.000,1,0),(8,21.000,1,0),(9,19.000,1,0),(10,25.000,1,0),(11,20.000,1,0),(12,21.000,1,0),(13,24.000,1,0),(14,20.000,1,0),(15,20.000,1,0),(16,23.000,1,0),(17,25.000,1,0),(18,27.000,1,0),(19,23.000,1,0),(20,21.000,1,0),(21,17.000,1,0),(22,21.000,1,0),(23,18.000,1,0),(24,21.000,1,0),(25,23.000,1,0),(26,23.000,1,0),(27,24.000,1,0),(28,25.000,1,0),(29,22.000,1,0),(30,20.000,1,0),(31,0.000,0,0),(32,0.000,0,0),(33,6.000,1,0),(34,666.000,1,0),(35,2.000,1,0),(36,2.000,1,0),(37,1.000,1,0),(38,2.000,1,0),(39,2.000,1,0),(40,2.000,1,0),(41,2.000,1,0),(42,1.000,1,0),(43,1.000,1,0),(44,1.000,1,0),(45,1.000,1,0),(46,1.000,1,0),(47,1.000,1,0),(48,1.000,1,0),(49,2.000,1,0),(50,2.000,1,0),(51,1.000,1,0),(52,5.000,1,0),(53,1.000,1,0),(54,1.000,1,0),(55,1.000,1,0),(56,2.000,1,0),(57,2.000,1,0),(58,3.000,1,0),(59,3.000,1,0),(60,3.000,1,0),(61,1.000,1,0),(62,2.000,1,0),(63,3.000,1,0),(64,1.000,1,0),(65,2.000,1,0),(66,2.000,1,0),(68,0.000,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,'Aliquota ordinaria (22%)'),(2,1,'Aliquota ridotta (10%)'),(3,1,'Aliquota minima (4%)'),(4,1,'Esente IVA Art.74'),(5,1,'TVA BE 21%'),(6,1,'ДДС BG 20%'),(7,1,'ΦΠΑ CY 19%'),(8,1,'DPH CZ 21%'),(9,1,'MwSt. DE 19%'),(10,1,'moms DK 25%'),(11,1,'km EE 20%'),(12,1,'IVA ES 21%'),(13,1,'ALV FI 24%'),(14,1,'TVA FR 20%'),(15,1,'VAT UK 20%'),(16,1,'ΦΠΑ GR 23%'),(17,1,'Croatia PDV 25%'),(18,1,'ÁFA HU 27%'),(19,1,'VAT IE 23%'),(20,1,'PVM LT 21%'),(21,1,'TVA LU 17%'),(22,1,'PVN LV 21%'),(23,1,'VAT MT 18%'),(24,1,'BTW NL 21%'),(25,1,'PTU PL 23%'),(26,1,'IVA PT 23%'),(27,1,'TVA RO 24%'),(28,1,'Moms SE 25%'),(29,1,'DDV SI 22%'),(30,1,'DPH SK 20%'),(31,1,''),(32,1,''),(33,1,'a1'),(34,1,'a1'),(35,1,'nome'),(36,1,'nome'),(37,1,'nome'),(38,1,'aaa'),(39,1,'aaa'),(40,1,'aaa'),(41,1,'aaa'),(42,1,'a1'),(43,1,'a1'),(44,1,'a1'),(45,1,'a1'),(46,1,'a1'),(47,1,'a1'),(48,1,'a1'),(49,1,'FireFoxII'),(50,1,'FireFoxII'),(51,1,'aaa'),(52,1,'a1'),(53,1,'a1'),(54,1,'aaa'),(55,1,'a1'),(56,1,'aaa'),(57,1,'aaa'),(58,1,'aaa'),(59,1,'aaa'),(60,1,'aaa'),(61,1,'a1'),(62,1,'aaa'),(63,1,'FireFoxII'),(64,1,'aaa'),(65,1,'FireFoxII'),(66,1,'aaa'),(67,1,''),(68,1,'Articolo 10 comma 8');

--
-- 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=207 DEFAULT CHARSET=utf8;

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

INSERT INTO `ps_tax_rule` VALUES (1,1,3,0,'0','0',1,0,''),(2,1,236,0,'0','0',1,0,''),(3,1,16,0,'0','0',1,0,''),(4,1,20,0,'0','0',1,0,''),(5,1,1,0,'0','0',1,0,''),(6,1,86,0,'0','0',1,0,''),(7,1,9,0,'0','0',1,0,''),(8,1,6,0,'0','0',1,0,''),(9,1,8,0,'0','0',1,0,''),(10,1,26,0,'0','0',1,0,''),(11,1,10,0,'0','0',1,0,''),(12,1,76,0,'0','0',1,0,''),(13,1,125,0,'0','0',1,0,''),(14,1,131,0,'0','0',1,0,''),(15,1,12,0,'0','0',1,0,''),(16,1,143,0,'0','0',1,0,''),(17,1,139,0,'0','0',1,0,''),(18,1,13,0,'0','0',1,0,''),(19,1,2,0,'0','0',1,0,''),(20,1,14,0,'0','0',1,0,''),(21,1,15,0,'0','0',1,0,''),(22,1,36,0,'0','0',1,0,''),(23,1,193,0,'0','0',1,0,''),(24,1,37,0,'0','0',1,0,''),(25,1,7,0,'0','0',1,0,''),(26,1,18,0,'0','0',1,0,''),(27,1,17,0,'0','0',1,0,''),(28,1,74,0,'0','0',1,0,''),(29,2,3,0,'0','0',2,0,''),(30,2,236,0,'0','0',2,0,''),(31,2,16,0,'0','0',2,0,''),(32,2,20,0,'0','0',2,0,''),(33,2,1,0,'0','0',2,0,''),(34,2,86,0,'0','0',2,0,''),(35,2,9,0,'0','0',2,0,''),(36,2,6,0,'0','0',2,0,''),(37,2,8,0,'0','0',2,0,''),(38,2,26,0,'0','0',2,0,''),(39,2,10,0,'0','0',2,0,''),(40,2,76,0,'0','0',2,0,''),(41,2,125,0,'0','0',2,0,''),(42,2,131,0,'0','0',2,0,''),(43,2,12,0,'0','0',2,0,''),(44,2,143,0,'0','0',2,0,''),(45,2,139,0,'0','0',2,0,''),(46,2,13,0,'0','0',2,0,''),(47,2,2,0,'0','0',2,0,''),(48,2,14,0,'0','0',2,0,''),(49,2,15,0,'0','0',2,0,''),(50,2,36,0,'0','0',2,0,''),(51,2,193,0,'0','0',2,0,''),(52,2,37,0,'0','0',2,0,''),(53,2,7,0,'0','0',2,0,''),(54,2,18,0,'0','0',2,0,''),(55,2,17,0,'0','0',2,0,''),(56,2,74,0,'0','0',2,0,''),(57,3,3,0,'0','0',3,0,''),(58,3,236,0,'0','0',3,0,''),(59,3,16,0,'0','0',3,0,''),(60,3,20,0,'0','0',3,0,''),(61,3,1,0,'0','0',3,0,''),(62,3,86,0,'0','0',3,0,''),(63,3,9,0,'0','0',3,0,''),(64,3,6,0,'0','0',3,0,''),(65,3,8,0,'0','0',3,0,''),(66,3,26,0,'0','0',3,0,''),(67,3,10,0,'0','0',3,0,''),(68,3,76,0,'0','0',3,0,''),(69,3,125,0,'0','0',3,0,''),(70,3,131,0,'0','0',3,0,''),(71,3,12,0,'0','0',3,0,''),(72,3,143,0,'0','0',3,0,''),(73,3,139,0,'0','0',3,0,''),(74,3,13,0,'0','0',3,0,''),(75,3,2,0,'0','0',3,0,''),(76,3,14,0,'0','0',3,0,''),(77,3,15,0,'0','0',3,0,''),(78,3,36,0,'0','0',3,0,''),(79,3,193,0,'0','0',3,0,''),(80,3,37,0,'0','0',3,0,''),(81,3,7,0,'0','0',3,0,''),(82,3,18,0,'0','0',3,0,''),(83,3,17,0,'0','0',3,0,''),(84,3,74,0,'0','0',3,0,''),(85,4,3,0,'0','0',3,0,''),(86,4,236,0,'0','0',3,0,''),(87,4,16,0,'0','0',3,0,''),(88,4,20,0,'0','0',3,0,''),(89,4,1,0,'0','0',3,0,''),(90,4,86,0,'0','0',3,0,''),(91,4,9,0,'0','0',3,0,''),(92,4,6,0,'0','0',3,0,''),(93,4,8,0,'0','0',3,0,''),(94,4,26,0,'0','0',3,0,''),(95,4,10,0,'0','0',4,0,''),(96,4,76,0,'0','0',3,0,''),(97,4,125,0,'0','0',3,0,''),(98,4,131,0,'0','0',3,0,''),(99,4,12,0,'0','0',3,0,''),(100,4,143,0,'0','0',3,0,''),(101,4,139,0,'0','0',3,0,''),(102,4,13,0,'0','0',3,0,''),(103,4,2,0,'0','0',3,0,''),(104,4,14,0,'0','0',3,0,''),(105,4,15,0,'0','0',3,0,''),(106,4,36,0,'0','0',3,0,''),(107,4,193,0,'0','0',3,0,''),(108,4,37,0,'0','0',3,0,''),(109,4,7,0,'0','0',3,0,''),(110,4,18,0,'0','0',3,0,''),(111,4,17,0,'0','0',3,0,''),(112,4,74,0,'0','0',3,0,''),(113,5,3,0,'0','0',3,0,''),(114,5,236,0,'0','0',3,0,''),(115,5,16,0,'0','0',3,0,''),(116,5,20,0,'0','0',3,0,''),(117,5,1,0,'0','0',3,0,''),(118,5,86,0,'0','0',3,0,''),(119,5,9,0,'0','0',3,0,''),(120,5,6,0,'0','0',3,0,''),(121,5,8,0,'0','0',3,0,''),(122,5,26,0,'0','0',3,0,''),(124,5,76,0,'0','0',3,0,''),(125,5,125,0,'0','0',3,0,''),(126,5,131,0,'0','0',3,0,''),(127,5,12,0,'0','0',3,0,''),(128,5,143,0,'0','0',3,0,''),(129,5,139,0,'0','0',3,0,''),(130,5,13,0,'0','0',3,0,''),(131,5,2,0,'0','0',3,0,''),(132,5,14,0,'0','0',3,0,''),(133,5,15,0,'0','0',3,0,''),(134,5,36,0,'0','0',3,0,''),(135,5,193,0,'0','0',3,0,''),(136,5,37,0,'0','0',3,0,''),(137,5,7,0,'0','0',3,0,''),(138,5,18,0,'0','0',3,0,''),(139,5,17,0,'0','0',3,0,''),(140,5,74,0,'0','0',3,0,''),(141,6,10,0,'0','0',1,0,''),(142,6,2,0,'0','0',4,0,''),(143,6,3,0,'0','0',5,0,''),(144,6,236,0,'0','0',6,0,''),(145,6,76,0,'0','0',7,0,''),(146,6,16,0,'0','0',8,0,''),(147,6,1,0,'0','0',9,0,''),(148,6,20,0,'0','0',10,0,''),(149,6,86,0,'0','0',11,0,''),(150,6,6,0,'0','0',12,0,''),(151,6,7,0,'0','0',13,0,''),(152,6,8,0,'0','0',14,0,''),(153,6,17,0,'0','0',15,0,''),(154,6,9,0,'0','0',16,0,''),(155,6,74,0,'0','0',17,0,''),(156,6,143,0,'0','0',18,0,''),(157,6,26,0,'0','0',19,0,''),(158,6,131,0,'0','0',20,0,''),(159,6,12,0,'0','0',21,0,''),(160,6,125,0,'0','0',22,0,''),(161,6,139,0,'0','0',23,0,''),(162,6,13,0,'0','0',24,0,''),(163,6,14,0,'0','0',25,0,''),(164,6,15,0,'0','0',26,0,''),(165,6,36,0,'0','0',27,0,''),(166,6,18,0,'0','0',28,0,''),(167,6,193,0,'0','0',29,0,''),(168,6,37,0,'0','0',30,0,''),(169,7,10,0,'0','0',31,0,''),(170,8,10,0,'0','0',32,0,''),(171,9,10,0,'0','0',33,0,''),(172,10,10,0,'0','0',34,0,''),(173,11,10,0,'0','0',35,0,''),(174,12,10,0,'0','0',36,0,''),(175,13,10,0,'0','0',37,0,''),(176,14,10,0,'0','0',38,0,''),(177,15,10,0,'0','0',39,0,''),(178,16,10,0,'0','0',40,0,''),(179,17,10,0,'0','0',41,0,''),(180,18,10,0,'0','0',42,0,''),(181,19,10,0,'0','0',43,0,''),(182,20,10,0,'0','0',44,0,''),(183,21,10,0,'0','0',45,0,''),(184,22,10,0,'0','0',46,0,''),(185,23,10,0,'0','0',47,0,''),(186,24,10,0,'0','0',48,0,''),(187,25,10,0,'0','0',49,0,''),(188,26,10,0,'0','0',50,0,''),(189,27,10,0,'0','0',51,0,''),(190,28,10,0,'0','0',52,0,''),(191,29,10,0,'0','0',53,0,''),(192,30,10,0,'0','0',54,0,''),(193,31,10,0,'0','0',55,0,''),(194,32,10,0,'0','0',56,0,''),(195,33,10,0,'0','0',57,0,''),(196,34,10,0,'0','0',58,0,''),(197,35,10,0,'0','0',59,0,''),(198,36,10,0,'0','0',60,0,''),(199,37,10,0,'0','0',61,0,''),(200,38,10,0,'0','0',62,0,''),(201,39,10,0,'0','0',63,0,''),(202,40,10,0,'0','0',64,0,''),(203,41,10,0,'0','0',65,0,''),(204,42,10,0,'0','0',66,0,''),(205,43,10,0,'0','0',67,0,''),(206,5,10,0,'0','0',68,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=6 DEFAULT CHARSET=utf8;

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

INSERT INTO `ps_tax_rules_group` VALUES (1,'Aliquota ordinaria (22%)',1,0,'2016-02-15 10:48:04','2016-12-28 09:41:05'),(2,'Aliquota ridotta (10%)',1,0,'2016-02-15 10:48:05','2016-12-27 10:52:25'),(3,'Aliquota minima (4%)',1,0,'2016-02-15 10:48:05','2016-12-27 10:52:35'),(4,'Esente IVA Art.74',1,0,'2016-02-15 10:48:05','2016-12-27 10:54:27'),(5,'Articolo 10 comma 8',1,0,'2017-01-31 11:50:36','2017-01-31 11:50:36');

--
-- 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),(4,1),(5,1);

--
-- Table structure for table `ps_theme`
--

CREATE TABLE `ps_theme` (
  `id_theme` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `directory` varchar(64) NOT NULL,
  `responsive` tinyint(1) NOT NULL DEFAULT '0',
  `default_left_column` tinyint(1) NOT NULL DEFAULT '0',
  `default_right_column` tinyint(1) NOT NULL DEFAULT '0',
  `product_per_page` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_theme`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_theme`
--

INSERT INTO `ps_theme` VALUES (1,'default-bootstrap','default-bootstrap',1,1,0,12),(2,'PRS010001','PRS010001',0,1,1,12);

--
-- Table structure for table `ps_theme_meta`
--

CREATE TABLE `ps_theme_meta` (
  `id_theme_meta` int(11) NOT NULL AUTO_INCREMENT,
  `id_theme` int(11) NOT NULL,
  `id_meta` int(10) unsigned NOT NULL,
  `left_column` tinyint(1) NOT NULL DEFAULT '1',
  `right_column` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_theme_meta`),
  UNIQUE KEY `id_theme_2` (`id_theme`,`id_meta`),
  KEY `id_theme` (`id_theme`),
  KEY `id_meta` (`id_meta`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_theme_meta`
--

INSERT INTO `ps_theme_meta` VALUES (1,1,1,0,0),(2,1,2,1,0),(3,1,3,0,0),(4,1,4,0,0),(5,1,5,1,0),(6,1,6,1,0),(7,1,7,0,0),(8,1,8,1,0),(9,1,9,1,0),(10,1,10,0,0),(11,1,11,0,0),(12,1,12,0,0),(13,1,13,0,0),(14,1,14,0,0),(15,1,15,0,0),(16,1,16,0,0),(17,1,17,0,0),(18,1,18,0,0),(19,1,19,0,0),(20,1,20,0,0),(21,1,21,0,0),(22,1,22,1,0),(23,1,23,0,0),(24,1,24,0,0),(25,1,25,0,0),(26,1,26,0,0),(27,1,28,1,0),(28,1,29,0,0),(29,1,27,0,0),(30,1,30,0,0),(31,1,31,0,0),(32,1,32,0,0),(33,1,33,0,0),(34,1,34,0,0),(35,1,36,1,0),(36,1,37,1,0),(37,1,38,1,0),(38,1,39,1,0),(39,2,11,1,1),(40,2,12,1,1),(41,2,13,1,1),(42,2,2,1,1),(43,2,14,1,1),(44,2,28,1,1),(45,2,29,1,1),(46,2,3,1,1),(47,2,15,1,1),(48,2,25,1,1),(49,2,16,1,1),(50,2,17,1,1),(51,2,4,1,1),(52,2,5,1,1),(53,2,33,1,1),(54,2,32,1,1),(55,2,36,1,1),(56,2,37,1,1),(57,2,38,1,1),(58,2,34,1,1),(59,2,30,1,1),(60,2,31,1,1),(61,2,39,1,1),(62,2,18,1,1),(63,2,6,1,1),(64,2,21,1,1),(65,2,26,1,1),(66,2,19,1,1),(67,2,24,1,1),(68,2,20,1,1),(69,2,1,1,1),(70,2,7,1,1),(71,2,8,1,1),(72,2,27,1,1),(73,2,35,1,1),(74,2,22,1,1),(75,2,9,1,1),(76,2,23,1,1),(77,2,10,1,1),(80,1,40,1,0),(81,2,40,1,1);

--
-- Table structure for table `ps_theme_specific`
--

CREATE TABLE `ps_theme_specific` (
  `id_theme` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  `entity` int(11) unsigned NOT NULL,
  `id_object` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_theme`,`id_shop`,`entity`,`id_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_theme_specific`
--


--
-- Table structure for table `ps_themeconfigurator`
--

CREATE TABLE `ps_themeconfigurator` (
  `id_item` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_shop` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `item_order` int(10) unsigned NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `title_use` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `hook` varchar(100) DEFAULT NULL,
  `url` text,
  `target` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `image` varchar(100) DEFAULT NULL,
  `image_w` varchar(10) DEFAULT NULL,
  `image_h` varchar(10) DEFAULT NULL,
  `html` text,
  `active` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_item`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_themeconfigurator`
--

INSERT INTO `ps_themeconfigurator` VALUES (1,1,1,1,'',0,'home','http://www.prestashop.com/',0,'banner-img1.jpg','383','267','',1),(2,1,1,2,'',0,'home','http://www.prestashop.com/',0,'banner-img2.jpg','383','267','',1),(3,1,1,3,'',0,'home','http://www.prestashop.com/',0,'banner-img3.jpg','383','267','',1),(4,1,1,4,'',0,'home','http://www.prestashop.com/',0,'banner-img4.jpg','383','142','',1),(5,1,1,5,'',0,'home','http://www.prestashop.com/',0,'banner-img5.jpg','777','142','',1),(6,1,1,6,'',0,'top','http://www.prestashop.com/',0,'banner-img6.jpg','381','219','',1),(7,1,1,7,'',0,'top','http://www.prestashop.com/',0,'banner-img7.jpg','381','219','',1);

--
-- 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_tmblocklink1`
--

CREATE TABLE `ps_tmblocklink1` (
  `id_tmblocklink1` int(10) NOT NULL AUTO_INCREMENT,
  `new_window` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_tmblocklink1`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tmblocklink1`
--

INSERT INTO `ps_tmblocklink1` VALUES (1,0),(2,0),(3,0),(4,0);

--
-- Table structure for table `ps_tmblocklink1_lang`
--

CREATE TABLE `ps_tmblocklink1_lang` (
  `id_tmblocklink1` int(10) NOT NULL,
  `id_lang` int(10) NOT NULL,
  `text` varchar(62) NOT NULL,
  `url` varchar(254) NOT NULL,
  PRIMARY KEY (`id_tmblocklink1`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tmblocklink1_lang`
--

INSERT INTO `ps_tmblocklink1_lang` VALUES (1,1,'I miei ordini','cronologia-ordini'),(2,1,'Le mie note di credito','buono-ordine'),(3,1,'I miei ordini','indirizzi'),(4,1,'Le mie informazioni personali','identita');

--
-- Table structure for table `ps_tmblocklink1_shop`
--

CREATE TABLE `ps_tmblocklink1_shop` (
  `id_tmblocklink1` int(10) NOT NULL AUTO_INCREMENT,
  `id_shop` int(10) NOT NULL,
  PRIMARY KEY (`id_tmblocklink1`,`id_shop`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tmblocklink1_shop`
--

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

--
-- Table structure for table `ps_tmblocklink2`
--

CREATE TABLE `ps_tmblocklink2` (
  `id_tmblocklink2` int(10) NOT NULL AUTO_INCREMENT,
  `new_window` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_tmblocklink2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tmblocklink2`
--


--
-- Table structure for table `ps_tmblocklink2_lang`
--

CREATE TABLE `ps_tmblocklink2_lang` (
  `id_tmblocklink2` int(10) NOT NULL,
  `id_lang` int(10) NOT NULL,
  `text` varchar(62) NOT NULL,
  `url` varchar(254) NOT NULL,
  PRIMARY KEY (`id_tmblocklink2`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tmblocklink2_lang`
--


--
-- Table structure for table `ps_tmblocklink2_shop`
--

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

--
-- Dumping data for table `ps_tmblocklink2_shop`
--


--
-- Table structure for table `ps_tmhomeslider`
--

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

--
-- Dumping data for table `ps_tmhomeslider`
--

INSERT INTO `ps_tmhomeslider` VALUES (1,1),(2,1),(3,1);

--
-- Table structure for table `ps_tmhomeslider_slides`
--

CREATE TABLE `ps_tmhomeslider_slides` (
  `id_tmhomeslider_slides` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `position` int(10) unsigned NOT NULL DEFAULT '0',
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_tmhomeslider_slides`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tmhomeslider_slides`
--

INSERT INTO `ps_tmhomeslider_slides` VALUES (1,1,0),(2,2,0),(3,0,1);

--
-- Table structure for table `ps_tmhomeslider_slides_lang`
--

CREATE TABLE `ps_tmhomeslider_slides_lang` (
  `id_tmhomeslider_slides` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `legend` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  PRIMARY KEY (`id_tmhomeslider_slides`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tmhomeslider_slides_lang`
--

INSERT INTO `ps_tmhomeslider_slides_lang` VALUES (1,1,'Sample 1','sample-1','http://www.prestashop.com/?utm_source=v16_tmhomeslider','sample-1.jpg'),(2,1,'Sample 2','sample-2','http://www.prestashop.com/?utm_source=v16_tmhomeslider','sample-2.jpg'),(3,1,'Offerta Notebook','#','http://www.desktopstore.it/4-notebook','3047dd40274904872c2d5e4ca6e17cdcecc2c149_bannerok.png');

--
-- 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_wishlist`
--

CREATE TABLE `ps_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 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_wishlist`
--


--
-- Table structure for table `ps_wishlist_email`
--

CREATE TABLE `ps_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_wishlist_email`
--


--
-- Table structure for table `ps_wishlist_product`
--

CREATE TABLE `ps_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 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_wishlist_product`
--


--
-- Table structure for table `ps_wishlist_product_cart`
--

CREATE TABLE `ps_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_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);


