22 lines
867 B
SQL
22 lines
867 B
SQL
-- Create professional_recognition_status enum if it doesn't exist
|
|
DO $$
|
|
BEGIN
|
|
IF NOT EXISTS (SELECT 1 FROM pg_type WHERE typname = 'professional_recognition_status') THEN
|
|
CREATE TYPE app.professional_recognition_status AS ENUM ('NOT_STARTED', 'IN_PROGRESS', 'COMPLETED');
|
|
END IF;
|
|
END $$;
|
|
|
|
-- Create language_code enum if it doesn't exist
|
|
DO $$
|
|
BEGIN
|
|
IF NOT EXISTS (SELECT 1 FROM pg_type WHERE typname = 'language_code') THEN
|
|
CREATE TYPE app.language_code AS ENUM ('en', 'ar', 'bs', 'fil', 'hi', 'es', 'tr', 'uk', 'vi');
|
|
END IF;
|
|
END $$;
|
|
|
|
-- Add columns to candidate table for applicant profile
|
|
ALTER TABLE app.candidate
|
|
ADD COLUMN IF NOT EXISTS professional_recognition_status app.professional_recognition_status,
|
|
ADD COLUMN IF NOT EXISTS nationality VARCHAR,
|
|
ADD COLUMN IF NOT EXISTS languages_spoken app.language_code[];
|