-- Add transcript summary fields to candidate table
ALTER TABLE app.candidate_transcript
    ADD COLUMN ai_is_nursing_focus BOOLEAN,
    ADD COLUMN ai_has_theory_hours BOOLEAN,
    ADD COLUMN ai_has_practice_hours BOOLEAN,
    ADD COLUMN is_nursing_focus BOOLEAN,
    ADD COLUMN has_theory_hours BOOLEAN,
    ADD COLUMN has_practice_hours BOOLEAN;

CREATE TYPE app.nurse_recognition_home_country AS ENUM (
    'nurse',
    'assistant_nurse',
    'nursing_helper',
    'none'
);

ALTER TYPE app.nurse_recognition RENAME TO nurse_recognition_germany;

-- Change qualification_status_home_country to use the new enum type
ALTER TABLE app.candidate
    ALTER COLUMN qualification_status_home_country TYPE app.nurse_recognition_home_country
    USING qualification_status_home_country::text::app.nurse_recognition_home_country;

DROP TABLE app.candidate_transcript_course;

-- Add transcript summary fields to candidate table
ALTER TABLE app.candidate
    DROP COLUMN transcripts_total_hours,
    DROP COLUMN transcripts_total_theory_hours,
    DROP COLUMN transcripts_total_practice_hours,
    DROP COLUMN transcripts_theory_and_practice,
    DROP COLUMN transcripts_structured_training,
    ADD COLUMN transcripts_has_duration BOOLEAN;