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