alexx876

Untitled

Apr 19th, 2021
527
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. alter table users drop column emailconf;
  2. alter table users drop column vk_notifications;
  3. alter table users drop column package_bonus;
  4.  
  5.  
  6. alter table tasks alter column text type varchar(10000) using text::varchar(10000);
  7. alter table tasks alter column photos type json using photos::json;
  8. alter table tasks alter column repost type varchar(255) using repost::varchar(255);
  9.  
  10. alter table tasks alter column hide drop default;
  11. ALTER TABLE tasks ALTER hide TYPE boolean USING
  12.     CASE WHEN hide=0 THEN FALSE
  13.          ELSE TRUE
  14.         END;
  15. alter table tasks alter column hide set default false;
  16.  
  17. alter table tasks alter column parse_users drop default;
  18. ALTER TABLE tasks ALTER parse_users TYPE boolean USING
  19.     CASE WHEN parse_users=0 THEN FALSE
  20.          ELSE TRUE
  21.         END;
  22. alter table tasks alter column parse_users set default false;
  23.  
  24. alter table creatives alter column text type varchar(10000) using text::varchar(10000);
  25. alter table creatives alter column photos type json using photos::json;
  26. alter table creatives alter column repost type varchar(255) using repost::varchar(255);
  27.  
  28. alter table creatives alter column parse_users drop default;
  29. ALTER TABLE creatives ALTER parse_users TYPE boolean USING
  30.     CASE WHEN parse_users=0 THEN FALSE
  31.          ELSE TRUE
  32.         END;
  33. alter table creatives alter column parse_users set default false;
  34.  
  35.  
  36.  
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×