-- =====================================================
-- MIGRATION: Convert sub_program_type from enum to varchar
-- REASON: Allow free-form sub program type values so new
--         types can be added without a schema migration.
-- TABLES: program, user_participation_summary, program_type_v1
-- =====================================================

ALTER TABLE program_v1
  ALTER COLUMN sub_program_type TYPE VARCHAR(50);

ALTER TABLE user_participation_summary
  ALTER COLUMN sub_program_type TYPE VARCHAR(50);

ALTER TABLE program_type_v1
  ALTER COLUMN sub_program_type TYPE VARCHAR(50);
