ALTER TABLE mantis_bug_file_table ALTER COLUMN content DROP NOT NULL;
ALTER TABLE mantis_project_file_table ALTER COLUMN content DROP NOT NULL;

ALTER TABLE mantis_bug_table ALTER COLUMN sticky DROP DEFAULT;
ALTER TABLE mantis_bug_table ALTER sticky TYPE bool USING CASE WHEN sticky=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_bug_table ALTER COLUMN sticky SET DEFAULT FALSE;

ALTER TABLE mantis_custom_field_table ALTER COLUMN advanced DROP DEFAULT;
ALTER TABLE mantis_custom_field_table ALTER advanced TYPE bool USING CASE WHEN advanced=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_custom_field_table ALTER COLUMN advanced SET DEFAULT FALSE;

ALTER TABLE mantis_custom_field_table ALTER COLUMN require_report DROP DEFAULT;
ALTER TABLE mantis_custom_field_table ALTER require_report TYPE bool USING CASE WHEN require_report=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_custom_field_table ALTER COLUMN require_report SET DEFAULT FALSE;

ALTER TABLE mantis_custom_field_table ALTER COLUMN require_update DROP DEFAULT;
ALTER TABLE mantis_custom_field_table ALTER require_update TYPE bool USING CASE WHEN require_update=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_custom_field_table ALTER COLUMN require_update SET DEFAULT FALSE;

ALTER TABLE mantis_custom_field_table ALTER COLUMN display_report DROP DEFAULT;
ALTER TABLE mantis_custom_field_table ALTER display_report TYPE bool USING CASE WHEN display_report=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_custom_field_table ALTER COLUMN display_report SET DEFAULT TRUE;

ALTER TABLE mantis_custom_field_table ALTER COLUMN display_update DROP DEFAULT;
ALTER TABLE mantis_custom_field_table ALTER display_update TYPE bool USING CASE WHEN display_update=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_custom_field_table ALTER COLUMN display_update SET DEFAULT TRUE;

ALTER TABLE mantis_custom_field_table ALTER COLUMN require_resolved DROP DEFAULT;
ALTER TABLE mantis_custom_field_table ALTER require_resolved TYPE bool USING CASE WHEN require_resolved=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_custom_field_table ALTER COLUMN require_resolved SET DEFAULT FALSE;

ALTER TABLE mantis_custom_field_table ALTER COLUMN display_resolved DROP DEFAULT;
ALTER TABLE mantis_custom_field_table ALTER display_resolved TYPE bool USING CASE WHEN display_resolved=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_custom_field_table ALTER COLUMN display_resolved SET DEFAULT FALSE;

ALTER TABLE mantis_custom_field_table ALTER COLUMN display_closed DROP DEFAULT;
ALTER TABLE mantis_custom_field_table ALTER display_closed TYPE bool USING CASE WHEN display_closed=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_custom_field_table ALTER COLUMN display_closed SET DEFAULT FALSE;

ALTER TABLE mantis_custom_field_table ALTER COLUMN require_closed DROP DEFAULT;
ALTER TABLE mantis_custom_field_table ALTER require_closed TYPE bool USING CASE WHEN require_closed=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_custom_field_table ALTER COLUMN require_closed SET DEFAULT FALSE;

ALTER TABLE mantis_filters_table ALTER COLUMN is_public DROP DEFAULT;
ALTER TABLE mantis_filters_table ALTER is_public TYPE bool USING CASE WHEN is_public=0 THEN FALSE ELSE TRUE END;

ALTER TABLE mantis_news_table ALTER COLUMN announcement DROP DEFAULT;
ALTER TABLE mantis_news_table ALTER announcement TYPE bool USING CASE WHEN announcement=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_news_table ALTER COLUMN announcement SET DEFAULT FALSE;

ALTER TABLE mantis_project_table ALTER COLUMN enabled DROP DEFAULT;
ALTER TABLE mantis_project_table ALTER enabled TYPE bool USING CASE WHEN enabled=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_project_table ALTER COLUMN enabled SET DEFAULT TRUE;

ALTER TABLE mantis_project_version_table ALTER COLUMN released DROP DEFAULT;
ALTER TABLE mantis_project_version_table ALTER released TYPE bool USING CASE WHEN released=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_project_version_table ALTER COLUMN released SET DEFAULT TRUE;

