qfvUszsp

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 loc_omroep
9-- -----------------------------------------------------
10-- -----------------------------------------------------
11-- Schema l_omroep
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema l_omroep
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `l_omroep` DEFAULT CHARACTER SET latin1 ;
18USE `l_omroep` ;
19
20-- -----------------------------------------------------
21-- Table `l_omroep`.`soort`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `l_omroep`.`soort` (
24  `soortcode` INT(11) NOT NULL AUTO_INCREMENT,
25  `soortomschrijving` VARCHAR(50) NOT NULL,
26  PRIMARY KEY (`soortcode`))
27ENGINE = MyISAM
28DEFAULT CHARACTER SET = latin1;
29
30
31-- -----------------------------------------------------
32-- Table `l_omroep`.`liedje`
33-- -----------------------------------------------------
34CREATE TABLE IF NOT EXISTS `l_omroep`.`liedje` (
35  `code` INT NOT NULL AUTO_INCREMENT,
36  `titel` VARCHAR(45) NOT NULL,
37  `artiest` VARCHAR(45) NOT NULL,
38  `soortcode` INT(11) NOT NULL,
39  PRIMARY KEY (`code`),
40  INDEX `fk_liedje_soort_idx` (`soortcode` ASC))
41ENGINE = MyISAM
42DEFAULT CHARACTER SET = latin1;
43
44
45-- -----------------------------------------------------
46-- Table `l_omroep`.`overzicht`
47-- -----------------------------------------------------
48CREATE TABLE IF NOT EXISTS `l_omroep`.`overzicht` (
49  `idOverzicht` INT(11) NOT NULL AUTO_INCREMENT,
50  `datum` VARCHAR(50) NOT NULL,
51  `dj` VARCHAR(50) NOT NULL,
52  PRIMARY KEY (`idOverzicht`))
53ENGINE = MyISAM
54DEFAULT CHARACTER SET = latin1;
55
56
57-- -----------------------------------------------------
58-- Table `l_omroep`.`overzichtlied`
59-- -----------------------------------------------------
60CREATE TABLE IF NOT EXISTS `l_omroep`.`overzichtlied` (
61  `idOverzicht` INT(11) NOT NULL,
62  `tijd` VARCHAR(45) NOT NULL,
63  `code` INT NOT NULL,
64  PRIMARY KEY (`idOverzicht`, `tijd`),
65  INDEX `fk_overzicht_has_liedje_overzicht1_idx` (`idOverzicht` ASC),
66  INDEX `fk_overzichtlied_liedje1_idx` (`code` ASC))
67ENGINE = MyISAM
68DEFAULT CHARACTER SET = latin1;
69
70
71SET SQL_MODE=@OLD_SQL_MODE;
72SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
73SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;