gistfile1.sql

CREATE TABLE `bestellungen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kunden_id` int(11) NOT NULL,
  `bestellnummer` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `kunden_id` (`kunden_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

CREATE TABLE `kunden` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vorname` varchar(255) NOT NULL,
  `nachname` varchar(255) NOT NULL,
  `email` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

ALTER TABLE `bestellungen`
  ADD CONSTRAINT `bestellungen_ibfk_1` FOREIGN KEY (`kunden_id`) REFERENCES `kunden` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;