· 9 years ago · Oct 18, 2016, 10:12 PM
1-- phpMyAdmin SQL Dump
2-- version 3.3.9.2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 18, 2016 at 07:46 PM
7-- Server version: 5.5.10
8-- PHP Version: 5.3.6
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12
13/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16/*!40101 SET NAMES utf8 */;
17
18--
19-- Database: `fecipteste`
20--
21
22-- --------------------------------------------------------
23
24--
25-- Table structure for table `abril`
26--
27
28CREATE TABLE IF NOT EXISTS `abril` (
29 `id` int(255) NOT NULL AUTO_INCREMENT,
30 `dia` int(255) NOT NULL,
31 `mes` int(255) NOT NULL,
32 `ano` int(255) NOT NULL,
33 `matricula` int(255) NOT NULL,
34 `hora` varchar(255) NOT NULL,
35 PRIMARY KEY (`id`)
36) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
37
38--
39-- Dumping data for table `abril`
40--
41
42
43-- --------------------------------------------------------
44
45--
46-- Table structure for table `admin`
47--
48
49CREATE TABLE IF NOT EXISTS `admin` (
50 `id` int(11) NOT NULL AUTO_INCREMENT,
51 `username` varchar(255) NOT NULL,
52 `pw` int(255) NOT NULL,
53 PRIMARY KEY (`id`)
54) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
55
56--
57-- Dumping data for table `admin`
58--
59
60INSERT INTO `admin` (`id`, `username`, `pw`) VALUES
61(1, 'paula', 123);
62
63-- --------------------------------------------------------
64
65--
66-- Table structure for table `agenda`
67--
68
69CREATE TABLE IF NOT EXISTS `agenda` (
70 `id` int(11) NOT NULL AUTO_INCREMENT,
71 `data` varchar(255) NOT NULL,
72 `acontec` varchar(255) NOT NULL,
73 PRIMARY KEY (`id`)
74) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
75
76--
77-- Dumping data for table `agenda`
78--
79
80INSERT INTO `agenda` (`id`, `data`, `acontec`) VALUES
81(11, '31/10/2016', 'FECIP.');
82
83-- --------------------------------------------------------
84
85--
86-- Table structure for table `agosto`
87--
88
89CREATE TABLE IF NOT EXISTS `agosto` (
90 `id` int(255) NOT NULL AUTO_INCREMENT,
91 `dia` int(255) NOT NULL,
92 `mes` int(255) NOT NULL,
93 `ano` int(255) NOT NULL,
94 `matricula` int(255) NOT NULL,
95 `hora` varchar(255) NOT NULL,
96 PRIMARY KEY (`id`)
97) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
98
99--
100-- Dumping data for table `agosto`
101--
102
103
104-- --------------------------------------------------------
105
106--
107-- Table structure for table `alunos`
108--
109
110CREATE TABLE IF NOT EXISTS `alunos` (
111 `matricula` int(11) NOT NULL AUTO_INCREMENT,
112 `nome` varchar(150) NOT NULL,
113 `curso` varchar(150) NOT NULL,
114 `telefone` varchar(150) NOT NULL,
115 `sexo` varchar(10) NOT NULL,
116 `dtnasc` varchar(15) NOT NULL,
117 `email` varchar(200) NOT NULL,
118 `responsavel` varchar(150) DEFAULT NULL,
119 `adv` int(1) DEFAULT '0',
120 `turma` varchar(5) DEFAULT NULL,
121 `turno` varchar(50) DEFAULT NULL,
122 `ano` varchar(50) DEFAULT NULL,
123 `tag` varchar(255) NOT NULL,
124 `dias` int(5) DEFAULT NULL,
125 PRIMARY KEY (`matricula`)
126) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
127
128--
129-- Dumping data for table `alunos`
130--
131
132INSERT INTO `alunos` (`matricula`, `nome`, `curso`, `telefone`, `sexo`, `dtnasc`, `email`, `responsavel`, `adv`, `turma`, `turno`, `ano`, `tag`, `dias`) VALUES
133(1, 'ASD', 'Eletr?nica (3)', 'AS', 'Masculino', '22/02/1999', 'D', 'j nicolau', 2, '2', 'Tarde (2)', 'Segundo (2)', '0', NULL),
134(2, 'Andreia', 'Eletr?nica (3)', '123123123', 'Masculino', '22/22/2222', '2222222', 'Gilvan1', 2, '2', 'Tarde (2)', 'Segundo (2)', '0', NULL),
135(6, 'carlos', 'Automação (1)', '33333', 'Masculino ', '22/22/2222', 'carlosmoretti', 'salca', 0, '6212', 'Tarde (2)', 'Segundo (2)', '2 BE F3 A0 D5\r', 18);
136
137-- --------------------------------------------------------
138
139--
140-- Table structure for table `dezembro`
141--
142
143CREATE TABLE IF NOT EXISTS `dezembro` (
144 `id` int(255) NOT NULL AUTO_INCREMENT,
145 `dia` int(255) NOT NULL,
146 `mes` int(255) NOT NULL,
147 `ano` int(255) NOT NULL,
148 `matricula` int(255) NOT NULL,
149 `hora` varchar(255) NOT NULL,
150 PRIMARY KEY (`id`)
151) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
152
153--
154-- Dumping data for table `dezembro`
155--
156
157
158-- --------------------------------------------------------
159
160--
161-- Table structure for table `fevereiro`
162--
163
164CREATE TABLE IF NOT EXISTS `fevereiro` (
165 `id` int(255) NOT NULL AUTO_INCREMENT,
166 `dia` int(255) NOT NULL,
167 `mes` int(255) NOT NULL,
168 `ano` int(255) NOT NULL,
169 `matricula` int(255) NOT NULL,
170 `hora` varchar(255) NOT NULL,
171 PRIMARY KEY (`id`)
172) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
173
174--
175-- Dumping data for table `fevereiro`
176--
177
178
179-- --------------------------------------------------------
180
181--
182-- Table structure for table `janeiro`
183--
184
185CREATE TABLE IF NOT EXISTS `janeiro` (
186 `id` int(255) NOT NULL AUTO_INCREMENT,
187 `dia` int(255) NOT NULL,
188 `mes` int(255) NOT NULL,
189 `ano` int(255) NOT NULL,
190 `matricula` int(255) NOT NULL,
191 `hora` varchar(255) NOT NULL,
192 PRIMARY KEY (`id`)
193) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
194
195--
196-- Dumping data for table `janeiro`
197--
198
199
200-- --------------------------------------------------------
201
202--
203-- Table structure for table `julho`
204--
205
206CREATE TABLE IF NOT EXISTS `julho` (
207 `id` int(255) NOT NULL AUTO_INCREMENT,
208 `dia` int(255) NOT NULL,
209 `mes` int(255) NOT NULL,
210 `ano` int(255) NOT NULL,
211 `matricula` int(255) NOT NULL,
212 `hora` varchar(255) NOT NULL,
213 PRIMARY KEY (`id`)
214) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
215
216--
217-- Dumping data for table `julho`
218--
219
220
221-- --------------------------------------------------------
222
223--
224-- Table structure for table `junho`
225--
226
227CREATE TABLE IF NOT EXISTS `junho` (
228 `id` int(255) NOT NULL AUTO_INCREMENT,
229 `dia` int(255) NOT NULL,
230 `mes` int(255) NOT NULL,
231 `ano` int(255) NOT NULL,
232 `matricula` int(255) NOT NULL,
233 `hora` varchar(255) NOT NULL,
234 PRIMARY KEY (`id`)
235) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
236
237--
238-- Dumping data for table `junho`
239--
240
241
242-- --------------------------------------------------------
243
244--
245-- Table structure for table `maio`
246--
247
248CREATE TABLE IF NOT EXISTS `maio` (
249 `id` int(255) NOT NULL AUTO_INCREMENT,
250 `dia` int(255) NOT NULL,
251 `mes` int(255) NOT NULL,
252 `ano` int(255) NOT NULL,
253 `matricula` int(255) NOT NULL,
254 `hora` varchar(255) NOT NULL,
255 PRIMARY KEY (`id`)
256) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
257
258--
259-- Dumping data for table `maio`
260--
261
262
263-- --------------------------------------------------------
264
265--
266-- Table structure for table `marco`
267--
268
269CREATE TABLE IF NOT EXISTS `marco` (
270 `id` int(255) NOT NULL AUTO_INCREMENT,
271 `dia` int(255) NOT NULL,
272 `mes` int(255) NOT NULL,
273 `ano` int(255) NOT NULL,
274 `matricula` int(255) NOT NULL,
275 `hora` varchar(255) NOT NULL,
276 PRIMARY KEY (`id`)
277) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
278
279--
280-- Dumping data for table `marco`
281--
282
283
284-- --------------------------------------------------------
285
286--
287-- Table structure for table `novembro`
288--
289
290CREATE TABLE IF NOT EXISTS `novembro` (
291 `id` int(255) NOT NULL AUTO_INCREMENT,
292 `dia` int(255) NOT NULL,
293 `mes` int(255) NOT NULL,
294 `ano` int(255) NOT NULL,
295 `matricula` int(255) NOT NULL,
296 `hora` varchar(255) NOT NULL,
297 PRIMARY KEY (`id`)
298) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
299
300--
301-- Dumping data for table `novembro`
302--
303
304
305-- --------------------------------------------------------
306
307--
308-- Table structure for table `outubro`
309--
310
311CREATE TABLE IF NOT EXISTS `outubro` (
312 `id` int(255) NOT NULL AUTO_INCREMENT,
313 `dia` int(255) NOT NULL,
314 `mes` int(255) NOT NULL,
315 `ano` int(255) NOT NULL,
316 `matricula` int(255) NOT NULL,
317 `hora` varchar(255) NOT NULL,
318 PRIMARY KEY (`id`)
319) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;
320
321--
322-- Dumping data for table `outubro`
323--
324
325INSERT INTO `outubro` (`id`, `dia`, `mes`, `ano`, `matricula`, `hora`) VALUES
326(1, 15, 10, 2016, 5, '17:49'),
327(2, 15, 10, 2016, 6, '18:25'),
328(3, 15, 10, 2016, 6, '18:25'),
329(4, 15, 10, 2016, 6, '18:34'),
330(5, 15, 10, 2016, 6, '18:35'),
331(6, 15, 10, 2016, 6, '18:36'),
332(7, 15, 10, 2016, 6, '18:36'),
333(8, 15, 10, 2016, 6, '18:37'),
334(9, 15, 10, 2016, 6, '18:38'),
335(10, 15, 10, 2016, 6, '18:39'),
336(11, 15, 10, 2016, 6, '18:39'),
337(12, 15, 10, 2016, 6, '18:40'),
338(13, 15, 10, 2016, 6, '18:40'),
339(14, 15, 10, 2016, 6, '18:45'),
340(15, 15, 10, 2016, 6, '18:45'),
341(16, 15, 10, 2016, 6, '18:45'),
342(17, 15, 10, 2016, 6, '18:46'),
343(18, 15, 10, 2016, 6, '19:4'),
344(19, 15, 10, 2016, 6, '19:4'),
345(20, 15, 10, 2016, 6, '19:6'),
346(21, 15, 10, 2016, 6, '19:6'),
347(22, 15, 10, 2016, 6, '19:9'),
348(23, 15, 10, 2016, 6, '19:9'),
349(24, 15, 10, 2016, 6, '19:9'),
350(25, 15, 10, 2016, 6, '19:9'),
351(26, 15, 10, 2016, 6, '19:9');
352
353-- --------------------------------------------------------
354
355--
356-- Table structure for table `professores`
357--
358
359CREATE TABLE IF NOT EXISTS `professores` (
360 `cpf` varchar(255) NOT NULL,
361 `nome` varchar(255) NOT NULL,
362 `filhos` varchar(255) NOT NULL,
363 `cep` varchar(255) NOT NULL,
364 `telefone` varchar(255) NOT NULL,
365 `sexo` varchar(255) NOT NULL,
366 `dtnasc` varchar(255) NOT NULL,
367 `rg` varchar(255) NOT NULL,
368 `disciplina` varchar(255) NOT NULL,
369 `estcivil` varchar(255) NOT NULL,
370 `email` varchar(255) NOT NULL,
371 `endereco` varchar(255) NOT NULL,
372 PRIMARY KEY (`cpf`)
373) ENGINE=InnoDB DEFAULT CHARSET=latin1;
374
375--
376-- Dumping data for table `professores`
377--
378
379INSERT INTO `professores` (`cpf`, `nome`, `filhos`, `cep`, `telefone`, `sexo`, `dtnasc`, `rg`, `disciplina`, `estcivil`, `email`, `endereco`) VALUES
380('53701372772', 'Carlos', '4 ou mais', '21820096', '34686643', 'Masculino', '22021999', '53701372772', 'matematica', 'Divorciado(a)', 'carlosmorettirjj@gmail.com', 'Rua Rio da Prata');
381
382-- --------------------------------------------------------
383
384--
385-- Table structure for table `responsaveis`
386--
387
388CREATE TABLE IF NOT EXISTS `responsaveis` (
389 `cpf` varchar(255) NOT NULL,
390 `nome` varchar(150) NOT NULL,
391 `cep` varchar(50) NOT NULL,
392 `telefone` varchar(15) NOT NULL,
393 `sexo` varchar(10) NOT NULL,
394 `dtnasc` varchar(10) NOT NULL,
395 `rg` varchar(50) NOT NULL,
396 `graufam` varchar(50) NOT NULL,
397 `estcivil` varchar(50) NOT NULL,
398 `email` varchar(150) NOT NULL,
399 `endereco` varchar(255) NOT NULL,
400 `aluno` varchar(255) DEFAULT NULL,
401 PRIMARY KEY (`cpf`)
402) ENGINE=InnoDB DEFAULT CHARSET=latin1;
403
404--
405-- Dumping data for table `responsaveis`
406--
407
408INSERT INTO `responsaveis` (`cpf`, `nome`, `cep`, `telefone`, `sexo`, `dtnasc`, `rg`, `graufam`, `estcivil`, `email`, `endereco`, `aluno`) VALUES
409('123123', 'Gilvan1', '123123', '123123', 'Masculino', '12/31/2322', '123123', ' Tios', 'Divorciado(a)', '123123123', '123123123', 'Andreia'),
410('1233333', 'salca', '12312333', '12312313', 'Masculino', '22/22/2222', '222222', ' Pais', 'Divorciado(a)', 'carlosmorettirjj@gmail.com', '12312323', '1231233'),
411('31231', 'Salca', '12313', '12313', 'Masculino', '22/22/2222', '2123123123', ' Tios', 'Viúvo(a)', 'carlosmorettirjj@gmail.com', 'Rua Rio da Prata', 'Carlos'),
412('4444', 'salca', '4444', '444', 'Feminino', '22/22/2222', '444444', ' Tios', 'Divorciado(a)', 'carlosmorettirjj@gmail.com', 'rdp', 'carlos'),
413('53701372772', 'Gilberto Marcolino Moretti', '21820096', '34686643', 'Masculino', '22/02/1999', '53701372772', ' Pais', 'Divorciado(a)', 'carlosmorettirjj@gmail.com', 'Rua Rio da Prata, 481, Bangu', 'Carlos Alexandre Moretti'),
414('595959', 'ksksks', '59599', '123123', 'Masculino', '22/22/2222', '13213', ' Avós', 'Solteiro(a)', '123123', '123123', '123123');
415
416-- --------------------------------------------------------
417
418--
419-- Table structure for table `setembro`
420--
421
422CREATE TABLE IF NOT EXISTS `setembro` (
423 `id` int(255) NOT NULL AUTO_INCREMENT,
424 `dia` int(255) NOT NULL,
425 `mes` int(255) NOT NULL,
426 `ano` int(255) NOT NULL,
427 `matricula` int(255) NOT NULL,
428 `hora` varchar(255) NOT NULL,
429 PRIMARY KEY (`id`)
430) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
431
432--
433-- Dumping data for table `setembro`
434--
435
436
437-- --------------------------------------------------------
438
439--
440-- Table structure for table `turmas`
441--
442
443CREATE TABLE IF NOT EXISTS `turmas` (
444 `id` int(255) NOT NULL AUTO_INCREMENT,
445 `turno` varchar(255) NOT NULL,
446 `curso` varchar(40) NOT NULL,
447 `ano` varchar(255) NOT NULL,
448 `numero` varchar(50) DEFAULT NULL,
449 PRIMARY KEY (`id`)
450) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
451
452--
453-- Dumping data for table `turmas`
454--
455
456INSERT INTO `turmas` (`id`, `turno`, `curso`, `ano`, `numero`) VALUES
457(1, 'manha', 'tarde', '3', NULL),
458(3, '1', '2', '2', NULL),
459(4, '1', '2', '2', NULL),
460(5, '2', '1', '1', '5'),
461(6, '2', '1', '2', '6212');