Deletes all references to sectors as they have been replaced by jobterms.
[platal.git] / upgrade / 1.0.1 / 99_jobs.sql
1 ALTER TABLE profile_job DROP COLUMN sectorid;
2 ALTER TABLE profile_job DROP COLUMN subsectorid;
3 ALTER TABLE profile_job DROP COLUMN subsubsectorid;
4 DROP TABLE profile_mentor_sector;
5 DROP TABLE profile_job_sector_enum;
6 DROP TABLE profile_job_subsector_enum;
7 DROP TABLE profile_job_subsubsector_enum;
8 DROP TABLE profile_job_alternates;
9
10 -- vim:set syntax=mysql: