1 | INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Air cabin crew',2000,0);
|
---|
2 |
|
---|
3 | INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Airline customer agent',3000,0);
|
---|
4 |
|
---|
5 | INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Airline pilot',4000,0);
|
---|
6 |
|
---|
7 | INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Airport information',5000,0);
|
---|
8 |
|
---|
9 | INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Administrator',1000,3);
|
---|
10 |
|
---|
11 | INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Air Human Resources',1000,1);
|
---|
12 |
|
---|
13 | INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Supply chain manager',3000,2);
|
---|
14 |
|
---|
15 | INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Road transport manager',3000,2);
|
---|
16 |
|
---|
17 | INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Bus or coach driver',3000,0);
|
---|
18 |
|
---|
19 | INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Transport Human Resources',3000,2);
|
---|
20 |
|
---|
21 |
|
---|
22 |
|
---|
23 | INSERT INTO Skills (NameSkill) VALUES ('driving');
|
---|
24 |
|
---|
25 | INSERT INTO Skills (NameSkill) VALUES ('mechanics');
|
---|
26 |
|
---|
27 | INSERT INTO Skills (NameSkill) VALUES ('electronics');
|
---|
28 |
|
---|
29 | INSERT INTO Skills (NameSkill) VALUES ('communication');
|
---|
30 |
|
---|
31 | INSERT INTO Skills (NameSkill) VALUES ('administrative');
|
---|
32 |
|
---|
33 | INSERT INTO Skills (NameSkill) VALUES ('customer Service');
|
---|
34 |
|
---|
35 | INSERT INTO Skills (NameSkill) VALUES ('management');
|
---|
36 |
|
---|
37 | INSERT INTO Skills (NameSkill) VALUES ('interviews');
|
---|
38 |
|
---|
39 | INSERT INTO Skills (NameSkill) VALUES ('translation');
|
---|
40 |
|
---|
41 | INSERT INTO Skills (NameSkill) VALUES ('problem solving');
|
---|
42 |
|
---|
43 |
|
---|
44 |
|
---|
45 | INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Airline pilot','We need pilots for airplanes','01/10/2015');
|
---|
46 |
|
---|
47 | INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Bus driver','We need bus drivers','05/12/2015');
|
---|
48 |
|
---|
49 | INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Air cabin crew','Crew for air cabins','09/20/2015');
|
---|
50 |
|
---|
51 | INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Airline customer agent','Agents for customer servis with airlines','09/22/2015');
|
---|
52 |
|
---|
53 | INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Supply chain manager','manager for supply chain','11/13/2015');
|
---|
54 |
|
---|
55 | INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Transport Human Resources','Person who will work with human resources in the transport department','10/25/2015');
|
---|
56 |
|
---|
57 |
|
---|
58 | INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant)
|
---|
59 | VALUES ('1111111111111','Angelina','Jolie');
|
---|
60 |
|
---|
61 | INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant)
|
---|
62 | VALUES ('1111111111112','Brad','Pitt');
|
---|
63 |
|
---|
64 | INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant)
|
---|
65 | VALUES ('1111111111113','George','Clooney');
|
---|
66 |
|
---|
67 | INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant)
|
---|
68 | VALUES ('1111111111114','Jesica','Alba');
|
---|
69 |
|
---|
70 | INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant)
|
---|
71 | VALUES ('1111111111115','Vladimir','Putin');
|
---|
72 |
|
---|
73 | INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant)
|
---|
74 | VALUES ('1111111111116','Barack','Obama');
|
---|
75 |
|
---|
76 | INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant)
|
---|
77 | VALUES ('1111111111117','Angela','Merkel');
|
---|
78 |
|
---|
79 | INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant)
|
---|
80 | VALUES ('1111111111118','Karolina','Gocheva');
|
---|
81 |
|
---|
82 | INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant)
|
---|
83 | VALUES ('1111111111119','Vlado','Janevski');
|
---|
84 |
|
---|
85 | INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant)
|
---|
86 | VALUES ('1111111111110','Cristiano','Ronaldo');
|
---|
87 |
|
---|
88 | INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant)
|
---|
89 | VALUES ('1111111111120','De','Gea');
|
---|
90 |
|
---|
91 | INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant)
|
---|
92 | VALUES ('1111111111121','Salma','Hayek');
|
---|
93 |
|
---|
94 |
|
---|
95 | INSERT INTO JobsApplicants (IdJob,IdApplicant)
|
---|
96 | VALUES ('29','1111111111112');
|
---|
97 |
|
---|
98 | INSERT INTO JobsApplicants (IdJob,IdApplicant)
|
---|
99 | VALUES ('29','1111111111111');
|
---|
100 |
|
---|
101 | INSERT INTO JobsApplicants (IdJob,IdApplicant)
|
---|
102 | VALUES ('32','1111111111110');
|
---|
103 |
|
---|
104 | INSERT INTO JobsApplicants (IdJob,IdApplicant)
|
---|
105 | VALUES ('33','1111111111113');
|
---|
106 |
|
---|
107 | INSERT INTO JobsApplicants (IdJob,IdApplicant)
|
---|
108 | VALUES ('33','1111111111114');
|
---|
109 |
|
---|
110 | INSERT INTO JobsApplicants (IdJob,IdApplicant)
|
---|
111 | VALUES ('33','1111111111115');
|
---|
112 |
|
---|
113 | INSERT INTO JobsApplicants (IdJob,IdApplicant)
|
---|
114 | VALUES ('34','1111111111116');
|
---|
115 |
|
---|
116 | INSERT INTO JobsApplicants (IdJob,IdApplicant)
|
---|
117 | VALUES ('34','1111111111117');
|
---|
118 |
|
---|
119 | INSERT INTO JobsApplicants (IdJob,IdApplicant)
|
---|
120 | VALUES ('35','1111111111118');
|
---|
121 |
|
---|
122 | INSERT INTO JobsApplicants (IdJob,IdApplicant)
|
---|
123 | VALUES ('35','1111111111119');
|
---|
124 |
|
---|
125 | INSERT INTO JobsApplicants (IdJob,IdApplicant)
|
---|
126 | VALUES ('35','1111111111120');
|
---|
127 |
|
---|
128 | INSERT INTO JobsApplicants (IdJob,IdApplicant)
|
---|
129 | VALUES ('35','1111111111121');
|
---|
130 |
|
---|
131 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
132 | VALUES ('2222222222220','Bill','Clinton','Macedonia','Air cabin crew','active');
|
---|
133 |
|
---|
134 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
135 | VALUES ('2222222222221','Chuck','Noris','Macedonia','Airline customer agent','active');
|
---|
136 |
|
---|
137 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
138 | VALUES ('2222222222222','Ana','Atanasova','Macedonia','Administrator','active');
|
---|
139 |
|
---|
140 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
141 | VALUES ('2222222222223','Goran','Lazarov','Macedonia','Administrator','active');
|
---|
142 |
|
---|
143 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
144 | VALUES ('2222222222224','Filip','Davkovski','Macedonia','Administrator','active');
|
---|
145 |
|
---|
146 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
147 | VALUES ('2222222222225','Ivona','Lazarovska','Macedonia','Supply chain manager','active');
|
---|
148 |
|
---|
149 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
150 | VALUES ('5222222222225','Ivona','Jolie','Macedonia','Supply chain manager','active');
|
---|
151 |
|
---|
152 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
153 | VALUES ('2222222222226','Vase','Pandev','Macedonia','Transport Human Resources','active');
|
---|
154 |
|
---|
155 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
156 | VALUES ('2222222222227','Martin','Donovan','Macedonia','Air Human Resources','active');
|
---|
157 |
|
---|
158 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
159 | VALUES ('2222222222228','Bruce','Willis','Macedonia','Airport information','active');
|
---|
160 |
|
---|
161 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
162 | VALUES ('2222222222229','Jackie','Chan','Macedonia','Bus or coach driver','active');
|
---|
163 |
|
---|
164 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
165 | VALUES ('1222222222228','George','Will','Macedonia','Transport Human Resources','active');
|
---|
166 |
|
---|
167 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
168 | VALUES ('1222222222229','Jackie','Willis','Macedonia','Supply chain manager','active');
|
---|
169 |
|
---|
170 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
171 | VALUES ('2222222222230','Richard','Gere','Macedonia','Air cabin crew','Fired');
|
---|
172 |
|
---|
173 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
174 | VALUES ('2222222222231','Selena','Gomez','Macedonia','Airline customer agent','Fired');
|
---|
175 |
|
---|
176 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
177 | VALUES ('2222222222233','Bob','Dylan','Macedonia','Transport Human Resources','Fired');
|
---|
178 |
|
---|
179 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
180 | VALUES ('2222222222234','Boby','Gomez','Macedonia','Supply chain manager','Fired');
|
---|
181 |
|
---|
182 | INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status])
|
---|
183 | VALUES ('2222222222235','Justin','Tmberlake','Macedonia','Transport Human Resources','Fired');
|
---|
184 |
|
---|
185 |
|
---|
186 |
|
---|
187 |
|
---|
188 |
|
---|
189 | INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag)
|
---|
190 | VALUES ('Ana','atanasova','Admin','2222222222222',3);
|
---|
191 |
|
---|
192 | INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag)
|
---|
193 | VALUES ('Filip','davkovski','Admin','2222222222224',3);
|
---|
194 |
|
---|
195 | INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag)
|
---|
196 | VALUES ('Goran','lazarov','Admin','2222222222223',3);
|
---|
197 |
|
---|
198 | INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag)
|
---|
199 | VALUES ('Ivona','Lazarovska','Manager','2222222222225',2);
|
---|
200 |
|
---|
201 | INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag)
|
---|
202 | VALUES ('Vase','Pandev','HR','2222222222226',1);
|
---|
203 |
|
---|
204 | INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag)
|
---|
205 | VALUES ('Martin','Donovan','HR','2222222222227',3);
|
---|
206 |
|
---|
207 | INSERT INTO [User] ([Role],idEmployee,AccountFlag)
|
---|
208 | VALUES ('HR','1222222222228',1);
|
---|
209 |
|
---|
210 | INSERT INTO [User] ([Role],idEmployee,AccountFlag)
|
---|
211 | VALUES ('Manager','1222222222229',2);
|
---|
212 |
|
---|
213 | INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag)
|
---|
214 | VALUES ('Bob','dylan','HR','2222222222233',0);
|
---|
215 |
|
---|
216 | INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag)
|
---|
217 | VALUES ('Boby','pass','Manager','2222222222234',0);
|
---|
218 |
|
---|
219 | INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag)
|
---|
220 | VALUES ('Justin','password','HR','2222222222235',0);
|
---|
221 |
|
---|
222 | INSERT INTO [User] (UserName,[Password],[Role],idEmployee,AccountFlag)
|
---|
223 | VALUES ('Iv','ivonaa','HR','5222222222225',2);
|
---|
224 |
|
---|
225 | INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating)
|
---|
226 | VALUES ('2222222222220','administrative',5.00);
|
---|
227 |
|
---|
228 | INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating)
|
---|
229 | VALUES ('2222222222222','communication',5.00);
|
---|
230 |
|
---|
231 | INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating)
|
---|
232 | VALUES ('2222222222223','driving',10.00);
|
---|
233 |
|
---|
234 | INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating)
|
---|
235 | VALUES ('2222222222221','customer Service',5.00);
|
---|
236 |
|
---|
237 | INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating)
|
---|
238 | VALUES ('2222222222221','administrative',10.00);
|
---|
239 |
|
---|
240 | INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating)
|
---|
241 | VALUES ('1222222222228','customer Service',10.00);
|
---|
242 |
|
---|
243 | INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating)
|
---|
244 | VALUES ('2222222222221','communication',10.00);
|
---|
245 |
|
---|
246 | INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating)
|
---|
247 | VALUES ('2222222222229','driving',10.00);
|
---|
248 |
|
---|
249 | INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating)
|
---|
250 | VALUES ('2222222222220','problem solving',8.00);
|
---|
251 |
|
---|
252 | INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating)
|
---|
253 | VALUES ('1222222222228','problem solving',8.00);
|
---|
254 |
|
---|
255 | INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating)
|
---|
256 | VALUES ('1222222222228','mechanics',7.00);
|
---|
257 |
|
---|
258 | INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating)
|
---|
259 | VALUES ('1222222222229','electronics',6.00);
|
---|
260 |
|
---|