PkxNs1d8

1# Host: localhost  (Version 5.5.5-10.1.21-MariaDB)
2# Date: 2019-05-22 14:04:56
3# Generator: MySQL-Front 6.0  (Build 2.20)
4
5
6#
7# Structure for table "departamento"
8#
9
10DROP TABLE IF EXISTS `departamento`;
11CREATE TABLE `departamento` (
12  `nome_depto` varchar(255) DEFAULT NULL,
13  `numero_depto` varchar(11) NOT NULL DEFAULT '0'
14) ENGINE=InnoDB DEFAULT CHARSET=latin1;
15
16#
17# Data for table "departamento"
18#
19
20INSERT INTO `departamento` VALUES ('Informação e Sistemas','D003'),('Tecnologia da Informação','D001');
21
22#
23# Structure for table "disciplina"
24#
25
26DROP TABLE IF EXISTS `disciplina`;
27CREATE TABLE `disciplina` (
28  `nome` varchar(255) DEFAULT NULL,
29  `cod_disciplina` varchar(11) NOT NULL DEFAULT '',
30  `carga_horaria` varchar(255) DEFAULT NULL,
31  PRIMARY KEY (`cod_disciplina`)
32) ENGINE=InnoDB DEFAULT CHARSET=latin1;
33
34#
35# Data for table "disciplina"
36#
37
38INSERT INTO `disciplina` VALUES ('Fundamentos de SI','IF973','75h'),('Banco de Dados','IF976','60h'),('Programação 2','IF992','60h');
39
40#
41# Structure for table "ministra"
42#
43
44DROP TABLE IF EXISTS `ministra`;
45CREATE TABLE `ministra` (
46  `siape` int(11) NOT NULL,
47  `cod_disciplina` varchar(255) DEFAULT NULL,
48  `periodo` varchar(255) DEFAULT NULL
49) ENGINE=InnoDB DEFAULT CHARSET=latin1;
50
51#
52# Data for table "ministra"
53#
54
55INSERT INTO `ministra` VALUES (1234,'IF973','2013.1'),(1234,'IF973','2013.2'),(1234,'IF992','2013.1'),(1234,'IF965','2013.1'),(4466,'IF976','2013.2'),(5678,'IF973','2013.2'),(1122,'IF973','2013.2'),(5678,'IF973','2013.2');
56
57#
58# Structure for table "professor"
59#
60
61DROP TABLE IF EXISTS `professor`;
62CREATE TABLE `professor` (
63  `nome` varchar(255) DEFAULT NULL,
64  `siape` int(11) NOT NULL AUTO_INCREMENT,
65  `categoria` varchar(255) DEFAULT NULL,
66  `salario` int(11) DEFAULT NULL,
67  `cod_depto` char(5) DEFAULT NULL,
68  PRIMARY KEY (`siape`)
69) ENGINE=InnoDB DEFAULT CHARSET=latin1;
70
71#
72# Data for table "professor"
73#
74
75INSERT INTO `professor` VALUES ('José',1122,'Adjunto 1',1500,'D003'),('Maria',1234,'Adjunto 1',1000,'D001'),('Pedro',5678,'Adjunto 2',2000,'D001');