rendered paste body-- 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);