CREATE DATABASE tuincentrum
GO
use tuincentrum
GO
CREATE TABLE plant(
	art_code char(3) PRIMARY KEY,
	plantennaam varchar(20) NOT NULL,
	soort varchar(10) NOT NULL,
	kleur varchar(10) NULL,
	hoogte float NULL,
	bloeibegin int NULL,
	bloeieinde int NULL,
	prijs money NOT NULL
);
CREATE TABLE leverancier(
	lev_code char(3) PRIMARY KEY,
	lev_naam varchar(50) NOT NULL,
	adres varchar(50) NOT NULL,
	woonplaats varchar(50) NOT NULL,
	korting numeric(4,1) NOT NULL
);
CREATE TABLE offerte(
	lev_code char(3) NOT NULL REFERENCES leverancier(lev_code),
	art_code char(3) NOT NULL REFERENCES plant(art_code),
	lev_tijd int NOT NULL,
	off_prijs money,
	PRIMARY KEY (lev_code, art_code)
);
CREATE TABLE bestelling(
	bestelnr char(4) PRIMARY KEY,
	lev_code char(3) NOT NULL REFERENCES leverancier(lev_code),
	besteldatum date NOT NULL,
	leverdatum date NOT NULL,
	bedrag money
);
CREATE TABLE bestelregel(
	bestelnr char(4) NOT NULL REFERENCES bestelling(bestelnr),
	art_code char(3) NOT NULL REFERENCES plant(art_code),
	aantal int NOT NULL,
	bestelprijs money NOT NULL,
	PRIMARY KEY (bestelnr, art_code)
);
CREATE TABLE plantschema(
	schemaid int PRIMARY KEY /*GENERATED ALWAYS AS*/ IDENTITY,
	categorie varchar(10) NOT NULL,
	hoogte1 int NOT NULL,
	hoogte2 int NOT NULL,
	afstand float NOT NULL
);
CREATE TABLE plantschema2(
    	schemaid int PRIMARY KEY /*GENERATED ALWAYS AS*/ IDENTITY,
	categorie varchar(10) not null,
	maxhoogte int not null,
	afstand float not null
)
go



INSERT INTO leverancier VALUES ('004', 'HOVENIER G.H.', 'ZANDWEG 50', 'LISSE', 0.0)
INSERT INTO leverancier VALUES ('009', 'BAUMGARTEN R.', 'TAKSTRAAT 13', 'HILLEGOM', 0.0)
INSERT INTO leverancier VALUES ('011', 'STRUIK BV.', 'BESSENLAAN 1', 'LISSE', 10.0)
INSERT INTO leverancier VALUES ('013', 'SPITMAN EN ZN.', 'ACHTERTUIN 9', 'AALSMEER', 0.0)
INSERT INTO leverancier VALUES ('014', 'DEZAAIER L.J.A.', 'DE GRONDEN 101', 'LISSE', 5.5)
INSERT INTO leverancier VALUES ('019', 'MOOIWEER FA.', 'VERLENGDE ZOMERSTR. 24', 'AALSMEER', 0.0)
INSERT INTO leverancier VALUES ('020', 'BLOEM L.Z.H.W.', 'LINNAEUSHOF 17', 'HILLEGOM', 0.0)
INSERT INTO leverancier VALUES ('021', 'TRA A.', 'KOELEPLEKSTRAAT 10', 'LISSE', 6.0)
INSERT INTO leverancier VALUES ('022', 'ERICA BV.', 'BERKENWEG 87', 'HEEMSTEDE', 0.0)
INSERT INTO leverancier VALUES ('034', 'DE GROENE KAS BV.', 'GLASWEG 1', 'AALSMEER', 2.3)
INSERT INTO leverancier VALUES ('035', 'FLORA BV.', 'OEVERSTRAAT 76', 'AALSMEER', 0.0)


