-- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Erstellungszeit: 17. Dez 2013 um 22:07
-- Server Version: 5.5.27
-- PHP-Version: 5.4.7

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Datenbank: `ikaonlineshop`
--

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

--
-- Tabellenstruktur für Tabelle `kunden`
--

CREATE TABLE IF NOT EXISTS `kunden` (
  `KundenNr` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) COLLATE latin1_german2_ci NOT NULL,
  `PLZ` int(11) DEFAULT NULL,
  `Ort` varchar(255) COLLATE latin1_german2_ci NOT NULL,
  `Strasse` varchar(255) COLLATE latin1_german2_ci NOT NULL,
  `Geburtsdatum` datetime DEFAULT NULL,
  `Mailkontakt` varchar(255) COLLATE latin1_german2_ci NOT NULL,
  PRIMARY KEY (`KundenNr`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=15 ;

--
-- Daten für Tabelle `kunden`
--

INSERT INTO `kunden` (`KundenNr`, `Name`, `PLZ`, `Ort`, `Strasse`, `Geburtsdatum`, `Mailkontakt`) VALUES
(1, 'Max Mustermann', 88045, 'Friedrichshafen', 'Seestraße 5', '1995-05-02 00:00:00', 'max@mustermann.mm'),
(2, 'Peter Pan', 88682, 'Salem', 'Mühlenweg 12', '1996-06-06 00:00:00', 'peter@pan.de'),
(3, 'Petra Panne', 88131, 'Lindau', 'Am Hafen 14', '1989-05-23 00:00:00', 'petra@panne.com'),
(4, 'Lieschen Müller', 88682, 'Salem', 'Mühlenstra?e 3', '1949-06-06 00:00:00', 'lm23@gmx.de'),
(5, 'Klaus Habenichts', 88045, 'Friedrichshafen', 'Seeblick 12', '1995-11-18 00:00:00', 'klaus@fn-online.de'),
(6, 'Hans von Glück', 88046, 'Friedrichshafen', 'Hafenstraße 3', '1986-09-12 00:00:00', 'hans@vonglueck.info'),
(7, 'Luke Skywalker', 55555, 'Eisplanet Hoth', 'In der kalten Höhle 4', '1980-01-01 00:00:00', 'luke@skywalker.com'),
(8, 'Obi-Wan Kenobi', 53210, 'Tatooine', 'Alte Hütte 23', '1920-03-02 00:00:00', 'obiwan@kenobi.zz'),
(9, 'Han Solo', 69012, 'Corellia', 'Shrike-Park 15', '1967-08-08 00:00:00', 'han.solo@millennium.falke'),
(10, 'Mensch Meier', 78462, 'Konstanz', 'Hafengasse 36', '1997-10-21 00:00:00', 'mensch@meier'),
(11, 'Nora Nürnberger', 90402, 'Nürnberg', 'An der Burg 27', NULL, 'wuerstle@hotmail.de'),
(12, 'Dagobert Duck', NULL, 'Entenhausen', 'Entengasse 7', '1930-07-03 00:00:00', 'dagobert.duck@disney.fun'),
(13, 'Daniel Düsentrieb', 90944, 'Entenhausen', 'Erfinderweg 11', '1940-02-14 00:00:00', 'duesentrieb@disney.fun'),
(14, 'Berta Glücklich', 88045, 'Friedrichshafen', 'Am alten Hafen 10', '1986-09-12 00:00:00', 'berta@gluecklich-online.de');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
