-- phpMyAdmin SQL Dump -- version 2.6.4-pl3 -- http://www.phpmyadmin.net -- -- Erstellungszeit: 02. April 2012 um 21:39 -- Server Version: 5.0.91 -- PHP-Version: 5.3.3-7+squeeze8 -- -- Datenbank: `db402772017` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `Kunden` -- CREATE TABLE `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 AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=15 ; -- -- Daten für Tabelle `Kunden` -- INSERT INTO `Kunden` VALUES (1, 'Max Mustermann', 88045, 'Friedrichshafen', 'Seestraße 5', '1995-05-02 00:00:00', 'max@mustermann.mm'); INSERT INTO `Kunden` VALUES (2, 'Peter Pan', 88682, 'Salem', 'Mühlenweg 12', '1996-06-06 00:00:00', 'peter@pan.de'); INSERT INTO `Kunden` VALUES (3, 'Petra Panne', 88131, 'Lindau', 'Am Hafen 14', '1989-05-23 00:00:00', 'petra@panne.com'); INSERT INTO `Kunden` VALUES (4, 'Lieschen Müller', 88682, 'Salem', 'Mühlenstraße 3', '1949-06-06 00:00:00', 'lm23@gmx.de'); INSERT INTO `Kunden` VALUES (5, 'Klaus Habenichts', 88045, 'Friedrichshafen', 'Seeblick 12', '1995-11-18 00:00:00', 'klaus@fn-online.de'); INSERT INTO `Kunden` VALUES (6, 'Hans von Glück', 88046, 'Friedrichshafen', 'Hafenstraße 3', '1986-09-12 00:00:00', 'hans@vonglueck.info'); INSERT INTO `Kunden` VALUES (7, 'Luke Skywalker', 55555, 'Eisplanet Hoth', 'In der kalten Höhle 4', '1980-01-01 00:00:00', 'luke@skywalker.com'); INSERT INTO `Kunden` VALUES (8, 'Obi-Wan Kenobi', 53210, 'Tatooine', 'Alte Hütte 23', '1920-03-02 00:00:00', 'obiwan@kenobi.zz'); INSERT INTO `Kunden` VALUES (9, 'Han Solo', 69012, 'Corellia', 'Shrike-Park 15', '1967-08-08 00:00:00', 'han.solo@millennium.falke'); INSERT INTO `Kunden` VALUES (10, 'Mensch Meier', 78462, 'Konstanz', 'Hafengasse 36', '1997-10-21 00:00:00', 'mensch@meier'); INSERT INTO `Kunden` VALUES (11, 'Nora Nürnberger', 90402, 'Nürnberg', 'An der Burg 27', NULL, 'wuerstle@hotmail.de'); INSERT INTO `Kunden` VALUES (12, 'Dagobert Duck', NULL, 'Entenhausen', 'Entengasse 7', '1930-07-03 00:00:00', 'dagobert.duck@disney.fun'); INSERT INTO `Kunden` VALUES (13, 'Daniel Düsentrieb', 90944, 'Entenhausen', 'Erfinderweg 11', '1940-02-14 00:00:00', 'duesentrieb@disney.fun'); INSERT INTO `Kunden` VALUES (14, 'Berta Glücklich', 88045, 'Friedrichshafen', 'Am alten Hafen 10', '1986-09-12 00:00:00', 'berta@gluecklich-online.de');