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