· 5 years ago · Mar 02, 2020, 11:20 AM
1-- DB Corrigida by Anderson
2-- MySQL dump 10.13 Distrib 8.0.19, for Win64 (x86_64)
3--
4-- Host: localhost Database: sistemapromo
5-- ------------------------------------------------------
6-- Server version 8.0.19
7CREATE DATABASE aula4;
8USE aula4;
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/*!50503 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 `departamento`
22--
23
24
25DROP TABLE IF EXISTS `departamento`;
26/*!40101 SET @saved_cs_client = @@character_set_client */;
27/*!50503 SET character_set_client = utf8mb4 */;
28CREATE TABLE `departamento` (
29 `NRO_DPTO` int NOT NULL AUTO_INCREMENT,
30 `NOME` varchar(30) DEFAULT NULL,
31 `COD_GER` int DEFAULT NULL,
32 PRIMARY KEY (`NRO_DPTO`)
33);
34
35
36--
37-- Dumping data for table `departamento`
38--
39
40LOCK TABLES `departamento` WRITE;
41/*!40000 ALTER TABLE `departamento` DISABLE KEYS */;
42INSERT INTO `departamento` VALUES (1,'PRESIDENCIA',10),(2,'DIRETORIA',11),(3,'ASSESSORIA ESPECIAL',13),(4,'MARKETING',15),(5,'INFORMATICA',18),(6,'PESSOAL',24),(7,'ENGENHARIA',36),(8,'PRODUCAO',31);
43/*!40000 ALTER TABLE `departamento` ENABLE KEYS */;
44UNLOCK TABLES;
45
46--
47-- Table structure for table `funcionario`
48--
49
50DROP TABLE IF EXISTS `funcionario`;
51
52CREATE TABLE `funcionario` (
53 `COD_FUNC` int NOT NULL,
54 `NOME` varchar(50) DEFAULT NULL,
55 `DTA_NASC` date DEFAULT NULL,
56 `SALARIO` float DEFAULT NULL,
57 `NRO_DPTO` int DEFAULT NULL,
58 `COD_GER` int DEFAULT NULL,
59 PRIMARY KEY (`COD_FUNC`),
60 KEY `NRO_DPTO` (`NRO_DPTO`),
61 CONSTRAINT `funcionario_ibfk_1` FOREIGN KEY (`NRO_DPTO`) REFERENCES `departamento` (`NRO_DPTO`)
62);
63/*!40101 SET character_set_client = @saved_cs_client */;
64
65--
66-- Dumping data for table `funcionario`
67--
68
69LOCK TABLES `funcionario` WRITE;
70/*!40000 ALTER TABLE `funcionario` DISABLE KEYS */;
71INSERT INTO `funcionario` VALUES (10,'MARCELO PANINI','1955-12-31',25000,1,NULL),(11,'AUGUSTA ROCHA','1963-09-29',25000,2,10),(12,'CARLOS AUGUSTO DISRAELI','1961-03-29',20000,2,10),(13,'MARCIA MARIA COSTA','1956-01-01',2500,3,12),(14,'ARNALDO NOVELLI','1960-08-10',20000,2,10),(15,'ANDREA LEMOS','1965-12-25',2500,4,11),(16,'GERALDO SANTOS','1970-10-15',5000,4,14),(17,'NADIA PIERCING','1968-01-12',750,5,16),(18,'CIBELE MARIA DO COUTO','1972-02-19',4000,5,12),(19,'MARCO ANTONIO C. BRANCO','1964-06-14',4000,5,16),(20,'PEDRO RIBEIRO','1961-10-12',4000,5,16),(21,'LUIZ CARLOS PINHEIRO','1962-11-12',4000,5,16),(22,'JOSE MANUEL RIBEIRO','1979-12-31',200,5,16),(23,'MARCOS CRUZ','1958-04-30',20000,2,10);
72/*!40000 ALTER TABLE `funcionario` ENABLE KEYS */;
73UNLOCK TABLES;
74
75--
76-- Table structure for table `participacao`
77--
78
79DROP TABLE IF EXISTS `participacao`;
80/*!40101 SET @saved_cs_client = @@character_set_client */;
81/*!50503 SET character_set_client = utf8mb4 */;
82CREATE TABLE `participacao` (
83 `COD_PROJ` char(3) NOT NULL,
84 `COD_FUNC` int NOT NULL,
85 `HORAS_TRAB` int DEFAULT NULL,
86 PRIMARY KEY (`COD_PROJ`),
87 KEY `COD_FUNC` (`COD_FUNC`),
88 CONSTRAINT `participacao_ibfk_1` FOREIGN KEY (`COD_FUNC`) REFERENCES `funcionario` (`COD_FUNC`)
89) ;
90
91
92--
93-- Dumping data for table `participacao`
94--
95
96LOCK TABLES `participacao` WRITE;
97/*!40000 ALTER TABLE `participacao` DISABLE KEYS */;
98INSERT INTO `participacao` VALUES ('CLA',13,100),('CLI',16,110),('FAT',19,40),('PRO',22,85),('WEB',17,120),('WET',19,30);
99/*!40000 ALTER TABLE `participacao` ENABLE KEYS */;
100UNLOCK TABLES;
101
102--
103-- Table structure for table `projeto`
104--
105
106DROP TABLE IF EXISTS `projeto`;
107/*!40101 SET @saved_cs_client = @@character_set_client */;
108/*!50503 SET character_set_client = utf8mb4 */;
109CREATE TABLE `projeto` (
110 `COD_PROJ` char(3) NOT NULL,
111 `NOME` varchar(50) DEFAULT NULL,
112 `DURACAO` int DEFAULT NULL,
113 `NRO_DPTO` int DEFAULT NULL,
114 PRIMARY KEY (`COD_PROJ`),
115 KEY `NRO_DPTO` (`NRO_DPTO`),
116 CONSTRAINT `projeto_ibfk_1` FOREIGN KEY (`NRO_DPTO`) REFERENCES `departamento` (`NRO_DPTO`)
117) ;
118/*!40101 SET character_set_client = @saved_cs_client */;
119
120--
121-- Dumping data for table `projeto`
122--
123
124LOCK TABLES `projeto` WRITE;
125/*!40000 ALTER TABLE `projeto` DISABLE KEYS */;
126INSERT INTO `projeto` VALUES ('CLI','CAPTACAO CLIENTES',4,4),('FAT','FATURAMENTO',6,4),('WEB','INTRANET',3,5);
127/*!40000 ALTER TABLE `projeto` ENABLE KEYS */;
128UNLOCK TABLES;
129/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
130
131/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
132/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
133/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
134/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
135/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
136/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
137/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
138
139-- Dump completed on 2020-03-01 22:43:06