· 8 years ago · Dec 06, 2017, 06:56 AM
1-- MySQL dump 10.16 Distrib 10.1.26-MariaDB, for Win32 (AMD64)
2--
3-- Host: localhost Database: es
4-- ------------------------------------------------------
5-- Server version 10.1.26-MariaDB
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 `attori`
20--
21
22DROP TABLE IF EXISTS `attori`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `attori` (
26 `codAttore` int(11) NOT NULL AUTO_INCREMENT,
27 `Nome` text,
28 `annoNascita` int(11) DEFAULT NULL,
29 `Nazionalita` text,
30 PRIMARY KEY (`codAttore`)
31) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Dumping data for table `attori`
36--
37
38LOCK TABLES `attori` WRITE;
39/*!40000 ALTER TABLE `attori` DISABLE KEYS */;
40INSERT INTO `attori` VALUES (1,'Giovanni',1954,'Italiano'),(2,'Lukabal',1910,'Ottomano'),(3,'Giovanni',1954,'Italiano'),(4,'Lukabal',1910,'Ottomano'),(5,'Giovanni',1954,'Italiano'),(6,'Lukabal',1910,'Ottomano'),(7,'Giovanni',1954,'Italiano'),(8,'Lukabal',1910,'Ottomano'),(9,'Giovanni',1954,'Italiano'),(10,'Lukabal',1910,'Ottomano'),(11,'Giovanni',1954,'Italiano'),(12,'Lukabal',1910,'Ottomano'),(13,'Giovanni',1954,'Italiano'),(14,'Lukabal',1910,'Ottomano'),(15,'Giovanni',1954,'Italiano'),(16,'Lukabal',1910,'Ottomano'),(17,'Giovanni',1954,'Italiano'),(18,'Lukabal',1910,'Ottomano'),(19,'Giovanni',1954,'Italiano'),(20,'Lukabal',1910,'Ottomano'),(21,'Giovanni',1954,'Italiano'),(22,'Lukabal',1910,'Ottomano');
41/*!40000 ALTER TABLE `attori` ENABLE KEYS */;
42UNLOCK TABLES;
43
44--
45-- Table structure for table `film`
46--
47
48DROP TABLE IF EXISTS `film`;
49/*!40101 SET @saved_cs_client = @@character_set_client */;
50/*!40101 SET character_set_client = utf8 */;
51CREATE TABLE `film` (
52 `codFilm` int(11) NOT NULL AUTO_INCREMENT,
53 `Titolo` text,
54 `annoProduzione` int(11) DEFAULT NULL,
55 `Nazionalita` text,
56 `Regista` text,
57 `codGenere` int(11) NOT NULL,
58 PRIMARY KEY (`codFilm`),
59 KEY `codGenere` (`codGenere`),
60 CONSTRAINT `film_ibfk_1` FOREIGN KEY (`codGenere`) REFERENCES `genere` (`codGenere`) ON DELETE NO ACTION ON UPDATE CASCADE
61) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Dumping data for table `film`
66--
67
68LOCK TABLES `film` WRITE;
69/*!40000 ALTER TABLE `film` DISABLE KEYS */;
70INSERT INTO `film` VALUES (2,'Giusto o bo',2010,'Polacco','Reggione',1),(3,'Giusto o bo',2010,'Polacco','Reggione',1),(4,'Giusto o bo',2010,'Polacco','Reggione',1),(5,'Giusto o bo',2010,'Polacco','Reggione',1),(6,'Giusto o bo',2010,'Polacco','Reggione',1),(7,'Giusto o bo',2010,'Polacco','Reggione',1),(8,'Giusto o bo',2010,'Polacco','Reggione',1),(9,'Giusto o bo',2010,'Polacco','Reggione',1),(10,'Giusto o bo',2010,'Polacco','Reggione',1),(11,'Giusto o bo',2010,'Polacco','Reggione',1);
71/*!40000 ALTER TABLE `film` ENABLE KEYS */;
72UNLOCK TABLES;
73
74--
75-- Table structure for table `genere`
76--
77
78DROP TABLE IF EXISTS `genere`;
79/*!40101 SET @saved_cs_client = @@character_set_client */;
80/*!40101 SET character_set_client = utf8 */;
81CREATE TABLE `genere` (
82 `codGenere` int(11) NOT NULL AUTO_INCREMENT,
83 `Descrizione` text,
84 PRIMARY KEY (`codGenere`)
85) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
86/*!40101 SET character_set_client = @saved_cs_client */;
87
88--
89-- Dumping data for table `genere`
90--
91
92LOCK TABLES `genere` WRITE;
93/*!40000 ALTER TABLE `genere` DISABLE KEYS */;
94INSERT INTO `genere` VALUES (1,'polizesco'),(2,'horror');
95/*!40000 ALTER TABLE `genere` ENABLE KEYS */;
96UNLOCK TABLES;
97
98--
99-- Table structure for table `proiezioni`
100--
101
102DROP TABLE IF EXISTS `proiezioni`;
103/*!40101 SET @saved_cs_client = @@character_set_client */;
104/*!40101 SET character_set_client = utf8 */;
105CREATE TABLE `proiezioni` (
106 `codProiezione` int(11) NOT NULL AUTO_INCREMENT,
107 `codFilm` int(11) NOT NULL,
108 `codSala` int(11) NOT NULL,
109 `Incasso` int(11) DEFAULT NULL,
110 `dataProiezione` text,
111 PRIMARY KEY (`codProiezione`),
112 KEY `codFilm` (`codFilm`),
113 KEY `codSala` (`codSala`),
114 CONSTRAINT `proiezioni_ibfk_1` FOREIGN KEY (`codFilm`) REFERENCES `film` (`codFilm`),
115 CONSTRAINT `proiezioni_ibfk_2` FOREIGN KEY (`codSala`) REFERENCES `sale` (`codSala`)
116) ENGINE=InnoDB DEFAULT CHARSET=latin1;
117/*!40101 SET character_set_client = @saved_cs_client */;
118
119--
120-- Dumping data for table `proiezioni`
121--
122
123LOCK TABLES `proiezioni` WRITE;
124/*!40000 ALTER TABLE `proiezioni` DISABLE KEYS */;
125/*!40000 ALTER TABLE `proiezioni` ENABLE KEYS */;
126UNLOCK TABLES;
127
128--
129-- Table structure for table `recita`
130--
131
132DROP TABLE IF EXISTS `recita`;
133/*!40101 SET @saved_cs_client = @@character_set_client */;
134/*!40101 SET character_set_client = utf8 */;
135CREATE TABLE `recita` (
136 `codAttore` int(11) NOT NULL,
137 `codFilm` int(11) NOT NULL,
138 PRIMARY KEY (`codAttore`,`codFilm`),
139 KEY `codFilm` (`codFilm`),
140 CONSTRAINT `recita_ibfk_1` FOREIGN KEY (`codAttore`) REFERENCES `attori` (`codAttore`) ON DELETE CASCADE ON UPDATE CASCADE,
141 CONSTRAINT `recita_ibfk_2` FOREIGN KEY (`codFilm`) REFERENCES `film` (`codFilm`) ON DELETE CASCADE ON UPDATE CASCADE
142) ENGINE=InnoDB DEFAULT CHARSET=latin1;
143/*!40101 SET character_set_client = @saved_cs_client */;
144
145--
146-- Dumping data for table `recita`
147--
148
149LOCK TABLES `recita` WRITE;
150/*!40000 ALTER TABLE `recita` DISABLE KEYS */;
151/*!40000 ALTER TABLE `recita` ENABLE KEYS */;
152UNLOCK TABLES;
153
154--
155-- Table structure for table `sale`
156--
157
158DROP TABLE IF EXISTS `sale`;
159/*!40101 SET @saved_cs_client = @@character_set_client */;
160/*!40101 SET character_set_client = utf8 */;
161CREATE TABLE `sale` (
162 `codSala` int(11) NOT NULL AUTO_INCREMENT,
163 `Posti` int(11) DEFAULT NULL,
164 `Nome` text,
165 `Citta` text,
166 PRIMARY KEY (`codSala`)
167) ENGINE=InnoDB DEFAULT CHARSET=latin1;
168/*!40101 SET character_set_client = @saved_cs_client */;
169
170--
171-- Dumping data for table `sale`
172--
173
174LOCK TABLES `sale` WRITE;
175/*!40000 ALTER TABLE `sale` DISABLE KEYS */;
176/*!40000 ALTER TABLE `sale` ENABLE KEYS */;
177UNLOCK TABLES;
178/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
179
180/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
181/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
182/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
183/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
184/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
185/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
186/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
187
188-- Dump completed on 2017-12-05 11:29:59