BKhKhF75

1-- MySQL Script generated by MySQL Workbench
2-- Tue Jan 29 14:27:58 2019
3-- Model: New Model    Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema popupplazz
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema popupplazz
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `popupplazz` DEFAULT CHARACTER SET utf8 ;
18USE `popupplazz` ;
19
20-- -----------------------------------------------------
21-- Table `popupplazz`.`data`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `popupplazz`.`data` (
24  `id` INT NOT NULL AUTO_INCREMENT,
25  `straat` VARCHAR(218) NOT NULL,
26  `straatnummer` INT NOT NULL,
27  `voorbijgangers` INT NOT NULL,
28  `prijs` INT NOT NULL,
29  `aantalEventsDichtbij` INT NOT NULL,
30  PRIMARY KEY (`id`))
31ENGINE = InnoDB;
32
33
34SET SQL_MODE=@OLD_SQL_MODE;
35SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
36SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;