· 6 years ago · Apr 19, 2019, 09:32 AM
1-- MySQL dump 10.13 Distrib 5.5.60, for debian-linux-gnu (x86_64)
2--
3-- Host: 10.5.30.4 Database: linha9b
4-- ------------------------------------------------------
5-- Server version 5.7.25
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 `DEPARTAMENTO`
20--
21
22DROP TABLE IF EXISTS `DEPARTAMENTO`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `DEPARTAMENTO` (
26 `Dnome` varchar(60) NOT NULL,
27 `Dnumero` int(11) NOT NULL AUTO_INCREMENT,
28 `Cpf_gerente` varchar(14) DEFAULT NULL,
29 `Data_inicio_gerente` date NOT NULL,
30 PRIMARY KEY (`Dnumero`)
31) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Dumping data for table `DEPARTAMENTO`
36--
37
38LOCK TABLES `DEPARTAMENTO` WRITE;
39/*!40000 ALTER TABLE `DEPARTAMENTO` DISABLE KEYS */;
40INSERT INTO `DEPARTAMENTO` VALUES ('Matriz',1,'88866555576','1981-06-19'),('Administração',4,'98765432168','1995-01-01'),('Pesquisa',5,'33344555587','1988-05-22');
41/*!40000 ALTER TABLE `DEPARTAMENTO` ENABLE KEYS */;
42UNLOCK TABLES;
43
44--
45-- Table structure for table `DEPENDENTE`
46--
47
48DROP TABLE IF EXISTS `DEPENDENTE`;
49/*!40101 SET @saved_cs_client = @@character_set_client */;
50/*!40101 SET character_set_client = utf8 */;
51CREATE TABLE `DEPENDENTE` (
52 `Fcpf` varchar(14) DEFAULT NULL,
53 `Nome_dependente` varchar(60) NOT NULL,
54 `Sexo` char(1) NOT NULL,
55 `Datanasc` date NOT NULL,
56 `Parentesco` varchar(60) NOT NULL,
57 PRIMARY KEY (`Nome_dependente`),
58 KEY `Fcpf` (`Fcpf`),
59 CONSTRAINT `DEPENDENTE_ibfk_1` FOREIGN KEY (`Fcpf`) REFERENCES `FUNCIONARIO` (`Cpf`) ON DELETE SET NULL ON UPDATE CASCADE
60) ENGINE=InnoDB DEFAULT CHARSET=latin1;
61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Dumping data for table `DEPENDENTE`
65--
66
67LOCK TABLES `DEPENDENTE` WRITE;
68/*!40000 ALTER TABLE `DEPENDENTE` DISABLE KEYS */;
69/*!40000 ALTER TABLE `DEPENDENTE` ENABLE KEYS */;
70UNLOCK TABLES;
71
72--
73-- Table structure for table `FUNCIONARIO`
74--
75
76DROP TABLE IF EXISTS `FUNCIONARIO`;
77/*!40101 SET @saved_cs_client = @@character_set_client */;
78/*!40101 SET character_set_client = utf8 */;
79CREATE TABLE `FUNCIONARIO` (
80 `Pnome` varchar(60) NOT NULL,
81 `Minicial` varchar(60) NOT NULL,
82 `Unome` varchar(60) NOT NULL,
83 `Cpf` varchar(14) NOT NULL,
84 `Datanasc` date NOT NULL,
85 `Endereco` varchar(60) NOT NULL,
86 `Sexo` char(1) NOT NULL,
87 `Salario` decimal(10,2) NOT NULL,
88 `Cpf_supervisor` varchar(14) DEFAULT NULL,
89 `Dnr` int(4) DEFAULT NULL,
90 PRIMARY KEY (`Cpf`),
91 KEY `Cpf_supervisor_fk` (`Cpf_supervisor`),
92 KEY `Dnr` (`Dnr`),
93 CONSTRAINT `Cpf_supervisor_fk` FOREIGN KEY (`Cpf_supervisor`) REFERENCES `FUNCIONARIO` (`Cpf`) ON DELETE SET NULL ON UPDATE CASCADE,
94 CONSTRAINT `FUNCIONARIO_ibfk_1` FOREIGN KEY (`Dnr`) REFERENCES `DEPARTAMENTO` (`Dnumero`) ON DELETE SET NULL ON UPDATE CASCADE
95) ENGINE=InnoDB DEFAULT CHARSET=latin1;
96/*!40101 SET character_set_client = @saved_cs_client */;
97
98--
99-- Dumping data for table `FUNCIONARIO`
100--
101
102LOCK TABLES `FUNCIONARIO` WRITE;
103/*!40000 ALTER TABLE `FUNCIONARIO` DISABLE KEYS */;
104INSERT INTO `FUNCIONARIO` VALUES ('João','B','Silva','12345678966','1965-01-09','Rua das Flores, 751, São Paulo, SP','M',30.00,'33344555587',5),('Fernando','T','Wong','33344555587','1955-12-08','Rua da Lapa 34, São Paulo, SP','M',40.00,'88866555576',5),('Joice','A','Leite','45345345376','1972-07-31','Av. Lucas Obes, 74, São Paulo, SP','F',25.00,NULL,NULL),('Ronaldo','K','Lima','66688444476','1962-09-15','Rua Rebouças, 65, Piracicaba, SP','M',38.00,'33344555587',5),('Jorge','E','Brito','88866555576','1937-11-10','Rua do Horto, 35, São Paulo, SP','M',55.00,NULL,1),('Jennifer','S','Souza','98765432168','1941-06-20','Av. Arthur de Lima, 54, Santo André, SP','F',43.00,'88866555576',4),('André','V','Pereira','98798798733','1969-03-29','Rua Timbira, 35, São Paulo, SP','M',25.00,'98765432168',4),('Alice','J','Zelaya','99988777767','1968-01-19','Rua Souza Lima, 35, Curitiba, PR','F',25.00,'98765432168',4);
105/*!40000 ALTER TABLE `FUNCIONARIO` ENABLE KEYS */;
106UNLOCK TABLES;
107
108--
109-- Table structure for table `LOCALIZACOES_DEP`
110--
111
112DROP TABLE IF EXISTS `LOCALIZACOES_DEP`;
113/*!40101 SET @saved_cs_client = @@character_set_client */;
114/*!40101 SET character_set_client = utf8 */;
115CREATE TABLE `LOCALIZACOES_DEP` (
116 `Dnumero` int(11) DEFAULT NULL,
117 `Dlocal` varchar(60) NOT NULL,
118 KEY `dnumero_fk` (`Dnumero`),
119 CONSTRAINT `dnumero_fk` FOREIGN KEY (`Dnumero`) REFERENCES `DEPARTAMENTO` (`Dnumero`) ON DELETE SET NULL ON UPDATE CASCADE
120) ENGINE=InnoDB DEFAULT CHARSET=latin1;
121/*!40101 SET character_set_client = @saved_cs_client */;
122
123--
124-- Dumping data for table `LOCALIZACOES_DEP`
125--
126
127LOCK TABLES `LOCALIZACOES_DEP` WRITE;
128/*!40000 ALTER TABLE `LOCALIZACOES_DEP` DISABLE KEYS */;
129INSERT INTO `LOCALIZACOES_DEP` VALUES (1,'São Paulo'),(4,'Mauá'),(5,'Santo André'),(5,'Itu'),(5,'São Paulo');
130/*!40000 ALTER TABLE `LOCALIZACOES_DEP` ENABLE KEYS */;
131UNLOCK TABLES;
132
133--
134-- Table structure for table `PROJETO`
135--
136
137DROP TABLE IF EXISTS `PROJETO`;
138/*!40101 SET @saved_cs_client = @@character_set_client */;
139/*!40101 SET character_set_client = utf8 */;
140CREATE TABLE `PROJETO` (
141 `Projnome` varchar(60) NOT NULL,
142 `Projnumero` int(11) NOT NULL AUTO_INCREMENT,
143 `Projlocal` varchar(60) NOT NULL,
144 `Dnum` int(11) DEFAULT NULL,
145 PRIMARY KEY (`Projnumero`),
146 KEY `dnum_fk` (`Dnum`),
147 CONSTRAINT `dnum_fk` FOREIGN KEY (`Dnum`) REFERENCES `DEPARTAMENTO` (`Dnumero`) ON DELETE SET NULL ON UPDATE CASCADE
148) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
149/*!40101 SET character_set_client = @saved_cs_client */;
150
151--
152-- Dumping data for table `PROJETO`
153--
154
155LOCK TABLES `PROJETO` WRITE;
156/*!40000 ALTER TABLE `PROJETO` DISABLE KEYS */;
157INSERT INTO `PROJETO` VALUES ('ProdutoX',1,'Santo André',5),('ProdutoY',2,'Itu',5),('ProdutoZ',3,'São Paulo',5),('Informatização',10,'Mauá',4),('Reorganização',20,'São Paulo',1),('Novosbeneficios',30,'Mauá',4);
158/*!40000 ALTER TABLE `PROJETO` ENABLE KEYS */;
159UNLOCK TABLES;
160
161--
162-- Table structure for table `TRABALHA_EM`
163--
164
165DROP TABLE IF EXISTS `TRABALHA_EM`;
166/*!40101 SET @saved_cs_client = @@character_set_client */;
167/*!40101 SET character_set_client = utf8 */;
168CREATE TABLE `TRABALHA_EM` (
169 `Fcpf` varchar(14) DEFAULT NULL,
170 `Pnr` int(11) DEFAULT NULL,
171 `Horas` time DEFAULT NULL,
172 KEY `fcpf_fk` (`Fcpf`),
173 KEY `Pnr` (`Pnr`),
174 CONSTRAINT `TRABALHA_EM_ibfk_1` FOREIGN KEY (`Pnr`) REFERENCES `PROJETO` (`Projnumero`) ON DELETE SET NULL ON UPDATE CASCADE,
175 CONSTRAINT `fcpf_fk` FOREIGN KEY (`Fcpf`) REFERENCES `FUNCIONARIO` (`Cpf`) ON DELETE SET NULL ON UPDATE CASCADE
176) ENGINE=InnoDB DEFAULT CHARSET=latin1;
177/*!40101 SET character_set_client = @saved_cs_client */;
178
179--
180-- Dumping data for table `TRABALHA_EM`
181--
182
183LOCK TABLES `TRABALHA_EM` WRITE;
184/*!40000 ALTER TABLE `TRABALHA_EM` DISABLE KEYS */;
185INSERT INTO `TRABALHA_EM` VALUES ('12345678966',1,'00:00:33'),('12345678966',2,'00:00:08'),('66688444476',3,'00:00:40'),('45345345376',1,'00:00:20'),('45345345376',2,'00:00:20'),('33344555587',2,'00:00:10'),('33344555587',3,'00:00:10'),('33344555587',10,'00:00:10'),('33344555587',20,'00:00:10'),('99988777767',30,'00:00:30'),('99988777767',10,'00:00:10'),('98765432168',10,'00:00:35'),('98765432168',30,'00:00:05'),('98765432168',30,'00:00:20'),('98765432168',20,'00:00:15'),('88866555576',20,NULL);
186/*!40000 ALTER TABLE `TRABALHA_EM` ENABLE KEYS */;
187UNLOCK TABLES;
188/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
189
190/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
191/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
192/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
193/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
194/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
195/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
196/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
197
198-- Dump completed on 2019-04-16 9:51:22