-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathData.sql
More file actions
94 lines (86 loc) · 10.9 KB
/
Copy pathData.sql
File metadata and controls
94 lines (86 loc) · 10.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
Use Unternehm
insert into Projekt (Name, Start_Date, End_Date) values ('Proj1', '2018-01-01 09:19:24', '2018-12-01 16:59:10');
insert into Projekt (Name, Start_Date, End_Date) values ('Proj2', '2018-02-02 03:06:35', '2019-01-01 12:41:27');
insert into Projekt (Name, Start_Date, End_Date) values ('Proj3', '2018-03-03 17:08:54', '2019-02-02 19:40:17');
insert into Projekt (Name, Start_Date, End_Date) values ('Proj4', '2018-04-04 10:40:12', '2019-03-03 22:18:58');
insert into Projekt (Name, Start_Date, End_Date) values ('Proj5', '2018-05-05 05:46:27', '2019-04-04 20:56:10');
insert into Projekt (Name, Start_Date, End_Date) values ('Proj6', '2018-06-06 20:49:26', '2019-05-05 13:55:27');
insert into Projekt (Name, Start_Date, End_Date) values ('Proj7', '2017-07-07 01:46:02', '2018-06-06 16:51:41');
insert into Projekt (Name, Start_Date, End_Date) values ('Proj8', '2018-08-08 00:28:56', '2019-07-07 20:16:35');
insert into Projekt (Name, Start_Date, End_Date) values ('Proj9', '2018-09-09 11:52:37', '2019-08-08 04:49:21');
insert into Projekt (Name, Start_Date, End_Date) values ('Proj10', '2018-10-10 06:32:48', '2019-09-09 08:11:20');
insert into Niederlassung (Ort, Telefon, Email) values ('Berlin', '8583000087', 'berlin@firma.com');
insert into Niederlassung (Ort, Telefon, Email) values ('Salzburg', '5026603615', 'salzburg@firma.com');
insert into Niederlassung (Ort, Telefon, Email) values ('Wien', '1976094486', 'wien@firma.com');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('M', 'Duane', 'Ruzicka', '0 Orin Hill', '9815312511', 'druzicka0@scribd.com');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('M', 'Nestor', 'Follit', '8 Fremont Park', '2398513132', 'nfollit1@youku.com');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('F', 'Gusella', 'Waller-Bridge', '7 Commercial Drive', '8159990753', 'gwallerbridge2@arstechnica.com');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('M', 'Stuart', 'Freeland', '81 Canary Pass', '2091119670', 'sfreeland3@cnet.com');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('F', 'Feliza', 'Harcombe', '6 Reindahl Junction', '3015962696', 'fharcombe4@github.com');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('F', 'Donnie', 'Bricham', '016 Fulton Lane', '3055325252', 'dbricham5@mit.edu');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('M', 'Sherlock', 'Gatsby', '43940 Stang Point', '5147192493', 'sgatsby6@liveinternet.ru');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('M', 'Lesley', 'Loosely', '12948 Moulton Crossing', '8507883337', 'lloosely7@webeden.co.uk');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('F', 'Iseabal', 'Murby', '6 Schlimgen Parkway', '3339135141', 'imurby8@nbcnews.com');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('M', 'Simone', 'Lorenzetti', '63 Hansons Lane', '8515279587', 'slorenzetti9@sphinn.com');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('F', 'Conni', 'Blenkinsop', '81905 Clove Parkway', '4728930495', 'cblenkinsopa@123-reg.co.uk');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('M', 'Kellby', 'Spencook', '8 Pleasure Park', '6223858902', 'kspencookb@chron.com');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('M', 'Reynolds', 'Linkie', '04025 Lake View Terrace', '3063708013', 'rlinkiec@nytimes.com');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('M', 'Haydon', 'Pobjoy', '2 Hollow Ridge Junction', '1071066462', 'hpobjoyd@businessweek.com');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('M', 'Neddy', 'Franz', '23 Lawn Center', '5909426565', 'nfranze@vk.com');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('M', 'Germain', 'Iacovacci', '77671 Little Fleur Point', '4799271755', 'giacovaccif@bbb.org');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('F', 'Charmane', 'Peniello', '5368 American Street', '7256676258', 'cpeniellog@bizjournals.com');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('M', 'Winfield', 'Baldelli', '99227 Havey Park', '6517181947', 'wbaldellih@people.com.cn');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('F', 'Tine', 'Tour', '90 Heffernan Hill', '2978897791', 'ttouri@washington.edu');
insert into Kunde (Sex , Vorname, Nachname, PLZ_Stadt, Telefon, Email) values ('M', 'Flem', 'Struttman', '75793 Lakewood Center', '2208467693', 'fstruttmanj@paypal.com');
insert into Abteilung (Name, Anzahl_Angestellte, Email, Telefon) values ('Developer', 12, 'developer@firma.com', '9074243440');
insert into Abteilung (Name, Anzahl_Angestellte, Email, Telefon) values ('Facilities', 6, 'facilities@firma.com', '2487126791');
insert into Abteilung (Name, Anzahl_Angestellte, Email, Telefon) values ('Buchhaltung', 3, 'buchhaltung@firma.com', '7816841938');
insert into Abteilung (Name, Anzahl_Angestellte, Email, Telefon) values ('CEO', 3, 'ceo@firma.com', '4607340613');
insert into Abteilung (Name, Anzahl_Angestellte, Email, Telefon) values ('Projektmanagement', 3, 'projektmanagement@firma.com', '8801153941');
insert into Abteilung (Name, Anzahl_Angestellte, Email, Telefon) values ('Sekr�terin', 3, 'sekraeterin@firma.com', '5133210036');
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Gerick', 'Solomonides', 'gsolomonides0@1688.com', 'M', 5000, 1);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Hyacinth', 'Moreno', 'hmoreno1@vk.com', 'F', 5000, 2);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Olimpia', 'Lyvon', 'olyvon2@earthlink.net', 'F', 5000, 3);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Mira', 'Caudrelier', 'mcaudrelier3@nifty.com', 'F', 5000, 1);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Gabby', 'Olford', 'golford4@sciencedaily.com', 'M', 5000, 2);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Ferguson', 'Ace', 'face5@uiuc.edu', 'M', 5000, 3);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Cecilio', 'Gieraths', 'cgieraths6@rediff.com', 'M', 5000, 1);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Igor', 'Brinson', 'ibrinson7@nifty.com', 'M', 5000, 2);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Rudolph', 'Alloisi', 'ralloisi8@mozilla.org', 'M', 5000, 3);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Mei', 'Sheran', 'msheran9@umich.edu', 'F', 5000, 1);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Mareah', 'Henrique', 'mhenriquea@trellian.com', 'F', 5000, 2);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Bob', 'Anstis', 'banstisb@miibeian.gov.cn', 'M', 5000, 3);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Winthrop', 'Fibbens', 'wfibbensc@marriott.com', 'M', 8000, 1);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Otto', 'Bewick', 'obewickd@cisco.com', 'M', 8000, 2);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Giraldo', 'Brislane', 'gbrislanee@unc.edu', 'M', 8000, 3);
insert into Angestellte (Vorname, Nachname, Sex , Gehalt, FK_FirmaID) values ('Wanda', 'Spadoni', 'F', 1200, 1);
insert into Angestellte (Vorname, Nachname, Sex , Gehalt, FK_FirmaID) values ('Cornela', 'Hatwells', 'F', 1200, 2);
insert into Angestellte (Vorname, Nachname, Sex , Gehalt, FK_FirmaID) values ('Nichol', 'Cabel', 'F', 1200, 3);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Pippo', 'Ecob', 'pecobg@hc360.com', 'F', 1200, 1);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Kamram', 'Bernet', 'kbernetj@mlb.com', 'F', 1200, 2);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Hooman', 'Bernet', 'hbernetj@mlb.com', 'F', 1200, 3);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Alex', 'Brk', 'alexbrk@mlb.com', 'M', 10000, 1);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Michi', 'Koller', 'mkoller@mlb.com', 'M', 10000, 2);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Sina', 'Barakati', 'sbarakati@mlb.com', 'M', 10000, 3);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Kimia', 'Kazazi', 'kkazazi@mlb.com', 'M', 7000, 1);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Alireza', 'Esbati', 'aliesb@mlb.com', 'M', 7000, 2);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Ebi', 'Ebrahimi', 'ebrahimi@mlb.com', 'F', 7000, 3);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Leo', 'Messi', 'LeoMessi@mlb.com', 'F', 1600, 1);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Karim', 'Morata', 'morata@mlb.com', 'F', 1600, 2);
insert into Angestellte (Vorname, Nachname, Email, Sex , Gehalt, FK_FirmaID) values ('Ervine', 'Ervinian', 'ervinian@mlb.com', 'F', 1600, 3);
insert into Bestellung (Datum, Preis, FK_Proj, FK_Kunde) values ('2017-12-17 23:12:27', 859, 1, 1);
insert into Bestellung (Datum, Preis, FK_Proj, FK_Kunde) values ('2018-01-01 18:17:10', 780, 2, 2);
insert into Bestellung (Datum, Preis, FK_Proj, FK_Kunde) values ('2018-02-02 13:39:35', 827, 3, 3);
insert into Bestellung (Datum, Preis, FK_Proj, FK_Kunde) values ('2018-03-03 15:29:12', 669, 4, 4);
insert into Bestellung (Datum, Preis, FK_Proj, FK_Kunde) values ('2018-04-04 02:29:11', 648, 5, 5);
insert into Bestellung (Datum, Preis, FK_Proj, FK_Kunde) values ('2018-05-05 03:22:59', 666, 6, 1);
insert into Bestellung (Datum, Preis, FK_Proj, FK_Kunde) values ('2018-06-06 02:19:13', 635, 1, 7);
insert into Bestellung (Datum, Preis, FK_Proj, FK_Kunde) values ('2018-07-07 00:07:00', 856, 2, 8);
insert into Bestellung (Datum, Preis, FK_Proj, FK_Kunde) values ('2018-08-08 11:52:50', 697, 7, 8);
insert into Bestellung (Datum, Preis, FK_Proj, FK_Kunde) values ('2018-09-09 12:23:48', 680, 10, 10);
update Angestellte set FK_Abt_nr = 1 where Gehalt = 5000
update Angestellte set FK_Abt_nr = 2 where Gehalt = 1200
update Angestellte set FK_Abt_nr = 3 where Gehalt = 7000
update Angestellte set FK_Abt_nr = 4 where Gehalt = 10000
update Angestellte set FK_Abt_nr = 5 where Gehalt = 8000
update Angestellte set FK_Abt_nr = 6 where Gehalt = 1600