Project

General

Profile

1
ALTER TABLE "newWorldCountries"
2
  ALTER COLUMN "isoCode" TYPE text
3
, ALTER COLUMN "isNewWorld" DROP DEFAULT
4
, ALTER COLUMN "isNewWorld" TYPE boolean USING "isNewWorld"::boolean
5
, ALTER COLUMN "countryNameStd" TYPE text
6
;
7

    
8
ALTER TABLE "newWorldCountries" ADD UNIQUE ("countryNameStd");
9
ALTER TABLE "newWorldCountries" ADD UNIQUE ("isoCode");
(2-2/3)