Implementation: podatoci.sql

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Air cabin crew',2000,0);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Airline customer agent',3000,0);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Airline pilot',4000,0);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Airport information',5000,0);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Administrator',1000,3);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Air Human Resources',1000,1);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Supply chain manager',3000,2);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Road transport manager',3000,2);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Bus or coach driver',3000,0);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Transport Human Resources',3000,2);



INSERT INTO Skills (NameSkill) VALUES ('driving');

INSERT INTO Skills (NameSkill) VALUES ('mechanics');

INSERT INTO Skills (NameSkill) VALUES ('electronics');

INSERT INTO Skills (NameSkill) VALUES ('communication');

INSERT INTO Skills (NameSkill) VALUES ('administrative');

INSERT INTO Skills (NameSkill) VALUES ('customer Service');

INSERT INTO Skills (NameSkill) VALUES ('management');

INSERT INTO Skills (NameSkill) VALUES ('interviews');

INSERT INTO Skills (NameSkill) VALUES ('translation');

INSERT INTO Skills (NameSkill) VALUES ('problem solving');



INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Airline pilot','We need pilots for airplanes','01/10/2015');

INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Bus driver','We need bus drivers','05/12/2015');

INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Air cabin crew','Crew for air cabins','09/20/2015');

INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Airline customer agent','Agents for customer servis with airlines','09/22/2015');

INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Supply chain manager','manager for supply chain','11/13/2015');

INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Transport Human Resources','Person who will work with human resources in the transport department','10/25/2015');


INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
        VALUES ('1111111111111','Angelina','Jolie');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
        VALUES ('1111111111112','Brad','Pitt');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
        VALUES ('1111111111113','George','Clooney');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
        VALUES ('1111111111114','Jesica','Alba');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
        VALUES ('1111111111115','Vladimir','Putin');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
        VALUES ('1111111111116','Barack','Obama');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
        VALUES ('1111111111117','Angela','Merkel');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
        VALUES ('1111111111118','Karolina','Gocheva');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
        VALUES ('1111111111119','Vlado','Janevski');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
        VALUES ('1111111111110','Cristiano','Ronaldo');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
        VALUES ('1111111111120','De','Gea');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
        VALUES ('1111111111121','Salma','Hayek');

        
INSERT INTO JobsApplicants (IdJob,IdApplicant) 
        VALUES ('29','1111111111112');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
        VALUES ('29','1111111111111');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
        VALUES ('32','1111111111110');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
        VALUES ('33','1111111111113');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
        VALUES ('33','1111111111114');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
        VALUES ('33','1111111111115');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
        VALUES ('34','1111111111116');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
        VALUES ('34','1111111111117');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
        VALUES ('35','1111111111118');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
        VALUES ('35','1111111111119');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
        VALUES ('35','1111111111120');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
        VALUES ('35','1111111111121');
        
INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('2222222222220','Bill','Clinton','Macedonia','Air cabin crew','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('2222222222221','Chuck','Noris','Macedonia','Airline customer agent','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('2222222222222','Ana','Atanasova','Macedonia','Administrator','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('2222222222223','Goran','Lazarov','Macedonia','Administrator','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('2222222222224','Filip','Davkovski','Macedonia','Administrator','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('2222222222225','Ivona','Lazarovska','Macedonia','Supply chain manager','active');
        
INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('5222222222225','Ivona','Jolie','Macedonia','Supply chain manager','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('2222222222226','Vase','Pandev','Macedonia','Transport Human Resources','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('2222222222227','Martin','Donovan','Macedonia','Air Human Resources','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('2222222222228','Bruce','Willis','Macedonia','Airport information','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('2222222222229','Jackie','Chan','Macedonia','Bus or coach driver','active');
        
INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('1222222222228','George','Will','Macedonia','Transport Human Resources','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('1222222222229','Jackie','Willis','Macedonia','Supply chain manager','active');
        
INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('2222222222230','Richard','Gere','Macedonia','Air cabin crew','Fired');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('2222222222231','Selena','Gomez','Macedonia','Airline customer agent','Fired');
        
INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('2222222222233','Bob','Dylan','Macedonia','Transport Human Resources','Fired');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('2222222222234','Boby','Gomez','Macedonia','Supply chain manager','Fired');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
        VALUES ('2222222222235','Justin','Tmberlake','Macedonia','Transport Human Resources','Fired');
        
        
        
        
        
INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag) 
        VALUES ('Ana','atanasova','Admin','2222222222222',3);

INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag) 
        VALUES ('Filip','davkovski','Admin','2222222222224',3);

INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag) 
        VALUES ('Goran','lazarov','Admin','2222222222223',3);

INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag) 
        VALUES ('Ivona','Lazarovska','Manager','2222222222225',2);

INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag) 
        VALUES ('Vase','Pandev','HR','2222222222226',1);

INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag) 
        VALUES ('Martin','Donovan','HR','2222222222227',3);
        
INSERT INTO [User] ([Role],idEmployee,AccountFlag) 
        VALUES ('HR','1222222222228',1);

INSERT INTO [User] ([Role],idEmployee,AccountFlag) 
        VALUES ('Manager','1222222222229',2);
        
INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag) 
        VALUES ('Bob','dylan','HR','2222222222233',0);

INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag) 
        VALUES ('Boby','pass','Manager','2222222222234',0);

INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag) 
        VALUES ('Justin','password','HR','2222222222235',0);
        
INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag) 
        VALUES ('Iv','ivonaa','HR','5222222222225',2);

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
        VALUES ('2222222222220','administrative',5.00);
        
INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
        VALUES ('2222222222222','communication',5.00);

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
        VALUES ('2222222222223','driving',10.00);
        
INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
        VALUES ('2222222222221','customer Service',5.00);
        
INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
        VALUES ('2222222222221','administrative',10.00);

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
        VALUES ('1222222222228','customer Service',10.00);

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
        VALUES ('2222222222221','communication',10.00);

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
        VALUES ('2222222222229','driving',10.00);

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
        VALUES ('2222222222220','problem solving',8.00);

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
        VALUES ('1222222222228','problem solving',8.00);

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
        VALUES ('1222222222228','mechanics',7.00);

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
        VALUES ('1222222222229','electronics',6.00);