· 8 years ago · Apr 09, 2018, 06:54 PM
1-- MySQL dump 10.13 Distrib 5.5.9, for Win32 (x86)
2--
3-- Host: localhost Database: tennis
4-- ------------------------------------------------------
5-- Server version 5.5.15
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Current Database: `tennis`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `tennis` /*!40100 DEFAULT CHARACTER SET utf8 */;
23
24USE `tennis`;
25
26--
27-- Table structure for table `bestuursleden`
28--
29
30DROP TABLE IF EXISTS `bestuursleden`;
31/*!40101 SET @saved_cs_client = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `bestuursleden` (
34 `SPELERSNR` int(11) NOT NULL,
35 `BEGIN_DATUM` date NOT NULL,
36 `EIND_DATUM` date DEFAULT NULL,
37 `FUNCTIE` char(20) DEFAULT NULL,
38 PRIMARY KEY (`SPELERSNR`,`BEGIN_DATUM`),
39 CONSTRAINT `bestuursleden_ibfk_1` FOREIGN KEY (`SPELERSNR`) REFERENCES `spelers` (`SPELERSNR`)
40) ENGINE=InnoDB DEFAULT CHARSET=utf8;
41/*!40101 SET character_set_client = @saved_cs_client */;
42
43--
44-- Dumping data for table `bestuursleden`
45--
46
47LOCK TABLES `bestuursleden` WRITE;
48/*!40000 ALTER TABLE `bestuursleden` DISABLE KEYS */;
49INSERT INTO `bestuursleden` VALUES (2,'1990-01-01','1992-12-31','Voorzitter'),(2,'1994-01-01',NULL,'Lid'),(6,'1990-01-01','1990-12-31','Secretaris'),(6,'1991-01-01','1992-12-31','Lid'),(6,'1992-01-01','1993-12-31','Penningmeester'),(6,'1993-01-01',NULL,'Voorzitter'),(8,'1990-01-01','1990-12-31','Penningmeester'),(8,'1991-01-01','1991-12-31','Secretaris'),(8,'1993-01-01','1993-12-31','Lid'),(8,'1994-01-01',NULL,'Lid'),(27,'1990-01-01','1990-12-31','Lid'),(27,'1991-01-01','1991-12-31','Penningmeester'),(27,'1993-01-01','1993-12-31','Penningmeester'),(57,'1992-01-01','1992-12-31','Secretaris'),(95,'1994-01-01',NULL,'Penningmeester'),(112,'1992-01-01','1992-12-31','Lid'),(112,'1994-01-01',NULL,'Secretaris');
50/*!40000 ALTER TABLE `bestuursleden` ENABLE KEYS */;
51UNLOCK TABLES;
52
53--
54-- Table structure for table `boetes`
55--
56
57DROP TABLE IF EXISTS `boetes`;
58/*!40101 SET @saved_cs_client = @@character_set_client */;
59/*!40101 SET character_set_client = utf8 */;
60CREATE TABLE `boetes` (
61 `BETALINGSNR` int(11) NOT NULL,
62 `SPELERSNR` int(11) NOT NULL,
63 `DATUM` date NOT NULL,
64 `BEDRAG` decimal(7,2) NOT NULL,
65 PRIMARY KEY (`BETALINGSNR`),
66 KEY `SPELERSNR` (`SPELERSNR`),
67 CONSTRAINT `boetes_ibfk_1` FOREIGN KEY (`SPELERSNR`) REFERENCES `spelers` (`SPELERSNR`)
68) ENGINE=InnoDB DEFAULT CHARSET=utf8;
69/*!40101 SET character_set_client = @saved_cs_client */;
70
71--
72-- Dumping data for table `boetes`
73--
74
75LOCK TABLES `boetes` WRITE;
76/*!40000 ALTER TABLE `boetes` DISABLE KEYS */;
77INSERT INTO `boetes` VALUES (1,6,'1980-12-08',100.00),(2,44,'1981-05-05',75.00),(3,27,'1983-09-10',100.00),(4,104,'1984-12-08',50.00),(5,44,'1980-12-08',25.00),(6,8,'1980-12-08',25.00),(7,44,'1982-12-30',30.00),(8,27,'1984-11-12',75.00);
78/*!40000 ALTER TABLE `boetes` ENABLE KEYS */;
79UNLOCK TABLES;
80
81--
82-- Table structure for table `spelers`
83--
84
85DROP TABLE IF EXISTS `spelers`;
86/*!40101 SET @saved_cs_client = @@character_set_client */;
87/*!40101 SET character_set_client = utf8 */;
88CREATE TABLE `spelers` (
89 `SPELERSNR` int(11) NOT NULL,
90 `NAAM` char(15) NOT NULL,
91 `VOORLETTERS` char(3) NOT NULL,
92 `GEB_DATUM` date DEFAULT NULL,
93 `GESLACHT` char(1) NOT NULL,
94 `JAARTOE` smallint(6) NOT NULL,
95 `STRAAT` varchar(30) NOT NULL,
96 `HUISNR` char(4) DEFAULT NULL,
97 `POSTCODE` char(6) DEFAULT NULL,
98 `PLAATS` varchar(30) NOT NULL,
99 `TELEFOON` char(13) DEFAULT NULL,
100 `BONDSNR` char(4) DEFAULT NULL,
101 PRIMARY KEY (`SPELERSNR`)
102) ENGINE=InnoDB DEFAULT CHARSET=utf8;
103/*!40101 SET character_set_client = @saved_cs_client */;
104
105--
106-- Dumping data for table `spelers`
107--
108
109LOCK TABLES `spelers` WRITE;
110/*!40000 ALTER TABLE `spelers` DISABLE KEYS */;
111INSERT INTO `spelers` VALUES (2,'Elfring','R','1948-09-01','M',1975,'Steden','43','3575NH','Den Haag','070-237893','2411'),(6,'Permentier','R','1964-06-25','M',1977,'Hazensteinln','80','1234KK','Den Haag','070-476537','8467'),(7,'Wijers','GWS','1963-05-11','M',1981,'Erasmusweg','39','9758VB','Den Haag','070-347689',NULL),(8,'Niewenburg','B','1962-07-08','V',1980,'Spoorlaan','4','6584WO','Rijswijk','070-458458','2983'),(27,'Cools','DD','1964-12-28','V',1983,'Liespad','804','8457DK','Zoetermeer','079-234857','2513'),(28,'Cools','C','1963-06-22','V',1983,'Oudegracht','10','1294QK','Leiden','010-659599',NULL),(39,'Bischoff','D','1956-10-29','M',1980,'Ericaplein','78','9629CD','Den Haag','070-393435',NULL),(44,'Bakker, de','E','1963-01-09','M',1980,'Lawaaistraat','23','4444LJ','Rijswijk','070-368753','1124'),(57,'Bohemen, van','M','1971-08-17','M',1985,'Erasmusweg','16','4377CB','Den Haag','070-473458','6409'),(83,'Hofland','PK','1956-11-11','M',1982,'Mariakade','16a','1812UP','Den Haag','070-353548','1608'),(95,'Meuleman','P','1963-05-14','M',1972,'Hoofdweg','33a','5746OP','Voorburg','070-867564',NULL),(100,'Permentier','P','1963-02-28','M',1979,'Hazensteinln','80','6494SG','Den Haag','070-494593','6524'),(104,'Moerman','D','1970-05-10','V',1984,'Stoutlaan','65','9437AO','Zoetermeer','079-987571','7060'),(112,'Baalen, van','IP','1963-10-01','V',1984,'Vosseweg','8','6392LK','Rotterdam','010-548745','1319');
112/*!40000 ALTER TABLE `spelers` ENABLE KEYS */;
113UNLOCK TABLES;
114
115--
116-- Table structure for table `teams`
117--
118
119DROP TABLE IF EXISTS `teams`;
120/*!40101 SET @saved_cs_client = @@character_set_client */;
121/*!40101 SET character_set_client = utf8 */;
122CREATE TABLE `teams` (
123 `TEAMNR` int(11) NOT NULL,
124 `SPELERSNR` int(11) NOT NULL,
125 `DIVISIE` char(6) NOT NULL,
126 PRIMARY KEY (`TEAMNR`),
127 KEY `SPELERSNR` (`SPELERSNR`),
128 CONSTRAINT `teams_ibfk_1` FOREIGN KEY (`SPELERSNR`) REFERENCES `spelers` (`SPELERSNR`)
129) ENGINE=InnoDB DEFAULT CHARSET=utf8;
130/*!40101 SET character_set_client = @saved_cs_client */;
131
132--
133-- Dumping data for table `teams`
134--
135
136LOCK TABLES `teams` WRITE;
137/*!40000 ALTER TABLE `teams` DISABLE KEYS */;
138INSERT INTO `teams` VALUES (1,6,'ere'),(2,27,'tweede');
139/*!40000 ALTER TABLE `teams` ENABLE KEYS */;
140UNLOCK TABLES;
141
142--
143-- Table structure for table `wedstrijden`
144--
145
146DROP TABLE IF EXISTS `wedstrijden`;
147/*!40101 SET @saved_cs_client = @@character_set_client */;
148/*!40101 SET character_set_client = utf8 */;
149CREATE TABLE `wedstrijden` (
150 `WEDSTRIJDNR` int(11) NOT NULL,
151 `TEAMNR` int(11) NOT NULL,
152 `SPELERSNR` int(11) NOT NULL,
153 `GEWONNEN` smallint(6) NOT NULL,
154 `VERLOREN` smallint(6) NOT NULL,
155 PRIMARY KEY (`WEDSTRIJDNR`),
156 KEY `TEAMNR` (`TEAMNR`),
157 KEY `SPELERSNR` (`SPELERSNR`),
158 CONSTRAINT `wedstrijden_ibfk_1` FOREIGN KEY (`TEAMNR`) REFERENCES `teams` (`TEAMNR`),
159 CONSTRAINT `wedstrijden_ibfk_2` FOREIGN KEY (`SPELERSNR`) REFERENCES `spelers` (`SPELERSNR`)
160) ENGINE=InnoDB DEFAULT CHARSET=utf8;
161/*!40101 SET character_set_client = @saved_cs_client */;
162
163--
164-- Dumping data for table `wedstrijden`
165--
166
167LOCK TABLES `wedstrijden` WRITE;
168/*!40000 ALTER TABLE `wedstrijden` DISABLE KEYS */;
169INSERT INTO `wedstrijden` VALUES (1,1,6,3,1),(2,1,6,2,3),(3,1,6,3,0),(4,1,44,3,2),(5,1,83,0,3),(6,1,2,1,3),(7,1,57,3,0),(8,1,8,0,3),(9,2,27,3,2),(10,2,104,3,2),(11,2,112,2,3),(12,2,112,1,3),(13,2,8,0,3);
170/*!40000 ALTER TABLE `wedstrijden` ENABLE KEYS */;
171UNLOCK TABLES;
172/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
173
174/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
175/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
176/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
177/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
178/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
179/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
180/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
181
182-- Dump completed on 2011-11-23 10:29:18