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