F4HQYTJM

11
22
33
44
55
66
77
88
99
1010
1111
1212
1313
1414
1515
1616
1717
1818
1919
2020
2121
2222
2323
2424
2525
2626
2727
2828
2929
3030
3131
3232
3333
3434
3535
3636
3737
3838
3939
4040
4141
4242
4343
4444
4545
4646
4747
4848
4949
5050
5151
5252
5353
5454
5555
5656
5757
5858
5959
6060
6161
6262
6363
6464
6565
6666
6767
6868
6969
7070
7171
7272
7373
7474
7575
7676
7777
7878
7979
8080
8181
8282
8383
8484
8585
8686
8787
8888
8989
9090
9191
9292
9393
9494
9595
9696
9797
9898
9999
100100
101101
102102
103103
104104
105105
106106
107107
108108
109109
110110
111111
112112
113113
114114
115115
116116
117117
118118
119119
120120
121121
122122
123123
124124
125125
126126
127127
128128
129129
130130
131131
132132
133133
134134
135135
136136
137137
138138
139-- MySQL dump 10.13  Distrib 5.5.19, for Win32 (x86)
140--
141-- Host: localhost    Database: bibliothek
142-- ------------------------------------------------------
143-- Server version   5.5.19
144 
145/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
146/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
147/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
148/*!40101 SET NAMES utf8 */;
149/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
150/*!40103 SET TIME_ZONE='+00:00' */;
151/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
152/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
153/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
154/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
155 
156create database if not exists Bibliothek;
157use Bibliothek;
158--
159-- Table structure for table t_buecher
160--
161 
162DROP TABLE IF EXISTS t_buecher;
163/*!40101 SET @saved_cs_client     = @@character_set_client */;
164/*!40101 SET character_set_client = utf8 */;
165CREATE TABLE t_buecher (
166  isbn varchar(13) NOT NULL DEFAULT '',
167  titel varchar(100) DEFAULT NULL,
168  autor varchar(100) DEFAULT NULL,
169  auflage int(11) DEFAULT NULL,
170  preis float DEFAULT NULL,
171  PRIMARY KEY (isbn),
172  KEY i_autor (autor),
173  KEY i_titel (titel)
174) ENGINE=InnoDB DEFAULT CHARSET=utf8;
175/*!40101 SET character_set_client = @saved_cs_client */;
176 
177--
178-- Dumping data for table t_buecher
179--
180 
181LOCK TABLES t_buecher WRITE;
182/*!40000 ALTER TABLE t_buecher DISABLE KEYS */;
183INSERT 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);
184/*!40000 ALTER TABLE t_buecher ENABLE KEYS */;
185UNLOCK TABLES;
186 
187--
188-- Table structure for table t_leser
189--
190 
191DROP TABLE IF EXISTS t_leser;
192/*!40101 SET @saved_cs_client     = @@character_set_client */;
193/*!40101 SET character_set_client = utf8 */;
194CREATE TABLE t_leser (
195  nr int(11) NOT NULL AUTO_INCREMENT,
196  name varchar(30) DEFAULT NULL,
197  vname varchar(30) DEFAULT NULL,
198  plz varchar(5) DEFAULT NULL,
199  ort varchar(100) DEFAULT NULL,
200  str varchar(100) DEFAULT NULL,
201  hnr varchar(5) DEFAULT NULL,
202  PRIMARY KEY (nr),
203  KEY i_leser_ab (name)
204) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
205/*!40101 SET character_set_client = @saved_cs_client */;
206 
207--
208-- Dumping data for table t_leser
209--
210 
211LOCK TABLES t_leser WRITE;
212/*!40000 ALTER TABLE t_leser DISABLE KEYS */;
213INSERT INTO t_leser VALUES (1,'Husler','Bernd','02749','Hainig','Waldweg','4'),(2,'Kramer','Birgit','02749','Hainig','Steinstr.','44');
214/*!40000 ALTER TABLE t_leser ENABLE KEYS */;
215UNLOCK TABLES;
216 
217--
218-- Table structure for table t_mess
219--
220 
221DROP TABLE IF EXISTS t_mess;
222/*!40101 SET @saved_cs_client     = @@character_set_client */;
223/*!40101 SET character_set_client = utf8 */;
224CREATE TABLE t_mess (
225  nr int(11) NOT NULL AUTO_INCREMENT,
226  wert int(11) DEFAULT NULL,
227  PRIMARY KEY (nr)
228) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
229/*!40101 SET character_set_client = @saved_cs_client */;
230 
231--
232-- Dumping data for table t_mess
233--
234 
235LOCK TABLES t_mess WRITE;
236/*!40000 ALTER TABLE t_mess DISABLE KEYS */;
237INSERT 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);
238/*!40000 ALTER TABLE t_mess ENABLE KEYS */;
239UNLOCK TABLES;
240 
241--
242-- Table structure for table t_verleih
243--
244 
245DROP TABLE IF EXISTS t_verleih;
246/*!40101 SET @saved_cs_client     = @@character_set_client */;
247/*!40101 SET character_set_client = utf8 */;
248CREATE TABLE t_verleih (
249  isbn varchar(13) NOT NULL DEFAULT '',
250  leser int(11) NOT NULL DEFAULT '0',
251  datum date DEFAULT NULL,
252  KEY i_ausleihe (isbn,leser),
253  KEY i_verleih (isbn,leser)
254) ENGINE=InnoDB DEFAULT CHARSET=utf8;
255/*!40101 SET character_set_client = @saved_cs_client */;
256 
257--
258-- Dumping data for table t_verleih
259--
260 
261LOCK TABLES t_verleih WRITE;
262/*!40000 ALTER TABLE t_verleih DISABLE KEYS */;
263INSERT 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');
264/*!40000 ALTER TABLE t_verleih ENABLE KEYS */;
265UNLOCK TABLES;
266/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
267 
268/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
269/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
270/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
271/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
272/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
273/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
274/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
275 
276-- Dump completed on 2012-03-06 14:55:55