/*!40101 SET NAMES 'utf8' */;
SET FOREIGN_KEY_CHECKS=0;

-- 
-- Table structure for table `categories`
-- 
DROP TABLE IF EXISTS `categories`;
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=133 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table `categories`
-- 
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('12','Widerstände',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('13','Kondensatoren',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('14','Induktivitäten',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('16','Dioden','46','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('17','Spannungsregler',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('18','0-4V','17','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('19','4-8V','17','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('20','8-20V','17','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('21','ADJ.','17','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('22','PH...','120','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('23','ZF...','16','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('24','lala','25','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('25','1N4...','16','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('26','1N5...','16','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('27','Brückengleichrichter','16','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('28','ICs','80','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('29','I²C','22','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('30','Transistoren',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('31','BC...','30','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('32','BD...','30','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('33','BCW...','30','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('34','TIP...','30','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('36','HD...','30','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('37','MOSFETs',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('38','N-Channel','37','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('39','Triacs',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('41','Quarz/Crystal',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('42','ULN...','22','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('43','IR',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('44','Sonstiege','28','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('45','Optokopler/MOC','28','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('46','74...',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('47','Flash/EEPROM/RAM...',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('48','Video','54','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('49','RTC','48','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('50','µC/ARM/MIPS...','28','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('52','A/D & D/A',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('53','Dig. Potis',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('54','USB','64','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('55','OPAMP',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('56','Module',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('57','Funk','56','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('58','LineTreiber',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('59','Sensoren','26','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('60','Motortreiber',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('61','Netzwerk','56','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('62','Netzwerk',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('63','Sensoren',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('64','Solid State Relays','22','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('65','Temperatur','63','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('66','Opto','63','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('67','IC-Sockel','59','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('68','RCL',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('69','Kondensatoren','68','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('71','Induktivitäten','68','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('73','Kerko','69','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('74','Elko','69','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('76','MKT/WIMA','69','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('77','Tantal','69','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('78','LCDs',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('79','GLCD','78','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('80','Text','48','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('81','7SEG.','78','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('82','LEDs',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('83','IR','82','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('84','Sonstige','56','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('85','IR','63','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('86','7SEG.','82','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('87','Rot','82','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('88','Gelb','82','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('90','Blau','82','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('91','Orange','82','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('92','Laser','82','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('93','Grün','82','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('94','Sonstige','82','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('95','Weiss','82','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('96','Audio',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('97','Laderegler',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('98','Vref','17','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('99','Stecker/Kontakte',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('100','Messerleisten','99','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('101','Step-Up','17','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('102','Step-Down','17','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('103','Dig. Iso.',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('104','DC/DC','56','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('105','Widerstände','68','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('108','0R-1K','105','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('109','1K-100K','105','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('110','100K-1M','105','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('111','>1M','105','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('112','Potentiometer','105','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('113','Schaltnetzteile','17','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('114','Sonstiges',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('115','USB','99','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('116','Taster/Schalter',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('117','Taster','116','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('118','Schalter','116','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('119','BZV...','16','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('120','Sonstiges','16','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('121','Pinheader','99','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('122','test',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('123','P-Channel','37','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('124','Radial','74','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('125','Axial','74','0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('126','Schrank',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('128','Suchen / Hinzufügen',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('129','dsfa',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('130','Platinen',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('131','R',NULL,'0','0','0');
INSERT INTO `categories` (`id`,`name`,`parent_id`,`disable_footprints`,`disable_manufacturers`,`disable_autodatasheets`) VALUES ('132','0603','131','0','0','0');
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;

