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