-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 24. Sep 2013 um 19:23
-- Server Version: 5.6.12-log
-- PHP-Version: 5.4.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- Datenbank: `part-db`
--
CREATE DATABASE IF NOT EXISTS `part-db` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `part-db`;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` mediumtext NOT NULL,
  `parentnode` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `parentnode` (`parentnode`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=73 ;

--
-- Daten für Tabelle `categories`
--

INSERT INTO `categories` (`id`, `name`, `parentnode`) VALUES
(1, 'Dioden', 0),
(2, '1N4...', 1),
(3, 'Brückengleichrichter', 1),
(4, 'IC -Sockel', 5),
(5, 'ICs', 0),
(6, '74...', 5),
(7, 'I²C', 10),
(8, 'Solid State Relays', 5),
(9, 'µC/ARM/MIPS', 5),
(10, 'BUS', 5),
(11, 'SPI', 10),
(12, 'Laderegler', 5),
(13, 'Flash/EEPROM', 5),
(14, 'Dig. Potis', 5),
(15, 'Sonstiges', 5),
(16, 'LCDs', 0),
(17, 'LEDs', 0),
(18, 'IR', 17),
(19, 'Rot', 17),
(20, 'Blau', 17),
(21, 'Gelb', 17),
(22, 'Grün', 17),
(23, 'Orange', 17),
(24, 'Weiß', 17),
(25, 'Module', 0),
(26, 'DC/DC', 25),
(27, 'Funk', 25),
(28, 'MOSFETs', 0),
(29, 'N-Channel', 28),
(30, 'P-Channel', 28),
(31, 'RCL', 0),
(32, 'Induktivitäten', 31),
(33, 'Kondensatoren', 31),
(34, 'Widerstände', 31),
(35, 'Quarz/Crystal', 0),
(36, '0R-1K', 34),
(37, '100K-1M', 34),
(38, '1K-100K', 34),
(39, 'Potentiometer', 34),
(40, 'Sensoren', 0),
(41, 'IR', 40),
(42, 'Ultraschall', 40),
(43, 'Temperatur', 40),
(44, 'Spannungsregler', 0),
(45, '0-4V', 44),
(46, '4-8V', 44),
(47, '8-20V', 44),
(48, 'ADJ', 44),
(49, 'Vref', 44),
(50, 'Stecker/Kontakte', 0),
(51, 'Messerleisten', 50),
(52, 'Pinheader', 50),
(53, 'Taster/Schalter', 0),
(54, 'Schalter', 53),
(55, 'Taster', 53),
(56, 'Transistoren', 0),
(57, 'BC...', 56),
(58, 'BCW...', 56),
(59, 'BD...', 56),
(60, 'Triacs', 0),
(61, 'Test', 0),
(62, '1M-...', 34),
(63, 'MOSFET-Treiber', 28),
(64, 'Schutzdioden', 1),
(65, 'SCHOTTKY', 1),
(72, 'Displays', 71),
(71, 'SONSTIGES', 0),
(70, 'Serial', 10);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `datasheets`
--

CREATE TABLE IF NOT EXISTS `datasheets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `part_id` int(11) NOT NULL DEFAULT '0',
  `datasheeturl` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `part_id` (`part_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `devices`
--

CREATE TABLE IF NOT EXISTS `devices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` mediumtext NOT NULL,
  `parentnode` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `footprints`
--

CREATE TABLE IF NOT EXISTS `footprints` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` mediumtext NOT NULL,
  `parentnode` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=895 ;

--
-- Daten für Tabelle `footprints`
--

INSERT INTO `footprints` (`id`, `name`, `parentnode`) VALUES
(1, 'DIODE_CB417', 0),
(2, 'DIODE_CB429', 0),
(3, 'DIODE_DO14', 0),
(4, 'DIODE_DO15', 0),
(5, 'DIODE_DO16', 0),
(6, 'DIODE_DO201', 0),
(7, 'DIODE_DO204AC', 0),
(8, 'DIODE_DO32', 0),
(9, 'DIODE_DO35', 0),
(10, 'DIODE_DO34', 0),
(11, 'DIODE_DO39', 0),
(12, 'DIODE_DO41', 0),
(13, 'DIODE_DO7', 0),
(14, 'DIODE_F126', 0),
(15, 'DIODE_GP20', 0),
(16, 'DIODE_R1', 0),
(17, 'DIODE_P600', 0),
(18, 'DIODE_SKE', 0),
(19, 'DIODE_SKA', 0),
(20, 'DIODE_SOD81', 0),
(21, 'DIODE_DO214AB', 0),
(22, 'DIODE_DO214AC', 0),
(23, 'DIODE_DO214AA', 0),
(24, 'DIODE_SMA', 0),
(25, 'DIODE_SMB', 0),
(26, 'DIODE_SMC', 0),
(27, 'DIODE_SOD123-1', 0),
(28, 'DIODE_SOD123-3', 0),
(29, 'DIODE_SOD123-5', 0),
(30, 'GLEICHRICHTER_2KBB-R', 0),
(31, 'GLEICHRICHTER_FB15', 0),
(32, 'GLEICHRICHTER_RB1A', 0),
(33, 'GLEICHRICHTER_SKBB', 0),
(34, 'GLEICHRICHTER_FB15A', 0),
(35, 'GLEICHRICHTER_2KBB', 0),
(36, 'GLEICHRICHTER_2KBP', 0),
(37, 'GLEICHRICHTER_DIP4S', 0),
(38, 'GLEICHRICHTER_FB100', 0),
(39, 'GLEICHRICHTER_FB32', 0),
(40, 'GLEICHRICHTER_KBU-4-6-8', 0),
(41, 'IC_DFS', 0),
(42, 'IC_DPAK-369C', 0),
(43, 'IC_MBxS', 0),
(44, 'IC_MULTIWATT15', 0),
(45, 'IC_SHARP-S2xxEx', 0),
(46, 'IC_DIP04', 0),
(47, 'IC_DIP06-4', 0),
(48, 'IC_DIP06', 0),
(49, 'IC_DIP08', 0),
(50, 'IC_DIP08A4', 0),
(51, 'IC_DIP14', 0),
(52, 'IC_DIP14A4', 0),
(53, 'IC_DIP14A8', 0),
(54, 'IC_DIP14A8', 0),
(55, 'IC_DIP16', 0),
(56, 'IC_DIP16A4', 0),
(57, 'IC_DIP16A8', 0),
(58, 'IC_DIP18', 0),
(59, 'IC_DIP20', 0),
(60, 'IC_DIP22-4', 0),
(61, 'IC_DIP22', 0),
(62, 'IC_DIP24-4', 0),
(63, 'IC_DIP24-9', 0),
(64, 'IC_DIP24', 0),
(65, 'IC_DIP24A12', 0),
(66, 'IC_DIP24W', 0),
(67, 'IC_DIP28-4', 0),
(68, 'IC_DIP28W', 0),
(69, 'IC_DIP28', 0),
(70, 'IC_DIP28W', 0),
(71, 'IC_DIP32-3', 0),
(72, 'IC_DIP32W', 0),
(73, 'IC_DIP36W', 0),
(74, 'IC_DIP40W', 0),
(75, 'IC_DIP42W', 0),
(76, 'IC_DIP48W', 0),
(77, 'IC_DIP52W', 0),
(78, 'IC_DIP64-9', 0),
(79, 'IC_DIP68-9', 0),
(80, 'IC_LQFP48', 0),
(81, 'IC_LQFP64', 0),
(82, 'IC_PQFP100', 0),
(83, 'IC_PQFP128', 0),
(84, 'IC_PQFP208', 0),
(85, 'IC_TQFP100', 0),
(86, 'IC_TQFP112', 0),
(87, 'IC_TQFP32', 0),
(88, 'IC_TQFP144', 0),
(89, 'IC_TQFP32', 0),
(90, 'IC_TQFP44', 0),
(91, 'IC_TQFP64', 0),
(92, 'IC_MSOP10', 0),
(93, 'IC_PSO36', 0),
(94, 'IC_PSO20', 0),
(95, 'IC_QSOP28', 0),
(96, 'IC_QSOP24', 0),
(97, 'IC_QSOP20', 0),
(98, 'IC_QSOP16', 0),
(99, 'IC_SO08', 0),
(100, 'IC_SO14', 0),
(101, 'IC_SO16', 0),
(102, 'IC_SO16W', 0),
(103, 'IC_SO18W', 0),
(104, 'IC_SO20W', 0),
(105, 'IC_SO24W', 0),
(106, 'IC_SO28W', 0),
(107, 'IC_SO32-400', 0),
(108, 'IC_SO32-525', 0),
(109, 'IC_SSOP14', 0),
(110, 'IC_SSOP16', 0),
(111, 'IC_SSOP20', 0),
(112, 'IC_SSOP24', 0),
(113, 'IC_SSOP28', 0),
(114, 'IC_SSOP30', 0),
(115, 'IC_SSOP48', 0),
(116, 'IC_SSOP56', 0),
(117, 'IC_SSOP56DL', 0),
(118, 'IC_SOT143', 0),
(119, 'IC_SOT223', 0),
(120, 'IC_SOT23-6', 0),
(121, 'IC_SOT23-5', 0),
(122, 'IC_SOT23-6', 0),
(123, 'IC_SOT23', 0),
(124, 'IC_SOT363', 0),
(125, 'IC_SOT82', 0),
(126, 'IC_SOT93', 0),
(127, 'IC_TSOP28-13', 0),
(128, 'IC_TSOP06', 0),
(129, 'IC_TSOP32-13', 0),
(130, 'IC_TSOP32', 0),
(131, 'IC_TSOP48', 0),
(132, 'IC_TSOP56', 0),
(133, 'IC_TSOP86', 0),
(134, 'IC_TSOPII28', 0),
(135, 'IC_TSOPII44', 0),
(136, 'IC_TSOPII50', 0),
(137, 'IC_TSOPII32', 0),
(138, 'IC_TSOPII50', 0),
(139, 'IC_TSOPII86', 0),
(140, 'IC_TSSOP08', 0),
(141, 'IC_TSSOP14', 0),
(142, 'IC_TSSOP16', 0),
(143, 'IC_TSSOP20', 0),
(144, 'IC_TSSOP28', 0),
(145, 'IC_TSSOP38', 0),
(146, 'IC_TSSOP48', 0),
(147, 'IC_TSSOP56', 0),
(148, 'IC_TSSOP64', 0),
(149, 'IC_TSOPII54', 0),
(150, 'IC_TSSOP08', 0),
(151, 'IC_TO126', 0),
(152, 'IC_TO126', 0),
(153, 'IC_TO18', 0),
(154, 'IC_TO18D', 0),
(155, 'IC_TO202', 0),
(156, 'IC_TO218-2', 0),
(157, 'IC_TO218', 0),
(158, 'IC_TO220-2', 0),
(159, 'IC_TO220-5', 0),
(160, 'IC_TO220', 0),
(161, 'IC_TO247-2', 0),
(162, 'IC_TO247', 0),
(163, 'IC_TO252', 0),
(164, 'IC_TO263', 0),
(165, 'IC_TO3', 0),
(166, 'IC_TO39', 0),
(167, 'IC_TO51', 0),
(168, 'IC_TO52', 0),
(169, 'IC_TO39-4', 0),
(170, 'IC_TO39', 0),
(171, 'IC_TO66', 0),
(172, 'IC_TO72-3', 0),
(173, 'IC_TO72-4', 0),
(174, 'IC_TO92-2', 0),
(175, 'IC_TO92-G4', 0),
(176, 'IC_TO92', 0),
(177, 'IC_UMAX08', 0),
(178, 'IC_UMAX10', 0),
(179, 'RESONATOR-MURATA_CSTCC-G-A', 0),
(180, 'RESONATOR-MURATA_CSTCE-G-A', 0),
(181, 'QUARZ_HC49-4H', 0),
(182, 'QUARZ_025MM', 0),
(183, 'QUARZ_HC49', 0),
(184, 'QUARZ_HC49-US', 0),
(185, 'SOCKEL_DIP04', 0),
(186, 'SOCKEL_DIP06-4', 0),
(187, 'SOCKEL_DIP06', 0),
(188, 'SOCKEL_DIP08', 0),
(189, 'SOCKEL_DIP08A4', 0),
(190, 'SOCKEL_DIP14', 0),
(191, 'SOCKEL_DIP14A4', 0),
(192, 'SOCKEL_DIP14A8', 0),
(193, 'SOCKEL_DIP16', 0),
(194, 'SOCKEL_DIP16A4', 0),
(195, 'SOCKEL_DIP16A8', 0),
(196, 'SOCKEL_DIP18', 0),
(197, 'SOCKEL_DIP20', 0),
(198, 'SOCKEL_DIP22-4', 0),
(199, 'SOCKEL_DIP22', 0),
(200, 'SOCKEL_DIP24-4', 0),
(201, 'SOCKEL_DIP24-9', 0),
(202, 'SOCKEL_DIP24', 0),
(203, 'SOCKEL_DIP24A12', 0),
(204, 'SOCKEL_DIP24W', 0),
(205, 'SOCKEL_DIP28-4', 0),
(206, 'SOCKEL_DIP28', 0),
(207, 'SOCKEL_DIP28W', 0),
(208, 'SOCKEL_DIP32-3', 0),
(209, 'SOCKEL_DIP32W', 0),
(210, 'SOCKEL_DIP36W', 0),
(211, 'SOCKEL_DIP40W', 0),
(212, 'SOCKEL_DIP42W', 0),
(213, 'SOCKEL_DIP48W', 0),
(214, 'SOCKEL_DIP52W', 0),
(215, 'SOCKEL_DIP68_9', 0),
(216, 'SOCKEL_DIP64_9', 0),
(217, 'SOCKEL_DIP68_9', 0),
(218, 'RELAIS_G2RL-1-E', 0),
(219, 'RELAIS_G2RL-1', 0),
(220, 'RELAIS_G2RL-1A-E', 0),
(221, 'RELAIS_G2RL-1A', 0),
(222, 'RELAIS_G2RL-2', 0),
(223, 'RELAIS_G2RL-2A', 0),
(224, 'RELAIS_G6D', 0),
(225, 'RELAIS_RY2', 0),
(226, 'TASTER_6X6-BLACK', 0),
(227, 'TASTER_6X6-BLUE', 0),
(228, 'TASTER_6X6-GREEN', 0),
(229, 'TASTER_6X6-RED', 0),
(230, 'TASTER_6X6-WHITE', 0),
(231, 'TASTER_LSH125', 0),
(232, 'TASTER_LSH43', 0),
(233, 'TASTER_LSH50', 0),
(234, 'TASTER_LSH70', 0),
(235, 'TASTER_LSH95', 0),
(236, 'TASTER_SKHH-3MM', 0),
(237, 'TASTER_B3F-10XX1', 0),
(238, 'TASTER_LSH125', 0),
(239, 'TASTER_LSH125', 0),
(240, 'TASTER_SKHH-5MM', 0),
(241, 'TASTER_SKHH-7MM', 0),
(242, 'TASTER_LSH80', 0),
(243, 'TASTER_LSH95', 0),
(244, 'TASTER_SKHH-9-5MM', 0),
(245, 'KIPPSCHALTER_1P-90-V-K', 0),
(246, 'KIPPSCHALTER_1P-90-V-L', 0),
(247, 'KIPPSCHALTER_1P-90-V-M', 0),
(248, 'KIPPSCHALTER_1P-90-H-K', 0),
(249, 'KIPPSCHALTER_1P-90-H-L', 0),
(250, 'KIPPSCHALTER_1P-90-H-M', 0),
(251, 'SICHERUNGSHALTER_Laengs', 0),
(252, 'SICHERUNGSHALTER_Quer', 0),
(253, 'BUCHSE_PHONE-JACK', 0),
(254, 'BUCHSE_STEREO-35MM', 0),
(255, 'BUCHSENLEISTE-ABGEWINKELT_1X02', 0),
(256, 'BUCHSENLEISTE-ABGEWINKELT_1X05', 0),
(257, 'BUCHSENLEISTE-ABGEWINKELT_1X06', 0),
(258, 'BUCHSENLEISTE-ABGEWINKELT_1X07', 0),
(259, 'BUCHSENLEISTE-ABGEWINKELT_1X08', 0),
(260, 'BUCHSENLEISTE-ABGEWINKELT_1X09', 0),
(261, 'BUCHSENLEISTE-ABGEWINKELT_1X10', 0),
(262, 'BUCHSENLEISTE-ABGEWINKELT_1X12', 0),
(263, 'BUCHSENLEISTE-ABGEWINKELT_1X13', 0),
(264, 'BUCHSENLEISTE-ABGEWINKELT_1X15', 0),
(265, 'BUCHSENLEISTE-ABGEWINKELT_1X17', 0),
(266, 'BUCHSENLEISTE-ABGEWINKELT_1X18', 0),
(267, 'BUCHSENLEISTE-ABGEWINKELT_1X20', 0),
(268, 'BUCHSENLEISTE-GERADE_1X05', 0),
(269, 'BUCHSENLEISTE-GERADE_1X05', 0),
(270, 'BUCHSENLEISTE-GERADE_1X06', 0),
(271, 'BUCHSENLEISTE-GERADE_1X07', 0),
(272, 'BUCHSENLEISTE-GERADE_1X08', 0),
(273, 'BUCHSENLEISTE-GERADE_1X09', 0),
(274, 'BUCHSENLEISTE-GERADE_1X10', 0),
(275, 'BUCHSENLEISTE-GERADE_1X12', 0),
(276, 'BUCHSENLEISTE-GERADE_1X13', 0),
(277, 'BUCHSENLEISTE-GERADE_1X15', 0),
(278, 'BUCHSENLEISTE-GERADE_1X17', 0),
(279, 'BUCHSENLEISTE-GERADE_1X20', 0),
(280, 'BUCHSENLEISTE-GERADE-FLACH_1X05', 0),
(281, 'BUCHSENLEISTE-GERADE_1X18', 0),
(282, 'BUCHSENLEISTE-GERADE-FLACH_1X05', 0),
(283, 'BUCHSENLEISTE-GERADE-FLACH_1X06', 0),
(284, 'BUCHSENLEISTE-GERADE-FLACH_1X07', 0),
(285, 'BUCHSENLEISTE-GERADE-FLACH_1X08', 0),
(286, 'BUCHSENLEISTE-GERADE-FLACH_1X09', 0),
(287, 'BUCHSENLEISTE-GERADE-FLACH_1X10', 0),
(288, 'BUCHSENLEISTE-GERADE-FLACH_1X12', 0),
(289, 'BUCHSENLEISTE-GERADE-FLACH_1X13', 0),
(290, 'BUCHSENLEISTE-GERADE-FLACH_1X15', 0),
(291, 'BUCHSENLEISTE-GERADE-FLACH_1X17', 0),
(292, 'BUCHSENLEISTE-GERADE-FLACH_1X18', 0),
(293, 'BUCHSENLEISTE-GERADE-FLACH_1X20', 0),
(294, 'BUCHSENLEISTE-GERADE-PRAEZISION_1X01', 0),
(295, 'BUCHSENLEISTE-GERADE-PRAEZISION_1X01', 0),
(296, 'BUCHSENLEISTE-GERADE-PRAEZISION_1X02', 0),
(297, 'BUCHSENLEISTE-GERADE-PRAEZISION_1X03', 0),
(298, 'BUCHSENLEISTE-GERADE-PRAEZISION_1X04', 0),
(299, 'BUCHSENLEISTE-GERADE-PRAEZISION_1X06', 0),
(300, 'BUCHSENLEISTE-GERADE-PRAEZISION_1X08', 0),
(301, 'BUCHSENLEISTE-GERADE-PRAEZISION_1X09', 0),
(302, 'BUCHSENLEISTE-GERADE-PRAEZISION_1X10', 0),
(303, 'BUCHSENLEISTE-GERADE-PRAEZISION_1X11', 0),
(304, 'BUCHSENLEISTE-GERADE-PRAEZISION_1X12', 0),
(305, 'BUCHSENLEISTE-GERADE-PRAEZISION_1X13', 0),
(306, 'BUCHSENLEISTE-GERADE-PRAEZISION_1X09', 0),
(307, 'BUCHSENLEISTE-GERADE-PRAEZISION_1X06', 0),
(308, 'BUCHSENLEISTE-GERADE-PRAEZISION_1X05', 0),
(309, 'BUCHSENLEISTE-GERADE-PRAEZISION_1X07', 0),
(310, 'BUCHSENLEISTE-ABGEWINKELT_2X05', 0),
(311, 'BUCHSENLEISTE-ABGEWINKELT_2X06', 0),
(312, 'BUCHSENLEISTE-ABGEWINKELT_2X07', 0),
(313, 'BUCHSENLEISTE-ABGEWINKELT_2X08', 0),
(314, 'BUCHSENLEISTE-ABGEWINKELT_2X09', 0),
(315, 'BUCHSENLEISTE-ABGEWINKELT_2X10', 0),
(316, 'BUCHSENLEISTE-ABGEWINKELT_2X12', 0),
(317, 'BUCHSENLEISTE-ABGEWINKELT_2X13', 0),
(318, 'BUCHSENLEISTE-ABGEWINKELT_2X15', 0),
(319, 'BUCHSENLEISTE-ABGEWINKELT_2X17', 0),
(320, 'BUCHSENLEISTE-ABGEWINKELT_2X18', 0),
(321, 'BUCHSENLEISTE-ABGEWINKELT_2X20', 0),
(322, 'BUCHSENLEISTE-GERADE_2X05', 0),
(323, 'BUCHSENLEISTE-GERADE_2X06', 0),
(324, 'BUCHSENLEISTE-GERADE_2X07', 0),
(325, 'BUCHSENLEISTE-GERADE_2X08', 0),
(326, 'BUCHSENLEISTE-GERADE_2X09', 0),
(327, 'BUCHSENLEISTE-GERADE_2X10', 0),
(328, 'BUCHSENLEISTE-GERADE_2X12', 0),
(329, 'BUCHSENLEISTE-GERADE_2X13', 0),
(330, 'BUCHSENLEISTE-GERADE_2X15', 0),
(331, 'BUCHSENLEISTE-GERADE_2X17', 0),
(332, 'BUCHSENLEISTE-GERADE_2X18', 0),
(333, 'BUCHSENLEISTE-GERADE_2X20', 0),
(334, 'BUCHSENLEISTE-GERADE-FLACH_2X05', 0),
(335, 'BUCHSENLEISTE-GERADE-FLACH_2X06', 0),
(336, 'BUCHSENLEISTE-GERADE-FLACH_2X07', 0),
(337, 'BUCHSENLEISTE-GERADE-FLACH_2X08', 0),
(338, 'BUCHSENLEISTE-GERADE-FLACH_2X09', 0),
(339, 'BUCHSENLEISTE-GERADE-FLACH_2X10', 0),
(340, 'BUCHSENLEISTE-GERADE-FLACH_2X12', 0),
(341, 'BUCHSENLEISTE-GERADE-FLACH_2X13', 0),
(342, 'BUCHSENLEISTE-GERADE-FLACH_2X15', 0),
(343, 'BUCHSENLEISTE-GERADE-FLACH_2X17', 0),
(344, 'BUCHSENLEISTE-GERADE-FLACH_2X18', 0),
(345, 'BUCHSENLEISTE-GERADE-FLACH_2X20', 0),
(346, 'BUCHSENLEISTE-GERADE-PRAEZISION_2X02', 0),
(347, 'BUCHSENLEISTE-GERADE-PRAEZISION_2X03', 0),
(348, 'BUCHSENLEISTE-GERADE-PRAEZISION_2X04', 0),
(349, 'BUCHSENLEISTE-GERADE-PRAEZISION_2X05', 0),
(350, 'BUCHSENLEISTE-GERADE-PRAEZISION_2X06', 0),
(351, 'BUCHSENLEISTE-GERADE-PRAEZISION_2X07', 0),
(352, 'BUCHSENLEISTE-GERADE-PRAEZISION_2X08', 0),
(353, 'BUCHSENLEISTE-GERADE-PRAEZISION_2X09', 0),
(354, 'BUCHSENLEISTE-GERADE-PRAEZISION_2X10', 0),
(355, 'BUCHSENLEISTE-GERADE-PRAEZISION_2X11', 0),
(356, 'BUCHSENLEISTE-GERADE-PRAEZISION_2X12', 0),
(357, 'BUCHSENLEISTE-GERADE-PRAEZISION_2X13', 0),
(358, 'BUCHSE-CENTRONICS_F14', 0),
(359, 'BUCHSE-CENTRONICS_F24', 0),
(360, 'BUCHSE-CENTRONICS_F50', 0),
(361, 'KLEMME-WAGO-233_102', 0),
(362, 'VERBINDER_SMA-JH', 0),
(363, 'LOETOESE_FASTON-V', 0),
(364, 'VERBINDER-PHOENIX_MCVR_02', 0),
(365, 'VERBINDER-PHOENIX_MCVR_03', 0),
(366, 'VERBINDER-PHOENIX_MCVR_04', 0),
(367, 'VERBINDER-PHOENIX_MCVR_05', 0),
(368, 'VERBINDER-PHOENIX_MC_02G', 0),
(369, 'VERBINDER-PHOENIX_MC_02', 0),
(370, 'VERBINDER-PHOENIX_MC_03', 0),
(371, 'VERBINDER-PHOENIX_MC_03G', 0),
(372, 'VERBINDER-PHOENIX_MC_02ST', 0),
(373, 'VERBINDER-PHOENIX_MC_03ST', 0),
(374, 'VERBINDER-PHOENIX_MSTBA_02', 0),
(375, 'VERBINDER-PHOENIX_MSTBA_03', 0),
(376, 'VERBINDER-PHOENIX_MSTBA_04', 0),
(377, 'VERBINDER-PHOENIX_MSTBA_05', 0),
(378, 'VERBINDER-PHOENIX_MSTBVA_02', 0),
(379, 'VERBINDER-PHOENIX_MSTBVA_03', 0),
(380, 'VERBINDER-PHOENIX_MSTBVA_04', 0),
(381, 'VERBINDER-PHOENIX_MSTBVA_05', 0),
(382, 'VERBINDER-PHOENIX_MSTBV_02', 0),
(383, 'VERBINDER-PHOENIX_MSTBV_03', 0),
(384, 'VERBINDER-PHOENIX_MSTBV_04', 0),
(385, 'VERBINDER-PHOENIX_MSTBV_05', 0),
(386, 'BUCHSE_RJ45-SHLD-LED', 0),
(387, 'BUCHSE_RJ45-SHLD', 0),
(388, 'BUCHSE_RJ45', 0),
(389, 'SCHRAUBKLEMME_AK700-3-5', 0),
(390, 'SCHRAUBKLEMME_RM350-02', 0),
(391, 'SCHRAUBKLEMME_RM350-03', 0),
(392, 'SCHRAUBKLEMME_RM350-04', 0),
(393, 'SCHRAUBKLEMME_RM350-05', 0),
(394, 'SCHRAUBKLEMME_RM508-02', 0),
(395, 'SCHRAUBKLEMME_RM508-03', 0),
(396, 'SCHRAUBKLEMME_RM508-04', 0),
(397, 'SCHRAUBKLEMME_RM508-05', 0),
(398, 'VERBINDER_LMI-L115-02', 0),
(399, 'VERBINDER_LMI-L115-03', 0),
(400, 'VERBINDER_LMI-L115-05', 0),
(401, 'VERBINDER_LMI-L115-10', 0),
(402, 'VERBINDER_LMI-L115-20', 0),
(403, 'STIFTLEISTE-ABGEWINKELT_1X01', 0),
(404, 'STIFTLEISTE-ABGEWINKELT_1X02', 0),
(405, 'STIFTLEISTE-ABGEWINKELT_1X04', 0),
(406, 'STIFTLEISTE-ABGEWINKELT_1X05', 0),
(407, 'STIFTLEISTE-ABGEWINKELT_1X06', 0),
(408, 'STIFTLEISTE-ABGEWINKELT_1X07', 0),
(409, 'STIFTLEISTE-ABGEWINKELT_1X03', 0),
(410, 'STIFTLEISTE-ABGEWINKELT_1X06', 0),
(411, 'STIFTLEISTE-ABGEWINKELT_1X08', 0),
(412, 'STIFTLEISTE-ABGEWINKELT_1X09', 0),
(413, 'STIFTLEISTE-ABGEWINKELT_1X10', 0),
(414, 'STIFTLEISTE-ABGEWINKELT_1X11', 0),
(415, 'STIFTLEISTE-ABGEWINKELT_1X12', 0),
(416, 'STIFTLEISTE-ABGEWINKELT_1X14', 0),
(417, 'STIFTLEISTE-ABGEWINKELT_1X15', 0),
(418, 'STIFTLEISTE-ABGEWINKELT_1X16', 0),
(419, 'STIFTLEISTE-ABGEWINKELT_1X17', 0),
(420, 'STIFTLEISTE-ABGEWINKELT_1X18', 0),
(421, 'STIFTLEISTE-ABGEWINKELT_1X19', 0),
(422, 'STIFTLEISTE-ABGEWINKELT_1X14', 0),
(423, 'STIFTLEISTE-ABGEWINKELT_1X20', 0),
(424, 'STIFTLEISTE-ABGEWINKELT_1X21', 0),
(425, 'STIFTLEISTE-ABGEWINKELT_1X22', 0),
(426, 'STIFTLEISTE-ABGEWINKELT_1X23', 0),
(427, 'STIFTLEISTE-ABGEWINKELT_1X24', 0),
(428, 'STIFTLEISTE-ABGEWINKELT_1X25', 0),
(429, 'STIFTLEISTE-ABGEWINKELT_1X26', 0),
(430, 'STIFTLEISTE-ABGEWINKELT_1X27', 0),
(431, 'STIFTLEISTE-ABGEWINKELT_1X28', 0),
(432, 'STIFTLEISTE-ABGEWINKELT_1X29', 0),
(433, 'STIFTLEISTE-ABGEWINKELT_1X30', 0),
(434, 'STIFTLEISTE-GERADE_1X01', 0),
(435, 'STIFTLEISTE-GERADE_1X02', 0),
(436, 'STIFTLEISTE-GERADE_1X03', 0),
(437, 'STIFTLEISTE-GERADE_1X04', 0),
(438, 'STIFTLEISTE-GERADE_1X05', 0),
(439, 'STIFTLEISTE-GERADE_1X06', 0),
(440, 'STIFTLEISTE-GERADE_1X07', 0),
(441, 'STIFTLEISTE-GERADE_1X08', 0),
(442, 'STIFTLEISTE-GERADE_1X09', 0),
(443, 'STIFTLEISTE-GERADE_1X10', 0),
(444, 'STIFTLEISTE-GERADE_1X11', 0),
(445, 'STIFTLEISTE-GERADE_1X12', 0),
(446, 'STIFTLEISTE-GERADE_1X13', 0),
(447, 'STIFTLEISTE-GERADE_1X14', 0),
(448, 'STIFTLEISTE-GERADE_1X15', 0),
(449, 'STIFTLEISTE-GERADE_1X16', 0),
(450, 'STIFTLEISTE-GERADE_1X17', 0),
(451, 'STIFTLEISTE-GERADE_1X18', 0),
(452, 'STIFTLEISTE-GERADE_1X19', 0),
(453, 'STIFTLEISTE-GERADE_1X20', 0),
(454, 'STIFTLEISTE-GERADE_1X21', 0),
(455, 'STIFTLEISTE-GERADE_1X22', 0),
(456, 'STIFTLEISTE-GERADE_1X23', 0),
(457, 'STIFTLEISTE-GERADE_1X24', 0),
(458, 'STIFTLEISTE-GERADE_1X25', 0),
(459, 'STIFTLEISTE-GERADE_1X26', 0),
(460, 'STIFTLEISTE-GERADE_1X27', 0),
(461, 'STIFTLEISTE-GERADE_1X28', 0),
(462, 'STIFTLEISTE-GERADE_1X29', 0),
(463, 'STIFTLEISTE-GERADE_1X30', 0),
(464, 'STIFTLEISTE-ABGEWINKELT_2X02', 0),
(465, 'STIFTLEISTE-ABGEWINKELT_2X03', 0),
(466, 'STIFTLEISTE-ABGEWINKELT_2X04', 0),
(467, 'STIFTLEISTE-ABGEWINKELT_2X05', 0),
(468, 'STIFTLEISTE-ABGEWINKELT_2X06', 0),
(469, 'STIFTLEISTE-ABGEWINKELT_2X07', 0),
(470, 'STIFTLEISTE-ABGEWINKELT_2X08', 0),
(471, 'STIFTLEISTE-ABGEWINKELT_2X09', 0),
(472, 'STIFTLEISTE-ABGEWINKELT_2X10', 0),
(473, 'STIFTLEISTE-ABGEWINKELT_2X11', 0),
(474, 'STIFTLEISTE-ABGEWINKELT_2X12', 0),
(475, 'STIFTLEISTE-ABGEWINKELT_2X13', 0),
(476, 'STIFTLEISTE-ABGEWINKELT_2X14', 0),
(477, 'STIFTLEISTE-ABGEWINKELT_2X15', 0),
(478, 'STIFTLEISTE-ABGEWINKELT_2X16', 0),
(479, 'STIFTLEISTE-ABGEWINKELT_2X17', 0),
(480, 'STIFTLEISTE-ABGEWINKELT_2X18', 0),
(481, 'STIFTLEISTE-ABGEWINKELT_2X19', 0),
(482, 'STIFTLEISTE-ABGEWINKELT_2X20', 0),
(483, 'STIFTLEISTE-ABGEWINKELT_2X21', 0),
(484, 'STIFTLEISTE-ABGEWINKELT_2X22', 0),
(485, 'STIFTLEISTE-ABGEWINKELT_2X23', 0),
(486, 'STIFTLEISTE-ABGEWINKELT_2X24', 0),
(487, 'STIFTLEISTE-ABGEWINKELT_2X25', 0),
(488, 'STIFTLEISTE-ABGEWINKELT_2X26', 0),
(489, 'STIFTLEISTE-ABGEWINKELT_2X27', 0),
(490, 'STIFTLEISTE-ABGEWINKELT_2X28', 0),
(491, 'STIFTLEISTE-ABGEWINKELT_2X29', 0),
(492, 'STIFTLEISTE-ABGEWINKELT_2X30', 0),
(493, 'STIFTLEISTE-GERADE_2X02', 0),
(494, 'STIFTLEISTE-GERADE_2X03', 0),
(495, 'STIFTLEISTE-GERADE_2X04', 0),
(496, 'STIFTLEISTE-GERADE_2X05', 0),
(497, 'STIFTLEISTE-GERADE_2X06', 0),
(498, 'STIFTLEISTE-GERADE_2X07', 0),
(499, 'STIFTLEISTE-GERADE_2X08', 0),
(500, 'STIFTLEISTE-GERADE_2X09', 0),
(501, 'STIFTLEISTE-GERADE_2X10', 0),
(502, 'STIFTLEISTE-GERADE_2X11', 0),
(503, 'STIFTLEISTE-GERADE_2X12', 0),
(504, 'STIFTLEISTE-GERADE_2X13', 0),
(505, 'STIFTLEISTE-GERADE_2X14', 0),
(506, 'STIFTLEISTE-GERADE_2X15', 0),
(507, 'STIFTLEISTE-GERADE_2X16', 0),
(508, 'STIFTLEISTE-GERADE_2X17', 0),
(509, 'STIFTLEISTE-GERADE_2X18', 0),
(510, 'STIFTLEISTE-GERADE_2X19', 0),
(511, 'STIFTLEISTE-GERADE_2X20', 0),
(512, 'STIFTLEISTE-GERADE_2X21', 0),
(513, 'STIFTLEISTE-GERADE_2X22', 0),
(514, 'STIFTLEISTE-GERADE_2X23', 0),
(515, 'STIFTLEISTE-GERADE_2X24', 0),
(516, 'STIFTLEISTE-GERADE_2X25', 0),
(517, 'STIFTLEISTE-GERADE_2X26', 0),
(518, 'STIFTLEISTE-GERADE_2X27', 0),
(519, 'STIFTLEISTE-GERADE_2X28', 0),
(520, 'STIFTLEISTE-GERADE_2X29', 0),
(521, 'STIFTLEISTE-GERADE_2X30', 0),
(522, 'STIFTLEISTE-GERADE-SMD_2X02', 0),
(523, 'STIFTLEISTE-GERADE-SMD_2X03', 0),
(524, 'STIFTLEISTE-GERADE-SMD_2X04', 0),
(525, 'STIFTLEISTE-GERADE-SMD_2X05', 0),
(526, 'STIFTLEISTE-ABGEWINKELT-RAHMEN_2X05', 0),
(527, 'STIFTLEISTE-ABGEWINKELT-RAHMEN_2X07', 0),
(528, 'STIFTLEISTE-ABGEWINKELT-RAHMEN_2X08', 0),
(529, 'STIFTLEISTE-ABGEWINKELT-RAHMEN_2X10', 0),
(530, 'STIFTLEISTE-ABGEWINKELT-RAHMEN_2X13', 0),
(531, 'STIFTLEISTE-ABGEWINKELT-RAHMEN_2X17', 0),
(532, 'STIFTLEISTE-ABGEWINKELT-RAHMEN_2X20', 0),
(533, 'STIFTLEISTE-ABGEWINKELT-RAHMEN_2X25', 0),
(534, 'STIFTLEISTE-ABGEWINKELT-RAHMEN_2X32', 0),
(535, 'STIFTLEISTE-GERADE-RAHMEN_2X03', 0),
(536, 'STIFTLEISTE-GERADE-RAHMEN_2X05', 0),
(537, 'STIFTLEISTE-GERADE-RAHMEN_2X08', 0),
(538, 'STIFTLEISTE-GERADE-RAHMEN_2X10', 0),
(539, 'STIFTLEISTE-GERADE-RAHMEN_2X13', 0),
(540, 'STIFTLEISTE-GERADE-RAHMEN_2X17', 0),
(541, 'STIFTLEISTE-GERADE-RAHMEN_2X20', 0),
(542, 'STIFTLEISTE-GERADE-RAHMEN_2X25', 0),
(543, 'STIFTLEISTE-GERADE-RAHMEN_2X32', 0),
(544, 'STIFTLEISTE-GERADE-RAHMEN_2X08', 0),
(545, 'STIFTLEISTE-GERADE-RAHMEN_2X07', 0),
(546, 'STIFTLEISTE-MOLEX-ABGEWINKELT_PSL-02', 0),
(547, 'STIFTLEISTE-MOLEX-ABGEWINKELT_PSL-02', 0),
(548, 'STIFTLEISTE-MOLEX-ABGEWINKELT_PSL-03', 0),
(549, 'STIFTLEISTE-MOLEX-ABGEWINKELT_PSL-04', 0),
(550, 'STIFTLEISTE-MOLEX-ABGEWINKELT_PSL-05', 0),
(551, 'STIFTLEISTE-MOLEX-ABGEWINKELT_PSL-06', 0),
(552, 'STIFTLEISTE-MOLEX-ABGEWINKELT_PSL-07', 0),
(553, 'STIFTLEISTE-MOLEX-ABGEWINKELT_PSL-08', 0),
(554, 'STIFTLEISTE-MOLEX-ABGEWINKELT_PSL-09', 0),
(555, 'STIFTLEISTE-MOLEX-ABGEWINKELT_PSL-10', 0),
(556, 'STIFTLEISTE-MOLEX-GERADE_PSL-02', 0),
(557, 'STIFTLEISTE-MOLEX-GERADE_PSL-03', 0),
(558, 'STIFTLEISTE-MOLEX-GERADE_PSL-04', 0),
(559, 'STIFTLEISTE-MOLEX-GERADE_PSL-05', 0),
(560, 'STIFTLEISTE-MOLEX-GERADE_PSL-06', 0),
(561, 'STIFTLEISTE-MOLEX-GERADE_PSL-07', 0),
(562, 'STIFTLEISTE-MOLEX-GERADE_PSL-08', 0),
(563, 'STIFTLEISTE-MOLEX-GERADE_PSL-09', 0),
(564, 'STIFTLEISTE-WAGO_733-02', 0),
(565, 'SUB-D-PLATINENMONTAGE_M-09', 0),
(566, 'SUB-D-PLATINENMONTAGE_M-25', 0),
(567, 'SUB-D-PLATINENMONTAGE_M-37', 0),
(568, 'SUB-D-PLATINENMONTAGE_M-15', 0),
(569, 'SUB-D-PLATINENMONTAGE_M-25', 0),
(570, 'SUB-D_M-09V', 0),
(571, 'SUB-D_M-09', 0),
(572, 'SUB-D_M-15', 0),
(573, 'SUB-D_M-15V', 0),
(574, 'SUB-D_M-09V', 0),
(575, 'SUB-D_M-25', 0),
(576, 'SUB-D_M-25V', 0),
(577, 'SUB-D_M-37', 0),
(578, 'SUB-D_M-37V', 0),
(579, 'SUB-D_M-15', 0),
(580, 'SUB-D_M-15V', 0),
(581, 'SUB-D_W-09', 0),
(582, 'SUB-D_W-09V', 0),
(583, 'SUB-D_W-15', 0),
(584, 'SUB-D_W-15V', 0),
(585, 'SUB-D_W-25', 0),
(586, 'SUB-D_W-25V', 0),
(587, 'SUB-D_W-37', 0),
(588, 'SUB-D_W-37V', 0),
(589, 'SUB-D-PLATINENMONTAGE_W-09', 0),
(590, 'SUB-D-PLATINENMONTAGE_W-15', 0),
(591, 'SUB-D-PLATINENMONTAGE_W-25', 0),
(592, 'SUB-D-PLATINENMONTAGE_W-37', 0),
(593, 'VERBINDER-USB_B-2', 0),
(594, 'LED-BLAU_3MM', 0),
(595, 'LED-BLAU_5MM-eckig', 0),
(596, 'LED-BLAU_5MM', 0),
(597, 'LED-BLAU_ROW-1', 0),
(598, 'LED-BLAU_ROW-2', 0),
(599, 'LED-BLAU_ROW-3', 0),
(600, 'LED-BLAU_ROW-5', 0),
(601, 'LED-GRUEN_5MM-eckig', 0),
(602, 'LED-BLAU_ROW-5', 0),
(603, 'LED-GRUEN_3MM', 0),
(604, 'LED-GRUEN_5MM', 0),
(605, 'LED-GRUEN_ROW-2', 0),
(606, 'LED-GRUEN_ROW-4', 0),
(607, 'LED-GRUEN_ROW-1', 0),
(608, 'LED-GRUEN_ROW-2', 0),
(609, 'LED-GRUEN_ROW-3', 0),
(610, 'LED-GRUEN_ROW-5', 0),
(611, 'LED-ROT_3MM', 0),
(612, 'LED-ROT_5MM-eckig', 0),
(613, 'LED-ROT_ROW-1', 0),
(614, 'LED-ROT_ROW-2', 0),
(615, 'LED-GRUEN_ROW-4', 0),
(616, 'LED-BLAU_ROW-4', 0),
(617, 'LED-ROT_3MM', 0),
(618, 'LED-ROT_5MM', 0),
(619, 'LED-ROT_ROW-1', 0),
(620, 'LED-ROT_ROW-3', 0),
(621, 'LED-ROT_ROW-5', 0),
(622, 'LED-ROT_ROW-2', 0),
(623, 'LED-ROT_ROW-4', 0),
(624, 'LED-ROT_ROW-5', 0),
(625, 'LED-BLAU_ROW-4', 0),
(626, 'LED-TRANSPARENT_3MM', 0),
(627, 'LED-TRANSPARENT_5MM-eckig', 0),
(628, 'LED-TRANSPARENT_5MM', 0),
(629, 'LED-TRANSPARENT_ROW-1', 0),
(630, 'LED-BLAU_0603', 0),
(631, 'LED-BLAU_0805', 0),
(632, 'LED-BLAU_1206', 0),
(633, 'LED-GRUEN_0603', 0),
(634, 'LED-GRUEN_0805', 0),
(635, 'LED-GRUEN_1206', 0),
(636, 'LED-ROT_0603', 0),
(637, 'LED-ROT_0805', 0),
(638, 'LED-ROT_1206', 0),
(639, 'LED-TRANSPARENT_0603', 0),
(640, 'LED-TRANSPARENT_0805', 0),
(641, 'LED-TRANSPARENT_1206', 0),
(642, 'SPULE_PDM', 0),
(643, 'SPULE_PD_L', 0),
(644, 'SPULE_PD_M', 0),
(645, 'SPULE_PD_S', 0),
(646, 'SPULE_PD_XL', 0),
(647, 'SPULE_PD_XXL', 0),
(648, 'KONDENSATOR_CTS_A_15MM', 0),
(649, 'KONDENSATOR_CTS_B_20MM', 0),
(650, 'KONDENSATOR_CTS_C_25MM', 0),
(651, 'KONDENSATOR_CTS_D_30MM', 0),
(652, 'ELKO_AXIAL_10D_22L', 0),
(653, 'ELKO_AXIAL_10D_25L', 0),
(654, 'SPULE_TYCO_H38', 0),
(655, 'ELKO_AXIAL_10D_30L', 0),
(656, 'ELKO_AXIAL_12D_30L', 0),
(657, 'ELKO_AXIAL_12D_35L', 0),
(658, 'ELKO_AXIAL_14D_35L', 0),
(659, 'ELKO_AXIAL_16D_30L', 0),
(660, 'ELKO_AXIAL_16D_35L', 0),
(661, 'ELKO_AXIAL_16D_45L', 0),
(662, 'ELKO_AXIAL_18D_35L', 0),
(663, 'ELKO_AXIAL_18D_45L', 0),
(664, 'ELKO_AXIAL_22D_45L', 0),
(665, 'ELKO_AXIAL_25D_45L', 0),
(666, 'ELKO_AXIAL_25D_50L', 0),
(667, 'ELKO_AXIAL_21D_45L', 0),
(668, 'ELKO_AXIAL_22D_45L', 0),
(669, 'ELKO_AXIAL_25D_55L', 0),
(670, 'ELKO_AXIAL_30D_50L', 0),
(671, 'ELKO_AXIAL_30D_55L', 0),
(672, 'ELKO_AXIAL_5D_15L', 0),
(673, 'ELKO_AXIAL_6D_15L', 0),
(674, 'ELKO_AXIAL_6D_22L', 0),
(675, 'ELKO_AXIAL_9D_15L', 0),
(676, 'ELKO_AXIAL_9D_22L', 0),
(677, 'ELKO_AXIAL_9D_25L', 0),
(678, 'ELKO_RADIAL_2RM5_5D', 0),
(679, 'ELKO_RADIAL_2RM5_6D3', 0),
(680, 'ELKO_RADIAL_3RM5_8D', 0),
(681, 'ELKO_RADIAL_5RM_10D', 0),
(682, 'ELKO_RADIAL_5RM_10D_H', 0),
(683, 'ELKO_RADIAL_5RM_12D5', 0),
(684, 'ELKO_RADIAL_2RM_5D', 0),
(685, 'ELKO_RADIAL_3RM5_8D', 0),
(686, 'ELKO_RADIAL_5RM_12D5_H', 0),
(687, 'ELKO_RADIAL_7RM5_16D', 0),
(688, 'ELKO_RADIAL_7RM5_16D_H', 0),
(689, 'ELKO_RADIAL_7RM5_16D_T', 0),
(690, 'ELKO_RADIAL_7RM5_18D', 0),
(691, 'ELKO_SMD_0505', 0),
(692, 'ELKO_SMD_0405', 0),
(693, 'ELKO_SMD_0505', 0),
(694, 'ELKO_SMD_0605', 0),
(695, 'ELKO_SMD_0807', 0),
(696, 'ELKO_SMD_0808', 0),
(697, 'ELKO_SMD_0810', 0),
(698, 'ELKO_SMD_1010', 0),
(699, 'ELKO_SMD_1012', 0),
(700, 'ELKO_SMD_1014', 0),
(701, 'ELKO_SMD_1212', 0),
(702, 'ELKO_SMD_1214', 0),
(703, 'ELKO_SMD_PANASONIC_C', 0),
(704, 'ELKO_SMD_PANASONIC_D', 0),
(705, 'ELKO_SMD_PANASONIC_F', 0),
(706, 'ELKO_SMD_PANASONIC_G', 0),
(707, 'FOLIENKONDENSATOR_100_040_130_095', 0),
(708, 'FOLIENKONDENSATOR_100_050_130_110', 0),
(709, 'FOLIENKONDENSATOR_100_060_130_120', 0),
(710, 'FOLIENKONDENSATOR_150_050_180_110', 0),
(711, 'ELKO_SMD_PANASONIC_D', 0),
(712, 'ELKO_SMD_PANASONIC_B', 0),
(713, 'ELKO_SMD_PANASONIC_G', 0),
(714, 'ELKO_SMD_PANASONIC_E', 0),
(715, 'FOLIENKONDENSATOR_150_060_180_125', 0),
(716, 'FOLIENKONDENSATOR_150_070_180_140', 0),
(717, 'FOLIENKONDENSATOR_150_080_180_150', 0),
(718, 'FOLIENKONDENSATOR_150_090_180_160', 0),
(719, 'FOLIENKONDENSATOR_225_060_265_150', 0),
(720, 'FOLIENKONDENSATOR_225_070_265_165', 0),
(721, 'FOLIENKONDENSATOR_225_085_265_185', 0),
(722, 'FOLIENKONDENSATOR_225_105_265_190', 0),
(723, 'FOLIENKONDENSATOR_225_110_265_210', 0),
(724, 'FOLIENKONDENSATOR_275_090_315_210', 0),
(725, 'FOLIENKONDENSATOR_275_110_315_210', 0),
(726, 'FOLIENKONDENSATOR_275_130_315_240', 0),
(727, 'FOLIENKONDENSATOR_275_150_315_260', 0),
(728, 'FOLIENKONDENSATOR_275_170_315_345', 0),
(729, 'FOLIENKONDENSATOR_275_200_315_395', 0),
(730, 'FOLIENKONDENSATOR_325_160_415_320', 0),
(731, 'FOLIENKONDENSATOR_325_180_415_395', 0),
(732, 'FOLIENKONDENSATOR_325_140_415_260', 0),
(733, 'FOLIENKONDENSATOR_375_150_415_260', 0),
(734, 'FOLIENKONDENSATOR_375_190_415_320', 0),
(735, 'FOLIENKONDENSATOR_375_200_415_395', 0),
(736, 'FOLIENKONDENSATOR-WIMA_10RM-4B-13L-9H5', 0),
(737, 'FOLIENKONDENSATOR-WIMA_10RM-5B-13L-11H', 0),
(738, 'FOLIENKONDENSATOR-WIMA_10RM-6B-13L-12H', 0),
(739, 'FOLIENKONDENSATOR-WIMA_15RM-5B-18L-11H', 0),
(740, 'FOLIENKONDENSATOR-WIMA_15RM-6B-18L-12H5', 0),
(741, 'FOLIENKONDENSATOR-WIMA_15RM-7B-18L-14H', 0),
(742, 'FOLIENKONDENSATOR-WIMA_15RM-8B-18L-15H', 0),
(743, 'FOLIENKONDENSATOR-WIMA_15RM-9B-18L-16H', 0),
(744, 'FOLIENKONDENSATOR-WIMA_22RM5-10B5-26L5-19H', 0),
(745, 'FOLIENKONDENSATOR-WIMA_22RM5-11B-26L5-21H', 0),
(746, 'FOLIENKONDENSATOR-WIMA_22RM5-6B-26L5-15H', 0),
(747, 'FOLIENKONDENSATOR-WIMA_22RM5-7B-26L5-16H5', 0),
(748, 'FOLIENKONDENSATOR-WIMA_22RM5-8B5-26L5-18H5', 0),
(749, 'FOLIENKONDENSATOR-WIMA_27RM5-11B-31L5-21H', 0),
(750, 'FOLIENKONDENSATOR-WIMA_27RM5-13B-31L5-24H', 0),
(751, 'FOLIENKONDENSATOR-WIMA_27RM5-15B-31L5-26H', 0),
(752, 'FOLIENKONDENSATOR-WIMA_27RM5-17B-31L5-34H5', 0),
(753, 'FOLIENKONDENSATOR-WIMA_27RM5-20B-31L5-39H5', 0),
(754, 'FOLIENKONDENSATOR-WIMA_27RM5-9B-31L5-21H', 0),
(755, 'FOLIENKONDENSATOR-WIMA_2RM5-2B5-4L6-7H5', 0),
(756, 'FOLIENKONDENSATOR-WIMA_2RM5-3B-4L6-7H5', 0),
(757, 'FOLIENKONDENSATOR-WIMA_2RM5-4B-4L6-9H', 0),
(758, 'FOLIENKONDENSATOR-WIMA_2RM5-5B-4L6-10H', 0),
(759, 'FOLIENKONDENSATOR-WIMA_2RM5-6B-4L6-10H', 0),
(760, 'FOLIENKONDENSATOR-WIMA_37RM5-15B-41L5-26H', 0),
(761, 'FOLIENKONDENSATOR-WIMA_37RM5-19B-41L5-32H', 0),
(762, 'FOLIENKONDENSATOR-WIMA_37RM5-20B-41L5-39H5', 0),
(763, 'FOLIENKONDENSATOR-WIMA_5RM-2B5-7L2-6H5', 0),
(764, 'FOLIENKONDENSATOR-WIMA_5RM-3B-7L2-7H5', 0),
(765, 'FOLIENKONDENSATOR-WIMA_5RM-3B5-7L2-8H5', 0),
(766, 'FOLIENKONDENSATOR-WIMA_5RM-4B5-7L2-9H5', 0),
(767, 'FOLIENKONDENSATOR-WIMA_5RM-5B-7L2-10H', 0),
(768, 'FOLIENKONDENSATOR-WIMA_5RM-5B5-7L2-11H5', 0),
(769, 'FOLIENKONDENSATOR-WIMA_5RM-7B2-7L2-13H', 0),
(770, 'FOLIENKONDENSATOR-WIMA_5RM-8B5-7L2-14H', 0),
(771, 'FOLIENKONDENSATOR-WIMA_7RM5-3B-10L-8H5', 0),
(772, 'FOLIENKONDENSATOR-WIMA_7RM5-4B-10L-9H', 0),
(773, 'FOLIENKONDENSATOR-WIMA_7RM5-5B-10L3-10H5', 0),
(774, 'FOLIENKONDENSATOR-WIMA_7RM5-5B7-10L-12H5', 0),
(775, 'KERKO_10RM-13D', 0),
(776, 'KERKO_10RM-18D', 0),
(777, 'KERKO_10RM-25D', 0),
(778, 'KERKO_2RM5-3D8', 0),
(779, 'KERKO_2RM5-4D4', 0),
(780, 'KERKO_2RM5-5D', 0),
(781, 'KERKO_5RM-10D', 0),
(782, 'KERKO_5RM-13D', 0),
(783, 'KERKO_5RM-3D8', 0),
(784, 'KERKO_5RM-4D4', 0),
(785, 'KERKO_5RM-5D', 0),
(786, 'KERKO_5RM-6D', 0),
(787, 'KERKO_5RM-8D', 0),
(788, 'KERKO_6RM4-10D', 0),
(789, 'KERKO_5RM-7D6', 0),
(790, 'KERKO_5RM-8D', 0),
(791, 'KERKO_6RM4-12D', 0),
(792, 'KERKO_6RM4-5D', 0),
(793, 'KERKO_6RM4-6D5', 0),
(794, 'KERKO_6RM4-7D4', 0),
(795, 'KERKO_7RM5-10D', 0),
(796, 'KERKO-SMD_0402', 0),
(797, 'KERKO-SMD_0603', 0),
(798, 'KERKO-SMD_0402', 0),
(799, 'KERKO-SMD_0805', 0),
(800, 'KERKO-SMD_1206', 0),
(801, 'KERKO-SMD_1210', 0),
(802, 'KERKO-SMD_1812', 0),
(803, 'KERKO-SMD_1825', 0),
(804, 'KERKO-SMD_2220', 0),
(805, 'KERKO-SMD_1206', 0),
(806, 'TANTAL_2RM5-10D', 0),
(807, 'TANTAL_2RM5-4D', 0),
(808, 'TANTAL_2RM5-4D5', 0),
(809, 'TANTAL_2RM5-5D', 0),
(810, 'TANTAL_2RM5-6D', 0),
(811, 'TANTAL_2RM5-6D5', 0),
(812, 'TANTAL_2RM5-5D5', 0),
(813, 'TANTAL_2RM5-6D', 0),
(814, 'TANTAL_2RM5-7D', 0),
(815, 'TANTAL_2RM5-8D', 0),
(816, 'TANTAL_2RM5-8D5', 0),
(817, 'TANTAL_2RM5-9D', 0),
(818, 'TANTAL_5RM-10D', 0),
(819, 'TANTAL_5RM-4D5', 0),
(820, 'TANTAL_5RM-5D', 0),
(821, 'TANTAL_5RM-11D', 0),
(822, 'TANTAL_5RM-5D5', 0),
(823, 'TANTAL_5RM-6D', 0),
(824, 'TANTAL_5RM-6D5', 0),
(825, 'TANTAL_5RM-7D', 0),
(826, 'TANTAL_5RM-8D', 0),
(827, 'TANTAL_5RM-8D5', 0),
(828, 'TANTAL_5RM-9D', 0),
(829, 'TANTAL-SMD_SCT-B', 0),
(830, 'TANTAL-SMD_SCT-D', 0),
(831, 'TANTAL-SMD_SCT-A', 0),
(832, 'TANTAL-SMD_SCT-B', 0),
(833, 'TANTAL-SMD_SCT-C', 0),
(834, 'TANTAL-SMD_SCT-E', 0),
(835, 'TANTAL-SMD_SCT-R', 0),
(836, 'WIDERSTAND-KOHLE_0204', 0),
(837, 'WIDERSTAND-KOHLE_0207', 0),
(838, 'WIDERSTAND-KOHLE_0414', 0),
(839, 'WIDERSTAND-KOHLE_0617', 0),
(840, 'WIDERSTAND-KOHLE_0309', 0),
(841, 'WIDERSTAND-KOHLE_0414', 0),
(842, 'WIDERSTAND-KOHLE_0922', 0),
(843, 'WIDERSTAND_SIL06', 0),
(844, 'WIDERSTAND_SIL07', 0),
(845, 'WIDERSTAND_SIL08', 0),
(846, 'WIDERSTAND_SIL09', 0),
(847, 'WIDERSTAND_SIL10', 0),
(848, 'WIDERSTAND_SIL05', 0),
(849, 'WIDERSTAND_SIL11', 0),
(850, 'WIDERSTAND_SIL12', 0),
(851, 'WIDERSTAND_SIL13', 0),
(852, 'WIDERSTAND_SIL14', 0),
(853, 'WIDERSTAND-SMD-ARRAY_4X0603-0612', 0),
(854, 'WIDERSTAND-SMD_0102-MLF', 0),
(855, 'WIDERSTAND-SMD_0402', 0),
(856, 'WIDERSTAND-SMD_0603', 0),
(857, 'WIDERSTAND-SMD_0805', 0),
(858, 'WIDERSTAND-SMD_1206', 0),
(859, 'WIDERSTAND-SMD_1210', 0),
(860, 'WIDERSTAND-SMD_1218', 0),
(861, 'WIDERSTAND-SMD_2010', 0),
(862, 'WIDERSTAND-SMD_2512', 0),
(863, 'TRIMMER_64W', 0),
(864, 'TRIMMER_64Y', 0),
(865, 'TRIMMER_PT10-H', 0),
(866, 'TRIMMER_PT15-H', 0),
(867, 'TRIMMER_T18', 0),
(868, 'TRIMMER_TS53-YJ', 0),
(869, 'TRIMMER_TS53-YL', 0),
(870, 'TRIMMER_TSM-4YJ', 0),
(871, 'TRIMMER_TSM-4YL', 0),
(872, 'VARISTOR_RM10', 0),
(873, 'VARISTOR_RM14', 0),
(874, 'VARISTOR_RM20', 0),
(875, 'VARISTOR_RM5', 0),
(876, 'VARISTOR_RM7', 0),
(877, 'Import', 0),
(878, 'WIDERSTAND-KOHLE_0310', 877),
(879, 'WIDERSTAND-KOHLE_0311', 877),
(880, 'WIDERSTAND-KOHLE_0312', 877),
(881, 'WIDERSTAND-KOHLE_0313', 877),
(882, 'WIDERSTAND-KOHLE_0314', 877),
(883, 'WIDERSTAND-KOHLE_0315', 877),
(884, 'WIDERSTAND-KOHLE_0316', 877),
(885, 'WIDERSTAND-KOHLE_0317', 877),
(886, 'WIDERSTAND-KOHLE_0318', 877),
(887, 'WIDERSTAND-KOHLE_0319', 877),
(888, 'WIDERSTAND-KOHLE_0320', 877),
(890, 'MSOP8', 877),
(891, 'DC/DC', 877),
(892, 'IC_SOT23-8', 877),
(893, 'C_DPAK-369C', 877),
(894, 'SMD', 877);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `internal`
--

CREATE TABLE IF NOT EXISTS `internal` (
  `keyName` char(30) CHARACTER SET ascii NOT NULL,
  `keyValue` char(30) DEFAULT NULL,
  UNIQUE KEY `keyName` (`keyName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `internal`
--

INSERT INTO `internal` (`keyName`, `keyValue`) VALUES
('dbVersion', '11'),
('dbAutoUpdate', '0');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `parts`
--

CREATE TABLE IF NOT EXISTS `parts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_category` int(11) NOT NULL DEFAULT '0',
  `name` mediumtext NOT NULL,
  `description` mediumtext,
  `instock` int(11) NOT NULL DEFAULT '0',
  `mininstock` int(11) NOT NULL DEFAULT '0',
  `comment` mediumtext NOT NULL,
  `obsolete` tinyint(1) NOT NULL DEFAULT '0',
  `visible` tinyint(1) NOT NULL,
  `id_footprint` int(11) NOT NULL DEFAULT '0',
  `id_storeloc` int(11) NOT NULL DEFAULT '0',
  `id_supplier` int(11) NOT NULL DEFAULT '0',
  `supplierpartnr` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_storeloc` (`id_storeloc`),
  KEY `id_category` (`id_category`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=153 ;

--
-- Daten für Tabelle `parts`
--

INSERT INTO `parts` (`id`, `id_category`, `name`, `description`, `instock`, `mininstock`, `comment`, `obsolete`, `visible`, `id_footprint`, `id_storeloc`, `id_supplier`, `supplierpartnr`) VALUES
(1, 36, '1 Ohm', '', 20, 0, '', 0, 0, 840, 4, 0, ''),
(2, 36, '7,5 Ohm', '', 20, 0, '', 0, 0, 840, 4, 0, ''),
(3, 36, '10 Ohm', '', 20, 0, '', 0, 0, 840, 4, 0, ''),
(4, 36, '22 Ohm', '', 20, 0, '', 0, 0, 840, 4, 0, ''),
(5, 36, '33 Ohm', '', 20, 0, '', 0, 0, 840, 4, 0, ''),
(6, 36, '47 Ohm', '', 20, 0, '', 0, 0, 840, 4, 0, ''),
(7, 36, '68 Ohm', '', 20, 0, '', 0, 0, 840, 4, 0, ''),
(8, 36, '75 Ohm', '', 20, 0, '', 0, 0, 840, 4, 0, ''),
(9, 36, '100 Ohm', '', 20, 0, '', 0, 0, 840, 4, 0, ''),
(30, 36, '680 Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(29, 36, '470 Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(28, 36, '360 Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(27, 36, '220 Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(26, 36, '150 Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(25, 36, '130 Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(24, 36, '100 Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(31, 36, '1k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(32, 38, '1,3k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(33, 38, '1,8k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(34, 38, '2,2k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(35, 38, '3k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(36, 38, '3,6k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(37, 38, '3,9k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(38, 38, '4,7k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(39, 38, '5,6k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(40, 38, '6,8k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(41, 38, '8,2k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(42, 38, '10k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 4, 1, ''),
(43, 38, '12k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(44, 38, '22k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(45, 38, '33k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(46, 38, '39k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(47, 38, '47k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(48, 38, '56k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(49, 38, '68k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(50, 38, '100k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(51, 37, '130k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(52, 37, '150k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(53, 37, '180k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(54, 37, '220k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(55, 37, '270k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(56, 37, '330k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(57, 37, '390k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(58, 37, '470k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(59, 37, '560k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(60, 37, '680k Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(61, 37, '1M Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(62, 62, '2,7M Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(63, 62, '3,3M Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(64, 62, '4,7M Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(65, 62, '10M Ohm', 'Widerstand', 20, 0, '', 0, 0, 840, 5, 1, ''),
(68, 43, 'STCN75', 'Temperatur Sensor', 3, 0, 'Temperatur Sensor Digital I2C', 0, 0, 890, 6, 2, ''),
(69, 29, 'STP210N75F6', 'Mosfet', 5, 0, 'Mosfet 75V 120A', 0, 0, 160, 7, 2, ''),
(70, 6, 'SN74HCT14DR', 'Schmitt Trigger', 5, 0, 'Schmitt-Trigger Invert', 0, 0, 100, 6, 3, ''),
(71, 6, 'SN74AHCT14QDRQ1', 'Schmitt Trigger', 5, 0, 'Schmitt-Trigger Invert', 0, 0, 100, 6, 3, ''),
(72, 6, 'SN74AHCT14QDRQ1', 'Schmitt Trigger', 5, 0, 'Schmitt-Trigger Invert', 0, 0, 100, 6, 3, ''),
(73, 13, 'M24M02', 'EEPROM', 3, 0, '2Mbit EEPROM 1MHZ SPI', 0, 0, 99, 6, 2, ''),
(74, 6, 'SN74F04NSR', 'INVERTER', 5, 0, 'Hex Inverter', 0, 0, 100, 6, 3, ''),
(75, 57, 'BC337', 'NPN Transistor', 6, 0, 'NPN Transistor', 0, 0, 176, 7, 4, ''),
(76, 26, 'PTV12020WAD', 'DC/DC', 2, 0, '1.2 to 5.5 V 16-A, 12-V Input, Non-Isolated', 0, 0, 891, 11, 3, ''),
(77, 26, 'PTN78020WAS', 'DC/DC', 2, 0, '2,5 bis 12,6V 6A 7-36V Input', 0, 0, 891, 11, 3, ''),
(78, 26, 'PTH08T250', 'DC/DC', 1, 0, '0,7-3,6V 50A 4,5-14V Input', 0, 0, 891, 11, 3, ''),
(79, 26, 'PTH080T230', 'DC/DC', 1, 0, '0,7-5,5V 6A 4,5-14V Input', 0, 0, 891, 11, 3, ''),
(80, 26, 'PTH08T255', 'DC/DC', 1, 0, '3,5,25V 40A 8-14V Input', 0, 0, 891, 11, 3, ''),
(81, 26, 'PTH12050', 'DC/DC', 1, 0, '1,2-5,5V 6A 10,8-13,2V Input', 0, 0, 891, 11, 3, ''),
(82, 26, 'PTV12010WAH', 'DC/DC', 2, 2, '1.2 to 5.5 V 6-A, 12-V', 0, 0, 891, 11, 3, ''),
(83, 7, 'TCA9509DGKR', 'Level Konverter', 5, 0, 'Level Konverter I2C Bus', 0, 0, 99, 6, 3, ''),
(84, 63, 'UCC27524', 'Gate Treiber', 3, 0, 'Low Side Mosfet Treiber 5A', 0, 0, 49, 7, 3, ''),
(85, 10, 'TXB0104', 'Level Konverter', 3, 0, 'Level Konverter Bus', 0, 0, 100, 6, 3, ''),
(86, 7, 'P82B96', 'Buffer', 8, 0, 'Buffer Level Konverter\r\n\r\nLevel Converter', 0, 0, 49, 6, 3, ''),
(87, 43, 'TMP101', 'Temperatur Sensor', 3, 0, 'Digitaler Temperatur Sensor', 0, 0, 120, 6, 3, ''),
(88, 26, 'PTH08T240', 'DC/DC', 1, 0, '0,7-5,5V 10A 4,5-14V Input', 0, 0, 891, 11, 3, ''),
(89, 63, 'HIP4081AIB', 'H-Brücke Treiber', 8, 0, 'H-Brücken Treiber 2A', 0, 0, 104, 7, 5, ''),
(90, 64, 'STTH3012W', 'Diode', 3, 0, '1200V 30A', 0, 0, 162, 8, 2, ''),
(91, 13, 'M95M02', 'EEPROM', 7, 0, '2Mbit SPI EEPROM', 0, 0, 99, 6, 2, ''),
(92, 10, 'MAX3378EEUD', 'Level Konverter', 5, 0, '15kV ESD-Protected / 1A / 16Mbps / Dual/Quad Low-Voltage Level Translators', 0, 0, 892, 6, 6, ''),
(93, 48, 'UCC283T', 'Spannungsregler', 3, 0, '3A Low Dropout', 0, 0, 160, 9, 3, ''),
(94, 43, 'STTS75', 'Temperatur Sensor', 2, 0, 'I2C Temperatur Sensor (LM75)', 0, 0, 99, 6, 2, ''),
(95, 7, '  ADS1110A4IDBVT', 'I2C ADC', 3, 0, '16-Bit 15SPS Delta-Sigma ADC with internal reference', 0, 0, 120, 6, 3, ''),
(96, 63, 'UCC27425', 'Gate Treiber', 3, 0, 'Dual Mosfet Treiber 4A', 0, 0, 49, 7, 3, ''),
(97, 26, 'PTN78020WAH', 'DC/DC', 5, 0, '2,5 bis 12,6V 6A 7-36V Input', 0, 0, 891, 11, 3, ''),
(98, 65, 'STPS20H100', 'Diode', 10, 0, '100V 10A D2PAK', 0, 0, 42, 8, 2, ''),
(99, 7, '  ADS1110A0IDBVT', 'I2C ADC', 5, 0, '16-Bit 15SPS Delta-Sigma ADC with internal reference', 0, 0, 120, 6, 3, ''),
(100, 9, 'AT90PWM3B', 'Atmega', 2, 0, 'Atmega für PWM', 0, 0, 107, 10, 7, ''),
(101, 63, 'ULN2803AN', 'Darlington Treiber', 5, 0, 'Darlington Treiber', 0, 0, 49, 7, 3, ''),
(102, 48, 'ISL80138IVEA', 'Spannungswandler', 2, 0, '40V, Low Quiescent Current, 150mA Linear Regulator', 0, 0, 109, 9, 5, ''),
(103, 14, 'ISL2242UFV14', 'Potentiomerter Digital', 2, 0, 'Dual Digitally Controlled Potentiometer', 0, 0, 109, 6, 5, ''),
(104, 65, 'STPS40M80CG', 'SCHOTTKY Diode', 10, 0, 'Diode 80V 40A D2Pak', 0, 0, 42, 8, 2, ''),
(105, 48, 'ICL7663SACBA', 'Spannungswandler', 2, 0, 'Positive Voltage Regulator 40mA', 0, 0, 99, 9, 5, ''),
(106, 26, 'PTN78060WAH', 'DC/DC', 3, 0, '2,5V-12,6V  3A 7-36V Input', 0, 0, 891, 11, 3, ''),
(107, 26, 'PTN78000WAH', 'DC/DC', 0, 1, '2,5V-12,6V  1,5A 7-36V Input', 0, 0, 891, 11, 3, ''),
(108, 15, 'NA555P', 'Timer', 3, 0, 'Timer 555', 0, 0, 49, 10, 3, ''),
(109, 49, 'TS822AILT', 'Referenzspannung', 1, 0, 'Referenz Spannung 2,5V', 0, 0, 123, 9, 2, ''),
(110, 46, 'UCC383T-5G3', 'Regler 5V/3A', 3, 0, 'LOW DROPOUT 3-A', 0, 0, 160, 9, 3, ''),
(111, 70, 'MAX232AE', 'Max232', 5, 0, '5V-Powered, Multichannel RS-232 Drivers/Receivers', 0, 0, 55, 10, 6, ''),
(112, 13, 'M24C16', '16Kbit EEPROM I2C', 1, 0, 'I2C EEPROM 16kBit', 0, 0, 99, 6, 2, ''),
(113, 48, 'UCC383T-ADJ', 'Regler 3A', 3, 0, 'LOW DROPOUT 3-A', 0, 0, 160, 9, 3, ''),
(114, 26, 'PTR08060W', 'DC/DC', 2, 2, '0,6 V to 5,5 V 6A 4.5 V to 14 V Input', 0, 0, 891, 11, 3, ''),
(115, 46, 'PT79SR105', '( -5V ) 1,5A Spannungswandler', 1, 0, '( -5V ) Spannungswandler', 0, 0, 894, 11, 3, ''),
(116, 7, 'P82B715PE4', 'I2C Bus Extender', 5, 0, 'Bus Extener für I2C ( Besser P82B96 verwenden )', 0, 0, 49, 6, 3, ''),
(117, 49, 'MCP1541T', 'Referenzspannung', 5, 0, 'Referenzspannungsquelle 4,069V', 0, 0, 123, 9, 0, ''),
(118, 7, 'MAX3379EE', 'Low-Voltage Level Translators in UCSP', 5, 0, 'Low-Voltage Level Translators in UCSP', 0, 0, 99, 6, 0, ''),
(119, 10, 'ADUM1401CRW', 'Isolator 4 CH', 7, 0, '4 Kanal Isolator \r\n4 CH Isolator', 0, 0, 102, 12, 0, ''),
(121, 48, 'TL783CKC', 'HIGH-VOLTAGE ADJUSTABLE REGULATOR', 5, 0, 'HIGH-VOLTAGE ADJUSTABLE REGULATOR\r\nOutput Adjustable From 1.25 V to 125 V\r\nAusgang von 1,25 bis 125V', 0, 0, 160, 9, 3, ''),
(122, 65, 'STPS40SM80', 'Schottky Diode 80V 40A', 2, 5, 'Diode 40A 80V D2PAK für PROJEKT AURA', 0, 0, 42, 8, 2, ''),
(123, 45, 'UCC383T-3', 'LDO Linear Regler 3.3V', 3, 0, 'Low Dropout 3A Regler\r\n3.3V  3,3V Ausganspannung', 0, 0, 160, 9, 0, ''),
(135, 15, 'SE555P', 'Timer', 3, 0, 'PRECISION TIMER', 0, 0, 49, 10, 3, ''),
(136, 14, 'MAX5392', 'Potentiomerter Digital', 5, 0, 'Dual, 256-Tap, Volatile, Low-Voltage, Linear Taper Digital Potentiometer', 0, 0, 142, 6, 6, ''),
(125, 7, 'ADUM1250', 'I2C Isolator', 6, 0, 'Hot Swappable Dual I2C Isolators\r\n1000 kHz operation \r\n3.0 V to 5.5 V supply/logic levels ', 0, 0, 99, 12, 8, ''),
(126, 63, 'HIP4081AIPZ', 'H-Brücke Treiber', 8, 0, '80V/2.5A Peak, High Frequency Full \r\nBridge FET Driver', 0, 0, 59, 7, 0, ''),
(127, 10, 'MAX3391EE', ' Dual/Quad  Low-Voltage Level Translators', 5, 0, 'Dual/Quad Low-Voltage Level Translators', 0, 0, 142, 6, 6, ''),
(128, 63, 'UCC27321P', 'Gate Treiber', 3, 0, 'SINGLE 9-A HIGH SPEED LOW SIDE MOSFET DRIVER WITH ENABLE', 0, 0, 49, 7, 3, ''),
(129, 7, 'ISL33001', 'I2C Buffer', 1, 2, 'I2C Bus Buffer with Rise Time Accelerators and Hot Swap Capability', 0, 0, 99, 6, 5, ''),
(130, 26, 'PTR08100', 'DC/DC', 2, 0, 'PTR08100W - 10-A, 4.5-V to 14-V INPUT, NON-ISOLATED, ADJUSTABLE WIDE-OUTPUT, SWITCHING REGULATOR ', 0, 0, 891, 11, 3, ''),
(131, 63, 'UCC27322', 'Gate Treiber', 3, 0, 'SINGLE 9-A HIGH SPEED LOW SIDE MOSFET DRIVER WITH ENABLE', 0, 0, 49, 7, 3, ''),
(132, 10, 'SN74LVC8T245', 'Pegel Konverter 8 bit', 1, 2, 'SN74LVC8T245-EP - 8-BIT DUAL-SUPPLY BUS TRANSCEIVER WITH CONFIGURABLE VOLTAGE TRANSLATION AND 3-STATE OUTPUTS', 0, 0, 112, 6, 3, ''),
(133, 49, 'MCP1541-I', 'Referenzspannung', 5, 0, '4,096V Refernzspannungsquelle', 0, 0, 176, 9, 5, ''),
(137, 43, 'TMP100NA', 'Temperatur Sensor', 3, 0, 'Digital Temperature Sensor with I2C Interface', 0, 0, 120, 6, 3, ''),
(138, 48, 'TL2575HV', 'Spannungsregler', 5, 0, '1-A SIMPLE STEP-DOWN SWITCHING VOLTAGE REGULATORS', 0, 0, 159, 9, 3, ''),
(139, 10, 'ADS1110A5IDBVT', 'Analog-Digital Konverter', 5, 0, '16-Bit ANALOG-TO-DIGITAL CONVERTER with Onboard Reference', 0, 0, 120, 12, 3, ''),
(140, 49, 'MCP1525', 'Referenzspannung', 5, 0, '2.5V Voltage Reference', 0, 0, 176, 9, 5, ''),
(141, 7, 'PCA9515', 'I2C Bus Extender', 5, 0, 'DUAL BIDIRECTIONAL I2C BUS AND SMBus REPEATER', 0, 0, 890, 6, 3, ''),
(142, 7, 'ADS1100A2IDBVT', 'I2C ADC', 5, 0, 'ADC Self-Calibrating 16-Bit Analog to Digital Converters', 0, 0, 120, 6, 3, ''),
(143, 13, 'SST26VF032', 'Serial Quad Flash Memory', 3, 0, '32 Mbit\r\nOp. Volt Range (V) 2.7 to 3.6\r\nMax. Clock Freq. 80 MHz', 0, 0, 99, 6, 2, ''),
(144, 26, 'PTH08T221', 'DC/DC', 1, 0, '4,5-14V IN\r\n0,7-5,5V Out\r\n16A', 0, 0, 891, 11, 3, ''),
(145, 72, '16x2 Display', '16x2 Display', 2, 0, 'Normale Display für µC und andere Sachen\r\nHD44780', 0, 0, 0, 0, 1, ''),
(146, 27, 'RFM70', 'Funk Modul', 3, 0, 'RFM70 2.4Ghz Module \r\nAnschluss über SPI an Atmega\r\nhttp://www.google.at/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&ved=0CCMQFjAA&url=http%3A%2F%2Fwww.hoperf.com%2Fupload%2Frf%2Frfm70.pdf&ei=iL-cULvXK6nE4gSR7IDgBw&usg=AFQjCNGPnRMgpRt5aXUQslgmxDMH2aT2oQ&sig2=hFFx2X__R5ZcOBANjOFbbg', 0, 0, 0, 0, 0, ''),
(147, 10, 'SN74LVC8T245', 'Level Konvertet 8 bit dual', 3, 0, 'Pegel Wandler Level Konverter', 0, 0, 105, 6, 3, ''),
(148, 26, 'PTN78020HAH', 'DC/DC', 1, 0, '15 V to 36 V Input\r\n11.85 V to 22 V Output\r\n6-A', 0, 0, 0, 11, 3, ''),
(149, 11, 'AD7843A', 'SPI Touch Controller', 2, 0, 'SPI Touch Controller', 0, 0, 0, 12, 0, ''),
(150, 10, 'ADG33004B', 'Pegel Wander', 2, 0, 'Level Shifter\r\nPegel Wandelr', 0, 0, 0, 12, 8, ''),
(151, 11, 'MXB7843', 'SPI Touch Controller', 4, 0, 'MXB7843 2.375V to 5.25V, 4-Wire Touch-Screen Controller', 0, 0, 0, 12, 6, ''),
(152, 7, 'AD7879', 'I2C Touch Controller', 2, 0, 'AD7879 Input Touch Screen\r\nI2C Touch Controller', 0, 0, 0, 12, 8, '');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `part_device`
--

CREATE TABLE IF NOT EXISTS `part_device` (
  `id_part` int(11) NOT NULL DEFAULT '0',
  `id_device` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `mountname` mediumtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `pending_orders`
--

CREATE TABLE IF NOT EXISTS `pending_orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `part_id` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `t` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `part_id` (`part_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `pictures`
--

CREATE TABLE IF NOT EXISTS `pictures` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `part_id` int(11) NOT NULL DEFAULT '0',
  `pict_fname` varchar(255) NOT NULL DEFAULT '',
  `pict_width` int(11) NOT NULL DEFAULT '0',
  `pict_height` int(11) NOT NULL DEFAULT '0',
  `pict_type` enum('P','T') NOT NULL DEFAULT 'P',
  `tn_obsolete` smallint(6) NOT NULL DEFAULT '0',
  `tn_t` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `tn_pictid` int(11) NOT NULL DEFAULT '0',
  `pict_masterpict` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `pict_type` (`pict_type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `preise`
--

CREATE TABLE IF NOT EXISTS `preise` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `part_id` int(11) NOT NULL DEFAULT '0',
  `id_supplier` int(11) NOT NULL DEFAULT '0',
  `supplierpartnr` mediumtext NOT NULL,
  `manual_input` tinyint(1) NOT NULL DEFAULT '0',
  `price` decimal(6,2) NOT NULL DEFAULT '0.00',
  `last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `part_id` (`part_id`),
  KEY `ma` (`manual_input`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `storeloc`
--

CREATE TABLE IF NOT EXISTS `storeloc` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` tinytext NOT NULL,
  `parentnode` int(11) NOT NULL DEFAULT '0',
  `is_full` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Daten für Tabelle `storeloc`
--

INSERT INTO `storeloc` (`id`, `name`, `parentnode`, `is_full`) VALUES
(1, 'Sortimentkasten', 0, 0),
(2, 'Sortimentkasten_Holz', 0, 0),
(3, 'Kiste_Projekt', 0, 0),
(4, '1-10k Box', 2, 0),
(5, '10k-10M Box', 2, 0),
(6, 'Box1_BUS', 2, 0),
(7, 'Box2_Tran_Mos', 2, 0),
(8, 'Box3_Dioden', 2, 0),
(9, 'Box4_Spannung', 2, 0),
(10, 'Box5_µC', 2, 0),
(11, 'Kiste DC/DC', 0, 0),
(12, 'Box6', 2, 0),
(13, 'Box7', 2, 0),
(14, 'Box8', 2, 0),
(15, 'Box9', 2, 0);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `suppliers`
--

CREATE TABLE IF NOT EXISTS `suppliers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` tinytext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Daten für Tabelle `suppliers`
--

INSERT INTO `suppliers` (`id`, `name`) VALUES
(1, 'Ebay'),
(2, 'STM'),
(3, 'Texas Instruments'),
(4, '-'),
(5, 'Intersil'),
(6, 'Maxim'),
(7, 'Atmel'),
(8, 'Analog Devices');

/*!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 */;
