· 9 years ago · Nov 18, 2016, 01:34 PM
1-- MySQL Script generated by MySQL Workbench
2-- 11/18/16 14:17:55
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 mydb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`table1`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`table1` (
24)
25ENGINE = InnoDB;
26
27
28-- -----------------------------------------------------
29-- Table `mydb`.`klanten`
30-- -----------------------------------------------------
31CREATE TABLE IF NOT EXISTS `mydb`.`klanten` (
32 `id` INT(11) NOT NULL,
33 `inlognaam` VARCHAR(50) NULL DEFAULT NULL,
34 `email` VARCHAR(255) NULL DEFAULT NULL,
35 `intialen` VARCHAR(5) NULL DEFAULT NULL,
36 `tussenvoegsel` VARCHAR(10) NULL DEFAULT NULL,
37 `achternaam` VARCHAR(255) NULL DEFAULT NULL,
38 `wachtwoord` VARCHAR(255) NULL DEFAULT NULL,
39 `woonadres` VARCHAR(255) NULL DEFAULT NULL,
40 `Huisnummer` VARCHAR(10) NULL DEFAULT NULL,
41 `postcode` VARCHAR(6) NULL DEFAULT NULL,
42 `telefoonnummer` VARCHAR(20) NULL DEFAULT NULL,
43 PRIMARY KEY (`id`))
44ENGINE = InnoDB
45DEFAULT CHARACTER SET = latin1;
46
47
48-- -----------------------------------------------------
49-- Table `mydb`.`bezorginformatie`
50-- -----------------------------------------------------
51CREATE TABLE IF NOT EXISTS `mydb`.`bezorginformatie` (
52 `id` INT(11) NOT NULL,
53 `adres` VARCHAR(255) NULL DEFAULT NULL,
54 `huisnummer` VARCHAR(10) NULL DEFAULT NULL,
55 `postcode` VARCHAR(6) NULL DEFAULT NULL,
56 PRIMARY KEY (`id`))
57ENGINE = InnoDB
58DEFAULT CHARACTER SET = latin1;
59
60
61-- -----------------------------------------------------
62-- Table `mydb`.`bestelkaart`
63-- -----------------------------------------------------
64CREATE TABLE IF NOT EXISTS `mydb`.`bestelkaart` (
65 `id` INT(11) NOT NULL,
66 `bezorger_id` INT(11) NULL DEFAULT NULL,
67 `tijdstip` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
68 `klanten_id` INT(11) NOT NULL,
69 `bezorginformatie_id` INT(11) NOT NULL,
70 PRIMARY KEY (`id`, `klanten_id`, `bezorginformatie_id`),
71 INDEX `fk_bestelkaart_klanten1_idx` (`klanten_id` ASC),
72 INDEX `fk_bestelkaart_bezorginformatie1_idx` (`bezorginformatie_id` ASC),
73 CONSTRAINT `fk_bestelkaart_klanten1`
74 FOREIGN KEY (`klanten_id`)
75 REFERENCES `mydb`.`klanten` (`id`)
76 ON DELETE NO ACTION
77 ON UPDATE NO ACTION,
78 CONSTRAINT `fk_bestelkaart_bezorginformatie1`
79 FOREIGN KEY (`bezorginformatie_id`)
80 REFERENCES `mydb`.`bezorginformatie` (`id`)
81 ON DELETE NO ACTION
82 ON UPDATE NO ACTION)
83ENGINE = InnoDB
84DEFAULT CHARACTER SET = latin1;
85
86
87-- -----------------------------------------------------
88-- Table `mydb`.`afleverlijst`
89-- -----------------------------------------------------
90CREATE TABLE IF NOT EXISTS `mydb`.`afleverlijst` (
91 `id` INT(11) NOT NULL,
92 `opmerkingen` TEXT NULL DEFAULT NULL,
93 `bestelkaart_id` INT(11) NOT NULL,
94 PRIMARY KEY (`id`, `bestelkaart_id`),
95 INDEX `fk_afleverlijst_bestelkaart1_idx` (`bestelkaart_id` ASC),
96 CONSTRAINT `fk_afleverlijst_bestelkaart1`
97 FOREIGN KEY (`bestelkaart_id`)
98 REFERENCES `mydb`.`bestelkaart` (`id`)
99 ON DELETE NO ACTION
100 ON UPDATE NO ACTION)
101ENGINE = InnoDB
102DEFAULT CHARACTER SET = latin1;
103
104
105-- -----------------------------------------------------
106-- Table `mydb`.`producten`
107-- -----------------------------------------------------
108CREATE TABLE IF NOT EXISTS `mydb`.`producten` (
109 `id` INT(11) NOT NULL,
110 `naam` VARCHAR(255) NULL DEFAULT NULL,
111 `producent` VARCHAR(255) NULL DEFAULT NULL,
112 `prijs` INT(11) NULL DEFAULT NULL,
113 `schapnummer` INT(11) NULL DEFAULT NULL,
114 `Voorraad` INT(5) NULL DEFAULT NULL,
115 PRIMARY KEY (`id`))
116ENGINE = InnoDB
117DEFAULT CHARACTER SET = latin1;
118
119
120-- -----------------------------------------------------
121-- Table `mydb`.`besteldeproducten`
122-- -----------------------------------------------------
123CREATE TABLE IF NOT EXISTS `mydb`.`besteldeproducten` (
124 `id` INT(11) NOT NULL,
125 `hoeveelheid` INT(2) NULL DEFAULT NULL,
126 `producten_id` INT(11) NOT NULL,
127 `bestelkaart_id` INT(11) NOT NULL,
128 PRIMARY KEY (`id`, `producten_id`, `bestelkaart_id`),
129 INDEX `fk_besteldeproducten_producten_idx` (`producten_id` ASC),
130 INDEX `fk_besteldeproducten_bestelkaart1_idx` (`bestelkaart_id` ASC),
131 CONSTRAINT `fk_besteldeproducten_producten`
132 FOREIGN KEY (`producten_id`)
133 REFERENCES `mydb`.`producten` (`id`)
134 ON DELETE NO ACTION
135 ON UPDATE NO ACTION,
136 CONSTRAINT `fk_besteldeproducten_bestelkaart1`
137 FOREIGN KEY (`bestelkaart_id`)
138 REFERENCES `mydb`.`bestelkaart` (`id`)
139 ON DELETE NO ACTION
140 ON UPDATE NO ACTION)
141ENGINE = InnoDB
142DEFAULT CHARACTER SET = latin1;
143
144
145-- -----------------------------------------------------
146-- Table `mydb`.`onbetaalde_bestellingen`
147-- -----------------------------------------------------
148CREATE TABLE IF NOT EXISTS `mydb`.`onbetaalde_bestellingen` (
149 `id` INT(11) NOT NULL,
150 `bestelkaart_id` INT(11) NOT NULL,
151 PRIMARY KEY (`id`, `bestelkaart_id`),
152 INDEX `fk_onbetaalde_bestellingen_bestelkaart1_idx` (`bestelkaart_id` ASC),
153 CONSTRAINT `fk_onbetaalde_bestellingen_bestelkaart1`
154 FOREIGN KEY (`bestelkaart_id`)
155 REFERENCES `mydb`.`bestelkaart` (`id`)
156 ON DELETE NO ACTION
157 ON UPDATE NO ACTION)
158ENGINE = InnoDB
159DEFAULT CHARACTER SET = latin1;
160
161
162-- -----------------------------------------------------
163-- Table `mydb`.`paklijst`
164-- -----------------------------------------------------
165CREATE TABLE IF NOT EXISTS `mydb`.`paklijst` (
166 `id` INT(11) NOT NULL,
167 `inpakker_naam` VARCHAR(255) NULL DEFAULT NULL,
168 `bestelkaart_id` INT(11) NOT NULL,
169 PRIMARY KEY (`id`, `bestelkaart_id`),
170 INDEX `fk_paklijst_bestelkaart1_idx` (`bestelkaart_id` ASC),
171 CONSTRAINT `fk_paklijst_bestelkaart1`
172 FOREIGN KEY (`bestelkaart_id`)
173 REFERENCES `mydb`.`bestelkaart` (`id`)
174 ON DELETE NO ACTION
175 ON UPDATE NO ACTION)
176ENGINE = InnoDB
177DEFAULT CHARACTER SET = latin1;
178
179
180SET SQL_MODE=@OLD_SQL_MODE;
181SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
182SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;