-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Generation Time: May 24, 2017 at 03:33 PM
-- Server version: 5.6.33
-- PHP Version: 7.0.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `BIBL`
--
CREATE DATABASE IF NOT EXISTS `BIBL` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `BIBL`;

-- --------------------------------------------------------

--
-- Table structure for table `Boeken`
--

CREATE TABLE `Boeken` (
  `boeknr` int(11) NOT NULL,
  `titel` varchar(30) NOT NULL,
  `taal` varchar(30) NOT NULL,
  `uitgnr` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Boeken`
--

INSERT INTO `Boeken` (`boeknr`, `titel`, `taal`, `uitgnr`) VALUES
(1, 'Professional C#', 'Engels', 1);

-- --------------------------------------------------------

--
-- Table structure for table `BoekenAuteurs`
--

CREATE TABLE `BoekenAuteurs` (
  `boeknr` int(11) NOT NULL,
  `aunr` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `Uitgevers`
--

CREATE TABLE `Uitgevers` (
  `uitgnr` int(11) NOT NULL,
  `uitgnaam` varchar(30) NOT NULL,
  `uitgstad` varchar(30) NOT NULL,
  `uitgland` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Uitgevers`
--

INSERT INTO `Uitgevers` (`uitgnr`, `uitgnaam`, `uitgstad`, `uitgland`) VALUES
(1, 'WROX', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `auteurs`
--

CREATE TABLE `auteurs` (
  `aunr` int(11) NOT NULL,
  `voornaam` varchar(30) NOT NULL,
  `familienaam` varchar(50) NOT NULL,
  `nationaliteit` varchar(30) NOT NULL,
  `gebdatum` date NOT NULL,
  `sterfdatum` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auteurs`
--

INSERT INTO `auteurs` (`aunr`, `voornaam`, `familienaam`, `nationaliteit`, `gebdatum`, `sterfdatum`) VALUES
(1, 'Christian', 'Nagel', 'Amerikaan', '1980-12-20', '0000-00-00'),
(2, 'Jay', 'Glynn', 'Amerikaan', '1975-01-24', '0000-00-00'),
(3, 'Bill', 'Evjen', 'Amerikaan', '1980-12-20', '0000-00-00');

-- --------------------------------------------------------

--
-- Table structure for table `hoofdstukken`
--

CREATE TABLE `hoofdstukken` (
  `boeknr` int(11) NOT NULL,
  `hfstnr` int(11) NOT NULL,
  `hfsttitel` varchar(100) NOT NULL,
  `startpagina` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `Boeken`
--
ALTER TABLE `Boeken`
  ADD PRIMARY KEY (`boeknr`),
  ADD KEY `fkuitgnr` (`uitgnr`);

--
-- Indexes for table `BoekenAuteurs`
--
ALTER TABLE `BoekenAuteurs`
  ADD PRIMARY KEY (`boeknr`,`aunr`),
  ADD KEY `fkaunr` (`aunr`);

--
-- Indexes for table `Uitgevers`
--
ALTER TABLE `Uitgevers`
  ADD PRIMARY KEY (`uitgnr`);

--
-- Indexes for table `auteurs`
--
ALTER TABLE `auteurs`
  ADD PRIMARY KEY (`aunr`);

--
-- Indexes for table `hoofdstukken`
--
ALTER TABLE `hoofdstukken`
  ADD PRIMARY KEY (`boeknr`,`hfstnr`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `Boeken`
--
ALTER TABLE `Boeken`
  MODIFY `boeknr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `Uitgevers`
--
ALTER TABLE `Uitgevers`
  MODIFY `uitgnr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `auteurs`
--
ALTER TABLE `auteurs`
  MODIFY `aunr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `hoofdstukken`
--
ALTER TABLE `hoofdstukken`
  MODIFY `boeknr` int(11) NOT NULL AUTO_INCREMENT;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `Boeken`
--
ALTER TABLE `Boeken`
  ADD CONSTRAINT `fkuitgnr` FOREIGN KEY (`uitgnr`) REFERENCES `uitgevers` (`uitgnr`);

--
-- Constraints for table `BoekenAuteurs`
--
ALTER TABLE `BoekenAuteurs`
  ADD CONSTRAINT `fkaunr` FOREIGN KEY (`aunr`) REFERENCES `auteurs` (`aunr`),
  ADD CONSTRAINT `fkboeknr` FOREIGN KEY (`boeknr`) REFERENCES `boeken` (`boeknr`);

--
-- Constraints for table `hoofdstukken`
--
ALTER TABLE `hoofdstukken`
  ADD CONSTRAINT `fkboeknr2` FOREIGN KEY (`boeknr`) REFERENCES `boeken` (`boeknr`);
--
-- Database: `DebtAware`
--
CREATE DATABASE IF NOT EXISTS `DebtAware` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `DebtAware`;

-- --------------------------------------------------------

--
-- Table structure for table `Relationships`
--

CREATE TABLE `Relationships` (
  `person1` int(11) NOT NULL,
  `person2` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Relationships`
--

INSERT INTO `Relationships` (`person1`, `person2`) VALUES
(39, 38),
(40, 38),
(40, 39);

-- --------------------------------------------------------

--
-- Table structure for table `debts`
--

CREATE TABLE `debts` (
  `debt_id` int(11) NOT NULL,
  `loaner_id` int(11) NOT NULL,
  `cost` float NOT NULL,
  `event_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `debts`
--

INSERT INTO `debts` (`debt_id`, `loaner_id`, `cost`, `event_id`) VALUES
(21, 39, 11, 49),
(22, 38, 3, 49),
(23, 38, 11.3, 49),
(24, 38, 14.34, 49),
(25, 38, 7, 49),
(26, 38, 11, 50),
(27, 39, 7, 50),
(28, 40, 9, 50),
(29, 40, 1, 50),
(30, 39, 13, 50);

-- --------------------------------------------------------

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `event_id` int(11) NOT NULL,
  `eventname` varchar(400) NOT NULL,
  `description` mediumtext NOT NULL,
  `longt` float NOT NULL,
  `latt` float NOT NULL,
  `creator_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`event_id`, `eventname`, `description`, `longt`, `latt`, `creator_id`) VALUES
(49, 'test', 'zz', 32, 23, 0),
(50, 'test2', 'hallo', 32, 23, 0),
(51, 'hallo', '', 32, 23, 0),
(52, '', '', 32, 23, 0),
(53, '', '', 32, 23, 0);

-- --------------------------------------------------------

--
-- Table structure for table `userevents`
--

CREATE TABLE `userevents` (
  `event_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `userevents`
--

INSERT INTO `userevents` (`event_id`, `user_id`) VALUES
(48, 38),
(49, 38),
(49, 39),
(50, 38),
(50, 39),
(50, 40),
(51, 38),
(51, 40),
(52, 40),
(53, 38);

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `user_id` int(11) NOT NULL,
  `email` varchar(60) NOT NULL,
  `name` varchar(40) NOT NULL,
  `password` varchar(150) NOT NULL,
  `ccnumber` varchar(14) NOT NULL DEFAULT '',
  `active` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`user_id`, `email`, `name`, `password`, `ccnumber`, `active`) VALUES
(38, 'jorrevynckier@hotmail.com', 'jorre vynckier', '$2y$10$cGVrxxdL6WFbeyrj77imAOUxulKGorAWuRRHVGcpNf27zfzs7R4Ue', 'BE32', NULL),
(39, 'laurensdierickx', 'laurens dierickx', '$2y$10$Irf8Y0HrvYUUqF6BaNIVSe2iL2nBKe7wXyICwd4zdDt6XcU/KstoC', 'BE32', NULL),
(40, 'kyara', 'kyara dewyse', '$2y$10$0nuC2y0Hxmo2O8jFsJcbCeDsPq342K9G3CZLXa4f4VYQjK3UGsx1e', 'zz', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `debts`
--
ALTER TABLE `debts`
  ADD PRIMARY KEY (`debt_id`);

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`event_id`);

--
-- Indexes for table `userevents`
--
ALTER TABLE `userevents`
  ADD PRIMARY KEY (`event_id`,`user_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `debts`
--
ALTER TABLE `debts`
  MODIFY `debt_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `event_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;--
-- Database: `LesDB`
--
CREATE DATABASE IF NOT EXISTS `LesDB` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `LesDB`;

-- --------------------------------------------------------

--
-- Table structure for table `Boeken`
--

CREATE TABLE `Boeken` (
  `boeknr` int(11) NOT NULL,
  `titel` varchar(30) NOT NULL,
  `taal` varchar(30) NOT NULL,
  `uitgnr` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `Uitgevers`
--

CREATE TABLE `Uitgevers` (
  `uitgnr` int(11) NOT NULL,
  `uitgnaam` varchar(30) NOT NULL,
  `uitgstad` varchar(30) NOT NULL,
  `uitgland` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `functies`
--

CREATE TABLE `functies` (
  `ftienaam` char(18) NOT NULL,
  `minsal` int(11) DEFAULT NULL,
  `maxsal` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `functies`
--

INSERT INTO `functies` (`ftienaam`, `minsal`, `maxsal`) VALUES
('Analist', 45000, 60000),
('DBA', 65000, 85000),
('Directeur', 100000, 140000),
('Lesgever', 55000, 80000),
('Onderdirecteur', 75000, 100000),
('Programmeur', 32000, 44000),
('Technicus', 30000, 37000),
('Vertegenwoordiger', 30000, 40000);

-- --------------------------------------------------------

--
-- Table structure for table `vervangingen`
--

CREATE TABLE `vervangingen` (
  `wnr` char(2) NOT NULL,
  `vervangernr` char(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vervangingen`
--

INSERT INTO `vervangingen` (`wnr`, `vervangernr`) VALUES
('01', '02'),
('05', '04'),
('04', '05'),
('03', '06'),
('07', '06'),
('06', '07'),
('08', '09'),
('10', '09'),
('08', '10'),
('09', '10'),
('14', '11'),
('20', '15'),
('17', '16'),
('16', '17'),
('19', '18'),
('18', '19');

-- --------------------------------------------------------

--
-- Table structure for table `vestigingen`
--

CREATE TABLE `vestigingen` (
  `vesnaam` char(15) NOT NULL,
  `branche` char(10) DEFAULT NULL,
  `plaats` char(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vestigingen`
--

INSERT INTO `vestigingen` (`vesnaam`, `branche`, `plaats`) VALUES
('Computerland', 'Verkoop', 'Brussel'),
('Leasing', 'Verhuur', 'Antwerpen'),
('Paradise', 'Verkoop', 'Gent'),
('Technica', 'Verkoop', 'Antwerpen'),
('Training', 'Opleiding', 'Antwerpen');

-- --------------------------------------------------------

--
-- Table structure for table `werknemers`
--

CREATE TABLE `werknemers` (
  `wnr` char(2) NOT NULL,
  `wnaam` char(15) DEFAULT NULL,
  `afdeling` char(2) DEFAULT NULL,
  `ftienaam` char(18) DEFAULT NULL,
  `salaris` int(11) DEFAULT NULL,
  `vesnaam` char(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `werknemers`
--

INSERT INTO `werknemers` (`wnr`, `wnaam`, `afdeling`, `ftienaam`, `salaris`, `vesnaam`) VALUES
('01', 'Buylaert', 'B3', 'Vertegenwoordiger', 40000, 'Computerland'),
('02', 'Vervekke', 'B3', 'Vertegenwoordiger', 42000, 'Computerland'),
('03', 'Janssens', 'B1', 'Directeur', 100000, 'Computerland'),
('04', 'Lievens', 'B2', 'Analist', 55000, 'Computerland'),
('05', 'Lutenberg', 'B2', 'Analist', 60000, 'Computerland'),
('06', 'Jens', 'A1', 'Directeur', 150000, 'Technica'),
('07', 'Timan', 'A1', 'Onderdirecteur', 120000, 'Technica'),
('08', 'Imbrecht', 'A2', 'Programmeur', 35000, 'Technica'),
('09', 'Pieters', 'A2', 'Analist', 43000, 'Technica'),
('10', 'Peeters', 'A2', 'Analist', 50000, 'Technica'),
('11', 'Mansaert', 'A2', 'DBA', 70000, 'Technica'),
('12', 'Lutenberg', 'G1', 'Onderdirecteur', 85000, 'Paradise'),
('13', 'Klerk', 'G3', 'Vertegenwoordiger', 28000, 'Paradise'),
('14', 'Konings', 'G2', 'Analist', 45000, 'Paradise'),
('15', 'Dingens', 'A1', 'Directeur', 80000, 'Training'),
('16', 'Van Loo', 'A4', 'Lesgever', 81000, 'Training'),
('17', 'Van Snit', 'A4', 'Lesgever', 60000, 'Training'),
('18', 'Van Meer', 'A3', 'Technicus', 43000, 'Leasing'),
('19', 'Meesen', 'A3', 'Technicus', 37000, 'Leasing'),
('20', 'Delmot', 'A1', 'Onderdirecteur', 83000, 'Leasing');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `Boeken`
--
ALTER TABLE `Boeken`
  ADD PRIMARY KEY (`boeknr`),
  ADD KEY `fkuitgnr` (`uitgnr`);

--
-- Indexes for table `Uitgevers`
--
ALTER TABLE `Uitgevers`
  ADD PRIMARY KEY (`uitgnr`);

--
-- Indexes for table `functies`
--
ALTER TABLE `functies`
  ADD PRIMARY KEY (`ftienaam`);

--
-- Indexes for table `vervangingen`
--
ALTER TABLE `vervangingen`
  ADD PRIMARY KEY (`wnr`,`vervangernr`),
  ADD KEY `fk2_vervanging` (`vervangernr`);

--
-- Indexes for table `vestigingen`
--
ALTER TABLE `vestigingen`
  ADD PRIMARY KEY (`vesnaam`);

--
-- Indexes for table `werknemers`
--
ALTER TABLE `werknemers`
  ADD PRIMARY KEY (`wnr`),
  ADD KEY `fk1_werknemer` (`vesnaam`),
  ADD KEY `fk2_werknemer` (`ftienaam`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `Boeken`
--
ALTER TABLE `Boeken`
  MODIFY `boeknr` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `Uitgevers`
--
ALTER TABLE `Uitgevers`
  MODIFY `uitgnr` int(11) NOT NULL AUTO_INCREMENT;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `Boeken`
--
ALTER TABLE `Boeken`
  ADD CONSTRAINT `fkuitgnr` FOREIGN KEY (`uitgnr`) REFERENCES `uitgevers` (`uitgnr`);

--
-- Constraints for table `vervangingen`
--
ALTER TABLE `vervangingen`
  ADD CONSTRAINT `fk1_vervanging` FOREIGN KEY (`wnr`) REFERENCES `werknemers` (`wnr`),
  ADD CONSTRAINT `fk2_vervanging` FOREIGN KEY (`vervangernr`) REFERENCES `werknemers` (`wnr`);

--
-- Constraints for table `werknemers`
--
ALTER TABLE `werknemers`
  ADD CONSTRAINT `fk1_werknemer` FOREIGN KEY (`vesnaam`) REFERENCES `vestigingen` (`vesnaam`),
  ADD CONSTRAINT `fk2_werknemer` FOREIGN KEY (`ftienaam`) REFERENCES `functies` (`ftienaam`);
--
-- Database: `School`
--
CREATE DATABASE IF NOT EXISTS `School` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `School`;

-- --------------------------------------------------------

--
-- Table structure for table `cursussen`
--

CREATE TABLE `cursussen` (
  `cursusnr` int(11) NOT NULL,
  `cursusnaam` varchar(30) DEFAULT NULL,
  `inschrijvingsgeld` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cursussen`
--

INSERT INTO `cursussen` (`cursusnr`, `cursusnaam`, `inschrijvingsgeld`) VALUES
(1, 'C#', 50),
(2, 'SQL', 100),
(3, 'Java', 70),
(4, 'Excel', 70),
(5, 'MS SQL Server', 100);

-- --------------------------------------------------------

--
-- Table structure for table `studenten`
--

CREATE TABLE `studenten` (
  `studnr` int(11) NOT NULL,
  `voornaam` varchar(30) DEFAULT NULL,
  `familienaam` varchar(30) DEFAULT NULL,
  `geboortedatum` date DEFAULT NULL,
  `geslacht` char(1) DEFAULT NULL,
  `betaald` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `studenten`
--

INSERT INTO `studenten` (`studnr`, `voornaam`, `familienaam`, `geboortedatum`, `geslacht`, `betaald`) VALUES
(1, 'Francois', 'Bemelmans', '1985-04-28', 'M', 250),
(2, 'Veerle', 'Van Maele', '1987-07-06', 'V', 50),
(3, 'Karel', 'Govaert', '1985-05-07', 'M', 0),
(4, 'Luc', 'Janssens', '1988-12-10', 'M', 50),
(5, 'Leen', 'Verstraete', '1988-12-09', 'V', 120),
(6, 'Jos', 'Van Den Berg', '1985-08-23', 'M', 150),
(7, 'Diane', 'Hanssen', '1986-05-12', 'V', 50),
(8, 'Bart', 'Baertmans', '1990-11-03', 'M', 50),
(9, 'Carol', 'Mestdagh', '1989-01-07', 'V', 100),
(10, 'Lucie', 'Jaspaert', '1989-05-22', 'V', 120),
(11, 'Koen', 'Mortelgems', '1990-04-04', 'M', 100),
(12, 'Marie', 'Van Maele', '1988-10-26', 'V', 0),
(13, 'Marc', 'Vandoorne', NULL, 'M', 0),
(14, 'Lieve', 'Van Maele', '1986-11-24', 'V', 0);

-- --------------------------------------------------------

--
-- Table structure for table `studenten_cursussen`
--

CREATE TABLE `studenten_cursussen` (
  `studnr` int(11) NOT NULL,
  `cursusnr` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `studenten_cursussen`
--

INSERT INTO `studenten_cursussen` (`studnr`, `cursusnr`) VALUES
(1, 1),
(2, 1),
(4, 1),
(7, 1),
(8, 1),
(12, 1),
(1, 2),
(5, 2),
(9, 2),
(10, 2),
(11, 2),
(12, 2),
(1, 3),
(5, 3),
(6, 3),
(1, 4),
(6, 4),
(10, 4);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cursussen`
--
ALTER TABLE `cursussen`
  ADD PRIMARY KEY (`cursusnr`);

--
-- Indexes for table `studenten`
--
ALTER TABLE `studenten`
  ADD PRIMARY KEY (`studnr`);

--
-- Indexes for table `studenten_cursussen`
--
ALTER TABLE `studenten_cursussen`
  ADD PRIMARY KEY (`studnr`,`cursusnr`),
  ADD KEY `cursusnr` (`cursusnr`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cursussen`
--
ALTER TABLE `cursussen`
  MODIFY `cursusnr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `studenten`
--
ALTER TABLE `studenten`
  MODIFY `studnr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `studenten_cursussen`
--
ALTER TABLE `studenten_cursussen`
  ADD CONSTRAINT `studenten_cursussen_ibfk_1` FOREIGN KEY (`studnr`) REFERENCES `studenten` (`studnr`),
  ADD CONSTRAINT `studenten_cursussen_ibfk_2` FOREIGN KEY (`cursusnr`) REFERENCES `cursussen` (`cursusnr`);
--
-- Database: `astralstrifes`
--
CREATE DATABASE IF NOT EXISTS `astralstrifes` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `astralstrifes`;

-- --------------------------------------------------------

--
-- Table structure for table `bullets`
--

CREATE TABLE `bullets` (
  `item_id` int(11) NOT NULL,
  `velocity` int(11) DEFAULT NULL,
  `image` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `difficulties`
--

CREATE TABLE `difficulties` (
  `difficulty_id` int(11) NOT NULL,
  `difficulty_name` varchar(45) DEFAULT NULL,
  `shootingEnemyScore` int(11) NOT NULL,
  `normalEnemyScore` int(11) NOT NULL,
  `saturnEnemyScore` int(11) NOT NULL,
  `normalEnemySpeed` float DEFAULT NULL,
  `shootingEnemyShoot` int(11) NOT NULL,
  `saturnEnemyMove` float NOT NULL,
  `shootingEnemyMulti` int(11) NOT NULL,
  `notmalEnemyMulti` int(11) NOT NULL,
  `saturnEnemyMulti` int(11) NOT NULL,
  `swiftyduration` int(11) NOT NULL,
  `adhdPower` int(11) NOT NULL,
  `spawnSpeed` int(11) NOT NULL,
  `playerShootSpeed` int(11) NOT NULL,
  `normalEDamage` int(11) NOT NULL,
  `shootEDamage` int(11) NOT NULL,
  `satEDamage` int(11) NOT NULL,
  `eBulletDamage` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `difficulties`
--

INSERT INTO `difficulties` (`difficulty_id`, `difficulty_name`, `shootingEnemyScore`, `normalEnemyScore`, `saturnEnemyScore`, `normalEnemySpeed`, `shootingEnemyShoot`, `saturnEnemyMove`, `shootingEnemyMulti`, `notmalEnemyMulti`, `saturnEnemyMulti`, `swiftyduration`, `adhdPower`, `spawnSpeed`, `playerShootSpeed`, `normalEDamage`, `shootEDamage`, `satEDamage`, `eBulletDamage`) VALUES
(1, 'easy', 15, 10, 20, 0.2, 1000, 0.2, 1, 1, 1, 3000, 30, 3000, 100, 10, 10, 10, 10),
(2, 'medium', 25, 15, 30, 0.3, 600, 0.3, 2, 1, 1, 4000, 25, 2500, 90, 15, 15, 15, 15),
(3, 'hard', 35, 20, 40, 0.4, 400, 0.5, 2, 2, 2, 5000, 20, 2000, 80, 20, 20, 20, 20);

-- --------------------------------------------------------

--
-- Table structure for table `enemies`
--

CREATE TABLE `enemies` (
  `enemy_id` int(11) NOT NULL,
  `enemy_name` varchar(45) NOT NULL,
  `image` varchar(45) DEFAULT NULL,
  `shoot` tinyint(1) DEFAULT NULL,
  `health` int(11) DEFAULT NULL,
  `moves` tinyint(1) DEFAULT NULL,
  `manna_score` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `enemies`
--

INSERT INTO `enemies` (`enemy_id`, `enemy_name`, `image`, `shoot`, `health`, `moves`, `manna_score`) VALUES
(1, 'shootingenemy', 'resources/gameSprites/planet4.png', 1, NULL, 0, 200),
(2, 'saturnenemy', 'resources/gameSprites/planet6.png', 1, NULL, 1, NULL),
(3, 'normalenemy', 'resources/gameSprites/planet1.png', 0, NULL, 1, 150);

-- --------------------------------------------------------

--
-- Table structure for table `game`
--

CREATE TABLE `game` (
  `game_id` int(11) NOT NULL,
  `score` int(11) DEFAULT NULL,
  `wave_id` int(11) DEFAULT NULL,
  `difficulty_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `item_id` int(11) NOT NULL,
  `item_name` varchar(45) NOT NULL,
  `type` varchar(45) DEFAULT NULL,
  `cost` int(11) DEFAULT NULL,
  `image` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`item_id`, `item_name`, `type`, `cost`, `image`) VALUES
(1, 'attackdrone', 'drone', NULL, 'resources/gameSprites/attack1.png'),
(3, 'healdrone', 'drone', NULL, 'resources/gameSprites/healdrone.png'),
(4, 'killdrone', 'drone', NULL, 'resources/gameSprites/attack2.png'),
(5, 'dronebullet', 'bullet', NULL, 'resources/gameSprites/attackDroneBullet.png'),
(6, 'swifty', 'powerup', NULL, 'resources/gameSprites/swifty.png');

-- --------------------------------------------------------

--
-- Table structure for table `powerup`
--

CREATE TABLE `powerup` (
  `item_id` int(11) NOT NULL,
  `skill` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `powerup`
--

INSERT INTO `powerup` (`item_id`, `skill`) VALUES
(6, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `ranks`
--

CREATE TABLE `ranks` (
  `rank_id` int(11) NOT NULL,
  `rank_name` varchar(45) DEFAULT NULL,
  `XP_needed` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ranks`
--

INSERT INTO `ranks` (`rank_id`, `rank_name`, `XP_needed`) VALUES
(1, 'Pluto', NULL),
(2, 'Moon', NULL),
(3, 'Mercury', NULL),
(4, 'Mars', NULL),
(5, 'Venus', NULL),
(6, 'Earth', NULL),
(7, 'Neptune', NULL),
(8, 'Uranus', NULL),
(9, 'Saturn', NULL),
(10, 'Jupiter', NULL),
(11, 'Proxima Centauri', NULL),
(12, 'Sun', NULL),
(13, 'UY Scuti', NULL),
(14, 'Andromeda', NULL),
(15, 'Heliosphere', NULL),
(16, 'Galaxy', NULL),
(17, 'Milky Way', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `skins`
--

CREATE TABLE `skins` (
  `item_id` int(11) NOT NULL,
  `unlock_lvl` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `supportdrones`
--

CREATE TABLE `supportdrones` (
  `item_id` int(11) NOT NULL,
  `unlock_lvl` int(11) DEFAULT NULL,
  `skill` varchar(45) DEFAULT NULL,
  `drone_xp` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supportdrones`
--

INSERT INTO `supportdrones` (`item_id`, `unlock_lvl`, `skill`, `drone_xp`) VALUES
(1, NULL, NULL, NULL),
(3, NULL, NULL, NULL),
(4, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `userid` int(11) NOT NULL,
  `username` varchar(25) NOT NULL,
  `password` varchar(128) NOT NULL,
  `email` varchar(45) NOT NULL,
  `XP` int(11) DEFAULT NULL,
  `highscore` int(11) DEFAULT NULL,
  `astrals` int(11) DEFAULT NULL,
  `game_id` int(11) DEFAULT NULL,
  `rank_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`userid`, `username`, `password`, `email`, `XP`, `highscore`, `astrals`, `game_id`, `rank_id`) VALUES
(3, 'AstralKing', 'astral123', 'astral@outlook.com', NULL, NULL, NULL, NULL, 3),
(4, 'VangeelJ', 'lol123', 'jensvangeel@zz.com', NULL, 1500, NULL, NULL, 2),
(5, 'Pwn0z', 'gRt', 'PownD@gmail.com', NULL, 10000, NULL, NULL, 1),
(6, 'laurens', 'l', 'laurens@gmail.com', NULL, NULL, NULL, NULL, 4),
(7, 'jorre', 'jorre', 'jorre', NULL, NULL, NULL, NULL, 5),
(8, 'JensVangeel', 'jens', 'jensvangeel@hotmail.com', NULL, NULL, NULL, NULL, 6);

-- --------------------------------------------------------

--
-- Table structure for table `wave_enemies`
--

CREATE TABLE `wave_enemies` (
  `wave_id` int(11) NOT NULL,
  `enemy_id` int(11) NOT NULL,
  `amount` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wave_enemies`
--

INSERT INTO `wave_enemies` (`wave_id`, `enemy_id`, `amount`) VALUES
(1, 1, 5),
(1, 3, 10),
(2, 1, 3),
(2, 2, 5),
(2, 3, 15),
(3, 1, 6),
(3, 2, 10),
(3, 3, 20),
(4, 1, 12),
(4, 2, 15),
(4, 3, 25),
(5, 1, 16),
(5, 2, 20),
(5, 3, 30);

-- --------------------------------------------------------

--
-- Table structure for table `waves`
--

CREATE TABLE `waves` (
  `wave_id` int(11) NOT NULL,
  `level_name` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `waves`
--

INSERT INTO `waves` (`wave_id`, `level_name`) VALUES
(1, 'wave1'),
(2, 'wave2'),
(3, 'wave3'),
(4, 'wave4'),
(5, 'wave5'),
(6, 'wave6'),
(7, 'wave7'),
(8, 'wave8'),
(9, 'wave9'),
(10, 'wave10'),
(11, 'wave11'),
(12, 'wave12');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bullets`
--
ALTER TABLE `bullets`
  ADD PRIMARY KEY (`item_id`);

--
-- Indexes for table `difficulties`
--
ALTER TABLE `difficulties`
  ADD PRIMARY KEY (`difficulty_id`);

--
-- Indexes for table `enemies`
--
ALTER TABLE `enemies`
  ADD PRIMARY KEY (`enemy_id`);

--
-- Indexes for table `game`
--
ALTER TABLE `game`
  ADD PRIMARY KEY (`game_id`),
  ADD KEY `wave_game_idx` (`wave_id`),
  ADD KEY `difficulty_game_idx` (`difficulty_id`);

--
-- Indexes for table `items`
--
ALTER TABLE `items`
  ADD PRIMARY KEY (`item_id`);

--
-- Indexes for table `powerup`
--
ALTER TABLE `powerup`
  ADD PRIMARY KEY (`item_id`);

--
-- Indexes for table `ranks`
--
ALTER TABLE `ranks`
  ADD PRIMARY KEY (`rank_id`);

--
-- Indexes for table `skins`
--
ALTER TABLE `skins`
  ADD PRIMARY KEY (`item_id`);

--
-- Indexes for table `supportdrones`
--
ALTER TABLE `supportdrones`
  ADD PRIMARY KEY (`item_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`userid`),
  ADD KEY `player_game_idx` (`game_id`);

--
-- Indexes for table `wave_enemies`
--
ALTER TABLE `wave_enemies`
  ADD PRIMARY KEY (`wave_id`,`enemy_id`),
  ADD KEY `wave_enemy_idx` (`enemy_id`);

--
-- Indexes for table `waves`
--
ALTER TABLE `waves`
  ADD PRIMARY KEY (`wave_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `difficulties`
--
ALTER TABLE `difficulties`
  MODIFY `difficulty_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `enemies`
--
ALTER TABLE `enemies`
  MODIFY `enemy_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `game`
--
ALTER TABLE `game`
  MODIFY `game_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `items`
--
ALTER TABLE `items`
  MODIFY `item_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `ranks`
--
ALTER TABLE `ranks`
  MODIFY `rank_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `userid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `waves`
--
ALTER TABLE `waves`
  MODIFY `wave_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `bullets`
--
ALTER TABLE `bullets`
  ADD CONSTRAINT `bullet_item` FOREIGN KEY (`item_id`) REFERENCES `items` (`item_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `game`
--
ALTER TABLE `game`
  ADD CONSTRAINT `difficulty_game` FOREIGN KEY (`difficulty_id`) REFERENCES `difficulties` (`difficulty_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `wave_game` FOREIGN KEY (`wave_id`) REFERENCES `waves` (`wave_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `powerup`
--
ALTER TABLE `powerup`
  ADD CONSTRAINT `item_powup` FOREIGN KEY (`item_id`) REFERENCES `items` (`item_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `skins`
--
ALTER TABLE `skins`
  ADD CONSTRAINT `item_skin` FOREIGN KEY (`item_id`) REFERENCES `items` (`item_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `player_game` FOREIGN KEY (`game_id`) REFERENCES `game` (`game_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `wave_enemies`
--
ALTER TABLE `wave_enemies`
  ADD CONSTRAINT `enemy_id` FOREIGN KEY (`enemy_id`) REFERENCES `enemies` (`enemy_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `wave_id` FOREIGN KEY (`wave_id`) REFERENCES `waves` (`wave_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
--
-- Database: `examshop`
--
CREATE DATABASE IF NOT EXISTS `examshop` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `examshop`;

-- --------------------------------------------------------

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `name`) VALUES
(1, 'Beverages'),
(2, 'Condiments'),
(3, 'Confections'),
(4, 'Dairy Products'),
(5, 'Grains/Cereals'),
(6, 'Meat/Poultry'),
(7, 'Produce'),
(8, 'Seafood');

-- --------------------------------------------------------

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `id` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`id`, `name`, `price`, `category_id`) VALUES
(1, 'Chai', 18, 1),
(2, 'Chang', 19, 1),
(3, 'Aniseed Syrup', 10, 2),
(4, 'Chef Anton\'s Cajun Seasoning', 22, 2),
(5, 'Chef Anton\'s Gumbo Mix', 21.35, 2),
(6, 'Grandma\'s Boysenberry Spread', 25, 2),
(7, 'Uncle Bob\'s Organic Dried Pears', 30, 7),
(8, 'Northwoods Cranberry Sauce', 40, 2),
(9, 'Mishi Kobe Niku', 97, 6),
(10, 'Ikura', 31, 8),
(11, 'Queso Cabrales', 21, 4),
(12, 'Queso Manchego La Pastora', 38, 4),
(13, 'Konbu', 6, 8),
(14, 'Tofu', 23.25, 7),
(15, 'Genen Shouyu', 15.5, 2),
(16, 'Pavlova', 17.45, 3),
(17, 'Alice Mutton', 39, 6),
(18, 'Carnarvon Tigers', 62.5, 8),
(19, 'Teatime Chocolate Biscuits', 9.2, 3),
(20, 'Sir Rodney\'s Marmalade', 81, 3),
(21, 'Sir Rodney\'s Scones', 10, 3);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product`
--
ALTER TABLE `product`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;--
-- Database: `forms`
--
CREATE DATABASE IF NOT EXISTS `forms` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `forms`;

-- --------------------------------------------------------

--
-- Table structure for table `fields`
--

CREATE TABLE `fields` (
  `idfields` int(11) NOT NULL,
  `form` int(11) NOT NULL,
  `name` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fields`
--

INSERT INTO `fields` (`idfields`, `form`, `name`) VALUES
(0, 0, 'voornaam'),
(1, 0, 'achternaam'),
(2, 0, 'hobby'),
(3, 1, 'voornaam'),
(4, 1, 'achternaam'),
(5, 1, 'leeftijd'),
(6, 1, 'hobby'),
(7, 1, 'geslacht'),
(8, 1, 'bloedgroep'),
(9, 1, 'email');

-- --------------------------------------------------------

--
-- Table structure for table `forms`
--

CREATE TABLE `forms` (
  `idforms` int(11) NOT NULL,
  `name` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `forms`
--

INSERT INTO `forms` (`idforms`, `name`) VALUES
(0, 'Korte Vragenlijst'),
(1, 'Lange Vragenlijst');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `fields`
--
ALTER TABLE `fields`
  ADD PRIMARY KEY (`idfields`),
  ADD KEY `fk_field_idx` (`form`);

--
-- Indexes for table `forms`
--
ALTER TABLE `forms`
  ADD PRIMARY KEY (`idforms`);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `fields`
--
ALTER TABLE `fields`
  ADD CONSTRAINT `fk_field` FOREIGN KEY (`form`) REFERENCES `forms` (`idforms`) ON DELETE NO ACTION ON UPDATE NO ACTION;
--
-- Database: `lapdb`
--
CREATE DATABASE IF NOT EXISTS `lapdb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `lapdb`;

-- --------------------------------------------------------

--
-- Table structure for table `Artikels`
--

CREATE TABLE `Artikels` (
  `anr` char(3) NOT NULL,
  `anaam` char(15) DEFAULT NULL,
  `kleur` char(10) DEFAULT NULL,
  `gewicht` int(11) DEFAULT NULL,
  `plaats` char(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Artikels`
--

INSERT INTO `Artikels` (`anr`, `anaam`, `kleur`, `gewicht`, `plaats`) VALUES
('A1', 'Moer', 'Rood', 12, 'Brussel'),
('A2', 'Bout', 'Groen', 17, 'Antwerpen'),
('A3', 'Schroef', 'Blauw', 17, 'Leuven'),
('A4', 'Schroef', 'Rood', 14, 'Brussel'),
('A5', 'Nagel', 'Blauw', 12, 'Antwerpen'),
('A6', 'Plug', 'Rood', 19, 'Brussel');

-- --------------------------------------------------------

--
-- Table structure for table `Leveranciers`
--

CREATE TABLE `Leveranciers` (
  `lnr` char(3) NOT NULL,
  `lnaam` char(15) DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  `plaats` char(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Leveranciers`
--

INSERT INTO `Leveranciers` (`lnr`, `lnaam`, `STATUS`, `plaats`) VALUES
('L1', 'Smith', 20, 'Brussel'),
('L2', 'Jones', 10, 'Antwerpen'),
('L3', 'Blake', 30, 'Antwerpen'),
('L4', 'Clark', 20, 'Brussel'),
('L5', 'Adams', 30, 'Gent'),
('L6', 'Ackermans', 0, 'Brugge');

-- --------------------------------------------------------

--
-- Table structure for table `Leveringen`
--

CREATE TABLE `Leveringen` (
  `lnr` char(3) NOT NULL,
  `anr` char(3) NOT NULL,
  `pnr` char(3) NOT NULL,
  `hoev` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Leveringen`
--

INSERT INTO `Leveringen` (`lnr`, `anr`, `pnr`, `hoev`) VALUES
('L1', 'A1', 'P1', 200),
('L1', 'A1', 'P4', 700),
('L2', 'A3', 'P1', 400),
('L2', 'A3', 'P2', 200),
('L2', 'A3', 'P3', 200),
('L2', 'A3', 'P4', 500),
('L2', 'A3', 'P5', 600),
('L2', 'A3', 'P6', 400),
('L2', 'A3', 'P7', 800),
('L2', 'A5', 'P2', 100),
('L3', 'A3', 'P1', 200),
('L3', 'A4', 'P2', 500),
('L4', 'A6', 'P3', 300),
('L4', 'A6', 'P7', 300),
('L5', 'A1', 'P4', 100),
('L5', 'A2', 'P2', 200),
('L5', 'A2', 'P4', 100),
('L5', 'A3', 'P4', 200),
('L5', 'A4', 'P4', 800),
('L5', 'A5', 'P4', 400),
('L5', 'A5', 'P5', 500),
('L5', 'A5', 'P7', 100),
('L5', 'A6', 'P2', 200),
('L5', 'A6', 'P4', 500);

-- --------------------------------------------------------

--
-- Table structure for table `Projecten`
--

CREATE TABLE `Projecten` (
  `pnr` char(3) NOT NULL,
  `pnaam` char(15) DEFAULT NULL,
  `plaats` char(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Projecten`
--

INSERT INTO `Projecten` (`pnr`, `pnaam`, `plaats`) VALUES
('P1', 'Sorter', 'Antwerpen'),
('P2', 'Display', 'Leuven'),
('P3', 'OCR', 'Gent'),
('P4', 'Console', 'Gent'),
('P5', 'RAID', 'Brussel'),
('P6', 'EDS', 'Namen'),
('P7', 'Tape', 'Brussel');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `Artikels`
--
ALTER TABLE `Artikels`
  ADD PRIMARY KEY (`anr`);

--
-- Indexes for table `Leveranciers`
--
ALTER TABLE `Leveranciers`
  ADD PRIMARY KEY (`lnr`);

--
-- Indexes for table `Leveringen`
--
ALTER TABLE `Leveringen`
  ADD PRIMARY KEY (`lnr`,`anr`,`pnr`),
  ADD KEY `fk2_levering` (`anr`),
  ADD KEY `fk3_levering` (`pnr`);

--
-- Indexes for table `Projecten`
--
ALTER TABLE `Projecten`
  ADD PRIMARY KEY (`pnr`);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `Leveringen`
--
ALTER TABLE `Leveringen`
  ADD CONSTRAINT `fk1_levering` FOREIGN KEY (`lnr`) REFERENCES `leveranciers` (`lnr`),
  ADD CONSTRAINT `fk2_levering` FOREIGN KEY (`anr`) REFERENCES `artikels` (`anr`),
  ADD CONSTRAINT `fk3_levering` FOREIGN KEY (`pnr`) REFERENCES `projecten` (`pnr`);
--
-- Database: `moviebase`
--
CREATE DATABASE IF NOT EXISTS `moviebase` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `moviebase`;

-- --------------------------------------------------------

--
-- Table structure for table `genre`
--

CREATE TABLE `genre` (
  `id` int(11) NOT NULL,
  `name` varchar(128) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `genre`
--

INSERT INTO `genre` (`id`, `name`) VALUES
(1, 'Action'),
(2, 'Adventure'),
(3, 'Comedy'),
(4, 'Detective'),
(5, 'Drama'),
(6, 'Fantasy'),
(7, 'Horror'),
(8, 'Sci-Fi'),
(9, 'Thriller'),
(10, 'Western');

-- --------------------------------------------------------

--
-- Table structure for table `movie`
--

CREATE TABLE `movie` (
  `id` int(11) NOT NULL,
  `title` varchar(128) DEFAULT NULL,
  `genre_id` int(11) DEFAULT NULL,
  `year` int(11) DEFAULT NULL,
  `stars` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `movie`
--

INSERT INTO `movie` (`id`, `title`, `genre_id`, `year`, `stars`) VALUES
(1, 'The Hunger Games', 6, 2012, 3),
(2, 'Star Trek Beyond', 8, 2016, 2),
(3, 'Divergent', 6, 2014, 3),
(4, 'Harry Potter and the Philosopher\'s Stone', 6, 2002, 4);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `genre`
--
ALTER TABLE `genre`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `movie`
--
ALTER TABLE `movie`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `genre`
--
ALTER TABLE `genre`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `movie`
--
ALTER TABLE `movie`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;--
-- Database: `oldtimer`
--
CREATE DATABASE IF NOT EXISTS `oldtimer` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `oldtimer`;

-- --------------------------------------------------------

--
-- Table structure for table `auto`
--

CREATE TABLE `auto` (
  `autonr` int(11) NOT NULL,
  `passagiers` int(11) DEFAULT NULL,
  `typenaam` char(30) DEFAULT NULL,
  `bouwjaar` int(11) DEFAULT NULL,
  `waarde` int(11) DEFAULT NULL,
  `lidnr` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auto`
--

INSERT INTO `auto` (`autonr`, `passagiers`, `typenaam`, `bouwjaar`, `waarde`, `lidnr`) VALUES
(1, 4, 'Ford MODEL A', 1930, 3000, 3),
(2, 4, 'Rolls-Royce Phantom II', 1931, 85000, 1),
(3, 4, 'Austin Ten', 1936, 3800, 5),
(4, 4, 'Duesenberg Model-J', 1932, 65000, 8),
(5, 2, 'Riley 9HP IMP', 1935, 4500, 2),
(6, 2, 'Singer Le Mans Speedster', 1934, 12500, 1),
(7, 2, 'Singer SM Roadster', 1954, 2500, 4),
(8, 2, 'Jaguar XK 120', 1952, 6500, 11),
(9, 2, 'Hornet Special', 1935, 5600, 12),
(10, 2, 'Oldsmobile Curved Dash', 1901, 8000, 1),
(11, 4, 'Austin Seven Chummy', 1923, 2000, 3),
(12, 4, 'Bentley R-Type', 1952, 4200, 14);

-- --------------------------------------------------------

--
-- Table structure for table `deelnemer`
--

CREATE TABLE `deelnemer` (
  `autonr` int(11) NOT NULL,
  `evenementnr` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `deelnemer`
--

INSERT INTO `deelnemer` (`autonr`, `evenementnr`) VALUES
(1, 201501),
(2, 201501),
(2, 201502),
(4, 201502),
(7, 201502),
(8, 201502),
(10, 201502),
(11, 201502),
(2, 201503),
(4, 201503),
(6, 201503),
(10, 201503),
(11, 201503),
(2, 201504),
(4, 201504),
(6, 201504),
(10, 201504),
(11, 201504),
(1, 201505),
(3, 201505),
(6, 201505),
(12, 201505);

-- --------------------------------------------------------

--
-- Table structure for table `evenement`
--

CREATE TABLE `evenement` (
  `evenementnr` int(11) NOT NULL,
  `evenementnaam` char(25) DEFAULT NULL,
  `evenementdatum` date DEFAULT NULL,
  `locatie` char(20) DEFAULT NULL,
  `soort` char(10) DEFAULT NULL,
  `prijs` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `evenement`
--

INSERT INTO `evenement` (`evenementnr`, `evenementnaam`, `evenementdatum`, `locatie`, `soort`, `prijs`) VALUES
(201501, 'Bollentocht', '2015-06-17', 'Keukenhof', 'Optocht', 25),
(201502, 'Zandvoort 2015', '2015-07-16', 'Boulevard', 'Toerrit', 45),
(201503, 'Amsterdam OldTimer', '2015-08-02', 'Damrak', 'Optocht', 15),
(201504, 'Amsterdam OldTimer', '2015-08-05', 'DeRai', 'Show', 5),
(201505, 'Hillegom Feestweek', '2015-08-19', 'Beeklaan', 'Toerrit', 38);

-- --------------------------------------------------------

--
-- Table structure for table `lid`
--

CREATE TABLE `lid` (
  `lidnr` int(11) NOT NULL,
  `lidnaam` char(20) DEFAULT NULL,
  `soort` char(6) DEFAULT NULL,
  `adres` char(50) DEFAULT NULL,
  `plaats` char(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lid`
--

INSERT INTO `lid` (`lidnr`, `lidnaam`, `soort`, `adres`, `plaats`) VALUES
(1, 'Verbeek', 'SENIOR', 'Parklaan 210', 'Sassenheim'),
(2, 'Schut', 'SENIOR', 'Bosweg 17', 'Noordwijk'),
(3, 'Vogel', 'SENIOR', 'Schans 35', 'Noordwijk'),
(4, 'Lenstra', 'SENIOR', 'Meerweg 24', 'Heemstede'),
(5, 'Pronk', 'SENIOR', 'Dreef 11', 'Aalsmeer'),
(6, 'Mol', 'JUNIOR', 'Hogeweg 94', 'Zandvoort'),
(7, 'Otten', 'JUNIOR', 'Hogeweg 96', 'Zandvoort'),
(8, 'Dregt', 'JUNIOR', 'Vosselaan 93', 'Hillegom'),
(9, 'Verbeek', 'SENIOR', 'Parklaan 210', 'Sassenheim'),
(10, 'Pronk', 'JUNIOR', 'Dreef 11', 'Aalsmeer'),
(11, 'Dekker', 'SENIOR', 'Lindenlaan 67', 'Sassenheim'),
(12, 'Wouters', 'JUNIOR', 'Emmaweg 32', 'Zandvoort'),
(13, 'Bos', 'JUNIOR', 'Dorpsstraat 210', 'Aalsmeer'),
(14, 'Bakker', 'JUNIOR', 'Mesdaglaan 84', 'Hillegom');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `auto`
--
ALTER TABLE `auto`
  ADD PRIMARY KEY (`autonr`),
  ADD KEY `fk_auto` (`lidnr`);

--
-- Indexes for table `deelnemer`
--
ALTER TABLE `deelnemer`
  ADD PRIMARY KEY (`autonr`,`evenementnr`),
  ADD KEY `fk2_deelnemer` (`evenementnr`);

--
-- Indexes for table `evenement`
--
ALTER TABLE `evenement`
  ADD PRIMARY KEY (`evenementnr`);

--
-- Indexes for table `lid`
--
ALTER TABLE `lid`
  ADD PRIMARY KEY (`lidnr`);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `auto`
--
ALTER TABLE `auto`
  ADD CONSTRAINT `fk_auto` FOREIGN KEY (`lidnr`) REFERENCES `lid` (`lidnr`);

--
-- Constraints for table `deelnemer`
--
ALTER TABLE `deelnemer`
  ADD CONSTRAINT `fk1_deelnemer` FOREIGN KEY (`autonr`) REFERENCES `auto` (`autonr`),
  ADD CONSTRAINT `fk2_deelnemer` FOREIGN KEY (`evenementnr`) REFERENCES `evenement` (`evenementnr`);
--
-- Database: `pizzaplace`
--
CREATE DATABASE IF NOT EXISTS `pizzaplace` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `pizzaplace`;

-- --------------------------------------------------------

--
-- Table structure for table `pizza`
--

CREATE TABLE `pizza` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `price` double NOT NULL,
  `vegetarian` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pizza`
--

INSERT INTO `pizza` (`id`, `name`, `price`, `vegetarian`) VALUES
(1, 'Margherita', 5.99, 1),
(2, 'Prosciutto', 6.99, 0),
(3, 'Funghi', 5.99, 1),
(4, 'Napolitana', 8.99, 0);

-- --------------------------------------------------------

--
-- Table structure for table `pizza_topping`
--

CREATE TABLE `pizza_topping` (
  `pizza_id` int(11) NOT NULL,
  `topping_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pizza_topping`
--

INSERT INTO `pizza_topping` (`pizza_id`, `topping_id`) VALUES
(1, 1),
(1, 6),
(2, 1),
(2, 2),
(2, 3),
(2, 6),
(3, 1),
(3, 2),
(3, 6),
(4, 1),
(4, 4),
(4, 5),
(4, 6);

-- --------------------------------------------------------

--
-- Table structure for table `topping`
--

CREATE TABLE `topping` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `topping`
--

INSERT INTO `topping` (`id`, `name`) VALUES
(1, 'tomatoes'),
(2, 'mushrooms'),
(3, 'ham'),
(4, 'ansjovis'),
(5, 'olives'),
(6, 'mozzarella');

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `login` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`login`, `password`) VALUES
('els', 'els123'),
('jef', 'jef123');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `pizza`
--
ALTER TABLE `pizza`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pizza_topping`
--
ALTER TABLE `pizza_topping`
  ADD PRIMARY KEY (`pizza_id`,`topping_id`);

--
-- Indexes for table `topping`
--
ALTER TABLE `topping`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`login`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `pizza`
--
ALTER TABLE `pizza`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `topping`
--
ALTER TABLE `topping`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;--
-- Database: `pokemon`
--
CREATE DATABASE IF NOT EXISTS `pokemon` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `pokemon`;

-- --------------------------------------------------------

--
-- Table structure for table `location`
--

CREATE TABLE `location` (
  `pokemonID` int(11) NOT NULL,
  `x` int(11) NOT NULL,
  `y` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `location`
--

INSERT INTO `location` (`pokemonID`, `x`, `y`) VALUES
(1, 519, 154),
(76, 638, 105),
(1, 568, 137),
(1, 567, 142),
(1, 615, 124),
(1, 537, 106),
(2, 516, 133),
(2, 589, 130),
(2, 507, 145),
(1, 607, 198),
(1, 601, 100),
(1, 388, 129),
(1, 388, 124),
(1, 410, 125),
(1, 464, 132),
(1, 510, 181),
(1, 408, 119),
(1, 413, 118),
(1, 503, 115),
(1, 474, 96),
(1, 504, 82),
(1, 437, 107),
(1, 437, 196),
(1, 357, 197),
(1, 547, 98),
(1, 577, 75),
(1, 579, 134),
(1, 608, 167),
(1, 512, 117),
(1, 634, 125),
(1, 656, 86);

-- --------------------------------------------------------

--
-- Table structure for table `pokemon`
--

CREATE TABLE `pokemon` (
  `id` int(11) NOT NULL,
  `identifier` varchar(45) DEFAULT NULL,
  `species_id` int(11) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  `base_experience` int(11) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  `is_default` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pokemon`
--

INSERT INTO `pokemon` (`id`, `identifier`, `species_id`, `height`, `weight`, `base_experience`, `order`, `is_default`) VALUES
(1, 'bulbasaur', 1, 7, 69, 64, 1, 1),
(2, 'ivysaur', 2, 10, 130, 142, 2, 1),
(3, 'venusaur', 3, 20, 1000, 236, 3, 1),
(4, 'charmander', 4, 6, 85, 62, 5, 1),
(5, 'charmeleon', 5, 11, 190, 142, 6, 1),
(6, 'charizard', 6, 17, 905, 240, 7, 1),
(7, 'squirtle', 7, 5, 90, 63, 10, 1),
(8, 'wartortle', 8, 10, 225, 142, 11, 1),
(9, 'blastoise', 9, 16, 855, 239, 12, 1),
(10, 'caterpie', 10, 3, 29, 39, 14, 1),
(11, 'metapod', 11, 7, 99, 72, 15, 1),
(12, 'butterfree', 12, 11, 320, 178, 16, 1),
(13, 'weedle', 13, 3, 32, 39, 17, 1),
(14, 'kakuna', 14, 6, 100, 72, 18, 1),
(15, 'beedrill', 15, 10, 295, 178, 19, 1),
(16, 'pidgey', 16, 3, 18, 50, 21, 1),
(17, 'pidgeotto', 17, 11, 300, 122, 22, 1),
(18, 'pidgeot', 18, 15, 395, 216, 23, 1),
(19, 'rattata', 19, 3, 35, 51, 25, 1),
(20, 'raticate', 20, 7, 185, 145, 26, 1),
(21, 'spearow', 21, 3, 20, 52, 27, 1),
(22, 'fearow', 22, 12, 380, 155, 28, 1),
(23, 'ekans', 23, 20, 69, 58, 29, 1),
(24, 'arbok', 24, 35, 650, 153, 30, 1),
(25, 'pikachu', 25, 4, 60, 112, 32, 1),
(26, 'raichu', 26, 8, 300, 218, 39, 1),
(27, 'sandshrew', 27, 6, 120, 60, 40, 1),
(28, 'sandslash', 28, 10, 295, 158, 41, 1),
(29, 'nidoran-f', 29, 4, 70, 55, 42, 1),
(30, 'nidorina', 30, 8, 200, 128, 43, 1),
(31, 'nidoqueen', 31, 13, 600, 227, 44, 1),
(32, 'nidoran-m', 32, 5, 90, 55, 45, 1),
(33, 'nidorino', 33, 9, 195, 128, 46, 1),
(34, 'nidoking', 34, 14, 620, 227, 47, 1),
(35, 'clefairy', 35, 6, 75, 113, 49, 1),
(36, 'clefable', 36, 13, 400, 217, 50, 1),
(37, 'vulpix', 37, 6, 99, 60, 51, 1),
(38, 'ninetales', 38, 11, 199, 177, 52, 1),
(39, 'jigglypuff', 39, 5, 55, 95, 54, 1),
(40, 'wigglytuff', 40, 10, 120, 196, 55, 1),
(41, 'zubat', 41, 8, 75, 49, 56, 1),
(42, 'golbat', 42, 16, 550, 159, 57, 1),
(43, 'oddish', 43, 5, 54, 64, 59, 1),
(44, 'gloom', 44, 8, 86, 138, 60, 1),
(45, 'vileplume', 45, 12, 186, 221, 61, 1),
(46, 'paras', 46, 3, 54, 57, 63, 1),
(47, 'parasect', 47, 10, 295, 142, 64, 1),
(48, 'venonat', 48, 10, 300, 61, 65, 1),
(49, 'venomoth', 49, 15, 125, 158, 66, 1),
(50, 'diglett', 50, 2, 8, 53, 67, 1),
(51, 'dugtrio', 51, 7, 333, 142, 68, 1),
(52, 'meowth', 52, 4, 42, 58, 69, 1),
(53, 'persian', 53, 10, 320, 154, 70, 1),
(54, 'psyduck', 54, 8, 196, 64, 71, 1),
(55, 'golduck', 55, 17, 766, 175, 72, 1),
(56, 'mankey', 56, 5, 280, 61, 73, 1),
(57, 'primeape', 57, 10, 320, 159, 74, 1),
(58, 'growlithe', 58, 7, 190, 70, 75, 1),
(59, 'arcanine', 59, 19, 1550, 194, 76, 1),
(60, 'poliwag', 60, 6, 124, 60, 77, 1),
(61, 'poliwhirl', 61, 10, 200, 135, 78, 1),
(62, 'poliwrath', 62, 13, 540, 230, 79, 1),
(63, 'abra', 63, 9, 195, 62, 81, 1),
(64, 'kadabra', 64, 13, 565, 140, 82, 1),
(65, 'alakazam', 65, 15, 480, 225, 83, 1),
(66, 'machop', 66, 8, 195, 61, 85, 1),
(67, 'machoke', 67, 15, 705, 142, 86, 1),
(68, 'machamp', 68, 16, 1300, 227, 87, 1),
(69, 'bellsprout', 69, 7, 40, 60, 88, 1),
(70, 'weepinbell', 70, 10, 64, 137, 89, 1),
(71, 'victreebel', 71, 17, 155, 221, 90, 1),
(72, 'tentacool', 72, 9, 455, 67, 91, 1),
(73, 'tentacruel', 73, 16, 550, 180, 92, 1),
(74, 'geodude', 74, 4, 200, 60, 93, 1),
(75, 'graveler', 75, 10, 1050, 137, 94, 1),
(76, 'golem', 76, 14, 3000, 223, 95, 1),
(77, 'ponyta', 77, 10, 300, 82, 96, 1),
(78, 'rapidash', 78, 17, 950, 175, 97, 1),
(79, 'slowpoke', 79, 12, 360, 63, 98, 1),
(80, 'slowbro', 80, 16, 785, 172, 99, 1),
(81, 'magnemite', 81, 3, 60, 65, 102, 1),
(82, 'magneton', 82, 10, 600, 163, 103, 1),
(83, 'farfetchd', 83, 8, 150, 123, 105, 1),
(84, 'doduo', 84, 14, 392, 62, 106, 1),
(85, 'dodrio', 85, 18, 852, 161, 107, 1),
(86, 'seel', 86, 11, 900, 65, 108, 1),
(87, 'dewgong', 87, 17, 1200, 166, 109, 1),
(88, 'grimer', 88, 9, 300, 65, 110, 1),
(89, 'muk', 89, 12, 300, 175, 111, 1),
(90, 'shellder', 90, 3, 40, 61, 112, 1),
(91, 'cloyster', 91, 15, 1325, 184, 113, 1),
(92, 'gastly', 92, 13, 1, 62, 114, 1),
(93, 'haunter', 93, 16, 1, 142, 115, 1),
(94, 'gengar', 94, 15, 405, 225, 116, 1),
(95, 'onix', 95, 88, 2100, 77, 118, 1),
(96, 'drowzee', 96, 10, 324, 66, 121, 1),
(97, 'hypno', 97, 16, 756, 169, 122, 1),
(98, 'krabby', 98, 4, 65, 65, 123, 1),
(99, 'kingler', 99, 13, 600, 166, 124, 1),
(100, 'voltorb', 100, 5, 104, 66, 125, 1),
(101, 'electrode', 101, 12, 666, 168, 126, 1),
(102, 'exeggcute', 102, 4, 25, 65, 127, 1),
(103, 'exeggutor', 103, 20, 1200, 182, 128, 1),
(104, 'cubone', 104, 4, 65, 64, 129, 1),
(105, 'marowak', 105, 10, 450, 149, 130, 1),
(106, 'hitmonlee', 106, 15, 498, 159, 132, 1),
(107, 'hitmonchan', 107, 14, 502, 159, 133, 1),
(108, 'lickitung', 108, 12, 655, 77, 135, 1),
(109, 'koffing', 109, 6, 10, 68, 137, 1),
(110, 'weezing', 110, 12, 95, 172, 138, 1),
(111, 'rhyhorn', 111, 10, 1150, 69, 139, 1),
(112, 'rhydon', 112, 19, 1200, 170, 140, 1),
(113, 'chansey', 113, 11, 346, 395, 143, 1),
(114, 'tangela', 114, 10, 350, 87, 145, 1),
(115, 'kangaskhan', 115, 22, 800, 172, 147, 1),
(116, 'horsea', 116, 4, 80, 59, 149, 1),
(117, 'seadra', 117, 12, 250, 154, 150, 1),
(118, 'goldeen', 118, 6, 150, 64, 152, 1),
(119, 'seaking', 119, 13, 390, 158, 153, 1),
(120, 'staryu', 120, 8, 345, 68, 154, 1),
(121, 'starmie', 121, 11, 800, 182, 155, 1),
(122, 'mr-mime', 122, 13, 545, 161, 157, 1),
(123, 'scyther', 123, 15, 560, 100, 158, 1),
(124, 'jynx', 124, 14, 406, 159, 162, 1),
(125, 'electabuzz', 125, 11, 300, 172, 164, 1),
(126, 'magmar', 126, 13, 445, 173, 167, 1),
(127, 'pinsir', 127, 15, 550, 175, 169, 1),
(128, 'tauros', 128, 14, 884, 172, 171, 1),
(129, 'magikarp', 129, 9, 100, 40, 172, 1),
(130, 'gyarados', 130, 65, 2350, 189, 173, 1),
(131, 'lapras', 131, 25, 2200, 187, 175, 1),
(132, 'ditto', 132, 3, 40, 101, 176, 1),
(133, 'eevee', 133, 3, 65, 65, 177, 1),
(134, 'vaporeon', 134, 10, 290, 184, 178, 1),
(135, 'jolteon', 135, 8, 245, 184, 179, 1),
(136, 'flareon', 136, 9, 250, 184, 180, 1),
(137, 'porygon', 137, 8, 365, 79, 186, 1),
(138, 'omanyte', 138, 4, 75, 71, 189, 1),
(139, 'omastar', 139, 10, 350, 173, 190, 1),
(140, 'kabuto', 140, 5, 115, 71, 191, 1),
(141, 'kabutops', 141, 13, 405, 173, 192, 1),
(142, 'aerodactyl', 142, 18, 590, 180, 193, 1),
(143, 'snorlax', 143, 21, 4600, 189, 196, 1),
(144, 'articuno', 144, 17, 554, 261, 197, 1),
(145, 'zapdos', 145, 16, 526, 261, 198, 1),
(146, 'moltres', 146, 20, 600, 261, 199, 1),
(147, 'dratini', 147, 18, 33, 60, 200, 1),
(148, 'dragonair', 148, 40, 165, 147, 201, 1),
(149, 'dragonite', 149, 22, 2100, 270, 202, 1),
(150, 'mewtwo', 150, 20, 1220, 306, 203, 1),
(151, 'mew', 151, 4, 40, 270, 206, 1),
(152, 'chikorita', 152, 9, 64, 64, 207, 1),
(153, 'bayleef', 153, 12, 158, 142, 208, 1),
(154, 'meganium', 154, 18, 1005, 236, 209, 1),
(155, 'cyndaquil', 155, 5, 79, 62, 210, 1),
(156, 'quilava', 156, 9, 190, 142, 211, 1),
(157, 'typhlosion', 157, 17, 795, 240, 212, 1),
(158, 'totodile', 158, 6, 95, 63, 213, 1),
(159, 'croconaw', 159, 11, 250, 142, 214, 1),
(160, 'feraligatr', 160, 23, 888, 239, 215, 1),
(161, 'sentret', 161, 8, 60, 43, 216, 1),
(162, 'furret', 162, 18, 325, 145, 217, 1),
(163, 'hoothoot', 163, 7, 212, 52, 218, 1),
(164, 'noctowl', 164, 16, 408, 155, 219, 1),
(165, 'ledyba', 165, 10, 108, 53, 220, 1),
(166, 'ledian', 166, 14, 356, 137, 221, 1),
(167, 'spinarak', 167, 5, 85, 50, 222, 1),
(168, 'ariados', 168, 11, 335, 137, 223, 1),
(169, 'crobat', 169, 18, 750, 241, 58, 1),
(170, 'chinchou', 170, 5, 120, 66, 224, 1),
(171, 'lanturn', 171, 12, 225, 161, 225, 1),
(172, 'pichu', 172, 3, 20, 41, 31, 1),
(173, 'cleffa', 173, 3, 30, 44, 48, 1),
(174, 'igglybuff', 174, 3, 10, 42, 53, 1),
(175, 'togepi', 175, 3, 15, 49, 226, 1),
(176, 'togetic', 176, 6, 32, 142, 227, 1),
(177, 'natu', 177, 2, 20, 64, 229, 1),
(178, 'xatu', 178, 15, 150, 165, 230, 1),
(179, 'mareep', 179, 6, 78, 56, 231, 1),
(180, 'flaaffy', 180, 8, 133, 128, 232, 1),
(181, 'ampharos', 181, 14, 615, 230, 233, 1),
(182, 'bellossom', 182, 4, 58, 221, 62, 1),
(183, 'marill', 183, 4, 85, 88, 236, 1),
(184, 'azumarill', 184, 8, 285, 189, 237, 1),
(185, 'sudowoodo', 185, 12, 380, 144, 239, 1),
(186, 'politoed', 186, 11, 339, 225, 80, 1),
(187, 'hoppip', 187, 4, 5, 50, 240, 1),
(188, 'skiploom', 188, 6, 10, 119, 241, 1),
(189, 'jumpluff', 189, 8, 30, 207, 242, 1),
(190, 'aipom', 190, 8, 115, 72, 243, 1),
(191, 'sunkern', 191, 3, 18, 36, 245, 1),
(192, 'sunflora', 192, 8, 85, 149, 246, 1),
(193, 'yanma', 193, 12, 380, 78, 247, 1),
(194, 'wooper', 194, 4, 85, 42, 249, 1),
(195, 'quagsire', 195, 14, 750, 151, 250, 1),
(196, 'espeon', 196, 9, 265, 184, 181, 1),
(197, 'umbreon', 197, 10, 270, 184, 182, 1),
(198, 'murkrow', 198, 5, 21, 81, 251, 1),
(199, 'slowking', 199, 20, 795, 172, 101, 1),
(200, 'misdreavus', 200, 7, 10, 87, 253, 1),
(201, 'unown', 201, 5, 50, 118, 255, 1),
(202, 'wobbuffet', 202, 13, 285, 142, 257, 1),
(203, 'girafarig', 203, 15, 415, 159, 258, 1),
(204, 'pineco', 204, 6, 72, 58, 259, 1),
(205, 'forretress', 205, 12, 1258, 163, 260, 1),
(206, 'dunsparce', 206, 15, 140, 145, 261, 1),
(207, 'gligar', 207, 11, 648, 86, 262, 1),
(208, 'steelix', 208, 92, 4000, 179, 119, 1),
(209, 'snubbull', 209, 6, 78, 60, 264, 1),
(210, 'granbull', 210, 14, 487, 158, 265, 1),
(211, 'qwilfish', 211, 5, 39, 86, 266, 1),
(212, 'scizor', 212, 18, 1180, 175, 159, 1),
(213, 'shuckle', 213, 6, 205, 177, 267, 1),
(214, 'heracross', 214, 15, 540, 175, 268, 1),
(215, 'sneasel', 215, 9, 280, 86, 270, 1),
(216, 'teddiursa', 216, 6, 88, 66, 272, 1),
(217, 'ursaring', 217, 18, 1258, 175, 273, 1),
(218, 'slugma', 218, 7, 350, 50, 274, 1),
(219, 'magcargo', 219, 8, 550, 144, 275, 1),
(220, 'swinub', 220, 4, 65, 50, 276, 1),
(221, 'piloswine', 221, 11, 558, 158, 277, 1),
(222, 'corsola', 222, 6, 50, 133, 279, 1),
(223, 'remoraid', 223, 6, 120, 60, 280, 1),
(224, 'octillery', 224, 9, 285, 168, 281, 1),
(225, 'delibird', 225, 9, 160, 116, 282, 1),
(226, 'mantine', 226, 21, 2200, 163, 284, 1),
(227, 'skarmory', 227, 17, 505, 163, 285, 1),
(228, 'houndour', 228, 6, 108, 66, 286, 1),
(229, 'houndoom', 229, 14, 350, 175, 287, 1),
(230, 'kingdra', 230, 18, 1520, 243, 151, 1),
(231, 'phanpy', 231, 5, 335, 66, 289, 1),
(232, 'donphan', 232, 11, 1200, 175, 290, 1),
(233, 'porygon2', 233, 6, 325, 180, 187, 1),
(234, 'stantler', 234, 14, 712, 163, 291, 1),
(235, 'smeargle', 235, 12, 580, 88, 292, 1),
(236, 'tyrogue', 236, 7, 210, 42, 131, 1),
(237, 'hitmontop', 237, 14, 480, 159, 134, 1),
(238, 'smoochum', 238, 4, 60, 61, 161, 1),
(239, 'elekid', 239, 6, 235, 72, 163, 1),
(240, 'magby', 240, 7, 214, 73, 166, 1),
(241, 'miltank', 241, 12, 755, 172, 293, 1),
(242, 'blissey', 242, 15, 468, 608, 144, 1),
(243, 'raikou', 243, 19, 1780, 261, 294, 1),
(244, 'entei', 244, 21, 1980, 261, 295, 1),
(245, 'suicune', 245, 20, 1870, 261, 296, 1),
(246, 'larvitar', 246, 6, 720, 60, 297, 1),
(247, 'pupitar', 247, 12, 1520, 144, 298, 1),
(248, 'tyranitar', 248, 20, 2020, 270, 299, 1),
(249, 'lugia', 249, 52, 2160, 306, 301, 1),
(250, 'ho-oh', 250, 38, 1990, 306, 302, 1),
(251, 'celebi', 251, 6, 50, 270, 303, 1),
(252, 'treecko', 252, 5, 50, 62, 304, 1),
(253, 'grovyle', 253, 9, 216, 142, 305, 1),
(254, 'sceptile', 254, 17, 522, 239, 306, 1),
(255, 'torchic', 255, 4, 25, 62, 308, 1),
(256, 'combusken', 256, 9, 195, 142, 309, 1),
(257, 'blaziken', 257, 19, 520, 239, 310, 1),
(258, 'mudkip', 258, 4, 76, 62, 312, 1),
(259, 'marshtomp', 259, 7, 280, 142, 313, 1),
(260, 'swampert', 260, 15, 819, 241, 314, 1),
(261, 'poochyena', 261, 5, 136, 44, 316, 1),
(262, 'mightyena', 262, 10, 370, 147, 317, 1),
(263, 'zigzagoon', 263, 4, 175, 48, 318, 1),
(264, 'linoone', 264, 5, 325, 147, 319, 1),
(265, 'wurmple', 265, 3, 36, 39, 320, 1),
(266, 'silcoon', 266, 6, 100, 72, 321, 1),
(267, 'beautifly', 267, 10, 284, 178, 322, 1),
(268, 'cascoon', 268, 7, 115, 41, 323, 1),
(269, 'dustox', 269, 12, 316, 135, 324, 1),
(270, 'lotad', 270, 5, 26, 44, 325, 1),
(271, 'lombre', 271, 12, 325, 119, 326, 1),
(272, 'ludicolo', 272, 15, 550, 216, 327, 1),
(273, 'seedot', 273, 5, 40, 44, 328, 1),
(274, 'nuzleaf', 274, 10, 280, 119, 329, 1),
(275, 'shiftry', 275, 13, 596, 216, 330, 1),
(276, 'taillow', 276, 3, 23, 54, 331, 1),
(277, 'swellow', 277, 7, 198, 151, 332, 1),
(278, 'wingull', 278, 6, 95, 54, 333, 1),
(279, 'pelipper', 279, 12, 280, 151, 334, 1),
(280, 'ralts', 280, 4, 66, 40, 335, 1),
(281, 'kirlia', 281, 8, 202, 97, 336, 1),
(282, 'gardevoir', 282, 16, 484, 233, 337, 1),
(283, 'surskit', 283, 5, 17, 54, 341, 1),
(284, 'masquerain', 284, 8, 36, 145, 342, 1),
(285, 'shroomish', 285, 4, 45, 59, 343, 1),
(286, 'breloom', 286, 12, 392, 161, 344, 1),
(287, 'slakoth', 287, 8, 240, 56, 345, 1),
(288, 'vigoroth', 288, 14, 465, 154, 346, 1),
(289, 'slaking', 289, 20, 1305, 252, 347, 1),
(290, 'nincada', 290, 5, 55, 53, 348, 1),
(291, 'ninjask', 291, 8, 120, 160, 349, 1),
(292, 'shedinja', 292, 8, 12, 83, 350, 1),
(293, 'whismur', 293, 6, 163, 48, 351, 1),
(294, 'loudred', 294, 10, 405, 126, 352, 1),
(295, 'exploud', 295, 15, 840, 221, 353, 1),
(296, 'makuhita', 296, 10, 864, 47, 354, 1),
(297, 'hariyama', 297, 23, 2538, 166, 355, 1),
(298, 'azurill', 298, 2, 20, 38, 235, 1),
(299, 'nosepass', 299, 10, 970, 75, 356, 1),
(300, 'skitty', 300, 6, 110, 52, 358, 1),
(301, 'delcatty', 301, 11, 326, 133, 359, 1),
(302, 'sableye', 302, 5, 110, 133, 360, 1),
(303, 'mawile', 303, 6, 115, 133, 362, 1),
(304, 'aron', 304, 4, 600, 66, 364, 1),
(305, 'lairon', 305, 9, 1200, 151, 365, 1),
(306, 'aggron', 306, 21, 3600, 239, 366, 1),
(307, 'meditite', 307, 6, 112, 56, 368, 1),
(308, 'medicham', 308, 13, 315, 144, 369, 1),
(309, 'electrike', 309, 6, 152, 59, 371, 1),
(310, 'manectric', 310, 15, 402, 166, 372, 1),
(311, 'plusle', 311, 4, 42, 142, 374, 1),
(312, 'minun', 312, 4, 42, 142, 375, 1),
(313, 'volbeat', 313, 7, 177, 140, 376, 1),
(314, 'illumise', 314, 6, 177, 140, 377, 1),
(315, 'roselia', 315, 3, 20, 140, 379, 1),
(316, 'gulpin', 316, 4, 103, 60, 381, 1),
(317, 'swalot', 317, 17, 800, 163, 382, 1),
(318, 'carvanha', 318, 8, 208, 61, 383, 1),
(319, 'sharpedo', 319, 18, 888, 161, 384, 1),
(320, 'wailmer', 320, 20, 1300, 80, 386, 1),
(321, 'wailord', 321, 145, 3980, 175, 387, 1),
(322, 'numel', 322, 7, 240, 61, 388, 1),
(323, 'camerupt', 323, 19, 2200, 161, 389, 1),
(324, 'torkoal', 324, 5, 804, 165, 391, 1),
(325, 'spoink', 325, 7, 306, 66, 392, 1),
(326, 'grumpig', 326, 9, 715, 165, 393, 1),
(327, 'spinda', 327, 11, 50, 126, 394, 1),
(328, 'trapinch', 328, 7, 150, 58, 395, 1),
(329, 'vibrava', 329, 11, 153, 119, 396, 1),
(330, 'flygon', 330, 20, 820, 234, 397, 1),
(331, 'cacnea', 331, 4, 513, 67, 398, 1),
(332, 'cacturne', 332, 13, 774, 166, 399, 1),
(333, 'swablu', 333, 4, 12, 62, 400, 1),
(334, 'altaria', 334, 11, 206, 172, 401, 1),
(335, 'zangoose', 335, 13, 403, 160, 403, 1),
(336, 'seviper', 336, 27, 525, 160, 404, 1),
(337, 'lunatone', 337, 10, 1680, 154, 405, 1),
(338, 'solrock', 338, 12, 1540, 154, 406, 1),
(339, 'barboach', 339, 4, 19, 58, 407, 1),
(340, 'whiscash', 340, 9, 236, 164, 408, 1),
(341, 'corphish', 341, 6, 115, 62, 409, 1),
(342, 'crawdaunt', 342, 11, 328, 164, 410, 1),
(343, 'baltoy', 343, 5, 215, 60, 411, 1),
(344, 'claydol', 344, 15, 1080, 175, 412, 1),
(345, 'lileep', 345, 10, 238, 71, 413, 1),
(346, 'cradily', 346, 15, 604, 173, 414, 1),
(347, 'anorith', 347, 7, 125, 71, 415, 1),
(348, 'armaldo', 348, 15, 682, 173, 416, 1),
(349, 'feebas', 349, 6, 74, 40, 417, 1),
(350, 'milotic', 350, 62, 1620, 189, 418, 1),
(351, 'castform', 351, 3, 8, 147, 419, 1),
(352, 'kecleon', 352, 10, 220, 154, 423, 1),
(353, 'shuppet', 353, 6, 23, 59, 424, 1),
(354, 'banette', 354, 11, 125, 159, 425, 1),
(355, 'duskull', 355, 8, 150, 59, 427, 1),
(356, 'dusclops', 356, 16, 306, 159, 428, 1),
(357, 'tropius', 357, 20, 1000, 161, 430, 1),
(358, 'chimecho', 358, 6, 10, 149, 432, 1),
(359, 'absol', 359, 12, 470, 163, 433, 1),
(360, 'wynaut', 360, 6, 140, 52, 256, 1),
(361, 'snorunt', 361, 7, 168, 60, 435, 1),
(362, 'glalie', 362, 15, 2565, 168, 436, 1),
(363, 'spheal', 363, 8, 395, 58, 439, 1),
(364, 'sealeo', 364, 11, 876, 144, 440, 1),
(365, 'walrein', 365, 14, 1506, 239, 441, 1),
(366, 'clamperl', 366, 4, 525, 69, 442, 1),
(367, 'huntail', 367, 17, 270, 170, 443, 1),
(368, 'gorebyss', 368, 18, 226, 170, 444, 1),
(369, 'relicanth', 369, 10, 234, 170, 445, 1),
(370, 'luvdisc', 370, 6, 87, 116, 446, 1),
(371, 'bagon', 371, 6, 421, 60, 447, 1),
(372, 'shelgon', 372, 11, 1105, 147, 448, 1),
(373, 'salamence', 373, 15, 1026, 270, 449, 1),
(374, 'beldum', 374, 6, 952, 60, 451, 1),
(375, 'metang', 375, 12, 2025, 147, 452, 1),
(376, 'metagross', 376, 16, 5500, 270, 453, 1),
(377, 'regirock', 377, 17, 2300, 261, 455, 1),
(378, 'regice', 378, 18, 1750, 261, 456, 1),
(379, 'registeel', 379, 19, 2050, 261, 457, 1),
(380, 'latias', 380, 14, 400, 270, 458, 1),
(381, 'latios', 381, 20, 600, 270, 460, 1),
(382, 'kyogre', 382, 45, 3520, 302, 462, 1),
(383, 'groudon', 383, 35, 9500, 302, 464, 1),
(384, 'rayquaza', 384, 70, 2065, 306, 466, 1),
(385, 'jirachi', 385, 3, 11, 270, 468, 1),
(386, 'deoxys-normal', 386, 17, 608, 270, 469, 1),
(387, 'turtwig', 387, 4, 102, 64, 473, 1),
(388, 'grotle', 388, 11, 970, 142, 474, 1),
(389, 'torterra', 389, 22, 3100, 236, 475, 1),
(390, 'chimchar', 390, 5, 62, 62, 476, 1),
(391, 'monferno', 391, 9, 220, 142, 477, 1),
(392, 'infernape', 392, 12, 550, 240, 478, 1),
(393, 'piplup', 393, 4, 52, 63, 479, 1),
(394, 'prinplup', 394, 8, 230, 142, 480, 1),
(395, 'empoleon', 395, 17, 845, 239, 481, 1),
(396, 'starly', 396, 3, 20, 49, 482, 1),
(397, 'staravia', 397, 6, 155, 119, 483, 1),
(398, 'staraptor', 398, 12, 249, 218, 484, 1),
(399, 'bidoof', 399, 5, 200, 50, 485, 1),
(400, 'bibarel', 400, 10, 315, 144, 486, 1),
(401, 'kricketot', 401, 3, 22, 39, 487, 1),
(402, 'kricketune', 402, 10, 255, 134, 488, 1),
(403, 'shinx', 403, 5, 95, 53, 489, 1),
(404, 'luxio', 404, 9, 305, 127, 490, 1),
(405, 'luxray', 405, 14, 420, 235, 491, 1),
(406, 'budew', 406, 2, 12, 56, 378, 1),
(407, 'roserade', 407, 9, 145, 232, 380, 1),
(408, 'cranidos', 408, 9, 315, 70, 492, 1),
(409, 'rampardos', 409, 16, 1025, 173, 493, 1),
(410, 'shieldon', 410, 5, 570, 70, 494, 1),
(411, 'bastiodon', 411, 13, 1495, 173, 495, 1),
(412, 'burmy', 412, 2, 34, 45, 496, 1),
(413, 'wormadam-plant', 413, 5, 65, 148, 497, 1),
(414, 'mothim', 414, 9, 233, 148, 500, 1),
(415, 'combee', 415, 3, 55, 49, 501, 1),
(416, 'vespiquen', 416, 12, 385, 166, 502, 1),
(417, 'pachirisu', 417, 4, 39, 142, 503, 1),
(418, 'buizel', 418, 7, 295, 66, 504, 1),
(419, 'floatzel', 419, 11, 335, 173, 505, 1),
(420, 'cherubi', 420, 4, 33, 55, 506, 1),
(421, 'cherrim', 421, 5, 93, 158, 507, 1),
(422, 'shellos', 422, 3, 63, 65, 508, 1),
(423, 'gastrodon', 423, 9, 299, 166, 509, 1),
(424, 'ambipom', 424, 12, 203, 169, 244, 1),
(425, 'drifloon', 425, 4, 12, 70, 510, 1),
(426, 'drifblim', 426, 12, 150, 174, 511, 1),
(427, 'buneary', 427, 4, 55, 70, 512, 1),
(428, 'lopunny', 428, 12, 333, 168, 513, 1),
(429, 'mismagius', 429, 9, 44, 173, 254, 1),
(430, 'honchkrow', 430, 9, 273, 177, 252, 1),
(431, 'glameow', 431, 5, 39, 62, 515, 1),
(432, 'purugly', 432, 10, 438, 158, 516, 1),
(433, 'chingling', 433, 2, 6, 57, 431, 1),
(434, 'stunky', 434, 4, 192, 66, 517, 1),
(435, 'skuntank', 435, 10, 380, 168, 518, 1),
(436, 'bronzor', 436, 5, 605, 60, 519, 1),
(437, 'bronzong', 437, 13, 1870, 175, 520, 1),
(438, 'bonsly', 438, 5, 150, 58, 238, 1),
(439, 'mime-jr', 439, 6, 130, 62, 156, 1),
(440, 'happiny', 440, 6, 244, 110, 142, 1),
(441, 'chatot', 441, 5, 19, 144, 521, 1),
(442, 'spiritomb', 442, 10, 1080, 170, 522, 1),
(443, 'gible', 443, 7, 205, 60, 523, 1),
(444, 'gabite', 444, 14, 560, 144, 524, 1),
(445, 'garchomp', 445, 19, 950, 270, 525, 1),
(446, 'munchlax', 446, 6, 1050, 78, 195, 1),
(447, 'riolu', 447, 7, 202, 57, 527, 1),
(448, 'lucario', 448, 12, 540, 184, 528, 1),
(449, 'hippopotas', 449, 8, 495, 66, 530, 1),
(450, 'hippowdon', 450, 20, 3000, 184, 531, 1),
(451, 'skorupi', 451, 8, 120, 66, 532, 1),
(452, 'drapion', 452, 13, 615, 175, 533, 1),
(453, 'croagunk', 453, 7, 230, 60, 534, 1),
(454, 'toxicroak', 454, 13, 444, 172, 535, 1),
(455, 'carnivine', 455, 14, 270, 159, 536, 1),
(456, 'finneon', 456, 4, 70, 66, 537, 1),
(457, 'lumineon', 457, 12, 240, 161, 538, 1),
(458, 'mantyke', 458, 10, 650, 69, 283, 1),
(459, 'snover', 459, 10, 505, 67, 539, 1),
(460, 'abomasnow', 460, 22, 1355, 173, 540, 1),
(461, 'weavile', 461, 11, 340, 179, 271, 1),
(462, 'magnezone', 462, 12, 1800, 241, 104, 1),
(463, 'lickilicky', 463, 17, 1400, 180, 136, 1),
(464, 'rhyperior', 464, 24, 2828, 241, 141, 1),
(465, 'tangrowth', 465, 20, 1286, 187, 146, 1),
(466, 'electivire', 466, 18, 1386, 243, 165, 1),
(467, 'magmortar', 467, 16, 680, 243, 168, 1),
(468, 'togekiss', 468, 15, 380, 245, 228, 1),
(469, 'yanmega', 469, 19, 515, 180, 248, 1),
(470, 'leafeon', 470, 10, 255, 184, 183, 1),
(471, 'glaceon', 471, 8, 259, 184, 184, 1),
(472, 'gliscor', 472, 20, 425, 179, 263, 1),
(473, 'mamoswine', 473, 25, 2910, 239, 278, 1),
(474, 'porygon-z', 474, 9, 340, 241, 188, 1),
(475, 'gallade', 475, 16, 520, 233, 339, 1),
(476, 'probopass', 476, 14, 3400, 184, 357, 1),
(477, 'dusknoir', 477, 22, 1066, 236, 429, 1),
(478, 'froslass', 478, 13, 266, 168, 438, 1),
(479, 'rotom', 479, 3, 3, 154, 542, 1),
(480, 'uxie', 480, 3, 3, 261, 548, 1),
(481, 'mesprit', 481, 3, 3, 261, 549, 1),
(482, 'azelf', 482, 3, 3, 261, 550, 1),
(483, 'dialga', 483, 54, 6830, 306, 551, 1),
(484, 'palkia', 484, 42, 3360, 306, 552, 1),
(485, 'heatran', 485, 17, 4300, 270, 553, 1),
(486, 'regigigas', 486, 37, 4200, 302, 554, 1),
(487, 'giratina-altered', 487, 45, 7500, 306, 555, 1),
(488, 'cresselia', 488, 15, 856, 270, 557, 1),
(489, 'phione', 489, 4, 31, 216, 558, 1),
(490, 'manaphy', 490, 3, 14, 270, 559, 1),
(491, 'darkrai', 491, 15, 505, 270, 560, 1),
(492, 'shaymin-land', 492, 2, 21, 270, 561, 1),
(493, 'arceus', 493, 32, 3200, 324, 563, 1),
(494, 'victini', 494, 4, 40, 270, 564, 1),
(495, 'snivy', 495, 6, 81, 62, 565, 1),
(496, 'servine', 496, 8, 160, 145, 566, 1),
(497, 'serperior', 497, 33, 630, 238, 567, 1),
(498, 'tepig', 498, 5, 99, 62, 568, 1),
(499, 'pignite', 499, 10, 555, 146, 569, 1),
(500, 'emboar', 500, 16, 1500, 238, 570, 1),
(501, 'oshawott', 501, 5, 59, 62, 571, 1),
(502, 'dewott', 502, 8, 245, 145, 572, 1),
(503, 'samurott', 503, 15, 946, 238, 573, 1),
(504, 'patrat', 504, 5, 116, 51, 574, 1),
(505, 'watchog', 505, 11, 270, 147, 575, 1),
(506, 'lillipup', 506, 4, 41, 55, 576, 1),
(507, 'herdier', 507, 9, 147, 130, 577, 1),
(508, 'stoutland', 508, 12, 610, 225, 578, 1),
(509, 'purrloin', 509, 4, 101, 56, 579, 1),
(510, 'liepard', 510, 11, 375, 156, 580, 1),
(511, 'pansage', 511, 6, 105, 63, 581, 1),
(512, 'simisage', 512, 11, 305, 174, 582, 1),
(513, 'pansear', 513, 6, 110, 63, 583, 1),
(514, 'simisear', 514, 10, 280, 174, 584, 1),
(515, 'panpour', 515, 6, 135, 63, 585, 1),
(516, 'simipour', 516, 10, 290, 174, 586, 1),
(517, 'munna', 517, 6, 233, 58, 587, 1),
(518, 'musharna', 518, 11, 605, 170, 588, 1),
(519, 'pidove', 519, 3, 21, 53, 589, 1),
(520, 'tranquill', 520, 6, 150, 125, 590, 1),
(521, 'unfezant', 521, 12, 290, 220, 591, 1),
(522, 'blitzle', 522, 8, 298, 59, 592, 1),
(523, 'zebstrika', 523, 16, 795, 174, 593, 1),
(524, 'roggenrola', 524, 4, 180, 56, 594, 1),
(525, 'boldore', 525, 9, 1020, 137, 595, 1),
(526, 'gigalith', 526, 17, 2600, 232, 596, 1),
(527, 'woobat', 527, 4, 21, 63, 597, 1),
(528, 'swoobat', 528, 9, 105, 149, 598, 1),
(529, 'drilbur', 529, 3, 85, 66, 599, 1),
(530, 'excadrill', 530, 7, 404, 178, 600, 1),
(531, 'audino', 531, 11, 310, 390, 601, 1),
(532, 'timburr', 532, 6, 125, 61, 603, 1),
(533, 'gurdurr', 533, 12, 400, 142, 604, 1),
(534, 'conkeldurr', 534, 14, 870, 227, 605, 1),
(535, 'tympole', 535, 5, 45, 59, 606, 1),
(536, 'palpitoad', 536, 8, 170, 134, 607, 1),
(537, 'seismitoad', 537, 15, 620, 229, 608, 1),
(538, 'throh', 538, 13, 555, 163, 609, 1),
(539, 'sawk', 539, 14, 510, 163, 610, 1),
(540, 'sewaddle', 540, 3, 25, 62, 611, 1),
(541, 'swadloon', 541, 5, 73, 133, 612, 1),
(542, 'leavanny', 542, 12, 205, 225, 613, 1),
(543, 'venipede', 543, 4, 53, 52, 614, 1),
(544, 'whirlipede', 544, 12, 585, 126, 615, 1),
(545, 'scolipede', 545, 25, 2005, 218, 616, 1),
(546, 'cottonee', 546, 3, 6, 56, 617, 1),
(547, 'whimsicott', 547, 7, 66, 168, 618, 1),
(548, 'petilil', 548, 5, 66, 56, 619, 1),
(549, 'lilligant', 549, 11, 163, 168, 620, 1),
(550, 'basculin-red-striped', 550, 10, 180, 161, 621, 1),
(551, 'sandile', 551, 7, 152, 58, 623, 1),
(552, 'krokorok', 552, 10, 334, 123, 624, 1),
(553, 'krookodile', 553, 15, 963, 234, 625, 1),
(554, 'darumaka', 554, 6, 375, 63, 626, 1),
(555, 'darmanitan-standard', 555, 13, 929, 168, 627, 1),
(556, 'maractus', 556, 10, 280, 161, 629, 1),
(557, 'dwebble', 557, 3, 145, 65, 630, 1),
(558, 'crustle', 558, 14, 2000, 166, 631, 1),
(559, 'scraggy', 559, 6, 118, 70, 632, 1),
(560, 'scrafty', 560, 11, 300, 171, 633, 1),
(561, 'sigilyph', 561, 14, 140, 172, 634, 1),
(562, 'yamask', 562, 5, 15, 61, 635, 1),
(563, 'cofagrigus', 563, 17, 765, 169, 636, 1),
(564, 'tirtouga', 564, 7, 165, 71, 637, 1),
(565, 'carracosta', 565, 12, 810, 173, 638, 1),
(566, 'archen', 566, 5, 95, 71, 639, 1),
(567, 'archeops', 567, 14, 320, 177, 640, 1),
(568, 'trubbish', 568, 6, 310, 66, 641, 1),
(569, 'garbodor', 569, 19, 1073, 166, 642, 1),
(570, 'zorua', 570, 7, 125, 66, 643, 1),
(571, 'zoroark', 571, 16, 811, 179, 644, 1),
(572, 'minccino', 572, 4, 58, 60, 645, 1),
(573, 'cinccino', 573, 5, 75, 165, 646, 1),
(574, 'gothita', 574, 4, 58, 58, 647, 1),
(575, 'gothorita', 575, 7, 180, 137, 648, 1),
(576, 'gothitelle', 576, 15, 440, 221, 649, 1),
(577, 'solosis', 577, 3, 10, 58, 650, 1),
(578, 'duosion', 578, 6, 80, 130, 651, 1),
(579, 'reuniclus', 579, 10, 201, 221, 652, 1),
(580, 'ducklett', 580, 5, 55, 61, 653, 1),
(581, 'swanna', 581, 13, 242, 166, 654, 1),
(582, 'vanillite', 582, 4, 57, 61, 655, 1),
(583, 'vanillish', 583, 11, 410, 138, 656, 1),
(584, 'vanilluxe', 584, 13, 575, 241, 657, 1),
(585, 'deerling', 585, 6, 195, 67, 658, 1),
(586, 'sawsbuck', 586, 19, 925, 166, 659, 1),
(587, 'emolga', 587, 4, 50, 150, 660, 1),
(588, 'karrablast', 588, 5, 59, 63, 661, 1),
(589, 'escavalier', 589, 10, 330, 173, 662, 1),
(590, 'foongus', 590, 2, 10, 59, 663, 1),
(591, 'amoonguss', 591, 6, 105, 162, 664, 1),
(592, 'frillish', 592, 12, 330, 67, 665, 1),
(593, 'jellicent', 593, 22, 1350, 168, 666, 1),
(594, 'alomomola', 594, 12, 316, 165, 667, 1),
(595, 'joltik', 595, 1, 6, 64, 668, 1),
(596, 'galvantula', 596, 8, 143, 165, 669, 1),
(597, 'ferroseed', 597, 6, 188, 61, 670, 1),
(598, 'ferrothorn', 598, 10, 1100, 171, 671, 1),
(599, 'klink', 599, 3, 210, 60, 672, 1),
(600, 'klang', 600, 6, 510, 154, 673, 1),
(601, 'klinklang', 601, 6, 810, 234, 674, 1),
(602, 'tynamo', 602, 2, 3, 55, 675, 1),
(603, 'eelektrik', 603, 12, 220, 142, 676, 1),
(604, 'eelektross', 604, 21, 805, 232, 677, 1),
(605, 'elgyem', 605, 5, 90, 67, 678, 1),
(606, 'beheeyem', 606, 10, 345, 170, 679, 1),
(607, 'litwick', 607, 3, 31, 55, 680, 1),
(608, 'lampent', 608, 6, 130, 130, 681, 1),
(609, 'chandelure', 609, 10, 343, 234, 682, 1),
(610, 'axew', 610, 6, 180, 64, 683, 1),
(611, 'fraxure', 611, 10, 360, 144, 684, 1),
(612, 'haxorus', 612, 18, 1055, 243, 685, 1),
(613, 'cubchoo', 613, 5, 85, 61, 686, 1),
(614, 'beartic', 614, 26, 2600, 170, 687, 1),
(615, 'cryogonal', 615, 11, 1480, 170, 688, 1),
(616, 'shelmet', 616, 4, 77, 61, 689, 1),
(617, 'accelgor', 617, 8, 253, 173, 690, 1),
(618, 'stunfisk', 618, 7, 110, 165, 691, 1),
(619, 'mienfoo', 619, 9, 200, 70, 692, 1),
(620, 'mienshao', 620, 14, 355, 179, 693, 1),
(621, 'druddigon', 621, 16, 1390, 170, 694, 1),
(622, 'golett', 622, 10, 920, 61, 695, 1),
(623, 'golurk', 623, 28, 3300, 169, 696, 1),
(624, 'pawniard', 624, 5, 102, 68, 697, 1),
(625, 'bisharp', 625, 16, 700, 172, 698, 1),
(626, 'bouffalant', 626, 16, 946, 172, 699, 1),
(627, 'rufflet', 627, 5, 105, 70, 700, 1),
(628, 'braviary', 628, 15, 410, 179, 701, 1),
(629, 'vullaby', 629, 5, 90, 74, 702, 1),
(630, 'mandibuzz', 630, 12, 395, 179, 703, 1),
(631, 'heatmor', 631, 14, 580, 169, 704, 1),
(632, 'durant', 632, 3, 330, 169, 705, 1),
(633, 'deino', 633, 8, 173, 60, 706, 1),
(634, 'zweilous', 634, 14, 500, 147, 707, 1),
(635, 'hydreigon', 635, 18, 1600, 270, 708, 1),
(636, 'larvesta', 636, 11, 288, 72, 709, 1),
(637, 'volcarona', 637, 16, 460, 248, 710, 1),
(638, 'cobalion', 638, 21, 2500, 261, 711, 1),
(639, 'terrakion', 639, 19, 2600, 261, 712, 1),
(640, 'virizion', 640, 20, 2000, 261, 713, 1),
(641, 'tornadus-incarnate', 641, 15, 630, 261, 714, 1),
(642, 'thundurus-incarnate', 642, 15, 610, 261, 716, 1),
(643, 'reshiram', 643, 32, 3300, 306, 718, 1),
(644, 'zekrom', 644, 29, 3450, 306, 719, 1),
(645, 'landorus-incarnate', 645, 15, 680, 270, 720, 1),
(646, 'kyurem', 646, 30, 3250, 297, 722, 1),
(647, 'keldeo-ordinary', 647, 14, 485, 261, 725, 1),
(648, 'meloetta-aria', 648, 6, 65, 270, 727, 1),
(649, 'genesect', 649, 15, 825, 270, 729, 1),
(650, 'chespin', 650, 4, 90, 63, 730, 1),
(651, 'quilladin', 651, 7, 290, 142, 731, 1),
(652, 'chesnaught', 652, 16, 900, 239, 732, 1),
(653, 'fennekin', 653, 4, 94, 61, 733, 1),
(654, 'braixen', 654, 10, 145, 143, 734, 1),
(655, 'delphox', 655, 15, 390, 240, 735, 1),
(656, 'froakie', 656, 3, 70, 63, 736, 1),
(657, 'frogadier', 657, 6, 109, 142, 737, 1),
(658, 'greninja', 658, 15, 400, 239, 738, 1),
(659, 'bunnelby', 659, 4, 50, 47, 739, 1),
(660, 'diggersby', 660, 10, 424, 148, 740, 1),
(661, 'fletchling', 661, 3, 17, 56, 741, 1),
(662, 'fletchinder', 662, 7, 160, 134, 742, 1),
(663, 'talonflame', 663, 12, 245, 175, 743, 1),
(664, 'scatterbug', 664, 3, 25, 40, 744, 1),
(665, 'spewpa', 665, 3, 84, 75, 745, 1),
(666, 'vivillon', 666, 12, 170, 185, 746, 1),
(667, 'litleo', 667, 6, 135, 74, 747, 1),
(668, 'pyroar', 668, 15, 815, 177, 748, 1),
(669, 'flabebe', 669, 1, 1, 61, 749, 1),
(670, 'floette', 670, 2, 9, 130, 750, 1),
(671, 'florges', 671, 11, 100, 248, 752, 1),
(672, 'skiddo', 672, 9, 310, 70, 753, 1),
(673, 'gogoat', 673, 17, 910, 186, 754, 1),
(674, 'pancham', 674, 6, 80, 70, 755, 1),
(675, 'pangoro', 675, 21, 1360, 173, 756, 1),
(676, 'furfrou', 676, 12, 280, 165, 757, 1),
(677, 'espurr', 677, 3, 35, 71, 758, 1),
(678, 'meowstic-male', 678, 6, 85, 163, 759, 1),
(679, 'honedge', 679, 8, 20, 65, 761, 1),
(680, 'doublade', 680, 8, 45, 157, 762, 1),
(681, 'aegislash-shield', 681, 17, 530, 234, 763, 1),
(682, 'spritzee', 682, 2, 5, 68, 765, 1),
(683, 'aromatisse', 683, 8, 155, 162, 766, 1),
(684, 'swirlix', 684, 4, 35, 68, 767, 1),
(685, 'slurpuff', 685, 8, 50, 168, 768, 1),
(686, 'inkay', 686, 4, 35, 58, 769, 1),
(687, 'malamar', 687, 15, 470, 169, 770, 1),
(688, 'binacle', 688, 5, 310, 61, 771, 1),
(689, 'barbaracle', 689, 13, 960, 175, 772, 1),
(690, 'skrelp', 690, 5, 73, 64, 773, 1),
(691, 'dragalge', 691, 18, 815, 173, 774, 1),
(692, 'clauncher', 692, 5, 83, 66, 775, 1),
(693, 'clawitzer', 693, 13, 353, 100, 776, 1),
(694, 'helioptile', 694, 5, 60, 58, 777, 1),
(695, 'heliolisk', 695, 10, 210, 168, 778, 1),
(696, 'tyrunt', 696, 8, 260, 72, 779, 1),
(697, 'tyrantrum', 697, 25, 2700, 182, 780, 1),
(698, 'amaura', 698, 13, 252, 72, 781, 1),
(699, 'aurorus', 699, 27, 2250, 104, 782, 1),
(700, 'sylveon', 700, 10, 235, 184, 185, 1),
(701, 'hawlucha', 701, 8, 215, 175, 783, 1),
(702, 'dedenne', 702, 2, 22, 151, 784, 1),
(703, 'carbink', 703, 3, 57, 100, 785, 1),
(704, 'goomy', 704, 3, 28, 60, 786, 1),
(705, 'sliggoo', 705, 8, 175, 158, 787, 1),
(706, 'goodra', 706, 20, 1505, 270, 788, 1),
(707, 'klefki', 707, 2, 30, 165, 789, 1),
(708, 'phantump', 708, 4, 70, 62, 790, 1),
(709, 'trevenant', 709, 15, 710, 166, 791, 1),
(710, 'pumpkaboo-average', 710, 4, 50, 67, 793, 1),
(711, 'gourgeist-average', 711, 9, 125, 173, 797, 1),
(712, 'bergmite', 712, 10, 995, 61, 800, 1),
(713, 'avalugg', 713, 20, 5050, 180, 801, 1),
(714, 'noibat', 714, 5, 80, 49, 802, 1),
(715, 'noivern', 715, 15, 850, 187, 803, 1),
(716, 'xerneas', 716, 30, 2150, 306, 804, 1),
(717, 'yveltal', 717, 58, 2030, 306, 805, 1),
(718, 'zygarde', 718, 50, 3050, 270, 806, 1),
(719, 'diancie', 719, 7, 88, 270, 807, 1),
(720, 'hoopa', 720, 5, 90, 270, 809, 1),
(721, 'volcanion', 721, 17, 1950, 270, 811, 1),
(10001, 'deoxys-attack', 386, 17, 608, 270, 470, 0),
(10002, 'deoxys-defense', 386, 17, 608, 270, 471, 0),
(10003, 'deoxys-speed', 386, 17, 608, 270, 472, 0),
(10004, 'wormadam-sandy', 413, 5, 65, 148, 498, 0),
(10005, 'wormadam-trash', 413, 5, 65, 148, 499, 0),
(10006, 'shaymin-sky', 492, 4, 52, 270, 562, 0),
(10007, 'giratina-origin', 487, 69, 6500, 306, 556, 0),
(10008, 'rotom-heat', 479, 3, 3, 182, 543, 0),
(10009, 'rotom-wash', 479, 3, 3, 182, 544, 0),
(10010, 'rotom-frost', 479, 3, 3, 182, 545, 0),
(10011, 'rotom-fan', 479, 3, 3, 182, 546, 0),
(10012, 'rotom-mow', 479, 3, 3, 182, 547, 0),
(10013, 'castform-sunny', 351, 3, 8, 147, 420, 0),
(10014, 'castform-rainy', 351, 3, 8, 147, 421, 0),
(10015, 'castform-snowy', 351, 3, 8, 147, 422, 0),
(10016, 'basculin-blue-striped', 550, 10, 180, 161, 622, 0),
(10017, 'darmanitan-zen', 555, 13, 929, 189, 628, 0),
(10018, 'meloetta-pirouette', 648, 6, 65, 270, 728, 0),
(10019, 'tornadus-therian', 641, 14, 630, 261, 715, 0),
(10020, 'thundurus-therian', 642, 30, 610, 261, 717, 0),
(10021, 'landorus-therian', 645, 13, 680, 270, 721, 0),
(10022, 'kyurem-black', 646, 33, 3250, 315, 723, 0),
(10023, 'kyurem-white', 646, 36, 3250, 315, 724, 0),
(10024, 'keldeo-resolute', 647, 14, 485, 261, 726, 0),
(10025, 'meowstic-female', 678, 6, 85, 163, 760, 0),
(10026, 'aegislash-blade', 681, 17, 530, 234, 764, 0),
(10027, 'pumpkaboo-small', 710, 3, 35, 67, 792, 0),
(10028, 'pumpkaboo-large', 710, 5, 75, 67, 794, 0),
(10029, 'pumpkaboo-super', 710, 8, 150, 67, 795, 0),
(10030, 'gourgeist-small', 711, 7, 95, 173, 796, 0),
(10031, 'gourgeist-large', 711, 11, 140, 173, 798, 0),
(10032, 'gourgeist-super', 711, 17, 390, 173, 799, 0),
(10033, 'venusaur-mega', 3, 24, 1555, 281, 4, 0),
(10034, 'charizard-mega-x', 6, 17, 1105, 285, 8, 0),
(10035, 'charizard-mega-y', 6, 17, 1005, 285, 9, 0),
(10036, 'blastoise-mega', 9, 16, 1011, 284, 13, 0),
(10037, 'alakazam-mega', 65, 12, 480, 266, 84, 0),
(10038, 'gengar-mega', 94, 14, 405, 270, 117, 0),
(10039, 'kangaskhan-mega', 115, 22, 1000, 207, 148, 0),
(10040, 'pinsir-mega', 127, 17, 590, 210, 170, 0),
(10041, 'gyarados-mega', 130, 65, 3050, 224, 174, 0),
(10042, 'aerodactyl-mega', 142, 21, 790, 215, 194, 0),
(10043, 'mewtwo-mega-x', 150, 23, 1270, 351, 204, 0),
(10044, 'mewtwo-mega-y', 150, 15, 330, 351, 205, 0),
(10045, 'ampharos-mega', 181, 14, 615, 275, 234, 0),
(10046, 'scizor-mega', 212, 20, 1250, 210, 160, 0),
(10047, 'heracross-mega', 214, 17, 625, 210, 269, 0),
(10048, 'houndoom-mega', 229, 19, 495, 210, 288, 0),
(10049, 'tyranitar-mega', 248, 25, 2550, 315, 300, 0),
(10050, 'blaziken-mega', 257, 19, 520, 284, 311, 0),
(10051, 'gardevoir-mega', 282, 16, 484, 278, 338, 0),
(10052, 'mawile-mega', 303, 10, 235, 168, 363, 0),
(10053, 'aggron-mega', 306, 22, 3950, 284, 367, 0),
(10054, 'medicham-mega', 308, 13, 315, 179, 370, 0),
(10055, 'manectric-mega', 310, 18, 440, 201, 373, 0),
(10056, 'banette-mega', 354, 12, 130, 194, 426, 0),
(10057, 'absol-mega', 359, 12, 490, 198, 434, 0),
(10058, 'garchomp-mega', 445, 19, 950, 315, 526, 0),
(10059, 'lucario-mega', 448, 13, 575, 219, 529, 0),
(10060, 'abomasnow-mega', 460, 27, 1850, 208, 541, 0),
(10061, 'floette-eternal', 670, 2, 9, 243, 751, 0),
(10062, 'latias-mega', 380, 18, 520, 315, 459, 0),
(10063, 'latios-mega', 381, 23, 700, 315, 461, 0),
(10064, 'swampert-mega', 260, 19, 1020, 286, 315, 0),
(10065, 'sceptile-mega', 254, 19, 552, 284, 307, 0),
(10066, 'sableye-mega', 302, 5, 1610, 168, 361, 0),
(10067, 'altaria-mega', 334, 15, 206, 207, 402, 0),
(10068, 'gallade-mega', 475, 16, 564, 278, 340, 0),
(10069, 'audino-mega', 531, 15, 320, 425, 602, 0),
(10070, 'sharpedo-mega', 319, 25, 1303, 196, 385, 0),
(10071, 'slowbro-mega', 80, 20, 1200, 207, 100, 0),
(10072, 'steelix-mega', 208, 105, 7400, 214, 120, 0),
(10073, 'pidgeot-mega', 18, 22, 505, 261, 24, 0),
(10074, 'glalie-mega', 362, 21, 3502, 203, 437, 0),
(10075, 'diancie-mega', 719, 11, 278, 315, 808, 0),
(10076, 'metagross-mega', 376, 25, 9429, 315, 454, 0),
(10077, 'kyogre-primal', 382, 98, 4300, 347, 463, 0),
(10078, 'groudon-primal', 383, 50, 9997, 347, 465, 0),
(10079, 'rayquaza-mega', 384, 108, 3920, 351, 467, 0),
(10080, 'pikachu-rock-star', 25, 4, 60, 112, 34, 0),
(10081, 'pikachu-belle', 25, 4, 60, 112, 35, 0),
(10082, 'pikachu-pop-star', 25, 4, 60, 112, 36, 0),
(10083, 'pikachu-phd', 25, 4, 60, 112, 37, 0),
(10084, 'pikachu-libre', 25, 4, 60, 112, 38, 0),
(10085, 'pikachu-cosplay', 25, 4, 60, 112, 33, 0),
(10086, 'hoopa-unbound', 720, 65, 4900, 306, 810, 0),
(10087, 'camerupt-mega', 323, 25, 3205, 196, 390, 0),
(10088, 'lopunny-mega', 428, 13, 283, 203, 514, 0),
(10089, 'salamence-mega', 373, 18, 1126, 315, 450, 0),
(10090, 'beedrill-mega', 15, 14, 405, 223, 20, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `pokemon`
--
ALTER TABLE `pokemon`
  ADD PRIMARY KEY (`id`);
--
-- Database: `snackplace`
--
CREATE DATABASE IF NOT EXISTS `snackplace` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `snackplace`;

-- --------------------------------------------------------

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `name` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `name`) VALUES
(1, 'Fries'),
(2, 'Snack'),
(3, 'Sauce');

-- --------------------------------------------------------

--
-- Table structure for table `logentry`
--

CREATE TABLE `logentry` (
  `id` int(11) NOT NULL,
  `message` varchar(1024) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logentry`
--

INSERT INTO `logentry` (`id`, `message`) VALUES
(1, '0:0:0:0:0:0:0:1 requested /home.do'),
(2, '0:0:0:0:0:0:0:1 requested /selectProduct.do'),
(3, '0:0:0:0:0:0:0:1 requested /addProduct.do'),
(4, '0:0:0:0:0:0:0:1 requested /selectProduct.do'),
(5, '0:0:0:0:0:0:0:1 requested /addProduct.do'),
(6, '0:0:0:0:0:0:0:1 requested /checkout.do'),
(7, '0:0:0:0:0:0:0:1 requested /home.do');

-- --------------------------------------------------------

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `name` varchar(45) NOT NULL,
  `price` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`id`, `category_id`, `name`, `price`) VALUES
(1, 1, 'Small fries', 1.75),
(2, 1, 'Medium fries', 2.25),
(3, 1, 'Large fries', 2.75),
(4, 2, 'Hamburger', 2.5),
(5, 2, 'Cheeseburger', 2.75),
(6, 2, 'Vegetarian burger', 2.5),
(7, 2, 'Hot dog', 2.25),
(8, 3, 'Mayonnaise', 0.5),
(9, 3, 'Ketchup', 0.5),
(10, 3, 'Garlic sauce', 0.5);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `logentry`
--
ALTER TABLE `logentry`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product`
--
ALTER TABLE `product`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `logentry`
--
ALTER TABLE `logentry`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;