-- MySQL dump 10.16  Distrib 10.1.6-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: part-db
-- ------------------------------------------------------
-- Server version	10.1.6-MariaDB-log

/*!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 `attachement_types`
--

DROP TABLE IF EXISTS `attachement_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attachement_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `attachement_types_parent_id_k` (`parent_id`),
  CONSTRAINT `attachement_types_parent_id_fk` FOREIGN KEY (`parent_id`) REFERENCES `attachement_types` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attachement_types`
--

LOCK TABLES `attachement_types` WRITE;
/*!40000 ALTER TABLE `attachement_types` DISABLE KEYS */;
INSERT INTO `attachement_types` VALUES (1,'Bilder',NULL),(2,'Datenblätter',NULL);
/*!40000 ALTER TABLE `attachement_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `attachements`
--

DROP TABLE IF EXISTS `attachements`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attachements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `class_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `element_id` int(11) NOT NULL,
  `type_id` int(11) NOT NULL,
  `filename` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `show_in_table` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `attachements_class_name_k` (`class_name`),
  KEY `attachements_element_id_k` (`element_id`),
  KEY `attachements_type_id_fk` (`type_id`),
  CONSTRAINT `attachements_type_id_fk` FOREIGN KEY (`type_id`) REFERENCES `attachement_types` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attachements`
--

LOCK TABLES `attachements` WRITE;
/*!40000 ALTER TABLE `attachements` DISABLE KEYS */;
INSERT INTO `attachements` VALUES (1,'Datenblatt','Part',136,2,'http://ww1.microchip.com/downloads/en/devicedoc/39662a.pdf',1),(2,'Datenblatt','Part',199,2,'http://kitsrus.com/projects/tda7052.pdf',1),(3,'Datenblatt','Part',185,2,'http://www.produktinfo.conrad.com/datenblaetter/125000-149999/147028-da-01-en-LD1117V33_Spannungswandler_Datenbaltt.pdf',1),(4,'Datenblatt','Part',200,2,'http://www.biltek.tubitak.gov.tr/gelisim/elektronik/dosyalar/6/LM386.pdf',1),(5,'Datenblatt','Part',261,2,'https://www.distrelec.ch/ishop/Datasheets/ivAVAGO-4N25_data_e.pdf',1),(6,'Datenblatt','Part',258,2,'https://www.distrelec.ch/ishop/Datasheets/ogMOC305xM_data_e.pdf',1),(7,'Datenblatt','Part',128,2,'http://www.nxp.com/documents/data_sheet/BT138_SERIES.pdf',1),(8,'Datenblatt','Part',265,2,'https://www.distrelec.ch/ishop/Datasheets/ahTSR1_data_de.pdf',1),(9,'Datenblatt','Part',218,2,'http://www.produktinfo.conrad.com/datenblaetter/175000-199999/181670-da-01-en-LCD_MODUL_STN_POSITIV_LED_WEISS_16X4.pdf',1),(10,'Datenblatt','Part',319,2,'javascript:picV(\'video\',%20800,%20480,%20\'/ishop/Datasheets/07004542.pdf\');',1),(11,'Datenblatt','Part',294,2,'http://www.conrad.ch/goto.php?artikel=163071',1),(12,'Datenblatt','Part',508,2,'http://www.us.kingbright.com/images/catalog/SPEC/SA10-21EWA.pdf',1),(13,'Datenblatt','Part',505,2,'http://www.produktinfo.conrad.com/datenblaetter/150000-174999/160032-da-01-en-7_SEGMENTANZEIGE_25MM_A.pdf',1);
/*!40000 ALTER TABLE `attachements` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `disable_footprints` tinyint(1) NOT NULL DEFAULT '0',
  `disable_manufacturers` tinyint(1) NOT NULL DEFAULT '0',
  `disable_autodatasheets` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `categories_parent_id_k` (`parent_id`),
  CONSTRAINT `categories_parent_id_fk` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `categories`
--

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` VALUES (1,'Aktive Bauelemente',NULL,0,0,0),(2,'Passive Bauelemente',NULL,0,0,0),(3,'Schalter / Taster',NULL,0,0,0),(4,'Steck- / Schraubverbinder',NULL,0,0,0),(5,'Widerstände',2,0,0,0),(6,'SMD 0,26 - 2W',5,0,0,0),(7,'Dioden',1,0,0,0),(8,'Transistoren Bipolar',1,0,0,0),(9,'ICs',1,0,0,0),(10,'Mikrocontroller',1,0,0,0),(11,'Quarze und Resonatoren',1,0,0,0),(12,'Kondensatoren',2,0,0,0),(13,'Elektrolytkondensatoren',12,0,0,0),(14,'MKS Folienkondensatoren',12,0,0,0),(15,'Keramikkondensatoren',12,0,0,0),(16,'Potentiometer',2,0,0,0),(17,'Spulen / Drosseln',2,0,0,0),(18,'Platinensteck- /schraubverbinder',4,0,0,0),(19,'Schraubklemmen',18,0,0,0),(20,'Buchsenleisten',18,0,0,0),(21,'Stiftleisten',18,0,0,0),(22,'Print-Taster',3,0,0,0),(23,'Print-Schiebeschalter',3,0,0,0),(24,'Print-Codierschalter',3,0,0,0),(25,'Print-Druckschalter',3,0,0,0),(26,'Print-Kippschalter/-taster',3,0,0,0),(27,'USB',18,0,0,0),(28,'Power-Jacks',18,0,0,0),(29,'Audio-Steckverbinder',18,0,0,0),(30,'Elektromechanische Bauteile',NULL,0,0,0),(31,'Sicherungen',30,0,0,0),(32,'Sicherungshalter Printmontage',31,0,0,0),(33,'Jumper',30,0,0,0),(34,'Leiterplatten und Zubehör',30,0,0,0),(35,'Leiterplattenbefestigungen',34,0,0,0),(36,'Molex THT',18,0,0,0),(37,'USB-Stecker / Buchsen',4,0,0,0),(38,'Sub-D Stecker / Buchsen',4,0,0,0),(39,'Gehäuse + Zubehör',30,0,0,0),(40,'Steckergehäuse',39,0,0,0),(41,'Handgehäuse',39,0,0,0),(42,'Standard-Dioden',7,0,0,0),(43,'Zener-Dioden',7,0,0,0),(44,'Schottky-Dioden',7,0,0,0),(45,'Optoelektronische Bauteile',NULL,0,0,0),(46,'LEDs',45,0,0,0),(47,'3mm',46,0,0,0),(48,'5mm',46,0,0,0),(49,'Zubehör',46,0,0,0),(50,'SMD',46,0,0,0),(51,'Stromversorgung',1,0,0,0),(52,'Festspannungsregler 78xx',51,0,0,0),(53,'Einstellbare Spannungsregler',51,0,0,0),(54,'Platinen',34,0,0,0),(55,'IC-Sockel',30,0,0,0),(56,'Audio-Steckverbinder',4,0,0,0),(57,'Sub-D Printstecker/-buchsen',18,0,0,0),(58,'Schneidklemm-Buchsen',4,0,0,0),(59,'Optokoppler / Optotriac',45,0,0,0),(60,'Relais',30,0,0,0),(61,'Batteriehalter',30,0,0,0),(62,'SMD <= 0,25W',5,0,0,0),(63,'Gleichrichter',1,0,0,0),(64,'SMD > 2W',5,0,0,0),(65,'IR-Empfänger',45,0,0,0),(66,'Werkstatt / Verbrauchsmaterial',NULL,0,0,0),(67,'Ethernet',18,0,0,0),(68,'LDO-Spannungsregler',51,0,0,0),(69,'Steckernetzteile',30,0,0,0),(70,'Lautsprecher und Signalgeber',30,0,0,0),(71,'Anzeigen und Zubehör',45,0,0,0),(72,'Zubehör',71,0,0,0),(73,'LCDs',71,0,0,0),(74,'PC-Peripherie',9,0,0,0),(75,'Digitale Potentiometer',9,0,0,0),(76,'Leistungsverstärker',9,0,0,0),(77,'I2C-Bausteine',9,0,0,0),(78,'Knäpfe und Knüppel',30,0,0,0),(79,'Inkrementalgeber',3,0,0,0),(81,'Fotowiderstände/Transistoren',45,0,0,0),(82,'10mm',46,0,0,0),(83,'Kartenslots',30,0,0,0),(84,'Batterieklemmen',4,0,0,0),(85,'Decoder/Encoder',9,0,0,0),(86,'8mm',46,0,0,0),(87,'Bipolarkondensatoren',12,0,0,0),(88,'Diac / Triac',9,0,0,0),(89,'Mosfet / Hexfet',9,0,0,0),(90,'Kabeldurchführungen',30,0,0,0),(91,'Schaltregler',51,0,0,0),(92,'Netzteile und Trafos',51,0,0,0),(93,'MKP Folienkondensatoren',12,0,0,0),(95,'Gehäusezubehör',39,0,0,0),(96,'Distanzbolzen',30,0,0,0),(97,'Tischgehäuse',39,0,0,0),(98,'Spezialwiderstände',5,0,0,0),(99,'Motorsteuer-ICs',9,0,0,0),(100,'Sonstige',9,0,0,0),(101,'Motoren',30,0,0,0),(102,'Transformatoren',2,0,0,0),(103,'SD-Kartenslots',18,0,0,0),(104,'Kühlkörper und Lüfter',30,0,0,0),(105,'Schutzdioden',7,0,0,0),(106,'Operationsverstärker',9,0,0,0),(107,'Vielschichtkondensatoren',12,0,0,0),(108,'Lampen und Fassungen',45,0,0,0),(109,'Kabel',30,0,0,0),(110,'Sonstiges',34,0,0,0),(111,'Bedrahtet <= 0,25W',5,0,0,0),(112,'Bedrahtet 0,26 - 2W',5,0,0,0),(113,'Bedrahtet > 2W',5,0,0,0),(114,'Sonstiges',2,0,0,0),(115,'Tantal-Kondensatoren',12,0,0,0),(116,'Molex SMD',18,0,0,0),(117,'Geräte / Bausteine / Bausätze',NULL,0,0,0),(118,'Bestellte Platinen',34,0,0,0),(119,'SMD Dioden',7,0,0,0),(120,'Chemikalien / Sprays',66,0,0,0),(121,'Lötzubehör',66,0,0,0),(122,'CNC-Zubehör',66,0,0,0),(123,'Schrumpfschlauch',66,0,0,0),(124,'Sonstige Sicherungshalter',31,0,0,0),(125,'Experimentiersysteme',66,0,0,0),(126,'Litzen',66,0,0,0),(127,'Werkstattausstattung',66,0,0,0),(128,'7-Segment',71,0,0,0),(129,'Miniaturtaster mit Hebel',3,0,0,0),(130,'Kaltgerätebuchsen/-stecker',4,0,0,0),(131,'Laborbuchsen/-stecker',4,0,0,0),(132,'Quetschverbinder',4,0,0,0),(133,'Wippschalter',3,0,0,0);
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `device_parts`
--

DROP TABLE IF EXISTS `device_parts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `device_parts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_part` int(11) NOT NULL DEFAULT '0',
  `id_device` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `mountnames` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `device_parts_combination_uk` (`id_part`,`id_device`),
  KEY `device_parts_id_part_k` (`id_part`),
  KEY `device_parts_id_device_k` (`id_device`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `device_parts`
--

LOCK TABLES `device_parts` WRITE;
/*!40000 ALTER TABLE `device_parts` DISABLE KEYS */;
INSERT INTO `device_parts` VALUES (1,10,26,2,','),(2,14,24,3,''),(3,14,27,2,','),(4,24,28,2,','),(5,142,24,1,''),(6,184,29,1,''),(7,314,1,3,'C11,C16,C18'),(8,314,22,3,'C11,C16,C18'),(9,323,25,1,''),(10,347,1,6,'T1,T2,T3,T4,T5,T6'),(11,347,22,6,'T1,T2,T3,T4,T5,T6'),(12,348,1,3,'D1,D2,D3'),(13,348,22,3,'D1,D2,D3'),(14,357,1,1,'LED2'),(15,357,22,1,'LED2'),(16,358,1,1,'LED1'),(17,358,22,1,'LED1'),(18,367,1,1,'R1'),(19,367,22,1,'R1'),(20,367,29,1,''),(21,368,1,4,'R20,R4,R11,R32'),(22,368,22,3,'R20,R4,R11'),(23,368,25,2,''),(24,368,29,2,''),(25,370,1,1,'C21'),(26,379,1,1,'IC3'),(27,379,22,1,'IC3'),(28,381,1,1,'IC2'),(29,381,22,1,'IC2'),(30,382,1,3,'U1,U2,U3'),(31,382,22,3,'U1,U2,U3'),(32,388,1,14,'C8,C5,C9,C4,C3,C2,C20,C12,C13,C14,C15,C19,C17,C1'),(33,388,22,13,'C8,C5,C9,C4,C3,C2,C20,C12,C13,C14,C19,C17,C1'),(34,388,25,2,''),(35,388,29,8,''),(36,397,24,9,''),(37,407,1,1,'Q2'),(38,407,22,1,'Q2'),(39,420,1,1,'R18'),(40,427,1,3,'R4,R6,R7'),(41,427,22,3,'R4,R6,R7'),(42,437,1,1,'C10'),(43,437,22,1,'C10'),(44,438,1,1,'R31'),(45,439,1,1,'I2C/UART'),(46,442,1,1,'ISP'),(47,446,1,1,'PPM'),(48,454,1,1,'OK1'),(49,455,1,1,'C7'),(50,455,22,1,'C7'),(51,458,1,1,'D4'),(52,459,1,1,'R2'),(53,459,22,1,'R2'),(54,460,1,4,'R19,R28,R25,R26'),(55,460,22,4,'R19,R28,R25,R26'),(56,461,1,1,'R24'),(57,465,1,3,'R3,R12,R13'),(58,465,22,3,'R3,R12,R13'),(59,466,1,3,'R8,R9,R10'),(60,466,22,3,'R8,R9,R10'),(61,467,1,1,'R27'),(62,468,1,1,'R21'),(63,468,22,1,'R21'),(64,469,1,1,'C6'),(65,470,1,6,'R14,R15,R16,R17,R22,R23'),(66,470,22,6,'R14,R15,R16,R17,R22,R23'),(67,471,1,1,''),(68,471,22,1,''),(69,472,1,1,'R29'),(70,472,22,1,'R29'),(71,473,1,1,'R30'),(72,473,22,1,'R30'),(73,476,25,1,''),(74,476,29,4,',,,'),(75,477,29,1,''),(76,478,29,1,''),(77,479,25,1,''),(78,479,29,1,''),(79,480,25,1,''),(80,481,27,1,''),(81,482,29,1,''),(82,484,28,1,''),(83,485,26,1,''),(84,486,25,3,''),(85,487,25,3,''),(86,488,29,4,''),(87,489,29,1,''),(88,490,29,1,''),(89,491,29,2,''),(90,492,29,2,''),(91,493,29,1,''),(92,494,29,1,''),(93,495,29,1,'');
/*!40000 ALTER TABLE `device_parts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `devices`
--

DROP TABLE IF EXISTS `devices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `devices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `order_quantity` int(11) NOT NULL DEFAULT '0',
  `order_only_missing_parts` tinyint(1) NOT NULL DEFAULT '0',
  `datetime_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `devices_parent_id_k` (`parent_id`),
  CONSTRAINT `devices_parent_id_fk` FOREIGN KEY (`parent_id`) REFERENCES `devices` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `devices`
--

LOCK TABLES `devices` WRITE;
/*!40000 ALTER TABLE `devices` DISABLE KEYS */;
INSERT INTO `devices` VALUES (1,'Vollbestückung',40,0,0,'2016-03-29 15:45:55'),(22,'Minimalbestückung',40,0,0,'2016-03-29 15:45:55'),(24,'MotionControl to LPT Adapter v1',NULL,0,0,'2016-03-29 15:45:55'),(25,'Micro-SD-2-DIL Adapter v1',NULL,0,0,'2016-03-29 15:45:55'),(26,'PowerJack-2-DIL Adapter v1',NULL,0,0,'2016-03-29 15:45:55'),(27,'SPI-2-DIL Adapter v1',NULL,0,0,'2016-03-29 15:45:55'),(28,'UART-2-DIL Adapter v1',NULL,0,0,'2016-03-29 15:45:55'),(29,'ENC28J60-Modul v2',NULL,0,0,'2016-03-29 15:45:55'),(39,'Brushless-Regler',NULL,0,0,'2016-03-29 15:45:55'),(40,'v14',39,0,0,'2016-03-29 15:45:55');
/*!40000 ALTER TABLE `devices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `footprints`
--

DROP TABLE IF EXISTS `footprints`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `footprints` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `filename` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `footprints_parent_id_k` (`parent_id`),
  CONSTRAINT `footprints_parent_id_fk` FOREIGN KEY (`parent_id`) REFERENCES `footprints` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `footprints`
--

LOCK TABLES `footprints` WRITE;
/*!40000 ALTER TABLE `footprints` DISABLE KEYS */;
INSERT INTO `footprints` VALUES (1,'Sonstige','',NULL),(2,'DIP4','%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP04.png',92),(3,'DIP6','%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP06.png',92),(4,'DIP8','%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP08.png',92),(5,'DIP10','',92),(6,'DIP12','',92),(7,'DIP14','%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP14.png',92),(8,'DIP16','%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP16.png',92),(9,'DIP18','%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP18.png',92),(10,'DIP20','%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP20.png',92),(11,'DIP24','%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP24.png',92),(12,'DIP28','%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP28.png',92),(13,'DIP40','%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP40W.png',92),(18,'RES-0207','',NULL),(19,'DIP22','%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP22.png',92),(20,'MULTIWATT15','%BASE%/img/footprints/Aktiv/ICs/IC_MULTIWATT15.png',NULL),(21,'SO20','%BASE%/img/footprints/Aktiv/ICs/SO/SO/IC_SO20W.png',NULL),(22,'RES-0805','%BASE%/img/footprints/Passiv/Widerstaende/SMD/WIDERSTAND-SMD_0805.png',NULL),(24,'PT10','%BASE%/img/footprints/Passiv/Widerstaende/Trimmer/TRIMMER_PT10-H.png',NULL),(25,'DIP32','%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP32-3.png',92),(28,'TO220-3','%BASE%/img/footprints/Aktiv/ICs/TO/IC_TO220.png',NULL),(29,'TO92','%BASE%/img/footprints/Aktiv/ICs/TO/IC_TO92.png',NULL),(30,'SSOP28','%BASE%/img/footprints/Aktiv/ICs/SO/SOP/SSOP/IC_SSOP28.png',NULL),(31,'DO35','%BASE%/img/footprints/Aktiv/Dioden/Bedrahtet/DIODE_DO35.png',NULL),(34,'PV32','',NULL),(35,'DIP48','%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP48W.png',92),(36,'HC49U','%BASE%/img/footprints/Aktiv/Oszillatoren/Quarze_bedrahtet/QUARZ_HC49-4H.png',NULL),(37,'HC49S','',NULL),(38,'SMD','',NULL),(39,'SOIC28','',NULL),(40,'SSOP16','%BASE%/img/footprints/Aktiv/ICs/SO/SOP/SSOP/IC_SSOP16.png',NULL),(41,'SO28','%BASE%/img/footprints/Aktiv/ICs/SO/SO/IC_SO28W.png',NULL),(42,'DPAK','',NULL),(43,'SO24','',NULL),(44,'RES-1206','%BASE%/img/footprints/Passiv/Widerstaende/SMD/WIDERSTAND-SMD_1206.png',NULL),(45,'RES-2512','%BASE%/img/footprints/Passiv/Widerstaende/SMD/WIDERSTAND-SMD_2512.png',NULL),(46,'SOIC8','%BASE%/img/footprints/Aktiv/ICs/SO/SO/IC_SO08.png',NULL),(47,'SOT23','%BASE%/img/footprints/Aktiv/ICs/SO/SOT/IC_SOT23.png',NULL),(48,'SOT89','',NULL),(50,'RES-0603','%BASE%/img/footprints/Passiv/Widerstaende/SMD/WIDERSTAND-SMD_0603.png',NULL),(51,'TO218','%BASE%/img/footprints/Aktiv/ICs/TO/IC_TO218.png',NULL),(52,'RES-0414','',NULL),(53,'RES-7343','',NULL),(54,'KEMET-B','',NULL),(55,'RM1.25mm','',NULL),(56,'DO214AA','%BASE%/img/footprints/Aktiv/Dioden/SMD/DIODE_DO214AA.png',NULL),(57,'DO15','%BASE%/img/footprints/Aktiv/Dioden/Bedrahtet/DIODE_DO15.png',NULL),(58,'RM5.08mm','',NULL),(59,'RM2.54mm','',NULL),(61,'DO201','%BASE%/img/footprints/Aktiv/Dioden/Bedrahtet/DIODE_DO201.png',NULL),(62,'THT','',NULL),(63,'DO214AC','%BASE%/img/footprints/Aktiv/Dioden/SMD/DIODE_DO214AC.png',NULL),(64,'DO41','%BASE%/img/footprints/Aktiv/Dioden/Bedrahtet/DIODE_DO41.png',NULL),(65,'QUAD28.6','',NULL),(66,'RB1A','%BASE%/img/footprints/Aktiv/Gleichrichter/GLEICHRICHTER_RB1A.png',NULL),(67,'MULTIWATT11','',NULL),(68,'TO218-5','',NULL),(69,'TQFP32','%BASE%/img/footprints/Aktiv/ICs/QFP/TQFP/IC_TQFP32.png',NULL),(70,'CAP-0805','%BASE%/img/footprints/Passiv/Kondensatoren/Keramik/SMD/KERKO-SMD_0805.png',NULL),(71,'CAP-0603','%BASE%/img/footprints/Passiv/Kondensatoren/Keramik/SMD/KERKO-SMD_0603.png',NULL),(72,'RM7.5mm','',NULL),(73,'DSUB-F25','%BASE%/img/footprints/Elektromechanik/Verbinder/Sub-D/Weiblich_Platinenmontage/SUB-D-PLATINENMONTAGE_W-25.png',NULL),(74,'DSUB-F9','%BASE%/img/footprints/Elektromechanik/Verbinder/Sub-D/Weiblich_Platinenmontage/SUB-D-PLATINENMONTAGE_W-09.png',NULL),(75,'DSUB-M9','%BASE%/img/footprints/Elektromechanik/Verbinder/Sub-D/Maennlich_Platinenmontage/SUB-D-PLATINENMONTAGE_M-09.png',NULL),(76,'DSUB-M25','%BASE%/img/footprints/Elektromechanik/Verbinder/Sub-D/Maennlich_Platinenmontage/SUB-D-PLATINENMONTAGE_M-25.png',NULL),(77,'WS10G','%BASE%/img/footprints/Elektromechanik/Verbinder/Stiftleisten/2-Reihig_mit_Rahmen_gerade/STIFTLEISTE-GERADE-RAHMEN_2X05.png',NULL),(78,'WS6G','%BASE%/img/footprints/Elektromechanik/Verbinder/Stiftleisten/2-Reihig_mit_Rahmen_gerade/STIFTLEISTE-GERADE-RAHMEN_2X03.png',NULL),(79,'WS10W','%BASE%/img/footprints/Elektromechanik/Verbinder/Stiftleisten/2-Reihig_mit_Rahmen_abgewinkelt/STIFTLEISTE-ABGEWINKELT-RAHMEN_2X05.png',NULL),(80,'WS16W','%BASE%/img/footprints/Elektromechanik/Verbinder/Stiftleisten/2-Reihig_mit_Rahmen_abgewinkelt/STIFTLEISTE-ABGEWINKELT-RAHMEN_2X08.png',NULL),(81,'WS16G','%BASE%/img/footprints/Elektromechanik/Verbinder/Stiftleisten/2-Reihig_mit_Rahmen_gerade/STIFTLEISTE-GERADE-RAHMEN_2X08.png',NULL),(82,'SO4','',NULL),(83,'SOT223','%BASE%/img/footprints/Aktiv/ICs/SO/SOT/IC_SOT223.png',NULL),(84,'KEMET-A','',NULL),(85,'SOD80','%BASE%/img/footprints/Aktiv/Dioden/SMD/DIODE_SOD80.png',NULL),(86,'KEMET-C','',NULL),(87,'RM3.5mm','',NULL),(88,'RM1.5mm','',NULL),(89,'Lötanschluss','',NULL),(90,'LED-3','%BASE%/img/footprints/Optik/LEDs/Bedrahtet/LED-ROT_3MM.png',NULL),(91,'LED-5','%BASE%/img/footprints/Optik/LEDs/Bedrahtet/LED-ROT_5MM.png',NULL),(92,'DIP','',NULL),(93,'Taster','',NULL),(94,'LSH50','%BASE%/img/footprints/Elektromechanik/Schalter_Taster/Drucktaster/TASTER_LSH50.png',93),(95,'CAP-0605','',NULL),(96,'CAP-0405','',NULL),(97,'MOLEX-PSL2G','%BASE%/img/footprints/Elektromechanik/Verbinder/Stiftleisten/Molex/PSL_gerade/STIFTLEISTE-MOLEX-GERADE_PSL-02.png',NULL),(98,'MOLEX-PSL3G','%BASE%/img/footprints/Elektromechanik/Verbinder/Stiftleisten/Molex/PSL_gerade/STIFTLEISTE-MOLEX-GERADE_PSL-03.png',NULL),(99,'MOLEX-PSL4G','%BASE%/img/footprints/Elektromechanik/Verbinder/Stiftleisten/Molex/PSL_gerade/STIFTLEISTE-MOLEX-GERADE_PSL-04.png',NULL),(100,'BL1X5','%BASE%/img/footprints/Elektromechanik/Verbinder/Buchsenleisten/1-Reihig_gerade/BUCHSENLEISTE-GERADE_1X05.png',NULL),(101,'BLW1X5','%BASE%/img/footprints/Elektromechanik/Verbinder/Buchsenleisten/1-Reihig_abgewinkelt/BUCHSENLEISTE-ABGEWINKELT_1X05.png',NULL),(102,'BUxx','%BASE%/img/footprints/Elektromechanik/Verbinder/Power-Jacks/BUCHSE_DCPOWERCONNECTOR.png',NULL),(103,'LED-0805','%BASE%/img/footprints/Optik/LEDs/SMD/LED-ROT_0805.png',NULL),(104,'MELF','%BASE%/img/footprints/Aktiv/Dioden/SMD/DIODE_MELF.png',NULL),(105,'MINIMELF','%BASE%/img/footprints/Aktiv/Dioden/SMD/DIODE_MINIMELF.png',NULL),(106,'MICROMELF','%BASE%/img/footprints/Aktiv/Dioden/SMD/DIODE_MICROMELF.png',NULL),(107,'MOLEX-PSL3W','%BASE%/img/footprints/Elektromechanik/Verbinder/Stiftleisten/Molex/PSL_abgewinkelt/STIFTLEISTE-MOLEX-ABGEWINKELT_PSL-03.png',NULL),(108,'1214','%BASE%/img/footprints/Passiv/Kondensatoren/Elektrolyt/SMD/ELKO_SMD_1214.png',NULL),(109,'7-Segment','%BASE%/img/footprints/Optik/7_Segment/7-SEGMENT_1-20CM.png',NULL);
/*!40000 ALTER TABLE `footprints` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `internal`
--

DROP TABLE IF EXISTS `internal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `internal` (
  `keyName` char(30) CHARACTER SET ascii NOT NULL,
  `keyValue` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  UNIQUE KEY `keyName` (`keyName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `internal`
--

LOCK TABLES `internal` WRITE;
/*!40000 ALTER TABLE `internal` DISABLE KEYS */;
INSERT INTO `internal` VALUES ('dbVersion','17');
/*!40000 ALTER TABLE `internal` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `manufacturers`
--

DROP TABLE IF EXISTS `manufacturers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `manufacturers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `address` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `phone_number` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `fax_number` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `email_address` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `website` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `auto_product_url` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `datetime_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `manufacturers_parent_id_k` (`parent_id`),
  CONSTRAINT `manufacturers_parent_id_fk` FOREIGN KEY (`parent_id`) REFERENCES `manufacturers` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `manufacturers`
--

LOCK TABLES `manufacturers` WRITE;
/*!40000 ALTER TABLE `manufacturers` DISABLE KEYS */;
/*!40000 ALTER TABLE `manufacturers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orderdetails`
--

DROP TABLE IF EXISTS `orderdetails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orderdetails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `part_id` int(11) NOT NULL,
  `id_supplier` int(11) NOT NULL DEFAULT '0',
  `supplierpartnr` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `obsolete` tinyint(1) DEFAULT '0',
  `supplier_product_url` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `datetime_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `orderdetails_part_id_k` (`part_id`),
  KEY `orderdetails_id_supplier_k` (`id_supplier`)
) ENGINE=InnoDB AUTO_INCREMENT=614 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orderdetails`
--

LOCK TABLES `orderdetails` WRITE;
/*!40000 ALTER TABLE `orderdetails` DISABLE KEYS */;
INSERT INTO `orderdetails` VALUES (1,132,1,'154242',0,'','2016-03-29 15:46:13'),(3,122,1,'154257',0,'','2016-03-29 15:46:13'),(4,129,1,'154166',0,'','2016-03-29 15:46:13'),(5,152,1,'522557',0,'','2016-03-29 15:46:13'),(7,94,1,'162272',0,'','2016-03-29 15:46:13'),(8,95,1,'162280',0,'','2016-03-29 15:46:13'),(9,87,1,'176001',0,'','2016-03-29 15:46:13'),(10,116,1,'156129',0,'','2016-03-29 15:46:13'),(11,117,1,'156128',0,'','2016-03-29 15:46:13'),(12,110,1,'179994',0,'','2016-03-29 15:46:13'),(13,175,1,'453099',0,'','2016-03-29 15:46:13'),(14,25,1,'734021',0,'','2016-03-29 15:46:13'),(15,22,1,'734166',0,'','2016-03-29 15:46:13'),(16,24,1,'734208',0,'','2016-03-29 15:46:13'),(17,176,2,'100264',0,'','2016-03-29 15:46:13'),(18,17,2,'202165',0,'','2016-03-29 15:46:13'),(19,12,2,'210342',0,'','2016-03-29 15:46:13'),(20,13,2,'210346',0,'','2016-03-29 15:46:13'),(21,18,2,'288332',0,'','2016-03-29 15:46:13'),(22,177,2,'288333',0,'','2016-03-29 15:46:13'),(23,120,2,'648999',0,'','2016-03-29 15:46:13'),(24,178,2,'662109',0,'','2016-03-29 15:46:13'),(25,179,2,'954638',0,'','2016-03-29 15:46:13'),(26,180,2,'956367',0,'','2016-03-29 15:46:13'),(27,181,2,'950109',0,'','2016-03-29 15:46:13'),(28,75,2,'666944',0,'','2016-03-29 15:46:13'),(29,80,2,'666952',0,'','2016-03-29 15:46:13'),(30,78,2,'666945',0,'','2016-03-29 15:46:13'),(31,16,2,'121631',0,'','2016-03-29 15:46:13'),(32,14,2,'127088',0,'','2016-03-29 15:46:13'),(33,20,2,'202372',0,'','2016-03-29 15:46:13'),(34,174,2,'353620',0,'','2016-03-29 15:46:13'),(35,182,2,'353600',0,'','2016-03-29 15:46:13'),(36,183,2,'458073',0,'','2016-03-29 15:46:13'),(37,134,2,'605379',0,'','2016-03-29 15:46:13'),(38,133,2,'612155',0,'','2016-03-29 15:46:13'),(39,121,2,'641802',0,'','2016-03-29 15:46:13'),(40,130,2,'642775',0,'','2016-03-29 15:46:13'),(41,184,2,'662422',0,'','2016-03-29 15:46:13'),(42,185,2,'662724',0,'','2016-03-29 15:46:13'),(43,136,2,'662876',0,'','2016-03-29 15:46:13'),(44,131,2,'666018',0,'','2016-03-29 15:46:13'),(45,79,2,'666953',0,'','2016-03-29 15:46:13'),(46,76,2,'666956',0,'','2016-03-29 15:46:13'),(47,81,2,'666982',0,'','2016-03-29 15:46:13'),(48,186,2,'667567',0,'','2016-03-29 15:46:13'),(49,187,2,'667589',0,'','2016-03-29 15:46:13'),(50,90,2,'820590',0,'','2016-03-29 15:46:13'),(51,91,2,'820596',0,'','2016-03-29 15:46:13'),(52,92,2,'838431',0,'','2016-03-29 15:46:13'),(53,188,2,'950680',0,'','2016-03-29 15:46:13'),(54,189,2,'953693',0,'','2016-03-29 15:46:13'),(55,190,2,'954615',0,'','2016-03-29 15:46:13'),(56,191,2,'956877',0,'','2016-03-29 15:46:13'),(57,192,2,'458099',0,'','2016-03-29 15:46:13'),(58,193,1,'814549',0,'','2016-03-29 15:46:13'),(59,194,1,'512683',0,'','2016-03-29 15:46:13'),(60,10,1,'733260',0,'','2016-03-29 15:46:13'),(61,135,1,'170007',0,'','2016-03-29 15:46:13'),(62,8,1,'700336',0,'','2016-03-29 15:46:13'),(63,195,1,'522667',0,'','2016-03-29 15:46:13'),(64,200,1,'142336',0,'','2016-03-29 15:46:13'),(65,148,1,'742324',0,'','2016-03-29 15:46:13'),(66,1,1,'731877',0,'','2016-03-29 15:46:13'),(67,2,1,'731891',0,'','2016-03-29 15:46:13'),(68,150,1,'503243',0,'','2016-03-29 15:46:13'),(69,201,1,'419168',0,'','2016-03-29 15:46:13'),(70,5,1,'703508',0,'','2016-03-29 15:46:13'),(71,6,1,'703524',0,'','2016-03-29 15:46:13'),(72,7,1,'707724',0,'','2016-03-29 15:46:13'),(73,84,1,'179213',0,'','2016-03-29 15:46:13'),(74,83,1,'179205',0,'','2016-03-29 15:46:13'),(75,86,1,'179230',0,'','2016-03-29 15:46:13'),(76,85,1,'179191',0,'','2016-03-29 15:46:13'),(77,202,1,'717581',0,'','2016-03-29 15:46:13'),(78,103,1,'528200',0,'','2016-03-29 15:46:13'),(79,203,1,'528226',0,'','2016-03-29 15:46:13'),(80,204,1,'705594',0,'','2016-03-29 15:46:13'),(81,205,1,'641138',0,'','2016-03-29 15:46:13'),(82,206,1,'541659',0,'','2016-03-29 15:46:13'),(83,156,1,'472670',0,'','2016-03-29 15:46:13'),(84,153,1,'445210',0,'','2016-03-29 15:46:13'),(85,154,1,'445432',0,'','2016-03-29 15:46:13'),(86,155,1,'406376',0,'','2016-03-29 15:46:13'),(87,163,1,'430838',0,'','2016-03-29 15:46:13'),(88,164,1,'430862',0,'','2016-03-29 15:46:13'),(89,165,1,'430897',0,'','2016-03-29 15:46:13'),(90,167,1,'430730',0,'','2016-03-29 15:46:13'),(91,166,1,'430765',0,'','2016-03-29 15:46:13'),(92,159,1,'422388',0,'','2016-03-29 15:46:13'),(93,160,1,'447321',0,'','2016-03-29 15:46:13'),(94,158,1,'445703',0,'','2016-03-29 15:46:13'),(95,157,1,'445536',0,'','2016-03-29 15:46:13'),(96,162,1,'431397',0,'','2016-03-29 15:46:13'),(97,26,1,'734036',0,'','2016-03-29 15:46:13'),(98,23,1,'734190',0,'','2016-03-29 15:46:13'),(99,28,1,'733884',0,'','2016-03-29 15:46:13'),(100,207,1,'531276',0,'','2016-03-29 15:46:13'),(101,29,1,'747013',0,'','2016-03-29 15:46:13'),(102,30,1,'747037',0,'','2016-03-29 15:46:13'),(103,208,1,'747085',0,'','2016-03-29 15:46:13'),(104,209,1,'528315',0,'','2016-03-29 15:46:13'),(105,210,1,'189618',0,'','2016-03-29 15:46:13'),(106,108,1,'189839',0,'','2016-03-29 15:46:13'),(107,169,1,'189871',0,'','2016-03-29 15:46:13'),(108,168,1,'189677',0,'','2016-03-29 15:46:13'),(109,173,1,'171069',0,'','2016-03-29 15:46:13'),(110,149,1,'153396',0,'','2016-03-29 15:46:13'),(111,212,1,'531243',0,'','2016-03-29 15:46:13'),(112,211,1,'530891',0,'','2016-03-29 15:46:13'),(113,213,1,'531251',0,'','2016-03-29 15:46:13'),(114,214,1,'530905',0,'','2016-03-29 15:46:13'),(115,216,1,'605808',0,'','2016-03-29 15:46:13'),(116,215,1,'605816',0,'','2016-03-29 15:46:13'),(117,101,1,'737314',0,'','2016-03-29 15:46:13'),(118,70,1,'155918',0,'','2016-03-29 15:46:13'),(119,217,1,'527769',0,'','2016-03-29 15:46:13'),(120,137,1,'731471',0,'','2016-03-29 15:46:13'),(121,11,1,'730294',0,'','2016-03-29 15:46:13'),(122,218,1,'181670',0,'','2016-03-29 15:46:13'),(123,219,1,'700708',0,'','2016-03-29 15:46:13'),(124,220,1,'145475',0,'','2016-03-29 15:46:13'),(125,221,1,'181154',0,'','2016-03-29 15:46:13'),(126,27,1,'734054',0,'','2016-03-29 15:46:13'),(127,222,1,'717529',0,'','2016-03-29 15:46:13'),(128,223,1,'55265',0,'','2016-03-29 15:46:13'),(129,224,1,'55247',0,'','2016-03-29 15:46:13'),(130,225,1,'812066',0,'','2016-03-29 15:46:13'),(131,226,3,'CONNECTOR MMC 12',0,'','2016-03-29 15:46:13'),(132,227,3,'12.2880-HC49U-S',0,'','2016-03-29 15:46:13'),(133,228,3,'TDA 7053',0,'','2016-03-29 15:46:13'),(134,229,3,'CLIP HQ9V',0,'','2016-03-29 15:46:13'),(135,230,3,'CLIP 9V',0,'','2016-03-29 15:46:13'),(136,231,3,'CLIP 9V-T',0,'','2016-03-29 15:46:13'),(137,232,3,'VS 1011E-S',0,'','2016-03-29 15:46:13'),(138,233,3,'HALTER 9V',0,'','2016-03-29 15:46:13'),(139,234,3,'HALTER 4XUM3-1DK',0,'','2016-03-29 15:46:13'),(140,235,3,'HALTER 1X9V',0,'','2016-03-29 15:46:13'),(141,236,1,'481637',0,'','2016-03-29 15:46:13'),(142,237,1,'457175',0,'','2016-03-29 15:46:13'),(143,238,1,'457272',0,'','2016-03-29 15:46:13'),(144,239,1,'500897',0,'','2016-03-29 15:46:13'),(145,240,1,'184473',0,'','2016-03-29 15:46:13'),(146,241,1,'184421',0,'','2016-03-29 15:46:13'),(147,242,1,'733777',0,'','2016-03-29 15:46:13'),(148,243,1,'736950',0,'','2016-03-29 15:46:13'),(149,93,1,'403989',0,'','2016-03-29 15:46:13'),(150,145,1,'742613',0,'','2016-03-29 15:46:13'),(151,257,2,'361002',0,'','2016-03-29 15:46:13'),(152,265,2,'361662',0,'','2016-03-29 15:46:13'),(153,336,2,'153947',0,'','2016-03-29 15:46:13'),(154,280,1,'523132',0,'','2016-03-29 15:46:13'),(155,273,1,'711764',0,'','2016-03-29 15:46:13'),(157,407,2,'667593',0,'','2016-03-29 15:46:13'),(159,388,2,'823499',0,'','2016-03-29 15:46:13'),(160,469,2,'838361',0,'','2016-03-29 15:46:13'),(161,314,2,'823501',0,'','2016-03-29 15:46:13'),(162,348,1,'153167',0,'','2016-03-29 15:46:13'),(163,358,1,'180104',0,'','2016-03-29 15:46:13'),(164,357,1,'180102',0,'','2016-03-29 15:46:13'),(165,454,2,'633523',0,'','2016-03-29 15:46:13'),(166,438,2,'728141',0,'','2016-03-29 15:46:13'),(167,367,2,'715612',0,'','2016-03-29 15:46:13'),(168,425,2,'715544',0,'','2016-03-29 15:46:13'),(169,468,2,'',0,'','2016-03-29 15:46:13'),(170,459,2,'',0,'','2016-03-29 15:46:13'),(171,463,2,'',0,'','2016-03-29 15:46:13'),(172,460,2,'',0,'','2016-03-29 15:46:13'),(173,464,2,'',0,'','2016-03-29 15:46:13'),(174,466,2,'',0,'','2016-03-29 15:46:13'),(175,368,2,'715588',0,'','2016-03-29 15:46:13'),(176,461,2,'',0,'','2016-03-29 15:46:13'),(177,427,1,'446314',0,'','2016-03-29 15:46:13'),(178,465,2,'',0,'','2016-03-29 15:46:13'),(179,470,2,'',0,'','2016-03-29 15:46:13'),(180,467,2,'',0,'','2016-03-29 15:46:13'),(181,420,2,'715201',0,'','2016-03-29 15:46:13'),(182,381,2,'645489',0,'','2016-03-29 15:46:13'),(183,347,2,'605328',0,'','2016-03-29 15:46:13'),(184,382,2,'646976',0,'','2016-03-29 15:46:13'),(185,370,1,'450825',0,'','2016-03-29 15:46:13'),(186,437,2,'818138',0,'','2016-03-29 15:46:13'),(187,446,2,'116833',0,'','2016-03-29 15:46:13'),(188,442,2,'116864',0,'','2016-03-29 15:46:13'),(189,439,2,'116865',0,'','2016-03-29 15:46:13'),(190,471,5,'',0,'','2016-03-29 15:46:13'),(191,452,2,'603810',0,'','2016-03-29 15:46:13'),(192,340,1,'167991',0,'','2016-03-29 15:46:13'),(194,379,1,'154684',0,'','2016-03-29 15:46:13'),(195,455,1,'442611',0,'','2016-03-29 15:46:13'),(196,301,1,'163746',0,'','2016-03-29 15:46:13'),(197,303,1,'160211',0,'','2016-03-29 15:46:13'),(198,304,1,'160213',0,'','2016-03-29 15:46:13'),(199,302,1,'160222',0,'','2016-03-29 15:46:13'),(200,343,1,'161032',0,'','2016-03-29 15:46:13'),(201,458,2,'600159',0,'','2016-03-29 15:46:13'),(202,311,2,'601250',0,'','2016-03-29 15:46:13'),(203,345,1,'160074',0,'','2016-03-29 15:46:13'),(204,344,1,'160484',0,'','2016-03-29 15:46:13'),(205,319,2,'605540',0,'','2016-03-29 15:46:13'),(206,170,1,'501433',0,'','2016-03-29 15:46:13'),(207,308,1,'162845',0,'','2016-03-29 15:46:13'),(208,127,1,'162752',0,'','2016-03-29 15:46:13'),(209,312,2,'611837',0,'','2016-03-29 15:46:13'),(210,293,1,'153047',0,'','2016-03-29 15:46:13'),(211,294,1,'163071',0,'','2016-03-29 15:46:13'),(212,334,2,'649042',0,'','2016-03-29 15:46:13'),(213,324,2,'646988',0,'','2016-03-29 15:46:13'),(214,310,1,'198685',0,'','2016-03-29 15:46:13'),(215,292,1,'198775',0,'','2016-03-29 15:46:13'),(216,290,1,'198672',0,'','2016-03-29 15:46:13'),(217,352,1,'142506',0,'','2016-03-29 15:46:13'),(218,349,1,'174858',0,'','2016-03-29 15:46:13'),(219,400,1,'151814',0,'','2016-03-29 15:46:13'),(220,396,2,'663219',0,'','2016-03-29 15:46:13'),(221,119,1,'152281',0,'','2016-03-29 15:46:13'),(222,126,2,'649548',0,'','2016-03-29 15:46:13'),(223,118,1,'177113',0,'','2016-03-29 15:46:13'),(224,295,1,'182877',0,'','2016-03-29 15:46:13'),(225,417,2,'644945',0,'','2016-03-29 15:46:13'),(226,399,1,'182826',0,'','2016-03-29 15:46:13'),(227,366,1,'154885',0,'','2016-03-29 15:46:13'),(228,378,2,'645110',0,'','2016-03-29 15:46:13'),(229,375,2,'645161',0,'','2016-03-29 15:46:13'),(230,418,2,'666012',0,'','2016-03-29 15:46:13'),(231,362,1,'445194',0,'','2016-03-29 15:46:13'),(232,291,1,'197969',0,'','2016-03-29 15:46:13'),(233,380,2,'645164',0,'','2016-03-29 15:46:13'),(234,331,2,'652411',0,'','2016-03-29 15:46:13'),(235,332,2,'652405',0,'','2016-03-29 15:46:13'),(236,248,1,'472700',0,'','2016-03-29 15:46:13'),(237,249,1,'472808',0,'','2016-03-29 15:46:13'),(238,247,1,'472743',0,'','2016-03-29 15:46:13'),(239,447,2,'116875',0,'','2016-03-29 15:46:13'),(240,448,2,'116876',0,'','2016-03-29 15:46:13'),(241,449,2,'116877',0,'','2016-03-29 15:46:13'),(242,450,2,'116878',0,'','2016-03-29 15:46:13'),(243,99,1,'738335',0,'','2016-03-29 15:46:13'),(244,386,2,'740842',0,'','2016-03-29 15:46:13'),(245,276,1,'526363',0,'','2016-03-29 15:46:13'),(246,277,1,'526398',0,'','2016-03-29 15:46:13'),(247,278,1,'526401',0,'','2016-03-29 15:46:13'),(248,451,2,'116904',0,'','2016-03-29 15:46:13'),(249,171,1,'428037',0,'','2016-03-29 15:46:13'),(250,371,1,'717525',0,'','2016-03-29 15:46:13'),(251,246,1,'535788',0,'','2016-03-29 15:46:13'),(252,252,1,'535729',0,'','2016-03-29 15:46:13'),(253,245,1,'535591',0,'','2016-03-29 15:46:13'),(254,282,1,'503369',0,'','2016-03-29 15:46:13'),(255,309,2,'818581',0,'','2016-03-29 15:46:13'),(256,398,2,'818511',0,'','2016-03-29 15:46:13'),(257,315,1,'445111',0,'','2016-03-29 15:46:13'),(258,422,2,'818566',0,'','2016-03-29 15:46:13'),(259,364,1,'445670',0,'','2016-03-29 15:46:13'),(260,365,1,'445503',0,'','2016-03-29 15:46:13'),(261,363,1,'445563',0,'','2016-03-29 15:46:13'),(262,387,2,'801797',0,'','2016-03-29 15:46:13'),(263,432,1,'601922',0,'','2016-03-29 15:46:13'),(264,392,2,'510816',0,'','2016-03-29 15:46:13'),(265,267,2,'824116',0,'','2016-03-29 15:46:13'),(266,296,1,'420266',0,'','2016-03-29 15:46:13'),(268,472,2,'',0,'','2016-03-29 15:46:13'),(269,473,2,'',0,'','2016-03-29 15:46:13'),(271,475,2,'631697',0,'','2016-03-29 15:46:13'),(272,486,2,'',0,'','2016-03-29 15:46:13'),(273,487,2,'',0,'','2016-03-29 15:46:13'),(274,476,2,'662670',0,'','2016-03-29 15:46:13'),(275,323,2,'129888',0,'','2016-03-29 15:46:13'),(276,480,5,'',0,'','2016-03-29 15:46:13'),(277,479,2,'601496',0,'','2016-03-29 15:46:13'),(278,485,5,'',0,'','2016-03-29 15:46:13'),(279,481,5,'',0,'','2016-03-29 15:46:13'),(280,484,5,'',0,'','2016-03-29 15:46:13'),(281,488,2,'722941',0,'','2016-03-29 15:46:13'),(282,489,2,'722981',0,'','2016-03-29 15:46:13'),(283,490,2,'353578',0,'','2016-03-29 15:46:13'),(284,491,2,'',0,'','2016-03-29 15:46:13'),(285,494,2,'818146',0,'','2016-03-29 15:46:13'),(286,495,2,'812121',0,'','2016-03-29 15:46:13'),(287,477,2,'644353',0,'','2016-03-29 15:46:13'),(288,478,2,'810770',0,'','2016-03-29 15:46:13'),(289,482,5,'',0,'','2016-03-29 15:46:13'),(290,496,2,'667910',0,'','2016-03-29 15:46:13'),(291,285,1,'710047',0,'','2016-03-29 15:46:13'),(292,497,2,'268091',0,'','2016-03-29 15:46:13'),(293,498,2,'268106',0,'','2016-03-29 15:46:13'),(294,499,2,'740836',0,'','2016-03-29 15:46:13'),(295,500,2,'740848',0,'','2016-03-29 15:46:13'),(296,501,2,'740840',0,'','2016-03-29 15:46:13'),(297,435,1,'523805',0,'','2016-03-29 15:46:13'),(298,502,1,'871001',0,'','2016-03-29 15:46:13'),(299,503,1,'055248',0,'','2016-03-29 15:46:13'),(300,69,1,'155829',0,'','2016-03-29 15:46:13'),(302,419,2,'667649',0,'','2016-03-29 15:46:13'),(303,325,2,'140934',0,'','2016-03-29 15:46:13'),(304,328,2,'140938',0,'','2016-03-29 15:46:13'),(305,326,2,'142258',0,'','2016-03-29 15:46:13'),(306,329,2,'142260',0,'','2016-03-29 15:46:13'),(307,408,2,'200865',0,'','2016-03-29 15:46:13'),(308,409,2,'202149',0,'','2016-03-29 15:46:13'),(309,410,2,'209255',0,'','2016-03-29 15:46:13'),(310,353,1,'501262',0,'','2016-03-29 15:46:13'),(311,389,1,'815357',0,'','2016-03-29 15:46:13'),(312,474,1,'812808',0,'','2016-03-29 15:46:13'),(313,274,1,'742082',0,'','2016-03-29 15:46:13'),(314,272,1,'742066',0,'','2016-03-29 15:46:13'),(315,300,1,'401668',0,'','2016-03-29 15:46:13'),(316,402,1,'500394',0,'','2016-03-29 15:46:13'),(317,404,1,'500741',0,'','2016-03-29 15:46:13'),(318,405,1,'468053',0,'','2016-03-29 15:46:13'),(319,403,1,'500418',0,'','2016-03-29 15:46:13'),(320,283,1,'425637',0,'','2016-03-29 15:46:13'),(321,284,1,'425609',0,'','2016-03-29 15:46:13'),(322,297,1,'459918',0,'','2016-03-29 15:46:13'),(323,316,1,'449990',0,'','2016-03-29 15:46:13'),(324,266,2,'823791',0,'','2016-03-29 15:46:13'),(325,250,1,'459935',0,'','2016-03-29 15:46:13'),(326,251,1,'459817',0,'','2016-03-29 15:46:13'),(327,430,1,'459856',0,'','2016-03-29 15:46:13'),(328,298,1,'459964',0,'','2016-03-29 15:46:13'),(329,275,1,'540474',0,'','2016-03-29 15:46:13'),(330,286,1,'741370',0,'','2016-03-29 15:46:13'),(331,377,2,'253749',0,'','2016-03-29 15:46:13'),(332,434,1,'814561',0,'','2016-03-29 15:46:13'),(333,433,1,'814573',0,'','2016-03-29 15:46:13'),(334,115,2,'649751',0,'','2016-03-29 15:46:13'),(335,128,2,'620071',0,'','2016-03-29 15:46:13'),(336,114,2,'662226',0,'','2016-03-29 15:46:13'),(337,123,1,'081735',0,'','2016-03-29 15:46:13'),(338,199,1,'181544',0,'','2016-03-29 15:46:13'),(339,111,2,'651931',0,'','2016-03-29 15:46:13'),(340,279,1,'184864',0,'','2016-03-29 15:46:13'),(341,104,2,'651924',0,'','2016-03-29 15:46:13'),(342,253,2,'505649',0,'','2016-03-29 15:46:13'),(343,198,1,'500825',0,'','2016-03-29 15:46:13'),(344,264,2,'500335',0,'','2016-03-29 15:46:13'),(345,262,2,'500333',0,'','2016-03-29 15:46:13'),(346,259,2,'500334',0,'','2016-03-29 15:46:13'),(347,330,2,'650027',0,'','2016-03-29 15:46:13'),(348,376,2,'250608',0,'','2016-03-29 15:46:13'),(349,196,1,'710690',0,'','2016-03-29 15:46:13'),(350,504,2,'116879',0,'','2016-03-29 15:46:13'),(351,385,2,'662705',0,'','2016-03-29 15:46:13'),(352,197,1,'142042',0,'','2016-03-29 15:46:13'),(353,394,2,'661484',0,'','2016-03-29 15:46:13'),(354,395,2,'661561',0,'','2016-03-29 15:46:13'),(355,256,2,'150250',0,'','2016-03-29 15:46:13'),(356,255,2,'153946',0,'','2016-03-29 15:46:13'),(357,327,2,'150001',0,'','2016-03-29 15:46:13'),(358,287,1,'742342',0,'','2016-03-29 15:46:13'),(373,431,1,'430706',0,'','2016-03-29 15:46:13'),(374,429,1,'419320',0,'','2016-03-29 15:46:13'),(375,270,2,'712606',0,'','2016-03-29 15:46:13'),(376,268,2,'712565',0,'','2016-03-29 15:46:13'),(377,271,2,'712564',0,'','2016-03-29 15:46:13'),(378,269,2,'712610',0,'','2016-03-29 15:46:13'),(379,406,1,'812811',0,'','2016-03-29 15:46:13'),(380,428,1,'812803',0,'','2016-03-29 15:46:13'),(381,411,2,'514485',0,'','2016-03-29 15:46:13'),(382,412,2,'514486',0,'','2016-03-29 15:46:13'),(383,413,2,'514487',0,'','2016-03-29 15:46:13'),(384,356,1,'180107',0,'','2016-03-29 15:46:13'),(385,393,2,'632644',0,'','2016-03-29 15:46:13'),(386,53,2,'254478',0,'','2016-03-29 15:46:13'),(387,391,2,'140336',0,'','2016-03-29 15:46:13'),(388,421,2,'715204',0,'','2016-03-29 15:46:13'),(389,423,2,'963616',0,'','2016-03-29 15:46:13'),(390,415,2,'560222',0,'','2016-03-29 15:46:13'),(391,414,2,'560212',0,'','2016-03-29 15:46:13'),(392,359,1,'710421',0,'','2016-03-29 15:46:13'),(393,258,2,'630638',0,'','2016-03-29 15:46:13'),(394,337,2,'630080',0,'','2016-03-29 15:46:13'),(395,457,2,'633522',0,'','2016-03-29 15:46:13'),(396,453,2,'630083',0,'','2016-03-29 15:46:13'),(397,261,2,'630144',0,'','2016-03-29 15:46:13'),(398,305,1,'403709',0,'','2016-03-29 15:46:13'),(399,350,1,'163073',0,'','2016-03-29 15:46:13'),(400,64,2,'631016',0,'','2016-03-29 15:46:13'),(401,361,1,'156945',0,'','2016-03-29 15:46:13'),(402,317,2,'719634',0,'','2016-03-29 15:46:13'),(403,313,2,'818272',0,'','2016-03-29 15:46:13'),(404,355,1,'533920',0,'','2016-03-29 15:46:13'),(405,322,2,'125442',0,'','2016-03-29 15:46:13'),(406,147,2,'127116',0,'','2016-03-29 15:46:13'),(407,146,2,'127114',0,'','2016-03-29 15:46:13'),(408,424,2,'361661',0,'','2016-03-29 15:46:13'),(409,320,2,'354196',0,'','2016-03-29 15:46:13'),(410,281,1,'168777',0,'','2016-03-29 15:46:13'),(411,82,1,'168467',0,'','2016-03-29 15:46:13'),(412,360,1,'156006',0,'','2016-03-29 15:46:13'),(413,372,1,'183387',0,'','2016-03-29 15:46:13'),(414,373,1,'707570',0,'','2016-03-29 15:46:13'),(415,374,1,'700479',0,'','2016-03-29 15:46:13'),(416,289,1,'744167',0,'','2016-03-29 15:46:13'),(417,288,1,'744153',0,'','2016-03-29 15:46:13'),(419,354,1,'155961',0,'','2016-03-29 15:46:13'),(420,342,1,'162063',0,'','2016-03-29 15:46:13'),(421,341,1,'167967',0,'','2016-03-29 15:46:13'),(422,416,2,'568047',0,'','2016-03-29 15:46:13'),(423,443,2,'116836',0,'','2016-03-29 15:46:13'),(424,444,2,'116835',0,'','2016-03-29 15:46:13'),(425,441,2,'116862',0,'','2016-03-29 15:46:13'),(426,445,2,'116834',0,'','2016-03-29 15:46:13'),(427,440,2,'116861',0,'','2016-03-29 15:46:13'),(428,260,2,'159794',0,'','2016-03-29 15:46:13'),(429,384,2,'662485',0,'','2016-03-29 15:46:13'),(430,369,2,'649203',0,'','2016-03-29 15:46:13'),(431,383,2,'649206',0,'','2016-03-29 15:46:13'),(444,263,2,'505650',0,'','2016-03-29 15:46:13'),(445,254,2,'505650',0,'','2016-03-29 15:46:13'),(446,307,1,'419646',0,'','2016-03-29 15:46:13'),(447,306,1,'400009',0,'','2016-03-29 15:46:13'),(448,346,1,'421421',0,'','2016-03-29 15:46:13'),(449,397,2,'700037',0,'','2016-03-29 15:46:13'),(450,299,1,'428804',0,'','2016-03-29 15:46:13'),(451,318,2,'715217',0,'','2016-03-29 15:46:13'),(452,333,2,'650181',0,'','2016-03-29 15:46:13'),(453,339,1,'180346',0,'','2016-03-29 15:46:13'),(454,338,1,'189066',0,'','2016-03-29 15:46:13'),(455,335,2,'129099',0,'','2016-03-29 15:46:13'),(456,390,1,'815322',0,'','2016-03-29 15:46:13'),(457,401,1,'551678',0,'','2016-03-29 15:46:13'),(458,505,1,'160032',0,'','2016-03-29 15:46:13'),(459,506,1,'704655',0,'','2016-03-29 15:46:13'),(460,507,1,'514221',0,'','2016-03-29 15:46:13'),(461,508,2,'661216',0,'','2016-03-29 15:46:13'),(462,510,2,'363639',0,'','2016-03-29 15:46:13'),(463,511,2,'110266',0,'','2016-03-29 15:46:13'),(464,512,2,'102901',0,'','2016-03-29 15:46:13'),(465,513,2,'300284',0,'','2016-03-29 15:46:13'),(466,514,2,'505134',0,'','2016-03-29 15:46:13'),(467,515,2,'505135',0,'','2016-03-29 15:46:13'),(468,516,2,'505147',0,'','2016-03-29 15:46:13'),(469,517,6,'505146',0,'','2016-03-29 15:46:13'),(470,518,6,'505148',0,'','2016-03-29 15:46:13'),(472,520,2,'202214',0,'','2016-03-29 15:46:13'),(473,521,6,'641253',0,'','2016-03-29 15:46:13'),(474,522,2,'208403',0,'','2016-03-29 15:46:13'),(475,523,2,'667553',0,'','2016-03-29 15:46:13'),(476,524,2,'748172',0,'','2016-03-29 15:46:13'),(477,525,2,'748327',0,'','2016-03-29 15:46:13'),(478,526,2,'748325',0,'','2016-03-29 15:46:13'),(479,530,2,'253257',0,'','2016-03-29 15:46:13'),(480,531,2,'505219',0,'','2016-03-29 15:46:13'),(481,532,2,'505224',0,'','2016-03-29 15:46:13'),(482,533,2,'604684',0,'','2016-03-29 15:46:13'),(483,534,2,'649931',0,'','2016-03-29 15:46:13'),(484,535,2,'661192',0,'','2016-03-29 15:46:13'),(486,456,2,'841006',0,'','2016-03-29 15:46:13'),(487,3,1,'',0,'','2016-03-29 15:46:13'),(488,4,1,'',0,'','2016-03-29 15:46:13'),(489,9,1,'',0,'','2016-03-29 15:46:13'),(490,15,1,'',0,'','2016-03-29 15:46:13'),(491,19,1,'',0,'','2016-03-29 15:46:13'),(492,21,2,'',0,'','2016-03-29 15:46:13'),(493,31,1,'',0,'','2016-03-29 15:46:13'),(494,32,1,'',0,'','2016-03-29 15:46:13'),(495,33,1,'',0,'','2016-03-29 15:46:13'),(496,34,1,'',0,'','2016-03-29 15:46:13'),(497,35,1,'',0,'','2016-03-29 15:46:13'),(498,36,1,'',0,'','2016-03-29 15:46:13'),(499,37,1,'',0,'','2016-03-29 15:46:13'),(500,38,1,'',0,'','2016-03-29 15:46:13'),(501,39,1,'',0,'','2016-03-29 15:46:13'),(502,40,1,'',0,'','2016-03-29 15:46:13'),(503,41,1,'',0,'','2016-03-29 15:46:13'),(504,42,1,'',0,'','2016-03-29 15:46:13'),(505,43,1,'',0,'','2016-03-29 15:46:13'),(506,44,1,'',0,'','2016-03-29 15:46:13'),(507,45,1,'',0,'','2016-03-29 15:46:13'),(508,46,1,'',0,'','2016-03-29 15:46:13'),(509,47,1,'',0,'','2016-03-29 15:46:13'),(510,48,1,'',0,'','2016-03-29 15:46:13'),(511,49,1,'',0,'','2016-03-29 15:46:13'),(512,50,1,'',0,'','2016-03-29 15:46:13'),(513,51,1,'',0,'','2016-03-29 15:46:13'),(514,52,1,'',0,'','2016-03-29 15:46:13'),(515,54,1,'',0,'','2016-03-29 15:46:13'),(516,55,1,'',0,'','2016-03-29 15:46:13'),(517,56,1,'',0,'','2016-03-29 15:46:13'),(518,57,1,'',0,'','2016-03-29 15:46:13'),(519,58,1,'',0,'','2016-03-29 15:46:13'),(520,59,1,'',0,'','2016-03-29 15:46:13'),(521,60,1,'',0,'','2016-03-29 15:46:13'),(522,61,1,'',0,'','2016-03-29 15:46:13'),(523,62,1,'',0,'','2016-03-29 15:46:13'),(524,63,1,'',0,'','2016-03-29 15:46:13'),(525,65,1,'',0,'','2016-03-29 15:46:13'),(526,66,1,'',0,'','2016-03-29 15:46:13'),(527,67,1,'',0,'','2016-03-29 15:46:13'),(528,68,1,'',0,'','2016-03-29 15:46:13'),(529,71,1,'',0,'','2016-03-29 15:46:13'),(530,72,1,'',0,'','2016-03-29 15:46:13'),(531,73,1,'',0,'','2016-03-29 15:46:13'),(532,74,1,'',0,'','2016-03-29 15:46:13'),(533,77,1,'',0,'','2016-03-29 15:46:13'),(534,89,1,'',0,'','2016-03-29 15:46:13'),(535,96,1,'',0,'','2016-03-29 15:46:13'),(536,97,1,'',0,'','2016-03-29 15:46:13'),(537,98,1,'',0,'','2016-03-29 15:46:13'),(538,100,1,'',0,'','2016-03-29 15:46:13'),(539,102,1,'',0,'','2016-03-29 15:46:13'),(540,105,1,'',0,'','2016-03-29 15:46:13'),(541,106,1,'',0,'','2016-03-29 15:46:13'),(542,107,1,'',0,'','2016-03-29 15:46:13'),(543,109,1,'',0,'','2016-03-29 15:46:13'),(544,112,1,'',0,'','2016-03-29 15:46:13'),(545,113,1,'',0,'','2016-03-29 15:46:13'),(546,124,1,'',0,'','2016-03-29 15:46:13'),(547,125,1,'',0,'','2016-03-29 15:46:13'),(548,138,1,'',0,'','2016-03-29 15:46:13'),(549,139,1,'',0,'','2016-03-29 15:46:13'),(550,140,1,'',0,'','2016-03-29 15:46:13'),(551,141,1,'',0,'','2016-03-29 15:46:13'),(552,142,1,'',0,'','2016-03-29 15:46:13'),(553,143,1,'',0,'','2016-03-29 15:46:13'),(554,144,1,'',0,'','2016-03-29 15:46:13'),(555,151,1,'',0,'','2016-03-29 15:46:13'),(556,161,1,'',0,'','2016-03-29 15:46:13'),(557,172,1,'',0,'','2016-03-29 15:46:13'),(558,321,2,'129448',0,'','2016-03-29 15:46:13'),(559,351,1,'163076',1,'','2016-03-29 15:46:13'),(560,462,2,'',0,'','2016-03-29 15:46:13'),(561,483,5,'',0,'','2016-03-29 15:46:13'),(562,492,2,'',0,'','2016-03-29 15:46:13'),(563,509,2,'700010',0,'','2016-03-29 15:46:13');
/*!40000 ALTER TABLE `orderdetails` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `parts`
--

DROP TABLE IF EXISTS `parts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `parts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_category` int(11) NOT NULL DEFAULT '0',
  `name` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `instock` int(11) NOT NULL DEFAULT '0',
  `mininstock` int(11) NOT NULL DEFAULT '0',
  `comment` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `visible` tinyint(1) NOT NULL,
  `id_footprint` int(11) DEFAULT NULL,
  `id_storelocation` int(11) DEFAULT NULL,
  `order_orderdetails_id` int(11) DEFAULT NULL,
  `order_quantity` int(11) NOT NULL DEFAULT '1',
  `manual_order` tinyint(1) NOT NULL DEFAULT '0',
  `id_manufacturer` int(11) DEFAULT NULL,
  `id_master_picture_attachement` int(11) DEFAULT NULL,
  `manufacturer_product_url` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `datetime_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `parts_id_category_k` (`id_category`),
  KEY `parts_id_footprint_k` (`id_footprint`),
  KEY `parts_id_storelocation_k` (`id_storelocation`),
  KEY `parts_order_orderdetails_id_k` (`order_orderdetails_id`),
  KEY `parts_id_manufacturer_k` (`id_manufacturer`),
  CONSTRAINT `parts_id_footprint_fk` FOREIGN KEY (`id_footprint`) REFERENCES `footprints` (`id`),
  CONSTRAINT `parts_id_manufacturer_fk` FOREIGN KEY (`id_manufacturer`) REFERENCES `manufacturers` (`id`),
  CONSTRAINT `parts_id_storelocation_fk` FOREIGN KEY (`id_storelocation`) REFERENCES `storelocations` (`id`),
  CONSTRAINT `parts_order_orderdetails_id_fk` FOREIGN KEY (`order_orderdetails_id`) REFERENCES `orderdetails` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=536 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `parts`
--

LOCK TABLES `parts` WRITE;
/*!40000 ALTER TABLE `parts` DISABLE KEYS */;
INSERT INTO `parts` VALUES (1,19,'Schraubklemme 2Pol RM5.08 Schwarz','',21,5,'',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(2,19,'Schraubklemme 3Pol RM5.08 Schwarz','',15,5,'',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(3,19,'Schraubklemme 3Pol RM5.08 Blau','',1,0,'',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(4,22,'Printtaster langer Stössel RM5.08','',5,3,'10x10mm, Stössel 7,5mm',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(5,22,'Printtaster gross eckig rot RM5.08','',1,1,'10x10mm',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(6,22,'Printtaster gross eckig schwarz RM5.08','',1,1,'10x10mm',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(7,22,'Printtaster miniatur mit Stössel 2Anschl.','',1,0,'15mm',0,62,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(8,22,'Printtaster miniatur','',27,4,'Standard, ohne Stössel',0,94,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(9,27,'USB-Printbuchse miniatur','',1,1,'',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(10,28,'Power-Jack Buchse Printmontage 5.7/1.95mm','',3,2,'',0,102,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(11,29,'3,5mm Klinkenbuchse Print Stereo','',3,1,'',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(12,24,'Print-Codierschalter 2er','',2,1,'',0,2,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(13,24,'Print-Codierschalter 4er','',2,1,'',0,4,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(14,21,'Stiftleiste 2x5Pol mit Rahmen','',5,2,'RM2,54mm\r\nFür 10P-ISP Flachbandkabel',0,77,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(15,21,'Stiftleiste 2x8Pol mit Rahmen','',3,2,'RM 2,54mm\r\nFür Display 16P Flachband',0,81,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(16,21,'Stiftleiste 2x3Pol mit Rahmen','',4,2,'RM 2,54mm\r\nFür 6P-ISP\r\n\r\nConrad 741435',0,78,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(17,26,'Print-Kippschalter on-on 1P','',3,2,'1A11-NF1PCAE\r\nRastend 2 Stellungen',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(18,32,'Print-Sicherungshalter 5x20mm','',3,1,'Schutzhaube erforderlich!',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(19,33,'Jumper 2,54mm div. Farben','',7,4,'',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(20,23,'Print-Schiebeschalter 2Pos','',3,1,'',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(21,35,'Platinenbefestigungen 90° Print','',4,2,'Metall, M3',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(22,36,'Molex Stiftleiste 2P 2,54mm','',6,2,'',0,97,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(23,36,'Molex Stiftleiste 3P 2,54mm','',11,2,'',0,98,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(24,36,'Molex Stiftleiste 4P 2,54mm','',5,2,'',0,99,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(25,36,'Molex Buchse 2P 2,54mm','',10,2,'',0,NULL,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(26,36,'Molex Buchse 3P 2,54mm','',5,2,'',0,NULL,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(27,36,'Molex Buchse 4P 2,54mm','',3,2,'',0,NULL,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(28,36,'Molex Crimpkontakte 20Stk','',2,1,'',0,NULL,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(29,37,'USB-Stecker Kabelmontage','',2,1,'Passende Gehäuse erforderlich und Verfügbar',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(30,40,'USB-Steckergehäuse für Kabel Transparent','',2,1,'Passend zu verfügbaren Stecker. Nur für Kabel-Montage!!!',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(31,29,'Cinch-Buchse doppelt R/L','',1,1,'Ausgelötet, nicht gekauft!',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(32,43,'Zener-Diode 2,7V 500mW','Zener-Diode 2,7V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(33,43,'Zener-Diode 3,3V 500mW','Zener-Diode 3,3V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(34,43,'Zener-Diode 3,9V 500mW','Zener-Diode 3,9V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(35,43,'Zener-Diode 4,7V 500mW','Zener-Diode 4,7V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(36,43,'Zener-Diode 5,1V 500mW','Zener-Diode 5,1V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(37,43,'Zener-Diode 5,6V 500mW','Zener-Diode 5,6V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(38,43,'Zener-Diode 6,2V 500mW','Zener-Diode 6,2V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(39,43,'Zener-Diode 6,8V 500mW','Zener-Diode 6,8V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(40,43,'Zener-Diode 7,5V 500mW','Zener-Diode 7,5V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(41,43,'Zener-Diode 8,2V 500mW','Zener-Diode 8,2V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(42,43,'Zener-Diode 10V 500mW','Zener-Diode 10V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(43,43,'Zener-Diode 12V 500mW','Zener-Diode 12V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(44,43,'Zener-Diode 15V 500mW','Zener-Diode 15V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(45,43,'Zener-Diode 18V 500mW','Zener-Diode 18V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(46,43,'Zener-Diode 20V 500mW','Zener-Diode 20V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(47,43,'Zener-Diode 22V 500mW','Zener-Diode 22V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(48,43,'Zener-Diode 24V 500mW','Zener-Diode 24V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(49,43,'Zener-Diode 27V 500mW','Zener-Diode 27V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(50,43,'Zener-Diode 30V 500mW','Zener-Diode 30V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(51,43,'Zener-Diode 33V 500mW','Zener-Diode 33V 500mW',10,2,'',0,31,5,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(52,47,'LED Rot 3mm Transparent','',7,3,'30° / 80mcd / 20mA / 2V',0,90,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(53,47,'LED Grün 3mm','',9,3,'',0,90,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(54,47,'LED Gelb 3mm','',10,3,'35° / 30mcd / 20mA / 2.1V',0,90,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(55,47,'LED Blau 3mm Transparent','',10,3,'20° / 2000mcd / 20mA / 3.2V',0,90,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(56,47,'LED Weiss 3mm','',10,3,'25° / 1200mcd / 20mA / 3.2V',0,90,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(57,48,'LED Rot 5mm','',10,3,'35° / 80mcd / 30mA / 2V',0,91,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(58,48,'LED Grün 5mm','',10,3,'35ï¿½ / 80mcd / 30mA / 2.2V',0,91,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(59,48,'LED Gelb 5mm','',10,3,'35° / 70mcd / 30mA / 2.1V',0,91,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(60,48,'LED Blau 5mm Transparent','',10,3,'12° / 1000mcd / 20mA / 3.2V',0,91,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(61,48,'LED Weiss 5mm','',10,3,'12° / 3000mcd / 20mA / 3.2V',0,91,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(62,48,'LED UV 5mm','',10,3,'20° / 3000mcd / 3.2V - 3.6V / Wellenlänge 400-405',0,91,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(63,48,'LED Rot 5mm Ultrahell Transparent','',6,1,'20° / 9800mcd / 1.9V - 2V / 20mA',0,91,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(64,48,'LED Infrarot 5mm','',2,2,'AN304 / 950nm',0,91,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(65,50,'SMD-LED Farbe unbekannt','',18,2,'keine Angaben',0,1,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(66,49,'LED-Fassung 3mm Schwarz Kunststoff','',20,3,'Zum Einpressen',0,1,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(67,49,'LED-Fassung 5mm Schwarz Kunststoff','',20,3,'Zum Einpressen',0,1,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(68,49,'LED-Fassung 5mm Metall','',1,1,'Schraubmontage, Bohrung 8mm',0,1,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(69,8,'BC327','Transistor PNP',9,3,'',0,29,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(70,8,'BC337','Transistor NPN',15,5,'',0,29,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(71,8,'BC517','Transistor NPN',16,4,'',0,NULL,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(72,8,'BC548B','Transistor NPN',12,4,'',0,NULL,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(73,8,'BC557B','Transistor PNP',9,3,'',0,NULL,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(74,11,'Quarz 3,8684Mhz hoch','',3,1,'',0,1,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(75,11,'Quarz 8Mhz tief','',2,2,'HC49/4H',0,36,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(76,11,'Quarz 10Mhz tief','',2,2,'HC49/4H',0,36,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(77,11,'Quarz 9.8304Mhz hoch','',1,1,'',0,1,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(78,11,'Quarz 8.192Mhz tief','',2,1,'HC49/4H',0,36,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(79,11,'Quarz 20Mhz tief','',3,1,'',0,36,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(80,11,'Quarz 16Mhz tief','',2,2,'HC49/4H',0,36,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(81,11,'Quarz 25Mhz SMD','',2,1,'HC49/4H SMX',0,37,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(82,11,'Quarz 32.768kHz','',2,1,'',0,1,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(83,52,'L7805','Spannungsregler 5V',8,3,'',0,28,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(84,52,'L7806','Spannungsregler 6V',4,1,'',0,28,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(85,52,'L7809','Spannungsregler 9V',2,1,'',0,28,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(86,52,'L7812','Spannungsregler 12V',8,3,'',0,28,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(87,53,'LM317','Einstellbarer Spannungsregler',4,2,'',0,28,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(89,14,'MKS Folienkondensator 330nF gross','',8,2,'',0,1,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(90,14,'Folienkondensator MKS2 10nF 63V','',9,4,'Conrad 459960',0,58,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(91,14,'Folienkondensator MKS2 100nF 63V','',51,5,'Conrad 459830',0,58,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(92,15,'Kerko 22pF 500V','',35,8,'',0,1,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(93,111,'Widerstand 330R','',101,1,'100er Pack',0,18,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(94,42,'1N4007','Diode 1000V 1A',100,15,'',0,64,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(95,42,'1N4148','Diode 75V 0,15A',100,15,'',0,31,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(96,21,'Stiftleiste 1-Reihig 20Pol','',15,2,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(97,21,'Stiftleiste 1-Reihig 20Pol gewinkelt RM2.54','',3,1,'Distrelec 36Pol 127252',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(98,21,'Stiftleiste 2-Reihig 32Pol RM2.54','',11,2,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(99,20,'Buchsenleiste 1-Reihig 20Pol RM2.54','',3,3,'Distrelec 50Pol 121562',0,100,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(100,20,'Präzisionsbuchsenleiste 1-Reihig 20Pol RM2.54','',8,1,'Nicht mehr bestellen',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(101,20,'Buchsenleiste 1-Reihig 20Pol RM2.54 gewinkelt','',4,3,'Distrelec 50Pol 121599',0,101,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(102,20,'Buchsenleiste 2x5Pol SMD','',4,1,'',0,38,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(103,54,'Hartpapier-Platine 50x100mm Einseitig Cu','',5,4,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(104,55,'IC-Sockel 8Pol','',3,2,'',0,4,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(105,55,'IC-Sockel 10Pol','',1,1,'',0,5,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(106,55,'IC-Sockel 16Pol','',7,3,'',0,8,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(107,55,'IC-Sockel 18Pol','',2,2,'',0,9,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(108,55,'IC-Sockel 20Pol','',13,2,'',0,10,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(109,55,'IC-Sockel 22Pol','',1,1,'',0,19,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(110,55,'IC-Sockel 28Pol','',34,3,'Distrelec 650560\r\n17Stk für 8.70Fr.: Distrelec 652647',0,12,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(111,55,'IC-Sockel 28Pol Breit','',6,1,'',0,12,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(112,55,'IC-Sockel 22Pol Breit','',2,1,'',0,19,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(113,55,'IC-Sockel 48Pol','',1,1,'',0,35,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(114,76,'LM386N-1','Verstärker',2,1,'',0,4,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(115,100,'74HCT373','Octal Transparent Latch',2,1,'',0,10,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(116,99,'L297','Schrittmotorchopper',0,1,'',0,10,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(117,99,'L298','Schrittmotortreiber',2,1,'',0,20,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(118,100,'NE555','Timer',5,1,'',0,4,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(119,74,'MAX232N','RS232 Treiber',2,1,'',0,8,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(120,77,'PCF8574P','I2C Portexpander',1,1,'',0,8,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(121,75,'DS1809-100+','IC',1,1,'100kOhm Digitalpotentiometer',0,4,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(122,10,'ATMega8535-16PU','Mikrocontroller',1,1,'',0,13,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(123,100,'TDA4605-3','Schaltnetzteil-IC',1,1,'',0,4,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(124,100,'7490N','IC',1,1,'',0,7,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(125,100,'7442N','IC',1,1,'',0,8,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(126,100,'74HC244D','IC',3,1,'',0,21,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(127,89,'IRFZ46N','N-Mosfet 55V 46A',4,2,'',0,28,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(128,88,'BT138F-800','Triac',2,1,'',0,28,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(129,10,'ATTiny2313-20PU','Mikrocontroller',2,2,'Distrelec 645062 3.90Fr',0,10,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(130,10,'ATMega8-16PU','Mikrocontroller',3,2,'Conrad 154054 11.95Fr.',0,12,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(131,10,'ATTiny24V-10PU','Mikrocontroller',3,2,'',0,7,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(132,10,'ATMega16-16PU','Mikrocontroller',2,2,'Distrelec 642777 11.10Fr\r\n',0,13,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(133,89,'IRF1010NPBF','N-Mosfet 55V 85A',2,2,'',0,28,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(134,89,'IRLZ 34NPBF','N-Mosfet 55V 30A',2,2,'',0,28,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(135,75,'DS1804-010+','IC',1,1,'10kOhm Digitalpoti',0,4,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(136,74,'ENC28J60/SP ','Ethernet-Controller',2,1,'',0,12,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(137,56,'Mono-Klinkenstecker 3.5mm','',1,1,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(138,38,'Sub-D Buchse 25Pol Lötanschlüsse','',1,1,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(139,38,'Sub-D Stecker 25Pol Lötanschlüsse','',1,1,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(140,38,'Sub-D Stecker 15Pol Lötanschlüsse','',3,1,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(141,40,'Sub-D Steckergehäuse 15Pol','',3,1,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(142,57,'Sub-D Buchse Print 25Pol 90°','',0,2,'',0,73,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(143,57,'Sub-D Stecker Print 25Pol 90°','',2,1,'',0,76,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(144,57,'Sub-D Stecker Print 9Pol 90°','',5,2,'',0,75,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(145,57,'Sub-D Buchse Print 9Pol 90°','',1,1,'',0,74,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(146,58,'Schneidklemm-Buchse 2x5Pol','',8,4,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(147,58,'Schneidklemm-Buchse 2x8Pol','',4,2,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(148,58,'Schneidklemm-Buchse 2x3Pol','',6,4,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(149,59,'Optokoppler CNY17-3','',4,1,'',0,3,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(150,60,'Print-Relais 5V / 10A 250V Weiss','',5,2,'Finder, 1 Wechsler',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(151,60,'Print-Relais 5V','',3,1,'2 Wechsler',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(152,61,'Batteriehalter 4xAA Weiss','',1,1,'',0,NULL,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(153,15,'Kerko 100nF 50V X7R','',18,4,'',0,70,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(154,15,'Kerko 22pF 50V','',10,2,'',0,70,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(155,62,'Widerstand 10k 0,1W','',20,4,'',0,22,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(156,13,'Elko 2200uF 63V','',5,1,'',0,72,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(157,16,'Poti mit Achse 10k linear','',1,1,'Kunststoff',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(158,16,'Poti mit Achse 220k linear','',1,1,'Kunststoff',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(159,16,'Trimmer 100k weiss','',1,1,'',0,34,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(160,16,'Trimmer 10k weiss','',3,1,'',0,34,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(161,16,'Trimmer 10k stehend linear','',1,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(162,16,'Trimmer 100k liegend linear','',3,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(163,16,'Mini-Trimmer 1k liegend','',4,1,'linear',0,24,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(164,16,'Mini-Trimmer 10k liegend','',5,5,'linear',0,24,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(165,16,'Mini-Trimmer 100k liegend','',3,1,'linear',0,24,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(166,16,'Mini-Trimmer 100k stehend','',2,1,'linear',0,24,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(167,16,'Mini-Trimmer 10k stehend','',4,1,'linear',0,24,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(168,55,'IC-Sockel 40Pol','',3,2,'Distrelec 651933 breit 1.10Fr',0,13,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(169,55,'IC-Sockel 32Pol','',3,2,'',0,25,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(170,63,'B40R','Brückengleichrichter',3,1,'',0,66,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(171,113,'Drahtwiderstand 0.47Ohm 5W','',2,2,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(172,65,'TSOP1738','',1,1,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(173,65,'TSOP1736','',2,1,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(174,17,'Induktivität axial 0.1mH 1.62A','',2,1,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(175,15,'Kerko 100nF 50V/100V','',10,8,'Conrad 453099 50V\r\nDistrelec 833111 100V',0,59,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(176,125,'Laborkabel mit Krokodilklemmen beidseitig','',10,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(177,32,'Schutzhaube zu Sicherungshalter 5x20mm','',3,1,'',0,NULL,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(178,74,'FT232RL','USB-Seriell Wandler',1,2,'',0,30,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(179,121,'Lötzinn Bleifrei 1.0mm Sn99/Cu1 100g','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(180,120,'Lötlack SK10 400ml','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(181,120,'Schutzlack Urethan 200ml','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(182,17,'Induktivität axial 0.01mH 1.4A','',1,0,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(183,125,'Experimentierplatte','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(184,67,'Ethernet Buchse m. Übertrager','',1,1,'',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(185,68,'LDO-Spannungsregler 3.3V','',2,2,'LD1117V33\r\nOder besser 645487',0,28,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(186,11,'Resonator 10MHz','',3,1,'noch nicht inventiert!',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(187,11,'Resonator 16MHz','',5,3,'noch nicht inventiert!',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(188,121,'Lötzinn-Absauger 200mm','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(189,121,'Aktivator für Lötspitzen Bleifrei','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(190,121,'Lötzinn Bleifrei 100g 0.5mm','',1,1,'Sn95.5/Ag3.8/Cu0.7',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(191,121,'Lötspitze Punktform für WHS-M','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(192,125,'Jumperkabel für Steckbrett KS-30','',1,1,'1 Pack = 75 Stk = 7.20Fr',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(193,122,'Hartmetall Speerbohrer 0.8mm','',2,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(194,69,'Steckernetzteil 5V 1200mA','',2,1,'514221',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(195,41,'Handgehäuse Plastik 66x66x28 Schwarz','',1,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(196,70,'Lautsprecher 5cm 8Ohm','',0,0,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(197,72,'LCD-Rahmen für 4x16 Display','',1,0,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(198,15,'Kerko 470pF 100V','',3,1,'',0,58,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(199,76,'TDA7052','NF-Verstärker',1,1,'',0,4,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(200,76,'LM386','Verstärker',1,0,'',0,46,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(201,127,'Weisse Schublade 24 Fächer','',5,0,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(202,78,'Drehknopf mit seitl. Befestigung','',0,0,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(203,54,'Hartpapier-Platine 100x100mm Einseitig Cu','',7,3,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(204,79,'Inkrementalgeber Vertikal','',0,0,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(205,117,'DCF77 Baustein','',0,0,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(206,127,'Isolierband 15mm 10m Schwarz','',3,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(207,40,'USB-Gehäuse Transparent','',1,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(208,27,'USB-Stecker Print Typ A Flach','',1,1,'',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(209,54,'Epoxyd-Platine 75x100mm Einseitig Cu','',0,0,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(210,55,'IC-Sockel 14Pol','',7,2,'',0,7,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(211,123,'Schrumpfschlauch 2.4','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(212,123,'Schrumpfschlauch 1.6','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(213,123,'Schrumpfschlauch 3.2','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(214,123,'Schrumpfschlauch 4.7','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(215,126,'Litze 0.14mm2 Schwarz','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(216,126,'Litze 0.14mm2 Rot','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(217,54,'Platine Punktraster 160x100mm','',1,1,'Distrelec 450124 5.50Fr',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(218,73,'LCD Positiv LED Weiss 16x4','',0,0,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(219,79,'Inkrementalgeber STEC12E08','',0,0,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(220,81,'Fotowiderstand A9060','',1,1,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(221,82,'LED 10mm Weiss','',3,0,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(222,78,'Drehknopf mit seitl. Befestigung Nr2','',0,0,'6mm',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(223,120,'Schutzlack Plastik 70 200ml','',0,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(224,120,'Reinigungsspray Kontakt LR 200ml','',0,0,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(225,121,'Entlötsauglitze','',1,1,'Reichelt ENTLÖTLITZE AB',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(226,83,'Kartenslot MMC12 SMD','',1,1,'',0,38,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(227,11,'Quarz 12.2889MHz','',4,1,'',0,36,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(228,76,'TDA7053','Audio-Verstärker',3,1,'',0,8,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(229,84,'Batterieclip 9V Block Robust','',2,0,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(230,84,'Batterieclip 9V Block','',4,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(231,84,'Batterieclip 9V Block T-Form','',4,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(232,85,'VS1011E-S','MP3-Decoder',2,1,'',0,39,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(233,61,'Batteriehalter 9V Block','',2,1,'',0,NULL,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(234,61,'Batteriehalter 4xAA Schwarz','',3,1,'',0,NULL,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(235,61,'Batteriehalter 9V oder 2xAA Einbau Schwarz','',1,0,'',0,NULL,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(236,115,'Tantal Kondensator 0,22uF 35V','',5,1,'',0,59,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(237,15,'Kerko 27pF 100V','',12,0,'',0,59,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(238,15,'Kerko 220pF 100V','',4,1,'',0,59,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(239,15,'Kerko 33pF ','',10,2,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(240,86,'LED 8mm Gelb-Orange 360°','',1,1,'',0,1,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(241,86,'LED 8mm Weiss 360°','',2,2,'',0,1,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(242,36,'Molex Stiftleiste 3Pol 90°','',5,1,'',0,107,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(243,21,'Stiftleiste 2x5Pol abgewinkelt mit Rahmen','',2,2,'',0,79,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(245,17,'Drossel 1uH','',2,1,'',0,18,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(246,17,'Drossel 100uH','',2,1,'',0,18,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(247,87,'Bipolarer Kondensator 10uF','',2,1,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(248,87,'Bipolarer Kondensator','',2,1,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(249,87,'Bipolarer Kondensator 100uF','',2,1,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(250,14,'Folienkondensator MKS4 470nF 63V','',5,1,'',0,72,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(251,14,'Folienkondensator MKS4 47nF 100V','',5,1,'',0,72,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(252,17,'Drossel 10uH 410mA','',2,1,'',0,18,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(253,90,'Kabeldurchführung mit Knickschutz 5,8mm soft','',3,2,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(254,90,'Zugentlastungsklemme','',2,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(255,70,'Lauttsprecher 8cm 15W 4Ohm','',1,0,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(256,70,'Lauttsprecher 8cm 50W 4Ohm','',1,0,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(257,92,'Printnetzteil Traco Power 12VDC 833mA','',1,0,'TML 10112 / 230VAC /\r\nBauteil in Eagle vorhanden',0,1,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(258,59,'Optotriac MOC3052M','',3,1,'',0,3,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(259,90,'Knickschutztülle 6.5mm','',4,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(260,56,'Stereo-Klinkenstecker 3,5mm','',3,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(261,59,'Optokoppler 4N25','',5,1,'',0,3,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(262,90,'Knickschutztülle 5,5mm','',4,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(263,90,'Zugentlastungsklemme','',3,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(264,90,'Knickschutztülle 3,5mm','',4,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(265,91,'Schaltregler Traco Power 5VDC 1A','',2,0,'TSR 1-2450',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(266,14,'Folienkondensator MKS4 1uF 100V','',4,1,'100VDC/63VAC',0,72,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(267,93,'Folienkondensator MKP X2 10nF 275VAC','',5,1,'Für Sniffer',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(268,112,'Metalloxydschicht-Widerstand 18 Ohm 1W','',6,1,'5%',0,18,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(269,112,'Metalloxydschicht-Widerstand 100 kOhm 1W','',4,1,'',0,18,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(270,112,'Metalloxydschicht-Widerstand 47 kOhm 1W','',4,1,'',0,18,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(271,112,'Metalloxydschicht-Widerstand 15 Ohm 1W','',6,1,'',0,18,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(272,38,'Sub-D Stecker 9Pol','',5,2,'Anschlüsse sind nicht beschriftet',0,89,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(273,40,'Sub-D Steckergehäuse 9Pol','',5,2,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(274,38,'Sub-D Buchse 9Pol','',5,2,'Anschlüsse sind nicht beschriftet',0,89,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(275,95,'Gehäusefüsse PU klar selbstklebend','',20,4,'',0,NULL,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(276,96,'Distanzhülse d=3mm l=10mm','',20,4,'',0,NULL,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(277,96,'Distanzhülse d=3mm l=25mm','',20,4,'',0,NULL,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(278,96,'Distanzhülse d=3mm l=30mm','',20,4,'',0,NULL,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(279,55,'IC-Sockel 6Pol','',4,2,'',0,3,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(280,97,'Tischgehäuse Kunststoff 135x95x45 grau','',2,0,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(281,55,'Quarz-Sockel','',2,1,'',0,36,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(282,98,'Druckabhängiger Widerstand','',2,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(283,114,'Joystick-Poti mit Taster','',1,1,'',0,62,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(284,114,'Joystick-Poti ohne Taster','',1,1,'',0,62,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(285,78,'Joystick-Knüppel','',2,2,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(286,96,'Gewindebolzen für Sub-D mit Muttern','',5,2,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(287,96,'Gewindebolzen Sub-D','',4,2,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(288,19,'Printklemme 2,5mm2 2pol','',4,4,'Distrelec 129503',0,58,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(289,19,'Printklemme 2,5mm2 3pol','',8,4,'',0,58,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(290,99,'TMC428-I','IC Trinamic',1,1,'',0,40,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(291,101,'60MM SCHRITTMOTOR, 1.8°, 2.8A, 2.1 NM ','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(292,99,'TMC249A-SA','STEPPER TREIBER 4 A SG',1,1,'',0,41,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(293,89,'BSS83P','P-Mosfet Kleinleistung 60V 0,33A',4,2,'',0,47,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(294,89,'IR2101S','Mosfet-Treiber',2,1,'',0,46,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(295,100,'ICM7555','Taktgeber',2,1,'',0,4,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(296,15,'Kerko Sortiment','',1,1,'',0,71,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(297,14,'Folienkondensator MKS2 220nF 100V','',10,5,'',0,58,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(298,14,'FolienkondensatorMKS4 1uF 63V','',5,4,'',0,72,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(299,64,'Widerstand 0,1R 3W','',9,2,'',0,38,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(300,113,'Widerstand 0,1 Ohm 5W','',4,2,'',0,62,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(301,44,'MBRS1100','Schottky-Diode 1A 100V',10,4,'',0,56,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(302,44,'SB3100','Schottky-Diode 3A 100V',10,5,'',0,61,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(303,44,'SB150','Schottky-Diode 1A 50V',10,5,'',0,57,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(304,44,'SB190','Schottky-Diode 1A 90V',10,5,'',0,57,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(305,111,'Null-Ohm Widerstand 0207','',20,5,'',0,18,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(306,127,'Widerstands-Uhr','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(307,62,'Widerstandssortiment','',1,1,'',0,50,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(308,89,'IRLR120N','N-Mosfet 100V 10A',5,2,'',0,42,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(309,13,'Elko 1000uF 63V','',5,2,'RM7.5 / D=16\r\nConrad 442156',0,72,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(310,99,'TMC428-PI24','Stepper Controller ',0,0,'',0,43,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(311,42,'MUR860G','Diode 600V 8A',2,2,'Gleichrichterdiode',0,28,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(312,89,'IRF9520NPBF','P-Mosfet 55V 6.8A',3,2,'',0,28,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(313,13,'SMD Elko 10uF 16V','',10,3,'Conrad 445124',0,96,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(314,15,'Kerko 220nF 25V','',20,5,'',0,71,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(315,13,'Elko 100uF 16V SMD','',10,4,'',0,95,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(316,14,'Folienkondensator MKS2 22nF 250V','',10,4,'Distrelec 828022',0,58,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(317,6,'SMD-Widerstand 10 Ohm 2W','',8,4,'',0,38,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(318,64,'Widerstand 0,15R 3W','',8,2,'',0,45,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(319,63,'GBPC 2510W','Brückengleichrichter 700V 25A',1,1,'',0,65,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(320,102,'Ringkerntrafo 300VA 230V/2x15V','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(321,103,'SD-Kartenslot SMD Distrelec_1','',2,1,'ALPS',0,38,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(322,103,'SD-Kartenslot SMD Distrelec_2','',2,1,'3M',0,38,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(323,103,'MicroSD-Kartenslot','',2,1,'',0,38,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(324,99,'L6203','Motortreiber 4A',3,4,'',0,67,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(325,19,'Stecker 2Pol RM5.08','',4,2,'',0,58,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(326,19,'Steckerbuchse 2Pol RM5.08','',4,2,'',0,58,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(327,70,'Lautsprecherabdeckung FRS8','',1,0,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(328,19,'Stecker 4pol RM5.08','',3,1,'',0,58,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(329,19,'Steckerbuchse 4pol RM5.08','',3,1,'',0,58,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(330,104,'Kühlkörper Multiwatt zum klammern','',2,0,'5.6K/W\r\n37.5mm lang',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(331,104,'Aufsteckkühlkörper TO220','',4,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(332,104,'Aufsteckkühlkörper TO220 Breit','',4,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(333,127,'Wärmeleitpaste 10ml Spritze','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(334,99,'L6506','Schrittmotor-Chopper',4,1,'',0,9,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(335,27,'USB-2.0 Buchse Typ B','',5,1,'',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(336,70,'Lauttsprecher 8cm 15W 8Ohm','',0,0,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(337,59,'Optokoppler Schnell 6N138','',8,2,'z.B. für UART optisch trennen',0,4,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(338,104,'Wärmeleitfolie 70/50 TO220 0,25mm','',6,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(339,104,'Wärmeleitfolie 70/50 TO247 0,25mm','',6,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(340,105,'P6KE15CA','Suppressordiode 12V Bidirektional',4,1,'',0,31,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(341,105,'P6KE6V8CA','Suppressordiode  5V Bidirektional',7,1,'P6KE6V8CA',0,31,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(342,105,'P6KE68CA','Suppressordiode  68V Bidirektional',4,1,'',0,31,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(343,44,'SB850','Schottky-Gleichrichterdiode 8A 50V',8,2,'D5,4mm\r\nL7,5mm',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(344,42,'P2000G','Diode 400V 20A',8,2,'Semikron',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(345,42,'P1000D','Diode 10A 200V',10,2,'Semikron',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(346,113,'Widerstand Draht 0,1 Ohm, 50W, 5%','',1,0,'',0,1,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(347,89,'IRLR7843','N-Mosfet 30V 113A',10,2,'Conrad 164398',0,42,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(348,42,'BAS21','Diode 200V 0,25A',20,2,'',0,47,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(349,106,'LM-393N','OPV',5,1,'',0,4,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(350,89,'IR2102','Mosfet-Treiber',1,1,'',0,4,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(351,89,'IR2103','Mosfet-Treiber',1,1,'',0,4,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(352,106,'LM358','OPV 2-fach ',5,1,'',0,46,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(353,124,'Sicherungshalter mit Kabel','',3,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(354,8,'BC817','Transistor',10,2,'',0,47,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(355,32,'Sicherungshalter freiliegend Printmontage','',10,2,'',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(356,50,'LED SMD0805 Gelb','',15,2,'',0,103,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(357,50,'LED SMD0805 Rot','',15,2,'',0,103,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(358,50,'LED SMD0805 Grün','',15,2,'',0,103,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(359,70,'Piepser SMD','',2,1,'',0,38,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(360,11,'Quarz 16MHz SMD','',2,1,'',0,37,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(361,52,'KIA78M05F','Spannungsregler 5V',6,2,'',0,42,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(362,11,'Quarz 16MHz HC-49/US-SMD','',4,1,'',0,37,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(363,13,'Elko Rad. 105°C 1uF 100V','',20,2,'',0,59,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(364,13,'Elko Rad. 105°C 0,1uF 50V','',20,2,'',0,88,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(365,13,'Elko Rad. 105°C 10uF 100V','',20,2,'',0,59,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(366,10,'ATMega168-20AU','Mikrocontroller',2,1,'Distrelec 645165',0,69,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(367,62,'Widerstand 10k 0,1W','',50,5,'7.30Fr/100',0,50,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(368,62,'Widerstand 1k 0,1W','',50,5,'7.30Fr/100',0,50,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(369,52,'L79L05ACZ','Spannungsregler -5V',2,1,'0.85Fr',0,29,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(370,107,'VS-Kondensator 1uF X7R','',20,3,'',0,70,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(371,78,'Drehknopf Pressbefestigung blau 12/4mm','',1,0,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(372,22,'Printtaster SMD viereckiger Stössel','',1,1,'',0,38,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(373,22,'Printtaster SMD rund langer Stössel','',1,1,'',0,38,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(374,22,'Printtaster mit Stössel rund','',1,1,'',0,1,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(375,10,'ATTiny45-20PU','Mikrocontroller',6,1,'',0,4,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(376,108,'Lampenfassung E10 Lötstifte RM10','',4,1,'',0,1,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(377,108,'Glühlampe E10 12V 200mA Weiss','',4,1,'',0,NULL,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(378,10,'ATMega32-16PU','Mikrocontroller',1,1,'',0,13,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(379,10,'ATMega88-20AU','Mikrocontroller',3,1,'Distrelec 645163',0,69,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(380,10,'ATMega88-20PU','Mikrocontroller',3,1,'',0,12,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(381,68,'LDO-Spannungsregler 5V 200mA SOT89','',5,2,'',0,48,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(382,89,'IR2104SPBF','Mosfet-Treiber ',4,1,'',0,46,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(383,52,'L7905CV','Spannungsregler -5V',3,1,'',0,28,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(384,52,'TS78L05CT','Spannungsregler 5V',6,1,'',0,29,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(385,68,'LD1117DT25','LDO-Spannungsregler 2,5V',3,1,'',0,42,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(386,16,'Cermet-Poti 10k lin SMC-10-V mit Achse, stehend','',3,1,'',0,24,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(387,13,'Elko radial 470uF 16V','',8,1,'',0,87,1,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(388,15,'Kerko 100nF 50V','',50,10,'Conrad 445544',0,71,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(389,35,'Linsenkopfschraube M3x10','',100,10,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(390,35,'Linsenkopfschraube M3x6','',100,10,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(391,19,'Printklemme 10Pol','',3,1,'',0,87,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(392,109,'Flachbandkabel 16Pol','',3,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(393,47,'LED Rot 3mm','',20,5,'',0,90,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(394,73,'LCD 4x20 Grün/Gelb mit LED','',1,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(395,73,'LCD 2x16 Grün/Gelb mit LED','',1,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(396,106,'TS912IN','OPV',2,1,'',0,4,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(397,111,'Widerstand 10k 0207','',82,10,'',0,18,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(398,13,'Elko 100uF 16V','',20,2,'',0,59,1,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(399,100,'KMZ-51','Magnetfeldsensor',1,1,'',0,46,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(400,106,'LM324N','OPV',4,1,'',0,7,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(401,110,'Nieten für Durchkontaktierungen 0.6mm','',1000,10,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(402,98,'Heissleiter NTC 10R','',1,1,'',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(403,98,'Heissleiter NTC 5R','',1,1,'',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(404,98,'Heissleiter NTC 2.5R','',1,1,'',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(405,98,'Heissleiter NTC 22R','',1,1,'',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(406,121,'Lötzinn Bleihaltig 1mm 100g','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(407,11,'Resonator 16MHz KR16.00MCB5T','',5,1,'',0,38,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(408,22,'Printtaster miniatur mit viereckigem Stössel','',5,1,'',0,62,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(409,26,'Print-Kippschalter liegend on-on 1P','',4,1,'',0,62,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(410,26,'Tastkappe 4x4mm','',5,1,'',0,NULL,8,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(411,109,'Litze Silikongummi 1mm2 schwarz','',2,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(412,109,'Litze Silikongummi 1mm2 rot','',2,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(413,109,'Litze Silikongummi 1mm2 blau','',2,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(414,70,'Piezo-Signalgeber KPEG-242','',2,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(415,70,'Piezo-Signalgeber KPEG-260','',1,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(416,70,'Summer KXG1205C','',2,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(417,100,'BTS555','Leistungsschalter',2,1,'',0,68,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(418,10,'ATTiny84V-10PU','Mikrocontroller',2,1,'',0,7,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(419,11,'Resonator 16MHz CSTCE16','',5,1,'',0,38,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(420,64,'Präzisionswiderstand 0,02R 5W','',3,2,'Isabellenhütte SMT-R020-1.0',0,38,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(421,64,'Präzisionswiderstand 0,05R 5W','',5,1,'Isabellenhütte SMT-R050-1.0',0,38,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(422,13,'Elko 330uF 25V','',8,1,'',0,87,1,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(423,127,'Pinzette mit Umkehrfunktion','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(424,91,'Schaltregler Traco Power 3,3VDC 1A','',1,1,'',0,28,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(425,62,'Widerstand 15R 0,1W','',50,10,'',0,50,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(427,62,'Widerstand 4,7k 0,1W','',50,5,'',0,50,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(428,121,'Lötzinn Bleihaltig 0.5mm 100g','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(429,112,'Metallschichtwiderstand 10R 1W','',10,2,'',0,52,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(430,14,'Folienkondensator MSK2 15nF 100VDC','',20,2,'',0,58,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(431,16,'Mini-Trimmer 1k stehend','',4,2,'',0,24,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(432,109,'Flachbandkabel 10Pol','',2,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(433,122,'Hartmetall Speerbohrer 1,3mm','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(434,122,'Hartmetall Speerbohrer 1,0mm','',1,1,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(435,127,'Sortimentsbox 24 Fächer klar','',5,0,'',0,NULL,9,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(437,115,'Kondensator Tantal 47uF 10VDC','',7,4,'',0,54,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(438,62,'Widerstand 0R 0,1W','',30,5,'',0,50,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(439,116,'Stiftleiste Molex SMD 6Pol 90°','',4,2,'PicoBlade',0,55,10,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(440,116,'Stiftleiste Molex SMD 2Pol 90°','',2,2,'PicoBlade',0,55,10,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(441,116,'Stiftleiste Molex SMD 3Pol 90°','',2,2,'PicoBlade',0,55,10,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(442,116,'Stiftleiste Molex SMD 5Pol 90°','',2,2,'PicoBlade',0,55,10,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(443,116,'Stiftleiste Molex SMD 5Pol','',2,2,'PicoBlade',0,55,10,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(444,116,'Stiftleiste Molex SMD 4Pol','',2,2,'PicoBlade',0,55,10,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(445,116,'Stiftleiste Molex SMD 3Pol','',4,2,'PicoBlade',0,55,10,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(446,116,'Stiftleiste Molex SMD 2Pol','',4,2,'PicoBlade',0,55,10,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(447,116,'Buchse Molex SMD 2Pol','',6,2,'PicoBlade',0,NULL,10,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(448,116,'Buchse Molex SMD 3Pol','',6,2,'PicoBlade',0,NULL,10,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(449,116,'Buchse Molex SMD 4Pol','',2,2,'PicoBlade',0,NULL,10,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(450,116,'Buchse Molex SMD 5Pol','',4,2,'PicoBlade',0,NULL,10,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(451,116,'Crimpkontakt Molex SMD','',30,5,'PicoBlade',0,NULL,10,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(452,105,'P6SMBJ33A','Suppressordiode 33V 600W Unidirektional',5,1,'',0,56,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(453,59,'Optokoppler 6N137','',4,1,'',0,4,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(454,59,'Optokoppler HCPL-0600','',2,1,'SMD-Variante von 6N137\r\n\r\nConrad 140053, gleicher Preis',0,46,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(455,13,'Elko Rad. 105°C 680uF 25VDC LowESR','',5,1,'Conrad 442611 D13\r\nDistrelec 801847 D10,5',0,58,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(456,117,'TV TrickleSaver','',1,0,'',0,NULL,NULL,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(457,59,'Optokoppler HCPL-0500','',4,1,'',0,46,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(458,105,'SMAJ24A','Suppressordiode 24V 400W Unidirektional',4,1,'',0,63,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(459,62,'Widerstand 10R 0,1W','',10,4,'',0,50,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(460,62,'Widerstand 180R 0,1W','',10,2,'',0,50,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(461,62,'Widerstand 390R 0,1W','',10,4,'',0,50,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(462,62,'Widerstand 220R 0,1W','',10,4,'',0,50,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(463,62,'Widerstand 15k 0,1W','',10,4,'',0,50,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(464,62,'Widerstand 2,2k 0,1W','',10,4,'',0,50,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(465,62,'Widerstand 47k 0,1W','',10,4,'',0,50,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(466,62,'Widerstand 18k','',10,4,'',0,50,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(467,62,'Widerstand 680R 0,1W','',10,4,'',0,50,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(468,62,'Widerstand 120R','',10,4,'',0,50,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(469,15,'Kerko 1uF 50V','',5,2,'',0,70,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(470,62,'Widerstand 47R 0,1W','',10,4,'',0,50,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(471,118,'Platine für Brushless-Controller v14','',0,0,'Preis geschätzt',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(472,62,'Widerstand 24k 0,1W','',10,4,'',0,50,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(473,62,'Widerstand 2,8k 0,1X','',10,4,'',0,50,NULL,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(474,35,'Mutter M3 Stahl mit Sicherungsring','',100,5,'',0,NULL,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(475,59,'Optokoppler HCPL-181','',5,2,'',0,82,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(476,68,'LM1117','LDO-Spannungsregler 3,3V 0,8A',4,2,'LM1117MP-3.3/NOPB',0,83,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(477,74,'ENC28J60/SO','Ethernet-Controller',2,1,'',0,39,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(478,115,'Kondensator Tantal 10uF 6,3VDC','',6,2,'',0,84,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(479,119,'LL4148','Diode 75V 150mA',10,2,'',0,85,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(480,118,'Platine für Micro-SD-2-DIL Adapter v1','',4,1,'Preis geschätzt',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(481,118,'Platine für SPI-2-DIL Adapter v1','',0,1,'Preis geschätzt',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(482,118,'Platine für ENC28J60-Modul v2','',4,1,'Preis geschätzt',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(483,118,'Platine für SO8-2-DIL Adapter v1','',4,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(484,118,'Platine für UART-2-DIL Adapter v1','',4,1,'Preis geschätzt',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(485,118,'Platine für PowerJack-2-DIL Adapter v1','',4,1,'Preis geschätzt',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(486,62,'Widerstand 3,3k 0,1W','',10,2,'',0,50,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(487,62,'Widerstand 1,8k 0,1W','',10,2,'',0,50,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(488,62,'Widerstand 51R 0,2W','',10,2,'',0,50,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(489,62,'Widerstand 2,4k 0,2W','',10,2,'',0,50,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(490,17,'Induktivität SMCC 22uH 560mA','',3,1,'',0,18,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(491,62,'Widerstand 150R 0,1W','',10,2,'',0,50,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(492,15,'Kerko 22pF 50V','',10,2,'',0,71,12,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(493,11,'Quarz 25MHz','',0,1,'',0,37,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(494,115,'Kondensator Tantal 100uF 10VDC','',6,2,'',0,86,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(495,115,'Kondensator Tantal 100uF 6,3V','',5,2,'',0,54,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(496,117,'Evaluationsboard STM32 Value Line Discovery','',1,1,'',0,NULL,NULL,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(497,78,'Drehknopf ohne Strich schwarz 20mm','',1,0,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(498,78,'Deckel ohne Strich schwarz 20mm','',1,0,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(499,16,'Cermet-Poti 1k lin SMC-10-V mit Achse, stehend','',1,1,'',0,24,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(500,16,'Cermet-Poti 100k lin SMC-10-V mit Achse, stehend','',1,1,'',0,24,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(501,16,'Cermet-Poti 5k lin SMC-10-V mit Achse, stehene','',1,1,'',0,24,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(502,104,'Lüfter 12VDC 80mm','',1,0,'',0,NULL,NULL,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(503,120,'Reinigungsspray Kontakt LR 400ml','',1,1,'',0,NULL,NULL,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(504,116,'Buchse Molex SMD 6Pol','',4,2,'',0,NULL,10,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(505,128,'7-Segnemt Anzeige 25mm CA Rot schwach','',6,1,'Farbe ist sehr schwach! Besser nicht mehr kaufen.',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(506,129,'Miniaturtaster mit Hebel','',2,0,'',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(507,69,'Steckernetzteil 5V 1A','',1,0,'',0,NULL,NULL,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(508,128,'7-Segment Anzeige 25mm Superrot','',4,1,'',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(509,111,'56R','Widerstand',50,5,'',0,18,6,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(510,92,'Netzteil Traco +5/+15/-15VDC 30W','',1,1,'TMP 30515C',0,NULL,NULL,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(511,130,'Kaltgerätebuchse mit Sicherung','',1,1,'Anschlüsse: Faston 4.8 x 0.8 mm',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(512,131,'Laborbuchsen rot/schwarz 4mm','',1,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(513,97,'Tischgehäuse 108x178x198','',1,1,'',0,NULL,NULL,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(514,132,'Flachsteckhülse isoliert 4,8x0,8 1,5q','',10,4,'',0,NULL,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(515,132,'Flachsteckhülse isoliert 6.3x0,8 1,5q','',10,4,'',0,NULL,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(516,132,'Ringkabelschuh M4 isoliert 1,5mm2','',10,4,'',0,NULL,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(517,132,'Ringkabelschuh M3 isoliert 1,5mm3','',10,4,'',0,NULL,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(518,132,'Ringkabelschuh M5 isoliert 1,5mm4','',10,4,'',0,NULL,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(520,133,'Wippschalter 250VAC, mit Lampe','',1,1,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(521,106,'LM6172','OPV 2fach schnell',2,1,'LM6172IN/NOPB\r\n100 MHz\r\n3000 V/us',0,4,NULL,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(522,25,'Print-Druckschalter 1P','',1,1,'Kappe auch mitbestellen! 208404',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(523,11,'Resonator 20MHz','',4,1,'',0,62,7,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(524,16,'Kohle-Potentiometer lin 50k klein','',1,1,'',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(525,16,'Kohle-Potentiometer lin 10k kleio','',1,1,'',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(526,16,'Kohle-Potentiometer lin 1k kleip','',1,1,'',0,62,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(530,48,'L-59EGW','Bi-Color LED 5mm rot/grün',5,1,'',0,91,2,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(531,132,'MPNYD 1-156','Rundsteckverbinder rot Stecker',30,5,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(532,132,'FRFNYD 1-157','Rundsteckverbinder rot Hülse',30,5,'',0,NULL,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(533,105,'P6KE20CA','Schutzdiode 20V 600W bidirektional',5,1,'',0,57,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(534,52,'L78L09ACZ','Spannungsregler 9V',3,1,'',0,29,3,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42'),(535,128,'SA39-11EWA','7-Segment LED 9,9mm superrot',5,1,'',0,109,4,NULL,1,0,NULL,NULL,'','2016-03-29 15:46:42','2016-03-29 15:46:42');
/*!40000 ALTER TABLE `parts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pricedetails`
--

DROP TABLE IF EXISTS `pricedetails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pricedetails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orderdetails_id` int(11) NOT NULL,
  `price` decimal(9,5) DEFAULT NULL,
  `price_related_quantity` int(11) NOT NULL DEFAULT '1',
  `min_discount_quantity` int(11) NOT NULL DEFAULT '1',
  `manual_input` tinyint(1) NOT NULL DEFAULT '1',
  `last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pricedetails_combination_uk` (`orderdetails_id`,`min_discount_quantity`),
  KEY `pricedetails_orderdetails_id_k` (`orderdetails_id`)
) ENGINE=InnoDB AUTO_INCREMENT=512 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pricedetails`
--

LOCK TABLES `pricedetails` WRITE;
/*!40000 ALTER TABLE `pricedetails` DISABLE KEYS */;
INSERT INTO `pricedetails` VALUES (1,1,11.95000,1,1,1,'2016-03-29 15:46:15'),(2,3,14.95000,1,1,1,'2016-03-29 15:46:15'),(3,4,4.35000,1,1,1,'2016-03-29 15:46:15'),(4,5,9.95000,1,1,1,'2016-03-29 15:46:15'),(5,7,0.20000,1,1,1,'2016-03-29 15:46:15'),(6,8,0.10000,1,1,1,'2016-03-29 15:46:15'),(7,9,2.15000,1,1,1,'2016-03-29 15:46:15'),(8,10,20.95000,1,1,1,'2016-03-29 15:46:15'),(9,11,16.95000,1,1,1,'2016-03-29 15:46:15'),(10,12,1.70000,1,1,1,'2016-03-29 15:46:15'),(11,13,0.55000,1,1,1,'2016-03-29 15:46:15'),(12,14,0.15000,1,1,1,'2016-03-29 15:46:15'),(13,15,0.30000,1,1,1,'2016-03-29 15:46:15'),(14,16,0.35000,1,1,1,'2016-03-29 15:46:15'),(15,17,9.30000,1,1,1,'2016-03-29 15:46:15'),(16,18,2.50000,1,1,1,'2016-03-29 15:46:15'),(17,19,2.10000,1,1,1,'2016-03-29 15:46:15'),(18,20,2.40000,1,1,1,'2016-03-29 15:46:15'),(19,21,0.70000,1,1,1,'2016-03-29 15:46:15'),(20,22,0.50000,1,1,1,'2016-03-29 15:46:15'),(21,23,3.80000,1,1,1,'2016-03-29 15:46:15'),(22,24,7.20000,1,1,1,'2016-03-29 15:46:15'),(23,25,10.80000,1,1,1,'2016-03-29 15:46:15'),(24,26,21.80000,1,1,1,'2016-03-29 15:46:15'),(25,27,17.20000,1,1,1,'2016-03-29 15:46:15'),(26,28,0.95000,1,1,1,'2016-03-29 15:46:15'),(27,29,0.90000,1,1,1,'2016-03-29 15:46:15'),(28,30,0.90000,1,1,1,'2016-03-29 15:46:15'),(29,31,2.40000,1,1,1,'2016-03-29 15:46:15'),(30,32,1.50000,1,1,1,'2016-03-29 15:46:15'),(31,33,1.00000,1,1,1,'2016-03-29 15:46:15'),(32,34,1.80000,1,1,1,'2016-03-29 15:46:15'),(33,35,1.40000,1,1,1,'2016-03-29 15:46:15'),(34,36,29.70000,1,1,1,'2016-03-29 15:46:15'),(35,37,2.10000,1,1,1,'2016-03-29 15:46:15'),(36,38,2.50000,1,1,1,'2016-03-29 15:46:15'),(37,39,5.70000,1,1,1,'2016-03-29 15:46:15'),(38,40,7.10000,1,1,1,'2016-03-29 15:46:15'),(39,41,7.00000,1,1,1,'2016-03-29 15:46:15'),(40,42,1.20000,1,1,1,'2016-03-29 15:46:15'),(41,43,5.20000,1,1,1,'2016-03-29 15:46:15'),(42,44,3.10000,1,1,1,'2016-03-29 15:46:15'),(43,45,0.90000,1,1,1,'2016-03-29 15:46:15'),(44,46,0.95000,1,1,1,'2016-03-29 15:46:15'),(45,47,1.10000,1,1,1,'2016-03-29 15:46:15'),(46,48,0.65000,1,1,1,'2016-03-29 15:46:15'),(47,49,0.75000,1,1,1,'2016-03-29 15:46:15'),(48,50,0.65000,1,1,1,'2016-03-29 15:46:15'),(49,51,0.65000,1,1,1,'2016-03-29 15:46:15'),(50,52,0.15000,1,1,1,'2016-03-29 15:46:15'),(51,53,30.20000,1,1,1,'2016-03-29 15:46:15'),(52,54,16.10000,1,1,1,'2016-03-29 15:46:15'),(53,55,21.60000,1,1,1,'2016-03-29 15:46:15'),(54,56,60.20000,1,1,1,'2016-03-29 15:46:15'),(55,57,7.20000,1,1,1,'2016-03-29 15:46:15'),(56,58,11.95000,1,1,1,'2016-03-29 15:46:15'),(57,59,13.95000,1,1,1,'2016-03-29 15:46:15'),(58,60,1.95000,1,1,1,'2016-03-29 15:46:15'),(59,61,6.45000,1,1,1,'2016-03-29 15:46:15'),(60,62,0.45000,1,1,1,'2016-03-29 15:46:15'),(61,63,6.45000,1,1,1,'2016-03-29 15:46:15'),(62,64,4.25000,1,1,1,'2016-03-29 15:46:15'),(63,65,1.15000,1,1,1,'2016-03-29 15:46:15'),(64,66,0.50000,1,1,1,'2016-03-29 15:46:15'),(65,67,0.75000,1,1,1,'2016-03-29 15:46:15'),(66,68,2.45000,1,1,1,'2016-03-29 15:46:15'),(67,69,10.95000,1,1,1,'2016-03-29 15:46:15'),(68,70,3.25000,1,1,1,'2016-03-29 15:46:15'),(69,71,3.25000,1,1,1,'2016-03-29 15:46:15'),(70,72,1.45000,1,1,1,'2016-03-29 15:46:15'),(71,73,1.15000,1,1,1,'2016-03-29 15:46:15'),(72,74,1.15000,1,1,1,'2016-03-29 15:46:15'),(73,75,1.15000,1,1,1,'2016-03-29 15:46:15'),(74,76,1.15000,1,1,1,'2016-03-29 15:46:15'),(75,77,8.95000,1,1,1,'2016-03-29 15:46:15'),(76,78,1.50000,1,1,1,'2016-03-29 15:46:15'),(77,79,1.85000,1,1,1,'2016-03-29 15:46:15'),(78,80,16.95000,1,1,1,'2016-03-29 15:46:15'),(79,81,20.95000,1,1,1,'2016-03-29 15:46:15'),(80,82,1.20000,1,1,1,'2016-03-29 15:46:15'),(81,83,3.45000,1,1,1,'2016-03-29 15:46:15'),(82,84,0.15000,1,1,1,'2016-03-29 15:46:15'),(83,85,0.15000,1,1,1,'2016-03-29 15:46:15'),(84,86,0.20000,1,1,1,'2016-03-29 15:46:15'),(85,87,0.95000,1,1,1,'2016-03-29 15:46:15'),(86,88,0.95000,1,1,1,'2016-03-29 15:46:15'),(87,89,0.95000,1,1,1,'2016-03-29 15:46:15'),(88,90,0.95000,1,1,1,'2016-03-29 15:46:15'),(89,91,0.95000,1,1,1,'2016-03-29 15:46:15'),(90,92,1.15000,1,1,1,'2016-03-29 15:46:15'),(91,93,1.65000,1,1,1,'2016-03-29 15:46:15'),(92,94,3.15000,1,1,1,'2016-03-29 15:46:15'),(93,95,3.75000,1,1,1,'2016-03-29 15:46:15'),(94,96,1.05000,1,1,1,'2016-03-29 15:46:15'),(95,97,0.25000,1,1,1,'2016-03-29 15:46:15'),(96,98,0.30000,1,1,1,'2016-03-29 15:46:15'),(97,99,1.95000,1,1,1,'2016-03-29 15:46:15'),(98,100,2.85000,1,1,1,'2016-03-29 15:46:15'),(99,101,1.45000,1,1,1,'2016-03-29 15:46:15'),(100,102,0.45000,1,1,1,'2016-03-29 15:46:15'),(101,103,1.45000,1,1,1,'2016-03-29 15:46:15'),(102,104,1.95000,1,1,1,'2016-03-29 15:46:15'),(103,105,0.85000,1,1,1,'2016-03-29 15:46:15'),(104,106,1.15000,1,1,1,'2016-03-29 15:46:15'),(105,107,1.95000,1,1,1,'2016-03-29 15:46:15'),(106,108,2.15000,1,1,1,'2016-03-29 15:46:15'),(107,109,3.15000,1,1,1,'2016-03-29 15:46:15'),(108,110,0.70000,1,1,1,'2016-03-29 15:46:15'),(109,111,2.65000,1,1,1,'2016-03-29 15:46:15'),(110,112,2.55000,1,1,1,'2016-03-29 15:46:15'),(111,113,2.75000,1,1,1,'2016-03-29 15:46:15'),(112,114,2.75000,1,1,1,'2016-03-29 15:46:15'),(113,115,2.45000,1,1,1,'2016-03-29 15:46:15'),(114,116,2.45000,1,1,1,'2016-03-29 15:46:15'),(115,117,3.95000,1,1,1,'2016-03-29 15:46:15'),(116,118,0.30000,1,1,1,'2016-03-29 15:46:15'),(117,119,5.75000,1,1,1,'2016-03-29 15:46:15'),(118,120,1.25000,1,1,1,'2016-03-29 15:46:15'),(119,121,1.35000,1,1,1,'2016-03-29 15:46:15'),(120,122,59.95000,1,1,1,'2016-03-29 15:46:15'),(121,123,6.75000,1,1,1,'2016-03-29 15:46:15'),(122,124,2.15000,1,1,1,'2016-03-29 15:46:15'),(123,125,4.05000,1,1,1,'2016-03-29 15:46:15'),(124,126,0.25000,1,1,1,'2016-03-29 15:46:15'),(125,127,8.95000,1,1,1,'2016-03-29 15:46:15'),(126,128,12.95000,1,1,1,'2016-03-29 15:46:15'),(127,129,12.95000,1,1,1,'2016-03-29 15:46:15'),(128,130,1.20000,1,1,1,'2016-03-29 15:46:15'),(129,131,9.00000,1,1,1,'2016-03-29 15:46:15'),(130,132,0.20000,1,1,1,'2016-03-29 15:46:15'),(131,133,0.90000,1,1,1,'2016-03-29 15:46:15'),(132,134,0.40000,1,1,1,'2016-03-29 15:46:15'),(133,135,0.20000,1,1,1,'2016-03-29 15:46:15'),(134,136,0.20000,1,1,1,'2016-03-29 15:46:15'),(135,137,15.00000,1,1,1,'2016-03-29 15:46:15'),(136,138,0.60000,1,1,1,'2016-03-29 15:46:15'),(137,139,0.40000,1,1,1,'2016-03-29 15:46:15'),(138,140,4.50000,1,1,1,'2016-03-29 15:46:15'),(139,141,1.15000,1,1,1,'2016-03-29 15:46:15'),(140,142,0.25000,1,1,1,'2016-03-29 15:46:15'),(141,143,0.25000,1,1,1,'2016-03-29 15:46:15'),(142,144,0.20000,1,1,1,'2016-03-29 15:46:15'),(143,145,4.95000,1,1,1,'2016-03-29 15:46:15'),(144,146,9.45000,1,1,1,'2016-03-29 15:46:15'),(145,147,0.35000,1,1,1,'2016-03-29 15:46:15'),(146,148,3.75000,1,1,1,'2016-03-29 15:46:15'),(147,149,3.65000,1,1,1,'2016-03-29 15:46:15'),(148,150,4.95000,1,1,1,'2016-03-29 15:46:15'),(149,151,53.00000,1,1,1,'2016-03-29 15:46:15'),(150,152,13.00000,1,1,1,'2016-03-29 15:46:15'),(151,153,14.00000,1,1,1,'2016-03-29 15:46:15'),(152,154,7.25000,1,1,1,'2016-03-29 15:46:15'),(153,155,2.50000,1,1,1,'2016-03-29 15:46:15'),(154,157,0.92000,1,1,1,'2016-03-29 15:46:15'),(155,159,0.11000,1,1,1,'2016-03-29 15:46:15'),(156,160,0.54000,1,1,1,'2016-03-29 15:46:15'),(157,161,0.15000,1,1,1,'2016-03-29 15:46:15'),(158,162,0.10000,1,1,1,'2016-03-29 15:46:15'),(159,163,0.25000,1,1,1,'2016-03-29 15:46:15'),(160,164,0.25000,1,1,1,'2016-03-29 15:46:15'),(161,165,3.35000,1,1,1,'2016-03-29 15:46:15'),(162,166,0.08000,1,1,1,'2016-03-29 15:46:15'),(163,167,0.08000,1,1,1,'2016-03-29 15:46:15'),(164,168,0.08000,1,1,1,'2016-03-29 15:46:15'),(165,169,0.08000,1,1,1,'2016-03-29 15:46:15'),(166,170,0.08000,1,1,1,'2016-03-29 15:46:15'),(167,171,0.08000,1,1,1,'2016-03-29 15:46:15'),(168,172,0.08000,1,1,1,'2016-03-29 15:46:15'),(169,173,0.08000,1,1,1,'2016-03-29 15:46:15'),(170,174,0.08000,1,1,1,'2016-03-29 15:46:15'),(171,175,0.08000,1,1,1,'2016-03-29 15:46:15'),(172,176,0.08000,1,1,1,'2016-03-29 15:46:15'),(173,177,0.08000,1,1,1,'2016-03-29 15:46:15'),(174,178,0.08000,1,1,1,'2016-03-29 15:46:15'),(175,179,0.08000,1,1,1,'2016-03-29 15:46:15'),(176,180,0.08000,1,1,1,'2016-03-29 15:46:15'),(177,181,4.54000,1,1,1,'2016-03-29 15:46:15'),(178,182,1.19000,1,1,1,'2016-03-29 15:46:15'),(179,183,1.84000,1,1,1,'2016-03-29 15:46:15'),(180,184,3.13000,1,1,1,'2016-03-29 15:46:15'),(181,185,0.15000,1,1,1,'2016-03-29 15:46:15'),(182,186,0.97000,1,1,1,'2016-03-29 15:46:15'),(183,187,1.40000,1,1,1,'2016-03-29 15:46:15'),(184,188,2.27000,1,1,1,'2016-03-29 15:46:15'),(185,189,2.70000,1,1,1,'2016-03-29 15:46:15'),(186,190,6.00000,1,1,1,'2016-03-29 15:46:15'),(187,191,0.81000,1,1,1,'2016-03-29 15:46:15'),(188,192,1.35000,1,1,1,'2016-03-29 15:46:15'),(189,194,6.45000,1,1,1,'2016-03-29 15:46:15'),(190,195,0.65000,1,1,1,'2016-03-29 15:46:15'),(191,196,0.50000,1,1,1,'2016-03-29 15:46:15'),(192,197,0.30000,1,1,1,'2016-03-29 15:46:15'),(193,198,0.30000,1,1,1,'2016-03-29 15:46:15'),(194,199,0.55000,1,1,1,'2016-03-29 15:46:15'),(195,200,0.95000,1,1,1,'2016-03-29 15:46:15'),(196,201,0.70000,1,1,1,'2016-03-29 15:46:15'),(197,202,2.16000,1,1,1,'2016-03-29 15:46:15'),(198,203,0.95000,1,1,1,'2016-03-29 15:46:15'),(199,204,1.30000,1,1,1,'2016-03-29 15:46:15'),(200,205,4.86000,1,1,1,'2016-03-29 15:46:15'),(201,206,0.60000,1,1,1,'2016-03-29 15:46:15'),(202,207,1.40000,1,1,1,'2016-03-29 15:46:15'),(203,208,1.45000,1,1,1,'2016-03-29 15:46:15'),(204,209,1.40000,1,1,1,'2016-03-29 15:46:15'),(205,210,0.55000,1,1,1,'2016-03-29 15:46:15'),(206,211,4.20000,1,1,1,'2016-03-29 15:46:15'),(207,212,6.48000,1,1,1,'2016-03-29 15:46:15'),(208,213,18.90000,1,1,1,'2016-03-29 15:46:15'),(209,214,18.95000,1,1,1,'2016-03-29 15:46:15'),(210,215,16.95000,1,1,1,'2016-03-29 15:46:15'),(211,216,17.95000,1,1,1,'2016-03-29 15:46:15'),(212,217,0.65000,1,1,1,'2016-03-29 15:46:15'),(213,218,0.90000,1,1,1,'2016-03-29 15:46:15'),(214,219,0.55000,1,1,1,'2016-03-29 15:46:15'),(215,220,2.38000,1,1,1,'2016-03-29 15:46:15'),(216,221,2.55000,1,1,1,'2016-03-29 15:46:15'),(217,222,0.86000,1,1,1,'2016-03-29 15:46:15'),(218,223,0.50000,1,1,1,'2016-03-29 15:46:15'),(219,224,1.85000,1,1,1,'2016-03-29 15:46:15'),(220,225,14.58000,1,1,1,'2016-03-29 15:46:15'),(221,226,10.95000,1,1,1,'2016-03-29 15:46:15'),(222,227,8.45000,1,1,1,'2016-03-29 15:46:15'),(223,228,12.96000,1,1,1,'2016-03-29 15:46:15'),(224,229,4.10000,1,1,1,'2016-03-29 15:46:15'),(225,230,5.51000,1,1,1,'2016-03-29 15:46:15'),(226,231,0.60000,1,1,1,'2016-03-29 15:46:15'),(227,232,129.95000,1,1,1,'2016-03-29 15:46:15'),(228,233,6.59000,1,1,1,'2016-03-29 15:46:15'),(229,234,3.35000,1,1,1,'2016-03-29 15:46:15'),(230,235,2.70000,1,1,1,'2016-03-29 15:46:15'),(231,236,1.25000,1,1,1,'2016-03-29 15:46:15'),(232,237,3.95000,1,1,1,'2016-03-29 15:46:15'),(233,238,1.65000,1,1,1,'2016-03-29 15:46:15'),(234,239,0.74000,1,1,1,'2016-03-29 15:46:15'),(235,240,1.26000,1,1,1,'2016-03-29 15:46:15'),(236,241,0.98000,1,1,1,'2016-03-29 15:46:15'),(237,242,1.05000,1,1,1,'2016-03-29 15:46:15'),(238,243,0.12000,1,1,1,'2016-03-29 15:46:15'),(239,244,3.48000,1,1,1,'2016-03-29 15:46:15'),(240,245,0.15000,1,1,1,'2016-03-29 15:46:15'),(241,246,0.20000,1,1,1,'2016-03-29 15:46:15'),(242,247,0.25000,1,1,1,'2016-03-29 15:46:15'),(243,248,0.51000,1,1,1,'2016-03-29 15:46:15'),(244,249,1.00000,1,1,1,'2016-03-29 15:46:15'),(245,250,1.05000,1,1,1,'2016-03-29 15:46:15'),(246,251,0.85000,1,1,1,'2016-03-29 15:46:15'),(247,252,0.85000,1,1,1,'2016-03-29 15:46:15'),(248,253,0.85000,1,1,1,'2016-03-29 15:46:15'),(249,254,14.95000,1,1,1,'2016-03-29 15:46:15'),(250,255,1.62000,1,1,1,'2016-03-29 15:46:15'),(251,256,0.19000,1,1,1,'2016-03-29 15:46:15'),(252,257,0.30000,1,1,1,'2016-03-29 15:46:15'),(253,258,0.49000,1,1,1,'2016-03-29 15:46:15'),(254,259,0.10000,1,1,1,'2016-03-29 15:46:15'),(255,260,0.10000,1,1,1,'2016-03-29 15:46:15'),(256,261,0.10000,1,1,1,'2016-03-29 15:46:15'),(257,262,0.92000,1,1,1,'2016-03-29 15:46:15'),(258,263,2.45000,1,1,1,'2016-03-29 15:46:15'),(259,264,2.05000,1,1,1,'2016-03-29 15:46:15'),(260,265,1.03000,1,1,1,'2016-03-29 15:46:15'),(261,266,57.95000,1,1,1,'2016-03-29 15:46:15'),(262,268,0.08000,1,1,1,'2016-03-29 15:46:15'),(263,269,0.08000,1,1,1,'2016-03-29 15:46:15'),(264,271,0.81000,1,1,1,'2016-03-29 15:46:15'),(265,272,0.08000,1,1,1,'2016-03-29 15:46:15'),(266,273,0.08000,1,1,1,'2016-03-29 15:46:15'),(267,274,1.62000,1,1,1,'2016-03-29 15:46:15'),(268,275,3.24000,1,1,1,'2016-03-29 15:46:15'),(269,276,2.00000,1,1,1,'2016-03-29 15:46:15'),(270,277,0.19000,1,1,1,'2016-03-29 15:46:15'),(271,278,1.50000,1,1,1,'2016-03-29 15:46:15'),(272,279,2.00000,1,1,1,'2016-03-29 15:46:15'),(273,280,1.50000,1,1,1,'2016-03-29 15:46:15'),(274,281,0.37000,1,1,1,'2016-03-29 15:46:15'),(275,282,0.37000,1,1,1,'2016-03-29 15:46:15'),(276,283,1.30000,1,1,1,'2016-03-29 15:46:15'),(277,284,0.08000,1,1,1,'2016-03-29 15:46:15'),(278,285,1.40000,1,1,1,'2016-03-29 15:46:15'),(279,286,1.30000,1,1,1,'2016-03-29 15:46:15'),(280,287,7.67000,1,1,1,'2016-03-29 15:46:15'),(281,288,0.59000,1,1,1,'2016-03-29 15:46:15'),(282,289,5.00000,1,1,1,'2016-03-29 15:46:15'),(283,290,21.60000,1,1,1,'2016-03-29 15:46:15'),(284,291,1.05000,1,1,1,'2016-03-29 15:46:15'),(285,292,3.35000,1,1,1,'2016-03-29 15:46:15'),(286,293,1.40000,1,1,1,'2016-03-29 15:46:15'),(287,294,3.10000,1,1,1,'2016-03-29 15:46:15'),(288,295,3.10000,1,1,1,'2016-03-29 15:46:15'),(289,296,3.10000,1,1,1,'2016-03-29 15:46:15'),(290,297,8.35000,1,1,1,'2016-03-29 15:46:15'),(291,298,3.25000,1,1,1,'2016-03-29 15:46:15'),(292,299,18.95000,1,1,1,'2016-03-29 15:46:15'),(293,300,0.35000,1,1,1,'2016-03-29 15:46:15'),(294,302,1.30000,1,1,1,'2016-03-29 15:46:15'),(295,303,1.46000,1,1,1,'2016-03-29 15:46:15'),(296,304,2.59000,1,1,1,'2016-03-29 15:46:15'),(297,305,0.97000,1,1,1,'2016-03-29 15:46:15'),(298,306,1.03000,1,1,1,'2016-03-29 15:46:15'),(299,307,0.81000,1,1,1,'2016-03-29 15:46:15'),(300,308,2.92000,1,1,1,'2016-03-29 15:46:15'),(301,309,1.03000,1,1,1,'2016-03-29 15:46:15'),(302,310,1.20000,1,1,1,'2016-03-29 15:46:15'),(303,311,0.04000,1,1,1,'2016-03-29 15:46:15'),(304,312,0.06000,1,1,1,'2016-03-29 15:46:15'),(305,313,0.90000,1,1,1,'2016-03-29 15:46:15'),(306,314,0.90000,1,1,1,'2016-03-29 15:46:15'),(307,315,0.90000,1,1,1,'2016-03-29 15:46:15'),(308,316,1.15000,1,1,1,'2016-03-29 15:46:15'),(309,317,1.15000,1,1,1,'2016-03-29 15:46:15'),(310,318,1.75000,1,1,1,'2016-03-29 15:46:15'),(311,319,1.05000,1,1,1,'2016-03-29 15:46:15'),(312,320,2.65000,1,1,1,'2016-03-29 15:46:15'),(313,321,2.65000,1,1,1,'2016-03-29 15:46:15'),(314,322,0.35000,1,1,1,'2016-03-29 15:46:15'),(315,323,0.30000,1,1,1,'2016-03-29 15:46:15'),(316,324,1.30000,1,1,1,'2016-03-29 15:46:15'),(317,325,0.45000,1,1,1,'2016-03-29 15:46:15'),(318,326,0.30000,1,1,1,'2016-03-29 15:46:15'),(319,327,0.20000,1,1,1,'2016-03-29 15:46:15'),(320,328,0.70000,1,1,1,'2016-03-29 15:46:15'),(321,329,0.15000,1,1,1,'2016-03-29 15:46:15'),(322,330,1.05000,1,1,1,'2016-03-29 15:46:15'),(323,331,1.73000,1,1,1,'2016-03-29 15:46:15'),(324,332,9.95000,1,1,1,'2016-03-29 15:46:15'),(325,333,9.95000,1,1,1,'2016-03-29 15:46:15'),(326,334,1.30000,1,1,1,'2016-03-29 15:46:15'),(327,335,1.94000,1,1,1,'2016-03-29 15:46:15'),(328,336,2.38000,1,1,1,'2016-03-29 15:46:15'),(329,337,2.40000,1,1,1,'2016-03-29 15:46:15'),(330,338,2.65000,1,1,1,'2016-03-29 15:46:15'),(331,339,0.90000,1,1,1,'2016-03-29 15:46:15'),(332,340,0.85000,1,1,1,'2016-03-29 15:46:15'),(333,341,0.35000,1,1,1,'2016-03-29 15:46:15'),(334,342,1.62000,1,1,1,'2016-03-29 15:46:15'),(335,343,0.20000,1,1,1,'2016-03-29 15:46:15'),(336,344,0.46000,1,1,1,'2016-03-29 15:46:15'),(337,345,0.71000,1,1,1,'2016-03-29 15:46:15'),(338,346,0.73000,1,1,1,'2016-03-29 15:46:15'),(339,347,4.97000,1,1,1,'2016-03-29 15:46:15'),(340,348,1.30000,1,1,1,'2016-03-29 15:46:15'),(341,349,4.25000,1,1,1,'2016-03-29 15:46:15'),(342,350,1.00000,1,1,1,'2016-03-29 15:46:15'),(343,351,1.40000,1,1,1,'2016-03-29 15:46:15'),(344,352,11.95000,1,1,1,'2016-03-29 15:46:15'),(345,353,30.24000,1,1,1,'2016-03-29 15:46:15'),(346,354,14.15000,1,1,1,'2016-03-29 15:46:15'),(347,355,17.01000,1,1,1,'2016-03-29 15:46:15'),(348,356,13.99000,1,1,1,'2016-03-29 15:46:15'),(349,357,6.80000,1,1,1,'2016-03-29 15:46:15'),(350,358,0.60000,1,1,1,'2016-03-29 15:46:15'),(351,373,0.80000,1,1,1,'2016-03-29 15:46:15'),(352,374,0.30000,1,1,1,'2016-03-29 15:46:15'),(353,375,0.65000,1,1,1,'2016-03-29 15:46:15'),(354,376,0.49000,1,1,1,'2016-03-29 15:46:15'),(355,377,0.49000,1,1,1,'2016-03-29 15:46:15'),(356,378,0.49000,1,1,1,'2016-03-29 15:46:15'),(357,379,13.95000,1,1,1,'2016-03-29 15:46:15'),(358,380,16.95000,1,1,1,'2016-03-29 15:46:15'),(359,381,3.02000,1,1,1,'2016-03-29 15:46:15'),(360,382,2.92000,1,1,1,'2016-03-29 15:46:15'),(361,383,3.02000,1,1,1,'2016-03-29 15:46:15'),(362,384,0.25000,1,1,1,'2016-03-29 15:46:15'),(363,385,0.15000,1,1,1,'2016-03-29 15:46:15'),(364,386,0.32000,1,1,1,'2016-03-29 15:46:15'),(365,387,3.08000,1,1,1,'2016-03-29 15:46:15'),(366,388,4.54000,1,1,1,'2016-03-29 15:46:15'),(367,389,7.45000,1,1,1,'2016-03-29 15:46:15'),(368,390,3.56000,1,1,1,'2016-03-29 15:46:15'),(369,391,2.92000,1,1,1,'2016-03-29 15:46:15'),(370,392,3.15000,1,1,1,'2016-03-29 15:46:15'),(371,393,1.62000,1,1,1,'2016-03-29 15:46:15'),(372,394,2.70000,1,1,1,'2016-03-29 15:46:15'),(373,395,1.73000,1,1,1,'2016-03-29 15:46:15'),(374,396,1.84000,1,1,1,'2016-03-29 15:46:15'),(375,397,0.97000,1,1,1,'2016-03-29 15:46:15'),(376,398,0.15000,1,1,1,'2016-03-29 15:46:15'),(377,399,4.95000,1,1,1,'2016-03-29 15:46:15'),(378,400,1.08000,1,1,1,'2016-03-29 15:46:15'),(379,401,0.95000,1,1,1,'2016-03-29 15:46:15'),(380,402,1.51000,1,1,1,'2016-03-29 15:46:15'),(381,403,0.49000,1,1,1,'2016-03-29 15:46:15'),(382,404,0.20000,1,1,1,'2016-03-29 15:46:15'),(383,405,3.46000,1,1,1,'2016-03-29 15:46:15'),(384,406,1.84000,1,1,1,'2016-03-29 15:46:15'),(385,407,1.94000,1,1,1,'2016-03-29 15:46:15'),(386,408,9.72000,1,1,1,'2016-03-29 15:46:15'),(387,409,92.77000,1,1,1,'2016-03-29 15:46:15'),(388,410,1.65000,1,1,1,'2016-03-29 15:46:15'),(389,411,1.20000,1,1,1,'2016-03-29 15:46:15'),(390,412,1.45000,1,1,1,'2016-03-29 15:46:15'),(391,413,0.70000,1,1,1,'2016-03-29 15:46:15'),(392,414,0.35000,1,1,1,'2016-03-29 15:46:15'),(393,415,0.25000,1,1,1,'2016-03-29 15:46:15'),(394,416,0.75000,1,1,1,'2016-03-29 15:46:15'),(395,417,0.50000,1,1,1,'2016-03-29 15:46:15'),(396,419,0.20000,1,1,1,'2016-03-29 15:46:15'),(397,420,1.35000,1,1,1,'2016-03-29 15:46:15'),(398,421,1.35000,1,1,1,'2016-03-29 15:46:15'),(399,422,3.56000,1,1,1,'2016-03-29 15:46:15'),(400,423,1.94000,1,1,1,'2016-03-29 15:46:15'),(401,424,2.05000,1,1,1,'2016-03-29 15:46:15'),(402,425,1.94000,1,1,1,'2016-03-29 15:46:15'),(403,426,1.73000,1,1,1,'2016-03-29 15:46:15'),(404,427,1.40000,1,1,1,'2016-03-29 15:46:15'),(405,428,2.38000,1,1,1,'2016-03-29 15:46:15'),(406,429,0.70000,1,1,1,'2016-03-29 15:46:15'),(407,430,0.92000,1,1,1,'2016-03-29 15:46:15'),(408,431,0.97000,1,1,1,'2016-03-29 15:46:15'),(409,444,1.73000,1,1,1,'2016-03-29 15:46:15'),(410,445,1.73000,1,1,1,'2016-03-29 15:46:15'),(411,446,149.95000,1,1,1,'2016-03-29 15:46:15'),(412,447,2.75000,1,1,1,'2016-03-29 15:46:15'),(413,448,8.95000,1,1,1,'2016-03-29 15:46:15'),(414,449,6.70000,1,1,1,'2016-03-29 15:46:15'),(415,450,0.60000,1,1,1,'2016-03-29 15:46:15'),(416,451,4.21000,1,1,1,'2016-03-29 15:46:15'),(417,452,5.94000,1,1,1,'2016-03-29 15:46:15'),(418,453,0.50000,1,1,1,'2016-03-29 15:46:15'),(419,454,0.30000,1,1,1,'2016-03-29 15:46:15'),(420,455,1.84000,1,1,1,'2016-03-29 15:46:15'),(421,456,0.04000,1,1,1,'2016-03-29 15:46:15'),(422,457,0.03000,1,1,1,'2016-03-29 15:46:15'),(423,458,2.25000,1,1,1,'2016-03-29 15:46:15'),(424,459,3.05000,1,1,1,'2016-03-29 15:46:15'),(425,460,9.95000,1,1,1,'2016-03-29 15:46:15'),(426,461,2.70000,1,1,1,'2016-03-29 15:46:15'),(427,462,83.16000,1,1,1,'2016-03-29 15:46:15'),(428,463,3.78000,1,1,1,'2016-03-29 15:46:15'),(429,464,6.70000,1,1,1,'2016-03-29 15:46:15'),(430,465,34.13000,1,1,1,'2016-03-29 15:46:15'),(431,466,0.32000,1,1,1,'2016-03-29 15:46:15'),(432,467,0.32000,1,1,1,'2016-03-29 15:46:15'),(433,468,0.17000,1,1,1,'2016-03-29 15:46:15'),(434,469,0.18000,1,1,1,'2016-03-29 15:46:15'),(435,470,0.17000,1,1,1,'2016-03-29 15:46:15'),(436,472,7.45000,1,1,1,'2016-03-29 15:46:15'),(437,473,8.75000,1,1,1,'2016-03-29 15:46:15'),(438,474,1.70000,1,1,1,'2016-03-29 15:46:15'),(439,475,0.65000,1,1,1,'2016-03-29 15:46:15'),(440,476,1.70000,1,1,1,'2016-03-29 15:46:15'),(441,477,1.90000,1,1,1,'2016-03-29 15:46:15'),(442,478,1.90000,1,1,1,'2016-03-29 15:46:15'),(443,479,0.60000,1,1,1,'2016-03-29 15:46:15'),(444,480,0.22000,1,1,1,'2016-03-29 15:46:15'),(445,481,0.23000,1,1,1,'2016-03-29 15:46:15'),(446,482,0.75000,1,1,1,'2016-03-29 15:46:15'),(447,483,0.75000,1,1,1,'2016-03-29 15:46:15'),(448,484,1.60000,1,1,1,'2016-03-29 15:46:15'),(449,486,39.00000,1,1,1,'2016-03-29 15:46:15');
/*!40000 ALTER TABLE `pricedetails` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `storelocations`
--

DROP TABLE IF EXISTS `storelocations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storelocations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `is_full` tinyint(1) NOT NULL DEFAULT '0',
  `datetime_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `storelocations_parent_id_k` (`parent_id`),
  CONSTRAINT `storelocations_parent_id_fk` FOREIGN KEY (`parent_id`) REFERENCES `storelocations` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `storelocations`
--

LOCK TABLES `storelocations` WRITE;
/*!40000 ALTER TABLE `storelocations` DISABLE KEYS */;
INSERT INTO `storelocations` VALUES (1,'Elkosortiment',NULL,0,'2016-03-29 15:46:06'),(2,'LED-Sortiment',NULL,0,'2016-03-29 15:46:06'),(3,'Schubladen Plastik',NULL,0,'2016-03-29 15:46:06'),(4,'Schubladen Stahl',NULL,0,'2016-03-29 15:46:06'),(5,'Zenerdioden-Sortiment',NULL,0,'2016-03-29 15:46:06'),(6,'Widerstands-Sortiment',NULL,0,'2016-03-29 15:46:06'),(7,'Weisse Schublade oben',NULL,0,'2016-03-29 15:46:06'),(8,'Leiterplatten-Kleinteile',NULL,0,'2016-03-29 15:46:06'),(9,'Werkstatt',NULL,0,'2016-03-29 15:46:06'),(10,'Stiftleisten SMD',NULL,0,'2016-03-29 15:46:06'),(12,'Kerko-Sortiment',NULL,0,'2016-03-29 15:46:06');
/*!40000 ALTER TABLE `storelocations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `suppliers`
--

DROP TABLE IF EXISTS `suppliers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `suppliers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `address` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `phone_number` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `fax_number` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `email_address` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `website` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `auto_product_url` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `datetime_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `suppliers_parent_id_k` (`parent_id`),
  CONSTRAINT `suppliers_parent_id_fk` FOREIGN KEY (`parent_id`) REFERENCES `suppliers` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `suppliers`
--

LOCK TABLES `suppliers` WRITE;
/*!40000 ALTER TABLE `suppliers` DISABLE KEYS */;
INSERT INTO `suppliers` VALUES (1,'Conrad',NULL,'','','','','','','2016-03-29 15:45:46'),(2,'Distrelec',NULL,'','','','','','','2016-03-29 15:45:46'),(3,'Reichelt',NULL,'','','','','','','2016-03-29 15:45:46'),(4,'PCB-Pool',NULL,'','','','','','','2016-03-29 15:45:46'),(5,'Platinen-Sammler',NULL,'','','','','','','2016-03-29 15:45:46'),(6,'Unbekannt',NULL,'','','','','','','2016-03-29 15:45:46');
/*!40000 ALTER TABLE `suppliers` 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 2016-03-29 17:48:29
