root/inputs/newWorld/geoscrub.schema.~.changes.sql @ 8062
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"); |