8R0qHVTF

1-- MySQL Script generated by MySQL Workbench
2-- 12/15/16 18:23:48
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-- Table `klant`
16-- -----------------------------------------------------
17DROP TABLE IF EXISTS `klant` ;
18
19CREATE TABLE IF NOT EXISTS `klant` (
20  `klantID` VARCHAR(25) NOT NULL,
21  `naam` VARCHAR(45) NOT NULL,
22  `telefoonnummer` VARCHAR(45) NOT NULL,
23  `postadres` VARCHAR(45) NOT NULL,
24  `jaaromzet` INT NOT NULL,
25  `emailadres` VARCHAR(45) NULL,
26  PRIMARY KEY (`klantID`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `factuur`
32-- -----------------------------------------------------
33DROP TABLE IF EXISTS `factuur` ;
34
35CREATE TABLE IF NOT EXISTS `factuur` (
36  `factuurID` VARCHAR(25) NOT NULL,
37  `klantID` VARCHAR(25) NOT NULL,
38  `totale_prijs` DOUBLE NOT NULL,
39  `datum` DATE NOT NULL,
40  `korting_percentage` INT NOT NULL,
41  PRIMARY KEY (`factuurID`),
42  INDEX `fk_factuur_klant_idx` (`klantID` ASC),
43  CONSTRAINT `fk_factuur_klant`
44    FOREIGN KEY (`klantID`)
45    REFERENCES `klant` (`klantID`)
46    ON DELETE NO ACTION
47    ON UPDATE NO ACTION)
48ENGINE = InnoDB;
49
50
51-- -----------------------------------------------------
52-- Table `orders`
53-- -----------------------------------------------------
54DROP TABLE IF EXISTS `orders` ;
55
56CREATE TABLE IF NOT EXISTS `orders` (
57  `orderID` VARCHAR(25) NOT NULL,
58  `klantID` VARCHAR(25) NOT NULL,
59  `orderstatus` VARCHAR(45) NOT NULL,
60  `datum` DATE NOT NULL,
61  `is_betaald` TINYINT(1) NOT NULL,
62  `totale_prijs` DOUBLE NOT NULL,
63  `korting_percentage` INT NOT NULL,
64  PRIMARY KEY (`orderID`),
65  INDEX `fk_order_klant1_idx` (`klantID` ASC),
66  CONSTRAINT `fk_order_klant1`
67    FOREIGN KEY (`klantID`)
68    REFERENCES `klant` (`klantID`)
69    ON DELETE NO ACTION
70    ON UPDATE NO ACTION)
71ENGINE = InnoDB;
72
73
74-- -----------------------------------------------------
75-- Table `robot`
76-- -----------------------------------------------------
77DROP TABLE IF EXISTS `robot` ;
78
79CREATE TABLE IF NOT EXISTS `robot` (
80  `robotID` VARCHAR(25) NOT NULL,
81  `gang` INT NOT NULL,
82  PRIMARY KEY (`robotID`))
83ENGINE = InnoDB;
84
85
86-- -----------------------------------------------------
87-- Table `verzamelen`
88-- -----------------------------------------------------
89DROP TABLE IF EXISTS `verzamelen` ;
90
91CREATE TABLE IF NOT EXISTS `verzamelen` (
92  `orderID` VARCHAR(25) NOT NULL,
93  `robotID` VARCHAR(25) NOT NULL,
94  PRIMARY KEY (`orderID`, `robotID`),
95  INDEX `fk_order_has_robot_robot1_idx` (`robotID` ASC),
96  INDEX `fk_order_has_robot_order1_idx` (`orderID` ASC),
97  CONSTRAINT `fk_order_has_robot_order1`
98    FOREIGN KEY (`orderID`)
99    REFERENCES `orders` (`orderID`)
100    ON DELETE NO ACTION
101    ON UPDATE NO ACTION,
102  CONSTRAINT `fk_order_has_robot_robot1`
103    FOREIGN KEY (`robotID`)
104    REFERENCES `robot` (`robotID`)
105    ON DELETE NO ACTION
106    ON UPDATE NO ACTION)
107ENGINE = InnoDB;
108
109
110-- -----------------------------------------------------
111-- Table `product`
112-- -----------------------------------------------------
113DROP TABLE IF EXISTS `product` ;
114
115CREATE TABLE IF NOT EXISTS `product` (
116  `productID` VARCHAR(25) NOT NULL,
117  `naam` VARCHAR(45) NOT NULL,
118  PRIMARY KEY (`productID`))
119ENGINE = InnoDB;
120
121
122-- -----------------------------------------------------
123-- Table `bestelling`
124-- -----------------------------------------------------
125DROP TABLE IF EXISTS `bestelling` ;
126
127CREATE TABLE IF NOT EXISTS `bestelling` (
128  `orderID` VARCHAR(25) NULL,
129  `productID` VARCHAR(25) NULL,
130  `stukprijs` DOUBLE NOT NULL,
131  `hoeveelheid` INT NOT NULL,
132  PRIMARY KEY (`orderID`, `productID`),
133  INDEX `fk_order_has_product_product1_idx` (`productID` ASC),
134  INDEX `fk_order_has_product_order1_idx` (`orderID` ASC),
135  CONSTRAINT `fk_order_has_product_order1`
136    FOREIGN KEY (`orderID`)
137    REFERENCES `orders` (`orderID`)
138    ON DELETE NO ACTION
139    ON UPDATE NO ACTION,
140  CONSTRAINT `fk_order_has_product_product1`
141    FOREIGN KEY (`productID`)
142    REFERENCES `product` (`productID`)
143    ON DELETE NO ACTION
144    ON UPDATE NO ACTION)
145ENGINE = InnoDB;
146
147
148-- -----------------------------------------------------
149-- Table `leverancier`
150-- -----------------------------------------------------
151DROP TABLE IF EXISTS `leverancier` ;
152
153CREATE TABLE IF NOT EXISTS `leverancier` (
154  `kvknummer` VARCHAR(45) NOT NULL,
155  `emailadres` VARCHAR(45) NULL,
156  `adres` VARCHAR(45) NOT NULL,
157  `contactpersoon` VARCHAR(45) NOT NULL,
158  `telefoonnummer` VARCHAR(30) NOT NULL,
159  PRIMARY KEY (`kvknummer`))
160ENGINE = InnoDB;
161
162
163-- -----------------------------------------------------
164-- Table `inkoop`
165-- -----------------------------------------------------
166DROP TABLE IF EXISTS `inkoop` ;
167
168CREATE TABLE IF NOT EXISTS `inkoop` (
169  `kvknummer` VARCHAR(45) NOT NULL,
170  `productID` VARCHAR(25) NOT NULL,
171  `prijs` DOUBLE NOT NULL,
172  `aantal` INT NULL,
173  PRIMARY KEY (`kvknummer`, `productID`),
174  INDEX `fk_leverancier_has_product_product1_idx` (`productID` ASC),
175  INDEX `fk_leverancier_has_product_leverancier1_idx` (`kvknummer` ASC),
176  CONSTRAINT `fk_leverancier_has_product_leverancier1`
177    FOREIGN KEY (`kvknummer`)
178    REFERENCES `leverancier` (`kvknummer`)
179    ON DELETE NO ACTION
180    ON UPDATE NO ACTION,
181  CONSTRAINT `fk_leverancier_has_product_product1`
182    FOREIGN KEY (`productID`)
183    REFERENCES `product` (`productID`)
184    ON DELETE NO ACTION
185    ON UPDATE NO ACTION)
186ENGINE = InnoDB;
187
188
189SET SQL_MODE=@OLD_SQL_MODE;
190SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
191SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
192
193-- -----------------------------------------------------
194-- Data for table `klant`
195-- -----------------------------------------------------
196START TRANSACTION;
197INSERT INTO `klant` (`klantID`, `naam`, `telefoonnummer`, `postadres`, `jaaromzet`, `emailadres`) VALUES ('01', 'Pieter Pater', '06-78945232', 'Paterstraat 69', 151522, 'pieterpater@msn.com');
198INSERT INTO `klant` (`klantID`, `naam`, `telefoonnummer`, `postadres`, `jaaromzet`, `emailadres`) VALUES ('02', 'Peter Pan', '06-45786213', 'Panterstraat 20', 43250, 'peterpannetje@gmail.com');
199INSERT INTO `klant` (`klantID`, `naam`, `telefoonnummer`, `postadres`, `jaaromzet`, `emailadres`) VALUES ('03', 'Robin van Persie', '06-12367996', 'Tijgerlaan 11', 15554, 'rvp4life@live.nl');
200INSERT INTO `klant` (`klantID`, `naam`, `telefoonnummer`, `postadres`, `jaaromzet`, `emailadres`) VALUES ('04', 'Arjen Robben', '06-14782235', 'Olifantendorp 87', 40521, NULL);
201INSERT INTO `klant` (`klantID`, `naam`, `telefoonnummer`, `postadres`, `jaaromzet`, `emailadres`) VALUES ('05', 'Klaas Taart', '06-47851236', 'Taartenstraat 23', 3500, 'klaasappeltaart@hotmail.com');
202INSERT INTO `klant` (`klantID`, `naam`, `telefoonnummer`, `postadres`, `jaaromzet`, `emailadres`) VALUES ('06', 'Jan Beton', '06-58746547', 'Kaaststraat 123', 8084, 'jantje@hotmale.com');
203INSERT INTO `klant` (`klantID`, `naam`, `telefoonnummer`, `postadres`, `jaaromzet`, `emailadres`) VALUES ('07', 'Rick Repter', '06-12345689', 'Septerlaan 30', 2200, 'coolrickje@gmail.com');
204INSERT INTO `klant` (`klantID`, `naam`, `telefoonnummer`, `postadres`, `jaaromzet`, `emailadres`) VALUES ('08', 'Max Verstappen', '06-58624587', 'Formule 1', 8000, 'maxjenummer1@gmail.com');
205INSERT INTO `klant` (`klantID`, `naam`, `telefoonnummer`, `postadres`, `jaaromzet`, `emailadres`) VALUES ('09', 'Chin Lee', '06-59874568', 'Bamischijf 23', 15264, 'leechin@hotmail.com');
206INSERT INTO `klant` (`klantID`, `naam`, `telefoonnummer`, `postadres`, `jaaromzet`, `emailadres`) VALUES ('10', 'Tim Aflu', '0689547865', 'Timafluselaan 848', 8568, 'tim.aflu@timaflu.nl');
207
208COMMIT;
209
210
211-- -----------------------------------------------------
212-- Data for table `factuur`
213-- -----------------------------------------------------
214START TRANSACTION;
215INSERT INTO `factuur` (`factuurID`, `klantID`, `totale_prijs`, `datum`, `korting_percentage`) VALUES ('00000001', '01', 38488.64, '2016-11-17', 15);
216INSERT INTO `factuur` (`factuurID`, `klantID`, `totale_prijs`, `datum`, `korting_percentage`) VALUES ('00000002', '02', 22185.52, '2016-11-06', 15);
217INSERT INTO `factuur` (`factuurID`, `klantID`, `totale_prijs`, `datum`, `korting_percentage`) VALUES ('00000003', '03', 5476.55, '2016-12-06', 10);
218INSERT INTO `factuur` (`factuurID`, `klantID`, `totale_prijs`, `datum`, `korting_percentage`) VALUES ('00000004', '04', 16549.76, '2016-12-07', 15);
219INSERT INTO `factuur` (`factuurID`, `klantID`, `totale_prijs`, `datum`, `korting_percentage`) VALUES ('00000005', '05', 1218.60, '2016-12-01', 5);
220INSERT INTO `factuur` (`factuurID`, `klantID`, `totale_prijs`, `datum`, `korting_percentage`) VALUES ('00000006', '06', 193.80, '2016-12-07', 5);
221INSERT INTO `factuur` (`factuurID`, `klantID`, `totale_prijs`, `datum`, `korting_percentage`) VALUES ('00000007', '07', 256.50, '2016-11-12', 5);
222INSERT INTO `factuur` (`factuurID`, `klantID`, `totale_prijs`, `datum`, `korting_percentage`) VALUES ('00000008', '08', 1055.70, '2016-09-22', 5);
223INSERT INTO `factuur` (`factuurID`, `klantID`, `totale_prijs`, `datum`, `korting_percentage`) VALUES ('00000009', '09', 2052.75, '2016-12-02', 10);
224INSERT INTO `factuur` (`factuurID`, `klantID`, `totale_prijs`, `datum`, `korting_percentage`) VALUES ('00000010', '10', 450.00, '2016-08-14', 5);
225
226COMMIT;
227
228
229-- -----------------------------------------------------
230-- Data for table `orders`
231-- -----------------------------------------------------
232START TRANSACTION;
233INSERT INTO `orders` (`orderID`, `klantID`, `orderstatus`, `datum`, `is_betaald`, `totale_prijs`, `korting_percentage`) VALUES ('000001', '01', 'verzonden', '2016-11-15', true, 48110.80, 5);
234INSERT INTO `orders` (`orderID`, `klantID`, `orderstatus`, `datum`, `is_betaald`, `totale_prijs`, `korting_percentage`) VALUES ('000002', '02', 'geleverd', '2016-11-04', true, 27731.90, 5);
235INSERT INTO `orders` (`orderID`, `klantID`, `orderstatus`, `datum`, `is_betaald`, `totale_prijs`, `korting_percentage`) VALUES ('000003', '03', 'uitverkocht', '2016-12-04', true, 6443.00, 5);
236INSERT INTO `orders` (`orderID`, `klantID`, `orderstatus`, `datum`, `is_betaald`, `totale_prijs`, `korting_percentage`) VALUES ('000004', '04', 'verzonden', '2016-12-05', false, 20687.20, 5);
237INSERT INTO `orders` (`orderID`, `klantID`, `orderstatus`, `datum`, `is_betaald`, `totale_prijs`, `korting_percentage`) VALUES ('000005', '05', 'uitverkocht', '2016-11-29', true, 1354.00, 5);
238INSERT INTO `orders` (`orderID`, `klantID`, `orderstatus`, `datum`, `is_betaald`, `totale_prijs`, `korting_percentage`) VALUES ('000006', '06', 'geleverd', '2016-12-05', true, 204.00, 0);
239INSERT INTO `orders` (`orderID`, `klantID`, `orderstatus`, `datum`, `is_betaald`, `totale_prijs`, `korting_percentage`) VALUES ('000007', '07', 'geleverd', '2016-11-10', false, 270.00, 0);
240INSERT INTO `orders` (`orderID`, `klantID`, `orderstatus`, `datum`, `is_betaald`, `totale_prijs`, `korting_percentage`) VALUES ('000008', '08', 'verzonden', '2016-09-20', true, 1173.00, 5);
241INSERT INTO `orders` (`orderID`, `klantID`, `orderstatus`, `datum`, `is_betaald`, `totale_prijs`, `korting_percentage`) VALUES ('000009', '09', 'verzonden', '2016-11-30', false, 2415.00, 5);
242INSERT INTO `orders` (`orderID`, `klantID`, `orderstatus`, `datum`, `is_betaald`, `totale_prijs`, `korting_percentage`) VALUES ('000010', '10', 'geleverd', '2016-08-12', true, 500.00, 5);
243
244COMMIT;
245
246
247-- -----------------------------------------------------
248-- Data for table `robot`
249-- -----------------------------------------------------
250START TRANSACTION;
251INSERT INTO `robot` (`robotID`, `gang`) VALUES ('001', 1);
252INSERT INTO `robot` (`robotID`, `gang`) VALUES ('002', 2);
253INSERT INTO `robot` (`robotID`, `gang`) VALUES ('003', 3);
254INSERT INTO `robot` (`robotID`, `gang`) VALUES ('004', 4);
255INSERT INTO `robot` (`robotID`, `gang`) VALUES ('005', 5);
256INSERT INTO `robot` (`robotID`, `gang`) VALUES ('006', 6);
257INSERT INTO `robot` (`robotID`, `gang`) VALUES ('007', 7);
258INSERT INTO `robot` (`robotID`, `gang`) VALUES ('008', 8);
259INSERT INTO `robot` (`robotID`, `gang`) VALUES ('009', 9);
260INSERT INTO `robot` (`robotID`, `gang`) VALUES ('010', 10);
261
262COMMIT;
263
264
265-- -----------------------------------------------------
266-- Data for table `verzamelen`
267-- -----------------------------------------------------
268START TRANSACTION;
269INSERT INTO `verzamelen` (`orderID`, `robotID`) VALUES ('000001', '001');
270INSERT INTO `verzamelen` (`orderID`, `robotID`) VALUES ('000002', '002');
271INSERT INTO `verzamelen` (`orderID`, `robotID`) VALUES ('000003', '003');
272INSERT INTO `verzamelen` (`orderID`, `robotID`) VALUES ('000004', '004');
273INSERT INTO `verzamelen` (`orderID`, `robotID`) VALUES ('000005', '005');
274INSERT INTO `verzamelen` (`orderID`, `robotID`) VALUES ('000006', '006');
275INSERT INTO `verzamelen` (`orderID`, `robotID`) VALUES ('000007', '007');
276INSERT INTO `verzamelen` (`orderID`, `robotID`) VALUES ('000008', '008');
277INSERT INTO `verzamelen` (`orderID`, `robotID`) VALUES ('000009', '009');
278INSERT INTO `verzamelen` (`orderID`, `robotID`) VALUES ('000010', '010');
279
280COMMIT;
281
282
283-- -----------------------------------------------------
284-- Data for table `product`
285-- -----------------------------------------------------
286START TRANSACTION;
287INSERT INTO `product` (`productID`, `naam`) VALUES ('100058', 'paracetamol');
288INSERT INTO `product` (`productID`, `naam`) VALUES ('100049', 'vitamine c');
289INSERT INTO `product` (`productID`, `naam`) VALUES ('100064', 'melatonine');
290INSERT INTO `product` (`productID`, `naam`) VALUES ('100095', 'ritalin');
291INSERT INTO `product` (`productID`, `naam`) VALUES ('110005', 'rennie');
292
293COMMIT;
294
295
296-- -----------------------------------------------------
297-- Data for table `bestelling`
298-- -----------------------------------------------------
299START TRANSACTION;
300INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000001', '100058', 4.00, 1000);
301INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000002', '100049', 7.50, 93);
302INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000003', '100064', 20.00, 103);
303INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000004', '100095', 35.40, 568);
304INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000005', '110005', 3.00, 22);
305INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000006', '110005', 3.00, 68);
306INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000007', '100058', 4.00, 45);
307INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000008', '100058', 4.00, 33);
308INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000009', '100095', 35.40, 14);
309INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000010', '100064', 20.00, 25);
310INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000001', '100064', 20.00, 78);
311INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000002', '100058', 4.00, 68);
312INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000003', '110005', 3.00, 45);
313INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000004', '100058', 4.00, 145);
314INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000005', '100058', 4.00, 322);
315INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000007', '100049', 7.50, 12);
316INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000008', '110005', 3.00, 347);
317INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000009', '100049', 7.50, 256);
318INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000001', '100095', 35.40, 1202);
319INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000002', '100095', 35.40, 756);
320INSERT INTO `bestelling` (`orderID`, `productID`, `stukprijs`, `hoeveelheid`) VALUES ('000003', '100095', 35.40, 120);
321
322COMMIT;
323
324
325-- -----------------------------------------------------
326-- Data for table `leverancier`
327-- -----------------------------------------------------
328START TRANSACTION;
329INSERT INTO `leverancier` (`kvknummer`, `emailadres`, `adres`, `contactpersoon`, `telefoonnummer`) VALUES ('54826351', 'dylanschaafstra@gmail.com', 'fransstraat 10', 'Dylan Schaafstra', '0318-654879');
330INSERT INTO `leverancier` (`kvknummer`, `emailadres`, `adres`, `contactpersoon`, `telefoonnummer`) VALUES ('54826332', 'michielbuyserd@gmail.com', 'klaasstraat 10', 'Michiel Buyserd', '073-987456');
331INSERT INTO `leverancier` (`kvknummer`, `emailadres`, `adres`, `contactpersoon`, `telefoonnummer`) VALUES ('54826400', 'wesleynoorlander@gmail.com', 'pjotrstraat 12', 'Wesley Noorlander', '042-587963');
332INSERT INTO `leverancier` (`kvknummer`, `emailadres`, `adres`, `contactpersoon`, `telefoonnummer`) VALUES ('54826650', NULL, 'vincentstraat 15', 'Patrick Jansen', '020-4669876');
333INSERT INTO `leverancier` (`kvknummer`, `emailadres`, `adres`, `contactpersoon`, `telefoonnummer`) VALUES ('54826701', 'klaasappeltaartje@gmail.com', 'klaaslaan 22', 'Klaas Taart', '010-4578642');
334INSERT INTO `leverancier` (`kvknummer`, `emailadres`, `adres`, `contactpersoon`, `telefoonnummer`) VALUES ('45930500', 'klaasvaak@hotfemale.com', 'variatie 54', 'Klaas Vaak', '0130-340098');
335INSERT INTO `leverancier` (`kvknummer`, `emailadres`, `adres`, `contactpersoon`, `telefoonnummer`) VALUES ('42587640', 'MichaelFlexon@habbo.com', 'productielaan 125', 'Michael Flexon', '040-3501250');
336INSERT INTO `leverancier` (`kvknummer`, `emailadres`, `adres`, `contactpersoon`, `telefoonnummer`) VALUES ('23053040', 'IlovePancakes@gmail.com', 'genoeglaan 50', 'Patrick Pannenkoek', '010-3240540');
337INSERT INTO `leverancier` (`kvknummer`, `emailadres`, `adres`, `contactpersoon`, `telefoonnummer`) VALUES ('46374609', NULL, 'plank 540', 'Saskia Plank', '0409-357120');
338INSERT INTO `leverancier` (`kvknummer`, `emailadres`, `adres`, `contactpersoon`, `telefoonnummer`) VALUES ('46964034', 'Karel.Lood@hotmail.com', 'aardveld 15', 'Karel Lood', '050-1350350');
339
340COMMIT;
341
342
343-- -----------------------------------------------------
344-- Data for table `inkoop`
345-- -----------------------------------------------------
346START TRANSACTION;
347INSERT INTO `inkoop` (`kvknummer`, `productID`, `prijs`, `aantal`) VALUES ('54826351', '100058', 0.99, 1700);
348INSERT INTO `inkoop` (`kvknummer`, `productID`, `prijs`, `aantal`) VALUES ('54826332', '100049', 3.00, 400);
349INSERT INTO `inkoop` (`kvknummer`, `productID`, `prijs`, `aantal`) VALUES ('54826400', '100064', 10.00, 206);
350INSERT INTO `inkoop` (`kvknummer`, `productID`, `prijs`, `aantal`) VALUES ('54826650', '100095', 12.50, 2200);
351INSERT INTO `inkoop` (`kvknummer`, `productID`, `prijs`, `aantal`) VALUES ('54826701', '110005', 0.50, 500);
352INSERT INTO `inkoop` (`kvknummer`, `productID`, `prijs`, `aantal`) VALUES ('45930500', '100058', 1.00, NULL);
353INSERT INTO `inkoop` (`kvknummer`, `productID`, `prijs`, `aantal`) VALUES ('42587640', '100049', 5.30, NULL);
354INSERT INTO `inkoop` (`kvknummer`, `productID`, `prijs`, `aantal`) VALUES ('23053040', '100058', 1.00, NULL);
355INSERT INTO `inkoop` (`kvknummer`, `productID`, `prijs`, `aantal`) VALUES ('46374609', '100095', 15.00, NULL);
356INSERT INTO `inkoop` (`kvknummer`, `productID`, `prijs`, `aantal`) VALUES ('46964034', '100058', 1.50, NULL);
357
358COMMIT;