L030p1VC

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema wimTestDb
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema wimTestDb
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `wimTestDb` DEFAULT CHARACTER SET utf8 ;
15USE `wimTestDb` ;
16
17-- -----------------------------------------------------
18-- Table `wimTestDb`.`Overzichten`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `wimTestDb`.`Overzichten` (
21  `idOverzichten` INT NOT NULL,
22  `idNummer` INT NOT NULL,
23  `Tijdstip` VARCHAR(45) NOT NULL,
24  PRIMARY KEY (`idOverzichten`))
25ENGINE = InnoDB;
26
27
28-- -----------------------------------------------------
29-- Table `wimTestDb`.`Soorten`
30-- -----------------------------------------------------
31CREATE TABLE IF NOT EXISTS `wimTestDb`.`Soorten` (
32  `idSoorten` INT NOT NULL,
33  `idNummer` INT NOT NULL,
34  `SoortNummer` VARCHAR(45) NOT NULL,
35  PRIMARY KEY (`idSoorten`))
36ENGINE = InnoDB;
37
38
39-- -----------------------------------------------------
40-- Table `wimTestDb`.`Liedjes`
41-- -----------------------------------------------------
42CREATE TABLE IF NOT EXISTS `wimTestDb`.`Liedjes` (
43  `idLiedjes` INT NOT NULL,
44  `LiedjeNaam` VARCHAR(45) NULL,
45  PRIMARY KEY (`idLiedjes`))
46ENGINE = InnoDB;
47
48
49SET SQL_MODE=@OLD_SQL_MODE;
50SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
51SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;