zHrKL72z

1
2-- MySQL dump 10.13  Distrib 5.5.19, for Win32 (x86)
3--
4-- Host: localhost    Database: bibliothek
5-- ------------------------------------------------------
6-- Server version   5.5.19
7 
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
10/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
11/*!40101 SET NAMES utf8 */;
12/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
13/*!40103 SET TIME_ZONE='+00:00' */;
14/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
15/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
16/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
17/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
18 
19create database if not exists Bibliothek;
20use Bibliothek;
21--
22-- Table structure for table t_buecher
23--
24 
25DROP TABLE IF EXISTS t_buecher;
26/*!40101 SET @saved_cs_client     = @@character_set_client */;
27/*!40101 SET character_set_client = utf8 */;
28CREATE TABLE t_buecher (
29  isbn varchar(13) NOT NULL DEFAULT '',
30  titel varchar(100) DEFAULT NULL,
31  autor varchar(100) DEFAULT NULL,
32  auflage int(11) DEFAULT NULL,
33  preis float DEFAULT NULL,
34  PRIMARY KEY (isbn),
35  KEY i_autor (autor),
36  KEY i_titel (titel)
37) ENGINE=InnoDB DEFAULT CHARSET=utf8;
38/*!40101 SET character_set_client = @saved_cs_client */;
39 
40--
41-- Dumping data for table t_buecher
42--
43 
44LOCK TABLES t_buecher WRITE;
45/*!40000 ALTER TABLE t_buecher DISABLE KEYS */;
46INSERT INTO t_buecher VALUES ('1-234-56789-0','Der Baum','Gerd Baumann',1,29.95),('1-254-56649-0','Mein Gartenbuch','Bernd Blume',2,19.95),('1-285-54709-0','Fit for Fun','Brigitte Schoene',3,21.55);
47/*!40000 ALTER TABLE t_buecher ENABLE KEYS */;
48UNLOCK TABLES;
49 
50--
51-- Table structure for table t_leser
52--
53 
54DROP TABLE IF EXISTS t_leser;
55/*!40101 SET @saved_cs_client     = @@character_set_client */;
56/*!40101 SET character_set_client = utf8 */;
57CREATE TABLE t_leser (
58  nr int(11) NOT NULL AUTO_INCREMENT,
59  name varchar(30) DEFAULT NULL,
60  vname varchar(30) DEFAULT NULL,
61  plz varchar(5) DEFAULT NULL,
62  ort varchar(100) DEFAULT NULL,
63  str varchar(100) DEFAULT NULL,
64  hnr varchar(5) DEFAULT NULL,
65  PRIMARY KEY (nr),
66  KEY i_leser_ab (name)
67) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
68/*!40101 SET character_set_client = @saved_cs_client */;
69 
70--
71-- Dumping data for table t_leser
72--
73 
74LOCK TABLES t_leser WRITE;
75/*!40000 ALTER TABLE t_leser DISABLE KEYS */;
76INSERT INTO t_leser VALUES (1,'Husler','Bernd','02749','Hainig','Waldweg','4'),(2,'Kramer','Birgit','02749','Hainig','Steinstr.','44');
77/*!40000 ALTER TABLE t_leser ENABLE KEYS */;
78UNLOCK TABLES;
79 
80--
81-- Table structure for table t_mess
82--
83 
84DROP TABLE IF EXISTS t_mess;
85/*!40101 SET @saved_cs_client     = @@character_set_client */;
86/*!40101 SET character_set_client = utf8 */;
87CREATE TABLE t_mess (
88  nr int(11) NOT NULL AUTO_INCREMENT,
89  wert int(11) DEFAULT NULL,
90  PRIMARY KEY (nr)
91) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
92/*!40101 SET character_set_client = @saved_cs_client */;
93 
94--
95-- Dumping data for table t_mess
96--
97 
98LOCK TABLES t_mess WRITE;
99/*!40000 ALTER TABLE t_mess DISABLE KEYS */;
100INSERT INTO t_mess VALUES (1,617),(2,852),(3,406),(4,474),(5,151),(6,333),(7,211),(8,57),(9,647),(10,67),(11,389),(12,746);
101/*!40000 ALTER TABLE t_mess ENABLE KEYS */;
102UNLOCK TABLES;
103 
104--
105-- Table structure for table t_verleih
106--
107 
108DROP TABLE IF EXISTS t_verleih;
109/*!40101 SET @saved_cs_client     = @@character_set_client */;
110/*!40101 SET character_set_client = utf8 */;
111CREATE TABLE t_verleih (
112  isbn varchar(13) NOT NULL DEFAULT '',
113  leser int(11) NOT NULL DEFAULT '0',
114  datum date DEFAULT NULL,
115  KEY i_ausleihe (isbn,leser),
116  KEY i_verleih (isbn,leser)
117) ENGINE=InnoDB DEFAULT CHARSET=utf8;
118/*!40101 SET character_set_client = @saved_cs_client */;
119 
120--
121-- Dumping data for table t_verleih
122--
123 
124LOCK TABLES t_verleih WRITE;
125/*!40000 ALTER TABLE t_verleih DISABLE KEYS */;
126INSERT INTO t_verleih VALUES ('1-254-56649-0',1,'2011-10-27'),('1-234-56789-0',1,'2011-11-25'),('1-285-54709-0',2,'2011-11-25'),('1-285-54709-0',3,'2011-11-29');
127/*!40000 ALTER TABLE t_verleih ENABLE KEYS */;
128UNLOCK TABLES;
129/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
130 
131/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
132/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
133/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
134/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
135/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
136/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
137/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
138 
139-- Dump completed on 2012-03-06 14:55:55