aA2GcdFi

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