-- A member's country preference is only set when they actually pick one, -- so geo-detection isn't overridden by a default nobody chose. ALTER TABLE "User" ALTER COLUMN "favoriteCountry" DROP NOT NULL; ALTER TABLE "User" ALTER COLUMN "favoriteCountry" DROP DEFAULT; UPDATE "User" SET "favoriteCountry" = NULL WHERE "favoriteCountry" = 'CA-QC';