SCMKVrBr

1-- MySQL dump 10.13  Distrib 5.7.20, for Linux (x86_64)
2--
3-- Host: localhost    Database: atividade2
4-- ------------------------------------------------------
5-- Server version	5.7.22-0ubuntu18.04.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 `dependentes`
20--
21
22DROP TABLE IF EXISTS `dependentes`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `dependentes` (
26  `depen_id` int(11) NOT NULL AUTO_INCREMENT,
27  `depen_nome` varchar(50) NOT NULL,
28  PRIMARY KEY (`depen_id`)
29) ENGINE=InnoDB DEFAULT CHARSET=latin1;
30/*!40101 SET character_set_client = @saved_cs_client */;
31
32--
33-- Dumping data for table `dependentes`
34--
35
36LOCK TABLES `dependentes` WRITE;
37/*!40000 ALTER TABLE `dependentes` DISABLE KEYS */;
38/*!40000 ALTER TABLE `dependentes` ENABLE KEYS */;
39UNLOCK TABLES;
40
41--
42-- Table structure for table `funcionarios`
43--
44
45DROP TABLE IF EXISTS `funcionarios`;
46/*!40101 SET @saved_cs_client     = @@character_set_client */;
47/*!40101 SET character_set_client = utf8 */;
48CREATE TABLE `funcionarios` (
49  `func_id` int(11) NOT NULL AUTO_INCREMENT,
50  `func_cpf` int(11) NOT NULL,
51  `func_servico` varchar(40) DEFAULT NULL,
52  `func_nome` varchar(50) NOT NULL,
53  PRIMARY KEY (`func_id`),
54  UNIQUE KEY `func_id_UNIQUE` (`func_id`),
55  UNIQUE KEY `func_cpf_UNIQUE` (`func_cpf`)
56) ENGINE=InnoDB DEFAULT CHARSET=latin1;
57/*!40101 SET character_set_client = @saved_cs_client */;
58
59--
60-- Dumping data for table `funcionarios`
61--
62
63LOCK TABLES `funcionarios` WRITE;
64/*!40000 ALTER TABLE `funcionarios` DISABLE KEYS */;
65/*!40000 ALTER TABLE `funcionarios` ENABLE KEYS */;
66UNLOCK TABLES;
67
68--
69-- Table structure for table `servicos`
70--
71
72DROP TABLE IF EXISTS `servicos`;
73/*!40101 SET @saved_cs_client     = @@character_set_client */;
74/*!40101 SET character_set_client = utf8 */;
75CREATE TABLE `servicos` (
76  `serv_id` int(11) NOT NULL AUTO_INCREMENT,
77  `serv_nome` varchar(50) DEFAULT NULL,
78  PRIMARY KEY (`serv_id`),
79  UNIQUE KEY `serv_id_UNIQUE` (`serv_id`)
80) ENGINE=InnoDB DEFAULT CHARSET=latin1;
81/*!40101 SET character_set_client = @saved_cs_client */;
82
83--
84-- Dumping data for table `servicos`
85--
86
87LOCK TABLES `servicos` WRITE;
88/*!40000 ALTER TABLE `servicos` DISABLE KEYS */;
89/*!40000 ALTER TABLE `servicos` ENABLE KEYS */;
90UNLOCK TABLES;
91/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
92
93/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
94/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
95/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
96/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
97/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
98/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
99/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
100
101-- Dump completed on 2018-08-21 11:06:16