[platal.git] / upgrade / 1.0.1 / 99_jobs.sql.postphp

ALTER TABLE profile_job DROP COLUMN sectorid;
ALTER TABLE profile_job DROP COLUMN subsectorid;
ALTER TABLE profile_job DROP COLUMN subsubsectorid;
DROP TABLE profile_mentor_sector;
DROP TABLE profile_job_sector_enum;
DROP TABLE profile_job_subsector_enum;
DROP TABLE profile_job_subsubsector_enum;
DROP TABLE profile_job_alternates;

-- vim:set syntax=mysql:
Commit	Line	Data
9d289116 SJ	1	ALTER TABLE profile_job DROP COLUMN sectorid;
	2	ALTER TABLE profile_job DROP COLUMN subsectorid;
	3	ALTER TABLE profile_job DROP COLUMN subsubsectorid;
da40b2a4 SJ	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;
ea9cfc3e SJ	9
ea9cfc3e SJ	10	-- vim:set syntax=mysql: