INSERT INTO `department` VALUES (1,'finance','New York'),(2,'PR','Paris'),(3,'marketing','Geneva'),(4,'development','Bucharest');

INSERT INTO `position` VALUES (1,'president','You have to give the impression that all is going well. Your attributions are: rotate on the president\'s chair and give orders left and right.'),(2,'manager','My boss arrived at work in a brand-new Lamborghini. I said, \"wow, that\'s cool!\". He said \"If you work hard, I\'ll get another one next year.\"'),(3,'analyst','Ability to tactfully explain to clients why three parrallel lines can\'t intersect, be red and transparent at the same time'),(4,'salesman','If the opportunity knocks, sell the door'),(5,'dev','Software Developer (aka. Dev) – An organism that turns caffeine into software');

INSERT INTO `employee` VALUES (1,1,1,NULL,'Big Hoss',10000.00,'2018-10-18 00:00:00'),(2,1,1,1,'Marc Rich',8000.00,'2018-10-18 00:00:00'),(3,2,2,1,'Russell Hobbs',5000.00,'2018-11-17 00:00:00'),(4,3,2,1,'John Edsel',6000.00,'2018-11-21 00:00:00'),(5,4,2,1,'Larry Code',6500.00,'2018-10-19 00:00:00'),(6,1,3,2,'George Banking',4500.00,'2019-01-15 00:00:00'),(7,2,3,3,'Ricky Martini',3500.00,'2019-02-18 00:00:00'),(8,3,4,4,'Henry Bird',3000.00,'2019-01-18 00:00:00'),(9,4,5,5,'Linus Codecamper',5000.00,'2019-01-21 00:00:00'),(10,4,5,5,'Satoshi Bitcoin',0.00,'2019-04-21 00:00:00'),(11,4,5,5,'Mark Sugar-Mountain',5500.00,'2019-06-21 00:00:00'),(12,3,4,4,'Popeye Sailor',2500.00,'2018-11-21 00:00:00'),(13,2,3,3,'Gabriela Catastrofirea',4000.00,'2018-11-22 00:00:00'),(14,1,3,2,'Omul Paiangan',3000.00,'2019-05-12 00:00:00'),(15,2,4,3,'Agamemnon Dandanache',2000.00,'2019-08-12 00:00:00'),(16,3,3,4,'Dale Carnavalului',2500.00,'2019-09-12 00:00:00'),(17,4,5,5,'Richard Computerman',3000.00,'2019-10-12 00:00:00'),(18,4,5,5,'Bjarn Strupsoup',3000.00,'2019-11-12 00:00:00'),(19,2,4,3,'Tony Stark',10000.00,'2019-04-26 00:00:00'),(20,2,4,3,'Captain America',10000.00,'2019-04-26 00:00:00'),(21,4,3,5,'Mafaldea',5000.00,'2018-11-21 00:00:00');