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