· 8 years ago · Jan 11, 2018, 03:48 PM
1-- MySQL dump 10.13 Distrib 5.7.20, for Linux (x86_64)
2--
3-- Host: localhost Database: softwareCompany
4-- ------------------------------------------------------
5-- Server version 5.7.20-0ubuntu0.17.10.1
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 `engineer`
20--
21
22DROP TABLE IF EXISTS `engineer`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `engineer` (
26 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
27 `name` varchar(255) NOT NULL,
28 `birthday` date NOT NULL,
29 `zeut` int(11) unsigned NOT NULL,
30 `specialization` int(11) unsigned DEFAULT NULL,
31 PRIMARY KEY (`id`),
32 KEY `sid` (`specialization`),
33 CONSTRAINT `sid` FOREIGN KEY (`specialization`) REFERENCES `softwareField` (`id`) ON DELETE SET NULL
34) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
35/*!40101 SET character_set_client = @saved_cs_client */;
36
37--
38-- Dumping data for table `engineer`
39--
40
41LOCK TABLES `engineer` WRITE;
42/*!40000 ALTER TABLE `engineer` DISABLE KEYS */;
43INSERT INTO `engineer` VALUES (1,'Gay Goed','1985-11-21',334863079,2),(2,'Rowena Searle','1951-12-11',317275303,5),(3,'Madelaine Klemensiewicz','1962-08-23',293204669,3),(4,'Rupert Whittles','1969-02-04',396703129,4),(5,'Ysabel Crasswell','1967-09-21',252405726,2),(6,'Kristy Siggs','1968-05-23',243458684,2),(7,'Carroll Bridgwater','1990-07-04',302481182,2),(8,'Lenna Morpeth','1996-01-06',265435780,2),(9,'Daven Poytheras','1982-05-14',230138029,4),(10,'Zabrina Genever','1985-10-25',230416357,1),(11,'Camey Chessum','1991-07-19',220408449,1),(12,'Minny Bruckenthal','1968-09-11',373724511,3),(13,'Samson Harmston','1992-12-25',321844146,1),(14,'Geoffry Aizlewood','1976-05-09',305256781,5),(15,'Christa Jahn','1993-02-07',313420675,2),(16,'Jilli Iceton','1957-11-15',358226982,3);
44/*!40000 ALTER TABLE `engineer` ENABLE KEYS */;
45UNLOCK TABLES;
46/*!50003 SET @saved_cs_client = @@character_set_client */ ;
47/*!50003 SET @saved_cs_results = @@character_set_results */ ;
48/*!50003 SET @saved_col_connection = @@collation_connection */ ;
49/*!50003 SET character_set_client = latin1 */ ;
50/*!50003 SET character_set_results = latin1 */ ;
51/*!50003 SET collation_connection = latin1_swedish_ci */ ;
52/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
53/*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
54DELIMITER ;;
55/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER engineer_before_update BEFORE UPDATE ON engineer FOR EACH ROW
56BEGIN
57 INSERT INTO engineer_audit SET
58 action = 'update',
59 engineerId = OLD.id,
60 name = OLD.name,
61 birthday = OLD.birthday,
62 zeut = OLD.zeut,
63 specialization = OLD.specialization;
64 END */;;
65DELIMITER ;
66/*!50003 SET sql_mode = @saved_sql_mode */ ;
67/*!50003 SET character_set_client = @saved_cs_client */ ;
68/*!50003 SET character_set_results = @saved_cs_results */ ;
69/*!50003 SET collation_connection = @saved_col_connection */ ;
70/*!50003 SET @saved_cs_client = @@character_set_client */ ;
71/*!50003 SET @saved_cs_results = @@character_set_results */ ;
72/*!50003 SET @saved_col_connection = @@collation_connection */ ;
73/*!50003 SET character_set_client = latin1 */ ;
74/*!50003 SET character_set_results = latin1 */ ;
75/*!50003 SET collation_connection = latin1_swedish_ci */ ;
76/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
77/*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
78DELIMITER ;;
79/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER engineer_before_delete BEFORE DELETE ON engineer FOR EACH ROW
80 BEGIN
81 INSERT INTO engineer_audit SET
82 action = 'delete',
83 engineerId = OLD.id,
84 name = OLD.name,
85 birthday = OLD.birthday,
86 zeut = OLD.zeut,
87 specialization = OLD.specialization;
88 END */;;
89DELIMITER ;
90/*!50003 SET sql_mode = @saved_sql_mode */ ;
91/*!50003 SET character_set_client = @saved_cs_client */ ;
92/*!50003 SET character_set_results = @saved_cs_results */ ;
93/*!50003 SET collation_connection = @saved_col_connection */ ;
94
95--
96-- Table structure for table `engineerAddress`
97--
98
99DROP TABLE IF EXISTS `engineerAddress`;
100/*!40101 SET @saved_cs_client = @@character_set_client */;
101/*!40101 SET character_set_client = utf8 */;
102CREATE TABLE `engineerAddress` (
103 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
104 `city` varchar(255) NOT NULL,
105 `street` varchar(255) NOT NULL,
106 `country` varchar(255) NOT NULL,
107 `zip` varchar(255) NOT NULL,
108 `engineerId` int(11) unsigned NOT NULL,
109 PRIMARY KEY (`id`),
110 KEY `eidEA` (`engineerId`),
111 CONSTRAINT `eidEA` FOREIGN KEY (`engineerId`) REFERENCES `engineer` (`id`) ON DELETE CASCADE
112) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
113/*!40101 SET character_set_client = @saved_cs_client */;
114
115--
116-- Dumping data for table `engineerAddress`
117--
118
119LOCK TABLES `engineerAddress` WRITE;
120/*!40000 ALTER TABLE `engineerAddress` DISABLE KEYS */;
121INSERT INTO `engineerAddress` VALUES (1,'Galatás','38 Stone Corner Pass','Greece','90415',1),(2,'Cabiao','7 Sage Hill','Philippines','58813',2),(3,'Larochette','73 Knutson Park','Luxembourg','54213',3),(4,'Nîmes','81 Bobwhite Circle','France','71902',4),(5,'Krivodanovka','6 Colorado Terrace','Russia','85740',5),(6,'Novo-Peredelkino','7 Corben Park','Russia','64452',6),(7,'Estancia','178 Steensland Road','Philippines','58187',7),(8,'Xiangcheng','691 Marquette Park','China','75668',8),(9,'Hisings Kärra','7324 Mallard Point','Sweden','35431',9),(10,'Beloye','8506 Sugar Parkway','Russia','90021',10),(11,'Resende','2016 Thackeray Crossing','Portugal','64770',11),(12,'Songshi','2 Scoville Street','China','47734',12),(13,'Guohe','30293 Cordelia Lane','China','97710',13),(14,'Chimboy Shahri','850 Kings Circle','Uzbekistan','89865',14),(15,'Caseros','317 Luster Lane','Argentina','54407',15),(16,'Luleå','7 Acker Road','Sweden','52261',16);
122/*!40000 ALTER TABLE `engineerAddress` ENABLE KEYS */;
123UNLOCK TABLES;
124
125--
126-- Table structure for table `engineerPhones`
127--
128
129DROP TABLE IF EXISTS `engineerPhones`;
130/*!40101 SET @saved_cs_client = @@character_set_client */;
131/*!40101 SET character_set_client = utf8 */;
132CREATE TABLE `engineerPhones` (
133 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
134 `phone` varchar(30) NOT NULL,
135 `engineerId` int(11) unsigned NOT NULL,
136 PRIMARY KEY (`id`),
137 KEY `eidEP` (`engineerId`),
138 CONSTRAINT `eidEP` FOREIGN KEY (`engineerId`) REFERENCES `engineer` (`id`) ON DELETE CASCADE
139) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
140/*!40101 SET character_set_client = @saved_cs_client */;
141
142--
143-- Dumping data for table `engineerPhones`
144--
145
146LOCK TABLES `engineerPhones` WRITE;
147/*!40000 ALTER TABLE `engineerPhones` DISABLE KEYS */;
148INSERT INTO `engineerPhones` VALUES (1,'57991884',1),(2,'55281340',2),(3,'58330469',3),(4,'56364075',4),(5,'59916278',5),(6,'59632974',6),(7,'55589975',7),(8,'57568987',8),(9,'55944875',9),(10,'50855864',10),(11,'55459403',11),(12,'52125981',12),(13,'56832305',13),(14,'56333672',14),(15,'59395698',15),(16,'59246758',16);
149/*!40000 ALTER TABLE `engineerPhones` ENABLE KEYS */;
150UNLOCK TABLES;
151
152--
153-- Table structure for table `engineer_audit`
154--
155
156DROP TABLE IF EXISTS `engineer_audit`;
157/*!40101 SET @saved_cs_client = @@character_set_client */;
158/*!40101 SET character_set_client = utf8 */;
159CREATE TABLE `engineer_audit` (
160 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
161 `engineerId` int(11) unsigned NOT NULL,
162 `name` varchar(255) NOT NULL,
163 `birthday` date NOT NULL,
164 `zeut` int(11) unsigned NOT NULL,
165 `specialization` int(11) unsigned DEFAULT NULL,
166 `action` varchar(50) DEFAULT NULL,
167 `changedate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
168 PRIMARY KEY (`id`)
169) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
170/*!40101 SET character_set_client = @saved_cs_client */;
171
172--
173-- Dumping data for table `engineer_audit`
174--
175
176LOCK TABLES `engineer_audit` WRITE;
177/*!40000 ALTER TABLE `engineer_audit` DISABLE KEYS */;
178INSERT INTO `engineer_audit` VALUES (1,1,'Gay Goede','1985-11-21',334863079,2,'update','2018-01-10 16:08:03');
179/*!40000 ALTER TABLE `engineer_audit` ENABLE KEYS */;
180UNLOCK TABLES;
181
182--
183-- Table structure for table `grades`
184--
185
186DROP TABLE IF EXISTS `grades`;
187/*!40101 SET @saved_cs_client = @@character_set_client */;
188/*!40101 SET character_set_client = utf8 */;
189CREATE TABLE `grades` (
190 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
191 `value` int(11) NOT NULL,
192 `data` date NOT NULL,
193 `projectId` int(11) unsigned NOT NULL,
194 `engineerId` int(11) unsigned NOT NULL,
195 PRIMARY KEY (`id`),
196 UNIQUE KEY `UK_Tools` (`projectId`,`engineerId`,`data`),
197 KEY `eidG` (`engineerId`),
198 CONSTRAINT `eidG` FOREIGN KEY (`engineerId`) REFERENCES `engineer` (`id`) ON DELETE CASCADE,
199 CONSTRAINT `pidG` FOREIGN KEY (`projectId`) REFERENCES `project` (`id`) ON DELETE CASCADE
200) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
201/*!40101 SET character_set_client = @saved_cs_client */;
202
203--
204-- Dumping data for table `grades`
205--
206
207LOCK TABLES `grades` WRITE;
208/*!40000 ALTER TABLE `grades` DISABLE KEYS */;
209INSERT INTO `grades` VALUES (1,10,'2018-01-01',5,1),(2,6,'2018-01-01',7,1),(3,4,'2017-01-01',3,4),(5,4,'2017-02-01',3,4),(6,2,'2017-03-01',3,4),(7,6,'2017-04-01',3,4),(8,7,'2017-05-01',3,4),(9,8,'2017-06-01',3,4),(10,2,'2017-07-01',3,4),(11,1,'2017-08-01',3,4),(12,7,'2017-09-01',3,4),(13,9,'2017-10-01',3,4),(14,9,'2017-11-01',3,4),(15,9,'2017-12-01',3,4),(16,10,'2018-01-01',6,10),(17,6,'2018-01-01',7,14),(18,7,'2018-01-01',6,14);
210/*!40000 ALTER TABLE `grades` ENABLE KEYS */;
211UNLOCK TABLES;
212/*!50003 SET @saved_cs_client = @@character_set_client */ ;
213/*!50003 SET @saved_cs_results = @@character_set_results */ ;
214/*!50003 SET @saved_col_connection = @@collation_connection */ ;
215/*!50003 SET character_set_client = latin1 */ ;
216/*!50003 SET character_set_results = latin1 */ ;
217/*!50003 SET collation_connection = latin1_swedish_ci */ ;
218/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
219/*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
220DELIMITER ;;
221/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER grades_before_update BEFORE UPDATE ON grades FOR EACH ROW
222BEGIN
223 INSERT INTO grades_audit SET
224 action = 'update',
225 gradesId = OLD.id,
226 value = OLD.value,
227 data = OLD.data,
228 projectId = OLD.projectId,
229 engineerId = OLD.engineerId;
230 END */;;
231DELIMITER ;
232/*!50003 SET sql_mode = @saved_sql_mode */ ;
233/*!50003 SET character_set_client = @saved_cs_client */ ;
234/*!50003 SET character_set_results = @saved_cs_results */ ;
235/*!50003 SET collation_connection = @saved_col_connection */ ;
236/*!50003 SET @saved_cs_client = @@character_set_client */ ;
237/*!50003 SET @saved_cs_results = @@character_set_results */ ;
238/*!50003 SET @saved_col_connection = @@collation_connection */ ;
239/*!50003 SET character_set_client = latin1 */ ;
240/*!50003 SET character_set_results = latin1 */ ;
241/*!50003 SET collation_connection = latin1_swedish_ci */ ;
242/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
243/*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
244DELIMITER ;;
245/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER grades_before_delete BEFORE DELETE ON grades FOR EACH ROW
246 BEGIN
247 INSERT INTO grades_audit SET
248 action = 'delete',
249 gradesId = OLD.id,
250 value = OLD.value,
251 data = OLD.data,
252 projectId = OLD.projectId,
253 engineerId = OLD.engineerId;
254 END */;;
255DELIMITER ;
256/*!50003 SET sql_mode = @saved_sql_mode */ ;
257/*!50003 SET character_set_client = @saved_cs_client */ ;
258/*!50003 SET character_set_results = @saved_cs_results */ ;
259/*!50003 SET collation_connection = @saved_col_connection */ ;
260
261--
262-- Table structure for table `grades_audit`
263--
264
265DROP TABLE IF EXISTS `grades_audit`;
266/*!40101 SET @saved_cs_client = @@character_set_client */;
267/*!40101 SET character_set_client = utf8 */;
268CREATE TABLE `grades_audit` (
269 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
270 `gradesId` int(11) unsigned NOT NULL,
271 `value` int(11) NOT NULL,
272 `data` date NOT NULL,
273 `projectId` int(11) unsigned NOT NULL,
274 `engineerId` int(11) unsigned NOT NULL,
275 `action` varchar(50) DEFAULT NULL,
276 `changedate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
277 PRIMARY KEY (`id`)
278) ENGINE=InnoDB DEFAULT CHARSET=latin1;
279/*!40101 SET character_set_client = @saved_cs_client */;
280
281--
282-- Dumping data for table `grades_audit`
283--
284
285LOCK TABLES `grades_audit` WRITE;
286/*!40000 ALTER TABLE `grades_audit` DISABLE KEYS */;
287/*!40000 ALTER TABLE `grades_audit` ENABLE KEYS */;
288UNLOCK TABLES;
289
290--
291-- Table structure for table `milestone`
292--
293
294DROP TABLE IF EXISTS `milestone`;
295/*!40101 SET @saved_cs_client = @@character_set_client */;
296/*!40101 SET character_set_client = utf8 */;
297CREATE TABLE `milestone` (
298 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
299 `name` varchar(50) NOT NULL,
300 `startdate` date NOT NULL,
301 `enddate` date NOT NULL,
302 `moneysum` decimal(15,2) NOT NULL,
303 `done` tinyint(4) DEFAULT '0',
304 `description` varchar(255) NOT NULL,
305 `projectId` int(11) unsigned NOT NULL,
306 PRIMARY KEY (`id`),
307 KEY `pidM` (`projectId`),
308 CONSTRAINT `pidM` FOREIGN KEY (`projectId`) REFERENCES `project` (`id`) ON DELETE CASCADE
309) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
310/*!40101 SET character_set_client = @saved_cs_client */;
311
312--
313-- Dumping data for table `milestone`
314--
315
316LOCK TABLES `milestone` WRITE;
317/*!40000 ALTER TABLE `milestone` DISABLE KEYS */;
318INSERT INTO `milestone` VALUES (1,'Vulpes vulpes','2018-01-04','2019-01-12',20214.82,0,'Unsp bus occupant injured in clsn w oth and unsp mv nontraf',6),(2,'Eolophus roseicapillus','2018-01-17','2019-05-14',55284.63,0,'Other disorders of continuity of bone, right humerus',5),(3,'Varanus komodensis','2018-01-05','2019-03-17',54193.51,0,'Other ossification of muscle, unspecified site',2),(4,'Nycticorax nycticorax','2018-01-04','2019-11-09',72610.50,0,'Nondisplaced oblique fracture of shaft of left radius, init',1),(5,'Bos mutus','2018-01-17','2019-03-17',30033.99,0,'Adverse effect of amphetamines',5),(6,'Martes americana','2018-01-06','2019-06-24',88490.15,0,'Unsp athscl nonaut bio bypass of the extrm, bilateral legs',3),(7,'Boa caninus','2018-01-25','2019-11-20',62229.28,0,'Surg instrumnt,matrl & gen hosp/persnl-use dev assoc w incdt',7),(8,'Sciurus niger','2018-01-25','2019-08-22',72175.25,0,'Fracture of nasal bones, subs for fx w delay heal',7),(9,'Ramphastos tucanus','2018-01-29','2019-08-05',53906.66,0,'Nondisp bimalleol fx l low leg, subs for clos fx w malunion',8),(10,'Cacatua tenuirostris','2018-01-05','2019-09-28',92593.01,0,'Lacerat extn musc/fasc/tend l rng fngr at wrs/hnd lv, sqla',2),(11,'Ciconia ciconia','2018-01-10','2019-04-14',94300.90,0,'Bathroom in prison as place',4),(12,'unavailable','2018-01-04','2019-06-08',53693.70,0,'Toxic effect of contact w Portugese Man-o-war, undet, init',6),(13,'Coendou prehensilis','2018-01-17','2019-09-01',42344.06,0,'Athscl autol vein bypass of the extrm w rest pain, right leg',5),(14,'Felis concolor','2018-01-25','2020-01-04',98848.70,0,'Schmorl\'s nodes, thoracolumbar region',7),(15,'Hymenolaimus malacorhynchus','2018-01-04','2019-09-29',54480.60,0,'Other hypertrophic osteoarthropathy, left hand',1),(16,'Haematopus ater','2018-01-25','2019-12-19',29126.17,0,'Burn of unspecified degree of left shoulder, init encntr',7),(17,'Bubo virginianus','2018-01-06','2019-04-18',91909.77,0,'Inj deep peroneal nrv at ank/ft level, right leg, sequela',3),(18,'Bassariscus astutus','2018-01-06','2019-07-16',61892.67,0,'Cont preg aft spon abort of one fts or more, third tri, fts4',3),(19,'Sciurus vulgaris','2018-01-04','2019-02-13',82835.00,0,'Acute pancreatitis without necrosis or infection, unsp',9),(20,'Physignathus cocincinus','2018-01-04','2019-06-17',65078.92,0,'Disp fx of low epiphy (separation) of r femr, 7thG',9);
319/*!40000 ALTER TABLE `milestone` ENABLE KEYS */;
320UNLOCK TABLES;
321
322--
323-- Table structure for table `project`
324--
325
326DROP TABLE IF EXISTS `project`;
327/*!40101 SET @saved_cs_client = @@character_set_client */;
328/*!40101 SET character_set_client = utf8 */;
329CREATE TABLE `project` (
330 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
331 `name` varchar(255) NOT NULL,
332 `startdate` date NOT NULL,
333 `description` varchar(255) NOT NULL,
334 `stage` tinyint(4) DEFAULT '1',
335 PRIMARY KEY (`id`)
336) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
337/*!40101 SET character_set_client = @saved_cs_client */;
338
339--
340-- Dumping data for table `project`
341--
342
343LOCK TABLES `project` WRITE;
344/*!40000 ALTER TABLE `project` DISABLE KEYS */;
345INSERT INTO `project` VALUES (1,'Nicolas LLC','2017-01-04','Nondisp fx of medial cuneiform of unspecified foot, sequela',6),(2,'Wisozk-Quigley','2018-01-05','Siderosis',5),(3,'Goyette Inc','2017-01-06','Corrosion of second degree of right ankle and foot, sequela',1),(4,'Mitchell, Schulist and Koch','2018-01-10','3-part fx surgical neck of l humerus, subs for fx w malunion',1),(5,'Price, Renner and Weissnat','2018-01-17','Toxic effect of venom of venomous lizard, self-harm, init',1),(6,'Schinner-Halvorson','2018-01-04','Displacement of carotid arterial graft (bypass), init encntr',1),(7,'Huels LLC','2018-01-25','Displ suprcndl fx w intrcndl extn low end r femr, 7thJ',1),(8,'Sawayn-Kuhic','2018-01-29','Displ seg fx shaft of r tibia, init for opn fx type 3A/B/C',1),(9,'Kessler, Erdman and Gorczany','2018-01-04','Toxic effect of cadmium and its compounds, undet, sequela',1);
346/*!40000 ALTER TABLE `project` ENABLE KEYS */;
347UNLOCK TABLES;
348/*!50003 SET @saved_cs_client = @@character_set_client */ ;
349/*!50003 SET @saved_cs_results = @@character_set_results */ ;
350/*!50003 SET @saved_col_connection = @@collation_connection */ ;
351/*!50003 SET character_set_client = latin1 */ ;
352/*!50003 SET character_set_results = latin1 */ ;
353/*!50003 SET collation_connection = latin1_swedish_ci */ ;
354/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
355/*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
356DELIMITER ;;
357/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER project_before_update BEFORE UPDATE ON project FOR EACH ROW
358 BEGIN
359 INSERT INTO project_audit SET
360 action = 'update',
361 projectId = OLD.id,
362 name = OLD.name,
363 startdate = OLD.startdate,
364 description = OLD.description,
365 stage = OLD.stage;
366 END */;;
367DELIMITER ;
368/*!50003 SET sql_mode = @saved_sql_mode */ ;
369/*!50003 SET character_set_client = @saved_cs_client */ ;
370/*!50003 SET character_set_results = @saved_cs_results */ ;
371/*!50003 SET collation_connection = @saved_col_connection */ ;
372/*!50003 SET @saved_cs_client = @@character_set_client */ ;
373/*!50003 SET @saved_cs_results = @@character_set_results */ ;
374/*!50003 SET @saved_col_connection = @@collation_connection */ ;
375/*!50003 SET character_set_client = latin1 */ ;
376/*!50003 SET character_set_results = latin1 */ ;
377/*!50003 SET collation_connection = latin1_swedish_ci */ ;
378/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
379/*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
380DELIMITER ;;
381/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER project_before_delete BEFORE DELETE ON project FOR EACH ROW
382 BEGIN
383 INSERT INTO project_audit SET
384 action = 'delete',
385 projectId = OLD.id,
386 name = OLD.name,
387 startdate = OLD.startdate,
388 description = OLD.description,
389 stage = OLD.stage;
390 END */;;
391DELIMITER ;
392/*!50003 SET sql_mode = @saved_sql_mode */ ;
393/*!50003 SET character_set_client = @saved_cs_client */ ;
394/*!50003 SET character_set_results = @saved_cs_results */ ;
395/*!50003 SET collation_connection = @saved_col_connection */ ;
396
397--
398-- Table structure for table `projectSoftware`
399--
400
401DROP TABLE IF EXISTS `projectSoftware`;
402/*!40101 SET @saved_cs_client = @@character_set_client */;
403/*!40101 SET character_set_client = utf8 */;
404CREATE TABLE `projectSoftware` (
405 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
406 `name` varchar(50) NOT NULL,
407 `projectId` int(11) unsigned NOT NULL,
408 PRIMARY KEY (`id`),
409 KEY `pidS` (`projectId`),
410 CONSTRAINT `pidS` FOREIGN KEY (`projectId`) REFERENCES `project` (`id`) ON DELETE CASCADE
411) ENGINE=InnoDB DEFAULT CHARSET=latin1;
412/*!40101 SET character_set_client = @saved_cs_client */;
413
414--
415-- Dumping data for table `projectSoftware`
416--
417
418LOCK TABLES `projectSoftware` WRITE;
419/*!40000 ALTER TABLE `projectSoftware` DISABLE KEYS */;
420/*!40000 ALTER TABLE `projectSoftware` ENABLE KEYS */;
421UNLOCK TABLES;
422
423--
424-- Table structure for table `project_audit`
425--
426
427DROP TABLE IF EXISTS `project_audit`;
428/*!40101 SET @saved_cs_client = @@character_set_client */;
429/*!40101 SET character_set_client = utf8 */;
430CREATE TABLE `project_audit` (
431 `id` int(11) NOT NULL AUTO_INCREMENT,
432 `projectId` int(11) NOT NULL,
433 `name` varchar(255) NOT NULL,
434 `startdate` date NOT NULL,
435 `description` varchar(255) NOT NULL,
436 `stage` tinyint(4) DEFAULT '1',
437 `action` varchar(50) DEFAULT NULL,
438 `changedate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
439 PRIMARY KEY (`id`)
440) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
441/*!40101 SET character_set_client = @saved_cs_client */;
442
443--
444-- Dumping data for table `project_audit`
445--
446
447LOCK TABLES `project_audit` WRITE;
448/*!40000 ALTER TABLE `project_audit` DISABLE KEYS */;
449INSERT INTO `project_audit` VALUES (1,1,'Nicolas LLC','2018-01-04','Nondisp fx of medial cuneiform of unspecified foot, sequela',1,'update','2018-01-10 16:04:20'),(2,1,'Nicolas LLC','2018-01-04','Nondisp fx of medial cuneiform of unspecified foot, sequela',6,'update','2018-01-10 16:28:12'),(3,3,'Goyette Inc','2018-01-06','Corrosion of second degree of right ankle and foot, sequela',1,'update','2018-01-10 16:49:46');
450/*!40000 ALTER TABLE `project_audit` ENABLE KEYS */;
451UNLOCK TABLES;
452
453--
454-- Table structure for table `softwareField`
455--
456
457DROP TABLE IF EXISTS `softwareField`;
458/*!40101 SET @saved_cs_client = @@character_set_client */;
459/*!40101 SET character_set_client = utf8 */;
460CREATE TABLE `softwareField` (
461 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
462 `name` varchar(255) NOT NULL,
463 `specialization` varchar(255) NOT NULL,
464 PRIMARY KEY (`id`)
465) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
466/*!40101 SET character_set_client = @saved_cs_client */;
467
468--
469-- Dumping data for table `softwareField`
470--
471
472LOCK TABLES `softwareField` WRITE;
473/*!40000 ALTER TABLE `softwareField` DISABLE KEYS */;
474INSERT INTO `softwareField` VALUES (1,'Undergraduate','Engineers Undergraduated'),(2,'Graduated','Engineers Graduated'),(3,'Master','Engineer with a Master Degree'),(4,'Doctorate','Engineer with a Doctorate'),(5,'Nobel Prize Winner','Engineer with a Nobel Prize');
475/*!40000 ALTER TABLE `softwareField` ENABLE KEYS */;
476UNLOCK TABLES;
477
478--
479-- Table structure for table `stages`
480--
481
482DROP TABLE IF EXISTS `stages`;
483/*!40101 SET @saved_cs_client = @@character_set_client */;
484/*!40101 SET character_set_client = utf8 */;
485CREATE TABLE `stages` (
486 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
487 `name` varchar(255) NOT NULL,
488 PRIMARY KEY (`id`)
489) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
490/*!40101 SET character_set_client = @saved_cs_client */;
491
492--
493-- Dumping data for table `stages`
494--
495
496LOCK TABLES `stages` WRITE;
497/*!40000 ALTER TABLE `stages` DISABLE KEYS */;
498INSERT INTO `stages` VALUES (1,'Config'),(2,'Task Management'),(3,'Planning'),(4,'Require Management'),(5,'Design Coding'),(6,'Unit Testing'),(7,'Software Testing');
499/*!40000 ALTER TABLE `stages` ENABLE KEYS */;
500UNLOCK TABLES;
501
502--
503-- Table structure for table `tools`
504--
505
506DROP TABLE IF EXISTS `tools`;
507/*!40101 SET @saved_cs_client = @@character_set_client */;
508/*!40101 SET character_set_client = utf8 */;
509CREATE TABLE `tools` (
510 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
511 `name` varchar(255) NOT NULL,
512 PRIMARY KEY (`id`)
513) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
514/*!40101 SET character_set_client = @saved_cs_client */;
515
516--
517-- Dumping data for table `tools`
518--
519
520LOCK TABLES `tools` WRITE;
521/*!40000 ALTER TABLE `tools` DISABLE KEYS */;
522INSERT INTO `tools` VALUES (1,'Github'),(2,'Asana'),(3,'Artificial intelligence'),(4,'Rapid prototyping'),(5,'Natural language processing'),(6,'Instagram'),(7,'A/B testing'),(8,'C++'),(9,'Swift'),(10,'Brand strategy'),(11,'Marketo marketing automation'),(12,'Penetration testing'),(13,'Docker development'),(14,'Relationship management'),(16,'AngularJS development'),(17,'Accounting (CPA)'),(18,'Machine learning'),(19,'JIRA administration');
523/*!40000 ALTER TABLE `tools` ENABLE KEYS */;
524UNLOCK TABLES;
525
526--
527-- Table structure for table `toolsProjects`
528--
529
530DROP TABLE IF EXISTS `toolsProjects`;
531/*!40101 SET @saved_cs_client = @@character_set_client */;
532/*!40101 SET character_set_client = utf8 */;
533CREATE TABLE `toolsProjects` (
534 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
535 `projectId` int(11) unsigned NOT NULL,
536 `toolsId` int(11) unsigned NOT NULL,
537 `stageId` int(11) unsigned DEFAULT '1',
538 PRIMARY KEY (`id`),
539 UNIQUE KEY `UK_Tools` (`projectId`,`toolsId`,`stageId`),
540 KEY `tidT` (`toolsId`),
541 KEY `sidT` (`stageId`),
542 CONSTRAINT `pidT` FOREIGN KEY (`projectId`) REFERENCES `project` (`id`) ON DELETE CASCADE,
543 CONSTRAINT `sidT` FOREIGN KEY (`stageId`) REFERENCES `stages` (`id`) ON DELETE CASCADE,
544 CONSTRAINT `tidT` FOREIGN KEY (`toolsId`) REFERENCES `tools` (`id`) ON DELETE CASCADE
545) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=latin1;
546/*!40101 SET character_set_client = @saved_cs_client */;
547
548--
549-- Dumping data for table `toolsProjects`
550--
551
552LOCK TABLES `toolsProjects` WRITE;
553/*!40000 ALTER TABLE `toolsProjects` DISABLE KEYS */;
554INSERT INTO `toolsProjects` VALUES (37,1,1,3),(40,1,1,4),(88,1,1,7),(25,1,2,1),(63,1,6,6),(5,1,8,2),(82,1,9,3),(4,1,10,2),(42,1,16,3),(60,1,17,1),(67,1,18,2),(41,2,2,4),(81,2,4,4),(53,2,4,6),(90,2,5,5),(38,2,7,3),(29,2,7,4),(52,2,8,1),(17,2,10,2),(39,2,10,7),(97,2,11,7),(54,2,12,1),(6,2,12,5),(68,2,14,1),(98,2,14,6),(62,2,18,1),(18,2,19,6),(50,3,1,5),(15,3,2,7),(73,3,4,1),(19,3,4,6),(56,3,4,7),(45,3,5,2),(84,3,5,6),(34,3,10,2),(92,3,13,7),(14,3,14,2),(9,3,17,4),(24,4,1,6),(99,4,4,4),(2,4,7,2),(3,4,7,4),(7,4,9,4),(91,4,10,2),(48,4,16,5),(78,4,17,6),(102,5,1,1),(70,5,1,3),(86,5,5,2),(26,5,5,4),(85,5,5,7),(103,5,6,1),(33,5,8,2),(49,5,9,3),(21,5,12,5),(80,5,19,7),(31,6,2,5),(44,6,5,2),(47,6,5,5),(8,6,8,6),(59,6,9,6),(43,6,10,1),(32,6,12,3),(79,6,12,5),(30,6,13,3),(23,6,16,3),(65,6,16,7),(64,6,18,5),(101,7,1,1),(13,7,5,7),(77,7,12,2),(96,7,13,5),(10,7,14,1),(72,7,14,4),(27,7,18,2),(57,7,19,3),(36,8,1,3),(46,8,1,6),(94,8,3,4),(71,8,4,6),(12,8,5,2),(51,8,11,2),(100,8,14,3),(76,8,14,4),(16,8,16,6),(95,9,2,2),(55,9,8,6),(20,9,9,2),(58,9,11,3),(87,9,11,7),(69,9,13,3),(89,9,16,5),(74,9,17,4);
555/*!40000 ALTER TABLE `toolsProjects` ENABLE KEYS */;
556UNLOCK TABLES;
557
558--
559-- Table structure for table `works`
560--
561
562DROP TABLE IF EXISTS `works`;
563/*!40101 SET @saved_cs_client = @@character_set_client */;
564/*!40101 SET character_set_client = utf8 */;
565CREATE TABLE `works` (
566 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
567 `projectId` int(11) unsigned NOT NULL,
568 `engineerId` int(11) unsigned NOT NULL,
569 PRIMARY KEY (`id`),
570 UNIQUE KEY `UK_Tools` (`projectId`,`engineerId`),
571 KEY `eidW` (`engineerId`),
572 CONSTRAINT `eidW` FOREIGN KEY (`engineerId`) REFERENCES `engineer` (`id`) ON DELETE CASCADE,
573 CONSTRAINT `pidW` FOREIGN KEY (`projectId`) REFERENCES `project` (`id`) ON DELETE CASCADE
574) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;
575/*!40101 SET character_set_client = @saved_cs_client */;
576
577--
578-- Dumping data for table `works`
579--
580
581LOCK TABLES `works` WRITE;
582/*!40000 ALTER TABLE `works` DISABLE KEYS */;
583INSERT INTO `works` VALUES (1,1,1),(10,1,14),(19,2,1),(20,2,6),(2,2,8),(21,2,11),(11,2,14),(3,3,3),(12,3,14),(4,4,3),(13,4,14),(5,5,11),(14,5,14),(6,6,10),(22,6,14),(16,7,14),(7,7,15),(17,8,14),(8,8,16),(9,9,2),(18,9,14);
584/*!40000 ALTER TABLE `works` ENABLE KEYS */;
585UNLOCK TABLES;
586/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
587
588/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
589/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
590/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
591/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
592/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
593/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
594/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
595
596-- Dump completed on 2018-01-10 17:33:12