INSERT INTO plant VALUES ('001','RODODENDRON','HEESTER', 'ROOD', 125, 5, 7, 19.50)
INSERT INTO plant VALUES ('012','SERING','HEESTER', 'PAARS', 500, 5, 6, 19.50)
INSERT INTO plant VALUES ('013','KRUISDISTEL','VAST', 'BLAUW', 75, 6, 7, 3.00)
INSERT INTO plant VALUES ('019','VUURDOORN','HEESTER', 'WIT', 0, 6, 6, 5.00)
INSERT INTO plant VALUES ('023','KLOKJESBLOEM','2-JARIG', 'BLAUW', 70, 6, 8, 1.80)
INSERT INTO plant VALUES ('024','KOGELDISTEL','VAST', 'BLAUW', 175, 6, 7, 3.00)
INSERT INTO plant VALUES ('027','PAARDEKASTANJE','BOOM', 'WIT', 2500, 5, 5, 17.50)
INSERT INTO plant VALUES ('028','LINDE','BOOM', 'GEEL', 4000, 7, 8, 42.50)
INSERT INTO plant VALUES ('031','WIJNSTOK','KLIM', NULL, 600, NULL, NULL, 10.00)
INSERT INTO plant VALUES ('035','VIOLIER','2-JARIG', 'GEMENGD', 60, 6, 7, 1.00)
INSERT INTO plant VALUES ('036','ZONNEBLOEM','1-JARIG', 'GEEL', 150, 8, 10, 1.80)
INSERT INTO plant VALUES ('039','POPULIER','BOOM', 'WIT', 1000, 3, 4, 4.50)
INSERT INTO plant VALUES ('042','CYPERGRAS','WATER', NULL, 100, NULL, NULL, 6.60)
INSERT INTO plant VALUES ('047','ZILVERSPAR','BOOM', NULL, 3000, NULL, NULL, 19.50)
INSERT INTO plant VALUES ('050','AFRIKAANTJE','1-JARIG', 'GEEL', 25, 7, 10, 0.60)
INSERT INTO plant VALUES ('054','BOTERBLOEM','VAST', 'WIT', 50, 5, 6, 3.00)
INSERT INTO plant VALUES ('056','HONDSTONG','VAST', 'BLAUW', 30, 6, 8, 2.50)
INSERT INTO plant VALUES ('061','STOKROOS','VAST', 'ROOD', 250, 6, 9, 2.00)
INSERT INTO plant VALUES ('066','DWERGCYPRES','BOOM', NULL, 500, NULL, NULL, 13.50)
INSERT INTO plant VALUES ('067','GANZERIK','VAST', 'ROOD', 25, 6, 9, 2.25)
INSERT INTO plant VALUES ('068','DAGLELIE','VAST', 'ROOD', 80, 6, 8, 3.00)
INSERT INTO plant VALUES ('071','DOVENETEL','VAST', 'GEEL', 25, 4, 5, 2.00)
INSERT INTO plant VALUES ('074','MUURBLOEM','2-JARIG', 'BRUIN', 50, 4, 5, 1.80)
INSERT INTO plant VALUES ('078','PIOEN','VAST', 'ROOD', 50, 6, 7, 4.50)
INSERT INTO plant VALUES ('080','KORENBLOEM','VAST', 'BLAUW', 80, 7, 8, 2.00)
INSERT INTO plant VALUES ('082','BEREKLAUW','VAST', 'WIT', 100, 7, 9, 3.50)
INSERT INTO plant VALUES ('087','KLOKJESBLOEM','VAST', 'BLAUW', 90, 6, 8, 3.00)
INSERT INTO plant VALUES ('089','LUPINE','VAST', 'GEMENGD', 100, 6, 7, 2.50)
INSERT INTO plant VALUES ('095','VIOLIER','1-JARIG', 'GEMENGD', 60, 6, 8, 1.00)
INSERT INTO plant VALUES ('102','JUDASPENNING','2-JARIG', 'LILA', 70, 5, 7, 1.00)
INSERT INTO plant VALUES ('103','AZALEA','HEESTER', 'ORANJE', 200, 4, 5, 17.50)
INSERT INTO plant VALUES ('104','ESDOORN','BOOM', 'GROEN', 2500, 6, 6, 17.50)
INSERT INTO plant VALUES ('105','DRAGON','KRUID', 'WIT', 100, 8, 9, 2.00)
INSERT INTO plant VALUES ('108','FORSYTHIA','HEESTER', 'GEEL', 250, 3, 4, 5.50)
INSERT INTO plant VALUES ('117','KORNOELJE','HEESTER', 'GEEL', 300, 5, 6, 5.50)
INSERT INTO plant VALUES ('120','BASILICUM','KRUID', 'WIT', 50, 8, 9, 2.00)
INSERT INTO plant VALUES ('123','BEGONIA','1-JARIG', 'ROOD', 15, 6, 9, 0.65)
INSERT INTO plant VALUES ('126','SIERUI','BOL', 'BLAUW', 75, 6, 8, 3.75)
INSERT INTO plant VALUES ('130','VINGERHOEDSKRUID','VAST', 'GEMENGD', 0, 6, 8, 2.00)
INSERT INTO plant VALUES ('143','VLAMBLOEM','1-JARIG', 'GEMENGD', 30, 7, 8, 1.50)
INSERT INTO plant VALUES ('147','ASTER','1-JARIG', 'GEMENGD', 50, 7, 10, 0.75)
INSERT INTO plant VALUES ('153','AKELEI','VAST', 'BLAUW', 60, 5, 7, 2.50)
INSERT INTO plant VALUES ('157','VIOOLTJE','2-JARIG', 'GEMENGD', 15, 3, 8, 0.50)
INSERT INTO plant VALUES ('162','AZIJNBOOM','BOOM', 'ROOD', 0, 6, 7, 9.50)
INSERT INTO plant VALUES ('164','MARGRIET','VAST', 'WIT', 70, 6, 8, 2.50)
INSERT INTO plant VALUES ('169','KROKUS','BOL', 'WIT', 15, 2, 3, 0.10)
INSERT INTO plant VALUES ('175','MONNIKSKAP','VAST', 'VIOLET', 120, 8, 9, 3.00)
INSERT INTO plant VALUES ('178','LIJSTERBES','BOOM', 'WIT', 500, 5, 5, 7.50)
INSERT INTO plant VALUES ('180','BOSRANK','KLIM', 'PAARS', 300, 7, 9, 6.50)
INSERT INTO plant VALUES ('184','IRIS','BOL', 'BLAUW', 100, 5, 7, 0.14)
INSERT INTO plant VALUES ('190','KIKKERBEET','WATER', 'WIT', 0, 7, 8, 1.70)
INSERT INTO plant VALUES ('195','MAGNOLIA','HEESTER', 'WIT', 1000, 4, 5, 14.50)
INSERT INTO plant VALUES ('200','ACACIA','BOOM', 'WIT', 2500, 6, 6, 17.50)
INSERT INTO plant VALUES ('205','DOTTERBLOEM','WATER', 'GEEL', 30, 4, 6, 5.90)
INSERT INTO plant VALUES ('207','ROZEMARIJN','KRUID', 'BLAUW', 150, 5, 5, 2.00)
INSERT INTO plant VALUES ('209','MEIDOORN','BOOM', 'ROZE', 700, 5, 5, 19.50)
INSERT INTO plant VALUES ('210','LIGUSTER','HEESTER', 'WIT', 200, 7, 7, 0.40)
INSERT INTO plant VALUES ('212','RIDDERSPOOR','VAST', 'LILA', 150, 6, 7, 3.00)
INSERT INTO plant VALUES ('224','DILLE','KRUID', 'GEEL', 90, 7, 8, 2.00)
INSERT INTO plant VALUES ('228','ENGELS GRAS','VAST', 'ROOD', 20, 5, 9, 2.00)
INSERT INTO plant VALUES ('234','KAMILLE','VAST', 'WIT', 70, 6, 7, 3.00)
INSERT INTO plant VALUES ('242','ZUURBES','HEESTER', 'ORANJE', 300, 5, 6, 3.50)
INSERT INTO plant VALUES ('253','BLAUW DRUIFJE','BOL', 'BLAUW', 20, 2, 6, 0.12)
INSERT INTO plant VALUES ('255','WINTERHEIDE','HEIDE', 'WIT', 20, 2, 4, 2.00)
INSERT INTO plant VALUES ('257','BERK','BOOM', NULL, 2000, NULL, NULL, 7.50)
INSERT INTO plant VALUES ('262','PASSIEBLOEM','KLIM', 'BLAUW', 0, 6, 9, 9.50)
INSERT INTO plant VALUES ('263','TOVERHAZELAAR','HEESTER', 'GEEL', 500, 1, 2, 32.00)
INSERT INTO plant VALUES ('266','KORENBLOEM','1-JARIG', 'GEMENGD', 80, 7, 8, 1.00)
INSERT INTO plant VALUES ('281','BEUK','BOOM', 'GROEN', 3000, 4, 5, 12.50)
INSERT INTO plant VALUES ('283','WATERHYACINT','WATER', 'BLAUW', 0, 6, 9, 6.60)
INSERT INTO plant VALUES ('285','KLAPROOS','VAST', 'ROOD', 70, 5, 6, 3.00)
INSERT INTO plant VALUES ('286','TULPEBOOM','BOOM', 'GEEL', 2000, 6, 7, 22.50)
INSERT INTO plant VALUES ('296','PETERSELIE','KRUID', NULL, 25, NULL, NULL, 2.00)
INSERT INTO plant VALUES ('297','MAJORAAN','KRUID', 'PAARS', 30, 7, 8, 2.00)
INSERT INTO plant VALUES ('300','PAMPUSGRAS','VAST', 'WIT', 300, 9, 10, 9.50)
INSERT INTO plant VALUES ('311','LEVERKRUID','VAST', 'PAARS', 175, 8, 9, 2.50)
INSERT INTO plant VALUES ('312','LISDODDE','WATER', 'GEEL', 200, 8, 9, 5.90)
INSERT INTO plant VALUES ('314','CHRYSANT','1-JARIG', 'GEEL', 80, 6, 8, 0.80)
INSERT INTO plant VALUES ('316','NAGELKRUID','VAST', 'ORANJE', 50, 7, 8, 3.00)
INSERT INTO plant VALUES ('319','ZURING','KRUID', 'ROOD', 70, 6, 6, 2.00)
INSERT INTO plant VALUES ('320','WATERLELIE','WATER', 'WIT', 0, 6, 8, 15.80)
INSERT INTO plant VALUES ('327','STRUIKHEIDE','HEIDE', 'GEMENGD', 30, 6, 8, 2.00)
INSERT INTO plant VALUES ('332','BLAASJESKRUID','WATER', 'GEEL', 0, 7, 8, 3.30)
INSERT INTO plant VALUES ('335','BOOMHEIDE','HEIDE', 'ROZE', 150, 7, 9, 5.50)
INSERT INTO plant VALUES ('351','TIJM','KRUID', 'PAARS', 10, 6, 6, 2.50)
INSERT INTO plant VALUES ('361','RIDDERSPOOR','1-JARIG', 'GEMENGD', 50, 7, 8, 1.00)
INSERT INTO plant VALUES ('362','SPAR','BOOM', NULL, 3000, NULL, NULL, 12.50)
INSERT INTO plant VALUES ('363','GIPSKRUID','VAST', 'WIT', 90, 7, 8, 4.50)
INSERT INTO plant VALUES ('364','BREM','HEESTER', 'GEEL', 150, 4, 7, 5.00)
INSERT INTO plant VALUES ('365','DOPHEIDE','HEIDE', 'ROOD', 35, 6, 9, 1.50)
INSERT INTO plant VALUES ('372','WOLFSMELK','VAST', 'GEEL', 60, 4, 4, 2.50)
INSERT INTO plant VALUES ('380','KLAPROOS','2-JARIG', 'GEMENGD', 40, 6, 6, 1.00)
INSERT INTO plant VALUES ('383','DAHLIA','1-JARIG', 'GEMENGD', 40, 8, 10, 1.00)
INSERT INTO plant VALUES ('384','VUURWERKPLANT','VAST', 'ROZE', 150, 6, 7, 3.50)
INSERT INTO plant VALUES ('390','ANEMOON','VAST', 'ROZE', 50, 8, 10, 3.50)
INSERT INTO plant VALUES ('391','SALIE','KRUID', 'VIOLET', 100, 6, 7, 2.00)
INSERT INTO plant VALUES ('393','JUDASBOOM','BOOM', 'ROZE', 800, 5, 5, 9.50)
INSERT INTO plant VALUES ('397','PEPERBOOMPJE','HEESTER', 'ROZE', 125, 2, 3, 15.00)
INSERT INTO plant VALUES ('398','HONDSTONG','2-JARIG', 'BLAUW', 30, 5, 6, 1.00)
INSERT INTO plant VALUES ('408','HULST','HEESTER', NULL, 700, NULL, NULL, 22.50)
INSERT INTO plant VALUES ('420','GOUDEN REGEN','BOOM', 'GEEL', 600, 5, 5, 22.00)
INSERT INTO plant VALUES ('422','WOLGRAS','WATER', 'WIT', 30, 5, 6, 4.60)
INSERT INTO plant VALUES ('425','BIESLOOK','KRUID', 'PAARS', 20, 7, 8, 2.00)
INSERT INTO plant VALUES ('426','ALYSSUM','1-JARIG', 'PAARS', 10, 6, 9, 0.60)
INSERT INTO plant VALUES ('427','KLIMOP','KLIM', NULL, 0, NULL, NULL, 7.50)
INSERT INTO plant VALUES ('428','KALMOES','WATER', NULL, 90, NULL, NULL, 5.90)
INSERT INTO plant VALUES ('434','PETUNIA','1-JARIG', 'ROZE', 25, 7, 10, 0.80)
INSERT INTO plant VALUES ('437','MUNT','KRUID', 'PAARS', 40, 8, 8, 2.00)
INSERT INTO plant VALUES ('438','ANJER','VAST', 'WIT', 40, 6, 8, 3.00)
INSERT INTO plant VALUES ('455','SLEUTELBLOEM','2-JARIG', 'GEMENGD', 25, 4, 5, 2.00)
INSERT INTO plant VALUES ('462','KERVEL','KRUID', 'WIT', 30, 5, 6, 2.00)
INSERT INTO plant VALUES ('467','ZONNEBLOEM','VAST', 'GEEL', 150, 8, 9, 2.00)
INSERT INTO plant VALUES ('468','LEEUWEBEKJE','1-JARIG', 'GEMENGD', 50, 7, 8, 0.80)
INSERT INTO plant VALUES ('469','TULP','BOL', 'GEEL', 30, 4, 6, 0.40)
INSERT INTO plant VALUES ('470','GIPSKRUID','1-JARIG', 'WIT', 50, 6, 7, 1.00)
INSERT INTO plant VALUES ('471','OLIJFWILG','HEESTER', 'GEEL', 400, 9, 10, 10.00)
INSERT INTO plant VALUES ('478','KLAPROOS','1-JARIG', 'GEMENGD', 35, 6, 9, 1.00)
INSERT INTO plant VALUES ('486','VUURPIJL','VAST', 'ROOD', 120, 6, 9, 3.50)
INSERT INTO plant VALUES ('498','JENEVERBES','BOOM', NULL, 250, NULL, NULL, 6.50)

