-- add field workPermitRequired on worker UPDATE worker SET workPermitRequired = 0 GO ALTER TABLE worker ALTER COLUMN workPermitRequired [tinyint] NOT NULL GO -- add field visaRequired on worker UPDATE worker SET visaRequired = 0 GO ALTER TABLE worker ALTER COLUMN visaRequired [tinyint] NOT NULL GO -- add field residentCardRequired on worker UPDATE worker SET residentCardRequired = 0 GO ALTER TABLE worker ALTER COLUMN residentCardRequired [tinyint] NOT NULL GO
Changer 9 par group de l'agence à migrer <!-- Migration Job To Qualification --> insert into qualification (evaluation,creationDate,templateId,workerQualificationId, linkToJobId) select 0, job.creationDate, templateId, workerJobId, id from job, worker where templateId is not null and job.workerJobId=worker.workerId and worker.defaultGroupId=9; <!-- Migration Qualificationtemplate To Qualification --> insert into qualification (evaluation,creationDate,templateId,workerQualificationId, linkToQualificationTemplateId) select 0, worker.creationDate, elt, worker_qualificationtemplate.workerId, elt from worker_qualificationtemplate, worker where worker.workerId=worker_qualificationtemplate.workerId and worker.defaultGroupId=9; <!-- Migration ProfessionalDevelopment to Qualification --> insert into qualification (evaluation,creationDate,templateId,workerQualificationId, linkToProfessionalDevelopmentTypeJobId) select 0, professionaldevelopment.creationDate, qualificationTemplate, professionalDevelopmentId,professionaldevelopmenttypejob.id from professionaldevelopment, professionaldevelopmenttypejob, worker where professionaldevelopment.professionalDevelopmentTypeId=professionaldevelopmenttypejob.id and professionalDevelopmentId=worker.workerId and worker.defaultGroupId=9;