26ZTfDJ6

1-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
2--
3-- Host: localhost    Database: gestione_parco
4-- ------------------------------------------------------
5-- Server version	5.7.17-log
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-- Table structure for table `agenzia`
20--
21
22DROP TABLE IF EXISTS `agenzia`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `agenzia` (
26  `nome` varchar(15) NOT NULL,
27  `sede` varchar(15) NOT NULL,
28  `username` varchar(15) NOT NULL,
29  `password` varchar(15) NOT NULL,
30  `telefono` int(8) DEFAULT NULL,
31  `partita_iva` int(10) DEFAULT NULL,
32  PRIMARY KEY (`username`)
33) ENGINE=InnoDB DEFAULT CHARSET=utf8;
34/*!40101 SET character_set_client = @saved_cs_client */;
35
36--
37-- Dumping data for table `agenzia`
38--
39
40LOCK TABLES `agenzia` WRITE;
41/*!40000 ALTER TABLE `agenzia` DISABLE KEYS */;
42INSERT INTO `agenzia` VALUES ('HolidayAg','Avellino','ag','holiday',89657,245972),('Fun&Dreams','Napoli','fun','dreams',813678,259876),('PowerAgency','Roma','power','agency',8274965,254793);
43/*!40000 ALTER TABLE `agenzia` ENABLE KEYS */;
44UNLOCK TABLES;
45
46--
47-- Table structure for table `attività`
48--
49
50DROP TABLE IF EXISTS `attività`;
51/*!40101 SET @saved_cs_client     = @@character_set_client */;
52/*!40101 SET character_set_client = utf8 */;
53CREATE TABLE `attività` (
54  `nome_attività` varchar(15) NOT NULL,
55  `prezzo` int(2) NOT NULL DEFAULT '15',
56  `nome` varchar(15) NOT NULL,
57  PRIMARY KEY (`nome_attività`),
58  KEY `nome_attività_idx` (`nome`),
59  CONSTRAINT `nome_attività` FOREIGN KEY (`nome`) REFERENCES `parco` (`nome`) ON DELETE NO ACTION ON UPDATE NO ACTION
60) ENGINE=InnoDB DEFAULT CHARSET=utf8;
61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Dumping data for table `attività`
65--
66
67LOCK TABLES `attività` WRITE;
68/*!40000 ALTER TABLE `attività` DISABLE KEYS */;
69INSERT INTO `attività` VALUES ('BuildCamp',15,'IndianaPark'),('CallOfDuty',15,'VictoryPark'),('DDay',15,'VictoryPark'),('Dorso',15,'Aquafun'),('Onde',15,'Aquafun'),('Pallanuoto',15,'Aquafun'),('Pellerossa',15,'IndianaPark');
70/*!40000 ALTER TABLE `attività` ENABLE KEYS */;
71UNLOCK TABLES;
72
73--
74-- Table structure for table `biglietto`
75--
76
77DROP TABLE IF EXISTS `biglietto`;
78/*!40101 SET @saved_cs_client     = @@character_set_client */;
79/*!40101 SET character_set_client = utf8 */;
80CREATE TABLE `biglietto` (
81  `codice_fiscale` varchar(16) NOT NULL,
82  `data_fine` date NOT NULL,
83  `nome_attività` varchar(15) DEFAULT NULL,
84  `data_acquisto` varchar(45) NOT NULL,
85  `prezzo` int(2) NOT NULL DEFAULT '20',
86  `nome_attività2` varchar(15) DEFAULT NULL,
87  `nome_attività3` varchar(15) DEFAULT NULL,
88  `nome_attività4` varchar(15) DEFAULT NULL,
89  `nome_attività5` varchar(15) DEFAULT NULL,
90  `nome_attività6` varchar(15) DEFAULT NULL,
91  `parco` varchar(15) NOT NULL,
92  PRIMARY KEY (`codice_fiscale`),
93  KEY `nome_attività_biglietto_idx` (`nome_attività`,`nome_attività2`,`nome_attività3`,`nome_attività5`,`nome_attività4`,`nome_attività6`),
94  KEY `parco_biglietto_idx` (`parco`),
95  CONSTRAINT `codice_fiscale_biglietto` FOREIGN KEY (`codice_fiscale`) REFERENCES `cliente` (`cf`) ON DELETE CASCADE ON UPDATE CASCADE,
96  CONSTRAINT `parco_biglietto` FOREIGN KEY (`parco`) REFERENCES `parco` (`nome`) ON DELETE NO ACTION ON UPDATE NO ACTION
97) ENGINE=InnoDB DEFAULT CHARSET=utf8;
98/*!40101 SET character_set_client = @saved_cs_client */;
99
100--
101-- Dumping data for table `biglietto`
102--
103
104LOCK TABLES `biglietto` WRITE;
105/*!40000 ALTER TABLE `biglietto` DISABLE KEYS */;
106INSERT INTO `biglietto` VALUES ('dgdido','2017-05-10','','2017/5/5',20,'','','','','','IndianaPark'),('dsd','2017-01-18','','2017/1/13',20,'','','','','','Aquafun'),('gcmczz','2017-02-05','Pellerossa','2017/1/30',35,'','','','','','IndianaPark'),('scrfnce','2017-02-08','Rana','2017/2/1',35,'','','','','','Aquafun'),('shsds','2017-03-06','BuildCamp','2017/3/1',35,'','','','','','IndianaPark');
107/*!40000 ALTER TABLE `biglietto` ENABLE KEYS */;
108UNLOCK TABLES;
109
110--
111-- Table structure for table `cliente`
112--
113
114DROP TABLE IF EXISTS `cliente`;
115/*!40101 SET @saved_cs_client     = @@character_set_client */;
116/*!40101 SET character_set_client = utf8 */;
117CREATE TABLE `cliente` (
118  `cf` varchar(16) NOT NULL,
119  `nome` varchar(20) NOT NULL,
120  `cognome` varchar(20) NOT NULL,
121  `età` int(2) NOT NULL,
122  PRIMARY KEY (`cf`)
123) ENGINE=InnoDB DEFAULT CHARSET=utf8;
124/*!40101 SET character_set_client = @saved_cs_client */;
125
126--
127-- Dumping data for table `cliente`
128--
129
130LOCK TABLES `cliente` WRITE;
131/*!40000 ALTER TABLE `cliente` DISABLE KEYS */;
132INSERT INTO `cliente` VALUES ('dgdido','carlo','rossi',22),('dsd','sffd','sdfs',5),('gcmczz','Giacomo','Cocozziello',21),('scrfnce','Francesco','Sciretta',21),('shsds','fgfz','fsgf',39);
133/*!40000 ALTER TABLE `cliente` ENABLE KEYS */;
134UNLOCK TABLES;
135
136--
137-- Table structure for table `contratto`
138--
139
140DROP TABLE IF EXISTS `contratto`;
141/*!40101 SET @saved_cs_client     = @@character_set_client */;
142/*!40101 SET character_set_client = utf8 */;
143CREATE TABLE `contratto` (
144  `codice` int(7) NOT NULL,
145  `scadenza` date NOT NULL,
146  `codicef` varchar(16) NOT NULL,
147  PRIMARY KEY (`codice`),
148  KEY `codicef_contratto_idx` (`codicef`),
149  CONSTRAINT `codicef_contratto` FOREIGN KEY (`codicef`) REFERENCES `dipendenti` (`codice_fiscale`) ON DELETE CASCADE ON UPDATE CASCADE
150) ENGINE=InnoDB DEFAULT CHARSET=utf8;
151/*!40101 SET character_set_client = @saved_cs_client */;
152
153--
154-- Dumping data for table `contratto`
155--
156
157LOCK TABLES `contratto` WRITE;
158/*!40000 ALTER TABLE `contratto` DISABLE KEYS */;
159INSERT INTO `contratto` VALUES (240,'2018-05-20','brnfnc548'),(241,'2020-04-30','glipftt88dd'),(242,'2019-10-19','gppvrd2553s'),(243,'2017-12-15','lcrrss589a6');
160/*!40000 ALTER TABLE `contratto` ENABLE KEYS */;
161UNLOCK TABLES;
162
163--
164-- Table structure for table `dipendenti`
165--
166
167DROP TABLE IF EXISTS `dipendenti`;
168/*!40101 SET @saved_cs_client     = @@character_set_client */;
169/*!40101 SET character_set_client = utf8 */;
170CREATE TABLE `dipendenti` (
171  `codice_fiscale` varchar(16) NOT NULL,
172  `nome` varchar(45) NOT NULL,
173  `cognome` varchar(45) NOT NULL,
174  `età` int(2) NOT NULL,
175  PRIMARY KEY (`codice_fiscale`)
176) ENGINE=InnoDB DEFAULT CHARSET=utf8;
177/*!40101 SET character_set_client = @saved_cs_client */;
178
179--
180-- Dumping data for table `dipendenti`
181--
182
183LOCK TABLES `dipendenti` WRITE;
184/*!40000 ALTER TABLE `dipendenti` DISABLE KEYS */;
185INSERT INTO `dipendenti` VALUES ('brnfnc548','Francesco','Bruni',25),('glipftt88dd','Giulia','Perfetto',20),('gppvrd2553s','Giuseppe','Verdi',30),('lcrrss589a6','Luca','Rossi',22);
186/*!40000 ALTER TABLE `dipendenti` ENABLE KEYS */;
187UNLOCK TABLES;
188
189--
190-- Table structure for table `offerta`
191--
192
193DROP TABLE IF EXISTS `offerta`;
194/*!40101 SET @saved_cs_client     = @@character_set_client */;
195/*!40101 SET character_set_client = utf8 */;
196CREATE TABLE `offerta` (
197  `codice` int(10) NOT NULL,
198  `nome` varchar(45) NOT NULL,
199  `descrizione` varchar(45) NOT NULL,
200  `data_inizio` date NOT NULL,
201  `data_fine` date NOT NULL,
202  `nome_parco` varchar(15) NOT NULL,
203  `sede_parco` varchar(15) NOT NULL,
204  PRIMARY KEY (`codice`),
205  KEY `nome_parco_sede_parco_idx` (`nome_parco`),
206  KEY `sede_parco_idx` (`sede_parco`)
207) ENGINE=InnoDB DEFAULT CHARSET=utf8;
208/*!40101 SET character_set_client = @saved_cs_client */;
209
210--
211-- Dumping data for table `offerta`
212--
213
214LOCK TABLES `offerta` WRITE;
215/*!40000 ALTER TABLE `offerta` DISABLE KEYS */;
216INSERT INTO `offerta` VALUES (6935,'Sconto20','Sconto del 20% sul menu pranzo','2017-02-11','2017-02-18','Indiana\'s Park','Nola'),(7821,'Prendi2x1','acquista due biglietti e ne paghi solo uno','2017-02-10','2017-02-13','Aquafun','Avellino'),(8975,'Gratis5x3','Entrate in 5,3 pagano due no','2017-02-20','2017-02-23','VictoryPark','Pontecagnano');
217/*!40000 ALTER TABLE `offerta` ENABLE KEYS */;
218UNLOCK TABLES;
219
220--
221-- Table structure for table `pacchetto`
222--
223
224DROP TABLE IF EXISTS `pacchetto`;
225/*!40101 SET @saved_cs_client     = @@character_set_client */;
226/*!40101 SET character_set_client = utf8 */;
227CREATE TABLE `pacchetto` (
228  `codice` int(10) NOT NULL,
229  `nome` varchar(45) NOT NULL,
230  `descrizione` varchar(45) NOT NULL,
231  `username` varchar(15) NOT NULL,
232  `id_ristorante` int(6) DEFAULT NULL,
233  `nomep` varchar(15) NOT NULL,
234  `data_acquisto` date NOT NULL,
235  `id_hotel` int(6) DEFAULT NULL,
236  `prezzo_pacchetto` int(2) NOT NULL,
237  `cf` varchar(16) DEFAULT NULL,
238  `venduto` varchar(3) DEFAULT 'NO',
239  PRIMARY KEY (`codice`),
240  KEY `hotel_ristorante_idx` (`id_hotel`,`id_ristorante`),
241  KEY `id_ristorante_pacchetto_idx` (`id_ristorante`),
242  KEY `nome_sede_pacchetto_idx` (`nomep`),
243  KEY `codice_cliente.pacchetto_idx` (`cf`),
244  CONSTRAINT `id_hotel_pacchetto` FOREIGN KEY (`id_hotel`) REFERENCES `struttura` (`codice`) ON DELETE CASCADE ON UPDATE CASCADE,
245  CONSTRAINT `id_ristorante_pacchetto` FOREIGN KEY (`id_ristorante`) REFERENCES `struttura` (`codice`) ON DELETE NO ACTION ON UPDATE NO ACTION,
246  CONSTRAINT `nomep_sede_pacchetto` FOREIGN KEY (`nomep`) REFERENCES `parco` (`nome`) ON DELETE NO ACTION ON UPDATE NO ACTION
247) ENGINE=InnoDB DEFAULT CHARSET=utf8;
248/*!40101 SET character_set_client = @saved_cs_client */;
249
250--
251-- Dumping data for table `pacchetto`
252--
253
254LOCK TABLES `pacchetto` WRITE;
255/*!40000 ALTER TABLE `pacchetto` DISABLE KEYS */;
256INSERT INTO `pacchetto` VALUES (2589,'Estate2017','Pacchetto Famiglia','fun',251,'Aquafun','2017-02-02',250,50,'asder','SI'),(2896,'Inverno2017','PacchettoCoppia','fun',251,'Aquafun','2017-01-20',250,30,'scrg','si');
257/*!40000 ALTER TABLE `pacchetto` ENABLE KEYS */;
258UNLOCK TABLES;
259
260--
261-- Table structure for table `parco`
262--
263
264DROP TABLE IF EXISTS `parco`;
265/*!40101 SET @saved_cs_client     = @@character_set_client */;
266/*!40101 SET character_set_client = utf8 */;
267CREATE TABLE `parco` (
268  `nome` varchar(15) NOT NULL,
269  `sede` varchar(15) NOT NULL,
270  `num_biglietti` int(5) DEFAULT NULL,
271  `numero_attività` varchar(15) DEFAULT NULL,
272  `telefono` int(7) DEFAULT NULL,
273  PRIMARY KEY (`nome`,`sede`)
274) ENGINE=InnoDB DEFAULT CHARSET=utf8;
275/*!40101 SET character_set_client = @saved_cs_client */;
276
277--
278-- Dumping data for table `parco`
279--
280
281LOCK TABLES `parco` WRITE;
282/*!40000 ALTER TABLE `parco` DISABLE KEYS */;
283INSERT INTO `parco` VALUES ('Aquafun','Avellino',70,'5',82469),('IndianaPark','Nola',90,'8',8169),('VictoryPark','Pontecagnano',100,'10',8137);
284/*!40000 ALTER TABLE `parco` ENABLE KEYS */;
285UNLOCK TABLES;
286
287--
288-- Table structure for table `parco_acquatico`
289--
290
291DROP TABLE IF EXISTS `parco_acquatico`;
292/*!40101 SET @saved_cs_client     = @@character_set_client */;
293/*!40101 SET character_set_client = utf8 */;
294CREATE TABLE `parco_acquatico` (
295  `nome` varchar(15) NOT NULL,
296  `sede` varchar(15) NOT NULL,
297  `num_piscine` int(25) DEFAULT NULL,
298  PRIMARY KEY (`nome`,`sede`),
299  CONSTRAINT `nome_sede_parco_acquatico` FOREIGN KEY (`nome`, `sede`) REFERENCES `parco` (`nome`, `sede`) ON DELETE CASCADE ON UPDATE CASCADE
300) ENGINE=InnoDB DEFAULT CHARSET=utf8;
301/*!40101 SET character_set_client = @saved_cs_client */;
302
303--
304-- Dumping data for table `parco_acquatico`
305--
306
307LOCK TABLES `parco_acquatico` WRITE;
308/*!40000 ALTER TABLE `parco_acquatico` DISABLE KEYS */;
309INSERT INTO `parco_acquatico` VALUES ('Aquafun','Avellino',4);
310/*!40000 ALTER TABLE `parco_acquatico` ENABLE KEYS */;
311UNLOCK TABLES;
312
313--
314-- Table structure for table `parco_avventura`
315--
316
317DROP TABLE IF EXISTS `parco_avventura`;
318/*!40101 SET @saved_cs_client     = @@character_set_client */;
319/*!40101 SET character_set_client = utf8 */;
320CREATE TABLE `parco_avventura` (
321  `percorso` varchar(15) NOT NULL,
322  `nome` varchar(15) NOT NULL,
323  `sede` varchar(15) NOT NULL,
324  PRIMARY KEY (`nome`,`sede`),
325  CONSTRAINT `nome_sede_parco_avventura` FOREIGN KEY (`nome`, `sede`) REFERENCES `parco` (`nome`, `sede`) ON DELETE CASCADE ON UPDATE CASCADE
326) ENGINE=InnoDB DEFAULT CHARSET=utf8;
327/*!40101 SET character_set_client = @saved_cs_client */;
328
329--
330-- Dumping data for table `parco_avventura`
331--
332
333LOCK TABLES `parco_avventura` WRITE;
334/*!40000 ALTER TABLE `parco_avventura` DISABLE KEYS */;
335INSERT INTO `parco_avventura` VALUES ('Campestre','VictoryPark','Pontecagnano');
336/*!40000 ALTER TABLE `parco_avventura` ENABLE KEYS */;
337UNLOCK TABLES;
338
339--
340-- Table structure for table `parco_tematico`
341--
342
343DROP TABLE IF EXISTS `parco_tematico`;
344/*!40101 SET @saved_cs_client     = @@character_set_client */;
345/*!40101 SET character_set_client = utf8 */;
346CREATE TABLE `parco_tematico` (
347  `tema` varchar(15) NOT NULL,
348  `nome` varchar(15) NOT NULL,
349  `sede` varchar(15) NOT NULL,
350  PRIMARY KEY (`nome`,`sede`),
351  CONSTRAINT `nome_sede_parco_tematico` FOREIGN KEY (`nome`, `sede`) REFERENCES `parco` (`nome`, `sede`) ON DELETE CASCADE ON UPDATE CASCADE
352) ENGINE=InnoDB DEFAULT CHARSET=utf8;
353/*!40101 SET character_set_client = @saved_cs_client */;
354
355--
356-- Dumping data for table `parco_tematico`
357--
358
359LOCK TABLES `parco_tematico` WRITE;
360/*!40000 ALTER TABLE `parco_tematico` DISABLE KEYS */;
361INSERT INTO `parco_tematico` VALUES ('Pellerossa','IndianaPark','Nola');
362/*!40000 ALTER TABLE `parco_tematico` ENABLE KEYS */;
363UNLOCK TABLES;
364
365--
366-- Table structure for table `struttura`
367--
368
369DROP TABLE IF EXISTS `struttura`;
370/*!40101 SET @saved_cs_client     = @@character_set_client */;
371/*!40101 SET character_set_client = utf8 */;
372CREATE TABLE `struttura` (
373  `codice` int(6) NOT NULL,
374  `tipo` varchar(15) NOT NULL,
375  `nome_struttura` varchar(45) NOT NULL,
376  `nome` varchar(15) NOT NULL,
377  PRIMARY KEY (`codice`),
378  KEY `nome, sede_idx` (`nome`),
379  CONSTRAINT `nome_sede_struttura` FOREIGN KEY (`nome`) REFERENCES `parco` (`nome`) ON DELETE CASCADE ON UPDATE CASCADE
380) ENGINE=InnoDB DEFAULT CHARSET=utf8;
381/*!40101 SET character_set_client = @saved_cs_client */;
382
383--
384-- Dumping data for table `struttura`
385--
386
387LOCK TABLES `struttura` WRITE;
388/*!40000 ALTER TABLE `struttura` DISABLE KEYS */;
389INSERT INTO `struttura` VALUES (250,'HOTEL','La Rosa','Aquafun'),(251,'RISTORANTE','il Vento','Aquafun'),(290,'il mare','RISTORANTE','Aquafun'),(295,'La pietra','HOTEL','VictoryPark'),(300,'la sabbia','RISTORANTE','IndianaPark');
390/*!40000 ALTER TABLE `struttura` ENABLE KEYS */;
391UNLOCK TABLES;
392/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
393
394/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
395/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
396/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
397/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
398/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
399/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
400/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
401
402-- Dump completed on 2017-01-30 17:35:14