· 8 years ago · Jan 31, 2018, 01:08 PM
1-- MySQL dump 10.13 Distrib 5.7.20, for osx10.13 (x86_64)
2--
3-- Host: localhost Database: Serwerownie
4-- ------------------------------------------------------
5-- Server version 5.7.20
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 `Modele`
20--
21
22DROP TABLE IF EXISTS `Modele`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `Modele` (
26 `IdModelu` int(11) NOT NULL AUTO_INCREMENT,
27 `IdProducenta` int(11) NOT NULL,
28 `Model` varchar(20) NOT NULL,
29 PRIMARY KEY (`IdModelu`),
30 KEY `IdProducenta` (`IdProducenta`),
31 CONSTRAINT `modele_ibfk_1` FOREIGN KEY (`IdProducenta`) REFERENCES `Producenci` (`IdProducenta`)
32) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Dumping data for table `Modele`
37--
38
39LOCK TABLES `Modele` WRITE;
40/*!40000 ALTER TABLE `Modele` DISABLE KEYS */;
41INSERT INTO `Modele` VALUES (1,1,'SmallAndFast'),(2,2,'SmallRAM'),(3,3,'StorageSerwer'),(4,1,'4CPU'),(5,1,'StorageSerwer'),(6,4,'4CPU'),(7,1,'BigMemory'),(8,3,'SuperFast');
42/*!40000 ALTER TABLE `Modele` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `OdpowiadaZaNaprawe`
47--
48
49DROP TABLE IF EXISTS `OdpowiadaZaNaprawe`;
50/*!40101 SET @saved_cs_client = @@character_set_client */;
51/*!40101 SET character_set_client = utf8 */;
52CREATE TABLE `OdpowiadaZaNaprawe` (
53 `IdModelu` int(11) NOT NULL,
54 `IdZespolu` int(11) NOT NULL,
55 PRIMARY KEY (`IdModelu`),
56 KEY `IdZespolu` (`IdZespolu`),
57 CONSTRAINT `odpowiadazanaprawe_ibfk_1` FOREIGN KEY (`IdModelu`) REFERENCES `Modele` (`IdModelu`),
58 CONSTRAINT `odpowiadazanaprawe_ibfk_2` FOREIGN KEY (`IdZespolu`) REFERENCES `ZespolyNaprawcze` (`IdZespolu`)
59) ENGINE=InnoDB DEFAULT CHARSET=utf8;
60/*!40101 SET character_set_client = @saved_cs_client */;
61
62--
63-- Dumping data for table `OdpowiadaZaNaprawe`
64--
65
66LOCK TABLES `OdpowiadaZaNaprawe` WRITE;
67/*!40000 ALTER TABLE `OdpowiadaZaNaprawe` DISABLE KEYS */;
68INSERT INTO `OdpowiadaZaNaprawe` VALUES (1,1),(4,1),(2,2),(5,2),(3,3),(7,3),(8,3),(6,4);
69/*!40000 ALTER TABLE `OdpowiadaZaNaprawe` ENABLE KEYS */;
70UNLOCK TABLES;
71
72--
73-- Table structure for table `Producenci`
74--
75
76DROP TABLE IF EXISTS `Producenci`;
77/*!40101 SET @saved_cs_client = @@character_set_client */;
78/*!40101 SET character_set_client = utf8 */;
79CREATE TABLE `Producenci` (
80 `IdProducenta` int(11) NOT NULL AUTO_INCREMENT,
81 `NazwaProducenta` varchar(40) NOT NULL,
82 PRIMARY KEY (`IdProducenta`)
83) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
84/*!40101 SET character_set_client = @saved_cs_client */;
85
86--
87-- Dumping data for table `Producenci`
88--
89
90LOCK TABLES `Producenci` WRITE;
91/*!40000 ALTER TABLE `Producenci` DISABLE KEYS */;
92INSERT INTO `Producenci` VALUES (1,'ServerKompSA'),(2,'SuperKomp'),(3,'SuperHiperServer'),(4,'FastComp');
93/*!40000 ALTER TABLE `Producenci` ENABLE KEYS */;
94UNLOCK TABLES;
95
96--
97-- Table structure for table `Serwerownie`
98--
99
100DROP TABLE IF EXISTS `Serwerownie`;
101/*!40101 SET @saved_cs_client = @@character_set_client */;
102/*!40101 SET character_set_client = utf8 */;
103CREATE TABLE `Serwerownie` (
104 `IdSerwerowni` int(11) NOT NULL AUTO_INCREMENT,
105 `NazwaSerwerowni` varchar(20) NOT NULL,
106 PRIMARY KEY (`IdSerwerowni`)
107) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
108/*!40101 SET character_set_client = @saved_cs_client */;
109
110--
111-- Dumping data for table `Serwerownie`
112--
113
114LOCK TABLES `Serwerownie` WRITE;
115/*!40000 ALTER TABLE `Serwerownie` DISABLE KEYS */;
116INSERT INTO `Serwerownie` VALUES (1,'RadomServerRoom'),(2,'SosnowiecServerRoom'),(3,'KatowiceServerRoom'),(4,'KrakowServerRoom'),(5,'WarszawaServerRoom');
117/*!40000 ALTER TABLE `Serwerownie` ENABLE KEYS */;
118UNLOCK TABLES;
119
120--
121-- Table structure for table `Umiejscowienia`
122--
123
124DROP TABLE IF EXISTS `Umiejscowienia`;
125/*!40101 SET @saved_cs_client = @@character_set_client */;
126/*!40101 SET character_set_client = utf8 */;
127CREATE TABLE `Umiejscowienia` (
128 `IdModelu` int(11) NOT NULL,
129 `IdSerwerowni` int(11) NOT NULL,
130 `Ilosc` int(11) DEFAULT '0',
131 PRIMARY KEY (`IdModelu`,`IdSerwerowni`),
132 KEY `IdSerwerowni` (`IdSerwerowni`),
133 CONSTRAINT `umiejscowienia_ibfk_1` FOREIGN KEY (`IdSerwerowni`) REFERENCES `Serwerownie` (`IdSerwerowni`),
134 CONSTRAINT `umiejscowienia_ibfk_2` FOREIGN KEY (`IdModelu`) REFERENCES `Modele` (`IdModelu`)
135) ENGINE=InnoDB DEFAULT CHARSET=utf8;
136/*!40101 SET character_set_client = @saved_cs_client */;
137
138--
139-- Dumping data for table `Umiejscowienia`
140--
141
142LOCK TABLES `Umiejscowienia` WRITE;
143/*!40000 ALTER TABLE `Umiejscowienia` DISABLE KEYS */;
144INSERT INTO `Umiejscowienia` VALUES (1,1,5),(1,2,2),(1,3,2),(1,5,2),(2,1,3),(2,2,5),(2,3,5),(2,4,5),(2,5,5),(3,1,10),(3,2,10),(4,1,5),(5,2,11),(6,2,3),(6,3,6),(6,4,2),(6,5,10),(7,3,4),(7,4,4),(8,4,10),(8,5,20);
145/*!40000 ALTER TABLE `Umiejscowienia` ENABLE KEYS */;
146UNLOCK TABLES;
147
148--
149-- Table structure for table `Zadania`
150--
151
152DROP TABLE IF EXISTS `Zadania`;
153/*!40101 SET @saved_cs_client = @@character_set_client */;
154/*!40101 SET character_set_client = utf8 */;
155CREATE TABLE `Zadania` (
156 `IdZadania` int(11) NOT NULL AUTO_INCREMENT,
157 `Opis` text NOT NULL,
158 `IdMainSerwerownia` int(11) NOT NULL,
159 `IdAuxSerwerownia` int(11) DEFAULT NULL,
160 PRIMARY KEY (`IdZadania`),
161 KEY `IdMainSerwerownia` (`IdMainSerwerownia`),
162 KEY `IdAuxSerwerownia` (`IdAuxSerwerownia`),
163 CONSTRAINT `zadania_ibfk_1` FOREIGN KEY (`IdMainSerwerownia`) REFERENCES `Serwerownie` (`IdSerwerowni`),
164 CONSTRAINT `zadania_ibfk_2` FOREIGN KEY (`IdAuxSerwerownia`) REFERENCES `Serwerownie` (`IdSerwerowni`)
165) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
166/*!40101 SET character_set_client = @saved_cs_client */;
167
168--
169-- Dumping data for table `Zadania`
170--
171
172LOCK TABLES `Zadania` WRITE;
173/*!40000 ALTER TABLE `Zadania` DISABLE KEYS */;
174INSERT INTO `Zadania` VALUES (1,'Backup',4,2),(2,'Cloud',1,2),(3,'WWW serwer dla firmy ABC',5,2),(4,'WWW serwer dla firmy DEF',5,3),(5,'WWW serwer dla firmy GHI',3,4),(6,'BigData',2,1),(7,'DataBase',2,4),(8,'CVS dla firmy XYZ',1,4),(9,'CVS dla firmy ZYX',1,2);
175/*!40000 ALTER TABLE `Zadania` ENABLE KEYS */;
176UNLOCK TABLES;
177
178--
179-- Table structure for table `ZespolyNaprawcze`
180--
181
182DROP TABLE IF EXISTS `ZespolyNaprawcze`;
183/*!40101 SET @saved_cs_client = @@character_set_client */;
184/*!40101 SET character_set_client = utf8 */;
185CREATE TABLE `ZespolyNaprawcze` (
186 `IdZespolu` int(11) NOT NULL AUTO_INCREMENT,
187 `NazwaZespolu` varchar(20) NOT NULL,
188 PRIMARY KEY (`IdZespolu`)
189) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
190/*!40101 SET character_set_client = @saved_cs_client */;
191
192--
193-- Dumping data for table `ZespolyNaprawcze`
194--
195
196LOCK TABLES `ZespolyNaprawcze` WRITE;
197/*!40000 ALTER TABLE `ZespolyNaprawcze` DISABLE KEYS */;
198INSERT INTO `ZespolyNaprawcze` VALUES (1,'SerwisKomp'),(2,'FastSerwis'),(3,'CheapSerwis'),(4,'SuperFastSerwis');
199/*!40000 ALTER TABLE `ZespolyNaprawcze` ENABLE KEYS */;
200UNLOCK TABLES;
201
202--
203-- Table structure for table `Zlecenia`
204--
205
206DROP TABLE IF EXISTS `Zlecenia`;
207/*!40101 SET @saved_cs_client = @@character_set_client */;
208/*!40101 SET character_set_client = utf8 */;
209CREATE TABLE `Zlecenia` (
210 `IdZadania` int(11) NOT NULL AUTO_INCREMENT,
211 `IdSerwerowni` int(11) NOT NULL,
212 PRIMARY KEY (`IdZadania`),
213 KEY `IdSerwerowni` (`IdSerwerowni`),
214 CONSTRAINT `zlecenia_ibfk_1` FOREIGN KEY (`IdZadania`) REFERENCES `Zadania` (`IdZadania`),
215 CONSTRAINT `zlecenia_ibfk_2` FOREIGN KEY (`IdSerwerowni`) REFERENCES `Serwerownie` (`IdSerwerowni`)
216) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
217/*!40101 SET character_set_client = @saved_cs_client */;
218
219--
220-- Dumping data for table `Zlecenia`
221--
222
223LOCK TABLES `Zlecenia` WRITE;
224/*!40000 ALTER TABLE `Zlecenia` DISABLE KEYS */;
225INSERT INTO `Zlecenia` VALUES (2,2),(6,2),(7,2),(9,2),(5,3),(1,4),(8,4),(3,5),(4,5);
226/*!40000 ALTER TABLE `Zlecenia` ENABLE KEYS */;
227UNLOCK TABLES;
228/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
229
230/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
231/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
232/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
233/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
234/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
235/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
236/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
237
238-- Dump completed on 2018-01-31 2:34:25