-- phpMyAdmin SQL Dump -- version 2.6.1-pl3 -- http://www.phpmyadmin.net -- -- Host: localhost -- Erstellungszeit: 31. Mai 2006 um 18:13 -- Server Version: 4.1.18 -- PHP-Version: 5.1.2 -- -- Datenbank: `dhwms` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `attribute` -- CREATE TABLE `attribute` ( `id` int(11) NOT NULL auto_increment, `componenttype_id` int(11) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `default_value` varchar(255) NOT NULL default '', `type` varchar(255) NOT NULL default '', `enabled` varchar(255) NOT NULL default '', `creation_date` int(11) NOT NULL default '0', `alteration_date` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `attribute_FI_1` (`componenttype_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ; -- -- Daten für Tabelle `attribute` -- INSERT INTO `attribute` VALUES (1, 1, 'MAC', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (2, 1, 'IP Adresse', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (3, 1, 'Schaltschema', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (4, 1, 'Revision', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (5, 1, 'TJA1080', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (6, 2, 'Revision', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (7, 2, 'Liefereingang', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (8, 3, 'Size MB', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (9, 3, 'Liefereingang', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (10, 4, 'CPLD', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (11, 4, 'FlexRay Version', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (12, 4, 'TJA1080', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (13, 4, 'Jumper', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (14, 5, 'CPLD', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (15, 5, 'FlexRay Version', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (16, 5, 'TJA1080', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (17, 5, 'Jumper', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (18, 6, 'Type', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (19, 6, 'Revision', '', 'string', '1', 0, 0); INSERT INTO `attribute` VALUES (20, 6, 'Vendor', '', 'string', '1', 0, 0); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `company` -- CREATE TABLE `company` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `creation_date` int(11) NOT NULL default '0', `alteration_date` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Daten für Tabelle `company` -- INSERT INTO `company` VALUES (1, 'BMW', 1148928144, 1148928144); INSERT INTO `company` VALUES (2, 'Volkswagen', 1148928295, 1148928295); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `component` -- CREATE TABLE `component` ( `id` int(11) NOT NULL auto_increment, `meta_id` int(11) NOT NULL default '0', `version` varchar(255) NOT NULL default '', `componenttype_id` int(11) NOT NULL default '0', `product_id` int(11) default NULL, `serial` varchar(255) NOT NULL default '', `name` varchar(255) NOT NULL default '', `comment` varchar(255) NOT NULL default '', `creation_date` int(11) NOT NULL default '0', `alteration_date` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `component_FI_1` (`meta_id`), KEY `component_FI_2` (`componenttype_id`), KEY `component_FI_3` (`product_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ; -- -- Daten für Tabelle `component` -- INSERT INTO `component` VALUES (1, 1, '1', 3, NULL, 'DCS-001', '', '', 0, 1148935427); INSERT INTO `component` VALUES (2, 2, '1', 3, NULL, 'DCS-002', '', '', 0, 1148935462); INSERT INTO `component` VALUES (3, 3, '1', 2, NULL, '01004533', '', '', 0, 1148935486); INSERT INTO `component` VALUES (4, 4, '1', 2, NULL, '01004534', '', '', 0, 1148935509); INSERT INTO `component` VALUES (5, 5, '1', 4, 8, 'S00AT001', '', '', 0, 1148935533); INSERT INTO `component` VALUES (6, 6, '1', 4, NULL, 'S00AT002', '', '', 0, 1148935554); INSERT INTO `component` VALUES (7, 7, '1', 4, 8, 'S00AT003', '', '', 0, 1148935573); INSERT INTO `component` VALUES (8, 8, '1', 4, NULL, 'S00AT004', '', '', 0, 1148935594); INSERT INTO `component` VALUES (9, 9, '1', 5, NULL, 'S00AT005', '', '', 0, 1148935634); INSERT INTO `component` VALUES (10, 10, '1', 5, NULL, 'S00AT006', '', '', 0, 1148935649); INSERT INTO `component` VALUES (11, 11, '1', 5, NULL, 'S00AT007', '', '', 0, 1148935666); INSERT INTO `component` VALUES (12, 12, '1', 5, NULL, 'S00AT008', '', '', 0, 1148935686); INSERT INTO `component` VALUES (13, 13, '1', 1, NULL, 'S00AT009', '', '', 0, 1148935711); INSERT INTO `component` VALUES (14, 14, '1', 1, NULL, 'S00AT010', '', '', 0, 1148935739); INSERT INTO `component` VALUES (15, 15, '1', 6, 8, '9304063', '', '', 0, 1148935823); INSERT INTO `component` VALUES (16, 16, '1', 6, NULL, '9304066', '', '', 0, 1148935846); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `component_info` -- CREATE TABLE `component_info` ( `id` int(11) NOT NULL auto_increment, `component_id` int(11) NOT NULL default '0', `attribute_id` int(11) NOT NULL default '0', `value` varchar(255) NOT NULL default '', `creation_date` int(11) NOT NULL default '0', `alteration_date` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `component_info_FI_1` (`component_id`), KEY `component_info_FI_2` (`attribute_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=57 ; -- -- Daten für Tabelle `component_info` -- INSERT INTO `component_info` VALUES (1, 1, 8, '512', 0, 1148935427); INSERT INTO `component_info` VALUES (2, 1, 9, '24.12.2005', 0, 1148935427); INSERT INTO `component_info` VALUES (3, 2, 8, '1000', 0, 1148935463); INSERT INTO `component_info` VALUES (4, 2, 9, '13.4.2006', 0, 1148935463); INSERT INTO `component_info` VALUES (5, 3, 6, '10-2001-1501', 0, 1148935486); INSERT INTO `component_info` VALUES (6, 3, 7, '2.9.2004', 0, 1148935486); INSERT INTO `component_info` VALUES (7, 4, 6, '10-2001-1501 new', 0, 1148935509); INSERT INTO `component_info` VALUES (8, 4, 7, '2.9.2004', 0, 1148935509); INSERT INTO `component_info` VALUES (9, 5, 10, 'FlexIM2plus IP V2.3', 0, 1148935534); INSERT INTO `component_info` VALUES (10, 5, 11, 'MOT V9.1', 0, 1148935534); INSERT INTO `component_info` VALUES (11, 5, 12, 'N1D3', 0, 1148935534); INSERT INTO `component_info` VALUES (12, 5, 13, 'TJA1080', 0, 1148935534); INSERT INTO `component_info` VALUES (13, 6, 10, 'FlexIM2plus IP V2.4', 0, 1148935555); INSERT INTO `component_info` VALUES (14, 6, 11, 'MOT V6.2', 0, 1148935555); INSERT INTO `component_info` VALUES (15, 6, 12, 'N1A', 0, 1148935555); INSERT INTO `component_info` VALUES (16, 6, 13, 'TJA1080', 0, 1148935555); INSERT INTO `component_info` VALUES (17, 7, 10, 'FlexIM2plus IP V2.3', 0, 1148935573); INSERT INTO `component_info` VALUES (18, 7, 11, 'MOT V9.1', 0, 1148935573); INSERT INTO `component_info` VALUES (19, 7, 12, 'N1A', 0, 1148935574); INSERT INTO `component_info` VALUES (20, 7, 13, 'TJA1080', 0, 1148935574); INSERT INTO `component_info` VALUES (21, 8, 10, 'FlexIM2plus IP V2.4', 0, 1148935595); INSERT INTO `component_info` VALUES (22, 8, 11, 'MOT V6.2', 0, 1148935595); INSERT INTO `component_info` VALUES (23, 8, 12, 'N1D3', 0, 1148935595); INSERT INTO `component_info` VALUES (24, 8, 13, 'TJA1080', 0, 1148935595); INSERT INTO `component_info` VALUES (25, 9, 14, 'FlexIm 4 plus', 0, 1148935634); INSERT INTO `component_info` VALUES (26, 9, 15, 'V9.1', 0, 1148935634); INSERT INTO `component_info` VALUES (27, 9, 16, 'N1D2', 0, 1148935634); INSERT INTO `component_info` VALUES (28, 9, 17, 'TJA1080', 0, 1148935634); INSERT INTO `component_info` VALUES (29, 10, 14, 'FlexIm 4 plus', 0, 1148935650); INSERT INTO `component_info` VALUES (30, 10, 15, '', 0, 1148935650); INSERT INTO `component_info` VALUES (31, 10, 16, '', 0, 1148935650); INSERT INTO `component_info` VALUES (32, 10, 17, '', 0, 1148935650); INSERT INTO `component_info` VALUES (33, 11, 14, 'FlexIm 4 plus', 0, 1148935667); INSERT INTO `component_info` VALUES (34, 11, 15, 'V9.1', 0, 1148935667); INSERT INTO `component_info` VALUES (35, 11, 16, 'N1D2', 0, 1148935667); INSERT INTO `component_info` VALUES (36, 11, 17, 'TJA1080', 0, 1148935667); INSERT INTO `component_info` VALUES (37, 12, 14, 'FlexIm 4 plus', 0, 1148935687); INSERT INTO `component_info` VALUES (38, 12, 15, 'V9.1', 0, 1148935687); INSERT INTO `component_info` VALUES (39, 12, 16, 'N1D2', 0, 1148935687); INSERT INTO `component_info` VALUES (40, 12, 17, 'TJA1080', 0, 1148935687); INSERT INTO `component_info` VALUES (41, 13, 1, '00.11.22.33.44', 0, 1148935711); INSERT INTO `component_info` VALUES (42, 13, 2, '192.168.83.6', 0, 1148935711); INSERT INTO `component_info` VALUES (43, 13, 3, '03', 0, 1148935711); INSERT INTO `component_info` VALUES (44, 13, 4, 'whatever', 0, 1148935711); INSERT INTO `component_info` VALUES (45, 13, 5, 'N1C', 0, 1148935711); INSERT INTO `component_info` VALUES (46, 14, 1, '00.11.22.33.11', 0, 1148935740); INSERT INTO `component_info` VALUES (47, 14, 2, '192.168.83.10', 0, 1148935740); INSERT INTO `component_info` VALUES (48, 14, 3, '03', 0, 1148935740); INSERT INTO `component_info` VALUES (49, 14, 4, 'whatever', 0, 1148935740); INSERT INTO `component_info` VALUES (50, 14, 5, 'N1C', 0, 1148935740); INSERT INTO `component_info` VALUES (51, 15, 18, 'TPCI2000-10', 0, 1148935824); INSERT INTO `component_info` VALUES (52, 15, 19, 'Ver 1.0 Rev B', 0, 1148935824); INSERT INTO `component_info` VALUES (53, 15, 20, 'TEWS', 0, 1148935824); INSERT INTO `component_info` VALUES (54, 16, 18, 'TPCI2000-10', 0, 1148935847); INSERT INTO `component_info` VALUES (55, 16, 19, 'Ver 1.0 Rev B', 0, 1148935847); INSERT INTO `component_info` VALUES (56, 16, 20, '', 0, 1148935847); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `componenttype` -- CREATE TABLE `componenttype` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `description` tinytext NOT NULL, `creation_date` int(11) NOT NULL default '0', `alteration_date` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `I_referenced_component_FK_2_1` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Daten für Tabelle `componenttype` -- INSERT INTO `componenttype` VALUES (1, 'Node Arm Board', '', 1148924319, 1148924319); INSERT INTO `componenttype` VALUES (2, 'CF2IP Adapter', '', 1148924403, 1148924403); INSERT INTO `componenttype` VALUES (3, 'CF Card', '', 1148924455, 1148924455); INSERT INTO `componenttype` VALUES (4, 'FlexIM2+', '', 1148924556, 1148924556); INSERT INTO `componenttype` VALUES (5, 'FlexIM4', '', 1148924648, 1148924648); INSERT INTO `componenttype` VALUES (6, 'PCI IP Carrier', '', 1148924712, 1148924712); INSERT INTO `componenttype` VALUES (7, 'test component', '', 1148932930, 1148932930); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `contact` -- CREATE TABLE `contact` ( `id` int(11) NOT NULL auto_increment, `department_id` int(11) NOT NULL default '0', `surname` varchar(255) NOT NULL default '', `firstname` varchar(255) NOT NULL default '', `phone` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `creation_date` int(11) NOT NULL default '0', `alteration_date` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `contact_FI_1` (`department_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Daten für Tabelle `contact` -- INSERT INTO `contact` VALUES (1, 1, 'Pitschl', 'Lukas', '0666/2323423', 'luke@bmw.de', 1148928244, 1148928244); INSERT INTO `contact` VALUES (2, 2, 'Schachinger', 'Stefan', '0664/5278335', 'schachi0@gmx.at', 1148928343, 1148928343); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `department` -- CREATE TABLE `department` ( `id` int(11) NOT NULL auto_increment, `company_id` int(11) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `address` varchar(255) NOT NULL default '', `city` varchar(255) NOT NULL default '', `zip` int(11) NOT NULL default '0', `state` varchar(255) NOT NULL default '', `creation_date` int(11) NOT NULL default '0', `alteration_date` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `department_FI_1` (`company_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Daten für Tabelle `department` -- INSERT INTO `department` VALUES (1, 1, 'Muenchen', 'Wiener Strasse 12', 'Wien', 12981, 'Germany', 1148928190, 1148928214); INSERT INTO `department` VALUES (2, 2, 'Wien', 'Novaragasse 16/11', 'Wien', 1020, 'Austria', 1148928318, 1148928318); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `depot` -- CREATE TABLE `depot` ( `id` int(11) NOT NULL auto_increment, `meta_id` int(11) NOT NULL default '0', `version` int(11) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `description` tinytext NOT NULL, `stock` int(11) NOT NULL default '0', `creation_date` int(11) NOT NULL default '0', `alteration_date` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `depot_FI_1` (`meta_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ; -- -- Daten für Tabelle `depot` -- INSERT INTO `depot` VALUES (1, 1, 1, 'Busdoctor Deckel', '', 20, 1148935871, 1148935871); INSERT INTO `depot` VALUES (2, 2, 1, 'Busdoctor Boden', '', 20, 1148935893, 1148935893); INSERT INTO `depot` VALUES (3, 3, 1, 'Busdoctor Frontplatte', '', 20, 1148935914, 1148935914); INSERT INTO `depot` VALUES (4, 4, 1, 'Busdoctor Rueckplatte', '', 20, 1148935926, 1148935926); INSERT INTO `depot` VALUES (5, 5, 1, 'Busdoctor Rueckplatte RBS', '', 20, 1148935936, 1148935936); INSERT INTO `depot` VALUES (6, 6, 1, 'TJA1080 N1D3', '', 50, 1148935951, 1148935951); INSERT INTO `depot` VALUES (7, 7, 1, 'Industrie PC', '', 5, 1148935964, 1148935964); INSERT INTO `depot` VALUES (8, 8, 1, 'Tastatur', '', 10, 1148935975, 1148935975); INSERT INTO `depot` VALUES (9, 9, 1, 'Maus', '', 10, 1148935984, 1148935984); INSERT INTO `depot` VALUES (10, 10, 1, 'NodePC Recovery CD', '', 10, 1148935997, 1148935997); INSERT INTO `depot` VALUES (11, 11, 1, 'NodePC Manual', '', 5, 1148936014, 1148936014); INSERT INTO `depot` VALUES (12, 12, 1, 'Busdoctor Control Tool', '', 10, 1148936037, 1148936037); INSERT INTO `depot` VALUES (13, 7, 2, 'Industrie PC', '1 of Industrie PC added to schachis power pc', 4, 29, 1149088743); INSERT INTO `depot` VALUES (14, 9, 2, 'Maus', '1 of Maus added to schachis power pc', 9, 29, 1149088831); INSERT INTO `depot` VALUES (15, 8, 2, 'Tastatur', '1 of Tastatur added to schachis power pc', 9, 29, 1149088832); INSERT INTO `depot` VALUES (16, 7, 3, 'Industrie PC', 'Removed 1 from NodePC schachis power pc', 5, 1, 1149088879); INSERT INTO `depot` VALUES (17, 9, 3, 'Maus', 'Removed 1 from NodePC schachis power pc', 10, 1, 1149088879); INSERT INTO `depot` VALUES (18, 8, 3, 'Tastatur', 'Removed 1 from NodePC schachis power pc', 10, 1, 1149088879); INSERT INTO `depot` VALUES (19, 7, 4, 'Industrie PC', '1 of Industrie PC added to schachis power pc', 4, 1, 1149088973); INSERT INTO `depot` VALUES (20, 9, 4, 'Maus', '1 of Maus added to schachis power pc', 9, 1, 1149088973); INSERT INTO `depot` VALUES (21, 8, 4, 'Tastatur', '1 of Tastatur added to schachis power pc', 9, 1, 1149088973); INSERT INTO `depot` VALUES (22, 11, 2, 'NodePC Manual', '1 of NodePC Manual added to schachis power pc', 4, 29, 1149088973); INSERT INTO `depot` VALUES (23, 10, 2, 'NodePC Recovery CD', '1 of NodePC Recovery CD added to schachis power pc', 9, 29, 1149088973); INSERT INTO `depot` VALUES (24, 6, 2, 'TJA1080 N1D3', '4 of TJA1080 N1D3 added to schachis power pc', 46, 29, 1149088973); INSERT INTO `depot` VALUES (25, 9, 5, 'Maus', 'Added 1 to NodePC schachis power pc', 8, 1, 1149090794); INSERT INTO `depot` VALUES (26, 8, 5, 'Tastatur', 'Added 1 to NodePC schachis power pc', 8, 1, 1149090794); INSERT INTO `depot` VALUES (27, 11, 3, 'NodePC Manual', 'Added 1 to NodePC schachis power pc', 3, 1, 1149090794); INSERT INTO `depot` VALUES (28, 10, 3, 'NodePC Recovery CD', 'Added 1 to NodePC schachis power pc', 8, 1, 1149090794); INSERT INTO `depot` VALUES (29, 6, 3, 'TJA1080 N1D3', 'Added 4 to NodePC schachis power pc', 42, 1, 1149090795); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `device` -- CREATE TABLE `device` ( `id` int(11) NOT NULL auto_increment, `meta_id` int(11) NOT NULL default '0', `version` varchar(255) NOT NULL default '', `deleted` int(11) NOT NULL default '0', `product_id` int(11) default NULL, `name` varchar(255) NOT NULL default '', `description` tinytext NOT NULL, `current_owner` varchar(255) NOT NULL default '', `creation_date` int(11) NOT NULL default '0', `alteration_date` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `device_FI_1` (`meta_id`), KEY `device_FI_2` (`product_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ; -- -- Daten für Tabelle `device` -- INSERT INTO `device` VALUES (1, 1, '1', 0, 1, 'DECOMSYS-BUSDOCTOR-010', 'Busdoctor', 'lukas pitschl', 1149084893, 1149084893); INSERT INTO `device` VALUES (2, 1, '2', 1, 3, 'DECOMSYS-BUSDOCTOR-010', 'Busdoctor', 'No current owner', 31, 1149084940); INSERT INTO `device` VALUES (3, 1, '3', 0, 4, 'DECOMSYS-BUSDOCTOR-010', 'Busdoctor', 'scachie', 1, 1149084967); INSERT INTO `device` VALUES (4, 2, '1', 0, NULL, 'Bohrmaschine', '', 'Schachi', 1149085446, 1149085446); INSERT INTO `device` VALUES (5, 2, '2', 0, NULL, 'Bohrmaschine', '', 'Lager', 31, 1149085457); INSERT INTO `device` VALUES (6, 2, '3', 0, NULL, 'Bohrmaschine', '', 'Lukas', 1, 1149085467); INSERT INTO `device` VALUES (7, 2, '4', 0, NULL, 'Bohrmaschine', '', 'Simon', 1, 1149085478); INSERT INTO `device` VALUES (8, 12, '1', 0, 5, 'schachis power pc', 'NodePC', 'schachi', 1149088743, 1149088743); INSERT INTO `device` VALUES (9, 12, '2', 1, 6, 'schachis power pc', 'NodePC', 'No current owner', 31, 1149088830); INSERT INTO `device` VALUES (10, 12, '3', 1, 7, 'schachis power pc', 'NodePC', 'No current owner', 1, 1149088879); INSERT INTO `device` VALUES (11, 12, '4', 1, 8, 'schachis power pc', 'NodePC', 'No current owner', 1, 1149088972); INSERT INTO `device` VALUES (12, 12, '5', 1, 9, 'schachis power pc', 'NodePC', 'No current owner', 1, 1149090681); INSERT INTO `device` VALUES (13, 12, '6', 1, 10, 'schachis power pc', 'NodePC', 'No current owner', 1, 1149090693); INSERT INTO `device` VALUES (14, 12, '7', 1, 11, 'schachis power pc', 'NodePC', 'No current owner', 1, 1149090793); INSERT INTO `device` VALUES (15, 12, '8', 1, 12, 'schachis power pc', 'NodePC', 'No current owner', 1, 1149090920); INSERT INTO `device` VALUES (16, 12, '9', 1, 13, 'schachis power pc', 'NodePC', 'No current owner', 1, 1149091209); INSERT INTO `device` VALUES (17, 12, '10', 1, 14, 'schachis power pc', 'NodePC', 'No current owner', 1, 1149091709); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `meta_component` -- CREATE TABLE `meta_component` ( `id` int(11) NOT NULL auto_increment, `latest` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `meta_component_FI_1` (`latest`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ; -- -- Daten für Tabelle `meta_component` -- INSERT INTO `meta_component` VALUES (1, 1); INSERT INTO `meta_component` VALUES (2, 2); INSERT INTO `meta_component` VALUES (3, 3); INSERT INTO `meta_component` VALUES (4, 4); INSERT INTO `meta_component` VALUES (5, 5); INSERT INTO `meta_component` VALUES (6, 6); INSERT INTO `meta_component` VALUES (7, 7); INSERT INTO `meta_component` VALUES (8, 8); INSERT INTO `meta_component` VALUES (9, 9); INSERT INTO `meta_component` VALUES (10, 10); INSERT INTO `meta_component` VALUES (11, 11); INSERT INTO `meta_component` VALUES (12, 12); INSERT INTO `meta_component` VALUES (13, 13); INSERT INTO `meta_component` VALUES (14, 14); INSERT INTO `meta_component` VALUES (15, 15); INSERT INTO `meta_component` VALUES (16, 16); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `meta_depot` -- CREATE TABLE `meta_depot` ( `id` int(11) NOT NULL auto_increment, `latest` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `meta_depot_FI_1` (`latest`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; -- -- Daten für Tabelle `meta_depot` -- INSERT INTO `meta_depot` VALUES (1, 1); INSERT INTO `meta_depot` VALUES (2, 2); INSERT INTO `meta_depot` VALUES (3, 3); INSERT INTO `meta_depot` VALUES (4, 4); INSERT INTO `meta_depot` VALUES (5, 5); INSERT INTO `meta_depot` VALUES (6, 29); INSERT INTO `meta_depot` VALUES (7, 19); INSERT INTO `meta_depot` VALUES (8, 26); INSERT INTO `meta_depot` VALUES (9, 25); INSERT INTO `meta_depot` VALUES (10, 28); INSERT INTO `meta_depot` VALUES (11, 27); INSERT INTO `meta_depot` VALUES (12, 12); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `meta_device` -- CREATE TABLE `meta_device` ( `id` int(11) NOT NULL auto_increment, `latest` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `meta_device_FI_1` (`latest`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; -- -- Daten für Tabelle `meta_device` -- INSERT INTO `meta_device` VALUES (1, 3); INSERT INTO `meta_device` VALUES (2, 7); INSERT INTO `meta_device` VALUES (12, 17); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `meta_product` -- CREATE TABLE `meta_product` ( `id` int(11) NOT NULL auto_increment, `latest` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `meta_product_FI_1` (`latest`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Daten für Tabelle `meta_product` -- INSERT INTO `meta_product` VALUES (1, 4); INSERT INTO `meta_product` VALUES (2, 14); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `product` -- CREATE TABLE `product` ( `id` int(11) NOT NULL auto_increment, `meta_id` int(11) NOT NULL default '0', `version` varchar(255) NOT NULL default '', `producttype_id` int(11) NOT NULL default '0', `serial` varchar(255) NOT NULL default '', `description` tinytext NOT NULL, `internal` varchar(255) NOT NULL default '', `inrepair` varchar(255) NOT NULL default '', `delivery_nr` varchar(255) NOT NULL default '', `delivery_date` varchar(255) NOT NULL default '', `billing_nr` varchar(255) NOT NULL default '', `billing_date` varchar(255) NOT NULL default '', `contact_id` int(11) NOT NULL default '0', `creation_date` int(11) NOT NULL default '0', `alteration_date` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `I_referenced_component_FK_3_1` (`serial`), KEY `product_FI_1` (`meta_id`), KEY `product_FI_2` (`producttype_id`), KEY `product_FI_3` (`contact_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ; -- -- Daten für Tabelle `product` -- INSERT INTO `product` VALUES (1, 1, '1', 1, 'DECOMSYS-BUSDOCTOR-010', 'version 2', '1', '0', '', '', '', '', 0, 1149084892, 1149084892); INSERT INTO `product` VALUES (2, 1, '2', 1, 'DECOMSYS-BUSDOCTOR-010', 'version 2', '1', '1', '', '', '', '', 0, 31, 1149084911); INSERT INTO `product` VALUES (3, 1, '3', 1, 'DECOMSYS-BUSDOCTOR-010', 'version 2', '0', '1', '', '', '', '', 0, 1, 1149084939); INSERT INTO `product` VALUES (4, 1, '4', 1, 'DECOMSYS-BUSDOCTOR-010', 'version 2', '1', '1', '', '', '', '', 0, 1, 1149084966); INSERT INTO `product` VALUES (5, 2, '1', 2, 'schachis power pc', 'anlegen, mit components, intern', '1', '0', '', '', '', '', 0, 1149088742, 1149088742); INSERT INTO `product` VALUES (6, 2, '2', 2, 'schachis power pc', 'nicht mehr intern, mehr components und items', '0', '0', '', '', '', '', 0, 31, 1149088829); INSERT INTO `product` VALUES (7, 2, '3', 2, 'schachis power pc', 'alle components und items entfernt, repair', '0', '1', '', '', '', '', 0, 1, 1149088878); INSERT INTO `product` VALUES (8, 2, '4', 2, 'schachis power pc', 'components und items wieder hinzugef? verkauft', '0', '0', '', '', '', '', 1, 1, 1149088972); INSERT INTO `product` VALUES (9, 2, '5', 2, 'schachis power pc', 'components und items wieder hinzugef? verkauft', '0', '0', '', '', '', '', 1, 1, 1149090681); INSERT INTO `product` VALUES (10, 2, '6', 2, 'schachis power pc', 'components und items wieder hinzugef? verkauft', '0', '0', '', '', '', '', 1, 1, 1149090692); INSERT INTO `product` VALUES (11, 2, '7', 2, 'schachis power pc', 'components und items wieder hinzugef? verkauft', '0', '0', '', '', '', '', 1, 1, 1149090793); INSERT INTO `product` VALUES (12, 2, '8', 2, 'schachis power pc', 'components und items wieder hinzugef? verkauft', '0', '0', '', '', '', '', 1, 1, 1149090919); INSERT INTO `product` VALUES (13, 2, '9', 2, 'schachis power pc', 'components und items wieder hinzugef? verkauft', '0', '0', '', '', '', '', 1, 1, 1149091208); INSERT INTO `product` VALUES (14, 2, '10', 2, 'schachis power pc', 'components und items wieder hinzugef? verkauft', '0', '0', '', '', '', '', 1, 1, 1149091708); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `product_component` -- CREATE TABLE `product_component` ( `id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL default '0', `component_id` int(11) NOT NULL default '0', `creation_date` int(11) NOT NULL default '0', `alteration_date` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `product_component_FI_1` (`product_id`), KEY `product_component_FI_2` (`component_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Daten für Tabelle `product_component` -- INSERT INTO `product_component` VALUES (1, 12, 1, 1149090920, 1149090920); INSERT INTO `product_component` VALUES (2, 12, 2, 1149090920, 1149090920); INSERT INTO `product_component` VALUES (3, 13, 1, 1149091209, 1149091209); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `product_depot` -- CREATE TABLE `product_depot` ( `id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL default '0', `depot_id` int(11) NOT NULL default '0', `stock` int(11) NOT NULL default '0', `creation_date` int(11) NOT NULL default '0', `alteration_date` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `product_depot_FI_1` (`product_id`), KEY `product_depot_FI_2` (`depot_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ; -- -- Daten für Tabelle `product_depot` -- INSERT INTO `product_depot` VALUES (1, 5, 7, 1, 1149088743, 1149088743); INSERT INTO `product_depot` VALUES (2, 6, 7, 1, 1149088831, 1149088831); INSERT INTO `product_depot` VALUES (3, 6, 9, 1, 1149088831, 1149088831); INSERT INTO `product_depot` VALUES (4, 6, 8, 1, 1149088832, 1149088832); INSERT INTO `product_depot` VALUES (5, 7, 7, 0, 1149088879, 1149088879); INSERT INTO `product_depot` VALUES (6, 7, 9, 0, 1149088879, 1149088879); INSERT INTO `product_depot` VALUES (7, 7, 8, 0, 1149088879, 1149088879); INSERT INTO `product_depot` VALUES (8, 8, 7, 1, 1149088973, 1149088973); INSERT INTO `product_depot` VALUES (9, 8, 9, 1, 1149088973, 1149088973); INSERT INTO `product_depot` VALUES (10, 8, 8, 1, 1149088973, 1149088973); INSERT INTO `product_depot` VALUES (11, 8, 11, 1, 1149088973, 1149088973); INSERT INTO `product_depot` VALUES (12, 8, 10, 1, 1149088973, 1149088973); INSERT INTO `product_depot` VALUES (13, 8, 6, 4, 1149088973, 1149088973); INSERT INTO `product_depot` VALUES (14, 10, 7, 1, 1149090694, 1149090694); INSERT INTO `product_depot` VALUES (15, 11, 7, 1, 1149090794, 1149090794); INSERT INTO `product_depot` VALUES (16, 11, 9, 1, 1149090794, 1149090794); INSERT INTO `product_depot` VALUES (17, 11, 8, 1, 1149090794, 1149090794); INSERT INTO `product_depot` VALUES (18, 11, 11, 1, 1149090794, 1149090794); INSERT INTO `product_depot` VALUES (19, 11, 10, 1, 1149090794, 1149090794); INSERT INTO `product_depot` VALUES (20, 11, 6, 4, 1149090795, 1149090795); INSERT INTO `product_depot` VALUES (21, 12, 7, 1, 1149090920, 1149090920); INSERT INTO `product_depot` VALUES (22, 12, 9, 1, 1149090920, 1149090920); INSERT INTO `product_depot` VALUES (23, 12, 8, 1, 1149090920, 1149090920); INSERT INTO `product_depot` VALUES (24, 12, 11, 1, 1149090920, 1149090920); INSERT INTO `product_depot` VALUES (25, 12, 10, 1, 1149090920, 1149090920); INSERT INTO `product_depot` VALUES (26, 12, 6, 4, 1149090920, 1149090920); INSERT INTO `product_depot` VALUES (27, 13, 7, 1, 1149091209, 1149091209); INSERT INTO `product_depot` VALUES (28, 13, 9, 1, 1149091209, 1149091209); INSERT INTO `product_depot` VALUES (29, 13, 8, 1, 1149091209, 1149091209); INSERT INTO `product_depot` VALUES (30, 13, 11, 1, 1149091209, 1149091209); INSERT INTO `product_depot` VALUES (31, 13, 10, 1, 1149091209, 1149091209); INSERT INTO `product_depot` VALUES (32, 13, 6, 4, 1149091209, 1149091209); INSERT INTO `product_depot` VALUES (33, 14, 7, 1, 1149091709, 1149091709); INSERT INTO `product_depot` VALUES (34, 14, 9, 1, 1149091709, 1149091709); INSERT INTO `product_depot` VALUES (35, 14, 8, 1, 1149091709, 1149091709); INSERT INTO `product_depot` VALUES (36, 14, 11, 1, 1149091709, 1149091709); INSERT INTO `product_depot` VALUES (37, 14, 10, 1, 1149091709, 1149091709); INSERT INTO `product_depot` VALUES (38, 14, 6, 4, 1149091709, 1149091709); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `producttype` -- CREATE TABLE `producttype` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `description` tinytext NOT NULL, `creation_date` int(11) NOT NULL default '0', `alteration_date` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Daten für Tabelle `producttype` -- INSERT INTO `producttype` VALUES (1, 'Busdoctor', 'Busdoctor Automotive', 1148925790, 1148925790); INSERT INTO `producttype` VALUES (2, 'NodePC', '', 1148925804, 1148925804);