4RtKssG0

1-- MySQL dump 10.13  Distrib 8.0.23, for Win64 (x86_64)
2--
3-- Host: localhost    Database: db_alunos
4-- ------------------------------------------------------
5-- Server version	5.7.31
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/*!50503 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 `aluno`
20--
21
22DROP TABLE IF EXISTS `aluno`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!50503 SET character_set_client = utf8mb4 */;
25CREATE TABLE `aluno` (
26  `NUMMATR` varchar(7) NOT NULL,
27  `CODCUR` varchar(6) DEFAULT NULL,
28  `NOME` varchar(45) DEFAULT NULL,
29  `NASCIMENTO` datetime DEFAULT NULL,
30  `BOLSA` float DEFAULT '0',
31  `E_MAIL` varchar(25) DEFAULT NULL,
32  `CodEmpr` varchar(4) DEFAULT NULL,
33  `Funcao` varchar(10) DEFAULT NULL,
34  `DataInicio` datetime DEFAULT NULL,
35  `DataFim` datetime DEFAULT NULL,
36  PRIMARY KEY (`NUMMATR`),
37  KEY `CodEmpr` (`CodEmpr`),
38  KEY `CODCUR` (`CODCUR`)
39) ENGINE=MyISAM DEFAULT CHARSET=utf8;
40/*!40101 SET character_set_client = @saved_cs_client */;
41
42--
43-- Dumping data for table `aluno`
44--
45
46LOCK TABLES `aluno` WRITE;
47/*!40000 ALTER TABLE `aluno` DISABLE KEYS */;
48/*!40000 ALTER TABLE `aluno` ENABLE KEYS */;
49UNLOCK TABLES;
50
51--
52-- Table structure for table `curriculo`
53--
54
55DROP TABLE IF EXISTS `curriculo`;
56/*!40101 SET @saved_cs_client     = @@character_set_client */;
57/*!50503 SET character_set_client = utf8mb4 */;
58CREATE TABLE `curriculo` (
59  `CODCUR` varchar(6) NOT NULL,
60  `CODDISC` varchar(6) NOT NULL,
61  PRIMARY KEY (`CODCUR`,`CODDISC`),
62  KEY `CODDISC` (`CODDISC`),
63  KEY `CODCUR` (`CODCUR`)
64) ENGINE=MyISAM DEFAULT CHARSET=utf8;
65/*!40101 SET character_set_client = @saved_cs_client */;
66
67--
68-- Dumping data for table `curriculo`
69--
70
71LOCK TABLES `curriculo` WRITE;
72/*!40000 ALTER TABLE `curriculo` DISABLE KEYS */;
73/*!40000 ALTER TABLE `curriculo` ENABLE KEYS */;
74UNLOCK TABLES;
75
76--
77-- Table structure for table `curso`
78--
79
80DROP TABLE IF EXISTS `curso`;
81/*!40101 SET @saved_cs_client     = @@character_set_client */;
82/*!50503 SET character_set_client = utf8mb4 */;
83CREATE TABLE `curso` (
84  `CODCURSO` varchar(6) NOT NULL,
85  `NOME` varchar(45) DEFAULT NULL,
86  PRIMARY KEY (`CODCURSO`)
87) ENGINE=MyISAM DEFAULT CHARSET=utf8;
88/*!40101 SET character_set_client = @saved_cs_client */;
89
90--
91-- Dumping data for table `curso`
92--
93
94LOCK TABLES `curso` WRITE;
95/*!40000 ALTER TABLE `curso` DISABLE KEYS */;
96/*!40000 ALTER TABLE `curso` ENABLE KEYS */;
97UNLOCK TABLES;
98
99--
100-- Table structure for table `disciplina`
101--
102
103DROP TABLE IF EXISTS `disciplina`;
104/*!40101 SET @saved_cs_client     = @@character_set_client */;
105/*!50503 SET character_set_client = utf8mb4 */;
106CREATE TABLE `disciplina` (
107  `CODDISC` varchar(6) NOT NULL,
108  `NOME` varchar(45) DEFAULT NULL,
109  PRIMARY KEY (`CODDISC`)
110) ENGINE=MyISAM DEFAULT CHARSET=utf8;
111/*!40101 SET character_set_client = @saved_cs_client */;
112
113--
114-- Dumping data for table `disciplina`
115--
116
117LOCK TABLES `disciplina` WRITE;
118/*!40000 ALTER TABLE `disciplina` DISABLE KEYS */;
119/*!40000 ALTER TABLE `disciplina` ENABLE KEYS */;
120UNLOCK TABLES;
121
122--
123-- Table structure for table `empresa`
124--
125
126DROP TABLE IF EXISTS `empresa`;
127/*!40101 SET @saved_cs_client     = @@character_set_client */;
128/*!50503 SET character_set_client = utf8mb4 */;
129CREATE TABLE `empresa` (
130  `CodEmpr` varchar(4) NOT NULL,
131  `Nome` varchar(30) DEFAULT NULL,
132  `Endereco` varchar(30) DEFAULT NULL,
133  PRIMARY KEY (`CodEmpr`)
134) ENGINE=MyISAM DEFAULT CHARSET=utf8;
135/*!40101 SET character_set_client = @saved_cs_client */;
136
137--
138-- Dumping data for table `empresa`
139--
140
141LOCK TABLES `empresa` WRITE;
142/*!40000 ALTER TABLE `empresa` DISABLE KEYS */;
143/*!40000 ALTER TABLE `empresa` ENABLE KEYS */;
144UNLOCK TABLES;
145
146--
147-- Table structure for table `nota`
148--
149
150DROP TABLE IF EXISTS `nota`;
151/*!40101 SET @saved_cs_client     = @@character_set_client */;
152/*!50503 SET character_set_client = utf8mb4 */;
153CREATE TABLE `nota` (
154  `CODDISC` varchar(6) NOT NULL,
155  `NUMMATR` varchar(7) NOT NULL,
156  `P1` float DEFAULT '0',
157  `P2` float DEFAULT '0',
158  `P3` float DEFAULT '0',
159  `P4` float DEFAULT '0',
160  `P5` float DEFAULT '0',
161  PRIMARY KEY (`CODDISC`,`NUMMATR`),
162  KEY `CODDISC` (`CODDISC`),
163  KEY `NUMMATR` (`NUMMATR`)
164) ENGINE=MyISAM DEFAULT CHARSET=utf8;
165/*!40101 SET character_set_client = @saved_cs_client */;
166
167--
168-- Dumping data for table `nota`
169--
170
171LOCK TABLES `nota` WRITE;
172/*!40000 ALTER TABLE `nota` DISABLE KEYS */;
173/*!40000 ALTER TABLE `nota` ENABLE KEYS */;
174UNLOCK TABLES;
175
176--
177-- Dumping events for database 'db_alunos'
178--
179
180--
181-- Dumping routines for database 'db_alunos'
182--
183/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
184
185/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
186/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
187/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
188/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
189/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
190/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
191/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
192
193-- Dump completed on 2021-04-16 20:21:13
194