update_enum_values.sql

-- Update the values to match Java enums
UPDATE prospects 
SET industry = 'HealthCare' 
WHERE industry = 'Health Care';

UPDATE prospects 
SET industry = 'SupplyChain' 
WHERE industry = 'Supply Chain';

UPDATE activities 
SET activity_type = 'TeamCreated' 
WHERE activity_type = 'Team Created';

UPDATE activities 
SET activity_type = 'LicenseCreated' 
WHERE activity_type = 'License Created';

-- Update the CHECK constraints to match
ALTER TABLE prospects 
    DROP CONSTRAINT IF EXISTS prospects_industry_check,
    ADD CONSTRAINT prospects_industry_check 
    CHECK (industry IN ('Fintech', 'Telecomunication', 'Banking', 'Automotive', 'HealthCare', 'Manufacturing', 'SupplyChain'));

ALTER TABLE activities 
    DROP CONSTRAINT IF EXISTS activities_activity_type_check,
    ADD CONSTRAINT activities_activity_type_check 
    CHECK (activity_type IN ('TeamCreated', 'Meeting', 'MOM', 'LicenseCreated', 'Other'));