The following gives me an error at line 4.
CREATE TABLE inventory (Pro_id INT not null ,
Pro_gr_id INT ,
Bestel_id INT not null ,
Pro_naam VARCHAR not null ,
lat_na VARCHAR ,
Verp_materiaal VARCHAR ,
Verp_kleur VARCHAR ,
Ho_ingr VARCHAR ,
Sec_ingr VARCHAR ,
Verp_maat VARCHAR ,
H_lev VARCHAR not null ,
H_lev_telno INT not null ,
S_lev VARCHAR ,
S_lev_telno INT ,
Ink_ppm_G INT not null ,
Vrk_pps_G INT ,
Ink_ppm_E INT ,
Vrk_pps_E INT not null ,
Opmerking MEDIUMTEXT ,
Aanp_dat DATE ,
PRIMARY KEY (Pro_id));
any idea??