From f0cd385a65e5caeb51f6f32a6d937d4855000e2f Mon Sep 17 00:00:00 2001
From: Benjamin Franzke <benjaminfranzke@googlemail.com>
Date: Sat, 26 Jan 2013 22:04:03 +0100
Subject: Add kapv data

Created with the toolchain outlines in grab.sh
---
 oracle-conversion/kapv.sql | 101 +++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 101 insertions(+)
 create mode 100644 oracle-conversion/kapv.sql

(limited to 'oracle-conversion')

diff --git a/oracle-conversion/kapv.sql b/oracle-conversion/kapv.sql
new file mode 100644
index 0000000..80796fa
--- /dev/null
+++ b/oracle-conversion/kapv.sql
@@ -0,0 +1,101 @@
+insert into Adressen values
+	('1','23966','wismar','poeler Str.','13','De'),
+	('2','19057','schwerin','Nachtigallenweg','1','De'),
+	('3','20095','hamburg','Hafenstr','13','De'),
+	('4','19217','rehna','Am Markt','33','De'),
+	('5','19370','parchim','Hauptstr.','21','De'),
+	('6','21266','jesteburg','Gruner Weg','7','De'),
+	('7','21376','salzhausen-luhmuhlen','Hinterstr','8','De'),
+	('8','21149','hamburg','Marktstr.','115','De');
+insert into Kunden values
+	('1','muller','klaus','03-MAY-54','m'),
+	('2','meier','joachim','12-DEC-51','m'),
+	('3','soltmann','doris','23-MAR-62','w'),
+	('4','dark','jan','15-JUN-54','m'),
+	('5','selten','johanna','01-OCT-45','w'),
+	('6','grau','alice','21-AUG-64','w'),
+	('7','thoms','walter','04-JAN-50','m');
+insert into Produktlager values
+	('10','12','1','Hammer','12-DEC-04','Mix','1'),
+	('23','100','2','Schraubstock','12-DEC-04','Eisen','2'),
+	('20','20','4','Zange','12-DEC-04','Mix','1'),
+	('30','50','3','Bohrerset','12-DEC-04','Metal','1'),
+	('84','100','5','Stepper','12-DEC-04','Mix','3'),
+	('112','12','6','Turnschuh','12-DEC-04','Leder','2'),
+	('45','10','7','Trainingsanzug','12-DEC-04','Cotton','1'),
+	('10','100','8','Badehose','12-DEC-04','Acryl','1'),
+	('74','46','9','Pullover','12-DEC-04','Cotton','1'),
+	('2','1000','10','Socken','12-DEC-04','Cotton','1'),
+	('78','25','11','Jacke','12-DEC-04','Jeans','1');
+insert into Kunden_Profil values
+	('1','1','309','-','-1'),
+	('2','2','456','-','-1'),
+	('3','3','345','-','-1'),
+	('4','4','465','-','-1'),
+	('5','5','234','+','0'),
+	('6','6','132','+','1'),
+	('7','7','465','+','1');
+insert into Auftrag values
+	('in arbeit','13-MAY-04','11','1'),
+	('in arbeit','15-MAY-03','10','1'),
+	('in arbeit','03-MAY-04','9','2'),
+	('ausgeliefert','13-MAR-04','8','3'),
+	('ausgeliefert','04-MAR-04','7','4'),
+	('ausgeliefert','23-MAR-04','6','5'),
+	('ausgeliefert','30-APR-04','5','5'),
+	('bezahlt','01-JUN-03','4','6'),
+	('bezahlt','13-OCT-03','3','6'),
+	('bezahlt','11-NOV-03','2','1'),
+	('bezahlt','13-MAY-98','1','2');
+insert into Rechnungsdaten values
+	('0','-','1','23-MAY-03','1','25-MAY-03','1'),
+	('0','-','2','21-NOV-03','1','27-NOV-03','2'),
+	('0','-','3','23-OCT-03','1','24-OCT-03','3'),
+	('0','-','4','11-JUN-03','1','12-JUN-03','4');
+insert into Auftrag_hat_Positionen values
+	('1','2','1'),
+	('2','3','1'),
+	('2','4','3'),
+	('4','5','4'),
+	('5','2','5'),
+	('6','1','6'),
+	('7','5','7'),
+	('8','3','8'),
+	('9','2','9'),
+	('10','1','10'),
+	('11','12','11'),
+	('1','3','3'),
+	('2','4','3');
+insert into Kunde_hat_Adresse values
+	('1','1'),
+	('2','2'),
+	('3','3'),
+	('4','4'),
+	('5','5'),
+	('6','5'),
+	('7','6'),
+	('8','7');
+insert into Vorlieben values
+	('Werkzeug','1'),
+	('Sport','2'),
+	('Textilien','3');
+insert into Kunde_hat_Vorlieben values
+	('1','1','1'),
+	('2','1','2'),
+	('3','1','1'),
+	('4','2','2'),
+	('5','3','1'),
+	('6','3','2'),
+	('7','2','3');
+insert into Zu_Vorlieben_gehoeren_Produkte values
+	('1','1'),
+	('2','1'),
+	('3','1'),
+	('4','1'),
+	('5','2'),
+	('6','2'),
+	('7','2'),
+	('8','2'),
+	('9','3'),
+	('10','3'),
+	('11','3');
-- 
cgit