Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL dump 10.13 Distrib 5.5.60, for debian-linux-gnu (x86_64)
- --
- -- Host: 10.5.30.4 Database: linha9b
- -- ------------------------------------------------------
- -- Server version 5.7.25
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
- /*!40103 SET TIME_ZONE='+00:00' */;
- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- --
- -- Table structure for table `DEPARTAMENTO`
- --
- DROP TABLE IF EXISTS `DEPARTAMENTO`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `DEPARTAMENTO` (
- `Dnome` varchar(60) NOT NULL,
- `Dnumero` int(11) NOT NULL AUTO_INCREMENT,
- `Cpf_gerente` varchar(14) DEFAULT NULL,
- `Data_inicio_gerente` date NOT NULL,
- PRIMARY KEY (`Dnumero`)
- ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `DEPARTAMENTO`
- --
- LOCK TABLES `DEPARTAMENTO` WRITE;
- /*!40000 ALTER TABLE `DEPARTAMENTO` DISABLE KEYS */;
- INSERT INTO `DEPARTAMENTO` VALUES ('Matriz',1,'88866555576','1981-06-19'),('Administração',4,'98765432168','1995-01-01'),('Pesquisa',5,'33344555587','1988-05-22');
- /*!40000 ALTER TABLE `DEPARTAMENTO` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `DEPENDENTE`
- --
- DROP TABLE IF EXISTS `DEPENDENTE`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `DEPENDENTE` (
- `Fcpf` varchar(14) DEFAULT NULL,
- `Nome_dependente` varchar(60) NOT NULL,
- `Sexo` char(1) NOT NULL,
- `Datanasc` date NOT NULL,
- `Parentesco` varchar(60) NOT NULL,
- PRIMARY KEY (`Nome_dependente`),
- KEY `Fcpf` (`Fcpf`),
- CONSTRAINT `DEPENDENTE_ibfk_1` FOREIGN KEY (`Fcpf`) REFERENCES `FUNCIONARIO` (`Cpf`) ON DELETE SET NULL ON UPDATE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `DEPENDENTE`
- --
- LOCK TABLES `DEPENDENTE` WRITE;
- /*!40000 ALTER TABLE `DEPENDENTE` DISABLE KEYS */;
- /*!40000 ALTER TABLE `DEPENDENTE` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `FUNCIONARIO`
- --
- DROP TABLE IF EXISTS `FUNCIONARIO`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `FUNCIONARIO` (
- `Pnome` varchar(60) NOT NULL,
- `Minicial` varchar(60) NOT NULL,
- `Unome` varchar(60) NOT NULL,
- `Cpf` varchar(14) NOT NULL,
- `Datanasc` date NOT NULL,
- `Endereco` varchar(60) NOT NULL,
- `Sexo` char(1) NOT NULL,
- `Salario` decimal(10,2) NOT NULL,
- `Cpf_supervisor` varchar(14) DEFAULT NULL,
- `Dnr` int(4) DEFAULT NULL,
- PRIMARY KEY (`Cpf`),
- KEY `Cpf_supervisor_fk` (`Cpf_supervisor`),
- KEY `Dnr` (`Dnr`),
- CONSTRAINT `Cpf_supervisor_fk` FOREIGN KEY (`Cpf_supervisor`) REFERENCES `FUNCIONARIO` (`Cpf`) ON DELETE SET NULL ON UPDATE CASCADE,
- CONSTRAINT `FUNCIONARIO_ibfk_1` FOREIGN KEY (`Dnr`) REFERENCES `DEPARTAMENTO` (`Dnumero`) ON DELETE SET NULL ON UPDATE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `FUNCIONARIO`
- --
- LOCK TABLES `FUNCIONARIO` WRITE;
- /*!40000 ALTER TABLE `FUNCIONARIO` DISABLE KEYS */;
- INSERT 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);
- /*!40000 ALTER TABLE `FUNCIONARIO` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `LOCALIZACOES_DEP`
- --
- DROP TABLE IF EXISTS `LOCALIZACOES_DEP`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `LOCALIZACOES_DEP` (
- `Dnumero` int(11) DEFAULT NULL,
- `Dlocal` varchar(60) NOT NULL,
- KEY `dnumero_fk` (`Dnumero`),
- CONSTRAINT `dnumero_fk` FOREIGN KEY (`Dnumero`) REFERENCES `DEPARTAMENTO` (`Dnumero`) ON DELETE SET NULL ON UPDATE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `LOCALIZACOES_DEP`
- --
- LOCK TABLES `LOCALIZACOES_DEP` WRITE;
- /*!40000 ALTER TABLE `LOCALIZACOES_DEP` DISABLE KEYS */;
- INSERT INTO `LOCALIZACOES_DEP` VALUES (1,'São Paulo'),(4,'Mauá'),(5,'Santo André'),(5,'Itu'),(5,'São Paulo');
- /*!40000 ALTER TABLE `LOCALIZACOES_DEP` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `PROJETO`
- --
- DROP TABLE IF EXISTS `PROJETO`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `PROJETO` (
- `Projnome` varchar(60) NOT NULL,
- `Projnumero` int(11) NOT NULL AUTO_INCREMENT,
- `Projlocal` varchar(60) NOT NULL,
- `Dnum` int(11) DEFAULT NULL,
- PRIMARY KEY (`Projnumero`),
- KEY `dnum_fk` (`Dnum`),
- CONSTRAINT `dnum_fk` FOREIGN KEY (`Dnum`) REFERENCES `DEPARTAMENTO` (`Dnumero`) ON DELETE SET NULL ON UPDATE CASCADE
- ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `PROJETO`
- --
- LOCK TABLES `PROJETO` WRITE;
- /*!40000 ALTER TABLE `PROJETO` DISABLE KEYS */;
- INSERT 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);
- /*!40000 ALTER TABLE `PROJETO` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `TRABALHA_EM`
- --
- DROP TABLE IF EXISTS `TRABALHA_EM`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `TRABALHA_EM` (
- `Fcpf` varchar(14) DEFAULT NULL,
- `Pnr` int(11) DEFAULT NULL,
- `Horas` time DEFAULT NULL,
- KEY `fcpf_fk` (`Fcpf`),
- KEY `Pnr` (`Pnr`),
- CONSTRAINT `TRABALHA_EM_ibfk_1` FOREIGN KEY (`Pnr`) REFERENCES `PROJETO` (`Projnumero`) ON DELETE SET NULL ON UPDATE CASCADE,
- CONSTRAINT `fcpf_fk` FOREIGN KEY (`Fcpf`) REFERENCES `FUNCIONARIO` (`Cpf`) ON DELETE SET NULL ON UPDATE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `TRABALHA_EM`
- --
- LOCK TABLES `TRABALHA_EM` WRITE;
- /*!40000 ALTER TABLE `TRABALHA_EM` DISABLE KEYS */;
- INSERT 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);
- /*!40000 ALTER TABLE `TRABALHA_EM` ENABLE KEYS */;
- UNLOCK TABLES;
- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
- -- Dump completed on 2019-04-16 9:51:22
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement