· 10 years ago · Mar 31, 2016, 12:57 AM
1-- phpMyAdmin SQL Dump
2-- version 4.5.1
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: 31-Mar-2016 Ã s 02:53
7-- Versão do servidor: 10.1.10-MariaDB
8-- PHP Version: 5.6.15
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `escolasistemica`
15--
16CREATE DATABASE IF NOT EXISTS `escolasistemica` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
17USE `escolasistemica`;
18
19-- --------------------------------------------------------
20
21--
22-- Estrutura da tabela `classes`
23--
24
25DROP TABLE IF EXISTS `classes`;
26CREATE TABLE IF NOT EXISTS `classes` (
27 `id` int(11) NOT NULL AUTO_INCREMENT,
28 `name` varchar(255) DEFAULT NULL,
29 `profile_id` int(11) DEFAULT NULL,
30 PRIMARY KEY (`id`),
31 UNIQUE KEY `name` (`name`),
32 KEY `FK_classes_profile_id` (`profile_id`)
33) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
34
35--
36-- Extraindo dados da tabela `classes`
37--
38
39INSERT INTO `classes` (`id`, `name`, `profile_id`) VALUES
40(1, 'ST SADS 2015 1 N2', 1),
41(2, 'ST SADS 2014 1 N1', 1),
42(3, 'ST SADS 2016 1 N1', 1);
43
44-- --------------------------------------------------------
45
46--
47-- Estrutura da tabela `disciplines`
48--
49
50DROP TABLE IF EXISTS `disciplines`;
51CREATE TABLE IF NOT EXISTS `disciplines` (
52 `id` int(11) NOT NULL AUTO_INCREMENT,
53 `name` varchar(255) DEFAULT NULL,
54 `profile_id` int(11) DEFAULT NULL,
55 PRIMARY KEY (`id`),
56 KEY `FK_disciplines_profile_id` (`profile_id`)
57) ENGINE=InnoDB DEFAULT CHARSET=utf8;
58
59-- --------------------------------------------------------
60
61--
62-- Estrutura da tabela `discipline_indicators`
63--
64
65DROP TABLE IF EXISTS `discipline_indicators`;
66CREATE TABLE IF NOT EXISTS `discipline_indicators` (
67 `discipline_id` int(11) NOT NULL,
68 `indicator_id` int(11) NOT NULL,
69 PRIMARY KEY (`discipline_id`,`indicator_id`),
70 KEY `FK_discipline_indicators_indicator_id` (`indicator_id`)
71) ENGINE=InnoDB DEFAULT CHARSET=utf8;
72
73-- --------------------------------------------------------
74
75--
76-- Estrutura da tabela `exams`
77--
78
79DROP TABLE IF EXISTS `exams`;
80CREATE TABLE IF NOT EXISTS `exams` (
81 `id` int(11) NOT NULL AUTO_INCREMENT,
82 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
83 `phase_id` int(11) NOT NULL,
84 `user_id` int(11) NOT NULL,
85 PRIMARY KEY (`id`),
86 KEY `FK_exams_phase_id` (`phase_id`),
87 KEY `FK_exams_user_id` (`user_id`)
88) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
89
90--
91-- Extraindo dados da tabela `exams`
92--
93
94INSERT INTO `exams` (`id`, `date`, `phase_id`, `user_id`) VALUES
95(1, '2016-03-30 22:42:58', 1, 29);
96
97-- --------------------------------------------------------
98
99--
100-- Estrutura da tabela `exam_comments`
101--
102
103DROP TABLE IF EXISTS `exam_comments`;
104CREATE TABLE IF NOT EXISTS `exam_comments` (
105 `id` int(11) NOT NULL AUTO_INCREMENT,
106 `observation` text,
107 `strategy` text,
108 `exam_id` int(11) DEFAULT NULL,
109 `comments_ORDER` int(11) DEFAULT NULL,
110 PRIMARY KEY (`id`),
111 KEY `FK_exam_comments_exam_id` (`exam_id`)
112) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
113
114--
115-- Extraindo dados da tabela `exam_comments`
116--
117
118INSERT INTO `exam_comments` (`id`, `observation`, `strategy`, `exam_id`, `comments_ORDER`) VALUES
119(1, 'middle-2', '', 1, 3),
120(2, 'middle-1', '', 1, 2),
121(3, '', '', 1, 4),
122(4, '', '', 1, 1),
123(5, 'first1', 'first2', 1, 0),
124(6, 'last1', 'last2', 1, 5);
125
126-- --------------------------------------------------------
127
128--
129-- Estrutura da tabela `exam_indicators`
130--
131
132DROP TABLE IF EXISTS `exam_indicators`;
133CREATE TABLE IF NOT EXISTS `exam_indicators` (
134 `id` int(11) NOT NULL AUTO_INCREMENT,
135 `value` int(11) DEFAULT NULL,
136 `indicator_id` int(11) DEFAULT NULL,
137 `exam_id` int(11) DEFAULT NULL,
138 `indicators_ORDER` int(11) DEFAULT NULL,
139 PRIMARY KEY (`id`),
140 UNIQUE KEY `UNQ_exam_indicators_0` (`indicator_id`,`exam_id`),
141 KEY `FK_exam_indicators_exam_id` (`exam_id`)
142) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;
143
144--
145-- Extraindo dados da tabela `exam_indicators`
146--
147
148INSERT INTO `exam_indicators` (`id`, `value`, `indicator_id`, `exam_id`, `indicators_ORDER`) VALUES
149(1, 2, 39, 1, 10),
150(2, 3, 49, 1, 20),
151(3, 2, 53, 1, 24),
152(4, 4, 33, 1, 4),
153(5, 3, 32, 1, 3),
154(6, 3, 50, 1, 21),
155(7, 4, 34, 1, 5),
156(8, 4, 51, 1, 22),
157(9, 4, 52, 1, 23),
158(10, 3, 37, 1, 8),
159(11, 3, 41, 1, 12),
160(12, 3, 45, 1, 16),
161(13, 4, 44, 1, 15),
162(14, 3, 40, 1, 11),
163(15, 3, 46, 1, 17),
164(16, 2, 31, 1, 2),
165(17, 4, 36, 1, 7),
166(18, 2, 29, 1, 0),
167(19, 4, 43, 1, 14),
168(20, 2, 48, 1, 19),
169(21, 3, 35, 1, 6),
170(22, 4, 42, 1, 13),
171(23, 3, 30, 1, 1),
172(24, 3, 47, 1, 18),
173(25, 3, 38, 1, 9);
174
175-- --------------------------------------------------------
176
177--
178-- Estrutura da tabela `goals`
179--
180
181DROP TABLE IF EXISTS `goals`;
182CREATE TABLE IF NOT EXISTS `goals` (
183 `id` int(11) NOT NULL AUTO_INCREMENT,
184 `name` text,
185 `objective_id` int(11) NOT NULL,
186 PRIMARY KEY (`id`),
187 KEY `FK_goals_objective_id` (`objective_id`)
188) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
189
190--
191-- Extraindo dados da tabela `goals`
192--
193
194INSERT INTO `goals` (`id`, `name`, `objective_id`) VALUES
195(2, 'Desenvolver os fundamentos técnicos e cientÃficos para aplicar os conceitos básicos de informática e ciência da computação no decorrer do curso.', 2),
196(3, 'Desenvolver os fundamentos técnicos e cientÃficos para resolver situações problemas contextualizados na área de software que exijam o raciocÃnio lógico aplicando técnicas de lógica de programação no decorrer do curso.', 2),
197(4, 'Desenvolver as capacidades técnicas, sociais, organizativas e metodológicas para desenvolver e documentar testes de software dentro de um processo especÃfico utilizando procedimentos da área de TI de maneira a validar o sistema de acordo com os requisitos de projeto no decorrer do curso.', 2),
198(5, 'Desenvolver as capacidades técnicas, sociais, organizativas e metodológicas necessárias ao desenvolvimento de sistemas computacionais utilizando paradigmas de programação estruturada e orientada a objetos de acordo com as especificações técnicas do projeto no decorrer do curso.', 2),
199(6, 'Desenvolver as capacidades técnicas, sociais, organizativas e metodológicas para utilizar ferramentas de modelagem e desenvolvimento de banco de dados empregando linguagens de consulta e manipulação de dados, normalização baseada em dependências funcionais e aplicação de técnicas de indexação no decorrer do curso.', 2),
200(7, 'Desenvolver as capacidades técnicas, sociais, organizativas e metodológicas para os fundamentos de engenharia de software empregando conceitos de projetos, processos e metodologia no decorrer do curso.', 2),
201(8, 'Proporcionar o desenvolvimento dos fundamentos técnicos, cientÃficos e as capacidades sociais, organizativos e metodológicos para o desenvolvimento de relacionamento interpessoal em seu ambiente de trabalho, com seus clientes, chefes e subordinados no decorrer do curso.', 2);
202
203-- --------------------------------------------------------
204
205--
206-- Estrutura da tabela `grade_range`
207--
208
209DROP TABLE IF EXISTS `grade_range`;
210CREATE TABLE IF NOT EXISTS `grade_range` (
211 `id` int(11) NOT NULL AUTO_INCREMENT,
212 `end` float DEFAULT NULL,
213 `start` float DEFAULT NULL,
214 `value` float DEFAULT NULL,
215 `profile_id` int(11) NOT NULL,
216 PRIMARY KEY (`id`),
217 KEY `FK_grade_range_profile_id` (`profile_id`)
218) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
219
220--
221-- Extraindo dados da tabela `grade_range`
222--
223
224INSERT INTO `grade_range` (`id`, `end`, `start`, `value`, `profile_id`) VALUES
225(1, 2, 0, 5, 1),
226(2, 5, 4.6, 10, 1),
227(3, 3, 2.6, 7, 1),
228(4, 4, 3.6, 8.5, 1),
229(5, 4.5, 4.1, 9, 1),
230(6, 2.5, 2.1, 6, 1),
231(7, 3.5, 3.1, 8, 1);
232
233-- --------------------------------------------------------
234
235--
236-- Estrutura da tabela `indicators`
237--
238
239DROP TABLE IF EXISTS `indicators`;
240CREATE TABLE IF NOT EXISTS `indicators` (
241 `id` int(11) NOT NULL AUTO_INCREMENT,
242 `name` text,
243 `goal_id` int(11) NOT NULL,
244 PRIMARY KEY (`id`),
245 KEY `FK_indicators_goal_id` (`goal_id`)
246) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8;
247
248--
249-- Extraindo dados da tabela `indicators`
250--
251
252INSERT INTO `indicators` (`id`, `name`, `goal_id`) VALUES
253(29, 'Analisa e avalia o funcionamento de computadores e periféricos em ambientes computacionais.', 2),
254(30, 'Codifica programas computacionais utilizando lógica de programação e respeitando boas práticas de programação.', 3),
255(31, 'Desenvolver sites web com elementos multimÃdia.', 3),
256(32, 'Desenvolver capacidades linguÃsticas de modo a saber usar adequadamente a linguagem oral e escrita em diferentes situações e contextos.', 3),
257(33, 'Conhecer o caráter do conhecimento cientÃfico aplicando a metodologia cientÃfica e utilizando redação acadêmica na realização da pesquisa, na escolha de métodos, técnicas e instrumentos de pesquisa.', 3),
258(34, 'Criar, modificar e manipular banco de dados utilizando linguagem SQL.', 3),
259(35, 'Utilizar estruturas de dados definindo-as e aplicando-as adequadamente nos programas.', 3),
260(36, 'Compreender a estrutura e funcionamento das organizações, a partir de uma visão global e sistêmica.', 3),
261(37, 'Configurar e administrar computadores em redes locais.', 4),
262(38, 'Desenvolver sistemas em diferentes segmentos.', 5),
263(39, 'Selecionar metodologia de processo e desenvolvimento de software.', 5),
264(40, 'Sistematizar o desenvolvimento de software na concepção do projeto de software.', 5),
265(41, 'Analisar e avaliar os conceitos básicos da segurança da informação de acordo com normas vigentes.', 5),
266(42, 'Realizar análise de sistemas utilizando ferramentas e linguagem de modelagem.', 5),
267(43, 'Instalar e configurar serviços básicos de rede para a conectividade de serviços na web.', 5),
268(44, 'Projetar de banco de dados.', 5),
269(45, 'Projetar e desenvolver interfaces de sistemas utilizando modelos de desenvolvimento e respeitando normas de ergonomia de software.', 5),
270(46, 'Identificar, especificar e implementar requisitos de segurança em sistemas.', 5),
271(47, 'Projetar sistemas com base nos artefatos de análise utilizando ferramentas e linguagem de modelagem, respeitando padrões de projeto.', 5),
272(48, 'Aplicar o conjunto de boas práticas, processos, polÃticas, leis e regulamentos pertinentes a área da Tecnologia da Informação.', 5),
273(49, 'Administrar e gerenciar banco de dados.', 6),
274(50, 'Conhecer e aplicar sistemas de gestão da qualidade e produtividade, propiciando diferencial competitivo.', 6),
275(51, 'Analisar e avaliar a viabilidade do desenvolvimento de um projeto.', 6),
276(52, 'Implementar sistemas segundo os padrões e normas de qualidade de produto e processo de desenvolvimento de software.', 7),
277(53, 'Planejar testes selecionando recursos, metodologias e ferramentas.', 7),
278(54, 'Desenvolver as noções relativas ao comportamento empreendedor aos aspectos inerentes ao desenvolvimento de um plano de negócio.', 7),
279(55, 'Atualizar e/ou induzir inovações tecnológicas tendo em vista a constante evolução dos processos e dos produtos industriais.', 8);
280
281-- --------------------------------------------------------
282
283--
284-- Estrutura da tabela `objectives`
285--
286
287DROP TABLE IF EXISTS `objectives`;
288CREATE TABLE IF NOT EXISTS `objectives` (
289 `id` int(11) NOT NULL AUTO_INCREMENT,
290 `name` text,
291 `profile_id` int(11) DEFAULT NULL,
292 PRIMARY KEY (`id`),
293 KEY `FK_objectives_profile_id` (`profile_id`)
294) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
295
296--
297-- Extraindo dados da tabela `objectives`
298--
299
300INSERT INTO `objectives` (`id`, `name`, `profile_id`) VALUES
301(2, 'Programar softwares, aplicando metodologias e padrões de desenvolvimento, normas técnicas, \nde qualidade, de saúde e segurança do trabalho e preservação ambiental. Testar softwares, \naplicando normas técnicas, de qualidade, de saúde e segurança do trabalho e preservação ambiental.', 1);
302
303-- --------------------------------------------------------
304
305--
306-- Estrutura da tabela `phases`
307--
308
309DROP TABLE IF EXISTS `phases`;
310CREATE TABLE IF NOT EXISTS `phases` (
311 `id` int(11) NOT NULL AUTO_INCREMENT,
312 `number` int(11) DEFAULT NULL,
313 `year` int(11) DEFAULT NULL,
314 `class_id` int(11) NOT NULL,
315 PRIMARY KEY (`id`),
316 KEY `FK_phases_class_id` (`class_id`)
317) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
318
319--
320-- Extraindo dados da tabela `phases`
321--
322
323INSERT INTO `phases` (`id`, `number`, `year`, `class_id`) VALUES
324(1, 1, 2016, 2);
325
326-- --------------------------------------------------------
327
328--
329-- Estrutura da tabela `phase_indicators`
330--
331
332DROP TABLE IF EXISTS `phase_indicators`;
333CREATE TABLE IF NOT EXISTS `phase_indicators` (
334 `id` int(11) NOT NULL AUTO_INCREMENT,
335 `priority` int(11) DEFAULT NULL,
336 `indicator_id` int(11) DEFAULT NULL,
337 `phase_id` int(11) DEFAULT NULL,
338 `indicators_ORDER` int(11) DEFAULT NULL,
339 PRIMARY KEY (`id`),
340 UNIQUE KEY `UNQ_phase_indicators_0` (`indicator_id`,`phase_id`),
341 KEY `FK_phase_indicators_phase_id` (`phase_id`)
342) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
343
344--
345-- Extraindo dados da tabela `phase_indicators`
346--
347
348INSERT INTO `phase_indicators` (`id`, `priority`, `indicator_id`, `phase_id`, `indicators_ORDER`) VALUES
349(1, 1, 47, 1, 18),
350(2, 2, 35, 1, 6),
351(3, 1, 53, 1, 24),
352(4, 2, 43, 1, 14),
353(5, 2, 33, 1, 4),
354(6, 2, 37, 1, 8),
355(7, 3, 31, 1, 2),
356(8, 2, 41, 1, 12),
357(9, 3, 38, 1, 9),
358(10, 3, 32, 1, 3),
359(11, 3, 34, 1, 5),
360(12, 3, 42, 1, 13),
361(13, 2, 45, 1, 16),
362(14, 1, 29, 1, 0),
363(15, 1, 51, 1, 22),
364(16, 1, 40, 1, 11),
365(17, 2, 52, 1, 23),
366(18, 2, 36, 1, 7),
367(19, 1, 44, 1, 15),
368(20, 2, 30, 1, 1),
369(21, 3, 50, 1, 21),
370(22, 2, 48, 1, 19),
371(23, 2, 39, 1, 10),
372(24, 1, 49, 1, 20),
373(25, 3, 46, 1, 17);
374
375-- --------------------------------------------------------
376
377--
378-- Estrutura da tabela `profiles`
379--
380
381DROP TABLE IF EXISTS `profiles`;
382CREATE TABLE IF NOT EXISTS `profiles` (
383 `id` int(11) NOT NULL AUTO_INCREMENT,
384 `name` varchar(255) DEFAULT NULL,
385 PRIMARY KEY (`id`)
386) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
387
388--
389-- Extraindo dados da tabela `profiles`
390--
391
392INSERT INTO `profiles` (`id`, `name`) VALUES
393(1, 'Faculdade'),
394(2, 'Perfil 2');
395
396-- --------------------------------------------------------
397
398--
399-- Estrutura da tabela `tokens`
400--
401
402DROP TABLE IF EXISTS `tokens`;
403CREATE TABLE IF NOT EXISTS `tokens` (
404 `id` int(11) NOT NULL AUTO_INCREMENT,
405 `token` varchar(255) DEFAULT NULL,
406 `EMAIL` varchar(255) DEFAULT NULL,
407 `expiration` bigint(20) DEFAULT NULL,
408 PRIMARY KEY (`id`)
409) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
410
411--
412-- Extraindo dados da tabela `tokens`
413--
414
415INSERT INTO `tokens` (`id`, `token`, `EMAIL`, `expiration`) VALUES
416(2, 'i5q51jv7uf35pj4ekblpm39m6u', 'teste@teste.com', 1457743759050),
417(3, 'qm50t277sgaosj1frp532bt5j2', 'hunslife@outlook.comm', 1457743785202),
418(4, 'qasukgt8pp15i5g1nc1q3trbnu', 'hunslife@outlook.commm', 1457744477664),
419(5, '22pih3m5ibdj55fpnncl21o4ni', 'hunslife@outlook.com', 1457747433506),
420(6, 'vnvfnsre8jibv6pfkj0888oi5b', 'hunslife@outlookk.com', 1457745943923),
421(7, 'orpe41sgi8u5h7qc7i4avdunpq', 'hunslife@outlook.com.br', 1458696732889),
422(8, '2jl6me4g7bdklusagu9893i53s', 'alif.correa@a2c.com.br', 1458351719062),
423(9, 'utjapmfnh1sruqqcsuelosjd3e', 'silvio@email.com', 1458773704273),
424(11, 'gbub4l1m9gfb0reec391ibc61n', 'gabriel.hobold@hotmail.com', 1459388661842);
425
426-- --------------------------------------------------------
427
428--
429-- Estrutura da tabela `users`
430--
431
432DROP TABLE IF EXISTS `users`;
433CREATE TABLE IF NOT EXISTS `users` (
434 `id` int(11) NOT NULL AUTO_INCREMENT,
435 `access` int(11) DEFAULT NULL,
436 `email` varchar(255) DEFAULT NULL,
437 `name` varchar(255) DEFAULT NULL,
438 `password` varchar(255) DEFAULT NULL,
439 `class_id` int(11) DEFAULT NULL,
440 `sent` tinyint(1) DEFAULT '0',
441 PRIMARY KEY (`id`),
442 UNIQUE KEY `UNQ_users_0` (`email`),
443 KEY `FK_users_class_id` (`class_id`)
444) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8;
445
446--
447-- Extraindo dados da tabela `users`
448--
449
450INSERT INTO `users` (`id`, `access`, `email`, `name`, `password`, `class_id`, `sent`) VALUES
451(1, 0, 'gabriel.hobold@hotmail.com', 'Gabriel Hobold', 'fcd2e6474b45ffa70fc1108d03d4fd993e299d5f0f79eac8ecc3baa1fbd09b4a8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', NULL, 0),
452(12, 0, 'alif.correa@a2c.com.br', 'Alif', '0420829753940fc7d0e301c8241c854317686d8ed64dcca551a19f3035a46e110420829753940fc7d0e301c8241c854317686d8ed64dcca551a19f3035a46e11', NULL, 0),
453(16, 1, 'email@email.com', 'Alif Correa Flores', '19544501963c36f8bec322677de3c556231fe8927f4b5970fa2a4cf36346c99719544501963c36f8bec322677de3c556231fe8927f4b5970fa2a4cf36346c997', 2, 1),
454(17, 1, 'email@email2.com', 'Andre Sandes Farias', '12a019e42e63d87519b8097ac823d96d022b9392eae1ea2edba07ae5c79242ec12a019e42e63d87519b8097ac823d96d022b9392eae1ea2edba07ae5c79242ec', 2, 0),
455(18, 1, 'email3@email.com', 'Bruno Bergmann', '1b100675b9697f996828b8e2e67dec214401d434c5b4beae22e5e3ea4703f25b1b100675b9697f996828b8e2e67dec214401d434c5b4beae22e5e3ea4703f25b', 2, 0),
456(19, 1, 'email4@email.com', 'Denielso Martins Cardoso', '2386c66bd77307026a7dce1e893909c83aafc1d3ff80b0ff6619d4e76bb2c1702386c66bd77307026a7dce1e893909c83aafc1d3ff80b0ff6619d4e76bb2c170', 2, 0),
457(20, 1, 'email5@email.com', 'Diego Henrique Mendes', '364c06edb9658d7e679842c96130793fced28c126718cdaf1bb91159e315cadc364c06edb9658d7e679842c96130793fced28c126718cdaf1bb91159e315cadc', 2, 0),
458(21, 1, 'email6@email.com', 'Elizandra Caroline Spliter', '6c40519586349131a91931e74b5b26a82d3698381609635217b7ec762b2cb0886c40519586349131a91931e74b5b26a82d3698381609635217b7ec762b2cb088', 2, 0),
459(22, 1, 'email7@email.com', 'Felipe Eduardo Brancher', '87137650406f901b28e3208c0353ecee4968be18ea56c0cf639d42c521027e7887137650406f901b28e3208c0353ecee4968be18ea56c0cf639d42c521027e78', 2, 0),
460(23, 1, 'email8@email.com', 'Felipe Petri', '0f22f14ae9a2c6c9a38e45047af220eedae6f7bc60fea9ee18aa95884ba87b900f22f14ae9a2c6c9a38e45047af220eedae6f7bc60fea9ee18aa95884ba87b90', 2, 0),
461(24, 1, 'email9@mail.com', 'Felipe Valtl de Mello', '93936802792f3a847c2e4e4967ac0838c3842d4b278348d7be5c3a89abc7379393936802792f3a847c2e4e4967ac0838c3842d4b278348d7be5c3a89abc73793', 2, 0),
462(25, 1, 'email10@email.com', 'Francisco Kennedy Nunes Pinheiro', '690bd9dd4057b951b9d0ad8c5e92996753582dbad3c5058cb6e4ab4b9bac174b690bd9dd4057b951b9d0ad8c5e92996753582dbad3c5058cb6e4ab4b9bac174b', 2, 0),
463(26, 1, 'email11@email.com', 'Gabriel Dallo', '05592d6e36c81fbc075f9c818a13e56d56fb1b91fecb3aca7e016f9d5fb6584d05592d6e36c81fbc075f9c818a13e56d56fb1b91fecb3aca7e016f9d5fb6584d', 2, 0),
464(28, 1, 'email12@email.com', 'Gabriel Eduardo Richter', '43f88223e1a28fc4e12d544add50678eff687693d13e7f4f317586339274b59b43f88223e1a28fc4e12d544add50678eff687693d13e7f4f317586339274b59b', 2, 0),
465(29, 1, 'email13@email.com', 'Gabriel Hobold Santini', 'ab6b82fbf61d6c2eb4a3453beae2c18579c0bbe6ebb213b4b2580ea404c32c97ab6b82fbf61d6c2eb4a3453beae2c18579c0bbe6ebb213b4b2580ea404c32c97', 2, 0),
466(30, 1, 'email14@email.com', 'Guilherme Choma', 'db03bf03514a561321fdb1014f1d4720082d90bf5308460fa939c6841763c87bdb03bf03514a561321fdb1014f1d4720082d90bf5308460fa939c6841763c87b', 2, 0),
467(31, 1, 'email15@email.com', 'Jessé Pacheco', 'f64c95dc3b64a33a843d19e48c9363fa96db24bde424dccea11f074cea8a0652f64c95dc3b64a33a843d19e48c9363fa96db24bde424dccea11f074cea8a0652', 2, 0),
468(32, 1, 'email16@email.com', 'Jorge Luiz Hess', '5fc839e0d131afc1e03c31a71dd9c41d2fec057149261e666ee0d0487091c6165fc839e0d131afc1e03c31a71dd9c41d2fec057149261e666ee0d0487091c616', 2, 0),
469(33, 1, 'email17@email.com', 'Juan Carlos Cabral de Souza', 'd2fd6607616443c9bcab8c3964e2af66db22d3644b5a12cd9d68ca910b891f66d2fd6607616443c9bcab8c3964e2af66db22d3644b5a12cd9d68ca910b891f66', 2, 0),
470(34, 1, 'email18@email.com', 'Júlia Lückfétt de EspÃndola', 'cfd4d7593a93592a09d1281654b959fbd991726e623e93a5717688eba260ffd0cfd4d7593a93592a09d1281654b959fbd991726e623e93a5717688eba260ffd0', 2, 0),
471(35, 1, 'email19@email.com', 'Kamila Thaise de Oliveira', 'f473109bb2b552bfdb8946f2b50d2b331721a1e584b0c9525124b1d7a157cb30f473109bb2b552bfdb8946f2b50d2b331721a1e584b0c9525124b1d7a157cb30', 2, 0),
472(36, 1, 'email20@email.com', 'Lucas Gabriel Rodrigues Simões', '7e72b16119c5192b10a34c097be80a9f553e3b17b453e03716eee1ca538f57ae7e72b16119c5192b10a34c097be80a9f553e3b17b453e03716eee1ca538f57ae', 2, 0),
473(37, 1, 'email21@email.com', 'Lucas Krüger', 'd9b9488294f08170c64f5f7bd699173cdfb2bc13bfa8c7205a322640c6f0c37ed9b9488294f08170c64f5f7bd699173cdfb2bc13bfa8c7205a322640c6f0c37e', 2, 0),
474(38, 1, 'email22@email.com', 'Paulo Felipe Borba', '3626090d04fb288c1c8e15833f3ad28bc26317a79b95ea5d13ed85c45d68f4cc3626090d04fb288c1c8e15833f3ad28bc26317a79b95ea5d13ed85c45d68f4cc', 2, 0),
475(39, 1, 'email23@email.com', 'Pedro Gustavo Duarte', '3df0a32ea9e31d10d80db21ba75ea7e4664f09c8804fad5c8e12f2a2a051bbbf3df0a32ea9e31d10d80db21ba75ea7e4664f09c8804fad5c8e12f2a2a051bbbf', 2, 0),
476(40, 1, 'email24@email.com', 'Renan Alberto de Souza', '0380b100a5047cdfa405b885b4b36a536bb2a4a9563f272ed38b5b3d5002beb90380b100a5047cdfa405b885b4b36a536bb2a4a9563f272ed38b5b3d5002beb9', 2, 0),
477(41, 1, 'email25@email.com', 'Rodrigo Venturi', '6f1b66eeaadc12aa1f96b83587eddbba918d7c64b12fa0e5754f62c46737e2926f1b66eeaadc12aa1f96b83587eddbba918d7c64b12fa0e5754f62c46737e292', 2, 0),
478(42, 1, 'email26@email.com', 'Thiara Morgana Hajdasz', '614d24c69176cb2285eba941f625478f4138e6bbfbfbf1493af76b07c3430155614d24c69176cb2285eba941f625478f4138e6bbfbfbf1493af76b07c3430155', 2, 0),
479(43, 1, 'email27@email.com', 'Vinicius Schadeck', '6b2a3ccb8828ae04577ad479db6aa0a8f737f9270effe0ab0c4f7886048a6e476b2a3ccb8828ae04577ad479db6aa0a8f737f9270effe0ab0c4f7886048a6e47', 2, 0),
480(44, 1, 'email28@email.com', 'Wellington Carlos Correa Monteiro', '2f99a1e0c7c3cb1bb0bcfdc3993cff98ee6cefc51a7ae69e3b4c728b4bf0b9bf2f99a1e0c7c3cb1bb0bcfdc3993cff98ee6cefc51a7ae69e3b4c728b4bf0b9bf', 2, 0),
481(45, 1, 'email29@email.com', 'Alexandre Ferreira', NULL, 1, 0),
482(46, 1, 'email30@email.com', 'Anderson Graper', 'ee5d318cce1275dbaebe26c654fa94e2b3e5d66c31a2227734e339b6e2373798ee5d318cce1275dbaebe26c654fa94e2b3e5d66c31a2227734e339b6e2373798', 1, 0),
483(47, 1, 'email31@email.com', 'Andre Luis Luchtenberg', '34db717244b83bbbe96eaede6420483c529e5c8753bc70daba83c83045d4c3dc34db717244b83bbbe96eaede6420483c529e5c8753bc70daba83c83045d4c3dc', 1, 0),
484(48, 1, 'email32@email.com', 'Bruno Rogério Schiochet', 'b6e4581523ed7a3436cfa3e90562424d0d95c0ab4e6cbc90cb1fbb1d87359e36b6e4581523ed7a3436cfa3e90562424d0d95c0ab4e6cbc90cb1fbb1d87359e36', 1, 0),
485(49, 1, 'email33@email.com', 'Caio Ricardo Lessin', 'a9e13ccf9e769b1ef24e40336b3c730a978daeebc7cfdf05462504dc45f7b870a9e13ccf9e769b1ef24e40336b3c730a978daeebc7cfdf05462504dc45f7b870', 1, 0),
486(50, 1, 'email34@email.com', 'Eduardo Fabricio Pacheco', '230d2fe1d2551e9e4c1ac08a9e439af7058eb0217c50f32d751d0c25c13e0081230d2fe1d2551e9e4c1ac08a9e439af7058eb0217c50f32d751d0c25c13e0081', 1, 0),
487(51, 1, 'email35@email.com', 'Fabiano Borchardt', '1e7d40662e68065fa6a7d140664d4ae546a8977f8149d68c02025014af9fa7111e7d40662e68065fa6a7d140664d4ae546a8977f8149d68c02025014af9fa711', 1, 0),
488(52, 1, 'email36@email.com', 'Felipe Lopes', '5c1e3ba3ff279c80d7ed053f90987021610199708bd761ea88e2d6f90cc5f2845c1e3ba3ff279c80d7ed053f90987021610199708bd761ea88e2d6f90cc5f284', 1, 0),
489(53, 1, 'email37@email.com', 'Gabriel Bonalume Reinert', '4f734b01ee2d478ef7e3561b813bf3aa984c7f8d4150f039fbbdda309ff1737b4f734b01ee2d478ef7e3561b813bf3aa984c7f8d4150f039fbbdda309ff1737b', 1, 0),
490(54, 1, 'email38@email.com', 'Guilherme Matheus de Souza', 'f46c4e88d79f8e716ebb52ec7a95fdfd297f4b4691c94e0bb1bf92cb0a563664f46c4e88d79f8e716ebb52ec7a95fdfd297f4b4691c94e0bb1bf92cb0a563664', 1, 0),
491(55, 1, 'email39@email.com', 'Guilherme Mendes Goulart', '9c7c80f6b1ffef9215ec88345cc80c6bd49edf11579ea575473d1191c04f7d979c7c80f6b1ffef9215ec88345cc80c6bd49edf11579ea575473d1191c04f7d97', 1, 0),
492(56, 1, 'email40@email.com', 'Guilherme Stegemann', '2c79f0f7cf5960558aaf5712600482f9ec86551dc9d5f57630027646bff387082c79f0f7cf5960558aaf5712600482f9ec86551dc9d5f57630027646bff38708', 1, 0),
493(57, 1, 'email41@email.com', 'Héctor Azevedo Mazzocco', 'b95f61dada7aab59c2569ea6ae7c93a0bb22ec2b53508db1eb822ab3101550cbb95f61dada7aab59c2569ea6ae7c93a0bb22ec2b53508db1eb822ab3101550cb', 1, 0),
494(58, 1, 'email42@email.com', 'Jeronimo Fleith de Lima', '9c70057ea6c39cd1a6067f0dc0d2db4f74e75e70babe3bad7f31e03f59aba59a9c70057ea6c39cd1a6067f0dc0d2db4f74e75e70babe3bad7f31e03f59aba59a', 1, 0),
495(59, 1, 'email43@email.com', 'João Vitor de Salves', '4fbc83fdf60933d6693c55f12067f7cfa4bb5a4801bc6bf1f49dfe5573b806214fbc83fdf60933d6693c55f12067f7cfa4bb5a4801bc6bf1f49dfe5573b80621', 1, 0),
496(60, 1, 'email44@email.com', 'Kadu Artur Prussek', '0c5ac2398ae389feaa9ef9188f6021c84a21484cd921edf6c52de8e1d6d168380c5ac2398ae389feaa9ef9188f6021c84a21484cd921edf6c52de8e1d6d16838', 1, 0),
497(61, 1, 'email45@email.com', 'Murilo Fuscolin', 'e2d53bb8e1f3451f22c3d5daa0e9139f480507399e838e482b91b3757eee3123e2d53bb8e1f3451f22c3d5daa0e9139f480507399e838e482b91b3757eee3123', 1, 0),
498(62, 1, 'email46@email.com', 'Natan Ronzani Matias', '169ba8c5da674d30f79cc07f681a05fef311e0e147e04ee148d4e51ceda47ba1169ba8c5da674d30f79cc07f681a05fef311e0e147e04ee148d4e51ceda47ba1', 1, 0),
499(63, 1, 'email47@email.com', 'Pedro Henrique de Oliveira Campelo', 'c4df7d97c48b866dc731efbf81ddf8b407fc6efd8ccc9e89cff07fa525165d08c4df7d97c48b866dc731efbf81ddf8b407fc6efd8ccc9e89cff07fa525165d08', 1, 0),
500(64, 1, 'email48@email.com', 'Rafael Negherbon', 'f76dfd730c3555a8a10627580bd27b68937f105ec497f5dac144463f1b65b930f76dfd730c3555a8a10627580bd27b68937f105ec497f5dac144463f1b65b930', 1, 0),
501(65, 1, 'email49@email.com', 'Rodrigo Pereira Marques', '9ec80061bbe93a1a6e64a3a3a39d7fe9f940dce96f8c7822e25eb8e4e0ece8f49ec80061bbe93a1a6e64a3a3a39d7fe9f940dce96f8c7822e25eb8e4e0ece8f4', 1, 0),
502(66, 1, 'email50@email.com', 'Samael Pereira Simões', '2837386ebdc84bc984859673d36a2066bacf54e12be2c513fbe1f33b680db43b2837386ebdc84bc984859673d36a2066bacf54e12be2c513fbe1f33b680db43b', 1, 0),
503(67, 1, 'email51@email.com', 'Sheyla Valerio Laurenzoni', 'a94235014fff4180924d46eb82acc56e9b925e57e487f4f02ab276ef3d4712d0a94235014fff4180924d46eb82acc56e9b925e57e487f4f02ab276ef3d4712d0', 1, 0),
504(68, 1, 'email52@email.com', 'Thállys Rodrigues Costa', '5b743c17d7740db364d7d4063b2fa9d0b7bdf0c610b05f254932fae0db79ac075b743c17d7740db364d7d4063b2fa9d0b7bdf0c610b05f254932fae0db79ac07', 1, 0),
505(69, 1, 'email53@email.com', 'Uriel Augusto Hass', '958185e2a6fde3c90af3cb124a0eb5198b310e05e6e454ec703ca4fd0be09516958185e2a6fde3c90af3cb124a0eb5198b310e05e6e454ec703ca4fd0be09516', 1, 0),
506(70, 1, 'email54@email.com', 'Wander Vinicius Capote Santos', 'f13e5ab6d20a847bf707a858dbc0c430c2b575bb14cc671e8093515f54af4eb6f13e5ab6d20a847bf707a858dbc0c430c2b575bb14cc671e8093515f54af4eb6', 1, 1),
507(71, 1, 'email55@email.com', 'Adriano Schulter Blau', 'c11cc15186e1ff0e26acda96d143aa126ad1d4e17856b31616e4b5fcd4b936c4c11cc15186e1ff0e26acda96d143aa126ad1d4e17856b31616e4b5fcd4b936c4', 3, 0),
508(72, 1, 'email56@email.com', 'Adriel Lucas Holtz', '13e1705f87ba9e50cb9be08ab62c86c3bb9f5d7c50447cfb7b4904f6153021ac13e1705f87ba9e50cb9be08ab62c86c3bb9f5d7c50447cfb7b4904f6153021ac', 3, 0),
509(73, 1, 'email57@email.com', 'André Felipe Moreira Leite', 'bae32b57e8c32700ba4e4df4e55fb21006a09975207c4e4bb62adfef384839e1bae32b57e8c32700ba4e4df4e55fb21006a09975207c4e4bb62adfef384839e1', 3, 0),
510(74, 1, 'email58@email.com', 'Ariadne Zanow', '2c8307b22663f6b2ebea57a5d43201625ee812535f1783340172ad0bbc4349bd2c8307b22663f6b2ebea57a5d43201625ee812535f1783340172ad0bbc4349bd', 3, 0),
511(75, 1, 'email59@email.com', 'Bernardo Souza de Oliveira', 'a71f0910e6f00d9dcd36093681391fa2c5cafba582523f278206a67c74a6b382a71f0910e6f00d9dcd36093681391fa2c5cafba582523f278206a67c74a6b382', 3, 0),
512(76, 1, 'email60@email.com', 'Carolina Wiest Marcelino - [ MENOR ]', '3b75a1a39e9caf66bb4e92964a88ff2a891170885f68c8d36e66b6d24d8bf6053b75a1a39e9caf66bb4e92964a88ff2a891170885f68c8d36e66b6d24d8bf605', 3, 0),
513(77, 1, 'email61@email.com', 'Christofher Michel Nogueira', '7cc0087a9a06ab9ab9c60a8f1a63605171a6530ca0f09180eda248409abbe5d07cc0087a9a06ab9ab9c60a8f1a63605171a6530ca0f09180eda248409abbe5d0', 3, 0),
514(78, 1, 'email62@email.com', 'Cristiane Teresinha da Cunha', '4369a82c3963290783bf2a0c2ce00ccb50b2443e32ce4228403fe966d0d91d394369a82c3963290783bf2a0c2ce00ccb50b2443e32ce4228403fe966d0d91d39', 3, 0),
515(79, 1, 'email63@email.com', 'Douglas Paulo Manes', 'c0c50adac219c9fd6653b146dc87f4313c68b6ebfce6423c194478566575c923c0c50adac219c9fd6653b146dc87f4313c68b6ebfce6423c194478566575c923', 3, 0),
516(80, 1, 'email64@email.com', 'Eduardo Pegoretti Borges', 'c0b410e2bc94e2267708e088f9581f41f659e78b698e34cb2567433f0def2cedc0b410e2bc94e2267708e088f9581f41f659e78b698e34cb2567433f0def2ced', 3, 0),
517(81, 1, 'email65@email.com', 'Eugenio Machado Inocencio', 'e11fd06dcc2228d7f8698d4fbb0f8a0662f76666a64e7f2ec66a17b37d90872be11fd06dcc2228d7f8698d4fbb0f8a0662f76666a64e7f2ec66a17b37d90872b', 3, 0),
518(82, 1, 'email66@email.com', 'Everton Rodrigo Matheus', 'e09f54753d6ef790565eafdb9c5e3aadf3f50bb5e153e8071e69d7006509624de09f54753d6ef790565eafdb9c5e3aadf3f50bb5e153e8071e69d7006509624d', 3, 0),
519(83, 1, 'email67@email.com', 'Ezequiel dos Santos', '74fb5dc11396a747212ffccae9b5f4395aa492f2e81decfe0acbf7f9bad1de7274fb5dc11396a747212ffccae9b5f4395aa492f2e81decfe0acbf7f9bad1de72', 3, 0),
520(84, 1, 'email68@email.com', 'Fabiano Faust', '16c65667fdc4d93d8feae14866a02c875d6e3b3f281df8b7d02586aaf317274916c65667fdc4d93d8feae14866a02c875d6e3b3f281df8b7d02586aaf3172749', 3, 0),
521(85, 1, 'email69@email.com', 'Fabiola Heller', 'f32f98c69e0d7f1e9c31707039ed4706a36b1912a3660f5f321d6a2bc87f6e26f32f98c69e0d7f1e9c31707039ed4706a36b1912a3660f5f321d6a2bc87f6e26', 3, 0),
522(86, 1, 'email70@email.com', 'Gabriel Gussella de Araujo Martins', '7436d6f516eee336e758ec09fba66a8428efba137ed57ee08bbcf439889026b67436d6f516eee336e758ec09fba66a8428efba137ed57ee08bbcf439889026b6', 3, 0),
523(87, 1, 'email71@email.com', 'Guilherme Fernando Alves Felipe', 'e3ddcc8002579f805ba63247f75cebfb54591425c186e764d6cd673aec0ab3f2e3ddcc8002579f805ba63247f75cebfb54591425c186e764d6cd673aec0ab3f2', 3, 0),
524(89, 1, 'email72@email.com', 'Gustavo Leandro Borges Silva', '9edc3c23534567ad53de84a185f4379bf419d37e9b3890c4062ee1c8b06316fc9edc3c23534567ad53de84a185f4379bf419d37e9b3890c4062ee1c8b06316fc', 3, 0),
525(90, 1, 'email73@email.com', 'Jurini de Espirito Santo Curvello Junior', 'de92407c98d856f43f16c0e3f7c51054acd1ee1dac680dae4bcdec4dd1bb492ede92407c98d856f43f16c0e3f7c51054acd1ee1dac680dae4bcdec4dd1bb492e', 3, 0),
526(91, 1, 'email74@email.com', 'Kevin Pinho Iamin', '86566b71d75ffccfb7554b3559dc2f142f2c55b869d0cbe5a6705d39481fa28b86566b71d75ffccfb7554b3559dc2f142f2c55b869d0cbe5a6705d39481fa28b', 3, 0),
527(92, 1, 'email75@email.com', 'Leandro Conradi Zmovirzynski', '952c22086a93996daea4cc90a0a0588fd82f1da7b865057801136683c15467cc952c22086a93996daea4cc90a0a0588fd82f1da7b865057801136683c15467cc', 3, 0),
528(93, 1, 'email76@email.com', 'Leandro Oliveira de Carvalho Dias', 'bf520bf35b0f9fe228a041fe0c57b976f90625dc6a18f6878fe56ac2e3b86ffdbf520bf35b0f9fe228a041fe0c57b976f90625dc6a18f6878fe56ac2e3b86ffd', 3, 0),
529(94, 1, 'email77@email.com', 'Leonardo Francisco Pereira', '69e015f4d711bc53f6d724dbd42055f78330b4f10e49c34338e7eaf8466f2c1069e015f4d711bc53f6d724dbd42055f78330b4f10e49c34338e7eaf8466f2c10', 3, 0),
530(95, 1, 'email78@email.com', 'Lucas Chaves Scalco', '623d1c5dc0eef7fb16a5a268987a00bfd6d8ae5e10d7ba4dfca5f56316614110623d1c5dc0eef7fb16a5a268987a00bfd6d8ae5e10d7ba4dfca5f56316614110', 3, 0),
531(96, 1, 'email79@email.com', 'Lucas Gabriel de França Draeger', '7957c99e78cdb0bc40e174625f562ce03e73f994ff23849fac0905b6323b74337957c99e78cdb0bc40e174625f562ce03e73f994ff23849fac0905b6323b7433', 3, 0),
532(97, 1, 'email80@email.com', 'Lucas Matheus Nunes - [ MENOR ]', '674bd2fe0121dfb1ac0ffddfc71e1ee6fe2674f42004c424884b07043baf4d42674bd2fe0121dfb1ac0ffddfc71e1ee6fe2674f42004c424884b07043baf4d42', 3, 0),
533(98, 1, 'email81@email.com', 'Marcelo Wesan', 'a0357072c38b28be2c4d07416392fe50638322bc0c747a4f8d905f323343bf9aa0357072c38b28be2c4d07416392fe50638322bc0c747a4f8d905f323343bf9a', 3, 0),
534(99, 1, 'email82@email.com', 'Mateus José Milczewski Alves Farias', '8e08eb03a5ad4437f449a7cbc5c77db4013d650f563b18272f09d279147687038e08eb03a5ad4437f449a7cbc5c77db4013d650f563b18272f09d27914768703', 3, 0),
535(100, 1, 'email83@email.com', 'Mateus Leal', '9fba1f932747acdb4e16ce38f8d966ffe0422d448dd381842449eb1f852d63269fba1f932747acdb4e16ce38f8d966ffe0422d448dd381842449eb1f852d6326', 3, 0),
536(101, 1, 'email84@email.com', 'Mateus Meyer Jiacomelli - [ PNE - MENOR ]', '6c15cd03c744432cdabbcc294e27232565b7362cf8a8ac55c4bba3731bc4acb26c15cd03c744432cdabbcc294e27232565b7362cf8a8ac55c4bba3731bc4acb2', 3, 0),
537(102, 1, 'email85@email.com', 'Maykon Bruno Silva', '6e913d69aa1bded5323cd10b9edb09ca89a93059a54a24a7be276516cf9581ad6e913d69aa1bded5323cd10b9edb09ca89a93059a54a24a7be276516cf9581ad', 3, 0),
538(103, 1, 'email86@email.com', 'Michelly Fernandes Juvencio', 'cdb5d2ffd9a003fd60eb743d38d4f7a3a07e717b6eb88bc990e237ccda048d0fcdb5d2ffd9a003fd60eb743d38d4f7a3a07e717b6eb88bc990e237ccda048d0f', 3, 0),
539(104, 1, 'email87@email.com', 'Osório Domingos de Oliveira Junior', 'e2e68ce72c257936909dc7c7a810541741434177c07213de2a974a4a120990e1e2e68ce72c257936909dc7c7a810541741434177c07213de2a974a4a120990e1', 3, 0),
540(105, 1, 'email88@email.com', 'Rodrigo Pereira Marques', '8971c59f37c8c3ffc3cf3b707395bcb75eb2bb47bd23cbee5aeb6cc01d2fb7408971c59f37c8c3ffc3cf3b707395bcb75eb2bb47bd23cbee5aeb6cc01d2fb740', 3, 0),
541(106, 1, 'email89@email.com', 'Thiago Henrique Rover', '06d7e105bcae93e30d4e892b6680647fd3ae9e64fd99974bf5670314c327e0cd06d7e105bcae93e30d4e892b6680647fd3ae9e64fd99974bf5670314c327e0cd', 3, 0),
542(107, 1, 'email90@email.com', 'Thiago Vieira Teixeira', '239a38b5ff6f5143503b82649a1330f82c3aed25e2d80389ee1633e242329b76239a38b5ff6f5143503b82649a1330f82c3aed25e2d80389ee1633e242329b76', 3, 0),
543(108, 1, 'email91@email.com', 'Vinicius William Wiest', '7979e624f013cccb1d70937f624bf6b48b57195d75ca75b39c9135730baeb7c77979e624f013cccb1d70937f624bf6b48b57195d75ca75b39c9135730baeb7c7', 3, 0),
544(109, 1, 'email92@email.com', 'Willian Cardoso', '33c41d3c00d938eac755b5938c9876118f31cf86e917109947b18c3fdcef1d3c33c41d3c00d938eac755b5938c9876118f31cf86e917109947b18c3fdcef1d3c', 3, 0),
545(110, 1, 'email93@email.com', 'Wilson Martins Pires Neto', '1c3fcc837dfbf355a34288c2ebf330881b90e082c57fda739b019e31b0e752861c3fcc837dfbf355a34288c2ebf330881b90e082c57fda739b019e31b0e75286', 3, 0),
546(111, 0, 'silvio@email.com', 'Administradores', '216e683ff0d2d25165b8bb7ba608c9a628ef299924ca49ab981ec7d2fecd6dad216e683ff0d2d25165b8bb7ba608c9a628ef299924ca49ab981ec7d2fecd6dad', NULL, 0),
547(116, 1, 'gabriel.hobolds@gmail.com', 'asdasdasd', '90419c6374bee7cf36c7924d4e0849ea23b6656ed686735ccfe898fb91d717a969f1d95398943c5b65cb96f80003b89fd8dcda1514cd28875822688df229cf3b', 1, 1);
548
549-- --------------------------------------------------------
550
551--
552-- Estrutura da tabela `user_settings`
553--
554
555DROP TABLE IF EXISTS `user_settings`;
556CREATE TABLE IF NOT EXISTS `user_settings` (
557 `enable_email` tinyint(1) DEFAULT '0',
558 `sidebar_collapse` tinyint(1) DEFAULT '0',
559 `theme` varchar(255) DEFAULT NULL,
560 `profile_id` int(11) DEFAULT NULL,
561 `user_id` int(11) NOT NULL,
562 PRIMARY KEY (`user_id`),
563 KEY `FK_user_settings_profile_id` (`profile_id`)
564) ENGINE=InnoDB DEFAULT CHARSET=utf8;
565
566--
567-- Extraindo dados da tabela `user_settings`
568--
569
570INSERT INTO `user_settings` (`enable_email`, `sidebar_collapse`, `theme`, `profile_id`, `user_id`) VALUES
571(1, 1, 'skin-red', 1, 1);
572
573--
574-- Constraints for dumped tables
575--
576
577--
578-- Limitadores para a tabela `classes`
579--
580ALTER TABLE `classes`
581 ADD CONSTRAINT `FK_classes_profile_id` FOREIGN KEY (`profile_id`) REFERENCES `profiles` (`id`);
582
583--
584-- Limitadores para a tabela `disciplines`
585--
586ALTER TABLE `disciplines`
587 ADD CONSTRAINT `FK_disciplines_profile_id` FOREIGN KEY (`profile_id`) REFERENCES `profiles` (`id`);
588
589--
590-- Limitadores para a tabela `discipline_indicators`
591--
592ALTER TABLE `discipline_indicators`
593 ADD CONSTRAINT `FK_discipline_indicators_discipline_id` FOREIGN KEY (`discipline_id`) REFERENCES `disciplines` (`id`),
594 ADD CONSTRAINT `FK_discipline_indicators_indicator_id` FOREIGN KEY (`indicator_id`) REFERENCES `indicators` (`id`);
595
596--
597-- Limitadores para a tabela `exams`
598--
599ALTER TABLE `exams`
600 ADD CONSTRAINT `FK_exams_phase_id` FOREIGN KEY (`phase_id`) REFERENCES `phases` (`id`),
601 ADD CONSTRAINT `FK_exams_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
602
603--
604-- Limitadores para a tabela `exam_comments`
605--
606ALTER TABLE `exam_comments`
607 ADD CONSTRAINT `FK_exam_comments_exam_id` FOREIGN KEY (`exam_id`) REFERENCES `exams` (`id`);
608
609--
610-- Limitadores para a tabela `exam_indicators`
611--
612ALTER TABLE `exam_indicators`
613 ADD CONSTRAINT `FK_exam_indicators_exam_id` FOREIGN KEY (`exam_id`) REFERENCES `exams` (`id`),
614 ADD CONSTRAINT `FK_exam_indicators_indicator_id` FOREIGN KEY (`indicator_id`) REFERENCES `indicators` (`id`);
615
616--
617-- Limitadores para a tabela `goals`
618--
619ALTER TABLE `goals`
620 ADD CONSTRAINT `FK_goals_objective_id` FOREIGN KEY (`objective_id`) REFERENCES `objectives` (`id`);
621
622--
623-- Limitadores para a tabela `grade_range`
624--
625ALTER TABLE `grade_range`
626 ADD CONSTRAINT `FK_grade_range_profile_id` FOREIGN KEY (`profile_id`) REFERENCES `profiles` (`id`);
627
628--
629-- Limitadores para a tabela `indicators`
630--
631ALTER TABLE `indicators`
632 ADD CONSTRAINT `FK_indicators_goal_id` FOREIGN KEY (`goal_id`) REFERENCES `goals` (`id`);
633
634--
635-- Limitadores para a tabela `objectives`
636--
637ALTER TABLE `objectives`
638 ADD CONSTRAINT `FK_objectives_profile_id` FOREIGN KEY (`profile_id`) REFERENCES `profiles` (`id`);
639
640--
641-- Limitadores para a tabela `phases`
642--
643ALTER TABLE `phases`
644 ADD CONSTRAINT `FK_phases_class_id` FOREIGN KEY (`class_id`) REFERENCES `classes` (`id`);
645
646--
647-- Limitadores para a tabela `phase_indicators`
648--
649ALTER TABLE `phase_indicators`
650 ADD CONSTRAINT `FK_phase_indicators_indicator_id` FOREIGN KEY (`indicator_id`) REFERENCES `indicators` (`id`),
651 ADD CONSTRAINT `FK_phase_indicators_phase_id` FOREIGN KEY (`phase_id`) REFERENCES `phases` (`id`);
652
653--
654-- Limitadores para a tabela `users`
655--
656ALTER TABLE `users`
657 ADD CONSTRAINT `FK_users_class_id` FOREIGN KEY (`class_id`) REFERENCES `classes` (`id`);
658
659--
660-- Limitadores para a tabela `user_settings`
661--
662ALTER TABLE `user_settings`
663 ADD CONSTRAINT `FK_user_settings_profile_id` FOREIGN KEY (`profile_id`) REFERENCES `profiles` (`id`),
664 ADD CONSTRAINT `FK_user_settings_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);