kHC4UG5W

1-- phpMyAdmin SQL Dump
2-- version 4.6.4
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost:8889
6-- Generation Time: May 24, 2017 at 03:33 PM
7-- Server version: 5.6.33
8-- PHP Version: 7.0.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `BIBL`
15--
16CREATE DATABASE IF NOT EXISTS `BIBL` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
17USE `BIBL`;
18
19-- --------------------------------------------------------
20
21--
22-- Table structure for table `Boeken`
23--
24
25CREATE TABLE `Boeken` (
26  `boeknr` int(11) NOT NULL,
27  `titel` varchar(30) NOT NULL,
28  `taal` varchar(30) NOT NULL,
29  `uitgnr` int(11) NOT NULL
30) ENGINE=InnoDB DEFAULT CHARSET=latin1;
31
32--
33-- Dumping data for table `Boeken`
34--
35
36INSERT INTO `Boeken` (`boeknr`, `titel`, `taal`, `uitgnr`) VALUES
37(1, 'Professional C#', 'Engels', 1);
38
39-- --------------------------------------------------------
40
41--
42-- Table structure for table `BoekenAuteurs`
43--
44
45CREATE TABLE `BoekenAuteurs` (
46  `boeknr` int(11) NOT NULL,
47  `aunr` int(11) NOT NULL
48) ENGINE=InnoDB DEFAULT CHARSET=latin1;
49
50-- --------------------------------------------------------
51
52--
53-- Table structure for table `Uitgevers`
54--
55
56CREATE TABLE `Uitgevers` (
57  `uitgnr` int(11) NOT NULL,
58  `uitgnaam` varchar(30) NOT NULL,
59  `uitgstad` varchar(30) NOT NULL,
60  `uitgland` varchar(50) NOT NULL
61) ENGINE=InnoDB DEFAULT CHARSET=latin1;
62
63--
64-- Dumping data for table `Uitgevers`
65--
66
67INSERT INTO `Uitgevers` (`uitgnr`, `uitgnaam`, `uitgstad`, `uitgland`) VALUES
68(1, 'WROX', '', '');
69
70-- --------------------------------------------------------
71
72--
73-- Table structure for table `auteurs`
74--
75
76CREATE TABLE `auteurs` (
77  `aunr` int(11) NOT NULL,
78  `voornaam` varchar(30) NOT NULL,
79  `familienaam` varchar(50) NOT NULL,
80  `nationaliteit` varchar(30) NOT NULL,
81  `gebdatum` date NOT NULL,
82  `sterfdatum` date NOT NULL
83) ENGINE=InnoDB DEFAULT CHARSET=latin1;
84
85--
86-- Dumping data for table `auteurs`
87--
88
89INSERT INTO `auteurs` (`aunr`, `voornaam`, `familienaam`, `nationaliteit`, `gebdatum`, `sterfdatum`) VALUES
90(1, 'Christian', 'Nagel', 'Amerikaan', '1980-12-20', '0000-00-00'),
91(2, 'Jay', 'Glynn', 'Amerikaan', '1975-01-24', '0000-00-00'),
92(3, 'Bill', 'Evjen', 'Amerikaan', '1980-12-20', '0000-00-00');
93
94-- --------------------------------------------------------
95
96--
97-- Table structure for table `hoofdstukken`
98--
99
100CREATE TABLE `hoofdstukken` (
101  `boeknr` int(11) NOT NULL,
102  `hfstnr` int(11) NOT NULL,
103  `hfsttitel` varchar(100) NOT NULL,
104  `startpagina` int(11) NOT NULL
105) ENGINE=InnoDB DEFAULT CHARSET=latin1;
106
107--
108-- Indexes for dumped tables
109--
110
111--
112-- Indexes for table `Boeken`
113--
114ALTER TABLE `Boeken`
115  ADD PRIMARY KEY (`boeknr`),
116  ADD KEY `fkuitgnr` (`uitgnr`);
117
118--
119-- Indexes for table `BoekenAuteurs`
120--
121ALTER TABLE `BoekenAuteurs`
122  ADD PRIMARY KEY (`boeknr`,`aunr`),
123  ADD KEY `fkaunr` (`aunr`);
124
125--
126-- Indexes for table `Uitgevers`
127--
128ALTER TABLE `Uitgevers`
129  ADD PRIMARY KEY (`uitgnr`);
130
131--
132-- Indexes for table `auteurs`
133--
134ALTER TABLE `auteurs`
135  ADD PRIMARY KEY (`aunr`);
136
137--
138-- Indexes for table `hoofdstukken`
139--
140ALTER TABLE `hoofdstukken`
141  ADD PRIMARY KEY (`boeknr`,`hfstnr`);
142
143--
144-- AUTO_INCREMENT for dumped tables
145--
146
147--
148-- AUTO_INCREMENT for table `Boeken`
149--
150ALTER TABLE `Boeken`
151  MODIFY `boeknr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
152--
153-- AUTO_INCREMENT for table `Uitgevers`
154--
155ALTER TABLE `Uitgevers`
156  MODIFY `uitgnr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
157--
158-- AUTO_INCREMENT for table `auteurs`
159--
160ALTER TABLE `auteurs`
161  MODIFY `aunr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
162--
163-- AUTO_INCREMENT for table `hoofdstukken`
164--
165ALTER TABLE `hoofdstukken`
166  MODIFY `boeknr` int(11) NOT NULL AUTO_INCREMENT;
167--
168-- Constraints for dumped tables
169--
170
171--
172-- Constraints for table `Boeken`
173--
174ALTER TABLE `Boeken`
175  ADD CONSTRAINT `fkuitgnr` FOREIGN KEY (`uitgnr`) REFERENCES `uitgevers` (`uitgnr`);
176
177--
178-- Constraints for table `BoekenAuteurs`
179--
180ALTER TABLE `BoekenAuteurs`
181  ADD CONSTRAINT `fkaunr` FOREIGN KEY (`aunr`) REFERENCES `auteurs` (`aunr`),
182  ADD CONSTRAINT `fkboeknr` FOREIGN KEY (`boeknr`) REFERENCES `boeken` (`boeknr`);
183
184--
185-- Constraints for table `hoofdstukken`
186--
187ALTER TABLE `hoofdstukken`
188  ADD CONSTRAINT `fkboeknr2` FOREIGN KEY (`boeknr`) REFERENCES `boeken` (`boeknr`);
189--
190-- Database: `DebtAware`
191--
192CREATE DATABASE IF NOT EXISTS `DebtAware` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
193USE `DebtAware`;
194
195-- --------------------------------------------------------
196
197--
198-- Table structure for table `Relationships`
199--
200
201CREATE TABLE `Relationships` (
202  `person1` int(11) NOT NULL,
203  `person2` int(11) NOT NULL
204) ENGINE=InnoDB DEFAULT CHARSET=utf8;
205
206--
207-- Dumping data for table `Relationships`
208--
209
210INSERT INTO `Relationships` (`person1`, `person2`) VALUES
211(39, 38),
212(40, 38),
213(40, 39);
214
215-- --------------------------------------------------------
216
217--
218-- Table structure for table `debts`
219--
220
221CREATE TABLE `debts` (
222  `debt_id` int(11) NOT NULL,
223  `loaner_id` int(11) NOT NULL,
224  `cost` float NOT NULL,
225  `event_id` int(11) NOT NULL
226) ENGINE=InnoDB DEFAULT CHARSET=utf8;
227
228--
229-- Dumping data for table `debts`
230--
231
232INSERT INTO `debts` (`debt_id`, `loaner_id`, `cost`, `event_id`) VALUES
233(21, 39, 11, 49),
234(22, 38, 3, 49),
235(23, 38, 11.3, 49),
236(24, 38, 14.34, 49),
237(25, 38, 7, 49),
238(26, 38, 11, 50),
239(27, 39, 7, 50),
240(28, 40, 9, 50),
241(29, 40, 1, 50),
242(30, 39, 13, 50);
243
244-- --------------------------------------------------------
245
246--
247-- Table structure for table `events`
248--
249
250CREATE TABLE `events` (
251  `event_id` int(11) NOT NULL,
252  `eventname` varchar(400) NOT NULL,
253  `description` mediumtext NOT NULL,
254  `longt` float NOT NULL,
255  `latt` float NOT NULL,
256  `creator_id` int(11) NOT NULL
257) ENGINE=InnoDB DEFAULT CHARSET=utf8;
258
259--
260-- Dumping data for table `events`
261--
262
263INSERT INTO `events` (`event_id`, `eventname`, `description`, `longt`, `latt`, `creator_id`) VALUES
264(49, 'test', 'zz', 32, 23, 0),
265(50, 'test2', 'hallo', 32, 23, 0),
266(51, 'hallo', '', 32, 23, 0),
267(52, '', '', 32, 23, 0),
268(53, '', '', 32, 23, 0);
269
270-- --------------------------------------------------------
271
272--
273-- Table structure for table `userevents`
274--
275
276CREATE TABLE `userevents` (
277  `event_id` int(11) NOT NULL,
278  `user_id` int(11) NOT NULL
279) ENGINE=InnoDB DEFAULT CHARSET=utf8;
280
281--
282-- Dumping data for table `userevents`
283--
284
285INSERT INTO `userevents` (`event_id`, `user_id`) VALUES
286(48, 38),
287(49, 38),
288(49, 39),
289(50, 38),
290(50, 39),
291(50, 40),
292(51, 38),
293(51, 40),
294(52, 40),
295(53, 38);
296
297-- --------------------------------------------------------
298
299--
300-- Table structure for table `users`
301--
302
303CREATE TABLE `users` (
304  `user_id` int(11) NOT NULL,
305  `email` varchar(60) NOT NULL,
306  `name` varchar(40) NOT NULL,
307  `password` varchar(150) NOT NULL,
308  `ccnumber` varchar(14) NOT NULL DEFAULT '',
309  `active` int(11) DEFAULT NULL
310) ENGINE=InnoDB DEFAULT CHARSET=utf8;
311
312--
313-- Dumping data for table `users`
314--
315
316INSERT INTO `users` (`user_id`, `email`, `name`, `password`, `ccnumber`, `active`) VALUES
317(38, 'jorrevynckier@hotmail.com', 'jorre vynckier', '$2y$10$cGVrxxdL6WFbeyrj77imAOUxulKGorAWuRRHVGcpNf27zfzs7R4Ue', 'BE32', NULL),
318(39, 'laurensdierickx', 'laurens dierickx', '$2y$10$Irf8Y0HrvYUUqF6BaNIVSe2iL2nBKe7wXyICwd4zdDt6XcU/KstoC', 'BE32', NULL),
319(40, 'kyara', 'kyara dewyse', '$2y$10$0nuC2y0Hxmo2O8jFsJcbCeDsPq342K9G3CZLXa4f4VYQjK3UGsx1e', 'zz', NULL);
320
321--
322-- Indexes for dumped tables
323--
324
325--
326-- Indexes for table `debts`
327--
328ALTER TABLE `debts`
329  ADD PRIMARY KEY (`debt_id`);
330
331--
332-- Indexes for table `events`
333--
334ALTER TABLE `events`
335  ADD PRIMARY KEY (`event_id`);
336
337--
338-- Indexes for table `userevents`
339--
340ALTER TABLE `userevents`
341  ADD PRIMARY KEY (`event_id`,`user_id`);
342
343--
344-- Indexes for table `users`
345--
346ALTER TABLE `users`
347  ADD PRIMARY KEY (`user_id`);
348
349--
350-- AUTO_INCREMENT for dumped tables
351--
352
353--
354-- AUTO_INCREMENT for table `debts`
355--
356ALTER TABLE `debts`
357  MODIFY `debt_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
358--
359-- AUTO_INCREMENT for table `events`
360--
361ALTER TABLE `events`
362  MODIFY `event_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;
363--
364-- AUTO_INCREMENT for table `users`
365--
366ALTER TABLE `users`
367  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;--
368-- Database: `LesDB`
369--
370CREATE DATABASE IF NOT EXISTS `LesDB` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
371USE `LesDB`;
372
373-- --------------------------------------------------------
374
375--
376-- Table structure for table `Boeken`
377--
378
379CREATE TABLE `Boeken` (
380  `boeknr` int(11) NOT NULL,
381  `titel` varchar(30) NOT NULL,
382  `taal` varchar(30) NOT NULL,
383  `uitgnr` int(11) NOT NULL
384) ENGINE=InnoDB DEFAULT CHARSET=latin1;
385
386-- --------------------------------------------------------
387
388--
389-- Table structure for table `Uitgevers`
390--
391
392CREATE TABLE `Uitgevers` (
393  `uitgnr` int(11) NOT NULL,
394  `uitgnaam` varchar(30) NOT NULL,
395  `uitgstad` varchar(30) NOT NULL,
396  `uitgland` varchar(50) NOT NULL
397) ENGINE=InnoDB DEFAULT CHARSET=latin1;
398
399-- --------------------------------------------------------
400
401--
402-- Table structure for table `functies`
403--
404
405CREATE TABLE `functies` (
406  `ftienaam` char(18) NOT NULL,
407  `minsal` int(11) DEFAULT NULL,
408  `maxsal` int(11) DEFAULT NULL
409) ENGINE=InnoDB DEFAULT CHARSET=latin1;
410
411--
412-- Dumping data for table `functies`
413--
414
415INSERT INTO `functies` (`ftienaam`, `minsal`, `maxsal`) VALUES
416('Analist', 45000, 60000),
417('DBA', 65000, 85000),
418('Directeur', 100000, 140000),
419('Lesgever', 55000, 80000),
420('Onderdirecteur', 75000, 100000),
421('Programmeur', 32000, 44000),
422('Technicus', 30000, 37000),
423('Vertegenwoordiger', 30000, 40000);
424
425-- --------------------------------------------------------
426
427--
428-- Table structure for table `vervangingen`
429--
430
431CREATE TABLE `vervangingen` (
432  `wnr` char(2) NOT NULL,
433  `vervangernr` char(2) NOT NULL
434) ENGINE=InnoDB DEFAULT CHARSET=latin1;
435
436--
437-- Dumping data for table `vervangingen`
438--
439
440INSERT INTO `vervangingen` (`wnr`, `vervangernr`) VALUES
441('01', '02'),
442('05', '04'),
443('04', '05'),
444('03', '06'),
445('07', '06'),
446('06', '07'),
447('08', '09'),
448('10', '09'),
449('08', '10'),
450('09', '10'),
451('14', '11'),
452('20', '15'),
453('17', '16'),
454('16', '17'),
455('19', '18'),
456('18', '19');
457
458-- --------------------------------------------------------
459
460--
461-- Table structure for table `vestigingen`
462--
463
464CREATE TABLE `vestigingen` (
465  `vesnaam` char(15) NOT NULL,
466  `branche` char(10) DEFAULT NULL,
467  `plaats` char(10) DEFAULT NULL
468) ENGINE=InnoDB DEFAULT CHARSET=latin1;
469
470--
471-- Dumping data for table `vestigingen`
472--
473
474INSERT INTO `vestigingen` (`vesnaam`, `branche`, `plaats`) VALUES
475('Computerland', 'Verkoop', 'Brussel'),
476('Leasing', 'Verhuur', 'Antwerpen'),
477('Paradise', 'Verkoop', 'Gent'),
478('Technica', 'Verkoop', 'Antwerpen'),
479('Training', 'Opleiding', 'Antwerpen');
480
481-- --------------------------------------------------------
482
483--
484-- Table structure for table `werknemers`
485--
486
487CREATE TABLE `werknemers` (
488  `wnr` char(2) NOT NULL,
489  `wnaam` char(15) DEFAULT NULL,
490  `afdeling` char(2) DEFAULT NULL,
491  `ftienaam` char(18) DEFAULT NULL,
492  `salaris` int(11) DEFAULT NULL,
493  `vesnaam` char(15) DEFAULT NULL
494) ENGINE=InnoDB DEFAULT CHARSET=latin1;
495
496--
497-- Dumping data for table `werknemers`
498--
499
500INSERT INTO `werknemers` (`wnr`, `wnaam`, `afdeling`, `ftienaam`, `salaris`, `vesnaam`) VALUES
501('01', 'Buylaert', 'B3', 'Vertegenwoordiger', 40000, 'Computerland'),
502('02', 'Vervekke', 'B3', 'Vertegenwoordiger', 42000, 'Computerland'),
503('03', 'Janssens', 'B1', 'Directeur', 100000, 'Computerland'),
504('04', 'Lievens', 'B2', 'Analist', 55000, 'Computerland'),
505('05', 'Lutenberg', 'B2', 'Analist', 60000, 'Computerland'),
506('06', 'Jens', 'A1', 'Directeur', 150000, 'Technica'),
507('07', 'Timan', 'A1', 'Onderdirecteur', 120000, 'Technica'),
508('08', 'Imbrecht', 'A2', 'Programmeur', 35000, 'Technica'),
509('09', 'Pieters', 'A2', 'Analist', 43000, 'Technica'),
510('10', 'Peeters', 'A2', 'Analist', 50000, 'Technica'),
511('11', 'Mansaert', 'A2', 'DBA', 70000, 'Technica'),
512('12', 'Lutenberg', 'G1', 'Onderdirecteur', 85000, 'Paradise'),
513('13', 'Klerk', 'G3', 'Vertegenwoordiger', 28000, 'Paradise'),
514('14', 'Konings', 'G2', 'Analist', 45000, 'Paradise'),
515('15', 'Dingens', 'A1', 'Directeur', 80000, 'Training'),
516('16', 'Van Loo', 'A4', 'Lesgever', 81000, 'Training'),
517('17', 'Van Snit', 'A4', 'Lesgever', 60000, 'Training'),
518('18', 'Van Meer', 'A3', 'Technicus', 43000, 'Leasing'),
519('19', 'Meesen', 'A3', 'Technicus', 37000, 'Leasing'),
520('20', 'Delmot', 'A1', 'Onderdirecteur', 83000, 'Leasing');
521
522--
523-- Indexes for dumped tables
524--
525
526--
527-- Indexes for table `Boeken`
528--
529ALTER TABLE `Boeken`
530  ADD PRIMARY KEY (`boeknr`),
531  ADD KEY `fkuitgnr` (`uitgnr`);
532
533--
534-- Indexes for table `Uitgevers`
535--
536ALTER TABLE `Uitgevers`
537  ADD PRIMARY KEY (`uitgnr`);
538
539--
540-- Indexes for table `functies`
541--
542ALTER TABLE `functies`
543  ADD PRIMARY KEY (`ftienaam`);
544
545--
546-- Indexes for table `vervangingen`
547--
548ALTER TABLE `vervangingen`
549  ADD PRIMARY KEY (`wnr`,`vervangernr`),
550  ADD KEY `fk2_vervanging` (`vervangernr`);
551
552--
553-- Indexes for table `vestigingen`
554--
555ALTER TABLE `vestigingen`
556  ADD PRIMARY KEY (`vesnaam`);
557
558--
559-- Indexes for table `werknemers`
560--
561ALTER TABLE `werknemers`
562  ADD PRIMARY KEY (`wnr`),
563  ADD KEY `fk1_werknemer` (`vesnaam`),
564  ADD KEY `fk2_werknemer` (`ftienaam`);
565
566--
567-- AUTO_INCREMENT for dumped tables
568--
569
570--
571-- AUTO_INCREMENT for table `Boeken`
572--
573ALTER TABLE `Boeken`
574  MODIFY `boeknr` int(11) NOT NULL AUTO_INCREMENT;
575--
576-- AUTO_INCREMENT for table `Uitgevers`
577--
578ALTER TABLE `Uitgevers`
579  MODIFY `uitgnr` int(11) NOT NULL AUTO_INCREMENT;
580--
581-- Constraints for dumped tables
582--
583
584--
585-- Constraints for table `Boeken`
586--
587ALTER TABLE `Boeken`
588  ADD CONSTRAINT `fkuitgnr` FOREIGN KEY (`uitgnr`) REFERENCES `uitgevers` (`uitgnr`);
589
590--
591-- Constraints for table `vervangingen`
592--
593ALTER TABLE `vervangingen`
594  ADD CONSTRAINT `fk1_vervanging` FOREIGN KEY (`wnr`) REFERENCES `werknemers` (`wnr`),
595  ADD CONSTRAINT `fk2_vervanging` FOREIGN KEY (`vervangernr`) REFERENCES `werknemers` (`wnr`);
596
597--
598-- Constraints for table `werknemers`
599--
600ALTER TABLE `werknemers`
601  ADD CONSTRAINT `fk1_werknemer` FOREIGN KEY (`vesnaam`) REFERENCES `vestigingen` (`vesnaam`),
602  ADD CONSTRAINT `fk2_werknemer` FOREIGN KEY (`ftienaam`) REFERENCES `functies` (`ftienaam`);
603--
604-- Database: `School`
605--
606CREATE DATABASE IF NOT EXISTS `School` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
607USE `School`;
608
609-- --------------------------------------------------------
610
611--
612-- Table structure for table `cursussen`
613--
614
615CREATE TABLE `cursussen` (
616  `cursusnr` int(11) NOT NULL,
617  `cursusnaam` varchar(30) DEFAULT NULL,
618  `inschrijvingsgeld` int(11) DEFAULT NULL
619) ENGINE=InnoDB DEFAULT CHARSET=latin1;
620
621--
622-- Dumping data for table `cursussen`
623--
624
625INSERT INTO `cursussen` (`cursusnr`, `cursusnaam`, `inschrijvingsgeld`) VALUES
626(1, 'C#', 50),
627(2, 'SQL', 100),
628(3, 'Java', 70),
629(4, 'Excel', 70),
630(5, 'MS SQL Server', 100);
631
632-- --------------------------------------------------------
633
634--
635-- Table structure for table `studenten`
636--
637
638CREATE TABLE `studenten` (
639  `studnr` int(11) NOT NULL,
640  `voornaam` varchar(30) DEFAULT NULL,
641  `familienaam` varchar(30) DEFAULT NULL,
642  `geboortedatum` date DEFAULT NULL,
643  `geslacht` char(1) DEFAULT NULL,
644  `betaald` int(11) DEFAULT '0'
645) ENGINE=InnoDB DEFAULT CHARSET=latin1;
646
647--
648-- Dumping data for table `studenten`
649--
650
651INSERT INTO `studenten` (`studnr`, `voornaam`, `familienaam`, `geboortedatum`, `geslacht`, `betaald`) VALUES
652(1, 'Francois', 'Bemelmans', '1985-04-28', 'M', 250),
653(2, 'Veerle', 'Van Maele', '1987-07-06', 'V', 50),
654(3, 'Karel', 'Govaert', '1985-05-07', 'M', 0),
655(4, 'Luc', 'Janssens', '1988-12-10', 'M', 50),
656(5, 'Leen', 'Verstraete', '1988-12-09', 'V', 120),
657(6, 'Jos', 'Van Den Berg', '1985-08-23', 'M', 150),
658(7, 'Diane', 'Hanssen', '1986-05-12', 'V', 50),
659(8, 'Bart', 'Baertmans', '1990-11-03', 'M', 50),
660(9, 'Carol', 'Mestdagh', '1989-01-07', 'V', 100),
661(10, 'Lucie', 'Jaspaert', '1989-05-22', 'V', 120),
662(11, 'Koen', 'Mortelgems', '1990-04-04', 'M', 100),
663(12, 'Marie', 'Van Maele', '1988-10-26', 'V', 0),
664(13, 'Marc', 'Vandoorne', NULL, 'M', 0),
665(14, 'Lieve', 'Van Maele', '1986-11-24', 'V', 0);
666
667-- --------------------------------------------------------
668
669--
670-- Table structure for table `studenten_cursussen`
671--
672
673CREATE TABLE `studenten_cursussen` (
674  `studnr` int(11) NOT NULL,
675  `cursusnr` int(11) NOT NULL
676) ENGINE=InnoDB DEFAULT CHARSET=latin1;
677
678--
679-- Dumping data for table `studenten_cursussen`
680--
681
682INSERT INTO `studenten_cursussen` (`studnr`, `cursusnr`) VALUES
683(1, 1),
684(2, 1),
685(4, 1),
686(7, 1),
687(8, 1),
688(12, 1),
689(1, 2),
690(5, 2),
691(9, 2),
692(10, 2),
693(11, 2),
694(12, 2),
695(1, 3),
696(5, 3),
697(6, 3),
698(1, 4),
699(6, 4),
700(10, 4);
701
702--
703-- Indexes for dumped tables
704--
705
706--
707-- Indexes for table `cursussen`
708--
709ALTER TABLE `cursussen`
710  ADD PRIMARY KEY (`cursusnr`);
711
712--
713-- Indexes for table `studenten`
714--
715ALTER TABLE `studenten`
716  ADD PRIMARY KEY (`studnr`);
717
718--
719-- Indexes for table `studenten_cursussen`
720--
721ALTER TABLE `studenten_cursussen`
722  ADD PRIMARY KEY (`studnr`,`cursusnr`),
723  ADD KEY `cursusnr` (`cursusnr`);
724
725--
726-- AUTO_INCREMENT for dumped tables
727--
728
729--
730-- AUTO_INCREMENT for table `cursussen`
731--
732ALTER TABLE `cursussen`
733  MODIFY `cursusnr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
734--
735-- AUTO_INCREMENT for table `studenten`
736--
737ALTER TABLE `studenten`
738  MODIFY `studnr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
739--
740-- Constraints for dumped tables
741--
742
743--
744-- Constraints for table `studenten_cursussen`
745--
746ALTER TABLE `studenten_cursussen`
747  ADD CONSTRAINT `studenten_cursussen_ibfk_1` FOREIGN KEY (`studnr`) REFERENCES `studenten` (`studnr`),
748  ADD CONSTRAINT `studenten_cursussen_ibfk_2` FOREIGN KEY (`cursusnr`) REFERENCES `cursussen` (`cursusnr`);
749--
750-- Database: `astralstrifes`
751--
752CREATE DATABASE IF NOT EXISTS `astralstrifes` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
753USE `astralstrifes`;
754
755-- --------------------------------------------------------
756
757--
758-- Table structure for table `bullets`
759--
760
761CREATE TABLE `bullets` (
762  `item_id` int(11) NOT NULL,
763  `velocity` int(11) DEFAULT NULL,
764  `image` varchar(45) DEFAULT NULL
765) ENGINE=InnoDB DEFAULT CHARSET=latin1;
766
767-- --------------------------------------------------------
768
769--
770-- Table structure for table `difficulties`
771--
772
773CREATE TABLE `difficulties` (
774  `difficulty_id` int(11) NOT NULL,
775  `difficulty_name` varchar(45) DEFAULT NULL,
776  `shootingEnemyScore` int(11) NOT NULL,
777  `normalEnemyScore` int(11) NOT NULL,
778  `saturnEnemyScore` int(11) NOT NULL,
779  `normalEnemySpeed` float DEFAULT NULL,
780  `shootingEnemyShoot` int(11) NOT NULL,
781  `saturnEnemyMove` float NOT NULL,
782  `shootingEnemyMulti` int(11) NOT NULL,
783  `notmalEnemyMulti` int(11) NOT NULL,
784  `saturnEnemyMulti` int(11) NOT NULL,
785  `swiftyduration` int(11) NOT NULL,
786  `adhdPower` int(11) NOT NULL,
787  `spawnSpeed` int(11) NOT NULL,
788  `playerShootSpeed` int(11) NOT NULL,
789  `normalEDamage` int(11) NOT NULL,
790  `shootEDamage` int(11) NOT NULL,
791  `satEDamage` int(11) NOT NULL,
792  `eBulletDamage` int(11) NOT NULL
793) ENGINE=InnoDB DEFAULT CHARSET=latin1;
794
795--
796-- Dumping data for table `difficulties`
797--
798
799INSERT INTO `difficulties` (`difficulty_id`, `difficulty_name`, `shootingEnemyScore`, `normalEnemyScore`, `saturnEnemyScore`, `normalEnemySpeed`, `shootingEnemyShoot`, `saturnEnemyMove`, `shootingEnemyMulti`, `notmalEnemyMulti`, `saturnEnemyMulti`, `swiftyduration`, `adhdPower`, `spawnSpeed`, `playerShootSpeed`, `normalEDamage`, `shootEDamage`, `satEDamage`, `eBulletDamage`) VALUES
800(1, 'easy', 15, 10, 20, 0.2, 1000, 0.2, 1, 1, 1, 3000, 30, 3000, 100, 10, 10, 10, 10),
801(2, 'medium', 25, 15, 30, 0.3, 600, 0.3, 2, 1, 1, 4000, 25, 2500, 90, 15, 15, 15, 15),
802(3, 'hard', 35, 20, 40, 0.4, 400, 0.5, 2, 2, 2, 5000, 20, 2000, 80, 20, 20, 20, 20);
803
804-- --------------------------------------------------------
805
806--
807-- Table structure for table `enemies`
808--
809
810CREATE TABLE `enemies` (
811  `enemy_id` int(11) NOT NULL,
812  `enemy_name` varchar(45) NOT NULL,
813  `image` varchar(45) DEFAULT NULL,
814  `shoot` tinyint(1) DEFAULT NULL,
815  `health` int(11) DEFAULT NULL,
816  `moves` tinyint(1) DEFAULT NULL,
817  `manna_score` int(11) DEFAULT NULL
818) ENGINE=InnoDB DEFAULT CHARSET=latin1;
819
820--
821-- Dumping data for table `enemies`
822--
823
824INSERT INTO `enemies` (`enemy_id`, `enemy_name`, `image`, `shoot`, `health`, `moves`, `manna_score`) VALUES
825(1, 'shootingenemy', 'resources/gameSprites/planet4.png', 1, NULL, 0, 200),
826(2, 'saturnenemy', 'resources/gameSprites/planet6.png', 1, NULL, 1, NULL),
827(3, 'normalenemy', 'resources/gameSprites/planet1.png', 0, NULL, 1, 150);
828
829-- --------------------------------------------------------
830
831--
832-- Table structure for table `game`
833--
834
835CREATE TABLE `game` (
836  `game_id` int(11) NOT NULL,
837  `score` int(11) DEFAULT NULL,
838  `wave_id` int(11) DEFAULT NULL,
839  `difficulty_id` int(11) DEFAULT NULL
840) ENGINE=InnoDB DEFAULT CHARSET=latin1;
841
842-- --------------------------------------------------------
843
844--
845-- Table structure for table `items`
846--
847
848CREATE TABLE `items` (
849  `item_id` int(11) NOT NULL,
850  `item_name` varchar(45) NOT NULL,
851  `type` varchar(45) DEFAULT NULL,
852  `cost` int(11) DEFAULT NULL,
853  `image` varchar(45) DEFAULT NULL
854) ENGINE=InnoDB DEFAULT CHARSET=latin1;
855
856--
857-- Dumping data for table `items`
858--
859
860INSERT INTO `items` (`item_id`, `item_name`, `type`, `cost`, `image`) VALUES
861(1, 'attackdrone', 'drone', NULL, 'resources/gameSprites/attack1.png'),
862(3, 'healdrone', 'drone', NULL, 'resources/gameSprites/healdrone.png'),
863(4, 'killdrone', 'drone', NULL, 'resources/gameSprites/attack2.png'),
864(5, 'dronebullet', 'bullet', NULL, 'resources/gameSprites/attackDroneBullet.png'),
865(6, 'swifty', 'powerup', NULL, 'resources/gameSprites/swifty.png');
866
867-- --------------------------------------------------------
868
869--
870-- Table structure for table `powerup`
871--
872
873CREATE TABLE `powerup` (
874  `item_id` int(11) NOT NULL,
875  `skill` varchar(45) DEFAULT NULL
876) ENGINE=InnoDB DEFAULT CHARSET=latin1;
877
878--
879-- Dumping data for table `powerup`
880--
881
882INSERT INTO `powerup` (`item_id`, `skill`) VALUES
883(6, NULL);
884
885-- --------------------------------------------------------
886
887--
888-- Table structure for table `ranks`
889--
890
891CREATE TABLE `ranks` (
892  `rank_id` int(11) NOT NULL,
893  `rank_name` varchar(45) DEFAULT NULL,
894  `XP_needed` int(11) DEFAULT NULL
895) ENGINE=InnoDB DEFAULT CHARSET=latin1;
896
897--
898-- Dumping data for table `ranks`
899--
900
901INSERT INTO `ranks` (`rank_id`, `rank_name`, `XP_needed`) VALUES
902(1, 'Pluto', NULL),
903(2, 'Moon', NULL),
904(3, 'Mercury', NULL),
905(4, 'Mars', NULL),
906(5, 'Venus', NULL),
907(6, 'Earth', NULL),
908(7, 'Neptune', NULL),
909(8, 'Uranus', NULL),
910(9, 'Saturn', NULL),
911(10, 'Jupiter', NULL),
912(11, 'Proxima Centauri', NULL),
913(12, 'Sun', NULL),
914(13, 'UY Scuti', NULL),
915(14, 'Andromeda', NULL),
916(15, 'Heliosphere', NULL),
917(16, 'Galaxy', NULL),
918(17, 'Milky Way', NULL);
919
920-- --------------------------------------------------------
921
922--
923-- Table structure for table `skins`
924--
925
926CREATE TABLE `skins` (
927  `item_id` int(11) NOT NULL,
928  `unlock_lvl` int(11) DEFAULT NULL
929) ENGINE=InnoDB DEFAULT CHARSET=latin1;
930
931-- --------------------------------------------------------
932
933--
934-- Table structure for table `supportdrones`
935--
936
937CREATE TABLE `supportdrones` (
938  `item_id` int(11) NOT NULL,
939  `unlock_lvl` int(11) DEFAULT NULL,
940  `skill` varchar(45) DEFAULT NULL,
941  `drone_xp` int(11) DEFAULT NULL
942) ENGINE=InnoDB DEFAULT CHARSET=latin1;
943
944--
945-- Dumping data for table `supportdrones`
946--
947
948INSERT INTO `supportdrones` (`item_id`, `unlock_lvl`, `skill`, `drone_xp`) VALUES
949(1, NULL, NULL, NULL),
950(3, NULL, NULL, NULL),
951(4, NULL, NULL, NULL);
952
953-- --------------------------------------------------------
954
955--
956-- Table structure for table `users`
957--
958
959CREATE TABLE `users` (
960  `userid` int(11) NOT NULL,
961  `username` varchar(25) NOT NULL,
962  `password` varchar(128) NOT NULL,
963  `email` varchar(45) NOT NULL,
964  `XP` int(11) DEFAULT NULL,
965  `highscore` int(11) DEFAULT NULL,
966  `astrals` int(11) DEFAULT NULL,
967  `game_id` int(11) DEFAULT NULL,
968  `rank_id` int(11) DEFAULT NULL
969) ENGINE=InnoDB DEFAULT CHARSET=latin1;
970
971--
972-- Dumping data for table `users`
973--
974
975INSERT INTO `users` (`userid`, `username`, `password`, `email`, `XP`, `highscore`, `astrals`, `game_id`, `rank_id`) VALUES
976(3, 'AstralKing', 'astral123', 'astral@outlook.com', NULL, NULL, NULL, NULL, 3),
977(4, 'VangeelJ', 'lol123', 'jensvangeel@zz.com', NULL, 1500, NULL, NULL, 2),
978(5, 'Pwn0z', 'gRt', 'PownD@gmail.com', NULL, 10000, NULL, NULL, 1),
979(6, 'laurens', 'l', 'laurens@gmail.com', NULL, NULL, NULL, NULL, 4),
980(7, 'jorre', 'jorre', 'jorre', NULL, NULL, NULL, NULL, 5),
981(8, 'JensVangeel', 'jens', 'jensvangeel@hotmail.com', NULL, NULL, NULL, NULL, 6);
982
983-- --------------------------------------------------------
984
985--
986-- Table structure for table `wave_enemies`
987--
988
989CREATE TABLE `wave_enemies` (
990  `wave_id` int(11) NOT NULL,
991  `enemy_id` int(11) NOT NULL,
992  `amount` int(11) NOT NULL
993) ENGINE=InnoDB DEFAULT CHARSET=latin1;
994
995--
996-- Dumping data for table `wave_enemies`
997--
998
999INSERT INTO `wave_enemies` (`wave_id`, `enemy_id`, `amount`) VALUES
1000(1, 1, 5),
1001(1, 3, 10),
1002(2, 1, 3),
1003(2, 2, 5),
1004(2, 3, 15),
1005(3, 1, 6),
1006(3, 2, 10),
1007(3, 3, 20),
1008(4, 1, 12),
1009(4, 2, 15),
1010(4, 3, 25),
1011(5, 1, 16),
1012(5, 2, 20),
1013(5, 3, 30);
1014
1015-- --------------------------------------------------------
1016
1017--
1018-- Table structure for table `waves`
1019--
1020
1021CREATE TABLE `waves` (
1022  `wave_id` int(11) NOT NULL,
1023  `level_name` varchar(45) DEFAULT NULL
1024) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1025
1026--
1027-- Dumping data for table `waves`
1028--
1029
1030INSERT INTO `waves` (`wave_id`, `level_name`) VALUES
1031(1, 'wave1'),
1032(2, 'wave2'),
1033(3, 'wave3'),
1034(4, 'wave4'),
1035(5, 'wave5'),
1036(6, 'wave6'),
1037(7, 'wave7'),
1038(8, 'wave8'),
1039(9, 'wave9'),
1040(10, 'wave10'),
1041(11, 'wave11'),
1042(12, 'wave12');
1043
1044--
1045-- Indexes for dumped tables
1046--
1047
1048--
1049-- Indexes for table `bullets`
1050--
1051ALTER TABLE `bullets`
1052  ADD PRIMARY KEY (`item_id`);
1053
1054--
1055-- Indexes for table `difficulties`
1056--
1057ALTER TABLE `difficulties`
1058  ADD PRIMARY KEY (`difficulty_id`);
1059
1060--
1061-- Indexes for table `enemies`
1062--
1063ALTER TABLE `enemies`
1064  ADD PRIMARY KEY (`enemy_id`);
1065
1066--
1067-- Indexes for table `game`
1068--
1069ALTER TABLE `game`
1070  ADD PRIMARY KEY (`game_id`),
1071  ADD KEY `wave_game_idx` (`wave_id`),
1072  ADD KEY `difficulty_game_idx` (`difficulty_id`);
1073
1074--
1075-- Indexes for table `items`
1076--
1077ALTER TABLE `items`
1078  ADD PRIMARY KEY (`item_id`);
1079
1080--
1081-- Indexes for table `powerup`
1082--
1083ALTER TABLE `powerup`
1084  ADD PRIMARY KEY (`item_id`);
1085
1086--
1087-- Indexes for table `ranks`
1088--
1089ALTER TABLE `ranks`
1090  ADD PRIMARY KEY (`rank_id`);
1091
1092--
1093-- Indexes for table `skins`
1094--
1095ALTER TABLE `skins`
1096  ADD PRIMARY KEY (`item_id`);
1097
1098--
1099-- Indexes for table `supportdrones`
1100--
1101ALTER TABLE `supportdrones`
1102  ADD PRIMARY KEY (`item_id`);
1103
1104--
1105-- Indexes for table `users`
1106--
1107ALTER TABLE `users`
1108  ADD PRIMARY KEY (`userid`),
1109  ADD KEY `player_game_idx` (`game_id`);
1110
1111--
1112-- Indexes for table `wave_enemies`
1113--
1114ALTER TABLE `wave_enemies`
1115  ADD PRIMARY KEY (`wave_id`,`enemy_id`),
1116  ADD KEY `wave_enemy_idx` (`enemy_id`);
1117
1118--
1119-- Indexes for table `waves`
1120--
1121ALTER TABLE `waves`
1122  ADD PRIMARY KEY (`wave_id`);
1123
1124--
1125-- AUTO_INCREMENT for dumped tables
1126--
1127
1128--
1129-- AUTO_INCREMENT for table `difficulties`
1130--
1131ALTER TABLE `difficulties`
1132  MODIFY `difficulty_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
1133--
1134-- AUTO_INCREMENT for table `enemies`
1135--
1136ALTER TABLE `enemies`
1137  MODIFY `enemy_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
1138--
1139-- AUTO_INCREMENT for table `game`
1140--
1141ALTER TABLE `game`
1142  MODIFY `game_id` int(11) NOT NULL AUTO_INCREMENT;
1143--
1144-- AUTO_INCREMENT for table `items`
1145--
1146ALTER TABLE `items`
1147  MODIFY `item_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
1148--
1149-- AUTO_INCREMENT for table `ranks`
1150--
1151ALTER TABLE `ranks`
1152  MODIFY `rank_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
1153--
1154-- AUTO_INCREMENT for table `users`
1155--
1156ALTER TABLE `users`
1157  MODIFY `userid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
1158--
1159-- AUTO_INCREMENT for table `waves`
1160--
1161ALTER TABLE `waves`
1162  MODIFY `wave_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
1163--
1164-- Constraints for dumped tables
1165--
1166
1167--
1168-- Constraints for table `bullets`
1169--
1170ALTER TABLE `bullets`
1171  ADD CONSTRAINT `bullet_item` FOREIGN KEY (`item_id`) REFERENCES `items` (`item_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
1172
1173--
1174-- Constraints for table `game`
1175--
1176ALTER TABLE `game`
1177  ADD CONSTRAINT `difficulty_game` FOREIGN KEY (`difficulty_id`) REFERENCES `difficulties` (`difficulty_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1178  ADD CONSTRAINT `wave_game` FOREIGN KEY (`wave_id`) REFERENCES `waves` (`wave_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
1179
1180--
1181-- Constraints for table `powerup`
1182--
1183ALTER TABLE `powerup`
1184  ADD CONSTRAINT `item_powup` FOREIGN KEY (`item_id`) REFERENCES `items` (`item_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
1185
1186--
1187-- Constraints for table `skins`
1188--
1189ALTER TABLE `skins`
1190  ADD CONSTRAINT `item_skin` FOREIGN KEY (`item_id`) REFERENCES `items` (`item_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
1191
1192--
1193-- Constraints for table `users`
1194--
1195ALTER TABLE `users`
1196  ADD CONSTRAINT `player_game` FOREIGN KEY (`game_id`) REFERENCES `game` (`game_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
1197
1198--
1199-- Constraints for table `wave_enemies`
1200--
1201ALTER TABLE `wave_enemies`
1202  ADD CONSTRAINT `enemy_id` FOREIGN KEY (`enemy_id`) REFERENCES `enemies` (`enemy_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1203  ADD CONSTRAINT `wave_id` FOREIGN KEY (`wave_id`) REFERENCES `waves` (`wave_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
1204--
1205-- Database: `examshop`
1206--
1207CREATE DATABASE IF NOT EXISTS `examshop` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
1208USE `examshop`;
1209
1210-- --------------------------------------------------------
1211
1212--
1213-- Table structure for table `category`
1214--
1215
1216CREATE TABLE `category` (
1217  `id` int(11) NOT NULL,
1218  `name` varchar(50) DEFAULT NULL
1219) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1220
1221--
1222-- Dumping data for table `category`
1223--
1224
1225INSERT INTO `category` (`id`, `name`) VALUES
1226(1, 'Beverages'),
1227(2, 'Condiments'),
1228(3, 'Confections'),
1229(4, 'Dairy Products'),
1230(5, 'Grains/Cereals'),
1231(6, 'Meat/Poultry'),
1232(7, 'Produce'),
1233(8, 'Seafood');
1234
1235-- --------------------------------------------------------
1236
1237--
1238-- Table structure for table `product`
1239--
1240
1241CREATE TABLE `product` (
1242  `id` int(11) NOT NULL,
1243  `name` varchar(50) DEFAULT NULL,
1244  `price` double DEFAULT NULL,
1245  `category_id` int(11) DEFAULT NULL
1246) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1247
1248--
1249-- Dumping data for table `product`
1250--
1251
1252INSERT INTO `product` (`id`, `name`, `price`, `category_id`) VALUES
1253(1, 'Chai', 18, 1),
1254(2, 'Chang', 19, 1),
1255(3, 'Aniseed Syrup', 10, 2),
1256(4, 'Chef Anton\'s Cajun Seasoning', 22, 2),
1257(5, 'Chef Anton\'s Gumbo Mix', 21.35, 2),
1258(6, 'Grandma\'s Boysenberry Spread', 25, 2),
1259(7, 'Uncle Bob\'s Organic Dried Pears', 30, 7),
1260(8, 'Northwoods Cranberry Sauce', 40, 2),
1261(9, 'Mishi Kobe Niku', 97, 6),
1262(10, 'Ikura', 31, 8),
1263(11, 'Queso Cabrales', 21, 4),
1264(12, 'Queso Manchego La Pastora', 38, 4),
1265(13, 'Konbu', 6, 8),
1266(14, 'Tofu', 23.25, 7),
1267(15, 'Genen Shouyu', 15.5, 2),
1268(16, 'Pavlova', 17.45, 3),
1269(17, 'Alice Mutton', 39, 6),
1270(18, 'Carnarvon Tigers', 62.5, 8),
1271(19, 'Teatime Chocolate Biscuits', 9.2, 3),
1272(20, 'Sir Rodney\'s Marmalade', 81, 3),
1273(21, 'Sir Rodney\'s Scones', 10, 3);
1274
1275--
1276-- Indexes for dumped tables
1277--
1278
1279--
1280-- Indexes for table `category`
1281--
1282ALTER TABLE `category`
1283  ADD PRIMARY KEY (`id`);
1284
1285--
1286-- Indexes for table `product`
1287--
1288ALTER TABLE `product`
1289  ADD PRIMARY KEY (`id`);
1290
1291--
1292-- AUTO_INCREMENT for dumped tables
1293--
1294
1295--
1296-- AUTO_INCREMENT for table `category`
1297--
1298ALTER TABLE `category`
1299  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
1300--
1301-- AUTO_INCREMENT for table `product`
1302--
1303ALTER TABLE `product`
1304  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;--
1305-- Database: `forms`
1306--
1307CREATE DATABASE IF NOT EXISTS `forms` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
1308USE `forms`;
1309
1310-- --------------------------------------------------------
1311
1312--
1313-- Table structure for table `fields`
1314--
1315
1316CREATE TABLE `fields` (
1317  `idfields` int(11) NOT NULL,
1318  `form` int(11) NOT NULL,
1319  `name` varchar(45) DEFAULT NULL
1320) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1321
1322--
1323-- Dumping data for table `fields`
1324--
1325
1326INSERT INTO `fields` (`idfields`, `form`, `name`) VALUES
1327(0, 0, 'voornaam'),
1328(1, 0, 'achternaam'),
1329(2, 0, 'hobby'),
1330(3, 1, 'voornaam'),
1331(4, 1, 'achternaam'),
1332(5, 1, 'leeftijd'),
1333(6, 1, 'hobby'),
1334(7, 1, 'geslacht'),
1335(8, 1, 'bloedgroep'),
1336(9, 1, 'email');
1337
1338-- --------------------------------------------------------
1339
1340--
1341-- Table structure for table `forms`
1342--
1343
1344CREATE TABLE `forms` (
1345  `idforms` int(11) NOT NULL,
1346  `name` varchar(45) NOT NULL
1347) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1348
1349--
1350-- Dumping data for table `forms`
1351--
1352
1353INSERT INTO `forms` (`idforms`, `name`) VALUES
1354(0, 'Korte Vragenlijst'),
1355(1, 'Lange Vragenlijst');
1356
1357--
1358-- Indexes for dumped tables
1359--
1360
1361--
1362-- Indexes for table `fields`
1363--
1364ALTER TABLE `fields`
1365  ADD PRIMARY KEY (`idfields`),
1366  ADD KEY `fk_field_idx` (`form`);
1367
1368--
1369-- Indexes for table `forms`
1370--
1371ALTER TABLE `forms`
1372  ADD PRIMARY KEY (`idforms`);
1373
1374--
1375-- Constraints for dumped tables
1376--
1377
1378--
1379-- Constraints for table `fields`
1380--
1381ALTER TABLE `fields`
1382  ADD CONSTRAINT `fk_field` FOREIGN KEY (`form`) REFERENCES `forms` (`idforms`) ON DELETE NO ACTION ON UPDATE NO ACTION;
1383--
1384-- Database: `lapdb`
1385--
1386CREATE DATABASE IF NOT EXISTS `lapdb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
1387USE `lapdb`;
1388
1389-- --------------------------------------------------------
1390
1391--
1392-- Table structure for table `Artikels`
1393--
1394
1395CREATE TABLE `Artikels` (
1396  `anr` char(3) NOT NULL,
1397  `anaam` char(15) DEFAULT NULL,
1398  `kleur` char(10) DEFAULT NULL,
1399  `gewicht` int(11) DEFAULT NULL,
1400  `plaats` char(15) DEFAULT NULL
1401) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1402
1403--
1404-- Dumping data for table `Artikels`
1405--
1406
1407INSERT INTO `Artikels` (`anr`, `anaam`, `kleur`, `gewicht`, `plaats`) VALUES
1408('A1', 'Moer', 'Rood', 12, 'Brussel'),
1409('A2', 'Bout', 'Groen', 17, 'Antwerpen'),
1410('A3', 'Schroef', 'Blauw', 17, 'Leuven'),
1411('A4', 'Schroef', 'Rood', 14, 'Brussel'),
1412('A5', 'Nagel', 'Blauw', 12, 'Antwerpen'),
1413('A6', 'Plug', 'Rood', 19, 'Brussel');
1414
1415-- --------------------------------------------------------
1416
1417--
1418-- Table structure for table `Leveranciers`
1419--
1420
1421CREATE TABLE `Leveranciers` (
1422  `lnr` char(3) NOT NULL,
1423  `lnaam` char(15) DEFAULT NULL,
1424  `STATUS` int(11) DEFAULT NULL,
1425  `plaats` char(15) DEFAULT NULL
1426) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1427
1428--
1429-- Dumping data for table `Leveranciers`
1430--
1431
1432INSERT INTO `Leveranciers` (`lnr`, `lnaam`, `STATUS`, `plaats`) VALUES
1433('L1', 'Smith', 20, 'Brussel'),
1434('L2', 'Jones', 10, 'Antwerpen'),
1435('L3', 'Blake', 30, 'Antwerpen'),
1436('L4', 'Clark', 20, 'Brussel'),
1437('L5', 'Adams', 30, 'Gent'),
1438('L6', 'Ackermans', 0, 'Brugge');
1439
1440-- --------------------------------------------------------
1441
1442--
1443-- Table structure for table `Leveringen`
1444--
1445
1446CREATE TABLE `Leveringen` (
1447  `lnr` char(3) NOT NULL,
1448  `anr` char(3) NOT NULL,
1449  `pnr` char(3) NOT NULL,
1450  `hoev` int(11) DEFAULT NULL
1451) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1452
1453--
1454-- Dumping data for table `Leveringen`
1455--
1456
1457INSERT INTO `Leveringen` (`lnr`, `anr`, `pnr`, `hoev`) VALUES
1458('L1', 'A1', 'P1', 200),
1459('L1', 'A1', 'P4', 700),
1460('L2', 'A3', 'P1', 400),
1461('L2', 'A3', 'P2', 200),
1462('L2', 'A3', 'P3', 200),
1463('L2', 'A3', 'P4', 500),
1464('L2', 'A3', 'P5', 600),
1465('L2', 'A3', 'P6', 400),
1466('L2', 'A3', 'P7', 800),
1467('L2', 'A5', 'P2', 100),
1468('L3', 'A3', 'P1', 200),
1469('L3', 'A4', 'P2', 500),
1470('L4', 'A6', 'P3', 300),
1471('L4', 'A6', 'P7', 300),
1472('L5', 'A1', 'P4', 100),
1473('L5', 'A2', 'P2', 200),
1474('L5', 'A2', 'P4', 100),
1475('L5', 'A3', 'P4', 200),
1476('L5', 'A4', 'P4', 800),
1477('L5', 'A5', 'P4', 400),
1478('L5', 'A5', 'P5', 500),
1479('L5', 'A5', 'P7', 100),
1480('L5', 'A6', 'P2', 200),
1481('L5', 'A6', 'P4', 500);
1482
1483-- --------------------------------------------------------
1484
1485--
1486-- Table structure for table `Projecten`
1487--
1488
1489CREATE TABLE `Projecten` (
1490  `pnr` char(3) NOT NULL,
1491  `pnaam` char(15) DEFAULT NULL,
1492  `plaats` char(15) DEFAULT NULL
1493) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1494
1495--
1496-- Dumping data for table `Projecten`
1497--
1498
1499INSERT INTO `Projecten` (`pnr`, `pnaam`, `plaats`) VALUES
1500('P1', 'Sorter', 'Antwerpen'),
1501('P2', 'Display', 'Leuven'),
1502('P3', 'OCR', 'Gent'),
1503('P4', 'Console', 'Gent'),
1504('P5', 'RAID', 'Brussel'),
1505('P6', 'EDS', 'Namen'),
1506('P7', 'Tape', 'Brussel');
1507
1508--
1509-- Indexes for dumped tables
1510--
1511
1512--
1513-- Indexes for table `Artikels`
1514--
1515ALTER TABLE `Artikels`
1516  ADD PRIMARY KEY (`anr`);
1517
1518--
1519-- Indexes for table `Leveranciers`
1520--
1521ALTER TABLE `Leveranciers`
1522  ADD PRIMARY KEY (`lnr`);
1523
1524--
1525-- Indexes for table `Leveringen`
1526--
1527ALTER TABLE `Leveringen`
1528  ADD PRIMARY KEY (`lnr`,`anr`,`pnr`),
1529  ADD KEY `fk2_levering` (`anr`),
1530  ADD KEY `fk3_levering` (`pnr`);
1531
1532--
1533-- Indexes for table `Projecten`
1534--
1535ALTER TABLE `Projecten`
1536  ADD PRIMARY KEY (`pnr`);
1537
1538--
1539-- Constraints for dumped tables
1540--
1541
1542--
1543-- Constraints for table `Leveringen`
1544--
1545ALTER TABLE `Leveringen`
1546  ADD CONSTRAINT `fk1_levering` FOREIGN KEY (`lnr`) REFERENCES `leveranciers` (`lnr`),
1547  ADD CONSTRAINT `fk2_levering` FOREIGN KEY (`anr`) REFERENCES `artikels` (`anr`),
1548  ADD CONSTRAINT `fk3_levering` FOREIGN KEY (`pnr`) REFERENCES `projecten` (`pnr`);
1549--
1550-- Database: `moviebase`
1551--
1552CREATE DATABASE IF NOT EXISTS `moviebase` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
1553USE `moviebase`;
1554
1555-- --------------------------------------------------------
1556
1557--
1558-- Table structure for table `genre`
1559--
1560
1561CREATE TABLE `genre` (
1562  `id` int(11) NOT NULL,
1563  `name` varchar(128) DEFAULT NULL
1564) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1565
1566--
1567-- Dumping data for table `genre`
1568--
1569
1570INSERT INTO `genre` (`id`, `name`) VALUES
1571(1, 'Action'),
1572(2, 'Adventure'),
1573(3, 'Comedy'),
1574(4, 'Detective'),
1575(5, 'Drama'),
1576(6, 'Fantasy'),
1577(7, 'Horror'),
1578(8, 'Sci-Fi'),
1579(9, 'Thriller'),
1580(10, 'Western');
1581
1582-- --------------------------------------------------------
1583
1584--
1585-- Table structure for table `movie`
1586--
1587
1588CREATE TABLE `movie` (
1589  `id` int(11) NOT NULL,
1590  `title` varchar(128) DEFAULT NULL,
1591  `genre_id` int(11) DEFAULT NULL,
1592  `year` int(11) DEFAULT NULL,
1593  `stars` tinyint(4) DEFAULT NULL
1594) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1595
1596--
1597-- Dumping data for table `movie`
1598--
1599
1600INSERT INTO `movie` (`id`, `title`, `genre_id`, `year`, `stars`) VALUES
1601(1, 'The Hunger Games', 6, 2012, 3),
1602(2, 'Star Trek Beyond', 8, 2016, 2),
1603(3, 'Divergent', 6, 2014, 3),
1604(4, 'Harry Potter and the Philosopher\'s Stone', 6, 2002, 4);
1605
1606--
1607-- Indexes for dumped tables
1608--
1609
1610--
1611-- Indexes for table `genre`
1612--
1613ALTER TABLE `genre`
1614  ADD PRIMARY KEY (`id`);
1615
1616--
1617-- Indexes for table `movie`
1618--
1619ALTER TABLE `movie`
1620  ADD PRIMARY KEY (`id`);
1621
1622--
1623-- AUTO_INCREMENT for dumped tables
1624--
1625
1626--
1627-- AUTO_INCREMENT for table `genre`
1628--
1629ALTER TABLE `genre`
1630  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
1631--
1632-- AUTO_INCREMENT for table `movie`
1633--
1634ALTER TABLE `movie`
1635  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;--
1636-- Database: `oldtimer`
1637--
1638CREATE DATABASE IF NOT EXISTS `oldtimer` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
1639USE `oldtimer`;
1640
1641-- --------------------------------------------------------
1642
1643--
1644-- Table structure for table `auto`
1645--
1646
1647CREATE TABLE `auto` (
1648  `autonr` int(11) NOT NULL,
1649  `passagiers` int(11) DEFAULT NULL,
1650  `typenaam` char(30) DEFAULT NULL,
1651  `bouwjaar` int(11) DEFAULT NULL,
1652  `waarde` int(11) DEFAULT NULL,
1653  `lidnr` int(11) DEFAULT NULL
1654) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1655
1656--
1657-- Dumping data for table `auto`
1658--
1659
1660INSERT INTO `auto` (`autonr`, `passagiers`, `typenaam`, `bouwjaar`, `waarde`, `lidnr`) VALUES
1661(1, 4, 'Ford MODEL A', 1930, 3000, 3),
1662(2, 4, 'Rolls-Royce Phantom II', 1931, 85000, 1),
1663(3, 4, 'Austin Ten', 1936, 3800, 5),
1664(4, 4, 'Duesenberg Model-J', 1932, 65000, 8),
1665(5, 2, 'Riley 9HP IMP', 1935, 4500, 2),
1666(6, 2, 'Singer Le Mans Speedster', 1934, 12500, 1),
1667(7, 2, 'Singer SM Roadster', 1954, 2500, 4),
1668(8, 2, 'Jaguar XK 120', 1952, 6500, 11),
1669(9, 2, 'Hornet Special', 1935, 5600, 12),
1670(10, 2, 'Oldsmobile Curved Dash', 1901, 8000, 1),
1671(11, 4, 'Austin Seven Chummy', 1923, 2000, 3),
1672(12, 4, 'Bentley R-Type', 1952, 4200, 14);
1673
1674-- --------------------------------------------------------
1675
1676--
1677-- Table structure for table `deelnemer`
1678--
1679
1680CREATE TABLE `deelnemer` (
1681  `autonr` int(11) NOT NULL,
1682  `evenementnr` int(11) NOT NULL
1683) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1684
1685--
1686-- Dumping data for table `deelnemer`
1687--
1688
1689INSERT INTO `deelnemer` (`autonr`, `evenementnr`) VALUES
1690(1, 201501),
1691(2, 201501),
1692(2, 201502),
1693(4, 201502),
1694(7, 201502),
1695(8, 201502),
1696(10, 201502),
1697(11, 201502),
1698(2, 201503),
1699(4, 201503),
1700(6, 201503),
1701(10, 201503),
1702(11, 201503),
1703(2, 201504),
1704(4, 201504),
1705(6, 201504),
1706(10, 201504),
1707(11, 201504),
1708(1, 201505),
1709(3, 201505),
1710(6, 201505),
1711(12, 201505);
1712
1713-- --------------------------------------------------------
1714
1715--
1716-- Table structure for table `evenement`
1717--
1718
1719CREATE TABLE `evenement` (
1720  `evenementnr` int(11) NOT NULL,
1721  `evenementnaam` char(25) DEFAULT NULL,
1722  `evenementdatum` date DEFAULT NULL,
1723  `locatie` char(20) DEFAULT NULL,
1724  `soort` char(10) DEFAULT NULL,
1725  `prijs` int(11) DEFAULT NULL
1726) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1727
1728--
1729-- Dumping data for table `evenement`
1730--
1731
1732INSERT INTO `evenement` (`evenementnr`, `evenementnaam`, `evenementdatum`, `locatie`, `soort`, `prijs`) VALUES
1733(201501, 'Bollentocht', '2015-06-17', 'Keukenhof', 'Optocht', 25),
1734(201502, 'Zandvoort 2015', '2015-07-16', 'Boulevard', 'Toerrit', 45),
1735(201503, 'Amsterdam OldTimer', '2015-08-02', 'Damrak', 'Optocht', 15),
1736(201504, 'Amsterdam OldTimer', '2015-08-05', 'DeRai', 'Show', 5),
1737(201505, 'Hillegom Feestweek', '2015-08-19', 'Beeklaan', 'Toerrit', 38);
1738
1739-- --------------------------------------------------------
1740
1741--
1742-- Table structure for table `lid`
1743--
1744
1745CREATE TABLE `lid` (
1746  `lidnr` int(11) NOT NULL,
1747  `lidnaam` char(20) DEFAULT NULL,
1748  `soort` char(6) DEFAULT NULL,
1749  `adres` char(50) DEFAULT NULL,
1750  `plaats` char(50) DEFAULT NULL
1751) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1752
1753--
1754-- Dumping data for table `lid`
1755--
1756
1757INSERT INTO `lid` (`lidnr`, `lidnaam`, `soort`, `adres`, `plaats`) VALUES
1758(1, 'Verbeek', 'SENIOR', 'Parklaan 210', 'Sassenheim'),
1759(2, 'Schut', 'SENIOR', 'Bosweg 17', 'Noordwijk'),
1760(3, 'Vogel', 'SENIOR', 'Schans 35', 'Noordwijk'),
1761(4, 'Lenstra', 'SENIOR', 'Meerweg 24', 'Heemstede'),
1762(5, 'Pronk', 'SENIOR', 'Dreef 11', 'Aalsmeer'),
1763(6, 'Mol', 'JUNIOR', 'Hogeweg 94', 'Zandvoort'),
1764(7, 'Otten', 'JUNIOR', 'Hogeweg 96', 'Zandvoort'),
1765(8, 'Dregt', 'JUNIOR', 'Vosselaan 93', 'Hillegom'),
1766(9, 'Verbeek', 'SENIOR', 'Parklaan 210', 'Sassenheim'),
1767(10, 'Pronk', 'JUNIOR', 'Dreef 11', 'Aalsmeer'),
1768(11, 'Dekker', 'SENIOR', 'Lindenlaan 67', 'Sassenheim'),
1769(12, 'Wouters', 'JUNIOR', 'Emmaweg 32', 'Zandvoort'),
1770(13, 'Bos', 'JUNIOR', 'Dorpsstraat 210', 'Aalsmeer'),
1771(14, 'Bakker', 'JUNIOR', 'Mesdaglaan 84', 'Hillegom');
1772
1773--
1774-- Indexes for dumped tables
1775--
1776
1777--
1778-- Indexes for table `auto`
1779--
1780ALTER TABLE `auto`
1781  ADD PRIMARY KEY (`autonr`),
1782  ADD KEY `fk_auto` (`lidnr`);
1783
1784--
1785-- Indexes for table `deelnemer`
1786--
1787ALTER TABLE `deelnemer`
1788  ADD PRIMARY KEY (`autonr`,`evenementnr`),
1789  ADD KEY `fk2_deelnemer` (`evenementnr`);
1790
1791--
1792-- Indexes for table `evenement`
1793--
1794ALTER TABLE `evenement`
1795  ADD PRIMARY KEY (`evenementnr`);
1796
1797--
1798-- Indexes for table `lid`
1799--
1800ALTER TABLE `lid`
1801  ADD PRIMARY KEY (`lidnr`);
1802
1803--
1804-- Constraints for dumped tables
1805--
1806
1807--
1808-- Constraints for table `auto`
1809--
1810ALTER TABLE `auto`
1811  ADD CONSTRAINT `fk_auto` FOREIGN KEY (`lidnr`) REFERENCES `lid` (`lidnr`);
1812
1813--
1814-- Constraints for table `deelnemer`
1815--
1816ALTER TABLE `deelnemer`
1817  ADD CONSTRAINT `fk1_deelnemer` FOREIGN KEY (`autonr`) REFERENCES `auto` (`autonr`),
1818  ADD CONSTRAINT `fk2_deelnemer` FOREIGN KEY (`evenementnr`) REFERENCES `evenement` (`evenementnr`);
1819--
1820-- Database: `pizzaplace`
1821--
1822CREATE DATABASE IF NOT EXISTS `pizzaplace` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
1823USE `pizzaplace`;
1824
1825-- --------------------------------------------------------
1826
1827--
1828-- Table structure for table `pizza`
1829--
1830
1831CREATE TABLE `pizza` (
1832  `id` int(11) NOT NULL,
1833  `name` varchar(50) NOT NULL,
1834  `price` double NOT NULL,
1835  `vegetarian` tinyint(1) NOT NULL
1836) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1837
1838--
1839-- Dumping data for table `pizza`
1840--
1841
1842INSERT INTO `pizza` (`id`, `name`, `price`, `vegetarian`) VALUES
1843(1, 'Margherita', 5.99, 1),
1844(2, 'Prosciutto', 6.99, 0),
1845(3, 'Funghi', 5.99, 1),
1846(4, 'Napolitana', 8.99, 0);
1847
1848-- --------------------------------------------------------
1849
1850--
1851-- Table structure for table `pizza_topping`
1852--
1853
1854CREATE TABLE `pizza_topping` (
1855  `pizza_id` int(11) NOT NULL,
1856  `topping_id` int(11) NOT NULL
1857) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1858
1859--
1860-- Dumping data for table `pizza_topping`
1861--
1862
1863INSERT INTO `pizza_topping` (`pizza_id`, `topping_id`) VALUES
1864(1, 1),
1865(1, 6),
1866(2, 1),
1867(2, 2),
1868(2, 3),
1869(2, 6),
1870(3, 1),
1871(3, 2),
1872(3, 6),
1873(4, 1),
1874(4, 4),
1875(4, 5),
1876(4, 6);
1877
1878-- --------------------------------------------------------
1879
1880--
1881-- Table structure for table `topping`
1882--
1883
1884CREATE TABLE `topping` (
1885  `id` int(11) NOT NULL,
1886  `name` varchar(50) NOT NULL
1887) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1888
1889--
1890-- Dumping data for table `topping`
1891--
1892
1893INSERT INTO `topping` (`id`, `name`) VALUES
1894(1, 'tomatoes'),
1895(2, 'mushrooms'),
1896(3, 'ham'),
1897(4, 'ansjovis'),
1898(5, 'olives'),
1899(6, 'mozzarella');
1900
1901-- --------------------------------------------------------
1902
1903--
1904-- Table structure for table `user`
1905--
1906
1907CREATE TABLE `user` (
1908  `login` varchar(50) NOT NULL,
1909  `password` varchar(255) NOT NULL
1910) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1911
1912--
1913-- Dumping data for table `user`
1914--
1915
1916INSERT INTO `user` (`login`, `password`) VALUES
1917('els', 'els123'),
1918('jef', 'jef123');
1919
1920--
1921-- Indexes for dumped tables
1922--
1923
1924--
1925-- Indexes for table `pizza`
1926--
1927ALTER TABLE `pizza`
1928  ADD PRIMARY KEY (`id`);
1929
1930--
1931-- Indexes for table `pizza_topping`
1932--
1933ALTER TABLE `pizza_topping`
1934  ADD PRIMARY KEY (`pizza_id`,`topping_id`);
1935
1936--
1937-- Indexes for table `topping`
1938--
1939ALTER TABLE `topping`
1940  ADD PRIMARY KEY (`id`);
1941
1942--
1943-- Indexes for table `user`
1944--
1945ALTER TABLE `user`
1946  ADD PRIMARY KEY (`login`);
1947
1948--
1949-- AUTO_INCREMENT for dumped tables
1950--
1951
1952--
1953-- AUTO_INCREMENT for table `pizza`
1954--
1955ALTER TABLE `pizza`
1956  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
1957--
1958-- AUTO_INCREMENT for table `topping`
1959--
1960ALTER TABLE `topping`
1961  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;--
1962-- Database: `pokemon`
1963--
1964CREATE DATABASE IF NOT EXISTS `pokemon` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
1965USE `pokemon`;
1966
1967-- --------------------------------------------------------
1968
1969--
1970-- Table structure for table `location`
1971--
1972
1973CREATE TABLE `location` (
1974  `pokemonID` int(11) NOT NULL,
1975  `x` int(11) NOT NULL,
1976  `y` int(11) NOT NULL
1977) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1978
1979--
1980-- Dumping data for table `location`
1981--
1982
1983INSERT INTO `location` (`pokemonID`, `x`, `y`) VALUES
1984(1, 519, 154),
1985(76, 638, 105),
1986(1, 568, 137),
1987(1, 567, 142),
1988(1, 615, 124),
1989(1, 537, 106),
1990(2, 516, 133),
1991(2, 589, 130),
1992(2, 507, 145),
1993(1, 607, 198),
1994(1, 601, 100),
1995(1, 388, 129),
1996(1, 388, 124),
1997(1, 410, 125),
1998(1, 464, 132),
1999(1, 510, 181),
2000(1, 408, 119),
2001(1, 413, 118),
2002(1, 503, 115),
2003(1, 474, 96),
2004(1, 504, 82),
2005(1, 437, 107),
2006(1, 437, 196),
2007(1, 357, 197),
2008(1, 547, 98),
2009(1, 577, 75),
2010(1, 579, 134),
2011(1, 608, 167),
2012(1, 512, 117),
2013(1, 634, 125),
2014(1, 656, 86);
2015
2016-- --------------------------------------------------------
2017
2018--
2019-- Table structure for table `pokemon`
2020--
2021
2022CREATE TABLE `pokemon` (
2023  `id` int(11) NOT NULL,
2024  `identifier` varchar(45) DEFAULT NULL,
2025  `species_id` int(11) DEFAULT NULL,
2026  `height` int(11) DEFAULT NULL,
2027  `weight` int(11) DEFAULT NULL,
2028  `base_experience` int(11) DEFAULT NULL,
2029  `order` int(11) DEFAULT NULL,
2030  `is_default` int(11) DEFAULT NULL
2031) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2032
2033--
2034-- Dumping data for table `pokemon`
2035--
2036
2037INSERT INTO `pokemon` (`id`, `identifier`, `species_id`, `height`, `weight`, `base_experience`, `order`, `is_default`) VALUES
2038(1, 'bulbasaur', 1, 7, 69, 64, 1, 1),
2039(2, 'ivysaur', 2, 10, 130, 142, 2, 1),
2040(3, 'venusaur', 3, 20, 1000, 236, 3, 1),
2041(4, 'charmander', 4, 6, 85, 62, 5, 1),
2042(5, 'charmeleon', 5, 11, 190, 142, 6, 1),
2043(6, 'charizard', 6, 17, 905, 240, 7, 1),
2044(7, 'squirtle', 7, 5, 90, 63, 10, 1),
2045(8, 'wartortle', 8, 10, 225, 142, 11, 1),
2046(9, 'blastoise', 9, 16, 855, 239, 12, 1),
2047(10, 'caterpie', 10, 3, 29, 39, 14, 1),
2048(11, 'metapod', 11, 7, 99, 72, 15, 1),
2049(12, 'butterfree', 12, 11, 320, 178, 16, 1),
2050(13, 'weedle', 13, 3, 32, 39, 17, 1),
2051(14, 'kakuna', 14, 6, 100, 72, 18, 1),
2052(15, 'beedrill', 15, 10, 295, 178, 19, 1),
2053(16, 'pidgey', 16, 3, 18, 50, 21, 1),
2054(17, 'pidgeotto', 17, 11, 300, 122, 22, 1),
2055(18, 'pidgeot', 18, 15, 395, 216, 23, 1),
2056(19, 'rattata', 19, 3, 35, 51, 25, 1),
2057(20, 'raticate', 20, 7, 185, 145, 26, 1),
2058(21, 'spearow', 21, 3, 20, 52, 27, 1),
2059(22, 'fearow', 22, 12, 380, 155, 28, 1),
2060(23, 'ekans', 23, 20, 69, 58, 29, 1),
2061(24, 'arbok', 24, 35, 650, 153, 30, 1),
2062(25, 'pikachu', 25, 4, 60, 112, 32, 1),
2063(26, 'raichu', 26, 8, 300, 218, 39, 1),
2064(27, 'sandshrew', 27, 6, 120, 60, 40, 1),
2065(28, 'sandslash', 28, 10, 295, 158, 41, 1),
2066(29, 'nidoran-f', 29, 4, 70, 55, 42, 1),
2067(30, 'nidorina', 30, 8, 200, 128, 43, 1),
2068(31, 'nidoqueen', 31, 13, 600, 227, 44, 1),
2069(32, 'nidoran-m', 32, 5, 90, 55, 45, 1),
2070(33, 'nidorino', 33, 9, 195, 128, 46, 1),
2071(34, 'nidoking', 34, 14, 620, 227, 47, 1),
2072(35, 'clefairy', 35, 6, 75, 113, 49, 1),
2073(36, 'clefable', 36, 13, 400, 217, 50, 1),
2074(37, 'vulpix', 37, 6, 99, 60, 51, 1),
2075(38, 'ninetales', 38, 11, 199, 177, 52, 1),
2076(39, 'jigglypuff', 39, 5, 55, 95, 54, 1),
2077(40, 'wigglytuff', 40, 10, 120, 196, 55, 1),
2078(41, 'zubat', 41, 8, 75, 49, 56, 1),
2079(42, 'golbat', 42, 16, 550, 159, 57, 1),
2080(43, 'oddish', 43, 5, 54, 64, 59, 1),
2081(44, 'gloom', 44, 8, 86, 138, 60, 1),
2082(45, 'vileplume', 45, 12, 186, 221, 61, 1),
2083(46, 'paras', 46, 3, 54, 57, 63, 1),
2084(47, 'parasect', 47, 10, 295, 142, 64, 1),
2085(48, 'venonat', 48, 10, 300, 61, 65, 1),
2086(49, 'venomoth', 49, 15, 125, 158, 66, 1),
2087(50, 'diglett', 50, 2, 8, 53, 67, 1),
2088(51, 'dugtrio', 51, 7, 333, 142, 68, 1),
2089(52, 'meowth', 52, 4, 42, 58, 69, 1),
2090(53, 'persian', 53, 10, 320, 154, 70, 1),
2091(54, 'psyduck', 54, 8, 196, 64, 71, 1),
2092(55, 'golduck', 55, 17, 766, 175, 72, 1),
2093(56, 'mankey', 56, 5, 280, 61, 73, 1),
2094(57, 'primeape', 57, 10, 320, 159, 74, 1),
2095(58, 'growlithe', 58, 7, 190, 70, 75, 1),
2096(59, 'arcanine', 59, 19, 1550, 194, 76, 1),
2097(60, 'poliwag', 60, 6, 124, 60, 77, 1),
2098(61, 'poliwhirl', 61, 10, 200, 135, 78, 1),
2099(62, 'poliwrath', 62, 13, 540, 230, 79, 1),
2100(63, 'abra', 63, 9, 195, 62, 81, 1),
2101(64, 'kadabra', 64, 13, 565, 140, 82, 1),
2102(65, 'alakazam', 65, 15, 480, 225, 83, 1),
2103(66, 'machop', 66, 8, 195, 61, 85, 1),
2104(67, 'machoke', 67, 15, 705, 142, 86, 1),
2105(68, 'machamp', 68, 16, 1300, 227, 87, 1),
2106(69, 'bellsprout', 69, 7, 40, 60, 88, 1),
2107(70, 'weepinbell', 70, 10, 64, 137, 89, 1),
2108(71, 'victreebel', 71, 17, 155, 221, 90, 1),
2109(72, 'tentacool', 72, 9, 455, 67, 91, 1),
2110(73, 'tentacruel', 73, 16, 550, 180, 92, 1),
2111(74, 'geodude', 74, 4, 200, 60, 93, 1),
2112(75, 'graveler', 75, 10, 1050, 137, 94, 1),
2113(76, 'golem', 76, 14, 3000, 223, 95, 1),
2114(77, 'ponyta', 77, 10, 300, 82, 96, 1),
2115(78, 'rapidash', 78, 17, 950, 175, 97, 1),
2116(79, 'slowpoke', 79, 12, 360, 63, 98, 1),
2117(80, 'slowbro', 80, 16, 785, 172, 99, 1),
2118(81, 'magnemite', 81, 3, 60, 65, 102, 1),
2119(82, 'magneton', 82, 10, 600, 163, 103, 1),
2120(83, 'farfetchd', 83, 8, 150, 123, 105, 1),
2121(84, 'doduo', 84, 14, 392, 62, 106, 1),
2122(85, 'dodrio', 85, 18, 852, 161, 107, 1),
2123(86, 'seel', 86, 11, 900, 65, 108, 1),
2124(87, 'dewgong', 87, 17, 1200, 166, 109, 1),
2125(88, 'grimer', 88, 9, 300, 65, 110, 1),
2126(89, 'muk', 89, 12, 300, 175, 111, 1),
2127(90, 'shellder', 90, 3, 40, 61, 112, 1),
2128(91, 'cloyster', 91, 15, 1325, 184, 113, 1),
2129(92, 'gastly', 92, 13, 1, 62, 114, 1),
2130(93, 'haunter', 93, 16, 1, 142, 115, 1),
2131(94, 'gengar', 94, 15, 405, 225, 116, 1),
2132(95, 'onix', 95, 88, 2100, 77, 118, 1),
2133(96, 'drowzee', 96, 10, 324, 66, 121, 1),
2134(97, 'hypno', 97, 16, 756, 169, 122, 1),
2135(98, 'krabby', 98, 4, 65, 65, 123, 1),
2136(99, 'kingler', 99, 13, 600, 166, 124, 1),
2137(100, 'voltorb', 100, 5, 104, 66, 125, 1),
2138(101, 'electrode', 101, 12, 666, 168, 126, 1),
2139(102, 'exeggcute', 102, 4, 25, 65, 127, 1),
2140(103, 'exeggutor', 103, 20, 1200, 182, 128, 1),
2141(104, 'cubone', 104, 4, 65, 64, 129, 1),
2142(105, 'marowak', 105, 10, 450, 149, 130, 1),
2143(106, 'hitmonlee', 106, 15, 498, 159, 132, 1),
2144(107, 'hitmonchan', 107, 14, 502, 159, 133, 1),
2145(108, 'lickitung', 108, 12, 655, 77, 135, 1),
2146(109, 'koffing', 109, 6, 10, 68, 137, 1),
2147(110, 'weezing', 110, 12, 95, 172, 138, 1),
2148(111, 'rhyhorn', 111, 10, 1150, 69, 139, 1),
2149(112, 'rhydon', 112, 19, 1200, 170, 140, 1),
2150(113, 'chansey', 113, 11, 346, 395, 143, 1),
2151(114, 'tangela', 114, 10, 350, 87, 145, 1),
2152(115, 'kangaskhan', 115, 22, 800, 172, 147, 1),
2153(116, 'horsea', 116, 4, 80, 59, 149, 1),
2154(117, 'seadra', 117, 12, 250, 154, 150, 1),
2155(118, 'goldeen', 118, 6, 150, 64, 152, 1),
2156(119, 'seaking', 119, 13, 390, 158, 153, 1),
2157(120, 'staryu', 120, 8, 345, 68, 154, 1),
2158(121, 'starmie', 121, 11, 800, 182, 155, 1),
2159(122, 'mr-mime', 122, 13, 545, 161, 157, 1),
2160(123, 'scyther', 123, 15, 560, 100, 158, 1),
2161(124, 'jynx', 124, 14, 406, 159, 162, 1),
2162(125, 'electabuzz', 125, 11, 300, 172, 164, 1),
2163(126, 'magmar', 126, 13, 445, 173, 167, 1),
2164(127, 'pinsir', 127, 15, 550, 175, 169, 1),
2165(128, 'tauros', 128, 14, 884, 172, 171, 1),
2166(129, 'magikarp', 129, 9, 100, 40, 172, 1),
2167(130, 'gyarados', 130, 65, 2350, 189, 173, 1),
2168(131, 'lapras', 131, 25, 2200, 187, 175, 1),
2169(132, 'ditto', 132, 3, 40, 101, 176, 1),
2170(133, 'eevee', 133, 3, 65, 65, 177, 1),
2171(134, 'vaporeon', 134, 10, 290, 184, 178, 1),
2172(135, 'jolteon', 135, 8, 245, 184, 179, 1),
2173(136, 'flareon', 136, 9, 250, 184, 180, 1),
2174(137, 'porygon', 137, 8, 365, 79, 186, 1),
2175(138, 'omanyte', 138, 4, 75, 71, 189, 1),
2176(139, 'omastar', 139, 10, 350, 173, 190, 1),
2177(140, 'kabuto', 140, 5, 115, 71, 191, 1),
2178(141, 'kabutops', 141, 13, 405, 173, 192, 1),
2179(142, 'aerodactyl', 142, 18, 590, 180, 193, 1),
2180(143, 'snorlax', 143, 21, 4600, 189, 196, 1),
2181(144, 'articuno', 144, 17, 554, 261, 197, 1),
2182(145, 'zapdos', 145, 16, 526, 261, 198, 1),
2183(146, 'moltres', 146, 20, 600, 261, 199, 1),
2184(147, 'dratini', 147, 18, 33, 60, 200, 1),
2185(148, 'dragonair', 148, 40, 165, 147, 201, 1),
2186(149, 'dragonite', 149, 22, 2100, 270, 202, 1),
2187(150, 'mewtwo', 150, 20, 1220, 306, 203, 1),
2188(151, 'mew', 151, 4, 40, 270, 206, 1),
2189(152, 'chikorita', 152, 9, 64, 64, 207, 1),
2190(153, 'bayleef', 153, 12, 158, 142, 208, 1),
2191(154, 'meganium', 154, 18, 1005, 236, 209, 1),
2192(155, 'cyndaquil', 155, 5, 79, 62, 210, 1),
2193(156, 'quilava', 156, 9, 190, 142, 211, 1),
2194(157, 'typhlosion', 157, 17, 795, 240, 212, 1),
2195(158, 'totodile', 158, 6, 95, 63, 213, 1),
2196(159, 'croconaw', 159, 11, 250, 142, 214, 1),
2197(160, 'feraligatr', 160, 23, 888, 239, 215, 1),
2198(161, 'sentret', 161, 8, 60, 43, 216, 1),
2199(162, 'furret', 162, 18, 325, 145, 217, 1),
2200(163, 'hoothoot', 163, 7, 212, 52, 218, 1),
2201(164, 'noctowl', 164, 16, 408, 155, 219, 1),
2202(165, 'ledyba', 165, 10, 108, 53, 220, 1),
2203(166, 'ledian', 166, 14, 356, 137, 221, 1),
2204(167, 'spinarak', 167, 5, 85, 50, 222, 1),
2205(168, 'ariados', 168, 11, 335, 137, 223, 1),
2206(169, 'crobat', 169, 18, 750, 241, 58, 1),
2207(170, 'chinchou', 170, 5, 120, 66, 224, 1),
2208(171, 'lanturn', 171, 12, 225, 161, 225, 1),
2209(172, 'pichu', 172, 3, 20, 41, 31, 1),
2210(173, 'cleffa', 173, 3, 30, 44, 48, 1),
2211(174, 'igglybuff', 174, 3, 10, 42, 53, 1),
2212(175, 'togepi', 175, 3, 15, 49, 226, 1),
2213(176, 'togetic', 176, 6, 32, 142, 227, 1),
2214(177, 'natu', 177, 2, 20, 64, 229, 1),
2215(178, 'xatu', 178, 15, 150, 165, 230, 1),
2216(179, 'mareep', 179, 6, 78, 56, 231, 1),
2217(180, 'flaaffy', 180, 8, 133, 128, 232, 1),
2218(181, 'ampharos', 181, 14, 615, 230, 233, 1),
2219(182, 'bellossom', 182, 4, 58, 221, 62, 1),
2220(183, 'marill', 183, 4, 85, 88, 236, 1),
2221(184, 'azumarill', 184, 8, 285, 189, 237, 1),
2222(185, 'sudowoodo', 185, 12, 380, 144, 239, 1),
2223(186, 'politoed', 186, 11, 339, 225, 80, 1),
2224(187, 'hoppip', 187, 4, 5, 50, 240, 1),
2225(188, 'skiploom', 188, 6, 10, 119, 241, 1),
2226(189, 'jumpluff', 189, 8, 30, 207, 242, 1),
2227(190, 'aipom', 190, 8, 115, 72, 243, 1),
2228(191, 'sunkern', 191, 3, 18, 36, 245, 1),
2229(192, 'sunflora', 192, 8, 85, 149, 246, 1),
2230(193, 'yanma', 193, 12, 380, 78, 247, 1),
2231(194, 'wooper', 194, 4, 85, 42, 249, 1),
2232(195, 'quagsire', 195, 14, 750, 151, 250, 1),
2233(196, 'espeon', 196, 9, 265, 184, 181, 1),
2234(197, 'umbreon', 197, 10, 270, 184, 182, 1),
2235(198, 'murkrow', 198, 5, 21, 81, 251, 1),
2236(199, 'slowking', 199, 20, 795, 172, 101, 1),
2237(200, 'misdreavus', 200, 7, 10, 87, 253, 1),
2238(201, 'unown', 201, 5, 50, 118, 255, 1),
2239(202, 'wobbuffet', 202, 13, 285, 142, 257, 1),
2240(203, 'girafarig', 203, 15, 415, 159, 258, 1),
2241(204, 'pineco', 204, 6, 72, 58, 259, 1),
2242(205, 'forretress', 205, 12, 1258, 163, 260, 1),
2243(206, 'dunsparce', 206, 15, 140, 145, 261, 1),
2244(207, 'gligar', 207, 11, 648, 86, 262, 1),
2245(208, 'steelix', 208, 92, 4000, 179, 119, 1),
2246(209, 'snubbull', 209, 6, 78, 60, 264, 1),
2247(210, 'granbull', 210, 14, 487, 158, 265, 1),
2248(211, 'qwilfish', 211, 5, 39, 86, 266, 1),
2249(212, 'scizor', 212, 18, 1180, 175, 159, 1),
2250(213, 'shuckle', 213, 6, 205, 177, 267, 1),
2251(214, 'heracross', 214, 15, 540, 175, 268, 1),
2252(215, 'sneasel', 215, 9, 280, 86, 270, 1),
2253(216, 'teddiursa', 216, 6, 88, 66, 272, 1),
2254(217, 'ursaring', 217, 18, 1258, 175, 273, 1),
2255(218, 'slugma', 218, 7, 350, 50, 274, 1),
2256(219, 'magcargo', 219, 8, 550, 144, 275, 1),
2257(220, 'swinub', 220, 4, 65, 50, 276, 1),
2258(221, 'piloswine', 221, 11, 558, 158, 277, 1),
2259(222, 'corsola', 222, 6, 50, 133, 279, 1),
2260(223, 'remoraid', 223, 6, 120, 60, 280, 1),
2261(224, 'octillery', 224, 9, 285, 168, 281, 1),
2262(225, 'delibird', 225, 9, 160, 116, 282, 1),
2263(226, 'mantine', 226, 21, 2200, 163, 284, 1),
2264(227, 'skarmory', 227, 17, 505, 163, 285, 1),
2265(228, 'houndour', 228, 6, 108, 66, 286, 1),
2266(229, 'houndoom', 229, 14, 350, 175, 287, 1),
2267(230, 'kingdra', 230, 18, 1520, 243, 151, 1),
2268(231, 'phanpy', 231, 5, 335, 66, 289, 1),
2269(232, 'donphan', 232, 11, 1200, 175, 290, 1),
2270(233, 'porygon2', 233, 6, 325, 180, 187, 1),
2271(234, 'stantler', 234, 14, 712, 163, 291, 1),
2272(235, 'smeargle', 235, 12, 580, 88, 292, 1),
2273(236, 'tyrogue', 236, 7, 210, 42, 131, 1),
2274(237, 'hitmontop', 237, 14, 480, 159, 134, 1),
2275(238, 'smoochum', 238, 4, 60, 61, 161, 1),
2276(239, 'elekid', 239, 6, 235, 72, 163, 1),
2277(240, 'magby', 240, 7, 214, 73, 166, 1),
2278(241, 'miltank', 241, 12, 755, 172, 293, 1),
2279(242, 'blissey', 242, 15, 468, 608, 144, 1),
2280(243, 'raikou', 243, 19, 1780, 261, 294, 1),
2281(244, 'entei', 244, 21, 1980, 261, 295, 1),
2282(245, 'suicune', 245, 20, 1870, 261, 296, 1),
2283(246, 'larvitar', 246, 6, 720, 60, 297, 1),
2284(247, 'pupitar', 247, 12, 1520, 144, 298, 1),
2285(248, 'tyranitar', 248, 20, 2020, 270, 299, 1),
2286(249, 'lugia', 249, 52, 2160, 306, 301, 1),
2287(250, 'ho-oh', 250, 38, 1990, 306, 302, 1),
2288(251, 'celebi', 251, 6, 50, 270, 303, 1),
2289(252, 'treecko', 252, 5, 50, 62, 304, 1),
2290(253, 'grovyle', 253, 9, 216, 142, 305, 1),
2291(254, 'sceptile', 254, 17, 522, 239, 306, 1),
2292(255, 'torchic', 255, 4, 25, 62, 308, 1),
2293(256, 'combusken', 256, 9, 195, 142, 309, 1),
2294(257, 'blaziken', 257, 19, 520, 239, 310, 1),
2295(258, 'mudkip', 258, 4, 76, 62, 312, 1),
2296(259, 'marshtomp', 259, 7, 280, 142, 313, 1),
2297(260, 'swampert', 260, 15, 819, 241, 314, 1),
2298(261, 'poochyena', 261, 5, 136, 44, 316, 1),
2299(262, 'mightyena', 262, 10, 370, 147, 317, 1),
2300(263, 'zigzagoon', 263, 4, 175, 48, 318, 1),
2301(264, 'linoone', 264, 5, 325, 147, 319, 1),
2302(265, 'wurmple', 265, 3, 36, 39, 320, 1),
2303(266, 'silcoon', 266, 6, 100, 72, 321, 1),
2304(267, 'beautifly', 267, 10, 284, 178, 322, 1),
2305(268, 'cascoon', 268, 7, 115, 41, 323, 1),
2306(269, 'dustox', 269, 12, 316, 135, 324, 1),
2307(270, 'lotad', 270, 5, 26, 44, 325, 1),
2308(271, 'lombre', 271, 12, 325, 119, 326, 1),
2309(272, 'ludicolo', 272, 15, 550, 216, 327, 1),
2310(273, 'seedot', 273, 5, 40, 44, 328, 1),
2311(274, 'nuzleaf', 274, 10, 280, 119, 329, 1),
2312(275, 'shiftry', 275, 13, 596, 216, 330, 1),
2313(276, 'taillow', 276, 3, 23, 54, 331, 1),
2314(277, 'swellow', 277, 7, 198, 151, 332, 1),
2315(278, 'wingull', 278, 6, 95, 54, 333, 1),
2316(279, 'pelipper', 279, 12, 280, 151, 334, 1),
2317(280, 'ralts', 280, 4, 66, 40, 335, 1),
2318(281, 'kirlia', 281, 8, 202, 97, 336, 1),
2319(282, 'gardevoir', 282, 16, 484, 233, 337, 1),
2320(283, 'surskit', 283, 5, 17, 54, 341, 1),
2321(284, 'masquerain', 284, 8, 36, 145, 342, 1),
2322(285, 'shroomish', 285, 4, 45, 59, 343, 1),
2323(286, 'breloom', 286, 12, 392, 161, 344, 1),
2324(287, 'slakoth', 287, 8, 240, 56, 345, 1),
2325(288, 'vigoroth', 288, 14, 465, 154, 346, 1),
2326(289, 'slaking', 289, 20, 1305, 252, 347, 1),
2327(290, 'nincada', 290, 5, 55, 53, 348, 1),
2328(291, 'ninjask', 291, 8, 120, 160, 349, 1),
2329(292, 'shedinja', 292, 8, 12, 83, 350, 1),
2330(293, 'whismur', 293, 6, 163, 48, 351, 1),
2331(294, 'loudred', 294, 10, 405, 126, 352, 1),
2332(295, 'exploud', 295, 15, 840, 221, 353, 1),
2333(296, 'makuhita', 296, 10, 864, 47, 354, 1),
2334(297, 'hariyama', 297, 23, 2538, 166, 355, 1),
2335(298, 'azurill', 298, 2, 20, 38, 235, 1),
2336(299, 'nosepass', 299, 10, 970, 75, 356, 1),
2337(300, 'skitty', 300, 6, 110, 52, 358, 1),
2338(301, 'delcatty', 301, 11, 326, 133, 359, 1),
2339(302, 'sableye', 302, 5, 110, 133, 360, 1),
2340(303, 'mawile', 303, 6, 115, 133, 362, 1),
2341(304, 'aron', 304, 4, 600, 66, 364, 1),
2342(305, 'lairon', 305, 9, 1200, 151, 365, 1),
2343(306, 'aggron', 306, 21, 3600, 239, 366, 1),
2344(307, 'meditite', 307, 6, 112, 56, 368, 1),
2345(308, 'medicham', 308, 13, 315, 144, 369, 1),
2346(309, 'electrike', 309, 6, 152, 59, 371, 1),
2347(310, 'manectric', 310, 15, 402, 166, 372, 1),
2348(311, 'plusle', 311, 4, 42, 142, 374, 1),
2349(312, 'minun', 312, 4, 42, 142, 375, 1),
2350(313, 'volbeat', 313, 7, 177, 140, 376, 1),
2351(314, 'illumise', 314, 6, 177, 140, 377, 1),
2352(315, 'roselia', 315, 3, 20, 140, 379, 1),
2353(316, 'gulpin', 316, 4, 103, 60, 381, 1),
2354(317, 'swalot', 317, 17, 800, 163, 382, 1),
2355(318, 'carvanha', 318, 8, 208, 61, 383, 1),
2356(319, 'sharpedo', 319, 18, 888, 161, 384, 1),
2357(320, 'wailmer', 320, 20, 1300, 80, 386, 1),
2358(321, 'wailord', 321, 145, 3980, 175, 387, 1),
2359(322, 'numel', 322, 7, 240, 61, 388, 1),
2360(323, 'camerupt', 323, 19, 2200, 161, 389, 1),
2361(324, 'torkoal', 324, 5, 804, 165, 391, 1),
2362(325, 'spoink', 325, 7, 306, 66, 392, 1),
2363(326, 'grumpig', 326, 9, 715, 165, 393, 1),
2364(327, 'spinda', 327, 11, 50, 126, 394, 1),
2365(328, 'trapinch', 328, 7, 150, 58, 395, 1),
2366(329, 'vibrava', 329, 11, 153, 119, 396, 1),
2367(330, 'flygon', 330, 20, 820, 234, 397, 1),
2368(331, 'cacnea', 331, 4, 513, 67, 398, 1),
2369(332, 'cacturne', 332, 13, 774, 166, 399, 1),
2370(333, 'swablu', 333, 4, 12, 62, 400, 1),
2371(334, 'altaria', 334, 11, 206, 172, 401, 1),
2372(335, 'zangoose', 335, 13, 403, 160, 403, 1),
2373(336, 'seviper', 336, 27, 525, 160, 404, 1),
2374(337, 'lunatone', 337, 10, 1680, 154, 405, 1),
2375(338, 'solrock', 338, 12, 1540, 154, 406, 1),
2376(339, 'barboach', 339, 4, 19, 58, 407, 1),
2377(340, 'whiscash', 340, 9, 236, 164, 408, 1),
2378(341, 'corphish', 341, 6, 115, 62, 409, 1),
2379(342, 'crawdaunt', 342, 11, 328, 164, 410, 1),
2380(343, 'baltoy', 343, 5, 215, 60, 411, 1),
2381(344, 'claydol', 344, 15, 1080, 175, 412, 1),
2382(345, 'lileep', 345, 10, 238, 71, 413, 1),
2383(346, 'cradily', 346, 15, 604, 173, 414, 1),
2384(347, 'anorith', 347, 7, 125, 71, 415, 1),
2385(348, 'armaldo', 348, 15, 682, 173, 416, 1),
2386(349, 'feebas', 349, 6, 74, 40, 417, 1),
2387(350, 'milotic', 350, 62, 1620, 189, 418, 1),
2388(351, 'castform', 351, 3, 8, 147, 419, 1),
2389(352, 'kecleon', 352, 10, 220, 154, 423, 1),
2390(353, 'shuppet', 353, 6, 23, 59, 424, 1),
2391(354, 'banette', 354, 11, 125, 159, 425, 1),
2392(355, 'duskull', 355, 8, 150, 59, 427, 1),
2393(356, 'dusclops', 356, 16, 306, 159, 428, 1),
2394(357, 'tropius', 357, 20, 1000, 161, 430, 1),
2395(358, 'chimecho', 358, 6, 10, 149, 432, 1),
2396(359, 'absol', 359, 12, 470, 163, 433, 1),
2397(360, 'wynaut', 360, 6, 140, 52, 256, 1),
2398(361, 'snorunt', 361, 7, 168, 60, 435, 1),
2399(362, 'glalie', 362, 15, 2565, 168, 436, 1),
2400(363, 'spheal', 363, 8, 395, 58, 439, 1),
2401(364, 'sealeo', 364, 11, 876, 144, 440, 1),
2402(365, 'walrein', 365, 14, 1506, 239, 441, 1),
2403(366, 'clamperl', 366, 4, 525, 69, 442, 1),
2404(367, 'huntail', 367, 17, 270, 170, 443, 1),
2405(368, 'gorebyss', 368, 18, 226, 170, 444, 1),
2406(369, 'relicanth', 369, 10, 234, 170, 445, 1),
2407(370, 'luvdisc', 370, 6, 87, 116, 446, 1),
2408(371, 'bagon', 371, 6, 421, 60, 447, 1),
2409(372, 'shelgon', 372, 11, 1105, 147, 448, 1),
2410(373, 'salamence', 373, 15, 1026, 270, 449, 1),
2411(374, 'beldum', 374, 6, 952, 60, 451, 1),
2412(375, 'metang', 375, 12, 2025, 147, 452, 1),
2413(376, 'metagross', 376, 16, 5500, 270, 453, 1),
2414(377, 'regirock', 377, 17, 2300, 261, 455, 1),
2415(378, 'regice', 378, 18, 1750, 261, 456, 1),
2416(379, 'registeel', 379, 19, 2050, 261, 457, 1),
2417(380, 'latias', 380, 14, 400, 270, 458, 1),
2418(381, 'latios', 381, 20, 600, 270, 460, 1),
2419(382, 'kyogre', 382, 45, 3520, 302, 462, 1),
2420(383, 'groudon', 383, 35, 9500, 302, 464, 1),
2421(384, 'rayquaza', 384, 70, 2065, 306, 466, 1),
2422(385, 'jirachi', 385, 3, 11, 270, 468, 1),
2423(386, 'deoxys-normal', 386, 17, 608, 270, 469, 1),
2424(387, 'turtwig', 387, 4, 102, 64, 473, 1),
2425(388, 'grotle', 388, 11, 970, 142, 474, 1),
2426(389, 'torterra', 389, 22, 3100, 236, 475, 1),
2427(390, 'chimchar', 390, 5, 62, 62, 476, 1),
2428(391, 'monferno', 391, 9, 220, 142, 477, 1),
2429(392, 'infernape', 392, 12, 550, 240, 478, 1),
2430(393, 'piplup', 393, 4, 52, 63, 479, 1),
2431(394, 'prinplup', 394, 8, 230, 142, 480, 1),
2432(395, 'empoleon', 395, 17, 845, 239, 481, 1),
2433(396, 'starly', 396, 3, 20, 49, 482, 1),
2434(397, 'staravia', 397, 6, 155, 119, 483, 1),
2435(398, 'staraptor', 398, 12, 249, 218, 484, 1),
2436(399, 'bidoof', 399, 5, 200, 50, 485, 1),
2437(400, 'bibarel', 400, 10, 315, 144, 486, 1),
2438(401, 'kricketot', 401, 3, 22, 39, 487, 1),
2439(402, 'kricketune', 402, 10, 255, 134, 488, 1),
2440(403, 'shinx', 403, 5, 95, 53, 489, 1),
2441(404, 'luxio', 404, 9, 305, 127, 490, 1),
2442(405, 'luxray', 405, 14, 420, 235, 491, 1),
2443(406, 'budew', 406, 2, 12, 56, 378, 1),
2444(407, 'roserade', 407, 9, 145, 232, 380, 1),
2445(408, 'cranidos', 408, 9, 315, 70, 492, 1),
2446(409, 'rampardos', 409, 16, 1025, 173, 493, 1),
2447(410, 'shieldon', 410, 5, 570, 70, 494, 1),
2448(411, 'bastiodon', 411, 13, 1495, 173, 495, 1),
2449(412, 'burmy', 412, 2, 34, 45, 496, 1),
2450(413, 'wormadam-plant', 413, 5, 65, 148, 497, 1),
2451(414, 'mothim', 414, 9, 233, 148, 500, 1),
2452(415, 'combee', 415, 3, 55, 49, 501, 1),
2453(416, 'vespiquen', 416, 12, 385, 166, 502, 1),
2454(417, 'pachirisu', 417, 4, 39, 142, 503, 1),
2455(418, 'buizel', 418, 7, 295, 66, 504, 1),
2456(419, 'floatzel', 419, 11, 335, 173, 505, 1),
2457(420, 'cherubi', 420, 4, 33, 55, 506, 1),
2458(421, 'cherrim', 421, 5, 93, 158, 507, 1),
2459(422, 'shellos', 422, 3, 63, 65, 508, 1),
2460(423, 'gastrodon', 423, 9, 299, 166, 509, 1),
2461(424, 'ambipom', 424, 12, 203, 169, 244, 1),
2462(425, 'drifloon', 425, 4, 12, 70, 510, 1),
2463(426, 'drifblim', 426, 12, 150, 174, 511, 1),
2464(427, 'buneary', 427, 4, 55, 70, 512, 1),
2465(428, 'lopunny', 428, 12, 333, 168, 513, 1),
2466(429, 'mismagius', 429, 9, 44, 173, 254, 1),
2467(430, 'honchkrow', 430, 9, 273, 177, 252, 1),
2468(431, 'glameow', 431, 5, 39, 62, 515, 1),
2469(432, 'purugly', 432, 10, 438, 158, 516, 1),
2470(433, 'chingling', 433, 2, 6, 57, 431, 1),
2471(434, 'stunky', 434, 4, 192, 66, 517, 1),
2472(435, 'skuntank', 435, 10, 380, 168, 518, 1),
2473(436, 'bronzor', 436, 5, 605, 60, 519, 1),
2474(437, 'bronzong', 437, 13, 1870, 175, 520, 1),
2475(438, 'bonsly', 438, 5, 150, 58, 238, 1),
2476(439, 'mime-jr', 439, 6, 130, 62, 156, 1),
2477(440, 'happiny', 440, 6, 244, 110, 142, 1),
2478(441, 'chatot', 441, 5, 19, 144, 521, 1),
2479(442, 'spiritomb', 442, 10, 1080, 170, 522, 1),
2480(443, 'gible', 443, 7, 205, 60, 523, 1),
2481(444, 'gabite', 444, 14, 560, 144, 524, 1),
2482(445, 'garchomp', 445, 19, 950, 270, 525, 1),
2483(446, 'munchlax', 446, 6, 1050, 78, 195, 1),
2484(447, 'riolu', 447, 7, 202, 57, 527, 1),
2485(448, 'lucario', 448, 12, 540, 184, 528, 1),
2486(449, 'hippopotas', 449, 8, 495, 66, 530, 1),
2487(450, 'hippowdon', 450, 20, 3000, 184, 531, 1),
2488(451, 'skorupi', 451, 8, 120, 66, 532, 1),
2489(452, 'drapion', 452, 13, 615, 175, 533, 1),
2490(453, 'croagunk', 453, 7, 230, 60, 534, 1),
2491(454, 'toxicroak', 454, 13, 444, 172, 535, 1),
2492(455, 'carnivine', 455, 14, 270, 159, 536, 1),
2493(456, 'finneon', 456, 4, 70, 66, 537, 1),
2494(457, 'lumineon', 457, 12, 240, 161, 538, 1),
2495(458, 'mantyke', 458, 10, 650, 69, 283, 1),
2496(459, 'snover', 459, 10, 505, 67, 539, 1),
2497(460, 'abomasnow', 460, 22, 1355, 173, 540, 1),
2498(461, 'weavile', 461, 11, 340, 179, 271, 1),
2499(462, 'magnezone', 462, 12, 1800, 241, 104, 1),
2500(463, 'lickilicky', 463, 17, 1400, 180, 136, 1),
2501(464, 'rhyperior', 464, 24, 2828, 241, 141, 1),
2502(465, 'tangrowth', 465, 20, 1286, 187, 146, 1),
2503(466, 'electivire', 466, 18, 1386, 243, 165, 1),
2504(467, 'magmortar', 467, 16, 680, 243, 168, 1),
2505(468, 'togekiss', 468, 15, 380, 245, 228, 1),
2506(469, 'yanmega', 469, 19, 515, 180, 248, 1),
2507(470, 'leafeon', 470, 10, 255, 184, 183, 1),
2508(471, 'glaceon', 471, 8, 259, 184, 184, 1),
2509(472, 'gliscor', 472, 20, 425, 179, 263, 1),
2510(473, 'mamoswine', 473, 25, 2910, 239, 278, 1),
2511(474, 'porygon-z', 474, 9, 340, 241, 188, 1),
2512(475, 'gallade', 475, 16, 520, 233, 339, 1),
2513(476, 'probopass', 476, 14, 3400, 184, 357, 1),
2514(477, 'dusknoir', 477, 22, 1066, 236, 429, 1),
2515(478, 'froslass', 478, 13, 266, 168, 438, 1),
2516(479, 'rotom', 479, 3, 3, 154, 542, 1),
2517(480, 'uxie', 480, 3, 3, 261, 548, 1),
2518(481, 'mesprit', 481, 3, 3, 261, 549, 1),
2519(482, 'azelf', 482, 3, 3, 261, 550, 1),
2520(483, 'dialga', 483, 54, 6830, 306, 551, 1),
2521(484, 'palkia', 484, 42, 3360, 306, 552, 1),
2522(485, 'heatran', 485, 17, 4300, 270, 553, 1),
2523(486, 'regigigas', 486, 37, 4200, 302, 554, 1),
2524(487, 'giratina-altered', 487, 45, 7500, 306, 555, 1),
2525(488, 'cresselia', 488, 15, 856, 270, 557, 1),
2526(489, 'phione', 489, 4, 31, 216, 558, 1),
2527(490, 'manaphy', 490, 3, 14, 270, 559, 1),
2528(491, 'darkrai', 491, 15, 505, 270, 560, 1),
2529(492, 'shaymin-land', 492, 2, 21, 270, 561, 1),
2530(493, 'arceus', 493, 32, 3200, 324, 563, 1),
2531(494, 'victini', 494, 4, 40, 270, 564, 1),
2532(495, 'snivy', 495, 6, 81, 62, 565, 1),
2533(496, 'servine', 496, 8, 160, 145, 566, 1),
2534(497, 'serperior', 497, 33, 630, 238, 567, 1),
2535(498, 'tepig', 498, 5, 99, 62, 568, 1),
2536(499, 'pignite', 499, 10, 555, 146, 569, 1),
2537(500, 'emboar', 500, 16, 1500, 238, 570, 1),
2538(501, 'oshawott', 501, 5, 59, 62, 571, 1),
2539(502, 'dewott', 502, 8, 245, 145, 572, 1),
2540(503, 'samurott', 503, 15, 946, 238, 573, 1),
2541(504, 'patrat', 504, 5, 116, 51, 574, 1),
2542(505, 'watchog', 505, 11, 270, 147, 575, 1),
2543(506, 'lillipup', 506, 4, 41, 55, 576, 1),
2544(507, 'herdier', 507, 9, 147, 130, 577, 1),
2545(508, 'stoutland', 508, 12, 610, 225, 578, 1),
2546(509, 'purrloin', 509, 4, 101, 56, 579, 1),
2547(510, 'liepard', 510, 11, 375, 156, 580, 1),
2548(511, 'pansage', 511, 6, 105, 63, 581, 1),
2549(512, 'simisage', 512, 11, 305, 174, 582, 1),
2550(513, 'pansear', 513, 6, 110, 63, 583, 1),
2551(514, 'simisear', 514, 10, 280, 174, 584, 1),
2552(515, 'panpour', 515, 6, 135, 63, 585, 1),
2553(516, 'simipour', 516, 10, 290, 174, 586, 1),
2554(517, 'munna', 517, 6, 233, 58, 587, 1),
2555(518, 'musharna', 518, 11, 605, 170, 588, 1),
2556(519, 'pidove', 519, 3, 21, 53, 589, 1),
2557(520, 'tranquill', 520, 6, 150, 125, 590, 1),
2558(521, 'unfezant', 521, 12, 290, 220, 591, 1),
2559(522, 'blitzle', 522, 8, 298, 59, 592, 1),
2560(523, 'zebstrika', 523, 16, 795, 174, 593, 1),
2561(524, 'roggenrola', 524, 4, 180, 56, 594, 1),
2562(525, 'boldore', 525, 9, 1020, 137, 595, 1),
2563(526, 'gigalith', 526, 17, 2600, 232, 596, 1),
2564(527, 'woobat', 527, 4, 21, 63, 597, 1),
2565(528, 'swoobat', 528, 9, 105, 149, 598, 1),
2566(529, 'drilbur', 529, 3, 85, 66, 599, 1),
2567(530, 'excadrill', 530, 7, 404, 178, 600, 1),
2568(531, 'audino', 531, 11, 310, 390, 601, 1),
2569(532, 'timburr', 532, 6, 125, 61, 603, 1),
2570(533, 'gurdurr', 533, 12, 400, 142, 604, 1),
2571(534, 'conkeldurr', 534, 14, 870, 227, 605, 1),
2572(535, 'tympole', 535, 5, 45, 59, 606, 1),
2573(536, 'palpitoad', 536, 8, 170, 134, 607, 1),
2574(537, 'seismitoad', 537, 15, 620, 229, 608, 1),
2575(538, 'throh', 538, 13, 555, 163, 609, 1),
2576(539, 'sawk', 539, 14, 510, 163, 610, 1),
2577(540, 'sewaddle', 540, 3, 25, 62, 611, 1),
2578(541, 'swadloon', 541, 5, 73, 133, 612, 1),
2579(542, 'leavanny', 542, 12, 205, 225, 613, 1),
2580(543, 'venipede', 543, 4, 53, 52, 614, 1),
2581(544, 'whirlipede', 544, 12, 585, 126, 615, 1),
2582(545, 'scolipede', 545, 25, 2005, 218, 616, 1),
2583(546, 'cottonee', 546, 3, 6, 56, 617, 1),
2584(547, 'whimsicott', 547, 7, 66, 168, 618, 1),
2585(548, 'petilil', 548, 5, 66, 56, 619, 1),
2586(549, 'lilligant', 549, 11, 163, 168, 620, 1),
2587(550, 'basculin-red-striped', 550, 10, 180, 161, 621, 1),
2588(551, 'sandile', 551, 7, 152, 58, 623, 1),
2589(552, 'krokorok', 552, 10, 334, 123, 624, 1),
2590(553, 'krookodile', 553, 15, 963, 234, 625, 1),
2591(554, 'darumaka', 554, 6, 375, 63, 626, 1),
2592(555, 'darmanitan-standard', 555, 13, 929, 168, 627, 1),
2593(556, 'maractus', 556, 10, 280, 161, 629, 1),
2594(557, 'dwebble', 557, 3, 145, 65, 630, 1),
2595(558, 'crustle', 558, 14, 2000, 166, 631, 1),
2596(559, 'scraggy', 559, 6, 118, 70, 632, 1),
2597(560, 'scrafty', 560, 11, 300, 171, 633, 1),
2598(561, 'sigilyph', 561, 14, 140, 172, 634, 1),
2599(562, 'yamask', 562, 5, 15, 61, 635, 1),
2600(563, 'cofagrigus', 563, 17, 765, 169, 636, 1),
2601(564, 'tirtouga', 564, 7, 165, 71, 637, 1),
2602(565, 'carracosta', 565, 12, 810, 173, 638, 1),
2603(566, 'archen', 566, 5, 95, 71, 639, 1),
2604(567, 'archeops', 567, 14, 320, 177, 640, 1),
2605(568, 'trubbish', 568, 6, 310, 66, 641, 1),
2606(569, 'garbodor', 569, 19, 1073, 166, 642, 1),
2607(570, 'zorua', 570, 7, 125, 66, 643, 1),
2608(571, 'zoroark', 571, 16, 811, 179, 644, 1),
2609(572, 'minccino', 572, 4, 58, 60, 645, 1),
2610(573, 'cinccino', 573, 5, 75, 165, 646, 1),
2611(574, 'gothita', 574, 4, 58, 58, 647, 1),
2612(575, 'gothorita', 575, 7, 180, 137, 648, 1),
2613(576, 'gothitelle', 576, 15, 440, 221, 649, 1),
2614(577, 'solosis', 577, 3, 10, 58, 650, 1),
2615(578, 'duosion', 578, 6, 80, 130, 651, 1),
2616(579, 'reuniclus', 579, 10, 201, 221, 652, 1),
2617(580, 'ducklett', 580, 5, 55, 61, 653, 1),
2618(581, 'swanna', 581, 13, 242, 166, 654, 1),
2619(582, 'vanillite', 582, 4, 57, 61, 655, 1),
2620(583, 'vanillish', 583, 11, 410, 138, 656, 1),
2621(584, 'vanilluxe', 584, 13, 575, 241, 657, 1),
2622(585, 'deerling', 585, 6, 195, 67, 658, 1),
2623(586, 'sawsbuck', 586, 19, 925, 166, 659, 1),
2624(587, 'emolga', 587, 4, 50, 150, 660, 1),
2625(588, 'karrablast', 588, 5, 59, 63, 661, 1),
2626(589, 'escavalier', 589, 10, 330, 173, 662, 1),
2627(590, 'foongus', 590, 2, 10, 59, 663, 1),
2628(591, 'amoonguss', 591, 6, 105, 162, 664, 1),
2629(592, 'frillish', 592, 12, 330, 67, 665, 1),
2630(593, 'jellicent', 593, 22, 1350, 168, 666, 1),
2631(594, 'alomomola', 594, 12, 316, 165, 667, 1),
2632(595, 'joltik', 595, 1, 6, 64, 668, 1),
2633(596, 'galvantula', 596, 8, 143, 165, 669, 1),
2634(597, 'ferroseed', 597, 6, 188, 61, 670, 1),
2635(598, 'ferrothorn', 598, 10, 1100, 171, 671, 1),
2636(599, 'klink', 599, 3, 210, 60, 672, 1),
2637(600, 'klang', 600, 6, 510, 154, 673, 1),
2638(601, 'klinklang', 601, 6, 810, 234, 674, 1),
2639(602, 'tynamo', 602, 2, 3, 55, 675, 1),
2640(603, 'eelektrik', 603, 12, 220, 142, 676, 1),
2641(604, 'eelektross', 604, 21, 805, 232, 677, 1),
2642(605, 'elgyem', 605, 5, 90, 67, 678, 1),
2643(606, 'beheeyem', 606, 10, 345, 170, 679, 1),
2644(607, 'litwick', 607, 3, 31, 55, 680, 1),
2645(608, 'lampent', 608, 6, 130, 130, 681, 1),
2646(609, 'chandelure', 609, 10, 343, 234, 682, 1),
2647(610, 'axew', 610, 6, 180, 64, 683, 1),
2648(611, 'fraxure', 611, 10, 360, 144, 684, 1),
2649(612, 'haxorus', 612, 18, 1055, 243, 685, 1),
2650(613, 'cubchoo', 613, 5, 85, 61, 686, 1),
2651(614, 'beartic', 614, 26, 2600, 170, 687, 1),
2652(615, 'cryogonal', 615, 11, 1480, 170, 688, 1),
2653(616, 'shelmet', 616, 4, 77, 61, 689, 1),
2654(617, 'accelgor', 617, 8, 253, 173, 690, 1),
2655(618, 'stunfisk', 618, 7, 110, 165, 691, 1),
2656(619, 'mienfoo', 619, 9, 200, 70, 692, 1),
2657(620, 'mienshao', 620, 14, 355, 179, 693, 1),
2658(621, 'druddigon', 621, 16, 1390, 170, 694, 1),
2659(622, 'golett', 622, 10, 920, 61, 695, 1),
2660(623, 'golurk', 623, 28, 3300, 169, 696, 1),
2661(624, 'pawniard', 624, 5, 102, 68, 697, 1),
2662(625, 'bisharp', 625, 16, 700, 172, 698, 1),
2663(626, 'bouffalant', 626, 16, 946, 172, 699, 1),
2664(627, 'rufflet', 627, 5, 105, 70, 700, 1),
2665(628, 'braviary', 628, 15, 410, 179, 701, 1),
2666(629, 'vullaby', 629, 5, 90, 74, 702, 1),
2667(630, 'mandibuzz', 630, 12, 395, 179, 703, 1),
2668(631, 'heatmor', 631, 14, 580, 169, 704, 1),
2669(632, 'durant', 632, 3, 330, 169, 705, 1),
2670(633, 'deino', 633, 8, 173, 60, 706, 1),
2671(634, 'zweilous', 634, 14, 500, 147, 707, 1),
2672(635, 'hydreigon', 635, 18, 1600, 270, 708, 1),
2673(636, 'larvesta', 636, 11, 288, 72, 709, 1),
2674(637, 'volcarona', 637, 16, 460, 248, 710, 1),
2675(638, 'cobalion', 638, 21, 2500, 261, 711, 1),
2676(639, 'terrakion', 639, 19, 2600, 261, 712, 1),
2677(640, 'virizion', 640, 20, 2000, 261, 713, 1),
2678(641, 'tornadus-incarnate', 641, 15, 630, 261, 714, 1),
2679(642, 'thundurus-incarnate', 642, 15, 610, 261, 716, 1),
2680(643, 'reshiram', 643, 32, 3300, 306, 718, 1),
2681(644, 'zekrom', 644, 29, 3450, 306, 719, 1),
2682(645, 'landorus-incarnate', 645, 15, 680, 270, 720, 1),
2683(646, 'kyurem', 646, 30, 3250, 297, 722, 1),
2684(647, 'keldeo-ordinary', 647, 14, 485, 261, 725, 1),
2685(648, 'meloetta-aria', 648, 6, 65, 270, 727, 1),
2686(649, 'genesect', 649, 15, 825, 270, 729, 1),
2687(650, 'chespin', 650, 4, 90, 63, 730, 1),
2688(651, 'quilladin', 651, 7, 290, 142, 731, 1),
2689(652, 'chesnaught', 652, 16, 900, 239, 732, 1),
2690(653, 'fennekin', 653, 4, 94, 61, 733, 1),
2691(654, 'braixen', 654, 10, 145, 143, 734, 1),
2692(655, 'delphox', 655, 15, 390, 240, 735, 1),
2693(656, 'froakie', 656, 3, 70, 63, 736, 1),
2694(657, 'frogadier', 657, 6, 109, 142, 737, 1),
2695(658, 'greninja', 658, 15, 400, 239, 738, 1),
2696(659, 'bunnelby', 659, 4, 50, 47, 739, 1),
2697(660, 'diggersby', 660, 10, 424, 148, 740, 1),
2698(661, 'fletchling', 661, 3, 17, 56, 741, 1),
2699(662, 'fletchinder', 662, 7, 160, 134, 742, 1),
2700(663, 'talonflame', 663, 12, 245, 175, 743, 1),
2701(664, 'scatterbug', 664, 3, 25, 40, 744, 1),
2702(665, 'spewpa', 665, 3, 84, 75, 745, 1),
2703(666, 'vivillon', 666, 12, 170, 185, 746, 1),
2704(667, 'litleo', 667, 6, 135, 74, 747, 1),
2705(668, 'pyroar', 668, 15, 815, 177, 748, 1),
2706(669, 'flabebe', 669, 1, 1, 61, 749, 1),
2707(670, 'floette', 670, 2, 9, 130, 750, 1),
2708(671, 'florges', 671, 11, 100, 248, 752, 1),
2709(672, 'skiddo', 672, 9, 310, 70, 753, 1),
2710(673, 'gogoat', 673, 17, 910, 186, 754, 1),
2711(674, 'pancham', 674, 6, 80, 70, 755, 1),
2712(675, 'pangoro', 675, 21, 1360, 173, 756, 1),
2713(676, 'furfrou', 676, 12, 280, 165, 757, 1),
2714(677, 'espurr', 677, 3, 35, 71, 758, 1),
2715(678, 'meowstic-male', 678, 6, 85, 163, 759, 1),
2716(679, 'honedge', 679, 8, 20, 65, 761, 1),
2717(680, 'doublade', 680, 8, 45, 157, 762, 1),
2718(681, 'aegislash-shield', 681, 17, 530, 234, 763, 1),
2719(682, 'spritzee', 682, 2, 5, 68, 765, 1),
2720(683, 'aromatisse', 683, 8, 155, 162, 766, 1),
2721(684, 'swirlix', 684, 4, 35, 68, 767, 1),
2722(685, 'slurpuff', 685, 8, 50, 168, 768, 1),
2723(686, 'inkay', 686, 4, 35, 58, 769, 1),
2724(687, 'malamar', 687, 15, 470, 169, 770, 1),
2725(688, 'binacle', 688, 5, 310, 61, 771, 1),
2726(689, 'barbaracle', 689, 13, 960, 175, 772, 1),
2727(690, 'skrelp', 690, 5, 73, 64, 773, 1),
2728(691, 'dragalge', 691, 18, 815, 173, 774, 1),
2729(692, 'clauncher', 692, 5, 83, 66, 775, 1),
2730(693, 'clawitzer', 693, 13, 353, 100, 776, 1),
2731(694, 'helioptile', 694, 5, 60, 58, 777, 1),
2732(695, 'heliolisk', 695, 10, 210, 168, 778, 1),
2733(696, 'tyrunt', 696, 8, 260, 72, 779, 1),
2734(697, 'tyrantrum', 697, 25, 2700, 182, 780, 1),
2735(698, 'amaura', 698, 13, 252, 72, 781, 1),
2736(699, 'aurorus', 699, 27, 2250, 104, 782, 1),
2737(700, 'sylveon', 700, 10, 235, 184, 185, 1),
2738(701, 'hawlucha', 701, 8, 215, 175, 783, 1),
2739(702, 'dedenne', 702, 2, 22, 151, 784, 1),
2740(703, 'carbink', 703, 3, 57, 100, 785, 1),
2741(704, 'goomy', 704, 3, 28, 60, 786, 1),
2742(705, 'sliggoo', 705, 8, 175, 158, 787, 1),
2743(706, 'goodra', 706, 20, 1505, 270, 788, 1),
2744(707, 'klefki', 707, 2, 30, 165, 789, 1),
2745(708, 'phantump', 708, 4, 70, 62, 790, 1),
2746(709, 'trevenant', 709, 15, 710, 166, 791, 1),
2747(710, 'pumpkaboo-average', 710, 4, 50, 67, 793, 1),
2748(711, 'gourgeist-average', 711, 9, 125, 173, 797, 1),
2749(712, 'bergmite', 712, 10, 995, 61, 800, 1),
2750(713, 'avalugg', 713, 20, 5050, 180, 801, 1),
2751(714, 'noibat', 714, 5, 80, 49, 802, 1),
2752(715, 'noivern', 715, 15, 850, 187, 803, 1),
2753(716, 'xerneas', 716, 30, 2150, 306, 804, 1),
2754(717, 'yveltal', 717, 58, 2030, 306, 805, 1),
2755(718, 'zygarde', 718, 50, 3050, 270, 806, 1),
2756(719, 'diancie', 719, 7, 88, 270, 807, 1),
2757(720, 'hoopa', 720, 5, 90, 270, 809, 1),
2758(721, 'volcanion', 721, 17, 1950, 270, 811, 1),
2759(10001, 'deoxys-attack', 386, 17, 608, 270, 470, 0),
2760(10002, 'deoxys-defense', 386, 17, 608, 270, 471, 0),
2761(10003, 'deoxys-speed', 386, 17, 608, 270, 472, 0),
2762(10004, 'wormadam-sandy', 413, 5, 65, 148, 498, 0),
2763(10005, 'wormadam-trash', 413, 5, 65, 148, 499, 0),
2764(10006, 'shaymin-sky', 492, 4, 52, 270, 562, 0),
2765(10007, 'giratina-origin', 487, 69, 6500, 306, 556, 0),
2766(10008, 'rotom-heat', 479, 3, 3, 182, 543, 0),
2767(10009, 'rotom-wash', 479, 3, 3, 182, 544, 0),
2768(10010, 'rotom-frost', 479, 3, 3, 182, 545, 0),
2769(10011, 'rotom-fan', 479, 3, 3, 182, 546, 0),
2770(10012, 'rotom-mow', 479, 3, 3, 182, 547, 0),
2771(10013, 'castform-sunny', 351, 3, 8, 147, 420, 0),
2772(10014, 'castform-rainy', 351, 3, 8, 147, 421, 0),
2773(10015, 'castform-snowy', 351, 3, 8, 147, 422, 0),
2774(10016, 'basculin-blue-striped', 550, 10, 180, 161, 622, 0),
2775(10017, 'darmanitan-zen', 555, 13, 929, 189, 628, 0),
2776(10018, 'meloetta-pirouette', 648, 6, 65, 270, 728, 0),
2777(10019, 'tornadus-therian', 641, 14, 630, 261, 715, 0),
2778(10020, 'thundurus-therian', 642, 30, 610, 261, 717, 0),
2779(10021, 'landorus-therian', 645, 13, 680, 270, 721, 0),
2780(10022, 'kyurem-black', 646, 33, 3250, 315, 723, 0),
2781(10023, 'kyurem-white', 646, 36, 3250, 315, 724, 0),
2782(10024, 'keldeo-resolute', 647, 14, 485, 261, 726, 0),
2783(10025, 'meowstic-female', 678, 6, 85, 163, 760, 0),
2784(10026, 'aegislash-blade', 681, 17, 530, 234, 764, 0),
2785(10027, 'pumpkaboo-small', 710, 3, 35, 67, 792, 0),
2786(10028, 'pumpkaboo-large', 710, 5, 75, 67, 794, 0),
2787(10029, 'pumpkaboo-super', 710, 8, 150, 67, 795, 0),
2788(10030, 'gourgeist-small', 711, 7, 95, 173, 796, 0),
2789(10031, 'gourgeist-large', 711, 11, 140, 173, 798, 0),
2790(10032, 'gourgeist-super', 711, 17, 390, 173, 799, 0),
2791(10033, 'venusaur-mega', 3, 24, 1555, 281, 4, 0),
2792(10034, 'charizard-mega-x', 6, 17, 1105, 285, 8, 0),
2793(10035, 'charizard-mega-y', 6, 17, 1005, 285, 9, 0),
2794(10036, 'blastoise-mega', 9, 16, 1011, 284, 13, 0),
2795(10037, 'alakazam-mega', 65, 12, 480, 266, 84, 0),
2796(10038, 'gengar-mega', 94, 14, 405, 270, 117, 0),
2797(10039, 'kangaskhan-mega', 115, 22, 1000, 207, 148, 0),
2798(10040, 'pinsir-mega', 127, 17, 590, 210, 170, 0),
2799(10041, 'gyarados-mega', 130, 65, 3050, 224, 174, 0),
2800(10042, 'aerodactyl-mega', 142, 21, 790, 215, 194, 0),
2801(10043, 'mewtwo-mega-x', 150, 23, 1270, 351, 204, 0),
2802(10044, 'mewtwo-mega-y', 150, 15, 330, 351, 205, 0),
2803(10045, 'ampharos-mega', 181, 14, 615, 275, 234, 0),
2804(10046, 'scizor-mega', 212, 20, 1250, 210, 160, 0),
2805(10047, 'heracross-mega', 214, 17, 625, 210, 269, 0),
2806(10048, 'houndoom-mega', 229, 19, 495, 210, 288, 0),
2807(10049, 'tyranitar-mega', 248, 25, 2550, 315, 300, 0),
2808(10050, 'blaziken-mega', 257, 19, 520, 284, 311, 0),
2809(10051, 'gardevoir-mega', 282, 16, 484, 278, 338, 0),
2810(10052, 'mawile-mega', 303, 10, 235, 168, 363, 0),
2811(10053, 'aggron-mega', 306, 22, 3950, 284, 367, 0),
2812(10054, 'medicham-mega', 308, 13, 315, 179, 370, 0),
2813(10055, 'manectric-mega', 310, 18, 440, 201, 373, 0),
2814(10056, 'banette-mega', 354, 12, 130, 194, 426, 0),
2815(10057, 'absol-mega', 359, 12, 490, 198, 434, 0),
2816(10058, 'garchomp-mega', 445, 19, 950, 315, 526, 0),
2817(10059, 'lucario-mega', 448, 13, 575, 219, 529, 0),
2818(10060, 'abomasnow-mega', 460, 27, 1850, 208, 541, 0),
2819(10061, 'floette-eternal', 670, 2, 9, 243, 751, 0),
2820(10062, 'latias-mega', 380, 18, 520, 315, 459, 0),
2821(10063, 'latios-mega', 381, 23, 700, 315, 461, 0),
2822(10064, 'swampert-mega', 260, 19, 1020, 286, 315, 0),
2823(10065, 'sceptile-mega', 254, 19, 552, 284, 307, 0),
2824(10066, 'sableye-mega', 302, 5, 1610, 168, 361, 0),
2825(10067, 'altaria-mega', 334, 15, 206, 207, 402, 0),
2826(10068, 'gallade-mega', 475, 16, 564, 278, 340, 0),
2827(10069, 'audino-mega', 531, 15, 320, 425, 602, 0),
2828(10070, 'sharpedo-mega', 319, 25, 1303, 196, 385, 0),
2829(10071, 'slowbro-mega', 80, 20, 1200, 207, 100, 0),
2830(10072, 'steelix-mega', 208, 105, 7400, 214, 120, 0),
2831(10073, 'pidgeot-mega', 18, 22, 505, 261, 24, 0),
2832(10074, 'glalie-mega', 362, 21, 3502, 203, 437, 0),
2833(10075, 'diancie-mega', 719, 11, 278, 315, 808, 0),
2834(10076, 'metagross-mega', 376, 25, 9429, 315, 454, 0),
2835(10077, 'kyogre-primal', 382, 98, 4300, 347, 463, 0),
2836(10078, 'groudon-primal', 383, 50, 9997, 347, 465, 0),
2837(10079, 'rayquaza-mega', 384, 108, 3920, 351, 467, 0),
2838(10080, 'pikachu-rock-star', 25, 4, 60, 112, 34, 0),
2839(10081, 'pikachu-belle', 25, 4, 60, 112, 35, 0),
2840(10082, 'pikachu-pop-star', 25, 4, 60, 112, 36, 0),
2841(10083, 'pikachu-phd', 25, 4, 60, 112, 37, 0),
2842(10084, 'pikachu-libre', 25, 4, 60, 112, 38, 0),
2843(10085, 'pikachu-cosplay', 25, 4, 60, 112, 33, 0),
2844(10086, 'hoopa-unbound', 720, 65, 4900, 306, 810, 0),
2845(10087, 'camerupt-mega', 323, 25, 3205, 196, 390, 0),
2846(10088, 'lopunny-mega', 428, 13, 283, 203, 514, 0),
2847(10089, 'salamence-mega', 373, 18, 1126, 315, 450, 0),
2848(10090, 'beedrill-mega', 15, 14, 405, 223, 20, 0);
2849
2850--
2851-- Indexes for dumped tables
2852--
2853
2854--
2855-- Indexes for table `pokemon`
2856--
2857ALTER TABLE `pokemon`
2858  ADD PRIMARY KEY (`id`);
2859--
2860-- Database: `snackplace`
2861--
2862CREATE DATABASE IF NOT EXISTS `snackplace` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2863USE `snackplace`;
2864
2865-- --------------------------------------------------------
2866
2867--
2868-- Table structure for table `category`
2869--
2870
2871CREATE TABLE `category` (
2872  `id` int(11) NOT NULL,
2873  `name` varchar(45) NOT NULL
2874) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2875
2876--
2877-- Dumping data for table `category`
2878--
2879
2880INSERT INTO `category` (`id`, `name`) VALUES
2881(1, 'Fries'),
2882(2, 'Snack'),
2883(3, 'Sauce');
2884
2885-- --------------------------------------------------------
2886
2887--
2888-- Table structure for table `logentry`
2889--
2890
2891CREATE TABLE `logentry` (
2892  `id` int(11) NOT NULL,
2893  `message` varchar(1024) DEFAULT NULL
2894) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2895
2896--
2897-- Dumping data for table `logentry`
2898--
2899
2900INSERT INTO `logentry` (`id`, `message`) VALUES
2901(1, '0:0:0:0:0:0:0:1 requested /home.do'),
2902(2, '0:0:0:0:0:0:0:1 requested /selectProduct.do'),
2903(3, '0:0:0:0:0:0:0:1 requested /addProduct.do'),
2904(4, '0:0:0:0:0:0:0:1 requested /selectProduct.do'),
2905(5, '0:0:0:0:0:0:0:1 requested /addProduct.do'),
2906(6, '0:0:0:0:0:0:0:1 requested /checkout.do'),
2907(7, '0:0:0:0:0:0:0:1 requested /home.do');
2908
2909-- --------------------------------------------------------
2910
2911--
2912-- Table structure for table `product`
2913--
2914
2915CREATE TABLE `product` (
2916  `id` int(11) NOT NULL,
2917  `category_id` int(11) NOT NULL,
2918  `name` varchar(45) NOT NULL,
2919  `price` double NOT NULL
2920) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2921
2922--
2923-- Dumping data for table `product`
2924--
2925
2926INSERT INTO `product` (`id`, `category_id`, `name`, `price`) VALUES
2927(1, 1, 'Small fries', 1.75),
2928(2, 1, 'Medium fries', 2.25),
2929(3, 1, 'Large fries', 2.75),
2930(4, 2, 'Hamburger', 2.5),
2931(5, 2, 'Cheeseburger', 2.75),
2932(6, 2, 'Vegetarian burger', 2.5),
2933(7, 2, 'Hot dog', 2.25),
2934(8, 3, 'Mayonnaise', 0.5),
2935(9, 3, 'Ketchup', 0.5),
2936(10, 3, 'Garlic sauce', 0.5);
2937
2938--
2939-- Indexes for dumped tables
2940--
2941
2942--
2943-- Indexes for table `category`
2944--
2945ALTER TABLE `category`
2946  ADD PRIMARY KEY (`id`);
2947
2948--
2949-- Indexes for table `logentry`
2950--
2951ALTER TABLE `logentry`
2952  ADD PRIMARY KEY (`id`);
2953
2954--
2955-- Indexes for table `product`
2956--
2957ALTER TABLE `product`
2958  ADD PRIMARY KEY (`id`);
2959
2960--
2961-- AUTO_INCREMENT for dumped tables
2962--
2963
2964--
2965-- AUTO_INCREMENT for table `category`
2966--
2967ALTER TABLE `category`
2968  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
2969--
2970-- AUTO_INCREMENT for table `logentry`
2971--
2972ALTER TABLE `logentry`
2973  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
2974--
2975-- AUTO_INCREMENT for table `product`
2976--
2977ALTER TABLE `product`
2978  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;