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