INSERT INTO bestelling VALUES ('0121', '013', '1999-01-17', '1999-01-31', 602.50)
INSERT INTO bestelling VALUES ('0174', '004', '1999-02-25', '1999-03-04', 117.50)
INSERT INTO bestelling VALUES ('0175', '004', '1999-02-27', '1999-03-06', 399.50)
INSERT INTO bestelling VALUES ('0181', '009', '1999-03-06', '1999-03-27', 607.60)
INSERT INTO bestelling VALUES ('0184', '022', '1999-03-06', '1999-03-16', 240.00)
INSERT INTO bestelling VALUES ('0186', '020', '1999-03-11', '1999-03-18', 422.50)
INSERT INTO bestelling VALUES ('0190', '014', '1999-03-13', '1999-03-23', 642.84)
INSERT INTO bestelling VALUES ('0191', '013', '1999-03-13', '1999-03-27', 1316.75)
INSERT INTO bestelling VALUES ('0192', '035', '1999-03-13', '1999-03-23', 330.75)
INSERT INTO bestelling VALUES ('0197', '035', '1999-03-14', '1999-03-23', 966.95)
INSERT INTO bestelling VALUES ('0200', '004', '1999-03-14', '1999-03-21', 72.00)
INSERT INTO bestelling VALUES ('0201', '004', '1999-03-26', '1999-04-02', 221.25)
INSERT INTO bestelling VALUES ('0202', '014', '1999-03-26', '1999-04-05', 511.48)
INSERT INTO bestelling VALUES ('0203', '019', '1999-04-01', '1999-04-15', 605.00)
INSERT INTO bestelling VALUES ('0204', '034', '1999-04-01', '1999-04-15', 486.06)


INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0121', '031', 25, 6.35);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0121', '087', 50, 1.9);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0121', '311', 50, 1.65);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0121', '314', 150, 0.45);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0121', '365', 150, 0.95);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0121', '422', 25, 2.25);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0174', '102', 25, 0.7);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0174', '380', 25, 0.65);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0174', '455', 50, 1.35);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0174', '470', 25, 0.65);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0175', '036', 50, 0.75);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0175', '074', 100, 0.7);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0175', '095', 100, 0.4);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0175', '102', 10, 0.45);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0175', '157', 400, 0.2);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0175', '380', 50, 0.45);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0175', '426', 250, 0.25);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0175', '434', 25, 0.35);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0175', '455', 50, 0.8);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0175', '470', 25, 0.45);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0175', '478', 50, 0.45);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0181', '209', 3, 9.45);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0181', '257', 10, 3.6);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0181', '263', 25, 15.45);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0181', '362', 20, 6.05);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0181', '397', 5, 7.2);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0184', '365', 200, 1.2);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0186', '126', 100, 3.25);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0186', '143', 25, 1.3);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0186', '468', 100, 0.65);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0190', '023', 100, 1);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0190', '050', 200, 0.35);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0190', '054', 50, 1.65);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0190', '056', 20, 1.45);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0190', '068', 25, 1.6);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0190', '102', 25, 0.55);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0190', '455', 100, 1.15);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0190', '467', 200, 1.15);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0191', '001', 10, 11.7);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0191', '036', 100, 1.1);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0191', '071', 25, 1.2);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0191', '087', 50, 1.8);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0191', '123', 50, 0.4);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0191', '184', 1000, 0.1);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0191', '281', 10, 7.55);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0191', '311', 50, 1.5);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0191', '312', 30, 2.75);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0191', '314', 100, 0.5);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0191', '316', 40, 1.75);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0191', '362', 10, 7.55);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0191', '364', 25, 2.95);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0191', '383', 250, 0.6);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0191', '422', 50, 2.15);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0191', '471', 15, 6);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0192', '089', 100, 1.65);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0192', '190', 12, 0.9);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0192', '427', 24, 5.05);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0192', '467', 25, 1.35);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0197', '068', 50, 2.3);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0197', '180', 36, 4.85);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0197', '190', 24, 1);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0197', '285', 50, 3.75);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0197', '320', 48, 8.95);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0197', '467', 25, 1.45);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0200', '036', 25, 1.25);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0200', '102', 10, 0.7);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0200', '380', 25, 0.7);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0200', '478', 25, 0.65);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0201', '036', 25, 1.25);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0201', '095', 25, 0.7);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0201', '102', 25, 0.75);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0201', '380', 25, 0.7);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0201', '434', 50, 0.55);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0201', '455', 50, 1.45);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0201', '470', 25, 0.75);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0201', '478', 25, 0.7);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0202', '050', 150, 0.4);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0202', '123', 100, 0.4);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0202', '147', 150, 0.5);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0202', '228', 75, 1.35);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0202', '316', 100, 2.05);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0202', '390', 25, 2.4);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0203', '056', 50, 1.4);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0203', '061', 25, 1.15);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0203', '080', 50, 1.15);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0203', '089', 200, 1.4);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0203', '363', 25, 2.65);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0203', '486', 50, 2.05);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0204', '061', 50, 1);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0204', '074', 50, 0.95);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0204', '087', 150, 1.55);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0204', '123', 50, 0.35);
INSERT INTO bestelregel (BESTELNR,ART_CODE,AANTAL,BESTELPRIJS) VALUES ('0204', '212', 100, 1.5);

