-- Direct SQL fix for missing M2M table
-- Run this directly on the production MySQL database

CREATE TABLE IF NOT EXISTS candidates_candidateprofile_preferred_abroad_categories (
    id bigint AUTO_INCREMENT NOT NULL PRIMARY KEY,
    candidateprofile_id bigint NOT NULL,
    abroadjobcategory_id bigint NOT NULL,
    CONSTRAINT candidates_candidateprofile_preferred_abroad_categories_candidateprofile_id_fk 
        FOREIGN KEY (candidateprofile_id) REFERENCES candidates_candidateprofile (id) ON DELETE CASCADE,
    CONSTRAINT candidates_candidateprofile_preferred_abroad_categories_abroadjobcategory_id_fk 
        FOREIGN KEY (abroadjobcategory_id) REFERENCES candidates_abroadjobcategory (id) ON DELETE CASCADE,
    UNIQUE KEY unique_cand_abroad_cat (candidateprofile_id, abroadjobcategory_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;