· 10 years ago · Apr 20, 2016, 06:57 PM
1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: 20-Abr-2016 Ã s 20:53
7-- Versão do servidor: 5.6.17
8-- PHP Version: 5.5.12
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 utf8 */;
18
19--
20-- Database: `curso`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Estrutura da tabela `aluno`
27--
28
29CREATE TABLE IF NOT EXISTS `aluno` (
30 `alun_id` int(11) NOT NULL AUTO_INCREMENT,
31 `alun_nome` varchar(255) NOT NULL,
32 `alun_email` varchar(255) NOT NULL,
33 `alun_sala_idSala` int(11) NOT NULL,
34 `alun_senha` varchar(255) NOT NULL,
35 PRIMARY KEY (`alun_id`),
36 KEY `alun_sala_idSala` (`alun_sala_idSala`)
37) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=201 ;
38
39--
40-- Extraindo dados da tabela `aluno`
41--
42
43INSERT INTO `aluno` (`alun_id`, `alun_nome`, `alun_email`, `alun_sala_idSala`, `alun_senha`) VALUES
44(2, 'Caleb Acevedo', 'a.aliquet.vel@nullaIn.ca', 6, '8149'),
45(3, 'Buckminster Ayala', 'commodo.ipsum@Duisatlacus.ca', 6, '1703'),
46(4, 'Hayley Green', 'scelerisque@mollis.edu', 1, '8381'),
47(5, 'Gillian Sampson', 'dictum.Phasellus@nonlacinia.ca', 1, '3487'),
48(6, 'Lee Knapp', 'diam.Sed@maurisMorbi.ca', 6, '6918'),
49(7, 'Martena Sexton', 'imperdiet.ullamcorper.Duis@sodalesMaurisblandit.org', 5, '6295'),
50(8, 'Keith Kemp', 'molestie.tellus@vitae.org', 7, '3297'),
51(9, 'Rachel Buckley', 'vitae@Morbi.edu', 5, '4068'),
52(10, 'Curran Knapp', 'mauris@Sednec.org', 1, '9647'),
53(11, 'Jocelyn Ramos', 'fringilla.euismod@Vivamussit.org', 1, '4353'),
54(12, 'Wayne Trevino', 'faucibus.orci@Nullamscelerisqueneque.co.uk', 6, '9583'),
55(13, 'Nyssa Webster', 'elementum@diam.edu', 2, '3870'),
56(14, 'Stephanie Holland', 'Sed.nunc.est@lorem.com', 2, '4333'),
57(15, 'Linda Patel', 'Cum@NuncmaurisMorbi.net', 5, '3232'),
58(16, 'Amos Dickson', 'Sed@malesuadamalesuada.edu', 2, '8612'),
59(17, 'Vivian Drake', 'Proin.ultrices.Duis@habitant.ca', 4, '2546'),
60(18, 'Flynn Oneil', 'Aliquam@maurisblanditmattis.com', 5, '6022'),
61(19, 'Hillary Rojas', 'arcu.Vestibulum.ante@id.org', 2, '6981'),
62(20, 'Gabriel Deleon', 'magnis.dis.parturient@mollisvitaeposuere.co.uk', 2, '8191'),
63(21, 'Joan Gomez', 'nunc.id@dictumsapienAenean.ca', 4, '4242'),
64(22, 'Dylan Vang', 'metus.In.nec@erateget.org', 1, '7514'),
65(23, 'Simone Heath', 'Suspendisse@auctorvitaealiquet.org', 6, '5850'),
66(24, 'Cameron English', 'porttitor@non.edu', 3, '4481'),
67(25, 'Nathan Medina', 'ac@adipiscingligulaAenean.co.uk', 6, '8616'),
68(26, 'Ryan Hudson', 'Sed.nulla.ante@atortorNunc.edu', 2, '1474'),
69(27, 'Yardley Mcmahon', 'egestas@tempusmauris.co.uk', 5, '4299'),
70(28, 'Reagan Espinoza', 'tristique@scelerisquenequeNullam.org', 1, '9825'),
71(29, 'Naida Lara', 'placerat@volutpatornarefacilisis.com', 7, '5731'),
72(30, 'Xantha Norris', 'tincidunt.adipiscing.Mauris@Nullaeuneque.org', 4, '3331'),
73(31, 'Athena Mercado', 'Praesent.eu@scelerisquenequeNullam.com', 4, '3292'),
74(32, 'Libby Simon', 'Nunc.pulvinar@Phasellusdolor.com', 5, '6308'),
75(33, 'Kyla Cleveland', 'Quisque.ornare@arcu.org', 7, '7296'),
76(34, 'Irma Rowe', 'egestas.urna.justo@Nuncmaurissapien.net', 6, '1901'),
77(35, 'Amela Cannon', 'tincidunt@In.edu', 1, '7835'),
78(36, 'Jacqueline Kinney', 'mi@interdumfeugiatSed.net', 3, '6126'),
79(37, 'Dawn Woods', 'sit.amet.diam@MorbivehiculaPellentesque.ca', 2, '3831'),
80(38, 'Cora Richards', 'dolor.vitae.dolor@placerat.org', 3, '1695'),
81(39, 'Ingrid Zimmerman', 'magna@Donecelementum.edu', 6, '2086'),
82(40, 'Keane Fox', 'turpis@quam.net', 2, '5538'),
83(41, 'Basil Dalton', 'Nam@adipiscing.org', 4, '8760'),
84(42, 'Fiona Lloyd', 'ante.ipsum.primis@urna.org', 6, '2345'),
85(43, 'Zia Obrien', 'Proin.nisl@rutrum.ca', 7, '2830'),
86(44, 'Xenos Sheppard', 'ipsum.dolor.sit@dolorFusce.net', 6, '6896'),
87(45, 'Mechelle Mcgee', 'ac.feugiat@molestiearcu.ca', 6, '6831'),
88(46, 'Regina Castaneda', 'congue@lectuspedeet.co.uk', 5, '6141'),
89(47, 'Joy Vasquez', 'ut.dolor@risusMorbi.net', 3, '3621'),
90(48, 'Leilani Dixon', 'ornare@fringilla.ca', 4, '4097'),
91(49, 'Damon Marquez', 'adipiscing.elit@utquamvel.com', 5, '6656'),
92(50, 'Jamalia Velazquez', 'senectus.et@tellusfaucibusleo.edu', 7, '8016'),
93(51, 'Henry Bray', 'ante.ipsum.primis@ProinvelitSed.co.uk', 2, '8304'),
94(52, 'Savannah Joyner', 'amet.ultricies@ipsumporta.org', 3, '1261'),
95(53, 'Erich Woods', 'ut.dolor@necanteblandit.com', 5, '1212'),
96(54, 'Dakota Mcclure', 'Maecenas.libero@CuraeDonectincidunt.com', 2, '3083'),
97(55, 'Lev Blake', 'at.fringilla@semelit.org', 7, '9064'),
98(56, 'Maxine Jordan', 'nascetur.ridiculus@tortor.ca', 7, '4113'),
99(57, 'Holly Dean', 'laoreet@estconguea.ca', 4, '4585'),
100(58, 'Lani Shaw', 'lobortis.quam.a@Loremipsum.co.uk', 1, '4346'),
101(59, 'Mia Prince', 'laoreet@nec.co.uk', 6, '2403'),
102(60, 'Octavia Brennan', 'feugiat.non.lobortis@Quisquepurus.ca', 5, '9458'),
103(61, 'Baxter Jenkins', 'Nam.tempor@egestasnuncsed.co.uk', 4, '8394'),
104(62, 'Oleg King', 'sem@atpretium.net', 2, '8429'),
105(63, 'Ora Klein', 'euismod.in.dolor@elementumloremut.org', 2, '9500'),
106(64, 'Risa Sanchez', 'eu.tempor@Namporttitor.co.uk', 3, '1713'),
107(65, 'Patience Farley', 'dui.quis@sed.net', 4, '5294'),
108(66, 'Alexis Hammond', 'Pellentesque.habitant@Cras.org', 3, '2003'),
109(67, 'Hamish Head', 'venenatis.a.magna@quisturpis.edu', 6, '4755'),
110(68, 'Haviva Boyer', 'mattis.velit@nasceturridiculusmus.ca', 1, '5068'),
111(69, 'Aretha Mcclure', 'magna.sed@auctorullamcorpernisl.edu', 4, '5463'),
112(70, 'Shay Hogan', 'amet@nonvestibulumnec.ca', 4, '9167'),
113(71, 'Pascale Collier', 'dictum.sapien@magna.net', 2, '4769'),
114(72, 'Nathan Holt', 'ipsum@turpisnecmauris.edu', 3, '5846'),
115(73, 'Noah Branch', 'malesuada.vel.convallis@massa.ca', 3, '1705'),
116(74, 'Laith Patrick', 'nulla.Cras.eu@Nam.org', 1, '2894'),
117(75, 'Sydney Flores', 'faucibus.Morbi.vehicula@eratvolutpat.edu', 5, '3208'),
118(76, 'Lacy Bruce', 'ante.dictum.mi@anteVivamus.net', 7, '7850'),
119(77, 'Ryan Holder', 'pellentesque.a@pedesagittisaugue.ca', 5, '7633'),
120(78, 'Kaitlin Mills', 'in.dolor.Fusce@sapienmolestieorci.com', 2, '9731'),
121(79, 'Yoshio Goff', 'sit.amet@nequenon.co.uk', 1, '7691'),
122(80, 'Candace Poole', 'Cras.convallis@nuncac.edu', 4, '9998'),
123(81, 'Hyacinth Cantu', 'dictum.ultricies@iaculisnec.org', 7, '2990'),
124(82, 'Regan Gamble', 'Sed.id.risus@Maurisutquam.edu', 1, '4634'),
125(83, 'Jonah Mcfarland', 'eleifend.nec@convallisdolor.edu', 1, '1189'),
126(84, 'Demetrius Zamora', 'Quisque@malesuadautsem.ca', 3, '5460'),
127(85, 'Susan Mcintyre', 'eget.tincidunt.dui@egestas.co.uk', 2, '5566'),
128(86, 'Reuben Thompson', 'Nunc.ut@euismod.net', 2, '5618'),
129(87, 'Mary Koch', 'amet.consectetuer@neque.org', 2, '5341'),
130(88, 'Quemby Gibson', 'purus@ipsum.ca', 4, '2973'),
131(89, 'Leandra Mcintosh', 'dis.parturient.montes@massa.edu', 7, '1413'),
132(90, 'Lacey Mullen', 'dolor.vitae@nec.net', 4, '6923'),
133(91, 'Brett Bradford', 'dui.Cum.sociis@eueuismodac.net', 7, '6376'),
134(92, 'Cecilia Aguirre', 'lorem.vehicula@Etiambibendumfermentum.org', 5, '2155'),
135(93, 'Felix Bradshaw', 'convallis.ligula@ideratEtiam.org', 7, '6320'),
136(94, 'Kyla Deleon', 'Phasellus@ornareliberoat.co.uk', 2, '6090'),
137(95, 'Lucy Frost', 'nascetur@at.edu', 4, '6990'),
138(96, 'Carson Stein', 'justo.nec.ante@aliquetmetusurna.ca', 2, '7467'),
139(97, 'Chanda Oneil', 'Curabitur.ut@diamdictumsapien.co.uk', 1, '1257'),
140(98, 'Elijah Mckay', 'vel@pedePraesent.edu', 2, '1527'),
141(99, 'Rhoda Sanford', 'augue.ut@orci.edu', 2, '4829'),
142(100, 'Libby King', 'Nunc.mauris.elit@euneque.net', 7, '2597'),
143(101, 'Perry Waller', 'augue.scelerisque.mollis@Morbi.org', 7, 'ca0cd09a12abade3bf0777574d9f987f'),
144(102, 'Scott Lee', 'dignissim@feugiat.co.uk', 6, 'ca0cd09a12abade3bf0777574d9f987f'),
145(103, 'Odysseus Kaufman', 'odio.a@etultricesposuere.com', 2, 'ca0cd09a12abade3bf0777574d9f987f'),
146(104, 'Venus Davis', 'magna@nonhendrerit.net', 4, 'ca0cd09a12abade3bf0777574d9f987f'),
147(105, 'Melvin George', 'sollicitudin@Cum.ca', 7, 'ca0cd09a12abade3bf0777574d9f987f'),
148(106, 'Zeph Key', 'Fusce@sitametconsectetuer.com', 2, 'ca0cd09a12abade3bf0777574d9f987f'),
149(107, 'Mari Hernandez', 'ornare@Maurisvel.co.uk', 2, 'ca0cd09a12abade3bf0777574d9f987f'),
150(108, 'Ciaran Keith', 'id.ante@nequepellentesque.co.uk', 5, 'ca0cd09a12abade3bf0777574d9f987f'),
151(109, 'Ethan Fowler', 'elit@fermentum.com', 7, 'ca0cd09a12abade3bf0777574d9f987f'),
152(110, 'Thor Cole', 'adipiscing.elit@mi.co.uk', 1, 'ca0cd09a12abade3bf0777574d9f987f'),
153(111, 'Lenore Fry', 'Maecenas.mi.felis@justo.ca', 4, 'ca0cd09a12abade3bf0777574d9f987f'),
154(112, 'Victoria Jimenez', 'nisi@eget.edu', 5, 'ca0cd09a12abade3bf0777574d9f987f'),
155(113, 'Janna Jackson', 'vulputate@nec.org', 3, 'ca0cd09a12abade3bf0777574d9f987f'),
156(114, 'Colorado Serrano', 'nec.cursus@parturient.co.uk', 5, 'ca0cd09a12abade3bf0777574d9f987f'),
157(115, 'Kelsey Mercer', 'rhoncus@dignissimtemporarcu.org', 7, 'ca0cd09a12abade3bf0777574d9f987f'),
158(116, 'Wynter Mathis', 'facilisis@egestas.com', 2, 'ca0cd09a12abade3bf0777574d9f987f'),
159(117, 'Kiara Kinney', 'sem@velfaucibus.edu', 2, 'ca0cd09a12abade3bf0777574d9f987f'),
160(118, 'Kyla Willis', 'non@nonummyipsum.edu', 2, 'ca0cd09a12abade3bf0777574d9f987f'),
161(119, 'Bruce Greer', 'dui.Cras@quisaccumsanconvallis.net', 4, 'ca0cd09a12abade3bf0777574d9f987f'),
162(120, 'Aladdin Guerra', 'odio.semper.cursus@Phasellus.org', 1, 'ca0cd09a12abade3bf0777574d9f987f'),
163(121, 'Lesley Cardenas', 'eu.eleifend@egetmassaSuspendisse.ca', 2, 'ca0cd09a12abade3bf0777574d9f987f'),
164(122, 'Brielle Estrada', 'at@dolor.ca', 1, 'ca0cd09a12abade3bf0777574d9f987f'),
165(123, 'Riley Orr', 'mi.eleifend@tincidunt.net', 7, 'ca0cd09a12abade3bf0777574d9f987f'),
166(124, 'Keegan Mueller', 'faucibus.orci.luctus@elitNullafacilisi.ca', 1, 'ca0cd09a12abade3bf0777574d9f987f'),
167(125, 'Fulton Griffith', 'nascetur@turpisnon.co.uk', 3, 'ca0cd09a12abade3bf0777574d9f987f'),
168(126, 'Samantha Parks', 'Morbi.quis.urna@eteros.com', 2, 'ca0cd09a12abade3bf0777574d9f987f'),
169(127, 'Thor Le', 'litora.torquent@lorem.com', 2, 'ca0cd09a12abade3bf0777574d9f987f'),
170(128, 'Maris Landry', 'non.justo.Proin@placeratvelitQuisque.ca', 3, 'ca0cd09a12abade3bf0777574d9f987f'),
171(129, 'Blaine Wilder', 'vel.vulputate@Maecenas.com', 2, 'ca0cd09a12abade3bf0777574d9f987f'),
172(130, 'Sydney Mercado', 'Morbi@vitae.co.uk', 7, 'ca0cd09a12abade3bf0777574d9f987f'),
173(131, 'Sean Blake', 'est@Nunc.co.uk', 3, 'ca0cd09a12abade3bf0777574d9f987f'),
174(132, 'Denise Hudson', 'erat.Vivamus@urnanec.ca', 7, 'ca0cd09a12abade3bf0777574d9f987f'),
175(133, 'Ruby Haley', 'tortor@semconsequatnec.net', 5, 'ca0cd09a12abade3bf0777574d9f987f'),
176(134, 'Jasper Burnett', 'Pellentesque.ultricies@enimnisl.co.uk', 6, 'ca0cd09a12abade3bf0777574d9f987f'),
177(135, 'Sylvia Banks', 'at.pede.Cras@pretiumaliquetmetus.co.uk', 3, 'ca0cd09a12abade3bf0777574d9f987f'),
178(136, 'Joel Boone', 'In@Donecfringilla.edu', 4, 'ca0cd09a12abade3bf0777574d9f987f'),
179(137, 'Omar Alvarez', 'tempus.mauris@elitAliquamauctor.co.uk', 5, 'ca0cd09a12abade3bf0777574d9f987f'),
180(138, 'Colette Camacho', 'sit.amet.orci@odioa.com', 1, 'ca0cd09a12abade3bf0777574d9f987f'),
181(139, 'Ray Duran', 'posuere.enim.nisl@acmattis.edu', 5, 'ca0cd09a12abade3bf0777574d9f987f'),
182(140, 'Justina Church', 'ornare.Fusce.mollis@Nuncuterat.edu', 7, 'ca0cd09a12abade3bf0777574d9f987f'),
183(141, 'Lee Workman', 'fermentum@Curabiturvel.org', 7, 'ca0cd09a12abade3bf0777574d9f987f'),
184(142, 'Dale Park', 'amet.consectetuer.adipiscing@NullamnislMaecenas.org', 6, 'ca0cd09a12abade3bf0777574d9f987f'),
185(143, 'Keane Vasquez', 'orci.sem.eget@velit.org', 5, 'ca0cd09a12abade3bf0777574d9f987f'),
186(144, 'Damian Petty', 'tempor.est@anuncIn.org', 4, 'ca0cd09a12abade3bf0777574d9f987f'),
187(145, 'Xantha Camacho', 'nascetur.ridiculus@Fuscemollis.org', 1, 'ca0cd09a12abade3bf0777574d9f987f'),
188(146, 'Aristotle Lowe', 'magna.tellus.faucibus@Nuncpulvinararcu.org', 3, 'ca0cd09a12abade3bf0777574d9f987f'),
189(147, 'Berk Keith', 'pede.ac.urna@utodiovel.net', 4, 'ca0cd09a12abade3bf0777574d9f987f'),
190(148, 'Callum Hancock', 'at.augue@arcuacorci.org', 1, 'ca0cd09a12abade3bf0777574d9f987f'),
191(149, 'Ursa Stuart', 'tincidunt.tempus@orciadipiscing.ca', 5, 'ca0cd09a12abade3bf0777574d9f987f'),
192(150, 'Ayanna Bell', 'arcu.Aliquam.ultrices@arcuiaculisenim.co.uk', 4, 'ca0cd09a12abade3bf0777574d9f987f'),
193(151, 'Hilda Hood', 'magna.sed@diam.co.uk', 5, 'ca0cd09a12abade3bf0777574d9f987f'),
194(152, 'Fatima Case', 'Cum.sociis@ultriciesadipiscingenim.edu', 7, 'ca0cd09a12abade3bf0777574d9f987f'),
195(153, 'Reece Cochran', 'commodo.ipsum@magna.edu', 1, 'ca0cd09a12abade3bf0777574d9f987f'),
196(154, 'Denton Valentine', 'vitae.sodales.at@sem.ca', 4, 'ca0cd09a12abade3bf0777574d9f987f'),
197(155, 'Iliana Bell', 'id.libero.Donec@hendrerit.edu', 4, 'ca0cd09a12abade3bf0777574d9f987f'),
198(156, 'Karen Deleon', 'tellus.justo@lacusvestibulumlorem.net', 3, 'ca0cd09a12abade3bf0777574d9f987f'),
199(157, 'Delilah Johnston', 'mollis.dui@acorci.net', 3, 'ca0cd09a12abade3bf0777574d9f987f'),
200(158, 'Patrick Cain', 'ornare.elit.elit@nequeseddictum.com', 2, 'ca0cd09a12abade3bf0777574d9f987f'),
201(159, 'Sacha Perez', 'Quisque@tinciduntcongueturpis.edu', 4, 'ca0cd09a12abade3bf0777574d9f987f'),
202(160, 'Timothy Goodwin', 'penatibus@nullaatsem.co.uk', 1, 'ca0cd09a12abade3bf0777574d9f987f'),
203(161, 'Justin Bolton', 'arcu.iaculis.enim@liberoduinec.org', 7, 'ca0cd09a12abade3bf0777574d9f987f'),
204(162, 'Macey Melendez', 'ligula.Aenean.euismod@turpisnecmauris.co.uk', 2, 'ca0cd09a12abade3bf0777574d9f987f'),
205(163, 'Anastasia Phelps', 'Aenean.massa@lorem.org', 6, 'ca0cd09a12abade3bf0777574d9f987f'),
206(164, 'Zane Gregory', 'auctor@estmollisnon.org', 3, 'ca0cd09a12abade3bf0777574d9f987f'),
207(165, 'Germaine Hoffman', 'orci.Donec.nibh@eueleifend.ca', 1, 'ca0cd09a12abade3bf0777574d9f987f'),
208(166, 'Courtney Olson', 'Integer.mollis.Integer@Morbi.org', 5, 'ca0cd09a12abade3bf0777574d9f987f'),
209(167, 'Benedict Mosley', 'velit@ornarefacilisiseget.org', 2, 'ca0cd09a12abade3bf0777574d9f987f'),
210(168, 'Lee Olsen', 'magna@est.net', 6, 'ca0cd09a12abade3bf0777574d9f987f'),
211(169, 'Peter Holloway', 'nisi@nonsollicitudina.edu', 6, 'ca0cd09a12abade3bf0777574d9f987f'),
212(170, 'Brynn Goodman', 'amet.ultricies@parturient.co.uk', 6, 'ca0cd09a12abade3bf0777574d9f987f'),
213(171, 'Rashad Salinas', 'volutpat.ornare.facilisis@ametmassaQuisque.org', 3, 'ca0cd09a12abade3bf0777574d9f987f'),
214(172, 'Germaine Salas', 'mi@Aenean.net', 1, 'ca0cd09a12abade3bf0777574d9f987f'),
215(173, 'Abra Sampson', 'iaculis.nec@Nullam.net', 7, 'ca0cd09a12abade3bf0777574d9f987f'),
216(174, 'Sean Ward', 'iaculis@Nullamfeugiat.org', 4, 'ca0cd09a12abade3bf0777574d9f987f'),
217(175, 'Nomlanga Curry', 'magna.Lorem@mienimcondimentum.com', 3, 'ca0cd09a12abade3bf0777574d9f987f'),
218(176, 'Phillip Christian', 'vel@molestietortornibh.net', 7, 'ca0cd09a12abade3bf0777574d9f987f'),
219(177, 'Anastasia Gomez', 'in.magna@eratneque.com', 2, 'ca0cd09a12abade3bf0777574d9f987f'),
220(178, 'Jane Wells', 'interdum@varius.net', 3, 'ca0cd09a12abade3bf0777574d9f987f'),
221(179, 'Rylee Hewitt', 'urna.suscipit@SeddictumProin.co.uk', 6, 'ca0cd09a12abade3bf0777574d9f987f'),
222(180, 'Cassady Tran', 'lectus.Nullam@Namporttitorscelerisque.co.uk', 4, 'ca0cd09a12abade3bf0777574d9f987f'),
223(181, 'Virginia Pate', 'urna.Nunc@mauris.com', 3, 'ca0cd09a12abade3bf0777574d9f987f'),
224(182, 'Francesca Mayer', 'nunc.In@Etiamvestibulummassa.edu', 2, 'ca0cd09a12abade3bf0777574d9f987f'),
225(183, 'Veronica Macdonald', 'Morbi.sit.amet@metus.co.uk', 3, 'ca0cd09a12abade3bf0777574d9f987f'),
226(184, 'Hanae Stevens', 'Aliquam.tincidunt@ipsumCurabitur.ca', 5, 'ca0cd09a12abade3bf0777574d9f987f'),
227(185, 'Magee Jennings', 'gravida@Pellentesqueut.ca', 1, 'ca0cd09a12abade3bf0777574d9f987f'),
228(186, 'Samuel Merritt', 'lacus.Quisque.purus@Aliquamnecenim.ca', 7, 'ca0cd09a12abade3bf0777574d9f987f'),
229(187, 'Georgia Roy', 'ipsum.leo.elementum@turpis.org', 5, 'ca0cd09a12abade3bf0777574d9f987f'),
230(188, 'Olivia Mendez', 'venenatis@eu.edu', 2, 'ca0cd09a12abade3bf0777574d9f987f'),
231(189, 'Mikayla Ortiz', 'Pellentesque@dictumPhasellus.net', 4, 'ca0cd09a12abade3bf0777574d9f987f'),
232(190, 'Kessie Collins', 'cubilia.Curae.Phasellus@sociisnatoquepenatibus.com', 5, 'ca0cd09a12abade3bf0777574d9f987f'),
233(191, 'Ria Cooley', 'bibendum.sed@eueleifend.ca', 6, 'ca0cd09a12abade3bf0777574d9f987f'),
234(192, 'Nola Boyd', 'rutrum.eu.ultrices@Donecest.net', 4, 'ca0cd09a12abade3bf0777574d9f987f'),
235(193, 'Whoopi Lamb', 'Nunc.pulvinar@aliquetmetusurna.org', 2, 'ca0cd09a12abade3bf0777574d9f987f'),
236(194, 'Kelly Rosales', 'Nunc.sollicitudin.commodo@Integervulputaterisus.com', 6, 'ca0cd09a12abade3bf0777574d9f987f'),
237(195, 'Lysandra Jensen', 'tristique.ac.eleifend@mauris.co.uk', 5, 'ca0cd09a12abade3bf0777574d9f987f'),
238(196, 'Dahlia Boyer', 'nec.metus.facilisis@tristique.ca', 1, 'ca0cd09a12abade3bf0777574d9f987f'),
239(197, 'Karly Morin', 'Mauris.eu@nibhDonec.com', 5, 'ca0cd09a12abade3bf0777574d9f987f'),
240(198, 'Rajah Guerrero', 'Etiam.gravida@erosnectellus.net', 7, 'ca0cd09a12abade3bf0777574d9f987f'),
241(199, 'Nina Camacho', 'id.mollis.nec@Cumsociisnatoque.co.uk', 5, 'ca0cd09a12abade3bf0777574d9f987f'),
242(200, 'Ulric Durham', 'ipsum.cursus@Quisquetinciduntpede.net', 5, 'ca0cd09a12abade3bf0777574d9f987f');
243
244-- --------------------------------------------------------
245
246--
247-- Estrutura da tabela `estoque_folha`
248--
249
250CREATE TABLE IF NOT EXISTS `estoque_folha` (
251 `idEstoque` int(11) NOT NULL AUTO_INCREMENT,
252 `data_entrada` date NOT NULL,
253 `quantidade_entrada` int(55) NOT NULL,
254 `quantidade` int(55) unsigned NOT NULL,
255 `estoque_minimo` int(55) NOT NULL,
256 `data_inicio` date NOT NULL DEFAULT '0000-00-00',
257 `data_baixa` date DEFAULT '0000-00-00',
258 `ativo` tinyint(1) NOT NULL DEFAULT '0',
259 `espera` tinyint(1) NOT NULL DEFAULT '1',
260 PRIMARY KEY (`idEstoque`)
261) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;
262
263--
264-- Extraindo dados da tabela `estoque_folha`
265--
266
267INSERT INTO `estoque_folha` (`idEstoque`, `data_entrada`, `quantidade_entrada`, `quantidade`, `estoque_minimo`, `data_inicio`, `data_baixa`, `ativo`, `espera`) VALUES
268(26, '2016-04-14', 100, 0, 50, '2016-04-18', '2016-04-20', 0, 0),
269(27, '2016-04-20', 100, 100, 50, '2016-04-20', '0000-00-00', 1, 0),
270(28, '2016-04-19', 200, 200, 100, '0000-00-00', '0000-00-00', 0, 1);
271
272--
273-- Acionadores `estoque_folha`
274--
275DROP TRIGGER IF EXISTS `tr_setaDataeDesativa`;
276DELIMITER //
277CREATE TRIGGER `tr_setaDataeDesativa` BEFORE UPDATE ON `estoque_folha`
278 FOR EACH ROW IF NEW.quantidade = 0 THEN
279 SET NEW.data_baixa = current_date;
280 SET NEW.ativo = '0';
281 ELSEIF NEW.quantidade > 0 THEN
282 SET NEW.data_baixa = 0000-00-00;
283 END IF
284//
285DELIMITER ;
286
287-- --------------------------------------------------------
288
289--
290-- Estrutura da tabela `funcionario`
291--
292
293CREATE TABLE IF NOT EXISTS `funcionario` (
294 `func_cod` int(6) NOT NULL AUTO_INCREMENT,
295 `func_nome` varchar(65) NOT NULL,
296 `func_email` varchar(65) DEFAULT NULL,
297 `func_cargo` varchar(55) NOT NULL,
298 `func_local` varchar(255) NOT NULL,
299 PRIMARY KEY (`func_cod`)
300) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
301
302--
303-- Extraindo dados da tabela `funcionario`
304--
305
306INSERT INTO `funcionario` (`func_cod`, `func_nome`, `func_email`, `func_cargo`, `func_local`) VALUES
307(1, 'Helô Viola', 'helo@email.com', 'Professora', 'CJN '),
308(2, 'Helô Viola', 'helo@email.com', 'Professora', 'CJN '),
309(3, 'Thais Travassos', 'thais@email.com', 'Professora', 'CJN'),
310(4, 'Diego Funcionario', 'diegofuncionario@email.com', 'Gestor', 'Secretaria');
311
312-- --------------------------------------------------------
313
314--
315-- Estrutura da tabela `impressao_aluno`
316--
317
318CREATE TABLE IF NOT EXISTS `impressao_aluno` (
319 `idImpressaoAluno` int(11) NOT NULL AUTO_INCREMENT,
320 `data_impressao_aluno` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
321 `aluno_id` int(11) NOT NULL,
322 `copias` int(11) NOT NULL,
323 `valor` decimal(3,2) NOT NULL,
324 `total` decimal(5,2) NOT NULL,
325 `situacao` tinyint(1) NOT NULL,
326 `impressora_id` int(11) NOT NULL,
327 PRIMARY KEY (`idImpressaoAluno`),
328 KEY `impa_aluno_alun_id` (`aluno_id`,`impressora_id`),
329 KEY `impressora_idImpressora` (`impressora_id`),
330 KEY `impa_aluno_alun_id_2` (`aluno_id`),
331 KEY `impressora_idImpressora_2` (`impressora_id`),
332 KEY `impa_aluno_alun_id_3` (`aluno_id`)
333) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=62 ;
334
335--
336-- Extraindo dados da tabela `impressao_aluno`
337--
338
339INSERT INTO `impressao_aluno` (`idImpressaoAluno`, `data_impressao_aluno`, `aluno_id`, `copias`, `valor`, `total`, `situacao`, `impressora_id`) VALUES
340(59, '2016-04-18 18:21:24', 190, 3, '0.50', '1.50', 1, 15),
341(60, '2016-04-18 18:22:54', 200, 20, '0.50', '10.00', 1, 16),
342(61, '2016-04-20 17:08:53', 194, 7, '0.50', '3.50', 1, 16);
343
344--
345-- Acionadores `impressao_aluno`
346--
347DROP TRIGGER IF EXISTS `tr_atualizaEstoque`;
348DELIMITER //
349CREATE TRIGGER `tr_atualizaEstoque` BEFORE INSERT ON `impressao_aluno`
350 FOR EACH ROW update estoque_folha
351set quantidade = quantidade - new.copias
352where ativo = '1'
353//
354DELIMITER ;
355
356-- --------------------------------------------------------
357
358--
359-- Estrutura da tabela `impressoras`
360--
361
362CREATE TABLE IF NOT EXISTS `impressoras` (
363 `id` int(11) NOT NULL AUTO_INCREMENT,
364 `marca` varchar(65) NOT NULL,
365 `modelo` varchar(65) NOT NULL,
366 `tinta` enum('P/B','Colorido') NOT NULL,
367 `data_compra` date NOT NULL,
368 PRIMARY KEY (`id`),
369 KEY `tinta` (`tinta`)
370) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
371
372--
373-- Extraindo dados da tabela `impressoras`
374--
375
376INSERT INTO `impressoras` (`id`, `marca`, `modelo`, `tinta`, `data_compra`) VALUES
377(15, 'Epson', 'AS Printer', 'P/B', '2016-04-18'),
378(16, 'HP', 'Photosmart 1020', 'Colorido', '2016-04-04');
379
380-- --------------------------------------------------------
381
382--
383-- Estrutura da tabela `sala`
384--
385
386CREATE TABLE IF NOT EXISTS `sala` (
387 `idSala` int(11) NOT NULL AUTO_INCREMENT,
388 `nome_sala` varchar(255) NOT NULL,
389 `segmento` varchar(255) NOT NULL,
390 PRIMARY KEY (`idSala`)
391) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
392
393--
394-- Extraindo dados da tabela `sala`
395--
396
397INSERT INTO `sala` (`idSala`, `nome_sala`, `segmento`) VALUES
398(1, '1A', 'Ensino Médio'),
399(2, '1B', 'Ensino Médio'),
400(3, '2A', 'Ensino Médio'),
401(4, '2B', 'Ensino Médio'),
402(5, '3A', 'Ensino Médio'),
403(6, '3B', 'Ensino Médio'),
404(7, '5AM', 'Fundamental I'),
405(8, '7AM', 'Fundamental II');
406
407-- --------------------------------------------------------
408
409--
410-- Estrutura da tabela `tinta`
411--
412
413CREATE TABLE IF NOT EXISTS `tinta` (
414 `idTinta` int(11) NOT NULL AUTO_INCREMENT,
415 `codigo` varchar(65) NOT NULL,
416 `tipo` varchar(65) NOT NULL,
417 `cor` tinyint(2) NOT NULL,
418 PRIMARY KEY (`idTinta`)
419) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
420
421-- --------------------------------------------------------
422
423--
424-- Estrutura da tabela `usuario`
425--
426
427CREATE TABLE IF NOT EXISTS `usuario` (
428 `idUsuario` int(11) NOT NULL AUTO_INCREMENT,
429 `nome` varchar(255) NOT NULL,
430 `email` varchar(255) NOT NULL,
431 `senha` varchar(255) NOT NULL,
432 `status` tinyint(1) NOT NULL,
433 `nivel` tinyint(4) NOT NULL,
434 PRIMARY KEY (`idUsuario`)
435) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;
436
437--
438-- Extraindo dados da tabela `usuario`
439--
440
441INSERT INTO `usuario` (`idUsuario`, `nome`, `email`, `senha`, `status`, `nivel`) VALUES
442(16, 'Test User ', 'admin@teste.com', '21232f297a57a5a743894a0e4a801fc3', 1, 1),
443(22, 'Sóstenes Gomes ', 'sostenes@email.com', '21232f297a57a5a743894a0e4a801fc3', 1, 2),
444(23, 'João Vitor Martins', 'joaovitor@email.com', '698dc19d489c4e4db73e28a713eab07b', 1, 2),
445(24, 'Test User', 'user@teste.com', '698dc19d489c4e4db73e28a713eab07b', 1, 2);
446
447--
448-- Constraints for dumped tables
449--
450
451--
452-- Limitadores para a tabela `aluno`
453--
454ALTER TABLE `aluno`
455 ADD CONSTRAINT `fk_aluno_sala` FOREIGN KEY (`alun_sala_idSala`) REFERENCES `sala` (`idSala`);
456
457--
458-- Limitadores para a tabela `impressao_aluno`
459--
460ALTER TABLE `impressao_aluno`
461 ADD CONSTRAINT `fk_impressao_aluno` FOREIGN KEY (`aluno_id`) REFERENCES `aluno` (`alun_id`),
462 ADD CONSTRAINT `fk_impressao_impressora` FOREIGN KEY (`impressora_id`) REFERENCES `impressoras` (`id`);
463
464/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
465/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
466/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;