ALTER TABLE mantis_sponsorship_table ALTER COLUMN paid DROP DEFAULT;
ALTER TABLE mantis_sponsorship_table ALTER paid TYPE bool USING CASE WHEN paid=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_sponsorship_table ALTER COLUMN paid SET DEFAULT FALSE;

ALTER TABLE mantis_user_pref_table ALTER COLUMN advanced_report DROP DEFAULT;
ALTER TABLE mantis_user_pref_table ALTER advanced_report TYPE bool USING CASE WHEN advanced_report=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_user_pref_table ALTER COLUMN advanced_report SET DEFAULT FALSE;

ALTER TABLE mantis_user_pref_table ALTER COLUMN advanced_view DROP DEFAULT;
ALTER TABLE mantis_user_pref_table ALTER advanced_view TYPE bool USING CASE WHEN advanced_view=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_user_pref_table ALTER COLUMN advanced_view SET DEFAULT FALSE;

ALTER TABLE mantis_user_pref_table ALTER COLUMN advanced_update DROP DEFAULT;
ALTER TABLE mantis_user_pref_table ALTER advanced_update TYPE bool USING CASE WHEN advanced_update=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_user_pref_table ALTER COLUMN advanced_update SET DEFAULT FALSE;

ALTER TABLE mantis_user_pref_table ALTER COLUMN redirect_delay DROP DEFAULT;
ALTER TABLE mantis_user_pref_table ALTER redirect_delay TYPE bool USING CASE WHEN redirect_delay=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_user_pref_table ALTER COLUMN redirect_delay SET DEFAULT FALSE;

ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_new DROP DEFAULT;
ALTER TABLE mantis_user_pref_table ALTER email_on_new TYPE bool USING CASE WHEN email_on_new=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_new SET DEFAULT FALSE;

ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_assigned DROP DEFAULT;
ALTER TABLE mantis_user_pref_table ALTER email_on_assigned TYPE bool USING CASE WHEN email_on_assigned=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_assigned SET DEFAULT FALSE;

ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_feedback DROP DEFAULT;
ALTER TABLE mantis_user_pref_table ALTER email_on_feedback TYPE bool USING CASE WHEN email_on_feedback=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_feedback SET DEFAULT FALSE;

ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_resolved DROP DEFAULT;
ALTER TABLE mantis_user_pref_table ALTER email_on_resolved TYPE bool USING CASE WHEN email_on_resolved=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_resolved SET DEFAULT FALSE;

ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_closed DROP DEFAULT;
ALTER TABLE mantis_user_pref_table ALTER email_on_closed TYPE bool USING CASE WHEN email_on_closed=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_closed SET DEFAULT FALSE;

ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_reopened DROP DEFAULT;
ALTER TABLE mantis_user_pref_table ALTER email_on_reopened TYPE bool USING CASE WHEN email_on_reopened=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_reopened SET DEFAULT FALSE;

ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_bugnote DROP DEFAULT;
ALTER TABLE mantis_user_pref_table ALTER email_on_bugnote TYPE bool USING CASE WHEN email_on_bugnote=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_bugnote SET DEFAULT FALSE;

ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_status DROP DEFAULT;
ALTER TABLE mantis_user_pref_table ALTER email_on_status TYPE bool USING CASE WHEN email_on_status=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_status SET DEFAULT FALSE;

ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_priority DROP DEFAULT;
ALTER TABLE mantis_user_pref_table ALTER email_on_priority TYPE bool USING CASE WHEN email_on_priority=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_user_pref_table ALTER COLUMN email_on_priority SET DEFAULT FALSE;

ALTER TABLE mantis_user_table ALTER COLUMN enabled DROP DEFAULT;
ALTER TABLE mantis_user_table ALTER enabled TYPE bool USING CASE WHEN enabled=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_user_table ALTER COLUMN enabled SET DEFAULT TRUE;

ALTER TABLE mantis_user_table ALTER COLUMN protected DROP DEFAULT;
ALTER TABLE mantis_user_table ALTER protected TYPE bool USING CASE WHEN protected=0 THEN FALSE ELSE TRUE END;
ALTER TABLE mantis_user_table ALTER COLUMN protected SET DEFAULT FALSE;