· 9 years ago · Aug 27, 2017, 02:16 PM
1CREATE DATABASE IF NOT EXISTS `DatingService` /*!40100 DEFAULT CHARACTER SET utf8 */;
2USE `DatingService`;
3-- MySQL dump 10.13 Distrib 5.7.9, for Win64 (x86_64)
4--
5-- Host: 173.194.104.191 Database: DatingService
6-- ------------------------------------------------------
7-- Server version 5.6.30
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `T_ATTRIBUTE`
22--
23
24DROP TABLE IF EXISTS `T_ATTRIBUTE`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `T_ATTRIBUTE` (
28 `Attribute_ID` int(2) NOT NULL,
29 `Explanation` varchar(100) NOT NULL,
30 PRIMARY KEY (`Attribute_ID`)
31) ENGINE=InnoDB DEFAULT CHARSET=utf8;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Dumping data for table `T_ATTRIBUTE`
36--
37
38LOCK TABLES `T_ATTRIBUTE` WRITE;
39/*!40000 ALTER TABLE `T_ATTRIBUTE` DISABLE KEYS */;
40INSERT INTO `T_ATTRIBUTE` VALUES (1,'Was machen Sie gerne in Ihrer Freizeit?'),(2,'Wenn ich ein Einhorn wäre, würde ich...'),(3,'In 10 Jahren möchten Sie wo stehen?'),(4,'Was ist Ihre Lieblingsband?'),(5,'Welche Sportarten interessieren Sie?'),(6,'Haben Sie ein Alkoholproblem?'),(7,'Welcher ist der beste Koch im deutschen Fernsehn?'),(8,'Ihre lieblings Fast-Food Kette ?'),(9,'Wo würden Sie gerne den nächsten Urlaub verbringen?'),(10,'Welches ist Ihr Lieblingstier?');
41/*!40000 ALTER TABLE `T_ATTRIBUTE` ENABLE KEYS */;
42UNLOCK TABLES;
43
44--
45-- Table structure for table `T_BLOCK`
46--
47
48DROP TABLE IF EXISTS `T_BLOCK`;
49/*!40101 SET @saved_cs_client = @@character_set_client */;
50/*!40101 SET character_set_client = utf8 */;
51CREATE TABLE `T_BLOCK` (
52 `Block_ID` int(11) NOT NULL,
53 `NoteDate` date NOT NULL,
54 `CommunicationBan_ID` int(6) NOT NULL,
55 `Oppression_ID` int(6) NOT NULL,
56 PRIMARY KEY (`Block_ID`),
57 KEY `CommunicationBan_ID` (`CommunicationBan_ID`),
58 KEY `Oppression_ID` (`Oppression_ID`),
59 CONSTRAINT `t_block_ibfk_1` FOREIGN KEY (`CommunicationBan_ID`) REFERENCES `T_USERPROFILE` (`Profile_ID`),
60 CONSTRAINT `t_block_ibfk_2` FOREIGN KEY (`Oppression_ID`) REFERENCES `T_USERPROFILE` (`Profile_ID`)
61) ENGINE=InnoDB DEFAULT CHARSET=utf8;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Dumping data for table `T_BLOCK`
66--
67
68LOCK TABLES `T_BLOCK` WRITE;
69/*!40000 ALTER TABLE `T_BLOCK` DISABLE KEYS */;
70INSERT INTO `T_BLOCK` VALUES (1,'2016-03-20',7,1),(2,'2016-03-18',8,1),(3,'2016-03-19',1,2),(4,'2016-03-17',3,2),(5,'2016-03-16',4,2),(6,'2016-03-15',6,2),(7,'2016-03-14',7,3),(8,'2016-03-13',3,4),(9,'2016-03-12',7,4),(10,'2016-03-11',1,6),(11,'2016-03-10',2,7),(12,'2016-06-19',3,45),(13,'2016-06-20',3,43),(14,'2016-06-20',28,43),(15,'2016-06-20',7,43);
71/*!40000 ALTER TABLE `T_BLOCK` ENABLE KEYS */;
72UNLOCK TABLES;
73
74--
75-- Table structure for table `T_CONFESSION`
76--
77
78DROP TABLE IF EXISTS `T_CONFESSION`;
79/*!40101 SET @saved_cs_client = @@character_set_client */;
80/*!40101 SET character_set_client = utf8 */;
81CREATE TABLE `T_CONFESSION` (
82 `Confession_ID` int(1) NOT NULL,
83 `Label` varchar(20) NOT NULL,
84 PRIMARY KEY (`Confession_ID`)
85) ENGINE=InnoDB DEFAULT CHARSET=utf8;
86/*!40101 SET character_set_client = @saved_cs_client */;
87
88--
89-- Dumping data for table `T_CONFESSION`
90--
91
92LOCK TABLES `T_CONFESSION` WRITE;
93/*!40000 ALTER TABLE `T_CONFESSION` DISABLE KEYS */;
94INSERT INTO `T_CONFESSION` VALUES (1,'römisch-katholisch'),(2,'evangelisch'),(3,'orthodoke'),(4,'Sunniten'),(5,'Shiiten'),(6,'keine Angabe');
95/*!40000 ALTER TABLE `T_CONFESSION` ENABLE KEYS */;
96UNLOCK TABLES;
97
98--
99-- Table structure for table `T_FREETEXT`
100--
101
102DROP TABLE IF EXISTS `T_FREETEXT`;
103/*!40101 SET @saved_cs_client = @@character_set_client */;
104/*!40101 SET character_set_client = utf8 */;
105CREATE TABLE `T_FREETEXT` (
106 `Attribute_ID` int(2) NOT NULL,
107 PRIMARY KEY (`Attribute_ID`),
108 CONSTRAINT `t_freetext_ibfk_1` FOREIGN KEY (`Attribute_ID`) REFERENCES `T_ATTRIBUTE` (`Attribute_ID`)
109) ENGINE=InnoDB DEFAULT CHARSET=utf8;
110/*!40101 SET character_set_client = @saved_cs_client */;
111
112--
113-- Dumping data for table `T_FREETEXT`
114--
115
116LOCK TABLES `T_FREETEXT` WRITE;
117/*!40000 ALTER TABLE `T_FREETEXT` DISABLE KEYS */;
118INSERT INTO `T_FREETEXT` VALUES (1),(2),(3),(4),(5);
119/*!40000 ALTER TABLE `T_FREETEXT` ENABLE KEYS */;
120UNLOCK TABLES;
121
122--
123-- Table structure for table `T_HAIRCOLOR`
124--
125
126DROP TABLE IF EXISTS `T_HAIRCOLOR`;
127/*!40101 SET @saved_cs_client = @@character_set_client */;
128/*!40101 SET character_set_client = utf8 */;
129CREATE TABLE `T_HAIRCOLOR` (
130 `Haircolor_ID` int(1) NOT NULL,
131 `Label` varchar(20) NOT NULL,
132 PRIMARY KEY (`Haircolor_ID`)
133) ENGINE=InnoDB DEFAULT CHARSET=utf8;
134/*!40101 SET character_set_client = @saved_cs_client */;
135
136--
137-- Dumping data for table `T_HAIRCOLOR`
138--
139
140LOCK TABLES `T_HAIRCOLOR` WRITE;
141/*!40000 ALTER TABLE `T_HAIRCOLOR` DISABLE KEYS */;
142INSERT INTO `T_HAIRCOLOR` VALUES (1,'blond'),(2,'braun'),(3,'rot'),(4,'Glatze');
143/*!40000 ALTER TABLE `T_HAIRCOLOR` ENABLE KEYS */;
144UNLOCK TABLES;
145
146--
147-- Table structure for table `T_INFO`
148--
149
150DROP TABLE IF EXISTS `T_INFO`;
151/*!40101 SET @saved_cs_client = @@character_set_client */;
152/*!40101 SET character_set_client = utf8 */;
153CREATE TABLE `T_INFO` (
154 `Info_ID` int(8) NOT NULL,
155 `Response` varchar(255) NOT NULL,
156 `Profile_ID` int(6) NOT NULL,
157 `Attribute_ID` int(2) NOT NULL,
158 PRIMARY KEY (`Info_ID`),
159 KEY `Profile_ID` (`Profile_ID`),
160 KEY `Attribute_ID` (`Attribute_ID`),
161 CONSTRAINT `t_info_ibfk_1` FOREIGN KEY (`Profile_ID`) REFERENCES `T_PROFILE` (`Profile_ID`),
162 CONSTRAINT `t_info_ibfk_2` FOREIGN KEY (`Attribute_ID`) REFERENCES `T_ATTRIBUTE` (`Attribute_ID`)
163) ENGINE=InnoDB DEFAULT CHARSET=utf8;
164/*!40101 SET character_set_client = @saved_cs_client */;
165
166--
167-- Dumping data for table `T_INFO`
168--
169
170LOCK TABLES `T_INFO` WRITE;
171/*!40000 ALTER TABLE `T_INFO` DISABLE KEYS */;
172INSERT INTO `T_INFO` VALUES (1,'Ich betrinke mich gerne alleine in meinem Keller',1,1),(2,'allen möglichen Leuten mit meinem Horn aufspießen',1,2),(3,'idealerweiße noch auf dem Boden',2,3),(4,'Metallica',2,4),(5,'Frauenwrestling',3,5),(6,'Wer das Bier nicht ehrt, ist des Deliriums nicht wert!',3,6),(7,'Gordon Ramsay',4,7),(8,'Burger King',4,8),(9,'Ich lese gerne Bücher',5,1),(10,'Regenbogenstrahlen aus meinen Arsch schießen',5,2),(11,'idealerweiße noch auf dem Boden',6,3),(12,'Metallica',6,4),(13,'Eishockey und Basketball',7,5),(14,'Optimismus ist: Aus einem Weizenkorn wird irgendwann ein Fass Bier!',7,6),(15,'Gordon Ramsay',8,7),(16,'Versuchen Java zu verstehen',9,1),(17,'Meine Magie nutzen, um die Welt zu verbessern',9,2),(18,'In Rente.',10,3),(19,'Wildecker Herzbuben',10,4),(20,'Kampftrinken',11,5),(21,'Wer das Bier nicht ehrt, ist des Deliriums nicht wert!',11,6),(22,'Gordon Ramsay',12,7),(23,'Burger King',12,8),(24,'Verzweifelt versuchen programmieren zu lernen',13,1),(25,'durch die Gegend springen',13,2),(26,'Beruflich am Höhepunkt',14,3),(27,'Metalica',14,4),(28,'Kampftrinken',15,5),(29,'Optimismus ist: Aus einem Weizenkorn wird irgendwann ein Fass Bier!',15,6),(30,'Gordon Ramsay',16,7),(31,'WoW, what else?',17,1),(32,'Ich mag DSDS',17,4),(33,'idealerweiße noch auf dem Boden',19,3),(34,'Brian Adams',19,4),(35,'Kampftrinken',20,5),(36,'Wer das Bier nicht ehrt, ist des Deliriums nicht wert!',20,6),(37,'Gordon Ramsay',21,7),(38,'Burger King',21,8),(39,'Mit ner Pulle Woddis am Bahnhof chillen mit meiner Crew',23,1),(40,'was für Einhorn?',23,2),(41,'möchte ich vom Bordstein zur Skyline aufgestiegen sein',23,3),(42,'Hauptsache Krach',22,4),(43,'Bogenschießen',23,5),(44,'Optimismus ist: Aus einem Weizenkorn wird irgendwann ein Fass Bier!',23,6),(45,'Gordon Ramsay',24,7),(46,'Für das Studium lernen',25,1),(47,'nichts tun, wie sonst auch immer',26,2),(48,'weiter vorne',26,3),(49,'Bushido',26,4),(50,'Fußball',27,5),(51,'Wer das Bier nicht ehrt, ist des Deliriums nicht wert!',27,6),(52,'Gordon Ramsay',28,7),(53,'Burger King',28,8),(54,'Essen =)',29,1),(55,'flieeeeeeeegen',29,2),(56,'in meinen neuen trendy Adidas',30,3),(57,'Aggro Berlin',30,4),(58,'Fussball',30,5),(59,'Optimismus ist: Aus einem Weizenkorn wird irgendwann ein Fass Bier!',31,6),(60,'Mit ner Pulle Woddis am Bahnhof chillen mit meiner Crew',32,1),(61,'was für Einhorn?',32,2),(62,'möchte ich vom Bordstein zur Skyline aufgestiegen sein',32,3),(92,'Chille',46,1),(94,'Volle',46,2),(97,'Xll',46,3),(99,'Cheef',46,4),(100,'Geh ',46,5),(101,'Wer das Bier nicht ehrt, ist des Deliriums nicht wert!',46,6),(102,'Gordon Ramsay',46,7),(103,'KFC',46,8),(104,'Italien',46,9),(105,'Pokemon',46,10),(106,'rgrewgewrg',41,1),(107,'Hopfen und Malz, ab in den Hals!',41,6),(108,'Gordon Ramsay',41,7),(109,'KFC',41,8),(110,'Pokemon',41,10),(111,'Balkonia',41,9),(114,'Balkonia',42,9),(115,'Ralf Zacherl',42,7),(116,'Drache',42,10);
173/*!40000 ALTER TABLE `T_INFO` ENABLE KEYS */;
174UNLOCK TABLES;
175
176--
177-- Table structure for table `T_ITEM`
178--
179
180DROP TABLE IF EXISTS `T_ITEM`;
181/*!40101 SET @saved_cs_client = @@character_set_client */;
182/*!40101 SET character_set_client = utf8 */;
183CREATE TABLE `T_ITEM` (
184 `Item_ID` int(2) NOT NULL,
185 `Title` varchar(80) NOT NULL,
186 `Selection_ID` int(2) NOT NULL,
187 PRIMARY KEY (`Item_ID`),
188 KEY `Selection_ID` (`Selection_ID`),
189 CONSTRAINT `t_item_ibfk_1` FOREIGN KEY (`Selection_ID`) REFERENCES `T_SELECTION` (`Attribute_ID`)
190) ENGINE=InnoDB DEFAULT CHARSET=utf8;
191/*!40101 SET character_set_client = @saved_cs_client */;
192
193--
194-- Dumping data for table `T_ITEM`
195--
196
197LOCK TABLES `T_ITEM` WRITE;
198/*!40000 ALTER TABLE `T_ITEM` DISABLE KEYS */;
199INSERT INTO `T_ITEM` VALUES (1,'Der kluge Mensch, so glaubt es mir, der redet nicht und trinkt sein Bier',6),(2,'Wer das Bier nicht ehrt, ist des Deliriums nicht wert!',6),(3,'Hopfen und Malz, ab in den Hals!',6),(4,'Optimismus ist: Aus einem Weizenkorn wird irgendwann ein Fass Bier!',6),(5,'Ralf Zacherl',7),(6,'Gordon Ramsay',7),(7,'Frank Oehler',7),(8,'Andreas Schweiger',7),(9,'Burger King',8),(10,'MC Donalds',8),(11,'KFC',8),(12,'hauptsache Essen!',8),(13,'Balkonia',9),(14,'Italien',9),(15,'In meiner Stammkneipe',9),(16,'Bloß nicht hier!',9),(17,'Einhorn',10),(18,'Drache',10),(19,'Pokemon',10),(20,'solange man es essen kann...',10);
200/*!40000 ALTER TABLE `T_ITEM` ENABLE KEYS */;
201UNLOCK TABLES;
202
203--
204-- Table structure for table `T_LEAFLET`
205--
206
207DROP TABLE IF EXISTS `T_LEAFLET`;
208/*!40101 SET @saved_cs_client = @@character_set_client */;
209/*!40101 SET character_set_client = utf8 */;
210CREATE TABLE `T_LEAFLET` (
211 `Leaflet_ID` int(6) NOT NULL,
212 `Ownership_ID` int(6) NOT NULL,
213 PRIMARY KEY (`Leaflet_ID`),
214 KEY `Ownership_ID` (`Ownership_ID`),
215 CONSTRAINT `t_leaflet_ibfk_1` FOREIGN KEY (`Ownership_ID`) REFERENCES `T_USERPROFILE` (`Profile_ID`)
216) ENGINE=InnoDB DEFAULT CHARSET=utf8;
217/*!40101 SET character_set_client = @saved_cs_client */;
218
219--
220-- Dumping data for table `T_LEAFLET`
221--
222
223LOCK TABLES `T_LEAFLET` WRITE;
224/*!40000 ALTER TABLE `T_LEAFLET` DISABLE KEYS */;
225INSERT INTO `T_LEAFLET` VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10),(11,11),(12,12),(13,13),(14,14),(15,15),(16,16),(17,17),(18,18),(19,19),(20,20),(21,21),(22,22),(23,23),(24,24),(25,25),(26,26),(27,27),(28,28),(29,29),(30,30),(31,31),(32,41),(33,43),(34,45),(35,47);
226/*!40000 ALTER TABLE `T_LEAFLET` ENABLE KEYS */;
227UNLOCK TABLES;
228
229--
230-- Table structure for table `T_PROFILE`
231--
232
233DROP TABLE IF EXISTS `T_PROFILE`;
234/*!40101 SET @saved_cs_client = @@character_set_client */;
235/*!40101 SET character_set_client = utf8 */;
236CREATE TABLE `T_PROFILE` (
237 `Profile_ID` int(6) NOT NULL,
238 `Sex` int(1) NOT NULL,
239 `Haircolor` int(1) NOT NULL,
240 `Confession` int(1) NOT NULL,
241 `Smoker` int(1) NOT NULL,
242 `Height` int(1) NOT NULL,
243 `Birthday` date NOT NULL,
244 PRIMARY KEY (`Profile_ID`),
245 KEY `Sex` (`Sex`),
246 KEY `Haircolor` (`Haircolor`),
247 KEY `Confession` (`Confession`),
248 KEY `Smoker` (`Smoker`),
249 CONSTRAINT `t_profile_ibfk_1` FOREIGN KEY (`Sex`) REFERENCES `T_SEX` (`Sex_ID`),
250 CONSTRAINT `t_profile_ibfk_2` FOREIGN KEY (`Haircolor`) REFERENCES `T_HAIRCOLOR` (`Haircolor_ID`),
251 CONSTRAINT `t_profile_ibfk_3` FOREIGN KEY (`Confession`) REFERENCES `T_CONFESSION` (`Confession_ID`),
252 CONSTRAINT `t_profile_ibfk_4` FOREIGN KEY (`Smoker`) REFERENCES `T_SMOKER` (`Smoker_ID`)
253) ENGINE=InnoDB DEFAULT CHARSET=utf8;
254/*!40101 SET character_set_client = @saved_cs_client */;
255
256--
257-- Dumping data for table `T_PROFILE`
258--
259
260LOCK TABLES `T_PROFILE` WRITE;
261/*!40000 ALTER TABLE `T_PROFILE` DISABLE KEYS */;
262INSERT INTO `T_PROFILE` VALUES (1,1,1,1,1,150,'1996-11-30'),(2,2,2,2,2,190,'1959-08-28'),(3,3,3,3,3,120,'1989-02-06'),(4,4,4,4,4,210,'1911-11-11'),(5,5,1,5,1,200,'1969-04-23'),(6,2,2,6,2,148,'1934-01-01'),(7,2,3,3,3,250,'1973-09-01'),(8,1,4,1,1,180,'2000-10-02'),(9,1,1,1,1,173,'1993-01-30'),(10,1,2,2,3,195,'1976-02-12'),(11,1,3,3,3,167,'1984-03-29'),(12,1,4,4,4,212,'1975-04-13'),(13,2,1,1,1,156,'1963-11-09'),(14,2,2,2,2,178,'1995-08-10'),(15,2,3,3,3,183,'1973-02-23'),(16,2,4,4,4,196,'1979-11-19'),(17,3,1,5,1,174,'1968-04-17'),(18,3,2,6,2,163,'1986-01-08'),(19,3,3,3,3,188,'1983-11-01'),(20,3,1,1,1,192,'2001-10-05'),(21,3,1,1,1,175,'1997-08-01'),(22,4,2,2,3,172,'1958-01-02'),(23,4,3,3,3,171,'1966-07-03'),(24,4,4,4,4,203,'1976-05-04'),(25,4,1,1,1,183,'1992-03-30'),(26,5,2,2,2,196,'1964-03-28'),(27,5,3,3,3,174,'1977-05-06'),(28,5,4,4,4,169,'1981-05-11'),(29,5,1,5,1,191,'1982-03-23'),(30,1,2,6,2,201,'1983-02-01'),(31,2,3,3,3,159,'1982-08-01'),(32,2,1,1,1,191,'1969-10-05'),(33,2,1,1,1,179,'1998-03-01'),(34,2,2,2,3,164,'1958-01-02'),(35,2,3,3,3,165,'1966-10-03'),(36,3,4,4,4,185,'1976-05-04'),(37,3,1,1,1,180,'1992-03-25'),(38,3,2,2,2,192,'1964-02-28'),(39,4,3,3,3,172,'1977-05-08'),(40,5,4,4,4,168,'1999-05-11'),(41,2,1,2,2,181,'2000-01-01'),(42,3,1,1,2,120,'2003-06-12'),(43,2,2,1,1,168,'1987-11-18'),(44,3,1,6,4,170,'1990-06-11'),(45,2,2,2,3,184,'1993-02-12'),(46,2,3,1,3,120,'2016-06-21'),(47,2,2,4,2,111,'2016-05-31'),(48,2,2,4,2,111,'2016-05-31'),(49,2,1,2,1,1111,'2016-06-01');
263/*!40000 ALTER TABLE `T_PROFILE` ENABLE KEYS */;
264UNLOCK TABLES;
265
266--
267-- Table structure for table `T_PROFILE_LEAFLET`
268--
269
270DROP TABLE IF EXISTS `T_PROFILE_LEAFLET`;
271/*!40101 SET @saved_cs_client = @@character_set_client */;
272/*!40101 SET character_set_client = utf8 */;
273CREATE TABLE `T_PROFILE_LEAFLET` (
274 `NoteDate` date NOT NULL,
275 `Leaflet_ID` int(6) NOT NULL,
276 `Lechery_ID` int(6) NOT NULL,
277 PRIMARY KEY (`Leaflet_ID`,`Lechery_ID`),
278 KEY `Lechery_ID` (`Lechery_ID`),
279 CONSTRAINT `t_profile_leaflet_ibfk_1` FOREIGN KEY (`Leaflet_ID`) REFERENCES `T_LEAFLET` (`Leaflet_ID`),
280 CONSTRAINT `t_profile_leaflet_ibfk_2` FOREIGN KEY (`Lechery_ID`) REFERENCES `T_USERPROFILE` (`Profile_ID`)
281) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Auflösung der n:m Beziehung zwischen Profile und Leaflet';
282/*!40101 SET character_set_client = @saved_cs_client */;
283
284--
285-- Dumping data for table `T_PROFILE_LEAFLET`
286--
287
288LOCK TABLES `T_PROFILE_LEAFLET` WRITE;
289/*!40000 ALTER TABLE `T_PROFILE_LEAFLET` DISABLE KEYS */;
290INSERT INTO `T_PROFILE_LEAFLET` VALUES ('2016-06-16',1,2),('2016-06-16',1,3),('2016-06-16',1,4),('2016-06-16',1,5),('2016-06-16',1,6),('2016-06-16',1,9),('2016-06-16',1,10),('2016-06-16',1,11),('2016-06-16',1,12),('2016-06-16',1,13),('2016-06-16',1,18),('2016-06-16',1,19),('2016-06-16',1,20),('2016-06-16',1,21),('2016-06-16',1,22),('2016-06-16',1,25),('2016-06-16',1,26),('2016-06-16',1,27),('2016-06-16',1,28),('2016-06-16',1,29),('2016-06-16',2,5),('2016-06-16',2,7),('2016-06-16',2,14),('2016-06-16',2,15),('2016-06-16',2,23),('2016-06-16',2,24),('2016-06-16',2,30),('2016-06-16',2,31),('2016-06-16',3,6),('2016-06-16',3,8),('2016-06-16',3,9),('2016-06-16',3,10),('2016-06-16',3,16),('2016-06-16',3,17),('2016-06-16',3,25),('2016-06-16',3,26),('2016-06-16',4,1),('2016-06-16',4,11),('2016-06-16',4,18),('2016-06-16',4,27),('2016-06-16',5,7),('2016-06-16',5,12),('2016-06-16',5,19),('2016-06-16',5,28),('2016-06-16',6,3),('2016-06-16',6,13),('2016-06-16',6,20),('2016-06-16',6,29),('2016-06-16',7,1),('2016-06-16',7,14),('2016-06-16',7,21),('2016-06-16',7,30),('2016-06-16',8,1),('2016-06-16',8,2),('2016-06-16',8,4),('2016-06-16',8,6),('2016-06-16',8,15),('2016-06-16',8,16),('2016-06-16',8,17),('2016-06-16',8,22),('2016-06-16',8,23),('2016-06-16',8,24),('2016-06-16',8,31),('2016-06-20',33,17),('2016-06-20',33,20),('2016-06-19',34,3);
291/*!40000 ALTER TABLE `T_PROFILE_LEAFLET` ENABLE KEYS */;
292UNLOCK TABLES;
293
294--
295-- Table structure for table `T_SEARCHPROFILE`
296--
297
298DROP TABLE IF EXISTS `T_SEARCHPROFILE`;
299/*!40101 SET @saved_cs_client = @@character_set_client */;
300/*!40101 SET character_set_client = utf8 */;
301CREATE TABLE `T_SEARCHPROFILE` (
302 `Profile_ID` int(6) NOT NULL,
303 `OwnerProfile_ID` int(6) NOT NULL,
304 `Description` varchar(40) NOT NULL,
305 PRIMARY KEY (`Profile_ID`),
306 KEY `OwnerProfile_ID` (`OwnerProfile_ID`),
307 CONSTRAINT `t_searchprofile_ibfk_1` FOREIGN KEY (`Profile_ID`) REFERENCES `T_PROFILE` (`Profile_ID`),
308 CONSTRAINT `t_searchprofile_ibfk_2` FOREIGN KEY (`OwnerProfile_ID`) REFERENCES `T_USERPROFILE` (`Profile_ID`)
309) ENGINE=InnoDB DEFAULT CHARSET=utf8;
310/*!40101 SET character_set_client = @saved_cs_client */;
311
312--
313-- Dumping data for table `T_SEARCHPROFILE`
314--
315
316LOCK TABLES `T_SEARCHPROFILE` WRITE;
317/*!40000 ALTER TABLE `T_SEARCHPROFILE` DISABLE KEYS */;
318INSERT INTO `T_SEARCHPROFILE` VALUES (32,1,'Meine Traumtyp'),(33,2,'Mein idealer Partner'),(34,3,'Meine Illusion'),(35,4,'Meine große Liebe'),(36,5,'Searchprofile_5'),(37,1,'Das wäre auch OK'),(38,2,'Wenn es sein muss'),(39,3,'Illusion maximiert'),(40,4,'Searchprofile_9'),(42,41,'null'),(44,43,'Mädels'),(46,45,'Meine große Liebe'),(49,47,'eofnewofn');
319/*!40000 ALTER TABLE `T_SEARCHPROFILE` ENABLE KEYS */;
320UNLOCK TABLES;
321
322--
323-- Table structure for table `T_SELECTION`
324--
325
326DROP TABLE IF EXISTS `T_SELECTION`;
327/*!40101 SET @saved_cs_client = @@character_set_client */;
328/*!40101 SET character_set_client = utf8 */;
329CREATE TABLE `T_SELECTION` (
330 `Attribute_ID` int(2) NOT NULL,
331 PRIMARY KEY (`Attribute_ID`),
332 CONSTRAINT `t_selection_ibfk_1` FOREIGN KEY (`Attribute_ID`) REFERENCES `T_ATTRIBUTE` (`Attribute_ID`)
333) ENGINE=InnoDB DEFAULT CHARSET=utf8;
334/*!40101 SET character_set_client = @saved_cs_client */;
335
336--
337-- Dumping data for table `T_SELECTION`
338--
339
340LOCK TABLES `T_SELECTION` WRITE;
341/*!40000 ALTER TABLE `T_SELECTION` DISABLE KEYS */;
342INSERT INTO `T_SELECTION` VALUES (6),(7),(8),(9),(10);
343/*!40000 ALTER TABLE `T_SELECTION` ENABLE KEYS */;
344UNLOCK TABLES;
345
346--
347-- Table structure for table `T_SEX`
348--
349
350DROP TABLE IF EXISTS `T_SEX`;
351/*!40101 SET @saved_cs_client = @@character_set_client */;
352/*!40101 SET character_set_client = utf8 */;
353CREATE TABLE `T_SEX` (
354 `Sex_ID` int(1) NOT NULL,
355 `Label` varchar(20) NOT NULL,
356 PRIMARY KEY (`Sex_ID`)
357) ENGINE=InnoDB DEFAULT CHARSET=utf8;
358/*!40101 SET character_set_client = @saved_cs_client */;
359
360--
361-- Dumping data for table `T_SEX`
362--
363
364LOCK TABLES `T_SEX` WRITE;
365/*!40000 ALTER TABLE `T_SEX` DISABLE KEYS */;
366INSERT INTO `T_SEX` VALUES (1,'unbekannt'),(2,'männlich'),(3,'weiblich'),(4,'heute männlich'),(5,'heute weiblich');
367/*!40000 ALTER TABLE `T_SEX` ENABLE KEYS */;
368UNLOCK TABLES;
369
370--
371-- Table structure for table `T_SMOKER`
372--
373
374DROP TABLE IF EXISTS `T_SMOKER`;
375/*!40101 SET @saved_cs_client = @@character_set_client */;
376/*!40101 SET character_set_client = utf8 */;
377CREATE TABLE `T_SMOKER` (
378 `Smoker_ID` int(1) NOT NULL,
379 `Label` varchar(20) NOT NULL,
380 PRIMARY KEY (`Smoker_ID`)
381) ENGINE=InnoDB DEFAULT CHARSET=utf8;
382/*!40101 SET character_set_client = @saved_cs_client */;
383
384--
385-- Dumping data for table `T_SMOKER`
386--
387
388LOCK TABLES `T_SMOKER` WRITE;
389/*!40000 ALTER TABLE `T_SMOKER` DISABLE KEYS */;
390INSERT INTO `T_SMOKER` VALUES (1,'Ja'),(2,'Nein'),(3,'Partyraucher'),(4,'keine Angabe');
391/*!40000 ALTER TABLE `T_SMOKER` ENABLE KEYS */;
392UNLOCK TABLES;
393
394--
395-- Table structure for table `T_USERPROFILE`
396--
397
398DROP TABLE IF EXISTS `T_USERPROFILE`;
399/*!40101 SET @saved_cs_client = @@character_set_client */;
400/*!40101 SET character_set_client = utf8 */;
401CREATE TABLE `T_USERPROFILE` (
402 `Profile_ID` int(6) NOT NULL,
403 `Nickname` varchar(40) NOT NULL,
404 `Firstname` varchar(40) NOT NULL,
405 `E_Mail` varchar(254) NOT NULL,
406 `Lastname` varchar(40) NOT NULL,
407 `CreationDate` date NOT NULL,
408 PRIMARY KEY (`Profile_ID`),
409 UNIQUE KEY `E_Mail_UNIQUE` (`E_Mail`),
410 CONSTRAINT `t_userprofile_ibfk_1` FOREIGN KEY (`Profile_ID`) REFERENCES `T_PROFILE` (`Profile_ID`)
411) ENGINE=InnoDB DEFAULT CHARSET=utf8;
412/*!40101 SET character_set_client = @saved_cs_client */;
413
414--
415-- Dumping data for table `T_USERPROFILE`
416--
417
418LOCK TABLES `T_USERPROFILE` WRITE;
419/*!40000 ALTER TABLE `T_USERPROFILE` DISABLE KEYS */;
420INSERT INTO `T_USERPROFILE` VALUES (1,'Frodo','Claus','Frodo@gmail.com','Kleber','1959-08-28'),(2,'Aragorn','Dieter','Aragorn@gmail.com','Hamlet','1989-02-06'),(3,'Gimli','Peter','Gimli@gmail.com','Müller','1911-11-11'),(4,'Legolas','Franziska','Legolas@gmail.com','Weidenbauer','1969-04-23'),(5,'Legolars','Marcel','Legolars@gmail.com','Schmidt','1934-01-01'),(6,'Boromir','Lisa','Boromir@gmail.com','Mayer','1973-09-01'),(7,'Gandalf','Romper','Gandalf@gmail.com','Stomper','2000-08-03'),(8,'Sam','Mareike','Sam@gmail.com','Geißler','1996-11-30'),(9,'Plitschplatsch','Mia','Plitschplatsch@gmail.com','Pottebaum','2000-10-12'),(10,'Plüschirüschi','Emma','Emma@gmail.com','Polaschek','2011-11-10'),(11,'Rappelzong','Ben','Rappelzong@gmail.com','Peter vor dem Berge','2011-08-30'),(12,'Hoppelpoppel','Luca ','Hoppelpoppel@gmail.com','Uthmann','2012-12-24'),(13,'Rambatussi','Paul','Rambatussi@gmail.com','Zimmermann ','2013-06-18'),(14,'Ichka Ckmir Indie Hos','Jonas','Ichka@gmail.com','Ahrens sive Ahringsmann','2014-01-30'),(15,'Alfredo der Analtorpedo','Fynn','Alfredo@gmail.com','Abelmann ','2014-09-18'),(16,'RäuberFotzenRotz','Leon','FotzenRotz@gmail.com','Wüllner ','2013-09-18'),(17,'Clint aus dem Wald des Ostens','Hanna','Clint@gmail.com','Winkes-Glüsenkamp','2014-05-30'),(18,'Jesus-ders-im-Kreuze-hat','Sophia','Kreuz@gmail.com','Wamhof vor den Wösten','2008-08-31'),(19,'ROFL die Waldfee','Anna','ROFL@gmail.com','Leimann','2004-07-24'),(20,'Jesus@abhängen','Leah','Jesus@gmail.com','Leimann','2011-05-18'),(21,'h4upts4ch3 z4hl3n 1m n4m3n','Sophia','h4upts4ch3@gmail.com','Laumeyer','2013-07-18'),(22,'The Legend of the Wienerschnitzel','Louis','Wienerschnitzel@gmail.com','Imholze','2010-12-01'),(23,'FunkyChinaManFromFunkyChinaTown','Erkan','Erkan@gmail.com','Alles','2009-08-16'),(24,'Summi die lustige Bashfliege','Maximilian','Summi@gmail.com','Isermeyer','2010-04-01'),(25,'Karotti der lustige Hasenzahn','Noah','Karotti@gmail.com','Finke aus dem Bruche','2012-10-18'),(26,'Gammli, das süße Schimmelbrot','Amelie','Gammli@gmail.com','Fahrtmann ','2003-02-20'),(27,'PressHardGoKlo','Mila','PressHardGoKlo@gmail.com','Netcher ','2011-01-01'),(28,'Mupfi die mutige Waschmaschine','Pia','Mupfi@gmail.com','Niemeyer vw. Bretholt','2008-06-27'),(29,'Cookie der terror-krümmel','Laura','Cookie@gmail.com','Meier zu Ortbergen','2004-09-10'),(30,'Hugh G. Erection','Emil','Hugh@gmail.com','Mönchs vd. Meyer zu Hüsede','2012-12-18'),(31,'G.B.Hindert','Neele','Hindert@gmail.com','Meyer zu Reckendorf','2010-06-19'),(41,'Kartoffelsalat','Ingo','ingo.trautwein.it@gmail.com','Trautwein','2016-06-16'),(43,'Marcosss','Marcos','marcos.souliotis@gmail.com','Souliotis','2016-06-19'),(45,'Flo','Florian','Florian.Ebbert@googlemail.com','Ebbert','2016-06-19'),(47,'knelkzzzz','Marc','klenk.marc@googlemail.com','Klenk','2016-06-20');
421/*!40000 ALTER TABLE `T_USERPROFILE` ENABLE KEYS */;
422UNLOCK TABLES;
423
424--
425-- Table structure for table `T_VISIT`
426--
427
428DROP TABLE IF EXISTS `T_VISIT`;
429/*!40101 SET @saved_cs_client = @@character_set_client */;
430/*!40101 SET character_set_client = utf8 */;
431CREATE TABLE `T_VISIT` (
432 `Visit_ID` int(11) NOT NULL,
433 `VisitDate` date NOT NULL,
434 `Voluptuary_ID` int(6) NOT NULL,
435 `Curiosity_ID` int(6) NOT NULL,
436 PRIMARY KEY (`Visit_ID`),
437 KEY `Voluptuary_ID` (`Voluptuary_ID`),
438 KEY `Curiosity_ID` (`Curiosity_ID`),
439 CONSTRAINT `t_visit_ibfk_1` FOREIGN KEY (`Voluptuary_ID`) REFERENCES `T_USERPROFILE` (`Profile_ID`),
440 CONSTRAINT `t_visit_ibfk_2` FOREIGN KEY (`Curiosity_ID`) REFERENCES `T_USERPROFILE` (`Profile_ID`)
441) ENGINE=InnoDB DEFAULT CHARSET=utf8;
442/*!40101 SET character_set_client = @saved_cs_client */;
443
444--
445-- Dumping data for table `T_VISIT`
446--
447
448LOCK TABLES `T_VISIT` WRITE;
449/*!40000 ALTER TABLE `T_VISIT` DISABLE KEYS */;
450INSERT INTO `T_VISIT` VALUES (1,'2016-03-11',1,2),(2,'2016-03-12',1,3),(3,'2016-03-13',1,4),(4,'2016-03-14',1,5),(5,'2016-03-15',1,6),(6,'2016-03-16',1,7),(7,'2011-03-17',1,8),(8,'2011-03-18',2,1),(9,'2011-03-19',2,3),(10,'2011-03-20',3,2),(11,'2011-03-21',4,2),(12,'2011-03-22',5,7),(13,'2011-03-23',6,3),(14,'2011-03-24',7,4),(15,'2011-03-25',8,7),(16,'2011-03-26',8,5),(17,'2011-03-27',2,4),(18,'2011-03-28',3,1),(19,'2011-03-29',4,1),(20,'2016-06-19',45,3),(21,'2016-06-19',45,3),(22,'2016-06-19',45,3),(23,'2016-06-19',45,3),(24,'2016-06-20',43,3),(25,'2016-06-20',43,3),(26,'2016-06-20',43,28),(27,'2016-06-20',43,7),(28,'2016-06-20',43,7),(29,'2016-06-20',43,17),(30,'2016-06-20',43,20),(31,'2016-06-20',47,13);
451/*!40000 ALTER TABLE `T_VISIT` ENABLE KEYS */;
452UNLOCK TABLES;
453/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
454
455/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
456/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
457/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
458/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
459/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
460/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
461/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
462
463-- Dump completed on 2016-06-22 16:29:33