extendtable.sql

企业人事管理系统主要功能有： ①人事档案管理：户口状况、政治面貌、生理状况、合同管理等； ②考勤加班出差管理； ③人事变动：新进员工登记、员工离职登记、人事变更记录； ④考核奖惩； ⑤员工培

insert into ExtendTable
values('1001','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1001','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1001','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1001','2006-6-4','正常','有','无','无')
insert into ExtendTable
values('1001','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1001','2006-6-6','正常','无','无','人事技能培训')
insert into ExtendTable
values('1001','2006-6-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1001','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1001','2006-6-9','迟到','有','无','无')
insert into ExtendTable
values('1001','2006-6-10','正常','有','无','无')

insert into ExtendTable
values('1002','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1002','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1002','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1002','2006-6-4','正常','有','无','无')
insert into ExtendTable
values('1002','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1002','2006-6-6','正常','无','无','人事技能培训')
insert into ExtendTable
values('1002','2006-6-7','迟到','无','无','无')
insert into ExtendTable
values('1002','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1002','2006-6-9','迟到','有','泄露机密罚款','无')
insert into ExtendTable
values('1002','2006-6-10','正常','有','无','无')

insert into ExtendTable
values('1003','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1003','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1003','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1003','2006-6-4','正常','有','无','无')
insert into ExtendTable
values('1003','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1003','2006-6-6','迟到','无','无','无')
insert into ExtendTable
values('1003','2006-6-7','迟到','无','无','无')
insert into ExtendTable
values('1003','2006-6-8','正常','无','无','无')
insert into ExtendTable
values('1003','2006-6-9','迟到','有','无','无')
insert into ExtendTable
values('1003','2006-6-10','正常','有','无','人事技能培训')

insert into ExtendTable
values('1004','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1004','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1004','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1004','2006-6-4','正常','有','无','无')
insert into ExtendTable
values('1004','2006-6-5','正常','有','无','人事技能培训')
insert into ExtendTable
values('1004','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1004','2006-6-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1004','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1004','2006-6-9','迟到','有','无','无')
insert into ExtendTable
values('1004','2006-6-10','正常','有','无','无')

insert into ExtendTable
values('1005','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1005','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1005','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1005','2006-6-4','正常','有','无','无')
insert into ExtendTable
values('1005','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1005','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1005','2006-6-7','正常','无','无','无')
insert into ExtendTable
values('1005','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1005','2006-6-9','迟到','有','无','无')
insert into ExtendTable
values('1005','2006-6-10','正常','有','无','人事技能培训')

insert into ExtendTable
values('1006','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1006','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1006','2006-6-3','正常','有','无','无')
insert into ExtendTable
values('1006','2006-6-4','正常','有','无','无')
insert into ExtendTable
values('1006','2006-6-5','正常','有','先进个人','无')
insert into ExtendTable
values('1006','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1006','2006-6-7','迟到','无','无','无')
insert into ExtendTable
values('1006','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1006','2006-6-9','迟到','有','泄露机密罚款','无')
insert into ExtendTable
values('1006','2006-6-10','正常','有','无','维护技能培训')

insert into ExtendTable
values('1007','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1007','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1007','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1007','2006-6-4','正常','有','无','无')
insert into ExtendTable
values('1007','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1007','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1007','2006-6-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1007','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1007','2006-6-9','迟到','有','无','维护技能培训')
insert into ExtendTable
values('1007','2006-6-10','正常','有','无','无')

insert into ExtendTable
values('1008','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1008','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1008','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1008','2006-6-4','正常','有','无','无')
insert into ExtendTable
values('1008','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1008','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1008','2006-6-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1008','2006-6-8','出差','无','无','维护技能培训')
insert into ExtendTable
values('1008','2006-6-9','迟到','有','无','无')
insert into ExtendTable
values('1008','2006-6-10','正常','有','无','无')

insert into ExtendTable
values('1009','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1009','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1009','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1009','2006-6-4','正常','有','无','无')
insert into ExtendTable
values('1009','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1009','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1009','2006-6-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1009','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1009','2006-6-9','迟到','有','无','无')
insert into ExtendTable
values('1009','2006-6-10','正常','有','无','维护技能培训')

insert into ExtendTable
values('1010','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1010','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1010','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1010','2006-6-4','正常','有','无','维护技能培训')
insert into ExtendTable
values('1010','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1010','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1010','2006-6-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1010','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1010','2006-6-9','迟到','有','泄露机密罚款','无')
insert into ExtendTable
values('1010','2006-6-10','正常','有','无','维护技能培训')

insert into ExtendTable
values('1011','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1011','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1011','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1011','2006-6-4','正常','有','无','策划技能培训')
insert into ExtendTable
values('1011','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1011','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1011','2006-6-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1011','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1011','2006-6-9','迟到','有','无','无')
insert into ExtendTable
values('1011','2006-6-10','正常','有','无','策划技能培训')

insert into ExtendTable
values('1012','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1012','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1012','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1012','2006-6-4','正常','有','无','策划技能培训')
insert into ExtendTable
values('1012','2006-6-5','正常','有','无','策划技能培训')
insert into ExtendTable
values('1012','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1012','2006-6-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1012','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1012','2006-6-9','迟到','有','泄露机密罚款','无')
insert into ExtendTable
values('1012','2006-6-10','正常','有','无','策划技能培训')

insert into ExtendTable
values('1013','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1013','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1013','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1013','2006-6-4','正常','有','无','无')
insert into ExtendTable
values('1013','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1013','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1013','2006-6-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1013','2006-6-8','出差','无','泄露机密罚款','无')
insert into ExtendTable
values('1013','2006-6-9','迟到','有','无','无')
insert into ExtendTable
values('1013','2006-6-10','正常','有','无','无')

insert into ExtendTable
values('1014','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1014','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1014','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1014','2006-6-4','正常','有','无','策划技能培训')
insert into ExtendTable
values('1014','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1014','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1014','2006-6-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1014','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1014','2006-6-9','迟到','有','无','无')
insert into ExtendTable
values('1014','2006-6-10','正常','有','无','策划技能培训')

insert into ExtendTable
values('1015','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1015','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1015','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1015','2006-6-4','正常','有','无','无')
insert into ExtendTable
values('1015','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1015','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1015','2006-6-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1015','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1015','2006-6-9','迟到','有','无','无')
insert into ExtendTable
values('1015','2006-6-10','正常','有','无','无')

insert into ExtendTable
values('1016','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1016','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1016','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1016','2006-6-4','正常','有','无','物流技能培训')
insert into ExtendTable
values('1016','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1016','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1016','2006-6-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1016','2006-6-8','出差','无','无','无')
insert into ExtendTable