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