GUIKAR741
4/9/2019 - 12:51 PM
Banco
Banco
-- 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