alter table users drop column emailconf;
alter table users drop column vk_notifications;
alter table users drop column package_bonus;


alter table tasks alter column text type varchar(10000) using text::varchar(10000);
alter table tasks alter column photos type json using photos::json;
alter table tasks alter column repost type varchar(255) using repost::varchar(255);

alter table tasks alter column hide drop default;
ALTER TABLE tasks ALTER hide TYPE boolean USING
    CASE WHEN hide=0 THEN FALSE
         ELSE TRUE
        END;
alter table tasks alter column hide set default false;

alter table tasks alter column parse_users drop default;
ALTER TABLE tasks ALTER parse_users TYPE boolean USING
    CASE WHEN parse_users=0 THEN FALSE
         ELSE TRUE
        END;
alter table tasks alter column parse_users set default false;

alter table creatives alter column text type varchar(10000) using text::varchar(10000);
alter table creatives alter column photos type json using photos::json;
alter table creatives alter column repost type varchar(255) using repost::varchar(255);

alter table creatives alter column parse_users drop default;
ALTER TABLE creatives ALTER parse_users TYPE boolean USING
    CASE WHEN parse_users=0 THEN FALSE
         ELSE TRUE
        END;
alter table creatives alter column parse_users set default false;