-- https://www.phpmyadmin.net/
--
-- Erstellungszeit: 12. Nov 2017 um 19:16
-- Server-Version: 5.7.20-0ubuntu0.17.04.1
-- PHP-Version: 7.0.22-0ubuntu0.17.04.1




--
-- Datenbank: `part-db`
--

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

--
-- Tabellenstruktur für Tabelle `attachements`
--

CREATE TABLE `attachements` (
  `id` int(11) NOT NULL,
  `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',
  `last_modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Daten für Tabelle `attachements`
--

INSERT INTO `attachements` (`id`, `name`, `class_name`, `element_id`, `type_id`, `filename`, `show_in_table`, `last_modified`) VALUES
(1, 'Datasheet', 'Part', 171, 2, '%BASE%/data/media/A906011_13_14.pdf', 1, '0000-00-00 00:00:00');

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

--
-- Tabellenstruktur für Tabelle `attachement_types`
--

CREATE TABLE `attachement_types` (
  `id` int(11) NOT NULL,
  `name` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci,
  `datetime_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Daten für Tabelle `attachement_types`
--

INSERT INTO `attachement_types` (`id`, `name`, `parent_id`, `comment`, `datetime_added`, `last_modified`) VALUES
(1, 'Bilder', NULL, NULL, '2017-11-10 17:14:02', '0000-00-00 00:00:00'),
(2, 'Datenblätter', NULL, NULL, '2017-11-10 17:14:02', '0000-00-00 00:00:00');

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

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

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `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',
  `disable_properties` tinyint(1) NOT NULL DEFAULT '0',
  `partname_regex` text COLLATE utf8_unicode_ci NOT NULL,
  `partname_hint` text COLLATE utf8_unicode_ci NOT NULL,
  `default_description` text COLLATE utf8_unicode_ci NOT NULL,
  `default_comment` text COLLATE utf8_unicode_ci NOT NULL,
  `comment` text COLLATE utf8_unicode_ci,
  `datetime_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `categories` (`id`, `name`, `parent_id`, `disable_footprints`, `disable_manufacturers`, `disable_autodatasheets`, `disable_properties`, `partname_regex`, `partname_hint`, `default_description`, `default_comment`, `comment`, `datetime_added`, `last_modified`) VALUES
(1, 'Wiederstände', 23, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(2, 'Aktiv', 35, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(3, 'Stecker', 16, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(4, 'Kondensatoren', 23, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(5, 'Transistoren', 2, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(6, 'Mosfet', 5, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(7, 'Dioden', 2, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(8, 'Festspannungsregler', 39, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(9, 'Kohleschicht', 1, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(10, 'Poti', 1, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(11, 'Audio', 3, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(12, 'Power', 3, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(13, 'Signal', 3, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(14, 'Sonstige', 3, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(15, 'µCs', 32, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(16, 'Mechanisch', 35, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(17, 'Sockel', 16, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(18, 'Schalter / Taster', 16, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(19, 'Klemmen', 16, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(20, 'Kerko', 4, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(21, 'Elko', 4, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(22, 'Folie', 4, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(23, 'Passiv', 35, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(24, 'Quarze', 23, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(26, 'Relais', 16, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(27, 'Pfostenverbinder', 3, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(28, 'Optokopler', 2, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(29, 'Sicherung', 35, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(30, 'Feinsicherung', 29, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(31, 'Induktivitäten', 23, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(32, 'ICs', 2, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(33, 'LEDs', 2, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(34, 'Metallfilm', 1, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '2017-11-11 16:50:57'),
(35, 'Elektronik', NULL, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(36, 'Analog', 32, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(37, 'Digital', 32, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(39, 'Spannungsregler', 2, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(40, 'Bipolar', 5, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(41, 'Mechanik', NULL, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(42, 'Schrauben M-Gewinde', 41, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(43, 'Schrauben PC', 41, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(44, 'Schaltregler', 39, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(45, 'Foto-Wiederstand', 1, 0, 0, 0, 0, '', '', '', '', NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00');

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

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

CREATE TABLE `devices` (
  `id` int(11) NOT NULL,
  `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,
  `last_modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment` text COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Tabellenstruktur für Tabelle `device_parts`
--

CREATE TABLE `device_parts` (
  `id` int(11) NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

CREATE TABLE `footprints` (
  `id` int(11) NOT NULL,
  `name` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `filename` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `filename_3d` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci,
  `datetime_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `footprints` (`id`, `name`, `filename`, `filename_3d`, `parent_id`, `comment`, `datetime_added`, `last_modified`) VALUES
(1, 'DIP08', '%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP08.png', '%BASE%/models/Housings_DIP/DIP-8_W7.62mm.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(2, 'TO247', '%BASE%/img/footprints/Aktiv/ICs/TO/IC_TO247.png', '%BASE%/models/Transistors_TO-247/TO-247_Vertical_FET-GDS.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(3, 'TO220', '%BASE%/img/footprints/Aktiv/ICs/TO/IC_TO220.png', '%BASE%/models/TO_SOT_Packages_THT/TO-220_Neutral123_Vertical.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(4, 'TO220-2', '%BASE%/img/footprints/Aktiv/ICs/TO/IC_TO220-2.png', '%BASE%/models/Diodes_ThroughHole/Diode_TO-220_Vertical.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(5, 'DIP16', '%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP16.png', '%BASE%/models/Housings_DIP/DIP-16_W7.62mm.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(6, 'DO35', '%BASE%/img/footprints/Aktiv/Dioden/Bedrahtet/DIODE_SOD81.png', '%BASE%/models/own/diode_do35.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(7, 'TO92', '%BASE%/img/footprints/Aktiv/ICs/TO/IC_TO92.png', '%BASE%/models/TO_SOT_Packages_THT/TO-92_Molded_Narrow_Oval.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(8, 'ALU_RH5', '%BASE%/img/footprints/Passiv/Widerstaende/Bedrahtet/Aluminium/WIDERSTAND-ALU_RH5.png', '%BASE%/models/Resistors_ThroughHole/Resistor_Ceramic_Horizontal_L36mm-W11mm-H10mm-p45mm.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(9, 'DIP18', '%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP18.png', '%BASE%/models/Housings_DIP/DIP-18_W7.62mm.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(10, 'DIP28', '%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP28.png', '%BASE%/models/Housings_DIP/DIP-28_W7.62mm.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(11, 'SOCKEL_DIP28', '%BASE%/img/footprints/Elektromechanik/IC-Sockel/DIP/SOCKEL_DIP28.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(12, 'TASTER_6X6-BLACK', '%BASE%/img/footprints/Elektromechanik/Schalter_Taster/Drucktaster/TASTER_6X6-BLACK.png', '%BASE%/models/Buttons_Switches_ThroughHole/SW_PUSH_6mm_h8mm.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(13, 'STIFTLEISTE-GERADE-RAHMEN_2X05', '%BASE%/img/footprints/Elektromechanik/Verbinder/Stiftleisten/2-Reihig_mit_Rahmen_gerade/STIFTLEISTE-GERADE-RAHMEN_2X05.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(14, 'PFL_10', '%BASE%/img/footprints/Elektromechanik/Verbinder/Buchsenleisten/2-Reihig_gerade_mit_Rahmen/PFL_10.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(15, 'MPE_094-1-006', '%BASE%/img/footprints/Elektromechanik/Verbinder/Buchsenleisten/1-Reihig_gerade/MPE_094-1-006.png', '%BASE%/models/own/pin_socket_2mm_6.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(16, 'SCHRAUBKLEMME_RM350-03', '%BASE%/img/footprints/Elektromechanik/Verbinder/Schraubklemmen/RM_350/SCHRAUBKLEMME_RM350-03.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(17, 'SCHRAUBKLEMME_RM350-02', '%BASE%/img/footprints/Elektromechanik/Verbinder/Schraubklemmen/RM_350/SCHRAUBKLEMME_RM350-02.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(18, 'FOLIENKONDENSATOR-WIMA_5RM-2B5-7L2-6H5', '%BASE%/img/footprints/Passiv/Kondensatoren/Folie/WIMA/RM_5mm/FOLIENKONDENSATOR-WIMA_5RM-2B5-7L2-6H5.png', '%BASE%/models/own/wima-cap.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(19, 'KERKO_5RM-5D', '%BASE%/img/footprints/Passiv/Kondensatoren/Keramik/Bedrahtet/RM_5mm/KERKO_5RM-5D.png', '%BASE%/models/Capacitors_ThroughHole/C_Disc_D3_P2.5.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(20, 'KERKO_5RM-10D', '%BASE%/img/footprints/Passiv/Kondensatoren/Keramik/Bedrahtet/RM_5mm/KERKO_5RM-10D.png', '%BASE%/models/Capacitors_ThroughHole/C_Disc_D6_P5.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(21, 'KBPC2508', '%BASE%/img/footprints/Aktiv/Gleichrichter/KBPC2508.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(22, 'QUARZ_HC49-4H', '%BASE%/img/footprints/Aktiv/Oszillatoren/Quarze_bedrahtet/QUARZ_HC49-4H.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(23, 'QUARZ_HC18', '%BASE%/img/footprints/Aktiv/Oszillatoren/Quarze_bedrahtet/QUARZ_HC18.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(24, 'DIP14', '%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP14.png', '%BASE%/models/Housings_DIP/DIP-14_W7.62mm_LongPads.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(25, 'DIP40', '%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP40W.png', '%BASE%/models/Housings_DIP/DIP-40_W15.24mm.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(26, 'DO41', '%BASE%/img/footprints/Aktiv/Dioden/Bedrahtet/DIODE_DO41.png', '%BASE%/models/own/diode_do41.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(27, 'DIP04', '%BASE%/img/footprints/Aktiv/ICs/DIP/IC_DIP04.png', '%BASE%/models/Housings_DIP/DIP-4_W7.62mm.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(28, 'PBS-11B', '%BASE%/img/footprints/Elektromechanik/Schalter_Taster/Drucktaster/TASTER_PBS-11B.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(29, 'PFL_20', '%BASE%/img/footprints/Elektromechanik/Verbinder/Buchsenleisten/2-Reihig_gerade_mit_Rahmen/PFL_20.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(30, 'SUB-D_M_FB-09', '%BASE%/img/footprints/Elektromechanik/Verbinder/Sub-D/Maennlich/SUB-D_M_FB-09.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(31, 'SUB-D_W-09', '%BASE%/img/footprints/Elektromechanik/Verbinder/Sub-D/Weiblich/SUB-D_W-09.png', '%BASE%/models/Connect/DB9FD.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(32, 'SUB-D-PLATINENMONTAGE_W-09', '%BASE%/img/footprints/Elektromechanik/Verbinder/Sub-D/Weiblich_Platinenmontage/SUB-D-PLATINENMONTAGE_W-09.png', '%BASE%/models/Connect/DB9FC.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(33, 'STIFTLEISTE-GERADE-RAHMEN_2X10', '%BASE%/img/footprints/Elektromechanik/Verbinder/Stiftleisten/2-Reihig_mit_Rahmen_gerade/STIFTLEISTE-GERADE-RAHMEN_2X10.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(34, 'RELAIS_V23061B1003A401', '%BASE%/img/footprints/Elektromechanik/Relais/RELAIS_V23061B1003A401.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(35, 'RELAIS_F40527-05', '%BASE%/img/footprints/Elektromechanik/Relais/RELAIS_F40527-05.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(36, 'SICHERUNG_6.3x32', '%BASE%/img/footprints/Elektromechanik/Sicherungen/SICHERUNG_6.3x32.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(37, 'WIDERSTAND-KOHLE_0207', '%BASE%/img/footprints/Passiv/Widerstaende/Bedrahtet/Kohleschicht/WIDERSTAND-KOHLE_0207.png', '%BASE%/models/Resistors_ThroughHole/Resistor_Horizontal_RM10mm.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(38, 'TRIMMER_PT15-H', '%BASE%/img/footprints/Passiv/Widerstaende/Trimmer/TRIMMER_PT15-H.png', '%BASE%/models/own/trimmer_piher_pt10-lv.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(39, 'TRIMMER_RS60112-LIN10K', '%BASE%/img/footprints/Passiv/Widerstaende/Trimmer/TRIMMER_RS60112-LIN10K.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(40, 'TRIMMER_M7x7.5', '%BASE%/img/footprints/Passiv/Widerstaende/Trimmer/TRIMMER_M7x7.5.png', '%BASE%/models/Potentiometers/Potentiometer_Alps-RK163-single_15mm.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(42, 'ELKO_RADIAL_2RM_5D', '%BASE%/img/footprints/Passiv/Kondensatoren/Elektrolyt/Radial/ELKO_RADIAL_2RM_5D.png', '%BASE%/models/Capacitors_ThroughHole/C_Radial_D5_L11_P2.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(43, '09HCP', '%BASE%/img/footprints/Passiv/Induktivitaeten/Bedrahtet/SPULE_5MM-S.png', '%BASE%/models/Inductors/INDUCTOR_V.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(44, 'BUCHSE_RJ45-SHLD', '%BASE%/img/footprints/Elektromechanik/Verbinder/RJxx/BUCHSE_RJ45-SHLD.png', '%BASE%/models/own/rj45-shield.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(45, 'LED-TRANSPARENT_5MM', '%BASE%/img/footprints/Optik/LEDs/Bedrahtet/LED-TRANSPARENT_5MM.png', '%BASE%/models/LEDs/LED-5MM.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(46, 'SUB-D_F_FB-09', '', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(47, 'STIFTLEISTE-GERADE-RAHMEN_2X03', '%BASE%/img/footprints/Elektromechanik/Verbinder/Stiftleisten/2-Reihig_mit_Rahmen_gerade/STIFTLEISTE-GERADE-RAHMEN_2X03.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(48, 'TO220-7', '%BASE%/img/footprints/Aktiv/ICs/TO/IC_TO220-7.png', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(49, 'KIPPSCHALTER_1P-Gewinde-K', '%BASE%/img/footprints/Elektromechanik/Schalter_Taster/Kippschalter/1_Wechsler_stehend/KIPPSCHALTER_1P-Gewinde-K.png', '%BASE%/models/own/switch_100sp5.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(50, 'LED_PLCC2', '%BASE%/img/footprints/Optik/LEDs/SMD/LED_PLCC2.png', '%BASE%/models/LEDs/LED_WS2812-PLCC6.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(51, 'VERBINDER-USB_B-1', '%BASE%/img/footprints/Elektromechanik/Verbinder/USB/VERBINDER-USB_B-1.png', '%BASE%/models/unused_3d/Connectors.usb.normal.usb_b.usb_b_through_hole.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(52, 'BUCHSENLEISTE-GERADE_1X20', '%BASE%/img/footprints/Elektromechanik/Verbinder/Buchsenleisten/1-Reihig_gerade/BUCHSENLEISTE-GERADE_1X20.png', '%BASE%/models/own/pin_socket_20.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(53, 'PFL_6', '', '', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00'),
(54, 'DC20/20SRWA', '%BASE%/img/footprints/Optik/DX20-20.png', '%BASE%/models/LEDs/ledbar.x3d', NULL, NULL, '2017-11-10 17:14:03', '0000-00-00 00:00:00');

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

--
-- Tabellenstruktur für Tabelle `groups`
--

CREATE TABLE `groups` (
  `id` int(11) NOT NULL,
  `name` varchar(32) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `comment` mediumtext,
  `perms_system` int(11) NOT NULL,
  `perms_groups` int(11) NOT NULL,
  `perms_users` int(11) NOT NULL,
  `perms_self` int(11) NOT NULL,
  `perms_system_config` int(11) NOT NULL,
  `perms_system_database` int(11) NOT NULL,
  `perms_parts` int(11) NOT NULL,
  `perms_parts_name` smallint(6) NOT NULL,
  `perms_parts_description` smallint(6) NOT NULL,
  `perms_parts_instock` smallint(6) NOT NULL,
  `perms_parts_mininstock` smallint(6) NOT NULL,
  `perms_parts_footprint` smallint(6) NOT NULL,
  `perms_parts_storelocation` smallint(6) NOT NULL,
  `perms_parts_manufacturer` smallint(6) NOT NULL,
  `perms_parts_comment` smallint(6) NOT NULL,
  `perms_parts_order` smallint(6) NOT NULL,
  `perms_parts_orderdetails` smallint(6) NOT NULL,
  `perms_parts_prices` smallint(6) NOT NULL,
  `perms_parts_attachements` smallint(6) NOT NULL,
  `perms_devices` int(11) NOT NULL,
  `perms_devices_parts` int(11) NOT NULL,
  `perms_storelocations` int(11) NOT NULL,
  `perms_footprints` int(11) NOT NULL,
  `perms_categories` int(11) NOT NULL,
  `perms_suppliers` int(11) NOT NULL,
  `perms_manufacturers` int(11) NOT NULL,
  `perms_attachement_types` int(11) NOT NULL,
  `perms_tools` int(11) NOT NULL,
  `datetime_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `groups`
--

INSERT INTO `groups` (`id`, `name`, `parent_id`, `comment`, `perms_system`, `perms_groups`, `perms_users`, `perms_self`, `perms_system_config`, `perms_system_database`, `perms_parts`, `perms_parts_name`, `perms_parts_description`, `perms_parts_instock`, `perms_parts_mininstock`, `perms_parts_footprint`, `perms_parts_storelocation`, `perms_parts_manufacturer`, `perms_parts_comment`, `perms_parts_order`, `perms_parts_orderdetails`, `perms_parts_prices`, `perms_parts_attachements`, `perms_devices`, `perms_devices_parts`, `perms_storelocations`, `perms_footprints`, `perms_categories`, `perms_suppliers`, `perms_manufacturers`, `perms_attachement_types`, `perms_tools`, `datetime_added`, `last_modified`) VALUES
(1, 'admins', NULL, 'Users of this group can do everything: Read, Write and Administrative actions.', 1, 1365, 21845, 21, 85, 21, 349525, 5, 5, 5, 5, 5, 5, 5, 5, 5, 325, 325, 325, 1365, 325, 1365, 1365, 1365, 1365, 1365, 341, 1365, '2017-11-10 17:14:02', '0000-00-00 00:00:00'),
(2, 'readonly', NULL, 'Users of this group can only read informations, use tools, and don\'t have access to administrative tools.', 2, 2730, 43690, 25, 170, 42, 349865, 9, 9, 9, 9, 9, 9, 9, 9, 9, 649, 649, 649, 1705, 649, 1705, 1705, 1705, 1705, 1705, 681, 1366, '2017-11-10 17:14:02', '0000-00-00 00:00:00'),
(3, 'users', NULL, 'Users of this group, can edit part informations, create new ones, etc. but are not allowed to use administrative tools. (But can read current configuration, and see Server status)', 2, 2730, 43690, 25, 105, 41, 349525, 5, 5, 5, 5, 5, 5, 5, 5, 5, 325, 325, 325, 1365, 325, 1365, 1365, 1365, 1365, 1365, 341, 1365, '2017-11-10 17:14:02', '0000-00-00 00:00:00');

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

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

CREATE TABLE `internal` (
  `keyName` char(30) CHARACTER SET ascii NOT NULL,
  `keyValue` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `internal` (`keyName`, `keyValue`) VALUES
('dbVersion', '22');

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

--
-- Tabellenstruktur für Tabelle `manufacturers`
--

CREATE TABLE `manufacturers` (
  `id` int(11) NOT NULL,
  `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,
  `comment` text COLLATE utf8_unicode_ci,
  `last_modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Tabellenstruktur für Tabelle `orderdetails`
--

CREATE TABLE `orderdetails` (
  `id` int(11) NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Daten für Tabelle `orderdetails`
--

INSERT INTO `orderdetails` (`id`, `part_id`, `id_supplier`, `supplierpartnr`, `obsolete`, `supplier_product_url`, `datetime_added`) VALUES
(1, 1, 1, 'NE 555 DIP', 0, '', '2013-09-14 19:32:30'),
(2, 2, 1, 'IRFP 450', 0, '', '2013-09-14 19:36:39'),
(3, 3, 1, 'µA 7805', 0, '', '2013-09-14 19:39:40'),
(4, 4, 1, 'IRF 740', 0, '', '2013-09-14 19:44:42'),
(5, 5, 1, 'MBR 10100', 0, '', '2013-09-14 19:46:51'),
(6, 7, 1, 'MOS 4046', 0, '', '2013-09-14 20:10:15'),
(7, 8, 1, '1N 4148', 0, '', '2013-09-14 20:13:20'),
(8, 9, 1, 'TL 494 DIL', 0, '', '2013-09-14 20:15:55'),
(9, 10, 1, 'IRFP 460', 0, '', '2013-09-14 20:18:49'),
(10, 11, 1, 'BC 547*', 0, '', '2013-09-14 20:21:44'),
(11, 12, 1, 'BC 557*', 0, '', '2013-09-14 20:24:03'),
(12, 13, 1, 'LM 335 TO92', 0, '', '2013-09-14 20:25:53'),
(13, 14, 1, 'BUZ 11', 0, '', '2013-09-14 20:27:47'),
(14, 17, 1, 'LM 317-220', 0, '', '2013-09-14 20:37:14'),
(15, 18, 1, 'µA 7812', 0, '', '2013-09-14 20:39:19'),
(16, 19, 1, 'MAX 232*', 0, '', '2013-09-14 20:42:14'),
(17, 20, 1, 'µA 7815', 0, '', '2013-09-14 20:43:52'),
(20, 37, 1, 'MAX 3232 CPE', 0, '', '2013-09-15 11:07:47'),
(21, 38, 1, 'ULN 2803A', 0, '', '2013-09-15 11:10:28'),
(22, 40, 1, 'µA 7824', 0, '', '2013-09-25 17:25:07'),
(23, 41, 1, 'µA 7818', 0, '', '2013-09-25 17:26:12'),
(24, 42, 1, 'LF 33 CV', 0, '', '2013-09-25 17:27:39'),
(25, 43, 1, 'ATMEGA 328P-PU', 0, '', '2013-09-25 17:34:04'),
(26, 44, 1, 'GS 28-S', 0, '', '2013-09-25 17:41:59'),
(27, 45, 1, 'TASTER 9302', 0, '', '2013-09-25 17:44:26'),
(28, 46, 1, 'WSL 10G', 0, '', '2013-09-25 17:48:07'),
(29, 47, 1, 'PFL 10', 0, '', '2013-09-25 17:57:47'),
(30, 48, 1, 'MPE 094-1-006', 0, '', '2013-09-25 18:00:51'),
(31, 49, 1, 'AKL 101-02', 0, '', '2013-09-25 18:06:25'),
(32, 50, 1, 'AKL 101-03', 0, '', '2013-09-25 18:07:40'),
(33, 51, 1, 'KERKO 18P', 0, '', '2013-09-25 18:10:58'),
(34, 52, 1, 'KERKO 100N', 0, '', '2013-09-25 18:14:40'),
(35, 53, 2, 'KERKO 22P', 0, '', '2013-09-25 18:15:57'),
(36, 54, 1, 'MKS-2 22N', 0, '', '2013-09-25 18:18:28'),
(37, 6, 1, 'B700C25A', 0, '', '2013-09-25 18:30:27'),
(38, 55, 1, '8,0000-HC49U-S', 0, '', '2013-09-25 18:37:50'),
(39, 56, 1, '16,0000-HC18', 0, '', '2013-09-25 18:42:15'),
(40, 57, 1, 'ATTINY 44-20PU', 0, '', '2014-03-20 13:14:05'),
(41, 58, 2, '420 203', 0, '', '2014-03-20 13:23:09'),
(42, 59, 2, '420 203', 0, '', '2014-03-20 13:24:47'),
(43, 61, 1, 'ATMEGA 32-16 DIP', 0, '', '2014-03-20 13:33:45'),
(44, 62, 1, 'RS60112-LIN10K', 0, '', '2014-03-20 13:41:39'),
(45, 63, 1, '1N 4936', 0, '', '2014-03-20 13:45:50'),
(46, 64, 3, '172-1590', 0, '', '2014-03-20 16:08:09'),
(47, 65, 2, '340 493', 0, '', '2014-03-20 16:17:04'),
(48, 66, 1, 'D-SUB ST 09FB', 0, '', '2014-03-20 16:25:52'),
(49, 67, 1, 'D-SUB BU 09EU', 0, '', '2014-03-20 16:29:33'),
(50, 68, 1, 'D-SUB BU 09', 0, '', '2014-03-20 16:32:42'),
(52, 70, 1, 'WSL 20G', 0, '', '2014-03-20 16:40:57'),
(53, 71, 1, 'PFL 20', 0, '', '2014-03-20 16:45:46'),
(54, 72, 2, '120820', 0, '', '2014-03-20 16:58:44'),
(55, 73, 1, 'USA-FLINK 0,5A', 0, '', '2014-03-20 17:06:06'),
(56, 15, 3, '661-3233', 0, '', '2014-03-21 08:47:00'),
(57, 16, 3, '661-3249', 0, '', '2014-03-21 08:48:18'),
(58, 32, 1, 'PT 10-L 1,0M', 0, '', '2014-03-21 08:50:38'),
(59, 34, 1, 'PT 10-L 10K', 0, '', '2014-03-21 08:51:25'),
(60, 33, 1, 'PT 10-L 25K', 0, '', '2014-03-21 08:52:01'),
(61, 60, 4, 'musikus-hifi', 0, '', '2014-03-21 09:56:38'),
(62, 39, 1, '1/4W 4,7M', 0, '', '2014-03-21 10:01:49'),
(63, 35, 1, '1/4W 820', 0, '', '2014-03-21 10:05:01'),
(64, 31, 1, '1/4W 680', 0, '', '2014-03-21 10:05:38'),
(65, 23, 1, '1/4W 470', 0, '', '2014-03-21 10:06:16'),
(66, 30, 1, '1/4W 330', 0, '', '2014-03-21 10:06:59'),
(67, 25, 1, '1/4W 220', 0, '', '2014-03-21 10:07:23'),
(68, 29, 1, '1/4W 150', 0, '', '2014-03-21 10:07:50'),
(69, 24, 1, '1/4W 47', 0, '', '2014-03-21 10:08:29'),
(70, 36, 1, '1/4W 4,7K', 0, '', '2014-03-21 10:09:14'),
(71, 28, 1, '1/4W 6,8K', 0, '', '2014-03-21 10:09:40'),
(72, 22, 1, '1/4W 2,2K', 0, '', '2014-03-21 10:10:00'),
(73, 27, 1, '1/4W 10K', 0, '', '2014-03-21 10:11:22'),
(74, 21, 1, '1/4W 1K', 0, '', '2014-03-21 10:11:44'),
(76, 75, 1, 'FKP-1-630 47N', 0, '', '2014-03-21 10:34:52'),
(77, 76, 1, 'FKP-1-630 22N', 0, '', '2014-03-21 10:36:47'),
(78, 77, 1, 'FKP-1-1600 10N', 0, '', '2014-03-21 10:38:15'),
(79, 78, 1, 'MKP-10-630 100N', 0, '', '2014-03-21 10:40:45'),
(80, 79, 1, 'MKP-10-630 2,2µ', 0, '', '2014-03-21 10:42:28'),
(81, 80, 1, 'FKP-1-1600 330P', 0, '', '2014-03-21 10:46:44'),
(82, 81, 1, 'RAD 10/35', 0, '', '2014-03-21 11:35:01'),
(83, 82, 1, 'RAD 100/63', 0, '', '2014-03-21 11:39:05'),
(84, 83, 1, 'RAD 100/63', 0, '', '2014-03-21 11:41:01'),
(85, 84, 1, 'RAD 330/63', 0, '', '2014-03-21 11:43:10'),
(86, 85, 3, '711-1532', 0, '', '2014-03-21 11:49:39'),
(87, 86, 3, '714-8578', 0, '', '2014-03-21 11:51:59'),
(88, 87, 1, 'SM 0,47/63RAD', 0, '', '2014-03-21 11:58:02'),
(89, 88, 1, 'SM 4,7/50RAD', 0, '', '2014-03-21 12:00:19'),
(90, 89, 1, 'SM 0,47/63RAD', 0, '', '2014-03-21 12:03:51'),
(91, 90, 1, 'RAD 470/63', 0, '', '2014-03-21 12:06:40'),
(92, 91, 1, 'MKP-10-630 680N', 0, '', '2014-03-21 12:14:11'),
(93, 92, 1, 'SM 1,0/63RAD', 0, '', '2014-03-21 12:17:04'),
(94, 93, 1, 'SM 2,2/50RAD', 0, '', '2014-03-21 12:19:10'),
(95, 94, 1, 'RAD 105 1.000/63', 0, '', '2014-03-21 12:36:02'),
(96, 95, 1, 'SM 22/10RAD', 0, '', '2014-03-21 12:44:28'),
(97, 96, 4, 'csmqshop', 0, '', '2014-03-21 12:54:30'),
(99, 97, 1, 'IRLIZ 44N', 0, '', '2014-04-08 11:52:16'),
(100, 98, 1, 'L-09HCP 10µ', 0, '', '2014-04-08 11:56:04'),
(101, 99, 1, 'MEBP 8-8G', 0, '', '2014-04-08 12:04:25'),
(102, 100, 1, 'ENC 28J60-I/SP', 0, '', '2014-04-08 12:08:26'),
(103, 101, 1, '25,0000-HC18', 0, '', '2014-04-08 12:10:22'),
(104, 102, 1, 'LED 5MM UV', 0, '', '2014-05-29 10:00:43'),
(105, 103, 1, 'ATTINY 13-20 DIP', 0, '', '2014-05-29 10:09:24'),
(106, 104, 1, 'D-SUB BU 09FB', 0, '', '2014-05-29 10:29:35'),
(107, 105, 4, 'kibuckelectronics', 0, '', '2014-05-29 10:33:51'),
(108, 106, 1, 'ATMEGA 644-20 PU', 0, '', '2014-05-29 10:37:00'),
(109, 107, 1, 'WSL 6G', 0, '', '2014-05-31 22:48:10'),
(110, 124, 1, '1/4W 820K', 0, '', '2014-08-29 14:56:32'),
(111, 125, 1, '1/4W 33K', 0, '', '2014-08-29 14:58:12'),
(112, 126, 1, '1/4W 220K', 0, '', '2014-08-29 15:00:29'),
(113, 127, 1, '1/4W 560', 0, '', '2014-08-29 15:05:33'),
(114, 128, 1, '1/4W 680K', 0, '', '2014-08-29 15:07:11'),
(115, 129, 1, '1/4W 68K', 0, '', '2014-08-29 15:09:47'),
(116, 130, 1, '1/4W 2,7K', 0, '', '2014-08-29 15:10:51'),
(117, 131, 1, '1/4W 470K', 0, '', '2014-08-29 15:14:19'),
(118, 132, 1, '1/4W 47K', 0, '', '2014-08-29 15:16:02'),
(119, 133, 1, '1/4W 130K', 0, '', '2014-08-29 15:18:15'),
(120, 134, 1, '1/4W 150K', 0, '', '2014-08-29 15:19:24'),
(121, 135, 1, '1/4W 100', 0, '', '2014-08-29 15:20:48'),
(122, 136, 1, '1/4W 100k', 0, '', '2014-08-29 15:22:33'),
(123, 137, 1, '1/4W 22', 0, '', '2014-08-29 15:23:46'),
(125, 140, 1, '1/4W 200K', 0, '', '2014-08-29 15:26:46'),
(126, 141, 1, '1/4W 18K', 0, '', '2014-08-29 15:27:51'),
(127, 142, 1, '1/4W 22K', 0, '', '2014-08-29 15:32:48'),
(128, 143, 1, '1/4W 180K', 0, '', '2014-08-29 15:36:19'),
(129, 144, 1, '1/4W 120K', 0, '', '2014-08-29 15:38:03'),
(130, 145, 1, '1/4W 3,3K', 0, '', '2014-08-29 15:39:33'),
(131, 146, 1, '1/4W 5,6K', 0, '', '2014-08-29 15:41:00'),
(132, 147, 1, '1/4W 330K', 0, '', '2014-08-29 15:42:11'),
(133, 148, 1, '1/4W 560K', 0, '', '2014-08-29 15:43:50'),
(134, 149, 1, '1/4W 15K', 0, '', '2014-08-29 15:45:04'),
(135, 150, 1, 'BC 549B', 0, '', '2014-08-29 16:27:20'),
(136, 151, 1, 'FKS-2 4,7N', 0, '', '2014-08-29 16:28:50'),
(137, 152, 1, 'ATMEGA 1284P-PU', 0, '', '2014-08-29 18:53:47'),
(138, 153, 3, '620-1990', 0, '', '2014-08-29 18:57:20'),
(139, 154, 3, '661-6759', 0, '', '2014-08-29 19:00:14'),
(140, 155, 1, 'LM 2678 T5,0', 0, '', '2014-08-29 19:08:11'),
(141, 156, 3, '533-5266', 0, '', '2014-08-29 19:14:16'),
(142, 157, 1, 'MS 500E', 0, '', '2014-08-29 19:17:42'),
(143, 158, 2, '420 068', 0, '', '2014-08-29 19:23:18'),
(144, 159, 1, 'DTL 2 SW', 0, '', '2014-08-29 19:26:05'),
(145, 161, 1, '74HC 595', 0, '', '2014-08-29 19:34:07'),
(146, 162, 1, 'USB BW', 0, '', '2014-08-29 19:36:03'),
(147, 163, 1, 'SM 0,22/63RAD', 0, '', '2014-08-29 19:38:25'),
(148, 164, 1, 'MPE 094-1-010', 0, '', '2014-08-29 19:44:49'),
(149, 165, 1, 'MPE 094-1-008', 0, '', '2014-08-29 19:46:22'),
(150, 166, 1, 'µA 7809', 0, '', '2014-08-29 19:47:56'),
(151, 167, 1, 'MPE 115-1-036', 0, '', '2014-08-29 19:51:41'),
(152, 168, 1, 'PFL 6', 0, '', '2014-08-29 19:53:55'),
(153, 170, 1, 'D-SUB ST 09', 0, '', '2014-08-29 20:17:51'),
(154, 171, 1, 'A 906013', 0, '', '2014-08-29 20:22:19'),
(155, 172, 1, 'ATMEGA 8-16 DIP', 0, '', '2014-08-29 20:25:20'),
(156, 173, 3, '805-0249', 0, '', '2014-08-29 20:34:45'),
(157, 175, 1, 'ZF 2,7', 0, '', '2014-08-29 20:43:35'),
(158, 176, 1, 'zf 4,7', 0, '', '2014-08-29 20:48:25'),
(159, 177, 1, 'SRBG 2000', 0, '', '2014-08-29 20:51:25'),
(160, 178, 1, 'LM 324 DIL', 0, '', '2014-08-29 20:56:33'),
(161, 179, 2, '120 441', 0, '', '2014-08-29 20:58:42');

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

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

CREATE TABLE `parts` (
  `id` int(11) NOT NULL,
  `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',
  `favorite` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `parts` (`id`, `id_category`, `name`, `description`, `instock`, `mininstock`, `comment`, `visible`, `id_footprint`, `id_storelocation`, `order_orderdetails_id`, `order_quantity`, `manual_order`, `id_manufacturer`, `id_master_picture_attachement`, `manufacturer_product_url`, `datetime_added`, `last_modified`, `favorite`) VALUES
(1, 2, 'NE555', '', 20, 0, '', 0, 1, 31, NULL, 1, 0, NULL, NULL, '', '2013-09-14 19:29:13', '2013-09-14 21:33:16', 0),
(2, 6, 'IRFP 450', 'Leistungs-MOSFET N-Ch TO-247AC 500V 14A', 3, 0, '', 0, 2, 32, NULL, 1, 0, NULL, NULL, '', '2013-09-14 19:36:29', '2013-09-14 23:17:53', 0),
(3, 8, '7805', 'Spannungsregler 1,5A positiv, TO-220', 17, 2, '', 0, 3, 33, 3, 10, 0, NULL, NULL, '', '2013-09-14 19:39:26', '2014-06-14 11:10:23', 0),
(4, 6, 'IRF 740', 'Leistungs-MOSFET N-Ch TO-220AB 400V 10 A', 1, 0, '', 0, 3, 34, 4, 10, 0, NULL, NULL, '', '2013-09-14 19:44:28', '2014-04-08 11:50:04', 0),
(5, 7, 'MBR 10100', 'Schottky Diode, TO-220AC, 100V, 10A', 10, 0, '', 0, 4, 35, NULL, 1, 0, NULL, NULL, '', '2013-09-14 19:46:42', '2013-09-14 23:19:13', 0),
(6, 2, 'KBPC2508', 'Gleichrichter 560V 25A ', 2, 0, '', 0, 21, 36, NULL, 1, 0, NULL, NULL, '', '2013-09-14 19:50:36', '2013-09-25 20:32:30', 0),
(7, 2, 'MOS 4046', 'PLL', 4, 0, '', 0, 5, 37, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:09:59', '2013-09-14 22:10:22', 0),
(8, 7, '1N4148', 'Planar Epitaxial Schaltdiode, DO35, 100V, 0,15A', 213, 0, '', 0, 6, 38, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:13:02', '2014-11-17 18:12:58', 0),
(9, 2, 'TL 494', 'PWM-IC, DIL-16', 5, 0, '', 0, 5, 39, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:15:45', '2013-09-14 22:16:00', 0),
(10, 6, 'IRFP 460', 'Leistungs-MOSFET N-Ch TO-247AC 500V 20A', 10, 0, '', 0, 2, 40, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:18:40', '2013-09-14 23:18:02', 0),
(11, 40, 'BC547', 'Transistor NPN TO-92 45V 0,1A 0,5W', 28, 5, '', 0, 7, 41, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:20:15', '2017-09-06 15:01:57', 0),
(12, 40, 'BC557', 'Transistor PNP TO-92 45V 0,1A 0,5W', 20, 5, '', 0, 7, 43, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:23:52', '2017-09-06 15:01:38', 0),
(13, 2, 'LM335', 'Temperatursensor, TO-92', 10, 0, '', 0, 7, 44, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:25:38', '2013-09-14 22:25:59', 0),
(14, 6, 'BUZ11', 'Transistor N-FET TO-220AB 50V 35A', 12, 0, '', 0, 3, 45, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:27:34', '2013-09-25 22:13:40', 0),
(15, 2, 'UCC37321P', 'SINGLE 9-A HIGH SPEED LOW SIDE MOSFET DRIVER WITH ENABLE', 5, 0, '', 0, 1, 46, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:31:17', '2014-03-21 08:47:17', 0),
(16, 2, 'UCC37322P', 'SINGLE 9-A HIGH SPEED LOW SIDE MOSFET DRIVER WITH ENABLE', 5, 0, '', 0, 1, 47, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:33:17', '2014-03-21 08:48:37', 0),
(17, 8, 'LM317', 'Spannungsregler, TO-220', 16, 0, '', 0, 3, 50, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:37:04', '2014-03-20 13:07:17', 0),
(18, 8, '7812', 'Spannungsregler 1,5A positiv, TO-220', 3, 0, '', 0, 3, 51, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:38:46', '2014-03-20 16:54:31', 0),
(19, 2, 'MAX232', 'RS232-Driver, DIL-16', 1, 0, '', 0, 5, 52, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:42:01', '2013-09-14 22:42:23', 0),
(20, 8, '7815', 'Spannungsregler 1,5A positiv, TO-220', 10, 0, '', 0, 3, 57, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:43:37', '2013-09-14 23:20:19', 0),
(21, 9, '1K Ohm', '', 135, 10, '', 0, 37, 1, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:46:19', '2017-11-11 12:56:51', 0),
(22, 9, '2,2K Ohm', '', 135, 0, '', 0, 37, 2, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:51:25', '2017-11-11 13:02:09', 0),
(23, 9, '470 Ohm', '', 149, 0, '', 0, 37, 3, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:53:37', '2017-11-11 13:06:29', 0),
(24, 9, '47 Ohm', '', 75, 0, '', 0, 37, 4, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:55:14', '2017-11-11 13:12:17', 0),
(25, 9, '220 Ohm', '', 188, 0, '', 0, 37, 5, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:55:34', '2017-11-11 13:24:16', 0),
(27, 9, '10K Ohm', '', 83, 0, '', 0, 37, 8, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:57:52', '2017-11-11 14:29:59', 0),
(28, 9, '6,8K Ohm', '', 71, 0, '', 0, 37, 9, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:58:17', '2017-11-11 14:32:31', 0),
(29, 9, '150 Ohm', '', 131, 0, '', 0, 37, 10, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:58:42', '2017-11-11 14:41:26', 0),
(30, 9, '330 Ohm', '', 74, 0, '', 0, 37, 11, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:59:25', '2017-11-11 14:44:00', 0),
(31, 9, '680 Ohm', '', 77, 0, '', 0, 37, 12, NULL, 1, 0, NULL, NULL, '', '2013-09-14 20:59:42', '2017-11-11 15:00:27', 0),
(32, 10, 'POTI 1M Ohm', '', 8, 0, '', 0, 38, 13, NULL, 1, 0, NULL, NULL, '', '2013-09-14 21:01:52', '2017-11-11 15:01:49', 0),
(33, 10, 'POTI 25K Ohm', '', 9, 0, '', 0, 38, 14, NULL, 1, 0, NULL, NULL, '', '2013-09-14 21:02:15', '2017-11-11 15:02:08', 0),
(34, 10, 'POTI 10K Ohm', 'Stehend', 1, 0, '', 0, 38, 15, NULL, 1, 0, NULL, NULL, '', '2013-09-14 21:03:19', '2017-11-11 15:04:22', 0),
(35, 9, '820 Ohm', '', 96, 0, '', 0, 37, 16, NULL, 1, 0, NULL, NULL, '', '2013-09-14 21:03:41', '2017-11-11 15:09:01', 0),
(36, 9, '4,7K Ohm', '', 182, 0, '', 0, 37, 17, NULL, 1, 0, NULL, NULL, '', '2013-09-14 21:06:04', '2017-11-11 15:22:24', 0),
(37, 2, 'MAX3232 CPE', 'RS232-Driver, DIL-16 3,3V', 4, 0, 'MIT MARKIERUNG MÖGL. DEFEKT', 0, 5, 54, NULL, 1, 0, NULL, NULL, '', '2013-09-15 11:07:31', '2013-09-20 19:03:58', 0),
(38, 2, 'ULN2803A', 'Darlington-Arrays, DIL-18 = TD 62083AP', 10, 0, '', 0, 9, 42, NULL, 1, 0, NULL, NULL, '', '2013-09-15 11:10:20', '2013-09-15 13:10:40', 0),
(39, 9, '4,7M Ohm', '', 106, 0, '', 0, 37, 6, NULL, 1, 0, NULL, NULL, '', '2013-09-15 11:15:25', '2017-11-11 13:14:19', 0),
(40, 8, '7824', 'Spannungsregler 1,5A positiv, TO-220', 5, 0, '', 0, 3, 55, NULL, 1, 0, NULL, NULL, '', '2013-09-25 17:24:56', '2014-03-20 16:53:41', 0),
(41, 8, '7818', 'Spannungsregler 1,5A positiv, TO-220', 5, 0, '', 0, 3, 56, NULL, 1, 0, NULL, NULL, '', '2013-09-25 17:26:04', '2013-09-25 19:26:35', 0),
(42, 8, 'LF 33 CV', 'Festspannungsregler, +3,3V, TO-220', 5, 0, '', 0, 3, 53, NULL, 1, 0, NULL, NULL, '', '2013-09-25 17:27:19', '2013-09-25 19:27:48', 0),
(43, 15, 'ATMega 328P-PU', 'ATMega AVR-RISC-Controller, DIL-28', 12, 0, 'Allgemeines\\r\\nModellbezeichnung\\r\\nATmega328P-PU\\r\\nTyp\\r\\n8-Bit Mikrocontroller\\r\\nTechnologie\\r\\nAVR RISC Architektur\\r\\nGehäuse\\r\\nPDIP-28\\r\\nTemperaturbereich\\r\\n-40 … +85 °C\\r\\nAusführung\\r\\nAusführung\\r\\nWatchdog\\r\\nGeschwindigkeit\\r\\n20 MHz\\r\\nSpeicher\\r\\n32 kByte\\r\\nAnalog Komperator/en\\r\\n1\\r\\nEEPROM\\r\\n1024 Byte\\r\\nRAM\\r\\n2 kByte\\r\\nPWM\\r\\n6\\r\\n8-bit Timer\\r\\n2\\r\\n16-bit Timer\\r\\n1\\r\\nAnschlüsse / Schnittstellen\\r\\nADC\\r\\n6\\r\\nUART\\r\\n1\\r\\nI/O\\r\\n23\\r\\nSPI\\r\\n1\\r\\nElektrische Werte\\r\\nSpannungsbereich\\r\\n+1,8 … +5,5 V', 0, 10, 59, NULL, 1, 0, NULL, NULL, '', '2013-09-25 17:33:55', '2014-11-17 18:12:30', 0),
(44, 17, 'SOCKEL_DIP28', '', 10, 0, '', 0, 11, 79, NULL, 1, 0, NULL, NULL, '', '2013-09-25 17:41:21', '2013-09-25 19:42:10', 0),
(45, 18, 'Kurzhubtaster 6x6mm', 'Kurzhubtaster 6x6mm, Höhe: 5,0mm, 12V, vertikal', 20, 0, '', 0, 12, 81, NULL, 1, 0, NULL, NULL, '', '2013-09-25 17:44:17', '2013-09-25 19:45:25', 0),
(46, 27, 'Wannenstecker', '10-polig, gerade', 35, 0, '', 0, 13, 80, NULL, 1, 0, NULL, NULL, '', '2013-09-25 17:47:57', '2014-11-17 18:10:15', 0),
(47, 27, 'Pfostenbuchse', '10-polig, mit Zugentlastung', 28, 0, '', 0, 14, 85, NULL, 1, 0, NULL, NULL, '', '2013-09-25 17:57:32', '2014-08-29 15:55:41', 0),
(48, 17, 'Buchsenleiste 1x6', '2,54 mm, 1X06, gerade', 15, 0, '', 0, 15, 86, NULL, 1, 0, NULL, NULL, '', '2013-09-25 18:00:38', '2014-08-29 19:43:32', 0),
(49, 19, 'Anschlussklemme 2-polig', 'RM 5,08', 29, 0, '', 0, 17, 77, 31, 20, 0, NULL, NULL, '', '2013-09-25 18:06:14', '2014-08-29 16:02:47', 0),
(50, 19, 'Anschlussklemme 3-polig', 'RM 5,08', 25, 0, '', 0, 16, 76, NULL, 1, 0, NULL, NULL, '', '2013-09-25 18:07:30', '2014-08-29 16:03:03', 0),
(51, 20, '18 pF', 'Keramik-Kondensator 18P', 40, 0, '', 0, 20, 109, NULL, 1, 0, NULL, NULL, '', '2013-09-25 18:10:50', '2014-03-21 12:30:50', 0),
(52, 20, '100 nF', 'Keramik-Kondensator 100N', 103, 0, '', 0, 19, 110, NULL, 1, 0, NULL, NULL, '', '2013-09-25 18:14:19', '2014-08-30 21:46:37', 0),
(53, 20, '22 pF', 'Keramik-Kondensator 22P', 48, 0, '', 0, 20, 111, NULL, 1, 0, NULL, NULL, '', '2013-09-25 18:15:36', '2014-03-21 12:33:40', 0),
(54, 22, 'MKS-2 22N', 'WIMA Folienkondensator, Rm 5mm, 22nF', 2, 0, '', 0, 18, 112, NULL, 1, 0, NULL, NULL, '', '2013-09-25 18:18:19', '2013-09-25 20:22:02', 0),
(55, 24, '8,0000-HC49U-S', 'Standardquarz, Grundton, 8,0 MHz', 1, 0, '', 0, 22, 119, NULL, 1, 0, NULL, NULL, '', '2013-09-25 18:37:45', '2013-09-25 20:38:05', 0),
(56, 24, '16,0000-HC18', 'Standardquarz, Grundton, 16,0 MHz', 39, 0, '', 0, 23, 120, NULL, 1, 0, NULL, NULL, '', '2013-09-25 18:42:11', '2014-11-17 18:11:32', 0),
(57, 15, 'ATtiny44-20PU', 'Atmel AVR-RISC-Controller, DIL-14', 3, 0, '', 0, 24, 49, NULL, 1, 0, NULL, NULL, '', '2014-03-20 13:13:47', '2014-03-20 13:14:34', 0),
(58, 18, 'Einbau-Drucktaster PBS-11B', 'Taster - Schließer - 1 A/250 V~ - Einbau-ø 12 mm - rot', 15, 0, '', 0, 28, 87, NULL, 1, 0, NULL, NULL, '', '2014-03-20 13:22:58', '2014-03-20 20:38:46', 0),
(59, 18, 'Einbau-Drucktaster PBS-11B', 'Taster - Schließer - 1 A/250 V~ - Einbau-ø 12 mm - rot', 15, 0, '', 0, 28, 88, NULL, 1, 0, NULL, NULL, '', '2014-03-20 13:24:44', '2014-03-20 20:38:59', 0),
(60, 10, 'Einbau Poti 1x 20K', 'Mit Mittelstellung Linear', 8, 0, '', 0, 40, 18, NULL, 1, 0, NULL, NULL, '', '2014-03-20 13:29:44', '2017-11-11 15:24:04', 0),
(61, 15, 'ATMEGA 32-16 DIP', 'ATMega AVR-RISC-Controller, DIL-40', 2, 0, '', 0, 25, 30, NULL, 1, 0, NULL, NULL, '', '2014-03-20 13:33:32', '2017-11-11 15:35:51', 0),
(62, 10, 'Schieberpotil Linear', 'ALPS Mini-Schiebe-Poti., linear, stereo, 10K', 3, 0, '', 0, 39, 19, NULL, 1, 0, NULL, NULL, '', '2014-03-20 13:41:23', '2017-11-11 15:24:31', 0),
(63, 7, '1N4936', 'Fast-Recovery-Gleichrichterdiode, DO41,400V,1A', 40, 0, '', 0, 26, 29, NULL, 1, 0, NULL, NULL, '', '2014-03-20 13:45:38', '2017-11-11 15:36:19', 0),
(64, 26, 'MSR-Relais 6VDC', 'V23061B1003A401', 4, 0, '', 0, 34, 28, NULL, 1, 0, NULL, NULL, '', '2014-03-20 16:07:53', '2017-11-11 15:36:31', 0),
(65, 26, 'Relais Finder F40527-05', '5 V-/50 Ω, Schaltleistung 250 V~/8 A, 2 Wechsler', 9, 0, '', 0, 35, 27, NULL, 1, 0, NULL, NULL, '', '2014-03-20 16:16:53', '2017-11-11 15:36:37', 0),
(66, 13, 'SUB-D 9Pol Male Flachband', 'D-SUB-Stecker, 9-polig f. Flachbandkabel', 11, 0, '', 0, 30, 61, NULL, 1, 0, NULL, NULL, '', '2014-03-20 16:25:39', '2014-05-29 10:11:40', 0),
(67, 13, 'SUB-D Buchse, 9-polig, gewinkelt, RM 9,4', 'D-SUB-Buchse, 9-polig, gewinkelt, RM 9,4', 8, 0, '', 0, 32, 24, NULL, 1, 0, NULL, NULL, '', '2014-03-20 16:29:21', '2017-11-11 15:26:27', 0),
(68, 13, 'SUB-D Buchse, 9-pol', 'D-SUB-Buchse, 9-polig, Lötkelch', 5, 0, '', 0, 31, 23, NULL, 1, 0, NULL, NULL, '', '2014-03-20 16:32:24', '2017-11-11 15:26:17', 0),
(70, 27, 'Wannenstecker, 20-polig, gerade', 'Wannenstecker, 20-polig, gerade', 2, 0, '', 0, 33, 20, NULL, 1, 0, NULL, NULL, '', '2014-03-20 16:40:46', '2017-11-11 15:24:54', 0),
(71, 27, 'Pfostenbuchse', 'Pfostenbuchse, 20-polig, mit Zugentlastung', 13, 0, '', 0, 29, 62, NULL, 1, 0, NULL, NULL, '', '2014-03-20 16:45:36', '2014-03-20 20:56:12', 0),
(72, 28, 'SFH617A-3', 'Fototransistor-Ausgang, DIP-4', 17, 0, '', 0, 27, 21, NULL, 1, 0, NULL, NULL, '', '2014-03-20 16:58:34', '2017-11-11 15:25:13', 0),
(73, 30, '500mA Flink', '6,3 x 32 mm ', 9, 0, 'Uni-T Messgerät', 0, 36, 89, NULL, 1, 0, NULL, NULL, '', '2014-03-20 17:05:21', '2014-03-20 21:21:32', 0),
(75, 22, 'FKP-1-630 47N', 'Folienkondensator Wima FKP-1 47N', 5, 0, '', 0, 18, 91, NULL, 1, 0, NULL, NULL, '', '2014-03-21 10:34:36', '2014-03-21 10:35:02', 0),
(76, 22, 'FKP-1-630 22N', 'Folienkondensator Wima FKP-1 22N', 9, 0, '', 0, 18, 92, NULL, 1, 0, NULL, NULL, '', '2014-03-21 10:36:26', '2014-03-21 10:37:03', 0),
(77, 22, '10N', '', 24, 0, '', 0, 18, 93, NULL, 1, 0, NULL, NULL, '', '2014-03-21 10:38:09', '2014-08-29 16:23:39', 0),
(78, 22, '100N', '', 155, 0, '', 0, 18, 94, NULL, 1, 0, NULL, NULL, '', '2014-03-21 10:40:40', '2014-08-29 16:22:44', 0),
(79, 22, 'MKP-10-630 2,2µ', 'Folienkondensator WIMA MKP 10 2,2 µF', 3, 0, '', 0, 18, 95, NULL, 1, 0, NULL, NULL, '', '2014-03-21 10:42:23', '2014-03-21 10:43:04', 0),
(80, 22, 'FKP-1-1600 330P', 'Folienkondensator Wima FKP-1 330P', 8, 0, '', 0, 18, 96, NULL, 1, 0, NULL, NULL, '', '2014-03-21 10:46:38', '2014-03-21 12:47:52', 0),
(81, 21, '10µF', 'Elektrolytkondensator 10 µF', 59, 0, '', 0, 42, 98, NULL, 1, 0, NULL, NULL, '', '2014-03-21 11:34:49', '2014-08-29 15:52:37', 0),
(82, 21, '100µF', 'Elektrolytkondensator 100 µF', 24, 0, '', 0, 42, 99, NULL, 1, 0, NULL, NULL, '', '2014-03-21 11:37:46', '2014-03-21 11:53:43', 0),
(83, 21, '220µF', 'Elektrolytkondensator 220 µF', 10, 0, '', 0, 42, 100, NULL, 1, 0, NULL, NULL, '', '2014-03-21 11:40:55', '2014-03-21 11:53:59', 0),
(84, 21, '330µF', 'Elektrolytkondensator 330 µF', 10, 0, '', 0, 42, 101, NULL, 1, 0, NULL, NULL, '', '2014-03-21 11:42:42', '2014-03-21 11:54:07', 0),
(85, 21, '10000µF', '', 1, 0, '', 0, 42, 102, NULL, 1, 0, NULL, NULL, '', '2014-03-21 11:49:18', '2014-03-21 11:53:36', 0),
(86, 21, '390µF', '', 1, 0, '', 0, 42, 102, NULL, 1, 0, NULL, NULL, '', '2014-03-21 11:51:42', '2014-03-21 11:54:15', 0),
(87, 21, '0,47µF', 'Elektrolytkondensator 0,47 µF', 67, 0, '', 0, 42, 103, NULL, 1, 0, NULL, NULL, '', '2014-03-21 11:56:48', '2014-08-29 16:01:50', 0),
(88, 21, '4,7µF', 'Elektrolytkondensator 4,7 µF', 44, 0, '', 0, 42, 104, NULL, 1, 0, NULL, NULL, '', '2014-03-21 12:00:15', '2014-08-29 19:27:22', 0),
(89, 21, '47µF', 'Elektrolytkondensator 47 µF', 15, 0, '', 0, 42, 105, NULL, 1, 0, NULL, NULL, '', '2014-03-21 12:01:50', '2014-03-21 12:04:13', 0),
(90, 21, '470µF', 'Elektrolytkondensator 470 µF', 14, 0, '', 0, 42, 106, NULL, 1, 0, NULL, NULL, '', '2014-03-21 12:06:13', '2014-03-21 12:06:52', 0),
(91, 22, 'MKP-10-630 680nF', 'Folienkondensator WIMA MKP 10 680 nF', 4, 0, '', 0, 18, 107, NULL, 1, 0, NULL, NULL, '', '2014-03-21 12:14:00', '2014-03-21 12:14:23', 0),
(92, 21, '1µF', 'Elektrolytkondensator 1 µF', 20, 10, '', 0, 42, 97, 93, 10, 0, NULL, NULL, '', '2014-03-21 12:16:20', '2014-08-29 15:56:22', 0),
(93, 21, '2,2µF', 'Elektrolytkondensator 2,2 µF', 33, 0, '', 0, 42, 108, NULL, 1, 0, NULL, NULL, '', '2014-03-21 12:18:47', '2014-08-29 16:00:49', 0),
(94, 21, '1000µF', 'Elektrolytkondensator 1000 µF', 21, 0, '', 0, 42, 114, NULL, 1, 0, NULL, NULL, '', '2014-03-21 12:34:46', '2014-08-29 15:58:01', 0),
(95, 21, '22µF', 'Elektrolytkondensator 22 µF', 10, 0, '', 0, 42, 113, NULL, 1, 0, NULL, NULL, '', '2014-03-21 12:44:15', '2014-03-21 12:44:37', 0),
(96, 12, '9V Clip Arduino', 'Arduino 9V Clip mit Stecker', 2, 0, '', 0, NULL, 115, NULL, 1, 0, NULL, NULL, '', '2014-03-21 12:54:26', '2014-03-21 12:54:45', 0),
(97, 6, 'IRLIZ 44N', 'Leistungs-MOSFET N-LogL TO-220-FU 55V 30A', 20, 0, '', 0, 3, 84, NULL, 1, 0, NULL, NULL, '', '2014-04-08 11:51:57', '2014-05-25 09:18:48', 0),
(98, 31, '10µH', 'Stehende-Induktivität, 09HCP, Ferrit, 10 µH', 10, 0, '• Toleranz: ± 20 %\\r\\n• Ø 12,5 x 10,8 mm\\r\\n• Raster: 7 mm\\r\\n• DCR max : 0,014 Ohm\\r\\n• Isat : 6,7 A', 0, 43, 90, NULL, 1, 0, NULL, NULL, '', '2014-04-08 11:55:49', '2014-04-08 11:56:18', 0),
(99, 13, 'RJ45 Buschse ohne Übertrager', 'Modular-Einbaubuchse 8/8, geschirmt', 10, 0, 'con-tycoelectronics -> RJ45-NO-SHIELD', 0, 44, 117, NULL, 1, 0, NULL, NULL, '', '2014-04-08 12:04:18', '2014-11-16 19:19:03', 0),
(100, 37, 'ENC 28J60-I/SP', 'Ethernet Controller, Stand-Alone, S-DIL-28', 5, 0, '', 0, 10, 82, NULL, 1, 0, NULL, NULL, '', '2014-04-08 12:08:15', '2017-09-06 14:59:26', 0),
(101, 24, '25MHz', 'Standardquarz, Oberton, 25,0 MHz', 5, 0, '', 0, 23, 118, NULL, 1, 0, NULL, NULL, '', '2014-04-08 12:10:09', '2014-04-08 12:10:30', 0),
(102, 33, 'LED 5mm, Ultraviolet, farblos, klar', '5mm LED UV', 10, 0, 'L-7113UVC - Kingbright', 0, 45, 131, NULL, 1, 0, NULL, NULL, '', '2014-05-29 10:00:28', '2014-05-29 10:04:41', 0),
(103, 15, 'ATtiny 13-20', 'Atmel AVR-RISC-Controller', 10, 0, '', 0, 1, 132, NULL, 1, 0, NULL, NULL, '', '2014-05-29 10:09:02', '2014-05-29 10:09:36', 0),
(104, 13, 'SUB-D 9Pol Female Flachband', 'D-SUB-Buchse, 9-polig f. Flachbandkabel', 10, 0, '', 0, 46, 133, NULL, 1, 0, NULL, NULL, '', '2014-05-29 10:28:59', '2014-05-29 10:29:47', 0),
(105, 13, 'HanRun HR911105A', 'MagJack RJ45 mit Wandler', 9, 0, '', 0, NULL, 134, NULL, 1, 0, NULL, NULL, '', '2014-05-29 10:32:43', '2014-05-29 10:34:22', 0),
(106, 15, 'ATmega 644 20PU', 'ATMega AVR-RISC-Controller, DIL-40', 1, 0, '', 0, 25, 135, NULL, 1, 0, NULL, NULL, '', '2014-05-29 10:36:24', '2014-05-29 10:37:12', 0),
(107, 27, 'Wannen Stecker 6POL', '', 16, 0, '', 0, 47, 136, NULL, 1, 0, NULL, NULL, '', '2014-05-31 22:47:53', '2014-11-17 18:08:47', 0),
(108, 34, '560 Ohm', '', 50, 0, '', 0, NULL, 161, NULL, 1, 0, NULL, NULL, '', '2014-07-12 09:37:54', '2014-07-12 09:37:54', 0),
(109, 34, '510 Ohm', '', 50, 0, '', 0, NULL, 162, NULL, 1, 0, NULL, NULL, '', '2014-07-12 09:40:22', '2014-07-12 09:40:22', 0),
(110, 34, '470 Ohm', '', 50, 0, '', 0, NULL, 163, NULL, 1, 0, NULL, NULL, '', '2014-07-12 09:40:50', '2014-07-12 09:40:51', 0),
(111, 34, '180 Ohm', '', 50, 0, '', 0, NULL, 164, NULL, 1, 0, NULL, NULL, '', '2014-07-12 09:41:40', '2014-07-12 09:41:40', 0),
(112, 34, '220 Ohm', '', 50, 0, '', 0, NULL, 165, NULL, 1, 0, NULL, NULL, '', '2014-07-12 09:42:18', '2014-07-12 09:42:18', 0),
(113, 34, '150 Ohm', '', 50, 0, '', 0, NULL, 166, NULL, 1, 0, NULL, NULL, '', '2014-07-12 09:42:55', '2014-07-12 09:44:09', 0),
(114, 34, '100 Ohm', '', 50, 0, '', 0, NULL, 167, NULL, 1, 0, NULL, NULL, '', '2014-07-12 09:43:51', '2014-07-12 09:44:20', 0),
(115, 34, '620 Ohm', '', 50, 0, '', 0, NULL, 168, NULL, 1, 0, NULL, NULL, '', '2014-07-12 09:45:01', '2014-07-12 09:45:01', 0),
(116, 34, '430 Ohm', '', 50, 0, '', 0, NULL, 169, NULL, 1, 0, NULL, NULL, '', '2014-07-12 09:45:36', '2014-07-12 09:45:36', 0),
(117, 34, '390 Ohm', '', 50, 0, '', 0, NULL, 170, NULL, 1, 0, NULL, NULL, '', '2014-07-12 09:46:32', '2014-07-12 09:46:32', 0),
(118, 34, '330 Ohm', '', 50, 0, '', 0, NULL, 171, NULL, 1, 0, NULL, NULL, '', '2014-07-12 09:46:53', '2014-07-12 09:46:53', 0),
(119, 34, '270 Ohm', '', 50, 0, '', 0, NULL, 172, NULL, 1, 0, NULL, NULL, '', '2014-07-12 09:48:14', '2014-07-12 09:48:14', 0),
(120, 34, '1K Ohm', '', 50, 0, '', 0, NULL, 173, NULL, 1, 0, NULL, NULL, '', '2014-07-12 09:49:09', '2014-07-12 09:49:09', 0),
(121, 34, '910 ohm', '', 50, 0, '', 0, NULL, 174, NULL, 1, 0, NULL, NULL, '', '2014-07-12 09:49:48', '2014-07-12 09:49:48', 0),
(122, 34, '820 Ohm', '', 50, 0, '', 0, NULL, 175, NULL, 1, 0, NULL, NULL, '', '2014-07-12 09:50:21', '2014-07-12 09:50:21', 0),
(123, 34, '750 Ohm', '', 50, 0, '', 0, NULL, 176, NULL, 1, 0, NULL, NULL, '', '2014-07-12 10:20:57', '2014-07-12 10:20:57', 0),
(124, 9, '820K Ohm', '', 100, 0, '', 0, 37, 191, NULL, 1, 0, NULL, NULL, '', '2014-08-29 14:55:56', '2014-08-29 15:04:23', 0),
(125, 9, '33K Ohm', '', 100, 0, '', 0, 37, 192, NULL, 1, 0, NULL, NULL, '', '2014-08-29 14:57:45', '2014-08-29 15:04:02', 0),
(126, 9, '220K Ohm', '', 100, 0, '', 0, 37, 193, NULL, 1, 0, NULL, NULL, '', '2014-08-29 14:59:57', '2014-08-29 15:03:44', 0),
(127, 9, '560 Ohm', '', 100, 0, '', 0, 37, 194, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:05:05', '2014-08-29 15:05:55', 0),
(128, 9, '680K Ohm', '', 100, 0, '', 0, 37, 195, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:07:02', '2014-08-29 15:08:06', 0),
(129, 9, '68K Ohm', '', 100, 0, '', 0, 37, 196, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:08:49', '2014-08-29 15:09:51', 0),
(130, 9, '2,7K Ohm', '', 100, 0, '', 0, 37, 197, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:10:32', '2014-08-29 15:11:29', 0),
(131, 9, '470K Ohm', '', 100, 0, '', 0, 37, 198, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:14:02', '2014-08-29 15:15:01', 0),
(132, 9, '47K Ohm', '', 100, 0, '', 0, 37, 199, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:15:43', '2014-08-29 15:16:09', 0),
(133, 9, '130K Ohm', '', 100, 0, '', 0, 37, 200, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:18:02', '2014-08-29 15:18:20', 0),
(134, 9, '150K Ohm', '', 100, 0, '', 0, 37, 201, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:19:11', '2014-08-29 15:19:29', 0),
(135, 9, '100 Ohm', '', 100, 0, '', 0, 37, 202, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:20:24', '2014-08-29 15:20:54', 0),
(136, 9, '100K Ohm', '', 100, 0, '', 0, 37, 203, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:22:24', '2014-08-29 15:22:37', 0),
(137, 9, '22 Ohm', '', 100, 0, '', 0, 37, 204, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:23:37', '2014-08-29 15:23:50', 0),
(138, 9, '68 Ohm', '', 100, 0, '', 0, 37, 205, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:25:12', '2014-08-29 15:25:12', 0),
(140, 9, '200K Ohm', '', 100, 0, '', 0, 37, 206, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:26:23', '2014-08-29 15:26:50', 0),
(141, 9, '18K Ohm', '', 100, 0, '', 0, 37, 207, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:27:41', '2014-08-29 15:28:17', 0),
(142, 9, '22K Ohm', '', 100, 0, '', 0, 37, 208, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:32:09', '2014-08-29 15:32:52', 0),
(143, 9, '180K Ohm', '', 100, 0, '', 0, 37, 209, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:36:08', '2014-08-29 15:36:22', 0),
(144, 9, '120K Ohm', '', 100, 0, '', 0, 37, 210, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:37:54', '2014-08-29 15:38:07', 0),
(145, 9, '3,3K Ohm', '', 100, 0, '', 0, 37, 211, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:39:22', '2014-08-29 15:39:39', 0),
(146, 9, '5,6K', '', 100, 0, '', 0, 37, 212, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:40:47', '2014-08-29 15:41:04', 0),
(147, 9, '330K Ohm', '', 100, 0, '', 0, 37, 213, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:42:00', '2014-08-29 15:42:16', 0),
(148, 9, '560K Ohm', '', 100, 0, '', 0, 37, 214, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:43:34', '2014-08-29 15:43:56', 0),
(149, 9, '15K Ohm', '', 100, 0, '', 0, 37, 215, NULL, 1, 0, NULL, NULL, '', '2014-08-29 15:44:52', '2014-08-29 15:45:07', 0),
(150, 40, 'BC549', '', 97, 0, '', 0, 7, 216, NULL, 1, 0, NULL, NULL, '', '2014-08-29 16:26:56', '2017-09-06 15:01:48', 0),
(151, 22, '4,7nF', '', 25, 0, '', 0, 18, 217, NULL, 1, 0, NULL, NULL, '', '2014-08-29 16:28:24', '2014-08-29 16:28:56', 0),
(152, 15, 'ATmega1284P-PU', '', 4, 0, '', 0, 25, 218, NULL, 1, 0, NULL, NULL, '', '2014-08-29 18:53:10', '2014-08-29 18:54:01', 0),
(153, 8, 'UCC283T-3', '3A 3.3Vout TO-220, 3-Pin, 3.85 to 9Vin, Low Dropout', 3, 0, '', 0, 3, 219, NULL, 1, 0, NULL, NULL, '', '2014-08-29 18:57:06', '2014-08-29 18:57:53', 0),
(154, 8, 'UCC283T-5', '3A 5Vout TO-220, 3-Pin, 5.45 to 9Vin', 3, 0, '', 0, 3, 220, NULL, 1, 0, NULL, NULL, '', '2014-08-29 19:00:02', '2014-08-29 19:00:34', 0),
(155, 44, 'LM2678T-5', 'Switching Regulator, LM2678T-5.0/NOPB, Buck Controller, 5A TO-220, 7-Pin, 260kHz, 5V', 3, 0, '', 0, 48, 137, NULL, 1, 0, NULL, NULL, '', '2014-08-29 19:07:56', '2017-09-06 15:01:01', 0),
(156, 44, 'LM2678T-12', 'Switching Regulator, LM2678T-12/NOPB, Buck Controller, 5A TO-220, 7-Pin, 260kHz, 12V', 3, 0, '', 0, 48, 138, NULL, 1, 0, NULL, NULL, '', '2014-08-29 19:12:50', '2017-09-06 15:00:52', 0),
(157, 18, 'Kippschalter, 1-polig, 6A-125VAC, (Ein)-Aus-(Ein)', 'Tastend', 5, 0, '', 0, 49, 139, NULL, 1, 0, NULL, NULL, '', '2014-08-29 19:17:28', '2014-08-29 19:17:48', 0),
(158, 18, 'Kippschalter 1Pol 10A', '', 2, 0, '', 0, NULL, 140, NULL, 1, 0, NULL, NULL, '', '2014-08-29 19:21:31', '2014-08-29 19:23:35', 0),
(159, 18, 'Eingabetaster SW, Schaltspannung: 24V,fürLED', '', 5, 0, '', 0, NULL, 141, NULL, 1, 0, NULL, NULL, '', '2014-08-29 19:25:59', '2014-08-29 19:26:12', 0),
(160, 33, 'WS2812B', 'Einzeln', 10, 0, '', 0, 50, 142, NULL, 1, 0, NULL, NULL, '', '2014-08-29 19:29:38', '2014-08-29 19:30:15', 0),
(161, 37, '74HC595', '8-Bit Schieberegister', 5, 0, '', 0, 5, 143, NULL, 1, 0, NULL, NULL, '', '2014-08-29 19:32:25', '2017-09-06 14:58:26', 0),
(162, 13, 'USB-Einbaubuchse, Serie B, gew., Printmontage', '', 10, 0, '', 0, 51, 144, NULL, 1, 0, NULL, NULL, '', '2014-08-29 19:35:41', '2014-08-29 19:36:50', 0),
(163, 21, '0,22µF', '', 25, 0, '', 0, 42, 145, NULL, 1, 0, NULL, NULL, '', '2014-08-29 19:37:49', '2014-08-29 19:38:33', 0),
(164, 17, 'Buchsenleiste 1x10', '2,54 mm, 1X10, gerade', 12, 0, '', 0, 15, 146, NULL, 1, 0, NULL, NULL, '', '2014-08-29 19:44:36', '2014-08-29 19:45:06', 0),
(165, 17, 'Buchsenleiste 1x8', '2,54 mm, 1X08, gerade', 10, 0, '', 0, 15, 147, NULL, 1, 0, NULL, NULL, '', '2014-08-29 19:46:05', '2014-08-29 19:46:38', 0),
(166, 8, '7809', 'Spannungsregler 1,5A positiv', 10, 0, '', 0, 3, 148, NULL, 1, 0, NULL, NULL, '', '2014-08-29 19:47:19', '2014-08-29 19:48:03', 0),
(167, 17, 'Präz.-Buchsenleisten', '2,54 mm, 1X36, gerade', 5, 0, '', 0, 52, 149, NULL, 1, 0, NULL, NULL, '', '2014-08-29 19:50:41', '2014-08-29 19:51:49', 0),
(168, 27, 'Pfostenbuchse', '6-polig, mit Zugentlastung', 10, 0, '', 0, 53, 150, NULL, 1, 0, NULL, NULL, '', '2014-08-29 19:53:46', '2014-08-29 19:54:00', 0),
(169, 2, 'Hall Sensor', 'Allegro A1302', 5, 0, '', 0, NULL, 151, NULL, 1, 0, NULL, NULL, '', '2014-08-29 20:15:49', '2014-11-30 14:04:57', 0),
(170, 13, 'SUB-D Stecker, 9-pol', 'D-SUB-Stecker, 9-polig, Lötkelch', 10, 0, '', 0, 31, 152, NULL, 1, 0, NULL, NULL, '', '2014-08-29 20:16:31', '2014-08-29 20:19:05', 0),
(171, 45, 'Fotowiderstand', '', 4, 0, '', 0, NULL, 153, NULL, 1, 0, NULL, NULL, '', '2014-08-29 20:21:24', '2017-09-06 15:07:32', 0),
(172, 15, 'ATmega8 16PU', '', 1, 0, '', 0, 10, 154, NULL, 1, 0, NULL, NULL, '', '2014-08-29 20:24:16', '2014-08-29 20:25:33', 0),
(173, 7, '1N5254', 'Z Diode 27V 0.1μA 500mW 5%, DO-35 2-Pin', 100, 0, '', 0, 6, 221, NULL, 1, 0, NULL, NULL, '', '2014-08-29 20:33:32', '2014-08-29 20:35:10', 0),
(174, 7, 'Z-Diode 4,3', '', 100, 0, '', 0, 6, 222, NULL, 1, 0, NULL, NULL, '', '2014-08-29 20:40:31', '2014-08-29 20:40:32', 0),
(175, 7, 'BZX55C', 'Z-Diode 2,7 Volt', 100, 0, '', 0, 6, 223, NULL, 1, 0, NULL, NULL, '', '2014-08-29 20:43:30', '2014-08-29 20:43:41', 0),
(176, 7, 'BZX79C4V7 R0', 'Zener-Diode 0,5W 4,7V', 25, 0, '', 0, 6, 226, NULL, 1, 0, NULL, NULL, '', '2014-08-29 20:48:13', '2014-08-29 20:48:33', 0),
(177, 33, 'DC-20/20SRWA', 'Bargraph-Anzeige, 20 Elemente, superrot', 5, 0, '', 0, 54, 227, NULL, 1, 0, NULL, NULL, '', '2014-08-29 20:50:47', '2017-09-06 15:00:05', 0),
(178, 36, 'LM324', 'Operationsverstärker, 4-fach, DIL-14', 9, 0, '', 0, 24, 228, NULL, 1, 0, NULL, NULL, '', '2014-08-29 20:56:21', '2017-09-06 14:57:48', 0),
(179, 33, 'Ultrahelle LED 10034Y1C-CSE-D', 'Bernstein', 8, 0, '2,2V 20mA\\r\\n9000mcd', 0, 45, 229, NULL, 1, 0, NULL, NULL, '', '2014-08-29 20:58:30', '2014-08-29 21:00:39', 0),
(180, 2, 'DC/DC Wandler', '5V in 2x12V out', 1, 0, '', 0, NULL, 230, NULL, 1, 0, NULL, NULL, '', '2014-08-29 21:03:55', '2014-08-29 21:03:55', 0);

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

--
-- Tabellenstruktur für Tabelle `pricedetails`
--

CREATE TABLE `pricedetails` (
  `id` int(11) NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Daten für Tabelle `pricedetails`
--

INSERT INTO `pricedetails` (`id`, `orderdetails_id`, `price`, `price_related_quantity`, `min_discount_quantity`, `manual_input`, `last_modified`) VALUES
(1, 1, '0.17000', 1, 1, 1, '2013-09-14 19:33:06'),
(2, 2, '1.65000', 1, 1, 1, '2013-09-14 19:36:48'),
(3, 3, '0.28000', 1, 1, 1, '2013-09-14 19:40:10'),
(4, 4, '0.63000', 1, 1, 1, '2013-09-14 19:44:50'),
(5, 5, '0.54000', 1, 1, 1, '2013-09-14 19:46:58'),
(6, 6, '0.34000', 1, 1, 1, '2013-09-14 20:10:22'),
(7, 7, '0.02000', 1, 1, 1, '2013-09-14 20:13:29'),
(8, 8, '0.29000', 1, 1, 1, '2013-09-14 20:16:00'),
(9, 9, '1.95000', 1, 1, 1, '2013-09-14 20:18:56'),
(10, 10, '0.04000', 1, 1, 1, '2013-09-14 20:21:52'),
(11, 11, '0.04000', 1, 1, 1, '2013-09-14 20:24:08'),
(12, 12, '0.74000', 1, 1, 1, '2013-09-14 20:25:59'),
(13, 13, '0.58000', 1, 1, 1, '2013-09-14 20:27:55'),
(14, 14, '0.25000', 1, 1, 1, '2013-09-14 20:37:24'),
(15, 15, '0.28000', 1, 1, 1, '2013-09-14 20:39:29'),
(16, 16, '0.38000', 1, 1, 1, '2013-09-14 20:42:23'),
(17, 17, '0.29000', 1, 1, 1, '2013-09-14 20:43:58'),
(23, 20, '1.60000', 1, 1, 1, '2013-09-15 11:07:53'),
(24, 21, '0.35000', 1, 1, 1, '2013-09-15 11:10:35'),
(25, 22, '0.29000', 1, 1, 1, '2013-09-25 17:25:21'),
(26, 23, '0.32000', 1, 1, 1, '2013-09-25 17:26:32'),
(27, 24, '0.73000', 1, 1, 1, '2013-09-25 17:27:45'),
(28, 25, '4.25000', 1, 1, 1, '2013-09-25 17:34:15'),
(29, 26, '0.09000', 1, 1, 1, '2013-09-25 17:42:06'),
(30, 27, '0.11000', 1, 1, 1, '2013-09-25 17:44:33'),
(31, 28, '0.08000', 1, 1, 1, '2013-09-25 17:48:13'),
(32, 29, '0.08000', 1, 1, 1, '2013-09-25 17:57:55'),
(33, 30, '0.25000', 1, 1, 1, '2013-09-25 18:00:57'),
(34, 31, '0.31000', 1, 1, 1, '2013-09-25 18:06:31'),
(35, 32, '0.31000', 1, 1, 1, '2013-09-25 18:07:45'),
(36, 33, '0.06000', 1, 1, 1, '2013-09-25 18:11:04'),
(37, 34, '0.06000', 1, 1, 1, '2013-09-25 18:14:49'),
(38, 35, '0.06000', 1, 1, 1, '2013-09-25 18:16:02'),
(39, 36, '0.11000', 1, 1, 1, '2013-09-25 18:18:36'),
(40, 37, '1.10000', 1, 1, 1, '2013-09-25 18:30:32'),
(41, 38, '0.17000', 1, 1, 1, '2013-09-25 18:37:56'),
(42, 39, '0.16000', 1, 1, 1, '2013-09-25 18:42:21'),
(43, 40, '2.65000', 1, 1, 1, '2014-03-20 13:14:20'),
(45, 41, '0.55000', 1, 1, 1, '2014-03-20 13:24:14'),
(46, 42, '0.55000', 1, 1, 1, '2014-03-20 13:24:56'),
(47, 43, '3.55000', 1, 1, 1, '2014-03-20 13:33:53'),
(48, 44, '2.75000', 1, 1, 1, '2014-03-20 13:41:47'),
(49, 45, '0.04000', 1, 1, 1, '2014-03-20 13:45:56'),
(50, 46, '4.62000', 1, 1, 1, '2014-03-20 16:08:24'),
(51, 47, '3.75000', 1, 1, 1, '2014-03-20 16:17:12'),
(52, 48, '0.47000', 1, 1, 1, '2014-03-20 16:25:59'),
(53, 49, '0.39000', 1, 1, 1, '2014-03-20 16:29:39'),
(54, 50, '0.17000', 1, 1, 1, '2014-03-20 16:32:50'),
(56, 52, '0.12000', 1, 1, 1, '2014-03-20 16:41:04'),
(57, 53, '0.14000', 1, 1, 1, '2014-03-20 16:45:52'),
(58, 54, '0.30000', 1, 1, 1, '2014-03-20 16:58:50'),
(59, 55, '0.73000', 1, 1, 1, '2014-03-20 17:06:18'),
(60, 56, '2.32000', 1, 1, 1, '2014-03-21 08:47:13'),
(61, 57, '2.35000', 1, 1, 1, '2014-03-21 08:48:29'),
(62, 58, '0.23000', 1, 1, 1, '2014-03-21 08:50:45'),
(63, 59, '0.23000', 1, 1, 1, '2014-03-21 08:51:31'),
(64, 60, '0.23000', 1, 1, 1, '2014-03-21 08:52:07'),
(65, 61, '2.89000', 1, 1, 1, '2014-03-21 09:56:55'),
(66, 62, '0.10000', 1, 1, 1, '2014-03-21 10:01:57'),
(67, 63, '0.10000', 1, 1, 1, '2014-03-21 10:05:09'),
(68, 64, '0.10000', 1, 1, 1, '2014-03-21 10:05:48'),
(69, 65, '0.10000', 1, 1, 1, '2014-03-21 10:06:23'),
(70, 66, '0.10000', 1, 1, 1, '2014-03-21 10:07:04'),
(71, 67, '0.10000', 1, 1, 1, '2014-03-21 10:07:28'),
(72, 68, '0.10000', 1, 1, 1, '2014-03-21 10:07:54'),
(73, 69, '0.10000', 1, 1, 1, '2014-03-21 10:08:33'),
(74, 70, '0.10000', 1, 1, 1, '2014-03-21 10:09:18'),
(75, 71, '0.10000', 1, 1, 1, '2014-03-21 10:09:44'),
(76, 72, '0.10000', 1, 1, 1, '2014-03-21 10:10:03'),
(77, 73, '0.10000', 1, 1, 1, '2014-03-21 10:11:24'),
(78, 74, '0.10000', 1, 1, 1, '2014-03-21 10:11:47'),
(80, 76, '0.57000', 1, 1, 1, '2014-03-21 10:35:00'),
(81, 77, '0.37000', 1, 1, 1, '2014-03-21 10:36:58'),
(82, 78, '0.54000', 1, 1, 1, '2014-03-21 10:38:33'),
(83, 79, '0.40000', 1, 1, 1, '2014-03-21 10:40:52'),
(84, 80, '2.85000', 1, 1, 1, '2014-03-21 10:42:35'),
(85, 81, '0.18000', 1, 1, 1, '2014-03-21 10:46:51'),
(86, 82, '0.04000', 1, 1, 1, '2014-03-21 11:35:07'),
(87, 83, '0.05000', 1, 1, 1, '2014-03-21 11:39:13'),
(88, 84, '0.05000', 1, 1, 1, '2014-03-21 11:41:06'),
(89, 85, '0.13000', 1, 1, 1, '2014-03-21 11:43:16'),
(90, 86, '4.94000', 1, 1, 1, '2014-03-21 11:49:50'),
(91, 87, '6.55000', 1, 1, 1, '2014-03-21 11:52:08'),
(92, 88, '0.05000', 1, 1, 1, '2014-03-21 11:58:08'),
(93, 89, '0.05000', 1, 1, 1, '2014-03-21 12:00:27'),
(94, 90, '0.05000', 1, 1, 1, '2014-03-21 12:04:00'),
(95, 91, '0.13000', 1, 1, 1, '2014-03-21 12:06:49'),
(96, 92, '1.15000', 1, 1, 1, '2014-03-21 12:14:20'),
(97, 93, '0.05000', 1, 1, 1, '2014-03-21 12:17:11'),
(98, 94, '0.05000', 1, 1, 1, '2014-03-21 12:19:18'),
(99, 95, '0.32000', 1, 1, 1, '2014-03-21 12:36:15'),
(100, 96, '0.05000', 1, 1, 1, '2014-03-21 12:44:34'),
(101, 97, '1.81000', 1, 1, 1, '2014-03-21 12:54:42'),
(102, 99, '0.79000', 1, 1, 1, '2014-04-08 11:52:28'),
(103, 100, '0.54000', 1, 1, 1, '2014-04-08 11:56:15'),
(104, 101, '0.55000', 1, 1, 1, '2014-04-08 12:04:49'),
(105, 102, '3.05000', 1, 1, 1, '2014-04-08 12:08:35'),
(106, 103, '0.20000', 1, 1, 1, '2014-04-08 12:10:28'),
(107, 104, '0.99000', 1, 1, 1, '2014-05-29 10:03:40'),
(108, 105, '1.20000', 1, 1, 1, '2014-05-29 10:09:33'),
(109, 106, '0.48000', 1, 1, 1, '2014-05-29 10:29:42'),
(110, 107, '1.95000', 1, 1, 1, '2014-05-29 10:34:04'),
(111, 108, '6.45000', 1, 1, 1, '2014-05-29 10:37:12'),
(112, 109, '0.16000', 1, 1, 1, '2014-05-31 22:48:37'),
(113, 110, '0.10000', 1, 1, 1, '2014-08-29 14:56:46'),
(114, 111, '0.10000', 1, 1, 1, '2014-08-29 14:58:21'),
(115, 112, '0.10000', 1, 1, 1, '2014-08-29 15:00:34'),
(116, 113, '0.10000', 1, 1, 1, '2014-08-29 15:05:41'),
(117, 114, '0.10000', 1, 1, 1, '2014-08-29 15:08:02'),
(118, 115, '0.10000', 1, 1, 1, '2014-08-29 15:09:51'),
(119, 116, '0.10000', 1, 1, 1, '2014-08-29 15:10:56'),
(120, 117, '0.10000', 1, 1, 1, '2014-08-29 15:14:24'),
(121, 118, '0.10000', 1, 1, 1, '2014-08-29 15:16:09'),
(122, 119, '0.10000', 1, 1, 1, '2014-08-29 15:18:19'),
(123, 120, '0.10000', 1, 1, 1, '2014-08-29 15:19:29'),
(124, 121, '0.10000', 1, 1, 1, '2014-08-29 15:20:54'),
(125, 122, '0.10000', 1, 1, 1, '2014-08-29 15:22:37'),
(126, 123, '0.10000', 1, 1, 1, '2014-08-29 15:23:50'),
(128, 125, '0.10000', 1, 1, 1, '2014-08-29 15:26:50'),
(129, 126, '0.10000', 1, 1, 1, '2014-08-29 15:28:17'),
(130, 127, '0.10000', 1, 1, 1, '2014-08-29 15:32:52'),
(131, 128, '0.10000', 1, 1, 1, '2014-08-29 15:36:22'),
(132, 129, '0.10000', 1, 1, 1, '2014-08-29 15:38:07'),
(133, 130, '0.10000', 1, 1, 1, '2014-08-29 15:39:39'),
(134, 131, '0.10000', 1, 1, 1, '2014-08-29 15:41:04'),
(135, 132, '0.10000', 1, 1, 1, '2014-08-29 15:42:16'),
(136, 133, '0.10000', 1, 1, 1, '2014-08-29 15:43:56'),
(137, 134, '0.10000', 1, 1, 1, '2014-08-29 15:45:07'),
(138, 135, '0.04000', 1, 1, 1, '2014-08-29 16:27:26'),
(139, 136, '0.09000', 1, 1, 1, '2014-08-29 16:28:56'),
(140, 137, '6.35000', 1, 1, 1, '2014-08-29 18:53:57'),
(141, 138, '6.25000', 1, 1, 1, '2014-08-29 18:57:27'),
(142, 139, '6.95000', 1, 1, 1, '2014-08-29 19:00:34'),
(143, 140, '4.40000', 1, 1, 1, '2014-08-29 19:08:17'),
(144, 141, '8.06000', 1, 1, 1, '2014-08-29 19:14:26'),
(145, 142, '1.80000', 1, 1, 1, '2014-08-29 19:17:48'),
(146, 143, '1.40000', 1, 1, 1, '2014-08-29 19:23:24'),
(147, 144, '1.95000', 1, 1, 1, '2014-08-29 19:26:12'),
(148, 145, '0.36000', 1, 1, 1, '2014-08-29 19:34:14'),
(149, 146, '0.22000', 1, 1, 1, '2014-08-29 19:36:10'),
(150, 147, '0.05000', 1, 1, 1, '2014-08-29 19:38:33'),
(151, 148, '0.29000', 1, 1, 1, '2014-08-29 19:44:56'),
(152, 149, '0.23000', 1, 1, 1, '2014-08-29 19:46:35'),
(153, 150, '0.28000', 1, 1, 1, '2014-08-29 19:48:03'),
(154, 151, '1.95000', 1, 1, 1, '2014-08-29 19:51:49'),
(155, 152, '0.24000', 1, 1, 1, '2014-08-29 19:54:00'),
(156, 153, '0.10000', 1, 1, 1, '2014-08-29 20:18:13'),
(157, 154, '0.96000', 1, 1, 1, '2014-08-29 20:22:29'),
(158, 155, '1.85000', 1, 1, 1, '2014-08-29 20:25:29'),
(159, 156, '0.03000', 1, 1, 1, '2014-08-29 20:35:05'),
(160, 157, '0.05000', 1, 1, 1, '2014-08-29 20:43:40'),
(161, 158, '0.05000', 1, 1, 1, '2014-08-29 20:48:29'),
(162, 159, '1.65000', 1, 1, 1, '2014-08-29 20:51:32'),
(163, 160, '0.22000', 1, 1, 1, '2014-08-29 20:56:40'),
(164, 161, '0.25000', 1, 1, 1, '2014-08-29 21:00:35');

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

--
-- Tabellenstruktur für Tabelle `storelocations`
--

CREATE TABLE `storelocations` (
  `id` int(11) NOT NULL,
  `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,
  `comment` text COLLATE utf8_unicode_ci,
  `last_modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Daten für Tabelle `storelocations`
--

INSERT INTO `storelocations` (`id`, `name`, `parent_id`, `is_full`, `datetime_added`, `comment`, `last_modified`) VALUES
(1, 'A01', 122, 0, '2013-09-14 19:16:13', NULL, '2017-11-11 16:49:14'),
(2, 'A02', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(3, 'A03', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(4, 'A04', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(5, 'A05', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(6, 'A06', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(7, 'A07', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(8, 'A08', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(9, 'A09', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(10, 'A10', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(11, 'A11', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(12, 'A12', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(13, 'A13', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(14, 'A14', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(15, 'A15', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(16, 'A16', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(17, 'A17', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(18, 'A18', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(19, 'A19', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(20, 'A20', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(21, 'A21', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(22, 'A22', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(23, 'A23', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(24, 'A24', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(25, 'A25', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(26, 'A26', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(27, 'A27', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(28, 'A28', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(29, 'A29', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(30, 'A30', 122, 0, '2013-09-14 19:16:13', NULL, '0000-00-00 00:00:00'),
(31, 'B01', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(32, 'B02', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(33, 'B03', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(34, 'B04', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(35, 'B05', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(36, 'B06', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(37, 'B07', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(38, 'B08', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(39, 'B09', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(40, 'B10', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(41, 'B11', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(42, 'B12', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(43, 'B13', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(44, 'B14', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(45, 'B15', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(46, 'B16', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(47, 'B17', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(48, 'B18', 123, 0, '2013-09-14 19:16:40', NULL, '0000-00-00 00:00:00'),
(49, 'B19', 123, 0, '2013-09-14 19:16:41', NULL, '0000-00-00 00:00:00'),
(50, 'B20', 123, 0, '2013-09-14 19:16:41', NULL, '0000-00-00 00:00:00'),
(51, 'B21', 123, 0, '2013-09-14 19:16:41', NULL, '0000-00-00 00:00:00'),
(52, 'B22', 123, 0, '2013-09-14 19:16:41', NULL, '0000-00-00 00:00:00'),
(53, 'B23', 123, 0, '2013-09-14 19:16:41', NULL, '0000-00-00 00:00:00'),
(54, 'B24', 123, 0, '2013-09-14 19:16:41', NULL, '0000-00-00 00:00:00'),
(55, 'B25', 123, 0, '2013-09-14 19:16:41', NULL, '0000-00-00 00:00:00'),
(56, 'B26', 123, 0, '2013-09-14 19:16:41', NULL, '0000-00-00 00:00:00'),
(57, 'B27', 123, 0, '2013-09-14 19:16:41', NULL, '0000-00-00 00:00:00'),
(58, 'B28', 123, 0, '2013-09-14 19:16:41', NULL, '0000-00-00 00:00:00'),
(59, 'B29', 123, 0, '2013-09-14 19:16:41', NULL, '0000-00-00 00:00:00'),
(60, 'B30', 123, 0, '2013-09-14 19:16:41', NULL, '0000-00-00 00:00:00'),
(61, 'C01', 124, 0, '2013-09-14 19:17:52', NULL, '0000-00-00 00:00:00'),
(62, 'C02', 124, 0, '2013-09-14 19:17:52', NULL, '0000-00-00 00:00:00'),
(63, 'C03', 124, 0, '2013-09-14 19:17:52', NULL, '0000-00-00 00:00:00'),
(64, 'C04', 124, 0, '2013-09-14 19:17:52', NULL, '0000-00-00 00:00:00'),
(65, 'C05', 124, 0, '2013-09-14 19:17:52', NULL, '0000-00-00 00:00:00'),
(66, 'C06', 124, 0, '2013-09-14 19:17:52', NULL, '0000-00-00 00:00:00'),
(67, 'C07', 124, 0, '2013-09-14 19:17:52', NULL, '0000-00-00 00:00:00'),
(68, 'C08', 124, 0, '2013-09-14 19:17:52', NULL, '0000-00-00 00:00:00'),
(69, 'C09', 124, 0, '2013-09-14 19:17:52', NULL, '0000-00-00 00:00:00'),
(70, 'C10', 124, 0, '2013-09-14 19:17:52', NULL, '0000-00-00 00:00:00'),
(71, 'C11', 124, 0, '2013-09-14 19:17:52', NULL, '0000-00-00 00:00:00'),
(72, 'C12', 124, 0, '2013-09-14 19:17:52', NULL, '0000-00-00 00:00:00'),
(73, 'C13', 124, 0, '2013-09-14 19:17:52', NULL, '0000-00-00 00:00:00'),
(74, 'C14', 124, 0, '2013-09-14 19:17:53', NULL, '0000-00-00 00:00:00'),
(75, 'C15', 124, 0, '2013-09-14 19:17:53', NULL, '0000-00-00 00:00:00'),
(76, 'C16', 124, 0, '2013-09-14 19:17:53', NULL, '0000-00-00 00:00:00'),
(77, 'C17', 124, 0, '2013-09-14 19:17:53', NULL, '0000-00-00 00:00:00'),
(78, 'C18', 124, 0, '2013-09-14 19:17:53', NULL, '0000-00-00 00:00:00'),
(79, 'C19', 124, 0, '2013-09-14 19:17:53', NULL, '0000-00-00 00:00:00'),
(80, 'C20', 124, 0, '2013-09-14 19:17:53', NULL, '0000-00-00 00:00:00'),
(81, 'C21', 124, 0, '2013-09-14 19:17:53', NULL, '0000-00-00 00:00:00'),
(82, 'C22', 124, 0, '2013-09-14 19:17:53', NULL, '0000-00-00 00:00:00'),
(83, 'C23', 124, 0, '2013-09-14 19:17:53', NULL, '0000-00-00 00:00:00'),
(84, 'C24', 124, 0, '2013-09-14 19:17:53', NULL, '0000-00-00 00:00:00'),
(85, 'C25', 124, 0, '2013-09-14 19:17:53', NULL, '0000-00-00 00:00:00'),
(86, 'C26', 124, 0, '2013-09-14 19:17:53', NULL, '0000-00-00 00:00:00'),
(87, 'C27', 124, 0, '2013-09-14 19:17:53', NULL, '0000-00-00 00:00:00'),
(88, 'C28', 124, 0, '2013-09-14 19:17:53', NULL, '0000-00-00 00:00:00'),
(89, 'C29', 124, 0, '2013-09-14 19:17:53', NULL, '0000-00-00 00:00:00'),
(90, 'C30', 124, 0, '2013-09-14 19:17:53', NULL, '0000-00-00 00:00:00'),
(91, 'D01', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(92, 'D02', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(93, 'D03', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(94, 'D04', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(95, 'D05', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(96, 'D06', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(97, 'D07', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(98, 'D08', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(99, 'D09', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(100, 'D10', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(101, 'D11', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(102, 'D12', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(103, 'D13', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(104, 'D14', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(105, 'D15', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(106, 'D16', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(107, 'D17', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(108, 'D18', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(109, 'D19', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(110, 'D20', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(111, 'D21', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(112, 'D22', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(113, 'D23', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(114, 'D24', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(115, 'D25', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(116, 'D26', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(117, 'D27', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(118, 'D28', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(119, 'D29', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(120, 'D30', 121, 0, '2013-09-14 19:25:30', NULL, '0000-00-00 00:00:00'),
(121, 'D', 125, 0, '2014-03-20 15:32:34', NULL, '0000-00-00 00:00:00'),
(122, 'A', 125, 0, '2014-03-20 15:42:54', NULL, '0000-00-00 00:00:00'),
(123, 'B', 125, 0, '2014-03-20 15:42:54', NULL, '0000-00-00 00:00:00'),
(124, 'C', 125, 0, '2014-03-20 15:42:54', NULL, '0000-00-00 00:00:00'),
(125, 'Regal 1', NULL, 0, '2014-03-20 15:48:18', NULL, '0000-00-00 00:00:00'),
(127, 'E', 125, 0, '2014-05-29 09:56:20', NULL, '0000-00-00 00:00:00'),
(128, 'F', 125, 0, '2014-05-29 09:56:38', NULL, '0000-00-00 00:00:00'),
(129, 'G', 125, 0, '2014-05-29 09:56:56', NULL, '0000-00-00 00:00:00'),
(130, 'H', 125, 0, '2014-05-29 09:57:09', NULL, '0000-00-00 00:00:00'),
(131, 'E01', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(132, 'E02', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(133, 'E03', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(134, 'E04', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(135, 'E05', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(136, 'E06', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(137, 'E07', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(138, 'E08', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(139, 'E09', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(140, 'E10', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(141, 'E11', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(142, 'E12', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(143, 'E13', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(144, 'E14', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(145, 'E15', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(146, 'E16', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(147, 'E17', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(148, 'E18', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(149, 'E19', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(150, 'E20', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(151, 'E21', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(152, 'E22', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(153, 'E23', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(154, 'E24', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(155, 'E25', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(156, 'E26', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(157, 'E27', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(158, 'E28', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(159, 'E29', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(160, 'E30', 127, 0, '2014-05-29 09:57:32', NULL, '0000-00-00 00:00:00'),
(161, 'F01', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(162, 'F02', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(163, 'F03', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(164, 'F04', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(165, 'F05', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(166, 'F06', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(167, 'F07', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(168, 'F08', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(169, 'F09', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(170, 'F10', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(171, 'F11', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(172, 'F12', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(173, 'F13', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(174, 'F14', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(175, 'F15', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(176, 'F16', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(177, 'F17', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(178, 'F18', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(179, 'F19', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(180, 'F20', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(181, 'F21', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(182, 'F22', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(183, 'F23', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(184, 'F24', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(185, 'F25', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(186, 'F26', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(187, 'F27', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(188, 'F28', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(189, 'F29', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(190, 'F30', 128, 0, '2014-05-29 09:57:56', NULL, '0000-00-00 00:00:00'),
(191, 'G01', 129, 0, '2014-05-29 09:58:14', NULL, '0000-00-00 00:00:00'),
(192, 'G02', 129, 0, '2014-05-29 09:58:14', NULL, '0000-00-00 00:00:00'),
(193, 'G03', 129, 0, '2014-05-29 09:58:15', NULL, '0000-00-00 00:00:00'),
(194, 'G04', 129, 0, '2014-05-29 09:58:15', NULL, '0000-00-00 00:00:00'),
(195, 'G05', 129, 0, '2014-05-29 09:58:16', NULL, '0000-00-00 00:00:00'),
(196, 'G06', 129, 0, '2014-05-29 09:58:16', NULL, '0000-00-00 00:00:00'),
(197, 'G07', 129, 0, '2014-05-29 09:58:16', NULL, '0000-00-00 00:00:00'),
(198, 'G08', 129, 0, '2014-05-29 09:58:16', NULL, '0000-00-00 00:00:00'),
(199, 'G09', 129, 0, '2014-05-29 09:58:16', NULL, '0000-00-00 00:00:00'),
(200, 'G10', 129, 0, '2014-05-29 09:58:16', NULL, '0000-00-00 00:00:00'),
(201, 'G11', 129, 0, '2014-05-29 09:58:16', NULL, '0000-00-00 00:00:00'),
(202, 'G12', 129, 0, '2014-05-29 09:58:16', NULL, '0000-00-00 00:00:00'),
(203, 'G13', 129, 0, '2014-05-29 09:58:17', NULL, '0000-00-00 00:00:00'),
(204, 'G14', 129, 0, '2014-05-29 09:58:17', NULL, '0000-00-00 00:00:00'),
(205, 'G15', 129, 0, '2014-05-29 09:58:17', NULL, '0000-00-00 00:00:00'),
(206, 'G16', 129, 0, '2014-05-29 09:58:18', NULL, '0000-00-00 00:00:00'),
(207, 'G17', 129, 0, '2014-05-29 09:58:18', NULL, '0000-00-00 00:00:00'),
(208, 'G18', 129, 0, '2014-05-29 09:58:18', NULL, '0000-00-00 00:00:00'),
(209, 'G19', 129, 0, '2014-05-29 09:58:18', NULL, '0000-00-00 00:00:00'),
(210, 'G20', 129, 0, '2014-05-29 09:58:18', NULL, '0000-00-00 00:00:00'),
(211, 'G21', 129, 0, '2014-05-29 09:58:18', NULL, '0000-00-00 00:00:00'),
(212, 'G22', 129, 0, '2014-05-29 09:58:18', NULL, '0000-00-00 00:00:00'),
(213, 'G23', 129, 0, '2014-05-29 09:58:18', NULL, '0000-00-00 00:00:00'),
(214, 'G24', 129, 0, '2014-05-29 09:58:18', NULL, '0000-00-00 00:00:00'),
(215, 'G25', 129, 0, '2014-05-29 09:58:18', NULL, '0000-00-00 00:00:00'),
(216, 'G26', 129, 0, '2014-05-29 09:58:18', NULL, '0000-00-00 00:00:00'),
(217, 'G27', 129, 0, '2014-05-29 09:58:18', NULL, '0000-00-00 00:00:00'),
(218, 'G28', 129, 0, '2014-05-29 09:58:18', NULL, '0000-00-00 00:00:00'),
(219, 'G29', 129, 0, '2014-05-29 09:58:18', NULL, '0000-00-00 00:00:00'),
(220, 'G30', 129, 0, '2014-05-29 09:58:18', NULL, '0000-00-00 00:00:00'),
(221, 'H01', 130, 0, '2014-05-29 09:58:35', NULL, '0000-00-00 00:00:00'),
(222, 'H02', 130, 0, '2014-05-29 09:58:35', NULL, '0000-00-00 00:00:00'),
(223, 'H03', 130, 0, '2014-05-29 09:58:35', NULL, '0000-00-00 00:00:00'),
(224, 'H04', 130, 0, '2014-05-29 09:58:35', NULL, '0000-00-00 00:00:00'),
(225, 'H05', 130, 0, '2014-05-29 09:58:36', NULL, '0000-00-00 00:00:00'),
(226, 'H06', 130, 0, '2014-05-29 09:58:36', NULL, '0000-00-00 00:00:00'),
(227, 'H07', 130, 0, '2014-05-29 09:58:36', NULL, '0000-00-00 00:00:00'),
(228, 'H08', 130, 0, '2014-05-29 09:58:36', NULL, '0000-00-00 00:00:00'),
(229, 'H09', 130, 0, '2014-05-29 09:58:36', NULL, '0000-00-00 00:00:00'),
(230, 'H10', 130, 0, '2014-05-29 09:58:36', NULL, '0000-00-00 00:00:00'),
(231, 'H11', 130, 0, '2014-05-29 09:58:36', NULL, '0000-00-00 00:00:00'),
(232, 'H12', 130, 0, '2014-05-29 09:58:36', NULL, '0000-00-00 00:00:00'),
(233, 'H13', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00'),
(234, 'H14', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00'),
(235, 'H15', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00'),
(236, 'H16', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00'),
(237, 'H17', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00'),
(238, 'H18', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00'),
(239, 'H19', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00'),
(240, 'H20', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00'),
(241, 'H21', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00'),
(242, 'H22', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00'),
(243, 'H23', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00'),
(244, 'H24', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00'),
(245, 'H25', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00'),
(246, 'H26', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00'),
(247, 'H27', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00'),
(248, 'H28', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00'),
(249, 'H29', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00'),
(250, 'H30', 130, 0, '2014-05-29 09:58:37', NULL, '0000-00-00 00:00:00');

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

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

CREATE TABLE `suppliers` (
  `id` int(11) NOT NULL,
  `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,
  `comment` text COLLATE utf8_unicode_ci,
  `last_modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `suppliers` (`id`, `name`, `parent_id`, `address`, `phone_number`, `fax_number`, `email_address`, `website`, `auto_product_url`, `datetime_added`, `comment`, `last_modified`) VALUES
(1, 'Reichelt', NULL, '', '', '', '', '', '', '2013-09-14 19:31:12', NULL, '0000-00-00 00:00:00'),
(2, 'Pollin', NULL, '', '', '', '', '', '', '2013-09-14 20:08:28', NULL, '0000-00-00 00:00:00'),
(3, 'RS', NULL, '', '', '', '', '', '', '2014-03-20 16:01:57', NULL, '0000-00-00 00:00:00'),
(4, 'Ebay', NULL, '', '', '', '', '', '', '2014-03-21 09:56:05', NULL, '0000-00-00 00:00:00');

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes für die Tabelle `attachements`
--
ALTER TABLE `attachements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `attachements_class_name_k` (`class_name`),
  ADD KEY `attachements_element_id_k` (`element_id`),
  ADD KEY `attachements_type_id_fk` (`type_id`);

--
-- Indizes für die Tabelle `attachement_types`
--
ALTER TABLE `attachement_types`
  ADD PRIMARY KEY (`id`),
  ADD KEY `attachement_types_parent_id_k` (`parent_id`);

--
-- Indizes für die Tabelle `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `categories_parent_id_k` (`parent_id`);

--
-- Indizes für die Tabelle `devices`
--
ALTER TABLE `devices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `devices_parent_id_k` (`parent_id`);

--
-- Indizes für die Tabelle `device_parts`
--
ALTER TABLE `device_parts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `device_parts_combination_uk` (`id_part`,`id_device`),
  ADD KEY `device_parts_id_part_k` (`id_part`),
  ADD KEY `device_parts_id_device_k` (`id_device`);

--
-- Indizes für die Tabelle `footprints`
--
ALTER TABLE `footprints`
  ADD PRIMARY KEY (`id`),
  ADD KEY `footprints_parent_id_k` (`parent_id`);

--
-- Indizes für die Tabelle `groups`
--
ALTER TABLE `groups`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indizes für die Tabelle `internal`
--
ALTER TABLE `internal`
  ADD UNIQUE KEY `keyName` (`keyName`);

--
-- Indizes für die Tabelle `manufacturers`
--
ALTER TABLE `manufacturers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `manufacturers_parent_id_k` (`parent_id`);

--
-- Indizes für die Tabelle `orderdetails`
--
ALTER TABLE `orderdetails`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orderdetails_part_id_k` (`part_id`),
  ADD KEY `orderdetails_id_supplier_k` (`id_supplier`);

--
-- Indizes für die Tabelle `parts`
--
ALTER TABLE `parts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parts_id_category_k` (`id_category`),
  ADD KEY `parts_id_footprint_k` (`id_footprint`),
  ADD KEY `parts_id_storelocation_k` (`id_storelocation`),
  ADD KEY `parts_order_orderdetails_id_k` (`order_orderdetails_id`),
  ADD KEY `parts_id_manufacturer_k` (`id_manufacturer`),
  ADD KEY `favorite` (`favorite`);

--
-- Indizes für die Tabelle `pricedetails`
--
ALTER TABLE `pricedetails`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pricedetails_combination_uk` (`orderdetails_id`,`min_discount_quantity`),
  ADD KEY `pricedetails_orderdetails_id_k` (`orderdetails_id`);

--
-- Indizes für die Tabelle `storelocations`
--
ALTER TABLE `storelocations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `storelocations_parent_id_k` (`parent_id`);

--
-- Indizes für die Tabelle `suppliers`
--
ALTER TABLE `suppliers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `suppliers_parent_id_k` (`parent_id`);

--
-- AUTO_INCREMENT für exportierte Tabellen
--

--
-- AUTO_INCREMENT für Tabelle `attachements`
--
ALTER TABLE `attachements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT für Tabelle `attachement_types`
--
ALTER TABLE `attachement_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT für Tabelle `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;
--
-- AUTO_INCREMENT für Tabelle `devices`
--
ALTER TABLE `devices`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `device_parts`
--
ALTER TABLE `device_parts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `footprints`
--
ALTER TABLE `footprints`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;
--
-- AUTO_INCREMENT für Tabelle `groups`
--
ALTER TABLE `groups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT für Tabelle `manufacturers`
--
ALTER TABLE `manufacturers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `orderdetails`
--
ALTER TABLE `orderdetails`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=162;
--
-- AUTO_INCREMENT für Tabelle `parts`
--
ALTER TABLE `parts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=182;
--
-- AUTO_INCREMENT für Tabelle `pricedetails`
--
ALTER TABLE `pricedetails`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=165;
--
-- AUTO_INCREMENT für Tabelle `storelocations`
--
ALTER TABLE `storelocations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=251;
--
-- AUTO_INCREMENT für Tabelle `suppliers`
--
ALTER TABLE `suppliers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- Constraints der exportierten Tabellen
--

--
-- Constraints der Tabelle `attachements`
--
ALTER TABLE `attachements`
  ADD CONSTRAINT `attachements_type_id_fk` FOREIGN KEY (`type_id`) REFERENCES `attachement_types` (`id`);

--
-- Constraints der Tabelle `attachement_types`
--
ALTER TABLE `attachement_types`
  ADD CONSTRAINT `attachement_types_parent_id_fk` FOREIGN KEY (`parent_id`) REFERENCES `attachement_types` (`id`);

--
-- Constraints der Tabelle `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `categories_parent_id_fk` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`);

--
-- Constraints der Tabelle `devices`
--
ALTER TABLE `devices`
  ADD CONSTRAINT `devices_parent_id_fk` FOREIGN KEY (`parent_id`) REFERENCES `devices` (`id`);

--
-- Constraints der Tabelle `footprints`
--
ALTER TABLE `footprints`
  ADD CONSTRAINT `footprints_parent_id_fk` FOREIGN KEY (`parent_id`) REFERENCES `footprints` (`id`);

--
-- Constraints der Tabelle `manufacturers`
--
ALTER TABLE `manufacturers`
  ADD CONSTRAINT `manufacturers_parent_id_fk` FOREIGN KEY (`parent_id`) REFERENCES `manufacturers` (`id`);

--
-- Constraints der Tabelle `parts`
--
ALTER TABLE `parts`
  ADD CONSTRAINT `parts_id_footprint_fk` FOREIGN KEY (`id_footprint`) REFERENCES `footprints` (`id`),
  ADD CONSTRAINT `parts_id_manufacturer_fk` FOREIGN KEY (`id_manufacturer`) REFERENCES `manufacturers` (`id`),
  ADD CONSTRAINT `parts_id_storelocation_fk` FOREIGN KEY (`id_storelocation`) REFERENCES `storelocations` (`id`),
  ADD CONSTRAINT `parts_order_orderdetails_id_fk` FOREIGN KEY (`order_orderdetails_id`) REFERENCES `orderdetails` (`id`);

--
-- Constraints der Tabelle `storelocations`
--
ALTER TABLE `storelocations`
  ADD CONSTRAINT `storelocations_parent_id_fk` FOREIGN KEY (`parent_id`) REFERENCES `storelocations` (`id`);

--
-- Constraints der Tabelle `suppliers`
--
ALTER TABLE `suppliers`
  ADD CONSTRAINT `suppliers_parent_id_fk` FOREIGN KEY (`parent_id`) REFERENCES `suppliers` (`id`);

