Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.6.4
- -- https://www.phpmyadmin.net/
- --
- -- Host: localhost:8889
- -- Generation Time: May 24, 2017 at 04:10 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;
- -- --------------------------------------------------------
- --
- -- 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;
- -- --------------------------------------------------------
- --
- -- 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;
- -- --------------------------------------------------------
- --
- -- 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;
- -- --------------------------------------------------------
- --
- -- 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=33;
- --
- -- AUTO_INCREMENT for table `events`
- --
- ALTER TABLE `events`
- MODIFY `event_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;
- --
- -- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement