-- MySQL dump 10.11 -- -- Host: localhost Database: taxidi_drupal -- ------------------------------------------------------ -- Server version 5.0.51a-24+lenny2 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `amazon_item` -- DROP TABLE IF EXISTS `amazon_item`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `amazon_item` ( `asin` varchar(64) NOT NULL, `title` varchar(255) NOT NULL, `detailpageurl` text, `salesrank` int(10) unsigned default NULL, `brand` varchar(64) default NULL, `publisher` varchar(64) default NULL, `manufacturer` varchar(64) default NULL, `mpn` varchar(128) default NULL, `studio` varchar(64) default NULL, `label` varchar(64) default NULL, `binding` varchar(64) default NULL, `releasedate` varchar(64) default NULL, `listpriceamount` float unsigned default NULL, `listpricecurrencycode` varchar(32) default NULL, `listpriceformattedprice` varchar(32) default NULL, `productgroup` varchar(255) default NULL, `producttypename` varchar(255) default NULL, `timestamp` int(10) unsigned NOT NULL default '0', `invalid_asin` int(11) default '0', PRIMARY KEY (`asin`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `amazon_item` -- LOCK TABLES `amazon_item` WRITE; /*!40000 ALTER TABLE `amazon_item` DISABLE KEYS */; INSERT INTO `amazon_item` VALUES ('','','',NULL,'','','',NULL,'','','','',NULL,NULL,NULL,'','',1243346283,NULL),('3746660939','Reise um die Welt','http://www.amazon.de/Reise-die-Welt-Adelbert-Chamisso/dp/3746660939%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3746660939',925338,'','Aufbau Tb','Aufbau Tb',NULL,'Aufbau Tb','Aufbau Tb','Taschenbuch','',1000,'EUR','EUR 10,00','Book','ABIS_BOOK',1255412344,NULL),('3770145992','DuMont Kunst Reiseführer Peloponnes','http://www.amazon.de/DuMont-Reisef%C3%BChrer-Peloponnes-Lambert-Schneider/dp/3770145992%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3770145992',255875,'','DuMont Reiseverlag, Ostfildern','DuMont Reiseverlag, Ostfildern',NULL,'DuMont Reiseverlag, Ostfildern','DuMont Reiseverlag, Ostfildern','Taschenbuch','',2590,'EUR','EUR 25,90','Book','ABIS_BOOK',1255412344,NULL),('3899534786','Peloponnes','http://www.amazon.de/Peloponnes-Hans-Peter-Siebenhaar/dp/3899534786%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3899534786',65176,'','Müller (Michael), Erlangen','Müller (Michael), Erlangen',NULL,'Müller (Michael), Erlangen','Müller (Michael), Erlangen','Broschiert','',2490,'EUR','EUR 24,90','Book','ABIS_BOOK',1255412344,NULL),('3899532430','Peloponnes','http://www.amazon.de/Peloponnes-Hans-Peter-Siebenhaar/dp/3899532430%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3899532430',120313,'','Müller (Michael), Erlangen','Müller (Michael), Erlangen',NULL,'Müller (Michael), Erlangen','Müller (Michael), Erlangen','Broschiert','',2290,'EUR','EUR 22,90','Book','ABIS_BOOK',1255412344,NULL),('389953123X','Peloponnes','http://www.amazon.de/Peloponnes-Hans-Peter-Siebenhaar/dp/389953123X%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D389953123X',572888,'','Müller, Michael GmbH','Müller, Michael GmbH',NULL,'Müller, Michael GmbH','Müller, Michael GmbH','Taschenbuch','',2290,'EUR','EUR 22,90','Book','ABIS_BOOK',1255412344,NULL),('3770161793','Stefan Loose Travel Handbücher Laos','http://www.amazon.de/Stefan-Loose-Travel-Handb%C3%BCcher-Laos/dp/3770161793%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3770161793',13210,'','DuMont Reiseverlag, Ostfildern','DuMont Reiseverlag, Ostfildern',NULL,'DuMont Reiseverlag, Ostfildern','DuMont Reiseverlag, Ostfildern','Broschiert','',2395,'EUR','EUR 23,95','Book','ABIS_BOOK',1255412344,NULL),('3770139798','DuMont Kunst Reiseführer Jordanien','http://www.amazon.de/DuMont-Reisef%C3%BChrer-Jordanien-Rainer-Scheck/dp/3770139798%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3770139798',19438,'','DuMont Reiseverlag, Ostfildern','DuMont Reiseverlag, Ostfildern',NULL,'DuMont Reiseverlag, Ostfildern','DuMont Reiseverlag, Ostfildern','Taschenbuch','',2590,'EUR','EUR 25,90','Book','ABIS_BOOK',1255426743,NULL),('377013978X','DuMont Kunst Reiseführer Syrien','http://www.amazon.de/DuMont-Reisef%C3%BChrer-Syrien-Rainer-Scheck/dp/377013978X%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D377013978X',26872,'','DuMont Reiseverlag, Ostfildern','DuMont Reiseverlag, Ostfildern',NULL,'DuMont Reiseverlag, Ostfildern','DuMont Reiseverlag, Ostfildern','Taschenbuch','',2590,'EUR','EUR 25,90','Book','ABIS_BOOK',1255469943,NULL),('1741045754','Best of Hong Kong (Hongkong) Encounter (Lonely Planet Hong Kong Encounter)','http://www.amazon.de/Best-Hongkong-Encounter-Lonely-Planet/dp/1741045754%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D1741045754',92181,'','Lonely Planet Publications','Lonely Planet Publications',NULL,'Lonely Planet Publications','Lonely Planet Publications','Taschenbuch','',872,'EUR','EUR 8,72','Book','ABIS_BOOK',1255477144,NULL),('3829715951','Lonely Planet Reiseführer Vietnam: Deutsche Ausgabe','http://www.amazon.de/Lonely-Planet-Reisef%C3%BChrer-Vietnam-Deutsche/dp/3829715951%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3829715951',12834,'','Lonely Planet','Lonely Planet',NULL,'Lonely Planet','Lonely Planet','Broschiert','',2495,'EUR','EUR 24,95','Book','ABIS_BOOK',1255477144,NULL),('3899301978','Westpommern: Pommersche Seenplatte, Ostseeküste','http://www.amazon.de/Westpommern-Pommersche-Ostseek%C3%BCste-Grazyna-Kling/dp/3899301978%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3899301978',563239,'','Schiler Verlag','Schiler Verlag',NULL,'Schiler Verlag','Schiler Verlag','Broschiert','',1480,'EUR','EUR 14,80','Book','ABIS_BOOK',1255477144,NULL),('3829711212','Baedeker Allianz Reiseführer Zypern','http://www.amazon.de/Baedeker-Allianz-Reisef%C3%BChrer-Zypern-Redaktion/dp/3829711212%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3829711212',112855,'','BAEDEKER KARL Verlag, Ostfildern','BAEDEKER KARL Verlag, Ostfildern',NULL,'BAEDEKER KARL Verlag, Ostfildern','BAEDEKER KARL Verlag, Ostfildern','Broschiert','',1995,'EUR','EUR 19,95','Book','ABIS_BOOK',1255477144,NULL),('3770160304','DuMont Kunst Reiseführer Zypern','http://www.amazon.de/DuMont-Reisef%C3%BChrer-Zypern-Andreas-Schneider/dp/3770160304%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3770160304',309526,'','DuMont Reiseverlag, Ostfildern','DuMont Reiseverlag, Ostfildern',NULL,'DuMont Reiseverlag, Ostfildern','DuMont Reiseverlag, Ostfildern','Taschenbuch','',2590,'EUR','EUR 25,90','Book','ABIS_BOOK',1255477144,NULL),('3899532007','Zypern. Das umfassende Reisehandbuch zu Zypern, der Aphrodite-Insel','http://www.amazon.de/Zypern-umfassende-Reisehandbuch-Zypern-Aphrodite-Insel/dp/3899532007%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3899532007',318029,'','Müller (Michael), Erlangen','Müller (Michael), Erlangen',NULL,'Müller (Michael), Erlangen','Müller (Michael), Erlangen','Taschenbuch','',1890,'EUR','EUR 18,90','Book','ABIS_BOOK',1255477144,NULL),('3831715092','Tokyo mit Kyoto und Yokohama: Handbuch für die Hauptstadt Japans, für die Umgebung mit Yokohama und für die alte Tempelstadt Kyoto','http://www.amazon.de/Tokyo-mit-Kyoto-Yokohama-Tempelstadt/dp/3831715092%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3831715092',62407,'','Reise Know-How Verlag Rump','Reise Know-How Verlag Rump',NULL,'Reise Know-How Verlag Rump','Reise Know-How Verlag Rump','Broschiert','',2250,'EUR','EUR 22,50','Book','ABIS_BOOK',1255477144,NULL),('3923975821','Reisegast in Japan','http://www.amazon.de/Reisegast-Japan-Kristina-Thomas/dp/3923975821%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3923975821',180446,'','Iwanowski\'s Reisebuchverlag','Iwanowski\'s Reisebuchverlag',NULL,'Iwanowski\'s Reisebuchverlag','Iwanowski\'s Reisebuchverlag','Taschenbuch','',1795,'EUR','EUR 17,95','Book','ABIS_BOOK',1255477144,NULL),('389953252X','Elsass. 15 Wanderungen und Touren','http://www.amazon.de/Elsass-Wanderungen-Touren-Antje-Schwab/dp/389953252X%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D389953252X',305031,'','Müller (Michael), Erlangen','Müller (Michael), Erlangen',NULL,'Müller (Michael), Erlangen','Müller (Michael), Erlangen','Broschiert','',1990,'EUR','EUR 19,90','Book','ABIS_BOOK',1255477144,NULL),('3760840884','Reisen in Griechenland, 3 Bde., Bd.1, Athen: BD 1','http://www.amazon.de/Reisen-Griechenland-Bde-Bd-1-Athen/dp/3760840884%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3760840884',669288,'','Artemis & Winkler','Artemis & Winkler',NULL,'Artemis & Winkler','Artemis & Winkler','Gebundene Ausgabe','',2490,'EUR','EUR 24,90','Book','ABIS_BOOK',1255477144,NULL),('3760840892','Reisen in Griechenland, 3 Bde., Bd.3, Delphoi: BD 3','http://www.amazon.de/Reisen-Griechenland-Bde-Bd-3-Delphoi/dp/3760840892%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3760840892',774149,'','Artemis & Winkler','Artemis & Winkler',NULL,'Artemis & Winkler','Artemis & Winkler','Taschenbuch','',2490,'EUR','EUR 24,90','Book','ABIS_BOOK',1255477144,NULL),('3760840906','Reisen in Griechenland, 3 Bde., Bd.2, Olympia: BD 2','http://www.amazon.de/Reisen-Griechenland-Bde-Bd-2-Olympia/dp/3760840906%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3760840906',735627,'','Artemis & Winkler','Artemis & Winkler',NULL,'Artemis & Winkler','Artemis & Winkler','Gebundene Ausgabe','',2490,'EUR','EUR 24,90','Book','ABIS_BOOK',1255477144,NULL),('398088290X','Vietnam - Ein Land im Aufbruch','http://www.amazon.de/Vietnam-Ein-Land-im-Aufbruch/dp/398088290X%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D398088290X',33758,'','Turtle-Media Home Entertainment','Turtle-Media Home Entertainment',NULL,'Turtle-Media Home Entertainment','Turtle-Media Home Entertainment','DVD','2003-03-28',1995,'EUR','EUR 19,95','DVD','ABIS_DVD',1255477144,NULL),('3899531175','Lesbos','http://www.amazon.de/Lesbos-Thomas-Schr%C3%B6der/dp/3899531175%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3899531175',539229,'','Müller, Michael GmbH','Müller, Michael GmbH',NULL,'Müller, Michael GmbH','Müller, Michael GmbH','Taschenbuch','',1590,'EUR','EUR 15,90','Book','ABIS_BOOK',1255477144,NULL),('3831712956','KulturSchock Polen','http://www.amazon.de/KulturSchock-Polen-Izabella-Gawin/dp/3831712956%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3831712956',334296,'','Reise Know-How Verlag Rump','Reise Know-How Verlag Rump',NULL,'Reise Know-How Verlag Rump','Reise Know-How Verlag Rump','Taschenbuch','',1490,'EUR','EUR 14,90','Book','ABIS_BOOK',1255477144,NULL),('B000EHTNDO','Laos - Aufbruch im Land am Mekong','http://www.amazon.de/Laos-Aufbruch-Mekong-Ute-Werner/dp/B000EHTNDO%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000EHTNDO',81618,'','Bavarian Video','Bavarian Video',NULL,'Bavarian Video','Bavarian Video','DVD','2006-02-09',NULL,NULL,NULL,'DVD','ABIS_DVD',1255477144,NULL),('3932546253','Masuren per Rad. 67 Streckenvorschläge (Cyklos-Fahrrad-Reiseführer)','http://www.amazon.de/Masuren-per-Rad-Streckenvorschl%C3%A4ge-Cyklos-Fahrrad-Reisef%C3%BChrer/dp/3932546253%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3932546253',333302,'','Kettler, Neuenhagen','Kettler, Neuenhagen',NULL,'Kettler, Neuenhagen','Kettler, Neuenhagen','Taschenbuch','',1480,'EUR','EUR 14,80','Book','ABIS_BOOK',1255477144,NULL),('3829715595','Lonely Planet Reiseführer Polen','http://www.amazon.de/Lonely-Planet-Reisef%C3%BChrer-Polen-Wilson/dp/3829715595%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3829715595',32337,'','Lonely Planet','Lonely Planet',NULL,'Lonely Planet','Lonely Planet','Broschiert','',2295,'EUR','EUR 22,95','Book','ABIS_BOOK',1255477144,NULL),('3770161025','Stefan Loose Travel Handbücher Bali - Lombok','http://www.amazon.de/Stefan-Loose-Travel-Handb%C3%BCcher-Bali/dp/3770161025%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3770161025',103347,'','DuMont Reiseverlag, Ostfildern','DuMont Reiseverlag, Ostfildern',NULL,'DuMont Reiseverlag, Ostfildern','DuMont Reiseverlag, Ostfildern','Taschenbuch','',1595,'EUR','EUR 15,95','Book','ABIS_BOOK',1255477144,NULL),('3899533194','Polnische Ostseeküste','http://www.amazon.de/Polnische-Ostseek%C3%BCste-Isabella-Schinzel/dp/3899533194%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3899533194',214112,'','Müller (Michael), Erlangen','Müller (Michael), Erlangen',NULL,'Müller (Michael), Erlangen','Müller (Michael), Erlangen','Broschiert','',1590,'EUR','EUR 15,90','Book','ABIS_BOOK',1255480744,NULL),('3866901186','400 Reisen, die Sie nie vergessen werden: Vom Amazonas bis ins Zululand','http://www.amazon.de/400-Reisen-die-vergessen-werden/dp/3866901186%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3866901186',182108,'','NATIONAL GEOGRAPHIC Deutschland','NATIONAL GEOGRAPHIC Deutschland',NULL,'NATIONAL GEOGRAPHIC Deutschland','NATIONAL GEOGRAPHIC Deutschland','Gebundene Ausgabe','',3995,'EUR','EUR 39,95','Book','ABIS_BOOK',1255513145,NULL),('3570198685','Geo Special : Neuseeland: 5/2009','http://www.amazon.de/Geo-Special-Neuseeland-5-2009/dp/3570198685%3FSubscriptionId%3DAKIAIQGLIPXGXFGOLL5A%26tag%3Dtaxidi-21%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D3570198685',89192,'','Mairdumont','Mairdumont',NULL,'Mairdumont','Mairdumont','Broschiert','',800,'EUR','EUR 8,00','Book','ABIS_BOOK',1255826343,NULL); /*!40000 ALTER TABLE `amazon_item` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2009-10-18 21:07:42