Dirk Vogt | 8e4fe81 | 2017-10-09 15:19:06 +0200 | [diff] [blame] | 1 | ALTER TABLE auth_user ALTER COLUMN is_superuser DROP DEFAULT; |
| 2 | ALTER TABLE auth_user ALTER is_superuser TYPE bool USING CASE WHEN is_superuser=0 THEN FALSE ELSE TRUE END; |
| 3 | ALTER TABLE auth_user ALTER COLUMN is_superuser SET DEFAULT FALSE; |
| 4 | |
| 5 | ALTER TABLE auth_user ALTER COLUMN is_active DROP DEFAULT; |
| 6 | ALTER TABLE auth_user ALTER is_active TYPE bool USING CASE WHEN is_active=0 THEN FALSE ELSE TRUE END; |
| 7 | ALTER TABLE auth_user ALTER COLUMN is_active SET DEFAULT FALSE; |
| 8 | |
| 9 | ALTER TABLE auth_user ALTER COLUMN is_staff DROP DEFAULT; |
| 10 | ALTER TABLE auth_user ALTER is_staff TYPE bool USING CASE WHEN is_staff=0 THEN FALSE ELSE TRUE END; |
| 11 | ALTER TABLE auth_user ALTER COLUMN is_staff SET DEFAULT FALSE; |
| 12 | |
| 13 | ALTER TABLE account_emailaddress ALTER COLUMN "primary" DROP DEFAULT; |
| 14 | ALTER TABLE account_emailaddress ALTER "primary" TYPE bool USING CASE WHEN "primary"=0 THEN FALSE ELSE TRUE END; |
| 15 | ALTER TABLE account_emailaddress ALTER COLUMN "primary" SET DEFAULT FALSE; |
| 16 | |
| 17 | ALTER TABLE account_emailaddress ALTER COLUMN verified DROP DEFAULT; |
| 18 | ALTER TABLE account_emailaddress ALTER verified TYPE bool USING CASE WHEN verified=0 THEN FALSE ELSE TRUE END; |
| 19 | ALTER TABLE account_emailaddress ALTER COLUMN verified SET DEFAULT FALSE; |
| 20 | |
| 21 | ALTER TABLE crashreports_crashreport ALTER COLUMN is_fake_report DROP DEFAULT; |
| 22 | ALTER TABLE crashreports_crashreport ALTER is_fake_report TYPE bool USING CASE WHEN is_fake_report=0 THEN FALSE ELSE TRUE END; |
| 23 | ALTER TABLE crashreports_crashreport ALTER COLUMN is_fake_report SET DEFAULT FALSE; |
| 24 | |
| 25 | ALTER TABLE crashreport_stats_version ALTER COLUMN is_official_release DROP DEFAULT; |
| 26 | ALTER TABLE crashreport_stats_version ALTER is_official_release TYPE bool USING CASE WHEN is_official_release=0 THEN FALSE ELSE TRUE END; |
| 27 | ALTER TABLE crashreport_stats_version ALTER COLUMN is_official_release SET DEFAULT FALSE; |
| 28 | |
| 29 | ALTER TABLE crashreport_stats_version ALTER COLUMN is_beta_release DROP DEFAULT; |
| 30 | ALTER TABLE crashreport_stats_version ALTER is_beta_release TYPE bool USING CASE WHEN is_beta_release=0 THEN FALSE ELSE TRUE END; |
| 31 | ALTER TABLE crashreport_stats_version ALTER COLUMN is_beta_release SET DEFAULT FALSE; |