summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBenjamin Franzke <benjaminfranzke@googlemail.com>2013-01-26 22:04:03 +0100
committerBenjamin Franzke <benjaminfranzke@googlemail.com>2013-01-26 22:04:03 +0100
commitf0cd385a65e5caeb51f6f32a6d937d4855000e2f (patch)
treef1c113b957a4b0157b70b0ac4d54c5bd9f0c26ac
parentdf4b7427f6d9fb59bca2d254f13a2fbe2f86ab51 (diff)
downloadsqltutor-plugin-f0cd385a65e5caeb51f6f32a6d937d4855000e2f.tar.gz
sqltutor-plugin-f0cd385a65e5caeb51f6f32a6d937d4855000e2f.tar.bz2
sqltutor-plugin-f0cd385a65e5caeb51f6f32a6d937d4855000e2f.zip
Add kapv data
Created with the toolchain outlines in grab.sh
-rw-r--r--oracle-conversion/kapv.sql101
1 files changed, 101 insertions, 0 deletions
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');