Project

General

Profile

1 6017 aaronmk
ALTER TABLE "newWorldCountries" ADD UNIQUE ("countryNameStd");
2 6527 aaronmk
ALTER TABLE "newWorldCountries" ADD UNIQUE ("isoCode");
3 6017 aaronmk
4
ALTER TABLE "newWorldCountries"
5 6527 aaronmk
  ALTER COLUMN "isoCode" TYPE text
6
, ALTER COLUMN "isNewWorld" DROP DEFAULT
7 6107 aaronmk
, ALTER COLUMN "isNewWorld" TYPE boolean USING "isNewWorld"::boolean
8 6108 aaronmk
, ALTER COLUMN "countryNameStd" TYPE text
9 6107 aaronmk
;