DROP TABLE vendors;
CREATE TABLE vendors (
	name		text,
	address		text,
	city		text,
	state		char(2),
	zip		char(10),
	country		text,
	shippingCost	float
);

INSERT INTO vendors VALUES ('diel', NULL, NULL, NULL, NULL, NULL, 0.0);
INSERT INTO vendors VALUES ('hofmann', NULL, NULL, NULL, NULL, NULL, 15.0);
INSERT INTO vendors VALUES ('saaler', NULL, NULL, NULL, NULL, NULL, 7.0);
INSERT INTO vendors VALUES ('schulz', NULL, NULL, NULL, NULL, NULL, 0.0);
INSERT INTO vendors VALUES ('huff', NULL, NULL, NULL, NULL, NULL, 18.0);
INSERT INTO vendors VALUES ('lacom', NULL, NULL, NULL, NULL, NULL, 20.0);
INSERT INTO vendors VALUES ('zone zero', NULL, NULL, NULL, NULL, NULL, 15.0);
INSERT INTO vendors VALUES ('kehr', NULL, NULL, NULL, NULL, NULL, 17.0);
INSERT INTO vendors VALUES ('haunz', NULL, NULL, NULL, NULL, NULL, 10.0);
INSERT INTO vendors VALUES ('fox', NULL, NULL, NULL, NULL, NULL, 5.0);


DROP TABLE prices;
CREATE TABLE prices (
	articleNr	char(20),
	vendor		text,
	price		float,
	inStock		bool
);

INSERT INTO prices VALUES ('x15r1201', 'diel', 100.0, 't');
INSERT INTO prices VALUES ('x15r1201', 'hofmann', 96.0, 't');
INSERT INTO prices VALUES ('x15r1201', 'saaler', 50.0, 'f');
INSERT INTO prices VALUES ('x15r1201', 'kehr', 110.0, 't');
INSERT INTO prices VALUES ('x15r1201', 'fox', 80.0, 't');
INSERT INTO prices VALUES ('y15r1202', 'lacom', 700.0, 't');
INSERT INTO prices VALUES ('y15r1202', 'zone zero', 790.0, 't');
INSERT INTO prices VALUES ('y15r1202', 'haunz', 650.0, 't');
INSERT INTO prices VALUES ('y15r1202', 'saaler', 900.0, 'f');
INSERT INTO prices VALUES ('z15r1203', 'fox', 180.0, 't');
INSERT INTO prices VALUES ('z15r1203', 'haunz', 190.0, 't');
INSERT INTO prices VALUES ('z15r1203', 'schulz', 170.0, 't');
INSERT INTO prices VALUES ('a15s1404', 'schulz', 150.0, 't');
INSERT INTO prices VALUES ('a15s1404', 'zone zero', 120.0, 't');
INSERT INTO prices VALUES ('a15s1404', 'diel', 150.0, 'f');
INSERT INTO prices VALUES ('a15s1404', 'haunz', 130.0, 't');
INSERT INTO prices VALUES ('b15s1405', 'haunz', 1500.0, 't');
INSERT INTO prices VALUES ('b15s1405', 'fox', 1500.0, 't');


DROP TABLE articles;
CREATE TABLE articles (
	articleNr	char(20),
	name		text,
	info		text,
	category	char(40),
	margin		float
);

INSERT INTO articles VALUES ('x15r1201', 'harddisk', '2GB', 'hardware', 0.25);
INSERT INTO articles VALUES ('y15r1202', 'monitor', '17"', 'hardware', 0.20);
INSERT INTO articles VALUES ('z15r1203', 'modem', '28.8bps', 'hardware', 0.35);
INSERT INTO articles VALUES ('a15s1404', 'SoftPC', 'MS-DOS emulator', 'software', 0.50);
INSERT INTO articles VALUES ('b15s1405', 'Postgres95', 'database', 'software', 0.05);

