
# Lohnprofile anlegen
INSERT INTO `lohnprofil` VALUES (1,0,'Sozialbefreit rk',1,1,1,0,1,0,0,0,0,0,0,0,0,2),
(2,2,'Kurzfrist rk',2,1,1,0,1,0,0,0,0,0.7,0.14,0.04,0,4),
(3,0,'Minijob mit Aufstockung',2,0,0,0,0,4.6,15,0,13,0.7,0.14,0.04,2,3);

# Mitarbeiter anlegen
INSERT into mitarbeiter values
(1, 0, 'Wagner', 'Michael', 'Herr', 'Talstr 1', '80000', 'München', 'DE12 3456 7890 1234 5678 90', 'Software Bank München', 'michael@test.de', 1000, "V/0",1, 1),
(2, 0, 'Mustera', 'Anna', 'Frau', 'Talstr 2', '80000', 'München', 'DE12 3456 7890 1234 5678 91', 'Software Bank München', 'anna@test.de', 15, "", 1, 3),
(3, 0, 'Musterb', 'Berta', 'Frau', 'Talstr 3', '80000', 'München', 'DE12 3456 7890 1234 5678 92', 'Software Bank München', 'berta@test.de', 13, "", 0, 3),
(4, 0, 'Musterc', 'Caesar', 'Herr', 'Talstr 4', '80000', 'München', 'DE12 3456 7890 1234 5678 93', 'Software Bank München', 'caesar@test.de', 10, "VI/0", 1, 2);
	

