CREATE TABLE IF NOT EXISTS `kunden` (
  `Kunden_ID` int(11) NOT NULL auto_increment,
  `Kunden_Name` varchar(255) NOT NULL,
  `Kunden_Vorname` varchar(255) NOT NULL,
  `Kunden_Status_ID` int(11) NOT NULL,
  `Kunden_Eingetragen` datetime NOT NULL,
  PRIMARY KEY  (`Kunden_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `kunden_status` (
  `Kunden_Status_ID` int(11) NOT NULL auto_increment,
  `Kunden_Status_Name` varchar(255) NOT NULL,
  PRIMARY KEY  (`Kunden_Status_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;


CREATE TABLE IF NOT EXISTS `artikel` (
  `Artikel_ID` int(11) NOT NULL auto_increment,
  `Artikel_Name` varchar(255) NOT NULL,
  `Artikel_Kosten` decimal(11,2) NOT NULL,
  `Artikel_Eingetragen` datetime NOT NULL,
  PRIMARY KEY  (`Artikel_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `artikel_lager_bestand` (
  `Artikel_ID` int(11) NOT NULL,
  `Lager_ID` int(11) NOT NULL,
  `Artikel_Lager_Bestand` int(11) NOT NULL,
  `Artikel_Lager_Bestand_Akualisiert` datetime NOT NULL,
  PRIMARY KEY  (`Artikel_ID`,`Lager_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;


CREATE TABLE IF NOT EXISTS `lager` (
  `Lager_ID` int(11) NOT NULL auto_increment,
  `Lager_Name` varchar(255) NOT NULL,
  `Lager_Max_Bestand` int(11) NOT NULL,
  `Lager_Eingetragen` datetime NOT NULL,
  PRIMARY KEY  (`Lager_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;


CREATE TABLE IF NOT EXISTS `bestellung` (
  `Bestellung_ID` int(11) NOT NULL auto_increment,
  `Kunden_ID` int(11) NOT NULL,
  `Artikel_ID` int(11) NOT NULL,
  `Bestellung_Eingetragen` datetime NOT NULL,
  PRIMARY KEY  (`Bestellung_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;