root/inputs/newWorld/geoscrub.schema.~.changes.sql @ 9288
1 | 6017 | aaronmk | ALTER TABLE "newWorldCountries" |
---|---|---|---|
2 | 6527 | aaronmk | ALTER COLUMN "isoCode" TYPE text |
3 | , ALTER COLUMN "isNewWorld" DROP DEFAULT |
||
4 | 6107 | aaronmk | , ALTER COLUMN "isNewWorld" TYPE boolean USING "isNewWorld"::boolean |
5 | 6108 | aaronmk | , ALTER COLUMN "countryNameStd" TYPE text |
6 | 6107 | aaronmk | ;
|
7 | 6528 | aaronmk | |
8 | ALTER TABLE "newWorldCountries" ADD UNIQUE ("countryNameStd"); |
||
9 | ALTER TABLE "newWorldCountries" ADD UNIQUE ("isoCode"); |