3kcq8LDn

1
2DROP TABLE IF EXISTS `cursos`;
3/*!40101 SET @saved_cs_client     = @@character_set_client */;
4/*!50503 SET character_set_client = utf8mb4 */;
5CREATE TABLE `cursos` (
6  `curso_id` tinyint(4) NOT NULL,
7  `description` text,
8  PRIMARY KEY (`curso_id`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
10/*!40101 SET character_set_client = @saved_cs_client */;
11
12--
13-- Dumping data for table `cursos`
14--
15
16LOCK TABLES `cursos` WRITE;
17/*!40000 ALTER TABLE `cursos` DISABLE KEYS */;
18/*!40000 ALTER TABLE `cursos` ENABLE KEYS */;
19UNLOCK TABLES;
20
21--
22-- Table structure for table `instrutores`
23--
24
25DROP TABLE IF EXISTS `instrutores`;
26/*!40101 SET @saved_cs_client     = @@character_set_client */;
27/*!50503 SET character_set_client = utf8mb4 */;
28CREATE TABLE `instrutores` (
29  `id_instrutor` smallint(6) NOT NULL AUTO_INCREMENT,
30  `data_nascimento` date DEFAULT NULL,
31  `habilidades` json DEFAULT NULL,
32  PRIMARY KEY (`id_instrutor`)
33) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
34/*!40101 SET character_set_client = @saved_cs_client */;
35
36--
37-- Dumping data for table `instrutores`
38--
39
40LOCK TABLES `instrutores` WRITE;
41/*!40000 ALTER TABLE `instrutores` DISABLE KEYS */;
42/*!40000 ALTER TABLE `instrutores` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `salas`
47--
48
49DROP TABLE IF EXISTS `salas`;
50/*!40101 SET @saved_cs_client     = @@character_set_client */;
51/*!50503 SET character_set_client = utf8mb4 */;
52CREATE TABLE `salas` (
53  `id_sala` smallint(6) NOT NULL AUTO_INCREMENT,
54  `descricao` text,
55  `vagas` tinyint(4) DEFAULT NULL,
56  PRIMARY KEY (`id_sala`)
57) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
58/*!40101 SET character_set_client = @saved_cs_client */;