INSERT INTO offerte VALUES ('004','036',7,1.10)
INSERT INTO offerte VALUES ('004','074',7,1.10)
INSERT INTO offerte VALUES ('004','095',7,0.60)
INSERT INTO offerte VALUES ('004','102',7,0.60)
INSERT INTO offerte VALUES ('004','157',7,0.30)
INSERT INTO offerte VALUES ('004','380',7,0.60)
INSERT INTO offerte VALUES ('004','426',7,0.35)
INSERT INTO offerte VALUES ('004','434',7,0.50)
INSERT INTO offerte VALUES ('004','455',7,1.20)
INSERT INTO offerte VALUES ('004','470',7,0.60)
INSERT INTO offerte VALUES ('004','478',7,0.60)
INSERT INTO offerte VALUES ('009','001',21,8.80)
INSERT INTO offerte VALUES ('009','027',21,7.90)
INSERT INTO offerte VALUES ('009','066',21,6.10)
INSERT INTO offerte VALUES ('009','103',21,7.90)
INSERT INTO offerte VALUES ('009','104',21,7.90)
INSERT INTO offerte VALUES ('009','117',21,2.50)
INSERT INTO offerte VALUES ('009','162',21,4.30)
INSERT INTO offerte VALUES ('009','178',21,3.40)
INSERT INTO offerte VALUES ('009','195',21,6.55)
INSERT INTO offerte VALUES ('009','209',21,8.80)
INSERT INTO offerte VALUES ('009','210',21,0.20)
INSERT INTO offerte VALUES ('009','257',21,3.40)
INSERT INTO offerte VALUES ('009','263',21,14.40)
INSERT INTO offerte VALUES ('009','281',21,5.65)
INSERT INTO offerte VALUES ('009','286',21,10.15)
INSERT INTO offerte VALUES ('009','362',21,5.65)
INSERT INTO offerte VALUES ('009','364',21,2.25)
INSERT INTO offerte VALUES ('009','393',21,4.30)
INSERT INTO offerte VALUES ('009','397',21,6.75)
INSERT INTO offerte VALUES ('009','408',21,10.15)
INSERT INTO offerte VALUES ('009','420',21,9.90)
INSERT INTO offerte VALUES ('009','471',21,4.50)
INSERT INTO offerte VALUES ('009','498',21,2.95)
INSERT INTO offerte VALUES ('011','001',14,10.35)
INSERT INTO offerte VALUES ('011','012',14,10.35)
INSERT INTO offerte VALUES ('011','103',14,9.30)
INSERT INTO offerte VALUES ('011','117',14,2.90)
INSERT INTO offerte VALUES ('011','195',14,7.70)
INSERT INTO offerte VALUES ('011','255',10,1.05)
INSERT INTO offerte VALUES ('011','263',14,16.95)
INSERT INTO offerte VALUES ('011','327',10,1.05)
INSERT INTO offerte VALUES ('011','335',21,2.90)
INSERT INTO offerte VALUES ('011','365',10,0.80)
INSERT INTO offerte VALUES ('011','397',14,7.95)
INSERT INTO offerte VALUES ('011','408',14,11.95)
INSERT INTO offerte VALUES ('013','001',14,12.70)
INSERT INTO offerte VALUES ('013','031',14,6.50)
INSERT INTO offerte VALUES ('013','036',7,1.15)
INSERT INTO offerte VALUES ('013','047',14,12.70)
INSERT INTO offerte VALUES ('013','056',10,1.65)
INSERT INTO offerte VALUES ('013','067',10,1.45)
INSERT INTO offerte VALUES ('013','071',10,1.30)
INSERT INTO offerte VALUES ('013','082',10,2.30)
INSERT INTO offerte VALUES ('013','087',10,1.95)
INSERT INTO offerte VALUES ('013','123',7,0.40)
INSERT INTO offerte VALUES ('013','184',7,0.10)
INSERT INTO offerte VALUES ('013','200',14,11.40)
INSERT INTO offerte VALUES ('013','228',10,1.30)
INSERT INTO offerte VALUES ('013','262',14,6.20)
INSERT INTO offerte VALUES ('013','281',14,8.15)
INSERT INTO offerte VALUES ('013','300',10,6.20)
INSERT INTO offerte VALUES ('013','311',10,1.65)
INSERT INTO offerte VALUES ('013','312',10,2.95)
INSERT INTO offerte VALUES ('013','314',7,0.50)
INSERT INTO offerte VALUES ('013','316',10,1.95)
INSERT INTO offerte VALUES ('013','332',10,1.65)
INSERT INTO offerte VALUES ('013','362',14,8.15)
INSERT INTO offerte VALUES ('013','364',14,3.25)
INSERT INTO offerte VALUES ('013','365',14,1.00)
INSERT INTO offerte VALUES ('013','372',10,1.65)
INSERT INTO offerte VALUES ('013','383',7,0.65)
INSERT INTO offerte VALUES ('013','391',10,1.30)
INSERT INTO offerte VALUES ('013','393',14,6.20)
INSERT INTO offerte VALUES ('013','422',10,2.30)
INSERT INTO offerte VALUES ('013','437',10,1.30)
INSERT INTO offerte VALUES ('013','471',14,6.50)
INSERT INTO offerte VALUES ('014','013',10,1.70)
INSERT INTO offerte VALUES ('014','023',10,1.05)
INSERT INTO offerte VALUES ('014','035',10,0.55)
INSERT INTO offerte VALUES ('014','050',10,0.35)
INSERT INTO offerte VALUES ('014','054',10,1.70)
INSERT INTO offerte VALUES ('014','056',10,1.45)
INSERT INTO offerte VALUES ('014','068',10,1.70)
INSERT INTO offerte VALUES ('014','071',10,1.15)
INSERT INTO offerte VALUES ('014','087',10,1.70)
INSERT INTO offerte VALUES ('014','102',10,0.55)
INSERT INTO offerte VALUES ('014','123',10,0.35)
INSERT INTO offerte VALUES ('014','147',10,0.45)
INSERT INTO offerte VALUES ('014','157',10,0.30)
INSERT INTO offerte VALUES ('014','164',10,1.45)
INSERT INTO offerte VALUES ('014','212',10,1.70)
INSERT INTO offerte VALUES ('014','228',10,1.15)
INSERT INTO offerte VALUES ('014','297',10,1.15)
INSERT INTO offerte VALUES ('014','311',10,1.45)
INSERT INTO offerte VALUES ('014','316',10,1.70)
INSERT INTO offerte VALUES ('014','351',10,1.45)
INSERT INTO offerte VALUES ('014','363',10,2.55)
INSERT INTO offerte VALUES ('014','372',10,1.45)
INSERT INTO offerte VALUES ('014','380',10,0.55)
INSERT INTO offerte VALUES ('014','384',10,2.00)
INSERT INTO offerte VALUES ('014','390',10,2.00)
INSERT INTO offerte VALUES ('014','398',10,0.55)
INSERT INTO offerte VALUES ('014','438',10,1.70)
INSERT INTO offerte VALUES ('014','455',10,1.15)
INSERT INTO offerte VALUES ('014','467',10,1.15)
INSERT INTO offerte VALUES ('014','478',10,0.55)
INSERT INTO offerte VALUES ('019','013',14,1.80)
INSERT INTO offerte VALUES ('019','056',14,1.50)
INSERT INTO offerte VALUES ('019','061',14,1.20)
INSERT INTO offerte VALUES ('019','067',14,1.35)
INSERT INTO offerte VALUES ('019','071',14,1.20)
INSERT INTO offerte VALUES ('019','078',14,2.70)
INSERT INTO offerte VALUES ('019','080',14,1.20)
INSERT INTO offerte VALUES ('019','082',14,2.10)
INSERT INTO offerte VALUES ('019','087',14,1.80)
INSERT INTO offerte VALUES ('019','089',14,1.50)
INSERT INTO offerte VALUES ('019','164',14,1.50)
INSERT INTO offerte VALUES ('019','175',14,1.80)
INSERT INTO offerte VALUES ('019','207',14,1.20)
INSERT INTO offerte VALUES ('019','212',14,1.80)
INSERT INTO offerte VALUES ('019','234',14,1.80)
INSERT INTO offerte VALUES ('019','316',14,1.80)
INSERT INTO offerte VALUES ('019','363',14,2.70)
INSERT INTO offerte VALUES ('019','372',14,1.50)
INSERT INTO offerte VALUES ('019','425',14,1.20)
INSERT INTO offerte VALUES ('019','438',14,1.80)
INSERT INTO offerte VALUES ('019','467',14,1.20)
INSERT INTO offerte VALUES ('019','486',14,2.10)
INSERT INTO offerte VALUES ('020','036',7,1.15)
INSERT INTO offerte VALUES ('020','123',7,0.40)
INSERT INTO offerte VALUES ('020','126',7,2.45)
INSERT INTO offerte VALUES ('020','143',7,1.00)
INSERT INTO offerte VALUES ('020','147',7,0.50)
INSERT INTO offerte VALUES ('020','169',7,0.05)
INSERT INTO offerte VALUES ('020','184',7,0.10)
INSERT INTO offerte VALUES ('020','253',7,0.10)
INSERT INTO offerte VALUES ('020','266',7,0.65)
INSERT INTO offerte VALUES ('020','314',7,0.50)
INSERT INTO offerte VALUES ('020','361',7,0.65)
INSERT INTO offerte VALUES ('020','383',7,0.65)
INSERT INTO offerte VALUES ('020','434',7,0.50)
INSERT INTO offerte VALUES ('020','468',7,0.50)
INSERT INTO offerte VALUES ('020','470',7,0.65)
INSERT INTO offerte VALUES ('021','001',10,9.75)
INSERT INTO offerte VALUES ('021','012',10,9.75)
INSERT INTO offerte VALUES ('021','019',10,2.50)
INSERT INTO offerte VALUES ('021','103',10,8.75)
INSERT INTO offerte VALUES ('021','108',10,2.75)
INSERT INTO offerte VALUES ('021','117',10,2.75)
INSERT INTO offerte VALUES ('021','195',10,7.25)
INSERT INTO offerte VALUES ('021','210',10,0.20)
INSERT INTO offerte VALUES ('021','242',10,1.75)
INSERT INTO offerte VALUES ('021','263',10,16.00)
INSERT INTO offerte VALUES ('021','364',10,2.50)
INSERT INTO offerte VALUES ('021','397',10,7.50)
INSERT INTO offerte VALUES ('021','408',10,11.25)
INSERT INTO offerte VALUES ('021','471',10,5.00)
INSERT INTO offerte VALUES ('022','028',14,22.95)
INSERT INTO offerte VALUES ('022','039',14,2.45)
INSERT INTO offerte VALUES ('022','103',14,9.45)
INSERT INTO offerte VALUES ('022','210',14,0.20)
INSERT INTO offerte VALUES ('022','281',14,6.75)
INSERT INTO offerte VALUES ('022','286',14,12.15)
INSERT INTO offerte VALUES ('022','335',10,2.95)
INSERT INTO offerte VALUES ('022','364',14,2.70)
INSERT INTO offerte VALUES ('022','365',10,0.80)
INSERT INTO offerte VALUES ('022','393',14,5.15)
INSERT INTO offerte VALUES ('022','471',14,5.40)
INSERT INTO offerte VALUES ('034','013',14,1.85)
INSERT INTO offerte VALUES ('034','024',14,1.85)
INSERT INTO offerte VALUES ('034','031',14,6.20)
INSERT INTO offerte VALUES ('034','050',14,0.35)
INSERT INTO offerte VALUES ('034','061',14,1.25)
INSERT INTO offerte VALUES ('034','074',14,1.10)
INSERT INTO offerte VALUES ('034','082',14,2.15)
INSERT INTO offerte VALUES ('034','087',14,1.85)
INSERT INTO offerte VALUES ('034','089',14,1.55)
INSERT INTO offerte VALUES ('034','105',14,1.25)
INSERT INTO offerte VALUES ('034','120',14,1.25)
INSERT INTO offerte VALUES ('034','123',14,0.40)
INSERT INTO offerte VALUES ('034','143',14,0.95)
INSERT INTO offerte VALUES ('034','153',14,1.55)
INSERT INTO offerte VALUES ('034','157',14,0.30)
INSERT INTO offerte VALUES ('034','164',14,1.55)
INSERT INTO offerte VALUES ('034','212',14,1.85)
INSERT INTO offerte VALUES ('034','224',14,1.25)
INSERT INTO offerte VALUES ('034','253',14,0.05)
INSERT INTO offerte VALUES ('034','285',14,3.10)
INSERT INTO offerte VALUES ('034','300',14,5.90)
INSERT INTO offerte VALUES ('034','319',14,1.25)
INSERT INTO offerte VALUES ('034','380',14,0.60)
INSERT INTO offerte VALUES ('034','390',14,2.15)
INSERT INTO offerte VALUES ('034','391',14,1.25)
INSERT INTO offerte VALUES ('034','398',14,0.60)
INSERT INTO offerte VALUES ('034','427',14,4.65)
INSERT INTO offerte VALUES ('034','455',14,1.25)
INSERT INTO offerte VALUES ('034','462',14,1.25)
INSERT INTO offerte VALUES ('034','468',14,0.50)
INSERT INTO offerte VALUES ('034','469',14,0.25)
INSERT INTO offerte VALUES ('035','042',10,3.30)
INSERT INTO offerte VALUES ('035','054',10,2.00)
INSERT INTO offerte VALUES ('035','061',10,1.30)
INSERT INTO offerte VALUES ('035','068',10,2.00)
INSERT INTO offerte VALUES ('035','082',10,2.30)
INSERT INTO offerte VALUES ('035','089',10,1.65)
INSERT INTO offerte VALUES ('035','130',10,1.30)
INSERT INTO offerte VALUES ('035','180',10,4.30)
INSERT INTO offerte VALUES ('035','190',10,0.85)
INSERT INTO offerte VALUES ('035','205',10,2.95)
INSERT INTO offerte VALUES ('035','283',10,3.30)
INSERT INTO offerte VALUES ('035','285',10,3.30)
INSERT INTO offerte VALUES ('035','296',10,1.30)
INSERT INTO offerte VALUES ('035','311',10,1.65)
INSERT INTO offerte VALUES ('035','320',10,7.90)
INSERT INTO offerte VALUES ('035','427',10,4.95)
INSERT INTO offerte VALUES ('035','428',10,2.95)
INSERT INTO offerte VALUES ('035','467',10,1.30)

INSERT INTO plantschema (categorie, hoogte1, hoogte2, afstand) VALUES ('ACHTER-H', 101, 150, 60)
INSERT INTO plantschema (categorie, hoogte1, hoogte2, afstand) VALUES ('ACHTER-L', 61, 100, 45)
INSERT INTO plantschema (categorie, hoogte1, hoogte2, afstand) VALUES ('BOMEN', 301, 4000, 400)
INSERT INTO plantschema (categorie, hoogte1, hoogte2, afstand) VALUES ('LAAG', 5, 15, 20)
INSERT INTO plantschema (categorie, hoogte1, hoogte2, afstand) VALUES ('MIDDEN', 16, 60, 30)
INSERT INTO plantschema (categorie, hoogte1, hoogte2, afstand) VALUES ('SCHEIDING', 151, 300, 85)
GO
insert into plantschema2 (categorie, maxhoogte, afstand)
select categorie, hoogte2, afstand from plantschema