CT Pizzaservice MySQL-Dump (2)
2006-07-06 15:43:29

-- phpMyAdmin SQL Dump
-- version 2.8.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jul 06, 2006 at 03:42 PM
-- Server version: 5.0.21
-- PHP Version: 5.1.4
-- 
-- Database: `ct_datenbanken_test`
-- 

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

-- 
-- Table structure for table `artikel`
-- 

CREATE TABLE `artikel` (
  `ArtikelNr` smallint(5) unsigned NOT NULL auto_increment,
  `Bezeichnung` varchar(50) NOT NULL default '',
  `Preis` double NOT NULL default '0',
  PRIMARY KEY  (`ArtikelNr`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

-- 
-- Dumping data for table `artikel`
-- 

INSERT INTO `artikel` VALUES (1, 'Pizza 4 Käse', 5);
INSERT INTO `artikel` VALUES (2, 'Ber-Rune', 6);
INSERT INTO `artikel` VALUES (3, '4 Soxx Dusk Shroud', 0.2);
INSERT INTO `artikel` VALUES (4, 'Tacker', 1.49);
INSERT INTO `artikel` VALUES (5, 'Tackermunition', 10);
INSERT INTO `artikel` VALUES (6, 'Eth Ogeraxt', 2);
INSERT INTO `artikel` VALUES (7, 'Jah', 6);
INSERT INTO `artikel` VALUES (8, 'Ber', 6);
INSERT INTO `artikel` VALUES (9, 'Schönheitscreme', 100);
INSERT INTO `artikel` VALUES (10, 'Speziale', 6);
INSERT INTO `artikel` VALUES (11, 'Salat', 4.5);
INSERT INTO `artikel` VALUES (12, 'Pizza Schinken', 4);
INSERT INTO `artikel` VALUES (13, 'griechischer Salat', 5);
INSERT INTO `artikel` VALUES (14, 'Pizza Salami', 4);
INSERT INTO `artikel` VALUES (15, 'Spaghetti Bolognese', 4.5);

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

-- 
-- Table structure for table `kunde`
-- 

CREATE TABLE `kunde` (
  `KundenNr` smallint(5) unsigned NOT NULL auto_increment,
  `Vorname` varchar(25) NOT NULL default '',
  `Nachname` varchar(25) NOT NULL default '',
  `Strasse` varchar(40) default NULL,
  `PLZ` smallint(5) unsigned default NULL,
  `Ort` varchar(40) default NULL,
  PRIMARY KEY  (`KundenNr`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

-- 
-- Dumping data for table `kunde`
-- 

INSERT INTO `kunde` VALUES (1, 'Rofl', 'Mao', 'Heininger Weg 43', 65535, 'Backnang');
INSERT INTO `kunde` VALUES (2, 'Eric', 'Schneider', 'Teichstr. 6', 65535, 'Unterweissach');
INSERT INTO `kunde` VALUES (3, 'Thorsten', 'Tacker', 'Tackerweg 1', 65535, 'Tackerhausen');
INSERT INTO `kunde` VALUES (4, 'Sascha', 'Raichle', 'Hauptstrasse 64', 65535, 'Burgstetten');
INSERT INTO `kunde` VALUES (5, 'Jian', 'Wang', 'Hässlicher Weg 1', 65535, 'Backnang');
INSERT INTO `kunde` VALUES (6, 'Tobias', 'Typ', 'Bahnhofstr. 5', 65535, 'Backnang');
INSERT INTO `kunde` VALUES (7, 'Heike', 'Tohn', 'Im Hang 9', 65535, 'Sulzbach');
INSERT INTO `kunde` VALUES (8, 'Hans', 'Wurst', 'Reiterhofstr. 4', 65535, 'Leichhausen');
INSERT INTO `kunde` VALUES (9, 'Mariella', 'Tacherles', 'Luserstr. 77', 65535, 'Wohlfahrtshausen');
INSERT INTO `kunde` VALUES (10, 'Werner', 'Lamer', 'Eselsstr. 8', 65535, 'Randolfstadt');
INSERT INTO `kunde` VALUES (11, 'Pascal', 'Setam', 'Tusestr. 9', 65535, 'Mangelstadt');
INSERT INTO `kunde` VALUES (12, 'vor', 'nach', '', 12345, '');
INSERT INTO `kunde` VALUES (13, 'vor', 'nach', NULL, 12345, '');
INSERT INTO `kunde` VALUES (14, 'vor', 'nach', NULL, NULL, NULL);

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

-- 
-- Table structure for table `position`
-- 

CREATE TABLE `position` (
  `RechnungsNr` smallint(5) unsigned NOT NULL default '0',
  `ArtikelNr` smallint(5) unsigned NOT NULL default '0',
  `Menge` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`RechnungsNr`,`ArtikelNr`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `position`
-- 

INSERT INTO `position` VALUES (1, 1, 11);
INSERT INTO `position` VALUES (2, 2, 2);
INSERT INTO `position` VALUES (3, 3, 1);
INSERT INTO `position` VALUES (4, 4, 20);
INSERT INTO `position` VALUES (5, 5, 1000);
INSERT INTO `position` VALUES (6, 6, 1);
INSERT INTO `position` VALUES (6, 7, 1);
INSERT INTO `position` VALUES (6, 8, 1);
INSERT INTO `position` VALUES (7, 9, 20);
INSERT INTO `position` VALUES (8, 10, 1);
INSERT INTO `position` VALUES (9, 11, 2);
INSERT INTO `position` VALUES (10, 12, 2);
INSERT INTO `position` VALUES (11, 13, 1);
INSERT INTO `position` VALUES (12, 14, 4);
INSERT INTO `position` VALUES (13, 15, 3);
INSERT INTO `position` VALUES (14, 12, 2);

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

-- 
-- Table structure for table `rechnung`
-- 

CREATE TABLE `rechnung` (
  `RechnungsNr` smallint(5) unsigned NOT NULL auto_increment,
  `Datum` date default NULL,
  `KundenNr` smallint(5) unsigned default NULL,
  PRIMARY KEY  (`RechnungsNr`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

-- 
-- Dumping data for table `rechnung`
-- 

INSERT INTO `rechnung` VALUES (1, '2005-03-02', 1);
INSERT INTO `rechnung` VALUES (2, '2005-03-03', 2);
INSERT INTO `rechnung` VALUES (3, '2005-03-03', 2);
INSERT INTO `rechnung` VALUES (4, '2005-03-03', 2);
INSERT INTO `rechnung` VALUES (5, '2002-02-20', 3);
INSERT INTO `rechnung` VALUES (6, '2004-05-03', 4);
INSERT INTO `rechnung` VALUES (7, '2005-01-01', 5);
INSERT INTO `rechnung` VALUES (8, '2005-03-03', 6);
INSERT INTO `rechnung` VALUES (9, '2005-03-04', 7);
INSERT INTO `rechnung` VALUES (10, '2005-03-02', 8);
INSERT INTO `rechnung` VALUES (11, '2005-03-02', 9);
INSERT INTO `rechnung` VALUES (12, '2005-03-03', 10);
INSERT INTO `rechnung` VALUES (13, '2005-03-03', 11);
INSERT INTO `rechnung` VALUES (14, '2005-03-03', 9);